items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
27 rows where record_id = "2011-05-16-8f616a6e-24913-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 |
---|---|---|---|---|---|---|---|
56d127988f009cb5b9ca56ede7218588927b412b | Donations to my constituency party or association, which have been or will be reported by my party to the Electoral Commission: | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-16-8f616a6e-24913-0 |
1570d6609b63c2d3fd5acb920449f405360cb4bf | Name of donor: Maurice Bennett | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-05-16-8f616a6e-24913-0 |
b4508d1668a49687ff6b675ddd9bec844b592c19 | Amount of donation or nature and value if donation in kind: £10,000 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 3 | 2011-05-16-8f616a6e-24913-0 |
c92650ea0ee59fe790a8f77c25ea82c058528702 | (Registered 7June 2010) | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 5 | 2011-05-16-8f616a6e-24913-0 |
f894f777a76245e35a4c8bfbeb69d2b890ef59c0 | Name of donor: Avtar Lit | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 6 | 2011-05-16-8f616a6e-24913-0 |
2c0ad48a45da69eedaa48d3860186438cf06deb5 | Amount of donation or nature and value if donation in kind: £5,000 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 8 | 2011-05-16-8f616a6e-24913-0 |
2b318bbd060ebb26e70af5bfaa383ec3a89dc602 | Name of donor: Mr W W Salomon | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 11 | 2011-05-16-8f616a6e-24913-0 |
5028edda7260f3e745a8381c488d4af868009a74 | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 13 | 2011-05-16-8f616a6e-24913-0 |
62e5983dfb1640ecfda6ede0497a6041d6b0ac55 | Name of donor: Mr Julian S Tanner | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 16 | 2011-05-16-8f616a6e-24913-0 |
086ffcdaa7daaa633061c881c1db45613272c0c9 | (Registered 7June 2010 ) | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 20 | 2011-05-16-8f616a6e-24913-0 |
16353da80aa430436acc414a7730cec1f53c750e | Name of donor: Mr Chris Lewis | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 21 | 2011-05-16-8f616a6e-24913-0 |
fcdc17df9af23f9908eaa8bc1aa9263d94f6a34b | Address of donor: private | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 22 | 2011-05-16-8f616a6e-24913-0 |
44e58da4a712a3fd6a9ceeb80300056bbb88178a | Amount of donation or nature and value if donation in kind: £2,000 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 23 | 2011-05-16-8f616a6e-24913-0 |
d79d60caab7c82a666dc5a79a4e482bcfd25166e | Donor status: individual | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 24 | 2011-05-16-8f616a6e-24913-0 |
f45fc70e7ff2b2f8a4ee87cebadb33da4c1a7ebe | (Registered 7 June 2010) | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 25 | 2011-05-16-8f616a6e-24913-0 |
16a53ac9db48a04a5a0dfca77d2462324359acc5 | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 26 | 2011-05-16-8f616a6e-24913-0 |
7cfee7f091d9a81b019f1039b5ea3b6d52f003e1 | Name of donor: Mr Stephen Brenninkmeijer | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 27 | 2011-05-16-8f616a6e-24913-0 |
4e403fdc1d2b0d9ce04f51f65fc1d4ad28b74933 | Date of receipt: 17 January 2011 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 30 | 2011-05-16-8f616a6e-24913-0 |
057a67a3b65b4f66734090a04e964a73b4b22e68 | Date of acceptance: 17 January 2011 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 31 | 2011-05-16-8f616a6e-24913-0 |
421e368679b210c2cfc77e0dd6319123361e476a | (Registered 24 February 2011) | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 33 | 2011-05-16-8f616a6e-24913-0 |
88b20babf522dba53f8831027aa47c1f52bcecae | Name of donor: Mr Maurice Bennett | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 34 | 2011-05-16-8f616a6e-24913-0 |
edcd63b1de0ddeec8312609b3f5baebe10e9fdfd | Address of donor: private | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 35 | 2011-05-16-8f616a6e-24913-0 |
aba74b4c1284b6a5cb8ac1e421deb6efe4f9f0c9 | Amount of donation or nature and value if donation in kind: £5,000 donation | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 36 | 2011-05-16-8f616a6e-24913-0 |
7ccd2c89aab488027b90121f16d9e8f8ddc93aac | Date of receipt: 24 March 2011 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 37 | 2011-05-16-8f616a6e-24913-0 |
793a4286c1e35a7b2d6287146cf83ef42e68f514 | Date of acceptance: 24 March 2011 | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 38 | 2011-05-16-8f616a6e-24913-0 |
92cfdcab76a3326334652280b65dfb810659513a | Donor status: individual | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 39 | 2011-05-16-8f616a6e-24913-0 |
060e70d7222414223efcad6f0c8c37caa95ecbae | (Registered 5 April 2011) | Sponsorships 8f616a6e | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 40 | 2011-05-16-8f616a6e-24913-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");