05-09-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,234 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
2960 2960 46137 Ziebach South Dakota US 2020-05-10 02:32:30 44.97881876 -101.6654622 1 0 0 1 Ziebach, South Dakota, US
2959 2959 48507 Zavala Texas US 2020-05-10 02:32:30 28.86617238 -99.76050829 2 0 0 2 Zavala, Texas, US
2958 2958 48505 Zapata Texas US 2020-05-10 02:32:30 27.00156391 -99.16987152 7 0 0 7 Zapata, Texas, US
2956 2956 4027 Yuma Arizona US 2020-05-10 02:32:30 32.76895712 -113.90666740000002 176 3 0 173 Yuma, Arizona, US
2957 2957 8125 Yuma Colorado US 2020-05-10 02:32:30 40.00346839 -102.4258673 10 0 0 10 Yuma, Colorado, US
2955 2955 2290 Yukon-Koyukuk Alaska US 2020-05-10 02:32:30 65.50815459 -151.3907387 1 0 0 1 Yukon-Koyukuk, Alaska, US
2954 2954 6115 Yuba California US 2020-05-10 02:32:30 39.26255932 -121.3535644 20 1 0 19 Yuba, California, US
2953 2953 48503 Young Texas US 2020-05-10 02:32:30 33.17659707 -98.68790885 4 1 0 3 Young, Texas, US
2948 2948 23031 York Maine US 2020-05-10 02:32:30 43.47808377 -70.71052375 256 8 0 248 York, Maine, US
2949 2949 31185 York Nebraska US 2020-05-10 02:32:30 40.87272618 -97.59710186 17 0 0 17 York, Nebraska, US
2950 2950 42133 York Pennsylvania US 2020-05-10 02:32:30 39.9210089 -76.73040131 767 13 0 754 York, Pennsylvania, US
2951 2951 45091 York South Carolina US 2020-05-10 02:32:30 34.97281497 -81.18085944 237 5 0 232 York, South Carolina, US
2952 2952 51199 York Virginia US 2020-05-10 02:32:30 37.24374789 -76.54412815 55 2 0 53 York, Virginia, US
2947 2947 6113 Yolo California US 2020-05-10 02:32:30 38.68278902 -121.9018288 172 20 0 152 Yolo, California, US
2946 2946 48501 Yoakum Texas US 2020-05-10 02:32:30 33.17320212 -102.8276433 2 0 0 2 Yoakum, Texas, US
2945 2945 30111 Yellowstone Montana US 2020-05-10 02:32:30 45.93955949 -108.2691486 82 2 0 80 Yellowstone, Montana, US
2944 2944 27173 Yellow Medicine Minnesota US 2020-05-10 02:32:30 44.71710183 -95.86842453 3 0 0 3 Yellow Medicine, Minnesota, US
2943 2943 5149 Yell Arkansas US 2020-05-10 02:32:30 35.00292371 -93.41171338 7 1 0 6 Yell, Arkansas, US
2942 2942 28163 Yazoo Mississippi US 2020-05-10 02:32:30 32.77890365 -90.39656148 162 2 0 160 Yazoo, Mississippi, US
2941 2941 4025 Yavapai Arizona US 2020-05-10 02:32:30 34.59933926 -112.5538588 175 4 0 171 Yavapai, Arizona, US
2940 2940 36123 Yates New York US 2020-05-10 02:32:30 42.63505484 -77.10369919 20 1 0 19 Yates, New York, US
2939 2939 46135 Yankton South Dakota US 2020-05-10 02:32:30 43.00924485 -97.39467635 29 0 0 29 Yankton, South Dakota, US
2938 2938 37199 Yancey North Carolina US 2020-05-10 02:32:30 35.90079156 -82.31237181 8 0 0 8 Yancey, North Carolina, US
2937 2937 41071 Yamhill Oregon US 2020-05-10 02:32:30 45.23330449 -123.3086963 47 7 0 40 Yamhill, Oregon, US
2936 2936 28161 Yalobusha Mississippi US 2020-05-10 02:32:30 34.02824175 -89.70762049999998 30 0 0 30 Yalobusha, Mississippi, US
2935 2935 53077 Yakima Washington US 2020-05-10 02:32:30 46.45738486 -120.7380126 1686 64 0 1627 Yakima, Washington, US
2934 2934 37197 Yadkin North Carolina US 2020-05-10 02:32:30 36.16222629 -80.66239436 49 1 0 48 Yadkin, North Carolina, US
2933 2933 51197 Wythe Virginia US 2020-05-10 02:32:30 36.91582035 -81.07834059 13 1 0 12 Wythe, Virginia, US
2930 2930 36121 Wyoming New York US 2020-05-10 02:32:30 42.70145109 -78.22199579 75 5 0 70 Wyoming, New York, US
2931 2931 42131 Wyoming Pennsylvania US 2020-05-10 02:32:30 41.51955538 -76.01074915 30 2 0 28 Wyoming, Pennsylvania, US
2932 2932 54109 Wyoming West Virginia US 2020-05-10 02:32:30 37.612327 -81.54511071 1 0 0 1 Wyoming, West Virginia, US
2929 2929 20209 Wyandotte Kansas US 2020-05-10 02:32:30 39.11727348 -94.76378225 1045 64 0 981 Wyandotte, Kansas, US
2928 2928 39175 Wyandot Ohio US 2020-05-10 02:32:30 40.84339621 -83.30734173 27 2 0 25 Wyandot, Ohio, US
2925 2925 19197 Wright Iowa US 2020-05-10 02:32:30 42.73305373 -93.73515113 6 0 0 6 Wright, Iowa, US
2926 2926 27171 Wright Minnesota US 2020-05-10 02:32:30 45.17297924 -93.96234781 92 1 0 91 Wright, Minnesota, US
2927 2927 29229 Wright Missouri US 2020-05-10 02:32:30 37.27029221 -92.46914488 10 0 0 10 Wright, Missouri, US
2922 2922 13321 Worth Georgia US 2020-05-10 02:32:30 31.55162306 -83.85090513 182 13 0 169 Worth, Georgia, US
2923 2923 19195 Worth Iowa US 2020-05-10 02:32:30 43.37750768 -93.26087602 1 0 0 1 Worth, Iowa, US
2924 2924 29227 Worth Missouri US 2020-05-10 02:32:30 40.47945588 -94.42328751 1 0 0 1 Worth, Missouri, US
2920 2920 24047 Worcester Maryland US 2020-05-10 02:32:30 38.21274277 -75.33200012 102 4 0 98 Worcester, Maryland, US
2921 2921 25027 Worcester Massachusetts US 2020-05-10 02:32:30 42.35026951 -71.90493363 7611 420 0 7191 Worcester, Massachusetts, US
2919 2919 40153 Woodward Oklahoma US 2020-05-10 02:32:30 36.42316318 -99.26283045 1 0 0 1 Woodward, Oklahoma, US
2918 2918 20207 Woodson Kansas US 2020-05-10 02:32:30 37.8865336 -95.74006277 6 0 0 6 Woodson, Kansas, US
2917 2917 40151 Woods Oklahoma US 2020-05-10 02:32:30 36.76705782 -98.86573064 3 0 0 3 Woods, Oklahoma, US
2916 2916 5147 Woodruff Arkansas US 2020-05-10 02:32:30 35.18902527 -91.2439489 1 0 0 1 Woodruff, Arkansas, US
2914 2914 17203 Woodford Illinois US 2020-05-10 02:32:30 40.78579374 -89.20973757 15 1 0 14 Woodford, Illinois, US
2915 2915 21239 Woodford Kentucky US 2020-05-10 02:32:30 38.04178222 -84.7417556 17 0 0 17 Woodford, Kentucky, US
2913 2913 19193 Woodbury Iowa US 2020-05-10 02:32:30 42.38979414 -96.0459439 1554 7 0 1547 Woodbury, Iowa, US
2909 2909 39173 Wood Ohio US 2020-05-10 02:32:30 41.36224827 -83.62285108 222 37 0 193 Wood, Ohio, US
2910 2910 48499 Wood Texas US 2020-05-10 02:32:30 32.78722382 -95.38236368 13 0 0 13 Wood, Texas, US
2911 2911 54107 Wood West Virginia US 2020-05-10 02:32:30 39.20967886 -81.5162836 43 2 0 41 Wood, West Virginia, US
2912 2912 55141 Wood Wisconsin US 2020-05-10 02:32:30 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2907 2907 48497 Wise Texas US 2020-05-10 02:32:30 33.21570665 -97.65460265 30 2 0 28 Wise, Texas, US
2908 2908 51195 Wise Virginia US 2020-05-10 02:32:30 36.9746148 -82.62410519 22 1 0 21 Wise, Virginia, US
2906 2906 54105 Wirt West Virginia US 2020-05-10 02:32:30 39.02775007 -81.37473928 3 0 0 3 Wirt, West Virginia, US
2904 2904 1133 Winston Alabama US 2020-05-10 02:32:30 34.15030532 -87.37325922 18 0 0 20 Winston, Alabama, US
2905 2905 28159 Winston Mississippi US 2020-05-10 02:32:30 33.08747908 -89.03391385 61 0 0 61 Winston, Mississippi, US
2903 2903 27169 Winona Minnesota US 2020-05-10 02:32:30 43.98772283 -91.78081305 70 15 0 55 Winona, Minnesota, US
2902 2902 19191 Winneshiek Iowa US 2020-05-10 02:32:30 43.29094334 -91.84422722 18 0 0 18 Winneshiek, Iowa, US
2899 2899 17201 Winnebago Illinois US 2020-05-10 02:32:30 42.33641854 -89.16085327 877 24 0 853 Winnebago, Illinois, US
2900 2900 19189 Winnebago Iowa US 2020-05-10 02:32:30 43.37751174 -93.73407298 3 0 0 3 Winnebago, Iowa, US
2901 2901 55139 Winnebago Wisconsin US 2020-05-10 02:32:30 44.06886922 -88.64477096 98 1 0 97 Winnebago, Wisconsin, US
2898 2898 22127 Winn Louisiana US 2020-05-10 02:32:30 31.94449367 -92.63789413 51 2 0 49 Winn, Louisiana, US
2897 2897 48495 Winkler Texas US 2020-05-10 02:32:30 31.85008651 -103.0485163 3 0 0 3 Winkler, Texas, US
2896 2896 50027 Windsor Vermont US 2020-05-10 02:32:30 43.58010937 -72.58595157 46 2 0 44 Windsor, Vermont, US
2894 2894 9015 Windham Connecticut US 2020-05-10 02:32:30 41.82972709 -71.98182316 266 6 0 260 Windham, Connecticut, US
2895 2895 50025 Windham Vermont US 2020-05-10 02:32:30 42.986982 -72.71268875 74 3 0 71 Windham, Vermont, US
2893 2893 51840 Winchester Virginia US 2020-05-10 02:32:30 39.17054517 -78.17325058 64 0 0 64 Winchester, Virginia, US
2889 2889 20205 Wilson Kansas US 2020-05-10 02:32:30 37.55937174 -95.74323255 1 0 0 1 Wilson, Kansas, US
2890 2890 37195 Wilson North Carolina US 2020-05-10 02:32:30 35.70625477 -77.917978 203 8 0 195 Wilson, North Carolina, US
2891 2891 47189 Wilson Tennessee US 2020-05-10 02:32:30 36.15496772 -86.29775884 297 6 0 291 Wilson, Tennessee, US
2892 2892 48493 Wilson Texas US 2020-05-10 02:32:30 29.1732598 -98.08693082 34 4 0 30 Wilson, Texas, US
2886 2886 17199 Williamson Illinois US 2020-05-10 02:32:30 37.73033511 -88.92994027 44 1 0 43 Williamson, Illinois, US
2887 2887 47187 Williamson Tennessee US 2020-05-10 02:32:30 35.89099229 -86.89281867 441 10 0 431 Williamson, Tennessee, US
2888 2888 48491 Williamson Texas US 2020-05-10 02:32:30 30.64655664 -97.6004854 368 13 0 355 Williamson, Texas, US
2884 2884 45089 Williamsburg South Carolina US 2020-05-10 02:32:30 33.62190129 -79.72767442 136 7 0 129 Williamsburg, South Carolina, US
2885 2885 51830 Williamsburg Virginia US 2020-05-10 02:32:30 37.28131268 -76.70905141 31 2 0 29 Williamsburg, Virginia, US
2882 2882 38105 Williams North Dakota US 2020-05-10 02:32:30 48.34522353 -103.4793387 18 0 0 18 Williams, North Dakota, US
2883 2883 39171 Williams Ohio US 2020-05-10 02:32:30 41.56052014 -84.58429552 44 1 0 43 Williams, Ohio, US
2881 2881 48489 Willacy Texas US 2020-05-10 02:32:30 26.47411727 -97.61535848 14 1 0 13 Willacy, Texas, US
2880 2880 17197 Will Illinois US 2020-05-10 02:32:30 41.44619267 -87.97862712 3636 202 0 3434 Will, Illinois, US
2878 2878 13319 Wilkinson Georgia US 2020-05-10 02:32:30 32.80291082 -83.17140684 39 2 0 37 Wilkinson, Georgia, US
2879 2879 28157 Wilkinson Mississippi US 2020-05-10 02:32:30 31.16078225 -91.31018819 75 9 0 66 Wilkinson, Mississippi, US
2877 2877 27167 Wilkin Minnesota US 2020-05-10 02:32:30 46.35721532 -96.4684375 11 3 0 8 Wilkin, Minnesota, US
2875 2875 13317 Wilkes Georgia US 2020-05-10 02:32:30 33.78290391 -82.74286107 27 0 0 27 Wilkes, Georgia, US
2876 2876 37193 Wilkes North Carolina US 2020-05-10 02:32:30 36.2084135 -81.16232895 202 1 0 201 Wilkes, North Carolina, US
2873 2873 1131 Wilcox Alabama US 2020-05-10 02:32:30 31.98773215 -87.30891118 78 4 0 76 Wilcox, Alabama, US
2874 2874 13315 Wilcox Georgia US 2020-05-10 02:32:30 31.97496928 -83.43438555 95 12 0 83 Wilcox, Georgia, US
2872 2872 48487 Wilbarger Texas US 2020-05-10 02:32:30 34.07945812 -99.24178437 2 0 0 2 Wilbarger, Texas, US
2871 2871 24045 Wicomico Maryland US 2020-05-10 02:32:30 38.37301947 -75.62705831 558 15 0 543 Wicomico, Maryland, US
2870 2870 48485 Wichita Texas US 2020-05-10 02:32:30 33.98842886 -98.7041034 74 2 0 72 Wichita, Texas, US
2869 2869 53075 Whitman Washington US 2020-05-10 02:32:30 46.90022523 -117.5241763 15 0 0 15 Whitman, Washington, US
2867 2867 18183 Whitley Indiana US 2020-05-10 02:32:30 41.13863784 -85.50791236 22 1 0 21 Whitley, Indiana, US
2868 2868 21235 Whitley Kentucky US 2020-05-10 02:32:30 36.75700531 -84.14541217 11 0 0 11 Whitley, Kentucky, US
2866 2866 13313 Whitfield Georgia US 2020-05-10 02:32:30 34.80987459 -84.96093476 149 6 0 143 Whitfield, Georgia, US
2865 2865 17195 Whiteside Illinois US 2020-05-10 02:32:30 41.75509713 -89.91556058 102 6 0 96 Whiteside, Illinois, US
2864 2864 32033 White Pine Nevada US 2020-05-10 02:32:30 39.44157041 -114.899966 3 0 0 3 White Pine, Nevada, US
2859 2859 5145 White Arkansas US 2020-05-10 02:32:30 35.25688493 -91.74908296 35 1 0 34 White, Arkansas, US
2860 2860 13311 White Georgia US 2020-05-10 02:32:30 34.64624278 -83.74905525 88 1 0 87 White, Georgia, US
2861 2861 17193 White Illinois US 2020-05-10 02:32:30 38.08706198 -88.17657461 2 0 0 2 White, Illinois, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [05-09-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
);