ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,784 rows where deaths = 144 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Mississippi 262
- Illinois 211
- Ohio 173
- Texas 169
- Georgia 162
- Louisiana 146
- South Carolina 117
- Virginia 115
- Indiana 112
- Kentucky 109
- Oklahoma 86
- New York 79
- Pennsylvania 77
- Michigan 75
- North Carolina 73
- Tennessee 72
- Alabama 70
- Wisconsin 66
- Missouri 52
- Oregon 41
- Arkansas 40
- Iowa 39
- Minnesota 37
- Arizona 35
- Kansas 35
- Guam 29
- Alaska 28
- Washington 28
- New Mexico 27
- West Virginia 27
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499677 | 2499677 | 2022-05-13 | La Paz | Arizona | 4012 | 5227 | 144 |
2500245 | 2500245 | 2022-05-13 | Morgan | Illinois | 17137 | 9661 | 144 |
2500397 | 2500397 | 2022-05-13 | Dallas | Iowa | 19049 | 23337 | 144 |
2500639 | 2500639 | 2022-05-13 | Knox | Kentucky | 21121 | 11523 | 144 |
2500729 | 2500729 | 2022-05-13 | Lincoln | Louisiana | 22061 | 12269 | 144 |
2501021 | 2501021 | 2022-05-13 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2501697 | 2501697 | 2022-05-13 | Mercer | Ohio | 39107 | 9715 | 144 |
2502015 | 2502015 | 2022-05-13 | Dillon | South Carolina | 45033 | 9729 | 144 |
2502550 | 2502550 | 2022-05-13 | Fauquier | Virginia | 51061 | 13267 | 144 |
2502740 | 2502740 | 2022-05-13 | Barron | Wisconsin | 55005 | 13743 | 144 |
2502824 | 2502824 | 2022-05-13 | Park | Wyoming | 56029 | 6801 | 144 |
2496419 | 2496419 | 2022-05-12 | La Paz | Arizona | 4012 | 5227 | 144 |
2496987 | 2496987 | 2022-05-12 | Morgan | Illinois | 17137 | 9652 | 144 |
2497139 | 2497139 | 2022-05-12 | Dallas | Iowa | 19049 | 23337 | 144 |
2497381 | 2497381 | 2022-05-12 | Knox | Kentucky | 21121 | 11523 | 144 |
2497471 | 2497471 | 2022-05-12 | Lincoln | Louisiana | 22061 | 12266 | 144 |
2497763 | 2497763 | 2022-05-12 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2498439 | 2498439 | 2022-05-12 | Mercer | Ohio | 39107 | 9715 | 144 |
2498757 | 2498757 | 2022-05-12 | Dillon | South Carolina | 45033 | 9729 | 144 |
2499292 | 2499292 | 2022-05-12 | Fauquier | Virginia | 51061 | 13247 | 144 |
2499482 | 2499482 | 2022-05-12 | Barron | Wisconsin | 55005 | 13732 | 144 |
2499566 | 2499566 | 2022-05-12 | Park | Wyoming | 56029 | 6801 | 144 |
2493161 | 2493161 | 2022-05-11 | La Paz | Arizona | 4012 | 5227 | 144 |
2493729 | 2493729 | 2022-05-11 | Morgan | Illinois | 17137 | 9642 | 144 |
2493881 | 2493881 | 2022-05-11 | Dallas | Iowa | 19049 | 23337 | 144 |
2494123 | 2494123 | 2022-05-11 | Knox | Kentucky | 21121 | 11523 | 144 |
2494213 | 2494213 | 2022-05-11 | Lincoln | Louisiana | 22061 | 12264 | 144 |
2494505 | 2494505 | 2022-05-11 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2495181 | 2495181 | 2022-05-11 | Mercer | Ohio | 39107 | 9699 | 144 |
2495499 | 2495499 | 2022-05-11 | Dillon | South Carolina | 45033 | 9729 | 144 |
2496034 | 2496034 | 2022-05-11 | Fauquier | Virginia | 51061 | 13228 | 144 |
2496224 | 2496224 | 2022-05-11 | Barron | Wisconsin | 55005 | 13722 | 144 |
2496308 | 2496308 | 2022-05-11 | Park | Wyoming | 56029 | 6801 | 144 |
2489903 | 2489903 | 2022-05-10 | La Paz | Arizona | 4012 | 5211 | 144 |
2490471 | 2490471 | 2022-05-10 | Morgan | Illinois | 17137 | 9635 | 144 |
2490623 | 2490623 | 2022-05-10 | Dallas | Iowa | 19049 | 23238 | 144 |
2490865 | 2490865 | 2022-05-10 | Knox | Kentucky | 21121 | 11523 | 144 |
2490955 | 2490955 | 2022-05-10 | Lincoln | Louisiana | 22061 | 12259 | 144 |
2491247 | 2491247 | 2022-05-10 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2491923 | 2491923 | 2022-05-10 | Mercer | Ohio | 39107 | 9699 | 144 |
2492241 | 2492241 | 2022-05-10 | Dillon | South Carolina | 45033 | 9720 | 144 |
2492966 | 2492966 | 2022-05-10 | Barron | Wisconsin | 55005 | 13704 | 144 |
2493050 | 2493050 | 2022-05-10 | Park | Wyoming | 56029 | 6801 | 144 |
2486646 | 2486646 | 2022-05-09 | La Paz | Arizona | 4012 | 5211 | 144 |
2487214 | 2487214 | 2022-05-09 | Morgan | Illinois | 17137 | 9629 | 144 |
2487366 | 2487366 | 2022-05-09 | Dallas | Iowa | 19049 | 23238 | 144 |
2487608 | 2487608 | 2022-05-09 | Knox | Kentucky | 21121 | 11523 | 144 |
2487698 | 2487698 | 2022-05-09 | Lincoln | Louisiana | 22061 | 12253 | 144 |
2487990 | 2487990 | 2022-05-09 | Itawamba | Mississippi | 28057 | 7430 | 144 |
2488665 | 2488665 | 2022-05-09 | Mercer | Ohio | 39107 | 9699 | 144 |
2488983 | 2488983 | 2022-05-09 | Dillon | South Carolina | 45033 | 9720 | 144 |
2489708 | 2489708 | 2022-05-09 | Barron | Wisconsin | 55005 | 13685 | 144 |
2483388 | 2483388 | 2022-05-08 | La Paz | Arizona | 4012 | 5211 | 144 |
2483956 | 2483956 | 2022-05-08 | Morgan | Illinois | 17137 | 9612 | 144 |
2484108 | 2484108 | 2022-05-08 | Dallas | Iowa | 19049 | 23238 | 144 |
2484334 | 2484334 | 2022-05-08 | Greenup | Kentucky | 21089 | 12076 | 144 |
2484440 | 2484440 | 2022-05-08 | Lincoln | Louisiana | 22061 | 12252 | 144 |
2484732 | 2484732 | 2022-05-08 | Itawamba | Mississippi | 28057 | 7421 | 144 |
2485408 | 2485408 | 2022-05-08 | Mercer | Ohio | 39107 | 9699 | 144 |
2485726 | 2485726 | 2022-05-08 | Dillon | South Carolina | 45033 | 9720 | 144 |
2486451 | 2486451 | 2022-05-08 | Barron | Wisconsin | 55005 | 13658 | 144 |
2480130 | 2480130 | 2022-05-07 | La Paz | Arizona | 4012 | 5211 | 144 |
2480698 | 2480698 | 2022-05-07 | Morgan | Illinois | 17137 | 9612 | 144 |
2480850 | 2480850 | 2022-05-07 | Dallas | Iowa | 19049 | 23238 | 144 |
2481076 | 2481076 | 2022-05-07 | Greenup | Kentucky | 21089 | 12076 | 144 |
2481182 | 2481182 | 2022-05-07 | Lincoln | Louisiana | 22061 | 12252 | 144 |
2481474 | 2481474 | 2022-05-07 | Itawamba | Mississippi | 28057 | 7421 | 144 |
2482150 | 2482150 | 2022-05-07 | Mercer | Ohio | 39107 | 9699 | 144 |
2482468 | 2482468 | 2022-05-07 | Dillon | South Carolina | 45033 | 9720 | 144 |
2483193 | 2483193 | 2022-05-07 | Barron | Wisconsin | 55005 | 13658 | 144 |
2476872 | 2476872 | 2022-05-06 | La Paz | Arizona | 4012 | 5211 | 144 |
2477440 | 2477440 | 2022-05-06 | Morgan | Illinois | 17137 | 9612 | 144 |
2477592 | 2477592 | 2022-05-06 | Dallas | Iowa | 19049 | 23238 | 144 |
2477818 | 2477818 | 2022-05-06 | Greenup | Kentucky | 21089 | 12076 | 144 |
2477924 | 2477924 | 2022-05-06 | Lincoln | Louisiana | 22061 | 12252 | 144 |
2478216 | 2478216 | 2022-05-06 | Itawamba | Mississippi | 28057 | 7421 | 144 |
2478892 | 2478892 | 2022-05-06 | Mercer | Ohio | 39107 | 9699 | 144 |
2479210 | 2479210 | 2022-05-06 | Dillon | South Carolina | 45033 | 9720 | 144 |
2479935 | 2479935 | 2022-05-06 | Barron | Wisconsin | 55005 | 13658 | 144 |
2473614 | 2473614 | 2022-05-05 | La Paz | Arizona | 4012 | 5211 | 144 |
2474182 | 2474182 | 2022-05-05 | Morgan | Illinois | 17137 | 9599 | 144 |
2474334 | 2474334 | 2022-05-05 | Dallas | Iowa | 19049 | 23238 | 144 |
2474560 | 2474560 | 2022-05-05 | Greenup | Kentucky | 21089 | 12076 | 144 |
2474666 | 2474666 | 2022-05-05 | Lincoln | Louisiana | 22061 | 12249 | 144 |
2474958 | 2474958 | 2022-05-05 | Itawamba | Mississippi | 28057 | 7421 | 144 |
2475634 | 2475634 | 2022-05-05 | Mercer | Ohio | 39107 | 9699 | 144 |
2475952 | 2475952 | 2022-05-05 | Dillon | South Carolina | 45033 | 9720 | 144 |
2476375 | 2476375 | 2022-05-05 | Uvalde | Texas | 48463 | 10594 | 144 |
2476677 | 2476677 | 2022-05-05 | Barron | Wisconsin | 55005 | 13649 | 144 |
2470357 | 2470357 | 2022-05-04 | La Paz | Arizona | 4012 | 5211 | 144 |
2470925 | 2470925 | 2022-05-04 | Morgan | Illinois | 17137 | 9596 | 144 |
2471077 | 2471077 | 2022-05-04 | Dallas | Iowa | 19049 | 23238 | 144 |
2471303 | 2471303 | 2022-05-04 | Greenup | Kentucky | 21089 | 12076 | 144 |
2471409 | 2471409 | 2022-05-04 | Lincoln | Louisiana | 22061 | 12245 | 144 |
2471701 | 2471701 | 2022-05-04 | Itawamba | Mississippi | 28057 | 7421 | 144 |
2472437 | 2472437 | 2022-05-04 | Garvin | Oklahoma | 40049 | 7029 | 144 |
2472695 | 2472695 | 2022-05-04 | Dillon | South Carolina | 45033 | 9720 | 144 |
2473118 | 2473118 | 2022-05-04 | Uvalde | Texas | 48463 | 10594 | 144 |
2473419 | 2473419 | 2022-05-04 | Barron | Wisconsin | 55005 | 13633 | 144 |
2467101 | 2467101 | 2022-05-03 | La Paz | Arizona | 4012 | 5209 | 144 |
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);