items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
41 rows where person_id = "uk.org.publicwhip/person/10029" and sort_order = 4 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 |
---|---|---|---|---|---|---|---|
bd0510efb782fb94bd04d30bacc815cf8ed306b6 | Received payment of £75 on 20 December 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 | 4 | 2012-03-05-1f359ece-10029-0 |
78cca64f208de4031d4c43da21b5938d90fb05a3 | Received payment of £75 on 20 December 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 | 4 | 2012-03-19-1f359ece-10029-0 |
a16f6069bd19831c6452289a23a6827b53fbfb3c | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-16 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-04-16-1f359ece-10029-0 |
cec01966414462c822860e55521d65cc55ef7029 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-04-30 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-04-30-1f359ece-10029-0 |
38da4e070df23974e7a74f4129c8f38f16bb9454 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-05-14 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-05-14-1f359ece-10029-0 |
680a2caad409742c98bee466e54b729a74942c58 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-11 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-06-11-1f359ece-10029-0 |
714f4b9091a9b9cf62e8bca907723a28b991d80c | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-06-25 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-06-25-1f359ece-10029-0 |
1682d8680af89ef1f7f28766fc30d2119d42b045 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-09 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-07-09-1f359ece-10029-0 |
b732f0e3b13194277a0446aca83453c15b4c2fb3 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-07-30 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-07-30-1f359ece-10029-0 |
2d6dc6547f6138d00c12be6f2570aa5ace4051db | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-09-03 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-09-03-1f359ece-10029-0 |
a6cc27eea089d7ab95cd80bd59e4c63a6c1bda37 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-09-03 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-09-03-84642823-10029-0 |
fa09207031185fb9763be5da5a9e593a5ec811d1 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-01 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-10-01-1f359ece-10029-0 |
6cd858cb69e84974edf2ff7429e59a177a28d84d | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-10-01 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-10-01-84642823-10029-0 |
5bd578a8d7b18a6eaa527fffdd44a97eed57a9b8 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-10-22 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-10-22-1f359ece-10029-0 |
6ef1ce285273bd20d01a829b4ad448d7173f8f2a | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-10-22 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-10-22-84642823-10029-0 |
796cc9fe5f418474e36d49f3064032bc2d0a7007 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-05 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-11-05-1f359ece-10029-0 |
549f07c505593de9921a39fb3f02de234edbd7b5 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-11-05 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-11-05-84642823-10029-0 |
661230fd6ae3100517375c27cc56047b5eca0d03 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-11-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-11-19-1f359ece-10029-0 |
64ba187729cb3700c4945a2e9fa633f9fdffb322 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-11-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-11-19-84642823-10029-0 |
9e89d7fb059b8cc29ea0c09c699b0c813eccdf89 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-03 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-12-03-1f359ece-10029-0 |
dd5d812cc9714e038e1bd4c41970a66949c764c4 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-03 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-12-03-84642823-10029-0 |
da97c84b687d96f27cb577bbe41f29f18e5ff543 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-12-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-12-19-1f359ece-10029-0 |
3961c5dbc2967fb4099193e6f88092ceb52225fd | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2012-12-19 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2012-12-19-84642823-10029-0 |
29e11517486782c433cd820344773ef46d579594 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-01-18 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-01-18-1f359ece-10029-0 |
9d470f78973dcf38673473ccaa5533d3b0a33b32 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-01-18 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-01-18-84642823-10029-0 |
19a4df07469c75383cd503050603032b942eb62c | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-04 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-02-04-1f359ece-10029-0 |
f0a0932531b9bf580f842674fce290dbd74f35c6 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-02-04 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-02-04-84642823-10029-0 |
8b5709f5abc28ffed327acce7c548422a9a858c8 | Received payment of £75 on 13 February 2011. Hours: 45 mins. (Registered 23 February 2012) | Remunerated employment, office, profession etc 1f359ece | 2013-02-25 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-02-25-1f359ece-10029-0 |
c8065f769264fe4e8ec68b965bff878523305bff | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-02-25 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-02-25-84642823-10029-0 |
6108fb49b1f941a7fa479f09c2d23a84155f00be | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-03-11 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-03-11-84642823-10029-0 |
d8a88d639e1516292ba6a0e73755fc8ef4ef2593 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-04-08 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-04-08-84642823-10029-0 |
e46417181133254d93e22f11899e9db52904657f | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-04-22 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-04-22-84642823-10029-0 |
e1ee7e9c4ec5c995cbf8993fa95d891168f0cf55 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-05-07 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-05-07-84642823-10029-0 |
e6d6e5dd5d27f322e43095984b77fcb2f6a85de1 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-05-20 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-05-20-84642823-10029-0 |
70566c0f0ba0641be941f26ae867266b687391b3 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-10 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-06-10-84642823-10029-0 |
66fb4a40365f30759eb803d19800437c303a5c0a | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-06-24 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-06-24-84642823-10029-0 |
24085005344b2880929b6a2b8c0e7c3cf72aa0f8 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-08 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-07-08-84642823-10029-0 |
f2e7db34fcd93456bae3a9c35e9d66f798df8654 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-07-29 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-07-29-84642823-10029-0 |
ec6ec0f56d728cd738e0de6fb7d29fe19b771602 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-08-27 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-08-27-84642823-10029-0 |
1c894626e1251796dff21033c95f1e23b402c693 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-09 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 2013-09-09-84642823-10029-0 |
2a0c353f1cb60db3dfd97020f74c46f09c420867 | Date of acceptance of donation: 6 August 2012 | Gifts, benefits and hospitality (UK) 84642823 | 2013-09-30 | Hugh Bayley uk.org.publicwhip/member/40682 | Hugh Bayley uk.org.publicwhip/person/10029 | 4 | 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");