04-27-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,154 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
2942 2942     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2959 2959     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2962 2962     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2934 2934     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2913 2913     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2911 2911     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2923 2923     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2916 2916     Henan China 2020-04-14 00:43:57 33.882 113.614 1276 22 1254 0 Henan, China
2903 2903     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
2919 2919     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2912 2912     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2925 2925     Liaoning China 2020-04-20 01:20:14 41.2956 122.6085 146 2 143 1 Liaoning, China
2894 2894     Chongqing China 2020-04-24 00:43:27 30.0572 107.874 579 6 573 0 Chongqing, China
2922 2922     Jiangsu China 2020-04-24 01:27:14 32.9711 119.455 653 0 646 7 Jiangsu, China
2955 2955     Sichuan China 2020-04-24 01:27:14 30.6171 102.7103 561 3 558 0 Sichuan, China
2885 2885     Anhui China 2020-04-24 12:04:47 31.8257 117.2264 991 6 985 0 Anhui, China
2914 2914     Hebei China 2020-04-25 00:34:20 39.549 116.1306 328 6 318 4 Hebei, China
2902 2902     Fujian China 2020-04-25 01:01:53 26.0789 117.9874 355 1 349 5 Fujian, China
2951 2951     Shaanxi China 2020-04-25 01:22:13 35.1917 108.8701 286 3 253 30 Shaanxi, China
2964 2964     Yunnan China 2020-04-25 23:55:42 24.974 101.487 185 2 181 2 Yunnan, China
26 26 36001 Albany New York US 2020-04-26 00:00:00 42.60060306 -73.97723916 979 36 0 943 Albany, New York, US
38 38 36003 Allegany New York US 2020-04-26 00:00:00 42.25748406 -78.02750466 35 2 0 33 Allegany, New York, US
249 249 36007 Broome New York US 2020-04-26 00:00:00 42.15903158 -75.81326086 261 19 0 242 Broome, New York, US
388 388 36009 Cattaraugus New York US 2020-04-26 00:00:00 42.24778241 -78.67923096 45 0 0 45 Cattaraugus, New York, US
389 389 36011 Cayuga New York US 2020-04-26 00:00:00 42.91261714 -76.55731592 48 1 0 47 Cayuga, New York, US
418 418 36013 Chautauqua New York US 2020-04-26 00:00:00 42.22769210000001 -79.36691763 30 3 0 27 Chautauqua, New York, US
423 423 36015 Chemung New York US 2020-04-26 00:00:00 42.13891056 -76.7638805 108 1 0 107 Chemung, New York, US
424 424 36017 Chenango New York US 2020-04-26 00:00:00 42.49430041 -75.60887553 95 0 0 95 Chenango, New York, US
523 523 36019 Clinton New York US 2020-04-26 00:00:00 44.74530905 -73.67875352 59 4 0 55 Clinton, New York, US
553 553 36021 Columbia New York US 2020-04-26 00:00:00 42.24819348 -73.63089095 146 13 0 133 Columbia, New York, US
579 579 36023 Cortland New York US 2020-04-26 00:00:00 42.59509207 -76.07048931 28 0 0 28 Cortland, New York, US
689 689 36025 Delaware New York US 2020-04-26 00:00:00 42.19837623 -74.96709306 58 4 0 54 Delaware, New York, US
748 748 36027 Dutchess New York US 2020-04-26 00:00:00 41.76486060000001 -73.74356679 2793 36 0 2757 Dutchess, New York, US
788 788 36029 Erie New York US 2020-04-26 00:00:00 42.76249024 -78.73063652 3021 207 0 2814 Erie, New York, US
795 795 36031 Essex New York US 2020-04-26 00:00:00 44.11630765 -73.77297842 24 0 0 24 Essex, New York, US
870 870 36033 Franklin New York US 2020-04-26 00:00:00 44.59040891 -74.29926032 14 0 0 14 Franklin, New York, US
895 895 36035 Fulton New York US 2020-04-26 00:00:00 43.11363907 -74.41798804 62 0 0 62 Fulton, New York, US
922 922 36037 Genesee New York US 2020-04-26 00:00:00 43.0022601 -78.19135193 148 3 0 145 Genesee, New York, US
998 998 36039 Greene New York US 2020-04-26 00:00:00 42.275797 -74.12384884 111 5 0 106 Greene, New York, US
1039 1039 36041 Hamilton New York US 2020-04-26 00:00:00 43.66146647 -74.49721957 3 0 0 3 Hamilton, New York, US
1121 1121 36043 Herkimer New York US 2020-04-26 00:00:00 43.42034246 -74.96145307 58 3 0 55 Herkimer, New York, US
1261 1261 36045 Jefferson New York US 2020-04-26 00:00:00 44.04200959 -75.94653457 60 0 0 60 Jefferson, New York, US
1464 1464 36049 Lewis New York US 2020-04-26 00:00:00 43.7844157 -75.44903992 9 0 0 9 Lewis, New York, US
1511 1511 36051 Livingston New York US 2020-04-26 00:00:00 42.72596275 -77.77966158 62 5 0 57 Livingston, New York, US
1574 1574 36053 Madison New York US 2020-04-26 00:00:00 42.91653905 -75.67266639 124 5 0 119 Madison, New York, US
1758 1758 36055 Monroe New York US 2020-04-26 00:00:00 43.14638895 -77.69322942 1331 108 0 1223 Monroe, New York, US
1779 1779 36057 Montgomery New York US 2020-04-26 00:00:00 42.90123494 -74.44011632 47 1 0 46 Montgomery, New York, US
1833 1833 36059 Nassau New York US 2020-04-26 00:00:00 40.74066522 -73.58941873 34865 1620 0 33245 Nassau, New York, US
1865 1865 36063 Niagara New York US 2020-04-26 00:00:00 43.19898042 -78.74777412 378 21 0 357 Niagara, New York, US
1918 1918 36065 Oneida New York US 2020-04-26 00:00:00 43.24375382 -75.43710392 397 15 0 382 Oneida, New York, US
1920 1920 36067 Onondaga New York US 2020-04-26 00:00:00 43.00491923 -76.19971155 726 26 0 700 Onondaga, New York, US
1922 1922 36069 Ontario New York US 2020-04-26 00:00:00 42.85145728 -77.30874425 86 9 0 77 Ontario, New York, US
1927 1927 36071 Orange New York US 2020-04-26 00:00:00 41.40337468 -74.30240757 8238 299 0 7939 Orange, New York, US
1935 1935 36073 Orleans New York US 2020-04-26 00:00:00 43.2516977 -78.2320066 80 9 0 71 Orleans, New York, US
1945 1945 36075 Oswego New York US 2020-04-26 00:00:00 43.42778894 -76.14635194 61 3 0 58 Oswego, New York, US
1950 1950 36077 Otsego New York US 2020-04-26 00:00:00 42.63492579 -75.03151402 62 4 0 58 Otsego, New York, US
2131 2131 36079 Putnam New York US 2020-04-26 00:00:00 41.42630093 -73.74965532 925 7 0 918 Putnam, New York, US
2169 2169 36083 Rensselaer New York US 2020-04-26 00:00:00 42.71348136 -73.51089874 246 11 0 235 Rensselaer, New York, US
2212 2212 36087 Rockland New York US 2020-04-26 00:00:00 41.15027894 -74.02560498 11366 481 0 10885 Rockland, New York, US
2278 2278 36091 Saratoga New York US 2020-04-26 00:00:00 43.10904162 -73.86653895 336 11 0 325 Saratoga, New York, US
2284 2284 36093 Schenectady New York US 2020-04-26 00:00:00 42.81668777 -74.05278291 457 22 0 435 Schenectady, New York, US
2286 2286 36095 Schoharie New York US 2020-04-26 00:00:00 42.58831742 -74.44339029999998 35 0 0 35 Schoharie, New York, US
2289 2289 36097 Schuyler New York US 2020-04-26 00:00:00 42.39184015 -76.8773299 7 0 0 7 Schuyler, New York, US
2313 2313 36099 Seneca New York US 2020-04-26 00:00:00 42.78081007 -76.82497064 38 0 0 38 Seneca, New York, US
2399 2399 36089 St. Lawrence New York US 2020-04-26 00:00:00 44.4976179 -75.06550039 169 0 0 169 St. Lawrence, New York, US
2429 2429 36101 Steuben New York US 2020-04-26 00:00:00 42.2689144 -77.3829924 209 35 0 174 Steuben, New York, US
2446 2446 36103 Suffolk New York US 2020-04-26 00:00:00 40.88320119 -72.8012172 32470 1102 0 31368 Suffolk, New York, US
2450 2450 36105 Sullivan New York US 2020-04-26 00:00:00 41.71579493 -74.76394559 748 21 0 727 Sullivan, New York, US
2514 2514 36107 Tioga New York US 2020-04-26 00:00:00 42.16852837 -76.30835812 71 6 0 65 Tioga, New York, US
2527 2527 36109 Tompkins New York US 2020-04-26 00:00:00 42.44945765 -76.47229843 126 0 0 126 Tompkins, New York, US
2561 2561 36111 Ulster New York US 2020-04-26 00:00:00 41.89027881 -74.26252104 1219 24 0 1195 Ulster, New York, US
2694 2694 36113 Warren New York US 2020-04-26 00:00:00 43.56173026 -73.8433699 147 0 0 147 Warren, New York, US
2723 2723 36115 Washington New York US 2020-04-26 00:00:00 43.31153794 -73.43043448 130 2 0 128 Washington, New York, US
2750 2750 36117 Wayne New York US 2020-04-26 00:00:00 43.15494365 -77.02976528 69 1 0 68 Wayne, New York, US
2773 2773 36119 Westchester New York US 2020-04-26 00:00:00 41.16278376 -73.75741653 28007 962 0 27045 Westchester, New York, US
2854 2854 36121 Wyoming New York US 2020-04-26 00:00:00 42.70145109 -78.22199579 63 5 0 58 Wyoming, New York, US
2863 2863 36123 Yates New York US 2020-04-26 00:00:00 42.63505484 -77.10369919 17 1 0 16 Yates, New York, US
2958 2958     Tianjin China 2020-04-26 01:08:08 39.3054 117.323 190 3 182 5 Tianjin, China
17 17 53001 Adams Washington US 2020-04-27 00:00:00 46.98299757 -118.5601734 46 0 0 46 Adams, Washington, US
88 88 53003 Asotin Washington US 2020-04-27 00:00:00 46.18894415 -117.2022851 17 2 0 16 Asotin, Washington, US
170 170 53005 Benton Washington US 2020-04-27 00:00:00 46.23946995 -119.5120834 409 42 0 371 Benton, Washington, US
422 422 53007 Chelan Washington US 2020-04-27 00:00:00 47.87046092 -120.6173956 93 5 0 88 Chelan, Washington, US
467 467 53009 Clallam Washington US 2020-04-27 00:00:00 48.04754642 -123.9226319 15 0 0 15 Clallam, Washington, US
480 480 53011 Clark Washington US 2020-04-27 00:00:00 45.77568046 -122.4829204 308 21 0 290 Clark, Washington, US
556 556 53013 Columbia Washington US 2020-04-27 00:00:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
591 591 53015 Cowlitz Washington US 2020-04-27 00:00:00 46.19074721 -122.6782231 39 0 0 39 Cowlitz, Washington, US
736 736 53017 Douglas Washington US 2020-04-27 00:00:00 47.7361335 -119.692937 75 2 0 74 Douglas, Washington, US
830 830 53019 Ferry Washington US 2020-04-27 00:00:00 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
878 878 53021 Franklin Washington US 2020-04-27 00:00:00 46.53351425 -118.9018212 256 7 0 251 Franklin, Washington, US
910 910 53023 Garfield Washington US 2020-04-27 00:00:00 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
973 973 53025 Grant Washington US 2020-04-27 00:00:00 47.20753737 -119.4500749 152 3 0 150 Grant, Washington, US
981 981 53027 Grays Harbor Washington US 2020-04-27 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1206 1206 53029 Island Washington US 2020-04-27 00:00:00 48.14713305 -122.5216407 164 8 0 155 Island, Washington, US
1268 1268 53031 Jefferson Washington US 2020-04-27 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1337 1337 53033 King Washington US 2020-04-27 00:00:00 47.49137892 -121.8346131 5945 443 0 5529 King, Washington, US
1347 1347 53035 Kitsap Washington US 2020-04-27 00:00:00 47.63479026 -122.6436061 147 2 0 145 Kitsap, Washington, US
1348 1348 53037 Kittitas Washington US 2020-04-27 00:00:00 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
1352 1352 53039 Klickitat Washington US 2020-04-27 00:00:00 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1466 1466 53041 Lewis Washington US 2020-04-27 00:00:00 46.57756476 -122.3925769 29 3 0 26 Lewis, Washington, US
1497 1497 53043 Lincoln Washington US 2020-04-27 00:00:00 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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