items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2011-07-19-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 |
---|---|---|---|---|---|---|---|
352fd9b6674def4c4a19d5f67241bd832f143459 | Name of donor: Newmarket Racecourses Trust | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2011-07-19-84642823-24773-0 |
4ce2bea112c94222d128c6c4ed5291436afc8c8a | Address of donor: Westfield House, The Links, Newmarket, Suffolk, CB8 0TG. | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2011-07-19-84642823-24773-0 |
0d17eee6ae1ee90cc39e5b7d4b2855d12243d3f3 | Amount of donation or nature and value if donation in kind: two annual badges and car passes for entry to Newmarket Racecourses. Total value: £790. | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2011-07-19-84642823-24773-0 |
c7ac5b097511670e90dc900d937b9f24cafa44f2 | Date of receipt of donation: 1 April 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2011-07-19-84642823-24773-0 |
45cae447fc25cd51db530bc814df2d7d03f00101 | Date of acceptance of donation: 2 April 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2011-07-19-84642823-24773-0 |
0efbed121ff2c19f696b3be43e3cf79337d8b116 | Donor status: trust, registration number 00867204 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2011-07-19-84642823-24773-0 |
d410dc317d074f86711a0096256dc34d883f4043 | (Registered 19 April 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2011-07-19-84642823-24773-0 |
10724d92c9cd3904c11fde8eef1d2e2079e94f07 | Name of donor: Jockey Club Estates | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2011-07-19-84642823-24773-0 |
7a70049a2e8962d8a307f5be7ae8709c5fc2b738 | Address of donor: 101 High Street, Newmarket, Suffolk, CB8 8JL. | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 8 | 2011-07-19-84642823-24773-0 |
22efd3ac5027cdd9a3a410c10432509e11593104 | 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 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 9 | 2011-07-19-84642823-24773-0 |
10f979a8976ddeef3d8e2f39ec9e910aea754227 | Date of receipt of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 10 | 2011-07-19-84642823-24773-0 |
aed8f2c1b9f1af91079ad1a91fec7089b15ea104 | Date of acceptance of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 11 | 2011-07-19-84642823-24773-0 |
666af9c1d4aa534cb784cbf8ca8f931b3f471e81 | Donor status: company, registration number 00944773 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 12 | 2011-07-19-84642823-24773-0 |
ae9d248663fe41ffe1156b2d50e397e09d2207c9 | Name of donor: Cavendish Corporate Finance LLP | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 14 | 2011-07-19-84642823-24773-0 |
1435353387b34b50df54238a5b40a23ffeb35119 | Address of donor: 40 Portland Place, London W1B 1NB. | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 15 | 2011-07-19-84642823-24773-0 |
af54a8be7e9952606222564dc411cffeabd4f069 | 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 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 16 | 2011-07-19-84642823-24773-0 |
ba4f3a3176b0ecc74cfed5d4fa0a4576c3f11aea | Date of receipt of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 17 | 2011-07-19-84642823-24773-0 |
0d07055d4bce5d713df3debf8c19f9b7bd358d9b | Date of acceptance of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 18 | 2011-07-19-84642823-24773-0 |
017da766d2b354ba647595375636a66d355813c0 | Donor status: limited liability partnership, registration number OC333044 | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 19 | 2011-07-19-84642823-24773-0 |
6ebddb6416f0b6df006c5297aae3069fa48d88a7 | (Registered 28 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-07-19 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 20 | 2011-07-19-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");