items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where date = "2002-05-14" and person_id = "uk.org.publicwhip/person/10025" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c15cc657f01f6adcbcf2af4190c74516325776ad | From time to time I buy and sell items of political iconography. | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 0 | 2002-05-14-0a4a155f-10025-0 |
0b1d89625bae45ed802863bb063f2fd11e179060 | Fee of £1,000 received from Ernst and Young for a debate on the economy in Harrogate on 22 November 2001. (Registered 6 March 2002) | Remunerated employment, office, profession etc. 0a4a155f | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 1 | 2002-05-14-0a4a155f-10025-0 |
cfbd7ee14e0b490a64d34eb6925d116e47354cf0 | 2-4 May 2001, to Greece to attend Olympic seminar. Travel and hotel accommodation provided by Organising Committee, 2004 Olympics. (Registered 9July 2001) | Overseas visits 80ef1083 | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 0 | 2002-05-14-80ef1083-10025-0 |
86bdf0f151afbc284e680fe6923c573e9506898a | 1-4 September 2001, to Tunisia at the invitation of the Tunisian Government. (Registered 6 March 2002) | Overseas visits 80ef1083 | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 1 | 2002-05-14-80ef1083-10025-0 |
9902027ec4e5a57a2e0f4171995c7f150417278d | Charles James Fox (Fine Arts) Ltd. | Registrable shareholdings 3aff2389 | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 0 | 2002-05-14-3aff2389-10025-0 |
7c5adfc6a00ff3b11bf30160011340f9430d3e43 | Vice-President, League Against Cruel Sports. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 0 | 2002-05-14-265f2269-10025-0 |
2fc53a267050b5bc8461d31e973a20a8b7c6e84a | Patron, Richard House Trust. | Miscellaneous and unremunerated interests 265f2269 | 2002-05-14 | Tony Banks uk.org.publicwhip/member/712 | Tony Banks uk.org.publicwhip/person/10025 | 1 | 2002-05-14-265f2269-10025-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");