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)

This data as json, copyable, CSV

rowiddatecountystatefipscasesdeaths
1 2020-01-21 Snohomish Washington 53061 1 0
2 2020-01-22 Snohomish Washington 53061 1 0
3 2020-01-23 Snohomish Washington 53061 1 0
4 2020-01-24 Cook Illinois 17031 1 0
5 2020-01-24 Snohomish Washington 53061 1 0
6 2020-01-25 Orange California 6059 1 0
7 2020-01-25 Cook Illinois 17031 1 0
8 2020-01-25 Snohomish Washington 53061 1 0
9 2020-01-26 Maricopa Arizona 4013 1 0
10 2020-01-26 Los Angeles California 6037 1 0
11 2020-01-26 Orange California 6059 1 0
12 2020-01-26 Cook Illinois 17031 1 0
13 2020-01-26 Snohomish Washington 53061 1 0
14 2020-01-27 Maricopa Arizona 4013 1 0
15 2020-01-27 Los Angeles California 6037 1 0
16 2020-01-27 Orange California 6059 1 0
17 2020-01-27 Cook Illinois 17031 1 0
18 2020-01-27 Snohomish Washington 53061 1 0
19 2020-01-28 Maricopa Arizona 4013 1 0
20 2020-01-28 Los Angeles California 6037 1 0
21 2020-01-28 Orange California 6059 1 0
22 2020-01-28 Cook Illinois 17031 1 0
23 2020-01-28 Snohomish Washington 53061 1 0
24 2020-01-29 Maricopa Arizona 4013 1 0
25 2020-01-29 Los Angeles California 6037 1 0
26 2020-01-29 Orange California 6059 1 0
27 2020-01-29 Cook Illinois 17031 1 0
28 2020-01-29 Snohomish Washington 53061 1 0
29 2020-01-30 Maricopa Arizona 4013 1 0
30 2020-01-30 Los Angeles California 6037 1 0
31 2020-01-30 Orange California 6059 1 0
32 2020-01-30 Cook Illinois 17031 2 0
33 2020-01-30 Snohomish Washington 53061 1 0
34 2020-01-31 Maricopa Arizona 4013 1 0
35 2020-01-31 Los Angeles California 6037 1 0
36 2020-01-31 Orange California 6059 1 0
37 2020-01-31 Santa Clara California 6085 1 0
38 2020-01-31 Cook Illinois 17031 2 0
39 2020-01-31 Snohomish Washington 53061 1 0
40 2020-02-01 Maricopa Arizona 4013 1 0
41 2020-02-01 Los Angeles California 6037 1 0
42 2020-02-01 Orange California 6059 1 0
43 2020-02-01 Santa Clara California 6085 1 0
44 2020-02-01 Cook Illinois 17031 2 0
45 2020-02-01 Suffolk Massachusetts 25025 1 0
46 2020-02-01 Snohomish Washington 53061 1 0
47 2020-02-02 Maricopa Arizona 4013 1 0
48 2020-02-02 Los Angeles California 6037 1 0
49 2020-02-02 Orange California 6059 1 0
50 2020-02-02 San Francisco California 6075 2 0
51 2020-02-02 Santa Clara California 6085 2 0
52 2020-02-02 Cook Illinois 17031 2 0
53 2020-02-02 Suffolk Massachusetts 25025 1 0
54 2020-02-02 Snohomish Washington 53061 1 0
55 2020-02-03 Maricopa Arizona 4013 1 0
56 2020-02-03 Los Angeles California 6037 1 0
57 2020-02-03 Orange California 6059 1 0
58 2020-02-03 San Francisco California 6075 2 0
59 2020-02-03 Santa Clara California 6085 2 0
60 2020-02-03 Cook Illinois 17031 2 0
61 2020-02-03 Suffolk Massachusetts 25025 1 0
62 2020-02-03 Snohomish Washington 53061 1 0
63 2020-02-04 Maricopa Arizona 4013 1 0
64 2020-02-04 Los Angeles California 6037 1 0
65 2020-02-04 Orange California 6059 1 0
66 2020-02-04 San Francisco California 6075 2 0
67 2020-02-04 Santa Clara California 6085 2 0
68 2020-02-04 Cook Illinois 17031 2 0
69 2020-02-04 Suffolk Massachusetts 25025 1 0
70 2020-02-04 Snohomish Washington 53061 1 0
71 2020-02-05 Maricopa Arizona 4013 1 0
72 2020-02-05 Los Angeles California 6037 1 0
73 2020-02-05 Orange California 6059 1 0
74 2020-02-05 San Francisco California 6075 2 0
75 2020-02-05 Santa Clara California 6085 2 0
76 2020-02-05 Cook Illinois 17031 2 0
77 2020-02-05 Suffolk Massachusetts 25025 1 0
78 2020-02-05 Snohomish Washington 53061 1 0
79 2020-02-05 Dane Wisconsin 55025 1 0
80 2020-02-06 Maricopa Arizona 4013 1 0
81 2020-02-06 Los Angeles California 6037 1 0
82 2020-02-06 Orange California 6059 1 0
83 2020-02-06 San Francisco California 6075 2 0
84 2020-02-06 Santa Clara California 6085 2 0
85 2020-02-06 Cook Illinois 17031 2 0
86 2020-02-06 Suffolk Massachusetts 25025 1 0
87 2020-02-06 Snohomish Washington 53061 1 0
88 2020-02-06 Dane Wisconsin 55025 1 0
89 2020-02-07 Maricopa Arizona 4013 1 0
90 2020-02-07 Los Angeles California 6037 1 0
91 2020-02-07 Orange California 6059 1 0
92 2020-02-07 San Francisco California 6075 2 0
93 2020-02-07 Santa Clara California 6085 2 0
94 2020-02-07 Cook Illinois 17031 2 0
95 2020-02-07 Suffolk Massachusetts 25025 1 0
96 2020-02-07 Snohomish Washington 53061 1 0
97 2020-02-07 Dane Wisconsin 55025 1 0
98 2020-02-08 Maricopa Arizona 4013 1 0
99 2020-02-08 Los Angeles California 6037 1 0
100 2020-02-08 Orange California 6059 1 0
101 2020-02-08 San Francisco California 6075 2 0