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
1191635 1191635 54103 Wetzel County WV 54 1/28/21 973 18
1191634 1191634 54101 Webster County WV 54 1/28/21 241 0
1191633 1191633 54099 Wayne County WV 54 1/28/21 2283 26
1191632 1191632 54097 Upshur County WV 54 1/28/21 1435 23
1191631 1191631 54095 Tyler County WV 54 1/28/21 550 3
1191630 1191630 54093 Tucker County WV 54 1/28/21 442 7
1191629 1191629 54091 Taylor County WV 54 1/28/21 975 16
1191628 1191628 54089 Summers County WV 54 1/28/21 652 21
1191627 1191627 54087 Roane County WV 54 1/28/21 446 6
1191626 1191626 54085 Ritchie County WV 54 1/28/21 539 8
1191625 1191625 54083 Randolph County WV 54 1/28/21 2132 8
1191624 1191624 54081 Raleigh County WV 54 1/28/21 3994 43
1191623 1191623 54079 Putnam County WV 54 1/28/21 3735 68
1191622 1191622 54077 Preston County WV 54 1/28/21 2378 38
1191621 1191621 54075 Pocahontas County WV 54 1/28/21 548 9
1191620 1191620 54073 Pleasants County WV 54 1/28/21 761 13
1191619 1191619 54071 Pendleton County WV 54 1/28/21 533 4
1191618 1191618 54069 Ohio County WV 54 1/28/21 3293 63
1191617 1191617 54067 Nicholas County WV 54 1/28/21 1016 11
1191616 1191616 54065 Morgan County WV 54 1/28/21 854 11
1191615 1191615 54063 Monroe County WV 54 1/28/21 862 11
1191614 1191614 54061 Monongalia County WV 54 1/28/21 6871 58
1191613 1191613 54059 Mingo County WV 54 1/28/21 1875 21
1191612 1191612 54057 Mineral County WV 54 1/28/21 2441 75
1191611 1191611 54055 Mercer County WV 54 1/28/21 3831 88
1191610 1191610 54047 McDowell County WV 54 1/28/21 1198 12
1191609 1191609 54053 Mason County WV 54 1/28/21 1499 31
1191608 1191608 54051 Marshall County WV 54 1/28/21 2694 63
1191607 1191607 54049 Marion County WV 54 1/28/21 3199 24
1191606 1191606 54045 Logan County WV 54 1/28/21 2297 68
1191605 1191605 54043 Lincoln County WV 54 1/28/21 1112 10
1191604 1191604 54041 Lewis County WV 54 1/28/21 802 12
1191603 1191603 54039 Kanawha County WV 54 1/28/21 10791 258
1191602 1191602 54037 Jefferson County WV 54 1/28/21 3223 32
1191601 1191601 54035 Jackson County WV 54 1/28/21 1560 45
1191600 1191600 54033 Harrison County WV 54 1/28/21 4320 54
1191599 1191599 54031 Hardy County WV 54 1/28/21 1173 16
1191598 1191598 54029 Hancock County WV 54 1/28/21 2417 82
1191597 1191597 54027 Hampshire County WV 54 1/28/21 1332 28
1191596 1191596 54025 Greenbrier County WV 54 1/28/21 2178 49
1191595 1191595 54023 Grant County WV 54 1/28/21 959 19
1191594 1191594 54021 Gilmer County WV 54 1/28/21 559 6
1191593 1191593 54019 Fayette County WV 54 1/28/21 2321 65
1191592 1191592 54017 Doddridge County WV 54 1/28/21 395 5
1191591 1191591 54015 Clay County WV 54 1/28/21 334 4
1191590 1191590 54013 Calhoun County WV 54 1/28/21 204 0
1191589 1191589 54011 Cabell County WV 54 1/28/21 6849 143
1191588 1191588 54009 Brooke County WV 54 1/28/21 1861 48
1191587 1191587 54007 Braxton County WV 54 1/28/21 730 1
1191586 1191586 54005 Boone County WV 54 1/28/21 1391 28
1191585 1191585 54003 Berkeley County WV 54 1/28/21 8630 82
1191584 1191584 54001 Barbour County WV 54 1/28/21 1080 17
1191583 1191583 0 Statewide Unallocated WV 54 1/28/21 0 0
1191582 1191582 53077 Yakima County WA 53 1/28/21 24151 366
1191581 1191581 53075 Whitman County WA 53 1/28/21 3134 36
1191580 1191580 53073 Whatcom County WA 53 1/28/21 5419 64
1191579 1191579 53071 Walla Walla County WA 53 1/28/21 4321 49
1191578 1191578 53069 Wahkiakum County WA 53 1/28/21 66 0
1191577 1191577 53067 Thurston County WA 53 1/28/21 6283 67
1191576 1191576 53065 Stevens County WA 53 1/28/21 1442 21
1191575 1191575 53063 Spokane County WA 53 1/28/21 32947 458
1191574 1191574 53061 Snohomish County WA 53 1/28/21 27508 484
1191573 1191573 53059 Skamania County WA 53 1/28/21 240 1
1191572 1191572 53057 Skagit County WA 53 1/28/21 4042 50
1191571 1191571 53055 San Juan County WA 53 1/28/21 96 0
1191570 1191570 53053 Pierce County WA 53 1/28/21 33488 459
1191569 1191569 53051 Pend Oreille County WA 53 1/28/21 554 4
1191568 1191568 53049 Pacific County WA 53 1/28/21 648 8
1191567 1191567 53047 Okanogan County WA 53 1/28/21 2015 34
1191566 1191566 53045 Mason County WA 53 1/28/21 2084 18
1191565 1191565 53043 Lincoln County WA 53 1/28/21 304 4
1191564 1191564 53041 Lewis County WA 53 1/28/21 3265 37
1191563 1191563 53039 Klickitat County WA 53 1/28/21 602 5
1191562 1191562 53037 Kittitas County WA 53 1/28/21 2053 30
1191561 1191561 53035 Kitsap County WA 53 1/28/21 5077 66
1191560 1191560 53033 King County WA 53 1/28/21 77067 1233
1191559 1191559 53031 Jefferson County WA 53 1/28/21 290 2
1191558 1191558 53029 Island County WA 53 1/28/21 1170 22
1191557 1191557 53027 Grays Harbor County WA 53 1/28/21 2924 32
1191556 1191556 53025 Grant County WA 53 1/28/21 7070 57
1191555 1191555 53023 Garfield County WA 53 1/28/21 103 4
1191554 1191554 53021 Franklin County WA 53 1/28/21 10095 90
1191553 1191553 53019 Ferry County WA 53 1/28/21 197 4
1191552 1191552 53017 Douglas County WA 53 1/28/21 3003 18
1191551 1191551 53015 Cowlitz County WA 53 1/28/21 3611 42
1191550 1191550 53013 Columbia County WA 53 1/28/21 94 4
1191549 1191549 53011 Clark County WA 53 1/28/21 17249 183
1191548 1191548 53009 Clallam County WA 53 1/28/21 890 5
1191547 1191547 53007 Chelan County WA 53 1/28/21 5684 49
1191546 1191546 53005 Benton County WA 53 1/28/21 14187 188
1191545 1191545 53003 Asotin County WA 53 1/28/21 1226 26
1191544 1191544 53001 Adams County WA 53 1/28/21 1779 19
1191543 1191543 0 Statewide Unallocated WA 53 1/28/21 1431 4
1191542 1191542 51840 Winchester city VA 51 1/28/21 2239 20
1191541 1191541 51830 Williamsburg City VA 51 1/28/21 429 9
1191540 1191540 51820 Waynesboro city VA 51 1/28/21 1807 23
1191539 1191539 51810 Virginia Beach city VA 51 1/28/21 25529 201
1191538 1191538 51800 Suffolk city VA 51 1/28/21 5620 109
1191537 1191537 51790 Staunton city VA 51 1/28/21 2186 51
1191536 1191536 51775 Salem city VA 51 1/28/21 1685 33

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