items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
16 rows where category_id = "1aeb07b2" and member_id = "uk.org.publicwhip/member/40115" sorted by date descending
This data as json, CSV (advanced)
date (date) 16 ✖
- 2010-09-06 1
- 2010-10-25 1
- 2010-11-08 1
- 2010-11-22 1
- 2010-12-06 1
- 2010-12-20 1
- 2011-01-10 1
- 2011-01-24 1
- 2011-02-07 1
- 2011-02-28 1
- 2011-03-14 1
- 2011-03-28 1
- 2011-04-18 1
- 2011-05-03 1
- 2011-05-16 1
- 2011-06-06 1
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
592ecac5fb09bd085c8afbff340ee7235e6d128b | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-06-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-06-06-1aeb07b2-24913-0 |
04b05f9ff5981d057ca08d8c6dd8db8b5407203f | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-16-1aeb07b2-24913-0 |
ed448da5461a376bfd72ded33365e18529abbbb6 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-05-03 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-03-1aeb07b2-24913-0 |
a356f19bdd1c20f888e2b88dfa1d28d057e2f760 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-04-18-1aeb07b2-24913-0 |
583c19fb68bc2c1e16598c2b035c902f77f9b5f3 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-28-1aeb07b2-24913-0 |
6a7f98ef4c10698498481814c6bbcd34bd2413b3 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-14-1aeb07b2-24913-0 |
74fdb347a19005fa33632384bf0c385ad16ac990 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-02-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-02-28-1aeb07b2-24913-0 |
2d4300bcc3637ff02b9c1bde3a0674ab1cdd9e67 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-02-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-02-07-1aeb07b2-24913-0 |
33d58ecae425472ea730e052e8cf6b9ea60c40f9 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-24-1aeb07b2-24913-0 |
a53acb4ef4d5d7dde9e41bb4cd6baed61c475da7 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2011-01-10 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-10-1aeb07b2-24913-0 |
9b782bde339d94971fa38f07f7140d8c8c2b92ec | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-12-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-12-20-1aeb07b2-24913-0 |
c2eecfa57c6a81d817cff5e54b41b68d5e28978c | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-12-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-12-06-1aeb07b2-24913-0 |
ed799c0bac3da54b3e82b110623b834aa9a51a74 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-11-22 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-22-1aeb07b2-24913-0 |
1cb1a4477eb72c4a852ac0516d594bceae0c0736 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-08-1aeb07b2-24913-0 |
9e7a4ad50123bd7b6852f561d39da22b09c25427 | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-10-25 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-10-25-1aeb07b2-24913-0 |
27224c20ddc7c4d93f555d5807f464a4f90f790c | MacLeod Consulting Group Ltd, 64 Knightsbridge, London SW1X 7JF. (Company ceased trading from 31 May 2010) | Directorships 1aeb07b2 | 2010-09-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-09-06-1aeb07b2-24913-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");