items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
21 rows where "date" is on date 2011-03-28 and person_id = "uk.org.publicwhip/person/10069" sorted by date descending
This data as json, CSV (advanced)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
00f134613a31fea3c092fb9d1cd594304293e33f | Address of donor: 1 Mosley Street, Newcastle upon Tyne, NE1 1YE. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 8 | 2011-03-28-8f616a6e-10069-0 |
0e9200d52993ede5cb9d94ace16031e3620d515b | Name of donor: Mr Chris Braithwaite | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 2 | 2011-03-28-8f616a6e-10069-0 |
1ab2e43818307d4668ed8548606877ff3658317a | Name of donor: GMB | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 7 | 2011-03-28-8f616a6e-10069-0 |
1adc83f297c88a3cb254b44210ceebd4ca868ad4 | Donor status: company | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 15 | 2011-03-28-8f616a6e-10069-0 |
335922296e76cc8a489cc2c4f6eab29c7b24b8de | Address of donor: Warwick Street, Newcastle, NE2 1BB. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 13 | 2011-03-28-8f616a6e-10069-0 |
36e7249f9d81b4f5e42d13eb035ea5fcd53c3b61 | Donor status: individual | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 5 | 2011-03-28-8f616a6e-10069-0 |
4e0b0e30c98978efbe6d74592455cf6977b2c1b6 | Address of donor: 71-73 Gillygate York YO31 7EA. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 23 | 2011-03-28-8f616a6e-10069-0 |
565eeb67e34a7522a56898e00bdcd9aa6d1bb739 | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 1 | 2011-03-28-8f616a6e-10069-0 | |
80c478e317ded2843c522c97d7a0e1e57dd4341c | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 0 | 2011-03-28-8f616a6e-10069-0 |
81409a747d74ea625635cffb71aa2011f771ae62 | Amount of donation or nature and value if donation in kind: £1,700 | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 24 | 2011-03-28-8f616a6e-10069-0 |
8d893c561c71907ded782141c166360f732e2d0b | Amount of donation or nature and value if donation in kind: £7,500 donated to the Newcastle East Parliamentary Association, which will report it to the Electoral Commission. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 4 | 2011-03-28-8f616a6e-10069-0 |
a75be83f21d5451f8e2770a6b08224311064aca3 | Name of donor: Unite North East | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 17 | 2011-03-28-8f616a6e-10069-0 |
a94ddd218727db52f338374313c37cd98e6fc811 | Address of donor: Transport House, John Dobson Street, Newcastle upon Tyne, NE1 8TW. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 18 | 2011-03-28-8f616a6e-10069-0 |
b3297b626b7d5d4769b8595f14a7ae3ea9b8d74a | Amount of donation or nature and value if donation in kind: £2,000 donated to the Newcastle East Parliamentary Association, which will report it to the Electoral Commission. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 19 | 2011-03-28-8f616a6e-10069-0 |
b486303f156133d83d09c999f0398e8562442649 | Name of donor: Flame Neal Ltd | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 12 | 2011-03-28-8f616a6e-10069-0 |
b8ceaed40379cb49e9c508c7121210a0ab5bda44 | Address of donor: private | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 3 | 2011-03-28-8f616a6e-10069-0 |
c75c2bbc20a3c3133d7adeec7dc992bad8a2f9fa | (Registered 9 June 2010) | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 21 | 2011-03-28-8f616a6e-10069-0 |
d67d70ec4825aeff5a5f92d3d867571f600993eb | Name of donor: CWU | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 22 | 2011-03-28-8f616a6e-10069-0 |
d7a9cdde3a7e15adb4120dd7c1de9d42f15ad7f4 | (Registered 8 July 2010) | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 26 | 2011-03-28-8f616a6e-10069-0 |
e5f8aed29828f7b6e63f6fa4c6f341cfd6f27200 | Donor status: trade union | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 25 | 2011-03-28-8f616a6e-10069-0 |
f372f577b87ab64dcf7fd1483e58fd7aa3aba1ad | Amount of donation or nature and value if donation in kind: £3,500 donated to the Newcastle East Parliamentary Association, which will report it to the Electoral Commission. | Sponsorships 8f616a6e | 2011-03-28 | Nick Brown uk.org.publicwhip/member/40420 | Nick Brown uk.org.publicwhip/person/10069 | 9 | 2011-03-28-8f616a6e-10069-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");