ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where state = "District of Columbia" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1946918 | 1946918 | 2021-11-24 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1943667 | 1943667 | 2021-11-23 | District of Columbia | District of Columbia | 11001 | 66433 | 1196 |
1940417 | 1940417 | 2021-11-22 | District of Columbia | District of Columbia | 11001 | 66347 | 1196 |
1937167 | 1937167 | 2021-11-21 | District of Columbia | District of Columbia | 11001 | 66028 | 1196 |
1933917 | 1933917 | 2021-11-20 | District of Columbia | District of Columbia | 11001 | 66028 | 1196 |
1930665 | 1930665 | 2021-11-19 | District of Columbia | District of Columbia | 11001 | 66028 | 1196 |
1927415 | 1927415 | 2021-11-18 | District of Columbia | District of Columbia | 11001 | 65889 | 1196 |
1924165 | 1924165 | 2021-11-17 | District of Columbia | District of Columbia | 11001 | 65793 | 1195 |
1920916 | 1920916 | 2021-11-16 | District of Columbia | District of Columbia | 11001 | 65707 | 1195 |
1917666 | 1917666 | 2021-11-15 | District of Columbia | District of Columbia | 11001 | 65623 | 1194 |
1914416 | 1914416 | 2021-11-14 | District of Columbia | District of Columbia | 11001 | 65371 | 1194 |
1911166 | 1911166 | 2021-11-13 | District of Columbia | District of Columbia | 11001 | 65371 | 1194 |
1907917 | 1907917 | 2021-11-12 | District of Columbia | District of Columbia | 11001 | 65371 | 1194 |
1904668 | 1904668 | 2021-11-11 | District of Columbia | District of Columbia | 11001 | 65159 | 1193 |
1901418 | 1901418 | 2021-11-10 | District of Columbia | District of Columbia | 11001 | 65159 | 1193 |
1898168 | 1898168 | 2021-11-09 | District of Columbia | District of Columbia | 11001 | 65094 | 1193 |
1894918 | 1894918 | 2021-11-08 | District of Columbia | District of Columbia | 11001 | 65050 | 1193 |
1891668 | 1891668 | 2021-11-07 | District of Columbia | District of Columbia | 11001 | 64799 | 1193 |
1888418 | 1888418 | 2021-11-06 | District of Columbia | District of Columbia | 11001 | 64799 | 1193 |
1885168 | 1885168 | 2021-11-05 | District of Columbia | District of Columbia | 11001 | 64799 | 1193 |
1881919 | 1881919 | 2021-11-04 | District of Columbia | District of Columbia | 11001 | 64708 | 1193 |
1878670 | 1878670 | 2021-11-03 | District of Columbia | District of Columbia | 11001 | 64602 | 1193 |
1875421 | 1875421 | 2021-11-02 | District of Columbia | District of Columbia | 11001 | 64541 | 1193 |
1872172 | 1872172 | 2021-11-01 | District of Columbia | District of Columbia | 11001 | 64470 | 1191 |
1868923 | 1868923 | 2021-10-31 | District of Columbia | District of Columbia | 11001 | 64240 | 1190 |
1865674 | 1865674 | 2021-10-30 | District of Columbia | District of Columbia | 11001 | 64240 | 1190 |
1862425 | 1862425 | 2021-10-29 | District of Columbia | District of Columbia | 11001 | 64240 | 1190 |
1859176 | 1859176 | 2021-10-28 | District of Columbia | District of Columbia | 11001 | 64108 | 1188 |
1855927 | 1855927 | 2021-10-27 | District of Columbia | District of Columbia | 11001 | 63990 | 1187 |
1852678 | 1852678 | 2021-10-26 | District of Columbia | District of Columbia | 11001 | 63919 | 1187 |
1849429 | 1849429 | 2021-10-25 | District of Columbia | District of Columbia | 11001 | 63879 | 1186 |
1846179 | 1846179 | 2021-10-24 | District of Columbia | District of Columbia | 11001 | 63588 | 1186 |
1842929 | 1842929 | 2021-10-23 | District of Columbia | District of Columbia | 11001 | 63588 | 1186 |
1839679 | 1839679 | 2021-10-22 | District of Columbia | District of Columbia | 11001 | 63588 | 1186 |
1836430 | 1836430 | 2021-10-21 | District of Columbia | District of Columbia | 11001 | 63474 | 1186 |
1833181 | 1833181 | 2021-10-20 | District of Columbia | District of Columbia | 11001 | 63400 | 1185 |
1829932 | 1829932 | 2021-10-19 | District of Columbia | District of Columbia | 11001 | 63345 | 1185 |
1826683 | 1826683 | 2021-10-18 | District of Columbia | District of Columbia | 11001 | 63305 | 1184 |
1823434 | 1823434 | 2021-10-17 | District of Columbia | District of Columbia | 11001 | 62976 | 1183 |
1820185 | 1820185 | 2021-10-16 | District of Columbia | District of Columbia | 11001 | 62976 | 1183 |
1816936 | 1816936 | 2021-10-15 | District of Columbia | District of Columbia | 11001 | 62976 | 1183 |
1813688 | 1813688 | 2021-10-14 | District of Columbia | District of Columbia | 11001 | 62852 | 1183 |
1810439 | 1810439 | 2021-10-13 | District of Columbia | District of Columbia | 11001 | 62750 | 1183 |
1807190 | 1807190 | 2021-10-12 | District of Columbia | District of Columbia | 11001 | 62702 | 1182 |
1803939 | 1803939 | 2021-10-11 | District of Columbia | District of Columbia | 11001 | 62266 | 1182 |
1800690 | 1800690 | 2021-10-10 | District of Columbia | District of Columbia | 11001 | 62266 | 1182 |
1797441 | 1797441 | 2021-10-09 | District of Columbia | District of Columbia | 11001 | 62266 | 1182 |
1794192 | 1794192 | 2021-10-08 | District of Columbia | District of Columbia | 11001 | 62266 | 1182 |
1790944 | 1790944 | 2021-10-07 | District of Columbia | District of Columbia | 11001 | 62098 | 1181 |
1787695 | 1787695 | 2021-10-06 | District of Columbia | District of Columbia | 11001 | 61978 | 1180 |
1784446 | 1784446 | 2021-10-05 | District of Columbia | District of Columbia | 11001 | 61863 | 1179 |
1781197 | 1781197 | 2021-10-04 | District of Columbia | District of Columbia | 11001 | 61791 | 1178 |
1777947 | 1777947 | 2021-10-03 | District of Columbia | District of Columbia | 11001 | 61331 | 1176 |
1774697 | 1774697 | 2021-10-02 | District of Columbia | District of Columbia | 11001 | 61331 | 1176 |
1771447 | 1771447 | 2021-10-01 | District of Columbia | District of Columbia | 11001 | 61331 | 1176 |
1768198 | 1768198 | 2021-09-30 | District of Columbia | District of Columbia | 11001 | 61153 | 1174 |
1764949 | 1764949 | 2021-09-29 | District of Columbia | District of Columbia | 11001 | 60996 | 1174 |
1761700 | 1761700 | 2021-09-28 | District of Columbia | District of Columbia | 11001 | 60898 | 1174 |
1758452 | 1758452 | 2021-09-27 | District of Columbia | District of Columbia | 11001 | 60772 | 1174 |
1755204 | 1755204 | 2021-09-26 | District of Columbia | District of Columbia | 11001 | 60205 | 1172 |
1751956 | 1751956 | 2021-09-25 | District of Columbia | District of Columbia | 11001 | 60205 | 1172 |
1748707 | 1748707 | 2021-09-24 | District of Columbia | District of Columbia | 11001 | 60205 | 1172 |
1745457 | 1745457 | 2021-09-23 | District of Columbia | District of Columbia | 11001 | 60018 | 1172 |
1742208 | 1742208 | 2021-09-22 | District of Columbia | District of Columbia | 11001 | 59849 | 1171 |
1738959 | 1738959 | 2021-09-21 | District of Columbia | District of Columbia | 11001 | 59712 | 1171 |
1735710 | 1735710 | 2021-09-20 | District of Columbia | District of Columbia | 11001 | 59563 | 1167 |
1732460 | 1732460 | 2021-09-19 | District of Columbia | District of Columbia | 11001 | 58851 | 1167 |
1729210 | 1729210 | 2021-09-18 | District of Columbia | District of Columbia | 11001 | 58851 | 1167 |
1725960 | 1725960 | 2021-09-17 | District of Columbia | District of Columbia | 11001 | 58851 | 1167 |
1722711 | 1722711 | 2021-09-16 | District of Columbia | District of Columbia | 11001 | 58649 | 1167 |
1719462 | 1719462 | 2021-09-15 | District of Columbia | District of Columbia | 11001 | 58440 | 1167 |
1716214 | 1716214 | 2021-09-14 | District of Columbia | District of Columbia | 11001 | 58146 | 1167 |
1712968 | 1712968 | 2021-09-13 | District of Columbia | District of Columbia | 11001 | 57771 | 1165 |
1709721 | 1709721 | 2021-09-12 | District of Columbia | District of Columbia | 11001 | 56966 | 1165 |
1706474 | 1706474 | 2021-09-11 | District of Columbia | District of Columbia | 11001 | 56966 | 1165 |
1703226 | 1703226 | 2021-09-10 | District of Columbia | District of Columbia | 11001 | 56966 | 1165 |
1699976 | 1699976 | 2021-09-09 | District of Columbia | District of Columbia | 11001 | 56859 | 1164 |
1696727 | 1696727 | 2021-09-08 | District of Columbia | District of Columbia | 11001 | 56694 | 1163 |
1693479 | 1693479 | 2021-09-07 | District of Columbia | District of Columbia | 11001 | 56569 | 1163 |
1690230 | 1690230 | 2021-09-06 | District of Columbia | District of Columbia | 11001 | 55918 | 1162 |
1686980 | 1686980 | 2021-09-05 | District of Columbia | District of Columbia | 11001 | 55918 | 1162 |
1683730 | 1683730 | 2021-09-04 | District of Columbia | District of Columbia | 11001 | 55918 | 1162 |
1680479 | 1680479 | 2021-09-03 | District of Columbia | District of Columbia | 11001 | 55918 | 1162 |
1677231 | 1677231 | 2021-09-02 | District of Columbia | District of Columbia | 11001 | 55718 | 1161 |
1673984 | 1673984 | 2021-09-01 | District of Columbia | District of Columbia | 11001 | 55570 | 1161 |
1670736 | 1670736 | 2021-08-31 | District of Columbia | District of Columbia | 11001 | 55431 | 1160 |
1667489 | 1667489 | 2021-08-30 | District of Columbia | District of Columbia | 11001 | 55253 | 1159 |
1664242 | 1664242 | 2021-08-29 | District of Columbia | District of Columbia | 11001 | 54556 | 1159 |
1660994 | 1660994 | 2021-08-28 | District of Columbia | District of Columbia | 11001 | 54556 | 1159 |
1657746 | 1657746 | 2021-08-27 | District of Columbia | District of Columbia | 11001 | 54556 | 1159 |
1654498 | 1654498 | 2021-08-26 | District of Columbia | District of Columbia | 11001 | 54366 | 1158 |
1651251 | 1651251 | 2021-08-25 | District of Columbia | District of Columbia | 11001 | 54156 | 1155 |
1648002 | 1648002 | 2021-08-24 | District of Columbia | District of Columbia | 11001 | 54031 | 1155 |
1644754 | 1644754 | 2021-08-23 | District of Columbia | District of Columbia | 11001 | 53898 | 1155 |
1641504 | 1641504 | 2021-08-22 | District of Columbia | District of Columbia | 11001 | 53342 | 1155 |
1638254 | 1638254 | 2021-08-21 | District of Columbia | District of Columbia | 11001 | 53342 | 1155 |
1635004 | 1635004 | 2021-08-20 | District of Columbia | District of Columbia | 11001 | 53342 | 1155 |
1631755 | 1631755 | 2021-08-19 | District of Columbia | District of Columbia | 11001 | 53162 | 1155 |
1628508 | 1628508 | 2021-08-18 | District of Columbia | District of Columbia | 11001 | 52843 | 1151 |
1625261 | 1625261 | 2021-08-17 | District of Columbia | District of Columbia | 11001 | 52843 | 1151 |
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);