05-06-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,218 rows sorted by Combined_Key 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 ▲
3218 3218       Zimbabwe 2020-05-07 02:32:28 -19.015438 29.154857 34 4 5 25 Zimbabwe
2944 2944 46137 Ziebach South Dakota US 2020-05-07 02:32:28 44.97881876 -101.6654622 1 0 0 1 Ziebach, South Dakota, US
3035 3035     Zhejiang China 2020-05-07 02:32:28 29.1832 120.0934 1268 1 1267 0 Zhejiang, China
2943 2943 48507 Zavala Texas US 2020-05-07 02:32:28 28.86617238 -99.76050829 1 0 0 1 Zavala, Texas, US
2942 2942 48505 Zapata Texas US 2020-05-07 02:32:28 27.00156391 -99.16987152 7 0 0 7 Zapata, Texas, US
3217 3217       Zambia 2020-05-07 02:32:28 -13.133897 27.849332 146 4 101 41 Zambia
3034 3034     Yunnan China 2020-05-07 02:32:28 24.974 101.48700000000001 185 2 181 2 Yunnan, China
2941 2941 8125 Yuma Colorado US 2020-05-07 02:32:28 40.00346839 -102.4258673 9 0 0 9 Yuma, Colorado, US
2940 2940 4027 Yuma Arizona US 2020-05-07 02:32:28 32.76895712 -113.90666740000002 134 1 0 133 Yuma, Arizona, US
2939 2939 2290 Yukon-Koyukuk Alaska US 2020-05-07 02:32:28 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
3033 3033     Yukon Canada 2020-05-07 02:32:28 64.2823 -135.0 11 0 0 11 Yukon, Canada
2938 2938 6115 Yuba California US 2020-05-07 02:32:28 39.26255932 -121.35356440000001 19 1 0 18 Yuba, California, US
2937 2937 48503 Young Texas US 2020-05-07 02:32:28 33.17659707 -98.68790885 4 1 0 3 Young, Texas, US
2936 2936 51199 York Virginia US 2020-05-07 02:32:28 37.24374789 -76.54412815 48 1 0 47 York, Virginia, US
2935 2935 45091 York South Carolina US 2020-05-07 02:32:28 34.97281497 -81.18085944 222 5 0 217 York, South Carolina, US
2934 2934 42133 York Pennsylvania US 2020-05-07 02:32:28 39.9210089 -76.73040131 722 11 0 711 York, Pennsylvania, US
2933 2933 31185 York Nebraska US 2020-05-07 02:32:28 40.87272618 -97.59710186 15 0 0 15 York, Nebraska, US
2932 2932 23031 York Maine US 2020-05-07 02:32:28 43.47808377 -70.71052375 230 8 0 222 York, Maine, US
2931 2931 6113 Yolo California US 2020-05-07 02:32:28 38.68278902 -121.90182879999999 172 20 0 152 Yolo, California, US
2930 2930 48501 Yoakum Texas US 2020-05-07 02:32:28 33.17320212 -102.82764329999999 2 0 0 2 Yoakum, Texas, US
3216 3216       Yemen 2020-05-07 02:32:28 15.552726999999999 48.516388 25 5 1 19 Yemen
2929 2929 30111 Yellowstone Montana US 2020-05-07 02:32:28 45.93955949 -108.26914860000001 83 2 0 81 Yellowstone, Montana, US
2928 2928 27173 Yellow Medicine Minnesota US 2020-05-07 02:32:28 44.71710183 -95.86842453 3 0 0 3 Yellow Medicine, Minnesota, US
2927 2927 5149 Yell Arkansas US 2020-05-07 02:32:28 35.00292371 -93.41171338 7 1 0 6 Yell, Arkansas, US
2926 2926 28163 Yazoo Mississippi US 2020-05-07 02:32:28 32.77890365 -90.39656148 155 2 0 153 Yazoo, Mississippi, US
2925 2925 4025 Yavapai Arizona US 2020-05-07 02:32:28 34.59933926 -112.5538588 140 3 0 137 Yavapai, Arizona, US
2924 2924 36123 Yates New York US 2020-05-07 02:32:28 42.63505484 -77.10369919 19 1 0 18 Yates, New York, US
2923 2923 46135 Yankton South Dakota US 2020-05-07 02:32:28 43.00924485 -97.39467635 29 0 0 29 Yankton, South Dakota, US
2922 2922 37199 Yancey North Carolina US 2020-05-07 02:32:28 35.90079156 -82.31237181 1 0 0 1 Yancey, North Carolina, US
2921 2921 41071 Yamhill Oregon US 2020-05-07 02:32:28 45.23330449 -123.3086963 42 7 0 35 Yamhill, Oregon, US
2920 2920 28161 Yalobusha Mississippi US 2020-05-07 02:32:28 34.02824175 -89.70762049999998 23 0 0 23 Yalobusha, Mississippi, US
2919 2919 53077 Yakima Washington US 2020-05-07 02:32:28 46.45738486 -120.73801259999999 1449 58 0 1397 Yakima, Washington, US
2918 2918 37197 Yadkin North Carolina US 2020-05-07 02:32:28 36.16222629 -80.66239436 27 1 0 26 Yadkin, North Carolina, US
3032 3032     Xinjiang China 2020-05-07 02:32:28 41.1129 85.2401 76 3 73 0 Xinjiang, China
2917 2917 51197 Wythe Virginia US 2020-05-07 02:32:28 36.91582035 -81.07834059 12 1 0 11 Wythe, Virginia, US
2916 2916 54109 Wyoming West Virginia US 2020-05-07 02:32:28 37.612327 -81.54511071 1 0 0 1 Wyoming, West Virginia, US
2915 2915 42131 Wyoming Pennsylvania US 2020-05-07 02:32:28 41.51955538 -76.01074915 27 2 0 25 Wyoming, Pennsylvania, US
2914 2914 36121 Wyoming New York US 2020-05-07 02:32:28 42.70145109 -78.22199579 70 5 0 65 Wyoming, New York, US
2913 2913 20209 Wyandotte Kansas US 2020-05-07 02:32:28 39.11727348 -94.76378225 910 64 0 846 Wyandotte, Kansas, US
2912 2912 39175 Wyandot Ohio US 2020-05-07 02:32:28 40.84339621 -83.30734173 24 2 0 22 Wyandot, Ohio, US
2911 2911 29229 Wright Missouri US 2020-05-07 02:32:28 37.27029221 -92.46914488 10 0 0 10 Wright, Missouri, US
2910 2910 27171 Wright Minnesota US 2020-05-07 02:32:28 45.17297924 -93.96234781 69 1 0 68 Wright, Minnesota, US
2909 2909 19197 Wright Iowa US 2020-05-07 02:32:28 42.73305373 -93.73515113 5 0 0 5 Wright, Iowa, US
2908 2908 29227 Worth Missouri US 2020-05-07 02:32:28 40.47945588 -94.42328751 1 0 0 1 Worth, Missouri, US
2907 2907 19195 Worth Iowa US 2020-05-07 02:32:28 43.37750768 -93.26087602 1 0 0 1 Worth, Iowa, US
2906 2906 13321 Worth Georgia US 2020-05-07 02:32:28 31.55162306 -83.85090513 175 12 0 163 Worth, Georgia, US
2905 2905 25027 Worcester Massachusetts US 2020-05-07 02:32:28 42.35026951 -71.90493363 6992 365 0 6627 Worcester, Massachusetts, US
2904 2904 24047 Worcester Maryland US 2020-05-07 02:32:28 38.21274277 -75.33200012 86 3 0 83 Worcester, Maryland, US
2903 2903 40153 Woodward Oklahoma US 2020-05-07 02:32:28 36.42316318 -99.26283045 1 0 0 1 Woodward, Oklahoma, US
2902 2902 20207 Woodson Kansas US 2020-05-07 02:32:28 37.8865336 -95.74006277 6 0 0 6 Woodson, Kansas, US
2901 2901 40151 Woods Oklahoma US 2020-05-07 02:32:28 36.76705782 -98.86573064 3 0 0 3 Woods, Oklahoma, US
2900 2900 5147 Woodruff Arkansas US 2020-05-07 02:32:28 35.18902527 -91.2439489 1 0 0 1 Woodruff, Arkansas, US
2899 2899 21239 Woodford Kentucky US 2020-05-07 02:32:28 38.04178222 -84.7417556 17 0 0 17 Woodford, Kentucky, US
2898 2898 17203 Woodford Illinois US 2020-05-07 02:32:28 40.78579374 -89.20973757 15 1 0 14 Woodford, Illinois, US
2897 2897 19193 Woodbury Iowa US 2020-05-07 02:32:28 42.38979414 -96.0459439 1323 4 0 1319 Woodbury, Iowa, US
2896 2896 55141 Wood Wisconsin US 2020-05-07 02:32:28 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2895 2895 54107 Wood West Virginia US 2020-05-07 02:32:28 39.20967886 -81.5162836 42 2 0 40 Wood, West Virginia, US
2894 2894 48499 Wood Texas US 2020-05-07 02:32:28 32.78722382 -95.38236368 11 0 0 11 Wood, Texas, US
2893 2893 39173 Wood Ohio US 2020-05-07 02:32:28 41.36224827 -83.62285108 210 32 0 183 Wood, Ohio, US
2892 2892 51195 Wise Virginia US 2020-05-07 02:32:28 36.9746148 -82.62410519 22 1 0 21 Wise, Virginia, US
2891 2891 48497 Wise Texas US 2020-05-07 02:32:28 33.21570665 -97.65460265 28 2 0 26 Wise, Texas, US
2890 2890 54105 Wirt West Virginia US 2020-05-07 02:32:28 39.02775007 -81.37473928 3 0 0 3 Wirt, West Virginia, US
2889 2889 28159 Winston Mississippi US 2020-05-07 02:32:28 33.08747908 -89.03391385 53 0 0 53 Winston, Mississippi, US
2888 2888 1133 Winston Alabama US 2020-05-07 02:32:28 34.15030532 -87.37325922 16 0 0 17 Winston, Alabama, US
2887 2887 27169 Winona Minnesota US 2020-05-07 02:32:28 43.98772283 -91.78081305 68 15 0 53 Winona, Minnesota, US
2886 2886 19191 Winneshiek Iowa US 2020-05-07 02:32:28 43.29094334 -91.84422722 18 0 0 18 Winneshiek, Iowa, US
2885 2885 55139 Winnebago Wisconsin US 2020-05-07 02:32:28 44.06886922 -88.64477096 85 1 0 84 Winnebago, Wisconsin, US
2884 2884 19189 Winnebago Iowa US 2020-05-07 02:32:28 43.37751174 -93.73407298 3 0 0 3 Winnebago, Iowa, US
2883 2883 17201 Winnebago Illinois US 2020-05-07 02:32:28 42.33641854 -89.16085327 696 20 0 676 Winnebago, Illinois, US
2882 2882 22127 Winn Louisiana US 2020-05-07 02:32:28 31.94449367 -92.63789413 47 2 0 45 Winn, Louisiana, US
2881 2881 48495 Winkler Texas US 2020-05-07 02:32:28 31.85008651 -103.04851629999999 3 0 0 3 Winkler, Texas, US
2880 2880 50027 Windsor Vermont US 2020-05-07 02:32:28 43.58010937 -72.58595157 44 2 0 42 Windsor, Vermont, US
2879 2879 50025 Windham Vermont US 2020-05-07 02:32:28 42.986982 -72.71268875 73 3 0 70 Windham, Vermont, US
2878 2878 9015 Windham Connecticut US 2020-05-07 02:32:28 41.82972709 -71.98182316 242 4 0 238 Windham, Connecticut, US
2877 2877 51840 Winchester Virginia US 2020-05-07 02:32:28 39.17054517 -78.17325058 56 0 0 56 Winchester, Virginia, US
2876 2876 48493 Wilson Texas US 2020-05-07 02:32:28 29.1732598 -98.08693082 34 4 0 30 Wilson, Texas, US
2875 2875 47189 Wilson Tennessee US 2020-05-07 02:32:28 36.15496772 -86.29775884 287 7 0 280 Wilson, Tennessee, US
2874 2874 37195 Wilson North Carolina US 2020-05-07 02:32:28 35.70625477 -77.917978 192 8 0 184 Wilson, North Carolina, US
2873 2873 20205 Wilson Kansas US 2020-05-07 02:32:28 37.55937174 -95.74323255 1 0 0 1 Wilson, Kansas, US
2872 2872 48491 Williamson Texas US 2020-05-07 02:32:28 30.64655664 -97.60048540000001 341 12 0 329 Williamson, Texas, US
2871 2871 47187 Williamson Tennessee US 2020-05-07 02:32:28 35.89099229 -86.89281867 436 10 0 426 Williamson, Tennessee, US
2870 2870 17199 Williamson Illinois US 2020-05-07 02:32:28 37.73033511 -88.92994027 40 0 0 40 Williamson, Illinois, US
2869 2869 51830 Williamsburg Virginia US 2020-05-07 02:32:28 37.28131268 -76.70905141 27 2 0 25 Williamsburg, Virginia, US
2868 2868 45089 Williamsburg South Carolina US 2020-05-07 02:32:28 33.62190129 -79.72767442 100 4 0 96 Williamsburg, South Carolina, US
2867 2867 39171 Williams Ohio US 2020-05-07 02:32:28 41.56052014 -84.58429552 42 1 0 41 Williams, Ohio, US
2866 2866 38105 Williams North Dakota US 2020-05-07 02:32:28 48.34522353 -103.4793387 13 0 0 13 Williams, North Dakota, US
2865 2865 48489 Willacy Texas US 2020-05-07 02:32:28 26.47411727 -97.61535848 13 1 0 12 Willacy, Texas, US
2864 2864 17197 Will Illinois US 2020-05-07 02:32:28 41.44619267 -87.97862712 3332 189 0 3143 Will, Illinois, US
2863 2863 28157 Wilkinson Mississippi US 2020-05-07 02:32:28 31.16078225 -91.31018819 72 7 0 65 Wilkinson, Mississippi, US
2862 2862 13319 Wilkinson Georgia US 2020-05-07 02:32:28 32.80291082 -83.17140684 41 2 0 39 Wilkinson, Georgia, US
2861 2861 27167 Wilkin Minnesota US 2020-05-07 02:32:28 46.35721532 -96.4684375 11 3 0 8 Wilkin, Minnesota, US
2860 2860 37193 Wilkes North Carolina US 2020-05-07 02:32:28 36.2084135 -81.16232895 147 1 0 146 Wilkes, North Carolina, US
2859 2859 13317 Wilkes Georgia US 2020-05-07 02:32:28 33.78290391 -82.74286107 26 0 0 26 Wilkes, Georgia, US
2858 2858 13315 Wilcox Georgia US 2020-05-07 02:32:28 31.97496928 -83.43438555 90 12 0 78 Wilcox, Georgia, US
2857 2857 1131 Wilcox Alabama US 2020-05-07 02:32:28 31.98773215 -87.30891118 72 4 0 69 Wilcox, Alabama, US
2856 2856 48487 Wilbarger Texas US 2020-05-07 02:32:28 34.07945812 -99.24178437 2 0 0 2 Wilbarger, Texas, US
2855 2855 24045 Wicomico Maryland US 2020-05-07 02:32:28 38.37301947 -75.62705831 517 11 0 506 Wicomico, Maryland, US
2854 2854 48485 Wichita Texas US 2020-05-07 02:32:28 33.98842886 -98.70410340000001 70 2 0 68 Wichita, Texas, US
2853 2853 53075 Whitman Washington US 2020-05-07 02:32:28 46.90022523 -117.52417630000001 14 0 0 14 Whitman, Washington, US
2852 2852 21235 Whitley Kentucky US 2020-05-07 02:32:28 36.75700531 -84.14541217 11 0 0 11 Whitley, Kentucky, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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