items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2012-12-19-84642823-10648-0" 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 |
---|---|---|---|---|---|---|---|
cae3dce0a741c6b800b8d13b25428fbf3815b096 | Name of donor: Grand Central Railway Company Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 0 | 2012-12-19-84642823-10648-0 |
34766fb9533d272f71f0015eeb9a1cb6ef31a7ca | Address of donor : River House, 17 Museum Street, York YO1 7DJ | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 1 | 2012-12-19-84642823-10648-0 |
cef5607449e9c1c43ec332fed71736c46be08621 | Amount of donation or nature and value if donation in kind: Complimentary first class pass valid for travel on Grand Central services, expired 31 December 2011. The estimated value of the pass was £1,000. I used the card on two occasions in December 2011 to the value of £160. | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 2 | 2012-12-19-84642823-10648-0 |
d96c1d8e975619d38b0365848bfb1d7e8e5a8f4e | Date of receipt of donation: June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 3 | 2012-12-19-84642823-10648-0 |
0015b23a4a37a48e1ea6b01dcb4b86cc052f7ef2 | Date of acceptance of donation: June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 4 | 2012-12-19-84642823-10648-0 |
7376b92b5b89b477d094291f2dd9ffbb44f03b22 | Donor status: company, registration 03979826 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 5 | 2012-12-19-84642823-10648-0 |
fcb6a7a002ff33e974a9bad1fdb9fcb6545a8faf | (Registered 28 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Rosie Winterton uk.org.publicwhip/member/40207 | Rosie Winterton uk.org.publicwhip/person/10648 | 6 | 2012-12-19-84642823-10648-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");