search

MEDSL / 2022-elections-official

Official returns for the 2022 Midterm Elections
14 stars 3 forks source link

Missing Races from Power County ID #19

Open rsolo19 opened 5 months ago

rsolo19 commented 5 months ago

Hello! I noticed there may be some missing races from the Power County, ID results. The below query shows that we have votes for STATE SENATE, ATTORNEY GENERAL, COUNTYWIDE VOTING STATISTICS, and then 0 votes for Governor and Secretary of State. But looking online at the Power County results from 2022, I think we'd expect results from other contests too, such as US Senate, US House, and > 0 votes for Governor.

select office, sum(votes)
from `src_medsl__id_2022`
where state_code = 'ID'
and county_name = 'POWER'
and election_year = '2022'
group by 1

As always thanks for all of your work on this :) Let me know if I'm missing something!!

sbaltzmit commented 5 months ago

Good catch, I think you're right. I just checked the precinct data that we downloaded from the state, and it looks like several pages of the Excel spreadsheets have broken references ("#REF!") instead of the vote totals. I'll add a note in the readme and I'll see if I can find a better data source, and please let me know if you have already found a way to obtain the correct precinct-level results for those contests. Thanks!