ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
138 rows where deaths = 848 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Louisiana 16
- Arizona 13
- Colorado 12
- New Jersey 11
- California 9
- Delaware 9
- Ohio 8
- Pennsylvania 8
- Texas 7
- Michigan 5
- Indiana 4
- Massachusetts 4
- Nevada 4
- South Carolina 4
- Wisconsin 4
- Illinois 3
- Maryland 3
- New York 3
- Washington 2
- Alabama 1
- Arkansas 1
- Florida 1
- Georgia 1
- Minnesota 1
- New Hampshire 1
- New Mexico 1
- North Carolina 1
- Utah 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2493173 | 2493173 | 2022-05-11 | Benton | Arkansas | 5007 | 67053 | 848 |
2460808 | 2460808 | 2022-05-01 | Sussex | Delaware | 10005 | 62096 | 848 |
2457552 | 2457552 | 2022-04-30 | Sussex | Delaware | 10005 | 62096 | 848 |
2454296 | 2454296 | 2022-04-29 | Sussex | Delaware | 10005 | 62096 | 848 |
2451040 | 2451040 | 2022-04-28 | Sussex | Delaware | 10005 | 62045 | 848 |
2447784 | 2447784 | 2022-04-27 | Sussex | Delaware | 10005 | 61991 | 848 |
2444528 | 2444528 | 2022-04-26 | Sussex | Delaware | 10005 | 61961 | 848 |
2441272 | 2441272 | 2022-04-25 | Sussex | Delaware | 10005 | 61940 | 848 |
2438016 | 2438016 | 2022-04-24 | Sussex | Delaware | 10005 | 61880 | 848 |
2434760 | 2434760 | 2022-04-23 | Sussex | Delaware | 10005 | 61880 | 848 |
2419335 | 2419335 | 2022-04-18 | St. Tammany | Louisiana | 22103 | 72164 | 848 |
2416079 | 2416079 | 2022-04-17 | St. Tammany | Louisiana | 22103 | 72116 | 848 |
2412823 | 2412823 | 2022-04-16 | St. Tammany | Louisiana | 22103 | 72116 | 848 |
2409567 | 2409567 | 2022-04-15 | St. Tammany | Louisiana | 22103 | 72116 | 848 |
2406311 | 2406311 | 2022-04-14 | St. Tammany | Louisiana | 22103 | 72116 | 848 |
2403055 | 2403055 | 2022-04-13 | St. Tammany | Louisiana | 22103 | 72103 | 848 |
2399801 | 2399801 | 2022-04-12 | St. Tammany | Louisiana | 22103 | 72078 | 848 |
2396545 | 2396545 | 2022-04-11 | St. Tammany | Louisiana | 22103 | 72059 | 848 |
2393290 | 2393290 | 2022-04-10 | St. Tammany | Louisiana | 22103 | 72051 | 848 |
2390034 | 2390034 | 2022-04-09 | St. Tammany | Louisiana | 22103 | 72051 | 848 |
2386778 | 2386778 | 2022-04-08 | St. Tammany | Louisiana | 22103 | 72051 | 848 |
2383523 | 2383523 | 2022-04-07 | St. Tammany | Louisiana | 22103 | 72036 | 848 |
2291776 | 2291776 | 2022-03-10 | Richmond | Georgia | 13245 | 49733 | 848 |
2293716 | 2293716 | 2022-03-10 | Lexington | South Carolina | 45063 | 95377 | 848 |
2246518 | 2246518 | 2022-02-24 | St. Joseph | Indiana | 18141 | 70122 | 848 |
2245361 | 2245361 | 2022-02-23 | Williamson | Texas | 48491 | 130706 | 848 |
2225270 | 2225270 | 2022-02-17 | Cumberland | Pennsylvania | 42041 | 49989 | 848 |
2219776 | 2219776 | 2022-02-16 | Madison | Alabama | 1089 | 87208 | 848 |
2222019 | 2222019 | 2022-02-16 | Cumberland | Pennsylvania | 42041 | 49909 | 848 |
2202361 | 2202361 | 2022-02-10 | Trumbull | Ohio | 39155 | 40828 | 848 |
2199107 | 2199107 | 2022-02-09 | Trumbull | Ohio | 39155 | 40795 | 848 |
2195498 | 2195498 | 2022-02-08 | Hillsborough | New Hampshire | 33011 | 92089 | 848 |
2195853 | 2195853 | 2022-02-08 | Trumbull | Ohio | 39155 | 40762 | 848 |
2149481 | 2149481 | 2022-01-25 | Saginaw | Michigan | 26145 | 45359 | 848 |
2146229 | 2146229 | 2022-01-24 | Saginaw | Michigan | 26145 | 45359 | 848 |
2142974 | 2142974 | 2022-01-23 | Saginaw | Michigan | 26145 | 44393 | 848 |
2139719 | 2139719 | 2022-01-22 | Saginaw | Michigan | 26145 | 44393 | 848 |
2136463 | 2136463 | 2022-01-21 | Saginaw | Michigan | 26145 | 44393 | 848 |
2130530 | 2130530 | 2022-01-19 | Rockland | New York | 36087 | 86822 | 848 |
2128226 | 2128226 | 2022-01-18 | Smith | Texas | 48423 | 38654 | 848 |
2099347 | 2099347 | 2022-01-09 | Waukesha | Wisconsin | 55133 | 79533 | 848 |
2096096 | 2096096 | 2022-01-08 | Waukesha | Wisconsin | 55133 | 79533 | 848 |
2091502 | 2091502 | 2022-01-07 | Orange | New York | 36071 | 85768 | 848 |
2092844 | 2092844 | 2022-01-07 | Waukesha | Wisconsin | 55133 | 79533 | 848 |
1932989 | 1932989 | 2021-11-19 | Brazoria | Texas | 48039 | 60525 | 848 |
1882290 | 1882290 | 2021-11-04 | Unknown | Illinois | 0 | 848 | |
1882303 | 1882303 | 2021-11-04 | Allen | Indiana | 18003 | 59610 | 848 |
1879054 | 1879054 | 2021-11-03 | Allen | Indiana | 18003 | 59444 | 848 |
1779405 | 1779405 | 2021-10-03 | Washoe | Nevada | 32031 | 61875 | 848 |
1776155 | 1776155 | 2021-10-02 | Washoe | Nevada | 32031 | 61875 | 848 |
1771370 | 1771370 | 2021-10-01 | Adams | Colorado | 8001 | 72218 | 848 |
1772905 | 1772905 | 2021-10-01 | Washoe | Nevada | 32031 | 61875 | 848 |
1769656 | 1769656 | 2021-09-30 | Washoe | Nevada | 32031 | 61667 | 848 |
1716167 | 1716167 | 2021-09-14 | Jefferson | Colorado | 8059 | 55675 | 848 |
1698709 | 1698709 | 2021-09-08 | Luzerne | Pennsylvania | 42079 | 34640 | 848 |
1692018 | 1692018 | 2021-09-06 | Lucas | Ohio | 39095 | 47581 | 848 |
1692685 | 1692685 | 2021-09-06 | Lubbock | Texas | 48303 | 58885 | 848 |
1688769 | 1688769 | 2021-09-05 | Lucas | Ohio | 39095 | 47464 | 848 |
1689436 | 1689436 | 2021-09-05 | Lubbock | Texas | 48303 | 58105 | 848 |
1685519 | 1685519 | 2021-09-04 | Lucas | Ohio | 39095 | 47256 | 848 |
1682268 | 1682268 | 2021-09-03 | Lucas | Ohio | 39095 | 47070 | 848 |
1669497 | 1669497 | 2021-08-30 | York | Pennsylvania | 42133 | 50210 | 848 |
1666250 | 1666250 | 2021-08-29 | York | Pennsylvania | 42133 | 50118 | 848 |
1663002 | 1663002 | 2021-08-28 | York | Pennsylvania | 42133 | 49972 | 848 |
1659754 | 1659754 | 2021-08-27 | York | Pennsylvania | 42133 | 49830 | 848 |
1649489 | 1649489 | 2021-08-24 | Somerset | New Jersey | 34035 | 31862 | 848 |
1643640 | 1643640 | 2021-08-22 | Spartanburg | South Carolina | 45083 | 46322 | 848 |
1640390 | 1640390 | 2021-08-21 | Spartanburg | South Carolina | 45083 | 46322 | 848 |
1634929 | 1634929 | 2021-08-20 | Arapahoe | Colorado | 8005 | 68219 | 848 |
1637140 | 1637140 | 2021-08-20 | Spartanburg | South Carolina | 45083 | 46322 | 848 |
1628379 | 1628379 | 2021-08-18 | Contra Costa | California | 6013 | 84067 | 848 |
1625132 | 1625132 | 2021-08-17 | Contra Costa | California | 6013 | 83655 | 848 |
1626747 | 1626747 | 2021-08-17 | Somerset | New Jersey | 34035 | 31491 | 848 |
1621885 | 1621885 | 2021-08-16 | Contra Costa | California | 6013 | 83366 | 848 |
1623500 | 1623500 | 2021-08-16 | Somerset | New Jersey | 34035 | 31428 | 848 |
1618638 | 1618638 | 2021-08-15 | Contra Costa | California | 6013 | 83043 | 848 |
1620253 | 1620253 | 2021-08-15 | Somerset | New Jersey | 34035 | 31408 | 848 |
1615390 | 1615390 | 2021-08-14 | Contra Costa | California | 6013 | 82631 | 848 |
1617005 | 1617005 | 2021-08-14 | Somerset | New Jersey | 34035 | 31360 | 848 |
1613757 | 1613757 | 2021-08-13 | Somerset | New Jersey | 34035 | 31289 | 848 |
1610508 | 1610508 | 2021-08-12 | Somerset | New Jersey | 34035 | 31221 | 848 |
1540747 | 1540747 | 2021-07-22 | Denver | Colorado | 8031 | 75356 | 848 |
1537500 | 1537500 | 2021-07-21 | Denver | Colorado | 8031 | 75274 | 848 |
1534252 | 1534252 | 2021-07-20 | Denver | Colorado | 8031 | 75170 | 848 |
1531005 | 1531005 | 2021-07-19 | Denver | Colorado | 8031 | 75170 | 848 |
1527758 | 1527758 | 2021-07-18 | Denver | Colorado | 8031 | 75016 | 848 |
1524511 | 1524511 | 2021-07-17 | Denver | Colorado | 8031 | 75016 | 848 |
1521263 | 1521263 | 2021-07-16 | Denver | Colorado | 8031 | 75016 | 848 |
1518015 | 1518015 | 2021-07-15 | Denver | Colorado | 8031 | 74963 | 848 |
1518891 | 1518891 | 2021-07-15 | East Baton Rouge | Louisiana | 22033 | 42450 | 848 |
1515644 | 1515644 | 2021-07-14 | East Baton Rouge | Louisiana | 22033 | 42310 | 848 |
1512398 | 1512398 | 2021-07-13 | East Baton Rouge | Louisiana | 22033 | 42091 | 848 |
1508275 | 1508275 | 2021-07-12 | Denver | Colorado | 8031 | 74823 | 848 |
1485398 | 1485398 | 2021-07-05 | Yuma | Arizona | 4027 | 37347 | 848 |
1482152 | 1482152 | 2021-07-04 | Yuma | Arizona | 4027 | 37346 | 848 |
1478905 | 1478905 | 2021-07-03 | Yuma | Arizona | 4027 | 37345 | 848 |
1475659 | 1475659 | 2021-07-02 | Yuma | Arizona | 4027 | 37334 | 848 |
1478214 | 1478214 | 2021-07-02 | Collin | Texas | 48085 | 93062 | 848 |
1472413 | 1472413 | 2021-07-01 | Yuma | Arizona | 4027 | 37326 | 848 |
1469168 | 1469168 | 2021-06-30 | Yuma | Arizona | 4027 | 37319 | 848 |
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);