Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

405 rows

View and edit SQL

Suggested facets: date (date)

Link rowid ▼ date cases deaths
1 2020-01-21 1 0
2 2020-01-22 1 0
3 2020-01-23 1 0
4 2020-01-24 2 0
5 2020-01-25 3 0
6 2020-01-26 5 0
7 2020-01-27 5 0
8 2020-01-28 5 0
9 2020-01-29 5 0
10 2020-01-30 6 0
11 2020-01-31 7 0
12 2020-02-01 8 0
13 2020-02-02 11 0
14 2020-02-03 11 0
15 2020-02-04 11 0
16 2020-02-05 12 0
17 2020-02-06 12 0
18 2020-02-07 12 0
19 2020-02-08 12 0
20 2020-02-09 12 0
21 2020-02-10 13 0
22 2020-02-11 13 0
23 2020-02-12 14 0
24 2020-02-13 15 0
25 2020-02-14 15 0
26 2020-02-15 15 0
27 2020-02-16 15 0
28 2020-02-17 25 0
29 2020-02-18 25 0
30 2020-02-19 25 0
31 2020-02-20 27 0
32 2020-02-21 30 0
33 2020-02-22 30 0
34 2020-02-23 30 0
35 2020-02-24 43 0
36 2020-02-25 45 0
37 2020-02-26 60 0
38 2020-02-27 60 0
39 2020-02-28 65 0
40 2020-02-29 70 1
41 2020-03-01 88 3
42 2020-03-02 104 6
43 2020-03-03 125 10
44 2020-03-04 161 12
45 2020-03-05 228 12
46 2020-03-06 311 15
47 2020-03-07 428 19
48 2020-03-08 547 22
49 2020-03-09 748 26
50 2020-03-10 1018 31
51 2020-03-11 1263 37
52 2020-03-12 1668 43
53 2020-03-13 2224 50
54 2020-03-14 2898 60
55 2020-03-15 3600 68
56 2020-03-16 4507 91
57 2020-03-17 5906 117
58 2020-03-18 8350 162
59 2020-03-19 12393 212
60 2020-03-20 18012 277
61 2020-03-21 24528 360
62 2020-03-22 33073 458
63 2020-03-23 43505 579
64 2020-03-24 53938 785
65 2020-03-25 68572 1054
66 2020-03-26 85570 1353
67 2020-03-27 102900 1770
68 2020-03-28 123966 2300
69 2020-03-29 142486 2718
70 2020-03-30 163955 3368
71 2020-03-31 188461 4304
72 2020-04-01 215391 5325
73 2020-04-02 245108 6541
74 2020-04-03 277426 7932
75 2020-04-04 312525 9488
76 2020-04-05 338141 10856
77 2020-04-06 369057 12382
78 2020-04-07 399394 14616
79 2020-04-08 431214 16701
80 2020-04-09 465913 18821
81 2020-04-10 499386 21084
82 2020-04-11 531106 23168
83 2020-04-12 558249 24849
84 2020-04-13 584018 26613
85 2020-04-14 610709 29318
86 2020-04-15 640742 32070
87 2020-04-16 672355 34419
88 2020-04-17 703864 36708
89 2020-04-18 732262 38659
90 2020-04-19 757596 40179
91 2020-04-20 784991 42016
92 2020-04-21 810505 44688
93 2020-04-22 839336 47059
94 2020-04-23 873112 49228
95 2020-04-24 909853 51360
96 2020-04-25 944261 53327
97 2020-04-26 970996 54580
98 2020-04-27 994193 56022
99 2020-04-28 1018844 58416
100 2020-04-29 1045399 60930

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [us] (
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);