ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
136 rows where deaths = 837 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 29
- Pennsylvania 20
- Texas 17
- Florida 10
- Ohio 8
- Delaware 7
- Oklahoma 7
- South Carolina 7
- Kansas 5
- New Jersey 5
- Arizona 4
- Georgia 4
- Illinois 4
- Indiana 4
- Louisiana 4
- Maryland 4
- Alabama 3
- California 3
- Minnesota 3
- Colorado 2
- Hawaii 2
- New Mexico 2
- New York 2
- Tennessee 2
- Utah 2
- Arkansas 1
- Massachusetts 1
- Michigan 1
- Missouri 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2385924 | 2385924 | 2022-04-08 | Sussex | Delaware | 10005 | 61414 | 837 |
2382669 | 2382669 | 2022-04-07 | Sussex | Delaware | 10005 | 61685 | 837 |
2379414 | 2379414 | 2022-04-06 | Sussex | Delaware | 10005 | 61653 | 837 |
2376160 | 2376160 | 2022-04-05 | Sussex | Delaware | 10005 | 61626 | 837 |
2372908 | 2372908 | 2022-04-04 | Sussex | Delaware | 10005 | 61611 | 837 |
2369449 | 2369449 | 2022-04-03 | Benton | Arkansas | 5007 | 66586 | 837 |
2369655 | 2369655 | 2022-04-03 | Sussex | Delaware | 10005 | 61592 | 837 |
2366402 | 2366402 | 2022-04-02 | Sussex | Delaware | 10005 | 61576 | 837 |
2314733 | 2314733 | 2022-03-17 | Winnebago | Illinois | 17201 | 76104 | 837 |
2315203 | 2315203 | 2022-03-17 | St. Tammany | Louisiana | 22103 | 71901 | 837 |
2311480 | 2311480 | 2022-03-16 | Winnebago | Illinois | 17201 | 76085 | 837 |
2300480 | 2300480 | 2022-03-12 | Galveston | Texas | 48167 | 95093 | 837 |
2280708 | 2280708 | 2022-03-06 | Lexington | South Carolina | 45063 | 95228 | 837 |
2277455 | 2277455 | 2022-03-05 | Lexington | South Carolina | 45063 | 95228 | 837 |
2274202 | 2274202 | 2022-03-04 | Lexington | South Carolina | 45063 | 95228 | 837 |
2270949 | 2270949 | 2022-03-03 | Lexington | South Carolina | 45063 | 95177 | 837 |
2265757 | 2265757 | 2022-03-02 | Richmond | Georgia | 13245 | 49512 | 837 |
2262506 | 2262506 | 2022-03-01 | Richmond | Georgia | 13245 | 49494 | 837 |
2233514 | 2233514 | 2022-02-20 | St. Joseph | Indiana | 18141 | 69965 | 837 |
2230263 | 2230263 | 2022-02-19 | St. Joseph | Indiana | 18141 | 69965 | 837 |
2227012 | 2227012 | 2022-02-18 | St. Joseph | Indiana | 18141 | 69965 | 837 |
2213275 | 2213275 | 2022-02-14 | Madison | Alabama | 1089 | 86794 | 837 |
2210022 | 2210022 | 2022-02-13 | Madison | Alabama | 1089 | 86721 | 837 |
2206769 | 2206769 | 2022-02-12 | Madison | Alabama | 1089 | 86601 | 837 |
2209513 | 2209513 | 2022-02-12 | McLennan | Texas | 48309 | 54785 | 837 |
2199394 | 2199394 | 2022-02-09 | Charleston | South Carolina | 45019 | 108928 | 837 |
2174616 | 2174616 | 2022-02-02 | Clayton | Georgia | 13063 | 61784 | 837 |
2147201 | 2147201 | 2022-01-24 | Dauphin | Pennsylvania | 42043 | 55111 | 837 |
2143947 | 2143947 | 2022-01-23 | Dauphin | Pennsylvania | 42043 | 54925 | 837 |
2135700 | 2135700 | 2022-01-21 | Honolulu | Hawaii | 15003 | 138140 | 837 |
2132448 | 2132448 | 2022-01-20 | Honolulu | Hawaii | 15003 | 135017 | 837 |
2117520 | 2117520 | 2022-01-15 | Rockland | New York | 36087 | 83819 | 837 |
2076200 | 2076200 | 2022-01-02 | Smith | Texas | 48423 | 38011 | 837 |
2072949 | 2072949 | 2022-01-01 | Smith | Texas | 48423 | 38011 | 837 |
2069698 | 2069698 | 2021-12-31 | Smith | Texas | 48423 | 38011 | 837 |
2066447 | 2066447 | 2021-12-30 | Smith | Texas | 48423 | 38011 | 837 |
2063197 | 2063197 | 2021-12-29 | Smith | Texas | 48423 | 37967 | 837 |
2059947 | 2059947 | 2021-12-28 | Smith | Texas | 48423 | 37929 | 837 |
2060332 | 2060332 | 2021-12-28 | Waukesha | Wisconsin | 55133 | 76417 | 837 |
2056698 | 2056698 | 2021-12-27 | Smith | Texas | 48423 | 37878 | 837 |
2034694 | 2034694 | 2021-12-21 | Citrus | Florida | 12017 | 20839 | 837 |
2031444 | 2031444 | 2021-12-20 | Citrus | Florida | 12017 | 20839 | 837 |
2028193 | 2028193 | 2021-12-19 | Citrus | Florida | 12017 | 20839 | 837 |
2024942 | 2024942 | 2021-12-18 | Citrus | Florida | 12017 | 20839 | 837 |
2021691 | 2021691 | 2021-12-17 | Citrus | Florida | 12017 | 20839 | 837 |
2018440 | 2018440 | 2021-12-16 | Citrus | Florida | 12017 | 20793 | 837 |
2015190 | 2015190 | 2021-12-15 | Citrus | Florida | 12017 | 20793 | 837 |
2011939 | 2011939 | 2021-12-14 | Citrus | Florida | 12017 | 20793 | 837 |
2003735 | 2003735 | 2021-12-11 | Onondaga | New York | 36067 | 62935 | 837 |
1876649 | 1876649 | 2021-11-02 | Kansas City | Missouri | 63803 | 837 | |
1760704 | 1760704 | 2021-09-27 | Knox | Tennessee | 47093 | 73860 | 837 |
1694099 | 1694099 | 2021-09-07 | Johnson | Kansas | 20091 | 70526 | 837 |
1690850 | 1690850 | 2021-09-06 | Johnson | Kansas | 20091 | 70526 | 837 |
1687600 | 1687600 | 2021-09-05 | Johnson | Kansas | 20091 | 70526 | 837 |
1684350 | 1684350 | 2021-09-04 | Johnson | Kansas | 20091 | 70526 | 837 |
1681099 | 1681099 | 2021-09-03 | Johnson | Kansas | 20091 | 70526 | 837 |
1675940 | 1675940 | 2021-09-01 | Chester | Pennsylvania | 42029 | 43986 | 837 |
1676437 | 1676437 | 2021-09-01 | Lubbock | Texas | 48303 | 57357 | 837 |
1672693 | 1672693 | 2021-08-31 | Chester | Pennsylvania | 42029 | 43860 | 837 |
1669445 | 1669445 | 2021-08-30 | Chester | Pennsylvania | 42029 | 43708 | 837 |
1666198 | 1666198 | 2021-08-29 | Chester | Pennsylvania | 42029 | 43608 | 837 |
1662950 | 1662950 | 2021-08-28 | Chester | Pennsylvania | 42029 | 43498 | 837 |
1659702 | 1659702 | 2021-08-27 | Chester | Pennsylvania | 42029 | 43389 | 837 |
1654279 | 1654279 | 2021-08-26 | Mohave | Arizona | 4015 | 27900 | 837 |
1627242 | 1627242 | 2021-08-17 | Luzerne | Pennsylvania | 42079 | 33095 | 837 |
1623800 | 1623800 | 2021-08-16 | Lucas | Ohio | 39095 | 44774 | 837 |
1620553 | 1620553 | 2021-08-15 | Lucas | Ohio | 39095 | 44716 | 837 |
1617305 | 1617305 | 2021-08-14 | Lucas | Ohio | 39095 | 44675 | 837 |
1614057 | 1614057 | 2021-08-13 | Lucas | Ohio | 39095 | 44600 | 837 |
1610808 | 1610808 | 2021-08-12 | Lucas | Ohio | 39095 | 44511 | 837 |
1607560 | 1607560 | 2021-08-11 | Lucas | Ohio | 39095 | 44406 | 837 |
1604311 | 1604311 | 2021-08-10 | Lucas | Ohio | 39095 | 44314 | 837 |
1555805 | 1555805 | 2021-07-26 | York | Pennsylvania | 42133 | 47337 | 837 |
1552558 | 1552558 | 2021-07-25 | York | Pennsylvania | 42133 | 47324 | 837 |
1518001 | 1518001 | 2021-07-15 | Arapahoe | Colorado | 8005 | 64723 | 837 |
1470195 | 1470195 | 2021-06-30 | East Baton Rouge | Louisiana | 22033 | 41204 | 837 |
1466950 | 1466950 | 2021-06-29 | East Baton Rouge | Louisiana | 22033 | 41108 | 837 |
1463705 | 1463705 | 2021-06-28 | East Baton Rouge | Louisiana | 22033 | 41063 | 837 |
1430373 | 1430373 | 2021-06-18 | Denver | Colorado | 8031 | 74041 | 837 |
1429666 | 1429666 | 2021-06-17 | Nueces | Texas | 48355 | 39877 | 837 |
1426421 | 1426421 | 2021-06-16 | Nueces | Texas | 48355 | 39860 | 837 |
1423174 | 1423174 | 2021-06-15 | Nueces | Texas | 48355 | 39848 | 837 |
1419928 | 1419928 | 2021-06-14 | Nueces | Texas | 48355 | 39827 | 837 |
1336091 | 1336091 | 2021-05-20 | Yuma | Arizona | 4027 | 37183 | 837 |
1336359 | 1336359 | 2021-05-20 | Sarasota | Florida | 12115 | 33365 | 837 |
1332844 | 1332844 | 2021-05-19 | Yuma | Arizona | 4027 | 37179 | 837 |
1329597 | 1329597 | 2021-05-18 | Yuma | Arizona | 4027 | 37177 | 837 |
1324802 | 1324802 | 2021-05-16 | Somerset | New Jersey | 34035 | 29861 | 837 |
1325856 | 1325856 | 2021-05-16 | Webb | Texas | 48479 | 44047 | 837 |
1321556 | 1321556 | 2021-05-15 | Somerset | New Jersey | 34035 | 29855 | 837 |
1322610 | 1322610 | 2021-05-15 | Webb | Texas | 48479 | 44047 | 837 |
1318310 | 1318310 | 2021-05-14 | Somerset | New Jersey | 34035 | 29831 | 837 |
1319364 | 1319364 | 2021-05-14 | Webb | Texas | 48479 | 44047 | 837 |
1287523 | 1287523 | 2021-05-05 | Tulare | California | 6107 | 49514 | 837 |
1284277 | 1284277 | 2021-05-04 | Tulare | California | 6107 | 49496 | 837 |
1281030 | 1281030 | 2021-05-03 | Tulare | California | 6107 | 49477 | 837 |
1283092 | 1283092 | 2021-05-03 | Lehigh | Pennsylvania | 42077 | 38386 | 837 |
1279845 | 1279845 | 2021-05-02 | Lehigh | Pennsylvania | 42077 | 38341 | 837 |
1243093 | 1243093 | 2021-04-21 | Genesee | Michigan | 26049 | 37620 | 837 |
1222668 | 1222668 | 2021-04-15 | Brevard | Florida | 12009 | 39002 | 837 |
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);