items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
47 rows where record_id = "2014-04-07-8f616a6e-24954-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 |
---|---|---|---|---|---|---|---|
f17a97da4b44e444aa9fde3630e4c6489dba577a | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 0 | 2014-04-07-8f616a6e-24954-0 |
3c3b6a51d4dc899cd64ac600b605500f12f5f4cb | Name of donor: Mr Charles Hill | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 1 | 2014-04-07-8f616a6e-24954-0 |
80966b3781d02541e47df8930ca0bf5dd8b2f3e3 | (Registered 8 April 2013) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 5 | 2014-04-07-8f616a6e-24954-0 |
3c56378835150b7842ed56e244718d2f3c37fb36 | Name of donor: Paul Smith | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 6 | 2014-04-07-8f616a6e-24954-0 |
25ebc29d939f1030527c9966405cd5638b872891 | Amount of donation or nature and value if donation in kind: £3,000 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 8 | 2014-04-07-8f616a6e-24954-0 |
777c71ff0f0f768b03d0b9a4967944aff42d03ec | (Registered 10 June 2013) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 10 | 2014-04-07-8f616a6e-24954-0 |
17c922c4d05f90b4678a340f9be2723583c49bf7 | (Registered 17 October 2013 ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 20 | 2014-04-07-8f616a6e-24954-0 |
6c02630100935f6fcaf6608a1b002cb8b1a91d0e | (Registered 17 October 2013 ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 30 | 2014-04-07-8f616a6e-24954-0 |
37ad40d7cb9f09b19848c6e8c5203cb32f3a9317 | Name of donor: SunMark Ltd | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 31 | 2014-04-07-8f616a6e-24954-0 |
1a3195034f06c86796a7e75f6cab18f9a62ef426 | Address of donor: 428 Long Drive, Greenford UB6 8UH | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 32 | 2014-04-07-8f616a6e-24954-0 |
dd810b440626be952aaab3ad20dd403fcf710bb5 | Donor status: company, registration no 03010238 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 34 | 2014-04-07-8f616a6e-24954-0 |
049ccdb4e58bbb65803bcb65dfd840a2af758118 | (Registered 17 October 2013) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 35 | 2014-04-07-8f616a6e-24954-0 |
b0d0197027fc7a47741e065487bb7c87ac4fcf08 | (Registered 4 December 2013 ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 40 | 2014-04-07-8f616a6e-24954-0 |
fb69cf31c172d7a646e0c32c3e2b7248b7486750 | (Registered 16 December 2013 ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 45 | 2014-04-07-8f616a6e-24954-0 |
96ea6a455d8165c917fed2b783047cc394d1ec37 | (Registered 16 December 2013, together with the donation listed next below ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 50 | 2014-04-07-8f616a6e-24954-0 |
eed2c36b4d23cd436473091de16be56cda14f610 | (Registered 16 December 2013 ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 60 | 2014-04-07-8f616a6e-24954-0 |
8a368bc2ea4b0a7220192949f3ccfafdd0a35192 | Name of donor: AHV Associates LLP | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 61 | 2014-04-07-8f616a6e-24954-0 |
507c197686af27c048be667e65e9d9e04368f093 | Address of donor: 131 Edgware Rd, London W2 2AP | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 62 | 2014-04-07-8f616a6e-24954-0 |
b69f83a7ea1858508d8f778a18a35fade94f3a5e | Donor status: company, registration no C300238 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 64 | 2014-04-07-8f616a6e-24954-0 |
ffbc69239be08a67136883472da3653ba5825978 | Name of donor: JSA Services Ltd | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 66 | 2014-04-07-8f616a6e-24954-0 |
f2d6ac7fdba5567f15f2c4f07f60d50bb16f9eeb | Address of donor: Radius House, 51 Clarendon Road, Watford WD17 1HP | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 67 | 2014-04-07-8f616a6e-24954-0 |
922cff2253dadd744d3c4a85feac8f769efd71ba | Donor status: company, registration no 02407547 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 69 | 2014-04-07-8f616a6e-24954-0 |
14bf131280a204fbbc1bd110cfc5548ac8db5c20 | (Registered 28 February 2014 ) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 70 | 2014-04-07-8f616a6e-24954-0 |
797d2474c898000c7489bb008905de848f261083 | Name of donor: Mr Stephen Brook | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 86 | 2014-04-07-8f616a6e-24954-0 |
3f3babd19adfd2c6b6c1269ee2bef076876c0e26 | Name of donor: Mr Anil Sharma | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 91 | 2014-04-07-8f616a6e-24954-0 |
c49c341bd08f72301dc775d0f97f19fc0a295bd4 | (Registered 28 February 2014) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 95 | 2014-04-07-8f616a6e-24954-0 |
5bcfb8366ea0786e5fd15e5406d4b1c47b5fd9aa | Name of donor: Mrs Hilda Worth | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 96 | 2014-04-07-8f616a6e-24954-0 |
15d337ce76e95943a9b8774815278e068b7c5ffa | (Registered 28 February 2014) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 100 | 2014-04-07-8f616a6e-24954-0 |
5e7e1e1d545875d273b6af5d7385473b3f9d14df | Name of donor: Mr Peter Batey | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 101 | 2014-04-07-8f616a6e-24954-0 |
945b35669c0cb317ec947f7f80a2163bd1cfced6 | Amount of donation or nature and value if donation in kind: £9,985 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 103 | 2014-04-07-8f616a6e-24954-0 |
5c6474172e0059d0100f80296921ab4ded0fcfe9 | Name of donor: RST Residential Investments Ltd | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 106 | 2014-04-07-8f616a6e-24954-0 |
c512d74c1b0deeb7e92436b58205dc7f2cbb5d5d | Address of donor: 109 Gloucester Place, London W1U 6JW | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 107 | 2014-04-07-8f616a6e-24954-0 |
9fb430ca79452c70bdf423d17a3377d26ff27f88 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 108 | 2014-04-07-8f616a6e-24954-0 |
c5c644a3d668c8bf5348d3f567a0021864c3cf17 | Donor status: company, registration no 6775786 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 109 | 2014-04-07-8f616a6e-24954-0 |
5516f79c8950f50861fb220ccf9e060e1bace584 | Name of donor: Mr David Meller | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 111 | 2014-04-07-8f616a6e-24954-0 |
3971048e3ce3f9416611e8fee16ca0bde2cf7f46 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 113 | 2014-04-07-8f616a6e-24954-0 |
39bc9984ab215c443ceeac68068ce4aa5b818ed0 | Name of donor: United and Cecil Club | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 116 | 2014-04-07-8f616a6e-24954-0 |
133d9889ac8c8cc02ddaf13c0f6daa83eeec4fd9 | Address of donor: 18 Thorney Lane North, Iver, Bucks SL0 9JW | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 117 | 2014-04-07-8f616a6e-24954-0 |
832566f1b96d957bbcc4084256546b9df6ac4f20 | Amount of donation or nature and value if donation in kind: £2,500 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 118 | 2014-04-07-8f616a6e-24954-0 |
28df5bc50f02b42ecf2bef03e1f053f114a4601d | Donor status: members’ association | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 119 | 2014-04-07-8f616a6e-24954-0 |
1ca13a8a76ec5e9ed04237316e884929d15d6188 | Name of donor: Mr Roy Peires | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 121 | 2014-04-07-8f616a6e-24954-0 |
3f5e5e1d2651f4e8d49e255d16a960a53124af85 | Amount of donation or nature and value if donation in kind: £1,000 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 123 | 2014-04-07-8f616a6e-24954-0 |
85f45b5dded9708e4f39bab10119eda8f3b4ec9d | Name of donor: Mr Bradley Yam | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 126 | 2014-04-07-8f616a6e-24954-0 |
0e201b54de94beefb696e299b0ac73e9c37934c5 | Address of donor: private | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 127 | 2014-04-07-8f616a6e-24954-0 |
a3676537c2172508e59af6483937ca8695b4e34e | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 128 | 2014-04-07-8f616a6e-24954-0 |
cb55e3bd566e363225dc1264fc7b1115ec9fc352 | Donor status: individual | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 129 | 2014-04-07-8f616a6e-24954-0 |
c04e0adec6e6d8a8dfce4da8b008c44cb13eb872 | (Registered 18March 2014) | Sponsorships 8f616a6e | 2014-04-07 | Richard Harrington uk.org.publicwhip/member/40637 | Richard Harrington uk.org.publicwhip/person/24954 | 130 | 2014-04-07-8f616a6e-24954-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");