ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Morgan" and fips = 1103 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174245 | 2174245 | 2022-02-02 | Morgan | Alabama | 1103 | 34153 | 452 |
2170993 | 2170993 | 2022-02-01 | Morgan | Alabama | 1103 | 33943 | 449 |
2167740 | 2167740 | 2022-01-31 | Morgan | Alabama | 1103 | 33760 | 448 |
2164485 | 2164485 | 2022-01-30 | Morgan | Alabama | 1103 | 33638 | 448 |
2161230 | 2161230 | 2022-01-29 | Morgan | Alabama | 1103 | 33440 | 448 |
2157974 | 2157974 | 2022-01-28 | Morgan | Alabama | 1103 | 31769 | 438 |
2154721 | 2154721 | 2022-01-27 | Morgan | Alabama | 1103 | 31769 | 438 |
2151468 | 2151468 | 2022-01-26 | Morgan | Alabama | 1103 | 31769 | 438 |
2148216 | 2148216 | 2022-01-25 | Morgan | Alabama | 1103 | 31769 | 438 |
2144964 | 2144964 | 2022-01-24 | Morgan | Alabama | 1103 | 31769 | 438 |
2141709 | 2141709 | 2022-01-23 | Morgan | Alabama | 1103 | 31585 | 438 |
2138453 | 2138453 | 2022-01-22 | Morgan | Alabama | 1103 | 31242 | 438 |
2135198 | 2135198 | 2022-01-21 | Morgan | Alabama | 1103 | 30520 | 438 |
2131946 | 2131946 | 2022-01-20 | Morgan | Alabama | 1103 | 30038 | 438 |
2128692 | 2128692 | 2022-01-19 | Morgan | Alabama | 1103 | 29469 | 437 |
2125439 | 2125439 | 2022-01-18 | Morgan | Alabama | 1103 | 28842 | 437 |
2122187 | 2122187 | 2022-01-17 | Morgan | Alabama | 1103 | 28456 | 437 |
2118935 | 2118935 | 2022-01-16 | Morgan | Alabama | 1103 | 28090 | 437 |
2115683 | 2115683 | 2022-01-15 | Morgan | Alabama | 1103 | 26361 | 431 |
2112431 | 2112431 | 2022-01-14 | Morgan | Alabama | 1103 | 26361 | 431 |
2109179 | 2109179 | 2022-01-13 | Morgan | Alabama | 1103 | 26361 | 431 |
2105928 | 2105928 | 2022-01-12 | Morgan | Alabama | 1103 | 26361 | 431 |
2102677 | 2102677 | 2022-01-11 | Morgan | Alabama | 1103 | 26122 | 431 |
2099426 | 2099426 | 2022-01-10 | Morgan | Alabama | 1103 | 25883 | 431 |
2096175 | 2096175 | 2022-01-09 | Morgan | Alabama | 1103 | 25719 | 431 |
2092923 | 2092923 | 2022-01-08 | Morgan | Alabama | 1103 | 25437 | 431 |
2089671 | 2089671 | 2022-01-07 | Morgan | Alabama | 1103 | 25222 | 431 |
2086420 | 2086420 | 2022-01-06 | Morgan | Alabama | 1103 | 24921 | 428 |
2083168 | 2083168 | 2022-01-05 | Morgan | Alabama | 1103 | 24623 | 426 |
2079916 | 2079916 | 2022-01-04 | Morgan | Alabama | 1103 | 24407 | 426 |
2076664 | 2076664 | 2022-01-03 | Morgan | Alabama | 1103 | 24195 | 425 |
2073413 | 2073413 | 2022-01-02 | Morgan | Alabama | 1103 | 24089 | 425 |
2070162 | 2070162 | 2022-01-01 | Morgan | Alabama | 1103 | 23831 | 425 |
2066911 | 2066911 | 2021-12-31 | Morgan | Alabama | 1103 | 23831 | 425 |
2063661 | 2063661 | 2021-12-30 | Morgan | Alabama | 1103 | 23661 | 425 |
2060411 | 2060411 | 2021-12-29 | Morgan | Alabama | 1103 | 23449 | 425 |
2057162 | 2057162 | 2021-12-28 | Morgan | Alabama | 1103 | 23314 | 425 |
2053913 | 2053913 | 2021-12-27 | Morgan | Alabama | 1103 | 23235 | 424 |
2050663 | 2050663 | 2021-12-26 | Morgan | Alabama | 1103 | 23180 | 424 |
2047413 | 2047413 | 2021-12-25 | Morgan | Alabama | 1103 | 23159 | 424 |
2044163 | 2044163 | 2021-12-24 | Morgan | Alabama | 1103 | 23084 | 424 |
2040914 | 2040914 | 2021-12-23 | Morgan | Alabama | 1103 | 23026 | 423 |
2037664 | 2037664 | 2021-12-22 | Morgan | Alabama | 1103 | 22986 | 421 |
2034414 | 2034414 | 2021-12-21 | Morgan | Alabama | 1103 | 22945 | 420 |
2031164 | 2031164 | 2021-12-20 | Morgan | Alabama | 1103 | 22913 | 419 |
2027913 | 2027913 | 2021-12-19 | Morgan | Alabama | 1103 | 22893 | 419 |
2024662 | 2024662 | 2021-12-18 | Morgan | Alabama | 1103 | 22874 | 419 |
2021411 | 2021411 | 2021-12-17 | Morgan | Alabama | 1103 | 22855 | 418 |
2018160 | 2018160 | 2021-12-16 | Morgan | Alabama | 1103 | 22827 | 417 |
2014910 | 2014910 | 2021-12-15 | Morgan | Alabama | 1103 | 22801 | 415 |
2011659 | 2011659 | 2021-12-14 | Morgan | Alabama | 1103 | 22772 | 414 |
2008408 | 2008408 | 2021-12-13 | Morgan | Alabama | 1103 | 22711 | 414 |
2005157 | 2005157 | 2021-12-12 | Morgan | Alabama | 1103 | 22697 | 414 |
2001906 | 2001906 | 2021-12-11 | Morgan | Alabama | 1103 | 22684 | 414 |
1998656 | 1998656 | 2021-12-10 | Morgan | Alabama | 1103 | 22652 | 414 |
1995405 | 1995405 | 2021-12-09 | Morgan | Alabama | 1103 | 22625 | 411 |
1992154 | 1992154 | 2021-12-08 | Morgan | Alabama | 1103 | 22597 | 411 |
1988903 | 1988903 | 2021-12-07 | Morgan | Alabama | 1103 | 22569 | 411 |
1985653 | 1985653 | 2021-12-06 | Morgan | Alabama | 1103 | 22548 | 411 |
1982403 | 1982403 | 2021-12-05 | Morgan | Alabama | 1103 | 22540 | 411 |
1979153 | 1979153 | 2021-12-04 | Morgan | Alabama | 1103 | 22530 | 411 |
1975903 | 1975903 | 2021-12-03 | Morgan | Alabama | 1103 | 22527 | 408 |
1972654 | 1972654 | 2021-12-02 | Morgan | Alabama | 1103 | 22503 | 408 |
1969404 | 1969404 | 2021-12-01 | Morgan | Alabama | 1103 | 22477 | 407 |
1966154 | 1966154 | 2021-11-30 | Morgan | Alabama | 1103 | 22459 | 406 |
1962902 | 1962902 | 2021-11-29 | Morgan | Alabama | 1103 | 22459 | 406 |
1959651 | 1959651 | 2021-11-28 | Morgan | Alabama | 1103 | 22454 | 406 |
1956400 | 1956400 | 2021-11-27 | Morgan | Alabama | 1103 | 22451 | 406 |
1953149 | 1953149 | 2021-11-26 | Morgan | Alabama | 1103 | 22441 | 406 |
1949898 | 1949898 | 2021-11-25 | Morgan | Alabama | 1103 | 22441 | 406 |
1946647 | 1946647 | 2021-11-24 | Morgan | Alabama | 1103 | 22427 | 407 |
1943396 | 1943396 | 2021-11-23 | Morgan | Alabama | 1103 | 22397 | 405 |
1940146 | 1940146 | 2021-11-22 | Morgan | Alabama | 1103 | 22367 | 405 |
1936896 | 1936896 | 2021-11-21 | Morgan | Alabama | 1103 | 22358 | 405 |
1933646 | 1933646 | 2021-11-20 | Morgan | Alabama | 1103 | 22343 | 405 |
1930394 | 1930394 | 2021-11-19 | Morgan | Alabama | 1103 | 22318 | 405 |
1927144 | 1927144 | 2021-11-18 | Morgan | Alabama | 1103 | 22307 | 405 |
1923894 | 1923894 | 2021-11-17 | Morgan | Alabama | 1103 | 22294 | 403 |
1920645 | 1920645 | 2021-11-16 | Morgan | Alabama | 1103 | 22272 | 401 |
1917395 | 1917395 | 2021-11-15 | Morgan | Alabama | 1103 | 22270 | 401 |
1914145 | 1914145 | 2021-11-14 | Morgan | Alabama | 1103 | 22259 | 401 |
1910895 | 1910895 | 2021-11-13 | Morgan | Alabama | 1103 | 22242 | 401 |
1907646 | 1907646 | 2021-11-12 | Morgan | Alabama | 1103 | 22197 | 398 |
1904397 | 1904397 | 2021-11-11 | Morgan | Alabama | 1103 | 22177 | 398 |
1901147 | 1901147 | 2021-11-10 | Morgan | Alabama | 1103 | 22124 | 398 |
1897897 | 1897897 | 2021-11-09 | Morgan | Alabama | 1103 | 22098 | 395 |
1894647 | 1894647 | 2021-11-08 | Morgan | Alabama | 1103 | 22058 | 394 |
1891397 | 1891397 | 2021-11-07 | Morgan | Alabama | 1103 | 22049 | 394 |
1888147 | 1888147 | 2021-11-06 | Morgan | Alabama | 1103 | 22041 | 394 |
1884897 | 1884897 | 2021-11-05 | Morgan | Alabama | 1103 | 21990 | 389 |
1881648 | 1881648 | 2021-11-04 | Morgan | Alabama | 1103 | 21969 | 387 |
1878399 | 1878399 | 2021-11-03 | Morgan | Alabama | 1103 | 21946 | 383 |
1875150 | 1875150 | 2021-11-02 | Morgan | Alabama | 1103 | 21908 | 383 |
1871901 | 1871901 | 2021-11-01 | Morgan | Alabama | 1103 | 21862 | 383 |
1868652 | 1868652 | 2021-10-31 | Morgan | Alabama | 1103 | 21861 | 383 |
1865403 | 1865403 | 2021-10-30 | Morgan | Alabama | 1103 | 21858 | 383 |
1862154 | 1862154 | 2021-10-29 | Morgan | Alabama | 1103 | 21819 | 383 |
1858905 | 1858905 | 2021-10-28 | Morgan | Alabama | 1103 | 21809 | 379 |
1855656 | 1855656 | 2021-10-27 | Morgan | Alabama | 1103 | 21758 | 378 |
1852407 | 1852407 | 2021-10-26 | Morgan | Alabama | 1103 | 21037 | 378 |
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);