items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where record_id = "2011-10-17-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 |
---|---|---|---|---|---|---|---|
017ba6b1aba67cdfec37f1e78910e020118771d1 | Support in the capacity as an MP | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2011-10-17-8f616a6e-10001-0 |
24cad0a228ef6de1e98c9c205739c38e9cb62a88 | Donation to support my campaign for leadership of the Labour Party: | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2011-10-17-8f616a6e-10001-0 |
87a0ea4b31ab2de7db4a737da31e3dde4b73379f | Name of donor: BM Creative Management Ltd (Media) | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2011-10-17-8f616a6e-10001-0 |
b0879622da0d4a673892e0ccdc76dda3f9e4771f | Address of donor: 4th Floor, Aldwych House, Aldwych, London WC2B 4HN | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2011-10-17-8f616a6e-10001-0 |
9cc583ecead350aba9eabd10d7221b7a8e3441be | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2011-10-17-8f616a6e-10001-0 |
380ac8b749b0ac8561ead614ba328929f12bc926 | Date of receipt: 8 October 2010 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2011-10-17-8f616a6e-10001-0 |
50f67f3f7757b07ba1e8499a78f6add8b57d5b6d | Date of acceptance: 11 October 2010 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2011-10-17-8f616a6e-10001-0 |
3c109835dcafcab1abdc95366ff8ac472164c83b | Donor status: company, registration 05635995 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2011-10-17-8f616a6e-10001-0 |
be84ca556576bf39f02a8b0c2ad17712b970b136 | (Registered 11 October 2010) | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 8 | 2011-10-17-8f616a6e-10001-0 |
8c7588c9b41f497cac08dcb52f745391c59689d6 | Name of donor: The Arts Club | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 9 | 2011-10-17-8f616a6e-10001-0 |
05d8fdddee45c5f1c545d3af6f99946f9c9a4772 | Address of donor: 40 Dover street London W1S 4NP | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 10 | 2011-10-17-8f616a6e-10001-0 |
212ffd767e08acad65b5ee5c37fc162f83b4676e | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 11 | 2011-10-17-8f616a6e-10001-0 |
05883aa90aa77b64b5772413a7b744f2aad5512d | Date of receipt: 25 October 2010 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 12 | 2011-10-17-8f616a6e-10001-0 |
211e2ab0212e49dcfdd050f7def9141b911aa0b7 | Date of acceptance: 5 October 2010 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 13 | 2011-10-17-8f616a6e-10001-0 |
102a9ee7babf896c57128d908c52dee65d32aa0c | Donor status: company, registration 0047802 | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 14 | 2011-10-17-8f616a6e-10001-0 |
3c10ca717bc46b552083563b54d4fab87af7afb1 | (Registered 25 October 2010) | Sponsorships 8f616a6e | 2011-10-17 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 15 | 2011-10-17-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");