ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,958 rows where deaths = 120 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 280
- Texas 275
- Georgia 272
- Ohio 204
- Michigan 189
- New York 178
- Mississippi 172
- Kentucky 165
- Indiana 163
- Virginia 155
- Tennessee 153
- Illinois 127
- Minnesota 127
- Arkansas 120
- North Carolina 119
- California 107
- Louisiana 103
- Pennsylvania 85
- Wisconsin 82
- Kansas 80
- Missouri 77
- Iowa 68
- Oklahoma 60
- South Carolina 57
- Alabama 54
- Florida 54
- West Virginia 50
- Maryland 47
- Idaho 44
- Washington 43
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499766 | 2499766 | 2022-05-13 | Calaveras | California | 6009 | 7754 | 120 |
2499985 | 2499985 | 2022-05-13 | Camden | Georgia | 13039 | 11467 | 120 |
2500837 | 2500837 | 2022-05-13 | Chippewa | Michigan | 26033 | 11841 | 120 |
2500917 | 2500917 | 2022-05-13 | Chisago | Minnesota | 27025 | 14845 | 120 |
2501032 | 2501032 | 2022-05-13 | Leake | Mississippi | 28079 | 6427 | 120 |
2501438 | 2501438 | 2022-05-13 | Cortland | New York | 36023 | 11365 | 120 |
2501584 | 2501584 | 2022-05-13 | Yadkin | North Carolina | 37197 | 11048 | 120 |
2502170 | 2502170 | 2022-05-13 | McNairy | Tennessee | 47109 | 7662 | 120 |
2502299 | 2502299 | 2022-05-13 | Grimes | Texas | 48185 | 8511 | 120 |
2502349 | 2502349 | 2022-05-13 | Lavaca | Texas | 48285 | 4271 | 120 |
2496508 | 2496508 | 2022-05-12 | Calaveras | California | 6009 | 7733 | 120 |
2496727 | 2496727 | 2022-05-12 | Camden | Georgia | 13039 | 11467 | 120 |
2497579 | 2497579 | 2022-05-12 | Chippewa | Michigan | 26033 | 11841 | 120 |
2497659 | 2497659 | 2022-05-12 | Chisago | Minnesota | 27025 | 14815 | 120 |
2497774 | 2497774 | 2022-05-12 | Leake | Mississippi | 28079 | 6427 | 120 |
2498177 | 2498177 | 2022-05-12 | Chenango | New York | 36017 | 9858 | 120 |
2498180 | 2498180 | 2022-05-12 | Cortland | New York | 36023 | 11365 | 120 |
2498326 | 2498326 | 2022-05-12 | Yadkin | North Carolina | 37197 | 11048 | 120 |
2498912 | 2498912 | 2022-05-12 | McNairy | Tennessee | 47109 | 7662 | 120 |
2499041 | 2499041 | 2022-05-12 | Grimes | Texas | 48185 | 8507 | 120 |
2499091 | 2499091 | 2022-05-12 | Lavaca | Texas | 48285 | 4271 | 120 |
2499315 | 2499315 | 2022-05-12 | James City | Virginia | 51095 | 15414 | 120 |
2499522 | 2499522 | 2022-05-12 | Oconto | Wisconsin | 55083 | 11513 | 120 |
2493250 | 2493250 | 2022-05-11 | Calaveras | California | 6009 | 7733 | 120 |
2493469 | 2493469 | 2022-05-11 | Camden | Georgia | 13039 | 11467 | 120 |
2494321 | 2494321 | 2022-05-11 | Chippewa | Michigan | 26033 | 11841 | 120 |
2494401 | 2494401 | 2022-05-11 | Chisago | Minnesota | 27025 | 14794 | 120 |
2494516 | 2494516 | 2022-05-11 | Leake | Mississippi | 28079 | 6427 | 120 |
2494919 | 2494919 | 2022-05-11 | Chenango | New York | 36017 | 9836 | 120 |
2494922 | 2494922 | 2022-05-11 | Cortland | New York | 36023 | 11346 | 120 |
2495068 | 2495068 | 2022-05-11 | Yadkin | North Carolina | 37197 | 11048 | 120 |
2495654 | 2495654 | 2022-05-11 | McNairy | Tennessee | 47109 | 7662 | 120 |
2495783 | 2495783 | 2022-05-11 | Grimes | Texas | 48185 | 8505 | 120 |
2495833 | 2495833 | 2022-05-11 | Lavaca | Texas | 48285 | 4271 | 120 |
2496057 | 2496057 | 2022-05-11 | James City | Virginia | 51095 | 15359 | 120 |
2496264 | 2496264 | 2022-05-11 | Oconto | Wisconsin | 55083 | 11506 | 120 |
2489992 | 2489992 | 2022-05-10 | Calaveras | California | 6009 | 7733 | 120 |
2491063 | 2491063 | 2022-05-10 | Chippewa | Michigan | 26033 | 11738 | 120 |
2491143 | 2491143 | 2022-05-10 | Chisago | Minnesota | 27025 | 14777 | 120 |
2491258 | 2491258 | 2022-05-10 | Leake | Mississippi | 28079 | 6427 | 120 |
2491661 | 2491661 | 2022-05-10 | Chenango | New York | 36017 | 9805 | 120 |
2491664 | 2491664 | 2022-05-10 | Cortland | New York | 36023 | 11320 | 120 |
2491810 | 2491810 | 2022-05-10 | Yadkin | North Carolina | 37197 | 11003 | 120 |
2492396 | 2492396 | 2022-05-10 | McNairy | Tennessee | 47109 | 7656 | 120 |
2492525 | 2492525 | 2022-05-10 | Grimes | Texas | 48185 | 8504 | 120 |
2492575 | 2492575 | 2022-05-10 | Lavaca | Texas | 48285 | 4269 | 120 |
2492799 | 2492799 | 2022-05-10 | James City | Virginia | 51095 | 15346 | 120 |
2493006 | 2493006 | 2022-05-10 | Oconto | Wisconsin | 55083 | 11496 | 120 |
2486735 | 2486735 | 2022-05-09 | Calaveras | California | 6009 | 7718 | 120 |
2487806 | 2487806 | 2022-05-09 | Chippewa | Michigan | 26033 | 11738 | 120 |
2487886 | 2487886 | 2022-05-09 | Chisago | Minnesota | 27025 | 14753 | 120 |
2488001 | 2488001 | 2022-05-09 | Leake | Mississippi | 28079 | 6427 | 120 |
2488403 | 2488403 | 2022-05-09 | Chenango | New York | 36017 | 9784 | 120 |
2488406 | 2488406 | 2022-05-09 | Cortland | New York | 36023 | 11309 | 120 |
2488552 | 2488552 | 2022-05-09 | Yadkin | North Carolina | 37197 | 11003 | 120 |
2489138 | 2489138 | 2022-05-09 | McNairy | Tennessee | 47109 | 7656 | 120 |
2489267 | 2489267 | 2022-05-09 | Grimes | Texas | 48185 | 8502 | 120 |
2489317 | 2489317 | 2022-05-09 | Lavaca | Texas | 48285 | 4268 | 120 |
2489541 | 2489541 | 2022-05-09 | James City | Virginia | 51095 | 15322 | 120 |
2489748 | 2489748 | 2022-05-09 | Oconto | Wisconsin | 55083 | 11491 | 120 |
2483477 | 2483477 | 2022-05-08 | Calaveras | California | 6009 | 7718 | 120 |
2484378 | 2484378 | 2022-05-08 | Muhlenberg | Kentucky | 21177 | 10187 | 120 |
2484548 | 2484548 | 2022-05-08 | Chippewa | Michigan | 26033 | 11738 | 120 |
2484628 | 2484628 | 2022-05-08 | Chisago | Minnesota | 27025 | 14726 | 120 |
2484743 | 2484743 | 2022-05-08 | Leake | Mississippi | 28079 | 6417 | 120 |
2485146 | 2485146 | 2022-05-08 | Chenango | New York | 36017 | 9779 | 120 |
2485149 | 2485149 | 2022-05-08 | Cortland | New York | 36023 | 11300 | 120 |
2485295 | 2485295 | 2022-05-08 | Yadkin | North Carolina | 37197 | 11003 | 120 |
2485881 | 2485881 | 2022-05-08 | McNairy | Tennessee | 47109 | 7656 | 120 |
2486010 | 2486010 | 2022-05-08 | Grimes | Texas | 48185 | 8500 | 120 |
2486060 | 2486060 | 2022-05-08 | Lavaca | Texas | 48285 | 4265 | 120 |
2486284 | 2486284 | 2022-05-08 | James City | Virginia | 51095 | 15233 | 120 |
2486491 | 2486491 | 2022-05-08 | Oconto | Wisconsin | 55083 | 11476 | 120 |
2480219 | 2480219 | 2022-05-07 | Calaveras | California | 6009 | 7718 | 120 |
2481120 | 2481120 | 2022-05-07 | Muhlenberg | Kentucky | 21177 | 10187 | 120 |
2481290 | 2481290 | 2022-05-07 | Chippewa | Michigan | 26033 | 11738 | 120 |
2481370 | 2481370 | 2022-05-07 | Chisago | Minnesota | 27025 | 14726 | 120 |
2481485 | 2481485 | 2022-05-07 | Leake | Mississippi | 28079 | 6417 | 120 |
2481888 | 2481888 | 2022-05-07 | Chenango | New York | 36017 | 9768 | 120 |
2481891 | 2481891 | 2022-05-07 | Cortland | New York | 36023 | 11289 | 120 |
2482037 | 2482037 | 2022-05-07 | Yadkin | North Carolina | 37197 | 11003 | 120 |
2482623 | 2482623 | 2022-05-07 | McNairy | Tennessee | 47109 | 7656 | 120 |
2482752 | 2482752 | 2022-05-07 | Grimes | Texas | 48185 | 8498 | 120 |
2482802 | 2482802 | 2022-05-07 | Lavaca | Texas | 48285 | 4264 | 120 |
2483026 | 2483026 | 2022-05-07 | James City | Virginia | 51095 | 15233 | 120 |
2483233 | 2483233 | 2022-05-07 | Oconto | Wisconsin | 55083 | 11476 | 120 |
2476961 | 2476961 | 2022-05-06 | Calaveras | California | 6009 | 7718 | 120 |
2477862 | 2477862 | 2022-05-06 | Muhlenberg | Kentucky | 21177 | 10187 | 120 |
2478032 | 2478032 | 2022-05-06 | Chippewa | Michigan | 26033 | 11738 | 120 |
2478112 | 2478112 | 2022-05-06 | Chisago | Minnesota | 27025 | 14726 | 120 |
2478227 | 2478227 | 2022-05-06 | Leake | Mississippi | 28079 | 6417 | 120 |
2478630 | 2478630 | 2022-05-06 | Chenango | New York | 36017 | 9751 | 120 |
2478633 | 2478633 | 2022-05-06 | Cortland | New York | 36023 | 11260 | 120 |
2478779 | 2478779 | 2022-05-06 | Yadkin | North Carolina | 37197 | 11003 | 120 |
2479365 | 2479365 | 2022-05-06 | McNairy | Tennessee | 47109 | 7656 | 120 |
2479494 | 2479494 | 2022-05-06 | Grimes | Texas | 48185 | 8497 | 120 |
2479544 | 2479544 | 2022-05-06 | Lavaca | Texas | 48285 | 4261 | 120 |
2479768 | 2479768 | 2022-05-06 | James City | Virginia | 51095 | 15233 | 120 |
2479975 | 2479975 | 2022-05-06 | Oconto | Wisconsin | 55083 | 11476 | 120 |
2473703 | 2473703 | 2022-05-05 | Calaveras | California | 6009 | 7707 | 120 |
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);