items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2013-06-10-8f616a6e-24886-0" sorted by date
This data as json, CSV (advanced)
date (date) 1 ✖
- 2013-06-10 11
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
1712a0602b1b97be98dea13b86b4f91277264f48 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 0 | 2013-06-10-8f616a6e-24886-0 |
da7ad46510a16280dcfbf7590b5fe93f7f0d3542 | Name of donor: Sun Mark Ltd | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 1 | 2013-06-10-8f616a6e-24886-0 |
5d87154fa362a054d8bd7ba80103fcab78b0533b | Address of donor: 428 Long Drive, Greenford, Middlesex UB6 8UH | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 2 | 2013-06-10-8f616a6e-24886-0 |
551f9b5b222f1a8d65c0a707d6d943e160789a01 | Amount of donation or nature and value if donation in kind: £15,000 | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 3 | 2013-06-10-8f616a6e-24886-0 |
049d8d10db5b139f61feb0c424a3286b2e36c402 | Donor status: company | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 4 | 2013-06-10-8f616a6e-24886-0 |
32f3c401eaee4aa8f4762dee6ad90012d936630f | (Registered 28 February 2013) | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 5 | 2013-06-10-8f616a6e-24886-0 |
2547155a3d638935d574cd0fab251703bfd42a34 | Name of donor: Mr Paul Brett | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 6 | 2013-06-10-8f616a6e-24886-0 |
64f072ce9cc1a123e5cf2074570b5867ed48b83b | Address of donor: private | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 7 | 2013-06-10-8f616a6e-24886-0 |
00031aee39a8ce739eeb57393ace1f0d43126981 | Amount of donation or nature and value if donation in kind: £12,000 | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 8 | 2013-06-10-8f616a6e-24886-0 |
19fa967c8141722e5f6679a5acc485f5b86604db | Donor status: individual | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 9 | 2013-06-10-8f616a6e-24886-0 |
c9fdaca1e702a2b3d4ff9f2df2759abacdf1b1f0 | (Registered 30 May 2013) | Sponsorships 8f616a6e | 2013-06-10 | Paul Uppal uk.org.publicwhip/member/40670 | Paul Uppal uk.org.publicwhip/person/24886 | 10 | 2013-06-10-8f616a6e-24886-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");