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 |
---|---|---|---|---|---|---|---|---|---|
168347 | 168347 | 95602 | 95602: Auburn | 2022-08-16 | Placer | 61 | 2310 | 17817 | |
168348 | 168348 | 95603 | 95603: Auburn | 2022-08-16 | Placer | 61 | 4794 | 27256 | |
168349 | 168349 | 95626 | 95626: Elverta | 2022-08-16 | Placer | 61 | 91 | 6371 | |
168350 | 168350 | 95631 | 95631: Foresthill | 2022-08-16 | Placer | 61 | 741 | 6387 | |
168351 | 168351 | 95648 | 95648: Lincoln | 2022-08-16 | Placer | 61 | 9273 | 51257 | |
168352 | 168352 | 95650 | 95650: Loomis | 2022-08-16 | Placer | 61 | 2164 | 12986 | |
168353 | 168353 | 95658 | 95658: Newcastle | 2022-08-16 | Placer | 61 | 946 | 6751 | |
168354 | 168354 | 95661 | 95661: Roseville | 2022-08-16 | Placer | 61 | 6803 | 30470 | |
168355 | 168355 | 95663 | 95663: Penryn | 2022-08-16 | Placer | 61 | 462 | 2102 | |
168356 | 168356 | 95677 | 95677: Rocklin | 2022-08-16 | Placer | 61 | 5223 | 23121 | |
168357 | 168357 | 95678 | 95678: Roseville | 2022-08-16 | Placer | 61 | 8966 | 41221 | |
168358 | 168358 | 95681 | 95681: Sheridan | 2022-08-16 | Placer | 61 | 238 | 1241 | |
168359 | 168359 | 95701 | 95701: Alta | 2022-08-16 | Placer | 61 | 120 | 842 | |
168360 | 168360 | 95703 | 95703: Applegate | 2022-08-16 | Placer | 61 | 267 | 3023 | |
168361 | 168361 | 95713 | 95713: Colfax | 2022-08-16 | Placer | 61 | 1088 | 8927 | |
168362 | 168362 | 95714 | 95714: Dutch Flat | 2022-08-16 | Placer | 61 | 47 | 701 | |
168363 | 168363 | 95715 | 95715: Emigrant Gap | 2022-08-16 | Placer | 61 | 18 | 0 | |
168364 | 168364 | 95717 | 95717: Gold Run | 2022-08-16 | Placer | 61 | 24 | 0 | |
168365 | 168365 | 95722 | 95722: Meadow Vista | 2022-08-16 | Placer | 61 | 658 | 4933 | |
168366 | 168366 | 95724 | 95724: Norden | 2022-08-16 | Placer | 61 | 6 | 0 | |
168367 | 168367 | 95746 | 95746: Granite Bay | 2022-08-16 | Placer | 61 | 3352 | 21786 | |
168368 | 168368 | 95747 | 95747: Roseville | 2022-08-16 | Placer | 61 | 14400 | 59715 | |
168369 | 168369 | 95765 | 95765: Rocklin | 2022-08-16 | Placer | 61 | 7660 | 37002 | |
168370 | 168370 | 96140 | 96140: Carnelian Bay | 2022-08-16 | Placer | 61 | 204 | 1659 | |
168371 | 168371 | 96141 | 96141: Homewood | 2022-08-16 | Placer | 61 | 73 | 933 | |
168372 | 168372 | 96142 | 96142: Tahoma | 2022-08-16 | Placer | 61 | 7 | 0 | |
168373 | 168373 | 96143 | 96143: Kings Beach | 2022-08-16 | Placer | 61 | 971 | 3988 | |
168374 | 168374 | 96145 | 96145: Tahoe City | 2022-08-16 | Placer | 61 | 651 | 3033 | |
168375 | 168375 | 96146 | 96146: Olympic Valley | 2022-08-16 | Placer | 61 | 266 | 1326 | |
168376 | 168376 | 96148 | 96148: Tahoe Vista | 2022-08-16 | Placer | 61 | 211 | 1450 | |
168377 | 168377 | 96161 | 96161: Truckee | 2022-08-16 | Placer | 61 | 341 | 18599 | |
168378 | 168378 | 96162 | 96162: Truckee | 2022-08-16 | Placer | 61 | 5 | 5 or fewer | 0 |
169610 | 169610 | 95602 | 95602: Auburn | 2022-08-15 | Placer | 61 | 2310 | 17817 | |
169611 | 169611 | 95603 | 95603: Auburn | 2022-08-15 | Placer | 61 | 4794 | 27256 | |
169612 | 169612 | 95626 | 95626: Elverta | 2022-08-15 | Placer | 61 | 91 | 6371 | |
169613 | 169613 | 95631 | 95631: Foresthill | 2022-08-15 | Placer | 61 | 741 | 6387 | |
169614 | 169614 | 95648 | 95648: Lincoln | 2022-08-15 | Placer | 61 | 9273 | 51257 | |
169615 | 169615 | 95650 | 95650: Loomis | 2022-08-15 | Placer | 61 | 2164 | 12986 | |
169616 | 169616 | 95658 | 95658: Newcastle | 2022-08-15 | Placer | 61 | 946 | 6751 | |
169617 | 169617 | 95661 | 95661: Roseville | 2022-08-15 | Placer | 61 | 6803 | 30470 | |
169618 | 169618 | 95663 | 95663: Penryn | 2022-08-15 | Placer | 61 | 462 | 2102 | |
169619 | 169619 | 95677 | 95677: Rocklin | 2022-08-15 | Placer | 61 | 5223 | 23121 | |
169620 | 169620 | 95678 | 95678: Roseville | 2022-08-15 | Placer | 61 | 8966 | 41221 | |
169621 | 169621 | 95681 | 95681: Sheridan | 2022-08-15 | Placer | 61 | 238 | 1241 | |
169622 | 169622 | 95701 | 95701: Alta | 2022-08-15 | Placer | 61 | 120 | 842 | |
169623 | 169623 | 95703 | 95703: Applegate | 2022-08-15 | Placer | 61 | 267 | 3023 | |
169624 | 169624 | 95713 | 95713: Colfax | 2022-08-15 | Placer | 61 | 1088 | 8927 | |
169625 | 169625 | 95714 | 95714: Dutch Flat | 2022-08-15 | Placer | 61 | 47 | 701 | |
169626 | 169626 | 95715 | 95715: Emigrant Gap | 2022-08-15 | Placer | 61 | 18 | 0 | |
169627 | 169627 | 95717 | 95717: Gold Run | 2022-08-15 | Placer | 61 | 24 | 0 | |
169628 | 169628 | 95722 | 95722: Meadow Vista | 2022-08-15 | Placer | 61 | 658 | 4933 | |
169629 | 169629 | 95724 | 95724: Norden | 2022-08-15 | Placer | 61 | 6 | 0 | |
169630 | 169630 | 95746 | 95746: Granite Bay | 2022-08-15 | Placer | 61 | 3352 | 21786 | |
169631 | 169631 | 95747 | 95747: Roseville | 2022-08-15 | Placer | 61 | 14400 | 59715 | |
169632 | 169632 | 95765 | 95765: Rocklin | 2022-08-15 | Placer | 61 | 7660 | 37002 | |
169633 | 169633 | 96140 | 96140: Carnelian Bay | 2022-08-15 | Placer | 61 | 204 | 1659 | |
169634 | 169634 | 96141 | 96141: Homewood | 2022-08-15 | Placer | 61 | 73 | 933 | |
169635 | 169635 | 96142 | 96142: Tahoma | 2022-08-15 | Placer | 61 | 7 | 0 | |
169636 | 169636 | 96143 | 96143: Kings Beach | 2022-08-15 | Placer | 61 | 971 | 3988 | |
169637 | 169637 | 96145 | 96145: Tahoe City | 2022-08-15 | Placer | 61 | 651 | 3033 | |
169638 | 169638 | 96146 | 96146: Olympic Valley | 2022-08-15 | Placer | 61 | 266 | 1326 | |
169639 | 169639 | 96148 | 96148: Tahoe Vista | 2022-08-15 | Placer | 61 | 211 | 1450 | |
169640 | 169640 | 96161 | 96161: Truckee | 2022-08-15 | Placer | 61 | 341 | 18599 | |
169641 | 169641 | 96162 | 96162: Truckee | 2022-08-15 | Placer | 61 | 5 | 5 or fewer | 0 |
170873 | 170873 | 95602 | 95602: Auburn | 2022-08-14 | Placer | 61 | 2310 | 17817 | |
170874 | 170874 | 95603 | 95603: Auburn | 2022-08-14 | Placer | 61 | 4794 | 27256 | |
170875 | 170875 | 95626 | 95626: Elverta | 2022-08-14 | Placer | 61 | 91 | 6371 | |
170876 | 170876 | 95631 | 95631: Foresthill | 2022-08-14 | Placer | 61 | 741 | 6387 | |
170877 | 170877 | 95648 | 95648: Lincoln | 2022-08-14 | Placer | 61 | 9273 | 51257 | |
170878 | 170878 | 95650 | 95650: Loomis | 2022-08-14 | Placer | 61 | 2164 | 12986 | |
170879 | 170879 | 95658 | 95658: Newcastle | 2022-08-14 | Placer | 61 | 946 | 6751 | |
170880 | 170880 | 95661 | 95661: Roseville | 2022-08-14 | Placer | 61 | 6803 | 30470 | |
170881 | 170881 | 95663 | 95663: Penryn | 2022-08-14 | Placer | 61 | 462 | 2102 | |
170882 | 170882 | 95677 | 95677: Rocklin | 2022-08-14 | Placer | 61 | 5223 | 23121 | |
170883 | 170883 | 95678 | 95678: Roseville | 2022-08-14 | Placer | 61 | 8966 | 41221 | |
170884 | 170884 | 95681 | 95681: Sheridan | 2022-08-14 | Placer | 61 | 238 | 1241 | |
170885 | 170885 | 95701 | 95701: Alta | 2022-08-14 | Placer | 61 | 120 | 842 | |
170886 | 170886 | 95703 | 95703: Applegate | 2022-08-14 | Placer | 61 | 267 | 3023 | |
170887 | 170887 | 95713 | 95713: Colfax | 2022-08-14 | Placer | 61 | 1088 | 8927 | |
170888 | 170888 | 95714 | 95714: Dutch Flat | 2022-08-14 | Placer | 61 | 47 | 701 | |
170889 | 170889 | 95715 | 95715: Emigrant Gap | 2022-08-14 | Placer | 61 | 18 | 0 | |
170890 | 170890 | 95717 | 95717: Gold Run | 2022-08-14 | Placer | 61 | 24 | 0 | |
170891 | 170891 | 95722 | 95722: Meadow Vista | 2022-08-14 | Placer | 61 | 658 | 4933 | |
170892 | 170892 | 95724 | 95724: Norden | 2022-08-14 | Placer | 61 | 6 | 0 | |
170893 | 170893 | 95746 | 95746: Granite Bay | 2022-08-14 | Placer | 61 | 3352 | 21786 | |
170894 | 170894 | 95747 | 95747: Roseville | 2022-08-14 | Placer | 61 | 14400 | 59715 | |
170895 | 170895 | 95765 | 95765: Rocklin | 2022-08-14 | Placer | 61 | 7660 | 37002 | |
170896 | 170896 | 96140 | 96140: Carnelian Bay | 2022-08-14 | Placer | 61 | 204 | 1659 | |
170897 | 170897 | 96141 | 96141: Homewood | 2022-08-14 | Placer | 61 | 73 | 933 | |
170898 | 170898 | 96142 | 96142: Tahoma | 2022-08-14 | Placer | 61 | 7 | 0 | |
170899 | 170899 | 96143 | 96143: Kings Beach | 2022-08-14 | Placer | 61 | 971 | 3988 | |
170900 | 170900 | 96145 | 96145: Tahoe City | 2022-08-14 | Placer | 61 | 651 | 3033 | |
170901 | 170901 | 96146 | 96146: Olympic Valley | 2022-08-14 | Placer | 61 | 266 | 1326 | |
170902 | 170902 | 96148 | 96148: Tahoe Vista | 2022-08-14 | Placer | 61 | 211 | 1450 | |
170903 | 170903 | 96161 | 96161: Truckee | 2022-08-14 | Placer | 61 | 341 | 18599 | |
170904 | 170904 | 96162 | 96162: Truckee | 2022-08-14 | Placer | 61 | 5 | 5 or fewer | 0 |
172136 | 172136 | 95602 | 95602: Auburn | 2022-08-13 | Placer | 61 | 2310 | 17817 | |
172137 | 172137 | 95603 | 95603: Auburn | 2022-08-13 | Placer | 61 | 4794 | 27256 | |
172138 | 172138 | 95626 | 95626: Elverta | 2022-08-13 | Placer | 61 | 91 | 6371 | |
172139 | 172139 | 95631 | 95631: Foresthill | 2022-08-13 | Placer | 61 | 741 | 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 );