ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
262,872 rows where deaths = 0 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 18,667
- Nebraska 15,843
- Kansas 15,139
- Kentucky 12,232
- Missouri 11,434
- Minnesota 9,130
- Iowa 8,872
- South Dakota 8,815
- Virginia 8,723
- Colorado 8,560
- Illinois 8,367
- Alaska 7,825
- North Dakota 7,720
- Tennessee 7,246
- Arkansas 7,023
- Montana 6,700
- West Virginia 6,469
- Oklahoma 6,267
- Idaho 5,630
- Georgia 5,551
- Wisconsin 5,534
- Utah 5,107
- Michigan 4,591
- California 4,530
- North Carolina 4,503
- Oregon 4,026
- Ohio 3,809
- Washington 3,735
- Indiana 3,463
- New Mexico 3,022
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499663 | 2499663 | 2022-05-13 | Skagway Municipality | Alaska | 2230 | 187 | 0 |
2499756 | 2499756 | 2022-05-13 | Unknown | Arkansas | 27002 | 0 | |
2499763 | 2499763 | 2022-05-13 | Alpine | California | 6003 | 126 | 0 |
2499847 | 2499847 | 2022-05-13 | Hinsdale | Colorado | 8053 | 131 | 0 |
2499849 | 2499849 | 2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 |
2499876 | 2499876 | 2022-05-13 | San Juan | Colorado | 8111 | 203 | 0 |
2499896 | 2499896 | 2022-05-13 | Unknown | Delaware | 899 | 0 | |
2500129 | 2500129 | 2022-05-13 | Kalawao | Hawaii | 15005 | 1 | 0 |
2500755 | 2500755 | 2022-05-13 | Unknown | Louisiana | 984 | 0 | |
2500777 | 2500777 | 2022-05-13 | Unknown | Maine | 42 | 0 | |
2500809 | 2500809 | 2022-05-13 | Dukes | Massachusetts | 25007 | 3587 | 0 |
2500815 | 2500815 | 2022-05-13 | Nantucket | Massachusetts | 25019 | 3481 | 0 |
2501291 | 2501291 | 2022-05-13 | Hayes | Nebraska | 31085 | 96 | 0 |
2501300 | 2501300 | 2022-05-13 | Keya Paha | Nebraska | 31103 | 119 | 0 |
2501305 | 2501305 | 2022-05-13 | Logan | Nebraska | 31113 | 138 | 0 |
2501306 | 2501306 | 2022-05-13 | Loup | Nebraska | 31115 | 79 | 0 |
2501392 | 2501392 | 2022-05-13 | Unknown | New Jersey | 3174 | 0 | |
2501426 | 2501426 | 2022-05-13 | Unknown | New Mexico | 67 | 0 | |
2501629 | 2501629 | 2022-05-13 | Slope | North Dakota | 38087 | 63 | 0 |
2501640 | 2501640 | 2022-05-13 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2501642 | 2501642 | 2022-05-13 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2501805 | 2501805 | 2022-05-13 | Unknown | Oklahoma | 806 | 0 | |
2502341 | 2502341 | 2022-05-13 | King | Texas | 48269 | 51 | 0 |
2502393 | 2502393 | 2022-05-13 | Pending County Assignment | Texas | 48999 | 65 | 0 |
2502466 | 2502466 | 2022-05-13 | Daggett | Utah | 49009 | 153 | 0 |
2502478 | 2502478 | 2022-05-13 | Rich | Utah | 49033 | 343 | 0 |
2502490 | 2502490 | 2022-05-13 | Wayne | Utah | 49055 | 444 | 0 |
2502677 | 2502677 | 2022-05-13 | Unknown | Washington | 3265 | 0 | |
2496405 | 2496405 | 2022-05-12 | Skagway Municipality | Alaska | 2230 | 187 | 0 |
2496498 | 2496498 | 2022-05-12 | Unknown | Arkansas | 27000 | 0 | |
2496505 | 2496505 | 2022-05-12 | Alpine | California | 6003 | 126 | 0 |
2496589 | 2496589 | 2022-05-12 | Hinsdale | Colorado | 8053 | 131 | 0 |
2496591 | 2496591 | 2022-05-12 | Jackson | Colorado | 8057 | 166 | 0 |
2496618 | 2496618 | 2022-05-12 | San Juan | Colorado | 8111 | 203 | 0 |
2496638 | 2496638 | 2022-05-12 | Unknown | Delaware | 895 | 0 | |
2496871 | 2496871 | 2022-05-12 | Kalawao | Hawaii | 15005 | 1 | 0 |
2497497 | 2497497 | 2022-05-12 | Unknown | Louisiana | 983 | 0 | |
2497519 | 2497519 | 2022-05-12 | Unknown | Maine | 52 | 0 | |
2497551 | 2497551 | 2022-05-12 | Dukes | Massachusetts | 25007 | 3569 | 0 |
2497557 | 2497557 | 2022-05-12 | Nantucket | Massachusetts | 25019 | 3477 | 0 |
2498033 | 2498033 | 2022-05-12 | Hayes | Nebraska | 31085 | 96 | 0 |
2498042 | 2498042 | 2022-05-12 | Keya Paha | Nebraska | 31103 | 119 | 0 |
2498047 | 2498047 | 2022-05-12 | Logan | Nebraska | 31113 | 138 | 0 |
2498048 | 2498048 | 2022-05-12 | Loup | Nebraska | 31115 | 79 | 0 |
2498100 | 2498100 | 2022-05-12 | Unknown | Nevada | 6466 | 0 | |
2498134 | 2498134 | 2022-05-12 | Unknown | New Jersey | 3200 | 0 | |
2498168 | 2498168 | 2022-05-12 | Unknown | New Mexico | 65 | 0 | |
2498371 | 2498371 | 2022-05-12 | Slope | North Dakota | 38087 | 63 | 0 |
2498382 | 2498382 | 2022-05-12 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2498384 | 2498384 | 2022-05-12 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2498547 | 2498547 | 2022-05-12 | Unknown | Oklahoma | 806 | 0 | |
2499083 | 2499083 | 2022-05-12 | King | Texas | 48269 | 51 | 0 |
2499135 | 2499135 | 2022-05-12 | Pending County Assignment | Texas | 48999 | 65 | 0 |
2499208 | 2499208 | 2022-05-12 | Daggett | Utah | 49009 | 153 | 0 |
2499220 | 2499220 | 2022-05-12 | Rich | Utah | 49033 | 343 | 0 |
2499232 | 2499232 | 2022-05-12 | Wayne | Utah | 49055 | 444 | 0 |
2499419 | 2499419 | 2022-05-12 | Unknown | Washington | 3265 | 0 | |
2493147 | 2493147 | 2022-05-11 | Skagway Municipality | Alaska | 2230 | 187 | 0 |
2493240 | 2493240 | 2022-05-11 | Unknown | Arkansas | 26996 | 0 | |
2493247 | 2493247 | 2022-05-11 | Alpine | California | 6003 | 126 | 0 |
2493331 | 2493331 | 2022-05-11 | Hinsdale | Colorado | 8053 | 131 | 0 |
2493333 | 2493333 | 2022-05-11 | Jackson | Colorado | 8057 | 165 | 0 |
2493360 | 2493360 | 2022-05-11 | San Juan | Colorado | 8111 | 203 | 0 |
2493380 | 2493380 | 2022-05-11 | Unknown | Delaware | 885 | 0 | |
2493613 | 2493613 | 2022-05-11 | Kalawao | Hawaii | 15005 | 1 | 0 |
2494239 | 2494239 | 2022-05-11 | Unknown | Louisiana | 983 | 0 | |
2494261 | 2494261 | 2022-05-11 | Unknown | Maine | 27 | 0 | |
2494293 | 2494293 | 2022-05-11 | Dukes | Massachusetts | 25007 | 3564 | 0 |
2494299 | 2494299 | 2022-05-11 | Nantucket | Massachusetts | 25019 | 3475 | 0 |
2494775 | 2494775 | 2022-05-11 | Hayes | Nebraska | 31085 | 96 | 0 |
2494784 | 2494784 | 2022-05-11 | Keya Paha | Nebraska | 31103 | 119 | 0 |
2494789 | 2494789 | 2022-05-11 | Logan | Nebraska | 31113 | 138 | 0 |
2494790 | 2494790 | 2022-05-11 | Loup | Nebraska | 31115 | 79 | 0 |
2494842 | 2494842 | 2022-05-11 | Unknown | Nevada | 6146 | 0 | |
2494876 | 2494876 | 2022-05-11 | Unknown | New Jersey | 3207 | 0 | |
2494910 | 2494910 | 2022-05-11 | Unknown | New Mexico | 65 | 0 | |
2495113 | 2495113 | 2022-05-11 | Slope | North Dakota | 38087 | 63 | 0 |
2495124 | 2495124 | 2022-05-11 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2495126 | 2495126 | 2022-05-11 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2495289 | 2495289 | 2022-05-11 | Unknown | Oklahoma | 2310 | 0 | |
2495825 | 2495825 | 2022-05-11 | King | Texas | 48269 | 51 | 0 |
2495877 | 2495877 | 2022-05-11 | Pending County Assignment | Texas | 48999 | 65 | 0 |
2495950 | 2495950 | 2022-05-11 | Daggett | Utah | 49009 | 153 | 0 |
2495962 | 2495962 | 2022-05-11 | Rich | Utah | 49033 | 342 | 0 |
2495974 | 2495974 | 2022-05-11 | Wayne | Utah | 49055 | 444 | 0 |
2496161 | 2496161 | 2022-05-11 | Unknown | Washington | 3265 | 0 | |
2489889 | 2489889 | 2022-05-10 | Skagway Municipality | Alaska | 2230 | 169 | 0 |
2489982 | 2489982 | 2022-05-10 | Unknown | Arkansas | 26996 | 0 | |
2489989 | 2489989 | 2022-05-10 | Alpine | California | 6003 | 126 | 0 |
2490073 | 2490073 | 2022-05-10 | Hinsdale | Colorado | 8053 | 131 | 0 |
2490075 | 2490075 | 2022-05-10 | Jackson | Colorado | 8057 | 165 | 0 |
2490102 | 2490102 | 2022-05-10 | San Juan | Colorado | 8111 | 203 | 0 |
2490122 | 2490122 | 2022-05-10 | Unknown | Delaware | 885 | 0 | |
2490355 | 2490355 | 2022-05-10 | Kalawao | Hawaii | 15005 | 1 | 0 |
2490687 | 2490687 | 2022-05-10 | Unknown | Iowa | 2238 | 0 | |
2490981 | 2490981 | 2022-05-10 | Unknown | Louisiana | 983 | 0 | |
2491003 | 2491003 | 2022-05-10 | Unknown | Maine | 35 | 0 | |
2491035 | 2491035 | 2022-05-10 | Dukes | Massachusetts | 25007 | 3554 | 0 |
2491041 | 2491041 | 2022-05-10 | Nantucket | Massachusetts | 25019 | 3471 | 0 |
2491517 | 2491517 | 2022-05-10 | Hayes | Nebraska | 31085 | 113 | 0 |
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);