ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
51 rows where cases = 9162 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 19
- Georgia 10
- Iowa 8
- Washington 5
- Kentucky 4
- Virginia 4
- Kansas 2
- Mississippi 2
- New Hampshire 2
- New York 2
- Pennsylvania 2
- Texas 2
- Alabama 1
- California 1
- Florida 1
- Guam 1
- Louisiana 1
- Massachusetts 1
- Puerto Rico 1
- Wisconsin 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2467404 | 2467404 | 2022-05-03 | Bryan | Georgia | 13029 | 9162 | 91 |
2464149 | 2464149 | 2022-05-02 | Bryan | Georgia | 13029 | 9162 | 91 |
2460893 | 2460893 | 2022-05-01 | Bryan | Georgia | 13029 | 9162 | 91 |
2457637 | 2457637 | 2022-04-30 | Bryan | Georgia | 13029 | 9162 | 91 |
2454381 | 2454381 | 2022-04-29 | Bryan | Georgia | 13029 | 9162 | 91 |
2451125 | 2451125 | 2022-04-28 | Bryan | Georgia | 13029 | 9162 | 91 |
2447869 | 2447869 | 2022-04-27 | Bryan | Georgia | 13029 | 9162 | 91 |
2332089 | 2332089 | 2022-03-22 | Sullivan | New Hampshire | 33019 | 9162 | 67 |
2328828 | 2328828 | 2022-03-21 | Carroll | New Hampshire | 33003 | 9162 | 56 |
2276860 | 2276860 | 2022-03-05 | Chenango | New York | 36017 | 9162 | 117 |
2239086 | 2239086 | 2022-02-21 | Whitman | Washington | 53075 | 9162 | 88 |
2235835 | 2235835 | 2022-02-20 | Whitman | Washington | 53075 | 9162 | 88 |
2232584 | 2232584 | 2022-02-19 | Whitman | Washington | 53075 | 9162 | 88 |
2229333 | 2229333 | 2022-02-18 | Whitman | Washington | 53075 | 9162 | 88 |
2226082 | 2226082 | 2022-02-17 | Whitman | Washington | 53075 | 9162 | 88 |
2194577 | 2194577 | 2022-02-08 | Muscatine | Iowa | 19139 | 9162 | 128 |
2191323 | 2191323 | 2022-02-07 | Muscatine | Iowa | 19139 | 9162 | 128 |
2188070 | 2188070 | 2022-02-06 | Muscatine | Iowa | 19139 | 9162 | 128 |
2184817 | 2184817 | 2022-02-05 | Muscatine | Iowa | 19139 | 9162 | 128 |
2181565 | 2181565 | 2022-02-04 | Muscatine | Iowa | 19139 | 9162 | 128 |
2178314 | 2178314 | 2022-02-03 | Muscatine | Iowa | 19139 | 9162 | 128 |
2175061 | 2175061 | 2022-02-02 | Muscatine | Iowa | 19139 | 9162 | 128 |
2147317 | 2147317 | 2022-01-24 | Trujillo Alto | Puerto Rico | 72139 | 9162 | |
2053541 | 2053541 | 2021-12-26 | Albemarle | Virginia | 51003 | 9162 | 115 |
2050291 | 2050291 | 2021-12-25 | Albemarle | Virginia | 51003 | 9162 | 115 |
2047041 | 2047041 | 2021-12-24 | Albemarle | Virginia | 51003 | 9162 | 115 |
2006161 | 2006161 | 2021-12-12 | Hopkins | Kentucky | 21107 | 9162 | 219 |
2002910 | 2002910 | 2021-12-11 | Hopkins | Kentucky | 21107 | 9162 | 219 |
1999660 | 1999660 | 2021-12-10 | Hopkins | Kentucky | 21107 | 9162 | 219 |
1762848 | 1762848 | 2021-09-28 | Pearl River | Mississippi | 28109 | 9162 | 226 |
1677857 | 1677857 | 2021-09-02 | Leavenworth | Kansas | 20103 | 9162 | 108 |
1674610 | 1674610 | 2021-09-01 | Leavenworth | Kansas | 20103 | 9162 | 108 |
1659704 | 1659704 | 2021-08-27 | Clearfield | Pennsylvania | 42033 | 9162 | 164 |
1613800 | 1613800 | 2021-08-13 | Chautauqua | New York | 36013 | 9162 | 147 |
1582085 | 1582085 | 2021-08-03 | Angelina | Texas | 48005 | 9162 | 289 |
1578836 | 1578836 | 2021-08-02 | Angelina | Texas | 48005 | 9162 | 289 |
1447511 | 1447511 | 2021-06-23 | St. Landry | Louisiana | 22097 | 9162 | 261 |
1444331 | 1444331 | 2021-06-22 | Hampshire | Massachusetts | 25015 | 9162 | 300 |
1381980 | 1381980 | 2021-06-03 | Unknown | Guam | 9162 | 140 | |
1263620 | 1263620 | 2021-04-27 | Northumberland | Pennsylvania | 42097 | 9162 | 345 |
1244833 | 1244833 | 2021-04-21 | Montgomery | Virginia | 51121 | 9162 | 89 |
1239652 | 1239652 | 2021-04-20 | Madison | Kentucky | 21151 | 9162 | 109 |
1189897 | 1189897 | 2021-04-05 | Lauderdale | Alabama | 1077 | 9162 | 227 |
1180050 | 1180050 | 2021-04-01 | Jefferson | Wisconsin | 55055 | 9162 | 125 |
1050755 | 1050755 | 2021-02-21 | Newton | Georgia | 13217 | 9162 | 191 |
1009527 | 1009527 | 2021-02-08 | Madison | Mississippi | 28089 | 9162 | 186 |
1002455 | 1002455 | 2021-02-06 | Story | Iowa | 19169 | 9162 | 43 |
732621 | 732621 | 2020-11-15 | Cherokee | Georgia | 13057 | 9162 | 112 |
638544 | 638544 | 2020-10-17 | Chatham | Georgia | 13051 | 9162 | 181 |
570414 | 570414 | 2020-09-26 | Pasco | Florida | 12101 | 9162 | 208 |
373272 | 373272 | 2020-07-27 | Imperial | California | 6025 | 9162 | 180 |
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);