items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where "date" is on date 2018-02-19 and person_id = "uk.org.publicwhip/person/10095" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: category_id, sort_order, record_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a59e0716e3f1ea3a64c519e06165286287abc2ef | Solicitor, William Cash & Co, The Tithe Barn, Upton Cresset, nr Bridgnorth, WV16 6UH. | Employment and earnings 10057ffd | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2018-02-19-10057ffd-10095-0 | |
f2c958865be1e82dcc9478a7ff6c9234430ec44a | 3 April 2017, received £30,000. Hours: 75 hrs. (Registered 28 April 2017) | Employment and earnings 10057ffd | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 1 | 2018-02-19-10057ffd-10095-0 | |
bd93aede751a8fee3886f3d5d4bbadd45b2ec1b6 | Name of donor: David E D Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £5,000 Donor status: individual (Registered 29 June 2017) | (a) Support linked to an MP but received by a local party organisation or indirectly via a central party organisation 2fa6c1a9 | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2018-02-19-2fa6c1a9-10095-0 | |
0e66d62e48f93045fb31a71a599395ea694e283e | Name of donor: (1) The People’s Movement against the EU (2) The Red Cell (UK think tank) Address of donor: (1) Tordenskjoldsgade 21, st.th. DK-1055 Copenhagen K, Denmark (2) Lynton Mansions, McAuley Close, London SE1 7BW Estimate of the probable value (or amount of any donation): flights £313; one night’s accommodation £80; dinner £50 and taxi transfers £120. The total value of £563 was divided (1) £63 and (2) £500 between the donors. Destination of visit: Aarhus, Denmark Dates of visit: 28-29 October 2017 Purpose of visit: to receive award to me in Denmark for promoting democracy and international cooperation in Europe. (Registered 16 November 2017; updated 28 November 2017) | Visits outside the UK 891eb863 | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2018-02-19-891eb863-10095-0 | |
b7059c54f4d56bb3a2ec54ba72a111d9788b60ae | Until September 2017, a half share in London rental property (residential): (i). (Registered 16 April 2012; updated 26 September 2017) | Land and property portfolio: (i) value over £100,000 and/or (ii) giving rental income of over £10,000 a year c0ee8024 | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2018-02-19-c0ee8024-10095-0 | |
e6540eb6477f8a6ffec8d20016fae52f4d560744 | Unremunerated Chairman of the European Foundation, an EU reform think tank which produces the European Journal. (Registered 26 September 2017) | Miscellaneous 5f2cbd10 | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2018-02-19-5f2cbd10-10095-0 | |
a317b3507955ce4d8a2fc6b25efe0de52e6b77d8 | I employ my wife, Bridget Cash, as Parliamentary Assistant. | Family members employed and paid from parliamentary expenses 59577839 | 2018-02-19 | Bill Cash uk.org.publicwhip/person/10095 | 0 | 2018-02-19-59577839-10095-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");