ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
192 rows where cases = 2789 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 18
- Arkansas 15
- Texas 15
- Missouri 14
- South Carolina 10
- Kentucky 9
- Mississippi 8
- Illinois 7
- Indiana 6
- Louisiana 6
- Minnesota 6
- Ohio 6
- Tennessee 6
- Colorado 5
- Kansas 5
- Virginia 5
- Florida 4
- Iowa 4
- South Dakota 4
- Michigan 3
- New Mexico 3
- New York 3
- Oregon 3
- Pennsylvania 3
- Wisconsin 3
- Arizona 2
- California 2
- Maryland 2
- Oklahoma 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490282 | 2490282 | 2022-05-10 | Long | Georgia | 13183 | 2789 | 35 |
2487025 | 2487025 | 2022-05-09 | Long | Georgia | 13183 | 2789 | 35 |
2483767 | 2483767 | 2022-05-08 | Long | Georgia | 13183 | 2789 | 35 |
2480509 | 2480509 | 2022-05-07 | Long | Georgia | 13183 | 2789 | 35 |
2477251 | 2477251 | 2022-05-06 | Long | Georgia | 13183 | 2789 | 35 |
2473993 | 2473993 | 2022-05-05 | Long | Georgia | 13183 | 2789 | 35 |
2476366 | 2476366 | 2022-05-05 | Terry | Texas | 48445 | 2789 | 84 |
2470736 | 2470736 | 2022-05-04 | Long | Georgia | 13183 | 2789 | 35 |
2473109 | 2473109 | 2022-05-04 | Terry | Texas | 48445 | 2789 | 84 |
2469853 | 2469853 | 2022-05-03 | Terry | Texas | 48445 | 2789 | 84 |
2466597 | 2466597 | 2022-05-02 | Terry | Texas | 48445 | 2789 | 84 |
2463342 | 2463342 | 2022-05-01 | Terry | Texas | 48445 | 2789 | 84 |
2460086 | 2460086 | 2022-04-30 | Terry | Texas | 48445 | 2789 | 84 |
2449896 | 2449896 | 2022-04-27 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2446639 | 2446639 | 2022-04-26 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2443384 | 2443384 | 2022-04-25 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2440128 | 2440128 | 2022-04-24 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2436872 | 2436872 | 2022-04-23 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2433616 | 2433616 | 2022-04-22 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2430360 | 2430360 | 2022-04-21 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2427104 | 2427104 | 2022-04-20 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2423848 | 2423848 | 2022-04-19 | Calhoun | South Carolina | 45017 | 2789 | 61 |
2379392 | 2379392 | 2022-04-06 | Rio Grande | Colorado | 8105 | 2789 | 46 |
2336245 | 2336245 | 2022-03-23 | Eastland | Texas | 48133 | 2789 | 113 |
2317177 | 2317177 | 2022-03-17 | Summers | West Virginia | 54089 | 2789 | 50 |
2306929 | 2306929 | 2022-03-14 | Callahan | Texas | 48059 | 2789 | 72 |
2256492 | 2256492 | 2022-02-27 | Wilson | Kansas | 20205 | 2789 | 39 |
2253241 | 2253241 | 2022-02-26 | Wilson | Kansas | 20205 | 2789 | 39 |
2249990 | 2249990 | 2022-02-25 | Wilson | Kansas | 20205 | 2789 | 39 |
2246826 | 2246826 | 2022-02-24 | Metcalfe | Kentucky | 21169 | 2789 | 58 |
2243575 | 2243575 | 2022-02-23 | Metcalfe | Kentucky | 21169 | 2789 | 58 |
2223933 | 2223933 | 2022-02-17 | Linn | Kansas | 20107 | 2789 | 24 |
2220682 | 2220682 | 2022-02-16 | Linn | Kansas | 20107 | 2789 | 24 |
2201404 | 2201404 | 2022-02-10 | West Feliciana | Louisiana | 22125 | 2789 | 42 |
2191785 | 2191785 | 2022-02-07 | Aitkin | Minnesota | 27001 | 2789 | 59 |
2180715 | 2180715 | 2022-02-04 | Conecuh | Alabama | 1035 | 2789 | 63 |
2172406 | 2172406 | 2022-02-01 | Montgomery | Mississippi | 28097 | 2789 | 64 |
2127774 | 2127774 | 2022-01-18 | Naguabo | Puerto Rico | 72103 | 2789 | |
2128307 | 2128307 | 2022-01-18 | Lamoille | Vermont | 50015 | 2789 | 12 |
2122417 | 2122417 | 2022-01-17 | Las Animas | Colorado | 8071 | 2789 | 35 |
2110174 | 2110174 | 2022-01-13 | Green | Kentucky | 21087 | 2789 | 40 |
2107262 | 2107262 | 2022-01-12 | Pennington | Minnesota | 27113 | 2789 | 34 |
2082801 | 2082801 | 2022-01-04 | Appomattox | Virginia | 51011 | 2789 | 38 |
2078216 | 2078216 | 2022-01-03 | Ste. Genevieve | Missouri | 29186 | 2789 | 34 |
2079284 | 2079284 | 2022-01-03 | Colorado | Texas | 48089 | 2789 | 56 |
2058509 | 2058509 | 2021-12-28 | Sibley | Minnesota | 27143 | 2789 | 20 |
2056636 | 2056636 | 2021-12-27 | Llano | Texas | 48299 | 2789 | 84 |
2019223 | 2019223 | 2021-12-16 | Union | Kentucky | 21225 | 2789 | 44 |
2012064 | 2012064 | 2021-12-14 | Greene | Georgia | 13133 | 2789 | 74 |
2000219 | 2000219 | 2021-12-10 | Wright | Missouri | 29229 | 2789 | 66 |
1986751 | 1986751 | 2021-12-06 | LaSalle | Louisiana | 22059 | 2789 | 46 |
1937469 | 1937469 | 2021-11-21 | Edgar | Illinois | 17045 | 2789 | 70 |
1934219 | 1934219 | 2021-11-20 | Edgar | Illinois | 17045 | 2789 | 70 |
1930968 | 1930968 | 2021-11-19 | Edgar | Illinois | 17045 | 2789 | 70 |
1925033 | 1925033 | 2021-11-17 | Franklin | Maine | 23007 | 2789 | 30 |
1915933 | 1915933 | 2021-11-14 | San Miguel | New Mexico | 35047 | 2789 | 28 |
1912683 | 1912683 | 2021-11-13 | San Miguel | New Mexico | 35047 | 2789 | 28 |
1909433 | 1909433 | 2021-11-12 | San Miguel | New Mexico | 35047 | 2789 | 28 |
1865021 | 1865021 | 2021-10-29 | Orleans | Vermont | 50019 | 2789 | 14 |
1858136 | 1858136 | 2021-10-27 | Benton | Tennessee | 47005 | 2789 | 52 |
1834281 | 1834281 | 2021-10-20 | Calhoun | Mississippi | 28013 | 2789 | 45 |
1817638 | 1817638 | 2021-10-15 | Casey | Kentucky | 21045 | 2789 | 53 |
1771063 | 1771063 | 2021-09-30 | Langlade | Wisconsin | 55067 | 2789 | 54 |
1746139 | 1746139 | 2021-09-23 | Anderson | Kentucky | 21005 | 2789 | 34 |
1742023 | 1742023 | 2021-09-22 | Grant | Arkansas | 5053 | 2789 | 47 |
1740064 | 1740064 | 2021-09-21 | Clarke | Mississippi | 28023 | 2789 | 90 |
1722878 | 1722878 | 2021-09-16 | Meriwether | Georgia | 13199 | 2789 | 97 |
1723497 | 1723497 | 2021-09-16 | Simpson | Kentucky | 21213 | 2789 | 47 |
1717153 | 1717153 | 2021-09-14 | Clare | Michigan | 26035 | 2789 | 89 |
1713905 | 1713905 | 2021-09-13 | Clare | Michigan | 26035 | 2789 | 89 |
1703006 | 1703006 | 2021-09-10 | La Paz | Arizona | 4012 | 2789 | 85 |
1686829 | 1686829 | 2021-09-05 | Randolph | Arkansas | 5121 | 2789 | 50 |
1680269 | 1680269 | 2021-09-03 | Ashley | Arkansas | 5003 | 2789 | 39 |
1671185 | 1671185 | 2021-08-31 | Randolph | Indiana | 18135 | 2789 | 85 |
1667292 | 1667292 | 2021-08-30 | Conway | Arkansas | 5029 | 2789 | 39 |
1655311 | 1655311 | 2021-08-26 | Concordia | Louisiana | 22029 | 2789 | 66 |
1646798 | 1646798 | 2021-08-23 | Humacao | Puerto Rico | 72069 | 2789 | |
1634251 | 1634251 | 2021-08-19 | Reeves | Texas | 48389 | 2789 | 45 |
1628641 | 1628641 | 2021-08-18 | Grady | Georgia | 13131 | 2789 | 66 |
1623790 | 1623790 | 2021-08-16 | Holmes | Ohio | 39075 | 2789 | 103 |
1620543 | 1620543 | 2021-08-15 | Holmes | Ohio | 39075 | 2789 | 103 |
1611879 | 1611879 | 2021-08-12 | Jackson | Wisconsin | 55053 | 2789 | 29 |
1604110 | 1604110 | 2021-08-10 | Anson | North Carolina | 37007 | 2789 | 56 |
1595993 | 1595993 | 2021-08-08 | Morgan | Colorado | 8087 | 2789 | 96 |
1592744 | 1592744 | 2021-08-07 | Morgan | Colorado | 8087 | 2789 | 96 |
1589495 | 1589495 | 2021-08-06 | Morgan | Colorado | 8087 | 2789 | 96 |
1573708 | 1573708 | 2021-08-01 | LaGrange | Indiana | 18087 | 2789 | 74 |
1570460 | 1570460 | 2021-07-31 | LaGrange | Indiana | 18087 | 2789 | 74 |
1567212 | 1567212 | 2021-07-30 | LaGrange | Indiana | 18087 | 2789 | 74 |
1551751 | 1551751 | 2021-07-25 | Crawford | Missouri | 29055 | 2789 | 41 |
1549074 | 1549074 | 2021-07-24 | Hardin | Ohio | 39065 | 2789 | 65 |
1541945 | 1541945 | 2021-07-22 | Marion | Mississippi | 28091 | 2789 | 80 |
1535577 | 1535577 | 2021-07-20 | Randolph | Missouri | 29175 | 2789 | 31 |
1444658 | 1444658 | 2021-06-22 | McDonald | Missouri | 29119 | 2789 | 38 |
1441460 | 1441460 | 2021-06-21 | Washington | Missouri | 29221 | 2789 | 52 |
1438214 | 1438214 | 2021-06-20 | Washington | Missouri | 29221 | 2789 | 52 |
1434967 | 1434967 | 2021-06-19 | Washington | Missouri | 29221 | 2789 | 52 |
1431720 | 1431720 | 2021-06-18 | Washington | Missouri | 29221 | 2789 | 52 |
1354823 | 1354823 | 2021-05-25 | Smith | Tennessee | 47159 | 2789 | 39 |
1340564 | 1340564 | 2021-05-21 | Cass | Minnesota | 27021 | 2789 | 31 |
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);