items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
18 rows where record_id = "2014-07-28-84642823-10260-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
94285b0c30b4706c2bc5230f1d68d1e3aa47c96b | Amount of donation or nature and value if donation in kind: two tickets to watch tennis, plus lunch and afternoon tea; total value £3,400 (£1,700 per person) | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 2 | 2014-07-28-84642823-10260-0 |
2708c8218060e0d409fd3cdb76694112509ee744 | Date of receipt of donation: 1 May 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 3 | 2014-07-28-84642823-10260-0 |
b10fadb931f0026802560e8272d4e40b50141dfa | Date of acceptance of donation: 27 June 2013 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 4 | 2014-07-28-84642823-10260-0 |
c2f736a625b3e7be1aacc53b12b740ce5dc3ca9f | (Registered 22 July 2013) | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 6 | 2014-07-28-84642823-10260-0 |
48386fe0207e5cc451bc61dd0ccf4f802e45546b | Name of donor: All England Lawn Tennis and Croquet Club Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 7 | 2014-07-28-84642823-10260-0 |
0680f5c239af906ec6e07d5158713a012da03da4 | Address of donor: Church Road, Wimbledon, London SW19 5AE | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 8 | 2014-07-28-84642823-10260-0 |
8f270cb6bc47f24c8ae9b99a74ec1daadf2fafe3 | Amount of donation or nature and value if donation in kind: two tickets for the Royal Box at Wimbledon, plus lunch; total value £3,590 (£1,795 per person) | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 9 | 2014-07-28-84642823-10260-0 |
818dadc8c47590a6e7e32f04d750014a623af8bb | Date of receipt of donation: 26 June 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 10 | 2014-07-28-84642823-10260-0 |
1969ee18f235e66f879a8b548670b8924508958e | Date of acceptance of donation: 26 June 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 11 | 2014-07-28-84642823-10260-0 |
00375c89fbdeb771eebff69e891983880befa5be | Donor status: company, registration number 7546718 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 12 | 2014-07-28-84642823-10260-0 |
cfad10df951c5fe7653917a98793e8d7ec6fa11e | (Registered 10 July 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 13 | 2014-07-28-84642823-10260-0 |
d337891189376e51c24e14a9ee12dc899801b76e | Name of donor: BSkyB | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 14 | 2014-07-28-84642823-10260-0 |
31aa895fe01f345a8df0fb07c14513c533aa1ce9 | Address of donor : Grant Way, Isleworth, TW7 5QD | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 15 | 2014-07-28-84642823-10260-0 |
7d76fa3314f7ac574d3b76aa62df57a8c1266508 | Amount of donation or nature and value if donation in kind: 2 Tour de France Stage 3 finish Line tickets, combined value £1,000 plus VAT | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 16 | 2014-07-28-84642823-10260-0 |
0d79d21c4554b630cbc7a854e2dfc491e398b1f2 | Date of receipt of donation: 7 July 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 17 | 2014-07-28-84642823-10260-0 |
0150c8d868df47f22ecf4ed9fc72a862dade73b7 | Date of acceptance of donation: 7 July 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 18 | 2014-07-28-84642823-10260-0 |
753a7b8c75bd5a69e2e63e820626d033dac78f83 | Donor status: company, registration no 2247735 | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 19 | 2014-07-28-84642823-10260-0 |
e383fa166f3a6b74ac480047e33945aa04ab0ff6 | (Registered 28 July 2014 ) | Gifts, benefits and hospitality (UK) 84642823 | 2014-07-28 | Harriet Harman uk.org.publicwhip/member/40140 | Harriet Harman uk.org.publicwhip/person/10260 | 20 | 2014-07-28-84642823-10260-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");