items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
22 rows where category_id = 59577839 and person_id = "uk.org.publicwhip/person/10086" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
7aa16e75bcfab1d65990b0940c3b4dec173e7dff | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-07-16 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-07-16-59577839-10086-0 | |
e710aab0370ac9e19b37d9099fb5feef806f4296 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-07-02 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-07-02-59577839-10086-0 | |
68112add46a41790495bd70af1d7de8ccdf991b0 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-06-18 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-06-18-59577839-10086-0 | |
e135a0207ef2e2a22170b006f4a0c5501515f7fc | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-06-04 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-06-04-59577839-10086-0 | |
c782ab1fb27a0614e88df23ccb13409a06bff3a3 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-05-14 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-05-14-59577839-10086-0 | |
657c646681381dff9883a5ab4092af5056f44651 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-04-30 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-04-30-59577839-10086-0 | |
f246cb71a29cd9da8564981d0c7e7a2781625c6a | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-04-16 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-04-16-59577839-10086-0 | |
7dbf5b010bf366f108759162fcb6d3ab1ae6aa3e | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-03-19 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-03-19-59577839-10086-0 | |
0f7882054ec28b7483d2d1ad52a9626ca7f55990 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-03-05 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-03-05-59577839-10086-0 | |
d9002dc403c9958a174b48012841b0144589757f | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-02-19 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-02-19-59577839-10086-0 | |
4a44dbcd3bab568b0332c45d641f90a54a98d907 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-02-05 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-02-05-59577839-10086-0 | |
03ed140bed56a160e09a3ac1562ff08e4947933c | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-01-22 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-01-22-59577839-10086-0 | |
8bca69a2d80acf6a22f217229fdf26e277ebe8ff | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2018-01-08 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2018-01-08-59577839-10086-0 | |
5ce137874421fc4c58e3792c5e029874d6d8cbad | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-12-11 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-12-11-59577839-10086-0 | |
4a519f830643156017c72915b708535f71f8c0ad | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-11-27 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-11-27-59577839-10086-0 | |
9b75c221134502c689355cdee2e985d8d4506301 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-11-13 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-11-13-59577839-10086-0 | |
a40a8872f7a40fa8aaf298658b8eac7fed880aa8 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-10-23 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-10-23-59577839-10086-0 | |
f2126048230fdc0d02c7d289f2dab0c27465a0b6 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-10-09 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-10-09-59577839-10086-0 | |
f5728543c01f6aaefdb169306c1a37554b03e6f6 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-09-11 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-09-11-59577839-10086-0 | |
8819c86c427bde996eb2ab16fdbbc2f362af1fef | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-08-29 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-08-29-59577839-10086-0 | |
9e21957cbabfaaa1bf47d70e5fdb5b6a0f73dd1b | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-07-31 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-07-31-59577839-10086-0 | |
2ef98d08883dba9572e4508283c85dc004e3fd51 | Between January and March 2017, I employed my daughter, Emily Campbell, as a part time Administrative Assistant. (Registered 06 July 2017) | Family members employed and paid from parliamentary expenses 59577839 | 2017-07-07 | Alan Campbell uk.org.publicwhip/person/10086 | 0 | 2017-07-07-59577839-10086-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");