ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where fips = 6039 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174401 | 2174401 | 2022-02-02 | Madera | California | 6039 | 38481 | 329 |
2171148 | 2171148 | 2022-02-01 | Madera | California | 6039 | 38243 | 329 |
2167895 | 2167895 | 2022-01-31 | Madera | California | 6039 | 38109 | 336 |
2164640 | 2164640 | 2022-01-30 | Madera | California | 6039 | 37110 | 336 |
2161385 | 2161385 | 2022-01-29 | Madera | California | 6039 | 37110 | 336 |
2158129 | 2158129 | 2022-01-28 | Madera | California | 6039 | 37110 | 336 |
2154876 | 2154876 | 2022-01-27 | Madera | California | 6039 | 36680 | 336 |
2151623 | 2151623 | 2022-01-26 | Madera | California | 6039 | 35229 | 329 |
2148371 | 2148371 | 2022-01-25 | Madera | California | 6039 | 34774 | 329 |
2145119 | 2145119 | 2022-01-24 | Madera | California | 6039 | 34397 | 336 |
2141864 | 2141864 | 2022-01-23 | Madera | California | 6039 | 33030 | 329 |
2138609 | 2138609 | 2022-01-22 | Madera | California | 6039 | 33030 | 329 |
2135353 | 2135353 | 2022-01-21 | Madera | California | 6039 | 33030 | 329 |
2132101 | 2132101 | 2022-01-20 | Madera | California | 6039 | 32456 | 329 |
2128848 | 2128848 | 2022-01-19 | Madera | California | 6039 | 31559 | 329 |
2125594 | 2125594 | 2022-01-18 | Madera | California | 6039 | 31410 | 329 |
2122342 | 2122342 | 2022-01-17 | Madera | California | 6039 | 31155 | 329 |
2119090 | 2119090 | 2022-01-16 | Madera | California | 6039 | 30136 | 329 |
2115838 | 2115838 | 2022-01-15 | Madera | California | 6039 | 30136 | 329 |
2112587 | 2112587 | 2022-01-14 | Madera | California | 6039 | 30136 | 329 |
2109335 | 2109335 | 2022-01-13 | Madera | California | 6039 | 29794 | 329 |
2106084 | 2106084 | 2022-01-12 | Madera | California | 6039 | 29136 | 329 |
2102833 | 2102833 | 2022-01-11 | Madera | California | 6039 | 28949 | 328 |
2099582 | 2099582 | 2022-01-10 | Madera | California | 6039 | 28773 | 328 |
2096331 | 2096331 | 2022-01-09 | Madera | California | 6039 | 28215 | 328 |
2093079 | 2093079 | 2022-01-08 | Madera | California | 6039 | 28215 | 328 |
2089827 | 2089827 | 2022-01-07 | Madera | California | 6039 | 28215 | 328 |
2086576 | 2086576 | 2022-01-06 | Madera | California | 6039 | 27840 | 327 |
2083324 | 2083324 | 2022-01-05 | Madera | California | 6039 | 27770 | 328 |
2080072 | 2080072 | 2022-01-04 | Madera | California | 6039 | 27668 | 324 |
2076820 | 2076820 | 2022-01-03 | Madera | California | 6039 | 27347 | 324 |
2073569 | 2073569 | 2022-01-02 | Madera | California | 6039 | 27347 | 324 |
2070318 | 2070318 | 2022-01-01 | Madera | California | 6039 | 27347 | 324 |
2067067 | 2067067 | 2021-12-31 | Madera | California | 6039 | 27347 | 324 |
2063816 | 2063816 | 2021-12-30 | Madera | California | 6039 | 27268 | 324 |
2060566 | 2060566 | 2021-12-29 | Madera | California | 6039 | 27178 | 324 |
2057317 | 2057317 | 2021-12-28 | Madera | California | 6039 | 27153 | 324 |
2054068 | 2054068 | 2021-12-27 | Madera | California | 6039 | 27054 | 324 |
2050818 | 2050818 | 2021-12-26 | Madera | California | 6039 | 27054 | 324 |
2047568 | 2047568 | 2021-12-25 | Madera | California | 6039 | 27054 | 324 |
2044318 | 2044318 | 2021-12-24 | Madera | California | 6039 | 27054 | 324 |
2041069 | 2041069 | 2021-12-23 | Madera | California | 6039 | 27015 | 324 |
2037819 | 2037819 | 2021-12-22 | Madera | California | 6039 | 26964 | 320 |
2034569 | 2034569 | 2021-12-21 | Madera | California | 6039 | 26944 | 317 |
2031319 | 2031319 | 2021-12-20 | Madera | California | 6039 | 26918 | 317 |
2028068 | 2028068 | 2021-12-19 | Madera | California | 6039 | 26851 | 317 |
2024817 | 2024817 | 2021-12-18 | Madera | California | 6039 | 26851 | 317 |
2021566 | 2021566 | 2021-12-17 | Madera | California | 6039 | 26851 | 317 |
2018315 | 2018315 | 2021-12-16 | Madera | California | 6039 | 26825 | 317 |
2015065 | 2015065 | 2021-12-15 | Madera | California | 6039 | 26784 | 315 |
2011814 | 2011814 | 2021-12-14 | Madera | California | 6039 | 26776 | 315 |
2008563 | 2008563 | 2021-12-13 | Madera | California | 6039 | 26742 | 315 |
2005312 | 2005312 | 2021-12-12 | Madera | California | 6039 | 26666 | 315 |
2002061 | 2002061 | 2021-12-11 | Madera | California | 6039 | 26666 | 315 |
1998811 | 1998811 | 2021-12-10 | Madera | California | 6039 | 26666 | 315 |
1995560 | 1995560 | 2021-12-09 | Madera | California | 6039 | 26645 | 315 |
1992309 | 1992309 | 2021-12-08 | Madera | California | 6039 | 26567 | 311 |
1989058 | 1989058 | 2021-12-07 | Madera | California | 6039 | 26534 | 311 |
1985808 | 1985808 | 2021-12-06 | Madera | California | 6039 | 26511 | 311 |
1982558 | 1982558 | 2021-12-05 | Madera | California | 6039 | 26388 | 311 |
1979308 | 1979308 | 2021-12-04 | Madera | California | 6039 | 26388 | 311 |
1976058 | 1976058 | 2021-12-03 | Madera | California | 6039 | 26388 | 311 |
1972809 | 1972809 | 2021-12-02 | Madera | California | 6039 | 26334 | 311 |
1969559 | 1969559 | 2021-12-01 | Madera | California | 6039 | 26233 | 311 |
1966309 | 1966309 | 2021-11-30 | Madera | California | 6039 | 26194 | 311 |
1963057 | 1963057 | 2021-11-29 | Madera | California | 6039 | 26180 | 311 |
1959806 | 1959806 | 2021-11-28 | Madera | California | 6039 | 26005 | 311 |
1956555 | 1956555 | 2021-11-27 | Madera | California | 6039 | 26005 | 311 |
1953304 | 1953304 | 2021-11-26 | Madera | California | 6039 | 26005 | 311 |
1950053 | 1950053 | 2021-11-25 | Madera | California | 6039 | 26005 | 300 |
1946802 | 1946802 | 2021-11-24 | Madera | California | 6039 | 26005 | 300 |
1943551 | 1943551 | 2021-11-23 | Madera | California | 6039 | 25997 | 300 |
1940301 | 1940301 | 2021-11-22 | Madera | California | 6039 | 25981 | 300 |
1937051 | 1937051 | 2021-11-21 | Madera | California | 6039 | 25845 | 300 |
1933801 | 1933801 | 2021-11-20 | Madera | California | 6039 | 25845 | 300 |
1930549 | 1930549 | 2021-11-19 | Madera | California | 6039 | 25845 | 300 |
1927299 | 1927299 | 2021-11-18 | Madera | California | 6039 | 25798 | 300 |
1924049 | 1924049 | 2021-11-17 | Madera | California | 6039 | 25726 | 293 |
1920800 | 1920800 | 2021-11-16 | Madera | California | 6039 | 25689 | 293 |
1917550 | 1917550 | 2021-11-15 | Madera | California | 6039 | 25650 | 293 |
1914300 | 1914300 | 2021-11-14 | Madera | California | 6039 | 25546 | 293 |
1911050 | 1911050 | 2021-11-13 | Madera | California | 6039 | 25546 | 293 |
1907801 | 1907801 | 2021-11-12 | Madera | California | 6039 | 25400 | 293 |
1904552 | 1904552 | 2021-11-11 | Madera | California | 6039 | 25400 | 291 |
1901302 | 1901302 | 2021-11-10 | Madera | California | 6039 | 25313 | 291 |
1898052 | 1898052 | 2021-11-09 | Madera | California | 6039 | 25281 | 291 |
1894802 | 1894802 | 2021-11-08 | Madera | California | 6039 | 25253 | 291 |
1891552 | 1891552 | 2021-11-07 | Madera | California | 6039 | 25022 | 291 |
1888302 | 1888302 | 2021-11-06 | Madera | California | 6039 | 25022 | 291 |
1885052 | 1885052 | 2021-11-05 | Madera | California | 6039 | 25022 | 291 |
1881803 | 1881803 | 2021-11-04 | Madera | California | 6039 | 24921 | 291 |
1878554 | 1878554 | 2021-11-03 | Madera | California | 6039 | 24792 | 287 |
1875305 | 1875305 | 2021-11-02 | Madera | California | 6039 | 24756 | 287 |
1872056 | 1872056 | 2021-11-01 | Madera | California | 6039 | 24699 | 287 |
1868807 | 1868807 | 2021-10-31 | Madera | California | 6039 | 24479 | 287 |
1865558 | 1865558 | 2021-10-30 | Madera | California | 6039 | 24479 | 287 |
1862309 | 1862309 | 2021-10-29 | Madera | California | 6039 | 24479 | 287 |
1859060 | 1859060 | 2021-10-28 | Madera | California | 6039 | 24368 | 287 |
1855811 | 1855811 | 2021-10-27 | Madera | California | 6039 | 24256 | 285 |
1852562 | 1852562 | 2021-10-26 | Madera | California | 6039 | 24218 | 285 |
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);