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 |
---|---|---|---|---|---|---|---|---|---|
43185 | 43185 | Benicia | Benicia | 2022-11-24 | Solano | 95 | 4623 | 27570 | |
43186 | 43186 | Dixon | Dixon | 2022-11-24 | Solano | 95 | 5328 | 19794 | |
43187 | 43187 | Fairfield | Fairfield | 2022-11-24 | Solano | 95 | 30452 | 117149 | |
43188 | 43188 | Rio Vista | Rio Vista | 2022-11-24 | Solano | 95 | 1575 | 9416 | |
43189 | 43189 | Suisun City | Suisun City | 2022-11-24 | Solano | 95 | 7872 | 29447 | |
43190 | 43190 | Unincorporated | Other | 2022-11-24 | Solano | 95 | 225 | 19580 | |
43191 | 43191 | Vacaville | Vacaville | 2022-11-24 | Solano | 95 | 28261 | 98807 | |
43192 | 43192 | Vallejo | Vallejo | 2022-11-24 | Solano | 95 | 34140 | 119544 | |
44416 | 44416 | Benicia | Benicia | 2022-11-23 | Solano | 95 | 4623 | 27570 | |
44417 | 44417 | Dixon | Dixon | 2022-11-23 | Solano | 95 | 5328 | 19794 | |
44418 | 44418 | Fairfield | Fairfield | 2022-11-23 | Solano | 95 | 30452 | 117149 | |
44419 | 44419 | Rio Vista | Rio Vista | 2022-11-23 | Solano | 95 | 1575 | 9416 | |
44420 | 44420 | Suisun City | Suisun City | 2022-11-23 | Solano | 95 | 7872 | 29447 | |
44421 | 44421 | Unincorporated | Other | 2022-11-23 | Solano | 95 | 225 | 19580 | |
44422 | 44422 | Vacaville | Vacaville | 2022-11-23 | Solano | 95 | 28261 | 98807 | |
44423 | 44423 | Vallejo | Vallejo | 2022-11-23 | Solano | 95 | 34140 | 119544 | |
45647 | 45647 | Benicia | Benicia | 2022-11-22 | Solano | 95 | 4597 | 27570 | |
45648 | 45648 | Dixon | Dixon | 2022-11-22 | Solano | 95 | 5316 | 19794 | |
45649 | 45649 | Fairfield | Fairfield | 2022-11-22 | Solano | 95 | 30337 | 117149 | |
45650 | 45650 | Rio Vista | Rio Vista | 2022-11-22 | Solano | 95 | 1570 | 9416 | |
45651 | 45651 | Suisun City | Suisun City | 2022-11-22 | Solano | 95 | 7846 | 29447 | |
45652 | 45652 | Unincorporated | Other | 2022-11-22 | Solano | 95 | 225 | 19580 | |
45653 | 45653 | Vacaville | Vacaville | 2022-11-22 | Solano | 95 | 28125 | 98807 | |
45654 | 45654 | Vallejo | Vallejo | 2022-11-22 | Solano | 95 | 33971 | 119544 | |
46878 | 46878 | Benicia | Benicia | 2022-11-21 | Solano | 95 | 4597 | 27570 | |
46879 | 46879 | Dixon | Dixon | 2022-11-21 | Solano | 95 | 5316 | 19794 | |
46880 | 46880 | Fairfield | Fairfield | 2022-11-21 | Solano | 95 | 30337 | 117149 | |
46881 | 46881 | Rio Vista | Rio Vista | 2022-11-21 | Solano | 95 | 1570 | 9416 | |
46882 | 46882 | Suisun City | Suisun City | 2022-11-21 | Solano | 95 | 7846 | 29447 | |
46883 | 46883 | Unincorporated | Other | 2022-11-21 | Solano | 95 | 225 | 19580 | |
46884 | 46884 | Vacaville | Vacaville | 2022-11-21 | Solano | 95 | 28125 | 98807 | |
46885 | 46885 | Vallejo | Vallejo | 2022-11-21 | Solano | 95 | 33971 | 119544 | |
48109 | 48109 | Benicia | Benicia | 2022-11-20 | Solano | 95 | 4597 | 27570 | |
48110 | 48110 | Dixon | Dixon | 2022-11-20 | Solano | 95 | 5316 | 19794 | |
48111 | 48111 | Fairfield | Fairfield | 2022-11-20 | Solano | 95 | 30337 | 117149 | |
48112 | 48112 | Rio Vista | Rio Vista | 2022-11-20 | Solano | 95 | 1570 | 9416 | |
48113 | 48113 | Suisun City | Suisun City | 2022-11-20 | Solano | 95 | 7846 | 29447 | |
48114 | 48114 | Unincorporated | Other | 2022-11-20 | Solano | 95 | 225 | 19580 | |
48115 | 48115 | Vacaville | Vacaville | 2022-11-20 | Solano | 95 | 28125 | 98807 | |
48116 | 48116 | Vallejo | Vallejo | 2022-11-20 | Solano | 95 | 33971 | 119544 | |
49340 | 49340 | Benicia | Benicia | 2022-11-19 | Solano | 95 | 4597 | 27570 | |
49341 | 49341 | Dixon | Dixon | 2022-11-19 | Solano | 95 | 5316 | 19794 | |
49342 | 49342 | Fairfield | Fairfield | 2022-11-19 | Solano | 95 | 30337 | 117149 | |
49343 | 49343 | Rio Vista | Rio Vista | 2022-11-19 | Solano | 95 | 1570 | 9416 | |
49344 | 49344 | Suisun City | Suisun City | 2022-11-19 | Solano | 95 | 7846 | 29447 | |
49345 | 49345 | Unincorporated | Other | 2022-11-19 | Solano | 95 | 225 | 19580 | |
49346 | 49346 | Vacaville | Vacaville | 2022-11-19 | Solano | 95 | 28125 | 98807 | |
49347 | 49347 | Vallejo | Vallejo | 2022-11-19 | Solano | 95 | 33971 | 119544 | |
50571 | 50571 | Benicia | Benicia | 2022-11-18 | Solano | 95 | 4597 | 27570 | |
50572 | 50572 | Dixon | Dixon | 2022-11-18 | Solano | 95 | 5316 | 19794 | |
50573 | 50573 | Fairfield | Fairfield | 2022-11-18 | Solano | 95 | 30337 | 117149 | |
50574 | 50574 | Rio Vista | Rio Vista | 2022-11-18 | Solano | 95 | 1570 | 9416 | |
50575 | 50575 | Suisun City | Suisun City | 2022-11-18 | Solano | 95 | 7846 | 29447 | |
50576 | 50576 | Unincorporated | Other | 2022-11-18 | Solano | 95 | 225 | 19580 | |
50577 | 50577 | Vacaville | Vacaville | 2022-11-18 | Solano | 95 | 28125 | 98807 | |
50578 | 50578 | Vallejo | Vallejo | 2022-11-18 | Solano | 95 | 33971 | 119544 | |
51802 | 51802 | Benicia | Benicia | 2022-11-17 | Solano | 95 | 4597 | 27570 | |
51803 | 51803 | Dixon | Dixon | 2022-11-17 | Solano | 95 | 5316 | 19794 | |
51804 | 51804 | Fairfield | Fairfield | 2022-11-17 | Solano | 95 | 30337 | 117149 | |
51805 | 51805 | Rio Vista | Rio Vista | 2022-11-17 | Solano | 95 | 1570 | 9416 | |
51806 | 51806 | Suisun City | Suisun City | 2022-11-17 | Solano | 95 | 7846 | 29447 | |
51807 | 51807 | Unincorporated | Other | 2022-11-17 | Solano | 95 | 225 | 19580 | |
51808 | 51808 | Vacaville | Vacaville | 2022-11-17 | Solano | 95 | 28125 | 98807 | |
51809 | 51809 | Vallejo | Vallejo | 2022-11-17 | Solano | 95 | 33971 | 119544 | |
53033 | 53033 | Benicia | Benicia | 2022-11-16 | Solano | 95 | 4573 | 27570 | |
53034 | 53034 | Dixon | Dixon | 2022-11-16 | Solano | 95 | 5303 | 19794 | |
53035 | 53035 | Fairfield | Fairfield | 2022-11-16 | Solano | 95 | 30243 | 117149 | |
53036 | 53036 | Rio Vista | Rio Vista | 2022-11-16 | Solano | 95 | 1563 | 9416 | |
53037 | 53037 | Suisun City | Suisun City | 2022-11-16 | Solano | 95 | 7812 | 29447 | |
53038 | 53038 | Unincorporated | Other | 2022-11-16 | Solano | 95 | 225 | 19580 | |
53039 | 53039 | Vacaville | Vacaville | 2022-11-16 | Solano | 95 | 27947 | 98807 | |
53040 | 53040 | Vallejo | Vallejo | 2022-11-16 | Solano | 95 | 33836 | 119544 | |
54264 | 54264 | Benicia | Benicia | 2022-11-15 | Solano | 95 | 4573 | 27570 | |
54265 | 54265 | Dixon | Dixon | 2022-11-15 | Solano | 95 | 5303 | 19794 | |
54266 | 54266 | Fairfield | Fairfield | 2022-11-15 | Solano | 95 | 30243 | 117149 | |
54267 | 54267 | Rio Vista | Rio Vista | 2022-11-15 | Solano | 95 | 1563 | 9416 | |
54268 | 54268 | Suisun City | Suisun City | 2022-11-15 | Solano | 95 | 7812 | 29447 | |
54269 | 54269 | Unincorporated | Other | 2022-11-15 | Solano | 95 | 225 | 19580 | |
54270 | 54270 | Vacaville | Vacaville | 2022-11-15 | Solano | 95 | 27947 | 98807 | |
54271 | 54271 | Vallejo | Vallejo | 2022-11-15 | Solano | 95 | 33836 | 119544 | |
55495 | 55495 | Benicia | Benicia | 2022-11-14 | Solano | 95 | 4573 | 27570 | |
55496 | 55496 | Dixon | Dixon | 2022-11-14 | Solano | 95 | 5303 | 19794 | |
55497 | 55497 | Fairfield | Fairfield | 2022-11-14 | Solano | 95 | 30243 | 117149 | |
55498 | 55498 | Rio Vista | Rio Vista | 2022-11-14 | Solano | 95 | 1563 | 9416 | |
55499 | 55499 | Suisun City | Suisun City | 2022-11-14 | Solano | 95 | 7812 | 29447 | |
55500 | 55500 | Unincorporated | Other | 2022-11-14 | Solano | 95 | 225 | 19580 | |
55501 | 55501 | Vacaville | Vacaville | 2022-11-14 | Solano | 95 | 27947 | 98807 | |
55502 | 55502 | Vallejo | Vallejo | 2022-11-14 | Solano | 95 | 33836 | 119544 | |
56726 | 56726 | Benicia | Benicia | 2022-11-13 | Solano | 95 | 4573 | 27570 | |
56727 | 56727 | Dixon | Dixon | 2022-11-13 | Solano | 95 | 5303 | 19794 | |
56728 | 56728 | Fairfield | Fairfield | 2022-11-13 | Solano | 95 | 30243 | 117149 | |
56729 | 56729 | Rio Vista | Rio Vista | 2022-11-13 | Solano | 95 | 1563 | 9416 | |
56730 | 56730 | Suisun City | Suisun City | 2022-11-13 | Solano | 95 | 7812 | 29447 | |
56731 | 56731 | Unincorporated | Other | 2022-11-13 | Solano | 95 | 225 | 19580 | |
56732 | 56732 | Vacaville | Vacaville | 2022-11-13 | Solano | 95 | 27947 | 98807 | |
56733 | 56733 | Vallejo | Vallejo | 2022-11-13 | Solano | 95 | 33836 | 119544 | |
57957 | 57957 | Benicia | Benicia | 2022-11-12 | Solano | 95 | 4573 | 27570 | |
57958 | 57958 | Dixon | Dixon | 2022-11-12 | Solano | 95 | 5303 | 19794 | |
57959 | 57959 | Fairfield | Fairfield | 2022-11-12 | Solano | 95 | 30243 | 117149 | |
57960 | 57960 | Rio Vista | Rio Vista | 2022-11-12 | Solano | 95 | 1563 | 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 );