home / democracyclub

candidates

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

42 rows where election = 51

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: gender, birth_date, party_id, party_name, post_id, post_label, email, twitter_username, party_ppc_page_url, facebook_personal_url, image_url, image_copyright, twitter_user_id, old_person_ids, party_ec_id, favourite_biscuits

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
11704 11704 1268 Tony Wright     male 1954-08-12 local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005792 Gorleston     http://www.gylabour.org.uk/tony_wright http://www.gylabour.org.uk https://en.wikipedia.org/wiki/Tony_Wright_(Great_Yarmouth_MP)   https://static-candidates.democracyclub.org.uk/media/images/images/1268.png   profile-photo john18   2016-05-05 0 0           PP53   0
11705 11705 4814 Alan Christie Grey     male   local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005784 Bradwell North   1.0 http://ukip-gy.co.uk/Alan%20Grey.pdf       https://static-candidates.democracyclub.org.uk/media/images/54e7b2d002f716934fefdb7f.png         2016-05-05 0 0   11739;32668       PP85   0
11706 11706 8192 Ken Petersen     male 1955.0 local.great-yarmouth.2016-05-05 51 party:63 Green Party DIW:E05005790 East Flegg             https://static-candidates.democracyclub.org.uk/media/images/images/8192.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP63   0
11707 11707 10228 Joshua Michael Turton     Male 1994-03-20 local.great-yarmouth.2016-05-05 51 party:63 Green Party DIW:E05005794 Magdalen                       2016-05-05 0 0           PP63   0
11708 11708 11737 James Louis Borg     male   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005784 Bradwell North     http://www.gylabour.org.uk/james_borg http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11737.png   profile-photo john18   2016-05-05 0 0           PP53 Chocolate Chip Cookie 0
11709 11709 11738 David Thomas Drewitt         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005784 Bradwell North                       2016-05-05 0 0           PP52   0
11710 11710 11745 Sue Hacon         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005785 Bradwell South and Hopton   1.0                   2016-05-05 0 0           PP85   0
11711 11711 11746 Julia Ann Miller         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005785 Bradwell South and Hopton                       2016-05-05 0 0           PP52   0
11712 11712 11747 Hilary Jeanette Wainwright     female   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005785 Bradwell South and Hopton       http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11747.png   copyright-assigned john18   2016-05-05 0 0           PP53   0
11713 11713 11753 Stephen Alfred Ames         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005789 Claydon                       2016-05-05 0 0           PP52   0
11714 11714 11754 Carol Ann Borg     female   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005789 Claydon   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11754.png   copyright-assigned john18   2016-05-05 0 0           PP53   0
11715 11715 11755 Philip Malcolm Grimmer         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005789 Claydon                       2016-05-05 0 0           PP85   0
11716 11716 11762 Peter Fitzgerald         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005792 Gorleston                       2016-05-05 0 0           PP85   0
11717 11717 11763 Emma Claire Flaxman-Taylor         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005792 Gorleston   1.0                   2016-05-05 0 0           PP52   0
11718 11718 11768 Margaret Mary Greenacre         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005798 Southtown and Cobholm                       2016-05-05 0 0           PP52   0
11719 11719 11769 Gary Paige         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005798 Southtown and Cobholm                       2016-05-05 0 0           PP85   0
11720 11720 11770 Paula Waters-Bunn     female   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005798 Southtown and Cobholm   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11770.png   profile-photo john18   2016-05-05 0 0           PP53   0
11721 11721 11771 Patricia Elizabeth Page         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005794 Magdalen                       2016-05-05 0 0           PP52   0
11722 11722 11772 Sylvia Pratt     female   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005794 Magdalen   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11772.png   profile-photo john18   2016-05-05 0 0           PP53   0
11723 11723 11773 Michael Thomas Jeal     male   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005795 Nelson   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11773.png   profile-photo john18   2016-05-05 0 0           PP53   0
11724 11724 11774 Aurelio Spinola         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005795 Nelson                       2016-05-05 0 0           PP85   0
11725 11725 11775 Anthony Chester Taylor         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005795 Nelson                       2016-05-05 0 0           PP52   0
11726 11726 11776 Tony Harris         local.great-yarmouth.2016-05-05 51 party:90 Liberal Democrats DIW:E05005788 Central And Northgate                       2016-05-05 0 0           PP90   0
11727 11727 11777 Lee Paul Sutton     male   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005788 Central And Northgate       http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11777.png   profile-photo john18   2016-05-05 0 0           PP53   0
11728 11728 11778 John Cyril Taylor         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005788 Central And Northgate                       2016-05-05 0 0           PP52   0
11729 11729 11779 Chris Walch         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005788 Central And Northgate   1.0                   2016-05-05 0 0           PP85   0
11730 11730 11780 Cliff Cotgrove         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005796 Ormesby                       2016-05-05 0 0           PP85   0
11731 11731 11781 Charles Joseph Reynolds         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005796 Ormesby   1.0                   2016-05-05 0 0           PP52   0
11732 11732 11782 John Simmons     male 1983.0 local.great-yarmouth.2016-05-05 51 joint-party:53-119 Labour and Co-operative Party DIW:E05005796 Ormesby     http://www.gylabour.org.uk/john_simmons http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11782.png   profile-photo john18   2016-05-05 0 0           joint-party:53-119 Bourbon 0
11733 11733 11783 Tracey Ann Darnell         local.great-yarmouth.2016-05-05 51 party:63 Green Party DIW:E05005797 St Andrews                       2016-05-05 0 0           PP63   0
11734 11734 11784 Marlene Ellen Fairhead     female   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005797 St Andrews   1.0   http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11784.png   profile-photo john18   2016-05-05 0 0           PP53   0
11735 11735 11785 Peter Phipps         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005797 St Andrews                       2016-05-05 0 0           PP85   0
11736 11736 11786 George William Rogers         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005797 St Andrews                       2016-05-05 0 0           PP52   0
11737 11737 11787 Graham Paul Carpenter         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005800 Yarmouth North                       2016-05-05 0 0           PP52   0
11738 11738 11788 Nicholas Mark Dyer         local.great-yarmouth.2016-05-05 51 party:90 Liberal Democrats DIW:E05005800 Yarmouth North                       2016-05-05 0 0           PP90   0
11739 11739 11789 Paul Charles Hammond         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005800 Yarmouth North   1.0                   2016-05-05 0 0           PP85   0
11740 11740 11790 Christina Horne     female 1957.0 local.great-yarmouth.2016-05-05 51 joint-party:53-119 Labour and Co-operative Party DIW:E05005800 Yarmouth North       http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11790.png   copyright-assigned john18   2016-05-05 0 0           joint-party:53-119   0
11741 11741 11791 James William Bensly         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005790 East Flegg   1.0                   2016-05-05 0 0           PP52   0
11742 11742 11792 Gary William Boyd         local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005790 East Flegg                       2016-05-05 0 0           PP53   0
11743 11743 11793 Carly Anne Webb         local.great-yarmouth.2016-05-05 51 party:85 UK Independence Party (UKIP) DIW:E05005790 East Flegg                       2016-05-05 0 0           PP85   0
11744 11744 11794 Barry George Coleman         local.great-yarmouth.2016-05-05 51 party:52 Conservative and Unionist Party DIW:E05005799 West Flegg   1.0                   2016-05-05 0 0           PP52   0
11745 11745 11795 Christina Stewart     female   local.great-yarmouth.2016-05-05 51 party:53 Labour Party DIW:E05005799 West Flegg     http://www.gylabour.org.uk/christina_stewart http://www.gylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/35840.png   profile-photo john18   2016-05-05 0 0   35840.0       PP53   0

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 6.776ms · Data license: CC-BY-SA · Data source: Democracy Club