home / regmem

items

Data source: mySociety Data

17 rows where record_id = "2010-02-03-80ef1083-13934-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
8fb97738b3b42a26156112293da0a9b5601de0ba Names of donors: 1. Speaker of the National Assembly of Mauritius Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 0 2010-02-03-80ef1083-13934-0
951ca86f3fe0f519a3f5f4ca4110cb6a2c4742f2 2. Air Mauritius Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 1 2010-02-03-80ef1083-13934-0
de1d7af503eac8514a92ac08694df154d6cd062d Address of donor: 1. Parliament House, Port Louis, Mauritius Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 2 2010-02-03-80ef1083-13934-0
c4d9a11f1e3e1fb57e62ab880476a68dbb606947 2. Air Mauritius Centre, President John Kennedy Street, Port Louis, Mauritius Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 3 2010-02-03-80ef1083-13934-0
1df5a01707cf0855b3682d14dc76f772a87a8da6 Amount of donation (or estimate of the probable value): 1. £1,855 Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 4 2010-02-03-80ef1083-13934-0
38c07278714ef931326b6d79ddf2fb6601866c74 2. £1,000 donation covered accommodation and flights Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 5 2010-02-03-80ef1083-13934-0
af32b9d1b1350568c6e98dfdaa359cba94c4961c Destination of visit: Mauritius Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 6 2010-02-03-80ef1083-13934-0
00022b486fa1efdd9b19294d74a6001e58e0bc32 Date of visit: 22-29 July 2009 Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 7 2010-02-03-80ef1083-13934-0
712d5f467510aa5538da21800bf58ccd3564f20e Purpose of visit: All-party delegation invited by the Mauritian Speaker for discussions with the Prime Minister and government officials. Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 8 2010-02-03-80ef1083-13934-0
6b0b8504db01d27e8a668d58f2b61a5b824f2772 (Registered 17 August 2009 ) Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 9 2010-02-03-80ef1083-13934-0
2cf885997eed4bf26d1050a3c0c49ebc5293fe84 Name of donor: Results UK Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 10 2010-02-03-80ef1083-13934-0
9fe4539ce4e5598a7ca2b902f8cac8da64685af6 Address of donor: 25 Clemens Street, Leamington Spa, CV31 2DP. Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 11 2010-02-03-80ef1083-13934-0
cdbf96ad596c8e036e580973e69d0a00aeb2b46f Amount of donation (or estimate of the probable value): £1075.69 (flights and accommodation) Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 12 2010-02-03-80ef1083-13934-0
468f4f2329d618c2befa212d21ca2daa43d79489 Destination of visit: India (Mumbai and Delhi) Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 13 2010-02-03-80ef1083-13934-0
b9206c432c7f52bac675683f27693cffc6b81c7a Date of visit: 6-10 September 2009 Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 14 2010-02-03-80ef1083-13934-0
957c074393bfa164c3508ba61b7aeabc4451482d Purpose of visit: visit to Delhi and Mumbai with Results UK, a charity, to investigate problems of TB, HIV/AIDS, sanitation and water, with rag-pickers and slum-dwellers. Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 15 2010-02-03-80ef1083-13934-0
fdd5c8ac0e06650ea6c521d1de7b8b6293814c71 (Registered 13 January 2010) Overseas visits 80ef1083 2010-02-03 uk.org.publicwhip/member/2027 Virendra Sharma uk.org.publicwhip/person/13934 16 2010-02-03-80ef1083-13934-0

Advanced export

JSON shape: default, array, 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)
    )
Powered by Datasette · Query took 60.634ms · Data source: mySociety Data