items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where person_id = "uk.org.publicwhip/person/10098" and sort_order = 3 sorted by category_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, member_id, date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
00f5f4a1fd3918f6ac54a8698da2e2804cf474bd | £75 for completing a survey. Hours: 30 mins. (Registered 24 November 2009) | Remunerated employment, office, profession etc 1f359ece | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-11-25-1f359ece-10098-0 |
b8716296d5ba68c03451a150b16ee7cf17714f51 | Fees for completing surveys from BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX. | Remunerated employment, office, profession etc 1f359ece | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-12-10-1f359ece-10098-0 |
c3caef4d1e89a259088f57a4a67955e46538623e | Fees for completing surveys from BPRI, 24-28 Bloomsbury Way, London, WC1A 2PX. | Remunerated employment, office, profession etc 1f359ece | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-01-06-1f359ece-10098-0 |
8a7e0cb782f291a09bc859dbb0d872c39ad5eed8 | £75 for participating in a survey. Hours: 30 mins. (Registered 11 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-02-03-1f359ece-10098-0 |
eb644d9ad655a69a42ead54142886bbf4f041af8 | £75 for participating in a survey. Hours: 30 mins. (Registered 11 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-02-24-1f359ece-10098-0 |
1a7f60632a30eaf5bbdce8700d1cbb7fcd83906a | £75 for participating in a survey. Hours: 30 mins. (Registered 11 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-03-10-1f359ece-10098-0 |
94513c9a571b8e0ed37c68f1cc5b43a3029f8c10 | £75 for participating in a survey. Hours: 30 mins. (Registered 11 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-03-24-1f359ece-10098-0 |
2b1c3fdf353a95f6c3c07e6469b9b92a5216da75 | £75 for participating in a survey. Hours: 30 mins. (Registered 11 January 2010) | Remunerated employment, office, profession etc 1f359ece | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-04-12-1f359ece-10098-0 |
1c82c68771f07abb5e2a2763066ab8c1a19ce444 | Commercial rented property in the Wirral. | Land and Property 4f1e6359 | 2000-11-10 | Ben Chapman uk.org.publicwhip/member/98 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2000-11-10-4f1e6359-10098-0 |
ae173a71185ee4c75d8ec0a871a57d091f4bf2f0 | Commercial rented property in the Wirral. | Land and Property 4f1e6359 | 2001-05-14 | Ben Chapman uk.org.publicwhip/member/98 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2001-05-14-4f1e6359-10098-0 |
48f1506ddf82870b5100b82397d25574c44772a5 | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2009-10-14 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-10-14-80ef1083-10098-0 |
fca435a1cf10e1a5c76f9242eb2f4ca8aec4bbef | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2009-10-28 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-10-28-80ef1083-10098-0 |
5e348d6ae5f9e68e336cf1963645ead8bc27cfda | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2009-11-11 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-11-11-80ef1083-10098-0 |
315fcf993e500c6ee568bf9c0bff6c5349b3f118 | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2009-11-25 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-11-25-80ef1083-10098-0 |
93ef045c3a962bac2ed449d69e2a122c5397303b | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2009-12-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2009-12-10-80ef1083-10098-0 |
81837e8c435aa3f999b4497573cfe176587f8d7b | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-01-06 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-01-06-80ef1083-10098-0 |
edf9505847785f15a2094b0c004eeed34fb2de8a | 2) Jiangsu Provincial People's Congress | Overseas visits 80ef1083 | 2010-02-03 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-02-03-80ef1083-10098-0 |
4b9d367481c589f4f1468d1de7f5544894481cb6 | Address of donor: 1) House of Commons | Overseas visits 80ef1083 | 2010-02-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-02-24-80ef1083-10098-0 |
c997005d99b4556c9370216bf89a4d930fb34611 | Address of donor: 1) House of Commons | Overseas visits 80ef1083 | 2010-03-10 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-03-10-80ef1083-10098-0 |
702b200d671038f257434751cc9021ad834d0e07 | Address of donor: 1) House of Commons | Overseas visits 80ef1083 | 2010-03-24 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-03-24-80ef1083-10098-0 |
73702c300a8e7f6e297d191c38d4a1e3190bee2b | Address of donor: 1) House of Commons | Overseas visits 80ef1083 | 2010-04-12 | Ben Chapman uk.org.publicwhip/member/1930 | Ben Chapman uk.org.publicwhip/person/10098 | 3 | 2010-04-12-80ef1083-10098-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");