ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
22,696 rows where deaths = 18 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,711
- Kansas 1,350
- Virginia 1,247
- Nebraska 1,233
- Kentucky 1,087
- Minnesota 992
- Iowa 869
- Georgia 844
- North Carolina 825
- Missouri 816
- North Dakota 803
- South Dakota 755
- Montana 731
- Oklahoma 711
- Illinois 573
- Arkansas 553
- Colorado 550
- Mississippi 515
- Ohio 503
- West Virginia 495
- Indiana 477
- Idaho 461
- Michigan 433
- Wisconsin 414
- Tennessee 387
- California 326
- Oregon 310
- Wyoming 286
- Louisiana 273
- Alabama 270
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499832 | 2499832 | 2022-05-13 | Costilla | Colorado | 8023 | 708 | 18 |
2500206 | 2500206 | 2022-05-13 | Gallatin | Illinois | 17059 | 1415 | 18 |
2500540 | 2500540 | 2022-05-13 | Ness | Kansas | 20135 | 780 | 18 |
2500555 | 2500555 | 2022-05-13 | Rush | Kansas | 20165 | 808 | 18 |
2500562 | 2500562 | 2022-05-13 | Sheridan | Kansas | 20179 | 786 | 18 |
2500947 | 2500947 | 2022-05-13 | Mahnomen | Minnesota | 27087 | 1803 | 18 |
2501171 | 2501171 | 2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 |
2501260 | 2501260 | 2022-05-13 | Butler | Nebraska | 31023 | 1923 | 18 |
2501320 | 2501320 | 2022-05-13 | Polk | Nebraska | 31143 | 1198 | 18 |
2501412 | 2501412 | 2022-05-13 | Mora | New Mexico | 35033 | 772 | 18 |
2501600 | 2501600 | 2022-05-13 | Emmons | North Dakota | 38029 | 728 | 18 |
2501617 | 2501617 | 2022-05-13 | Nelson | North Dakota | 38063 | 768 | 18 |
2502052 | 2502052 | 2022-05-13 | Buffalo | South Dakota | 46017 | 620 | 18 |
2502097 | 2502097 | 2022-05-13 | Perkins | South Dakota | 46105 | 684 | 18 |
2502321 | 2502321 | 2022-05-13 | Hudspeth | Texas | 48229 | 989 | 18 |
2502438 | 2502438 | 2022-05-13 | Upton | Texas | 48461 | 833 | 18 |
2502492 | 2502492 | 2022-05-13 | Addison | Vermont | 50001 | 5939 | 18 |
2502539 | 2502539 | 2022-05-13 | Craig | Virginia | 51045 | 1128 | 18 |
2502691 | 2502691 | 2022-05-13 | Doddridge | West Virginia | 54017 | 2162 | 18 |
2502784 | 2502784 | 2022-05-13 | Pepin | Wisconsin | 55091 | 2001 | 18 |
2502832 | 2502832 | 2022-05-13 | Weston | Wyoming | 56045 | 1588 | 18 |
2496574 | 2496574 | 2022-05-12 | Costilla | Colorado | 8023 | 708 | 18 |
2496948 | 2496948 | 2022-05-12 | Gallatin | Illinois | 17059 | 1415 | 18 |
2497282 | 2497282 | 2022-05-12 | Ness | Kansas | 20135 | 780 | 18 |
2497297 | 2497297 | 2022-05-12 | Rush | Kansas | 20165 | 808 | 18 |
2497304 | 2497304 | 2022-05-12 | Sheridan | Kansas | 20179 | 786 | 18 |
2497913 | 2497913 | 2022-05-12 | Scotland | Missouri | 29199 | 680 | 18 |
2498002 | 2498002 | 2022-05-12 | Butler | Nebraska | 31023 | 1921 | 18 |
2498062 | 2498062 | 2022-05-12 | Polk | Nebraska | 31143 | 1197 | 18 |
2498154 | 2498154 | 2022-05-12 | Mora | New Mexico | 35033 | 772 | 18 |
2498342 | 2498342 | 2022-05-12 | Emmons | North Dakota | 38029 | 728 | 18 |
2498359 | 2498359 | 2022-05-12 | Nelson | North Dakota | 38063 | 765 | 18 |
2498794 | 2498794 | 2022-05-12 | Buffalo | South Dakota | 46017 | 620 | 18 |
2498839 | 2498839 | 2022-05-12 | Perkins | South Dakota | 46105 | 684 | 18 |
2499063 | 2499063 | 2022-05-12 | Hudspeth | Texas | 48229 | 989 | 18 |
2499180 | 2499180 | 2022-05-12 | Upton | Texas | 48461 | 833 | 18 |
2499234 | 2499234 | 2022-05-12 | Addison | Vermont | 50001 | 5922 | 18 |
2499281 | 2499281 | 2022-05-12 | Craig | Virginia | 51045 | 1128 | 18 |
2499433 | 2499433 | 2022-05-12 | Doddridge | West Virginia | 54017 | 2162 | 18 |
2499526 | 2499526 | 2022-05-12 | Pepin | Wisconsin | 55091 | 1999 | 18 |
2499574 | 2499574 | 2022-05-12 | Weston | Wyoming | 56045 | 1588 | 18 |
2493316 | 2493316 | 2022-05-11 | Costilla | Colorado | 8023 | 703 | 18 |
2493690 | 2493690 | 2022-05-11 | Gallatin | Illinois | 17059 | 1414 | 18 |
2494024 | 2494024 | 2022-05-11 | Ness | Kansas | 20135 | 780 | 18 |
2494039 | 2494039 | 2022-05-11 | Rush | Kansas | 20165 | 808 | 18 |
2494046 | 2494046 | 2022-05-11 | Sheridan | Kansas | 20179 | 786 | 18 |
2494416 | 2494416 | 2022-05-11 | Houston | Minnesota | 27055 | 4648 | 18 |
2494655 | 2494655 | 2022-05-11 | Scotland | Missouri | 29199 | 680 | 18 |
2494744 | 2494744 | 2022-05-11 | Butler | Nebraska | 31023 | 1921 | 18 |
2494804 | 2494804 | 2022-05-11 | Polk | Nebraska | 31143 | 1197 | 18 |
2494896 | 2494896 | 2022-05-11 | Mora | New Mexico | 35033 | 772 | 18 |
2495084 | 2495084 | 2022-05-11 | Emmons | North Dakota | 38029 | 728 | 18 |
2495101 | 2495101 | 2022-05-11 | Nelson | North Dakota | 38063 | 765 | 18 |
2495536 | 2495536 | 2022-05-11 | Buffalo | South Dakota | 46017 | 620 | 18 |
2495581 | 2495581 | 2022-05-11 | Perkins | South Dakota | 46105 | 684 | 18 |
2495805 | 2495805 | 2022-05-11 | Hudspeth | Texas | 48229 | 989 | 18 |
2495922 | 2495922 | 2022-05-11 | Upton | Texas | 48461 | 833 | 18 |
2495976 | 2495976 | 2022-05-11 | Addison | Vermont | 50001 | 5902 | 18 |
2496023 | 2496023 | 2022-05-11 | Craig | Virginia | 51045 | 1128 | 18 |
2496175 | 2496175 | 2022-05-11 | Doddridge | West Virginia | 54017 | 2158 | 18 |
2496268 | 2496268 | 2022-05-11 | Pepin | Wisconsin | 55091 | 1996 | 18 |
2496316 | 2496316 | 2022-05-11 | Weston | Wyoming | 56045 | 1588 | 18 |
2489892 | 2489892 | 2022-05-10 | Valdez-Cordova Census Area | Alaska | 2261 | 2925 | 18 |
2490058 | 2490058 | 2022-05-10 | Costilla | Colorado | 8023 | 703 | 18 |
2490432 | 2490432 | 2022-05-10 | Gallatin | Illinois | 17059 | 1412 | 18 |
2490766 | 2490766 | 2022-05-10 | Ness | Kansas | 20135 | 780 | 18 |
2490781 | 2490781 | 2022-05-10 | Rush | Kansas | 20165 | 808 | 18 |
2490788 | 2490788 | 2022-05-10 | Sheridan | Kansas | 20179 | 786 | 18 |
2491158 | 2491158 | 2022-05-10 | Houston | Minnesota | 27055 | 4640 | 18 |
2491397 | 2491397 | 2022-05-10 | Scotland | Missouri | 29199 | 680 | 18 |
2491486 | 2491486 | 2022-05-10 | Butler | Nebraska | 31023 | 1933 | 18 |
2491546 | 2491546 | 2022-05-10 | Polk | Nebraska | 31143 | 1250 | 18 |
2491638 | 2491638 | 2022-05-10 | Mora | New Mexico | 35033 | 771 | 18 |
2491826 | 2491826 | 2022-05-10 | Emmons | North Dakota | 38029 | 728 | 18 |
2491843 | 2491843 | 2022-05-10 | Nelson | North Dakota | 38063 | 765 | 18 |
2492278 | 2492278 | 2022-05-10 | Buffalo | South Dakota | 46017 | 620 | 18 |
2492323 | 2492323 | 2022-05-10 | Perkins | South Dakota | 46105 | 683 | 18 |
2492547 | 2492547 | 2022-05-10 | Hudspeth | Texas | 48229 | 989 | 18 |
2492664 | 2492664 | 2022-05-10 | Upton | Texas | 48461 | 833 | 18 |
2492718 | 2492718 | 2022-05-10 | Addison | Vermont | 50001 | 5886 | 18 |
2492765 | 2492765 | 2022-05-10 | Craig | Virginia | 51045 | 1127 | 18 |
2492917 | 2492917 | 2022-05-10 | Doddridge | West Virginia | 54017 | 2157 | 18 |
2493010 | 2493010 | 2022-05-10 | Pepin | Wisconsin | 55091 | 1994 | 18 |
2493058 | 2493058 | 2022-05-10 | Weston | Wyoming | 56045 | 1588 | 18 |
2486635 | 2486635 | 2022-05-09 | Valdez-Cordova Census Area | Alaska | 2261 | 2925 | 18 |
2487175 | 2487175 | 2022-05-09 | Gallatin | Illinois | 17059 | 1411 | 18 |
2487509 | 2487509 | 2022-05-09 | Ness | Kansas | 20135 | 780 | 18 |
2487524 | 2487524 | 2022-05-09 | Rush | Kansas | 20165 | 808 | 18 |
2487531 | 2487531 | 2022-05-09 | Sheridan | Kansas | 20179 | 786 | 18 |
2487901 | 2487901 | 2022-05-09 | Houston | Minnesota | 27055 | 4629 | 18 |
2488139 | 2488139 | 2022-05-09 | Scotland | Missouri | 29199 | 680 | 18 |
2488228 | 2488228 | 2022-05-09 | Butler | Nebraska | 31023 | 1933 | 18 |
2488288 | 2488288 | 2022-05-09 | Polk | Nebraska | 31143 | 1250 | 18 |
2488380 | 2488380 | 2022-05-09 | Mora | New Mexico | 35033 | 771 | 18 |
2488568 | 2488568 | 2022-05-09 | Emmons | North Dakota | 38029 | 728 | 18 |
2488585 | 2488585 | 2022-05-09 | Nelson | North Dakota | 38063 | 765 | 18 |
2489020 | 2489020 | 2022-05-09 | Buffalo | South Dakota | 46017 | 620 | 18 |
2489065 | 2489065 | 2022-05-09 | Perkins | South Dakota | 46105 | 683 | 18 |
2489289 | 2489289 | 2022-05-09 | Hudspeth | Texas | 48229 | 989 | 18 |
2489406 | 2489406 | 2022-05-09 | Upton | Texas | 48461 | 833 | 18 |
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);