⚠️ 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,306,763 rows sorted by date descending

View and edit SQL

These facets timed out: county

state

fips

Link rowid date ▲ county state fips cases deaths
1283941 2021-05-03 Wetzel West Virginia 54103 1287 29
1283942 2021-05-03 Wirt West Virginia 54105 406 3
1283943 2021-05-03 Wood West Virginia 54107 7693 165
1283944 2021-05-03 Wyoming West Virginia 54109 1966 39
1283945 2021-05-03 Adams Wisconsin 55001 1897 17
1283946 2021-05-03 Ashland Wisconsin 55003 1333 15
1283947 2021-05-03 Barron Wisconsin 55005 5891 83
1283948 2021-05-03 Bayfield Wisconsin 55007 1252 19
1283949 2021-05-03 Brown Wisconsin 55009 34892 283
1283950 2021-05-03 Buffalo Wisconsin 55011 1385 7
1283951 2021-05-03 Burnett Wisconsin 55013 1499 22
1283952 2021-05-03 Calumet Wisconsin 55015 6408 52
1283953 2021-05-03 Chippewa Wisconsin 55017 7517 96
1283954 2021-05-03 Clark Wisconsin 55019 3639 62
1283955 2021-05-03 Columbia Wisconsin 55021 5762 69
1283956 2021-05-03 Crawford Wisconsin 55023 1766 17
1283957 2021-05-03 Dane Wisconsin 55025 45817 325
1283958 2021-05-03 Dodge Wisconsin 55027 12727 184
1283959 2021-05-03 Door Wisconsin 55029 2808 28
1283960 2021-05-03 Douglas Wisconsin 55031 4767 51
1283961 2021-05-03 Dunn Wisconsin 55033 5022 32
1283962 2021-05-03 Eau Claire Wisconsin 55035 11826 119
1283963 2021-05-03 Florence Wisconsin 55037 499 12
1283964 2021-05-03 Fond du Lac Wisconsin 55039 13561 121
1283965 2021-05-03 Forest Wisconsin 55041 1035 26
1283966 2021-05-03 Grant Wisconsin 55043 5660 90
1283967 2021-05-03 Green Wisconsin 55045 3608 24
1283968 2021-05-03 Green Lake Wisconsin 55047 2008 22
1283969 2021-05-03 Iowa Wisconsin 55049 2101 11
1283970 2021-05-03 Iron Wisconsin 55051 692 40
1283971 2021-05-03 Jackson Wisconsin 55053 2682 28
1283972 2021-05-03 Jefferson Wisconsin 55055 9499 132
1283973 2021-05-03 Juneau Wisconsin 55057 3251 27
1283974 2021-05-03 Kenosha Wisconsin 55059 18212 322
1283975 2021-05-03 Kewaunee Wisconsin 55061 2675 35
1283976 2021-05-03 La Crosse Wisconsin 55063 13496 82
1283977 2021-05-03 Lafayette Wisconsin 55065 1704 9
1283978 2021-05-03 Langlade Wisconsin 55067 2157 46
1283979 2021-05-03 Lincoln Wisconsin 55069 3261 91
1283980 2021-05-03 Manitowoc Wisconsin 55071 8735 88
1283981 2021-05-03 Marathon Wisconsin 55073 16079 220
1283982 2021-05-03 Marinette Wisconsin 55075 4560 69
1283983 2021-05-03 Marquette Wisconsin 55077 1556 27
1283984 2021-05-03 Menominee Wisconsin 55078 807 11
1283985 2021-05-03 Milwaukee Wisconsin 55079 115175 1345
1283986 2021-05-03 Monroe Wisconsin 55081 4623 38
1283987 2021-05-03 Oconto Wisconsin 55083 4950 61
1283988 2021-05-03 Oneida Wisconsin 55085 3781 75
1283989 2021-05-03 Outagamie Wisconsin 55087 23479 218
1283990 2021-05-03 Ozaukee Wisconsin 55089 9124 91
1283991 2021-05-03 Pepin Wisconsin 55091 876 7
1283992 2021-05-03 Pierce Wisconsin 55093 4895 42
1283993 2021-05-03 Polk Wisconsin 55095 4506 53
1283994 2021-05-03 Portage Wisconsin 55097 7276 72
1283995 2021-05-03 Price Wisconsin 55099 1332 7
1283996 2021-05-03 Racine Wisconsin 55101 24568 369
1283997 2021-05-03 Richland Wisconsin 55103 1374 15
1283998 2021-05-03 Rock Wisconsin 55105 17712 190
1283999 2021-05-03 Rusk Wisconsin 55107 1348 18
1284000 2021-05-03 Sauk Wisconsin 55111 6058 53
1284001 2021-05-03 Sawyer Wisconsin 55113 1716 26
1284002 2021-05-03 Shawano Wisconsin 55115 5252 83
1284003 2021-05-03 Sheboygan Wisconsin 55117 14589 150
1284004 2021-05-03 St. Croix Wisconsin 55109 9398 57
1284005 2021-05-03 Taylor Wisconsin 55119 2099 32
1284006 2021-05-03 Trempealeau Wisconsin 55121 3636 44
1284007 2021-05-03 Vernon Wisconsin 55123 1982 42
1284008 2021-05-03 Vilas Wisconsin 55125 2383 41
1284009 2021-05-03 Walworth Wisconsin 55127 12399 159
1284010 2021-05-03 Washburn Wisconsin 55129 1527 20
1284011 2021-05-03 Washington Wisconsin 55131 16616 162
1284012 2021-05-03 Waukesha Wisconsin 55133 48463 574
1284013 2021-05-03 Waupaca Wisconsin 55135 5994 162
1284014 2021-05-03 Waushara Wisconsin 55137 2484 37
1284015 2021-05-03 Winnebago Wisconsin 55139 21124 216
1284016 2021-05-03 Wood Wisconsin 55141 7496 94
1284017 2021-05-03 Albany Wyoming 56001 4266 11
1284018 2021-05-03 Big Horn Wyoming 56003 1149 32
1284019 2021-05-03 Campbell Wyoming 56005 4842 60
1284020 2021-05-03 Carbon Wyoming 56007 1576 23
1284021 2021-05-03 Converse Wyoming 56009 996 17
1284022 2021-05-03 Crook Wyoming 56011 429 12
1284023 2021-05-03 Fremont Wyoming 56013 5175 84
1284024 2021-05-03 Goshen Wyoming 56015 1207 24
1284025 2021-05-03 Hot Springs Wyoming 56017 369 3
1284026 2021-05-03 Johnson Wyoming 56019 717 10
1284027 2021-05-03 Laramie Wyoming 56021 9072 113
1284028 2021-05-03 Lincoln Wyoming 56023 1398 12
1284029 2021-05-03 Natrona Wyoming 56025 7959 136
1284030 2021-05-03 Niobrara Wyoming 56027 157 2
1284031 2021-05-03 Park Wyoming 56029 2709 30
1284032 2021-05-03 Platte Wyoming 56031 623 11
1284033 2021-05-03 Sheridan Wyoming 56033 3127 31
1284034 2021-05-03 Sublette Wyoming 56035 779 7
1284035 2021-05-03 Sweetwater Wyoming 56037 4250 37
1284036 2021-05-03 Teton Wyoming 56039 3739 9
1284037 2021-05-03 Uinta Wyoming 56041 2195 12
1284038 2021-05-03 Washakie Wyoming 56043 905 26
1284039 2021-05-03 Weston Wyoming 56045 651 5
1277545 2021-05-02 Autauga Alabama 1001 6909 107

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