04-18-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,055 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
2808 2808 99999   Grand Princess US 2020-04-18 22:32:47     103 0 0 103 Grand Princess, US
2523 2523 90056 Unassigned Wyoming US 2020-04-18 22:32:47     0 1 0 -1 Unassigned, Wyoming, US
2522 2522 90055 Unassigned Wisconsin US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Wisconsin, US
2521 2521 90054 Unassigned West Virginia US 2020-04-18 22:32:47     0 9 0 -9 Unassigned, West Virginia, US
2520 2520 90053 Unassigned Washington US 2020-04-18 22:32:47     444 0 0 444 Unassigned, Washington, US
2519 2519 90051 Unassigned Virginia US 2020-04-18 22:32:47     0 94 0 -94 Unassigned, Virginia, US
2518 2518 90050 Unassigned Vermont US 2020-04-18 22:32:47     10 1 0 9 Unassigned, Vermont, US
2517 2517 90049 Unassigned Utah US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Utah, US
2516 2516 90047 Unassigned Tennessee US 2020-04-18 22:32:47     37 0 0 37 Unassigned, Tennessee, US
2515 2515 90046 Unassigned South Dakota US 2020-04-18 22:32:47     0 0 0 0 Unassigned, South Dakota, US
2514 2514 90044 Unassigned Rhode Island US 2020-04-18 22:32:47     1146 43 0 1012 Unassigned, Rhode Island, US
2513 2513 90042 Unassigned Pennsylvania US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Pennsylvania, US
2512 2512 90041 Unassigned Oregon US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Oregon, US
2511 2511 90040 Unassigned Oklahoma US 2020-04-18 22:32:47     108 5 0 103 Unassigned, Oklahoma, US
2510 2510 90039 Unassigned Ohio US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Ohio, US
2509 2509 90036 Unassigned New York US 2020-04-18 22:32:47     0 1059 0 -1059 Unassigned, New York, US
2508 2508 90035 Unassigned New Mexico US 2020-04-18 22:32:47     0 0 0 0 Unassigned, New Mexico, US
2507 2507 90034 Unassigned New Jersey US 2020-04-18 22:32:47     748 2 0 746 Unassigned, New Jersey, US
2506 2506 90033 Unassigned New Hampshire US 2020-04-18 22:32:47     0 35 0 -35 Unassigned, New Hampshire, US
2505 2505 90032 Unassigned Nevada US 2020-04-18 22:32:47     34 0 0 34 Unassigned, Nevada, US
2504 2504 90031 Unassigned Nebraska US 2020-04-18 22:32:47     60 9 0 51 Unassigned, Nebraska, US
2503 2503 90030 Unassigned Montana US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Montana, US
2502 2502 90029 Unassigned Missouri US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Missouri, US
2501 2501 90028 Unassigned Mississippi US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Mississippi, US
2500 2500 90027 Unassigned Minnesota US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Minnesota, US
2499 2499 90026 Unassigned Michigan US 2020-04-18 22:32:47     48 3 0 45 Unassigned, Michigan, US
2498 2498 90025 Unassigned Massachusetts US 2020-04-18 22:32:47     733 19 0 714 Unassigned, Massachusetts, US
2497 2497 90023 Unassigned Maine US 2020-04-18 22:32:47     1 0 0 1 Unassigned, Maine, US
2496 2496 90022 Unassigned Louisiana US 2020-04-18 22:32:47     57 1 0 56 Unassigned, Louisiana, US
2495 2495 90021 Unassigned Kentucky US 2020-04-18 22:32:47     73 6 0 67 Unassigned, Kentucky, US
2494 2494 90020 Unassigned Kansas US 2020-04-18 22:32:47     0 1 0 0 Unassigned, Kansas, US
2493 2493 90019 Unassigned Iowa US 2020-04-18 22:32:47     1 0 0 1 Unassigned, Iowa, US
2492 2492 90018 Unassigned Indiana US 2020-04-18 22:32:47     0 120 0 0 Unassigned, Indiana, US
2491 2491 90017 Unassigned Illinois US 2020-04-18 22:32:47     84 3 0 81 Unassigned, Illinois, US
2490 2490 90016 Unassigned Idaho US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Idaho, US
2489 2489 90015 Unassigned Hawaii US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Hawaii, US
2488 2488 90013 Unassigned Georgia US 2020-04-18 22:32:47     220 0 0 220 Unassigned, Georgia, US
2487 2487 90012 Unassigned Florida US 2020-04-18 22:32:47     3 0 0 3 Unassigned, Florida, US
2486 2486 90010 Unassigned Delaware US 2020-04-18 22:32:47     30 0 0 30 Unassigned, Delaware, US
2485 2485 90009 Unassigned Connecticut US 2020-04-18 22:32:47     525 3 0 522 Unassigned, Connecticut, US
2484 2484 90008 Unassigned Colorado US 2020-04-18 22:32:47     67 1 0 66 Unassigned, Colorado, US
2483 2483 90006 Unassigned California US 2020-04-18 22:32:47     0 0 0 0 Unassigned, California, US
2482 2482 90005 Unassigned Arkansas US 2020-04-18 22:32:47     42 0 0 42 Unassigned, Arkansas, US
2481 2481 90004 Unassigned Arizona US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Arizona, US
2480 2480 90002 Unassigned Alaska US 2020-04-18 22:32:47     0 4 0 -4 Unassigned, Alaska, US
2479 2479 90001 Unassigned Alabama US 2020-04-18 22:32:47     0 0 0 0 Unassigned, Alabama, US
2799 2799 88888   Diamond Princess US 2020-04-18 22:32:47     49 0 0 49 Diamond Princess, US
1901 1901 80047 Out of TN Tennessee US 2020-04-18 22:32:47     259 1 0 258 Out of TN, Tennessee, US
1900 1900 80040 Out of OK Oklahoma US 2020-04-18 22:32:47     0 0 0 0 Out of OK, Oklahoma, US
1899 1899 80026 Out of MI Michigan US 2020-04-18 22:32:47     74 2 0 72 Out of MI, Michigan, US
1898 1898 80015 Out of HI Hawaii US 2020-04-18 22:32:47     6 0 0 6 Out of HI, Hawaii, US
1897 1897 80013 Out of GA Georgia US 2020-04-18 22:32:47     815 7 0 808 Out of GA, Georgia, US
2612 2612 56043 Washakie Wyoming US 2020-04-18 22:32:47 43.90451606 -107.680187 5 0 0 5 Washakie, Wyoming, US
2476 2476 56041 Uinta Wyoming US 2020-04-18 22:32:47 41.2878183 -110.5475782 6 0 0 6 Uinta, Wyoming, US
2423 2423 56039 Teton Wyoming US 2020-04-18 22:32:47 43.93522482 -110.5890801 62 0 0 62 Teton, Wyoming, US
2391 2391 56037 Sweetwater Wyoming US 2020-04-18 22:32:47 41.65943896 -108.8827882 10 0 0 10 Sweetwater, Wyoming, US
2362 2362 56035 Sublette Wyoming US 2020-04-18 22:32:47 42.76558279 -109.9130922 1 0 0 1 Sublette, Wyoming, US
2264 2264 56033 Sheridan Wyoming US 2020-04-18 22:32:47 44.79048913 -106.8862389 12 0 0 12 Sheridan, Wyoming, US
1997 1997 56031 Platte Wyoming US 2020-04-18 22:32:47 42.13299116 -104.966331 0 0 0 0 Platte, Wyoming, US
1919 1919 56029 Park Wyoming US 2020-04-18 22:32:47 44.52157546 -109.5852825 1 0 0 1 Park, Wyoming, US
1809 1809 56027 Niobrara Wyoming US 2020-04-18 22:32:47 43.05607708 -104.4758896 1 0 0 1 Niobrara, Wyoming, US
1777 1777 56025 Natrona Wyoming US 2020-04-18 22:32:47 42.96180148 -106.797885 38 0 0 38 Natrona, Wyoming, US
1451 1451 56023 Lincoln Wyoming US 2020-04-18 22:32:47 42.26376367 -110.6563997 5 0 0 5 Lincoln, Wyoming, US
1364 1364 56021 Laramie Wyoming US 2020-04-18 22:32:47 41.3070252 -104.6887497 70 0 0 70 Laramie, Wyoming, US
1250 1250 56019 Johnson Wyoming US 2020-04-18 22:32:47 44.04057166 -106.5845174 11 1 0 10 Johnson, Wyoming, US
1113 1113 56017 Hot Springs Wyoming US 2020-04-18 22:32:47 43.71930657 -108.4423174 1 0 0 1 Hot Springs, Wyoming, US
923 923 56015 Goshen Wyoming US 2020-04-18 22:32:47 42.08798185 -104.3534743 3 0 0 3 Goshen, Wyoming, US
863 863 56013 Fremont Wyoming US 2020-04-18 22:32:47 43.04183996 -108.6296893 47 0 0 47 Fremont, Wyoming, US
597 597 56011 Crook Wyoming US 2020-04-18 22:32:47 44.58855102 -104.5697705 4 0 0 4 Crook, Wyoming, US
551 551 56009 Converse Wyoming US 2020-04-18 22:32:47 42.97272268 -105.5081848 8 0 0 8 Converse, Wyoming, US
339 339 56007 Carbon Wyoming US 2020-04-18 22:32:47 41.69357844 -106.9326084 4 0 0 4 Carbon, Wyoming, US
330 330 56005 Campbell Wyoming US 2020-04-18 22:32:47 44.24886082 -105.5474404 13 0 0 13 Campbell, Wyoming, US
184 184 56003 Big Horn Wyoming US 2020-04-18 22:32:47 44.52405055 -107.9960365 1 0 0 1 Big Horn, Wyoming, US
27 27 56001 Albany Wyoming US 2020-04-18 22:32:47 41.65498705 -105.7235415 6 0 0 6 Albany, Wyoming, US
2740 2740 55141 Wood Wisconsin US 2020-04-18 22:32:47 44.45537896 -90.04158336 2 0 0 2 Wood, Wisconsin, US
2729 2729 55139 Winnebago Wisconsin US 2020-04-18 22:32:47 44.06886922 -88.64477096 38 1 0 37 Winnebago, Wisconsin, US
2650 2650 55137 Waushara Wisconsin US 2020-04-18 22:32:47 44.11324419 -89.24317107 2 0 0 2 Waushara, Wisconsin, US
2649 2649 55135 Waupaca Wisconsin US 2020-04-18 22:32:47 44.47068056 -88.96534501 4 1 0 3 Waupaca, Wisconsin, US
2648 2648 55133 Waukesha Wisconsin US 2020-04-18 22:32:47 43.01833055 -88.30431188 259 11 0 248 Waukesha, Wisconsin, US
2643 2643 55131 Washington Wisconsin US 2020-04-18 22:32:47 43.36863664 -88.22974712 82 3 0 79 Washington, Wisconsin, US
2613 2613 55129 Washburn Wisconsin US 2020-04-18 22:32:47 45.89838588 -91.79050449 1 0 0 1 Washburn, Wisconsin, US
2590 2590 55127 Walworth Wisconsin US 2020-04-18 22:32:47 42.66858202 -88.54163073 89 4 0 85 Walworth, Wisconsin, US
2567 2567 55125 Vilas Wisconsin US 2020-04-18 22:32:47 46.05467334 -89.51719204 4 0 0 4 Vilas, Wisconsin, US
2453 2453 55121 Trempealeau Wisconsin US 2020-04-18 22:32:47 44.30360275 -91.35893614 1 0 0 1 Trempealeau, Wisconsin, US
2252 2252 55117 Sheboygan Wisconsin US 2020-04-18 22:32:47 43.72099677 -87.94579284 39 2 0 37 Sheboygan, Wisconsin, US
2250 2250 55115 Shawano Wisconsin US 2020-04-18 22:32:47 44.78902246 -88.76443896 6 0 0 6 Shawano, Wisconsin, US
2209 2209 55113 Sawyer Wisconsin US 2020-04-18 22:32:47 45.87931905 -91.14504927 2 0 0 2 Sawyer, Wisconsin, US
2207 2207 55111 Sauk Wisconsin US 2020-04-18 22:32:47 43.42574087 -89.94966132 32 3 0 29 Sauk, Wisconsin, US
2309 2309 55109 St. Croix Wisconsin US 2020-04-18 22:32:47 45.03437474 -92.45000068 11 0 0 11 St. Croix, Wisconsin, US
2154 2154 55107 Rusk Wisconsin US 2020-04-18 22:32:47 45.47498854 -91.1333012 4 0 0 4 Rusk, Wisconsin, US
2131 2131 55105 Rock Wisconsin US 2020-04-18 22:32:47 42.67151616 -89.071479 68 4 0 64 Rock, Wisconsin, US
2109 2109 55103 Richland Wisconsin US 2020-04-18 22:32:47 43.3762778 -90.43012729 8 1 0 7 Richland, Wisconsin, US
2069 2069 55101 Racine Wisconsin US 2020-04-18 22:32:47 42.74753117 -88.05941254 164 8 0 156 Racine, Wisconsin, US
2041 2041 55099 Price Wisconsin US 2020-04-18 22:32:47 45.68051754 -90.3609888 1 0 0 1 Price, Wisconsin, US
2022 2022 55097 Portage Wisconsin US 2020-04-18 22:32:47 44.47558711 -89.50152965 4 0 0 4 Portage, Wisconsin, US
2015 2015 55095 Polk Wisconsin US 2020-04-18 22:32:47 45.46130348 -92.44182875 4 0 0 4 Polk, Wisconsin, US
1973 1973 55093 Pierce Wisconsin US 2020-04-18 22:32:47 44.71850291 -92.4224416 7 0 0 7 Pierce, Wisconsin, US
1942 1942 55091 Pepin Wisconsin US 2020-04-18 22:32:47 44.58307413 -91.99949611 0 0 0 0 Pepin, Wisconsin, US
1908 1908 55089 Ozaukee Wisconsin US 2020-04-18 22:32:47 43.38352225 -87.94625009 79 9 0 70 Ozaukee, Wisconsin, US
1902 1902 55087 Outagamie Wisconsin US 2020-04-18 22:32:47 44.41578887 -88.46565023 33 2 0 31 Outagamie, Wisconsin, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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