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

82 rows where state = "Mississippi" 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

  • Mississippi · 82 ✖
date county state fips cases deaths population deaths_per_million cases_per_million ▲
2022-05-13 Covington Mississippi 28031 7086 113 18636 6063 380231
2022-05-13 Neshoba Mississippi 28099 10622 241 29118 8276 364791
2022-05-13 Webster Mississippi 28155 3388 70 9689 7224 349674
2022-05-13 Yalobusha Mississippi 28161 4114 57 12108 4707 339775
2022-05-13 Tippah Mississippi 28139 7361 109 22015 4951 334362
2022-05-13 Union Mississippi 28145 9487 122 28815 4233 329238
2022-05-13 Prentiss Mississippi 28117 8245 103 25126 4099 328146
2022-05-13 Chickasaw Mississippi 28017 5603 96 17103 5613 327603
2022-05-13 Calhoun Mississippi 28013 4641 71 14361 4943 323166
2022-05-13 Pontotoc Mississippi 28115 10364 145 32174 4506 322123
2022-05-13 Tishomingo Mississippi 28141 6172 122 19383 6294 318423
2022-05-13 Itawamba Mississippi 28057 7430 144 23390 6156 317657
2022-05-13 Lee Mississippi 28081 26783 301 85436 3523 313486
2022-05-13 Monroe Mississippi 28095 10997 220 35252 6240 311953
2022-05-13 Jones Mississippi 28067 21234 295 68098 4331 311815
2022-05-13 Panola Mississippi 28107 10566 169 34192 4942 309019
2022-05-13 Bolivar Mississippi 28011 9354 179 30628 5844 305406
2022-05-13 Montgomery Mississippi 28097 2963 77 9775 7877 303120
2022-05-13 Jasper Mississippi 28061 4943 75 16383 4577 301715
2022-05-13 Lowndes Mississippi 28087 17528 238 58595 4061 299138
2022-05-13 Wayne Mississippi 28153 6008 87 20183 4310 297676
2022-05-13 Stone Mississippi 28131 5409 71 18336 3872 294993
2022-05-13 Attala Mississippi 28007 5361 113 18174 6217 294981
2022-05-13 Forrest Mississippi 28035 22076 315 74897 4205 294751
2022-05-13 Coahoma Mississippi 28027 6486 126 22124 5695 293165
2022-05-13 George Mississippi 28039 7163 87 24500 3551 292367
2022-05-13 Winston Mississippi 28159 5231 104 17955 5792 291339
2022-05-13 Newton Mississippi 28101 6059 98 21018 4662 288276
2022-05-13 Lawrence Mississippi 28077 3590 56 12586 4449 285237
2022-05-13 Lafayette Mississippi 28071 15364 179 54019 3313 284418
2022-05-13 Marion Mississippi 28091 6974 135 24573 5493 283807
2022-05-13 Choctaw Mississippi 28019 2318 33 8210 4019 282338
2022-05-13 Leake Mississippi 28079 6427 120 22786 5266 282059
2022-05-13 Marshall Mississippi 28093 9941 174 35294 4930 281662
2022-05-13 Lamar Mississippi 28073 17441 160 63343 2525 275342
2022-05-13 Benton Mississippi 28009 2274 49 8259 5932 275335
2022-05-13 Pearl River Mississippi 28109 15151 275 55535 4951 272818
2022-05-13 Alcorn Mississippi 28003 10080 160 36953 4329 272778
2022-05-13 Clarke Mississippi 28023 4239 108 15541 6949 272762
2022-05-13 DeSoto Mississippi 28033 50344 554 184945 2995 272210
2022-05-13 Yazoo Mississippi 28163 8054 107 29690 3603 271269
2022-05-13 Grenada Mississippi 28043 5533 131 20758 6310 266547
2022-05-13 Tunica Mississippi 28143 2559 48 9632 4983 265676
2022-05-13 Amite Mississippi 28005 3259 69 12297 5611 265023
2022-05-13 Simpson Mississippi 28127 7026 149 26658 5589 263560
2022-05-13 Noxubee Mississippi 28103 2730 48 10417 4607 262071
2022-05-13 Holmes Mississippi 28051 4455 104 17010 6114 261904
2022-05-13 Tate Mississippi 28137 7396 143 28321 5049 261148
2022-05-13 Leflore Mississippi 28083 7326 169 28183 5996 259943
2022-05-13 Copiah Mississippi 28029 7287 121 28065 4311 259647
2022-05-13 Smith Mississippi 28129 4127 68 15916 4272 259298
2022-05-13 Harrison Mississippi 28047 53859 665 208080 3195 258837
2022-05-13 Jackson Mississippi 28059 37055 463 143617 3223 258012
2022-05-13 Carroll Mississippi 28015 2565 54 9947 5428 257866
2022-05-13 Hancock Mississippi 28045 12277 152 47632 3191 257746
2022-05-13 Clay Mississippi 28025 4974 98 19316 5073 257506
2022-05-13 Jefferson Davis Mississippi 28065 2865 53 11128 4762 257458
2022-05-13 Lauderdale Mississippi 28075 18898 367 74125 4951 254947
2022-05-13 Perry Mississippi 28111 3048 64 11973 5345 254572
2022-05-13 Walthall Mississippi 28147 3622 79 14286 5529 253534
2022-05-13 Humphreys Mississippi 28053 2030 46 8064 5704 251736
2022-05-13 Franklin Mississippi 28037 1927 38 7713 4926 249837
2022-05-13 Pike Mississippi 28113 9751 189 39288 4810 248192
2022-05-13 Lincoln Mississippi 28085 8324 157 34153 4596 243726
2022-05-13 Claiborne Mississippi 28021 2152 46 8988 5117 239430
2022-05-13 Washington Mississippi 28151 10470 199 43909 4532 238447
2022-05-13 Rankin Mississippi 28121 36738 489 155271 3149 236605
2022-05-13 Greene Mississippi 28041 3198 59 13586 4342 235389
2022-05-13 Adams Mississippi 28001 7224 143 30693 4659 235363
2022-05-13 Scott Mississippi 28123 6559 119 28124 4231 233217
2022-05-13 Quitman Mississippi 28119 1579 31 6792 4564 232479
2022-05-13 Tallahatchie Mississippi 28135 3203 60 13809 4344 231950
2022-05-13 Sunflower Mississippi 28133 5773 125 25110 4978 229908
2022-05-13 Madison Mississippi 28089 24189 329 106272 3095 227614
2022-05-13 Hinds Mississippi 28049 52682 791 231840 3411 227234
2022-05-13 Warren Mississippi 28149 10250 202 45381 4451 225865
2022-05-13 Kemper Mississippi 28069 2187 48 9742 4927 224491
2022-05-13 Oktibbeha Mississippi 28105 11127 162 49587 3266 224393
2022-05-13 Sharkey Mississippi 28125 953 26 4321 6017 220550
2022-05-13 Jefferson Mississippi 28063 1494 37 6990 5293 213733
2022-05-13 Wilkinson Mississippi 28157 1804 46 8630 5330 209038
2022-05-13 Issaquena Mississippi 28055 262 9 1327 6782 197437

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;