items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-02-23-8f616a6e-24847-1" 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 |
|---|---|---|---|---|---|---|---|
| f3ce31cc8c0951afa7891bbd83f63fec9a18f7ad | Name of donor: CARE (Christian Action Research and Education) | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 0 | 2015-02-23-8f616a6e-24847-1 |
| 0aef09c74acc306e9dffbdc0718b79b3bc07bf1f | Address of donor: 53 Romney St, London SW1P 3RF | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 1 | 2015-02-23-8f616a6e-24847-1 |
| c83db60c29f3842e3037d7051c19117db939735d | Amount of donation or nature and value if donation in kind: Four days a week voluntary service from October 2013 to July 2014 provided by a volunteer intern who is self funding except for a bursary of £7,150 as a member of the educational leadership programme at the charity CARE. | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 2 | 2015-02-23-8f616a6e-24847-1 |
| 47fc76eb42c68d7dc0a29ce05c0134ad2084943d | Date of receipt: 22 October 2013 | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 3 | 2015-02-23-8f616a6e-24847-1 |
| fee6f766e8fdfe964f8f5712bf266ae8b1f9ae15 | Date of acceptance: 22 October 2013 | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 4 | 2015-02-23-8f616a6e-24847-1 |
| 89fe9f37c7308b16065f7f25f120af85666e990c | Donor status: company, registration 3481417 | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 5 | 2015-02-23-8f616a6e-24847-1 |
| d655ef53da62e8b035c3d5dfa401b59bb27ed68f | (Registered 30 October 2013) | Sponsorships 8f616a6e | 2015-02-23 | Gavin Shuker uk.org.publicwhip/member/40380 | Gavin Shuker uk.org.publicwhip/person/24847 | 6 | 2015-02-23-8f616a6e-24847-1 |
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");