Big Local News snapshots this data once a day from The Johns Hopkins University Center for Systems Science and Engineering. These are daily reports which provide cases, deaths and recovered for all global locations as wells as United States counties. There is one CSV file for each day's report. The entire set of CSV files are refreshed daily. The zipped archives contain previous daily reports and are date stamped when they were uplaoded by Big Local News. Please cite Johns Hopkins University as described in the README.

Data source: Big Local News · About: README

3,420 rows sorted by Province_State descending

View and edit SQL

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State ▲ Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3218     Zhejiang China 3/22/20 7:20 29.1832 120.0934 1237 1 1219 17 Zhejiang, China
3224     Yunnan China 3/16/20 23:37 24.974 101.487 176 2 172 2 Yunnan, China
3231     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
1129 56013 Fremont Wyoming US 3/22/20 23:45 43.04183996 -108.6296893 10 0 0 0 Fremont, Wyoming, US
1130 56021 Laramie Wyoming US 3/22/20 23:45 41.3070252 -104.6887497 6 0 0 0 Laramie, Wyoming, US
1131 56033 Sheridan Wyoming US 3/22/20 23:45 44.79048913 -106.8862389 4 0 0 0 Sheridan, Wyoming, US
1132 56039 Teton Wyoming US 3/22/20 23:45 43.93522482 -110.5890801 2 0 0 0 Teton, Wyoming, US
1133 56029 Park Wyoming US 3/22/20 23:45 44.52157546 -109.5852825 1 0 0 0 Park, Wyoming, US
1134 56005 Campbell Wyoming US 3/22/20 23:45 44.24886082 -105.5474404 1 0 0 0 Campbell, Wyoming, US
1135 56025 Natrona Wyoming US 3/22/20 23:45 42.96180148 -106.797885 1 0 0 0 Natrona, Wyoming, US
1136 56007 Carbon Wyoming US 3/22/20 23:45 41.69357844 -106.9326084 1 0 0 0 Carbon, Wyoming, US
3160 56001 Albany Wyoming US 3/22/20 23:45 41.65498705 -105.7235415 0 0 0 0 Albany, Wyoming, US
3161 56003 Big Horn Wyoming US 3/22/20 23:45 44.52405055 -107.9960365 0 0 0 0 Big Horn, Wyoming, US
3162 56009 Converse Wyoming US 3/22/20 23:45 42.97272268 -105.5081848 0 0 0 0 Converse, Wyoming, US
3163 56011 Crook Wyoming US 3/22/20 23:45 44.58855102 -104.5697705 0 0 0 0 Crook, Wyoming, US
3164 56015 Goshen Wyoming US 3/22/20 23:45 42.08798185 -104.3534743 0 0 0 0 Goshen, Wyoming, US
3165 56017 Hot Springs Wyoming US 3/22/20 23:45 43.71930657 -108.4423174 0 0 0 0 Hot Springs, Wyoming, US
3166 56019 Johnson Wyoming US 3/22/20 23:45 44.04057166 -106.5845174 0 0 0 0 Johnson, Wyoming, US
3167 56023 Lincoln Wyoming US 3/22/20 23:45 42.26376367 -110.6563997 0 0 0 0 Lincoln, Wyoming, US
3168 56027 Niobrara Wyoming US 3/22/20 23:45 43.05607708 -104.4758896 0 0 0 0 Niobrara, Wyoming, US
3169 56031 Platte Wyoming US 3/22/20 23:45 42.13299116 -104.966331 0 0 0 0 Platte, Wyoming, US
3170 56035 Sublette Wyoming US 3/22/20 23:45 42.76558279 -109.9130922 0 0 0 0 Sublette, Wyoming, US
3171 56037 Sweetwater Wyoming US 3/22/20 23:45 41.65943896 -108.8827882 0 0 0 0 Sweetwater, Wyoming, US
3172 56041 Uinta Wyoming US 3/22/20 23:45 41.2878183 -110.5475782 0 0 0 0 Uinta, Wyoming, US
3173 56043 Washakie Wyoming US 3/22/20 23:45 43.90451606 -107.680187 0 0 0 0 Washakie, Wyoming, US
3174 56045 Weston Wyoming US 3/22/20 23:45 43.83961191 -104.5674881 0 0 0 0 Weston, Wyoming, US
1160   Unassigned Wuhan Evacuee US 3/22/20 23:45 0.0 0.0 4 0 0 0 Unassigned, Wuhan Evacuee, US
526 55079 Milwaukee Wisconsin US 3/22/20 23:45 43.00486062 -87.96733172 182 2 0 0 Milwaukee, Wisconsin, US
527 55025 Dane Wisconsin US 3/22/20 23:45 43.06601594 -89.41733797 61 0 0 0 Dane, Wisconsin, US
528 55133 Waukesha Wisconsin US 3/22/20 23:45 43.01833055 -88.30431188 30 0 0 0 Waukesha, Wisconsin, US
529 55039 Fond du Lac Wisconsin US 3/22/20 23:45 43.75354908 -88.48885325 16 1 0 0 Fond du Lac, Wisconsin, US
530 55131 Washington Wisconsin US 3/22/20 23:45 43.36863664 -88.22974712 14 0 0 0 Washington, Wisconsin, US
531 55089 Ozaukee Wisconsin US 3/22/20 23:45 43.38352225 -87.94625009 13 1 0 0 Ozaukee, Wisconsin, US
532 55059 Kenosha Wisconsin US 3/22/20 23:45 42.57639354 -88.04051686 10 0 0 0 Kenosha, Wisconsin, US
533 55117 Sheboygan Wisconsin US 3/22/20 23:45 43.72099677 -87.94579284 6 0 0 0 Sheboygan, Wisconsin, US
534 55139 Winnebago Wisconsin US 3/22/20 23:45 44.06886922 -88.64477096 5 0 0 0 Winnebago, Wisconsin, US
535 55063 La Crosse Wisconsin US 3/22/20 23:45 43.90632465 -91.11451093 5 0 0 0 La Crosse, Wisconsin, US
536 55021 Columbia Wisconsin US 3/22/20 23:45 43.46492199 -89.33589004 5 0 0 0 Columbia, Wisconsin, US
537 55101 Racine Wisconsin US 3/22/20 23:45 42.74753117 -88.05941254 4 0 0 0 Racine, Wisconsin, US
538 55035 Eau Claire Wisconsin US 3/22/20 23:45 44.726614 -91.28609183 4 0 0 0 Eau Claire, Wisconsin, US
539 55009 Brown Wisconsin US 3/22/20 23:45 44.4526553 -88.00411844 3 0 0 0 Brown, Wisconsin, US
540 55127 Walworth Wisconsin US 3/22/20 23:45 42.66858202 -88.54163073 3 0 0 0 Walworth, Wisconsin, US
541 55105 Rock Wisconsin US 3/22/20 23:45 42.67151616 -89.071479 3 0 0 0 Rock, Wisconsin, US
542 55087 Outagamie Wisconsin US 3/22/20 23:45 44.41578887 -88.46565023 2 0 0 0 Outagamie, Wisconsin, US
543 55111 Sauk Wisconsin US 3/22/20 23:45 43.42574087 -89.94966132 2 0 0 0 Sauk, Wisconsin, US
544 55109 St. Croix Wisconsin US 3/22/20 23:45 45.03437474 -92.45000068 2 0 0 0 St. Croix, Wisconsin, US
545 55055 Jefferson Wisconsin US 3/22/20 23:45 43.02054068 -88.77529134 2 0 0 0 Jefferson, Wisconsin, US
546 55093 Pierce Wisconsin US 3/22/20 23:45 44.71850291 -92.4224416 1 0 0 0 Pierce, Wisconsin, US
547 55141 Wood Wisconsin US 3/22/20 23:45 44.45537896 -90.04158336 1 0 0 0 Wood, Wisconsin, US
548 55015 Calumet Wisconsin US 3/22/20 23:45 44.0816316 -88.21780273 1 0 0 0 Calumet, Wisconsin, US
549 55007 Bayfield Wisconsin US 3/22/20 23:45 46.52868768 -91.19716729 1 0 0 0 Bayfield, Wisconsin, US
550 55033 Dunn Wisconsin US 3/22/20 23:45 44.94562799 -91.8962481 1 0 0 0 Dunn, Wisconsin, US
551 55017 Chippewa Wisconsin US 3/22/20 23:45 45.06939744 -91.28068855 1 0 0 0 Chippewa, Wisconsin, US
552 55073 Marathon Wisconsin US 3/22/20 23:45 44.89792533 -89.75863384 1 0 0 0 Marathon, Wisconsin, US
553 55031 Douglas Wisconsin US 3/22/20 23:45 46.43222285 -91.91595768 1 0 0 0 Douglas, Wisconsin, US
554 55045 Green Wisconsin US 3/22/20 23:45 42.6794956 -89.60243287 1 0 0 0 Green, Wisconsin, US
3117 55001 Adams Wisconsin US 3/22/20 23:45 43.96974651 -89.76782777 0 0 0 0 Adams, Wisconsin, US
3118 55003 Ashland Wisconsin US 3/22/20 23:45 46.31956891 -90.67837132 0 0 0 0 Ashland, Wisconsin, US
3119 55005 Barron Wisconsin US 3/22/20 23:45 45.42372701 -91.84833627 0 0 0 0 Barron, Wisconsin, US
3120 55011 Buffalo Wisconsin US 3/22/20 23:45 44.37835084 -91.75332578 0 0 0 0 Buffalo, Wisconsin, US
3121 55013 Burnett Wisconsin US 3/22/20 23:45 45.86303537 -92.36711412 0 0 0 0 Burnett, Wisconsin, US
3122 55019 Clark Wisconsin US 3/22/20 23:45 44.73483377 -90.61207486 0 0 0 0 Clark, Wisconsin, US
3123 55023 Crawford Wisconsin US 3/22/20 23:45 43.23870316 -90.93073686 0 0 0 0 Crawford, Wisconsin, US
3124 55027 Dodge Wisconsin US 3/22/20 23:45 43.41576662 -88.70928178 0 0 0 0 Dodge, Wisconsin, US
3125 55029 Door Wisconsin US 3/22/20 23:45 44.95856458 -87.30002707 0 0 0 0 Door, Wisconsin, US
3126 55037 Florence Wisconsin US 3/22/20 23:45 45.84963535 -88.39804137 0 0 0 0 Florence, Wisconsin, US
3127 55041 Forest Wisconsin US 3/22/20 23:45 45.66678019 -88.77084892 0 0 0 0 Forest, Wisconsin, US
3128 55043 Grant Wisconsin US 3/22/20 23:45 42.8671731 -90.7063218 0 0 0 0 Grant, Wisconsin, US
3129 55047 Green Lake Wisconsin US 3/22/20 23:45 43.80025981 -89.04679553 0 0 0 0 Green Lake, Wisconsin, US
3130 55049 Iowa Wisconsin US 3/22/20 23:45 43.00050278 -90.13469017 0 0 0 0 Iowa, Wisconsin, US
3131 55051 Iron Wisconsin US 3/22/20 23:45 46.26302338 -90.24295041 0 0 0 0 Iron, Wisconsin, US
3132 55053 Jackson Wisconsin US 3/22/20 23:45 44.31864893 -90.80566792 0 0 0 0 Jackson, Wisconsin, US
3133 55057 Juneau Wisconsin US 3/22/20 23:45 43.92456975 -90.11120239 0 0 0 0 Juneau, Wisconsin, US
3134 55061 Kewaunee Wisconsin US 3/22/20 23:45 44.51727459 -87.61468386 0 0 0 0 Kewaunee, Wisconsin, US
3135 55065 Lafayette Wisconsin US 3/22/20 23:45 42.66005229 -90.1317729 0 0 0 0 Lafayette, Wisconsin, US
3136 55067 Langlade Wisconsin US 3/22/20 23:45 45.26271619 -89.07483625 0 0 0 0 Langlade, Wisconsin, US
3137 55069 Lincoln Wisconsin US 3/22/20 23:45 45.33737523 -89.73411273 0 0 0 0 Lincoln, Wisconsin, US
3138 55071 Manitowoc Wisconsin US 3/22/20 23:45 44.11946801 -87.80928853 0 0 0 0 Manitowoc, Wisconsin, US
3139 55075 Marinette Wisconsin US 3/22/20 23:45 45.38553432 -88.033246 0 0 0 0 Marinette, Wisconsin, US
3140 55077 Marquette Wisconsin US 3/22/20 23:45 43.81911946 -89.40073763 0 0 0 0 Marquette, Wisconsin, US
3141 55078 Menominee Wisconsin US 3/22/20 23:45 45.00422544 -88.70950714 0 0 0 0 Menominee, Wisconsin, US
3142 55081 Monroe Wisconsin US 3/22/20 23:45 43.94641218 -90.618819 0 0 0 0 Monroe, Wisconsin, US
3143 55083 Oconto Wisconsin US 3/22/20 23:45 45.02715345 -88.26807503 0 0 0 0 Oconto, Wisconsin, US
3144 55085 Oneida Wisconsin US 3/22/20 23:45 45.70677897 -89.51944105 0 0 0 0 Oneida, Wisconsin, US
3145 55091 Pepin Wisconsin US 3/22/20 23:45 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
3146 55095 Polk Wisconsin US 3/22/20 23:45 45.46130348 -92.44182875 0 0 0 0 Polk, Wisconsin, US
3147 55097 Portage Wisconsin US 3/22/20 23:45 44.47558711 -89.50152965 0 0 0 0 Portage, Wisconsin, US
3148 55099 Price Wisconsin US 3/22/20 23:45 45.68051754 -90.3609888 0 0 0 0 Price, Wisconsin, US
3149 55103 Richland Wisconsin US 3/22/20 23:45 43.3762778 -90.43012729 0 0 0 0 Richland, Wisconsin, US
3150 55107 Rusk Wisconsin US 3/22/20 23:45 45.47498854 -91.1333012 0 0 0 0 Rusk, Wisconsin, US
3151 55113 Sawyer Wisconsin US 3/22/20 23:45 45.87931905 -91.14504927 0 0 0 0 Sawyer, Wisconsin, US
3152 55115 Shawano Wisconsin US 3/22/20 23:45 44.78902246 -88.76443896 0 0 0 0 Shawano, Wisconsin, US
3153 55119 Taylor Wisconsin US 3/22/20 23:45 45.21179252 -90.5004405 0 0 0 0 Taylor, Wisconsin, US
3154 55121 Trempealeau Wisconsin US 3/22/20 23:45 44.30360275 -91.35893614 0 0 0 0 Trempealeau, Wisconsin, US
3155 55123 Vernon Wisconsin US 3/22/20 23:45 43.59422667 -90.8324691 0 0 0 0 Vernon, Wisconsin, US
3156 55125 Vilas Wisconsin US 3/22/20 23:45 46.05467334 -89.51719204 0 0 0 0 Vilas, Wisconsin, US
3157 55129 Washburn Wisconsin US 3/22/20 23:45 45.89838588 -91.79050449 0 0 0 0 Washburn, Wisconsin, US
3158 55135 Waupaca Wisconsin US 3/22/20 23:45 44.47068056 -88.96534501 0 0 0 0 Waupaca, Wisconsin, US
3159 55137 Waushara Wisconsin US 3/22/20 23:45 44.11324419 -89.24317107 0 0 0 0 Waushara, Wisconsin, US
3194     Western Australia Australia 3/22/20 23:48 -31.9505 115.8605 120 1 1 118 Western Australia, Australia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [03-22-2020] (
   [FIPS] INTEGER,
   [Admin2] TEXT,
   [Province_State] TEXT,
   [Country_Region] TEXT,
   [Last_Update] TEXT,
   [Lat] FLOAT,
   [Long_] FLOAT,
   [Confirmed] INTEGER,
   [Deaths] INTEGER,
   [Recovered] INTEGER,
   [Active] INTEGER,
   [Combined_Key] TEXT
);