items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-84642823-11924-3" 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 |
---|---|---|---|---|---|---|---|
b4c6be90b818582f2702771286fc47986d34f81e | Name of donor: Merlin Entertainments Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 0 | 2015-03-30-84642823-11924-3 |
55e1cc7070aa5e91ffe02c680894d7094d07f178 | Address of donor: 3 Market Close, Poole BH15 1NQ | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 1 | 2015-03-30-84642823-11924-3 |
697e9cffd57973dde3900c5c5f5a3df7733b9d0e | Amount of donation or nature and value if donation in kind: 2 tickets for a Six Nations rugby game in November 2014, preceded by reception and lunch; total value £600 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 2 | 2015-03-30-84642823-11924-3 |
7900a5dd66f09b0baf0ef8377424c3ed7562a893 | Date of receipt of donation: 23 September 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 3 | 2015-03-30-84642823-11924-3 |
a005bfb27da86b3a61af672bb67613e31231c818 | Date of acceptance of donation: 28 September 2014 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 4 | 2015-03-30-84642823-11924-3 |
05e3d9492ee8599b91a97d6505eb79d02389d028 | Donor status: company, registration 03663168 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 5 | 2015-03-30-84642823-11924-3 |
dbbce8f41e7b50f2c8d626e19cb53ff9a0c4c1fa | (Registered 18 December 2014 together with invitation received on 30 January 2014) | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | John Penrose uk.org.publicwhip/member/40657 | John Penrose uk.org.publicwhip/person/11924 | 6 | 2015-03-30-84642823-11924-3 |
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");