ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 11001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174517 | 2174517 | 2022-02-02 | District of Columbia | District of Columbia | 11001 | 131093 | 1290 |
2171264 | 2171264 | 2022-02-01 | District of Columbia | District of Columbia | 11001 | 130949 | 1290 |
2168011 | 2168011 | 2022-01-31 | District of Columbia | District of Columbia | 11001 | 130888 | 1289 |
2164756 | 2164756 | 2022-01-30 | District of Columbia | District of Columbia | 11001 | 129817 | 1284 |
2161501 | 2161501 | 2022-01-29 | District of Columbia | District of Columbia | 11001 | 129817 | 1284 |
2158245 | 2158245 | 2022-01-28 | District of Columbia | District of Columbia | 11001 | 129817 | 1284 |
2154992 | 2154992 | 2022-01-27 | District of Columbia | District of Columbia | 11001 | 129479 | 1282 |
2151739 | 2151739 | 2022-01-26 | District of Columbia | District of Columbia | 11001 | 129108 | 1280 |
2148487 | 2148487 | 2022-01-25 | District of Columbia | District of Columbia | 11001 | 128739 | 1278 |
2145235 | 2145235 | 2022-01-24 | District of Columbia | District of Columbia | 11001 | 128550 | 1275 |
2141980 | 2141980 | 2022-01-23 | District of Columbia | District of Columbia | 11001 | 127200 | 1267 |
2138725 | 2138725 | 2022-01-22 | District of Columbia | District of Columbia | 11001 | 127200 | 1267 |
2135469 | 2135469 | 2022-01-21 | District of Columbia | District of Columbia | 11001 | 127200 | 1267 |
2132217 | 2132217 | 2022-01-20 | District of Columbia | District of Columbia | 11001 | 126675 | 1264 |
2128964 | 2128964 | 2022-01-19 | District of Columbia | District of Columbia | 11001 | 126187 | 1263 |
2125710 | 2125710 | 2022-01-18 | District of Columbia | District of Columbia | 11001 | 125707 | 1260 |
2122458 | 2122458 | 2022-01-17 | District of Columbia | District of Columbia | 11001 | 121871 | 1255 |
2119206 | 2119206 | 2022-01-16 | District of Columbia | District of Columbia | 11001 | 121871 | 1255 |
2115954 | 2115954 | 2022-01-15 | District of Columbia | District of Columbia | 11001 | 121871 | 1255 |
2112703 | 2112703 | 2022-01-14 | District of Columbia | District of Columbia | 11001 | 121871 | 1255 |
2109451 | 2109451 | 2022-01-13 | District of Columbia | District of Columbia | 11001 | 120327 | 1245 |
2106200 | 2106200 | 2022-01-12 | District of Columbia | District of Columbia | 11001 | 118802 | 1240 |
2102949 | 2102949 | 2022-01-11 | District of Columbia | District of Columbia | 11001 | 117586 | 1237 |
2099698 | 2099698 | 2022-01-10 | District of Columbia | District of Columbia | 11001 | 116278 | 1233 |
2096447 | 2096447 | 2022-01-09 | District of Columbia | District of Columbia | 11001 | 110040 | 1227 |
2093195 | 2093195 | 2022-01-08 | District of Columbia | District of Columbia | 11001 | 110040 | 1227 |
2089943 | 2089943 | 2022-01-07 | District of Columbia | District of Columbia | 11001 | 110040 | 1227 |
2086692 | 2086692 | 2022-01-06 | District of Columbia | District of Columbia | 11001 | 108112 | 1225 |
2083440 | 2083440 | 2022-01-05 | District of Columbia | District of Columbia | 11001 | 106819 | 1222 |
2080188 | 2080188 | 2022-01-04 | District of Columbia | District of Columbia | 11001 | 105493 | 1220 |
2076936 | 2076936 | 2022-01-03 | District of Columbia | District of Columbia | 11001 | 103487 | 1218 |
2073685 | 2073685 | 2022-01-02 | District of Columbia | District of Columbia | 11001 | 94286 | 1211 |
2070434 | 2070434 | 2022-01-01 | District of Columbia | District of Columbia | 11001 | 94286 | 1211 |
2067183 | 2067183 | 2021-12-31 | District of Columbia | District of Columbia | 11001 | 94286 | 1211 |
2063932 | 2063932 | 2021-12-30 | District of Columbia | District of Columbia | 11001 | 94286 | 1211 |
2060682 | 2060682 | 2021-12-29 | District of Columbia | District of Columbia | 11001 | 92045 | 1210 |
2057433 | 2057433 | 2021-12-28 | District of Columbia | District of Columbia | 11001 | 90633 | 1209 |
2054184 | 2054184 | 2021-12-27 | District of Columbia | District of Columbia | 11001 | 88765 | 1209 |
2050934 | 2050934 | 2021-12-26 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2047684 | 2047684 | 2021-12-25 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2044434 | 2044434 | 2021-12-24 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2041185 | 2041185 | 2021-12-23 | District of Columbia | District of Columbia | 11001 | 79565 | 1207 |
2037935 | 2037935 | 2021-12-22 | District of Columbia | District of Columbia | 11001 | 77661 | 1207 |
2034685 | 2034685 | 2021-12-21 | District of Columbia | District of Columbia | 11001 | 76137 | 1207 |
2031435 | 2031435 | 2021-12-20 | District of Columbia | District of Columbia | 11001 | 74982 | 1207 |
2028184 | 2028184 | 2021-12-19 | District of Columbia | District of Columbia | 11001 | 71219 | 1206 |
2024933 | 2024933 | 2021-12-18 | District of Columbia | District of Columbia | 11001 | 71219 | 1206 |
2021682 | 2021682 | 2021-12-17 | District of Columbia | District of Columbia | 11001 | 71219 | 1206 |
2018431 | 2018431 | 2021-12-16 | District of Columbia | District of Columbia | 11001 | 70375 | 1204 |
2015181 | 2015181 | 2021-12-15 | District of Columbia | District of Columbia | 11001 | 69867 | 1203 |
2011930 | 2011930 | 2021-12-14 | District of Columbia | District of Columbia | 11001 | 69540 | 1203 |
2008679 | 2008679 | 2021-12-13 | District of Columbia | District of Columbia | 11001 | 68702 | 1199 |
2005428 | 2005428 | 2021-12-12 | District of Columbia | District of Columbia | 11001 | 68702 | 1199 |
2002177 | 2002177 | 2021-12-11 | District of Columbia | District of Columbia | 11001 | 68702 | 1199 |
1998927 | 1998927 | 2021-12-10 | District of Columbia | District of Columbia | 11001 | 68702 | 1199 |
1995676 | 1995676 | 2021-12-09 | District of Columbia | District of Columbia | 11001 | 68460 | 1197 |
1992425 | 1992425 | 2021-12-08 | District of Columbia | District of Columbia | 11001 | 68262 | 1197 |
1989174 | 1989174 | 2021-12-07 | District of Columbia | District of Columbia | 11001 | 68134 | 1197 |
1985924 | 1985924 | 2021-12-06 | District of Columbia | District of Columbia | 11001 | 67996 | 1197 |
1982674 | 1982674 | 2021-12-05 | District of Columbia | District of Columbia | 11001 | 67430 | 1197 |
1979424 | 1979424 | 2021-12-04 | District of Columbia | District of Columbia | 11001 | 67430 | 1197 |
1976174 | 1976174 | 2021-12-03 | District of Columbia | District of Columbia | 11001 | 67430 | 1197 |
1972925 | 1972925 | 2021-12-02 | District of Columbia | District of Columbia | 11001 | 67173 | 1197 |
1969675 | 1969675 | 2021-12-01 | District of Columbia | District of Columbia | 11001 | 67047 | 1196 |
1966425 | 1966425 | 2021-11-30 | District of Columbia | District of Columbia | 11001 | 66912 | 1196 |
1963173 | 1963173 | 2021-11-29 | District of Columbia | District of Columbia | 11001 | 66857 | 1196 |
1959922 | 1959922 | 2021-11-28 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1956671 | 1956671 | 2021-11-27 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1953420 | 1953420 | 2021-11-26 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
1950169 | 1950169 | 2021-11-25 | District of Columbia | District of Columbia | 11001 | 66510 | 1196 |
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 |
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);