ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 45,205
- Georgia 31,334
- Virginia 25,448
- Kentucky 22,492
- Missouri 21,271
- Illinois 19,434
- North Carolina 19,408
- Iowa 18,670
- Tennessee 18,668
- Indiana 18,158
- Kansas 17,755
- Ohio 17,274
- Minnesota 16,491
- Mississippi 16,201
- Michigan 16,146
- Arkansas 14,572
- Nebraska 14,559
- Oklahoma 14,372
- Wisconsin 13,929
- Florida 13,582
- Pennsylvania 13,313
- Alabama 13,117
- Louisiana 12,943
- Puerto Rico 12,261
- Colorado 12,087
- New York 11,820
- California 11,755
- South Dakota 11,008
- West Virginia 10,116
- South Carolina 9,227
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
602961 | 602961 | 2020-10-06 | Pulaski | Georgia | 13235 | 350 | 22 |
602962 | 602962 | 2020-10-06 | Putnam | Georgia | 13237 | 767 | 25 |
602963 | 602963 | 2020-10-06 | Quitman | Georgia | 13239 | 36 | 1 |
602964 | 602964 | 2020-10-06 | Rabun | Georgia | 13241 | 381 | 11 |
602965 | 602965 | 2020-10-06 | Randolph | Georgia | 13243 | 346 | 29 |
602966 | 602966 | 2020-10-06 | Richmond | Georgia | 13245 | 7579 | 168 |
602967 | 602967 | 2020-10-06 | Rockdale | Georgia | 13247 | 1977 | 37 |
602968 | 602968 | 2020-10-06 | Schley | Georgia | 13249 | 139 | 2 |
602969 | 602969 | 2020-10-06 | Screven | Georgia | 13251 | 442 | 11 |
602970 | 602970 | 2020-10-06 | Seminole | Georgia | 13253 | 381 | 9 |
602971 | 602971 | 2020-10-06 | Spalding | Georgia | 13255 | 1581 | 62 |
602972 | 602972 | 2020-10-06 | Stephens | Georgia | 13257 | 1145 | 38 |
602973 | 602973 | 2020-10-06 | Stewart | Georgia | 13259 | 558 | 15 |
602974 | 602974 | 2020-10-06 | Sumter | Georgia | 13261 | 1100 | 64 |
602975 | 602975 | 2020-10-06 | Talbot | Georgia | 13263 | 188 | 6 |
602976 | 602976 | 2020-10-06 | Taliaferro | Georgia | 13265 | 24 | 0 |
602977 | 602977 | 2020-10-06 | Tattnall | Georgia | 13267 | 895 | 11 |
602978 | 602978 | 2020-10-06 | Taylor | Georgia | 13269 | 265 | 11 |
602979 | 602979 | 2020-10-06 | Telfair | Georgia | 13271 | 448 | 21 |
602980 | 602980 | 2020-10-06 | Terrell | Georgia | 13273 | 366 | 32 |
602981 | 602981 | 2020-10-06 | Thomas | Georgia | 13275 | 1619 | 66 |
602982 | 602982 | 2020-10-06 | Tift | Georgia | 13277 | 1969 | 57 |
602983 | 602983 | 2020-10-06 | Toombs | Georgia | 13279 | 1411 | 51 |
602984 | 602984 | 2020-10-06 | Towns | Georgia | 13281 | 363 | 10 |
602985 | 602985 | 2020-10-06 | Treutlen | Georgia | 13283 | 302 | 11 |
602986 | 602986 | 2020-10-06 | Troup | Georgia | 13285 | 3163 | 102 |
602987 | 602987 | 2020-10-06 | Turner | Georgia | 13287 | 361 | 24 |
602988 | 602988 | 2020-10-06 | Twiggs | Georgia | 13289 | 203 | 9 |
602989 | 602989 | 2020-10-06 | Union | Georgia | 13291 | 825 | 21 |
602990 | 602990 | 2020-10-06 | Unknown | Georgia | 2510 | 7 | |
602991 | 602991 | 2020-10-06 | Upson | Georgia | 13293 | 1182 | 63 |
602992 | 602992 | 2020-10-06 | Walker | Georgia | 13295 | 1647 | 38 |
602993 | 602993 | 2020-10-06 | Walton | Georgia | 13297 | 2080 | 57 |
602994 | 602994 | 2020-10-06 | Ware | Georgia | 13299 | 2030 | 62 |
602995 | 602995 | 2020-10-06 | Warren | Georgia | 13301 | 175 | 5 |
602996 | 602996 | 2020-10-06 | Washington | Georgia | 13303 | 757 | 8 |
602997 | 602997 | 2020-10-06 | Wayne | Georgia | 13305 | 1255 | 31 |
602998 | 602998 | 2020-10-06 | Webster | Georgia | 13307 | 51 | 2 |
602999 | 602999 | 2020-10-06 | Wheeler | Georgia | 13309 | 381 | 12 |
603000 | 603000 | 2020-10-06 | White | Georgia | 13311 | 910 | 20 |
603001 | 603001 | 2020-10-06 | Whitfield | Georgia | 13313 | 4756 | 61 |
603002 | 603002 | 2020-10-06 | Wilcox | Georgia | 13315 | 305 | 24 |
603003 | 603003 | 2020-10-06 | Wilkes | Georgia | 13317 | 277 | 5 |
603004 | 603004 | 2020-10-06 | Wilkinson | Georgia | 13319 | 356 | 18 |
603005 | 603005 | 2020-10-06 | Worth | Georgia | 13321 | 602 | 30 |
603006 | 603006 | 2020-10-06 | Unknown | Guam | 3787 | 56 | |
603007 | 603007 | 2020-10-06 | Hawaii | Hawaii | 15001 | 845 | 15 |
603008 | 603008 | 2020-10-06 | Honolulu | Hawaii | 15003 | 11683 | 132 |
603009 | 603009 | 2020-10-06 | Kauai | Hawaii | 15007 | 59 | 0 |
603010 | 603010 | 2020-10-06 | Maui | Hawaii | 15009 | 503 | 12 |
603011 | 603011 | 2020-10-06 | Ada | Idaho | 16001 | 13732 | 153 |
603012 | 603012 | 2020-10-06 | Adams | Idaho | 16003 | 29 | 2 |
603013 | 603013 | 2020-10-06 | Bannock | Idaho | 16005 | 1459 | 6 |
603014 | 603014 | 2020-10-06 | Bear Lake | Idaho | 16007 | 52 | 1 |
603015 | 603015 | 2020-10-06 | Benewah | Idaho | 16009 | 157 | 3 |
603016 | 603016 | 2020-10-06 | Bingham | Idaho | 16011 | 1150 | 10 |
603017 | 603017 | 2020-10-06 | Blaine | Idaho | 16013 | 708 | 6 |
603018 | 603018 | 2020-10-06 | Boise | Idaho | 16015 | 74 | 2 |
603019 | 603019 | 2020-10-06 | Bonner | Idaho | 16017 | 377 | 0 |
603020 | 603020 | 2020-10-06 | Bonneville | Idaho | 16019 | 3152 | 18 |
603021 | 603021 | 2020-10-06 | Boundary | Idaho | 16021 | 62 | 1 |
603022 | 603022 | 2020-10-06 | Butte | Idaho | 16023 | 50 | 0 |
603023 | 603023 | 2020-10-06 | Camas | Idaho | 16025 | 38 | 0 |
603024 | 603024 | 2020-10-06 | Canyon | Idaho | 16027 | 8446 | 103 |
603025 | 603025 | 2020-10-06 | Caribou | Idaho | 16029 | 148 | 2 |
603026 | 603026 | 2020-10-06 | Cassia | Idaho | 16031 | 866 | 7 |
603027 | 603027 | 2020-10-06 | Clark | Idaho | 16033 | 38 | 0 |
603028 | 603028 | 2020-10-06 | Clearwater | Idaho | 16035 | 83 | 0 |
603029 | 603029 | 2020-10-06 | Custer | Idaho | 16037 | 70 | 1 |
603030 | 603030 | 2020-10-06 | Elmore | Idaho | 16039 | 395 | 4 |
603031 | 603031 | 2020-10-06 | Franklin | Idaho | 16041 | 202 | 1 |
603032 | 603032 | 2020-10-06 | Fremont | Idaho | 16043 | 279 | 3 |
603033 | 603033 | 2020-10-06 | Gem | Idaho | 16045 | 347 | 4 |
603034 | 603034 | 2020-10-06 | Gooding | Idaho | 16047 | 349 | 0 |
603035 | 603035 | 2020-10-06 | Idaho | Idaho | 16049 | 232 | 0 |
603036 | 603036 | 2020-10-06 | Jefferson | Idaho | 16051 | 688 | 3 |
603037 | 603037 | 2020-10-06 | Jerome | Idaho | 16053 | 835 | 7 |
603038 | 603038 | 2020-10-06 | Kootenai | Idaho | 16055 | 2880 | 40 |
603039 | 603039 | 2020-10-06 | Latah | Idaho | 16057 | 643 | 0 |
603040 | 603040 | 2020-10-06 | Lemhi | Idaho | 16059 | 123 | 0 |
603041 | 603041 | 2020-10-06 | Lewis | Idaho | 16061 | 41 | 1 |
603042 | 603042 | 2020-10-06 | Lincoln | Idaho | 16063 | 98 | 0 |
603043 | 603043 | 2020-10-06 | Madison | Idaho | 16065 | 1238 | 2 |
603044 | 603044 | 2020-10-06 | Minidoka | Idaho | 16067 | 805 | 8 |
603045 | 603045 | 2020-10-06 | Nez Perce | Idaho | 16069 | 493 | 24 |
603046 | 603046 | 2020-10-06 | Oneida | Idaho | 16071 | 30 | 0 |
603047 | 603047 | 2020-10-06 | Owyhee | Idaho | 16073 | 338 | 5 |
603048 | 603048 | 2020-10-06 | Payette | Idaho | 16075 | 949 | 9 |
603049 | 603049 | 2020-10-06 | Power | Idaho | 16077 | 304 | 1 |
603050 | 603050 | 2020-10-06 | Shoshone | Idaho | 16079 | 215 | 18 |
603051 | 603051 | 2020-10-06 | Teton | Idaho | 16081 | 213 | 1 |
603052 | 603052 | 2020-10-06 | Twin Falls | Idaho | 16083 | 2607 | 41 |
603053 | 603053 | 2020-10-06 | Valley | Idaho | 16085 | 103 | 1 |
603054 | 603054 | 2020-10-06 | Washington | Idaho | 16087 | 389 | 6 |
603055 | 603055 | 2020-10-06 | Adams | Illinois | 17001 | 1282 | 10 |
603056 | 603056 | 2020-10-06 | Alexander | Illinois | 17003 | 94 | 1 |
603057 | 603057 | 2020-10-06 | Bond | Illinois | 17005 | 365 | 8 |
603058 | 603058 | 2020-10-06 | Boone | Illinois | 17007 | 1243 | 24 |
603059 | 603059 | 2020-10-06 | Brown | Illinois | 17009 | 72 | 0 |
603060 | 603060 | 2020-10-06 | Bureau | Illinois | 17011 | 753 | 14 |
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);