items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2011-05-03-8f616a6e-10001-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 |
---|---|---|---|---|---|---|---|
6d0e42619fad514620dea7d142b327f2bc03a2fc | Support in the capacity as an MP | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2011-05-03-8f616a6e-10001-0 |
1c51cede80ab9378fd5ae8682b78357ca6274945 | Donation to support my campaign for leadership of the Labour Party: | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2011-05-03-8f616a6e-10001-0 |
10a5ba059f9b2c36a6468393023ceb2abacbe374 | Name of donor: BM Creative Management Ltd (Media) | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2011-05-03-8f616a6e-10001-0 |
0a71c80104badacff4f6ebbb1315ca5eec25f506 | Address of donor: 4th Floor, Aldwych House, Aldwych, London WC2B 4HN | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2011-05-03-8f616a6e-10001-0 |
bf8b0455e00610e60baac5a624cf986240e18121 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2011-05-03-8f616a6e-10001-0 |
b7484e592b4760b2dbc2b1b68a27b78a7e445b22 | Date of receipt: 8 October 2010 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2011-05-03-8f616a6e-10001-0 |
f41425291e22fb1a34f8d320d6cd83884d125343 | Date of acceptance: 11 October 2010 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2011-05-03-8f616a6e-10001-0 |
3673013a4d3e2497a149bf5ffa2009967aecb7ab | Donor status: company, registration 05635995 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2011-05-03-8f616a6e-10001-0 |
8cb9fc19472ca20b3c930a2e4f13bfaae4f356af | (Registered 11 October 2010) | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2011-05-03-8f616a6e-10001-0 |
559624f8fd6766c0ac09bca8fd19708e4ca0b7f8 | Name of donor: The Arts Club | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2011-05-03-8f616a6e-10001-0 |
a8f434f746353407311f3e5815af4d6dc75912c6 | Address of donor: 40 Dover street London W1S 4NP | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2011-05-03-8f616a6e-10001-0 |
a06a31bcafb940df0b5e6d3f0a311557afc83416 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2011-05-03-8f616a6e-10001-0 |
869eb441ffb02fd35a56722380b26bc21ca42109 | Date of receipt: 25 October 2010 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2011-05-03-8f616a6e-10001-0 |
04a315c950abff701a6d593f6817c7cf1f3db41c | Date of acceptance: 5 October 2010 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2011-05-03-8f616a6e-10001-0 |
ca2929613a5448c646f95d6ffedef8381e5748bc | Donor status: company, registration 0047802 | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2011-05-03-8f616a6e-10001-0 |
0e7264e33a4314c7acb63ac4e14a3a6eadb4d6e8 | (Registered 25 October 2010) | Sponsorships 8f616a6e | 2011-05-03 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 15 | 2011-05-03-8f616a6e-10001-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");