ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,248,308 rows sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

Link rowid date ▲ county state fips cases deaths
1248308 1248308 2021-04-22 Weston Wyoming 56045 647 5
1248307 1248307 2021-04-22 Washakie Wyoming 56043 897 26
1248306 1248306 2021-04-22 Uinta Wyoming 56041 2157 12
1248305 1248305 2021-04-22 Teton Wyoming 56039 3715 9
1248304 1248304 2021-04-22 Sweetwater Wyoming 56037 4151 37
1248303 1248303 2021-04-22 Sublette Wyoming 56035 757 7
1248302 1248302 2021-04-22 Sheridan Wyoming 56033 3112 31
1248301 1248301 2021-04-22 Platte Wyoming 56031 618 11
1248300 1248300 2021-04-22 Park Wyoming 56029 2668 30
1248299 1248299 2021-04-22 Niobrara Wyoming 56027 151 2
1248298 1248298 2021-04-22 Natrona Wyoming 56025 7913 136
1248297 1248297 2021-04-22 Lincoln Wyoming 56023 1388 12
1248296 1248296 2021-04-22 Laramie Wyoming 56021 8933 113
1248295 1248295 2021-04-22 Johnson Wyoming 56019 717 10
1248294 1248294 2021-04-22 Hot Springs Wyoming 56017 366 3
1248293 1248293 2021-04-22 Goshen Wyoming 56015 1201 23
1248292 1248292 2021-04-22 Fremont Wyoming 56013 5132 83
1248291 1248291 2021-04-22 Crook Wyoming 56011 428 12
1248290 1248290 2021-04-22 Converse Wyoming 56009 990 17
1248289 1248289 2021-04-22 Carbon Wyoming 56007 1556 23
1248288 1248288 2021-04-22 Campbell Wyoming 56005 4814 60
1248287 1248287 2021-04-22 Big Horn Wyoming 56003 1132 32
1248286 1248286 2021-04-22 Albany Wyoming 56001 4170 11
1248285 1248285 2021-04-22 Wood Wisconsin 55141 7374 90
1248284 1248284 2021-04-22 Winnebago Wisconsin 55139 20924 212
1248283 1248283 2021-04-22 Waushara Wisconsin 55137 2465 36
1248282 1248282 2021-04-22 Waupaca Wisconsin 55135 5966 161
1248281 1248281 2021-04-22 Waukesha Wisconsin 55133 48052 566
1248280 1248280 2021-04-22 Washington Wisconsin 55131 16434 153
1248279 1248279 2021-04-22 Washburn Wisconsin 55129 1504 20
1248278 1248278 2021-04-22 Walworth Wisconsin 55127 12239 155
1248277 1248277 2021-04-22 Vilas Wisconsin 55125 2365 41
1248276 1248276 2021-04-22 Vernon Wisconsin 55123 1967 42
1248275 1248275 2021-04-22 Trempealeau Wisconsin 55121 3607 43
1248274 1248274 2021-04-22 Taylor Wisconsin 55119 2084 32
1248273 1248273 2021-04-22 St. Croix Wisconsin 55109 9080 57
1248272 1248272 2021-04-22 Sheboygan Wisconsin 55117 14488 145
1248271 1248271 2021-04-22 Shawano Wisconsin 55115 5240 82
1248270 1248270 2021-04-22 Sawyer Wisconsin 55113 1663 25
1248269 1248269 2021-04-22 Sauk Wisconsin 55111 5954 52
1248268 1248268 2021-04-22 Rusk Wisconsin 55107 1333 18
1248267 1248267 2021-04-22 Rock Wisconsin 55105 17243 187
1248266 1248266 2021-04-22 Richland Wisconsin 55103 1368 15
1248265 1248265 2021-04-22 Racine Wisconsin 55101 24191 365
1248264 1248264 2021-04-22 Price Wisconsin 55099 1323 7
1248263 1248263 2021-04-22 Portage Wisconsin 55097 7218 70
1248262 1248262 2021-04-22 Polk Wisconsin 55095 4391 49
1248261 1248261 2021-04-22 Pierce Wisconsin 55093 4768 42
1248260 1248260 2021-04-22 Pepin Wisconsin 55091 862 7
1248259 1248259 2021-04-22 Ozaukee Wisconsin 55089 9054 90
1248258 1248258 2021-04-22 Outagamie Wisconsin 55087 23301 217
1248257 1248257 2021-04-22 Oneida Wisconsin 55085 3746 74
1248256 1248256 2021-04-22 Oconto Wisconsin 55083 4897 58
1248255 1248255 2021-04-22 Monroe Wisconsin 55081 4564 38
1248254 1248254 2021-04-22 Milwaukee Wisconsin 55079 113723 1325
1248253 1248253 2021-04-22 Menominee Wisconsin 55078 800 11
1248252 1248252 2021-04-22 Marquette Wisconsin 55077 1546 27
1248251 1248251 2021-04-22 Marinette Wisconsin 55075 4499 68
1248250 1248250 2021-04-22 Marathon Wisconsin 55073 15855 219
1248249 1248249 2021-04-22 Manitowoc Wisconsin 55071 8664 87
1248248 1248248 2021-04-22 Lincoln Wisconsin 55069 3250 89
1248247 1248247 2021-04-22 Langlade Wisconsin 55067 2144 46
1248246 1248246 2021-04-22 Lafayette Wisconsin 55065 1694 8
1248245 1248245 2021-04-22 La Crosse Wisconsin 55063 13354 80
1248244 1248244 2021-04-22 Kewaunee Wisconsin 55061 2655 34
1248243 1248243 2021-04-22 Kenosha Wisconsin 55059 17985 320
1248242 1248242 2021-04-22 Juneau Wisconsin 55057 3192 26
1248241 1248241 2021-04-22 Jefferson Wisconsin 55055 9417 131
1248240 1248240 2021-04-22 Jackson Wisconsin 55053 2671 28
1248239 1248239 2021-04-22 Iron Wisconsin 55051 688 40
1248238 1248238 2021-04-22 Iowa Wisconsin 55049 2081 11
1248237 1248237 2021-04-22 Green Lake Wisconsin 55047 2000 22
1248236 1248236 2021-04-22 Green Wisconsin 55045 3568 23
1248235 1248235 2021-04-22 Grant Wisconsin 55043 5622 90
1248234 1248234 2021-04-22 Forest Wisconsin 55041 1025 26
1248233 1248233 2021-04-22 Fond du Lac Wisconsin 55039 13463 114
1248232 1248232 2021-04-22 Florence Wisconsin 55037 497 12
1248231 1248231 2021-04-22 Eau Claire Wisconsin 55035 11760 118
1248230 1248230 2021-04-22 Dunn Wisconsin 55033 4974 32
1248229 1248229 2021-04-22 Douglas Wisconsin 55031 4695 50
1248228 1248228 2021-04-22 Door Wisconsin 55029 2790 28
1248227 1248227 2021-04-22 Dodge Wisconsin 55027 12618 183
1248226 1248226 2021-04-22 Dane Wisconsin 55025 45235 316
1248225 1248225 2021-04-22 Crawford Wisconsin 55023 1762 17
1248224 1248224 2021-04-22 Columbia Wisconsin 55021 5699 69
1248223 1248223 2021-04-22 Clark Wisconsin 55019 3612 62
1248222 1248222 2021-04-22 Chippewa Wisconsin 55017 7473 96
1248221 1248221 2021-04-22 Calumet Wisconsin 55015 6369 50
1248220 1248220 2021-04-22 Burnett Wisconsin 55013 1472 22
1248219 1248219 2021-04-22 Buffalo Wisconsin 55011 1379 7
1248218 1248218 2021-04-22 Brown Wisconsin 55009 34546 274
1248217 1248217 2021-04-22 Bayfield Wisconsin 55007 1236 19
1248216 1248216 2021-04-22 Barron Wisconsin 55005 5822 77
1248215 1248215 2021-04-22 Ashland Wisconsin 55003 1311 15
1248214 1248214 2021-04-22 Adams Wisconsin 55001 1870 17
1248213 1248213 2021-04-22 Wyoming West Virginia 54109 1934 42
1248212 1248212 2021-04-22 Wood West Virginia 54107 7600 168
1248211 1248211 2021-04-22 Wirt West Virginia 54105 382 3
1248210 1248210 2021-04-22 Wetzel West Virginia 54103 1224 29
1248209 1248209 2021-04-22 Webster West Virginia 54101 456 7

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);