covid_casesdeaths_reshaped_bln

Table actions
Data provided via a collaboration between USAFacts and Big Local News. This is an ongoing effort to collect and distribute county-level data on confirmed coronavirus cases and deaths. Please cite USAFacts as the data provider. The three CSV files are the current version and will be updated daily around 8 a.m. The zipped archives are prior versions with a date stamp of when they were uploaded by Big Local News. See README for additional details

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

1,191,735 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ countyFIPS County Name State stateFIPS date cases deaths
1191735 1191735 56045 Weston County WY 56 1/28/21 610 4
1191734 1191734 56043 Washakie County WY 56 1/28/21 864 25
1191733 1191733 56041 Uinta County WY 56 1/28/21 1957 12
1191732 1191732 56039 Teton County WY 56 1/28/21 3028 6
1191731 1191731 56037 Sweetwater County WY 56 1/28/21 3440 32
1191730 1191730 56035 Sublette County WY 56 1/28/21 648 7
1191729 1191729 56033 Sheridan County WY 56 1/28/21 2861 19
1191728 1191728 56031 Platte County WY 56 1/28/21 549 11
1191727 1191727 56029 Park County WY 56 1/28/21 2525 20
1191726 1191726 56027 Niobrara County WY 56 1/28/21 145 2
1191725 1191725 56025 Natrona County WY 56 1/28/21 7439 117
1191724 1191724 56023 Lincoln County WY 56 1/28/21 1123 11
1191723 1191723 56021 Laramie County WY 56 1/28/21 7959 87
1191722 1191722 56019 Johnson County WY 56 1/28/21 612 9
1191721 1191721 56017 Hot Springs County WY 56 1/28/21 354 3
1191720 1191720 56015 Goshen County WY 56 1/28/21 1111 20
1191719 1191719 56013 Fremont County WY 56 1/28/21 4409 77
1191718 1191718 56011 Crook County WY 56 1/28/21 413 10
1191717 1191717 56009 Converse County WY 56 1/28/21 900 14
1191716 1191716 56007 Carbon County WY 56 1/28/21 1175 18
1191715 1191715 56005 Campbell County WY 56 1/28/21 4592 53
1191714 1191714 56003 Big Horn County WY 56 1/28/21 958 28
1191713 1191713 56001 Albany County WY 56 1/28/21 3758 11
1191712 1191712 0 Statewide Unallocated WY 56 1/28/21 0 0
1191711 1191711 55141 Wood County WI 55 1/28/21 6756 66
1191710 1191710 55139 Winnebago County WI 55 1/28/21 18929 167
1191709 1191709 55137 Waushara County WI 55 1/28/21 2294 25
1191708 1191708 55135 Waupaca County WI 55 1/28/21 5428 105
1191707 1191707 55133 Waukesha County WI 55 1/28/21 42626 438
1191706 1191706 55131 Washington County WI 55 1/28/21 14870 121
1191705 1191705 55129 Washburn County WI 55 1/28/21 1288 17
1191704 1191704 55127 Walworth County WI 55 1/28/21 10767 118
1191703 1191703 55125 Vilas County WI 55 1/28/21 2019 32
1191702 1191702 55123 Vernon County WI 55 1/28/21 1786 34
1191701 1191701 55121 Trempealeau County WI 55 1/28/21 3354 34
1191700 1191700 55119 Taylor County WI 55 1/28/21 1956 20
1191699 1191699 55117 Sheboygan County WI 55 1/28/21 13067 113
1191698 1191698 55115 Shawano County WI 55 1/28/21 4959 68
1191697 1191697 55113 Sawyer County WI 55 1/28/21 1434 17
1191696 1191696 55111 Sauk County WI 55 1/28/21 5274 35
1191695 1191695 55109 St. Croix County WI 55 1/28/21 7558 40
1191694 1191694 55107 Rusk County WI 55 1/28/21 1265 14
1191693 1191693 55105 Rock County WI 55 1/28/21 15083 138
1191692 1191692 55103 Richland County WI 55 1/28/21 1247 13
1191691 1191691 55101 Racine County WI 55 1/28/21 22181 296
1191690 1191690 55099 Price County WI 55 1/28/21 1180 7
1191689 1191689 55097 Portage County WI 55 1/28/21 6555 59
1191688 1191688 55095 Polk County WI 55 1/28/21 3589 42
1191687 1191687 55093 Pierce County WI 55 1/28/21 4094 33
1191686 1191686 55091 Pepin County WI 55 1/28/21 794 7
1191685 1191685 55089 Ozaukee County WI 55 1/28/21 8148 72
1191684 1191684 55087 Outagamie County WI 55 1/28/21 20303 177
1191683 1191683 55085 Oneida County WI 55 1/28/21 3272 57
1191682 1191682 55083 Oconto County WI 55 1/28/21 4542 45
1191681 1191681 55081 Monroe County WI 55 1/28/21 4131 30
1191680 1191680 55079 Milwaukee County WI 55 1/28/21 102528 1127
1191679 1191679 55078 Menominee County WI 55 1/28/21 784 11
1191678 1191678 55077 Marquette County WI 55 1/28/21 1426 21
1191677 1191677 55075 Marinette County WI 55 1/28/21 4256 58
1191676 1191676 55073 Marathon County WI 55 1/28/21 14532 169
1191675 1191675 55071 Manitowoc County WI 55 1/28/21 7910 60
1191674 1191674 55069 Lincoln County WI 55 1/28/21 2967 55
1191673 1191673 55067 Langlade County WI 55 1/28/21 2035 31
1191672 1191672 55065 Lafayette County WI 55 1/28/21 1509 7
1191671 1191671 55063 La Crosse County WI 55 1/28/21 12114 71
1191670 1191670 55061 Kewaunee County WI 55 1/28/21 2488 26
1191669 1191669 55059 Kenosha County WI 55 1/28/21 16031 268
1191668 1191668 55057 Juneau County WI 55 1/28/21 2941 17
1191667 1191667 55055 Jefferson County WI 55 1/28/21 8346 70
1191666 1191666 55053 Jackson County WI 55 1/28/21 2583 21
1191665 1191665 55051 Iron County WI 55 1/28/21 582 19
1191664 1191664 55049 Iowa County WI 55 1/28/21 1874 9
1191663 1191663 55047 Green Lake County WI 55 1/28/21 1889 15
1191662 1191662 55045 Green County WI 55 1/28/21 2773 12
1191661 1191661 55043 Grant County WI 55 1/28/21 5084 79
1191660 1191660 55041 Forest County WI 55 1/28/21 971 22
1191659 1191659 55039 Fond du Lac County WI 55 1/28/21 12425 82
1191658 1191658 55037 Florence County WI 55 1/28/21 454 12
1191657 1191657 55035 Eau Claire County WI 55 1/28/21 10770 97
1191656 1191656 55033 Dunn County WI 55 1/28/21 4325 26
1191655 1191655 55031 Douglas County WI 55 1/28/21 4079 18
1191654 1191654 55029 Door County WI 55 1/28/21 2529 18
1191653 1191653 55027 Dodge County WI 55 1/28/21 11828 143
1191652 1191652 55025 Dane County WI 55 1/28/21 39091 244
1191651 1191651 55023 Crawford County WI 55 1/28/21 1683 15
1191650 1191650 55021 Columbia County WI 55 1/28/21 5173 39
1191649 1191649 55019 Clark County WI 55 1/28/21 3446 56
1191648 1191648 55017 Chippewa County WI 55 1/28/21 6918 77
1191647 1191647 55015 Calumet County WI 55 1/28/21 5660 39
1191646 1191646 55013 Burnett County WI 55 1/28/21 1215 23
1191645 1191645 55011 Buffalo County WI 55 1/28/21 1284 7
1191644 1191644 55009 Brown County WI 55 1/28/21 31187 193
1191643 1191643 55007 Bayfield County WI 55 1/28/21 1086 18
1191642 1191642 55005 Barron County WI 55 1/28/21 5212 69
1191641 1191641 55003 Ashland County WI 55 1/28/21 1197 16
1191640 1191640 55001 Adams County WI 55 1/28/21 1646 11
1191639 1191639 0 Statewide Unallocated WI 55 1/28/21 0 0
1191638 1191638 54109 Wyoming County WV 54 1/28/21 1470 28
1191637 1191637 54107 Wood County WV 54 1/28/21 6377 103
1191636 1191636 54105 Wirt County WV 54 1/28/21 320 1

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [covid_casesdeaths_reshaped_bln] (
   [countyFIPS] INTEGER,
   [County Name] TEXT,
   [State] TEXT,
   [stateFIPS] INTEGER,
   [date] TEXT,
   [cases] INTEGER,
   [deaths] INTEGER
);