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 |
---|---|---|---|---|---|---|---|---|---|
278650 | 278650 | Benicia | Benicia | 2022-05-21 | Solano | 95 | 3406 | 27570 | |
278651 | 278651 | Dixon | Dixon | 2022-05-21 | Solano | 95 | 4500 | 19794 | |
278652 | 278652 | Fairfield | Fairfield | 2022-05-21 | Solano | 95 | 23687 | 117149 | |
278653 | 278653 | Rio Vista | Rio Vista | 2022-05-21 | Solano | 95 | 1231 | 9416 | |
278654 | 278654 | Suisun City | Suisun City | 2022-05-21 | Solano | 95 | 6236 | 29447 | |
278655 | 278655 | Unincorporated | Other | 2022-05-21 | Solano | 95 | 203 | 19580 | |
278656 | 278656 | Vacaville | Vacaville | 2022-05-21 | Solano | 95 | 22632 | 98807 | |
278657 | 278657 | Vallejo | Vallejo | 2022-05-21 | Solano | 95 | 26789 | 119544 | |
279923 | 279923 | Benicia | Benicia | 2022-05-20 | Solano | 95 | 3406 | 27570 | |
279924 | 279924 | Dixon | Dixon | 2022-05-20 | Solano | 95 | 4500 | 19794 | |
279925 | 279925 | Fairfield | Fairfield | 2022-05-20 | Solano | 95 | 23687 | 117149 | |
279926 | 279926 | Rio Vista | Rio Vista | 2022-05-20 | Solano | 95 | 1231 | 9416 | |
279927 | 279927 | Suisun City | Suisun City | 2022-05-20 | Solano | 95 | 6236 | 29447 | |
279928 | 279928 | Unincorporated | Other | 2022-05-20 | Solano | 95 | 203 | 19580 | |
279929 | 279929 | Vacaville | Vacaville | 2022-05-20 | Solano | 95 | 22632 | 98807 | |
279930 | 279930 | Vallejo | Vallejo | 2022-05-20 | Solano | 95 | 26789 | 119544 | |
281196 | 281196 | Benicia | Benicia | 2022-05-19 | Solano | 95 | 3406 | 27570 | |
281197 | 281197 | Dixon | Dixon | 2022-05-19 | Solano | 95 | 4500 | 19794 | |
281198 | 281198 | Fairfield | Fairfield | 2022-05-19 | Solano | 95 | 23687 | 117149 | |
281199 | 281199 | Rio Vista | Rio Vista | 2022-05-19 | Solano | 95 | 1231 | 9416 | |
281200 | 281200 | Suisun City | Suisun City | 2022-05-19 | Solano | 95 | 6236 | 29447 | |
281201 | 281201 | Unincorporated | Other | 2022-05-19 | Solano | 95 | 203 | 19580 | |
281202 | 281202 | Vacaville | Vacaville | 2022-05-19 | Solano | 95 | 22632 | 98807 | |
281203 | 281203 | Vallejo | Vallejo | 2022-05-19 | Solano | 95 | 26789 | 119544 | |
282469 | 282469 | Benicia | Benicia | 2022-05-18 | Solano | 95 | 3363 | 27570 | |
282470 | 282470 | Dixon | Dixon | 2022-05-18 | Solano | 95 | 4477 | 19794 | |
282471 | 282471 | Fairfield | Fairfield | 2022-05-18 | Solano | 95 | 23539 | 117149 | |
282472 | 282472 | Rio Vista | Rio Vista | 2022-05-18 | Solano | 95 | 1223 | 9416 | |
282473 | 282473 | Suisun City | Suisun City | 2022-05-18 | Solano | 95 | 6188 | 29447 | |
282474 | 282474 | Unincorporated | Other | 2022-05-18 | Solano | 95 | 202 | 19580 | |
282475 | 282475 | Vacaville | Vacaville | 2022-05-18 | Solano | 95 | 22456 | 98807 | |
282476 | 282476 | Vallejo | Vallejo | 2022-05-18 | Solano | 95 | 26605 | 119544 | |
283742 | 283742 | Benicia | Benicia | 2022-05-17 | Solano | 95 | 3363 | 27570 | |
283743 | 283743 | Dixon | Dixon | 2022-05-17 | Solano | 95 | 4477 | 19794 | |
283744 | 283744 | Fairfield | Fairfield | 2022-05-17 | Solano | 95 | 23539 | 117149 | |
283745 | 283745 | Rio Vista | Rio Vista | 2022-05-17 | Solano | 95 | 1223 | 9416 | |
283746 | 283746 | Suisun City | Suisun City | 2022-05-17 | Solano | 95 | 6188 | 29447 | |
283747 | 283747 | Unincorporated | Other | 2022-05-17 | Solano | 95 | 202 | 19580 | |
283748 | 283748 | Vacaville | Vacaville | 2022-05-17 | Solano | 95 | 22456 | 98807 | |
283749 | 283749 | Vallejo | Vallejo | 2022-05-17 | Solano | 95 | 26605 | 119544 | |
285015 | 285015 | Benicia | Benicia | 2022-05-16 | Solano | 95 | 3363 | 27570 | |
285016 | 285016 | Dixon | Dixon | 2022-05-16 | Solano | 95 | 4477 | 19794 | |
285017 | 285017 | Fairfield | Fairfield | 2022-05-16 | Solano | 95 | 23539 | 117149 | |
285018 | 285018 | Rio Vista | Rio Vista | 2022-05-16 | Solano | 95 | 1223 | 9416 | |
285019 | 285019 | Suisun City | Suisun City | 2022-05-16 | Solano | 95 | 6188 | 29447 | |
285020 | 285020 | Unincorporated | Other | 2022-05-16 | Solano | 95 | 202 | 19580 | |
285021 | 285021 | Vacaville | Vacaville | 2022-05-16 | Solano | 95 | 22456 | 98807 | |
285022 | 285022 | Vallejo | Vallejo | 2022-05-16 | Solano | 95 | 26605 | 119544 | |
286288 | 286288 | Benicia | Benicia | 2022-05-15 | Solano | 95 | 3324 | 27570 | |
286289 | 286289 | Dixon | Dixon | 2022-05-15 | Solano | 95 | 4440 | 19794 | |
286290 | 286290 | Fairfield | Fairfield | 2022-05-15 | Solano | 95 | 23370 | 117149 | |
286291 | 286291 | Rio Vista | Rio Vista | 2022-05-15 | Solano | 95 | 1219 | 9416 | |
286292 | 286292 | Suisun City | Suisun City | 2022-05-15 | Solano | 95 | 6140 | 29447 | |
286293 | 286293 | Unincorporated | Other | 2022-05-15 | Solano | 95 | 202 | 19580 | |
286294 | 286294 | Vacaville | Vacaville | 2022-05-15 | Solano | 95 | 22302 | 98807 | |
286295 | 286295 | Vallejo | Vallejo | 2022-05-15 | Solano | 95 | 26381 | 119544 | |
287561 | 287561 | Benicia | Benicia | 2022-05-14 | Solano | 95 | 3324 | 27570 | |
287562 | 287562 | Dixon | Dixon | 2022-05-14 | Solano | 95 | 4440 | 19794 | |
287563 | 287563 | Fairfield | Fairfield | 2022-05-14 | Solano | 95 | 23370 | 117149 | |
287564 | 287564 | Rio Vista | Rio Vista | 2022-05-14 | Solano | 95 | 1219 | 9416 | |
287565 | 287565 | Suisun City | Suisun City | 2022-05-14 | Solano | 95 | 6140 | 29447 | |
287566 | 287566 | Unincorporated | Other | 2022-05-14 | Solano | 95 | 202 | 19580 | |
287567 | 287567 | Vacaville | Vacaville | 2022-05-14 | Solano | 95 | 22302 | 98807 | |
287568 | 287568 | Vallejo | Vallejo | 2022-05-14 | Solano | 95 | 26381 | 119544 | |
288834 | 288834 | Benicia | Benicia | 2022-05-13 | Solano | 95 | 3324 | 27570 | |
288835 | 288835 | Dixon | Dixon | 2022-05-13 | Solano | 95 | 4440 | 19794 | |
288836 | 288836 | Fairfield | Fairfield | 2022-05-13 | Solano | 95 | 23370 | 117149 | |
288837 | 288837 | Rio Vista | Rio Vista | 2022-05-13 | Solano | 95 | 1219 | 9416 | |
288838 | 288838 | Suisun City | Suisun City | 2022-05-13 | Solano | 95 | 6140 | 29447 | |
288839 | 288839 | Unincorporated | Other | 2022-05-13 | Solano | 95 | 202 | 19580 | |
288840 | 288840 | Vacaville | Vacaville | 2022-05-13 | Solano | 95 | 22302 | 98807 | |
288841 | 288841 | Vallejo | Vallejo | 2022-05-13 | Solano | 95 | 26381 | 119544 | |
290107 | 290107 | Benicia | Benicia | 2022-05-12 | Solano | 95 | 3324 | 27570 | |
290108 | 290108 | Dixon | Dixon | 2022-05-12 | Solano | 95 | 4440 | 19794 | |
290109 | 290109 | Fairfield | Fairfield | 2022-05-12 | Solano | 95 | 23370 | 117149 | |
290110 | 290110 | Rio Vista | Rio Vista | 2022-05-12 | Solano | 95 | 1219 | 9416 | |
290111 | 290111 | Suisun City | Suisun City | 2022-05-12 | Solano | 95 | 6140 | 29447 | |
290112 | 290112 | Unincorporated | Other | 2022-05-12 | Solano | 95 | 202 | 19580 | |
290113 | 290113 | Vacaville | Vacaville | 2022-05-12 | Solano | 95 | 22302 | 98807 | |
290114 | 290114 | Vallejo | Vallejo | 2022-05-12 | Solano | 95 | 26381 | 119544 | |
291380 | 291380 | Benicia | Benicia | 2022-05-11 | Solano | 95 | 3310 | 27570 | |
291381 | 291381 | Dixon | Dixon | 2022-05-11 | Solano | 95 | 4421 | 19794 | |
291382 | 291382 | Fairfield | Fairfield | 2022-05-11 | Solano | 95 | 23260 | 117149 | |
291383 | 291383 | Rio Vista | Rio Vista | 2022-05-11 | Solano | 95 | 1212 | 9416 | |
291384 | 291384 | Suisun City | Suisun City | 2022-05-11 | Solano | 95 | 6109 | 29447 | |
291385 | 291385 | Unincorporated | Other | 2022-05-11 | Solano | 95 | 201 | 19580 | |
291386 | 291386 | Vacaville | Vacaville | 2022-05-11 | Solano | 95 | 22107 | 98807 | |
291387 | 291387 | Vallejo | Vallejo | 2022-05-11 | Solano | 95 | 26256 | 119544 | |
292653 | 292653 | Benicia | Benicia | 2022-05-10 | Solano | 95 | 3310 | 27570 | |
292654 | 292654 | Dixon | Dixon | 2022-05-10 | Solano | 95 | 4421 | 19794 | |
292655 | 292655 | Fairfield | Fairfield | 2022-05-10 | Solano | 95 | 23260 | 117149 | |
292656 | 292656 | Rio Vista | Rio Vista | 2022-05-10 | Solano | 95 | 1212 | 9416 | |
292657 | 292657 | Suisun City | Suisun City | 2022-05-10 | Solano | 95 | 6109 | 29447 | |
292658 | 292658 | Unincorporated | Other | 2022-05-10 | Solano | 95 | 201 | 19580 | |
292659 | 292659 | Vacaville | Vacaville | 2022-05-10 | Solano | 95 | 22107 | 98807 | |
292660 | 292660 | Vallejo | Vallejo | 2022-05-10 | Solano | 95 | 26256 | 119544 | |
293926 | 293926 | Benicia | Benicia | 2022-05-09 | Solano | 95 | 3310 | 27570 | |
293927 | 293927 | Dixon | Dixon | 2022-05-09 | Solano | 95 | 4421 | 19794 | |
293928 | 293928 | Fairfield | Fairfield | 2022-05-09 | Solano | 95 | 23260 | 117149 | |
293929 | 293929 | Rio Vista | Rio Vista | 2022-05-09 | Solano | 95 | 1212 | 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 );