items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
19 rows where record_id = "2010-02-24-8f616a6e-11506-0" 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 |
---|---|---|---|---|---|---|---|
c2b1db267d9b1f13f91a808fd686af401578e793 | Address of donor: private | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 1 | 2010-02-24-8f616a6e-11506-0 |
9ffe3e93b2c162a80e484bff6d3c9614b0b73253 | Amount of donation or nature and value if donation in kind: £500 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 2 | 2010-02-24-8f616a6e-11506-0 |
bbe101558782a90b82ec6c845cd8f187964229ba | Date of receipt: 8 January 2009 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 3 | 2010-02-24-8f616a6e-11506-0 |
6d021f6210db21ecb8840d8e7792a72b2c8c40d4 | Date of acceptance: 8 January 2009 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 4 | 2010-02-24-8f616a6e-11506-0 |
c4a69b78ef93c3522a24224191dec115ca30dc78 | Donor status: Individual | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 5 | 2010-02-24-8f616a6e-11506-0 |
77592ac38e1bdfc549121be08443a4a4256ca0b5 | Amount of donation or nature and value if donation in kind: £500 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 7 | 2010-02-24-8f616a6e-11506-0 |
5a80db1528028689caea04e8c32b30e48dd1df07 | Date of receipt: 5 February 2009 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 8 | 2010-02-24-8f616a6e-11506-0 |
32b6a46cccd7381fbea650230e8a2320df882e9e | Date of acceptance: 5 February 2009 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 9 | 2010-02-24-8f616a6e-11506-0 |
3e764da6a7015afb9d088a6acf028bc6f5979f85 | Amount of donation or nature and value if donation in kind: £1000 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 11 | 2010-02-24-8f616a6e-11506-0 |
264a96c7b5ffa6bd8fff6429baab19c84eaa38dd | Date of receipt: 14 May 2009 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 12 | 2010-02-24-8f616a6e-11506-0 |
cdaca84245ec391a0716286645a7a8aef22fb6f3 | Date of acceptance: 14 May 2009 | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 13 | 2010-02-24-8f616a6e-11506-0 |
4d9b063d3675eb2f9c315467a80e1921e5214848 | (Registered 20 July 2009) | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 14 | 2010-02-24-8f616a6e-11506-0 |
9e9485d614713955c54c8e6e736b5a982adf682f | Amount of donation or nature and value if donation in kind: £500 (given to constituency association) | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 17 | 2010-02-24-8f616a6e-11506-0 |
c1d389056fdc06d873b92e050924c7c75b240aa1 | (Registered 3 December 2009) | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 19 | 2010-02-24-8f616a6e-11506-0 |
b4d8810882b7f679363bacea4eef0ade508345e0 | Name of donor: Mrs Elizabeth Culshaw | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 20 | 2010-02-24-8f616a6e-11506-0 |
0f5134c42e4d8993c8be53c7f8d5edfc4b8eb70a | Address of donor: private | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 21 | 2010-02-24-8f616a6e-11506-0 |
bbbfbbf999aff971c01a8227dc3428951c9a1da7 | Amount of donation or nature and value if donation in kind: £500 (given to constituency association in 2009) | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 22 | 2010-02-24-8f616a6e-11506-0 |
e147b40b66b497dd9987dd90f49a54835bc25763 | Donor status: individual | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 23 | 2010-02-24-8f616a6e-11506-0 |
382a2015ee990fb288a92d2f179e068ddcccb8bc | (Registered 6 January 2010) | Sponsorships 8f616a6e | 2010-02-24 | David Jones uk.org.publicwhip/member/1506 | David Jones uk.org.publicwhip/person/11506 | 24 | 2010-02-24-8f616a6e-11506-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");