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 state

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date county state ▼ fips cases deaths
1 1 2021-01-31 Autauga Alabama 1001 5669 69
2 2 2021-01-31 Baldwin Alabama 1003 18126 224
3 3 2021-01-31 Barbour Alabama 1005 1951 40
4 4 2021-01-31 Bibb Alabama 1007 2307 52
5 5 2021-01-31 Blount Alabama 1009 5713 100
6 6 2021-01-31 Bullock Alabama 1011 1086 29
7 7 2021-01-31 Butler Alabama 1013 1812 60
8 8 2021-01-31 Calhoun Alabama 1015 12011 232
9 9 2021-01-31 Chambers Alabama 1017 3203 76
10 10 2021-01-31 Cherokee Alabama 1019 1704 35
11 11 2021-01-31 Chilton Alabama 1021 3544 79
12 12 2021-01-31 Choctaw Alabama 1023 535 24
13 13 2021-01-31 Clarke Alabama 1025 3227 38
14 14 2021-01-31 Clay Alabama 1027 1328 50
15 15 2021-01-31 Cleburne Alabama 1029 1281 28
16 16 2021-01-31 Coffee Alabama 1031 4915 72
17 17 2021-01-31 Colbert Alabama 1033 5736 104
18 18 2021-01-31 Conecuh Alabama 1035 1007 23
19 19 2021-01-31 Coosa Alabama 1037 678 19
20 20 2021-01-31 Covington Alabama 1039 3581 87
21 21 2021-01-31 Crenshaw Alabama 1041 1312 48
22 22 2021-01-31 Cullman Alabama 1043 8551 149
23 23 2021-01-31 Dale Alabama 1045 4290 98
24 24 2021-01-31 Dallas Alabama 1047 3224 111
25 25 2021-01-31 DeKalb Alabama 1049 8133 137
26 26 2021-01-31 Elmore Alabama 1051 8602 134
27 27 2021-01-31 Escambia Alabama 1053 3523 48
28 28 2021-01-31 Etowah Alabama 1055 12515 246
29 29 2021-01-31 Fayette Alabama 1057 1856 38
30 30 2021-01-31 Franklin Alabama 1059 3842 60
31 31 2021-01-31 Geneva Alabama 1061 2258 52
32 32 2021-01-31 Greene Alabama 1063 801 27
33 33 2021-01-31 Hale Alabama 1065 1958 54
34 34 2021-01-31 Henry Alabama 1067 1675 32
35 35 2021-01-31 Houston Alabama 1069 9471 209
36 36 2021-01-31 Jackson Alabama 1071 6245 70
37 37 2021-01-31 Jefferson Alabama 1073 66884 1128
38 38 2021-01-31 Lamar Alabama 1075 1248 28
39 39 2021-01-31 Lauderdale Alabama 1077 8180 156
40 40 2021-01-31 Lawrence Alabama 1079 2647 70
41 41 2021-01-31 Lee Alabama 1081 13829 128
42 42 2021-01-31 Limestone Alabama 1083 8676 106
43 43 2021-01-31 Lowndes Alabama 1085 1232 39
44 44 2021-01-31 Macon Alabama 1087 1288 38
45 45 2021-01-31 Madison Alabama 1089 29680 287
46 46 2021-01-31 Marengo Alabama 1091 2188 34
47 47 2021-01-31 Marion Alabama 1093 2613 74
48 48 2021-01-31 Marshall Alabama 1095 10780 152
49 49 2021-01-31 Mobile Alabama 1097 33060 611
50 50 2021-01-31 Monroe Alabama 1099 1569 22
51 51 2021-01-31 Montgomery Alabama 1101 20921 370
52 52 2021-01-31 Morgan Alabama 1103 13001 175
53 53 2021-01-31 Perry Alabama 1105 1027 20
54 54 2021-01-31 Pickens Alabama 1107 2095 33
55 55 2021-01-31 Pike Alabama 1109 2746 41
56 56 2021-01-31 Randolph Alabama 1111 1518 37
57 57 2021-01-31 Russell Alabama 1113 3751 19
58 58 2021-01-31 Shelby Alabama 1117 20216 160
59 59 2021-01-31 St. Clair Alabama 1115 8159 155
60 60 2021-01-31 Sumter Alabama 1119 930 28
61 61 2021-01-31 Talladega Alabama 1121 6837 117
62 62 2021-01-31 Tallapoosa Alabama 1123 3325 114
63 63 2021-01-31 Tuscaloosa Alabama 1125 22421 302
64 64 2021-01-31 Walker Alabama 1127 6158 197
65 65 2021-01-31 Washington Alabama 1129 1474 27
66 66 2021-01-31 Wilcox Alabama 1131 1137 22
67 67 2021-01-31 Winston Alabama 1133 2379 44
3248 3248 2021-02-01 Autauga Alabama 1001 5683 69
3249 3249 2021-02-01 Baldwin Alabama 1003 18211 224
3250 3250 2021-02-01 Barbour Alabama 1005 1956 40
3251 3251 2021-02-01 Bibb Alabama 1007 2309 52
3252 3252 2021-02-01 Blount Alabama 1009 5720 100
3253 3253 2021-02-01 Bullock Alabama 1011 1089 29
3254 3254 2021-02-01 Butler Alabama 1013 1827 60
3255 3255 2021-02-01 Calhoun Alabama 1015 12062 232
3256 3256 2021-02-01 Chambers Alabama 1017 3210 76
3257 3257 2021-02-01 Cherokee Alabama 1019 1707 35
3258 3258 2021-02-01 Chilton Alabama 1021 3553 79
3259 3259 2021-02-01 Choctaw Alabama 1023 535 24
3260 3260 2021-02-01 Clarke Alabama 1025 3228 38
3261 3261 2021-02-01 Clay Alabama 1027 1330 50
3262 3262 2021-02-01 Cleburne Alabama 1029 1286 28
3263 3263 2021-02-01 Coffee Alabama 1031 4922 72
3264 3264 2021-02-01 Colbert Alabama 1033 5745 104
3265 3265 2021-02-01 Conecuh Alabama 1035 1010 23
3266 3266 2021-02-01 Coosa Alabama 1037 681 19
3267 3267 2021-02-01 Covington Alabama 1039 3589 87
3268 3268 2021-02-01 Crenshaw Alabama 1041 1313 48
3269 3269 2021-02-01 Cullman Alabama 1043 8574 149
3270 3270 2021-02-01 Dale Alabama 1045 4310 98
3271 3271 2021-02-01 Dallas Alabama 1047 3228 111
3272 3272 2021-02-01 DeKalb Alabama 1049 8139 137
3273 3273 2021-02-01 Elmore Alabama 1051 8640 134
3274 3274 2021-02-01 Escambia Alabama 1053 3548 48
3275 3275 2021-02-01 Etowah Alabama 1055 12550 246
3276 3276 2021-02-01 Fayette Alabama 1057 1858 38
3277 3277 2021-02-01 Franklin Alabama 1059 3846 60
3278 3278 2021-02-01 Geneva Alabama 1061 2266 52
3279 3279 2021-02-01 Greene Alabama 1063 806 27
3280 3280 2021-02-01 Hale Alabama 1065 1961 54

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
);