ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
112 rows where cases = 3638 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Minnesota 14
- Texas 10
- Georgia 9
- Arkansas 8
- Kentucky 8
- Michigan 5
- Wisconsin 5
- Kansas 4
- Louisiana 4
- Oklahoma 4
- Oregon 4
- Tennessee 4
- Idaho 3
- Indiana 3
- New York 3
- West Virginia 3
- Missouri 2
- North Dakota 2
- Ohio 2
- Pennsylvania 2
- South Dakota 2
- Virginia 2
- Arizona 1
- Florida 1
- Illinois 1
- Maine 1
- Mississippi 1
- New Jersey 1
- New Mexico 1
- South Carolina 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501621 | 2501621 | 2022-05-13 | Ramsey | North Dakota | 38071 | 3638 | 57 |
2402461 | 2402461 | 2022-04-13 | Gem | Idaho | 16045 | 3638 | 79 |
2399206 | 2399206 | 2022-04-12 | Gem | Idaho | 16045 | 3638 | 79 |
2395951 | 2395951 | 2022-04-11 | Gem | Idaho | 16045 | 3638 | 79 |
2355329 | 2355329 | 2022-03-29 | Tillamook | Oregon | 41057 | 3638 | 60 |
2352076 | 2352076 | 2022-03-28 | Tillamook | Oregon | 41057 | 3638 | 60 |
2279324 | 2279324 | 2022-03-06 | Leslie | Kentucky | 21131 | 3638 | 39 |
2276071 | 2276071 | 2022-03-05 | Leslie | Kentucky | 21131 | 3638 | 39 |
2272818 | 2272818 | 2022-03-04 | Leslie | Kentucky | 21131 | 3638 | 39 |
2219252 | 2219252 | 2022-02-15 | Leon | Texas | 48289 | 3638 | 84 |
2193157 | 2193157 | 2022-02-07 | Falls | Texas | 48145 | 3638 | 57 |
2189903 | 2189903 | 2022-02-06 | Falls | Texas | 48145 | 3638 | 57 |
2063712 | 2063712 | 2021-12-30 | La Paz | Arizona | 4012 | 3638 | 107 |
2060471 | 2060471 | 2021-12-29 | Arkansas | Arkansas | 5001 | 3638 | 64 |
2054010 | 2054010 | 2021-12-27 | Lawrence | Arkansas | 5075 | 3638 | 62 |
2005569 | 2005569 | 2021-12-12 | Hart | Georgia | 13147 | 3638 | 73 |
2002318 | 2002318 | 2021-12-11 | Hart | Georgia | 13147 | 3638 | 73 |
1999068 | 1999068 | 2021-12-10 | Hart | Georgia | 13147 | 3638 | 73 |
1989386 | 1989386 | 2021-12-07 | Union | Georgia | 13291 | 3638 | 130 |
1971603 | 1971603 | 2021-12-01 | Lincoln | Oregon | 41041 | 3638 | 52 |
1962233 | 1962233 | 2021-11-28 | Austin | Texas | 48015 | 3638 | 56 |
1958982 | 1958982 | 2021-11-27 | Austin | Texas | 48015 | 3638 | 56 |
1955731 | 1955731 | 2021-11-26 | Austin | Texas | 48015 | 3638 | 56 |
1952480 | 1952480 | 2021-11-25 | Austin | Texas | 48015 | 3638 | 56 |
1949229 | 1949229 | 2021-11-24 | Austin | Texas | 48015 | 3638 | 56 |
1944462 | 1944462 | 2021-11-23 | Wayne | Kentucky | 21231 | 3638 | 66 |
1917779 | 1917779 | 2021-11-15 | Dodge | Georgia | 13091 | 3638 | 127 |
1915098 | 1915098 | 2021-11-14 | Anderson | Kentucky | 21005 | 3638 | 48 |
1911848 | 1911848 | 2021-11-13 | Anderson | Kentucky | 21005 | 3638 | 48 |
1908599 | 1908599 | 2021-11-12 | Anderson | Kentucky | 21005 | 3638 | 48 |
1877197 | 1877197 | 2021-11-02 | Hocking | Ohio | 39073 | 3638 | 85 |
1872642 | 1872642 | 2021-11-01 | Washington | Indiana | 18175 | 3638 | 53 |
1873375 | 1873375 | 2021-11-01 | Crawford | Missouri | 29055 | 3638 | 57 |
1858758 | 1858758 | 2021-10-27 | Wyoming | West Virginia | 54109 | 3638 | 61 |
1847164 | 1847164 | 2021-10-24 | Oceana | Michigan | 26127 | 3638 | 70 |
1843914 | 1843914 | 2021-10-23 | Oceana | Michigan | 26127 | 3638 | 70 |
1840664 | 1840664 | 2021-10-22 | Oceana | Michigan | 26127 | 3638 | 70 |
1829760 | 1829760 | 2021-10-19 | Lincoln | Arkansas | 5079 | 3638 | 57 |
1826511 | 1826511 | 2021-10-18 | Lincoln | Arkansas | 5079 | 3638 | 57 |
1823262 | 1823262 | 2021-10-17 | Lincoln | Arkansas | 5079 | 3638 | 57 |
1789851 | 1789851 | 2021-10-06 | Davison | South Dakota | 46035 | 3638 | 71 |
1786717 | 1786717 | 2021-10-05 | Morgan | Tennessee | 47129 | 3638 | 46 |
1756256 | 1756256 | 2021-09-26 | Mille Lacs | Minnesota | 27095 | 3638 | 60 |
1753008 | 1753008 | 2021-09-25 | Mille Lacs | Minnesota | 27095 | 3638 | 60 |
1754746 | 1754746 | 2021-09-25 | Hancock | West Virginia | 54029 | 3638 | 97 |
1749760 | 1749760 | 2021-09-24 | Mille Lacs | Minnesota | 27095 | 3638 | 60 |
1722328 | 1722328 | 2021-09-15 | Lincoln | Wisconsin | 55069 | 3638 | 106 |
1718580 | 1718580 | 2021-09-14 | Dimmit | Texas | 48127 | 3638 | 40 |
1710576 | 1710576 | 2021-09-12 | Union | Louisiana | 22111 | 3638 | 92 |
1707329 | 1707329 | 2021-09-11 | Union | Louisiana | 22111 | 3638 | 92 |
1704081 | 1704081 | 2021-09-10 | Union | Louisiana | 22111 | 3638 | 92 |
1694722 | 1694722 | 2021-09-07 | Miller | Missouri | 29131 | 3638 | 68 |
1649731 | 1649731 | 2021-08-24 | Stutsman | North Dakota | 38093 | 3638 | 82 |
1623508 | 1623508 | 2021-08-16 | Cibola | New Mexico | 35006 | 3638 | 128 |
1600856 | 1600856 | 2021-08-09 | Wyoming | New York | 36121 | 3638 | 53 |
1580597 | 1580597 | 2021-08-03 | East Feliciana | Louisiana | 22037 | 3638 | 121 |
1576395 | 1576395 | 2021-08-02 | Yell | Arkansas | 5149 | 3638 | 66 |
1536088 | 1536088 | 2021-07-20 | Highland | Ohio | 39071 | 3638 | 68 |
1536555 | 1536555 | 2021-07-20 | Hardin | Tennessee | 47071 | 3638 | 69 |
1492571 | 1492571 | 2021-07-07 | Wabash | Indiana | 18169 | 3638 | 83 |
1451830 | 1451830 | 2021-06-24 | Josephine | Oregon | 41033 | 3638 | 72 |
1444464 | 1444464 | 2021-06-22 | Lyon | Minnesota | 27083 | 3638 | 53 |
1441046 | 1441046 | 2021-06-21 | Oxford | Maine | 23017 | 3638 | 67 |
1441219 | 1441219 | 2021-06-21 | Lyon | Minnesota | 27083 | 3638 | 53 |
1437973 | 1437973 | 2021-06-20 | Lyon | Minnesota | 27083 | 3638 | 53 |
1434726 | 1434726 | 2021-06-19 | Lyon | Minnesota | 27083 | 3638 | 53 |
1431479 | 1431479 | 2021-06-18 | Lyon | Minnesota | 27083 | 3638 | 53 |
1428234 | 1428234 | 2021-06-17 | Lyon | Minnesota | 27083 | 3638 | 53 |
1424989 | 1424989 | 2021-06-16 | Lyon | Minnesota | 27083 | 3638 | 53 |
1420916 | 1420916 | 2021-06-15 | Wayne | Georgia | 13305 | 3638 | 91 |
1421741 | 1421741 | 2021-06-15 | Lyon | Minnesota | 27083 | 3638 | 53 |
1418496 | 1418496 | 2021-06-14 | Lyon | Minnesota | 27083 | 3638 | 53 |
1415251 | 1415251 | 2021-06-13 | Lyon | Minnesota | 27083 | 3638 | 53 |
1416907 | 1416907 | 2021-06-13 | Prince George | Virginia | 51149 | 3638 | 32 |
1407935 | 1407935 | 2021-06-11 | Wayne | Georgia | 13305 | 3638 | 91 |
1392532 | 1392532 | 2021-06-06 | Lyon | Minnesota | 27083 | 3638 | 52 |
1376836 | 1376836 | 2021-06-01 | Warren | New York | 36113 | 3638 | 57 |
1373590 | 1373590 | 2021-05-31 | Warren | New York | 36113 | 3638 | 57 |
1352145 | 1352145 | 2021-05-24 | Green | Wisconsin | 55045 | 3638 | 25 |
1348899 | 1348899 | 2021-05-23 | Green | Wisconsin | 55045 | 3638 | 25 |
1328520 | 1328520 | 2021-05-17 | Clinton | Pennsylvania | 42035 | 3638 | 64 |
1297426 | 1297426 | 2021-05-08 | Bryan | Georgia | 13029 | 3638 | 39 |
1290496 | 1290496 | 2021-05-05 | Trempealeau | Wisconsin | 55121 | 3638 | 44 |
1091410 | 1091410 | 2021-03-05 | Okmulgee | Oklahoma | 40111 | 3638 | 50 |
1082584 | 1082584 | 2021-03-02 | Jefferson | West Virginia | 54037 | 3638 | 37 |
1073093 | 1073093 | 2021-02-28 | Boone | Arkansas | 5009 | 3638 | 73 |
1070770 | 1070770 | 2021-02-27 | Franklin | Kentucky | 21073 | 3638 | 28 |
1056583 | 1056583 | 2021-02-22 | Lewis | Washington | 53041 | 3638 | 47 |
1000760 | 1000760 | 2021-02-05 | Dillon | South Carolina | 45033 | 3638 | 74 |
994374 | 994374 | 2021-02-03 | Cheatham | Tennessee | 47021 | 3638 | 34 |
990781 | 990781 | 2021-02-02 | Logan | Oklahoma | 40083 | 3638 | 23 |
973848 | 973848 | 2021-01-28 | Union | Mississippi | 28145 | 3638 | 66 |
952571 | 952571 | 2021-01-21 | Albemarle | Virginia | 51003 | 3638 | 35 |
918174 | 918174 | 2021-01-11 | Seward | Kansas | 20175 | 3638 | 28 |
914929 | 914929 | 2021-01-10 | Seward | Kansas | 20175 | 3638 | 28 |
916156 | 916156 | 2021-01-10 | Pontotoc | Oklahoma | 40123 | 3638 | 27 |
911684 | 911684 | 2021-01-09 | Seward | Kansas | 20175 | 3638 | 28 |
908439 | 908439 | 2021-01-08 | Seward | Kansas | 20175 | 3638 | 28 |
890535 | 890535 | 2021-01-02 | Franklin | Tennessee | 47051 | 3638 | 48 |
862760 | 862760 | 2020-12-25 | Jackson | Indiana | 18071 | 3638 | 43 |
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);