items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2010-09-06-8f616a6e-24849-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 |
---|---|---|---|---|---|---|---|
07706dd01d0a423220428a5c29915aa88b360507 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 0 | 2010-09-06-8f616a6e-24849-0 |
9ea9b97db1e23c493911bf1cdf5d630517265475 | Name of donor: Mr Charles H Vero | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 1 | 2010-09-06-8f616a6e-24849-0 |
cfaacbcead18413b93b1ff36e6889828b3dca035 | Address of donor: private | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 2 | 2010-09-06-8f616a6e-24849-0 |
63cde034c38feff0eba2f349624a62f2ce6cc26b | Amount of donation or nature and value if donation in kind: £4,000 | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 3 | 2010-09-06-8f616a6e-24849-0 |
a9b2f5d3d3b5894a939163289b6f6aa561ccfcd9 | Donor status: individual | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 4 | 2010-09-06-8f616a6e-24849-0 |
fbe8c5d20f75be8b2c2fd76d584a90dee4344ccb | Name of donor: Stalbury Trustees | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 6 | 2010-09-06-8f616a6e-24849-0 |
76255f9bf5b93ad883f8d89b902a390d45930ffb | Address of donor: 31 Hill Street London W1J 5LS | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 7 | 2010-09-06-8f616a6e-24849-0 |
44539234076b53786f47795455ab88ad3d74faac | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 8 | 2010-09-06-8f616a6e-24849-0 |
0a1a7674bbb810286ff75d62227a7b54d8cb19de | Donor status: company No 01430799 | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 9 | 2010-09-06-8f616a6e-24849-0 |
9cac72d7884b96ff60bb566c722343c73ea79e44 | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2010-09-06 | Dan Byles uk.org.publicwhip/member/40449 | Dan Byles uk.org.publicwhip/person/24849 | 10 | 2010-09-06-8f616a6e-24849-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");