ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
470 rows where cases = 1233 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 46
- Kansas 42
- Texas 42
- Kentucky 29
- Georgia 25
- Montana 25
- Alabama 21
- Florida 20
- Missouri 18
- Virginia 18
- Puerto Rico 12
- Illinois 11
- Mississippi 11
- New Mexico 11
- Oklahoma 11
- Arkansas 10
- North Dakota 10
- Tennessee 10
- North Carolina 9
- West Virginia 9
- Indiana 8
- Idaho 7
- Minnesota 7
- South Dakota 7
- Michigan 6
- Oregon 5
- Colorado 4
- New York 4
- California 3
- Louisiana 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2474444 | 2474444 | 2022-05-05 | Gray | Kansas | 20069 | 1233 | 23 |
2471187 | 2471187 | 2022-05-04 | Gray | Kansas | 20069 | 1233 | 23 |
2467931 | 2467931 | 2022-05-03 | Gray | Kansas | 20069 | 1233 | 23 |
2464676 | 2464676 | 2022-05-02 | Gray | Kansas | 20069 | 1233 | 23 |
2461420 | 2461420 | 2022-05-01 | Gray | Kansas | 20069 | 1233 | 23 |
2458164 | 2458164 | 2022-04-30 | Gray | Kansas | 20069 | 1233 | 23 |
2454908 | 2454908 | 2022-04-29 | Gray | Kansas | 20069 | 1233 | 23 |
2451652 | 2451652 | 2022-04-28 | Gray | Kansas | 20069 | 1233 | 23 |
2448396 | 2448396 | 2022-04-27 | Gray | Kansas | 20069 | 1233 | 23 |
2445140 | 2445140 | 2022-04-26 | Gray | Kansas | 20069 | 1233 | 23 |
2441884 | 2441884 | 2022-04-25 | Gray | Kansas | 20069 | 1233 | 23 |
2438628 | 2438628 | 2022-04-24 | Gray | Kansas | 20069 | 1233 | 23 |
2435372 | 2435372 | 2022-04-23 | Gray | Kansas | 20069 | 1233 | 23 |
2432116 | 2432116 | 2022-04-22 | Gray | Kansas | 20069 | 1233 | 23 |
2323368 | 2323368 | 2022-03-19 | Sabine | Texas | 48403 | 1233 | 88 |
2320114 | 2320114 | 2022-03-18 | Sabine | Texas | 48403 | 1233 | 88 |
2293977 | 2293977 | 2022-03-10 | Garza | Texas | 48169 | 1233 | 27 |
2290725 | 2290725 | 2022-03-09 | Garza | Texas | 48169 | 1233 | 27 |
2285705 | 2285705 | 2022-03-08 | Kearny | Kansas | 20093 | 1233 | 20 |
2282453 | 2282453 | 2022-03-07 | Kearny | Kansas | 20093 | 1233 | 20 |
2270164 | 2270164 | 2022-03-03 | Toole | Montana | 30101 | 1233 | 23 |
2270231 | 2270231 | 2022-03-03 | Morrill | Nebraska | 31123 | 1233 | 18 |
2271331 | 2271331 | 2022-03-03 | San Saba | Texas | 48411 | 1233 | 33 |
2266911 | 2266911 | 2022-03-02 | Toole | Montana | 30101 | 1233 | 23 |
2268079 | 2268079 | 2022-03-02 | San Saba | Texas | 48411 | 1233 | 33 |
2263660 | 2263660 | 2022-03-01 | Toole | Montana | 30101 | 1233 | 23 |
2264826 | 2264826 | 2022-03-01 | San Saba | Texas | 48411 | 1233 | 33 |
2260409 | 2260409 | 2022-02-28 | Toole | Montana | 30101 | 1233 | 23 |
2261576 | 2261576 | 2022-02-28 | San Saba | Texas | 48411 | 1233 | 33 |
2257158 | 2257158 | 2022-02-27 | Toole | Montana | 30101 | 1233 | 23 |
2258325 | 2258325 | 2022-02-27 | San Saba | Texas | 48411 | 1233 | 33 |
2253907 | 2253907 | 2022-02-26 | Toole | Montana | 30101 | 1233 | 23 |
2255074 | 2255074 | 2022-02-26 | San Saba | Texas | 48411 | 1233 | 33 |
2250656 | 2250656 | 2022-02-25 | Toole | Montana | 30101 | 1233 | 23 |
2247405 | 2247405 | 2022-02-24 | Toole | Montana | 30101 | 1233 | 23 |
2244154 | 2244154 | 2022-02-23 | Toole | Montana | 30101 | 1233 | 23 |
2233741 | 2233741 | 2022-02-20 | Ballard | Kentucky | 21007 | 1233 | 27 |
2230490 | 2230490 | 2022-02-19 | Ballard | Kentucky | 21007 | 1233 | 27 |
2227239 | 2227239 | 2022-02-18 | Ballard | Kentucky | 21007 | 1233 | 27 |
2214970 | 2214970 | 2022-02-14 | Pierce | Nebraska | 31139 | 1233 | 21 |
2191682 | 2191682 | 2022-02-07 | Unknown | Maryland | 1233 | 216 | |
2193136 | 2193136 | 2022-02-07 | Crane | Texas | 48103 | 1233 | 21 |
2187890 | 2187890 | 2022-02-06 | Scott | Illinois | 17171 | 1233 | 11 |
2189882 | 2189882 | 2022-02-06 | Crane | Texas | 48103 | 1233 | 21 |
2184637 | 2184637 | 2022-02-05 | Scott | Illinois | 17171 | 1233 | 11 |
2186737 | 2186737 | 2022-02-05 | McCulloch | Texas | 48307 | 1233 | 42 |
2181385 | 2181385 | 2022-02-04 | Scott | Illinois | 17171 | 1233 | 11 |
2179929 | 2179929 | 2022-02-03 | Day | South Dakota | 46037 | 1233 | 32 |
2176925 | 2176925 | 2022-02-02 | Hartley | Texas | 48205 | 1233 | 3 |
2169514 | 2169514 | 2022-01-31 | Guadalupe | New Mexico | 35019 | 1233 | 16 |
2146266 | 2146266 | 2022-01-24 | Grant | Minnesota | 27051 | 1233 | 12 |
2137500 | 2137500 | 2022-01-21 | Ceiba | Puerto Rico | 72037 | 1233 | |
2123829 | 2123829 | 2022-01-17 | Dawes | Nebraska | 31045 | 1233 | 21 |
2113896 | 2113896 | 2022-01-14 | Carter | Missouri | 29035 | 1233 | 19 |
2107888 | 2107888 | 2022-01-12 | Bottineau | North Dakota | 38009 | 1233 | 24 |
2096658 | 2096658 | 2022-01-09 | Twiggs | Georgia | 13289 | 1233 | 62 |
2093406 | 2093406 | 2022-01-08 | Twiggs | Georgia | 13289 | 1233 | 62 |
2090154 | 2090154 | 2022-01-07 | Twiggs | Georgia | 13289 | 1233 | 62 |
2086903 | 2086903 | 2022-01-06 | Twiggs | Georgia | 13289 | 1233 | 62 |
2083651 | 2083651 | 2022-01-05 | Twiggs | Georgia | 13289 | 1233 | 62 |
2056875 | 2056875 | 2021-12-27 | Northampton | Virginia | 51131 | 1233 | 48 |
2038238 | 2038238 | 2021-12-22 | Edwards | Illinois | 17047 | 1233 | 21 |
2020352 | 2020352 | 2021-12-16 | Harney | Oregon | 41025 | 1233 | 33 |
2017859 | 2017859 | 2021-12-15 | Lunenburg | Virginia | 51111 | 1233 | 23 |
2012480 | 2012480 | 2021-12-14 | Pocahontas | Iowa | 19151 | 1233 | 25 |
2009229 | 2009229 | 2021-12-13 | Pocahontas | Iowa | 19151 | 1233 | 25 |
2005978 | 2005978 | 2021-12-12 | Pocahontas | Iowa | 19151 | 1233 | 25 |
2002727 | 2002727 | 2021-12-11 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1999477 | 1999477 | 2021-12-10 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1996226 | 1996226 | 2021-12-09 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1992975 | 1992975 | 2021-12-08 | Pocahontas | Iowa | 19151 | 1233 | 25 |
1991909 | 1991909 | 2021-12-07 | Williamsburg city | Virginia | 51830 | 1233 | 13 |
1984272 | 1984272 | 2021-12-05 | Camden | North Carolina | 37029 | 1233 | 8 |
1980678 | 1980678 | 2021-12-04 | Ozark | Missouri | 29153 | 1233 | 42 |
1981022 | 1981022 | 2021-12-04 | Camden | North Carolina | 37029 | 1233 | 8 |
1977772 | 1977772 | 2021-12-03 | Camden | North Carolina | 37029 | 1233 | 8 |
1972764 | 1972764 | 2021-12-02 | Newton | Arkansas | 5101 | 1233 | 40 |
1975304 | 1975304 | 2021-12-02 | Floyd | Texas | 48153 | 1233 | 40 |
1969249 | 1969249 | 2021-11-30 | Tucker | West Virginia | 54093 | 1233 | 31 |
1928185 | 1928185 | 2021-11-18 | Nicholas | Kentucky | 21181 | 1233 | 21 |
1915214 | 1915214 | 2021-11-14 | Wolfe | Kentucky | 21237 | 1233 | 12 |
1911964 | 1911964 | 2021-11-13 | Wolfe | Kentucky | 21237 | 1233 | 12 |
1908715 | 1908715 | 2021-11-12 | Wolfe | Kentucky | 21237 | 1233 | 12 |
1905290 | 1905290 | 2021-11-11 | Kingman | Kansas | 20095 | 1233 | 23 |
1902040 | 1902040 | 2021-11-10 | Kingman | Kansas | 20095 | 1233 | 23 |
1882087 | 1882087 | 2021-11-04 | Miller | Georgia | 13201 | 1233 | 22 |
1878910 | 1878910 | 2021-11-03 | Benewah | Idaho | 16009 | 1233 | 26 |
1880734 | 1880734 | 2021-11-03 | Orocovis | Puerto Rico | 72107 | 1233 | |
1876704 | 1876704 | 2021-11-02 | Sullivan | Missouri | 29211 | 1233 | 15 |
1874613 | 1874613 | 2021-11-01 | La Salle | Texas | 48283 | 1233 | 40 |
1852881 | 1852881 | 2021-10-26 | Terrell | Georgia | 13273 | 1233 | 56 |
1841986 | 1841986 | 2021-10-22 | Archer | Texas | 48009 | 1233 | 19 |
1838725 | 1838725 | 2021-10-21 | Van Buren | Tennessee | 47175 | 1233 | 27 |
1830140 | 1830140 | 2021-10-19 | Treutlen | Georgia | 13283 | 1233 | 47 |
1830902 | 1830902 | 2021-10-19 | Mackinac | Michigan | 26097 | 1233 | 7 |
1832527 | 1832527 | 2021-10-19 | Orange | Vermont | 50017 | 1233 | 5 |
1826891 | 1826891 | 2021-10-18 | Treutlen | Georgia | 13283 | 1233 | 47 |
1827653 | 1827653 | 2021-10-18 | Mackinac | Michigan | 26097 | 1233 | 7 |
1812171 | 1812171 | 2021-10-13 | Traill | North Dakota | 38097 | 1233 | 19 |
1808521 | 1808521 | 2021-10-12 | Powell | Montana | 30077 | 1233 | 14 |
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);