Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are time series reports which provide cases, deaths and recovered for global locations as well as United States counties. Each file covers from Jan 22 to the present. For the United States there is one file for cases and one for deaths. For the global locations, there is one file for cases, one for deaths and one for recovered cases. The entire set of CSV files are refreshed daily. The zipped archives contain previous time series 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: big-local-datasette

1,060 rows

View and edit SQL

Suggested facets: File

Link rowid ▼ Update Date File Location Field Updated Old New Comments
1 4/7/2020 time_series_covid19_confirmed_US.csv Viginia Island 3/29/2020 0 23 New York Times
2 4/7/2020 time_series_covid19_confirmed_US.csv Viginia Island 3/30/2020 0 30 New York Times
3 4/7/2020 time_series_covid19_confirmed_US.csv DC, US 3/21/2020 0 98 New York Times
4 4/7/2020 time_series_covid19_confirmed_US.csv Miami-Dade, FL 3/19/2020 0 101 New York Times
5 4/7/2020 time_series_covid19_confirmed_US.csv Miami-Dade, FL 3/20/2020 0 124 New York Times
6 4/7/2020 time_series_covid19_confirmed_US.csv Hillsborough, NH 4/2/2020 0 163 New York Times
7 4/7/2020 time_series_covid19_confirmed_US.csv Harris, TX 3/20/2020 0 55 New York Times
8 4/7/2020 time_series_covid19_confirmed_US.csv Kansas City 3/21/2020 0 13 New York Times
9 4/9/2020 time_series_covid19_confirmed_US.csv Box Elder, UT 3/20/2020 13 7 New York Times
10 4/9/2020 time_series_covid19_confirmed_US.csv Union, FL 4/4/2020 10 2 New York Times
11 4/9/2020 time_series_covid19_confirmed_US.csv Daviess, KY 3/28/2020 33 20 New York Times
12 4/9/2020 time_series_covid19_confirmed_US.csv Washington, RI 4/2/2020 46 34 New York Times
13 4/9/2020 time_series_covid19_confirmed_US.csv West Feliciana, LA 4/2/2020 20 10 New York Times
14 4/9/2020 time_series_covid19_confirmed_US.csv Davidson, TN 4/2/2020 617 785 New York Times
15 4/13/2020 time_series_covid19_confirmed_global.csv Florida 4/13/2020 682619 580619 data source error
16 4/13/2020 time_series_covid19_confirmed_US.csv Okaloosa, Florida 4/13/2020 102103 103 data source error
17 4/14/2020 time_series_covid19_deaths_US.csv Unassigned, NY 4/3/2020 955 623  
18 4/14/2020 time_series_covid19_deaths_US.csv Unassigned, NY 4/4/2020 1173 427  
19 4/14/2020 time_series_covid19_deaths_US.csv Unassigned, NY 4/5/2020 1260 338  
20 4/16/2020 time_series_covid19_deaths_global.csv France 4/1/2020 4032 4403 add 371 decesEhpad
21 4/16/2020 time_series_covid19_confirmed_global.csv France 4/4/2020 89953 68605 only report casConfirmes
22 4/16/2020 time_series_covid19_confirmed_global.csv France 4/5/2020 92839 70478  
23 4/16/2020 time_series_covid19_confirmed_global.csv France 4/6/2020 98010 74390  
24 4/16/2020 time_series_covid19_confirmed_global.csv France 4/7/2020 109069 78167  
25 4/16/2020 time_series_covid19_confirmed_global.csv France 4/8/2020 112950 82048  
26 4/16/2020 time_series_covid19_confirmed_global.csv France 4/9/2020 117749 86334  
27 4/16/2020 time_series_covid19_confirmed_global.csv France 4/10/2020 124869 90676  
28 4/16/2020 time_series_covid19_confirmed_global.csv France 4/11/2020 129654 93790  
29 4/16/2020 time_series_covid19_confirmed_global.csv France 4/12/2020 132591 120633 casPossiblesEhpad added
30 4/16/2020 time_series_covid19_confirmed_global.csv France 4/13/2020 136779 124298  
31 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/11/2020 3 2  
32 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/12/2020 3 2  
33 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/13/2020 3 2  
34 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/14/2020 3 2  
35 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/15/2020 3 2  
36 4/16/2020 time_series_covid19_confirmed_US.csv Sutter, California 4/16/2020 3 2  
37 4/16/2020 time_series_covid19_confirmed_global.csv US 4/11/2020 20463 20462  
38 4/16/2020 time_series_covid19_confirmed_global.csv US 4/12/2020 22020 22019  
39 4/16/2020 time_series_covid19_confirmed_global.csv US 4/13/2020 23529 23528  
40 4/16/2020 time_series_covid19_confirmed_global.csv US 4/14/2020 25832 25831  
41 4/16/2020 time_series_covid19_confirmed_global.csv US 4/15/2020 28326 28325  
42 4/16/2020 time_series_covid19_confirmed_global.csv US 4/16/2020 32917 32916  
43 4/18/2020 time_series_covid19_confirmed_US.csv all Illinois counties 4/7/2020 12271 13553 changed at county level,
44 4/18/2020 time_series_covid19_deaths_US.csv all Illinois counties 4/7/2020 308 380 aggregated state value
45 4/18/2020 time_series_covid19_confirmed_global.csv US 4/7/2020 396223 397505  
46 4/18/2020 time_series_covid19_deaths_global.csv US 4/7/2020 12722 12794  
47 4/18/2020 time_series_covid19_confirmed_US.csv all Illinois counties 4/9/2020 15079 16422 changed at county level,
48 4/18/2020 time_series_covid19_deaths_US.csv all Illinois counties 4/9/2020 462 528 aggregated state value
49 4/18/2020 time_series_covid19_confirmed_global.csv US 4/9/2020 461437 462780  
50 4/18/2020 time_series_covid19_deaths_global.csv US 4/9/2020 16478 16544  
51 4/19/2020 time_series_covid19_confirmed_US.csv Davidson, Tennessee 4/16/2020 1492 1283  
52 4/19/2020 time_series_covid19_confirmed_global.csv US 4/16/2020 667801 667592  
53 4/22/2020 time_series_covid19_confirmed_global.csv US 4/1/2020 213372 213242 Navajo Nation correction
54 4/22/2020 time_series_covid19_confirmed_global.csv US 4/2/2020 243762 243622 Navajo Nation correction
55 4/22/2020 time_series_covid19_confirmed_global.csv US 4/3/2020 275586 275367 Navajo Nation correction
56 4/22/2020 time_series_covid19_confirmed_global.csv US 4/4/2020 308853 308650 Navajo Nation correction
57 4/22/2020 time_series_covid19_confirmed_global.csv US 4/5/2020 337072 336802 Navajo Nation correction
58 4/22/2020 time_series_covid19_confirmed_global.csv US 4/6/2020 366667 366317 Navajo Nation correction
59 4/22/2020 time_series_covid19_confirmed_global.csv US 4/7/2020 397505 397121 Navajo Nation correction
60 4/22/2020 time_series_covid19_confirmed_global.csv US 4/8/2020 429052 428654 Navajo Nation correction
61 4/22/2020 time_series_covid19_deaths_global.csv US 3/31/2020 3873 3874 Navajo Nation correction
62 4/22/2020 time_series_covid19_deaths_global.csv US 4/1/2020 4757 4760 Navajo Nation correction
63 4/22/2020 time_series_covid19_deaths_global.csv US 4/2/2020 5926 5929 Navajo Nation correction
64 4/22/2020 time_series_covid19_deaths_global.csv US 4/3/2020 7087 7090 Navajo Nation correction
65 4/22/2020 time_series_covid19_deaths_global.csv US 4/4/2020 8407 8408 Navajo Nation correction
66 4/22/2020 time_series_covid19_deaths_global.csv US 4/7/2020 12794 12794 Navajo Nation correction
67 4/22/2020 time_series_covid19_deaths_global.csv US 4/8/2020 14695 14704 Navajo Nation correction
68 4/22/2020 time_series_covid19_deaths_global.csv US 4/10/2020 18586 18595 Navajo Nation correction
69 4/22/2020 time_series_covid19_deaths_global.csv US 4/11/2020 20462 20471 Navajo Nation correction
70 4/22/2020 time_series_covid19_deaths_global.csv US 4/12/2020 22019 22029 Navajo Nation correction
71 4/22/2020 time_series_covid19_deaths_global.csv US 4/13/2020 23528 23538 Navajo Nation correction
72 4/22/2020 time_series_covid19_deaths_global.csv US 4/14/2020 25831 25843 Navajo Nation correction
73 4/22/2020 time_series_covid19_deaths_global.csv US 4/15/2020 28325 28338 Navajo Nation correction
74 4/22/2020 time_series_covid19_deaths_global.csv US 4/16/2020 32916 32930 Navajo Nation correction
75 4/22/2020 time_series_covid19_deaths_global.csv US 4/17/2020 36773 36787 Navajo Nation correction
76 4/22/2020 time_series_covid19_confirmed_US.csv Navajo, AZ 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
77 4/22/2020 time_series_covid19_confirmed_US.csv Coconino, AZ 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
78 4/22/2020 time_series_covid19_confirmed_US.csv Apache, AZ 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
79 4/22/2020 time_series_covid19_confirmed_US.csv San Juan, NM 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
80 4/22/2020 time_series_covid19_confirmed_US.csv McKinley, NM 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
81 4/22/2020 time_series_covid19_confirmed_US.csv Cibola, NM 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
82 4/22/2020 time_series_covid19_confirmed_US.csv Socorro, NM 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
83 4/22/2020 time_series_covid19_confirmed_US.csv San Juan, UT 04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20     remove duplicates
84 4/22/2020 time_series_covid19_deaths_US.csv Navajo, AZ 3/31/20;04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20;04/09/20;04/10/20;04/11/20;04/12/20;04/13/20;04/14/20;04/15/20;04/16/20;04/17/20     remove duplicates
85 4/22/2020 time_series_covid19_deaths_US.csv Coconino, AZ 3/31/20;04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20;04/09/20;04/10/20;04/11/20;04/12/20;04/13/20;04/14/20;04/15/20;04/16/20;04/17/20     remove duplicates
86 4/22/2020 time_series_covid19_deaths_US.csv Apache, AZ 3/31/20;04/01/20;04/02/20;04/03/20;04/04/20;04/05/20;04/06/20;04/07/20;04/08/20;04/09/20;04/10/20;04/11/20;04/12/20;04/13/20;04/14/20;04/15/20;04/16/20;04/17/20     remove duplicates
87 4/22/2020 time_series_covid19_deaths_US.csv McKinley, NM 4/4/2020 0 1 remove duplicates
88 4/22/2020 time_series_covid19_confirmed_US.csv Unassigned, WA 4/19/2020 436 159 remove spike
89 4/22/2020 time_series_covid19_confirmed_global.csv US 4/19/2020 759086 758809 remove spike
90 4/22/2020 time_series_covid19_confirmed_US.csv US 4/21/2020     correction for US federal data
91 4/22/2020 time_series_covid19_deaths_US.csv US 4/21/2020     correction for US federal data
92 4/22/2020 time_series_covid19_confirmed_global.csv US 4/21/2020     correction for US federal data
93 4/22/2020 time_series_covid19_deaths_global.csv US 4/21/2020     correction for US federal data
94 4/23/2020 time_series_covid19_confirmed_US.csv Benton, WA 4/21/2020 423 326 remove 97 probable cases,
95 4/23/2020 time_series_covid19_confirmed_US.csv Benton, WA 4/22/2020 0 338 consistent with state report
96 4/23/2020 time_series_covid19_confirmed_US.csv Franklin, WA 4/21/2020 266 192 remove 74 probable cases,
97 4/23/2020 time_series_covid19_confirmed_US.csv Franklin, WA 4/22/2020 0 207 consistent with state report
98 4/23/2020 time_series_covid19_deaths_US.csv Benton, WA 4/22/2020 0 35 adjust for Benton and Franklin, WA
99 4/23/2020 time_series_covid19_deaths_US.csv Franklin, WA 4/22/2020 0 4 adjust for Benton and Franklin, WA
100 4/23/2020 time_series_covid19_confirmed_global.csv US 4/21/2020 812036 811865 adjust for Benton and Franklin, WA

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [Errata] (
   [Update Date] TEXT,
   [File] TEXT,
   [Location] TEXT,
   [Field Updated] TEXT,
   [Old] INTEGER,
   [New] INTEGER,
   [Comments] TEXT
);