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 95,196
- Georgia 62,969
- Virginia 51,649
- Kentucky 46,132
- Missouri 44,320
- Illinois 39,641
- North Carolina 39,109
- Kansas 38,623
- Iowa 38,370
- Tennessee 37,567
- Indiana 36,282
- Ohio 34,658
- Minnesota 33,827
- Nebraska 32,924
- Michigan 32,694
- Mississippi 32,356
- Oklahoma 29,737
- Arkansas 29,620
- Wisconsin 28,199
- Puerto Rico 27,824
- Florida 27,046
- Pennsylvania 26,512
- Alabama 26,383
- Louisiana 25,748
- Colorado 24,759
- South Dakota 24,010
- New York 23,246
- California 23,239
- West Virginia 20,967
- North Dakota 19,601
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1248210 | 1248210 | 2021-04-22 | Putnam | West Virginia | 54079 | 4854 | 100 |
1248211 | 1248211 | 2021-04-22 | Raleigh | West Virginia | 54081 | 6288 | 79 |
1248212 | 1248212 | 2021-04-22 | Randolph | West Virginia | 54083 | 2504 | 13 |
1248213 | 1248213 | 2021-04-22 | Ritchie | West Virginia | 54085 | 667 | 11 |
1248214 | 1248214 | 2021-04-22 | Roane | West Virginia | 54087 | 588 | 8 |
1248215 | 1248215 | 2021-04-22 | Summers | West Virginia | 54089 | 773 | 23 |
1248216 | 1248216 | 2021-04-22 | Taylor | West Virginia | 54091 | 1204 | 23 |
1248217 | 1248217 | 2021-04-22 | Tucker | West Virginia | 54093 | 524 | 10 |
1248218 | 1248218 | 2021-04-22 | Tyler | West Virginia | 54095 | 677 | 9 |
1248219 | 1248219 | 2021-04-22 | Upshur | West Virginia | 54097 | 1826 | 35 |
1248220 | 1248220 | 2021-04-22 | Wayne | West Virginia | 54099 | 2827 | 39 |
1248221 | 1248221 | 2021-04-22 | Webster | West Virginia | 54101 | 456 | 7 |
1248222 | 1248222 | 2021-04-22 | Wetzel | West Virginia | 54103 | 1224 | 29 |
1248223 | 1248223 | 2021-04-22 | Wirt | West Virginia | 54105 | 382 | 3 |
1248224 | 1248224 | 2021-04-22 | Wood | West Virginia | 54107 | 7600 | 168 |
1248225 | 1248225 | 2021-04-22 | Wyoming | West Virginia | 54109 | 1934 | 42 |
1248226 | 1248226 | 2021-04-22 | Adams | Wisconsin | 55001 | 1870 | 17 |
1248227 | 1248227 | 2021-04-22 | Ashland | Wisconsin | 55003 | 1311 | 15 |
1248228 | 1248228 | 2021-04-22 | Barron | Wisconsin | 55005 | 5822 | 77 |
1248229 | 1248229 | 2021-04-22 | Bayfield | Wisconsin | 55007 | 1236 | 19 |
1248230 | 1248230 | 2021-04-22 | Brown | Wisconsin | 55009 | 34546 | 274 |
1248231 | 1248231 | 2021-04-22 | Buffalo | Wisconsin | 55011 | 1379 | 7 |
1248232 | 1248232 | 2021-04-22 | Burnett | Wisconsin | 55013 | 1472 | 22 |
1248233 | 1248233 | 2021-04-22 | Calumet | Wisconsin | 55015 | 6369 | 50 |
1248234 | 1248234 | 2021-04-22 | Chippewa | Wisconsin | 55017 | 7473 | 96 |
1248235 | 1248235 | 2021-04-22 | Clark | Wisconsin | 55019 | 3612 | 62 |
1248236 | 1248236 | 2021-04-22 | Columbia | Wisconsin | 55021 | 5699 | 69 |
1248237 | 1248237 | 2021-04-22 | Crawford | Wisconsin | 55023 | 1762 | 17 |
1248238 | 1248238 | 2021-04-22 | Dane | Wisconsin | 55025 | 45235 | 316 |
1248239 | 1248239 | 2021-04-22 | Dodge | Wisconsin | 55027 | 12618 | 183 |
1248240 | 1248240 | 2021-04-22 | Door | Wisconsin | 55029 | 2790 | 28 |
1248241 | 1248241 | 2021-04-22 | Douglas | Wisconsin | 55031 | 4695 | 50 |
1248242 | 1248242 | 2021-04-22 | Dunn | Wisconsin | 55033 | 4974 | 32 |
1248243 | 1248243 | 2021-04-22 | Eau Claire | Wisconsin | 55035 | 11760 | 118 |
1248244 | 1248244 | 2021-04-22 | Florence | Wisconsin | 55037 | 497 | 12 |
1248245 | 1248245 | 2021-04-22 | Fond du Lac | Wisconsin | 55039 | 13463 | 114 |
1248246 | 1248246 | 2021-04-22 | Forest | Wisconsin | 55041 | 1025 | 26 |
1248247 | 1248247 | 2021-04-22 | Grant | Wisconsin | 55043 | 5622 | 90 |
1248248 | 1248248 | 2021-04-22 | Green | Wisconsin | 55045 | 3568 | 23 |
1248249 | 1248249 | 2021-04-22 | Green Lake | Wisconsin | 55047 | 2000 | 22 |
1248250 | 1248250 | 2021-04-22 | Iowa | Wisconsin | 55049 | 2081 | 11 |
1248251 | 1248251 | 2021-04-22 | Iron | Wisconsin | 55051 | 688 | 40 |
1248252 | 1248252 | 2021-04-22 | Jackson | Wisconsin | 55053 | 2671 | 28 |
1248253 | 1248253 | 2021-04-22 | Jefferson | Wisconsin | 55055 | 9417 | 131 |
1248254 | 1248254 | 2021-04-22 | Juneau | Wisconsin | 55057 | 3192 | 26 |
1248255 | 1248255 | 2021-04-22 | Kenosha | Wisconsin | 55059 | 17985 | 320 |
1248256 | 1248256 | 2021-04-22 | Kewaunee | Wisconsin | 55061 | 2655 | 34 |
1248257 | 1248257 | 2021-04-22 | La Crosse | Wisconsin | 55063 | 13354 | 80 |
1248258 | 1248258 | 2021-04-22 | Lafayette | Wisconsin | 55065 | 1694 | 8 |
1248259 | 1248259 | 2021-04-22 | Langlade | Wisconsin | 55067 | 2144 | 46 |
1248260 | 1248260 | 2021-04-22 | Lincoln | Wisconsin | 55069 | 3250 | 89 |
1248261 | 1248261 | 2021-04-22 | Manitowoc | Wisconsin | 55071 | 8664 | 87 |
1248262 | 1248262 | 2021-04-22 | Marathon | Wisconsin | 55073 | 15855 | 219 |
1248263 | 1248263 | 2021-04-22 | Marinette | Wisconsin | 55075 | 4499 | 68 |
1248264 | 1248264 | 2021-04-22 | Marquette | Wisconsin | 55077 | 1546 | 27 |
1248265 | 1248265 | 2021-04-22 | Menominee | Wisconsin | 55078 | 800 | 11 |
1248266 | 1248266 | 2021-04-22 | Milwaukee | Wisconsin | 55079 | 113723 | 1325 |
1248267 | 1248267 | 2021-04-22 | Monroe | Wisconsin | 55081 | 4564 | 38 |
1248268 | 1248268 | 2021-04-22 | Oconto | Wisconsin | 55083 | 4897 | 58 |
1248269 | 1248269 | 2021-04-22 | Oneida | Wisconsin | 55085 | 3746 | 74 |
1248270 | 1248270 | 2021-04-22 | Outagamie | Wisconsin | 55087 | 23301 | 217 |
1248271 | 1248271 | 2021-04-22 | Ozaukee | Wisconsin | 55089 | 9054 | 90 |
1248272 | 1248272 | 2021-04-22 | Pepin | Wisconsin | 55091 | 862 | 7 |
1248273 | 1248273 | 2021-04-22 | Pierce | Wisconsin | 55093 | 4768 | 42 |
1248274 | 1248274 | 2021-04-22 | Polk | Wisconsin | 55095 | 4391 | 49 |
1248275 | 1248275 | 2021-04-22 | Portage | Wisconsin | 55097 | 7218 | 70 |
1248276 | 1248276 | 2021-04-22 | Price | Wisconsin | 55099 | 1323 | 7 |
1248277 | 1248277 | 2021-04-22 | Racine | Wisconsin | 55101 | 24191 | 365 |
1248278 | 1248278 | 2021-04-22 | Richland | Wisconsin | 55103 | 1368 | 15 |
1248279 | 1248279 | 2021-04-22 | Rock | Wisconsin | 55105 | 17243 | 187 |
1248280 | 1248280 | 2021-04-22 | Rusk | Wisconsin | 55107 | 1333 | 18 |
1248281 | 1248281 | 2021-04-22 | Sauk | Wisconsin | 55111 | 5954 | 52 |
1248282 | 1248282 | 2021-04-22 | Sawyer | Wisconsin | 55113 | 1663 | 25 |
1248283 | 1248283 | 2021-04-22 | Shawano | Wisconsin | 55115 | 5240 | 82 |
1248284 | 1248284 | 2021-04-22 | Sheboygan | Wisconsin | 55117 | 14488 | 145 |
1248285 | 1248285 | 2021-04-22 | St. Croix | Wisconsin | 55109 | 9080 | 57 |
1248286 | 1248286 | 2021-04-22 | Taylor | Wisconsin | 55119 | 2084 | 32 |
1248287 | 1248287 | 2021-04-22 | Trempealeau | Wisconsin | 55121 | 3607 | 43 |
1248288 | 1248288 | 2021-04-22 | Vernon | Wisconsin | 55123 | 1967 | 42 |
1248289 | 1248289 | 2021-04-22 | Vilas | Wisconsin | 55125 | 2365 | 41 |
1248290 | 1248290 | 2021-04-22 | Walworth | Wisconsin | 55127 | 12239 | 155 |
1248291 | 1248291 | 2021-04-22 | Washburn | Wisconsin | 55129 | 1504 | 20 |
1248292 | 1248292 | 2021-04-22 | Washington | Wisconsin | 55131 | 16434 | 153 |
1248293 | 1248293 | 2021-04-22 | Waukesha | Wisconsin | 55133 | 48052 | 566 |
1248294 | 1248294 | 2021-04-22 | Waupaca | Wisconsin | 55135 | 5966 | 161 |
1248295 | 1248295 | 2021-04-22 | Waushara | Wisconsin | 55137 | 2465 | 36 |
1248296 | 1248296 | 2021-04-22 | Winnebago | Wisconsin | 55139 | 20924 | 212 |
1248297 | 1248297 | 2021-04-22 | Wood | Wisconsin | 55141 | 7374 | 90 |
1248298 | 1248298 | 2021-04-22 | Albany | Wyoming | 56001 | 4170 | 11 |
1248299 | 1248299 | 2021-04-22 | Big Horn | Wyoming | 56003 | 1132 | 32 |
1248300 | 1248300 | 2021-04-22 | Campbell | Wyoming | 56005 | 4814 | 60 |
1248301 | 1248301 | 2021-04-22 | Carbon | Wyoming | 56007 | 1556 | 23 |
1248302 | 1248302 | 2021-04-22 | Converse | Wyoming | 56009 | 990 | 17 |
1248303 | 1248303 | 2021-04-22 | Crook | Wyoming | 56011 | 428 | 12 |
1248304 | 1248304 | 2021-04-22 | Fremont | Wyoming | 56013 | 5132 | 83 |
1248305 | 1248305 | 2021-04-22 | Goshen | Wyoming | 56015 | 1201 | 23 |
1248306 | 1248306 | 2021-04-22 | Hot Springs | Wyoming | 56017 | 366 | 3 |
1248307 | 1248307 | 2021-04-22 | Johnson | Wyoming | 56019 | 717 | 10 |
1248308 | 1248308 | 2021-04-22 | Laramie | Wyoming | 56021 | 8933 | 113 |
1248309 | 1248309 | 2021-04-22 | Lincoln | Wyoming | 56023 | 1388 | 12 |
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);