ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Washington" and fips = 24043 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175421 | 2175421 | 2022-02-02 | Washington | Maryland | 24043 | 32893 | 530 |
2172168 | 2172168 | 2022-02-01 | Washington | Maryland | 24043 | 32788 | 528 |
2168915 | 2168915 | 2022-01-31 | Washington | Maryland | 24043 | 32728 | 527 |
2165660 | 2165660 | 2022-01-30 | Washington | Maryland | 24043 | 32686 | 526 |
2162405 | 2162405 | 2022-01-29 | Washington | Maryland | 24043 | 32552 | 526 |
2159150 | 2159150 | 2022-01-28 | Washington | Maryland | 24043 | 32447 | 524 |
2155896 | 2155896 | 2022-01-27 | Washington | Maryland | 24043 | 32335 | 521 |
2152643 | 2152643 | 2022-01-26 | Washington | Maryland | 24043 | 32169 | 519 |
2149391 | 2149391 | 2022-01-25 | Washington | Maryland | 24043 | 32065 | 515 |
2146139 | 2146139 | 2022-01-24 | Washington | Maryland | 24043 | 31965 | 514 |
2142884 | 2142884 | 2022-01-23 | Washington | Maryland | 24043 | 31838 | 514 |
2139629 | 2139629 | 2022-01-22 | Washington | Maryland | 24043 | 31729 | 513 |
2136373 | 2136373 | 2022-01-21 | Washington | Maryland | 24043 | 31481 | 512 |
2133121 | 2133121 | 2022-01-20 | Washington | Maryland | 24043 | 31287 | 507 |
2129868 | 2129868 | 2022-01-19 | Washington | Maryland | 24043 | 31060 | 501 |
2126614 | 2126614 | 2022-01-18 | Washington | Maryland | 24043 | 30986 | 500 |
2123362 | 2123362 | 2022-01-17 | Washington | Maryland | 24043 | 30862 | 498 |
2120110 | 2120110 | 2022-01-16 | Washington | Maryland | 24043 | 30709 | 497 |
2116858 | 2116858 | 2022-01-15 | Washington | Maryland | 24043 | 30377 | 495 |
2113607 | 2113607 | 2022-01-14 | Washington | Maryland | 24043 | 30033 | 492 |
2110355 | 2110355 | 2022-01-13 | Washington | Maryland | 24043 | 29712 | 492 |
2107104 | 2107104 | 2022-01-12 | Washington | Maryland | 24043 | 29408 | 492 |
2103853 | 2103853 | 2022-01-11 | Washington | Maryland | 24043 | 28849 | 489 |
2100602 | 2100602 | 2022-01-10 | Washington | Maryland | 24043 | 28793 | 486 |
2097351 | 2097351 | 2022-01-09 | Washington | Maryland | 24043 | 28691 | 486 |
2094099 | 2094099 | 2022-01-08 | Washington | Maryland | 24043 | 28315 | 486 |
2090847 | 2090847 | 2022-01-07 | Washington | Maryland | 24043 | 27984 | 485 |
2087596 | 2087596 | 2022-01-06 | Washington | Maryland | 24043 | 27640 | 479 |
2084344 | 2084344 | 2022-01-05 | Washington | Maryland | 24043 | 27159 | 477 |
2081092 | 2081092 | 2022-01-04 | Washington | Maryland | 24043 | 26746 | 474 |
2077840 | 2077840 | 2022-01-03 | Washington | Maryland | 24043 | 26642 | 468 |
2074589 | 2074589 | 2022-01-02 | Washington | Maryland | 24043 | 26446 | 468 |
2071338 | 2071338 | 2022-01-01 | Washington | Maryland | 24043 | 25443 | 462 |
2068087 | 2068087 | 2021-12-31 | Washington | Maryland | 24043 | 25443 | 462 |
2064836 | 2064836 | 2021-12-30 | Washington | Maryland | 24043 | 25443 | 462 |
2061586 | 2061586 | 2021-12-29 | Washington | Maryland | 24043 | 25084 | 455 |
2058337 | 2058337 | 2021-12-28 | Washington | Maryland | 24043 | 24866 | 452 |
2055088 | 2055088 | 2021-12-27 | Washington | Maryland | 24043 | 22032 | 429 |
2051838 | 2051838 | 2021-12-26 | Washington | Maryland | 24043 | 22032 | 429 |
2048588 | 2048588 | 2021-12-25 | Washington | Maryland | 24043 | 22032 | 429 |
2045338 | 2045338 | 2021-12-24 | Washington | Maryland | 24043 | 22032 | 429 |
2042088 | 2042088 | 2021-12-23 | Washington | Maryland | 24043 | 22032 | 429 |
2038839 | 2038839 | 2021-12-22 | Washington | Maryland | 24043 | 22032 | 429 |
2035589 | 2035589 | 2021-12-21 | Washington | Maryland | 24043 | 22032 | 429 |
2032339 | 2032339 | 2021-12-20 | Washington | Maryland | 24043 | 22032 | 429 |
2029088 | 2029088 | 2021-12-19 | Washington | Maryland | 24043 | 22032 | 429 |
2025837 | 2025837 | 2021-12-18 | Washington | Maryland | 24043 | 22032 | 429 |
2022586 | 2022586 | 2021-12-17 | Washington | Maryland | 24043 | 22032 | 429 |
2019335 | 2019335 | 2021-12-16 | Washington | Maryland | 24043 | 22032 | 429 |
2016085 | 2016085 | 2021-12-15 | Washington | Maryland | 24043 | 22032 | 429 |
2012834 | 2012834 | 2021-12-14 | Washington | Maryland | 24043 | 22032 | 429 |
2009583 | 2009583 | 2021-12-13 | Washington | Maryland | 24043 | 22032 | 429 |
2006332 | 2006332 | 2021-12-12 | Washington | Maryland | 24043 | 22032 | 429 |
2003081 | 2003081 | 2021-12-11 | Washington | Maryland | 24043 | 22032 | 429 |
1999831 | 1999831 | 2021-12-10 | Washington | Maryland | 24043 | 22032 | 429 |
1996580 | 1996580 | 2021-12-09 | Washington | Maryland | 24043 | 22032 | 429 |
1993329 | 1993329 | 2021-12-08 | Washington | Maryland | 24043 | 22032 | 429 |
1990078 | 1990078 | 2021-12-07 | Washington | Maryland | 24043 | 22032 | 429 |
1986828 | 1986828 | 2021-12-06 | Washington | Maryland | 24043 | 22032 | 429 |
1983578 | 1983578 | 2021-12-05 | Washington | Maryland | 24043 | 22032 | 429 |
1980328 | 1980328 | 2021-12-04 | Washington | Maryland | 24043 | 22032 | 429 |
1977078 | 1977078 | 2021-12-03 | Washington | Maryland | 24043 | 21931 | 427 |
1973828 | 1973828 | 2021-12-02 | Washington | Maryland | 24043 | 21802 | 426 |
1970579 | 1970579 | 2021-12-01 | Washington | Maryland | 24043 | 21656 | 425 |
1967329 | 1967329 | 2021-11-30 | Washington | Maryland | 24043 | 21512 | 424 |
1964077 | 1964077 | 2021-11-29 | Washington | Maryland | 24043 | 21462 | 423 |
1960826 | 1960826 | 2021-11-28 | Washington | Maryland | 24043 | 21421 | 423 |
1957575 | 1957575 | 2021-11-27 | Washington | Maryland | 24043 | 21292 | 423 |
1954324 | 1954324 | 2021-11-26 | Washington | Maryland | 24043 | 21135 | 422 |
1951073 | 1951073 | 2021-11-25 | Washington | Maryland | 24043 | 21135 | 422 |
1947822 | 1947822 | 2021-11-24 | Washington | Maryland | 24043 | 21135 | 422 |
1944571 | 1944571 | 2021-11-23 | Washington | Maryland | 24043 | 21048 | 421 |
1941320 | 1941320 | 2021-11-22 | Washington | Maryland | 24043 | 21004 | 421 |
1938070 | 1938070 | 2021-11-21 | Washington | Maryland | 24043 | 20969 | 420 |
1934820 | 1934820 | 2021-11-20 | Washington | Maryland | 24043 | 20902 | 420 |
1931570 | 1931570 | 2021-11-19 | Washington | Maryland | 24043 | 20846 | 420 |
1928319 | 1928319 | 2021-11-18 | Washington | Maryland | 24043 | 20791 | 420 |
1925069 | 1925069 | 2021-11-17 | Washington | Maryland | 24043 | 20709 | 419 |
1921820 | 1921820 | 2021-11-16 | Washington | Maryland | 24043 | 20625 | 418 |
1918570 | 1918570 | 2021-11-15 | Washington | Maryland | 24043 | 20595 | 418 |
1915320 | 1915320 | 2021-11-14 | Washington | Maryland | 24043 | 20565 | 418 |
1912070 | 1912070 | 2021-11-13 | Washington | Maryland | 24043 | 20504 | 418 |
1908820 | 1908820 | 2021-11-12 | Washington | Maryland | 24043 | 20434 | 418 |
1905571 | 1905571 | 2021-11-11 | Washington | Maryland | 24043 | 20370 | 416 |
1902322 | 1902322 | 2021-11-10 | Washington | Maryland | 24043 | 20291 | 413 |
1899072 | 1899072 | 2021-11-09 | Washington | Maryland | 24043 | 20179 | 410 |
1895822 | 1895822 | 2021-11-08 | Washington | Maryland | 24043 | 20158 | 409 |
1892572 | 1892572 | 2021-11-07 | Washington | Maryland | 24043 | 20119 | 409 |
1889322 | 1889322 | 2021-11-06 | Washington | Maryland | 24043 | 20062 | 409 |
1886072 | 1886072 | 2021-11-05 | Washington | Maryland | 24043 | 19992 | 407 |
1882823 | 1882823 | 2021-11-04 | Washington | Maryland | 24043 | 19932 | 406 |
1879574 | 1879574 | 2021-11-03 | Washington | Maryland | 24043 | 19876 | 406 |
1876325 | 1876325 | 2021-11-02 | Washington | Maryland | 24043 | 19797 | 401 |
1873076 | 1873076 | 2021-11-01 | Washington | Maryland | 24043 | 19787 | 397 |
1869827 | 1869827 | 2021-10-31 | Washington | Maryland | 24043 | 19768 | 397 |
1866578 | 1866578 | 2021-10-30 | Washington | Maryland | 24043 | 19719 | 396 |
1863329 | 1863329 | 2021-10-29 | Washington | Maryland | 24043 | 19653 | 396 |
1860080 | 1860080 | 2021-10-28 | Washington | Maryland | 24043 | 19572 | 395 |
1856831 | 1856831 | 2021-10-27 | Washington | Maryland | 24043 | 19518 | 393 |
1853582 | 1853582 | 2021-10-26 | Washington | Maryland | 24043 | 19448 | 393 |
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);