ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
34,996 rows where deaths = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 2,845
- Kansas 2,561
- Virginia 2,148
- North Dakota 1,748
- Nebraska 1,615
- Oklahoma 1,394
- Missouri 1,378
- Georgia 1,360
- Montana 1,326
- Wisconsin 1,258
- Kentucky 1,057
- Illinois 981
- Colorado 965
- North Carolina 862
- Michigan 766
- Minnesota 759
- Indiana 719
- South Dakota 689
- Iowa 676
- Mississippi 658
- Tennessee 646
- Washington 642
- Arkansas 588
- California 562
- West Virginia 548
- Pennsylvania 502
- Utah 495
- Ohio 468
- Alabama 466
- Idaho 443
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499869 | 2499869 | 2022-05-13 | Pitkin | Colorado | 8097 | 6676 | 7 |
2500481 | 2500481 | 2022-05-13 | Chase | Kansas | 20017 | 673 | 7 |
2500521 | 2500521 | 2022-05-13 | Kiowa | Kansas | 20097 | 667 | 7 |
2500564 | 2500564 | 2022-05-13 | Smith | Kansas | 20183 | 645 | 7 |
2501256 | 2501256 | 2022-05-13 | Boyd | Nebraska | 31015 | 402 | 7 |
2501263 | 2501263 | 2022-05-13 | Chase | Nebraska | 31029 | 749 | 7 |
2501285 | 2501285 | 2022-05-13 | Gosper | Nebraska | 31073 | 381 | 7 |
2501296 | 2501296 | 2022-05-13 | Jefferson | Nebraska | 31095 | 1216 | 7 |
2501352 | 2501352 | 2022-05-13 | Lincoln | Nevada | 32017 | 550 | 7 |
2501595 | 2501595 | 2022-05-13 | Cavalier | North Dakota | 38019 | 822 | 7 |
2501627 | 2501627 | 2022-05-13 | Sheridan | North Dakota | 38083 | 299 | 7 |
2501745 | 2501745 | 2022-05-13 | Cimarron | Oklahoma | 40025 | 566 | 7 |
2502054 | 2502054 | 2022-05-13 | Campbell | South Dakota | 46021 | 268 | 7 |
2502098 | 2502098 | 2022-05-13 | Potter | South Dakota | 46107 | 703 | 7 |
2502102 | 2502102 | 2022-05-13 | Stanley | South Dakota | 46117 | 637 | 7 |
2502312 | 2502312 | 2022-05-13 | Hemphill | Texas | 48211 | 1239 | 7 |
2502424 | 2502424 | 2022-05-13 | Stonewall | Texas | 48433 | 362 | 7 |
2502477 | 2502477 | 2022-05-13 | Piute | Utah | 49031 | 304 | 7 |
2502570 | 2502570 | 2022-05-13 | Highland | Virginia | 51091 | 387 | 7 |
2502654 | 2502654 | 2022-05-13 | Garfield | Washington | 53023 | 389 | 7 |
2502678 | 2502678 | 2022-05-13 | Wahkiakum | Washington | 53069 | 537 | 7 |
2496611 | 2496611 | 2022-05-12 | Pitkin | Colorado | 8097 | 6671 | 7 |
2497223 | 2497223 | 2022-05-12 | Chase | Kansas | 20017 | 673 | 7 |
2497263 | 2497263 | 2022-05-12 | Kiowa | Kansas | 20097 | 666 | 7 |
2497306 | 2497306 | 2022-05-12 | Smith | Kansas | 20183 | 645 | 7 |
2497998 | 2497998 | 2022-05-12 | Boyd | Nebraska | 31015 | 402 | 7 |
2498005 | 2498005 | 2022-05-12 | Chase | Nebraska | 31029 | 748 | 7 |
2498027 | 2498027 | 2022-05-12 | Gosper | Nebraska | 31073 | 381 | 7 |
2498038 | 2498038 | 2022-05-12 | Jefferson | Nebraska | 31095 | 1215 | 7 |
2498094 | 2498094 | 2022-05-12 | Lincoln | Nevada | 32017 | 550 | 7 |
2498337 | 2498337 | 2022-05-12 | Cavalier | North Dakota | 38019 | 820 | 7 |
2498369 | 2498369 | 2022-05-12 | Sheridan | North Dakota | 38083 | 298 | 7 |
2498487 | 2498487 | 2022-05-12 | Cimarron | Oklahoma | 40025 | 566 | 7 |
2498796 | 2498796 | 2022-05-12 | Campbell | South Dakota | 46021 | 268 | 7 |
2498840 | 2498840 | 2022-05-12 | Potter | South Dakota | 46107 | 703 | 7 |
2498844 | 2498844 | 2022-05-12 | Stanley | South Dakota | 46117 | 637 | 7 |
2499054 | 2499054 | 2022-05-12 | Hemphill | Texas | 48211 | 1238 | 7 |
2499166 | 2499166 | 2022-05-12 | Stonewall | Texas | 48433 | 362 | 7 |
2499219 | 2499219 | 2022-05-12 | Piute | Utah | 49031 | 304 | 7 |
2499312 | 2499312 | 2022-05-12 | Highland | Virginia | 51091 | 387 | 7 |
2499396 | 2499396 | 2022-05-12 | Garfield | Washington | 53023 | 389 | 7 |
2499420 | 2499420 | 2022-05-12 | Wahkiakum | Washington | 53069 | 537 | 7 |
2493353 | 2493353 | 2022-05-11 | Pitkin | Colorado | 8097 | 6631 | 7 |
2493965 | 2493965 | 2022-05-11 | Chase | Kansas | 20017 | 673 | 7 |
2494005 | 2494005 | 2022-05-11 | Kiowa | Kansas | 20097 | 666 | 7 |
2494048 | 2494048 | 2022-05-11 | Smith | Kansas | 20183 | 645 | 7 |
2494740 | 2494740 | 2022-05-11 | Boyd | Nebraska | 31015 | 402 | 7 |
2494747 | 2494747 | 2022-05-11 | Chase | Nebraska | 31029 | 748 | 7 |
2494769 | 2494769 | 2022-05-11 | Gosper | Nebraska | 31073 | 381 | 7 |
2494780 | 2494780 | 2022-05-11 | Jefferson | Nebraska | 31095 | 1215 | 7 |
2494836 | 2494836 | 2022-05-11 | Lincoln | Nevada | 32017 | 550 | 7 |
2495079 | 2495079 | 2022-05-11 | Cavalier | North Dakota | 38019 | 820 | 7 |
2495111 | 2495111 | 2022-05-11 | Sheridan | North Dakota | 38083 | 298 | 7 |
2495208 | 2495208 | 2022-05-11 | Unknown | Ohio | 0 | 7 | |
2495229 | 2495229 | 2022-05-11 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2495538 | 2495538 | 2022-05-11 | Campbell | South Dakota | 46021 | 268 | 7 |
2495582 | 2495582 | 2022-05-11 | Potter | South Dakota | 46107 | 703 | 7 |
2495586 | 2495586 | 2022-05-11 | Stanley | South Dakota | 46117 | 637 | 7 |
2495796 | 2495796 | 2022-05-11 | Hemphill | Texas | 48211 | 1238 | 7 |
2495908 | 2495908 | 2022-05-11 | Stonewall | Texas | 48433 | 362 | 7 |
2495961 | 2495961 | 2022-05-11 | Piute | Utah | 49031 | 304 | 7 |
2496054 | 2496054 | 2022-05-11 | Highland | Virginia | 51091 | 384 | 7 |
2496138 | 2496138 | 2022-05-11 | Garfield | Washington | 53023 | 389 | 7 |
2496162 | 2496162 | 2022-05-11 | Wahkiakum | Washington | 53069 | 537 | 7 |
2490095 | 2490095 | 2022-05-10 | Pitkin | Colorado | 8097 | 6624 | 7 |
2490707 | 2490707 | 2022-05-10 | Chase | Kansas | 20017 | 673 | 7 |
2490747 | 2490747 | 2022-05-10 | Kiowa | Kansas | 20097 | 666 | 7 |
2490790 | 2490790 | 2022-05-10 | Smith | Kansas | 20183 | 645 | 7 |
2491482 | 2491482 | 2022-05-10 | Boyd | Nebraska | 31015 | 410 | 7 |
2491489 | 2491489 | 2022-05-10 | Chase | Nebraska | 31029 | 745 | 7 |
2491511 | 2491511 | 2022-05-10 | Gosper | Nebraska | 31073 | 379 | 7 |
2491522 | 2491522 | 2022-05-10 | Jefferson | Nebraska | 31095 | 1209 | 7 |
2491578 | 2491578 | 2022-05-10 | Lincoln | Nevada | 32017 | 548 | 7 |
2491821 | 2491821 | 2022-05-10 | Cavalier | North Dakota | 38019 | 820 | 7 |
2491853 | 2491853 | 2022-05-10 | Sheridan | North Dakota | 38083 | 298 | 7 |
2491950 | 2491950 | 2022-05-10 | Unknown | Ohio | 0 | 7 | |
2491971 | 2491971 | 2022-05-10 | Cimarron | Oklahoma | 40025 | 565 | 7 |
2492280 | 2492280 | 2022-05-10 | Campbell | South Dakota | 46021 | 268 | 7 |
2492324 | 2492324 | 2022-05-10 | Potter | South Dakota | 46107 | 704 | 7 |
2492328 | 2492328 | 2022-05-10 | Stanley | South Dakota | 46117 | 637 | 7 |
2492538 | 2492538 | 2022-05-10 | Hemphill | Texas | 48211 | 1236 | 7 |
2492650 | 2492650 | 2022-05-10 | Stonewall | Texas | 48433 | 362 | 7 |
2492703 | 2492703 | 2022-05-10 | Piute | Utah | 49031 | 304 | 7 |
2492796 | 2492796 | 2022-05-10 | Highland | Virginia | 51091 | 384 | 7 |
2492880 | 2492880 | 2022-05-10 | Garfield | Washington | 53023 | 389 | 7 |
2492904 | 2492904 | 2022-05-10 | Wahkiakum | Washington | 53069 | 537 | 7 |
2486838 | 2486838 | 2022-05-09 | Pitkin | Colorado | 8097 | 6623 | 7 |
2487450 | 2487450 | 2022-05-09 | Chase | Kansas | 20017 | 673 | 7 |
2487490 | 2487490 | 2022-05-09 | Kiowa | Kansas | 20097 | 666 | 7 |
2487533 | 2487533 | 2022-05-09 | Smith | Kansas | 20183 | 645 | 7 |
2488224 | 2488224 | 2022-05-09 | Boyd | Nebraska | 31015 | 410 | 7 |
2488231 | 2488231 | 2022-05-09 | Chase | Nebraska | 31029 | 745 | 7 |
2488253 | 2488253 | 2022-05-09 | Gosper | Nebraska | 31073 | 379 | 7 |
2488264 | 2488264 | 2022-05-09 | Jefferson | Nebraska | 31095 | 1209 | 7 |
2488320 | 2488320 | 2022-05-09 | Lincoln | Nevada | 32017 | 548 | 7 |
2488326 | 2488326 | 2022-05-09 | Unknown | Nevada | 7418 | 7 | |
2488563 | 2488563 | 2022-05-09 | Cavalier | North Dakota | 38019 | 820 | 7 |
2488595 | 2488595 | 2022-05-09 | Sheridan | North Dakota | 38083 | 298 | 7 |
2488692 | 2488692 | 2022-05-09 | Unknown | Ohio | 0 | 7 | |
2488713 | 2488713 | 2022-05-09 | Cimarron | Oklahoma | 40025 | 565 | 7 |
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);