04-06-2020

Table actions
Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

4 rows where Last_Update = "4/6/20 1:14"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths

Last_Update ✖

  • 4/6/20 1:14 · 4 ✖
Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
2544 2544     Beijing China 4/6/20 1:14 40.1824 116.4142 587 8 443 136 Beijing, China
2559 2559     Fujian China 4/6/20 1:14 26.0789 117.9874 350 1 305 44 Fujian, China
2611 2611     Shaanxi China 4/6/20 1:14 35.1917 108.8701 256 3 246 7 Shaanxi, China
2615 2615     Sichuan China 4/6/20 1:14 30.6171 102.7103 559 3 540 16 Sichuan, China

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-06-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);