items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2012-10-01-a41b9847-10001-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 |
---|---|---|---|---|---|---|---|
02b1ad0857bfbd3faba293c3ad8ecc13036dd2b3 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2012-10-01-a41b9847-10001-0 |
a13029f8d048303186fab50b6c5d2965cc7d7e5c | Name of donor: Cartan Tours Inc, | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2012-10-01-a41b9847-10001-0 |
a2651eef207ba2b6f8e5267fe6428dc8defc5df4 | Address of donor : 1334 Parkview Ave Suite 200, Manhattan Beach CA 90266. | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2012-10-01-a41b9847-10001-0 |
62e52e1db37e09b86655943ca8d91e5103c35387 | Amount of donation or nature and value if donation in kind: two tickets for Olympics athletics event on 5 August 2012; total value £840 | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2012-10-01-a41b9847-10001-0 |
993dd2b1e64aaf4011acf4584b69c12b5dedbffc | Date of receipt of donation: 28 July 2012 | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2012-10-01-a41b9847-10001-0 |
ec2f26844ec1d3979835275f7f9474da909ff9f0 | Date of acceptance of donation: 28 July 2012 | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2012-10-01-a41b9847-10001-0 |
6a2613aa07690efb524b0711e70b9b9b123cfa04 | Donor status: company registered in US | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2012-10-01-a41b9847-10001-0 |
8e2cd12594e09cd67943d8baf555e341a24a2775 | (Registered 16 August; updated 10 September 2012) | Overseas benefits and gifts a41b9847 | 2012-10-01 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2012-10-01-a41b9847-10001-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");