johns_hopkins_csse_daily_reports
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)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10592 | 10592 | 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 |
40713 | 40713 | 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 |
40747 | 40747 | 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 |
40892 | 40892 | 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 |
41101 | 41101 | 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 |
41174 | 41174 | 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 |
41196 | 41196 | 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 |
41294 | 41294 | 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 |
41333 | 41333 | 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 |
41539 | 41539 | 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 |
41733 | 41733 | 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 |
42166 | 42166 | 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 |
42179 | 42179 | 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 |
42510 | 42510 | 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 |
42513 | 42513 | 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 |
42537 | 42537 | 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 |
42614 | 42614 | 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 |
42726 | 42726 | 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 |
42739 | 42739 | 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 |
42803 | 42803 | 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 |
42894 | 42894 | 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 |
42948 | 42948 | 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 |
43054 | 43054 | 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 |
47773 | 47773 | 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 |
47808 | 47808 | 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 |
47955 | 47955 | 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 |
48165 | 48165 | 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 |
48238 | 48238 | 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 |
48261 | 48261 | 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 |
48358 | 48358 | 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 |
48397 | 48397 | 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 |
48607 | 48607 | 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 |
48804 | 48804 | 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 |
49248 | 49248 | 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 |
49599 | 49599 | 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 |
49602 | 49602 | 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 |
49626 | 49626 | 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 |
49706 | 49706 | 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 |
49818 | 49818 | 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 |
49831 | 49831 | 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 |
49989 | 49989 | 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 |
50044 | 50044 | 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 |
50152 | 50152 | 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 |
59161 | 59161 | 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 |
59407 | 59407 | 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 |
59492 | 59492 | 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 |
59689 | 59689 | 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 |
59941 | 59941 | 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 |
60173 | 60173 | 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 |
61081 | 61081 | 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 |
61085 | 61085 | 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 |
61111 | 61111 | 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 |
61352 | 61352 | 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 |
61426 | 61426 | 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 |
81339 | 81339 | 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 |
81346 | 81346 | 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 |
95483 | 95483 | 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 |
95732 | 95732 | 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 |
95817 | 95817 | 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 |
96014 | 96014 | 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 |
96266 | 96266 | 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 |
96498 | 96498 | 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 |
97411 | 97411 | 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 |
97415 | 97415 | 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 |
97682 | 97682 | 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 |
97755 | 97755 | 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 |
111189 | 111189 | 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 |
111550 | 111550 | 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 |
111586 | 111586 | 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 |
111747 | 111747 | 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 |
111970 | 111970 | 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 |
112048 | 112048 | 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 |
112075 | 112075 | 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 |
112225 | 112225 | 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 |
112453 | 112453 | 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 |
112661 | 112661 | 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 |
113500 | 113500 | 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 |
113503 | 113503 | 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 |
113527 | 113527 | 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 |
113614 | 113614 | 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 |
113747 | 113747 | 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 |
113815 | 113815 | 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 |
113917 | 113917 | 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 |
119090 | 119090 | 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 |
119335 | 119335 | 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 |
119420 | 119420 | 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 |
119617 | 119617 | 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 |
119869 | 119869 | 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 |
120100 | 120100 | 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 |
121005 | 121005 | 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 |
121009 | 121009 | 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 |
121035 | 121035 | 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 |
121276 | 121276 | 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 |
121350 | 121350 | 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 |
124967 | 124967 | 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 |
134824 | 134824 | 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 |
134860 | 134860 | 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 |
135016 | 135016 | 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 |
135235 | 135235 | 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 |
135310 | 135310 | 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 TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);