home / democracyclub

candidates

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

56 rows where election = 56

✎ 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, facebook_page_url, party_ppc_page_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
12131 12131 3248 Nigel Knowles     male 1946-12-05 local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010508 Franche & Habberley North   1.0 http://www.labour.org.uk/people/detail/nigel-knowles       https://static-candidates.democracyclub.org.uk/media/images/images/3248.png   other Aisha Candidates agent emailed it to us (NUT). 2016-05-05 0 0   32019.0       PP53   0
12132 12132 10014 John Cedric Aston         local.wyre-forest.2016-05-05 56 ynmp-party:2 Independent DIW:E05010502 Aggborough & Spennells   1.0                   2016-05-05 0 0   13523.0       ynmp-party:2   0
12133 12133 10015 Anna Coleman     female   local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010502 Aggborough & Spennells     https://www.wyreforestconservatives.com/people/anna-coleman       https://static-candidates.democracyclub.org.uk/media/images/images/10015.png   profile-photo sjorford https://www.wyreforestconservatives.com/people/anna-coleman 2016-05-05 0 0           PP52   0
12134 12134 10016 Doug Hine         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0           PP63   0
12135 12135 10017 Philip Howard Jeanes         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0   13524.0       PP85   0
12136 12136 10018 Keith Robertson         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0   14443.0       PP44   0
12137 12137 10019 Brian Alan Rushbrook         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010502 Aggborough & Spennells                       2016-05-05 0 0   13525.0       PP53   0
12138 12138 10059 Berenice Susan Dawes         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0           PP85   0
12139 12139 10060 Lin Henderson         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0           PP52   0
12140 12140 10061 Vi Higgs         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010503 Areley Kings & Riverside   1.0                   2016-05-05 0 0           PP53   0
12141 12141 10062 John William Roland Thomas         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0           PP44   0
12142 12142 13052 Gilda Maria Davis         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010510 Mitton                       2016-05-05 0 0           PP63   0
12143 12143 13053 Jill Hawes         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010510 Mitton                       2016-05-05 0 0           PP53   0
12144 12144 13054 John Holden         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010510 Mitton                       2016-05-05 0 0           PP85   0
12145 12145 13055 Nicky Martin         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010510 Mitton   1.0                   2016-05-05 0 0           PP44   0
12146 12146 13056 Tony Muir         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010510 Mitton                       2016-05-05 0 0           PP52   0
12147 12147 14125 Linda Anne Candlin         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP44   0
12148 12148 14128 David John Field         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP85   0
12149 12149 14816 John Davis         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0           PP63   0
12150 12150 14817 Paul Bernard Harrison         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0           PP52   0
12151 12151 14818 Bill Hopkins         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0   32018.0       PP85   0
12152 12152 14819 Caroline Marie Shellie         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010508 Franche & Habberley North                       2016-05-05 0 0           PP44   0
12153 12153 15073 Meriel Rose Acton         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP44   0
12154 12154 15074 Brett Caulfield     Male   local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010511 Offmore & Comberton     https://my.greenparty.org.uk/candidates/106312 https://wyreforest.greenparty.org.uk/local-elections.html     https://static-candidates.democracyclub.org.uk/media/images/images/15074.png   profile-photo yanbad13257 http://www.redditchadvertiser.co.uk/news/regional/15267834.Brett_Caulfield_to_contest_Wyre_Forest_seat_for_the_Green_Party_in_General_Election/ 2016-05-05 0 0           PP63   0
12155 12155 15075 Mike Cheeseman     Male   local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP52   0
12156 12156 15076 Shazu Miah     male   local.wyre-forest.2016-05-05 56 party:90 Liberal Democrats DIW:E05010511 Offmore & Comberton   1.0 http://www.libdems.org.uk/shazu-miah       https://static-candidates.democracyclub.org.uk/media/images/images/15076.png   profile-photo yanbad13257 http://www.wyreforest.gov.uk/council/councillors/mem109.htm 2016-05-05 0 0           PP90   0
12157 12157 15077 Nick Savage         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP53   0
12158 12158 15078 Martin John Stooke         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010511 Offmore & Comberton                       2016-05-05 0 0           PP85   0
12159 12159 19066 Rachel Louise Akathiotis         local.wyre-forest.2016-05-05 56 party:90 Liberal Democrats DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP90   0
12160 12160 19067 Dave Finch         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP63   0
12161 12161 19068 William Paul Stephen Mack         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP52   0
12162 12162 19069 Steven John Walker         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010506 Broadwaters   1.0                   2016-05-05 0 0           PP53   0
12163 12163 19070 Paul Wooldridge         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP85   0
12164 12164 19071 Peter Winston Montgomery Young         local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010506 Broadwaters                       2016-05-05 0 0           PP44   0
12165 12165 19194 Dan Collins         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010513 Wyre Forest Rural                       2016-05-05 0 0           PP85   0
12166 12166 19196 Stephen John Williams         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010513 Wyre Forest Rural   1.0                   2016-05-05 0 0           PP52   0
12167 12167 19198 Maurice Andrew Alton         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010504 Bewdley & Rock                       2016-05-05 0 0           PP85   0
12168 12168 19199 Calne Edginton-White     female   local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010504 Bewdley & Rock             https://static-candidates.democracyclub.org.uk/media/images/images/19199.png   profile-photo sjorford http://www.ichcbewdley.co.uk/index.php?page=Calne-Edginton-White 2016-05-05 0 0           PP44   0
12169 12169 19200 Phil Oliver         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010504 Bewdley & Rock                       2016-05-05 0 0           PP63   0
12170 12170 19201 Rod Stanczyszyn         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010504 Bewdley & Rock                       2016-05-05 0 0           PP53   0
12171 12171 19202 Rod Wilson         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010504 Bewdley & Rock   1.0                   2016-05-05 0 0           PP52   0
12172 12172 19203 Adrian Stanley Beavis         local.wyre-forest.2016-05-05 56 party:90 Liberal Democrats DIW:E05010505 Blakebrook & Habberley South                       2016-05-05 0 0           PP90   0
12173 12173 19204 George Connolly mr   male 1997-05-15 local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010505 Blakebrook & Habberley South             https://static-candidates.democracyclub.org.uk/media/images/images/19204.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0           PP85   0
12174 12174 19205 Bernadette Connor         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010505 Blakebrook & Habberley South                       2016-05-05 0 0           PP53   0
12175 12175 19206 Vicky Lea         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010505 Blakebrook & Habberley South                       2016-05-05 0 0           PP63   0
12176 12176 19207 Juliet Denise Smith         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010505 Blakebrook & Habberley South   1.0                   2016-05-05 0 0           PP52   0
12177 12177 19208 Leia Rachael Devon Beavis         local.wyre-forest.2016-05-05 56 party:90 Liberal Democrats DIW:E05010507 Foley Park & Hoobrook                       2016-05-05 0 0           PP90   0
12178 12178 19209 John Byng     male   local.wyre-forest.2016-05-05 56 party:44 Independent Kidderminster Hospital and Health Concern DIW:E05010507 Foley Park & Hoobrook             https://static-candidates.democracyclub.org.uk/media/images/images/19209.png   profile-photo sjorford http://www.ichcbewdley.co.uk/index.php?page=john-byng 2016-05-05 0 0           PP44   0
12179 12179 19210 Gerald Crumpton         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010507 Foley Park & Hoobrook                       2016-05-05 0 0           PP53   0
12180 12180 19211 Nicky Gale         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010507 Foley Park & Hoobrook   1.0                   2016-05-05 0 0           PP52   0
12181 12181 19212 Michael James William Wrench         local.wyre-forest.2016-05-05 56 party:85 UK Independence Party (UKIP) DIW:E05010507 Foley Park & Hoobrook                       2016-05-05 0 0           PP85   0
12182 12182 19213 Daniel John Crampton         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP53   0
12183 12183 19214 Martin Layton         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010512 Wribbenhall & Arley                       2016-05-05 0 0           PP63   0
12184 12184 19215 Rebecca Vale         local.wyre-forest.2016-05-05 56 party:52 Conservative and Unionist Party DIW:E05010512 Wribbenhall & Arley   1.0                   2016-05-05 0 0           PP52   0
12185 12185 32003 Nicholas Dean Atkinson         local.wyre-forest.2016-05-05 56 party:63 Green Party DIW:E05010503 Areley Kings & Riverside                       2016-05-05 0 0   10058.0       PP63   0
12186 12186 32024 Dave Jones         local.wyre-forest.2016-05-05 56 party:53 Labour Party DIW:E05010513 Wyre Forest Rural                       2016-05-05 0 0   19195.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 8.25ms · Data license: CC-BY-SA · Data source: Democracy Club