04-24-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,128 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
823 823   Federal Correctional Institution (FCI) Michigan US 2020-04-25 06:30:53     68 0 0 68 Federal Correctional Institution (FCI), Michigan, US
1698 1698   Michigan Department of Corrections (MDOC) Michigan US 2020-04-25 06:30:53     973 28 0 945 Michigan Department of Corrections (MDOC), Michigan, US
1946 1946 80008 Out of CO Colorado US 2020-04-25 06:30:53     0 2 0 -2 Out of CO, Colorado, US
1947 1947 80013 Out of GA Georgia US 2020-04-25 06:30:53     916 10 0 906 Out of GA, Georgia, US
1948 1948 80015 Out of HI Hawaii US 2020-04-25 06:30:53     6 0 0 6 Out of HI, Hawaii, US
1949 1949 80026 Out of MI Michigan US 2020-04-25 06:30:53     14 1 0 13 Out of MI, Michigan, US
1950 1950 80040 Out of OK Oklahoma US 2020-04-25 06:30:53     0 0 0 0 Out of OK, Oklahoma, US
1951 1951 80047 Out of TN Tennessee US 2020-04-25 06:30:53     260 1 0 259 Out of TN, Tennessee, US
2353 2353 90049 Southwest Utah US 2020-04-25 06:30:53     0 0 0 0 Southwest, Utah, US
2543 2543 90001 Unassigned Alabama US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Alabama, US
2544 2544 90002 Unassigned Alaska US 2020-04-25 06:30:53     0 4 0 -4 Unassigned, Alaska, US
2545 2545 90004 Unassigned Arizona US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Arizona, US
2546 2546 90005 Unassigned Arkansas US 2020-04-25 06:30:53     182 0 0 182 Unassigned, Arkansas, US
2547 2547 90006 Unassigned California US 2020-04-25 06:30:53     0 2 0 -2 Unassigned, California, US
2548 2548 90008 Unassigned Colorado US 2020-04-25 06:30:53     103 2 0 101 Unassigned, Colorado, US
2549 2549 90009 Unassigned Connecticut US 2020-04-25 06:30:53     522 6 0 516 Unassigned, Connecticut, US
2550 2550 90010 Unassigned Delaware US 2020-04-25 06:30:53     4 0 0 4 Unassigned, Delaware, US
2551 2551 90012 Unassigned Florida US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Florida, US
2552 2552 90013 Unassigned Georgia US 2020-04-25 06:30:53     447 0 0 447 Unassigned, Georgia, US
2553 2553 90015 Unassigned Hawaii US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Hawaii, US
2554 2554 90016 Unassigned Idaho US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Idaho, US
2555 2555 90017 Unassigned Illinois US 2020-04-25 06:30:53     218 1 0 217 Unassigned, Illinois, US
2556 2556 90018 Unassigned Indiana US 2020-04-25 06:30:53     0 175 0 0 Unassigned, Indiana, US
2557 2557 90019 Unassigned Iowa US 2020-04-25 06:30:53     4 0 0 4 Unassigned, Iowa, US
2558 2558 90020 Unassigned Kansas US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Kansas, US
2559 2559 90021 Unassigned Kentucky US 2020-04-25 06:30:53     58 0 0 58 Unassigned, Kentucky, US
2560 2560 90022 Unassigned Louisiana US 2020-04-25 06:30:53     63 59 0 4 Unassigned, Louisiana, US
2561 2561 90023 Unassigned Maine US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Maine, US
2562 2562 90024 Unassigned Maryland US 2020-04-25 06:31:05     0 111 0 -111 Unassigned, Maryland, US
2563 2563 90025 Unassigned Massachusetts US 2020-04-25 06:30:53     791 603 0 188 Unassigned, Massachusetts, US
2564 2564 90026 Unassigned Michigan US 2020-04-25 06:30:53     9 1 0 8 Unassigned, Michigan, US
2565 2565 90027 Unassigned Minnesota US 2020-04-25 06:30:53     6 0 0 6 Unassigned, Minnesota, US
2566 2566 90028 Unassigned Mississippi US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Mississippi, US
2567 2567 90029 Unassigned Missouri US 2020-04-25 06:30:53     1 0 0 1 Unassigned, Missouri, US
2568 2568 90030 Unassigned Montana US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Montana, US
2569 2569 90031 Unassigned Nebraska US 2020-04-25 06:30:53     0 12 0 -12 Unassigned, Nebraska, US
2570 2570 90032 Unassigned Nevada US 2020-04-25 06:30:53     65 2 0 63 Unassigned, Nevada, US
2571 2571 90033 Unassigned New Hampshire US 2020-04-25 06:30:53     3 50 0 -47 Unassigned, New Hampshire, US
2572 2572 90034 Unassigned New Jersey US 2020-04-25 06:30:53     532 0 0 532 Unassigned, New Jersey, US
2573 2573 90035 Unassigned New Mexico US 2020-04-25 06:30:53     0 0 0 0 Unassigned, New Mexico, US
2574 2574 90036 Unassigned New York US 2020-04-25 06:30:53     0 0 0 0 Unassigned, New York, US
2575 2575 90037 Unassigned North Carolina US 2020-04-25 06:30:53     0 0 0 0 Unassigned, North Carolina, US
2576 2576 90038 Unassigned North Dakota US 2020-04-25 06:30:53     0 0 0 0 Unassigned, North Dakota, US
2577 2577 90039 Unassigned Ohio US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Ohio, US
2578 2578 90040 Unassigned Oklahoma US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Oklahoma, US
2579 2579 90041 Unassigned Oregon US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Oregon, US
2580 2580 90042 Unassigned Pennsylvania US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Pennsylvania, US
2581 2581 90044 Unassigned Rhode Island US 2020-04-25 06:30:53     1132 130 0 930 Unassigned, Rhode Island, US
2582 2582 90045 Unassigned South Carolina US 2020-04-25 06:30:53     0 0 0 0 Unassigned, South Carolina, US
2583 2583 90046 Unassigned South Dakota US 2020-04-25 06:30:53     0 0 0 0 Unassigned, South Dakota, US
2584 2584 90047 Unassigned Tennessee US 2020-04-25 06:30:53     19 0 0 19 Unassigned, Tennessee, US
2585 2585 90048 Unassigned Texas US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Texas, US
2586 2586 90049 Unassigned Utah US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Utah, US
2587 2587 90050 Unassigned Vermont US 2020-04-25 06:30:53     3 0 0 3 Unassigned, Vermont, US
2588 2588 90051 Unassigned Virginia US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Virginia, US
2589 2589 90053 Unassigned Washington US 2020-04-24 00:00:00     100 0 0 100 Unassigned, Washington, US
2590 2590 90054 Unassigned West Virginia US 2020-04-25 06:30:53     0 0 0 0 Unassigned, West Virginia, US
2591 2591 90055 Unassigned Wisconsin US 2020-04-25 06:30:53     0 0 0 0 Unassigned, Wisconsin, US
2592 2592 90056 Unassigned Wyoming US 2020-04-25 06:30:53     0 6 0 -6 Unassigned, Wyoming, US
2874 2874     Diamond Princess Canada 2020-04-25 06:30:55     0 1 0 0 Diamond Princess, Canada
2875 2875 88888   Diamond Princess US 2020-04-25 06:30:53     49 0 0 49 Diamond Princess, US
2883 2883 99999   Grand Princess US 2020-04-25 06:30:53     103 3 0 100 Grand Princess, US
2919 2919     Recovered Canada 2020-04-25 06:30:55     0 0 15149 -15149 Recovered, Canada
2920 2920     Recovered US 2020-04-25 06:30:53     0 0 99079 -99079 Recovered, US
2984 2984       Diamond Princess 2020-04-25 06:30:33     712 13 645 54 Diamond Princess
3039 3039       MS Zaandam 2020-04-25 06:30:33     9 2 0 7 MS Zaandam
2876 2876     Falkland Islands (Malvinas) United Kingdom 2020-04-25 06:30:33 -51.7963 -59.5236 13 0 11 2 Falkland Islands (Malvinas), United Kingdom
3126 3126     Tasmania Australia 2020-04-25 06:31:19 -42.8821 147.3272 207 9 67 131 Tasmania, Australia
3058 3058       New Zealand 2020-04-25 06:30:33 -40.9006 174.886 1461 18 1118 325 New Zealand
2946 2946       Argentina 2020-04-25 06:30:33 -38.4161 -63.6167 3607 176 976 2455 Argentina
3127 3127     Victoria Australia 2020-04-25 06:31:19 -37.8136 144.9631 1343 16 1172 155 Victoria, Australia
2973 2973       Chile 2020-04-25 06:30:33 -35.6751 -71.543 12306 174 6327 5805 Chile
3121 3121     Australian Capital Territory Australia 2020-04-25 06:31:19 -35.4735 149.0124 105 3 88 14 Australian Capital Territory, Australia
3125 3125     South Australia Australia 2020-04-25 06:31:19 -34.9285 138.6007 438 4 331 103 South Australia, Australia
3122 3122     New South Wales Australia 2020-04-25 06:31:19 -33.8688 151.2093 2982 33 1379 1570 New South Wales, Australia
3113 3113       Uruguay 2020-04-25 06:30:33 -32.5228 -55.7658 563 12 369 182 Uruguay
3128 3128     Western Australia Australia 2020-04-25 06:31:19 -31.9505 115.8605 548 8 340 200 Western Australia, Australia
3092 3092       South Africa 2020-04-25 06:30:33 -30.5595 22.9375 4220 79 1473 2668 South Africa
3124 3124     Queensland Australia 2020-04-25 06:31:19 -27.4698 153.0251 1026 6 738 282 Queensland, Australia
2994 2994       Eswatini 2020-04-25 06:30:33 -26.5225 31.4659 36 1 10 25 Eswatini
3068 3068       Paraguay 2020-04-25 06:30:33 -23.4425 -58.4438 223 9 78 136 Paraguay
3055 3055       Namibia 2020-04-25 06:30:33 -22.9576 18.4904 16 0 7 9 Namibia
2961 2961       Botswana 2020-04-25 06:30:33 -22.3285 24.6849 22 1 0 21 Botswana
2921 2921     Reunion France 2020-04-25 06:30:33 -21.1151 55.5364 412 0 300 112 Reunion, France
2909 2909     New Caledonia France 2020-04-25 06:30:33 -20.904304999999997 165.618042 18 0 17 1 New Caledonia, France
3047 3047       Mauritius 2020-04-25 06:30:33 -20.348404000000002 57.552152 331 9 285 37 Mauritius
3120 3120       Zimbabwe 2020-04-25 06:30:33 -19.015438 29.154857 29 4 2 23 Zimbabwe
3040 3040       Madagascar 2020-04-25 06:30:33 -18.766947000000002 46.869107 122 0 61 61 Madagascar
3054 3054       Mozambique 2020-04-25 06:30:33 -18.665695 35.529562 65 0 12 53 Mozambique
2996 2996       Fiji 2020-04-25 06:30:33 -17.7134 178.065 18 0 10 8 Fiji
2879 2879     French Polynesia France 2020-04-25 06:30:33 -17.6797 -149.4068 57 0 41 16 French Polynesia, France
2959 2959       Bolivia 2020-04-25 06:30:33 -16.2902 -63.5887 807 44 54 709 Bolivia
2962 2962       Brazil 2020-04-25 06:30:33 -14.235 -51.9253 54043 3704 27655 22684 Brazil
3080 3080       Samoa 2020-04-25 06:30:33 -13.759 -172.1046 0 0 0 0 Samoa
3041 3041       Malawi 2020-04-25 06:30:33 -13.254307999999998 34.301525 33 3 4 26 Malawi
3119 3119       Zambia 2020-04-25 06:30:33 -13.133897 27.849332 84 3 37 44 Zambia
2906 2906     Mayotte France 2020-04-25 06:30:33 -12.8275 45.166244 354 4 144 206 Mayotte, France
3123 3123     Northern Territory Australia 2020-04-25 06:31:19 -12.4634 130.8456 28 0 9 19 Northern Territory, Australia
2944 2944       Angola 2020-04-25 06:30:33 -11.2027 17.8739 25 2 6 17 Angola
3069 3069       Peru 2020-04-25 06:30:33 -9.19 -75.0152 21648 634 7496 13518 Peru

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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