New_York_Times_COVID_data

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

Custom SQL query returning 101 rows (hide)

rowiddatestatefipscasesdeaths
1 2020-01-21 Washington 53 1 0
2 2020-01-22 Washington 53 1 0
3 2020-01-23 Washington 53 1 0
4 2020-01-24 Illinois 17 1 0
5 2020-01-24 Washington 53 1 0
6 2020-01-25 California 6 1 0
7 2020-01-25 Illinois 17 1 0
8 2020-01-25 Washington 53 1 0
9 2020-01-26 Arizona 4 1 0
11 2020-01-26 Illinois 17 1 0
12 2020-01-26 Washington 53 1 0
13 2020-01-27 Arizona 4 1 0
15 2020-01-27 Illinois 17 1 0
16 2020-01-27 Washington 53 1 0
17 2020-01-28 Arizona 4 1 0
19 2020-01-28 Illinois 17 1 0
20 2020-01-28 Washington 53 1 0
21 2020-01-29 Arizona 4 1 0
23 2020-01-29 Illinois 17 1 0
24 2020-01-29 Washington 53 1 0
25 2020-01-30 Arizona 4 1 0
28 2020-01-30 Washington 53 1 0
29 2020-01-31 Arizona 4 1 0
32 2020-01-31 Washington 53 1 0
33 2020-02-01 Arizona 4 1 0
36 2020-02-01 Massachusetts 25 1 0
37 2020-02-01 Washington 53 1 0
38 2020-02-02 Arizona 4 1 0
41 2020-02-02 Massachusetts 25 1 0
42 2020-02-02 Washington 53 1 0
43 2020-02-03 Arizona 4 1 0
46 2020-02-03 Massachusetts 25 1 0
47 2020-02-03 Washington 53 1 0
48 2020-02-04 Arizona 4 1 0
51 2020-02-04 Massachusetts 25 1 0
52 2020-02-04 Washington 53 1 0
53 2020-02-05 Arizona 4 1 0
56 2020-02-05 Massachusetts 25 1 0
57 2020-02-05 Washington 53 1 0
58 2020-02-05 Wisconsin 55 1 0
59 2020-02-06 Arizona 4 1 0
62 2020-02-06 Massachusetts 25 1 0
63 2020-02-06 Washington 53 1 0
64 2020-02-06 Wisconsin 55 1 0
65 2020-02-07 Arizona 4 1 0
68 2020-02-07 Massachusetts 25 1 0
69 2020-02-07 Washington 53 1 0
70 2020-02-07 Wisconsin 55 1 0
71 2020-02-08 Arizona 4 1 0
74 2020-02-08 Massachusetts 25 1 0
75 2020-02-08 Washington 53 1 0
76 2020-02-08 Wisconsin 55 1 0
77 2020-02-09 Arizona 4 1 0
80 2020-02-09 Massachusetts 25 1 0
81 2020-02-09 Washington 53 1 0
82 2020-02-09 Wisconsin 55 1 0
83 2020-02-10 Arizona 4 1 0
86 2020-02-10 Massachusetts 25 1 0
87 2020-02-10 Washington 53 1 0
88 2020-02-10 Wisconsin 55 1 0
89 2020-02-11 Arizona 4 1 0
92 2020-02-11 Massachusetts 25 1 0
93 2020-02-11 Washington 53 1 0
94 2020-02-11 Wisconsin 55 1 0
95 2020-02-12 Arizona 4 1 0
98 2020-02-12 Massachusetts 25 1 0
99 2020-02-12 Texas 48 1 0
100 2020-02-12 Washington 53 1 0
101 2020-02-12 Wisconsin 55 1 0
102 2020-02-13 Arizona 4 1 0
105 2020-02-13 Massachusetts 25 1 0
107 2020-02-13 Washington 53 1 0
108 2020-02-13 Wisconsin 55 1 0
109 2020-02-14 Arizona 4 1 0
112 2020-02-14 Massachusetts 25 1 0
114 2020-02-14 Washington 53 1 0
115 2020-02-14 Wisconsin 55 1 0
116 2020-02-15 Arizona 4 1 0
119 2020-02-15 Massachusetts 25 1 0
121 2020-02-15 Washington 53 1 0
122 2020-02-15 Wisconsin 55 1 0
123 2020-02-16 Arizona 4 1 0
126 2020-02-16 Massachusetts 25 1 0
128 2020-02-16 Washington 53 1 0
129 2020-02-16 Wisconsin 55 1 0
130 2020-02-17 Arizona 4 1 0
133 2020-02-17 Massachusetts 25 1 0
136 2020-02-17 Washington 53 1 0
137 2020-02-17 Wisconsin 55 1 0
138 2020-02-18 Arizona 4 1 0
141 2020-02-18 Massachusetts 25 1 0
144 2020-02-18 Washington 53 1 0
145 2020-02-18 Wisconsin 55 1 0
146 2020-02-19 Arizona 4 1 0
149 2020-02-19 Massachusetts 25 1 0
152 2020-02-19 Washington 53 1 0
153 2020-02-19 Wisconsin 55 1 0
154 2020-02-20 Arizona 4 1 0
157 2020-02-20 Massachusetts 25 1 0
160 2020-02-20 Washington 53 1 0
161 2020-02-20 Wisconsin 55 1 0