04-22-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,101 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
2831 2831 48507 Zavala Texas US 2020-04-22 23:30:53 28.86617238 -99.76050829 1 0 0 1 Zavala, Texas, US
2830 2830 48505 Zapata Texas US 2020-04-22 23:30:53 27.00156391 -99.16987152 7 0 0 7 Zapata, Texas, US
2828 2828 4027 Yuma Arizona US 2020-04-22 23:30:53 32.76895712 -113.90666740000002 42 1 0 41 Yuma, Arizona, US
2829 2829 8125 Yuma Colorado US 2020-04-22 23:30:53 40.00346839 -102.4258673 4 0 0 4 Yuma, Colorado, US
2827 2827 2290 Yukon-Koyukuk Alaska US 2020-04-22 23:30:53 65.50815459 -151.3907387 1 0 0 1 Yukon-Koyukuk, Alaska, US
2826 2826 6115 Yuba California US 2020-04-22 23:30:53 39.26255932 -121.3535644 16 1 0 15 Yuba, California, US
2825 2825 48503 Young Texas US 2020-04-22 23:30:53 33.17659707 -98.68790885 4 1 0 3 Young, Texas, US
2820 2820 23031 York Maine US 2020-04-22 23:30:53 43.47808377 -70.71052375 185 6 0 179 York, Maine, US
2821 2821 31185 York Nebraska US 2020-04-22 23:30:53 40.87272618 -97.59710186 7 0 0 7 York, Nebraska, US
2822 2822 42133 York Pennsylvania US 2020-04-22 23:30:53 39.9210089 -76.73040131 531 14 0 517 York, Pennsylvania, US
2823 2823 45091 York South Carolina US 2020-04-22 23:30:53 34.97281497 -81.18085944 166 3 0 163 York, South Carolina, US
2824 2824 51199 York Virginia US 2020-04-22 23:30:53 37.24374789 -76.54412815 43 1 0 42 York, Virginia, US
2819 2819 6113 Yolo California US 2020-04-22 23:30:53 38.68278902 -121.9018288 146 10 0 136 Yolo, California, US
2818 2818 48501 Yoakum Texas US 2020-04-22 23:30:53 33.17320212 -102.8276433 1 0 0 1 Yoakum, Texas, US
2817 2817 30111 Yellowstone Montana US 2020-04-22 23:30:53 45.93955949 -108.2691486 74 1 0 73 Yellowstone, Montana, US
2816 2816 27173 Yellow Medicine Minnesota US 2020-04-22 23:30:53 44.71710183 -95.86842453 3 0 0 3 Yellow Medicine, Minnesota, US
2815 2815 5149 Yell Arkansas US 2020-04-22 23:30:53 35.00292371 -93.41171338 2 0 0 2 Yell, Arkansas, US
2814 2814 28163 Yazoo Mississippi US 2020-04-22 23:30:53 32.77890365 -90.39656148 103 1 0 102 Yazoo, Mississippi, US
2813 2813 4025 Yavapai Arizona US 2020-04-22 23:30:53 34.59933926 -112.5538588 73 1 0 72 Yavapai, Arizona, US
2812 2812 36123 Yates New York US 2020-04-22 23:30:53 42.63505484 -77.10369919 11 0 0 11 Yates, New York, US
2811 2811 46135 Yankton South Dakota US 2020-04-22 23:30:53 43.00924485 -97.39467635 23 0 0 23 Yankton, South Dakota, US
2810 2810 41071 Yamhill Oregon US 2020-04-22 23:30:53 45.23330449 -123.3086963 35 6 0 29 Yamhill, Oregon, US
2809 2809 28161 Yalobusha Mississippi US 2020-04-22 23:30:53 34.02824175 -89.70762049999998 17 0 0 17 Yalobusha, Mississippi, US
2808 2808 53077 Yakima Washington US 2020-04-22 23:30:53 46.45738486 -120.7380126 886 41 0 848 Yakima, Washington, US
2807 2807 37197 Yadkin North Carolina US 2020-04-22 23:30:53 36.16222629 -80.66239436 11 1 0 10 Yadkin, North Carolina, US
2806 2806 51197 Wythe Virginia US 2020-04-22 23:30:53 36.91582035 -81.07834059 11 1 0 10 Wythe, Virginia, US
2803 2803 36121 Wyoming New York US 2020-04-22 23:30:53 42.70145109 -78.22199579 44 3 0 41 Wyoming, New York, US
2804 2804 42131 Wyoming Pennsylvania US 2020-04-22 23:30:53 41.51955538 -76.01074915 17 1 0 16 Wyoming, Pennsylvania, US
2805 2805 54109 Wyoming West Virginia US 2020-04-22 23:30:53 37.612327 -81.54511071 1 0 0 1 Wyoming, West Virginia, US
2802 2802 20209 Wyandotte Kansas US 2020-04-22 23:30:53 39.11727348 -94.76378225 473 47 0 426 Wyandotte, Kansas, US
2801 2801 39175 Wyandot Ohio US 2020-04-22 23:30:53 40.84339621 -83.30734173 21 2 0 19 Wyandot, Ohio, US
2798 2798 19197 Wright Iowa US 2020-04-22 23:30:53 42.73305373 -93.73515113 2 0 0 2 Wright, Iowa, US
2799 2799 27171 Wright Minnesota US 2020-04-22 23:30:53 45.17297924 -93.96234781 30 1 0 29 Wright, Minnesota, US
2800 2800 29229 Wright Missouri US 2020-04-22 23:30:53 37.27029221 -92.46914488 9 0 0 9 Wright, Missouri, US
2795 2795 13321 Worth Georgia US 2020-04-22 23:30:53 31.55162306 -83.85090513 142 9 0 133 Worth, Georgia, US
2796 2796 19195 Worth Iowa US 2020-04-22 23:30:53 43.37750768 -93.26087602 1 0 0 1 Worth, Iowa, US
2797 2797 29227 Worth Missouri US 2020-04-22 23:30:53 40.47945588 -94.42328751 1 0 0 1 Worth, Missouri, US
2793 2793 24047 Worcester Maryland US 2020-04-22 23:38:40 38.21274277 -75.33200012 34 0 0 34 Worcester, Maryland, US
2794 2794 25027 Worcester Massachusetts US 2020-04-22 23:30:53 42.35026951 -71.90493363 3456 133 0 3323 Worcester, Massachusetts, US
2792 2792 40153 Woodward Oklahoma US 2020-04-22 23:30:53 36.42316318 -99.26283045 1 0 0 1 Woodward, Oklahoma, US
2791 2791 20207 Woodson Kansas US 2020-04-22 23:30:53 37.8865336 -95.74006277 5 0 0 5 Woodson, Kansas, US
2790 2790 40151 Woods Oklahoma US 2020-04-22 23:30:53 36.76705782 -98.86573064 3 0 0 3 Woods, Oklahoma, US
2789 2789 5147 Woodruff Arkansas US 2020-04-22 23:30:53 35.18902527 -91.2439489 1 0 0 1 Woodruff, Arkansas, US
2787 2787 17203 Woodford Illinois US 2020-04-22 23:30:53 40.78579374 -89.20973757 11 1 0 10 Woodford, Illinois, US
2788 2788 21239 Woodford Kentucky US 2020-04-22 23:30:53 38.04178222 -84.7417556 19 0 0 19 Woodford, Kentucky, US
2786 2786 19193 Woodbury Iowa US 2020-04-22 23:30:53 42.38979414 -96.0459439 100 1 0 99 Woodbury, Iowa, US
2782 2782 39173 Wood Ohio US 2020-04-22 23:30:53 41.36224827 -83.62285108 98 14 0 85 Wood, Ohio, US
2783 2783 48499 Wood Texas US 2020-04-22 23:30:53 32.78722382 -95.38236368 6 0 0 6 Wood, Texas, US
2784 2784 54107 Wood West Virginia US 2020-04-22 23:30:53 39.20967886 -81.5162836 33 0 0 33 Wood, West Virginia, US
2785 2785 55141 Wood Wisconsin US 2020-04-22 23:30:53 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2780 2780 48497 Wise Texas US 2020-04-22 23:30:53 33.21570665 -97.65460265 13 2 0 11 Wise, Texas, US
2781 2781 51195 Wise Virginia US 2020-04-22 23:30:53 36.9746148 -82.62410519 18 1 0 17 Wise, Virginia, US
2779 2779 54105 Wirt West Virginia US 2020-04-22 23:30:53 39.02775007 -81.37473928 2 0 0 2 Wirt, West Virginia, US
2777 2777 1133 Winston Alabama US 2020-04-22 23:30:53 34.15030532 -87.37325922 10 0 0 10 Winston, Alabama, US
2778 2778 28159 Winston Mississippi US 2020-04-22 23:30:53 33.08747908 -89.03391385 36 0 0 36 Winston, Mississippi, US
2776 2776 27169 Winona Minnesota US 2020-04-22 23:30:53 43.98772283 -91.78081305 61 10 0 51 Winona, Minnesota, US
2775 2775 19191 Winneshiek Iowa US 2020-04-22 23:30:53 43.29094334 -91.84422722 8 0 0 8 Winneshiek, Iowa, US
2772 2772 17201 Winnebago Illinois US 2020-04-22 23:30:53 42.33641854 -89.16085327 238 5 0 233 Winnebago, Illinois, US
2773 2773 19189 Winnebago Iowa US 2020-04-22 23:30:53 43.37751174 -93.73407298 2 0 0 2 Winnebago, Iowa, US
2774 2774 55139 Winnebago Wisconsin US 2020-04-22 23:30:53 44.06886922 -88.64477096 43 1 0 42 Winnebago, Wisconsin, US
2771 2771 22127 Winn Louisiana US 2020-04-22 23:30:53 31.94449367 -92.63789413 19 2 0 17 Winn, Louisiana, US
2770 2770 48495 Winkler Texas US 2020-04-22 23:30:53 31.85008651 -103.0485163 3 0 0 3 Winkler, Texas, US
2769 2769 50027 Windsor Vermont US 2020-04-22 23:30:53 43.58010937 -72.58595157 38 2 0 36 Windsor, Vermont, US
2767 2767 9015 Windham Connecticut US 2020-04-22 23:30:53 41.82972709 -71.98182316 122 7 0 115 Windham, Connecticut, US
2768 2768 50025 Windham Vermont US 2020-04-22 23:30:53 42.986982 -72.71268875 67 2 0 65 Windham, Vermont, US
2766 2766 51840 Winchester Virginia US 2020-04-22 23:30:53 39.17054517 -78.17325058 29 0 0 29 Winchester, Virginia, US
2762 2762 20205 Wilson Kansas US 2020-04-22 23:30:53 37.55937174 -95.74323255 1 0 0 1 Wilson, Kansas, US
2763 2763 37195 Wilson North Carolina US 2020-04-22 23:30:53 35.70625477 -77.917978 127 6 0 121 Wilson, North Carolina, US
2764 2764 47189 Wilson Tennessee US 2020-04-22 23:30:53 36.15496772 -86.29775884 187 1 0 186 Wilson, Tennessee, US
2765 2765 48493 Wilson Texas US 2020-04-22 23:30:53 29.1732598 -98.08693082 23 2 0 21 Wilson, Texas, US
2759 2759 17199 Williamson Illinois US 2020-04-22 23:30:53 37.73033511 -88.92994027 17 0 0 17 Williamson, Illinois, US
2760 2760 47187 Williamson Tennessee US 2020-04-22 23:30:53 35.89099229 -86.89281867 359 6 0 353 Williamson, Tennessee, US
2761 2761 48491 Williamson Texas US 2020-04-22 23:30:53 30.64655664 -97.6004854 158 5 0 153 Williamson, Texas, US
2757 2757 45089 Williamsburg South Carolina US 2020-04-22 23:30:53 33.62190129 -79.72767442 27 0 0 27 Williamsburg, South Carolina, US
2758 2758 51830 Williamsburg Virginia US 2020-04-22 23:30:53 37.28131268 -76.70905141 14 1 0 13 Williamsburg, Virginia, US
2755 2755 38105 Williams North Dakota US 2020-04-22 23:30:53 48.34522353 -103.4793387 9 0 0 9 Williams, North Dakota, US
2756 2756 39171 Williams Ohio US 2020-04-22 23:30:53 41.56052014 -84.58429552 16 1 0 15 Williams, Ohio, US
2754 2754 48489 Willacy Texas US 2020-04-22 23:30:53 26.47411727 -97.61535848 10 1 0 9 Willacy, Texas, US
2753 2753 17197 Will Illinois US 2020-04-22 23:30:53 41.44619267 -87.97862712 1820 110 0 1710 Will, Illinois, US
2751 2751 13319 Wilkinson Georgia US 2020-04-22 23:30:53 32.80291082 -83.17140684 22 2 0 20 Wilkinson, Georgia, US
2752 2752 28157 Wilkinson Mississippi US 2020-04-22 23:30:53 31.16078225 -91.31018819 66 6 0 60 Wilkinson, Mississippi, US
2750 2750 27167 Wilkin Minnesota US 2020-04-22 23:30:53 46.35721532 -96.4684375 10 2 0 8 Wilkin, Minnesota, US
2748 2748 13317 Wilkes Georgia US 2020-04-22 23:30:53 33.78290391 -82.74286107 21 0 0 21 Wilkes, Georgia, US
2749 2749 37193 Wilkes North Carolina US 2020-04-22 23:30:53 36.2084135 -81.16232895 5 1 0 4 Wilkes, North Carolina, US
2746 2746 1131 Wilcox Alabama US 2020-04-22 23:30:53 31.98773215 -87.30891118 51 1 0 49 Wilcox, Alabama, US
2747 2747 13315 Wilcox Georgia US 2020-04-22 23:30:53 31.97496928 -83.43438555 51 6 0 45 Wilcox, Georgia, US
2745 2745 48487 Wilbarger Texas US 2020-04-22 23:30:53 34.07945812 -99.24178437 1 0 0 1 Wilbarger, Texas, US
2744 2744 24045 Wicomico Maryland US 2020-04-22 23:38:40 38.37301947 -75.62705831 183 2 0 181 Wicomico, Maryland, US
2743 2743 48485 Wichita Texas US 2020-04-22 23:30:53 33.98842886 -98.7041034 62 2 0 60 Wichita, Texas, US
2742 2742 53075 Whitman Washington US 2020-04-22 23:30:53 46.90022523 -117.5241763 13 0 0 13 Whitman, Washington, US
2740 2740 18183 Whitley Indiana US 2020-04-22 23:30:53 41.13863784 -85.50791236 16 1 0 15 Whitley, Indiana, US
2741 2741 21235 Whitley Kentucky US 2020-04-22 23:30:53 36.75700531 -84.14541217 10 0 0 10 Whitley, Kentucky, US
2739 2739 13313 Whitfield Georgia US 2020-04-22 23:30:53 34.80987459 -84.96093476 53 4 0 49 Whitfield, Georgia, US
2738 2738 17195 Whiteside Illinois US 2020-04-22 23:30:53 41.75509713 -89.91556058 45 3 0 42 Whiteside, Illinois, US
2737 2737 32033 White Pine Nevada US 2020-04-22 23:30:53 39.44157041 -114.899966 3 0 0 3 White Pine, Nevada, US
2732 2732 5145 White Arkansas US 2020-04-22 23:30:53 35.25688493 -91.74908296 29 1 0 28 White, Arkansas, US
2733 2733 13311 White Georgia US 2020-04-22 23:30:53 34.64624278 -83.74905525 33 0 0 33 White, Georgia, US
2734 2734 17193 White Illinois US 2020-04-22 23:30:53 38.08706198 -88.17657461 1 0 0 1 White, Illinois, US
2735 2735 18181 White Indiana US 2020-04-22 23:30:53 40.74911165 -86.86492015 11 0 0 11 White, Indiana, US
2736 2736 47185 White Tennessee US 2020-04-22 23:30:53 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-22-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
);