ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Marion" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175656 | 2175656 | 2022-02-02 | Marion | Mississippi | 28091 | 6582 | 128 |
2172403 | 2172403 | 2022-02-01 | Marion | Mississippi | 28091 | 6560 | 127 |
2169150 | 2169150 | 2022-01-31 | Marion | Mississippi | 28091 | 6521 | 125 |
2165895 | 2165895 | 2022-01-30 | Marion | Mississippi | 28091 | 6398 | 125 |
2162640 | 2162640 | 2022-01-29 | Marion | Mississippi | 28091 | 6398 | 125 |
2159385 | 2159385 | 2022-01-28 | Marion | Mississippi | 28091 | 6398 | 125 |
2156131 | 2156131 | 2022-01-27 | Marion | Mississippi | 28091 | 6334 | 125 |
2152878 | 2152878 | 2022-01-26 | Marion | Mississippi | 28091 | 6252 | 124 |
2149626 | 2149626 | 2022-01-25 | Marion | Mississippi | 28091 | 6168 | 123 |
2146374 | 2146374 | 2022-01-24 | Marion | Mississippi | 28091 | 6117 | 122 |
2143119 | 2143119 | 2022-01-23 | Marion | Mississippi | 28091 | 5908 | 122 |
2139864 | 2139864 | 2022-01-22 | Marion | Mississippi | 28091 | 5908 | 122 |
2136608 | 2136608 | 2022-01-21 | Marion | Mississippi | 28091 | 5908 | 122 |
2133356 | 2133356 | 2022-01-20 | Marion | Mississippi | 28091 | 5808 | 122 |
2130103 | 2130103 | 2022-01-19 | Marion | Mississippi | 28091 | 5709 | 122 |
2126849 | 2126849 | 2022-01-18 | Marion | Mississippi | 28091 | 5602 | 120 |
2123597 | 2123597 | 2022-01-17 | Marion | Mississippi | 28091 | 5363 | 119 |
2120345 | 2120345 | 2022-01-16 | Marion | Mississippi | 28091 | 5363 | 119 |
2117093 | 2117093 | 2022-01-15 | Marion | Mississippi | 28091 | 5363 | 119 |
2113842 | 2113842 | 2022-01-14 | Marion | Mississippi | 28091 | 5363 | 119 |
2110590 | 2110590 | 2022-01-13 | Marion | Mississippi | 28091 | 5260 | 119 |
2107339 | 2107339 | 2022-01-12 | Marion | Mississippi | 28091 | 5166 | 119 |
2104088 | 2104088 | 2022-01-11 | Marion | Mississippi | 28091 | 5070 | 119 |
2100837 | 2100837 | 2022-01-10 | Marion | Mississippi | 28091 | 5030 | 118 |
2097586 | 2097586 | 2022-01-09 | Marion | Mississippi | 28091 | 4889 | 117 |
2094334 | 2094334 | 2022-01-08 | Marion | Mississippi | 28091 | 4889 | 117 |
2091082 | 2091082 | 2022-01-07 | Marion | Mississippi | 28091 | 4889 | 117 |
2087831 | 2087831 | 2022-01-06 | Marion | Mississippi | 28091 | 4815 | 117 |
2084579 | 2084579 | 2022-01-05 | Marion | Mississippi | 28091 | 4748 | 116 |
2081327 | 2081327 | 2022-01-04 | Marion | Mississippi | 28091 | 4694 | 115 |
2078075 | 2078075 | 2022-01-03 | Marion | Mississippi | 28091 | 4664 | 115 |
2074824 | 2074824 | 2022-01-02 | Marion | Mississippi | 28091 | 4557 | 115 |
2071573 | 2071573 | 2022-01-01 | Marion | Mississippi | 28091 | 4557 | 115 |
2068322 | 2068322 | 2021-12-31 | Marion | Mississippi | 28091 | 4557 | 115 |
2065071 | 2065071 | 2021-12-30 | Marion | Mississippi | 28091 | 4557 | 115 |
2061821 | 2061821 | 2021-12-29 | Marion | Mississippi | 28091 | 4500 | 115 |
2058572 | 2058572 | 2021-12-28 | Marion | Mississippi | 28091 | 4459 | 114 |
2055323 | 2055323 | 2021-12-27 | Marion | Mississippi | 28091 | 4442 | 114 |
2052073 | 2052073 | 2021-12-26 | Marion | Mississippi | 28091 | 4384 | 113 |
2048823 | 2048823 | 2021-12-25 | Marion | Mississippi | 28091 | 4384 | 113 |
2045573 | 2045573 | 2021-12-24 | Marion | Mississippi | 28091 | 4384 | 113 |
2042323 | 2042323 | 2021-12-23 | Marion | Mississippi | 28091 | 4384 | 113 |
2039074 | 2039074 | 2021-12-22 | Marion | Mississippi | 28091 | 4384 | 113 |
2035824 | 2035824 | 2021-12-21 | Marion | Mississippi | 28091 | 4380 | 113 |
2032574 | 2032574 | 2021-12-20 | Marion | Mississippi | 28091 | 4373 | 113 |
2029323 | 2029323 | 2021-12-19 | Marion | Mississippi | 28091 | 4355 | 113 |
2026072 | 2026072 | 2021-12-18 | Marion | Mississippi | 28091 | 4355 | 113 |
2022821 | 2022821 | 2021-12-17 | Marion | Mississippi | 28091 | 4355 | 113 |
2019570 | 2019570 | 2021-12-16 | Marion | Mississippi | 28091 | 4347 | 113 |
2016320 | 2016320 | 2021-12-15 | Marion | Mississippi | 28091 | 4343 | 112 |
2013069 | 2013069 | 2021-12-14 | Marion | Mississippi | 28091 | 4339 | 112 |
2009818 | 2009818 | 2021-12-13 | Marion | Mississippi | 28091 | 4334 | 112 |
2006567 | 2006567 | 2021-12-12 | Marion | Mississippi | 28091 | 4327 | 112 |
2003316 | 2003316 | 2021-12-11 | Marion | Mississippi | 28091 | 4327 | 112 |
2000066 | 2000066 | 2021-12-10 | Marion | Mississippi | 28091 | 4327 | 112 |
1996815 | 1996815 | 2021-12-09 | Marion | Mississippi | 28091 | 4323 | 112 |
1993564 | 1993564 | 2021-12-08 | Marion | Mississippi | 28091 | 4318 | 112 |
1990313 | 1990313 | 2021-12-07 | Marion | Mississippi | 28091 | 4313 | 112 |
1987063 | 1987063 | 2021-12-06 | Marion | Mississippi | 28091 | 4311 | 112 |
1983813 | 1983813 | 2021-12-05 | Marion | Mississippi | 28091 | 4295 | 112 |
1980563 | 1980563 | 2021-12-04 | Marion | Mississippi | 28091 | 4295 | 112 |
1977313 | 1977313 | 2021-12-03 | Marion | Mississippi | 28091 | 4295 | 112 |
1974063 | 1974063 | 2021-12-02 | Marion | Mississippi | 28091 | 4295 | 112 |
1970814 | 1970814 | 2021-12-01 | Marion | Mississippi | 28091 | 4287 | 112 |
1967564 | 1967564 | 2021-11-30 | Marion | Mississippi | 28091 | 4279 | 112 |
1964312 | 1964312 | 2021-11-29 | Marion | Mississippi | 28091 | 4277 | 112 |
1961061 | 1961061 | 2021-11-28 | Marion | Mississippi | 28091 | 4265 | 112 |
1957810 | 1957810 | 2021-11-27 | Marion | Mississippi | 28091 | 4265 | 112 |
1954559 | 1954559 | 2021-11-26 | Marion | Mississippi | 28091 | 4265 | 112 |
1951308 | 1951308 | 2021-11-25 | Marion | Mississippi | 28091 | 4265 | 112 |
1948057 | 1948057 | 2021-11-24 | Marion | Mississippi | 28091 | 4265 | 112 |
1944806 | 1944806 | 2021-11-23 | Marion | Mississippi | 28091 | 4264 | 112 |
1941555 | 1941555 | 2021-11-22 | Marion | Mississippi | 28091 | 4264 | 112 |
1938305 | 1938305 | 2021-11-21 | Marion | Mississippi | 28091 | 4257 | 112 |
1935055 | 1935055 | 2021-11-20 | Marion | Mississippi | 28091 | 4257 | 112 |
1931805 | 1931805 | 2021-11-19 | Marion | Mississippi | 28091 | 4257 | 112 |
1928554 | 1928554 | 2021-11-18 | Marion | Mississippi | 28091 | 4256 | 111 |
1925304 | 1925304 | 2021-11-17 | Marion | Mississippi | 28091 | 4254 | 111 |
1922055 | 1922055 | 2021-11-16 | Marion | Mississippi | 28091 | 4254 | 110 |
1918805 | 1918805 | 2021-11-15 | Marion | Mississippi | 28091 | 4254 | 109 |
1915555 | 1915555 | 2021-11-14 | Marion | Mississippi | 28091 | 4252 | 109 |
1912305 | 1912305 | 2021-11-13 | Marion | Mississippi | 28091 | 4252 | 109 |
1909055 | 1909055 | 2021-11-12 | Marion | Mississippi | 28091 | 4252 | 109 |
1905806 | 1905806 | 2021-11-11 | Marion | Mississippi | 28091 | 4248 | 109 |
1902557 | 1902557 | 2021-11-10 | Marion | Mississippi | 28091 | 4248 | 109 |
1899307 | 1899307 | 2021-11-09 | Marion | Mississippi | 28091 | 4246 | 108 |
1896057 | 1896057 | 2021-11-08 | Marion | Mississippi | 28091 | 4245 | 108 |
1892807 | 1892807 | 2021-11-07 | Marion | Mississippi | 28091 | 4244 | 108 |
1889557 | 1889557 | 2021-11-06 | Marion | Mississippi | 28091 | 4244 | 108 |
1886307 | 1886307 | 2021-11-05 | Marion | Mississippi | 28091 | 4244 | 108 |
1883058 | 1883058 | 2021-11-04 | Marion | Mississippi | 28091 | 4244 | 108 |
1879809 | 1879809 | 2021-11-03 | Marion | Mississippi | 28091 | 4242 | 108 |
1876560 | 1876560 | 2021-11-02 | Marion | Mississippi | 28091 | 4239 | 108 |
1873311 | 1873311 | 2021-11-01 | Marion | Mississippi | 28091 | 4239 | 108 |
1870062 | 1870062 | 2021-10-31 | Marion | Mississippi | 28091 | 4239 | 108 |
1866813 | 1866813 | 2021-10-30 | Marion | Mississippi | 28091 | 4239 | 108 |
1863564 | 1863564 | 2021-10-29 | Marion | Mississippi | 28091 | 4239 | 108 |
1860315 | 1860315 | 2021-10-28 | Marion | Mississippi | 28091 | 4238 | 108 |
1857066 | 1857066 | 2021-10-27 | Marion | Mississippi | 28091 | 4236 | 108 |
1853817 | 1853817 | 2021-10-26 | Marion | Mississippi | 28091 | 4236 | 108 |
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);