us

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

112 rows

View and edit SQL

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

Link rowid ▼ date cases deaths downloaded_by_bln
1 2020-01-21 1 0 2020-05-13T05:15:19+00:00
2 2020-01-22 1 0 2020-05-13T05:15:19+00:00
3 2020-01-23 1 0 2020-05-13T05:15:19+00:00
4 2020-01-24 2 0 2020-05-13T05:15:19+00:00
5 2020-01-25 3 0 2020-05-13T05:15:19+00:00
6 2020-01-26 5 0 2020-05-13T05:15:19+00:00
7 2020-01-27 5 0 2020-05-13T05:15:19+00:00
8 2020-01-28 5 0 2020-05-13T05:15:19+00:00
9 2020-01-29 5 0 2020-05-13T05:15:19+00:00
10 2020-01-30 6 0 2020-05-13T05:15:19+00:00
11 2020-01-31 7 0 2020-05-13T05:15:19+00:00
12 2020-02-01 8 0 2020-05-13T05:15:19+00:00
13 2020-02-02 11 0 2020-05-13T05:15:19+00:00
14 2020-02-03 11 0 2020-05-13T05:15:19+00:00
15 2020-02-04 11 0 2020-05-13T05:15:19+00:00
16 2020-02-05 12 0 2020-05-13T05:15:19+00:00
17 2020-02-06 12 0 2020-05-13T05:15:19+00:00
18 2020-02-07 12 0 2020-05-13T05:15:19+00:00
19 2020-02-08 12 0 2020-05-13T05:15:19+00:00
20 2020-02-09 12 0 2020-05-13T05:15:19+00:00
21 2020-02-10 13 0 2020-05-13T05:15:19+00:00
22 2020-02-11 13 0 2020-05-13T05:15:19+00:00
23 2020-02-12 14 0 2020-05-13T05:15:19+00:00
24 2020-02-13 15 0 2020-05-13T05:15:19+00:00
25 2020-02-14 15 0 2020-05-13T05:15:19+00:00
26 2020-02-15 15 0 2020-05-13T05:15:19+00:00
27 2020-02-16 15 0 2020-05-13T05:15:19+00:00
28 2020-02-17 25 0 2020-05-13T05:15:19+00:00
29 2020-02-18 25 0 2020-05-13T05:15:19+00:00
30 2020-02-19 25 0 2020-05-13T05:15:19+00:00
31 2020-02-20 27 0 2020-05-13T05:15:19+00:00
32 2020-02-21 30 0 2020-05-13T05:15:19+00:00
33 2020-02-22 30 0 2020-05-13T05:15:19+00:00
34 2020-02-23 30 0 2020-05-13T05:15:19+00:00
35 2020-02-24 43 0 2020-05-13T05:15:19+00:00
36 2020-02-25 45 0 2020-05-13T05:15:19+00:00
37 2020-02-26 60 0 2020-05-13T05:15:19+00:00
38 2020-02-27 60 0 2020-05-13T05:15:19+00:00
39 2020-02-28 65 0 2020-05-13T05:15:19+00:00
40 2020-02-29 70 1 2020-05-13T05:15:19+00:00
41 2020-03-01 88 3 2020-05-13T05:15:19+00:00
42 2020-03-02 104 6 2020-05-13T05:15:19+00:00
43 2020-03-03 125 10 2020-05-13T05:15:19+00:00
44 2020-03-04 161 12 2020-05-13T05:15:19+00:00
45 2020-03-05 228 12 2020-05-13T05:15:19+00:00
46 2020-03-06 311 15 2020-05-13T05:15:19+00:00
47 2020-03-07 428 19 2020-05-13T05:15:19+00:00
48 2020-03-08 547 22 2020-05-13T05:15:19+00:00
49 2020-03-09 748 26 2020-05-13T05:15:19+00:00
50 2020-03-10 1018 31 2020-05-13T05:15:19+00:00
51 2020-03-11 1263 37 2020-05-13T05:15:19+00:00
52 2020-03-12 1668 43 2020-05-13T05:15:19+00:00
53 2020-03-13 2224 50 2020-05-13T05:15:19+00:00
54 2020-03-14 2898 60 2020-05-13T05:15:19+00:00
55 2020-03-15 3600 68 2020-05-13T05:15:19+00:00
56 2020-03-16 4507 91 2020-05-13T05:15:19+00:00
57 2020-03-17 5906 117 2020-05-13T05:15:19+00:00
58 2020-03-18 8350 162 2020-05-13T05:15:19+00:00
59 2020-03-19 12393 212 2020-05-13T05:15:19+00:00
60 2020-03-20 18001 275 2020-05-13T05:15:19+00:00
61 2020-03-21 24526 358 2020-05-13T05:15:19+00:00
62 2020-03-22 33063 455 2020-05-13T05:15:19+00:00
63 2020-03-23 43500 574 2020-05-13T05:15:19+00:00
64 2020-03-24 53924 769 2020-05-13T05:15:19+00:00
65 2020-03-25 68530 1039 2020-05-13T05:15:19+00:00
66 2020-03-26 85558 1345 2020-05-13T05:15:19+00:00
67 2020-03-27 102829 1758 2020-05-13T05:15:19+00:00
68 2020-03-28 123723 2287 2020-05-13T05:15:19+00:00
69 2020-03-29 142397 2702 2020-05-13T05:15:19+00:00
70 2020-03-30 163863 3356 2020-05-13T05:15:19+00:00
71 2020-03-31 188413 4290 2020-05-13T05:15:19+00:00
72 2020-04-01 215161 5315 2020-05-13T05:15:19+00:00
73 2020-04-02 244619 6542 2020-05-13T05:15:19+00:00
74 2020-04-03 277262 7902 2020-05-13T05:15:19+00:00
75 2020-04-04 312497 9466 2020-05-13T05:15:19+00:00
76 2020-04-05 337955 10828 2020-05-13T05:15:19+00:00
77 2020-04-06 367567 12330 2020-05-13T05:15:19+00:00
78 2020-04-07 399352 14579 2020-05-13T05:15:19+00:00
79 2020-04-08 431169 16673 2020-05-13T05:15:19+00:00
80 2020-04-09 465846 18772 2020-05-13T05:15:19+00:00
81 2020-04-10 499297 21028 2020-05-13T05:15:19+00:00
82 2020-04-11 531011 23105 2020-05-13T05:15:19+00:00
83 2020-04-12 558150 24785 2020-05-13T05:15:19+00:00
84 2020-04-13 583894 26547 2020-05-13T05:15:19+00:00
85 2020-04-14 610541 29246 2020-05-13T05:15:19+00:00
86 2020-04-15 640557 31994 2020-05-13T05:15:19+00:00
87 2020-04-16 672162 34264 2020-05-13T05:15:19+00:00
88 2020-04-17 703651 36626 2020-05-13T05:15:19+00:00
89 2020-04-18 732031 38571 2020-05-13T05:15:19+00:00
90 2020-04-19 757385 40089 2020-05-13T05:15:19+00:00
91 2020-04-20 784664 41919 2020-05-13T05:15:19+00:00
92 2020-04-21 810143 44587 2020-05-13T05:15:19+00:00
93 2020-04-22 838845 46897 2020-05-13T05:15:19+00:00
94 2020-04-23 872631 49065 2020-05-13T05:15:19+00:00
95 2020-04-24 909471 51192 2020-05-13T05:15:19+00:00
96 2020-04-25 943743 53152 2020-05-13T05:15:19+00:00
97 2020-04-26 970350 54407 2020-05-13T05:15:19+00:00
98 2020-04-27 993704 55980 2020-05-13T05:15:19+00:00
99 2020-04-28 1018356 58374 2020-05-13T05:15:19+00:00
100 2020-04-29 1045059 60888 2020-05-13T05:15:19+00:00

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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