items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
31 rows where person_id = "uk.org.publicwhip/person/11048" and sort_order = 3 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
65902be92e9e0d187b3cd4134e5682417c46207b | Destination of visit: Vietnam | Overseas visits 80ef1083 | 2015-03-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2015-03-30-80ef1083-11048-0 |
90841d153affa8601e9fdc24e90fba3bb2de935f | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-12-19 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-12-19-80ef1083-11048-0 |
7303edf3ce1f3c07c8f35848e79a5d0d36d20c51 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-12-03 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-12-03-80ef1083-11048-0 |
f3ade6d1e1f1f09ebb6e75c02abae7fa2a0ba96d | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-11-19 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-11-19-80ef1083-11048-0 |
4449dbac12e9745d1b03c22a73e43d56e485d1ec | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-11-05 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-11-05-80ef1083-11048-0 |
1fe603b7423171b5cf090032e00a719a55e175b8 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-10-22 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-10-22-80ef1083-11048-0 |
0f6711cf6aca1a86399000075d365bb56f62bdb2 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-10-01 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-10-01-80ef1083-11048-0 |
017c3ff210c1646bc3909f5c9663a06164d518e4 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-09-03 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-09-03-80ef1083-11048-0 |
473d8c39c0a8ba68e699f77927cf07bfbf4bb3ba | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-07-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-07-30-80ef1083-11048-0 |
f4f1300321de6c1b6bdc422ca55b7f580b5dd9d4 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-07-09 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-07-09-80ef1083-11048-0 |
6a60b25f0bbf23d58f70d0e109700e31a9408b87 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-06-25 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-06-25-80ef1083-11048-0 |
2e12bffec3e25658e09abf394ec0698400b94cd9 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-06-11 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-06-11-80ef1083-11048-0 |
93146bb48e360abca463e208a147f740a80452b1 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-05-14 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-05-14-80ef1083-11048-0 |
15786100d09fc34b0d50b1f63f6bb991563d1893 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-04-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-04-30-80ef1083-11048-0 |
c178e7d327e1fef0a2da97f85a39b6468b02f2f6 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-04-16 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-04-16-80ef1083-11048-0 |
9a5fc10bd3843c28ec43a108bd301868234d139a | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-03-19 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-03-19-80ef1083-11048-0 |
f60a23bc184e15dcbbcb28a9dce129422a2ce1bd | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-03-05 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-03-05-80ef1083-11048-0 |
ecb2258d77120a6598ae003de02fe73e49c1f23b | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-02-20 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-02-20-80ef1083-11048-0 |
98f36d46c3c6cd2ce48c0f8cc7b3c9dace3d1b7b | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-01-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-01-30-80ef1083-11048-0 |
fe603dafdfb34de1310f6d0241ed7f9f0cd26f49 | Destination of visit: Riyadh, Saudi Arabia | Overseas visits 80ef1083 | 2012-01-13 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2012-01-13-80ef1083-11048-0 |
da04b59828eb2b31e9dcd906174ef52ddf9c1853 | Destination of visit: Washington, USA. | Overseas visits 80ef1083 | 2010-10-25 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-10-25-80ef1083-11048-0 |
bf34ae2f023b6ddff193a4bf346bc844d4b07a69 | Destination of visit: Washington, USA. | Overseas visits 80ef1083 | 2010-09-06 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-09-06-80ef1083-11048-0 |
000be50e0dbc18dbdddde850cc161ee607ac3a70 | Destination of visit: Washington, USA. | Overseas visits 80ef1083 | 2010-04-12 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-04-12-80ef1083-11048-0 |
cfb11b59a8738950b2c0e06eeee3c60d0d0587fe | Destination of visit: Washington, USA. | Overseas visits 80ef1083 | 2010-03-24 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-03-24-80ef1083-11048-0 |
73db42dde9ae105a7c4a2967bde08dfd36f93e3e | Destination of visit: Washington, USA. | Overseas visits 80ef1083 | 2010-03-10 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-03-10-80ef1083-11048-0 |
1682233babf22e55ddd3697d5196838bde1ed0c0 | Destination of visit: Washington, USA. | Overseas visits 80ef1083 | 2010-02-24 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-02-24-80ef1083-11048-0 |
de2d773f8c1ccff13e181c39be98db44881ecf7d | Address of donor: 1401 Eye Street NW, Suite 505, Washington, DC 20005, USA. | Overseas visits 80ef1083 | 2010-02-03 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-02-03-80ef1083-11048-0 |
f78e8825011b7e6aa5adebfa5b1caa3d6fff909f | Address of donor: 1401 Eye Street NW, Suite 505, Washington, DC 20005, USA. | Overseas visits 80ef1083 | 2010-01-06 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2010-01-06-80ef1083-11048-0 |
a7c92279114a338ec4f4ba00309019a24a46f884 | Address of donor: 1401 Eye Street NW, Suite 505, Washington, DC 20005, USA. | Overseas visits 80ef1083 | 2009-12-10 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2009-12-10-80ef1083-11048-0 |
8702ca5e60bf3c4467e1b813c4d97d706d8891ce | Address of donor: 1401 Eye Street NW, Suite 505, Washington, DC 20005, USA. | Overseas visits 80ef1083 | 2009-11-25 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2009-11-25-80ef1083-11048-0 |
9c97bc1d5146b109e91b3db1fefff3029cbe29c8 | Address of donor: 1401 Eye Street NW, Suite 505, Washington, DC 20005, USA. | Overseas visits 80ef1083 | 2009-11-11 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 3 | 2009-11-11-80ef1083-11048-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");