ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
134 rows where cases = 4057 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Michigan 21
- Iowa 11
- Illinois 10
- Virginia 10
- Indiana 7
- Minnesota 6
- Mississippi 6
- Texas 6
- Ohio 5
- Alabama 4
- Georgia 4
- Kentucky 4
- Missouri 4
- New York 4
- Arkansas 3
- Colorado 3
- Oregon 3
- Washington 3
- Wisconsin 3
- Idaho 2
- Kansas 2
- Pennsylvania 2
- South Carolina 2
- West Virginia 2
- Alaska 1
- Louisiana 1
- Montana 1
- Nebraska 1
- New Mexico 1
- Tennessee 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499303 | 2499303 | 2022-05-12 | Grayson | Virginia | 51077 | 4057 | 83 |
2461132 | 2461132 | 2022-05-01 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2457876 | 2457876 | 2022-04-30 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2454620 | 2454620 | 2022-04-29 | Jo Daviess | Illinois | 17085 | 4057 | 39 |
2427654 | 2427654 | 2022-04-20 | Giles | Virginia | 51071 | 4057 | 50 |
2424398 | 2424398 | 2022-04-19 | Giles | Virginia | 51071 | 4057 | 50 |
2301808 | 2301808 | 2022-03-13 | Vermillion | Indiana | 18165 | 4057 | 74 |
2298556 | 2298556 | 2022-03-12 | Vermillion | Indiana | 18165 | 4057 | 74 |
2295304 | 2295304 | 2022-03-11 | Vermillion | Indiana | 18165 | 4057 | 74 |
2292052 | 2292052 | 2022-03-10 | Vermillion | Indiana | 18165 | 4057 | 74 |
2293896 | 2293896 | 2022-03-10 | Aransas | Texas | 48007 | 4057 | 80 |
2288800 | 2288800 | 2022-03-09 | Vermillion | Indiana | 18165 | 4057 | 74 |
2266894 | 2266894 | 2022-03-02 | Park | Montana | 30067 | 4057 | 34 |
2249112 | 2249112 | 2022-02-25 | Clay | Arkansas | 5021 | 4057 | 87 |
2232749 | 2232749 | 2022-02-20 | Clay | Alabama | 1027 | 4057 | 74 |
2224391 | 2224391 | 2022-02-17 | Wadena | Minnesota | 27159 | 4057 | 50 |
2200119 | 2200119 | 2022-02-09 | Wetzel | West Virginia | 54103 | 4057 | 74 |
2135052 | 2135052 | 2022-01-20 | Adams | Wisconsin | 55001 | 4057 | 46 |
2058271 | 2058271 | 2021-12-28 | Pointe Coupee | Louisiana | 22077 | 4057 | 85 |
2003442 | 2003442 | 2021-12-11 | Randolph | Missouri | 29175 | 4057 | 80 |
1988974 | 1988974 | 2021-12-07 | Cleburne | Arkansas | 5023 | 4057 | 95 |
1989798 | 1989798 | 2021-12-07 | Labette | Kansas | 20099 | 4057 | 63 |
1990953 | 1990953 | 2021-12-07 | Holmes | Ohio | 39075 | 4057 | 143 |
1986548 | 1986548 | 2021-12-06 | Labette | Kansas | 20099 | 4057 | 63 |
1986914 | 1986914 | 2021-12-06 | Otsego | Michigan | 26137 | 4057 | 70 |
1988526 | 1988526 | 2021-12-06 | Windsor | Vermont | 50027 | 4057 | 33 |
1981844 | 1981844 | 2021-12-04 | Hutchinson | Texas | 48233 | 4057 | 96 |
1930033 | 1930033 | 2021-11-18 | Botetourt | Virginia | 51023 | 4057 | 54 |
1892713 | 1892713 | 2021-11-07 | Le Sueur | Minnesota | 27079 | 4057 | 33 |
1889463 | 1889463 | 2021-11-06 | Le Sueur | Minnesota | 27079 | 4057 | 33 |
1886213 | 1886213 | 2021-11-05 | Le Sueur | Minnesota | 27079 | 4057 | 33 |
1826225 | 1826225 | 2021-10-17 | Hancock | West Virginia | 54029 | 4057 | 108 |
1792076 | 1792076 | 2021-10-07 | Leake | Mississippi | 28079 | 4057 | 87 |
1786447 | 1786447 | 2021-10-05 | Tioga | Pennsylvania | 42117 | 4057 | 122 |
1781394 | 1781394 | 2021-10-04 | Sumter | Georgia | 13261 | 4057 | 119 |
1763244 | 1763244 | 2021-09-28 | Greene | New York | 36039 | 4057 | 83 |
1763838 | 1763838 | 2021-09-28 | Union | South Carolina | 45087 | 4057 | 91 |
1723891 | 1723891 | 2021-09-16 | Barry | Missouri | 29009 | 4057 | 58 |
1720622 | 1720622 | 2021-09-15 | Sunflower | Mississippi | 28133 | 4057 | 104 |
1714499 | 1714499 | 2021-09-13 | Chenango | New York | 36017 | 4057 | 85 |
1699483 | 1699483 | 2021-09-08 | Kittitas | Washington | 53037 | 4057 | 41 |
1663966 | 1663966 | 2021-08-29 | Marion | Alabama | 1093 | 4057 | 110 |
1664106 | 1664106 | 2021-08-29 | Yell | Arkansas | 5149 | 4057 | 67 |
1666170 | 1666170 | 2021-08-29 | Malheur | Oregon | 41045 | 4057 | 66 |
1662922 | 1662922 | 2021-08-28 | Malheur | Oregon | 41045 | 4057 | 66 |
1659674 | 1659674 | 2021-08-27 | Malheur | Oregon | 41045 | 4057 | 66 |
1580328 | 1580328 | 2021-08-03 | Plymouth | Iowa | 19149 | 4057 | 82 |
1577079 | 1577079 | 2021-08-02 | Plymouth | Iowa | 19149 | 4057 | 82 |
1573831 | 1573831 | 2021-08-01 | Plymouth | Iowa | 19149 | 4057 | 82 |
1570583 | 1570583 | 2021-07-31 | Plymouth | Iowa | 19149 | 4057 | 82 |
1567335 | 1567335 | 2021-07-30 | Plymouth | Iowa | 19149 | 4057 | 82 |
1564087 | 1564087 | 2021-07-29 | Plymouth | Iowa | 19149 | 4057 | 82 |
1560839 | 1560839 | 2021-07-28 | Plymouth | Iowa | 19149 | 4057 | 82 |
1526318 | 1526318 | 2021-07-17 | Brown | Ohio | 39015 | 4057 | 62 |
1517456 | 1517456 | 2021-07-14 | Charlottesville city | Virginia | 51540 | 4057 | 58 |
1509276 | 1509276 | 2021-07-12 | Delta | Michigan | 26041 | 4057 | 95 |
1505397 | 1505397 | 2021-07-11 | Fulton | Illinois | 17057 | 4057 | 67 |
1506030 | 1506030 | 2021-07-11 | Delta | Michigan | 26041 | 4057 | 95 |
1502151 | 1502151 | 2021-07-10 | Fulton | Illinois | 17057 | 4057 | 67 |
1502784 | 1502784 | 2021-07-10 | Delta | Michigan | 26041 | 4057 | 95 |
1498905 | 1498905 | 2021-07-09 | Fulton | Illinois | 17057 | 4057 | 67 |
1499538 | 1499538 | 2021-07-09 | Delta | Michigan | 26041 | 4057 | 95 |
1496292 | 1496292 | 2021-07-08 | Delta | Michigan | 26041 | 4057 | 95 |
1492412 | 1492412 | 2021-07-07 | Fulton | Illinois | 17057 | 4057 | 67 |
1493045 | 1493045 | 2021-07-07 | Delta | Michigan | 26041 | 4057 | 95 |
1489165 | 1489165 | 2021-07-06 | Fulton | Illinois | 17057 | 4057 | 67 |
1489798 | 1489798 | 2021-07-06 | Delta | Michigan | 26041 | 4057 | 95 |
1486551 | 1486551 | 2021-07-05 | Delta | Michigan | 26041 | 4057 | 95 |
1483305 | 1483305 | 2021-07-04 | Delta | Michigan | 26041 | 4057 | 95 |
1480059 | 1480059 | 2021-07-03 | Delta | Michigan | 26041 | 4057 | 95 |
1476812 | 1476812 | 2021-07-02 | Delta | Michigan | 26041 | 4057 | 95 |
1473422 | 1473422 | 2021-07-01 | Whitley | Kentucky | 21235 | 4057 | 61 |
1473566 | 1473566 | 2021-07-01 | Delta | Michigan | 26041 | 4057 | 95 |
1469341 | 1469341 | 2021-06-30 | Logan | Colorado | 8075 | 4057 | 69 |
1470320 | 1470320 | 2021-06-30 | Delta | Michigan | 26041 | 4057 | 95 |
1467075 | 1467075 | 2021-06-29 | Delta | Michigan | 26041 | 4057 | 95 |
1463830 | 1463830 | 2021-06-28 | Delta | Michigan | 26041 | 4057 | 95 |
1460585 | 1460585 | 2021-06-27 | Delta | Michigan | 26041 | 4057 | 95 |
1457340 | 1457340 | 2021-06-26 | Delta | Michigan | 26041 | 4057 | 95 |
1454095 | 1454095 | 2021-06-25 | Delta | Michigan | 26041 | 4057 | 95 |
1402164 | 1402164 | 2021-06-09 | Delta | Michigan | 26041 | 4057 | 94 |
1389774 | 1389774 | 2021-06-05 | Columbia | New York | 36021 | 4057 | 104 |
1377261 | 1377261 | 2021-06-01 | Venango | Pennsylvania | 42121 | 4057 | 96 |
1335702 | 1335702 | 2021-05-19 | Franklin | Virginia | 51067 | 4057 | 77 |
1329966 | 1329966 | 2021-05-18 | Liberty | Georgia | 13179 | 4057 | 64 |
1316917 | 1316917 | 2021-05-14 | Chattahoochee | Georgia | 13053 | 4057 | 15 |
1269177 | 1269177 | 2021-04-29 | Morrison | Minnesota | 27097 | 4057 | 60 |
1251180 | 1251180 | 2021-04-23 | Waller | Texas | 48473 | 4057 | 46 |
1243313 | 1243313 | 2021-04-21 | Union | Mississippi | 28145 | 4057 | 76 |
1230700 | 1230700 | 2021-04-17 | Fulton | New York | 36035 | 4057 | 86 |
1214061 | 1214061 | 2021-04-12 | Monroe | Mississippi | 28095 | 4057 | 132 |
1210813 | 1210813 | 2021-04-11 | Monroe | Mississippi | 28095 | 4057 | 132 |
1200450 | 1200450 | 2021-04-08 | Jasper | Iowa | 19099 | 4057 | 70 |
1194151 | 1194151 | 2021-04-06 | Graves | Kentucky | 21083 | 4057 | 90 |
1190901 | 1190901 | 2021-04-05 | Graves | Kentucky | 21083 | 4057 | 90 |
1147721 | 1147721 | 2021-03-23 | Kenai Peninsula Borough | Alaska | 2122 | 4057 | 19 |
1134267 | 1134267 | 2021-03-18 | Van Zandt | Texas | 48467 | 4057 | 112 |
1131019 | 1131019 | 2021-03-17 | Van Zandt | Texas | 48467 | 4057 | 112 |
1126424 | 1126424 | 2021-03-16 | Butler | Missouri | 29023 | 4057 | 37 |
1111685 | 1111685 | 2021-03-11 | Manassas city | Virginia | 51683 | 4057 | 42 |
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);