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 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
2897 2897 99999   Grand Princess US 2020-04-27 02:30:52     103 3 0 100 Grand Princess, US
2605 2605 90056 Unassigned Wyoming US 2020-04-27 02:30:52     0 6 0 -6 Unassigned, Wyoming, US
2604 2604 90055 Unassigned Wisconsin US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Wisconsin, US
2603 2603 90054 Unassigned West Virginia US 2020-04-27 02:30:52     0 0 0 0 Unassigned, West Virginia, US
2602 2602 90053 Unassigned Washington US 2020-04-26 00:00:00     123 0 0 123 Unassigned, Washington, US
2601 2601 90051 Unassigned Virginia US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Virginia, US
2600 2600 90050 Unassigned Vermont US 2020-04-27 02:30:52     5 0 0 5 Unassigned, Vermont, US
2366 2366 90049 Southwest Utah US 2020-04-27 02:30:52     0 0 0 0 Southwest, Utah, US
2599 2599 90049 Unassigned Utah US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Utah, US
2598 2598 90048 Unassigned Texas US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Texas, US
2597 2597 90047 Unassigned Tennessee US 2020-04-27 02:30:52     37 0 0 37 Unassigned, Tennessee, US
2596 2596 90046 Unassigned South Dakota US 2020-04-27 02:30:52     0 0 0 0 Unassigned, South Dakota, US
2595 2595 90045 Unassigned South Carolina US 2020-04-27 02:30:52     0 0 0 0 Unassigned, South Carolina, US
2594 2594 90044 Unassigned Rhode Island US 2020-04-27 02:30:52     1109 78 0 883 Unassigned, Rhode Island, US
2593 2593 90042 Unassigned Pennsylvania US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Pennsylvania, US
2592 2592 90041 Unassigned Oregon US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Oregon, US
2591 2591 90040 Unassigned Oklahoma US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Oklahoma, US
2590 2590 90039 Unassigned Ohio US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Ohio, US
2589 2589 90038 Unassigned North Dakota US 2020-04-27 02:30:52     0 0 0 0 Unassigned, North Dakota, US
2588 2588 90037 Unassigned North Carolina US 2020-04-27 02:30:52     1 0 0 1 Unassigned, North Carolina, US
2587 2587 90036 Unassigned New York US 2020-04-27 02:30:52     0 0 0 0 Unassigned, New York, US
2586 2586 90035 Unassigned New Mexico US 2020-04-27 02:30:52     0 0 0 0 Unassigned, New Mexico, US
2585 2585 90034 Unassigned New Jersey US 2020-04-27 02:30:52     681 0 0 681 Unassigned, New Jersey, US
2584 2584 90033 Unassigned New Hampshire US 2020-04-27 02:30:52     5 57 0 -52 Unassigned, New Hampshire, US
2583 2583 90032 Unassigned Nevada US 2020-04-27 02:30:52     95 1 0 94 Unassigned, Nevada, US
2582 2582 90031 Unassigned Nebraska US 2020-04-27 02:30:52     10 18 0 -8 Unassigned, Nebraska, US
2581 2581 90030 Unassigned Montana US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Montana, US
2580 2580 90029 Unassigned Missouri US 2020-04-27 02:30:52     1 0 0 1 Unassigned, Missouri, US
2579 2579 90028 Unassigned Mississippi US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Mississippi, US
2578 2578 90027 Unassigned Minnesota US 2020-04-27 02:30:52     9 0 0 9 Unassigned, Minnesota, US
2577 2577 90026 Unassigned Michigan US 2020-04-27 02:30:52     3 1 0 2 Unassigned, Michigan, US
2576 2576 90025 Unassigned Massachusetts US 2020-04-27 02:30:52     807 141 0 666 Unassigned, Massachusetts, US
2575 2575 90024 Unassigned Maryland US 2020-04-27 02:31:05     0 145 0 -145 Unassigned, Maryland, US
2574 2574 90023 Unassigned Maine US 2020-04-27 02:30:52     2 0 0 2 Unassigned, Maine, US
2573 2573 90022 Unassigned Louisiana US 2020-04-27 02:30:52     64 59 0 5 Unassigned, Louisiana, US
2572 2572 90021 Unassigned Kentucky US 2020-04-27 02:30:52     58 0 0 58 Unassigned, Kentucky, US
2571 2571 90020 Unassigned Kansas US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Kansas, US
2570 2570 90019 Unassigned Iowa US 2020-04-27 02:30:52     6 0 0 6 Unassigned, Iowa, US
2569 2569 90018 Unassigned Indiana US 2020-04-27 02:30:52     0 180 0 0 Unassigned, Indiana, US
2568 2568 90017 Unassigned Illinois US 2020-04-27 02:30:52     307 0 0 307 Unassigned, Illinois, US
2567 2567 90016 Unassigned Idaho US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Idaho, US
2566 2566 90015 Unassigned Hawaii US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Hawaii, US
2565 2565 90013 Unassigned Georgia US 2020-04-27 02:30:52     622 0 0 622 Unassigned, Georgia, US
2564 2564 90012 Unassigned Florida US 2020-04-27 02:30:52     1 0 0 1 Unassigned, Florida, US
2563 2563 90010 Unassigned Delaware US 2020-04-27 02:30:52     9 0 0 9 Unassigned, Delaware, US
2562 2562 90009 Unassigned Connecticut US 2020-04-27 02:30:52     522 0 0 522 Unassigned, Connecticut, US
2561 2561 90008 Unassigned Colorado US 2020-04-27 02:30:52     172 2 0 170 Unassigned, Colorado, US
2560 2560 90006 Unassigned California US 2020-04-27 02:30:52     0 2 0 -2 Unassigned, California, US
2559 2559 90005 Unassigned Arkansas US 2020-04-27 02:30:52     216 0 0 216 Unassigned, Arkansas, US
2558 2558 90004 Unassigned Arizona US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Arizona, US
2557 2557 90002 Unassigned Alaska US 2020-04-27 02:30:52     0 4 0 -4 Unassigned, Alaska, US
2556 2556 90001 Unassigned Alabama US 2020-04-27 02:30:52     0 0 0 0 Unassigned, Alabama, US
2889 2889 88888   Diamond Princess US 2020-04-27 02:30:52     49 0 0 49 Diamond Princess, US
1961 1961 80047 Out of TN Tennessee US 2020-04-27 02:30:52     332 2 0 330 Out of TN, Tennessee, US
1960 1960 80040 Out of OK Oklahoma US 2020-04-27 02:30:52     0 0 0 0 Out of OK, Oklahoma, US
1959 1959 80026 Out of MI Michigan US 2020-04-27 02:30:52     27 1 0 26 Out of MI, Michigan, US
1958 1958 80015 Out of HI Hawaii US 2020-04-27 02:30:52     7 0 0 7 Out of HI, Hawaii, US
1957 1957 80013 Out of GA Georgia US 2020-04-27 02:30:52     1022 9 0 1013 Out of GA, Georgia, US
1956 1956 80008 Out of CO Colorado US 2020-04-27 02:30:52     0 2 0 -2 Out of CO, Colorado, US
2696 2696 56043 Washakie Wyoming US 2020-04-27 02:30:52 43.90451606 -107.68018700000002 8 0 0 8 Washakie, Wyoming, US
2553 2553 56041 Uinta Wyoming US 2020-04-27 02:30:52 41.2878183 -110.54757820000002 7 0 0 7 Uinta, Wyoming, US
2498 2498 56039 Teton Wyoming US 2020-04-27 02:30:52 43.93522482 -110.5890801 95 0 0 95 Teton, Wyoming, US
2466 2466 56037 Sweetwater Wyoming US 2020-04-27 02:30:52 41.65943896 -108.8827882 16 0 0 16 Sweetwater, Wyoming, US
2437 2437 56035 Sublette Wyoming US 2020-04-27 02:30:52 42.76558279 -109.9130922 3 0 0 3 Sublette, Wyoming, US
2333 2333 56033 Sheridan Wyoming US 2020-04-27 02:30:52 44.79048913 -106.8862389 16 0 0 16 Sheridan, Wyoming, US
2062 2062 56031 Platte Wyoming US 2020-04-27 02:30:52 42.13299116 -104.966331 0 0 0 0 Platte, Wyoming, US
1979 1979 56029 Park Wyoming US 2020-04-27 02:30:52 44.52157546 -109.5852825 1 0 0 1 Park, Wyoming, US
1866 1866 56027 Niobrara Wyoming US 2020-04-27 02:30:52 43.05607708 -104.4758896 2 0 0 2 Niobrara, Wyoming, US
1833 1833 56025 Natrona Wyoming US 2020-04-27 02:30:52 42.96180148 -106.797885 49 0 0 49 Natrona, Wyoming, US
1497 1497 56023 Lincoln Wyoming US 2020-04-27 02:30:52 42.26376367 -110.6563997 9 0 0 9 Lincoln, Wyoming, US
1408 1408 56021 Laramie Wyoming US 2020-04-27 02:30:52 41.30702520000001 -104.6887497 125 0 0 125 Laramie, Wyoming, US
1292 1292 56019 Johnson Wyoming US 2020-04-27 02:30:52 44.04057166 -106.5845174 15 1 0 14 Johnson, Wyoming, US
1151 1151 56017 Hot Springs Wyoming US 2020-04-27 02:30:52 43.71930657 -108.4423174 3 0 0 3 Hot Springs, Wyoming, US
950 950 56015 Goshen Wyoming US 2020-04-27 02:30:52 42.08798185 -104.3534743 4 0 0 4 Goshen, Wyoming, US
885 885 56013 Fremont Wyoming US 2020-04-27 02:30:52 43.04183996 -108.6296893 91 0 0 91 Fremont, Wyoming, US
613 613 56011 Crook Wyoming US 2020-04-27 02:30:52 44.58855102 -104.5697705 5 0 0 5 Crook, Wyoming, US
567 567 56009 Converse Wyoming US 2020-04-27 02:30:52 42.97272268 -105.5081848 16 0 0 16 Converse, Wyoming, US
342 342 56007 Carbon Wyoming US 2020-04-27 02:30:52 41.69357844 -106.9326084 6 0 0 6 Carbon, Wyoming, US
333 333 56005 Campbell Wyoming US 2020-04-27 02:30:52 44.24886082 -105.5474404 23 0 0 23 Campbell, Wyoming, US
187 187 56003 Big Horn Wyoming US 2020-04-27 02:30:52 44.52405055 -107.9960365 2 0 0 2 Big Horn, Wyoming, US
27 27 56001 Albany Wyoming US 2020-04-27 02:30:52 41.65498705 -105.7235415 6 0 0 6 Albany, Wyoming, US
2828 2828 55141 Wood Wisconsin US 2020-04-27 02:30:52 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2817 2817 55139 Winnebago Wisconsin US 2020-04-27 02:30:52 44.06886922 -88.64477096 48 1 0 47 Winnebago, Wisconsin, US
2734 2734 55137 Waushara Wisconsin US 2020-04-27 02:30:52 44.11324419 -89.24317107 2 0 0 2 Waushara, Wisconsin, US
2733 2733 55135 Waupaca Wisconsin US 2020-04-27 02:30:52 44.47068056 -88.96534501 7 1 0 6 Waupaca, Wisconsin, US
2732 2732 55133 Waukesha Wisconsin US 2020-04-27 02:30:52 43.01833055 -88.30431188 307 14 0 293 Waukesha, Wisconsin, US
2726 2726 55131 Washington Wisconsin US 2020-04-27 02:30:52 43.36863664 -88.22974712 92 4 0 88 Washington, Wisconsin, US
2697 2697 55129 Washburn Wisconsin US 2020-04-27 02:30:52 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2674 2674 55127 Walworth Wisconsin US 2020-04-27 02:30:52 42.66858202 -88.54163073 135 8 0 127 Walworth, Wisconsin, US
2651 2651 55125 Vilas Wisconsin US 2020-04-27 02:30:52 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2648 2648 55123 Vernon Wisconsin US 2020-04-27 02:30:52 43.59422667 -90.8324691 1 0 0 1 Vernon, Wisconsin, US
2529 2529 55121 Trempealeau Wisconsin US 2020-04-27 02:30:52 44.30360275 -91.35893614 2 0 0 2 Trempealeau, Wisconsin, US
2320 2320 55117 Sheboygan Wisconsin US 2020-04-27 02:30:52 43.72099677 -87.94579284 45 2 0 43 Sheboygan, Wisconsin, US
2318 2318 55115 Shawano Wisconsin US 2020-04-27 02:30:52 44.78902246 -88.76443896 8 0 0 8 Shawano, Wisconsin, US
2277 2277 55113 Sawyer Wisconsin US 2020-04-27 02:30:52 45.87931905 -91.14504927 3 0 0 3 Sawyer, Wisconsin, US
2275 2275 55111 Sauk Wisconsin US 2020-04-27 02:30:52 43.42574087 -89.94966132 40 3 0 37 Sauk, Wisconsin, US
2382 2382 55109 St. Croix Wisconsin US 2020-04-27 02:30:52 45.03437474 -92.45000068 13 0 0 13 St. Croix, Wisconsin, US
2221 2221 55107 Rusk Wisconsin US 2020-04-27 02:30:52 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2198 2198 55105 Rock Wisconsin US 2020-04-27 02:30:52 42.67151616 -89.07147900000002 151 5 0 146 Rock, Wisconsin, US
2176 2176 55103 Richland Wisconsin US 2020-04-27 02:30:52 43.3762778 -90.43012729 11 1 0 10 Richland, Wisconsin, 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
);