04-25-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,134 rows sorted by Last_Update

✎ 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
2923 2923     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2939 2939     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2942 2942     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2917 2917     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2896 2896     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2894 2894     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2906 2906     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2899 2899     Henan China 2020-04-14 00:43:57 33.882 113.614 1276 22 1254 0 Henan, China
2887 2887     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
2902 2902     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2895 2895     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2908 2908     Liaoning China 2020-04-20 01:20:14 41.2956 122.6085 146 2 143 1 Liaoning, China
26 26 36001 Albany New York US 2020-04-24 00:00:00 42.60060306 -73.97723916 899 31 0 868 Albany, New York, US
38 38 36003 Allegany New York US 2020-04-24 00:00:00 42.25748406 -78.02750466 35 2 0 33 Allegany, New York, US
248 248 36007 Broome New York US 2020-04-24 00:00:00 42.15903158 -75.81326086 251 17 0 234 Broome, New York, US
386 386 36009 Cattaraugus New York US 2020-04-24 00:00:00 42.24778241 -78.67923096 45 0 0 45 Cattaraugus, New York, US
387 387 36011 Cayuga New York US 2020-04-24 00:00:00 42.91261714 -76.55731592 47 1 0 46 Cayuga, New York, US
416 416 36013 Chautauqua New York US 2020-04-24 00:00:00 42.22769210000001 -79.36691763 27 3 0 24 Chautauqua, New York, US
421 421 36015 Chemung New York US 2020-04-24 00:00:00 42.13891056 -76.7638805 103 1 0 102 Chemung, New York, US
422 422 36017 Chenango New York US 2020-04-24 00:00:00 42.49430041 -75.60887553 91 0 0 91 Chenango, New York, US
521 521 36019 Clinton New York US 2020-04-24 00:00:00 44.74530905 -73.67875352 54 4 0 50 Clinton, New York, US
551 551 36021 Columbia New York US 2020-04-24 00:00:00 42.24819348 -73.63089095 140 13 0 127 Columbia, New York, US
577 577 36023 Cortland New York US 2020-04-24 00:00:00 42.59509207 -76.07048931 28 0 0 28 Cortland, New York, US
685 685 36025 Delaware New York US 2020-04-24 00:00:00 42.19837623 -74.96709306 58 4 0 54 Delaware, New York, US
744 744 36027 Dutchess New York US 2020-04-24 00:00:00 41.76486060000001 -73.74356679 2660 35 0 2625 Dutchess, New York, US
783 783 36029 Erie New York US 2020-04-24 00:00:00 42.76249024 -78.73063652 2773 198 0 2575 Erie, New York, US
790 790 36031 Essex New York US 2020-04-24 00:00:00 44.11630765 -73.77297842 24 0 0 24 Essex, New York, US
865 865 36033 Franklin New York US 2020-04-24 00:00:00 44.59040891 -74.29926032 14 0 0 14 Franklin, New York, US
890 890 36035 Fulton New York US 2020-04-24 00:00:00 43.11363907 -74.41798804 61 0 0 61 Fulton, New York, US
917 917 36037 Genesee New York US 2020-04-24 00:00:00 43.0022601 -78.19135193 141 3 0 138 Genesee, New York, US
992 992 36039 Greene New York US 2020-04-24 00:00:00 42.275797 -74.12384884 107 5 0 102 Greene, New York, US
1033 1033 36041 Hamilton New York US 2020-04-24 00:00:00 43.66146647 -74.49721957 3 0 0 3 Hamilton, New York, US
1114 1114 36043 Herkimer New York US 2020-04-24 00:00:00 43.42034246 -74.96145307 56 3 0 53 Herkimer, New York, US
1253 1253 36045 Jefferson New York US 2020-04-24 00:00:00 44.04200959 -75.94653457 59 0 0 59 Jefferson, New York, US
1456 1456 36049 Lewis New York US 2020-04-24 00:00:00 43.7844157 -75.44903992 9 0 0 9 Lewis, New York, US
1503 1503 36051 Livingston New York US 2020-04-24 00:00:00 42.72596275 -77.77966158 58 5 0 53 Livingston, New York, US
1566 1566 36053 Madison New York US 2020-04-24 00:00:00 42.91653905 -75.67266639 121 5 0 116 Madison, New York, US
1750 1750 36055 Monroe New York US 2020-04-24 00:00:00 43.14638895 -77.69322942 1285 96 0 1189 Monroe, New York, US
1771 1771 36057 Montgomery New York US 2020-04-24 00:00:00 42.90123494 -74.44011632 46 1 0 45 Montgomery, New York, US
1825 1825 36059 Nassau New York US 2020-04-24 00:00:00 40.74066522 -73.58941873 33798 1558 0 32240 Nassau, New York, US
1856 1856 36063 Niagara New York US 2020-04-24 00:00:00 43.19898042 -78.74777412 344 21 0 323 Niagara, New York, US
1909 1909 36065 Oneida New York US 2020-04-24 00:00:00 43.24375382 -75.43710392 364 11 0 353 Oneida, New York, US
1911 1911 36067 Onondaga New York US 2020-04-24 00:00:00 43.00491923 -76.19971155 664 25 0 639 Onondaga, New York, US
1913 1913 36069 Ontario New York US 2020-04-24 00:00:00 42.85145728 -77.30874425 82 9 0 73 Ontario, New York, US
1918 1918 36071 Orange New York US 2020-04-24 00:00:00 41.40337468 -74.30240757 7973 274 0 7699 Orange, New York, US
1926 1926 36073 Orleans New York US 2020-04-24 00:00:00 43.2516977 -78.2320066 75 7 0 68 Orleans, New York, US
1936 1936 36075 Oswego New York US 2020-04-24 00:00:00 43.42778894 -76.14635194 57 2 0 55 Oswego, New York, US
1941 1941 36077 Otsego New York US 2020-04-24 00:00:00 42.63492579 -75.03151402 60 4 0 56 Otsego, New York, US
2119 2119 36079 Putnam New York US 2020-04-24 00:00:00 41.42630093 -73.74965532 885 7 0 878 Putnam, New York, US
2156 2156 36083 Rensselaer New York US 2020-04-24 00:00:00 42.71348136 -73.51089874 221 11 0 210 Rensselaer, New York, US
2199 2199 36087 Rockland New York US 2020-04-24 00:00:00 41.15027894 -74.02560498 11091 453 0 10638 Rockland, New York, US
2264 2264 36091 Saratoga New York US 2020-04-24 00:00:00 43.10904162 -73.86653895 320 11 0 309 Saratoga, New York, US
2270 2270 36093 Schenectady New York US 2020-04-24 00:00:00 42.81668777 -74.05278291 431 15 0 416 Schenectady, New York, US
2272 2272 36095 Schoharie New York US 2020-04-24 00:00:00 42.58831742 -74.44339029999998 33 0 0 33 Schoharie, New York, US
2275 2275 36097 Schuyler New York US 2020-04-24 00:00:00 42.39184015 -76.8773299 7 0 0 7 Schuyler, New York, US
2299 2299 36099 Seneca New York US 2020-04-24 00:00:00 42.78081007 -76.82497064 36 0 0 36 Seneca, New York, US
2384 2384 36089 St. Lawrence New York US 2020-04-24 00:00:00 44.4976179 -75.06550039 156 0 0 156 St. Lawrence, New York, US
2414 2414 36101 Steuben New York US 2020-04-24 00:00:00 42.2689144 -77.3829924 204 33 0 171 Steuben, New York, US
2431 2431 36103 Suffolk New York US 2020-04-24 00:00:00 40.88320119 -72.8012172 31368 1042 0 30326 Suffolk, New York, US
2435 2435 36105 Sullivan New York US 2020-04-24 00:00:00 41.71579493 -74.76394559 689 17 0 672 Sullivan, New York, US
2499 2499 36107 Tioga New York US 2020-04-24 00:00:00 42.16852837 -76.30835812 71 5 0 66 Tioga, New York, US
2512 2512 36109 Tompkins New York US 2020-04-24 00:00:00 42.44945765 -76.47229843 126 0 0 126 Tompkins, New York, US
2546 2546 36111 Ulster New York US 2020-04-24 00:00:00 41.89027881 -74.26252104 1166 23 0 1143 Ulster, New York, US
2678 2678 36113 Warren New York US 2020-04-24 00:00:00 43.56173026 -73.8433699 132 0 0 132 Warren, New York, US
2707 2707 36115 Washington New York US 2020-04-24 00:00:00 43.31153794 -73.43043448 113 2 0 111 Washington, New York, US
2734 2734 36117 Wayne New York US 2020-04-24 00:00:00 43.15494365 -77.02976528 65 0 0 65 Wayne, New York, US
2757 2757 36119 Westchester New York US 2020-04-24 00:00:00 41.16278376 -73.75741653 27231 920 0 26311 Westchester, New York, US
2838 2838 36121 Wyoming New York US 2020-04-24 00:00:00 42.70145109 -78.22199579 57 5 0 52 Wyoming, New York, US
2847 2847 36123 Yates New York US 2020-04-24 00:00:00 42.63505484 -77.10369919 16 1 0 15 Yates, New York, US
2878 2878     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2905 2905     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2935 2935     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
2869 2869     Anhui China 2020-04-24 12:04:47 31.8257 117.2264 991 6 985 0 Anhui, China
17 17 53001 Adams Washington US 2020-04-25 00:00:00 46.98299757 -118.5601734 46 0 0 46 Adams, Washington, US
87 87 53003 Asotin Washington US 2020-04-25 00:00:00 46.18894415 -117.2022851 17 2 0 16 Asotin, Washington, US
169 169 53005 Benton Washington US 2020-04-25 00:00:00 46.23946995 -119.5120834 399 40 0 362 Benton, Washington, US
420 420 53007 Chelan Washington US 2020-04-25 00:00:00 47.87046092 -120.6173956 90 5 0 85 Chelan, Washington, US
465 465 53009 Clallam Washington US 2020-04-25 00:00:00 48.04754642 -123.9226319 15 0 0 15 Clallam, Washington, US
478 478 53011 Clark Washington US 2020-04-25 00:00:00 45.77568046 -122.4829204 296 20 0 278 Clark, Washington, US
554 554 53013 Columbia Washington US 2020-04-25 00:00:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
588 588 53015 Cowlitz Washington US 2020-04-25 00:00:00 46.19074721 -122.6782231 39 0 0 39 Cowlitz, Washington, US
732 732 53017 Douglas Washington US 2020-04-25 00:00:00 47.7361335 -119.692937 70 1 0 69 Douglas, Washington, US
825 825 53019 Ferry Washington US 2020-04-25 00:00:00 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
873 873 53021 Franklin Washington US 2020-04-25 00:00:00 46.53351425 -118.9018212 250 6 0 245 Franklin, Washington, US
905 905 53023 Garfield Washington US 2020-04-25 00:00:00 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
967 967 53025 Grant Washington US 2020-04-25 00:00:00 47.20753737 -119.4500749 150 3 0 148 Grant, Washington, US
975 975 53027 Grays Harbor Washington US 2020-04-25 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1199 1199 53029 Island Washington US 2020-04-25 00:00:00 48.14713305 -122.5216407 161 8 0 152 Island, Washington, US
1260 1260 53031 Jefferson Washington US 2020-04-25 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1329 1329 53033 King Washington US 2020-04-25 00:00:00 47.49137892 -121.8346131 5739 428 0 5339 King, Washington, US
1339 1339 53035 Kitsap Washington US 2020-04-25 00:00:00 47.63479026 -122.6436061 144 2 0 142 Kitsap, Washington, US
1340 1340 53037 Kittitas Washington US 2020-04-25 00:00:00 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
1344 1344 53039 Klickitat Washington US 2020-04-25 00:00:00 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1458 1458 53041 Lewis Washington US 2020-04-25 00:00:00 46.57756476 -122.3925769 29 3 0 26 Lewis, Washington, US
1489 1489 53043 Lincoln Washington US 2020-04-25 00:00:00 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US
1630 1630 53045 Mason Washington US 2020-04-25 00:00:00 47.35007586 -123.1863685 22 1 0 22 Mason, Washington, US
1899 1899 53047 Okanogan Washington US 2020-04-25 00:00:00 48.54855019 -119.7387224 17 1 0 16 Okanogan, Washington, US
1963 1963 53049 Pacific Washington US 2020-04-25 00:00:00 46.55418369 -123.7285716 4 0 0 4 Pacific, Washington, US
1991 1991 53051 Pend Oreille Washington US 2020-04-25 00:00:00 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US
2030 2030 53053 Pierce Washington US 2020-04-25 00:00:00 47.03892768 -122.1405958 1235 51 0 1189 Pierce, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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