ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 22027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175330 | 2175330 | 2022-02-02 | Claiborne | Louisiana | 22027 | 3101 | 68 |
2172077 | 2172077 | 2022-02-01 | Claiborne | Louisiana | 22027 | 3083 | 68 |
2168824 | 2168824 | 2022-01-31 | Claiborne | Louisiana | 22027 | 3068 | 67 |
2165569 | 2165569 | 2022-01-30 | Claiborne | Louisiana | 22027 | 3053 | 67 |
2162314 | 2162314 | 2022-01-29 | Claiborne | Louisiana | 22027 | 3053 | 67 |
2159059 | 2159059 | 2022-01-28 | Claiborne | Louisiana | 22027 | 3053 | 67 |
2155805 | 2155805 | 2022-01-27 | Claiborne | Louisiana | 22027 | 3030 | 67 |
2152552 | 2152552 | 2022-01-26 | Claiborne | Louisiana | 22027 | 3009 | 67 |
2149300 | 2149300 | 2022-01-25 | Claiborne | Louisiana | 22027 | 2836 | 67 |
2146048 | 2146048 | 2022-01-24 | Claiborne | Louisiana | 22027 | 2814 | 67 |
2142793 | 2142793 | 2022-01-23 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2139538 | 2139538 | 2022-01-22 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2136282 | 2136282 | 2022-01-21 | Claiborne | Louisiana | 22027 | 2778 | 67 |
2133030 | 2133030 | 2022-01-20 | Claiborne | Louisiana | 22027 | 2750 | 67 |
2129777 | 2129777 | 2022-01-19 | Claiborne | Louisiana | 22027 | 2721 | 67 |
2126523 | 2126523 | 2022-01-18 | Claiborne | Louisiana | 22027 | 2695 | 67 |
2123271 | 2123271 | 2022-01-17 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2120019 | 2120019 | 2022-01-16 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2116767 | 2116767 | 2022-01-15 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2113516 | 2113516 | 2022-01-14 | Claiborne | Louisiana | 22027 | 2558 | 67 |
2110264 | 2110264 | 2022-01-13 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2107013 | 2107013 | 2022-01-12 | Claiborne | Louisiana | 22027 | 2429 | 67 |
2103762 | 2103762 | 2022-01-11 | Claiborne | Louisiana | 22027 | 2429 | 66 |
2100511 | 2100511 | 2022-01-10 | Claiborne | Louisiana | 22027 | 2348 | 66 |
2097260 | 2097260 | 2022-01-09 | Claiborne | Louisiana | 22027 | 2284 | 66 |
2094008 | 2094008 | 2022-01-08 | Claiborne | Louisiana | 22027 | 2284 | 66 |
2090756 | 2090756 | 2022-01-07 | Claiborne | Louisiana | 22027 | 2284 | 66 |
2087505 | 2087505 | 2022-01-06 | Claiborne | Louisiana | 22027 | 2259 | 66 |
2084253 | 2084253 | 2022-01-05 | Claiborne | Louisiana | 22027 | 2207 | 66 |
2081001 | 2081001 | 2022-01-04 | Claiborne | Louisiana | 22027 | 2199 | 66 |
2077749 | 2077749 | 2022-01-03 | Claiborne | Louisiana | 22027 | 2189 | 66 |
2074498 | 2074498 | 2022-01-02 | Claiborne | Louisiana | 22027 | 2138 | 66 |
2071247 | 2071247 | 2022-01-01 | Claiborne | Louisiana | 22027 | 2138 | 66 |
2067996 | 2067996 | 2021-12-31 | Claiborne | Louisiana | 22027 | 2138 | 66 |
2064745 | 2064745 | 2021-12-30 | Claiborne | Louisiana | 22027 | 2138 | 66 |
2061495 | 2061495 | 2021-12-29 | Claiborne | Louisiana | 22027 | 2119 | 66 |
2058246 | 2058246 | 2021-12-28 | Claiborne | Louisiana | 22027 | 2106 | 66 |
2054997 | 2054997 | 2021-12-27 | Claiborne | Louisiana | 22027 | 2101 | 66 |
2051747 | 2051747 | 2021-12-26 | Claiborne | Louisiana | 22027 | 2080 | 66 |
2048497 | 2048497 | 2021-12-25 | Claiborne | Louisiana | 22027 | 2080 | 66 |
2045247 | 2045247 | 2021-12-24 | Claiborne | Louisiana | 22027 | 2080 | 66 |
2041998 | 2041998 | 2021-12-23 | Claiborne | Louisiana | 22027 | 2080 | 66 |
2038748 | 2038748 | 2021-12-22 | Claiborne | Louisiana | 22027 | 2077 | 66 |
2035498 | 2035498 | 2021-12-21 | Claiborne | Louisiana | 22027 | 2070 | 66 |
2032248 | 2032248 | 2021-12-20 | Claiborne | Louisiana | 22027 | 2070 | 66 |
2028997 | 2028997 | 2021-12-19 | Claiborne | Louisiana | 22027 | 2069 | 66 |
2025746 | 2025746 | 2021-12-18 | Claiborne | Louisiana | 22027 | 2069 | 66 |
2022495 | 2022495 | 2021-12-17 | Claiborne | Louisiana | 22027 | 2069 | 66 |
2019244 | 2019244 | 2021-12-16 | Claiborne | Louisiana | 22027 | 2069 | 66 |
2015994 | 2015994 | 2021-12-15 | Claiborne | Louisiana | 22027 | 2064 | 66 |
2012743 | 2012743 | 2021-12-14 | Claiborne | Louisiana | 22027 | 2061 | 66 |
2009492 | 2009492 | 2021-12-13 | Claiborne | Louisiana | 22027 | 2059 | 66 |
2006241 | 2006241 | 2021-12-12 | Claiborne | Louisiana | 22027 | 2058 | 66 |
2002990 | 2002990 | 2021-12-11 | Claiborne | Louisiana | 22027 | 2058 | 66 |
1999740 | 1999740 | 2021-12-10 | Claiborne | Louisiana | 22027 | 2058 | 66 |
1996489 | 1996489 | 2021-12-09 | Claiborne | Louisiana | 22027 | 2055 | 66 |
1993238 | 1993238 | 2021-12-08 | Claiborne | Louisiana | 22027 | 2050 | 66 |
1989987 | 1989987 | 2021-12-07 | Claiborne | Louisiana | 22027 | 2039 | 66 |
1986737 | 1986737 | 2021-12-06 | Claiborne | Louisiana | 22027 | 2038 | 66 |
1983487 | 1983487 | 2021-12-05 | Claiborne | Louisiana | 22027 | 2035 | 66 |
1980237 | 1980237 | 2021-12-04 | Claiborne | Louisiana | 22027 | 2035 | 66 |
1976987 | 1976987 | 2021-12-03 | Claiborne | Louisiana | 22027 | 2035 | 66 |
1973738 | 1973738 | 2021-12-02 | Claiborne | Louisiana | 22027 | 2034 | 66 |
1970488 | 1970488 | 2021-12-01 | Claiborne | Louisiana | 22027 | 2034 | 66 |
1967238 | 1967238 | 2021-11-30 | Claiborne | Louisiana | 22027 | 2032 | 66 |
1963986 | 1963986 | 2021-11-29 | Claiborne | Louisiana | 22027 | 2032 | 66 |
1960735 | 1960735 | 2021-11-28 | Claiborne | Louisiana | 22027 | 2030 | 66 |
1957484 | 1957484 | 2021-11-27 | Claiborne | Louisiana | 22027 | 2030 | 66 |
1954233 | 1954233 | 2021-11-26 | Claiborne | Louisiana | 22027 | 2030 | 66 |
1950982 | 1950982 | 2021-11-25 | Claiborne | Louisiana | 22027 | 2030 | 66 |
1947731 | 1947731 | 2021-11-24 | Claiborne | Louisiana | 22027 | 2030 | 66 |
1944480 | 1944480 | 2021-11-23 | Claiborne | Louisiana | 22027 | 2030 | 66 |
1941230 | 1941230 | 2021-11-22 | Claiborne | Louisiana | 22027 | 2026 | 66 |
1937980 | 1937980 | 2021-11-21 | Claiborne | Louisiana | 22027 | 2025 | 66 |
1934730 | 1934730 | 2021-11-20 | Claiborne | Louisiana | 22027 | 2025 | 66 |
1931479 | 1931479 | 2021-11-19 | Claiborne | Louisiana | 22027 | 2025 | 66 |
1928228 | 1928228 | 2021-11-18 | Claiborne | Louisiana | 22027 | 2024 | 66 |
1924978 | 1924978 | 2021-11-17 | Claiborne | Louisiana | 22027 | 2024 | 66 |
1921729 | 1921729 | 2021-11-16 | Claiborne | Louisiana | 22027 | 2021 | 66 |
1918479 | 1918479 | 2021-11-15 | Claiborne | Louisiana | 22027 | 2021 | 66 |
1915229 | 1915229 | 2021-11-14 | Claiborne | Louisiana | 22027 | 2020 | 66 |
1911979 | 1911979 | 2021-11-13 | Claiborne | Louisiana | 22027 | 2020 | 66 |
1908730 | 1908730 | 2021-11-12 | Claiborne | Louisiana | 22027 | 2020 | 66 |
1905481 | 1905481 | 2021-11-11 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1902231 | 1902231 | 2021-11-10 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1898981 | 1898981 | 2021-11-09 | Claiborne | Louisiana | 22027 | 2019 | 65 |
1895731 | 1895731 | 2021-11-08 | Claiborne | Louisiana | 22027 | 2019 | 64 |
1892481 | 1892481 | 2021-11-07 | Claiborne | Louisiana | 22027 | 2015 | 64 |
1889231 | 1889231 | 2021-11-06 | Claiborne | Louisiana | 22027 | 2015 | 64 |
1885981 | 1885981 | 2021-11-05 | Claiborne | Louisiana | 22027 | 2015 | 64 |
1882732 | 1882732 | 2021-11-04 | Claiborne | Louisiana | 22027 | 2015 | 63 |
1879483 | 1879483 | 2021-11-03 | Claiborne | Louisiana | 22027 | 2014 | 63 |
1876234 | 1876234 | 2021-11-02 | Claiborne | Louisiana | 22027 | 2013 | 63 |
1872985 | 1872985 | 2021-11-01 | Claiborne | Louisiana | 22027 | 2013 | 63 |
1869736 | 1869736 | 2021-10-31 | Claiborne | Louisiana | 22027 | 2011 | 63 |
1866487 | 1866487 | 2021-10-30 | Claiborne | Louisiana | 22027 | 2011 | 63 |
1863238 | 1863238 | 2021-10-29 | Claiborne | Louisiana | 22027 | 2011 | 63 |
1859989 | 1859989 | 2021-10-28 | Claiborne | Louisiana | 22027 | 2010 | 63 |
1856740 | 1856740 | 2021-10-27 | Claiborne | Louisiana | 22027 | 2008 | 63 |
1853491 | 1853491 | 2021-10-26 | Claiborne | Louisiana | 22027 | 2007 | 63 |
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);