latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
53 rows where "date" is on date 2022-07-15 and 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 |
---|---|---|---|---|---|---|---|---|---|
208009 | 208009 | 94501 | 94501: Alameda | 2022-07-15 | Alameda | 1 | 10080 | 62826 | |
208010 | 208010 | 94502 | 94502: Alameda | 2022-07-15 | Alameda | 1 | 1690 | 14117 | |
208011 | 208011 | 94505 | 94505: Discovery Bay | 2022-07-15 | Alameda | 1 | 4 | 16382 | |
208012 | 208012 | 94514 | 94514: Byron | 2022-07-15 | Alameda | 1 | 4 | 1461 | |
208013 | 208013 | 94536 | 94536: Fremont | 2022-07-15 | Alameda | 1 | 11441 | 72976 | |
208014 | 208014 | 94538 | 94538: Fremont | 2022-07-15 | Alameda | 1 | 12017 | 63911 | |
208015 | 208015 | 94539 | 94539: Fremont | 2022-07-15 | Alameda | 1 | 6346 | 52960 | |
208016 | 208016 | 94541 | 94541: Hayward | 2022-07-15 | Alameda | 1 | 16965 | 65132 | |
208017 | 208017 | 94542 | 94542: Hayward | 2022-07-15 | Alameda | 1 | 2609 | 13973 | |
208018 | 208018 | 94544 | 94544: Hayward | 2022-07-15 | Alameda | 1 | 20621 | 77121 | |
208019 | 208019 | 94545 | 94545: Hayward | 2022-07-15 | Alameda | 1 | 8007 | 31657 | |
208020 | 208020 | 94546 | 94546: Castro Valley | 2022-07-15 | Alameda | 1 | 8200 | 45536 | |
208021 | 208021 | 94550 | 94550: Livermore | 2022-07-15 | Alameda | 1 | 8361 | 50138 | |
208022 | 208022 | 94551 | 94551: Livermore | 2022-07-15 | Alameda | 1 | 7838 | 38986 | |
208023 | 208023 | 94552 | 94552: Castro Valley | 2022-07-15 | Alameda | 1 | 2065 | 15204 | |
208024 | 208024 | 94555 | 94555: Fremont | 2022-07-15 | Alameda | 1 | 5031 | 36037 | |
208025 | 208025 | 94560 | 94560: Newark | 2022-07-15 | Alameda | 1 | 9998 | 44245 | |
208026 | 208026 | 94566 | 94566: Pleasanton | 2022-07-15 | Alameda | 1 | 6194 | 45046 | |
208027 | 208027 | 94568 | 94568: Dublin | 2022-07-15 | Alameda | 1 | 11854 | 58399 | |
208028 | 208028 | 94577 | 94577: San Leandro | 2022-07-15 | Alameda | 1 | 10217 | 48666 | |
208029 | 208029 | 94578 | 94578: San Leandro | 2022-07-15 | Alameda | 1 | 9717 | 40150 | |
208030 | 208030 | 94579 | 94579: San Leandro | 2022-07-15 | Alameda | 1 | 4608 | 20237 | |
208031 | 208031 | 94580 | 94580: San Lorenzo | 2022-07-15 | Alameda | 1 | 6905 | 28970 | |
208032 | 208032 | 94586 | 94586: Sunol | 2022-07-15 | Alameda | 1 | 119 | 797 | |
208033 | 208033 | 94587 | 94587: Union City | 2022-07-15 | Alameda | 1 | 13974 | 72446 | |
208034 | 208034 | 94588 | 94588: Pleasanton | 2022-07-15 | Alameda | 1 | 5067 | 31895 | |
208035 | 208035 | 94601 | 94601: Oakland | 2022-07-15 | Alameda | 1 | 15075 | 53261 | |
208036 | 208036 | 94602 | 94602: Oakland | 2022-07-15 | Alameda | 1 | 5137 | 29770 | |
208037 | 208037 | 94603 | 94603: Oakland | 2022-07-15 | Alameda | 1 | 10527 | 33241 | |
208038 | 208038 | 94605 | 94605: Oakland | 2022-07-15 | Alameda | 1 | 9664 | 42375 | |
208039 | 208039 | 94606 | 94606: Oakland | 2022-07-15 | Alameda | 1 | 7615 | 37076 | |
208040 | 208040 | 94607 | 94607: Oakland | 2022-07-15 | Alameda | 1 | 6096 | 26646 | |
208041 | 208041 | 94608 | 94608: Emeryville | 2022-07-15 | Alameda | 1 | 6211 | 31000 | |
208042 | 208042 | 94609 | 94609: Oakland | 2022-07-15 | Alameda | 1 | 4473 | 22293 | |
208043 | 208043 | 94610 | 94610: Oakland | 2022-07-15 | Alameda | 1 | 4823 | 30862 | |
208044 | 208044 | 94611 | 94611: Oakland | 2022-07-15 | Alameda | 1 | 5455 | 37826 | |
208045 | 208045 | 94612 | 94612: Oakland | 2022-07-15 | Alameda | 1 | 3636 | 17279 | |
208046 | 208046 | 94613 | 94613: Oakland | 2022-07-15 | Alameda | 1 | 5 | 212 | |
208047 | 208047 | 94618 | 94618: Oakland | 2022-07-15 | Alameda | 1 | 1948 | 15545 | |
208048 | 208048 | 94619 | 94619: Oakland | 2022-07-15 | Alameda | 1 | 4604 | 24080 | |
208049 | 208049 | 94621 | 94621: Oakland | 2022-07-15 | Alameda | 1 | 10315 | 32915 | |
208050 | 208050 | 94702 | 94702: Berkeley | 2022-07-15 | Alameda | 1 | 2857 | 16520 | |
208051 | 208051 | 94703 | 94703: Berkeley | 2022-07-15 | Alameda | 1 | 3159 | 19805 | |
208052 | 208052 | 94704 | 94704: Berkeley | 2022-07-15 | Alameda | 1 | 4742 | 29129 | |
208053 | 208053 | 94705 | 94705: Berkeley | 2022-07-15 | Alameda | 1 | 1760 | 13152 | |
208054 | 208054 | 94706 | 94706: Albany | 2022-07-15 | Alameda | 1 | 2308 | 19921 | |
208055 | 208055 | 94707 | 94707: Berkeley | 2022-07-15 | Alameda | 1 | 943 | 12862 | |
208056 | 208056 | 94708 | 94708: Berkeley | 2022-07-15 | Alameda | 1 | 905 | 11725 | |
208057 | 208057 | 94709 | 94709: Berkeley | 2022-07-15 | Alameda | 1 | 1454 | 11796 | |
208058 | 208058 | 94710 | 94710: Berkeley | 2022-07-15 | Alameda | 1 | 1834 | 8059 | |
208059 | 208059 | 94720 | 94720: Berkeley | 2022-07-15 | Alameda | 1 | 994 | 1336 | |
208060 | 208060 | 95377 | 95377: Tracy | 2022-07-15 | Alameda | 1 | 1 | 32091 | |
208061 | 208061 | 95391 | 95391: Mountain House | 2022-07-15 | Alameda | 1 | 4 | 20131 |
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 );