items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2018-05-14-70b64e89-24879-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 |
---|---|---|---|---|---|---|---|
3ae981a4af568bd3eb5e659b330abc4446835529 | Name of donor: Gallagher Developments Address of donor: Gallagher Way, Gallagher Business Park, Warwick CV34 6AF Amount of donation or nature and value if donation in kind: £20,000 Date received: 25 April 2017 Date accepted: 25 April 2017 Donor status: company, registration 00937417 (Registered 02 May 2017) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 0 | 2018-05-14-70b64e89-24879-0 | |
9f4a65d3d62d751b2eb59fecf4ec1ddec513a048 | Name of donor: Mrs Shadi Ritchie Address of donor: private Amount of donation or nature and value if donation in kind: £10,000 Date received: 1 June 2017 Date accepted: 5 July 2017 Donor status: individual (Registered 05 July 2017) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 1 | 2018-05-14-70b64e89-24879-0 | |
c244c7e93b85d05cf36ca11cf777a587b3c8b241 | Name of donor: Alexander Temerko Address of donor: private Amount of donation or nature and value if donation in kind: £7,500 Date received: 15 November 2017 Date accepted: 16 November 2017 Donor status: individual (Registered 11 December 2017) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 2 | 2018-05-14-70b64e89-24879-0 | |
4ffd3a6935792e86b591854bcdad11bf7a890389 | Name of donor: Allfunds Bank, S.A. Address of donor: Registro Mercantil De Madrid – Book 15.897-Section 8 Paper M-268 Amount of donation or nature and value if donation in kind: £2,000 Date received: 13 November 2017 Date accepted: 16 November 2017 Donor status: company, registration FC026760 (Registered 11 December 2017) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 3 | 2018-05-14-70b64e89-24879-0 | |
0c7704e04b8d681c77fe5a5bf7862fbf3b0d424c | Name of donor: Countrywide Developments Ltd Address of donor: Gallagher House, Gallagher Way, Gallagher Business Park, Warwick CV34 6AF Amount of donation, or nature and value if donation in kind: £2,500 Date received: 22 February 2018 Date accepted: 28 February 2018 Donor status: company, registration 2865543 (Registered 14 March 2018) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 4 | 2018-05-14-70b64e89-24879-0 | |
35f4f199adea26a182fe186cf7d84a210741db7e | Name of donor: Pietas Ltd Address of donor: 9 Great Chesterford Court, Great Chesterford, Saffron Walden CB10 1PF Amount of donation, or nature and value if donation in kind: £3,000 sponsorship for dinner Date received: 20 March 2018 Date accepted: 20 March 2018 Donor status: company, registration 03988618 (Registered 29 March 2018) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 5 | 2018-05-14-70b64e89-24879-0 | |
30e080faa5a64bc044ca5cf20cb16f65cea49a56 | Name of donor: Marc Pennick Address of donor: private Amount of donation, or nature and value if donation in kind: £2,000 Date received: 5 April 2018 Date accepted: 5 April 2018 Donor status: individual (Registered 17 April 2018) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 6 | 2018-05-14-70b64e89-24879-0 | |
0074a6028aad796990e8d39ee6117d95cda2a225 | Name of donor: Skeol Ltd Address of donor: Eldo House, Kempson Way, Suffolk Business Park, Bury St Edmunds IP32 7AR Amount of donation, or nature and value if donation in kind: £2,500 Date received: 6 April 2018 Date accepted: 6 April 2018 Donor status: company, registration 09813058 (Registered 30 April 2018) | (b) Any other support not included in Category 2(a) 70b64e89 | 2018-05-14 | Brandon Lewis uk.org.publicwhip/person/24879 | 7 | 2018-05-14-70b64e89-24879-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");