items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
12 rows where member_id = "uk.org.publicwhip/member/1088" and person_id = "uk.org.publicwhip/person/10407" sorted by date
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, sort_order, record_id, date (date)
hash | item | category_id | date ▼ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
12b3a9944fdc226a6b8a3b44707d292aa5531b83 | Member of Harris Parliamentary Panel. (£1-£1,000) . Fees are paid to organisations nominated by me. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2002-05-14-1f359ece-10407-0 |
9cceff7a8017dac2ce709447026353a7017e6641 | Some fees from media work. The fees are paid to organisations nominated by me. | Remunerated employment, office, profession etc 1f359ece | 2002-05-14 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 1 | 2002-05-14-1f359ece-10407-0 |
af3dd0bdba2fe201a12a75c746d51cf548aff390 | House in Halifax. | Land and Property 4f1e6359 | 2002-11-26 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2002-11-26-4f1e6359-10407-0 |
95c8fdea27c04356ba39d0f3e2b39510607108cf | House in Halifax. | Land and Property 4f1e6359 | 2003-12-04 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2003-12-04-4f1e6359-10407-0 |
e08f110a7b30eb57c474618e656f23c278c7f03a | House in Halifax. | Land and Property 4f1e6359 | 2004-01-31 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2004-01-31-4f1e6359-10407-0 |
17db26aae74f1cffa48bed1ddb06e326e8f4a1a0 | House in Halifax. | Land and Property 4f1e6359 | 2004-05-21 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2004-05-21-4f1e6359-10407-0 |
f338ec653ea3c5285cda4f1ae686b711dd4e4f41 | House in Halifax. | Land and Property 4f1e6359 | 2004-07-16 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2004-07-16-4f1e6359-10407-0 |
802a59f2f1fe32d9e15976c6612cb120d26ee932 | House in Halifax. | Land and Property 4f1e6359 | 2004-09-08 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2004-09-08-4f1e6359-10407-0 |
6826053e4a61d274759e3a26b94d1b42c0ec4fa5 | House in Halifax. | Land and Property 4f1e6359 | 2004-10-22 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2004-10-22-4f1e6359-10407-0 |
35b7397a462e9822ca6ae08aef240da13a41cf42 | House in Halifax. | Land and Property 4f1e6359 | 2004-12-03 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2004-12-03-4f1e6359-10407-0 |
f00f9cb4007a8e1f1a832501cc58192dac503ccc | House in Halifax. | Land and Property 4f1e6359 | 2005-01-28 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2005-01-28-4f1e6359-10407-0 |
bb2f623f2bc646dfb682c2cbb3fb8db37096dfd4 | House in Halifax. | Land and Property 4f1e6359 | 2005-04-11 | Alice Mahon uk.org.publicwhip/member/1088 | Alice Mahon uk.org.publicwhip/person/10407 | 0 | 2005-04-11-4f1e6359-10407-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");