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 192,499
- Georgia 124,089
- Virginia 102,596
- Kentucky 92,092
- Missouri 89,132
- Illinois 79,090
- Kansas 78,870
- North Carolina 77,409
- Iowa 76,670
- Tennessee 74,335
- Indiana 71,549
- Nebraska 68,879
- Ohio 68,745
- Minnesota 67,531
- Michigan 64,866
- Mississippi 63,815
- Oklahoma 59,611
- Arkansas 58,652
- Puerto Rico 58,081
- Wisconsin 55,705
- Florida 53,022
- Pennsylvania 52,173
- Alabama 51,977
- Louisiana 50,642
- South Dakota 49,288
- Colorado 49,207
- New York 45,460
- California 45,403
- West Virginia 42,018
- Montana 40,432
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2487134 | 2487134 | 2022-05-09 | Madison | Idaho | 16065 | 12669 | 50 |
2487135 | 2487135 | 2022-05-09 | Minidoka | Idaho | 16067 | 4233 | 64 |
2487136 | 2487136 | 2022-05-09 | Nez Perce | Idaho | 16069 | 8950 | 148 |
2487137 | 2487137 | 2022-05-09 | Oneida | Idaho | 16071 | 806 | 11 |
2487138 | 2487138 | 2022-05-09 | Owyhee | Idaho | 16073 | 2271 | 53 |
2487139 | 2487139 | 2022-05-09 | Payette | Idaho | 16075 | 5579 | 87 |
2487140 | 2487140 | 2022-05-09 | Power | Idaho | 16077 | 1495 | 20 |
2487141 | 2487141 | 2022-05-09 | Shoshone | Idaho | 16079 | 2739 | 76 |
2487142 | 2487142 | 2022-05-09 | Teton | Idaho | 16081 | 2721 | 9 |
2487143 | 2487143 | 2022-05-09 | Twin Falls | Idaho | 16083 | 24107 | 295 |
2487144 | 2487144 | 2022-05-09 | Valley | Idaho | 16085 | 2633 | 16 |
2487145 | 2487145 | 2022-05-09 | Washington | Idaho | 16087 | 2392 | 57 |
2487146 | 2487146 | 2022-05-09 | Adams | Illinois | 17001 | 22479 | 238 |
2487147 | 2487147 | 2022-05-09 | Alexander | Illinois | 17003 | 1287 | 15 |
2487148 | 2487148 | 2022-05-09 | Bond | Illinois | 17005 | 4360 | 37 |
2487149 | 2487149 | 2022-05-09 | Boone | Illinois | 17007 | 14095 | 130 |
2487150 | 2487150 | 2022-05-09 | Brown | Illinois | 17009 | 2426 | 21 |
2487151 | 2487151 | 2022-05-09 | Bureau | Illinois | 17011 | 8426 | 140 |
2487152 | 2487152 | 2022-05-09 | Calhoun | Illinois | 17013 | 1531 | 8 |
2487153 | 2487153 | 2022-05-09 | Carroll | Illinois | 17015 | 4292 | 49 |
2487154 | 2487154 | 2022-05-09 | Cass | Illinois | 17017 | 4632 | 44 |
2487155 | 2487155 | 2022-05-09 | Champaign | Illinois | 17019 | 66475 | 296 |
2487156 | 2487156 | 2022-05-09 | Christian | Illinois | 17021 | 10305 | 131 |
2487157 | 2487157 | 2022-05-09 | Clark | Illinois | 17023 | 4875 | 60 |
2487158 | 2487158 | 2022-05-09 | Clay | Illinois | 17025 | 4747 | 74 |
2487159 | 2487159 | 2022-05-09 | Clinton | Illinois | 17027 | 12028 | 122 |
2487160 | 2487160 | 2022-05-09 | Coles | Illinois | 17029 | 15491 | 175 |
2487161 | 2487161 | 2022-05-09 | Cook | Illinois | 17031 | 1182472 | 14923 |
2487162 | 2487162 | 2022-05-09 | Crawford | Illinois | 17033 | 6233 | 61 |
2487163 | 2487163 | 2022-05-09 | Cumberland | Illinois | 17035 | 3375 | 49 |
2487164 | 2487164 | 2022-05-09 | De Witt | Illinois | 17039 | 4404 | 44 |
2487165 | 2487165 | 2022-05-09 | DeKalb | Illinois | 17037 | 24288 | 201 |
2487166 | 2487166 | 2022-05-09 | Douglas | Illinois | 17041 | 6581 | 61 |
2487167 | 2487167 | 2022-05-09 | DuPage | Illinois | 17043 | 222090 | 1800 |
2487168 | 2487168 | 2022-05-09 | Edgar | Illinois | 17045 | 5201 | 79 |
2487169 | 2487169 | 2022-05-09 | Edwards | Illinois | 17047 | 1746 | 29 |
2487170 | 2487170 | 2022-05-09 | Effingham | Illinois | 17049 | 10701 | 150 |
2487171 | 2487171 | 2022-05-09 | Fayette | Illinois | 17051 | 7142 | 104 |
2487172 | 2487172 | 2022-05-09 | Ford | Illinois | 17053 | 4476 | 75 |
2487173 | 2487173 | 2022-05-09 | Franklin | Illinois | 17055 | 12255 | 178 |
2487174 | 2487174 | 2022-05-09 | Fulton | Illinois | 17057 | 10204 | 135 |
2487175 | 2487175 | 2022-05-09 | Gallatin | Illinois | 17059 | 1411 | 18 |
2487176 | 2487176 | 2022-05-09 | Greene | Illinois | 17061 | 3651 | 58 |
2487177 | 2487177 | 2022-05-09 | Grundy | Illinois | 17063 | 12945 | 140 |
2487178 | 2487178 | 2022-05-09 | Hamilton | Illinois | 17065 | 2181 | 34 |
2487179 | 2487179 | 2022-05-09 | Hancock | Illinois | 17067 | 4412 | 58 |
2487180 | 2487180 | 2022-05-09 | Hardin | Illinois | 17069 | 1057 | 20 |
2487181 | 2487181 | 2022-05-09 | Henderson | Illinois | 17071 | 1158 | 28 |
2487182 | 2487182 | 2022-05-09 | Henry | Illinois | 17073 | 12830 | 150 |
2487183 | 2487183 | 2022-05-09 | Iroquois | Illinois | 17075 | 7260 | 118 |
2487184 | 2487184 | 2022-05-09 | Jackson | Illinois | 17077 | 15752 | 130 |
2487185 | 2487185 | 2022-05-09 | Jasper | Illinois | 17079 | 2688 | 32 |
2487186 | 2487186 | 2022-05-09 | Jefferson | Illinois | 17081 | 11146 | 176 |
2487187 | 2487187 | 2022-05-09 | Jersey | Illinois | 17083 | 6299 | 91 |
2487188 | 2487188 | 2022-05-09 | Jo Daviess | Illinois | 17085 | 4082 | 39 |
2487189 | 2487189 | 2022-05-09 | Johnson | Illinois | 17087 | 4501 | 46 |
2487190 | 2487190 | 2022-05-09 | Kane | Illinois | 17089 | 130712 | 1179 |
2487191 | 2487191 | 2022-05-09 | Kankakee | Illinois | 17091 | 29216 | 373 |
2487192 | 2487192 | 2022-05-09 | Kendall | Illinois | 17093 | 32197 | 170 |
2487193 | 2487193 | 2022-05-09 | Knox | Illinois | 17095 | 12666 | 246 |
2487194 | 2487194 | 2022-05-09 | LaSalle | Illinois | 17099 | 29528 | 441 |
2487195 | 2487195 | 2022-05-09 | Lake | Illinois | 17097 | 157445 | 1464 |
2487196 | 2487196 | 2022-05-09 | Lawrence | Illinois | 17101 | 5494 | 52 |
2487197 | 2487197 | 2022-05-09 | Lee | Illinois | 17103 | 8972 | 118 |
2487198 | 2487198 | 2022-05-09 | Livingston | Illinois | 17105 | 10868 | 148 |
2487199 | 2487199 | 2022-05-09 | Logan | Illinois | 17107 | 9818 | 100 |
2487200 | 2487200 | 2022-05-09 | Macon | Illinois | 17115 | 30986 | 354 |
2487201 | 2487201 | 2022-05-09 | Macoupin | Illinois | 17117 | 12928 | 171 |
2487202 | 2487202 | 2022-05-09 | Madison | Illinois | 17119 | 71260 | 865 |
2487203 | 2487203 | 2022-05-09 | Marion | Illinois | 17121 | 11916 | 217 |
2487204 | 2487204 | 2022-05-09 | Marshall | Illinois | 17123 | 2799 | 33 |
2487205 | 2487205 | 2022-05-09 | Mason | Illinois | 17125 | 3945 | 61 |
2487206 | 2487206 | 2022-05-09 | Massac | Illinois | 17127 | 3886 | 71 |
2487207 | 2487207 | 2022-05-09 | McDonough | Illinois | 17109 | 7276 | 104 |
2487208 | 2487208 | 2022-05-09 | McHenry | Illinois | 17111 | 78452 | 511 |
2487209 | 2487209 | 2022-05-09 | McLean | Illinois | 17113 | 51894 | 330 |
2487210 | 2487210 | 2022-05-09 | Menard | Illinois | 17129 | 3548 | 24 |
2487211 | 2487211 | 2022-05-09 | Mercer | Illinois | 17131 | 4059 | 47 |
2487212 | 2487212 | 2022-05-09 | Monroe | Illinois | 17133 | 9599 | 128 |
2487213 | 2487213 | 2022-05-09 | Montgomery | Illinois | 17135 | 9858 | 111 |
2487214 | 2487214 | 2022-05-09 | Morgan | Illinois | 17137 | 9629 | 144 |
2487215 | 2487215 | 2022-05-09 | Moultrie | Illinois | 17139 | 4092 | 52 |
2487216 | 2487216 | 2022-05-09 | Ogle | Illinois | 17141 | 14226 | 136 |
2487217 | 2487217 | 2022-05-09 | Peoria | Illinois | 17143 | 47593 | 555 |
2487218 | 2487218 | 2022-05-09 | Perry | Illinois | 17145 | 7498 | 106 |
2487219 | 2487219 | 2022-05-09 | Piatt | Illinois | 17147 | 4554 | 29 |
2487220 | 2487220 | 2022-05-09 | Pike | Illinois | 17149 | 5044 | 70 |
2487221 | 2487221 | 2022-05-09 | Pope | Illinois | 17151 | 959 | 8 |
2487222 | 2487222 | 2022-05-09 | Pulaski | Illinois | 17153 | 1726 | 19 |
2487223 | 2487223 | 2022-05-09 | Putnam | Illinois | 17155 | 1155 | 10 |
2487224 | 2487224 | 2022-05-09 | Randolph | Illinois | 17157 | 10547 | 132 |
2487225 | 2487225 | 2022-05-09 | Richland | Illinois | 17159 | 5164 | 83 |
2487226 | 2487226 | 2022-05-09 | Rock Island | Illinois | 17161 | 33622 | 522 |
2487227 | 2487227 | 2022-05-09 | Saline | Illinois | 17165 | 7915 | 111 |
2487228 | 2487228 | 2022-05-09 | Sangamon | Illinois | 17167 | 56175 | 432 |
2487229 | 2487229 | 2022-05-09 | Schuyler | Illinois | 17169 | 1968 | 29 |
2487230 | 2487230 | 2022-05-09 | Scott | Illinois | 17171 | 1271 | 12 |
2487231 | 2487231 | 2022-05-09 | Shelby | Illinois | 17173 | 6252 | 80 |
2487232 | 2487232 | 2022-05-09 | St. Clair | Illinois | 17163 | 70298 | 775 |
2487233 | 2487233 | 2022-05-09 | Stark | Illinois | 17175 | 1527 | 33 |
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);