items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
13 rows where record_id = "2011-02-28-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 |
---|---|---|---|---|---|---|---|
8050bdd7cd5f4e66c25461c02ea6b2681242ce1e | Name of donor: Onifas Ltd, trading as The Bedford Arms | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 0 | 2011-02-28-84642823-11026-0 |
1f786a8608c193872ce10c2c0506a66bdbc7ea41 | Address of donor : 77 Bedford Hill London London SW12 9HD | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 1 | 2011-02-28-84642823-11026-0 |
595e093f710758fa2b58f6eb96761aa34ee7cba9 | Date of receipt of donation: 29 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 3 | 2011-02-28-84642823-11026-0 |
aa0e206c1d6b8dad1f5d920c104fc10c046f8778 | Date of acceptance of donation: 29 June 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 4 | 2011-02-28-84642823-11026-0 |
a4811070d4d1dd48f39615910dadb0d108ff2f82 | Donor status: company No 5175241 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 5 | 2011-02-28-84642823-11026-0 |
0691b7a946ae8686ce1eb2e976f9bb2ed333508c | (Registered 24 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 6 | 2011-02-28-84642823-11026-0 |
c09937e2b1a9e796a1c3822c96e9b4a91f4fc05a | Name of donor: Research in Motion UK | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 7 | 2011-02-28-84642823-11026-0 |
17f8c2c6e54616737f14bd0b49d6ae95993972e5 | Address of donor : 36 Station Road Egham Surrey TW20 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 8 | 2011-02-28-84642823-11026-0 |
ae82bffadfcd6ed38cae96a1f103fbefe9c2265f | 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-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 9 | 2011-02-28-84642823-11026-0 |
b76b0d7a9da15451fc030fbde0e6ea4063e1ea6e | Date of receipt of donation: 12 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 10 | 2011-02-28-84642823-11026-0 |
58ddcd257a021aaf1f113078ccc801b12d8d21c3 | Date of acceptance of donation: 12 July 2010 | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 11 | 2011-02-28-84642823-11026-0 |
7b4c985c9bd2720ad757c2583c3e05a962533f3a | Donor status: company No 4022422. | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 12 | 2011-02-28-84642823-11026-0 |
577f7f5b84543d48f644573d3319c2b66fe3975a | (Registered 24 July 2010) | Gifts, benefits and hospitality (UK) 84642823 | 2011-02-28 | Greg Knight uk.org.publicwhip/member/40234 | Greg Knight uk.org.publicwhip/person/11026 | 13 | 2011-02-28-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");