ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,327 rows where deaths = 43 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 52
- Texas 924
- Iowa 870
- Georgia 843
- Arkansas 603
- Missouri 596
- Michigan 579
- Virginia 570
- Indiana 520
- Kentucky 498
- Illinois 493
- North Carolina 471
- South Dakota 459
- Minnesota 458
- Mississippi 457
- Wisconsin 442
- Kansas 401
- Tennessee 401
- Alabama 347
- Louisiana 321
- Ohio 268
- South Carolina 244
- Oklahoma 231
- Idaho 223
- Florida 211
- California 202
- West Virginia 180
- New York 127
- Washington 126
- Oregon 116
- Utah 112
- New Mexico 110
- Wyoming 107
- Nebraska 106
- North Dakota 106
- Colorado 100
- Pennsylvania 84
- Montana 78
- Maryland 67
- Rhode Island 67
- Maine 56
- Alaska 32
- New Hampshire 28
- Vermont 20
- Virgin Islands 19
- Hawaii 15
- Nevada 15
- Arizona 8
- Massachusetts 5
- New Jersey 5
- Connecticut 3
- Delaware 2
- Puerto Rico 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499744 | 2499744 | 2022-05-13 | Prairie | Arkansas | 5117 | 1965 | 43 |
2499748 | 2499748 | 2022-05-13 | Scott | Arkansas | 5127 | 2299 | 43 |
2499856 | 2499856 | 2022-05-13 | Las Animas | Colorado | 8071 | 3635 | 43 |
2500529 | 2500529 | 2022-05-13 | Marion | Kansas | 20115 | 3337 | 43 |
2500576 | 2500576 | 2022-05-13 | Wilson | Kansas | 20205 | 2828 | 43 |
2500688 | 2500688 | 2022-05-13 | Todd | Kentucky | 21219 | 2982 | 43 |
2501146 | 2501146 | 2022-05-13 | Monroe | Missouri | 29137 | 2180 | 43 |
2501572 | 2501572 | 2022-05-13 | Swain | North Carolina | 37173 | 3715 | 43 |
2501625 | 2501625 | 2022-05-13 | Rolette | North Dakota | 38079 | 6121 | 43 |
2501738 | 2501738 | 2022-05-13 | Blaine | Oklahoma | 40011 | 2461 | 43 |
2502158 | 2502158 | 2022-05-13 | Lake | Tennessee | 47095 | 2749 | 43 |
2502548 | 2502548 | 2022-05-13 | Fairfax city | Virginia | 51600 | 2056 | 43 |
2502575 | 2502575 | 2022-05-13 | King William | Virginia | 51101 | 3767 | 43 |
2502686 | 2502686 | 2022-05-13 | Braxton | West Virginia | 54007 | 3940 | 43 |
2502744 | 2502744 | 2022-05-13 | Burnett | Wisconsin | 55013 | 4062 | 43 |
2502764 | 2502764 | 2022-05-13 | Jackson | Wisconsin | 55053 | 5736 | 43 |
2496486 | 2496486 | 2022-05-12 | Prairie | Arkansas | 5117 | 1964 | 43 |
2496490 | 2496490 | 2022-05-12 | Scott | Arkansas | 5127 | 2298 | 43 |
2496598 | 2496598 | 2022-05-12 | Las Animas | Colorado | 8071 | 3634 | 43 |
2497271 | 2497271 | 2022-05-12 | Marion | Kansas | 20115 | 3336 | 43 |
2497318 | 2497318 | 2022-05-12 | Wilson | Kansas | 20205 | 2826 | 43 |
2497430 | 2497430 | 2022-05-12 | Todd | Kentucky | 21219 | 2982 | 43 |
2497888 | 2497888 | 2022-05-12 | Monroe | Missouri | 29137 | 2179 | 43 |
2498080 | 2498080 | 2022-05-12 | Washington | Nebraska | 31177 | 4575 | 43 |
2498314 | 2498314 | 2022-05-12 | Swain | North Carolina | 37173 | 3715 | 43 |
2498367 | 2498367 | 2022-05-12 | Rolette | North Dakota | 38079 | 6095 | 43 |
2498480 | 2498480 | 2022-05-12 | Blaine | Oklahoma | 40011 | 2461 | 43 |
2498566 | 2498566 | 2022-05-12 | Hood River | Oregon | 41027 | 3683 | 43 |
2498900 | 2498900 | 2022-05-12 | Lake | Tennessee | 47095 | 2749 | 43 |
2499290 | 2499290 | 2022-05-12 | Fairfax city | Virginia | 51600 | 2055 | 43 |
2499428 | 2499428 | 2022-05-12 | Braxton | West Virginia | 54007 | 3937 | 43 |
2499486 | 2499486 | 2022-05-12 | Burnett | Wisconsin | 55013 | 4052 | 43 |
2499506 | 2499506 | 2022-05-12 | Jackson | Wisconsin | 55053 | 5731 | 43 |
2493228 | 2493228 | 2022-05-11 | Prairie | Arkansas | 5117 | 1964 | 43 |
2493232 | 2493232 | 2022-05-11 | Scott | Arkansas | 5127 | 2298 | 43 |
2493340 | 2493340 | 2022-05-11 | Las Animas | Colorado | 8071 | 3623 | 43 |
2494013 | 2494013 | 2022-05-11 | Marion | Kansas | 20115 | 3336 | 43 |
2494060 | 2494060 | 2022-05-11 | Wilson | Kansas | 20205 | 2826 | 43 |
2494172 | 2494172 | 2022-05-11 | Todd | Kentucky | 21219 | 2982 | 43 |
2494630 | 2494630 | 2022-05-11 | Monroe | Missouri | 29137 | 2179 | 43 |
2494822 | 2494822 | 2022-05-11 | Washington | Nebraska | 31177 | 4575 | 43 |
2495056 | 2495056 | 2022-05-11 | Swain | North Carolina | 37173 | 3715 | 43 |
2495109 | 2495109 | 2022-05-11 | Rolette | North Dakota | 38079 | 6095 | 43 |
2495308 | 2495308 | 2022-05-11 | Hood River | Oregon | 41027 | 3677 | 43 |
2495642 | 2495642 | 2022-05-11 | Lake | Tennessee | 47095 | 2749 | 43 |
2496032 | 2496032 | 2022-05-11 | Fairfax city | Virginia | 51600 | 2049 | 43 |
2496170 | 2496170 | 2022-05-11 | Braxton | West Virginia | 54007 | 3937 | 43 |
2496228 | 2496228 | 2022-05-11 | Burnett | Wisconsin | 55013 | 4047 | 43 |
2496248 | 2496248 | 2022-05-11 | Jackson | Wisconsin | 55053 | 5726 | 43 |
2489970 | 2489970 | 2022-05-10 | Prairie | Arkansas | 5117 | 1964 | 43 |
2489974 | 2489974 | 2022-05-10 | Scott | Arkansas | 5127 | 2298 | 43 |
2490082 | 2490082 | 2022-05-10 | Las Animas | Colorado | 8071 | 3623 | 43 |
2490755 | 2490755 | 2022-05-10 | Marion | Kansas | 20115 | 3336 | 43 |
2490802 | 2490802 | 2022-05-10 | Wilson | Kansas | 20205 | 2826 | 43 |
2490914 | 2490914 | 2022-05-10 | Todd | Kentucky | 21219 | 2982 | 43 |
2491372 | 2491372 | 2022-05-10 | Monroe | Missouri | 29137 | 2179 | 43 |
2491564 | 2491564 | 2022-05-10 | Washington | Nebraska | 31177 | 4598 | 43 |
2491798 | 2491798 | 2022-05-10 | Swain | North Carolina | 37173 | 3662 | 43 |
2491851 | 2491851 | 2022-05-10 | Rolette | North Dakota | 38079 | 6095 | 43 |
2492050 | 2492050 | 2022-05-10 | Hood River | Oregon | 41027 | 3667 | 43 |
2492384 | 2492384 | 2022-05-10 | Lake | Tennessee | 47095 | 2749 | 43 |
2492774 | 2492774 | 2022-05-10 | Fairfax city | Virginia | 51600 | 2047 | 43 |
2492912 | 2492912 | 2022-05-10 | Braxton | West Virginia | 54007 | 3934 | 43 |
2492970 | 2492970 | 2022-05-10 | Burnett | Wisconsin | 55013 | 4038 | 43 |
2492990 | 2492990 | 2022-05-10 | Jackson | Wisconsin | 55053 | 5719 | 43 |
2486713 | 2486713 | 2022-05-09 | Prairie | Arkansas | 5117 | 1963 | 43 |
2486717 | 2486717 | 2022-05-09 | Scott | Arkansas | 5127 | 2297 | 43 |
2486825 | 2486825 | 2022-05-09 | Las Animas | Colorado | 8071 | 3622 | 43 |
2487498 | 2487498 | 2022-05-09 | Marion | Kansas | 20115 | 3336 | 43 |
2487545 | 2487545 | 2022-05-09 | Wilson | Kansas | 20205 | 2826 | 43 |
2487657 | 2487657 | 2022-05-09 | Todd | Kentucky | 21219 | 2982 | 43 |
2488114 | 2488114 | 2022-05-09 | Monroe | Missouri | 29137 | 2179 | 43 |
2488306 | 2488306 | 2022-05-09 | Washington | Nebraska | 31177 | 4598 | 43 |
2488540 | 2488540 | 2022-05-09 | Swain | North Carolina | 37173 | 3662 | 43 |
2488593 | 2488593 | 2022-05-09 | Rolette | North Dakota | 38079 | 6095 | 43 |
2488792 | 2488792 | 2022-05-09 | Hood River | Oregon | 41027 | 3659 | 43 |
2489126 | 2489126 | 2022-05-09 | Lake | Tennessee | 47095 | 2749 | 43 |
2489413 | 2489413 | 2022-05-09 | Ward | Texas | 48475 | 2829 | 43 |
2489516 | 2489516 | 2022-05-09 | Fairfax city | Virginia | 51600 | 2043 | 43 |
2489654 | 2489654 | 2022-05-09 | Braxton | West Virginia | 54007 | 3934 | 43 |
2489712 | 2489712 | 2022-05-09 | Burnett | Wisconsin | 55013 | 4033 | 43 |
2489732 | 2489732 | 2022-05-09 | Jackson | Wisconsin | 55053 | 5715 | 43 |
2483455 | 2483455 | 2022-05-08 | Prairie | Arkansas | 5117 | 1963 | 43 |
2483459 | 2483459 | 2022-05-08 | Scott | Arkansas | 5127 | 2297 | 43 |
2483567 | 2483567 | 2022-05-08 | Las Animas | Colorado | 8071 | 3616 | 43 |
2484240 | 2484240 | 2022-05-08 | Marion | Kansas | 20115 | 3336 | 43 |
2484287 | 2484287 | 2022-05-08 | Wilson | Kansas | 20205 | 2826 | 43 |
2484388 | 2484388 | 2022-05-08 | Powell | Kentucky | 21197 | 4775 | 43 |
2484399 | 2484399 | 2022-05-08 | Todd | Kentucky | 21219 | 2987 | 43 |
2484857 | 2484857 | 2022-05-08 | Monroe | Missouri | 29137 | 2179 | 43 |
2485049 | 2485049 | 2022-05-08 | Washington | Nebraska | 31177 | 4595 | 43 |
2485283 | 2485283 | 2022-05-08 | Swain | North Carolina | 37173 | 3662 | 43 |
2485336 | 2485336 | 2022-05-08 | Rolette | North Dakota | 38079 | 6095 | 43 |
2485535 | 2485535 | 2022-05-08 | Hood River | Oregon | 41027 | 3648 | 43 |
2485869 | 2485869 | 2022-05-08 | Lake | Tennessee | 47095 | 2749 | 43 |
2486155 | 2486155 | 2022-05-08 | Ward | Texas | 48475 | 2829 | 43 |
2486259 | 2486259 | 2022-05-08 | Fairfax city | Virginia | 51600 | 2033 | 43 |
2486397 | 2486397 | 2022-05-08 | Braxton | West Virginia | 54007 | 3927 | 43 |
2486455 | 2486455 | 2022-05-08 | Burnett | Wisconsin | 55013 | 4024 | 43 |
2486475 | 2486475 | 2022-05-08 | Jackson | Wisconsin | 55053 | 5706 | 43 |
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);