CPC Leadership Results 2022

Breakdown of voting across the Canadian federal electoral districts

@kaggle.iammattaustin_cpcleadership2022

Table List

1 table(38.45 KB)

Cpcldr Results By Ed 2022

@kaggle.iammattaustin_cpcleadership2022.cpcldr_results_by_ed_2022

38.45 KB
338 rows
13 columns

ed ED	scott_aitchison Scott Aitchison	roman_baber Roman Baber	jean_charest Jean Charest	leslyn_lewis Leslyn Lewis	pierre_poilievre Pierre Poilievre	total_votes Total Votes	scott_aitchison_1 Scott Aitchison.1	roman_baber_1 Roman Baber.1	jean_charest_1 Jean Charest.1	leslyn_lewis_1 Leslyn Lewis.1	pierre_poilievre_1 Pierre Poilievre.1	total_electoral_pts Total Electoral Pts
10001 - Avalon	2	11	76	52	348	489	0.409	2.24949	15.54192	10.63395	71.16564	100
10002 - Bonavista–Burin–Trinity	3	6	25	27	237	298	1.00671	2.01342	8.38926	9.0604	79.5302	100
10003 - Coast of Bays–Central–Notre Dame	2	18	48	64	410	542	0.369	3.32103	8.85609	11.80812	75.64576	100
10004 - Labrador		4	7	4	118	133		3.00752	5.26316	3.00752	88.72181	100
10005 - Long Range Mountains	1	6	44	35	351	437	0.22883	1.373	10.06865	8.00915	80.32037	100
10006 - St. John's East	8	17	119	76	316	536	1.49254	3.17164	22.20149	14.1791	58.95522	100
10007 - St. John's South–Mount Pearl	3	14	69	48	253	387	0.77519	3.61757	17.82946	12.4031	65.37468	100
11001 - Cardigan	6	9	83	69	316	483	1.24224	1.86335	17.18427	14.28571	65.42443	100
11002 - Charlottetown	4	8	100	68	181	361	1.10803	2.21607	27.70083	18.83657	50.1385	100
11003 - Egmont	2	6	42	85	275	410	0.48781	1.46342	10.2439	20.73171	67.07317	100


CREATE TABLE cpcldr_results_by_ed_2022 (
  "ed" VARCHAR,
  "scott_aitchison" BIGINT,
  "roman_baber" BIGINT,
  "jean_charest" BIGINT,
  "leslyn_lewis" BIGINT,
  "pierre_poilievre" BIGINT,
  "total_votes" BIGINT,
  "scott_aitchison_1" DOUBLE,
  "roman_baber_1" DOUBLE,
  "jean_charest_1" DOUBLE,
  "leslyn_lewis_1" DOUBLE,
  "pierre_poilievre_1" DOUBLE,
  "total_electoral_pts" DOUBLE
);