ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 71,320
- Georgia 47,769
- Virginia 39,147
- Kentucky 34,852
- Missouri 33,322
- Illinois 29,971
- North Carolina 29,708
- Iowa 28,970
- Kansas 28,663
- Tennessee 28,543
- Indiana 27,634
- Ohio 26,338
- Minnesota 25,555
- Michigan 24,798
- Mississippi 24,648
- Nebraska 24,164
- Oklahoma 22,406
- Arkansas 22,400
- Wisconsin 21,359
- Florida 20,586
- Puerto Rico 20,398
- Pennsylvania 20,214
- Alabama 20,018
- Louisiana 19,638
- Colorado 18,679
- South Dakota 17,806
- New York 17,794
- California 17,729
- West Virginia 15,781
- North Dakota 14,525
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
937234 | 937234 | 2021-01-17 | Caribou | Idaho | 16029 | 586 | 10 |
937235 | 937235 | 2021-01-17 | Cassia | Idaho | 16031 | 2700 | 22 |
937236 | 937236 | 2021-01-17 | Clark | Idaho | 16033 | 53 | 0 |
937237 | 937237 | 2021-01-17 | Clearwater | Idaho | 16035 | 921 | 10 |
937238 | 937238 | 2021-01-17 | Custer | Idaho | 16037 | 223 | 2 |
937239 | 937239 | 2021-01-17 | Elmore | Idaho | 16039 | 1471 | 10 |
937240 | 937240 | 2021-01-17 | Franklin | Idaho | 16041 | 997 | 12 |
937241 | 937241 | 2021-01-17 | Fremont | Idaho | 16043 | 919 | 14 |
937242 | 937242 | 2021-01-17 | Gem | Idaho | 16045 | 1557 | 25 |
937243 | 937243 | 2021-01-17 | Gooding | Idaho | 16047 | 1207 | 21 |
937244 | 937244 | 2021-01-17 | Idaho | Idaho | 16049 | 1134 | 16 |
937245 | 937245 | 2021-01-17 | Jefferson | Idaho | 16051 | 2196 | 15 |
937246 | 937246 | 2021-01-17 | Jerome | Idaho | 16053 | 2360 | 17 |
937247 | 937247 | 2021-01-17 | Kootenai | Idaho | 16055 | 14754 | 140 |
937248 | 937248 | 2021-01-17 | Latah | Idaho | 16057 | 2382 | 6 |
937249 | 937249 | 2021-01-17 | Lemhi | Idaho | 16059 | 473 | 9 |
937250 | 937250 | 2021-01-17 | Lewis | Idaho | 16061 | 361 | 6 |
937251 | 937251 | 2021-01-17 | Lincoln | Idaho | 16063 | 459 | 9 |
937252 | 937252 | 2021-01-17 | Madison | Idaho | 16065 | 5658 | 21 |
937253 | 937253 | 2021-01-17 | Minidoka | Idaho | 16067 | 2176 | 25 |
937254 | 937254 | 2021-01-17 | Nez Perce | Idaho | 16069 | 3191 | 46 |
937255 | 937255 | 2021-01-17 | Oneida | Idaho | 16071 | 282 | 3 |
937256 | 937256 | 2021-01-17 | Owyhee | Idaho | 16073 | 951 | 23 |
937257 | 937257 | 2021-01-17 | Payette | Idaho | 16075 | 2231 | 25 |
937258 | 937258 | 2021-01-17 | Power | Idaho | 16077 | 576 | 6 |
937259 | 937259 | 2021-01-17 | Shoshone | Idaho | 16079 | 920 | 30 |
937260 | 937260 | 2021-01-17 | Teton | Idaho | 16081 | 879 | 4 |
937261 | 937261 | 2021-01-17 | Twin Falls | Idaho | 16083 | 8510 | 117 |
937262 | 937262 | 2021-01-17 | Valley | Idaho | 16085 | 625 | 4 |
937263 | 937263 | 2021-01-17 | Washington | Idaho | 16087 | 1083 | 17 |
937264 | 937264 | 2021-01-17 | Adams | Illinois | 17001 | 7310 | 117 |
937265 | 937265 | 2021-01-17 | Alexander | Illinois | 17003 | 388 | 7 |
937266 | 937266 | 2021-01-17 | Bond | Illinois | 17005 | 1731 | 24 |
937267 | 937267 | 2021-01-17 | Boone | Illinois | 17007 | 5523 | 77 |
937268 | 937268 | 2021-01-17 | Brown | Illinois | 17009 | 607 | 11 |
937269 | 937269 | 2021-01-17 | Bureau | Illinois | 17011 | 2996 | 84 |
937270 | 937270 | 2021-01-17 | Calhoun | Illinois | 17013 | 437 | 4 |
937271 | 937271 | 2021-01-17 | Carroll | Illinois | 17015 | 1423 | 33 |
937272 | 937272 | 2021-01-17 | Cass | Illinois | 17017 | 1747 | 31 |
937273 | 937273 | 2021-01-17 | Champaign | Illinois | 17019 | 15349 | 97 |
937274 | 937274 | 2021-01-17 | Christian | Illinois | 17021 | 2974 | 74 |
937275 | 937275 | 2021-01-17 | Clark | Illinois | 17023 | 1465 | 29 |
937276 | 937276 | 2021-01-17 | Clay | Illinois | 17025 | 1309 | 39 |
937277 | 937277 | 2021-01-17 | Clinton | Illinois | 17027 | 4989 | 85 |
937278 | 937278 | 2021-01-17 | Coles | Illinois | 17029 | 4690 | 80 |
937279 | 937279 | 2021-01-17 | Cook | Illinois | 17031 | 433089 | 9005 |
937280 | 937280 | 2021-01-17 | Crawford | Illinois | 17033 | 1753 | 34 |
937281 | 937281 | 2021-01-17 | Cumberland | Illinois | 17035 | 1075 | 27 |
937282 | 937282 | 2021-01-17 | De Witt | Illinois | 17039 | 1135 | 27 |
937283 | 937283 | 2021-01-17 | DeKalb | Illinois | 17037 | 7469 | 92 |
937284 | 937284 | 2021-01-17 | Douglas | Illinois | 17041 | 1986 | 33 |
937285 | 937285 | 2021-01-17 | DuPage | Illinois | 17043 | 68737 | 1145 |
937286 | 937286 | 2021-01-17 | Edgar | Illinois | 17045 | 1427 | 53 |
937287 | 937287 | 2021-01-17 | Edwards | Illinois | 17047 | 460 | 9 |
937288 | 937288 | 2021-01-17 | Effingham | Illinois | 17049 | 4298 | 68 |
937289 | 937289 | 2021-01-17 | Fayette | Illinois | 17051 | 2898 | 53 |
937290 | 937290 | 2021-01-17 | Ford | Illinois | 17053 | 1380 | 49 |
937291 | 937291 | 2021-01-17 | Franklin | Illinois | 17055 | 3820 | 68 |
937292 | 937292 | 2021-01-17 | Fulton | Illinois | 17057 | 2544 | 49 |
937293 | 937293 | 2021-01-17 | Gallatin | Illinois | 17059 | 385 | 4 |
937294 | 937294 | 2021-01-17 | Greene | Illinois | 17061 | 1252 | 42 |
937295 | 937295 | 2021-01-17 | Grundy | Illinois | 17063 | 4339 | 54 |
937296 | 937296 | 2021-01-17 | Hamilton | Illinois | 17065 | 714 | 16 |
937297 | 937297 | 2021-01-17 | Hancock | Illinois | 17067 | 1469 | 33 |
937298 | 937298 | 2021-01-17 | Hardin | Illinois | 17069 | 301 | 8 |
937299 | 937299 | 2021-01-17 | Henderson | Illinois | 17071 | 451 | 16 |
937300 | 937300 | 2021-01-17 | Henry | Illinois | 17073 | 3996 | 76 |
937301 | 937301 | 2021-01-17 | Iroquois | Illinois | 17075 | 2577 | 56 |
937302 | 937302 | 2021-01-17 | Jackson | Illinois | 17077 | 4156 | 67 |
937303 | 937303 | 2021-01-17 | Jasper | Illinois | 17079 | 1038 | 16 |
937304 | 937304 | 2021-01-17 | Jefferson | Illinois | 17081 | 3409 | 104 |
937305 | 937305 | 2021-01-17 | Jersey | Illinois | 17083 | 2194 | 56 |
937306 | 937306 | 2021-01-17 | Jo Daviess | Illinois | 17085 | 1481 | 24 |
937307 | 937307 | 2021-01-17 | Johnson | Illinois | 17087 | 1211 | 15 |
937308 | 937308 | 2021-01-17 | Kane | Illinois | 17089 | 45704 | 675 |
937309 | 937309 | 2021-01-17 | Kankakee | Illinois | 17091 | 11431 | 179 |
937310 | 937310 | 2021-01-17 | Kendall | Illinois | 17093 | 9717 | 78 |
937311 | 937311 | 2021-01-17 | Knox | Illinois | 17095 | 4577 | 140 |
937312 | 937312 | 2021-01-17 | LaSalle | Illinois | 17099 | 9392 | 247 |
937313 | 937313 | 2021-01-17 | Lake | Illinois | 17097 | 53068 | 884 |
937314 | 937314 | 2021-01-17 | Lawrence | Illinois | 17101 | 2167 | 30 |
937315 | 937315 | 2021-01-17 | Lee | Illinois | 17103 | 3024 | 72 |
937316 | 937316 | 2021-01-17 | Livingston | Illinois | 17105 | 3624 | 66 |
937317 | 937317 | 2021-01-17 | Logan | Illinois | 17107 | 3075 | 56 |
937318 | 937318 | 2021-01-17 | Macon | Illinois | 17115 | 8775 | 179 |
937319 | 937319 | 2021-01-17 | Macoupin | Illinois | 17117 | 3810 | 94 |
937320 | 937320 | 2021-01-17 | Madison | Illinois | 17119 | 24144 | 462 |
937321 | 937321 | 2021-01-17 | Marion | Illinois | 17121 | 3958 | 111 |
937322 | 937322 | 2021-01-17 | Marshall | Illinois | 17123 | 662 | 13 |
937323 | 937323 | 2021-01-17 | Mason | Illinois | 17125 | 1162 | 40 |
937324 | 937324 | 2021-01-17 | Massac | Illinois | 17127 | 1014 | 30 |
937325 | 937325 | 2021-01-17 | McDonough | Illinois | 17109 | 2132 | 51 |
937326 | 937326 | 2021-01-17 | McHenry | Illinois | 17111 | 21498 | 248 |
937327 | 937327 | 2021-01-17 | McLean | Illinois | 17113 | 13143 | 159 |
937328 | 937328 | 2021-01-17 | Menard | Illinois | 17129 | 868 | 10 |
937329 | 937329 | 2021-01-17 | Mercer | Illinois | 17131 | 1167 | 29 |
937330 | 937330 | 2021-01-17 | Monroe | Illinois | 17133 | 3545 | 70 |
937331 | 937331 | 2021-01-17 | Montgomery | Illinois | 17135 | 3031 | 40 |
937332 | 937332 | 2021-01-17 | Morgan | Illinois | 17137 | 3306 | 90 |
937333 | 937333 | 2021-01-17 | Moultrie | Illinois | 17139 | 1364 | 28 |
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);