items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2017-08-29-10057ffd-24857-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 |
---|---|---|---|---|---|---|---|
674fc6f28faab71251d302f1d4dc0a0302464a19 | Fiona Bruce and Co LLP; solicitors practice. Address: Justice House, 3 Grappenhall Rd, Stockton Heath, Warrington WA4 2AH. Consultancy fees received: | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 0 | 2017-08-29-10057ffd-24857-0 | |
cb3d1727e671d50ba0adb77d8896c22e0c375856 | 31 July 2016, received £34,536.72. Hours: 6 hrs. (Registered 31 August 2016) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 1 | 2017-08-29-10057ffd-24857-0 | |
04e53b5a3232f9e761ff7d5e174a1c76f4d81bd0 | 31 August 2016, received £5,000. Hours: 10 hrs. (Registered 13 September 2016) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 2 | 2017-08-29-10057ffd-24857-0 | |
76fbe7b7237d79b1344f2a5d594a24565e05a68b | 30 September 2016, received £5,000. Hours: 8 hrs. (Registered 26 October 2016) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 3 | 2017-08-29-10057ffd-24857-0 | |
0006476b3dfa919331f0c3d7cbd2fd223114251c | 31 October 2016, received £5,000. Hours: 8 hrs. (Registered 28 November 2016) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 4 | 2017-08-29-10057ffd-24857-0 | |
dc1e270f20ae45301aff219e019b7d1bafb6bd2a | 30 November 2016, received £5,000. Hours: 6 hrs. (Registered 09 January 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 5 | 2017-08-29-10057ffd-24857-0 | |
9b1f2ddeb49330704888db673c768b35117cb146 | 31 December 2016, received £5,000. Hours: 6 hrs. (Registered 27 January 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 6 | 2017-08-29-10057ffd-24857-0 | |
dbabd7ba8b237d58cac57ce196c27257543c7248 | 31 January 2017, received £67,511.12. Hours: 9 hrs. (Registered 15 February 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 7 | 2017-08-29-10057ffd-24857-0 | |
93c58170b77c044f96909fb182fecfdd3444f7c6 | 28 February 2017, received £5,000. Hours: 9 hrs. (Registered 24 March 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 8 | 2017-08-29-10057ffd-24857-0 | |
3a822a5bb42a13189b55d0e9c71b91005402138f | 31 March 2017, received £5,000. Hours: 13 hrs. (Registered 18 April 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 9 | 2017-08-29-10057ffd-24857-0 | |
660e55de665f21718d9fac3e75d154d8f5fff205 | 30 April 2017, received £5,000. Hours: 7 hrs. (Registered 02 May 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 10 | 2017-08-29-10057ffd-24857-0 | |
3873974c9be9908346b3bce4febf9919202e0f98 | 30 May 2017, received £5,000. Hours: 7 hrs. (Registered 15 June 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 11 | 2017-08-29-10057ffd-24857-0 | |
702281e17fd8c20afbd05500a7af3d9ca07c6b7f | 30 June 2017, received £5,000. Hours: 8 hrs. (Registered 27 July 2017) | Employment and earnings 10057ffd | 2017-08-29 | Fiona Bruce uk.org.publicwhip/person/24857 | 12 | 2017-08-29-10057ffd-24857-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");