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 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
2917 2917     Qinghai China 2020-02-23 11:19:02 35.7452 95.9956 18 0 18 0 Qinghai, China
2933 2933     Tibet China 2020-02-23 11:19:02 31.6927 88.0924 1 0 1 0 Tibet, China
2936 2936     Xinjiang China 2020-03-08 05:31:02 41.1129 85.2401 76 3 73 0 Xinjiang, China
2911 2911     Ningxia China 2020-03-16 08:47:05 37.2692 106.1655 75 0 75 0 Ningxia, China
2890 2890     Hainan China 2020-03-24 04:19:14 19.1959 109.7453 168 6 162 0 Hainan, China
2888 2888     Guangxi China 2020-04-02 00:16:02 23.8298 108.7881 254 2 252 0 Guangxi, China
2900 2900     Jiangxi China 2020-04-10 01:22:42 27.614 115.7221 937 1 936 0 Jiangxi, China
2893 2893     Henan China 2020-04-14 00:43:57 33.882 113.61399999999999 1276 22 1254 0 Henan, China
2881 2881     Gansu China 2020-04-16 13:44:14 37.8099 101.0583 139 2 137 0 Gansu, China
2896 2896     Hunan China 2020-04-18 01:15:10 27.6104 111.7088 1019 4 1015 0 Hunan, China
2889 2889     Guizhou China 2020-04-19 00:51:07 26.8154 106.8748 147 2 145 0 Guizhou, China
2902 2902     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-23 00:00:00 42.60060306 -73.97723916 805 31 0 774 Albany, New York, US
38 38 36003 Allegany New York US 2020-04-23 00:00:00 42.25748406 -78.02750466 31 2 0 29 Allegany, New York, US
248 248 36007 Broome New York US 2020-04-23 00:00:00 42.15903158 -75.81326086 232 17 0 215 Broome, New York, US
386 386 36009 Cattaraugus New York US 2020-04-23 00:00:00 42.24778241 -78.67923096 39 0 0 39 Cattaraugus, New York, US
387 387 36011 Cayuga New York US 2020-04-23 00:00:00 42.91261714 -76.55731592 39 1 0 38 Cayuga, New York, US
416 416 36013 Chautauqua New York US 2020-04-23 00:00:00 42.22769210000001 -79.36691763 27 3 0 24 Chautauqua, New York, US
421 421 36015 Chemung New York US 2020-04-23 00:00:00 42.13891056 -76.7638805 79 1 0 78 Chemung, New York, US
422 422 36017 Chenango New York US 2020-04-23 00:00:00 42.49430041 -75.60887553 84 0 0 84 Chenango, New York, US
521 521 36019 Clinton New York US 2020-04-23 00:00:00 44.74530905 -73.67875352 53 4 0 49 Clinton, New York, US
551 551 36021 Columbia New York US 2020-04-23 00:00:00 42.24819348 -73.63089095 129 13 0 116 Columbia, New York, US
577 577 36023 Cortland New York US 2020-04-23 00:00:00 42.59509207 -76.07048931 25 0 0 25 Cortland, New York, US
685 685 36025 Delaware New York US 2020-04-23 00:00:00 42.19837623 -74.96709306 51 4 0 47 Delaware, New York, US
744 744 36027 Dutchess New York US 2020-04-23 00:00:00 41.76486060000001 -73.74356679 2517 35 0 2482 Dutchess, New York, US
783 783 36029 Erie New York US 2020-04-23 00:00:00 42.76249024 -78.73063652 2603 198 0 2405 Erie, New York, US
790 790 36031 Essex New York US 2020-04-23 00:00:00 44.11630765 -73.77297842 22 0 0 22 Essex, New York, US
865 865 36033 Franklin New York US 2020-04-23 00:00:00 44.59040891 -74.29926032 13 0 0 13 Franklin, New York, US
890 890 36035 Fulton New York US 2020-04-23 00:00:00 43.11363907 -74.41798804 29 0 0 29 Fulton, New York, US
917 917 36037 Genesee New York US 2020-04-23 00:00:00 43.0022601 -78.19135193 127 3 0 124 Genesee, New York, US
992 992 36039 Greene New York US 2020-04-23 00:00:00 42.275797 -74.12384884 90 5 0 85 Greene, New York, US
1033 1033 36041 Hamilton New York US 2020-04-23 00:00:00 43.66146647 -74.49721957 3 0 0 3 Hamilton, New York, US
1114 1114 36043 Herkimer New York US 2020-04-23 00:00:00 43.42034246 -74.96145307 56 3 0 53 Herkimer, New York, US
1252 1252 36045 Jefferson New York US 2020-04-23 00:00:00 44.04200959 -75.94653457 58 0 0 58 Jefferson, New York, US
1454 1454 36049 Lewis New York US 2020-04-23 00:00:00 43.7844157 -75.44903992 9 0 0 9 Lewis, New York, US
1501 1501 36051 Livingston New York US 2020-04-23 00:00:00 42.72596275 -77.77966158 44 5 0 39 Livingston, New York, US
1564 1564 36053 Madison New York US 2020-04-23 00:00:00 42.91653905 -75.67266639 106 5 0 101 Madison, New York, US
1746 1746 36055 Monroe New York US 2020-04-23 00:00:00 43.14638895 -77.69322942 1199 96 0 1103 Monroe, New York, US
1767 1767 36057 Montgomery New York US 2020-04-23 00:00:00 42.90123494 -74.44011632 39 1 0 38 Montgomery, New York, US
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
1852 1852 36063 Niagara New York US 2020-04-23 00:00:00 43.19898042 -78.74777412 332 21 0 311 Niagara, New York, US
1905 1905 36065 Oneida New York US 2020-04-23 00:00:00 43.24375382 -75.43710392 323 11 0 312 Oneida, New York, US
1907 1907 36067 Onondaga New York US 2020-04-23 00:00:00 43.00491923 -76.19971155 639 25 0 614 Onondaga, New York, US
1909 1909 36069 Ontario New York US 2020-04-23 00:00:00 42.85145728 -77.30874425 73 9 0 64 Ontario, New York, US
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
1922 1922 36073 Orleans New York US 2020-04-23 00:00:00 43.2516977 -78.2320066 60 7 0 53 Orleans, New York, US
1932 1932 36075 Oswego New York US 2020-04-23 00:00:00 43.42778894 -76.14635194 51 2 0 49 Oswego, New York, US
1937 1937 36077 Otsego New York US 2020-04-23 00:00:00 42.63492579 -75.03151402 50 4 0 46 Otsego, New York, US
2114 2114 36079 Putnam New York US 2020-04-23 00:00:00 41.42630093 -73.74965532 619 7 0 612 Putnam, New York, US
2151 2151 36083 Rensselaer New York US 2020-04-23 00:00:00 42.71348136 -73.51089874 198 11 0 187 Rensselaer, New York, 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
2259 2259 36091 Saratoga New York US 2020-04-23 00:00:00 43.10904162 -73.86653895 278 11 0 267 Saratoga, New York, US
2265 2265 36093 Schenectady New York US 2020-04-23 00:00:00 42.81668777 -74.05278291 297 15 0 282 Schenectady, New York, US
2267 2267 36095 Schoharie New York US 2020-04-23 00:00:00 42.58831742 -74.44339029999998 21 0 0 21 Schoharie, New York, US
2270 2270 36097 Schuyler New York US 2020-04-23 00:00:00 42.39184015 -76.8773299 7 0 0 7 Schuyler, New York, US
2294 2294 36099 Seneca New York US 2020-04-23 00:00:00 42.78081007 -76.82497064 18 0 0 18 Seneca, New York, US
2379 2379 36089 St. Lawrence New York US 2020-04-23 00:00:00 44.4976179 -75.06550039 144 0 0 144 St. Lawrence, New York, US
2409 2409 36101 Steuben New York US 2020-04-23 00:00:00 42.2689144 -77.3829924 171 33 0 138 Steuben, 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
2430 2430 36105 Sullivan New York US 2020-04-23 00:00:00 41.71579493 -74.76394559 628 17 0 611 Sullivan, New York, US
2494 2494 36107 Tioga New York US 2020-04-23 00:00:00 42.16852837 -76.30835812 40 5 0 35 Tioga, New York, US
2507 2507 36109 Tompkins New York US 2020-04-23 00:00:00 42.44945765 -76.47229843 121 0 0 121 Tompkins, New York, US
2541 2541 36111 Ulster New York US 2020-04-23 00:00:00 41.89027881 -74.26252104 976 23 0 953 Ulster, New York, US
2672 2672 36113 Warren New York US 2020-04-23 00:00:00 43.56173026 -73.8433699 122 0 0 122 Warren, New York, US
2701 2701 36115 Washington New York US 2020-04-23 00:00:00 43.31153794 -73.43043448 83 2 0 81 Washington, New York, US
2728 2728 36117 Wayne New York US 2020-04-23 00:00:00 43.15494365 -77.02976528 53 0 0 53 Wayne, New York, 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
2832 2832 36121 Wyoming New York US 2020-04-23 00:00:00 42.70145109 -78.22199579 43 5 0 38 Wyoming, New York, US
2841 2841 36123 Yates New York US 2020-04-23 00:00:00 42.63505484 -77.10369919 11 1 0 10 Yates, New York, US
2903 2903     Macau China 2020-04-23 10:54:47 22.1667 113.55 45 0 27 18 Macau, China
17 17 53001 Adams Washington US 2020-04-24 00:00:00 46.98299757 -118.5601734 45 0 0 45 Adams, Washington, US
87 87 53003 Asotin Washington US 2020-04-24 00:00:00 46.18894415 -117.2022851 16 1 0 15 Asotin, Washington, US
169 169 53005 Benton Washington US 2020-04-24 00:00:00 46.23946995 -119.5120834 383 39 0 347 Benton, Washington, US
420 420 53007 Chelan Washington US 2020-04-24 00:00:00 47.87046092 -120.6173956 89 5 0 84 Chelan, Washington, US
465 465 53009 Clallam Washington US 2020-04-24 00:00:00 48.04754642 -123.9226319 14 0 0 14 Clallam, Washington, US
478 478 53011 Clark Washington US 2020-04-24 00:00:00 45.77568046 -122.4829204 293 20 0 277 Clark, Washington, US
554 554 53013 Columbia Washington US 2020-04-24 00:00:00 46.29442881 -117.9051983 1 0 0 1 Columbia, Washington, US
588 588 53015 Cowlitz Washington US 2020-04-24 00:00:00 46.19074721 -122.6782231 36 0 0 36 Cowlitz, Washington, US
732 732 53017 Douglas Washington US 2020-04-24 00:00:00 47.7361335 -119.692937 69 1 0 68 Douglas, Washington, US
825 825 53019 Ferry Washington US 2020-04-24 00:00:00 48.471143100000006 -118.5154041 1 0 0 1 Ferry, Washington, US
873 873 53021 Franklin Washington US 2020-04-24 00:00:00 46.53351425 -118.9018212 239 5 0 234 Franklin, Washington, US
905 905 53023 Garfield Washington US 2020-04-24 00:00:00 46.43197502 -117.5454032 0 0 0 0 Garfield, Washington, US
967 967 53025 Grant Washington US 2020-04-24 00:00:00 47.20753737 -119.4500749 149 3 0 147 Grant, Washington, US
975 975 53027 Grays Harbor Washington US 2020-04-24 00:00:00 47.14003705 -123.7820567 12 0 0 12 Grays Harbor, Washington, US
1198 1198 53029 Island Washington US 2020-04-24 00:00:00 48.14713305 -122.5216407 160 8 0 151 Island, Washington, US
1259 1259 53031 Jefferson Washington US 2020-04-24 00:00:00 47.75003077 -123.56097040000002 28 0 0 28 Jefferson, Washington, US
1328 1328 53033 King Washington US 2020-04-24 00:00:00 47.49137892 -121.8346131 5637 418 0 5244 King, Washington, US
1338 1338 53035 Kitsap Washington US 2020-04-24 00:00:00 47.63479026 -122.6436061 143 2 0 141 Kitsap, Washington, US
1339 1339 53037 Kittitas Washington US 2020-04-24 00:00:00 47.12521214 -120.679439 14 0 0 14 Kittitas, Washington, US
1343 1343 53039 Klickitat Washington US 2020-04-24 00:00:00 45.87325839 -120.7913598 16 2 0 13 Klickitat, Washington, US
1456 1456 53041 Lewis Washington US 2020-04-24 00:00:00 46.57756476 -122.3925769 25 3 0 22 Lewis, Washington, US
1487 1487 53043 Lincoln Washington US 2020-04-24 00:00:00 47.57705241 -118.4194388 2 0 0 2 Lincoln, Washington, US
1627 1627 53045 Mason Washington US 2020-04-24 00:00:00 47.35007586 -123.1863685 22 0 0 22 Mason, Washington, US
1895 1895 53047 Okanogan Washington US 2020-04-24 00:00:00 48.54855019 -119.7387224 16 1 0 16 Okanogan, Washington, US
1959 1959 53049 Pacific Washington US 2020-04-24 00:00:00 46.55418369 -123.7285716 4 0 0 4 Pacific, Washington, US
1986 1986 53051 Pend Oreille Washington US 2020-04-24 00:00:00 48.53234021 -117.2741804 2 0 0 2 Pend Oreille, Washington, US
2025 2025 53053 Pierce Washington US 2020-04-24 00:00:00 47.03892768 -122.1405958 1212 51 0 1169 Pierce, Washington, US
2241 2241 53055 San Juan Washington US 2020-04-24 00:00:00 48.60182783 -122.96745 14 0 0 14 San Juan, Washington, US
2333 2333 53057 Skagit Washington US 2020-04-24 00:00:00 48.48171488 -121.766131 283 10 0 273 Skagit, Washington, US
2334 2334 53059 Skamania Washington US 2020-04-24 00:00:00 46.02408726 -121.9164403 3 0 0 3 Skamania, Washington, 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
);