items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2011-03-28-84642823-24935-0" sorted by date
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
2de6a9d4787fdc582fbbe516dfb83c3cca79289a | Name of donor: Marina Dalglish Breast Cancer Charity | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 0 | 2011-03-28-84642823-24935-0 |
2adcc8894b988ef9b46549628da47051a2565c95 | Address of donor : 78 Seal Street, Liverpool L1 4BH | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 1 | 2011-03-28-84642823-24935-0 |
810ea09c5431057eb927b3d2350be6080a2fe756 | Amount of donation or nature and value if donation in kind: 2 tickets for a charity ball; total value £700 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 2 | 2011-03-28-84642823-24935-0 |
a3fdacef02541ada532a1e5c81f0b4afb3a54b3b | Date of receipt of donation: 5 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 3 | 2011-03-28-84642823-24935-0 |
0f9dd831fe5036dcd5c345e1c116afb79776afa5 | Date of acceptance of donation: 5 February 2011 | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 4 | 2011-03-28-84642823-24935-0 |
71c432d09a7c901c215205ede797b519bce4311d | Donor status: charity | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 5 | 2011-03-28-84642823-24935-0 |
0004a0382e9d762eeab1ce6d3af43e3ec4ea180d | (Registered 11 February 2011) | Gifts, benefits and hospitality (UK) 84642823 | 2011-03-28 | Steve Rotheram uk.org.publicwhip/member/40371 | Steve Rotheram uk.org.publicwhip/person/24935 | 6 | 2011-03-28-84642823-24935-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");