items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
17 rows where person_id = "uk.org.publicwhip/person/24741" and sort_order = 22 sorted by date descending
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 |
---|---|---|---|---|---|---|---|
3ff38253d9ba3e261b5c668822223521cc112adc | 8 September 2016, received £200 for survey completed on 28 June 2016. Hours: 1 hr. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-10-17 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2016-10-17-10057ffd-24741-0 | |
6be06c1df3ef26494144f7dbf0ab02f1c047e816 | 8 September 2016, received £200 for survey completed on 28 June 2016. Hours: 1 hr. (Registered 08 September 2016) | Employment and earnings 10057ffd | 2016-10-03 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2016-10-03-10057ffd-24741-0 | |
679c5fd1374668def106293617593ac214ba6326 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-05-16 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-05-16-8f616a6e-24741-0 |
346eb990fdc0a1f3116f43cbe2ba1bfdf59be78d | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-05-03 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-05-03-8f616a6e-24741-0 |
00a32fced89324f5791550c1b8d63f160e3517b5 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-04-18 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-04-18-8f616a6e-24741-0 |
488db46130830bf17fb77f5601fa23de4e4f52ee | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-03-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-03-28-8f616a6e-24741-0 |
f934fd6e9f72c1019ea5331b0363ca5ffbeda18b | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-03-14 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-03-14-8f616a6e-24741-0 |
86442de3f52aa528713595438a93b4a9a3e3f857 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-02-28 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-02-28-8f616a6e-24741-0 |
b5ef8b21743eebb38f73af1adf32fcac8a14e7f8 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-02-07 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-02-07-8f616a6e-24741-0 |
533028b20f7c2f48dd8d84c568067c6cafe39278 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-01-24 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-01-24-8f616a6e-24741-0 |
d510f53d6da4eaf0c022f1e37fc24063ea52e152 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2011-01-10 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2011-01-10-8f616a6e-24741-0 |
81e3c740ebe3223e1cd84448a95d204d90298c5e | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2010-12-20 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2010-12-20-8f616a6e-24741-0 |
e97991a7076b9a1c413c50a827f585db05891f35 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2010-12-06 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2010-12-06-8f616a6e-24741-0 |
6abfc62f1d69edbdd573c4d812aaac3d93d79e6d | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2010-11-22 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2010-11-22-8f616a6e-24741-0 |
cb3b1eb27ed699f9b864f76b7a78c1a33fed45f1 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2010-11-08 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2010-11-08-8f616a6e-24741-0 |
7ddc90c332952e2bec7266fb83cab3e9559b3d81 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2010-10-25 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2010-10-25-8f616a6e-24741-0 |
f1edc4642ae97890dbcae0decb9cac6c2dbb0dc4 | Name of donor: AB Produce PLC | Sponsorships 8f616a6e | 2010-09-06 | Andrew Bridgen uk.org.publicwhip/member/40453 | Andrew Bridgen uk.org.publicwhip/person/24741 | 22 | 2010-09-06-8f616a6e-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");