items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2011-04-18-8f616a6e-24901-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
14f517dd8f7d0845ab39938c936c7b2e34c8eee4 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 0 | 2011-04-18-8f616a6e-24901-0 |
0924caf6d7a68cf450dfaced33cc8f8ae8b93077 | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 1 | 2011-04-18-8f616a6e-24901-0 | |
2cbbb874c6da40ced97f7e0a8f525e0234350da2 | Name of donor: Mr W D Lyons | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 2 | 2011-04-18-8f616a6e-24901-0 |
73d160874a8ae9f8bdfb07b58d7b0f145e520c95 | Name of donor: Mr W G Oldfield | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 7 | 2011-04-18-8f616a6e-24901-0 |
0504f17f9cb334955d963a1a964df496b958c961 | Amount of donation or nature and value if donation in kind: £5,000 donation (to my constituency party) | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 9 | 2011-04-18-8f616a6e-24901-0 |
28528b236aec87f5d6aada6f72e032d32636b6b5 | Name of donor: Mr G R Williams | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 12 | 2011-04-18-8f616a6e-24901-0 |
10cb11cbfd9ff07bd860a37102dba3580ac6a9db | Address of donor: private | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 13 | 2011-04-18-8f616a6e-24901-0 |
34a00f1ec3b2074a88e3fc24a978ed1fc986acee | Amount of donation or nature and value if donation in kind: £3,000 donation (to my constituency party) | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 14 | 2011-04-18-8f616a6e-24901-0 |
7aad5669ea7813a4a10778877fc0e33bb1f065b9 | Donor status: individual | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 15 | 2011-04-18-8f616a6e-24901-0 |
0bd6966d7e15cc7c22574add1aad738be4297ba0 | (Registered 28 May 2010) | Sponsorships 8f616a6e | 2011-04-18 | Steve Brine uk.org.publicwhip/member/40660 | Steve Brine uk.org.publicwhip/person/24901 | 16 | 2011-04-18-8f616a6e-24901-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");