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: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2177960 | 2177960 | 2022-02-03 | Rockdale | Georgia | 13247 | 17749 | 285 |
2177961 | 2177961 | 2022-02-03 | Schley | Georgia | 13249 | 1105 | 8 |
2177962 | 2177962 | 2022-02-03 | Screven | Georgia | 13251 | 2550 | 62 |
2177963 | 2177963 | 2022-02-03 | Seminole | Georgia | 13253 | 2091 | 27 |
2177964 | 2177964 | 2022-02-03 | Spalding | Georgia | 13255 | 15378 | 365 |
2177965 | 2177965 | 2022-02-03 | Stephens | Georgia | 13257 | 6044 | 132 |
2177966 | 2177966 | 2022-02-03 | Stewart | Georgia | 13259 | 2020 | 31 |
2177967 | 2177967 | 2022-02-03 | Sumter | Georgia | 13261 | 6535 | 147 |
2177968 | 2177968 | 2022-02-03 | Talbot | Georgia | 13263 | 1112 | 31 |
2177969 | 2177969 | 2022-02-03 | Taliaferro | Georgia | 13265 | 260 | 3 |
2177970 | 2177970 | 2022-02-03 | Tattnall | Georgia | 13267 | 4760 | 122 |
2177971 | 2177971 | 2022-02-03 | Taylor | Georgia | 13269 | 1911 | 48 |
2177972 | 2177972 | 2022-02-03 | Telfair | Georgia | 13271 | 2945 | 76 |
2177973 | 2177973 | 2022-02-03 | Terrell | Georgia | 13273 | 1959 | 59 |
2177974 | 2177974 | 2022-02-03 | Thomas | Georgia | 13275 | 11365 | 189 |
2177975 | 2177975 | 2022-02-03 | Tift | Georgia | 13277 | 11242 | 200 |
2177976 | 2177976 | 2022-02-03 | Toombs | Georgia | 13279 | 6680 | 180 |
2177977 | 2177977 | 2022-02-03 | Towns | Georgia | 13281 | 2226 | 94 |
2177978 | 2177978 | 2022-02-03 | Treutlen | Georgia | 13283 | 1579 | 57 |
2177979 | 2177979 | 2022-02-03 | Troup | Georgia | 13285 | 15099 | 348 |
2177980 | 2177980 | 2022-02-03 | Turner | Georgia | 13287 | 2470 | 50 |
2177981 | 2177981 | 2022-02-03 | Twiggs | Georgia | 13289 | 1480 | 64 |
2177982 | 2177982 | 2022-02-03 | Union | Georgia | 13291 | 4530 | 140 |
2177983 | 2177983 | 2022-02-03 | Unknown | Georgia | 11415 | 11 | |
2177984 | 2177984 | 2022-02-03 | Upson | Georgia | 13293 | 7477 | 207 |
2177985 | 2177985 | 2022-02-03 | Walker | Georgia | 13295 | 15582 | 198 |
2177986 | 2177986 | 2022-02-03 | Walton | Georgia | 13297 | 21486 | 385 |
2177987 | 2177987 | 2022-02-03 | Ware | Georgia | 13299 | 9401 | 255 |
2177988 | 2177988 | 2022-02-03 | Warren | Georgia | 13301 | 1017 | 28 |
2177989 | 2177989 | 2022-02-03 | Washington | Georgia | 13303 | 4190 | 131 |
2177990 | 2177990 | 2022-02-03 | Wayne | Georgia | 13305 | 7362 | 188 |
2177991 | 2177991 | 2022-02-03 | Webster | Georgia | 13307 | 425 | 7 |
2177992 | 2177992 | 2022-02-03 | Wheeler | Georgia | 13309 | 1177 | 36 |
2177993 | 2177993 | 2022-02-03 | White | Georgia | 13311 | 6558 | 146 |
2177994 | 2177994 | 2022-02-03 | Whitfield | Georgia | 13313 | 32443 | 377 |
2177995 | 2177995 | 2022-02-03 | Wilcox | Georgia | 13315 | 1898 | 62 |
2177996 | 2177996 | 2022-02-03 | Wilkes | Georgia | 13317 | 2203 | 43 |
2177997 | 2177997 | 2022-02-03 | Wilkinson | Georgia | 13319 | 2145 | 50 |
2177998 | 2177998 | 2022-02-03 | Worth | Georgia | 13321 | 4503 | 104 |
2177999 | 2177999 | 2022-02-03 | Unknown | Guam | 34757 | 297 | |
2178000 | 2178000 | 2022-02-03 | Hawaii | Hawaii | 15001 | 23885 | 164 |
2178001 | 2178001 | 2022-02-03 | Honolulu | Hawaii | 15003 | 156007 | 882 |
2178002 | 2178002 | 2022-02-03 | Kalawao | Hawaii | 15005 | 1 | 0 |
2178003 | 2178003 | 2022-02-03 | Kauai | Hawaii | 15007 | 10089 | 22 |
2178004 | 2178004 | 2022-02-03 | Maui | Hawaii | 15009 | 27913 | 114 |
2178005 | 2178005 | 2022-02-03 | Unknown | Hawaii | 0 | 9 | |
2178006 | 2178006 | 2022-02-03 | Ada | Idaho | 16001 | 108139 | 931 |
2178007 | 2178007 | 2022-02-03 | Adams | Idaho | 16003 | 641 | 14 |
2178008 | 2178008 | 2022-02-03 | Bannock | Idaho | 16005 | 19730 | 230 |
2178009 | 2178009 | 2022-02-03 | Bear Lake | Idaho | 16007 | 900 | 15 |
2178010 | 2178010 | 2022-02-03 | Benewah | Idaho | 16009 | 1897 | 34 |
2178011 | 2178011 | 2022-02-03 | Bingham | Idaho | 16011 | 9461 | 141 |
2178012 | 2178012 | 2022-02-03 | Blaine | Idaho | 16013 | 4928 | 29 |
2178013 | 2178013 | 2022-02-03 | Boise | Idaho | 16015 | 968 | 13 |
2178014 | 2178014 | 2022-02-03 | Bonner | Idaho | 16017 | 7817 | 163 |
2178015 | 2178015 | 2022-02-03 | Bonneville | Idaho | 16019 | 30134 | 265 |
2178016 | 2178016 | 2022-02-03 | Boundary | Idaho | 16021 | 1919 | 55 |
2178017 | 2178017 | 2022-02-03 | Butte | Idaho | 16023 | 465 | 7 |
2178018 | 2178018 | 2022-02-03 | Camas | Idaho | 16025 | 128 | 2 |
2178019 | 2178019 | 2022-02-03 | Canyon | Idaho | 16027 | 54099 | 636 |
2178020 | 2178020 | 2022-02-03 | Caribou | Idaho | 16029 | 1433 | 25 |
2178021 | 2178021 | 2022-02-03 | Cassia | Idaho | 16031 | 4336 | 48 |
2178022 | 2178022 | 2022-02-03 | Clark | Idaho | 16033 | 105 | 0 |
2178023 | 2178023 | 2022-02-03 | Clearwater | Idaho | 16035 | 2119 | 31 |
2178024 | 2178024 | 2022-02-03 | Custer | Idaho | 16037 | 499 | 7 |
2178025 | 2178025 | 2022-02-03 | Elmore | Idaho | 16039 | 5475 | 58 |
2178026 | 2178026 | 2022-02-03 | Franklin | Idaho | 16041 | 2185 | 27 |
2178027 | 2178027 | 2022-02-03 | Fremont | Idaho | 16043 | 2187 | 22 |
2178028 | 2178028 | 2022-02-03 | Gem | Idaho | 16045 | 3325 | 77 |
2178029 | 2178029 | 2022-02-03 | Gooding | Idaho | 16047 | 2637 | 48 |
2178030 | 2178030 | 2022-02-03 | Idaho | Idaho | 16049 | 2826 | 44 |
2178031 | 2178031 | 2022-02-03 | Jefferson | Idaho | 16051 | 5816 | 57 |
2178032 | 2178032 | 2022-02-03 | Jerome | Idaho | 16053 | 4887 | 60 |
2178033 | 2178033 | 2022-02-03 | Kootenai | Idaho | 16055 | 36658 | 529 |
2178034 | 2178034 | 2022-02-03 | Latah | Idaho | 16057 | 6371 | 45 |
2178035 | 2178035 | 2022-02-03 | Lemhi | Idaho | 16059 | 1213 | 25 |
2178036 | 2178036 | 2022-02-03 | Lewis | Idaho | 16061 | 1070 | 25 |
2178037 | 2178037 | 2022-02-03 | Lincoln | Idaho | 16063 | 870 | 14 |
2178038 | 2178038 | 2022-02-03 | Madison | Idaho | 16065 | 12322 | 44 |
2178039 | 2178039 | 2022-02-03 | Minidoka | Idaho | 16067 | 3581 | 55 |
2178040 | 2178040 | 2022-02-03 | Nez Perce | Idaho | 16069 | 8458 | 125 |
2178041 | 2178041 | 2022-02-03 | Oneida | Idaho | 16071 | 765 | 10 |
2178042 | 2178042 | 2022-02-03 | Owyhee | Idaho | 16073 | 2025 | 48 |
2178043 | 2178043 | 2022-02-03 | Payette | Idaho | 16075 | 4942 | 78 |
2178044 | 2178044 | 2022-02-03 | Power | Idaho | 16077 | 1433 | 18 |
2178045 | 2178045 | 2022-02-03 | Shoshone | Idaho | 16079 | 2446 | 71 |
2178046 | 2178046 | 2022-02-03 | Teton | Idaho | 16081 | 2624 | 8 |
2178047 | 2178047 | 2022-02-03 | Twin Falls | Idaho | 16083 | 19152 | 266 |
2178048 | 2178048 | 2022-02-03 | Valley | Idaho | 16085 | 2280 | 15 |
2178049 | 2178049 | 2022-02-03 | Washington | Idaho | 16087 | 2118 | 53 |
2178050 | 2178050 | 2022-02-03 | Adams | Illinois | 17001 | 21360 | 219 |
2178051 | 2178051 | 2022-02-03 | Alexander | Illinois | 17003 | 1231 | 13 |
2178052 | 2178052 | 2022-02-03 | Bond | Illinois | 17005 | 4162 | 34 |
2178053 | 2178053 | 2022-02-03 | Boone | Illinois | 17007 | 13210 | 115 |
2178054 | 2178054 | 2022-02-03 | Brown | Illinois | 17009 | 2315 | 19 |
2178055 | 2178055 | 2022-02-03 | Bureau | Illinois | 17011 | 7987 | 135 |
2178056 | 2178056 | 2022-02-03 | Calhoun | Illinois | 17013 | 1490 | 7 |
2178057 | 2178057 | 2022-02-03 | Carroll | Illinois | 17015 | 3893 | 46 |
2178058 | 2178058 | 2022-02-03 | Cass | Illinois | 17017 | 4475 | 43 |
2178059 | 2178059 | 2022-02-03 | Champaign | Illinois | 17019 | 59144 | 273 |
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);