items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
47 rows where category_id = "4f1e6359" and person_id = "uk.org.publicwhip/person/10031" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, member_id, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
3ac33f59ef5b14de3501c95bc891741f66dd83e3 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2008-01-22 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2008-01-22-4f1e6359-10031-0 |
ac117ae44bad709326aece0b09677ee6cd7cc668 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2008-01-09 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2008-01-09-4f1e6359-10031-0 |
59b69f59dc75c5eed0784f95d156133626b84ade | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-12-18 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-12-18-4f1e6359-10031-0 |
59fb273e6647ba327ab5ab6b9062120297494f88 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-12-04 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-12-04-4f1e6359-10031-0 |
46841d92b1687748c102faaeb5917f749e0491cb | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-11-20 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-11-20-4f1e6359-10031-0 |
6b2e48a030e4de01f5108fc504bedea97650b183 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-11-06 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-11-06-4f1e6359-10031-0 |
573aa506f5a97b94b0aab015f8994abad04b4600 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-10-23 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-10-23-4f1e6359-10031-0 |
705edb5d9dd1b98af13d634ccef3c9f44534019d | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-10-09 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-10-09-4f1e6359-10031-0 |
107c3bb31a8ddfab0d23a75254b05b53a7f2be5e | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-08-28 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-08-28-4f1e6359-10031-0 |
d0bc9d956f04fc8c105ed5eec34a9a7c096dabd1 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-07-30 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-07-30-4f1e6359-10031-0 |
082d42e6e5aeb04c12732a97e2ce800fa1e536dd | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-07-17 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-07-17-4f1e6359-10031-0 |
6bcba6a844f97a13b3dbe14e4e0eb96fd0c26bee | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-07-03 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-07-03-4f1e6359-10031-0 |
dce6ffe5778a9a84515121c5fc3bb457e83a7e67 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-06-19 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-06-19-4f1e6359-10031-0 |
926b4d0f140e82a3a45705b61af2c863eee9f781 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-06-05 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-06-05-4f1e6359-10031-0 |
7785809244036c4ade68ba1b2f6319dfafddf9e7 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-05-15 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-05-15-4f1e6359-10031-0 |
e0467bf65541550804009135f52fd2b4c585b6c0 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-05-01 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-05-01-4f1e6359-10031-0 |
6674d300ca804a2ff7f16afea23a313190d257ea | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-03-26 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-03-26-4f1e6359-10031-0 |
8bca1adab212032af02a97d21d2e5b22c9ffe009 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-03-13 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-03-13-4f1e6359-10031-0 |
9324f45bb77b783d98b65f71942dde346a834c04 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-02-27 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-02-27-4f1e6359-10031-0 |
9501d51e21e0b8fb361f152639cbe87d0da772f8 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-02-06 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-02-06-4f1e6359-10031-0 |
e7683ee261fcecd6bb9ab95f8ba05aed2a0c5e17 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-01-23 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-01-23-4f1e6359-10031-0 |
cf90d584925956f3089d0a90e50a589734e5eec1 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2007-01-09 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2007-01-09-4f1e6359-10031-0 |
e742f6e82dd6ae65e87683fc1a830724cb1441ed | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-12-11 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-12-11-4f1e6359-10031-0 |
5ff788a1bdd64c0f2949b2aa2834b10a68c4bf20 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-11-27 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-11-27-4f1e6359-10031-0 |
33ba664cea49096ab2036308d4732a82773b650a | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-11-06 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-11-06-4f1e6359-10031-0 |
6d55163dbf4d7c53d4116a24619f46ef06007f2b | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-09-19 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-09-19-4f1e6359-10031-0 |
8f3b2dd9cf84185636da1f6edfda8dd26692c5c4 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-07-25 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-07-25-4f1e6359-10031-0 |
78ee105db87f1c1d2094c3cef656919aa93f7408 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-06-21 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-06-21-4f1e6359-10031-0 |
d466ce9fb15fa9b8d4ff60abcab67c05f50e28e8 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-05-12 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-05-12-4f1e6359-10031-0 |
2579ef7b769be7fb796b4cf24fa4a80941c13e0f | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-03-24 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-03-24-4f1e6359-10031-0 |
aff855de99d317dd633f8ef2a18ba6db27d1e249 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-02-14 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-02-14-4f1e6359-10031-0 |
b28cf9ee9a6199aceb704616bbed12c6d3c2363a | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2006-02-13 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2006-02-13-4f1e6359-10031-0 |
63582f96ee2f5b8849e9d96731554775582fbf75 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2005-12-14 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2005-12-14-4f1e6359-10031-0 |
83ab007859bf4591b121edd20fd913ee9e07c572 | Residential rented property; flat in London. | Land and Property 4f1e6359 | 2005-11-01 | Margaret Beckett uk.org.publicwhip/member/1533 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2005-11-01-4f1e6359-10031-0 |
d3a501597a73d7c70e117ac71ffc8d36113fcecd | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2005-04-11 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2005-04-11-4f1e6359-10031-0 |
7f498cedd9276a1bf23d7ebfdf10792967d250e4 | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2005-01-28 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2005-01-28-4f1e6359-10031-0 |
785166788b31787db13f1dd4a235161bb53e067a | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2004-12-03 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2004-12-03-4f1e6359-10031-0 |
bbf9e4a81c060b1bb6eb4ff419994696c2cdbc15 | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2004-10-22 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2004-10-22-4f1e6359-10031-0 |
e6347ecaa09f7dc6a0bee06899ca5763efb5651a | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2004-09-08 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2004-09-08-4f1e6359-10031-0 |
01174358ed4ac596b0f25d7f32d86d3cc066dd8d | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2004-07-16 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2004-07-16-4f1e6359-10031-0 |
0632fbc6164188a5449dc7721698de7e82d9f908 | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2004-05-21 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2004-05-21-4f1e6359-10031-0 |
6872d5bc38ded801510cce52d68be3173101991f | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2004-01-31 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2004-01-31-4f1e6359-10031-0 |
44f17b2f611bd67e0bd6229bb33456db501bc391 | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2003-12-04 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2003-12-04-4f1e6359-10031-0 |
4213bafa1bf389e288162b6f4f059e63fc0f26fa | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2002-11-26 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2002-11-26-4f1e6359-10031-0 |
bd79f75fc0a630dc39a4f2fecd220630091a6e48 | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2002-05-14 | Margaret Beckett uk.org.publicwhip/member/721 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2002-05-14-4f1e6359-10031-0 |
7d2f734ca00028f78b90821c39f709ef41e02923 | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2001-05-14 | Margaret Beckett uk.org.publicwhip/member/31 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2001-05-14-4f1e6359-10031-0 |
52d0e37beead5ee9c11b484efe20cc6f30e806ee | Residential rented property; flat in Westminster, London SW1. | Land and Property 4f1e6359 | 2000-11-10 | Margaret Beckett uk.org.publicwhip/member/31 | Margaret Beckett uk.org.publicwhip/person/10031 | 0 | 2000-11-10-4f1e6359-10031-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");