ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 28049 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-15 1
- 2020-03-16 1
- 2020-03-17 1
- 2020-03-18 1
- 2020-03-19 1
- 2020-03-20 1
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- …
state 1
- Mississippi · 690 ✖
fips 1
- 28049 · 690 ✖
county 1
- Hinds 690
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175635 | 2175635 | 2022-02-02 | Hinds | Mississippi | 28049 | 49936 | 709 |
2172382 | 2172382 | 2022-02-01 | Hinds | Mississippi | 28049 | 49786 | 704 |
2169129 | 2169129 | 2022-01-31 | Hinds | Mississippi | 28049 | 49670 | 699 |
2165874 | 2165874 | 2022-01-30 | Hinds | Mississippi | 28049 | 49094 | 690 |
2162619 | 2162619 | 2022-01-29 | Hinds | Mississippi | 28049 | 49094 | 690 |
2159364 | 2159364 | 2022-01-28 | Hinds | Mississippi | 28049 | 49094 | 690 |
2156110 | 2156110 | 2022-01-27 | Hinds | Mississippi | 28049 | 48840 | 690 |
2152857 | 2152857 | 2022-01-26 | Hinds | Mississippi | 28049 | 48521 | 689 |
2149605 | 2149605 | 2022-01-25 | Hinds | Mississippi | 28049 | 48203 | 687 |
2146353 | 2146353 | 2022-01-24 | Hinds | Mississippi | 28049 | 47986 | 684 |
2143098 | 2143098 | 2022-01-23 | Hinds | Mississippi | 28049 | 47341 | 682 |
2139843 | 2139843 | 2022-01-22 | Hinds | Mississippi | 28049 | 47341 | 682 |
2136587 | 2136587 | 2022-01-21 | Hinds | Mississippi | 28049 | 47341 | 682 |
2133335 | 2133335 | 2022-01-20 | Hinds | Mississippi | 28049 | 46821 | 679 |
2130082 | 2130082 | 2022-01-19 | Hinds | Mississippi | 28049 | 46338 | 679 |
2126828 | 2126828 | 2022-01-18 | Hinds | Mississippi | 28049 | 45953 | 668 |
2123576 | 2123576 | 2022-01-17 | Hinds | Mississippi | 28049 | 44333 | 665 |
2120324 | 2120324 | 2022-01-16 | Hinds | Mississippi | 28049 | 44333 | 665 |
2117072 | 2117072 | 2022-01-15 | Hinds | Mississippi | 28049 | 44333 | 665 |
2113821 | 2113821 | 2022-01-14 | Hinds | Mississippi | 28049 | 44333 | 665 |
2110569 | 2110569 | 2022-01-13 | Hinds | Mississippi | 28049 | 43895 | 665 |
2107318 | 2107318 | 2022-01-12 | Hinds | Mississippi | 28049 | 43503 | 662 |
2104067 | 2104067 | 2022-01-11 | Hinds | Mississippi | 28049 | 42974 | 660 |
2100816 | 2100816 | 2022-01-10 | Hinds | Mississippi | 28049 | 42637 | 658 |
2097565 | 2097565 | 2022-01-09 | Hinds | Mississippi | 28049 | 40899 | 658 |
2094313 | 2094313 | 2022-01-08 | Hinds | Mississippi | 28049 | 40899 | 658 |
2091061 | 2091061 | 2022-01-07 | Hinds | Mississippi | 28049 | 40899 | 658 |
2087810 | 2087810 | 2022-01-06 | Hinds | Mississippi | 28049 | 40368 | 657 |
2084558 | 2084558 | 2022-01-05 | Hinds | Mississippi | 28049 | 39829 | 656 |
2081306 | 2081306 | 2022-01-04 | Hinds | Mississippi | 28049 | 39306 | 656 |
2078054 | 2078054 | 2022-01-03 | Hinds | Mississippi | 28049 | 39015 | 654 |
2074803 | 2074803 | 2022-01-02 | Hinds | Mississippi | 28049 | 36307 | 654 |
2071552 | 2071552 | 2022-01-01 | Hinds | Mississippi | 28049 | 36307 | 654 |
2068301 | 2068301 | 2021-12-31 | Hinds | Mississippi | 28049 | 36307 | 654 |
2065050 | 2065050 | 2021-12-30 | Hinds | Mississippi | 28049 | 36307 | 654 |
2061800 | 2061800 | 2021-12-29 | Hinds | Mississippi | 28049 | 35615 | 654 |
2058551 | 2058551 | 2021-12-28 | Hinds | Mississippi | 28049 | 35081 | 654 |
2055302 | 2055302 | 2021-12-27 | Hinds | Mississippi | 28049 | 34832 | 653 |
2052052 | 2052052 | 2021-12-26 | Hinds | Mississippi | 28049 | 33686 | 652 |
2048802 | 2048802 | 2021-12-25 | Hinds | Mississippi | 28049 | 33686 | 652 |
2045552 | 2045552 | 2021-12-24 | Hinds | Mississippi | 28049 | 33686 | 652 |
2042302 | 2042302 | 2021-12-23 | Hinds | Mississippi | 28049 | 33686 | 652 |
2039053 | 2039053 | 2021-12-22 | Hinds | Mississippi | 28049 | 33686 | 652 |
2035803 | 2035803 | 2021-12-21 | Hinds | Mississippi | 28049 | 33488 | 651 |
2032553 | 2032553 | 2021-12-20 | Hinds | Mississippi | 28049 | 33421 | 649 |
2029302 | 2029302 | 2021-12-19 | Hinds | Mississippi | 28049 | 33208 | 649 |
2026051 | 2026051 | 2021-12-18 | Hinds | Mississippi | 28049 | 33208 | 649 |
2022800 | 2022800 | 2021-12-17 | Hinds | Mississippi | 28049 | 33208 | 649 |
2019549 | 2019549 | 2021-12-16 | Hinds | Mississippi | 28049 | 33100 | 649 |
2016299 | 2016299 | 2021-12-15 | Hinds | Mississippi | 28049 | 33044 | 649 |
2013048 | 2013048 | 2021-12-14 | Hinds | Mississippi | 28049 | 33007 | 648 |
2009797 | 2009797 | 2021-12-13 | Hinds | Mississippi | 28049 | 32998 | 647 |
2006546 | 2006546 | 2021-12-12 | Hinds | Mississippi | 28049 | 32943 | 646 |
2003295 | 2003295 | 2021-12-11 | Hinds | Mississippi | 28049 | 32943 | 646 |
2000045 | 2000045 | 2021-12-10 | Hinds | Mississippi | 28049 | 32943 | 646 |
1996794 | 1996794 | 2021-12-09 | Hinds | Mississippi | 28049 | 32918 | 646 |
1993543 | 1993543 | 2021-12-08 | Hinds | Mississippi | 28049 | 32859 | 645 |
1990292 | 1990292 | 2021-12-07 | Hinds | Mississippi | 28049 | 32826 | 644 |
1987042 | 1987042 | 2021-12-06 | Hinds | Mississippi | 28049 | 32797 | 643 |
1983792 | 1983792 | 2021-12-05 | Hinds | Mississippi | 28049 | 32743 | 643 |
1980542 | 1980542 | 2021-12-04 | Hinds | Mississippi | 28049 | 32743 | 643 |
1977292 | 1977292 | 2021-12-03 | Hinds | Mississippi | 28049 | 32743 | 643 |
1974042 | 1974042 | 2021-12-02 | Hinds | Mississippi | 28049 | 32718 | 643 |
1970793 | 1970793 | 2021-12-01 | Hinds | Mississippi | 28049 | 32678 | 643 |
1967543 | 1967543 | 2021-11-30 | Hinds | Mississippi | 28049 | 32652 | 642 |
1964291 | 1964291 | 2021-11-29 | Hinds | Mississippi | 28049 | 32638 | 641 |
1961040 | 1961040 | 2021-11-28 | Hinds | Mississippi | 28049 | 32556 | 641 |
1957789 | 1957789 | 2021-11-27 | Hinds | Mississippi | 28049 | 32556 | 641 |
1954538 | 1954538 | 2021-11-26 | Hinds | Mississippi | 28049 | 32556 | 641 |
1951287 | 1951287 | 2021-11-25 | Hinds | Mississippi | 28049 | 32556 | 641 |
1948036 | 1948036 | 2021-11-24 | Hinds | Mississippi | 28049 | 32556 | 641 |
1944785 | 1944785 | 2021-11-23 | Hinds | Mississippi | 28049 | 32537 | 639 |
1941534 | 1941534 | 2021-11-22 | Hinds | Mississippi | 28049 | 32527 | 639 |
1938284 | 1938284 | 2021-11-21 | Hinds | Mississippi | 28049 | 32489 | 639 |
1935034 | 1935034 | 2021-11-20 | Hinds | Mississippi | 28049 | 32489 | 639 |
1931784 | 1931784 | 2021-11-19 | Hinds | Mississippi | 28049 | 32489 | 639 |
1928533 | 1928533 | 2021-11-18 | Hinds | Mississippi | 28049 | 32470 | 639 |
1925283 | 1925283 | 2021-11-17 | Hinds | Mississippi | 28049 | 32454 | 639 |
1922034 | 1922034 | 2021-11-16 | Hinds | Mississippi | 28049 | 32433 | 639 |
1918784 | 1918784 | 2021-11-15 | Hinds | Mississippi | 28049 | 32411 | 639 |
1915534 | 1915534 | 2021-11-14 | Hinds | Mississippi | 28049 | 32355 | 638 |
1912284 | 1912284 | 2021-11-13 | Hinds | Mississippi | 28049 | 32355 | 638 |
1909034 | 1909034 | 2021-11-12 | Hinds | Mississippi | 28049 | 32355 | 638 |
1905785 | 1905785 | 2021-11-11 | Hinds | Mississippi | 28049 | 32336 | 638 |
1902536 | 1902536 | 2021-11-10 | Hinds | Mississippi | 28049 | 32336 | 638 |
1899286 | 1899286 | 2021-11-09 | Hinds | Mississippi | 28049 | 32308 | 638 |
1896036 | 1896036 | 2021-11-08 | Hinds | Mississippi | 28049 | 32293 | 637 |
1892786 | 1892786 | 2021-11-07 | Hinds | Mississippi | 28049 | 32255 | 637 |
1889536 | 1889536 | 2021-11-06 | Hinds | Mississippi | 28049 | 32255 | 637 |
1886286 | 1886286 | 2021-11-05 | Hinds | Mississippi | 28049 | 32255 | 637 |
1883037 | 1883037 | 2021-11-04 | Hinds | Mississippi | 28049 | 32226 | 637 |
1879788 | 1879788 | 2021-11-03 | Hinds | Mississippi | 28049 | 32201 | 637 |
1876539 | 1876539 | 2021-11-02 | Hinds | Mississippi | 28049 | 32171 | 637 |
1873290 | 1873290 | 2021-11-01 | Hinds | Mississippi | 28049 | 32155 | 633 |
1870041 | 1870041 | 2021-10-31 | Hinds | Mississippi | 28049 | 32131 | 632 |
1866792 | 1866792 | 2021-10-30 | Hinds | Mississippi | 28049 | 32131 | 632 |
1863543 | 1863543 | 2021-10-29 | Hinds | Mississippi | 28049 | 32131 | 632 |
1860294 | 1860294 | 2021-10-28 | Hinds | Mississippi | 28049 | 32114 | 632 |
1857045 | 1857045 | 2021-10-27 | Hinds | Mississippi | 28049 | 32087 | 631 |
1853796 | 1853796 | 2021-10-26 | Hinds | Mississippi | 28049 | 32074 | 631 |
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);