items

Data source: mySociety Data · About: simonw/register-of-members-interests

44 rows where member_id = "uk.org.publicwhip/member/1061" sorted by date descending

View and edit SQL

Suggested facets: item, category_id, date, sort_order, date (date)

hash item category_id date ▲ member_id person_id sort_order record_id
69b2e80d861cc6234ae499ee2c9c9b652067ba4c County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2005-04-11 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2005-04-11-ead1ca87-10376-0
ed046b308825004d8c798501fe418c3a524984e8 Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2005-04-11 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2005-04-11-4f1e6359-10376-0
90f3e5f3436e9400699cf948ba2d1044cf00eb52 Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2005-04-11 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2005-04-11-4f1e6359-10376-0
23454637cdcb2b86cfe346ad8ee070f73d37a509 (a) County Pub Company Ltd. Registrable shareholdings 3aff2389 2005-04-11 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2005-04-11-3aff2389-10376-0
f857fa997ff7eaacddeab93963001e60c9b9421a County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2005-01-28 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2005-01-28-ead1ca87-10376-0
90c2d1951e6e80bfc3f6e4cd5056b5d170a4b5af Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2005-01-28 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2005-01-28-4f1e6359-10376-0
4f603df017dcf6d9abe5a8e063d49c88c36c611e Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2005-01-28 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2005-01-28-4f1e6359-10376-0
49829445996c35f5c0cedf2e2bda3c0753b9839f (a) County Pub Company Ltd. Registrable shareholdings 3aff2389 2005-01-28 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2005-01-28-3aff2389-10376-0
510a39179bd80c19aa5c87f94405007dac61752d County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2004-12-03 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-12-03-ead1ca87-10376-0
264cafc16509e4e418d4e408f746fc7d56ae90a8 Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2004-12-03 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-12-03-4f1e6359-10376-0
6395cac2a97c10a2bd31768a9631769a204fb2f0 Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2004-12-03 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2004-12-03-4f1e6359-10376-0
8255b6d398fe04a96895974aa92957d6027c969c County Pub Company Ltd. Registrable shareholdings 3aff2389 2004-12-03 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-12-03-3aff2389-10376-0
946925a7ea628b1f78d49fe0203ed33b261675c1 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2004-10-22 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-10-22-ead1ca87-10376-0
12751a4c7f97806e5ad976a9826154cf6f58983e Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2004-10-22 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-10-22-4f1e6359-10376-0
db455a78b937ff94b4355916339e089348898146 Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2004-10-22 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2004-10-22-4f1e6359-10376-0
f5500a58ea2e806c3967b06229f562e8bad08388 County Pub Company Ltd. Registrable shareholdings 3aff2389 2004-10-22 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-10-22-3aff2389-10376-0
fecf042e7c7317f4518fbae7b7fdc93abca10951 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2004-09-08 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-09-08-ead1ca87-10376-0
8734fdf21423157534ac0778f7359140e03100e5 Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2004-09-08 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-09-08-4f1e6359-10376-0
15f386bb0e2e3a22415b8a734a85a92192dcf1fa Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2004-09-08 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2004-09-08-4f1e6359-10376-0
b110e152be34e65a476d6fbfaf3025f909645829 County Pub Company Ltd. Registrable shareholdings 3aff2389 2004-09-08 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-09-08-3aff2389-10376-0
339ccb152f4378e0e0495dc3ba20d9cfdd88dca8 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2004-07-16 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-07-16-ead1ca87-10376-0
b79cfc976b9e716ad0abdb5957c7bbb7914c80bb Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2004-07-16 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-07-16-4f1e6359-10376-0
448b2e6a35f8f5a792a5a0efc6e437013a1ae1db Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2004-07-16 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2004-07-16-4f1e6359-10376-0
cbb4ef6afa4256663df155e8d13082a5b1ae798d County Pub Company Ltd. Registrable shareholdings 3aff2389 2004-07-16 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-07-16-3aff2389-10376-0
09dbd1d8f58a05c99933237b884edcf90d870378 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2004-05-21 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-05-21-ead1ca87-10376-0
bff9f2868466bbeeb375010a0810ed3d954e6b3d Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2004-05-21 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-05-21-4f1e6359-10376-0
05ea68ec377212c15cde1eee44f2e6fe86cf670b Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2004-05-21 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2004-05-21-4f1e6359-10376-0
78701e6d1dcc917dc0e74abbfecfe7e8ebb82258 County Pub Company Ltd. Registrable shareholdings 3aff2389 2004-05-21 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-05-21-3aff2389-10376-0
57d0c9e517e897b3e0ec019c0454d5c9b9a39bd7 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2004-01-31 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-01-31-ead1ca87-10376-0
d6a46317bdc1212173a418ad820d2ee3333ab8dd Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2004-01-31 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-01-31-4f1e6359-10376-0
d86154a3d9e0ee052fea8a4dec3ca5e1ba4d4035 Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2004-01-31 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2004-01-31-4f1e6359-10376-0
b0e4d0e832d97180e0fa9f64ee4301c2e03551b4 County Pub Company Ltd. Registrable shareholdings 3aff2389 2004-01-31 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2004-01-31-3aff2389-10376-0
4c6cfdbc03d6611128489c8aac22e0de07719bc2 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2003-12-04 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2003-12-04-ead1ca87-10376-0
55fc67be8a6972b602dac56ab52943c7b6ce566d Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2003-12-04 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2003-12-04-4f1e6359-10376-0
14306b4a8b15beb54a76e73c2673bf2e197d328e Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2003-12-04 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2003-12-04-4f1e6359-10376-0
0e08001900d00938c58186d5abc12b1f075c4cd0 County Pub Company Ltd. Registrable shareholdings 3aff2389 2003-12-04 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2003-12-04-3aff2389-10376-0
fc52734e29aef83eb92ac3ed4e0e086be3e584a4 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2002-11-26 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-11-26-ead1ca87-10376-0
8742099401f5c2ab88a5f72a43f21d1d2191e99a Land in Cambuslang on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2002-11-26 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-11-26-4f1e6359-10376-0
6432ddaece17638c00c9fa3d730d98a248cb8846 Residential flat in London SW1, from which rental income is received. Land and Property 4f1e6359 2002-11-26 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 1 2002-11-26-4f1e6359-10376-0
be54fcf934e607794ef988558aa2d6d2295e40a6 County Pub Company Ltd. Registrable shareholdings 3aff2389 2002-11-26 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-11-26-3aff2389-10376-0
c3d296e46e97f77c71d545508ed988505cb03400 County Pub Company Limited, trading as The County Inn Public House. Remunerated directorships ead1ca87 2002-05-14 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-05-14-ead1ca87-10376-0
f4f6a04607eb6afe9aa32e1df6b901c841dbc7fb 17 March 2002, I received two hospitality tickets for the CIS Football Final provided by the Co-operative Insurance Society. (Registered 24 March 2002) Gifts, benefits and hospitality (UK) 84642823 2002-05-14 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-05-14-84642823-10376-0
4398e629a172c05a46923df44500aa77a114342d Land on which County Inn is situated (see Category 1). Land and Property 4f1e6359 2002-05-14 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-05-14-4f1e6359-10376-0
5c6699b756d296a7f6cb180ebc5ec110c8d9ed4f County Pub Company Ltd. Registrable shareholdings 3aff2389 2002-05-14 Thomas McAvoy uk.org.publicwhip/member/1061 Thomas McAvoy uk.org.publicwhip/person/10376 0 2002-05-14-3aff2389-10376-0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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");
Powered by Datasette · Query took 17.46ms · Data source: mySociety Data · About: simonw/register-of-members-interests