home / democracyclub

candidates

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

48 rows where election = 91

✎ View and edit SQL

This data as JSON, CSV (advanced)

Suggested facets: honorific_prefix, gender, party_id, party_name, post_id, post_label, email, twitter_username, party_ppc_page_url, facebook_personal_url, homepage_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
14954 14954 706 Arshad Khan     male   local.crawley.2016-05-05 91 party:157 Justice Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP157   0
14955 14955 5125 Christopher Brown     male   local.crawley.2016-05-05 91 party:85 UK Independence Party (UKIP) DIW:E05007631 Bewbush       http://www.chrisbrownukip.org/     https://static-candidates.democracyclub.org.uk/media/images/55268e5859bbc5c063445b83.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   11877;31824       PP85   0
14956 14956 11875 Marion Ayling         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP53   0
14957 14957 11876 Andrew Belben         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP52   0
14958 14958 11878 Martin Kail         local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007631 Bewbush                       2016-05-05 0 0           PP63   0
14959 14959 11879 Sarah Smith         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007631 Bewbush                       2016-05-05 0 0   31825.0       PP90   0
14960 14960 11880 Irshad Jalaldeen         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007632 Broadfield North                       2016-05-05 0 0           PP52   0
14961 14961 11881 Brian J Quinn         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007632 Broadfield North                       2016-05-05 0 0           PP53   0
14962 14962 11882 Charlotte Franco         local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007633 Broadfield South                       2016-05-05 0 0           PP63   0
14963 14963 11883 Charles Petts         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007633 Broadfield South                       2016-05-05 0 0           PP52   0
14964 14964 11884 Tahira Rana         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007633 Broadfield South                       2016-05-05 0 0           PP53   0
14965 14965 11885 Chris Mullins         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007635 Gossops Green ward                       2016-05-05 0 0           PP53   0
14966 14966 11886 Philip Norville         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007635 Gossops Green ward                       2016-05-05 0 0           PP52   0
14967 14967 11887 Neil James Setford-Thompson         local.crawley.2016-05-05 91 party:85 UK Independence Party (UKIP) DIW:E05007635 Gossops Green ward                       2016-05-05 0 0           PP85   0
14968 14968 11888 George Paul Bird         local.crawley.2016-05-05 91 party:85 UK Independence Party (UKIP) DIW:E05007636 Ifield                       2016-05-05 0 0           PP85   0
14969 14969 11889 Andrew Jagger         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007636 Ifield                       2016-05-05 0 0           PP52   0
14970 14970 11890 Richard Martin Kail Mr   Male 1995-10-05 local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007636 Ifield     https://www.facebook.com/richardkailgreenparty/ https://www.midsussex.greenparty.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11890.png   public-domain RichardKail It's my own photograph. 2016-05-05 0 0   34222.0       PP63   0
14971 14971 11891 Mike Sargent         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007636 Ifield                       2016-05-05 0 0           PP90   0
14972 14972 11892 Peter Smith         local.crawley.2016-05-05 91 joint-party:53-119 Labour and Co-operative Party DIW:E05007636 Ifield     http://labourclp7.nationbuilder.com/peter_smith_2016_candidate https://www.crawleylabour.org.uk     https://static-candidates.democracyclub.org.uk/media/images/images/11892.png   public-domain peter11   2016-05-05 0 0           joint-party:53-119   0
14973 14973 11893 Rudolf Otto Hugh Affolter         local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007637 Langley Green                       2016-05-05 0 0           PP63   0
14974 14974 11894 Kevin Hall         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007637 Langley Green                       2016-05-05 0 0           PP52   0
14975 14975 11895 Sharon Kennett         local.crawley.2016-05-05 91 party:85 UK Independence Party (UKIP) DIW:E05007637 Langley Green                       2016-05-05 0 0   31848.0       PP85   0
14976 14976 11896 Marko Scepanovic     Male   local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007637 Langley Green     http://www.libdems.org.uk/marko_scepanovic     https://www.linkedin.com/in/marko-scepanovic-86804075/ https://static-candidates.democracyclub.org.uk/media/images/images/11896.png   profile-photo mark From the Crawley Liberal Democrats website: https://crawley-libdems.org.uk/en/page/marko-scepanovic 2016-05-05 0 0           PP90   0
14977 14977 11897 Brenda Ann Smith         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007637 Langley Green                       2016-05-05 0 0           PP53   0
14978 14978 11898 Danielle Kail         local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007638 Maidenbower                       2016-05-05 0 0           PP63   0
14979 14979 11899 Duncan Peck         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007638 Maidenbower                       2016-05-05 0 0           PP52   0
14980 14980 11900 Akram Rana         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007638 Maidenbower                       2016-05-05 0 0           PP53   0
14981 14981 11901 Tina Belben         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007640 Pound Hill North                       2016-05-05 0 0           PP52   0
14982 14982 11902 Tony Patel         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007640 Pound Hill North                       2016-05-05 0 0           PP53   0
14983 14983 11903 Valerie Spooner         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007640 Pound Hill North                       2016-05-05 0 0           PP90   0
14984 14984 11904 Daniel Elliott         local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007641 Pound Hill South and Worth                       2016-05-05 0 0           PP63   0
14985 14985 11905 Colin Flack     male   local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007641 Pound Hill South and Worth     https://labourclp7.nationbuilder.com/colin_flack_2018_candidate       https://static-candidates.democracyclub.org.uk/media/images/images/11905.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=715574547949469696 2016-05-05 0 0           PP53   0
14986 14986 11906 Bob Lanzer Mr   male   local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007641 Pound Hill South and Worth             https://static-candidates.democracyclub.org.uk/media/images/images/11906.png   other gregorywilliams https://www.westsussex.gov.uk/find-my-nearest/councillor/details/api/type/councillor/view/mr-bob-lanzer 2016-05-05 0 0           PP52   0
14987 14987 11907 Alison Berridge         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007642 Southgate                       2016-05-05 0 0           PP52   0
14988 14988 11908 Kevin Osborne         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007642 Southgate                       2016-05-05 0 0           PP90   0
14989 14989 11909 Mike Pickett         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007642 Southgate                       2016-05-05 0 0           PP53   0
14990 14990 11910 Brenda Burgess         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007643 Three Bridges ward                       2016-05-05 0 0           PP52   0
14991 14991 11911 Daryl Lynn Duncan-English         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007643 Three Bridges ward                       2016-05-05 0 0           PP53   0
14992 14992 11912 Colin Frank Young         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007643 Three Bridges ward                       2016-05-05 0 0           PP90   0
14993 14993 11913 Allan Peter Griffiths         local.crawley.2016-05-05 91 party:85 UK Independence Party (UKIP) DIW:E05007644 Tilgate ward                       2016-05-05 0 0   25456.0       PP85   0
14994 14994 11914 Claire Griffiths Mrs       local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007644 Tilgate ward       https://www.conservatives.com/               2016-05-05 0 0           PP52   0
14995 14995 11915 Derek Andrew Hardman         local.crawley.2016-05-05 91 party:63 Green Party DIW:E05007644 Tilgate ward                       2016-05-05 0 0           PP63   0
14996 14996 11916 James Harper         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007644 Tilgate ward                       2016-05-05 0 0           PP90   0
14997 14997 11917 Carlos Portal Castro         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007644 Tilgate ward                       2016-05-05 0 0           PP53   0
14998 14998 11918 David Anderson         local.crawley.2016-05-05 91 party:90 Liberal Democrats DIW:E05007645 West Green                       2016-05-05 0 0           PP90   0
14999 14999 11919 Ian Anguige         local.crawley.2016-05-05 91 party:52 Conservative and Unionist Party DIW:E05007645 West Green                       2016-05-05 0 0           PP52   0
15000 15000 11920 Rory Stuart Fiveash         local.crawley.2016-05-05 91 party:53 Labour Party DIW:E05007645 West Green                       2016-05-05 0 0           PP53   0
15001 15001 11921 Carole Lauderdale         local.crawley.2016-05-05 91 party:85 UK Independence Party (UKIP) DIW:E05007645 West Green                       2016-05-05 0 0           PP85   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 8.052ms · Data license: CC-BY-SA · Data source: Democracy Club