items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-04-30-84642823-11843-0" sorted by hash
This data as json, CSV (advanced)
Suggested facets: date (date)
hash ▼ | item | category_id | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
001b24cd1a4ba0faa2b9234941f1b491e7646f8f | Date of acceptance of donation: 1 June 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 4 | 2012-04-30-84642823-11843-0 |
66a8337d10412777cba0e29406b22920f330fb19 | Name of donor: Stoke-on-Trent City Council | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 0 | 2012-04-30-84642823-11843-0 |
67cd093795b12ac7f930b0740778b86b7c1825ea | (Registered 19 July 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 6 | 2012-04-30-84642823-11843-0 |
88c5794ce5276a9fd190fcc6ad09019620f59a56 | Date of receipt of donation: 1 June 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 3 | 2012-04-30-84642823-11843-0 |
be3dfa5d62a36bd64712329396d6f1c6a7e31c1b | Address of donor: Civic Centre, Glebe Street, Stoke, ST4 1RN. | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 1 | 2012-04-30-84642823-11843-0 |
fe104e59088ba75c09667a0d478eb39a60e7983a | Amount of donation or nature and value if donation in kind: provision of council parking permit. Estimated value: £750. | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 2 | 2012-04-30-84642823-11843-0 |
fe7625a5e3b28d4ecfcccc70e79d4fd94e9aba83 | Donor status: local authority | Gifts, benefits and hospitality (UK) 84642823 | 2012-04-30 | Robert Flello uk.org.publicwhip/member/40583 | Rob Flello uk.org.publicwhip/person/11843 | 5 | 2012-04-30-84642823-11843-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");