04-07-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

2,858 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
1506 1506   McIntosh Georgia US 2020-04-07 23:04:49     3 0 0 0 McIntosh,Georgia,US
1769 1769 80008 Out of CO Colorado US 2020-04-07 23:04:49     0 1 0 0 Out of CO,Colorado,US
1770 1770 80015 Out of HI Hawaii US 2020-04-07 23:04:49     2 0 0 0 Out of HI,Hawaii,US
1771 1771   Out of MI Michigan US 2020-04-07 23:04:49     118 1 0 0 Out of MI,Michigan,US
1772 1772 80040 Out of OK Oklahoma US 2020-04-07 23:04:49     2 0 0 0 Out of OK,Oklahoma,US
1773 1773   Out of TN Tennessee US 2020-04-07 23:04:49     290 1 0 0 Out of TN,Tennessee,US
2300 2300 90002 Unassigned Alaska US 2020-04-07 23:04:49     0 1 0 0 Unassigned, Alaska, US
2301 2301 90004 Unassigned Arizona US 2020-04-07 23:04:49     0 14 0 0 Unassigned, Arizona, US
2302 2302 90005 Unassigned Arkansas US 2020-04-07 23:04:49     44 12 0 0 Unassigned, Arkansas, US
2303 2303 90006 Unassigned California US 2020-04-07 23:04:49     42 0 0 0 Unassigned, California, US
2304 2304 90008 Unassigned Colorado US 2020-04-07 23:04:49     252 29 0 0 Unassigned, Colorado, US
2305 2305 90009 Unassigned Connecticut US 2020-04-07 23:04:49     292 3 0 0 Unassigned, Connecticut, US
2306 2306 90010 Unassigned Delaware US 2020-04-07 23:04:49     0 10 0 0 Unassigned, Delaware, US
2307 2307 90012 Unassigned Florida US 2020-04-07 23:04:49     2 29 0 0 Unassigned,Florida,US
2308 2308 90013 Unassigned Georgia US 2020-04-07 23:04:49     489 7 0 0 Unassigned,Georgia,US
2309 2309 90015 Unassigned Hawaii US 2020-04-07 23:04:49     7 0 0 0 Unassigned, Hawaii, US
2310 2310 90016 Unassigned Idaho US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Idaho, US
2311 2311 90017 Unassigned Illinois US 2020-04-07 23:04:49     72 1 0 0 Unassigned, Illinois, US
2312 2312 90018 Unassigned Indiana US 2020-04-07 23:04:49     0 136 0 0 Unassigned, Indiana, US
2313 2313 90019 Unassigned Iowa US 2020-04-07 23:04:49     0 1 0 0 Unassigned, Iowa, US
2314 2314 90020 Unassigned Kansas US 2020-04-07 23:04:49     0 5 0 0 Unassigned,Kansas,US
2315 2315 90021 Unassigned Kentucky US 2020-04-07 23:04:49     152 5 0 0 Unassigned, Kentucky, US
2316 2316   Unassigned Louisiana US 2020-04-07 23:04:49     49 2 0 0 Unassigned,Louisiana,US
2317 2317 90023 Unassigned Maine US 2020-04-07 23:04:49     9 0 0 0 Unassigned, Maine, US
2318 2318 90024 Unassigned Maryland US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Maryland, US
2319 2319 90025 Unassigned Massachusetts US 2020-04-07 23:04:49     229 11 0 0 Unassigned, Massachusetts, US
2320 2320 90026 Unassigned Michigan US 2020-04-07 23:04:49     409 3 0 0 Unassigned,Michigan,US
2321 2321 90027 Unassigned Minnesota US 2020-04-07 23:04:49     6 0 0 0 Unassigned, Minnesota, US
2322 2322 90029 Unassigned Missouri US 2020-04-07 23:04:49     1 1 0 0 Unassigned, Missouri, US
2323 2323 90030 Unassigned Montana US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Montana, US
2324 2324 90031 Unassigned Nebraska US 2020-04-07 23:04:49     1 1 0 0 Unassigned, Nebraska, US
2325 2325 90032 Unassigned Nevada US 2020-04-07 23:04:49     33 12 0 0 Unassigned, Nevada, US
2326 2326 90033 Unassigned New Hampshire US 2020-04-07 23:04:49     1 6 0 0 Unassigned, New Hampshire, US
2327 2327 90034 Unassigned New Jersey US 2020-04-07 23:04:49     2207 5 0 0 Unassigned, New Jersey, US
2328 2328 90035 Unassigned New Mexico US 2020-04-07 23:04:49     0 0 0 0 Unassigned, New Mexico, US
2329 2329 90036 Unassigned New York US 2020-04-07 23:04:49     0 116 0 0 Unassigned, New York, US
2330 2330 90037 Unassigned North Carolina US 2020-04-07 23:04:49     0 2 0 0 Unassigned, North Carolina, US
2331 2331 90038 Unassigned North Dakota US 2020-04-07 23:04:49     0 0 0 0 Unassigned, North Dakota, US
2332 2332 90039 Unassigned Ohio US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Ohio, US
2333 2333 90040 Unassigned Oklahoma US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Oklahoma, US
2334 2334 90042 Unassigned Pennsylvania US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Pennsylvania, US
2335 2335 90044 Unassigned Rhode Island US 2020-04-07 23:04:49     353 21 0 0 Unassigned, Rhode Island, US
2336 2336 90046 Unassigned South Dakota US 2020-04-07 23:04:49     0 0 0 0 Unassigned, South Dakota, US
2337 2337 90047 Unassigned Tennessee US 2020-04-07 23:04:49     59 0 0 0 Unassigned, Tennessee, US
2338 2338 90049 Unassigned Utah US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Utah,US
2339 2339 90050 Unassigned Vermont US 2020-04-07 23:04:49     3 18 0 0 Unassigned, Vermont, US
2340 2340 90051 Unassigned Virginia US 2020-04-07 23:04:49     0 50 0 0 Unassigned, Virginia, US
2341 2341 90053 Unassigned Washington US 2020-04-07 23:04:49     677 0 0 0 Unassigned, Washington, US
2342 2342 90055 Unassigned Wisconsin US 2020-04-07 23:04:49     0 0 0 0 Unassigned, Wisconsin, US
2343 2343   Unassigned Wyoming US 2020-04-07 23:04:49     0 0 0 0 Unassigned,Wyoming,US
2602 2602     Diamond Princess Canada 2020-04-07 23:11:15     0 1 0 0 Diamond Princess, Canada
2603 2603 88888   Diamond Princess US 2020-04-07 23:04:49     49 0 0 0 Diamond Princess, US
2611 2611     Grand Princess Canada 2020-04-07 23:11:15     13 0 0 0 Grand Princess, Canada
2612 2612 99999   Grand Princess US 2020-04-07 23:04:49     103 3 0 0 Grand Princess, US
2653 2653     Recovered Canada 2020-04-07 23:11:15     0 0 3791 0 Recovered, Canada
2654 2654     Recovered US 2020-04-07 23:04:49     0 0 21763 0 Recovered, US
2723 2723       Diamond Princess 2020-04-07 23:04:29     712 11 619 82 Diamond Princess
2778 2778       MS Zaandam 2020-04-07 23:04:29     9 2 0 7 ,,MS Zaandam
2604 2604     Falkland Islands (Malvinas) United Kingdom 2020-04-07 23:04:29 -51.7963 -59.5236 2 0 0 2 Falkland Islands (Malvinas), United Kingdom
2668 2668     Tasmania Australia 2020-04-07 23:11:31 -42.8821 147.3272 89 2 26 61 Tasmania, Australia
2797 2797       New Zealand 2020-04-07 23:04:29 -40.9006 174.886 1160 1 241 918 New Zealand
2685 2685       Argentina 2020-04-07 23:04:29 -38.4161 -63.6167 1628 56 338 1234 Argentina
2672 2672     Victoria Australia 2020-04-07 23:11:31 -37.8136 144.9631 1191 11 620 560 Victoria, Australia
2712 2712       Chile 2020-04-07 23:04:29 -35.6751 -71.543 5116 43 898 4175 Chile
2592 2592     Australian Capital Territory Australia 2020-04-07 23:11:31 -35.4735 149.0124 96 2 40 54 Australian Capital Territory, Australia
2666 2666     South Australia Australia 2020-04-07 23:11:31 -34.9285 138.6007 411 1 53 357 South Australia, Australia
2639 2639     New South Wales Australia 2020-04-07 23:11:31 -33.8688 151.2093 2686 21 4 2661 New South Wales, Australia
2852 2852       Uruguay 2020-04-07 23:04:29 -32.5228 -55.7658 424 7 150 267 Uruguay
2674 2674     Western Australia Australia 2020-04-07 23:11:31 -31.9505 115.8605 460 4 162 294 Western Australia, Australia
2831 2831       South Africa 2020-04-07 23:04:29 -30.5595 22.9375 1749 13 95 1641 South Africa
2652 2652     Queensland Australia 2020-04-07 23:11:31 -27.4698 153.0251 934 4 173 757 Queensland, Australia
2733 2733       Eswatini 2020-04-07 23:04:29 -26.5225 31.4659 10 0 4 6 Eswatini
2807 2807       Paraguay 2020-04-07 23:04:29 -23.4425 -58.4438 115 5 15 95 Paraguay
2794 2794       Namibia 2020-04-07 23:04:29 -22.9576 18.4904 16 0 3 13 Namibia
2700 2700       Botswana 2020-04-07 23:04:29 -22.3285 24.6849 6 1 0 5 Botswana
2655 2655     Reunion France 2020-04-07 23:04:29 -21.1151 55.5364 358 0 40 318 Reunion, France
2638 2638     New Caledonia France 2020-04-07 23:04:29 -20.904304999999997 165.618042 18 0 1 17 New Caledonia, France
2786 2786       Mauritius 2020-04-07 23:04:29 -20.348404000000002 57.552152 268 7 8 253 Mauritius
2858 2858       Zimbabwe 2020-04-07 23:04:29 -19.015438 29.154857 11 2 0 9 Zimbabwe
2779 2779       Madagascar 2020-04-07 23:04:29 -18.766947000000002 46.869107 88 0 7 81 Madagascar
2793 2793       Mozambique 2020-04-07 23:04:29 -18.665695 35.529562 10 0 1 9 Mozambique
2735 2735       Fiji 2020-04-07 23:04:29 -17.7134 178.065 15 0 0 15 Fiji
2607 2607     French Polynesia France 2020-04-07 23:04:29 -17.6797 -149.4068 47 0 0 47 French Polynesia, France
2698 2698       Bolivia 2020-04-07 23:04:29 -16.2902 -63.5887 194 14 2 178 Bolivia
2701 2701       Brazil 2020-04-07 23:04:29 -14.235 -51.9253 14034 686 127 13221 Brazil
2819 2819       Samoa 2020-04-07 23:11:15 -13.759 -172.1046 0 0 0 0 Samoa
2780 2780       Malawi 2020-04-07 23:04:29 -13.254307999999998 34.301525 8 1 0 7 Malawi
2857 2857       Zambia 2020-04-07 23:04:29 -13.133897 27.849332 39 1 7 31 Zambia
2635 2635     Mayotte France 2020-04-07 23:04:29 -12.8275 45.166244 171 2 22 147 Mayotte, France
2643 2643     Northern Territory Australia 2020-04-07 23:11:31 -12.4634 130.8456 28 0 2 26 Northern Territory, Australia
2683 2683       Angola 2020-04-07 23:04:29 -11.2027 17.8739 17 2 2 13 Angola
2808 2808       Peru 2020-04-07 23:04:29 -9.19 -75.0152 2954 107 1301 1546 Peru
2843 2843       Timor-Leste 2020-04-07 23:04:29 -8.874217 125.727539 1 0 0 1 Timor-Leste
2657 2657     Saint Helena, Ascension and Tristan da Cunha United Kingdom 2020-04-07 23:04:29 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
2841 2841       Tanzania 2020-04-07 23:04:29 -6.369028 34.888822 24 1 5 18 Tanzania
2806 2806       Papua New Guinea 2020-04-07 23:04:29 -6.314993 143.95555 2 0 0 2 Papua New Guinea
2825 2825       Seychelles 2020-04-07 23:04:29 -4.6796 55.492 11 0 0 11 Seychelles
2715 2715       Congo (Kinshasa) 2020-04-07 23:04:29 -4.322447 15.307045 180 18 9 153 Congo (Kinshasa)
2714 2714       Congo (Brazzaville) 2020-04-07 23:04:29 -4.2634 15.2832 45 5 2 38 Congo (Brazzaville)
2706 2706       Burundi 2020-04-07 23:04:29 -3.3731 29.9189 3 0 0 3 Burundi

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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