ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
796 rows where fips = 22051 and state = "Louisiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2110276 | 2110276 | 2022-01-13 | Jefferson | Louisiana | 22051 | 92879 | 1202 |
2107025 | 2107025 | 2022-01-12 | Jefferson | Louisiana | 22051 | 92879 | 1202 |
2103774 | 2103774 | 2022-01-11 | Jefferson | Louisiana | 22051 | 92879 | 1202 |
2100523 | 2100523 | 2022-01-10 | Jefferson | Louisiana | 22051 | 91870 | 1200 |
2097272 | 2097272 | 2022-01-09 | Jefferson | Louisiana | 22051 | 87861 | 1198 |
2094020 | 2094020 | 2022-01-08 | Jefferson | Louisiana | 22051 | 87861 | 1198 |
2090768 | 2090768 | 2022-01-07 | Jefferson | Louisiana | 22051 | 87861 | 1198 |
2087517 | 2087517 | 2022-01-06 | Jefferson | Louisiana | 22051 | 86247 | 1197 |
2084265 | 2084265 | 2022-01-05 | Jefferson | Louisiana | 22051 | 84692 | 1195 |
2081013 | 2081013 | 2022-01-04 | Jefferson | Louisiana | 22051 | 83489 | 1195 |
2077761 | 2077761 | 2022-01-03 | Jefferson | Louisiana | 22051 | 82443 | 1193 |
2074510 | 2074510 | 2022-01-02 | Jefferson | Louisiana | 22051 | 77982 | 1193 |
2071259 | 2071259 | 2022-01-01 | Jefferson | Louisiana | 22051 | 77982 | 1193 |
2068008 | 2068008 | 2021-12-31 | Jefferson | Louisiana | 22051 | 77982 | 1193 |
2064757 | 2064757 | 2021-12-30 | Jefferson | Louisiana | 22051 | 77982 | 1193 |
2061507 | 2061507 | 2021-12-29 | Jefferson | Louisiana | 22051 | 76571 | 1192 |
2058258 | 2058258 | 2021-12-28 | Jefferson | Louisiana | 22051 | 75466 | 1192 |
2055009 | 2055009 | 2021-12-27 | Jefferson | Louisiana | 22051 | 74885 | 1191 |
2051759 | 2051759 | 2021-12-26 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2048509 | 2048509 | 2021-12-25 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2045259 | 2045259 | 2021-12-24 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2042010 | 2042010 | 2021-12-23 | Jefferson | Louisiana | 22051 | 72750 | 1191 |
2038760 | 2038760 | 2021-12-22 | Jefferson | Louisiana | 22051 | 72302 | 1191 |
2035510 | 2035510 | 2021-12-21 | Jefferson | Louisiana | 22051 | 71942 | 1188 |
2032260 | 2032260 | 2021-12-20 | Jefferson | Louisiana | 22051 | 71715 | 1188 |
2029009 | 2029009 | 2021-12-19 | Jefferson | Louisiana | 22051 | 71240 | 1187 |
2025758 | 2025758 | 2021-12-18 | Jefferson | Louisiana | 22051 | 71240 | 1187 |
2022507 | 2022507 | 2021-12-17 | Jefferson | Louisiana | 22051 | 71240 | 1187 |
2019256 | 2019256 | 2021-12-16 | Jefferson | Louisiana | 22051 | 71086 | 1187 |
2016006 | 2016006 | 2021-12-15 | Jefferson | Louisiana | 22051 | 70980 | 1186 |
2012755 | 2012755 | 2021-12-14 | Jefferson | Louisiana | 22051 | 70908 | 1183 |
2009504 | 2009504 | 2021-12-13 | Jefferson | Louisiana | 22051 | 70858 | 1183 |
2006253 | 2006253 | 2021-12-12 | Jefferson | Louisiana | 22051 | 70741 | 1183 |
2003002 | 2003002 | 2021-12-11 | Jefferson | Louisiana | 22051 | 70741 | 1183 |
1999752 | 1999752 | 2021-12-10 | Jefferson | Louisiana | 22051 | 70741 | 1183 |
1996501 | 1996501 | 2021-12-09 | Jefferson | Louisiana | 22051 | 70701 | 1182 |
1993250 | 1993250 | 2021-12-08 | Jefferson | Louisiana | 22051 | 70660 | 1182 |
1989999 | 1989999 | 2021-12-07 | Jefferson | Louisiana | 22051 | 70615 | 1180 |
1986749 | 1986749 | 2021-12-06 | Jefferson | Louisiana | 22051 | 70582 | 1180 |
1983499 | 1983499 | 2021-12-05 | Jefferson | Louisiana | 22051 | 70500 | 1177 |
1980249 | 1980249 | 2021-12-04 | Jefferson | Louisiana | 22051 | 70500 | 1177 |
1976999 | 1976999 | 2021-12-03 | Jefferson | Louisiana | 22051 | 70500 | 1177 |
1973750 | 1973750 | 2021-12-02 | Jefferson | Louisiana | 22051 | 70469 | 1177 |
1970500 | 1970500 | 2021-12-01 | Jefferson | Louisiana | 22051 | 70427 | 1177 |
1967250 | 1967250 | 2021-11-30 | Jefferson | Louisiana | 22051 | 70373 | 1180 |
1963998 | 1963998 | 2021-11-29 | Jefferson | Louisiana | 22051 | 70320 | 1180 |
1960747 | 1960747 | 2021-11-28 | Jefferson | Louisiana | 22051 | 70252 | 1180 |
1957496 | 1957496 | 2021-11-27 | Jefferson | Louisiana | 22051 | 70252 | 1180 |
1954245 | 1954245 | 2021-11-26 | Jefferson | Louisiana | 22051 | 70252 | 1180 |
1950994 | 1950994 | 2021-11-25 | Jefferson | Louisiana | 22051 | 70252 | 1180 |
1947743 | 1947743 | 2021-11-24 | Jefferson | Louisiana | 22051 | 70252 | 1180 |
1944492 | 1944492 | 2021-11-23 | Jefferson | Louisiana | 22051 | 70233 | 1180 |
1941242 | 1941242 | 2021-11-22 | Jefferson | Louisiana | 22051 | 70208 | 1180 |
1937992 | 1937992 | 2021-11-21 | Jefferson | Louisiana | 22051 | 70155 | 1180 |
1934742 | 1934742 | 2021-11-20 | Jefferson | Louisiana | 22051 | 70155 | 1180 |
1931491 | 1931491 | 2021-11-19 | Jefferson | Louisiana | 22051 | 70155 | 1180 |
1928240 | 1928240 | 2021-11-18 | Jefferson | Louisiana | 22051 | 70127 | 1180 |
1924990 | 1924990 | 2021-11-17 | Jefferson | Louisiana | 22051 | 70092 | 1179 |
1921741 | 1921741 | 2021-11-16 | Jefferson | Louisiana | 22051 | 70067 | 1177 |
1918491 | 1918491 | 2021-11-15 | Jefferson | Louisiana | 22051 | 70040 | 1177 |
1915241 | 1915241 | 2021-11-14 | Jefferson | Louisiana | 22051 | 69968 | 1177 |
1911991 | 1911991 | 2021-11-13 | Jefferson | Louisiana | 22051 | 69968 | 1177 |
1908742 | 1908742 | 2021-11-12 | Jefferson | Louisiana | 22051 | 69968 | 1177 |
1905493 | 1905493 | 2021-11-11 | Jefferson | Louisiana | 22051 | 69915 | 1176 |
1902243 | 1902243 | 2021-11-10 | Jefferson | Louisiana | 22051 | 69915 | 1176 |
1898993 | 1898993 | 2021-11-09 | Jefferson | Louisiana | 22051 | 69897 | 1175 |
1895743 | 1895743 | 2021-11-08 | Jefferson | Louisiana | 22051 | 69876 | 1176 |
1892493 | 1892493 | 2021-11-07 | Jefferson | Louisiana | 22051 | 69813 | 1175 |
1889243 | 1889243 | 2021-11-06 | Jefferson | Louisiana | 22051 | 69813 | 1175 |
1885993 | 1885993 | 2021-11-05 | Jefferson | Louisiana | 22051 | 69813 | 1175 |
1882744 | 1882744 | 2021-11-04 | Jefferson | Louisiana | 22051 | 69660 | 1173 |
1879495 | 1879495 | 2021-11-03 | Jefferson | Louisiana | 22051 | 69621 | 1172 |
1876246 | 1876246 | 2021-11-02 | Jefferson | Louisiana | 22051 | 69593 | 1169 |
1872997 | 1872997 | 2021-11-01 | Jefferson | Louisiana | 22051 | 69576 | 1167 |
1869748 | 1869748 | 2021-10-31 | Jefferson | Louisiana | 22051 | 69518 | 1167 |
1866499 | 1866499 | 2021-10-30 | Jefferson | Louisiana | 22051 | 69518 | 1167 |
1863250 | 1863250 | 2021-10-29 | Jefferson | Louisiana | 22051 | 69518 | 1167 |
1860001 | 1860001 | 2021-10-28 | Jefferson | Louisiana | 22051 | 69492 | 1162 |
1856752 | 1856752 | 2021-10-27 | Jefferson | Louisiana | 22051 | 69468 | 1162 |
1853503 | 1853503 | 2021-10-26 | Jefferson | Louisiana | 22051 | 69429 | 1162 |
1850254 | 1850254 | 2021-10-25 | Jefferson | Louisiana | 22051 | 69406 | 1160 |
1847004 | 1847004 | 2021-10-24 | Jefferson | Louisiana | 22051 | 69330 | 1158 |
1843754 | 1843754 | 2021-10-23 | Jefferson | Louisiana | 22051 | 69330 | 1158 |
1840504 | 1840504 | 2021-10-22 | Jefferson | Louisiana | 22051 | 69330 | 1158 |
1837255 | 1837255 | 2021-10-21 | Jefferson | Louisiana | 22051 | 69295 | 1156 |
1834006 | 1834006 | 2021-10-20 | Jefferson | Louisiana | 22051 | 69255 | 1156 |
1830757 | 1830757 | 2021-10-19 | Jefferson | Louisiana | 22051 | 69218 | 1154 |
1827508 | 1827508 | 2021-10-18 | Jefferson | Louisiana | 22051 | 69187 | 1151 |
1824259 | 1824259 | 2021-10-17 | Jefferson | Louisiana | 22051 | 69122 | 1150 |
1821010 | 1821010 | 2021-10-16 | Jefferson | Louisiana | 22051 | 69122 | 1150 |
1817761 | 1817761 | 2021-10-15 | Jefferson | Louisiana | 22051 | 69122 | 1150 |
1814513 | 1814513 | 2021-10-14 | Jefferson | Louisiana | 22051 | 69076 | 1149 |
1811264 | 1811264 | 2021-10-13 | Jefferson | Louisiana | 22051 | 69014 | 1147 |
1808015 | 1808015 | 2021-10-12 | Jefferson | Louisiana | 22051 | 68976 | 1144 |
1804764 | 1804764 | 2021-10-11 | Jefferson | Louisiana | 22051 | 68939 | 1143 |
1801515 | 1801515 | 2021-10-10 | Jefferson | Louisiana | 22051 | 68849 | 1142 |
1798266 | 1798266 | 2021-10-09 | Jefferson | Louisiana | 22051 | 68849 | 1142 |
1795017 | 1795017 | 2021-10-08 | Jefferson | Louisiana | 22051 | 68849 | 1142 |
1791769 | 1791769 | 2021-10-07 | Jefferson | Louisiana | 22051 | 68806 | 1139 |
1788520 | 1788520 | 2021-10-06 | Jefferson | Louisiana | 22051 | 68772 | 1137 |
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);