items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2017-01-09-70b64e89-24850-0" sorted by record_id descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▲ |
---|---|---|---|---|---|---|---|
6d8a774495577c21c3cdc1b49c344e53c870bd8c | Name of donor: Trevor Chinn Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 21 October 2015 Date accepted: 21 October 2015 Donor status: individual (Registered 30 November 2015; updated 26 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 0 | 2017-01-09-70b64e89-24850-0 | |
1a161313b905ca5ae4cb46be87d8e46a376f110e | Name of donor: Daniel Beard Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 17 November 2015 Date accepted: 17 November 2015 Donor status: individual (Registered 22 December 2015; updated 26 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 1 | 2017-01-09-70b64e89-24850-0 | |
cedc15d4aa50b66db3b5a7acf4a4e6a5db123d84 | Name of donor: Peter Coates Address of donor: private Amount of donation or nature and value if donation in kind: £40,000 Date received: 7 December 2015 Date accepted: 7 December 2015 Donor status: individual (Registered 22 December 2015; updated 26 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 2 | 2017-01-09-70b64e89-24850-0 | |
05d7b9629fe25861ccb3cedf852606a4e4006ee0 | Name of donor: Lord David Sainsbury Address of donor: private Amount of donation or nature and value if donation in kind: £20,000 Date received: 17 December Date accepted: 17 December Donor status: individual (Registered 18 January 2016; updated 26 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 3 | 2017-01-09-70b64e89-24850-0 | |
c6f72789a34e59b3904c414eb8024980acc5e689 | Name of donor: Tim Allen Address of donor: private Amount of donation or nature and value if donation in kind: £15,000 Date received: 1 April 2016 Date accepted: 1 April 2016 Donor status: individual (Registered 26 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 4 | 2017-01-09-70b64e89-24850-0 | |
00a3d714d7c0d3a2df90cc5a60c248ad2cb9aaad | Name of donor: Alison Wedgwood Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 Date received: 14 June Date of accepted: 14 June Donor status: individual (Registered 07 July 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 5 | 2017-01-09-70b64e89-24850-0 | |
69e8b05148b99ffe3f9b4aa68994f8c10cab5af7 | Name of donor: Sir Trevor Chinn Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Date received: 24 November 2016 Date accepted: 24 November 2016 Donor status: individual (Registered 22 December 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-09 | Tristram Hunt uk.org.publicwhip/person/24850 | 6 | 2017-01-09-70b64e89-24850-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");