items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2011-03-14-8f616a6e-10357-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 |
---|---|---|---|---|---|---|---|
06f30cd325d1b8610b3911c45e0994ce90c71a1b | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 0 | 2011-03-14-8f616a6e-10357-0 |
2bdd77351a9059be71c19b44186ea30f531ed283 | Name of donor: Mr Joshua Rowe | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 1 | 2011-03-14-8f616a6e-10357-0 |
3d8797662b2b113c20cd66e6477722bcb0504c9f | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 2 | 2011-03-14-8f616a6e-10357-0 |
0d37453478315d30c05623bae15b924dd2a1f1ed | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 4 | 2011-03-14-8f616a6e-10357-0 |
83986bb5a23a98f35fb3d62ee38e53828a12c610 | Name of donor: London and City Credit Corporation Ltd | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 6 | 2011-03-14-8f616a6e-10357-0 |
531b522d66bcfaf3b1b74166391f40c694a13521 | Address of donor: 14 The Embankment Vale Road Stockport SK4 3GN | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 7 | 2011-03-14-8f616a6e-10357-0 |
e678608fcd1a9d8c3e39f4449ce4f5f805d31efd | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 8 | 2011-03-14-8f616a6e-10357-0 |
dfde927cfd2edd916b3817befb8c47738d4aab7e | Donor status: company | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 9 | 2011-03-14-8f616a6e-10357-0 |
75c4798f0e18a8654932bf824d405a781761889c | (Registered 3 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Ivan Lewis uk.org.publicwhip/member/40135 | Ivan Lewis uk.org.publicwhip/person/10357 | 10 | 2011-03-14-8f616a6e-10357-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");