ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
191 rows where cases = 3247 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 19
- Georgia 13
- Illinois 11
- Louisiana 11
- Wisconsin 11
- Kentucky 9
- Arkansas 8
- California 7
- North Dakota 7
- South Dakota 7
- Indiana 6
- Missouri 6
- Virginia 6
- Alabama 5
- Idaho 5
- Michigan 5
- Minnesota 5
- North Carolina 5
- Texas 5
- Florida 4
- Tennessee 4
- West Virginia 4
- Alaska 3
- Utah 3
- Washington 3
- Colorado 2
- Nebraska 2
- Oklahoma 2
- Oregon 2
- Pennsylvania 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2429969 | 2429969 | 2022-04-21 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2426713 | 2426713 | 2022-04-20 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2423457 | 2423457 | 2022-04-19 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2420200 | 2420200 | 2022-04-18 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2416945 | 2416945 | 2022-04-17 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2413689 | 2413689 | 2022-04-16 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2410433 | 2410433 | 2022-04-15 | Mountrail | North Dakota | 38061 | 3247 | 37 |
2402099 | 2402099 | 2022-04-13 | Plumas | California | 6063 | 3247 | 13 |
2398844 | 2398844 | 2022-04-12 | Plumas | California | 6063 | 3247 | 13 |
2395589 | 2395589 | 2022-04-11 | Plumas | California | 6063 | 3247 | 13 |
2396790 | 2396790 | 2022-04-11 | Amite | Mississippi | 28005 | 3247 | 69 |
2392333 | 2392333 | 2022-04-10 | Plumas | California | 6063 | 3247 | 14 |
2393535 | 2393535 | 2022-04-10 | Amite | Mississippi | 28005 | 3247 | 69 |
2389077 | 2389077 | 2022-04-09 | Plumas | California | 6063 | 3247 | 14 |
2390279 | 2390279 | 2022-04-09 | Amite | Mississippi | 28005 | 3247 | 69 |
2385822 | 2385822 | 2022-04-08 | Plumas | California | 6063 | 3247 | 14 |
2387023 | 2387023 | 2022-04-08 | Amite | Mississippi | 28005 | 3247 | 69 |
2383768 | 2383768 | 2022-04-07 | Amite | Mississippi | 28005 | 3247 | 69 |
2380513 | 2380513 | 2022-04-06 | Amite | Mississippi | 28005 | 3247 | 69 |
2377258 | 2377258 | 2022-04-05 | Amite | Mississippi | 28005 | 3247 | 69 |
2379049 | 2379049 | 2022-04-05 | Price | Wisconsin | 55099 | 3247 | 33 |
2374006 | 2374006 | 2022-04-04 | Amite | Mississippi | 28005 | 3247 | 69 |
2375795 | 2375795 | 2022-04-04 | Price | Wisconsin | 55099 | 3247 | 33 |
2372543 | 2372543 | 2022-04-03 | Price | Wisconsin | 55099 | 3247 | 33 |
2369290 | 2369290 | 2022-04-02 | Price | Wisconsin | 55099 | 3247 | 33 |
2366037 | 2366037 | 2022-04-01 | Price | Wisconsin | 55099 | 3247 | 33 |
2362784 | 2362784 | 2022-03-31 | Price | Wisconsin | 55099 | 3247 | 33 |
2359530 | 2359530 | 2022-03-30 | Price | Wisconsin | 55099 | 3247 | 33 |
2356276 | 2356276 | 2022-03-29 | Price | Wisconsin | 55099 | 3247 | 33 |
2353023 | 2353023 | 2022-03-28 | Price | Wisconsin | 55099 | 3247 | 33 |
2325322 | 2325322 | 2022-03-20 | Dent | Missouri | 29065 | 3247 | 79 |
2322068 | 2322068 | 2022-03-19 | Dent | Missouri | 29065 | 3247 | 79 |
2318814 | 2318814 | 2022-03-18 | Dent | Missouri | 29065 | 3247 | 79 |
2304424 | 2304424 | 2022-03-14 | Little River | Arkansas | 5081 | 3247 | 92 |
2294423 | 2294423 | 2022-03-10 | Ashland | Wisconsin | 55003 | 3247 | 36 |
2263961 | 2263961 | 2022-03-01 | Mitchell | North Carolina | 37121 | 3247 | 33 |
2261638 | 2261638 | 2022-02-28 | Millard | Utah | 49027 | 3247 | 35 |
2243643 | 2243643 | 2022-02-23 | Madison | Louisiana | 22065 | 3247 | 58 |
2233871 | 2233871 | 2022-02-20 | Claiborne | Louisiana | 22027 | 3247 | 72 |
2230620 | 2230620 | 2022-02-19 | Claiborne | Louisiana | 22027 | 3247 | 72 |
2227369 | 2227369 | 2022-02-18 | Claiborne | Louisiana | 22027 | 3247 | 72 |
2216275 | 2216275 | 2022-02-14 | Southampton | Virginia | 51175 | 3247 | 80 |
2164518 | 2164518 | 2022-01-30 | Northwest Arctic Borough | Alaska | 2188 | 3247 | 11 |
2161263 | 2161263 | 2022-01-29 | Northwest Arctic Borough | Alaska | 2188 | 3247 | 11 |
2158007 | 2158007 | 2022-01-28 | Northwest Arctic Borough | Alaska | 2188 | 3247 | 11 |
2125859 | 2125859 | 2022-01-18 | Jefferson | Georgia | 13163 | 3247 | 97 |
2128332 | 2128332 | 2022-01-18 | Bristol city | Virginia | 51520 | 3247 | 59 |
2100803 | 2100803 | 2022-01-10 | Clarke | Mississippi | 28023 | 3247 | 96 |
2097194 | 2097194 | 2022-01-09 | Lewis | Kentucky | 21135 | 3247 | 70 |
2097214 | 2097214 | 2022-01-09 | Morgan | Kentucky | 21175 | 3247 | 17 |
2098933 | 2098933 | 2022-01-09 | Panola | Texas | 48365 | 3247 | 113 |
2093942 | 2093942 | 2022-01-08 | Lewis | Kentucky | 21135 | 3247 | 70 |
2093962 | 2093962 | 2022-01-08 | Morgan | Kentucky | 21175 | 3247 | 17 |
2090690 | 2090690 | 2022-01-07 | Lewis | Kentucky | 21135 | 3247 | 70 |
2090710 | 2090710 | 2022-01-07 | Morgan | Kentucky | 21175 | 3247 | 17 |
2081447 | 2081447 | 2022-01-04 | Pike | Missouri | 29163 | 3247 | 54 |
2051906 | 2051906 | 2021-12-26 | Manistee | Michigan | 26101 | 3247 | 58 |
2047394 | 2047394 | 2021-12-25 | Hale | Alabama | 1065 | 3247 | 91 |
2048656 | 2048656 | 2021-12-25 | Manistee | Michigan | 26101 | 3247 | 58 |
2045406 | 2045406 | 2021-12-24 | Manistee | Michigan | 26101 | 3247 | 58 |
2042156 | 2042156 | 2021-12-23 | Manistee | Michigan | 26101 | 3247 | 58 |
2038907 | 2038907 | 2021-12-22 | Manistee | Michigan | 26101 | 3247 | 58 |
2031290 | 2031290 | 2021-12-20 | Sharp | Arkansas | 5135 | 3247 | 76 |
2020115 | 2020115 | 2021-12-16 | Yancey | North Carolina | 37199 | 3247 | 36 |
2012172 | 2012172 | 2021-12-14 | Blaine | Idaho | 16013 | 3247 | 27 |
1972767 | 1972767 | 2021-12-02 | Phillips | Arkansas | 5107 | 3247 | 78 |
1975723 | 1975723 | 2021-12-02 | Lincoln | West Virginia | 54043 | 3247 | 52 |
1968855 | 1968855 | 2021-11-30 | Jones | Texas | 48253 | 3247 | 77 |
1963549 | 1963549 | 2021-11-29 | Wayne | Illinois | 17191 | 3247 | 66 |
1965451 | 1965451 | 2021-11-29 | Polk | Tennessee | 47139 | 3247 | 33 |
1946901 | 1946901 | 2021-11-24 | Teller | Colorado | 8119 | 3247 | 41 |
1937981 | 1937981 | 2021-11-21 | Concordia | Louisiana | 22029 | 3247 | 79 |
1934731 | 1934731 | 2021-11-20 | Concordia | Louisiana | 22029 | 3247 | 79 |
1931480 | 1931480 | 2021-11-19 | Concordia | Louisiana | 22029 | 3247 | 79 |
1929329 | 1929329 | 2021-11-18 | Crook | Oregon | 41013 | 3247 | 54 |
1878747 | 1878747 | 2021-11-03 | Ben Hill | Georgia | 13017 | 3247 | 101 |
1874848 | 1874848 | 2021-11-01 | Louisa | Virginia | 51109 | 3247 | 48 |
1866567 | 1866567 | 2021-10-30 | Garrett | Maryland | 24023 | 3247 | 79 |
1859296 | 1859296 | 2021-10-28 | Elbert | Georgia | 13105 | 3247 | 86 |
1823734 | 1823734 | 2021-10-17 | Douglas | Illinois | 17041 | 3247 | 43 |
1819869 | 1819869 | 2021-10-16 | Butler | Alabama | 1013 | 3247 | 94 |
1820485 | 1820485 | 2021-10-16 | Douglas | Illinois | 17041 | 3247 | 43 |
1816669 | 1816669 | 2021-10-15 | Randolph | Alabama | 1111 | 3247 | 63 |
1817236 | 1817236 | 2021-10-15 | Douglas | Illinois | 17041 | 3247 | 43 |
1813860 | 1813860 | 2021-10-14 | Morgan | Georgia | 13211 | 3247 | 40 |
1801814 | 1801814 | 2021-10-10 | Jasper | Mississippi | 28061 | 3247 | 64 |
1798565 | 1798565 | 2021-10-09 | Jasper | Mississippi | 28061 | 3247 | 64 |
1795316 | 1795316 | 2021-10-08 | Jasper | Mississippi | 28061 | 3247 | 64 |
1793753 | 1793753 | 2021-10-07 | Nicholas | West Virginia | 54067 | 3247 | 38 |
1788375 | 1788375 | 2021-10-06 | Adair | Kentucky | 21001 | 3247 | 74 |
1765404 | 1765404 | 2021-09-29 | Spencer | Indiana | 18147 | 3247 | 37 |
1745180 | 1745180 | 2021-09-23 | Marengo | Alabama | 1091 | 3247 | 83 |
1744460 | 1744460 | 2021-09-22 | Johnson | Tennessee | 47091 | 3247 | 44 |
1709799 | 1709799 | 2021-09-12 | Berrien | Georgia | 13019 | 3247 | 54 |
1706552 | 1706552 | 2021-09-11 | Berrien | Georgia | 13019 | 3247 | 54 |
1703304 | 1703304 | 2021-09-10 | Berrien | Georgia | 13019 | 3247 | 54 |
1691433 | 1691433 | 2021-09-06 | Crawford | Missouri | 29055 | 3247 | 45 |
1677951 | 1677951 | 2021-09-02 | Grant | Kentucky | 21081 | 3247 | 27 |
1680037 | 1680037 | 2021-09-02 | Mingo | West Virginia | 54059 | 3247 | 46 |
1645608 | 1645608 | 2021-08-23 | Union | Louisiana | 22111 | 3247 | 89 |
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);