ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32,560 rows where deaths = 9 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 3,084
- Kansas 2,255
- South Dakota 1,790
- Virginia 1,656
- Nebraska 1,393
- Minnesota 1,328
- Georgia 1,299
- Kentucky 1,297
- Missouri 1,267
- Iowa 1,049
- Idaho 979
- North Dakota 950
- North Carolina 899
- Montana 897
- West Virginia 838
- Colorado 792
- Arkansas 681
- Oklahoma 670
- Utah 628
- New Mexico 591
- Mississippi 559
- Alabama 515
- Michigan 490
- Tennessee 481
- Ohio 477
- Wyoming 451
- Washington 441
- Illinois 421
- Indiana 411
- Alaska 399
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499829 | 2499829 | 2022-05-13 | Cheyenne | Colorado | 8017 | 322 | 9 |
2499857 | 2499857 | 2022-05-13 | Lincoln | Colorado | 8073 | 2199 | 9 |
2500132 | 2500132 | 2022-05-13 | Unknown | Hawaii | 0 | 9 | |
2500144 | 2500144 | 2022-05-13 | Butte | Idaho | 16023 | 475 | 9 |
2500151 | 2500151 | 2022-05-13 | Custer | Idaho | 16037 | 532 | 9 |
2500173 | 2500173 | 2022-05-13 | Teton | Idaho | 16081 | 2723 | 9 |
2500549 | 2500549 | 2022-05-13 | Rawlins | Kansas | 20153 | 683 | 9 |
2500910 | 2500910 | 2022-05-13 | Big Stone | Minnesota | 27011 | 1425 | 9 |
2501020 | 2501020 | 2022-05-13 | Issaquena | Mississippi | 28055 | 262 | 9 |
2501202 | 2501202 | 2022-05-13 | Daniels | Montana | 30019 | 386 | 9 |
2501212 | 2501212 | 2022-05-13 | Granite | Montana | 30039 | 537 | 9 |
2501221 | 2501221 | 2022-05-13 | McCone | Montana | 30055 | 383 | 9 |
2501298 | 2501298 | 2022-05-13 | Kearney | Nebraska | 31099 | 1181 | 9 |
2501301 | 2501301 | 2022-05-13 | Kimball | Nebraska | 31105 | 752 | 9 |
2501500 | 2501500 | 2022-05-13 | Camden | North Carolina | 37029 | 1786 | 9 |
2501591 | 2501591 | 2022-05-13 | Bowman | North Dakota | 38011 | 828 | 9 |
2501611 | 2501611 | 2022-05-13 | McIntosh | North Dakota | 38051 | 688 | 9 |
2501626 | 2501626 | 2022-05-13 | Sargent | North Dakota | 38081 | 1031 | 9 |
2502056 | 2502056 | 2022-05-13 | Clark | South Dakota | 46025 | 804 | 9 |
2502089 | 2502089 | 2022-05-13 | McPherson | South Dakota | 46089 | 426 | 9 |
2502212 | 2502212 | 2022-05-13 | Armstrong | Texas | 48011 | 555 | 9 |
2502257 | 2502257 | 2022-05-13 | Cottle | Texas | 48101 | 319 | 9 |
2502328 | 2502328 | 2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 |
2502368 | 2502368 | 2022-05-13 | McMullen | Texas | 48311 | 169 | 9 |
2502414 | 2502414 | 2022-05-13 | Schleicher | Texas | 48413 | 528 | 9 |
2496571 | 2496571 | 2022-05-12 | Cheyenne | Colorado | 8017 | 322 | 9 |
2496599 | 2496599 | 2022-05-12 | Lincoln | Colorado | 8073 | 2199 | 9 |
2496874 | 2496874 | 2022-05-12 | Unknown | Hawaii | 0 | 9 | |
2496886 | 2496886 | 2022-05-12 | Butte | Idaho | 16023 | 475 | 9 |
2496893 | 2496893 | 2022-05-12 | Custer | Idaho | 16037 | 531 | 9 |
2496915 | 2496915 | 2022-05-12 | Teton | Idaho | 16081 | 2722 | 9 |
2497291 | 2497291 | 2022-05-12 | Rawlins | Kansas | 20153 | 680 | 9 |
2497652 | 2497652 | 2022-05-12 | Big Stone | Minnesota | 27011 | 1423 | 9 |
2497762 | 2497762 | 2022-05-12 | Issaquena | Mississippi | 28055 | 262 | 9 |
2497944 | 2497944 | 2022-05-12 | Daniels | Montana | 30019 | 386 | 9 |
2497954 | 2497954 | 2022-05-12 | Granite | Montana | 30039 | 536 | 9 |
2497963 | 2497963 | 2022-05-12 | McCone | Montana | 30055 | 383 | 9 |
2498040 | 2498040 | 2022-05-12 | Kearney | Nebraska | 31099 | 1179 | 9 |
2498043 | 2498043 | 2022-05-12 | Kimball | Nebraska | 31105 | 752 | 9 |
2498242 | 2498242 | 2022-05-12 | Camden | North Carolina | 37029 | 1786 | 9 |
2498333 | 2498333 | 2022-05-12 | Bowman | North Dakota | 38011 | 828 | 9 |
2498353 | 2498353 | 2022-05-12 | McIntosh | North Dakota | 38051 | 687 | 9 |
2498368 | 2498368 | 2022-05-12 | Sargent | North Dakota | 38081 | 1024 | 9 |
2498798 | 2498798 | 2022-05-12 | Clark | South Dakota | 46025 | 804 | 9 |
2498831 | 2498831 | 2022-05-12 | McPherson | South Dakota | 46089 | 426 | 9 |
2498954 | 2498954 | 2022-05-12 | Armstrong | Texas | 48011 | 555 | 9 |
2498999 | 2498999 | 2022-05-12 | Cottle | Texas | 48101 | 319 | 9 |
2499070 | 2499070 | 2022-05-12 | Jeff Davis | Texas | 48243 | 224 | 9 |
2499110 | 2499110 | 2022-05-12 | McMullen | Texas | 48311 | 169 | 9 |
2499156 | 2499156 | 2022-05-12 | Schleicher | Texas | 48413 | 528 | 9 |
2493313 | 2493313 | 2022-05-11 | Cheyenne | Colorado | 8017 | 322 | 9 |
2493341 | 2493341 | 2022-05-11 | Lincoln | Colorado | 8073 | 2186 | 9 |
2493616 | 2493616 | 2022-05-11 | Unknown | Hawaii | 0 | 9 | |
2493628 | 2493628 | 2022-05-11 | Butte | Idaho | 16023 | 475 | 9 |
2493635 | 2493635 | 2022-05-11 | Custer | Idaho | 16037 | 531 | 9 |
2493657 | 2493657 | 2022-05-11 | Teton | Idaho | 16081 | 2722 | 9 |
2494033 | 2494033 | 2022-05-11 | Rawlins | Kansas | 20153 | 680 | 9 |
2494394 | 2494394 | 2022-05-11 | Big Stone | Minnesota | 27011 | 1421 | 9 |
2494504 | 2494504 | 2022-05-11 | Issaquena | Mississippi | 28055 | 262 | 9 |
2494686 | 2494686 | 2022-05-11 | Daniels | Montana | 30019 | 386 | 9 |
2494696 | 2494696 | 2022-05-11 | Granite | Montana | 30039 | 536 | 9 |
2494705 | 2494705 | 2022-05-11 | McCone | Montana | 30055 | 383 | 9 |
2494782 | 2494782 | 2022-05-11 | Kearney | Nebraska | 31099 | 1179 | 9 |
2494785 | 2494785 | 2022-05-11 | Kimball | Nebraska | 31105 | 752 | 9 |
2494984 | 2494984 | 2022-05-11 | Camden | North Carolina | 37029 | 1786 | 9 |
2495075 | 2495075 | 2022-05-11 | Bowman | North Dakota | 38011 | 828 | 9 |
2495095 | 2495095 | 2022-05-11 | McIntosh | North Dakota | 38051 | 687 | 9 |
2495110 | 2495110 | 2022-05-11 | Sargent | North Dakota | 38081 | 1024 | 9 |
2495540 | 2495540 | 2022-05-11 | Clark | South Dakota | 46025 | 804 | 9 |
2495573 | 2495573 | 2022-05-11 | McPherson | South Dakota | 46089 | 426 | 9 |
2495696 | 2495696 | 2022-05-11 | Armstrong | Texas | 48011 | 555 | 9 |
2495741 | 2495741 | 2022-05-11 | Cottle | Texas | 48101 | 319 | 9 |
2495812 | 2495812 | 2022-05-11 | Jeff Davis | Texas | 48243 | 224 | 9 |
2495852 | 2495852 | 2022-05-11 | McMullen | Texas | 48311 | 169 | 9 |
2495898 | 2495898 | 2022-05-11 | Schleicher | Texas | 48413 | 528 | 9 |
2490055 | 2490055 | 2022-05-10 | Cheyenne | Colorado | 8017 | 322 | 9 |
2490083 | 2490083 | 2022-05-10 | Lincoln | Colorado | 8073 | 2185 | 9 |
2490358 | 2490358 | 2022-05-10 | Unknown | Hawaii | 0 | 9 | |
2490370 | 2490370 | 2022-05-10 | Butte | Idaho | 16023 | 475 | 9 |
2490377 | 2490377 | 2022-05-10 | Custer | Idaho | 16037 | 531 | 9 |
2490399 | 2490399 | 2022-05-10 | Teton | Idaho | 16081 | 2721 | 9 |
2490775 | 2490775 | 2022-05-10 | Rawlins | Kansas | 20153 | 680 | 9 |
2491136 | 2491136 | 2022-05-10 | Big Stone | Minnesota | 27011 | 1421 | 9 |
2491246 | 2491246 | 2022-05-10 | Issaquena | Mississippi | 28055 | 262 | 9 |
2491428 | 2491428 | 2022-05-10 | Daniels | Montana | 30019 | 386 | 9 |
2491438 | 2491438 | 2022-05-10 | Granite | Montana | 30039 | 536 | 9 |
2491447 | 2491447 | 2022-05-10 | McCone | Montana | 30055 | 383 | 9 |
2491524 | 2491524 | 2022-05-10 | Kearney | Nebraska | 31099 | 1227 | 9 |
2491527 | 2491527 | 2022-05-10 | Kimball | Nebraska | 31105 | 775 | 9 |
2491726 | 2491726 | 2022-05-10 | Camden | North Carolina | 37029 | 1775 | 9 |
2491817 | 2491817 | 2022-05-10 | Bowman | North Dakota | 38011 | 828 | 9 |
2491837 | 2491837 | 2022-05-10 | McIntosh | North Dakota | 38051 | 687 | 9 |
2491852 | 2491852 | 2022-05-10 | Sargent | North Dakota | 38081 | 1024 | 9 |
2492282 | 2492282 | 2022-05-10 | Clark | South Dakota | 46025 | 804 | 9 |
2492315 | 2492315 | 2022-05-10 | McPherson | South Dakota | 46089 | 426 | 9 |
2492438 | 2492438 | 2022-05-10 | Armstrong | Texas | 48011 | 555 | 9 |
2492483 | 2492483 | 2022-05-10 | Cottle | Texas | 48101 | 319 | 9 |
2492554 | 2492554 | 2022-05-10 | Jeff Davis | Texas | 48243 | 223 | 9 |
2492594 | 2492594 | 2022-05-10 | McMullen | Texas | 48311 | 169 | 9 |
2492640 | 2492640 | 2022-05-10 | Schleicher | Texas | 48413 | 528 | 9 |
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);