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)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
135335 | 135335 | 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 |
135480 | 135480 | 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 |
135703 | 135703 | 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 |
135906 | 135906 | 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 |
136733 | 136733 | 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 |
136736 | 136736 | 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 |
136760 | 136760 | 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 |
136847 | 136847 | 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 |
136976 | 136976 | 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 |
137043 | 137043 | 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 |
137145 | 137145 | 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 |
148179 | 148179 | 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 |
148183 | 148183 | 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 |
148184 | 148184 | 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 |
148188 | 148188 | 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 |
148190 | 148190 | 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 |
148191 | 148191 | 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 |
148211 | 148211 | 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 |
148212 | 148212 | 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 |
148219 | 148219 | 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 |
148221 | 148221 | 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 |
174400 | 174400 | 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 |
174647 | 174647 | 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 |
174732 | 174732 | 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 |
174929 | 174929 | 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 |
175181 | 175181 | 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 |
175413 | 175413 | 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 |
176321 | 176321 | 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 |
176325 | 176325 | 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 |
176592 | 176592 | 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 |
176666 | 176666 | 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 |
196280 | 196280 | 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 |
196284 | 196284 | 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 |
196285 | 196285 | 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 |
196289 | 196289 | 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 |
196291 | 196291 | 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 |
196293 | 196293 | 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 |
196315 | 196315 | 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 |
196316 | 196316 | 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 |
196323 | 196323 | 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 |
208465 | 208465 | 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 |
208469 | 208469 | 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 |
208470 | 208470 | 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 |
208474 | 208474 | 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 |
208476 | 208476 | 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 |
208477 | 208477 | 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 |
208497 | 208497 | 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 |
208498 | 208498 | 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 |
208505 | 208505 | 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 |
208507 | 208507 | 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 |
212501 | 212501 | 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 |
213975 | 213975 | 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 |
214547 | 214547 | 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 |
214777 | 214777 | 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 |
214858 | 214858 | 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 |
215040 | 215040 | 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 |
215280 | 215280 | 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 |
215497 | 215497 | 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 |
216353 | 216353 | 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 |
216356 | 216356 | 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 |
216380 | 216380 | 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 |
216607 | 216607 | 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 |
216678 | 216678 | 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 |
226070 | 226070 | 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 |
226106 | 226106 | 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 |
226262 | 226262 | 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 |
226481 | 226481 | 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 |
226557 | 226557 | 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 |
226583 | 226583 | 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 |
226730 | 226730 | 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 |
226955 | 226955 | 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 |
227158 | 227158 | 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 |
227985 | 227985 | 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 |
227988 | 227988 | 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 |
228012 | 228012 | 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 |
228099 | 228099 | 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 |
228228 | 228228 | 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 |
228295 | 228295 | 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 |
228397 | 228397 | 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 |
265257 | 265257 | 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 |
265625 | 265625 | 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 |
265661 | 265661 | 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 |
265823 | 265823 | 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 |
266049 | 266049 | 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 |
266128 | 266128 | 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 |
266306 | 266306 | 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 |
266536 | 266536 | 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 |
266748 | 266748 | 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 |
267599 | 267599 | 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 |
267602 | 267602 | 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 |
267626 | 267626 | 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 |
267848 | 267848 | 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 |
267918 | 267918 | 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 |
269043 | 269043 | 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 |
269079 | 269079 | 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 |
269235 | 269235 | 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 |
269452 | 269452 | 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 |
269527 | 269527 | 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 |
269552 | 269552 | 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 |
269697 | 269697 | 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 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]);