items
Data source: mySociety Data · About: simonw/register-of-members-interests-datasette
36 rows where person_id = "uk.org.publicwhip/person/10074" and sort_order = 7 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: item, category_id, date, date (date)
hash | item | category_id | date ▲ | member_id | person_id | sort_order | record_id |
---|---|---|---|---|---|---|---|
4ec07c237b5afa5b013d0b987376f7bf23bfed7e | Name of donor: Indian Government | Overseas visits 80ef1083 | 2012-01-13 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2012-01-13-80ef1083-10074-0 |
8e825e6fc2a60a107d8ddf191dd33a25a98dcb2e | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-12-13 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-12-13-80ef1083-10074-0 |
04d2d6a7114ee06d73254d6a185084e7d7549604 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-11-29 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-11-29-80ef1083-10074-0 |
c893ce4d2ff00c2be93da6e48c70fe3403ce421d | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-11-16 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-11-16-80ef1083-10074-0 |
084465ec2a1c6da65a5d9b5b041278b1ea2a7570 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-10-31 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-10-31-80ef1083-10074-0 |
eb9d863939873bcc5de705e0fdcc0f541543018c | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-10-17 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-10-17-80ef1083-10074-0 |
8f96048c4b788822f795840329a3b5298421d30c | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-09-28 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-09-28-80ef1083-10074-0 |
7df028bf59e16d2b33df218fd951c902c242769a | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-08-30 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-08-30-80ef1083-10074-0 |
2eb1d506c8d60756604cd98be678a15b242eca7e | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-07-19 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-07-19-80ef1083-10074-0 |
da37a31d2d683a452e826a2aef85800b76d12938 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-07-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-07-06-80ef1083-10074-0 |
951ddfc631ee1efd433300752c688dd38f48726f | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-06-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-06-20-80ef1083-10074-0 |
70e552700c5d50f0adf7bc0169495b73f3f76e16 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-06-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-06-06-80ef1083-10074-0 |
5089cbb8ea276226f1a7cdf3615522f85f6bf34d | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-05-16 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-05-16-8f616a6e-10074-0 |
86751c3e56b09df0049e8a193049a46f59effee6 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-05-16 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-05-16-80ef1083-10074-0 |
3c09141f9742f3b4a2eacc763b33fed3580e0d5f | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-05-03 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-05-03-8f616a6e-10074-0 |
4d62bf4c766ec31393e98cb2a593e1d9e3f1a45e | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-05-03 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-05-03-80ef1083-10074-0 |
f850b6bb153397eaa1c05d65c0b733493d73e48b | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-04-18 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-04-18-8f616a6e-10074-0 |
e7e584c1be13c153d38bb4d0c3681ff2702a57f7 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-04-18 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-04-18-80ef1083-10074-0 |
bcd189b68d564bdbe35f063e6764a46ae63e117c | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-03-28 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-03-28-8f616a6e-10074-0 |
747728cec90728ab752022298474d044b3a7360c | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-03-28 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-03-28-80ef1083-10074-0 |
5d3943cf4b8d2128e146194a1432f6b596d7a950 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-03-14 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-03-14-8f616a6e-10074-0 |
05f078aacd1486efae1d1d776d6b6a887c4a1ae3 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-03-14 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-03-14-80ef1083-10074-0 |
b59cdc10c185703edeecdffa32d3683fc454e1cd | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-02-28 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-02-28-8f616a6e-10074-0 |
006814ba049689b3ce79ddb4a293aa495ebdffaf | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-02-28 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-02-28-80ef1083-10074-0 |
b4eb1dfacdfc16dd68ea0d45901ac88746f6708f | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-02-07 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-02-07-8f616a6e-10074-0 |
7fc23d079a25462f290526cce44771caca5c15ff | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-02-07 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-02-07-80ef1083-10074-0 |
a1b86107e2441cc99405d013f2f89f023ffb9359 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-01-24 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-01-24-8f616a6e-10074-0 |
8979f985b991ae88cf281ef1c1bebb8abf3c9f66 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-01-24 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-01-24-80ef1083-10074-0 |
9254246e9316576170c20ebb49d8823a7619f0d1 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2011-01-10 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-01-10-8f616a6e-10074-0 |
05be2786770b96f36c2b3b6fe401be2dcab9c314 | Name of donor: Indian Government | Overseas visits 80ef1083 | 2011-01-10 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2011-01-10-80ef1083-10074-0 |
727253ad1b78b6ddb65ed131a965141d57d96910 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-12-20 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-12-20-8f616a6e-10074-0 |
ba42e75f82f6541cdac9bd184eb3130021ee2d23 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-12-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-12-06-8f616a6e-10074-0 |
09ac7be04377ae29a83529243edb5876f230b866 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-11-22 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-11-22-8f616a6e-10074-0 |
90039db00d897d933aba5ef7d85a9bdb2bbdbf43 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-11-08 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-11-08-8f616a6e-10074-0 |
8a392b7dadd465c43e45a77ccf17df4ecdcaa9c7 | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-10-25 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-10-25-8f616a6e-10074-0 |
f85ab11133dff7e58f6d8512d92da218bfa2a18f | Address of donor: 7 Deveron Road, Huntly | Sponsorships 8f616a6e | 2010-09-06 | Malcolm Bruce uk.org.publicwhip/member/40280 | Malcolm Bruce uk.org.publicwhip/person/10074 | 7 | 2010-09-06-8f616a6e-10074-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");