04-26-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,142 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
2931 2931     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2947 2947     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2950 2950     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2925 2925     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2904 2904     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2902 2902     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2914 2914     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2907 2907     Henan China 2020-04-14 00:43:57 33.882 113.61399999999999 1276 22 1254 0 Henan, China
2895 2895     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
2910 2910     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2903 2903     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2916 2916     Liaoning China 2020-04-20 01:20:14 41.2956 122.6085 146 2 143 1 Liaoning, China
2886 2886     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2913 2913     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2943 2943     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
2877 2877     Anhui China 2020-04-24 12:04:47 31.8257 117.2264 991 6 985 0 Anhui, China
26 26 36001 Albany New York US 2020-04-25 00:00:00 42.60060306 -73.97723916 948 32 0 916 Albany, New York, US
38 38 36003 Allegany New York US 2020-04-25 00:00:00 42.25748406 -78.02750466 35 2 0 33 Allegany, New York, US
249 249 36007 Broome New York US 2020-04-25 00:00:00 42.15903158 -75.81326086 257 17 0 240 Broome, New York, US
387 387 36009 Cattaraugus New York US 2020-04-25 00:00:00 42.24778241 -78.67923096 45 0 0 45 Cattaraugus, New York, US
388 388 36011 Cayuga New York US 2020-04-25 00:00:00 42.91261714 -76.55731592 47 1 0 46 Cayuga, New York, US
417 417 36013 Chautauqua New York US 2020-04-25 00:00:00 42.22769210000001 -79.36691763 29 3 0 26 Chautauqua, New York, US
422 422 36015 Chemung New York US 2020-04-25 00:00:00 42.13891056 -76.7638805 106 1 0 105 Chemung, New York, US
423 423 36017 Chenango New York US 2020-04-25 00:00:00 42.49430041 -75.60887553 93 0 0 93 Chenango, New York, US
522 522 36019 Clinton New York US 2020-04-25 00:00:00 44.74530905 -73.67875352 57 4 0 53 Clinton, New York, US
552 552 36021 Columbia New York US 2020-04-25 00:00:00 42.24819348 -73.63089095 143 13 0 130 Columbia, New York, US
578 578 36023 Cortland New York US 2020-04-25 00:00:00 42.59509207 -76.07048931 28 0 0 28 Cortland, New York, US
687 687 36025 Delaware New York US 2020-04-25 00:00:00 42.19837623 -74.96709306 58 4 0 54 Delaware, New York, US
746 746 36027 Dutchess New York US 2020-04-25 00:00:00 41.76486060000001 -73.74356679 2729 35 0 2694 Dutchess, New York, US
786 786 36029 Erie New York US 2020-04-25 00:00:00 42.76249024 -78.73063652 2954 207 0 2747 Erie, New York, US
793 793 36031 Essex New York US 2020-04-25 00:00:00 44.11630765 -73.77297842 24 0 0 24 Essex, New York, US
868 868 36033 Franklin New York US 2020-04-25 00:00:00 44.59040891 -74.29926032 14 0 0 14 Franklin, New York, US
893 893 36035 Fulton New York US 2020-04-25 00:00:00 43.11363907 -74.41798804 62 0 0 62 Fulton, New York, US
920 920 36037 Genesee New York US 2020-04-25 00:00:00 43.0022601 -78.19135193 144 3 0 141 Genesee, New York, US
996 996 36039 Greene New York US 2020-04-25 00:00:00 42.275797 -74.12384884 110 5 0 105 Greene, New York, US
1037 1037 36041 Hamilton New York US 2020-04-25 00:00:00 43.66146647 -74.49721957 3 0 0 3 Hamilton, New York, US
1119 1119 36043 Herkimer New York US 2020-04-25 00:00:00 43.42034246 -74.96145307 57 3 0 54 Herkimer, New York, US
1259 1259 36045 Jefferson New York US 2020-04-25 00:00:00 44.04200959 -75.94653457 60 0 0 60 Jefferson, New York, US
1462 1462 36049 Lewis New York US 2020-04-25 00:00:00 43.7844157 -75.44903992 9 0 0 9 Lewis, New York, US
1509 1509 36051 Livingston New York US 2020-04-25 00:00:00 42.72596275 -77.77966158 60 5 0 55 Livingston, New York, US
1572 1572 36053 Madison New York US 2020-04-25 00:00:00 42.91653905 -75.67266639 123 5 0 118 Madison, New York, US
1756 1756 36055 Monroe New York US 2020-04-25 00:00:00 43.14638895 -77.69322942 1316 106 0 1210 Monroe, New York, US
1777 1777 36057 Montgomery New York US 2020-04-25 00:00:00 42.90123494 -74.44011632 47 1 0 46 Montgomery, New York, US
1831 1831 36059 Nassau New York US 2020-04-25 00:00:00 40.74066522 -73.58941873 34522 1587 0 32935 Nassau, New York, US
1862 1862 36063 Niagara New York US 2020-04-25 00:00:00 43.19898042 -78.74777412 368 21 0 347 Niagara, New York, US
1915 1915 36065 Oneida New York US 2020-04-25 00:00:00 43.24375382 -75.43710392 384 14 0 370 Oneida, New York, US
1917 1917 36067 Onondaga New York US 2020-04-25 00:00:00 43.00491923 -76.19971155 692 25 0 667 Onondaga, New York, US
1919 1919 36069 Ontario New York US 2020-04-25 00:00:00 42.85145728 -77.30874425 84 9 0 75 Ontario, New York, US
1924 1924 36071 Orange New York US 2020-04-25 00:00:00 41.40337468 -74.30240757 8106 274 0 7832 Orange, New York, US
1932 1932 36073 Orleans New York US 2020-04-25 00:00:00 43.2516977 -78.2320066 80 7 0 73 Orleans, New York, US
1942 1942 36075 Oswego New York US 2020-04-25 00:00:00 43.42778894 -76.14635194 61 2 0 59 Oswego, New York, US
1947 1947 36077 Otsego New York US 2020-04-25 00:00:00 42.63492579 -75.03151402 60 4 0 56 Otsego, New York, US
2125 2125 36079 Putnam New York US 2020-04-25 00:00:00 41.42630093 -73.74965532 904 7 0 897 Putnam, New York, US
2163 2163 36083 Rensselaer New York US 2020-04-25 00:00:00 42.71348136 -73.51089874 242 11 0 231 Rensselaer, New York, US
2206 2206 36087 Rockland New York US 2020-04-25 00:00:00 41.15027894 -74.02560498 11256 453 0 10803 Rockland, New York, US
2272 2272 36091 Saratoga New York US 2020-04-25 00:00:00 43.10904162 -73.86653895 330 11 0 319 Saratoga, New York, US
2278 2278 36093 Schenectady New York US 2020-04-25 00:00:00 42.81668777 -74.05278291 449 15 0 434 Schenectady, New York, US
2280 2280 36095 Schoharie New York US 2020-04-25 00:00:00 42.58831742 -74.44339029999998 35 0 0 35 Schoharie, New York, US
2283 2283 36097 Schuyler New York US 2020-04-25 00:00:00 42.39184015 -76.8773299 7 0 0 7 Schuyler, New York, US
2307 2307 36099 Seneca New York US 2020-04-25 00:00:00 42.78081007 -76.82497064 38 0 0 38 Seneca, New York, US
2392 2392 36089 St. Lawrence New York US 2020-04-25 00:00:00 44.4976179 -75.06550039 167 0 0 167 St. Lawrence, New York, US
2422 2422 36101 Steuben New York US 2020-04-25 00:00:00 42.2689144 -77.3829924 207 33 0 174 Steuben, New York, US
2439 2439 36103 Suffolk New York US 2020-04-25 00:00:00 40.88320119 -72.8012172 32059 1070 0 30989 Suffolk, New York, US
2443 2443 36105 Sullivan New York US 2020-04-25 00:00:00 41.71579493 -74.76394559 724 17 0 707 Sullivan, New York, US
2507 2507 36107 Tioga New York US 2020-04-25 00:00:00 42.16852837 -76.30835812 71 5 0 66 Tioga, New York, US
2520 2520 36109 Tompkins New York US 2020-04-25 00:00:00 42.44945765 -76.47229843 126 0 0 126 Tompkins, New York, US
2554 2554 36111 Ulster New York US 2020-04-25 00:00:00 41.89027881 -74.26252104 1190 23 0 1167 Ulster, New York, US
2686 2686 36113 Warren New York US 2020-04-25 00:00:00 43.56173026 -73.8433699 135 0 0 135 Warren, New York, US
2715 2715 36115 Washington New York US 2020-04-25 00:00:00 43.31153794 -73.43043448 127 2 0 125 Washington, New York, US
2742 2742 36117 Wayne New York US 2020-04-25 00:00:00 43.15494365 -77.02976528 65 0 0 65 Wayne, New York, US
2765 2765 36119 Westchester New York US 2020-04-25 00:00:00 41.16278376 -73.75741653 27664 946 0 26718 Westchester, New York, US
2846 2846 36121 Wyoming New York US 2020-04-25 00:00:00 42.70145109 -78.22199579 59 5 0 54 Wyoming, New York, US
2855 2855 36123 Yates New York US 2020-04-25 00:00:00 42.63505484 -77.10369919 17 1 0 16 Yates, New York, US
2905 2905     Hebei China 2020-04-25 00:34:20 39.549 116.1306 328 6 318 4 Hebei, China
2894 2894     Fujian China 2020-04-25 01:01:53 26.0789 117.9874 355 1 349 5 Fujian, China
2939 2939     Shaanxi China 2020-04-25 01:22:13 35.1917 108.8701 286 3 253 30 Shaanxi, China
2952 2952     Yunnan China 2020-04-25 23:55:42 24.974 101.48700000000001 185 2 181 2 Yunnan, China
17 17 53001 Adams Washington US 2020-04-26 00:00:00 46.98299757 -118.5601734 46 0 0 46 Adams, Washington, US
88 88 53003 Asotin Washington US 2020-04-26 00:00:00 46.18894415 -117.2022851 17 2 0 16 Asotin, Washington, US
170 170 53005 Benton Washington US 2020-04-26 00:00:00 46.23946995 -119.5120834 405 42 0 368 Benton, Washington, US
421 421 53007 Chelan Washington US 2020-04-26 00:00:00 47.87046092 -120.6173956 91 5 0 86 Chelan, Washington, US
466 466 53009 Clallam Washington US 2020-04-26 00:00:00 48.04754642 -123.9226319 15 0 0 15 Clallam, Washington, US
479 479 53011 Clark Washington US 2020-04-26 00:00:00 45.77568046 -122.4829204 297 20 0 279 Clark, Washington, US
555 555 53013 Columbia Washington US 2020-04-26 00:00:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
589 589 53015 Cowlitz Washington US 2020-04-26 00:00:00 46.19074721 -122.6782231 39 0 0 39 Cowlitz, Washington, US
734 734 53017 Douglas Washington US 2020-04-26 00:00:00 47.7361335 -119.692937 72 2 0 71 Douglas, Washington, US
828 828 53019 Ferry Washington US 2020-04-26 00:00:00 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
876 876 53021 Franklin Washington US 2020-04-26 00:00:00 46.53351425 -118.9018212 251 7 0 246 Franklin, Washington, US
908 908 53023 Garfield Washington US 2020-04-26 00:00:00 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
971 971 53025 Grant Washington US 2020-04-26 00:00:00 47.20753737 -119.4500749 150 3 0 148 Grant, Washington, US
979 979 53027 Grays Harbor Washington US 2020-04-26 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1204 1204 53029 Island Washington US 2020-04-26 00:00:00 48.14713305 -122.5216407 160 8 0 151 Island, Washington, US
1266 1266 53031 Jefferson Washington US 2020-04-26 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1335 1335 53033 King Washington US 2020-04-26 00:00:00 47.49137892 -121.8346131 5863 437 0 5455 King, Washington, US
1345 1345 53035 Kitsap Washington US 2020-04-26 00:00:00 47.63479026 -122.6436061 144 2 0 142 Kitsap, Washington, US
1346 1346 53037 Kittitas Washington US 2020-04-26 00:00:00 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
1350 1350 53039 Klickitat Washington US 2020-04-26 00:00:00 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1464 1464 53041 Lewis Washington US 2020-04-26 00:00:00 46.57756476 -122.3925769 29 3 0 26 Lewis, Washington, US
1495 1495 53043 Lincoln Washington US 2020-04-26 00:00:00 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US
1636 1636 53045 Mason Washington US 2020-04-26 00:00:00 47.35007586 -123.1863685 22 1 0 21 Mason, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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