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 Confirmed 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
3348 3348       Italy 3/30/20 22:52 41.87194 12.56738 101739 11591 14620 75528 Italy
3417 3417       Spain 3/30/20 22:52 40.463667 -3.74922 87956 7716 16780 63460 Spain
3214 3214     Hubei China 3/30/20 12:30 30.9756 112.2707 67801 3186 62889 1726 Hubei, China
3329 3329       Germany 3/30/20 22:52 51.165691 10.451526 66885 645 13500 52740 Germany
3325 3325       France 3/30/20 22:52 46.2276 2.2137 44029 3020 7927 33599 France
3344 3344       Iran 3/30/20 22:52 32.427908 53.688046 41495 2757 13911 24827 Iran
2067 2067 36061 New York City New York US 3/30/20 22:52 40.7672726 -73.97152637 37453 790 0 0 New York City, New York, US
3435 3435       United Kingdom 3/30/20 22:52 55.3781 -3.436 22141 1408 135 20598 United Kingdom
3422 3422       Switzerland 3/30/20 22:52 46.8182 8.2275 15922 359 1823 13740 Switzerland
3283 3283       Belgium 3/30/20 22:52 50.8333 4.469936 11899 513 1527 9859 Belgium
3383 3383       Netherlands 3/30/20 22:52 52.1326 5.2913 11750 864 250 10636 Netherlands
3431 3431       Turkey 3/30/20 22:52 38.9637 35.2433 10827 168 162 10497 Turkey
3354 3354       Korea, South 3/30/20 22:52 35.907757 127.766922 9661 158 5228 4275 Korea, South
3276 3276       Austria 3/30/20 22:52 47.5162 14.5501 9618 108 636 8874 Austria
3059 3059 36119 Westchester New York US 3/30/20 22:52 41.16278376 -73.75741653 9326 10 0 0 Westchester, New York, US
2046 2046 36059 Nassau New York US 3/30/20 22:52 40.74066522 -73.58941873 7344 39 0 0 Nassau, New York, US
3398 3398       Portugal 3/30/20 22:52 39.3999 -8.2245 6408 140 43 6225 Portugal
2721 2721 36103 Suffolk New York US 3/30/20 22:52 40.88320119 -72.8012172 5791 40 0 0 Suffolk, New York, US
3347 3347       Israel 3/30/20 22:52 31.046051 34.851612 4979 17 147 4518 Israel
3290 3290       Brazil 3/30/20 22:52 -14.235 -51.9253 4579 159 120 4300 Brazil
3389 3389       Norway 3/30/20 22:52 60.472 8.4689 4445 32 12 4401 Norway
3421 3421       Sweden 3/30/20 22:52 60.128161 18.643501 4028 146 16 3866 Sweden
2877 2877   Unassigned New Jersey US 3/30/20 22:52 0.0 0.0 3847 91 0 0 Unassigned, New Jersey, US
629 629 17031 Cook Illinois US 3/30/20 22:52 41.84144849 -87.81658794 3727 44 0 0 Cook, Illinois, US
3241 3241     Quebec Canada 3/30/20 22:58 52.9399 -73.5491 3430 67 0 0 Quebec, Canada
3030 3030 26163 Wayne Michigan US 3/30/20 22:52 42.278056 -83.378611 3195 83 0 0 Wayne,Michigan,US
3309 3309       Czechia 3/30/20 22:52 49.8175 15.473 3001 23 25 2953 Czechia
3346 3346       Ireland 3/30/20 22:52 53.1424 -7.6921 2910 54 5 2851 Ireland
3368 3368       Malaysia 3/30/20 22:52 4.210484 101.975766 2626 37 479 2110 Malaysia
3310 3310       Denmark 3/30/20 22:52 56.2639 9.5018 2577 77 1 2499 Denmark
2461 2461 36087 Rockland New York US 3/30/20 22:52 41.15027894 -74.02560498 2511 8 0 0 Rockland, New York, US
191 191 34003 Bergen New Jersey US 3/30/20 22:52 40.96010917 -74.07164325 2482 23 0 0 Bergen, New Jersey, US
1717 1717 6037 Los Angeles California US 3/30/20 22:52 34.30828379 -118.2282411 2474 44 0 0 Los Angeles, California, US
3300 3300       Chile 3/30/20 22:52 -35.6751 -71.543 2449 8 156 2285 Chile
1506 1506 53033 King Washington US 3/30/20 22:52 47.49137892 -121.8346131 2161 144 0 0 King, Washington, US
3400 3400       Romania 3/30/20 22:52 45.9432 24.9668 2109 65 209 1835 Romania
3397 3397       Poland 3/30/20 22:52 51.9194 19.1451 2055 31 7 2017 Poland
3229 3229     New South Wales Australia 3/30/20 22:58 -33.8688 151.2093 2032 8 4 2020 New South Wales, Australia
3365 3365       Luxembourg 3/30/20 22:52 49.8153 6.1296 1988 22 40 1926 Luxembourg
3315 3315       Ecuador 3/30/20 22:52 -1.8312 -78.1834 1962 60 3 1899 Ecuador
3350 3350       Japan 3/30/20 22:52 36.204824 138.252924 1866 54 424 1388 Japan
3401 3401       Russia 3/30/20 22:52 61.52401 105.318756 1836 9 66 1761 Russia
3391 3391       Pakistan 3/30/20 22:52 30.3753 69.3451 1717 21 76 1620 Pakistan
3237 3237     Ontario Canada 3/30/20 22:58 51.2538 -85.3232 1706 31 0 0 Ontario, Canada
1914 1914 12086 Miami-Dade Florida US 3/30/20 22:52 25.6112362 -80.55170587 1632 3 0 0 Miami-Dade, Florida, US
889 889 34013 Essex New Jersey US 3/30/20 22:52 40.78681335 -74.24657979 1564 13 0 0 Essex, New Jersey, US
3396 3396       Philippines 3/30/20 22:52 12.879721 121.774017 1546 78 42 1426 Philippines
3426 3426       Thailand 3/30/20 22:52 15.870032 100.992541 1524 9 127 1286 Thailand
3206 3206     Guangdong China 3/30/20 2:07 23.3417 113.4244 1484 8 1351 125 Guangdong, China
2153 2153 22071 Orleans Louisiana US 3/30/20 22:52 30.06971951 -89.92660315 1480 86 0 0 Orleans, Louisiana, US
3408 3408       Saudi Arabia 3/30/20 22:52 23.885942 45.079162 1453 8 115 1330 Saudi Arabia
901 901 9001 Fairfield Connecticut US 3/30/20 22:52 41.26809896 -73.3881171 1445 21 0 0 Fairfield, Connecticut, US
2146 2146 36071 Orange New York US 3/30/20 22:52 41.40337468 -74.30240757 1435 5 0 0 Orange, New York, US
3343 3343       Indonesia 3/30/20 22:52 -0.7893 113.9213 1414 122 75 1217 Indonesia
2110 2110 26125 Oakland Michigan US 3/30/20 22:52 42.66090111 -83.38595416 1365 48 0 0 Oakland, Michigan, US
3324 3324       Finland 3/30/20 22:52 61.92411 25.748151 1352 13 10 1329 Finland
3416 3416       South Africa 3/30/20 22:52 -30.5595 22.9375 1326 3 31 1292 South Africa
1313 1313 34017 Hudson New Jersey US 3/30/20 22:52 40.73766234 -74.07515667 1314 7 0 0 Hudson, New Jersey, US
3212 3212     Henan China 3/29/20 1:44 33.882 113.614 1276 22 1251 3 Henan, China
3267 3267     Zhejiang China 3/30/20 1:32 29.1832 120.0934 1255 1 1225 29 Zhejiang, China
3342 3342       India 3/30/20 22:52 20.593684 78.96288 1251 32 102 1117 India
2896 2896 34039 Union New Jersey US 3/30/20 22:52 40.65835409 -74.30680092 1213 7 0 0 Union, New Jersey, US
3331 3331       Greece 3/30/20 22:52 39.0742 21.8243 1212 43 52 1117 Greece
284 284 12011 Broward Florida US 3/30/20 22:52 26.15184651 -80.48725556 1152 11 0 0 Broward, Florida, US
1916 1916 25017 Middlesex Massachusetts US 3/30/20 22:52 42.48607732 -71.39049229 1141 8 0 0 Middlesex, Massachusetts, US
1917 1917 34023 Middlesex New Jersey US 3/30/20 22:52 40.43629879 -74.41426991 1123 12 0 0 Middlesex, New Jersey, US
2720 2720 25025 Suffolk Massachusetts US 3/30/20 22:52 42.3279514 -71.07850442 1115 5 0 0 Suffolk, Massachusetts, US
2207 2207 34031 Passaic New Jersey US 3/30/20 22:52 41.03238628 -74.29954144 1091 10 0 0 Passaic, New Jersey, US
3341 3341       Iceland 3/30/20 22:52 64.9631 -19.0208 1086 2 157 927 Iceland
2251 2251 42101 Philadelphia Pennsylvania US 3/30/20 22:52 40.00338507 -75.1379271 1072 8 0 0 Philadelphia, Pennsylvania, US
2634 2634 53061 Snohomish Washington US 3/30/20 22:52 48.04615983 -121.7170703 1068 23 0 0 Snohomish, Washington, US
1953 1953 34025 Monmouth New Jersey US 3/30/20 22:52 40.26549699 -74.22240686 1030 8 0 0 Monmouth, New Jersey, US
3215 3215     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
3374 3374       Mexico 3/30/20 22:52 23.6345 -102.5528 993 20 35 938 Mexico
3182 3182     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3392 3392       Panama 3/30/20 22:52 8.538 -80.7821 989 24 4 961 Panama
3187 3187     British Columbia Canada 3/30/20 22:58 53.7267 -127.6476 970 19 0 0 British Columbia, Canada
3395 3395       Peru 3/30/20 22:52 -9.19 -75.0152 950 24 53 873 Peru
3219 3219     Jiangxi China 3/30/20 3:15 27.614 115.7221 937 1 935 1 Jiangxi, China
3314 3314       Dominican Republic 3/30/20 22:52 18.7357 -70.1627 901 42 4 855 Dominican Republic
3412 3412       Singapore 3/30/20 22:52 1.2833 103.8333 879 3 228 648 Singapore
2112 2112 34029 Ocean New Jersey US 3/30/20 22:52 39.8895449 -74.28089251 874 6 0 0 Ocean, New Jersey, US
2530 2530 6085 Santa Clara California US 3/30/20 22:52 37.23104908 -121.6970462 848 28 0 0 Santa Clara, California, US
1411 1411 22051 Jefferson Louisiana US 3/30/20 22:52 29.74075478 -90.11115756 838 37 0 0 Jefferson, Louisiana, US
3261 3261     Victoria Australia 3/30/20 22:58 -37.8136 144.9631 821 4 191 626 Victoria, Australia
3274 3274       Argentina 3/30/20 22:52 -38.4161 -63.6167 820 23 228 569 Argentina
1797 1797 18097 Marion Indiana US 3/30/20 22:52 39.78163624 -86.13826325 804 12 0 0 Marion, Indiana, US
3301 3301       Colombia 3/30/20 22:52 4.5709 -74.2973 798 12 15 771 Colombia
3306 3306       Croatia 3/30/20 22:52 45.1 15.2 790 6 67 717 Croatia
3410 3410       Serbia 3/30/20 22:52 44.0165 21.0059 785 16 0 769 Serbia
3250 3250     Shandong China 3/30/20 0:22 36.3427 118.1498 773 7 753 13 Shandong, China
3414 3414       Slovenia 3/30/20 22:52 46.1512 14.9955 756 11 10 735 Slovenia
528 528 32003 Clark Nevada US 3/30/20 22:52 36.21458855 -115.0130241 753 14 0 0 Clark, Nevada, US
1746 1746 26099 Macomb Michigan US 3/30/20 22:52 42.69158356 -82.92752801 728 27 0 0 Macomb, Michigan, US
2018 2018 34027 Morris New Jersey US 3/30/20 22:52 40.86095313 -74.5455371 720 8 0 0 Morris, New Jersey, US
3320 3320       Estonia 3/30/20 22:52 58.5953 25.0136 715 3 20 692 Estonia
3311 3311       Diamond Princess 3/30/20 22:52 0.0 0.0 712 10 603 99 Diamond Princess
3399 3399       Qatar 3/30/20 22:52 25.3548 51.1839 693 1 51 641 Qatar
1788 1788 4013 Maricopa Arizona US 3/30/20 22:52 33.34835867 -112.4918154 690 5 0 0 Maricopa, Arizona, US
3242 3242     Queensland Australia 3/30/20 22:58 -27.4698 153.0251 689 2 8 679 Queensland, Australia

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