04-24-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,128 rows sorted by Active descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Last_Update (date)

Link rowid FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active ▲ Combined_Key
1840 1840 36061 New York City New York US 2020-04-25 06:30:53 40.76727260000001 -73.97152637 150473 16646 0 133827 New York City, New York, US
3112 3112       United Kingdom 2020-04-25 06:30:33 55.3781 -3.4360000000000004 143464 19506 0 123958 United Kingdom
3021 3021       Italy 2020-04-25 06:30:33 41.87194 12.56738 192994 25969 60498 106527 Italy
3094 3094       Spain 2020-04-25 06:30:33 40.463667 -3.7492199999999998 219764 22524 92355 104885 Spain
2998 2998       France 2020-04-25 06:30:33 46.2276 2.2137 158653 22216 43493 92898 France
3108 3108       Turkey 2020-04-25 06:30:33 38.9637 35.2433 104912 2600 21737 80575 Turkey
3075 3075       Russia 2020-04-25 06:30:33 61.52401 105.31875600000001 68622 615 5568 62439 Russia
3002 3002       Germany 2020-04-25 06:30:33 51.165690999999995 10.451526 154999 5760 109800 39439 Germany
3057 3057       Netherlands 2020-04-25 06:30:33 52.1326 5.2913 36535 4289 0 32246 Netherlands
1821 1821 36059 Nassau New York US 2020-04-23 00:00:00 40.74066522 -73.58941873 32765 1518 0 31247 Nassau, New York, US
2426 2426 36103 Suffolk New York US 2020-04-23 00:00:00 40.88320119 -72.8012172 30606 993 0 29613 Suffolk, New York, US
2955 2955       Belgium 2020-04-25 06:30:33 50.8333 4.469936 44293 6679 10122 27492 Belgium
569 569 17031 Cook Illinois US 2020-04-25 06:30:53 41.84144849 -87.81658794 27616 1220 0 26396 Cook, Illinois, US
2751 2751 36119 Westchester New York US 2020-04-23 00:00:00 41.16278376 -73.75741653 26633 891 0 25742 Westchester, New York, US
2962 2962       Brazil 2020-04-25 06:30:33 -14.235 -51.9253 54043 3704 27655 22684 Brazil
2918 2918     Quebec Canada 2020-04-25 06:30:55 52.9399 -73.5491 22616 1968 0 21276 Quebec, Canada
2988 2988       Ecuador 2020-04-25 06:30:33 -1.8312 -78.1834 22719 576 1366 20777 Ecuador
3072 3072       Portugal 2020-04-25 06:30:33 39.3999 -8.2245 22797 854 1228 20715 Portugal
3015 3015       India 2020-04-25 06:30:33 20.593684 78.96288 24530 780 5498 18252 India
1515 1515 6037 Los Angeles California US 2020-04-25 06:30:53 34.30828379 -118.2282411 18545 850 0 17695 Los Angeles, California, US
3017 3017       Iran 2020-04-25 06:30:33 32.427908 53.68804599999999 88194 5574 66599 16021 Iran
3098 3098       Sweden 2020-04-25 06:30:33 60.128161 18.643501 17567 2152 1005 14410 Sweden
2725 2725 26163 Wayne Michigan US 2020-04-25 06:30:53 42.28098405 -83.281255 15407 1443 0 13964 Wayne, Michigan, US
2914 2914     Ontario Canada 2020-04-25 06:30:55 51.2538 -85.3232 14550 862 0 13688 Ontario, Canada
3069 3069       Peru 2020-04-25 06:30:33 -9.19 -75.0152 21648 634 7496 13518 Peru
171 171 34003 Bergen New Jersey US 2020-04-25 06:30:53 40.96010917 -74.07164325 14363 934 0 13429 Bergen, New Jersey, US
3083 3083       Saudi Arabia 2020-04-25 06:30:33 23.885942 45.079162 15102 127 2049 12926 Saudi Arabia
1161 1161 34017 Hudson New Jersey US 2020-04-25 06:30:53 40.73766234 -74.07515667 13011 706 0 12305 Hudson, New Jersey, US
2013 2013 42101 Philadelphia Pennsylvania US 2020-04-25 06:30:53 40.00338507 -75.1379271 11877 449 0 11428 Philadelphia, Pennsylvania, US
1700 1700 25017 Middlesex Massachusetts US 2020-04-25 06:30:53 42.48607732 -71.39049229 11681 428 0 11253 Middlesex, Massachusetts, US
789 789 34013 Essex New Jersey US 2020-04-25 06:30:53 40.78681335 -74.24657979 12110 975 0 11135 Essex, New Jersey, US
3088 3088       Singapore 2020-04-25 06:30:33 1.2833 103.8333 12075 12 956 11107 Singapore
3023 3023       Japan 2020-04-25 06:30:33 36.204824 138.252924 12829 345 1530 10954 Japan
2603 2603 34039 Union New Jersey US 2020-04-25 06:30:53 40.65835409 -74.30680092 11208 542 0 10666 Union, New Jersey, US
1697 1697 12086 Miami-Dade Florida US 2020-04-25 06:30:53 25.6112362 -80.55170587 10926 287 0 10639 Miami-Dade, Florida, US
2425 2425 25025 Suffolk Massachusetts US 2020-04-25 06:30:53 42.3279514 -71.07850442 10724 285 0 10439 Suffolk, Massachusetts, US
1975 1975 34031 Passaic New Jersey US 2020-04-25 06:30:53 41.03238628 -74.29954144 10291 383 0 9908 Passaic, New Jersey, US
2194 2194 36087 Rockland New York US 2020-04-23 00:00:00 41.15027894 -74.02560498 10091 453 0 9638 Rockland, New York, US
800 800 9001 Fairfield Connecticut US 2020-04-25 06:30:53 41.26809896 -73.3881171 10227 662 0 9565 Fairfield, Connecticut, US
1701 1701 34023 Middlesex New Jersey US 2020-04-25 06:30:53 40.43629879 -74.41426991 9789 413 0 9376 Middlesex, New Jersey, US
3065 3065       Pakistan 2020-04-25 06:30:33 30.3753 69.3451 11940 253 2755 8932 Pakistan
3020 3020       Israel 2020-04-25 06:30:33 31.046051000000002 34.851612 15143 199 6291 8861 Israel
3071 3071       Poland 2020-04-25 06:30:33 51.9194 19.1451 10892 494 1944 8454 Poland
3019 3019       Ireland 2020-04-25 06:30:33 53.1424 -7.6921 18184 1014 9233 7937 Ireland
3073 3073       Qatar 2020-04-25 06:30:33 25.3548 51.1839 8525 10 809 7706 Qatar
2954 2954       Belarus 2020-04-25 06:30:33 53.7098 27.9534 8773 63 1120 7590 Belarus
3111 3111       United Arab Emirates 2020-04-25 06:30:33 23.424076 53.847818000000004 9281 64 1760 7457 United Arab Emirates
3063 3063       Norway 2020-04-25 06:30:33 60.472 8.4689 7463 199 32 7232 Norway
3074 3074       Romania 2020-04-25 06:30:33 45.9432 24.9668 10417 567 2817 7033 Romania
1914 1914 36071 Orange New York US 2020-04-23 00:00:00 41.40337468 -74.30240757 7155 274 0 6881 Orange, New York, US
3110 3110       Ukraine 2020-04-25 06:25:11 48.3794 31.1656 7647 193 601 6853 Ukraine
788 788 25009 Essex Massachusetts US 2020-04-25 06:30:53 42.6687626 -70.94687179 6841 245 0 6596 Essex, Massachusetts, US
3016 3016       Indonesia 2020-04-25 06:30:33 -0.7893 113.9213 8211 689 1002 6520 Indonesia
1879 1879 26125 Oakland Michigan US 2020-04-25 06:30:53 42.66090111 -83.38595416 6804 585 0 6219 Oakland, Michigan, US
3099 3099       Switzerland 2020-04-25 06:30:33 46.8182 8.2275 28677 1589 21000 6088 Switzerland
3070 3070       Philippines 2020-04-25 06:30:33 12.879721 121.77401699999999 7192 477 762 5953 Philippines
1921 1921 22071 Orleans Louisiana US 2020-04-25 06:30:53 30.06971951 -89.92660315 6286 392 0 5894 Orleans, Louisiana, US
1836 1836 9009 New Haven Connecticut US 2020-04-25 06:30:53 41.4080325 -72.93620426 6286 396 0 5890 New Haven, Connecticut, US
2973 2973       Chile 2020-04-25 06:30:33 -35.6751 -71.543 12306 174 6327 5805 Chile
1248 1248 22051 Jefferson Louisiana US 2020-04-25 06:30:53 29.74075478 -90.11115756 5985 323 0 5662 Jefferson, Louisiana, US
3085 3085       Serbia 2020-04-25 06:30:33 44.0165 21.0059 6630 125 870 5635 Serbia
1070 1070 48201 Harris Texas US 2020-04-25 06:30:53 29.86 -95.39 5482 84 0 5398 Harris, Texas, US
1881 1881 34029 Ocean New Jersey US 2020-04-25 06:30:53 39.8895449 -74.28089251 5612 301 0 5311 Ocean, New Jersey, US
1328 1328 53033 King Washington US 2020-04-24 00:00:00 47.49137892 -121.8346131 5637 418 0 5244 King, Washington, US
1733 1733 34025 Monmouth New Jersey US 2020-04-25 06:30:53 40.26549699 -74.22240686 5368 273 0 5095 Monmouth, New Jersey, US
3066 3066       Panama 2020-04-25 06:30:33 8.538 -80.7821 5338 154 319 4865 Panama
2987 2987       Dominican Republic 2020-04-25 06:30:33 18.7357 -70.1627 5749 267 763 4719 Dominican Republic
1864 1864 25021 Norfolk Massachusetts US 2020-04-25 06:30:53 42.16073095 -71.20530408 4979 290 0 4689 Norfolk, Massachusetts, US
2982 2982       Czechia 2020-04-25 06:30:33 49.8175 15.472999999999999 7273 214 2371 4688 Czechia
2101 2101 44007 Providence Rhode Island US 2020-04-25 06:30:53 41.87064746 -71.57753536 4603 0 0 4603 Providence, Rhode Island, US
1541 1541 26099 Macomb Michigan US 2020-04-25 06:30:53 42.69158356 -82.92752801 5022 504 0 4518 Macomb, Michigan, US
3048 3048       Mexico 2020-04-25 06:30:33 23.6345 -102.5528 12872 1221 7149 4502 Mexico
2952 2952       Bangladesh 2020-04-25 06:30:33 23.685 90.3563 4689 131 112 4446 Bangladesh
250 250 12011 Broward Florida US 2020-04-25 06:30:53 26.15184651 -80.48725556 4591 162 0 4429 Broward, Florida, US
1794 1794 34027 Morris New Jersey US 2020-04-25 06:30:53 40.86095313 -74.54553709999998 4716 340 0 4376 Morris, New Jersey, US
1590 1590 18097 Marion Indiana US 2020-04-25 06:30:53 39.78163624 -86.13826325 4537 238 0 4299 Marion, Indiana, US
2098 2098 24033 Prince George's Maryland US 2020-04-25 06:31:05 38.83070039 -76.8496441 4403 158 0 4245 Prince George's, Maryland, US
2823 2823 25027 Worcester Massachusetts US 2020-04-25 06:30:53 42.35026951 -71.90493363 4227 133 0 4094 Worcester, Massachusetts, US
1082 1082 9003 Hartford Connecticut US 2020-04-25 06:30:53 41.80283011 -72.73103891 4570 511 0 4059 Hartford, Connecticut, US
2055 2055 25023 Plymouth Massachusetts US 2020-04-25 06:30:53 41.94070556 -70.80802823 4160 141 0 4019 Plymouth, Massachusetts, US
2861 2861     Alberta Canada 2020-04-25 06:30:55 53.9333 -116.5765 4017 72 0 3945 Alberta, Canada
2974 2974       Colombia 2020-04-25 06:30:33 4.5709 -74.2973 4881 225 1003 3653 Colombia
708 708 11001 District of Columbia District of Columbia US 2020-04-25 06:30:53 38.90417773 -77.01655992 3528 153 0 3375 District of Columbia, District of Columbia, US
1770 1770 42091 Montgomery Pennsylvania US 2020-04-25 06:30:53 40.21053671 -75.36652296 3525 208 0 3317 Montgomery, Pennsylvania, US
475 475 32003 Clark Nevada US 2020-04-25 06:30:53 36.21458855 -115.0130241 3443 168 0 3275 Clark, Nevada, US
2175 2175 6065 Riverside California US 2020-04-25 06:30:53 33.74314981 -115.9933578 3315 112 0 3203 Riverside, California, US
3053 3053       Morocco 2020-04-25 06:30:33 31.7917 -7.0926 3758 158 486 3114 Morocco
1764 1764 24031 Montgomery Maryland US 2020-04-25 06:31:05 39.13676329 -77.20358245 3227 154 0 3073 Montgomery, Maryland, US
1581 1581 4013 Maricopa Arizona US 2020-04-25 06:30:53 33.34835867 -112.4918154 3116 120 0 2996 Maricopa, Arizona, US
688 688 42045 Delaware Pennsylvania US 2020-04-25 06:30:53 39.91680171 -75.40243663 3055 129 0 2926 Delaware, Pennsylvania, US
1685 1685 34021 Mercer New Jersey US 2020-04-25 06:30:53 40.28047017 -74.70479631 3086 178 0 2908 Mercer, New Jersey, US
1038 1038 25013 Hampden Massachusetts US 2020-04-25 06:30:53 42.13440424 -72.63235561 3060 244 0 2816 Hampden, Massachusetts, US
645 645 48113 Dallas Texas US 2020-04-25 06:30:53 32.76670599 -96.7779605 2834 103 0 2757 Dallas, Texas, US
2235 2235 6073 San Diego California US 2020-04-25 06:30:53 33.03484597 -116.7365326 2826 102 0 2724 San Diego, California, US
2347 2347 34035 Somerset New Jersey US 2020-04-25 06:30:53 40.56465737 -74.61683016 2921 198 0 2723 Somerset, New Jersey, US
2989 2989       Egypt 2020-04-25 06:30:33 26.820553000000004 30.802497999999996 4092 294 1075 2723 Egypt
2948 2948       Austria 2020-04-25 06:30:33 47.5162 14.5501 15071 530 11872 2669 Austria
3092 3092       South Africa 2020-04-25 06:30:33 -30.5595 22.9375 4220 79 1473 2668 South Africa
324 324 34007 Camden New Jersey US 2020-04-25 06:30:53 39.80343818 -74.96388753 2750 106 0 2644 Camden, New Jersey, US
1379 1379 17097 Lake Illinois US 2020-04-25 06:30:53 42.3224907 -88.00367925 2717 105 0 2612 Lake, Illinois, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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