ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
197 rows where cases = 2879 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 18
- Indiana 14
- Louisiana 12
- Arkansas 11
- Tennessee 11
- Iowa 9
- Texas 9
- Minnesota 8
- Ohio 8
- Virginia 8
- Mississippi 7
- Oklahoma 7
- Kentucky 6
- North Carolina 6
- South Dakota 6
- Georgia 5
- Idaho 5
- New York 5
- South Carolina 5
- Alabama 4
- West Virginia 4
- Wisconsin 4
- Illinois 3
- Nevada 3
- California 2
- Colorado 2
- Nebraska 2
- North Dakota 2
- Pennsylvania 2
- Puerto Rico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369400 | 2369400 | 2022-04-03 | Wilcox | Alabama | 1131 | 2879 | 46 |
2366147 | 2366147 | 2022-04-02 | Wilcox | Alabama | 1131 | 2879 | 46 |
2362894 | 2362894 | 2022-04-01 | Wilcox | Alabama | 1131 | 2879 | 46 |
2281659 | 2281659 | 2022-03-07 | Lee | Arkansas | 5077 | 2879 | 58 |
2278406 | 2278406 | 2022-03-06 | Lee | Arkansas | 5077 | 2879 | 58 |
2275153 | 2275153 | 2022-03-05 | Lee | Arkansas | 5077 | 2879 | 58 |
2271900 | 2271900 | 2022-03-04 | Lee | Arkansas | 5077 | 2879 | 58 |
2237315 | 2237315 | 2022-02-21 | Aitkin | Minnesota | 27001 | 2879 | 60 |
2234064 | 2234064 | 2022-02-20 | Aitkin | Minnesota | 27001 | 2879 | 60 |
2230813 | 2230813 | 2022-02-19 | Aitkin | Minnesota | 27001 | 2879 | 60 |
2227562 | 2227562 | 2022-02-18 | Aitkin | Minnesota | 27001 | 2879 | 60 |
2217373 | 2217373 | 2022-02-15 | Winnebago | Iowa | 19189 | 2879 | 43 |
2214122 | 2214122 | 2022-02-14 | Winnebago | Iowa | 19189 | 2879 | 43 |
2210870 | 2210870 | 2022-02-13 | Winnebago | Iowa | 19189 | 2879 | 43 |
2207617 | 2207617 | 2022-02-12 | Winnebago | Iowa | 19189 | 2879 | 43 |
2204364 | 2204364 | 2022-02-11 | Winnebago | Iowa | 19189 | 2879 | 43 |
2201111 | 2201111 | 2022-02-10 | Winnebago | Iowa | 19189 | 2879 | 43 |
2197857 | 2197857 | 2022-02-09 | Winnebago | Iowa | 19189 | 2879 | 43 |
2198965 | 2198965 | 2022-02-09 | Washington | North Carolina | 37187 | 2879 | 44 |
2195288 | 2195288 | 2022-02-08 | Pemiscot | Missouri | 29155 | 2879 | 65 |
2167947 | 2167947 | 2022-01-31 | Crowley | Colorado | 8025 | 2879 | 28 |
2152900 | 2152900 | 2022-01-26 | Tallahatchie | Mississippi | 28135 | 2879 | 54 |
2144718 | 2144718 | 2022-01-23 | Westmoreland | Virginia | 51193 | 2879 | 39 |
2141463 | 2141463 | 2022-01-22 | Westmoreland | Virginia | 51193 | 2879 | 39 |
2138207 | 2138207 | 2022-01-21 | Westmoreland | Virginia | 51193 | 2879 | 39 |
2133991 | 2133991 | 2022-01-20 | Harrison | Ohio | 39067 | 2879 | 61 |
2125792 | 2125792 | 2022-01-18 | Brooks | Georgia | 13027 | 2879 | 76 |
2113941 | 2113941 | 2022-01-14 | Madison | Missouri | 29123 | 2879 | 45 |
2099332 | 2099332 | 2022-01-09 | Richland | Wisconsin | 55103 | 2879 | 38 |
2096081 | 2096081 | 2022-01-08 | Richland | Wisconsin | 55103 | 2879 | 38 |
2092829 | 2092829 | 2022-01-07 | Richland | Wisconsin | 55103 | 2879 | 38 |
2078006 | 2078006 | 2022-01-03 | Renville | Minnesota | 27129 | 2879 | 52 |
2079512 | 2079512 | 2022-01-03 | San Juan | Utah | 49037 | 2879 | 46 |
2074509 | 2074509 | 2022-01-02 | Jackson | Louisiana | 22049 | 2879 | 64 |
2071258 | 2071258 | 2022-01-01 | Jackson | Louisiana | 22049 | 2879 | 64 |
2068007 | 2068007 | 2021-12-31 | Jackson | Louisiana | 22049 | 2879 | 64 |
2064756 | 2064756 | 2021-12-30 | Jackson | Louisiana | 22049 | 2879 | 64 |
2014980 | 2014980 | 2021-12-15 | Clay | Arkansas | 5021 | 2879 | 77 |
1987492 | 1987492 | 2021-12-06 | Schoharie | New York | 36095 | 2879 | 25 |
1968629 | 1968629 | 2021-11-30 | Union | South Dakota | 46127 | 2879 | 46 |
1928443 | 1928443 | 2021-11-18 | Fillmore | Minnesota | 27045 | 2879 | 15 |
1928617 | 1928617 | 2021-11-18 | Cooper | Missouri | 29053 | 2879 | 51 |
1924867 | 1924867 | 2021-11-17 | Casey | Kentucky | 21045 | 2879 | 58 |
1914649 | 1914649 | 2021-11-14 | Kauai | Hawaii | 15007 | 2879 | 11 |
1878485 | 1878485 | 2021-11-03 | Grant | Arkansas | 5053 | 2879 | 50 |
1875236 | 1875236 | 2021-11-02 | Grant | Arkansas | 5053 | 2879 | 50 |
1872959 | 1872959 | 2021-11-01 | Spencer | Kentucky | 21215 | 2879 | 34 |
1851152 | 1851152 | 2021-10-25 | Rolette | North Dakota | 38079 | 2879 | 32 |
1851983 | 1851983 | 2021-10-25 | Young | Texas | 48503 | 2879 | 66 |
1848733 | 1848733 | 2021-10-24 | Young | Texas | 48503 | 2879 | 66 |
1845483 | 1845483 | 2021-10-23 | Young | Texas | 48503 | 2879 | 66 |
1845732 | 1845732 | 2021-10-23 | McDowell | West Virginia | 54047 | 2879 | 47 |
1801956 | 1801956 | 2021-10-10 | Ray | Missouri | 29177 | 2879 | 48 |
1797258 | 1797258 | 2021-10-09 | Hempstead | Arkansas | 5057 | 2879 | 27 |
1761969 | 1761969 | 2021-09-28 | Minidoka | Idaho | 16067 | 2879 | 39 |
1758600 | 1758600 | 2021-09-27 | Jeff Davis | Georgia | 13161 | 2879 | 54 |
1721738 | 1721738 | 2021-09-15 | Polk | Tennessee | 47139 | 2879 | 25 |
1701797 | 1701797 | 2021-09-09 | Van Wert | Ohio | 39161 | 2879 | 68 |
1692441 | 1692441 | 2021-09-06 | Bledsoe | Tennessee | 47007 | 2879 | 13 |
1689192 | 1689192 | 2021-09-05 | Bledsoe | Tennessee | 47007 | 2879 | 13 |
1685942 | 1685942 | 2021-09-04 | Bledsoe | Tennessee | 47007 | 2879 | 13 |
1682691 | 1682691 | 2021-09-03 | Bledsoe | Tennessee | 47007 | 2879 | 13 |
1670346 | 1670346 | 2021-08-30 | Jackson | Wisconsin | 55053 | 2879 | 29 |
1664663 | 1664663 | 2021-08-29 | Jennings | Indiana | 18079 | 2879 | 54 |
1661415 | 1661415 | 2021-08-28 | Jennings | Indiana | 18079 | 2879 | 54 |
1658167 | 1658167 | 2021-08-27 | Jennings | Indiana | 18079 | 2879 | 54 |
1640324 | 1640324 | 2021-08-21 | Rio Grande | Puerto Rico | 72119 | 2879 | |
1599414 | 1599414 | 2021-08-09 | Haralson | Georgia | 13143 | 2879 | 91 |
1587449 | 1587449 | 2021-08-05 | Wayne | Mississippi | 28153 | 2879 | 45 |
1553367 | 1553367 | 2021-07-25 | Randolph | West Virginia | 54083 | 2879 | 15 |
1550120 | 1550120 | 2021-07-24 | Randolph | West Virginia | 54083 | 2879 | 15 |
1545818 | 1545818 | 2021-07-23 | Fayette | Ohio | 39047 | 2879 | 50 |
1546873 | 1546873 | 2021-07-23 | Randolph | West Virginia | 54083 | 2879 | 15 |
1541822 | 1541822 | 2021-07-22 | Cass | Minnesota | 27021 | 2879 | 33 |
1530423 | 1530423 | 2021-07-18 | Accomack | Virginia | 51001 | 2879 | 46 |
1525749 | 1525749 | 2021-07-17 | Audrain | Missouri | 29007 | 2879 | 58 |
1527176 | 1527176 | 2021-07-17 | Accomack | Virginia | 51001 | 2879 | 46 |
1523929 | 1523929 | 2021-07-16 | Accomack | Virginia | 51001 | 2879 | 46 |
1505909 | 1505909 | 2021-07-11 | Franklin | Louisiana | 22041 | 2879 | 107 |
1502663 | 1502663 | 2021-07-10 | Franklin | Louisiana | 22041 | 2879 | 107 |
1499417 | 1499417 | 2021-07-09 | Franklin | Louisiana | 22041 | 2879 | 107 |
1487875 | 1487875 | 2021-07-05 | McNairy | Tennessee | 47109 | 2879 | 55 |
1487993 | 1487993 | 2021-07-05 | Frio | Texas | 48163 | 2879 | 52 |
1484628 | 1484628 | 2021-07-04 | McNairy | Tennessee | 47109 | 2879 | 55 |
1484746 | 1484746 | 2021-07-04 | Frio | Texas | 48163 | 2879 | 52 |
1481382 | 1481382 | 2021-07-03 | McNairy | Tennessee | 47109 | 2879 | 55 |
1481500 | 1481500 | 2021-07-03 | Frio | Texas | 48163 | 2879 | 52 |
1478135 | 1478135 | 2021-07-02 | McNairy | Tennessee | 47109 | 2879 | 55 |
1478253 | 1478253 | 2021-07-02 | Frio | Texas | 48163 | 2879 | 52 |
1473865 | 1473865 | 2021-07-01 | McDonald | Missouri | 29119 | 2879 | 38 |
1471643 | 1471643 | 2021-06-30 | McNairy | Tennessee | 47109 | 2879 | 55 |
1460054 | 1460054 | 2021-06-27 | Greene | Indiana | 18055 | 2879 | 89 |
1460912 | 1460912 | 2021-06-27 | Saline | Missouri | 29195 | 2879 | 38 |
1456809 | 1456809 | 2021-06-26 | Greene | Indiana | 18055 | 2879 | 89 |
1453564 | 1453564 | 2021-06-25 | Greene | Indiana | 18055 | 2879 | 89 |
1424758 | 1424758 | 2021-06-16 | De Soto | Louisiana | 22031 | 2879 | 78 |
1414959 | 1414959 | 2021-06-13 | Marshall | Kentucky | 21157 | 2879 | 58 |
1411714 | 1411714 | 2021-06-12 | Marshall | Kentucky | 21157 | 2879 | 58 |
1399871 | 1399871 | 2021-06-08 | Seminole | Oklahoma | 40133 | 2879 | 78 |
1396626 | 1396626 | 2021-06-07 | Seminole | Oklahoma | 40133 | 2879 | 78 |
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);