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 |
---|---|---|---|---|---|---|---|---|---|
955957 | 955957 | Benicia | Benicia | 2020-12-04 | Solano | 95 | 300 | 27570 | |
955958 | 955958 | Dixon | Dixon | 2020-12-04 | Solano | 95 | 814 | 19794 | |
955959 | 955959 | Fairfield | Fairfield | 2020-12-04 | Solano | 95 | 3430 | 117149 | |
955960 | 955960 | Rio Vista | Rio Vista | 2020-12-04 | Solano | 95 | 97 | 9416 | |
955961 | 955961 | Suisun City | Suisun City | 2020-12-04 | Solano | 95 | 789 | 29447 | |
955962 | 955962 | Unincorporated | Other | 2020-12-04 | Solano | 95 | 40 | 19580 | |
955963 | 955963 | Vacaville | Vacaville | 2020-12-04 | Solano | 95 | 2363 | 98807 | |
955964 | 955964 | Vallejo | Vallejo | 2020-12-04 | Solano | 95 | 3580 | 119544 | |
957168 | 957168 | Benicia | Benicia | 2020-12-03 | Solano | 95 | 293 | 27570 | |
957169 | 957169 | Dixon | Dixon | 2020-12-03 | Solano | 95 | 787 | 19794 | |
957170 | 957170 | Fairfield | Fairfield | 2020-12-03 | Solano | 95 | 3338 | 117149 | |
957171 | 957171 | Rio Vista | Rio Vista | 2020-12-03 | Solano | 95 | 95 | 9416 | |
957172 | 957172 | Suisun City | Suisun City | 2020-12-03 | Solano | 95 | 770 | 29447 | |
957173 | 957173 | Unincorporated | Other | 2020-12-03 | Solano | 95 | 40 | 19580 | |
957174 | 957174 | Vacaville | Vacaville | 2020-12-03 | Solano | 95 | 2295 | 98807 | |
957175 | 957175 | Vallejo | Vallejo | 2020-12-03 | Solano | 95 | 3501 | 119544 | |
958379 | 958379 | Benicia | Benicia | 2020-12-02 | Solano | 95 | 290 | 27570 | |
958380 | 958380 | Dixon | Dixon | 2020-12-02 | Solano | 95 | 769 | 19794 | |
958381 | 958381 | Fairfield | Fairfield | 2020-12-02 | Solano | 95 | 3303 | 117149 | |
958382 | 958382 | Rio Vista | Rio Vista | 2020-12-02 | Solano | 95 | 94 | 9416 | |
958383 | 958383 | Suisun City | Suisun City | 2020-12-02 | Solano | 95 | 755 | 29447 | |
958384 | 958384 | Unincorporated | Other | 2020-12-02 | Solano | 95 | 40 | 19580 | |
958385 | 958385 | Vacaville | Vacaville | 2020-12-02 | Solano | 95 | 2255 | 98807 | |
958386 | 958386 | Vallejo | Vallejo | 2020-12-02 | Solano | 95 | 3451 | 119544 | |
959590 | 959590 | Benicia | Benicia | 2020-12-01 | Solano | 95 | 287 | 27570 | |
959591 | 959591 | Dixon | Dixon | 2020-12-01 | Solano | 95 | 745 | 19794 | |
959592 | 959592 | Fairfield | Fairfield | 2020-12-01 | Solano | 95 | 3243 | 117149 | |
959593 | 959593 | Rio Vista | Rio Vista | 2020-12-01 | Solano | 95 | 93 | 9416 | |
959594 | 959594 | Suisun City | Suisun City | 2020-12-01 | Solano | 95 | 743 | 29447 | |
959595 | 959595 | Unincorporated | Other | 2020-12-01 | Solano | 95 | 40 | 19580 | |
959596 | 959596 | Vacaville | Vacaville | 2020-12-01 | Solano | 95 | 2206 | 98807 | |
959597 | 959597 | Vallejo | Vallejo | 2020-12-01 | Solano | 95 | 3374 | 119544 | |
960801 | 960801 | Benicia | Benicia | 2020-11-30 | Solano | 95 | 286 | 27570 | |
960802 | 960802 | Dixon | Dixon | 2020-11-30 | Solano | 95 | 738 | 19794 | |
960803 | 960803 | Fairfield | Fairfield | 2020-11-30 | Solano | 95 | 3225 | 117149 | |
960804 | 960804 | Rio Vista | Rio Vista | 2020-11-30 | Solano | 95 | 91 | 9416 | |
960805 | 960805 | Suisun City | Suisun City | 2020-11-30 | Solano | 95 | 739 | 29447 | |
960806 | 960806 | Unincorporated | Other | 2020-11-30 | Solano | 95 | 40 | 19580 | |
960807 | 960807 | Vacaville | Vacaville | 2020-11-30 | Solano | 95 | 2185 | 98807 | |
960808 | 960808 | Vallejo | Vallejo | 2020-11-30 | Solano | 95 | 3344 | 119544 | |
962012 | 962012 | Benicia | Benicia | 2020-11-29 | Solano | 95 | 276 | 27570 | |
962013 | 962013 | Dixon | Dixon | 2020-11-29 | Solano | 95 | 670 | 19794 | |
962014 | 962014 | Fairfield | Fairfield | 2020-11-29 | Solano | 95 | 3076 | 117149 | |
962015 | 962015 | Rio Vista | Rio Vista | 2020-11-29 | Solano | 95 | 80 | 9416 | |
962016 | 962016 | Suisun City | Suisun City | 2020-11-29 | Solano | 95 | 691 | 29447 | |
962017 | 962017 | Unincorporated | Other | 2020-11-29 | Solano | 95 | 39 | 19580 | |
962018 | 962018 | Vacaville | Vacaville | 2020-11-29 | Solano | 95 | 2030 | 98807 | |
962019 | 962019 | Vallejo | Vallejo | 2020-11-29 | Solano | 95 | 3174 | 119544 | |
963223 | 963223 | Benicia | Benicia | 2020-11-28 | Solano | 95 | 276 | 27570 | |
963224 | 963224 | Dixon | Dixon | 2020-11-28 | Solano | 95 | 670 | 19794 | |
963225 | 963225 | Fairfield | Fairfield | 2020-11-28 | Solano | 95 | 3076 | 117149 | |
963226 | 963226 | Rio Vista | Rio Vista | 2020-11-28 | Solano | 95 | 80 | 9416 | |
963227 | 963227 | Suisun City | Suisun City | 2020-11-28 | Solano | 95 | 691 | 29447 | |
963228 | 963228 | Unincorporated | Other | 2020-11-28 | Solano | 95 | 39 | 19580 | |
963229 | 963229 | Vacaville | Vacaville | 2020-11-28 | Solano | 95 | 2030 | 98807 | |
963230 | 963230 | Vallejo | Vallejo | 2020-11-28 | Solano | 95 | 3174 | 119544 | |
964434 | 964434 | Benicia | Benicia | 2020-11-27 | Solano | 95 | 276 | 27570 | |
964435 | 964435 | Dixon | Dixon | 2020-11-27 | Solano | 95 | 670 | 19794 | |
964436 | 964436 | Fairfield | Fairfield | 2020-11-27 | Solano | 95 | 3076 | 117149 | |
964437 | 964437 | Rio Vista | Rio Vista | 2020-11-27 | Solano | 95 | 80 | 9416 | |
964438 | 964438 | Suisun City | Suisun City | 2020-11-27 | Solano | 95 | 691 | 29447 | |
964439 | 964439 | Unincorporated | Other | 2020-11-27 | Solano | 95 | 39 | 19580 | |
964440 | 964440 | Vacaville | Vacaville | 2020-11-27 | Solano | 95 | 2030 | 98807 | |
964441 | 964441 | Vallejo | Vallejo | 2020-11-27 | Solano | 95 | 3174 | 119544 | |
965645 | 965645 | Benicia | Benicia | 2020-11-26 | Solano | 95 | 276 | 27570 | |
965646 | 965646 | Dixon | Dixon | 2020-11-26 | Solano | 95 | 670 | 19794 | |
965647 | 965647 | Fairfield | Fairfield | 2020-11-26 | Solano | 95 | 3076 | 117149 | |
965648 | 965648 | Rio Vista | Rio Vista | 2020-11-26 | Solano | 95 | 80 | 9416 | |
965649 | 965649 | Suisun City | Suisun City | 2020-11-26 | Solano | 95 | 691 | 29447 | |
965650 | 965650 | Unincorporated | Other | 2020-11-26 | Solano | 95 | 39 | 19580 | |
965651 | 965651 | Vacaville | Vacaville | 2020-11-26 | Solano | 95 | 2030 | 98807 | |
965652 | 965652 | Vallejo | Vallejo | 2020-11-26 | Solano | 95 | 3174 | 119544 | |
966856 | 966856 | Benicia | Benicia | 2020-11-25 | Solano | 95 | 276 | 27570 | |
966857 | 966857 | Dixon | Dixon | 2020-11-25 | Solano | 95 | 670 | 19794 | |
966858 | 966858 | Fairfield | Fairfield | 2020-11-25 | Solano | 95 | 3076 | 117149 | |
966859 | 966859 | Rio Vista | Rio Vista | 2020-11-25 | Solano | 95 | 80 | 9416 | |
966860 | 966860 | Suisun City | Suisun City | 2020-11-25 | Solano | 95 | 691 | 29447 | |
966861 | 966861 | Unincorporated | Other | 2020-11-25 | Solano | 95 | 39 | 19580 | |
966862 | 966862 | Vacaville | Vacaville | 2020-11-25 | Solano | 95 | 2030 | 98807 | |
966863 | 966863 | Vallejo | Vallejo | 2020-11-25 | Solano | 95 | 3174 | 119544 | |
968067 | 968067 | Benicia | Benicia | 2020-11-24 | Solano | 95 | 272 | 27570 | |
968068 | 968068 | Dixon | Dixon | 2020-11-24 | Solano | 95 | 659 | 19794 | |
968069 | 968069 | Fairfield | Fairfield | 2020-11-24 | Solano | 95 | 3049 | 117149 | |
968070 | 968070 | Rio Vista | Rio Vista | 2020-11-24 | Solano | 95 | 79 | 9416 | |
968071 | 968071 | Suisun City | Suisun City | 2020-11-24 | Solano | 95 | 681 | 29447 | |
968072 | 968072 | Unincorporated | Other | 2020-11-24 | Solano | 95 | 32 | 19580 | |
968073 | 968073 | Vacaville | Vacaville | 2020-11-24 | Solano | 95 | 2008 | 98807 | |
968074 | 968074 | Vallejo | Vallejo | 2020-11-24 | Solano | 95 | 3138 | 119544 | |
969278 | 969278 | Benicia | Benicia | 2020-11-23 | Solano | 95 | 251 | 27570 | |
969279 | 969279 | Dixon | Dixon | 2020-11-23 | Solano | 95 | 604 | 19794 | |
969280 | 969280 | Fairfield | Fairfield | 2020-11-23 | Solano | 95 | 2903 | 117149 | |
969281 | 969281 | Rio Vista | Rio Vista | 2020-11-23 | Solano | 95 | 75 | 9416 | |
969282 | 969282 | Suisun City | Suisun City | 2020-11-23 | Solano | 95 | 638 | 29447 | |
969283 | 969283 | Unincorporated | Other | 2020-11-23 | Solano | 95 | 32 | 19580 | |
969284 | 969284 | Vacaville | Vacaville | 2020-11-23 | Solano | 95 | 1838 | 98807 | |
969285 | 969285 | Vallejo | Vallejo | 2020-11-23 | Solano | 95 | 3008 | 119544 | |
970489 | 970489 | Benicia | Benicia | 2020-11-22 | Solano | 95 | 251 | 27570 | |
970490 | 970490 | Dixon | Dixon | 2020-11-22 | Solano | 95 | 604 | 19794 | |
970491 | 970491 | Fairfield | Fairfield | 2020-11-22 | Solano | 95 | 2903 | 117149 | |
970492 | 970492 | Rio Vista | Rio Vista | 2020-11-22 | Solano | 95 | 75 | 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 );