ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lincoln" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2162331 | 2162331 | 2022-01-29 | Lincoln | Louisiana | 22061 | 11235 | 124 |
2159076 | 2159076 | 2022-01-28 | Lincoln | Louisiana | 22061 | 11235 | 124 |
2155822 | 2155822 | 2022-01-27 | Lincoln | Louisiana | 22061 | 11096 | 123 |
2152569 | 2152569 | 2022-01-26 | Lincoln | Louisiana | 22061 | 10997 | 123 |
2149317 | 2149317 | 2022-01-25 | Lincoln | Louisiana | 22061 | 10279 | 123 |
2146065 | 2146065 | 2022-01-24 | Lincoln | Louisiana | 22061 | 10139 | 122 |
2142810 | 2142810 | 2022-01-23 | Lincoln | Louisiana | 22061 | 9984 | 122 |
2139555 | 2139555 | 2022-01-22 | Lincoln | Louisiana | 22061 | 9984 | 122 |
2136299 | 2136299 | 2022-01-21 | Lincoln | Louisiana | 22061 | 9984 | 122 |
2133047 | 2133047 | 2022-01-20 | Lincoln | Louisiana | 22061 | 9843 | 122 |
2129794 | 2129794 | 2022-01-19 | Lincoln | Louisiana | 22061 | 9599 | 122 |
2126540 | 2126540 | 2022-01-18 | Lincoln | Louisiana | 22061 | 9426 | 122 |
2123288 | 2123288 | 2022-01-17 | Lincoln | Louisiana | 22061 | 9251 | 121 |
2120036 | 2120036 | 2022-01-16 | Lincoln | Louisiana | 22061 | 9251 | 121 |
2116784 | 2116784 | 2022-01-15 | Lincoln | Louisiana | 22061 | 9251 | 121 |
2113533 | 2113533 | 2022-01-14 | Lincoln | Louisiana | 22061 | 9251 | 121 |
2110281 | 2110281 | 2022-01-13 | Lincoln | Louisiana | 22061 | 8709 | 121 |
2107030 | 2107030 | 2022-01-12 | Lincoln | Louisiana | 22061 | 8709 | 121 |
2103779 | 2103779 | 2022-01-11 | Lincoln | Louisiana | 22061 | 8709 | 121 |
2100528 | 2100528 | 2022-01-10 | Lincoln | Louisiana | 22061 | 8552 | 120 |
2097277 | 2097277 | 2022-01-09 | Lincoln | Louisiana | 22061 | 8329 | 120 |
2094025 | 2094025 | 2022-01-08 | Lincoln | Louisiana | 22061 | 8329 | 120 |
2090773 | 2090773 | 2022-01-07 | Lincoln | Louisiana | 22061 | 8329 | 120 |
2087522 | 2087522 | 2022-01-06 | Lincoln | Louisiana | 22061 | 8209 | 120 |
2084270 | 2084270 | 2022-01-05 | Lincoln | Louisiana | 22061 | 8073 | 119 |
2081018 | 2081018 | 2022-01-04 | Lincoln | Louisiana | 22061 | 7952 | 119 |
2077766 | 2077766 | 2022-01-03 | Lincoln | Louisiana | 22061 | 7916 | 119 |
2074515 | 2074515 | 2022-01-02 | Lincoln | Louisiana | 22061 | 7664 | 119 |
2071264 | 2071264 | 2022-01-01 | Lincoln | Louisiana | 22061 | 7664 | 119 |
2068013 | 2068013 | 2021-12-31 | Lincoln | Louisiana | 22061 | 7664 | 119 |
2064762 | 2064762 | 2021-12-30 | Lincoln | Louisiana | 22061 | 7664 | 119 |
2061512 | 2061512 | 2021-12-29 | Lincoln | Louisiana | 22061 | 7576 | 119 |
2058263 | 2058263 | 2021-12-28 | Lincoln | Louisiana | 22061 | 7474 | 119 |
2055014 | 2055014 | 2021-12-27 | Lincoln | Louisiana | 22061 | 7464 | 119 |
2051764 | 2051764 | 2021-12-26 | Lincoln | Louisiana | 22061 | 7396 | 119 |
2048514 | 2048514 | 2021-12-25 | Lincoln | Louisiana | 22061 | 7396 | 119 |
2045264 | 2045264 | 2021-12-24 | Lincoln | Louisiana | 22061 | 7396 | 119 |
2042015 | 2042015 | 2021-12-23 | Lincoln | Louisiana | 22061 | 7396 | 119 |
2038765 | 2038765 | 2021-12-22 | Lincoln | Louisiana | 22061 | 7385 | 119 |
2035515 | 2035515 | 2021-12-21 | Lincoln | Louisiana | 22061 | 7378 | 119 |
2032265 | 2032265 | 2021-12-20 | Lincoln | Louisiana | 22061 | 7371 | 119 |
2029014 | 2029014 | 2021-12-19 | Lincoln | Louisiana | 22061 | 7355 | 119 |
2025763 | 2025763 | 2021-12-18 | Lincoln | Louisiana | 22061 | 7355 | 119 |
2022512 | 2022512 | 2021-12-17 | Lincoln | Louisiana | 22061 | 7355 | 119 |
2019261 | 2019261 | 2021-12-16 | Lincoln | Louisiana | 22061 | 7349 | 119 |
2016011 | 2016011 | 2021-12-15 | Lincoln | Louisiana | 22061 | 7343 | 119 |
2012760 | 2012760 | 2021-12-14 | Lincoln | Louisiana | 22061 | 7333 | 119 |
2009509 | 2009509 | 2021-12-13 | Lincoln | Louisiana | 22061 | 7329 | 118 |
2006258 | 2006258 | 2021-12-12 | Lincoln | Louisiana | 22061 | 7320 | 117 |
2003007 | 2003007 | 2021-12-11 | Lincoln | Louisiana | 22061 | 7320 | 117 |
1999757 | 1999757 | 2021-12-10 | Lincoln | Louisiana | 22061 | 7320 | 117 |
1996506 | 1996506 | 2021-12-09 | Lincoln | Louisiana | 22061 | 7312 | 117 |
1993255 | 1993255 | 2021-12-08 | Lincoln | Louisiana | 22061 | 7309 | 117 |
1990004 | 1990004 | 2021-12-07 | Lincoln | Louisiana | 22061 | 7305 | 117 |
1986754 | 1986754 | 2021-12-06 | Lincoln | Louisiana | 22061 | 7301 | 117 |
1983504 | 1983504 | 2021-12-05 | Lincoln | Louisiana | 22061 | 7289 | 117 |
1980254 | 1980254 | 2021-12-04 | Lincoln | Louisiana | 22061 | 7289 | 117 |
1977004 | 1977004 | 2021-12-03 | Lincoln | Louisiana | 22061 | 7289 | 117 |
1973755 | 1973755 | 2021-12-02 | Lincoln | Louisiana | 22061 | 7284 | 117 |
1970505 | 1970505 | 2021-12-01 | Lincoln | Louisiana | 22061 | 7271 | 117 |
1967255 | 1967255 | 2021-11-30 | Lincoln | Louisiana | 22061 | 7250 | 117 |
1964003 | 1964003 | 2021-11-29 | Lincoln | Louisiana | 22061 | 7234 | 117 |
1960752 | 1960752 | 2021-11-28 | Lincoln | Louisiana | 22061 | 7214 | 117 |
1957501 | 1957501 | 2021-11-27 | Lincoln | Louisiana | 22061 | 7214 | 117 |
1954250 | 1954250 | 2021-11-26 | Lincoln | Louisiana | 22061 | 7214 | 117 |
1950999 | 1950999 | 2021-11-25 | Lincoln | Louisiana | 22061 | 7214 | 117 |
1947748 | 1947748 | 2021-11-24 | Lincoln | Louisiana | 22061 | 7214 | 117 |
1944497 | 1944497 | 2021-11-23 | Lincoln | Louisiana | 22061 | 7209 | 117 |
1941247 | 1941247 | 2021-11-22 | Lincoln | Louisiana | 22061 | 7193 | 116 |
1937997 | 1937997 | 2021-11-21 | Lincoln | Louisiana | 22061 | 7187 | 116 |
1934747 | 1934747 | 2021-11-20 | Lincoln | Louisiana | 22061 | 7187 | 116 |
1931496 | 1931496 | 2021-11-19 | Lincoln | Louisiana | 22061 | 7187 | 116 |
1928245 | 1928245 | 2021-11-18 | Lincoln | Louisiana | 22061 | 7175 | 116 |
1924995 | 1924995 | 2021-11-17 | Lincoln | Louisiana | 22061 | 7162 | 116 |
1921746 | 1921746 | 2021-11-16 | Lincoln | Louisiana | 22061 | 7158 | 116 |
1918496 | 1918496 | 2021-11-15 | Lincoln | Louisiana | 22061 | 7144 | 116 |
1915246 | 1915246 | 2021-11-14 | Lincoln | Louisiana | 22061 | 7131 | 116 |
1911996 | 1911996 | 2021-11-13 | Lincoln | Louisiana | 22061 | 7131 | 116 |
1908747 | 1908747 | 2021-11-12 | Lincoln | Louisiana | 22061 | 7131 | 116 |
1905498 | 1905498 | 2021-11-11 | Lincoln | Louisiana | 22061 | 7122 | 116 |
1902248 | 1902248 | 2021-11-10 | Lincoln | Louisiana | 22061 | 7122 | 116 |
1898998 | 1898998 | 2021-11-09 | Lincoln | Louisiana | 22061 | 7112 | 115 |
1895748 | 1895748 | 2021-11-08 | Lincoln | Louisiana | 22061 | 7104 | 115 |
1892498 | 1892498 | 2021-11-07 | Lincoln | Louisiana | 22061 | 7088 | 115 |
1889248 | 1889248 | 2021-11-06 | Lincoln | Louisiana | 22061 | 7088 | 115 |
1885998 | 1885998 | 2021-11-05 | Lincoln | Louisiana | 22061 | 7088 | 115 |
1882749 | 1882749 | 2021-11-04 | Lincoln | Louisiana | 22061 | 7087 | 115 |
1879500 | 1879500 | 2021-11-03 | Lincoln | Louisiana | 22061 | 7084 | 115 |
1876251 | 1876251 | 2021-11-02 | Lincoln | Louisiana | 22061 | 7082 | 115 |
1873002 | 1873002 | 2021-11-01 | Lincoln | Louisiana | 22061 | 7078 | 115 |
1869753 | 1869753 | 2021-10-31 | Lincoln | Louisiana | 22061 | 7063 | 115 |
1866504 | 1866504 | 2021-10-30 | Lincoln | Louisiana | 22061 | 7063 | 115 |
1863255 | 1863255 | 2021-10-29 | Lincoln | Louisiana | 22061 | 7063 | 115 |
1860006 | 1860006 | 2021-10-28 | Lincoln | Louisiana | 22061 | 7060 | 115 |
1856757 | 1856757 | 2021-10-27 | Lincoln | Louisiana | 22061 | 7057 | 115 |
1853508 | 1853508 | 2021-10-26 | Lincoln | Louisiana | 22061 | 7047 | 115 |
1850259 | 1850259 | 2021-10-25 | Lincoln | Louisiana | 22061 | 7045 | 115 |
1847009 | 1847009 | 2021-10-24 | Lincoln | Louisiana | 22061 | 7041 | 115 |
1843759 | 1843759 | 2021-10-23 | Lincoln | Louisiana | 22061 | 7041 | 115 |
1840509 | 1840509 | 2021-10-22 | Lincoln | Louisiana | 22061 | 7041 | 115 |
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);