daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64,046 rows where province_or_state = "New York" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-04-29 | US | New York | Fulton | 36035 | 67 | 0 | 0 | 67 | 43.11363907 | -74.41798804 | 2020-04-30 02:32:27 | Fulton, New York, US |
2020-04-29 | US | New York | Hamilton | 36041 | 3 | 0 | 0 | 3 | 43.66146647 | -74.49721957 | 2020-04-30 02:32:27 | Hamilton, New York, US |
2020-04-29 | US | New York | Jefferson | 36045 | 60 | 0 | 0 | 60 | 44.04200959 | -75.94653457 | 2020-04-30 02:32:27 | Jefferson, New York, US |
2020-04-29 | US | New York | Lewis | 36049 | 9 | 0 | 0 | 9 | 43.784415700000004 | -75.44903992 | 2020-04-30 02:32:27 | Lewis, New York, US |
2020-04-29 | US | New York | Schoharie | 36095 | 39 | 0 | 0 | 39 | 42.58831742 | -74.44339029999998 | 2020-04-30 02:32:27 | Schoharie, New York, US |
2020-04-29 | US | New York | Schuyler | 36097 | 7 | 0 | 0 | 7 | 42.39184015 | -76.8773299 | 2020-04-30 02:32:27 | Schuyler, New York, US |
2020-04-29 | US | New York | Seneca | 36099 | 38 | 0 | 0 | 38 | 42.78081007 | -76.82497064 | 2020-04-30 02:32:27 | Seneca, New York, US |
2020-04-29 | US | New York | St. Lawrence | 36089 | 170 | 0 | 0 | 170 | 44.4976179 | -75.06550039 | 2020-04-30 02:32:27 | St. Lawrence, New York, US |
2020-04-29 | US | New York | Tompkins | 36109 | 127 | 0 | 0 | 127 | 42.44945765 | -76.47229843 | 2020-04-30 02:32:27 | Tompkins, New York, US |
2020-04-29 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-04-30 02:32:27 | Unassigned, New York, US |
2020-04-29 | US | New York | Warren | 36113 | 152 | 0 | 0 | 152 | 43.56173026 | -73.8433699 | 2020-04-30 02:32:27 | Warren, New York, US |
2020-08-15 | US | New York | Cortland | 36023 | 97 | 0 | 0 | 97 | 42.59509207 | -76.07048931 | 2020-08-16 04:27:42 | Cortland, New York, US |
2020-08-15 | US | New York | Essex | 36031 | 59 | 0 | 0 | 59 | 44.11630765 | -73.77297842 | 2020-08-16 04:27:42 | Essex, New York, US |
2020-08-15 | US | New York | Franklin | 36033 | 54 | 0 | 0 | 54 | 44.59040891 | -74.29926032 | 2020-08-16 04:27:42 | Franklin, New York, US |
2020-08-15 | US | New York | Hamilton | 36041 | 8 | 0 | 0 | 8 | 43.66146647 | -74.49721957 | 2020-08-16 04:27:42 | Hamilton, New York, US |
2020-08-15 | US | New York | Jefferson | 36045 | 143 | 0 | 0 | 143 | 44.04200959 | -75.94653457 | 2020-08-16 04:27:42 | Jefferson, New York, US |
2020-08-15 | US | New York | Lewis | 36049 | 47 | 0 | 0 | 47 | 43.7844157 | -75.44903992 | 2020-08-16 04:27:42 | Lewis, New York, US |
2020-08-15 | US | New York | Schoharie | 36095 | 69 | 0 | 0 | 69 | 42.58831742 | -74.44339029999998 | 2020-08-16 04:27:42 | Schoharie, New York, US |
2020-08-15 | US | New York | Schuyler | 36097 | 23 | 0 | 0 | 23 | 42.39184015 | -76.8773299 | 2020-08-16 04:27:42 | Schuyler, New York, US |
2020-08-15 | US | New York | Tompkins | 36109 | 238 | 0 | 0 | 238 | 42.44945765 | -76.47229843 | 2020-08-16 04:27:42 | Tompkins, New York, US |
2020-08-15 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-08-16 04:27:42 | Unassigned, New York, US |
2020-07-27 | US | New York | Cortland | 36023 | 87 | 0 | 0 | 87 | 42.59509207 | -76.07048931 | 2020-07-28 04:58:43 | Cortland, New York, US |
2020-07-27 | US | New York | Essex | 36031 | 55 | 0 | 0 | 55 | 44.11630765 | -73.77297842 | 2020-07-28 04:58:43 | Essex, New York, US |
2020-07-27 | US | New York | Franklin | 36033 | 44 | 0 | 0 | 44 | 44.59040891 | -74.29926032 | 2020-07-28 04:58:43 | Franklin, New York, US |
2020-07-27 | US | New York | Hamilton | 36041 | 7 | 0 | 0 | 7 | 43.66146647 | -74.49721957 | 2020-07-28 04:58:43 | Hamilton, New York, US |
2020-07-27 | US | New York | Jefferson | 36045 | 128 | 0 | 0 | 128 | 44.04200959 | -75.94653457 | 2020-07-28 04:58:43 | Jefferson, New York, US |
2020-07-27 | US | New York | Lewis | 36049 | 34 | 0 | 0 | 34 | 43.7844157 | -75.44903992 | 2020-07-28 04:58:43 | Lewis, New York, US |
2020-07-27 | US | New York | Schoharie | 36095 | 68 | 0 | 0 | 68 | 42.58831742 | -74.44339029999998 | 2020-07-28 04:58:43 | Schoharie, New York, US |
2020-07-27 | US | New York | Schuyler | 36097 | 20 | 0 | 0 | 20 | 42.39184015 | -76.8773299 | 2020-07-28 04:58:43 | Schuyler, New York, US |
2020-07-27 | US | New York | Tompkins | 36109 | 225 | 0 | 0 | 225 | 42.44945765 | -76.47229843 | 2020-07-28 04:58:43 | Tompkins, New York, US |
2020-07-27 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-07-28 04:58:43 | Unassigned, New York, US |
2020-08-31 | US | New York | Cortland | 36023 | 100 | 0 | 0 | 100 | 42.59509207 | -76.07048931 | 2020-09-01 04:28:31 | Cortland, New York, US |
2020-08-31 | US | New York | Essex | 36031 | 129 | 0 | 0 | 129 | 44.11630765 | -73.77297842 | 2020-09-01 04:28:31 | Essex, New York, US |
2020-08-31 | US | New York | Franklin | 36033 | 58 | 0 | 0 | 58 | 44.59040891 | -74.29926032 | 2020-09-01 04:28:31 | Franklin, New York, US |
2020-08-31 | US | New York | Hamilton | 36041 | 14 | 0 | 0 | 14 | 43.66146647 | -74.49721957 | 2020-09-01 04:28:31 | Hamilton, New York, US |
2020-08-31 | US | New York | Jefferson | 36045 | 150 | 0 | 0 | 150 | 44.04200959 | -75.94653457 | 2020-09-01 04:28:31 | Jefferson, New York, US |
2020-08-31 | US | New York | Lewis | 36049 | 49 | 0 | 0 | 49 | 43.7844157 | -75.44903992 | 2020-09-01 04:28:31 | Lewis, New York, US |
2020-08-31 | US | New York | Schoharie | 36095 | 69 | 0 | 0 | 69 | 42.58831742 | -74.44339029999998 | 2020-09-01 04:28:31 | Schoharie, New York, US |
2020-08-31 | US | New York | Schuyler | 36097 | 26 | 0 | 0 | 26 | 42.39184015 | -76.8773299 | 2020-09-01 04:28:31 | Schuyler, New York, US |
2020-08-31 | US | New York | Tompkins | 36109 | 265 | 0 | 0 | 265 | 42.44945765 | -76.47229843 | 2020-09-01 04:28:31 | Tompkins, New York, US |
2020-08-19 | US | New York | Cortland | 36023 | 97 | 0 | 0 | 97 | 42.59509207 | -76.07048931 | 2020-08-20 04:27:43 | Cortland, New York, US |
2020-08-19 | US | New York | Essex | 36031 | 63 | 0 | 0 | 63 | 44.11630765 | -73.77297842 | 2020-08-20 04:27:43 | Essex, New York, US |
2020-08-19 | US | New York | Franklin | 36033 | 56 | 0 | 0 | 56 | 44.59040891 | -74.29926032 | 2020-08-20 04:27:43 | Franklin, New York, US |
2020-08-19 | US | New York | Hamilton | 36041 | 11 | 0 | 0 | 11 | 43.66146647 | -74.49721957 | 2020-08-20 04:27:43 | Hamilton, New York, US |
2020-08-19 | US | New York | Jefferson | 36045 | 143 | 0 | 0 | 143 | 44.04200959 | -75.94653457 | 2020-08-20 04:27:43 | Jefferson, New York, US |
2020-08-19 | US | New York | Lewis | 36049 | 47 | 0 | 0 | 47 | 43.7844157 | -75.44903992 | 2020-08-20 04:27:43 | Lewis, New York, US |
2020-08-19 | US | New York | Schoharie | 36095 | 69 | 0 | 0 | 69 | 42.58831742 | -74.44339029999998 | 2020-08-20 04:27:43 | Schoharie, New York, US |
2020-08-19 | US | New York | Schuyler | 36097 | 23 | 0 | 0 | 23 | 42.39184015 | -76.8773299 | 2020-08-20 04:27:43 | Schuyler, New York, US |
2020-08-19 | US | New York | Tompkins | 36109 | 238 | 0 | 0 | 238 | 42.44945765 | -76.47229843 | 2020-08-20 04:27:43 | Tompkins, New York, US |
2020-08-19 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-08-20 04:27:43 | Unassigned, New York, US |
2020-10-29 | US | New York | Tompkins | 36109 | 632 | 0 | 0 | 632 | 42.44945765 | -76.47229843 | 2020-10-30 04:24:49 | Tompkins, New York, US |
2020-06-08 | US | New York | Allegany | 36003 | 51 | 0 | 0 | 51 | 42.25748406 | -78.02750466 | 2020-06-09 03:33:03 | Allegany, New York, US |
2020-06-08 | US | New York | Cortland | 36023 | 42 | 0 | 0 | 42 | 42.59509207 | -76.07048931 | 2020-06-09 03:33:03 | Cortland, New York, US |
2020-06-08 | US | New York | Essex | 36031 | 39 | 0 | 0 | 39 | 44.11630765 | -73.77297842 | 2020-06-09 03:33:03 | Essex, New York, US |
2020-06-08 | US | New York | Franklin | 36033 | 23 | 0 | 0 | 23 | 44.59040891 | -74.29926032 | 2020-06-09 03:33:03 | Franklin, New York, US |
2020-06-08 | US | New York | Hamilton | 36041 | 5 | 0 | 0 | 5 | 43.66146647 | -74.49721957 | 2020-06-09 03:33:03 | Hamilton, New York, US |
2020-06-08 | US | New York | Jefferson | 36045 | 78 | 0 | 0 | 78 | 44.04200959 | -75.94653457 | 2020-06-09 03:33:03 | Jefferson, New York, US |
2020-06-08 | US | New York | Lewis | 36049 | 20 | 0 | 0 | 20 | 43.7844157 | -75.44903992 | 2020-06-09 03:33:03 | Lewis, New York, US |
2020-06-08 | US | New York | Schoharie | 36095 | 54 | 0 | 0 | 54 | 42.58831742 | -74.44339029999998 | 2020-06-09 03:33:03 | Schoharie, New York, US |
2020-06-08 | US | New York | Schuyler | 36097 | 12 | 0 | 0 | 12 | 42.39184015 | -76.8773299 | 2020-06-09 03:33:03 | Schuyler, New York, US |
2020-06-08 | US | New York | Seneca | 36099 | 61 | 0 | 0 | 61 | 42.78081007 | -76.82497064 | 2020-06-09 03:33:03 | Seneca, New York, US |
2020-06-08 | US | New York | Tompkins | 36109 | 171 | 0 | 0 | 171 | 42.44945765 | -76.47229843 | 2020-06-09 03:33:03 | Tompkins, New York, US |
2020-06-08 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-06-09 03:33:03 | Unassigned, New York, US |
2020-04-30 | US | New York | Cattaraugus | 36009 | 47 | 0 | 0 | 47 | 42.24778241 | -78.67923096 | 2020-05-01 02:32:28 | Cattaraugus, New York, US |
2020-04-30 | US | New York | Chenango | 36017 | 98 | 0 | 0 | 98 | 42.49430041 | -75.60887553 | 2020-05-01 02:32:28 | Chenango, New York, US |
2020-04-30 | US | New York | Cortland | 36023 | 28 | 0 | 0 | 28 | 42.59509207 | -76.07048931 | 2020-05-01 02:32:28 | Cortland, New York, US |
2020-04-30 | US | New York | Essex | 36031 | 28 | 0 | 0 | 28 | 44.11630765 | -73.77297842 | 2020-05-01 02:32:28 | Essex, New York, US |
2020-04-30 | US | New York | Franklin | 36033 | 15 | 0 | 0 | 15 | 44.59040891 | -74.29926032 | 2020-05-01 02:32:28 | Franklin, New York, US |
2020-04-30 | US | New York | Fulton | 36035 | 71 | 0 | 0 | 71 | 43.11363907 | -74.41798804 | 2020-05-01 02:32:28 | Fulton, New York, US |
2020-04-30 | US | New York | Hamilton | 36041 | 3 | 0 | 0 | 3 | 43.66146647 | -74.49721957 | 2020-05-01 02:32:28 | Hamilton, New York, US |
2020-04-30 | US | New York | Jefferson | 36045 | 61 | 0 | 0 | 61 | 44.04200959 | -75.94653457 | 2020-05-01 02:32:28 | Jefferson, New York, US |
2020-04-30 | US | New York | Lewis | 36049 | 9 | 0 | 0 | 9 | 43.784415700000004 | -75.44903992 | 2020-05-01 02:32:28 | Lewis, New York, US |
2020-04-30 | US | New York | Schoharie | 36095 | 42 | 0 | 0 | 42 | 42.58831742 | -74.44339029999998 | 2020-05-01 02:32:28 | Schoharie, New York, US |
2020-04-30 | US | New York | Schuyler | 36097 | 7 | 0 | 0 | 7 | 42.39184015 | -76.8773299 | 2020-05-01 02:32:28 | Schuyler, New York, US |
2020-04-30 | US | New York | Seneca | 36099 | 39 | 0 | 0 | 39 | 42.78081007 | -76.82497064 | 2020-05-01 02:32:28 | Seneca, New York, US |
2020-04-30 | US | New York | St. Lawrence | 36089 | 173 | 0 | 0 | 173 | 44.4976179 | -75.06550039 | 2020-05-01 02:32:28 | St. Lawrence, New York, US |
2020-04-30 | US | New York | Tompkins | 36109 | 128 | 0 | 0 | 128 | 42.44945765 | -76.47229843 | 2020-05-01 02:32:28 | Tompkins, New York, US |
2020-04-30 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-05-01 02:32:28 | Unassigned, New York, US |
2020-04-30 | US | New York | Warren | 36113 | 176 | 0 | 0 | 176 | 43.56173026 | -73.8433699 | 2020-05-01 02:32:28 | Warren, New York, US |
2020-05-21 | US | New York | Allegany | 36003 | 44 | 0 | 0 | 44 | 42.25748406 | -78.02750466 | 2020-05-22 02:36:51 | Allegany, New York, US |
2020-05-21 | US | New York | Cattaraugus | 36009 | 71 | 0 | 0 | 71 | 42.24778241 | -78.67923096 | 2020-05-22 02:36:51 | Cattaraugus, New York, US |
2020-05-21 | US | New York | Chenango | 36017 | 118 | 0 | 0 | 118 | 42.49430041 | -75.60887553 | 2020-05-22 02:36:51 | Chenango, New York, US |
2020-05-21 | US | New York | Cortland | 36023 | 36 | 0 | 0 | 36 | 42.59509207 | -76.07048931 | 2020-05-22 02:36:51 | Cortland, New York, US |
2020-05-21 | US | New York | Essex | 36031 | 36 | 0 | 0 | 36 | 44.11630765 | -73.77297842 | 2020-05-22 02:36:51 | Essex, New York, US |
2020-05-21 | US | New York | Franklin | 36033 | 19 | 0 | 0 | 19 | 44.59040891 | -74.29926032 | 2020-05-22 02:36:51 | Franklin, New York, US |
2020-05-21 | US | New York | Hamilton | 36041 | 5 | 0 | 0 | 5 | 43.66146647 | -74.49721957 | 2020-05-22 02:36:51 | Hamilton, New York, US |
2020-05-21 | US | New York | Jefferson | 36045 | 71 | 0 | 0 | 71 | 44.04200959 | -75.94653457 | 2020-05-22 02:36:51 | Jefferson, New York, US |
2020-05-21 | US | New York | Lewis | 36049 | 18 | 0 | 0 | 18 | 43.7844157 | -75.44903992 | 2020-05-22 02:36:51 | Lewis, New York, US |
2020-05-21 | US | New York | Schoharie | 36095 | 49 | 0 | 0 | 49 | 42.58831742 | -74.44339029999998 | 2020-05-22 02:36:51 | Schoharie, New York, US |
2020-05-21 | US | New York | Schuyler | 36097 | 10 | 0 | 0 | 10 | 42.39184015 | -76.8773299 | 2020-05-22 02:36:51 | Schuyler, New York, US |
2020-05-21 | US | New York | Seneca | 36099 | 52 | 0 | 0 | 52 | 42.78081007 | -76.82497064 | 2020-05-22 02:36:51 | Seneca, New York, US |
2020-05-21 | US | New York | Tompkins | 36109 | 145 | 0 | 0 | 145 | 42.44945765 | -76.47229843 | 2020-05-22 02:36:51 | Tompkins, New York, US |
2020-05-21 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-05-22 02:36:51 | Unassigned, New York, US |
2020-04-28 | US | New York | Cattaraugus | 36009 | 45 | 0 | 0 | 45 | 42.24778241 | -78.67923096 | 2020-04-29 02:32:29 | Cattaraugus, New York, US |
2020-04-28 | US | New York | Chenango | 36017 | 95 | 0 | 0 | 95 | 42.49430041 | -75.60887553 | 2020-04-29 02:32:29 | Chenango, New York, US |
2020-04-28 | US | New York | Cortland | 36023 | 28 | 0 | 0 | 28 | 42.59509207 | -76.07048931 | 2020-04-29 02:32:29 | Cortland, New York, US |
2020-04-28 | US | New York | Essex | 36031 | 26 | 0 | 0 | 26 | 44.11630765 | -73.77297842 | 2020-04-29 02:32:29 | Essex, New York, US |
2020-04-28 | US | New York | Franklin | 36033 | 14 | 0 | 0 | 14 | 44.59040891 | -74.29926032 | 2020-04-29 02:32:29 | Franklin, New York, US |
2020-04-28 | US | New York | Fulton | 36035 | 66 | 0 | 0 | 66 | 43.11363907 | -74.41798804 | 2020-04-29 02:32:29 | Fulton, New York, US |
2020-04-28 | US | New York | Hamilton | 36041 | 3 | 0 | 0 | 3 | 43.66146647 | -74.49721957 | 2020-04-29 02:32:29 | Hamilton, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;