items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2014-03-24-80ef1083-10106-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 |
---|---|---|---|---|---|---|---|
f0d99dcf92471e24465329b0bfb9892e2f688702 | Amount of donation (or estimate of the probable value): flights, accommodation etc; total value £1,200 | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 3 | 2014-03-24-80ef1083-10106-0 |
98c2a3b17f9f6e693cc6496b5e5acbd2b9c15660 | Destination of visit: Israel | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 4 | 2014-03-24-80ef1083-10106-0 |
a027cf842b4bb07edc0082422e7674a2d08bb06f | Date of visit: 10-13 March 2014 | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 5 | 2014-03-24-80ef1083-10106-0 |
8c969614b6e60c9ee52bdb3be255512c8e5c4742 | Purpose of visit: political delegation to Israel | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 6 | 2014-03-24-80ef1083-10106-0 |
74676d645d4534abedda8236dc6452785cf4ab33 | (Registered 19 March 2014) | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 7 | 2014-03-24-80ef1083-10106-0 |
eba062dabda5daf58d9bdfecc7eea3a0efb750a2 | Name of donor: Conservative Friends of Israel | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 8 | 2014-03-24-80ef1083-10106-0 |
4695a12e9d946ce39fd04772c547280d2ea855ed | Address of donor: c/o Shelley Stock Hunter LLP, 7-10 Chandos St, London | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 9 | 2014-03-24-80ef1083-10106-0 |
bf24d2ac0f7bf2a9daeecba77a19e2e7a261f531 | W1G 9DG | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 10 | 2014-03-24-80ef1083-10106-0 |
019bd6ccff6dc8097ae2cb997fef8e8bd5f3c8eb | Amount of donation (or estimate of the probable value): £2,000 | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 11 | 2014-03-24-80ef1083-10106-0 |
680420523ddde3d8b53164e077f7efee2e70d2e7 | Destination of visit: Israel and the West Bank | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 12 | 2014-03-24-80ef1083-10106-0 |
0382f7b6479567d165bd27c3019503481ebab4d5 | Date of visit: 16-21 February 2014 | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 13 | 2014-03-24-80ef1083-10106-0 |
6542bbac3e4c7236348ff0e36b8693724c5201ef | Purpose of visit: fact f inding political delegation | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 14 | 2014-03-24-80ef1083-10106-0 |
5267ed9d6c512bed8ae79918867d7f60c8e54e3b | (Registered 21 March 2014) | Overseas visits 80ef1083 | 2014-03-24 | James Clappison uk.org.publicwhip/member/40314 | James Clappison uk.org.publicwhip/person/10106 | 15 | 2014-03-24-80ef1083-10106-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");