home / regmem

items

Data source: mySociety Data

7 rows where record_id = "2011-03-14-84642823-11719-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
8352def1fe824659fb4408262d2f8ff1c181a509 Name of donor: British Transport Police Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 0 2011-03-14-84642823-11719-0
2688e4c2a64dae9f1b9cdc29dd0003d38d5c7bbc Address of donor : Force HQ, 25 Camden Road, London, NW1 9LN Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 1 2011-03-14-84642823-11719-0
9377ba68ade3bff2e2b400604fd2f0fa48e5a534 Amount of donation or nature and value if donation in kind: As a Special Constable for the British Transport Police, I am entitled to use my warrant card to travel on London Underground and on London buses. Value of an annual travel card for the London area is £1,904. Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 2 2011-03-14-84642823-11719-0
407b6945c7a0e8113b37a42f808744cb0574216d Date of receipt of donation: 2006 Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 3 2011-03-14-84642823-11719-0
6a4b694c5be8786bd6c1e51749f82d5af01b5628 Date of acceptance of donation: 2006 Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 4 2011-03-14-84642823-11719-0
d15a39eb24bcac3f51d121de584de16179ff63ee Donor status: Police Service Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 5 2011-03-14-84642823-11719-0
00089ed1f22b5d89914671829737b4288d2becce (Registered 3 September 2010) Gifts, benefits and hospitality (UK) 84642823 2011-03-14 uk.org.publicwhip/member/40407 David Davies uk.org.publicwhip/person/11719 6 2011-03-14-84642823-11719-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 3.848ms · Data source: mySociety Data