items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2011-03-14-8f616a6e-24749-0" sorted by record_id
This data as json, CSV (advanced)
date (date) 1 ✖
- 2011-03-14 13
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
87d25ba6891dbd5cfc852cd1ff2743622da41c19 | 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 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-03-14-8f616a6e-24749-0 |
f05f7aa8b428b76ed6e1cc8106dafae018809364 | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-03-14-8f616a6e-24749-0 |
7dc6c9d33b7d3cb41103a8e0fcad70b90d7c8ee0 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2011-03-14-8f616a6e-24749-0 |
157ce8cf8db3b05380d7da3c1e7b1f14cf54be4c | Donor status: individual | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2011-03-14-8f616a6e-24749-0 |
9c4e8b3167c2fde70e44a2cd6e20beb46770805f | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2011-03-14-8f616a6e-24749-0 |
0923ab6ca2287904bd7cc731fcdcedd987303063 | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2011-03-14-8f616a6e-24749-0 |
346937fddbfe9743f261d9b04c8856928c65e03f | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2011-03-14-8f616a6e-24749-0 |
87f1375d11af6d14455b7c2be4ff9d47e2c67181 | Donor status: club | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2011-03-14-8f616a6e-24749-0 |
c1fceb279b7d7ed07b1d4074f514187e17d65ede | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2011-03-14-8f616a6e-24749-0 |
622ce6f6b7ee27e87fe00bb2fcc14e14aed18281 | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2011-03-14-8f616a6e-24749-0 |
ba7c071711f4fb8dffe368725e75d70d208d7969 | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2011-03-14-8f616a6e-24749-0 |
671b6f3ab34f54784ababb711f17b0c8cdd8977f | Donor status: company | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2011-03-14-8f616a6e-24749-0 |
0c36b4b1a146f0a7e4ccba8fd017d4f544174cec | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-03-14 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2011-03-14-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");