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 = 4 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 |
---|---|---|---|---|---|---|---|
38bcbc91de60655e5bba00a887c038bd0743a231 | Date of visit: 10-16 December 2011 | Overseas visits 80ef1083 | 2015-03-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2015-03-30-80ef1083-11048-0 |
cc8b6f230e5f937ebce09c4fbc55a65c3862c720 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-12-19 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-12-19-80ef1083-11048-0 |
1e572695787ffc6c6bfd1af7c667e366b856e415 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-12-03 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-12-03-80ef1083-11048-0 |
8a67d89b4bc298c8292bb0134445c2ab12b2f05e | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-11-19 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-11-19-80ef1083-11048-0 |
d5b85042709de4488f834107d0d409ef2818a369 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-11-05 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-11-05-80ef1083-11048-0 |
ad0d1f7c73fb007b2e8617dcd7c48ed53696112e | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-10-22 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-10-22-80ef1083-11048-0 |
7ada9b01800b993e1bc0ebde8bd575944d78df80 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-10-01 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-10-01-80ef1083-11048-0 |
865dffd31e69d1a8227eb381962da429de43fed6 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-09-03 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-09-03-80ef1083-11048-0 |
d4a98e222b50dd3df4165d5c8b387352cd154fad | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-07-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-07-30-80ef1083-11048-0 |
060189fef0696e5bcd9d486c68a684889505959f | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-07-09 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-07-09-80ef1083-11048-0 |
10f6b49a971519ed7159e8dc48a1253cb3b785a1 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-06-25 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-06-25-80ef1083-11048-0 |
41130e2c9737d64045474976bd001ac6c569197e | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-06-11 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-06-11-80ef1083-11048-0 |
4aee45eb8dae5c6f95b0e6f1ac78b6accd04b21a | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-05-14 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-05-14-80ef1083-11048-0 |
08acb65e34deeade7791ecf96090ea3436747943 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-04-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-04-30-80ef1083-11048-0 |
cced72f23bb5205fced55f28dc22b0fd601ee1fa | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-04-16 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-04-16-80ef1083-11048-0 |
a3283b538c1bcc30754228f7252e2d9b5d9b5dc3 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-03-19 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-03-19-80ef1083-11048-0 |
b70dc1b349373abf21e93f4dc35ed1c24026c727 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-03-05 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-03-05-80ef1083-11048-0 |
c2d459916355641fd4b395030997ad73b2260d59 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-02-20 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-02-20-80ef1083-11048-0 |
8872993477e17727d91642ad91769c23822cb69a | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-01-30 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-01-30-80ef1083-11048-0 |
4a622058e7c343e31de3fbd6dbba8025d61ac3c4 | Date of visit: 4-8 December 2011 | Overseas visits 80ef1083 | 2012-01-13 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2012-01-13-80ef1083-11048-0 |
c6fba400792f8742914063cbf0f66dcecdc449b8 | Date of visit:13 – 16 October 2009. | Overseas visits 80ef1083 | 2010-10-25 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-10-25-80ef1083-11048-0 |
feb7ab772e658f8a7dd4a5342e4dbce858ee5847 | Date of visit:13 – 16 October 2009. | Overseas visits 80ef1083 | 2010-09-06 | Ian Liddell-Grainger uk.org.publicwhip/member/40118 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-09-06-80ef1083-11048-0 |
d5ac6f0b4c0a9fe95c4193fb8f84f86cb788b2f9 | Date of visit:13 - 16 October 2009. | Overseas visits 80ef1083 | 2010-04-12 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-04-12-80ef1083-11048-0 |
1d13137368ebd2ae26471f89d10712177d9bf711 | Date of visit:13 - 16 October 2009. | Overseas visits 80ef1083 | 2010-03-24 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-03-24-80ef1083-11048-0 |
1971c06261210273159f7228687e26c68a6cf7cb | Date of visit:13 - 16 October 2009. | Overseas visits 80ef1083 | 2010-03-10 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-03-10-80ef1083-11048-0 |
0a9b0b19a8b5924aae82660302a68cb81a730c98 | Date of visit:13 - 16 October 2009. | Overseas visits 80ef1083 | 2010-02-24 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-02-24-80ef1083-11048-0 |
2a192858e0971270ce263be2377c6bf1b87b8367 | Amount of donation (or estimate of the probable value): £5609.41 | Overseas visits 80ef1083 | 2010-02-03 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-02-03-80ef1083-11048-0 |
b3379888458e1d048496ac44007b2756844c35cc | Amount of donation (or estimate of the probable value): £5609.41 | Overseas visits 80ef1083 | 2010-01-06 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2010-01-06-80ef1083-11048-0 |
99c1ad54681411a783473129c60ee770102f5521 | Amount of donation (or estimate of the probable value): £5609.41 | Overseas visits 80ef1083 | 2009-12-10 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2009-12-10-80ef1083-11048-0 |
11981583289beee84022ef6caf37c68851555bec | Amount of donation (or estimate of the probable value): £5609.41 | Overseas visits 80ef1083 | 2009-11-25 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 2009-11-25-80ef1083-11048-0 |
f614f2ede783e614133cff1f7104dc4436eb8eef | Amount of donation (or estimate of the probable value): £5609.41 | Overseas visits 80ef1083 | 2009-11-11 | Ian Liddell-Grainger uk.org.publicwhip/member/1451 | Ian Liddell-Grainger uk.org.publicwhip/person/11048 | 4 | 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");