items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where item = "Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017)" and person_id = "uk.org.publicwhip/person/25330" sorted by date
This data as json, CSV (advanced)
Suggested facets: sort_order, date (date)
item 1 ✖
- Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) · 21 ✖
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2b60afe4d277a057770140ca8ad1ca9717f47085 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-07-31 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-07-31-64e8edeb-25330-0 | |
cd0c53ec72fc82d0d0e40106d0076e282eac8b3a | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-08-29 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-08-29-64e8edeb-25330-0 | |
1ce1814c35a31cba7d0efd9673e43517c5edac88 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-09-11 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-09-11-64e8edeb-25330-0 | |
c8b4cf374965a65740b7b9d4a608b0408ef5a2eb | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-10-09 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-10-09-64e8edeb-25330-0 | |
d1c78face68376eb235ebe84ed984ed4599787fe | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-10-23 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-10-23-64e8edeb-25330-0 | |
b1c149a2359ab5d8c1b0fbbf483a5d2b08bbf70f | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-11-13 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-11-13-64e8edeb-25330-0 | |
ac91ecc3ce64e0307e5709bc4ac80bf2e89281cc | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-11-27 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-11-27-64e8edeb-25330-0 | |
663025e191f9509c777ad9362e9aab744fa7b43b | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2017-12-11 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2017-12-11-64e8edeb-25330-0 | |
f4ba824ecea2fc3fe674fcd5ce1110cc4a2cf564 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-01-08 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2018-01-08-64e8edeb-25330-0 | |
84c9711ca0a802ec9e35518ba8dd10cb53887519 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-01-22 | Mims Davies uk.org.publicwhip/person/25330 | 2 | 2018-01-22-64e8edeb-25330-0 | |
a43252a6a77f598c6ea1650e4f06b0cbdc0b1f03 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-02-05 | Mims Davies uk.org.publicwhip/person/25330 | 1 | 2018-02-05-64e8edeb-25330-0 | |
29245536889012245149c36ba3c37f0884758870 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-02-19 | Mims Davies uk.org.publicwhip/person/25330 | 1 | 2018-02-19-64e8edeb-25330-0 | |
96be2bea654ac113b7a902b01fd070350ef5bf31 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-03-05 | Mims Davies uk.org.publicwhip/person/25330 | 1 | 2018-03-05-64e8edeb-25330-0 | |
fffbcf5dbcb160f7c9ade934588863a5c6526958 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-03-19 | Mims Davies uk.org.publicwhip/person/25330 | 1 | 2018-03-19-64e8edeb-25330-0 | |
bef9584c41611bb6a44ee804204106bc398ab614 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-04-16 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-04-16-64e8edeb-25330-0 | |
4e08a4fa2b1196a1e4f66faf5f35e454b97d547a | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-04-30 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-04-30-64e8edeb-25330-0 | |
8bdcc48622807335dc5b66777395001194e2c0ca | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-05-14 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-05-14-64e8edeb-25330-0 | |
b1d400e0b486a50995a8d70560f02050b2c8dc7a | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-06-04 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-06-04-64e8edeb-25330-0 | |
439955160ad842dc36090bb275eaef69f81991ce | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-06-18 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-06-18-64e8edeb-25330-0 | |
4d910d067a2e45f23ae159952ba28ce89836a107 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-07-02 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-07-02-64e8edeb-25330-0 | |
77a8091ced38b0f15080d8165c3977137ddd61b8 | Name of donor: ITV plc Address of donor: The London Television Centre, Upper Ground, London SE1 9LT Amount of donation or nature and value if donation in kind: Ticket to Royal Ascot, with accompanying hospitality, value £718.80 Date received: 22 June 2017 Date accepted: 22 June 2017 Donor status: company, registration 4967001 (Registered 20 July 2017) | Gifts, benefits and hospitality from UK sources 64e8edeb | 2018-07-16 | Mims Davies uk.org.publicwhip/person/25330 | 0 | 2018-07-16-64e8edeb-25330-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");