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

21,422 rows where province_or_state = "New York" sorted by day descending

View and edit SQL

province_or_state

  • New York · 21,422

country_or_region

  • US 21,422
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
906637 2021-03-03 US New York Albany 36001 20985 333 0 20652 42.60060306 -73.97723916 2021-03-04 05:24:24 Albany, New York, US
906638 2021-03-03 US New York Allegany 36003 2908 81 0 2827 42.25748406 -78.02750466 2021-03-04 05:24:24 Allegany, New York, US
906639 2021-03-03 US New York Bronx 36005 145809 5907 0 139902 40.85209301 -73.86282755 2021-03-04 05:24:24 Bronx, New York, US
906640 2021-03-03 US New York Broome 36007 15028 336 0 14692 42.15903158 -75.81326086 2021-03-04 05:24:24 Broome, New York, US
906641 2021-03-03 US New York Cattaraugus 36009 4448 76 0 4372 42.24778241 -78.67923096 2021-03-04 05:24:24 Cattaraugus, New York, US
906642 2021-03-03 US New York Cayuga 36011 5398 89 0 5309 42.91261714 -76.55731592 2021-03-04 05:24:24 Cayuga, New York, US
906643 2021-03-03 US New York Chautauqua 36013 7361 123 0 7238 42.22769210000001 -79.36691763 2021-03-04 05:24:24 Chautauqua, New York, US
906644 2021-03-03 US New York Chemung 36015 6453 130 0 6323 42.13891056 -76.7638805 2021-03-04 05:24:24 Chemung, New York, US
906645 2021-03-03 US New York Chenango 36017 2452 69 0 2383 42.49430041 -75.60887553 2021-03-04 05:24:24 Chenango, New York, US
906646 2021-03-03 US New York Clinton 36019 3682 26 0 3656 44.74530905 -73.67875352 2021-03-04 05:24:24 Clinton, New York, US
906647 2021-03-03 US New York Columbia 36021 3421 96 0 3325 42.24819348 -73.63089095 2021-03-04 05:24:24 Columbia, New York, US
906648 2021-03-03 US New York Cortland 36023 3178 60 0 3118 42.59509207 -76.07048931 2021-03-04 05:24:24 Cortland, New York, US
906649 2021-03-03 US New York Delaware 36025 1535 33 0 1502 42.19837623 -74.96709306 2021-03-04 05:24:24 Delaware, New York, US
906650 2021-03-03 US New York Dutchess 36027 22549 408 0 22141 41.76486060000001 -73.74356679 2021-03-04 05:24:24 Dutchess, New York, US
906651 2021-03-03 US New York Erie 36029 65789 1609 0 64180 42.76249024 -78.73063652 2021-03-04 05:24:24 Erie, New York, US
906652 2021-03-03 US New York Essex 36031 1352 26 0 1326 44.11630765 -73.77297842 2021-03-04 05:24:24 Essex, New York, US
906653 2021-03-03 US New York Franklin 36033 2107 12 0 2095 44.59040891 -74.29926032 2021-03-04 05:24:24 Franklin, New York, US
906654 2021-03-03 US New York Fulton 36035 3376 84 0 3292 43.11363907 -74.41798804 2021-03-04 05:24:24 Fulton, New York, US
906655 2021-03-03 US New York Genesee 36037 4435 118 0 4317 43.0022601 -78.19135193 2021-03-04 05:24:24 Genesee, New York, US
906656 2021-03-03 US New York Greene 36039 2670 71 0 2599 42.275797 -74.12384884 2021-03-04 05:24:24 Greene, New York, US
906657 2021-03-03 US New York Hamilton 36041 285 2 0 283 43.66146647 -74.49721957 2021-03-04 05:24:24 Hamilton, New York, US
906658 2021-03-03 US New York Herkimer 36043 4575 107 0 4468 43.42034246 -74.96145307 2021-03-04 05:24:24 Herkimer, New York, US
906659 2021-03-03 US New York Jefferson 36045 4836 63 0 4773 44.04200959 -75.94653457 2021-03-04 05:24:24 Jefferson, New York, US
906660 2021-03-03 US New York Kings 36047 213207 9172 0 204035 40.6361825 -73.94935552 2021-03-04 05:24:24 Kings, New York, US
906661 2021-03-03 US New York Lewis 36049 2074 30 0 2044 43.7844157 -75.44903992 2021-03-04 05:24:24 Lewis, New York, US
906662 2021-03-03 US New York Livingston 36051 3568 56 0 3512 42.72596275 -77.77966158 2021-03-04 05:24:24 Livingston, New York, US
906663 2021-03-03 US New York Madison 36053 3863 85 0 3778 42.91653905 -75.67266639 2021-03-04 05:24:24 Madison, New York, US
906664 2021-03-03 US New York Monroe 36055 52878 992 0 51886 43.14638895 -77.69322942 2021-03-04 05:24:24 Monroe, New York, US
906665 2021-03-03 US New York Montgomery 36057 3206 107 0 3099 42.90123494 -74.44011632 2021-03-04 05:24:24 Montgomery, New York, US
906666 2021-03-03 US New York Nassau 36059 149851 2930 0 146921 40.74066522 -73.58941873 2021-03-04 05:24:24 Nassau, New York, US
906667 2021-03-03 US New York New York 36061 104874 3940 0 100934 40.76727260000001 -73.97152637 2021-03-04 05:24:24 New York, New York, US
906668 2021-03-03 US New York Niagara 36063 15380 312 0 15068 43.19898042 -78.74777412 2021-03-04 05:24:24 Niagara, New York, US
906669 2021-03-03 US New York Oneida 36065 19793 480 0 19313 43.24375382 -75.43710392 2021-03-04 05:24:24 Oneida, New York, US
906670 2021-03-03 US New York Onondaga 36067 32562 634 0 31928 43.00491923 -76.19971155 2021-03-04 05:24:24 Onondaga, New York, US
906671 2021-03-03 US New York Ontario 36069 5839 89 0 5750 42.85145728 -77.30874425 2021-03-04 05:24:24 Ontario, New York, US
906672 2021-03-03 US New York Orange 36071 37441 720 0 36721 41.40337468 -74.30240757 2021-03-04 05:24:24 Orange, New York, US
906673 2021-03-03 US New York Orleans 36073 2456 81 0 2375 43.2516977 -78.2320066 2021-03-04 05:24:24 Orleans, New York, US
906674 2021-03-03 US New York Oswego 36075 6038 89 0 5949 43.42778894 -76.14635194 2021-03-04 05:24:24 Oswego, New York, US
906675 2021-03-03 US New York Otsego 36077 2373 43 0 2330 42.63492579 -75.03151402 2021-03-04 05:24:24 Otsego, New York, US
906676 2021-03-03 US New York Out of NY 80036 0 192 0 -192 44.74530905 0.0 2021-03-04 05:24:24 Out of NY, New York, US
906677 2021-03-03 US New York Putnam 36079 8418 86 0 8332 41.42630093 -73.74965532 2021-03-04 05:24:24 Putnam, New York, US
906678 2021-03-03 US New York Queens 36081 213800 8831 0 204969 40.71088124 -73.81684712 2021-03-04 05:24:24 Queens, New York, US
906679 2021-03-03 US New York Rensselaer 36083 9103 132 0 8971 42.71348136 -73.51089874 2021-03-04 05:24:24 Rensselaer, New York, US
906680 2021-03-03 US New York Richmond 36085 57617 1586 0 56031 40.58582155 -74.14808598 2021-03-04 05:24:24 Richmond, New York, US
906681 2021-03-03 US New York Rockland 36087 38955 891 0 38064 41.15027894 -74.02560498 2021-03-04 05:24:24 Rockland, New York, US
906682 2021-03-03 US New York Saratoga 36091 12052 145 0 11907 43.10904162 -73.86653895 2021-03-04 05:24:24 Saratoga, New York, US
906683 2021-03-03 US New York Schenectady 36093 10911 178 0 10733 42.81668777 -74.05278291 2021-03-04 05:24:24 Schenectady, New York, US
906684 2021-03-03 US New York Schoharie 36095 1223 13 0 1210 42.58831742 -74.44339029999998 2021-03-04 05:24:24 Schoharie, New York, US
906685 2021-03-03 US New York Schuyler 36097 869 12 0 857 42.39184015 -76.8773299 2021-03-04 05:24:24 Schuyler, New York, US
906686 2021-03-03 US New York Seneca 36099 1627 53 0 1574 42.78081007 -76.82497064 2021-03-04 05:24:24 Seneca, New York, US
906687 2021-03-03 US New York St. Lawrence 36089 5601 88 0 5513 44.4976179 -75.06550039 2021-03-04 05:24:24 St. Lawrence, New York, US
906688 2021-03-03 US New York Steuben 36101 5530 137 0 5393 42.2689144 -77.3829924 2021-03-04 05:24:24 Steuben, New York, US
906689 2021-03-03 US New York Suffolk 36103 163885 3102 0 160783 40.88320119 -72.8012172 2021-03-04 05:24:24 Suffolk, New York, US
906690 2021-03-03 US New York Sullivan 36105 4796 60 0 4736 41.71579493 -74.76394559 2021-03-04 05:24:24 Sullivan, New York, US
906691 2021-03-03 US New York Tioga 36107 2819 56 0 2763 42.16852837 -76.30835812 2021-03-04 05:24:24 Tioga, New York, US
906692 2021-03-03 US New York Tompkins 36109 3472 42 0 3430 42.44945765 -76.47229843 2021-03-04 05:24:24 Tompkins, New York, US
906693 2021-03-03 US New York Ulster 36111 10146 228 0 9918 41.89027881 -74.26252104 2021-03-04 05:24:24 Ulster, New York, US
906694 2021-03-03 US New York Unassigned 90036 191 128 0 63 44.74530905 0.0 2021-03-04 05:24:24 Unassigned, New York, US
906695 2021-03-03 US New York Warren 36113 2864 55 0 2809 43.56173026 -73.8433699 2021-03-04 05:24:24 Warren, New York, US
906696 2021-03-03 US New York Washington 36115 2360 52 0 2308 43.31153794 -73.43043448 2021-03-04 05:24:24 Washington, New York, US
906697 2021-03-03 US New York Wayne 36117 4495 65 0 4430 43.15494365 -77.02976528 2021-03-04 05:24:24 Wayne, New York, US
906698 2021-03-03 US New York Westchester 36119 108623 2109 0 106514 41.16278376 -73.75741653 2021-03-04 05:24:24 Westchester, New York, US
906699 2021-03-03 US New York Wyoming 36121 2841 49 0 2792 42.70145109 -78.22199579 2021-03-04 05:24:24 Wyoming, New York, US
906700 2021-03-03 US New York Yates 36123 1015 26 0 989 42.63505484 -77.10369919 2021-03-04 05:24:24 Yates, New York, US
69018 2021-03-02 US New York Albany 36001 20931 333 0 20598 42.60060306 -73.97723916 2021-03-03 05:23:28 Albany, New York, US
69019 2021-03-02 US New York Allegany 36003 2906 81 0 2825 42.25748406 -78.02750466 2021-03-03 05:23:28 Allegany, New York, US
69020 2021-03-02 US New York Bronx 36005 145226 5897 0 139329 40.85209301 -73.86282755 2021-03-03 05:23:28 Bronx, New York, US
69021 2021-03-02 US New York Broome 36007 14913 336 0 14577 42.15903158 -75.81326086 2021-03-03 05:23:28 Broome, New York, US
69022 2021-03-02 US New York Cattaraugus 36009 4433 76 0 4357 42.24778241 -78.67923096 2021-03-03 05:23:28 Cattaraugus, New York, US
69023 2021-03-02 US New York Cayuga 36011 5386 88 0 5298 42.91261714 -76.55731592 2021-03-03 05:23:28 Cayuga, New York, US
69024 2021-03-02 US New York Chautauqua 36013 7341 123 0 7218 42.22769210000001 -79.36691763 2021-03-03 05:23:28 Chautauqua, New York, US
69025 2021-03-02 US New York Chemung 36015 6445 130 0 6315 42.13891056 -76.7638805 2021-03-03 05:23:28 Chemung, New York, US
69026 2021-03-02 US New York Chenango 36017 2443 69 0 2374 42.49430041 -75.60887553 2021-03-03 05:23:28 Chenango, New York, US
69027 2021-03-02 US New York Clinton 36019 3645 26 0 3619 44.74530905 -73.67875352 2021-03-03 05:23:28 Clinton, New York, US
69028 2021-03-02 US New York Columbia 36021 3405 96 0 3309 42.24819348 -73.63089095 2021-03-03 05:23:28 Columbia, New York, US
69029 2021-03-02 US New York Cortland 36023 3172 60 0 3112 42.59509207 -76.07048931 2021-03-03 05:23:28 Cortland, New York, US
69030 2021-03-02 US New York Delaware 36025 1524 33 0 1491 42.19837623 -74.96709306 2021-03-03 05:23:28 Delaware, New York, US
69031 2021-03-02 US New York Dutchess 36027 22457 408 0 22049 41.76486060000001 -73.74356679 2021-03-03 05:23:28 Dutchess, New York, US
69032 2021-03-02 US New York Erie 36029 65571 1607 0 63964 42.76249024 -78.73063652 2021-03-03 05:23:28 Erie, New York, US
69033 2021-03-02 US New York Essex 36031 1347 26 0 1321 44.11630765 -73.77297842 2021-03-03 05:23:28 Essex, New York, US
69034 2021-03-02 US New York Franklin 36033 2098 12 0 2086 44.59040891 -74.29926032 2021-03-03 05:23:28 Franklin, New York, US
69035 2021-03-02 US New York Fulton 36035 3351 84 0 3267 43.11363907 -74.41798804 2021-03-03 05:23:28 Fulton, New York, US
69036 2021-03-02 US New York Genesee 36037 4420 118 0 4302 43.0022601 -78.19135193 2021-03-03 05:23:28 Genesee, New York, US
69037 2021-03-02 US New York Greene 36039 2650 71 0 2579 42.275797 -74.12384884 2021-03-03 05:23:28 Greene, New York, US
69038 2021-03-02 US New York Hamilton 36041 285 2 0 283 43.66146647 -74.49721957 2021-03-03 05:23:28 Hamilton, New York, US
69039 2021-03-02 US New York Herkimer 36043 4568 107 0 4461 43.42034246 -74.96145307 2021-03-03 05:23:28 Herkimer, New York, US
69040 2021-03-02 US New York Jefferson 36045 4816 63 0 4753 44.04200959 -75.94653457 2021-03-03 05:23:28 Jefferson, New York, US
69041 2021-03-02 US New York Kings 36047 212124 9144 0 202980 40.6361825 -73.94935552 2021-03-03 05:23:28 Kings, New York, US
69042 2021-03-02 US New York Lewis 36049 2073 30 0 2043 43.7844157 -75.44903992 2021-03-03 05:23:28 Lewis, New York, US
69043 2021-03-02 US New York Livingston 36051 3558 56 0 3502 42.72596275 -77.77966158 2021-03-03 05:23:28 Livingston, New York, US
69044 2021-03-02 US New York Madison 36053 3854 85 0 3769 42.91653905 -75.67266639 2021-03-03 05:23:28 Madison, New York, US
69045 2021-03-02 US New York Monroe 36055 52759 992 0 51767 43.14638895 -77.69322942 2021-03-03 05:23:28 Monroe, New York, US
69046 2021-03-02 US New York Montgomery 36057 3199 107 0 3092 42.90123494 -74.44011632 2021-03-03 05:23:28 Montgomery, New York, US
69047 2021-03-02 US New York Nassau 36059 149251 2926 0 146325 40.74066522 -73.58941873 2021-03-03 05:23:28 Nassau, New York, US
69048 2021-03-02 US New York New York 36061 104444 3917 0 100527 40.76727260000001 -73.97152637 2021-03-03 05:23:28 New York, New York, US
69049 2021-03-02 US New York Niagara 36063 15351 312 0 15039 43.19898042 -78.74777412 2021-03-03 05:23:28 Niagara, New York, US
69050 2021-03-02 US New York Oneida 36065 19763 478 0 19285 43.24375382 -75.43710392 2021-03-03 05:23:28 Oneida, New York, US
69051 2021-03-02 US New York Onondaga 36067 32489 634 0 31855 43.00491923 -76.19971155 2021-03-03 05:23:28 Onondaga, New York, US
69052 2021-03-02 US New York Ontario 36069 5813 88 0 5725 42.85145728 -77.30874425 2021-03-03 05:23:28 Ontario, New York, US
69053 2021-03-02 US New York Orange 36071 37232 720 0 36512 41.40337468 -74.30240757 2021-03-03 05:23:28 Orange, 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]);