latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
54,961 rows where fips = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
120862 | 120862 | 94501 | 94501: Alameda | 2022-09-22 | Alameda | 1 | 10998 | 62826 | |
120863 | 120863 | 94502 | 94502: Alameda | 2022-09-22 | Alameda | 1 | 1851 | 14117 | |
120864 | 120864 | 94505 | 94505: Discovery Bay | 2022-09-22 | Alameda | 1 | 4 | 16382 | |
120865 | 120865 | 94514 | 94514: Byron | 2022-09-22 | Alameda | 1 | 3 | 1461 | |
120866 | 120866 | 94536 | 94536: Fremont | 2022-09-22 | Alameda | 1 | 12555 | 72976 | |
120867 | 120867 | 94538 | 94538: Fremont | 2022-09-22 | Alameda | 1 | 13229 | 63911 | |
120868 | 120868 | 94539 | 94539: Fremont | 2022-09-22 | Alameda | 1 | 7049 | 52960 | |
120869 | 120869 | 94541 | 94541: Hayward | 2022-09-22 | Alameda | 1 | 18224 | 65132 | |
120870 | 120870 | 94542 | 94542: Hayward | 2022-09-22 | Alameda | 1 | 2849 | 13973 | |
120871 | 120871 | 94544 | 94544: Hayward | 2022-09-22 | Alameda | 1 | 22226 | 77121 | |
120872 | 120872 | 94545 | 94545: Hayward | 2022-09-22 | Alameda | 1 | 8602 | 31657 | |
120873 | 120873 | 94546 | 94546: Castro Valley | 2022-09-22 | Alameda | 1 | 8894 | 45536 | |
120874 | 120874 | 94550 | 94550: Livermore | 2022-09-22 | Alameda | 1 | 8898 | 50138 | |
120875 | 120875 | 94551 | 94551: Livermore | 2022-09-22 | Alameda | 1 | 8328 | 38986 | |
120876 | 120876 | 94552 | 94552: Castro Valley | 2022-09-22 | Alameda | 1 | 2231 | 15204 | |
120877 | 120877 | 94555 | 94555: Fremont | 2022-09-22 | Alameda | 1 | 5538 | 36037 | |
120878 | 120878 | 94560 | 94560: Newark | 2022-09-22 | Alameda | 1 | 11000 | 44245 | |
120879 | 120879 | 94566 | 94566: Pleasanton | 2022-09-22 | Alameda | 1 | 6509 | 45046 | |
120880 | 120880 | 94568 | 94568: Dublin | 2022-09-22 | Alameda | 1 | 13040 | 58399 | |
120881 | 120881 | 94577 | 94577: San Leandro | 2022-09-22 | Alameda | 1 | 11042 | 48666 | |
120882 | 120882 | 94578 | 94578: San Leandro | 2022-09-22 | Alameda | 1 | 10485 | 40150 | |
120883 | 120883 | 94579 | 94579: San Leandro | 2022-09-22 | Alameda | 1 | 5079 | 20237 | |
120884 | 120884 | 94580 | 94580: San Lorenzo | 2022-09-22 | Alameda | 1 | 7484 | 28970 | |
120885 | 120885 | 94586 | 94586: Sunol | 2022-09-22 | Alameda | 1 | 132 | 797 | |
120886 | 120886 | 94587 | 94587: Union City | 2022-09-22 | Alameda | 1 | 15244 | 72446 | |
120887 | 120887 | 94588 | 94588: Pleasanton | 2022-09-22 | Alameda | 1 | 5408 | 31895 | |
120888 | 120888 | 94601 | 94601: Oakland | 2022-09-22 | Alameda | 1 | 15831 | 53261 | |
120889 | 120889 | 94602 | 94602: Oakland | 2022-09-22 | Alameda | 1 | 5580 | 29770 | |
120890 | 120890 | 94603 | 94603: Oakland | 2022-09-22 | Alameda | 1 | 11127 | 33241 | |
120891 | 120891 | 94605 | 94605: Oakland | 2022-09-22 | Alameda | 1 | 10366 | 42375 | |
120892 | 120892 | 94606 | 94606: Oakland | 2022-09-22 | Alameda | 1 | 8223 | 37076 | |
120893 | 120893 | 94607 | 94607: Oakland | 2022-09-22 | Alameda | 1 | 6482 | 26646 | |
120894 | 120894 | 94608 | 94608: Emeryville | 2022-09-22 | Alameda | 1 | 6710 | 31000 | |
120895 | 120895 | 94609 | 94609: Oakland | 2022-09-22 | Alameda | 1 | 4860 | 22293 | |
120896 | 120896 | 94610 | 94610: Oakland | 2022-09-22 | Alameda | 1 | 5283 | 30862 | |
120897 | 120897 | 94611 | 94611: Oakland | 2022-09-22 | Alameda | 1 | 6028 | 37826 | |
120898 | 120898 | 94612 | 94612: Oakland | 2022-09-22 | Alameda | 1 | 3941 | 17279 | |
120899 | 120899 | 94613 | 94613: Oakland | 2022-09-22 | Alameda | 1 | 6 | 212 | |
120900 | 120900 | 94618 | 94618: Oakland | 2022-09-22 | Alameda | 1 | 2138 | 15545 | |
120901 | 120901 | 94619 | 94619: Oakland | 2022-09-22 | Alameda | 1 | 4998 | 24080 | |
120902 | 120902 | 94621 | 94621: Oakland | 2022-09-22 | Alameda | 1 | 10927 | 32915 | |
120903 | 120903 | 94702 | 94702: Berkeley | 2022-09-22 | Alameda | 1 | 3160 | 16520 | |
120904 | 120904 | 94703 | 94703: Berkeley | 2022-09-22 | Alameda | 1 | 3469 | 19805 | |
120905 | 120905 | 94704 | 94704: Berkeley | 2022-09-22 | Alameda | 1 | 5010 | 29129 | |
120906 | 120906 | 94705 | 94705: Berkeley | 2022-09-22 | Alameda | 1 | 1980 | 13152 | |
120907 | 120907 | 94706 | 94706: Albany | 2022-09-22 | Alameda | 1 | 2618 | 19921 | |
120908 | 120908 | 94707 | 94707: Berkeley | 2022-09-22 | Alameda | 1 | 1079 | 12862 | |
120909 | 120909 | 94708 | 94708: Berkeley | 2022-09-22 | Alameda | 1 | 1018 | 11725 | |
120910 | 120910 | 94709 | 94709: Berkeley | 2022-09-22 | Alameda | 1 | 1610 | 11796 | |
120911 | 120911 | 94710 | 94710: Berkeley | 2022-09-22 | Alameda | 1 | 1955 | 8059 | |
120912 | 120912 | 94720 | 94720: Berkeley | 2022-09-22 | Alameda | 1 | 1064 | 1336 | |
120913 | 120913 | 95377 | 95377: Tracy | 2022-09-22 | Alameda | 1 | 1 | 32091 | |
120914 | 120914 | 95391 | 95391: Mountain House | 2022-09-22 | Alameda | 1 | 3 | 20131 | |
122125 | 122125 | 94501 | 94501: Alameda | 2022-09-21 | Alameda | 1 | 11206 | 62826 | |
122126 | 122126 | 94502 | 94502: Alameda | 2022-09-21 | Alameda | 1 | 1849 | 14117 | |
122127 | 122127 | 94505 | 94505: Discovery Bay | 2022-09-21 | Alameda | 1 | 4 | 16382 | |
122128 | 122128 | 94514 | 94514: Byron | 2022-09-21 | Alameda | 1 | 3 | 1461 | |
122129 | 122129 | 94536 | 94536: Fremont | 2022-09-21 | Alameda | 1 | 12696 | 72976 | |
122130 | 122130 | 94538 | 94538: Fremont | 2022-09-21 | Alameda | 1 | 13456 | 63911 | |
122131 | 122131 | 94539 | 94539: Fremont | 2022-09-21 | Alameda | 1 | 7168 | 52960 | |
122132 | 122132 | 94541 | 94541: Hayward | 2022-09-21 | Alameda | 1 | 18554 | 65132 | |
122133 | 122133 | 94542 | 94542: Hayward | 2022-09-21 | Alameda | 1 | 2862 | 13973 | |
122134 | 122134 | 94544 | 94544: Hayward | 2022-09-21 | Alameda | 1 | 22624 | 77121 | |
122135 | 122135 | 94545 | 94545: Hayward | 2022-09-21 | Alameda | 1 | 8747 | 31657 | |
122136 | 122136 | 94546 | 94546: Castro Valley | 2022-09-21 | Alameda | 1 | 9105 | 45536 | |
122137 | 122137 | 94550 | 94550: Livermore | 2022-09-21 | Alameda | 1 | 9039 | 50138 | |
122138 | 122138 | 94551 | 94551: Livermore | 2022-09-21 | Alameda | 1 | 8547 | 38986 | |
122139 | 122139 | 94552 | 94552: Castro Valley | 2022-09-21 | Alameda | 1 | 2244 | 15204 | |
122140 | 122140 | 94555 | 94555: Fremont | 2022-09-21 | Alameda | 1 | 5534 | 36037 | |
122141 | 122141 | 94560 | 94560: Newark | 2022-09-21 | Alameda | 1 | 11060 | 44245 | |
122142 | 122142 | 94566 | 94566: Pleasanton | 2022-09-21 | Alameda | 1 | 6641 | 45046 | |
122143 | 122143 | 94568 | 94568: Dublin | 2022-09-21 | Alameda | 1 | 14630 | 58399 | |
122144 | 122144 | 94577 | 94577: San Leandro | 2022-09-21 | Alameda | 1 | 11164 | 48666 | |
122145 | 122145 | 94578 | 94578: San Leandro | 2022-09-21 | Alameda | 1 | 10665 | 40150 | |
122146 | 122146 | 94579 | 94579: San Leandro | 2022-09-21 | Alameda | 1 | 5397 | 20237 | |
122147 | 122147 | 94580 | 94580: San Lorenzo | 2022-09-21 | Alameda | 1 | 7538 | 28970 | |
122148 | 122148 | 94586 | 94586: Sunol | 2022-09-21 | Alameda | 1 | 135 | 797 | |
122149 | 122149 | 94587 | 94587: Union City | 2022-09-21 | Alameda | 1 | 15528 | 72446 | |
122150 | 122150 | 94588 | 94588: Pleasanton | 2022-09-21 | Alameda | 1 | 5574 | 31895 | |
122151 | 122151 | 94601 | 94601: Oakland | 2022-09-21 | Alameda | 1 | 16073 | 53261 | |
122152 | 122152 | 94602 | 94602: Oakland | 2022-09-21 | Alameda | 1 | 5624 | 29770 | |
122153 | 122153 | 94603 | 94603: Oakland | 2022-09-21 | Alameda | 1 | 11560 | 33241 | |
122154 | 122154 | 94605 | 94605: Oakland | 2022-09-21 | Alameda | 1 | 10628 | 42375 | |
122155 | 122155 | 94606 | 94606: Oakland | 2022-09-21 | Alameda | 1 | 8503 | 37076 | |
122156 | 122156 | 94607 | 94607: Oakland | 2022-09-21 | Alameda | 1 | 6702 | 26646 | |
122157 | 122157 | 94608 | 94608: Emeryville | 2022-09-21 | Alameda | 1 | 6896 | 31000 | |
122158 | 122158 | 94609 | 94609: Oakland | 2022-09-21 | Alameda | 1 | 5149 | 22293 | |
122159 | 122159 | 94610 | 94610: Oakland | 2022-09-21 | Alameda | 1 | 5348 | 30862 | |
122160 | 122160 | 94611 | 94611: Oakland | 2022-09-21 | Alameda | 1 | 6083 | 37826 | |
122161 | 122161 | 94612 | 94612: Oakland | 2022-09-21 | Alameda | 1 | 4077 | 17279 | |
122162 | 122162 | 94613 | 94613: Oakland | 2022-09-21 | Alameda | 1 | 6 | 212 | |
122163 | 122163 | 94618 | 94618: Oakland | 2022-09-21 | Alameda | 1 | 2149 | 15545 | |
122164 | 122164 | 94619 | 94619: Oakland | 2022-09-21 | Alameda | 1 | 5081 | 24080 | |
122165 | 122165 | 94621 | 94621: Oakland | 2022-09-21 | Alameda | 1 | 11208 | 32915 | |
122166 | 122166 | 94702 | 94702: Berkeley | 2022-09-21 | Alameda | 1 | 3148 | 16520 | |
122167 | 122167 | 94703 | 94703: Berkeley | 2022-09-21 | Alameda | 1 | 3451 | 19805 | |
122168 | 122168 | 94704 | 94704: Berkeley | 2022-09-21 | Alameda | 1 | 4992 | 29129 | |
122169 | 122169 | 94705 | 94705: Berkeley | 2022-09-21 | Alameda | 1 | 1974 | 13152 | |
122170 | 122170 | 94706 | 94706: Albany | 2022-09-21 | Alameda | 1 | 2694 | 19921 | |
122171 | 122171 | 94707 | 94707: Berkeley | 2022-09-21 | Alameda | 1 | 1075 | 12862 |
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 );