ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
839 rows where fips = 6037 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174400 | 2174400 | 2022-02-02 | Los Angeles | California | 6037 | 2684348 | 29099 |
2171147 | 2171147 | 2022-02-01 | Los Angeles | California | 6037 | 2668798 | 28998 |
2167894 | 2167894 | 2022-01-31 | Los Angeles | California | 6037 | 2660118 | 28963 |
2164639 | 2164639 | 2022-01-30 | Los Angeles | California | 6037 | 2649455 | 28923 |
2161384 | 2161384 | 2022-01-29 | Los Angeles | California | 6037 | 2632698 | 28886 |
2158128 | 2158128 | 2022-01-28 | Los Angeles | California | 6037 | 2611089 | 28816 |
2154875 | 2154875 | 2022-01-27 | Los Angeles | California | 6037 | 2587443 | 28715 |
2151622 | 2151622 | 2022-01-26 | Los Angeles | California | 6037 | 2561472 | 28630 |
2148370 | 2148370 | 2022-01-25 | Los Angeles | California | 6037 | 2540779 | 28540 |
2145118 | 2145118 | 2022-01-24 | Los Angeles | California | 6037 | 2520482 | 28507 |
2141863 | 2141863 | 2022-01-23 | Los Angeles | California | 6037 | 2494801 | 28480 |
2138608 | 2138608 | 2022-01-22 | Los Angeles | California | 6037 | 2468501 | 28417 |
2135352 | 2135352 | 2022-01-21 | Los Angeles | California | 6037 | 2429448 | 28346 |
2132100 | 2132100 | 2022-01-20 | Los Angeles | California | 6037 | 2386425 | 28282 |
2128847 | 2128847 | 2022-01-19 | Los Angeles | California | 6037 | 2344525 | 28181 |
2125593 | 2125593 | 2022-01-18 | Los Angeles | California | 6037 | 2312272 | 28122 |
2122341 | 2122341 | 2022-01-17 | Los Angeles | California | 6037 | 2289749 | 28086 |
2119089 | 2119089 | 2022-01-16 | Los Angeles | California | 6037 | 2258206 | 28059 |
2115837 | 2115837 | 2022-01-15 | Los Angeles | California | 6037 | 2214368 | 28008 |
2112586 | 2112586 | 2022-01-14 | Los Angeles | California | 6037 | 2172712 | 27985 |
2109334 | 2109334 | 2022-01-13 | Los Angeles | California | 6037 | 2132227 | 27985 |
2106083 | 2106083 | 2022-01-12 | Los Angeles | California | 6037 | 2087285 | 27850 |
2102832 | 2102832 | 2022-01-11 | Los Angeles | California | 6037 | 2046912 | 27812 |
2099581 | 2099581 | 2022-01-10 | Los Angeles | California | 6037 | 2011668 | 27798 |
2096330 | 2096330 | 2022-01-09 | Los Angeles | California | 6037 | 1968147 | 27785 |
2093078 | 2093078 | 2022-01-08 | Los Angeles | California | 6037 | 1922594 | 27772 |
2089826 | 2089826 | 2022-01-07 | Los Angeles | California | 6037 | 1888230 | 27756 |
2086575 | 2086575 | 2022-01-06 | Los Angeles | California | 6037 | 1844626 | 27728 |
2083323 | 2083323 | 2022-01-05 | Los Angeles | California | 6037 | 1807532 | 27698 |
2080071 | 2080071 | 2022-01-04 | Los Angeles | California | 6037 | 1780858 | 27671 |
2076819 | 2076819 | 2022-01-03 | Los Angeles | California | 6037 | 1758226 | 27647 |
2073568 | 2073568 | 2022-01-02 | Los Angeles | California | 6037 | 1741996 | 27640 |
2070317 | 2070317 | 2022-01-01 | Los Angeles | California | 6037 | 1697286 | 27637 |
2067066 | 2067066 | 2021-12-31 | Los Angeles | California | 6037 | 1697286 | 27637 |
2063815 | 2063815 | 2021-12-30 | Los Angeles | California | 6037 | 1670249 | 27625 |
2060565 | 2060565 | 2021-12-29 | Los Angeles | California | 6037 | 1650080 | 27601 |
2057316 | 2057316 | 2021-12-28 | Los Angeles | California | 6037 | 1633597 | 27576 |
2054067 | 2054067 | 2021-12-27 | Los Angeles | California | 6037 | 1624146 | 27555 |
2050817 | 2050817 | 2021-12-26 | Los Angeles | California | 6037 | 1616737 | 27546 |
2047567 | 2047567 | 2021-12-25 | Los Angeles | California | 6037 | 1595943 | 27533 |
2044317 | 2044317 | 2021-12-24 | Los Angeles | California | 6037 | 1595943 | 27533 |
2041068 | 2041068 | 2021-12-23 | Los Angeles | California | 6037 | 1586017 | 27512 |
2037818 | 2037818 | 2021-12-22 | Los Angeles | California | 6037 | 1577406 | 27488 |
2034568 | 2034568 | 2021-12-21 | Los Angeles | California | 6037 | 1570934 | 27473 |
2031318 | 2031318 | 2021-12-20 | Los Angeles | California | 6037 | 1567837 | 27448 |
2028067 | 2028067 | 2021-12-19 | Los Angeles | California | 6037 | 1564583 | 27441 |
2024816 | 2024816 | 2021-12-18 | Los Angeles | California | 6037 | 1561081 | 27432 |
2021565 | 2021565 | 2021-12-17 | Los Angeles | California | 6037 | 1557389 | 27413 |
2018314 | 2018314 | 2021-12-16 | Los Angeles | California | 6037 | 1554070 | 27388 |
2015064 | 2015064 | 2021-12-15 | Los Angeles | California | 6037 | 1551821 | 27369 |
2011813 | 2011813 | 2021-12-14 | Los Angeles | California | 6037 | 1550000 | 27352 |
2008562 | 2008562 | 2021-12-13 | Los Angeles | California | 6037 | 1548861 | 27341 |
2005311 | 2005311 | 2021-12-12 | Los Angeles | California | 6037 | 1547746 | 27330 |
2002060 | 2002060 | 2021-12-11 | Los Angeles | California | 6037 | 1546287 | 27325 |
1998810 | 1998810 | 2021-12-10 | Los Angeles | California | 6037 | 1544488 | 27304 |
1995559 | 1995559 | 2021-12-09 | Los Angeles | California | 6037 | 1542590 | 27288 |
1992308 | 1992308 | 2021-12-08 | Los Angeles | California | 6037 | 1540904 | 27275 |
1989057 | 1989057 | 2021-12-07 | Los Angeles | California | 6037 | 1539155 | 27262 |
1985807 | 1985807 | 2021-12-06 | Los Angeles | California | 6037 | 1538154 | 27248 |
1982557 | 1982557 | 2021-12-05 | Los Angeles | California | 6037 | 1537055 | 27246 |
1979307 | 1979307 | 2021-12-04 | Los Angeles | California | 6037 | 1535424 | 27244 |
1976057 | 1976057 | 2021-12-03 | Los Angeles | California | 6037 | 1533134 | 27225 |
1972808 | 1972808 | 2021-12-02 | Los Angeles | California | 6037 | 1531230 | 27208 |
1969558 | 1969558 | 2021-12-01 | Los Angeles | California | 6037 | 1529290 | 27184 |
1966308 | 1966308 | 2021-11-30 | Los Angeles | California | 6037 | 1527836 | 27166 |
1963056 | 1963056 | 2021-11-29 | Los Angeles | California | 6037 | 1526976 | 27138 |
1959805 | 1959805 | 2021-11-28 | Los Angeles | California | 6037 | 1526190 | 27128 |
1956554 | 1956554 | 2021-11-27 | Los Angeles | California | 6037 | 1525616 | 27121 |
1953303 | 1953303 | 2021-11-26 | Los Angeles | California | 6037 | 1524998 | 27102 |
1950052 | 1950052 | 2021-11-25 | Los Angeles | California | 6037 | 1523244 | 27074 |
1946801 | 1946801 | 2021-11-24 | Los Angeles | California | 6037 | 1523244 | 27074 |
1943550 | 1943550 | 2021-11-23 | Los Angeles | California | 6037 | 1521901 | 27046 |
1940300 | 1940300 | 2021-11-22 | Los Angeles | California | 6037 | 1521208 | 27017 |
1937050 | 1937050 | 2021-11-21 | Los Angeles | California | 6037 | 1520485 | 27010 |
1933800 | 1933800 | 2021-11-20 | Los Angeles | California | 6037 | 1519436 | 26999 |
1930548 | 1930548 | 2021-11-19 | Los Angeles | California | 6037 | 1517605 | 26973 |
1927298 | 1927298 | 2021-11-18 | Los Angeles | California | 6037 | 1516028 | 26949 |
1924048 | 1924048 | 2021-11-17 | Los Angeles | California | 6037 | 1514986 | 26923 |
1920799 | 1920799 | 2021-11-16 | Los Angeles | California | 6037 | 1513720 | 26903 |
1917549 | 1917549 | 2021-11-15 | Los Angeles | California | 6037 | 1512851 | 26872 |
1914299 | 1914299 | 2021-11-14 | Los Angeles | California | 6037 | 1512028 | 26862 |
1911049 | 1911049 | 2021-11-13 | Los Angeles | California | 6037 | 1511138 | 26856 |
1907800 | 1907800 | 2021-11-12 | Los Angeles | California | 6037 | 1509777 | 26838 |
1904551 | 1904551 | 2021-11-11 | Los Angeles | California | 6037 | 1508440 | 26814 |
1901301 | 1901301 | 2021-11-10 | Los Angeles | California | 6037 | 1507009 | 26796 |
1898051 | 1898051 | 2021-11-09 | Los Angeles | California | 6037 | 1505547 | 26762 |
1894801 | 1894801 | 2021-11-08 | Los Angeles | California | 6037 | 1504368 | 26752 |
1891551 | 1891551 | 2021-11-07 | Los Angeles | California | 6037 | 1503380 | 26750 |
1888301 | 1888301 | 2021-11-06 | Los Angeles | California | 6037 | 1502231 | 26740 |
1885051 | 1885051 | 2021-11-05 | Los Angeles | California | 6037 | 1500615 | 26719 |
1881802 | 1881802 | 2021-11-04 | Los Angeles | California | 6037 | 1499097 | 26695 |
1878553 | 1878553 | 2021-11-03 | Los Angeles | California | 6037 | 1497297 | 26683 |
1875304 | 1875304 | 2021-11-02 | Los Angeles | California | 6037 | 1495718 | 26661 |
1872055 | 1872055 | 2021-11-01 | Los Angeles | California | 6037 | 1494823 | 26644 |
1868806 | 1868806 | 2021-10-31 | Los Angeles | California | 6037 | 1493874 | 26637 |
1865557 | 1865557 | 2021-10-30 | Los Angeles | California | 6037 | 1492810 | 26628 |
1862308 | 1862308 | 2021-10-29 | Los Angeles | California | 6037 | 1491402 | 26626 |
1859059 | 1859059 | 2021-10-28 | Los Angeles | California | 6037 | 1490084 | 26604 |
1855810 | 1855810 | 2021-10-27 | Los Angeles | California | 6037 | 1488206 | 26599 |
1852561 | 1852561 | 2021-10-26 | Los Angeles | California | 6037 | 1487318 | 26579 |
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);