home / democracyclub

democracyclub

Custom SQL query returning 63 rows

Query parameters

This data as JSON, CSV

rowididnamehonorific_prefixhonorific_suffixgenderbirth_dateelectionparty_idparty_namepost_idpost_labelmapit_urlelectedparty_ppc_page_urlhomepage_urlwikipedia_urllinkedin_urlimage_urlproxy_image_url_templateimage_copyrightimage_uploading_userimage_uploading_user_noteselection_dateelection_currentparty_lists_in_useparty_list_positionold_person_idsgss_codeparlparse_idtheyworkforyou_urlparty_ec_idfavourite_biscuitscancelled_poll
15425 1147 Hugh McGuinness     male   98 party:85 UK Independence Party (UKIP) DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP85   0
15426 3005 Martin Lyon     male 1966-02-16 98 party:85 UK Independence Party (UKIP) DIW:E05004497 Bishopstoke East     http://ukipwinchester.com/martin-lyon/       https://static-candidates.democracyclub.org.uk/media/images/images/3005.png   other sjorford http://www.dailyecho.co.uk/news/12886165.ELECTION_2015__Meet_the_candidates___Winchester/?ref=twt 2016-05-05 0 0   34671.0       PP85   0
15427 16518 Christine McKeone         98 party:53 Labour Party DIW:E05004497 Bishopstoke East                       2016-05-05 0 0           PP53   0
15428 16519 Trevor Mignot         98 party:90 Liberal Democrats DIW:E05004497 Bishopstoke East                       2016-05-05 0 0           PP90   0
15429 16520 Ania Waterman         98 party:63 Green Party DIW:E05004497 Bishopstoke East                       2016-05-05 0 0           PP63   0
15430 16521 Tom Yates         98 party:52 Conservative and Unionist Party DIW:E05004497 Bishopstoke East                       2016-05-05 0 0   38693.0       PP52   0
15431 16525 John Peter Edwards         98 party:85 UK Independence Party (UKIP) DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP85   0
15432 16526 David Hubble         98 party:63 Green Party DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP63   0
15433 16527 Sue Toher         98 party:53 Labour Party DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP53   0
15434 16528 Anne Margaret Winstanley         98 party:90 Liberal Democrats DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP90   0
15435 16529 Chris Yates         98 party:52 Conservative and Unionist Party DIW:E05004498 Bishopstoke West ward                       2016-05-05 0 0           PP52   0
15436 16535 Ian Almeric Bennett         98 party:52 Conservative and Unionist Party DIW:E05004499 Botley ward                       2016-05-05 0 0           PP52   0
15437 16536 Chris Greenwood         98 party:85 UK Independence Party (UKIP) DIW:E05004499 Botley ward                       2016-05-05 0 0           PP85   0
15438 16537 Rupert Gregory Miles Kyrle Cllr   male   98 party:90 Liberal Democrats DIW:E05004499 Botley ward                       2016-05-05 0 0           PP90   0
15439 16538 Kevin Paul Williamson         98 party:53 Labour Party DIW:E05004499 Botley ward                       2016-05-05 0 0           PP53   0
15440 16539 Stephanie Louise Arnold         98 party:52 Conservative and Unionist Party DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0           PP52   0
15441 16540 Derek Daniels         98 party:85 UK Independence Party (UKIP) DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0           PP85   0
15442 16541 Steve Holes         98 party:90 Liberal Democrats DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0   38638.0       PP90   0
15443 16542 Shere Sattar         98 party:53 Labour Party DIW:E05004500 Bursledon and Old Netley ward                       2016-05-05 0 0           PP53   0
15444 16551 Haulwen Veronica Broadhurst         98 party:90 Liberal Democrats DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0           PP90   0
15445 16552 Pete House         98 party:85 UK Independence Party (UKIP) DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0   35199.0       PP85   0
15446 16553 Sarah Mann         98 party:53 Labour Party DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0           PP53   0
15447 16554 John Hamilton Reynolds         98 party:52 Conservative and Unionist Party DIW:E05004501 Chandler's Ford East ward                       2016-05-05 0 0           PP52   0
15448 16559 Peter Clayton         98 party:53 Labour Party DIW:E05004502 Chandler's Ford West ward                       2016-05-05 0 0           PP53   0
15449 16560 Keith Frederick Hatch         98 party:52 Conservative and Unionist Party DIW:E05004502 Chandler's Ford West ward                       2016-05-05 0 0           PP52   0
15450 16561 David Arthur Pragnell     male   98 party:90 Liberal Democrats DIW:E05004502 Chandler's Ford West ward             https://static-candidates.democracyclub.org.uk/media/images/images/16561.png   other mattl From Eastleigh Borough Council website: https://meetings.eastleigh.gov.uk/mgUserInfo.aspx?UID=50000082 2016-05-05 0 0           PP90   0
15451 16562 Andy Whitehouse         98 party:85 UK Independence Party (UKIP) DIW:E05004502 Chandler's Ford West ward                       2016-05-05 0 0           PP85   0
15452 16568 Mark Leonard Balaam         98 party:90 Liberal Democrats DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP90   0
15453 16569 Andy Moore         98 party:85 UK Independence Party (UKIP) DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP85   0
15454 16570 Simon Payne         98 party:52 Conservative and Unionist Party DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP52   0
15455 16571 Steve Phillips         98 party:53 Labour Party DIW:E05004503 Eastleigh Central                       2016-05-05 0 0           PP53   0
15456 16577 Mike Holliday         98 party:52 Conservative and Unionist Party DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP52   0
15457 16578 Alexander David Hughes         98 party:63 Green Party DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP63   0
15458 16579 Keith Iain McFarlane         98 party:85 UK Independence Party (UKIP) DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP85   0
15459 16580 Christopher Andrew Thomas         98 party:90 Liberal Democrats DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0           PP90   0
15460 16582 Kathy O'Neill         98 party:53 Labour Party DIW:E05004504 Eastleigh North ward                       2016-05-05 0 0   29090;38655       PP53   0
15461 16589 Nick Arnold         98 party:52 Conservative and Unionist Party DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP52   0
15462 16590 Pete Luffman         98 party:53 Labour Party DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP53   0
15463 16591 Darshan Singh Mann         98 party:90 Liberal Democrats DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP90   0
15464 16592 Jan Weller         98 party:85 UK Independence Party (UKIP) DIW:E05004505 Eastleigh South ward                       2016-05-05 0 0           PP85   0
15465 16597 Steven Dennis Broomfield         98 party:52 Conservative and Unionist Party DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP52   0
15466 16598 Rob Rushton         98 party:90 Liberal Democrats DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP90   0
15467 16599 Mary Shephard         98 party:53 Labour Party DIW:E05004506 Fair Oak and Horton Heath ward                       2016-05-05 0 0           PP53   0
15468 16600 Sheelagh de Carteret Cohen         98 party:52 Conservative and Unionist Party DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP52   0
15469 16601 Malcolm Robert Cross         98 party:90 Liberal Democrats DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP90   0
15470 16602 Hilary Daniels         98 party:85 UK Independence Party (UKIP) DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP85   0
15471 16603 Chris Rogers         98 party:53 Labour Party DIW:E05004507 Hamble-le-Rice and Butlocks Heath ward                       2016-05-05 0 0           PP53   0
15472 16604 Terry Crow         98 party:53 Labour Party DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP53   0
15473 16605 Liam Fleming         98 party:63 Green Party DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP63   0
15474 16606 Cynthia Margaret Garton Cllr   female   98 party:90 Liberal Democrats DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP90   0
15475 16607 Graham Robert Piper         98 party:52 Conservative and Unionist Party DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP52   0
15476 16608 Paul Michael Webber         98 party:85 UK Independence Party (UKIP) DIW:E05004509 Hedge End St John's ward                       2016-05-05 0 0           PP85   0
15477 16609 Daniel Edward Hatfield         98 party:52 Conservative and Unionist Party DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP52   0
15478 16610 Jean Leech         98 party:85 UK Independence Party (UKIP) DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP85   0
15479 16611 Beverley Anne Rose         98 party:90 Liberal Democrats DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP90   0
15480 16612 Michael Tibble         98 party:53 Labour Party DIW:E05004511 Hiltingbury East ward                       2016-05-05 0 0           PP53   0
15481 16623 Kevin Butt         98 party:53 Labour Party DIW:E05004512 Hiltingbury West ward                       2016-05-05 0 0           PP53   0
15482 16624 James Ian Duguid         98 party:90 Liberal Democrats DIW:E05004512 Hiltingbury West ward                       2016-05-05 0 0           PP90   0
15483 16625 Michael Joseph Hughes         98 party:52 Conservative and Unionist Party DIW:E05004512 Hiltingbury West ward                       2016-05-05 0 0           PP52   0
15484 16626 David John Aylwin Airey         98 party:90 Liberal Democrats DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0           PP90   0
15485 16627 Chris Martin         98 party:85 UK Independence Party (UKIP) DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0           PP85   0
15486 16628 Jamie Mills         98 party:52 Conservative and Unionist Party DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0           PP52   0
15487 16629 Siobhan O'Rourke         98 party:53 Labour Party DIW:E05004513 Netley Abbey ward                       2016-05-05 0 0   29116;38675       PP53   0
Powered by Datasette · Query took 0.907ms