ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where cases = 13647 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 20
- Oklahoma 7
- North Carolina 5
- Wisconsin 4
- Kansas 3
- Tennessee 3
- Texas 3
- Arkansas 2
- California 2
- New York 2
- Alabama 1
- Florida 1
- Idaho 1
- Illinois 1
- Indiana 1
- Iowa 1
- Missouri 1
- New Jersey 1
- Ohio 1
- Oregon 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500351 | 2500351 | 2022-05-13 | Shelby | Indiana | 18145 | 13647 | 182 |
2502213 | 2502213 | 2022-05-13 | Atascosa | Texas | 48013 | 13647 | 231 |
2498955 | 2498955 | 2022-05-12 | Atascosa | Texas | 48013 | 13647 | 231 |
2431157 | 2431157 | 2022-04-21 | Waupaca | Wisconsin | 55135 | 13647 | 251 |
2423293 | 2423293 | 2022-04-19 | Madison | New York | 36053 | 13647 | 126 |
2348529 | 2348529 | 2022-03-27 | McDowell | North Carolina | 37111 | 13647 | 167 |
2345276 | 2345276 | 2022-03-26 | McDowell | North Carolina | 37111 | 13647 | 167 |
2342023 | 2342023 | 2022-03-25 | McDowell | North Carolina | 37111 | 13647 | 167 |
2213902 | 2213902 | 2022-02-14 | Ogle | Illinois | 17141 | 13647 | 136 |
2058710 | 2058710 | 2021-12-28 | St. Francois | Missouri | 29187 | 13647 | 228 |
2036447 | 2036447 | 2021-12-21 | Erie | Ohio | 39043 | 13647 | 213 |
2006025 | 2006025 | 2021-12-12 | Douglas | Kansas | 20045 | 13647 | 107 |
2002774 | 2002774 | 2021-12-11 | Douglas | Kansas | 20045 | 13647 | 107 |
1999524 | 1999524 | 2021-12-10 | Douglas | Kansas | 20045 | 13647 | 107 |
1987605 | 1987605 | 2021-12-06 | Wilson | North Carolina | 37195 | 13647 | 243 |
1926996 | 1926996 | 2021-11-17 | Wood | West Virginia | 54107 | 13647 | 256 |
1919197 | 1919197 | 2021-11-15 | Chautauqua | New York | 36013 | 13647 | 186 |
1860822 | 1860822 | 2021-10-28 | Moore | North Carolina | 37125 | 13647 | 246 |
1695373 | 1695373 | 2021-09-07 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1692125 | 1692125 | 2021-09-06 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1688876 | 1688876 | 2021-09-05 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1685626 | 1685626 | 2021-09-04 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1682375 | 1682375 | 2021-09-03 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1679125 | 1679125 | 2021-09-02 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1675877 | 1675877 | 2021-09-01 | Rogers | Oklahoma | 40131 | 13647 | 214 |
1566402 | 1566402 | 2021-07-29 | La Crosse | Wisconsin | 55063 | 13647 | 93 |
1511394 | 1511394 | 2021-07-13 | Faulkner | Arkansas | 5045 | 13647 | 168 |
1507372 | 1507372 | 2021-07-11 | Sevier | Tennessee | 47155 | 13647 | 179 |
1504126 | 1504126 | 2021-07-10 | Sevier | Tennessee | 47155 | 13647 | 179 |
1500880 | 1500880 | 2021-07-09 | Sevier | Tennessee | 47155 | 13647 | 179 |
1394536 | 1394536 | 2021-06-07 | Craighead | Arkansas | 5031 | 13647 | 183 |
1342412 | 1342412 | 2021-05-21 | La Crosse | Wisconsin | 55063 | 13647 | 88 |
1309932 | 1309932 | 2021-05-11 | Fond du Lac | Wisconsin | 55039 | 13647 | 121 |
1251810 | 1251810 | 2021-04-24 | Yolo | California | 6113 | 13647 | 205 |
1173651 | 1173651 | 2021-03-31 | Etowah | Alabama | 1055 | 13647 | 343 |
1127632 | 1127632 | 2021-03-16 | Guadalupe | Texas | 48187 | 13647 | 198 |
1114159 | 1114159 | 2021-03-12 | Clackamas | Oregon | 41005 | 13647 | 195 |
934219 | 934219 | 2021-01-16 | Black Hawk | Iowa | 19013 | 13647 | 236 |
914173 | 914173 | 2021-01-10 | San Luis Obispo | California | 6079 | 13647 | 101 |
904795 | 904795 | 2021-01-07 | Kootenai | Idaho | 16055 | 13647 | 130 |
778021 | 778021 | 2020-11-29 | Sarasota | Florida | 12115 | 13647 | 389 |
656161 | 656161 | 2020-10-22 | Monmouth | New Jersey | 34025 | 13647 | 870 |
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);