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 193,009
- Georgia 124,569
- Virginia 102,862
- Kentucky 92,332
- Missouri 89,366
- Illinois 79,296
- Kansas 79,082
- North Carolina 77,609
- Iowa 76,870
- Tennessee 74,527
- Indiana 71,735
- Nebraska 69,067
- Ohio 68,923
- Minnesota 67,707
- Michigan 65,034
- Mississippi 63,981
- Oklahoma 59,767
- Arkansas 58,880
- Puerto Rico 58,239
- Wisconsin 55,921
- Florida 53,226
- Pennsylvania 52,307
- Alabama 52,178
- Louisiana 50,772
- South Dakota 49,420
- Colorado 49,399
- California 45,577
- New York 45,576
- West Virginia 42,138
- Montana 40,544
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499470 | 2499470 | 2022-05-12 | Taylor | West Virginia | 54091 | 4580 | 73 |
2499471 | 2499471 | 2022-05-12 | Tucker | West Virginia | 54093 | 2023 | 38 |
2499472 | 2499472 | 2022-05-12 | Tyler | West Virginia | 54095 | 2214 | 32 |
2499473 | 2499473 | 2022-05-12 | Upshur | West Virginia | 54097 | 6918 | 95 |
2499474 | 2499474 | 2022-05-12 | Wayne | West Virginia | 54099 | 9904 | 125 |
2499475 | 2499475 | 2022-05-12 | Webster | West Virginia | 54101 | 2272 | 33 |
2499476 | 2499476 | 2022-05-12 | Wetzel | West Virginia | 54103 | 4364 | 86 |
2499477 | 2499477 | 2022-05-12 | Wirt | West Virginia | 54105 | 1455 | 25 |
2499478 | 2499478 | 2022-05-12 | Wood | West Virginia | 54107 | 22301 | 346 |
2499479 | 2499479 | 2022-05-12 | Wyoming | West Virginia | 54109 | 7042 | 116 |
2499480 | 2499480 | 2022-05-12 | Adams | Wisconsin | 55001 | 4727 | 61 |
2499481 | 2499481 | 2022-05-12 | Ashland | Wisconsin | 55003 | 3357 | 36 |
2499482 | 2499482 | 2022-05-12 | Barron | Wisconsin | 55005 | 13732 | 144 |
2499483 | 2499483 | 2022-05-12 | Bayfield | Wisconsin | 55007 | 3417 | 41 |
2499484 | 2499484 | 2022-05-12 | Brown | Wisconsin | 55009 | 85571 | 557 |
2499485 | 2499485 | 2022-05-12 | Buffalo | Wisconsin | 55011 | 3604 | 12 |
2499486 | 2499486 | 2022-05-12 | Burnett | Wisconsin | 55013 | 4052 | 43 |
2499487 | 2499487 | 2022-05-12 | Calumet | Wisconsin | 55015 | 14741 | 121 |
2499488 | 2499488 | 2022-05-12 | Chippewa | Wisconsin | 55017 | 19093 | 187 |
2499489 | 2499489 | 2022-05-12 | Clark | Wisconsin | 55019 | 7688 | 122 |
2499490 | 2499490 | 2022-05-12 | Columbia | Wisconsin | 55021 | 15792 | 128 |
2499491 | 2499491 | 2022-05-12 | Crawford | Wisconsin | 55023 | 4291 | 28 |
2499492 | 2499492 | 2022-05-12 | Dane | Wisconsin | 55025 | 134092 | 516 |
2499493 | 2499493 | 2022-05-12 | Dodge | Wisconsin | 55027 | 27541 | 340 |
2499494 | 2499494 | 2022-05-12 | Door | Wisconsin | 55029 | 7085 | 71 |
2499495 | 2499495 | 2022-05-12 | Douglas | Wisconsin | 55031 | 11964 | 79 |
2499496 | 2499496 | 2022-05-12 | Dunn | Wisconsin | 55033 | 13598 | 75 |
2499497 | 2499497 | 2022-05-12 | Eau Claire | Wisconsin | 55035 | 31278 | 187 |
2499498 | 2499498 | 2022-05-12 | Florence | Wisconsin | 55037 | 1091 | 17 |
2499499 | 2499499 | 2022-05-12 | Fond du Lac | Wisconsin | 55039 | 32473 | 277 |
2499500 | 2499500 | 2022-05-12 | Forest | Wisconsin | 55041 | 2692 | 52 |
2499501 | 2499501 | 2022-05-12 | Grant | Wisconsin | 55043 | 12930 | 146 |
2499502 | 2499502 | 2022-05-12 | Green | Wisconsin | 55045 | 9504 | 54 |
2499503 | 2499503 | 2022-05-12 | Green Lake | Wisconsin | 55047 | 5260 | 64 |
2499504 | 2499504 | 2022-05-12 | Iowa | Wisconsin | 55049 | 5420 | 29 |
2499505 | 2499505 | 2022-05-12 | Iron | Wisconsin | 55051 | 1481 | 47 |
2499506 | 2499506 | 2022-05-12 | Jackson | Wisconsin | 55053 | 5731 | 43 |
2499507 | 2499507 | 2022-05-12 | Jefferson | Wisconsin | 55055 | 21985 | 243 |
2499508 | 2499508 | 2022-05-12 | Juneau | Wisconsin | 55057 | 7846 | 68 |
2499509 | 2499509 | 2022-05-12 | Kenosha | Wisconsin | 55059 | 45207 | 631 |
2499510 | 2499510 | 2022-05-12 | Kewaunee | Wisconsin | 55061 | 5922 | 59 |
2499511 | 2499511 | 2022-05-12 | La Crosse | Wisconsin | 55063 | 35922 | 186 |
2499512 | 2499512 | 2022-05-12 | Lafayette | Wisconsin | 55065 | 3727 | 26 |
2499513 | 2499513 | 2022-05-12 | Langlade | Wisconsin | 55067 | 5287 | 92 |
2499514 | 2499514 | 2022-05-12 | Lincoln | Wisconsin | 55069 | 7174 | 148 |
2499515 | 2499515 | 2022-05-12 | Manitowoc | Wisconsin | 55071 | 20776 | 189 |
2499516 | 2499516 | 2022-05-12 | Marathon | Wisconsin | 55073 | 40243 | 491 |
2499517 | 2499517 | 2022-05-12 | Marinette | Wisconsin | 55075 | 11750 | 127 |
2499518 | 2499518 | 2022-05-12 | Marquette | Wisconsin | 55077 | 3868 | 61 |
2499519 | 2499519 | 2022-05-12 | Menominee | Wisconsin | 55078 | 1980 | 14 |
2499520 | 2499520 | 2022-05-12 | Milwaukee | Wisconsin | 55079 | 276952 | 2291 |
2499521 | 2499521 | 2022-05-12 | Monroe | Wisconsin | 55081 | 12289 | 91 |
2499522 | 2499522 | 2022-05-12 | Oconto | Wisconsin | 55083 | 11513 | 120 |
2499523 | 2499523 | 2022-05-12 | Oneida | Wisconsin | 55085 | 8599 | 139 |
2499524 | 2499524 | 2022-05-12 | Outagamie | Wisconsin | 55087 | 55265 | 406 |
2499525 | 2499525 | 2022-05-12 | Ozaukee | Wisconsin | 55089 | 23109 | 186 |
2499526 | 2499526 | 2022-05-12 | Pepin | Wisconsin | 55091 | 1999 | 18 |
2499527 | 2499527 | 2022-05-12 | Pierce | Wisconsin | 55093 | 11864 | 73 |
2499528 | 2499528 | 2022-05-12 | Polk | Wisconsin | 55095 | 12677 | 122 |
2499529 | 2499529 | 2022-05-12 | Portage | Wisconsin | 55097 | 18449 | 161 |
2499530 | 2499530 | 2022-05-12 | Price | Wisconsin | 55099 | 3281 | 33 |
2499531 | 2499531 | 2022-05-12 | Racine | Wisconsin | 55101 | 57597 | 690 |
2499532 | 2499532 | 2022-05-12 | Richland | Wisconsin | 55103 | 3988 | 48 |
2499533 | 2499533 | 2022-05-12 | Rock | Wisconsin | 55105 | 44224 | 395 |
2499534 | 2499534 | 2022-05-12 | Rusk | Wisconsin | 55107 | 3464 | 55 |
2499535 | 2499535 | 2022-05-12 | Sauk | Wisconsin | 55111 | 16447 | 136 |
2499536 | 2499536 | 2022-05-12 | Sawyer | Wisconsin | 55113 | 4634 | 62 |
2499537 | 2499537 | 2022-05-12 | Shawano | Wisconsin | 55115 | 11974 | 152 |
2499538 | 2499538 | 2022-05-12 | Sheboygan | Wisconsin | 55117 | 33044 | 320 |
2499539 | 2499539 | 2022-05-12 | St. Croix | Wisconsin | 55109 | 25600 | 149 |
2499540 | 2499540 | 2022-05-12 | Taylor | Wisconsin | 55119 | 4883 | 72 |
2499541 | 2499541 | 2022-05-12 | Trempealeau | Wisconsin | 55121 | 8545 | 65 |
2499542 | 2499542 | 2022-05-12 | Vernon | Wisconsin | 55123 | 6238 | 98 |
2499543 | 2499543 | 2022-05-12 | Vilas | Wisconsin | 55125 | 5268 | 89 |
2499544 | 2499544 | 2022-05-12 | Walworth | Wisconsin | 55127 | 27295 | 281 |
2499545 | 2499545 | 2022-05-12 | Washburn | Wisconsin | 55129 | 4073 | 46 |
2499546 | 2499546 | 2022-05-12 | Washington | Wisconsin | 55131 | 38921 | 344 |
2499547 | 2499547 | 2022-05-12 | Waukesha | Wisconsin | 55133 | 115657 | 1093 |
2499548 | 2499548 | 2022-05-12 | Waupaca | Wisconsin | 55135 | 13807 | 252 |
2499549 | 2499549 | 2022-05-12 | Waushara | Wisconsin | 55137 | 6510 | 87 |
2499550 | 2499550 | 2022-05-12 | Winnebago | Wisconsin | 55139 | 52971 | 381 |
2499551 | 2499551 | 2022-05-12 | Wood | Wisconsin | 55141 | 21430 | 233 |
2499552 | 2499552 | 2022-05-12 | Albany | Wyoming | 56001 | 9934 | 49 |
2499553 | 2499553 | 2022-05-12 | Big Horn | Wyoming | 56003 | 2586 | 61 |
2499554 | 2499554 | 2022-05-12 | Campbell | Wyoming | 56005 | 12113 | 149 |
2499555 | 2499555 | 2022-05-12 | Carbon | Wyoming | 56007 | 4627 | 52 |
2499556 | 2499556 | 2022-05-12 | Converse | Wyoming | 56009 | 3144 | 55 |
2499557 | 2499557 | 2022-05-12 | Crook | Wyoming | 56011 | 1351 | 29 |
2499558 | 2499558 | 2022-05-12 | Fremont | Wyoming | 56013 | 13795 | 193 |
2499559 | 2499559 | 2022-05-12 | Goshen | Wyoming | 56015 | 3646 | 57 |
2499560 | 2499560 | 2022-05-12 | Hot Springs | Wyoming | 56017 | 1159 | 16 |
2499561 | 2499561 | 2022-05-12 | Johnson | Wyoming | 56019 | 1845 | 19 |
2499562 | 2499562 | 2022-05-12 | Laramie | Wyoming | 56021 | 26292 | 290 |
2499563 | 2499563 | 2022-05-12 | Lincoln | Wyoming | 56023 | 3979 | 31 |
2499564 | 2499564 | 2022-05-12 | Natrona | Wyoming | 56025 | 22380 | 273 |
2499565 | 2499565 | 2022-05-12 | Niobrara | Wyoming | 56027 | 694 | 10 |
2499566 | 2499566 | 2022-05-12 | Park | Wyoming | 56029 | 6801 | 144 |
2499567 | 2499567 | 2022-05-12 | Platte | Wyoming | 56031 | 1911 | 41 |
2499568 | 2499568 | 2022-05-12 | Sheridan | Wyoming | 56033 | 8097 | 78 |
2499569 | 2499569 | 2022-05-12 | Sublette | Wyoming | 56035 | 1926 | 27 |
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);