04-22-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,101 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
818 818   Federal Correctional Institution (FCI) Michigan US 2020-04-22 23:30:53     57 0 0 57 Federal Correctional Institution (FCI), Michigan, US
1685 1685   Michigan Department of Corrections (MDOC) Michigan US 2020-04-22 23:30:53     655 25 0 630 Michigan Department of Corrections (MDOC), Michigan, US
1930 1930 80013 Out of GA Georgia US 2020-04-22 23:30:53     1003 9 0 994 Out of GA, Georgia, US
1931 1931 80015 Out of HI Hawaii US 2020-04-22 23:30:53     6 0 0 6 Out of HI, Hawaii, US
1932 1932 80026 Out of MI Michigan US 2020-04-22 23:30:53     37 1 0 36 Out of MI, Michigan, US
1933 1933 80040 Out of OK Oklahoma US 2020-04-22 23:30:53     0 0 0 0 Out of OK, Oklahoma, US
1934 1934 80047 Out of TN Tennessee US 2020-04-22 23:30:53     265 1 0 264 Out of TN, Tennessee, US
2520 2520 90001 Unassigned Alabama US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Alabama, US
2521 2521 90002 Unassigned Alaska US 2020-04-22 23:30:53     0 4 0 -4 Unassigned, Alaska, US
2522 2522 90004 Unassigned Arizona US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Arizona, US
2523 2523 90005 Unassigned Arkansas US 2020-04-22 23:30:53     95 0 0 95 Unassigned, Arkansas, US
2524 2524 90006 Unassigned California US 2020-04-22 23:30:53     0 2 0 -2 Unassigned, California, US
2525 2525 90008 Unassigned Colorado US 2020-04-22 23:30:53     95 1 0 94 Unassigned, Colorado, US
2526 2526 90009 Unassigned Connecticut US 2020-04-22 23:30:53     550 4 0 546 Unassigned, Connecticut, US
2527 2527 90010 Unassigned Delaware US 2020-04-22 23:30:53     28 0 0 28 Unassigned, Delaware, US
2528 2528 90012 Unassigned Florida US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Florida, US
2529 2529 90013 Unassigned Georgia US 2020-04-22 23:30:53     667 0 0 667 Unassigned, Georgia, US
2530 2530 90015 Unassigned Hawaii US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Hawaii, US
2531 2531 90016 Unassigned Idaho US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Idaho, US
2532 2532 90017 Unassigned Illinois US 2020-04-22 23:30:53     228 1 0 227 Unassigned, Illinois, US
2533 2533 90018 Unassigned Indiana US 2020-04-22 23:30:53     0 175 0 0 Unassigned, Indiana, US
2534 2534 90019 Unassigned Iowa US 2020-04-22 23:30:53     4 0 0 4 Unassigned, Iowa, US
2535 2535 90020 Unassigned Kansas US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Kansas, US
2536 2536 90021 Unassigned Kentucky US 2020-04-22 23:30:53     72 0 0 72 Unassigned, Kentucky, US
2537 2537 90022 Unassigned Louisiana US 2020-04-22 23:30:53     60 1 0 59 Unassigned, Louisiana, US
2538 2538 90023 Unassigned Maine US 2020-04-22 23:30:53     2 0 0 2 Unassigned, Maine, US
2539 2539 90024 Unassigned Maryland US 2020-04-22 23:38:40     0 108 0 -108 Unassigned, Maryland, US
2540 2540 90025 Unassigned Massachusetts US 2020-04-22 23:30:53     854 229 0 625 Unassigned, Massachusetts, US
2541 2541 90026 Unassigned Michigan US 2020-04-22 23:30:53     3 0 0 3 Unassigned, Michigan, US
2542 2542 90027 Unassigned Minnesota US 2020-04-22 23:30:53     4 0 0 4 Unassigned, Minnesota, US
2543 2543 90028 Unassigned Mississippi US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Mississippi, US
2544 2544 90029 Unassigned Missouri US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Missouri, US
2545 2545 90030 Unassigned Montana US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Montana, US
2546 2546 90031 Unassigned Nebraska US 2020-04-22 23:30:53     12 20 0 -8 Unassigned, Nebraska, US
2547 2547 90032 Unassigned Nevada US 2020-04-22 23:30:53     6 0 0 6 Unassigned, Nevada, US
2548 2548 90033 Unassigned New Hampshire US 2020-04-22 23:30:53     17 45 0 -28 Unassigned, New Hampshire, US
2549 2549 90034 Unassigned New Jersey US 2020-04-22 23:30:53     1045 0 0 1045 Unassigned, New Jersey, US
2550 2550 90035 Unassigned New Mexico US 2020-04-22 23:30:53     0 0 0 0 Unassigned, New Mexico, US
2551 2551 90036 Unassigned New York US 2020-04-22 23:30:53     0 0 0 0 Unassigned, New York, US
2552 2552 90037 Unassigned North Carolina US 2020-04-22 23:30:53     0 0 0 0 Unassigned, North Carolina, US
2553 2553 90039 Unassigned Ohio US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Ohio, US
2554 2554 90040 Unassigned Oklahoma US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Oklahoma, US
2555 2555 90041 Unassigned Oregon US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Oregon, US
2556 2556 90042 Unassigned Pennsylvania US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Pennsylvania, US
2557 2557 90044 Unassigned Rhode Island US 2020-04-22 23:30:53     895 100 0 717 Unassigned, Rhode Island, US
2558 2558 90046 Unassigned South Dakota US 2020-04-22 23:30:53     0 0 0 0 Unassigned, South Dakota, US
2559 2559 90047 Unassigned Tennessee US 2020-04-22 23:30:53     36 0 0 36 Unassigned, Tennessee, US
2560 2560 90049 Unassigned Utah US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Utah, US
2561 2561 90050 Unassigned Vermont US 2020-04-22 23:30:53     3 0 0 3 Unassigned, Vermont, US
2562 2562 90051 Unassigned Virginia US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Virginia, US
2563 2563 90053 Unassigned Washington US 2020-04-22 23:30:53     159 0 0 159 Unassigned, Washington, US
2564 2564 90054 Unassigned West Virginia US 2020-04-22 23:30:53     0 20 0 -20 Unassigned, West Virginia, US
2565 2565 90055 Unassigned Wisconsin US 2020-04-22 23:30:53     0 0 0 0 Unassigned, Wisconsin, US
2566 2566 90056 Unassigned Wyoming US 2020-04-22 23:30:53     0 5 0 -5 Unassigned, Wyoming, US
2846 2846 88888   Diamond Princess US 2020-04-22 23:30:53     49 0 0 49 Diamond Princess, US
2854 2854 99999   Grand Princess US 2020-04-22 23:30:53     103 0 0 103 Grand Princess, US
2895 2895     Recovered Canada 2020-04-22 23:38:42     0 0 14454 -14454 Recovered, Canada
2896 2896     Recovered US 2020-04-22 23:30:53     0 0 77366 -77366 Recovered, US
2965 2965       Diamond Princess 2020-04-22 23:30:32     712 13 644 55 Diamond Princess
3020 3020       MS Zaandam 2020-04-22 23:30:32     9 2 0 7 MS Zaandam
2847 2847     Falkland Islands (Malvinas) United Kingdom 2020-04-22 23:30:32 -51.7963 -59.5236 11 0 3 8 Falkland Islands (Malvinas), United Kingdom
2910 2910     Tasmania Australia 2020-04-22 23:38:57 -42.8821 147.3272 180 7 67 106 Tasmania, Australia
3039 3039       New Zealand 2020-04-22 23:30:32 -40.9006 174.886 1451 14 1036 401 New Zealand
2927 2927       Argentina 2020-04-22 23:30:32 -38.4161 -63.6167 3144 152 872 2120 Argentina
2914 2914     Victoria Australia 2020-04-22 23:38:57 -37.8136 144.9631 1319 14 1172 133 Victoria, Australia
2954 2954       Chile 2020-04-22 23:30:32 -35.6751 -71.543 11296 160 5386 5750 Chile
2836 2836     Australian Capital Territory Australia 2020-04-22 23:38:57 -35.4735 149.0124 103 3 88 12 Australian Capital Territory, Australia
2908 2908     South Australia Australia 2020-04-22 23:38:57 -34.9285 138.6007 435 4 331 100 South Australia, Australia
2881 2881     New South Wales Australia 2020-04-22 23:38:57 -33.8688 151.2093 2926 26 1379 1521 New South Wales, Australia
3094 3094       Uruguay 2020-04-22 23:30:32 -32.5228 -55.7658 543 12 324 207 Uruguay
2916 2916     Western Australia Australia 2020-04-22 23:38:57 -31.9505 115.8605 541 7 340 194 Western Australia, Australia
3073 3073       South Africa 2020-04-22 23:30:32 -30.5595 22.9375 3635 65 1055 2515 South Africa
2894 2894     Queensland Australia 2020-04-22 23:38:57 -27.4698 153.0251 1015 6 738 271 Queensland, Australia
2975 2975       Eswatini 2020-04-22 23:30:32 -26.5225 31.4659 31 1 8 22 Eswatini
3049 3049       Paraguay 2020-04-22 23:30:32 -23.4425 -58.4438 213 9 62 142 Paraguay
3036 3036       Namibia 2020-04-22 23:30:32 -22.9576 18.4904 16 0 6 10 Namibia
2942 2942       Botswana 2020-04-22 23:30:32 -22.3285 24.6849 22 1 0 21 Botswana
2897 2897     Reunion France 2020-04-22 23:30:32 -21.1151 55.5364 410 0 238 172 Reunion, France
2880 2880     New Caledonia France 2020-04-22 23:30:32 -20.904304999999997 165.618042 18 0 17 1 New Caledonia, France
3028 3028       Mauritius 2020-04-22 23:30:32 -20.348404000000002 57.552152 329 9 261 59 Mauritius
3101 3101       Zimbabwe 2020-04-22 23:30:32 -19.015438 29.154857 28 4 2 22 Zimbabwe
3021 3021       Madagascar 2020-04-22 23:30:32 -18.766947000000002 46.869107 121 0 52 69 Madagascar
3035 3035       Mozambique 2020-04-22 23:30:32 -18.665695 35.529562 41 0 8 33 Mozambique
2977 2977       Fiji 2020-04-22 23:30:32 -17.7134 178.065 18 0 8 10 Fiji
2850 2850     French Polynesia France 2020-04-22 23:30:32 -17.6797 -149.4068 57 0 35 22 French Polynesia, France
2940 2940       Bolivia 2020-04-22 23:30:32 -16.2902 -63.5887 609 37 44 528 Bolivia
2943 2943       Brazil 2020-04-22 23:30:32 -14.235 -51.9253 45757 2906 25318 17533 Brazil
3061 3061       Samoa 2020-04-22 23:38:42 -13.759 -172.1046 0 0 0 0 Samoa
3022 3022       Malawi 2020-04-22 23:30:32 -13.254307999999998 34.301525 23 3 3 17 Malawi
3100 3100       Zambia 2020-04-22 23:30:32 -13.133897 27.849332 74 3 35 36 Zambia
2877 2877     Mayotte France 2020-04-22 23:30:32 -12.8275 45.166244 326 4 125 197 Mayotte, France
2885 2885     Northern Territory Australia 2020-04-22 23:38:57 -12.4634 130.8456 28 0 9 19 Northern Territory, Australia
2925 2925       Angola 2020-04-22 23:30:32 -11.2027 17.8739 25 2 6 17 Angola
3050 3050       Peru 2020-04-22 23:30:32 -9.19 -75.0152 19250 530 7027 11693 Peru
3085 3085       Timor-Leste 2020-04-22 23:30:32 -8.874217 125.727539 23 0 1 22 Timor-Leste
2899 2899     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-22 23:30:32 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3083 3083       Tanzania 2020-04-22 23:30:32 -6.369028 34.888822 284 10 11 263 Tanzania
3048 3048       Papua New Guinea 2020-04-22 23:30:32 -6.314993 143.95555 8 0 0 8 Papua New Guinea
3067 3067       Seychelles 2020-04-22 23:30:32 -4.6796 55.492 11 0 5 6 Seychelles
2957 2957       Congo (Kinshasa) 2020-04-22 23:30:32 -4.322447 15.307045 359 25 45 289 Congo (Kinshasa)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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