items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2011-05-03-84642823-11026-0" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
169e78f052393c5650d7c4387531589d0ed9a9e2 | Name of donor: Onifas Ltd, trading as The Bedford Arms | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2011-05-03-84642823-11026-0 |
023bb85d26c67f57b88074656f6fa31ab30fb067 | Address of donor : 77 Bedford Hill London London SW12 9HD | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 1 | 2011-05-03-84642823-11026-0 |
8802e40f2ceb266a4fd854b201fb007c6dd77b63 | Date of receipt of donation: 29 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 3 | 2011-05-03-84642823-11026-0 |
38d593cbef180419dd28554355120f6baf2f5aa6 | Date of acceptance of donation: 29 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 4 | 2011-05-03-84642823-11026-0 |
91e87a57d14a239bd27388fc274b8e71956c8fc2 | Donor status: company No 5175241 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 5 | 2011-05-03-84642823-11026-0 |
6790f2323b1a2819a2073b7e5dcfff99137331c4 | (Registered 24 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 6 | 2011-05-03-84642823-11026-0 |
04fbdab1741c484d81c0f31c2318318e6ea32cfa | Name of donor: Research in Motion UK | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 7 | 2011-05-03-84642823-11026-0 |
987c4ed58fdb487112e38fc462d773d653238cea | Address of donor : 36 Station Road Egham Surrey TW20 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 8 | 2011-05-03-84642823-11026-0 |
4c28c45738b20c176c04a66131d8f370996fb1f4 | Amount of donation or nature and value if donation in kind: sponsorship for the group for a music album by parliamentary rock group MP4 towards the costs of rehearsals, equipment and launch reception value £1,500 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 9 | 2011-05-03-84642823-11026-0 |
a1e0414b3d49b9eeb6924f9fcda2002cd6e719a9 | Date of receipt of donation: 12 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 10 | 2011-05-03-84642823-11026-0 |
aa4fb512ae24f6a23f2fe6506d3a70394d063d8f | Date of acceptance of donation: 12 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 11 | 2011-05-03-84642823-11026-0 |
014ac0a5d0d61b362b9c6f55abf9eb29eae3715f | Donor status: company No 4022422. | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 12 | 2011-05-03-84642823-11026-0 |
38ffa6c6c0167aed45cac9bbdc6f07b7e96bd134 | (Registered 24 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-05-03 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 13 | 2011-05-03-84642823-11026-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");