items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where "date" is on date 2011-07-06 and person_id = "uk.org.publicwhip/person/10069" sorted by person_id
This data as json, CSV (advanced)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
92205a3a642d57ebca7c892af6881609da499346 | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-07-06-8f616a6e-10069-0 |
bb7c7fc2f0bb8b8cb8bd3f667d003ba3747b7713 | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-07-06-8f616a6e-10069-0 | |
79162b430a45e714917fa198173ec76a2b258423 | Name of donor: CWU | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-07-06-8f616a6e-10069-0 |
58f365d80997a3588a670c5012bb8c135aae3c50 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-07-06-8f616a6e-10069-0 |
efad576b301c869e70bb84a74c9f8930d6dd3e90 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-07-06-8f616a6e-10069-0 |
5b7fbf99a6bc31fb8769655320442a6c7b46751e | Donor status: trade union | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-07-06-8f616a6e-10069-0 |
c29fc22d3e47d30fdc06208b514a5c8fce07183e | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-07-06 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 6 | 2011-07-06-8f616a6e-10069-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");