items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-80ef1083-11715-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 |
---|---|---|---|---|---|---|---|
52b2f34c6578fb738f1fddbff3547588097f1cf8 | Name of donor: UK Defence Forum | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 0 | 2015-03-30-80ef1083-11715-0 |
51e1e50d116c589ce9ba28512b503374c9a03c32 | Address of donor: Grainger Suite, Dobson House, Regent Centre, Gosforth, Newcastle upon Tyne, NE3 3PF | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 1 | 2015-03-30-80ef1083-11715-0 |
1263bc179eb050f1c36f74102a8b5255bb230963 | Amount of donation (or estimate of the probable value): guidance, accommodation and subsistence (est value £815) | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 2 | 2015-03-30-80ef1083-11715-0 |
a3f76a6393b88b09aa5d70606679fea31087cf2d | Destination of visit: Belgium and France | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 3 | 2015-03-30-80ef1083-11715-0 |
a78365d83af520c1e941de176ba6e08c1784f1b0 | Date of visit: 3-6 July 2014 | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 4 | 2015-03-30-80ef1083-11715-0 |
f668e1dcc71be4e5e091571bd8cf4100b84494a8 | Purpose of visit: Study tour of military cemeteries and battlefields | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 5 | 2015-03-30-80ef1083-11715-0 |
df6ac1da577014d2eb0fa78750656b1ee8e3035e | (Registered 8 July 2014) | Overseas visits 80ef1083 | 2015-03-30 | Mark Lancaster uk.org.publicwhip/member/40403 | Mark Lancaster uk.org.publicwhip/person/11715 | 6 | 2015-03-30-80ef1083-11715-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");