ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
162 rows where cases = 3409 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 15
- Arkansas 11
- Mississippi 11
- Georgia 10
- Minnesota 10
- Iowa 8
- Illinois 7
- Missouri 7
- Kentucky 6
- Indiana 5
- Louisiana 5
- Wisconsin 5
- Massachusetts 4
- North Carolina 4
- Pennsylvania 4
- Puerto Rico 4
- Tennessee 4
- Washington 4
- West Virginia 4
- Alabama 3
- Montana 3
- New York 3
- Ohio 3
- Virginia 3
- Alaska 2
- California 2
- Maryland 2
- Michigan 2
- Nebraska 2
- New Mexico 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499730 | 2499730 | 2022-05-13 | Marion | Arkansas | 5089 | 3409 | 88 |
2496225 | 2496225 | 2022-05-11 | Bayfield | Wisconsin | 55007 | 3409 | 41 |
2422656 | 2422656 | 2022-04-19 | Nantucket | Massachusetts | 25019 | 3409 | 0 |
2394025 | 2394025 | 2022-04-10 | Yates | New York | 36123 | 3409 | 39 |
2382742 | 2382742 | 2022-04-07 | Bacon | Georgia | 13005 | 3409 | 71 |
2385563 | 2385563 | 2022-04-07 | Rusk | Wisconsin | 55107 | 3409 | 54 |
2353461 | 2353461 | 2022-03-29 | Bacon | Georgia | 13005 | 3409 | 71 |
2350209 | 2350209 | 2022-03-28 | Bacon | Georgia | 13005 | 3409 | 69 |
2291962 | 2291962 | 2022-03-10 | Washington | Illinois | 17189 | 3409 | 40 |
2263092 | 2263092 | 2022-03-01 | Pendleton | Kentucky | 21191 | 3409 | 34 |
2263987 | 2263987 | 2022-03-01 | Swain | North Carolina | 37173 | 3409 | 35 |
2248137 | 2248137 | 2022-02-24 | San German | Puerto Rico | 72125 | 3409 | |
2228353 | 2228353 | 2022-02-18 | Monroe | Ohio | 39111 | 3409 | 73 |
2209596 | 2209596 | 2022-02-12 | Wilbarger | Texas | 48487 | 3409 | 83 |
2192161 | 2192161 | 2022-02-07 | Gage | Nebraska | 31067 | 3409 | 37 |
2177531 | 2177531 | 2022-02-03 | Northwest Arctic Borough | Alaska | 2188 | 3409 | 11 |
2174278 | 2174278 | 2022-02-02 | Northwest Arctic Borough | Alaska | 2188 | 3409 | 11 |
2167542 | 2167542 | 2022-01-30 | Braxton | West Virginia | 54007 | 3409 | 35 |
2151298 | 2151298 | 2022-01-25 | Monroe | West Virginia | 54063 | 3409 | 33 |
2134775 | 2134775 | 2022-01-20 | Zavala | Texas | 48507 | 3409 | 56 |
2126796 | 2126796 | 2022-01-18 | Wadena | Minnesota | 27159 | 3409 | 46 |
2121623 | 2121623 | 2022-01-16 | Houston | Texas | 48225 | 3409 | 91 |
2074758 | 2074758 | 2022-01-02 | Roseau | Minnesota | 27135 | 3409 | 37 |
2071507 | 2071507 | 2022-01-01 | Roseau | Minnesota | 27135 | 3409 | 37 |
2068256 | 2068256 | 2021-12-31 | Roseau | Minnesota | 27135 | 3409 | 37 |
2065005 | 2065005 | 2021-12-30 | Roseau | Minnesota | 27135 | 3409 | 37 |
2053673 | 2053673 | 2021-12-26 | Adams | Washington | 53001 | 3409 | 34 |
2050423 | 2050423 | 2021-12-25 | Adams | Washington | 53001 | 3409 | 34 |
2047173 | 2047173 | 2021-12-24 | Adams | Washington | 53001 | 3409 | 34 |
2043923 | 2043923 | 2021-12-23 | Adams | Washington | 53001 | 3409 | 34 |
1996989 | 1996989 | 2021-12-09 | Hill | Montana | 30041 | 3409 | 71 |
1992223 | 1992223 | 2021-12-08 | Clark | Arkansas | 5019 | 3409 | 63 |
1978956 | 1978956 | 2021-12-03 | Brooke | West Virginia | 54009 | 3409 | 78 |
1970799 | 1970799 | 2021-12-01 | Jasper | Mississippi | 28061 | 3409 | 66 |
1953222 | 1953222 | 2021-11-26 | Columbia | Arkansas | 5027 | 3409 | 74 |
1949971 | 1949971 | 2021-11-25 | Columbia | Arkansas | 5027 | 3409 | 74 |
1943469 | 1943469 | 2021-11-23 | Columbia | Arkansas | 5027 | 3409 | 74 |
1940219 | 1940219 | 2021-11-22 | Columbia | Arkansas | 5027 | 3409 | 74 |
1936969 | 1936969 | 2021-11-21 | Columbia | Arkansas | 5027 | 3409 | 74 |
1930349 | 1930349 | 2021-11-19 | Butler | Alabama | 1013 | 3409 | 100 |
1926805 | 1926805 | 2021-11-17 | Dinwiddie | Virginia | 51053 | 3409 | 58 |
1915316 | 1915316 | 2021-11-14 | Somerset | Maryland | 24039 | 3409 | 54 |
1904391 | 1904391 | 2021-11-11 | Marengo | Alabama | 1091 | 3409 | 93 |
1905986 | 1905986 | 2021-11-11 | Lincoln | Montana | 30053 | 3409 | 58 |
1902737 | 1902737 | 2021-11-10 | Lincoln | Montana | 30053 | 3409 | 58 |
1898704 | 1898704 | 2021-11-09 | Mahaska | Iowa | 19123 | 3409 | 59 |
1895454 | 1895454 | 2021-11-08 | Mahaska | Iowa | 19123 | 3409 | 59 |
1892204 | 1892204 | 2021-11-07 | Mahaska | Iowa | 19123 | 3409 | 59 |
1888954 | 1888954 | 2021-11-06 | Mahaska | Iowa | 19123 | 3409 | 59 |
1885704 | 1885704 | 2021-11-05 | Mahaska | Iowa | 19123 | 3409 | 59 |
1882088 | 1882088 | 2021-11-04 | Mitchell | Georgia | 13205 | 3409 | 100 |
1882455 | 1882455 | 2021-11-04 | Mahaska | Iowa | 19123 | 3409 | 59 |
1878839 | 1878839 | 2021-11-03 | Mitchell | Georgia | 13205 | 3409 | 100 |
1879206 | 1879206 | 2021-11-03 | Mahaska | Iowa | 19123 | 3409 | 59 |
1879757 | 1879757 | 2021-11-03 | Waseca | Minnesota | 27161 | 3409 | 31 |
1862265 | 1862265 | 2021-10-29 | Ouachita | Arkansas | 5103 | 3409 | 85 |
1859016 | 1859016 | 2021-10-28 | Ouachita | Arkansas | 5103 | 3409 | 85 |
1849884 | 1849884 | 2021-10-25 | Spencer | Indiana | 18147 | 3409 | 43 |
1847091 | 1847091 | 2021-10-24 | Franklin | Massachusetts | 25011 | 3409 | 122 |
1843841 | 1843841 | 2021-10-23 | Franklin | Massachusetts | 25011 | 3409 | 122 |
1840591 | 1840591 | 2021-10-22 | Franklin | Massachusetts | 25011 | 3409 | 122 |
1834769 | 1834769 | 2021-10-20 | Ashe | North Carolina | 37009 | 3409 | 48 |
1804668 | 1804668 | 2021-10-11 | Hart | Kentucky | 21099 | 3409 | 61 |
1806803 | 1806803 | 2021-10-11 | Kewaunee | Wisconsin | 55061 | 3409 | 41 |
1792491 | 1792491 | 2021-10-07 | Lewis | New York | 36049 | 3409 | 38 |
1793335 | 1793335 | 2021-10-07 | Gray | Texas | 48179 | 3409 | 71 |
1785312 | 1785312 | 2021-10-05 | Aroostook | Maine | 23003 | 3409 | 74 |
1786223 | 1786223 | 2021-10-05 | Holmes | Ohio | 39075 | 3409 | 112 |
1781956 | 1781956 | 2021-10-04 | McCreary | Kentucky | 21147 | 3409 | 48 |
1778706 | 1778706 | 2021-10-03 | McCreary | Kentucky | 21147 | 3409 | 48 |
1775456 | 1775456 | 2021-10-02 | McCreary | Kentucky | 21147 | 3409 | 48 |
1765018 | 1765018 | 2021-09-29 | Appling | Georgia | 13001 | 3409 | 89 |
1767180 | 1767180 | 2021-09-29 | Fentress | Tennessee | 47049 | 3409 | 59 |
1767622 | 1767622 | 2021-09-29 | Lee | Virginia | 51105 | 3409 | 52 |
1741350 | 1741350 | 2021-09-21 | Gonzales | Texas | 48177 | 3409 | 73 |
1736886 | 1736886 | 2021-09-20 | Adair | Missouri | 29001 | 3409 | 31 |
1733636 | 1733636 | 2021-09-19 | Adair | Missouri | 29001 | 3409 | 31 |
1730386 | 1730386 | 2021-09-18 | Adair | Missouri | 29001 | 3409 | 31 |
1727136 | 1727136 | 2021-09-17 | Adair | Missouri | 29001 | 3409 | 31 |
1723887 | 1723887 | 2021-09-16 | Adair | Missouri | 29001 | 3409 | 31 |
1719575 | 1719575 | 2021-09-15 | Dodge | Georgia | 13091 | 3409 | 114 |
1713108 | 1713108 | 2021-09-13 | Harris | Georgia | 13145 | 3409 | 69 |
1714125 | 1714125 | 2021-09-13 | Stone | Mississippi | 28131 | 3409 | 53 |
1696866 | 1696866 | 2021-09-08 | Haralson | Georgia | 13143 | 3409 | 94 |
1697530 | 1697530 | 2021-09-08 | Assumption | Louisiana | 22007 | 3409 | 51 |
1699104 | 1699104 | 2021-09-08 | Fayette | Texas | 48149 | 3409 | 80 |
1695480 | 1695480 | 2021-09-07 | Tioga | Pennsylvania | 42117 | 3409 | 114 |
1652518 | 1652518 | 2021-08-25 | Saline | Missouri | 29195 | 3409 | 41 |
1642636 | 1642636 | 2021-08-22 | Leake | Mississippi | 28079 | 3409 | 77 |
1639386 | 1639386 | 2021-08-21 | Leake | Mississippi | 28079 | 3409 | 77 |
1636136 | 1636136 | 2021-08-20 | Leake | Mississippi | 28079 | 3409 | 77 |
1622833 | 1622833 | 2021-08-16 | Franklin | Louisiana | 22041 | 3409 | 111 |
1614245 | 1614245 | 2021-08-13 | Jefferson | Pennsylvania | 42065 | 3409 | 99 |
1595822 | 1595822 | 2021-08-08 | Carroll | Arkansas | 5015 | 3409 | 52 |
1574376 | 1574376 | 2021-08-01 | Adams | Mississippi | 28001 | 3409 | 88 |
1571128 | 1571128 | 2021-07-31 | Adams | Mississippi | 28001 | 3409 | 88 |
1567880 | 1567880 | 2021-07-30 | Adams | Mississippi | 28001 | 3409 | 88 |
1518880 | 1518880 | 2021-07-15 | Beauregard | Louisiana | 22011 | 3409 | 79 |
1511826 | 1511826 | 2021-07-13 | Bonner | Idaho | 16017 | 3409 | 45 |
1513033 | 1513033 | 2021-07-13 | Lyon | Nevada | 32019 | 3409 | 65 |
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);