us-states

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.

Data source: Big Local News · About: README

3,864 rows

View and edit SQL

Suggested facets: date (date), downloaded_by_bln (date)

Link rowid ▼ date state fips cases deaths downloaded_by_bln
1 2020-01-21 Washington 53 1 0 2020-05-13T05:15:19+00:00
2 2020-01-22 Washington 53 1 0 2020-05-13T05:15:19+00:00
3 2020-01-23 Washington 53 1 0 2020-05-13T05:15:19+00:00
4 2020-01-24 Illinois 17 1 0 2020-05-13T05:15:19+00:00
5 2020-01-24 Washington 53 1 0 2020-05-13T05:15:19+00:00
6 2020-01-25 California 6 1 0 2020-05-13T05:15:19+00:00
7 2020-01-25 Illinois 17 1 0 2020-05-13T05:15:19+00:00
8 2020-01-25 Washington 53 1 0 2020-05-13T05:15:19+00:00
9 2020-01-26 Arizona 4 1 0 2020-05-13T05:15:19+00:00
10 2020-01-26 California 6 2 0 2020-05-13T05:15:19+00:00
11 2020-01-26 Illinois 17 1 0 2020-05-13T05:15:19+00:00
12 2020-01-26 Washington 53 1 0 2020-05-13T05:15:19+00:00
13 2020-01-27 Arizona 4 1 0 2020-05-13T05:15:19+00:00
14 2020-01-27 California 6 2 0 2020-05-13T05:15:19+00:00
15 2020-01-27 Illinois 17 1 0 2020-05-13T05:15:19+00:00
16 2020-01-27 Washington 53 1 0 2020-05-13T05:15:19+00:00
17 2020-01-28 Arizona 4 1 0 2020-05-13T05:15:19+00:00
18 2020-01-28 California 6 2 0 2020-05-13T05:15:19+00:00
19 2020-01-28 Illinois 17 1 0 2020-05-13T05:15:19+00:00
20 2020-01-28 Washington 53 1 0 2020-05-13T05:15:19+00:00
21 2020-01-29 Arizona 4 1 0 2020-05-13T05:15:19+00:00
22 2020-01-29 California 6 2 0 2020-05-13T05:15:19+00:00
23 2020-01-29 Illinois 17 1 0 2020-05-13T05:15:19+00:00
24 2020-01-29 Washington 53 1 0 2020-05-13T05:15:19+00:00
25 2020-01-30 Arizona 4 1 0 2020-05-13T05:15:19+00:00
26 2020-01-30 California 6 2 0 2020-05-13T05:15:19+00:00
27 2020-01-30 Illinois 17 2 0 2020-05-13T05:15:19+00:00
28 2020-01-30 Washington 53 1 0 2020-05-13T05:15:19+00:00
29 2020-01-31 Arizona 4 1 0 2020-05-13T05:15:19+00:00
30 2020-01-31 California 6 3 0 2020-05-13T05:15:19+00:00
31 2020-01-31 Illinois 17 2 0 2020-05-13T05:15:19+00:00
32 2020-01-31 Washington 53 1 0 2020-05-13T05:15:19+00:00
33 2020-02-01 Arizona 4 1 0 2020-05-13T05:15:19+00:00
34 2020-02-01 California 6 3 0 2020-05-13T05:15:19+00:00
35 2020-02-01 Illinois 17 2 0 2020-05-13T05:15:19+00:00
36 2020-02-01 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
37 2020-02-01 Washington 53 1 0 2020-05-13T05:15:19+00:00
38 2020-02-02 Arizona 4 1 0 2020-05-13T05:15:19+00:00
39 2020-02-02 California 6 6 0 2020-05-13T05:15:19+00:00
40 2020-02-02 Illinois 17 2 0 2020-05-13T05:15:19+00:00
41 2020-02-02 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
42 2020-02-02 Washington 53 1 0 2020-05-13T05:15:19+00:00
43 2020-02-03 Arizona 4 1 0 2020-05-13T05:15:19+00:00
44 2020-02-03 California 6 6 0 2020-05-13T05:15:19+00:00
45 2020-02-03 Illinois 17 2 0 2020-05-13T05:15:19+00:00
46 2020-02-03 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
47 2020-02-03 Washington 53 1 0 2020-05-13T05:15:19+00:00
48 2020-02-04 Arizona 4 1 0 2020-05-13T05:15:19+00:00
49 2020-02-04 California 6 6 0 2020-05-13T05:15:19+00:00
50 2020-02-04 Illinois 17 2 0 2020-05-13T05:15:19+00:00
51 2020-02-04 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
52 2020-02-04 Washington 53 1 0 2020-05-13T05:15:19+00:00
53 2020-02-05 Arizona 4 1 0 2020-05-13T05:15:19+00:00
54 2020-02-05 California 6 6 0 2020-05-13T05:15:19+00:00
55 2020-02-05 Illinois 17 2 0 2020-05-13T05:15:19+00:00
56 2020-02-05 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
57 2020-02-05 Washington 53 1 0 2020-05-13T05:15:19+00:00
58 2020-02-05 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
59 2020-02-06 Arizona 4 1 0 2020-05-13T05:15:19+00:00
60 2020-02-06 California 6 6 0 2020-05-13T05:15:19+00:00
61 2020-02-06 Illinois 17 2 0 2020-05-13T05:15:19+00:00
62 2020-02-06 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
63 2020-02-06 Washington 53 1 0 2020-05-13T05:15:19+00:00
64 2020-02-06 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
65 2020-02-07 Arizona 4 1 0 2020-05-13T05:15:19+00:00
66 2020-02-07 California 6 6 0 2020-05-13T05:15:19+00:00
67 2020-02-07 Illinois 17 2 0 2020-05-13T05:15:19+00:00
68 2020-02-07 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
69 2020-02-07 Washington 53 1 0 2020-05-13T05:15:19+00:00
70 2020-02-07 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
71 2020-02-08 Arizona 4 1 0 2020-05-13T05:15:19+00:00
72 2020-02-08 California 6 6 0 2020-05-13T05:15:19+00:00
73 2020-02-08 Illinois 17 2 0 2020-05-13T05:15:19+00:00
74 2020-02-08 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
75 2020-02-08 Washington 53 1 0 2020-05-13T05:15:19+00:00
76 2020-02-08 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
77 2020-02-09 Arizona 4 1 0 2020-05-13T05:15:19+00:00
78 2020-02-09 California 6 6 0 2020-05-13T05:15:19+00:00
79 2020-02-09 Illinois 17 2 0 2020-05-13T05:15:19+00:00
80 2020-02-09 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
81 2020-02-09 Washington 53 1 0 2020-05-13T05:15:19+00:00
82 2020-02-09 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
83 2020-02-10 Arizona 4 1 0 2020-05-13T05:15:19+00:00
84 2020-02-10 California 6 7 0 2020-05-13T05:15:19+00:00
85 2020-02-10 Illinois 17 2 0 2020-05-13T05:15:19+00:00
86 2020-02-10 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
87 2020-02-10 Washington 53 1 0 2020-05-13T05:15:19+00:00
88 2020-02-10 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
89 2020-02-11 Arizona 4 1 0 2020-05-13T05:15:19+00:00
90 2020-02-11 California 6 7 0 2020-05-13T05:15:19+00:00
91 2020-02-11 Illinois 17 2 0 2020-05-13T05:15:19+00:00
92 2020-02-11 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
93 2020-02-11 Washington 53 1 0 2020-05-13T05:15:19+00:00
94 2020-02-11 Wisconsin 55 1 0 2020-05-13T05:15:19+00:00
95 2020-02-12 Arizona 4 1 0 2020-05-13T05:15:19+00:00
96 2020-02-12 California 6 7 0 2020-05-13T05:15:19+00:00
97 2020-02-12 Illinois 17 2 0 2020-05-13T05:15:19+00:00
98 2020-02-12 Massachusetts 25 1 0 2020-05-13T05:15:19+00:00
99 2020-02-12 Texas 48 1 0 2020-05-13T05:15:19+00:00
100 2020-02-12 Washington 53 1 0 2020-05-13T05:15:19+00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [us-states] (
   [date] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER,
   [downloaded_by_bln] TEXT
);
Powered by Datasette · Query took 47.552ms · Data source: Big Local News · About: README