items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where record_id = "2007-06-05-9e46def6-10068-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 |
---|---|---|---|---|---|---|---|
f5d5a6d2b2682f4841c5e0da2f90427af6ff24f8 | Lord Bhattacharyya (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 0 | 2007-06-05-9e46def6-10068-0 |
b0fc7052e03e4f2f77184dc181de7b9d3cae0a65 | Mr Paul Myners (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 1 | 2007-06-05-9e46def6-10068-0 |
f8cb24ff4b1ddd3ac8e0e067e6a7c592ddb31e00 | Sir Sigmund Sternberg (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 2 | 2007-06-05-9e46def6-10068-0 |
46c57566d1385967f9e43edcb7171d0c9672ef51 | Lord Leitch (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 3 | 2007-06-05-9e46def6-10068-0 |
a8804f4c034eea03bff59181cc1161dd7e6301e2 | Lord Gregson (donation to Leadership Campaign Fund | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 4 | 2007-06-05-9e46def6-10068-0 |
23ec38713c41046832ade59b13c19b46d4099350 | Community Trade Union (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 5 | 2007-06-05-9e46def6-10068-0 |
7b8c393db3b5ca835bb0435f30fe4515d3343032 | Caparo Industries plc (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 6 | 2007-06-05-9e46def6-10068-0 |
840d7cbfd0ccde7c39118de14a3e8cdb530abf4a | Mr John Miskelly (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 7 | 2007-06-05-9e46def6-10068-0 |
5f36b98df58c76da91ada0fa44e92836b2031c00 | Lord Gavron (donation to Leadership Campaign Fund) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 8 | 2007-06-05-9e46def6-10068-0 |
295b61ea879cf256c120add907ee23ed458aaeb9 | Vehicle and driver support for Leadership Campaign from the Co-operative Party. | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 9 | 2007-06-05-9e46def6-10068-0 |
c914441e844faa3501a8ae5cd0a470d02e91246e | Design services for Leadership Campaign from Abbot Mead Vickers BBDO Ltd. | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 10 | 2007-06-05-9e46def6-10068-0 |
1284818cca5167a0acead541db39510129c56133 | (Registered 25 May 2007) | Sponsorship or financial or material support 9e46def6 | 2007-06-05 | Gordon Brown uk.org.publicwhip/member/1997 | Gordon Brown uk.org.publicwhip/person/10068 | 11 | 2007-06-05-9e46def6-10068-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");