items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2010-12-20-80ef1083-11621-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 |
---|---|---|---|---|---|---|---|
4565b5def86e2e8ecc026a9fd6e69ececd0bab35 | Name of donor: | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 0 | 2010-12-20-80ef1083-11621-0 |
1e19881c99b35192e462fedc9ff3758c143fe970 | 1. Jerusalem Institute for Market Studies | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 1 | 2010-12-20-80ef1083-11621-0 |
e9f1311ddfd378147433e974055497733f25e9e2 | 2. Conservative Friends of Israel | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 2 | 2010-12-20-80ef1083-11621-0 |
8c91e46493acaa5f92fd5b08dabd0728e61e2f13 | Address of donor: | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 3 | 2010-12-20-80ef1083-11621-0 |
f948c6883471619be2f45231269369e893ae7d66 | 1. Tchernikovsky 49/9, Jerusalem, Israel. | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 4 | 2010-12-20-80ef1083-11621-0 |
e667c2fc39da5789cfc083ac81e4ff66ef29996f | 2. 45b Westbourne Terrace, London W2 3UR. | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 5 | 2010-12-20-80ef1083-11621-0 |
12a4ab7850978656839e84096c09294a2e26a52a | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 6 | 2010-12-20-80ef1083-11621-0 |
108f03caae0de03ddb45b5cd85e4d7feaa50ee40 | 1. £1500 for travel, accommodation and meals. | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 7 | 2010-12-20-80ef1083-11621-0 |
fa569bbead2a688c189cba405e1560947db9b5ed | 2. £250 for meals and transport. | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 8 | 2010-12-20-80ef1083-11621-0 |
b35c75c99044d9092636c128a99d3263a7c1a03d | Destination of visit: Israel | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 9 | 2010-12-20-80ef1083-11621-0 |
4a70bda34d6b4c3231037a801b4493eb344eea1c | Date of visit: 23-26 January 2010 | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 10 | 2010-12-20-80ef1083-11621-0 |
08e5761b3df8830bbb7eed6e918ff03cdda10d9a | Purpose of visit: to give a lecture to the Jerusalem Institute of Market Studies. | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 11 | 2010-12-20-80ef1083-11621-0 |
58813178b4672e20ccc7153a56c7a6d07c543eab | (Registered 2 February 2010) | Overseas visits 80ef1083 | 2010-12-20 | Douglas Carswell uk.org.publicwhip/member/40175 | Douglas Carswell uk.org.publicwhip/person/11621 | 12 | 2010-12-20-80ef1083-11621-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");