03-29-2020
Data source: Big Local News · About: README
3,437 rows sorted by Active descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3404 | 3404 | Senegal | 3/29/20 23:08 | 14.4974 | -14.4524 | 142 | 0 | 27 | 115 | Senegal | |||
3264 | 3264 | Afghanistan | 3/29/20 23:08 | 33.93911 | 67.709953 | 118 | 4 | 2 | 114 | Afghanistan | |||
3382 | 3382 | Nigeria | 3/29/20 23:08 | 9.082 | 8.6753 | 111 | 1 | 3 | 107 | Nigeria | |||
3186 | 3186 | Channel Islands | United Kingdom | 3/29/20 23:08 | 49.3723 | -2.3644 | 108 | 2 | 0 | 106 | Channel Islands, United Kingdom | ||
3413 | 3413 | Sri Lanka | 3/29/20 23:08 | 7.873054 | 80.771797 | 117 | 1 | 11 | 105 | Sri Lanka | |||
3334 | 3334 | Honduras | 3/29/20 23:08 | 15.2 | -86.2419 | 110 | 3 | 3 | 104 | Honduras | |||
3368 | 3368 | Mauritius | 3/29/20 23:08 | -20.348404 | 57.552152 | 107 | 3 | 0 | 104 | Mauritius | |||
3306 | 3306 | Diamond Princess | 3/29/20 23:08 | 0.0 | 0.0 | 712 | 10 | 603 | 99 | Diamond Princess | |||
3220 | 3220 | Martinique | France | 3/29/20 23:08 | 14.6415 | -61.0242 | 93 | 1 | 0 | 92 | Martinique, France | ||
3350 | 3350 | Kosovo | 3/29/20 23:08 | 42.602636 | 20.902977 | 94 | 1 | 1 | 92 | Kosovo | |||
3286 | 3286 | Brunei | 3/29/20 23:08 | 4.5353 | 114.7277 | 126 | 1 | 34 | 91 | Brunei | |||
3435 | 3435 | West Bank and Gaza | 3/29/20 23:08 | 31.9522 | 35.2332 | 109 | 1 | 18 | 90 | West Bank and Gaza | |||
3191 | 3191 | Faroe Islands | Denmark | 3/29/20 23:08 | 61.8926 | -6.9118 | 159 | 0 | 70 | 89 | Faroe Islands, Denmark | ||
3200 | 3200 | Guadeloupe | France | 3/29/20 23:08 | 16.265 | -61.551 | 106 | 4 | 17 | 85 | Guadeloupe, France | ||
3352 | 3352 | Kyrgyzstan | 3/29/20 23:08 | 41.20438 | 74.766098 | 84 | 0 | 0 | 84 | Kyrgyzstan | |||
3373 | 3373 | Montenegro | 3/29/20 23:08 | 42.708678 | 19.37439 | 85 | 1 | 0 | 84 | Montenegro | |||
3291 | 3291 | Cambodia | 3/29/20 23:08 | 11.55 | 104.9167 | 103 | 0 | 21 | 82 | Cambodia | |||
3283 | 3283 | Bolivia | 3/29/20 23:08 | -16.2902 | -63.5887 | 81 | 1 | 0 | 80 | Bolivia | |||
3433 | 3433 | Venezuela | 3/29/20 23:08 | 6.4238 | -66.5897 | 119 | 2 | 39 | 78 | Venezuela | |||
3180 | 3180 | Australian Capital Territory | Australia | 3/29/20 23:14 | -35.4735 | 149.0124 | 77 | 0 | 2 | 75 | Australian Capital Territory, Australia | ||
3424 | 3424 | Trinidad and Tobago | 3/29/20 23:08 | 10.6918 | -61.2225 | 78 | 3 | 1 | 74 | Trinidad and Tobago | |||
3323 | 3323 | Georgia | 3/29/20 23:08 | 42.3154 | 43.3569 | 91 | 0 | 18 | 73 | Georgia | |||
3397 | 3397 | Rwanda | 3/29/20 23:08 | -1.9403 | 29.8739 | 70 | 0 | 0 | 70 | Rwanda | |||
3221 | 3221 | Mayotte | France | 3/29/20 23:08 | -12.8275 | 45.166244 | 63 | 0 | 0 | 63 | Mayotte, France | ||
3278 | 3278 | Belarus | 3/29/20 23:08 | 53.7098 | 27.9534 | 94 | 0 | 32 | 62 | Belarus | |||
3253 | 3253 | Tasmania | Australia | 3/29/20 23:14 | -42.8821 | 147.3272 | 66 | 0 | 5 | 61 | Tasmania, Australia | ||
3298 | 3298 | Congo (Kinshasa) | 3/29/20 23:08 | -4.322447 | 15.307045 | 65 | 6 | 2 | 57 | Congo (Kinshasa) | |||
3358 | 3358 | Liechtenstein | 3/29/20 23:08 | 47.14 | 9.55 | 56 | 0 | 0 | 56 | Liechtenstein | |||
3389 | 3389 | Paraguay | 3/29/20 23:08 | -23.4425 | -58.4438 | 59 | 3 | 1 | 55 | Paraguay | |||
3196 | 3196 | Gibraltar | United Kingdom | 3/29/20 23:08 | 36.1408 | -5.3536 | 65 | 0 | 14 | 51 | Gibraltar, United Kingdom | ||
3179 | 3179 | Aruba | Netherlands | 3/29/20 23:08 | 12.5211 | -69.9683 | 50 | 0 | 1 | 49 | Aruba, Netherlands | ||
3371 | 3371 | Monaco | 3/29/20 23:08 | 43.7333 | 7.4167 | 46 | 1 | 1 | 44 | Monaco | |||
3194 | 3194 | Fujian | China | 3/29/20 0:57 | 26.0789 | 117.9874 | 338 | 1 | 295 | 42 | Fujian, China | ||
3213 | 3213 | Isle of Man | United Kingdom | 3/29/20 23:08 | 54.2361 | -4.5481 | 42 | 0 | 0 | 42 | Isle of Man, United Kingdom | ||
3348 | 3348 | Kenya | 3/29/20 23:08 | -0.0236 | 37.9062 | 42 | 1 | 1 | 40 | Kenya | |||
3362 | 3362 | Madagascar | 3/29/20 23:08 | -18.766947 | 46.869107 | 39 | 0 | 0 | 39 | Madagascar | |||
3277 | 3277 | Barbados | 3/29/20 23:08 | 13.1939 | -59.5432 | 33 | 0 | 0 | 33 | Barbados | |||
3427 | 3427 | Uganda | 3/29/20 23:08 | 1.373333 | 32.290275 | 33 | 0 | 0 | 33 | Uganda | |||
3193 | 3193 | French Polynesia | France | 3/29/20 23:08 | -17.6797 | 149.4068 | 30 | 0 | 0 | 30 | French Polynesia, France | ||
3254 | 3254 | Tianjin | China | 3/29/20 6:13 | 39.3054 | 117.323 | 166 | 3 | 133 | 30 | Tianjin, China | ||
3344 | 3344 | Jamaica | 3/29/20 23:08 | 18.1096 | -77.2975 | 32 | 1 | 2 | 29 | Jamaica | |||
3436 | 3436 | Zambia | 3/29/20 23:08 | -13.133897 | 27.849332 | 29 | 0 | 0 | 29 | Zambia | |||
3263 | 3263 | Zhejiang | China | 3/29/20 2:22 | 29.1832 | 120.0934 | 1254 | 1 | 1225 | 28 | Zhejiang, China | ||
3276 | 3276 | Bangladesh | 3/29/20 23:08 | 23.685 | 90.3563 | 48 | 5 | 15 | 28 | Bangladesh | |||
3218 | 3218 | Macau | China | 3/28/20 15:17 | 22.1667 | 113.55 | 37 | 0 | 10 | 27 | Macau, China | ||
3312 | 3312 | El Salvador | 3/29/20 23:08 | 13.7942 | -88.8965 | 24 | 0 | 0 | 24 | El Salvador | |||
3328 | 3328 | Guatemala | 3/29/20 23:08 | 15.7835 | -90.2308 | 34 | 1 | 10 | 23 | Guatemala | |||
3423 | 3423 | Togo | 3/29/20 23:08 | 8.6195 | 0.8248 | 25 | 1 | 1 | 23 | Togo | |||
3192 | 3192 | French Guiana | France | 3/29/20 23:08 | 4.0 | -53.0 | 28 | 0 | 6 | 22 | French Guiana, France | ||
3182 | 3182 | Bermuda | United Kingdom | 3/29/20 23:08 | 32.3078 | -64.7505 | 22 | 0 | 2 | 20 | Bermuda, United Kingdom | ||
3212 | 3212 | Inner Mongolia | China | 3/29/20 0:51 | 44.0935 | 113.9448 | 95 | 1 | 74 | 20 | Inner Mongolia, China | ||
3317 | 3317 | Ethiopia | 3/29/20 23:08 | 9.145 | 40.4897 | 21 | 0 | 1 | 20 | Ethiopia | |||
3297 | 3297 | Congo (Brazzaville) | 3/29/20 23:08 | -4.2634 | 15.2832 | 19 | 0 | 0 | 19 | Congo (Brazzaville) | |||
3307 | 3307 | Djibouti | 3/29/20 23:08 | 11.8251 | 42.5903 | 18 | 0 | 0 | 18 | Djibouti | |||
3365 | 3365 | Mali | 3/29/20 23:08 | 17.570692 | -3.996166 | 18 | 1 | 0 | 17 | Mali | |||
3381 | 3381 | Niger | 3/29/20 23:08 | 17.607789 | 8.081666 | 18 | 1 | 0 | 17 | Niger | |||
3329 | 3329 | Guinea | 3/29/20 23:08 | 9.9456 | -9.6966 | 16 | 0 | 0 | 16 | Guinea | |||
3224 | 3224 | New Caledonia | France | 3/29/20 23:08 | -20.904305 | 165.618042 | 15 | 0 | 0 | 15 | New Caledonia, France | ||
3229 | 3229 | Northern Territory | Australia | 3/29/20 23:14 | -12.4634 | 130.8456 | 15 | 0 | 0 | 15 | Northern Territory, Australia | ||
3332 | 3332 | Haiti | 3/29/20 23:08 | 18.9712 | -72.2852 | 8 | 0 | 1 | 14 | Haiti | |||
3214 | 3214 | Jiangsu | China | 3/29/20 2:00 | 32.9711 | 119.455 | 644 | 0 | 631 | 13 | Jiangsu, China | ||
3246 | 3246 | Shandong | China | 3/27/20 7:48 | 36.3427 | 118.1498 | 772 | 7 | 752 | 13 | Shandong, China | ||
3420 | 3420 | Tanzania | 3/29/20 23:08 | -6.369028 | 34.888822 | 14 | 0 | 1 | 13 | Tanzania | |||
3313 | 3313 | Equatorial Guinea | 3/29/20 23:08 | 1.6508 | 10.2679 | 12 | 0 | 0 | 12 | Equatorial Guinea | |||
3314 | 3314 | Eritrea | 3/29/20 23:08 | 15.1794 | 39.7823 | 12 | 0 | 0 | 12 | Eritrea | |||
3372 | 3372 | Mongolia | 3/29/20 23:08 | 46.8625 | 103.8467 | 12 | 0 | 0 | 12 | Mongolia | |||
3195 | 3195 | Gansu | China | 3/29/20 14:25 | 37.8099 | 101.0583 | 138 | 2 | 125 | 11 | Gansu, China | ||
3249 | 3249 | Sichuan | China | 3/29/20 1:49 | 30.6171 | 102.7103 | 550 | 3 | 536 | 11 | Sichuan, China | ||
3252 | 3252 | St Martin | France | 3/29/20 23:08 | 18.0708 | -63.0501 | 11 | 0 | 0 | 11 | St Martin, France | ||
3308 | 3308 | Dominica | 3/29/20 23:08 | 15.415 | -61.371 | 11 | 0 | 0 | 11 | Dominica | |||
3274 | 3274 | Bahamas | 3/29/20 23:08 | 25.025885 | -78.035889 | 11 | 0 | 1 | 10 | Bahamas | |||
3289 | 3289 | Burma | 3/29/20 23:08 | 21.9162 | 95.956 | 10 | 0 | 0 | 10 | Burma | |||
3316 | 3316 | Eswatini | 3/29/20 23:08 | -26.5225 | 31.4659 | 9 | 0 | 0 | 9 | Eswatini | |||
3327 | 3327 | Grenada | 3/29/20 23:08 | 12.1165 | -61.679 | 9 | 0 | 0 | 9 | Grenada | |||
3376 | 3376 | Namibia | 3/29/20 23:08 | -22.9576 | 18.4904 | 11 | 0 | 2 | 9 | Namibia | |||
3199 | 3199 | Greenland | Denmark | 3/29/20 23:08 | 71.7069 | -42.6043 | 10 | 0 | 2 | 8 | Greenland, Denmark | ||
3217 | 3217 | Liaoning | China | 3/29/20 4:59 | 41.2956 | 122.6085 | 134 | 2 | 124 | 8 | Liaoning, China | ||
3245 | 3245 | Shaanxi | China | 3/26/20 2:14 | 35.1917 | 108.8701 | 253 | 3 | 242 | 8 | Shaanxi, China | ||
3353 | 3353 | Laos | 3/29/20 23:08 | 19.85627 | 102.495496 | 8 | 0 | 0 | 8 | Laos | |||
3357 | 3357 | Libya | 3/29/20 23:08 | 26.3351 | 17.228331 | 8 | 0 | 0 | 8 | Libya | |||
3375 | 3375 | Mozambique | 3/29/20 23:08 | -18.665695 | 35.529562 | 8 | 0 | 0 | 8 | Mozambique | |||
3399 | 3399 | Saint Lucia | 3/29/20 23:08 | 13.9094 | -60.9789 | 9 | 0 | 1 | 8 | Saint Lucia | |||
3406 | 3406 | Seychelles | 3/29/20 23:08 | -4.6796 | 55.492 | 8 | 0 | 0 | 8 | Seychelles | |||
3415 | 3415 | Suriname | 3/29/20 23:08 | 3.9193 | -56.0278 | 8 | 0 | 0 | 8 | Suriname | |||
3418 | 3418 | Syria | 3/29/20 23:08 | 34.802075 | 38.996815 | 9 | 1 | 0 | 8 | Syria | |||
3185 | 3185 | Cayman Islands | United Kingdom | 3/29/20 23:08 | 19.3133 | -81.2546 | 8 | 1 | 0 | 7 | Cayman Islands, United Kingdom | ||
3269 | 3269 | Antigua and Barbuda | 3/29/20 23:08 | 17.0608 | -61.7964 | 7 | 0 | 0 | 7 | Antigua and Barbuda | |||
3331 | 3331 | Guyana | 3/29/20 23:08 | 4.860416 | -58.93018 | 8 | 1 | 0 | 7 | Guyana | |||
3250 | 3250 | Sint Maarten | Netherlands | 3/29/20 23:08 | 18.0425 | -63.0548 | 6 | 0 | 0 | 6 | Sint Maarten, Netherlands | ||
3262 | 3262 | Yunnan | China | 3/26/20 23:16 | 24.974 | 101.487 | 180 | 2 | 172 | 6 | Yunnan, China | ||
3281 | 3281 | Benin | 3/29/20 23:08 | 9.3077 | 2.3158 | 6 | 0 | 0 | 6 | Benin | |||
3321 | 3321 | Gabon | 3/29/20 23:08 | -0.8037 | 11.6094 | 7 | 1 | 0 | 6 | Gabon | |||
3333 | 3333 | Holy See | 3/29/20 23:08 | 41.9029 | 12.4534 | 6 | 0 | 0 | 6 | Holy See | |||
3437 | 3437 | Zimbabwe | 3/29/20 23:08 | -19.015438 | 29.154857 | 7 | 1 | 0 | 6 | Zimbabwe | |||
3188 | 3188 | Curacao | Netherlands | 3/29/20 23:08 | 12.1696 | -68.99 | 8 | 1 | 2 | 5 | Curacao, Netherlands | ||
3216 | 3216 | Jilin | China | 3/29/20 0:28 | 43.6661 | 126.1923 | 98 | 1 | 92 | 5 | Jilin, China | ||
3222 | 3222 | Montserrat | United Kingdom | 3/29/20 23:08 | 16.742498 | -62.187366 | 5 | 0 | 0 | 5 | Montserrat, United Kingdom | ||
3242 | 3242 | Saint Barthelemy | France | 3/29/20 23:08 | 17.9 | -62.8333 | 5 | 0 | 0 | 5 | Saint Barthelemy, France | ||
3268 | 3268 | Angola | 3/29/20 23:08 | -11.2027 | 17.8739 | 7 | 2 | 0 | 5 | Angola | |||
3290 | 3290 | Cabo Verde | 3/29/20 23:08 | 16.5388 | -23.0418 | 6 | 1 | 0 | 5 | Cabo Verde |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [03-29-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 );