items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2011-03-28-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 |
---|---|---|---|---|---|---|---|
c1c8b7ad6ab4130ec2c66e9091d4bd41bf057fcd | Name of donor: Newmarket Racecourses Trust | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2011-03-28-84642823-24773-0 |
1cdc4f6f328e7e1bf9bb6236550eccd74cd45f9b | Address of donor: Westfield House, The Links, Newmarket, Suffolk, CB8 0TG. | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2011-03-28-84642823-24773-0 |
c246adabdb81d12688939114a0b03fd635a0b8a0 | 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 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2011-03-28-84642823-24773-0 |
1d45ee9bb876ae26172670dbb2c56db1a6067263 | Date of receipt of donation: 9 April 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2011-03-28-84642823-24773-0 |
41dd457e5924c35b5dcfc548e6d083a63d0f2bdf | Date of acceptance of donation: 7 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2011-03-28-84642823-24773-0 |
ce9bc0f76ca2cb432e1a4a20804e17a0fd33dded | Donor status: trust, registration number 00867204 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2011-03-28-84642823-24773-0 |
d9c7449e044f8c98552092e00891ba3536e5a261 | (Registered 14 May 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2011-03-28-84642823-24773-0 |
dbc11e0b2d7f96c9003a17bc08acfed3fd400978 | Name of donor: British Sky Broadcasting Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2011-03-28-84642823-24773-0 |
5658b0d84871fe6b804abccbabeb22d27c18f23d | Address of donor: Grant Way, Isleworth, TW7 5QD. | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 8 | 2011-03-28-84642823-24773-0 |
1985a40eb86e81f692a42ee07bcc2a6b054c3121 | 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 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 9 | 2011-03-28-84642823-24773-0 |
965190a0d16cb32cd2af8731c3dbc4a40b747a9c | Date of receipt of donation: 23 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 10 | 2011-03-28-84642823-24773-0 |
e4c1d594fcbbdaac02d59431f64d153c844d8d9e | Date of acceptance of donation: 28 May 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 11 | 2011-03-28-84642823-24773-0 |
b61bb6e74c36bedda921c9e60094e0bff8052172 | Donor status: company, registration number 2247735 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 12 | 2011-03-28-84642823-24773-0 |
2f2477054b84ff8301f17cb81af5ed9d7ce3f3eb | (Registered 7 June 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 13 | 2011-03-28-84642823-24773-0 |
57c8ec37ffccaab2c88c582d2eaea4dc49814d64 | Name of donor: Jockey Club Estates | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 14 | 2011-03-28-84642823-24773-0 |
d1b6a13da0c8fb8250e16483a738c0e0285b9d5b | Address of donor: 101 High Street, Newmarket, Suffolk, CB8 8JL. | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 15 | 2011-03-28-84642823-24773-0 |
a57b8ae2f2f774ad5fde5f6c0066cf10e028e17a | 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-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 16 | 2011-03-28-84642823-24773-0 |
8aa36a77aef75e6911450bac4083aa4d70b856eb | Date of receipt of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 17 | 2011-03-28-84642823-24773-0 |
1713fcf10ca28c2553af776a400deb098f2bf920 | Date of acceptance of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 18 | 2011-03-28-84642823-24773-0 |
06856fc26724635d9dc2dfb77c3864bb5aa6ff5f | Donor status: company, registration number 00944773 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 19 | 2011-03-28-84642823-24773-0 |
cd1a105e77116ea4e17e1c540ebca7859291453c | Name of donor: Cavendish Corporate Finance LLP | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 21 | 2011-03-28-84642823-24773-0 |
1dd9629c165d578b3ff5d61922f7481ae1d3e851 | Address of donor: 40 Portland Place, London W1B 1NB. | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 22 | 2011-03-28-84642823-24773-0 |
5e662c0b2d5aa24d151905d578b2966ae6ab7a0d | 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-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 23 | 2011-03-28-84642823-24773-0 |
8a6c0621b14c809cc4c820c41e3ae1a226bcd708 | Date of receipt of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 24 | 2011-03-28-84642823-24773-0 |
2dfaca4de208e5c868dacf881685c6831c23f85c | Date of acceptance of donation: 5 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 25 | 2011-03-28-84642823-24773-0 |
58eec42fee4bf461a3fb7510be3eaa125ac5e3de | Donor status: limited liability partnership, registration number OC333044 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 26 | 2011-03-28-84642823-24773-0 |
7fe6a16ca3724325eb1318340e64c3cd7b79afa9 | (Registered 28 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 27 | 2011-03-28-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");