03-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,420 rows sorted by Combined_Key descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key ▲
3387 3387       Zimbabwe 3/22/20 23:45 -19.015438 29.154857 3 0 0 3 Zimbabwe
2690 2690 46137 Ziebach South Dakota US 3/22/20 23:45 44.97881876 -101.6654622 0 0 0 0 Ziebach, South Dakota, US
3218 3218     Zhejiang China 3/22/20 7:20 29.1832 120.0934 1237 1 1219 17 Zhejiang, China
2939 2939 48507 Zavala Texas US 3/22/20 23:45 28.86617238 -99.76050829 0 0 0 0 Zavala, Texas, US
2938 2938 48505 Zapata Texas US 3/22/20 23:45 27.00156391 -99.16987152 0 0 0 0 Zapata, Texas, US
3386 3386       Zambia 3/22/20 23:45 -13.133897 27.849332 3 0 0 3 Zambia
3224 3224     Yunnan China 3/16/20 23:37 24.974 101.487 176 2 172 2 Yunnan, China
445 445 8125 Yuma Colorado US 3/22/20 23:45 40.00346839 -102.4258673 1 0 0 0 Yuma, Colorado, US
949 949 4027 Yuma Arizona US 3/22/20 23:45 32.76895712 -113.9066674 1 0 0 0 Yuma, Arizona, US
1232 1232 2290 Yukon-Koyukuk Alaska US 3/22/20 23:45 65.50815459 -151.3907387 0 0 0 0 Yukon-Koyukuk, Alaska, US
130 130 6115 Yuba California US 3/22/20 23:45 39.26255932 -121.3535644 2 0 0 0 Yuba, California, US
2937 2937 48503 Young Texas US 3/22/20 23:45 33.17659707 -98.68790885 0 0 0 0 Young, Texas, US
681 681 51199 York Virginia US 3/22/20 23:45 37.24374789 -76.54412815 5 1 0 0 York, Virginia, US
811 811 45091 York South Carolina US 3/22/20 23:45 34.97281497 -81.18085944 4 0 0 0 York, South Carolina, US
461 461 42133 York Pennsylvania US 3/22/20 23:45 39.9210089 -76.73040131 10 0 0 0 York, Pennsylvania, US
2299 2299 31185 York Nebraska US 3/22/20 23:45 40.87272618 -97.59710186 0 0 0 0 York, Nebraska, US
1013 1013 23031 York Maine US 3/22/20 23:45 43.47808377 -70.71052375 8 0 0 0 York, Maine, US
120 120 6113 Yolo California US 3/22/20 23:45 38.68278902 -121.9018288 6 0 0 0 Yolo, California, US
2936 2936 48501 Yoakum Texas US 3/22/20 23:45 33.17320212 -102.8276433 0 0 0 0 Yoakum, Texas, US
1110 1110 30111 Yellowstone Montana US 3/22/20 23:45 45.93955949 -108.2691486 6 0 0 0 Yellowstone, Montana, US
2042 2042 27173 Yellow Medicine Minnesota US 3/22/20 23:45 44.71710183 -95.86842453 0 0 0 0 Yellow Medicine, Minnesota, US
1284 1284 5149 Yell Arkansas US 3/22/20 23:45 35.00292371 -93.41171338 0 0 0 0 Yell, Arkansas, US
746 746 28163 Yazoo Mississippi US 3/22/20 23:45 32.77890365 -90.39656148 1 0 0 0 Yazoo, Mississippi, US
945 945 4025 Yavapai Arizona US 3/22/20 23:45 34.59933926 -112.5538588 3 0 0 0 Yavapai, Arizona, US
2358 2358 36123 Yates New York US 3/22/20 23:45 42.63505484 -77.10369919 0 0 0 0 Yates, New York, US
2689 2689 46135 Yankton South Dakota US 3/22/20 23:45 43.00924485 -97.39467635 0 0 0 0 Yankton, South Dakota, US
2413 2413 37199 Yancey North Carolina US 3/22/20 23:45 35.90079156 -82.31237181 0 0 0 0 Yancey, North Carolina, US
908 908 41071 Yamhill Oregon US 3/22/20 23:45 45.23330449 -123.3086963 6 0 0 0 Yamhill, Oregon, US
2072 2072 28161 Yalobusha Mississippi US 3/22/20 23:45 34.02824175 -89.7076205 0 0 0 0 Yalobusha, Mississippi, US
1231 1231 2282 Yakutat Alaska US 3/22/20 23:45 59.8909808 -140.3601451 0 0 0 0 Yakutat, Alaska, US
55 55 53077 Yakima Washington US 3/22/20 23:45 46.45738486 -120.7380126 16 0 0 0 Yakima, Washington, US
2412 2412 37197 Yadkin North Carolina US 3/22/20 23:45 36.16222629 -80.66239436 0 0 0 0 Yadkin, North Carolina, US
3231 3231     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3059 3059 51197 Wythe Virginia US 3/22/20 23:45 36.91582035 -81.07834059 0 0 0 0 Wythe, Virginia, US
3116 3116 54109 Wyoming West Virginia US 3/22/20 23:45 37.612327 -81.54511071 0 0 0 0 Wyoming, West Virginia, US
2619 2619 42131 Wyoming Pennsylvania US 3/22/20 23:45 41.51955538 -76.01074915 0 0 0 0 Wyoming, Pennsylvania, US
32 32 36121 Wyoming New York US 3/22/20 23:45 42.70145109 -78.22199579 2 0 0 0 Wyoming, New York, US
1053 1053 20209 Wyandotte Kansas US 3/22/20 23:45 39.11727348 -94.76378225 14 1 0 0 Wyandotte, Kansas, US
2505 2505 39175 Wyandot Ohio US 3/22/20 23:45 40.84339621 -83.30734173 0 0 0 0 Wyandot, Ohio, US
2170 2170 29229 Wright Missouri US 3/22/20 23:45 37.27029221 -92.46914488 0 0 0 0 Wright, Missouri, US
858 858 27171 Wright Minnesota US 3/22/20 23:45 45.17297924 -93.96234781 3 0 0 0 Wright, Minnesota, US
1696 1696 19197 Wright Iowa US 3/22/20 23:45 42.73305373 -93.73515113 0 0 0 0 Wright, Iowa, US
1230 1230 2275 Wrangell Alaska US 3/22/20 23:45 56.3202004 -132.0583731 0 0 0 0 Wrangell, Alaska, US
2169 2169 29227 Worth Missouri US 3/22/20 23:45 40.47945588 -94.42328751 0 0 0 0 Worth, Missouri, US
1695 1695 19195 Worth Iowa US 3/22/20 23:45 43.37750768 -93.26087602 0 0 0 0 Worth, Iowa, US
398 398 13321 Worth Georgia US 3/22/20 23:45 31.55162306 -83.85090513 2 0 0 0 Worth, Georgia, US
289 289 25027 Worcester Massachusetts US 3/22/20 23:45 42.35026951 -71.90493363 37 0 0 0 Worcester, Massachusetts, US
662 662 24047 Worcester Maryland US 3/22/20 23:45 38.21274277 -75.33200012 2 0 0 0 Worcester, Maryland, US
2566 2566 40153 Woodward Oklahoma US 3/22/20 23:45 36.42316318 -99.26283045 0 0 0 0 Woodward, Oklahoma, US
1786 1786 20207 Woodson Kansas US 3/22/20 23:45 37.8865336 -95.74006277 0 0 0 0 Woodson, Kansas, US
2565 2565 40151 Woods Oklahoma US 3/22/20 23:45 36.76705782 -98.86573064 0 0 0 0 Woods, Oklahoma, US
901 901 5147 Woodruff Arkansas US 3/22/20 23:45 35.18902527 -91.2439489 1 0 0 0 Woodruff, Arkansas, US
1887 1887 21239 Woodford Kentucky US 3/22/20 23:45 38.04178222 -84.7417556 0 0 0 0 Woodford, Kentucky, US
151 151 17203 Woodford Illinois US 3/22/20 23:45 40.78579374 -89.20973757 2 0 0 0 Woodford, Illinois, US
1008 1008 19193 Woodbury Iowa US 3/22/20 23:45 42.38979414 -96.0459439 1 0 0 0 Woodbury, Iowa, US
547 547 55141 Wood Wisconsin US 3/22/20 23:45 44.45537896 -90.04158336 1 0 0 0 Wood, Wisconsin, US
3115 3115 54107 Wood West Virginia US 3/22/20 23:45 39.20967886 -81.5162836 0 0 0 0 Wood, West Virginia, US
2935 2935 48499 Wood Texas US 3/22/20 23:45 32.78722382 -95.38236368 0 0 0 0 Wood, Texas, US
595 595 39173 Wood Ohio US 3/22/20 23:45 41.36224827 -83.62285108 1 0 0 0 Wood, Ohio, US
1886 1886 21237 Wolfe Kentucky US 3/22/20 23:45 37.73941626 -83.49303612 0 0 0 0 Wolfe, Kentucky, US
3058 3058 51195 Wise Virginia US 3/22/20 23:45 36.9746148 -82.62410519 0 0 0 0 Wise, Virginia, US
2934 2934 48497 Wise Texas US 3/22/20 23:45 33.21570665 -97.65460265 0 0 0 0 Wise, Texas, US
3114 3114 54105 Wirt West Virginia US 3/22/20 23:45 39.02775007 -81.37473928 0 0 0 0 Wirt, West Virginia, US
736 736 28159 Winston Mississippi US 3/22/20 23:45 33.08747908 -89.03391385 2 0 0 0 Winston, Mississippi, US
1206 1206 1133 Winston Alabama US 3/22/20 23:45 34.15030532 -87.37325922 0 0 0 0 Winston, Alabama, US
2041 2041 27169 Winona Minnesota US 3/22/20 23:45 43.98772283 -91.78081305 0 0 0 0 Winona, Minnesota, US
1003 1003 19191 Winneshiek Iowa US 3/22/20 23:45 43.29094334 -91.84422722 1 0 0 0 Winneshiek, Iowa, US
534 534 55139 Winnebago Wisconsin US 3/22/20 23:45 44.06886922 -88.64477096 5 0 0 0 Winnebago, Wisconsin, US
1694 1694 19189 Winnebago Iowa US 3/22/20 23:45 43.37751174 -93.73407298 0 0 0 0 Winnebago, Iowa, US
146 146 17201 Winnebago Illinois US 3/22/20 23:45 42.33641854 -89.16085327 4 0 0 0 Winnebago, Illinois, US
1915 1915 22127 Winn Louisiana US 3/22/20 23:45 31.94449367 -92.63789413 0 0 0 0 Winn, Louisiana, US
2933 2933 48495 Winkler Texas US 3/22/20 23:45 31.85008651 -103.0485163 0 0 0 0 Winkler, Texas, US
1083 1083 50027 Windsor Vermont US 3/22/20 23:45 43.58010937 -72.58595157 8 1 0 0 Windsor, Vermont, US
1084 1084 50025 Windham Vermont US 3/22/20 23:45 42.986982 -72.71268875 5 0 0 0 Windham, Vermont, US
605 605 9015 Windham Connecticut US 3/22/20 23:45 41.82972709 -71.98182316 1 0 0 0 Windham, Connecticut, US
3057 3057 51840 Winchester Virginia US 3/22/20 23:45 39.17054517 -78.17325058 0 0 0 0 Winchester, Virginia, US
2932 2932 48493 Wilson Texas US 3/22/20 23:45 29.1732598 -98.08693082 0 0 0 0 Wilson, Texas, US
504 504 47189 Wilson Tennessee US 3/22/20 23:45 36.15496772 -86.29775884 2 0 0 0 Wilson, Tennessee, US
625 625 37195 Wilson North Carolina US 3/22/20 23:45 35.70625477 -77.917978 3 0 0 0 Wilson, North Carolina, US
1785 1785 20205 Wilson Kansas US 3/22/20 23:45 37.55937174 -95.74323255 0 0 0 0 Wilson, Kansas, US
316 316 48491 Williamson Texas US 3/22/20 23:45 30.64655664 -97.6004854 9 0 0 0 Williamson, Texas, US
486 486 47187 Williamson Tennessee US 3/22/20 23:45 35.89099229 -86.89281867 48 0 0 0 Williamson, Tennessee, US
159 159 17199 Williamson Illinois US 3/22/20 23:45 37.73033511 -88.92994027 1 0 0 0 Williamson, Illinois, US
682 682 51830 Williamsburg Virginia US 3/22/20 23:45 37.28131268 -76.70905141 5 1 0 0 Williamsburg, Virginia, US
2632 2632 45089 Williamsburg South Carolina US 3/22/20 23:45 33.62190129 -79.72767442 0 0 0 0 Williamsburg, South Carolina, US
2504 2504 39171 Williams Ohio US 3/22/20 23:45 41.56052014 -84.58429552 0 0 0 0 Williams, Ohio, US
2460 2460 38105 Williams North Dakota US 3/22/20 23:45 48.34522353 -103.4793387 0 0 0 0 Williams, North Dakota, US
2931 2931 48489 Willacy Texas US 3/22/20 23:45 26.47411727 -97.61535848 0 0 0 0 Willacy, Texas, US
141 141 17197 Will Illinois US 3/22/20 23:45 41.44619267 -87.97862712 21 1 0 0 Will, Illinois, US
728 728 28157 Wilkinson Mississippi US 3/22/20 23:45 31.16078225 -91.31018819 3 0 0 0 Wilkinson, Mississippi, US
1459 1459 13319 Wilkinson Georgia US 3/22/20 23:45 32.80291082 -83.17140684 0 0 0 0 Wilkinson, Georgia, US
2040 2040 27167 Wilkin Minnesota US 3/22/20 23:45 46.35721532 -96.4684375 0 0 0 0 Wilkin, Minnesota, US
2411 2411 37193 Wilkes North Carolina US 3/22/20 23:45 36.2084135 -81.16232895 0 0 0 0 Wilkes, North Carolina, US
1458 1458 13317 Wilkes Georgia US 3/22/20 23:45 33.78290391 -82.74286107 0 0 0 0 Wilkes, Georgia, US
1457 1457 13315 Wilcox Georgia US 3/22/20 23:45 31.97496928 -83.43438555 0 0 0 0 Wilcox, Georgia, US
1205 1205 1131 Wilcox Alabama US 3/22/20 23:45 31.98773215 -87.30891118 0 0 0 0 Wilcox, Alabama, US
2930 2930 48487 Wilbarger Texas US 3/22/20 23:45 34.07945812 -99.24178437 0 0 0 0 Wilbarger, Texas, US
661 661 24045 Wicomico Maryland US 3/22/20 23:45 38.37301947 -75.62705831 2 0 0 0 Wicomico, Maryland, US
321 321 48485 Wichita Texas US 3/22/20 23:45 33.98842886 -98.7041034 4 0 0 0 Wichita, Texas, US
1784 1784 20203 Wichita Kansas US 3/22/20 23:45 38.48178252 -101.3471509 0 0 0 0 Wichita, Kansas, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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