ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
189 rows where deaths = 648 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 22
- New Hampshire 16
- Tennessee 15
- Pennsylvania 14
- Florida 12
- New York 12
- Michigan 10
- Texas 10
- Alabama 9
- Missouri 9
- Arizona 7
- New Jersey 7
- California 5
- Georgia 5
- Wisconsin 5
- Connecticut 4
- South Carolina 4
- Colorado 3
- Arkansas 2
- Idaho 2
- Louisiana 2
- Massachusetts 2
- Washington 2
- Illinois 1
- Maryland 1
- Mississippi 1
- New Mexico 1
- Ohio 1
- Oklahoma 1
- Oregon 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499806 | 2499806 | 2022-05-13 | Shasta | California | 6089 | 36988 | 648 |
2496548 | 2496548 | 2022-05-12 | Shasta | California | 6089 | 36945 | 648 |
2493290 | 2493290 | 2022-05-11 | Shasta | California | 6089 | 36945 | 648 |
2490032 | 2490032 | 2022-05-10 | Shasta | California | 6089 | 36945 | 648 |
2444235 | 2444235 | 2022-04-26 | Etowah | Alabama | 1055 | 28756 | 648 |
2445514 | 2445514 | 2022-04-26 | Muskegon | Michigan | 26121 | 41913 | 648 |
2440979 | 2440979 | 2022-04-25 | Etowah | Alabama | 1055 | 28756 | 648 |
2442258 | 2442258 | 2022-04-25 | Muskegon | Michigan | 26121 | 41913 | 648 |
2437723 | 2437723 | 2022-04-24 | Etowah | Alabama | 1055 | 28750 | 648 |
2439002 | 2439002 | 2022-04-24 | Muskegon | Michigan | 26121 | 41913 | 648 |
2434467 | 2434467 | 2022-04-23 | Etowah | Alabama | 1055 | 28750 | 648 |
2435746 | 2435746 | 2022-04-23 | Muskegon | Michigan | 26121 | 41913 | 648 |
2431211 | 2431211 | 2022-04-22 | Etowah | Alabama | 1055 | 28750 | 648 |
2432490 | 2432490 | 2022-04-22 | Muskegon | Michigan | 26121 | 41913 | 648 |
2427955 | 2427955 | 2022-04-21 | Etowah | Alabama | 1055 | 28750 | 648 |
2429234 | 2429234 | 2022-04-21 | Muskegon | Michigan | 26121 | 41913 | 648 |
2425978 | 2425978 | 2022-04-20 | Muskegon | Michigan | 26121 | 41913 | 648 |
2415656 | 2415656 | 2022-04-17 | Madison | Indiana | 18095 | 32676 | 648 |
2412400 | 2412400 | 2022-04-16 | Madison | Indiana | 18095 | 32676 | 648 |
2409144 | 2409144 | 2022-04-15 | Madison | Indiana | 18095 | 32676 | 648 |
2405888 | 2405888 | 2022-04-14 | Madison | Indiana | 18095 | 32676 | 648 |
2402633 | 2402633 | 2022-04-13 | Madison | Indiana | 18095 | 32676 | 648 |
2399378 | 2399378 | 2022-04-12 | Madison | Indiana | 18095 | 32665 | 648 |
2396123 | 2396123 | 2022-04-11 | Madison | Indiana | 18095 | 32665 | 648 |
2392867 | 2392867 | 2022-04-10 | Madison | Indiana | 18095 | 32655 | 648 |
2389611 | 2389611 | 2022-04-09 | Madison | Indiana | 18095 | 32655 | 648 |
2386356 | 2386356 | 2022-04-08 | Madison | Indiana | 18095 | 32655 | 648 |
2383101 | 2383101 | 2022-04-07 | Madison | Indiana | 18095 | 32649 | 648 |
2379846 | 2379846 | 2022-04-06 | Madison | Indiana | 18095 | 32649 | 648 |
2376192 | 2376192 | 2022-04-05 | Indian River | Florida | 12061 | 32366 | 648 |
2376592 | 2376592 | 2022-04-05 | Madison | Indiana | 18095 | 32642 | 648 |
2372940 | 2372940 | 2022-04-04 | Indian River | Florida | 12061 | 32366 | 648 |
2373340 | 2373340 | 2022-04-04 | Madison | Indiana | 18095 | 32642 | 648 |
2369687 | 2369687 | 2022-04-03 | Indian River | Florida | 12061 | 32366 | 648 |
2370087 | 2370087 | 2022-04-03 | Madison | Indiana | 18095 | 32633 | 648 |
2366434 | 2366434 | 2022-04-02 | Indian River | Florida | 12061 | 32366 | 648 |
2366834 | 2366834 | 2022-04-02 | Madison | Indiana | 18095 | 32633 | 648 |
2363181 | 2363181 | 2022-04-01 | Indian River | Florida | 12061 | 32366 | 648 |
2363581 | 2363581 | 2022-04-01 | Madison | Indiana | 18095 | 32633 | 648 |
2359927 | 2359927 | 2022-03-31 | Indian River | Florida | 12061 | 32366 | 648 |
2356673 | 2356673 | 2022-03-30 | Indian River | Florida | 12061 | 32366 | 648 |
2358653 | 2358653 | 2022-03-30 | Washington | Pennsylvania | 42125 | 50733 | 648 |
2350130 | 2350130 | 2022-03-28 | New London | Connecticut | 9011 | 54484 | 648 |
2346877 | 2346877 | 2022-03-27 | New London | Connecticut | 9011 | 54414 | 648 |
2343624 | 2343624 | 2022-03-26 | New London | Connecticut | 9011 | 54414 | 648 |
2340371 | 2340371 | 2022-03-25 | New London | Connecticut | 9011 | 54414 | 648 |
2291998 | 2291998 | 2022-03-10 | Hamilton | Indiana | 18057 | 81517 | 648 |
2288746 | 2288746 | 2022-03-09 | Hamilton | Indiana | 18057 | 81498 | 648 |
2268964 | 2268964 | 2022-03-03 | Henry | Georgia | 13151 | 57367 | 648 |
2263855 | 2263855 | 2022-03-01 | Dutchess | New York | 36027 | 63189 | 648 |
2260604 | 2260604 | 2022-02-28 | Dutchess | New York | 36027 | 63182 | 648 |
2261613 | 2261613 | 2022-02-28 | Wichita | Texas | 48485 | 33864 | 648 |
2257353 | 2257353 | 2022-02-27 | Dutchess | New York | 36027 | 63162 | 648 |
2258362 | 2258362 | 2022-02-27 | Wichita | Texas | 48485 | 33864 | 648 |
2254102 | 2254102 | 2022-02-26 | Dutchess | New York | 36027 | 63148 | 648 |
2254860 | 2254860 | 2022-02-26 | Unknown | Tennessee | 25294 | 648 | |
2250851 | 2250851 | 2022-02-25 | Dutchess | New York | 36027 | 63110 | 648 |
2222852 | 2222852 | 2022-02-16 | Kanawha | West Virginia | 54039 | 45729 | 648 |
2217052 | 2217052 | 2022-02-15 | Canyon | Idaho | 16027 | 57581 | 648 |
2215550 | 2215550 | 2022-02-14 | Schuylkill | Pennsylvania | 42107 | 33766 | 648 |
2215924 | 2215924 | 2022-02-14 | Ector | Texas | 48135 | 36687 | 648 |
2212273 | 2212273 | 2022-02-13 | Franklin | Pennsylvania | 42055 | 39599 | 648 |
2209020 | 2209020 | 2022-02-12 | Franklin | Pennsylvania | 42055 | 39563 | 648 |
2180199 | 2180199 | 2022-02-03 | Johnson | Texas | 48251 | 40436 | 648 |
2137418 | 2137418 | 2022-01-21 | Beaver | Pennsylvania | 42007 | 35529 | 648 |
2134164 | 2134164 | 2022-01-20 | Beaver | Pennsylvania | 42007 | 35171 | 648 |
2108168 | 2108168 | 2022-01-12 | Erie | Pennsylvania | 42049 | 47971 | 648 |
2014921 | 2014921 | 2021-12-15 | Tuscaloosa | Alabama | 1125 | 36465 | 648 |
2011670 | 2011670 | 2021-12-14 | Tuscaloosa | Alabama | 1125 | 36442 | 648 |
2013048 | 2013048 | 2021-12-14 | Hinds | Mississippi | 28049 | 33007 | 648 |
2014708 | 2014708 | 2021-12-14 | Yakima | Washington | 53077 | 47436 | 648 |
1995468 | 1995468 | 2021-12-09 | Benton | Arkansas | 5007 | 44567 | 648 |
1977730 | 1977730 | 2021-12-03 | Oneida | New York | 36065 | 33796 | 648 |
1945631 | 1945631 | 2021-11-23 | Cumberland | Pennsylvania | 42041 | 30775 | 648 |
1927494 | 1927494 | 2021-11-18 | Bibb | Georgia | 13021 | 26002 | 648 |
1917449 | 1917449 | 2021-11-15 | Navajo | Arizona | 4017 | 23170 | 648 |
1914199 | 1914199 | 2021-11-14 | Navajo | Arizona | 4017 | 23043 | 648 |
1914872 | 1914872 | 2021-11-14 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1910949 | 1910949 | 2021-11-13 | Navajo | Arizona | 4017 | 22974 | 648 |
1911622 | 1911622 | 2021-11-13 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1908373 | 1908373 | 2021-11-12 | St. Joseph | Indiana | 18141 | 46447 | 648 |
1904842 | 1904842 | 2021-11-11 | Muscogee | Georgia | 13215 | 24339 | 648 |
1901592 | 1901592 | 2021-11-10 | Muscogee | Georgia | 13215 | 24339 | 648 |
1854917 | 1854917 | 2021-10-26 | Hamilton | Tennessee | 47065 | 63843 | 648 |
1790731 | 1790731 | 2021-10-07 | Yavapai | Arizona | 4025 | 26645 | 648 |
1771683 | 1771683 | 2021-10-01 | Ada | Idaho | 16001 | 71882 | 648 |
1770302 | 1770302 | 2021-09-30 | Charleston | South Carolina | 45019 | 62941 | 648 |
1763632 | 1763632 | 2021-09-28 | Multnomah | Oregon | 41051 | 52638 | 648 |
1763798 | 1763798 | 2021-09-28 | Anderson | South Carolina | 45007 | 34362 | 648 |
1746732 | 1746732 | 2021-09-23 | St. Charles | Missouri | 29183 | 58545 | 648 |
1743483 | 1743483 | 2021-09-22 | St. Charles | Missouri | 29183 | 58420 | 648 |
1740234 | 1740234 | 2021-09-21 | St. Charles | Missouri | 29183 | 58263 | 648 |
1736985 | 1736985 | 2021-09-20 | St. Charles | Missouri | 29183 | 58155 | 648 |
1733735 | 1733735 | 2021-09-19 | St. Charles | Missouri | 29183 | 58006 | 648 |
1730485 | 1730485 | 2021-09-18 | St. Charles | Missouri | 29183 | 58006 | 648 |
1727235 | 1727235 | 2021-09-17 | St. Charles | Missouri | 29183 | 57879 | 648 |
1722439 | 1722439 | 2021-09-16 | Montgomery | Alabama | 1101 | 32358 | 648 |
1723986 | 1723986 | 2021-09-16 | St. Charles | Missouri | 29183 | 57709 | 648 |
1698861 | 1698861 | 2021-09-08 | Richland | South Carolina | 45079 | 60471 | 648 |
1695613 | 1695613 | 2021-09-07 | Richland | South Carolina | 45079 | 60327 | 648 |
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);