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,264
- Georgia 124,729
- Virginia 102,995
- Kentucky 92,452
- Missouri 89,483
- Illinois 79,399
- Kansas 79,188
- North Carolina 77,709
- Iowa 76,970
- Tennessee 74,623
- Indiana 71,828
- Nebraska 69,161
- Ohio 69,012
- Minnesota 67,795
- Michigan 65,118
- Mississippi 64,064
- Oklahoma 59,845
- Arkansas 58,880
- Puerto Rico 58,318
- Wisconsin 55,921
- Florida 53,294
- Pennsylvania 52,374
- Alabama 52,178
- Louisiana 50,837
- South Dakota 49,486
- Colorado 49,427
- New York 45,634
- California 45,577
- West Virginia 42,183
- Montana 40,600
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496598 | 2496598 | 2022-05-12 | Las Animas | Colorado | 8071 | 3634 | 43 |
2496599 | 2496599 | 2022-05-12 | Lincoln | Colorado | 8073 | 2199 | 9 |
2496600 | 2496600 | 2022-05-12 | Logan | Colorado | 8075 | 7477 | 109 |
2496601 | 2496601 | 2022-05-12 | Mesa | Colorado | 8077 | 43081 | 564 |
2496602 | 2496602 | 2022-05-12 | Mineral | Colorado | 8079 | 238 | 2 |
2496603 | 2496603 | 2022-05-12 | Moffat | Colorado | 8081 | 3062 | 52 |
2496604 | 2496604 | 2022-05-12 | Montezuma | Colorado | 8083 | 6222 | 81 |
2496605 | 2496605 | 2022-05-12 | Montrose | Colorado | 8085 | 9395 | 160 |
2496606 | 2496606 | 2022-05-12 | Morgan | Colorado | 8087 | 5734 | 138 |
2496607 | 2496607 | 2022-05-12 | Otero | Colorado | 8089 | 4319 | 130 |
2496608 | 2496608 | 2022-05-12 | Ouray | Colorado | 8091 | 882 | 6 |
2496609 | 2496609 | 2022-05-12 | Park | Colorado | 8093 | 2908 | 20 |
2496610 | 2496610 | 2022-05-12 | Phillips | Colorado | 8095 | 894 | 19 |
2496611 | 2496611 | 2022-05-12 | Pitkin | Colorado | 8097 | 6671 | 7 |
2496612 | 2496612 | 2022-05-12 | Prowers | Colorado | 8099 | 2654 | 51 |
2496613 | 2496613 | 2022-05-12 | Pueblo | Colorado | 8101 | 47647 | 802 |
2496614 | 2496614 | 2022-05-12 | Rio Blanco | Colorado | 8103 | 1694 | 13 |
2496615 | 2496615 | 2022-05-12 | Rio Grande | Colorado | 8105 | 2855 | 46 |
2496616 | 2496616 | 2022-05-12 | Routt | Colorado | 8107 | 6544 | 25 |
2496617 | 2496617 | 2022-05-12 | Saguache | Colorado | 8109 | 1202 | 12 |
2496618 | 2496618 | 2022-05-12 | San Juan | Colorado | 8111 | 203 | 0 |
2496619 | 2496619 | 2022-05-12 | San Miguel | Colorado | 8113 | 2321 | 8 |
2496620 | 2496620 | 2022-05-12 | Sedgwick | Colorado | 8115 | 490 | 11 |
2496621 | 2496621 | 2022-05-12 | Summit | Colorado | 8117 | 10081 | 14 |
2496622 | 2496622 | 2022-05-12 | Teller | Colorado | 8119 | 4894 | 57 |
2496623 | 2496623 | 2022-05-12 | Washington | Colorado | 8121 | 1065 | 28 |
2496624 | 2496624 | 2022-05-12 | Weld | Colorado | 8123 | 85569 | 703 |
2496625 | 2496625 | 2022-05-12 | Yuma | Colorado | 8125 | 1886 | 23 |
2496626 | 2496626 | 2022-05-12 | Fairfield | Connecticut | 9001 | 213432 | 2725 |
2496627 | 2496627 | 2022-05-12 | Hartford | Connecticut | 9003 | 186693 | 3144 |
2496628 | 2496628 | 2022-05-12 | Litchfield | Connecticut | 9005 | 33325 | 462 |
2496629 | 2496629 | 2022-05-12 | Middlesex | Connecticut | 9007 | 29910 | 481 |
2496630 | 2496630 | 2022-05-12 | New Haven | Connecticut | 9009 | 204937 | 2831 |
2496631 | 2496631 | 2022-05-12 | New London | Connecticut | 9011 | 57958 | 660 |
2496632 | 2496632 | 2022-05-12 | Tolland | Connecticut | 9013 | 21840 | 274 |
2496633 | 2496633 | 2022-05-12 | Unknown | Connecticut | 2375 | 1 | |
2496634 | 2496634 | 2022-05-12 | Windham | Connecticut | 9015 | 26594 | 305 |
2496635 | 2496635 | 2022-05-12 | Kent | Delaware | 10001 | 51721 | 650 |
2496636 | 2496636 | 2022-05-12 | New Castle | Delaware | 10003 | 151033 | 1423 |
2496637 | 2496637 | 2022-05-12 | Sussex | Delaware | 10005 | 63024 | 855 |
2496638 | 2496638 | 2022-05-12 | Unknown | Delaware | 895 | 0 | |
2496639 | 2496639 | 2022-05-12 | District of Columbia | District of Columbia | 11001 | 143943 | 1340 |
2496640 | 2496640 | 2022-05-12 | Alachua | Florida | 12001 | 69008 | 665 |
2496641 | 2496641 | 2022-05-12 | Baker | Florida | 12003 | 8712 | 142 |
2496642 | 2496642 | 2022-05-12 | Bay | Florida | 12005 | 45926 | 827 |
2496643 | 2496643 | 2022-05-12 | Bradford | Florida | 12007 | 7538 | 150 |
2496644 | 2496644 | 2022-05-12 | Brevard | Florida | 12009 | 135740 | 2100 |
2496645 | 2496645 | 2022-05-12 | Broward | Florida | 12011 | 614436 | 5852 |
2496646 | 2496646 | 2022-05-12 | Calhoun | Florida | 12013 | 4103 | 98 |
2496647 | 2496647 | 2022-05-12 | Charlotte | Florida | 12015 | 36528 | 812 |
2496648 | 2496648 | 2022-05-12 | Citrus | Florida | 12017 | 29988 | 976 |
2496649 | 2496649 | 2022-05-12 | Clay | Florida | 12019 | 53825 | 856 |
2496650 | 2496650 | 2022-05-12 | Collier | Florida | 12021 | 85078 | 1000 |
2496651 | 2496651 | 2022-05-12 | Columbia | Florida | 12023 | 21193 | 402 |
2496652 | 2496652 | 2022-05-12 | DeSoto | Florida | 12027 | 9455 | 150 |
2496653 | 2496653 | 2022-05-12 | Dixie | Florida | 12029 | 4046 | 70 |
2496654 | 2496654 | 2022-05-12 | Duval | Florida | 12031 | 255189 | 3410 |
2496655 | 2496655 | 2022-05-12 | Escambia | Florida | 12033 | 78190 | 1311 |
2496656 | 2496656 | 2022-05-12 | Flagler | Florida | 12035 | 22651 | 359 |
2496657 | 2496657 | 2022-05-12 | Franklin | Florida | 12037 | 3087 | 52 |
2496658 | 2496658 | 2022-05-12 | Gadsden | Florida | 12039 | 13475 | 207 |
2496659 | 2496659 | 2022-05-12 | Gilchrist | Florida | 12041 | 4562 | 93 |
2496660 | 2496660 | 2022-05-12 | Glades | Florida | 12043 | 1995 | 36 |
2496661 | 2496661 | 2022-05-12 | Gulf | Florida | 12045 | 4292 | 79 |
2496662 | 2496662 | 2022-05-12 | Hamilton | Florida | 12047 | 3841 | 56 |
2496663 | 2496663 | 2022-05-12 | Hardee | Florida | 12049 | 8696 | 124 |
2496664 | 2496664 | 2022-05-12 | Hendry | Florida | 12051 | 11773 | 160 |
2496665 | 2496665 | 2022-05-12 | Hernando | Florida | 12053 | 42396 | 1095 |
2496666 | 2496666 | 2022-05-12 | Highlands | Florida | 12055 | 24304 | 686 |
2496667 | 2496667 | 2022-05-12 | Hillsborough | Florida | 12057 | 379994 | 3793 |
2496668 | 2496668 | 2022-05-12 | Holmes | Florida | 12059 | 5429 | 87 |
2496669 | 2496669 | 2022-05-12 | Indian River | Florida | 12061 | 33156 | 654 |
2496670 | 2496670 | 2022-05-12 | Jackson | Florida | 12063 | 14854 | 280 |
2496671 | 2496671 | 2022-05-12 | Jefferson | Florida | 12065 | 3964 | 61 |
2496672 | 2496672 | 2022-05-12 | Lafayette | Florida | 12067 | 2780 | 61 |
2496673 | 2496673 | 2022-05-12 | Lake | Florida | 12069 | 86320 | 1501 |
2496674 | 2496674 | 2022-05-12 | Lee | Florida | 12071 | 191963 | 2158 |
2496675 | 2496675 | 2022-05-12 | Leon | Florida | 12073 | 85724 | 663 |
2496676 | 2496676 | 2022-05-12 | Levy | Florida | 12075 | 10284 | 169 |
2496677 | 2496677 | 2022-05-12 | Liberty | Florida | 12077 | 2507 | 30 |
2496678 | 2496678 | 2022-05-12 | Madison | Florida | 12079 | 5849 | 97 |
2496679 | 2496679 | 2022-05-12 | Manatee | Florida | 12081 | 96960 | 1434 |
2496680 | 2496680 | 2022-05-12 | Marion | Florida | 12083 | 84120 | 2105 |
2496681 | 2496681 | 2022-05-12 | Martin | Florida | 12085 | 30920 | 616 |
2496682 | 2496682 | 2022-05-12 | Miami-Dade | Florida | 12086 | 1209302 | 10921 |
2496683 | 2496683 | 2022-05-12 | Monroe | Florida | 12087 | 18412 | 119 |
2496684 | 2496684 | 2022-05-12 | Nassau | Florida | 12089 | 21949 | 294 |
2496685 | 2496685 | 2022-05-12 | Okaloosa | Florida | 12091 | 51630 | 688 |
2496686 | 2496686 | 2022-05-12 | Okeechobee | Florida | 12093 | 10649 | 183 |
2496687 | 2496687 | 2022-05-12 | Orange | Florida | 12095 | 383010 | 2835 |
2496688 | 2496688 | 2022-05-12 | Osceola | Florida | 12097 | 115328 | 1147 |
2496689 | 2496689 | 2022-05-12 | Palm Beach | Florida | 12099 | 375184 | 5059 |
2496690 | 2496690 | 2022-05-12 | Pasco | Florida | 12101 | 123993 | 1900 |
2496691 | 2496691 | 2022-05-12 | Pinellas | Florida | 12103 | 212746 | 3356 |
2496692 | 2496692 | 2022-05-12 | Polk | Florida | 12105 | 202456 | 2991 |
2496693 | 2496693 | 2022-05-12 | Putnam | Florida | 12107 | 17669 | 424 |
2496694 | 2496694 | 2022-05-12 | Santa Rosa | Florida | 12113 | 48592 | 621 |
2496695 | 2496695 | 2022-05-12 | Sarasota | Florida | 12115 | 91416 | 1620 |
2496696 | 2496696 | 2022-05-12 | Seminole | Florida | 12117 | 105227 | 1096 |
2496697 | 2496697 | 2022-05-12 | St. Johns | Florida | 12109 | 63143 | 567 |
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);