us-counties-recent

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

94,127 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
94127 94127 2021-02-28 Weston Wyoming 56045 622 5
94126 94126 2021-02-28 Washakie Wyoming 56043 880 26
94125 94125 2021-02-28 Uinta Wyoming 56041 2053 12
94124 94124 2021-02-28 Teton Wyoming 56039 3351 9
94123 94123 2021-02-28 Sweetwater Wyoming 56037 3759 34
94122 94122 2021-02-28 Sublette Wyoming 56035 676 7
94121 94121 2021-02-28 Sheridan Wyoming 56033 3020 27
94120 94120 2021-02-28 Platte Wyoming 56031 590 11
94119 94119 2021-02-28 Park Wyoming 56029 2615 26
94118 94118 2021-02-28 Niobrara Wyoming 56027 149 2
94117 94117 2021-02-28 Natrona Wyoming 56025 7696 131
94116 94116 2021-02-28 Lincoln Wyoming 56023 1229 11
94115 94115 2021-02-28 Laramie Wyoming 56021 8188 106
94114 94114 2021-02-28 Johnson Wyoming 56019 712 9
94113 94113 2021-02-28 Hot Springs Wyoming 56017 360 3
94112 94112 2021-02-28 Goshen Wyoming 56015 1145 23
94111 94111 2021-02-28 Fremont Wyoming 56013 4868 82
94110 94110 2021-02-28 Crook Wyoming 56011 417 11
94109 94109 2021-02-28 Converse Wyoming 56009 970 17
94108 94108 2021-02-28 Carbon Wyoming 56007 1450 21
94107 94107 2021-02-28 Campbell Wyoming 56005 4664 57
94106 94106 2021-02-28 Big Horn Wyoming 56003 1075 30
94105 94105 2021-02-28 Albany Wyoming 56001 3905 11
94104 94104 2021-02-28 Wood Wisconsin 55141 7137 85
94103 94103 2021-02-28 Winnebago Wisconsin 55139 19738 204
94102 94102 2021-02-28 Waushara Wisconsin 55137 2403 34
94101 94101 2021-02-28 Waupaca Wisconsin 55135 5670 157
94100 94100 2021-02-28 Waukesha Wisconsin 55133 44784 525
94099 94099 2021-02-28 Washington Wisconsin 55131 15513 142
94098 94098 2021-02-28 Washburn Wisconsin 55129 1365 20
94097 94097 2021-02-28 Walworth Wisconsin 55127 11222 146
94096 94096 2021-02-28 Vilas Wisconsin 55125 2260 38
94095 94095 2021-02-28 Vernon Wisconsin 55123 1895 39
94094 94094 2021-02-28 Trempealeau Wisconsin 55121 3478 38
94093 94093 2021-02-28 Taylor Wisconsin 55119 2012 30
94092 94092 2021-02-28 St. Croix Wisconsin 55109 7996 47
94091 94091 2021-02-28 Sheboygan Wisconsin 55117 13656 136
94090 94090 2021-02-28 Shawano Wisconsin 55115 5094 81
94089 94089 2021-02-28 Sawyer Wisconsin 55113 1548 21
94088 94088 2021-02-28 Sauk Wisconsin 55111 5524 47
94087 94087 2021-02-28 Rusk Wisconsin 55107 1293 17
94086 94086 2021-02-28 Rock Wisconsin 55105 15950 173
94085 94085 2021-02-28 Richland Wisconsin 55103 1321 14
94084 94084 2021-02-28 Racine Wisconsin 55101 22940 349
94083 94083 2021-02-28 Price Wisconsin 55099 1254 7
94082 94082 2021-02-28 Portage Wisconsin 55097 7000 67
94081 94081 2021-02-28 Polk Wisconsin 55095 3990 46
94080 94080 2021-02-28 Pierce Wisconsin 55093 4366 39
94079 94079 2021-02-28 Pepin Wisconsin 55091 826 7
94078 94078 2021-02-28 Ozaukee Wisconsin 55089 8524 83
94077 94077 2021-02-28 Outagamie Wisconsin 55087 21610 207
94076 94076 2021-02-28 Oneida Wisconsin 55085 3514 71
94075 94075 2021-02-28 Oconto Wisconsin 55083 4709 55
94074 94074 2021-02-28 Monroe Wisconsin 55081 4411 32
94073 94073 2021-02-28 Milwaukee Wisconsin 55079 107069 1274
94072 94072 2021-02-28 Menominee Wisconsin 55078 797 11
94071 94071 2021-02-28 Marquette Wisconsin 55077 1486 26
94070 94070 2021-02-28 Marinette Wisconsin 55075 4364 66
94069 94069 2021-02-28 Marathon Wisconsin 55073 15025 209
94068 94068 2021-02-28 Manitowoc Wisconsin 55071 8363 81
94067 94067 2021-02-28 Lincoln Wisconsin 55069 3102 75
94066 94066 2021-02-28 Langlade Wisconsin 55067 2090 44
94065 94065 2021-02-28 Lafayette Wisconsin 55065 1611 8
94064 94064 2021-02-28 La Crosse Wisconsin 55063 12885 78
94063 94063 2021-02-28 Kewaunee Wisconsin 55061 2580 28
94062 94062 2021-02-28 Kenosha Wisconsin 55059 16956 315
94061 94061 2021-02-28 Juneau Wisconsin 55057 3068 20
94060 94060 2021-02-28 Jefferson Wisconsin 55055 8819 125
94059 94059 2021-02-28 Jackson Wisconsin 55053 2615 23
94058 94058 2021-02-28 Iron Wisconsin 55051 658 39
94057 94057 2021-02-28 Iowa Wisconsin 55049 1940 10
94056 94056 2021-02-28 Green Lake Wisconsin 55047 1944 21
94055 94055 2021-02-28 Green Wisconsin 55045 3257 22
94054 94054 2021-02-28 Grant Wisconsin 55043 5338 85
94053 94053 2021-02-28 Forest Wisconsin 55041 994 26
94052 94052 2021-02-28 Fond du Lac Wisconsin 55039 13046 101
94051 94051 2021-02-28 Florence Wisconsin 55037 468 12
94050 94050 2021-02-28 Eau Claire Wisconsin 55035 11309 114
94049 94049 2021-02-28 Dunn Wisconsin 55033 4592 28
94048 94048 2021-02-28 Douglas Wisconsin 55031 4236 40
94047 94047 2021-02-28 Door Wisconsin 55029 2613 25
94046 94046 2021-02-28 Dodge Wisconsin 55027 12184 176
94045 94045 2021-02-28 Dane Wisconsin 55025 42100 296
94044 94044 2021-02-28 Crawford Wisconsin 55023 1718 17
94043 94043 2021-02-28 Columbia Wisconsin 55021 5410 60
94042 94042 2021-02-28 Clark Wisconsin 55019 3543 61
94041 94041 2021-02-28 Chippewa Wisconsin 55017 7224 94
94040 94040 2021-02-28 Calumet Wisconsin 55015 6014 46
94039 94039 2021-02-28 Burnett Wisconsin 55013 1342 23
94038 94038 2021-02-28 Buffalo Wisconsin 55011 1352 7
94037 94037 2021-02-28 Brown Wisconsin 55009 32637 250
94036 94036 2021-02-28 Bayfield Wisconsin 55007 1139 19
94035 94035 2021-02-28 Barron Wisconsin 55005 5509 76
94034 94034 2021-02-28 Ashland Wisconsin 55003 1241 16
94033 94033 2021-02-28 Adams Wisconsin 55001 1739 15
94032 94032 2021-02-28 Wyoming West Virginia 54109 1741 34
94031 94031 2021-02-28 Wood West Virginia 54107 7047 131
94030 94030 2021-02-28 Wirt West Virginia 54105 359 2
94029 94029 2021-02-28 Wetzel West Virginia 54103 1086 19
94028 94028 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-recent] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);