04-30-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,179 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
2905 2905 48507 Zavala Texas US 2020-05-01 02:32:28 28.86617238 -99.76050829 1 0 0 1 Zavala, Texas, US
2904 2904 48505 Zapata Texas US 2020-05-01 02:32:28 27.00156391 -99.16987152 7 0 0 7 Zapata, Texas, US
2902 2902 4027 Yuma Arizona US 2020-05-01 02:32:28 32.76895712 -113.90666740000002 85 1 0 84 Yuma, Arizona, US
2903 2903 8125 Yuma Colorado US 2020-05-01 02:32:28 40.00346839 -102.4258673 8 0 0 8 Yuma, Colorado, US
2901 2901 2290 Yukon-Koyukuk Alaska US 2020-05-01 02:32:28 65.50815459 -151.39073869999999 1 0 0 1 Yukon-Koyukuk, Alaska, US
2900 2900 6115 Yuba California US 2020-05-01 02:32:28 39.26255932 -121.35356440000001 18 1 0 17 Yuba, California, US
2899 2899 48503 Young Texas US 2020-05-01 02:32:28 33.17659707 -98.68790885 4 1 0 3 Young, Texas, US
2894 2894 23031 York Maine US 2020-05-01 02:32:28 43.47808377 -70.71052375 205 7 0 198 York, Maine, US
2895 2895 31185 York Nebraska US 2020-05-01 02:32:28 40.87272618 -97.59710186 12 0 0 12 York, Nebraska, US
2896 2896 42133 York Pennsylvania US 2020-05-01 02:32:28 39.9210089 -76.73040131 641 9 0 632 York, Pennsylvania, US
2897 2897 45091 York South Carolina US 2020-05-01 02:32:28 34.97281497 -81.18085944 210 3 0 207 York, South Carolina, US
2898 2898 51199 York Virginia US 2020-05-01 02:32:28 37.24374789 -76.54412815 46 1 0 45 York, Virginia, US
2893 2893 6113 Yolo California US 2020-05-01 02:32:28 38.68278902 -121.90182879999999 164 16 0 148 Yolo, California, US
2892 2892 48501 Yoakum Texas US 2020-05-01 02:32:28 33.17320212 -102.82764329999999 1 0 0 1 Yoakum, Texas, US
2891 2891 30111 Yellowstone Montana US 2020-05-01 02:32:28 45.93955949 -108.26914860000001 80 2 0 78 Yellowstone, Montana, US
2890 2890 27173 Yellow Medicine Minnesota US 2020-05-01 02:32:28 44.71710183 -95.86842453 3 0 0 3 Yellow Medicine, Minnesota, US
2889 2889 5149 Yell Arkansas US 2020-05-01 02:32:28 35.00292371 -93.41171338 3 0 0 3 Yell, Arkansas, US
2888 2888 28163 Yazoo Mississippi US 2020-05-01 02:32:28 32.77890365 -90.39656148 135 1 0 134 Yazoo, Mississippi, US
2887 2887 4025 Yavapai Arizona US 2020-05-01 02:32:28 34.59933926 -112.5538588 79 1 0 78 Yavapai, Arizona, US
2886 2886 36123 Yates New York US 2020-05-01 02:32:28 42.63505484 -77.10369919 18 1 0 17 Yates, New York, US
2885 2885 46135 Yankton South Dakota US 2020-05-01 02:32:28 43.00924485 -97.39467635 26 0 0 26 Yankton, South Dakota, US
2884 2884 41071 Yamhill Oregon US 2020-05-01 02:32:28 45.23330449 -123.3086963 39 7 0 32 Yamhill, Oregon, US
2883 2883 28161 Yalobusha Mississippi US 2020-05-01 02:32:28 34.02824175 -89.70762049999998 19 0 0 19 Yalobusha, Mississippi, US
2882 2882 53077 Yakima Washington US 2020-05-01 02:32:28 46.45738486 -120.73801259999999 1128 48 0 1081 Yakima, Washington, US
2881 2881 37197 Yadkin North Carolina US 2020-05-01 02:32:28 36.16222629 -80.66239436 17 1 0 16 Yadkin, North Carolina, US
2880 2880 51197 Wythe Virginia US 2020-05-01 02:32:28 36.91582035 -81.07834059 11 1 0 10 Wythe, Virginia, US
2877 2877 36121 Wyoming New York US 2020-05-01 02:32:28 42.70145109 -78.22199579 67 5 0 62 Wyoming, New York, US
2878 2878 42131 Wyoming Pennsylvania US 2020-05-01 02:32:28 41.51955538 -76.01074915 20 2 0 18 Wyoming, Pennsylvania, US
2879 2879 54109 Wyoming West Virginia US 2020-05-01 02:32:28 37.612327 -81.54511071 1 0 0 1 Wyoming, West Virginia, US
2876 2876 20209 Wyandotte Kansas US 2020-05-01 02:32:28 39.11727348 -94.76378225 677 55 0 622 Wyandotte, Kansas, US
2875 2875 39175 Wyandot Ohio US 2020-05-01 02:32:28 40.84339621 -83.30734173 24 2 0 22 Wyandot, Ohio, US
2872 2872 19197 Wright Iowa US 2020-05-01 02:32:28 42.73305373 -93.73515113 3 0 0 3 Wright, Iowa, US
2873 2873 27171 Wright Minnesota US 2020-05-01 02:32:28 45.17297924 -93.96234781 42 1 0 41 Wright, Minnesota, US
2874 2874 29229 Wright Missouri US 2020-05-01 02:32:28 37.27029221 -92.46914488 10 0 0 10 Wright, Missouri, US
2869 2869 13321 Worth Georgia US 2020-05-01 02:32:28 31.55162306 -83.85090513 153 11 0 142 Worth, Georgia, US
2870 2870 19195 Worth Iowa US 2020-05-01 02:32:28 43.37750768 -93.26087602 1 0 0 1 Worth, Iowa, US
2871 2871 29227 Worth Missouri US 2020-05-01 02:32:28 40.47945588 -94.42328751 1 0 0 1 Worth, Missouri, US
2867 2867 24047 Worcester Maryland US 2020-05-01 02:32:28 38.21274277 -75.33200012 61 2 0 59 Worcester, Maryland, US
2868 2868 25027 Worcester Massachusetts US 2020-05-01 02:32:28 42.35026951 -71.90493363 5550 265 0 5285 Worcester, Massachusetts, US
2866 2866 40153 Woodward Oklahoma US 2020-05-01 02:32:28 36.42316318 -99.26283045 1 0 0 1 Woodward, Oklahoma, US
2865 2865 20207 Woodson Kansas US 2020-05-01 02:32:28 37.8865336 -95.74006277 5 0 0 5 Woodson, Kansas, US
2864 2864 40151 Woods Oklahoma US 2020-05-01 02:32:28 36.76705782 -98.86573064 3 0 0 3 Woods, Oklahoma, US
2863 2863 5147 Woodruff Arkansas US 2020-05-01 02:32:28 35.18902527 -91.2439489 1 0 0 1 Woodruff, Arkansas, US
2861 2861 17203 Woodford Illinois US 2020-05-01 02:32:28 40.78579374 -89.20973757 13 1 0 12 Woodford, Illinois, US
2862 2862 21239 Woodford Kentucky US 2020-05-01 02:32:28 38.04178222 -84.7417556 18 0 0 18 Woodford, Kentucky, US
2860 2860 19193 Woodbury Iowa US 2020-05-01 02:32:28 42.38979414 -96.0459439 742 1 0 741 Woodbury, Iowa, US
2856 2856 39173 Wood Ohio US 2020-05-01 02:32:28 41.36224827 -83.62285108 164 25 0 144 Wood, Ohio, US
2857 2857 48499 Wood Texas US 2020-05-01 02:32:28 32.78722382 -95.38236368 8 0 0 8 Wood, Texas, US
2858 2858 54107 Wood West Virginia US 2020-05-01 02:32:28 39.20967886 -81.5162836 38 2 0 36 Wood, West Virginia, US
2859 2859 55141 Wood Wisconsin US 2020-05-01 02:32:28 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2854 2854 48497 Wise Texas US 2020-05-01 02:32:28 33.21570665 -97.65460265 17 2 0 15 Wise, Texas, US
2855 2855 51195 Wise Virginia US 2020-05-01 02:32:28 36.9746148 -82.62410519 22 1 0 21 Wise, Virginia, US
2853 2853 54105 Wirt West Virginia US 2020-05-01 02:32:28 39.02775007 -81.37473928 3 0 0 3 Wirt, West Virginia, US
2851 2851 1133 Winston Alabama US 2020-05-01 02:32:28 34.15030532 -87.37325922 14 0 0 15 Winston, Alabama, US
2852 2852 28159 Winston Mississippi US 2020-05-01 02:32:28 33.08747908 -89.03391385 42 0 0 42 Winston, Mississippi, US
2850 2850 27169 Winona Minnesota US 2020-05-01 02:32:28 43.98772283 -91.78081305 66 15 0 51 Winona, Minnesota, US
2849 2849 19191 Winneshiek Iowa US 2020-05-01 02:32:28 43.29094334 -91.84422722 15 0 0 15 Winneshiek, Iowa, US
2846 2846 17201 Winnebago Illinois US 2020-05-01 02:32:28 42.33641854 -89.16085327 442 11 0 431 Winnebago, Illinois, US
2847 2847 19189 Winnebago Iowa US 2020-05-01 02:32:28 43.37751174 -93.73407298 2 0 0 2 Winnebago, Iowa, US
2848 2848 55139 Winnebago Wisconsin US 2020-05-01 02:32:28 44.06886922 -88.64477096 53 1 0 52 Winnebago, Wisconsin, US
2845 2845 22127 Winn Louisiana US 2020-05-01 02:32:28 31.94449367 -92.63789413 32 2 0 30 Winn, Louisiana, US
2844 2844 48495 Winkler Texas US 2020-05-01 02:32:28 31.85008651 -103.04851629999999 3 0 0 3 Winkler, Texas, US
2843 2843 50027 Windsor Vermont US 2020-05-01 02:32:28 43.58010937 -72.58595157 40 2 0 38 Windsor, Vermont, US
2841 2841 9015 Windham Connecticut US 2020-05-01 02:32:28 41.82972709 -71.98182316 186 2 0 184 Windham, Connecticut, US
2842 2842 50025 Windham Vermont US 2020-05-01 02:32:28 42.986982 -72.71268875 71 3 0 68 Windham, Vermont, US
2840 2840 51840 Winchester Virginia US 2020-05-01 02:32:28 39.17054517 -78.17325058 37 0 0 37 Winchester, Virginia, US
2836 2836 20205 Wilson Kansas US 2020-05-01 02:32:28 37.55937174 -95.74323255 1 0 0 1 Wilson, Kansas, US
2837 2837 37195 Wilson North Carolina US 2020-05-01 02:32:28 35.70625477 -77.917978 165 7 0 158 Wilson, North Carolina, US
2838 2838 47189 Wilson Tennessee US 2020-05-01 02:32:28 36.15496772 -86.29775884 253 4 0 249 Wilson, Tennessee, US
2839 2839 48493 Wilson Texas US 2020-05-01 02:32:28 29.1732598 -98.08693082 32 3 0 29 Wilson, Texas, US
2833 2833 17199 Williamson Illinois US 2020-05-01 02:32:28 37.73033511 -88.92994027 31 0 0 31 Williamson, Illinois, US
2834 2834 47187 Williamson Tennessee US 2020-05-01 02:32:28 35.89099229 -86.89281867 411 9 0 402 Williamson, Tennessee, US
2835 2835 48491 Williamson Texas US 2020-05-01 02:32:28 30.64655664 -97.60048540000001 301 9 0 292 Williamson, Texas, US
2831 2831 45089 Williamsburg South Carolina US 2020-05-01 02:32:28 33.62190129 -79.72767442 67 0 0 67 Williamsburg, South Carolina, US
2832 2832 51830 Williamsburg Virginia US 2020-05-01 02:32:28 37.28131268 -76.70905141 18 1 0 17 Williamsburg, Virginia, US
2829 2829 38105 Williams North Dakota US 2020-05-01 02:32:28 48.34522353 -103.4793387 10 0 0 10 Williams, North Dakota, US
2830 2830 39171 Williams Ohio US 2020-05-01 02:32:28 41.56052014 -84.58429552 34 1 0 33 Williams, Ohio, US
2828 2828 48489 Willacy Texas US 2020-05-01 02:32:28 26.47411727 -97.61535848 13 1 0 12 Willacy, Texas, US
2827 2827 17197 Will Illinois US 2020-05-01 02:32:28 41.44619267 -87.97862712 2492 151 0 2341 Will, Illinois, US
2825 2825 13319 Wilkinson Georgia US 2020-05-01 02:32:28 32.80291082 -83.17140684 35 2 0 33 Wilkinson, Georgia, US
2826 2826 28157 Wilkinson Mississippi US 2020-05-01 02:32:28 31.16078225 -91.31018819 69 7 0 62 Wilkinson, Mississippi, US
2824 2824 27167 Wilkin Minnesota US 2020-05-01 02:32:28 46.35721532 -96.4684375 12 3 0 9 Wilkin, Minnesota, US
2822 2822 13317 Wilkes Georgia US 2020-05-01 02:32:28 33.78290391 -82.74286107 25 0 0 25 Wilkes, Georgia, US
2823 2823 37193 Wilkes North Carolina US 2020-05-01 02:32:28 36.2084135 -81.16232895 33 1 0 32 Wilkes, North Carolina, US
2820 2820 1131 Wilcox Alabama US 2020-05-01 02:32:28 31.98773215 -87.30891118 65 2 0 64 Wilcox, Alabama, US
2821 2821 13315 Wilcox Georgia US 2020-05-01 02:32:28 31.97496928 -83.43438555 90 9 0 81 Wilcox, Georgia, US
2819 2819 48487 Wilbarger Texas US 2020-05-01 02:32:28 34.07945812 -99.24178437 1 0 0 1 Wilbarger, Texas, US
2818 2818 24045 Wicomico Maryland US 2020-05-01 02:32:28 38.37301947 -75.62705831 406 7 0 399 Wicomico, Maryland, US
2817 2817 48485 Wichita Texas US 2020-05-01 02:32:28 33.98842886 -98.70410340000001 65 2 0 63 Wichita, Texas, US
2816 2816 53075 Whitman Washington US 2020-05-01 02:32:28 46.90022523 -117.52417630000001 14 0 0 14 Whitman, Washington, US
2814 2814 18183 Whitley Indiana US 2020-05-01 02:32:28 41.13863784 -85.50791236 19 1 0 18 Whitley, Indiana, US
2815 2815 21235 Whitley Kentucky US 2020-05-01 02:32:28 36.75700531 -84.14541217 11 0 0 11 Whitley, Kentucky, US
2813 2813 13313 Whitfield Georgia US 2020-05-01 02:32:28 34.80987459 -84.96093476 103 4 0 99 Whitfield, Georgia, US
2812 2812 17195 Whiteside Illinois US 2020-05-01 02:32:28 41.75509713 -89.91556058 84 5 0 79 Whiteside, Illinois, US
2811 2811 32033 White Pine Nevada US 2020-05-01 02:32:28 39.44157041 -114.89996599999999 3 0 0 3 White Pine, Nevada, US
2806 2806 5145 White Arkansas US 2020-05-01 02:32:28 35.25688493 -91.74908296 34 1 0 33 White, Arkansas, US
2807 2807 13311 White Georgia US 2020-05-01 02:32:28 34.64624278 -83.74905525 59 0 0 59 White, Georgia, US
2808 2808 17193 White Illinois US 2020-05-01 02:32:28 38.08706198 -88.17657461 2 0 0 2 White, Illinois, US
2809 2809 18181 White Indiana US 2020-05-01 02:32:28 40.74911165 -86.86492015 47 0 0 47 White, Indiana, US
2810 2810 47185 White Tennessee US 2020-05-01 02:32:28 35.92929884 -85.45591799 7 0 0 7 White, Tennessee, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [04-30-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
);