items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2013-05-07-8f616a6e-13934-0" sorted by category_id
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id ▼ | date | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
a1853c107fe1bf178ff8d93d117ee8bd3a9698ad | Support in the capacity as an MP: | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 0 | 2013-05-07-8f616a6e-13934-0 |
70cd5da9a8b83eb6360a5d674749335f1cff202d | Name of donor: Express Taxation & Accountancy Services Ltd, trading as Tack & Co Accountants | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 1 | 2013-05-07-8f616a6e-13934-0 |
3b0de1e695725a6e1069a2939b20dcc042316244 | Address of donor: 13-15 The Green, Southall, Middlesex UB2 4AH | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 2 | 2013-05-07-8f616a6e-13934-0 |
7aff86d3c99b75186c84ad8b849933fba275202d | Amount of donation or nature and value if donation in kind: rent free use of an office in the constituency; value £6,000 per annum. | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 3 | 2013-05-07-8f616a6e-13934-0 |
067e8117a1cccb8421191ce4311a3953d31191f8 | Date of receipt: received since 15 May 2008 | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 4 | 2013-05-07-8f616a6e-13934-0 |
af24955adbabcdd2629e9994cf9ae3c7f2be846a | Date of acceptance: received since 15 May 2008 | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 5 | 2013-05-07-8f616a6e-13934-0 |
797f4364afe3f56bdba5a1093c100c5b311a2e37 | Donor status: company, registration 03484457 | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 6 | 2013-05-07-8f616a6e-13934-0 |
f71d42eb26c664b107fca14fb81e251db9d30d62 | (Registered 24 July 2011; updated 5 September 2012) | Sponsorships 8f616a6e | 2013-05-07 | Virendra Sharma uk.org.publicwhip/member/40221 | Virendra Sharma uk.org.publicwhip/person/13934 | 7 | 2013-05-07-8f616a6e-13934-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");