ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
139 rows where deaths = 789 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- Louisiana 14
- Washington 12
- Alabama 9
- Illinois 9
- Mississippi 8
- Texas 8
- California 7
- Maryland 7
- Oklahoma 7
- Utah 7
- Pennsylvania 6
- Colorado 5
- Florida 5
- Georgia 4
- Minnesota 4
- New Jersey 4
- South Carolina 4
- Arizona 3
- Kansas 3
- Massachusetts 3
- Michigan 3
- New York 2
- Wisconsin 2
- North Carolina 1
- Ohio 1
- Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492908 | 2492908 | 2022-05-10 | Yakima | Washington | 53077 | 73738 | 789 |
2489650 | 2489650 | 2022-05-09 | Yakima | Washington | 53077 | 73738 | 789 |
2486393 | 2486393 | 2022-05-08 | Yakima | Washington | 53077 | 73738 | 789 |
2483135 | 2483135 | 2022-05-07 | Yakima | Washington | 53077 | 73738 | 789 |
2479877 | 2479877 | 2022-05-06 | Yakima | Washington | 53077 | 73738 | 789 |
2476619 | 2476619 | 2022-05-05 | Yakima | Washington | 53077 | 73713 | 789 |
2473361 | 2473361 | 2022-05-04 | Yakima | Washington | 53077 | 73699 | 789 |
2450375 | 2450375 | 2022-04-27 | Utah | Utah | 49049 | 201899 | 789 |
2446090 | 2446090 | 2022-04-26 | Oneida | New York | 36065 | 56094 | 789 |
2447118 | 2447118 | 2022-04-26 | Utah | Utah | 49049 | 201899 | 789 |
2442394 | 2442394 | 2022-04-25 | Hinds | Mississippi | 28049 | 52299 | 789 |
2443863 | 2443863 | 2022-04-25 | Utah | Utah | 49049 | 201899 | 789 |
2439138 | 2439138 | 2022-04-24 | Hinds | Mississippi | 28049 | 52299 | 789 |
2440607 | 2440607 | 2022-04-24 | Utah | Utah | 49049 | 201899 | 789 |
2435882 | 2435882 | 2022-04-23 | Hinds | Mississippi | 28049 | 52299 | 789 |
2437351 | 2437351 | 2022-04-23 | Utah | Utah | 49049 | 201899 | 789 |
2432626 | 2432626 | 2022-04-22 | Hinds | Mississippi | 28049 | 52299 | 789 |
2434095 | 2434095 | 2022-04-22 | Utah | Utah | 49049 | 201899 | 789 |
2429370 | 2429370 | 2022-04-21 | Hinds | Mississippi | 28049 | 52299 | 789 |
2430839 | 2430839 | 2022-04-21 | Utah | Utah | 49049 | 201899 | 789 |
2426114 | 2426114 | 2022-04-20 | Hinds | Mississippi | 28049 | 52299 | 789 |
2422858 | 2422858 | 2022-04-19 | Hinds | Mississippi | 28049 | 52299 | 789 |
2419602 | 2419602 | 2022-04-18 | Hinds | Mississippi | 28049 | 52299 | 789 |
2362645 | 2362645 | 2022-03-31 | Clark | Washington | 53011 | 88033 | 789 |
2359391 | 2359391 | 2022-03-30 | Clark | Washington | 53011 | 88033 | 789 |
2334879 | 2334879 | 2022-03-23 | Anoka | Minnesota | 27003 | 98071 | 789 |
2335718 | 2335718 | 2022-03-23 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2331625 | 2331625 | 2022-03-22 | Anoka | Minnesota | 27003 | 98055 | 789 |
2332464 | 2332464 | 2022-03-22 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2329211 | 2329211 | 2022-03-21 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2325959 | 2325959 | 2022-03-20 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2322706 | 2322706 | 2022-03-19 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2319452 | 2319452 | 2022-03-18 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2316198 | 2316198 | 2022-03-17 | Cleveland | Oklahoma | 40027 | 78865 | 789 |
2284562 | 2284562 | 2022-03-07 | Virginia Beach city | Virginia | 51810 | 88594 | 789 |
2259203 | 2259203 | 2022-02-28 | Hall | Georgia | 13139 | 53324 | 789 |
2255952 | 2255952 | 2022-02-27 | Hall | Georgia | 13139 | 53270 | 789 |
2252701 | 2252701 | 2022-02-26 | Hall | Georgia | 13139 | 53270 | 789 |
2249450 | 2249450 | 2022-02-25 | Hall | Georgia | 13139 | 53270 | 789 |
2222481 | 2222481 | 2022-02-16 | Jefferson | Texas | 48245 | 42830 | 789 |
2178151 | 2178151 | 2022-02-03 | Winnebago | Illinois | 17201 | 73421 | 789 |
2174898 | 2174898 | 2022-02-02 | Winnebago | Illinois | 17201 | 73421 | 789 |
2031163 | 2031163 | 2021-12-20 | Montgomery | Alabama | 1101 | 35009 | 789 |
2027912 | 2027912 | 2021-12-19 | Montgomery | Alabama | 1101 | 34971 | 789 |
2028061 | 2028061 | 2021-12-19 | Imperial | California | 6025 | 40303 | 789 |
2024661 | 2024661 | 2021-12-18 | Montgomery | Alabama | 1101 | 34946 | 789 |
2024810 | 2024810 | 2021-12-18 | Imperial | California | 6025 | 40303 | 789 |
2021410 | 2021410 | 2021-12-17 | Montgomery | Alabama | 1101 | 34910 | 789 |
2021559 | 2021559 | 2021-12-17 | Imperial | California | 6025 | 40303 | 789 |
2018159 | 2018159 | 2021-12-16 | Montgomery | Alabama | 1101 | 34875 | 789 |
2014909 | 2014909 | 2021-12-15 | Montgomery | Alabama | 1101 | 34833 | 789 |
1984809 | 1984809 | 2021-12-05 | Richland | South Carolina | 45079 | 70437 | 789 |
1981559 | 1981559 | 2021-12-04 | Richland | South Carolina | 45079 | 70437 | 789 |
1978309 | 1978309 | 2021-12-03 | Richland | South Carolina | 45079 | 70437 | 789 |
1975059 | 1975059 | 2021-12-02 | Richland | South Carolina | 45079 | 70359 | 789 |
1954303 | 1954303 | 2021-11-26 | Anne Arundel | Maryland | 24003 | 54975 | 789 |
1951052 | 1951052 | 2021-11-25 | Anne Arundel | Maryland | 24003 | 54975 | 789 |
1947801 | 1947801 | 2021-11-24 | Anne Arundel | Maryland | 24003 | 54975 | 789 |
1896475 | 1896475 | 2021-11-08 | Onondaga | New York | 36067 | 54953 | 789 |
1717838 | 1717838 | 2021-09-14 | Guilford | North Carolina | 37081 | 59393 | 789 |
1712489 | 1712489 | 2021-09-12 | Spokane | Washington | 53063 | 60406 | 789 |
1709242 | 1709242 | 2021-09-11 | Spokane | Washington | 53063 | 60406 | 789 |
1705995 | 1705995 | 2021-09-10 | Spokane | Washington | 53063 | 60406 | 789 |
1637011 | 1637011 | 2021-08-20 | Westmoreland | Pennsylvania | 42129 | 35709 | 789 |
1633761 | 1633761 | 2021-08-19 | Westmoreland | Pennsylvania | 42129 | 35638 | 789 |
1622821 | 1622821 | 2021-08-16 | Caddo | Louisiana | 22017 | 32858 | 789 |
1596646 | 1596646 | 2021-08-08 | Johnson | Kansas | 20091 | 64508 | 789 |
1593397 | 1593397 | 2021-08-07 | Johnson | Kansas | 20091 | 64508 | 789 |
1590148 | 1590148 | 2021-08-06 | Johnson | Kansas | 20091 | 64508 | 789 |
1559407 | 1559407 | 2021-07-27 | Denton | Texas | 48121 | 79128 | 789 |
1354991 | 1354991 | 2021-05-25 | Lubbock | Texas | 48303 | 49285 | 789 |
1351745 | 1351745 | 2021-05-24 | Lubbock | Texas | 48303 | 49276 | 789 |
1348499 | 1348499 | 2021-05-23 | Lubbock | Texas | 48303 | 49253 | 789 |
1345251 | 1345251 | 2021-05-22 | Lubbock | Texas | 48303 | 49253 | 789 |
1342003 | 1342003 | 2021-05-21 | Lubbock | Texas | 48303 | 49253 | 789 |
1338755 | 1338755 | 2021-05-20 | Lubbock | Texas | 48303 | 49223 | 789 |
1319995 | 1319995 | 2021-05-15 | Arapahoe | Colorado | 8005 | 61273 | 789 |
1305792 | 1305792 | 2021-05-10 | Chester | Pennsylvania | 42029 | 39910 | 789 |
1302546 | 1302546 | 2021-05-09 | Chester | Pennsylvania | 42029 | 39871 | 789 |
1299299 | 1299299 | 2021-05-08 | Chester | Pennsylvania | 42029 | 39817 | 789 |
1296104 | 1296104 | 2021-05-07 | York | Pennsylvania | 42133 | 44970 | 789 |
1268067 | 1268067 | 2021-04-29 | El Paso | Colorado | 8041 | 63562 | 789 |
1261501 | 1261501 | 2021-04-27 | Contra Costa | California | 6013 | 67746 | 789 |
1262464 | 1262464 | 2021-04-27 | Orleans | Louisiana | 22071 | 29807 | 789 |
1258254 | 1258254 | 2021-04-26 | Contra Costa | California | 6013 | 67670 | 789 |
1259217 | 1259217 | 2021-04-26 | Orleans | Louisiana | 22071 | 29775 | 789 |
1255007 | 1255007 | 2021-04-25 | Contra Costa | California | 6013 | 67587 | 789 |
1255970 | 1255970 | 2021-04-25 | Orleans | Louisiana | 22071 | 29721 | 789 |
1252723 | 1252723 | 2021-04-24 | Orleans | Louisiana | 22071 | 29721 | 789 |
1249476 | 1249476 | 2021-04-23 | Orleans | Louisiana | 22071 | 29721 | 789 |
1246229 | 1246229 | 2021-04-22 | Orleans | Louisiana | 22071 | 29701 | 789 |
1242982 | 1242982 | 2021-04-21 | Orleans | Louisiana | 22071 | 29670 | 789 |
1239716 | 1239716 | 2021-04-20 | East Baton Rouge | Louisiana | 22033 | 38478 | 789 |
1239735 | 1239735 | 2021-04-20 | Orleans | Louisiana | 22071 | 29652 | 789 |
1236488 | 1236488 | 2021-04-19 | Orleans | Louisiana | 22071 | 29633 | 789 |
1233241 | 1233241 | 2021-04-18 | Orleans | Louisiana | 22071 | 29584 | 789 |
1229993 | 1229993 | 2021-04-17 | Orleans | Louisiana | 22071 | 29584 | 789 |
1226745 | 1226745 | 2021-04-16 | Orleans | Louisiana | 22071 | 29584 | 789 |
1194375 | 1194375 | 2021-04-06 | Genesee | Michigan | 26049 | 32130 | 789 |
1190119 | 1190119 | 2021-04-05 | Denver | Colorado | 8031 | 65148 | 789 |
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);