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 |
---|---|---|---|---|---|---|---|---|---|
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 | |
293930 | 293930 | Suisun City | Suisun City | 2022-05-09 | Solano | 95 | 6109 | 29447 | |
293931 | 293931 | Unincorporated | Other | 2022-05-09 | Solano | 95 | 201 | 19580 | |
293932 | 293932 | Vacaville | Vacaville | 2022-05-09 | Solano | 95 | 22107 | 98807 | |
293933 | 293933 | Vallejo | Vallejo | 2022-05-09 | Solano | 95 | 26256 | 119544 | |
295199 | 295199 | Benicia | Benicia | 2022-05-08 | Solano | 95 | 3277 | 27570 | |
295200 | 295200 | Dixon | Dixon | 2022-05-08 | Solano | 95 | 4400 | 19794 | |
295201 | 295201 | Fairfield | Fairfield | 2022-05-08 | Solano | 95 | 23139 | 117149 | |
295202 | 295202 | Rio Vista | Rio Vista | 2022-05-08 | Solano | 95 | 1205 | 9416 | |
295203 | 295203 | Suisun City | Suisun City | 2022-05-08 | Solano | 95 | 6081 | 29447 | |
295204 | 295204 | Unincorporated | Other | 2022-05-08 | Solano | 95 | 201 | 19580 | |
295205 | 295205 | Vacaville | Vacaville | 2022-05-08 | Solano | 95 | 21990 | 98807 | |
295206 | 295206 | Vallejo | Vallejo | 2022-05-08 | Solano | 95 | 26114 | 119544 | |
296472 | 296472 | Benicia | Benicia | 2022-05-07 | Solano | 95 | 3277 | 27570 | |
296473 | 296473 | Dixon | Dixon | 2022-05-07 | Solano | 95 | 4400 | 19794 | |
296474 | 296474 | Fairfield | Fairfield | 2022-05-07 | Solano | 95 | 23139 | 117149 | |
296475 | 296475 | Rio Vista | Rio Vista | 2022-05-07 | Solano | 95 | 1205 | 9416 | |
296476 | 296476 | Suisun City | Suisun City | 2022-05-07 | Solano | 95 | 6081 | 29447 | |
296477 | 296477 | Unincorporated | Other | 2022-05-07 | Solano | 95 | 201 | 19580 | |
296478 | 296478 | Vacaville | Vacaville | 2022-05-07 | Solano | 95 | 21990 | 98807 | |
296479 | 296479 | Vallejo | Vallejo | 2022-05-07 | Solano | 95 | 26114 | 119544 | |
297745 | 297745 | Benicia | Benicia | 2022-05-06 | Solano | 95 | 3277 | 27570 | |
297746 | 297746 | Dixon | Dixon | 2022-05-06 | Solano | 95 | 4400 | 19794 | |
297747 | 297747 | Fairfield | Fairfield | 2022-05-06 | Solano | 95 | 23139 | 117149 | |
297748 | 297748 | Rio Vista | Rio Vista | 2022-05-06 | Solano | 95 | 1205 | 9416 | |
297749 | 297749 | Suisun City | Suisun City | 2022-05-06 | Solano | 95 | 6081 | 29447 | |
297750 | 297750 | Unincorporated | Other | 2022-05-06 | Solano | 95 | 201 | 19580 | |
297751 | 297751 | Vacaville | Vacaville | 2022-05-06 | Solano | 95 | 21990 | 98807 | |
297752 | 297752 | Vallejo | Vallejo | 2022-05-06 | Solano | 95 | 26114 | 119544 | |
299018 | 299018 | Benicia | Benicia | 2022-05-05 | Solano | 95 | 3277 | 27570 | |
299019 | 299019 | Dixon | Dixon | 2022-05-05 | Solano | 95 | 4400 | 19794 | |
299020 | 299020 | Fairfield | Fairfield | 2022-05-05 | Solano | 95 | 23139 | 117149 | |
299021 | 299021 | Rio Vista | Rio Vista | 2022-05-05 | Solano | 95 | 1205 | 9416 | |
299022 | 299022 | Suisun City | Suisun City | 2022-05-05 | Solano | 95 | 6081 | 29447 | |
299023 | 299023 | Unincorporated | Other | 2022-05-05 | Solano | 95 | 201 | 19580 | |
299024 | 299024 | Vacaville | Vacaville | 2022-05-05 | Solano | 95 | 21990 | 98807 | |
299025 | 299025 | Vallejo | Vallejo | 2022-05-05 | Solano | 95 | 26114 | 119544 | |
300291 | 300291 | Benicia | Benicia | 2022-05-04 | Solano | 95 | 3260 | 27570 | |
300292 | 300292 | Dixon | Dixon | 2022-05-04 | Solano | 95 | 4395 | 19794 | |
300293 | 300293 | Fairfield | Fairfield | 2022-05-04 | Solano | 95 | 23074 | 117149 | |
300294 | 300294 | Rio Vista | Rio Vista | 2022-05-04 | Solano | 95 | 1202 | 9416 | |
300295 | 300295 | Suisun City | Suisun City | 2022-05-04 | Solano | 95 | 6060 | 29447 | |
300296 | 300296 | Unincorporated | Other | 2022-05-04 | Solano | 95 | 201 | 19580 | |
300297 | 300297 | Vacaville | Vacaville | 2022-05-04 | Solano | 95 | 21925 | 98807 | |
300298 | 300298 | Vallejo | Vallejo | 2022-05-04 | Solano | 95 | 26028 | 119544 | |
301560 | 301560 | Benicia | Benicia | 2022-05-03 | Solano | 95 | 3095 | 27570 | |
301561 | 301561 | Dixon | Dixon | 2022-05-03 | Solano | 95 | 4311 | 19794 | |
301562 | 301562 | Fairfield | Fairfield | 2022-05-03 | Solano | 95 | 22432 | 117149 | |
301563 | 301563 | Rio Vista | Rio Vista | 2022-05-03 | Solano | 95 | 1181 | 9416 | |
301564 | 301564 | Suisun City | Suisun City | 2022-05-03 | Solano | 95 | 5863 | 29447 | |
301565 | 301565 | Unincorporated | Other | 2022-05-03 | Solano | 95 | 198 | 19580 | |
301566 | 301566 | Vacaville | Vacaville | 2022-05-03 | Solano | 95 | 21442 | 98807 | |
301567 | 301567 | Vallejo | Vallejo | 2022-05-03 | Solano | 95 | 25271 | 119544 | |
302829 | 302829 | Benicia | Benicia | 2022-05-02 | Solano | 95 | 3095 | 27570 | |
302830 | 302830 | Dixon | Dixon | 2022-05-02 | Solano | 95 | 4311 | 19794 | |
302831 | 302831 | Fairfield | Fairfield | 2022-05-02 | Solano | 95 | 22432 | 117149 | |
302832 | 302832 | Rio Vista | Rio Vista | 2022-05-02 | Solano | 95 | 1181 | 9416 | |
302833 | 302833 | Suisun City | Suisun City | 2022-05-02 | Solano | 95 | 5863 | 29447 | |
302834 | 302834 | Unincorporated | Other | 2022-05-02 | Solano | 95 | 198 | 19580 | |
302835 | 302835 | Vacaville | Vacaville | 2022-05-02 | Solano | 95 | 21442 | 98807 | |
302836 | 302836 | Vallejo | Vallejo | 2022-05-02 | Solano | 95 | 25271 | 119544 | |
304098 | 304098 | Benicia | Benicia | 2022-05-01 | Solano | 95 | 3095 | 27570 | |
304099 | 304099 | Dixon | Dixon | 2022-05-01 | Solano | 95 | 4311 | 19794 | |
304100 | 304100 | Fairfield | Fairfield | 2022-05-01 | Solano | 95 | 22432 | 117149 | |
304101 | 304101 | Rio Vista | Rio Vista | 2022-05-01 | Solano | 95 | 1181 | 9416 | |
304102 | 304102 | Suisun City | Suisun City | 2022-05-01 | Solano | 95 | 5863 | 29447 | |
304103 | 304103 | Unincorporated | Other | 2022-05-01 | Solano | 95 | 198 | 19580 | |
304104 | 304104 | Vacaville | Vacaville | 2022-05-01 | Solano | 95 | 21442 | 98807 | |
304105 | 304105 | Vallejo | Vallejo | 2022-05-01 | Solano | 95 | 25271 | 119544 | |
305367 | 305367 | Benicia | Benicia | 2022-04-30 | Solano | 95 | 3095 | 27570 | |
305368 | 305368 | Dixon | Dixon | 2022-04-30 | Solano | 95 | 4311 | 19794 | |
305369 | 305369 | Fairfield | Fairfield | 2022-04-30 | Solano | 95 | 22432 | 117149 | |
305370 | 305370 | Rio Vista | Rio Vista | 2022-04-30 | Solano | 95 | 1181 | 9416 | |
305371 | 305371 | Suisun City | Suisun City | 2022-04-30 | Solano | 95 | 5863 | 29447 | |
305372 | 305372 | Unincorporated | Other | 2022-04-30 | Solano | 95 | 198 | 19580 | |
305373 | 305373 | Vacaville | Vacaville | 2022-04-30 | Solano | 95 | 21442 | 98807 | |
305374 | 305374 | Vallejo | Vallejo | 2022-04-30 | Solano | 95 | 25271 | 119544 | |
306636 | 306636 | Benicia | Benicia | 2022-04-29 | Solano | 95 | 3095 | 27570 | |
306637 | 306637 | Dixon | Dixon | 2022-04-29 | Solano | 95 | 4311 | 19794 | |
306638 | 306638 | Fairfield | Fairfield | 2022-04-29 | Solano | 95 | 22432 | 117149 | |
306639 | 306639 | Rio Vista | Rio Vista | 2022-04-29 | Solano | 95 | 1181 | 9416 | |
306640 | 306640 | Suisun City | Suisun City | 2022-04-29 | Solano | 95 | 5863 | 29447 | |
306641 | 306641 | Unincorporated | Other | 2022-04-29 | Solano | 95 | 198 | 19580 | |
306642 | 306642 | Vacaville | Vacaville | 2022-04-29 | Solano | 95 | 21442 | 98807 | |
306643 | 306643 | Vallejo | Vallejo | 2022-04-29 | Solano | 95 | 25271 | 119544 | |
307905 | 307905 | Benicia | Benicia | 2022-04-28 | Solano | 95 | 3095 | 27570 | |
307906 | 307906 | Dixon | Dixon | 2022-04-28 | Solano | 95 | 4311 | 19794 | |
307907 | 307907 | Fairfield | Fairfield | 2022-04-28 | Solano | 95 | 22432 | 117149 | |
307908 | 307908 | Rio Vista | Rio Vista | 2022-04-28 | Solano | 95 | 1181 | 9416 | |
307909 | 307909 | Suisun City | Suisun City | 2022-04-28 | Solano | 95 | 5863 | 29447 | |
307910 | 307910 | Unincorporated | Other | 2022-04-28 | Solano | 95 | 198 | 19580 | |
307911 | 307911 | Vacaville | Vacaville | 2022-04-28 | Solano | 95 | 21442 | 98807 | |
307912 | 307912 | Vallejo | Vallejo | 2022-04-28 | Solano | 95 | 25271 | 119544 | |
309174 | 309174 | Benicia | Benicia | 2022-04-27 | Solano | 95 | 3095 | 27570 | |
309175 | 309175 | Dixon | Dixon | 2022-04-27 | Solano | 95 | 4311 | 19794 | |
309176 | 309176 | Fairfield | Fairfield | 2022-04-27 | Solano | 95 | 22432 | 117149 | |
309177 | 309177 | Rio Vista | Rio Vista | 2022-04-27 | Solano | 95 | 1181 | 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 );