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)
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);