items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where person_id = "uk.org.publicwhip/person/10383" and sort_order = 7 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
c70db156701d56dae60ce575e0b08df3b4a8585d | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-06-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-06-06-8f616a6e-10383-0 |
eb006562fa7c010bda7bdba73877b8e618522a01 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-05-16-8f616a6e-10383-0 |
4fdc07d54622b6c06e9dab0c2ed12527acfcd00e | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-05-03 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-05-03-8f616a6e-10383-0 |
b00e0a88662694a0174c547c40a65b6fd1fca0c5 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-04-18 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-04-18-8f616a6e-10383-0 |
a43a572fc447ded020796fd19782d05169e2e9c4 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-03-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-03-28-8f616a6e-10383-0 |
18f1761e8600ca1ef5fa0ca0e71f51b1a5486e9e | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-03-14 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-03-14-8f616a6e-10383-0 |
ba998f279786929ec4cae9d088a581b203db4f56 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-02-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-02-28-8f616a6e-10383-0 |
57141c3dff5c93db5d816e3bc28386bb0581761f | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-02-07 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-02-07-8f616a6e-10383-0 |
bef7361452b6de29ef0a56168085c117f3b73882 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-01-24 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-01-24-8f616a6e-10383-0 |
30860b6d3733b6c31900463341cc368b347a7c74 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2011-01-10-8f616a6e-10383-0 |
2220f0258680fd0dcb407333384c8d8e66cf1738 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2010-12-20 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2010-12-20-8f616a6e-10383-0 |
3358783b43a98b43b5801bbad7ed882c1a878f10 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2010-12-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2010-12-06-8f616a6e-10383-0 |
6730f972dc6b8f913d017d7905adadde10f97222 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2010-11-22 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2010-11-22-8f616a6e-10383-0 |
e9f3346dc3138f533bbc0959ceafab718f6dacaf | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2010-11-08 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2010-11-08-8f616a6e-10383-0 |
350c60ed71c274510bb312701e46c951da8d9b96 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2010-10-25 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2010-10-25-8f616a6e-10383-0 |
12af31bf3d0cc37be55b519a2d00b257aeafd7e3 | Address of donor: 68 Coombe Road Kingston upon Thames Surrey KT2 7AE | Sponsorships 8f616a6e | 2010-09-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 7 | 2010-09-06-8f616a6e-10383-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");