items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2011-07-06-84642823-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 |
---|---|---|---|---|---|---|---|
1e87fc91514b3b6ff97ad9d7d3e12d624eedc280 | Name of donor: Royal Opera House | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2011-07-06-84642823-10357-0 |
ec8eaa9eb65421274dd149d173816e4ba67b6bec | Address of donor : Covent Garden, London WC2E 9DD | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2011-07-06-84642823-10357-0 |
8c71368c99bacaee29edcf815ce61ce4597f0281 | Amount of donation or nature and value if donation in kind: tickets for ballet; value £2,000 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2011-07-06-84642823-10357-0 |
7aba6ca6b1e1f3f67f2baab05d1f39ed2efc8105 | Date of receipt of donation: 28 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 3 | 2011-07-06-84642823-10357-0 |
f71b97ac076d2b6e575c1aef5ad9ba196ccf763b | Date of acceptance of donation: 28 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2011-07-06-84642823-10357-0 |
60cdab68527a1884c178b2d6dc586a353962a0cc | Donor status: charity | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 5 | 2011-07-06-84642823-10357-0 |
dc128be63714e355193c66c86834ce5d8e39e006 | (Registered 1 April 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-06 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2011-07-06-84642823-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");