ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Clay" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175623 | 2175623 | 2022-02-02 | Clay | Mississippi | 28025 | 4723 | 88 |
2172370 | 2172370 | 2022-02-01 | Clay | Mississippi | 28025 | 4702 | 87 |
2169117 | 2169117 | 2022-01-31 | Clay | Mississippi | 28025 | 4674 | 83 |
2165862 | 2165862 | 2022-01-30 | Clay | Mississippi | 28025 | 4625 | 80 |
2162607 | 2162607 | 2022-01-29 | Clay | Mississippi | 28025 | 4625 | 80 |
2159352 | 2159352 | 2022-01-28 | Clay | Mississippi | 28025 | 4625 | 80 |
2156098 | 2156098 | 2022-01-27 | Clay | Mississippi | 28025 | 4595 | 80 |
2152845 | 2152845 | 2022-01-26 | Clay | Mississippi | 28025 | 4565 | 80 |
2149593 | 2149593 | 2022-01-25 | Clay | Mississippi | 28025 | 4537 | 80 |
2146341 | 2146341 | 2022-01-24 | Clay | Mississippi | 28025 | 4491 | 80 |
2143086 | 2143086 | 2022-01-23 | Clay | Mississippi | 28025 | 4439 | 80 |
2139831 | 2139831 | 2022-01-22 | Clay | Mississippi | 28025 | 4439 | 80 |
2136575 | 2136575 | 2022-01-21 | Clay | Mississippi | 28025 | 4439 | 80 |
2133323 | 2133323 | 2022-01-20 | Clay | Mississippi | 28025 | 4418 | 80 |
2130070 | 2130070 | 2022-01-19 | Clay | Mississippi | 28025 | 4370 | 78 |
2126816 | 2126816 | 2022-01-18 | Clay | Mississippi | 28025 | 4283 | 78 |
2123564 | 2123564 | 2022-01-17 | Clay | Mississippi | 28025 | 4126 | 78 |
2120312 | 2120312 | 2022-01-16 | Clay | Mississippi | 28025 | 4126 | 78 |
2117060 | 2117060 | 2022-01-15 | Clay | Mississippi | 28025 | 4126 | 78 |
2113809 | 2113809 | 2022-01-14 | Clay | Mississippi | 28025 | 4126 | 78 |
2110557 | 2110557 | 2022-01-13 | Clay | Mississippi | 28025 | 4059 | 78 |
2107306 | 2107306 | 2022-01-12 | Clay | Mississippi | 28025 | 3965 | 78 |
2104055 | 2104055 | 2022-01-11 | Clay | Mississippi | 28025 | 3895 | 78 |
2100804 | 2100804 | 2022-01-10 | Clay | Mississippi | 28025 | 3855 | 78 |
2097553 | 2097553 | 2022-01-09 | Clay | Mississippi | 28025 | 3712 | 78 |
2094301 | 2094301 | 2022-01-08 | Clay | Mississippi | 28025 | 3712 | 78 |
2091049 | 2091049 | 2022-01-07 | Clay | Mississippi | 28025 | 3712 | 78 |
2087798 | 2087798 | 2022-01-06 | Clay | Mississippi | 28025 | 3657 | 78 |
2084546 | 2084546 | 2022-01-05 | Clay | Mississippi | 28025 | 3597 | 78 |
2081294 | 2081294 | 2022-01-04 | Clay | Mississippi | 28025 | 3539 | 78 |
2078042 | 2078042 | 2022-01-03 | Clay | Mississippi | 28025 | 3483 | 78 |
2074791 | 2074791 | 2022-01-02 | Clay | Mississippi | 28025 | 3345 | 78 |
2071540 | 2071540 | 2022-01-01 | Clay | Mississippi | 28025 | 3345 | 78 |
2068289 | 2068289 | 2021-12-31 | Clay | Mississippi | 28025 | 3345 | 78 |
2065038 | 2065038 | 2021-12-30 | Clay | Mississippi | 28025 | 3345 | 78 |
2061788 | 2061788 | 2021-12-29 | Clay | Mississippi | 28025 | 3305 | 78 |
2058539 | 2058539 | 2021-12-28 | Clay | Mississippi | 28025 | 3276 | 78 |
2055290 | 2055290 | 2021-12-27 | Clay | Mississippi | 28025 | 3246 | 78 |
2052040 | 2052040 | 2021-12-26 | Clay | Mississippi | 28025 | 3207 | 78 |
2048790 | 2048790 | 2021-12-25 | Clay | Mississippi | 28025 | 3207 | 78 |
2045540 | 2045540 | 2021-12-24 | Clay | Mississippi | 28025 | 3207 | 78 |
2042290 | 2042290 | 2021-12-23 | Clay | Mississippi | 28025 | 3207 | 78 |
2039041 | 2039041 | 2021-12-22 | Clay | Mississippi | 28025 | 3207 | 78 |
2035791 | 2035791 | 2021-12-21 | Clay | Mississippi | 28025 | 3203 | 78 |
2032541 | 2032541 | 2021-12-20 | Clay | Mississippi | 28025 | 3201 | 78 |
2029290 | 2029290 | 2021-12-19 | Clay | Mississippi | 28025 | 3195 | 78 |
2026039 | 2026039 | 2021-12-18 | Clay | Mississippi | 28025 | 3195 | 78 |
2022788 | 2022788 | 2021-12-17 | Clay | Mississippi | 28025 | 3195 | 78 |
2019537 | 2019537 | 2021-12-16 | Clay | Mississippi | 28025 | 3190 | 78 |
2016287 | 2016287 | 2021-12-15 | Clay | Mississippi | 28025 | 3181 | 78 |
2013036 | 2013036 | 2021-12-14 | Clay | Mississippi | 28025 | 3172 | 78 |
2009785 | 2009785 | 2021-12-13 | Clay | Mississippi | 28025 | 3167 | 78 |
2006534 | 2006534 | 2021-12-12 | Clay | Mississippi | 28025 | 3157 | 78 |
2003283 | 2003283 | 2021-12-11 | Clay | Mississippi | 28025 | 3157 | 78 |
2000033 | 2000033 | 2021-12-10 | Clay | Mississippi | 28025 | 3157 | 78 |
1996782 | 1996782 | 2021-12-09 | Clay | Mississippi | 28025 | 3150 | 78 |
1993531 | 1993531 | 2021-12-08 | Clay | Mississippi | 28025 | 3148 | 78 |
1990280 | 1990280 | 2021-12-07 | Clay | Mississippi | 28025 | 3143 | 78 |
1987030 | 1987030 | 2021-12-06 | Clay | Mississippi | 28025 | 3139 | 78 |
1983780 | 1983780 | 2021-12-05 | Clay | Mississippi | 28025 | 3129 | 78 |
1980530 | 1980530 | 2021-12-04 | Clay | Mississippi | 28025 | 3129 | 78 |
1977280 | 1977280 | 2021-12-03 | Clay | Mississippi | 28025 | 3129 | 78 |
1974030 | 1974030 | 2021-12-02 | Clay | Mississippi | 28025 | 3127 | 78 |
1970781 | 1970781 | 2021-12-01 | Clay | Mississippi | 28025 | 3126 | 78 |
1967531 | 1967531 | 2021-11-30 | Clay | Mississippi | 28025 | 3125 | 78 |
1964279 | 1964279 | 2021-11-29 | Clay | Mississippi | 28025 | 3122 | 78 |
1961028 | 1961028 | 2021-11-28 | Clay | Mississippi | 28025 | 3118 | 78 |
1957777 | 1957777 | 2021-11-27 | Clay | Mississippi | 28025 | 3118 | 78 |
1954526 | 1954526 | 2021-11-26 | Clay | Mississippi | 28025 | 3118 | 78 |
1951275 | 1951275 | 2021-11-25 | Clay | Mississippi | 28025 | 3118 | 78 |
1948024 | 1948024 | 2021-11-24 | Clay | Mississippi | 28025 | 3118 | 78 |
1944773 | 1944773 | 2021-11-23 | Clay | Mississippi | 28025 | 3117 | 78 |
1941522 | 1941522 | 2021-11-22 | Clay | Mississippi | 28025 | 3117 | 78 |
1938272 | 1938272 | 2021-11-21 | Clay | Mississippi | 28025 | 3114 | 78 |
1935022 | 1935022 | 2021-11-20 | Clay | Mississippi | 28025 | 3114 | 78 |
1931772 | 1931772 | 2021-11-19 | Clay | Mississippi | 28025 | 3114 | 78 |
1928521 | 1928521 | 2021-11-18 | Clay | Mississippi | 28025 | 3112 | 78 |
1925271 | 1925271 | 2021-11-17 | Clay | Mississippi | 28025 | 3111 | 78 |
1922022 | 1922022 | 2021-11-16 | Clay | Mississippi | 28025 | 3109 | 78 |
1918772 | 1918772 | 2021-11-15 | Clay | Mississippi | 28025 | 3106 | 78 |
1915522 | 1915522 | 2021-11-14 | Clay | Mississippi | 28025 | 3103 | 77 |
1912272 | 1912272 | 2021-11-13 | Clay | Mississippi | 28025 | 3103 | 77 |
1909022 | 1909022 | 2021-11-12 | Clay | Mississippi | 28025 | 3103 | 77 |
1905773 | 1905773 | 2021-11-11 | Clay | Mississippi | 28025 | 3101 | 77 |
1902524 | 1902524 | 2021-11-10 | Clay | Mississippi | 28025 | 3101 | 77 |
1899274 | 1899274 | 2021-11-09 | Clay | Mississippi | 28025 | 3100 | 77 |
1896024 | 1896024 | 2021-11-08 | Clay | Mississippi | 28025 | 3100 | 77 |
1892774 | 1892774 | 2021-11-07 | Clay | Mississippi | 28025 | 3099 | 77 |
1889524 | 1889524 | 2021-11-06 | Clay | Mississippi | 28025 | 3099 | 77 |
1886274 | 1886274 | 2021-11-05 | Clay | Mississippi | 28025 | 3099 | 77 |
1883025 | 1883025 | 2021-11-04 | Clay | Mississippi | 28025 | 3098 | 77 |
1879776 | 1879776 | 2021-11-03 | Clay | Mississippi | 28025 | 3097 | 77 |
1876527 | 1876527 | 2021-11-02 | Clay | Mississippi | 28025 | 3097 | 77 |
1873278 | 1873278 | 2021-11-01 | Clay | Mississippi | 28025 | 3097 | 77 |
1870029 | 1870029 | 2021-10-31 | Clay | Mississippi | 28025 | 3094 | 77 |
1866780 | 1866780 | 2021-10-30 | Clay | Mississippi | 28025 | 3094 | 77 |
1863531 | 1863531 | 2021-10-29 | Clay | Mississippi | 28025 | 3094 | 77 |
1860282 | 1860282 | 2021-10-28 | Clay | Mississippi | 28025 | 3093 | 77 |
1857033 | 1857033 | 2021-10-27 | Clay | Mississippi | 28025 | 3092 | 77 |
1853784 | 1853784 | 2021-10-26 | Clay | Mississippi | 28025 | 3090 | 77 |
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);