items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2013-08-27-84642823-11858-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 |
---|---|---|---|---|---|---|---|
fd49d3a6e9fa584f608eaecf34851e6c42e0c494 | Name of donor: Royal Opera House | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 0 | 2013-08-27-84642823-11858-0 |
544d109d98551d27aba99207c21d8772e329e52d | Address of donor: Covent Garden, London WC2E 9DD | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 1 | 2013-08-27-84642823-11858-0 |
350b236ff4554791f584cfe50f5e4d58ecbbe736 | Amount of donation or nature and value if donation in kind: 4 tickets (one for each opera of the Ring cycle) with a total value of £888 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 2 | 2013-08-27-84642823-11858-0 |
016bdee7453b8ab5b6ba456da7a5abbfab1eff2f | Date of receipt of donation: 12 September 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 3 | 2013-08-27-84642823-11858-0 |
aba21ba6bd9052ee92001833895ca93d639916ba | Date of acceptance of donation: 24 September 2012; 26 September 2012; 21 October 2012; 24 October 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 4 | 2013-08-27-84642823-11858-0 |
4a09f71fa3f9528476cc7874ed9101ffd8d7d638 | Donor status: charity and limited company, registration no 480523 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 5 | 2013-08-27-84642823-11858-0 |
6026d4dbc0fec25167db90b0dc732c7961814545 | (Registered 30 October 2012) | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 6 | 2013-08-27-84642823-11858-0 |
b772c3cbfac112b3a084ada6588014d11f2db7dc | Name of donor: This Is Global Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 7 | 2013-08-27-84642823-11858-0 |
3023e3cb7fa54d4dbc261c64887874a5c2ee1681 | Address of donor: 30 Leicester Square, London WC2H 7LA | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 8 | 2013-08-27-84642823-11858-0 |
97eca1dd7b987c93daa42c49e94b0880206f242b | Amount of donation or nature and value if donation in kind: 4 tickets to Capital FM Summertime Ball with a total value of £1,400 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 9 | 2013-08-27-84642823-11858-0 |
5bcba330ff348c86381bb2907a178d4543872703 | Date of receipt of donation: 9 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 10 | 2013-08-27-84642823-11858-0 |
21cdca9d1bf7a576a2a78572cca2c61c8973b88b | Date of acceptance of donation: 9 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 11 | 2013-08-27-84642823-11858-0 |
928ce0e9302ce8478442ae4ae63c172eaa9ccad3 | Company, registration no 06251684 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 12 | 2013-08-27-84642823-11858-0 |
f8ee2f36121b8a0f44a5310fd5cc54a1ec6be2fc | (Registered 19 June 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 13 | 2013-08-27-84642823-11858-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");