ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
221 rows where cases = 2517 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 21
- Kentucky 19
- Missouri 16
- Virginia 15
- Indiana 13
- Mississippi 13
- Nebraska 12
- Louisiana 10
- Iowa 9
- Puerto Rico 9
- Kansas 8
- Illinois 7
- Alabama 6
- Arkansas 5
- Idaho 5
- North Carolina 5
- Ohio 5
- Wisconsin 5
- Georgia 4
- Montana 4
- South Carolina 4
- Florida 3
- Minnesota 3
- Tennessee 3
- Colorado 2
- New Hampshire 2
- New York 2
- North Dakota 2
- Washington 2
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490633 | 2490633 | 2022-05-10 | Franklin | Iowa | 19069 | 2517 | 42 |
2487376 | 2487376 | 2022-05-09 | Franklin | Iowa | 19069 | 2517 | 42 |
2484118 | 2484118 | 2022-05-08 | Franklin | Iowa | 19069 | 2517 | 42 |
2486243 | 2486243 | 2022-05-08 | Charlotte | Virginia | 51037 | 2517 | 45 |
2480860 | 2480860 | 2022-05-07 | Franklin | Iowa | 19069 | 2517 | 42 |
2482985 | 2482985 | 2022-05-07 | Charlotte | Virginia | 51037 | 2517 | 45 |
2477602 | 2477602 | 2022-05-06 | Franklin | Iowa | 19069 | 2517 | 42 |
2479727 | 2479727 | 2022-05-06 | Charlotte | Virginia | 51037 | 2517 | 45 |
2474344 | 2474344 | 2022-05-05 | Franklin | Iowa | 19069 | 2517 | 42 |
2471087 | 2471087 | 2022-05-04 | Franklin | Iowa | 19069 | 2517 | 42 |
2469955 | 2469955 | 2022-05-03 | Charlotte | Virginia | 51037 | 2517 | 46 |
2393237 | 2393237 | 2022-04-10 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2389981 | 2389981 | 2022-04-09 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2386725 | 2386725 | 2022-04-08 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2383470 | 2383470 | 2022-04-07 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2380215 | 2380215 | 2022-04-06 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2381451 | 2381451 | 2022-04-06 | Ciales | Puerto Rico | 72039 | 2517 | |
2376960 | 2376960 | 2022-04-05 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2378196 | 2378196 | 2022-04-05 | Ciales | Puerto Rico | 72039 | 2517 | |
2373708 | 2373708 | 2022-04-04 | Wolfe | Kentucky | 21237 | 2517 | 22 |
2374942 | 2374942 | 2022-04-04 | Ciales | Puerto Rico | 72039 | 2517 | |
2359825 | 2359825 | 2022-03-31 | Bent | Colorado | 8011 | 2517 | 47 |
2313421 | 2313421 | 2022-03-16 | Blanco | Texas | 48031 | 2517 | 34 |
2310168 | 2310168 | 2022-03-15 | Blanco | Texas | 48031 | 2517 | 34 |
2302648 | 2302648 | 2022-03-13 | Deer Lodge | Montana | 30023 | 2517 | 28 |
2299396 | 2299396 | 2022-03-12 | Deer Lodge | Montana | 30023 | 2517 | 28 |
2296144 | 2296144 | 2022-03-11 | Deer Lodge | Montana | 30023 | 2517 | 28 |
2256525 | 2256525 | 2022-02-27 | Edmonson | Kentucky | 21061 | 2517 | 38 |
2253274 | 2253274 | 2022-02-26 | Edmonson | Kentucky | 21061 | 2517 | 38 |
2250023 | 2250023 | 2022-02-25 | Edmonson | Kentucky | 21061 | 2517 | 38 |
2166123 | 2166123 | 2022-01-30 | Colfax | Nebraska | 31037 | 2517 | 26 |
2162868 | 2162868 | 2022-01-29 | Colfax | Nebraska | 31037 | 2517 | 26 |
2159613 | 2159613 | 2022-01-28 | Colfax | Nebraska | 31037 | 2517 | 26 |
2146098 | 2146098 | 2022-01-24 | West Feliciana | Louisiana | 22125 | 2517 | 41 |
2137806 | 2137806 | 2022-01-21 | Camp | Texas | 48063 | 2517 | 70 |
2105022 | 2105022 | 2022-01-11 | Salinas | Puerto Rico | 72123 | 2517 | |
2087079 | 2087079 | 2022-01-06 | Blackford | Indiana | 18009 | 2517 | 56 |
2056904 | 2056904 | 2021-12-27 | Southampton | Virginia | 51175 | 2517 | 72 |
2051578 | 2051578 | 2021-12-26 | Osage | Kansas | 20139 | 2517 | 40 |
2048328 | 2048328 | 2021-12-25 | Osage | Kansas | 20139 | 2517 | 40 |
2045078 | 2045078 | 2021-12-24 | Osage | Kansas | 20139 | 2517 | 40 |
2041829 | 2041829 | 2021-12-23 | Osage | Kansas | 20139 | 2517 | 40 |
2038579 | 2038579 | 2021-12-22 | Osage | Kansas | 20139 | 2517 | 40 |
2031268 | 2031268 | 2021-12-20 | Marion | Arkansas | 5089 | 2517 | 69 |
2024215 | 2024215 | 2021-12-17 | Tyler | Texas | 48457 | 2517 | 72 |
2017629 | 2017629 | 2021-12-15 | Leon | Texas | 48289 | 2517 | 71 |
2014379 | 2014379 | 2021-12-14 | Leon | Texas | 48289 | 2517 | 71 |
2009884 | 2009884 | 2021-12-13 | Dallas | Missouri | 29059 | 2517 | 57 |
2004212 | 2004212 | 2021-12-11 | Corozal | Puerto Rico | 72047 | 2517 | |
2000165 | 2000165 | 2021-12-10 | Madison | Missouri | 29123 | 2517 | 40 |
2000961 | 2000961 | 2021-12-10 | Corozal | Puerto Rico | 72047 | 2517 | |
1983136 | 1983136 | 2021-12-05 | Tipton | Indiana | 18159 | 2517 | 70 |
1983468 | 1983468 | 2021-12-05 | Washington | Kentucky | 21229 | 2517 | 48 |
1979886 | 1979886 | 2021-12-04 | Tipton | Indiana | 18159 | 2517 | 70 |
1980218 | 1980218 | 2021-12-04 | Washington | Kentucky | 21229 | 2517 | 48 |
1976636 | 1976636 | 2021-12-03 | Tipton | Indiana | 18159 | 2517 | 70 |
1976968 | 1976968 | 2021-12-03 | Washington | Kentucky | 21229 | 2517 | 48 |
1973731 | 1973731 | 2021-12-02 | Bienville | Louisiana | 22013 | 2517 | 99 |
1970481 | 1970481 | 2021-12-01 | Bienville | Louisiana | 22013 | 2517 | 99 |
1963912 | 1963912 | 2021-11-29 | Knott | Kentucky | 21119 | 2517 | 43 |
1965631 | 1965631 | 2021-11-29 | Madison | Texas | 48313 | 2517 | 45 |
1946737 | 1946737 | 2021-11-24 | Howard | Arkansas | 5061 | 2517 | 38 |
1941213 | 1941213 | 2021-11-22 | Webster | Kentucky | 21233 | 2517 | 42 |
1933146 | 1933146 | 2021-11-19 | Nolan | Texas | 48353 | 2517 | 79 |
1929895 | 1929895 | 2021-11-18 | Nolan | Texas | 48353 | 2517 | 79 |
1901110 | 1901110 | 2021-11-10 | Cleburne | Alabama | 1029 | 2517 | 60 |
1882225 | 1882225 | 2021-11-04 | Ford | Illinois | 17053 | 2517 | 67 |
1854060 | 1854060 | 2021-10-26 | Gage | Nebraska | 31067 | 2517 | 27 |
1850811 | 1850811 | 2021-10-25 | Gage | Nebraska | 31067 | 2517 | 27 |
1847561 | 1847561 | 2021-10-24 | Gage | Nebraska | 31067 | 2517 | 27 |
1844311 | 1844311 | 2021-10-23 | Gage | Nebraska | 31067 | 2517 | 27 |
1841061 | 1841061 | 2021-10-22 | Gage | Nebraska | 31067 | 2517 | 27 |
1841401 | 1841401 | 2021-10-22 | Richland | North Dakota | 38077 | 2517 | 19 |
1837812 | 1837812 | 2021-10-21 | Gage | Nebraska | 31067 | 2517 | 27 |
1807655 | 1807655 | 2021-10-12 | Vermillion | Indiana | 18165 | 2517 | 54 |
1804404 | 1804404 | 2021-10-11 | Vermillion | Indiana | 18165 | 2517 | 54 |
1802339 | 1802339 | 2021-10-10 | Northampton | North Carolina | 37131 | 2517 | 62 |
1799090 | 1799090 | 2021-10-09 | Northampton | North Carolina | 37131 | 2517 | 62 |
1795841 | 1795841 | 2021-10-08 | Northampton | North Carolina | 37131 | 2517 | 62 |
1789740 | 1789740 | 2021-10-06 | Isabela | Puerto Rico | 72071 | 2517 | |
1762393 | 1762393 | 2021-09-28 | Breckinridge | Kentucky | 21027 | 2517 | 26 |
1762948 | 1762948 | 2021-09-28 | Morgan | Missouri | 29141 | 2517 | 57 |
1759536 | 1759536 | 2021-09-27 | Wabasha | Minnesota | 27157 | 2517 | 5 |
1742910 | 1742910 | 2021-09-22 | Casey | Kentucky | 21045 | 2517 | 50 |
1741814 | 1741814 | 2021-09-21 | Green Lake | Wisconsin | 55047 | 2517 | 29 |
1714168 | 1714168 | 2021-09-13 | Cooper | Missouri | 29053 | 2517 | 31 |
1715669 | 1715669 | 2021-09-13 | Prince Edward | Virginia | 51147 | 2517 | 40 |
1686217 | 1686217 | 2021-09-04 | Panola | Texas | 48365 | 2517 | 89 |
1676938 | 1676938 | 2021-09-02 | Fayette | Alabama | 1057 | 2517 | 66 |
1672001 | 1672001 | 2021-08-31 | Ray | Missouri | 29177 | 2517 | 39 |
1667334 | 1667334 | 2021-08-30 | Polk | Arkansas | 5113 | 2517 | 88 |
1668593 | 1668593 | 2021-08-30 | Clarke | Mississippi | 28023 | 2517 | 81 |
1654144 | 1654144 | 2021-08-25 | Vilas | Wisconsin | 55125 | 2517 | 45 |
1637450 | 1637450 | 2021-08-20 | Lee | Texas | 48287 | 2517 | 41 |
1631466 | 1631466 | 2021-08-19 | Hale | Alabama | 1065 | 2517 | 79 |
1628912 | 1628912 | 2021-08-18 | Fountain | Indiana | 18045 | 2517 | 52 |
1623099 | 1623099 | 2021-08-16 | Waseca | Minnesota | 27161 | 2517 | 23 |
1621497 | 1621497 | 2021-08-15 | Waynesboro city | Virginia | 51820 | 2517 | 39 |
1618249 | 1618249 | 2021-08-14 | Waynesboro city | Virginia | 51820 | 2517 | 39 |
1615001 | 1615001 | 2021-08-13 | Waynesboro city | Virginia | 51820 | 2517 | 39 |
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);