items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
20 rows where record_id = "2011-12-13-84642823-24811-0" sorted by record_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order | record_id ▼ |
---|---|---|---|---|---|---|---|
f7b3ee183a6ce04a301e95cf177d1539873dafcb | Name of donor: ITV | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 0 | 2011-12-13-84642823-24811-0 |
bc0b9174f57c60d4509c4d070d539703042e7afa | Address of donor : London Television Centre, Upper Ground, London SE1 9LT | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 1 | 2011-12-13-84642823-24811-0 |
1ca960d035fb1afba3c8fd42db2c15ef2b2335f0 | Amount of donation or nature and value if donation in kind: ticket and hospitality at the National Television Awards; value £662.46 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 2 | 2011-12-13-84642823-24811-0 |
1bcc286928adda8f0b666b294666b37647f8bae3 | Date of receipt of donation: 26 January 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 3 | 2011-12-13-84642823-24811-0 |
1e79c344a9adf7211a536d0306cbb11e12a11591 | Date of acceptance of donation: 26 January 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 4 | 2011-12-13-84642823-24811-0 |
8de83914fdc361642e80ebd62d2789f3953e34e8 | Donor status: company, registration number 4967001 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 5 | 2011-12-13-84642823-24811-0 |
506305f76911e12fd04722caceec3c5e95494a30 | Name of donor: UK Music | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 7 | 2011-12-13-84642823-24811-0 |
182d8eb23f20b00d2083afb76c4b9e52f73613ec | Address of donor : 26 Berners Street, London W1T 3LR | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 8 | 2011-12-13-84642823-24811-0 |
c82d7032089ff9c3eea436186a61395d34289a08 | Amount of donation or nature and value if donation in kind: ticket and hospitality at the BRIT Awards; value £850 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 9 | 2011-12-13-84642823-24811-0 |
3e4f77352a34b26084374c2edcebf30bad04fa17 | Date of receipt of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 10 | 2011-12-13-84642823-24811-0 |
9325ec5dbb9302a0df48555564f490103e4d6c7d | Date of acceptance of donation: 15 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 11 | 2011-12-13-84642823-24811-0 |
692bae92b325354af53dae5413004b5bb63d7369 | Donor status: company, registration number 3245288 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 12 | 2011-12-13-84642823-24811-0 |
6286781cff1da078d94fa2a85f27b0c6c440c3a3 | (Registered 4 March 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 13 | 2011-12-13-84642823-24811-0 |
ba87419311daf44cb96379bf9f416e6b723fcdad | Name of donor: Time Warner Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 14 | 2011-12-13-84642823-24811-0 |
0016bfc69a309bb258dc05c15281cb5abd3fc19f | Address of donor : 44 GreatMarlborough Street, London W1F 7JL | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 15 | 2011-12-13-84642823-24811-0 |
261682f8dacac1abfe092dfb79af3ed646245d04 | Amount of donation or nature and value if donation in kind: ticket and hospitality at the Orange British Academy Film Awards; value £700 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 16 | 2011-12-13-84642823-24811-0 |
fe569932c917e89c38ef766ef5180313420ed09f | Date of receipt of donation: 13 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 17 | 2011-12-13-84642823-24811-0 |
61d588b42d55c6f0b0cb5256bf4d7468d42357dc | Date of acceptance of donation: 13 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 18 | 2011-12-13-84642823-24811-0 |
af9a01259e8f551235986643d9ac68044c246da9 | Donor status: company, registration number 02713670 | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 19 | 2011-12-13-84642823-24811-0 |
646d737efc2b1174aaedaa25a1c2a1cd9a45afda | (Registered 8 March 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-12-13 | Gloria De Piero uk.org.publicwhip/member/40048 | Gloria De Piero uk.org.publicwhip/person/24811 | 20 | 2011-12-13-84642823-24811-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");