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 |
---|---|---|---|---|---|---|---|---|---|
593988 | 593988 | Benicia | Benicia | 2021-09-15 | Solano | 95 | 1378 | 27570 | |
593989 | 593989 | Dixon | Dixon | 2021-09-15 | Solano | 95 | 2403 | 19794 | |
593990 | 593990 | Fairfield | Fairfield | 2021-09-15 | Solano | 95 | 11624 | 117149 | |
593991 | 593991 | Rio Vista | Rio Vista | 2021-09-15 | Solano | 95 | 547 | 9416 | |
593992 | 593992 | Suisun City | Suisun City | 2021-09-15 | Solano | 95 | 3045 | 29447 | |
593993 | 593993 | Unincorporated | Other | 2021-09-15 | Solano | 95 | 134 | 19580 | |
593994 | 593994 | Vacaville | Vacaville | 2021-09-15 | Solano | 95 | 11399 | 98807 | |
593995 | 593995 | Vallejo | Vallejo | 2021-09-15 | Solano | 95 | 12664 | 119544 | |
595264 | 595264 | Benicia | Benicia | 2021-09-14 | Solano | 95 | 1369 | 27570 | |
595265 | 595265 | Dixon | Dixon | 2021-09-14 | Solano | 95 | 2386 | 19794 | |
595266 | 595266 | Fairfield | Fairfield | 2021-09-14 | Solano | 95 | 11559 | 117149 | |
595267 | 595267 | Rio Vista | Rio Vista | 2021-09-14 | Solano | 95 | 542 | 9416 | |
595268 | 595268 | Suisun City | Suisun City | 2021-09-14 | Solano | 95 | 3011 | 29447 | |
595269 | 595269 | Unincorporated | Other | 2021-09-14 | Solano | 95 | 134 | 19580 | |
595270 | 595270 | Vacaville | Vacaville | 2021-09-14 | Solano | 95 | 11263 | 98807 | |
595271 | 595271 | Vallejo | Vallejo | 2021-09-14 | Solano | 95 | 12550 | 119544 | |
596540 | 596540 | Benicia | Benicia | 2021-09-13 | Solano | 95 | 1369 | 27570 | |
596541 | 596541 | Dixon | Dixon | 2021-09-13 | Solano | 95 | 2386 | 19794 | |
596542 | 596542 | Fairfield | Fairfield | 2021-09-13 | Solano | 95 | 11559 | 117149 | |
596543 | 596543 | Rio Vista | Rio Vista | 2021-09-13 | Solano | 95 | 542 | 9416 | |
596544 | 596544 | Suisun City | Suisun City | 2021-09-13 | Solano | 95 | 3011 | 29447 | |
596545 | 596545 | Unincorporated | Other | 2021-09-13 | Solano | 95 | 134 | 19580 | |
596546 | 596546 | Vacaville | Vacaville | 2021-09-13 | Solano | 95 | 11263 | 98807 | |
596547 | 596547 | Vallejo | Vallejo | 2021-09-13 | Solano | 95 | 12550 | 119544 | |
597816 | 597816 | Benicia | Benicia | 2021-09-12 | Solano | 95 | 1362 | 27570 | |
597817 | 597817 | Dixon | Dixon | 2021-09-12 | Solano | 95 | 2378 | 19794 | |
597818 | 597818 | Fairfield | Fairfield | 2021-09-12 | Solano | 95 | 11529 | 117149 | |
597819 | 597819 | Rio Vista | Rio Vista | 2021-09-12 | Solano | 95 | 539 | 9416 | |
597820 | 597820 | Suisun City | Suisun City | 2021-09-12 | Solano | 95 | 3004 | 29447 | |
597821 | 597821 | Unincorporated | Other | 2021-09-12 | Solano | 95 | 134 | 19580 | |
597822 | 597822 | Vacaville | Vacaville | 2021-09-12 | Solano | 95 | 11211 | 98807 | |
597823 | 597823 | Vallejo | Vallejo | 2021-09-12 | Solano | 95 | 12508 | 119544 | |
599092 | 599092 | Benicia | Benicia | 2021-09-11 | Solano | 95 | 1362 | 27570 | |
599093 | 599093 | Dixon | Dixon | 2021-09-11 | Solano | 95 | 2378 | 19794 | |
599094 | 599094 | Fairfield | Fairfield | 2021-09-11 | Solano | 95 | 11529 | 117149 | |
599095 | 599095 | Rio Vista | Rio Vista | 2021-09-11 | Solano | 95 | 539 | 9416 | |
599096 | 599096 | Suisun City | Suisun City | 2021-09-11 | Solano | 95 | 3004 | 29447 | |
599097 | 599097 | Unincorporated | Other | 2021-09-11 | Solano | 95 | 134 | 19580 | |
599098 | 599098 | Vacaville | Vacaville | 2021-09-11 | Solano | 95 | 11211 | 98807 | |
599099 | 599099 | Vallejo | Vallejo | 2021-09-11 | Solano | 95 | 12508 | 119544 | |
600368 | 600368 | Benicia | Benicia | 2021-09-10 | Solano | 95 | 1362 | 27570 | |
600369 | 600369 | Dixon | Dixon | 2021-09-10 | Solano | 95 | 2378 | 19794 | |
600370 | 600370 | Fairfield | Fairfield | 2021-09-10 | Solano | 95 | 11529 | 117149 | |
600371 | 600371 | Rio Vista | Rio Vista | 2021-09-10 | Solano | 95 | 539 | 9416 | |
600372 | 600372 | Suisun City | Suisun City | 2021-09-10 | Solano | 95 | 3004 | 29447 | |
600373 | 600373 | Unincorporated | Other | 2021-09-10 | Solano | 95 | 134 | 19580 | |
600374 | 600374 | Vacaville | Vacaville | 2021-09-10 | Solano | 95 | 11211 | 98807 | |
600375 | 600375 | Vallejo | Vallejo | 2021-09-10 | Solano | 95 | 12508 | 119544 | |
601644 | 601644 | Benicia | Benicia | 2021-09-09 | Solano | 95 | 1354 | 27570 | |
601645 | 601645 | Dixon | Dixon | 2021-09-09 | Solano | 95 | 2362 | 19794 | |
601646 | 601646 | Fairfield | Fairfield | 2021-09-09 | Solano | 95 | 11488 | 117149 | |
601647 | 601647 | Rio Vista | Rio Vista | 2021-09-09 | Solano | 95 | 533 | 9416 | |
601648 | 601648 | Suisun City | Suisun City | 2021-09-09 | Solano | 95 | 2989 | 29447 | |
601649 | 601649 | Unincorporated | Other | 2021-09-09 | Solano | 95 | 134 | 19580 | |
601650 | 601650 | Vacaville | Vacaville | 2021-09-09 | Solano | 95 | 11138 | 98807 | |
601651 | 601651 | Vallejo | Vallejo | 2021-09-09 | Solano | 95 | 12446 | 119544 | |
602920 | 602920 | Benicia | Benicia | 2021-09-08 | Solano | 95 | 1354 | 27570 | |
602921 | 602921 | Dixon | Dixon | 2021-09-08 | Solano | 95 | 2362 | 19794 | |
602922 | 602922 | Fairfield | Fairfield | 2021-09-08 | Solano | 95 | 11488 | 117149 | |
602923 | 602923 | Rio Vista | Rio Vista | 2021-09-08 | Solano | 95 | 533 | 9416 | |
602924 | 602924 | Suisun City | Suisun City | 2021-09-08 | Solano | 95 | 2989 | 29447 | |
602925 | 602925 | Unincorporated | Other | 2021-09-08 | Solano | 95 | 134 | 19580 | |
602926 | 602926 | Vacaville | Vacaville | 2021-09-08 | Solano | 95 | 11138 | 98807 | |
602927 | 602927 | Vallejo | Vallejo | 2021-09-08 | Solano | 95 | 12446 | 119544 | |
604196 | 604196 | Benicia | Benicia | 2021-09-07 | Solano | 95 | 1345 | 27570 | |
604197 | 604197 | Dixon | Dixon | 2021-09-07 | Solano | 95 | 2337 | 19794 | |
604198 | 604198 | Fairfield | Fairfield | 2021-09-07 | Solano | 95 | 11382 | 117149 | |
604199 | 604199 | Rio Vista | Rio Vista | 2021-09-07 | Solano | 95 | 526 | 9416 | |
604200 | 604200 | Suisun City | Suisun City | 2021-09-07 | Solano | 95 | 2955 | 29447 | |
604201 | 604201 | Unincorporated | Other | 2021-09-07 | Solano | 95 | 133 | 19580 | |
604202 | 604202 | Vacaville | Vacaville | 2021-09-07 | Solano | 95 | 11023 | 98807 | |
604203 | 604203 | Vallejo | Vallejo | 2021-09-07 | Solano | 95 | 12337 | 119544 | |
605472 | 605472 | Benicia | Benicia | 2021-09-06 | Solano | 95 | 1345 | 27570 | |
605473 | 605473 | Dixon | Dixon | 2021-09-06 | Solano | 95 | 2337 | 19794 | |
605474 | 605474 | Fairfield | Fairfield | 2021-09-06 | Solano | 95 | 11382 | 117149 | |
605475 | 605475 | Rio Vista | Rio Vista | 2021-09-06 | Solano | 95 | 526 | 9416 | |
605476 | 605476 | Suisun City | Suisun City | 2021-09-06 | Solano | 95 | 2955 | 29447 | |
605477 | 605477 | Unincorporated | Other | 2021-09-06 | Solano | 95 | 133 | 19580 | |
605478 | 605478 | Vacaville | Vacaville | 2021-09-06 | Solano | 95 | 11023 | 98807 | |
605479 | 605479 | Vallejo | Vallejo | 2021-09-06 | Solano | 95 | 12337 | 119544 | |
606748 | 606748 | Benicia | Benicia | 2021-09-05 | Solano | 95 | 1345 | 27570 | |
606749 | 606749 | Dixon | Dixon | 2021-09-05 | Solano | 95 | 2337 | 19794 | |
606750 | 606750 | Fairfield | Fairfield | 2021-09-05 | Solano | 95 | 11382 | 117149 | |
606751 | 606751 | Rio Vista | Rio Vista | 2021-09-05 | Solano | 95 | 526 | 9416 | |
606752 | 606752 | Suisun City | Suisun City | 2021-09-05 | Solano | 95 | 2955 | 29447 | |
606753 | 606753 | Unincorporated | Other | 2021-09-05 | Solano | 95 | 133 | 19580 | |
606754 | 606754 | Vacaville | Vacaville | 2021-09-05 | Solano | 95 | 11023 | 98807 | |
606755 | 606755 | Vallejo | Vallejo | 2021-09-05 | Solano | 95 | 12337 | 119544 | |
608024 | 608024 | Benicia | Benicia | 2021-09-04 | Solano | 95 | 1345 | 27570 | |
608025 | 608025 | Dixon | Dixon | 2021-09-04 | Solano | 95 | 2337 | 19794 | |
608026 | 608026 | Fairfield | Fairfield | 2021-09-04 | Solano | 95 | 11382 | 117149 | |
608027 | 608027 | Rio Vista | Rio Vista | 2021-09-04 | Solano | 95 | 526 | 9416 | |
608028 | 608028 | Suisun City | Suisun City | 2021-09-04 | Solano | 95 | 2955 | 29447 | |
608029 | 608029 | Unincorporated | Other | 2021-09-04 | Solano | 95 | 133 | 19580 | |
608030 | 608030 | Vacaville | Vacaville | 2021-09-04 | Solano | 95 | 11023 | 98807 | |
608031 | 608031 | Vallejo | Vallejo | 2021-09-04 | Solano | 95 | 12337 | 119544 | |
609300 | 609300 | Benicia | Benicia | 2021-09-03 | Solano | 95 | 1345 | 27570 | |
609301 | 609301 | Dixon | Dixon | 2021-09-03 | Solano | 95 | 2337 | 19794 | |
609302 | 609302 | Fairfield | Fairfield | 2021-09-03 | Solano | 95 | 11382 | 117149 | |
609303 | 609303 | Rio Vista | Rio Vista | 2021-09-03 | Solano | 95 | 526 | 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 );