ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
803 rows where fips = 6081 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174422 | 2174422 | 2022-02-02 | San Mateo | California | 6081 | 117617 | 655 |
2171169 | 2171169 | 2022-02-01 | San Mateo | California | 6081 | 117062 | 655 |
2167916 | 2167916 | 2022-01-31 | San Mateo | California | 6081 | 116728 | 655 |
2164661 | 2164661 | 2022-01-30 | San Mateo | California | 6081 | 114055 | 655 |
2161406 | 2161406 | 2022-01-29 | San Mateo | California | 6081 | 114055 | 655 |
2158150 | 2158150 | 2022-01-28 | San Mateo | California | 6081 | 114055 | 655 |
2154897 | 2154897 | 2022-01-27 | San Mateo | California | 6081 | 112765 | 647 |
2151644 | 2151644 | 2022-01-26 | San Mateo | California | 6081 | 108299 | 647 |
2148392 | 2148392 | 2022-01-25 | San Mateo | California | 6081 | 107257 | 647 |
2145140 | 2145140 | 2022-01-24 | San Mateo | California | 6081 | 106229 | 647 |
2141885 | 2141885 | 2022-01-23 | San Mateo | California | 6081 | 101729 | 647 |
2138630 | 2138630 | 2022-01-22 | San Mateo | California | 6081 | 101729 | 647 |
2135374 | 2135374 | 2022-01-21 | San Mateo | California | 6081 | 101729 | 647 |
2132122 | 2132122 | 2022-01-20 | San Mateo | California | 6081 | 100004 | 644 |
2128869 | 2128869 | 2022-01-19 | San Mateo | California | 6081 | 94920 | 644 |
2125615 | 2125615 | 2022-01-18 | San Mateo | California | 6081 | 93708 | 644 |
2122363 | 2122363 | 2022-01-17 | San Mateo | California | 6081 | 92661 | 644 |
2119111 | 2119111 | 2022-01-16 | San Mateo | California | 6081 | 87189 | 644 |
2115859 | 2115859 | 2022-01-15 | San Mateo | California | 6081 | 87189 | 644 |
2112608 | 2112608 | 2022-01-14 | San Mateo | California | 6081 | 87189 | 644 |
2109356 | 2109356 | 2022-01-13 | San Mateo | California | 6081 | 85171 | 638 |
2106105 | 2106105 | 2022-01-12 | San Mateo | California | 6081 | 81301 | 638 |
2102854 | 2102854 | 2022-01-11 | San Mateo | California | 6081 | 79755 | 638 |
2099603 | 2099603 | 2022-01-10 | San Mateo | California | 6081 | 78412 | 638 |
2096352 | 2096352 | 2022-01-09 | San Mateo | California | 6081 | 72463 | 638 |
2093100 | 2093100 | 2022-01-08 | San Mateo | California | 6081 | 72463 | 638 |
2089848 | 2089848 | 2022-01-07 | San Mateo | California | 6081 | 72463 | 638 |
2086597 | 2086597 | 2022-01-06 | San Mateo | California | 6081 | 70563 | 636 |
2083345 | 2083345 | 2022-01-05 | San Mateo | California | 6081 | 67727 | 636 |
2080093 | 2080093 | 2022-01-04 | San Mateo | California | 6081 | 67040 | 636 |
2076841 | 2076841 | 2022-01-03 | San Mateo | California | 6081 | 64291 | 636 |
2073590 | 2073590 | 2022-01-02 | San Mateo | California | 6081 | 63074 | 636 |
2070339 | 2070339 | 2022-01-01 | San Mateo | California | 6081 | 63074 | 636 |
2067088 | 2067088 | 2021-12-31 | San Mateo | California | 6081 | 63074 | 636 |
2063837 | 2063837 | 2021-12-30 | San Mateo | California | 6081 | 62048 | 635 |
2060587 | 2060587 | 2021-12-29 | San Mateo | California | 6081 | 60790 | 635 |
2057338 | 2057338 | 2021-12-28 | San Mateo | California | 6081 | 60475 | 635 |
2054089 | 2054089 | 2021-12-27 | San Mateo | California | 6081 | 59051 | 635 |
2050839 | 2050839 | 2021-12-26 | San Mateo | California | 6081 | 59051 | 635 |
2047589 | 2047589 | 2021-12-25 | San Mateo | California | 6081 | 59051 | 635 |
2044339 | 2044339 | 2021-12-24 | San Mateo | California | 6081 | 59051 | 635 |
2041090 | 2041090 | 2021-12-23 | San Mateo | California | 6081 | 58682 | 635 |
2037840 | 2037840 | 2021-12-22 | San Mateo | California | 6081 | 58354 | 635 |
2034590 | 2034590 | 2021-12-21 | San Mateo | California | 6081 | 58220 | 635 |
2031340 | 2031340 | 2021-12-20 | San Mateo | California | 6081 | 58105 | 635 |
2028089 | 2028089 | 2021-12-19 | San Mateo | California | 6081 | 57703 | 635 |
2024838 | 2024838 | 2021-12-18 | San Mateo | California | 6081 | 57703 | 635 |
2021587 | 2021587 | 2021-12-17 | San Mateo | California | 6081 | 57703 | 635 |
2018336 | 2018336 | 2021-12-16 | San Mateo | California | 6081 | 57630 | 631 |
2015086 | 2015086 | 2021-12-15 | San Mateo | California | 6081 | 57509 | 631 |
2011835 | 2011835 | 2021-12-14 | San Mateo | California | 6081 | 57477 | 631 |
2008584 | 2008584 | 2021-12-13 | San Mateo | California | 6081 | 57413 | 631 |
2005333 | 2005333 | 2021-12-12 | San Mateo | California | 6081 | 57192 | 631 |
2002082 | 2002082 | 2021-12-11 | San Mateo | California | 6081 | 57192 | 631 |
1998832 | 1998832 | 2021-12-10 | San Mateo | California | 6081 | 57192 | 631 |
1995581 | 1995581 | 2021-12-09 | San Mateo | California | 6081 | 57128 | 631 |
1992330 | 1992330 | 2021-12-08 | San Mateo | California | 6081 | 56974 | 631 |
1989079 | 1989079 | 2021-12-07 | San Mateo | California | 6081 | 56923 | 631 |
1985829 | 1985829 | 2021-12-06 | San Mateo | California | 6081 | 56861 | 631 |
1982579 | 1982579 | 2021-12-05 | San Mateo | California | 6081 | 56585 | 631 |
1979329 | 1979329 | 2021-12-04 | San Mateo | California | 6081 | 56585 | 631 |
1976079 | 1976079 | 2021-12-03 | San Mateo | California | 6081 | 56585 | 631 |
1972830 | 1972830 | 2021-12-02 | San Mateo | California | 6081 | 56522 | 629 |
1969580 | 1969580 | 2021-12-01 | San Mateo | California | 6081 | 56354 | 629 |
1966330 | 1966330 | 2021-11-30 | San Mateo | California | 6081 | 56320 | 629 |
1963078 | 1963078 | 2021-11-29 | San Mateo | California | 6081 | 56265 | 629 |
1959827 | 1959827 | 2021-11-28 | San Mateo | California | 6081 | 56058 | 629 |
1956576 | 1956576 | 2021-11-27 | San Mateo | California | 6081 | 56058 | 629 |
1953325 | 1953325 | 2021-11-26 | San Mateo | California | 6081 | 56058 | 629 |
1950074 | 1950074 | 2021-11-25 | San Mateo | California | 6081 | 56058 | 627 |
1946823 | 1946823 | 2021-11-24 | San Mateo | California | 6081 | 56058 | 627 |
1943572 | 1943572 | 2021-11-23 | San Mateo | California | 6081 | 56028 | 627 |
1940322 | 1940322 | 2021-11-22 | San Mateo | California | 6081 | 55988 | 627 |
1937072 | 1937072 | 2021-11-21 | San Mateo | California | 6081 | 55830 | 627 |
1933822 | 1933822 | 2021-11-20 | San Mateo | California | 6081 | 55830 | 627 |
1930570 | 1930570 | 2021-11-19 | San Mateo | California | 6081 | 55830 | 627 |
1927320 | 1927320 | 2021-11-18 | San Mateo | California | 6081 | 55790 | 626 |
1924070 | 1924070 | 2021-11-17 | San Mateo | California | 6081 | 55676 | 626 |
1920821 | 1920821 | 2021-11-16 | San Mateo | California | 6081 | 55652 | 626 |
1917571 | 1917571 | 2021-11-15 | San Mateo | California | 6081 | 55620 | 626 |
1914321 | 1914321 | 2021-11-14 | San Mateo | California | 6081 | 55495 | 626 |
1911071 | 1911071 | 2021-11-13 | San Mateo | California | 6081 | 55495 | 626 |
1907822 | 1907822 | 2021-11-12 | San Mateo | California | 6081 | 55364 | 626 |
1904573 | 1904573 | 2021-11-11 | San Mateo | California | 6081 | 55364 | 626 |
1901323 | 1901323 | 2021-11-10 | San Mateo | California | 6081 | 55278 | 626 |
1898073 | 1898073 | 2021-11-09 | San Mateo | California | 6081 | 55239 | 626 |
1894823 | 1894823 | 2021-11-08 | San Mateo | California | 6081 | 55181 | 626 |
1891573 | 1891573 | 2021-11-07 | San Mateo | California | 6081 | 55023 | 626 |
1888323 | 1888323 | 2021-11-06 | San Mateo | California | 6081 | 55023 | 626 |
1885073 | 1885073 | 2021-11-05 | San Mateo | California | 6081 | 55023 | 626 |
1881824 | 1881824 | 2021-11-04 | San Mateo | California | 6081 | 54977 | 625 |
1878575 | 1878575 | 2021-11-03 | San Mateo | California | 6081 | 54847 | 625 |
1875326 | 1875326 | 2021-11-02 | San Mateo | California | 6081 | 54810 | 625 |
1872077 | 1872077 | 2021-11-01 | San Mateo | California | 6081 | 54780 | 625 |
1868828 | 1868828 | 2021-10-31 | San Mateo | California | 6081 | 54579 | 625 |
1865579 | 1865579 | 2021-10-30 | San Mateo | California | 6081 | 54579 | 625 |
1862330 | 1862330 | 2021-10-29 | San Mateo | California | 6081 | 54579 | 625 |
1859081 | 1859081 | 2021-10-28 | San Mateo | California | 6081 | 54528 | 623 |
1855832 | 1855832 | 2021-10-27 | San Mateo | California | 6081 | 54423 | 623 |
1852583 | 1852583 | 2021-10-26 | San Mateo | California | 6081 | 54376 | 623 |
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);