items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2013-07-08-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 |
---|---|---|---|---|---|---|---|
004e6d529bcb1b121bc2dfa2ff5e8eda7332972e | Name of donor: Royal Opera House | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 0 | 2013-07-08-84642823-11858-0 |
55a5486e3fbf825e10491a0aa81ec271d04b7b87 | Address of donor: Covent Garden, London WC2E 9DD | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 1 | 2013-07-08-84642823-11858-0 |
fb11c8acc1aaca081463705edf97193c47b58cde | 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-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 2 | 2013-07-08-84642823-11858-0 |
0a12de1e4ede7fde64ceebc988a6407151755ef9 | Date of receipt of donation: 12 September 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 3 | 2013-07-08-84642823-11858-0 |
6fc292762d77ca362b0c45e7cc5d8956961e9d0f | Date of acceptance of donation: 24 September 2012; 26 September 2012; 21 October 2012; 24 October 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 4 | 2013-07-08-84642823-11858-0 |
74085c44de0428ad8e7ba180a4bdea62a9d33d0c | Donor status: charity and limited company, registration no 480523 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 5 | 2013-07-08-84642823-11858-0 |
79d9c597ed8b5a867c424329aa59bbcb35455867 | (Registered 30 October 2012) | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 6 | 2013-07-08-84642823-11858-0 |
7d9bb1941812cb1921049d3b5d7f17fe3449e530 | Name of donor: This Is Global Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 7 | 2013-07-08-84642823-11858-0 |
477901d2d6a5ccdd5436c658bc0261e59122d306 | Address of donor: 30 Leicester Square, London WC2H 7LA | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 8 | 2013-07-08-84642823-11858-0 |
d0875998b63030b4a535a2230224d718f437570b | 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-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 9 | 2013-07-08-84642823-11858-0 |
f2284b691848334e9fd6dc4e1771195d321f419f | Date of receipt of donation: 9 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 10 | 2013-07-08-84642823-11858-0 |
f0dab89ccdf73678d8d02d5612a2d45d34d1c8b8 | Date of acceptance of donation: 9 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 11 | 2013-07-08-84642823-11858-0 |
d0873506bcafa4f06f3746cdb06dbb6a87a83984 | Company, registration no 06251684 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 12 | 2013-07-08-84642823-11858-0 |
e1004b27fa485aa5cea01353bc52d1fdc6afffa0 | (Registered 19 June 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 13 | 2013-07-08-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");