ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Tulare" and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2174435 | 2174435 | 2022-02-02 | Tulare | California | 6107 | 120776 | 1247 |
2171182 | 2171182 | 2022-02-01 | Tulare | California | 6107 | 120362 | 1245 |
2167929 | 2167929 | 2022-01-31 | Tulare | California | 6107 | 119985 | 1245 |
2164674 | 2164674 | 2022-01-30 | Tulare | California | 6107 | 117463 | 1237 |
2161419 | 2161419 | 2022-01-29 | Tulare | California | 6107 | 117463 | 1237 |
2158163 | 2158163 | 2022-01-28 | Tulare | California | 6107 | 117463 | 1237 |
2154910 | 2154910 | 2022-01-27 | Tulare | California | 6107 | 116213 | 1234 |
2151657 | 2151657 | 2022-01-26 | Tulare | California | 6107 | 113127 | 1229 |
2148405 | 2148405 | 2022-01-25 | Tulare | California | 6107 | 111979 | 1223 |
2145153 | 2145153 | 2022-01-24 | Tulare | California | 6107 | 111010 | 1219 |
2141898 | 2141898 | 2022-01-23 | Tulare | California | 6107 | 107113 | 1211 |
2138643 | 2138643 | 2022-01-22 | Tulare | California | 6107 | 107113 | 1211 |
2135387 | 2135387 | 2022-01-21 | Tulare | California | 6107 | 107113 | 1211 |
2132135 | 2132135 | 2022-01-20 | Tulare | California | 6107 | 105633 | 1200 |
2128882 | 2128882 | 2022-01-19 | Tulare | California | 6107 | 102511 | 1196 |
2125628 | 2125628 | 2022-01-18 | Tulare | California | 6107 | 101585 | 1199 |
2122376 | 2122376 | 2022-01-17 | Tulare | California | 6107 | 100711 | 1199 |
2119124 | 2119124 | 2022-01-16 | Tulare | California | 6107 | 97613 | 1192 |
2115872 | 2115872 | 2022-01-15 | Tulare | California | 6107 | 97613 | 1192 |
2112621 | 2112621 | 2022-01-14 | Tulare | California | 6107 | 97613 | 1192 |
2109369 | 2109369 | 2022-01-13 | Tulare | California | 6107 | 96787 | 1192 |
2106118 | 2106118 | 2022-01-12 | Tulare | California | 6107 | 94642 | 1188 |
2102867 | 2102867 | 2022-01-11 | Tulare | California | 6107 | 93873 | 1186 |
2099616 | 2099616 | 2022-01-10 | Tulare | California | 6107 | 93460 | 1186 |
2096365 | 2096365 | 2022-01-09 | Tulare | California | 6107 | 91975 | 1185 |
2093113 | 2093113 | 2022-01-08 | Tulare | California | 6107 | 91975 | 1185 |
2089861 | 2089861 | 2022-01-07 | Tulare | California | 6107 | 91975 | 1185 |
2086610 | 2086610 | 2022-01-06 | Tulare | California | 6107 | 91093 | 1179 |
2083358 | 2083358 | 2022-01-05 | Tulare | California | 6107 | 90638 | 1173 |
2080106 | 2080106 | 2022-01-04 | Tulare | California | 6107 | 90409 | 1167 |
2076854 | 2076854 | 2022-01-03 | Tulare | California | 6107 | 89686 | 1160 |
2073603 | 2073603 | 2022-01-02 | Tulare | California | 6107 | 89686 | 1160 |
2070352 | 2070352 | 2022-01-01 | Tulare | California | 6107 | 89686 | 1160 |
2067101 | 2067101 | 2021-12-31 | Tulare | California | 6107 | 89686 | 1160 |
2063850 | 2063850 | 2021-12-30 | Tulare | California | 6107 | 89497 | 1160 |
2060600 | 2060600 | 2021-12-29 | Tulare | California | 6107 | 89074 | 1156 |
2057351 | 2057351 | 2021-12-28 | Tulare | California | 6107 | 89006 | 1146 |
2054102 | 2054102 | 2021-12-27 | Tulare | California | 6107 | 88736 | 1137 |
2050852 | 2050852 | 2021-12-26 | Tulare | California | 6107 | 88736 | 1137 |
2047602 | 2047602 | 2021-12-25 | Tulare | California | 6107 | 88736 | 1137 |
2044352 | 2044352 | 2021-12-24 | Tulare | California | 6107 | 88736 | 1137 |
2041103 | 2041103 | 2021-12-23 | Tulare | California | 6107 | 88670 | 1137 |
2037853 | 2037853 | 2021-12-22 | Tulare | California | 6107 | 88375 | 1137 |
2034603 | 2034603 | 2021-12-21 | Tulare | California | 6107 | 88333 | 1129 |
2031353 | 2031353 | 2021-12-20 | Tulare | California | 6107 | 88294 | 1129 |
2028102 | 2028102 | 2021-12-19 | Tulare | California | 6107 | 88131 | 1121 |
2024851 | 2024851 | 2021-12-18 | Tulare | California | 6107 | 88131 | 1121 |
2021600 | 2021600 | 2021-12-17 | Tulare | California | 6107 | 88131 | 1121 |
2018349 | 2018349 | 2021-12-16 | Tulare | California | 6107 | 88055 | 1120 |
2015099 | 2015099 | 2021-12-15 | Tulare | California | 6107 | 87801 | 1120 |
2011848 | 2011848 | 2021-12-14 | Tulare | California | 6107 | 87756 | 1114 |
2008597 | 2008597 | 2021-12-13 | Tulare | California | 6107 | 87731 | 1115 |
2005346 | 2005346 | 2021-12-12 | Tulare | California | 6107 | 87521 | 1103 |
2002095 | 2002095 | 2021-12-11 | Tulare | California | 6107 | 87521 | 1103 |
1998845 | 1998845 | 2021-12-10 | Tulare | California | 6107 | 87521 | 1103 |
1995594 | 1995594 | 2021-12-09 | Tulare | California | 6107 | 87470 | 1102 |
1992343 | 1992343 | 2021-12-08 | Tulare | California | 6107 | 87136 | 1103 |
1989092 | 1989092 | 2021-12-07 | Tulare | California | 6107 | 87010 | 1101 |
1985842 | 1985842 | 2021-12-06 | Tulare | California | 6107 | 86979 | 1102 |
1982592 | 1982592 | 2021-12-05 | Tulare | California | 6107 | 86739 | 1100 |
1979342 | 1979342 | 2021-12-04 | Tulare | California | 6107 | 86739 | 1100 |
1976092 | 1976092 | 2021-12-03 | Tulare | California | 6107 | 86739 | 1100 |
1972843 | 1972843 | 2021-12-02 | Tulare | California | 6107 | 86678 | 1098 |
1969593 | 1969593 | 2021-12-01 | Tulare | California | 6107 | 86137 | 1099 |
1966343 | 1966343 | 2021-11-30 | Tulare | California | 6107 | 86087 | 1096 |
1963091 | 1963091 | 2021-11-29 | Tulare | California | 6107 | 86070 | 1095 |
1959840 | 1959840 | 2021-11-28 | Tulare | California | 6107 | 85614 | 1082 |
1956589 | 1956589 | 2021-11-27 | Tulare | California | 6107 | 85614 | 1082 |
1953338 | 1953338 | 2021-11-26 | Tulare | California | 6107 | 85614 | 1082 |
1950087 | 1950087 | 2021-11-25 | Tulare | California | 6107 | 85614 | 1082 |
1946836 | 1946836 | 2021-11-24 | Tulare | California | 6107 | 85614 | 1082 |
1943585 | 1943585 | 2021-11-23 | Tulare | California | 6107 | 85551 | 1075 |
1940335 | 1940335 | 2021-11-22 | Tulare | California | 6107 | 85522 | 1075 |
1937085 | 1937085 | 2021-11-21 | Tulare | California | 6107 | 85311 | 1054 |
1933835 | 1933835 | 2021-11-20 | Tulare | California | 6107 | 85311 | 1054 |
1930583 | 1930583 | 2021-11-19 | Tulare | California | 6107 | 85311 | 1054 |
1927333 | 1927333 | 2021-11-18 | Tulare | California | 6107 | 85214 | 1047 |
1924083 | 1924083 | 2021-11-17 | Tulare | California | 6107 | 84883 | 1039 |
1920834 | 1920834 | 2021-11-16 | Tulare | California | 6107 | 84828 | 1039 |
1917584 | 1917584 | 2021-11-15 | Tulare | California | 6107 | 84774 | 1037 |
1914334 | 1914334 | 2021-11-14 | Tulare | California | 6107 | 84621 | 1033 |
1911084 | 1911084 | 2021-11-13 | Tulare | California | 6107 | 84621 | 1033 |
1907835 | 1907835 | 2021-11-12 | Tulare | California | 6107 | 84369 | 1028 |
1904586 | 1904586 | 2021-11-11 | Tulare | California | 6107 | 84369 | 1028 |
1901336 | 1901336 | 2021-11-10 | Tulare | California | 6107 | 83971 | 1024 |
1898086 | 1898086 | 2021-11-09 | Tulare | California | 6107 | 83872 | 1020 |
1894836 | 1894836 | 2021-11-08 | Tulare | California | 6107 | 83818 | 1020 |
1891586 | 1891586 | 2021-11-07 | Tulare | California | 6107 | 83440 | 1010 |
1888336 | 1888336 | 2021-11-06 | Tulare | California | 6107 | 83440 | 1010 |
1885086 | 1885086 | 2021-11-05 | Tulare | California | 6107 | 83440 | 1010 |
1881837 | 1881837 | 2021-11-04 | Tulare | California | 6107 | 83261 | 1007 |
1878588 | 1878588 | 2021-11-03 | Tulare | California | 6107 | 82724 | 1002 |
1875339 | 1875339 | 2021-11-02 | Tulare | California | 6107 | 82610 | 1002 |
1872090 | 1872090 | 2021-11-01 | Tulare | California | 6107 | 82532 | 1002 |
1868841 | 1868841 | 2021-10-31 | Tulare | California | 6107 | 81967 | 995 |
1865592 | 1865592 | 2021-10-30 | Tulare | California | 6107 | 81967 | 995 |
1862343 | 1862343 | 2021-10-29 | Tulare | California | 6107 | 81967 | 995 |
1859094 | 1859094 | 2021-10-28 | Tulare | California | 6107 | 81790 | 991 |
1855845 | 1855845 | 2021-10-27 | Tulare | California | 6107 | 81266 | 991 |
1852596 | 1852596 | 2021-10-26 | Tulare | California | 6107 | 81147 | 986 |
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);