johns_hopkins_csse_daily_reports

⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

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

8,305 rows where province_or_state = "New York" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • New York · 8,305

country_or_region

  • US 8,305
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
391114 2020-08-08 US New York Albany 36001 2581 128 0 2453 42.60060306 -73.97723916 2020-08-09 04:34:54 Albany, New York, US
391129 2020-08-08 US New York Allegany 36003 79 1 0 78 42.25748406 -78.02750466 2020-08-09 04:34:54 Allegany, New York, US
391372 2020-08-08 US New York Broome 36007 1120 69 0 1051 42.15903158 -75.81326086 2020-08-09 04:34:54 Broome, New York, US
391526 2020-08-08 US New York Cattaraugus 36009 165 6 0 159 42.24778241 -78.67923096 2020-08-09 04:34:54 Cattaraugus, New York, US
391529 2020-08-08 US New York Cayuga 36011 151 2 0 149 42.91261714 -76.55731592 2020-08-09 04:34:54 Cayuga, New York, US
391560 2020-08-08 US New York Chautauqua 36013 253 9 0 244 42.22769210000001 -79.36691763 2020-08-09 04:34:54 Chautauqua, New York, US
391565 2020-08-08 US New York Chemung 36015 171 3 0 168 42.13891056 -76.7638805 2020-08-09 04:34:54 Chemung, New York, US
391566 2020-08-08 US New York Chenango 36017 215 6 0 209 42.49430041 -75.60887553 2020-08-09 04:34:54 Chenango, New York, US
391673 2020-08-08 US New York Clinton 36019 127 4 0 123 44.74530905 -73.67875352 2020-08-09 04:34:54 Clinton, New York, US
391707 2020-08-08 US New York Columbia 36021 539 37 0 502 42.24819348 -73.63089095 2020-08-09 04:34:54 Columbia, New York, US
391738 2020-08-08 US New York Cortland 36023 95 0 0 95 42.59509207 -76.07048931 2020-08-09 04:34:54 Cortland, New York, US
391860 2020-08-08 US New York Delaware 36025 105 4 0 101 42.19837623 -74.96709306 2020-08-09 04:34:54 Delaware, New York, US
391931 2020-08-08 US New York Dutchess 36027 4600 153 0 4447 41.76486060000001 -73.74356679 2020-08-09 04:34:54 Dutchess, New York, US
391979 2020-08-08 US New York Erie 36029 8850 671 0 8179 42.76249024 -78.73063652 2020-08-09 04:34:54 Erie, New York, US
391987 2020-08-08 US New York Essex 36031 55 0 0 55 44.11630765 -73.77297842 2020-08-09 04:34:54 Essex, New York, US
392072 2020-08-08 US New York Franklin 36033 54 0 0 54 44.59040891 -74.29926032 2020-08-09 04:34:54 Franklin, New York, US
392099 2020-08-08 US New York Fulton 36035 295 24 0 271 43.11363907 -74.41798804 2020-08-09 04:34:54 Fulton, New York, US
392130 2020-08-08 US New York Genesee 36037 277 5 0 272 43.0022601 -78.19135193 2020-08-09 04:34:54 Genesee, New York, US
392217 2020-08-08 US New York Greene 36039 291 18 0 273 42.275797 -74.12384884 2020-08-09 04:34:54 Greene, New York, US
392269 2020-08-08 US New York Hamilton 36041 8 0 0 8 43.66146647 -74.49721957 2020-08-09 04:34:54 Hamilton, New York, US
392361 2020-08-08 US New York Herkimer 36043 273 4 0 269 43.42034246 -74.96145307 2020-08-09 04:34:54 Herkimer, New York, US
392521 2020-08-08 US New York Jefferson 36045 140 0 0 140 44.04200959 -75.94653457 2020-08-09 04:34:54 Jefferson, New York, US
392754 2020-08-08 US New York Lewis 36049 41 0 0 41 43.7844157 -75.44903992 2020-08-09 04:34:54 Lewis, New York, US
392805 2020-08-08 US New York Livingston 36051 176 8 0 168 42.72596275 -77.77966158 2020-08-09 04:34:54 Livingston, New York, US
392875 2020-08-08 US New York Madison 36053 412 17 0 395 42.91653905 -75.67266639 2020-08-09 04:34:54 Madison, New York, US
393078 2020-08-08 US New York Monroe 36055 4922 285 0 4637 43.14638895 -77.69322942 2020-08-09 04:34:54 Monroe, New York, US
393099 2020-08-08 US New York Montgomery 36057 172 4 0 168 42.90123494 -74.44011632 2020-08-09 04:34:54 Montgomery, New York, US
393157 2020-08-08 US New York Nassau 36059 43628 2194 0 41434 40.74066522 -73.58941873 2020-08-09 04:34:54 Nassau, New York, US
393178 2020-08-08 US New York New York City 36061 227584 23575 0 204009 40.76727260000001 -73.97152637 2020-08-09 04:34:54 New York City, New York, US
393190 2020-08-08 US New York Niagara 36063 1494 98 0 1396 43.19898042 -78.74777412 2020-08-09 04:34:54 Niagara, New York, US
393248 2020-08-08 US New York Oneida 36065 2142 115 0 2027 43.24375382 -75.43710392 2020-08-09 04:34:54 Oneida, New York, US
393250 2020-08-08 US New York Onondaga 36067 3565 200 0 3365 43.00491923 -76.19971155 2020-08-09 04:34:54 Onondaga, New York, US
393252 2020-08-08 US New York Ontario 36069 357 34 0 323 42.85145728 -77.30874425 2020-08-09 04:34:54 Ontario, New York, US
393257 2020-08-08 US New York Orange 36071 11156 491 0 10665 41.40337468 -74.30240757 2020-08-09 04:34:54 Orange, New York, US
393265 2020-08-08 US New York Orleans 36073 298 54 0 244 43.2516977 -78.2320066 2020-08-09 04:34:54 Orleans, New York, US
393276 2020-08-08 US New York Oswego 36075 253 3 0 250 43.42778894 -76.14635194 2020-08-09 04:34:54 Oswego, New York, US
393281 2020-08-08 US New York Otsego 36077 116 5 0 111 42.63492579 -75.03151402 2020-08-09 04:34:54 Otsego, New York, US
393486 2020-08-08 US New York Putnam 36079 1447 63 0 1384 41.42630093 -73.74965532 2020-08-09 04:34:54 Putnam, New York, US
393528 2020-08-08 US New York Rensselaer 36083 761 30 0 731 42.71348136 -73.51089874 2020-08-09 04:34:54 Rensselaer, New York, US
393579 2020-08-08 US New York Rockland 36087 13936 674 0 13262 41.15027894 -74.02560498 2020-08-09 04:34:54 Rockland, New York, US
393660 2020-08-08 US New York Saratoga 36091 755 17 0 738 43.10904162 -73.86653895 2020-08-09 04:34:54 Saratoga, New York, US
393666 2020-08-08 US New York Schenectady 36093 1058 37 0 1021 42.81668777 -74.05278291 2020-08-09 04:34:54 Schenectady, New York, US
393669 2020-08-08 US New York Schoharie 36095 69 0 0 69 42.58831742 -74.44339029999998 2020-08-09 04:34:54 Schoharie, New York, US
393673 2020-08-08 US New York Schuyler 36097 22 0 0 22 42.39184015 -76.8773299 2020-08-09 04:34:54 Schuyler, New York, US
393699 2020-08-08 US New York Seneca 36099 89 3 0 86 42.78081007 -76.82497064 2020-08-09 04:34:54 Seneca, New York, US
393794 2020-08-08 US New York St. Lawrence 36089 263 4 0 259 44.4976179 -75.06550039 2020-08-09 04:34:54 St. Lawrence, New York, US
393826 2020-08-08 US New York Steuben 36101 298 42 0 256 42.2689144 -77.3829924 2020-08-09 04:34:54 Steuben, New York, US
393845 2020-08-08 US New York Suffolk 36103 43749 1998 0 41751 40.88320119 -72.8012172 2020-08-09 04:34:54 Suffolk, New York, US
393850 2020-08-08 US New York Sullivan 36105 1488 48 0 1440 41.71579493 -74.76394559 2020-08-09 04:34:54 Sullivan, New York, US
393925 2020-08-08 US New York Tioga 36107 193 25 0 168 42.16852837 -76.30835812 2020-08-09 04:34:54 Tioga, New York, US
393940 2020-08-08 US New York Tompkins 36109 234 0 0 234 42.44945765 -76.47229843 2020-08-09 04:34:54 Tompkins, New York, US
393981 2020-08-08 US New York Ulster 36111 2057 91 0 1966 41.89027881 -74.26252104 2020-08-09 04:34:54 Ulster, New York, US
394012 2020-08-08 US New York Unassigned 90036 0 0 0 0 44.74530905 0.0 2020-08-09 04:34:54 Unassigned, New York, US
394123 2020-08-08 US New York Warren 36113 308 33 0 275 43.56173026 -73.8433699 2020-08-09 04:34:54 Warren, New York, US
394153 2020-08-08 US New York Washington 36115 257 14 0 243 43.31153794 -73.43043448 2020-08-09 04:34:54 Washington, New York, US
394182 2020-08-08 US New York Wayne 36117 249 3 0 246 43.15494365 -77.02976528 2020-08-09 04:34:54 Wayne, New York, US
394206 2020-08-08 US New York Westchester 36119 36180 1447 0 34733 41.16278376 -73.75741653 2020-08-09 04:34:54 Westchester, New York, US
394293 2020-08-08 US New York Wyoming 36121 116 5 0 111 42.70145109 -78.22199579 2020-08-09 04:34:54 Wyoming, New York, US
394305 2020-08-08 US New York Yates 36123 56 7 0 49 42.63505484 -77.10369919 2020-08-09 04:34:54 Yates, New York, US
281678 2020-08-07 US New York Albany 36001 2573 128 0 2445 42.60060306 -73.97723916 2020-08-08 04:34:53 Albany, New York, US
281693 2020-08-07 US New York Allegany 36003 79 1 0 78 42.25748406 -78.02750466 2020-08-08 04:34:53 Allegany, New York, US
281936 2020-08-07 US New York Broome 36007 1115 69 0 1046 42.15903158 -75.81326086 2020-08-08 04:34:53 Broome, New York, US
282090 2020-08-07 US New York Cattaraugus 36009 164 6 0 158 42.24778241 -78.67923096 2020-08-08 04:34:53 Cattaraugus, New York, US
282093 2020-08-07 US New York Cayuga 36011 151 2 0 149 42.91261714 -76.55731592 2020-08-08 04:34:53 Cayuga, New York, US
282124 2020-08-07 US New York Chautauqua 36013 249 9 0 240 42.22769210000001 -79.36691763 2020-08-08 04:34:53 Chautauqua, New York, US
282129 2020-08-07 US New York Chemung 36015 168 3 0 165 42.13891056 -76.7638805 2020-08-08 04:34:53 Chemung, New York, US
282130 2020-08-07 US New York Chenango 36017 215 6 0 209 42.49430041 -75.60887553 2020-08-08 04:34:53 Chenango, New York, US
282237 2020-08-07 US New York Clinton 36019 127 4 0 123 44.74530905 -73.67875352 2020-08-08 04:34:53 Clinton, New York, US
282271 2020-08-07 US New York Columbia 36021 535 37 0 498 42.24819348 -73.63089095 2020-08-08 04:34:53 Columbia, New York, US
282302 2020-08-07 US New York Cortland 36023 95 0 0 95 42.59509207 -76.07048931 2020-08-08 04:34:53 Cortland, New York, US
282424 2020-08-07 US New York Delaware 36025 104 4 0 100 42.19837623 -74.96709306 2020-08-08 04:34:53 Delaware, New York, US
282495 2020-08-07 US New York Dutchess 36027 4589 153 0 4436 41.76486060000001 -73.74356679 2020-08-08 04:34:53 Dutchess, New York, US
282543 2020-08-07 US New York Erie 36029 8791 671 0 8120 42.76249024 -78.73063652 2020-08-08 04:34:53 Erie, New York, US
282551 2020-08-07 US New York Essex 36031 55 0 0 55 44.11630765 -73.77297842 2020-08-08 04:34:53 Essex, New York, US
282636 2020-08-07 US New York Franklin 36033 54 0 0 54 44.59040891 -74.29926032 2020-08-08 04:34:53 Franklin, New York, US
282663 2020-08-07 US New York Fulton 36035 293 24 0 269 43.11363907 -74.41798804 2020-08-08 04:34:53 Fulton, New York, US
282694 2020-08-07 US New York Genesee 36037 277 5 0 272 43.0022601 -78.19135193 2020-08-08 04:34:53 Genesee, New York, US
282781 2020-08-07 US New York Greene 36039 291 18 0 273 42.275797 -74.12384884 2020-08-08 04:34:53 Greene, New York, US
282833 2020-08-07 US New York Hamilton 36041 8 0 0 8 43.66146647 -74.49721957 2020-08-08 04:34:53 Hamilton, New York, US
282925 2020-08-07 US New York Herkimer 36043 270 4 0 266 43.42034246 -74.96145307 2020-08-08 04:34:53 Herkimer, New York, US
283085 2020-08-07 US New York Jefferson 36045 140 0 0 140 44.04200959 -75.94653457 2020-08-08 04:34:53 Jefferson, New York, US
283318 2020-08-07 US New York Lewis 36049 39 0 0 39 43.7844157 -75.44903992 2020-08-08 04:34:53 Lewis, New York, US
283369 2020-08-07 US New York Livingston 36051 174 8 0 166 42.72596275 -77.77966158 2020-08-08 04:34:53 Livingston, New York, US
283439 2020-08-07 US New York Madison 36053 412 17 0 395 42.91653905 -75.67266639 2020-08-08 04:34:53 Madison, New York, US
283642 2020-08-07 US New York Monroe 36055 4901 285 0 4616 43.14638895 -77.69322942 2020-08-08 04:34:53 Monroe, New York, US
283663 2020-08-07 US New York Montgomery 36057 170 4 0 166 42.90123494 -74.44011632 2020-08-08 04:34:53 Montgomery, New York, US
283721 2020-08-07 US New York Nassau 36059 43580 2194 0 41386 40.74066522 -73.58941873 2020-08-08 04:34:53 Nassau, New York, US
283742 2020-08-07 US New York New York City 36061 227258 23567 0 203691 40.76727260000001 -73.97152637 2020-08-08 04:34:53 New York City, New York, US
283754 2020-08-07 US New York Niagara 36063 1491 98 0 1393 43.19898042 -78.74777412 2020-08-08 04:34:53 Niagara, New York, US
283812 2020-08-07 US New York Oneida 36065 2129 115 0 2014 43.24375382 -75.43710392 2020-08-08 04:34:53 Oneida, New York, US
283814 2020-08-07 US New York Onondaga 36067 3556 200 0 3356 43.00491923 -76.19971155 2020-08-08 04:34:53 Onondaga, New York, US
283816 2020-08-07 US New York Ontario 36069 357 34 0 323 42.85145728 -77.30874425 2020-08-08 04:34:53 Ontario, New York, US
283821 2020-08-07 US New York Orange 36071 11129 491 0 10638 41.40337468 -74.30240757 2020-08-08 04:34:53 Orange, New York, US
283829 2020-08-07 US New York Orleans 36073 297 54 0 243 43.2516977 -78.2320066 2020-08-08 04:34:53 Orleans, New York, US
283840 2020-08-07 US New York Oswego 36075 251 3 0 248 43.42778894 -76.14635194 2020-08-08 04:34:53 Oswego, New York, US
283845 2020-08-07 US New York Otsego 36077 116 5 0 111 42.63492579 -75.03151402 2020-08-08 04:34:53 Otsego, New York, US
284050 2020-08-07 US New York Putnam 36079 1446 63 0 1383 41.42630093 -73.74965532 2020-08-08 04:34:53 Putnam, New York, US
284092 2020-08-07 US New York Rensselaer 36083 759 30 0 729 42.71348136 -73.51089874 2020-08-08 04:34:53 Rensselaer, New York, US
284143 2020-08-07 US New York Rockland 36087 13925 674 0 13251 41.15027894 -74.02560498 2020-08-08 04:34:53 Rockland, New York, US
284224 2020-08-07 US New York Saratoga 36091 752 17 0 735 43.10904162 -73.86653895 2020-08-08 04:34:53 Saratoga, New York, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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] INTEGER,
   [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]);
Powered by Datasette · Query took 1802.155ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette