items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where record_id = "2013-12-09-8f616a6e-24954-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 |
---|---|---|---|---|---|---|---|
7201f8c129f5576d66e48a72bea40cca51e1e10c | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2013-12-09-8f616a6e-24954-0 |
401012f4f86c6de216dfdfdb92c12e81a4330a80 | Name of donor: Mr Charles Hill | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 1 | 2013-12-09-8f616a6e-24954-0 |
124d6a8dcaad0d5ac42d69002850e6491e084a32 | (Registered 8 April 2013) | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 5 | 2013-12-09-8f616a6e-24954-0 |
9cd9ebf44844db6798db07c5819e926acc52e251 | Name of donor: Paul Smith | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 6 | 2013-12-09-8f616a6e-24954-0 |
d0d8598d7668cea2ba0af0e61236bc7b8656a150 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 8 | 2013-12-09-8f616a6e-24954-0 |
7108209daf7a7c5328af5e880ad6323b3f67cc26 | (Registered 10 June 2013) | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 10 | 2013-12-09-8f616a6e-24954-0 |
65f7596faa26ea80a69c1916914ccffff45004e9 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 11 | 2013-12-09-8f616a6e-24954-0 |
a2e86ae5b3ee39f010930340ca7e7d3b084c4747 | Address of donor: 18 Thorney Lane North, Iver, Bucks SL0 9JW | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 12 | 2013-12-09-8f616a6e-24954-0 |
e246bb7e22898e2729846099e8c67cc9e7b694df | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 13 | 2013-12-09-8f616a6e-24954-0 |
d9c6e3d7c0c94fce49bf3aa1d1c0a87ed920d2c3 | Donor status: members’ association | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 14 | 2013-12-09-8f616a6e-24954-0 |
a49a3e1b80b1b430d4b121d05a958fd20bb9b2d5 | (Registered 17 October 2013 ) | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 20 | 2013-12-09-8f616a6e-24954-0 |
984f63cd6d0f134d49063871ee4f9e55fb21ba76 | (Registered 17 October 2013 ) | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 30 | 2013-12-09-8f616a6e-24954-0 |
47be04edfcac75559f49ceead2f68854fd6dc0c2 | Name of donor: SunMark Ltd | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 31 | 2013-12-09-8f616a6e-24954-0 |
5193ff5a05b03146aeb5dbde339feac2fd215644 | Address of donor: 428 Long Drive, Greenford UB6 8UH | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 32 | 2013-12-09-8f616a6e-24954-0 |
70d7e6880766c2121b592b51470290c2d302a40e | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 33 | 2013-12-09-8f616a6e-24954-0 |
ee2313ed61e8246bb1c61a38c880f546b0897cf7 | Donor status: company, registration no 03010238 | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 34 | 2013-12-09-8f616a6e-24954-0 |
8a61869472aed1ba4bc1bb02b340e3fe87ae73c8 | (Registered 17 October 2013) | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 35 | 2013-12-09-8f616a6e-24954-0 |
394bc0856b9fa887572d7727b7fa6f49ba08e38f | Name of donor: Mr Stephen Brook | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 36 | 2013-12-09-8f616a6e-24954-0 |
da304a72a6636f859ac38a8ae691422adcbde262 | Address of donor: private | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 37 | 2013-12-09-8f616a6e-24954-0 |
f586d0f039f5d8010bb535958736844f4314bf02 | Amount of donation or nature and value if donation in kind: £1,000 | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 38 | 2013-12-09-8f616a6e-24954-0 |
918865faccece4cdee6b80d7d333e7ca86c41b35 | Donor status: individual | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 39 | 2013-12-09-8f616a6e-24954-0 |
046acd346487e828321831376f664a5c4f2765d6 | (Registered 4 December 2013 ) | Sponsorships 8f616a6e | 2013-12-09 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 40 | 2013-12-09-8f616a6e-24954-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");