items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where person_id = "uk.org.publicwhip/person/10397" and sort_order = 13 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 |
---|---|---|---|---|---|---|---|
76d6bf2955765f17a2c7ddc33f0f49de09ff3580 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-06-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-06-06-8f616a6e-10397-0 |
221b6eed06d488686e7df28a18b817cf137597e4 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-05-16 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-05-16-8f616a6e-10397-0 |
600bb44617cde3d1729faeae3586eaed3d5c2b8b | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-05-03 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-05-03-8f616a6e-10397-0 |
1780b36b475037fa04f113f67c503aa4a34c045f | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-04-18 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-04-18-8f616a6e-10397-0 |
4eb60167f69c53d83def57988beb1cecfce5254c | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-03-28 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-03-28-8f616a6e-10397-0 |
4a2e45e49ccef0d109e26a2976cc3a7f10e6a3e9 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-03-14 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-03-14-8f616a6e-10397-0 |
b74db603aa37d72912367a2ff78bc52c3fda9114 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-02-28 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-02-28-8f616a6e-10397-0 |
00c8ae522b86077eb540fa7ff2473a786bed6740 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-02-07 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-02-07-8f616a6e-10397-0 |
ed0d3fd3c51e10c64708148a913caea2257ceaf3 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-01-24 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-01-24-8f616a6e-10397-0 |
54b7b5b9f56b0d71f7dbc2e7138d15b56da593f3 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2011-01-10 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2011-01-10-8f616a6e-10397-0 |
090becacd8369b128b89de555e053ef3fa9269fc | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-12-20 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-12-20-8f616a6e-10397-0 |
fb47afa68f2d01ac74f27ca17ef7c32a6c4f8fc2 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-12-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-12-06-8f616a6e-10397-0 |
a215d22cd2860867205787d7b515cd39f8c0c59f | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-11-22 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-11-22-8f616a6e-10397-0 |
e432f224d436c009f030924d15cf22bfd1e2f4db | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-11-08 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-11-08-8f616a6e-10397-0 |
c9807fe458e2a1eda71272092f772239fea357cb | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-10-25 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-10-25-8f616a6e-10397-0 |
e88d1037837b5f0ad59e112be6097999b0fccf39 | Amount of donation or nature and value if donation in kind: £5,000. | Sponsorships 8f616a6e | 2010-09-06 | Patrick McLoughlin uk.org.publicwhip/member/40203 | Patrick McLoughlin uk.org.publicwhip/person/10397 | 13 | 2010-09-06-8f616a6e-10397-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");