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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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