items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2014-02-03-84642823-24901-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 |
---|---|---|---|---|---|---|---|
b1a940d688285e2757d26a60fddca43e306fd3d9 | Amount of donation or nature and value if donation in kind: two tickets to Glastonbury Festival; value £1,340 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 2 | 2014-02-03-84642823-24901-0 |
6077f683c2c0a4c66e58e054c0cd92b8f69b079e | Date of receipt of donation: 26 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 3 | 2014-02-03-84642823-24901-0 |
376dd0fe14383be809deb25373d911c62fb9e766 | Date of acceptance of donation: 29 and 30 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 4 | 2014-02-03-84642823-24901-0 |
17fe23b4d05c2203a0cd9de62c9db89c9558623f | (Registered 26 July 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 6 | 2014-02-03-84642823-24901-0 |
91e9e79ec8d6eed26b82be43ddeb7d9da2e9b2d1 | Name of donor: PRS for Music Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 7 | 2014-02-03-84642823-24901-0 |
fd6f8b18b742921b81deace92d983caacbcee773 | Address of donor : 29-33 Berners St, London W1T 3AB | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 8 | 2014-02-03-84642823-24901-0 |
79a2cd511004c9f8c2205215f13a7031ce9436fe | Amount of donation or nature and value if donation in kind: dinner and concert for two people at O2 Arena, total value £400 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 9 | 2014-02-03-84642823-24901-0 |
a513a05ca4806e24b8416a65a6843697b50df63b | Date of receipt of donation: 24 September 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 10 | 2014-02-03-84642823-24901-0 |
78120177a3513762ab11c609f35e2919462b90e7 | Date of acceptance of donation: 24 September 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 11 | 2014-02-03-84642823-24901-0 |
30982bf1759cf7cbb2ce56eba06ab3212ab87544 | Donor status: company, registration 3444246 | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 12 | 2014-02-03-84642823-24901-0 |
41945e16a9f70b8163427eb8760f075dd851527f | (Registered 2 October 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-02-03 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 13 | 2014-02-03-84642823-24901-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");