items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
26 rows where category_id = "a41b9847" and person_id = "uk.org.publicwhip/person/10678" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date (date)
member_id 1 ✖
- David Lammy 26
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a9257209a64d4020dce0ec88be118041c147ee76 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2015-03-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-30-a41b9847-10678-0 |
08cb9691454129840aa5b33d6c1b03cc7142ec9b | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2015-03-09 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-03-09-a41b9847-10678-0 |
dceaf547fe18d83d3328644053c1984556f6a2c4 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2015-02-23 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-02-23-a41b9847-10678-0 |
4a1e47ada2f6516126afb5d1355c713b1ac7834b | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2015-02-09 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-02-09-a41b9847-10678-0 |
d2f8dd9bf11a3d454883c26cd1927f81e4cbbcce | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2015-01-26 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-01-26-a41b9847-10678-0 |
2633a5a795de0a0267c61f16860f2f7ef175ea23 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2015-01-06 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2015-01-06-a41b9847-10678-0 |
147615aea25b68eb720bd9c8e6fcd0798ea5a448 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2014-12-08 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-12-08-a41b9847-10678-0 |
b9fc07e1c0a0c75810016ac3eb876e45568f39d2 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2014-11-24 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-11-24-a41b9847-10678-0 |
5cc2f3625cef2448ca65babc645d39436d78d0d0 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2014-11-10 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-11-10-a41b9847-10678-0 |
1b9059842d2efed20466bd8b06e12fcc0182ff67 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2014-10-27 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-10-27-a41b9847-10678-0 |
4d5f8e68e1eb01f4d1ae796cef03acd651697d93 | See my entries in Category 2. | Overseas benefits and gifts a41b9847 | 2014-10-13 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-10-13-a41b9847-10678-0 |
7a64da94e78f1d34c295395bf36fccacb58ef1eb | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-09-22 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-09-22-a41b9847-10678-0 |
676e1b62d3d2466079bb4fab6c833de380a74422 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-08-26 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-08-26-a41b9847-10678-0 |
671cbdab1f853e942f8c6d8656088a834d3bdde2 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-07-28 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-07-28-a41b9847-10678-0 |
af98f0fc6207cd3b5f8ee6603f5d34d3adfa7a78 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-07-14 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-07-14-a41b9847-10678-0 |
bfba2d27c8610e765908dfe63c33ca47f9088f0b | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-06-30 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-06-30-a41b9847-10678-0 |
58687e7e17cb003d12af3a2f0e313181882949b0 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-06-16 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-06-16-a41b9847-10678-0 |
813102d0e8e4ba1e15ae6aa4264f481989e6540a | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-06-02 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-06-02-a41b9847-10678-0 |
1a97a8b7edd05579764004f51ec423af9f2df196 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-05-12 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-05-12-a41b9847-10678-0 |
9ced008080f1c0fd96899f49ea063b19be237365 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-04-28 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-04-28-a41b9847-10678-0 |
cd5bb62fd4db4943b1cb033151d2f0f13fceb7ea | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-04-07 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-04-07-a41b9847-10678-0 |
05c8630408d9cebf2068e29e211529146714b68d | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-03-24 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-03-24-a41b9847-10678-0 |
6f8f19599d467ac6e5e2f26585e083456fa40efe | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-03-21 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-03-21-a41b9847-10678-0 |
f1d6f243de502ebcc578b429e2e25974a611b09a | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-03-10 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-03-10-a41b9847-10678-0 |
2a06add6c88c5fe7ed3e3b1b06d858a4a3d9248e | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-02-24 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-02-24-a41b9847-10678-0 |
31a1e425b2511468b3ef47a6669ef45221666f18 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2014-02-03 | David Lammy uk.org.publicwhip/member/40615 | David Lammy uk.org.publicwhip/person/10678 | 0 | 2014-02-03-a41b9847-10678-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");