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 Long_ descending

✎ 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
3323 3323       Fiji 3/30/20 22:52 -17.7134 178.065 5 0 0 5 Fiji
3384 3384       New Zealand 3/30/20 22:52 -40.9006 174.886 589 1 63 525 New Zealand
3228 3228     New Caledonia France 3/30/20 22:52 -20.904305 165.618042 15 0 0 15 New Caledonia, France
3242 3242     Queensland Australia 3/30/20 22:58 -27.4698 153.0251 689 2 8 679 Queensland, Australia
3229 3229     New South Wales Australia 3/30/20 22:58 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
3197 3197     French Polynesia France 3/30/20 22:52 -17.6797 149.4068 36 0 0 36 French Polynesia, France
3184 3184     Australian Capital Territory Australia 3/30/20 22:58 -35.4735 149.0124 78 1 2 75 Australian Capital Territory, Australia
3257 3257     Tasmania Australia 3/30/20 22:58 -42.8821 147.3272 66 0 5 61 Tasmania, Australia
3232 3232 69000   Northern Mariana Islands US 3/30/20 22:52 15.0979 145.6739 0 0 0 0 Northern Mariana Islands, US
3261 3261     Victoria Australia 3/30/20 22:58 -37.8136 144.9631 821 4 191 626 Victoria, Australia
3205 3205 66000   Guam US 3/30/20 22:52 13.4443 144.7937 58 1 0 0 Guam, US
3393 3393       Papua New Guinea 3/30/20 22:52 -6.314993 143.95555 1 0 0 1 Papua New Guinea
3255 3255     South Australia Australia 3/30/20 22:58 -34.9285 138.6007 305 0 6 299 South Australia, Australia
3350 3350       Japan 3/30/20 22:52 36.204824 138.252924 1866 54 424 1388 Japan
3233 3233     Northern Territory Australia 3/30/20 22:58 -12.4634 130.8456 15 0 0 15 Northern Territory, Australia
3354 3354       Korea, South 3/30/20 22:52 35.907757 127.766922 9661 158 5228 4275 Korea, South
3211 3211     Heilongjiang China 3/26/20 0:15 47.862 127.7615 484 13 469 2 Heilongjiang, China
3220 3220     Jilin China 3/29/20 0:28 43.6661 126.1923 98 1 92 5 Jilin, China
3427 3427       Timor-Leste 3/30/20 22:52 -8.874217 125.727539 1 0 0 1 Timor-Leste
3221 3221     Liaoning China 3/29/20 23:44 41.2956 122.6085 136 2 124 10 Liaoning, China
3396 3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines
3251 3251     Shanghai China 3/30/20 5:05 31.202 121.4491 498 5 338 155 Shanghai, China
3424 3424       Taiwan* 3/30/20 7:11 23.7 121.0 306 5 39 262 Taiwan*
3267 3267     Zhejiang China 3/30/20 1:32 29.1832 120.0934 1255 1 1225 29 Zhejiang, China
3218 3218     Jiangsu China 3/30/20 1:49 32.9711 119.455 645 0 631 14 Jiangsu, China
3250 3250     Shandong China 3/30/20 0:22 36.3427 118.1498 773 7 753 13 Shandong, China
3198 3198     Fujian China 3/30/20 0:32 26.0789 117.9874 340 1 295 44 Fujian, China
3258 3258     Tianjin China 3/30/20 8:42 39.3054 117.323 174 3 133 38 Tianjin, China
3182 3182     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3185 3185     Beijing China 3/30/20 5:34 40.1824 116.4142 577 8 415 154 Beijing, China
3210 3210     Hebei China 3/30/20 2:07 39.549 116.1306 321 6 310 5 Hebei, China
3263 3263     Western Australia Australia 3/30/20 22:58 -31.9505 115.8605 355 2 41 312 Western Australia, Australia
3219 3219     Jiangxi China 3/30/20 3:15 27.614 115.7221 937 1 935 1 Jiangxi, China
3291 3291       Brunei 3/30/20 22:52 4.5353 114.7277 127 1 38 88 Brunei
3213 3213     Hong Kong China 3/30/20 9:27 22.3 114.2 682 4 123 555 Hong Kong, China
3216 3216     Inner Mongolia China 3/30/20 0:06 44.0935 113.9448 97 1 74 22 Inner Mongolia, China
3343 3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia
3212 3212     Henan China 3/29/20 1:44 33.882 113.614 1276 22 1251 3 Henan, China
3222 3222     Macau China 3/30/20 2:07 22.1667 113.55 38 0 10 28 Macau, China
3206 3206     Guangdong China 3/30/20 2:07 23.3417 113.4244 1484 8 1351 125 Guangdong, China
3252 3252     Shanxi China 3/29/20 0:20 37.5777 112.2922 136 0 133 3 Shanxi, China
3214 3214     Hubei China 3/30/20 12:30 30.9756 112.2707 67801 3186 62889 1726 Hubei, China
3215 3215     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
3209 3209     Hainan China 3/24/20 4:29 19.1959 109.7453 168 6 162 0 Hainan, China
3249 3249     Shaanxi China 3/26/20 2:14 35.1917 108.8701 253 3 242 8 Shaanxi, China
3207 3207     Guangxi China 3/20/20 4:33 23.8298 108.7881 254 2 250 2 Guangxi, China
3439 3439       Vietnam 3/30/20 22:52 14.058324 108.277199 203 0 55 148 Vietnam
3191 3191     Chongqing China 3/29/20 0:14 30.0572 107.874 579 6 570 3 Chongqing, China
3208 3208     Guizhou China 3/18/20 1:37 26.8154 106.8748 146 2 144 0 Guizhou, China
3231 3231     Ningxia China 3/16/20 8:47 37.2692 106.1655 75 0 75 0 Ningxia, China
3401 3401       Russia 3/30/20 22:52 61.52401 105.318756 1836 9 66 1761 Russia
3296 3296       Cambodia 3/30/20 22:52 11.55 104.9167 107 0 21 86 Cambodia
3377 3377       Mongolia 3/30/20 22:52 46.8625 103.8467 12 0 2 10 Mongolia
3412 3412       Singapore 3/30/20 22:52 1.2833 103.8333 879 3 228 648 Singapore
3253 3253     Sichuan China 3/30/20 1:09 30.6171 102.7103 550 3 536 11 Sichuan, China
3358 3358       Laos 3/30/20 22:52 19.85627 102.495496 8 0 0 8 Laos
3368 3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3266 3266     Yunnan China 3/26/20 23:16 24.974 101.487 180 2 172 6 Yunnan, China
3199 3199     Gansu China 3/29/20 14:25 37.8099 101.0583 138 2 125 11 Gansu, China
3426 3426       Thailand 3/30/20 22:52 15.870032 100.992541 1524 9 127 1286 Thailand
3240 3240     Qinghai China 2/23/20 11:19 35.7452 95.9956 18 0 18 0 Qinghai, China
3294 3294       Burma 3/30/20 22:52 21.9162 95.956 14 0 0 14 Burma
3286 3286       Bhutan 3/30/20 22:52 27.5142 90.4336 4 0 0 4 Bhutan
3280 3280       Bangladesh 3/30/20 22:52 23.685 90.3563 49 5 19 25 Bangladesh
3259 3259     Tibet China 2/23/20 11:19 31.6927 88.0924 1 0 1 0 Tibet, China
3264 3264     Xinjiang China 3/8/20 5:31 41.1129 85.2401 76 3 73 0 Xinjiang, China
3382 3382       Nepal 3/30/20 22:52 28.1667 84.25 5 0 1 4 Nepal
3418 3418       Sri Lanka 3/30/20 22:52 7.873054 80.771797 122 2 15 105 Sri Lanka
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
3357 3357       Kyrgyzstan 3/30/20 22:52 41.20438 74.766098 94 0 3 91 Kyrgyzstan
3369 3369       Maldives 3/30/20 22:52 3.2028 73.2207 17 0 13 4 Maldives
3391 3391       Pakistan 3/30/20 22:52 30.3753 69.3451 1717 21 76 1620 Pakistan
3268 3268       Afghanistan 3/30/20 22:52 33.93911 67.709953 146 4 2 164 Afghanistan
3352 3352       Kazakhstan 3/30/20 22:52 48.0196 66.9237 302 1 21 280 Kazakhstan
3437 3437       Uzbekistan 3/30/20 22:52 41.377491 64.585262 149 2 7 140 Uzbekistan
3373 3373       Mauritius 3/30/20 22:52 -20.348404 57.552152 128 3 0 125 Mauritius
3390 3390       Oman 3/30/20 22:52 21.512583 55.923255 179 0 29 150 Oman
3245 3245     Reunion France 3/30/20 22:52 -21.1151 55.5364 224 0 1 223 Reunion, France
3411 3411       Seychelles 3/30/20 22:52 -4.6796 55.492 8 0 0 8 Seychelles
3434 3434       United Arab Emirates 3/30/20 22:52 23.424076 53.847818 611 5 61 545 United Arab Emirates
3344 3344       Iran 3/30/20 22:52 32.427908 53.688046 41495 2757 13911 24827 Iran
3399 3399       Qatar 3/30/20 22:52 25.3548 51.1839 693 1 51 641 Qatar
3279 3279       Bahrain 3/30/20 22:52 26.0275 50.55 515 4 279 232 Bahrain
3277 3277       Azerbaijan 3/30/20 22:52 40.1431 47.5769 273 4 26 243 Azerbaijan
3356 3356       Kuwait 3/30/20 22:52 29.31166 47.481766 266 0 72 194 Kuwait
3367 3367       Madagascar 3/30/20 22:52 -18.766947 46.869107 43 0 0 43 Madagascar
3415 3415       Somalia 3/30/20 22:52 5.152149 46.199616 3 0 0 3 Somalia
3225 3225     Mayotte France 3/30/20 22:52 -12.8275 45.166244 82 0 10 72 Mayotte, France
3408 3408       Saudi Arabia 3/30/20 22:52 23.885942 45.079162 1453 8 115 1330 Saudi Arabia
3275 3275       Armenia 3/30/20 22:52 40.0691 45.0382 482 3 30 449 Armenia
3345 3345       Iraq 3/30/20 22:52 33.223191 43.679291 630 46 152 432 Iraq
3328 3328       Georgia 3/30/20 22:52 42.3154 43.3569 103 0 20 83 Georgia
3312 3312       Djibouti 3/30/20 22:52 11.8251 42.5903 18 0 0 18 Djibouti
3322 3322       Ethiopia 3/30/20 22:52 9.145 40.4897 23 0 4 19 Ethiopia
3319 3319       Eritrea 3/30/20 22:52 15.1794 39.7823 12 0 0 12 Eritrea
3423 3423       Syria 3/30/20 22:52 34.802075 38.996815 10 2 0 8 Syria
3353 3353       Kenya 3/30/20 22:52 -0.0236 37.9062 50 1 1 48 Kenya
3351 3351       Jordan 3/30/20 22:52 31.24 36.51 268 5 26 237 Jordan
3360 3360       Lebanon 3/30/20 22:52 33.8547 35.8623 446 11 35 400 Lebanon
3380 3380       Mozambique 3/30/20 22:52 -18.665695 35.529562 8 0 0 8 Mozambique

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