items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2010-03-24-80ef1083-10050-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 |
---|---|---|---|---|---|---|---|
0288f5ad36053eec0579be444733c7b4957e5285 | Name of donor: | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 0 | 2010-03-24-80ef1083-10050-0 |
0ee37d28fc29d76440e2de0fd9309e03f1478476 | 1) Vision Australia | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 1 | 2010-03-24-80ef1083-10050-0 |
dd4c4f5ea95aaa27424a68507c6da2928a4a5595 | 2) Australia and New Zealand School of Government | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 2 | 2010-03-24-80ef1083-10050-0 |
063e6411128fccfa32330c4d2712081c0a23ca02 | Address of donor: | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 3 | 2010-03-24-80ef1083-10050-0 |
bfeb692c43fb1c717ed132c5a5780d8065f896d3 | 1) Vision Australia Kooyong, 454 Glenferrie Road, Kooyong, Vic 3144, Australia. | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 4 | 2010-03-24-80ef1083-10050-0 |
6caca2c430d7ed212452c35e8d3cb66f207dde5b | 2) PO Box 4023, Parkville, Vic 3052, Australia. | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 5 | 2010-03-24-80ef1083-10050-0 |
b590db298f820086175fb995ac6b7f221615fce0 | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 6 | 2010-03-24-80ef1083-10050-0 |
d7ec6474325327075748dda97464cf8a80df8b68 | 1) accommodation and internal flights for me and my wife (approximately £3000)all other costs were covered personally. | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 7 | 2010-03-24-80ef1083-10050-0 |
533ebdcea02b6770e8b5f11317e13136ad1b159c | 2) part-funding for international flights for me and my wife (£4800)I personally funded the outstanding amount. | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 8 | 2010-03-24-80ef1083-10050-0 |
1980fc5c2a99dec92e54356d3b054cee32dc2c45 | Destination of visit: Sydney, Canberra, Melbourne and BrisbaneAustralia | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 9 | 2010-03-24-80ef1083-10050-0 |
82170c172b17ecc3e92ecaf06e7db1a2b2790f70 | Date of visit: 5-22 November 2009 | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 10 | 2010-03-24-80ef1083-10050-0 |
e0f857c1db961795e549a30664bfa66e5a27d515 | Purpose of visit: to undertake lectures, charitable fundraising and meetings with ministers and others. | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 11 | 2010-03-24-80ef1083-10050-0 |
b9080c1bf146512dcee08f584f796c1e62d0ac46 | (Registered 9 December 2009) | Overseas visits 80ef1083 | 2010-03-24 | David Blunkett uk.org.publicwhip/member/1810 | David Blunkett uk.org.publicwhip/person/10050 | 12 | 2010-03-24-80ef1083-10050-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");