items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2010-11-22-84642823-24773-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 |
---|---|---|---|---|---|---|---|
7df98de57e7a50e5dbd8cea416be2430c29a9760 | Name of donor: Newmarket Racecourses Trust | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2010-11-22-84642823-24773-0 |
ab96c48bdd7fdf0a6c80e4efe76a35508e974741 | Address of donor: Westfield House, The Links, Newmarket, Suffolk, CB8 0TG. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2010-11-22-84642823-24773-0 |
3caa9ec93f0e39cbbf4ed41a8974fd19e8369482 | Amount of donation or nature and value if donation in kind: two annual badges and car passes for entry to Newmarket Racecourses. Total value: £760. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2010-11-22-84642823-24773-0 |
9153b81948d97d7faf9a74e44220adf5310852bc | Date of receipt of donation: 9 April 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2010-11-22-84642823-24773-0 |
b9fac9cc0587d2a36e348484ee761f88cb6c48d6 | Date of acceptance of donation: 7 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2010-11-22-84642823-24773-0 |
53053e5e0af7b7386e3976b4a793721d2ecbde68 | Donor status: trust, registration number 00867204 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2010-11-22-84642823-24773-0 |
b58b57f7b08c183cdbbfd8fdf5f63366b83dd3fc | (Registered 14 May 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2010-11-22-84642823-24773-0 |
d7aa0f14aaa735bd17905ec88a9032b21a0432c6 | Name of donor: British Sky Broadcasting Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2010-11-22-84642823-24773-0 |
397539b68cb180f7687f9119f520061763cef5f7 | Address of donor: Grant Way, Isleworth, TW7 5QD. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 8 | 2010-11-22-84642823-24773-0 |
c82e67453a5fdaef43c2174912676a9257b0bde9 | Amount of donation or nature and value if donation in kind: 28-31 May 2010. My family and I were provided with hospitality and accommodation at the Hay Festival weekend, as guests of Sky News. Value: £912. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 9 | 2010-11-22-84642823-24773-0 |
8ad8b2088bd56cc5a282d18bf6c9b74a7615476e | Date of receipt of donation: 23 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 10 | 2010-11-22-84642823-24773-0 |
7dc3cb588efbd18775e480aa33d8c5caa7b12046 | Date of acceptance of donation: 28 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 11 | 2010-11-22-84642823-24773-0 |
2af533f05d57078e4b05c74b4270a65ee93f8c88 | Donor status: company, registration number 2247735 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 12 | 2010-11-22-84642823-24773-0 |
fb6a4c38ab293f6b5233d5f25f39e0ffa168c2ec | (Registered 7 June 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 13 | 2010-11-22-84642823-24773-0 |
e796cb14d4ac0426c8a87f620d18303116239823 | Name of donor: Jockey Club Estates | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 14 | 2010-11-22-84642823-24773-0 |
f46d34cf6e1b5cc05d4e9dcd28ea3791d8b6134b | Address of donor: 101 High Street, Newmarket, Suffolk, CB8 8JL. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 15 | 2010-11-22-84642823-24773-0 |
6c1c1400e376de25ab3433beadf65f85d5eecae3 | Amount of donation or nature and value if donation in kind: honorary membership of the Club Rooms in Newmarket. Value: membership £455.75, joining fee £900. Total: £1355.75 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 16 | 2010-11-22-84642823-24773-0 |
c00afad1a481dcc31beefa464560fa0621b1172b | Date of receipt of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 17 | 2010-11-22-84642823-24773-0 |
e427ab1340578b02c0e73903f8aa6f9342681563 | Date of acceptance of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 18 | 2010-11-22-84642823-24773-0 |
22e7353c18393294af2203c9969c97a773289034 | Donor status: company, registration number 00944773 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 19 | 2010-11-22-84642823-24773-0 |
66decb762596a195aa49fbbfae678adf5d9a0a74 | Name of donor: Cavendish Corporate Finance LLP | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 21 | 2010-11-22-84642823-24773-0 |
68fae4c255cc70e6efb26b4c6dcc431edc455d8c | Address of donor: 40 Portland Place, London W1B 1NB. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 22 | 2010-11-22-84642823-24773-0 |
336999b65338953c15260090f52c67ae2d928030 | Amount of donation or nature and value if donation in kind: my wife and I received tickets to the Conservative Summer Party. Payment was made directly to the Conservative Party. | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 23 | 2010-11-22-84642823-24773-0 |
f314c2d07e4284fd412fbe1775c547ff01bdd4c1 | Date of receipt of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 24 | 2010-11-22-84642823-24773-0 |
04df7c2ee74936c3ed9e531ad8d639fcdea18a6c | Date of acceptance of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 25 | 2010-11-22-84642823-24773-0 |
bdb54b1aa1889544350d1df2b2dd5384adebe6d9 | Donor status: limited liability partnership, registration number OC333044 | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 26 | 2010-11-22-84642823-24773-0 |
5b3f56d8f79bae336aedd27a51f9e939d7877e2b | (Registered 28 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2010-11-22 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 27 | 2010-11-22-84642823-24773-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");