ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
122 rows where deaths = 33 and state = "California" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 28
county 28
- Humboldt 14
- San Luis Obispo 14
- Siskiyou 11
- Contra Costa 8
- San Joaquin 8
- Stanislaus 8
- Amador 7
- El Dorado 5
- Mariposa 5
- Tehama 5
- Glenn 4
- Lake 4
- Kings 3
- Sutter 3
- Tuolumne 3
- Ventura 3
- Butte 2
- Orange 2
- Placer 2
- San Francisco 2
- Shasta 2
- Los Angeles 1
- Mendocino 1
- Napa 1
- Riverside 1
- Sacramento 1
- Santa Clara 1
- Santa Cruz 1
state 1
- California · 122 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2372796 | 2372796 | 2022-04-04 | Mariposa | California | 6043 | 3015 | 33 |
2369543 | 2369543 | 2022-04-03 | Mariposa | California | 6043 | 3013 | 33 |
2366290 | 2366290 | 2022-04-02 | Mariposa | California | 6043 | 3013 | 33 |
2363037 | 2363037 | 2022-04-01 | Mariposa | California | 6043 | 3013 | 33 |
2359783 | 2359783 | 2022-03-31 | Mariposa | California | 6043 | 3013 | 33 |
1735585 | 1735585 | 2021-09-20 | Glenn | California | 6021 | 3980 | 33 |
1732335 | 1732335 | 2021-09-19 | Glenn | California | 6021 | 3964 | 33 |
1729085 | 1729085 | 2021-09-18 | Glenn | California | 6021 | 3950 | 33 |
1725835 | 1725835 | 2021-09-17 | Glenn | California | 6021 | 3946 | 33 |
1394643 | 1394643 | 2021-06-07 | Siskiyou | California | 6093 | 2379 | 33 |
1391398 | 1391398 | 2021-06-06 | Siskiyou | California | 6093 | 2375 | 33 |
1388153 | 1388153 | 2021-06-05 | Siskiyou | California | 6093 | 2375 | 33 |
1384908 | 1384908 | 2021-06-04 | Siskiyou | California | 6093 | 2375 | 33 |
1381662 | 1381662 | 2021-06-03 | Siskiyou | California | 6093 | 2370 | 33 |
1378417 | 1378417 | 2021-06-02 | Siskiyou | California | 6093 | 2363 | 33 |
1375171 | 1375171 | 2021-06-01 | Siskiyou | California | 6093 | 2359 | 33 |
1371926 | 1371926 | 2021-05-31 | Siskiyou | California | 6093 | 2352 | 33 |
1368681 | 1368681 | 2021-05-30 | Siskiyou | California | 6093 | 2352 | 33 |
1365435 | 1365435 | 2021-05-29 | Siskiyou | California | 6093 | 2352 | 33 |
1362189 | 1362189 | 2021-05-28 | Siskiyou | California | 6093 | 2352 | 33 |
1141387 | 1141387 | 2021-03-21 | Tehama | California | 6103 | 4696 | 33 |
1138141 | 1138141 | 2021-03-20 | Tehama | California | 6103 | 4685 | 33 |
1118661 | 1118661 | 2021-03-14 | Tehama | California | 6103 | 4647 | 33 |
1115414 | 1115414 | 2021-03-13 | Tehama | California | 6103 | 4638 | 33 |
1099144 | 1099144 | 2021-03-08 | Humboldt | California | 6023 | 3308 | 33 |
1095896 | 1095896 | 2021-03-07 | Humboldt | California | 6023 | 3266 | 33 |
1092650 | 1092650 | 2021-03-06 | Humboldt | California | 6023 | 3266 | 33 |
1089404 | 1089404 | 2021-03-05 | Humboldt | California | 6023 | 3266 | 33 |
1086159 | 1086159 | 2021-03-04 | Humboldt | California | 6023 | 3246 | 33 |
1082913 | 1082913 | 2021-03-03 | Humboldt | California | 6023 | 3230 | 33 |
1079667 | 1079667 | 2021-03-02 | Humboldt | California | 6023 | 3219 | 33 |
1076422 | 1076422 | 2021-03-01 | Humboldt | California | 6023 | 3210 | 33 |
1073176 | 1073176 | 2021-02-28 | Humboldt | California | 6023 | 3180 | 33 |
1069930 | 1069930 | 2021-02-27 | Humboldt | California | 6023 | 3180 | 33 |
1066685 | 1066685 | 2021-02-26 | Humboldt | California | 6023 | 3180 | 33 |
1063440 | 1063440 | 2021-02-25 | Humboldt | California | 6023 | 3160 | 33 |
1060195 | 1060195 | 2021-02-24 | Humboldt | California | 6023 | 3151 | 33 |
1056949 | 1056949 | 2021-02-23 | Humboldt | California | 6023 | 3136 | 33 |
998532 | 998532 | 2021-02-05 | Lake | California | 6033 | 2882 | 33 |
995286 | 995286 | 2021-02-04 | Lake | California | 6033 | 2869 | 33 |
992040 | 992040 | 2021-02-03 | Lake | California | 6033 | 2857 | 33 |
988780 | 988780 | 2021-02-02 | Amador | California | 6005 | 3233 | 33 |
988794 | 988794 | 2021-02-02 | Lake | California | 6033 | 2843 | 33 |
985533 | 985533 | 2021-02-01 | Amador | California | 6005 | 3211 | 33 |
982286 | 982286 | 2021-01-31 | Amador | California | 6005 | 3180 | 33 |
979040 | 979040 | 2021-01-30 | Amador | California | 6005 | 3133 | 33 |
975795 | 975795 | 2021-01-29 | Amador | California | 6005 | 3123 | 33 |
972550 | 972550 | 2021-01-28 | Amador | California | 6005 | 3115 | 33 |
969305 | 969305 | 2021-01-27 | Amador | California | 6005 | 3112 | 33 |
953100 | 953100 | 2021-01-22 | Mendocino | California | 6045 | 3234 | 33 |
920632 | 920632 | 2021-01-12 | El Dorado | California | 6017 | 6987 | 33 |
917387 | 917387 | 2021-01-11 | El Dorado | California | 6017 | 6904 | 33 |
914142 | 914142 | 2021-01-10 | El Dorado | California | 6017 | 6800 | 33 |
914188 | 914188 | 2021-01-10 | Tuolumne | California | 6109 | 3180 | 33 |
910897 | 910897 | 2021-01-09 | El Dorado | California | 6017 | 6690 | 33 |
910943 | 910943 | 2021-01-09 | Tuolumne | California | 6109 | 3180 | 33 |
907652 | 907652 | 2021-01-08 | El Dorado | California | 6017 | 6545 | 33 |
907698 | 907698 | 2021-01-08 | Tuolumne | California | 6109 | 3180 | 33 |
904425 | 904425 | 2021-01-07 | Napa | California | 6055 | 6343 | 33 |
859015 | 859015 | 2020-12-24 | Tehama | California | 6103 | 2737 | 33 |
823312 | 823312 | 2020-12-13 | Sutter | California | 6101 | 4717 | 33 |
820066 | 820066 | 2020-12-12 | Sutter | California | 6101 | 4657 | 33 |
816820 | 816820 | 2020-12-11 | Sutter | California | 6101 | 4657 | 33 |
787608 | 787608 | 2020-12-02 | Santa Cruz | California | 6087 | 4696 | 33 |
732429 | 732429 | 2020-11-15 | San Luis Obispo | California | 6079 | 5073 | 33 |
729184 | 729184 | 2020-11-14 | San Luis Obispo | California | 6079 | 5038 | 33 |
725941 | 725941 | 2020-11-13 | San Luis Obispo | California | 6079 | 5038 | 33 |
722698 | 722698 | 2020-11-12 | San Luis Obispo | California | 6079 | 4972 | 33 |
719455 | 719455 | 2020-11-11 | San Luis Obispo | California | 6079 | 4846 | 33 |
716212 | 716212 | 2020-11-10 | San Luis Obispo | California | 6079 | 4846 | 33 |
712968 | 712968 | 2020-11-09 | San Luis Obispo | California | 6079 | 4794 | 33 |
709724 | 709724 | 2020-11-08 | San Luis Obispo | California | 6079 | 4645 | 33 |
706480 | 706480 | 2020-11-07 | San Luis Obispo | California | 6079 | 4568 | 33 |
703237 | 703237 | 2020-11-06 | San Luis Obispo | California | 6079 | 4568 | 33 |
699994 | 699994 | 2020-11-05 | San Luis Obispo | California | 6079 | 4496 | 33 |
699999 | 699999 | 2020-11-05 | Shasta | California | 6089 | 2375 | 33 |
696750 | 696750 | 2020-11-04 | San Luis Obispo | California | 6079 | 4422 | 33 |
696755 | 696755 | 2020-11-04 | Shasta | California | 6089 | 2288 | 33 |
693508 | 693508 | 2020-11-03 | San Luis Obispo | California | 6079 | 4380 | 33 |
690265 | 690265 | 2020-11-02 | San Luis Obispo | California | 6079 | 4342 | 33 |
541085 | 541085 | 2020-09-17 | Butte | California | 6007 | 2704 | 33 |
537848 | 537848 | 2020-09-16 | Butte | California | 6007 | 2695 | 33 |
489357 | 489357 | 2020-09-01 | Placer | California | 6061 | 3027 | 33 |
486124 | 486124 | 2020-08-31 | Placer | California | 6061 | 3003 | 33 |
303063 | 303063 | 2020-07-05 | Kings | California | 6031 | 2673 | 33 |
299899 | 299899 | 2020-07-04 | Kings | California | 6031 | 2634 | 33 |
296737 | 296737 | 2020-07-03 | Kings | California | 6031 | 2600 | 33 |
234150 | 234150 | 2020-06-13 | Stanislaus | California | 6099 | 1092 | 33 |
231044 | 231044 | 2020-06-12 | Stanislaus | California | 6099 | 1072 | 33 |
227941 | 227941 | 2020-06-11 | Stanislaus | California | 6099 | 1072 | 33 |
224839 | 224839 | 2020-06-10 | Stanislaus | California | 6099 | 1023 | 33 |
221744 | 221744 | 2020-06-09 | Stanislaus | California | 6099 | 991 | 33 |
218649 | 218649 | 2020-06-08 | Stanislaus | California | 6099 | 937 | 33 |
215558 | 215558 | 2020-06-07 | Stanislaus | California | 6099 | 901 | 33 |
212471 | 212471 | 2020-06-06 | Stanislaus | California | 6099 | 865 | 33 |
194012 | 194012 | 2020-05-31 | Ventura | California | 6111 | 1116 | 33 |
190945 | 190945 | 2020-05-30 | Ventura | California | 6111 | 1093 | 33 |
187880 | 187880 | 2020-05-29 | Ventura | California | 6111 | 1083 | 33 |
178709 | 178709 | 2020-05-26 | San Joaquin | California | 6077 | 771 | 33 |
175665 | 175665 | 2020-05-25 | San Joaquin | California | 6077 | 760 | 33 |
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);