ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
814 rows where fips = 6023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174393 | 2174393 | 2022-02-02 | Humboldt | California | 6023 | 17721 | 131 |
2171140 | 2171140 | 2022-02-01 | Humboldt | California | 6023 | 17675 | 131 |
2167887 | 2167887 | 2022-01-31 | Humboldt | California | 6023 | 17614 | 130 |
2164632 | 2164632 | 2022-01-30 | Humboldt | California | 6023 | 17179 | 129 |
2161377 | 2161377 | 2022-01-29 | Humboldt | California | 6023 | 17179 | 129 |
2158121 | 2158121 | 2022-01-28 | Humboldt | California | 6023 | 17179 | 129 |
2154868 | 2154868 | 2022-01-27 | Humboldt | California | 6023 | 17082 | 129 |
2151615 | 2151615 | 2022-01-26 | Humboldt | California | 6023 | 16453 | 129 |
2148363 | 2148363 | 2022-01-25 | Humboldt | California | 6023 | 16259 | 129 |
2145111 | 2145111 | 2022-01-24 | Humboldt | California | 6023 | 16139 | 129 |
2141856 | 2141856 | 2022-01-23 | Humboldt | California | 6023 | 15471 | 129 |
2138601 | 2138601 | 2022-01-22 | Humboldt | California | 6023 | 15471 | 129 |
2135345 | 2135345 | 2022-01-21 | Humboldt | California | 6023 | 15471 | 129 |
2132093 | 2132093 | 2022-01-20 | Humboldt | California | 6023 | 15234 | 129 |
2128840 | 2128840 | 2022-01-19 | Humboldt | California | 6023 | 14600 | 128 |
2125586 | 2125586 | 2022-01-18 | Humboldt | California | 6023 | 14502 | 128 |
2122334 | 2122334 | 2022-01-17 | Humboldt | California | 6023 | 14457 | 128 |
2119082 | 2119082 | 2022-01-16 | Humboldt | California | 6023 | 13801 | 128 |
2115830 | 2115830 | 2022-01-15 | Humboldt | California | 6023 | 13801 | 128 |
2112579 | 2112579 | 2022-01-14 | Humboldt | California | 6023 | 13801 | 128 |
2109327 | 2109327 | 2022-01-13 | Humboldt | California | 6023 | 13463 | 128 |
2106076 | 2106076 | 2022-01-12 | Humboldt | California | 6023 | 12923 | 126 |
2102825 | 2102825 | 2022-01-11 | Humboldt | California | 6023 | 12741 | 125 |
2099574 | 2099574 | 2022-01-10 | Humboldt | California | 6023 | 12545 | 124 |
2096323 | 2096323 | 2022-01-09 | Humboldt | California | 6023 | 12112 | 124 |
2093071 | 2093071 | 2022-01-08 | Humboldt | California | 6023 | 12112 | 124 |
2089819 | 2089819 | 2022-01-07 | Humboldt | California | 6023 | 12112 | 124 |
2086568 | 2086568 | 2022-01-06 | Humboldt | California | 6023 | 11901 | 124 |
2083316 | 2083316 | 2022-01-05 | Humboldt | California | 6023 | 11681 | 124 |
2080064 | 2080064 | 2022-01-04 | Humboldt | California | 6023 | 11600 | 123 |
2076812 | 2076812 | 2022-01-03 | Humboldt | California | 6023 | 11352 | 123 |
2073561 | 2073561 | 2022-01-02 | Humboldt | California | 6023 | 11197 | 122 |
2070310 | 2070310 | 2022-01-01 | Humboldt | California | 6023 | 11197 | 122 |
2067059 | 2067059 | 2021-12-31 | Humboldt | California | 6023 | 11197 | 122 |
2063808 | 2063808 | 2021-12-30 | Humboldt | California | 6023 | 11065 | 122 |
2060558 | 2060558 | 2021-12-29 | Humboldt | California | 6023 | 10978 | 122 |
2057309 | 2057309 | 2021-12-28 | Humboldt | California | 6023 | 10944 | 122 |
2054060 | 2054060 | 2021-12-27 | Humboldt | California | 6023 | 10836 | 122 |
2050810 | 2050810 | 2021-12-26 | Humboldt | California | 6023 | 10832 | 122 |
2047560 | 2047560 | 2021-12-25 | Humboldt | California | 6023 | 10832 | 122 |
2044310 | 2044310 | 2021-12-24 | Humboldt | California | 6023 | 10832 | 122 |
2041061 | 2041061 | 2021-12-23 | Humboldt | California | 6023 | 10802 | 122 |
2037811 | 2037811 | 2021-12-22 | Humboldt | California | 6023 | 10744 | 122 |
2034561 | 2034561 | 2021-12-21 | Humboldt | California | 6023 | 10728 | 122 |
2031311 | 2031311 | 2021-12-20 | Humboldt | California | 6023 | 10712 | 121 |
2028060 | 2028060 | 2021-12-19 | Humboldt | California | 6023 | 10644 | 120 |
2024809 | 2024809 | 2021-12-18 | Humboldt | California | 6023 | 10644 | 120 |
2021558 | 2021558 | 2021-12-17 | Humboldt | California | 6023 | 10644 | 120 |
2018307 | 2018307 | 2021-12-16 | Humboldt | California | 6023 | 10609 | 120 |
2015057 | 2015057 | 2021-12-15 | Humboldt | California | 6023 | 10570 | 120 |
2011806 | 2011806 | 2021-12-14 | Humboldt | California | 6023 | 10555 | 120 |
2008555 | 2008555 | 2021-12-13 | Humboldt | California | 6023 | 10538 | 120 |
2005304 | 2005304 | 2021-12-12 | Humboldt | California | 6023 | 10455 | 120 |
2002053 | 2002053 | 2021-12-11 | Humboldt | California | 6023 | 10455 | 120 |
1998803 | 1998803 | 2021-12-10 | Humboldt | California | 6023 | 10455 | 120 |
1995552 | 1995552 | 2021-12-09 | Humboldt | California | 6023 | 10438 | 120 |
1992301 | 1992301 | 2021-12-08 | Humboldt | California | 6023 | 10391 | 120 |
1989050 | 1989050 | 2021-12-07 | Humboldt | California | 6023 | 10369 | 119 |
1985800 | 1985800 | 2021-12-06 | Humboldt | California | 6023 | 10360 | 119 |
1982550 | 1982550 | 2021-12-05 | Humboldt | California | 6023 | 10294 | 119 |
1979300 | 1979300 | 2021-12-04 | Humboldt | California | 6023 | 10294 | 119 |
1976050 | 1976050 | 2021-12-03 | Humboldt | California | 6023 | 10294 | 119 |
1972801 | 1972801 | 2021-12-02 | Humboldt | California | 6023 | 10271 | 119 |
1969551 | 1969551 | 2021-12-01 | Humboldt | California | 6023 | 10183 | 119 |
1966301 | 1966301 | 2021-11-30 | Humboldt | California | 6023 | 10158 | 119 |
1963049 | 1963049 | 2021-11-29 | Humboldt | California | 6023 | 10143 | 118 |
1959798 | 1959798 | 2021-11-28 | Humboldt | California | 6023 | 10043 | 117 |
1956547 | 1956547 | 2021-11-27 | Humboldt | California | 6023 | 10043 | 117 |
1953296 | 1953296 | 2021-11-26 | Humboldt | California | 6023 | 10043 | 117 |
1950045 | 1950045 | 2021-11-25 | Humboldt | California | 6023 | 10043 | 117 |
1946794 | 1946794 | 2021-11-24 | Humboldt | California | 6023 | 10043 | 117 |
1943543 | 1943543 | 2021-11-23 | Humboldt | California | 6023 | 10033 | 117 |
1940293 | 1940293 | 2021-11-22 | Humboldt | California | 6023 | 10022 | 117 |
1937043 | 1937043 | 2021-11-21 | Humboldt | California | 6023 | 9946 | 117 |
1933793 | 1933793 | 2021-11-20 | Humboldt | California | 6023 | 9946 | 117 |
1930541 | 1930541 | 2021-11-19 | Humboldt | California | 6023 | 9946 | 117 |
1927291 | 1927291 | 2021-11-18 | Humboldt | California | 6023 | 9914 | 117 |
1924041 | 1924041 | 2021-11-17 | Humboldt | California | 6023 | 9873 | 117 |
1920792 | 1920792 | 2021-11-16 | Humboldt | California | 6023 | 9851 | 117 |
1917542 | 1917542 | 2021-11-15 | Humboldt | California | 6023 | 9836 | 117 |
1914292 | 1914292 | 2021-11-14 | Humboldt | California | 6023 | 9798 | 117 |
1911042 | 1911042 | 2021-11-13 | Humboldt | California | 6023 | 9798 | 117 |
1907793 | 1907793 | 2021-11-12 | Humboldt | California | 6023 | 9746 | 117 |
1904544 | 1904544 | 2021-11-11 | Humboldt | California | 6023 | 9746 | 117 |
1901294 | 1901294 | 2021-11-10 | Humboldt | California | 6023 | 9698 | 117 |
1898044 | 1898044 | 2021-11-09 | Humboldt | California | 6023 | 9681 | 117 |
1894794 | 1894794 | 2021-11-08 | Humboldt | California | 6023 | 9660 | 117 |
1891544 | 1891544 | 2021-11-07 | Humboldt | California | 6023 | 9558 | 116 |
1888294 | 1888294 | 2021-11-06 | Humboldt | California | 6023 | 9558 | 116 |
1885044 | 1885044 | 2021-11-05 | Humboldt | California | 6023 | 9558 | 116 |
1881795 | 1881795 | 2021-11-04 | Humboldt | California | 6023 | 9535 | 116 |
1878546 | 1878546 | 2021-11-03 | Humboldt | California | 6023 | 9490 | 116 |
1875297 | 1875297 | 2021-11-02 | Humboldt | California | 6023 | 9482 | 116 |
1872048 | 1872048 | 2021-11-01 | Humboldt | California | 6023 | 9472 | 116 |
1868799 | 1868799 | 2021-10-31 | Humboldt | California | 6023 | 9424 | 112 |
1865550 | 1865550 | 2021-10-30 | Humboldt | California | 6023 | 9424 | 112 |
1862301 | 1862301 | 2021-10-29 | Humboldt | California | 6023 | 9424 | 112 |
1859052 | 1859052 | 2021-10-28 | Humboldt | California | 6023 | 9404 | 110 |
1855803 | 1855803 | 2021-10-27 | Humboldt | California | 6023 | 9346 | 109 |
1852554 | 1852554 | 2021-10-26 | Humboldt | California | 6023 | 9341 | 109 |
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);