Data license: CC-BY-SA · Data source: Democracy Club
This data as JSON, CSV (advanced)
Suggested facets: party_id, party_name, post_id, post_label, image_url, image_copyright, image_uploading_user, image_uploading_user_notes, 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 | twitter_username | facebook_page_url | party_ppc_page_url | facebook_personal_url | homepage_url | wikipedia_url | linkedin_url | image_url | proxy_image_url_template | image_copyright | image_uploading_user | image_uploading_user_notes | twitter_user_id | 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 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8936 | 8936 | 19502 | Nicola Benjamin | local.hackney.2016-05-05 15 | party:52 | Conservative and Unionist Party | LBW:E05009373 | Hackney Downs | 2016-05-05 | 0 | 0 | PP52 | 0 | ||||||||||||||||||||||||||
| 8937 | 8937 | 19503 | Alastair Binnie-Lubbock | male | 1985.0 | local.hackney.2016-05-05 15 | party:63 | Green Party | LBW:E05009373 | Hackney Downs | alastair.binnie@greenparty.org.uk | alastairis | https://www.facebook.com/hackneygreenparty/ | https://static-candidates.democracyclub.org.uk/media/images/images/19503.png | profile-photo | Auto imported from Twitter | 68492964 | 2016-05-05 | 0 | 0 | PP63 | Bourbon | 0 | ||||||||||||||||
| 8938 | 8938 | 19504 | Sem Moema | local.hackney.2016-05-05 15 | party:53 | Labour Party | LBW:E05009373 | Hackney Downs | https://static-candidates.democracyclub.org.uk/media/images/images/19504.png | other | E9to5 | http://mginternet.hackney.gov.uk/UserData/7/2/4/Info00004427/bigpic.jpg | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||
| 8939 | 8939 | 19505 | Mohammed Sadiq | local.hackney.2016-05-05 15 | party:90 | Liberal Democrats | LBW:E05009373 | Hackney Downs | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 8940 | 8940 | 19506 | Mick Cotter | local.hackney.2016-05-05 15 | party:804 | Trade Unionist and Socialist Coalition | LBW:E05009385 | Stoke Newington | 2016-05-05 | 0 | 0 | PP804 | 0 | ||||||||||||||||||||||||||
| 8941 | 8941 | 19507 | Victor De Almeida | local.hackney.2016-05-05 15 | party:90 | Liberal Democrats | LBW:E05009385 | Stoke Newington | 2016-05-05 | 0 | 0 | PP90 | 0 | ||||||||||||||||||||||||||
| 8942 | 8942 | 19508 | Patrick Moule | local.hackney.2016-05-05 15 | party:53 | Labour Party | LBW:E05009385 | Stoke Newington | 2016-05-05 | 0 | 0 | PP53 | 0 | ||||||||||||||||||||||||||
| 8943 | 8943 | 19509 | Halita Obineche | local.hackney.2016-05-05 15 | party:63 | Green Party | LBW:E05009385 | Stoke Newington | 2016-05-05 | 0 | 0 | PP63 | 0 | ||||||||||||||||||||||||||
| 8944 | 8944 | 19510 | Christopher Darlington Sills | male | local.hackney.2016-05-05 15 | party:52 | Conservative and Unionist Party | LBW:E05009385 | Stoke Newington | https://www.hackneyconservatives.org.uk/people/chris-sills | https://static-candidates.democracyclub.org.uk/media/images/images/19510.png | profile-photo | fbrc | https://www.hackneyconservatives.org.uk/people/chris-sills | 2016-05-05 | 0 | 0 | 49147.0 | PP52 | 0 |
JSON shape: default, array, newline-delimited
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))