Skip to content

Parsing Errors with Package #49

Description

@castower

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!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions