latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
7,936 rows where county = "Solano" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
911712 | 911712 | Benicia | Benicia | 2021-01-09 | Solano | 95 | 604 | 27570 | |
911713 | 911713 | Dixon | Dixon | 2021-01-09 | Solano | 95 | 1385 | 19794 | |
911714 | 911714 | Fairfield | Fairfield | 2021-01-09 | Solano | 95 | 6228 | 117149 | |
911715 | 911715 | Rio Vista | Rio Vista | 2021-01-09 | Solano | 95 | 205 | 9416 | |
911716 | 911716 | Suisun City | Suisun City | 2021-01-09 | Solano | 95 | 1539 | 29447 | |
911717 | 911717 | Unincorporated | Other | 2021-01-09 | Solano | 95 | 68 | 19580 | |
911718 | 911718 | Vacaville | Vacaville | 2021-01-09 | Solano | 95 | 5760 | 98807 | |
911719 | 911719 | Vallejo | Vallejo | 2021-01-09 | Solano | 95 | 6443 | 119544 | |
912988 | 912988 | Benicia | Benicia | 2021-01-08 | Solano | 95 | 604 | 27570 | |
912989 | 912989 | Dixon | Dixon | 2021-01-08 | Solano | 95 | 1385 | 19794 | |
912990 | 912990 | Fairfield | Fairfield | 2021-01-08 | Solano | 95 | 6228 | 117149 | |
912991 | 912991 | Rio Vista | Rio Vista | 2021-01-08 | Solano | 95 | 205 | 9416 | |
912992 | 912992 | Suisun City | Suisun City | 2021-01-08 | Solano | 95 | 1539 | 29447 | |
912993 | 912993 | Unincorporated | Other | 2021-01-08 | Solano | 95 | 68 | 19580 | |
912994 | 912994 | Vacaville | Vacaville | 2021-01-08 | Solano | 95 | 5760 | 98807 | |
912995 | 912995 | Vallejo | Vallejo | 2021-01-08 | Solano | 95 | 6443 | 119544 | |
914264 | 914264 | Benicia | Benicia | 2021-01-07 | Solano | 95 | 592 | 27570 | |
914265 | 914265 | Dixon | Dixon | 2021-01-07 | Solano | 95 | 1364 | 19794 | |
914266 | 914266 | Fairfield | Fairfield | 2021-01-07 | Solano | 95 | 6128 | 117149 | |
914267 | 914267 | Rio Vista | Rio Vista | 2021-01-07 | Solano | 95 | 204 | 9416 | |
914268 | 914268 | Suisun City | Suisun City | 2021-01-07 | Solano | 95 | 1520 | 29447 | |
914269 | 914269 | Unincorporated | Other | 2021-01-07 | Solano | 95 | 67 | 19580 | |
914270 | 914270 | Vacaville | Vacaville | 2021-01-07 | Solano | 95 | 5665 | 98807 | |
914271 | 914271 | Vallejo | Vallejo | 2021-01-07 | Solano | 95 | 6315 | 119544 | |
915540 | 915540 | Benicia | Benicia | 2021-01-06 | Solano | 95 | 583 | 27570 | |
915541 | 915541 | Dixon | Dixon | 2021-01-06 | Solano | 95 | 1341 | 19794 | |
915542 | 915542 | Fairfield | Fairfield | 2021-01-06 | Solano | 95 | 6053 | 117149 | |
915543 | 915543 | Rio Vista | Rio Vista | 2021-01-06 | Solano | 95 | 197 | 9416 | |
915544 | 915544 | Suisun City | Suisun City | 2021-01-06 | Solano | 95 | 1504 | 29447 | |
915545 | 915545 | Unincorporated | Other | 2021-01-06 | Solano | 95 | 67 | 19580 | |
915546 | 915546 | Vacaville | Vacaville | 2021-01-06 | Solano | 95 | 5538 | 98807 | |
915547 | 915547 | Vallejo | Vallejo | 2021-01-06 | Solano | 95 | 6237 | 119544 | |
916816 | 916816 | Benicia | Benicia | 2021-01-05 | Solano | 95 | 574 | 27570 | |
916817 | 916817 | Dixon | Dixon | 2021-01-05 | Solano | 95 | 1325 | 19794 | |
916818 | 916818 | Fairfield | Fairfield | 2021-01-05 | Solano | 95 | 5966 | 117149 | |
916819 | 916819 | Rio Vista | Rio Vista | 2021-01-05 | Solano | 95 | 194 | 9416 | |
916820 | 916820 | Suisun City | Suisun City | 2021-01-05 | Solano | 95 | 1473 | 29447 | |
916821 | 916821 | Unincorporated | Other | 2021-01-05 | Solano | 95 | 66 | 19580 | |
916822 | 916822 | Vacaville | Vacaville | 2021-01-05 | Solano | 95 | 5479 | 98807 | |
916823 | 916823 | Vallejo | Vallejo | 2021-01-05 | Solano | 95 | 6145 | 119544 | |
918092 | 918092 | Benicia | Benicia | 2021-01-04 | Solano | 95 | 565 | 27570 | |
918093 | 918093 | Dixon | Dixon | 2021-01-04 | Solano | 95 | 1311 | 19794 | |
918094 | 918094 | Fairfield | Fairfield | 2021-01-04 | Solano | 95 | 5903 | 117149 | |
918095 | 918095 | Rio Vista | Rio Vista | 2021-01-04 | Solano | 95 | 194 | 9416 | |
918096 | 918096 | Suisun City | Suisun City | 2021-01-04 | Solano | 95 | 1461 | 29447 | |
918097 | 918097 | Unincorporated | Other | 2021-01-04 | Solano | 95 | 65 | 19580 | |
918098 | 918098 | Vacaville | Vacaville | 2021-01-04 | Solano | 95 | 5362 | 98807 | |
918099 | 918099 | Vallejo | Vallejo | 2021-01-04 | Solano | 95 | 6092 | 119544 | |
919315 | 919315 | Benicia | Benicia | 2021-01-03 | Solano | 95 | 508 | 27570 | |
919316 | 919316 | Dixon | Dixon | 2021-01-03 | Solano | 95 | 1221 | 19794 | |
919317 | 919317 | Fairfield | Fairfield | 2021-01-03 | Solano | 95 | 5443 | 117149 | |
919318 | 919318 | Rio Vista | Rio Vista | 2021-01-03 | Solano | 95 | 165 | 9416 | |
919319 | 919319 | Suisun City | Suisun City | 2021-01-03 | Solano | 95 | 1346 | 29447 | |
919320 | 919320 | Unincorporated | Other | 2021-01-03 | Solano | 95 | 61 | 19580 | |
919321 | 919321 | Vacaville | Vacaville | 2021-01-03 | Solano | 95 | 4854 | 98807 | |
919322 | 919322 | Vallejo | Vallejo | 2021-01-03 | Solano | 95 | 5613 | 119544 | |
920538 | 920538 | Benicia | Benicia | 2021-01-02 | Solano | 95 | 508 | 27570 | |
920539 | 920539 | Dixon | Dixon | 2021-01-02 | Solano | 95 | 1221 | 19794 | |
920540 | 920540 | Fairfield | Fairfield | 2021-01-02 | Solano | 95 | 5443 | 117149 | |
920541 | 920541 | Rio Vista | Rio Vista | 2021-01-02 | Solano | 95 | 165 | 9416 | |
920542 | 920542 | Suisun City | Suisun City | 2021-01-02 | Solano | 95 | 1346 | 29447 | |
920543 | 920543 | Unincorporated | Other | 2021-01-02 | Solano | 95 | 61 | 19580 | |
920544 | 920544 | Vacaville | Vacaville | 2021-01-02 | Solano | 95 | 4854 | 98807 | |
920545 | 920545 | Vallejo | Vallejo | 2021-01-02 | Solano | 95 | 5613 | 119544 | |
921761 | 921761 | Benicia | Benicia | 2021-01-01 | Solano | 95 | 508 | 27570 | |
921762 | 921762 | Dixon | Dixon | 2021-01-01 | Solano | 95 | 1221 | 19794 | |
921763 | 921763 | Fairfield | Fairfield | 2021-01-01 | Solano | 95 | 5443 | 117149 | |
921764 | 921764 | Rio Vista | Rio Vista | 2021-01-01 | Solano | 95 | 165 | 9416 | |
921765 | 921765 | Suisun City | Suisun City | 2021-01-01 | Solano | 95 | 1346 | 29447 | |
921766 | 921766 | Unincorporated | Other | 2021-01-01 | Solano | 95 | 61 | 19580 | |
921767 | 921767 | Vacaville | Vacaville | 2021-01-01 | Solano | 95 | 4854 | 98807 | |
921768 | 921768 | Vallejo | Vallejo | 2021-01-01 | Solano | 95 | 5613 | 119544 | |
922984 | 922984 | Benicia | Benicia | 2020-12-31 | Solano | 95 | 508 | 27570 | |
922985 | 922985 | Dixon | Dixon | 2020-12-31 | Solano | 95 | 1221 | 19794 | |
922986 | 922986 | Fairfield | Fairfield | 2020-12-31 | Solano | 95 | 5443 | 117149 | |
922987 | 922987 | Rio Vista | Rio Vista | 2020-12-31 | Solano | 95 | 165 | 9416 | |
922988 | 922988 | Suisun City | Suisun City | 2020-12-31 | Solano | 95 | 1346 | 29447 | |
922989 | 922989 | Unincorporated | Other | 2020-12-31 | Solano | 95 | 61 | 19580 | |
922990 | 922990 | Vacaville | Vacaville | 2020-12-31 | Solano | 95 | 4854 | 98807 | |
922991 | 922991 | Vallejo | Vallejo | 2020-12-31 | Solano | 95 | 5613 | 119544 | |
924207 | 924207 | Benicia | Benicia | 2020-12-30 | Solano | 95 | 504 | 27570 | |
924208 | 924208 | Dixon | Dixon | 2020-12-30 | Solano | 95 | 1216 | 19794 | |
924209 | 924209 | Fairfield | Fairfield | 2020-12-30 | Solano | 95 | 5395 | 117149 | |
924210 | 924210 | Rio Vista | Rio Vista | 2020-12-30 | Solano | 95 | 161 | 9416 | |
924211 | 924211 | Suisun City | Suisun City | 2020-12-30 | Solano | 95 | 1330 | 29447 | |
924212 | 924212 | Unincorporated | Other | 2020-12-30 | Solano | 95 | 61 | 19580 | |
924213 | 924213 | Vacaville | Vacaville | 2020-12-30 | Solano | 95 | 4768 | 98807 | |
924214 | 924214 | Vallejo | Vallejo | 2020-12-30 | Solano | 95 | 5573 | 119544 | |
925430 | 925430 | Benicia | Benicia | 2020-12-29 | Solano | 95 | 493 | 27570 | |
925431 | 925431 | Dixon | Dixon | 2020-12-29 | Solano | 95 | 1207 | 19794 | |
925432 | 925432 | Fairfield | Fairfield | 2020-12-29 | Solano | 95 | 5322 | 117149 | |
925433 | 925433 | Rio Vista | Rio Vista | 2020-12-29 | Solano | 95 | 156 | 9416 | |
925434 | 925434 | Suisun City | Suisun City | 2020-12-29 | Solano | 95 | 1304 | 29447 | |
925435 | 925435 | Unincorporated | Other | 2020-12-29 | Solano | 95 | 61 | 19580 | |
925436 | 925436 | Vacaville | Vacaville | 2020-12-29 | Solano | 95 | 4697 | 98807 | |
925437 | 925437 | Vallejo | Vallejo | 2020-12-29 | Solano | 95 | 5486 | 119544 | |
926653 | 926653 | Benicia | Benicia | 2020-12-28 | Solano | 95 | 488 | 27570 | |
926654 | 926654 | Dixon | Dixon | 2020-12-28 | Solano | 95 | 1200 | 19794 | |
926655 | 926655 | Fairfield | Fairfield | 2020-12-28 | Solano | 95 | 5285 | 117149 | |
926656 | 926656 | Rio Vista | Rio Vista | 2020-12-28 | Solano | 95 | 156 | 9416 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );