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

58 rows where "Last_Update" is on date 2020-04-23

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: Province_State, Country_Region, Last_Update, Deaths, Recovered

Last_Update (date) ✖

  • 2020-04-23 · 58 ✖
Link rowid ▼ FIPS Admin2 Province_State Country_Region Last_Update Lat Long_ Confirmed Deaths Recovered Active Combined_Key
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

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
);