items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2011-12-13-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 |
---|---|---|---|---|---|---|---|
7f5f50773dc086fd19935bae681eb7970a5cd145 | Support in the capacity as an MP | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2011-12-13-8f616a6e-10001-0 |
7f237af83adfca5ba71ed7ffcbbeb095608e0360 | Donation to support my campaign for leadership of the Labour Party: | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2011-12-13-8f616a6e-10001-0 |
5ff57e4b510577b9d6c12f70f005c75a271ecdc2 | Name of donor: BM Creative Management Ltd (Media) | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2011-12-13-8f616a6e-10001-0 |
90d38c8c3fcf37286209ab8d460ad6889abfd1a2 | Address of donor: 4th Floor, Aldwych House, Aldwych, London WC2B 4HN | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2011-12-13-8f616a6e-10001-0 |
76bd510369219b098711e199e1019be16374036f | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2011-12-13-8f616a6e-10001-0 |
73661419914475290343cc9ba5b5c6a61b3d712f | Date of receipt: 8 October 2010 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2011-12-13-8f616a6e-10001-0 |
df682362169745fa7506a546370b8d3524c1016d | Date of acceptance: 11 October 2010 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2011-12-13-8f616a6e-10001-0 |
83a492b4e56802f215e7d4c4653140aa8cd00fca | Donor status: company, registration 05635995 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2011-12-13-8f616a6e-10001-0 |
b2679145c3993f4e9496e0e7336f2a8b5b92a28c | (Registered 11 October 2010) | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2011-12-13-8f616a6e-10001-0 |
b29d077f104941b55a64aef4989587378a8d82c4 | Name of donor: The Arts Club | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2011-12-13-8f616a6e-10001-0 |
d21b495fcea372f95d8822224cb4fbc575425706 | Address of donor: 40 Dover street London W1S 4NP | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2011-12-13-8f616a6e-10001-0 |
ea3c2a162da42caa03e5c03d72beb690b32997f0 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2011-12-13-8f616a6e-10001-0 |
8d4fed01746e9fd7837f7a42cf9d2cea6e4488c8 | Date of receipt: 25 October 2010 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2011-12-13-8f616a6e-10001-0 |
d88773831967414622bef29c3d7156a66edcf8e3 | Date of acceptance: 5 October 2010 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2011-12-13-8f616a6e-10001-0 |
7e43e5bb8221fb020bda2273c3f4ea3a396ceb7c | Donor status: company, registration 0047802 | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2011-12-13-8f616a6e-10001-0 |
017f1d90f3c576fd0aca7153cda54cadae646b4c | (Registered 25 October 2010) | Sponsorships 8f616a6e | 2011-12-13 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 15 | 2011-12-13-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");