ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Madera" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
1849313 | 1849313 | 2021-10-25 | Madera | California | 6039 | 23955 | 285 |
1846063 | 1846063 | 2021-10-24 | Madera | California | 6039 | 23955 | 285 |
1842813 | 1842813 | 2021-10-23 | Madera | California | 6039 | 23955 | 285 |
1839563 | 1839563 | 2021-10-22 | Madera | California | 6039 | 23955 | 285 |
1836314 | 1836314 | 2021-10-21 | Madera | California | 6039 | 23876 | 285 |
1833065 | 1833065 | 2021-10-20 | Madera | California | 6039 | 23761 | 281 |
1829816 | 1829816 | 2021-10-19 | Madera | California | 6039 | 23720 | 281 |
1826567 | 1826567 | 2021-10-18 | Madera | California | 6039 | 23680 | 281 |
1823318 | 1823318 | 2021-10-17 | Madera | California | 6039 | 23518 | 281 |
1820069 | 1820069 | 2021-10-16 | Madera | California | 6039 | 23518 | 281 |
1816820 | 1816820 | 2021-10-15 | Madera | California | 6039 | 23518 | 281 |
1813572 | 1813572 | 2021-10-14 | Madera | California | 6039 | 23420 | 281 |
1810323 | 1810323 | 2021-10-13 | Madera | California | 6039 | 23319 | 277 |
1807074 | 1807074 | 2021-10-12 | Madera | California | 6039 | 23300 | 275 |
1803823 | 1803823 | 2021-10-11 | Madera | California | 6039 | 23231 | 275 |
1800574 | 1800574 | 2021-10-10 | Madera | California | 6039 | 23058 | 275 |
1797325 | 1797325 | 2021-10-09 | Madera | California | 6039 | 23058 | 275 |
1794076 | 1794076 | 2021-10-08 | Madera | California | 6039 | 23058 | 275 |
1790828 | 1790828 | 2021-10-07 | Madera | California | 6039 | 22975 | 275 |
1787579 | 1787579 | 2021-10-06 | Madera | California | 6039 | 22849 | 272 |
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);