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 |
---|---|---|---|---|---|---|---|---|---|
122018 | 122018 | Benicia | Benicia | 2022-09-22 | Solano | 95 | 4453 | 27570 | |
122019 | 122019 | Dixon | Dixon | 2022-09-22 | Solano | 95 | 5234 | 19794 | |
122020 | 122020 | Fairfield | Fairfield | 2022-09-22 | Solano | 95 | 29724 | 117149 | |
122021 | 122021 | Rio Vista | Rio Vista | 2022-09-22 | Solano | 95 | 1531 | 9416 | |
122022 | 122022 | Suisun City | Suisun City | 2022-09-22 | Solano | 95 | 7663 | 29447 | |
122023 | 122023 | Unincorporated | Other | 2022-09-22 | Solano | 95 | 222 | 19580 | |
122024 | 122024 | Vacaville | Vacaville | 2022-09-22 | Solano | 95 | 27415 | 98807 | |
122025 | 122025 | Vallejo | Vallejo | 2022-09-22 | Solano | 95 | 33165 | 119544 | |
123281 | 123281 | Benicia | Benicia | 2022-09-21 | Solano | 95 | 4443 | 27570 | |
123282 | 123282 | Dixon | Dixon | 2022-09-21 | Solano | 95 | 5225 | 19794 | |
123283 | 123283 | Fairfield | Fairfield | 2022-09-21 | Solano | 95 | 29627 | 117149 | |
123284 | 123284 | Rio Vista | Rio Vista | 2022-09-21 | Solano | 95 | 1526 | 9416 | |
123285 | 123285 | Suisun City | Suisun City | 2022-09-21 | Solano | 95 | 7651 | 29447 | |
123286 | 123286 | Unincorporated | Other | 2022-09-21 | Solano | 95 | 222 | 19580 | |
123287 | 123287 | Vacaville | Vacaville | 2022-09-21 | Solano | 95 | 27349 | 98807 | |
123288 | 123288 | Vallejo | Vallejo | 2022-09-21 | Solano | 95 | 33082 | 119544 | |
124544 | 124544 | Benicia | Benicia | 2022-09-20 | Solano | 95 | 4443 | 27570 | |
124545 | 124545 | Dixon | Dixon | 2022-09-20 | Solano | 95 | 5225 | 19794 | |
124546 | 124546 | Fairfield | Fairfield | 2022-09-20 | Solano | 95 | 29627 | 117149 | |
124547 | 124547 | Rio Vista | Rio Vista | 2022-09-20 | Solano | 95 | 1526 | 9416 | |
124548 | 124548 | Suisun City | Suisun City | 2022-09-20 | Solano | 95 | 7651 | 29447 | |
124549 | 124549 | Unincorporated | Other | 2022-09-20 | Solano | 95 | 222 | 19580 | |
124550 | 124550 | Vacaville | Vacaville | 2022-09-20 | Solano | 95 | 27349 | 98807 | |
124551 | 124551 | Vallejo | Vallejo | 2022-09-20 | Solano | 95 | 33082 | 119544 | |
125807 | 125807 | Benicia | Benicia | 2022-09-19 | Solano | 95 | 4443 | 27570 | |
125808 | 125808 | Dixon | Dixon | 2022-09-19 | Solano | 95 | 5225 | 19794 | |
125809 | 125809 | Fairfield | Fairfield | 2022-09-19 | Solano | 95 | 29627 | 117149 | |
125810 | 125810 | Rio Vista | Rio Vista | 2022-09-19 | Solano | 95 | 1526 | 9416 | |
125811 | 125811 | Suisun City | Suisun City | 2022-09-19 | Solano | 95 | 7651 | 29447 | |
125812 | 125812 | Unincorporated | Other | 2022-09-19 | Solano | 95 | 222 | 19580 | |
125813 | 125813 | Vacaville | Vacaville | 2022-09-19 | Solano | 95 | 27349 | 98807 | |
125814 | 125814 | Vallejo | Vallejo | 2022-09-19 | Solano | 95 | 33082 | 119544 | |
127070 | 127070 | Benicia | Benicia | 2022-09-18 | Solano | 95 | 4443 | 27570 | |
127071 | 127071 | Dixon | Dixon | 2022-09-18 | Solano | 95 | 5225 | 19794 | |
127072 | 127072 | Fairfield | Fairfield | 2022-09-18 | Solano | 95 | 29627 | 117149 | |
127073 | 127073 | Rio Vista | Rio Vista | 2022-09-18 | Solano | 95 | 1526 | 9416 | |
127074 | 127074 | Suisun City | Suisun City | 2022-09-18 | Solano | 95 | 7651 | 29447 | |
127075 | 127075 | Unincorporated | Other | 2022-09-18 | Solano | 95 | 222 | 19580 | |
127076 | 127076 | Vacaville | Vacaville | 2022-09-18 | Solano | 95 | 27349 | 98807 | |
127077 | 127077 | Vallejo | Vallejo | 2022-09-18 | Solano | 95 | 33082 | 119544 | |
128333 | 128333 | Benicia | Benicia | 2022-09-17 | Solano | 95 | 4443 | 27570 | |
128334 | 128334 | Dixon | Dixon | 2022-09-17 | Solano | 95 | 5225 | 19794 | |
128335 | 128335 | Fairfield | Fairfield | 2022-09-17 | Solano | 95 | 29627 | 117149 | |
128336 | 128336 | Rio Vista | Rio Vista | 2022-09-17 | Solano | 95 | 1526 | 9416 | |
128337 | 128337 | Suisun City | Suisun City | 2022-09-17 | Solano | 95 | 7651 | 29447 | |
128338 | 128338 | Unincorporated | Other | 2022-09-17 | Solano | 95 | 222 | 19580 | |
128339 | 128339 | Vacaville | Vacaville | 2022-09-17 | Solano | 95 | 27349 | 98807 | |
128340 | 128340 | Vallejo | Vallejo | 2022-09-17 | Solano | 95 | 33082 | 119544 | |
129596 | 129596 | Benicia | Benicia | 2022-09-16 | Solano | 95 | 4443 | 27570 | |
129597 | 129597 | Dixon | Dixon | 2022-09-16 | Solano | 95 | 5225 | 19794 | |
129598 | 129598 | Fairfield | Fairfield | 2022-09-16 | Solano | 95 | 29627 | 117149 | |
129599 | 129599 | Rio Vista | Rio Vista | 2022-09-16 | Solano | 95 | 1526 | 9416 | |
129600 | 129600 | Suisun City | Suisun City | 2022-09-16 | Solano | 95 | 7651 | 29447 | |
129601 | 129601 | Unincorporated | Other | 2022-09-16 | Solano | 95 | 222 | 19580 | |
129602 | 129602 | Vacaville | Vacaville | 2022-09-16 | Solano | 95 | 27349 | 98807 | |
129603 | 129603 | Vallejo | Vallejo | 2022-09-16 | Solano | 95 | 33082 | 119544 | |
130859 | 130859 | Benicia | Benicia | 2022-09-15 | Solano | 95 | 4443 | 27570 | |
130860 | 130860 | Dixon | Dixon | 2022-09-15 | Solano | 95 | 5225 | 19794 | |
130861 | 130861 | Fairfield | Fairfield | 2022-09-15 | Solano | 95 | 29627 | 117149 | |
130862 | 130862 | Rio Vista | Rio Vista | 2022-09-15 | Solano | 95 | 1526 | 9416 | |
130863 | 130863 | Suisun City | Suisun City | 2022-09-15 | Solano | 95 | 7651 | 29447 | |
130864 | 130864 | Unincorporated | Other | 2022-09-15 | Solano | 95 | 222 | 19580 | |
130865 | 130865 | Vacaville | Vacaville | 2022-09-15 | Solano | 95 | 27349 | 98807 | |
130866 | 130866 | Vallejo | Vallejo | 2022-09-15 | Solano | 95 | 33082 | 119544 | |
132122 | 132122 | Benicia | Benicia | 2022-09-14 | Solano | 95 | 4422 | 27570 | |
132123 | 132123 | Dixon | Dixon | 2022-09-14 | Solano | 95 | 5207 | 19794 | |
132124 | 132124 | Fairfield | Fairfield | 2022-09-14 | Solano | 95 | 29503 | 117149 | |
132125 | 132125 | Rio Vista | Rio Vista | 2022-09-14 | Solano | 95 | 1521 | 9416 | |
132126 | 132126 | Suisun City | Suisun City | 2022-09-14 | Solano | 95 | 7629 | 29447 | |
132127 | 132127 | Unincorporated | Other | 2022-09-14 | Solano | 95 | 221 | 19580 | |
132128 | 132128 | Vacaville | Vacaville | 2022-09-14 | Solano | 95 | 27255 | 98807 | |
132129 | 132129 | Vallejo | Vallejo | 2022-09-14 | Solano | 95 | 32978 | 119544 | |
133385 | 133385 | Benicia | Benicia | 2022-09-13 | Solano | 95 | 4422 | 27570 | |
133386 | 133386 | Dixon | Dixon | 2022-09-13 | Solano | 95 | 5207 | 19794 | |
133387 | 133387 | Fairfield | Fairfield | 2022-09-13 | Solano | 95 | 29503 | 117149 | |
133388 | 133388 | Rio Vista | Rio Vista | 2022-09-13 | Solano | 95 | 1521 | 9416 | |
133389 | 133389 | Suisun City | Suisun City | 2022-09-13 | Solano | 95 | 7629 | 29447 | |
133390 | 133390 | Unincorporated | Other | 2022-09-13 | Solano | 95 | 221 | 19580 | |
133391 | 133391 | Vacaville | Vacaville | 2022-09-13 | Solano | 95 | 27255 | 98807 | |
133392 | 133392 | Vallejo | Vallejo | 2022-09-13 | Solano | 95 | 32978 | 119544 | |
134648 | 134648 | Benicia | Benicia | 2022-09-12 | Solano | 95 | 4422 | 27570 | |
134649 | 134649 | Dixon | Dixon | 2022-09-12 | Solano | 95 | 5207 | 19794 | |
134650 | 134650 | Fairfield | Fairfield | 2022-09-12 | Solano | 95 | 29503 | 117149 | |
134651 | 134651 | Rio Vista | Rio Vista | 2022-09-12 | Solano | 95 | 1521 | 9416 | |
134652 | 134652 | Suisun City | Suisun City | 2022-09-12 | Solano | 95 | 7629 | 29447 | |
134653 | 134653 | Unincorporated | Other | 2022-09-12 | Solano | 95 | 221 | 19580 | |
134654 | 134654 | Vacaville | Vacaville | 2022-09-12 | Solano | 95 | 27255 | 98807 | |
134655 | 134655 | Vallejo | Vallejo | 2022-09-12 | Solano | 95 | 32978 | 119544 | |
135911 | 135911 | Benicia | Benicia | 2022-09-11 | Solano | 95 | 4422 | 27570 | |
135912 | 135912 | Dixon | Dixon | 2022-09-11 | Solano | 95 | 5207 | 19794 | |
135913 | 135913 | Fairfield | Fairfield | 2022-09-11 | Solano | 95 | 29503 | 117149 | |
135914 | 135914 | Rio Vista | Rio Vista | 2022-09-11 | Solano | 95 | 1521 | 9416 | |
135915 | 135915 | Suisun City | Suisun City | 2022-09-11 | Solano | 95 | 7629 | 29447 | |
135916 | 135916 | Unincorporated | Other | 2022-09-11 | Solano | 95 | 221 | 19580 | |
135917 | 135917 | Vacaville | Vacaville | 2022-09-11 | Solano | 95 | 27255 | 98807 | |
135918 | 135918 | Vallejo | Vallejo | 2022-09-11 | Solano | 95 | 32978 | 119544 | |
137174 | 137174 | Benicia | Benicia | 2022-09-10 | Solano | 95 | 4422 | 27570 | |
137175 | 137175 | Dixon | Dixon | 2022-09-10 | Solano | 95 | 5207 | 19794 | |
137176 | 137176 | Fairfield | Fairfield | 2022-09-10 | Solano | 95 | 29503 | 117149 | |
137177 | 137177 | Rio Vista | Rio Vista | 2022-09-10 | Solano | 95 | 1521 | 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 );