us-counties
Data source: Big Local News · About: big-local-datasette
570,096 rows sorted by rowid descending
This data as json, copyable, CSV (advanced)
Link | rowid ▲ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
569996 | 569996 | 2020-09-25 | Webster | West Virginia | 54101 | 7 | 0 |
569995 | 569995 | 2020-09-25 | Wayne | West Virginia | 54099 | 389 | 10 |
569994 | 569994 | 2020-09-25 | Upshur | West Virginia | 54097 | 64 | 0 |
569993 | 569993 | 2020-09-25 | Tyler | West Virginia | 54095 | 16 | 0 |
569992 | 569992 | 2020-09-25 | Tucker | West Virginia | 54093 | 20 | 0 |
569991 | 569991 | 2020-09-25 | Taylor | West Virginia | 54091 | 120 | 6 |
569990 | 569990 | 2020-09-25 | Summers | West Virginia | 54089 | 49 | 0 |
569989 | 569989 | 2020-09-25 | Roane | West Virginia | 54087 | 49 | 2 |
569988 | 569988 | 2020-09-25 | Ritchie | West Virginia | 54085 | 12 | 0 |
569987 | 569987 | 2020-09-25 | Randolph | West Virginia | 54083 | 240 | 1 |
569986 | 569986 | 2020-09-25 | Raleigh | West Virginia | 54081 | 501 | 8 |
569985 | 569985 | 2020-09-25 | Putnam | West Virginia | 54079 | 538 | 5 |
569984 | 569984 | 2020-09-25 | Preston | West Virginia | 54077 | 152 | 4 |
569983 | 569983 | 2020-09-25 | Pocahontas | West Virginia | 54075 | 59 | 0 |
569982 | 569982 | 2020-09-25 | Pleasants | West Virginia | 54073 | 17 | 3 |
569981 | 569981 | 2020-09-25 | Pendleton | West Virginia | 54071 | 52 | 1 |
569980 | 569980 | 2020-09-25 | Ohio | West Virginia | 54069 | 367 | 6 |
569979 | 569979 | 2020-09-25 | Nicholas | West Virginia | 54067 | 99 | 3 |
569978 | 569978 | 2020-09-25 | Morgan | West Virginia | 54065 | 53 | 0 |
569977 | 569977 | 2020-09-25 | Monroe | West Virginia | 54063 | 147 | 7 |
569976 | 569976 | 2020-09-25 | Monongalia | West Virginia | 54061 | 1980 | 5 |
569975 | 569975 | 2020-09-25 | Mingo | West Virginia | 54059 | 372 | 9 |
569974 | 569974 | 2020-09-25 | Mineral | West Virginia | 54057 | 172 | 4 |
569973 | 569973 | 2020-09-25 | Mercer | West Virginia | 54055 | 409 | 28 |
569972 | 569972 | 2020-09-25 | McDowell | West Virginia | 54047 | 81 | 0 |
569971 | 569971 | 2020-09-25 | Mason | West Virginia | 54053 | 141 | 6 |
569970 | 569970 | 2020-09-25 | Marshall | West Virginia | 54051 | 170 | 1 |
569969 | 569969 | 2020-09-25 | Marion | West Virginia | 54049 | 265 | 3 |
569968 | 569968 | 2020-09-25 | Logan | West Virginia | 54045 | 606 | 39 |
569967 | 569967 | 2020-09-25 | Lincoln | West Virginia | 54043 | 164 | 2 |
569966 | 569966 | 2020-09-25 | Lewis | West Virginia | 54041 | 38 | 2 |
569965 | 569965 | 2020-09-25 | Kanawha | West Virginia | 54039 | 2554 | 76 |
569964 | 569964 | 2020-09-25 | Jefferson | West Virginia | 54037 | 427 | 4 |
569963 | 569963 | 2020-09-25 | Jackson | West Virginia | 54035 | 259 | 23 |
569962 | 569962 | 2020-09-25 | Harrison | West Virginia | 54033 | 349 | 9 |
569961 | 569961 | 2020-09-25 | Hardy | West Virginia | 54031 | 88 | 1 |
569960 | 569960 | 2020-09-25 | Hancock | West Virginia | 54029 | 148 | 0 |
569959 | 569959 | 2020-09-25 | Hampshire | West Virginia | 54027 | 104 | 1 |
569958 | 569958 | 2020-09-25 | Greenbrier | West Virginia | 54025 | 125 | 3 |
569957 | 569957 | 2020-09-25 | Grant | West Virginia | 54023 | 158 | 7 |
569956 | 569956 | 2020-09-25 | Gilmer | West Virginia | 54021 | 43 | 0 |
569955 | 569955 | 2020-09-25 | Fayette | West Virginia | 54019 | 599 | 13 |
569954 | 569954 | 2020-09-25 | Doddridge | West Virginia | 54017 | 22 | 1 |
569953 | 569953 | 2020-09-25 | Clay | West Virginia | 54015 | 34 | 2 |
569952 | 569952 | 2020-09-25 | Calhoun | West Virginia | 54013 | 25 | 0 |
569951 | 569951 | 2020-09-25 | Cabell | West Virginia | 54011 | 767 | 10 |
569950 | 569950 | 2020-09-25 | Brooke | West Virginia | 54009 | 111 | 1 |
569949 | 569949 | 2020-09-25 | Braxton | West Virginia | 54007 | 13 | 0 |
569948 | 569948 | 2020-09-25 | Boone | West Virginia | 54005 | 218 | 1 |
569947 | 569947 | 2020-09-25 | Berkeley | West Virginia | 54003 | 976 | 13 |
569946 | 569946 | 2020-09-25 | Barbour | West Virginia | 54001 | 53 | 1 |
569945 | 569945 | 2020-09-25 | Yakima | Washington | 53077 | 12216 | 271 |
569944 | 569944 | 2020-09-25 | Whitman | Washington | 53075 | 1240 | 0 |
569943 | 569943 | 2020-09-25 | Whatcom | Washington | 53073 | 1328 | 52 |
569942 | 569942 | 2020-09-25 | Walla Walla | Washington | 53071 | 897 | 7 |
569941 | 569941 | 2020-09-25 | Wahkiakum | Washington | 53069 | 6 | 0 |
569940 | 569940 | 2020-09-25 | Unknown | Washington | 2 | 2 | |
569939 | 569939 | 2020-09-25 | Thurston | Washington | 53067 | 1179 | 18 |
569938 | 569938 | 2020-09-25 | Stevens | Washington | 53065 | 165 | 2 |
569937 | 569937 | 2020-09-25 | Spokane | Washington | 53063 | 6808 | 168 |
569936 | 569936 | 2020-09-25 | Snohomish | Washington | 53061 | 8016 | 223 |
569935 | 569935 | 2020-09-25 | Skamania | Washington | 53059 | 65 | 1 |
569934 | 569934 | 2020-09-25 | Skagit | Washington | 53057 | 1096 | 24 |
569933 | 569933 | 2020-09-25 | San Juan | Washington | 53055 | 30 | 0 |
569932 | 569932 | 2020-09-25 | Pierce | Washington | 53053 | 8677 | 220 |
569931 | 569931 | 2020-09-25 | Pend Oreille | Washington | 53051 | 60 | 0 |
569930 | 569930 | 2020-09-25 | Pacific | Washington | 53049 | 80 | 3 |
569929 | 569929 | 2020-09-25 | Okanogan | Washington | 53047 | 1061 | 13 |
569928 | 569928 | 2020-09-25 | Mason | Washington | 53045 | 386 | 4 |
569927 | 569927 | 2020-09-25 | Lincoln | Washington | 53043 | 45 | 1 |
569926 | 569926 | 2020-09-25 | Lewis | Washington | 53041 | 491 | 4 |
569925 | 569925 | 2020-09-25 | Klickitat | Washington | 53039 | 192 | 3 |
569924 | 569924 | 2020-09-25 | Kittitas | Washington | 53037 | 528 | 22 |
569923 | 569923 | 2020-09-25 | Kitsap | Washington | 53035 | 1175 | 14 |
569922 | 569922 | 2020-09-25 | King | Washington | 53033 | 21915 | 787 |
569921 | 569921 | 2020-09-25 | Jefferson | Washington | 53031 | 71 | 0 |
569920 | 569920 | 2020-09-25 | Island | Washington | 53029 | 318 | 15 |
569919 | 569919 | 2020-09-25 | Grays Harbor | Washington | 53027 | 476 | 7 |
569918 | 569918 | 2020-09-25 | Grant | Washington | 53025 | 3033 | 20 |
569917 | 569917 | 2020-09-25 | Garfield | Washington | 53023 | 11 | 0 |
569916 | 569916 | 2020-09-25 | Franklin | Washington | 53021 | 4379 | 67 |
569915 | 569915 | 2020-09-25 | Ferry | Washington | 53019 | 30 | 0 |
569914 | 569914 | 2020-09-25 | Douglas | Washington | 53017 | 1295 | 10 |
569913 | 569913 | 2020-09-25 | Cowlitz | Washington | 53015 | 657 | 7 |
569912 | 569912 | 2020-09-25 | Columbia | Washington | 53013 | 14 | 1 |
569911 | 569911 | 2020-09-25 | Clark | Washington | 53011 | 3300 | 64 |
569910 | 569910 | 2020-09-25 | Clallam | Washington | 53009 | 228 | 1 |
569909 | 569909 | 2020-09-25 | Chelan | Washington | 53007 | 2055 | 17 |
569908 | 569908 | 2020-09-25 | Benton | Washington | 53005 | 4684 | 133 |
569907 | 569907 | 2020-09-25 | Asotin | Washington | 53003 | 105 | 2 |
569906 | 569906 | 2020-09-25 | Adams | Washington | 53001 | 835 | 10 |
569905 | 569905 | 2020-09-25 | York | Virginia | 51199 | 541 | 8 |
569904 | 569904 | 2020-09-25 | Wythe | Virginia | 51197 | 232 | 4 |
569903 | 569903 | 2020-09-25 | Wise | Virginia | 51195 | 400 | 9 |
569902 | 569902 | 2020-09-25 | Winchester city | Virginia | 51840 | 495 | 4 |
569901 | 569901 | 2020-09-25 | Williamsburg city | Virginia | 51830 | 177 | 7 |
569900 | 569900 | 2020-09-25 | Westmoreland | Virginia | 51193 | 273 | 3 |
569899 | 569899 | 2020-09-25 | Waynesboro city | Virginia | 51820 | 259 | 3 |
569898 | 569898 | 2020-09-25 | Washington | Virginia | 51191 | 553 | 20 |
569897 | 569897 | 2020-09-25 | Warren | Virginia | 51187 | 415 | 7 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [us-counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );