us

Table actions
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

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

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