items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
9 rows where record_id = "2007-07-17-9e46def6-10048-0" sorted by person_id descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date | member_id | person_id ▲ | sort_order | record_id |
---|---|---|---|---|---|---|---|
2c8421b450b879b790d8e5d30bb1983f3a50271d | Donations to my campaign for election as Deputy Leader of the Labour Party from: | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 0 | 2007-07-17-9e46def6-10048-0 |
338e68b571450877659e507467f382694ff52d56 | John Wilkinson, Wilkinson Star Ltd, Manchester. (Registered 16 April 2007) | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 1 | 2007-07-17-9e46def6-10048-0 |
d9787721f5aa0043340970d6fe49123a85830f04 | Peninsula Business Services, Salford | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 2 | 2007-07-17-9e46def6-10048-0 |
1e94acde27ad8602a8cbcf6b378bf48f502132e1 | Anthony Bailey, of London (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 3 | 2007-07-17-9e46def6-10048-0 |
bc5da1e964e3de3da274ad9f0c0f12018760ee48 | Mrs I Harrison, of Doncaster (personal donation) (Registered 21 June 2007) | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 4 | 2007-07-17-9e46def6-10048-0 |
0d8c2084daf1db618ad1a506c3eb1c5c2705b48b | USDAW | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 5 | 2007-07-17-9e46def6-10048-0 |
4f799dfea74346e312c8a91a5d6fedab2b7d69be | B M Creative Management Ltd, London | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 6 | 2007-07-17-9e46def6-10048-0 |
890fe4193e01d098ef0b4a2cc0ee3cf6636d7169 | Mr J Ramsbottom, of Wilmslow (personal donation) | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 7 | 2007-07-17-9e46def6-10048-0 |
bf5e38263a6279228305a969f64011b04bbebf56 | Donation in kind for working up the 'Hazel for Deputy' website from Mr Howard Dawber, Canary Wharf Group, London (Registered 10 July 2007) | Sponsorship or financial or material support 9e46def6 | 2007-07-17 | Hazel Blears uk.org.publicwhip/member/1802 | Hazel Blears uk.org.publicwhip/person/10048 | 8 | 2007-07-17-9e46def6-10048-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");