ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
279 rows where cases = 2019 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 23
- Missouri 20
- Indiana 19
- Georgia 17
- Illinois 15
- Mississippi 15
- Texas 13
- Arkansas 10
- Tennessee 10
- Louisiana 9
- Minnesota 9
- New Mexico 9
- Oklahoma 9
- Kentucky 8
- Pennsylvania 8
- Alabama 7
- Puerto Rico 7
- South Dakota 7
- Idaho 6
- Nebraska 6
- Virginia 5
- West Virginia 5
- Alaska 4
- California 4
- Colorado 4
- Ohio 4
- Oregon 4
- Iowa 3
- North Dakota 3
- Utah 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492955 | 2492955 | 2022-05-10 | Tucker | West Virginia | 54093 | 2019 | 38 |
2489697 | 2489697 | 2022-05-09 | Tucker | West Virginia | 54093 | 2019 | 38 |
2415689 | 2415689 | 2022-04-17 | Union | Indiana | 18161 | 2019 | 21 |
2412433 | 2412433 | 2022-04-16 | Union | Indiana | 18161 | 2019 | 21 |
2409177 | 2409177 | 2022-04-15 | Union | Indiana | 18161 | 2019 | 21 |
2405921 | 2405921 | 2022-04-14 | Union | Indiana | 18161 | 2019 | 21 |
2402666 | 2402666 | 2022-04-13 | Union | Indiana | 18161 | 2019 | 21 |
2399411 | 2399411 | 2022-04-12 | Union | Indiana | 18161 | 2019 | 21 |
2396156 | 2396156 | 2022-04-11 | Union | Indiana | 18161 | 2019 | 21 |
2392900 | 2392900 | 2022-04-10 | Union | Indiana | 18161 | 2019 | 21 |
2389644 | 2389644 | 2022-04-09 | Union | Indiana | 18161 | 2019 | 21 |
2386389 | 2386389 | 2022-04-08 | Union | Indiana | 18161 | 2019 | 21 |
2370777 | 2370777 | 2022-04-03 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2367524 | 2367524 | 2022-04-02 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2364271 | 2364271 | 2022-04-01 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2361017 | 2361017 | 2022-03-31 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2357763 | 2357763 | 2022-03-30 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2354510 | 2354510 | 2022-03-29 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2351258 | 2351258 | 2022-03-28 | Humphreys | Mississippi | 28053 | 2019 | 45 |
2348251 | 2348251 | 2022-03-27 | Cheyenne | Nebraska | 31033 | 2019 | 23 |
2344998 | 2344998 | 2022-03-26 | Cheyenne | Nebraska | 31033 | 2019 | 23 |
2341745 | 2341745 | 2022-03-25 | Cheyenne | Nebraska | 31033 | 2019 | 23 |
2338379 | 2338379 | 2022-03-24 | Oregon | Missouri | 29149 | 2019 | 33 |
2338492 | 2338492 | 2022-03-24 | Cheyenne | Nebraska | 31033 | 2019 | 23 |
2335125 | 2335125 | 2022-03-23 | Oregon | Missouri | 29149 | 2019 | 33 |
2335238 | 2335238 | 2022-03-23 | Cheyenne | Nebraska | 31033 | 2019 | 23 |
2331871 | 2331871 | 2022-03-22 | Oregon | Missouri | 29149 | 2019 | 33 |
2331984 | 2331984 | 2022-03-22 | Cheyenne | Nebraska | 31033 | 2019 | 23 |
2328618 | 2328618 | 2022-03-21 | Oregon | Missouri | 29149 | 2019 | 32 |
2310006 | 2310006 | 2022-03-15 | Custer | South Dakota | 46033 | 2019 | 23 |
2306753 | 2306753 | 2022-03-14 | Custer | South Dakota | 46033 | 2019 | 23 |
2302864 | 2302864 | 2022-03-13 | Sierra | New Mexico | 35051 | 2019 | 70 |
2299612 | 2299612 | 2022-03-12 | Sierra | New Mexico | 35051 | 2019 | 70 |
2296360 | 2296360 | 2022-03-11 | Sierra | New Mexico | 35051 | 2019 | 70 |
2293108 | 2293108 | 2022-03-10 | Sierra | New Mexico | 35051 | 2019 | 70 |
2278825 | 2278825 | 2022-03-06 | Boundary | Idaho | 16021 | 2019 | 57 |
2275572 | 2275572 | 2022-03-05 | Boundary | Idaho | 16021 | 2019 | 57 |
2272319 | 2272319 | 2022-03-04 | Boundary | Idaho | 16021 | 2019 | 57 |
2265739 | 2265739 | 2022-03-02 | Montgomery | Georgia | 13209 | 2019 | 49 |
2266611 | 2266611 | 2022-03-02 | Lake | Minnesota | 27075 | 2019 | 28 |
2261747 | 2261747 | 2022-02-28 | Madison | Virginia | 51113 | 2019 | 36 |
2243860 | 2243860 | 2022-02-23 | Marshall | Minnesota | 27089 | 2019 | 23 |
2217006 | 2217006 | 2022-02-15 | Terrell | Georgia | 13273 | 2019 | 60 |
2212468 | 2212468 | 2022-02-13 | Grant | South Dakota | 46051 | 2019 | 49 |
2209215 | 2209215 | 2022-02-12 | Grant | South Dakota | 46051 | 2019 | 49 |
2205962 | 2205962 | 2022-02-11 | Grant | South Dakota | 46051 | 2019 | 49 |
2190849 | 2190849 | 2022-02-07 | Atkinson | Georgia | 13003 | 2019 | 39 |
2191577 | 2191577 | 2022-02-07 | Wolfe | Kentucky | 21237 | 2019 | 18 |
2177344 | 2177344 | 2022-02-02 | Tyler | West Virginia | 54095 | 2019 | 27 |
2165068 | 2165068 | 2022-01-30 | Hamilton | Illinois | 17065 | 2019 | 30 |
2161813 | 2161813 | 2022-01-29 | Hamilton | Illinois | 17065 | 2019 | 30 |
2158558 | 2158558 | 2022-01-28 | Hamilton | Illinois | 17065 | 2019 | 30 |
2150349 | 2150349 | 2022-01-25 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2145492 | 2145492 | 2022-01-24 | Fremont | Idaho | 16043 | 2019 | 21 |
2146539 | 2146539 | 2022-01-24 | Deer Lodge | Montana | 30023 | 2019 | 29 |
2147097 | 2147097 | 2022-01-24 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2143488 | 2143488 | 2022-01-23 | Los Alamos | New Mexico | 35028 | 2019 | 12 |
2143843 | 2143843 | 2022-01-23 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2140233 | 2140233 | 2022-01-22 | Los Alamos | New Mexico | 35028 | 2019 | 12 |
2140588 | 2140588 | 2022-01-22 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2136977 | 2136977 | 2022-01-21 | Los Alamos | New Mexico | 35028 | 2019 | 12 |
2137332 | 2137332 | 2022-01-21 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2134078 | 2134078 | 2022-01-20 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2130179 | 2130179 | 2022-01-19 | Grundy | Missouri | 29079 | 2019 | 61 |
2130826 | 2130826 | 2022-01-19 | Hughes | Oklahoma | 40063 | 2019 | 49 |
2125393 | 2125393 | 2022-01-18 | Bullock | Alabama | 1011 | 2019 | 46 |
2111508 | 2111508 | 2022-01-13 | Luquillo | Puerto Rico | 72089 | 2019 | |
2099440 | 2099440 | 2022-01-10 | Wilcox | Alabama | 1131 | 2019 | 38 |
2096215 | 2096215 | 2022-01-09 | Valdez-Cordova Census Area | Alaska | 2261 | 2019 | 12 |
2092963 | 2092963 | 2022-01-08 | Valdez-Cordova Census Area | Alaska | 2261 | 2019 | 12 |
2089711 | 2089711 | 2022-01-07 | Valdez-Cordova Census Area | Alaska | 2261 | 2019 | 12 |
2080577 | 2080577 | 2022-01-04 | Brown | Indiana | 18013 | 2019 | 52 |
2065972 | 2065972 | 2021-12-30 | Guayama | Puerto Rico | 72057 | 2019 | |
2050791 | 2050791 | 2021-12-26 | Stone | Arkansas | 5137 | 2019 | 47 |
2041111 | 2041111 | 2021-12-23 | Archuleta | Colorado | 8007 | 2019 | 9 |
2020494 | 2020494 | 2021-12-16 | Morovis | Puerto Rico | 72101 | 2019 | |
2009023 | 2009023 | 2021-12-13 | Menard | Illinois | 17129 | 2019 | 19 |
1948603 | 1948603 | 2021-11-24 | Barnes | North Dakota | 38003 | 2019 | 38 |
1945188 | 1945188 | 2021-11-23 | Socorro | New Mexico | 35053 | 2019 | 64 |
1945828 | 1945828 | 2021-11-23 | Dewey | South Dakota | 46041 | 2019 | 32 |
1946249 | 1946249 | 2021-11-23 | Unknown | Utah | 2019 | 41 | |
1926836 | 1926836 | 2021-11-17 | King William | Virginia | 51101 | 2019 | 24 |
1917299 | 1917299 | 2021-11-14 | Price | Wisconsin | 55099 | 2019 | 13 |
1914049 | 1914049 | 2021-11-13 | Price | Wisconsin | 55099 | 2019 | 13 |
1910799 | 1910799 | 2021-11-12 | Price | Wisconsin | 55099 | 2019 | 13 |
1905481 | 1905481 | 2021-11-11 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1902231 | 1902231 | 2021-11-10 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1898981 | 1898981 | 2021-11-09 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1895731 | 1895731 | 2021-11-08 | Claiborne | Louisiana | 22027 | 2019 | 64 |
1896839 | 1896839 | 2021-11-08 | Hood River | Oregon | 41027 | 2019 | 37 |
1892055 | 1892055 | 2021-11-07 | Blackford | Indiana | 18009 | 2019 | 45 |
1888805 | 1888805 | 2021-11-06 | Blackford | Indiana | 18009 | 2019 | 45 |
1885555 | 1885555 | 2021-11-05 | Blackford | Indiana | 18009 | 2019 | 45 |
1869945 | 1869945 | 2021-10-31 | Cottonwood | Minnesota | 27033 | 2019 | 29 |
1866696 | 1866696 | 2021-10-30 | Cottonwood | Minnesota | 27033 | 2019 | 29 |
1863447 | 1863447 | 2021-10-29 | Cottonwood | Minnesota | 27033 | 2019 | 29 |
1862081 | 1862081 | 2021-10-28 | Big Horn | Wyoming | 56003 | 2019 | 53 |
1854932 | 1854932 | 2021-10-26 | Lake | Tennessee | 47095 | 2019 | 31 |
1832939 | 1832939 | 2021-10-20 | Kusilvak Census Area | Alaska | 2158 | 2019 | 8 |
1792039 | 1792039 | 2021-10-07 | Amite | Mississippi | 28005 | 2019 | 52 |
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);