latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,251,796 rows sorted by rowid descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: date
Link | rowid ▲ | id | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
1251796 | 1251796 | 96162 | 96162: Truckee | 2020-02-28 | Placer | 61 | 0 | 0 | |
1251795 | 1251795 | 96161 | 96161: Truckee | 2020-02-28 | Placer | 61 | 0 | 18599 | |
1251794 | 1251794 | 96148 | 96148: Tahoe Vista | 2020-02-28 | Placer | 61 | 0 | 1450 | |
1251793 | 1251793 | 96146 | 96146: Olympic Valley | 2020-02-28 | Placer | 61 | 0 | 1326 | |
1251792 | 1251792 | 96145 | 96145: Tahoe City | 2020-02-28 | Placer | 61 | 0 | 3033 | |
1251791 | 1251791 | 96143 | 96143: Kings Beach | 2020-02-28 | Placer | 61 | 0 | 3988 | |
1251790 | 1251790 | 96142 | 96142: Tahoma | 2020-02-28 | Placer | 61 | 0 | 0 | |
1251789 | 1251789 | 96141 | 96141: Homewood | 2020-02-28 | Placer | 61 | 0 | 933 | |
1251788 | 1251788 | 96140 | 96140: Carnelian Bay | 2020-02-28 | Placer | 61 | 0 | 1659 | |
1251787 | 1251787 | 95765 | 95765: Rocklin | 2020-02-28 | Placer | 61 | 0 | 37002 | |
1251786 | 1251786 | 95747 | 95747: Roseville | 2020-02-28 | Placer | 61 | 1 | 59715 | |
1251785 | 1251785 | 95746 | 95746: Granite Bay | 2020-02-28 | Placer | 61 | 0 | 21786 | |
1251784 | 1251784 | 95724 | 95724: Norden | 2020-02-28 | Placer | 61 | 0 | 0 | |
1251783 | 1251783 | 95722 | 95722: Meadow Vista | 2020-02-28 | Placer | 61 | 0 | 4933 | |
1251782 | 1251782 | 95717 | 95717: Gold Run | 2020-02-28 | Placer | 61 | 0 | 0 | |
1251781 | 1251781 | 95715 | 95715: Emigrant Gap | 2020-02-28 | Placer | 61 | 0 | 0 | |
1251780 | 1251780 | 95714 | 95714: Dutch Flat | 2020-02-28 | Placer | 61 | 0 | 701 | |
1251779 | 1251779 | 95713 | 95713: Colfax | 2020-02-28 | Placer | 61 | 0 | 8927 | |
1251778 | 1251778 | 95703 | 95703: Applegate | 2020-02-28 | Placer | 61 | 0 | 3023 | |
1251777 | 1251777 | 95701 | 95701: Alta | 2020-02-28 | Placer | 61 | 0 | 842 | |
1251776 | 1251776 | 95681 | 95681: Sheridan | 2020-02-28 | Placer | 61 | 0 | 1241 | |
1251775 | 1251775 | 95678 | 95678: Roseville | 2020-02-28 | Placer | 61 | 0 | 41221 | |
1251774 | 1251774 | 95677 | 95677: Rocklin | 2020-02-28 | Placer | 61 | 0 | 23121 | |
1251773 | 1251773 | 95663 | 95663: Penryn | 2020-02-28 | Placer | 61 | 0 | 2102 | |
1251772 | 1251772 | 95661 | 95661: Roseville | 2020-02-28 | Placer | 61 | 0 | 30470 | |
1251771 | 1251771 | 95658 | 95658: Newcastle | 2020-02-28 | Placer | 61 | 0 | 6751 | |
1251770 | 1251770 | 95650 | 95650: Loomis | 2020-02-28 | Placer | 61 | 0 | 12986 | |
1251769 | 1251769 | 95648 | 95648: Lincoln | 2020-02-28 | Placer | 61 | 0 | 51257 | |
1251768 | 1251768 | 95631 | 95631: Foresthill | 2020-02-28 | Placer | 61 | 0 | 6387 | |
1251767 | 1251767 | 95626 | 95626: Elverta | 2020-02-28 | Placer | 61 | 0 | 6371 | |
1251766 | 1251766 | 95603 | 95603: Auburn | 2020-02-28 | Placer | 61 | 0 | 27256 | |
1251765 | 1251765 | 95602 | 95602: Auburn | 2020-02-28 | Placer | 61 | 0 | 17817 | |
1251764 | 1251764 | 95391 | 95391: Mountain House | 2020-02-28 | Alameda | 1 | 0 | 20131 | |
1251763 | 1251763 | 95377 | 95377: Tracy | 2020-02-28 | Alameda | 1 | 0 | 32091 | |
1251762 | 1251762 | 94720 | 94720: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 1336 | |
1251761 | 1251761 | 94710 | 94710: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 8059 | |
1251760 | 1251760 | 94709 | 94709: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 11796 | |
1251759 | 1251759 | 94708 | 94708: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 11725 | |
1251758 | 1251758 | 94707 | 94707: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 12862 | |
1251757 | 1251757 | 94706 | 94706: Albany | 2020-02-28 | Alameda | 1 | 0 | 19921 | |
1251756 | 1251756 | 94705 | 94705: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 13152 | |
1251755 | 1251755 | 94704 | 94704: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 29129 | |
1251754 | 1251754 | 94703 | 94703: Berkeley | 2020-02-28 | Alameda | 1 | 9 | 9 or fewer | 19805 |
1251753 | 1251753 | 94702 | 94702: Berkeley | 2020-02-28 | Alameda | 1 | 0 | 16520 | |
1251752 | 1251752 | 94621 | 94621: Oakland | 2020-02-28 | Alameda | 1 | 0 | 32915 | |
1251751 | 1251751 | 94619 | 94619: Oakland | 2020-02-28 | Alameda | 1 | 0 | 24080 | |
1251750 | 1251750 | 94618 | 94618: Oakland | 2020-02-28 | Alameda | 1 | 0 | 15545 | |
1251749 | 1251749 | 94613 | 94613: Oakland | 2020-02-28 | Alameda | 1 | 0 | 212 | |
1251748 | 1251748 | 94612 | 94612: Oakland | 2020-02-28 | Alameda | 1 | 0 | 17279 | |
1251747 | 1251747 | 94611 | 94611: Oakland | 2020-02-28 | Alameda | 1 | 0 | 37826 | |
1251746 | 1251746 | 94610 | 94610: Oakland | 2020-02-28 | Alameda | 1 | 0 | 30862 | |
1251745 | 1251745 | 94609 | 94609: Oakland | 2020-02-28 | Alameda | 1 | 0 | 22293 | |
1251744 | 1251744 | 94608 | 94608: Emeryville | 2020-02-28 | Alameda | 1 | 9 | 9 or fewer | 31000 |
1251743 | 1251743 | 94607 | 94607: Oakland | 2020-02-28 | Alameda | 1 | 0 | 26646 | |
1251742 | 1251742 | 94606 | 94606: Oakland | 2020-02-28 | Alameda | 1 | 0 | 37076 | |
1251741 | 1251741 | 94605 | 94605: Oakland | 2020-02-28 | Alameda | 1 | 0 | 42375 | |
1251740 | 1251740 | 94603 | 94603: Oakland | 2020-02-28 | Alameda | 1 | 0 | 33241 | |
1251739 | 1251739 | 94602 | 94602: Oakland | 2020-02-28 | Alameda | 1 | 0 | 29770 | |
1251738 | 1251738 | 94601 | 94601: Oakland | 2020-02-28 | Alameda | 1 | 0 | 53261 | |
1251737 | 1251737 | 94588 | 94588: Pleasanton | 2020-02-28 | Alameda | 1 | 0 | 31895 | |
1251736 | 1251736 | 94587 | 94587: Union City | 2020-02-28 | Alameda | 1 | 0 | 72446 | |
1251735 | 1251735 | 94586 | 94586: Sunol | 2020-02-28 | Alameda | 1 | 0 | 797 | |
1251734 | 1251734 | 94580 | 94580: San Lorenzo | 2020-02-28 | Alameda | 1 | 0 | 28970 | |
1251733 | 1251733 | 94579 | 94579: San Leandro | 2020-02-28 | Alameda | 1 | 0 | 20237 | |
1251732 | 1251732 | 94578 | 94578: San Leandro | 2020-02-28 | Alameda | 1 | 0 | 40150 | |
1251731 | 1251731 | 94577 | 94577: San Leandro | 2020-02-28 | Alameda | 1 | 0 | 48666 | |
1251730 | 1251730 | 94568 | 94568: Dublin | 2020-02-28 | Alameda | 1 | 0 | 58399 | |
1251729 | 1251729 | 94566 | 94566: Pleasanton | 2020-02-28 | Alameda | 1 | 0 | 45046 | |
1251728 | 1251728 | 94560 | 94560: Newark | 2020-02-28 | Alameda | 1 | 0 | 44245 | |
1251727 | 1251727 | 94555 | 94555: Fremont | 2020-02-28 | Alameda | 1 | 0 | 36037 | |
1251726 | 1251726 | 94552 | 94552: Castro Valley | 2020-02-28 | Alameda | 1 | 0 | 15204 | |
1251725 | 1251725 | 94551 | 94551: Livermore | 2020-02-28 | Alameda | 1 | 0 | 38986 | |
1251724 | 1251724 | 94550 | 94550: Livermore | 2020-02-28 | Alameda | 1 | 0 | 50138 | |
1251723 | 1251723 | 94546 | 94546: Castro Valley | 2020-02-28 | Alameda | 1 | 0 | 45536 | |
1251722 | 1251722 | 94545 | 94545: Hayward | 2020-02-28 | Alameda | 1 | 9 | 9 or fewer | 31657 |
1251721 | 1251721 | 94544 | 94544: Hayward | 2020-02-28 | Alameda | 1 | 0 | 77121 | |
1251720 | 1251720 | 94542 | 94542: Hayward | 2020-02-28 | Alameda | 1 | 0 | 13973 | |
1251719 | 1251719 | 94541 | 94541: Hayward | 2020-02-28 | Alameda | 1 | 0 | 65132 | |
1251718 | 1251718 | 94539 | 94539: Fremont | 2020-02-28 | Alameda | 1 | 0 | 52960 | |
1251717 | 1251717 | 94538 | 94538: Fremont | 2020-02-28 | Alameda | 1 | 0 | 63911 | |
1251716 | 1251716 | 94536 | 94536: Fremont | 2020-02-28 | Alameda | 1 | 0 | 72976 | |
1251715 | 1251715 | 94514 | 94514: Byron | 2020-02-28 | Alameda | 1 | 0 | 1461 | |
1251714 | 1251714 | 94505 | 94505: Discovery Bay | 2020-02-28 | Alameda | 1 | 0 | 16382 | |
1251713 | 1251713 | 94502 | 94502: Alameda | 2020-02-28 | Alameda | 1 | 0 | 14117 | |
1251712 | 1251712 | 94501 | 94501: Alameda | 2020-02-28 | Alameda | 1 | 0 | 62826 | |
1251711 | 1251711 | 96162 | 96162: Truckee | 2020-02-29 | Placer | 61 | 0 | 0 | |
1251710 | 1251710 | 96161 | 96161: Truckee | 2020-02-29 | Placer | 61 | 0 | 18599 | |
1251709 | 1251709 | 96148 | 96148: Tahoe Vista | 2020-02-29 | Placer | 61 | 0 | 1450 | |
1251708 | 1251708 | 96146 | 96146: Olympic Valley | 2020-02-29 | Placer | 61 | 0 | 1326 | |
1251707 | 1251707 | 96145 | 96145: Tahoe City | 2020-02-29 | Placer | 61 | 0 | 3033 | |
1251706 | 1251706 | 96143 | 96143: Kings Beach | 2020-02-29 | Placer | 61 | 0 | 3988 | |
1251705 | 1251705 | 96142 | 96142: Tahoma | 2020-02-29 | Placer | 61 | 0 | 0 | |
1251704 | 1251704 | 96141 | 96141: Homewood | 2020-02-29 | Placer | 61 | 0 | 933 | |
1251703 | 1251703 | 96140 | 96140: Carnelian Bay | 2020-02-29 | Placer | 61 | 0 | 1659 | |
1251702 | 1251702 | 95765 | 95765: Rocklin | 2020-02-29 | Placer | 61 | 0 | 37002 | |
1251701 | 1251701 | 95747 | 95747: Roseville | 2020-02-29 | Placer | 61 | 1 | 59715 | |
1251700 | 1251700 | 95746 | 95746: Granite Bay | 2020-02-29 | Placer | 61 | 0 | 21786 | |
1251699 | 1251699 | 95724 | 95724: Norden | 2020-02-29 | Placer | 61 | 0 | 0 | |
1251698 | 1251698 | 95722 | 95722: Meadow Vista | 2020-02-29 | Placer | 61 | 0 | 4933 | |
1251697 | 1251697 | 95717 | 95717: Gold Run | 2020-02-29 | Placer | 61 | 0 | 0 |
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] INTEGER );