items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2011-01-24-84642823-10076-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 |
---|---|---|---|---|---|---|---|
8628110634666963550baa921acde1a9e5edc559 | Name of donor: British Racing Drivers Club | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 0 | 2011-01-24-84642823-10076-0 |
8c9dbc157f428bf41ed30757ef99bae614d3e919 | Address of donor: Silverstone Circuit Silverstone Towcester Northamptonshire NN12 8TN | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 1 | 2011-01-24-84642823-10076-0 |
ec6c8616a69453af5b39fb0c44994ca73c8243fe | Amount of donation or nature and value if donation in kind: two tickets to British Grand Prix, total value £782 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 2 | 2011-01-24-84642823-10076-0 |
5eae980160182ed3bf750a3b02b757c562d44b93 | Donor status: club | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 5 | 2011-01-24-84642823-10076-0 |
86a03172f239892c13ed25ebfb4d7a872c35068d | Name of donor: Motor Sports Association | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 7 | 2011-01-24-84642823-10076-0 |
ff4346890b4ca10c78503832c69072a5b6431b87 | Address of donor: Motorsports House Riverside Park Colnbrook SL3 0HG | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 8 | 2011-01-24-84642823-10076-0 |
92a532479e2324ae9d508a976e22241ffa5c9fbf | Amount of donation or nature and value if donation in kind: two tickets to British Grand Prix, total value £782. | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 9 | 2011-01-24-84642823-10076-0 |
047fb11de592793d0aec4999ef027e896f7e1239 | Date of receipt: 11 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 10 | 2011-01-24-84642823-10076-0 |
6524c80962f0b9d02bf40a989d398a353004f87c | Date of acceptance: 11 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 11 | 2011-01-24-84642823-10076-0 |
3390836c6e578cb8f2cdf5dc70b34aa993bf84d2 | Donor status: company No 1344829 | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 12 | 2011-01-24-84642823-10076-0 |
5f7b68b57360089a50eaec26a1ae5fde714794ca | (Registered 10 June 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-01-24 | Richard Burden uk.org.publicwhip/member/40085 | Richard Burden uk.org.publicwhip/person/10076 | 13 | 2011-01-24-84642823-10076-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");