ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
89 rows where deaths = 59 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 20
county 20
- Tuolumne 28
- Amador 10
- Butte 10
- Placer 5
- San Benito 5
- Humboldt 4
- Siskiyou 4
- El Dorado 3
- Sacramento 3
- San Luis Obispo 3
- Yolo 3
- Alameda 2
- Napa 2
- Calaveras 1
- Imperial 1
- Mendocino 1
- Monterey 1
- Riverside 1
- San Francisco 1
- Shasta 1
state 1
- California · 89 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1823345 | 1823345 | 2021-10-17 | Siskiyou | California | 6093 | 4581 | 59 |
1820096 | 1820096 | 2021-10-16 | Siskiyou | California | 6093 | 4581 | 59 |
1816847 | 1816847 | 2021-10-15 | Siskiyou | California | 6093 | 4581 | 59 |
1813599 | 1813599 | 2021-10-14 | Siskiyou | California | 6093 | 4567 | 59 |
1761567 | 1761567 | 2021-09-28 | Amador | California | 6005 | 5070 | 59 |
1758319 | 1758319 | 2021-09-27 | Amador | California | 6005 | 5054 | 59 |
1755071 | 1755071 | 2021-09-26 | Amador | California | 6005 | 4987 | 59 |
1751823 | 1751823 | 2021-09-25 | Amador | California | 6005 | 4987 | 59 |
1748574 | 1748574 | 2021-09-24 | Amador | California | 6005 | 4987 | 59 |
1745324 | 1745324 | 2021-09-23 | Amador | California | 6005 | 4968 | 59 |
1742075 | 1742075 | 2021-09-22 | Amador | California | 6005 | 4943 | 59 |
1738826 | 1738826 | 2021-09-21 | Amador | California | 6005 | 4929 | 59 |
1735577 | 1735577 | 2021-09-20 | Amador | California | 6005 | 4921 | 59 |
1732327 | 1732327 | 2021-09-19 | Amador | California | 6005 | 4896 | 59 |
1651138 | 1651138 | 2021-08-25 | Mendocino | California | 6045 | 5796 | 59 |
1631631 | 1631631 | 2021-08-19 | Humboldt | California | 6023 | 6393 | 59 |
1628377 | 1628377 | 2021-08-18 | Calaveras | California | 6009 | 2642 | 59 |
1628384 | 1628384 | 2021-08-18 | Humboldt | California | 6023 | 6331 | 59 |
1625137 | 1625137 | 2021-08-17 | Humboldt | California | 6023 | 6252 | 59 |
1621890 | 1621890 | 2021-08-16 | Humboldt | California | 6023 | 6200 | 59 |
1141390 | 1141390 | 2021-03-21 | Tuolumne | California | 6109 | 4008 | 59 |
1138144 | 1138144 | 2021-03-20 | Tuolumne | California | 6109 | 4008 | 59 |
1134898 | 1134898 | 2021-03-19 | Tuolumne | California | 6109 | 4008 | 59 |
1131651 | 1131651 | 2021-03-18 | Tuolumne | California | 6109 | 4006 | 59 |
1128403 | 1128403 | 2021-03-17 | Tuolumne | California | 6109 | 4003 | 59 |
1125157 | 1125157 | 2021-03-16 | Tuolumne | California | 6109 | 3995 | 59 |
1121911 | 1121911 | 2021-03-15 | Tuolumne | California | 6109 | 3994 | 59 |
1118664 | 1118664 | 2021-03-14 | Tuolumne | California | 6109 | 3991 | 59 |
1115417 | 1115417 | 2021-03-13 | Tuolumne | California | 6109 | 3991 | 59 |
1112171 | 1112171 | 2021-03-12 | Tuolumne | California | 6109 | 3991 | 59 |
1108925 | 1108925 | 2021-03-11 | Tuolumne | California | 6109 | 3989 | 59 |
1105679 | 1105679 | 2021-03-10 | Tuolumne | California | 6109 | 3986 | 59 |
1102433 | 1102433 | 2021-03-09 | Tuolumne | California | 6109 | 3985 | 59 |
1099187 | 1099187 | 2021-03-08 | Tuolumne | California | 6109 | 3982 | 59 |
1095939 | 1095939 | 2021-03-07 | Tuolumne | California | 6109 | 3972 | 59 |
1092693 | 1092693 | 2021-03-06 | Tuolumne | California | 6109 | 3972 | 59 |
1089447 | 1089447 | 2021-03-05 | Tuolumne | California | 6109 | 3972 | 59 |
1086202 | 1086202 | 2021-03-04 | Tuolumne | California | 6109 | 3968 | 59 |
1082956 | 1082956 | 2021-03-03 | Tuolumne | California | 6109 | 3966 | 59 |
1079710 | 1079710 | 2021-03-02 | Tuolumne | California | 6109 | 3963 | 59 |
1076465 | 1076465 | 2021-03-01 | Tuolumne | California | 6109 | 3960 | 59 |
1073199 | 1073199 | 2021-02-28 | San Benito | California | 6069 | 5767 | 59 |
1073219 | 1073219 | 2021-02-28 | Tuolumne | California | 6109 | 3950 | 59 |
1069953 | 1069953 | 2021-02-27 | San Benito | California | 6069 | 5759 | 59 |
1069973 | 1069973 | 2021-02-27 | Tuolumne | California | 6109 | 3950 | 59 |
1066708 | 1066708 | 2021-02-26 | San Benito | California | 6069 | 5752 | 59 |
1066728 | 1066728 | 2021-02-26 | Tuolumne | California | 6109 | 3950 | 59 |
1063463 | 1063463 | 2021-02-25 | San Benito | California | 6069 | 5743 | 59 |
1063483 | 1063483 | 2021-02-25 | Tuolumne | California | 6109 | 3946 | 59 |
1060218 | 1060218 | 2021-02-24 | San Benito | California | 6069 | 5731 | 59 |
1060238 | 1060238 | 2021-02-24 | Tuolumne | California | 6109 | 3942 | 59 |
1056992 | 1056992 | 2021-02-23 | Tuolumne | California | 6109 | 3929 | 59 |
1053746 | 1053746 | 2021-02-22 | Tuolumne | California | 6109 | 3914 | 59 |
1014772 | 1014772 | 2021-02-10 | Napa | California | 6055 | 8750 | 59 |
1011527 | 1011527 | 2021-02-09 | Napa | California | 6055 | 8720 | 59 |
962822 | 962822 | 2021-01-25 | El Dorado | California | 6017 | 8003 | 59 |
959577 | 959577 | 2021-01-24 | El Dorado | California | 6017 | 7984 | 59 |
956331 | 956331 | 2021-01-23 | El Dorado | California | 6017 | 7877 | 59 |
846023 | 846023 | 2020-12-20 | San Luis Obispo | California | 6079 | 8788 | 59 |
842777 | 842777 | 2020-12-19 | San Luis Obispo | California | 6079 | 8598 | 59 |
839532 | 839532 | 2020-12-18 | San Luis Obispo | California | 6079 | 8460 | 59 |
826553 | 826553 | 2020-12-14 | Shasta | California | 6089 | 6777 | 59 |
777833 | 777833 | 2020-11-29 | Butte | California | 6007 | 3894 | 59 |
774588 | 774588 | 2020-11-28 | Butte | California | 6007 | 3894 | 59 |
771343 | 771343 | 2020-11-27 | Butte | California | 6007 | 3894 | 59 |
768098 | 768098 | 2020-11-26 | Butte | California | 6007 | 3853 | 59 |
764852 | 764852 | 2020-11-25 | Butte | California | 6007 | 3853 | 59 |
761607 | 761607 | 2020-11-24 | Butte | California | 6007 | 3812 | 59 |
758362 | 758362 | 2020-11-23 | Butte | California | 6007 | 3762 | 59 |
755115 | 755115 | 2020-11-22 | Butte | California | 6007 | 3664 | 59 |
751869 | 751869 | 2020-11-21 | Butte | California | 6007 | 3624 | 59 |
748623 | 748623 | 2020-11-20 | Butte | California | 6007 | 3624 | 59 |
690256 | 690256 | 2020-11-02 | Placer | California | 6061 | 4467 | 59 |
687011 | 687011 | 2020-11-01 | Placer | California | 6061 | 4374 | 59 |
683767 | 683767 | 2020-10-31 | Placer | California | 6061 | 4353 | 59 |
680524 | 680524 | 2020-10-30 | Placer | California | 6061 | 4353 | 59 |
677281 | 677281 | 2020-10-29 | Placer | California | 6061 | 4290 | 59 |
670822 | 670822 | 2020-10-27 | Yolo | California | 6113 | 3219 | 59 |
667579 | 667579 | 2020-10-26 | Yolo | California | 6113 | 3207 | 59 |
664334 | 664334 | 2020-10-25 | Yolo | California | 6113 | 3191 | 59 |
508753 | 508753 | 2020-09-07 | Monterey | California | 6053 | 8629 | 59 |
386162 | 386162 | 2020-07-31 | San Francisco | California | 6075 | 6578 | 59 |
249665 | 249665 | 2020-06-18 | Imperial | California | 6025 | 4659 | 59 |
215542 | 215542 | 2020-06-07 | Sacramento | California | 6067 | 1568 | 59 |
212455 | 212455 | 2020-06-06 | Sacramento | California | 6067 | 1536 | 59 |
209370 | 209370 | 2020-06-05 | Sacramento | California | 6067 | 1518 | 59 |
98336 | 98336 | 2020-04-29 | Alameda | California | 6001 | 1589 | 59 |
95491 | 95491 | 2020-04-28 | Alameda | California | 6001 | 1554 | 59 |
62080 | 62080 | 2020-04-16 | Riverside | California | 6065 | 2264 | 59 |
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);