home / democracyclub

democracyclub

Custom SQL query returning 5 rows

Query parameters

This data as JSON, CSV

rowididnamehonorific_prefixhonorific_suffixgenderbirth_dateelectionparty_idparty_namepost_idpost_labelmapit_urlelectedparty_ppc_page_urlhomepage_urlwikipedia_urllinkedin_urlimage_urlproxy_image_url_templateimage_copyrightimage_uploading_userimage_uploading_user_noteselection_dateelection_currentparty_lists_in_useparty_list_positionold_person_idsgss_codeparlparse_idtheyworkforyou_urlparty_ec_idfavourite_biscuitscancelled_poll
11699 19435 Jess Brayne     female   50 party:53 Labour Party LBW:E05000060 Underhill             https://static-candidates.democracyclub.org.uk/media/images/images/19435.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=722886281668227072 2016-05-05 0 0           PP53   0
11700 19436 Lesley Evans         50 party:52 Conservative and Unionist Party LBW:E05000060 Underhill                       2016-05-05 0 0           PP52   0
11701 19437 Phil Fletcher     male   50 party:63 Green Party LBW:E05000060 Underhill     https://my.greenparty.org.uk/candidates/105890 https://barnet.greenparty.org.uk/     https://static-candidates.democracyclub.org.uk/media/images/images/19437.png   profile-photo   Auto imported from Twitter: https://twitter.com/intent/user?user_id=194977936 2016-05-05 0 0   43723.0       PP63   0
11702 19438 Duncan Macdonald Mr   male   50 party:90 Liberal Democrats LBW:E05000060 Underhill                       2016-05-05 0 0           PP90   0
11703 19439 Barry Ryan         50 party:85 UK Independence Party (UKIP) LBW:E05000060 Underhill                       2016-05-05 0 0           PP85   0
Powered by Datasette · Query took 0.322ms