ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 56
- Texas 163,014
- Georgia 105,689
- Virginia 87,162
- Kentucky 78,172
- Missouri 75,560
- Illinois 67,142
- Kansas 66,658
- North Carolina 65,809
- Iowa 65,070
- Tennessee 63,199
- Indiana 60,846
- Ohio 58,421
- Nebraska 57,975
- Minnesota 57,323
- Michigan 55,122
- Mississippi 54,250
- Oklahoma 50,563
- Arkansas 49,912
- Puerto Rico 48,917
- Wisconsin 47,353
- Florida 45,202
- Pennsylvania 44,401
- Alabama 44,205
- Louisiana 43,102
- Colorado 41,847
- South Dakota 41,632
- California 38,732
- New York 38,732
- West Virginia 35,638
- North Dakota 34,019
- Montana 33,936
- South Carolina 30,571
- Idaho 27,903
- Washington 26,203
- Oregon 23,460
- New Mexico 21,412
- Utah 19,319
- Alaska 17,182
- Maryland 16,645
- Wyoming 15,055
- New Jersey 14,777
- Maine 11,058
- Nevada 10,767
- Massachusetts 10,114
- Arizona 10,111
- Vermont 9,958
- New Hampshire 7,292
- Connecticut 6,011
- Rhode Island 3,984
- Hawaii 3,262
- Delaware 2,651
- Virgin Islands 2,110
- Northern Mariana Islands 1,365
- District of Columbia 678
- Guam 670
- American Samoa 118
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2109228 | 2109228 | 2022-01-13 | Graham | Arizona | 4009 | 9449 | 159 |
2109229 | 2109229 | 2022-01-13 | Greenlee | Arizona | 4011 | 1647 | 30 |
2109230 | 2109230 | 2022-01-13 | La Paz | Arizona | 4012 | 3945 | 112 |
2109231 | 2109231 | 2022-01-13 | Maricopa | Arizona | 4013 | 982065 | 14064 |
2109232 | 2109232 | 2022-01-13 | Mohave | Arizona | 4015 | 42924 | 1230 |
2109233 | 2109233 | 2022-01-13 | Navajo | Arizona | 4017 | 29629 | 770 |
2109234 | 2109234 | 2022-01-13 | Pima | Arizona | 4019 | 191727 | 3273 |
2109235 | 2109235 | 2022-01-13 | Pinal | Arizona | 4021 | 97878 | 1361 |
2109236 | 2109236 | 2022-01-13 | Santa Cruz | Arizona | 4023 | 11684 | 207 |
2109237 | 2109237 | 2022-01-13 | Unknown | Arizona | 2 | 0 | |
2109238 | 2109238 | 2022-01-13 | Yavapai | Arizona | 4025 | 38885 | 1007 |
2109239 | 2109239 | 2022-01-13 | Yuma | Arizona | 4027 | 47851 | 1012 |
2109240 | 2109240 | 2022-01-13 | Arkansas | Arkansas | 5001 | 4425 | 67 |
2109241 | 2109241 | 2022-01-13 | Ashley | Arkansas | 5003 | 3920 | 56 |
2109242 | 2109242 | 2022-01-13 | Baxter | Arkansas | 5005 | 7118 | 209 |
2109243 | 2109243 | 2022-01-13 | Benton | Arkansas | 5007 | 52356 | 705 |
2109244 | 2109244 | 2022-01-13 | Boone | Arkansas | 5009 | 7624 | 142 |
2109245 | 2109245 | 2022-01-13 | Bradley | Arkansas | 5011 | 2302 | 43 |
2109246 | 2109246 | 2022-01-13 | Calhoun | Arkansas | 5013 | 703 | 9 |
2109247 | 2109247 | 2022-01-13 | Carroll | Arkansas | 5015 | 5002 | 83 |
2109248 | 2109248 | 2022-01-13 | Chicot | Arkansas | 5017 | 2362 | 49 |
2109249 | 2109249 | 2022-01-13 | Clark | Arkansas | 5019 | 4265 | 66 |
2109250 | 2109250 | 2022-01-13 | Clay | Arkansas | 5021 | 3214 | 77 |
2109251 | 2109251 | 2022-01-13 | Cleburne | Arkansas | 5023 | 4937 | 104 |
2109252 | 2109252 | 2022-01-13 | Cleveland | Arkansas | 5025 | 1778 | 33 |
2109253 | 2109253 | 2022-01-13 | Columbia | Arkansas | 5027 | 4188 | 77 |
2109254 | 2109254 | 2022-01-13 | Conway | Arkansas | 5029 | 4193 | 50 |
2109255 | 2109255 | 2022-01-13 | Craighead | Arkansas | 5031 | 30135 | 267 |
2109256 | 2109256 | 2022-01-13 | Crawford | Arkansas | 5033 | 12621 | 201 |
2109257 | 2109257 | 2022-01-13 | Crittenden | Arkansas | 5035 | 11710 | 194 |
2109258 | 2109258 | 2022-01-13 | Cross | Arkansas | 5037 | 3741 | 73 |
2109259 | 2109259 | 2022-01-13 | Dallas | Arkansas | 5039 | 1388 | 21 |
2109260 | 2109260 | 2022-01-13 | Desha | Arkansas | 5041 | 2428 | 35 |
2109261 | 2109261 | 2022-01-13 | Drew | Arkansas | 5043 | 3535 | 58 |
2109262 | 2109262 | 2022-01-13 | Faulkner | Arkansas | 5045 | 26734 | 254 |
2109263 | 2109263 | 2022-01-13 | Franklin | Arkansas | 5047 | 3149 | 61 |
2109264 | 2109264 | 2022-01-13 | Fulton | Arkansas | 5049 | 2202 | 79 |
2109265 | 2109265 | 2022-01-13 | Garland | Arkansas | 5051 | 18406 | 434 |
2109266 | 2109266 | 2022-01-13 | Grant | Arkansas | 5053 | 3490 | 52 |
2109267 | 2109267 | 2022-01-13 | Greene | Arkansas | 5055 | 12698 | 139 |
2109268 | 2109268 | 2022-01-13 | Hempstead | Arkansas | 5057 | 3668 | 51 |
2109269 | 2109269 | 2022-01-13 | Hot Spring | Arkansas | 5059 | 8914 | 113 |
2109270 | 2109270 | 2022-01-13 | Howard | Arkansas | 5061 | 3170 | 39 |
2109271 | 2109271 | 2022-01-13 | Independence | Arkansas | 5063 | 8207 | 180 |
2109272 | 2109272 | 2022-01-13 | Izard | Arkansas | 5065 | 3231 | 58 |
2109273 | 2109273 | 2022-01-13 | Jackson | Arkansas | 5067 | 5058 | 49 |
2109274 | 2109274 | 2022-01-13 | Jefferson | Arkansas | 5069 | 15284 | 240 |
2109275 | 2109275 | 2022-01-13 | Johnson | Arkansas | 5071 | 5251 | 65 |
2109276 | 2109276 | 2022-01-13 | Lafayette | Arkansas | 5073 | 1066 | 28 |
2109277 | 2109277 | 2022-01-13 | Lawrence | Arkansas | 5075 | 4032 | 64 |
2109278 | 2109278 | 2022-01-13 | Lee | Arkansas | 5077 | 2523 | 54 |
2109279 | 2109279 | 2022-01-13 | Lincoln | Arkansas | 5079 | 4259 | 59 |
2109280 | 2109280 | 2022-01-13 | Little River | Arkansas | 5081 | 2550 | 85 |
2109281 | 2109281 | 2022-01-13 | Logan | Arkansas | 5083 | 4112 | 56 |
2109282 | 2109282 | 2022-01-13 | Lonoke | Arkansas | 5085 | 15669 | 189 |
2109283 | 2109283 | 2022-01-13 | Madison | Arkansas | 5087 | 3149 | 47 |
2109284 | 2109284 | 2022-01-13 | Marion | Arkansas | 5089 | 2702 | 75 |
2109285 | 2109285 | 2022-01-13 | Miller | Arkansas | 5091 | 7599 | 158 |
2109286 | 2109286 | 2022-01-13 | Mississippi | Arkansas | 5093 | 10804 | 165 |
2109287 | 2109287 | 2022-01-13 | Monroe | Arkansas | 5095 | 1519 | 28 |
2109288 | 2109288 | 2022-01-13 | Montgomery | Arkansas | 5097 | 1275 | 53 |
2109289 | 2109289 | 2022-01-13 | Nevada | Arkansas | 5099 | 1731 | 43 |
2109290 | 2109290 | 2022-01-13 | Newton | Arkansas | 5101 | 1467 | 45 |
2109291 | 2109291 | 2022-01-13 | Ouachita | Arkansas | 5103 | 4355 | 91 |
2109292 | 2109292 | 2022-01-13 | Perry | Arkansas | 5105 | 1885 | 26 |
2109293 | 2109293 | 2022-01-13 | Phillips | Arkansas | 5107 | 4047 | 84 |
2109294 | 2109294 | 2022-01-13 | Pike | Arkansas | 5109 | 2108 | 39 |
2109295 | 2109295 | 2022-01-13 | Poinsett | Arkansas | 5111 | 6458 | 107 |
2109296 | 2109296 | 2022-01-13 | Polk | Arkansas | 5113 | 3322 | 130 |
2109297 | 2109297 | 2022-01-13 | Pope | Arkansas | 5115 | 14344 | 169 |
2109298 | 2109298 | 2022-01-13 | Prairie | Arkansas | 5117 | 1529 | 32 |
2109299 | 2109299 | 2022-01-13 | Pulaski | Arkansas | 5119 | 82760 | 988 |
2109300 | 2109300 | 2022-01-13 | Randolph | Arkansas | 5121 | 4040 | 68 |
2109301 | 2109301 | 2022-01-13 | Saline | Arkansas | 5125 | 24213 | 265 |
2109302 | 2109302 | 2022-01-13 | Scott | Arkansas | 5127 | 1906 | 35 |
2109303 | 2109303 | 2022-01-13 | Searcy | Arkansas | 5129 | 1670 | 33 |
2109304 | 2109304 | 2022-01-13 | Sebastian | Arkansas | 5131 | 26818 | 416 |
2109305 | 2109305 | 2022-01-13 | Sevier | Arkansas | 5133 | 4671 | 63 |
2109306 | 2109306 | 2022-01-13 | Sharp | Arkansas | 5135 | 3656 | 82 |
2109307 | 2109307 | 2022-01-13 | St. Francis | Arkansas | 5123 | 5933 | 74 |
2109308 | 2109308 | 2022-01-13 | Stone | Arkansas | 5137 | 2238 | 51 |
2109309 | 2109309 | 2022-01-13 | Union | Arkansas | 5139 | 7495 | 155 |
2109310 | 2109310 | 2022-01-13 | Unknown | Arkansas | 11614 | 0 | |
2109311 | 2109311 | 2022-01-13 | Van Buren | Arkansas | 5141 | 2824 | 46 |
2109312 | 2109312 | 2022-01-13 | Washington | Arkansas | 5143 | 54794 | 523 |
2109313 | 2109313 | 2022-01-13 | White | Arkansas | 5145 | 16568 | 216 |
2109314 | 2109314 | 2022-01-13 | Woodruff | Arkansas | 5147 | 1314 | 24 |
2109315 | 2109315 | 2022-01-13 | Yell | Arkansas | 5149 | 5363 | 91 |
2109316 | 2109316 | 2022-01-13 | Alameda | California | 6001 | 180353 | 1586 |
2109317 | 2109317 | 2022-01-13 | Alpine | California | 6003 | 117 | 0 |
2109318 | 2109318 | 2022-01-13 | Amador | California | 6005 | 6482 | 71 |
2109319 | 2109319 | 2022-01-13 | Butte | California | 6007 | 29391 | 348 |
2109320 | 2109320 | 2022-01-13 | Calaveras | California | 6009 | 5281 | 93 |
2109321 | 2109321 | 2022-01-13 | Colusa | California | 6011 | 3599 | 21 |
2109322 | 2109322 | 2022-01-13 | Contra Costa | California | 6013 | 139908 | 1077 |
2109323 | 2109323 | 2022-01-13 | Del Norte | California | 6015 | 4251 | 43 |
2109324 | 2109324 | 2022-01-13 | El Dorado | California | 6017 | 22358 | 175 |
2109325 | 2109325 | 2022-01-13 | Fresno | California | 6019 | 179628 | 2413 |
2109326 | 2109326 | 2022-01-13 | Glenn | California | 6021 | 5033 | 55 |
2109327 | 2109327 | 2022-01-13 | Humboldt | California | 6023 | 13463 | 128 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);