New_York_Times_COVID_data: us-states: 19,979 rows

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

19,979 rows

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link	rowid ▼	date	state	fips	cases
101	101	2020-02-12	Wisconsin	55	1
102	102	2020-02-13	Arizona	4	1
103	103	2020-02-13	California	6	7
104	104	2020-02-13	Illinois	17	2
105	105	2020-02-13	Massachusetts	25	1
106	106	2020-02-13	Texas	48	2
107	107	2020-02-13	Washington	53	1
108	108	2020-02-13	Wisconsin	55	1
109	109	2020-02-14	Arizona	4	1
110	110	2020-02-14	California	6	7
111	111	2020-02-14	Illinois	17	2
112	112	2020-02-14	Massachusetts	25	1
113	113	2020-02-14	Texas	48	2
114	114	2020-02-14	Washington	53	1
115	115	2020-02-14	Wisconsin	55	1
116	116	2020-02-15	Arizona	4	1
117	117	2020-02-15	California	6	7
118	118	2020-02-15	Illinois	17	2
119	119	2020-02-15	Massachusetts	25	1
120	120	2020-02-15	Texas	48	2
121	121	2020-02-15	Washington	53	1
122	122	2020-02-15	Wisconsin	55	1
123	123	2020-02-16	Arizona	4	1
124	124	2020-02-16	California	6	7
125	125	2020-02-16	Illinois	17	2
126	126	2020-02-16	Massachusetts	25	1
127	127	2020-02-16	Texas	48	2
128	128	2020-02-16	Washington	53	1
129	129	2020-02-16	Wisconsin	55	1
130	130	2020-02-17	Arizona	4	1
131	131	2020-02-17	California	6	7
132	132	2020-02-17	Illinois	17	2
133	133	2020-02-17	Massachusetts	25	1
134	134	2020-02-17	Nebraska	31	10
135	135	2020-02-17	Texas	48	2
136	136	2020-02-17	Washington	53	1
137	137	2020-02-17	Wisconsin	55	1
138	138	2020-02-18	Arizona	4	1
139	139	2020-02-18	California	6	7
140	140	2020-02-18	Illinois	17	2
141	141	2020-02-18	Massachusetts	25	1
142	142	2020-02-18	Nebraska	31	10
143	143	2020-02-18	Texas	48	2
144	144	2020-02-18	Washington	53	1
145	145	2020-02-18	Wisconsin	55	1
146	146	2020-02-19	Arizona	4	1
147	147	2020-02-19	California	6	7
148	148	2020-02-19	Illinois	17	2
149	149	2020-02-19	Massachusetts	25	1
150	150	2020-02-19	Nebraska	31	10
151	151	2020-02-19	Texas	48	2
152	152	2020-02-19	Washington	53	1
153	153	2020-02-19	Wisconsin	55	1
154	154	2020-02-20	Arizona	4	1
155	155	2020-02-20	California	6	8
156	156	2020-02-20	Illinois	17	2
157	157	2020-02-20	Massachusetts	25	1
158	158	2020-02-20	Nebraska	31	11
159	159	2020-02-20	Texas	48	2
160	160	2020-02-20	Washington	53	1
161	161	2020-02-20	Wisconsin	55	1
162	162	2020-02-21	Arizona	4	1
163	163	2020-02-21	California	6	9
164	164	2020-02-21	Illinois	17	2
165	165	2020-02-21	Massachusetts	25	1
166	166	2020-02-21	Nebraska	31	11
167	167	2020-02-21	Texas	48	4
168	168	2020-02-21	Washington	53	1
169	169	2020-02-21	Wisconsin	55	1
170	170	2020-02-22	Arizona	4	1
171	171	2020-02-22	California	6	9
172	172	2020-02-22	Illinois	17	2
173	173	2020-02-22	Massachusetts	25	1
174	174	2020-02-22	Nebraska	31	11
175	175	2020-02-22	Texas	48	4
176	176	2020-02-22	Washington	53	1
177	177	2020-02-22	Wisconsin	55	1
178	178	2020-02-23	Arizona	4	1
179	179	2020-02-23	California	6	9
180	180	2020-02-23	Illinois	17	2
181	181	2020-02-23	Massachusetts	25	1
182	182	2020-02-23	Nebraska	31	11
183	183	2020-02-23	Texas	48	4
184	184	2020-02-23	Washington	53	1
185	185	2020-02-23	Wisconsin	55	1
186	186	2020-02-24	Arizona	4	1
187	187	2020-02-24	California	6	11
188	188	2020-02-24	Illinois	17	2
189	189	2020-02-24	Massachusetts	25	1
190	190	2020-02-24	Nebraska	31	12
191	191	2020-02-24	Texas	48	10
192	192	2020-02-24	Washington	53	5
193	193	2020-02-24	Wisconsin	55	1
194	194	2020-02-25	Arizona	4	1
195	195	2020-02-25	California	6	11
196	196	2020-02-25	Illinois	17	2
197	197	2020-02-25	Massachusetts	25	1
198	198	2020-02-25	Nebraska	31	13
199	199	2020-02-25	Texas	48	10
200	200	2020-02-25	Utah	49	1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);