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 138,122
- Georgia 89,849
- Virginia 74,127
- Kentucky 66,292
- Missouri 63,977
- Illinois 56,945
- Kansas 56,263
- North Carolina 56,009
- Iowa 55,170
- Tennessee 53,791
- Indiana 51,738
- Ohio 49,699
- Nebraska 48,669
- Minnesota 48,611
- Michigan 46,806
- Mississippi 46,132
- Oklahoma 42,919
- Arkansas 42,388
- Puerto Rico 41,175
- Wisconsin 40,297
- Florida 38,470
- Pennsylvania 37,835
- Alabama 37,639
- Louisiana 36,667
- Colorado 35,511
- South Dakota 35,164
- New York 33,048
- California 32,990
- West Virginia 30,248
- North Dakota 28,727
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1792390 | 1792390 | 2021-10-07 | Elko | Nevada | 32007 | 8113 | 96 |
1792391 | 1792391 | 2021-10-07 | Esmeralda | Nevada | 32009 | 58 | 1 |
1792392 | 1792392 | 2021-10-07 | Eureka | Nevada | 32011 | 194 | 0 |
1792393 | 1792393 | 2021-10-07 | Humboldt | Nevada | 32013 | 2227 | 20 |
1792394 | 1792394 | 2021-10-07 | Lander | Nevada | 32015 | 744 | 14 |
1792395 | 1792395 | 2021-10-07 | Lincoln | Nevada | 32017 | 504 | 5 |
1792396 | 1792396 | 2021-10-07 | Lyon | Nevada | 32019 | 6272 | 101 |
1792397 | 1792397 | 2021-10-07 | Mineral | Nevada | 32021 | 533 | 11 |
1792398 | 1792398 | 2021-10-07 | Nye | Nevada | 32023 | 4315 | 138 |
1792399 | 1792399 | 2021-10-07 | Pershing | Nevada | 32027 | 1074 | 25 |
1792400 | 1792400 | 2021-10-07 | Storey | Nevada | 32029 | 195 | 4 |
1792401 | 1792401 | 2021-10-07 | Washoe | Nevada | 32031 | 62650 | 859 |
1792402 | 1792402 | 2021-10-07 | White Pine | Nevada | 32033 | 1147 | 10 |
1792403 | 1792403 | 2021-10-07 | Belknap | New Hampshire | 33001 | 5620 | 118 |
1792404 | 1792404 | 2021-10-07 | Carroll | New Hampshire | 33003 | 3389 | 19 |
1792405 | 1792405 | 2021-10-07 | Cheshire | New Hampshire | 33005 | 5199 | 47 |
1792406 | 1792406 | 2021-10-07 | Coos | New Hampshire | 33007 | 2897 | 49 |
1792407 | 1792407 | 2021-10-07 | Grafton | New Hampshire | 33009 | 5358 | 30 |
1792408 | 1792408 | 2021-10-07 | Hillsborough | New Hampshire | 33011 | 43190 | 668 |
1792409 | 1792409 | 2021-10-07 | Merrimack | New Hampshire | 33013 | 12292 | 129 |
1792410 | 1792410 | 2021-10-07 | Rockingham | New Hampshire | 33015 | 29543 | 292 |
1792411 | 1792411 | 2021-10-07 | Strafford | New Hampshire | 33017 | 12396 | 112 |
1792412 | 1792412 | 2021-10-07 | Sullivan | New Hampshire | 33019 | 2775 | 32 |
1792413 | 1792413 | 2021-10-07 | Unknown | New Hampshire | 903 | 1 | |
1792414 | 1792414 | 2021-10-07 | Atlantic | New Jersey | 34001 | 38214 | 744 |
1792415 | 1792415 | 2021-10-07 | Bergen | New Jersey | 34003 | 117476 | 2968 |
1792416 | 1792416 | 2021-10-07 | Burlington | New Jersey | 34005 | 52797 | 927 |
1792417 | 1792417 | 2021-10-07 | Camden | New Jersey | 34007 | 65942 | 1413 |
1792418 | 1792418 | 2021-10-07 | Cape May | New Jersey | 34009 | 12098 | 232 |
1792419 | 1792419 | 2021-10-07 | Cumberland | New Jersey | 34011 | 20216 | 465 |
1792420 | 1792420 | 2021-10-07 | Essex | New Jersey | 34013 | 104968 | 3129 |
1792421 | 1792421 | 2021-10-07 | Gloucester | New Jersey | 34015 | 37023 | 704 |
1792422 | 1792422 | 2021-10-07 | Hudson | New Jersey | 34017 | 96145 | 2375 |
1792423 | 1792423 | 2021-10-07 | Hunterdon | New Jersey | 34019 | 11548 | 187 |
1792424 | 1792424 | 2021-10-07 | Mercer | New Jersey | 34021 | 38479 | 996 |
1792425 | 1792425 | 2021-10-07 | Middlesex | New Jersey | 34023 | 104138 | 2438 |
1792426 | 1792426 | 2021-10-07 | Monmouth | New Jersey | 34025 | 89812 | 1711 |
1792427 | 1792427 | 2021-10-07 | Morris | New Jersey | 34027 | 56651 | 1292 |
1792428 | 1792428 | 2021-10-07 | Ocean | New Jersey | 34029 | 91259 | 2301 |
1792429 | 1792429 | 2021-10-07 | Passaic | New Jersey | 34031 | 80278 | 1995 |
1792430 | 1792430 | 2021-10-07 | Salem | New Jersey | 34033 | 7404 | 200 |
1792431 | 1792431 | 2021-10-07 | Somerset | New Jersey | 34035 | 34265 | 871 |
1792432 | 1792432 | 2021-10-07 | Sussex | New Jersey | 34037 | 16449 | 322 |
1792433 | 1792433 | 2021-10-07 | Union | New Jersey | 34039 | 79000 | 2029 |
1792434 | 1792434 | 2021-10-07 | Unknown | New Jersey | 640 | 0 | |
1792435 | 1792435 | 2021-10-07 | Warren | New Jersey | 34041 | 11641 | 252 |
1792436 | 1792436 | 2021-10-07 | Bernalillo | New Mexico | 35001 | 72529 | 1076 |
1792437 | 1792437 | 2021-10-07 | Catron | New Mexico | 35003 | 147 | 7 |
1792438 | 1792438 | 2021-10-07 | Chaves | New Mexico | 35005 | 12384 | 191 |
1792439 | 1792439 | 2021-10-07 | Cibola | New Mexico | 35006 | 4058 | 135 |
1792440 | 1792440 | 2021-10-07 | Colfax | New Mexico | 35007 | 1347 | 47 |
1792441 | 1792441 | 2021-10-07 | Curry | New Mexico | 35009 | 7159 | 106 |
1792442 | 1792442 | 2021-10-07 | De Baca | New Mexico | 35011 | 223 | 3 |
1792443 | 1792443 | 2021-10-07 | Doña Ana | New Mexico | 35013 | 29147 | 525 |
1792444 | 1792444 | 2021-10-07 | Eddy | New Mexico | 35015 | 10507 | 191 |
1792445 | 1792445 | 2021-10-07 | Grant | New Mexico | 35017 | 2166 | 48 |
1792446 | 1792446 | 2021-10-07 | Guadalupe | New Mexico | 35019 | 851 | 15 |
1792447 | 1792447 | 2021-10-07 | Harding | New Mexico | 35021 | 29 | 2 |
1792448 | 1792448 | 2021-10-07 | Hidalgo | New Mexico | 35023 | 547 | 11 |
1792449 | 1792449 | 2021-10-07 | Lea | New Mexico | 35025 | 13963 | 256 |
1792450 | 1792450 | 2021-10-07 | Lincoln | New Mexico | 35027 | 2731 | 29 |
1792451 | 1792451 | 2021-10-07 | Los Alamos | New Mexico | 35028 | 720 | 9 |
1792452 | 1792452 | 2021-10-07 | Luna | New Mexico | 35029 | 3824 | 93 |
1792453 | 1792453 | 2021-10-07 | McKinley | New Mexico | 35031 | 14146 | 501 |
1792454 | 1792454 | 2021-10-07 | Mora | New Mexico | 35033 | 319 | 10 |
1792455 | 1792455 | 2021-10-07 | Otero | New Mexico | 35035 | 7343 | 97 |
1792456 | 1792456 | 2021-10-07 | Quay | New Mexico | 35037 | 966 | 17 |
1792457 | 1792457 | 2021-10-07 | Rio Arriba | New Mexico | 35039 | 4568 | 83 |
1792458 | 1792458 | 2021-10-07 | Roosevelt | New Mexico | 35041 | 2611 | 68 |
1792459 | 1792459 | 2021-10-07 | San Juan | New Mexico | 35045 | 19183 | 537 |
1792460 | 1792460 | 2021-10-07 | San Miguel | New Mexico | 35047 | 2448 | 21 |
1792461 | 1792461 | 2021-10-07 | Sandoval | New Mexico | 35043 | 15186 | 267 |
1792462 | 1792462 | 2021-10-07 | Santa Fe | New Mexico | 35049 | 12793 | 166 |
1792463 | 1792463 | 2021-10-07 | Sierra | New Mexico | 35051 | 982 | 54 |
1792464 | 1792464 | 2021-10-07 | Socorro | New Mexico | 35053 | 1621 | 62 |
1792465 | 1792465 | 2021-10-07 | Taos | New Mexico | 35055 | 2259 | 62 |
1792466 | 1792466 | 2021-10-07 | Torrance | New Mexico | 35057 | 1663 | 18 |
1792467 | 1792467 | 2021-10-07 | Union | New Mexico | 35059 | 504 | 11 |
1792468 | 1792468 | 2021-10-07 | Valencia | New Mexico | 35061 | 9046 | 138 |
1792469 | 1792469 | 2021-10-07 | Albany | New York | 36001 | 29671 | 375 |
1792470 | 1792470 | 2021-10-07 | Allegany | New York | 36003 | 4290 | 93 |
1792471 | 1792471 | 2021-10-07 | Broome | New York | 36007 | 23108 | 395 |
1792472 | 1792472 | 2021-10-07 | Cattaraugus | New York | 36009 | 7170 | 105 |
1792473 | 1792473 | 2021-10-07 | Cayuga | New York | 36011 | 8296 | 106 |
1792474 | 1792474 | 2021-10-07 | Chautauqua | New York | 36013 | 11824 | 164 |
1792475 | 1792475 | 2021-10-07 | Chemung | New York | 36015 | 10020 | 150 |
1792476 | 1792476 | 2021-10-07 | Chenango | New York | 36017 | 4419 | 86 |
1792477 | 1792477 | 2021-10-07 | Clinton | New York | 36019 | 6288 | 36 |
1792478 | 1792478 | 2021-10-07 | Columbia | New York | 36021 | 4856 | 110 |
1792479 | 1792479 | 2021-10-07 | Cortland | New York | 36023 | 5111 | 76 |
1792480 | 1792480 | 2021-10-07 | Delaware | New York | 36025 | 3329 | 42 |
1792481 | 1792481 | 2021-10-07 | Dutchess | New York | 36027 | 34772 | 493 |
1792482 | 1792482 | 2021-10-07 | Erie | New York | 36029 | 102820 | 1913 |
1792483 | 1792483 | 2021-10-07 | Essex | New York | 36031 | 2135 | 30 |
1792484 | 1792484 | 2021-10-07 | Franklin | New York | 36033 | 3934 | 19 |
1792485 | 1792485 | 2021-10-07 | Fulton | New York | 36035 | 5919 | 99 |
1792486 | 1792486 | 2021-10-07 | Genesee | New York | 36037 | 6573 | 132 |
1792487 | 1792487 | 2021-10-07 | Greene | New York | 36039 | 4205 | 85 |
1792488 | 1792488 | 2021-10-07 | Hamilton | New York | 36041 | 424 | 3 |
1792489 | 1792489 | 2021-10-07 | Herkimer | New York | 36043 | 6354 | 120 |
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);