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

View and edit SQL

state

fips

date (date)

county

Link rowid date ▲ county state fips cases deaths
1225577 2021-04-15 Weston Wyoming 56045 646 5
1225576 2021-04-15 Washakie Wyoming 56043 897 26
1225575 2021-04-15 Uinta Wyoming 56041 2155 12
1225574 2021-04-15 Teton Wyoming 56039 3689 9
1225573 2021-04-15 Sweetwater Wyoming 56037 4119 37
1225572 2021-04-15 Sublette Wyoming 56035 750 7
1225571 2021-04-15 Sheridan Wyoming 56033 3098 31
1225570 2021-04-15 Platte Wyoming 56031 617 11
1225569 2021-04-15 Park Wyoming 56029 2660 30
1225568 2021-04-15 Niobrara Wyoming 56027 150 2
1225567 2021-04-15 Natrona Wyoming 56025 7876 135
1225566 2021-04-15 Lincoln Wyoming 56023 1385 12
1225565 2021-04-15 Laramie Wyoming 56021 8820 113
1225564 2021-04-15 Johnson Wyoming 56019 716 10
1225563 2021-04-15 Hot Springs Wyoming 56017 364 3
1225562 2021-04-15 Goshen Wyoming 56015 1178 23
1225561 2021-04-15 Fremont Wyoming 56013 5117 82
1225560 2021-04-15 Crook Wyoming 56011 428 12
1225559 2021-04-15 Converse Wyoming 56009 990 17
1225558 2021-04-15 Carbon Wyoming 56007 1537 23
1225557 2021-04-15 Campbell Wyoming 56005 4788 60
1225556 2021-04-15 Big Horn Wyoming 56003 1118 32
1225555 2021-04-15 Albany Wyoming 56001 4105 11
1225554 2021-04-15 Wood Wisconsin 55141 7333 90
1225553 2021-04-15 Winnebago Wisconsin 55139 20812 211
1225552 2021-04-15 Waushara Wisconsin 55137 2452 35
1225551 2021-04-15 Waupaca Wisconsin 55135 5930 161
1225550 2021-04-15 Waukesha Wisconsin 55133 47717 558
1225549 2021-04-15 Washington Wisconsin 55131 16312 154
1225548 2021-04-15 Washburn Wisconsin 55129 1476 20
1225547 2021-04-15 Walworth Wisconsin 55127 12151 155
1225546 2021-04-15 Vilas Wisconsin 55125 2362 41
1225545 2021-04-15 Vernon Wisconsin 55123 1964 42
1225544 2021-04-15 Trempealeau Wisconsin 55121 3594 42
1225543 2021-04-15 Taylor Wisconsin 55119 2076 32
1225542 2021-04-15 St. Croix Wisconsin 55109 8898 57
1225541 2021-04-15 Sheboygan Wisconsin 55117 14393 143
1225540 2021-04-15 Shawano Wisconsin 55115 5230 81
1225539 2021-04-15 Sawyer Wisconsin 55113 1634 25
1225538 2021-04-15 Sauk Wisconsin 55111 5910 52
1225537 2021-04-15 Rusk Wisconsin 55107 1327 17
1225536 2021-04-15 Rock Wisconsin 55105 16981 187
1225535 2021-04-15 Richland Wisconsin 55103 1359 15
1225534 2021-04-15 Racine Wisconsin 55101 23973 364
1225533 2021-04-15 Price Wisconsin 55099 1307 7
1225532 2021-04-15 Portage Wisconsin 55097 7179 70
1225531 2021-04-15 Polk Wisconsin 55095 4311 49
1225530 2021-04-15 Pierce Wisconsin 55093 4676 42
1225529 2021-04-15 Pepin Wisconsin 55091 850 7
1225528 2021-04-15 Ozaukee Wisconsin 55089 8998 90
1225527 2021-04-15 Outagamie Wisconsin 55087 23110 217
1225526 2021-04-15 Oneida Wisconsin 55085 3707 74
1225525 2021-04-15 Oconto Wisconsin 55083 4872 57
1225524 2021-04-15 Monroe Wisconsin 55081 4532 38
1225523 2021-04-15 Milwaukee Wisconsin 55079 112634 1318
1225522 2021-04-15 Menominee Wisconsin 55078 800 11
1225521 2021-04-15 Marquette Wisconsin 55077 1541 27
1225520 2021-04-15 Marinette Wisconsin 55075 4472 68
1225519 2021-04-15 Marathon Wisconsin 55073 15702 218
1225518 2021-04-15 Manitowoc Wisconsin 55071 8614 87
1225517 2021-04-15 Lincoln Wisconsin 55069 3229 88
1225516 2021-04-15 Langlade Wisconsin 55067 2120 46
1225515 2021-04-15 Lafayette Wisconsin 55065 1688 8
1225514 2021-04-15 La Crosse Wisconsin 55063 13310 80
1225513 2021-04-15 Kewaunee Wisconsin 55061 2643 34
1225512 2021-04-15 Kenosha Wisconsin 55059 17815 320
1225511 2021-04-15 Juneau Wisconsin 55057 3169 26
1225510 2021-04-15 Jefferson Wisconsin 55055 9348 131
1225509 2021-04-15 Jackson Wisconsin 55053 2659 28
1225508 2021-04-15 Iron Wisconsin 55051 688 40
1225507 2021-04-15 Iowa Wisconsin 55049 2068 11
1225506 2021-04-15 Green Lake Wisconsin 55047 1993 22
1225505 2021-04-15 Green Wisconsin 55045 3540 23
1225504 2021-04-15 Grant Wisconsin 55043 5569 90
1225503 2021-04-15 Forest Wisconsin 55041 1021 26
1225502 2021-04-15 Fond du Lac Wisconsin 55039 13408 114
1225501 2021-04-15 Florence Wisconsin 55037 492 12
1225500 2021-04-15 Eau Claire Wisconsin 55035 11700 117
1225499 2021-04-15 Dunn Wisconsin 55033 4909 32
1225498 2021-04-15 Douglas Wisconsin 55031 4613 49
1225497 2021-04-15 Door Wisconsin 55029 2779 28
1225496 2021-04-15 Dodge Wisconsin 55027 12546 183
1225495 2021-04-15 Dane Wisconsin 55025 44770 313
1225494 2021-04-15 Crawford Wisconsin 55023 1753 17
1225493 2021-04-15 Columbia Wisconsin 55021 5664 69
1225492 2021-04-15 Clark Wisconsin 55019 3590 62
1225491 2021-04-15 Chippewa Wisconsin 55017 7450 96
1225490 2021-04-15 Calumet Wisconsin 55015 6335 50
1225489 2021-04-15 Burnett Wisconsin 55013 1424 22
1225488 2021-04-15 Buffalo Wisconsin 55011 1367 7
1225487 2021-04-15 Brown Wisconsin 55009 34374 274
1225486 2021-04-15 Bayfield Wisconsin 55007 1233 19
1225485 2021-04-15 Barron Wisconsin 55005 5778 76
1225484 2021-04-15 Ashland Wisconsin 55003 1303 16
1225483 2021-04-15 Adams Wisconsin 55001 1851 15
1225482 2021-04-15 Wyoming West Virginia 54109 1896 40
1225481 2021-04-15 Wood West Virginia 54107 7554 167
1225480 2021-04-15 Wirt West Virginia 54105 376 3
1225479 2021-04-15 Wetzel West Virginia 54103 1180 29
1225478 2021-04-15 Webster West Virginia 54101 454 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]);