items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2015-03-30-84642823-24740-1" 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 ▼ |
---|---|---|---|---|---|---|---|
a28c95c82532e0ea9e2992437f278d499d055a18 | Name of donor: MIR Steel UK Ltd | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 0 | 2015-03-30-84642823-24740-1 |
58bf1166ed190d88d2c8a87273c10edaffcb6e42 | Address of donor: Liberty Commodities Ltd, 7 Hertford Street, London W1J 7RH | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 1 | 2015-03-30-84642823-24740-1 |
636d3dfe1bd06a4d1c3e8c0edff3aa87e9ba3977 | Amount of donation or nature and value if donation in kind: two tickets and hospitality to Wales v Ireland on 14 March 2015, at £495 each; total £990 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 2 | 2015-03-30-84642823-24740-1 |
8eddc2d0f8090226b30d9c0612d354a6ba70767e | Date of receipt of donation: 14 March 2015 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 3 | 2015-03-30-84642823-24740-1 |
10c21c39aa26034d783c814667ab0c1d14185b94 | Date of acceptance of donation: 14 March 2015 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 4 | 2015-03-30-84642823-24740-1 |
b07826d2cd0bcf24af959bf16eda25b08607a775 | Donor status: company, registration 3349135 | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 5 | 2015-03-30-84642823-24740-1 |
434c66c800abb85e5fa2a4b2c163b01749ae1ddc | (Registered 17 March 2015) | Gifts, benefits and hospitality (UK) 84642823 | 2015-03-30 | Alun Cairns uk.org.publicwhip/member/40623 | Alun Cairns uk.org.publicwhip/person/24740 | 6 | 2015-03-30-84642823-24740-1 |
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");