latest_ny_times_counties_with_populations (view)

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 license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

57 rows where state = "New York" sorted by cases_per_million descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • New York · 57 ✖
date county state fips cases deaths population deaths_per_million cases_per_million ▲
2022-05-13 Nassau New York 36059 425386 3853 1356924 2839 313492
2022-05-13 Suffolk New York 36103 444799 4399 1476601 2979 301231
2022-05-13 Rockland New York 36087 96142 897 325789 2753 295105
2022-05-13 Orange New York 36071 111228 954 384940 2478 288948
2022-05-13 Westchester New York 36119 264447 2720 967506 2811 273328
2022-05-13 Chemung New York 36015 22603 233 83456 2791 270837
2022-05-13 Onondaga New York 36067 121727 1073 460528 2329 264320
2022-05-13 Broome New York 36007 48947 520 190488 2729 256955
2022-05-13 Oneida New York 36065 58360 803 228671 3511 255213
2022-05-13 Sullivan New York 36105 19217 130 75432 1723 254759
2022-05-13 Montgomery New York 36057 12471 205 49221 4164 253367
2022-05-13 Putnam New York 36079 24875 125 98320 1271 253000
2022-05-13 Fulton New York 36035 13428 169 53383 3165 251540
2022-05-13 Genesee New York 36037 14395 187 57280 3264 251309
2022-05-13 Erie New York 36029 227059 2651 918702 2885 247151
2022-05-13 Oswego New York 36075 28826 194 117124 1656 246115
2022-05-13 Lewis New York 36049 6417 49 26296 1863 244029
2022-05-13 Niagara New York 36063 51069 585 209281 2795 244021
2022-05-13 Tioga New York 36107 11719 85 48203 1763 243117
2022-05-13 Herkimer New York 36043 14827 193 61319 3147 241801
2022-05-13 Cortland New York 36023 11365 120 47581 2522 238855
2022-05-13 Warren New York 36113 14739 129 63944 2017 230498
2022-05-13 Dutchess New York 36027 66962 659 294218 2239 227593
2022-05-13 Schenectady New York 36093 35317 305 155299 1963 227412
2022-05-13 Cayuga New York 36011 17375 152 76576 1984 226898
2022-05-13 Orleans New York 36073 9116 117 40352 2899 225911
2022-05-13 Clinton New York 36019 18034 90 80485 1118 224066
2022-05-13 Steuben New York 36101 21216 253 95379 2652 222438
2022-05-13 Monroe New York 36055 163464 1587 741770 2139 220370
2022-05-13 Wyoming New York 36121 8692 84 39859 2107 218068
2022-05-13 Saratoga New York 36091 49890 335 229863 1457 217042
2022-05-13 Rensselaer New York 36083 33850 259 158714 1631 213276
2022-05-13 Cattaraugus New York 36009 16113 222 76117 2916 211687
2022-05-13 Washington New York 36115 12875 115 61204 1878 210362
2022-05-13 Schuyler New York 36097 3724 25 17807 1403 209131
2022-05-13 Chenango New York 36017 9858 121 47207 2563 208824
2022-05-13 St. Lawrence New York 36089 22454 191 107740 1772 208409
2022-05-13 Hamilton New York 36041 919 5 4416 1132 208106
2022-05-13 Albany New York 36001 63461 523 305506 1711 207724
2022-05-13 Tompkins New York 36109 21144 85 102180 831 206928
2022-05-13 Wayne New York 36117 18503 179 89918 1990 205776
2022-05-13 Madison New York 36053 14319 127 70941 1790 201843
2022-05-13 Allegany New York 36003 9275 155 46091 3362 201232
2022-05-13 Franklin New York 36033 10059 46 50022 919 201091
2022-05-13 Ontario New York 36069 21586 180 109777 1639 196634
2022-05-13 Livingston New York 36051 12324 118 62914 1875 195886
2022-05-13 Jefferson New York 36045 21422 138 109834 1256 195039
2022-05-13 Chautauqua New York 36013 24556 302 126903 2379 193502
2022-05-13 Greene New York 36039 9055 130 47188 2754 191892
2022-05-13 Ulster New York 36111 33856 365 177573 2055 190659
2022-05-13 Seneca New York 36099 6391 91 34016 2675 187882
2022-05-13 Delaware New York 36025 8261 72 44135 1631 187175
2022-05-13 Columbia New York 36021 10772 141 59461 2371 181160
2022-05-13 Otsego New York 36077 10667 88 59493 1479 179298
2022-05-13 Schoharie New York 36095 5336 36 30999 1161 172134
2022-05-13 Essex New York 36031 6124 61 36885 1653 166029
2022-05-13 Yates New York 36123 3704 40 24913 1605 148677

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW latest_ny_times_counties_with_populations AS 
    select
      ny_times_us_counties.date,
      ny_times_us_counties.county,
      ny_times_us_counties.state,
      ny_times_us_counties.fips,
      ny_times_us_counties.cases,
      ny_times_us_counties.deaths,
      us_census_county_populations_2019.population,
      1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million,
      1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million
    from
      ny_times_us_counties
      join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips
    where
      "date" = (
        select
          max(date)
        from
          ny_times_us_counties
      )
    order by
      deaths_per_million desc;