ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
114 rows where deaths = 705 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Louisiana 13
- Ohio 10
- Texas 9
- Tennessee 8
- Georgia 7
- Indiana 7
- Pennsylvania 7
- Alabama 6
- Florida 5
- New Jersey 5
- South Carolina 5
- Colorado 4
- Illinois 4
- Washington 4
- Michigan 3
- New Hampshire 3
- Maryland 2
- Missouri 2
- New York 2
- Arkansas 1
- Massachusetts 1
- Minnesota 1
- North Carolina 1
- Oklahoma 1
- Puerto Rico 1
- Virginia 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2461621 | 2461621 | 2022-05-01 | Calcasieu | Louisiana | 22019 | 54731 | 705 |
2458365 | 2458365 | 2022-04-30 | Calcasieu | Louisiana | 22019 | 54731 | 705 |
2455109 | 2455109 | 2022-04-29 | Calcasieu | Louisiana | 22019 | 54731 | 705 |
2451853 | 2451853 | 2022-04-28 | Calcasieu | Louisiana | 22019 | 54726 | 705 |
2448597 | 2448597 | 2022-04-27 | Calcasieu | Louisiana | 22019 | 54713 | 705 |
2445341 | 2445341 | 2022-04-26 | Calcasieu | Louisiana | 22019 | 54707 | 705 |
2442085 | 2442085 | 2022-04-25 | Calcasieu | Louisiana | 22019 | 54701 | 705 |
2438829 | 2438829 | 2022-04-24 | Calcasieu | Louisiana | 22019 | 54689 | 705 |
2435573 | 2435573 | 2022-04-23 | Calcasieu | Louisiana | 22019 | 54689 | 705 |
2432317 | 2432317 | 2022-04-22 | Calcasieu | Louisiana | 22019 | 54689 | 705 |
2429061 | 2429061 | 2022-04-21 | Calcasieu | Louisiana | 22019 | 54683 | 705 |
2378455 | 2378455 | 2022-04-05 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2378963 | 2378963 | 2022-04-05 | Kanawha | West Virginia | 54039 | 47089 | 705 |
2375201 | 2375201 | 2022-04-04 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2371949 | 2371949 | 2022-04-03 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2368696 | 2368696 | 2022-04-02 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2365443 | 2365443 | 2022-04-01 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2362190 | 2362190 | 2022-03-31 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2358936 | 2358936 | 2022-03-30 | Sullivan | Tennessee | 47163 | 45721 | 705 |
2283787 | 2283787 | 2022-03-07 | Cambria | Pennsylvania | 42021 | 34351 | 705 |
2280535 | 2280535 | 2022-03-06 | Cambria | Pennsylvania | 42021 | 34345 | 705 |
2248010 | 2248010 | 2022-02-24 | Beaver | Pennsylvania | 42007 | 39635 | 705 |
2216544 | 2216544 | 2022-02-15 | Tuscaloosa | Alabama | 1125 | 53493 | 705 |
2196003 | 2196003 | 2022-02-08 | Erie | Pennsylvania | 42049 | 55324 | 705 |
2174691 | 2174691 | 2022-02-02 | Muscogee | Georgia | 13215 | 36446 | 705 |
2172884 | 2172884 | 2022-02-01 | Gaston | North Carolina | 37071 | 61140 | 705 |
2128938 | 2128938 | 2022-01-19 | Pueblo | Colorado | 8101 | 38120 | 705 |
2109243 | 2109243 | 2022-01-13 | Benton | Arkansas | 5007 | 52356 | 705 |
2107207 | 2107207 | 2022-01-12 | Anoka | Minnesota | 27003 | 78044 | 705 |
2103086 | 2103086 | 2022-01-11 | Hall | Georgia | 13139 | 46066 | 705 |
2099835 | 2099835 | 2022-01-10 | Hall | Georgia | 13139 | 45444 | 705 |
2087073 | 2087073 | 2022-01-06 | Winnebago | Illinois | 17201 | 57705 | 705 |
2088509 | 2088509 | 2022-01-06 | Trumbull | Ohio | 39155 | 34109 | 705 |
2085258 | 2085258 | 2022-01-05 | Trumbull | Ohio | 39155 | 33822 | 705 |
2082006 | 2082006 | 2022-01-04 | Trumbull | Ohio | 39155 | 33530 | 705 |
2078754 | 2078754 | 2022-01-03 | Trumbull | Ohio | 39155 | 33159 | 705 |
2075503 | 2075503 | 2022-01-02 | Trumbull | Ohio | 39155 | 32836 | 705 |
2072252 | 2072252 | 2022-01-01 | Trumbull | Ohio | 39155 | 32074 | 705 |
2069001 | 2069001 | 2021-12-31 | Trumbull | Ohio | 39155 | 32074 | 705 |
2051390 | 2051390 | 2021-12-26 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2048140 | 2048140 | 2021-12-25 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2044890 | 2044890 | 2021-12-24 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2041641 | 2041641 | 2021-12-23 | St. Joseph | Indiana | 18141 | 53755 | 705 |
2038391 | 2038391 | 2021-12-22 | St. Joseph | Indiana | 18141 | 53755 | 705 |
1944661 | 1944661 | 2021-11-23 | Saginaw | Michigan | 26145 | 31880 | 705 |
1941410 | 1941410 | 2021-11-22 | Saginaw | Michigan | 26145 | 31880 | 705 |
1938631 | 1938631 | 2021-11-21 | Hillsborough | New Hampshire | 33011 | 51150 | 705 |
1935381 | 1935381 | 2021-11-20 | Hillsborough | New Hampshire | 33011 | 51150 | 705 |
1932131 | 1932131 | 2021-11-19 | Hillsborough | New Hampshire | 33011 | 51150 | 705 |
1933053 | 1933053 | 2021-11-19 | Galveston | Texas | 48167 | 64948 | 705 |
1929802 | 1929802 | 2021-11-18 | Galveston | Texas | 48167 | 64907 | 705 |
1926552 | 1926552 | 2021-11-17 | Galveston | Texas | 48167 | 64883 | 705 |
1900295 | 1900295 | 2021-11-09 | Lexington | South Carolina | 45063 | 54700 | 705 |
1897045 | 1897045 | 2021-11-08 | Lexington | South Carolina | 45063 | 54683 | 705 |
1882108 | 1882108 | 2021-11-04 | Richmond | Georgia | 13245 | 35161 | 705 |
1871894 | 1871894 | 2021-11-01 | Madison | Alabama | 1089 | 52833 | 705 |
1868645 | 1868645 | 2021-10-31 | Madison | Alabama | 1089 | 52810 | 705 |
1865396 | 1865396 | 2021-10-30 | Madison | Alabama | 1089 | 52779 | 705 |
1862147 | 1862147 | 2021-10-29 | Madison | Alabama | 1089 | 52782 | 705 |
1861302 | 1861302 | 2021-10-28 | Lexington | South Carolina | 45063 | 54199 | 705 |
1854994 | 1854994 | 2021-10-26 | Bell | Texas | 48027 | 38344 | 705 |
1846278 | 1846278 | 2021-10-24 | Clayton | Georgia | 13063 | 39088 | 705 |
1843028 | 1843028 | 2021-10-23 | Clayton | Georgia | 13063 | 39088 | 705 |
1839778 | 1839778 | 2021-10-22 | Clayton | Georgia | 13063 | 39088 | 705 |
1842142 | 1842142 | 2021-10-22 | McLennan | Texas | 48309 | 41989 | 705 |
1829346 | 1829346 | 2021-10-18 | Henrico | Virginia | 51087 | 33845 | 705 |
1815785 | 1815785 | 2021-10-14 | Anderson | South Carolina | 45007 | 35787 | 705 |
1787214 | 1787214 | 2021-10-05 | Snohomish | Washington | 53061 | 60219 | 705 |
1738032 | 1738032 | 2021-09-20 | Brazoria | Texas | 48039 | 55139 | 705 |
1734782 | 1734782 | 2021-09-19 | Brazoria | Texas | 48039 | 55139 | 705 |
1726009 | 1726009 | 2021-09-17 | Osceola | Florida | 12097 | 68321 | 705 |
1722760 | 1722760 | 2021-09-16 | Osceola | Florida | 12097 | 66882 | 705 |
1719511 | 1719511 | 2021-09-15 | Osceola | Florida | 12097 | 66882 | 705 |
1720345 | 1720345 | 2021-09-15 | Anne Arundel | Maryland | 24003 | 48859 | 705 |
1716263 | 1716263 | 2021-09-14 | Osceola | Florida | 12097 | 66882 | 705 |
1717097 | 1717097 | 2021-09-14 | Anne Arundel | Maryland | 24003 | 48748 | 705 |
1668959 | 1668959 | 2021-08-30 | Atlantic | New Jersey | 34001 | 34222 | 705 |
1665712 | 1665712 | 2021-08-29 | Atlantic | New Jersey | 34001 | 34135 | 705 |
1662464 | 1662464 | 2021-08-28 | Atlantic | New Jersey | 34001 | 34051 | 705 |
1659216 | 1659216 | 2021-08-27 | Atlantic | New Jersey | 34001 | 33981 | 705 |
1655967 | 1655967 | 2021-08-26 | Atlantic | New Jersey | 34001 | 33832 | 705 |
1611790 | 1611790 | 2021-08-12 | Spokane | Washington | 53063 | 51535 | 705 |
1446728 | 1446728 | 2021-06-23 | Unknown | Florida | 7299 | 705 | |
1356168 | 1356168 | 2021-05-26 | Allen | Indiana | 18003 | 41330 | 705 |
1352922 | 1352922 | 2021-05-25 | Allen | Indiana | 18003 | 41294 | 705 |
1276176 | 1276176 | 2021-05-01 | Orange | New York | 36071 | 47264 | 705 |
1175951 | 1175951 | 2021-03-31 | Westmoreland | Pennsylvania | 42129 | 29178 | 705 |
1172704 | 1172704 | 2021-03-30 | Westmoreland | Pennsylvania | 42129 | 29052 | 705 |
1130048 | 1130048 | 2021-03-17 | Rockland | New York | 36087 | 41359 | 705 |
1081925 | 1081925 | 2021-03-02 | Spartanburg | South Carolina | 45083 | 35962 | 705 |
1055708 | 1055708 | 2021-02-22 | Oklahoma | Oklahoma | 40109 | 79884 | 705 |
1047060 | 1047060 | 2021-02-20 | Mobile | Alabama | 1097 | 35289 | 705 |
1047286 | 1047286 | 2021-02-20 | Jefferson | Colorado | 8059 | 36435 | 705 |
994611 | 994611 | 2021-02-03 | Lubbock | Texas | 48303 | 47195 | 705 |
988856 | 988856 | 2021-02-02 | El Paso | Colorado | 8041 | 48003 | 705 |
985609 | 985609 | 2021-02-01 | El Paso | Colorado | 8041 | 47890 | 705 |
960027 | 960027 | 2021-01-24 | Kane | Illinois | 17089 | 47171 | 705 |
956781 | 956781 | 2021-01-23 | Kane | Illinois | 17089 | 47054 | 705 |
945239 | 945239 | 2021-01-19 | Franklin | Ohio | 39049 | 98533 | 705 |
941992 | 941992 | 2021-01-18 | Franklin | Ohio | 39049 | 97996 | 705 |
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);