ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Queen Anne's" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2175416 | 2175416 | 2022-02-02 | Queen Anne's | Maryland | 24035 | 6724 | 105 |
2172163 | 2172163 | 2022-02-01 | Queen Anne's | Maryland | 24035 | 6708 | 105 |
2168910 | 2168910 | 2022-01-31 | Queen Anne's | Maryland | 24035 | 6695 | 105 |
2165655 | 2165655 | 2022-01-30 | Queen Anne's | Maryland | 24035 | 6687 | 105 |
2162400 | 2162400 | 2022-01-29 | Queen Anne's | Maryland | 24035 | 6670 | 105 |
2159145 | 2159145 | 2022-01-28 | Queen Anne's | Maryland | 24035 | 6639 | 105 |
2155891 | 2155891 | 2022-01-27 | Queen Anne's | Maryland | 24035 | 6610 | 105 |
2152638 | 2152638 | 2022-01-26 | Queen Anne's | Maryland | 24035 | 6566 | 105 |
2149386 | 2149386 | 2022-01-25 | Queen Anne's | Maryland | 24035 | 6538 | 102 |
2146134 | 2146134 | 2022-01-24 | Queen Anne's | Maryland | 24035 | 6514 | 101 |
2142879 | 2142879 | 2022-01-23 | Queen Anne's | Maryland | 24035 | 6485 | 101 |
2139624 | 2139624 | 2022-01-22 | Queen Anne's | Maryland | 24035 | 6433 | 101 |
2136368 | 2136368 | 2022-01-21 | Queen Anne's | Maryland | 24035 | 6390 | 101 |
2133116 | 2133116 | 2022-01-20 | Queen Anne's | Maryland | 24035 | 6342 | 98 |
2129863 | 2129863 | 2022-01-19 | Queen Anne's | Maryland | 24035 | 6303 | 96 |
2126609 | 2126609 | 2022-01-18 | Queen Anne's | Maryland | 24035 | 6279 | 95 |
2123357 | 2123357 | 2022-01-17 | Queen Anne's | Maryland | 24035 | 6227 | 95 |
2120105 | 2120105 | 2022-01-16 | Queen Anne's | Maryland | 24035 | 6174 | 94 |
2116853 | 2116853 | 2022-01-15 | Queen Anne's | Maryland | 24035 | 6093 | 94 |
2113602 | 2113602 | 2022-01-14 | Queen Anne's | Maryland | 24035 | 6017 | 94 |
2110350 | 2110350 | 2022-01-13 | Queen Anne's | Maryland | 24035 | 5957 | 91 |
2107099 | 2107099 | 2022-01-12 | Queen Anne's | Maryland | 24035 | 5885 | 90 |
2103848 | 2103848 | 2022-01-11 | Queen Anne's | Maryland | 24035 | 5827 | 87 |
2100597 | 2100597 | 2022-01-10 | Queen Anne's | Maryland | 24035 | 5790 | 86 |
2097346 | 2097346 | 2022-01-09 | Queen Anne's | Maryland | 24035 | 5734 | 86 |
2094094 | 2094094 | 2022-01-08 | Queen Anne's | Maryland | 24035 | 5668 | 86 |
2090842 | 2090842 | 2022-01-07 | Queen Anne's | Maryland | 24035 | 5628 | 86 |
2087591 | 2087591 | 2022-01-06 | Queen Anne's | Maryland | 24035 | 5573 | 86 |
2084339 | 2084339 | 2022-01-05 | Queen Anne's | Maryland | 24035 | 5510 | 86 |
2081087 | 2081087 | 2022-01-04 | Queen Anne's | Maryland | 24035 | 5466 | 86 |
2077835 | 2077835 | 2022-01-03 | Queen Anne's | Maryland | 24035 | 5406 | 85 |
2074584 | 2074584 | 2022-01-02 | Queen Anne's | Maryland | 24035 | 5362 | 85 |
2071333 | 2071333 | 2022-01-01 | Queen Anne's | Maryland | 24035 | 5141 | 83 |
2068082 | 2068082 | 2021-12-31 | Queen Anne's | Maryland | 24035 | 5141 | 83 |
2064831 | 2064831 | 2021-12-30 | Queen Anne's | Maryland | 24035 | 5141 | 83 |
2061581 | 2061581 | 2021-12-29 | Queen Anne's | Maryland | 24035 | 5076 | 83 |
2058332 | 2058332 | 2021-12-28 | Queen Anne's | Maryland | 24035 | 5020 | 82 |
2055083 | 2055083 | 2021-12-27 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2051833 | 2051833 | 2021-12-26 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2048583 | 2048583 | 2021-12-25 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2045333 | 2045333 | 2021-12-24 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2042083 | 2042083 | 2021-12-23 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2038834 | 2038834 | 2021-12-22 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2035584 | 2035584 | 2021-12-21 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2032334 | 2032334 | 2021-12-20 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2029083 | 2029083 | 2021-12-19 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2025832 | 2025832 | 2021-12-18 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2022581 | 2022581 | 2021-12-17 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2019330 | 2019330 | 2021-12-16 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2016080 | 2016080 | 2021-12-15 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2012829 | 2012829 | 2021-12-14 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2009578 | 2009578 | 2021-12-13 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2006327 | 2006327 | 2021-12-12 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
2003076 | 2003076 | 2021-12-11 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1999826 | 1999826 | 2021-12-10 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1996575 | 1996575 | 2021-12-09 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1993324 | 1993324 | 2021-12-08 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1990073 | 1990073 | 2021-12-07 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1986823 | 1986823 | 2021-12-06 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1983573 | 1983573 | 2021-12-05 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1980323 | 1980323 | 2021-12-04 | Queen Anne's | Maryland | 24035 | 4275 | 77 |
1977073 | 1977073 | 2021-12-03 | Queen Anne's | Maryland | 24035 | 4258 | 77 |
1973823 | 1973823 | 2021-12-02 | Queen Anne's | Maryland | 24035 | 4233 | 77 |
1970574 | 1970574 | 2021-12-01 | Queen Anne's | Maryland | 24035 | 4212 | 77 |
1967324 | 1967324 | 2021-11-30 | Queen Anne's | Maryland | 24035 | 4206 | 75 |
1964072 | 1964072 | 2021-11-29 | Queen Anne's | Maryland | 24035 | 4188 | 75 |
1960821 | 1960821 | 2021-11-28 | Queen Anne's | Maryland | 24035 | 4181 | 75 |
1957570 | 1957570 | 2021-11-27 | Queen Anne's | Maryland | 24035 | 4175 | 75 |
1954319 | 1954319 | 2021-11-26 | Queen Anne's | Maryland | 24035 | 4128 | 75 |
1951068 | 1951068 | 2021-11-25 | Queen Anne's | Maryland | 24035 | 4128 | 75 |
1947817 | 1947817 | 2021-11-24 | Queen Anne's | Maryland | 24035 | 4128 | 75 |
1944566 | 1944566 | 2021-11-23 | Queen Anne's | Maryland | 24035 | 4117 | 75 |
1941315 | 1941315 | 2021-11-22 | Queen Anne's | Maryland | 24035 | 4115 | 74 |
1938065 | 1938065 | 2021-11-21 | Queen Anne's | Maryland | 24035 | 4105 | 74 |
1934815 | 1934815 | 2021-11-20 | Queen Anne's | Maryland | 24035 | 4097 | 74 |
1931565 | 1931565 | 2021-11-19 | Queen Anne's | Maryland | 24035 | 4081 | 74 |
1928314 | 1928314 | 2021-11-18 | Queen Anne's | Maryland | 24035 | 4075 | 74 |
1925064 | 1925064 | 2021-11-17 | Queen Anne's | Maryland | 24035 | 4055 | 74 |
1921815 | 1921815 | 2021-11-16 | Queen Anne's | Maryland | 24035 | 4048 | 74 |
1918565 | 1918565 | 2021-11-15 | Queen Anne's | Maryland | 24035 | 4042 | 73 |
1915315 | 1915315 | 2021-11-14 | Queen Anne's | Maryland | 24035 | 4025 | 73 |
1912065 | 1912065 | 2021-11-13 | Queen Anne's | Maryland | 24035 | 4016 | 73 |
1908815 | 1908815 | 2021-11-12 | Queen Anne's | Maryland | 24035 | 3994 | 73 |
1905566 | 1905566 | 2021-11-11 | Queen Anne's | Maryland | 24035 | 3982 | 73 |
1902317 | 1902317 | 2021-11-10 | Queen Anne's | Maryland | 24035 | 3962 | 73 |
1899067 | 1899067 | 2021-11-09 | Queen Anne's | Maryland | 24035 | 3958 | 73 |
1895817 | 1895817 | 2021-11-08 | Queen Anne's | Maryland | 24035 | 3954 | 73 |
1892567 | 1892567 | 2021-11-07 | Queen Anne's | Maryland | 24035 | 3947 | 73 |
1889317 | 1889317 | 2021-11-06 | Queen Anne's | Maryland | 24035 | 3936 | 73 |
1886067 | 1886067 | 2021-11-05 | Queen Anne's | Maryland | 24035 | 3930 | 73 |
1882818 | 1882818 | 2021-11-04 | Queen Anne's | Maryland | 24035 | 3925 | 72 |
1879569 | 1879569 | 2021-11-03 | Queen Anne's | Maryland | 24035 | 3924 | 72 |
1876320 | 1876320 | 2021-11-02 | Queen Anne's | Maryland | 24035 | 3919 | 72 |
1873071 | 1873071 | 2021-11-01 | Queen Anne's | Maryland | 24035 | 3913 | 72 |
1869822 | 1869822 | 2021-10-31 | Queen Anne's | Maryland | 24035 | 3908 | 72 |
1866573 | 1866573 | 2021-10-30 | Queen Anne's | Maryland | 24035 | 3901 | 72 |
1863324 | 1863324 | 2021-10-29 | Queen Anne's | Maryland | 24035 | 3893 | 72 |
1860075 | 1860075 | 2021-10-28 | Queen Anne's | Maryland | 24035 | 3888 | 72 |
1856826 | 1856826 | 2021-10-27 | Queen Anne's | Maryland | 24035 | 3878 | 72 |
1853577 | 1853577 | 2021-10-26 | Queen Anne's | Maryland | 24035 | 3875 | 71 |
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);