items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
14 rows where record_id = "2011-11-29-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 |
---|---|---|---|---|---|---|---|
77f41473065a4aebeb50e6ff0ed9a421ad3d1a49 | Name of donor: Newmarket Racecourses Trust | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 0 | 2011-11-29-84642823-24773-0 |
3a07a200ebe88d23bdd95096e2545fd033e18cb3 | Address of donor: Westfield House, The Links, Newmarket, Suffolk, CB8 0TG. | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 1 | 2011-11-29-84642823-24773-0 |
5fb52037816699d97ac6d0e75e8d23c018d088a2 | 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-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 2 | 2011-11-29-84642823-24773-0 |
1b88420969eb9bbb5a8f8427ead1093e392e1c10 | Date of receipt of donation: 1 April 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 3 | 2011-11-29-84642823-24773-0 |
277e590299ed64a5a8b988f25320e1f28c8cedb0 | Date of acceptance of donation: 2 April 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 4 | 2011-11-29-84642823-24773-0 |
85ca185271ea61cd4bd4ee06ff77f5de96833807 | Donor status: trust, registration number 00867204 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 5 | 2011-11-29-84642823-24773-0 |
bbfbfa7d8bf91ac27835ebd7a7c018c4e732d072 | (Registered 19 April 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 6 | 2011-11-29-84642823-24773-0 |
adbe1895389b113388dddc98f741319add4e706b | Name of donor: Jockey Club Estates | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 7 | 2011-11-29-84642823-24773-0 |
13e8e03d9004370621395ef6f52cfa0940317b48 | Address of donor: 101 High Street, Newmarket, Suffolk, CB8 8JL. | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 8 | 2011-11-29-84642823-24773-0 |
85edc935ba17109654a3e3a185eade735897371f | 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-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 9 | 2011-11-29-84642823-24773-0 |
a91396d073b0b088d2409a7e1e8d92b502b46390 | Date of receipt of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 10 | 2011-11-29-84642823-24773-0 |
0167fdcda763dbad5f7a13a78d6bb03405763a16 | Date of acceptance of donation: 9 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 11 | 2011-11-29-84642823-24773-0 |
b2bea72945b3dbbb1145d4625002d51601fc0d17 | Donor status: company, registration number 00944773 | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 12 | 2011-11-29-84642823-24773-0 |
a747d0cccceac9c17a52251488414aa1b96772e6 | (Registered 28 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-11-29 | Matthew Hancock uk.org.publicwhip/member/40652 | Matthew Hancock uk.org.publicwhip/person/24773 | 13 | 2011-11-29-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");