home / regmem

items

Data source: mySociety Data

20 rows where record_id = "2018-06-18-64e8edeb-10040-0" sorted by sort_order

View and edit SQL

hash item category_id date member_id person_id sort_order record_id
a2231734ffb7cd7298c4027d588005ae429222a9 Name of donor: The Queens Club Address of donor: Palliser Road, London W14 9EQ Amount of donation or nature and value if donation in kind: two tickets to attend the Aegon Championships, with associated hospitality; value £630 Date received: 25 June 2017 Date accepted: 25 June 2017 Donor status: company, registration 23072 (Registered 05 July 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 0 2018-06-18-64e8edeb-10040-0
57e8890d08d8e7ca402f417c6bd1e7eadda8c4e2 Name of donor: All England Lawn Tennis Club, Church Road, Wimbledon, London SW19 5AE Amount of donation or nature and value if donation in kind: two tickets for the Royal Box at the Wimbledon championships on 13 July 2017, estimated value £8,590 Date received: 13 July 2017 Date accepted: 13 July 2017 Donor status: company, registration 07546773 (Registered 17 July 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 1 2018-06-18-64e8edeb-10040-0
bfa7b5fc9a4d66da8098e3adad1edd1c5b42d9a2 Name of donor: Lancashire County Cricket Club Address of donor: Emirates Old Trafford, Manchester M16 0PX Amount of donation, or nature and value if donation in kind: Ticket to attend the Test Match on 5 August 2017, and associated hospitality, total value £420 Date received: 5 August 2017 Date accepted: 5 August 2017 Donor status: company, registration IP28451R. (Registered 24 August 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 2 2018-06-18-64e8edeb-10040-0
5d8f682adb09e769895826432de1371b49c05cd0 Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 9 September 2017, with associated hospitality; total value £330 Date received: 9 September 2017 Date accepted: 9 September 2017 Donor status: individual. (Registered 28 September 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 3 2018-06-18-64e8edeb-10040-0
0a4dea485d07e8d6c4e22eb262833e640ae08a4b Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 14 September 2017, with associated hospitality; total value £330 Date received: 14 September 2017 Date accepted: 14 September 2017 Donor status: individual. (Registered 28 September 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 4 2018-06-18-64e8edeb-10040-0
a77c9a0db91a078e3012ee797074b7b1745ffcba Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a boxing match on 16 September 2017, with associated hospitality; total value £400 Date received: 16 September 2017 Date accepted: 16 September 2017 Donor status: individual. (Registered 28 September 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 5 2018-06-18-64e8edeb-10040-0
310e19d424bf9ecbcc2bac536aec920c4b0042d1 Name of donor: Norwich City Football Club Address of donor: Carrow Road, Norwich NR 1JE Amount of donation or nature and value if donation in kind: two tickets to attend a football match on 14 October 2017, and associated hospitality; total value £511.63 Date received: 14 October 2017 Date accepted: 14 October 2017 Donor status: company, registration 00154044. (Registered 23 October 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 6 2018-06-18-64e8edeb-10040-0
de197604668e0c1206c29ac799266ba2305f9e00 Name of donor: Manchester City Football Club Address of donor: Etihad Stadium, Etihad Campus, Manchester M11 3FF Amount of donation or nature and value if donation in kind: two tickets to attend a football match on 5 November 2017, and associated hospitality; total value £2,400 Date received: 5 November 2017 Date accepted: 5 November 2017 Donor status: company, registration 40946 (Registered 28 November 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 7 2018-06-18-64e8edeb-10040-0
1b83f4f7610d917c9da5e4ecf558e3c3b46b8cf2 Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: four tickets to attend the ATP World Tour Finals on Sunday 12 November 2017, and associated hospitality; total value £426.40 Date received: 12 November 2017 Date accepted: 12 November 2017 Donor status: unincorporated association (Registered 28 November 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 8 2018-06-18-64e8edeb-10040-0
1ac4c0067fb3d35f096be0fdb17f6ff053a79021 Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Tuesday 14 November 2017, and associated hospitality; total value £286.40 Date received: 14 November 2017 Date accepted: 14 November 2017 Donor status: unincorporated association (Registered 28 November 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 9 2018-06-18-64e8edeb-10040-0
93611171ccca3d787a7bed69c1c92f1d24f5fabe Name of donor: Association of Tennis Professionals Address of donor: Palliser House, Palliser Road, London W14 9EB Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Thursday 16 November 2017, and associated hospitality; total value £286.40 Date received: 16 November 2017 Date accepted: 16 November 2017 Donor status: unincorporated association (Registered 28 November 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 10 2018-06-18-64e8edeb-10040-0
f051805738cfed9ece0450656e83ccbf1cb748dc Name of donor: Lawn Tennis Association Address of donor: 100 Priory Lane, London SW15 5JQ Amount of donation or nature and value if donation in kind: two tickets to attend the ATP World Tour Finals on Sunday 19 November 2017, and associated hospitality; total value £480 Date received: 19 November 2017 Date accepted: 19 November 2017 Donor status: company, registration 07459469 (Registered 30 November 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 11 2018-06-18-64e8edeb-10040-0
571e675d57b39bb3b58e7917230221422fcca333 Name of donor: Arsenal Football Club Address of donor: Highbury House, 75 Drayton Park, London N5 1BU Amount of donation or nature and value if donation in kind: two tickets to attend a football match on 29 November 2017, and associated hospitality; total estimated value £500 Date received: 29 November 2017 Date accepted: 29 November 2017 Donor status: company, registration 00109244 (Registered 20 December 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 12 2018-06-18-64e8edeb-10040-0
e8b1f8a51ac03c6bc053f28950372936c7d0de54 Name of donor: Arsenal Football Club Address of donor: Highbury House, 75 Drayton Park, London N5 1BU Amount of donation or nature and value if donation in kind: two tickets to attend a football match on 10 December 2017, and associated hospitality; total estimated value £500 Date received: 10 December 2017 Date accepted: 10 December 2017 Donor status: company, registration 00109244 (Registered 20 December 2017) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 13 2018-06-18-64e8edeb-10040-0
c60db3003509056119b1a336784d8fde175b3147 Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 1 March 2018, with associated hospitality; total value £330 Date received: 1 March 2018 Date accepted: 1 March 2018 Donor status: individual (Registered 06 March 2018) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 14 2018-06-18-64e8edeb-10040-0
fe389496a3015b0e52b526f4c0939a7ac12a3778 Name of donor: Brighton and Hove Albion Football Club Address of donor: American Express Community Stadium, Village Way, Falmer BN1 9BL Amount of donation, or nature and value if donation in kind: Two tickets to attend a football match, and associated hospitality; total value £528 Date received: 4 March 2018 Date accepted: 4 March 2018 Donor status: company, registration 81077 (Registered 13 March 2018) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 15 2018-06-18-64e8edeb-10040-0
c1d37893726549ce5b707c97f4594ab98c5f7162 Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 5 April 2018, with associated hospitality; total value £330 Date received: 5 April 2018 Date accepted: 5 April 2018 Donor status: individual (Registered 12 April 2018) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 16 2018-06-18-64e8edeb-10040-0
000184b8529f6060a101851f0489e1575a4aa55c Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 8 April 2018, with associated hospitality; total value £330 Date received: 8 April 2018 Date accepted: 8 April 2018 Donor status: individual (Registered 12 April 2018) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 17 2018-06-18-64e8edeb-10040-0
531577a601637112676b3f9e59baebb51272f33d Name of donor: Frank Warren Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 22 April 2018, with associated hospitality; total value £330 Date received: 22 April 2018 Date accepted: 22 April 2018 Donor status: individual (Registered 24 April 2018) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 18 2018-06-18-64e8edeb-10040-0
bc60e42973469d160c12d3169dd99423785f2225 Name of donor: Ravi Gill Address of donor: private Amount of donation, or nature and value if donation in kind: Two tickets for a football match on 29 April 2018, with associated hospitality; total value £810 Date received: 29 April 2018 Date accepted: 29 April 2018 Donor status: individual (Registered 09 May 2018) Gifts, benefits and hospitality from UK sources 64e8edeb 2018-06-18 John Bercow uk.org.publicwhip/person/10040 19 2018-06-18-64e8edeb-10040-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 5.898ms · Data source: mySociety Data