home / democracyclub

candidates

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

51 rows where election = 36

✎ 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, homepage_url, image_url, 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
10169 10169 4259 Gavin Callaghan     male   local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004030 Pitsea North West   1.0 http://www.labour.org.uk/people/detail/gavin-callaghan http://www.gavincallaghan.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/4259.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   9653.0       PP53   0
10170 10170 9605 Susan Patricia McCaffery         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004021 Billericay East                       2016-05-05 0 0           PP85   0
10171 10171 9606 Patricia Reid         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004021 Billericay East                       2016-05-05 0 0           PP53   0
10172 10172 9607 Stuart Bryan Sullivan         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004021 Billericay East   1.0                   2016-05-05 0 0           PP52   0
10173 10173 9608 Jack Anthony Ferguson         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004022 Billericay West                       2016-05-05 0 0           PP53   0
10174 10174 9609 Cliff Hammans         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004022 Billericay West                       2016-05-05 0 0           PP85   0
10175 10175 9610 Philip Charles Turner         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004022 Billericay West   1.0                   2016-05-05 0 0           PP52   0
10176 10176 9611 David Thomas Kirkman     male   local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004023 Burstead                       2016-05-05 0 0           PP53   0
10177 10177 9612 Richard Andrew Moore         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004023 Burstead   1.0                   2016-05-05 0 0           PP52   0
10178 10178 9613 Kevin John Piper         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004023 Burstead                       2016-05-05 0 0           PP85   0
10179 10179 9614 Stuart Johns Allen         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004024 Crouch   1.0                   2016-05-05 0 0           PP52   0
10180 10180 9615 Sally Jane Muylders         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004024 Crouch                       2016-05-05 0 0           PP53   0
10181 10181 9616 Richard Frederick Petchey         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004024 Crouch                       2016-05-05 0 0           PP85   0
10182 10182 9617 Adele Jane Brown         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004025 Fryerns   1.0                   2016-05-05 0 0           PP53   0
10183 10183 9618 Tony Mark Low         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004025 Fryerns                       2016-05-05 0 0           PP52   0
10184 10184 9619 Rhyan Lee Waine Mr   Male 1997-08-01 local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004025 Fryerns     http://www.basildonboroughukip.org/2016/04/15/may-2016-election-special-ukip-candidate-for-fryerns-rhyan-waine/       https://static-candidates.democracyclub.org.uk/media/images/images/9619.png   profile-photo RhyanW http://www.basildonboroughukip.org/2016/04/15/may-2016-election-special-ukip-candidate-for-fryerns-rhyan-waine/ 2016-05-05 0 0           PP85   0
10185 10185 9632 Lewis David Blaney     male   local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP53   0
10186 10186 9633 Hazel Patricia Green         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004026 Laindon Park   1.0                   2016-05-05 0 0           PP85   0
10187 10187 9634 Gary David Maylin     male   local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP52   0
10188 10188 9635 Philip William Rackley         local.basildon.2016-05-05 36 party:63 Green Party DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP63   0
10189 10189 9636 Alan Henry Richards         local.basildon.2016-05-05 36 party:90 Liberal Democrats DIW:E05004026 Laindon Park                       2016-05-05 0 0           PP90   0
10190 10190 9637 John Drummond         local.basildon.2016-05-05 36 party:63 Green Party DIW:E05004027 Langdon Hills                       2016-05-05 0 0           PP63   0
10191 10191 9638 Philip Edward Gibbs Dr   male 1960.0 local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004027 Langdon Hills       http://philipgibbslangdonhills.blogspot.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/9638.png   profile-photo philip3   2016-05-05 0 0           PP85   0
10192 10192 9639 Liz Grant         local.basildon.2016-05-05 36 party:90 Liberal Democrats DIW:E05004027 Langdon Hills                       2016-05-05 0 0   26576.0       PP90   0
10193 10193 9640 Alex James Harrison         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004027 Langdon Hills                       2016-05-05 0 0           PP53   0
10194 10194 9641 Stephen Hillier         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004027 Langdon Hills   1.0                   2016-05-05 0 0           PP52   0
10195 10195 9642 Andrew Forrest Gordon Mr   male 1992.0 local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004028 Lee Chapel North   1.0   https://andrew-gordon.net/   https://www.linkedin.com/in/andrew-gordon-24580855/ https://static-candidates.democracyclub.org.uk/media/images/images/9642.png   profile-photo agordon92   2016-05-05 0 0           PP53 chocolate malted milk 0
10196 10196 9643 Arthur John James         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004028 Lee Chapel North                       2016-05-05 0 0           PP85   0
10197 10197 9644 Stephen Graham Yates         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004028 Lee Chapel North                       2016-05-05 0 0           PP52   0
10198 10198 9645 Clarence Machipisa Zwengunde         local.basildon.2016-05-05 36 ynmp-party:2 Independent DIW:E05004028 Lee Chapel North                       2016-05-05 0 0           ynmp-party:2   0
10199 10199 9647 Derrick William John Fellowes         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004029 Nethermayne   1.0                   2016-05-05 0 0           PP85   0
10200 10200 9648 Dean Robert Hall         local.basildon.2016-05-05 36 party:63 Green Party DIW:E05004029 Nethermayne                       2016-05-05 0 0           PP63   0
10201 10201 9649 Graham Peter Herbing         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004029 Nethermayne                       2016-05-05 0 0           PP53   0
10202 10202 9650 Pauline Patricia Kettle         local.basildon.2016-05-05 36 ynmp-party:2 Independent DIW:E05004029 Nethermayne                       2016-05-05 0 0           ynmp-party:2   0
10203 10203 9651 Ben Williams         local.basildon.2016-05-05 36 party:90 Liberal Democrats DIW:E05004029 Nethermayne                       2016-05-05 0 0           PP90   0
10204 10204 9652 Jacqueline Ann Blake         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004030 Pitsea North West                       2016-05-05 0 0           PP52   0
10205 10205 9654 Michelle Yvonne Regan         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004030 Pitsea North West                       2016-05-05 0 0           PP85   0
10206 10206 9655 Kayode Adeniran     male   local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004031 Pitsea South East             https://static-candidates.democracyclub.org.uk/media/images/images/9655.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=720002710829932544 2016-05-05 0 0   48955.0       PP53   0
10207 10207 9656 Jose Carrion         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004031 Pitsea South East   1.0                   2016-05-05 0 0           PP85   0
10208 10208 9657 Ian David Dwyer     male   local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004031 Pitsea South East                       2016-05-05 0 0           PP52   0
10209 10209 9668 Leslie Ronald Allport         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004032 St Martin's                       2016-05-05 0 0           PP85   0
10210 10210 9669 David Edmund Burton-Sampson     male   local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004032 St Martin's   1.0                   2016-05-05 0 0           PP53   0
10211 10211 9670 Jeff Henry         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004032 St Martin's                       2016-05-05 0 0           PP52   0
10212 10212 9674 Kayte Block Cllr   female 1988.0 local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004033 Vange   1.0   http://kayte4bb.co.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/9674.png   profile-photo yanbad13257   2016-05-05 0 0           PP53   0
10213 10213 9675 Terry Latchford         local.basildon.2016-05-05 36 party:85 UK Independence Party (UKIP) DIW:E05004033 Vange                       2016-05-05 0 0           PP85   0
10214 10214 9676 Tamara Danielle Rainford         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004033 Vange                       2016-05-05 0 0           PP52   0
10215 10215 9677 Eunice Christine Brockman         local.basildon.2016-05-05 36 party:4005 Wickford Independents DIW:E05004035 Wickford North                       2016-05-05 0 0           PP4005   0
10216 10216 9678 Dolores Maria Baila McGurran         local.basildon.2016-05-05 36 party:53 Labour Party DIW:E05004035 Wickford North                       2016-05-05 0 0           PP53   0
10217 10217 9679 Carole Morris         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004035 Wickford North   1.0                   2016-05-05 0 0           PP52   0
10218 10218 9680 David Radley     male   local.basildon.2016-05-05 36 party:90 Liberal Democrats DIW:E05004035 Wickford North                       2016-05-05 0 0           PP90   0
10219 10219 36676 Christopher Allen         local.basildon.2016-05-05 36 party:52 Conservative and Unionist Party DIW:E05004029 Nethermayne     http://basildonconservatives.com/candidates/fryerns/                 2016-05-05 0 0   9646.0       PP52   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 7.225ms · Data license: CC-BY-SA · Data source: Democracy Club