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 56
- Texas 168,366
- Georgia 108,889
- Virginia 89,958
- Kentucky 80,692
- Missouri 78,017
- Illinois 69,305
- Kansas 68,863
- North Carolina 67,909
- Iowa 67,170
- Tennessee 65,215
- Indiana 62,778
- Ohio 60,290
- Nebraska 59,949
- Minnesota 59,171
- Michigan 56,886
- Mississippi 55,972
- Oklahoma 52,201
- Arkansas 51,432
- Puerto Rico 50,576
- Wisconsin 48,865
- Florida 46,562
- Pennsylvania 45,808
- Alabama 45,612
- Louisiana 44,467
- Colorado 43,127
- South Dakota 43,018
- New York 39,950
- California 39,892
- West Virginia 36,793
- North Dakota 35,153
- Montana 35,112
- South Carolina 31,537
- Idaho 28,828
- Washington 27,022
- Oregon 24,219
- New Mexico 22,120
- Utah 19,949
- Alaska 17,770
- Maryland 17,170
- Wyoming 15,538
- New Jersey 15,239
- Maine 11,414
- Nevada 11,124
- Massachusetts 10,429
- Arizona 10,419
- Vermont 10,273
- New Hampshire 7,523
- Connecticut 6,191
- Rhode Island 4,110
- Hawaii 3,386
- Delaware 2,731
- Virgin Islands 2,184
- Northern Mariana Islands 1,441
- District of Columbia 698
- Guam 690
- American Samoa 139
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
2178060 | 2178060 | 2022-02-03 | Christian | Illinois | 17021 | 9613 | 121 |
2178061 | 2178061 | 2022-02-03 | Clark | Illinois | 17023 | 4560 | 55 |
2178062 | 2178062 | 2022-02-03 | Clay | Illinois | 17025 | 4532 | 67 |
2178063 | 2178063 | 2022-02-03 | Clinton | Illinois | 17027 | 11480 | 119 |
2178064 | 2178064 | 2022-02-03 | Coles | Illinois | 17029 | 14627 | 158 |
2178065 | 2178065 | 2022-02-03 | Cook | Illinois | 17031 | 1084468 | 13988 |
2178066 | 2178066 | 2022-02-03 | Crawford | Illinois | 17033 | 5906 | 55 |
2178067 | 2178067 | 2022-02-03 | Cumberland | Illinois | 17035 | 3245 | 48 |
2178068 | 2178068 | 2022-02-03 | De Witt | Illinois | 17039 | 4195 | 40 |
2178069 | 2178069 | 2022-02-03 | DeKalb | Illinois | 17037 | 22002 | 188 |
2178070 | 2178070 | 2022-02-03 | Douglas | Illinois | 17041 | 6276 | 56 |
2178071 | 2178071 | 2022-02-03 | DuPage | Illinois | 17043 | 198539 | 1679 |
2178072 | 2178072 | 2022-02-03 | Edgar | Illinois | 17045 | 4926 | 76 |
2178073 | 2178073 | 2022-02-03 | Edwards | Illinois | 17047 | 1723 | 26 |
2178074 | 2178074 | 2022-02-03 | Effingham | Illinois | 17049 | 10302 | 137 |
2178075 | 2178075 | 2022-02-03 | Fayette | Illinois | 17051 | 6834 | 92 |
2178076 | 2178076 | 2022-02-03 | Ford | Illinois | 17053 | 4252 | 70 |
2178077 | 2178077 | 2022-02-03 | Franklin | Illinois | 17055 | 11738 | 162 |
2178078 | 2178078 | 2022-02-03 | Fulton | Illinois | 17057 | 9579 | 119 |
2178079 | 2178079 | 2022-02-03 | Gallatin | Illinois | 17059 | 1283 | 13 |
2178080 | 2178080 | 2022-02-03 | Greene | Illinois | 17061 | 3498 | 55 |
2178081 | 2178081 | 2022-02-03 | Grundy | Illinois | 17063 | 12214 | 129 |
2178082 | 2178082 | 2022-02-03 | Hamilton | Illinois | 17065 | 2078 | 31 |
2178083 | 2178083 | 2022-02-03 | Hancock | Illinois | 17067 | 4144 | 53 |
2178084 | 2178084 | 2022-02-03 | Hardin | Illinois | 17069 | 1012 | 18 |
2178085 | 2178085 | 2022-02-03 | Henderson | Illinois | 17071 | 1087 | 26 |
2178086 | 2178086 | 2022-02-03 | Henry | Illinois | 17073 | 12042 | 139 |
2178087 | 2178087 | 2022-02-03 | Iroquois | Illinois | 17075 | 6900 | 106 |
2178088 | 2178088 | 2022-02-03 | Jackson | Illinois | 17077 | 14732 | 116 |
2178089 | 2178089 | 2022-02-03 | Jasper | Illinois | 17079 | 2583 | 26 |
2178090 | 2178090 | 2022-02-03 | Jefferson | Illinois | 17081 | 10466 | 162 |
2178091 | 2178091 | 2022-02-03 | Jersey | Illinois | 17083 | 6038 | 81 |
2178092 | 2178092 | 2022-02-03 | Jo Daviess | Illinois | 17085 | 3789 | 36 |
2178093 | 2178093 | 2022-02-03 | Johnson | Illinois | 17087 | 3985 | 44 |
2178094 | 2178094 | 2022-02-03 | Kane | Illinois | 17089 | 119863 | 1093 |
2178095 | 2178095 | 2022-02-03 | Kankakee | Illinois | 17091 | 27981 | 353 |
2178096 | 2178096 | 2022-02-03 | Kendall | Illinois | 17093 | 29304 | 152 |
2178097 | 2178097 | 2022-02-03 | Knox | Illinois | 17095 | 12035 | 230 |
2178098 | 2178098 | 2022-02-03 | LaSalle | Illinois | 17099 | 27644 | 416 |
2178099 | 2178099 | 2022-02-03 | Lake | Illinois | 17097 | 141359 | 1316 |
2178100 | 2178100 | 2022-02-03 | Lawrence | Illinois | 17101 | 5257 | 49 |
2178101 | 2178101 | 2022-02-03 | Lee | Illinois | 17103 | 8305 | 113 |
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);