ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
671 rows where cases = 523 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 97
- Texas 54
- Georgia 38
- Kansas 34
- Virginia 26
- Kentucky 24
- Montana 24
- Illinois 23
- South Dakota 23
- Alabama 19
- Mississippi 19
- Puerto Rico 17
- Idaho 16
- Missouri 16
- West Virginia 16
- Alaska 15
- Colorado 14
- North Dakota 13
- Oklahoma 13
- Tennessee 13
- Michigan 12
- Minnesota 12
- Oregon 12
- Indiana 11
- North Carolina 11
- Iowa 10
- South Carolina 9
- Arkansas 8
- Florida 8
- New York 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500862 | 2500862 | 2022-05-13 | Keweenaw | Michigan | 26083 | 523 | 14 |
2497604 | 2497604 | 2022-05-12 | Keweenaw | Michigan | 26083 | 523 | 14 |
2494346 | 2494346 | 2022-05-11 | Keweenaw | Michigan | 26083 | 523 | 14 |
2491483 | 2491483 | 2022-05-10 | Brown | Nebraska | 31017 | 523 | 4 |
2488225 | 2488225 | 2022-05-09 | Brown | Nebraska | 31017 | 523 | 4 |
2484968 | 2484968 | 2022-05-08 | Brown | Nebraska | 31017 | 523 | 4 |
2481710 | 2481710 | 2022-05-07 | Brown | Nebraska | 31017 | 523 | 4 |
2478452 | 2478452 | 2022-05-06 | Brown | Nebraska | 31017 | 523 | 4 |
2475194 | 2475194 | 2022-05-05 | Brown | Nebraska | 31017 | 523 | 4 |
2471937 | 2471937 | 2022-05-04 | Brown | Nebraska | 31017 | 523 | 4 |
2468681 | 2468681 | 2022-05-03 | Brown | Nebraska | 31017 | 523 | 4 |
2465425 | 2465425 | 2022-05-02 | Brown | Nebraska | 31017 | 523 | 4 |
2462170 | 2462170 | 2022-05-01 | Brown | Nebraska | 31017 | 523 | 4 |
2458914 | 2458914 | 2022-04-30 | Brown | Nebraska | 31017 | 523 | 4 |
2455658 | 2455658 | 2022-04-29 | Brown | Nebraska | 31017 | 523 | 4 |
2452402 | 2452402 | 2022-04-28 | Brown | Nebraska | 31017 | 523 | 4 |
2449146 | 2449146 | 2022-04-27 | Brown | Nebraska | 31017 | 523 | 4 |
2445889 | 2445889 | 2022-04-26 | Brown | Nebraska | 31017 | 523 | 4 |
2378676 | 2378676 | 2022-04-05 | Schleicher | Texas | 48413 | 523 | 9 |
2375422 | 2375422 | 2022-04-04 | Schleicher | Texas | 48413 | 523 | 9 |
2372170 | 2372170 | 2022-04-03 | Schleicher | Texas | 48413 | 523 | 9 |
2368917 | 2368917 | 2022-04-02 | Schleicher | Texas | 48413 | 523 | 9 |
2365664 | 2365664 | 2022-04-01 | Schleicher | Texas | 48413 | 523 | 9 |
2362210 | 2362210 | 2022-03-31 | Armstrong | Texas | 48011 | 523 | 9 |
2358956 | 2358956 | 2022-03-30 | Armstrong | Texas | 48011 | 523 | 9 |
2353161 | 2353161 | 2022-03-29 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2349909 | 2349909 | 2022-03-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2346656 | 2346656 | 2022-03-27 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2343403 | 2343403 | 2022-03-26 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2340150 | 2340150 | 2022-03-25 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2336897 | 2336897 | 2022-03-24 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2333643 | 2333643 | 2022-03-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2330389 | 2330389 | 2022-03-22 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2327137 | 2327137 | 2022-03-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 523 | 5 |
2267758 | 2267758 | 2022-03-02 | Mellette | South Dakota | 46095 | 523 | 7 |
2248251 | 2248251 | 2022-02-24 | Mellette | South Dakota | 46095 | 523 | 7 |
2213076 | 2213076 | 2022-02-13 | Wahkiakum | Washington | 53069 | 523 | 5 |
2209823 | 2209823 | 2022-02-12 | Wahkiakum | Washington | 53069 | 523 | 5 |
2206570 | 2206570 | 2022-02-11 | Wahkiakum | Washington | 53069 | 523 | 5 |
2189734 | 2189734 | 2022-02-06 | Ziebach | South Dakota | 46137 | 523 | 11 |
2186481 | 2186481 | 2022-02-05 | Ziebach | South Dakota | 46137 | 523 | 11 |
2183229 | 2183229 | 2022-02-04 | Ziebach | South Dakota | 46137 | 523 | 11 |
2179977 | 2179977 | 2022-02-03 | Ziebach | South Dakota | 46137 | 523 | 11 |
2176684 | 2176684 | 2022-02-02 | Faulk | South Dakota | 46049 | 523 | 16 |
2172628 | 2172628 | 2022-02-01 | Cherry | Nebraska | 31031 | 523 | 8 |
2172763 | 2172763 | 2022-02-01 | De Baca | New Mexico | 35011 | 523 | 5 |
2169375 | 2169375 | 2022-01-31 | Cherry | Nebraska | 31031 | 523 | 8 |
2137173 | 2137173 | 2022-01-21 | Griggs | North Dakota | 38039 | 523 | 2 |
2131141 | 2131141 | 2022-01-19 | Jackson | South Dakota | 46071 | 523 | 20 |
2106137 | 2106137 | 2022-01-12 | Custer | Colorado | 8027 | 523 | 16 |
2108286 | 2108286 | 2022-01-12 | Vieques | Puerto Rico | 72147 | 523 | |
2104460 | 2104460 | 2022-01-11 | Mora | New Mexico | 35033 | 523 | 14 |
2079135 | 2079135 | 2022-01-03 | Stanley | South Dakota | 46117 | 523 | 3 |
2032705 | 2032705 | 2021-12-20 | Schuyler | Missouri | 29197 | 523 | 22 |
1994135 | 1994135 | 2021-12-08 | McIntosh | North Dakota | 38051 | 523 | 9 |
1960966 | 1960966 | 2021-11-28 | Lake of the Woods | Minnesota | 27077 | 523 | 5 |
1961362 | 1961362 | 2021-11-28 | Webster | Nebraska | 31181 | 523 | 9 |
1957715 | 1957715 | 2021-11-27 | Lake of the Woods | Minnesota | 27077 | 523 | 5 |
1958111 | 1958111 | 2021-11-27 | Webster | Nebraska | 31181 | 523 | 9 |
1954464 | 1954464 | 2021-11-26 | Lake of the Woods | Minnesota | 27077 | 523 | 5 |
1954860 | 1954860 | 2021-11-26 | Webster | Nebraska | 31181 | 523 | 9 |
1951213 | 1951213 | 2021-11-25 | Lake of the Woods | Minnesota | 27077 | 523 | 5 |
1951609 | 1951609 | 2021-11-25 | Webster | Nebraska | 31181 | 523 | 9 |
1947962 | 1947962 | 2021-11-24 | Lake of the Woods | Minnesota | 27077 | 523 | 5 |
1948358 | 1948358 | 2021-11-24 | Webster | Nebraska | 31181 | 523 | 9 |
1943614 | 1943614 | 2021-11-23 | Gilpin | Colorado | 8047 | 523 | 3 |
1944309 | 1944309 | 2021-11-23 | Ness | Kansas | 20135 | 523 | 17 |
1941059 | 1941059 | 2021-11-22 | Ness | Kansas | 20135 | 523 | 17 |
1921494 | 1921494 | 2021-11-16 | Barber | Kansas | 20007 | 523 | 7 |
1918244 | 1918244 | 2021-11-15 | Barber | Kansas | 20007 | 523 | 7 |
1914343 | 1914343 | 2021-11-14 | Baca | Colorado | 8009 | 523 | 5 |
1915754 | 1915754 | 2021-11-14 | Sheridan | Montana | 30091 | 523 | 8 |
1911093 | 1911093 | 2021-11-13 | Baca | Colorado | 8009 | 523 | 5 |
1912504 | 1912504 | 2021-11-13 | Sheridan | Montana | 30091 | 523 | 8 |
1907844 | 1907844 | 2021-11-12 | Baca | Colorado | 8009 | 523 | 5 |
1909254 | 1909254 | 2021-11-12 | Sheridan | Montana | 30091 | 523 | 8 |
1897071 | 1897071 | 2021-11-08 | Clark | South Dakota | 46025 | 523 | 5 |
1878438 | 1878438 | 2021-11-03 | Unknown | Alaska | 523 | 1 | |
1875189 | 1875189 | 2021-11-02 | Unknown | Alaska | 523 | 1 | |
1876650 | 1876650 | 2021-11-02 | Knox | Missouri | 29103 | 523 | 3 |
1871940 | 1871940 | 2021-11-01 | Unknown | Alaska | 523 | 1 | |
1873401 | 1873401 | 2021-11-01 | Knox | Missouri | 29103 | 523 | 3 |
1870152 | 1870152 | 2021-10-31 | Knox | Missouri | 29103 | 523 | 3 |
1866903 | 1866903 | 2021-10-30 | Knox | Missouri | 29103 | 523 | 3 |
1853531 | 1853531 | 2021-10-26 | Tensas | Louisiana | 22107 | 523 | 9 |
1831456 | 1831456 | 2021-10-19 | Union | New Mexico | 35059 | 523 | 12 |
1815028 | 1815028 | 2021-10-14 | Sweet Grass | Montana | 30097 | 523 | 7 |
1815088 | 1815088 | 2021-10-14 | Kimball | Nebraska | 31105 | 523 | 9 |
1812934 | 1812934 | 2021-10-13 | Real | Texas | 48385 | 523 | 18 |
1792356 | 1792356 | 2021-10-07 | Nuckolls | Nebraska | 31129 | 523 | 12 |
1768865 | 1768865 | 2021-09-30 | Stafford | Kansas | 20185 | 523 | 14 |
1765616 | 1765616 | 2021-09-29 | Stafford | Kansas | 20185 | 523 | 14 |
1766647 | 1766647 | 2021-09-29 | Emmons | North Dakota | 38029 | 523 | 14 |
1762432 | 1762432 | 2021-09-28 | Hickman | Kentucky | 21105 | 523 | 18 |
1763398 | 1763398 | 2021-09-28 | Emmons | North Dakota | 38029 | 523 | 14 |
1741959 | 1741959 | 2021-09-22 | Dillingham Census Area | Alaska | 2070 | 523 | 5 |
1743923 | 1743923 | 2021-09-22 | Nelson | North Dakota | 38063 | 523 | 16 |
1741357 | 1741357 | 2021-09-21 | Hall | Texas | 48191 | 523 | 15 |
1733870 | 1733870 | 2021-09-19 | Morrill | Nebraska | 31123 | 523 | 15 |
1734993 | 1734993 | 2021-09-19 | Upton | Texas | 48461 | 523 | 12 |
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);