items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-02-23-8f616a6e-24851-5" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
38699293db8ac49ba708d56d992891eb427e73a7 | Name of donor: PricewaterhouseCoopers LLP | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 0 | 2015-02-23-8f616a6e-24851-5 |
9bb9f1ed1d056f6c1e9d64c1c1852cb21813c8b6 | Address of donor: Plumtree Court, London EC4A 4HT | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 1 | 2015-02-23-8f616a6e-24851-5 |
2191415cb8d1536328962baf0b3e0e7444636f40 | Amount of donation or nature and value if donation in kind: analyst to support me in my role as Shadow Work and Pensions Secretary from 20 October 2014 to 31 March 2015, at a value of £63,045 | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 2 | 2015-02-23-8f616a6e-24851-5 |
61ba28be68c9ce87cc5a85d2171a5e7aeac61265 | Date of receipt: 20 October 2014 | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 3 | 2015-02-23-8f616a6e-24851-5 |
27286445d8adccb9e97edf2ac3a2627c57fd6eff | Date of acceptance: 20 October 2014 | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 4 | 2015-02-23-8f616a6e-24851-5 |
af9a4aad553302cc7271e0e191f385a16d6b7276 | Donor status: limited liability partnership | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 5 | 2015-02-23-8f616a6e-24851-5 |
3d03315e3f3e54d33c6acc44109497ccc4b0c141 | (Registered 17 October 2014; updated 14 November 2014, 16 December 2014) | Sponsorships 8f616a6e | 2015-02-23 | Rachel Reeves uk.org.publicwhip/member/40357 | Rachel Reeves uk.org.publicwhip/person/24851 | 6 | 2015-02-23-8f616a6e-24851-5 |
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");