04-26-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,142 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
2874 2874 48507 Zavala Texas US 2020-04-27 02:30:52 28.86617238 -99.76050829 1 0 0 1 Zavala, Texas, US
2873 2873 48505 Zapata Texas US 2020-04-27 02:30:52 27.00156391 -99.16987152 7 0 0 7 Zapata, Texas, US
2871 2871 4027 Yuma Arizona US 2020-04-27 02:30:52 32.76895712 -113.90666740000002 59 1 0 58 Yuma, Arizona, US
2872 2872 8125 Yuma Colorado US 2020-04-27 02:30:52 40.00346839 -102.4258673 6 0 0 6 Yuma, Colorado, US
2870 2870 2290 Yukon-Koyukuk Alaska US 2020-04-27 02:30:52 65.50815459 -151.3907387 1 0 0 1 Yukon-Koyukuk, Alaska, US
2869 2869 6115 Yuba California US 2020-04-27 02:30:52 39.26255932 -121.3535644 16 1 0 15 Yuba, California, US
2868 2868 48503 Young Texas US 2020-04-27 02:30:52 33.17659707 -98.68790885 4 1 0 3 Young, Texas, US
2863 2863 23031 York Maine US 2020-04-27 02:30:52 43.47808377 -70.71052375 196 7 0 189 York, Maine, US
2864 2864 31185 York Nebraska US 2020-04-27 02:30:52 40.87272618 -97.59710186 10 0 0 10 York, Nebraska, US
2865 2865 42133 York Pennsylvania US 2020-04-27 02:30:52 39.9210089 -76.73040131 593 8 0 585 York, Pennsylvania, US
2866 2866 45091 York South Carolina US 2020-04-27 02:30:52 34.97281497 -81.18085944 181 3 0 178 York, South Carolina, US
2867 2867 51199 York Virginia US 2020-04-27 02:30:52 37.24374789 -76.54412815 44 1 0 43 York, Virginia, US
2862 2862 6113 Yolo California US 2020-04-27 02:30:52 38.68278902 -121.9018288 161 13 0 148 Yolo, California, US
2861 2861 48501 Yoakum Texas US 2020-04-27 02:30:52 33.17320212 -102.8276433 1 0 0 1 Yoakum, Texas, US
2860 2860 30111 Yellowstone Montana US 2020-04-27 02:30:52 45.93955949 -108.2691486 78 1 0 77 Yellowstone, Montana, US
2859 2859 27173 Yellow Medicine Minnesota US 2020-04-27 02:30:52 44.71710183 -95.86842453 3 0 0 3 Yellow Medicine, Minnesota, US
2858 2858 5149 Yell Arkansas US 2020-04-27 02:30:52 35.00292371 -93.41171338 3 0 0 3 Yell, Arkansas, US
2857 2857 28163 Yazoo Mississippi US 2020-04-27 02:30:52 32.77890365 -90.39656148 122 1 0 121 Yazoo, Mississippi, US
2856 2856 4025 Yavapai Arizona US 2020-04-27 02:30:52 34.59933926 -112.5538588 76 1 0 75 Yavapai, Arizona, US
2855 2855 36123 Yates New York US 2020-04-25 00:00:00 42.63505484 -77.10369919 17 1 0 16 Yates, New York, US
2854 2854 46135 Yankton South Dakota US 2020-04-27 02:30:52 43.00924485 -97.39467635 26 0 0 26 Yankton, South Dakota, US
2853 2853 41071 Yamhill Oregon US 2020-04-27 02:30:52 45.23330449 -123.3086963 36 6 0 30 Yamhill, Oregon, US
2852 2852 28161 Yalobusha Mississippi US 2020-04-27 02:30:52 34.02824175 -89.70762049999998 18 0 0 18 Yalobusha, Mississippi, US
2851 2851 53077 Yakima Washington US 2020-04-26 00:00:00 46.45738486 -120.7380126 1015 45 0 971 Yakima, Washington, US
2850 2850 37197 Yadkin North Carolina US 2020-04-27 02:30:52 36.16222629 -80.66239436 12 1 0 11 Yadkin, North Carolina, US
2849 2849 51197 Wythe Virginia US 2020-04-27 02:30:52 36.91582035 -81.07834059 11 1 0 10 Wythe, Virginia, US
2846 2846 36121 Wyoming New York US 2020-04-25 00:00:00 42.70145109 -78.22199579 59 5 0 54 Wyoming, New York, US
2847 2847 42131 Wyoming Pennsylvania US 2020-04-27 02:30:52 41.51955538 -76.01074915 17 2 0 15 Wyoming, Pennsylvania, US
2848 2848 54109 Wyoming West Virginia US 2020-04-27 02:30:52 37.612327 -81.54511071 1 0 0 1 Wyoming, West Virginia, US
2845 2845 20209 Wyandotte Kansas US 2020-04-27 02:30:52 39.11727348 -94.76378225 565 51 0 514 Wyandotte, Kansas, US
2844 2844 39175 Wyandot Ohio US 2020-04-27 02:30:52 40.84339621 -83.30734173 24 2 0 22 Wyandot, Ohio, US
2841 2841 19197 Wright Iowa US 2020-04-27 02:30:52 42.73305373 -93.73515113 2 0 0 2 Wright, Iowa, US
2842 2842 27171 Wright Minnesota US 2020-04-27 02:30:52 45.17297924 -93.96234781 33 1 0 32 Wright, Minnesota, US
2843 2843 29229 Wright Missouri US 2020-04-27 02:30:52 37.27029221 -92.46914488 9 0 0 9 Wright, Missouri, US
2838 2838 13321 Worth Georgia US 2020-04-27 02:30:52 31.55162306 -83.85090513 141 9 0 132 Worth, Georgia, US
2839 2839 19195 Worth Iowa US 2020-04-27 02:30:52 43.37750768 -93.26087602 1 0 0 1 Worth, Iowa, US
2840 2840 29227 Worth Missouri US 2020-04-27 02:30:52 40.47945588 -94.42328751 1 0 0 1 Worth, Missouri, US
2836 2836 24047 Worcester Maryland US 2020-04-27 02:31:05 38.21274277 -75.33200012 48 0 0 48 Worcester, Maryland, US
2837 2837 25027 Worcester Massachusetts US 2020-04-27 02:30:52 42.35026951 -71.90493363 4572 183 0 4389 Worcester, Massachusetts, US
2835 2835 40153 Woodward Oklahoma US 2020-04-27 02:30:52 36.42316318 -99.26283045 1 0 0 1 Woodward, Oklahoma, US
2834 2834 20207 Woodson Kansas US 2020-04-27 02:30:52 37.8865336 -95.74006277 5 0 0 5 Woodson, Kansas, US
2833 2833 40151 Woods Oklahoma US 2020-04-27 02:30:52 36.76705782 -98.86573064 3 0 0 3 Woods, Oklahoma, US
2832 2832 5147 Woodruff Arkansas US 2020-04-27 02:30:52 35.18902527 -91.2439489 1 0 0 1 Woodruff, Arkansas, US
2830 2830 17203 Woodford Illinois US 2020-04-27 02:30:52 40.78579374 -89.20973757 11 1 0 10 Woodford, Illinois, US
2831 2831 21239 Woodford Kentucky US 2020-04-27 02:30:52 38.04178222 -84.7417556 19 0 0 19 Woodford, Kentucky, US
2829 2829 19193 Woodbury Iowa US 2020-04-27 02:30:52 42.38979414 -96.0459439 409 1 0 408 Woodbury, Iowa, US
2825 2825 39173 Wood Ohio US 2020-04-27 02:30:52 41.36224827 -83.62285108 133 19 0 116 Wood, Ohio, US
2826 2826 48499 Wood Texas US 2020-04-27 02:30:52 32.78722382 -95.38236368 7 0 0 7 Wood, Texas, US
2827 2827 54107 Wood West Virginia US 2020-04-27 02:30:52 39.20967886 -81.5162836 36 2 0 34 Wood, West Virginia, US
2828 2828 55141 Wood Wisconsin US 2020-04-27 02:30:52 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2823 2823 48497 Wise Texas US 2020-04-27 02:30:52 33.21570665 -97.65460265 15 2 0 13 Wise, Texas, US
2824 2824 51195 Wise Virginia US 2020-04-27 02:30:52 36.9746148 -82.62410519 20 1 0 19 Wise, Virginia, US
2822 2822 54105 Wirt West Virginia US 2020-04-27 02:30:52 39.02775007 -81.37473928 3 0 0 3 Wirt, West Virginia, US
2820 2820 1133 Winston Alabama US 2020-04-27 02:30:52 34.15030532 -87.37325922 10 0 0 11 Winston, Alabama, US
2821 2821 28159 Winston Mississippi US 2020-04-27 02:30:52 33.08747908 -89.03391385 38 0 0 38 Winston, Mississippi, US
2819 2819 27169 Winona Minnesota US 2020-04-27 02:30:52 43.98772283 -91.78081305 66 13 0 53 Winona, Minnesota, US
2818 2818 19191 Winneshiek Iowa US 2020-04-27 02:30:52 43.29094334 -91.84422722 24 0 0 24 Winneshiek, Iowa, US
2815 2815 17201 Winnebago Illinois US 2020-04-27 02:30:52 42.33641854 -89.16085327 318 8 0 310 Winnebago, Illinois, US
2816 2816 19189 Winnebago Iowa US 2020-04-27 02:30:52 43.37751174 -93.73407298 2 0 0 2 Winnebago, Iowa, US
2817 2817 55139 Winnebago Wisconsin US 2020-04-27 02:30:52 44.06886922 -88.64477096 48 1 0 47 Winnebago, Wisconsin, US
2814 2814 22127 Winn Louisiana US 2020-04-27 02:30:52 31.94449367 -92.63789413 20 2 0 18 Winn, Louisiana, US
2813 2813 48495 Winkler Texas US 2020-04-27 02:30:52 31.85008651 -103.0485163 3 0 0 3 Winkler, Texas, US
2812 2812 50027 Windsor Vermont US 2020-04-27 02:30:52 43.58010937 -72.58595157 39 2 0 37 Windsor, Vermont, US
2810 2810 9015 Windham Connecticut US 2020-04-27 02:30:52 41.82972709 -71.98182316 157 3 0 154 Windham, Connecticut, US
2811 2811 50025 Windham Vermont US 2020-04-27 02:30:52 42.986982 -72.71268875 69 2 0 67 Windham, Vermont, US
2809 2809 51840 Winchester Virginia US 2020-04-27 02:30:52 39.17054517 -78.17325058 33 0 0 33 Winchester, Virginia, US
2805 2805 20205 Wilson Kansas US 2020-04-27 02:30:52 37.55937174 -95.74323255 1 0 0 1 Wilson, Kansas, US
2806 2806 37195 Wilson North Carolina US 2020-04-27 02:30:52 35.70625477 -77.917978 151 6 0 145 Wilson, North Carolina, US
2807 2807 47189 Wilson Tennessee US 2020-04-27 02:30:52 36.15496772 -86.29775884 233 3 0 230 Wilson, Tennessee, US
2808 2808 48493 Wilson Texas US 2020-04-27 02:30:52 29.1732598 -98.08693082 29 2 0 27 Wilson, Texas, US
2802 2802 17199 Williamson Illinois US 2020-04-27 02:30:52 37.73033511 -88.92994027 25 0 0 25 Williamson, Illinois, US
2803 2803 47187 Williamson Tennessee US 2020-04-27 02:30:52 35.89099229 -86.89281867 397 7 0 390 Williamson, Tennessee, US
2804 2804 48491 Williamson Texas US 2020-04-27 02:30:52 30.64655664 -97.6004854 211 6 0 205 Williamson, Texas, US
2800 2800 45089 Williamsburg South Carolina US 2020-04-27 02:30:52 33.62190129 -79.72767442 56 0 0 56 Williamsburg, South Carolina, US
2801 2801 51830 Williamsburg Virginia US 2020-04-27 02:30:52 37.28131268 -76.70905141 15 1 0 14 Williamsburg, Virginia, US
2798 2798 38105 Williams North Dakota US 2020-04-27 02:30:52 48.34522353 -103.4793387 10 0 0 10 Williams, North Dakota, US
2799 2799 39171 Williams Ohio US 2020-04-27 02:30:52 41.56052014 -84.58429552 29 1 0 28 Williams, Ohio, US
2797 2797 48489 Willacy Texas US 2020-04-27 02:30:52 26.47411727 -97.61535848 13 1 0 12 Willacy, Texas, US
2796 2796 17197 Will Illinois US 2020-04-27 02:30:52 41.44619267 -87.97862712 2126 133 0 1993 Will, Illinois, US
2794 2794 13319 Wilkinson Georgia US 2020-04-27 02:30:52 32.80291082 -83.17140684 31 2 0 29 Wilkinson, Georgia, US
2795 2795 28157 Wilkinson Mississippi US 2020-04-27 02:30:52 31.16078225 -91.31018819 68 7 0 61 Wilkinson, Mississippi, US
2793 2793 27167 Wilkin Minnesota US 2020-04-27 02:30:52 46.35721532 -96.4684375 11 3 0 8 Wilkin, Minnesota, US
2791 2791 13317 Wilkes Georgia US 2020-04-27 02:30:52 33.78290391 -82.74286107 23 0 0 23 Wilkes, Georgia, US
2792 2792 37193 Wilkes North Carolina US 2020-04-27 02:30:52 36.2084135 -81.16232895 21 1 0 20 Wilkes, North Carolina, US
2789 2789 1131 Wilcox Alabama US 2020-04-27 02:30:52 31.98773215 -87.30891118 56 1 0 55 Wilcox, Alabama, US
2790 2790 13315 Wilcox Georgia US 2020-04-27 02:30:52 31.97496928 -83.43438555 68 6 0 62 Wilcox, Georgia, US
2788 2788 48487 Wilbarger Texas US 2020-04-27 02:30:52 34.07945812 -99.24178437 1 0 0 1 Wilbarger, Texas, US
2787 2787 24045 Wicomico Maryland US 2020-04-27 02:31:05 38.37301947 -75.62705831 270 4 0 266 Wicomico, Maryland, US
2786 2786 48485 Wichita Texas US 2020-04-27 02:30:52 33.98842886 -98.7041034 62 2 0 60 Wichita, Texas, US
2785 2785 53075 Whitman Washington US 2020-04-26 00:00:00 46.90022523 -117.5241763 14 0 0 14 Whitman, Washington, US
2783 2783 18183 Whitley Indiana US 2020-04-27 02:30:52 41.13863784 -85.50791236 16 1 0 15 Whitley, Indiana, US
2784 2784 21235 Whitley Kentucky US 2020-04-27 02:30:52 36.75700531 -84.14541217 11 0 0 11 Whitley, Kentucky, US
2782 2782 13313 Whitfield Georgia US 2020-04-27 02:30:52 34.80987459 -84.96093476 63 4 0 59 Whitfield, Georgia, US
2781 2781 17195 Whiteside Illinois US 2020-04-27 02:30:52 41.75509713 -89.91556058 62 5 0 57 Whiteside, Illinois, US
2780 2780 32033 White Pine Nevada US 2020-04-27 02:30:52 39.44157041 -114.899966 3 0 0 3 White Pine, Nevada, US
2775 2775 5145 White Arkansas US 2020-04-27 02:30:52 35.25688493 -91.74908296 31 1 0 30 White, Arkansas, US
2776 2776 13311 White Georgia US 2020-04-27 02:30:52 34.64624278 -83.74905525 38 0 0 38 White, Georgia, US
2777 2777 17193 White Illinois US 2020-04-27 02:30:52 38.08706198 -88.17657461 1 0 0 1 White, Illinois, US
2778 2778 18181 White Indiana US 2020-04-27 02:30:52 40.74911165 -86.86492015 26 0 0 26 White, Indiana, US
2779 2779 47185 White Tennessee US 2020-04-27 02:30:52 35.92929884 -85.45591799 4 0 0 4 White, Tennessee, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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