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 >30
- Texas 191,482
- Georgia 123,449
- Virginia 102,064
- Kentucky 91,612
- Missouri 88,664
- Illinois 78,575
- Kansas 78,446
- North Carolina 77,009
- Iowa 76,270
- Tennessee 73,951
- Indiana 71,136
- Nebraska 68,503
- Ohio 68,389
- Minnesota 67,179
- Michigan 64,530
- Mississippi 63,484
- Oklahoma 59,299
- Arkansas 58,348
- Puerto Rico 57,765
- Wisconsin 55,417
- Florida 52,750
- Pennsylvania 51,905
- Alabama 51,709
- Louisiana 50,382
- South Dakota 49,024
- Colorado 48,951
- New York 45,228
- California 45,171
- West Virginia 41,798
- Montana 40,208
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474258 | 2474258 | 2022-05-05 | Knox | Indiana | 18083 | 10770 | 153 |
2474259 | 2474259 | 2022-05-05 | Kosciusko | Indiana | 18085 | 19797 | 237 |
2474260 | 2474260 | 2022-05-05 | LaGrange | Indiana | 18087 | 5860 | 102 |
2474261 | 2474261 | 2022-05-05 | LaPorte | Indiana | 18091 | 25721 | 368 |
2474262 | 2474262 | 2022-05-05 | Lake | Indiana | 18089 | 107616 | 1826 |
2474263 | 2474263 | 2022-05-05 | Lawrence | Indiana | 18093 | 11950 | 260 |
2474264 | 2474264 | 2022-05-05 | Madison | Indiana | 18095 | 32790 | 652 |
2474265 | 2474265 | 2022-05-05 | Marion | Indiana | 18097 | 226560 | 2995 |
2474266 | 2474266 | 2022-05-05 | Marshall | Indiana | 18099 | 12400 | 197 |
2474267 | 2474267 | 2022-05-05 | Martin | Indiana | 18101 | 2169 | 25 |
2474268 | 2474268 | 2022-05-05 | Miami | Indiana | 18103 | 9280 | 159 |
2474269 | 2474269 | 2022-05-05 | Monroe | Indiana | 18105 | 28457 | 280 |
2474270 | 2474270 | 2022-05-05 | Montgomery | Indiana | 18107 | 10706 | 164 |
2474271 | 2474271 | 2022-05-05 | Morgan | Indiana | 18109 | 16529 | 287 |
2474272 | 2474272 | 2022-05-05 | Newton | Indiana | 18111 | 2581 | 68 |
2474273 | 2474273 | 2022-05-05 | Noble | Indiana | 18113 | 13100 | 157 |
2474274 | 2474274 | 2022-05-05 | Ohio | Indiana | 18115 | 1451 | 19 |
2474275 | 2474275 | 2022-05-05 | Orange | Indiana | 18117 | 5049 | 96 |
2474276 | 2474276 | 2022-05-05 | Owen | Indiana | 18119 | 5877 | 121 |
2474277 | 2474277 | 2022-05-05 | Parke | Indiana | 18121 | 3600 | 46 |
2474278 | 2474278 | 2022-05-05 | Perry | Indiana | 18123 | 4659 | 69 |
2474279 | 2474279 | 2022-05-05 | Pike | Indiana | 18125 | 3743 | 49 |
2474280 | 2474280 | 2022-05-05 | Porter | Indiana | 18127 | 38223 | 562 |
2474281 | 2474281 | 2022-05-05 | Posey | Indiana | 18129 | 6559 | 58 |
2474282 | 2474282 | 2022-05-05 | Pulaski | Indiana | 18131 | 3081 | 86 |
2474283 | 2474283 | 2022-05-05 | Putnam | Indiana | 18133 | 9381 | 129 |
2474284 | 2474284 | 2022-05-05 | Randolph | Indiana | 18135 | 5912 | 148 |
2474285 | 2474285 | 2022-05-05 | Ripley | Indiana | 18137 | 8329 | 138 |
2474286 | 2474286 | 2022-05-05 | Rush | Indiana | 18139 | 4849 | 58 |
2474287 | 2474287 | 2022-05-05 | Scott | Indiana | 18143 | 7885 | 106 |
2474288 | 2474288 | 2022-05-05 | Shelby | Indiana | 18145 | 13622 | 182 |
2474289 | 2474289 | 2022-05-05 | Spencer | Indiana | 18147 | 5240 | 61 |
2474290 | 2474290 | 2022-05-05 | St. Joseph | Indiana | 18141 | 71349 | 873 |
2474291 | 2474291 | 2022-05-05 | Starke | Indiana | 18149 | 4765 | 99 |
2474292 | 2474292 | 2022-05-05 | Steuben | Indiana | 18151 | 9642 | 121 |
2474293 | 2474293 | 2022-05-05 | Sullivan | Indiana | 18153 | 5288 | 76 |
2474294 | 2474294 | 2022-05-05 | Switzerland | Indiana | 18155 | 2315 | 20 |
2474295 | 2474295 | 2022-05-05 | Tippecanoe | Indiana | 18157 | 51236 | 396 |
2474296 | 2474296 | 2022-05-05 | Tipton | Indiana | 18159 | 3534 | 87 |
2474297 | 2474297 | 2022-05-05 | Union | Indiana | 18161 | 2022 | 21 |
2474298 | 2474298 | 2022-05-05 | Unknown | Indiana | 0 | 21 | |
2474299 | 2474299 | 2022-05-05 | Vanderburgh | Indiana | 18163 | 57582 | 635 |
2474300 | 2474300 | 2022-05-05 | Vermillion | Indiana | 18165 | 4095 | 75 |
2474301 | 2474301 | 2022-05-05 | Vigo | Indiana | 18167 | 28961 | 413 |
2474302 | 2474302 | 2022-05-05 | Wabash | Indiana | 18169 | 8736 | 156 |
2474303 | 2474303 | 2022-05-05 | Warren | Indiana | 18171 | 2107 | 30 |
2474304 | 2474304 | 2022-05-05 | Warrick | Indiana | 18173 | 20343 | 239 |
2474305 | 2474305 | 2022-05-05 | Washington | Indiana | 18175 | 6004 | 85 |
2474306 | 2474306 | 2022-05-05 | Wayne | Indiana | 18177 | 18864 | 337 |
2474307 | 2474307 | 2022-05-05 | Wells | Indiana | 18179 | 6507 | 132 |
2474308 | 2474308 | 2022-05-05 | White | Indiana | 18181 | 6917 | 96 |
2474309 | 2474309 | 2022-05-05 | Whitley | Indiana | 18183 | 9691 | 84 |
2474310 | 2474310 | 2022-05-05 | Adair | Iowa | 19001 | 1588 | 50 |
2474311 | 2474311 | 2022-05-05 | Adams | Iowa | 19003 | 819 | 13 |
2474312 | 2474312 | 2022-05-05 | Allamakee | Iowa | 19005 | 2881 | 60 |
2474313 | 2474313 | 2022-05-05 | Appanoose | Iowa | 19007 | 2923 | 68 |
2474314 | 2474314 | 2022-05-05 | Audubon | Iowa | 19009 | 1114 | 19 |
2474315 | 2474315 | 2022-05-05 | Benton | Iowa | 19011 | 6057 | 77 |
2474316 | 2474316 | 2022-05-05 | Black Hawk | Iowa | 19013 | 33010 | 479 |
2474317 | 2474317 | 2022-05-05 | Boone | Iowa | 19015 | 5505 | 54 |
2474318 | 2474318 | 2022-05-05 | Bremer | Iowa | 19017 | 5541 | 82 |
2474319 | 2474319 | 2022-05-05 | Buchanan | Iowa | 19019 | 4604 | 58 |
2474320 | 2474320 | 2022-05-05 | Buena Vista | Iowa | 19021 | 6401 | 57 |
2474321 | 2474321 | 2022-05-05 | Butler | Iowa | 19023 | 3243 | 53 |
2474322 | 2474322 | 2022-05-05 | Calhoun | Iowa | 19025 | 2603 | 25 |
2474323 | 2474323 | 2022-05-05 | Carroll | Iowa | 19027 | 4950 | 65 |
2474324 | 2474324 | 2022-05-05 | Cass | Iowa | 19029 | 2962 | 78 |
2474325 | 2474325 | 2022-05-05 | Cedar | Iowa | 19031 | 4181 | 35 |
2474326 | 2474326 | 2022-05-05 | Cerro Gordo | Iowa | 19033 | 11140 | 169 |
2474327 | 2474327 | 2022-05-05 | Cherokee | Iowa | 19035 | 2977 | 61 |
2474328 | 2474328 | 2022-05-05 | Chickasaw | Iowa | 19037 | 2691 | 32 |
2474329 | 2474329 | 2022-05-05 | Clarke | Iowa | 19039 | 2265 | 37 |
2474330 | 2474330 | 2022-05-05 | Clay | Iowa | 19041 | 4113 | 44 |
2474331 | 2474331 | 2022-05-05 | Clayton | Iowa | 19043 | 3491 | 72 |
2474332 | 2474332 | 2022-05-05 | Clinton | Iowa | 19045 | 11601 | 146 |
2474333 | 2474333 | 2022-05-05 | Crawford | Iowa | 19047 | 4528 | 54 |
2474334 | 2474334 | 2022-05-05 | Dallas | Iowa | 19049 | 23238 | 144 |
2474335 | 2474335 | 2022-05-05 | Davis | Iowa | 19051 | 1602 | 32 |
2474336 | 2474336 | 2022-05-05 | Decatur | Iowa | 19053 | 1516 | 26 |
2474337 | 2474337 | 2022-05-05 | Delaware | Iowa | 19055 | 4040 | 68 |
2474338 | 2474338 | 2022-05-05 | Des Moines | Iowa | 19057 | 9170 | 138 |
2474339 | 2474339 | 2022-05-05 | Dickinson | Iowa | 19059 | 4133 | 72 |
2474340 | 2474340 | 2022-05-05 | Dubuque | Iowa | 19061 | 26176 | 294 |
2474341 | 2474341 | 2022-05-05 | Emmet | Iowa | 19063 | 2364 | 52 |
2474342 | 2474342 | 2022-05-05 | Fayette | Iowa | 19065 | 4110 | 74 |
2474343 | 2474343 | 2022-05-05 | Floyd | Iowa | 19067 | 3575 | 62 |
2474344 | 2474344 | 2022-05-05 | Franklin | Iowa | 19069 | 2517 | 42 |
2474345 | 2474345 | 2022-05-05 | Fremont | Iowa | 19071 | 1387 | 25 |
2474346 | 2474346 | 2022-05-05 | Greene | Iowa | 19073 | 1743 | 21 |
2474347 | 2474347 | 2022-05-05 | Grundy | Iowa | 19075 | 2570 | 44 |
2474348 | 2474348 | 2022-05-05 | Guthrie | Iowa | 19077 | 2359 | 46 |
2474349 | 2474349 | 2022-05-05 | Hamilton | Iowa | 19079 | 3477 | 72 |
2474350 | 2474350 | 2022-05-05 | Hancock | Iowa | 19081 | 2848 | 47 |
2474351 | 2474351 | 2022-05-05 | Hardin | Iowa | 19083 | 4130 | 62 |
2474352 | 2474352 | 2022-05-05 | Harrison | Iowa | 19085 | 3435 | 95 |
2474353 | 2474353 | 2022-05-05 | Henry | Iowa | 19087 | 5566 | 74 |
2474354 | 2474354 | 2022-05-05 | Howard | Iowa | 19089 | 2064 | 35 |
2474355 | 2474355 | 2022-05-05 | Humboldt | Iowa | 19091 | 2627 | 38 |
2474356 | 2474356 | 2022-05-05 | Ida | Iowa | 19093 | 1826 | 49 |
2474357 | 2474357 | 2022-05-05 | Iowa | Iowa | 19095 | 3699 | 50 |
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);