items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-01-30-84642823-24733-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 |
---|---|---|---|---|---|---|---|
fc63e967819b208cbc515c93a569cf90ef3d2162 | Name of donor: NFL UK Limited | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 0 | 2012-01-30-84642823-24733-0 |
6679332c9de3246481a8258f1100c9f1dab73729 | Address of donor: 1 Hills Place, London W1F 7SA | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 1 | 2012-01-30-84642823-24733-0 |
0024570b10dc4124ca10fc42811df620e95abb2c | Amount of donation or nature and value of donation in kind: two tickets to the NFL International Series Game at Wembley and hospitality: total value approximately £850 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 2 | 2012-01-30-84642823-24733-0 |
377537a9d02865db461083be7cd9fc1470befa11 | Date of receipt of donation: 23 October 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 3 | 2012-01-30-84642823-24733-0 |
d368911ba6894ba02cc8c24a29b56cd079431d1c | Date of acceptance of donation: 23 October 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 4 | 2012-01-30-84642823-24733-0 |
73e10c59f05038eb9ace90b37ff49331c1cfb644 | Donor status: Company; registration number 07736687 | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 5 | 2012-01-30-84642823-24733-0 |
8e3f60ada22d56ace38923645b45bf344be76cdf | (Registered 14 November 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-01-30 | Gregg McClymont uk.org.publicwhip/member/40193 | Gregg McClymont uk.org.publicwhip/person/24733 | 6 | 2012-01-30-84642823-24733-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");