daily_reports (view)

⚠️ This table has been renamed. Use johns_hopkins_csse_daily_reports instead.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

64 rows where country_or_region = "US", "last_update" is on date 2021-02-01 and province_or_state = "New York" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

These facets timed out: province_or_state

country_or_region 1

day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
2021-01-31 US New York Albany 36001 18701 291 0 18410 42.60060306 -73.97723916 2021-02-01 05:22:53 Albany, New York, US
2021-01-31 US New York Allegany 36003 2578 78 0 2500 42.25748406 -78.02750466 2021-02-01 05:22:53 Allegany, New York, US
2021-01-31 US New York Bronx 36005 119673 5425 0 114248 40.85209301 -73.86282755 2021-02-01 05:22:53 Bronx, New York, US
2021-01-31 US New York Broome 36007 12748 292 0 12456 42.15903158 -75.81326086 2021-02-01 05:22:53 Broome, New York, US
2021-01-31 US New York Cattaraugus 36009 3797 67 0 3730 42.24778241 -78.67923096 2021-02-01 05:22:53 Cattaraugus, New York, US
2021-01-31 US New York Cayuga 36011 4903 82 0 4821 42.91261714 -76.55731592 2021-02-01 05:22:53 Cayuga, New York, US
2021-01-31 US New York Chautauqua 36013 6481 97 0 6384 42.22769210000001 -79.36691763 2021-02-01 05:22:53 Chautauqua, New York, US
2021-01-31 US New York Chemung 36015 6041 116 0 5925 42.13891056 -76.7638805 2021-02-01 05:22:53 Chemung, New York, US
2021-01-31 US New York Chenango 36017 2110 55 0 2055 42.49430041 -75.60887553 2021-02-01 05:22:53 Chenango, New York, US
2021-01-31 US New York Clinton 36019 2720 20 0 2700 44.74530905 -73.67875352 2021-02-01 05:22:53 Clinton, New York, US
2021-01-31 US New York Columbia 36021 2971 83 0 2888 42.24819348 -73.63089095 2021-02-01 05:22:53 Columbia, New York, US
2021-01-31 US New York Cortland 36023 2846 57 0 2789 42.59509207 -76.07048931 2021-02-01 05:22:53 Cortland, New York, US
2021-01-31 US New York Delaware 36025 1217 29 0 1188 42.19837623 -74.96709306 2021-02-01 05:22:53 Delaware, New York, US
2021-01-31 US New York Dutchess 36027 19123 357 0 18766 41.76486060000001 -73.74356679 2021-02-01 05:22:53 Dutchess, New York, US
2021-01-31 US New York Erie 36029 57406 1461 0 55945 42.76249024 -78.73063652 2021-02-01 05:22:53 Erie, New York, US
2021-01-31 US New York Essex 36031 1111 22 0 1089 44.11630765 -73.77297842 2021-02-01 05:22:53 Essex, New York, US
2021-01-31 US New York Franklin 36033 1539 9 0 1530 44.59040891 -74.29926032 2021-02-01 05:22:53 Franklin, New York, US
2021-01-31 US New York Fulton 36035 2593 64 0 2529 43.11363907 -74.41798804 2021-02-01 05:22:53 Fulton, New York, US
2021-01-31 US New York Genesee 36037 4027 107 0 3920 43.0022601 -78.19135193 2021-02-01 05:22:53 Genesee, New York, US
2021-01-31 US New York Greene 36039 2356 67 0 2289 42.275797 -74.12384884 2021-02-01 05:22:53 Greene, New York, US
2021-01-31 US New York Hamilton 36041 214 1 0 213 43.66146647 -74.49721957 2021-02-01 05:22:53 Hamilton, New York, US
2021-01-31 US New York Herkimer 36043 4203 90 0 4113 43.42034246 -74.96145307 2021-02-01 05:22:53 Herkimer, New York, US
2021-01-31 US New York Jefferson 36045 3960 45 0 3915 44.04200959 -75.94653457 2021-02-01 05:22:53 Jefferson, New York, US
2021-01-31 US New York Kings 36047 175232 8395 0 166837 40.6361825 -73.94935552 2021-02-01 05:22:53 Kings, New York, US
2021-01-31 US New York Lewis 36049 1755 25 0 1730 43.7844157 -75.44903992 2021-02-01 05:22:53 Lewis, New York, US
2021-01-31 US New York Livingston 36051 3020 46 0 2974 42.72596275 -77.77966158 2021-02-01 05:22:53 Livingston, New York, US
2021-01-31 US New York Madison 36053 3484 79 0 3405 42.91653905 -75.67266639 2021-02-01 05:22:53 Madison, New York, US
2021-01-31 US New York Monroe 36055 47996 873 0 47123 43.14638895 -77.69322942 2021-02-01 05:22:53 Monroe, New York, US
2021-01-31 US New York Montgomery 36057 2674 83 0 2591 42.90123494 -74.44011632 2021-02-01 05:22:53 Montgomery, New York, US
2021-01-31 US New York Nassau 36059 128735 2677 0 126058 40.74066522 -73.58941873 2021-02-01 05:22:53 Nassau, New York, US
2021-01-31 US New York New York 36061 85779 3586 0 82193 40.76727260000001 -73.97152637 2021-02-01 05:22:53 New York, New York, US
2021-01-31 US New York Niagara 36063 13690 276 0 13414 43.19898042 -78.74777412 2021-02-01 05:22:53 Niagara, New York, US
2021-01-31 US New York Oneida 36065 18354 405 0 17949 43.24375382 -75.43710392 2021-02-01 05:22:53 Oneida, New York, US
2021-01-31 US New York Onondaga 36067 30054 572 0 29482 43.00491923 -76.19971155 2021-02-01 05:22:53 Onondaga, New York, US
2021-01-31 US New York Ontario 36069 5181 87 0 5094 42.85145728 -77.30874425 2021-02-01 05:22:53 Ontario, New York, US
2021-01-31 US New York Orange 36071 32239 678 0 31561 41.40337468 -74.30240757 2021-02-01 05:22:53 Orange, New York, US
2021-01-31 US New York Orleans 36073 2173 78 0 2095 43.2516977 -78.2320066 2021-02-01 05:22:53 Orleans, New York, US
2021-01-31 US New York Oswego 36075 5444 83 0 5361 43.42778894 -76.14635194 2021-02-01 05:22:53 Oswego, New York, US
2021-01-31 US New York Otsego 36077 1999 29 0 1970 42.63492579 -75.03151402 2021-02-01 05:22:53 Otsego, New York, US
2021-01-31 US New York Out of NY 80036 0 180 0 0 44.74530905 0.0 2021-02-01 05:22:53 Out of NY, New York, US
2021-01-31 US New York Putnam 36079 7338 81 0 7257 41.42630093 -73.74965532 2021-02-01 05:22:53 Putnam, New York, US
2021-01-31 US New York Queens 36081 178112 8133 0 169979 40.71088124 -73.81684712 2021-02-01 05:22:53 Queens, New York, US
2021-01-31 US New York Rensselaer 36083 7960 116 0 7844 42.71348136 -73.51089874 2021-02-01 05:22:53 Rensselaer, New York, US
2021-01-31 US New York Richmond 36085 49736 1451 0 48285 40.58582155 -74.14808598 2021-02-01 05:22:53 Richmond, New York, US
2021-01-31 US New York Rockland 36087 34589 652 0 33937 41.15027894 -74.02560498 2021-02-01 05:22:53 Rockland, New York, US
2021-01-31 US New York Saratoga 36091 10548 120 0 10428 43.10904162 -73.86653895 2021-02-01 05:22:53 Saratoga, New York, US
2021-01-31 US New York Schenectady 36093 9764 150 0 9614 42.81668777 -74.05278291 2021-02-01 05:22:53 Schenectady, New York, US
2021-01-31 US New York Schoharie 36095 1029 8 0 1021 42.58831742 -74.44339029999998 2021-02-01 05:22:53 Schoharie, New York, US
2021-01-31 US New York Schuyler 36097 800 10 0 790 42.39184015 -76.8773299 2021-02-01 05:22:53 Schuyler, New York, US
2021-01-31 US New York Seneca 36099 1396 49 0 1347 42.78081007 -76.82497064 2021-02-01 05:22:53 Seneca, New York, US
2021-01-31 US New York St. Lawrence 36089 4403 67 0 4336 44.4976179 -75.06550039 2021-02-01 05:22:53 St. Lawrence, New York, US
2021-01-31 US New York Steuben 36101 5025 136 0 4889 42.2689144 -77.3829924 2021-02-01 05:22:53 Steuben, New York, US
2021-01-31 US New York Suffolk 36103 143498 2794 0 140704 40.88320119 -72.8012172 2021-02-01 05:22:53 Suffolk, New York, US
2021-01-31 US New York Sullivan 36105 4205 55 0 4150 41.71579493 -74.76394559 2021-02-01 05:22:53 Sullivan, New York, US
2021-01-31 US New York Tioga 36107 2473 55 0 2418 42.16852837 -76.30835812 2021-02-01 05:22:53 Tioga, New York, US
2021-01-31 US New York Tompkins 36109 2987 31 0 2956 42.44945765 -76.47229843 2021-02-01 05:22:53 Tompkins, New York, US
2021-01-31 US New York Ulster 36111 8778 210 0 8568 41.89027881 -74.26252104 2021-02-01 05:22:53 Ulster, New York, US
2021-01-31 US New York Unassigned 90036 96 148 0 0 44.74530905 0.0 2021-02-01 05:22:53 Unassigned, New York, US
2021-01-31 US New York Warren 36113 2452 47 0 2405 43.56173026 -73.8433699 2021-02-01 05:22:53 Warren, New York, US
2021-01-31 US New York Washington 36115 1854 37 0 1817 43.31153794 -73.43043448 2021-02-01 05:22:53 Washington, New York, US
2021-01-31 US New York Wayne 36117 4101 58 0 4043 43.15494365 -77.02976528 2021-02-01 05:22:53 Wayne, New York, US
2021-01-31 US New York Westchester 36119 94214 1906 0 92308 41.16278376 -73.75741653 2021-02-01 05:22:53 Westchester, New York, US
2021-01-31 US New York Wyoming 36121 2479 45 0 2434 42.70145109 -78.22199579 2021-02-01 05:22:53 Wyoming, New York, US
2021-01-31 US New York Yates 36123 943 24 0 919 42.63505484 -77.10369919 2021-02-01 05:22:53 Yates, New York, US

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;