daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
64,046 rows where country_or_region = "US" and province_or_state = "New York" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-25 | US | New York | Tompkins | 36109 | 603 | 0 | 0 | 603 | 42.44945765 | -76.47229843 | 2020-10-26 04:25:02 | Tompkins, New York, US |
2020-04-13 | US | New York | Cattaraugus | 36009 | 28 | 0 | 0 | 28 | 42.24778241 | -78.67923096 | 2020-04-13 23:07:54 | Cattaraugus, New York, US |
2020-04-13 | US | New York | Chenango | 36017 | 65 | 0 | 0 | 65 | 42.49430041 | -75.60887553 | 2020-04-13 23:07:54 | Chenango, New York, US |
2020-04-13 | US | New York | Cortland | 36023 | 21 | 0 | 0 | 21 | 42.59509207 | -76.07048931 | 2020-04-13 23:07:54 | Cortland, New York, US |
2020-04-13 | US | New York | Essex | 36031 | 12 | 0 | 0 | 12 | 44.11630765 | -73.77297842 | 2020-04-13 23:07:54 | Essex, New York, US |
2020-04-13 | US | New York | Franklin | 36033 | 12 | 0 | 0 | 12 | 44.59040891 | -74.29926032 | 2020-04-13 23:07:54 | Franklin, New York, US |
2020-04-13 | US | New York | Fulton | 36035 | 21 | 0 | 0 | 21 | 43.11363907 | -74.41798804 | 2020-04-13 23:07:54 | Fulton, New York, US |
2020-04-13 | US | New York | Greene | 36039 | 45 | 0 | 0 | 45 | 42.275797 | -74.12384884 | 2020-04-13 23:07:54 | Greene, New York, US |
2020-04-13 | US | New York | Hamilton | 36041 | 3 | 0 | 0 | 3 | 43.66146647 | -74.49721957 | 2020-04-13 23:07:54 | Hamilton, New York, US |
2020-04-13 | US | New York | Jefferson | 36045 | 46 | 0 | 0 | 46 | 44.04200959 | -75.94653457 | 2020-04-13 23:07:54 | Jefferson, New York, US |
2020-04-13 | US | New York | Lewis | 36049 | 6 | 0 | 0 | 6 | 43.784415700000004 | -75.44903992 | 2020-04-13 23:07:54 | Lewis, New York, US |
2020-04-13 | US | New York | Ontario | 36069 | 57 | 0 | 0 | 57 | 42.85145728 | -77.30874425 | 2020-04-13 23:07:54 | Ontario, New York, US |
2020-04-13 | US | New York | Orleans | 36073 | 26 | 0 | 0 | 26 | 43.2516977 | -78.2320066 | 2020-04-13 23:07:54 | Orleans, New York, US |
2020-04-13 | US | New York | Schoharie | 36095 | 12 | 0 | 0 | 12 | 42.58831742 | -74.44339029999998 | 2020-04-13 23:07:54 | Schoharie, New York, US |
2020-04-13 | US | New York | Schuyler | 36097 | 8 | 0 | 0 | 8 | 42.39184015 | -76.8773299 | 2020-04-13 23:07:54 | Schuyler, New York, US |
2020-04-13 | US | New York | Seneca | 36099 | 16 | 0 | 0 | 16 | 42.78081007 | -76.82497064 | 2020-04-13 23:07:54 | Seneca, New York, US |
2020-04-13 | US | New York | St. Lawrence | 36089 | 89 | 0 | 0 | 89 | 44.4976179 | -75.06550039 | 2020-04-13 23:07:54 | St. Lawrence, New York, US |
2020-04-13 | US | New York | Tioga | 36107 | 23 | 0 | 0 | 23 | 42.16852837 | -76.30835812 | 2020-04-13 23:07:54 | Tioga, New York, US |
2020-04-13 | US | New York | Tompkins | 36109 | 113 | 0 | 0 | 113 | 42.44945765 | -76.47229843 | 2020-04-13 23:07:54 | Tompkins, New York, US |
2020-04-13 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-04-13 23:07:54 | Unassigned, New York, US |
2020-04-13 | US | New York | Warren | 36113 | 48 | 0 | 0 | 48 | 43.56173026 | -73.8433699 | 2020-04-13 23:07:54 | Warren, New York, US |
2020-04-13 | US | New York | Wayne | 36117 | 42 | 0 | 0 | 42 | 43.15494365 | -77.02976528 | 2020-04-13 23:07:54 | Wayne, New York, US |
2020-04-13 | US | New York | Yates | 36123 | 4 | 0 | 0 | 4 | 42.63505484 | -77.10369919 | 2020-04-13 23:07:54 | Yates, New York, US |
2020-04-17 | US | New York | Cattaraugus | 36009 | 34 | 0 | 0 | 34 | 42.24778241 | -78.67923096 | 2020-04-17 23:30:52 | Cattaraugus, New York, US |
2020-04-17 | US | New York | Chenango | 36017 | 76 | 0 | 0 | 76 | 42.49430041 | -75.60887553 | 2020-04-17 23:30:52 | Chenango, New York, US |
2020-04-17 | US | New York | Cortland | 36023 | 25 | 0 | 0 | 25 | 42.59509207 | -76.07048931 | 2020-04-17 23:30:52 | Cortland, New York, US |
2020-04-17 | US | New York | Essex | 36031 | 15 | 0 | 0 | 15 | 44.11630765 | -73.77297842 | 2020-04-17 23:30:52 | Essex, New York, US |
2020-04-17 | US | New York | Franklin | 36033 | 13 | 0 | 0 | 13 | 44.59040891 | -74.29926032 | 2020-04-17 23:30:52 | Franklin, New York, US |
2020-04-17 | US | New York | Fulton | 36035 | 27 | 0 | 0 | 27 | 43.11363907 | -74.41798804 | 2020-04-17 23:30:52 | Fulton, New York, US |
2020-04-17 | US | New York | Greene | 36039 | 77 | 0 | 0 | 77 | 42.275797 | -74.12384884 | 2020-04-17 23:30:52 | Greene, New York, US |
2020-04-17 | US | New York | Hamilton | 36041 | 3 | 0 | 0 | 3 | 43.66146647 | -74.49721957 | 2020-04-17 23:30:52 | Hamilton, New York, US |
2020-04-17 | US | New York | Jefferson | 36045 | 50 | 0 | 0 | 50 | 44.04200959 | -75.94653457 | 2020-04-17 23:30:52 | Jefferson, New York, US |
2020-04-17 | US | New York | Lewis | 36049 | 8 | 0 | 0 | 8 | 43.784415700000004 | -75.44903992 | 2020-04-17 23:30:52 | Lewis, New York, US |
2020-04-17 | US | New York | Ontario | 36069 | 67 | 0 | 0 | 67 | 42.85145728 | -77.30874425 | 2020-04-17 23:30:52 | Ontario, New York, US |
2020-04-17 | US | New York | Schoharie | 36095 | 20 | 0 | 0 | 20 | 42.58831742 | -74.44339029999998 | 2020-04-17 23:30:52 | Schoharie, New York, US |
2020-04-17 | US | New York | Schuyler | 36097 | 8 | 0 | 0 | 8 | 42.39184015 | -76.8773299 | 2020-04-17 23:30:52 | Schuyler, New York, US |
2020-04-17 | US | New York | Seneca | 36099 | 18 | 0 | 0 | 18 | 42.78081007 | -76.82497064 | 2020-04-17 23:30:52 | Seneca, New York, US |
2020-04-17 | US | New York | St. Lawrence | 36089 | 96 | 0 | 0 | 96 | 44.4976179 | -75.06550039 | 2020-04-17 23:30:52 | St. Lawrence, New York, US |
2020-04-17 | US | New York | Tioga | 36107 | 30 | 0 | 0 | 30 | 42.16852837 | -76.30835812 | 2020-04-17 23:30:52 | Tioga, New York, US |
2020-04-17 | US | New York | Tompkins | 36109 | 119 | 0 | 0 | 119 | 42.44945765 | -76.47229843 | 2020-04-17 23:30:52 | Tompkins, New York, US |
2020-04-17 | US | New York | Warren | 36113 | 91 | 0 | 0 | 91 | 43.56173026 | -73.8433699 | 2020-04-17 23:30:52 | Warren, New York, US |
2020-04-17 | US | New York | Wayne | 36117 | 49 | 0 | 0 | 49 | 43.15494365 | -77.02976528 | 2020-04-17 23:30:52 | Wayne, New York, US |
2020-04-17 | US | New York | Yates | 36123 | 8 | 0 | 0 | 8 | 42.63505484 | -77.10369919 | 2020-04-17 23:30:52 | Yates, New York, US |
2020-07-23 | US | New York | Cortland | 36023 | 80 | 0 | 0 | 80 | 42.59509207 | -76.07048931 | 2020-07-24 05:30:40 | Cortland, New York, US |
2020-07-23 | US | New York | Essex | 36031 | 54 | 0 | 0 | 54 | 44.11630765 | -73.77297842 | 2020-07-24 05:30:40 | Essex, New York, US |
2020-07-23 | US | New York | Franklin | 36033 | 42 | 0 | 0 | 42 | 44.59040891 | -74.29926032 | 2020-07-24 05:30:40 | Franklin, New York, US |
2020-07-23 | US | New York | Hamilton | 36041 | 6 | 0 | 0 | 6 | 43.66146647 | -74.49721957 | 2020-07-24 05:30:40 | Hamilton, New York, US |
2020-07-23 | US | New York | Jefferson | 36045 | 120 | 0 | 0 | 120 | 44.04200959 | -75.94653457 | 2020-07-24 05:30:40 | Jefferson, New York, US |
2020-07-23 | US | New York | Lewis | 36049 | 34 | 0 | 0 | 34 | 43.7844157 | -75.44903992 | 2020-07-24 05:30:40 | Lewis, New York, US |
2020-07-23 | US | New York | Schoharie | 36095 | 66 | 0 | 0 | 66 | 42.58831742 | -74.44339029999998 | 2020-07-24 05:30:40 | Schoharie, New York, US |
2020-07-23 | US | New York | Schuyler | 36097 | 20 | 0 | 0 | 20 | 42.39184015 | -76.8773299 | 2020-07-24 05:30:40 | Schuyler, New York, US |
2020-07-23 | US | New York | Seneca | 36099 | 80 | 0 | 0 | 80 | 42.78081007 | -76.82497064 | 2020-07-24 05:30:40 | Seneca, New York, US |
2020-07-23 | US | New York | Tompkins | 36109 | 213 | 0 | 0 | 213 | 42.44945765 | -76.47229843 | 2020-07-24 05:30:40 | Tompkins, New York, US |
2020-07-23 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-07-24 05:30:40 | Unassigned, New York, US |
2020-10-14 | US | New York | Schuyler | 36097 | 79 | 0 | 0 | 79 | 42.39184015 | -76.8773299 | 2020-10-15 04:24:28 | Schuyler, New York, US |
2020-10-14 | US | New York | Tompkins | 36109 | 507 | 0 | 0 | 507 | 42.44945765 | -76.47229843 | 2020-10-15 04:24:28 | Tompkins, New York, US |
2020-08-04 | US | New York | Cortland | 36023 | 93 | 0 | 0 | 93 | 42.59509207 | -76.07048931 | 2020-08-05 04:34:43 | Cortland, New York, US |
2020-08-04 | US | New York | Essex | 36031 | 55 | 0 | 0 | 55 | 44.11630765 | -73.77297842 | 2020-08-05 04:34:43 | Essex, New York, US |
2020-08-04 | US | New York | Franklin | 36033 | 50 | 0 | 0 | 50 | 44.59040891 | -74.29926032 | 2020-08-05 04:34:43 | Franklin, New York, US |
2020-08-04 | US | New York | Hamilton | 36041 | 7 | 0 | 0 | 7 | 43.66146647 | -74.49721957 | 2020-08-05 04:34:43 | Hamilton, New York, US |
2020-08-04 | US | New York | Jefferson | 36045 | 139 | 0 | 0 | 139 | 44.04200959 | -75.94653457 | 2020-08-05 04:34:43 | Jefferson, New York, US |
2020-08-04 | US | New York | Lewis | 36049 | 37 | 0 | 0 | 37 | 43.7844157 | -75.44903992 | 2020-08-05 04:34:43 | Lewis, New York, US |
2020-08-04 | US | New York | Schoharie | 36095 | 68 | 0 | 0 | 68 | 42.58831742 | -74.44339029999998 | 2020-08-05 04:34:43 | Schoharie, New York, US |
2020-08-04 | US | New York | Schuyler | 36097 | 22 | 0 | 0 | 22 | 42.39184015 | -76.8773299 | 2020-08-05 04:34:43 | Schuyler, New York, US |
2020-08-04 | US | New York | Tompkins | 36109 | 230 | 0 | 0 | 230 | 42.44945765 | -76.47229843 | 2020-08-05 04:34:43 | Tompkins, New York, US |
2020-08-04 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-08-05 04:34:43 | Unassigned, New York, US |
2020-05-08 | US | New York | Allegany | 36003 | 35 | 0 | 0 | 35 | 42.25748406 | -78.02750466 | 2020-05-09 02:32:35 | Allegany, New York, US |
2020-05-08 | US | New York | Cattaraugus | 36009 | 59 | 0 | 0 | 59 | 42.24778241 | -78.67923096 | 2020-05-09 02:32:35 | Cattaraugus, New York, US |
2020-05-08 | US | New York | Chenango | 36017 | 105 | 0 | 0 | 105 | 42.49430041 | -75.60887553 | 2020-05-09 02:32:35 | Chenango, New York, US |
2020-05-08 | US | New York | Cortland | 36023 | 29 | 0 | 0 | 29 | 42.59509207 | -76.07048931 | 2020-05-09 02:32:35 | Cortland, New York, US |
2020-05-08 | US | New York | Essex | 36031 | 31 | 0 | 0 | 31 | 44.11630765 | -73.77297842 | 2020-05-09 02:32:35 | Essex, New York, US |
2020-05-08 | US | New York | Franklin | 36033 | 17 | 0 | 0 | 17 | 44.59040891 | -74.29926032 | 2020-05-09 02:32:35 | Franklin, New York, US |
2020-05-08 | US | New York | Fulton | 36035 | 103 | 0 | 0 | 103 | 43.11363907 | -74.41798804 | 2020-05-09 02:32:35 | Fulton, New York, US |
2020-05-08 | US | New York | Hamilton | 36041 | 5 | 0 | 0 | 5 | 43.66146647 | -74.49721957 | 2020-05-09 02:32:35 | Hamilton, New York, US |
2020-05-08 | US | New York | Jefferson | 36045 | 66 | 0 | 0 | 66 | 44.04200959 | -75.94653457 | 2020-05-09 02:32:35 | Jefferson, New York, US |
2020-05-08 | US | New York | Lewis | 36049 | 10 | 0 | 0 | 10 | 43.7844157 | -75.44903992 | 2020-05-09 02:32:35 | Lewis, New York, US |
2020-05-08 | US | New York | Schoharie | 36095 | 45 | 0 | 0 | 45 | 42.58831742 | -74.44339029999998 | 2020-05-09 02:32:35 | Schoharie, New York, US |
2020-05-08 | US | New York | Schuyler | 36097 | 7 | 0 | 0 | 7 | 42.39184015 | -76.8773299 | 2020-05-09 02:32:35 | Schuyler, New York, US |
2020-05-08 | US | New York | Seneca | 36099 | 46 | 0 | 0 | 46 | 42.78081007 | -76.82497064 | 2020-05-09 02:32:35 | Seneca, New York, US |
2020-05-08 | US | New York | St. Lawrence | 36089 | 187 | 0 | 0 | 187 | 44.4976179 | -75.06550039 | 2020-05-09 02:32:35 | St. Lawrence, New York, US |
2020-05-08 | US | New York | Tompkins | 36109 | 131 | 0 | 0 | 131 | 42.44945765 | -76.47229843 | 2020-05-09 02:32:35 | Tompkins, New York, US |
2020-05-08 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-05-09 02:32:35 | Unassigned, New York, US |
2020-05-08 | US | New York | Warren | 36113 | 199 | 0 | 0 | 199 | 43.56173026 | -73.8433699 | 2020-05-09 02:32:35 | Warren, New York, US |
2020-07-19 | US | New York | Cortland | 36023 | 69 | 0 | 0 | 69 | 42.59509207 | -76.07048931 | 2020-07-20 05:34:40 | Cortland, New York, US |
2020-07-19 | US | New York | Essex | 36031 | 51 | 0 | 0 | 51 | 44.11630765 | -73.77297842 | 2020-07-20 05:34:40 | Essex, New York, US |
2020-07-19 | US | New York | Franklin | 36033 | 40 | 0 | 0 | 40 | 44.59040891 | -74.29926032 | 2020-07-20 05:34:40 | Franklin, New York, US |
2020-07-19 | US | New York | Hamilton | 36041 | 6 | 0 | 0 | 6 | 43.66146647 | -74.49721957 | 2020-07-20 05:34:40 | Hamilton, New York, US |
2020-07-19 | US | New York | Jefferson | 36045 | 105 | 0 | 0 | 105 | 44.04200959 | -75.94653457 | 2020-07-20 05:34:40 | Jefferson, New York, US |
2020-07-19 | US | New York | Lewis | 36049 | 33 | 0 | 0 | 33 | 43.7844157 | -75.44903992 | 2020-07-20 05:34:40 | Lewis, New York, US |
2020-07-19 | US | New York | Schoharie | 36095 | 62 | 0 | 0 | 62 | 42.58831742 | -74.44339029999998 | 2020-07-20 05:34:40 | Schoharie, New York, US |
2020-07-19 | US | New York | Schuyler | 36097 | 16 | 0 | 0 | 16 | 42.39184015 | -76.8773299 | 2020-07-20 05:34:40 | Schuyler, New York, US |
2020-07-19 | US | New York | Seneca | 36099 | 80 | 0 | 0 | 80 | 42.78081007 | -76.82497064 | 2020-07-20 05:34:40 | Seneca, New York, US |
2020-07-19 | US | New York | Tompkins | 36109 | 208 | 0 | 0 | 208 | 42.44945765 | -76.47229843 | 2020-07-20 05:34:40 | Tompkins, New York, US |
2020-07-19 | US | New York | Unassigned | 90036 | 0 | 0 | 0 | 0 | 44.74530905 | 0.0 | 2020-07-20 05:34:40 | Unassigned, New York, US |
2020-11-18 | US | New York | Tompkins | 36109 | 828 | 0 | 0 | 828 | 42.44945765 | -76.47229843 | 2020-11-19 05:25:23 | Tompkins, New York, US |
2020-04-29 | US | New York | Cattaraugus | 36009 | 47 | 0 | 0 | 47 | 42.24778241 | -78.67923096 | 2020-04-30 02:32:27 | Cattaraugus, New York, US |
2020-04-29 | US | New York | Chenango | 36017 | 96 | 0 | 0 | 96 | 42.49430041 | -75.60887553 | 2020-04-30 02:32:27 | Chenango, New York, US |
2020-04-29 | US | New York | Cortland | 36023 | 28 | 0 | 0 | 28 | 42.59509207 | -76.07048931 | 2020-04-30 02:32:27 | Cortland, New York, US |
2020-04-29 | US | New York | Essex | 36031 | 27 | 0 | 0 | 27 | 44.11630765 | -73.77297842 | 2020-04-30 02:32:27 | Essex, New York, US |
2020-04-29 | US | New York | Franklin | 36033 | 15 | 0 | 0 | 15 | 44.59040891 | -74.29926032 | 2020-04-30 02:32:27 | Franklin, New York, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;