us-counties-recent

Table actions
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

94,127 rows sorted by county

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county ▼ state fips cases deaths
2416 2416 2021-01-31 Abbeville South Carolina 45001 1843 29
5663 5663 2021-02-01 Abbeville South Carolina 45001 1848 29
8909 8909 2021-02-02 Abbeville South Carolina 45001 1856 30
12155 12155 2021-02-03 Abbeville South Carolina 45001 1873 31
15401 15401 2021-02-04 Abbeville South Carolina 45001 1887 31
18647 18647 2021-02-05 Abbeville South Carolina 45001 1948 31
21893 21893 2021-02-06 Abbeville South Carolina 45001 1972 31
25139 25139 2021-02-07 Abbeville South Carolina 45001 1989 31
28385 28385 2021-02-08 Abbeville South Carolina 45001 2002 31
31630 31630 2021-02-09 Abbeville South Carolina 45001 2008 31
34875 34875 2021-02-10 Abbeville South Carolina 45001 2024 32
38120 38120 2021-02-11 Abbeville South Carolina 45001 2045 32
41365 41365 2021-02-12 Abbeville South Carolina 45001 2067 32
44610 44610 2021-02-13 Abbeville South Carolina 45001 2097 32
47857 47857 2021-02-14 Abbeville South Carolina 45001 2117 34
51103 51103 2021-02-15 Abbeville South Carolina 45001 2119 34
54348 54348 2021-02-16 Abbeville South Carolina 45001 2124 34
57593 57593 2021-02-17 Abbeville South Carolina 45001 2130 34
60838 60838 2021-02-18 Abbeville South Carolina 45001 2146 34
64083 64083 2021-02-19 Abbeville South Carolina 45001 2159 34
67330 67330 2021-02-20 Abbeville South Carolina 45001 2174 34
70577 70577 2021-02-21 Abbeville South Carolina 45001 2184 34
73823 73823 2021-02-22 Abbeville South Carolina 45001 2191 34
77069 77069 2021-02-23 Abbeville South Carolina 45001 2192 34
80314 80314 2021-02-24 Abbeville South Carolina 45001 2200 34
83559 83559 2021-02-25 Abbeville South Carolina 45001 2207 35
86804 86804 2021-02-26 Abbeville South Carolina 45001 2216 35
90050 90050 2021-02-27 Abbeville South Carolina 45001 2224 35
93296 93296 2021-02-28 Abbeville South Carolina 45001 2235 35
1122 1122 2021-01-31 Acadia Louisiana 22001 5809 177
4369 4369 2021-02-01 Acadia Louisiana 22001 5823 177
7616 7616 2021-02-02 Acadia Louisiana 22001 5849 177
10862 10862 2021-02-03 Acadia Louisiana 22001 5865 177
14108 14108 2021-02-04 Acadia Louisiana 22001 5881 177
17354 17354 2021-02-05 Acadia Louisiana 22001 5906 177
20600 20600 2021-02-06 Acadia Louisiana 22001 5906 177
23846 23846 2021-02-07 Acadia Louisiana 22001 5904 177
27092 27092 2021-02-08 Acadia Louisiana 22001 5910 177
30338 30338 2021-02-09 Acadia Louisiana 22001 5930 177
33583 33583 2021-02-10 Acadia Louisiana 22001 5935 177
36828 36828 2021-02-11 Acadia Louisiana 22001 5968 177
40073 40073 2021-02-12 Acadia Louisiana 22001 5982 177
43318 43318 2021-02-13 Acadia Louisiana 22001 5982 177
46563 46563 2021-02-14 Acadia Louisiana 22001 5989 178
49810 49810 2021-02-15 Acadia Louisiana 22001 5987 178
53056 53056 2021-02-16 Acadia Louisiana 22001 5987 178
56301 56301 2021-02-17 Acadia Louisiana 22001 5983 178
59546 59546 2021-02-18 Acadia Louisiana 22001 5993 181
62791 62791 2021-02-19 Acadia Louisiana 22001 5999 181
66036 66036 2021-02-20 Acadia Louisiana 22001 5999 181
69283 69283 2021-02-21 Acadia Louisiana 22001 6021 181
72530 72530 2021-02-22 Acadia Louisiana 22001 6025 182
75776 75776 2021-02-23 Acadia Louisiana 22001 6040 183
79022 79022 2021-02-24 Acadia Louisiana 22001 6057 183
82267 82267 2021-02-25 Acadia Louisiana 22001 6061 183
85512 85512 2021-02-26 Acadia Louisiana 22001 6054 185
88757 88757 2021-02-27 Acadia Louisiana 22001 6054 185
92003 92003 2021-02-28 Acadia Louisiana 22001 6077 185
2926 2926 2021-01-31 Accomack Virginia 51001 2342 31
6173 6173 2021-02-01 Accomack Virginia 51001 2365 31
9419 9419 2021-02-02 Accomack Virginia 51001 2388 32
12665 12665 2021-02-03 Accomack Virginia 51001 2391 32
15911 15911 2021-02-04 Accomack Virginia 51001 2403 32
19157 19157 2021-02-05 Accomack Virginia 51001 2428 32
22403 22403 2021-02-06 Accomack Virginia 51001 2448 33
25649 25649 2021-02-07 Accomack Virginia 51001 2457 33
28895 28895 2021-02-08 Accomack Virginia 51001 2461 33
32140 32140 2021-02-09 Accomack Virginia 51001 2467 33
35385 35385 2021-02-10 Accomack Virginia 51001 2473 33
38630 38630 2021-02-11 Accomack Virginia 51001 2485 33
41875 41875 2021-02-12 Accomack Virginia 51001 2506 33
45120 45120 2021-02-13 Accomack Virginia 51001 2516 33
48367 48367 2021-02-14 Accomack Virginia 51001 2519 33
51613 51613 2021-02-15 Accomack Virginia 51001 2523 33
54858 54858 2021-02-16 Accomack Virginia 51001 2527 34
58103 58103 2021-02-17 Accomack Virginia 51001 2529 34
61348 61348 2021-02-18 Accomack Virginia 51001 2538 35
64593 64593 2021-02-19 Accomack Virginia 51001 2545 35
67840 67840 2021-02-20 Accomack Virginia 51001 2552 35
71087 71087 2021-02-21 Accomack Virginia 51001 2559 35
74333 74333 2021-02-22 Accomack Virginia 51001 2565 35
77579 77579 2021-02-23 Accomack Virginia 51001 2572 35
80824 80824 2021-02-24 Accomack Virginia 51001 2575 35
84069 84069 2021-02-25 Accomack Virginia 51001 2580 35
87314 87314 2021-02-26 Accomack Virginia 51001 2588 35
90560 90560 2021-02-27 Accomack Virginia 51001 2596 35
93806 93806 2021-02-28 Accomack Virginia 51001 2602 35
557 557 2021-01-31 Ada Idaho 16001 44483 409
3804 3804 2021-02-01 Ada Idaho 16001 44620 413
7051 7051 2021-02-02 Ada Idaho 16001 44771 413
10297 10297 2021-02-03 Ada Idaho 16001 44889 414
13543 13543 2021-02-04 Ada Idaho 16001 45010 414
16789 16789 2021-02-05 Ada Idaho 16001 45095 416
20035 20035 2021-02-06 Ada Idaho 16001 45151 418
23281 23281 2021-02-07 Ada Idaho 16001 45151 418
26527 26527 2021-02-08 Ada Idaho 16001 45292 422
29773 29773 2021-02-09 Ada Idaho 16001 45391 422
33018 33018 2021-02-10 Ada Idaho 16001 45501 424
36263 36263 2021-02-11 Ada Idaho 16001 45615 424
39508 39508 2021-02-12 Ada Idaho 16001 45720 426

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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