04-21-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,093 rows sorted by FIPS 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
2846 2846 99999   Grand Princess US 2020-04-21 23:30:50     103 0 0 103 Grand Princess, US
2559 2559 90056 Unassigned Wyoming US 2020-04-21 23:30:50     0 1 0 -1 Unassigned, Wyoming, US
2558 2558 90055 Unassigned Wisconsin US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Wisconsin, US
2557 2557 90054 Unassigned West Virginia US 2020-04-21 23:30:50     0 19 0 -19 Unassigned, West Virginia, US
2556 2556 90053 Unassigned Washington US 2020-04-21 23:30:50     159 0 0 159 Unassigned, Washington, US
2555 2555 90051 Unassigned Virginia US 2020-04-21 23:30:50     0 140 0 -140 Unassigned, Virginia, US
2554 2554 90050 Unassigned Vermont US 2020-04-21 23:30:50     3 0 0 3 Unassigned, Vermont, US
2553 2553 90049 Unassigned Utah US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Utah, US
2552 2552 90047 Unassigned Tennessee US 2020-04-21 23:30:50     36 0 0 36 Unassigned, Tennessee, US
2551 2551 90046 Unassigned South Dakota US 2020-04-21 23:30:50     0 0 0 0 Unassigned, South Dakota, US
2550 2550 90044 Unassigned Rhode Island US 2020-04-21 23:30:50     1000 82 0 832 Unassigned, Rhode Island, US
2549 2549 90042 Unassigned Pennsylvania US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Pennsylvania, US
2548 2548 90041 Unassigned Oregon US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Oregon, US
2547 2547 90040 Unassigned Oklahoma US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Oklahoma, US
2546 2546 90039 Unassigned Ohio US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Ohio, US
2545 2545 90037 Unassigned North Carolina US 2020-04-21 23:30:50     0 0 0 0 Unassigned, North Carolina, US
2544 2544 90036 Unassigned New York US 2020-04-21 23:30:50     0 3 0 -3 Unassigned, New York, US
2543 2543 90035 Unassigned New Mexico US 2020-04-21 23:30:50     0 0 0 0 Unassigned, New Mexico, US
2542 2542 90034 Unassigned New Jersey US 2020-04-21 23:30:50     3073 233 0 2840 Unassigned, New Jersey, US
2541 2541 90033 Unassigned New Hampshire US 2020-04-21 23:30:50     14 39 0 -25 Unassigned, New Hampshire, US
2540 2540 90032 Unassigned Nevada US 2020-04-21 23:30:50     34 0 0 34 Unassigned, Nevada, US
2539 2539 90031 Unassigned Nebraska US 2020-04-21 23:30:50     0 15 0 -15 Unassigned, Nebraska, US
2538 2538 90030 Unassigned Montana US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Montana, US
2537 2537 90029 Unassigned Missouri US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Missouri, US
2536 2536 90028 Unassigned Mississippi US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Mississippi, US
2535 2535 90027 Unassigned Minnesota US 2020-04-21 23:30:50     4 0 0 4 Unassigned, Minnesota, US
2534 2534 90026 Unassigned Michigan US 2020-04-21 23:30:50     28 4 0 24 Unassigned, Michigan, US
2533 2533 90025 Unassigned Massachusetts US 2020-04-21 23:30:50     929 8 0 921 Unassigned, Massachusetts, US
2532 2532 90024 Unassigned Maryland US 2020-04-21 23:38:51     0 120 0 -120 Unassigned, Maryland, US
2531 2531 90023 Unassigned Maine US 2020-04-21 23:30:50     1 0 0 1 Unassigned, Maine, US
2530 2530 90022 Unassigned Louisiana US 2020-04-21 23:30:50     59 2 0 57 Unassigned, Louisiana, US
2529 2529 90021 Unassigned Kentucky US 2020-04-21 23:30:50     73 0 0 73 Unassigned, Kentucky, US
2528 2528 90020 Unassigned Kansas US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Kansas, US
2527 2527 90019 Unassigned Iowa US 2020-04-21 23:30:50     21 0 0 21 Unassigned, Iowa, US
2526 2526 90018 Unassigned Indiana US 2020-04-21 23:30:50     0 155 0 0 Unassigned, Indiana, US
2525 2525 90017 Unassigned Illinois US 2020-04-21 23:30:50     192 2 0 190 Unassigned, Illinois, US
2524 2524 90016 Unassigned Idaho US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Idaho, US
2523 2523 90015 Unassigned Hawaii US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Hawaii, US
2522 2522 90013 Unassigned Georgia US 2020-04-21 23:30:50     470 0 0 470 Unassigned, Georgia, US
2521 2521 90012 Unassigned Florida US 2020-04-21 23:30:50     4 0 0 4 Unassigned, Florida, US
2520 2520 90010 Unassigned Delaware US 2020-04-21 23:30:50     30 0 0 30 Unassigned, Delaware, US
2519 2519 90009 Unassigned Connecticut US 2020-04-21 23:30:50     503 4 0 499 Unassigned, Connecticut, US
2518 2518 90008 Unassigned Colorado US 2020-04-21 23:30:50     126 1 0 125 Unassigned, Colorado, US
2517 2517 90006 Unassigned California US 2020-04-21 23:30:50     0 2 0 -2 Unassigned, California, US
2516 2516 90005 Unassigned Arkansas US 2020-04-21 23:30:50     45 0 0 45 Unassigned, Arkansas, US
2515 2515 90004 Unassigned Arizona US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Arizona, US
2514 2514 90002 Unassigned Alaska US 2020-04-21 23:30:50     0 4 0 -4 Unassigned, Alaska, US
2513 2513 90001 Unassigned Alabama US 2020-04-21 23:30:50     0 0 0 0 Unassigned, Alabama, US
2837 2837 88888   Diamond Princess US 2020-04-21 23:30:50     49 0 0 49 Diamond Princess, US
1927 1927 80047 Out of TN Tennessee US 2020-04-21 23:30:50     265 1 0 264 Out of TN, Tennessee, US
1926 1926 80040 Out of OK Oklahoma US 2020-04-21 23:30:50     0 0 0 0 Out of OK, Oklahoma, US
1925 1925 80026 Out of MI Michigan US 2020-04-21 23:30:50     69 2 0 67 Out of MI, Michigan, US
1924 1924 80015 Out of HI Hawaii US 2020-04-21 23:30:50     6 0 0 6 Out of HI, Hawaii, US
1923 1923 80013 Out of GA Georgia US 2020-04-21 23:30:50     970 7 0 963 Out of GA, Georgia, US
2648 2648 56043 Washakie Wyoming US 2020-04-21 23:30:50 43.90451606 -107.68018700000002 8 0 0 8 Washakie, Wyoming, US
2510 2510 56041 Uinta Wyoming US 2020-04-21 23:30:50 41.2878183 -110.54757820000002 7 0 0 7 Uinta, Wyoming, US
2455 2455 56039 Teton Wyoming US 2020-04-21 23:30:50 43.93522482 -110.5890801 92 0 0 92 Teton, Wyoming, US
2423 2423 56037 Sweetwater Wyoming US 2020-04-21 23:30:50 41.65943896 -108.8827882 16 0 0 16 Sweetwater, Wyoming, US
2394 2394 56035 Sublette Wyoming US 2020-04-21 23:30:50 42.76558279 -109.9130922 3 0 0 3 Sublette, Wyoming, US
2294 2294 56033 Sheridan Wyoming US 2020-04-21 23:30:50 44.79048913 -106.8862389 16 0 0 16 Sheridan, Wyoming, US
2026 2026 56031 Platte Wyoming US 2020-04-21 23:30:50 42.13299116 -104.966331 0 0 0 0 Platte, Wyoming, US
1945 1945 56029 Park Wyoming US 2020-04-21 23:30:50 44.52157546 -109.5852825 1 0 0 1 Park, Wyoming, US
1835 1835 56027 Niobrara Wyoming US 2020-04-21 23:30:50 43.05607708 -104.4758896 2 0 0 2 Niobrara, Wyoming, US
1802 1802 56025 Natrona Wyoming US 2020-04-21 23:30:50 42.96180148 -106.797885 48 0 0 48 Natrona, Wyoming, US
1472 1472 56023 Lincoln Wyoming US 2020-04-21 23:30:50 42.26376367 -110.6563997 9 0 0 9 Lincoln, Wyoming, US
1384 1384 56021 Laramie Wyoming US 2020-04-21 23:30:50 41.30702520000001 -104.6887497 110 0 0 110 Laramie, Wyoming, US
1270 1270 56019 Johnson Wyoming US 2020-04-21 23:30:50 44.04057166 -106.5845174 15 1 0 14 Johnson, Wyoming, US
1132 1132 56017 Hot Springs Wyoming US 2020-04-21 23:30:50 43.71930657 -108.4423174 3 0 0 3 Hot Springs, Wyoming, US
936 936 56015 Goshen Wyoming US 2020-04-21 23:30:50 42.08798185 -104.3534743 4 0 0 4 Goshen, Wyoming, US
874 874 56013 Fremont Wyoming US 2020-04-21 23:30:50 43.04183996 -108.6296893 58 0 0 58 Fremont, Wyoming, US
606 606 56011 Crook Wyoming US 2020-04-21 23:30:50 44.58855102 -104.5697705 5 0 0 5 Crook, Wyoming, US
560 560 56009 Converse Wyoming US 2020-04-21 23:30:50 42.97272268 -105.5081848 15 0 0 15 Converse, Wyoming, US
340 340 56007 Carbon Wyoming US 2020-04-21 23:30:50 41.69357844 -106.9326084 4 0 0 4 Carbon, Wyoming, US
331 331 56005 Campbell Wyoming US 2020-04-21 23:30:50 44.24886082 -105.5474404 18 0 0 18 Campbell, Wyoming, US
186 186 56003 Big Horn Wyoming US 2020-04-21 23:30:50 44.52405055 -107.9960365 3 0 0 3 Big Horn, Wyoming, US
27 27 56001 Albany Wyoming US 2020-04-21 23:30:50 41.65498705 -105.7235415 6 0 0 6 Albany, Wyoming, US
2776 2776 55141 Wood Wisconsin US 2020-04-21 23:30:50 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2765 2765 55139 Winnebago Wisconsin US 2020-04-21 23:30:50 44.06886922 -88.64477096 41 1 0 40 Winnebago, Wisconsin, US
2685 2685 55137 Waushara Wisconsin US 2020-04-21 23:30:50 44.11324419 -89.24317107 2 0 0 2 Waushara, Wisconsin, US
2684 2684 55135 Waupaca Wisconsin US 2020-04-21 23:30:50 44.47068056 -88.96534501 4 1 0 3 Waupaca, Wisconsin, US
2683 2683 55133 Waukesha Wisconsin US 2020-04-21 23:30:50 43.01833055 -88.30431188 274 13 0 261 Waukesha, Wisconsin, US
2678 2678 55131 Washington Wisconsin US 2020-04-21 23:30:50 43.36863664 -88.22974712 87 3 0 84 Washington, Wisconsin, US
2649 2649 55129 Washburn Wisconsin US 2020-04-21 23:30:50 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2626 2626 55127 Walworth Wisconsin US 2020-04-21 23:30:50 42.66858202 -88.54163073 90 7 0 83 Walworth, Wisconsin, US
2603 2603 55125 Vilas Wisconsin US 2020-04-21 23:30:50 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2486 2486 55121 Trempealeau Wisconsin US 2020-04-21 23:30:50 44.30360275 -91.35893614 1 0 0 1 Trempealeau, Wisconsin, US
2281 2281 55117 Sheboygan Wisconsin US 2020-04-21 23:30:50 43.72099677 -87.94579284 43 2 0 41 Sheboygan, Wisconsin, US
2279 2279 55115 Shawano Wisconsin US 2020-04-21 23:30:50 44.78902246 -88.76443896 6 0 0 6 Shawano, Wisconsin, US
2238 2238 55113 Sawyer Wisconsin US 2020-04-21 23:30:50 45.87931905 -91.14504927 2 0 0 2 Sawyer, Wisconsin, US
2236 2236 55111 Sauk Wisconsin US 2020-04-21 23:30:50 43.42574087 -89.94966132 34 3 0 31 Sauk, Wisconsin, US
2341 2341 55109 St. Croix Wisconsin US 2020-04-21 23:30:50 45.03437474 -92.45000068 11 0 0 11 St. Croix, Wisconsin, US
2183 2183 55107 Rusk Wisconsin US 2020-04-21 23:30:50 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2160 2160 55105 Rock Wisconsin US 2020-04-21 23:30:50 42.67151616 -89.07147900000002 83 4 0 79 Rock, Wisconsin, US
2138 2138 55103 Richland Wisconsin US 2020-04-21 23:30:50 43.3762778 -90.43012729 8 1 0 7 Richland, Wisconsin, US
2098 2098 55101 Racine Wisconsin US 2020-04-21 23:30:50 42.74753117 -88.05941254 185 10 0 175 Racine, Wisconsin, US
2070 2070 55099 Price Wisconsin US 2020-04-21 23:30:50 45.68051754 -90.3609888 1 0 0 1 Price, Wisconsin, US
2051 2051 55097 Portage Wisconsin US 2020-04-21 23:30:50 44.47558711 -89.50152965 4 0 0 4 Portage, Wisconsin, US
2044 2044 55095 Polk Wisconsin US 2020-04-21 23:30:50 45.46130348 -92.44182875 4 0 0 4 Polk, Wisconsin, US
2001 2001 55093 Pierce Wisconsin US 2020-04-21 23:30:50 44.71850291 -92.4224416 8 0 0 8 Pierce, Wisconsin, US
1970 1970 55091 Pepin Wisconsin US 2020-04-21 23:30:50 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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