ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
179 rows where cases = 3037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 23
- Indiana 12
- Kentucky 12
- Virginia 12
- Texas 11
- Oklahoma 10
- Georgia 9
- Arkansas 7
- Iowa 7
- Florida 5
- Louisiana 5
- Ohio 5
- Wisconsin 5
- California 4
- Idaho 4
- Nebraska 4
- New York 4
- Alabama 3
- Maryland 3
- Michigan 3
- Minnesota 3
- Montana 3
- North Carolina 3
- Arizona 2
- Illinois 2
- New Mexico 2
- Puerto Rico 2
- Tennessee 2
- Utah 2
- Wyoming 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501933 | 2501933 | 2022-05-13 | Ciales | Puerto Rico | 72039 | 3037 | |
2495251 | 2495251 | 2022-05-11 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2491993 | 2491993 | 2022-05-10 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2488735 | 2488735 | 2022-05-09 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2485478 | 2485478 | 2022-05-08 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2482220 | 2482220 | 2022-05-07 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2478962 | 2478962 | 2022-05-06 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2473798 | 2473798 | 2022-05-05 | Moffat | Colorado | 8081 | 3037 | 52 |
2475704 | 2475704 | 2022-05-05 | Johnston | Oklahoma | 40069 | 3037 | 54 |
2402089 | 2402089 | 2022-04-13 | Mariposa | California | 6043 | 3037 | 34 |
2348034 | 2348034 | 2022-03-27 | Perry | Mississippi | 28111 | 3037 | 64 |
2344781 | 2344781 | 2022-03-26 | Perry | Mississippi | 28111 | 3037 | 64 |
2341528 | 2341528 | 2022-03-25 | Perry | Mississippi | 28111 | 3037 | 64 |
2338022 | 2338022 | 2022-03-24 | Kent | Maryland | 24029 | 3037 | 66 |
2338275 | 2338275 | 2022-03-24 | Perry | Mississippi | 28111 | 3037 | 64 |
2334768 | 2334768 | 2022-03-23 | Kent | Maryland | 24029 | 3037 | 66 |
2335021 | 2335021 | 2022-03-23 | Perry | Mississippi | 28111 | 3037 | 64 |
2331767 | 2331767 | 2022-03-22 | Perry | Mississippi | 28111 | 3037 | 64 |
2328515 | 2328515 | 2022-03-21 | Perry | Mississippi | 28111 | 3037 | 64 |
2325262 | 2325262 | 2022-03-20 | Perry | Mississippi | 28111 | 3037 | 64 |
2322008 | 2322008 | 2022-03-19 | Perry | Mississippi | 28111 | 3037 | 64 |
2318754 | 2318754 | 2022-03-18 | Perry | Mississippi | 28111 | 3037 | 64 |
2315501 | 2315501 | 2022-03-17 | Perry | Mississippi | 28111 | 3037 | 64 |
2312248 | 2312248 | 2022-03-16 | Perry | Mississippi | 28111 | 3037 | 64 |
2308995 | 2308995 | 2022-03-15 | Perry | Mississippi | 28111 | 3037 | 64 |
2305744 | 2305744 | 2022-03-14 | Perry | Mississippi | 28111 | 3037 | 64 |
2266585 | 2266585 | 2022-03-02 | Chippewa | Minnesota | 27023 | 3037 | 47 |
2238790 | 2238790 | 2022-02-21 | Nolan | Texas | 48353 | 3037 | 93 |
2234486 | 2234486 | 2022-02-20 | Seward | Nebraska | 31159 | 3037 | 41 |
2231235 | 2231235 | 2022-02-19 | Seward | Nebraska | 31159 | 3037 | 41 |
2227984 | 2227984 | 2022-02-18 | Seward | Nebraska | 31159 | 3037 | 41 |
2210409 | 2210409 | 2022-02-13 | Dade | Georgia | 13083 | 3037 | 28 |
2211635 | 2211635 | 2022-02-13 | Roosevelt | Montana | 30085 | 3037 | 70 |
2207156 | 2207156 | 2022-02-12 | Dade | Georgia | 13083 | 3037 | 28 |
2208382 | 2208382 | 2022-02-12 | Roosevelt | Montana | 30085 | 3037 | 70 |
2203903 | 2203903 | 2022-02-11 | Dade | Georgia | 13083 | 3037 | 28 |
2205129 | 2205129 | 2022-02-11 | Roosevelt | Montana | 30085 | 3037 | 70 |
2195204 | 2195204 | 2022-02-08 | Webster | Mississippi | 28155 | 3037 | 58 |
2165546 | 2165546 | 2022-01-30 | Trigg | Kentucky | 21221 | 3037 | 35 |
2162291 | 2162291 | 2022-01-29 | Trigg | Kentucky | 21221 | 3037 | 35 |
2159036 | 2159036 | 2022-01-28 | Trigg | Kentucky | 21221 | 3037 | 35 |
2132982 | 2132982 | 2022-01-20 | Monroe | Kentucky | 21171 | 3037 | 69 |
2103523 | 2103523 | 2022-01-11 | Wright | Iowa | 19197 | 3037 | 54 |
2100272 | 2100272 | 2022-01-10 | Wright | Iowa | 19197 | 3037 | 54 |
2102274 | 2102274 | 2022-01-10 | San Juan | Utah | 49037 | 3037 | 46 |
2097021 | 2097021 | 2022-01-09 | Wright | Iowa | 19197 | 3037 | 54 |
2093769 | 2093769 | 2022-01-08 | Wright | Iowa | 19197 | 3037 | 54 |
2090517 | 2090517 | 2022-01-07 | Wright | Iowa | 19197 | 3037 | 54 |
2087266 | 2087266 | 2022-01-06 | Wright | Iowa | 19197 | 3037 | 54 |
2084014 | 2084014 | 2022-01-05 | Wright | Iowa | 19197 | 3037 | 54 |
2078005 | 2078005 | 2022-01-03 | Redwood | Minnesota | 27127 | 3037 | 49 |
2062987 | 2062987 | 2021-12-29 | Andrews | Texas | 48003 | 3037 | 65 |
2059636 | 2059636 | 2021-12-28 | Union | South Dakota | 46127 | 3037 | 47 |
2051399 | 2051399 | 2021-12-26 | Vermillion | Indiana | 18165 | 3037 | 61 |
2048149 | 2048149 | 2021-12-25 | Vermillion | Indiana | 18165 | 3037 | 61 |
2044899 | 2044899 | 2021-12-24 | Vermillion | Indiana | 18165 | 3037 | 61 |
2041650 | 2041650 | 2021-12-23 | Vermillion | Indiana | 18165 | 3037 | 61 |
2038400 | 2038400 | 2021-12-22 | Vermillion | Indiana | 18165 | 3037 | 61 |
2030855 | 2030855 | 2021-12-19 | King George | Virginia | 51099 | 3037 | 25 |
2027604 | 2027604 | 2021-12-18 | King George | Virginia | 51099 | 3037 | 25 |
2024353 | 2024353 | 2021-12-17 | King George | Virginia | 51099 | 3037 | 25 |
2009422 | 2009422 | 2021-12-13 | Lawrence | Kentucky | 21127 | 3037 | 45 |
1962980 | 1962980 | 2021-11-29 | Cross | Arkansas | 5037 | 3037 | 66 |
1923199 | 1923199 | 2021-11-16 | Sequatchie | Tennessee | 47153 | 3037 | 33 |
1881564 | 1881564 | 2021-11-03 | Vernon | Wisconsin | 55123 | 3037 | 61 |
1872414 | 1872414 | 2021-11-01 | Blaine | Idaho | 16013 | 3037 | 27 |
1822197 | 1822197 | 2021-10-16 | Aguadilla | Puerto Rico | 72005 | 3037 | |
1823050 | 1823050 | 2021-10-16 | Langlade | Wisconsin | 55067 | 3037 | 54 |
1819801 | 1819801 | 2021-10-15 | Langlade | Wisconsin | 55067 | 3037 | 54 |
1816552 | 1816552 | 2021-10-14 | Langlade | Wisconsin | 55067 | 3037 | 54 |
1801796 | 1801796 | 2021-10-10 | Clay | Mississippi | 28025 | 3037 | 75 |
1798547 | 1798547 | 2021-10-09 | Clay | Mississippi | 28025 | 3037 | 75 |
1795298 | 1795298 | 2021-10-08 | Clay | Mississippi | 28025 | 3037 | 75 |
1791401 | 1791401 | 2021-10-07 | Starke | Indiana | 18149 | 3037 | 69 |
1791919 | 1791919 | 2021-10-07 | Menominee | Michigan | 26109 | 3037 | 48 |
1792880 | 1792880 | 2021-10-07 | Union | Oregon | 41061 | 3037 | 41 |
1788670 | 1788670 | 2021-10-06 | Menominee | Michigan | 26109 | 3037 | 48 |
1755285 | 1755285 | 2021-09-26 | Brantley | Georgia | 13025 | 3037 | 69 |
1752037 | 1752037 | 2021-09-25 | Brantley | Georgia | 13025 | 3037 | 69 |
1748788 | 1748788 | 2021-09-24 | Brantley | Georgia | 13025 | 3037 | 69 |
1745109 | 1745109 | 2021-09-22 | Waushara | Wisconsin | 55137 | 3037 | 44 |
1735156 | 1735156 | 2021-09-19 | Orange | Virginia | 51137 | 3037 | 45 |
1729008 | 1729008 | 2021-09-18 | Clark | Arkansas | 5019 | 3037 | 50 |
1731906 | 1731906 | 2021-09-18 | Orange | Virginia | 51137 | 3037 | 45 |
1728656 | 1728656 | 2021-09-17 | Orange | Virginia | 51137 | 3037 | 45 |
1715899 | 1715899 | 2021-09-14 | Butler | Alabama | 1013 | 3037 | 78 |
1718659 | 1718659 | 2021-09-14 | Lavaca | Texas | 48285 | 3037 | 86 |
1700431 | 1700431 | 2021-09-09 | Spencer | Indiana | 18147 | 3037 | 33 |
1698504 | 1698504 | 2021-09-08 | Holmes | Ohio | 39075 | 3037 | 103 |
1673007 | 1673007 | 2021-08-31 | Morgan | Tennessee | 47129 | 3037 | 41 |
1664989 | 1664989 | 2021-08-29 | Lincoln | Kentucky | 21137 | 3037 | 64 |
1661741 | 1661741 | 2021-08-28 | Lincoln | Kentucky | 21137 | 3037 | 64 |
1658493 | 1658493 | 2021-08-27 | Lincoln | Kentucky | 21137 | 3037 | 64 |
1642618 | 1642618 | 2021-08-22 | Grenada | Mississippi | 28043 | 3037 | 91 |
1639368 | 1639368 | 2021-08-21 | Grenada | Mississippi | 28043 | 3037 | 91 |
1636118 | 1636118 | 2021-08-20 | Grenada | Mississippi | 28043 | 3037 | 91 |
1599525 | 1599525 | 2021-08-09 | Cassia | Idaho | 16031 | 3037 | 28 |
1601078 | 1601078 | 2021-08-09 | Perry | Ohio | 39127 | 3037 | 50 |
1601637 | 1601637 | 2021-08-09 | Deaf Smith | Texas | 48117 | 3037 | 68 |
1598389 | 1598389 | 2021-08-08 | Deaf Smith | Texas | 48117 | 3037 | 68 |
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);