ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
198 rows where cases = 2759 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Texas 14
- Ohio 11
- Virginia 11
- Louisiana 10
- Missouri 10
- Oklahoma 10
- Florida 7
- Kentucky 7
- South Dakota 7
- Arkansas 6
- Colorado 6
- Illinois 6
- Indiana 6
- Mississippi 6
- West Virginia 5
- North Carolina 4
- South Carolina 4
- Tennessee 4
- Utah 4
- Wisconsin 4
- Minnesota 3
- Puerto Rico 3
- Alabama 2
- Idaho 2
- Iowa 2
- Maryland 2
- Michigan 2
- Nebraska 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2369774 | 2369774 | 2022-04-03 | Early | Georgia | 13099 | 2759 | 61 |
2366521 | 2366521 | 2022-04-02 | Early | Georgia | 13099 | 2759 | 61 |
2363268 | 2363268 | 2022-04-01 | Early | Georgia | 13099 | 2759 | 61 |
2353507 | 2353507 | 2022-03-29 | Early | Georgia | 13099 | 2759 | 60 |
2350255 | 2350255 | 2022-03-28 | Early | Georgia | 13099 | 2759 | 60 |
2347223 | 2347223 | 2022-03-27 | Marshall | Illinois | 17123 | 2759 | 33 |
2343970 | 2343970 | 2022-03-26 | Marshall | Illinois | 17123 | 2759 | 33 |
2340717 | 2340717 | 2022-03-25 | Marshall | Illinois | 17123 | 2759 | 33 |
2337464 | 2337464 | 2022-03-24 | Marshall | Illinois | 17123 | 2759 | 33 |
2301502 | 2301502 | 2022-03-13 | Long | Georgia | 13183 | 2759 | 34 |
2298250 | 2298250 | 2022-03-12 | Long | Georgia | 13183 | 2759 | 34 |
2294998 | 2294998 | 2022-03-11 | Long | Georgia | 13183 | 2759 | 34 |
2291746 | 2291746 | 2022-03-10 | Long | Georgia | 13183 | 2759 | 34 |
2268854 | 2268854 | 2022-03-03 | Lafayette | Florida | 12067 | 2759 | 55 |
2265601 | 2265601 | 2022-03-02 | Lafayette | Florida | 12067 | 2759 | 55 |
2262350 | 2262350 | 2022-03-01 | Lafayette | Florida | 12067 | 2759 | 51 |
2264199 | 2264199 | 2022-03-01 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2259099 | 2259099 | 2022-02-28 | Lafayette | Florida | 12067 | 2759 | 51 |
2260949 | 2260949 | 2022-02-28 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2255848 | 2255848 | 2022-02-27 | Lafayette | Florida | 12067 | 2759 | 51 |
2257698 | 2257698 | 2022-02-27 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2252597 | 2252597 | 2022-02-26 | Lafayette | Florida | 12067 | 2759 | 51 |
2254447 | 2254447 | 2022-02-26 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2249346 | 2249346 | 2022-02-25 | Lafayette | Florida | 12067 | 2759 | 51 |
2251196 | 2251196 | 2022-02-25 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2251647 | 2251647 | 2022-02-25 | Callahan | Texas | 48059 | 2759 | 72 |
2247945 | 2247945 | 2022-02-24 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2248396 | 2248396 | 2022-02-24 | Callahan | Texas | 48059 | 2759 | 72 |
2244694 | 2244694 | 2022-02-23 | Nowata | Oklahoma | 40105 | 2759 | 35 |
2240311 | 2240311 | 2022-02-22 | Lyon | Kentucky | 21143 | 2759 | 33 |
2223299 | 2223299 | 2022-02-17 | Unknown | Connecticut | 2759 | 0 | |
2187618 | 2187618 | 2022-02-06 | Charlton | Georgia | 13049 | 2759 | 58 |
2184365 | 2184365 | 2022-02-05 | Charlton | Georgia | 13049 | 2759 | 58 |
2181113 | 2181113 | 2022-02-04 | Charlton | Georgia | 13049 | 2759 | 58 |
2120941 | 2120941 | 2022-01-16 | Walsh | North Dakota | 38099 | 2759 | 34 |
2117729 | 2117729 | 2022-01-15 | Harrison | Ohio | 39067 | 2759 | 61 |
2077379 | 2077379 | 2022-01-03 | Parke | Indiana | 18121 | 2759 | 36 |
2065581 | 2065581 | 2021-12-30 | Northampton | North Carolina | 37131 | 2759 | 66 |
2054333 | 2054333 | 2021-12-27 | Jefferson | Georgia | 13163 | 2759 | 93 |
2032462 | 2032462 | 2021-12-20 | Faribault | Minnesota | 27043 | 2759 | 37 |
2033888 | 2033888 | 2021-12-20 | Llano | Texas | 48299 | 2759 | 83 |
1988995 | 1988995 | 2021-12-07 | Izard | Arkansas | 5065 | 2759 | 55 |
1991797 | 1991797 | 2021-12-07 | Buckingham | Virginia | 51029 | 2759 | 40 |
1941661 | 1941661 | 2021-11-22 | Moniteau | Missouri | 29135 | 2759 | 46 |
1930085 | 1930085 | 2021-11-18 | King George | Virginia | 51099 | 2759 | 24 |
1905058 | 1905058 | 2021-11-11 | Carroll | Indiana | 18015 | 2759 | 39 |
1905074 | 1905074 | 2021-11-11 | Franklin | Indiana | 18047 | 2759 | 47 |
1887946 | 1887946 | 2021-11-05 | Barbour | West Virginia | 54001 | 2759 | 45 |
1883355 | 1883355 | 2021-11-04 | Unknown | Nebraska | 2759 | 153 | |
1872624 | 1872624 | 2021-11-01 | Rush | Indiana | 18139 | 2759 | 32 |
1868867 | 1868867 | 2021-10-31 | Elbert | Colorado | 8039 | 2759 | 23 |
1865618 | 1865618 | 2021-10-30 | Elbert | Colorado | 8039 | 2759 | 23 |
1862369 | 1862369 | 2021-10-29 | Elbert | Colorado | 8039 | 2759 | 23 |
1863627 | 1863627 | 2021-10-29 | Cooper | Missouri | 29053 | 2759 | 33 |
1864433 | 1864433 | 2021-10-29 | Wyoming | Pennsylvania | 42131 | 2759 | 63 |
1847356 | 1847356 | 2021-10-24 | Andrew | Missouri | 29003 | 2759 | 24 |
1848977 | 1848977 | 2021-10-24 | Lincoln | West Virginia | 54043 | 2759 | 42 |
1828485 | 1828485 | 2021-10-18 | Paulding | Ohio | 39125 | 2759 | 45 |
1817838 | 1817838 | 2021-10-15 | Talbot | Maryland | 24041 | 2759 | 51 |
1807977 | 1807977 | 2021-10-12 | Spencer | Kentucky | 21215 | 2759 | 31 |
1806503 | 1806503 | 2021-10-11 | Duchesne | Utah | 49013 | 2759 | 16 |
1803253 | 1803253 | 2021-10-10 | Duchesne | Utah | 49013 | 2759 | 16 |
1800004 | 1800004 | 2021-10-09 | Duchesne | Utah | 49013 | 2759 | 16 |
1796755 | 1796755 | 2021-10-08 | Duchesne | Utah | 49013 | 2759 | 16 |
1758694 | 1758694 | 2021-09-27 | Blaine | Idaho | 16013 | 2759 | 20 |
1738181 | 1738181 | 2021-09-20 | Montague | Texas | 48337 | 2759 | 82 |
1734931 | 1734931 | 2021-09-19 | Montague | Texas | 48337 | 2759 | 82 |
1731681 | 1731681 | 2021-09-18 | Montague | Texas | 48337 | 2759 | 82 |
1709869 | 1709869 | 2021-09-12 | Jeff Davis | Georgia | 13161 | 2759 | 46 |
1711996 | 1711996 | 2021-09-12 | Polk | Tennessee | 47139 | 2759 | 25 |
1706622 | 1706622 | 2021-09-11 | Jeff Davis | Georgia | 13161 | 2759 | 46 |
1708749 | 1708749 | 2021-09-11 | Polk | Tennessee | 47139 | 2759 | 25 |
1703374 | 1703374 | 2021-09-10 | Jeff Davis | Georgia | 13161 | 2759 | 46 |
1705502 | 1705502 | 2021-09-10 | Polk | Tennessee | 47139 | 2759 | 25 |
1702770 | 1702770 | 2021-09-09 | Jackson | West Virginia | 54035 | 2759 | 64 |
1690338 | 1690338 | 2021-09-06 | Crisp | Georgia | 13081 | 2759 | 96 |
1687088 | 1687088 | 2021-09-05 | Crisp | Georgia | 13081 | 2759 | 96 |
1683838 | 1683838 | 2021-09-04 | Crisp | Georgia | 13081 | 2759 | 96 |
1680587 | 1680587 | 2021-09-03 | Crisp | Georgia | 13081 | 2759 | 96 |
1653577 | 1653577 | 2021-08-25 | Burleson | Texas | 48051 | 2759 | 49 |
1649624 | 1649624 | 2021-08-24 | Greene | North Carolina | 37079 | 2759 | 49 |
1650026 | 1650026 | 2021-08-24 | Canovanas | Puerto Rico | 72029 | 2759 | |
1642600 | 1642600 | 2021-08-22 | Attala | Mississippi | 28007 | 2759 | 78 |
1639350 | 1639350 | 2021-08-21 | Attala | Mississippi | 28007 | 2759 | 78 |
1636100 | 1636100 | 2021-08-20 | Attala | Mississippi | 28007 | 2759 | 78 |
1634183 | 1634183 | 2021-08-19 | Jones | Texas | 48253 | 2759 | 57 |
1628807 | 1628807 | 2021-08-18 | Douglas | Illinois | 17041 | 2759 | 42 |
1625394 | 1625394 | 2021-08-17 | Grady | Georgia | 13131 | 2759 | 66 |
1598889 | 1598889 | 2021-08-08 | Kewaunee | Wisconsin | 55061 | 2759 | 37 |
1595640 | 1595640 | 2021-08-07 | Kewaunee | Wisconsin | 55061 | 2759 | 37 |
1592391 | 1592391 | 2021-08-06 | Kewaunee | Wisconsin | 55061 | 2759 | 37 |
1588897 | 1588897 | 2021-08-05 | Botetourt | Virginia | 51023 | 2759 | 37 |
1585265 | 1585265 | 2021-08-04 | Grainger | Tennessee | 47057 | 2759 | 51 |
1579864 | 1579864 | 2021-08-03 | Burke | Georgia | 13033 | 2759 | 66 |
1577706 | 1577706 | 2021-08-02 | Adair | Missouri | 29001 | 2759 | 25 |
1574458 | 1574458 | 2021-08-01 | Adair | Missouri | 29001 | 2759 | 25 |
1571210 | 1571210 | 2021-07-31 | Adair | Missouri | 29001 | 2759 | 25 |
1567962 | 1567962 | 2021-07-30 | Adair | Missouri | 29001 | 2759 | 25 |
1566164 | 1566164 | 2021-07-29 | Carroll | Virginia | 51035 | 2759 | 79 |
1553255 | 1553255 | 2021-07-25 | Pulaski | Virginia | 51155 | 2759 | 64 |
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);