data.world-r

data.world-r copied to clipboard

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!