ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
153 rows where deaths = 850 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 25
- Arizona 20
- Pennsylvania 18
- Texas 13
- California 11
- New Jersey 11
- North Carolina 10
- Florida 9
- Colorado 7
- Indiana 7
- Louisiana 7
- Illinois 6
- Michigan 5
- Ohio 5
- Delaware 4
- Maryland 4
- Massachusetts 3
- Missouri 3
- Wisconsin 3
- Alabama 1
- District of Columbia 1
- Idaho 1
- Minnesota 1
- Oregon 1
- Puerto Rico 1
- Washington 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501521 | 2501521 | 2022-05-13 | Gaston | North Carolina | 37071 | 65857 | 850 |
2498263 | 2498263 | 2022-05-12 | Gaston | North Carolina | 37071 | 65857 | 850 |
2495005 | 2495005 | 2022-05-11 | Gaston | North Carolina | 37071 | 65857 | 850 |
2491747 | 2491747 | 2022-05-10 | Gaston | North Carolina | 37071 | 65618 | 850 |
2488489 | 2488489 | 2022-05-09 | Gaston | North Carolina | 37071 | 65618 | 850 |
2485232 | 2485232 | 2022-05-08 | Gaston | North Carolina | 37071 | 65618 | 850 |
2481974 | 2481974 | 2022-05-07 | Gaston | North Carolina | 37071 | 65618 | 850 |
2478716 | 2478716 | 2022-05-06 | Gaston | North Carolina | 37071 | 65618 | 850 |
2473832 | 2473832 | 2022-05-05 | Sussex | Delaware | 10005 | 62429 | 850 |
2475458 | 2475458 | 2022-05-05 | Gaston | North Carolina | 37071 | 65618 | 850 |
2470575 | 2470575 | 2022-05-04 | Sussex | Delaware | 10005 | 62303 | 850 |
2472201 | 2472201 | 2022-05-04 | Gaston | North Carolina | 37071 | 65618 | 850 |
2467319 | 2467319 | 2022-05-03 | Sussex | Delaware | 10005 | 62253 | 850 |
2464064 | 2464064 | 2022-05-02 | Sussex | Delaware | 10005 | 62229 | 850 |
2461191 | 2461191 | 2022-05-01 | Winnebago | Illinois | 17201 | 77462 | 850 |
2461663 | 2461663 | 2022-05-01 | St. Tammany | Louisiana | 22103 | 72468 | 850 |
2457935 | 2457935 | 2022-04-30 | Winnebago | Illinois | 17201 | 77462 | 850 |
2458407 | 2458407 | 2022-04-30 | St. Tammany | Louisiana | 22103 | 72468 | 850 |
2454679 | 2454679 | 2022-04-29 | Winnebago | Illinois | 17201 | 77462 | 850 |
2455151 | 2455151 | 2022-04-29 | St. Tammany | Louisiana | 22103 | 72468 | 850 |
2451895 | 2451895 | 2022-04-28 | St. Tammany | Louisiana | 22103 | 72422 | 850 |
2448639 | 2448639 | 2022-04-27 | St. Tammany | Louisiana | 22103 | 72400 | 850 |
2444540 | 2444540 | 2022-04-26 | Clay | Florida | 12019 | 53548 | 850 |
2445383 | 2445383 | 2022-04-26 | St. Tammany | Louisiana | 22103 | 72352 | 850 |
2441284 | 2441284 | 2022-04-25 | Clay | Florida | 12019 | 53548 | 850 |
2442127 | 2442127 | 2022-04-25 | St. Tammany | Louisiana | 22103 | 72325 | 850 |
2438028 | 2438028 | 2022-04-24 | Clay | Florida | 12019 | 53548 | 850 |
2434772 | 2434772 | 2022-04-23 | Clay | Florida | 12019 | 53548 | 850 |
2431516 | 2431516 | 2022-04-22 | Clay | Florida | 12019 | 53548 | 850 |
2428260 | 2428260 | 2022-04-21 | Clay | Florida | 12019 | 53494 | 850 |
2425004 | 2425004 | 2022-04-20 | Clay | Florida | 12019 | 53494 | 850 |
2427387 | 2427387 | 2022-04-20 | Galveston | Texas | 48167 | 95913 | 850 |
2405360 | 2405360 | 2022-04-14 | San Francisco | California | 6075 | 135079 | 850 |
2284866 | 2284866 | 2022-03-08 | Navajo | Arizona | 4017 | 37678 | 850 |
2281614 | 2281614 | 2022-03-07 | Navajo | Arizona | 4017 | 37678 | 850 |
2282168 | 2282168 | 2022-03-07 | Madison | Illinois | 17119 | 69833 | 850 |
2278361 | 2278361 | 2022-03-06 | Navajo | Arizona | 4017 | 37678 | 850 |
2275108 | 2275108 | 2022-03-05 | Navajo | Arizona | 4017 | 37678 | 850 |
2271855 | 2271855 | 2022-03-04 | Navajo | Arizona | 4017 | 37678 | 850 |
2268603 | 2268603 | 2022-03-03 | Navajo | Arizona | 4017 | 37678 | 850 |
2269277 | 2269277 | 2022-03-03 | St. Joseph | Indiana | 18141 | 70255 | 850 |
2265350 | 2265350 | 2022-03-02 | Navajo | Arizona | 4017 | 37678 | 850 |
2262100 | 2262100 | 2022-03-01 | Navajo | Arizona | 4017 | 37593 | 850 |
2258849 | 2258849 | 2022-02-28 | Navajo | Arizona | 4017 | 37593 | 850 |
2255598 | 2255598 | 2022-02-27 | Navajo | Arizona | 4017 | 37593 | 850 |
2252347 | 2252347 | 2022-02-26 | Navajo | Arizona | 4017 | 37593 | 850 |
2249096 | 2249096 | 2022-02-25 | Navajo | Arizona | 4017 | 37564 | 850 |
2245845 | 2245845 | 2022-02-24 | Navajo | Arizona | 4017 | 37532 | 850 |
2241525 | 2241525 | 2022-02-22 | Cumberland | Pennsylvania | 42041 | 50204 | 850 |
2238274 | 2238274 | 2022-02-21 | Cumberland | Pennsylvania | 42041 | 50155 | 850 |
2235023 | 2235023 | 2022-02-20 | Cumberland | Pennsylvania | 42041 | 50155 | 850 |
2226284 | 2226284 | 2022-02-18 | Montgomery | Alabama | 1101 | 54093 | 850 |
2225770 | 2225770 | 2022-02-17 | McLennan | Texas | 48309 | 55554 | 850 |
2169800 | 2169800 | 2022-01-31 | Lorain | Ohio | 39093 | 64882 | 850 |
2166545 | 2166545 | 2022-01-30 | Lorain | Ohio | 39093 | 64810 | 850 |
2163290 | 2163290 | 2022-01-29 | Lorain | Ohio | 39093 | 64761 | 850 |
2160035 | 2160035 | 2022-01-28 | Lorain | Ohio | 39093 | 64687 | 850 |
2131480 | 2131480 | 2022-01-19 | Smith | Texas | 48423 | 38892 | 850 |
2110922 | 2110922 | 2022-01-13 | Atlantic | New Jersey | 34001 | 59079 | 850 |
2107671 | 2107671 | 2022-01-12 | Atlantic | New Jersey | 34001 | 58327 | 850 |
2109100 | 2109100 | 2022-01-12 | Waukesha | Wisconsin | 55133 | 83186 | 850 |
2105849 | 2105849 | 2022-01-11 | Waukesha | Wisconsin | 55133 | 82574 | 850 |
2102598 | 2102598 | 2022-01-10 | Waukesha | Wisconsin | 55133 | 82253 | 850 |
2089461 | 2089461 | 2022-01-06 | Snohomish | Washington | 53061 | 88481 | 850 |
2015417 | 2015417 | 2021-12-15 | Ada | Idaho | 16001 | 87113 | 850 |
1992212 | 1992212 | 2021-12-08 | Yavapai | Arizona | 4025 | 33924 | 850 |
1987857 | 1987857 | 2021-12-06 | Multnomah | Oregon | 41051 | 61066 | 850 |
1945990 | 1945990 | 2021-11-23 | Brazoria | Texas | 48039 | 60675 | 850 |
1942739 | 1942739 | 2021-11-22 | Brazoria | Texas | 48039 | 60623 | 850 |
1939489 | 1939489 | 2021-11-21 | Brazoria | Texas | 48039 | 60623 | 850 |
1936239 | 1936239 | 2021-11-20 | Brazoria | Texas | 48039 | 60623 | 850 |
1909144 | 1909144 | 2021-11-12 | Kansas City | Missouri | 64767 | 850 | |
1905895 | 1905895 | 2021-11-11 | Kansas City | Missouri | 64530 | 850 | |
1902646 | 1902646 | 2021-11-10 | Kansas City | Missouri | 64530 | 850 | |
1789701 | 1789701 | 2021-10-06 | Westmoreland | Pennsylvania | 42129 | 41693 | 850 |
1774620 | 1774620 | 2021-10-02 | Adams | Colorado | 8001 | 72392 | 850 |
1773405 | 1773405 | 2021-10-01 | Chester | Pennsylvania | 42029 | 47641 | 850 |
1770155 | 1770155 | 2021-09-30 | Chester | Pennsylvania | 42029 | 47513 | 850 |
1766906 | 1766906 | 2021-09-29 | Chester | Pennsylvania | 42029 | 47387 | 850 |
1677156 | 1677156 | 2021-09-02 | Arapahoe | Colorado | 8005 | 70657 | 850 |
1673766 | 1673766 | 2021-09-01 | Mohave | Arizona | 4015 | 28465 | 850 |
1673909 | 1673909 | 2021-09-01 | Arapahoe | Colorado | 8005 | 70151 | 850 |
1670661 | 1670661 | 2021-08-31 | Arapahoe | Colorado | 8005 | 70151 | 850 |
1667414 | 1667414 | 2021-08-30 | Arapahoe | Colorado | 8005 | 69953 | 850 |
1668976 | 1668976 | 2021-08-30 | Somerset | New Jersey | 34035 | 32167 | 850 |
1659233 | 1659233 | 2021-08-27 | Somerset | New Jersey | 34035 | 32064 | 850 |
1655984 | 1655984 | 2021-08-26 | Somerset | New Jersey | 34035 | 31981 | 850 |
1642991 | 1642991 | 2021-08-22 | Somerset | New Jersey | 34035 | 31780 | 850 |
1639741 | 1639741 | 2021-08-21 | Somerset | New Jersey | 34035 | 31739 | 850 |
1543844 | 1543844 | 2021-07-23 | Yuma | Arizona | 4027 | 37426 | 850 |
1540596 | 1540596 | 2021-07-22 | Yuma | Arizona | 4027 | 37410 | 850 |
1511522 | 1511522 | 2021-07-13 | Denver | Colorado | 8031 | 74889 | 850 |
1491201 | 1491201 | 2021-07-06 | Collin | Texas | 48085 | 93283 | 850 |
1487954 | 1487954 | 2021-07-05 | Collin | Texas | 48085 | 93173 | 850 |
1484707 | 1484707 | 2021-07-04 | Collin | Texas | 48085 | 93149 | 850 |
1481461 | 1481461 | 2021-07-03 | Collin | Texas | 48085 | 93113 | 850 |
1466053 | 1466053 | 2021-06-29 | Tulare | California | 6107 | 49823 | 850 |
1462808 | 1462808 | 2021-06-28 | Tulare | California | 6107 | 49823 | 850 |
1459563 | 1459563 | 2021-06-27 | Tulare | California | 6107 | 49823 | 850 |
1456318 | 1456318 | 2021-06-26 | Tulare | California | 6107 | 49823 | 850 |
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);