ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
109 rows where cases = 4489 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 9
- Florida 8
- Puerto Rico 7
- Texas 7
- Missouri 6
- Mississippi 5
- New York 5
- Tennessee 5
- Colorado 4
- Louisiana 4
- Michigan 4
- Illinois 3
- Indiana 3
- Iowa 3
- North Carolina 3
- Ohio 3
- Pennsylvania 3
- Virginia 3
- Kentucky 2
- Maryland 2
- Minnesota 2
- Oklahoma 2
- South Dakota 2
- Washington 2
- Wisconsin 2
- Alabama 1
- Arkansas 1
- Maine 1
- Massachusetts 1
- Nevada 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493687 | 2493687 | 2022-05-11 | Ford | Illinois | 17053 | 4489 | 75 |
2402388 | 2402388 | 2022-04-13 | Putnam | Georgia | 13237 | 4489 | 105 |
2399133 | 2399133 | 2022-04-12 | Putnam | Georgia | 13237 | 4489 | 105 |
2395878 | 2395878 | 2022-04-11 | Putnam | Georgia | 13237 | 4489 | 105 |
2337050 | 2337050 | 2022-03-24 | Alamosa | Colorado | 8003 | 4489 | 61 |
2333796 | 2333796 | 2022-03-23 | Alamosa | Colorado | 8003 | 4489 | 61 |
2329405 | 2329405 | 2022-03-21 | Fajardo | Puerto Rico | 72053 | 4489 | |
2310589 | 2310589 | 2022-03-15 | Asotin | Washington | 53003 | 4489 | 65 |
2307336 | 2307336 | 2022-03-14 | Asotin | Washington | 53003 | 4489 | 65 |
2293579 | 2293579 | 2022-03-10 | Montour | Pennsylvania | 42093 | 4489 | 91 |
2290327 | 2290327 | 2022-03-09 | Montour | Pennsylvania | 42093 | 4489 | 91 |
2287075 | 2287075 | 2022-03-08 | Montour | Pennsylvania | 42093 | 4489 | 91 |
2248952 | 2248952 | 2022-02-24 | Sawyer | Wisconsin | 55113 | 4489 | 58 |
2244261 | 2244261 | 2022-02-23 | Humboldt | Nevada | 32013 | 4489 | 51 |
2225927 | 2225927 | 2022-02-17 | Buchanan | Virginia | 51027 | 4489 | 95 |
2216332 | 2216332 | 2022-02-14 | Barbour | West Virginia | 54001 | 4489 | 66 |
2177714 | 2177714 | 2022-02-03 | Elbert | Colorado | 8039 | 4489 | 33 |
2102914 | 2102914 | 2022-01-11 | Montezuma | Colorado | 8083 | 4489 | 58 |
2074973 | 2074973 | 2022-01-02 | Washington | Missouri | 29221 | 4489 | 102 |
2071722 | 2071722 | 2022-01-01 | Washington | Missouri | 29221 | 4489 | 102 |
2068471 | 2068471 | 2021-12-31 | Washington | Missouri | 29221 | 4489 | 102 |
2065220 | 2065220 | 2021-12-30 | Washington | Missouri | 29221 | 4489 | 102 |
2059590 | 2059590 | 2021-12-28 | Davison | South Dakota | 46035 | 4489 | 73 |
2032296 | 2032296 | 2021-12-20 | West Baton Rouge | Louisiana | 22121 | 4489 | 79 |
2009948 | 2009948 | 2021-12-13 | Saline | Missouri | 29195 | 4489 | 84 |
1962158 | 1962158 | 2021-11-28 | Grainger | Tennessee | 47057 | 4489 | 68 |
1958907 | 1958907 | 2021-11-27 | Grainger | Tennessee | 47057 | 4489 | 68 |
1955656 | 1955656 | 2021-11-26 | Grainger | Tennessee | 47057 | 4489 | 68 |
1952405 | 1952405 | 2021-11-25 | Grainger | Tennessee | 47057 | 4489 | 68 |
1949154 | 1949154 | 2021-11-24 | Grainger | Tennessee | 47057 | 4489 | 68 |
1945752 | 1945752 | 2021-11-23 | Vega Baja | Puerto Rico | 72145 | 4489 | |
1946279 | 1946279 | 2021-11-23 | Amherst | Virginia | 51009 | 4489 | 61 |
1942501 | 1942501 | 2021-11-22 | Vega Baja | Puerto Rico | 72145 | 4489 | |
1937566 | 1937566 | 2021-11-21 | Decatur | Indiana | 18031 | 4489 | 114 |
1939251 | 1939251 | 2021-11-21 | Vega Baja | Puerto Rico | 72145 | 4489 | |
1934316 | 1934316 | 2021-11-20 | Decatur | Indiana | 18031 | 4489 | 114 |
1936001 | 1936001 | 2021-11-20 | Vega Baja | Puerto Rico | 72145 | 4489 | |
1931065 | 1931065 | 2021-11-19 | Decatur | Indiana | 18031 | 4489 | 114 |
1928186 | 1928186 | 2021-11-18 | Ohio | Kentucky | 21183 | 4489 | 84 |
1837272 | 1837272 | 2021-10-21 | Sabine | Louisiana | 22085 | 4489 | 88 |
1838075 | 1838075 | 2021-10-21 | Montgomery | North Carolina | 37123 | 4489 | 108 |
1791012 | 1791012 | 2021-10-07 | Washington | Florida | 12133 | 4489 | 62 |
1787763 | 1787763 | 2021-10-06 | Washington | Florida | 12133 | 4489 | 62 |
1784514 | 1784514 | 2021-10-05 | Washington | Florida | 12133 | 4489 | 62 |
1781265 | 1781265 | 2021-10-04 | Washington | Florida | 12133 | 4489 | 62 |
1778015 | 1778015 | 2021-10-03 | Washington | Florida | 12133 | 4489 | 62 |
1774765 | 1774765 | 2021-10-02 | Washington | Florida | 12133 | 4489 | 62 |
1771515 | 1771515 | 2021-10-01 | Washington | Florida | 12133 | 4489 | 62 |
1761564 | 1761564 | 2021-09-28 | Yell | Arkansas | 5149 | 4489 | 76 |
1721118 | 1721118 | 2021-09-15 | Person | North Carolina | 37145 | 4489 | 78 |
1711255 | 1711255 | 2021-09-12 | Columbia | New York | 36021 | 4489 | 107 |
1702928 | 1702928 | 2021-09-10 | Dallas | Alabama | 1047 | 4489 | 172 |
1614804 | 1614804 | 2021-08-13 | Uvalde | Texas | 48463 | 4489 | 76 |
1596977 | 1596977 | 2021-08-08 | Hillsdale | Michigan | 26059 | 4489 | 95 |
1593728 | 1593728 | 2021-08-07 | Hillsdale | Michigan | 26059 | 4489 | 95 |
1590479 | 1590479 | 2021-08-06 | Hillsdale | Michigan | 26059 | 4489 | 95 |
1584063 | 1584063 | 2021-08-04 | Isanti | Minnesota | 27059 | 4489 | 67 |
1571823 | 1571823 | 2021-07-31 | Madison | Ohio | 39097 | 4489 | 66 |
1506256 | 1506256 | 2021-07-11 | Warren | Mississippi | 28149 | 4489 | 121 |
1503010 | 1503010 | 2021-07-10 | Warren | Mississippi | 28149 | 4489 | 121 |
1499764 | 1499764 | 2021-07-09 | Warren | Mississippi | 28149 | 4489 | 121 |
1413594 | 1413594 | 2021-06-12 | Danville city | Virginia | 51590 | 4489 | 141 |
1363824 | 1363824 | 2021-05-28 | Livingston | New York | 36051 | 4489 | 59 |
1356121 | 1356121 | 2021-05-26 | Marion | Illinois | 17121 | 4489 | 122 |
1352845 | 1352845 | 2021-05-25 | Franklin | Illinois | 17055 | 4489 | 88 |
1339754 | 1339754 | 2021-05-21 | Thomas | Georgia | 13275 | 4489 | 124 |
1336507 | 1336507 | 2021-05-20 | Thomas | Georgia | 13275 | 4489 | 124 |
1291940 | 1291940 | 2021-05-06 | Winona | Minnesota | 27169 | 4489 | 50 |
1293260 | 1293260 | 2021-05-06 | Hill | Texas | 48217 | 4489 | 108 |
1288434 | 1288434 | 2021-05-05 | Lincoln | Louisiana | 22061 | 4489 | 92 |
1290014 | 1290014 | 2021-05-05 | Hill | Texas | 48217 | 4489 | 108 |
1286768 | 1286768 | 2021-05-04 | Hill | Texas | 48217 | 4489 | 108 |
1283522 | 1283522 | 2021-05-03 | Hill | Texas | 48217 | 4489 | 108 |
1271873 | 1271873 | 2021-04-30 | Des Moines | Iowa | 19057 | 4489 | 66 |
1258456 | 1258456 | 2021-04-26 | Baldwin | Georgia | 13009 | 4489 | 128 |
1242883 | 1242883 | 2021-04-21 | Jessamine | Kentucky | 21113 | 4489 | 62 |
1244226 | 1244226 | 2021-04-21 | Toa Baja | Puerto Rico | 72137 | 4489 | |
1241054 | 1241054 | 2021-04-20 | Codington | South Dakota | 46029 | 4489 | 80 |
1190723 | 1190723 | 2021-04-05 | Muscatine | Iowa | 19139 | 4489 | 96 |
1174795 | 1174795 | 2021-03-31 | St. Mary | Louisiana | 22101 | 4489 | 129 |
1158580 | 1158580 | 2021-03-26 | Penobscot | Maine | 23019 | 4489 | 87 |
1136124 | 1136124 | 2021-03-19 | Oktibbeha | Mississippi | 28105 | 4489 | 97 |
1092877 | 1092877 | 2021-03-06 | Colquitt | Georgia | 13071 | 4489 | 106 |
1094301 | 1094301 | 2021-03-06 | Cattaraugus | New York | 36009 | 4489 | 77 |
1078428 | 1078428 | 2021-03-01 | Osage | Oklahoma | 40113 | 4489 | 50 |
1045632 | 1045632 | 2021-02-19 | Herkimer | New York | 36043 | 4489 | 104 |
1012918 | 1012918 | 2021-02-09 | Taney | Missouri | 29213 | 4489 | 73 |
994047 | 994047 | 2021-02-03 | Pontotoc | Oklahoma | 40123 | 4489 | 38 |
990483 | 990483 | 2021-02-02 | St. Lawrence | New York | 36089 | 4489 | 68 |
984230 | 984230 | 2021-01-31 | Sandusky | Ohio | 39143 | 4489 | 64 |
973583 | 973583 | 2021-01-28 | St. Mary's | Maryland | 24037 | 4489 | 102 |
956084 | 956084 | 2021-01-22 | Oconto | Wisconsin | 55083 | 4489 | 51 |
947610 | 947610 | 2021-01-20 | Cecil | Maryland | 24015 | 4489 | 94 |
933934 | 933934 | 2021-01-16 | Spalding | Georgia | 13255 | 4489 | 113 |
925470 | 925470 | 2021-01-13 | Strafford | New Hampshire | 33017 | 4489 | 40 |
923077 | 923077 | 2021-01-12 | Bowie | Texas | 48037 | 4489 | 131 |
911937 | 911937 | 2021-01-09 | Hampshire | Massachusetts | 25015 | 4489 | 208 |
912936 | 912936 | 2021-01-09 | Deschutes | Oregon | 41017 | 4489 | 27 |
905661 | 905661 | 2021-01-07 | Lafayette | Mississippi | 28071 | 4489 | 86 |
906146 | 906146 | 2021-01-07 | Duplin | North Carolina | 37061 | 4489 | 67 |
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);