ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
135 rows where deaths = 799 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 26
- California 22
- Louisiana 10
- South Carolina 9
- Pennsylvania 8
- Iowa 7
- North Carolina 7
- Washington 7
- Alabama 6
- Arizona 5
- Delaware 5
- Florida 5
- Georgia 5
- Ohio 5
- Texas 5
- Indiana 4
- Massachusetts 4
- Nevada 4
- New York 4
- Illinois 3
- Colorado 2
- Hawaii 2
- Michigan 2
- New Jersey 1
- New Mexico 1
- Utah 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2486359 | 2486359 | 2022-05-08 | Clark | Washington | 53011 | 90331 | 799 |
2483101 | 2483101 | 2022-05-07 | Clark | Washington | 53011 | 90331 | 799 |
2479843 | 2479843 | 2022-05-06 | Clark | Washington | 53011 | 90331 | 799 |
2476585 | 2476585 | 2022-05-05 | Clark | Washington | 53011 | 90331 | 799 |
2470551 | 2470551 | 2022-05-04 | Pueblo | Colorado | 8101 | 47087 | 799 |
2473327 | 2473327 | 2022-05-04 | Clark | Washington | 53011 | 90331 | 799 |
2467295 | 2467295 | 2022-05-03 | Pueblo | Colorado | 8101 | 47072 | 799 |
2423362 | 2423362 | 2022-04-19 | Gaston | North Carolina | 37071 | 65195 | 799 |
2420105 | 2420105 | 2022-04-18 | Gaston | North Carolina | 37071 | 65195 | 799 |
2416850 | 2416850 | 2022-04-17 | Gaston | North Carolina | 37071 | 65195 | 799 |
2413594 | 2413594 | 2022-04-16 | Gaston | North Carolina | 37071 | 65195 | 799 |
2410338 | 2410338 | 2022-04-15 | Gaston | North Carolina | 37071 | 65195 | 799 |
2407082 | 2407082 | 2022-04-14 | Gaston | North Carolina | 37071 | 65195 | 799 |
2403826 | 2403826 | 2022-04-13 | Gaston | North Carolina | 37071 | 65195 | 799 |
2268958 | 2268958 | 2022-03-03 | Hall | Georgia | 13139 | 53341 | 799 |
2248489 | 2248489 | 2022-02-24 | Jefferson | Texas | 48245 | 43553 | 799 |
2233151 | 2233151 | 2022-02-20 | Chatham | Georgia | 13051 | 61104 | 799 |
2229900 | 2229900 | 2022-02-19 | Chatham | Georgia | 13051 | 61104 | 799 |
2226649 | 2226649 | 2022-02-18 | Chatham | Georgia | 13051 | 61104 | 799 |
2218931 | 2218931 | 2022-02-15 | Lexington | South Carolina | 45063 | 93977 | 799 |
2160213 | 2160213 | 2022-01-28 | Cumberland | Pennsylvania | 42041 | 47749 | 799 |
2157457 | 2157457 | 2022-01-27 | McLennan | Texas | 48309 | 52416 | 799 |
2096324 | 2096324 | 2022-01-09 | Imperial | California | 6025 | 44100 | 799 |
2093072 | 2093072 | 2022-01-08 | Imperial | California | 6025 | 44100 | 799 |
2089820 | 2089820 | 2022-01-07 | Imperial | California | 6025 | 44100 | 799 |
2086569 | 2086569 | 2022-01-06 | Imperial | California | 6025 | 43460 | 799 |
2083167 | 2083167 | 2022-01-05 | Montgomery | Alabama | 1101 | 40450 | 799 |
2083317 | 2083317 | 2022-01-05 | Imperial | California | 6025 | 43000 | 799 |
2080065 | 2080065 | 2022-01-04 | Imperial | California | 6025 | 42815 | 799 |
2080287 | 2080287 | 2022-01-04 | Clayton | Georgia | 13063 | 48843 | 799 |
2076813 | 2076813 | 2022-01-03 | Imperial | California | 6025 | 42076 | 799 |
2073562 | 2073562 | 2022-01-02 | Imperial | California | 6025 | 42076 | 799 |
2070311 | 2070311 | 2022-01-01 | Imperial | California | 6025 | 42076 | 799 |
2067060 | 2067060 | 2021-12-31 | Imperial | California | 6025 | 42076 | 799 |
2063809 | 2063809 | 2021-12-30 | Imperial | California | 6025 | 41864 | 799 |
2064163 | 2064163 | 2021-12-30 | Honolulu | Hawaii | 15003 | 77570 | 799 |
2060559 | 2060559 | 2021-12-29 | Imperial | California | 6025 | 41444 | 799 |
2060913 | 2060913 | 2021-12-29 | Honolulu | Hawaii | 15003 | 74890 | 799 |
2057310 | 2057310 | 2021-12-28 | Imperial | California | 6025 | 41401 | 799 |
2058998 | 2058998 | 2021-12-28 | Rockland | New York | 36087 | 62396 | 799 |
2054061 | 2054061 | 2021-12-27 | Imperial | California | 6025 | 41099 | 799 |
2055749 | 2055749 | 2021-12-27 | Rockland | New York | 36087 | 61717 | 799 |
2050811 | 2050811 | 2021-12-26 | Imperial | California | 6025 | 41099 | 799 |
2047561 | 2047561 | 2021-12-25 | Imperial | California | 6025 | 41099 | 799 |
2044311 | 2044311 | 2021-12-24 | Imperial | California | 6025 | 41099 | 799 |
2036820 | 2036820 | 2021-12-21 | Richland | South Carolina | 45079 | 71662 | 799 |
2033570 | 2033570 | 2021-12-20 | Richland | South Carolina | 45079 | 71579 | 799 |
2030320 | 2030320 | 2021-12-19 | Richland | South Carolina | 45079 | 71257 | 799 |
2027069 | 2027069 | 2021-12-18 | Richland | South Carolina | 45079 | 71257 | 799 |
2023818 | 2023818 | 2021-12-17 | Richland | South Carolina | 45079 | 71257 | 799 |
2020567 | 2020567 | 2021-12-16 | Richland | South Carolina | 45079 | 71171 | 799 |
2017316 | 2017316 | 2021-12-15 | Richland | South Carolina | 45079 | 71089 | 799 |
2014831 | 2014831 | 2021-12-14 | Waukesha | Wisconsin | 55133 | 73261 | 799 |
2010470 | 2010470 | 2021-12-13 | Mahoning | Ohio | 39099 | 37199 | 799 |
2007219 | 2007219 | 2021-12-12 | Mahoning | Ohio | 39099 | 37109 | 799 |
2003968 | 2003968 | 2021-12-11 | Mahoning | Ohio | 39099 | 37002 | 799 |
2000717 | 2000717 | 2021-12-10 | Mahoning | Ohio | 39099 | 36833 | 799 |
1994525 | 1994525 | 2021-12-08 | Anderson | South Carolina | 45007 | 38057 | 799 |
1974483 | 1974483 | 2021-12-02 | Orange | New York | 36071 | 62692 | 799 |
1966976 | 1966976 | 2021-11-30 | Polk | Iowa | 19153 | 80541 | 799 |
1963724 | 1963724 | 2021-11-29 | Polk | Iowa | 19153 | 80541 | 799 |
1960473 | 1960473 | 2021-11-28 | Polk | Iowa | 19153 | 80541 | 799 |
1957222 | 1957222 | 2021-11-27 | Polk | Iowa | 19153 | 80541 | 799 |
1953971 | 1953971 | 2021-11-26 | Polk | Iowa | 19153 | 80541 | 799 |
1950720 | 1950720 | 2021-11-25 | Polk | Iowa | 19153 | 80541 | 799 |
1947469 | 1947469 | 2021-11-24 | Polk | Iowa | 19153 | 80541 | 799 |
1928972 | 1928972 | 2021-11-18 | Onondaga | New York | 36067 | 56962 | 799 |
1849800 | 1849800 | 2021-10-25 | Unknown | Illinois | 0 | 799 | |
1781581 | 1781581 | 2021-10-04 | Allen | Indiana | 18003 | 55473 | 799 |
1733918 | 1733918 | 2021-09-19 | Washoe | Nevada | 32031 | 59005 | 799 |
1730668 | 1730668 | 2021-09-18 | Washoe | Nevada | 32031 | 59005 | 799 |
1727418 | 1727418 | 2021-09-17 | Washoe | Nevada | 32031 | 59005 | 799 |
1715735 | 1715735 | 2021-09-13 | Spokane | Washington | 53063 | 61368 | 799 |
1611385 | 1611385 | 2021-08-12 | Denton | Texas | 48121 | 83129 | 799 |
1462954 | 1462954 | 2021-06-28 | Unknown | Florida | 55 | 799 | |
1459709 | 1459709 | 2021-06-27 | Unknown | Florida | 55 | 799 | |
1456464 | 1456464 | 2021-06-26 | Unknown | Florida | 55 | 799 | |
1453219 | 1453219 | 2021-06-25 | Unknown | Florida | 55 | 799 | |
1421530 | 1421530 | 2021-06-15 | Orleans | Louisiana | 22071 | 30876 | 799 |
1418285 | 1418285 | 2021-06-14 | Orleans | Louisiana | 22071 | 30861 | 799 |
1415039 | 1415039 | 2021-06-13 | Orleans | Louisiana | 22071 | 30830 | 799 |
1411794 | 1411794 | 2021-06-12 | Orleans | Louisiana | 22071 | 30830 | 799 |
1408549 | 1408549 | 2021-06-11 | Orleans | Louisiana | 22071 | 30830 | 799 |
1287476 | 1287476 | 2021-05-05 | Contra Costa | California | 6013 | 68279 | 799 |
1288565 | 1288565 | 2021-05-05 | Kent | Michigan | 26081 | 69371 | 799 |
1284230 | 1284230 | 2021-05-04 | Contra Costa | California | 6013 | 68212 | 799 |
1285319 | 1285319 | 2021-05-04 | Kent | Michigan | 26081 | 69158 | 799 |
1278680 | 1278680 | 2021-05-02 | East Baton Rouge | Louisiana | 22033 | 39099 | 799 |
1275433 | 1275433 | 2021-05-01 | East Baton Rouge | Louisiana | 22033 | 39099 | 799 |
1272186 | 1272186 | 2021-04-30 | East Baton Rouge | Louisiana | 22033 | 39099 | 799 |
1268939 | 1268939 | 2021-04-29 | East Baton Rouge | Louisiana | 22033 | 38970 | 799 |
1242145 | 1242145 | 2021-04-21 | New Castle | Delaware | 10003 | 60187 | 799 |
1238898 | 1238898 | 2021-04-20 | New Castle | Delaware | 10003 | 59996 | 799 |
1235381 | 1235381 | 2021-04-19 | Mobile | Alabama | 1097 | 39129 | 799 |
1235651 | 1235651 | 2021-04-19 | New Castle | Delaware | 10003 | 59884 | 799 |
1232133 | 1232133 | 2021-04-18 | Mobile | Alabama | 1097 | 39126 | 799 |
1232404 | 1232404 | 2021-04-18 | New Castle | Delaware | 10003 | 59610 | 799 |
1228885 | 1228885 | 2021-04-17 | Mobile | Alabama | 1097 | 39111 | 799 |
1229155 | 1229155 | 2021-04-17 | New Castle | Delaware | 10003 | 59355 | 799 |
1225637 | 1225637 | 2021-04-16 | Mobile | Alabama | 1097 | 39067 | 799 |
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);