items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2002-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 |
---|---|---|---|---|---|---|---|
e6ff34db22954a3ce6f89dd3bb6608996956123b | Vice President of Offa's Dyke Association (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 0 | 2002-05-14-265f2269-10416-0 |
a5a18ee5aff340badb473aa91dfe9f378d6b5107 | Vice President of Heart of Wales Line Travellers Association (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 1 | 2002-05-14-265f2269-10416-0 |
9d386f61c081f41cbb3395bbc75d4eccd76e2827 | Member of Shropshire Chamber of Commerce, Training and Enterprise (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 2 | 2002-05-14-265f2269-10416-0 |
f8c1d51a8249c1835790eb3199ec607ea0e816cc | Patron of the Drapers' Hall Building Preservation Trust (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 3 | 2002-05-14-265f2269-10416-0 |
6025bb7bce1c0beee7178c910fa1ebf6678b4676 | Patron of the ReGenerate charity (honorary and unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 4 | 2002-05-14-265f2269-10416-0 |
040510a35af611454e526195565e448cb0473002 | Chairman of Advantage Shrewsbury business forum (unpaid). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 5 | 2002-05-14-265f2269-10416-0 |
3be54531b6192df812762753f6c50fd7f188b76f | Trustee of the Shrewsbury Town FC Supporters Fund (unpaid). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 6 | 2002-05-14-265f2269-10416-0 |
c07593eee7931f4baa7f152c6f8fb04964452e10 | Member of the Shrewsbury Citizen's Advice Bureau Management Board (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 7 | 2002-05-14-265f2269-10416-0 |
b7738ca0593327dfe141a4bfdaf450a286ed8bf3 | Director of Shrewsbury and Central Shropshire Citizens Advice Bureau (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Paul Marsden uk.org.publicwhip/member/1348 | Paul Marsden uk.org.publicwhip/person/10416 | 8 | 2002-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");