ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
121 rows where cases = 3371 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 11
- Indiana 10
- Mississippi 8
- Iowa 7
- Georgia 6
- Missouri 6
- South Dakota 5
- Wisconsin 5
- Wyoming 5
- Idaho 4
- North Carolina 4
- Pennsylvania 4
- West Virginia 4
- Alabama 3
- Arkansas 3
- New York 3
- Ohio 3
- Tennessee 3
- Kansas 2
- Louisiana 2
- New Mexico 2
- Oregon 2
- Puerto Rico 2
- South Carolina 2
- Virginia 2
- Arizona 1
- California 1
- Colorado 1
- Florida 1
- Illinois 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2469242 | 2469242 | 2022-05-03 | Curry | Oregon | 41015 | 3371 | 54 |
2430625 | 2430625 | 2022-04-21 | Duval | Texas | 48131 | 3371 | 70 |
2354819 | 2354819 | 2022-03-29 | Seward | Nebraska | 31159 | 3371 | 41 |
2287617 | 2287617 | 2022-03-08 | Tyler | Texas | 48457 | 3371 | 83 |
2277401 | 2277401 | 2022-03-05 | Salinas | Puerto Rico | 72123 | 3371 | |
2263488 | 2263488 | 2022-03-01 | Webster | Mississippi | 28155 | 3371 | 68 |
2247631 | 2247631 | 2022-02-24 | Schuyler | New York | 36097 | 3371 | 24 |
2222155 | 2222155 | 2022-02-16 | Bamberg | South Carolina | 45009 | 3371 | 71 |
2216885 | 2216885 | 2022-02-15 | Brooks | Georgia | 13027 | 3371 | 80 |
2182740 | 2182740 | 2022-02-04 | Ramsey | North Dakota | 38071 | 3371 | 48 |
2171786 | 2171786 | 2022-02-01 | Iowa | Iowa | 19095 | 3371 | 42 |
2168533 | 2168533 | 2022-01-31 | Iowa | Iowa | 19095 | 3371 | 42 |
2170167 | 2170167 | 2022-01-31 | Clay | South Dakota | 46027 | 3371 | 19 |
2165278 | 2165278 | 2022-01-30 | Iowa | Iowa | 19095 | 3371 | 42 |
2162023 | 2162023 | 2022-01-29 | Iowa | Iowa | 19095 | 3371 | 42 |
2158768 | 2158768 | 2022-01-28 | Iowa | Iowa | 19095 | 3371 | 42 |
2155514 | 2155514 | 2022-01-27 | Iowa | Iowa | 19095 | 3371 | 42 |
2156272 | 2156272 | 2022-01-27 | Ste. Genevieve | Missouri | 29186 | 3371 | 35 |
2152182 | 2152182 | 2022-01-26 | Parke | Indiana | 18121 | 3371 | 41 |
2152261 | 2152261 | 2022-01-26 | Iowa | Iowa | 19095 | 3371 | 42 |
2150540 | 2150540 | 2022-01-25 | Lares | Puerto Rico | 72081 | 3371 | |
2126574 | 2126574 | 2022-01-18 | Winn | Louisiana | 22127 | 3371 | 58 |
2122031 | 2122031 | 2022-01-16 | Taylor | West Virginia | 54091 | 3371 | 56 |
2118785 | 2118785 | 2022-01-15 | Wetzel | West Virginia | 54103 | 3371 | 68 |
2106469 | 2106469 | 2022-01-12 | Minidoka | Idaho | 16067 | 3371 | 54 |
2087082 | 2087082 | 2022-01-06 | Carroll | Indiana | 18015 | 3371 | 48 |
2079898 | 2079898 | 2022-01-04 | Henry | Alabama | 1067 | 3371 | 67 |
2067038 | 2067038 | 2021-12-31 | Sharp | Arkansas | 5135 | 3371 | 78 |
2038814 | 2038814 | 2021-12-22 | Waldo | Maine | 23027 | 3371 | 37 |
2034324 | 2034324 | 2021-12-20 | Sawyer | Wisconsin | 55113 | 3371 | 42 |
1993710 | 1993710 | 2021-12-08 | Texas | Missouri | 29215 | 3371 | 65 |
1988174 | 1988174 | 2021-12-06 | Humphreys | Tennessee | 47085 | 3371 | 50 |
1921373 | 1921373 | 2021-11-16 | Starke | Indiana | 18149 | 3371 | 74 |
1905884 | 1905884 | 2021-11-11 | Henry | Missouri | 29083 | 3371 | 51 |
1902635 | 1902635 | 2021-11-10 | Henry | Missouri | 29083 | 3371 | 51 |
1883747 | 1883747 | 2021-11-04 | Wyandot | Ohio | 39175 | 3371 | 62 |
1876545 | 1876545 | 2021-11-02 | Jasper | Mississippi | 28061 | 3371 | 65 |
1837375 | 1837375 | 2021-10-21 | Emmet | Michigan | 26047 | 3371 | 49 |
1832294 | 1832294 | 2021-10-19 | Deaf Smith | Texas | 48117 | 3371 | 75 |
1827595 | 1827595 | 2021-10-18 | Franklin | Massachusetts | 25011 | 3371 | 122 |
1799751 | 1799751 | 2021-10-09 | Austin | Texas | 48015 | 3371 | 50 |
1794032 | 1794032 | 2021-10-08 | Ouachita | Arkansas | 5103 | 3371 | 76 |
1790496 | 1790496 | 2021-10-06 | Mason | West Virginia | 54053 | 3371 | 49 |
1741883 | 1741883 | 2021-09-21 | Uinta | Wyoming | 56041 | 3371 | 23 |
1693584 | 1693584 | 2021-09-07 | Cook | Georgia | 13075 | 3371 | 49 |
1676140 | 1676140 | 2021-09-01 | Davison | South Dakota | 46035 | 3371 | 69 |
1671138 | 1671138 | 2021-08-31 | Fayette | Indiana | 18041 | 3371 | 69 |
1673497 | 1673497 | 2021-08-31 | Okanogan | Washington | 53047 | 3371 | 46 |
1666421 | 1666421 | 2021-08-29 | Lawrence | South Dakota | 46081 | 3371 | 50 |
1667159 | 1667159 | 2021-08-29 | Park | Wyoming | 56029 | 3371 | 37 |
1663173 | 1663173 | 2021-08-28 | Lawrence | South Dakota | 46081 | 3371 | 50 |
1663911 | 1663911 | 2021-08-28 | Park | Wyoming | 56029 | 3371 | 37 |
1659925 | 1659925 | 2021-08-27 | Lawrence | South Dakota | 46081 | 3371 | 50 |
1660663 | 1660663 | 2021-08-27 | Park | Wyoming | 56029 | 3371 | 37 |
1637488 | 1637488 | 2021-08-20 | Palo Pinto | Texas | 48363 | 3371 | 83 |
1627699 | 1627699 | 2021-08-17 | Kleberg | Texas | 48273 | 3371 | 97 |
1623164 | 1623164 | 2021-08-16 | Prentiss | Mississippi | 28117 | 3371 | 64 |
1621632 | 1621632 | 2021-08-15 | Lincoln | Wisconsin | 55069 | 3371 | 97 |
1618384 | 1618384 | 2021-08-14 | Lincoln | Wisconsin | 55069 | 3371 | 97 |
1615136 | 1615136 | 2021-08-13 | Lincoln | Wisconsin | 55069 | 3371 | 97 |
1598002 | 1598002 | 2021-08-08 | Jefferson | Pennsylvania | 42065 | 3371 | 99 |
1594753 | 1594753 | 2021-08-07 | Jefferson | Pennsylvania | 42065 | 3371 | 99 |
1563702 | 1563702 | 2021-07-29 | Madison | Georgia | 13195 | 3371 | 56 |
1543781 | 1543781 | 2021-07-23 | Marion | Alabama | 1093 | 3371 | 106 |
1512055 | 1512055 | 2021-07-13 | White | Indiana | 18181 | 3371 | 55 |
1495771 | 1495771 | 2021-07-08 | Jefferson | Indiana | 18077 | 3371 | 87 |
1438076 | 1438076 | 2021-06-20 | Pike | Mississippi | 28113 | 3371 | 111 |
1434829 | 1434829 | 2021-06-19 | Pike | Mississippi | 28113 | 3371 | 111 |
1431582 | 1431582 | 2021-06-18 | Pike | Mississippi | 28113 | 3371 | 111 |
1422202 | 1422202 | 2021-06-15 | Luna | New Mexico | 35029 | 3371 | 92 |
1311984 | 1311984 | 2021-05-12 | Person | North Carolina | 37145 | 3371 | 70 |
1262861 | 1262861 | 2021-04-27 | Lawrence | Missouri | 29109 | 3371 | 81 |
1248848 | 1248848 | 2021-04-23 | Toombs | Georgia | 13279 | 3371 | 112 |
1246084 | 1246084 | 2021-04-22 | Boyle | Kentucky | 21021 | 3371 | 69 |
1235620 | 1235620 | 2021-04-19 | Montrose | Colorado | 8085 | 3371 | 57 |
1211136 | 1211136 | 2021-04-11 | Grafton | New Hampshire | 33009 | 3371 | 21 |
1208415 | 1208415 | 2021-04-10 | Perry | Pennsylvania | 42099 | 3371 | 94 |
1187351 | 1187351 | 2021-04-04 | Jasper | Indiana | 18073 | 3371 | 48 |
1183688 | 1183688 | 2021-04-03 | Baker | Florida | 12003 | 3371 | 61 |
1170177 | 1170177 | 2021-03-29 | Tazewell | Virginia | 51185 | 3371 | 64 |
1145100 | 1145100 | 2021-03-22 | Adams | Indiana | 18001 | 3371 | 52 |
1143245 | 1143245 | 2021-03-21 | Highland | Ohio | 39071 | 3371 | 56 |
1132198 | 1132198 | 2021-03-18 | Wabash | Indiana | 18169 | 3371 | 77 |
1114179 | 1114179 | 2021-03-12 | Malheur | Oregon | 41045 | 3371 | 58 |
1109825 | 1109825 | 2021-03-11 | Evangeline | Louisiana | 22039 | 3371 | 81 |
1096289 | 1096289 | 2021-03-07 | Nez Perce | Idaho | 16069 | 3371 | 52 |
1093043 | 1093043 | 2021-03-06 | Nez Perce | Idaho | 16069 | 3371 | 52 |
1089797 | 1089797 | 2021-03-05 | Nez Perce | Idaho | 16069 | 3371 | 52 |
1075598 | 1075598 | 2021-02-28 | White | Tennessee | 47185 | 3371 | 66 |
1065058 | 1065058 | 2021-02-25 | Cibola | New Mexico | 35006 | 3371 | 104 |
1054943 | 1054943 | 2021-02-22 | Hancock | Mississippi | 28045 | 3371 | 73 |
1052820 | 1052820 | 2021-02-21 | Hardeman | Tennessee | 47069 | 3371 | 63 |
1053118 | 1053118 | 2021-02-21 | Waller | Texas | 48473 | 3371 | 38 |
1032294 | 1032294 | 2021-02-15 | Butler | Missouri | 29023 | 3371 | 30 |
1008245 | 1008245 | 2021-02-08 | St. Francis | Arkansas | 5123 | 3371 | 36 |
988465 | 988465 | 2021-02-01 | Marion | West Virginia | 54049 | 3371 | 25 |
956577 | 956577 | 2021-01-23 | Effingham | Georgia | 13103 | 3371 | 45 |
884760 | 884760 | 2021-01-01 | Dale | Alabama | 1045 | 3371 | 63 |
865188 | 865188 | 2020-12-25 | Douglas | Wisconsin | 55031 | 3371 | 29 |
845775 | 845775 | 2020-12-19 | Albany | Wyoming | 56001 | 3371 | 9 |
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);