items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2011-02-28-8f616a6e-10040-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 |
---|---|---|---|---|---|---|---|
916e3fbfb4be8db6762de5b89df935f185095005 | Donations to my campaign for re-election to the House of Commons were received as follows: | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 0 | 2011-02-28-8f616a6e-10040-0 |
aa4547f722424f9582f5992565b38a6702d70c28 | Name of donor: Michael Keegan | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 1 | 2011-02-28-8f616a6e-10040-0 |
ef2117bb3b74278dd9e8711956918d8a978869fd | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 3 | 2011-02-28-8f616a6e-10040-0 |
cfe609fda502f10b07b52daa71c8f667796a66a3 | Name of donor: Sir Sigmund Sternberg | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 6 | 2011-02-28-8f616a6e-10040-0 |
c52a32c1e659556e9c2d5c59d5160c57a25a45c0 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 8 | 2011-02-28-8f616a6e-10040-0 |
0c1dd894d40b25de6449766e312dfaf0bd41de5b | Name of donor: Sun Mark Ltd | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 11 | 2011-02-28-8f616a6e-10040-0 |
7f3273fc319efc0dc3e228b0180cb44a30a4afe9 | Address of donor: Sun House, Greenford, Middlesex UB6 8UH. | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 12 | 2011-02-28-8f616a6e-10040-0 |
826f1708585ffb9485e64b577ba90cacf6664ed7 | Donor status: company | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 14 | 2011-02-28-8f616a6e-10040-0 |
19c7cc23f5b987b093e1502fe9023d253f42af67 | Name of donor: Arjan and Jaya Vekaria | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 16 | 2011-02-28-8f616a6e-10040-0 |
d203e0998f686f6a5e2e7a9a0229ed7307effaae | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 18 | 2011-02-28-8f616a6e-10040-0 |
16ffa3b4704cfaca678139f9f1352456f8d623f8 | Name of donor: Mr Narinder Singh Chadha | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 21 | 2011-02-28-8f616a6e-10040-0 |
8fd127551a1c859f829e8e4e3d7c4913b8d08f48 | Address of donor: private | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 22 | 2011-02-28-8f616a6e-10040-0 |
b918cb89efb604e9d3137847af8c4d4d8a31627e | Amount of donation or nature and value if donation in kind: £2,501 | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 23 | 2011-02-28-8f616a6e-10040-0 |
9025b486177823a65f97c0c953d550bd3b3e2554 | Donor status: individual | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 24 | 2011-02-28-8f616a6e-10040-0 |
d4f8a6af3f8e03969b9ecf18ceb47da64ee837bd | (Registered 16 June 2010) | Sponsorships 8f616a6e | 2011-02-28 | John Bercow uk.org.publicwhip/member/40131 | John Bercow uk.org.publicwhip/person/10040 | 25 | 2011-02-28-8f616a6e-10040-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");