previously unseen geocoded_state
values broke covid_hosp_state_timeseries acquisition
#1420
Labels
geocoded_state
values broke covid_hosp_state_timeseries acquisition
#1420
The "Update COVID Hosp: state timeseries dataset" acquisition job has been failing since apr 4 2024; first failure in cronicle: https://cronicle-prod-01.delphi.cmu.edu/#JobDetails?id=jluljl1fnlb
Error message from cronicle:
The offending csv file is https://us-dhhs-aa.s3.us-east-2.amazonaws.com/g62h-syeh_2024-04-04T07-01-48.csv
In our TABLE
covid_hosp_state_timeseries
, COLUMNgeocoded_state
is of typeVARCHAR(32)
.The most recently successfully imported csv has nulls/empties for geocoded_state column, as does the csv issued immediately after the offending csv file, as does the most recently issued csv. Only the one csv appears to have these long "
POINT (...
" values. I downloaded these 4 mentioned csv files and ran the following commands to demonstrate:Attempt to skip the offending file similar to solution in #1369 :
After adding that line to the
covid_hosp_meta
table above, i re-ran the cronicle job and am now awaiting the results.The text was updated successfully, but these errors were encountered: