04-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

2,810 rows sorted by Admin2 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
2810 2810   unassigned Wyoming US 4/6/20 23:22     0 0 0 0 unassigned, Wyoming, US
2538 2538 48505 Zapata Texas US 4/6/20 23:22 27.00156391 -99.16987152 1 0 0 0 Zapata, Texas, US
2536 2536 4027 Yuma Arizona US 4/6/20 23:22 32.76895712 -113.9066674 13 0 0 0 Yuma, Arizona, US
2537 2537 8125 Yuma Colorado US 4/6/20 23:22 40.00346839 -102.4258673 2 0 0 0 Yuma, Colorado, US
2535 2535 2290 Yukon-Koyukuk Alaska US 4/6/20 23:22 65.50815459 -151.3907387 1 0 0 0 Yukon-Koyukuk, Alaska, US
2534 2534 6115 Yuba California US 4/6/20 23:22 39.26255932 -121.3535644 11 0 0 0 Yuba, California, US
2533 2533 48503 Young Texas US 4/6/20 23:22 33.17659707 -98.68790885 3 0 0 0 Young, Texas, US
2528 2528 23031 York Maine US 4/6/20 23:22 43.47808377 -70.71052375 108 1 0 0 York, Maine, US
2529 2529 31185 York Nebraska US 4/6/20 23:22 40.87272618 -97.59710186 1 0 0 0 York, Nebraska, US
2530 2530 42133 York Pennsylvania US 4/6/20 23:22 39.9210089 -76.73040131 189 1 0 0 York, Pennsylvania, US
2531 2531 45091 York South Carolina US 4/6/20 23:22 34.97281497 -81.18085944 95 2 0 0 York, South Carolina, US
2532 2532 51199 York Virginia US 4/6/20 23:22 37.24374789 -76.54412815 21 1 0 0 York, Virginia, US
2527 2527 6113 Yolo California US 4/6/20 23:22 38.68278902 -121.9018288 37 1 0 0 Yolo, California, US
2526 2526 30111 Yellowstone Montana US 4/6/20 23:22 45.93955949 -108.2691486 40 0 0 0 Yellowstone, Montana, US
2525 2525 27173 Yellow Medicine Minnesota US 4/6/20 23:22 44.71710183 -95.86842453 1 0 0 0 Yellow Medicine, Minnesota, US
2524 2524 5149 Yell Arkansas US 4/6/20 23:22 35.00292371 -93.41171338 1 0 0 0 Yell, Arkansas, US
2523 2523 28163 Yazoo Mississippi US 4/6/20 23:22 32.77890365 -90.39656148 32 1 0 0 Yazoo, Mississippi, US
2522 2522 4025 Yavapai Arizona US 4/6/20 23:22 34.59933926 -112.5538588 49 0 0 0 Yavapai, Arizona, US
2521 2521 36123 Yates New York US 4/6/20 23:22 42.63505484 -77.10369919 1 0 0 0 Yates, New York, US
2520 2520 46135 Yankton South Dakota US 4/6/20 23:22 43.00924485 -97.39467635 18 0 0 0 Yankton, South Dakota, US
2519 2519 41071 Yamhill Oregon US 4/6/20 23:22 45.23330449 -123.3086963 26 3 0 0 Yamhill, Oregon, US
2518 2518 28161 Yalobusha Mississippi US 4/6/20 23:22 34.02824175 -89.7076205 11 0 0 0 Yalobusha, Mississippi, US
2517 2517 53077 Yakima Washington US 4/6/20 23:22 46.45738486 -120.7380126 363 19 0 0 Yakima, Washington, US
2516 2516 37197 Yadkin North Carolina US 4/6/20 23:22 36.16222629 -80.66239436 9 0 0 0 Yadkin, North Carolina, US
2515 2515 51197 Wythe Virginia US 4/6/20 23:22 36.91582035 -81.07834059 3 0 0 0 Wythe, Virginia, US
2513 2513 36121 Wyoming New York US 4/6/20 23:22 42.70145109 -78.22199579 23 1 0 0 Wyoming, New York, US
2514 2514 42131 Wyoming Pennsylvania US 4/6/20 23:22 41.51955538 -76.01074915 5 0 0 0 Wyoming, Pennsylvania, US
2512 2512 20209 Wyandotte Kansas US 4/6/20 23:22 39.11727348 -94.76378225 186 6 0 0 Wyandotte, Kansas, US
2511 2511 39175 Wyandot Ohio US 4/6/20 23:22 40.84339621 -83.30734173 5 0 0 0 Wyandot, Ohio, US
2508 2508 19197 Wright Iowa US 4/6/20 23:22 42.73305373 -93.73515113 1 0 0 0 Wright, Iowa, US
2509 2509 27171 Wright Minnesota US 4/6/20 23:22 45.17297924 -93.96234781 9 0 0 0 Wright, Minnesota, US
2510 2510 29229 Wright Missouri US 4/6/20 23:22 37.27029221 -92.46914488 7 0 0 0 Wright, Missouri, US
2506 2506 13321 Worth Georgia US 4/6/20 23:22 31.55162306 -83.85090513 39 2 0 0 Worth, Georgia, US
2507 2507 29227 Worth Missouri US 4/6/20 23:22 40.47945588 -94.42328751 1 0 0 0 Worth, Missouri, US
2504 2504 24047 Worcester Maryland US 4/6/20 23:22 38.21274277 -75.33200012 10 0 0 0 Worcester, Maryland, US
2505 2505 25027 Worcester Massachusetts US 4/6/20 23:22 42.35026951 -71.90493363 1077 18 0 0 Worcester, Massachusetts, US
2503 2503 40153 Woodward Oklahoma US 4/6/20 23:22 36.42316318 -99.26283045 1 0 0 0 Woodward, Oklahoma, US
2502 2502 20207 Woodson Kansas US 4/6/20 23:22 37.8865336 -95.74006277 3 0 0 0 Woodson, Kansas, US
2501 2501 5147 Woodruff Arkansas US 4/6/20 23:22 35.18902527 -91.2439489 1 0 0 0 Woodruff, Arkansas, US
2499 2499 17203 Woodford Illinois US 4/6/20 23:22 40.78579374 -89.20973757 6 0 0 0 Woodford, Illinois, US
2500 2500 21239 Woodford Kentucky US 4/6/20 23:22 38.04178222 -84.7417556 9 1 0 0 Woodford, Kentucky, US
2498 2498 19193 Woodbury Iowa US 4/6/20 23:22 42.38979414 -96.0459439 8 0 0 0 Woodbury, Iowa, US
2494 2494 39173 Wood Ohio US 4/6/20 23:22 41.36224827 -83.62285108 34 0 0 0 Wood, Ohio, US
2495 2495 48499 Wood Texas US 4/6/20 23:22 32.78722382 -95.38236368 3 0 0 0 Wood, Texas, US
2496 2496 54107 Wood West Virginia US 4/6/20 23:22 39.20967886 -81.5162836 11 0 0 0 Wood, West Virginia, US
2497 2497 55141 Wood Wisconsin US 4/6/20 23:22 44.45537896 -90.04158336 2 0 0 0 Wood, Wisconsin, US
2492 2492 48497 Wise Texas US 4/6/20 23:22 33.21570665 -97.65460265 3 0 0 0 Wise, Texas, US
2493 2493 51195 Wise Virginia US 4/6/20 23:22 36.9746148 -82.62410519 1 0 0 0 Wise, Virginia, US
2491 2491 54105 Wirt West Virginia US 4/6/20 23:22 39.02775007 -81.37473928 1 0 0 0 Wirt, West Virginia, US
2489 2489 1133 Winston Alabama US 4/6/20 23:22 34.15030532 -87.37325922 3 0 0 0 Winston, Alabama, US
2490 2490 28159 Winston Mississippi US 4/6/20 23:22 33.08747908 -89.03391385 15 0 0 0 Winston, Mississippi, US
2488 2488 27169 Winona Minnesota US 4/6/20 23:22 43.98772283 -91.78081305 14 2 0 0 Winona, Minnesota, US
2487 2487 19191 Winneshiek Iowa US 4/6/20 23:22 43.29094334 -91.84422722 4 0 0 0 Winneshiek, Iowa, US
2484 2484 17201 Winnebago Illinois US 4/6/20 23:22 42.33641854 -89.16085327 49 1 0 0 Winnebago, Illinois, US
2485 2485 19189 Winnebago Iowa US 4/6/20 23:22 43.37751174 -93.73407298 1 0 0 0 Winnebago, Iowa, US
2486 2486 55139 Winnebago Wisconsin US 4/6/20 23:22 44.06886922 -88.64477096 24 1 0 0 Winnebago, Wisconsin, US
2483 2483 22127 Winn Louisiana US 4/6/20 23:22 31.94449367 -92.63789413 2 1 0 0 Winn, Louisiana, US
2482 2482 50027 Windsor Vermont US 4/6/20 23:22 43.58010937 -72.58595157 22 1 0 0 Windsor, Vermont, US
2480 2480 9015 Windham Connecticut US 4/6/20 23:22 41.82972709 -71.98182316 40 1 0 0 Windham, Connecticut, US
2481 2481 50025 Windham Vermont US 4/6/20 23:22 42.986982 -72.71268875 35 0 0 0 Windham, Vermont, US
2479 2479 51840 Winchester Virginia US 4/6/20 23:22 39.17054517 -78.17325058 13 0 0 0 Winchester, Virginia, US
2476 2476 37195 Wilson North Carolina US 4/6/20 23:22 35.70625477 -77.917978 29 1 0 0 Wilson, North Carolina, US
2477 2477 47189 Wilson Tennessee US 4/6/20 23:22 36.15496772 -86.29775884 97 0 0 0 Wilson, Tennessee, US
2478 2478 48493 Wilson Texas US 4/6/20 23:22 29.1732598 -98.08693082 6 0 0 0 Wilson, Texas, US
2473 2473 17199 Williamson Illinois US 4/6/20 23:22 37.73033511 -88.92994027 3 0 0 0 Williamson, Illinois, US
2474 2474 47187 Williamson Tennessee US 4/6/20 23:22 35.89099229 -86.89281867 260 2 0 0 Williamson, Tennessee, US
2475 2475 48491 Williamson Texas US 4/6/20 23:22 30.64655664 -97.6004854 77 2 0 0 Williamson, Texas, US
2471 2471 45089 Williamsburg South Carolina US 4/6/20 23:22 33.62190129 -79.72767442 11 0 0 0 Williamsburg, South Carolina, US
2472 2472 51830 Williamsburg Virginia US 4/6/20 23:22 37.28131268 -76.70905141 13 1 0 0 Williamsburg, Virginia, US
2469 2469 38105 Williams North Dakota US 4/6/20 23:22 48.34522353 -103.4793387 5 0 0 0 Williams, North Dakota, US
2470 2470 39171 Williams Ohio US 4/6/20 23:22 41.56052014 -84.58429552 1 0 0 0 Williams, Ohio, US
2468 2468 48489 Willacy Texas US 4/6/20 23:22 26.47411727 -97.61535848 5 1 0 0 Willacy, Texas, US
2467 2467 17197 Will Illinois US 4/6/20 23:22 41.44619267 -87.97862712 697 19 0 0 Will, Illinois, US
2465 2465 13319 Wilkinson Georgia US 4/6/20 23:22 32.80291082 -83.17140684 3 0 0 0 Wilkinson, Georgia, US
2466 2466 28157 Wilkinson Mississippi US 4/6/20 23:22 31.16078225 -91.31018819 30 3 0 0 Wilkinson, Mississippi, US
2464 2464 27167 Wilkin Minnesota US 4/6/20 23:22 46.35721532 -96.4684375 2 0 0 0 Wilkin, Minnesota, US
2462 2462 13317 Wilkes Georgia US 4/6/20 23:22 33.78290391 -82.74286107 4 0 0 0 Wilkes, Georgia, US
2463 2463 37193 Wilkes North Carolina US 4/6/20 23:22 36.2084135 -81.16232895 4 1 0 0 Wilkes, North Carolina, US
2460 2460 1131 Wilcox Alabama US 4/6/20 23:22 31.98773215 -87.30891118 13 0 0 0 Wilcox, Alabama, US
2461 2461 13315 Wilcox Georgia US 4/6/20 23:22 31.97496928 -83.43438555 2 0 0 0 Wilcox, Georgia, US
2459 2459 24045 Wicomico Maryland US 4/6/20 23:22 38.37301947 -75.62705831 11 1 0 0 Wicomico, Maryland, US
2458 2458 48485 Wichita Texas US 4/6/20 23:22 33.98842886 -98.7041034 47 0 0 0 Wichita, Texas, US
2457 2457 53075 Whitman Washington US 4/6/20 23:22 46.90022523 -117.5241763 12 0 0 0 Whitman, Washington, US
2456 2456 18183 Whitley Indiana US 4/6/20 23:22 41.13863784 -85.50791236 8 1 0 0 Whitley, Indiana, US
2455 2455 13313 Whitfield Georgia US 4/6/20 23:22 34.80987459 -84.96093476 17 1 0 0 Whitfield, Georgia, US
2454 2454 17195 Whiteside Illinois US 4/6/20 23:22 41.75509713 -89.91556058 18 1 0 0 Whiteside, Illinois, US
2453 2453 32033 White Pine Nevada US 4/6/20 23:22 39.44157041 -114.899966 1 0 0 0 White Pine, Nevada, US
2449 2449 5145 White Arkansas US 4/6/20 23:22 35.25688493 -91.74908296 25 0 0 0 White, Arkansas, US
2450 2450 13311 White Georgia US 4/6/20 23:22 34.64624278 -83.74905525 4 0 0 0 White, Georgia, US
2451 2451 18181 White Indiana US 4/6/20 23:22 40.74911165 -86.86492015 3 0 0 0 White, Indiana, US
2452 2452 47185 White Tennessee US 4/6/20 23:22 35.92929884 -85.45591799 2 0 0 0 White, Tennessee, US
2448 2448 13309 Wheeler Georgia US 4/6/20 23:22 32.12009104 -82.72574721 1 0 0 0 Wheeler, Georgia, US
2447 2447 53073 Whatcom Washington US 4/6/20 23:22 48.82227976 -121.7490018 228 19 0 0 Whatcom, Washington, US
2446 2446 48481 Wharton Texas US 4/6/20 23:22 29.27765923 -96.22319248 13 0 0 0 Wharton, Texas, US
2445 2445 26165 Wexford Michigan US 4/6/20 23:22 44.33853602 -85.57712739 5 0 0 0 Wexford, Michigan, US
2444 2444 54103 Wetzel West Virginia US 4/6/20 23:22 39.6065771 -80.6401654 2 0 0 0 Wetzel, West Virginia, US
2442 2442 42129 Westmoreland Pennsylvania US 4/6/20 23:22 40.3137798 -79.46615476 157 0 0 0 Westmoreland, Pennsylvania, US
2443 2443 51193 Westmoreland Virginia US 4/6/20 23:22 38.11021557 -76.80213247 3 0 0 0 Westmoreland, Virginia, US
2441 2441 36119 Westchester New York US 4/6/20 23:22 41.16278376 -73.75741653 14294 211 0 0 Westchester, New York, US
2440 2440 22125 West Feliciana Louisiana US 4/6/20 23:22 30.87882871 -91.4148538 30 0 0 0 West Feliciana, Louisiana, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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