home / democracyclub

candidates

Data license: CC-BY-SA · Data source: Democracy Club

206 rows where election = 10

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, facebook_page_url, party_ppc_page_url, facebook_personal_url, homepage_url, linkedin_url, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, twitter_user_id, old_person_ids, party_ec_id

Link rowid id name honorific_prefix honorific_suffix gender birth_date election party_id party_name post_id post_label mapit_url elected party_ppc_page_url homepage_url wikipedia_url linkedin_url image_url proxy_image_url_template image_copyright image_uploading_user image_uploading_user_notes election_date election_current party_lists_in_use party_list_position old_person_ids gss_code parlparse_id theyworkforyou_url party_ec_id favourite_biscuits cancelled_poll
8582 8582 263 Jordan Newell     male   local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010828 Castle     http://www.labour.org.uk/people/detail/jordan-newell       https://static-candidates.democracyclub.org.uk/media/images/5481e7e2b150e238702c057c.png   profile-photo     2016-05-05 0 0   15367.0       PP53   0
8583 8583 264 Peter Lynn     male   local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010834 Mile End           https://uk.linkedin.com/in/peter-lynn-13a8135 https://static-candidates.democracyclub.org.uk/media/images/images/264.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   15482.0       PP63   0
8584 8584 833 Tim Glover     male   local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010843 Wivenhoe                       2016-05-05 0 0           PP63   0
8585 8585 836 John Spademan     male 1960-06-01 local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP53   0
8586 8586 2193 John Pitts     male   local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010832 Marks Tey & Layer             https://static-candidates.democracyclub.org.uk/media/images/55268e1159bbc5c063445b7e.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-c-e.html 2016-05-05 0 0           PP85   0
8587 8587 4312 Tim Young Mr   male 1961.0 local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010829 Greenstead     http://vote.labour.org.uk/tim-young     https://www.linkedin.com/in/tim-young-561b2637/ https://static-candidates.democracyclub.org.uk/media/images/553b8c847b9de399275bb49b.png   profile-photo edent This is the candidate’s twitter profile image, from https://twitter.com/Tim4Clacton 2016-05-05 0 0           PP53   0
8588 8588 5001 Mark Goacher Mr   male 1969.0 local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010828 Castle     https://my.greenparty.org.uk/candidates/105898 http://markgoachergreen.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/5001.png   profile-photo kdcm87 https://my.greenparty.org.uk/candidates/105898 2016-05-05 0 0   7915.0       PP63   0
8589 8589 5181 David Alexander Hough Mr   male 1959-08-29 local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010841 Stanway             https://static-candidates.democracyclub.org.uk/media/images/553aa4eec0ff2778587ee2b7.png   profile-photo edent From alternate Twitter account https://twitter.com/colchester1648 2016-05-05 0 0   15569.0       PP53   0
8590 8590 5435 Maria Vigneau     female   local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010833 Mersea & Pyefleet             https://static-candidates.democracyclub.org.uk/media/images/5526947559bbc5c063445bde.png   profile-photo JPCarrington As featured on official party PPC pages: http://www.myukip.com/parliamentary-candidates-f-k.html 2016-05-05 0 0           PP85   0
8591 8591 5497 Dominic Graham Mr   male   local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010834 Mile End       https://northeastessexlibdems.org.uk/en/contact/dominic-graham     https://static-candidates.democracyclub.org.uk/media/images/55191aef4ff096f44902d233.png   profile-photo domgraham@hotmail.co.uk http://northeastessexlibdems.org.uk/en/ 2016-05-05 0 0   15480.0       PP90   0
8592 8592 6228 Jo Hayes     Female   local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010828 Castle       http://johayes.mycouncillor.org.uk/about/#page-content     https://static-candidates.democracyclub.org.uk/media/images/553aa77c319151d456c24fab.png   profile-photo edent https://twitter.com/JoHayesLibDem 2016-05-05 0 0   24560.0       PP90   0
8593 8593 7138 Chris Flossman Mr   Male 1994-01-25 local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010829 Greenstead     https://my.greenparty.org.uk/candidates/105988       https://static-candidates.democracyclub.org.uk/media/images/551d7140570782f7747687d6.png   copyright-assigned CFlossman   2016-05-05 0 0           PP63   0
8594 8594 7916 Phil Finn     male   local.colchester.2016-05-05 10 joint-party:53-119 Labour and Co-operative Party DIW:E05010843 Wivenhoe                       2016-05-05 0 0           joint-party:53-119   0
8595 8595 7917 Cyril Liddy Cllr.   male   local.colchester.2016-05-05 10 joint-party:53-119 Labour and Co-operative Party DIW:E05010843 Wivenhoe     http://www.colchesterlabour.com/wivenhoe                 2016-05-05 0 0           joint-party:53-119   0
8596 8596 7918 Rosalind Scott Cllr.   female   local.colchester.2016-05-05 10 joint-party:53-119 Labour and Co-operative Party DIW:E05010843 Wivenhoe     http://vote.labour.org.uk/janice-rosalind-scott http://rosalindscott.org.uk/   https://www.linkedin.com/in/rosalindscott/ https://static-candidates.democracyclub.org.uk/media/images/images/7918.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           joint-party:53-119 Jaffa cake 0
8597 8597 8136 Chris Hill     Male 1983-02-18 local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010829 Greenstead     https://www.colchesterindependents.co.uk/candidates https://www.colchesterindependents.co.uk/   https://www.linkedin.com/in/chrismarkhill/ https://static-candidates.democracyclub.org.uk/media/images/images/8136.png   public-domain Minkus Photo from official candidate election literature 2016-05-05 0 0   24270;48696       PP52   0
8598 8598 14097 Susan Lorna Allen         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP63   0
8599 8599 14098 Richard George Issard Brown         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP52   0
8600 8600 14099 Andrew Lawrence Canessa         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP63   0
8601 8601 14100 Adam Daniel Fox         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP53   0
8602 8602 14101 Liam Henry Gallagher         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0   48718.0       PP52   0
8603 8603 14102 Julia Pauline Havis         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP90   0
8604 8604 14103 Janet Mary Knight         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP90   0
8605 8605 14104 Justin Knight         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP90   0
8606 8606 14105 Michael Edward Charles Lilley         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP53   0
8607 8607 14106 Janet Christina Plummer         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP63   0
8608 8608 14107 Alan Herbert Scattergood         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP52   0
8609 8609 14108 Lee Paul Scordis         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010836 Old Heath & The Hythe                       2016-05-05 0 0           PP53   0
8610 8610 15337 Sam Borley         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP63   0
8611 8611 15338 Chris Brown         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP52   0
8612 8612 15339 Michael James Brown         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP52   0
8613 8613 15340 Annabel Rose Fay Glayzer Mrs   Female 1991.0 local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010827 Berechurch             https://static-candidates.democracyclub.org.uk/media/images/images/15340.png   profile-photo annabel_glayzer   2016-05-05 0 0           PP52   0
8614 8614 15341 Dave Harris         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP53   0
8615 8615 15342 Katie Lily Francis Hood         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010827 Berechurch                       2016-05-05 0 0           PP90   0
8616 8616 15343 Jakub Makowski         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010827 Berechurch                       2016-05-05 0 0           PP90   0
8617 8617 15344 Ralph George Morse         local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010827 Berechurch                       2016-05-05 0 0           PP85   0
8618 8618 15345 Chris Pearson         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP53   0
8619 8619 15346 George Edward Penny         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010827 Berechurch                       2016-05-05 0 0           PP90   0
8620 8620 15347 Martyn Keith Warnes         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010827 Berechurch                       2016-05-05 0 0           PP53   0
8621 8621 15358 Nick Barlow         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010828 Castle                       2016-05-05 0 0           PP90   0
8622 8622 15359 Daniel John Ellis         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010828 Castle                       2016-05-05 0 0           PP52   0
8623 8623 15360 Bill Frame         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010828 Castle                       2016-05-05 0 0           PP90   0
8624 8624 15361 Barry Gilheany         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010828 Castle                       2016-05-05 0 0   48690.0       PP53   0
8625 8625 15362 Charles David Ham         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010828 Castle                       2016-05-05 0 0           PP63   0
8626 8626 15363 Amanda Jane Kirke         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010828 Castle                       2016-05-05 0 0           PP63   0
8627 8627 15364 Darius Grant Laws         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010828 Castle                       2016-05-05 0 0           PP52   0
8628 8628 15365 Kate Martin         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010828 Castle                       2016-05-05 0 0           PP52   0
8629 8629 15366 Isobel Claire Merry         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010828 Castle                       2016-05-05 0 0           PP53   0
8630 8630 15382 Owen Leslie Bartholomew     Male   local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010829 Greenstead                       2016-05-05 0 0   24556.0       PP90   0
8631 8631 15383 Tina Jane Bourne         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP53   0
8632 8632 15384 Asa Michael Brotherton         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP63   0
8633 8633 15385 Poppy Eloise Gerrard-Abbott         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP63   0
8634 8634 15386 Paul Gordon Hanslow         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP52   0
8635 8635 15387 Andrew John Higginson         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010829 Greenstead                       2016-05-05 0 0           PP52   0
8636 8636 15388 Christopher John Lee     male   local.colchester.2016-05-05 10 ynmp-party:2 Independent DIW:E05010829 Greenstead     https://www.colchesterindependents.co.uk/candidates https://www.colchesterindependents.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/15388.png   profile-photo Minkus Sourced from campaign page: https://www.colchesterindependents.co.uk/candidates 2016-05-05 0 0           ynmp-party:2   0
8637 8637 15389 James Anthony Middleditch         local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010829 Greenstead                       2016-05-05 0 0           PP85   0
8638 8638 15390 Josef Schumacher         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010829 Greenstead                       2016-05-05 0 0           PP90   0
8639 8639 15391 Julie Ann Young Mrs   Female 1959-07-26 local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010829 Greenstead             https://static-candidates.democracyclub.org.uk/media/images/images/15391.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=1209083954 2016-05-05 0 0   24273.0       PP53   0
8640 8640 15400 John Baker         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010830 Highwoods                       2016-05-05 0 0           PP90   0
8641 8641 15401 Gary David Braddy         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP53   0
8642 8642 15402 James Simon Child         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP52   0
8643 8643 15403 Chris Hayter         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP52   0
8644 8644 15404 Steph Hayward         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP52   0
8645 8645 15405 Alex Knupffer         local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010830 Highwoods                       2016-05-05 0 0           PP85   0
8646 8646 15406 David Charles McCulloch         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP53   0
8647 8647 15407 Bonnie Jayne Murphy         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP63   0
8648 8648 15408 Bev Oxford         local.colchester.2016-05-05 10 ynmp-party:2 Independent DIW:E05010830 Highwoods                       2016-05-05 0 0           ynmp-party:2   0
8649 8649 15409 Gerard Paul Oxford         local.colchester.2016-05-05 10 ynmp-party:2 Independent DIW:E05010830 Highwoods                       2016-05-05 0 0           ynmp-party:2   0
8650 8650 15410 Phil Oxford         local.colchester.2016-05-05 10 ynmp-party:2 Independent DIW:E05010830 Highwoods                       2016-05-05 0 0           ynmp-party:2   0
8651 8651 15411 Leo Palmer         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP63   0
8652 8652 15412 Robbie Spence         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP63   0
8653 8653 15413 Diane Stevens         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010830 Highwoods                       2016-05-05 0 0           PP53   0
8654 8654 15428 Lewis Charles Barber         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP52   0
8655 8655 15429 Sioux Blair-Jordan         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP53   0
8656 8656 15430 Emmanuel Blondel         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP63   0
8657 8657 15431 Rosa Belle Chandler         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP63   0
8658 8658 15432 Stephen George Ford         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP63   0
8659 8659 15433 Gemma Marie Graham         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP90   0
8660 8660 15434 Alison Jane Inman         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP53   0
8661 8661 15435 Brian David Henry Jarvis         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP52   0
8662 8662 15436 Megan Joanne Saliu         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP53   0
8663 8663 15438 Susan Mary Waite         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP90   0
8664 8664 15439 Dennis Willetts         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010831 Lexden & Braiswick                       2016-05-05 0 0           PP52   0
8665 8665 15440 Kevin Paul Bentley         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP52   0
8666 8666 15441 Gillian Mary Collings         local.colchester.2016-05-05 10 party:90 Liberal Democrats DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP90   0
8667 8667 15442 Andrew John Ellis         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP52   0
8668 8668 15443 Jackie Maclean         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP52   0
8669 8669 15444 Clare Teresa Palmer         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP63   0
8670 8670 15445 Matthew James Stemp         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP63   0
8671 8671 15446 Michael Kenneth Wagstaff         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP53   0
8672 8672 15447 John Christopher Wood         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010832 Marks Tey & Layer                       2016-05-05 0 0           PP53   0
8673 8673 15457 Peter Douglas Cameron Banks Mr BSc FMPRS Male   local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010833 Mersea & Pyefleet     https://www.facebook.com/colchestergreenparty/ http://banksyboy.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/15457.png   profile-photo BoyBanksy photo taken by family member 2016-05-05 0 0           PP63   0
8674 8674 15458 Neil Martin Belcher         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP53   0
8675 8675 15459 Lisa Britton         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP63   0
8676 8676 15460 David Roger Broise         local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP85   0
8677 8677 15461 Robert Alec Davidson         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP52   0
8678 8678 15462 David Holmes         local.colchester.2016-05-05 10 party:85 UK Independence Party (UKIP) DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP85   0
8679 8679 15463 John Gilbert Jowers         local.colchester.2016-05-05 10 party:52 Conservative and Unionist Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP52   0
8680 8680 15464 Bartosz Mizgier         local.colchester.2016-05-05 10 party:63 Green Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP63   0
8681 8681 15465 Bry Whittle Mogridge         local.colchester.2016-05-05 10 party:53 Labour Party DIW:E05010833 Mersea & Pyefleet                       2016-05-05 0 0           PP53   0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "candidates" (
"id" INTEGER,
  "name" TEXT,
  "honorific_prefix" REAL,
  "honorific_suffix" REAL,
  "gender" TEXT,
  "birth_date" REAL,
  "election" INTEGER,
  "party_id" TEXT,
  "party_name" TEXT,
  "post_id" TEXT,
  "post_label" TEXT,
  "mapit_url" INTEGER,
  "elected" REAL,
  "email" TEXT,
  "twitter_username" REAL,
  "facebook_page_url" REAL,
  "party_ppc_page_url" REAL,
  "facebook_personal_url" REAL,
  "homepage_url" REAL,
  "wikipedia_url" REAL,
  "linkedin_url" REAL,
  "image_url" REAL,
  "proxy_image_url_template" INTEGER,
  "image_copyright" REAL,
  "image_uploading_user" REAL,
  "image_uploading_user_notes" REAL,
  "twitter_user_id" INTEGER,
  "election_date" TEXT,
  "election_current" INTEGER,
  "party_lists_in_use" INTEGER,
  "party_list_position" INTEGER,
  "old_person_ids" REAL,
  "gss_code" INTEGER,
  "parlparse_id" REAL,
  "theyworkforyou_url" REAL,
  "party_ec_id" TEXT,
  "favourite_biscuits" REAL,
  "cancelled_poll" INTEGER
,
FOREIGN KEY ("election") REFERENCES [election](id))
Powered by Datasette · Query took 9.267ms · Data license: CC-BY-SA · Data source: Democracy Club