items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where person_id = "uk.org.publicwhip/person/10045" and sort_order = 23 sorted by member_id
This data as json, CSV (advanced)
Suggested facets: item, category_id, member_id, date (date)
hash | item | category_id | date | member_id ▼ | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
9262c28dbf88360932407cc2de2a28fbc69b03f3 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-08-13 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-08-13-10057ffd-10045-0 | |
f695565a6b129bccf77ec59912d18cde945d0669 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-09-10 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-09-10-10057ffd-10045-0 | |
1701034138594025a23e9bcba64e140925325d1d | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-10-01 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-10-01-10057ffd-10045-0 | |
07f429a2b8b4818f4fc863c64f3e530a8500d45e | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-10-15 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-10-15-10057ffd-10045-0 | |
0d6beda05600304d0538f335a9afd0def1399622 | 8 December 2017, payment of £60. Hours: 30 mins. (Registered 01 March 2018) | Employment and earnings 10057ffd | 2018-10-29 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-10-29-10057ffd-10045-0 | |
f8190d66ee1eaf94e624bbfe89a23531c058ab9b | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2018-11-19 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-11-19-10057ffd-10045-0 | |
7a654e7d59c13dd9b49da8c5f241f7e1ab848c2c | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2018-12-03 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-12-03-10057ffd-10045-0 | |
f60265997369015b63f0a5ab1f8dd613993d6554 | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2018-12-17 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2018-12-17-10057ffd-10045-0 | |
50ee9675729aa0891e5f92913a1a3145ce6268cf | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-01-21 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2019-01-21-10057ffd-10045-0 | |
ac1ca0477c9af560099aeb70cd3033468e32827d | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-02-04 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2019-02-04-10057ffd-10045-0 | |
c5fac207dc8e2f2d448f32125ae8770c1031b368 | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-02-18 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2019-02-18-10057ffd-10045-0 | |
9202143c7aa21bd46f69f28949c608c81c30ae79 | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-03-04 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2019-03-04-10057ffd-10045-0 | |
659418e344217fdfc51261296ef5b42ddd2ffeaa | 5 July 2018, payment of £70. Hours: 30 mins. (Registered 27 July 2018) | Employment and earnings 10057ffd | 2019-03-18 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2019-03-18-10057ffd-10045-0 | |
10104e2abc8ea8554e162a393d6f192522908237 | 27 September 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-01-13 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2012-01-13-1f359ece-10045-0 |
2d61dadd3ab3306ae29eaa69d735ec5815700937 | 27 September 2011, £75. Hours: 30 mins. (Registered 4 January 2012) | Remunerated employment, office, profession etc 1f359ece | 2012-01-30 | Clive Betts uk.org.publicwhip/member/40526 | Clive Betts uk.org.publicwhip/person/10045 | 23 | 2012-01-30-1f359ece-10045-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");