us-counties

Table actions
Big Local News snapshots this data daily from https://github.com/nytimes/covid-19-data. This is time series data for U.S. confirmed cases and deaths down to the county level. There are three CSV files released once a day: national-level data, state-level data and county-level data. Each file contains date, county/state name, FIPS code, number of confirmed cases, number of deaths going back to January 21. All data is gathered by New York Times reporters from state and local health departments or official government announcements. The data is updated once a day in the morning, usually around 8 a.m. EDT, with a full day’s worth of data from the day before. Please cite the New York Times as described in the README and check terms of use.

Data source: Big Local News · About: big-local-datasette

1,076,224 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: date (date)

Link rowid ▲ date county state fips cases deaths
1076224 1076224 2021-02-28 Weston Wyoming 56045 622 5
1076223 1076223 2021-02-28 Washakie Wyoming 56043 880 26
1076222 1076222 2021-02-28 Uinta Wyoming 56041 2053 12
1076221 1076221 2021-02-28 Teton Wyoming 56039 3351 9
1076220 1076220 2021-02-28 Sweetwater Wyoming 56037 3759 34
1076219 1076219 2021-02-28 Sublette Wyoming 56035 676 7
1076218 1076218 2021-02-28 Sheridan Wyoming 56033 3020 27
1076217 1076217 2021-02-28 Platte Wyoming 56031 590 11
1076216 1076216 2021-02-28 Park Wyoming 56029 2615 26
1076215 1076215 2021-02-28 Niobrara Wyoming 56027 149 2
1076214 1076214 2021-02-28 Natrona Wyoming 56025 7696 131
1076213 1076213 2021-02-28 Lincoln Wyoming 56023 1229 11
1076212 1076212 2021-02-28 Laramie Wyoming 56021 8188 106
1076211 1076211 2021-02-28 Johnson Wyoming 56019 712 9
1076210 1076210 2021-02-28 Hot Springs Wyoming 56017 360 3
1076209 1076209 2021-02-28 Goshen Wyoming 56015 1145 23
1076208 1076208 2021-02-28 Fremont Wyoming 56013 4868 82
1076207 1076207 2021-02-28 Crook Wyoming 56011 417 11
1076206 1076206 2021-02-28 Converse Wyoming 56009 970 17
1076205 1076205 2021-02-28 Carbon Wyoming 56007 1450 21
1076204 1076204 2021-02-28 Campbell Wyoming 56005 4664 57
1076203 1076203 2021-02-28 Big Horn Wyoming 56003 1075 30
1076202 1076202 2021-02-28 Albany Wyoming 56001 3905 11
1076201 1076201 2021-02-28 Wood Wisconsin 55141 7137 85
1076200 1076200 2021-02-28 Winnebago Wisconsin 55139 19738 204
1076199 1076199 2021-02-28 Waushara Wisconsin 55137 2403 34
1076198 1076198 2021-02-28 Waupaca Wisconsin 55135 5670 157
1076197 1076197 2021-02-28 Waukesha Wisconsin 55133 44784 525
1076196 1076196 2021-02-28 Washington Wisconsin 55131 15513 142
1076195 1076195 2021-02-28 Washburn Wisconsin 55129 1365 20
1076194 1076194 2021-02-28 Walworth Wisconsin 55127 11222 146
1076193 1076193 2021-02-28 Vilas Wisconsin 55125 2260 38
1076192 1076192 2021-02-28 Vernon Wisconsin 55123 1895 39
1076191 1076191 2021-02-28 Trempealeau Wisconsin 55121 3478 38
1076190 1076190 2021-02-28 Taylor Wisconsin 55119 2012 30
1076189 1076189 2021-02-28 St. Croix Wisconsin 55109 7996 47
1076188 1076188 2021-02-28 Sheboygan Wisconsin 55117 13656 136
1076187 1076187 2021-02-28 Shawano Wisconsin 55115 5094 81
1076186 1076186 2021-02-28 Sawyer Wisconsin 55113 1548 21
1076185 1076185 2021-02-28 Sauk Wisconsin 55111 5524 47
1076184 1076184 2021-02-28 Rusk Wisconsin 55107 1293 17
1076183 1076183 2021-02-28 Rock Wisconsin 55105 15950 173
1076182 1076182 2021-02-28 Richland Wisconsin 55103 1321 14
1076181 1076181 2021-02-28 Racine Wisconsin 55101 22940 349
1076180 1076180 2021-02-28 Price Wisconsin 55099 1254 7
1076179 1076179 2021-02-28 Portage Wisconsin 55097 7000 67
1076178 1076178 2021-02-28 Polk Wisconsin 55095 3990 46
1076177 1076177 2021-02-28 Pierce Wisconsin 55093 4366 39
1076176 1076176 2021-02-28 Pepin Wisconsin 55091 826 7
1076175 1076175 2021-02-28 Ozaukee Wisconsin 55089 8524 83
1076174 1076174 2021-02-28 Outagamie Wisconsin 55087 21610 207
1076173 1076173 2021-02-28 Oneida Wisconsin 55085 3514 71
1076172 1076172 2021-02-28 Oconto Wisconsin 55083 4709 55
1076171 1076171 2021-02-28 Monroe Wisconsin 55081 4411 32
1076170 1076170 2021-02-28 Milwaukee Wisconsin 55079 107069 1274
1076169 1076169 2021-02-28 Menominee Wisconsin 55078 797 11
1076168 1076168 2021-02-28 Marquette Wisconsin 55077 1486 26
1076167 1076167 2021-02-28 Marinette Wisconsin 55075 4364 66
1076166 1076166 2021-02-28 Marathon Wisconsin 55073 15025 209
1076165 1076165 2021-02-28 Manitowoc Wisconsin 55071 8363 81
1076164 1076164 2021-02-28 Lincoln Wisconsin 55069 3102 75
1076163 1076163 2021-02-28 Langlade Wisconsin 55067 2090 44
1076162 1076162 2021-02-28 Lafayette Wisconsin 55065 1611 8
1076161 1076161 2021-02-28 La Crosse Wisconsin 55063 12885 78
1076160 1076160 2021-02-28 Kewaunee Wisconsin 55061 2580 28
1076159 1076159 2021-02-28 Kenosha Wisconsin 55059 16956 315
1076158 1076158 2021-02-28 Juneau Wisconsin 55057 3068 20
1076157 1076157 2021-02-28 Jefferson Wisconsin 55055 8819 125
1076156 1076156 2021-02-28 Jackson Wisconsin 55053 2615 23
1076155 1076155 2021-02-28 Iron Wisconsin 55051 658 39
1076154 1076154 2021-02-28 Iowa Wisconsin 55049 1940 10
1076153 1076153 2021-02-28 Green Lake Wisconsin 55047 1944 21
1076152 1076152 2021-02-28 Green Wisconsin 55045 3257 22
1076151 1076151 2021-02-28 Grant Wisconsin 55043 5338 85
1076150 1076150 2021-02-28 Forest Wisconsin 55041 994 26
1076149 1076149 2021-02-28 Fond du Lac Wisconsin 55039 13046 101
1076148 1076148 2021-02-28 Florence Wisconsin 55037 468 12
1076147 1076147 2021-02-28 Eau Claire Wisconsin 55035 11309 114
1076146 1076146 2021-02-28 Dunn Wisconsin 55033 4592 28
1076145 1076145 2021-02-28 Douglas Wisconsin 55031 4236 40
1076144 1076144 2021-02-28 Door Wisconsin 55029 2613 25
1076143 1076143 2021-02-28 Dodge Wisconsin 55027 12184 176
1076142 1076142 2021-02-28 Dane Wisconsin 55025 42100 296
1076141 1076141 2021-02-28 Crawford Wisconsin 55023 1718 17
1076140 1076140 2021-02-28 Columbia Wisconsin 55021 5410 60
1076139 1076139 2021-02-28 Clark Wisconsin 55019 3543 61
1076138 1076138 2021-02-28 Chippewa Wisconsin 55017 7224 94
1076137 1076137 2021-02-28 Calumet Wisconsin 55015 6014 46
1076136 1076136 2021-02-28 Burnett Wisconsin 55013 1342 23
1076135 1076135 2021-02-28 Buffalo Wisconsin 55011 1352 7
1076134 1076134 2021-02-28 Brown Wisconsin 55009 32637 250
1076133 1076133 2021-02-28 Bayfield Wisconsin 55007 1139 19
1076132 1076132 2021-02-28 Barron Wisconsin 55005 5509 76
1076131 1076131 2021-02-28 Ashland Wisconsin 55003 1241 16
1076130 1076130 2021-02-28 Adams Wisconsin 55001 1739 15
1076129 1076129 2021-02-28 Wyoming West Virginia 54109 1741 34
1076128 1076128 2021-02-28 Wood West Virginia 54107 7047 131
1076127 1076127 2021-02-28 Wirt West Virginia 54105 359 2
1076126 1076126 2021-02-28 Wetzel West Virginia 54103 1086 19
1076125 1076125 2021-02-28 Webster West Virginia 54101 321 3

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us-counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);