items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
32 rows where category_id = "28e22fe3" and member_id = "uk.org.publicwhip/member/40115" sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, date, sort_order, record_id
date (date) 16 ✖
- 2010-09-06 2
- 2010-10-25 2
- 2010-11-08 2
- 2010-11-22 2
- 2010-12-06 2
- 2010-12-20 2
- 2011-01-10 2
- 2011-01-24 2
- 2011-02-07 2
- 2011-02-28 2
- 2011-03-14 2
- 2011-03-28 2
- 2011-04-18 2
- 2011-05-03 2
- 2011-05-16 2
- 2011-06-06 2
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
788053db3077f6f13b4d1c8bade098d777faee6d | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-06-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-06-06-28e22fe3-24913-0 |
bb2a122e6da4ab4a3205587a1d3d5bb4a9291a6e | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-06-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-06-06-28e22fe3-24913-0 |
965b2aa0c6356a8e008a7334b39b4b157dfd64cb | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-16-28e22fe3-24913-0 |
8d490a4dfc78d3f5db16b1fda599596432c3bfc4 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-05-16 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-05-16-28e22fe3-24913-0 |
5e0c2871160e29183dc259ff8f290161b749750a | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-05-03 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-05-03-28e22fe3-24913-0 |
500859b348e2477be60c5e4252b9183e7b44f732 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-05-03 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-05-03-28e22fe3-24913-0 |
172796867d7aff7a187373f65b20faa4df23cde2 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-04-18-28e22fe3-24913-0 |
3822ff5634c9ce2640d48721d3bb35d667a471d5 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-04-18 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-04-18-28e22fe3-24913-0 |
4116f49e4690ad4209ba937459c978727a9b5766 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-28-28e22fe3-24913-0 |
fbb3654801d3e7af9042f8eaf7fc974fcf9f1e56 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-03-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-03-28-28e22fe3-24913-0 |
6147772cfd1b9bca939704e4456e3f56f56941af | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-03-14-28e22fe3-24913-0 |
d083389ef180f1a15a434be7c11b3d3997cd0a61 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-03-14 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-03-14-28e22fe3-24913-0 |
e701a7e78b8589459db9009ac98f38c27db1a125 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-02-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-02-28-28e22fe3-24913-0 |
421cebf40e60bf82f29dcfdf59ed93ac415b370a | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 22 days. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-02-28 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-02-28-28e22fe3-24913-0 |
db141da6b85944c7ed7a8a2e15ea4ca48a67f4fb | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-02-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-02-07-28e22fe3-24913-0 |
93287e2dcde1079d4e5f7b8ebf01c569691a4ed5 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-02-07 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-02-07-28e22fe3-24913-0 |
6dc8681f5ff9b21f96ba8fd33895ddeacc0fb36c | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-24-28e22fe3-24913-0 |
1762e1e3a98d00d2416a7861279c7bdd73458754 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-01-24 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-01-24-28e22fe3-24913-0 |
7dbc57d5b61af307b70f2fc7cc50c6492dfc7d7d | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2011-01-10 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2011-01-10-28e22fe3-24913-0 |
461c82f822a1098523b4dc9e23eb42c210be163e | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2011-01-10 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2011-01-10-28e22fe3-24913-0 |
e7e319b11a42d034f9798013d677fec979bff657 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2010-12-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-12-20-28e22fe3-24913-0 |
4465e8a02434e123b19a80f69a565257c074a2d2 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2010-12-20 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-12-20-28e22fe3-24913-0 |
31ea34f3032d1eb517875e313c7913b1262f9d1b | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2010-12-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-12-06-28e22fe3-24913-0 |
88d3bbfef3385c17c7825efc5aef7e7cee795529 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2010-12-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-12-06-28e22fe3-24913-0 |
2119b4f88bc41ef68c8012941dd559e024916d38 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2010-11-22 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-22-28e22fe3-24913-0 |
db94402cfb177c6ac0e2c770f6d6efe6816a5e33 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2010-11-22 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-11-22-28e22fe3-24913-0 |
16a0cfd1489c8978b353d265ae179d957223f993 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-11-08-28e22fe3-24913-0 |
6fb6638eb2cfb606e86eb1e6c7a3897bc379395f | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2010-11-08 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-11-08-28e22fe3-24913-0 |
43d4768ecb7b68d95346cf2c43a5c77b4ea868a5 | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2010-10-25 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-10-25-28e22fe3-24913-0 |
3742fdd6619906c1d1a2d83739376493c1d3c01d | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2010-10-25 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-10-25-28e22fe3-24913-0 |
799a8573c215494e368026adfa5208c9f0355e0e | Of MacLeod Consulting Group Ltd: | Clients 28e22fe3 | 2010-09-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 0 | 2010-09-06-28e22fe3-24913-0 |
d7d5eb7e437e864f43aaf7930f7b6da8665cda15 | Payment of £20,375 from Royal Bank of Scotland, 199 Bishopsgate, London, for business and communications consultancy advice. Hours: 26 hrs. (Registered 7 June 2010) | Clients 28e22fe3 | 2010-09-06 | Mary Macleod uk.org.publicwhip/member/40115 | Mary Macleod uk.org.publicwhip/person/24913 | 1 | 2010-09-06-28e22fe3-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");