items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2010-11-22-8f616a6e-24749-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 |
---|---|---|---|---|---|---|---|
00344403cb25e9e6d134b48895b61575746da8d5 | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2010-11-22-8f616a6e-24749-0 |
24f72b0546822960557d315903032042cca73e91 | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2010-11-22-8f616a6e-24749-0 |
06f854d0e95935906a3f9f1905b22b171ef2708c | Address of donor: private | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2010-11-22-8f616a6e-24749-0 |
d3be2c70461c92f04d8514399b0deb15704d9721 | Donor status: individual | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2010-11-22-8f616a6e-24749-0 |
b9a50511280731cedd053e2ac13a78664b24088f | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2010-11-22-8f616a6e-24749-0 |
c284a1fc81d531eb0a66f24138a44864bfceed60 | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2010-11-22-8f616a6e-24749-0 |
a15b4f641df44140954dd56aeb2ecd735a41a3b0 | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2010-11-22-8f616a6e-24749-0 |
37b9c47ac652fbeb527adedaf104646c79b57245 | Donor status: club | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2010-11-22-8f616a6e-24749-0 |
72fcce7dcc896e8a00bfbb5979576d441d343b6b | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2010-11-22-8f616a6e-24749-0 |
22f46d7abc37b278f166129e2f80f0ebabdcaec1 | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2010-11-22-8f616a6e-24749-0 |
082f38ca19d389f95db0e338d939faffc738769e | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2010-11-22-8f616a6e-24749-0 |
09b27cd70e47b01d24d4cabec177e0b408c8c468 | Donor status: company | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2010-11-22-8f616a6e-24749-0 |
658f1a0cc0161c307f2f4024cac5d794b264bbc6 | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2010-11-22 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2010-11-22-8f616a6e-24749-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");