latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
31,264 rows where fips = 61 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date ▲ | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
799038 | 799038 | 95602 | 95602: Auburn | 2021-04-07 | Placer | 61 | 810 | 17817 | |
799039 | 799039 | 95603 | 95603: Auburn | 2021-04-07 | Placer | 61 | 1460 | 27256 | |
799040 | 799040 | 95626 | 95626: Elverta | 2021-04-07 | Placer | 61 | 23 | 6371 | |
799041 | 799041 | 95631 | 95631: Foresthill | 2021-04-07 | Placer | 61 | 209 | 6387 | |
799042 | 799042 | 95648 | 95648: Lincoln | 2021-04-07 | Placer | 61 | 2782 | 51257 | |
799043 | 799043 | 95650 | 95650: Loomis | 2021-04-07 | Placer | 61 | 653 | 12986 | |
799044 | 799044 | 95658 | 95658: Newcastle | 2021-04-07 | Placer | 61 | 283 | 6751 | |
799045 | 799045 | 95661 | 95661: Roseville | 2021-04-07 | Placer | 61 | 2023 | 30470 | |
799046 | 799046 | 95663 | 95663: Penryn | 2021-04-07 | Placer | 61 | 145 | 2102 | |
799047 | 799047 | 95677 | 95677: Rocklin | 2021-04-07 | Placer | 61 | 1426 | 23121 | |
799048 | 799048 | 95678 | 95678: Roseville | 2021-04-07 | Placer | 61 | 2695 | 41221 | |
799049 | 799049 | 95681 | 95681: Sheridan | 2021-04-07 | Placer | 61 | 69 | 1241 | |
799050 | 799050 | 95701 | 95701: Alta | 2021-04-07 | Placer | 61 | 37 | 842 | |
799051 | 799051 | 95703 | 95703: Applegate | 2021-04-07 | Placer | 61 | 84 | 3023 | |
799052 | 799052 | 95713 | 95713: Colfax | 2021-04-07 | Placer | 61 | 290 | 8927 | |
799053 | 799053 | 95714 | 95714: Dutch Flat | 2021-04-07 | Placer | 61 | 10 | 701 | |
799054 | 799054 | 95715 | 95715: Emigrant Gap | 2021-04-07 | Placer | 61 | 7 | 0 | |
799055 | 799055 | 95717 | 95717: Gold Run | 2021-04-07 | Placer | 61 | 5 | 5 or fewer | 0 |
799056 | 799056 | 95722 | 95722: Meadow Vista | 2021-04-07 | Placer | 61 | 182 | 4933 | |
799057 | 799057 | 95724 | 95724: Norden | 2021-04-07 | Placer | 61 | 5 | 5 or fewer | 0 |
799058 | 799058 | 95746 | 95746: Granite Bay | 2021-04-07 | Placer | 61 | 938 | 21786 | |
799059 | 799059 | 95747 | 95747: Roseville | 2021-04-07 | Placer | 61 | 3829 | 59715 | |
799060 | 799060 | 95765 | 95765: Rocklin | 2021-04-07 | Placer | 61 | 2129 | 37002 | |
799061 | 799061 | 96140 | 96140: Carnelian Bay | 2021-04-07 | Placer | 61 | 53 | 1659 | |
799062 | 799062 | 96141 | 96141: Homewood | 2021-04-07 | Placer | 61 | 10 | 933 | |
799063 | 799063 | 96142 | 96142: Tahoma | 2021-04-07 | Placer | 61 | 5 | 5 or fewer | 0 |
799064 | 799064 | 96143 | 96143: Kings Beach | 2021-04-07 | Placer | 61 | 366 | 3988 | |
799065 | 799065 | 96145 | 96145: Tahoe City | 2021-04-07 | Placer | 61 | 159 | 3033 | |
799066 | 799066 | 96146 | 96146: Olympic Valley | 2021-04-07 | Placer | 61 | 62 | 1326 | |
799067 | 799067 | 96148 | 96148: Tahoe Vista | 2021-04-07 | Placer | 61 | 56 | 1450 | |
799068 | 799068 | 96161 | 96161: Truckee | 2021-04-07 | Placer | 61 | 85 | 18599 | |
799069 | 799069 | 96162 | 96162: Truckee | 2021-04-07 | Placer | 61 | 5 | 5 or fewer | 0 |
800314 | 800314 | 95602 | 95602: Auburn | 2021-04-06 | Placer | 61 | 809 | 17817 | |
800315 | 800315 | 95603 | 95603: Auburn | 2021-04-06 | Placer | 61 | 1458 | 27256 | |
800316 | 800316 | 95626 | 95626: Elverta | 2021-04-06 | Placer | 61 | 23 | 6371 | |
800317 | 800317 | 95631 | 95631: Foresthill | 2021-04-06 | Placer | 61 | 209 | 6387 | |
800318 | 800318 | 95648 | 95648: Lincoln | 2021-04-06 | Placer | 61 | 2782 | 51257 | |
800319 | 800319 | 95650 | 95650: Loomis | 2021-04-06 | Placer | 61 | 652 | 12986 | |
800320 | 800320 | 95658 | 95658: Newcastle | 2021-04-06 | Placer | 61 | 283 | 6751 | |
800321 | 800321 | 95661 | 95661: Roseville | 2021-04-06 | Placer | 61 | 2018 | 30470 | |
800322 | 800322 | 95663 | 95663: Penryn | 2021-04-06 | Placer | 61 | 144 | 2102 | |
800323 | 800323 | 95677 | 95677: Rocklin | 2021-04-06 | Placer | 61 | 1426 | 23121 | |
800324 | 800324 | 95678 | 95678: Roseville | 2021-04-06 | Placer | 61 | 2684 | 41221 | |
800325 | 800325 | 95681 | 95681: Sheridan | 2021-04-06 | Placer | 61 | 69 | 1241 | |
800326 | 800326 | 95701 | 95701: Alta | 2021-04-06 | Placer | 61 | 37 | 842 | |
800327 | 800327 | 95703 | 95703: Applegate | 2021-04-06 | Placer | 61 | 84 | 3023 | |
800328 | 800328 | 95713 | 95713: Colfax | 2021-04-06 | Placer | 61 | 288 | 8927 | |
800329 | 800329 | 95714 | 95714: Dutch Flat | 2021-04-06 | Placer | 61 | 10 | 701 | |
800330 | 800330 | 95715 | 95715: Emigrant Gap | 2021-04-06 | Placer | 61 | 7 | 0 | |
800331 | 800331 | 95717 | 95717: Gold Run | 2021-04-06 | Placer | 61 | 5 | 5 or fewer | 0 |
800332 | 800332 | 95722 | 95722: Meadow Vista | 2021-04-06 | Placer | 61 | 180 | 4933 | |
800333 | 800333 | 95724 | 95724: Norden | 2021-04-06 | Placer | 61 | 5 | 5 or fewer | 0 |
800334 | 800334 | 95746 | 95746: Granite Bay | 2021-04-06 | Placer | 61 | 935 | 21786 | |
800335 | 800335 | 95747 | 95747: Roseville | 2021-04-06 | Placer | 61 | 3814 | 59715 | |
800336 | 800336 | 95765 | 95765: Rocklin | 2021-04-06 | Placer | 61 | 2126 | 37002 | |
800337 | 800337 | 96140 | 96140: Carnelian Bay | 2021-04-06 | Placer | 61 | 52 | 1659 | |
800338 | 800338 | 96141 | 96141: Homewood | 2021-04-06 | Placer | 61 | 10 | 933 | |
800339 | 800339 | 96142 | 96142: Tahoma | 2021-04-06 | Placer | 61 | 5 | 5 or fewer | 0 |
800340 | 800340 | 96143 | 96143: Kings Beach | 2021-04-06 | Placer | 61 | 366 | 3988 | |
800341 | 800341 | 96145 | 96145: Tahoe City | 2021-04-06 | Placer | 61 | 159 | 3033 | |
800342 | 800342 | 96146 | 96146: Olympic Valley | 2021-04-06 | Placer | 61 | 62 | 1326 | |
800343 | 800343 | 96148 | 96148: Tahoe Vista | 2021-04-06 | Placer | 61 | 56 | 1450 | |
800344 | 800344 | 96161 | 96161: Truckee | 2021-04-06 | Placer | 61 | 84 | 18599 | |
800345 | 800345 | 96162 | 96162: Truckee | 2021-04-06 | Placer | 61 | 5 | 5 or fewer | 0 |
801590 | 801590 | 95602 | 95602: Auburn | 2021-04-05 | Placer | 61 | 806 | 17817 | |
801591 | 801591 | 95603 | 95603: Auburn | 2021-04-05 | Placer | 61 | 1453 | 27256 | |
801592 | 801592 | 95626 | 95626: Elverta | 2021-04-05 | Placer | 61 | 23 | 6371 | |
801593 | 801593 | 95631 | 95631: Foresthill | 2021-04-05 | Placer | 61 | 209 | 6387 | |
801594 | 801594 | 95648 | 95648: Lincoln | 2021-04-05 | Placer | 61 | 2777 | 51257 | |
801595 | 801595 | 95650 | 95650: Loomis | 2021-04-05 | Placer | 61 | 652 | 12986 | |
801596 | 801596 | 95658 | 95658: Newcastle | 2021-04-05 | Placer | 61 | 282 | 6751 | |
801597 | 801597 | 95661 | 95661: Roseville | 2021-04-05 | Placer | 61 | 2017 | 30470 | |
801598 | 801598 | 95663 | 95663: Penryn | 2021-04-05 | Placer | 61 | 144 | 2102 | |
801599 | 801599 | 95677 | 95677: Rocklin | 2021-04-05 | Placer | 61 | 1425 | 23121 | |
801600 | 801600 | 95678 | 95678: Roseville | 2021-04-05 | Placer | 61 | 2678 | 41221 | |
801601 | 801601 | 95681 | 95681: Sheridan | 2021-04-05 | Placer | 61 | 69 | 1241 | |
801602 | 801602 | 95701 | 95701: Alta | 2021-04-05 | Placer | 61 | 35 | 842 | |
801603 | 801603 | 95703 | 95703: Applegate | 2021-04-05 | Placer | 61 | 83 | 3023 | |
801604 | 801604 | 95713 | 95713: Colfax | 2021-04-05 | Placer | 61 | 287 | 8927 | |
801605 | 801605 | 95714 | 95714: Dutch Flat | 2021-04-05 | Placer | 61 | 10 | 701 | |
801606 | 801606 | 95715 | 95715: Emigrant Gap | 2021-04-05 | Placer | 61 | 7 | 0 | |
801607 | 801607 | 95717 | 95717: Gold Run | 2021-04-05 | Placer | 61 | 5 | 5 or fewer | 0 |
801608 | 801608 | 95722 | 95722: Meadow Vista | 2021-04-05 | Placer | 61 | 179 | 4933 | |
801609 | 801609 | 95724 | 95724: Norden | 2021-04-05 | Placer | 61 | 5 | 5 or fewer | 0 |
801610 | 801610 | 95746 | 95746: Granite Bay | 2021-04-05 | Placer | 61 | 928 | 21786 | |
801611 | 801611 | 95747 | 95747: Roseville | 2021-04-05 | Placer | 61 | 3801 | 59715 | |
801612 | 801612 | 95765 | 95765: Rocklin | 2021-04-05 | Placer | 61 | 2125 | 37002 | |
801613 | 801613 | 96140 | 96140: Carnelian Bay | 2021-04-05 | Placer | 61 | 52 | 1659 | |
801614 | 801614 | 96141 | 96141: Homewood | 2021-04-05 | Placer | 61 | 10 | 933 | |
801615 | 801615 | 96142 | 96142: Tahoma | 2021-04-05 | Placer | 61 | 5 | 5 or fewer | 0 |
801616 | 801616 | 96143 | 96143: Kings Beach | 2021-04-05 | Placer | 61 | 365 | 3988 | |
801617 | 801617 | 96145 | 96145: Tahoe City | 2021-04-05 | Placer | 61 | 159 | 3033 | |
801618 | 801618 | 96146 | 96146: Olympic Valley | 2021-04-05 | Placer | 61 | 62 | 1326 | |
801619 | 801619 | 96148 | 96148: Tahoe Vista | 2021-04-05 | Placer | 61 | 56 | 1450 | |
801620 | 801620 | 96161 | 96161: Truckee | 2021-04-05 | Placer | 61 | 84 | 18599 | |
801621 | 801621 | 96162 | 96162: Truckee | 2021-04-05 | Placer | 61 | 5 | 5 or fewer | 0 |
802866 | 802866 | 95602 | 95602: Auburn | 2021-04-04 | Placer | 61 | 802 | 17817 | |
802867 | 802867 | 95603 | 95603: Auburn | 2021-04-04 | Placer | 61 | 1440 | 27256 | |
802868 | 802868 | 95626 | 95626: Elverta | 2021-04-04 | Placer | 61 | 24 | 6371 | |
802869 | 802869 | 95631 | 95631: Foresthill | 2021-04-04 | Placer | 61 | 207 | 6387 |
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 );