New_York_Times_COVID_data: us-states: 19,979 rows where sorted by cases

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 sorted by cases

descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

Advanced export

JSON shape: default, array, newline-delimited

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