ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
101 rows where cases = 4763 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Pennsylvania 14
- Oklahoma 7
- Minnesota 6
- Mississippi 6
- Illinois 5
- Kentucky 5
- Virginia 5
- Alabama 4
- Indiana 4
- Michigan 4
- Tennessee 4
- Colorado 3
- Georgia 3
- Missouri 3
- North Carolina 3
- Texas 3
- Kansas 2
- Louisiana 2
- New York 2
- Puerto Rico 2
- Wisconsin 2
- Arkansas 1
- Florida 1
- Iowa 1
- Maryland 1
- Massachusetts 1
- New Jersey 1
- Ohio 1
- Oregon 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426847 | 2426847 | 2022-04-20 | Craig | Oklahoma | 40035 | 4763 | 54 |
2423591 | 2423591 | 2022-04-19 | Craig | Oklahoma | 40035 | 4763 | 54 |
2420334 | 2420334 | 2022-04-18 | Craig | Oklahoma | 40035 | 4763 | 54 |
2417079 | 2417079 | 2022-04-17 | Craig | Oklahoma | 40035 | 4763 | 54 |
2413823 | 2413823 | 2022-04-16 | Craig | Oklahoma | 40035 | 4763 | 54 |
2410567 | 2410567 | 2022-04-15 | Craig | Oklahoma | 40035 | 4763 | 54 |
2407311 | 2407311 | 2022-04-14 | Craig | Oklahoma | 40035 | 4763 | 54 |
2398892 | 2398892 | 2022-04-12 | Elbert | Colorado | 8039 | 4763 | 37 |
2371637 | 2371637 | 2022-04-03 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2372038 | 2372038 | 2022-04-03 | Fayette | Texas | 48149 | 4763 | 104 |
2368384 | 2368384 | 2022-04-02 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2368785 | 2368785 | 2022-04-02 | Fayette | Texas | 48149 | 4763 | 104 |
2365131 | 2365131 | 2022-04-01 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2361878 | 2361878 | 2022-03-31 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2356712 | 2356712 | 2022-03-30 | Appling | Georgia | 13001 | 4763 | 123 |
2358624 | 2358624 | 2022-03-30 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2355370 | 2355370 | 2022-03-29 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2352117 | 2352117 | 2022-03-28 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2348865 | 2348865 | 2022-03-27 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2345612 | 2345612 | 2022-03-26 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2342359 | 2342359 | 2022-03-25 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2339106 | 2339106 | 2022-03-24 | Juniata | Pennsylvania | 42067 | 4763 | 175 |
2269777 | 2269777 | 2022-03-03 | Iosco | Michigan | 26069 | 4763 | 134 |
2266524 | 2266524 | 2022-03-02 | Iosco | Michigan | 26069 | 4763 | 134 |
2261700 | 2261700 | 2022-02-28 | Colonial Heights city | Virginia | 51570 | 4763 | 90 |
2243935 | 2243935 | 2022-02-23 | Jasper | Mississippi | 28061 | 4763 | 71 |
2214311 | 2214311 | 2022-02-14 | McCreary | Kentucky | 21147 | 4763 | 73 |
2216447 | 2216447 | 2022-02-14 | Taylor | Wisconsin | 55119 | 4763 | 66 |
2083866 | 2083866 | 2022-01-05 | LaGrange | Indiana | 18087 | 4763 | 95 |
2084600 | 2084600 | 2022-01-05 | Sunflower | Mississippi | 28133 | 4763 | 110 |
2030266 | 2030266 | 2021-12-19 | Trujillo Alto | Puerto Rico | 72139 | 4763 | |
2015276 | 2015276 | 2021-12-15 | Chattooga | Georgia | 13055 | 4763 | 108 |
1998751 | 1998751 | 2021-12-10 | Johnson | Arkansas | 5071 | 4763 | 61 |
1992730 | 1992730 | 2021-12-08 | Fayette | Illinois | 17051 | 4763 | 74 |
1942683 | 1942683 | 2021-11-22 | McNairy | Tennessee | 47109 | 4763 | 71 |
1938288 | 1938288 | 2021-11-21 | Itawamba | Mississippi | 28057 | 4763 | 107 |
1935038 | 1935038 | 2021-11-20 | Itawamba | Mississippi | 28057 | 4763 | 107 |
1931788 | 1931788 | 2021-11-19 | Itawamba | Mississippi | 28057 | 4763 | 107 |
1927159 | 1927159 | 2021-11-18 | Winston | Alabama | 1133 | 4763 | 107 |
1928216 | 1928216 | 2021-11-18 | Allen | Louisiana | 22003 | 4763 | 117 |
1909498 | 1909498 | 2021-11-12 | Wyoming | New York | 36121 | 4763 | 62 |
1882734 | 1882734 | 2021-11-04 | De Soto | Louisiana | 22031 | 4763 | 111 |
1835141 | 1835141 | 2021-10-20 | Clinton | Pennsylvania | 42035 | 4763 | 73 |
1835454 | 1835454 | 2021-10-20 | Overton | Tennessee | 47133 | 4763 | 79 |
1808219 | 1808219 | 2021-10-12 | Freeborn | Minnesota | 27047 | 4763 | 42 |
1781648 | 1781648 | 2021-10-04 | Ripley | Indiana | 18137 | 4763 | 81 |
1767057 | 1767057 | 2021-09-29 | Clarendon | South Carolina | 45027 | 4763 | 134 |
1720724 | 1720724 | 2021-09-15 | Pulaski | Missouri | 29169 | 4763 | 68 |
1700613 | 1700613 | 2021-09-09 | Montgomery | Kansas | 20125 | 4763 | 95 |
1697364 | 1697364 | 2021-09-08 | Montgomery | Kansas | 20125 | 4763 | 95 |
1697613 | 1697613 | 2021-09-08 | Calvert | Maryland | 24009 | 4763 | 90 |
1694165 | 1694165 | 2021-09-07 | Bell | Kentucky | 21013 | 4763 | 68 |
1695724 | 1695724 | 2021-09-07 | Henderson | Tennessee | 47077 | 4763 | 82 |
1655757 | 1655757 | 2021-08-26 | Polk | Missouri | 29167 | 4763 | 51 |
1650156 | 1650156 | 2021-08-24 | Codington | South Dakota | 46029 | 4763 | 82 |
1639829 | 1639829 | 2021-08-21 | Tompkins | New York | 36109 | 4763 | 55 |
1576229 | 1576229 | 2021-08-02 | Covington | Alabama | 1039 | 4763 | 125 |
1569724 | 1569724 | 2021-07-31 | Chilton | Alabama | 1021 | 4763 | 117 |
1553184 | 1553184 | 2021-07-25 | Culpeper | Virginia | 51047 | 4763 | 67 |
1549937 | 1549937 | 2021-07-24 | Culpeper | Virginia | 51047 | 4763 | 67 |
1546690 | 1546690 | 2021-07-23 | Culpeper | Virginia | 51047 | 4763 | 67 |
1506114 | 1506114 | 2021-07-11 | Douglas | Minnesota | 27041 | 4763 | 81 |
1502868 | 1502868 | 2021-07-10 | Douglas | Minnesota | 27041 | 4763 | 81 |
1499622 | 1499622 | 2021-07-09 | Douglas | Minnesota | 27041 | 4763 | 81 |
1493704 | 1493704 | 2021-07-07 | Chatham | North Carolina | 37037 | 4763 | 89 |
1441761 | 1441761 | 2021-06-21 | Beaufort | North Carolina | 37013 | 4763 | 100 |
1425755 | 1425755 | 2021-06-16 | Shelby | Ohio | 39149 | 4763 | 95 |
1425865 | 1425865 | 2021-06-16 | Klamath | Oregon | 41035 | 4763 | 78 |
1414508 | 1414508 | 2021-06-13 | Effingham | Illinois | 17049 | 4763 | 83 |
1411263 | 1411263 | 2021-06-12 | Effingham | Illinois | 17049 | 4763 | 83 |
1408018 | 1408018 | 2021-06-11 | Effingham | Illinois | 17049 | 4763 | 83 |
1409790 | 1409790 | 2021-06-11 | Toa Alta | Puerto Rico | 72135 | 4763 | |
1400771 | 1400771 | 2021-06-08 | Jefferson | West Virginia | 54037 | 4763 | 53 |
1375363 | 1375363 | 2021-06-01 | Colquitt | Georgia | 13071 | 4763 | 124 |
1334037 | 1334037 | 2021-05-19 | Newaygo | Michigan | 26123 | 4763 | 64 |
1311358 | 1311358 | 2021-05-12 | Goodhue | Minnesota | 27049 | 4763 | 72 |
1298567 | 1298567 | 2021-05-08 | Johnson | Missouri | 29101 | 4763 | 54 |
1216704 | 1216704 | 2021-04-13 | Marshall | Iowa | 19127 | 4763 | 74 |
1199585 | 1199585 | 2021-04-07 | Campbell | Wyoming | 56005 | 4763 | 60 |
1180756 | 1180756 | 2021-04-02 | Jackson | Illinois | 17077 | 4763 | 73 |
1181538 | 1181538 | 2021-04-02 | Bolivar | Mississippi | 28011 | 4763 | 128 |
1176893 | 1176893 | 2021-04-01 | Dale | Alabama | 1045 | 4763 | 109 |
1145651 | 1145651 | 2021-03-22 | Branch | Michigan | 26023 | 4763 | 111 |
1094259 | 1094259 | 2021-03-06 | Salem | New Jersey | 34033 | 4763 | 166 |
1015897 | 1015897 | 2021-02-10 | Chisago | Minnesota | 27025 | 4763 | 43 |
1002674 | 1002674 | 2021-02-06 | Pike | Kentucky | 21195 | 4763 | 51 |
972629 | 972629 | 2021-01-28 | Garfield | Colorado | 8045 | 4763 | 36 |
897682 | 897682 | 2021-01-04 | Sauk | Wisconsin | 55111 | 4763 | 31 |
864574 | 864574 | 2020-12-25 | Gibson | Tennessee | 47053 | 4763 | 87 |
856321 | 856321 | 2020-12-23 | Warrick | Indiana | 18173 | 4763 | 87 |
808773 | 808773 | 2020-12-08 | Cleveland | North Carolina | 37045 | 4763 | 114 |
760470 | 760470 | 2020-11-23 | Lebanon | Pennsylvania | 42075 | 4763 | 103 |
755983 | 755983 | 2020-11-22 | Kenton | Kentucky | 21117 | 4763 | 62 |
650815 | 650815 | 2020-10-20 | Chesapeake city | Virginia | 51550 | 4763 | 79 |
580074 | 580074 | 2020-09-29 | Weld | Colorado | 8123 | 4763 | 150 |
582593 | 582593 | 2020-09-29 | Smith | Texas | 48423 | 4763 | 105 |
492749 | 492749 | 2020-09-02 | Santa Rosa | Florida | 12113 | 4763 | 58 |
451400 | 451400 | 2020-08-20 | Fayette | Kentucky | 21067 | 4763 | 53 |
340060 | 340060 | 2020-07-16 | Berks | Pennsylvania | 42011 | 4763 | 360 |
134394 | 134394 | 2020-05-11 | Hampden | Massachusetts | 25013 | 4763 | 458 |
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);