items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2023-03-20-64e8edeb-10312-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 |
|---|---|---|---|---|---|---|---|
| 203a252aa2bc2801b3e7cbdc6a8576895d773e94 | Name of donor: Jon Moynihan Address of donor: private Amount of donation or nature and value if donation in kind: Provision of food and drink for a briefing dinner hosted by me at a private residence on 1 February 2022, total value £744 Date received: 1 February 2022 Date accepted: 1 February 2022 Donor status: individual (Registered 01 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 0 | 2023-03-20-64e8edeb-10312-0 | |
| f7a525f169b7ccf0c8f4542f4257211e8e866f3e | Name of donor: Jon Moynihan Address of donor: private Amount of donation or nature and value if donation in kind: Provision of food, drink and staff, for a briefing dinner hosted by me at a private residence on 25 January 2022, total value £1,203.38 Date received: 25 January 2022 Date accepted: 25 January 2022 Donor status: individual (Registered 03 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 1 | 2023-03-20-64e8edeb-10312-0 | |
| 285b5616cdec664f9b5189c5455c4d1ec63ae0e9 | Name of donor: Jon Moynihan Address of donor: private Amount of donation or nature and value if donation in kind: Provision of food, drink and staff, for a briefing dinner hosted by me at a private residence on 26 January 2022, total value £1,279.63 Date received: 26 January 2022 Date accepted: 26 January 2022 Donor status: individual (Registered 03 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 2 | 2023-03-20-64e8edeb-10312-0 | |
| 471bf1856bb7613cab6e0b824ef9c69f09d802c5 | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: Provision of a briefing dinner, including food and wines etc, hosted by me in Parliament on 8 February 2022, value £345.51 Date received: 8 February 2022 Date accepted: 8 February 2022 Donor status: individual (Registered 04 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 3 | 2023-03-20-64e8edeb-10312-0 | |
| 5948f1f6f4c18f53d677f32624e1f4d6082e8e7b | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £280.47 payment to me to cover the cost of a briefing dinner, including food and wines etc, hosted by me in Parliament on 22 February 2022 Date received: 25 February 2022 Date accepted: 25 February 2022 Donor status: individual (Registered 04 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 4 | 2023-03-20-64e8edeb-10312-0 | |
| 509a4852b85a9c05ade79f695b268abc2c43156d | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £377.20 payment to me to cover the cost of staff for a briefing dinner hosted by me at a private residence on 1 February 2022 Date received: 2 March 2022 Date accepted: 2 March 2022 Donor status: individual (Registered 04 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 5 | 2023-03-20-64e8edeb-10312-0 | |
| 7f334ce3862431639804b6c1213fbbc49ded5896 | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £486.53 payment to me to cover the cost of a briefing dinner, including food and wines etc, hosted by me in Parliament on 2 February 2022 Date received: 2 March 2022 Date accepted: 2 March 2022 Donor status: individual (Registered 04 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 6 | 2023-03-20-64e8edeb-10312-0 | |
| 69a8f1b08737e9839a8b39bfed0a5e79b681293b | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £479.30 payment to me to cover the cost of a briefing dinner, including food and wines etc, hosted by me in Parliament on 1 March 2022 Date received: 3 March 2022 Date accepted: 3 March 2022 Donor status: individual (Registered 11 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 7 | 2023-03-20-64e8edeb-10312-0 | |
| 296b1996680de3a779f1a06e450abef1c357e1e7 | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £500.59 payment to me to cover the cost of a briefing dinner, including food and wines etc, hosted by me in Parliament on 23 February 2022 Date received: 8 March 2022 Date accepted: 8 March 2022 Donor status: individual (Registered 11 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 8 | 2023-03-20-64e8edeb-10312-0 | |
| 61cfd2d7ca94691dfa40164086f5c771695a24b1 | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: £167.48 payment to me to cover the cost of a briefing dinner, including food and wines etc, hosted by me in Parliament on 2 March 2022 Date received: 8 March 2022 Date accepted: 8 March 2022 Donor status: individual (Registered 11 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 9 | 2023-03-20-64e8edeb-10312-0 | |
| 09c507cf86263808527043b701eba5ed01a3b9c3 | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: payment of £412.35 to me to cover the cost of staff and soft drinks for a briefing dinner hosted by me at a private residence on 7 February 2022 Date received: 2 March 2022 Date accepted: 2 March 2022 Donor status: individual (Registered 15 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 10 | 2023-03-20-64e8edeb-10312-0 | |
| f4fa4b26ee8d6d2f64d47ad94a5fc2311ebd3053 | Name of donor: Adrian R B Johnson Address of donor: private Amount of donation or nature and value if donation in kind: payment of £797.57 to me to cover the cost of a briefing dinner, including food and chef, hosted by me at a private residence on 7 February 2022 Date received: 15 March 2022 Date accepted: 15 March 2022 Donor status: individual (Registered 15 March 2022) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 11 | 2023-03-20-64e8edeb-10312-0 | |
| 8d2e3751230f1675aa42508f3a3c3e1587e6eb94 | Name of donor: Richard Matthews Address of donor: private Amount of donation or nature and value if donation in kind: One dayâs shooting for myself and a friend, value £1,700 Date received: 21 January 2023 Date accepted: 21 January 2023 Donor status: individual (Registered 15 February 2023) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2023-03-20 | Bernard Jenkin uk.org.publicwhip/person/10312 | 12 | 2023-03-20-64e8edeb-10312-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");