03-30-2020

Table actions
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,442 rows sorted by rowid descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid ▲ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3242 3242     Queensland Australia 3/30/20 22:58 -27.4698 153.0251 689 2 8 679 Queensland, Australia
3241 3241     Quebec Canada 3/30/20 22:58 52.9399 -73.5491 3430 67 0 0 Quebec, Canada
3240 3240     Qinghai China 2/23/20 11:19 35.7452 95.9956 18 0 18 0 Qinghai, China
3239 3239     Puerto Rico US 3/30/20 22:52 18.2208 -66.5901 174 6 0 0 Puerto Rico, US
3238 3238     Prince Edward Island Canada 3/30/20 22:58 46.5107 -63.4168 18 0 0 0 Prince Edward Island, Canada
3237 3237     Ontario Canada 3/30/20 22:58 51.2538 -85.3232 1706 31 0 0 Ontario, Canada
3236 3236     Nunavut Canada 3/30/20 22:58 70.2998 -83.1076 0 0 0 0 Nunavut, Canada
3235 3235     Nova Scotia Canada 3/30/20 22:58 44.682 -63.7443 127 0 0 0 Nova Scotia, Canada
3234 3234     Northwest Territories Canada 3/30/20 22:58 64.8255 -124.8457 1 0 0 0 ,Northwest Territories,Canada
3233 3233     Northern Territory Australia 3/30/20 22:58 -12.4634 130.8456 15 0 0 15 Northern Territory, Australia
3232 3232 69000   Northern Mariana Islands US 3/30/20 22:52 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3231 3231     Ningxia China 3/16/20 8:47 37.2692 106.1655 75 0 75 0 Ningxia, China
3230 3230     Newfoundland and Labrador Canada 3/30/20 22:58 53.1355 -57.6604 148 1 0 0 Newfoundland and Labrador, Canada
3229 3229     New South Wales Australia 3/30/20 22:58 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
3228 3228     New Caledonia France 3/30/20 22:52 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3227 3227     New Brunswick Canada 3/30/20 22:58 46.5653 -66.4619 68 0 0 0 New Brunswick, Canada
3226 3226     Montserrat United Kingdom 3/30/20 22:52 16.742498 -62.187366 5 0 0 5 Montserrat, United Kingdom
3225 3225     Mayotte France 3/30/20 22:52 -12.8275 45.166244 82 0 10 72 Mayotte, France
3224 3224     Martinique France 3/30/20 22:52 14.6415 -61.0242 93 1 0 92 Martinique, France
3223 3223     Manitoba Canada 3/30/20 22:58 53.7609 -98.8139 96 1 0 0 Manitoba, Canada
3222 3222     Macau China 3/30/20 2:07 22.1667 113.55 38 0 10 28 Macau, China
3221 3221     Liaoning China 3/29/20 23:44 41.2956 122.6085 136 2 124 10 Liaoning, China
3220 3220     Jilin China 3/29/20 0:28 43.6661 126.1923 98 1 92 5 Jilin, China
3219 3219     Jiangxi China 3/30/20 3:15 27.614 115.7221 937 1 935 1 Jiangxi, China
3218 3218     Jiangsu China 3/30/20 1:49 32.9711 119.455 645 0 631 14 Jiangsu, China
3217 3217     Isle of Man United Kingdom 3/30/20 22:52 54.2361 -4.5481 49 0 0 49 Isle of Man, United Kingdom
3216 3216     Inner Mongolia China 3/30/20 0:06 44.0935 113.9448 97 1 74 22 Inner Mongolia, China
3215 3215     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
3214 3214     Hubei China 3/30/20 12:30 30.9756 112.2707 67801 3186 62889 1726 Hubei, China
3213 3213     Hong Kong China 3/30/20 9:27 22.3 114.2 682 4 123 555 Hong Kong, China
3212 3212     Henan China 3/29/20 1:44 33.882 113.614 1276 22 1251 3 Henan, China
3211 3211     Heilongjiang China 3/26/20 0:15 47.862 127.7615 484 13 469 2 Heilongjiang, China
3210 3210     Hebei China 3/30/20 2:07 39.549 116.1306 321 6 310 5 Hebei, China
3209 3209     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3208 3208     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3207 3207     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3206 3206     Guangdong China 3/30/20 2:07 23.3417 113.4244 1484 8 1351 125 Guangdong, China
3205 3205 66000   Guam US 3/30/20 22:52 13.4443 144.7937 58 1 0 0 Guam, US
3204 3204     Guadeloupe France 3/30/20 22:52 16.265 -61.551 106 4 17 85 Guadeloupe, France
3203 3203     Greenland Denmark 3/30/20 22:52 71.7069 -42.6043 10 0 2 8 Greenland, Denmark
3202 3202 99999   Grand Princess US 3/30/20 22:52 0.0 0.0 103 3 0 0 Grand Princess, US
3201 3201     Grand Princess Canada 3/30/20 22:58 0.0 0.0 13 0 0 0 Grand Princess, Canada
3200 3200     Gibraltar United Kingdom 3/30/20 22:52 36.1408 -5.3536 69 0 34 35 Gibraltar, United Kingdom
3199 3199     Gansu China 3/29/20 14:25 37.8099 101.0583 138 2 125 11 Gansu, China
3198 3198     Fujian China 3/30/20 0:32 26.0789 117.9874 340 1 295 44 Fujian, China
3197 3197     French Polynesia France 3/30/20 22:52 -17.6797 149.4068 36 0 0 36 French Polynesia, France
3196 3196     French Guiana France 3/30/20 22:52 4.0 -53.0 43 0 6 37 French Guiana, France
3195 3195     Faroe Islands Denmark 3/30/20 22:52 61.8926 -6.9118 168 0 70 98 Faroe Islands, Denmark
3194 3194 88888   Diamond Princess US 3/30/20 22:52 0.0 0.0 49 0 0 0 Diamond Princess, US
3193 3193     Diamond Princess Canada 3/30/20 22:58 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3192 3192     Curacao Netherlands 3/30/20 22:52 12.1696 -68.99 11 1 2 8 Curacao, Netherlands
3191 3191     Chongqing China 3/29/20 0:14 30.0572 107.874 579 6 570 3 Chongqing, China
3190 3190     Channel Islands United Kingdom 3/30/20 22:52 49.3723 -2.3644 141 2 0 139 Channel Islands, United Kingdom
3189 3189     Cayman Islands United Kingdom 3/30/20 22:52 19.3133 -81.2546 12 1 0 11 Cayman Islands, United Kingdom
3188 3188     British Virgin Islands United Kingdom 3/30/20 22:52 18.4207 -64.64 2 0 0 2 British Virgin Islands, United Kingdom
3187 3187     British Columbia Canada 3/30/20 22:58 53.7267 -127.6476 970 19 0 0 British Columbia, Canada
3186 3186     Bermuda United Kingdom 3/30/20 22:52 32.3078 -64.7505 27 0 2 25 Bermuda, United Kingdom
3185 3185     Beijing China 3/30/20 5:34 40.1824 116.4142 577 8 415 154 Beijing, China
3184 3184     Australian Capital Territory Australia 3/30/20 22:58 -35.4735 149.0124 78 1 2 75 Australian Capital Territory, Australia
3183 3183     Aruba Netherlands 3/30/20 22:52 12.5211 -69.9683 50 0 1 49 Aruba, Netherlands
3182 3182     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3181 3181     Anguilla United Kingdom 3/30/20 22:52 18.2206 -63.0686 2 0 0 2 Anguilla, United Kingdom
3180 3180 60000   American Samoa US 3/30/20 22:52 -14.271 -170.132 0 0 0 0 American Samoa, US
3179 3179     Alberta Canada 3/30/20 22:58 53.9333 -116.5765 661 3 0 0 Alberta, Canada
3178 3178 46137 Ziebach South Dakota US 3/30/20 22:52 44.97881876 -101.6654622 0 0 0 0 Ziebach, South Dakota, US
3177 3177 48507 Zavala Texas US 3/30/20 22:52 28.86617238 -99.76050829 0 0 0 0 Zavala, Texas, US
3176 3176 48505 Zapata Texas US 3/30/20 22:52 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
3175 3175 8125 Yuma Colorado US 3/30/20 22:52 40.00346839 -102.4258673 2 0 0 0 Yuma, Colorado, US
3174 3174 4027 Yuma Arizona US 3/30/20 22:52 32.76895712 -113.9066674 6 0 0 0 Yuma, Arizona, US
3173 3173 2290 Yukon-Koyukuk Alaska US 3/30/20 22:52 65.50815459 -151.3907387 0 0 0 0 Yukon-Koyukuk, Alaska, US
3172 3172 6115 Yuba California US 3/30/20 22:52 39.26255932 -121.3535644 4 0 0 0 Yuba, California, US
3171 3171 48503 Young Texas US 3/30/20 22:52 33.17659707 -98.68790885 1 0 0 0 Young, Texas, US
3170 3170 51199 York Virginia US 3/30/20 22:52 37.24374789 -76.54412815 11 1 0 0 York, Virginia, US
3169 3169 45091 York South Carolina US 3/30/20 22:52 34.97281497 -81.18085944 43 0 0 0 York, South Carolina, US
3168 3168 42133 York Pennsylvania US 3/30/20 22:52 39.9210089 -76.73040131 54 0 0 0 York, Pennsylvania, US
3167 3167 31185 York Nebraska US 3/30/20 22:52 40.87272618 -97.59710186 1 0 0 0 York, Nebraska, US
3166 3166 23031 York Maine US 3/30/20 22:52 43.47808377 -70.71052375 53 0 0 0 York, Maine, US
3165 3165 6113 Yolo California US 3/30/20 22:52 38.68278902 -121.9018288 16 1 0 0 Yolo, California, US
3164 3164 48501 Yoakum Texas US 3/30/20 22:52 33.17320212 -102.8276433 0 0 0 0 Yoakum, Texas, US
3163 3163 30111 Yellowstone Montana US 3/30/20 22:52 45.93955949 -108.2691486 26 0 0 0 Yellowstone, Montana, US
3162 3162 27173 Yellow Medicine Minnesota US 3/30/20 22:52 44.71710183 -95.86842453 0 0 0 0 Yellow Medicine, Minnesota, US
3161 3161 5149 Yell Arkansas US 3/30/20 22:52 35.00292371 -93.41171338 0 0 0 0 Yell, Arkansas, US
3160 3160 28163 Yazoo Mississippi US 3/30/20 22:52 32.77890365 -90.39656148 5 0 0 0 Yazoo, Mississippi, US
3159 3159 4025 Yavapai Arizona US 3/30/20 22:52 34.59933926 -112.5538588 15 0 0 0 Yavapai, Arizona, US
3158 3158 36123 Yates New York US 3/30/20 22:52 42.63505484 -77.10369919 0 0 0 0 Yates, New York, US
3157 3157 46135 Yankton South Dakota US 3/30/20 22:52 43.00924485 -97.39467635 4 0 0 0 Yankton, South Dakota, US
3156 3156 37199 Yancey North Carolina US 3/30/20 22:52 35.90079156 -82.31237181 0 0 0 0 Yancey, North Carolina, US
3155 3155 41071 Yamhill Oregon US 3/30/20 22:52 45.23330449 -123.3086963 14 2 0 0 Yamhill, Oregon, US
3154 3154 28161 Yalobusha Mississippi US 3/30/20 22:52 34.02824175 -89.7076205 3 0 0 0 Yalobusha, Mississippi, US
3153 3153 2282 Yakutat Alaska US 3/30/20 22:52 59.8909808 -140.3601451 0 0 0 0 Yakutat, Alaska, US
3152 3152 53077 Yakima Washington US 3/30/20 22:52 46.45738486 -120.7380126 147 3 0 0 Yakima, Washington, US
3151 3151 37197 Yadkin North Carolina US 3/30/20 22:52 36.16222629 -80.66239436 1 0 0 0 Yadkin, North Carolina, US
3150 3150 51197 Wythe Virginia US 3/30/20 22:52 36.91582035 -81.07834059 1 0 0 0 Wythe, Virginia, US
3149 3149 54109 Wyoming West Virginia US 3/30/20 22:52 37.612327 -81.54511071 0 0 0 0 Wyoming, West Virginia, US
3148 3148 42131 Wyoming Pennsylvania US 3/30/20 22:52 41.51955538 -76.01074915 0 0 0 0 Wyoming, Pennsylvania, US
3147 3147 36121 Wyoming New York US 3/30/20 22:52 42.70145109 -78.22199579 8 1 0 0 Wyoming, New York, US
3146 3146 20209 Wyandotte Kansas US 3/30/20 22:52 39.11727348 -94.76378225 67 4 0 0 Wyandotte, Kansas, US
3145 3145 39175 Wyandot Ohio US 3/30/20 22:52 40.84339621 -83.30734173 1 0 0 0 Wyandot, Ohio, US
3144 3144 29229 Wright Missouri US 3/30/20 22:52 37.27029221 -92.46914488 4 0 0 0 Wright, Missouri, US
3143 3143 27171 Wright Minnesota US 3/30/20 22:52 45.17297924 -93.96234781 6 0 0 0 Wright, Minnesota, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-30-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
);