items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where record_id = "2012-07-09-80ef1083-24947-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 |
---|---|---|---|---|---|---|---|
67f3ed81209d330da60f64faac54cb206dcf26d7 | Name of donor: | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 0 | 2012-07-09-80ef1083-24947-0 |
59b8f77c90e9d64c7fcf0ab4b647aa3175954502 | 5) Virgin Atlantic Airways Ltd | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 1 | 2012-07-09-80ef1083-24947-0 |
89564e92baa416806d49b00ca14ee85747fc71e1 | 6) Free the Children | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 2 | 2012-07-09-80ef1083-24947-0 |
6f09f9e6ec96c7f72347451076c40103ee843ef0 | Address of donor: | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 3 | 2012-07-09-80ef1083-24947-0 |
2e4a281821a04545eea1c18fcbbcf7247c0b11e8 | 7) The Office (SE2), Manor Royal, Crawley RH10 9NU | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 4 | 2012-07-09-80ef1083-24947-0 |
0005d1757d131ddae36d4db3ba34042f7c6c473a | 8) 75 Westminster Bridge Road, London SE1 7HS | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 5 | 2012-07-09-80ef1083-24947-0 |
b91d319e1ab30fe6e221e64b21bb639ea9336dcc | Amount of donation (or estimate of the probable value): | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 6 | 2012-07-09-80ef1083-24947-0 |
57e465a075fe3cb05c8e32d6fc63f29ff9a3010d | 7) Virgin Atlantic paid for return flights London to Nairobi, UK transfers and accommodation and food; value £2,599.32 | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 7 | 2012-07-09-80ef1083-24947-0 |
a45652e2d3c47b22acf6ed10270bd4e9b89af150 | 8) Free the Children paid for internal return flight Nairobi to Bogani; value £333.18. | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 8 | 2012-07-09-80ef1083-24947-0 |
0bf9130dcef1f554ebb4ae16396105c13358dfab | Total cost of trip; £2,958.73 | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 9 | 2012-07-09-80ef1083-24947-0 |
f9c3dca3a85c22c06621ad3ab7496ea9092d8993 | Destination of visit: Kenya | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 10 | 2012-07-09-80ef1083-24947-0 |
717c8a9f4792d17775728cc05be73d284060c4be | Date of visit: 31 August-3 September 2011 | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 11 | 2012-07-09-80ef1083-24947-0 |
6b72a13a350f66ac2b5503db3c8cc4a005e91d9f | Purpose of visit: to participate in the overseas aid programmes operated in Kenya by Virgin Atlantic in association with Free the Children. | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 12 | 2012-07-09-80ef1083-24947-0 |
f9a9afd3f54b0efb2b2f385d3a022b403b54ffcd | (Registered 30 September 2011) | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 13 | 2012-07-09-80ef1083-24947-0 |
ac60f6a3eeec0f790c17809e1fa7a17259c9b36f | Name of donor: Presence Switzerland, Embassy of Switzerland in the United Kingdom | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 14 | 2012-07-09-80ef1083-24947-0 |
6d444aa128e257f257d22045a268255ff2db5fd6 | Address of donor: 16-18 Montagu Place, London W1H 2BQ | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 15 | 2012-07-09-80ef1083-24947-0 |
e569b55175f2b3687ee1c0a24875d2730ebc6a09 | Amount of donation (or estimate of the probable value): travel, accommodation and food costs; total value approximately £1,530 | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 16 | 2012-07-09-80ef1083-24947-0 |
24623eba7fc0a1860d7aca69519e2fabf376c0e8 | Destination of visit: Berne, Switzerland | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 17 | 2012-07-09-80ef1083-24947-0 |
ba460b814b0f44bf4a9b753e74b56fd719fa74db | Date of visit: 13-17 September 2011 | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 18 | 2012-07-09-80ef1083-24947-0 |
e6abc690225cbef3b2a8797c13b47aeb62412cdc | Purpose of visit: to participate in a rail transport study tour and workshop | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 19 | 2012-07-09-80ef1083-24947-0 |
fb8fb5dee6761e7eb21e42440885dfb8d5e00383 | (Registered 12 October 2011) | Overseas visits 80ef1083 | 2012-07-09 | Iain Stewart uk.org.publicwhip/member/40404 | Iain Stewart uk.org.publicwhip/person/24947 | 20 | 2012-07-09-80ef1083-24947-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");