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 83,258
- Georgia 55,449
- Virginia 45,431
- Kentucky 40,492
- Missouri 38,821
- Illinois 34,800
- North Carolina 34,409
- Iowa 33,670
- Kansas 33,645
- Tennessee 33,055
- Indiana 31,958
- Ohio 30,475
- Minnesota 29,691
- Michigan 28,746
- Nebraska 28,535
- Mississippi 28,502
- Oklahoma 26,071
- Arkansas 26,048
- Wisconsin 24,815
- Puerto Rico 24,111
- Florida 23,850
- Pennsylvania 23,363
- Alabama 23,234
- Louisiana 22,693
- Colorado 21,751
- South Dakota 20,908
- New York 20,520
- California 20,513
- West Virginia 18,421
- North Dakota 17,063
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1095477 | 1095477 | 2021-03-06 | Prince William | Virginia | 51153 | 39868 | 450 |
1095478 | 1095478 | 2021-03-06 | Pulaski | Virginia | 51155 | 2331 | 55 |
1095479 | 1095479 | 2021-03-06 | Radford city | Virginia | 51750 | 1903 | 17 |
1095480 | 1095480 | 2021-03-06 | Rappahannock | Virginia | 51157 | 306 | 2 |
1095481 | 1095481 | 2021-03-06 | Richmond | Virginia | 51159 | 1380 | 10 |
1095482 | 1095482 | 2021-03-06 | Richmond city | Virginia | 51760 | 14990 | 215 |
1095483 | 1095483 | 2021-03-06 | Roanoke | Virginia | 51161 | 7435 | 131 |
1095484 | 1095484 | 2021-03-06 | Roanoke city | Virginia | 51770 | 7622 | 162 |
1095485 | 1095485 | 2021-03-06 | Rockbridge | Virginia | 51163 | 1309 | 40 |
1095486 | 1095486 | 2021-03-06 | Rockingham | Virginia | 51165 | 6117 | 96 |
1095487 | 1095487 | 2021-03-06 | Russell | Virginia | 51167 | 2042 | 35 |
1095488 | 1095488 | 2021-03-06 | Salem city | Virginia | 51775 | 1872 | 42 |
1095489 | 1095489 | 2021-03-06 | Scott | Virginia | 51169 | 1603 | 49 |
1095490 | 1095490 | 2021-03-06 | Shenandoah | Virginia | 51171 | 3743 | 124 |
1095491 | 1095491 | 2021-03-06 | Smyth | Virginia | 51173 | 2526 | 87 |
1095492 | 1095492 | 2021-03-06 | Southampton | Virginia | 51175 | 1860 | 52 |
1095493 | 1095493 | 2021-03-06 | Spotsylvania | Virginia | 51177 | 8418 | 102 |
1095494 | 1095494 | 2021-03-06 | Stafford | Virginia | 51179 | 9659 | 68 |
1095495 | 1095495 | 2021-03-06 | Staunton city | Virginia | 51790 | 2472 | 67 |
1095496 | 1095496 | 2021-03-06 | Suffolk city | Virginia | 51800 | 7006 | 165 |
1095497 | 1095497 | 2021-03-06 | Surry | Virginia | 51181 | 373 | 8 |
1095498 | 1095498 | 2021-03-06 | Sussex | Virginia | 51183 | 1081 | 20 |
1095499 | 1095499 | 2021-03-06 | Tazewell | Virginia | 51185 | 3233 | 60 |
1095500 | 1095500 | 2021-03-06 | Virginia Beach city | Virginia | 51810 | 31077 | 333 |
1095501 | 1095501 | 2021-03-06 | Warren | Virginia | 51187 | 2326 | 48 |
1095502 | 1095502 | 2021-03-06 | Washington | Virginia | 51191 | 4307 | 99 |
1095503 | 1095503 | 2021-03-06 | Waynesboro city | Virginia | 51820 | 2162 | 34 |
1095504 | 1095504 | 2021-03-06 | Westmoreland | Virginia | 51193 | 1124 | 21 |
1095505 | 1095505 | 2021-03-06 | Williamsburg city | Virginia | 51830 | 544 | 12 |
1095506 | 1095506 | 2021-03-06 | Winchester city | Virginia | 51840 | 2481 | 41 |
1095507 | 1095507 | 2021-03-06 | Wise | Virginia | 51195 | 2900 | 93 |
1095508 | 1095508 | 2021-03-06 | Wythe | Virginia | 51197 | 2051 | 66 |
1095509 | 1095509 | 2021-03-06 | York | Virginia | 51199 | 3104 | 39 |
1095510 | 1095510 | 2021-03-06 | Adams | Washington | 53001 | 1931 | 21 |
1095511 | 1095511 | 2021-03-06 | Asotin | Washington | 53003 | 1292 | 28 |
1095512 | 1095512 | 2021-03-06 | Benton | Washington | 53005 | 15169 | 208 |
1095513 | 1095513 | 2021-03-06 | Chelan | Washington | 53007 | 6262 | 63 |
1095514 | 1095514 | 2021-03-06 | Clallam | Washington | 53009 | 988 | 8 |
1095515 | 1095515 | 2021-03-06 | Clark | Washington | 53011 | 19142 | 232 |
1095516 | 1095516 | 2021-03-06 | Columbia | Washington | 53013 | 115 | 4 |
1095517 | 1095517 | 2021-03-06 | Cowlitz | Washington | 53015 | 4447 | 66 |
1095518 | 1095518 | 2021-03-06 | Douglas | Washington | 53017 | 3274 | 23 |
1095519 | 1095519 | 2021-03-06 | Ferry | Washington | 53019 | 210 | 4 |
1095520 | 1095520 | 2021-03-06 | Franklin | Washington | 53021 | 11247 | 101 |
1095521 | 1095521 | 2021-03-06 | Garfield | Washington | 53023 | 117 | 4 |
1095522 | 1095522 | 2021-03-06 | Grant | Washington | 53025 | 9007 | 114 |
1095523 | 1095523 | 2021-03-06 | Grays Harbor | Washington | 53027 | 3404 | 49 |
1095524 | 1095524 | 2021-03-06 | Island | Washington | 53029 | 1363 | 27 |
1095525 | 1095525 | 2021-03-06 | Jefferson | Washington | 53031 | 338 | 2 |
1095526 | 1095526 | 2021-03-06 | King | Washington | 53033 | 85017 | 1417 |
1095527 | 1095527 | 2021-03-06 | Kitsap | Washington | 53035 | 5863 | 87 |
1095528 | 1095528 | 2021-03-06 | Kittitas | Washington | 53037 | 2296 | 30 |
1095529 | 1095529 | 2021-03-06 | Klickitat | Washington | 53039 | 664 | 8 |
1095530 | 1095530 | 2021-03-06 | Lewis | Washington | 53041 | 3758 | 50 |
1095531 | 1095531 | 2021-03-06 | Lincoln | Washington | 53043 | 341 | 5 |
1095532 | 1095532 | 2021-03-06 | Mason | Washington | 53045 | 2353 | 27 |
1095533 | 1095533 | 2021-03-06 | Okanogan | Washington | 53047 | 2181 | 36 |
1095534 | 1095534 | 2021-03-06 | Pacific | Washington | 53049 | 747 | 10 |
1095535 | 1095535 | 2021-03-06 | Pend Oreille | Washington | 53051 | 639 | 7 |
1095536 | 1095536 | 2021-03-06 | Pierce | Washington | 53053 | 39037 | 563 |
1095537 | 1095537 | 2021-03-06 | San Juan | Washington | 53055 | 121 | 0 |
1095538 | 1095538 | 2021-03-06 | Skagit | Washington | 53057 | 4531 | 60 |
1095539 | 1095539 | 2021-03-06 | Skamania | Washington | 53059 | 256 | 1 |
1095540 | 1095540 | 2021-03-06 | Snohomish | Washington | 53061 | 31299 | 546 |
1095541 | 1095541 | 2021-03-06 | Spokane | Washington | 53063 | 37613 | 590 |
1095542 | 1095542 | 2021-03-06 | Stevens | Washington | 53065 | 1662 | 23 |
1095543 | 1095543 | 2021-03-06 | Thurston | Washington | 53067 | 7358 | 77 |
1095544 | 1095544 | 2021-03-06 | Wahkiakum | Washington | 53069 | 99 | 0 |
1095545 | 1095545 | 2021-03-06 | Walla Walla | Washington | 53071 | 4802 | 61 |
1095546 | 1095546 | 2021-03-06 | Whatcom | Washington | 53073 | 6953 | 85 |
1095547 | 1095547 | 2021-03-06 | Whitman | Washington | 53075 | 3434 | 45 |
1095548 | 1095548 | 2021-03-06 | Yakima | Washington | 53077 | 27971 | 425 |
1095549 | 1095549 | 2021-03-06 | Barbour | West Virginia | 54001 | 1254 | 21 |
1095550 | 1095550 | 2021-03-06 | Berkeley | West Virginia | 54003 | 9783 | 100 |
1095551 | 1095551 | 2021-03-06 | Boone | West Virginia | 54005 | 1608 | 32 |
1095552 | 1095552 | 2021-03-06 | Braxton | West Virginia | 54007 | 779 | 1 |
1095553 | 1095553 | 2021-03-06 | Brooke | West Virginia | 54009 | 2023 | 50 |
1095554 | 1095554 | 2021-03-06 | Cabell | West Virginia | 54011 | 7903 | 161 |
1095555 | 1095555 | 2021-03-06 | Calhoun | West Virginia | 54013 | 232 | 0 |
1095556 | 1095556 | 2021-03-06 | Clay | West Virginia | 54015 | 380 | 6 |
1095557 | 1095557 | 2021-03-06 | Doddridge | West Virginia | 54017 | 472 | 6 |
1095558 | 1095558 | 2021-03-06 | Fayette | West Virginia | 54019 | 2721 | 70 |
1095559 | 1095559 | 2021-03-06 | Gilmer | West Virginia | 54021 | 721 | 8 |
1095560 | 1095560 | 2021-03-06 | Grant | West Virginia | 54023 | 1084 | 26 |
1095561 | 1095561 | 2021-03-06 | Greenbrier | West Virginia | 54025 | 2423 | 52 |
1095562 | 1095562 | 2021-03-06 | Hampshire | West Virginia | 54027 | 1552 | 28 |
1095563 | 1095563 | 2021-03-06 | Hancock | West Virginia | 54029 | 2605 | 86 |
1095564 | 1095564 | 2021-03-06 | Hardy | West Virginia | 54031 | 1285 | 20 |
1095565 | 1095565 | 2021-03-06 | Harrison | West Virginia | 54033 | 4880 | 70 |
1095566 | 1095566 | 2021-03-06 | Jackson | West Virginia | 54035 | 1676 | 50 |
1095567 | 1095567 | 2021-03-06 | Jefferson | West Virginia | 54037 | 3678 | 39 |
1095568 | 1095568 | 2021-03-06 | Kanawha | West Virginia | 54039 | 12215 | 286 |
1095569 | 1095569 | 2021-03-06 | Lewis | West Virginia | 54041 | 1051 | 19 |
1095570 | 1095570 | 2021-03-06 | Lincoln | West Virginia | 54043 | 1239 | 13 |
1095571 | 1095571 | 2021-03-06 | Logan | West Virginia | 54045 | 2724 | 77 |
1095572 | 1095572 | 2021-03-06 | Marion | West Virginia | 54049 | 3726 | 34 |
1095573 | 1095573 | 2021-03-06 | Marshall | West Virginia | 54051 | 3035 | 66 |
1095574 | 1095574 | 2021-03-06 | Mason | West Virginia | 54053 | 1782 | 37 |
1095575 | 1095575 | 2021-03-06 | McDowell | West Virginia | 54047 | 1370 | 20 |
1095576 | 1095576 | 2021-03-06 | Mercer | West Virginia | 54055 | 4244 | 112 |
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);