ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
70 rows where cases = 7040 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 27
- Iowa 14
- Florida 13
- Minnesota 5
- Alabama 3
- Pennsylvania 3
- Texas 3
- Virginia 3
- Wyoming 3
- Indiana 2
- Kansas 2
- Mississippi 2
- Tennessee 2
- Arkansas 1
- California 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Montana 1
- New Jersey 1
- New Mexico 1
- New York 1
- North Carolina 1
- Utah 1
- Washington 1
- West Virginia 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2496221 | 2496221 | 2022-05-11 | Wyoming | West Virginia | 54109 | 7040 | 116 |
2445548 | 2445548 | 2022-04-26 | Cass | Minnesota | 27021 | 7040 | 80 |
2397028 | 2397028 | 2022-04-11 | Ravalli | Montana | 30081 | 7040 | 141 |
2393486 | 2393486 | 2022-04-10 | Lyon | Minnesota | 27083 | 7040 | 72 |
2390230 | 2390230 | 2022-04-09 | Lyon | Minnesota | 27083 | 7040 | 72 |
2386974 | 2386974 | 2022-04-08 | Lyon | Minnesota | 27083 | 7040 | 72 |
2383719 | 2383719 | 2022-04-07 | Lyon | Minnesota | 27083 | 7040 | 72 |
2268677 | 2268677 | 2022-03-03 | St. Francis | Arkansas | 5123 | 7040 | 85 |
2260669 | 2260669 | 2022-02-28 | Cherokee | North Carolina | 37039 | 7040 | 110 |
2217403 | 2217403 | 2022-02-15 | Ellis | Kansas | 20051 | 7040 | 79 |
2217911 | 2217911 | 2022-02-15 | Copiah | Mississippi | 28029 | 7040 | 108 |
2214152 | 2214152 | 2022-02-14 | Ellis | Kansas | 20051 | 7040 | 79 |
2215968 | 2215968 | 2022-02-14 | Hopkins | Texas | 48223 | 7040 | 166 |
2202895 | 2202895 | 2022-02-10 | Cooke | Texas | 48097 | 7040 | 123 |
2149017 | 2149017 | 2022-01-25 | Lee | Iowa | 19111 | 7040 | 117 |
2145765 | 2145765 | 2022-01-24 | Lee | Iowa | 19111 | 7040 | 117 |
2142510 | 2142510 | 2022-01-23 | Lee | Iowa | 19111 | 7040 | 117 |
2139255 | 2139255 | 2022-01-22 | Lee | Iowa | 19111 | 7040 | 117 |
2141217 | 2141217 | 2022-01-22 | Polk | Texas | 48373 | 7040 | 225 |
2135999 | 2135999 | 2022-01-21 | Lee | Iowa | 19111 | 7040 | 117 |
2132747 | 2132747 | 2022-01-20 | Lee | Iowa | 19111 | 7040 | 117 |
2129494 | 2129494 | 2022-01-19 | Lee | Iowa | 19111 | 7040 | 117 |
1963210 | 1963210 | 2021-11-29 | Levy | Florida | 12075 | 7040 | 94 |
1959959 | 1959959 | 2021-11-28 | Levy | Florida | 12075 | 7040 | 94 |
1956708 | 1956708 | 2021-11-27 | Levy | Florida | 12075 | 7040 | 94 |
1953457 | 1953457 | 2021-11-26 | Levy | Florida | 12075 | 7040 | 94 |
1950206 | 1950206 | 2021-11-25 | Levy | Florida | 12075 | 7040 | 94 |
1946955 | 1946955 | 2021-11-24 | Levy | Florida | 12075 | 7040 | 94 |
1943704 | 1943704 | 2021-11-23 | Levy | Florida | 12075 | 7040 | 94 |
1944170 | 1944170 | 2021-11-23 | Des Moines | Iowa | 19057 | 7040 | 101 |
1940454 | 1940454 | 2021-11-22 | Levy | Florida | 12075 | 7040 | 94 |
1940920 | 1940920 | 2021-11-22 | Des Moines | Iowa | 19057 | 7040 | 101 |
1937204 | 1937204 | 2021-11-21 | Levy | Florida | 12075 | 7040 | 94 |
1937670 | 1937670 | 2021-11-21 | Des Moines | Iowa | 19057 | 7040 | 101 |
1933954 | 1933954 | 2021-11-20 | Levy | Florida | 12075 | 7040 | 94 |
1934420 | 1934420 | 2021-11-20 | Des Moines | Iowa | 19057 | 7040 | 101 |
1930702 | 1930702 | 2021-11-19 | Levy | Florida | 12075 | 7040 | 89 |
1931169 | 1931169 | 2021-11-19 | Des Moines | Iowa | 19057 | 7040 | 101 |
1927918 | 1927918 | 2021-11-18 | Des Moines | Iowa | 19057 | 7040 | 101 |
1924668 | 1924668 | 2021-11-17 | Des Moines | Iowa | 19057 | 7040 | 101 |
1919945 | 1919945 | 2021-11-15 | Rhea | Tennessee | 47143 | 7040 | 94 |
1881338 | 1881338 | 2021-11-03 | James City | Virginia | 51095 | 7040 | 94 |
1783927 | 1783927 | 2021-10-04 | Washington | Virginia | 51191 | 7040 | 133 |
1735367 | 1735367 | 2021-09-19 | Campbell | Wyoming | 56005 | 7040 | 74 |
1732117 | 1732117 | 2021-09-18 | Campbell | Wyoming | 56005 | 7040 | 74 |
1728867 | 1728867 | 2021-09-17 | Campbell | Wyoming | 56005 | 7040 | 74 |
1657063 | 1657063 | 2021-08-26 | Iron | Utah | 49021 | 7040 | 39 |
1626833 | 1626833 | 2021-08-17 | Sullivan | New York | 36105 | 7040 | 76 |
1587123 | 1587123 | 2021-08-05 | St. Charles | Louisiana | 22089 | 7040 | 101 |
1562515 | 1562515 | 2021-07-28 | Cumberland | Tennessee | 47035 | 7040 | 143 |
1532565 | 1532565 | 2021-07-19 | Eddy | New Mexico | 35015 | 7040 | 141 |
1472339 | 1472339 | 2021-07-01 | Jackson | Alabama | 1071 | 7040 | 114 |
1469094 | 1469094 | 2021-06-30 | Jackson | Alabama | 1071 | 7040 | 114 |
1424824 | 1424824 | 2021-06-16 | Allegany | Maryland | 24001 | 7040 | 212 |
1329853 | 1329853 | 2021-05-18 | Monroe | Florida | 12087 | 7040 | 49 |
1234385 | 1234385 | 2021-04-18 | Lawrence | Pennsylvania | 42073 | 7040 | 200 |
1164610 | 1164610 | 2021-03-28 | Grant | Indiana | 18053 | 7040 | 172 |
1160696 | 1160696 | 2021-03-27 | Walker | Alabama | 1127 | 7040 | 274 |
1147395 | 1147395 | 2021-03-22 | Lynchburg city | Virginia | 51680 | 7040 | 144 |
1108639 | 1108639 | 2021-03-10 | Portage | Wisconsin | 55097 | 7040 | 67 |
1089998 | 1089998 | 2021-03-05 | Wayne | Indiana | 18177 | 7040 | 195 |
1051691 | 1051691 | 2021-02-21 | Forrest | Mississippi | 28035 | 7040 | 135 |
931401 | 931401 | 2021-01-15 | Barnstable | Massachusetts | 25001 | 7040 | 291 |
927142 | 927142 | 2021-01-14 | Napa | California | 6055 | 7040 | 38 |
595001 | 595001 | 2020-10-03 | Chester | Pennsylvania | 42029 | 7040 | 369 |
591760 | 591760 | 2020-10-02 | Chester | Pennsylvania | 42029 | 7040 | 369 |
470066 | 470066 | 2020-08-26 | Brevard | Florida | 12009 | 7040 | 200 |
390205 | 390205 | 2020-08-01 | Jefferson | Kentucky | 21111 | 7040 | 248 |
277490 | 277490 | 2020-06-26 | Yakima | Washington | 53077 | 7040 | 150 |
244954 | 244954 | 2020-06-16 | Camden | New Jersey | 34007 | 7040 | 417 |
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);