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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▼ date county state fips cases deaths
101 101 2021-01-31 Greenlee Arizona 4011 523 6
102 102 2021-01-31 La Paz Arizona 4012 2247 58
103 103 2021-01-31 Maricopa Arizona 4013 472760 7462
104 104 2021-01-31 Mohave Arizona 4015 19395 519
105 105 2021-01-31 Navajo Arizona 4017 14482 429
106 106 2021-01-31 Pima Arizona 4019 101457 1740
107 107 2021-01-31 Pinal Arizona 4021 42322 612
108 108 2021-01-31 Santa Cruz Arizona 4023 7428 149
109 109 2021-01-31 Yavapai Arizona 4025 16408 381
110 110 2021-01-31 Yuma Arizona 4027 35127 697
111 111 2021-01-31 Arkansas Arkansas 5001 1774 36
112 112 2021-01-31 Ashley Arkansas 5003 1640 27
113 113 2021-01-31 Baxter Arkansas 5005 2635 95
114 114 2021-01-31 Benton Arkansas 5007 25105 348
115 115 2021-01-31 Boone Arkansas 5009 3334 74
116 116 2021-01-31 Bradley Arkansas 5011 1250 29
117 117 2021-01-31 Calhoun Arkansas 5013 346 2
118 118 2021-01-31 Carroll Arkansas 5015 2580 39
119 119 2021-01-31 Chicot Arkansas 5017 1551 38
120 120 2021-01-31 Clark Arkansas 5019 1837 34
121 121 2021-01-31 Clay Arkansas 5021 1564 42
122 122 2021-01-31 Cleburne Arkansas 5023 1761 59
123 123 2021-01-31 Cleveland Arkansas 5025 796 23
124 124 2021-01-31 Columbia Arkansas 5027 1930 50
125 125 2021-01-31 Conway Arkansas 5029 1983 27
126 126 2021-01-31 Craighead Arkansas 5031 12141 166
127 127 2021-01-31 Crawford Arkansas 5033 6196 90
128 128 2021-01-31 Crittenden Arkansas 5035 5360 84
129 129 2021-01-31 Cross Arkansas 5037 1819 43
130 130 2021-01-31 Dallas Arkansas 5039 668 12
131 131 2021-01-31 Desha Arkansas 5041 1206 17
132 132 2021-01-31 Drew Arkansas 5043 1864 31
133 133 2021-01-31 Faulkner Arkansas 5045 10624 135
134 134 2021-01-31 Franklin Arkansas 5047 1502 30
135 135 2021-01-31 Fulton Arkansas 5049 1024 42
136 136 2021-01-31 Garland Arkansas 5051 8370 206
137 137 2021-01-31 Grant Arkansas 5053 1386 28
138 138 2021-01-31 Greene Arkansas 5055 5498 65
139 139 2021-01-31 Hempstead Arkansas 5057 1632 14
140 140 2021-01-31 Hot Spring Arkansas 5059 4399 62
141 141 2021-01-31 Howard Arkansas 5061 1352 21
142 142 2021-01-31 Independence Arkansas 5063 3454 113
143 143 2021-01-31 Izard Arkansas 5065 1557 36
144 144 2021-01-31 Jackson Arkansas 5067 3066 32
145 145 2021-01-31 Jefferson Arkansas 5069 8061 148
146 146 2021-01-31 Johnson Arkansas 5071 2505 28
147 147 2021-01-31 Lafayette Arkansas 5073 445 7
148 148 2021-01-31 Lawrence Arkansas 5075 1907 41
149 149 2021-01-31 Lee Arkansas 5077 1597 31
150 150 2021-01-31 Lincoln Arkansas 5079 3051 38
151 151 2021-01-31 Little River Arkansas 5081 1036 39
152 152 2021-01-31 Logan Arkansas 5083 1974 17
153 153 2021-01-31 Lonoke Arkansas 5085 5963 103
154 154 2021-01-31 Madison Arkansas 5087 1340 18
155 155 2021-01-31 Marion Arkansas 5089 867 27
156 156 2021-01-31 Miller Arkansas 5091 3376 29
157 157 2021-01-31 Mississippi Arkansas 5093 5250 105
158 158 2021-01-31 Monroe Arkansas 5095 732 14
159 159 2021-01-31 Montgomery Arkansas 5097 654 27
160 160 2021-01-31 Nevada Arkansas 5099 717 23
161 161 2021-01-31 Newton Arkansas 5101 647 26
162 162 2021-01-31 Ouachita Arkansas 5103 1964 45
163 163 2021-01-31 Perry Arkansas 5105 678 7
164 164 2021-01-31 Phillips Arkansas 5107 1607 31
165 165 2021-01-31 Pike Arkansas 5109 877 19
166 166 2021-01-31 Poinsett Arkansas 5111 2927 72
167 167 2021-01-31 Polk Arkansas 5113 1656 56
168 168 2021-01-31 Pope Arkansas 5115 7188 86
169 169 2021-01-31 Prairie Arkansas 5117 790 21
170 170 2021-01-31 Pulaski Arkansas 5119 33841 508
171 171 2021-01-31 Randolph Arkansas 5121 1834 46
172 172 2021-01-31 Saline Arkansas 5125 10403 148
173 173 2021-01-31 Scott Arkansas 5127 869 14
174 174 2021-01-31 Searcy Arkansas 5129 615 14
175 175 2021-01-31 Sebastian Arkansas 5131 13555 230
176 176 2021-01-31 Sevier Arkansas 5133 2343 25
177 177 2021-01-31 Sharp Arkansas 5135 1445 46
178 178 2021-01-31 St. Francis Arkansas 5123 3315 32
179 179 2021-01-31 Stone Arkansas 5137 924 29
180 180 2021-01-31 Union Arkansas 5139 3331 92
181 181 2021-01-31 Unknown Arkansas   2907 0
182 182 2021-01-31 Van Buren Arkansas 5141 1117 13
183 183 2021-01-31 Washington Arkansas 5143 27660 307
184 184 2021-01-31 White Arkansas 5145 6496 89
185 185 2021-01-31 Woodruff Arkansas 5147 552 6
186 186 2021-01-31 Yell Arkansas 5149 3048 61
187 187 2021-01-31 Alameda California 6001 73792 980
188 188 2021-01-31 Alpine California 6003 72 0
189 189 2021-01-31 Amador California 6005 3180 33
190 190 2021-01-31 Butte California 6007 10177 138
191 191 2021-01-31 Calaveras California 6009 1763 23
192 192 2021-01-31 Colusa California 6011 1935 10
193 193 2021-01-31 Contra Costa California 6013 57337 529
194 194 2021-01-31 Del Norte California 6015 883 3
195 195 2021-01-31 El Dorado California 6017 8299 79
196 196 2021-01-31 Fresno California 6019 88476 1137
197 197 2021-01-31 Glenn California 6021 2074 23
198 198 2021-01-31 Humboldt California 6023 2754 30
199 199 2021-01-31 Imperial California 6025 26160 531
200 200 2021-01-31 Inyo California 6027 1068 29

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