items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2017-01-23-70b64e89-10357-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2eea682d1ef20c116a0331dc036c396f265a9032 | Name of donor: Sir Trevor Chinn Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 to support my mayoral campaign Date received: 21 March 2016 Date accepted: 21 March 2016 Donor status: individual (Registered 23 March 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2017-01-23-70b64e89-10357-0 | |
fe9c0c1dd32a66ae8a4d8771a8ae6686d9b06384 | Name of donor: Len Collinson Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 to support my mayoral campaign Date received: 19 April 2016 Date accepted: 19 April 2016 Donor status: individual (Registered 28 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2017-01-23-70b64e89-10357-0 | |
54a24ddca07ee19128e7748c78dcf95c444f4dfd | Name of donor: Sir Trevor Chinn Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 to support my mayoral campaign Date received: 22 April 2016 Date accepted: 22 April 2016 Donor status: individual (Registered 28 April 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2017-01-23-70b64e89-10357-0 | |
e64f5b9596a5cf4a483451c6173d941eae2f1762 | Name of donor: Sir Trevor Chinn Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 to support my mayoral campaign Date received: 16 May 2016 Date accepted: 16 May 2016 Donor status: individual (Registered 31 May 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2017-01-23-70b64e89-10357-0 | |
33e2cb4f8a836d6f9c0e7ce22b77670094a16259 | Name of donor: Dov Hamburger Address of donor: private Amount of donation or nature and value if donation in kind: £2,500 to support my mayoral campaign Date received: 26 May 2016 Date accepted: 26 May 2016 Donor status: individual (Registered 16 June 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2017-01-23-70b64e89-10357-0 | |
6921877be2666035879472b6b0f8dba528233f3a | Name of donor: Herzl Hamburger Address of donor: private Amount of donation or nature and value if donation in kind: £2,500 to support my mayoral campaign Date received: 26 May 2016 Date accepted: 26 May 2016 Donor status: individual (Registered 16 June 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2017-01-23-70b64e89-10357-0 | |
a7d8236b3714c8efd59bf9f34059a52b1e456846 | Name of donor: Maurice Watkins Address of donor: private Amount of donation or nature and value if donation in kind: £3,000 to support my mayoral campaign Date received: 10 June 2016 Date accepted: 10 June 2016 Donor status: individual (Registered 16 June 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2017-01-23-70b64e89-10357-0 | |
eca5829631b2fe9f2cc0c65eb699850c31f60fec | Name of donor: Green Bay Capital Ltd Address of donor: 2nd Floor, 145-157 St John Street, London EC1V 4PY Amount of donation or nature and value if donation in kind: £5,000 to support my mayoral campaign Date received: 11 July 2016 Date accepted: 11 July 2016 Donor status: company, registration 07803392 (Registered 21 July 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2017-01-23-70b64e89-10357-0 | |
45aefd517db4815e98839c2794f9475918afedf6 | Name of donor: Michael Edelson Address of donor: private Amount of donation or nature and value if donation in kind: £3,000 towards my mayoral campaign Date received: 7 July 2016 Date accepted: 7 July 2016 Donor status: individual (Registered 25 July 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2017-01-23-70b64e89-10357-0 | |
10e2697505f17a6b8e20ae4d55d2c22c92cb3de3 | Name of donor: Jon Manson Address of donor: private Amount of donation or nature and value if donation in kind: £2,000 towards my mayoral campaign Date received: 8 July 2016 Date accepted: 8 July 2016 Donor status: individual (Registered 25 July 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2017-01-23-70b64e89-10357-0 | |
824a05d81f77ff503cd892ee1f3299fe3829c0f1 | Name of donor: David Mond Address of donor: private Amount of donation or nature and value if donation in kind: £3,000 towards my mayoral campaign Date received: 24 May 2016 Date accepted: 25 July 2016 Donor status: individual (Registered 25 July 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2017-01-23-70b64e89-10357-0 | |
15fd7de7c725019615fc5663666be1b3e878ed43 | Name of donor: Simon Margolis Address of donor: private Amount of donation or nature and value if donation in kind: £3,000 towards my mayoral campaign Date received: 28 July 2016 Date accepted: 28 July 2016 Donor status: individual (Registered 05 August 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 11 | 2017-01-23-70b64e89-10357-0 | |
55165f5db8c2ae7eeba9934457cd650920402267 | Name of donor: Sir David Garrard Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 towards my mayoral campaign Date received: 29 September 2016 Date accepted: 29 September 2016 Donor status: individual (Registered 01 November 2016) | (b) Any other support not included in Category 2(a) 70b64e89 | 2017-01-23 | Ivan Lewis uk.org.publicwhip/person/10357 | 12 | 2017-01-23-70b64e89-10357-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");