03-27-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,432 rows sorted by Admin2 descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 ▲ Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
3173 3173 46137 Ziebach South Dakota US 2020-03-27 22:14:55 44.97881876 -101.6654622 0 0 0 0 Ziebach, South Dakota, US
3172 3172 48507 Zavala Texas US 2020-03-27 22:14:55 28.86617238 -99.76050829 0 0 0 0 Zavala, Texas, US
3171 3171 48505 Zapata Texas US 2020-03-27 22:14:55 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
3169 3169 4027 Yuma Arizona US 2020-03-27 22:14:55 32.76895712 -113.90666740000002 4 0 0 0 Yuma, Arizona, US
3170 3170 8125 Yuma Colorado US 2020-03-27 22:14:55 40.00346839 -102.4258673 2 0 0 0 Yuma, Colorado, US
3168 3168 2290 Yukon-Koyukuk Alaska US 2020-03-27 22:14:55 65.50815459 -151.39073869999999 0 0 0 0 Yukon-Koyukuk, Alaska, US
3167 3167 6115 Yuba California US 2020-03-27 22:14:55 39.26255932 -121.35356440000001 3 0 0 0 Yuba, California, US
3166 3166 48503 Young Texas US 2020-03-27 22:14:55 33.17659707 -98.68790885 1 0 0 0 Young, Texas, US
3161 3161 23031 York Maine US 2020-03-27 22:14:55 43.47808377 -70.71052375 33 0 0 0 York, Maine, US
3162 3162 31185 York Nebraska US 2020-03-27 22:14:55 40.87272618 -97.59710186 0 0 0 0 York, Nebraska, US
3163 3163 42133 York Pennsylvania US 2020-03-27 22:14:55 39.9210089 -76.73040131 30 0 0 0 York, Pennsylvania, US
3164 3164 45091 York South Carolina US 2020-03-27 22:14:55 34.97281497 -81.18085944 19 0 0 0 York, South Carolina, US
3165 3165 51199 York Virginia US 2020-03-27 22:14:55 37.24374789 -76.54412815 9 1 0 0 York, Virginia, US
3160 3160 6113 Yolo California US 2020-03-27 22:14:55 38.68278902 -121.90182879999999 13 1 0 0 Yolo, California, US
3159 3159 48501 Yoakum Texas US 2020-03-27 22:14:55 33.17320212 -102.82764329999999 1 0 0 0 Yoakum, Texas, US
3158 3158 30111 Yellowstone Montana US 2020-03-27 22:14:55 45.93955949 -108.26914860000001 20 0 0 0 Yellowstone, Montana, US
3157 3157 27173 Yellow Medicine Minnesota US 2020-03-27 22:14:55 44.71710183 -95.86842453 0 0 0 0 Yellow Medicine, Minnesota, US
3156 3156 5149 Yell Arkansas US 2020-03-27 22:14:55 35.00292371 -93.41171338 0 0 0 0 Yell, Arkansas, US
3155 3155 28163 Yazoo Mississippi US 2020-03-27 22:14:55 32.77890365 -90.39656148 4 0 0 0 Yazoo, Mississippi, US
3154 3154 4025 Yavapai Arizona US 2020-03-27 22:14:55 34.59933926 -112.5538588 9 0 0 0 Yavapai, Arizona, US
3153 3153 36123 Yates New York US 2020-03-27 22:14:55 42.63505484 -77.10369919 0 0 0 0 Yates, New York, US
3152 3152 46135 Yankton South Dakota US 2020-03-27 22:14:55 43.00924485 -97.39467635 0 0 0 0 Yankton, South Dakota, US
3151 3151 37199 Yancey North Carolina US 2020-03-27 22:14:55 35.90079156 -82.31237181 0 0 0 0 Yancey, North Carolina, US
3150 3150 41071 Yamhill Oregon US 2020-03-27 22:14:55 45.23330449 -123.3086963 11 0 0 0 Yamhill, Oregon, US
3149 3149 28161 Yalobusha Mississippi US 2020-03-27 22:14:55 34.02824175 -89.70762049999998 3 0 0 0 Yalobusha, Mississippi, US
3148 3148 2282 Yakutat Alaska US 2020-03-27 22:14:55 59.890980799999994 -140.36014509999998 0 0 0 0 Yakutat, Alaska, US
3147 3147 53077 Yakima Washington US 2020-03-27 22:14:55 46.45738486 -120.73801259999999 66 2 0 0 Yakima, Washington, US
3146 3146 37197 Yadkin North Carolina US 2020-03-27 22:14:55 36.16222629 -80.66239436 0 0 0 0 Yadkin, North Carolina, US
3145 3145 51197 Wythe Virginia US 2020-03-27 22:14:55 36.91582035 -81.07834059 0 0 0 0 Wythe, Virginia, US
3142 3142 36121 Wyoming New York US 2020-03-27 22:14:55 42.70145109 -78.22199579 7 1 0 0 Wyoming, New York, US
3143 3143 42131 Wyoming Pennsylvania US 2020-03-27 22:14:55 41.51955538 -76.01074915 0 0 0 0 Wyoming, Pennsylvania, US
3144 3144 54109 Wyoming West Virginia US 2020-03-27 22:14:55 37.612327 -81.54511071 0 0 0 0 Wyoming, West Virginia, US
3141 3141 20209 Wyandotte Kansas US 2020-03-27 22:14:55 39.11727348 -94.76378225 43 3 0 0 Wyandotte, Kansas, US
3140 3140 39175 Wyandot Ohio US 2020-03-27 22:14:55 40.84339621 -83.30734173 1 0 0 0 Wyandot, Ohio, US
3137 3137 19197 Wright Iowa US 2020-03-27 22:14:55 42.73305373 -93.73515113 1 0 0 0 Wright, Iowa, US
3138 3138 27171 Wright Minnesota US 2020-03-27 22:14:55 45.17297924 -93.96234781 5 0 0 0 Wright, Minnesota, US
3139 3139 29229 Wright Missouri US 2020-03-27 22:14:55 37.27029221 -92.46914488 1 0 0 0 Wright, Missouri, US
3136 3136 2275 Wrangell Alaska US 2020-03-27 22:14:55 56.3202004 -132.05837309999998 0 0 0 0 Wrangell, Alaska, US
3133 3133 13321 Worth Georgia US 2020-03-27 22:14:55 31.55162306 -83.85090513 7 0 0 0 Worth, Georgia, US
3134 3134 19195 Worth Iowa US 2020-03-27 22:14:55 43.37750768 -93.26087602 0 0 0 0 Worth, Iowa, US
3135 3135 29227 Worth Missouri US 2020-03-27 22:14:55 40.47945588 -94.42328751 0 0 0 0 Worth, Missouri, US
3131 3131 24047 Worcester Maryland US 2020-03-27 22:14:55 38.21274277 -75.33200012 2 0 0 0 Worcester, Maryland, US
3132 3132 25027 Worcester Massachusetts US 2020-03-27 22:14:55 42.35026951 -71.90493363 219 3 0 0 Worcester, Massachusetts, US
3130 3130 40153 Woodward Oklahoma US 2020-03-27 22:14:55 36.42316318 -99.26283045 0 0 0 0 Woodward, Oklahoma, US
3129 3129 20207 Woodson Kansas US 2020-03-27 22:14:55 37.8865336 -95.74006277 1 0 0 0 Woodson, Kansas, US
3128 3128 40151 Woods Oklahoma US 2020-03-27 22:14:55 36.76705782 -98.86573064 0 0 0 0 Woods, Oklahoma, US
3127 3127 5147 Woodruff Arkansas US 2020-03-27 22:14:55 35.18902527 -91.2439489 1 0 0 0 Woodruff, Arkansas, US
3125 3125 17203 Woodford Illinois US 2020-03-27 22:14:55 40.78579374 -89.20973757 3 0 0 0 Woodford, Illinois, US
3126 3126 21239 Woodford Kentucky US 2020-03-27 22:14:55 38.04178222 -84.7417556 0 0 0 0 Woodford, Kentucky, US
3124 3124 19193 Woodbury Iowa US 2020-03-27 22:14:55 42.38979414 -96.0459439 3 0 0 0 Woodbury, Iowa, US
3120 3120 39173 Wood Ohio US 2020-03-27 22:14:55 41.36224827 -83.62285108 8 0 0 0 Wood, Ohio, US
3121 3121 48499 Wood Texas US 2020-03-27 22:14:55 32.78722382 -95.38236368 0 0 0 0 Wood, Texas, US
3122 3122 54107 Wood West Virginia US 2020-03-27 22:14:55 39.20967886 -81.5162836 2 0 0 0 Wood, West Virginia, US
3123 3123 55141 Wood Wisconsin US 2020-03-27 22:14:55 44.45537896 -90.04158336 2 0 0 0 Wood, Wisconsin, US
3119 3119 21237 Wolfe Kentucky US 2020-03-27 22:14:55 37.73941626 -83.49303612 0 0 0 0 Wolfe, Kentucky, US
3117 3117 48497 Wise Texas US 2020-03-27 22:14:55 33.21570665 -97.65460265 0 0 0 0 Wise, Texas, US
3118 3118 51195 Wise Virginia US 2020-03-27 22:14:55 36.9746148 -82.62410519 0 0 0 0 Wise, Virginia, US
3116 3116 54105 Wirt West Virginia US 2020-03-27 22:14:55 39.02775007 -81.37473928 0 0 0 0 Wirt, West Virginia, US
3114 3114 1133 Winston Alabama US 2020-03-27 22:14:55 34.15030532 -87.37325922 2 0 0 0 Winston, Alabama, US
3115 3115 28159 Winston Mississippi US 2020-03-27 22:14:55 33.08747908 -89.03391385 3 0 0 0 Winston, Mississippi, US
3113 3113 27169 Winona Minnesota US 2020-03-27 22:14:55 43.98772283 -91.78081305 4 0 0 0 Winona, Minnesota, US
3112 3112 19191 Winneshiek Iowa US 2020-03-27 22:14:55 43.29094334 -91.84422722 2 0 0 0 Winneshiek, Iowa, US
3109 3109 17201 Winnebago Illinois US 2020-03-27 22:14:55 42.33641854 -89.16085327 8 0 0 0 Winnebago, Illinois, US
3110 3110 19189 Winnebago Iowa US 2020-03-27 22:14:55 43.37751174 -93.73407298 0 0 0 0 Winnebago, Iowa, US
3111 3111 55139 Winnebago Wisconsin US 2020-03-27 22:14:55 44.06886922 -88.64477096 6 0 0 0 Winnebago, Wisconsin, US
3108 3108 22127 Winn Louisiana US 2020-03-27 22:14:55 31.94449367 -92.63789413 1 0 0 0 Winn, Louisiana, US
3107 3107 48495 Winkler Texas US 2020-03-27 22:14:55 31.85008651 -103.04851629999999 0 0 0 0 Winkler, Texas, US
3106 3106 50027 Windsor Vermont US 2020-03-27 22:14:55 43.58010937 -72.58595157 18 1 0 0 Windsor, Vermont, US
3104 3104 9015 Windham Connecticut US 2020-03-27 22:14:55 41.82972709 -71.98182316 3 0 0 0 Windham, Connecticut, US
3105 3105 50025 Windham Vermont US 2020-03-27 22:14:55 42.986982 -72.71268875 7 0 0 0 Windham, Vermont, US
3103 3103 51840 Winchester Virginia US 2020-03-27 22:14:55 39.17054517 -78.17325058 0 0 0 0 Winchester, Virginia, US
3099 3099 20205 Wilson Kansas US 2020-03-27 22:14:55 37.55937174 -95.74323255 0 0 0 0 Wilson, Kansas, US
3100 3100 37195 Wilson North Carolina US 2020-03-27 22:14:55 35.70625477 -77.917978 7 0 0 0 Wilson, North Carolina, US
3101 3101 47189 Wilson Tennessee US 2020-03-27 22:14:55 36.15496772 -86.29775884 20 0 0 0 Wilson, Tennessee, US
3102 3102 48493 Wilson Texas US 2020-03-27 22:14:55 29.1732598 -98.08693082 1 0 0 0 Wilson, Texas, US
3096 3096 17199 Williamson Illinois US 2020-03-27 22:14:55 37.73033511 -88.92994027 1 0 0 0 Williamson, Illinois, US
3097 3097 47187 Williamson Tennessee US 2020-03-27 22:14:55 35.89099229 -86.89281867 91 0 0 0 Williamson, Tennessee, US
3098 3098 48491 Williamson Texas US 2020-03-27 22:14:55 30.64655664 -97.60048540000001 34 0 0 0 Williamson, Texas, US
3094 3094 45089 Williamsburg South Carolina US 2020-03-27 22:14:55 33.62190129 -79.72767442 1 0 0 0 Williamsburg, South Carolina, US
3095 3095 51830 Williamsburg Virginia US 2020-03-27 22:14:55 37.28131268 -76.70905141 5 1 0 0 Williamsburg, Virginia, US
3092 3092 38105 Williams North Dakota US 2020-03-27 22:14:55 48.34522353 -103.4793387 0 0 0 0 Williams, North Dakota, US
3093 3093 39171 Williams Ohio US 2020-03-27 22:14:55 41.56052014 -84.58429552 0 0 0 0 Williams, Ohio, US
3091 3091 48489 Willacy Texas US 2020-03-27 22:14:55 26.47411727 -97.61535848 1 0 0 0 Willacy, Texas, US
3090 3090 17197 Will Illinois US 2020-03-27 22:14:55 41.44619267 -87.97862712 104 3 0 0 Will, Illinois, US
3088 3088 13319 Wilkinson Georgia US 2020-03-27 22:14:55 32.80291082 -83.17140684 0 0 0 0 Wilkinson, Georgia, US
3089 3089 28157 Wilkinson Mississippi US 2020-03-27 22:14:55 31.16078225 -91.31018819 9 1 0 0 Wilkinson, Mississippi, US
3087 3087 27167 Wilkin Minnesota US 2020-03-27 22:14:55 46.35721532 -96.4684375 1 0 0 0 Wilkin, Minnesota, US
3085 3085 13317 Wilkes Georgia US 2020-03-27 22:14:55 33.78290391 -82.74286107 1 0 0 0 Wilkes, Georgia, US
3086 3086 37193 Wilkes North Carolina US 2020-03-27 22:14:55 36.2084135 -81.16232895 0 0 0 0 Wilkes, North Carolina, US
3083 3083 1131 Wilcox Alabama US 2020-03-27 22:14:55 31.98773215 -87.30891118 2 0 0 0 Wilcox, Alabama, US
3084 3084 13315 Wilcox Georgia US 2020-03-27 22:14:55 31.97496928 -83.43438555 0 0 0 0 Wilcox, Georgia, US
3082 3082 48487 Wilbarger Texas US 2020-03-27 22:14:55 34.07945812 -99.24178437 0 0 0 0 Wilbarger, Texas, US
3081 3081 24045 Wicomico Maryland US 2020-03-27 22:14:55 38.37301947 -75.62705831 5 0 0 0 Wicomico, Maryland, US
3079 3079 20203 Wichita Kansas US 2020-03-27 22:14:55 38.48178252 -101.3471509 0 0 0 0 Wichita, Kansas, US
3080 3080 48485 Wichita Texas US 2020-03-27 22:14:55 33.98842886 -98.70410340000001 15 0 0 0 Wichita, Texas, US
3078 3078 30109 Wibaux Montana US 2020-03-27 22:14:55 46.95925154 -104.2510927 0 0 0 0 Wibaux, Montana, US
3077 3077 53075 Whitman Washington US 2020-03-27 22:14:55 46.90022523 -117.52417630000001 5 0 0 0 Whitman, Washington, US
3075 3075 18183 Whitley Indiana US 2020-03-27 22:14:55 41.13863784 -85.50791236 0 0 0 0 Whitley, Indiana, US
3076 3076 21235 Whitley Kentucky US 2020-03-27 22:14:55 36.75700531 -84.14541217 0 0 0 0 Whitley, Kentucky, US
3074 3074 13313 Whitfield Georgia US 2020-03-27 22:14:55 34.80987459 -84.96093476 6 0 0 0 Whitfield, Georgia, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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