ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
47 rows where county = "Scott", deaths = 99 and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2078091 | 2078091 | 2022-01-03 | Scott | Mississippi | 28123 | 5120 | 99 |
2074840 | 2074840 | 2022-01-02 | Scott | Mississippi | 28123 | 4983 | 99 |
2071589 | 2071589 | 2022-01-01 | Scott | Mississippi | 28123 | 4983 | 99 |
2068338 | 2068338 | 2021-12-31 | Scott | Mississippi | 28123 | 4983 | 99 |
2065087 | 2065087 | 2021-12-30 | Scott | Mississippi | 28123 | 4983 | 99 |
2061837 | 2061837 | 2021-12-29 | Scott | Mississippi | 28123 | 4955 | 99 |
2058588 | 2058588 | 2021-12-28 | Scott | Mississippi | 28123 | 4929 | 99 |
2055339 | 2055339 | 2021-12-27 | Scott | Mississippi | 28123 | 4911 | 99 |
2052089 | 2052089 | 2021-12-26 | Scott | Mississippi | 28123 | 4853 | 99 |
2048839 | 2048839 | 2021-12-25 | Scott | Mississippi | 28123 | 4853 | 99 |
2045589 | 2045589 | 2021-12-24 | Scott | Mississippi | 28123 | 4853 | 99 |
2042339 | 2042339 | 2021-12-23 | Scott | Mississippi | 28123 | 4853 | 99 |
2039090 | 2039090 | 2021-12-22 | Scott | Mississippi | 28123 | 4853 | 99 |
2035840 | 2035840 | 2021-12-21 | Scott | Mississippi | 28123 | 4850 | 99 |
2032590 | 2032590 | 2021-12-20 | Scott | Mississippi | 28123 | 4846 | 99 |
2029339 | 2029339 | 2021-12-19 | Scott | Mississippi | 28123 | 4839 | 99 |
2026088 | 2026088 | 2021-12-18 | Scott | Mississippi | 28123 | 4839 | 99 |
2022837 | 2022837 | 2021-12-17 | Scott | Mississippi | 28123 | 4839 | 99 |
2019586 | 2019586 | 2021-12-16 | Scott | Mississippi | 28123 | 4829 | 99 |
2016336 | 2016336 | 2021-12-15 | Scott | Mississippi | 28123 | 4817 | 99 |
2013085 | 2013085 | 2021-12-14 | Scott | Mississippi | 28123 | 4813 | 99 |
2009834 | 2009834 | 2021-12-13 | Scott | Mississippi | 28123 | 4811 | 99 |
2006583 | 2006583 | 2021-12-12 | Scott | Mississippi | 28123 | 4806 | 99 |
2003332 | 2003332 | 2021-12-11 | Scott | Mississippi | 28123 | 4806 | 99 |
2000082 | 2000082 | 2021-12-10 | Scott | Mississippi | 28123 | 4806 | 99 |
1996831 | 1996831 | 2021-12-09 | Scott | Mississippi | 28123 | 4806 | 99 |
1993580 | 1993580 | 2021-12-08 | Scott | Mississippi | 28123 | 4801 | 99 |
1990329 | 1990329 | 2021-12-07 | Scott | Mississippi | 28123 | 4795 | 99 |
1987079 | 1987079 | 2021-12-06 | Scott | Mississippi | 28123 | 4794 | 99 |
1983829 | 1983829 | 2021-12-05 | Scott | Mississippi | 28123 | 4789 | 99 |
1980579 | 1980579 | 2021-12-04 | Scott | Mississippi | 28123 | 4789 | 99 |
1977329 | 1977329 | 2021-12-03 | Scott | Mississippi | 28123 | 4789 | 99 |
1974079 | 1974079 | 2021-12-02 | Scott | Mississippi | 28123 | 4787 | 99 |
1970830 | 1970830 | 2021-12-01 | Scott | Mississippi | 28123 | 4782 | 99 |
1967580 | 1967580 | 2021-11-30 | Scott | Mississippi | 28123 | 4781 | 99 |
1964328 | 1964328 | 2021-11-29 | Scott | Mississippi | 28123 | 4778 | 99 |
1961077 | 1961077 | 2021-11-28 | Scott | Mississippi | 28123 | 4774 | 99 |
1957826 | 1957826 | 2021-11-27 | Scott | Mississippi | 28123 | 4774 | 99 |
1954575 | 1954575 | 2021-11-26 | Scott | Mississippi | 28123 | 4774 | 99 |
1951324 | 1951324 | 2021-11-25 | Scott | Mississippi | 28123 | 4774 | 99 |
1948073 | 1948073 | 2021-11-24 | Scott | Mississippi | 28123 | 4774 | 99 |
1944822 | 1944822 | 2021-11-23 | Scott | Mississippi | 28123 | 4773 | 99 |
1941571 | 1941571 | 2021-11-22 | Scott | Mississippi | 28123 | 4773 | 99 |
1938321 | 1938321 | 2021-11-21 | Scott | Mississippi | 28123 | 4758 | 99 |
1935071 | 1935071 | 2021-11-20 | Scott | Mississippi | 28123 | 4758 | 99 |
1931821 | 1931821 | 2021-11-19 | Scott | Mississippi | 28123 | 4758 | 99 |
1928570 | 1928570 | 2021-11-18 | Scott | Mississippi | 28123 | 4758 | 99 |
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);