johns_hopkins_csse_daily_reports

Table actions
⚠️ 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

64 rows where "last_update" is on date 2022-07-15 and province_or_state = "New York" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state 1

  • New York · 64 ✖

country_or_region 1

Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
3431187 3431187 2022-07-14 US New York Albany 36001 68262 543 0   42.60060306 -73.97723916 2022-07-15 04:20:53 Albany, New York, US
3431188 3431188 2022-07-14 US New York Allegany 36003 9676 158 0   42.25748406 -78.02750466 2022-07-15 04:20:53 Allegany, New York, US
3431189 3431189 2022-07-14 US New York Bronx 36005 449639 7834 0   40.85209301 -73.86282755 2022-07-15 04:20:53 Bronx, New York, US
3431190 3431190 2022-07-14 US New York Broome 36007 51329 534 0   42.15903158 -75.81326086 2022-07-15 04:20:53 Broome, New York, US
3431191 3431191 2022-07-14 US New York Cattaraugus 36009 16972 226 0   42.24778241 -78.67923096 2022-07-15 04:20:53 Cattaraugus, New York, US
3431192 3431192 2022-07-14 US New York Cayuga 36011 17939 160 0   42.91261714 -76.55731592 2022-07-15 04:20:53 Cayuga, New York, US
3431193 3431193 2022-07-14 US New York Chautauqua 36013 26027 306 0   42.2276921 -79.36691763 2022-07-15 04:20:53 Chautauqua, New York, US
3431194 3431194 2022-07-14 US New York Chemung 36015 23548 239 0   42.13891056 -76.7638805 2022-07-15 04:20:53 Chemung, New York, US
3431195 3431195 2022-07-14 US New York Chenango 36017 10340 124 0   42.49430041 -75.60887553 2022-07-15 04:20:53 Chenango, New York, US
3431196 3431196 2022-07-14 US New York Clinton 36019 19360 94 0   44.74530905 -73.67875352 2022-07-15 04:20:53 Clinton, New York, US
3431197 3431197 2022-07-14 US New York Columbia 36021 11704 150 0   42.24819348 -73.63089095 2022-07-15 04:20:53 Columbia, New York, US
3431198 3431198 2022-07-14 US New York Cortland 36023 11732 123 0   42.59509207 -76.07048931 2022-07-15 04:20:53 Cortland, New York, US
3431199 3431199 2022-07-14 US New York Delaware 36025 8834 79 0   42.19837623 -74.96709306 2022-07-15 04:20:53 Delaware, New York, US
3431200 3431200 2022-07-14 US New York Dutchess 36027 72227 671 0   41.7648606 -73.74356679 2022-07-15 04:20:53 Dutchess, New York, US
3431201 3431201 2022-07-14 US New York Erie 36029 239399 2703 0   42.76249024 -78.73063652 2022-07-15 04:20:53 Erie, New York, US
3431202 3431202 2022-07-14 US New York Essex 36031 6608 65 0   44.11630765 -73.77297842 2022-07-15 04:20:53 Essex, New York, US
3431203 3431203 2022-07-14 US New York Franklin 36033 10557 48 0   44.59040891 -74.29926032 2022-07-15 04:20:53 Franklin, New York, US
3431204 3431204 2022-07-14 US New York Fulton 36035 14191 173 0   43.11363907 -74.41798804 2022-07-15 04:20:53 Fulton, New York, US
3431205 3431205 2022-07-14 US New York Genesee 36037 14947 193 0   43.0022601 -78.19135193 2022-07-15 04:20:53 Genesee, New York, US
3431206 3431206 2022-07-14 US New York Greene 36039 9603 134 0   42.275797 -74.12384884 2022-07-15 04:20:53 Greene, New York, US
3431207 3431207 2022-07-14 US New York Hamilton 36041 967 5 0   43.66146647 -74.49721957 2022-07-15 04:20:53 Hamilton, New York, US
3431208 3431208 2022-07-14 US New York Herkimer 36043 15433 197 0   43.42034246 -74.96145307 2022-07-15 04:20:53 Herkimer, New York, US
3431209 3431209 2022-07-14 US New York Jefferson 36045 22717 142 0   44.04200959 -75.94653457 2022-07-15 04:20:53 Jefferson, New York, US
3431210 3431210 2022-07-14 US New York Kings 36047 795517 13064 0   40.6361825 -73.94935552 2022-07-15 04:20:53 Kings, New York, US
3431211 3431211 2022-07-14 US New York Lewis 36049 6620 50 0   43.7844157 -75.44903992 2022-07-15 04:20:53 Lewis, New York, US
3431212 3431212 2022-07-14 US New York Livingston 36051 12847 121 0   42.72596275 -77.77966158 2022-07-15 04:20:53 Livingston, New York, US
3431213 3431213 2022-07-14 US New York Madison 36053 14834 129 0   42.91653905 -75.67266639 2022-07-15 04:20:53 Madison, New York, US
3431214 3431214 2022-07-14 US New York Monroe 36055 171365 1655 0   43.14638895 -77.69322942 2022-07-15 04:20:53 Monroe, New York, US
3431215 3431215 2022-07-14 US New York Montgomery 36057 13166 209 0   42.90123494 -74.44011632 2022-07-15 04:20:53 Montgomery, New York, US
3431216 3431216 2022-07-14 US New York Nassau 36059 464264 3928 0   40.74066522 -73.58941873 2022-07-15 04:20:53 Nassau, New York, US
3431217 3431217 2022-07-14 US New York New York 36061 494153 5567 0   40.7672726 -73.97152637 2022-07-15 04:20:53 New York, New York, US
3431218 3431218 2022-07-14 US New York Niagara 36063 53597 597 0   43.19898042 -78.74777412 2022-07-15 04:20:53 Niagara, New York, US
3431219 3431219 2022-07-14 US New York Oneida 36065 60849 819 0   43.24375382 -75.43710392 2022-07-15 04:20:53 Oneida, New York, US
3431220 3431220 2022-07-14 US New York Onondaga 36067 126306 1096 0   43.00491923 -76.19971155 2022-07-15 04:20:53 Onondaga, New York, US
3431221 3431221 2022-07-14 US New York Ontario 36069 22713 189 0   42.85145728 -77.30874425 2022-07-15 04:20:53 Ontario, New York, US
3431222 3431222 2022-07-14 US New York Orange 36071 124362 1182 0   41.40337468 -74.30240757 2022-07-15 04:20:53 Orange, New York, US
3431223 3431223 2022-07-14 US New York Orleans 36073 9471 119 0   43.2516977 -78.2320066 2022-07-15 04:20:53 Orleans, New York, US
3431224 3431224 2022-07-14 US New York Oswego 36075 29830 201 0   43.42778894 -76.14635194 2022-07-15 04:20:53 Oswego, New York, US
3431225 3431225 2022-07-14 US New York Otsego 36077 11474 94 0   42.63492579 -75.03151402 2022-07-15 04:20:53 Otsego, New York, US
3431226 3431226 2022-07-14 US New York Out of NY 80036 0 484 0   44.74530905 0.0 2022-07-15 04:20:53 Out of NY, New York, US
3431227 3431227 2022-07-14 US New York Putnam 36079 26923 125 0   41.42630093 -73.74965532 2022-07-15 04:20:53 Putnam, New York, US
3431228 3431228 2022-07-14 US New York Queens 36081 732544 12036 0   40.71088124 -73.81684712 2022-07-15 04:20:53 Queens, New York, US
3431229 3431229 2022-07-14 US New York Rensselaer 36083 36396 276 0   42.71348136 -73.51089874 2022-07-15 04:20:53 Rensselaer, New York, US
3431230 3431230 2022-07-14 US New York Richmond 36085 188090 2382 0   40.58582155 -74.14808598 2022-07-15 04:20:53 Richmond, New York, US
3431231 3431231 2022-07-14 US New York Rockland 36087 102397 911 0   41.15027894 -74.02560498 2022-07-15 04:20:53 Rockland, New York, US
3431232 3431232 2022-07-14 US New York Saratoga 36091 53589 349 0   43.10904162 -73.86653895 2022-07-15 04:20:53 Saratoga, New York, US
3431233 3431233 2022-07-14 US New York Schenectady 36093 38055 318 0   42.81668777 -74.05278291 2022-07-15 04:20:53 Schenectady, New York, US
3431234 3431234 2022-07-14 US New York Schoharie 36095 5657 36 0   42.58831742 -74.4433903 2022-07-15 04:20:53 Schoharie, New York, US
3431235 3431235 2022-07-14 US New York Schuyler 36097 3905 28 0   42.39184015 -76.8773299 2022-07-15 04:20:53 Schuyler, New York, US
3431236 3431236 2022-07-14 US New York Seneca 36099 6648 94 0   42.78081007 -76.82497064 2022-07-15 04:20:53 Seneca, New York, US
3431237 3431237 2022-07-14 US New York St. Lawrence 36089 23320 198 0   44.4976179 -75.06550039 2022-07-15 04:20:53 St. Lawrence, New York, US
3431238 3431238 2022-07-14 US New York Steuben 36101 22320 258 0   42.2689144 -77.3829924 2022-07-15 04:20:53 Steuben, New York, US
3431239 3431239 2022-07-14 US New York Suffolk 36103 480009 4493 0   40.88320119 -72.8012172 2022-07-15 04:20:53 Suffolk, New York, US
3431240 3431240 2022-07-14 US New York Sullivan 36105 20658 133 0   41.71579493 -74.76394559 2022-07-15 04:20:53 Sullivan, New York, US
3431241 3431241 2022-07-14 US New York Tioga 36107 12247 86 0   42.16852837 -76.30835812 2022-07-15 04:20:53 Tioga, New York, US
3431242 3431242 2022-07-14 US New York Tompkins 36109 22915 89 0   42.44945765 -76.47229843 2022-07-15 04:20:53 Tompkins, New York, US
3431243 3431243 2022-07-14 US New York Ulster 36111 36443 375 0   41.89027881 -74.26252104 2022-07-15 04:20:53 Ulster, New York, US
3431244 3431244 2022-07-14 US New York Unassigned 90036 895 2 0   44.74530905 0.0 2022-07-15 04:20:53 Unassigned, New York, US
3431245 3431245 2022-07-14 US New York Warren 36113 16014 131 0   43.56173026 -73.8433699 2022-07-15 04:20:53 Warren, New York, US
3431246 3431246 2022-07-14 US New York Washington 36115 13690 121 0   43.31153794 -73.43043448 2022-07-15 04:20:53 Washington, New York, US
3431247 3431247 2022-07-14 US New York Wayne 36117 19266 185 0   43.15494365 -77.02976528 2022-07-15 04:20:53 Wayne, New York, US
3431248 3431248 2022-07-14 US New York Westchester 36119 287373 2756 0   41.16278376 -73.75741653 2022-07-15 04:20:53 Westchester, New York, US
3431249 3431249 2022-07-14 US New York Wyoming 36121 9033 85 0   42.70145109 -78.22199579 2022-07-15 04:20:53 Wyoming, New York, US
3431250 3431250 2022-07-14 US New York Yates 36123 3874 40 0   42.63505484 -77.10369919 2022-07-15 04:20:53 Yates, New York, US

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] 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]);