COVID_Johns_Hopkins_daily_reports: 03-25-2020: 9 rows where where Last

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

9 rows where Last_Update = "2020-03-25 06:43:02"

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	Province_State	Country_Region	Last_Update	Lat	Long_	Confirmed	Deaths	Recovered	Active	Combined_Key
3187	3187	Fujian	China	2020-03-25 06:43:02	26.0789	117.9874	322	1	295	26	Fujian, China
3205	3205	Inner Mongolia	China	2020-03-25 06:43:02	44.0935	113.9448	77	1	74	2	Inner Mongolia, China
3207	3207	Jiangsu	China	2020-03-25 06:43:02	32.9711	119.455	638	0	631	7	Jiangsu, China
3209	3209	Jilin	China	2020-03-25 06:43:02	43.6661	126.1923	94	1	92	1	Jilin, China
3237	3237	Shaanxi	China	2020-03-25 06:43:02	35.1917	108.8701	250	3	240	7	Shaanxi, China
3238	3238	Shandong	China	2020-03-25 06:43:02	36.3427	118.1498	769	7	752	10	Shandong, China
3239	3239	Shanghai	China	2020-03-25 06:43:02	31.202	121.4491	433	5	330	98	Shanghai, China
3241	3241	Sichuan	China	2020-03-25 06:43:02	30.6171	102.7103	547	3	536	8	Sichuan, China
3253	3253	Zhejiang	China	2020-03-25 06:43:02	29.1832	120.0934	1241	1	1221	19	Zhejiang, China

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [03-25-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
);