dumfriesva-gov/covid19-cases-jhy9-25m3
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 10 months ago
Indexed 1 month ago

Covid-19 | Cases

March 2020 - Present. An overview by locality of total cases, total hospitalizations and total deaths for the Commonwealth of Virginia. Updated daily at 12:00 p.m.

From data.virginia.gov: "This data set includes the cumulative (total) number of COVID-19 cases, hospitalizations, and deaths for each locality in Virginia by report date. This data set was first published on April 01, 2020. The data set increases in size daily and as a result, the dataset may take longer to update; however, it is expected to be available by 12:00 noon daily. When you download the data set, the dates will be sorted in ascending order, meaning that the earliest date will be at the top. To see data for the most recent date, please scroll down to the bottom of the data set. The Virginia Department of Health’s Thomas Jefferson Health District (TJHD) will be renamed to Blue Ridge Health District (BRHD), effective January 2021. More information about this change can be found here: https://www.vdh.virginia.gov/blue-ridge/name-change/"

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"dumfriesva-gov/covid19-cases-jhy9-25m3\".\"covid19_cases\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • covid19_cases