03-30-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,442 rows sorted by Lat

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat ▼ Long_ Confirmed Deaths Recovered Active Combined_Key
3257 3257     Tasmania Australia 3/30/20 22:58 -42.8821 147.3272 66 0 5 61 Tasmania, Australia
3384 3384       New Zealand 3/30/20 22:52 -40.9006 174.886 589 1 63 525 New Zealand
3274 3274       Argentina 3/30/20 22:52 -38.4161 -63.6167 820 23 228 569 Argentina
3261 3261     Victoria Australia 3/30/20 22:58 -37.8136 144.9631 821 4 191 626 Victoria, Australia
3300 3300       Chile 3/30/20 22:52 -35.6751 -71.543 2449 8 156 2285 Chile
3184 3184     Australian Capital Territory Australia 3/30/20 22:58 -35.4735 149.0124 78 1 2 75 Australian Capital Territory, Australia
3255 3255     South Australia Australia 3/30/20 22:58 -34.9285 138.6007 305 0 6 299 South Australia, Australia
3229 3229     New South Wales Australia 3/30/20 22:58 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
3436 3436       Uruguay 3/30/20 22:52 -32.5228 -55.7658 310 1 0 309 Uruguay
3263 3263     Western Australia Australia 3/30/20 22:58 -31.9505 115.8605 355 2 41 312 Western Australia, Australia
3416 3416       South Africa 3/30/20 22:52 -30.5595 22.9375 1326 3 31 1292 South Africa
3242 3242     Queensland Australia 3/30/20 22:58 -27.4698 153.0251 689 2 8 679 Queensland, Australia
3321 3321       Eswatini 3/30/20 22:52 -26.5225 31.4659 9 0 0 9 Eswatini
3394 3394       Paraguay 3/30/20 22:52 -23.4425 -58.4438 64 3 1 60 Paraguay
3381 3381       Namibia 3/30/20 22:52 -22.9576 18.4904 11 0 2 9 Namibia
3289 3289       Botswana 3/30/20 22:52 -22.3285 24.6849 3 0 0 3 Botswana
3245 3245     Reunion France 3/30/20 22:52 -21.1151 55.5364 224 0 1 223 Reunion, France
3228 3228     New Caledonia France 3/30/20 22:52 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3373 3373       Mauritius 3/30/20 22:52 -20.348404 57.552152 128 3 0 125 Mauritius
3442 3442       Zimbabwe 3/30/20 22:52 -19.015438 29.154857 7 1 0 6 Zimbabwe
3367 3367       Madagascar 3/30/20 22:52 -18.766947 46.869107 43 0 0 43 Madagascar
3380 3380       Mozambique 3/30/20 22:52 -18.665695 35.529562 8 0 0 8 Mozambique
3323 3323       Fiji 3/30/20 22:52 -17.7134 178.065 5 0 0 5 Fiji
3197 3197     French Polynesia France 3/30/20 22:52 -17.6797 149.4068 36 0 0 36 French Polynesia, France
3287 3287       Bolivia 3/30/20 22:52 -16.2902 -63.5887 97 4 0 93 Bolivia
3180 3180 60000   American Samoa US 3/30/20 22:52 -14.271 -170.132 0 0 0 0 American Samoa, US
3290 3290       Brazil 3/30/20 22:52 -14.235 -51.9253 4579 159 120 4300 Brazil
3406 3406       Samoa 3/30/20 22:58 -13.759 -172.1046 0 0 0 0 Samoa
3441 3441       Zambia 3/30/20 22:52 -13.133897 27.849332 35 0 0 35 Zambia
3225 3225     Mayotte France 3/30/20 22:52 -12.8275 45.166244 82 0 10 72 Mayotte, France
3233 3233     Northern Territory Australia 3/30/20 22:58 -12.4634 130.8456 15 0 0 15 Northern Territory, Australia
3272 3272       Angola 3/30/20 22:52 -11.2027 17.8739 7 2 0 5 Angola
3395 3395       Peru 3/30/20 22:52 -9.19 -75.0152 950 24 53 873 Peru
3427 3427       Timor-Leste 3/30/20 22:52 -8.874217 125.727539 1 0 0 1 Timor-Leste
3247 3247     Saint Helena, Ascension and Tristan da Cunha United Kingdom 3/30/20 22:52 -7.9467 -14.3559 0 0 0 0 Saint Helena, Ascension and Tristan da Cunha, United Kingdom
3425 3425       Tanzania 3/30/20 22:52 -6.369028 34.888822 19 0 1 18 Tanzania
3393 3393       Papua New Guinea 3/30/20 22:52 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3411 3411       Seychelles 3/30/20 22:52 -4.6796 55.492 8 0 0 8 Seychelles
3303 3303       Congo (Kinshasa) 3/30/20 22:52 -4.322447 15.307045 81 8 2 71 Congo (Kinshasa)
3302 3302       Congo (Brazzaville) 3/30/20 22:52 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
3402 3402       Rwanda 3/30/20 22:52 -1.9403 29.8739 70 0 0 70 Rwanda
3315 3315       Ecuador 3/30/20 22:52 -1.8312 -78.1834 1962 60 3 1899 Ecuador
3326 3326       Gabon 3/30/20 22:52 -0.8037 11.6094 7 1 0 6 Gabon
3343 3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia
3353 3353       Kenya 3/30/20 22:52 -0.0236 37.9062 50 1 1 48 Kenya
2178 2178   Out of MI Michigan US 3/30/20 22:52 0.0 0.0 17 0 0 0 Out of MI,Michigan,US
2179 2179   Out of TN Tennessee US 3/30/20 22:52 0.0 0.0 150 0 0 0 Out of TN,Tennessee,US
2180 2180   Out of UT Utah US 3/30/20 22:52 0.0 0.0 19 0 0 0 Out of UT,Utah,US
2856 2856   Unassigned Alaska US 3/30/20 22:52 0.0 0.0 0 2 0 0 Unassigned, Alaska, US
2857 2857   Unassigned Arizona US 3/30/20 22:52 0.0 0.0 0 9 0 0 Unassigned, Arizona, US
2858 2858   Unassigned Arkansas US 3/30/20 22:52 0.0 0.0 49 2 0 0 Unassigned, Arkansas, US
2859 2859   Unassigned California US 3/30/20 22:52 0.0 0.0 0 0 0 0 Unassigned, California, US
2860 2860   Unassigned Colorado US 3/30/20 22:52 0.0 0.0 186 1 0 0 Unassigned, Colorado, US
2861 2861   Unassigned Connecticut US 3/30/20 22:52 0.0 0.0 176 0 0 0 Unassigned, Connecticut, US
2862 2862   Unassigned Florida US 3/30/20 22:52 0.0 0.0 1 4 0 0 Unassigned, Florida, US
2863 2863   Unassigned Georgia US 3/30/20 22:52 0.0 0.0 164 1 0 0 Unassigned, Georgia, US
2864 2864   Unassigned Hawaii US 3/30/20 22:52 0.0 0.0 8 0 0 0 Unassigned, Hawaii, US
2865 2865   Unassigned Illinois US 3/30/20 22:52 0.0 0.0 13 0 0 0 Unassigned, Illinois, US
2866 2866   Unassigned Kentucky US 3/30/20 22:52 0.0 0.0 53 2 0 0 Unassigned, Kentucky, US
2867 2867   Unassigned Louisiana US 3/30/20 22:52 0.0 0.0 14 0 0 0 Unassigned, Louisiana, US
2868 2868   Unassigned Maine US 3/30/20 22:52 0.0 0.0 5 0 0 0 Unassigned, Maine, US
2869 2869   Unassigned Maryland US 3/30/20 22:52 0.0 0.0 0 1 0 0 Unassigned, Maryland, US
2870 2870   Unassigned Massachusetts US 3/30/20 22:52 0.0 0.0 489 9 0 0 Unassigned, Massachusetts, US
2871 2871   Unassigned Michigan US 3/30/20 22:52 0.0 0.0 78 0 0 0 Unassigned,Michigan,US
2872 2872   Unassigned Minnesota US 3/30/20 22:52 0.0 0.0 0 1 0 0 Unassigned, Minnesota, US
2873 2873   Unassigned Mississippi US 3/30/20 22:52 0.0 0.0 89 2 0 0 Unassigned, Mississippi, US
2874 2874   Unassigned Nebraska US 3/30/20 22:52 0.0 0.0 2 0 0 0 Unassigned, Nebraska, US
2875 2875   Unassigned Nevada US 3/30/20 22:52 0.0 0.0 132 0 0 0 Unassigned, Nevada, US
2876 2876   Unassigned New Hampshire US 3/30/20 22:52 0.0 0.0 56 0 0 0 Unassigned, New Hampshire, US
2877 2877   Unassigned New Jersey US 3/30/20 22:52 0.0 0.0 3847 91 0 0 Unassigned, New Jersey, US
2878 2878   Unassigned New York US 3/30/20 22:52 0.0 0.0 0 298 0 0 Unassigned, New York, US
2879 2879   Unassigned North Carolina US 3/30/20 22:52 0.0 0.0 0 1 0 0 Unassigned, North Carolina, US
2880 2880   Unassigned North Dakota US 3/30/20 22:52 0.0 0.0 0 1 0 0 Unassigned, North Dakota, US
2881 2881   Unassigned Rhode Island US 3/30/20 22:52 0.0 0.0 171 7 0 0 Unassigned, Rhode Island, US
2882 2882   Unassigned Tennessee US 3/30/20 22:52 0.0 0.0 197 4 0 0 Unassigned, Tennessee, US
2883 2883   Unassigned Vermont US 3/30/20 22:52 0.0 0.0 28 7 0 0 Unassigned, Vermont, US
2884 2884   Unassigned Washington US 3/30/20 22:52 0.0 0.0 274 0 0 0 Unassigned, Washington, US
2885 2885   Unassigned Wisconsin US 3/30/20 22:52 0.0 0.0 0 0 0 0 Unassigned, Wisconsin, US
3193 3193     Diamond Princess Canada 3/30/20 22:58 0.0 0.0 0 1 0 0 Diamond Princess, Canada
3194 3194 88888   Diamond Princess US 3/30/20 22:52 0.0 0.0 49 0 0 0 Diamond Princess, US
3201 3201     Grand Princess Canada 3/30/20 22:58 0.0 0.0 13 0 0 0 Grand Princess, Canada
3202 3202 99999   Grand Princess US 3/30/20 22:52 0.0 0.0 103 3 0 0 Grand Princess, US
3243 3243     Recovered Canada 3/30/20 22:58 0.0 0.0 0 0 466 0 Recovered, Canada
3244 3244     Recovered US 3/30/20 22:52 0.0 0.0 0 0 5644 0 Recovered, US
3311 3311       Diamond Princess 3/30/20 22:52 0.0 0.0 712 10 603 99 Diamond Princess
3366 3366       MS Zaandam 3/30/20 22:52 0.0 0.0 2 0 0 2 ,,MS Zaandam
3412 3412       Singapore 3/30/20 22:52 1.2833 103.8333 879 3 228 648 Singapore
3432 3432       Uganda 3/30/20 22:52 1.373333 32.290275 33 0 0 33 Uganda
3318 3318       Equatorial Guinea 3/30/20 22:52 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3369 3369       Maldives 3/30/20 22:52 3.2028 73.2207 17 0 13 4 Maldives
3297 3297       Cameroon 3/30/20 22:52 3.848 11.5021 139 6 5 128 Cameroon
3420 3420       Suriname 3/30/20 22:52 3.9193 -56.0278 8 0 0 8 Suriname
3196 3196     French Guiana France 3/30/20 22:52 4.0 -53.0 43 0 6 37 French Guiana, France
3368 3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3291 3291       Brunei 3/30/20 22:52 4.5353 114.7277 127 1 38 88 Brunei
3301 3301       Colombia 3/30/20 22:52 4.5709 -74.2973 798 12 15 771 Colombia
3336 3336       Guyana 3/30/20 22:52 4.860416 -58.93018 8 1 0 7 Guyana
3415 3415       Somalia 3/30/20 22:52 5.152149 46.199616 3 0 0 3 Somalia
3438 3438       Venezuela 3/30/20 22:52 6.4238 -66.5897 135 3 39 93 Venezuela
3361 3361       Liberia 3/30/20 22:52 6.428055 -9.429499 3 0 0 3 Liberia

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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