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

77 rows where state = "Oklahoma" 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

  • Oklahoma · 77 ✖
date county state fips cases deaths population deaths_per_million cases_per_million ▲
2022-05-13 Adair Oklahoma 40001 8001 75 22194 3379 360502
2022-05-13 Craig Oklahoma 40035 4785 55 14142 3889 338353
2022-05-13 Major Oklahoma 40093 2461 41 7629 5374 322584
2022-05-13 Pontotoc Oklahoma 40123 12132 150 38284 3918 316894
2022-05-13 Coal Oklahoma 40029 1672 24 5495 4367 304276
2022-05-13 Love Oklahoma 40085 3109 39 10253 3803 303228
2022-05-13 Alfalfa Oklahoma 40003 1716 15 5702 2630 300947
2022-05-13 Texas Oklahoma 40139 5996 54 19983 2702 300055
2022-05-13 Cherokee Oklahoma 40021 14532 151 48657 3103 298662
2022-05-13 Carter Oklahoma 40019 14366 239 48111 4967 298601
2022-05-13 Murray Oklahoma 40099 4165 77 14073 5471 295956
2022-05-13 Ottawa Oklahoma 40115 9204 127 31127 4080 295691
2022-05-13 Okfuskee Oklahoma 40107 3533 62 11993 5169 294588
2022-05-13 Muskogee Oklahoma 40101 19987 348 67997 5117 293939
2022-05-13 McClain Oklahoma 40087 11773 137 40474 3384 290878
2022-05-13 Caddo Oklahoma 40015 8278 171 28762 5945 287810
2022-05-13 Pottawatomie Oklahoma 40125 20703 284 72592 3912 285196
2022-05-13 Bryan Oklahoma 40013 13672 136 47995 2833 284863
2022-05-13 Atoka Oklahoma 40005 3911 54 13758 3924 284270
2022-05-13 Kay Oklahoma 40071 12327 216 43538 4961 283131
2022-05-13 Cleveland Oklahoma 40027 79713 822 284014 2894 280665
2022-05-13 Choctaw Oklahoma 40023 4056 64 14672 4362 276444
2022-05-13 Nowata Oklahoma 40105 2785 40 10076 3969 276399
2022-05-13 Rogers Oklahoma 40131 25476 389 92459 4207 275538
2022-05-13 Comanche Oklahoma 40031 33173 397 120749 3287 274726
2022-05-13 Johnston Oklahoma 40069 3041 54 11085 4871 274334
2022-05-13 Noble Oklahoma 40103 3050 39 11131 3503 274009
2022-05-13 Beckham Oklahoma 40009 5983 106 21859 4849 273708
2022-05-13 Custer Oklahoma 40039 7935 169 29003 5826 273592
2022-05-13 Marshall Oklahoma 40095 4603 46 16931 2716 271868
2022-05-13 Wagoner Oklahoma 40145 21915 277 81289 3407 269593
2022-05-13 Canadian Oklahoma 40017 39889 390 148306 2629 268964
2022-05-13 Jackson Oklahoma 40065 6575 108 24530 4402 268039
2022-05-13 Woods Oklahoma 40151 2352 38 8793 4321 267485
2022-05-13 Kingfisher Oklahoma 40073 4178 71 15765 4503 265017
2022-05-13 Tulsa Oklahoma 40143 172585 2183 651552 3350 264882
2022-05-13 Cimarron Oklahoma 40025 566 7 2137 3275 264857
2022-05-13 Stephens Oklahoma 40137 11374 205 43143 4751 263634
2022-05-13 Blaine Oklahoma 40011 2461 43 9429 4560 261003
2022-05-13 Cotton Oklahoma 40033 1464 29 5666 5118 258383
2022-05-13 Delaware Oklahoma 40041 11098 203 43009 4719 258039
2022-05-13 Sequoyah Oklahoma 40135 10639 106 41569 2549 255935
2022-05-13 Woodward Oklahoma 40153 5172 76 20211 3760 255900
2022-05-13 Creek Oklahoma 40037 18245 338 71522 4725 255096
2022-05-13 Garvin Oklahoma 40049 7068 148 27711 5340 255061
2022-05-13 Seminole Oklahoma 40133 6142 135 24258 5565 253194
2022-05-13 Mayes Oklahoma 40097 10399 163 41100 3965 253017
2022-05-13 Okmulgee Oklahoma 40111 9686 188 38465 4887 251813
2022-05-13 Pawnee Oklahoma 40117 4121 85 16376 5190 251648
2022-05-13 Le Flore Oklahoma 40079 12521 107 49853 2146 251158
2022-05-13 Oklahoma Oklahoma 40109 199990 2467 797434 3093 250791
2022-05-13 Garfield Oklahoma 40047 15233 295 61056 4831 249492
2022-05-13 Roger Mills Oklahoma 40129 892 16 3583 4465 248953
2022-05-13 McIntosh Oklahoma 40091 4864 124 19596 6327 248213
2022-05-13 McCurtain Oklahoma 40089 8117 166 32832 5056 247228
2022-05-13 Pittsburg Oklahoma 40121 10780 211 43654 4833 246941
2022-05-13 Washington Oklahoma 40147 12718 262 51527 5084 246822
2022-05-13 Grady Oklahoma 40051 13773 246 55834 4405 246677
2022-05-13 Washita Oklahoma 40149 2639 54 10916 4946 241755
2022-05-13 Pushmataha Oklahoma 40127 2677 45 11096 4055 241258
2022-05-13 Grant Oklahoma 40053 1036 16 4333 3692 239095
2022-05-13 Osage Oklahoma 40113 10965 167 46963 3555 233481
2022-05-13 Logan Oklahoma 40083 10911 160 48011 3332 227260
2022-05-13 Greer Oklahoma 40055 1296 37 5712 6477 226890
2022-05-13 Lincoln Oklahoma 40081 7897 140 34877 4014 226424
2022-05-13 Payne Oklahoma 40119 18463 166 81784 2029 225753
2022-05-13 Kiowa Oklahoma 40075 1965 52 8708 5971 225654
2022-05-13 Latimer Oklahoma 40077 2273 35 10073 3474 225652
2022-05-13 Jefferson Oklahoma 40067 1339 27 6002 4498 223092
2022-05-13 Haskell Oklahoma 40061 2796 41 12627 3247 221430
2022-05-13 Dewey Oklahoma 40043 1064 32 4891 6542 217542
2022-05-13 Tillman Oklahoma 40141 1532 35 7250 4827 211310
2022-05-13 Ellis Oklahoma 40045 774 8 3859 2073 200570
2022-05-13 Harmon Oklahoma 40057 522 12 2653 4523 196758
2022-05-13 Hughes Oklahoma 40063 2586 62 13279 4669 194743
2022-05-13 Harper Oklahoma 40059 714 12 3688 3253 193600
2022-05-13 Beaver Oklahoma 40007 969 11 5311 2071 182451

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;