items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2014-12-08-8f616a6e-10080-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 |
---|---|---|---|---|---|---|---|
226faa7a17cb64ed267e525b56c50108c7f4c043 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 0 | 2014-12-08-8f616a6e-10080-0 |
7faf2ab6a4534d6745d5071fe80e1ce88c6c879c | Name of donor: Paul Burstow Business Networking Club | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 1 | 2014-12-08-8f616a6e-10080-0 |
54d2b1951e483ad6ccd9d078ebf4a46347489030 | Address of donor: 234 Gander Green Lane, Sutton SM3 9QF | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 2 | 2014-12-08-8f616a6e-10080-0 |
f600b419e66c78cbc5ae015386343bb4e4896fdc | Amount of donation or nature and value if donation in kind: £1,549.45 | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 3 | 2014-12-08-8f616a6e-10080-0 |
2c9044eae310bdb127fb4ae81c7aa64a670406a2 | Donor status: members’ association | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 4 | 2014-12-08-8f616a6e-10080-0 |
02eacf260ab315a74576cd0dd3b2fae84b2caff3 | (Registered 30 January 2014) | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 5 | 2014-12-08-8f616a6e-10080-0 |
2d00ca7ad0524b96292fa7d797d56b7d23b243e4 | Name of donor: Smith and Byford Ltd | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 6 | 2014-12-08-8f616a6e-10080-0 |
a2007cf04bd5b636d9d8383bf5e836d9f2f3678a | Address of donor: St George’s House, Station Approach, Cheam SM2 7AT | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 7 | 2014-12-08-8f616a6e-10080-0 |
36fa3555b8582ef95379d7954662dd4281caa0f3 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 8 | 2014-12-08-8f616a6e-10080-0 |
bfac6ea0e5e1d9ced7c013a049277e551ce73491 | Donor status: company, registration 01074356 | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 9 | 2014-12-08-8f616a6e-10080-0 |
5b211a63b7a44e429e57a63d5127764512473b19 | (Registered 1 December 2014) | Sponsorships 8f616a6e | 2014-12-08 | Paul Burstow uk.org.publicwhip/member/40594 | Paul Burstow uk.org.publicwhip/person/10080 | 10 | 2014-12-08-8f616a6e-10080-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");