03-25-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

8 rows where Last_Update = "2020-03-25 23:37:49"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Deaths, Recovered, Last_Update (date)

Last_Update ✖

  • 2020-03-25 23:37:49 · 8 ✖
Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3174 3174     Australian Capital Territory Australia 2020-03-25 23:37:49 -35.4735 149.0124 39 0 0 39 Australian Capital Territory, Australia
3218 3218     New South Wales Australia 2020-03-25 23:37:49 -33.8688 151.2093 1029 7 4 1018 New South Wales, Australia
3222 3222     Northern Territory Australia 2020-03-25 23:37:49 -12.4634 130.8456 6 0 0 6 Northern Territory, Australia
3230 3230     Queensland Australia 2020-03-25 23:37:49 -27.4698 153.0251 443 0 8 435 Queensland, Australia
3243 3243     South Australia Australia 2020-03-25 23:37:49 -34.9285 138.6007 170 0 6 164 South Australia, Australia
3245 3245     Tasmania Australia 2020-03-25 23:37:49 -42.8821 147.3272 36 0 3 33 Tasmania, Australia
3248 3248     Victoria Australia 2020-03-25 23:37:49 -37.8136 144.9631 466 0 97 369 Victoria, Australia
3250 3250     Western Australia Australia 2020-03-25 23:37:49 -31.9505 115.8605 175 1 1 173 Western Australia, Australia

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);