⚠️ 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

county

Link rowid date ▲ county state fips cases deaths
1199502 2021-04-07 Wetzel West Virginia 54103 1200 29
1199503 2021-04-07 Wirt West Virginia 54105 370 3
1199504 2021-04-07 Wood West Virginia 54107 7493 166
1199505 2021-04-07 Wyoming West Virginia 54109 1856 39
1199506 2021-04-07 Adams Wisconsin 55001 1822 15
1199507 2021-04-07 Ashland Wisconsin 55003 1291 16
1199508 2021-04-07 Barron Wisconsin 55005 5724 76
1199509 2021-04-07 Bayfield Wisconsin 55007 1206 19
1199510 2021-04-07 Brown Wisconsin 55009 34027 272
1199511 2021-04-07 Buffalo Wisconsin 55011 1363 7
1199512 2021-04-07 Burnett Wisconsin 55013 1389 22
1199513 2021-04-07 Calumet Wisconsin 55015 6270 50
1199514 2021-04-07 Chippewa Wisconsin 55017 7395 96
1199515 2021-04-07 Clark Wisconsin 55019 3571 62
1199516 2021-04-07 Columbia Wisconsin 55021 5611 68
1199517 2021-04-07 Crawford Wisconsin 55023 1737 17
1199518 2021-04-07 Dane Wisconsin 55025 44022 312
1199519 2021-04-07 Dodge Wisconsin 55027 12462 182
1199520 2021-04-07 Door Wisconsin 55029 2751 26
1199521 2021-04-07 Douglas Wisconsin 55031 4483 47
1199522 2021-04-07 Dunn Wisconsin 55033 4845 31
1199523 2021-04-07 Eau Claire Wisconsin 55035 11644 117
1199524 2021-04-07 Florence Wisconsin 55037 484 12
1199525 2021-04-07 Fond du Lac Wisconsin 55039 13327 114
1199526 2021-04-07 Forest Wisconsin 55041 1012 26
1199527 2021-04-07 Grant Wisconsin 55043 5506 89
1199528 2021-04-07 Green Wisconsin 55045 3504 23
1199529 2021-04-07 Green Lake Wisconsin 55047 1979 22
1199530 2021-04-07 Iowa Wisconsin 55049 2050 11
1199531 2021-04-07 Iron Wisconsin 55051 687 40
1199532 2021-04-07 Jackson Wisconsin 55053 2645 28
1199533 2021-04-07 Jefferson Wisconsin 55055 9252 128
1199534 2021-04-07 Juneau Wisconsin 55057 3155 25
1199535 2021-04-07 Kenosha Wisconsin 55059 17631 319
1199536 2021-04-07 Kewaunee Wisconsin 55061 2625 33
1199537 2021-04-07 La Crosse Wisconsin 55063 13257 80
1199538 2021-04-07 Lafayette Wisconsin 55065 1664 8
1199539 2021-04-07 Langlade Wisconsin 55067 2110 46
1199540 2021-04-07 Lincoln Wisconsin 55069 3175 87
1199541 2021-04-07 Manitowoc Wisconsin 55071 8559 86
1199542 2021-04-07 Marathon Wisconsin 55073 15460 218
1199543 2021-04-07 Marinette Wisconsin 55075 4437 68
1199544 2021-04-07 Marquette Wisconsin 55077 1525 27
1199545 2021-04-07 Menominee Wisconsin 55078 798 11
1199546 2021-04-07 Milwaukee Wisconsin 55079 111272 1310
1199547 2021-04-07 Monroe Wisconsin 55081 4498 37
1199548 2021-04-07 Oconto Wisconsin 55083 4828 57
1199549 2021-04-07 Oneida Wisconsin 55085 3674 74
1199550 2021-04-07 Outagamie Wisconsin 55087 22815 216
1199551 2021-04-07 Ozaukee Wisconsin 55089 8894 89
1199552 2021-04-07 Pepin Wisconsin 55091 846 7
1199553 2021-04-07 Pierce Wisconsin 55093 4614 41
1199554 2021-04-07 Polk Wisconsin 55095 4188 48
1199555 2021-04-07 Portage Wisconsin 55097 7133 70
1199556 2021-04-07 Price Wisconsin 55099 1288 7
1199557 2021-04-07 Racine Wisconsin 55101 23683 364
1199558 2021-04-07 Richland Wisconsin 55103 1349 15
1199559 2021-04-07 Rock Wisconsin 55105 16676 185
1199560 2021-04-07 Rusk Wisconsin 55107 1325 17
1199561 2021-04-07 Sauk Wisconsin 55111 5812 50
1199562 2021-04-07 Sawyer Wisconsin 55113 1619 24
1199563 2021-04-07 Shawano Wisconsin 55115 5198 81
1199564 2021-04-07 Sheboygan Wisconsin 55117 14215 143
1199565 2021-04-07 St. Croix Wisconsin 55109 8627 56
1199566 2021-04-07 Taylor Wisconsin 55119 2065 32
1199567 2021-04-07 Trempealeau Wisconsin 55121 3585 41
1199568 2021-04-07 Vernon Wisconsin 55123 1951 41
1199569 2021-04-07 Vilas Wisconsin 55125 2340 41
1199570 2021-04-07 Walworth Wisconsin 55127 11969 155
1199571 2021-04-07 Washburn Wisconsin 55129 1441 20
1199572 2021-04-07 Washington Wisconsin 55131 16149 152
1199573 2021-04-07 Waukesha Wisconsin 55133 47160 551
1199574 2021-04-07 Waupaca Wisconsin 55135 5880 161
1199575 2021-04-07 Waushara Wisconsin 55137 2442 35
1199576 2021-04-07 Winnebago Wisconsin 55139 20599 211
1199577 2021-04-07 Wood Wisconsin 55141 7261 90
1199578 2021-04-07 Albany Wyoming 56001 4021 11
1199579 2021-04-07 Big Horn Wyoming 56003 1114 32
1199580 2021-04-07 Campbell Wyoming 56005 4763 60
1199581 2021-04-07 Carbon Wyoming 56007 1520 23
1199582 2021-04-07 Converse Wyoming 56009 985 17
1199583 2021-04-07 Crook Wyoming 56011 424 12
1199584 2021-04-07 Fremont Wyoming 56013 5090 82
1199585 2021-04-07 Goshen Wyoming 56015 1173 23
1199586 2021-04-07 Hot Springs Wyoming 56017 363 3
1199587 2021-04-07 Johnson Wyoming 56019 714 10
1199588 2021-04-07 Laramie Wyoming 56021 8730 111
1199589 2021-04-07 Lincoln Wyoming 56023 1375 12
1199590 2021-04-07 Natrona Wyoming 56025 7832 135
1199591 2021-04-07 Niobrara Wyoming 56027 150 2
1199592 2021-04-07 Park Wyoming 56029 2646 30
1199593 2021-04-07 Platte Wyoming 56031 611 11
1199594 2021-04-07 Sheridan Wyoming 56033 3083 31
1199595 2021-04-07 Sublette Wyoming 56035 724 7
1199596 2021-04-07 Sweetwater Wyoming 56037 4067 37
1199597 2021-04-07 Teton Wyoming 56039 3645 9
1199598 2021-04-07 Uinta Wyoming 56041 2140 12
1199599 2021-04-07 Washakie Wyoming 56043 891 26
1199600 2021-04-07 Weston Wyoming 56045 639 5
1193106 2021-04-06 Autauga Alabama 1001 6644 102

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