ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Rankin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
deaths 227 ✖
- 282 35
- 278 28
- 6 26
- 86 20
- 12 15
- 1 13
- 2 13
- 10 13
- 277 11
- 271 10
- 405 10
- 401 9
- 5 8
- 408 8
- 23 7
- 80 7
- 89 7
- 265 7
- 275 7
- 284 7
- 397 7
- 407 7
- 0 6
- 274 6
- 384 6
- 390 6
- 400 6
- 409 6
- 417 6
- 423 6
- 9 5
- 69 5
- 83 5
- 285 5
- 294 5
- 301 5
- 388 5
- 392 5
- 402 5
- 418 5
- 422 5
- 4 4
- 8 4
- 15 4
- 28 4
- 79 4
- 88 4
- 243 4
- 258 4
- 272 4
- 280 4
- 286 4
- 322 4
- 345 4
- 20 3
- 47 3
- 63 3
- 72 3
- 73 3
- 75 3
- 77 3
- 90 3
- 96 3
- 103 3
- 143 3
- 156 3
- 217 3
- 253 3
- 264 3
- 269 3
- 276 3
- 287 3
- 290 3
- 291 3
- 312 3
- 329 3
- 358 3
- 370 3
- 381 3
- 387 3
- 404 3
- 7 2
- 19 2
- 21 2
- 22 2
- 27 2
- 32 2
- 35 2
- 38 2
- 41 2
- 42 2
- 44 2
- 71 2
- 102 2
- 116 2
- 117 2
- 129 2
- 163 2
- 171 2
- 211 2
- 257 2
- 266 2
- 267 2
- 279 2
- 281 2
- 319 2
- 366 2
- 414 2
- 419 2
- 13 1
- 25 1
- 30 1
- 31 1
- 33 1
- 34 1
- 43 1
- 45 1
- 54 1
- 59 1
- 60 1
- 61 1
- 62 1
- 65 1
- 66 1
- 70 1
- 74 1
- 76 1
- 82 1
- 84 1
- 91 1
- 93 1
- 94 1
- 95 1
- 98 1
- 100 1
- 106 1
- 107 1
- 112 1
- 114 1
- 115 1
- 118 1
- 122 1
- 128 1
- 132 1
- 136 1
- 140 1
- 142 1
- 149 1
- 155 1
- 157 1
- 161 1
- 165 1
- 168 1
- 169 1
- 175 1
- 178 1
- 179 1
- 180 1
- 186 1
- 187 1
- 189 1
- 195 1
- 201 1
- 204 1
- 205 1
- 208 1
- 212 1
- 219 1
- 220 1
- 221 1
- 223 1
- 225 1
- 227 1
- 228 1
- 231 1
- 232 1
- 235 1
- 237 1
- 240 1
- 242 1
- 246 1
- 248 1
- 249 1
- 252 1
- 254 1
- 260 1
- 261 1
- 262 1
- 263 1
- 273 1
- 289 1
- 292 1
- 293 1
- 297 1
- 299 1
- 303 1
- 309 1
- 310 1
- 311 1
- 314 1
- 320 1
- 324 1
- 327 1
- 328 1
- 338 1
- 339 1
- 343 1
- 349 1
- 354 1
- 355 1
- 357 1
- 360 1
- 368 1
- 373 1
- 377 1
- 379 1
- 380 1
- 382 1
- 386 1
- 391 1
- 394 1
- 403 1
- 406 1
- 415 1
- 428 1
- 439 1
- 443 1
state 1
- Mississippi 685
fips 1
- 28121 685
county 1
- Rankin · 685 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175671 | 2175671 | 2022-02-02 | Rankin | Mississippi | 28121 | 33904 | 443 |
2172418 | 2172418 | 2022-02-01 | Rankin | Mississippi | 28121 | 33560 | 439 |
2169165 | 2169165 | 2022-01-31 | Rankin | Mississippi | 28121 | 33409 | 428 |
2165910 | 2165910 | 2022-01-30 | Rankin | Mississippi | 28121 | 32794 | 423 |
2162655 | 2162655 | 2022-01-29 | Rankin | Mississippi | 28121 | 32794 | 423 |
2159400 | 2159400 | 2022-01-28 | Rankin | Mississippi | 28121 | 32794 | 423 |
2156146 | 2156146 | 2022-01-27 | Rankin | Mississippi | 28121 | 32530 | 423 |
2152893 | 2152893 | 2022-01-26 | Rankin | Mississippi | 28121 | 32216 | 423 |
2149641 | 2149641 | 2022-01-25 | Rankin | Mississippi | 28121 | 31866 | 423 |
2146389 | 2146389 | 2022-01-24 | Rankin | Mississippi | 28121 | 31648 | 422 |
2143134 | 2143134 | 2022-01-23 | Rankin | Mississippi | 28121 | 31081 | 422 |
2139879 | 2139879 | 2022-01-22 | Rankin | Mississippi | 28121 | 31081 | 422 |
2136623 | 2136623 | 2022-01-21 | Rankin | Mississippi | 28121 | 31081 | 422 |
2133371 | 2133371 | 2022-01-20 | Rankin | Mississippi | 28121 | 30545 | 422 |
2130118 | 2130118 | 2022-01-19 | Rankin | Mississippi | 28121 | 30112 | 419 |
2126864 | 2126864 | 2022-01-18 | Rankin | Mississippi | 28121 | 29759 | 419 |
2123612 | 2123612 | 2022-01-17 | Rankin | Mississippi | 28121 | 28534 | 418 |
2120360 | 2120360 | 2022-01-16 | Rankin | Mississippi | 28121 | 28534 | 418 |
2117108 | 2117108 | 2022-01-15 | Rankin | Mississippi | 28121 | 28534 | 418 |
2113857 | 2113857 | 2022-01-14 | Rankin | Mississippi | 28121 | 28534 | 418 |
2110605 | 2110605 | 2022-01-13 | Rankin | Mississippi | 28121 | 28282 | 418 |
2107354 | 2107354 | 2022-01-12 | Rankin | Mississippi | 28121 | 27986 | 417 |
2104103 | 2104103 | 2022-01-11 | Rankin | Mississippi | 28121 | 27687 | 417 |
2100852 | 2100852 | 2022-01-10 | Rankin | Mississippi | 28121 | 27526 | 417 |
2097601 | 2097601 | 2022-01-09 | Rankin | Mississippi | 28121 | 26485 | 417 |
2094349 | 2094349 | 2022-01-08 | Rankin | Mississippi | 28121 | 26485 | 417 |
2091097 | 2091097 | 2022-01-07 | Rankin | Mississippi | 28121 | 26485 | 417 |
2087846 | 2087846 | 2022-01-06 | Rankin | Mississippi | 28121 | 26205 | 415 |
2084594 | 2084594 | 2022-01-05 | Rankin | Mississippi | 28121 | 25943 | 414 |
2081342 | 2081342 | 2022-01-04 | Rankin | Mississippi | 28121 | 25681 | 414 |
2078090 | 2078090 | 2022-01-03 | Rankin | Mississippi | 28121 | 25481 | 409 |
2074839 | 2074839 | 2022-01-02 | Rankin | Mississippi | 28121 | 24292 | 409 |
2071588 | 2071588 | 2022-01-01 | Rankin | Mississippi | 28121 | 24292 | 409 |
2068337 | 2068337 | 2021-12-31 | Rankin | Mississippi | 28121 | 24292 | 409 |
2065086 | 2065086 | 2021-12-30 | Rankin | Mississippi | 28121 | 24292 | 409 |
2061836 | 2061836 | 2021-12-29 | Rankin | Mississippi | 28121 | 23980 | 409 |
2058587 | 2058587 | 2021-12-28 | Rankin | Mississippi | 28121 | 23735 | 408 |
2055338 | 2055338 | 2021-12-27 | Rankin | Mississippi | 28121 | 23618 | 408 |
2052088 | 2052088 | 2021-12-26 | Rankin | Mississippi | 28121 | 23104 | 408 |
2048838 | 2048838 | 2021-12-25 | Rankin | Mississippi | 28121 | 23104 | 408 |
2045588 | 2045588 | 2021-12-24 | Rankin | Mississippi | 28121 | 23104 | 408 |
2042338 | 2042338 | 2021-12-23 | Rankin | Mississippi | 28121 | 23104 | 408 |
2039089 | 2039089 | 2021-12-22 | Rankin | Mississippi | 28121 | 23104 | 408 |
2035839 | 2035839 | 2021-12-21 | Rankin | Mississippi | 28121 | 23030 | 408 |
2032589 | 2032589 | 2021-12-20 | Rankin | Mississippi | 28121 | 22990 | 407 |
2029338 | 2029338 | 2021-12-19 | Rankin | Mississippi | 28121 | 22891 | 407 |
2026087 | 2026087 | 2021-12-18 | Rankin | Mississippi | 28121 | 22891 | 407 |
2022836 | 2022836 | 2021-12-17 | Rankin | Mississippi | 28121 | 22891 | 407 |
2019585 | 2019585 | 2021-12-16 | Rankin | Mississippi | 28121 | 22801 | 407 |
2016335 | 2016335 | 2021-12-15 | Rankin | Mississippi | 28121 | 22765 | 407 |
2013084 | 2013084 | 2021-12-14 | Rankin | Mississippi | 28121 | 22740 | 407 |
2009833 | 2009833 | 2021-12-13 | Rankin | Mississippi | 28121 | 22731 | 406 |
2006582 | 2006582 | 2021-12-12 | Rankin | Mississippi | 28121 | 22699 | 405 |
2003331 | 2003331 | 2021-12-11 | Rankin | Mississippi | 28121 | 22699 | 405 |
2000081 | 2000081 | 2021-12-10 | Rankin | Mississippi | 28121 | 22699 | 405 |
1996830 | 1996830 | 2021-12-09 | Rankin | Mississippi | 28121 | 22688 | 405 |
1993579 | 1993579 | 2021-12-08 | Rankin | Mississippi | 28121 | 22635 | 405 |
1990328 | 1990328 | 2021-12-07 | Rankin | Mississippi | 28121 | 22621 | 405 |
1987078 | 1987078 | 2021-12-06 | Rankin | Mississippi | 28121 | 22593 | 405 |
1983828 | 1983828 | 2021-12-05 | Rankin | Mississippi | 28121 | 22565 | 405 |
1980578 | 1980578 | 2021-12-04 | Rankin | Mississippi | 28121 | 22565 | 405 |
1977328 | 1977328 | 2021-12-03 | Rankin | Mississippi | 28121 | 22565 | 405 |
1974078 | 1974078 | 2021-12-02 | Rankin | Mississippi | 28121 | 22553 | 404 |
1970829 | 1970829 | 2021-12-01 | Rankin | Mississippi | 28121 | 22521 | 404 |
1967579 | 1967579 | 2021-11-30 | Rankin | Mississippi | 28121 | 22516 | 404 |
1964327 | 1964327 | 2021-11-29 | Rankin | Mississippi | 28121 | 22507 | 403 |
1961076 | 1961076 | 2021-11-28 | Rankin | Mississippi | 28121 | 22442 | 402 |
1957825 | 1957825 | 2021-11-27 | Rankin | Mississippi | 28121 | 22442 | 402 |
1954574 | 1954574 | 2021-11-26 | Rankin | Mississippi | 28121 | 22442 | 402 |
1951323 | 1951323 | 2021-11-25 | Rankin | Mississippi | 28121 | 22442 | 402 |
1948072 | 1948072 | 2021-11-24 | Rankin | Mississippi | 28121 | 22442 | 402 |
1944821 | 1944821 | 2021-11-23 | Rankin | Mississippi | 28121 | 22424 | 401 |
1941570 | 1941570 | 2021-11-22 | Rankin | Mississippi | 28121 | 22419 | 401 |
1938320 | 1938320 | 2021-11-21 | Rankin | Mississippi | 28121 | 22386 | 401 |
1935070 | 1935070 | 2021-11-20 | Rankin | Mississippi | 28121 | 22386 | 401 |
1931820 | 1931820 | 2021-11-19 | Rankin | Mississippi | 28121 | 22386 | 401 |
1928569 | 1928569 | 2021-11-18 | Rankin | Mississippi | 28121 | 22375 | 401 |
1925319 | 1925319 | 2021-11-17 | Rankin | Mississippi | 28121 | 22374 | 401 |
1922070 | 1922070 | 2021-11-16 | Rankin | Mississippi | 28121 | 22367 | 401 |
1918820 | 1918820 | 2021-11-15 | Rankin | Mississippi | 28121 | 22360 | 401 |
1915570 | 1915570 | 2021-11-14 | Rankin | Mississippi | 28121 | 22322 | 400 |
1912320 | 1912320 | 2021-11-13 | Rankin | Mississippi | 28121 | 22322 | 400 |
1909070 | 1909070 | 2021-11-12 | Rankin | Mississippi | 28121 | 22322 | 400 |
1905821 | 1905821 | 2021-11-11 | Rankin | Mississippi | 28121 | 22302 | 400 |
1902572 | 1902572 | 2021-11-10 | Rankin | Mississippi | 28121 | 22302 | 400 |
1899322 | 1899322 | 2021-11-09 | Rankin | Mississippi | 28121 | 22294 | 400 |
1896072 | 1896072 | 2021-11-08 | Rankin | Mississippi | 28121 | 22290 | 397 |
1892822 | 1892822 | 2021-11-07 | Rankin | Mississippi | 28121 | 22271 | 397 |
1889572 | 1889572 | 2021-11-06 | Rankin | Mississippi | 28121 | 22271 | 397 |
1886322 | 1886322 | 2021-11-05 | Rankin | Mississippi | 28121 | 22271 | 397 |
1883073 | 1883073 | 2021-11-04 | Rankin | Mississippi | 28121 | 22234 | 397 |
1879824 | 1879824 | 2021-11-03 | Rankin | Mississippi | 28121 | 22230 | 397 |
1876575 | 1876575 | 2021-11-02 | Rankin | Mississippi | 28121 | 22178 | 397 |
1873326 | 1873326 | 2021-11-01 | Rankin | Mississippi | 28121 | 22162 | 394 |
1870077 | 1870077 | 2021-10-31 | Rankin | Mississippi | 28121 | 22137 | 392 |
1866828 | 1866828 | 2021-10-30 | Rankin | Mississippi | 28121 | 22137 | 392 |
1863579 | 1863579 | 2021-10-29 | Rankin | Mississippi | 28121 | 22137 | 392 |
1860330 | 1860330 | 2021-10-28 | Rankin | Mississippi | 28121 | 22117 | 392 |
1857081 | 1857081 | 2021-10-27 | Rankin | Mississippi | 28121 | 22110 | 392 |
1853832 | 1853832 | 2021-10-26 | Rankin | Mississippi | 28121 | 22103 | 391 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);