ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Frederick" and fips = 24021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175409 | 2175409 | 2022-02-02 | Frederick | Maryland | 24021 | 42905 | 485 |
2172156 | 2172156 | 2022-02-01 | Frederick | Maryland | 24021 | 42801 | 483 |
2168903 | 2168903 | 2022-01-31 | Frederick | Maryland | 24021 | 42713 | 480 |
2165648 | 2165648 | 2022-01-30 | Frederick | Maryland | 24021 | 42655 | 479 |
2162393 | 2162393 | 2022-01-29 | Frederick | Maryland | 24021 | 42559 | 479 |
2159138 | 2159138 | 2022-01-28 | Frederick | Maryland | 24021 | 42433 | 474 |
2155884 | 2155884 | 2022-01-27 | Frederick | Maryland | 24021 | 42307 | 472 |
2152631 | 2152631 | 2022-01-26 | Frederick | Maryland | 24021 | 42151 | 470 |
2149379 | 2149379 | 2022-01-25 | Frederick | Maryland | 24021 | 41995 | 466 |
2146127 | 2146127 | 2022-01-24 | Frederick | Maryland | 24021 | 41823 | 464 |
2142872 | 2142872 | 2022-01-23 | Frederick | Maryland | 24021 | 41667 | 464 |
2139617 | 2139617 | 2022-01-22 | Frederick | Maryland | 24021 | 41534 | 464 |
2136361 | 2136361 | 2022-01-21 | Frederick | Maryland | 24021 | 41314 | 458 |
2133109 | 2133109 | 2022-01-20 | Frederick | Maryland | 24021 | 41105 | 457 |
2129856 | 2129856 | 2022-01-19 | Frederick | Maryland | 24021 | 40770 | 452 |
2126602 | 2126602 | 2022-01-18 | Frederick | Maryland | 24021 | 40555 | 446 |
2123350 | 2123350 | 2022-01-17 | Frederick | Maryland | 24021 | 40442 | 443 |
2120098 | 2120098 | 2022-01-16 | Frederick | Maryland | 24021 | 40101 | 442 |
2116846 | 2116846 | 2022-01-15 | Frederick | Maryland | 24021 | 39732 | 438 |
2113595 | 2113595 | 2022-01-14 | Frederick | Maryland | 24021 | 39227 | 437 |
2110343 | 2110343 | 2022-01-13 | Frederick | Maryland | 24021 | 38852 | 436 |
2107092 | 2107092 | 2022-01-12 | Frederick | Maryland | 24021 | 38329 | 434 |
2103841 | 2103841 | 2022-01-11 | Frederick | Maryland | 24021 | 37461 | 433 |
2100590 | 2100590 | 2022-01-10 | Frederick | Maryland | 24021 | 36992 | 428 |
2097339 | 2097339 | 2022-01-09 | Frederick | Maryland | 24021 | 36765 | 428 |
2094087 | 2094087 | 2022-01-08 | Frederick | Maryland | 24021 | 35958 | 427 |
2090835 | 2090835 | 2022-01-07 | Frederick | Maryland | 24021 | 35336 | 426 |
2087584 | 2087584 | 2022-01-06 | Frederick | Maryland | 24021 | 34699 | 423 |
2084332 | 2084332 | 2022-01-05 | Frederick | Maryland | 24021 | 34087 | 423 |
2081080 | 2081080 | 2022-01-04 | Frederick | Maryland | 24021 | 33473 | 423 |
2077828 | 2077828 | 2022-01-03 | Frederick | Maryland | 24021 | 32811 | 419 |
2074577 | 2074577 | 2022-01-02 | Frederick | Maryland | 24021 | 32265 | 419 |
2071326 | 2071326 | 2022-01-01 | Frederick | Maryland | 24021 | 30646 | 417 |
2068075 | 2068075 | 2021-12-31 | Frederick | Maryland | 24021 | 30646 | 417 |
2064824 | 2064824 | 2021-12-30 | Frederick | Maryland | 24021 | 30646 | 417 |
2061574 | 2061574 | 2021-12-29 | Frederick | Maryland | 24021 | 30000 | 417 |
2058325 | 2058325 | 2021-12-28 | Frederick | Maryland | 24021 | 29569 | 413 |
2055076 | 2055076 | 2021-12-27 | Frederick | Maryland | 24021 | 26257 | 397 |
2051826 | 2051826 | 2021-12-26 | Frederick | Maryland | 24021 | 26257 | 397 |
2048576 | 2048576 | 2021-12-25 | Frederick | Maryland | 24021 | 26257 | 397 |
2045326 | 2045326 | 2021-12-24 | Frederick | Maryland | 24021 | 26257 | 397 |
2042076 | 2042076 | 2021-12-23 | Frederick | Maryland | 24021 | 26257 | 397 |
2038827 | 2038827 | 2021-12-22 | Frederick | Maryland | 24021 | 26257 | 397 |
2035577 | 2035577 | 2021-12-21 | Frederick | Maryland | 24021 | 26257 | 397 |
2032327 | 2032327 | 2021-12-20 | Frederick | Maryland | 24021 | 26257 | 397 |
2029076 | 2029076 | 2021-12-19 | Frederick | Maryland | 24021 | 26257 | 397 |
2025825 | 2025825 | 2021-12-18 | Frederick | Maryland | 24021 | 26257 | 397 |
2022574 | 2022574 | 2021-12-17 | Frederick | Maryland | 24021 | 26257 | 397 |
2019323 | 2019323 | 2021-12-16 | Frederick | Maryland | 24021 | 26257 | 397 |
2016073 | 2016073 | 2021-12-15 | Frederick | Maryland | 24021 | 26257 | 397 |
2012822 | 2012822 | 2021-12-14 | Frederick | Maryland | 24021 | 26257 | 397 |
2009571 | 2009571 | 2021-12-13 | Frederick | Maryland | 24021 | 26257 | 397 |
2006320 | 2006320 | 2021-12-12 | Frederick | Maryland | 24021 | 26257 | 397 |
2003069 | 2003069 | 2021-12-11 | Frederick | Maryland | 24021 | 26257 | 397 |
1999819 | 1999819 | 2021-12-10 | Frederick | Maryland | 24021 | 26257 | 397 |
1996568 | 1996568 | 2021-12-09 | Frederick | Maryland | 24021 | 26257 | 397 |
1993317 | 1993317 | 2021-12-08 | Frederick | Maryland | 24021 | 26257 | 397 |
1990066 | 1990066 | 2021-12-07 | Frederick | Maryland | 24021 | 26257 | 397 |
1986816 | 1986816 | 2021-12-06 | Frederick | Maryland | 24021 | 26257 | 397 |
1983566 | 1983566 | 2021-12-05 | Frederick | Maryland | 24021 | 26257 | 397 |
1980316 | 1980316 | 2021-12-04 | Frederick | Maryland | 24021 | 26257 | 397 |
1977066 | 1977066 | 2021-12-03 | Frederick | Maryland | 24021 | 26148 | 397 |
1973816 | 1973816 | 2021-12-02 | Frederick | Maryland | 24021 | 26044 | 396 |
1970567 | 1970567 | 2021-12-01 | Frederick | Maryland | 24021 | 25917 | 393 |
1967317 | 1967317 | 2021-11-30 | Frederick | Maryland | 24021 | 25846 | 393 |
1964065 | 1964065 | 2021-11-29 | Frederick | Maryland | 24021 | 25759 | 392 |
1960814 | 1960814 | 2021-11-28 | Frederick | Maryland | 24021 | 25715 | 392 |
1957563 | 1957563 | 2021-11-27 | Frederick | Maryland | 24021 | 25693 | 392 |
1954312 | 1954312 | 2021-11-26 | Frederick | Maryland | 24021 | 25517 | 390 |
1951061 | 1951061 | 2021-11-25 | Frederick | Maryland | 24021 | 25517 | 390 |
1947810 | 1947810 | 2021-11-24 | Frederick | Maryland | 24021 | 25517 | 390 |
1944559 | 1944559 | 2021-11-23 | Frederick | Maryland | 24021 | 25452 | 390 |
1941308 | 1941308 | 2021-11-22 | Frederick | Maryland | 24021 | 25391 | 390 |
1938058 | 1938058 | 2021-11-21 | Frederick | Maryland | 24021 | 25331 | 390 |
1934808 | 1934808 | 2021-11-20 | Frederick | Maryland | 24021 | 25289 | 389 |
1931558 | 1931558 | 2021-11-19 | Frederick | Maryland | 24021 | 25233 | 389 |
1928307 | 1928307 | 2021-11-18 | Frederick | Maryland | 24021 | 25181 | 388 |
1925057 | 1925057 | 2021-11-17 | Frederick | Maryland | 24021 | 25122 | 388 |
1921808 | 1921808 | 2021-11-16 | Frederick | Maryland | 24021 | 25065 | 388 |
1918558 | 1918558 | 2021-11-15 | Frederick | Maryland | 24021 | 25029 | 386 |
1915308 | 1915308 | 2021-11-14 | Frederick | Maryland | 24021 | 24987 | 386 |
1912058 | 1912058 | 2021-11-13 | Frederick | Maryland | 24021 | 24929 | 386 |
1908808 | 1908808 | 2021-11-12 | Frederick | Maryland | 24021 | 24878 | 386 |
1905559 | 1905559 | 2021-11-11 | Frederick | Maryland | 24021 | 24822 | 386 |
1902310 | 1902310 | 2021-11-10 | Frederick | Maryland | 24021 | 24751 | 385 |
1899060 | 1899060 | 2021-11-09 | Frederick | Maryland | 24021 | 24699 | 384 |
1895810 | 1895810 | 2021-11-08 | Frederick | Maryland | 24021 | 24681 | 382 |
1892560 | 1892560 | 2021-11-07 | Frederick | Maryland | 24021 | 24637 | 382 |
1889310 | 1889310 | 2021-11-06 | Frederick | Maryland | 24021 | 24586 | 381 |
1886060 | 1886060 | 2021-11-05 | Frederick | Maryland | 24021 | 24550 | 379 |
1882811 | 1882811 | 2021-11-04 | Frederick | Maryland | 24021 | 24502 | 379 |
1879562 | 1879562 | 2021-11-03 | Frederick | Maryland | 24021 | 24450 | 379 |
1876313 | 1876313 | 2021-11-02 | Frederick | Maryland | 24021 | 24405 | 379 |
1873064 | 1873064 | 2021-11-01 | Frederick | Maryland | 24021 | 24381 | 377 |
1869815 | 1869815 | 2021-10-31 | Frederick | Maryland | 24021 | 24357 | 377 |
1866566 | 1866566 | 2021-10-30 | Frederick | Maryland | 24021 | 24324 | 377 |
1863317 | 1863317 | 2021-10-29 | Frederick | Maryland | 24021 | 24278 | 377 |
1860068 | 1860068 | 2021-10-28 | Frederick | Maryland | 24021 | 24234 | 377 |
1856819 | 1856819 | 2021-10-27 | Frederick | Maryland | 24021 | 24182 | 377 |
1853570 | 1853570 | 2021-10-26 | Frederick | Maryland | 24021 | 24150 | 376 |
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);