ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
146 rows where deaths = 698 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 30
- Florida 20
- Pennsylvania 17
- Texas 11
- Louisiana 9
- Tennessee 8
- Georgia 7
- New York 7
- California 6
- New Jersey 6
- Ohio 6
- Colorado 5
- Missouri 5
- Arizona 4
- Virginia 4
- Illinois 3
- Maryland 3
- Minnesota 3
- North Carolina 3
- Washington 3
- West Virginia 3
- Alabama 2
- Nevada 2
- South Carolina 2
- Connecticut 1
- Idaho 1
- Massachusetts 1
- Michigan 1
- New Hampshire 1
- New Mexico 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2355682 | 2355682 | 2022-03-29 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2352429 | 2352429 | 2022-03-28 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2349177 | 2349177 | 2022-03-27 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2345924 | 2345924 | 2022-03-26 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2342671 | 2342671 | 2022-03-25 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2339418 | 2339418 | 2022-03-24 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2336164 | 2336164 | 2022-03-23 | Sullivan | Tennessee | 47163 | 45676 | 698 |
2328175 | 2328175 | 2022-03-21 | Calcasieu | Louisiana | 22019 | 54576 | 698 |
2329859 | 2329859 | 2022-03-21 | Potter | Texas | 48375 | 35671 | 698 |
2324922 | 2324922 | 2022-03-20 | Calcasieu | Louisiana | 22019 | 54573 | 698 |
2326607 | 2326607 | 2022-03-20 | Potter | Texas | 48375 | 35301 | 698 |
2321668 | 2321668 | 2022-03-19 | Calcasieu | Louisiana | 22019 | 54573 | 698 |
2323354 | 2323354 | 2022-03-19 | Potter | Texas | 48375 | 35301 | 698 |
2318414 | 2318414 | 2022-03-18 | Calcasieu | Louisiana | 22019 | 54573 | 698 |
2320100 | 2320100 | 2022-03-18 | Potter | Texas | 48375 | 35301 | 698 |
2315161 | 2315161 | 2022-03-17 | Calcasieu | Louisiana | 22019 | 54564 | 698 |
2317152 | 2317152 | 2022-03-17 | Kanawha | West Virginia | 54039 | 46983 | 698 |
2311908 | 2311908 | 2022-03-16 | Calcasieu | Louisiana | 22019 | 54545 | 698 |
2313899 | 2313899 | 2022-03-16 | Kanawha | West Virginia | 54039 | 46966 | 698 |
2308655 | 2308655 | 2022-03-15 | Calcasieu | Louisiana | 22019 | 54539 | 698 |
2310646 | 2310646 | 2022-03-15 | Kanawha | West Virginia | 54039 | 46953 | 698 |
2258957 | 2258957 | 2022-02-28 | Monterey | California | 6053 | 90725 | 698 |
2255706 | 2255706 | 2022-02-27 | Monterey | California | 6053 | 90484 | 698 |
2252455 | 2252455 | 2022-02-26 | Monterey | California | 6053 | 90484 | 698 |
2249204 | 2249204 | 2022-02-25 | Monterey | California | 6053 | 90484 | 698 |
2251267 | 2251267 | 2022-02-25 | Butler | Pennsylvania | 42019 | 43982 | 698 |
2251743 | 2251743 | 2022-02-25 | Johnson | Texas | 48251 | 41609 | 698 |
2248016 | 2248016 | 2022-02-24 | Butler | Pennsylvania | 42019 | 43963 | 698 |
2248492 | 2248492 | 2022-02-24 | Johnson | Texas | 48251 | 41523 | 698 |
2244311 | 2244311 | 2022-02-23 | Doña Ana | New Mexico | 35013 | 62339 | 698 |
2241515 | 2241515 | 2022-02-22 | Cambria | Pennsylvania | 42021 | 34141 | 698 |
2238264 | 2238264 | 2022-02-21 | Cambria | Pennsylvania | 42021 | 34080 | 698 |
2238941 | 2238941 | 2022-02-21 | Chesterfield | Virginia | 51041 | 70086 | 698 |
2235013 | 2235013 | 2022-02-20 | Cambria | Pennsylvania | 42021 | 34080 | 698 |
2203534 | 2203534 | 2022-02-11 | Tuscaloosa | Alabama | 1125 | 53228 | 698 |
2200280 | 2200280 | 2022-02-10 | Tuscaloosa | Alabama | 1125 | 53101 | 698 |
2202521 | 2202521 | 2022-02-10 | Lackawanna | Pennsylvania | 42069 | 41787 | 698 |
2196765 | 2196765 | 2022-02-08 | Virginia Beach city | Virginia | 51810 | 86969 | 698 |
2186242 | 2186242 | 2022-02-05 | Erie | Pennsylvania | 42049 | 55204 | 698 |
2177849 | 2177849 | 2022-02-03 | Bibb | Georgia | 13021 | 35621 | 698 |
2155166 | 2155166 | 2022-01-27 | Muscogee | Georgia | 13215 | 35357 | 698 |
2156271 | 2156271 | 2022-01-27 | St. Louis city | Missouri | 29510 | 53086 | 698 |
2153018 | 2153018 | 2022-01-26 | St. Louis city | Missouri | 29510 | 52825 | 698 |
2106566 | 2106566 | 2022-01-12 | St. Clair | Illinois | 17163 | 56896 | 698 |
2060570 | 2060570 | 2021-12-29 | Merced | California | 6047 | 46970 | 698 |
2036649 | 2036649 | 2021-12-21 | Cumberland | Pennsylvania | 42041 | 34694 | 698 |
2008682 | 2008682 | 2021-12-13 | Bay | Florida | 12005 | 32055 | 698 |
2005431 | 2005431 | 2021-12-12 | Bay | Florida | 12005 | 32055 | 698 |
2002180 | 2002180 | 2021-12-11 | Bay | Florida | 12005 | 32055 | 698 |
1998930 | 1998930 | 2021-12-10 | Bay | Florida | 12005 | 32055 | 698 |
1995679 | 1995679 | 2021-12-09 | Bay | Florida | 12005 | 32003 | 698 |
1992428 | 1992428 | 2021-12-08 | Bay | Florida | 12005 | 32003 | 698 |
1986260 | 1986260 | 2021-12-06 | Madison | Illinois | 17119 | 43578 | 698 |
1974889 | 1974889 | 2021-12-02 | Dauphin | Pennsylvania | 42043 | 38443 | 698 |
1919131 | 1919131 | 2021-11-15 | Hillsborough | New Hampshire | 33011 | 49908 | 698 |
1914426 | 1914426 | 2021-11-14 | Clay | Florida | 12019 | 33925 | 698 |
1911176 | 1911176 | 2021-11-13 | Clay | Florida | 12019 | 33925 | 698 |
1907927 | 1907927 | 2021-11-12 | Clay | Florida | 12019 | 33925 | 698 |
1904678 | 1904678 | 2021-11-11 | Clay | Florida | 12019 | 33858 | 698 |
1901428 | 1901428 | 2021-11-10 | Clay | Florida | 12019 | 33858 | 698 |
1898178 | 1898178 | 2021-11-09 | Clay | Florida | 12019 | 33858 | 698 |
1894928 | 1894928 | 2021-11-08 | Clay | Florida | 12019 | 33858 | 698 |
1895011 | 1895011 | 2021-11-08 | Chatham | Georgia | 13051 | 38796 | 698 |
1891761 | 1891761 | 2021-11-07 | Chatham | Georgia | 13051 | 38797 | 698 |
1888511 | 1888511 | 2021-11-06 | Chatham | Georgia | 13051 | 38797 | 698 |
1885261 | 1885261 | 2021-11-05 | Chatham | Georgia | 13051 | 38797 | 698 |
1882012 | 1882012 | 2021-11-04 | Chatham | Georgia | 13051 | 38764 | 698 |
1881056 | 1881056 | 2021-11-03 | Galveston | Texas | 48167 | 64343 | 698 |
1875208 | 1875208 | 2021-11-02 | Yavapai | Arizona | 4025 | 28709 | 698 |
1877807 | 1877807 | 2021-11-02 | Galveston | Texas | 48167 | 64291 | 698 |
1873395 | 1873395 | 2021-11-01 | Jackson | Missouri | 29095 | 56176 | 698 |
1870146 | 1870146 | 2021-10-31 | Jackson | Missouri | 29095 | 56143 | 698 |
1866897 | 1866897 | 2021-10-30 | Jackson | Missouri | 29095 | 56089 | 698 |
1841995 | 1841995 | 2021-10-22 | Bell | Texas | 48027 | 38344 | 698 |
1807426 | 1807426 | 2021-10-12 | Ada | Idaho | 16001 | 75566 | 698 |
1793606 | 1793606 | 2021-10-07 | Henrico | Virginia | 51087 | 33127 | 698 |
1790357 | 1790357 | 2021-10-06 | Henrico | Virginia | 51087 | 33054 | 698 |
1776175 | 1776175 | 2021-10-02 | Gloucester | New Jersey | 34015 | 36550 | 698 |
1770966 | 1770966 | 2021-09-30 | Snohomish | Washington | 53061 | 59051 | 698 |
1717771 | 1717771 | 2021-09-14 | Onondaga | New York | 36067 | 44486 | 698 |
1707356 | 1707356 | 2021-09-11 | Anne Arundel | Maryland | 24003 | 48452 | 698 |
1698847 | 1698847 | 2021-09-08 | Horry | South Carolina | 45051 | 54039 | 698 |
1669741 | 1669741 | 2021-08-30 | Knox | Tennessee | 47093 | 61321 | 698 |
1610478 | 1610478 | 2021-08-12 | Washoe | Nevada | 32031 | 49495 | 698 |
1607230 | 1607230 | 2021-08-11 | Washoe | Nevada | 32031 | 49251 | 698 |
1578001 | 1578001 | 2021-08-02 | Atlantic | New Jersey | 34001 | 32228 | 698 |
1574753 | 1574753 | 2021-08-01 | Atlantic | New Jersey | 34001 | 32204 | 698 |
1571505 | 1571505 | 2021-07-31 | Atlantic | New Jersey | 34001 | 32167 | 698 |
1568257 | 1568257 | 2021-07-30 | Atlantic | New Jersey | 34001 | 32133 | 698 |
1452288 | 1452288 | 2021-06-24 | Fort Bend | Texas | 48157 | 69845 | 698 |
1381267 | 1381267 | 2021-06-02 | Pierce | Washington | 53053 | 55440 | 698 |
1339566 | 1339566 | 2021-05-21 | Escambia | Florida | 12033 | 36454 | 698 |
1336319 | 1336319 | 2021-05-20 | Escambia | Florida | 12033 | 36438 | 698 |
1333072 | 1333072 | 2021-05-19 | Escambia | Florida | 12033 | 36420 | 698 |
1329825 | 1329825 | 2021-05-18 | Escambia | Florida | 12033 | 36406 | 698 |
1292473 | 1292473 | 2021-05-06 | Guilford | North Carolina | 37081 | 46902 | 698 |
1289227 | 1289227 | 2021-05-05 | Guilford | North Carolina | 37081 | 46810 | 698 |
1258306 | 1258306 | 2021-04-26 | Adams | Colorado | 8001 | 56421 | 698 |
1255059 | 1255059 | 2021-04-25 | Adams | Colorado | 8001 | 56140 | 698 |
1253447 | 1253447 | 2021-04-24 | Orange | New York | 36071 | 46749 | 698 |
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);