05-05-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,211 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
847 847   Federal Correctional Institution (FCI) Michigan US 2020-05-06 02:32:31     98 2 0 96 Federal Correctional Institution (FCI), Michigan, US
1748 1748   Michigan Department of Corrections (MDOC) Michigan US 2020-05-06 02:32:31     1898 48 0 1850 Michigan Department of Corrections (MDOC), Michigan, US
1999 1999 80008 Out of CO Colorado US 2020-05-06 02:32:31     0 2 0 -2 Out of CO, Colorado, US
2000 2000 80013 Out of GA Georgia US 2020-05-06 02:32:31     1043 18 0 1025 Out of GA, Georgia, US
2001 2001 80015 Out of HI Hawaii US 2020-05-06 02:32:31     10 0 0 10 Out of HI, Hawaii, US
2002 2002 80026 Out of MI Michigan US 2020-05-06 02:32:31     64 0 0 64 Out of MI, Michigan, US
2003 2003 80040 Out of OK Oklahoma US 2020-05-06 02:32:31     0 0 0 0 Out of OK, Oklahoma, US
2004 2004 80047 Out of TN Tennessee US 2020-05-06 02:32:31     356 5 0 351 Out of TN, Tennessee, US
2613 2613 90001 Unassigned Alabama US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Alabama, US
2614 2614 90002 Unassigned Alaska US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Alaska, US
2615 2615 90004 Unassigned Arizona US 2020-05-06 02:32:31     0 2 0 -2 Unassigned, Arizona, US
2616 2616 90005 Unassigned Arkansas US 2020-05-06 02:32:31     163 0 0 163 Unassigned, Arkansas, US
2617 2617 90006 Unassigned California US 2020-05-06 02:32:31     0 2 0 -2 Unassigned, California, US
2618 2618 90008 Unassigned Colorado US 2020-05-06 02:32:31     189 3 0 186 Unassigned, Colorado, US
2619 2619 90009 Unassigned Connecticut US 2020-05-06 02:32:31     368 2 0 366 Unassigned, Connecticut, US
2620 2620 90010 Unassigned Delaware US 2020-05-06 02:32:31     25 0 0 25 Unassigned, Delaware, US
2621 2621 90012 Unassigned Florida US 2020-05-06 02:32:31     17 0 0 17 Unassigned, Florida, US
2622 2622 90013 Unassigned Georgia US 2020-05-06 02:32:31     686 3 0 683 Unassigned, Georgia, US
2623 2623 90015 Unassigned Hawaii US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Hawaii, US
2624 2624 90016 Unassigned Idaho US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Idaho, US
2625 2625 90017 Unassigned Illinois US 2020-05-06 02:32:31     236 0 0 236 Unassigned, Illinois, US
2626 2626 90018 Unassigned Indiana US 2020-05-06 02:32:31     0 30 0 0 Unassigned, Indiana, US
2627 2627 90019 Unassigned Iowa US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Iowa, US
2628 2628 90020 Unassigned Kansas US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Kansas, US
2629 2629 90021 Unassigned Kentucky US 2020-05-06 02:32:31     57 0 0 57 Unassigned, Kentucky, US
2630 2630 90022 Unassigned Louisiana US 2020-05-06 02:32:31     63 73 0 -10 Unassigned, Louisiana, US
2631 2631 90023 Unassigned Maine US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Maine, US
2632 2632 90024 Unassigned Maryland US 2020-05-06 02:32:31     0 87 0 -87 Unassigned, Maryland, US
2633 2633 90025 Unassigned Massachusetts US 2020-05-06 02:32:31     594 7 0 587 Unassigned, Massachusetts, US
2634 2634 90026 Unassigned Michigan US 2020-05-06 02:32:31     13 1 0 12 Unassigned, Michigan, US
2635 2635 90027 Unassigned Minnesota US 2020-05-06 02:32:31     22 1 0 21 Unassigned, Minnesota, US
2636 2636 90028 Unassigned Mississippi US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Mississippi, US
2637 2637 90029 Unassigned Missouri US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Missouri, US
2638 2638 90030 Unassigned Montana US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Montana, US
2639 2639 90031 Unassigned Nebraska US 2020-05-06 02:32:31     0 11 0 -11 Unassigned, Nebraska, US
2640 2640 90032 Unassigned Nevada US 2020-05-06 02:32:31     0 3 0 -3 Unassigned, Nevada, US
2641 2641 90033 Unassigned New Hampshire US 2020-05-06 02:32:31     15 32 0 -17 Unassigned, New Hampshire, US
2642 2642 90034 Unassigned New Jersey US 2020-05-06 02:32:31     550 0 0 550 Unassigned, New Jersey, US
2643 2643 90035 Unassigned New Mexico US 2020-05-06 02:32:31     0 0 0 0 Unassigned, New Mexico, US
2644 2644 90036 Unassigned New York US 2020-05-06 02:32:31     0 0 0 0 Unassigned, New York, US
2645 2645 90037 Unassigned North Carolina US 2020-05-06 02:32:31     0 0 0 0 Unassigned, North Carolina, US
2646 2646 90038 Unassigned North Dakota US 2020-05-06 02:32:31     0 6 0 -6 Unassigned, North Dakota, US
2647 2647 90039 Unassigned Ohio US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Ohio, US
2648 2648 90040 Unassigned Oklahoma US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Oklahoma, US
2649 2649 90041 Unassigned Oregon US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Oregon, US
2650 2650 90042 Unassigned Pennsylvania US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Pennsylvania, US
2651 2651 90044 Unassigned Rhode Island US 2020-05-06 02:32:31     1414 84 0 1059 Unassigned, Rhode Island, US
2652 2652 90045 Unassigned South Carolina US 2020-05-06 02:32:31     0 0 0 0 Unassigned, South Carolina, US
2653 2653 90046 Unassigned South Dakota US 2020-05-06 02:32:31     0 0 0 0 Unassigned, South Dakota, US
2654 2654 90047 Unassigned Tennessee US 2020-05-06 02:32:31     89 0 0 89 Unassigned, Tennessee, US
2655 2655 90048 Unassigned Texas US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Texas, US
2656 2656 90049 Unassigned Utah US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Utah, US
2657 2657 90050 Unassigned Vermont US 2020-05-06 02:32:31     4 0 0 4 Unassigned, Vermont, US
2658 2658 90051 Unassigned Virginia US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Virginia, US
2659 2659 90053 Unassigned Washington US 2020-05-06 02:32:31     37 0 0 37 Unassigned, Washington, US
2660 2660 90054 Unassigned West Virginia US 2020-05-06 02:32:31     0 0 0 0 Unassigned, West Virginia, US
2661 2661 90055 Unassigned Wisconsin US 2020-05-06 02:32:31     0 0 0 0 Unassigned, Wisconsin, US
2662 2662 90056 Unassigned Wyoming US 2020-05-06 02:32:31     0 6 0 -6 Unassigned, Wyoming, US
2952 2952     Diamond Princess Canada 2020-05-06 02:32:31     1 1 0 0 Diamond Princess, Canada
2953 2953 88888   Diamond Princess US 2020-05-06 02:32:31     49 0 0 49 Diamond Princess, US
2961 2961     Grand Princess Canada 2020-05-06 02:32:31     13 0 0 13 Grand Princess, Canada
2962 2962 99999   Grand Princess US 2020-05-06 02:32:31     103 3 0 100 Grand Princess, US
3003 3003     Recovered Canada 2020-05-06 02:32:31     0 0 27006 -27006 Recovered, Canada
3004 3004     Recovered US 2020-05-06 02:32:31     0 0 189791 -160761 Recovered, US
3074 3074       Diamond Princess 2020-05-06 02:32:31     712 13 645 54 Diamond Princess
3129 3129       MS Zaandam 2020-05-06 02:32:31     9 2 0 7 MS Zaandam
2954 2954     Falkland Islands (Malvinas) United Kingdom 2020-05-06 02:32:31 -51.7963 -59.5236 13 0 13 0 Falkland Islands (Malvinas), United Kingdom
3018 3018     Tasmania Australia 2020-05-06 02:32:31 -42.8821 147.3272 225 13 165 47 Tasmania, Australia
3148 3148       New Zealand 2020-05-06 02:32:31 -40.9006 174.886 1488 21 1316 151 New Zealand
3035 3035       Argentina 2020-05-06 02:32:31 -38.4161 -63.6167 5020 264 1472 3284 Argentina
3022 3022     Victoria Australia 2020-05-06 02:32:31 -37.8136 144.9631 1440 18 1321 101 Victoria, Australia
3062 3062       Chile 2020-05-06 02:32:31 -35.6751 -71.543 22016 275 10710 11031 Chile
2942 2942     Australian Capital Territory Australia 2020-05-06 02:32:31 -35.4735 149.0124 107 3 103 1 Australian Capital Territory, Australia
3016 3016     South Australia Australia 2020-05-06 02:32:31 -34.9285 138.6007 438 4 429 5 South Australia, Australia
2989 2989     New South Wales Australia 2020-05-06 02:32:31 -33.8688 151.2093 3042 44 2418 580 New South Wales, Australia
3204 3204       Uruguay 2020-05-06 02:32:31 -32.5228 -55.7658 670 17 468 185 Uruguay
3024 3024     Western Australia Australia 2020-05-06 02:32:31 -31.9505 115.8605 551 9 528 14 Western Australia, Australia
3182 3182       South Africa 2020-05-06 02:32:31 -30.5595 22.9375 7572 148 2746 4678 South Africa
3002 3002     Queensland Australia 2020-05-06 02:32:31 -27.4698 153.0251 1043 6 985 52 Queensland, Australia
3084 3084       Eswatini 2020-05-06 02:32:31 -26.5225 31.4659 119 1 12 106 Eswatini
3158 3158       Paraguay 2020-05-06 02:32:31 -23.4425 -58.4438 431 10 135 286 Paraguay
3145 3145       Namibia 2020-05-06 02:32:31 -22.9576 18.4904 16 0 8 8 Namibia
3050 3050       Botswana 2020-05-06 02:32:31 -22.3285 24.6849 23 1 8 14 Botswana
3005 3005     Reunion France 2020-05-06 02:32:31 -21.1151 55.5364 424 0 300 124 Reunion, France
2988 2988     New Caledonia France 2020-05-06 02:32:31 -20.904304999999997 165.618042 18 0 17 1 New Caledonia, France
3137 3137       Mauritius 2020-05-06 02:32:31 -20.348404000000002 57.552152 332 10 319 3 Mauritius
3211 3211       Zimbabwe 2020-05-06 02:32:31 -19.015438 29.154857 34 4 5 25 Zimbabwe
3130 3130       Madagascar 2020-05-06 02:32:31 -18.766947000000002 46.869107 151 0 101 50 Madagascar
3144 3144       Mozambique 2020-05-06 02:32:31 -18.665695 35.529562 81 0 19 62 Mozambique
3086 3086       Fiji 2020-05-06 02:32:31 -17.7134 178.065 18 0 14 4 Fiji
2957 2957     French Polynesia France 2020-05-06 02:32:31 -17.6797 -149.4068 60 0 54 6 French Polynesia, France
3048 3048       Bolivia 2020-05-06 02:32:31 -16.2902 -63.5887 1802 86 187 1529 Bolivia
3051 3051       Brazil 2020-05-06 02:32:31 -14.235 -51.9253 115455 7938 48221 59296 Brazil
3170 3170       Samoa 2020-05-06 02:32:31 -13.759 -172.1046 0 0 0 0 Samoa
3131 3131       Malawi 2020-05-06 02:32:31 -13.254307999999998 34.301525 41 3 9 29 Malawi
3210 3210       Zambia 2020-05-06 02:32:31 -13.133897 27.849332 138 3 92 43 Zambia
2985 2985     Mayotte France 2020-05-06 02:32:31 -12.8275 45.166244 739 9 352 378 Mayotte, France
2993 2993     Northern Territory Australia 2020-05-06 02:32:31 -12.4634 130.8456 29 0 26 3 Northern Territory, Australia
3064 3064       Comoros 2020-05-06 02:32:31 -11.6455 43.3333 3 0 0 3 Comoros
3033 3033       Angola 2020-05-06 02:32:31 -11.2027 17.8739 36 2 11 23 Angola

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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