ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
100 rows where cases = 5004 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 13
- Michigan 10
- North Carolina 9
- South Carolina 7
- Louisiana 6
- South Dakota 5
- Georgia 4
- Indiana 4
- Minnesota 4
- Wisconsin 4
- Nebraska 3
- Texas 3
- Illinois 2
- Missouri 2
- New York 2
- Ohio 2
- Oregon 2
- Tennessee 2
- Washington 2
- Arkansas 1
- Colorado 1
- Florida 1
- Maine 1
- Maryland 1
- Mississippi 1
- New Mexico 1
- Oklahoma 1
- Pennsylvania 1
- Puerto Rico 1
- Utah 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2422728 | 2422728 | 2022-04-19 | Osceola | Michigan | 26133 | 5004 | 80 |
2419472 | 2419472 | 2022-04-18 | Osceola | Michigan | 26133 | 5004 | 80 |
2416216 | 2416216 | 2022-04-17 | Osceola | Michigan | 26133 | 5004 | 80 |
2412960 | 2412960 | 2022-04-16 | Osceola | Michigan | 26133 | 5004 | 80 |
2409704 | 2409704 | 2022-04-15 | Osceola | Michigan | 26133 | 5004 | 80 |
2406448 | 2406448 | 2022-04-14 | Osceola | Michigan | 26133 | 5004 | 80 |
2403192 | 2403192 | 2022-04-13 | Osceola | Michigan | 26133 | 5004 | 80 |
2393206 | 2393206 | 2022-04-10 | Morgan | Kentucky | 21175 | 5004 | 22 |
2389950 | 2389950 | 2022-04-09 | Morgan | Kentucky | 21175 | 5004 | 22 |
2386694 | 2386694 | 2022-04-08 | Morgan | Kentucky | 21175 | 5004 | 22 |
2388260 | 2388260 | 2022-04-08 | Burleson | Texas | 48051 | 5004 | 66 |
2383439 | 2383439 | 2022-04-07 | Morgan | Kentucky | 21175 | 5004 | 22 |
2385005 | 2385005 | 2022-04-07 | Burleson | Texas | 48051 | 5004 | 66 |
2380184 | 2380184 | 2022-04-06 | Morgan | Kentucky | 21175 | 5004 | 22 |
2376929 | 2376929 | 2022-04-05 | Morgan | Kentucky | 21175 | 5004 | 22 |
2373677 | 2373677 | 2022-04-04 | Morgan | Kentucky | 21175 | 5004 | 22 |
2374480 | 2374480 | 2022-04-04 | Schoharie | New York | 36095 | 5004 | 35 |
2287023 | 2287023 | 2022-03-08 | Union | Oregon | 41061 | 5004 | 74 |
2270070 | 2270070 | 2022-03-03 | New Madrid | Missouri | 29143 | 5004 | 81 |
2255967 | 2255967 | 2022-02-27 | Jones | Georgia | 13169 | 5004 | 105 |
2252716 | 2252716 | 2022-02-26 | Jones | Georgia | 13169 | 5004 | 105 |
2249465 | 2249465 | 2022-02-25 | Jones | Georgia | 13169 | 5004 | 105 |
2240846 | 2240846 | 2022-02-22 | Vernon | Missouri | 29217 | 5004 | 99 |
2242158 | 2242158 | 2022-02-22 | Orleans | Vermont | 50019 | 5004 | 33 |
2186052 | 2186052 | 2022-02-05 | Holmes | Ohio | 39075 | 5004 | 172 |
2182800 | 2182800 | 2022-02-04 | Holmes | Ohio | 39075 | 5004 | 172 |
2177572 | 2177572 | 2022-02-03 | Columbia | Arkansas | 5027 | 5004 | 77 |
2155680 | 2155680 | 2022-01-27 | Bourbon | Kentucky | 21017 | 5004 | 45 |
2146137 | 2146137 | 2022-01-24 | Talbot | Maryland | 24041 | 5004 | 72 |
2124487 | 2124487 | 2022-01-17 | Cayey | Puerto Rico | 72035 | 5004 | |
2124555 | 2124555 | 2022-01-17 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2121303 | 2121303 | 2022-01-16 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2118051 | 2118051 | 2022-01-15 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2114800 | 2114800 | 2022-01-14 | Abbeville | South Carolina | 45001 | 5004 | 57 |
2109063 | 2109063 | 2022-01-12 | Kewaunee | Wisconsin | 55061 | 5004 | 51 |
2058199 | 2058199 | 2021-12-28 | Montgomery | Kentucky | 21173 | 5004 | 74 |
2058446 | 2058446 | 2021-12-28 | Brown | Minnesota | 27015 | 5004 | 66 |
2028583 | 2028583 | 2021-12-19 | Decatur | Indiana | 18031 | 5004 | 117 |
2025332 | 2025332 | 2021-12-18 | Decatur | Indiana | 18031 | 5004 | 117 |
2022081 | 2022081 | 2021-12-17 | Decatur | Indiana | 18031 | 5004 | 117 |
2012247 | 2012247 | 2021-12-14 | Iroquois | Illinois | 17075 | 5004 | 88 |
1997864 | 1997864 | 2021-12-09 | Meade | South Dakota | 46093 | 5004 | 53 |
1900070 | 1900070 | 2021-11-09 | Unknown | Oklahoma | 5004 | 0 | |
1880309 | 1880309 | 2021-11-03 | Macon | North Carolina | 37113 | 5004 | 71 |
1852347 | 1852347 | 2021-10-25 | Park | Wyoming | 56029 | 5004 | 70 |
1837185 | 1837185 | 2021-10-21 | Marshall | Kentucky | 21157 | 5004 | 77 |
1806085 | 1806085 | 2021-10-11 | Brookings | South Dakota | 46011 | 5004 | 38 |
1802835 | 1802835 | 2021-10-10 | Brookings | South Dakota | 46011 | 5004 | 38 |
1799586 | 1799586 | 2021-10-09 | Brookings | South Dakota | 46011 | 5004 | 38 |
1796337 | 1796337 | 2021-10-08 | Brookings | South Dakota | 46011 | 5004 | 38 |
1756238 | 1756238 | 2021-09-26 | Isanti | Minnesota | 27059 | 5004 | 70 |
1752990 | 1752990 | 2021-09-25 | Isanti | Minnesota | 27059 | 5004 | 70 |
1749742 | 1749742 | 2021-09-24 | Isanti | Minnesota | 27059 | 5004 | 70 |
1745915 | 1745915 | 2021-09-23 | Steuben | Indiana | 18151 | 5004 | 70 |
1695618 | 1695618 | 2021-09-07 | Williamsburg | South Carolina | 45089 | 5004 | 114 |
1619589 | 1619589 | 2021-08-15 | Iberville | Louisiana | 22047 | 5004 | 107 |
1616341 | 1616341 | 2021-08-14 | Iberville | Louisiana | 22047 | 5004 | 107 |
1613092 | 1613092 | 2021-08-13 | Iberville | Louisiana | 22047 | 5004 | 107 |
1605276 | 1605276 | 2021-08-10 | Grays Harbor | Washington | 53027 | 5004 | 82 |
1580878 | 1580878 | 2021-08-03 | Bolivar | Mississippi | 28011 | 5004 | 134 |
1539219 | 1539219 | 2021-07-21 | Richmond | North Carolina | 37153 | 5004 | 98 |
1532439 | 1532439 | 2021-07-19 | Dodge | Nebraska | 31053 | 5004 | 83 |
1529491 | 1529491 | 2021-07-18 | Vance | North Carolina | 37181 | 5004 | 90 |
1526244 | 1526244 | 2021-07-17 | Vance | North Carolina | 37181 | 5004 | 90 |
1522997 | 1522997 | 2021-07-16 | Vance | North Carolina | 37181 | 5004 | 90 |
1519749 | 1519749 | 2021-07-15 | Vance | North Carolina | 37181 | 5004 | 90 |
1514204 | 1514204 | 2021-07-13 | Campbell | Virginia | 51031 | 5004 | 103 |
1511214 | 1511214 | 2021-07-12 | Pierce | Wisconsin | 55093 | 5004 | 44 |
1505819 | 1505819 | 2021-07-11 | Henderson | Kentucky | 21101 | 5004 | 79 |
1502573 | 1502573 | 2021-07-10 | Henderson | Kentucky | 21101 | 5004 | 79 |
1499327 | 1499327 | 2021-07-09 | Henderson | Kentucky | 21101 | 5004 | 79 |
1469310 | 1469310 | 2021-06-30 | Broomfield | Colorado | 8014 | 5004 | 76 |
1336476 | 1336476 | 2021-05-20 | Murray | Georgia | 13213 | 5004 | 86 |
1311840 | 1311840 | 2021-05-12 | Otero | New Mexico | 35035 | 5004 | 75 |
1264477 | 1264477 | 2021-04-27 | Dunn | Wisconsin | 55033 | 5004 | 32 |
1153769 | 1153769 | 2021-03-24 | Box Elder | Utah | 49003 | 5004 | 47 |
1146359 | 1146359 | 2021-03-22 | McDowell | North Carolina | 37111 | 5004 | 62 |
1122857 | 1122857 | 2021-03-15 | Androscoggin | Maine | 23001 | 5004 | 57 |
1048691 | 1048691 | 2021-02-20 | Buffalo | Nebraska | 31019 | 5004 | 54 |
1046059 | 1046059 | 2021-02-19 | Indiana | Pennsylvania | 42063 | 5004 | 156 |
1029482 | 1029482 | 2021-02-14 | Granville | North Carolina | 37077 | 5004 | 74 |
1020431 | 1020431 | 2021-02-11 | Atascosa | Texas | 48013 | 5004 | 126 |
1010655 | 1010655 | 2021-02-08 | Monroe | Tennessee | 47123 | 5004 | 82 |
963913 | 963913 | 2021-01-25 | Lapeer | Michigan | 26087 | 5004 | 121 |
945590 | 945590 | 2021-01-19 | Georgetown | South Carolina | 45043 | 5004 | 103 |
932757 | 932757 | 2021-01-15 | McMinn | Tennessee | 47107 | 5004 | 73 |
925534 | 925534 | 2021-01-13 | Chautauqua | New York | 36013 | 5004 | 46 |
897566 | 897566 | 2021-01-04 | Thurston | Washington | 53067 | 5004 | 56 |
875606 | 875606 | 2020-12-29 | Boone | Illinois | 17007 | 5004 | 67 |
850330 | 850330 | 2020-12-21 | Lenawee | Michigan | 26091 | 5004 | 63 |
810427 | 810427 | 2020-12-09 | Columbia | Florida | 12023 | 5004 | 100 |
810070 | 810070 | 2020-12-08 | Wood | Wisconsin | 55141 | 5004 | 39 |
775566 | 775566 | 2020-11-28 | St. Landry | Louisiana | 22097 | 5004 | 154 |
772321 | 772321 | 2020-11-27 | St. Landry | Louisiana | 22097 | 5004 | 154 |
756904 | 756904 | 2020-11-22 | Randolph | North Carolina | 37151 | 5004 | 76 |
671751 | 671751 | 2020-10-27 | Tangipahoa | Louisiana | 22105 | 5004 | 126 |
632962 | 632962 | 2020-10-15 | Washtenaw | Michigan | 26161 | 5004 | 126 |
617681 | 617681 | 2020-10-10 | Washington | Oregon | 41067 | 5004 | 67 |
514184 | 514184 | 2020-09-08 | Beaufort | South Carolina | 45013 | 5004 | 72 |
210770 | 210770 | 2020-06-05 | Douglas | Nebraska | 31055 | 5004 | 45 |
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);