data.world-r
data.world-r copied to clipboard
Parsing Errors with Package
Hello @datadotworld, I am currently working with the COVID-19 data on the site, but I am running into parsing errors with my queries.
I have tried the following codes:
df2 <- dwapi::sql(
owner_id = "covid-19-data-resource-hub",
dataset_id = "covid-19-case-counts",
"SELECT * FROM covid_19_cases")
and
library("data.world")
sql_stmt <- qry_sql("SELECT * FROM covid_19_cases")
df <- data.world::query(
sql_stmt, "covid-19-data-resource-hub/covid-19-case-counts")
Both queries run, but I get the following error:
1517712 parsing failures.
row col expected actual file
58631 admin2 1/0/T/F/TRUE/FALSE Jackson literal data
58631 fips 1/0/T/F/TRUE/FALSE 20085 literal data
58632 admin2 1/0/T/F/TRUE/FALSE Sequatchie literal data
58632 fips 1/0/T/F/TRUE/FALSE 47153 literal data
58633 admin2 1/0/T/F/TRUE/FALSE Wayne literal data
..... ...... .................. .......... ............
See problems(...) for more details.
Is there a way to fix this error? I'm new to the packages and how they work. I can't seem to find any info on this in the documentation.
Thanks!