ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
663 rows where cases = 399 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Dakota 46
- Missouri 38
- Texas 35
- South Dakota 32
- Georgia 31
- Nebraska 31
- Colorado 23
- Virginia 23
- Kentucky 21
- West Virginia 19
- Alaska 18
- Idaho 18
- Minnesota 18
- Louisiana 17
- Montana 17
- Oklahoma 17
- Pennsylvania 17
- Washington 16
- Michigan 15
- Illinois 14
- Puerto Rico 14
- Iowa 13
- Mississippi 13
- Kansas 12
- Tennessee 12
- Indiana 11
- Ohio 11
- Florida 10
- New York 10
- Oregon 10
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471970 | 2471970 | 2022-05-04 | Harlan | Nebraska | 31083 | 399 | 3 |
2468714 | 2468714 | 2022-05-03 | Harlan | Nebraska | 31083 | 399 | 3 |
2442667 | 2442667 | 2022-04-25 | Harlan | Nebraska | 31083 | 399 | 3 |
2439411 | 2439411 | 2022-04-24 | Harlan | Nebraska | 31083 | 399 | 3 |
2436155 | 2436155 | 2022-04-23 | Harlan | Nebraska | 31083 | 399 | 3 |
2432899 | 2432899 | 2022-04-22 | Harlan | Nebraska | 31083 | 399 | 3 |
2375912 | 2375912 | 2022-04-05 | Denali Borough | Alaska | 2068 | 399 | 1 |
2372660 | 2372660 | 2022-04-04 | Denali Borough | Alaska | 2068 | 399 | 1 |
2369407 | 2369407 | 2022-04-03 | Denali Borough | Alaska | 2068 | 399 | 1 |
2366154 | 2366154 | 2022-04-02 | Denali Borough | Alaska | 2068 | 399 | 1 |
2362901 | 2362901 | 2022-04-01 | Denali Borough | Alaska | 2068 | 399 | 1 |
2359647 | 2359647 | 2022-03-31 | Denali Borough | Alaska | 2068 | 399 | 1 |
2356393 | 2356393 | 2022-03-30 | Denali Borough | Alaska | 2068 | 399 | 1 |
2354775 | 2354775 | 2022-03-29 | Garfield | Nebraska | 31071 | 399 | 2 |
2351522 | 2351522 | 2022-03-28 | Garfield | Nebraska | 31071 | 399 | 2 |
2286375 | 2286375 | 2022-03-08 | Worth | Missouri | 29227 | 399 | 3 |
2283123 | 2283123 | 2022-03-07 | Worth | Missouri | 29227 | 399 | 3 |
2279870 | 2279870 | 2022-03-06 | Worth | Missouri | 29227 | 399 | 3 |
2276617 | 2276617 | 2022-03-05 | Worth | Missouri | 29227 | 399 | 3 |
2273364 | 2273364 | 2022-03-04 | Worth | Missouri | 29227 | 399 | 3 |
2270112 | 2270112 | 2022-03-03 | Worth | Missouri | 29227 | 399 | 3 |
2266859 | 2266859 | 2022-03-02 | Worth | Missouri | 29227 | 399 | 3 |
2234552 | 2234552 | 2022-02-20 | Catron | New Mexico | 35003 | 399 | 13 |
2231301 | 2231301 | 2022-02-19 | Catron | New Mexico | 35003 | 399 | 13 |
2228050 | 2228050 | 2022-02-18 | Catron | New Mexico | 35003 | 399 | 13 |
2224799 | 2224799 | 2022-02-17 | Catron | New Mexico | 35003 | 399 | 13 |
2221548 | 2221548 | 2022-02-16 | Catron | New Mexico | 35003 | 399 | 13 |
2214874 | 2214874 | 2022-02-14 | Meagher | Montana | 30059 | 399 | 10 |
2196212 | 2196212 | 2022-02-08 | Jerauld | South Dakota | 46073 | 399 | 19 |
2192958 | 2192958 | 2022-02-07 | Jerauld | South Dakota | 46073 | 399 | 19 |
2141751 | 2141751 | 2022-01-23 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 399 | 5 |
2138495 | 2138495 | 2022-01-22 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 399 | 5 |
2135240 | 2135240 | 2022-01-21 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 399 | 5 |
2111919 | 2111919 | 2022-01-13 | Menard | Texas | 48327 | 399 | 12 |
2107900 | 2107900 | 2022-01-12 | Golden Valley | North Dakota | 38033 | 399 | 4 |
2098635 | 2098635 | 2022-01-09 | Mellette | South Dakota | 46095 | 399 | 4 |
2095383 | 2095383 | 2022-01-08 | Mellette | South Dakota | 46095 | 399 | 4 |
2092131 | 2092131 | 2022-01-07 | Mellette | South Dakota | 46095 | 399 | 4 |
2087291 | 2087291 | 2022-01-06 | Elk | Kansas | 20049 | 399 | 7 |
2084039 | 2084039 | 2022-01-05 | Elk | Kansas | 20049 | 399 | 7 |
1964589 | 1964589 | 2021-11-29 | Perkins | Nebraska | 31135 | 399 | 12 |
1938546 | 1938546 | 2021-11-21 | Frontier | Nebraska | 31063 | 399 | 2 |
1938596 | 1938596 | 2021-11-21 | Sherman | Nebraska | 31163 | 399 | 4 |
1939933 | 1939933 | 2021-11-21 | San Juan | Washington | 53055 | 399 | 0 |
1935296 | 1935296 | 2021-11-20 | Frontier | Nebraska | 31063 | 399 | 2 |
1935346 | 1935346 | 2021-11-20 | Sherman | Nebraska | 31163 | 399 | 4 |
1936683 | 1936683 | 2021-11-20 | San Juan | Washington | 53055 | 399 | 0 |
1932046 | 1932046 | 2021-11-19 | Frontier | Nebraska | 31063 | 399 | 2 |
1932096 | 1932096 | 2021-11-19 | Sherman | Nebraska | 31163 | 399 | 4 |
1933433 | 1933433 | 2021-11-19 | San Juan | Washington | 53055 | 399 | 0 |
1928795 | 1928795 | 2021-11-18 | Frontier | Nebraska | 31063 | 399 | 2 |
1929612 | 1929612 | 2021-11-18 | Sanborn | South Dakota | 46111 | 399 | 3 |
1925545 | 1925545 | 2021-11-17 | Frontier | Nebraska | 31063 | 399 | 2 |
1922619 | 1922619 | 2021-11-16 | Griggs | North Dakota | 38039 | 399 | 2 |
1919836 | 1919836 | 2021-11-15 | Hand | South Dakota | 46059 | 399 | 6 |
1916586 | 1916586 | 2021-11-14 | Hand | South Dakota | 46059 | 399 | 6 |
1913336 | 1913336 | 2021-11-13 | Hand | South Dakota | 46059 | 399 | 6 |
1910086 | 1910086 | 2021-11-12 | Hand | South Dakota | 46059 | 399 | 6 |
1906837 | 1906837 | 2021-11-11 | Hand | South Dakota | 46059 | 399 | 6 |
1903588 | 1903588 | 2021-11-10 | Hand | South Dakota | 46059 | 399 | 6 |
1900338 | 1900338 | 2021-11-09 | Hand | South Dakota | 46059 | 399 | 6 |
1896602 | 1896602 | 2021-11-08 | Adams | North Dakota | 38001 | 399 | 5 |
1897276 | 1897276 | 2021-11-08 | Culberson | Texas | 48109 | 399 | 11 |
1893352 | 1893352 | 2021-11-07 | Adams | North Dakota | 38001 | 399 | 5 |
1894026 | 1894026 | 2021-11-07 | Culberson | Texas | 48109 | 399 | 11 |
1881016 | 1881016 | 2021-11-03 | Collingsworth | Texas | 48087 | 399 | 11 |
1877596 | 1877596 | 2021-11-02 | Jackson | South Dakota | 46071 | 399 | 16 |
1860540 | 1860540 | 2021-10-28 | Cherry | Nebraska | 31031 | 399 | 8 |
1857291 | 1857291 | 2021-10-27 | Cherry | Nebraska | 31031 | 399 | 8 |
1851593 | 1851593 | 2021-10-25 | Faulk | South Dakota | 46049 | 399 | 15 |
1848343 | 1848343 | 2021-10-24 | Faulk | South Dakota | 46049 | 399 | 15 |
1845093 | 1845093 | 2021-10-23 | Faulk | South Dakota | 46049 | 399 | 15 |
1839678 | 1839678 | 2021-10-22 | Unknown | Delaware | 399 | 0 | |
1841843 | 1841843 | 2021-10-22 | Faulk | South Dakota | 46049 | 399 | 15 |
1838594 | 1838594 | 2021-10-21 | Faulk | South Dakota | 46049 | 399 | 15 |
1835345 | 1835345 | 2021-10-20 | Faulk | South Dakota | 46049 | 399 | 15 |
1824079 | 1824079 | 2021-10-17 | Osborne | Kansas | 20141 | 399 | 14 |
1820830 | 1820830 | 2021-10-16 | Osborne | Kansas | 20141 | 399 | 14 |
1817581 | 1817581 | 2021-10-15 | Osborne | Kansas | 20141 | 399 | 14 |
1790913 | 1790913 | 2021-10-07 | Ouray | Colorado | 8091 | 399 | 5 |
1787664 | 1787664 | 2021-10-06 | Ouray | Colorado | 8091 | 399 | 5 |
1786957 | 1786957 | 2021-10-05 | Shackelford | Texas | 48417 | 399 | 5 |
1770396 | 1770396 | 2021-09-30 | Stanley | South Dakota | 46117 | 399 | 3 |
1741142 | 1741142 | 2021-09-21 | Marshall | South Dakota | 46091 | 399 | 6 |
1737893 | 1737893 | 2021-09-20 | Marshall | South Dakota | 46091 | 399 | 6 |
1720704 | 1720704 | 2021-09-15 | Mercer | Missouri | 29129 | 399 | 3 |
1721514 | 1721514 | 2021-09-15 | Las Marias | Puerto Rico | 72083 | 399 | |
1679726 | 1679726 | 2021-09-02 | Real | Texas | 48385 | 399 | 14 |
1675308 | 1675308 | 2021-09-01 | Musselshell | Montana | 30065 | 399 | 14 |
1670482 | 1670482 | 2021-08-31 | Aleutians East Borough | Alaska | 2013 | 399 | 3 |
1668571 | 1668571 | 2021-08-30 | Traverse | Minnesota | 27155 | 399 | 5 |
1664010 | 1664010 | 2021-08-29 | Unknown | Alaska | 399 | 0 | |
1665324 | 1665324 | 2021-08-29 | Traverse | Minnesota | 27155 | 399 | 5 |
1660762 | 1660762 | 2021-08-28 | Unknown | Alaska | 399 | 0 | |
1662076 | 1662076 | 2021-08-28 | Traverse | Minnesota | 27155 | 399 | 5 |
1657514 | 1657514 | 2021-08-27 | Unknown | Alaska | 399 | 0 | |
1658828 | 1658828 | 2021-08-27 | Traverse | Minnesota | 27155 | 399 | 5 |
1625531 | 1625531 | 2021-08-17 | Oneida | Idaho | 16071 | 399 | 4 |
1619344 | 1619344 | 2021-08-15 | Barber | Kansas | 20007 | 399 | 7 |
1621678 | 1621678 | 2021-08-15 | Hot Springs | Wyoming | 56017 | 399 | 3 |
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);