home / democracyclub

candidates

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

103 rows where election = 74

✎ 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, facebook_personal_url, homepage_url, linkedin_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
13250 13250 93 Stuart Kelly     male   local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000968 Oxton   1.0                   2016-05-05 0 0           PP90   0
13251 13251 413 Peter Reisdorf     male 1962-06-26 local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000963 Hoylake and Meols     http://www.libdems.org.uk/peter_reisdorf       https://static-candidates.democracyclub.org.uk/media/images/images/413.png   profile-photo brycx http://www.libdems.org.uk/peter_reisdorf 2016-05-05 0 0           PP90   0
13252 13252 5006 James Laing     male 1967-04-05 local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000975 West Kirby and Thurstaston       http://www.eddisburylabour.org/     https://static-candidates.democracyclub.org.uk/media/images/550bf52c4aa4fdc23cc908f4.png   other Eddisburylabour I own the copyright and allow its use on this site 2016-05-05 0 0           PP53   0
13253 13253 5203 Kenny Peers     male   local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000971 Rock Ferry     https://my.greenparty.org.uk/candidates/105813       https://static-candidates.democracyclub.org.uk/media/images/5519aedaba7512a07da47939.png   profile-photo kierant https://my.greenparty.org.uk/candidates/105813 2016-05-05 0 0           PP63   0
13254 13254 5428 Allan Brame     male 1952-01-20 local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000970 Prenton     http://www.libdems.org.uk/allan_brame     http://uk.linkedin.com/pub/allan-brame/67/832/448/en https://static-candidates.democracyclub.org.uk/media/images/550bdea336b6dcb123cb431e.png         2016-05-05 0 0           PP90   0
13255 13255 6881 Adam Heatherington Mr   Male 1975.0 local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000974 Wallasey             https://static-candidates.democracyclub.org.uk/media/images/images/6881.png   profile-photo ripperger2345   2016-05-05 0 0           PP85 Custard cream 0
13256 13256 11204 Jim Bradshaw         local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000954 Bebington                       2016-05-05 0 0           PP85   0
13257 13257 11205 Des Drury     male   local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000954 Bebington     https://www.wirralconservatives.com/desdrury       https://static-candidates.democracyclub.org.uk/media/images/images/11205.png   profile-photo fbrc https://www.wirralconservatives.com/desdrury 2016-05-05 0 0           PP52   0
13258 13258 11206 Penelope Ruth Golby         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000954 Bebington                       2016-05-05 0 0           PP90   0
13259 13259 11207 Christina Claire Muspratt         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000954 Bebington   1.0                   2016-05-05 0 0           PP53   0
13260 13260 11208 Anthony James Smith         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000954 Bebington                       2016-05-05 0 0           PP63   0
13261 13261 11209 Debbie Caplin     Female 1961-12-18 local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000955 Bidston and St James             https://static-candidates.democracyclub.org.uk/media/images/images/11209_H6NLrVK.png   profile-photo j0e_m Emailed to DemoClub by the candidate for use on the site. 2016-05-05 0 0           PP85   0
13262 13262 11211 Brian Gill         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000955 Bidston and St James                       2016-05-05 0 0           PP90   0
13263 13263 11212 Benjamin Halligan         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000955 Bidston and St James                       2016-05-05 0 0           PP804   0
13264 13264 11213 Nick Hanna         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000955 Bidston and St James                       2016-05-05 0 0           PP52   0
13265 13265 11214 Julie McManus         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000955 Bidston and St James   1.0                   2016-05-05 0 0           PP53   0
13266 13266 11215 June Cowin         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP52   0
13267 13267 11216 Graeme Foster         local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP85   0
13268 13268 11217 Steve Hayes     male   local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000956 Birkenhead and Tranmere             https://static-candidates.democracyclub.org.uk/media/images/images/11217.png   public-domain harryrossgorman Portrait of candidate. https://drive.google.com/file/d/1lzlqOSxs2OlmXBQKbIw1Lytnglpy9ocN/view 2016-05-05 0 0           PP63   0
13269 13269 11218 Mary Price         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP90   0
13270 13270 11219 Jean Stapleton         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000956 Birkenhead and Tranmere   1.0                   2016-05-05 0 0           PP53   0
13271 13271 11220 Jack Yarlett         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000956 Birkenhead and Tranmere                       2016-05-05 0 0           PP804   0
13272 13272 11221 Mark Halligan         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000957 Bromborough                       2016-05-05 0 0           PP804   0
13273 13273 11222 Percy Hogg         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000957 Bromborough                       2016-05-05 0 0           PP63   0
13274 13274 11223 Jennifer Lane         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000957 Bromborough                       2016-05-05 0 0           PP90   0
13275 13275 11224 Steve Niblock     male   local.wirral.2016-05-05 74 ynmp-party:2 Independent MTW:E05000957 Bromborough           https://uk.linkedin.com/in/steve-niblock-0a17753a           2016-05-05 0 0           ynmp-party:2   0
13276 13276 11225 Warren Ward Cllr   Male 1997-09-27 local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000957 Bromborough   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11225.png   copyright-assigned WAW_97 As it is my photo 2016-05-05 0 0           PP53   0
13277 13277 11226 Pete Welch         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000957 Bromborough                       2016-05-05 0 0           PP52   0
13278 13278 11227 Jan Cambridge         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000958 Clatterbridge                       2016-05-05 0 0           PP90   0
13279 13279 11228 Jenny Holliday         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000958 Clatterbridge                       2016-05-05 0 0           PP53   0
13280 13280 11229 Jim McGinley         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000958 Clatterbridge                       2016-05-05 0 0           PP63   0
13281 13281 11230 Cherry Povall         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000958 Clatterbridge   1.0                   2016-05-05 0 0           PP52   0
13282 13282 11231 George Davies         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000959 Claughton   1.0                   2016-05-05 0 0           PP53   0
13283 13283 11232 Moira Gommon         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000959 Claughton                       2016-05-05 0 0           PP63   0
13284 13284 11233 Phil Simpson         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000959 Claughton                       2016-05-05 0 0           PP804   0
13285 13285 11234 Barbara Vera Sinclair         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000959 Claughton                       2016-05-05 0 0           PP52   0
13286 13286 11235 Christopher Teggin         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000959 Claughton                       2016-05-05 0 0           PP90   0
13287 13287 11236 Phillip Gilchrist         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000960 Eastham   1.0                   2016-05-05 0 0           PP90   0
13288 13288 11237 Giuseppe Roberto         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000960 Eastham                       2016-05-05 0 0   42533.0       PP53   0
13289 13289 11238 Perle Sheldricks         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000960 Eastham                       2016-05-05 0 0           PP63   0
13290 13290 11239 Peter Taylor         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000960 Eastham                       2016-05-05 0 0           PP52   0
13291 13291 11240 Tom Anderson     male   local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000961 Greasby, Frankby and Irby   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/11240.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=361126012 2016-05-05 0 0           PP52   0
13292 13292 11241 John Cresswell         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000961 Greasby, Frankby and Irby                       2016-05-05 0 0           PP90   0
13293 13293 11242 Frank Harrison         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000961 Greasby, Frankby and Irby                       2016-05-05 0 0           PP53   0
13294 13294 11243 Cathy Page   MBE female   local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000961 Greasby, Frankby and Irby                       2016-05-05 0 0           PP63   0
13295 13295 11244 Barbara Burton         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000962 Heswall                       2016-05-05 0 0           PP63   0
13296 13296 11245 Kathryn Hodson         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000962 Heswall   1.0                   2016-05-05 0 0           PP52   0
13297 13297 11246 Jeff Judge         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000962 Heswall                       2016-05-05 0 0           PP53   0
13298 13298 11247 David Tyrrell         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000962 Heswall                       2016-05-05 0 0           PP90   0
13299 13299 11248 Alix Cockcroft         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000963 Hoylake and Meols                       2016-05-05 0 0           PP63   0
13300 13300 11249 John Hale         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000963 Hoylake and Meols   1.0                   2016-05-05 0 0           PP52   0
13301 13301 11250 Jean Robinson         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000963 Hoylake and Meols             https://static-candidates.democracyclub.org.uk/media/images/images/11250.png   profile-photo fbrc https://twitter.com/UptonLabour/status/1053391342213234688 2016-05-05 0 0   49212.0       PP53   0
13302 13302 12284 Tony Jones         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000967 New Brighton   1.0                   2016-05-05 0 0           PP53   0
13303 13303 12285 Gregory William North         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000967 New Brighton                       2016-05-05 0 0           PP804   0
13304 13304 12286 Tony Pritchard         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000967 New Brighton                       2016-05-05 0 0           PP52   0
13305 13305 12287 Cynthia Stonall         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000967 New Brighton                       2016-05-05 0 0           PP63   0
13306 13306 12288 Jackie Usher         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000967 New Brighton                       2016-05-05 0 0           PP90   0
13307 13307 12289 Paula Walters Ms   Female   local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000967 New Brighton       http://ukbestweb.co.uk/paulawaltersukip/     https://static-candidates.democracyclub.org.uk/media/images/images/12289.png   profile-photo   Auto imported from Twitter 2016-05-05 0 0   22861.0       PP85   0
13308 13308 12579 William Eborall         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000964 Leasowe and Moreton East                       2016-05-05 0 0           PP52   0
13309 13309 12580 Gillian Homeri         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000964 Leasowe and Moreton East                       2016-05-05 0 0           PP63   0
13310 13310 12581 Anita Leech         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000964 Leasowe and Moreton East   1.0                   2016-05-05 0 0           PP53   0
13311 13311 12582 Daniel Clein         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000965 Liscard                       2016-05-05 0 0           PP90   0
13312 13312 12583 Trevor Desrosiers         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000965 Liscard                       2016-05-05 0 0           PP63   0
13313 13313 12584 Ann Lavin         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000965 Liscard                       2016-05-05 0 0           PP52   0
13314 13314 12585 Ann Parry         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000965 Liscard                       2016-05-05 0 0           PP52   0
13315 13315 12586 Tom Usher         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000965 Liscard   1.0                   2016-05-05 0 0           PP53   0
13316 13316 12587 Lynda Williams         local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000965 Liscard                       2016-05-05 0 0           PP85   0
13317 13317 12588 Janette Williamson         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000965 Liscard   1.0                   2016-05-05 0 0           PP53   0
13318 13318 12605 Chris Blakeley     male   local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000966 Moreton West and Saughall Massie   1.0         https://static-candidates.democracyclub.org.uk/media/images/images/12605.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=23207410 2016-05-05 0 0           PP52   0
13319 13319 12606 Karl Greaney     male   local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000966 Moreton West and Saughall Massie                       2016-05-05 0 0           PP53   0
13320 13320 12608 Lindsey Stowell-Smith         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000966 Moreton West and Saughall Massie                       2016-05-05 0 0           PP63   0
13321 13321 12685 Liz Heydon         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000968 Oxton                       2016-05-05 0 0           PP63   0
13322 13322 12686 Philip Merry         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000968 Oxton                       2016-05-05 0 0           PP52   0
13323 13323 12687 Vicky Nowak         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000968 Oxton                       2016-05-05 0 0           PP53   0
13324 13324 12708 Allen Burton         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000969 Pensby and Thingwall                       2016-05-05 0 0           PP63   0
13325 13325 12709 Damien Cummins         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000969 Pensby and Thingwall                       2016-05-05 0 0           PP90   0
13326 13326 12710 Jan Davison         local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000969 Pensby and Thingwall                       2016-05-05 0 0           PP85   0
13327 13327 12711 Andrew Gardner     male   local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000969 Pensby and Thingwall       http://andrewgardner.campaigningforyou.com/     https://static-candidates.democracyclub.org.uk/media/images/images/12711.png   profile-photo JeniT https://twitter.com/AmgM600 2016-05-05 0 0           PP52   0
13328 13328 12712 Mike Sullivan         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000969 Pensby and Thingwall   1.0                   2016-05-05 0 0           PP53   0
13329 13329 12719 Chris Cooke     male   local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000970 Prenton             https://static-candidates.democracyclub.org.uk/media/images/images/12719.png   other harry14 This photograph comes from election literature from the Prenton ward. 2016-05-05 0 0           PP63   0
13330 13330 12720 Hilary Jones         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000970 Prenton                       2016-05-05 0 0           PP52   0
13331 13331 12721 Tony Norbury         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000970 Prenton   1.0                   2016-05-05 0 0           PP53   0
13332 13332 12727 Bill Davies         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000971 Rock Ferry   1.0                   2016-05-05 0 0           PP53   0
13333 13333 12728 Billy Foster         local.wirral.2016-05-05 74 party:85 UK Independence Party (UKIP) MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP85   0
13334 13334 12729 Leah Halligan         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP804   0
13335 13335 12730 Robert Hughes         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP52   0
13336 13336 12731 Edward Smith         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000971 Rock Ferry                       2016-05-05 0 0           PP90   0
13337 13337 12732 John Laing         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000972 Seacombe                       2016-05-05 0 0           PP52   0
13338 13338 12733 Paul Stuart         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000972 Seacombe   1.0                   2016-05-05 0 0           PP53   0
13339 13339 12734 Lily Clough     female   local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000973 Upton     https://my.greenparty.org.uk/candidates/106264       https://static-candidates.democracyclub.org.uk/media/images/images/12734.png   profile-photo J https://my.greenparty.org.uk/candidates/106264 2016-05-05 0 0           PP63   0
13340 13340 12735 Alan Davies         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000973 Upton                       2016-05-05 0 0           PP90   0
13341 13341 12736 Geoffrey Gubb         local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000973 Upton                       2016-05-05 0 0           PP52   0
13342 13342 12737 Philip Jones         local.wirral.2016-05-05 74 party:804 Trade Unionist and Socialist Coalition MTW:E05000973 Upton                       2016-05-05 0 0           PP804   0
13343 13343 12738 Matthew Patrick         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000973 Upton   1.0                   2016-05-05 0 0           PP53   0
13344 13344 12739 John Codling         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000974 Wallasey                       2016-05-05 0 0           PP90   0
13345 13345 12740 Ian Lewis     male   local.wirral.2016-05-05 74 party:52 Conservative and Unionist Party MTW:E05000974 Wallasey   1.0 https://www.wirralconservatives.com/ianlewis       https://static-candidates.democracyclub.org.uk/media/images/images/12740.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=728602309542985732 2016-05-05 0 0           PP52   0
13346 13346 12741 Bill McGenity         local.wirral.2016-05-05 74 party:53 Labour Party MTW:E05000974 Wallasey                       2016-05-05 0 0           PP53   0
13347 13347 12742 John Rodgers         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000974 Wallasey                       2016-05-05 0 0           PP63   0
13348 13348 12745 Yvonne McGinley         local.wirral.2016-05-05 74 party:63 Green Party MTW:E05000975 West Kirby and Thurstaston                       2016-05-05 0 0           PP63   0
13349 13349 12746 Mike Redfern         local.wirral.2016-05-05 74 party:90 Liberal Democrats MTW:E05000975 West Kirby and Thurstaston                       2016-05-05 0 0           PP90   0

Next page

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 9.73ms · Data license: CC-BY-SA · Data source: Democracy Club