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

This data as json, copyable, CSV

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

New_York_Times_COVID_data

Custom SQL query returning 101 rows (hide)