items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2011-11-16-80ef1083-10013-0" sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
156654a03a9f667b949d056a0fb02a03530a376f | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 0 | 2011-11-16-80ef1083-10013-0 |
e3454551a2452b5aed37b4c081fbf576d6d8fb38 | Address of donor: 45B Westbourne Terrace, London W23UR | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 1 | 2011-11-16-80ef1083-10013-0 |
3d56b1218a3d0eb1da3b52c4e4d4a999a00a1215 | Amount of donation (or estimate of the probable value): £1,663.19 from CFI; plus two meals provided by other hosts, estimated cost of £100. | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 2 | 2011-11-16-80ef1083-10013-0 |
435325a675d1de7a78af7f77ab0a2ea6c825e004 | Destination of visit: Israel | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 3 | 2011-11-16-80ef1083-10013-0 |
11fa3877d3119678efee903c6ea262d260c1d6a1 | Date of visit: 20-25 February 2011 | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 4 | 2011-11-16-80ef1083-10013-0 |
027521f4b71ea6e6af50ad986875648a7745c4b1 | Purpose of visit: fact-finding political delegation to Israel and the West Bank. | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 5 | 2011-11-16-80ef1083-10013-0 |
120497d1e78814df74c02c7dccbe482149a66a57 | (Registered 11 March 2011) | Overseas visits 80ef1083 | 2011-11-16 | James Arbuthnot uk.org.publicwhip/member/40439 | James Arbuthnot uk.org.publicwhip/person/10013 | 6 | 2011-11-16-80ef1083-10013-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");