ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "St. Charles" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175361 | 2175361 | 2022-02-02 | St. Charles | Louisiana | 22089 | 13421 | 135 |
2172108 | 2172108 | 2022-02-01 | St. Charles | Louisiana | 22089 | 13366 | 135 |
2168855 | 2168855 | 2022-01-31 | St. Charles | Louisiana | 22089 | 13318 | 135 |
2165600 | 2165600 | 2022-01-30 | St. Charles | Louisiana | 22089 | 13244 | 135 |
2162345 | 2162345 | 2022-01-29 | St. Charles | Louisiana | 22089 | 13244 | 135 |
2159090 | 2159090 | 2022-01-28 | St. Charles | Louisiana | 22089 | 13244 | 135 |
2155836 | 2155836 | 2022-01-27 | St. Charles | Louisiana | 22089 | 13199 | 133 |
2152583 | 2152583 | 2022-01-26 | St. Charles | Louisiana | 22089 | 13150 | 133 |
2149331 | 2149331 | 2022-01-25 | St. Charles | Louisiana | 22089 | 12532 | 133 |
2146079 | 2146079 | 2022-01-24 | St. Charles | Louisiana | 22089 | 12496 | 133 |
2142824 | 2142824 | 2022-01-23 | St. Charles | Louisiana | 22089 | 12367 | 132 |
2139569 | 2139569 | 2022-01-22 | St. Charles | Louisiana | 22089 | 12367 | 132 |
2136313 | 2136313 | 2022-01-21 | St. Charles | Louisiana | 22089 | 12367 | 132 |
2133061 | 2133061 | 2022-01-20 | St. Charles | Louisiana | 22089 | 12275 | 131 |
2129808 | 2129808 | 2022-01-19 | St. Charles | Louisiana | 22089 | 12210 | 131 |
2126554 | 2126554 | 2022-01-18 | St. Charles | Louisiana | 22089 | 12048 | 130 |
2123302 | 2123302 | 2022-01-17 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2120050 | 2120050 | 2022-01-16 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2116798 | 2116798 | 2022-01-15 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2113547 | 2113547 | 2022-01-14 | St. Charles | Louisiana | 22089 | 11761 | 129 |
2110295 | 2110295 | 2022-01-13 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2107044 | 2107044 | 2022-01-12 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2103793 | 2103793 | 2022-01-11 | St. Charles | Louisiana | 22089 | 11238 | 129 |
2100542 | 2100542 | 2022-01-10 | St. Charles | Louisiana | 22089 | 11150 | 129 |
2097291 | 2097291 | 2022-01-09 | St. Charles | Louisiana | 22089 | 10784 | 129 |
2094039 | 2094039 | 2022-01-08 | St. Charles | Louisiana | 22089 | 10784 | 129 |
2090787 | 2090787 | 2022-01-07 | St. Charles | Louisiana | 22089 | 10784 | 129 |
2087536 | 2087536 | 2022-01-06 | St. Charles | Louisiana | 22089 | 10594 | 128 |
2084284 | 2084284 | 2022-01-05 | St. Charles | Louisiana | 22089 | 10467 | 128 |
2081032 | 2081032 | 2022-01-04 | St. Charles | Louisiana | 22089 | 10333 | 128 |
2077780 | 2077780 | 2022-01-03 | St. Charles | Louisiana | 22089 | 10210 | 128 |
2074529 | 2074529 | 2022-01-02 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2071278 | 2071278 | 2022-01-01 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2068027 | 2068027 | 2021-12-31 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2064776 | 2064776 | 2021-12-30 | St. Charles | Louisiana | 22089 | 9784 | 128 |
2061526 | 2061526 | 2021-12-29 | St. Charles | Louisiana | 22089 | 9627 | 128 |
2058277 | 2058277 | 2021-12-28 | St. Charles | Louisiana | 22089 | 9529 | 128 |
2055028 | 2055028 | 2021-12-27 | St. Charles | Louisiana | 22089 | 9470 | 128 |
2051778 | 2051778 | 2021-12-26 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2048528 | 2048528 | 2021-12-25 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2045278 | 2045278 | 2021-12-24 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2042029 | 2042029 | 2021-12-23 | St. Charles | Louisiana | 22089 | 9294 | 128 |
2038779 | 2038779 | 2021-12-22 | St. Charles | Louisiana | 22089 | 9240 | 128 |
2035529 | 2035529 | 2021-12-21 | St. Charles | Louisiana | 22089 | 9203 | 128 |
2032279 | 2032279 | 2021-12-20 | St. Charles | Louisiana | 22089 | 9177 | 128 |
2029028 | 2029028 | 2021-12-19 | St. Charles | Louisiana | 22089 | 9125 | 128 |
2025777 | 2025777 | 2021-12-18 | St. Charles | Louisiana | 22089 | 9125 | 128 |
2022526 | 2022526 | 2021-12-17 | St. Charles | Louisiana | 22089 | 9125 | 128 |
2019275 | 2019275 | 2021-12-16 | St. Charles | Louisiana | 22089 | 9113 | 128 |
2016025 | 2016025 | 2021-12-15 | St. Charles | Louisiana | 22089 | 9102 | 128 |
2012774 | 2012774 | 2021-12-14 | St. Charles | Louisiana | 22089 | 9088 | 128 |
2009523 | 2009523 | 2021-12-13 | St. Charles | Louisiana | 22089 | 9084 | 128 |
2006272 | 2006272 | 2021-12-12 | St. Charles | Louisiana | 22089 | 9045 | 128 |
2003021 | 2003021 | 2021-12-11 | St. Charles | Louisiana | 22089 | 9045 | 128 |
1999771 | 1999771 | 2021-12-10 | St. Charles | Louisiana | 22089 | 9045 | 128 |
1996520 | 1996520 | 2021-12-09 | St. Charles | Louisiana | 22089 | 9035 | 128 |
1993269 | 1993269 | 2021-12-08 | St. Charles | Louisiana | 22089 | 9022 | 128 |
1990018 | 1990018 | 2021-12-07 | St. Charles | Louisiana | 22089 | 9013 | 128 |
1986768 | 1986768 | 2021-12-06 | St. Charles | Louisiana | 22089 | 9005 | 128 |
1983518 | 1983518 | 2021-12-05 | St. Charles | Louisiana | 22089 | 8998 | 128 |
1980268 | 1980268 | 2021-12-04 | St. Charles | Louisiana | 22089 | 8998 | 128 |
1977018 | 1977018 | 2021-12-03 | St. Charles | Louisiana | 22089 | 8998 | 128 |
1973769 | 1973769 | 2021-12-02 | St. Charles | Louisiana | 22089 | 8996 | 128 |
1970519 | 1970519 | 2021-12-01 | St. Charles | Louisiana | 22089 | 8992 | 128 |
1967269 | 1967269 | 2021-11-30 | St. Charles | Louisiana | 22089 | 8987 | 127 |
1964017 | 1964017 | 2021-11-29 | St. Charles | Louisiana | 22089 | 8967 | 127 |
1960766 | 1960766 | 2021-11-28 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1957515 | 1957515 | 2021-11-27 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1954264 | 1954264 | 2021-11-26 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1951013 | 1951013 | 2021-11-25 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1947762 | 1947762 | 2021-11-24 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1944511 | 1944511 | 2021-11-23 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1941261 | 1941261 | 2021-11-22 | St. Charles | Louisiana | 22089 | 8941 | 127 |
1938011 | 1938011 | 2021-11-21 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1934761 | 1934761 | 2021-11-20 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1931510 | 1931510 | 2021-11-19 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1928259 | 1928259 | 2021-11-18 | St. Charles | Louisiana | 22089 | 8933 | 127 |
1925009 | 1925009 | 2021-11-17 | St. Charles | Louisiana | 22089 | 8927 | 127 |
1921760 | 1921760 | 2021-11-16 | St. Charles | Louisiana | 22089 | 8925 | 127 |
1918510 | 1918510 | 2021-11-15 | St. Charles | Louisiana | 22089 | 8923 | 127 |
1915260 | 1915260 | 2021-11-14 | St. Charles | Louisiana | 22089 | 8921 | 127 |
1912010 | 1912010 | 2021-11-13 | St. Charles | Louisiana | 22089 | 8921 | 127 |
1908761 | 1908761 | 2021-11-12 | St. Charles | Louisiana | 22089 | 8921 | 127 |
1905512 | 1905512 | 2021-11-11 | St. Charles | Louisiana | 22089 | 8911 | 127 |
1902262 | 1902262 | 2021-11-10 | St. Charles | Louisiana | 22089 | 8911 | 127 |
1899012 | 1899012 | 2021-11-09 | St. Charles | Louisiana | 22089 | 8910 | 127 |
1895762 | 1895762 | 2021-11-08 | St. Charles | Louisiana | 22089 | 8910 | 127 |
1892512 | 1892512 | 2021-11-07 | St. Charles | Louisiana | 22089 | 8904 | 127 |
1889262 | 1889262 | 2021-11-06 | St. Charles | Louisiana | 22089 | 8904 | 127 |
1886012 | 1886012 | 2021-11-05 | St. Charles | Louisiana | 22089 | 8904 | 127 |
1882763 | 1882763 | 2021-11-04 | St. Charles | Louisiana | 22089 | 8896 | 127 |
1879514 | 1879514 | 2021-11-03 | St. Charles | Louisiana | 22089 | 8894 | 127 |
1876265 | 1876265 | 2021-11-02 | St. Charles | Louisiana | 22089 | 8890 | 127 |
1873016 | 1873016 | 2021-11-01 | St. Charles | Louisiana | 22089 | 8888 | 127 |
1869767 | 1869767 | 2021-10-31 | St. Charles | Louisiana | 22089 | 8872 | 127 |
1866518 | 1866518 | 2021-10-30 | St. Charles | Louisiana | 22089 | 8872 | 127 |
1863269 | 1863269 | 2021-10-29 | St. Charles | Louisiana | 22089 | 8872 | 127 |
1860020 | 1860020 | 2021-10-28 | St. Charles | Louisiana | 22089 | 8869 | 127 |
1856771 | 1856771 | 2021-10-27 | St. Charles | Louisiana | 22089 | 8867 | 127 |
1853522 | 1853522 | 2021-10-26 | St. Charles | Louisiana | 22089 | 8865 | 127 |
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);