ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "St. Landry" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175365 | 2175365 | 2022-02-02 | St. Landry | Louisiana | 22097 | 21055 | 365 |
2172112 | 2172112 | 2022-02-01 | St. Landry | Louisiana | 22097 | 20934 | 365 |
2168859 | 2168859 | 2022-01-31 | St. Landry | Louisiana | 22097 | 20811 | 362 |
2165604 | 2165604 | 2022-01-30 | St. Landry | Louisiana | 22097 | 20553 | 362 |
2162349 | 2162349 | 2022-01-29 | St. Landry | Louisiana | 22097 | 20553 | 362 |
2159094 | 2159094 | 2022-01-28 | St. Landry | Louisiana | 22097 | 20553 | 362 |
2155840 | 2155840 | 2022-01-27 | St. Landry | Louisiana | 22097 | 20349 | 361 |
2152587 | 2152587 | 2022-01-26 | St. Landry | Louisiana | 22097 | 20177 | 360 |
2149335 | 2149335 | 2022-01-25 | St. Landry | Louisiana | 22097 | 19157 | 360 |
2146083 | 2146083 | 2022-01-24 | St. Landry | Louisiana | 22097 | 18883 | 357 |
2142828 | 2142828 | 2022-01-23 | St. Landry | Louisiana | 22097 | 18520 | 356 |
2139573 | 2139573 | 2022-01-22 | St. Landry | Louisiana | 22097 | 18520 | 356 |
2136317 | 2136317 | 2022-01-21 | St. Landry | Louisiana | 22097 | 18520 | 356 |
2133065 | 2133065 | 2022-01-20 | St. Landry | Louisiana | 22097 | 18274 | 357 |
2129812 | 2129812 | 2022-01-19 | St. Landry | Louisiana | 22097 | 18010 | 354 |
2126558 | 2126558 | 2022-01-18 | St. Landry | Louisiana | 22097 | 17822 | 354 |
2123306 | 2123306 | 2022-01-17 | St. Landry | Louisiana | 22097 | 17275 | 354 |
2120054 | 2120054 | 2022-01-16 | St. Landry | Louisiana | 22097 | 17275 | 354 |
2116802 | 2116802 | 2022-01-15 | St. Landry | Louisiana | 22097 | 17275 | 354 |
2113551 | 2113551 | 2022-01-14 | St. Landry | Louisiana | 22097 | 17275 | 354 |
2110299 | 2110299 | 2022-01-13 | St. Landry | Louisiana | 22097 | 16488 | 354 |
2107048 | 2107048 | 2022-01-12 | St. Landry | Louisiana | 22097 | 16488 | 354 |
2103797 | 2103797 | 2022-01-11 | St. Landry | Louisiana | 22097 | 16488 | 354 |
2100546 | 2100546 | 2022-01-10 | St. Landry | Louisiana | 22097 | 16337 | 354 |
2097295 | 2097295 | 2022-01-09 | St. Landry | Louisiana | 22097 | 15881 | 354 |
2094043 | 2094043 | 2022-01-08 | St. Landry | Louisiana | 22097 | 15881 | 354 |
2090791 | 2090791 | 2022-01-07 | St. Landry | Louisiana | 22097 | 15881 | 354 |
2087540 | 2087540 | 2022-01-06 | St. Landry | Louisiana | 22097 | 15638 | 354 |
2084288 | 2084288 | 2022-01-05 | St. Landry | Louisiana | 22097 | 15435 | 353 |
2081036 | 2081036 | 2022-01-04 | St. Landry | Louisiana | 22097 | 15317 | 353 |
2077784 | 2077784 | 2022-01-03 | St. Landry | Louisiana | 22097 | 15214 | 353 |
2074533 | 2074533 | 2022-01-02 | St. Landry | Louisiana | 22097 | 14894 | 352 |
2071282 | 2071282 | 2022-01-01 | St. Landry | Louisiana | 22097 | 14894 | 352 |
2068031 | 2068031 | 2021-12-31 | St. Landry | Louisiana | 22097 | 14894 | 352 |
2064780 | 2064780 | 2021-12-30 | St. Landry | Louisiana | 22097 | 14894 | 352 |
2061530 | 2061530 | 2021-12-29 | St. Landry | Louisiana | 22097 | 14788 | 352 |
2058281 | 2058281 | 2021-12-28 | St. Landry | Louisiana | 22097 | 14703 | 352 |
2055032 | 2055032 | 2021-12-27 | St. Landry | Louisiana | 22097 | 14683 | 352 |
2051782 | 2051782 | 2021-12-26 | St. Landry | Louisiana | 22097 | 14594 | 352 |
2048532 | 2048532 | 2021-12-25 | St. Landry | Louisiana | 22097 | 14594 | 352 |
2045282 | 2045282 | 2021-12-24 | St. Landry | Louisiana | 22097 | 14594 | 352 |
2042033 | 2042033 | 2021-12-23 | St. Landry | Louisiana | 22097 | 14594 | 352 |
2038783 | 2038783 | 2021-12-22 | St. Landry | Louisiana | 22097 | 14577 | 352 |
2035533 | 2035533 | 2021-12-21 | St. Landry | Louisiana | 22097 | 14555 | 352 |
2032283 | 2032283 | 2021-12-20 | St. Landry | Louisiana | 22097 | 14547 | 352 |
2029032 | 2029032 | 2021-12-19 | St. Landry | Louisiana | 22097 | 14523 | 352 |
2025781 | 2025781 | 2021-12-18 | St. Landry | Louisiana | 22097 | 14523 | 352 |
2022530 | 2022530 | 2021-12-17 | St. Landry | Louisiana | 22097 | 14523 | 352 |
2019279 | 2019279 | 2021-12-16 | St. Landry | Louisiana | 22097 | 14514 | 351 |
2016029 | 2016029 | 2021-12-15 | St. Landry | Louisiana | 22097 | 14503 | 351 |
2012778 | 2012778 | 2021-12-14 | St. Landry | Louisiana | 22097 | 14493 | 351 |
2009527 | 2009527 | 2021-12-13 | St. Landry | Louisiana | 22097 | 14483 | 351 |
2006276 | 2006276 | 2021-12-12 | St. Landry | Louisiana | 22097 | 14469 | 351 |
2003025 | 2003025 | 2021-12-11 | St. Landry | Louisiana | 22097 | 14469 | 351 |
1999775 | 1999775 | 2021-12-10 | St. Landry | Louisiana | 22097 | 14469 | 351 |
1996524 | 1996524 | 2021-12-09 | St. Landry | Louisiana | 22097 | 14462 | 351 |
1993273 | 1993273 | 2021-12-08 | St. Landry | Louisiana | 22097 | 14453 | 351 |
1990022 | 1990022 | 2021-12-07 | St. Landry | Louisiana | 22097 | 14443 | 350 |
1986772 | 1986772 | 2021-12-06 | St. Landry | Louisiana | 22097 | 14432 | 350 |
1983522 | 1983522 | 2021-12-05 | St. Landry | Louisiana | 22097 | 14417 | 350 |
1980272 | 1980272 | 2021-12-04 | St. Landry | Louisiana | 22097 | 14417 | 350 |
1977022 | 1977022 | 2021-12-03 | St. Landry | Louisiana | 22097 | 14417 | 350 |
1973773 | 1973773 | 2021-12-02 | St. Landry | Louisiana | 22097 | 14413 | 350 |
1970523 | 1970523 | 2021-12-01 | St. Landry | Louisiana | 22097 | 14410 | 350 |
1967273 | 1967273 | 2021-11-30 | St. Landry | Louisiana | 22097 | 14393 | 350 |
1964021 | 1964021 | 2021-11-29 | St. Landry | Louisiana | 22097 | 14389 | 350 |
1960770 | 1960770 | 2021-11-28 | St. Landry | Louisiana | 22097 | 14356 | 349 |
1957519 | 1957519 | 2021-11-27 | St. Landry | Louisiana | 22097 | 14356 | 349 |
1954268 | 1954268 | 2021-11-26 | St. Landry | Louisiana | 22097 | 14356 | 349 |
1951017 | 1951017 | 2021-11-25 | St. Landry | Louisiana | 22097 | 14356 | 349 |
1947766 | 1947766 | 2021-11-24 | St. Landry | Louisiana | 22097 | 14356 | 349 |
1944515 | 1944515 | 2021-11-23 | St. Landry | Louisiana | 22097 | 14348 | 349 |
1941265 | 1941265 | 2021-11-22 | St. Landry | Louisiana | 22097 | 14325 | 347 |
1938015 | 1938015 | 2021-11-21 | St. Landry | Louisiana | 22097 | 14313 | 347 |
1934765 | 1934765 | 2021-11-20 | St. Landry | Louisiana | 22097 | 14313 | 347 |
1931514 | 1931514 | 2021-11-19 | St. Landry | Louisiana | 22097 | 14313 | 347 |
1928263 | 1928263 | 2021-11-18 | St. Landry | Louisiana | 22097 | 14302 | 347 |
1925013 | 1925013 | 2021-11-17 | St. Landry | Louisiana | 22097 | 14296 | 347 |
1921764 | 1921764 | 2021-11-16 | St. Landry | Louisiana | 22097 | 14280 | 347 |
1918514 | 1918514 | 2021-11-15 | St. Landry | Louisiana | 22097 | 14277 | 347 |
1915264 | 1915264 | 2021-11-14 | St. Landry | Louisiana | 22097 | 14258 | 347 |
1912014 | 1912014 | 2021-11-13 | St. Landry | Louisiana | 22097 | 14258 | 347 |
1908765 | 1908765 | 2021-11-12 | St. Landry | Louisiana | 22097 | 14258 | 347 |
1905516 | 1905516 | 2021-11-11 | St. Landry | Louisiana | 22097 | 14242 | 347 |
1902266 | 1902266 | 2021-11-10 | St. Landry | Louisiana | 22097 | 14242 | 347 |
1899016 | 1899016 | 2021-11-09 | St. Landry | Louisiana | 22097 | 14227 | 347 |
1895766 | 1895766 | 2021-11-08 | St. Landry | Louisiana | 22097 | 14221 | 347 |
1892516 | 1892516 | 2021-11-07 | St. Landry | Louisiana | 22097 | 14188 | 346 |
1889266 | 1889266 | 2021-11-06 | St. Landry | Louisiana | 22097 | 14188 | 346 |
1886016 | 1886016 | 2021-11-05 | St. Landry | Louisiana | 22097 | 14188 | 346 |
1882767 | 1882767 | 2021-11-04 | St. Landry | Louisiana | 22097 | 14177 | 346 |
1879518 | 1879518 | 2021-11-03 | St. Landry | Louisiana | 22097 | 14161 | 346 |
1876269 | 1876269 | 2021-11-02 | St. Landry | Louisiana | 22097 | 14144 | 346 |
1873020 | 1873020 | 2021-11-01 | St. Landry | Louisiana | 22097 | 14134 | 346 |
1869771 | 1869771 | 2021-10-31 | St. Landry | Louisiana | 22097 | 14103 | 345 |
1866522 | 1866522 | 2021-10-30 | St. Landry | Louisiana | 22097 | 14103 | 345 |
1863273 | 1863273 | 2021-10-29 | St. Landry | Louisiana | 22097 | 14103 | 345 |
1860024 | 1860024 | 2021-10-28 | St. Landry | Louisiana | 22097 | 14095 | 344 |
1856775 | 1856775 | 2021-10-27 | St. Landry | Louisiana | 22097 | 14081 | 344 |
1853526 | 1853526 | 2021-10-26 | St. Landry | Louisiana | 22097 | 14048 | 344 |
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);