items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
11 rows where record_id = "2016-12-19-10057ffd-24741-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a23978cb5138e3417acae6381d7ece5c53074f0e | Payments from ComRes, 4 Millbank, London SW1P 3JA, for opinion surveys. All payments donated to North West Leicestershire Conservative Association. | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 0 | 2016-12-19-10057ffd-24741-0 | |
2c22540af484593d8ccad9a7cf5c9825fb0877c5 | 14 January 2016, received £75 for survey completed on 27 October 2015. Hours: 30 mins. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 1 | 2016-12-19-10057ffd-24741-0 | |
fdca7b797b432e52d9800ed7629f9d289335155b | 20 January 2016, received £75 for survey completed on 26 November 2015. Hours: 30 mins. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 2 | 2016-12-19-10057ffd-24741-0 | |
a96ff7764484d0ac0c594149e59dcdd113e9c032 | 14 April 2016, received £100 for survey completed on 25 January 2016. Hours: 45 mins. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 3 | 2016-12-19-10057ffd-24741-0 | |
1795226bc19d15648dd7a82cfb3025ebea0ef51a | 17 May 2016, received £75 for survey completed on 30 March 2016. Hours: 30 mins. (Registered 17 May 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 4 | 2016-12-19-10057ffd-24741-0 | |
d734b1800e0c6b3faa0bc08ed3ce83695cb83342 | Payments from YouGov, 50 Featherstone Street, London, EC1Y 8RT. All payments donated to North West Leicestershire Conservative Association. | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 5 | 2016-12-19-10057ffd-24741-0 | |
0982077045bfddd3fe39323d5f69825717ede188 | 14 December 2015, £30 received for survey completed on 29 November 2015. Hours: 30 mins. (Registered 21 January 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 6 | 2016-12-19-10057ffd-24741-0 | |
a02adacf1513c851dcca294121b5fb39ec6a0216 | Payments from Ipsos MORI, 3 Thomas More Square, London E1W 1YW, for opinion surveys. All payments donated to North West Leicestershire Conservative Association. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 7 | 2016-12-19-10057ffd-24741-0 | |
f4ee7e6742b947a6980c735b7ed3a09a2475c590 | 12 January 2016, received £200 for survey completed on 24 November 2015. Hours: 1 hr. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 8 | 2016-12-19-10057ffd-24741-0 | |
320d85382de2238f5e6c2ed65c088ce9e0a9393d | 13 July 2016, received £80 for survey completed on 10 May 2016. Hours: 30 mins. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 9 | 2016-12-19-10057ffd-24741-0 | |
07278fa441b89ead423bdc37071754151da928b7 | 8 September 2016, received £200 for survey completed on 28 June 2016. Hours: 1 hr. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-12-19 | Andrew Bridgen uk.org.publicwhip/person/24741 | 10 | 2016-12-19-10057ffd-24741-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");