items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
10 rows where record_id = "2010-03-24-80ef1083-10371-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 |
---|---|---|---|---|---|---|---|
57ea10e996355687545dcb0b0c5fa7bae7115624 | Name of donor: 1) Consolidated Contractors Company | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 0 | 2010-03-24-80ef1083-10371-0 |
b0e9c12b1cd1b97c6ca3218b8910317884ec6d48 | 2) Government of Tajikistan | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 1 | 2010-03-24-80ef1083-10371-0 |
1a009250504addbc8027fe27a4966a82867ab666 | Address of donor: 1) 11A West Halkin Street, Belgravia, London SW1X 8JL. | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 2 | 2010-03-24-80ef1083-10371-0 |
e389040a2c433dc77447fd0cf4bcdfdda2202411 | 2) Dushanbe, Tajikistan. | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 3 | 2010-03-24-80ef1083-10371-0 |
f489bd76bdcba30b25bd685d164a0ab74062b17c | Amount of donation (or estimate of the probable value): 1) £1408.20 (flights to and from Dushanbe) | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 4 | 2010-03-24-80ef1083-10371-0 |
c22522ee29d4b2d114ce69788b205c3cb6fb710b | 2) approximately £400 (for accommodation) | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 5 | 2010-03-24-80ef1083-10371-0 |
4311c55084f283003a7cf09e4c0aa92b0a8d1046 | Destination of visit: Tajikistan | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 6 | 2010-03-24-80ef1083-10371-0 |
c43b4e6b142479cbd6b1310269f65b49043ebef1 | Date of visit: 14-18 November 2009 | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 7 | 2010-03-24-80ef1083-10371-0 |
265929971c49535f8d046e7155c66bc93227a781 | Purpose of visit: officers of the All-Party Parliamentary Group for Tajikistan met parliamentarians and established a friendship group and met agencies dealing with Afghan refugees and drug trafficking. | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 8 | 2010-03-24-80ef1083-10371-0 |
d91a36faa04ad9403deadf8ec46972a3906bd165 | (Registered 8 December 2009) | Overseas visits 80ef1083 | 2010-03-24 | Tim Loughton uk.org.publicwhip/member/1944 | Tim Loughton uk.org.publicwhip/person/10371 | 9 | 2010-03-24-80ef1083-10371-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");