election-2024

Custom SQL query

Tables

_enrichment_errors

id, job_id, created_at, row_pks, error

78 rows

_enrichment_jobs

id, status, enrichment, database_name, table_name, filter_querystring, config, started_at, finished_at, cancel_reason, next_cursor, row_count, error_count, done_count, actor_id, cost_100ths_cent

1 row

address_geocoding

rowid, full_name, address, latitude, longitude, opencage_result

696 rows

candidate_details

name, imageURL, candidatePage, party, titles, statement, contact

355 rows

candidate_to_ro

candidate, ro

688 rows

candidates

constituency, party, wikipedia, name, incumbent, previous_member_of_dail_or_seanad

690 rows

constituencies

constituency, seat_count, returning_officer_url, candidate_listing_page

43 rows

constituency_boundaries

id, OBJECTID_1, GUID, CON_SEAT_, CON_ID, InPoly_FID, SimPgnFlag, MaxSimpTol, MinSimpTol, geometry

39 rows

party_websites

party, website

21 rows

returning_officer_data

constituency, surname, party, full_name, address, occupation, imageUrl

698 rows

Views

Download SQLite DB: election-2024.db 7.3 MB