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 = 12 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 |
---|---|---|---|---|---|---|---|
537e5da4b5925cd6af88875802932b6ebed315f3 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-06-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-06-06-8f616a6e-10383-0 |
78eca022e2b68ae6d32245fdf9edb017a85da001 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-05-16 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-05-16-8f616a6e-10383-0 |
82e5468e200b0c18cff263745913d53886f50ce2 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-05-03 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-05-03-8f616a6e-10383-0 |
ed38b59994c9a5e668a80715cd8026157849af86 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-04-18 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-04-18-8f616a6e-10383-0 |
383c22f9cc2b6406989e72fe2049e6fcb060aa8f | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-03-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-03-28-8f616a6e-10383-0 |
837c01b9cd3bb16635220f646773b10b68c3266b | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-03-14 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-03-14-8f616a6e-10383-0 |
7a919f57e18e0f24d8ab3b891e44104806d1322a | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-02-28 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-02-28-8f616a6e-10383-0 |
b05fe654dbfd34826d5b1f4f9732249f4eba5b78 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-02-07 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-02-07-8f616a6e-10383-0 |
b8575747ddc398d9f9f1860d16b1bb6333700612 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-01-24 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-01-24-8f616a6e-10383-0 |
034691bbf4c10a4da86c821f3be81a9cd465a0d8 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2011-01-10 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2011-01-10-8f616a6e-10383-0 |
043d852027ede96f2a66c00d046770960ac2faea | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2010-12-20 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2010-12-20-8f616a6e-10383-0 |
7b2972cbb47056053a3d8df2a94186d50fd1acaf | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2010-12-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2010-12-06-8f616a6e-10383-0 |
8880e3070a4572cd673968c7921992820d7d3b06 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2010-11-22 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2010-11-22-8f616a6e-10383-0 |
83d2a2a38d9d16bda42f53f6d9e1b0c8e596c03f | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2010-11-08 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2010-11-08-8f616a6e-10383-0 |
309b8c13d5c0624dcfe5f7e7866db993074d7d66 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2010-10-25 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 2010-10-25-8f616a6e-10383-0 |
d39d5616146fd7ac4c9b86cc77e3787531c9f289 | Address of donor: Unity House, 39 Charlton Street London NW1 1JD, 622 Skyline Plaza Alencon Link Basingstoke Hants RG21 7AX and 2 Kings Road Great Yarmouth Norfolk NR30 3JW | Sponsorships 8f616a6e | 2010-09-06 | John McDonnell uk.org.publicwhip/member/40306 | John Martin McDonnell uk.org.publicwhip/person/10383 | 12 | 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");