ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Caddo" and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175325 | 2175325 | 2022-02-02 | Caddo | Louisiana | 22017 | 65124 | 1041 |
2172072 | 2172072 | 2022-02-01 | Caddo | Louisiana | 22017 | 64850 | 1041 |
2168819 | 2168819 | 2022-01-31 | Caddo | Louisiana | 22017 | 64581 | 1031 |
2165564 | 2165564 | 2022-01-30 | Caddo | Louisiana | 22017 | 63932 | 1029 |
2162309 | 2162309 | 2022-01-29 | Caddo | Louisiana | 22017 | 63932 | 1029 |
2159054 | 2159054 | 2022-01-28 | Caddo | Louisiana | 22017 | 63932 | 1029 |
2155800 | 2155800 | 2022-01-27 | Caddo | Louisiana | 22017 | 63555 | 1028 |
2152547 | 2152547 | 2022-01-26 | Caddo | Louisiana | 22017 | 63102 | 1026 |
2149295 | 2149295 | 2022-01-25 | Caddo | Louisiana | 22017 | 59432 | 1022 |
2146043 | 2146043 | 2022-01-24 | Caddo | Louisiana | 22017 | 59117 | 1015 |
2142788 | 2142788 | 2022-01-23 | Caddo | Louisiana | 22017 | 58155 | 1008 |
2139533 | 2139533 | 2022-01-22 | Caddo | Louisiana | 22017 | 58155 | 1008 |
2136277 | 2136277 | 2022-01-21 | Caddo | Louisiana | 22017 | 58155 | 1008 |
2133025 | 2133025 | 2022-01-20 | Caddo | Louisiana | 22017 | 57493 | 1004 |
2129772 | 2129772 | 2022-01-19 | Caddo | Louisiana | 22017 | 56785 | 1004 |
2126518 | 2126518 | 2022-01-18 | Caddo | Louisiana | 22017 | 56228 | 1001 |
2123266 | 2123266 | 2022-01-17 | Caddo | Louisiana | 22017 | 54330 | 1000 |
2120014 | 2120014 | 2022-01-16 | Caddo | Louisiana | 22017 | 54330 | 1000 |
2116762 | 2116762 | 2022-01-15 | Caddo | Louisiana | 22017 | 54330 | 1000 |
2113511 | 2113511 | 2022-01-14 | Caddo | Louisiana | 22017 | 54330 | 1000 |
2110259 | 2110259 | 2022-01-13 | Caddo | Louisiana | 22017 | 51919 | 1000 |
2107008 | 2107008 | 2022-01-12 | Caddo | Louisiana | 22017 | 51919 | 1000 |
2103757 | 2103757 | 2022-01-11 | Caddo | Louisiana | 22017 | 51919 | 1000 |
2100506 | 2100506 | 2022-01-10 | Caddo | Louisiana | 22017 | 51278 | 996 |
2097255 | 2097255 | 2022-01-09 | Caddo | Louisiana | 22017 | 49545 | 993 |
2094003 | 2094003 | 2022-01-08 | Caddo | Louisiana | 22017 | 49545 | 993 |
2090751 | 2090751 | 2022-01-07 | Caddo | Louisiana | 22017 | 49545 | 993 |
2087500 | 2087500 | 2022-01-06 | Caddo | Louisiana | 22017 | 48681 | 992 |
2084248 | 2084248 | 2022-01-05 | Caddo | Louisiana | 22017 | 47759 | 993 |
2080996 | 2080996 | 2022-01-04 | Caddo | Louisiana | 22017 | 47044 | 993 |
2077744 | 2077744 | 2022-01-03 | Caddo | Louisiana | 22017 | 46695 | 993 |
2074493 | 2074493 | 2022-01-02 | Caddo | Louisiana | 22017 | 44253 | 993 |
2071242 | 2071242 | 2022-01-01 | Caddo | Louisiana | 22017 | 44253 | 993 |
2067991 | 2067991 | 2021-12-31 | Caddo | Louisiana | 22017 | 44253 | 993 |
2064740 | 2064740 | 2021-12-30 | Caddo | Louisiana | 22017 | 44253 | 993 |
2061490 | 2061490 | 2021-12-29 | Caddo | Louisiana | 22017 | 43442 | 993 |
2058241 | 2058241 | 2021-12-28 | Caddo | Louisiana | 22017 | 42782 | 992 |
2054992 | 2054992 | 2021-12-27 | Caddo | Louisiana | 22017 | 42285 | 991 |
2051742 | 2051742 | 2021-12-26 | Caddo | Louisiana | 22017 | 41321 | 990 |
2048492 | 2048492 | 2021-12-25 | Caddo | Louisiana | 22017 | 41321 | 990 |
2045242 | 2045242 | 2021-12-24 | Caddo | Louisiana | 22017 | 41321 | 990 |
2041993 | 2041993 | 2021-12-23 | Caddo | Louisiana | 22017 | 41321 | 990 |
2038743 | 2038743 | 2021-12-22 | Caddo | Louisiana | 22017 | 41095 | 989 |
2035493 | 2035493 | 2021-12-21 | Caddo | Louisiana | 22017 | 40942 | 989 |
2032243 | 2032243 | 2021-12-20 | Caddo | Louisiana | 22017 | 40831 | 989 |
2028992 | 2028992 | 2021-12-19 | Caddo | Louisiana | 22017 | 40654 | 988 |
2025741 | 2025741 | 2021-12-18 | Caddo | Louisiana | 22017 | 40654 | 988 |
2022490 | 2022490 | 2021-12-17 | Caddo | Louisiana | 22017 | 40654 | 988 |
2019239 | 2019239 | 2021-12-16 | Caddo | Louisiana | 22017 | 40580 | 987 |
2015989 | 2015989 | 2021-12-15 | Caddo | Louisiana | 22017 | 40535 | 987 |
2012738 | 2012738 | 2021-12-14 | Caddo | Louisiana | 22017 | 40469 | 987 |
2009487 | 2009487 | 2021-12-13 | Caddo | Louisiana | 22017 | 40441 | 984 |
2006236 | 2006236 | 2021-12-12 | Caddo | Louisiana | 22017 | 40397 | 982 |
2002985 | 2002985 | 2021-12-11 | Caddo | Louisiana | 22017 | 40397 | 982 |
1999735 | 1999735 | 2021-12-10 | Caddo | Louisiana | 22017 | 40397 | 982 |
1996484 | 1996484 | 2021-12-09 | Caddo | Louisiana | 22017 | 40374 | 983 |
1993233 | 1993233 | 2021-12-08 | Caddo | Louisiana | 22017 | 40346 | 983 |
1989982 | 1989982 | 2021-12-07 | Caddo | Louisiana | 22017 | 40319 | 981 |
1986732 | 1986732 | 2021-12-06 | Caddo | Louisiana | 22017 | 40281 | 981 |
1983482 | 1983482 | 2021-12-05 | Caddo | Louisiana | 22017 | 40205 | 981 |
1980232 | 1980232 | 2021-12-04 | Caddo | Louisiana | 22017 | 40205 | 981 |
1976982 | 1976982 | 2021-12-03 | Caddo | Louisiana | 22017 | 40205 | 981 |
1973733 | 1973733 | 2021-12-02 | Caddo | Louisiana | 22017 | 40176 | 979 |
1970483 | 1970483 | 2021-12-01 | Caddo | Louisiana | 22017 | 40147 | 978 |
1967233 | 1967233 | 2021-11-30 | Caddo | Louisiana | 22017 | 40100 | 978 |
1963981 | 1963981 | 2021-11-29 | Caddo | Louisiana | 22017 | 40068 | 978 |
1960730 | 1960730 | 2021-11-28 | Caddo | Louisiana | 22017 | 39993 | 977 |
1957479 | 1957479 | 2021-11-27 | Caddo | Louisiana | 22017 | 39993 | 977 |
1954228 | 1954228 | 2021-11-26 | Caddo | Louisiana | 22017 | 39993 | 977 |
1950977 | 1950977 | 2021-11-25 | Caddo | Louisiana | 22017 | 39993 | 977 |
1947726 | 1947726 | 2021-11-24 | Caddo | Louisiana | 22017 | 39993 | 977 |
1944475 | 1944475 | 2021-11-23 | Caddo | Louisiana | 22017 | 39984 | 977 |
1941225 | 1941225 | 2021-11-22 | Caddo | Louisiana | 22017 | 39960 | 977 |
1937975 | 1937975 | 2021-11-21 | Caddo | Louisiana | 22017 | 39923 | 977 |
1934725 | 1934725 | 2021-11-20 | Caddo | Louisiana | 22017 | 39923 | 977 |
1931474 | 1931474 | 2021-11-19 | Caddo | Louisiana | 22017 | 39923 | 977 |
1928223 | 1928223 | 2021-11-18 | Caddo | Louisiana | 22017 | 39896 | 976 |
1924973 | 1924973 | 2021-11-17 | Caddo | Louisiana | 22017 | 39875 | 975 |
1921724 | 1921724 | 2021-11-16 | Caddo | Louisiana | 22017 | 39799 | 970 |
1918474 | 1918474 | 2021-11-15 | Caddo | Louisiana | 22017 | 39766 | 970 |
1915224 | 1915224 | 2021-11-14 | Caddo | Louisiana | 22017 | 39713 | 967 |
1911974 | 1911974 | 2021-11-13 | Caddo | Louisiana | 22017 | 39713 | 967 |
1908725 | 1908725 | 2021-11-12 | Caddo | Louisiana | 22017 | 39713 | 967 |
1905476 | 1905476 | 2021-11-11 | Caddo | Louisiana | 22017 | 39662 | 965 |
1902226 | 1902226 | 2021-11-10 | Caddo | Louisiana | 22017 | 39662 | 965 |
1898976 | 1898976 | 2021-11-09 | Caddo | Louisiana | 22017 | 39632 | 965 |
1895726 | 1895726 | 2021-11-08 | Caddo | Louisiana | 22017 | 39616 | 965 |
1892476 | 1892476 | 2021-11-07 | Caddo | Louisiana | 22017 | 39563 | 965 |
1889226 | 1889226 | 2021-11-06 | Caddo | Louisiana | 22017 | 39563 | 965 |
1885976 | 1885976 | 2021-11-05 | Caddo | Louisiana | 22017 | 39563 | 965 |
1882727 | 1882727 | 2021-11-04 | Caddo | Louisiana | 22017 | 39541 | 964 |
1879478 | 1879478 | 2021-11-03 | Caddo | Louisiana | 22017 | 39516 | 963 |
1876229 | 1876229 | 2021-11-02 | Caddo | Louisiana | 22017 | 39497 | 962 |
1872980 | 1872980 | 2021-11-01 | Caddo | Louisiana | 22017 | 39484 | 961 |
1869731 | 1869731 | 2021-10-31 | Caddo | Louisiana | 22017 | 39428 | 961 |
1866482 | 1866482 | 2021-10-30 | Caddo | Louisiana | 22017 | 39428 | 961 |
1863233 | 1863233 | 2021-10-29 | Caddo | Louisiana | 22017 | 39428 | 961 |
1859984 | 1859984 | 2021-10-28 | Caddo | Louisiana | 22017 | 39409 | 958 |
1856735 | 1856735 | 2021-10-27 | Caddo | Louisiana | 22017 | 39377 | 957 |
1853486 | 1853486 | 2021-10-26 | Caddo | Louisiana | 22017 | 39353 | 957 |
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);