ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
344 rows where cases = 1495 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 21
- South Dakota 20
- Texas 20
- Idaho 16
- Minnesota 16
- Alabama 15
- Illinois 15
- Virginia 14
- Indiana 12
- Kentucky 12
- North Carolina 11
- Oklahoma 11
- Florida 10
- Kansas 10
- Mississippi 9
- West Virginia 9
- Iowa 8
- Missouri 8
- New York 8
- Pennsylvania 7
- Puerto Rico 7
- Tennessee 7
- Washington 7
- Arkansas 6
- California 6
- Louisiana 6
- Michigan 6
- Colorado 5
- Nebraska 5
- Oregon 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500147 | 2500147 | 2022-05-13 | Caribou | Idaho | 16029 | 1495 | 28 |
2496889 | 2496889 | 2022-05-12 | Caribou | Idaho | 16029 | 1495 | 28 |
2496913 | 2496913 | 2022-05-12 | Power | Idaho | 16077 | 1495 | 20 |
2493631 | 2493631 | 2022-05-11 | Caribou | Idaho | 16029 | 1495 | 28 |
2493655 | 2493655 | 2022-05-11 | Power | Idaho | 16077 | 1495 | 20 |
2490373 | 2490373 | 2022-05-10 | Caribou | Idaho | 16029 | 1495 | 28 |
2490397 | 2490397 | 2022-05-10 | Power | Idaho | 16077 | 1495 | 20 |
2487116 | 2487116 | 2022-05-09 | Caribou | Idaho | 16029 | 1495 | 28 |
2487140 | 2487140 | 2022-05-09 | Power | Idaho | 16077 | 1495 | 20 |
2483882 | 2483882 | 2022-05-08 | Power | Idaho | 16077 | 1495 | 20 |
2484641 | 2484641 | 2022-05-08 | Grant | Minnesota | 27051 | 1495 | 12 |
2480624 | 2480624 | 2022-05-07 | Power | Idaho | 16077 | 1495 | 20 |
2481383 | 2481383 | 2022-05-07 | Grant | Minnesota | 27051 | 1495 | 12 |
2477366 | 2477366 | 2022-05-06 | Power | Idaho | 16077 | 1495 | 20 |
2478125 | 2478125 | 2022-05-06 | Grant | Minnesota | 27051 | 1495 | 12 |
2474108 | 2474108 | 2022-05-05 | Power | Idaho | 16077 | 1495 | 20 |
2470851 | 2470851 | 2022-05-04 | Power | Idaho | 16077 | 1495 | 20 |
2467595 | 2467595 | 2022-05-03 | Power | Idaho | 16077 | 1495 | 20 |
2464340 | 2464340 | 2022-05-02 | Power | Idaho | 16077 | 1495 | 20 |
2453732 | 2453732 | 2022-04-28 | Mathews | Virginia | 51115 | 1495 | 27 |
2426055 | 2426055 | 2022-04-20 | Norman | Minnesota | 27107 | 1495 | 13 |
2327139 | 2327139 | 2022-03-21 | Unknown | American Samoa | 1495 | 0 | |
2328559 | 2328559 | 2022-03-21 | Carter | Missouri | 29035 | 1495 | 23 |
2293758 | 2293758 | 2022-03-10 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2290506 | 2290506 | 2022-03-09 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2287254 | 2287254 | 2022-03-08 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2284002 | 2284002 | 2022-03-07 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2280750 | 2280750 | 2022-03-06 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2277497 | 2277497 | 2022-03-05 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2274244 | 2274244 | 2022-03-04 | Hamlin | South Dakota | 46057 | 1495 | 41 |
2269459 | 2269459 | 2022-03-03 | Morris | Kansas | 20127 | 1495 | 26 |
2266206 | 2266206 | 2022-03-02 | Morris | Kansas | 20127 | 1495 | 26 |
2262982 | 2262982 | 2022-03-01 | Sherman | Kansas | 20181 | 1495 | 19 |
2259731 | 2259731 | 2022-02-28 | Sherman | Kansas | 20181 | 1495 | 19 |
2243178 | 2243178 | 2022-02-23 | Stark | Illinois | 17175 | 1495 | 32 |
2237083 | 2237083 | 2022-02-21 | Owsley | Kentucky | 21189 | 1495 | 23 |
2175670 | 2175670 | 2022-02-02 | Quitman | Mississippi | 28119 | 1495 | 29 |
2176846 | 2176846 | 2022-02-02 | Brooks | Texas | 48047 | 1495 | 49 |
2151673 | 2151673 | 2022-01-26 | Conejos | Colorado | 8021 | 1495 | 49 |
2149889 | 2149889 | 2022-01-25 | Knox | Nebraska | 31107 | 1495 | 13 |
2079917 | 2079917 | 2022-01-04 | Perry | Alabama | 1105 | 1495 | 41 |
2061522 | 2061522 | 2021-12-29 | Red River | Louisiana | 22081 | 1495 | 49 |
2057234 | 2057234 | 2021-12-28 | Cleveland | Arkansas | 5025 | 1495 | 33 |
2038247 | 2038247 | 2021-12-22 | Hamilton | Illinois | 17065 | 1495 | 27 |
2040760 | 2040760 | 2021-12-22 | Tyler | West Virginia | 54095 | 1495 | 25 |
2034263 | 2034263 | 2021-12-20 | Webster | West Virginia | 54101 | 1495 | 26 |
2017967 | 2017967 | 2021-12-15 | Doddridge | West Virginia | 54017 | 1495 | 12 |
2008833 | 2008833 | 2021-12-13 | Lanier | Georgia | 13173 | 1495 | 17 |
2009931 | 2009931 | 2021-12-13 | Oregon | Missouri | 29149 | 1495 | 26 |
1994515 | 1994515 | 2021-12-08 | Yauco | Puerto Rico | 72153 | 1495 | |
1990563 | 1990563 | 2021-12-07 | Hamilton | Nebraska | 31081 | 1495 | 19 |
1991863 | 1991863 | 2021-12-07 | Nelson | Virginia | 51125 | 1495 | 21 |
1986384 | 1986384 | 2021-12-06 | Switzerland | Indiana | 18155 | 1495 | 12 |
1988846 | 1988846 | 2021-12-06 | Sublette | Wyoming | 56035 | 1495 | 23 |
1978696 | 1978696 | 2021-12-03 | Swisher | Texas | 48437 | 1495 | 22 |
1978988 | 1978988 | 2021-12-03 | Pleasants | West Virginia | 54073 | 1495 | 31 |
1972435 | 1972435 | 2021-12-01 | Lincoln | Washington | 53043 | 1495 | 25 |
1967489 | 1967489 | 2021-11-30 | Pipestone | Minnesota | 27117 | 1495 | 29 |
1969185 | 1969185 | 2021-11-30 | Lincoln | Washington | 53043 | 1495 | 25 |
1941472 | 1941472 | 2021-11-22 | Murray | Minnesota | 27101 | 1495 | 11 |
1942938 | 1942938 | 2021-11-22 | Swisher | Texas | 48437 | 1495 | 22 |
1939688 | 1939688 | 2021-11-21 | Swisher | Texas | 48437 | 1495 | 22 |
1936438 | 1936438 | 2021-11-20 | Swisher | Texas | 48437 | 1495 | 22 |
1928712 | 1928712 | 2021-11-18 | Carbon | Montana | 30009 | 1495 | 21 |
1929937 | 1929937 | 2021-11-18 | Swisher | Texas | 48437 | 1495 | 22 |
1926687 | 1926687 | 2021-11-17 | Swisher | Texas | 48437 | 1495 | 22 |
1914302 | 1914302 | 2021-11-14 | Mariposa | California | 6043 | 1495 | 17 |
1911052 | 1911052 | 2021-11-13 | Mariposa | California | 6043 | 1495 | 17 |
1907803 | 1907803 | 2021-11-12 | Mariposa | California | 6043 | 1495 | 17 |
1905874 | 1905874 | 2021-11-11 | DeKalb | Missouri | 29063 | 1495 | 34 |
1902459 | 1902459 | 2021-11-10 | Koochiching | Minnesota | 27071 | 1495 | 21 |
1902625 | 1902625 | 2021-11-10 | DeKalb | Missouri | 29063 | 1495 | 34 |
1882551 | 1882551 | 2021-11-04 | Marshall | Kansas | 20117 | 1495 | 31 |
1884434 | 1884434 | 2021-11-04 | Somervell | Texas | 48425 | 1495 | 21 |
1879302 | 1879302 | 2021-11-03 | Marshall | Kansas | 20117 | 1495 | 31 |
1832584 | 1832584 | 2021-10-19 | Galax city | Virginia | 51640 | 1495 | 62 |
1810280 | 1810280 | 2021-10-13 | Perry | Arkansas | 5105 | 1495 | 21 |
1812780 | 1812780 | 2021-10-13 | Clay | Texas | 48077 | 1495 | 23 |
1804123 | 1804123 | 2021-10-11 | Pulaski | Georgia | 13235 | 1495 | 56 |
1800874 | 1800874 | 2021-10-10 | Pulaski | Georgia | 13235 | 1495 | 56 |
1797625 | 1797625 | 2021-10-09 | Pulaski | Georgia | 13235 | 1495 | 56 |
1794376 | 1794376 | 2021-10-08 | Pulaski | Georgia | 13235 | 1495 | 56 |
1791115 | 1791115 | 2021-10-07 | Montgomery | Georgia | 13209 | 1495 | 37 |
1791128 | 1791128 | 2021-10-07 | Pulaski | Georgia | 13235 | 1495 | 56 |
1791575 | 1791575 | 2021-10-07 | Marion | Kansas | 20115 | 1495 | 27 |
1793138 | 1793138 | 2021-10-07 | Roberts | South Dakota | 46109 | 1495 | 43 |
1788326 | 1788326 | 2021-10-06 | Marion | Kansas | 20115 | 1495 | 27 |
1789889 | 1789889 | 2021-10-06 | Roberts | South Dakota | 46109 | 1495 | 43 |
1785867 | 1785867 | 2021-10-05 | Red Willow | Nebraska | 31145 | 1495 | 15 |
1783019 | 1783019 | 2021-10-04 | Vinton | Ohio | 39163 | 1495 | 20 |
1783786 | 1783786 | 2021-10-04 | Caledonia | Vermont | 50005 | 1495 | 11 |
1778173 | 1778173 | 2021-10-03 | Wilkes | Georgia | 13317 | 1495 | 34 |
1774923 | 1774923 | 2021-10-02 | Wilkes | Georgia | 13317 | 1495 | 34 |
1771673 | 1771673 | 2021-10-01 | Wilkes | Georgia | 13317 | 1495 | 34 |
1769164 | 1769164 | 2021-09-30 | Leelanau | Michigan | 26089 | 1495 | 22 |
1765915 | 1765915 | 2021-09-29 | Leelanau | Michigan | 26089 | 1495 | 22 |
1758135 | 1758135 | 2021-09-27 | Bullock | Alabama | 1011 | 1495 | 43 |
1757382 | 1757382 | 2021-09-26 | Lake | South Dakota | 46079 | 1495 | 20 |
1754134 | 1754134 | 2021-09-25 | Lake | South Dakota | 46079 | 1495 | 20 |
1750886 | 1750886 | 2021-09-24 | Lake | South Dakota | 46079 | 1495 | 20 |
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);