items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2001-05-14-265f2269-10416-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 |
---|---|---|---|---|---|---|---|
4c3b208ff9f62b9f364045ec22a90a8f7895c7f5 | Vice President of Offa's Dyke Association (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 0 | 2001-05-14-265f2269-10416-0 |
0ebed9cdaa181e721e7ab5f2abab50996c5f752a | Vice President of Heart of Wales Line Travellers Association (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 1 | 2001-05-14-265f2269-10416-0 |
af6f83e71211d91648037e516cc1ecd8d08b647d | Member of the Agriculture and Rural Economy Committee of the Country Landowners Association (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 2 | 2001-05-14-265f2269-10416-0 |
c3ed7aa35eadbdada19185c23ba77153415a51d5 | Member of Shropshire Chamber of Commerce, Training and Enterprise (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 3 | 2001-05-14-265f2269-10416-0 |
69379475e03b92956ceb26d721d1950c95a2abe1 | Patron of the Drapers' Hall Building Preservation Trust (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 4 | 2001-05-14-265f2269-10416-0 |
0e2d4fb42f709de23804ba200736609dd04922a1 | Patron of the ReGenerate charity (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 5 | 2001-05-14-265f2269-10416-0 |
30b1abb8f70a012c404d2efc53a74ce3f1cb1182 | Chairman of Advantage Shrewsbury business forum (unpaid). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 6 | 2001-05-14-265f2269-10416-0 |
3ee00e53b724a0f1ce132656c23f2f23ad66b28e | Trustee of the Shrewsbury Town FC Supporters Fund (unpaid). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Paul Marsden uk.org.publicwhip/member/416 | Paul Marsden uk.org.publicwhip/person/10416 | 7 | 2001-05-14-265f2269-10416-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");