04-02-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,572 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
2394 2394       Afghanistan 4/2/20 23:25 33.93911 67.709953 240 4 10 257 Afghanistan
2395 2395       Albania 4/2/20 23:25 41.1533 20.1683 277 16 76 185 Albania
2396 2396       Algeria 4/2/20 23:25 28.0339 1.6596 986 86 61 839 Algeria
2397 2397       Andorra 4/2/20 23:25 42.5063 1.5218 428 15 10 403 Andorra
2398 2398       Angola 4/2/20 23:25 -11.2027 17.8739 8 2 1 5 Angola
2399 2399       Antigua and Barbuda 4/2/20 23:25 17.0608 -61.7964 9 0 0 9 Antigua and Barbuda
2400 2400       Argentina 4/2/20 23:25 -38.4161 -63.6167 1133 36 256 841 Argentina
2401 2401       Armenia 4/2/20 23:25 40.0691 45.0382 663 7 33 623 Armenia
2402 2402       Austria 4/2/20 23:25 47.5162 14.5501 11129 158 1749 9222 Austria
2403 2403       Azerbaijan 4/2/20 23:25 40.1431 47.5769 400 5 26 369 Azerbaijan
2404 2404       Bahamas 4/2/20 23:25 25.025885 -78.035889 24 1 1 22 Bahamas
2405 2405       Bahrain 4/2/20 23:25 26.0275 50.55 643 4 381 258 Bahrain
2406 2406       Bangladesh 4/2/20 23:25 23.685 90.3563 56 6 25 25 Bangladesh
2407 2407       Barbados 4/2/20 23:25 13.1939 -59.5432 46 0 0 46 Barbados
2408 2408       Belarus 4/2/20 23:25 53.7098 27.9534 304 4 53 247 Belarus
2409 2409       Belgium 4/2/20 23:25 50.8333 4.469936 15348 1011 2495 11842 Belgium
2410 2410       Belize 4/2/20 23:25 17.1899 -88.4976 3 0 0 3 ,,Belize
2411 2411       Benin 4/2/20 23:25 9.3077 2.3158 13 0 1 12 Benin
2412 2412       Bhutan 4/2/20 23:25 27.5142 90.4336 5 0 1 4 Bhutan
2413 2413       Bolivia 4/2/20 23:25 -16.2902 -63.5887 123 8 1 114 Bolivia
2414 2414       Bosnia and Herzegovina 4/2/20 23:25 43.9159 17.6791 533 16 20 497 Bosnia and Herzegovina
2415 2415       Botswana 4/2/20 23:25 -22.3285 24.6849 4 1 0 3 Botswana
2416 2416       Brazil 4/2/20 23:25 -14.235 -51.9253 8044 324 127 7593 Brazil
2417 2417       Brunei 4/2/20 23:25 4.5353 114.7277 133 1 56 76 Brunei
2418 2418       Bulgaria 4/2/20 23:25 42.7339 25.4858 457 10 25 422 Bulgaria
2419 2419       Burkina Faso 4/2/20 23:25 12.2383 -1.5616 288 16 50 222 Burkina Faso
2420 2420       Burma 4/2/20 23:25 21.9162 95.956 20 1 0 19 Burma
2421 2421       Burundi 4/2/20 23:25 -3.3731 29.9189 3 0 0 3 Burundi
2422 2422       Cabo Verde 4/2/20 23:25 16.5388 -23.0418 6 1 0 5 Cabo Verde
2423 2423       Cambodia 4/2/20 23:25 11.55 104.9167 110 0 34 76 Cambodia
2424 2424       Cameroon 4/2/20 23:25 3.848 11.5021 306 7 10 289 Cameroon
2425 2425       Central African Republic 4/2/20 23:25 6.6111 20.9394 3 0 0 3 Central African Republic
2426 2426       Chad 4/2/20 23:25 15.4542 18.7322 8 0 0 8 Chad
2427 2427       Chile 4/2/20 23:25 -35.6751 -71.543 3404 18 335 3051 Chile
2428 2428       Colombia 4/2/20 23:25 4.5709 -74.2973 1161 19 55 1087 Colombia
2429 2429       Congo (Brazzaville) 4/2/20 23:25 -4.2634 15.2832 22 2 2 18 Congo (Brazzaville)
2430 2430       Congo (Kinshasa) 4/2/20 23:25 -4.322447 15.307045 134 13 3 118 Congo (Kinshasa)
2431 2431       Costa Rica 4/2/20 23:25 9.7489 -83.7534 396 2 6 388 Costa Rica
2432 2432       Cote d'Ivoire 4/2/20 23:25 7.54 -5.5471 194 1 15 178 Cote d'Ivoire
2433 2433       Croatia 4/2/20 23:25 45.1 15.2 1011 7 88 916 Croatia
2434 2434       Cuba 4/2/20 23:25 21.521757 -77.781167 233 6 13 214 Cuba
2435 2435       Cyprus 4/2/20 23:25 35.1264 33.4299 356 10 28 318 Cyprus
2436 2436       Czechia 4/2/20 23:25 49.8175 15.473 3858 44 67 3747 Czechia
2437 2437       Denmark 4/2/20 23:25 56.2639 9.5018 3386 123 1089 2174 Denmark
2438 2438       Diamond Princess 4/2/20 23:25     712 11 619 82 Diamond Princess
2439 2439       Djibouti 4/2/20 23:25 11.8251 42.5903 40 0 0 40 Djibouti
2440 2440       Dominica 4/2/20 23:25 15.415 -61.371 12 0 0 12 Dominica
2441 2441       Dominican Republic 4/2/20 23:25 18.7357 -70.1627 1380 60 16 1304 Dominican Republic
2442 2442       Ecuador 4/2/20 23:25 -1.8312 -78.1834 3163 120 65 2978 Ecuador
2443 2443       Egypt 4/2/20 23:25 26.820553 30.802498 865 58 201 606 Egypt
2444 2444       El Salvador 4/2/20 23:25 13.7942 -88.8965 41 2 0 39 El Salvador
2445 2445       Equatorial Guinea 4/2/20 23:25 1.6508 10.2679 15 0 1 14 Equatorial Guinea
2446 2446       Eritrea 4/2/20 23:25 15.1794 39.7823 22 0 0 22 Eritrea
2447 2447       Estonia 4/2/20 23:25 58.5953 25.0136 858 11 45 802 Estonia
2448 2448       Eswatini 4/2/20 23:25 -26.5225 31.4659 9 0 0 9 Eswatini
2449 2449       Ethiopia 4/2/20 23:25 9.145 40.4897 29 0 3 26 Ethiopia
2450 2450       Fiji 4/2/20 23:25 -17.7134 178.065 7 0 0 7 Fiji
2451 2451       Finland 4/2/20 23:25 61.92411 25.748151 1518 19 300 1199 Finland
2452 2452       France 4/2/20 23:25 46.2276 2.2137 58404 5376 12428 41290 France
2453 2453       Gabon 4/2/20 23:25 -0.8037 11.6094 21 1 0 20 Gabon
2454 2454       Gambia 4/2/20 23:25 13.4432 -15.3101 4 1 2 1 Gambia
2455 2455       Georgia 4/2/20 23:25 42.3154 43.3569 134 0 26 108 Georgia
2456 2456       Germany 4/2/20 23:25 51.165691 10.451526 84794 1107 22440 61247 Germany
2457 2457       Ghana 4/2/20 23:25 7.9465 -1.0232 204 5 31 168 Ghana
2458 2458       Greece 4/2/20 23:25 39.0742 21.8243 1544 53 61 1430 Greece
2459 2459       Grenada 4/2/20 23:25 12.1165 -61.679 10 0 0 10 Grenada
2460 2460       Guatemala 4/2/20 23:25 15.7835 -90.2308 47 1 12 34 Guatemala
2461 2461       Guinea 4/2/20 23:25 9.9456 -9.6966 52 0 0 52 Guinea
2462 2462       Guinea-Bissau 4/2/20 23:25 11.8037 -15.1804 9 0 0 9 Guinea-Bissau
2463 2463       Guyana 4/2/20 23:25 4.860416 -58.93018 19 4 0 15 Guyana
2464 2464       Haiti 4/2/20 23:25 18.9712 -72.2852 16 0 1 15 Haiti
2465 2465       Holy See 4/2/20 23:25 41.9029 12.4534 7 0 0 7 Holy See
2466 2466       Honduras 4/2/20 23:25 15.2 -86.2419 219 14 3 202 Honduras
2467 2467       Hungary 4/2/20 23:25 47.1625 19.5033 585 21 42 522 Hungary
2468 2468       Iceland 4/2/20 23:25 64.9631 -19.0208 1319 4 284 1031 Iceland
2469 2469       India 4/2/20 23:25 20.593684 78.96288 2543 72 191 2280 India
2470 2470       Indonesia 4/2/20 23:25 -0.7893 113.9213 1790 170 112 1508 Indonesia
2471 2471       Iran 4/2/20 23:25 32.427908 53.688046 50468 3160 16711 30597 Iran
2472 2472       Iraq 4/2/20 23:25 33.223191 43.679291 772 54 202 516 Iraq
2473 2473       Ireland 4/2/20 23:25 53.1424 -7.6921 3849 98 5 3746 Ireland
2474 2474       Israel 4/2/20 23:25 31.046051 34.851612 7132 38 597 6483 Israel
2475 2475       Italy 4/2/20 23:25 41.87194 12.56738 115242 13915 18278 83049 Italy
2476 2476       Jamaica 4/2/20 23:25 18.1096 -77.2975 47 3 2 42 Jamaica
2477 2477       Japan 4/2/20 23:25 36.204824 138.252924 2495 62 472 1961 Japan
2478 2478       Jordan 4/2/20 23:25 31.24 36.51 299 5 45 249 Jordan
2479 2479       Kazakhstan 4/2/20 23:25 48.0196 66.9237 435 3 27 405 Kazakhstan
2480 2480       Kenya 4/2/20 23:25 -0.0236 37.9062 110 3 4 103 Kenya
2481 2481       Korea, South 4/2/20 23:25 35.907757 127.766922 9976 169 5828 3979 Korea, South
2482 2482       Kosovo 4/2/20 23:25 42.602636 20.902977 125 1 10 114 Kosovo
2483 2483       Kuwait 4/2/20 23:25 29.31166 47.481766 342 0 81 261 Kuwait
2484 2484       Kyrgyzstan 4/2/20 23:25 41.20438 74.766098 116 0 5 111 Kyrgyzstan
2485 2485       Laos 4/2/20 23:25 19.85627 102.495496 10 0 0 10 Laos
2486 2486       Latvia 4/2/20 23:25 56.8796 24.6032 458 0 31 427 Latvia
2487 2487       Lebanon 4/2/20 23:25 33.8547 35.8623 494 16 46 432 Lebanon
2488 2488       Liberia 4/2/20 23:25 6.428055 -9.429499 6 0 0 6 Liberia
2489 2489       Libya 4/2/20 23:25 26.3351 17.228331 11 1 0 10 Libya
2490 2490       Liechtenstein 4/2/20 23:25 47.14 9.55 75 0 0 75 Liechtenstein
2491 2491       Lithuania 4/2/20 23:25 55.1694 23.8813 579 6 0 633 Lithuania
2492 2492       Luxembourg 4/2/20 23:25 49.8153 6.1296 2487 30 80 2377 Luxembourg
2493 2493       MS Zaandam 4/2/20 23:25     9 2 0 7 ,,MS Zaandam

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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