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 |
---|---|---|---|---|---|---|---|---|---|
503392 | 503392 | Benicia | Benicia | 2021-11-25 | Solano | 95 | 1581 | 27570 | |
503393 | 503393 | Dixon | Dixon | 2021-11-25 | Solano | 95 | 2580 | 19794 | |
503394 | 503394 | Fairfield | Fairfield | 2021-11-25 | Solano | 95 | 12505 | 117149 | |
503395 | 503395 | Rio Vista | Rio Vista | 2021-11-25 | Solano | 95 | 630 | 9416 | |
503396 | 503396 | Suisun City | Suisun City | 2021-11-25 | Solano | 95 | 3306 | 29447 | |
503397 | 503397 | Unincorporated | Other | 2021-11-25 | Solano | 95 | 145 | 19580 | |
503398 | 503398 | Vacaville | Vacaville | 2021-11-25 | Solano | 95 | 12324 | 98807 | |
503399 | 503399 | Vallejo | Vallejo | 2021-11-25 | Solano | 95 | 13629 | 119544 | |
504668 | 504668 | Benicia | Benicia | 2021-11-24 | Solano | 95 | 1581 | 27570 | |
504669 | 504669 | Dixon | Dixon | 2021-11-24 | Solano | 95 | 2580 | 19794 | |
504670 | 504670 | Fairfield | Fairfield | 2021-11-24 | Solano | 95 | 12505 | 117149 | |
504671 | 504671 | Rio Vista | Rio Vista | 2021-11-24 | Solano | 95 | 630 | 9416 | |
504672 | 504672 | Suisun City | Suisun City | 2021-11-24 | Solano | 95 | 3306 | 29447 | |
504673 | 504673 | Unincorporated | Other | 2021-11-24 | Solano | 95 | 145 | 19580 | |
504674 | 504674 | Vacaville | Vacaville | 2021-11-24 | Solano | 95 | 12324 | 98807 | |
504675 | 504675 | Vallejo | Vallejo | 2021-11-24 | Solano | 95 | 13629 | 119544 | |
505944 | 505944 | Benicia | Benicia | 2021-11-23 | Solano | 95 | 1573 | 27570 | |
505945 | 505945 | Dixon | Dixon | 2021-11-23 | Solano | 95 | 2576 | 19794 | |
505946 | 505946 | Fairfield | Fairfield | 2021-11-23 | Solano | 95 | 12489 | 117149 | |
505947 | 505947 | Rio Vista | Rio Vista | 2021-11-23 | Solano | 95 | 627 | 9416 | |
505948 | 505948 | Suisun City | Suisun City | 2021-11-23 | Solano | 95 | 3297 | 29447 | |
505949 | 505949 | Unincorporated | Other | 2021-11-23 | Solano | 95 | 145 | 19580 | |
505950 | 505950 | Vacaville | Vacaville | 2021-11-23 | Solano | 95 | 12300 | 98807 | |
505951 | 505951 | Vallejo | Vallejo | 2021-11-23 | Solano | 95 | 13605 | 119544 | |
507220 | 507220 | Benicia | Benicia | 2021-11-22 | Solano | 95 | 1573 | 27570 | |
507221 | 507221 | Dixon | Dixon | 2021-11-22 | Solano | 95 | 2576 | 19794 | |
507222 | 507222 | Fairfield | Fairfield | 2021-11-22 | Solano | 95 | 12489 | 117149 | |
507223 | 507223 | Rio Vista | Rio Vista | 2021-11-22 | Solano | 95 | 627 | 9416 | |
507224 | 507224 | Suisun City | Suisun City | 2021-11-22 | Solano | 95 | 3297 | 29447 | |
507225 | 507225 | Unincorporated | Other | 2021-11-22 | Solano | 95 | 145 | 19580 | |
507226 | 507226 | Vacaville | Vacaville | 2021-11-22 | Solano | 95 | 12300 | 98807 | |
507227 | 507227 | Vallejo | Vallejo | 2021-11-22 | Solano | 95 | 13605 | 119544 | |
508496 | 508496 | Benicia | Benicia | 2021-11-21 | Solano | 95 | 1570 | 27570 | |
508497 | 508497 | Dixon | Dixon | 2021-11-21 | Solano | 95 | 2571 | 19794 | |
508498 | 508498 | Fairfield | Fairfield | 2021-11-21 | Solano | 95 | 12470 | 117149 | |
508499 | 508499 | Rio Vista | Rio Vista | 2021-11-21 | Solano | 95 | 626 | 9416 | |
508500 | 508500 | Suisun City | Suisun City | 2021-11-21 | Solano | 95 | 3288 | 29447 | |
508501 | 508501 | Unincorporated | Other | 2021-11-21 | Solano | 95 | 143 | 19580 | |
508502 | 508502 | Vacaville | Vacaville | 2021-11-21 | Solano | 95 | 12274 | 98807 | |
508503 | 508503 | Vallejo | Vallejo | 2021-11-21 | Solano | 95 | 13587 | 119544 | |
509772 | 509772 | Benicia | Benicia | 2021-11-20 | Solano | 95 | 1570 | 27570 | |
509773 | 509773 | Dixon | Dixon | 2021-11-20 | Solano | 95 | 2571 | 19794 | |
509774 | 509774 | Fairfield | Fairfield | 2021-11-20 | Solano | 95 | 12470 | 117149 | |
509775 | 509775 | Rio Vista | Rio Vista | 2021-11-20 | Solano | 95 | 626 | 9416 | |
509776 | 509776 | Suisun City | Suisun City | 2021-11-20 | Solano | 95 | 3288 | 29447 | |
509777 | 509777 | Unincorporated | Other | 2021-11-20 | Solano | 95 | 143 | 19580 | |
509778 | 509778 | Vacaville | Vacaville | 2021-11-20 | Solano | 95 | 12274 | 98807 | |
509779 | 509779 | Vallejo | Vallejo | 2021-11-20 | Solano | 95 | 13587 | 119544 | |
511048 | 511048 | Benicia | Benicia | 2021-11-19 | Solano | 95 | 1570 | 27570 | |
511049 | 511049 | Dixon | Dixon | 2021-11-19 | Solano | 95 | 2571 | 19794 | |
511050 | 511050 | Fairfield | Fairfield | 2021-11-19 | Solano | 95 | 12470 | 117149 | |
511051 | 511051 | Rio Vista | Rio Vista | 2021-11-19 | Solano | 95 | 626 | 9416 | |
511052 | 511052 | Suisun City | Suisun City | 2021-11-19 | Solano | 95 | 3288 | 29447 | |
511053 | 511053 | Unincorporated | Other | 2021-11-19 | Solano | 95 | 143 | 19580 | |
511054 | 511054 | Vacaville | Vacaville | 2021-11-19 | Solano | 95 | 12274 | 98807 | |
511055 | 511055 | Vallejo | Vallejo | 2021-11-19 | Solano | 95 | 13587 | 119544 | |
512324 | 512324 | Benicia | Benicia | 2021-11-18 | Solano | 95 | 1560 | 27570 | |
512325 | 512325 | Dixon | Dixon | 2021-11-18 | Solano | 95 | 2567 | 19794 | |
512326 | 512326 | Fairfield | Fairfield | 2021-11-18 | Solano | 95 | 12429 | 117149 | |
512327 | 512327 | Rio Vista | Rio Vista | 2021-11-18 | Solano | 95 | 625 | 9416 | |
512328 | 512328 | Suisun City | Suisun City | 2021-11-18 | Solano | 95 | 3278 | 29447 | |
512329 | 512329 | Unincorporated | Other | 2021-11-18 | Solano | 95 | 142 | 19580 | |
512330 | 512330 | Vacaville | Vacaville | 2021-11-18 | Solano | 95 | 12209 | 98807 | |
512331 | 512331 | Vallejo | Vallejo | 2021-11-18 | Solano | 95 | 13540 | 119544 | |
513600 | 513600 | Benicia | Benicia | 2021-11-17 | Solano | 95 | 1560 | 27570 | |
513601 | 513601 | Dixon | Dixon | 2021-11-17 | Solano | 95 | 2567 | 19794 | |
513602 | 513602 | Fairfield | Fairfield | 2021-11-17 | Solano | 95 | 12429 | 117149 | |
513603 | 513603 | Rio Vista | Rio Vista | 2021-11-17 | Solano | 95 | 625 | 9416 | |
513604 | 513604 | Suisun City | Suisun City | 2021-11-17 | Solano | 95 | 3278 | 29447 | |
513605 | 513605 | Unincorporated | Other | 2021-11-17 | Solano | 95 | 142 | 19580 | |
513606 | 513606 | Vacaville | Vacaville | 2021-11-17 | Solano | 95 | 12209 | 98807 | |
513607 | 513607 | Vallejo | Vallejo | 2021-11-17 | Solano | 95 | 13540 | 119544 | |
514876 | 514876 | Benicia | Benicia | 2021-11-16 | Solano | 95 | 1560 | 27570 | |
514877 | 514877 | Dixon | Dixon | 2021-11-16 | Solano | 95 | 2567 | 19794 | |
514878 | 514878 | Fairfield | Fairfield | 2021-11-16 | Solano | 95 | 12429 | 117149 | |
514879 | 514879 | Rio Vista | Rio Vista | 2021-11-16 | Solano | 95 | 625 | 9416 | |
514880 | 514880 | Suisun City | Suisun City | 2021-11-16 | Solano | 95 | 3278 | 29447 | |
514881 | 514881 | Unincorporated | Other | 2021-11-16 | Solano | 95 | 142 | 19580 | |
514882 | 514882 | Vacaville | Vacaville | 2021-11-16 | Solano | 95 | 12209 | 98807 | |
514883 | 514883 | Vallejo | Vallejo | 2021-11-16 | Solano | 95 | 13540 | 119544 | |
516152 | 516152 | Benicia | Benicia | 2021-11-15 | Solano | 95 | 1560 | 27570 | |
516153 | 516153 | Dixon | Dixon | 2021-11-15 | Solano | 95 | 2567 | 19794 | |
516154 | 516154 | Fairfield | Fairfield | 2021-11-15 | Solano | 95 | 12429 | 117149 | |
516155 | 516155 | Rio Vista | Rio Vista | 2021-11-15 | Solano | 95 | 625 | 9416 | |
516156 | 516156 | Suisun City | Suisun City | 2021-11-15 | Solano | 95 | 3278 | 29447 | |
516157 | 516157 | Unincorporated | Other | 2021-11-15 | Solano | 95 | 142 | 19580 | |
516158 | 516158 | Vacaville | Vacaville | 2021-11-15 | Solano | 95 | 12209 | 98807 | |
516159 | 516159 | Vallejo | Vallejo | 2021-11-15 | Solano | 95 | 13540 | 119544 | |
517428 | 517428 | Benicia | Benicia | 2021-11-14 | Solano | 95 | 1559 | 27570 | |
517429 | 517429 | Dixon | Dixon | 2021-11-14 | Solano | 95 | 2563 | 19794 | |
517430 | 517430 | Fairfield | Fairfield | 2021-11-14 | Solano | 95 | 12403 | 117149 | |
517431 | 517431 | Rio Vista | Rio Vista | 2021-11-14 | Solano | 95 | 621 | 9416 | |
517432 | 517432 | Suisun City | Suisun City | 2021-11-14 | Solano | 95 | 3267 | 29447 | |
517433 | 517433 | Unincorporated | Other | 2021-11-14 | Solano | 95 | 141 | 19580 | |
517434 | 517434 | Vacaville | Vacaville | 2021-11-14 | Solano | 95 | 12182 | 98807 | |
517435 | 517435 | Vallejo | Vallejo | 2021-11-14 | Solano | 95 | 13522 | 119544 | |
518704 | 518704 | Benicia | Benicia | 2021-11-13 | Solano | 95 | 1559 | 27570 | |
518705 | 518705 | Dixon | Dixon | 2021-11-13 | Solano | 95 | 2563 | 19794 | |
518706 | 518706 | Fairfield | Fairfield | 2021-11-13 | Solano | 95 | 12403 | 117149 | |
518707 | 518707 | Rio Vista | Rio Vista | 2021-11-13 | Solano | 95 | 621 | 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 );