items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
24 rows where person_id = "uk.org.publicwhip/person/10029" and sort_order = 5 sorted by person_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date (date)
hash | item | category_id | date | member_id | person_id ▼ | sort_order | record_id |
---|---|---|---|---|---|---|---|
bd69b1bdb63dda8453e12a30d0f7beeff0a70b16 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-05 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-03-05-1f359ece-10029-0 |
835ae80e94a90560c76797b3051a44e8e785d699 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-03-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-03-19-1f359ece-10029-0 |
f8634ed26b151f80330cd4a4e365d11626cf883d | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-09-03 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-09-03-84642823-10029-0 |
2a9cd08e7f3211d9e1aff594628281dba0f7c975 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-10-01 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-10-01-84642823-10029-0 |
0e642f2fed53a99e7c432b23bb408accdbef401b | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-10-22 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-10-22-84642823-10029-0 |
3346dd523538f650dc7fd28dce03b28033edd4a1 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-11-05 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-11-05-84642823-10029-0 |
27af29986c047db1e39e19f0ca21223410b60414 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-11-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-11-19-84642823-10029-0 |
12826f25f4af7715405d800b9005a2f98ca67666 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-03 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-12-03-84642823-10029-0 |
3eb58eb1be2599ad0df10f66205592190997a2c1 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2012-12-19-84642823-10029-0 |
beb9764efad45a62915ecc1da1000e873f33670c | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-01-18 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-01-18-84642823-10029-0 |
56037a68854d64f08eebab5a8e4d6267ffbd5e3f | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-02-04 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-02-04-84642823-10029-0 |
726253080f4ddf4bd3257872dc1ea73eaaf0d0d9 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-02-25 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-02-25-84642823-10029-0 |
dba69b1c7c62e7a4056e6628973b76485df4ad00 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-03-11 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-03-11-84642823-10029-0 |
5594ca64dc4944b3a39bc22ceff580eff0f248d4 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-04-08 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-04-08-84642823-10029-0 |
540a924c7f31e940810599f5e30c07ede0d67825 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-04-22 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-04-22-84642823-10029-0 |
c3217643ec02465511a2e39f6fd6144fa0df88f1 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-05-07 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-05-07-84642823-10029-0 |
ed571a93b058b89218c79cfd8173bb7c271703dd | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-05-20 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-05-20-84642823-10029-0 |
9e731d5a0addbd3e298119f82241fc812f2ce8d8 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-06-10-84642823-10029-0 |
ab14a98af30c962a970e45a23ce81c69472251fb | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-06-24-84642823-10029-0 |
587d7b71488bb5fd6a64a67744b902b4c45aacd7 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-07-08-84642823-10029-0 |
555c45ef2ba7abd636ea1a86379c44c3fb72fb0d | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-07-29-84642823-10029-0 |
e2d66e45fa8a16c7b8eea357d3601b9f02a587d0 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-08-27-84642823-10029-0 |
e2deb4353d71b57b44f8cb87b780f7234cdf0a70 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-09 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-09-09-84642823-10029-0 |
b63e5364be61dc542c9e65a2d449c401d3404417 | Donor status: company, registration no 51491 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 5 | 2013-09-30-84642823-10029-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");