ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
338 rows where cases = 1370 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 36
- Georgia 17
- Minnesota 16
- Iowa 15
- Puerto Rico 15
- Virginia 15
- Wisconsin 15
- Missouri 14
- Indiana 13
- Kentucky 12
- Mississippi 12
- Tennessee 12
- Oklahoma 11
- Arkansas 9
- Kansas 9
- Ohio 9
- Idaho 8
- Louisiana 8
- Montana 8
- North Carolina 8
- West Virginia 8
- Alabama 7
- South Dakota 6
- Colorado 5
- Maine 5
- California 4
- Illinois 4
- Oregon 4
- Pennsylvania 4
- Vermont 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2428907 | 2428907 | 2022-04-21 | Rooks | Kansas | 20163 | 1370 | 20 |
2425651 | 2425651 | 2022-04-20 | Rooks | Kansas | 20163 | 1370 | 20 |
2422395 | 2422395 | 2022-04-19 | Rooks | Kansas | 20163 | 1370 | 20 |
2419139 | 2419139 | 2022-04-18 | Rooks | Kansas | 20163 | 1370 | 20 |
2415883 | 2415883 | 2022-04-17 | Rooks | Kansas | 20163 | 1370 | 20 |
2412627 | 2412627 | 2022-04-16 | Rooks | Kansas | 20163 | 1370 | 20 |
2409371 | 2409371 | 2022-04-15 | Rooks | Kansas | 20163 | 1370 | 20 |
2262881 | 2262881 | 2022-03-01 | Van Buren | Iowa | 19177 | 1370 | 26 |
2259630 | 2259630 | 2022-02-28 | Van Buren | Iowa | 19177 | 1370 | 26 |
2261379 | 2261379 | 2022-02-28 | Bailey | Texas | 48017 | 1370 | 38 |
2256379 | 2256379 | 2022-02-27 | Van Buren | Iowa | 19177 | 1370 | 26 |
2258128 | 2258128 | 2022-02-27 | Bailey | Texas | 48017 | 1370 | 38 |
2253128 | 2253128 | 2022-02-26 | Van Buren | Iowa | 19177 | 1370 | 26 |
2254877 | 2254877 | 2022-02-26 | Bailey | Texas | 48017 | 1370 | 38 |
2249877 | 2249877 | 2022-02-25 | Van Buren | Iowa | 19177 | 1370 | 26 |
2251626 | 2251626 | 2022-02-25 | Bailey | Texas | 48017 | 1370 | 38 |
2246626 | 2246626 | 2022-02-24 | Van Buren | Iowa | 19177 | 1370 | 26 |
2248375 | 2248375 | 2022-02-24 | Bailey | Texas | 48017 | 1370 | 38 |
2243375 | 2243375 | 2022-02-23 | Van Buren | Iowa | 19177 | 1370 | 26 |
2245014 | 2245014 | 2022-02-23 | Tripp | South Dakota | 46123 | 1370 | 23 |
2245124 | 2245124 | 2022-02-23 | Bailey | Texas | 48017 | 1370 | 37 |
2241752 | 2241752 | 2022-02-22 | Moody | South Dakota | 46101 | 1370 | 27 |
2241873 | 2241873 | 2022-02-22 | Bailey | Texas | 48017 | 1370 | 37 |
2200763 | 2200763 | 2022-02-10 | Wheeler | Georgia | 13309 | 1370 | 38 |
2156686 | 2156686 | 2022-01-27 | Dickey | North Dakota | 38021 | 1370 | 38 |
2154076 | 2154076 | 2022-01-26 | Carson | Texas | 48065 | 1370 | 31 |
2113899 | 2113899 | 2022-01-14 | Chariton | Missouri | 29041 | 1370 | 32 |
2081442 | 2081442 | 2022-01-04 | Ozark | Missouri | 29153 | 1370 | 47 |
2077706 | 2077706 | 2022-01-03 | Nicholas | Kentucky | 21181 | 1370 | 29 |
2075755 | 2075755 | 2022-01-02 | Rincon | Puerto Rico | 72117 | 1370 | |
2056502 | 2056502 | 2021-12-27 | Blanco | Texas | 48031 | 1370 | 28 |
2051096 | 2051096 | 2021-12-26 | Macon | Georgia | 13193 | 1370 | 46 |
2053334 | 2053334 | 2021-12-26 | Hamilton | Texas | 48193 | 1370 | 29 |
2047846 | 2047846 | 2021-12-25 | Macon | Georgia | 13193 | 1370 | 46 |
2050084 | 2050084 | 2021-12-25 | Hamilton | Texas | 48193 | 1370 | 29 |
2044596 | 2044596 | 2021-12-24 | Macon | Georgia | 13193 | 1370 | 46 |
2046834 | 2046834 | 2021-12-24 | Hamilton | Texas | 48193 | 1370 | 29 |
2043584 | 2043584 | 2021-12-23 | Hamilton | Texas | 48193 | 1370 | 29 |
2031898 | 2031898 | 2021-12-20 | Union | Indiana | 18161 | 1370 | 18 |
2015979 | 2015979 | 2021-12-15 | Wolfe | Kentucky | 21237 | 1370 | 13 |
2013206 | 2013206 | 2021-12-14 | St. Clair | Missouri | 29185 | 1370 | 27 |
2008308 | 2008308 | 2021-12-12 | Pepin | Wisconsin | 55091 | 1370 | 12 |
2005057 | 2005057 | 2021-12-11 | Pepin | Wisconsin | 55091 | 1370 | 12 |
2001806 | 2001806 | 2021-12-10 | Pepin | Wisconsin | 55091 | 1370 | 12 |
1994809 | 1994809 | 2021-12-08 | Franklin | Texas | 48159 | 1370 | 37 |
1989881 | 1989881 | 2021-12-07 | Crittenden | Kentucky | 21055 | 1370 | 37 |
1988022 | 1988022 | 2021-12-06 | Allendale | South Carolina | 45005 | 1370 | 21 |
1983777 | 1983777 | 2021-12-05 | Choctaw | Mississippi | 28019 | 1370 | 27 |
1980527 | 1980527 | 2021-12-04 | Choctaw | Mississippi | 28019 | 1370 | 27 |
1977277 | 1977277 | 2021-12-03 | Choctaw | Mississippi | 28019 | 1370 | 27 |
1974027 | 1974027 | 2021-12-02 | Choctaw | Mississippi | 28019 | 1370 | 27 |
1966411 | 1966411 | 2021-11-30 | Yuma | Colorado | 8125 | 1370 | 18 |
1965876 | 1965876 | 2021-11-29 | Poquoson city | Virginia | 51735 | 1370 | 22 |
1962260 | 1962260 | 2021-11-28 | Castro | Texas | 48069 | 1370 | 38 |
1962624 | 1962624 | 2021-11-28 | Poquoson city | Virginia | 51735 | 1370 | 22 |
1959009 | 1959009 | 2021-11-27 | Castro | Texas | 48069 | 1370 | 38 |
1959373 | 1959373 | 2021-11-27 | Poquoson city | Virginia | 51735 | 1370 | 22 |
1955758 | 1955758 | 2021-11-26 | Castro | Texas | 48069 | 1370 | 38 |
1956122 | 1956122 | 2021-11-26 | Poquoson city | Virginia | 51735 | 1370 | 22 |
1952507 | 1952507 | 2021-11-25 | Castro | Texas | 48069 | 1370 | 38 |
1949256 | 1949256 | 2021-11-24 | Castro | Texas | 48069 | 1370 | 38 |
1946005 | 1946005 | 2021-11-23 | Castro | Texas | 48069 | 1370 | 38 |
1937407 | 1937407 | 2021-11-21 | Benewah | Idaho | 16009 | 1370 | 28 |
1934157 | 1934157 | 2021-11-20 | Benewah | Idaho | 16009 | 1370 | 28 |
1929455 | 1929455 | 2021-11-18 | Guayama | Puerto Rico | 72057 | 1370 | |
1926205 | 1926205 | 2021-11-17 | Guayama | Puerto Rico | 72057 | 1370 | |
1878206 | 1878206 | 2021-11-02 | Doddridge | West Virginia | 54017 | 1370 | 10 |
1859765 | 1859765 | 2021-10-28 | Cloud | Kansas | 20029 | 1370 | 29 |
1856516 | 1856516 | 2021-10-27 | Cloud | Kansas | 20029 | 1370 | 29 |
1858686 | 1858686 | 2021-10-27 | Lincoln | Washington | 53043 | 1370 | 22 |
1853734 | 1853734 | 2021-10-26 | Murray | Minnesota | 27101 | 1370 | 11 |
1849315 | 1849315 | 2021-10-25 | Mariposa | California | 6043 | 1370 | 17 |
1832428 | 1832428 | 2021-10-19 | Red River | Texas | 48387 | 1370 | 48 |
1808483 | 1808483 | 2021-10-12 | Beaverhead | Montana | 30001 | 1370 | 15 |
1810010 | 1810010 | 2021-10-12 | Roane | West Virginia | 54087 | 1370 | 16 |
1804217 | 1804217 | 2021-10-11 | Valley | Idaho | 16085 | 1370 | 10 |
1800968 | 1800968 | 2021-10-10 | Valley | Idaho | 16085 | 1370 | 10 |
1797011 | 1797011 | 2021-10-08 | Ritchie | West Virginia | 54085 | 1370 | 16 |
1787496 | 1787496 | 2021-10-06 | Cleveland | Arkansas | 5025 | 1370 | 32 |
1779250 | 1779250 | 2021-10-03 | Dawson | Montana | 30021 | 1370 | 34 |
1776000 | 1776000 | 2021-10-02 | Dawson | Montana | 30021 | 1370 | 34 |
1772750 | 1772750 | 2021-10-01 | Dawson | Montana | 30021 | 1370 | 34 |
1765789 | 1765789 | 2021-09-29 | Red River | Louisiana | 22081 | 1370 | 44 |
1762737 | 1762737 | 2021-09-28 | Jackson | Minnesota | 27063 | 1370 | 12 |
1721457 | 1721457 | 2021-09-15 | Potter | Pennsylvania | 42105 | 1370 | 27 |
1713406 | 1713406 | 2021-09-13 | Newton | Indiana | 18111 | 1370 | 43 |
1714173 | 1714173 | 2021-09-13 | DeKalb | Missouri | 29063 | 1370 | 33 |
1715692 | 1715692 | 2021-09-13 | Sussex | Virginia | 51183 | 1370 | 23 |
1700232 | 1700232 | 2021-09-09 | Franklin | Idaho | 16041 | 1370 | 19 |
1696911 | 1696911 | 2021-09-08 | Pulaski | Georgia | 13235 | 1370 | 51 |
1684914 | 1684914 | 2021-09-04 | Bollinger | Missouri | 29017 | 1370 | 15 |
1673641 | 1673641 | 2021-08-31 | Big Horn | Wyoming | 56003 | 1370 | 38 |
1653581 | 1653581 | 2021-08-25 | Callahan | Texas | 48059 | 1370 | 44 |
1588899 | 1588899 | 2021-08-05 | Brunswick | Virginia | 51025 | 1370 | 25 |
1584117 | 1584117 | 2021-08-04 | Watonwan | Minnesota | 27165 | 1370 | 9 |
1584177 | 1584177 | 2021-08-04 | Perry | Mississippi | 28111 | 1370 | 38 |
1582663 | 1582663 | 2021-08-03 | Price | Wisconsin | 55099 | 1370 | 8 |
1573541 | 1573541 | 2021-08-01 | Gooding | Idaho | 16047 | 1370 | 23 |
1570293 | 1570293 | 2021-07-31 | Gooding | Idaho | 16047 | 1370 | 23 |
1570930 | 1570930 | 2021-07-31 | Kent | Maryland | 24029 | 1370 | 51 |
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);