counties

Data provided by Big Local News and snapshotted daily from the COVID19 Tracker, https://covidtracking.com/.

Data source: Big Local News · About: README

11 rows

View and edit SQL

Suggested facets: state, mainSite, pui, downloaded_by_bln (date)

Link rowid ▼ state county covid19Site dataSite mainSite pui pum downloaded_by_bln
1 CA Los Angeles http://publichealth.lacounty.gov/media/Coronavirus/#     No data   2020-05-13T05:15:01+00:00
2 NY Westchester https://health.westchestergov.com/2019-novel-coronavirus     No data   2020-05-13T05:15:01+00:00
3 WA King https://www.kingcounty.gov/depts/health/communicable-diseases/disease-control/novel-coronavirus.aspx     No data   2020-05-13T05:15:01+00:00
4 WA Snohomish https://www.snohd.org/484/Novel-Coronavirus-2019     All data   2020-05-13T05:15:01+00:00
5 WA Grant http://granthealth.org/2019-novel-coronavirus-2019-ncov/     No data   2020-05-13T05:15:01+00:00
6 WA Jefferson https://www.jeffersoncountypublichealth.org/1429/COVID-19     All data   2020-05-13T05:15:01+00:00
7 WA Pierce https://www.tpchd.org/healthy-people/human-coronavirus     Only positives   2020-05-13T05:15:01+00:00
8 WA Clark https://www.clark.wa.gov/public-health/novel-coronavirus     All data   2020-05-13T05:15:01+00:00
9 WA Kittitas https://www.co.kittitas.wa.us/response/202003-covid19/default.aspx     No data   2020-05-13T05:15:01+00:00
10 CA Contra Costa https://www.coronavirus.cchealth.org/   https://cchealth.org/     2020-05-13T05:15:01+00:00
11 CA Alameda County http://www.acphd.org/2019-ncov.aspx   http://www.acphd.org/     2020-05-13T05:15:01+00:00

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [counties] (
   [state] TEXT,
   [county] TEXT,
   [covid19Site] TEXT,
   [dataSite] TEXT,
   [mainSite] TEXT,
   [twitter] TEXT,
   [pui] TEXT,
   [pum] TEXT,
   [downloaded_by_bln] TEXT
);
Powered by Datasette · Query took 19.399ms · Data source: Big Local News · About: README