items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2001-05-14-265f2269-10349-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 |
---|---|---|---|---|---|---|---|
2676f18fb4b358753706e8d94e954165441de4ef | Patron of STRADA, Cambridge; day centre for sufferers from stroke and dysphasia (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 0 | 2001-05-14-265f2269-10349-0 |
f464f9e310fef098196b3cb51605a8bb5437cdaf | Patron of the Cambridgeshire Small Business Group (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 1 | 2001-05-14-265f2269-10349-0 |
2ab1bf08f62ebe179627ad79a724d8ae69684d3f | Vice-President of the Cambridgeshire Beekeepers' Association (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 2 | 2001-05-14-265f2269-10349-0 |
513523540221eb4ceda6b99ab8995261899bfa8b | Vice-President of the Local Government Association (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 3 | 2001-05-14-265f2269-10349-0 |
129ca01211c89c3dfd5ce7134e992402085e8a60 | Patron of ASPIRE (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 4 | 2001-05-14-265f2269-10349-0 |
2581fe8411c6b00f2d749a0dd3fa304fc7f479c8 | Patron of the International Centre for Child Studies (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 5 | 2001-05-14-265f2269-10349-0 |
201e0eb53545d73e0f76c683edf260b7958d73f6 | Patron of Headway Cambridge (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 6 | 2001-05-14-265f2269-10349-0 |
3bc2de1ec0f8757f160634a97b10e41bc278897d | Member of the Council of The Association of Conservative Clubs Ltd. (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 7 | 2001-05-14-265f2269-10349-0 |
d8898b3146075cfdb86278601d8bfacc1802e120 | Vice-Patron of the MRI Scanner Appeal at Hinchingbrooke Hospital, Cambridge (Unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 8 | 2001-05-14-265f2269-10349-0 |
a1f998374e4515100462879da57a9402d13ecfa7 | Vice-President of the Cambridge and Peterborough Federation of Young Farmers Clubs (unremunerated). | Miscellaneous and unremunerated interests 265f2269 | 2001-05-14 | Andrew Lansley uk.org.publicwhip/member/349 | Andrew Lansley uk.org.publicwhip/person/10349 | 9 | 2001-05-14-265f2269-10349-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");