ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
16,353 rows where deaths = 29 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 1,420
- Georgia 903
- Virginia 816
- Kentucky 808
- Iowa 794
- Missouri 773
- Michigan 660
- Illinois 647
- Minnesota 571
- South Dakota 547
- Wisconsin 541
- Kansas 540
- Arkansas 539
- Tennessee 480
- Oklahoma 475
- Montana 456
- Mississippi 449
- Indiana 352
- Louisiana 346
- North Carolina 345
- Alabama 344
- Idaho 334
- West Virginia 303
- Nebraska 264
- Oregon 220
- Washington 220
- Colorado 214
- Ohio 179
- Florida 172
- New York 169
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500006 | 2500006 | 2022-05-13 | Dade | Georgia | 13083 | 3393 | 29 |
2500130 | 2500130 | 2022-05-13 | Kauai | Hawaii | 15007 | 12864 | 29 |
2500153 | 2500153 | 2022-05-13 | Franklin | Idaho | 16041 | 2331 | 29 |
2500163 | 2500163 | 2022-05-13 | Lewis | Idaho | 16061 | 1134 | 29 |
2500200 | 2500200 | 2022-05-13 | Edwards | Illinois | 17047 | 1749 | 29 |
2500250 | 2500250 | 2022-05-13 | Piatt | Illinois | 17147 | 4575 | 29 |
2500260 | 2500260 | 2022-05-13 | Schuyler | Illinois | 17169 | 1977 | 29 |
2500474 | 2500474 | 2022-05-13 | Anderson | Kansas | 20003 | 2133 | 29 |
2500515 | 2500515 | 2022-05-13 | Jackson | Kansas | 20085 | 3908 | 29 |
2500582 | 2500582 | 2022-05-13 | Ballard | Kentucky | 21007 | 1387 | 29 |
2500941 | 2500941 | 2022-05-13 | Lac qui Parle | Minnesota | 27073 | 1764 | 29 |
2500992 | 2500992 | 2022-05-13 | Yellow Medicine | Minnesota | 27173 | 2580 | 29 |
2501106 | 2501106 | 2022-05-13 | Daviess | Missouri | 29061 | 1730 | 29 |
2501204 | 2501204 | 2022-05-13 | Deer Lodge | Montana | 30023 | 2563 | 29 |
2501231 | 2501231 | 2022-05-13 | Powell | Montana | 30077 | 1869 | 29 |
2501356 | 2501356 | 2022-05-13 | Pershing | Nevada | 32027 | 2130 | 29 |
2501749 | 2501749 | 2022-05-13 | Cotton | Oklahoma | 40033 | 1464 | 29 |
2501829 | 2501829 | 2022-05-13 | Lake | Oregon | 41037 | 1429 | 29 |
2502228 | 2502228 | 2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 |
2502304 | 2502304 | 2022-05-13 | Hansford | Texas | 48195 | 1929 | 29 |
2502652 | 2502652 | 2022-05-13 | Ferry | Washington | 53019 | 1420 | 29 |
2502658 | 2502658 | 2022-05-13 | Jefferson | Washington | 53031 | 3198 | 29 |
2502762 | 2502762 | 2022-05-13 | Iowa | Wisconsin | 55049 | 5424 | 29 |
2502815 | 2502815 | 2022-05-13 | Crook | Wyoming | 56011 | 1351 | 29 |
2496748 | 2496748 | 2022-05-12 | Dade | Georgia | 13083 | 3393 | 29 |
2496872 | 2496872 | 2022-05-12 | Kauai | Hawaii | 15007 | 12864 | 29 |
2496895 | 2496895 | 2022-05-12 | Franklin | Idaho | 16041 | 2330 | 29 |
2496905 | 2496905 | 2022-05-12 | Lewis | Idaho | 16061 | 1134 | 29 |
2496942 | 2496942 | 2022-05-12 | Edwards | Illinois | 17047 | 1749 | 29 |
2496992 | 2496992 | 2022-05-12 | Piatt | Illinois | 17147 | 4570 | 29 |
2497002 | 2497002 | 2022-05-12 | Schuyler | Illinois | 17169 | 1975 | 29 |
2497216 | 2497216 | 2022-05-12 | Anderson | Kansas | 20003 | 2128 | 29 |
2497257 | 2497257 | 2022-05-12 | Jackson | Kansas | 20085 | 3903 | 29 |
2497324 | 2497324 | 2022-05-12 | Ballard | Kentucky | 21007 | 1387 | 29 |
2497683 | 2497683 | 2022-05-12 | Lac qui Parle | Minnesota | 27073 | 1760 | 29 |
2497734 | 2497734 | 2022-05-12 | Yellow Medicine | Minnesota | 27173 | 2576 | 29 |
2497848 | 2497848 | 2022-05-12 | Daviess | Missouri | 29061 | 1727 | 29 |
2497946 | 2497946 | 2022-05-12 | Deer Lodge | Montana | 30023 | 2560 | 29 |
2497973 | 2497973 | 2022-05-12 | Powell | Montana | 30077 | 1868 | 29 |
2498098 | 2498098 | 2022-05-12 | Pershing | Nevada | 32027 | 2130 | 29 |
2498491 | 2498491 | 2022-05-12 | Cotton | Oklahoma | 40033 | 1464 | 29 |
2498571 | 2498571 | 2022-05-12 | Lake | Oregon | 41037 | 1428 | 29 |
2498970 | 2498970 | 2022-05-12 | Brewster | Texas | 48043 | 1076 | 29 |
2499046 | 2499046 | 2022-05-12 | Hansford | Texas | 48195 | 1929 | 29 |
2499394 | 2499394 | 2022-05-12 | Ferry | Washington | 53019 | 1420 | 29 |
2499400 | 2499400 | 2022-05-12 | Jefferson | Washington | 53031 | 3180 | 29 |
2499504 | 2499504 | 2022-05-12 | Iowa | Wisconsin | 55049 | 5420 | 29 |
2499557 | 2499557 | 2022-05-12 | Crook | Wyoming | 56011 | 1351 | 29 |
2493490 | 2493490 | 2022-05-11 | Dade | Georgia | 13083 | 3393 | 29 |
2493614 | 2493614 | 2022-05-11 | Kauai | Hawaii | 15007 | 12864 | 29 |
2493637 | 2493637 | 2022-05-11 | Franklin | Idaho | 16041 | 2330 | 29 |
2493647 | 2493647 | 2022-05-11 | Lewis | Idaho | 16061 | 1134 | 29 |
2493684 | 2493684 | 2022-05-11 | Edwards | Illinois | 17047 | 1748 | 29 |
2493734 | 2493734 | 2022-05-11 | Piatt | Illinois | 17147 | 4563 | 29 |
2493744 | 2493744 | 2022-05-11 | Schuyler | Illinois | 17169 | 1971 | 29 |
2493958 | 2493958 | 2022-05-11 | Anderson | Kansas | 20003 | 2128 | 29 |
2493999 | 2493999 | 2022-05-11 | Jackson | Kansas | 20085 | 3903 | 29 |
2494066 | 2494066 | 2022-05-11 | Ballard | Kentucky | 21007 | 1387 | 29 |
2494425 | 2494425 | 2022-05-11 | Lac qui Parle | Minnesota | 27073 | 1760 | 29 |
2494476 | 2494476 | 2022-05-11 | Yellow Medicine | Minnesota | 27173 | 2570 | 29 |
2494590 | 2494590 | 2022-05-11 | Daviess | Missouri | 29061 | 1727 | 29 |
2494688 | 2494688 | 2022-05-11 | Deer Lodge | Montana | 30023 | 2560 | 29 |
2494715 | 2494715 | 2022-05-11 | Powell | Montana | 30077 | 1868 | 29 |
2494840 | 2494840 | 2022-05-11 | Pershing | Nevada | 32027 | 2130 | 29 |
2495233 | 2495233 | 2022-05-11 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2495313 | 2495313 | 2022-05-11 | Lake | Oregon | 41037 | 1426 | 29 |
2495712 | 2495712 | 2022-05-11 | Brewster | Texas | 48043 | 1074 | 29 |
2495788 | 2495788 | 2022-05-11 | Hansford | Texas | 48195 | 1929 | 29 |
2496136 | 2496136 | 2022-05-11 | Ferry | Washington | 53019 | 1420 | 29 |
2496142 | 2496142 | 2022-05-11 | Jefferson | Washington | 53031 | 3180 | 29 |
2496246 | 2496246 | 2022-05-11 | Iowa | Wisconsin | 55049 | 5406 | 29 |
2496299 | 2496299 | 2022-05-11 | Crook | Wyoming | 56011 | 1351 | 29 |
2489896 | 2489896 | 2022-05-10 | Unknown | American Samoa | 5904 | 29 | |
2490232 | 2490232 | 2022-05-10 | Dade | Georgia | 13083 | 3367 | 29 |
2490356 | 2490356 | 2022-05-10 | Kauai | Hawaii | 15007 | 12473 | 29 |
2490379 | 2490379 | 2022-05-10 | Franklin | Idaho | 16041 | 2330 | 29 |
2490389 | 2490389 | 2022-05-10 | Lewis | Idaho | 16061 | 1134 | 29 |
2490426 | 2490426 | 2022-05-10 | Edwards | Illinois | 17047 | 1747 | 29 |
2490476 | 2490476 | 2022-05-10 | Piatt | Illinois | 17147 | 4560 | 29 |
2490486 | 2490486 | 2022-05-10 | Schuyler | Illinois | 17169 | 1969 | 29 |
2490700 | 2490700 | 2022-05-10 | Anderson | Kansas | 20003 | 2128 | 29 |
2490741 | 2490741 | 2022-05-10 | Jackson | Kansas | 20085 | 3903 | 29 |
2490808 | 2490808 | 2022-05-10 | Ballard | Kentucky | 21007 | 1387 | 29 |
2491167 | 2491167 | 2022-05-10 | Lac qui Parle | Minnesota | 27073 | 1758 | 29 |
2491218 | 2491218 | 2022-05-10 | Yellow Medicine | Minnesota | 27173 | 2566 | 29 |
2491332 | 2491332 | 2022-05-10 | Daviess | Missouri | 29061 | 1727 | 29 |
2491430 | 2491430 | 2022-05-10 | Deer Lodge | Montana | 30023 | 2560 | 29 |
2491457 | 2491457 | 2022-05-10 | Powell | Montana | 30077 | 1868 | 29 |
2491582 | 2491582 | 2022-05-10 | Pershing | Nevada | 32027 | 2130 | 29 |
2491975 | 2491975 | 2022-05-10 | Cotton | Oklahoma | 40033 | 1462 | 29 |
2492055 | 2492055 | 2022-05-10 | Lake | Oregon | 41037 | 1425 | 29 |
2492454 | 2492454 | 2022-05-10 | Brewster | Texas | 48043 | 1070 | 29 |
2492530 | 2492530 | 2022-05-10 | Hansford | Texas | 48195 | 1929 | 29 |
2492878 | 2492878 | 2022-05-10 | Ferry | Washington | 53019 | 1419 | 29 |
2493041 | 2493041 | 2022-05-10 | Crook | Wyoming | 56011 | 1351 | 29 |
2486975 | 2486975 | 2022-05-09 | Dade | Georgia | 13083 | 3367 | 29 |
2487099 | 2487099 | 2022-05-09 | Kauai | Hawaii | 15007 | 12473 | 29 |
2487122 | 2487122 | 2022-05-09 | Franklin | Idaho | 16041 | 2330 | 29 |
2487132 | 2487132 | 2022-05-09 | Lewis | Idaho | 16061 | 1134 | 29 |
2487169 | 2487169 | 2022-05-09 | Edwards | Illinois | 17047 | 1746 | 29 |
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);