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,424 rows sorted by Combined_Key descending

View and edit SQL

Suggested facets: Last_Update (date)

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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