ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
802 rows where fips = 6013 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174388 | 2174388 | 2022-02-02 | Contra Costa | California | 6013 | 184961 | 1115 |
2171135 | 2171135 | 2022-02-01 | Contra Costa | California | 6013 | 184048 | 1115 |
2167882 | 2167882 | 2022-01-31 | Contra Costa | California | 6013 | 183484 | 1102 |
2164627 | 2164627 | 2022-01-30 | Contra Costa | California | 6013 | 178585 | 1101 |
2161372 | 2161372 | 2022-01-29 | Contra Costa | California | 6013 | 178585 | 1101 |
2158116 | 2158116 | 2022-01-28 | Contra Costa | California | 6013 | 178585 | 1101 |
2154863 | 2154863 | 2022-01-27 | Contra Costa | California | 6013 | 176554 | 1095 |
2151610 | 2151610 | 2022-01-26 | Contra Costa | California | 6013 | 172490 | 1092 |
2148358 | 2148358 | 2022-01-25 | Contra Costa | California | 6013 | 170859 | 1092 |
2145106 | 2145106 | 2022-01-24 | Contra Costa | California | 6013 | 169496 | 1092 |
2141851 | 2141851 | 2022-01-23 | Contra Costa | California | 6013 | 162809 | 1091 |
2138596 | 2138596 | 2022-01-22 | Contra Costa | California | 6013 | 162809 | 1091 |
2135340 | 2135340 | 2022-01-21 | Contra Costa | California | 6013 | 162809 | 1091 |
2132088 | 2132088 | 2022-01-20 | Contra Costa | California | 6013 | 160241 | 1091 |
2128835 | 2128835 | 2022-01-19 | Contra Costa | California | 6013 | 154775 | 1085 |
2125581 | 2125581 | 2022-01-18 | Contra Costa | California | 6013 | 153322 | 1086 |
2122329 | 2122329 | 2022-01-17 | Contra Costa | California | 6013 | 151636 | 1086 |
2119077 | 2119077 | 2022-01-16 | Contra Costa | California | 6013 | 142972 | 1082 |
2115825 | 2115825 | 2022-01-15 | Contra Costa | California | 6013 | 142972 | 1082 |
2112574 | 2112574 | 2022-01-14 | Contra Costa | California | 6013 | 142972 | 1082 |
2109322 | 2109322 | 2022-01-13 | Contra Costa | California | 6013 | 139908 | 1077 |
2106071 | 2106071 | 2022-01-12 | Contra Costa | California | 6013 | 135644 | 1077 |
2102820 | 2102820 | 2022-01-11 | Contra Costa | California | 6013 | 133185 | 1077 |
2099569 | 2099569 | 2022-01-10 | Contra Costa | California | 6013 | 131284 | 1077 |
2096318 | 2096318 | 2022-01-09 | Contra Costa | California | 6013 | 123141 | 1077 |
2093066 | 2093066 | 2022-01-08 | Contra Costa | California | 6013 | 123141 | 1077 |
2089814 | 2089814 | 2022-01-07 | Contra Costa | California | 6013 | 123141 | 1077 |
2086563 | 2086563 | 2022-01-06 | Contra Costa | California | 6013 | 120422 | 1071 |
2083311 | 2083311 | 2022-01-05 | Contra Costa | California | 6013 | 118727 | 1075 |
2080059 | 2080059 | 2022-01-04 | Contra Costa | California | 6013 | 117688 | 1073 |
2076807 | 2076807 | 2022-01-03 | Contra Costa | California | 6013 | 112315 | 1073 |
2073556 | 2073556 | 2022-01-02 | Contra Costa | California | 6013 | 112315 | 1073 |
2070305 | 2070305 | 2022-01-01 | Contra Costa | California | 6013 | 112315 | 1073 |
2067054 | 2067054 | 2021-12-31 | Contra Costa | California | 6013 | 112315 | 1073 |
2063803 | 2063803 | 2021-12-30 | Contra Costa | California | 6013 | 110887 | 1072 |
2060553 | 2060553 | 2021-12-29 | Contra Costa | California | 6013 | 109693 | 1072 |
2057304 | 2057304 | 2021-12-28 | Contra Costa | California | 6013 | 109225 | 1071 |
2054055 | 2054055 | 2021-12-27 | Contra Costa | California | 6013 | 107555 | 1071 |
2050805 | 2050805 | 2021-12-26 | Contra Costa | California | 6013 | 107555 | 1071 |
2047555 | 2047555 | 2021-12-25 | Contra Costa | California | 6013 | 107555 | 1071 |
2044305 | 2044305 | 2021-12-24 | Contra Costa | California | 6013 | 107555 | 1071 |
2041056 | 2041056 | 2021-12-23 | Contra Costa | California | 6013 | 107092 | 1070 |
2037806 | 2037806 | 2021-12-22 | Contra Costa | California | 6013 | 106751 | 1068 |
2034556 | 2034556 | 2021-12-21 | Contra Costa | California | 6013 | 106547 | 1068 |
2031306 | 2031306 | 2021-12-20 | Contra Costa | California | 6013 | 106402 | 1068 |
2028055 | 2028055 | 2021-12-19 | Contra Costa | California | 6013 | 105876 | 1065 |
2024804 | 2024804 | 2021-12-18 | Contra Costa | California | 6013 | 105876 | 1065 |
2021553 | 2021553 | 2021-12-17 | Contra Costa | California | 6013 | 105876 | 1065 |
2018302 | 2018302 | 2021-12-16 | Contra Costa | California | 6013 | 105732 | 1064 |
2015052 | 2015052 | 2021-12-15 | Contra Costa | California | 6013 | 105591 | 1064 |
2011801 | 2011801 | 2021-12-14 | Contra Costa | California | 6013 | 105497 | 1064 |
2008550 | 2008550 | 2021-12-13 | Contra Costa | California | 6013 | 105432 | 1065 |
2005299 | 2005299 | 2021-12-12 | Contra Costa | California | 6013 | 105074 | 1061 |
2002048 | 2002048 | 2021-12-11 | Contra Costa | California | 6013 | 105074 | 1061 |
1998798 | 1998798 | 2021-12-10 | Contra Costa | California | 6013 | 105074 | 1061 |
1995547 | 1995547 | 2021-12-09 | Contra Costa | California | 6013 | 104962 | 1058 |
1992296 | 1992296 | 2021-12-08 | Contra Costa | California | 6013 | 104815 | 1058 |
1989045 | 1989045 | 2021-12-07 | Contra Costa | California | 6013 | 104721 | 1058 |
1985795 | 1985795 | 2021-12-06 | Contra Costa | California | 6013 | 104645 | 1058 |
1982545 | 1982545 | 2021-12-05 | Contra Costa | California | 6013 | 104218 | 1056 |
1979295 | 1979295 | 2021-12-04 | Contra Costa | California | 6013 | 104218 | 1056 |
1976045 | 1976045 | 2021-12-03 | Contra Costa | California | 6013 | 104218 | 1056 |
1972796 | 1972796 | 2021-12-02 | Contra Costa | California | 6013 | 104045 | 1048 |
1969546 | 1969546 | 2021-12-01 | Contra Costa | California | 6013 | 103869 | 1046 |
1966296 | 1966296 | 2021-11-30 | Contra Costa | California | 6013 | 103772 | 1046 |
1963044 | 1963044 | 2021-11-29 | Contra Costa | California | 6013 | 103686 | 1046 |
1959793 | 1959793 | 2021-11-28 | Contra Costa | California | 6013 | 103292 | 1045 |
1956542 | 1956542 | 2021-11-27 | Contra Costa | California | 6013 | 103292 | 1045 |
1953291 | 1953291 | 2021-11-26 | Contra Costa | California | 6013 | 103292 | 1045 |
1950040 | 1950040 | 2021-11-25 | Contra Costa | California | 6013 | 103292 | 1045 |
1946789 | 1946789 | 2021-11-24 | Contra Costa | California | 6013 | 103292 | 1045 |
1943538 | 1943538 | 2021-11-23 | Contra Costa | California | 6013 | 103208 | 1045 |
1940288 | 1940288 | 2021-11-22 | Contra Costa | California | 6013 | 103138 | 1045 |
1937038 | 1937038 | 2021-11-21 | Contra Costa | California | 6013 | 102822 | 1043 |
1933788 | 1933788 | 2021-11-20 | Contra Costa | California | 6013 | 102822 | 1043 |
1930536 | 1930536 | 2021-11-19 | Contra Costa | California | 6013 | 102822 | 1043 |
1927286 | 1927286 | 2021-11-18 | Contra Costa | California | 6013 | 102718 | 1039 |
1924036 | 1924036 | 2021-11-17 | Contra Costa | California | 6013 | 102625 | 1038 |
1920787 | 1920787 | 2021-11-16 | Contra Costa | California | 6013 | 102556 | 1038 |
1917537 | 1917537 | 2021-11-15 | Contra Costa | California | 6013 | 102493 | 1038 |
1914287 | 1914287 | 2021-11-14 | Contra Costa | California | 6013 | 102309 | 1028 |
1911037 | 1911037 | 2021-11-13 | Contra Costa | California | 6013 | 102309 | 1028 |
1907788 | 1907788 | 2021-11-12 | Contra Costa | California | 6013 | 102113 | 1028 |
1904539 | 1904539 | 2021-11-11 | Contra Costa | California | 6013 | 102113 | 1028 |
1901289 | 1901289 | 2021-11-10 | Contra Costa | California | 6013 | 101997 | 1028 |
1898039 | 1898039 | 2021-11-09 | Contra Costa | California | 6013 | 101934 | 1028 |
1894789 | 1894789 | 2021-11-08 | Contra Costa | California | 6013 | 101861 | 1028 |
1891539 | 1891539 | 2021-11-07 | Contra Costa | California | 6013 | 101547 | 1025 |
1888289 | 1888289 | 2021-11-06 | Contra Costa | California | 6013 | 101547 | 1025 |
1885039 | 1885039 | 2021-11-05 | Contra Costa | California | 6013 | 101547 | 1025 |
1881790 | 1881790 | 2021-11-04 | Contra Costa | California | 6013 | 101433 | 1025 |
1878541 | 1878541 | 2021-11-03 | Contra Costa | California | 6013 | 101275 | 1025 |
1875292 | 1875292 | 2021-11-02 | Contra Costa | California | 6013 | 101206 | 1025 |
1872043 | 1872043 | 2021-11-01 | Contra Costa | California | 6013 | 101131 | 1025 |
1868794 | 1868794 | 2021-10-31 | Contra Costa | California | 6013 | 100757 | 1024 |
1865545 | 1865545 | 2021-10-30 | Contra Costa | California | 6013 | 100757 | 1024 |
1862296 | 1862296 | 2021-10-29 | Contra Costa | California | 6013 | 100757 | 1024 |
1859047 | 1859047 | 2021-10-28 | Contra Costa | California | 6013 | 100637 | 1018 |
1855798 | 1855798 | 2021-10-27 | Contra Costa | California | 6013 | 100515 | 1017 |
1852549 | 1852549 | 2021-10-26 | Contra Costa | California | 6013 | 100430 | 1017 |
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);