items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2013-07-29-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 |
---|---|---|---|---|---|---|---|
f987df5b9451bd9918eb4500ad02dc23f6482a39 | Name of donor: Royal Opera House | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 0 | 2013-07-29-84642823-11858-0 |
115c7ca78c02891ed1411893f99b6223714f2354 | Address of donor: Covent Garden, London WC2E 9DD | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 1 | 2013-07-29-84642823-11858-0 |
edda868519618ed56b59efe94008b7b879072ee8 | 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-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 2 | 2013-07-29-84642823-11858-0 |
061642714b67ca56a1fd9b9b043c0a809adf39ed | Date of receipt of donation: 12 September 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 3 | 2013-07-29-84642823-11858-0 |
c5ad49f5625553339bbce5b3c3422e3856c07cd4 | 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-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 4 | 2013-07-29-84642823-11858-0 |
76d0e01cc79a7996c6244bbb58a8a218c5f0caa4 | Donor status: charity and limited company, registration no 480523 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 5 | 2013-07-29-84642823-11858-0 |
01131488c80b4be21fff2bb124ccdcca9f3cbfad | (Registered 30 October 2012) | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 6 | 2013-07-29-84642823-11858-0 |
3ac72e30edb76ad237736ab315c9f6a514d6d353 | Name of donor: This Is Global Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 7 | 2013-07-29-84642823-11858-0 |
4435b48d4ba06e8fb14b3bc79ae5e1d42b4a700b | Address of donor: 30 Leicester Square, London WC2H 7LA | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 8 | 2013-07-29-84642823-11858-0 |
0767bb2316e6a1e1b4510588aa8ddf3b866fb791 | 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-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 9 | 2013-07-29-84642823-11858-0 |
2b465fd1d65f05c72f3f7bc50a51748f2fb9322c | Date of receipt of donation: 9 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 10 | 2013-07-29-84642823-11858-0 |
e90267127a3a6efc6057918770e185a8aa3e5a25 | Date of acceptance of donation: 9 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 11 | 2013-07-29-84642823-11858-0 |
42673574f74b2bd219ff7396010679b0f7ba6966 | Company, registration no 06251684 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 12 | 2013-07-29-84642823-11858-0 |
a931d341cbcbc1a9e4269be587d6f8f0feda3352 | (Registered 19 June 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Michael Gove uk.org.publicwhip/member/40593 | Michael Gove uk.org.publicwhip/person/11858 | 13 | 2013-07-29-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");