ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
451 rows where cases = 1243 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 30
- Montana 30
- Texas 26
- Oklahoma 25
- Iowa 22
- Kentucky 21
- Kansas 20
- Alabama 19
- Virginia 19
- Michigan 17
- Idaho 14
- North Carolina 13
- Mississippi 12
- Oregon 12
- Puerto Rico 12
- Colorado 11
- Missouri 11
- Wisconsin 11
- Arkansas 10
- Minnesota 10
- Tennessee 9
- Utah 9
- West Virginia 9
- Illinois 8
- Florida 7
- Louisiana 7
- Nebraska 7
- North Dakota 7
- Indiana 5
- New York 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2450297 | 2450297 | 2022-04-27 | Sabine | Texas | 48403 | 1243 | 89 |
2447040 | 2447040 | 2022-04-26 | Sabine | Texas | 48403 | 1243 | 89 |
2443785 | 2443785 | 2022-04-25 | Sabine | Texas | 48403 | 1243 | 89 |
2440529 | 2440529 | 2022-04-24 | Sabine | Texas | 48403 | 1243 | 89 |
2437273 | 2437273 | 2022-04-23 | Sabine | Texas | 48403 | 1243 | 89 |
2434017 | 2434017 | 2022-04-22 | Sabine | Texas | 48403 | 1243 | 89 |
2430761 | 2430761 | 2022-04-21 | Sabine | Texas | 48403 | 1243 | 89 |
2427505 | 2427505 | 2022-04-20 | Sabine | Texas | 48403 | 1243 | 89 |
2388485 | 2388485 | 2022-04-08 | Yoakum | Texas | 48501 | 1243 | 41 |
2385230 | 2385230 | 2022-04-07 | Yoakum | Texas | 48501 | 1243 | 41 |
2381975 | 2381975 | 2022-04-06 | Yoakum | Texas | 48501 | 1243 | 41 |
2378720 | 2378720 | 2022-04-05 | Yoakum | Texas | 48501 | 1243 | 41 |
2354801 | 2354801 | 2022-03-29 | Morrill | Nebraska | 31123 | 1243 | 18 |
2348296 | 2348296 | 2022-03-27 | Morrill | Nebraska | 31123 | 1243 | 18 |
2345043 | 2345043 | 2022-03-26 | Morrill | Nebraska | 31123 | 1243 | 18 |
2341790 | 2341790 | 2022-03-25 | Morrill | Nebraska | 31123 | 1243 | 18 |
2328709 | 2328709 | 2022-03-21 | Toole | Montana | 30101 | 1243 | 23 |
2269185 | 2269185 | 2022-03-03 | Scott | Illinois | 17171 | 1243 | 11 |
2263613 | 2263613 | 2022-03-01 | Broadwater | Montana | 30007 | 1243 | 18 |
2223669 | 2223669 | 2022-02-17 | Scott | Illinois | 17171 | 1243 | 11 |
2222749 | 2222749 | 2022-02-16 | Norton city | Virginia | 51720 | 1243 | 22 |
2218145 | 2218145 | 2022-02-15 | Teton | Montana | 30099 | 1243 | 20 |
2193803 | 2193803 | 2022-02-08 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1243 | 8 |
2190550 | 2190550 | 2022-02-07 | Yukon-Koyukuk Census Area | Alaska | 2290 | 1243 | 8 |
2169022 | 2169022 | 2022-01-31 | Big Stone | Minnesota | 27011 | 1243 | 7 |
2140756 | 2140756 | 2022-01-22 | Ceiba | Puerto Rico | 72037 | 1243 | |
2097600 | 2097600 | 2022-01-09 | Quitman | Mississippi | 28119 | 1243 | 28 |
2099133 | 2099133 | 2022-01-09 | Middlesex | Virginia | 51119 | 1243 | 34 |
2094348 | 2094348 | 2022-01-08 | Quitman | Mississippi | 28119 | 1243 | 28 |
2095882 | 2095882 | 2022-01-08 | Middlesex | Virginia | 51119 | 1243 | 34 |
2091096 | 2091096 | 2022-01-07 | Quitman | Mississippi | 28119 | 1243 | 28 |
2092630 | 2092630 | 2022-01-07 | Middlesex | Virginia | 51119 | 1243 | 34 |
2088702 | 2088702 | 2022-01-06 | Adjuntas | Puerto Rico | 72001 | 1243 | |
2079435 | 2079435 | 2022-01-03 | Refugio | Texas | 48391 | 1243 | 31 |
2079721 | 2079721 | 2022-01-03 | Calhoun | West Virginia | 54013 | 1243 | 9 |
2076243 | 2076243 | 2022-01-02 | Beaver | Utah | 49001 | 1243 | 14 |
2072992 | 2072992 | 2022-01-01 | Beaver | Utah | 49001 | 1243 | 14 |
2069741 | 2069741 | 2021-12-31 | Beaver | Utah | 49001 | 1243 | 14 |
2039275 | 2039275 | 2021-12-22 | Stillwater | Montana | 30095 | 1243 | 29 |
2040862 | 2040862 | 2021-12-22 | Weston | Wyoming | 56045 | 1243 | 14 |
2035883 | 2035883 | 2021-12-21 | Clark | Missouri | 29045 | 1243 | 28 |
2036025 | 2036025 | 2021-12-21 | Stillwater | Montana | 30095 | 1243 | 29 |
2037612 | 2037612 | 2021-12-21 | Weston | Wyoming | 56045 | 1243 | 14 |
2032775 | 2032775 | 2021-12-20 | Stillwater | Montana | 30095 | 1243 | 29 |
2033599 | 2033599 | 2021-12-20 | Fall River | South Dakota | 46047 | 1243 | 28 |
2029524 | 2029524 | 2021-12-19 | Stillwater | Montana | 30095 | 1243 | 29 |
2026273 | 2026273 | 2021-12-18 | Stillwater | Montana | 30095 | 1243 | 29 |
2023022 | 2023022 | 2021-12-17 | Stillwater | Montana | 30095 | 1243 | 29 |
2019771 | 2019771 | 2021-12-16 | Stillwater | Montana | 30095 | 1243 | 29 |
2016521 | 2016521 | 2021-12-15 | Stillwater | Montana | 30095 | 1243 | 29 |
2013270 | 2013270 | 2021-12-14 | Stillwater | Montana | 30095 | 1243 | 29 |
2010019 | 2010019 | 2021-12-13 | Stillwater | Montana | 30095 | 1243 | 29 |
2005403 | 2005403 | 2021-12-12 | Rio Blanco | Colorado | 8103 | 1243 | 11 |
2006768 | 2006768 | 2021-12-12 | Stillwater | Montana | 30095 | 1243 | 29 |
2008163 | 2008163 | 2021-12-12 | Williamsburg city | Virginia | 51830 | 1243 | 13 |
2002152 | 2002152 | 2021-12-11 | Rio Blanco | Colorado | 8103 | 1243 | 11 |
2003517 | 2003517 | 2021-12-11 | Stillwater | Montana | 30095 | 1243 | 29 |
2004912 | 2004912 | 2021-12-11 | Williamsburg city | Virginia | 51830 | 1243 | 13 |
1998902 | 1998902 | 2021-12-10 | Rio Blanco | Colorado | 8103 | 1243 | 11 |
2000267 | 2000267 | 2021-12-10 | Stillwater | Montana | 30095 | 1243 | 29 |
2001661 | 2001661 | 2021-12-10 | Williamsburg city | Virginia | 51830 | 1243 | 13 |
1997016 | 1997016 | 2021-12-09 | Stillwater | Montana | 30095 | 1243 | 29 |
1993765 | 1993765 | 2021-12-08 | Stillwater | Montana | 30095 | 1243 | 29 |
1990773 | 1990773 | 2021-12-07 | Camden | North Carolina | 37029 | 1243 | 9 |
1987264 | 1987264 | 2021-12-06 | Stillwater | Montana | 30095 | 1243 | 29 |
1984014 | 1984014 | 2021-12-05 | Stillwater | Montana | 30095 | 1243 | 29 |
1980764 | 1980764 | 2021-12-04 | Stillwater | Montana | 30095 | 1243 | 29 |
1977514 | 1977514 | 2021-12-03 | Stillwater | Montana | 30095 | 1243 | 29 |
1978998 | 1978998 | 2021-12-03 | Tucker | West Virginia | 54093 | 1243 | 31 |
1975737 | 1975737 | 2021-12-02 | Pendleton | West Virginia | 54071 | 1243 | 15 |
1960125 | 1960125 | 2021-11-28 | Terrell | Georgia | 13273 | 1243 | 57 |
1962616 | 1962616 | 2021-11-28 | Northumberland | Virginia | 51133 | 1243 | 36 |
1956874 | 1956874 | 2021-11-27 | Terrell | Georgia | 13273 | 1243 | 57 |
1959365 | 1959365 | 2021-11-27 | Northumberland | Virginia | 51133 | 1243 | 36 |
1953623 | 1953623 | 2021-11-26 | Terrell | Georgia | 13273 | 1243 | 57 |
1956114 | 1956114 | 2021-11-26 | Northumberland | Virginia | 51133 | 1243 | 36 |
1950372 | 1950372 | 2021-11-25 | Terrell | Georgia | 13273 | 1243 | 57 |
1947121 | 1947121 | 2021-11-24 | Terrell | Georgia | 13273 | 1243 | 57 |
1943870 | 1943870 | 2021-11-23 | Terrell | Georgia | 13273 | 1243 | 57 |
1940620 | 1940620 | 2021-11-22 | Terrell | Georgia | 13273 | 1243 | 57 |
1937370 | 1937370 | 2021-11-21 | Terrell | Georgia | 13273 | 1243 | 57 |
1939407 | 1939407 | 2021-11-21 | Hancock | Tennessee | 47067 | 1243 | 20 |
1934120 | 1934120 | 2021-11-20 | Terrell | Georgia | 13273 | 1243 | 57 |
1936157 | 1936157 | 2021-11-20 | Hancock | Tennessee | 47067 | 1243 | 20 |
1930868 | 1930868 | 2021-11-19 | Terrell | Georgia | 13273 | 1243 | 57 |
1932731 | 1932731 | 2021-11-19 | Orocovis | Puerto Rico | 72107 | 1243 | |
1932907 | 1932907 | 2021-11-19 | Hancock | Tennessee | 47067 | 1243 | 20 |
1927395 | 1927395 | 2021-11-18 | San Miguel | Colorado | 8113 | 1243 | 5 |
1925208 | 1925208 | 2021-11-17 | Lake | Minnesota | 27075 | 1243 | 24 |
1921119 | 1921119 | 2021-11-16 | Terrell | Georgia | 13273 | 1243 | 57 |
1921574 | 1921574 | 2021-11-16 | Russell | Kansas | 20167 | 1243 | 33 |
1921959 | 1921959 | 2021-11-16 | Lake | Minnesota | 27075 | 1243 | 24 |
1918324 | 1918324 | 2021-11-15 | Russell | Kansas | 20167 | 1243 | 33 |
1898336 | 1898336 | 2021-11-09 | Miller | Georgia | 13201 | 1243 | 22 |
1891876 | 1891876 | 2021-11-07 | Treutlen | Georgia | 13283 | 1243 | 53 |
1888626 | 1888626 | 2021-11-06 | Treutlen | Georgia | 13283 | 1243 | 53 |
1885376 | 1885376 | 2021-11-05 | Treutlen | Georgia | 13283 | 1243 | 53 |
1882127 | 1882127 | 2021-11-04 | Treutlen | Georgia | 13283 | 1243 | 53 |
1867043 | 1867043 | 2021-10-30 | Custer | Nebraska | 31041 | 1243 | 21 |
1863794 | 1863794 | 2021-10-29 | Custer | Nebraska | 31041 | 1243 | 21 |
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);