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 71,320
- Georgia 47,769
- Virginia 39,147
- Kentucky 34,732
- Missouri 33,205
- Illinois 29,869
- North Carolina 29,708
- Iowa 28,870
- Kansas 28,557
- Tennessee 28,543
- Indiana 27,542
- Ohio 26,338
- Minnesota 25,467
- Michigan 24,714
- Mississippi 24,566
- Nebraska 24,157
- Oklahoma 22,406
- Arkansas 22,400
- Wisconsin 21,359
- Florida 20,586
- Puerto Rico 20,398
- Pennsylvania 20,214
- Alabama 20,018
- Louisiana 19,573
- Colorado 18,679
- South Dakota 17,806
- New York 17,794
- California 17,729
- West Virginia 15,781
- North Dakota 14,525
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
938340 | 938340 | 2021-01-17 | Boyd | Nebraska | 31015 | 167 | 3 |
938341 | 938341 | 2021-01-17 | Brown | Nebraska | 31017 | 211 | 2 |
938342 | 938342 | 2021-01-17 | Buffalo | Nebraska | 31019 | 4625 | 53 |
938343 | 938343 | 2021-01-17 | Burt | Nebraska | 31021 | 552 | 10 |
938344 | 938344 | 2021-01-17 | Butler | Nebraska | 31023 | 780 | 11 |
938345 | 938345 | 2021-01-17 | Cass | Nebraska | 31025 | 1961 | 14 |
938346 | 938346 | 2021-01-17 | Cedar | Nebraska | 31027 | 594 | 10 |
938347 | 938347 | 2021-01-17 | Chase | Nebraska | 31029 | 411 | 3 |
938348 | 938348 | 2021-01-17 | Cherry | Nebraska | 31031 | 259 | 6 |
938349 | 938349 | 2021-01-17 | Cheyenne | Nebraska | 31033 | 793 | 15 |
938350 | 938350 | 2021-01-17 | Clay | Nebraska | 31035 | 598 | 11 |
938351 | 938351 | 2021-01-17 | Colfax | Nebraska | 31037 | 1502 | 19 |
938352 | 938352 | 2021-01-17 | Cuming | Nebraska | 31039 | 907 | 9 |
938353 | 938353 | 2021-01-17 | Custer | Nebraska | 31041 | 724 | 16 |
938354 | 938354 | 2021-01-17 | Dakota | Nebraska | 31043 | 3720 | 67 |
938355 | 938355 | 2021-01-17 | Dawes | Nebraska | 31045 | 583 | 18 |
938356 | 938356 | 2021-01-17 | Dawson | Nebraska | 31047 | 2618 | 25 |
938357 | 938357 | 2021-01-17 | Deuel | Nebraska | 31049 | 82 | 0 |
938358 | 938358 | 2021-01-17 | Dixon | Nebraska | 31051 | 515 | 8 |
938359 | 938359 | 2021-01-17 | Dodge | Nebraska | 31053 | 4186 | 48 |
938360 | 938360 | 2021-01-17 | Douglas | Nebraska | 31055 | 58393 | 553 |
938361 | 938361 | 2021-01-17 | Dundy | Nebraska | 31057 | 133 | 4 |
938362 | 938362 | 2021-01-17 | Fillmore | Nebraska | 31059 | 447 | 9 |
938363 | 938363 | 2021-01-17 | Franklin | Nebraska | 31061 | 216 | 3 |
938364 | 938364 | 2021-01-17 | Frontier | Nebraska | 31063 | 170 | 1 |
938365 | 938365 | 2021-01-17 | Furnas | Nebraska | 31065 | 394 | 4 |
938366 | 938366 | 2021-01-17 | Gage | Nebraska | 31067 | 1952 | 15 |
938367 | 938367 | 2021-01-17 | Garden | Nebraska | 31069 | 101 | 1 |
938368 | 938368 | 2021-01-17 | Garfield | Nebraska | 31071 | 134 | 3 |
938369 | 938369 | 2021-01-17 | Gosper | Nebraska | 31073 | 172 | 4 |
938370 | 938370 | 2021-01-17 | Grant | Nebraska | 31075 | 22 | 4 |
938371 | 938371 | 2021-01-17 | Greeley | Nebraska | 31077 | 182 | 2 |
938372 | 938372 | 2021-01-17 | Hall | Nebraska | 31079 | 6356 | 103 |
938373 | 938373 | 2021-01-17 | Hamilton | Nebraska | 31081 | 803 | 16 |
938374 | 938374 | 2021-01-17 | Harlan | Nebraska | 31083 | 191 | 0 |
938375 | 938375 | 2021-01-17 | Hayes | Nebraska | 31085 | 56 | 0 |
938376 | 938376 | 2021-01-17 | Hitchcock | Nebraska | 31087 | 205 | 3 |
938377 | 938377 | 2021-01-17 | Holt | Nebraska | 31089 | 721 | 14 |
938378 | 938378 | 2021-01-17 | Hooker | Nebraska | 31091 | 49 | 2 |
938379 | 938379 | 2021-01-17 | Howard | Nebraska | 31093 | 491 | 14 |
938380 | 938380 | 2021-01-17 | Jefferson | Nebraska | 31095 | 588 | 1 |
938381 | 938381 | 2021-01-17 | Johnson | Nebraska | 31097 | 595 | 7 |
938382 | 938382 | 2021-01-17 | Kearney | Nebraska | 31099 | 605 | 4 |
938383 | 938383 | 2021-01-17 | Keith | Nebraska | 31101 | 632 | 3 |
938384 | 938384 | 2021-01-17 | Keya Paha | Nebraska | 31103 | 38 | 0 |
938385 | 938385 | 2021-01-17 | Kimball | Nebraska | 31105 | 363 | 5 |
938386 | 938386 | 2021-01-17 | Knox | Nebraska | 31107 | 760 | 7 |
938387 | 938387 | 2021-01-17 | Lancaster | Nebraska | 31109 | 25257 | 179 |
938388 | 938388 | 2021-01-17 | Lincoln | Nebraska | 31111 | 3268 | 39 |
938389 | 938389 | 2021-01-17 | Logan | Nebraska | 31113 | 71 | 0 |
938390 | 938390 | 2021-01-17 | Loup | Nebraska | 31115 | 38 | 0 |
938391 | 938391 | 2021-01-17 | Madison | Nebraska | 31119 | 3950 | 40 |
938392 | 938392 | 2021-01-17 | McPherson | Nebraska | 31117 | 23 | 1 |
938393 | 938393 | 2021-01-17 | Merrick | Nebraska | 31121 | 686 | 11 |
938394 | 938394 | 2021-01-17 | Morrill | Nebraska | 31123 | 437 | 15 |
938395 | 938395 | 2021-01-17 | Nance | Nebraska | 31125 | 361 | 10 |
938396 | 938396 | 2021-01-17 | Nemaha | Nebraska | 31127 | 542 | 12 |
938397 | 938397 | 2021-01-17 | Nuckolls | Nebraska | 31129 | 328 | 1 |
938398 | 938398 | 2021-01-17 | Otoe | Nebraska | 31131 | 1123 | 3 |
938399 | 938399 | 2021-01-17 | Pawnee | Nebraska | 31133 | 177 | 1 |
938400 | 938400 | 2021-01-17 | Perkins | Nebraska | 31135 | 255 | 11 |
938401 | 938401 | 2021-01-17 | Phelps | Nebraska | 31137 | 829 | 8 |
938402 | 938402 | 2021-01-17 | Pierce | Nebraska | 31139 | 569 | 20 |
938403 | 938403 | 2021-01-17 | Platte | Nebraska | 31141 | 3671 | 45 |
938404 | 938404 | 2021-01-17 | Polk | Nebraska | 31143 | 493 | 17 |
938405 | 938405 | 2021-01-17 | Red Willow | Nebraska | 31145 | 1077 | 9 |
938406 | 938406 | 2021-01-17 | Richardson | Nebraska | 31147 | 575 | 15 |
938407 | 938407 | 2021-01-17 | Rock | Nebraska | 31149 | 100 | 2 |
938408 | 938408 | 2021-01-17 | Saline | Nebraska | 31151 | 1823 | 3 |
938409 | 938409 | 2021-01-17 | Sarpy | Nebraska | 31153 | 17431 | 86 |
938410 | 938410 | 2021-01-17 | Saunders | Nebraska | 31155 | 2066 | 11 |
938411 | 938411 | 2021-01-17 | Scotts Bluff | Nebraska | 31157 | 4255 | 78 |
938412 | 938412 | 2021-01-17 | Seward | Nebraska | 31159 | 1705 | 25 |
938413 | 938413 | 2021-01-17 | Sheridan | Nebraska | 31161 | 405 | 13 |
938414 | 938414 | 2021-01-17 | Sherman | Nebraska | 31163 | 165 | 4 |
938415 | 938415 | 2021-01-17 | Sioux | Nebraska | 31165 | 30 | 0 |
938416 | 938416 | 2021-01-17 | Stanton | Nebraska | 31167 | 338 | 8 |
938417 | 938417 | 2021-01-17 | Thayer | Nebraska | 31169 | 428 | 3 |
938418 | 938418 | 2021-01-17 | Thomas | Nebraska | 31171 | 50 | 0 |
938419 | 938419 | 2021-01-17 | Thurston | Nebraska | 31173 | 736 | 9 |
938420 | 938420 | 2021-01-17 | Valley | Nebraska | 31175 | 284 | 3 |
938421 | 938421 | 2021-01-17 | Washington | Nebraska | 31177 | 1791 | 17 |
938422 | 938422 | 2021-01-17 | Wayne | Nebraska | 31179 | 907 | 6 |
938423 | 938423 | 2021-01-17 | Webster | Nebraska | 31181 | 288 | 4 |
938424 | 938424 | 2021-01-17 | Wheeler | Nebraska | 31183 | 32 | 0 |
938425 | 938425 | 2021-01-17 | York | Nebraska | 31185 | 1483 | 12 |
938426 | 938426 | 2021-01-17 | Carson City | Nevada | 32510 | 5515 | 91 |
938427 | 938427 | 2021-01-17 | Churchill | Nevada | 32001 | 1601 | 44 |
938428 | 938428 | 2021-01-17 | Clark | Nevada | 32003 | 200597 | 2866 |
938429 | 938429 | 2021-01-17 | Douglas | Nevada | 32005 | 2259 | 25 |
938430 | 938430 | 2021-01-17 | Elko | Nevada | 32007 | 4123 | 40 |
938431 | 938431 | 2021-01-17 | Esmeralda | Nevada | 32009 | 34 | 0 |
938432 | 938432 | 2021-01-17 | Eureka | Nevada | 32011 | 43 | 0 |
938433 | 938433 | 2021-01-17 | Humboldt | Nevada | 32013 | 937 | 11 |
938434 | 938434 | 2021-01-17 | Lander | Nevada | 32015 | 415 | 8 |
938435 | 938435 | 2021-01-17 | Lincoln | Nevada | 32017 | 321 | 1 |
938436 | 938436 | 2021-01-17 | Lyon | Nevada | 32019 | 2458 | 49 |
938437 | 938437 | 2021-01-17 | Mineral | Nevada | 32021 | 227 | 4 |
938438 | 938438 | 2021-01-17 | Nye | Nevada | 32023 | 2366 | 57 |
938439 | 938439 | 2021-01-17 | Pershing | Nevada | 32027 | 856 | 15 |
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);