ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
832 rows where fips = 6075 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174419 | 2174419 | 2022-02-02 | San Francisco | California | 6075 | 122878 | 713 |
2171166 | 2171166 | 2022-02-01 | San Francisco | California | 6075 | 122391 | 712 |
2167913 | 2167913 | 2022-01-31 | San Francisco | California | 6075 | 122044 | 712 |
2164658 | 2164658 | 2022-01-30 | San Francisco | California | 6075 | 119537 | 712 |
2161403 | 2161403 | 2022-01-29 | San Francisco | California | 6075 | 119537 | 712 |
2158147 | 2158147 | 2022-01-28 | San Francisco | California | 6075 | 119537 | 712 |
2154894 | 2154894 | 2022-01-27 | San Francisco | California | 6075 | 118446 | 704 |
2151641 | 2151641 | 2022-01-26 | San Francisco | California | 6075 | 115878 | 703 |
2148389 | 2148389 | 2022-01-25 | San Francisco | California | 6075 | 115042 | 703 |
2145137 | 2145137 | 2022-01-24 | San Francisco | California | 6075 | 114109 | 704 |
2141882 | 2141882 | 2022-01-23 | San Francisco | California | 6075 | 109862 | 702 |
2138627 | 2138627 | 2022-01-22 | San Francisco | California | 6075 | 109862 | 702 |
2135371 | 2135371 | 2022-01-21 | San Francisco | California | 6075 | 109862 | 702 |
2132119 | 2132119 | 2022-01-20 | San Francisco | California | 6075 | 108276 | 694 |
2128866 | 2128866 | 2022-01-19 | San Francisco | California | 6075 | 103376 | 694 |
2125612 | 2125612 | 2022-01-18 | San Francisco | California | 6075 | 102163 | 694 |
2122360 | 2122360 | 2022-01-17 | San Francisco | California | 6075 | 101010 | 694 |
2119108 | 2119108 | 2022-01-16 | San Francisco | California | 6075 | 94875 | 692 |
2115856 | 2115856 | 2022-01-15 | San Francisco | California | 6075 | 94875 | 692 |
2112605 | 2112605 | 2022-01-14 | San Francisco | California | 6075 | 94875 | 692 |
2109353 | 2109353 | 2022-01-13 | San Francisco | California | 6075 | 92571 | 691 |
2106102 | 2106102 | 2022-01-12 | San Francisco | California | 6075 | 88170 | 691 |
2102851 | 2102851 | 2022-01-11 | San Francisco | California | 6075 | 86701 | 690 |
2099600 | 2099600 | 2022-01-10 | San Francisco | California | 6075 | 84955 | 690 |
2096349 | 2096349 | 2022-01-09 | San Francisco | California | 6075 | 78152 | 690 |
2093097 | 2093097 | 2022-01-08 | San Francisco | California | 6075 | 78152 | 690 |
2089845 | 2089845 | 2022-01-07 | San Francisco | California | 6075 | 78152 | 690 |
2086594 | 2086594 | 2022-01-06 | San Francisco | California | 6075 | 75897 | 686 |
2083342 | 2083342 | 2022-01-05 | San Francisco | California | 6075 | 74094 | 688 |
2080090 | 2080090 | 2022-01-04 | San Francisco | California | 6075 | 72743 | 686 |
2076838 | 2076838 | 2022-01-03 | San Francisco | California | 6075 | 67926 | 682 |
2073587 | 2073587 | 2022-01-02 | San Francisco | California | 6075 | 67926 | 682 |
2070336 | 2070336 | 2022-01-01 | San Francisco | California | 6075 | 67926 | 682 |
2067085 | 2067085 | 2021-12-31 | San Francisco | California | 6075 | 67926 | 682 |
2063834 | 2063834 | 2021-12-30 | San Francisco | California | 6075 | 66545 | 684 |
2060584 | 2060584 | 2021-12-29 | San Francisco | California | 6075 | 64833 | 682 |
2057335 | 2057335 | 2021-12-28 | San Francisco | California | 6075 | 64008 | 682 |
2054086 | 2054086 | 2021-12-27 | San Francisco | California | 6075 | 61317 | 682 |
2050836 | 2050836 | 2021-12-26 | San Francisco | California | 6075 | 61317 | 682 |
2047586 | 2047586 | 2021-12-25 | San Francisco | California | 6075 | 61317 | 682 |
2044336 | 2044336 | 2021-12-24 | San Francisco | California | 6075 | 61317 | 682 |
2041087 | 2041087 | 2021-12-23 | San Francisco | California | 6075 | 60608 | 682 |
2037837 | 2037837 | 2021-12-22 | San Francisco | California | 6075 | 59886 | 681 |
2034587 | 2034587 | 2021-12-21 | San Francisco | California | 6075 | 59597 | 681 |
2031337 | 2031337 | 2021-12-20 | San Francisco | California | 6075 | 59294 | 681 |
2028086 | 2028086 | 2021-12-19 | San Francisco | California | 6075 | 58498 | 679 |
2024835 | 2024835 | 2021-12-18 | San Francisco | California | 6075 | 58498 | 679 |
2021584 | 2021584 | 2021-12-17 | San Francisco | California | 6075 | 58498 | 679 |
2018333 | 2018333 | 2021-12-16 | San Francisco | California | 6075 | 58350 | 679 |
2015083 | 2015083 | 2021-12-15 | San Francisco | California | 6075 | 58182 | 679 |
2011832 | 2011832 | 2021-12-14 | San Francisco | California | 6075 | 58149 | 678 |
2008581 | 2008581 | 2021-12-13 | San Francisco | California | 6075 | 58084 | 678 |
2005330 | 2005330 | 2021-12-12 | San Francisco | California | 6075 | 57773 | 678 |
2002079 | 2002079 | 2021-12-11 | San Francisco | California | 6075 | 57773 | 678 |
1998829 | 1998829 | 2021-12-10 | San Francisco | California | 6075 | 57773 | 678 |
1995578 | 1995578 | 2021-12-09 | San Francisco | California | 6075 | 57696 | 677 |
1992327 | 1992327 | 2021-12-08 | San Francisco | California | 6075 | 57587 | 676 |
1989076 | 1989076 | 2021-12-07 | San Francisco | California | 6075 | 57517 | 674 |
1985826 | 1985826 | 2021-12-06 | San Francisco | California | 6075 | 57461 | 674 |
1982576 | 1982576 | 2021-12-05 | San Francisco | California | 6075 | 57144 | 674 |
1979326 | 1979326 | 2021-12-04 | San Francisco | California | 6075 | 57144 | 674 |
1976076 | 1976076 | 2021-12-03 | San Francisco | California | 6075 | 57144 | 674 |
1972827 | 1972827 | 2021-12-02 | San Francisco | California | 6075 | 57057 | 672 |
1969577 | 1969577 | 2021-12-01 | San Francisco | California | 6075 | 56934 | 672 |
1966327 | 1966327 | 2021-11-30 | San Francisco | California | 6075 | 56912 | 669 |
1963075 | 1963075 | 2021-11-29 | San Francisco | California | 6075 | 56869 | 669 |
1959824 | 1959824 | 2021-11-28 | San Francisco | California | 6075 | 56617 | 669 |
1956573 | 1956573 | 2021-11-27 | San Francisco | California | 6075 | 56617 | 669 |
1953322 | 1953322 | 2021-11-26 | San Francisco | California | 6075 | 56617 | 669 |
1950071 | 1950071 | 2021-11-25 | San Francisco | California | 6075 | 56617 | 669 |
1946820 | 1946820 | 2021-11-24 | San Francisco | California | 6075 | 56617 | 669 |
1943569 | 1943569 | 2021-11-23 | San Francisco | California | 6075 | 56565 | 669 |
1940319 | 1940319 | 2021-11-22 | San Francisco | California | 6075 | 56528 | 669 |
1937069 | 1937069 | 2021-11-21 | San Francisco | California | 6075 | 56312 | 669 |
1933819 | 1933819 | 2021-11-20 | San Francisco | California | 6075 | 56312 | 669 |
1930567 | 1930567 | 2021-11-19 | San Francisco | California | 6075 | 56312 | 669 |
1927317 | 1927317 | 2021-11-18 | San Francisco | California | 6075 | 56256 | 667 |
1924067 | 1924067 | 2021-11-17 | San Francisco | California | 6075 | 56179 | 667 |
1920818 | 1920818 | 2021-11-16 | San Francisco | California | 6075 | 56138 | 667 |
1917568 | 1917568 | 2021-11-15 | San Francisco | California | 6075 | 56102 | 667 |
1914318 | 1914318 | 2021-11-14 | San Francisco | California | 6075 | 55959 | 667 |
1911068 | 1911068 | 2021-11-13 | San Francisco | California | 6075 | 55959 | 667 |
1907819 | 1907819 | 2021-11-12 | San Francisco | California | 6075 | 55827 | 666 |
1904570 | 1904570 | 2021-11-11 | San Francisco | California | 6075 | 55827 | 666 |
1901320 | 1901320 | 2021-11-10 | San Francisco | California | 6075 | 55706 | 666 |
1898070 | 1898070 | 2021-11-09 | San Francisco | California | 6075 | 55652 | 666 |
1894820 | 1894820 | 2021-11-08 | San Francisco | California | 6075 | 55578 | 666 |
1891570 | 1891570 | 2021-11-07 | San Francisco | California | 6075 | 55266 | 666 |
1888320 | 1888320 | 2021-11-06 | San Francisco | California | 6075 | 55266 | 666 |
1885070 | 1885070 | 2021-11-05 | San Francisco | California | 6075 | 55266 | 666 |
1881821 | 1881821 | 2021-11-04 | San Francisco | California | 6075 | 55203 | 663 |
1878572 | 1878572 | 2021-11-03 | San Francisco | California | 6075 | 55104 | 663 |
1875323 | 1875323 | 2021-11-02 | San Francisco | California | 6075 | 55072 | 661 |
1872074 | 1872074 | 2021-11-01 | San Francisco | California | 6075 | 55024 | 661 |
1868825 | 1868825 | 2021-10-31 | San Francisco | California | 6075 | 54815 | 661 |
1865576 | 1865576 | 2021-10-30 | San Francisco | California | 6075 | 54815 | 661 |
1862327 | 1862327 | 2021-10-29 | San Francisco | California | 6075 | 54815 | 661 |
1859078 | 1859078 | 2021-10-28 | San Francisco | California | 6075 | 54762 | 655 |
1855829 | 1855829 | 2021-10-27 | San Francisco | California | 6075 | 54686 | 655 |
1852580 | 1852580 | 2021-10-26 | San Francisco | California | 6075 | 54664 | 649 |
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);