items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2019-02-04-10057ffd-10484-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 |
---|---|---|---|---|---|---|---|
d65a6a8baf85f24dbc2f4696b9f4a7d6b6667e76 | Payments from Drew University, 99 Great Russell Street, London WC1B 3LA: | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 0 | 2019-02-04-10057ffd-10484-0 | |
6581cb4cb9d61781c082cec04a96a37bf42d024e | 31 October 2018 received £870 for a series of seminars and debates, acting as a political co-ordinator for the autumn semester. Hours: 16 hrs. (Registered 01 November 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 1 | 2019-02-04-10057ffd-10484-0 | |
e8c6a991c6b3f9530bd515ee6efa315c366ccb82 | Payments from DODS Group plc, Level 11, The Shard, 32 London Bridge Street, London SE1 9SG, for speaking at Westminster Explained events. All payments donated to charity. (Registered 15 May 2015; updated 16 March 2017) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 2 | 2019-02-04-10057ffd-10484-0 | |
e9ec155afda8503ffac6f96eb2f6071b63a5ac0c | 1 February 2018, payment of £150 for an event on 29 January 2018. Hours: 2 hrs. (Registered 14 February 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 3 | 2019-02-04-10057ffd-10484-0 | |
a84a4a2195190db00441e0ad548f9659803617d4 | 3 April 2018, payment of £150 for an event on 19 March 2018. Hours: 2 hrs. (Registered 11 April 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 4 | 2019-02-04-10057ffd-10484-0 | |
5898627b51b00c8c9a2cbcd551f8587cd5ee4dcd | 8 August 2018, payment of £300 for two events. Hours: 4 hrs in total. (Registered 09 August 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 5 | 2019-02-04-10057ffd-10484-0 | |
a85548c5e9b7b69b6a25323e3043983a5896c39c | 28 August 2018, received £300 for two sessions on 28 June and 5 July 2018. Hours: 4 hrs in total. (Registered 29 August 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 6 | 2019-02-04-10057ffd-10484-0 | |
eaa4137c35141201d9b8e1ff6c58a03fbba858fa | 9 October 2018, received £150 for an event on 20 September 2018. Hours: 2 hrs. (Registered 17 October 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 7 | 2019-02-04-10057ffd-10484-0 | |
7b474c4a48527ff730f66c3d6dded3765a3bceac | 14 November 2018, received £150 for an event on 11 October 2018. Hours: 2 hrs. (Registered 15 November 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 8 | 2019-02-04-10057ffd-10484-0 | |
cb4d82eecd0d37a49534943d7f051979ac3026d8 | 14 November 2018, received £150 for an event on 30 October 2018. Hours: 2 hrs. (Registered 15 November 2018) | Employment and earnings 10057ffd | 2019-02-04 | Steve Pound uk.org.publicwhip/person/10484 | 9 | 2019-02-04-10057ffd-10484-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");