items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2011-01-10-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 |
---|---|---|---|---|---|---|---|
f152923c8482320f5416c54c0066c7ffd09899ec | Donations to the constituency party or association, which have been or will be reported by the party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 0 | 2011-01-10-8f616a6e-24749-0 |
8cab6902331b80f063755e8ea98d1eefc4b37e4d | Name of donor: Austen Reid | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 1 | 2011-01-10-8f616a6e-24749-0 |
0bed361cca541957e569827251ee01ecfb7740e4 | Address of donor: private | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 2 | 2011-01-10-8f616a6e-24749-0 |
8d4b652bfe5f631f1d12723c4e458dc30f921999 | Donor status: individual | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 4 | 2011-01-10-8f616a6e-24749-0 |
c46953587fe3fe990de4e8fd6ebea794a83744ab | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 6 | 2011-01-10-8f616a6e-24749-0 |
42609ca4606a554f29b5b13753f6b6afe032ac4d | Address of donor: 18 Thorney Lane North Iver Bucks SL0 9PY | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 7 | 2011-01-10-8f616a6e-24749-0 |
ffadc645d7d858bb5d668fe03c32660a19e53dd2 | Amount of donation or nature and value if donation in kind: £2,500. | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 8 | 2011-01-10-8f616a6e-24749-0 |
762e9f346db1d808be3db4e7ce43eb39ad081330 | Donor status: club | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 9 | 2011-01-10-8f616a6e-24749-0 |
6d4ed0df43127612c1a767a8a9264a7451a54cec | Name of donor: Metloc Printers | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 11 | 2011-01-10-8f616a6e-24749-0 |
2195594a2bb5a2693c21911c74bb0135bb0fb04b | Address of donor: Caxton House Old Station Road Loughton Essex IG10 4PE | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 12 | 2011-01-10-8f616a6e-24749-0 |
1b2ebdc30f2355c6f816803f10ff7e2077b9eeea | Amount of donation or nature and value if donation in kind: £3,000. | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 13 | 2011-01-10-8f616a6e-24749-0 |
88138e8a34d4beaa2b0d08aa90dcfc1d124e9532 | Donor status: company | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 14 | 2011-01-10-8f616a6e-24749-0 |
6317f29af68ed62273e072ac1b48985d9017943f | (Registered 4 June 2010) | Sponsorships 8f616a6e | 2011-01-10 | Stephen Metcalfe uk.org.publicwhip/member/40540 | Stephen Metcalfe uk.org.publicwhip/person/24749 | 15 | 2011-01-10-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");