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 |
---|---|---|---|---|---|---|---|---|---|
954866 | 954866 | 94501 | 94501: Alameda | 2020-12-04 | Alameda | 1 | 597 | 62826 | |
954867 | 954867 | 94502 | 94502: Alameda | 2020-12-04 | Alameda | 1 | 89 | 14117 | |
954868 | 954868 | 94505 | 94505: Discovery Bay | 2020-12-04 | Alameda | 1 | 0 | 16382 | |
954869 | 954869 | 94514 | 94514: Byron | 2020-12-04 | Alameda | 1 | 0 | 1461 | |
954870 | 954870 | 94536 | 94536: Fremont | 2020-12-04 | Alameda | 1 | 887 | 72976 | |
954871 | 954871 | 94538 | 94538: Fremont | 2020-12-04 | Alameda | 1 | 907 | 63911 | |
954872 | 954872 | 94539 | 94539: Fremont | 2020-12-04 | Alameda | 1 | 322 | 52960 | |
954873 | 954873 | 94541 | 94541: Hayward | 2020-12-04 | Alameda | 1 | 2182 | 65132 | |
954874 | 954874 | 94542 | 94542: Hayward | 2020-12-04 | Alameda | 1 | 238 | 13973 | |
954875 | 954875 | 94544 | 94544: Hayward | 2020-12-04 | Alameda | 1 | 2737 | 77121 | |
954876 | 954876 | 94545 | 94545: Hayward | 2020-12-04 | Alameda | 1 | 759 | 31657 | |
954877 | 954877 | 94546 | 94546: Castro Valley | 2020-12-04 | Alameda | 1 | 649 | 45536 | |
954878 | 954878 | 94550 | 94550: Livermore | 2020-12-04 | Alameda | 1 | 730 | 50138 | |
954879 | 954879 | 94551 | 94551: Livermore | 2020-12-04 | Alameda | 1 | 731 | 38986 | |
954880 | 954880 | 94552 | 94552: Castro Valley | 2020-12-04 | Alameda | 1 | 143 | 15204 | |
954881 | 954881 | 94555 | 94555: Fremont | 2020-12-04 | Alameda | 1 | 285 | 36037 | |
954882 | 954882 | 94560 | 94560: Newark | 2020-12-04 | Alameda | 1 | 860 | 44245 | |
954883 | 954883 | 94566 | 94566: Pleasanton | 2020-12-04 | Alameda | 1 | 471 | 45046 | |
954884 | 954884 | 94568 | 94568: Dublin | 2020-12-04 | Alameda | 1 | 736 | 58399 | |
954885 | 954885 | 94577 | 94577: San Leandro | 2020-12-04 | Alameda | 1 | 1010 | 48666 | |
954886 | 954886 | 94578 | 94578: San Leandro | 2020-12-04 | Alameda | 1 | 1021 | 40150 | |
954887 | 954887 | 94579 | 94579: San Leandro | 2020-12-04 | Alameda | 1 | 302 | 20237 | |
954888 | 954888 | 94580 | 94580: San Lorenzo | 2020-12-04 | Alameda | 1 | 646 | 28970 | |
954889 | 954889 | 94586 | 94586: Sunol | 2020-12-04 | Alameda | 1 | 13 | 797 | |
954890 | 954890 | 94587 | 94587: Union City | 2020-12-04 | Alameda | 1 | 1278 | 72446 | |
954891 | 954891 | 94588 | 94588: Pleasanton | 2020-12-04 | Alameda | 1 | 325 | 31895 | |
954892 | 954892 | 94601 | 94601: Oakland | 2020-12-04 | Alameda | 1 | 2688 | 53261 | |
954893 | 954893 | 94602 | 94602: Oakland | 2020-12-04 | Alameda | 1 | 485 | 29770 | |
954894 | 954894 | 94603 | 94603: Oakland | 2020-12-04 | Alameda | 1 | 1810 | 33241 | |
954895 | 954895 | 94605 | 94605: Oakland | 2020-12-04 | Alameda | 1 | 1035 | 42375 | |
954896 | 954896 | 94606 | 94606: Oakland | 2020-12-04 | Alameda | 1 | 886 | 37076 | |
954897 | 954897 | 94607 | 94607: Oakland | 2020-12-04 | Alameda | 1 | 495 | 26646 | |
954898 | 954898 | 94608 | 94608: Emeryville | 2020-12-04 | Alameda | 1 | 433 | 31000 | |
954899 | 954899 | 94609 | 94609: Oakland | 2020-12-04 | Alameda | 1 | 334 | 22293 | |
954900 | 954900 | 94610 | 94610: Oakland | 2020-12-04 | Alameda | 1 | 268 | 30862 | |
954901 | 954901 | 94611 | 94611: Oakland | 2020-12-04 | Alameda | 1 | 319 | 37826 | |
954902 | 954902 | 94612 | 94612: Oakland | 2020-12-04 | Alameda | 1 | 191 | 17279 | |
954903 | 954903 | 94613 | 94613: Oakland | 2020-12-04 | Alameda | 1 | 0 | 212 | |
954904 | 954904 | 94618 | 94618: Oakland | 2020-12-04 | Alameda | 1 | 75 | 15545 | |
954905 | 954905 | 94619 | 94619: Oakland | 2020-12-04 | Alameda | 1 | 503 | 24080 | |
954906 | 954906 | 94621 | 94621: Oakland | 2020-12-04 | Alameda | 1 | 1799 | 32915 | |
954907 | 954907 | 94702 | 94702: Berkeley | 2020-12-04 | Alameda | 1 | 162 | 16520 | |
954908 | 954908 | 94703 | 94703: Berkeley | 2020-12-04 | Alameda | 1 | 231 | 19805 | |
954909 | 954909 | 94704 | 94704: Berkeley | 2020-12-04 | Alameda | 1 | 264 | 29129 | |
954910 | 954910 | 94705 | 94705: Berkeley | 2020-12-04 | Alameda | 1 | 94 | 13152 | |
954911 | 954911 | 94706 | 94706: Albany | 2020-12-04 | Alameda | 1 | 102 | 19921 | |
954912 | 954912 | 94707 | 94707: Berkeley | 2020-12-04 | Alameda | 1 | 52 | 12862 | |
954913 | 954913 | 94708 | 94708: Berkeley | 2020-12-04 | Alameda | 1 | 37 | 11725 | |
954914 | 954914 | 94709 | 94709: Berkeley | 2020-12-04 | Alameda | 1 | 53 | 11796 | |
954915 | 954915 | 94710 | 94710: Berkeley | 2020-12-04 | Alameda | 1 | 287 | 8059 | |
954916 | 954916 | 94720 | 94720: Berkeley | 2020-12-04 | Alameda | 1 | 25 | 1336 | |
954917 | 954917 | 95377 | 95377: Tracy | 2020-12-04 | Alameda | 1 | 0 | 32091 | |
954918 | 954918 | 95391 | 95391: Mountain House | 2020-12-04 | Alameda | 1 | 0 | 20131 | |
956077 | 956077 | 94501 | 94501: Alameda | 2020-12-03 | Alameda | 1 | 585 | 62826 | |
956078 | 956078 | 94502 | 94502: Alameda | 2020-12-03 | Alameda | 1 | 88 | 14117 | |
956079 | 956079 | 94505 | 94505: Discovery Bay | 2020-12-03 | Alameda | 1 | 0 | 16382 | |
956080 | 956080 | 94514 | 94514: Byron | 2020-12-03 | Alameda | 1 | 0 | 1461 | |
956081 | 956081 | 94536 | 94536: Fremont | 2020-12-03 | Alameda | 1 | 863 | 72976 | |
956082 | 956082 | 94538 | 94538: Fremont | 2020-12-03 | Alameda | 1 | 867 | 63911 | |
956083 | 956083 | 94539 | 94539: Fremont | 2020-12-03 | Alameda | 1 | 303 | 52960 | |
956084 | 956084 | 94541 | 94541: Hayward | 2020-12-03 | Alameda | 1 | 2101 | 65132 | |
956085 | 956085 | 94542 | 94542: Hayward | 2020-12-03 | Alameda | 1 | 227 | 13973 | |
956086 | 956086 | 94544 | 94544: Hayward | 2020-12-03 | Alameda | 1 | 2654 | 77121 | |
956087 | 956087 | 94545 | 94545: Hayward | 2020-12-03 | Alameda | 1 | 743 | 31657 | |
956088 | 956088 | 94546 | 94546: Castro Valley | 2020-12-03 | Alameda | 1 | 624 | 45536 | |
956089 | 956089 | 94550 | 94550: Livermore | 2020-12-03 | Alameda | 1 | 693 | 50138 | |
956090 | 956090 | 94551 | 94551: Livermore | 2020-12-03 | Alameda | 1 | 717 | 38986 | |
956091 | 956091 | 94552 | 94552: Castro Valley | 2020-12-03 | Alameda | 1 | 130 | 15204 | |
956092 | 956092 | 94555 | 94555: Fremont | 2020-12-03 | Alameda | 1 | 270 | 36037 | |
956093 | 956093 | 94560 | 94560: Newark | 2020-12-03 | Alameda | 1 | 834 | 44245 | |
956094 | 956094 | 94566 | 94566: Pleasanton | 2020-12-03 | Alameda | 1 | 454 | 45046 | |
956095 | 956095 | 94568 | 94568: Dublin | 2020-12-03 | Alameda | 1 | 713 | 58399 | |
956096 | 956096 | 94577 | 94577: San Leandro | 2020-12-03 | Alameda | 1 | 982 | 48666 | |
956097 | 956097 | 94578 | 94578: San Leandro | 2020-12-03 | Alameda | 1 | 991 | 40150 | |
956098 | 956098 | 94579 | 94579: San Leandro | 2020-12-03 | Alameda | 1 | 294 | 20237 | |
956099 | 956099 | 94580 | 94580: San Lorenzo | 2020-12-03 | Alameda | 1 | 629 | 28970 | |
956100 | 956100 | 94586 | 94586: Sunol | 2020-12-03 | Alameda | 1 | 13 | 797 | |
956101 | 956101 | 94587 | 94587: Union City | 2020-12-03 | Alameda | 1 | 1235 | 72446 | |
956102 | 956102 | 94588 | 94588: Pleasanton | 2020-12-03 | Alameda | 1 | 315 | 31895 | |
956103 | 956103 | 94601 | 94601: Oakland | 2020-12-03 | Alameda | 1 | 2628 | 53261 | |
956104 | 956104 | 94602 | 94602: Oakland | 2020-12-03 | Alameda | 1 | 477 | 29770 | |
956105 | 956105 | 94603 | 94603: Oakland | 2020-12-03 | Alameda | 1 | 1770 | 33241 | |
956106 | 956106 | 94605 | 94605: Oakland | 2020-12-03 | Alameda | 1 | 1020 | 42375 | |
956107 | 956107 | 94606 | 94606: Oakland | 2020-12-03 | Alameda | 1 | 863 | 37076 | |
956108 | 956108 | 94607 | 94607: Oakland | 2020-12-03 | Alameda | 1 | 486 | 26646 | |
956109 | 956109 | 94608 | 94608: Emeryville | 2020-12-03 | Alameda | 1 | 426 | 31000 | |
956110 | 956110 | 94609 | 94609: Oakland | 2020-12-03 | Alameda | 1 | 326 | 22293 | |
956111 | 956111 | 94610 | 94610: Oakland | 2020-12-03 | Alameda | 1 | 259 | 30862 | |
956112 | 956112 | 94611 | 94611: Oakland | 2020-12-03 | Alameda | 1 | 313 | 37826 | |
956113 | 956113 | 94612 | 94612: Oakland | 2020-12-03 | Alameda | 1 | 187 | 17279 | |
956114 | 956114 | 94613 | 94613: Oakland | 2020-12-03 | Alameda | 1 | 0 | 212 | |
956115 | 956115 | 94618 | 94618: Oakland | 2020-12-03 | Alameda | 1 | 71 | 15545 | |
956116 | 956116 | 94619 | 94619: Oakland | 2020-12-03 | Alameda | 1 | 494 | 24080 | |
956117 | 956117 | 94621 | 94621: Oakland | 2020-12-03 | Alameda | 1 | 1777 | 32915 | |
956118 | 956118 | 94702 | 94702: Berkeley | 2020-12-03 | Alameda | 1 | 158 | 16520 | |
956119 | 956119 | 94703 | 94703: Berkeley | 2020-12-03 | Alameda | 1 | 225 | 19805 | |
956120 | 956120 | 94704 | 94704: Berkeley | 2020-12-03 | Alameda | 1 | 263 | 29129 | |
956121 | 956121 | 94705 | 94705: Berkeley | 2020-12-03 | Alameda | 1 | 92 | 13152 | |
956122 | 956122 | 94706 | 94706: Albany | 2020-12-03 | Alameda | 1 | 96 | 19921 | |
956123 | 956123 | 94707 | 94707: Berkeley | 2020-12-03 | Alameda | 1 | 47 | 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 );