03-28-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,433 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
3339 3339       Italy 3/28/20 23:05 41.87194 12.56738 92472 10023 12384 70065 Italy
3408 3408       Spain 3/28/20 23:05 40.463667 -3.74922 73235 5982 12285 54968 Spain
3206 3206     Hubei China 3/28/20 1:26 30.9756 112.2707 67801 3177 62098 2526 Hubei, China
3320 3320       Germany 3/28/20 23:05 51.165691 10.451526 57695 433 8481 48781 Germany
3316 3316       France 3/28/20 23:05 46.2276 2.2137 37162 2311 5700 29561 France
3335 3335       Iran 3/28/20 23:05 32.427908 53.688046 35408 2517 11679 21212 Iran
2067 2067 36061 New York City New York US 3/28/20 23:05 40.7672726 -73.97152637 29776 517 0 0 New York City, New York, US
3426 3426       United Kingdom 3/28/20 23:05 55.3781 -3.436 17089 1019 135 15935 United Kingdom
3413 3413       Switzerland 3/28/20 23:05 46.8182 8.2275 14076 264 1530 12282 Switzerland
3374 3374       Netherlands 3/28/20 23:05 52.1326 5.2913 9762 639 3 9120 Netherlands
3345 3345       Korea, South 3/28/20 23:05 35.907757 127.766922 9478 144 4811 4523 Korea, South
3275 3275       Belgium 3/28/20 23:05 50.8333 4.469936 9134 353 1063 7718 Belgium
3268 3268       Austria 3/28/20 23:05 47.5162 14.5501 8271 68 225 7978 Austria
3051 3051 36119 Westchester New York US 3/28/20 23:05 41.16278376 -73.75741653 7875 10 0 0 Westchester, New York, US
3422 3422       Turkey 3/28/20 23:05 38.9637 35.2433 7402 108 70 7224 Turkey
2046 2046 36059 Nassau New York US 3/28/20 23:05 40.74066522 -73.58941873 5537 27 0 0 Nassau, New York, US
3389 3389       Portugal 3/28/20 23:05 39.3999 -8.2245 5170 100 43 5027 Portugal
2721 2721 36103 Suffolk New York US 3/28/20 23:05 40.88320119 -72.8012172 4138 30 0 0 Suffolk, New York, US
3380 3380       Norway 3/28/20 23:05 60.472 8.4689 4015 23 7 3985 Norway
3281 3281       Brazil 3/28/20 23:05 -14.235 -51.9253 3904 111 6 3787 Brazil
3338 3338       Israel 3/28/20 23:05 31.046051 34.851612 3901 13 84 3518 Israel
3412 3412       Sweden 3/28/20 23:05 60.128161 18.643501 3447 105 16 3326 Sweden
3300 3300       Czechia 3/28/20 23:05 49.8175 15.473 2631 11 11 2609 Czechia
629 629 17031 Cook Illinois US 3/28/20 23:05 41.84144849 -87.81658794 2613 28 0 0 Cook, Illinois, US
3233 3233     Quebec Canada 3/28/20 23:10 52.9399 -73.5491 2498 43 0 0 Quebec, Canada
2871 2871   Unassigned New Jersey US 3/28/20 23:05 0.0 0.0 2478 86 0 0 Unassigned, New Jersey, US
3337 3337       Ireland 3/28/20 23:05 53.1424 -7.6921 2415 36 5 2374 Ireland
3359 3359       Malaysia 3/28/20 23:05 4.210484 101.975766 2320 27 320 1973 Malaysia
3022 3022 26163 Wayne Michigan US 3/28/20 23:05 42.28098405 -83.281255 2316 46 0 0 Wayne, Michigan, US
3301 3301       Denmark 3/28/20 23:05 56.2639 9.5018 2201 65 1 2135 Denmark
1506 1506 53033 King Washington US 3/28/20 23:05 47.49137892 -121.8346131 2077 136 0 0 King, Washington, US
3291 3291       Chile 3/28/20 23:05 -35.6751 -71.543 1909 6 61 1842 Chile
2461 2461 36087 Rockland New York US 3/28/20 23:05 41.15027894 -74.02560498 1896 8 0 0 Rockland, New York, US
191 191 34003 Bergen New Jersey US 3/28/20 23:05 40.96010917 -74.07164325 1838 13 0 0 Bergen, New Jersey, US
3356 3356       Luxembourg 3/28/20 23:05 49.8153 6.1296 1831 18 40 1773 Luxembourg
3306 3306       Ecuador 3/28/20 23:05 -1.8312 -78.1834 1823 48 3 1772 Ecuador
3341 3341       Japan 3/28/20 23:05 36.204824 138.252924 1693 52 404 1237 Japan
3388 3388       Poland 3/28/20 23:05 51.9194 19.1451 1638 18 7 1613 Poland
3221 3221     New South Wales Australia 3/28/20 23:11 -33.8688 151.2093 1617 8 4 1605 New South Wales, Australia
3382 3382       Pakistan 3/28/20 23:05 30.3753 69.3451 1495 12 29 1454 Pakistan
3198 3198     Guangdong China 3/28/20 2:13 23.3417 113.4244 1467 8 1341 118 Guangdong, China
1717 1717 6037 Los Angeles California US 3/28/20 23:05 34.30828379 -118.2282411 1465 26 0 0 Los Angeles, California, US
3391 3391       Romania 3/28/20 23:05 45.9432 24.9668 1452 37 139 1276 Romania
2153 2153 22071 Orleans Louisiana US 3/28/20 23:05 30.06971951 -89.92660315 1298 70 0 0 Orleans, Louisiana, US
3204 3204     Henan China 3/28/20 1:35 33.882 113.614 1275 22 1251 2 Henan, China
3392 3392       Russia 3/28/20 23:05 61.52401 105.318756 1264 4 49 1211 Russia
3259 3259     Zhejiang China 3/28/20 2:01 29.1832 120.0934 1251 1 1225 25 Zhejiang, China
3417 3417       Thailand 3/28/20 23:05 15.870032 100.992541 1245 6 100 1142 Thailand
3399 3399       Saudi Arabia 3/28/20 23:05 23.885942 45.079162 1203 4 37 1162 Saudi Arabia
3407 3407       South Africa 3/28/20 23:05 -30.5595 22.9375 1187 1 31 1155 South Africa
3315 3315       Finland 3/28/20 23:05 61.92411 25.748151 1167 9 10 1148 Finland
3334 3334       Indonesia 3/28/20 23:05 -0.7893 113.9213 1155 102 59 994 Indonesia
3229 3229     Ontario Canada 3/28/20 23:10 51.2538 -85.3232 1144 18 0 0 Ontario, Canada
2146 2146 36071 Orange New York US 3/28/20 23:05 41.40337468 -74.30240757 1101 4 0 0 Orange, New York, US
889 889 34013 Essex New Jersey US 3/28/20 23:05 40.78681335 -74.24657979 1086 7 0 0 Essex, New Jersey, US
3387 3387       Philippines 3/28/20 23:05 12.879721 121.774017 1075 68 35 972 Philippines
3322 3322       Greece 3/28/20 23:05 39.0742 21.8243 1061 32 52 977 Greece
2110 2110 26125 Oakland Michigan US 3/28/20 23:05 42.66090111 -83.38595416 1018 31 0 0 Oakland, Michigan, US
3207 3207     Hunan China 3/14/20 8:25 27.6104 111.7088 1018 4 1014 0 Hunan, China
1914 1914 12086 Miami-Dade Florida US 3/28/20 23:05 25.6112362 -80.55170587 1003 2 0 0 Miami-Dade, Florida, US
3174 3174     Anhui China 3/8/20 5:19 31.8257 117.2264 990 6 984 0 Anhui, China
3333 3333       India 3/28/20 23:05 20.593684 78.96288 987 24 84 879 India
3332 3332       Iceland 3/28/20 23:05 64.9631 -19.0208 963 2 114 847 Iceland
3211 3211     Jiangxi China 3/23/20 1:27 27.614 115.7221 936 1 934 1 Jiangxi, China
2634 2634 53061 Snohomish Washington US 3/28/20 23:05 48.04615983 -121.7170703 913 23 0 0 Snohomish, Washington, US
901 901 9001 Fairfield Connecticut US 3/28/20 23:05 41.26809896 -73.3881171 908 20 0 0 Fairfield, Connecticut, US
3179 3179     British Columbia Canada 3/28/20 23:10 53.7267 -127.6476 884 17 0 0 British Columbia, Canada
2720 2720 25025 Suffolk Massachusetts US 3/28/20 23:05 42.3279514 -71.07850442 843 3 0 0 Suffolk, Massachusetts, US
1916 1916 25017 Middlesex Massachusetts US 3/28/20 23:05 42.48607732 -71.39049229 842 5 0 0 Middlesex, Massachusetts, US
284 284 12011 Broward Florida US 3/28/20 23:05 26.15184651 -80.48725556 814 10 0 0 Broward, Florida, US
1917 1917 34023 Middlesex New Jersey US 3/28/20 23:05 40.43629879 -74.41426991 808 4 0 0 Middlesex, New Jersey, US
2251 2251 42101 Philadelphia Pennsylvania US 3/28/20 23:05 40.00338507 -75.1379271 803 5 0 0 Philadelphia, Pennsylvania, US
3403 3403       Singapore 3/28/20 23:05 1.2833 103.8333 802 2 198 602 Singapore
3383 3383       Panama 3/28/20 23:05 8.538 -80.7821 786 14 2 770 Panama
1953 1953 34025 Monmouth New Jersey US 3/28/20 23:05 40.26549699 -74.22240686 781 6 0 0 Monmouth, New Jersey, US
3242 3242     Shandong China 3/27/20 7:48 36.3427 118.1498 772 7 752 13 Shandong, China
1313 1313 34017 Hudson New Jersey US 3/28/20 23:05 40.73766234 -74.07515667 771 4 0 0 Hudson, New Jersey, US
1411 1411 22051 Jefferson Louisiana US 3/28/20 23:05 29.74075478 -90.11115756 744 26 0 0 Jefferson, Louisiana, US
2888 2888 34039 Union New Jersey US 3/28/20 23:05 40.65835409 -74.30680092 742 0 0 0 Union, New Jersey, US
3305 3305       Dominican Republic 3/28/20 23:05 18.7357 -70.1627 719 28 3 688 Dominican Republic
3365 3365       Mexico 3/28/20 23:05 23.6345 -102.5528 717 12 4 701 Mexico
3302 3302       Diamond Princess 3/28/20 23:05 0.0 0.0 712 10 597 105 Diamond Princess
3266 3266       Argentina 3/28/20 23:05 -38.4161 -63.6167 690 18 72 600 Argentina
3253 3253     Victoria Australia 3/28/20 23:11 -37.8136 144.9631 685 3 191 491 Victoria, Australia
3405 3405       Slovenia 3/28/20 23:05 46.1512 14.9955 684 9 10 665 Slovenia
3386 3386       Peru 3/28/20 23:05 -9.19 -75.0152 671 16 16 639 Peru
3401 3401       Serbia 3/28/20 23:05 44.0165 21.0059 659 10 0 649 Serbia
3297 3297       Croatia 3/28/20 23:05 45.1 15.2 657 5 45 607 Croatia
3311 3311       Estonia 3/28/20 23:05 58.5953 25.0136 645 1 20 624 Estonia
3210 3210     Jiangsu China 3/27/20 1:49 32.9711 119.455 641 0 631 10 Jiangsu, China
3234 3234     Queensland Australia 3/28/20 23:11 -27.4698 153.0251 625 1 8 616 Queensland, Australia
2112 2112 34029 Ocean New Jersey US 3/28/20 23:05 39.8895449 -74.28089251 624 4 0 0 Ocean, New Jersey, US
2207 2207 34031 Passaic New Jersey US 3/28/20 23:05 41.03238628 -74.29954144 608 7 0 0 Passaic, New Jersey, US
3292 3292       Colombia 3/28/20 23:05 4.5709 -74.2973 608 6 10 592 Colombia
2530 2530 6085 Santa Clara California US 3/28/20 23:05 37.23104908 -121.6970462 591 25 0 0 Santa Clara, California, US
3390 3390       Qatar 3/28/20 23:05 25.3548 51.1839 590 1 45 544 Qatar
1797 1797 18097 Marion Indiana US 3/28/20 23:05 39.78163624 -86.13826325 584 10 0 0 Marion, Indiana, US
3183 3183     Chongqing China 3/23/20 23:34 30.0572 107.874 578 6 570 2 Chongqing, China
3307 3307       Egypt 3/28/20 23:05 26.820553 30.802498 576 36 121 419 Egypt
3177 3177     Beijing China 3/28/20 6:15 40.1824 116.4142 573 8 410 155 Beijing, China

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [03-28-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
);