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 Province_State

✎ 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
3268 3268       Afghanistan 3/30/20 22:52 33.93911 67.709953 146 4 2 164 Afghanistan
3269 3269       Albania 3/30/20 22:52 41.1533 20.1683 223 11 44 168 Albania
3270 3270       Algeria 3/30/20 22:52 28.0339 1.6596 584 35 37 512 Algeria
3271 3271       Andorra 3/30/20 22:52 42.5063 1.5218 370 8 10 352 Andorra
3272 3272       Angola 3/30/20 22:52 -11.2027 17.8739 7 2 0 5 Angola
3273 3273       Antigua and Barbuda 3/30/20 22:52 17.0608 -61.7964 7 0 0 7 Antigua and Barbuda
3274 3274       Argentina 3/30/20 22:52 -38.4161 -63.6167 820 23 228 569 Argentina
3275 3275       Armenia 3/30/20 22:52 40.0691 45.0382 482 3 30 449 Armenia
3276 3276       Austria 3/30/20 22:52 47.5162 14.5501 9618 108 636 8874 Austria
3277 3277       Azerbaijan 3/30/20 22:52 40.1431 47.5769 273 4 26 243 Azerbaijan
3278 3278       Bahamas 3/30/20 22:52 25.025885 -78.035889 14 0 1 13 Bahamas
3279 3279       Bahrain 3/30/20 22:52 26.0275 50.55 515 4 279 232 Bahrain
3280 3280       Bangladesh 3/30/20 22:52 23.685 90.3563 49 5 19 25 Bangladesh
3281 3281       Barbados 3/30/20 22:52 13.1939 -59.5432 33 0 0 33 Barbados
3282 3282       Belarus 3/30/20 22:52 53.7098 27.9534 152 0 32 120 Belarus
3283 3283       Belgium 3/30/20 22:52 50.8333 4.469936 11899 513 1527 9859 Belgium
3284 3284       Belize 3/30/20 22:52 17.1899 -88.4976 3 0 0 3 ,,Belize
3285 3285       Benin 3/30/20 22:52 9.3077 2.3158 6 0 0 6 Benin
3286 3286       Bhutan 3/30/20 22:52 27.5142 90.4336 4 0 0 4 Bhutan
3287 3287       Bolivia 3/30/20 22:52 -16.2902 -63.5887 97 4 0 93 Bolivia
3288 3288       Bosnia and Herzegovina 3/30/20 22:52 43.9159 17.6791 368 10 17 341 Bosnia and Herzegovina
3289 3289       Botswana 3/30/20 22:52 -22.3285 24.6849 3 0 0 3 Botswana
3290 3290       Brazil 3/30/20 22:52 -14.235 -51.9253 4579 159 120 4300 Brazil
3291 3291       Brunei 3/30/20 22:52 4.5353 114.7277 127 1 38 88 Brunei
3292 3292       Bulgaria 3/30/20 22:52 42.7339 25.4858 359 8 17 334 Bulgaria
3293 3293       Burkina Faso 3/30/20 22:52 12.2383 -1.5616 246 12 31 203 Burkina Faso
3294 3294       Burma 3/30/20 22:52 21.9162 95.956 14 0 0 14 Burma
3295 3295       Cabo Verde 3/30/20 22:52 16.5388 -23.0418 6 1 0 5 Cabo Verde
3296 3296       Cambodia 3/30/20 22:52 11.55 104.9167 107 0 21 86 Cambodia
3297 3297       Cameroon 3/30/20 22:52 3.848 11.5021 139 6 5 128 Cameroon
3298 3298       Central African Republic 3/30/20 22:52 6.6111 20.9394 3 0 0 3 Central African Republic
3299 3299       Chad 3/30/20 22:52 15.4542 18.7322 5 0 0 5 Chad
3300 3300       Chile 3/30/20 22:52 -35.6751 -71.543 2449 8 156 2285 Chile
3301 3301       Colombia 3/30/20 22:52 4.5709 -74.2973 798 12 15 771 Colombia
3302 3302       Congo (Brazzaville) 3/30/20 22:52 -4.2634 15.2832 19 0 0 19 Congo (Brazzaville)
3303 3303       Congo (Kinshasa) 3/30/20 22:52 -4.322447 15.307045 81 8 2 71 Congo (Kinshasa)
3304 3304       Costa Rica 3/30/20 22:52 9.7489 -83.7534 330 2 4 324 Costa Rica
3305 3305       Cote d'Ivoire 3/30/20 22:52 7.54 -5.5471 168 1 6 161 Cote d'Ivoire
3306 3306       Croatia 3/30/20 22:52 45.1 15.2 790 6 67 717 Croatia
3307 3307       Cuba 3/30/20 22:52 21.521757 -77.781167 170 4 4 162 Cuba
3308 3308       Cyprus 3/30/20 22:52 35.1264 33.4299 230 7 22 201 Cyprus
3309 3309       Czechia 3/30/20 22:52 49.8175 15.473 3001 23 25 2953 Czechia
3310 3310       Denmark 3/30/20 22:52 56.2639 9.5018 2577 77 1 2499 Denmark
3311 3311       Diamond Princess 3/30/20 22:52 0.0 0.0 712 10 603 99 Diamond Princess
3312 3312       Djibouti 3/30/20 22:52 11.8251 42.5903 18 0 0 18 Djibouti
3313 3313       Dominica 3/30/20 22:52 15.415 -61.371 11 0 0 11 Dominica
3314 3314       Dominican Republic 3/30/20 22:52 18.7357 -70.1627 901 42 4 855 Dominican Republic
3315 3315       Ecuador 3/30/20 22:52 -1.8312 -78.1834 1962 60 3 1899 Ecuador
3316 3316       Egypt 3/30/20 22:52 26.820553 30.802498 656 41 150 465 Egypt
3317 3317       El Salvador 3/30/20 22:52 13.7942 -88.8965 30 0 0 30 El Salvador
3318 3318       Equatorial Guinea 3/30/20 22:52 1.6508 10.2679 12 0 0 12 Equatorial Guinea
3319 3319       Eritrea 3/30/20 22:52 15.1794 39.7823 12 0 0 12 Eritrea
3320 3320       Estonia 3/30/20 22:52 58.5953 25.0136 715 3 20 692 Estonia
3321 3321       Eswatini 3/30/20 22:52 -26.5225 31.4659 9 0 0 9 Eswatini
3322 3322       Ethiopia 3/30/20 22:52 9.145 40.4897 23 0 4 19 Ethiopia
3323 3323       Fiji 3/30/20 22:52 -17.7134 178.065 5 0 0 5 Fiji
3324 3324       Finland 3/30/20 22:52 61.92411 25.748151 1352 13 10 1329 Finland
3325 3325       France 3/30/20 22:52 46.2276 2.2137 44029 3020 7927 33599 France
3326 3326       Gabon 3/30/20 22:52 -0.8037 11.6094 7 1 0 6 Gabon
3327 3327       Gambia 3/30/20 22:52 13.4432 -15.3101 4 1 0 3 Gambia
3328 3328       Georgia 3/30/20 22:52 42.3154 43.3569 103 0 20 83 Georgia
3329 3329       Germany 3/30/20 22:52 51.165691 10.451526 66885 645 13500 52740 Germany
3330 3330       Ghana 3/30/20 22:52 7.9465 -1.0232 152 5 2 145 Ghana
3331 3331       Greece 3/30/20 22:52 39.0742 21.8243 1212 43 52 1117 Greece
3332 3332       Grenada 3/30/20 22:52 12.1165 -61.679 9 0 0 9 Grenada
3333 3333       Guatemala 3/30/20 22:52 15.7835 -90.2308 36 1 10 25 Guatemala
3334 3334       Guinea 3/30/20 22:52 9.9456 -9.6966 22 0 0 22 Guinea
3335 3335       Guinea-Bissau 3/30/20 22:52 11.8037 -15.1804 8 0 0 8 Guinea-Bissau
3336 3336       Guyana 3/30/20 22:52 4.860416 -58.93018 8 1 0 7 Guyana
3337 3337       Haiti 3/30/20 22:52 18.9712 -72.2852 15 0 1 14 Haiti
3338 3338       Holy See 3/30/20 22:52 41.9029 12.4534 6 0 0 6 Holy See
3339 3339       Honduras 3/30/20 22:52 15.2 -86.2419 139 7 3 129 Honduras
3340 3340       Hungary 3/30/20 22:52 47.1625 19.5033 447 15 34 398 Hungary
3341 3341       Iceland 3/30/20 22:52 64.9631 -19.0208 1086 2 157 927 Iceland
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
3343 3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia
3344 3344       Iran 3/30/20 22:52 32.427908 53.688046 41495 2757 13911 24827 Iran
3345 3345       Iraq 3/30/20 22:52 33.223191 43.679291 630 46 152 432 Iraq
3346 3346       Ireland 3/30/20 22:52 53.1424 -7.6921 2910 54 5 2851 Ireland
3347 3347       Israel 3/30/20 22:52 31.046051 34.851612 4979 17 147 4518 Israel
3348 3348       Italy 3/30/20 22:52 41.87194 12.56738 101739 11591 14620 75528 Italy
3349 3349       Jamaica 3/30/20 22:52 18.1096 -77.2975 36 1 2 33 Jamaica
3350 3350       Japan 3/30/20 22:52 36.204824 138.252924 1866 54 424 1388 Japan
3351 3351       Jordan 3/30/20 22:52 31.24 36.51 268 5 26 237 Jordan
3352 3352       Kazakhstan 3/30/20 22:52 48.0196 66.9237 302 1 21 280 Kazakhstan
3353 3353       Kenya 3/30/20 22:52 -0.0236 37.9062 50 1 1 48 Kenya
3354 3354       Korea, South 3/30/20 22:52 35.907757 127.766922 9661 158 5228 4275 Korea, South
3355 3355       Kosovo 3/30/20 22:52 42.602636 20.902977 94 1 1 92 Kosovo
3356 3356       Kuwait 3/30/20 22:52 29.31166 47.481766 266 0 72 194 Kuwait
3357 3357       Kyrgyzstan 3/30/20 22:52 41.20438 74.766098 94 0 3 91 Kyrgyzstan
3358 3358       Laos 3/30/20 22:52 19.85627 102.495496 8 0 0 8 Laos
3359 3359       Latvia 3/30/20 22:52 56.8796 24.6032 376 0 1 375 Latvia
3360 3360       Lebanon 3/30/20 22:52 33.8547 35.8623 446 11 35 400 Lebanon
3361 3361       Liberia 3/30/20 22:52 6.428055 -9.429499 3 0 0 3 Liberia
3362 3362       Libya 3/30/20 22:52 26.3351 17.228331 8 0 0 8 Libya
3363 3363       Liechtenstein 3/30/20 22:52 47.14 9.55 62 0 0 62 Liechtenstein
3364 3364       Lithuania 3/30/20 22:52 55.1694 23.8813 424 4 0 477 Lithuania
3365 3365       Luxembourg 3/30/20 22:52 49.8153 6.1296 1988 22 40 1926 Luxembourg
3366 3366       MS Zaandam 3/30/20 22:52 0.0 0.0 2 0 0 2 ,,MS Zaandam
3367 3367       Madagascar 3/30/20 22:52 -18.766947 46.869107 43 0 0 43 Madagascar

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
);