items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2021-11-01-10057ffd-25579-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
4ee9dadb641ba81035b1e533953900c39ce4b86b | Payments received from St George's Hospital NHS Trust, Blackshaw Road, London SW17 0QT, for my work as a doctor: | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 0 | 2021-11-01-10057ffd-25579-0 | |
947360c5ad62a4f4c38f882eaff9ba64722fdd2c | 9 September 2020, received £638.16 for shift worked on 8 August 2020. Hours: 10 hrs. (Registered 05 October 2020; updated 11 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 1 | 2021-11-01-10057ffd-25579-0 | |
85f932d2fceb90319f1319b8bb0e45e27433d4d4 | 16 September 2020, received £638.16 for shift worked on 6 September 2020. Hours: 10 hrs. (Registered 05 October 2020; updated 11 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 2 | 2021-11-01-10057ffd-25579-0 | |
ec85ea35ef311f3bec2e6f0b787b697e93879e53 | 21 October 2020, received £369.82. Hours: 6 hrs. (Registered 29 October 2020; updated 11 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 3 | 2021-11-01-10057ffd-25579-0 | |
fb70858e3dd9d8111b317c5ba6cbf0e151a88599 | Payment of £638.78 expected for a shift on 17 October 2020. Hours: 10 hrs. (Registered 11 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 4 | 2021-11-01-10057ffd-25579-0 | |
386548f943f49d4f05e1cfc6f3e366f2a547bbf7 | Payment of £638.78 expected for a shift on 1 November 2020. Hours: 10 hrs. (Registered 11 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 5 | 2021-11-01-10057ffd-25579-0 | |
2ff86b28719ded8975f6cc9962cf12e88a213cec | 26 November 2020, received £571.54 for shift worked on 11 November 2020. Hours: 9 hrs. (Registered 30 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 6 | 2021-11-01-10057ffd-25579-0 | |
897f00344b3d7f3142b47f0160c7e5896fe0cbbd | 9 December 2020, received £532.38. Hours: 10 hrs. (Registered 05 January 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 7 | 2021-11-01-10057ffd-25579-0 | |
9092c1108c85fe5bc785e48c428fe6262a641491 | 16 December 2020, received £571.54. Hours: 9 hrs. (Registered 05 January 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 8 | 2021-11-01-10057ffd-25579-0 | |
bb70a8d0aaea8c736981b7bf24cbc09a1a3b864a | 6 January 2021, received £672.40. Hours: 10.5 hrs. (Registered 13 January 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 9 | 2021-11-01-10057ffd-25579-0 | |
37965f72d5aaf21f73c4609b6a0aeb35a74151d6 | 20 January 2021, received £622.40 for a shift worked on 4 January 2021. Hours worked: 10 hrs. (Registered 04 February 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 10 | 2021-11-01-10057ffd-25579-0 | |
95908b0112bba6fe39cb028107ed71792c53f1d6 | 20 January 2021, received £670.24 for a shift worked on 9 January 2021. Hours: 10 hrs. (Registered 04 February 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 11 | 2021-11-01-10057ffd-25579-0 | |
c8fceaf48c9f4c6ad377478e07438c85f067c606 | 3 February 2021, received £670.24 for a shift worked on 23 January 2021. Hours: 10 hrs. (Registered 04 February 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 12 | 2021-11-01-10057ffd-25579-0 | |
8e7bca9906335c30f2346f29f4b671d3d1fb8df5 | 10 February 2021, received £268.96. Hours: 4 hrs. (Registered 03 March 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 13 | 2021-11-01-10057ffd-25579-0 | |
2f2f9857efc8f980b117ca47f961202b88df7296 | 17 February 2021, received £672.40. Hours: 10 hrs. (Registered 03 March 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 14 | 2021-11-01-10057ffd-25579-0 | |
0c4c9b945686144b58da445bd385c1699afa6854 | 3 March 2021, received £700. Hours: 10 hrs. (Registered 03 March 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 15 | 2021-11-01-10057ffd-25579-0 | |
02b9dc240b897a727b99c8ea3265c7316d584797 | 24 March 2021, received £700. Hours: 10 hrs. (Registered 14 April 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 16 | 2021-11-01-10057ffd-25579-0 | |
f5b516f335cb22462b27dd9227f0ca28d5b134df | 30 June 2021, received £622. Hours: 10 hrs. (Registered 30 June 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 17 | 2021-11-01-10057ffd-25579-0 | |
99f79e591540215809d70eec729ec71f089d782d | 21 July 2021, received £570 for a shift worked on 9 July 2021. Hours worked: 10 hrs. (Registered 17 August 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 18 | 2021-11-01-10057ffd-25579-0 | |
b799ec616be24bffab71f1002dd5f847a1225c5e | 21 July 2021, received £665 for shift worked on 11 July 2021. Hours: 10 hrs. (Registered 17 August 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 19 | 2021-11-01-10057ffd-25579-0 | |
57349dc80144dd4280f4422638bb3cbc426feb89 | 28 July 2021, received £585. Hours: 10.25 hrs. (Registered 17 August 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 20 | 2021-11-01-10057ffd-25579-0 | |
1d91ef3354ae5620e04ab2a92f9b951bfcdf650a | 4 August 2021, received £585. Hours: 10.25 hrs. (Registered 17 August 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 21 | 2021-11-01-10057ffd-25579-0 | |
9ab831059786a65ffa9f744230d97fb403f47b12 | 11 August 2021, received £600 for a shift worked on 27 July 2021. Hours: 10 hrs. (Registered 17 August 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 22 | 2021-11-01-10057ffd-25579-0 | |
b8b294e55fd98f6e2df71d62ac86cd7f6d7d5937 | 11 August 2021, received £435 for a shift worked on 30 July 2021. Hours: 8 hrs. (Registered 17 August 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 23 | 2021-11-01-10057ffd-25579-0 | |
7a2e0628a78dac45a3f1d98962e23f9cfbad0eb5 | Payments from the GP Surgery, 6-10 St George's Road, Wimbledon SW19 4DP, for assisting with holiday cover for GPs on annual leave: | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 24 | 2021-11-01-10057ffd-25579-0 | |
f4ce0f7c513599df1ee15587b3d129929909c054 | 14 October 2020, received £1,105 for four shifts on 6, 13, 14 and 27 August 2020. Hours: 18 hrs. (Registered 29 October 2020; updated 11 November 2020) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 25 | 2021-11-01-10057ffd-25579-0 | |
e69329fe48f53712d54a225a548db8f52d706ca5 | 6 May 2021, received £572. Hours: 10 hrs. (Registered 03 June 2021) | Employment and earnings 10057ffd | 2021-11-01 | Rosena Allin-Khan uk.org.publicwhip/person/25579 | 26 | 2021-11-01-10057ffd-25579-0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE items ( hash VARCHAR(40) NOT NULL, item TEXT, category_id TEXT, date TEXT, member_id TEXT, person_id TEXT, sort_order INTEGER, record_id TEXT, PRIMARY KEY (hash), FOREIGN KEY ("category_id") REFERENCES [categories](id), FOREIGN KEY ("member_id") REFERENCES [members](id), FOREIGN KEY ("person_id") REFERENCES [people](id) ); CREATE INDEX items_date ON items("date"); CREATE INDEX items_category_id ON items("category_id"); CREATE INDEX items_member_id ON items("member_id"); CREATE INDEX items_person_id ON items("person_id"); CREATE INDEX items_record_id ON items("record_id");