items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
15 rows where record_id = "2014-09-22-8f616a6e-10202-0" sorted by sort_order
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id | sort_order ▼ | record_id |
---|---|---|---|---|---|---|---|
77ec81fa186aedddcdc0fa01f6bad4f6697fc498 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 0 | 2014-09-22-8f616a6e-10202-0 |
7f44f31d9d83ae2273dc8e04cee38a2cd2ae1898 | Name of donor: Ove Arup & Partners International Ltd | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 1 | 2014-09-22-8f616a6e-10202-0 |
c3d6d9ed29d67378256c0b850af2d3d6bb69c93a | Address of donor: 13 Fitzroy Street London W1T 4BQ | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 2 | 2014-09-22-8f616a6e-10202-0 |
cd782a6515a16e1769f82215fb24f7bc17454eb9 | Amount of donation or nature and value if donation in kind: Policy analysis provided to me as Shadow Secretary of State for Energy and Climate Change, 1 day per week for a period of 6 months, commencing 4 February 2013. Value £7,942. | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 3 | 2014-09-22-8f616a6e-10202-0 |
2840ba927b2965e7d932698a10fdd2182314d963 | Date of receipt: 4 February 2013 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 4 | 2014-09-22-8f616a6e-10202-0 |
e0c3877560594064a3987b802f880cad8bba2abb | Date of acceptance: 4 February 2013 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 5 | 2014-09-22-8f616a6e-10202-0 |
2fd24b22e5ea7c28c1f2d33e84f4089782fc2fa9 | Donor status: company, registration no 952468 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 6 | 2014-09-22-8f616a6e-10202-0 |
102b09b96f5c77ae9b262a179c51a6d5bb5805c9 | (Registered 30 January 2013; corrected 25 February 2013) | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 7 | 2014-09-22-8f616a6e-10202-0 |
af51769a9358cd5de3c875879d5c77b5edfd4178 | Name of donor: Calor Gas Ltd | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 8 | 2014-09-22-8f616a6e-10202-0 |
7fc4efe669c05290ea1c7144e567fafb73f5ed8d | Address of donor: Athena Drive, Warwick, CV34 6RL | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 9 | 2014-09-22-8f616a6e-10202-0 |
88698849e54381ce37f817c815cd7132c58c98e7 | Amount of donation or nature and value if donation in kind: cost of design and printing of a book on energy efficiency; £1,929 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 10 | 2014-09-22-8f616a6e-10202-0 |
77d1e8fef2d953e5cd70422141c4f38141bf555e | Date of receipt: 19 September 2013 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 11 | 2014-09-22-8f616a6e-10202-0 |
78c8be7f4d6f8bf4ac32e035c77f045f46167053 | Date of acceptance: 19 September 2013 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 12 | 2014-09-22-8f616a6e-10202-0 |
932db576208ca471e001ca13303fdc0bcd040c69 | Donor status: company, registration 303703 | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 13 | 2014-09-22-8f616a6e-10202-0 |
66b2c531dc19e7afcaba5831e2c5d9ffd9d2b55f | (Registered 30 September 2013) | Sponsorships 8f616a6e | 2014-09-22 | Caroline Flint uk.org.publicwhip/member/40206 | Caroline Flint uk.org.publicwhip/person/10202 | 14 | 2014-09-22-8f616a6e-10202-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");