04-23-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,122 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
2910 2910     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2927 2927     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2930 2930     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2902 2902     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2881 2881     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2879 2879     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2854 2854     Anhui China 2020-04-09 01:12:20 31.8257 117.2264 991 6 984 1 Anhui, China
2891 2891     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2884 2884     Henan China 2020-04-14 00:43:57 33.882 113.614 1276 22 1254 0 Henan, China
2872 2872     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
2887 2887     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2880 2880     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2882 2882     Hebei China 2020-04-20 01:20:14 39.549 116.1306 328 6 317 5 Hebei, China
2893 2893     Liaoning China 2020-04-20 01:20:14 41.2956 122.6085 146 2 143 1 Liaoning, China
2888 2888     Inner Mongolia China 2020-04-21 01:04:31 44.0935 113.9448 194 1 108 85 Inner Mongolia, China
26 26 36001 Albany New York US 2020-04-22 00:00:00 42.60060306 -73.97723916 758 30 0 728 Albany, New York, US
38 38 36003 Allegany New York US 2020-04-22 00:00:00 42.25748406 -78.02750466 30 2 0 28 Allegany, New York, US
248 248 36007 Broome New York US 2020-04-22 00:00:00 42.15903158 -75.81326086 224 15 0 209 Broome, New York, US
386 386 36009 Cattaraugus New York US 2020-04-22 00:00:00 42.24778241 -78.67923096 37 0 0 37 Cattaraugus, New York, US
387 387 36011 Cayuga New York US 2020-04-22 00:00:00 42.91261714 -76.55731592 37 1 0 36 Cayuga, New York, US
416 416 36013 Chautauqua New York US 2020-04-22 00:00:00 42.22769210000001 -79.36691763 26 3 0 23 Chautauqua, New York, US
421 421 36015 Chemung New York US 2020-04-22 00:00:00 42.13891056 -76.7638805 76 1 0 75 Chemung, New York, US
422 422 36017 Chenango New York US 2020-04-22 00:00:00 42.49430041 -75.60887553 82 0 0 82 Chenango, New York, US
521 521 36019 Clinton New York US 2020-04-22 00:00:00 44.74530905 -73.67875352 52 4 0 48 Clinton, New York, US
550 550 36021 Columbia New York US 2020-04-22 00:00:00 42.24819348 -73.63089095 123 13 0 110 Columbia, New York, US
576 576 36023 Cortland New York US 2020-04-22 00:00:00 42.59509207 -76.07048931 25 0 0 25 Cortland, New York, US
684 684 36025 Delaware New York US 2020-04-22 00:00:00 42.19837623 -74.96709306 50 4 0 46 Delaware, New York, US
743 743 36027 Dutchess New York US 2020-04-22 00:00:00 41.76486060000001 -73.74356679 2460 35 0 2425 Dutchess, New York, US
782 782 36029 Erie New York US 2020-04-22 00:00:00 42.76249024 -78.73063652 2450 188 0 2262 Erie, New York, US
789 789 36031 Essex New York US 2020-04-22 00:00:00 44.11630765 -73.77297842 22 0 0 22 Essex, New York, US
864 864 36033 Franklin New York US 2020-04-22 00:00:00 44.59040891 -74.29926032 13 0 0 13 Franklin, New York, US
889 889 36035 Fulton New York US 2020-04-22 00:00:00 43.11363907 -74.41798804 28 0 0 28 Fulton, New York, US
916 916 36037 Genesee New York US 2020-04-22 00:00:00 43.0022601 -78.19135193 126 3 0 123 Genesee, New York, US
990 990 36039 Greene New York US 2020-04-22 00:00:00 42.275797 -74.12384884 89 0 0 89 Greene, New York, US
1031 1031 36041 Hamilton New York US 2020-04-22 00:00:00 43.66146647 -74.49721957 3 0 0 3 Hamilton, New York, US
1112 1112 36043 Herkimer New York US 2020-04-22 00:00:00 43.42034246 -74.96145307 54 3 0 51 Herkimer, New York, US
1250 1250 36045 Jefferson New York US 2020-04-22 00:00:00 44.04200959 -75.94653457 56 0 0 56 Jefferson, New York, US
1452 1452 36049 Lewis New York US 2020-04-22 00:00:00 43.7844157 -75.44903992 9 0 0 9 Lewis, New York, US
1499 1499 36051 Livingston New York US 2020-04-22 00:00:00 42.72596275 -77.77966158 41 5 0 36 Livingston, New York, US
1562 1562 36053 Madison New York US 2020-04-22 00:00:00 42.91653905 -75.67266639 106 5 0 101 Madison, New York, US
1743 1743 36055 Monroe New York US 2020-04-22 00:00:00 43.14638895 -77.69322942 1152 91 0 1061 Monroe, New York, US
1764 1764 36057 Montgomery New York US 2020-04-22 00:00:00 42.90123494 -74.44011632 39 1 0 38 Montgomery, New York, US
1818 1818 36059 Nassau New York US 2020-04-22 00:00:00 40.74066522 -73.58941873 32124 1471 0 30653 Nassau, New York, US
1849 1849 36063 Niagara New York US 2020-04-22 00:00:00 43.19898042 -78.74777412 295 18 0 277 Niagara, New York, US
1900 1900 36065 Oneida New York US 2020-04-22 00:00:00 43.24375382 -75.43710392 317 11 0 306 Oneida, New York, US
1902 1902 36067 Onondaga New York US 2020-04-22 00:00:00 43.00491923 -76.19971155 600 23 0 577 Onondaga, New York, US
1904 1904 36069 Ontario New York US 2020-04-22 00:00:00 42.85145728 -77.30874425 73 0 0 73 Ontario, New York, US
1909 1909 36071 Orange New York US 2020-04-22 00:00:00 41.40337468 -74.30240757 6816 268 0 6548 Orange, New York, US
1917 1917 36073 Orleans New York US 2020-04-22 00:00:00 43.2516977 -78.2320066 59 5 0 54 Orleans, New York, US
1927 1927 36075 Oswego New York US 2020-04-22 00:00:00 43.42778894 -76.14635194 49 2 0 47 Oswego, New York, US
1932 1932 36077 Otsego New York US 2020-04-22 00:00:00 42.63492579 -75.03151402 50 4 0 46 Otsego, New York, US
2109 2109 36079 Putnam New York US 2020-04-22 00:00:00 41.42630093 -73.74965532 615 7 0 608 Putnam, New York, US
2146 2146 36083 Rensselaer New York US 2020-04-22 00:00:00 42.71348136 -73.51089874 191 10 0 181 Rensselaer, New York, US
2189 2189 36087 Rockland New York US 2020-04-22 00:00:00 41.15027894 -74.02560498 9828 436 0 9392 Rockland, New York, US
2254 2254 36091 Saratoga New York US 2020-04-22 00:00:00 43.10904162 -73.86653895 265 7 0 258 Saratoga, New York, US
2260 2260 36093 Schenectady New York US 2020-04-22 00:00:00 42.81668777 -74.05278291 288 15 0 273 Schenectady, New York, US
2262 2262 36095 Schoharie New York US 2020-04-22 00:00:00 42.58831742 -74.44339029999998 21 0 0 21 Schoharie, New York, US
2265 2265 36097 Schuyler New York US 2020-04-22 00:00:00 42.39184015 -76.8773299 7 0 0 7 Schuyler, New York, US
2289 2289 36099 Seneca New York US 2020-04-22 00:00:00 42.78081007 -76.82497064 18 0 0 18 Seneca, New York, US
2374 2374 36089 St. Lawrence New York US 2020-04-22 00:00:00 44.4976179 -75.06550039 139 0 0 139 St. Lawrence, New York, US
2403 2403 36101 Steuben New York US 2020-04-22 00:00:00 42.2689144 -77.3829924 171 33 0 138 Steuben, New York, US
2420 2420 36103 Suffolk New York US 2020-04-22 00:00:00 40.88320119 -72.8012172 29567 959 0 28608 Suffolk, New York, US
2424 2424 36105 Sullivan New York US 2020-04-22 00:00:00 41.71579493 -74.76394559 580 17 0 563 Sullivan, New York, US
2488 2488 36107 Tioga New York US 2020-04-22 00:00:00 42.16852837 -76.30835812 40 4 0 36 Tioga, New York, US
2501 2501 36109 Tompkins New York US 2020-04-22 00:00:00 42.44945765 -76.47229843 119 0 0 119 Tompkins, New York, US
2535 2535 36111 Ulster New York US 2020-04-22 00:00:00 41.89027881 -74.26252104 942 21 0 921 Ulster, New York, US
2665 2665 36113 Warren New York US 2020-04-22 00:00:00 43.56173026 -73.8433699 119 0 0 119 Warren, New York, US
2694 2694 36115 Washington New York US 2020-04-22 00:00:00 43.31153794 -73.43043448 80 2 0 78 Washington, New York, US
2720 2720 36117 Wayne New York US 2020-04-22 00:00:00 43.15494365 -77.02976528 53 0 0 53 Wayne, New York, US
2743 2743 36119 Westchester New York US 2020-04-22 00:00:00 41.16278376 -73.75741653 25959 863 0 25096 Westchester, New York, US
2823 2823 36121 Wyoming New York US 2020-04-22 00:00:00 42.70145109 -78.22199579 41 4 0 37 Wyoming, New York, US
2832 2832 36123 Yates New York US 2020-04-22 00:00:00 42.63505484 -77.10369919 11 1 0 10 Yates, New York, US
2920 2920     Shandong China 2020-04-22 00:33:30 36.3427 118.1498 787 7 766 14 Shandong, China
2919 2919     Shaanxi China 2020-04-22 02:37:29 35.1917 108.8701 279 3 253 23 Shaanxi, China
17 17 53001 Adams Washington US 2020-04-23 00:00:00 46.98299757 -118.5601734 45 0 0 45 Adams, Washington, US
87 87 53003 Asotin Washington US 2020-04-23 00:00:00 46.18894415 -117.2022851 16 1 0 15 Asotin, Washington, US
169 169 53005 Benton Washington US 2020-04-23 00:00:00 46.23946995 -119.5120834 365 38 0 329 Benton, Washington, US
420 420 53007 Chelan Washington US 2020-04-23 00:00:00 47.87046092 -120.6173956 88 5 0 83 Chelan, Washington, US
465 465 53009 Clallam Washington US 2020-04-23 00:00:00 48.04754642 -123.9226319 14 0 0 14 Clallam, Washington, US
478 478 53011 Clark Washington US 2020-04-23 00:00:00 45.77568046 -122.4829204 291 19 0 276 Clark, Washington, US
553 553 53013 Columbia Washington US 2020-04-23 00:00:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
587 587 53015 Cowlitz Washington US 2020-04-23 00:00:00 46.19074721 -122.6782231 35 0 0 35 Cowlitz, Washington, US
731 731 53017 Douglas Washington US 2020-04-23 00:00:00 47.7361335 -119.692937 63 1 0 62 Douglas, Washington, US
824 824 53019 Ferry Washington US 2020-04-23 00:00:00 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
872 872 53021 Franklin Washington US 2020-04-23 00:00:00 46.53351425 -118.9018212 233 5 0 228 Franklin, Washington, US
904 904 53023 Garfield Washington US 2020-04-23 00:00:00 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
965 965 53025 Grant Washington US 2020-04-23 00:00:00 47.20753737 -119.4500749 146 2 0 144 Grant, Washington, US
973 973 53027 Grays Harbor Washington US 2020-04-23 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1196 1196 53029 Island Washington US 2020-04-23 00:00:00 48.14713305 -122.5216407 160 8 0 151 Island, Washington, US
1257 1257 53031 Jefferson Washington US 2020-04-23 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1326 1326 53033 King Washington US 2020-04-23 00:00:00 47.49137892 -121.8346131 5532 410 0 5147 King, Washington, US
1336 1336 53035 Kitsap Washington US 2020-04-23 00:00:00 47.63479026 -122.6436061 144 2 0 142 Kitsap, Washington, US
1337 1337 53037 Kittitas Washington US 2020-04-23 00:00:00 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
1341 1341 53039 Klickitat Washington US 2020-04-23 00:00:00 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1454 1454 53041 Lewis Washington US 2020-04-23 00:00:00 46.57756476 -122.3925769 22 3 0 19 Lewis, Washington, US
1485 1485 53043 Lincoln Washington US 2020-04-23 00:00:00 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US
1625 1625 53045 Mason Washington US 2020-04-23 00:00:00 47.35007586 -123.1863685 22 0 0 22 Mason, Washington, US
1890 1890 53047 Okanogan Washington US 2020-04-23 00:00:00 48.54855019 -119.7387224 16 1 0 16 Okanogan, Washington, US
1954 1954 53049 Pacific Washington US 2020-04-23 00:00:00 46.55418369 -123.7285716 4 0 0 4 Pacific, Washington, US
1981 1981 53051 Pend Oreille Washington US 2020-04-23 00:00:00 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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