items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
7 rows where record_id = "2013-02-25-80ef1083-11667-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 |
---|---|---|---|---|---|---|---|
4d4e48692a8b4b547dec2c15de5ebfe9f495245b | Name of donor: SCA Hygiene Products | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 0 | 2013-02-25-80ef1083-11667-0 |
3f9552aaba42c11899501553aae3e269a0f33f33 | Address of donor: Southfields Rd, Dunstable, Beds LU6 3EJ | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 1 | 2013-02-25-80ef1083-11667-0 |
75c7f1691d539c91a6865ea93fcc13b6796e01fa | Amount of donation (or estimate of the probable value): £1,176.20 for flights, accommodation and conference fees | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 2 | 2013-02-25-80ef1083-11667-0 |
28add93285c6cf8e6cef8fd18d7a4c1b06df51dd | Destination of visit: Copenhagen | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 3 | 2013-02-25-80ef1083-11667-0 |
77392571a199f7fa93abc3857751d4fc2bf42ccf | Date of visit: 23 to 25 April 2012 | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 4 | 2013-02-25-80ef1083-11667-0 |
117c62b4b98a1b6489abfe85df2a64e00c6d7d78 | Purpose of visit: to attend Global Forum on Incontinence as a guest of SCA | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 5 | 2013-02-25-80ef1083-11667-0 |
f71f6f2390c9647d273d53c55c9b849876bd19e4 | (Registered 18 May 2012) | Overseas visits 80ef1083 | 2013-02-25 | Rosie Cooper uk.org.publicwhip/member/40651 | Rosie Cooper uk.org.publicwhip/person/11667 | 6 | 2013-02-25-80ef1083-11667-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");