04-15-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,028 rows sorted by Lat

✎ 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
801 801   Federal Correctional Institution (FCI) Michigan US 2020-04-15 22:56:51     36 0 0 36 Federal Correctional Institution (FCI), Michigan, US
1600 1600   McIntosh Georgia US 2020-04-15 22:56:51     3 0 0 3 McIntosh, Georgia, US
1646 1646   Michigan Department of Corrections (MDOC) Michigan US 2020-04-15 22:56:51     472 12 0 460 Michigan Department of Corrections (MDOC), Michigan, US
1881 1881 80013 Out of GA Georgia US 2020-04-15 22:56:51     683 0 0 683 Out of GA, Georgia, US
1882 1882   Out of MI Michigan US 2020-04-15 22:56:51     166 2 0 164 Out of MI, Michigan, US
1883 1883 80040 Out of OK Oklahoma US 2020-04-15 22:56:51     0 0 0 0 Out of OK, Oklahoma, US
1884 1884   Out of TN Tennessee US 2020-04-15 22:56:51     260 1 0 259 Out of TN, Tennessee, US
2457 2457 90002 Unassigned Alaska US 2020-04-15 22:56:51     0 4 0 -4 Unassigned, Alaska, US
2458 2458 90004 Unassigned Arizona US 2020-04-15 22:56:51     0 27 0 -27 Unassigned, Arizona, US
2459 2459 90005 Unassigned Arkansas US 2020-04-15 22:56:51     48 0 0 48 Unassigned, Arkansas, US
2460 2460 90006 Unassigned California US 2020-04-15 22:56:51     0 0 0 0 Unassigned, California, US
2461 2461 90008 Unassigned Colorado US 2020-04-15 22:56:51     119 0 0 119 Unassigned, Colorado, US
2462 2462 90009 Unassigned Connecticut US 2020-04-15 22:56:51     537 2 0 535 Unassigned, Connecticut, US
2463 2463 90010 Unassigned Delaware US 2020-04-15 22:56:51     17 9 0 14 Unassigned, Delaware, US
2464 2464 90012 Unassigned Florida US 2020-04-15 22:56:51     5 0 0 5 Unassigned, Florida, US
2465 2465 90013 Unassigned Georgia US 2020-04-15 22:56:51     263 7 0 256 Unassigned, Georgia, US
2466 2466 90015 Unassigned Hawaii US 2020-04-15 22:56:51     1 0 0 1 Unassigned, Hawaii, US
2467 2467 90016 Unassigned Idaho US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Idaho, US
2468 2468 90017 Unassigned Illinois US 2020-04-15 22:56:51     45 1 0 44 Unassigned, Illinois, US
2469 2469 90018 Unassigned Indiana US 2020-04-15 22:56:51     0 131 0 0 Unassigned, Indiana, US
2470 2470 90019 Unassigned Iowa US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Iowa, US
2471 2471 90020 Unassigned Kansas US 2020-04-15 22:56:51     0 2 0 0 Unassigned, Kansas, US
2472 2472 90021 Unassigned Kentucky US 2020-04-15 22:56:51     78 9 0 69 Unassigned, Kentucky, US
2473 2473 90022 Unassigned Louisiana US 2020-04-15 22:56:51     56 1 0 55 Unassigned, Louisiana, US
2474 2474 90023 Unassigned Maine US 2020-04-15 22:56:51     2 0 0 2 Unassigned, Maine, US
2475 2475 90025 Unassigned Massachusetts US 2020-04-15 22:56:51     572 14 0 558 Unassigned, Massachusetts, US
2476 2476 90026 Unassigned Michigan US 2020-04-15 22:56:51     76 5 0 71 Unassigned, Michigan, US
2477 2477 90027 Unassigned Minnesota US 2020-04-15 22:56:51     2 0 0 2 Unassigned, Minnesota, US
2478 2478 90028 Unassigned Mississippi US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Mississippi, US
2479 2479 90029 Unassigned Missouri US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Missouri, US
2480 2480 90030 Unassigned Montana US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Montana, US
2481 2481 90031 Unassigned Nebraska US 2020-04-15 22:56:51     19 5 0 14 Unassigned, Nebraska, US
2482 2482 90032 Unassigned Nevada US 2020-04-15 22:56:51     5 0 0 5 Unassigned, Nevada, US
2483 2483 90033 Unassigned New Hampshire US 2020-04-15 22:56:51     0 29 0 -29 Unassigned, New Hampshire, US
2484 2484 90034 Unassigned New Jersey US 2020-04-15 22:56:51     1189 2 0 1187 Unassigned, New Jersey, US
2485 2485 90035 Unassigned New Mexico US 2020-04-15 22:56:51     0 0 0 0 Unassigned, New Mexico, US
2486 2486 90036 Unassigned New York US 2020-04-15 22:56:51     0 0 0 0 Unassigned, New York, US
2487 2487 90039 Unassigned Ohio US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Ohio, US
2488 2488 90040 Unassigned Oklahoma US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Oklahoma, US
2489 2489 90041 Unassigned Oregon US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Oregon, US
2490 2490 90042 Unassigned Pennsylvania US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Pennsylvania, US
2491 2491 90044 Unassigned Rhode Island US 2020-04-15 22:56:51     756 62 0 679 Unassigned, Rhode Island, US
2492 2492 90046 Unassigned South Dakota US 2020-04-15 22:56:51     0 0 0 0 Unassigned, South Dakota, US
2493 2493 90047 Unassigned Tennessee US 2020-04-15 22:56:51     136 0 0 136 Unassigned, Tennessee, US
2494 2494 90049 Unassigned Utah US 2020-04-15 22:56:51     0 7 0 -7 Unassigned, Utah, US
2495 2495 90050 Unassigned Vermont US 2020-04-15 22:56:51     15 0 0 15 Unassigned, Vermont, US
2496 2496 90051 Unassigned Virginia US 2020-04-15 22:56:51     0 101 0 -101 Unassigned, Virginia, US
2497 2497 90053 Unassigned Washington US 2020-04-15 22:56:51     383 0 0 383 Unassigned, Washington, US
2498 2498 90054 Unassigned West Virginia US 2020-04-15 22:56:51     0 4 0 -4 Unassigned, West Virginia, US
2499 2499 90055 Unassigned Wisconsin US 2020-04-15 22:56:51     1 0 0 1 Unassigned, Wisconsin, US
2500 2500   Unassigned Wyoming US 2020-04-15 22:56:51     0 0 0 0 Unassigned, Wyoming, US
2772 2772 88888   Diamond Princess US 2020-04-15 22:56:51     49 0 0 49 Diamond Princess, US
2780 2780     Grand Princess Canada 2020-04-15 23:04:09     13 0 0 13 Grand Princess, Canada
2781 2781 99999   Grand Princess US 2020-04-15 22:56:51     103 0 0 103 Grand Princess, US
2822 2822     Recovered Canada 2020-04-15 23:04:09     0 0 8966 -8966 Recovered, Canada
2823 2823     Recovered US 2020-04-15 22:56:51     0 0 52096 -52096 Recovered, US
2892 2892       Diamond Princess 2020-04-15 22:56:32     712 12 639 61 Diamond Princess
2947 2947       MS Zaandam 2020-04-15 22:56:32     9 2 0 7 MS Zaandam
2773 2773     Falkland Islands (Malvinas) United Kingdom 2020-04-15 22:56:32 -51.7963 -59.5236 11 0 1 10 Falkland Islands (Malvinas), United Kingdom
2837 2837     Tasmania Australia 2020-04-15 23:04:26 -42.8821 147.3272 165 6 53 106 Tasmania, Australia
2966 2966       New Zealand 2020-04-15 22:56:32 -40.9006 174.886 1386 9 728 649 New Zealand
2854 2854       Argentina 2020-04-15 22:56:32 -38.4161 -63.6167 2443 111 596 1736 Argentina
2841 2841     Victoria Australia 2020-04-15 23:04:26 -37.8136 144.9631 1299 14 1118 167 Victoria, Australia
2881 2881       Chile 2020-04-15 22:56:32 -35.6751 -71.543 8273 94 2937 5242 Chile
2762 2762     Australian Capital Territory Australia 2020-04-15 23:04:26 -35.4735 149.0124 103 3 72 28 Australian Capital Territory, Australia
2835 2835     South Australia Australia 2020-04-15 23:04:26 -34.9285 138.6007 433 4 240 189 South Australia, Australia
2808 2808     New South Wales Australia 2020-04-15 23:04:26 -33.8688 151.2093 2886 25 4 2857 New South Wales, Australia
3021 3021       Uruguay 2020-04-15 22:56:32 -32.5228 -55.7658 492 8 260 224 Uruguay
2843 2843     Western Australia Australia 2020-04-15 23:04:26 -31.9505 115.8605 527 6 251 270 Western Australia, Australia
3000 3000       South Africa 2020-04-15 22:56:32 -30.5595 22.9375 2506 34 410 2062 South Africa
2821 2821     Queensland Australia 2020-04-15 23:04:26 -27.4698 153.0251 999 5 442 552 Queensland, Australia
2902 2902       Eswatini 2020-04-15 22:56:32 -26.5225 31.4659 15 0 8 7 Eswatini
2976 2976       Paraguay 2020-04-15 22:56:32 -23.4425 -58.4438 161 8 23 130 Paraguay
2963 2963       Namibia 2020-04-15 22:56:32 -22.9576 18.4904 16 0 3 13 Namibia
2869 2869       Botswana 2020-04-15 22:56:32 -22.3285 24.6849 13 1 0 12 Botswana
2824 2824     Reunion France 2020-04-15 22:56:32 -21.1151 55.5364 391 0 237 154 Reunion, France
2807 2807     New Caledonia France 2020-04-15 22:56:32 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2955 2955       Mauritius 2020-04-15 22:56:32 -20.348404000000002 57.552152 324 9 65 250 Mauritius
3028 3028       Zimbabwe 2020-04-15 22:56:32 -19.015438 29.154857 23 3 1 19 Zimbabwe
2948 2948       Madagascar 2020-04-15 22:56:32 -18.766947000000002 46.869107 110 0 29 81 Madagascar
2962 2962       Mozambique 2020-04-15 22:56:32 -18.665695 35.529562 29 0 2 27 Mozambique
2904 2904       Fiji 2020-04-15 22:56:32 -17.7134 178.065 16 0 0 16 Fiji
2776 2776     French Polynesia France 2020-04-15 22:56:32 -17.6797 -149.4068 55 0 0 55 French Polynesia, France
2867 2867       Bolivia 2020-04-15 22:56:32 -16.2902 -63.5887 397 28 7 362 Bolivia
2870 2870       Brazil 2020-04-15 22:56:32 -14.235 -51.9253 28320 1736 14026 12558 Brazil
2988 2988       Samoa 2020-04-15 23:04:09 -13.759 -172.1046 0 0 0 0 Samoa
2949 2949       Malawi 2020-04-15 22:56:32 -13.254307999999998 34.301525 16 2 0 14 Malawi
3027 3027       Zambia 2020-04-15 22:56:32 -13.133897 27.849332 48 2 30 16 Zambia
2804 2804     Mayotte France 2020-04-15 22:56:32 -12.8275 45.166244 217 3 69 145 Mayotte, France
2812 2812     Northern Territory Australia 2020-04-15 23:04:26 -12.4634 130.8456 28 0 6 22 Northern Territory, Australia
2852 2852       Angola 2020-04-15 22:56:32 -11.2027 17.8739 19 2 5 12 Angola
2977 2977       Peru 2020-04-15 22:56:32 -9.19 -75.0152 11475 254 3108 8113 Peru
3012 3012       Timor-Leste 2020-04-15 22:56:32 -8.874217 125.727539 8 0 1 7 Timor-Leste
2826 2826     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-15 22:56:32 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3010 3010       Tanzania 2020-04-15 22:56:32 -6.369028 34.888822 88 4 11 73 Tanzania
2975 2975       Papua New Guinea 2020-04-15 22:56:32 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2994 2994       Seychelles 2020-04-15 22:56:32 -4.6796 55.492 11 0 0 11 Seychelles
2884 2884       Congo (Kinshasa) 2020-04-15 22:56:32 -4.322447 15.307045 254 21 21 212 Congo (Kinshasa)
2883 2883       Congo (Brazzaville) 2020-04-15 22:56:32 -4.2634 15.2832 117 5 11 101 Congo (Brazzaville)
2875 2875       Burundi 2020-04-15 22:56:32 -3.3731 29.9189 5 1 0 4 Burundi

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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