ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where deaths = 84 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2301210 | 2301210 | 2022-03-13 | Amador | California | 6005 | 9078 | 84 |
2297958 | 2297958 | 2022-03-12 | Amador | California | 6005 | 9078 | 84 |
2294706 | 2294706 | 2022-03-11 | Amador | California | 6005 | 9078 | 84 |
2291454 | 2291454 | 2022-03-10 | Amador | California | 6005 | 9060 | 84 |
2288202 | 2288202 | 2022-03-09 | Amador | California | 6005 | 9060 | 84 |
2284951 | 2284951 | 2022-03-08 | Amador | California | 6005 | 9021 | 84 |
2281699 | 2281699 | 2022-03-07 | Amador | California | 6005 | 9020 | 84 |
2145146 | 2145146 | 2022-01-24 | Siskiyou | California | 6093 | 6259 | 84 |
1943536 | 1943536 | 2021-11-23 | Calaveras | California | 6009 | 4356 | 84 |
1940286 | 1940286 | 2021-11-22 | Calaveras | California | 6009 | 4349 | 84 |
1937036 | 1937036 | 2021-11-21 | Calaveras | California | 6009 | 4330 | 84 |
1933786 | 1933786 | 2021-11-20 | Calaveras | California | 6009 | 4330 | 84 |
1930534 | 1930534 | 2021-11-19 | Calaveras | California | 6009 | 4330 | 84 |
1927284 | 1927284 | 2021-11-18 | Calaveras | California | 6009 | 4321 | 84 |
1917535 | 1917535 | 2021-11-15 | Calaveras | California | 6009 | 4286 | 84 |
1901287 | 1901287 | 2021-11-10 | Calaveras | California | 6009 | 4233 | 84 |
1781084 | 1781084 | 2021-10-04 | Mendocino | California | 6045 | 7309 | 84 |
1777834 | 1777834 | 2021-10-03 | Mendocino | California | 6045 | 7239 | 84 |
1774584 | 1774584 | 2021-10-02 | Mendocino | California | 6045 | 7239 | 84 |
1771334 | 1771334 | 2021-10-01 | Mendocino | California | 6045 | 7239 | 84 |
1768085 | 1768085 | 2021-09-30 | Mendocino | California | 6045 | 7191 | 84 |
1738875 | 1738875 | 2021-09-21 | Tehama | California | 6103 | 8277 | 84 |
1735626 | 1735626 | 2021-09-20 | Tehama | California | 6103 | 8237 | 84 |
1732336 | 1732336 | 2021-09-19 | Humboldt | California | 6023 | 8262 | 84 |
1732376 | 1732376 | 2021-09-19 | Tehama | California | 6103 | 8211 | 84 |
1729086 | 1729086 | 2021-09-18 | Humboldt | California | 6023 | 8231 | 84 |
1729126 | 1729126 | 2021-09-18 | Tehama | California | 6103 | 8176 | 84 |
1725836 | 1725836 | 2021-09-17 | Humboldt | California | 6023 | 8190 | 84 |
1157599 | 1157599 | 2021-03-26 | Nevada | California | 6057 | 4219 | 84 |
966109 | 966109 | 2021-01-26 | Sutter | California | 6101 | 8129 | 84 |
807091 | 807091 | 2020-12-08 | Yolo | California | 6113 | 5549 | 84 |
803846 | 803846 | 2020-12-07 | Yolo | California | 6113 | 5492 | 84 |
800601 | 800601 | 2020-12-06 | Yolo | California | 6113 | 5372 | 84 |
797356 | 797356 | 2020-12-05 | Yolo | California | 6113 | 5310 | 84 |
699970 | 699970 | 2020-11-05 | Kings | California | 6031 | 8817 | 84 |
696726 | 696726 | 2020-11-04 | Kings | California | 6031 | 8783 | 84 |
693484 | 693484 | 2020-11-03 | Kings | California | 6031 | 8673 | 84 |
690241 | 690241 | 2020-11-02 | Kings | California | 6031 | 8641 | 84 |
648082 | 648082 | 2020-10-20 | Monterey | California | 6053 | 11158 | 84 |
499064 | 499064 | 2020-09-04 | San Francisco | California | 6075 | 9758 | 84 |
495831 | 495831 | 2020-09-03 | San Francisco | California | 6075 | 9699 | 84 |
492597 | 492597 | 2020-09-02 | San Francisco | California | 6075 | 9620 | 84 |
453805 | 453805 | 2020-08-21 | Marin | California | 6041 | 5879 | 84 |
450598 | 450598 | 2020-08-20 | Santa Barbara | California | 6083 | 7578 | 84 |
312559 | 312559 | 2020-07-08 | Fresno | California | 6019 | 7281 | 84 |
309394 | 309394 | 2020-07-07 | Kern | California | 6029 | 5553 | 84 |
209377 | 209377 | 2020-06-05 | San Mateo | California | 6081 | 2299 | 84 |
206296 | 206296 | 2020-06-04 | San Mateo | California | 6081 | 2244 | 84 |
203216 | 203216 | 2020-06-03 | San Mateo | California | 6081 | 2212 | 84 |
200140 | 200140 | 2020-06-02 | San Mateo | California | 6081 | 2190 | 84 |
197067 | 197067 | 2020-06-01 | San Mateo | California | 6081 | 2169 | 84 |
193997 | 193997 | 2020-05-31 | San Mateo | California | 6081 | 2129 | 84 |
194010 | 194010 | 2020-05-31 | Tulare | California | 6107 | 1879 | 84 |
190930 | 190930 | 2020-05-30 | San Mateo | California | 6081 | 2104 | 84 |
190943 | 190943 | 2020-05-30 | Tulare | California | 6107 | 1852 | 84 |
187865 | 187865 | 2020-05-29 | San Mateo | California | 6081 | 2070 | 84 |
187878 | 187878 | 2020-05-29 | Tulare | California | 6107 | 1844 | 84 |
145380 | 145380 | 2020-05-15 | Alameda | California | 6001 | 2321 | 84 |
145407 | 145407 | 2020-05-15 | Orange | California | 6059 | 4163 | 84 |
73102 | 73102 | 2020-04-20 | Santa Clara | California | 6085 | 1922 | 84 |
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);