ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,059 rows where deaths = 133 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 302
- Georgia 257
- Ohio 182
- North Carolina 170
- Mississippi 168
- Louisiana 155
- Oklahoma 127
- Pennsylvania 112
- Michigan 103
- Missouri 100
- Virginia 97
- Kentucky 95
- South Carolina 92
- New York 89
- Illinois 87
- Washington 80
- Tennessee 75
- Wisconsin 75
- Indiana 73
- Alabama 68
- Florida 61
- West Virginia 61
- Arkansas 53
- Iowa 48
- Kansas 40
- Minnesota 39
- California 33
- New Mexico 24
- Maryland 21
- Oregon 20
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500076 | 2500076 | 2022-05-13 | Peach | Georgia | 13225 | 6239 | 133 |
2496818 | 2496818 | 2022-05-12 | Peach | Georgia | 13225 | 6239 | 133 |
2497873 | 2497873 | 2022-05-12 | Lafayette | Missouri | 29107 | 7814 | 133 |
2493560 | 2493560 | 2022-05-11 | Peach | Georgia | 13225 | 6239 | 133 |
2494615 | 2494615 | 2022-05-11 | Lafayette | Missouri | 29107 | 7814 | 133 |
2490302 | 2490302 | 2022-05-10 | Peach | Georgia | 13225 | 6216 | 133 |
2491357 | 2491357 | 2022-05-10 | Lafayette | Missouri | 29107 | 7814 | 133 |
2487045 | 2487045 | 2022-05-09 | Peach | Georgia | 13225 | 6216 | 133 |
2488099 | 2488099 | 2022-05-09 | Lafayette | Missouri | 29107 | 7814 | 133 |
2483787 | 2483787 | 2022-05-08 | Peach | Georgia | 13225 | 6216 | 133 |
2484332 | 2484332 | 2022-05-08 | Grayson | Kentucky | 21085 | 8008 | 133 |
2484842 | 2484842 | 2022-05-08 | Lafayette | Missouri | 29107 | 7814 | 133 |
2480529 | 2480529 | 2022-05-07 | Peach | Georgia | 13225 | 6216 | 133 |
2481074 | 2481074 | 2022-05-07 | Grayson | Kentucky | 21085 | 8008 | 133 |
2481584 | 2481584 | 2022-05-07 | Lafayette | Missouri | 29107 | 7814 | 133 |
2477271 | 2477271 | 2022-05-06 | Peach | Georgia | 13225 | 6216 | 133 |
2477816 | 2477816 | 2022-05-06 | Grayson | Kentucky | 21085 | 8008 | 133 |
2478326 | 2478326 | 2022-05-06 | Lafayette | Missouri | 29107 | 7814 | 133 |
2474013 | 2474013 | 2022-05-05 | Peach | Georgia | 13225 | 6216 | 133 |
2474558 | 2474558 | 2022-05-05 | Grayson | Kentucky | 21085 | 8008 | 133 |
2475068 | 2475068 | 2022-05-05 | Lafayette | Missouri | 29107 | 7805 | 133 |
2476730 | 2476730 | 2022-05-05 | Sauk | Wisconsin | 55111 | 16229 | 133 |
2470756 | 2470756 | 2022-05-04 | Peach | Georgia | 13225 | 6216 | 133 |
2471301 | 2471301 | 2022-05-04 | Grayson | Kentucky | 21085 | 8008 | 133 |
2472372 | 2472372 | 2022-05-04 | Madison | Ohio | 39097 | 9708 | 133 |
2472459 | 2472459 | 2022-05-04 | McClain | Oklahoma | 40087 | 11655 | 133 |
2473472 | 2473472 | 2022-05-04 | Sauk | Wisconsin | 55111 | 16188 | 133 |
2467416 | 2467416 | 2022-05-03 | Chattooga | Georgia | 13055 | 6676 | 133 |
2467500 | 2467500 | 2022-05-03 | Peach | Georgia | 13225 | 6185 | 133 |
2468045 | 2468045 | 2022-05-03 | Grayson | Kentucky | 21085 | 8008 | 133 |
2468911 | 2468911 | 2022-05-03 | Alexander | North Carolina | 37003 | 10432 | 133 |
2469116 | 2469116 | 2022-05-03 | Madison | Ohio | 39097 | 9708 | 133 |
2469203 | 2469203 | 2022-05-03 | McClain | Oklahoma | 40087 | 11655 | 133 |
2470215 | 2470215 | 2022-05-03 | Sauk | Wisconsin | 55111 | 16152 | 133 |
2464161 | 2464161 | 2022-05-02 | Chattooga | Georgia | 13055 | 6676 | 133 |
2464245 | 2464245 | 2022-05-02 | Peach | Georgia | 13225 | 6185 | 133 |
2464790 | 2464790 | 2022-05-02 | Grayson | Kentucky | 21085 | 8008 | 133 |
2465655 | 2465655 | 2022-05-02 | Alexander | North Carolina | 37003 | 10432 | 133 |
2465860 | 2465860 | 2022-05-02 | Madison | Ohio | 39097 | 9708 | 133 |
2465947 | 2465947 | 2022-05-02 | McClain | Oklahoma | 40087 | 11655 | 133 |
2466959 | 2466959 | 2022-05-02 | Sauk | Wisconsin | 55111 | 16141 | 133 |
2460905 | 2460905 | 2022-05-01 | Chattooga | Georgia | 13055 | 6676 | 133 |
2460989 | 2460989 | 2022-05-01 | Peach | Georgia | 13225 | 6187 | 133 |
2461560 | 2461560 | 2022-05-01 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2461842 | 2461842 | 2022-05-01 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2462400 | 2462400 | 2022-05-01 | Alexander | North Carolina | 37003 | 10432 | 133 |
2462605 | 2462605 | 2022-05-01 | Madison | Ohio | 39097 | 9708 | 133 |
2462692 | 2462692 | 2022-05-01 | McClain | Oklahoma | 40087 | 11655 | 133 |
2462750 | 2462750 | 2022-05-01 | Polk | Oregon | 41053 | 15491 | 133 |
2463704 | 2463704 | 2022-05-01 | Sauk | Wisconsin | 55111 | 16108 | 133 |
2457649 | 2457649 | 2022-04-30 | Chattooga | Georgia | 13055 | 6676 | 133 |
2457733 | 2457733 | 2022-04-30 | Peach | Georgia | 13225 | 6187 | 133 |
2458304 | 2458304 | 2022-04-30 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2458586 | 2458586 | 2022-04-30 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2459144 | 2459144 | 2022-04-30 | Alexander | North Carolina | 37003 | 10432 | 133 |
2459349 | 2459349 | 2022-04-30 | Madison | Ohio | 39097 | 9708 | 133 |
2459436 | 2459436 | 2022-04-30 | McClain | Oklahoma | 40087 | 11655 | 133 |
2459494 | 2459494 | 2022-04-30 | Polk | Oregon | 41053 | 15491 | 133 |
2460448 | 2460448 | 2022-04-30 | Sauk | Wisconsin | 55111 | 16108 | 133 |
2454393 | 2454393 | 2022-04-29 | Chattooga | Georgia | 13055 | 6676 | 133 |
2454477 | 2454477 | 2022-04-29 | Peach | Georgia | 13225 | 6187 | 133 |
2455048 | 2455048 | 2022-04-29 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2455330 | 2455330 | 2022-04-29 | Goodhue | Minnesota | 27049 | 13341 | 133 |
2455888 | 2455888 | 2022-04-29 | Alexander | North Carolina | 37003 | 10432 | 133 |
2456093 | 2456093 | 2022-04-29 | Madison | Ohio | 39097 | 9708 | 133 |
2456180 | 2456180 | 2022-04-29 | McClain | Oklahoma | 40087 | 11655 | 133 |
2456238 | 2456238 | 2022-04-29 | Polk | Oregon | 41053 | 15491 | 133 |
2457192 | 2457192 | 2022-04-29 | Sauk | Wisconsin | 55111 | 16108 | 133 |
2451137 | 2451137 | 2022-04-28 | Chattooga | Georgia | 13055 | 6676 | 133 |
2451221 | 2451221 | 2022-04-28 | Peach | Georgia | 13225 | 6187 | 133 |
2451792 | 2451792 | 2022-04-28 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2452074 | 2452074 | 2022-04-28 | Goodhue | Minnesota | 27049 | 13308 | 133 |
2452632 | 2452632 | 2022-04-28 | Alexander | North Carolina | 37003 | 10432 | 133 |
2452837 | 2452837 | 2022-04-28 | Madison | Ohio | 39097 | 9708 | 133 |
2452924 | 2452924 | 2022-04-28 | McClain | Oklahoma | 40087 | 11655 | 133 |
2452982 | 2452982 | 2022-04-28 | Polk | Oregon | 41053 | 15478 | 133 |
2453936 | 2453936 | 2022-04-28 | Sauk | Wisconsin | 55111 | 16086 | 133 |
2447881 | 2447881 | 2022-04-27 | Chattooga | Georgia | 13055 | 6676 | 133 |
2447965 | 2447965 | 2022-04-27 | Peach | Georgia | 13225 | 6187 | 133 |
2448536 | 2448536 | 2022-04-27 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2448818 | 2448818 | 2022-04-27 | Goodhue | Minnesota | 27049 | 13283 | 133 |
2449304 | 2449304 | 2022-04-27 | Rio Arriba | New Mexico | 35039 | 9836 | 133 |
2449376 | 2449376 | 2022-04-27 | Alexander | North Carolina | 37003 | 10432 | 133 |
2449668 | 2449668 | 2022-04-27 | McClain | Oklahoma | 40087 | 11650 | 133 |
2449726 | 2449726 | 2022-04-27 | Polk | Oregon | 41053 | 15460 | 133 |
2450680 | 2450680 | 2022-04-27 | Sauk | Wisconsin | 55111 | 16063 | 133 |
2444709 | 2444709 | 2022-04-26 | Peach | Georgia | 13225 | 6171 | 133 |
2445280 | 2445280 | 2022-04-26 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2445387 | 2445387 | 2022-04-26 | Union | Louisiana | 22111 | 6914 | 133 |
2445562 | 2445562 | 2022-04-26 | Goodhue | Minnesota | 27049 | 13271 | 133 |
2446047 | 2446047 | 2022-04-26 | Rio Arriba | New Mexico | 35039 | 9836 | 133 |
2446119 | 2446119 | 2022-04-26 | Alexander | North Carolina | 37003 | 10419 | 133 |
2446411 | 2446411 | 2022-04-26 | McClain | Oklahoma | 40087 | 11650 | 133 |
2446887 | 2446887 | 2022-04-26 | Cooke | Texas | 48097 | 7343 | 133 |
2447424 | 2447424 | 2022-04-26 | Sauk | Wisconsin | 55111 | 16052 | 133 |
2441453 | 2441453 | 2022-04-25 | Peach | Georgia | 13225 | 6171 | 133 |
2442024 | 2442024 | 2022-04-25 | Lincoln | Kentucky | 21137 | 6452 | 133 |
2442131 | 2442131 | 2022-04-25 | Union | Louisiana | 22111 | 6914 | 133 |
2442306 | 2442306 | 2022-04-25 | Goodhue | Minnesota | 27049 | 13234 | 133 |
2442792 | 2442792 | 2022-04-25 | Rio Arriba | New Mexico | 35039 | 9836 | 133 |
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);