ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
164 rows where cases = 2840 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Virginia 17
- Iowa 9
- Texas 9
- Georgia 8
- North Carolina 8
- Alabama 7
- Illinois 7
- Indiana 7
- Kentucky 7
- Tennessee 7
- Louisiana 6
- Ohio 6
- Arkansas 5
- Maryland 5
- Minnesota 5
- Missouri 5
- West Virginia 5
- Wisconsin 5
- Mississippi 4
- South Dakota 4
- Utah 4
- Pennsylvania 3
- Puerto Rico 3
- Florida 2
- Idaho 2
- Michigan 2
- New York 2
- California 1
- Colorado 1
- Connecticut 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2453723 | 2453723 | 2022-04-28 | Lexington city | Virginia | 51678 | 2840 | 40 |
2445046 | 2445046 | 2022-04-26 | Hancock | Iowa | 19081 | 2840 | 47 |
2441790 | 2441790 | 2022-04-25 | Hancock | Iowa | 19081 | 2840 | 47 |
2438534 | 2438534 | 2022-04-24 | Hancock | Iowa | 19081 | 2840 | 47 |
2435278 | 2435278 | 2022-04-23 | Hancock | Iowa | 19081 | 2840 | 47 |
2432022 | 2432022 | 2022-04-22 | Hancock | Iowa | 19081 | 2840 | 47 |
2428766 | 2428766 | 2022-04-21 | Hancock | Iowa | 19081 | 2840 | 47 |
2425510 | 2425510 | 2022-04-20 | Hancock | Iowa | 19081 | 2840 | 47 |
2421708 | 2421708 | 2022-04-19 | Park | Colorado | 8093 | 2840 | 20 |
2423777 | 2423777 | 2022-04-19 | Comerio | Puerto Rico | 72045 | 2840 | |
2381756 | 2381756 | 2022-04-06 | Camp | Texas | 48063 | 2840 | 74 |
2378501 | 2378501 | 2022-04-05 | Camp | Texas | 48063 | 2840 | 74 |
2314346 | 2314346 | 2022-03-17 | Unknown | Connecticut | 2840 | 8 | |
2288030 | 2288030 | 2022-03-09 | Conecuh | Alabama | 1035 | 2840 | 67 |
2284778 | 2284778 | 2022-03-08 | Conecuh | Alabama | 1035 | 2840 | 66 |
2266694 | 2266694 | 2022-03-02 | Jefferson Davis | Mississippi | 28065 | 2840 | 50 |
2236052 | 2236052 | 2022-02-21 | Wilcox | Alabama | 1131 | 2840 | 42 |
2218389 | 2218389 | 2022-02-15 | Alleghany | North Carolina | 37005 | 2840 | 11 |
2193727 | 2193727 | 2022-02-08 | Coosa | Alabama | 1037 | 2840 | 53 |
2140723 | 2140723 | 2022-01-22 | Potter | Pennsylvania | 42105 | 2840 | 82 |
2131048 | 2131048 | 2022-01-19 | Utuado | Puerto Rico | 72141 | 2840 | |
2104186 | 2104186 | 2022-01-11 | Macon | Missouri | 29121 | 2840 | 39 |
2096634 | 2096634 | 2022-01-09 | Rabun | Georgia | 13241 | 2840 | 79 |
2093382 | 2093382 | 2022-01-08 | Rabun | Georgia | 13241 | 2840 | 79 |
2090130 | 2090130 | 2022-01-07 | Rabun | Georgia | 13241 | 2840 | 79 |
2086879 | 2086879 | 2022-01-06 | Rabun | Georgia | 13241 | 2840 | 79 |
2083627 | 2083627 | 2022-01-05 | Rabun | Georgia | 13241 | 2840 | 79 |
2082536 | 2082536 | 2022-01-04 | Colorado | Texas | 48089 | 2840 | 56 |
2044055 | 2044055 | 2021-12-23 | Marquette | Wisconsin | 55077 | 2840 | 38 |
2035509 | 2035509 | 2021-12-21 | Jackson | Louisiana | 22049 | 2840 | 64 |
2024476 | 2024476 | 2021-12-17 | Hardy | West Virginia | 54031 | 2840 | 38 |
2008268 | 2008268 | 2021-12-12 | Burnett | Wisconsin | 55013 | 2840 | 33 |
2005017 | 2005017 | 2021-12-11 | Burnett | Wisconsin | 55013 | 2840 | 33 |
2001766 | 2001766 | 2021-12-10 | Burnett | Wisconsin | 55013 | 2840 | 33 |
1972276 | 1972276 | 2021-12-01 | Windham | Vermont | 50025 | 2840 | 26 |
1937557 | 1937557 | 2021-11-21 | Carroll | Indiana | 18015 | 2840 | 40 |
1938755 | 1938755 | 2021-11-21 | Avery | North Carolina | 37011 | 2840 | 39 |
1934307 | 1934307 | 2021-11-20 | Carroll | Indiana | 18015 | 2840 | 40 |
1935505 | 1935505 | 2021-11-20 | Avery | North Carolina | 37011 | 2840 | 39 |
1931056 | 1931056 | 2021-11-19 | Carroll | Indiana | 18015 | 2840 | 40 |
1932255 | 1932255 | 2021-11-19 | Avery | North Carolina | 37011 | 2840 | 39 |
1905387 | 1905387 | 2021-11-11 | Garrard | Kentucky | 21079 | 2840 | 51 |
1902137 | 1902137 | 2021-11-10 | Garrard | Kentucky | 21079 | 2840 | 51 |
1894371 | 1894371 | 2021-11-07 | Powhatan | Virginia | 51145 | 2840 | 28 |
1891121 | 1891121 | 2021-11-06 | Powhatan | Virginia | 51145 | 2840 | 28 |
1887871 | 1887871 | 2021-11-05 | Powhatan | Virginia | 51145 | 2840 | 28 |
1838153 | 1838153 | 2021-10-21 | Rolette | North Dakota | 38079 | 2840 | 31 |
1835596 | 1835596 | 2021-10-20 | Houston | Texas | 48225 | 2840 | 79 |
1830699 | 1830699 | 2021-10-19 | Morgan | Kentucky | 21175 | 2840 | 9 |
1829246 | 1829246 | 2021-10-18 | Duchesne | Utah | 49013 | 2840 | 16 |
1825997 | 1825997 | 2021-10-17 | Duchesne | Utah | 49013 | 2840 | 16 |
1826237 | 1826237 | 2021-10-17 | McDowell | West Virginia | 54047 | 2840 | 44 |
1822748 | 1822748 | 2021-10-16 | Duchesne | Utah | 49013 | 2840 | 16 |
1819499 | 1819499 | 2021-10-15 | Duchesne | Utah | 49013 | 2840 | 16 |
1787937 | 1787937 | 2021-10-06 | Blaine | Idaho | 16013 | 2840 | 22 |
1762805 | 1762805 | 2021-09-28 | Clarke | Mississippi | 28023 | 2840 | 91 |
1722421 | 1722421 | 2021-09-16 | Hale | Alabama | 1065 | 2840 | 81 |
1725490 | 1725490 | 2021-09-16 | Boone | West Virginia | 54005 | 2840 | 38 |
1706344 | 1706344 | 2021-09-11 | Colusa | California | 6011 | 2840 | 18 |
1700231 | 1700231 | 2021-09-09 | Elmore | Idaho | 16039 | 2840 | 23 |
1697023 | 1697023 | 2021-09-08 | Crawford | Illinois | 17033 | 2840 | 44 |
1698810 | 1698810 | 2021-09-08 | Vega Alta | Puerto Rico | 72143 | 2840 | |
1678045 | 1678045 | 2021-09-02 | Concordia | Louisiana | 22029 | 2840 | 67 |
1675987 | 1675987 | 2021-09-01 | Warren | Pennsylvania | 42123 | 2840 | 107 |
1676193 | 1676193 | 2021-09-01 | Bledsoe | Tennessee | 47007 | 2840 | 13 |
1655593 | 1655593 | 2021-08-26 | Attala | Mississippi | 28007 | 2840 | 79 |
1632738 | 1632738 | 2021-08-19 | Oceana | Michigan | 26127 | 2840 | 60 |
1629491 | 1629491 | 2021-08-18 | Oceana | Michigan | 26127 | 2840 | 60 |
1625686 | 1625686 | 2021-08-17 | LaGrange | Indiana | 18087 | 2840 | 75 |
1603286 | 1603286 | 2021-08-10 | Mercer | Kentucky | 21167 | 2840 | 52 |
1568067 | 1568067 | 2021-07-30 | Stoddard | Missouri | 29207 | 2840 | 45 |
1564741 | 1564741 | 2021-07-29 | Crawford | Missouri | 29055 | 2840 | 41 |
1559329 | 1559329 | 2021-07-27 | Smith | Tennessee | 47159 | 2840 | 40 |
1531222 | 1531222 | 2021-07-19 | Lee | Georgia | 13177 | 2840 | 59 |
1495096 | 1495096 | 2021-07-08 | Winston | Alabama | 1133 | 2840 | 72 |
1491849 | 1491849 | 2021-07-07 | Winston | Alabama | 1133 | 2840 | 72 |
1491515 | 1491515 | 2021-07-06 | Halifax | Virginia | 51083 | 2840 | 78 |
1488268 | 1488268 | 2021-07-05 | Halifax | Virginia | 51083 | 2840 | 78 |
1485021 | 1485021 | 2021-07-04 | Halifax | Virginia | 51083 | 2840 | 78 |
1481775 | 1481775 | 2021-07-03 | Halifax | Virginia | 51083 | 2840 | 78 |
1478528 | 1478528 | 2021-07-02 | Halifax | Virginia | 51083 | 2840 | 78 |
1472479 | 1472479 | 2021-07-01 | Sevier | Arkansas | 5133 | 2840 | 24 |
1475282 | 1475282 | 2021-07-01 | Halifax | Virginia | 51083 | 2840 | 78 |
1423513 | 1423513 | 2021-06-15 | Randolph | West Virginia | 54083 | 2840 | 15 |
1405234 | 1405234 | 2021-06-10 | Montgomery | Kentucky | 21173 | 2840 | 30 |
1398868 | 1398868 | 2021-06-08 | Dorchester | Maryland | 24019 | 2840 | 65 |
1395622 | 1395622 | 2021-06-07 | Dorchester | Maryland | 24019 | 2840 | 65 |
1392376 | 1392376 | 2021-06-06 | Dorchester | Maryland | 24019 | 2840 | 65 |
1381263 | 1381263 | 2021-06-02 | Mason | Washington | 53045 | 2840 | 33 |
1376074 | 1376074 | 2021-06-01 | De Soto | Louisiana | 22031 | 2840 | 78 |
1351054 | 1351054 | 2021-05-24 | Fayette | Ohio | 39047 | 2840 | 50 |
1347808 | 1347808 | 2021-05-23 | Fayette | Ohio | 39047 | 2840 | 50 |
1343028 | 1343028 | 2021-05-22 | Hawaii | Hawaii | 15001 | 2840 | 53 |
1340630 | 1340630 | 2021-05-21 | Todd | Minnesota | 27153 | 2840 | 32 |
1335900 | 1335900 | 2021-05-19 | Door | Wisconsin | 55029 | 2840 | 30 |
1332412 | 1332412 | 2021-05-18 | Accomack | Virginia | 51001 | 2840 | 41 |
1329165 | 1329165 | 2021-05-17 | Accomack | Virginia | 51001 | 2840 | 41 |
1324042 | 1324042 | 2021-05-16 | Harlan | Kentucky | 21095 | 2840 | 83 |
1324524 | 1324524 | 2021-05-16 | Dunklin | Missouri | 29069 | 2840 | 22 |
1321278 | 1321278 | 2021-05-15 | Dunklin | Missouri | 29069 | 2840 | 22 |
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);