items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
8 rows where record_id = "2013-09-09-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 |
---|---|---|---|---|---|---|---|
02326046f7b287b85761e6c94e8df194d0ff8ba9 | See my entry in Category 2. | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 0 | 2013-09-09-a41b9847-10001-0 |
ae3832e40781dce0eaffa60c69f0e593673ab65e | Name of donor: Cartan Tours Inc, | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 1 | 2013-09-09-a41b9847-10001-0 |
9f14bbbac18a021c0bdb0e7405c0cb3a9939b8de | Address of donor : 1334 Parkview Ave Suite 200, Manhattan Beach CA 90266. | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 2 | 2013-09-09-a41b9847-10001-0 |
71be1f0cb006306cbc094c74a91f810d05bc64bc | 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 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 3 | 2013-09-09-a41b9847-10001-0 |
e05df2cbc409b9030f18ced1641e825206699c9d | Date of receipt of donation: 28 July 2012 | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 4 | 2013-09-09-a41b9847-10001-0 |
2d6215a6f135a4a8ed5dcfe07d8419a8b19ecf19 | Date of acceptance of donation: 28 July 2012 | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 5 | 2013-09-09-a41b9847-10001-0 |
e56729752595554cdc816ed46f1668f915cb7b5d | Donor status: company registered in US | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 6 | 2013-09-09-a41b9847-10001-0 |
529e82ed91d82354393ed1ea3d235011785e2c56 | (Registered 16 August; updated 10 September 2012) | Overseas benefits and gifts a41b9847 | 2013-09-09 | Diane Abbott uk.org.publicwhip/member/40289 | Diane Abbott uk.org.publicwhip/person/10001 | 7 | 2013-09-09-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");