ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Harrison" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110568 | 2110568 | 2022-01-13 | Harrison | Mississippi | 28047 | 40700 | 572 |
2107317 | 2107317 | 2022-01-12 | Harrison | Mississippi | 28047 | 40147 | 572 |
2104066 | 2104066 | 2022-01-11 | Harrison | Mississippi | 28047 | 39720 | 571 |
2100815 | 2100815 | 2022-01-10 | Harrison | Mississippi | 28047 | 39356 | 571 |
2097564 | 2097564 | 2022-01-09 | Harrison | Mississippi | 28047 | 38403 | 571 |
2094312 | 2094312 | 2022-01-08 | Harrison | Mississippi | 28047 | 38403 | 571 |
2091060 | 2091060 | 2022-01-07 | Harrison | Mississippi | 28047 | 38403 | 571 |
2087809 | 2087809 | 2022-01-06 | Harrison | Mississippi | 28047 | 37914 | 569 |
2084557 | 2084557 | 2022-01-05 | Harrison | Mississippi | 28047 | 37544 | 569 |
2081305 | 2081305 | 2022-01-04 | Harrison | Mississippi | 28047 | 37028 | 569 |
2078053 | 2078053 | 2022-01-03 | Harrison | Mississippi | 28047 | 36758 | 567 |
2074802 | 2074802 | 2022-01-02 | Harrison | Mississippi | 28047 | 35987 | 567 |
2071551 | 2071551 | 2022-01-01 | Harrison | Mississippi | 28047 | 35987 | 567 |
2068300 | 2068300 | 2021-12-31 | Harrison | Mississippi | 28047 | 35987 | 567 |
2065049 | 2065049 | 2021-12-30 | Harrison | Mississippi | 28047 | 35987 | 567 |
2061799 | 2061799 | 2021-12-29 | Harrison | Mississippi | 28047 | 35825 | 567 |
2058550 | 2058550 | 2021-12-28 | Harrison | Mississippi | 28047 | 35682 | 567 |
2055301 | 2055301 | 2021-12-27 | Harrison | Mississippi | 28047 | 35565 | 565 |
2052051 | 2052051 | 2021-12-26 | Harrison | Mississippi | 28047 | 35351 | 565 |
2048801 | 2048801 | 2021-12-25 | Harrison | Mississippi | 28047 | 35351 | 565 |
2045551 | 2045551 | 2021-12-24 | Harrison | Mississippi | 28047 | 35351 | 565 |
2042301 | 2042301 | 2021-12-23 | Harrison | Mississippi | 28047 | 35351 | 565 |
2039052 | 2039052 | 2021-12-22 | Harrison | Mississippi | 28047 | 35351 | 565 |
2035802 | 2035802 | 2021-12-21 | Harrison | Mississippi | 28047 | 35323 | 565 |
2032552 | 2032552 | 2021-12-20 | Harrison | Mississippi | 28047 | 35313 | 563 |
2029301 | 2029301 | 2021-12-19 | Harrison | Mississippi | 28047 | 35254 | 562 |
2026050 | 2026050 | 2021-12-18 | Harrison | Mississippi | 28047 | 35254 | 562 |
2022799 | 2022799 | 2021-12-17 | Harrison | Mississippi | 28047 | 35254 | 562 |
2019548 | 2019548 | 2021-12-16 | Harrison | Mississippi | 28047 | 35236 | 561 |
2016298 | 2016298 | 2021-12-15 | Harrison | Mississippi | 28047 | 35207 | 561 |
2013047 | 2013047 | 2021-12-14 | Harrison | Mississippi | 28047 | 35187 | 561 |
2009796 | 2009796 | 2021-12-13 | Harrison | Mississippi | 28047 | 35175 | 560 |
2006545 | 2006545 | 2021-12-12 | Harrison | Mississippi | 28047 | 35150 | 560 |
2003294 | 2003294 | 2021-12-11 | Harrison | Mississippi | 28047 | 35150 | 560 |
2000044 | 2000044 | 2021-12-10 | Harrison | Mississippi | 28047 | 35150 | 560 |
1996793 | 1996793 | 2021-12-09 | Harrison | Mississippi | 28047 | 35135 | 560 |
1993542 | 1993542 | 2021-12-08 | Harrison | Mississippi | 28047 | 35122 | 559 |
1990291 | 1990291 | 2021-12-07 | Harrison | Mississippi | 28047 | 35086 | 559 |
1987041 | 1987041 | 2021-12-06 | Harrison | Mississippi | 28047 | 35042 | 558 |
1983791 | 1983791 | 2021-12-05 | Harrison | Mississippi | 28047 | 34999 | 558 |
1980541 | 1980541 | 2021-12-04 | Harrison | Mississippi | 28047 | 34999 | 558 |
1977291 | 1977291 | 2021-12-03 | Harrison | Mississippi | 28047 | 34999 | 558 |
1974041 | 1974041 | 2021-12-02 | Harrison | Mississippi | 28047 | 34981 | 557 |
1970792 | 1970792 | 2021-12-01 | Harrison | Mississippi | 28047 | 34949 | 557 |
1967542 | 1967542 | 2021-11-30 | Harrison | Mississippi | 28047 | 34920 | 557 |
1964290 | 1964290 | 2021-11-29 | Harrison | Mississippi | 28047 | 34892 | 556 |
1961039 | 1961039 | 2021-11-28 | Harrison | Mississippi | 28047 | 34853 | 555 |
1957788 | 1957788 | 2021-11-27 | Harrison | Mississippi | 28047 | 34853 | 555 |
1954537 | 1954537 | 2021-11-26 | Harrison | Mississippi | 28047 | 34853 | 555 |
1951286 | 1951286 | 2021-11-25 | Harrison | Mississippi | 28047 | 34853 | 555 |
1948035 | 1948035 | 2021-11-24 | Harrison | Mississippi | 28047 | 34853 | 555 |
1944784 | 1944784 | 2021-11-23 | Harrison | Mississippi | 28047 | 34825 | 554 |
1941533 | 1941533 | 2021-11-22 | Harrison | Mississippi | 28047 | 34806 | 553 |
1938283 | 1938283 | 2021-11-21 | Harrison | Mississippi | 28047 | 34758 | 553 |
1935033 | 1935033 | 2021-11-20 | Harrison | Mississippi | 28047 | 34758 | 553 |
1931783 | 1931783 | 2021-11-19 | Harrison | Mississippi | 28047 | 34758 | 553 |
1928532 | 1928532 | 2021-11-18 | Harrison | Mississippi | 28047 | 34724 | 552 |
1925282 | 1925282 | 2021-11-17 | Harrison | Mississippi | 28047 | 34694 | 552 |
1922033 | 1922033 | 2021-11-16 | Harrison | Mississippi | 28047 | 34679 | 552 |
1918783 | 1918783 | 2021-11-15 | Harrison | Mississippi | 28047 | 34667 | 552 |
1915533 | 1915533 | 2021-11-14 | Harrison | Mississippi | 28047 | 34641 | 552 |
1912283 | 1912283 | 2021-11-13 | Harrison | Mississippi | 28047 | 34641 | 552 |
1909033 | 1909033 | 2021-11-12 | Harrison | Mississippi | 28047 | 34641 | 552 |
1905784 | 1905784 | 2021-11-11 | Harrison | Mississippi | 28047 | 34617 | 551 |
1902535 | 1902535 | 2021-11-10 | Harrison | Mississippi | 28047 | 34617 | 551 |
1899285 | 1899285 | 2021-11-09 | Harrison | Mississippi | 28047 | 34599 | 551 |
1896035 | 1896035 | 2021-11-08 | Harrison | Mississippi | 28047 | 34582 | 549 |
1892785 | 1892785 | 2021-11-07 | Harrison | Mississippi | 28047 | 34563 | 548 |
1889535 | 1889535 | 2021-11-06 | Harrison | Mississippi | 28047 | 34563 | 548 |
1886285 | 1886285 | 2021-11-05 | Harrison | Mississippi | 28047 | 34563 | 548 |
1883036 | 1883036 | 2021-11-04 | Harrison | Mississippi | 28047 | 34531 | 546 |
1879787 | 1879787 | 2021-11-03 | Harrison | Mississippi | 28047 | 34498 | 546 |
1876538 | 1876538 | 2021-11-02 | Harrison | Mississippi | 28047 | 34485 | 546 |
1873289 | 1873289 | 2021-11-01 | Harrison | Mississippi | 28047 | 34465 | 543 |
1870040 | 1870040 | 2021-10-31 | Harrison | Mississippi | 28047 | 34446 | 542 |
1866791 | 1866791 | 2021-10-30 | Harrison | Mississippi | 28047 | 34446 | 542 |
1863542 | 1863542 | 2021-10-29 | Harrison | Mississippi | 28047 | 34446 | 542 |
1860293 | 1860293 | 2021-10-28 | Harrison | Mississippi | 28047 | 34445 | 541 |
1857044 | 1857044 | 2021-10-27 | Harrison | Mississippi | 28047 | 34423 | 541 |
1853795 | 1853795 | 2021-10-26 | Harrison | Mississippi | 28047 | 34400 | 541 |
1850546 | 1850546 | 2021-10-25 | Harrison | Mississippi | 28047 | 34353 | 540 |
1847296 | 1847296 | 2021-10-24 | Harrison | Mississippi | 28047 | 34338 | 538 |
1844046 | 1844046 | 2021-10-23 | Harrison | Mississippi | 28047 | 34338 | 538 |
1840796 | 1840796 | 2021-10-22 | Harrison | Mississippi | 28047 | 34338 | 538 |
1837547 | 1837547 | 2021-10-21 | Harrison | Mississippi | 28047 | 34312 | 538 |
1834298 | 1834298 | 2021-10-20 | Harrison | Mississippi | 28047 | 34281 | 537 |
1831049 | 1831049 | 2021-10-19 | Harrison | Mississippi | 28047 | 34258 | 537 |
1827800 | 1827800 | 2021-10-18 | Harrison | Mississippi | 28047 | 34150 | 535 |
1824551 | 1824551 | 2021-10-17 | Harrison | Mississippi | 28047 | 34102 | 530 |
1821302 | 1821302 | 2021-10-16 | Harrison | Mississippi | 28047 | 34102 | 530 |
1818053 | 1818053 | 2021-10-15 | Harrison | Mississippi | 28047 | 34102 | 530 |
1814804 | 1814804 | 2021-10-14 | Harrison | Mississippi | 28047 | 34085 | 530 |
1811556 | 1811556 | 2021-10-13 | Harrison | Mississippi | 28047 | 34022 | 530 |
1808307 | 1808307 | 2021-10-12 | Harrison | Mississippi | 28047 | 33979 | 529 |
1805056 | 1805056 | 2021-10-11 | Harrison | Mississippi | 28047 | 33919 | 525 |
1801807 | 1801807 | 2021-10-10 | Harrison | Mississippi | 28047 | 33835 | 522 |
1798558 | 1798558 | 2021-10-09 | Harrison | Mississippi | 28047 | 33835 | 522 |
1795309 | 1795309 | 2021-10-08 | Harrison | Mississippi | 28047 | 33835 | 522 |
1792060 | 1792060 | 2021-10-07 | Harrison | Mississippi | 28047 | 33790 | 521 |
1788811 | 1788811 | 2021-10-06 | Harrison | Mississippi | 28047 | 33728 | 518 |
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);