home / democracyclub

candidates

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

51 rows where election = 54

✎ 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, party_ppc_page_url, facebook_personal_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
11942 11942 5788 Leonard Amos     male 1957-11-20 local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008993 Fernhill     http://www.labour.org.uk/people/detail/leonard-amos       https://static-candidates.democracyclub.org.uk/media/images/54cd1b0b668e142f73d3b4b4.png   profile-photo     2016-05-05 0 0           PP53   0
11943 11943 6333 Carl Hewitt     male 1965-11-02 local.rushmoor.2016-05-05 54 ynmp-party:2 Independent DIW:E05008999 St Mark's             https://static-candidates.democracyclub.org.uk/media/images/images/6333.png   profile-photo carlosfandango1st   2016-05-05 0 0   18659.0       ynmp-party:2 Digestive 0
11944 11944 7555 Martin Anthony Coule Mr   male 1963.0 local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05008993 Fernhill                       2016-05-05 0 0           PP63   0
11945 11945 10294 Richard James Adair Mr   Male   local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05008995 Manor Park     http://www.portsmouthlibdems.org.uk/richard_adair2       https://static-candidates.democracyclub.org.uk/media/images/images/10294.png   profile-photo petersteadman http://www.libdems.org.uk/richard_adair - libdem candidate page 2016-05-05 0 0           PP90   0
11946 11946 15977 Harry Dagger Nelson         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008993 Fernhill                       2016-05-05 0 0           PP85   0
11947 11947 15978 John Edward Woolley     male   local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008993 Fernhill                       2016-05-05 0 0   18869.0       PP52   0
11948 11948 18591 Derek Roy Cornwell         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP85   0
11949 11949 18592 Clive Grattan         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP53   0
11950 11950 18593 Mara Makunura         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP52   0
11951 11951 18594 Shaun Patrick Joseph Murphy         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05008990 Cherrywood                       2016-05-05 0 0           PP90   0
11952 11952 18601 Susan Mary Carter         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP52   0
11953 11953 18602 Alain Stephen Dekker         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP90   0
11954 11954 18603 Madi Jabbi         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP53   0
11955 11955 18604 Justin Palmer         local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP63   0
11956 11956 18605 Jenny Parsons         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008991 Cove and Southwood                       2016-05-05 0 0           PP85   0
11957 11957 18606 Peter Hayward         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008992 Empress                       2016-05-05 0 0           PP53   0
11958 11958 18607 Marina Munro         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008992 Empress                       2016-05-05 0 0           PP52   0
11959 11959 18608 Colin Nixon         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008992 Empress                       2016-05-05 0 0           PP85   0
11960 11960 18618 Rosie Bell         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008994 Knellwood                       2016-05-05 0 0           PP85   0
11961 11961 18619 Jeffrey Michael De Noronha         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05008994 Knellwood                       2016-05-05 0 0           PP90   0
11962 11962 18620 Amy Hannah Lewry         local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05008994 Knellwood                       2016-05-05 0 0           PP63   0
11963 11963 18621 Paul Graham Taylor         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008994 Knellwood                       2016-05-05 0 0           PP52   0
11964 11964 18622 Bill Tootill         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008994 Knellwood                       2016-05-05 0 0           PP53   0
11965 11965 18630 David Edward Clifford         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008995 Manor Park                       2016-05-05 0 0           PP52   0
11966 11966 18631 David Lee Collett         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008995 Manor Park                       2016-05-05 0 0           PP85   0
11967 11967 18632 Dominique Jamie Alexandra Swaddling         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008995 Manor Park                       2016-05-05 0 0           PP53   0
11968 11968 18640 David Anthony Armitage         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008996 North Town                       2016-05-05 0 0           PP52   0
11969 11969 18641 Keith Dibble         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008996 North Town                       2016-05-05 0 0           PP53   0
11970 11970 18642 Mark Letties         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008996 North Town                       2016-05-05 0 0           PP85   0
11971 11971 18649 Kevin Betsworth         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008997 Rowhill                       2016-05-05 0 0           PP85   0
11972 11972 18650 Julie Martha Considine         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008997 Rowhill                       2016-05-05 0 0           PP53   0
11973 11973 18651 Peta Martine Howell         local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05008997 Rowhill                       2016-05-05 0 0           PP63   0
11974 11974 18652 Maurice Leonard Sheehan         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008997 Rowhill                       2016-05-05 0 0           PP52   0
11975 11975 18653 Sue Gadsby         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008998 St John's                       2016-05-05 0 0           PP53   0
11976 11976 18654 Chris Harding         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008998 St John's                       2016-05-05 0 0           PP85   0
11977 11977 18655 Peter John Moyle         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008998 St John's                       2016-05-05 0 0           PP52   0
11978 11978 18656 Philip Geoffrey Thompson         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05008998 St John's                       2016-05-05 0 0           PP90   0
11979 11979 18657 Simon Amir Austridge         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05008999 St Mark's                       2016-05-05 0 0           PP85   0
11980 11980 18658 Diane Beverley Bedford         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05008999 St Mark's                       2016-05-05 0 0           PP52   0
11981 11981 18660 Abul Koher Chowdhury         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05008999 St Mark's                       2016-05-05 0 0           PP90   0
11982 11982 18661 Gary Simpson         local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05008999 St Mark's                       2016-05-05 0 0           PP63   0
11983 11983 18662 Colin Southon         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05008999 St Mark's                       2016-05-05 0 0   31098.0       PP53   0
11984 11984 18663 Attika Salim Choudhary         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05009000 Wellington                       2016-05-05 0 0           PP52   0
11985 11985 18664 Alex Crawford         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05009000 Wellington                       2016-05-05 0 0           PP53   0
11986 11986 18665 Haydar Koher         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05009000 Wellington                       2016-05-05 0 0           PP90   0
11987 11987 18666 Paula Samantha Marshall         local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05009001 West Heath                       2016-05-05 0 0           PP63   0
11988 11988 18667 Steve Morgan         local.rushmoor.2016-05-05 54 party:52 Conservative and Unionist Party DIW:E05009001 West Heath                       2016-05-05 0 0           PP52   0
11989 11989 18668 Josephine Patricia Murphy         local.rushmoor.2016-05-05 54 party:90 Liberal Democrats DIW:E05009001 West Heath                       2016-05-05 0 0           PP90   0
11990 11990 18669 Trevor Simpson         local.rushmoor.2016-05-05 54 party:53 Labour Party DIW:E05009001 West Heath                       2016-05-05 0 0           PP53   0
11991 11991 18670 Mark Staplehurst         local.rushmoor.2016-05-05 54 party:85 UK Independence Party (UKIP) DIW:E05009001 West Heath                       2016-05-05 0 0           PP85   0
11992 11992 46197 Donna Wallace Mrs   female   local.rushmoor.2016-05-05 54 party:63 Green Party DIW:E05008992 Empress     https://my.greenparty.org.uk/candidates/105784       https://static-candidates.democracyclub.org.uk/media/images/images/34816.png   profile-photo kdcm87 Photo from local election campaign https://blackwater.greenparty.org.uk/candidates/candidates-rushmoor.html 2016-05-05 0 0   34816.0       PP63   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 12.208ms · Data license: CC-BY-SA · Data source: Democracy Club