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 |
---|---|---|---|---|---|---|---|---|---|
601266 | 601266 | 95663 | 95663: Penryn | 2021-09-09 | Placer | 61 | 216 | 2102 | |
601267 | 601267 | 95677 | 95677: Rocklin | 2021-09-09 | Placer | 61 | 2310 | 23121 | |
601268 | 601268 | 95678 | 95678: Roseville | 2021-09-09 | Placer | 61 | 4037 | 41221 | |
601269 | 601269 | 95681 | 95681: Sheridan | 2021-09-09 | Placer | 61 | 114 | 1241 | |
601270 | 601270 | 95701 | 95701: Alta | 2021-09-09 | Placer | 61 | 57 | 842 | |
601271 | 601271 | 95703 | 95703: Applegate | 2021-09-09 | Placer | 61 | 134 | 3023 | |
601272 | 601272 | 95713 | 95713: Colfax | 2021-09-09 | Placer | 61 | 506 | 8927 | |
601273 | 601273 | 95714 | 95714: Dutch Flat | 2021-09-09 | Placer | 61 | 18 | 701 | |
601274 | 601274 | 95715 | 95715: Emigrant Gap | 2021-09-09 | Placer | 61 | 11 | 0 | |
601275 | 601275 | 95717 | 95717: Gold Run | 2021-09-09 | Placer | 61 | 5 | 5 or fewer | 0 |
601276 | 601276 | 95722 | 95722: Meadow Vista | 2021-09-09 | Placer | 61 | 314 | 4933 | |
601277 | 601277 | 95724 | 95724: Norden | 2021-09-09 | Placer | 61 | 5 | 5 or fewer | 0 |
601278 | 601278 | 95746 | 95746: Granite Bay | 2021-09-09 | Placer | 61 | 1429 | 21786 | |
601279 | 601279 | 95747 | 95747: Roseville | 2021-09-09 | Placer | 61 | 5861 | 59715 | |
601280 | 601280 | 95765 | 95765: Rocklin | 2021-09-09 | Placer | 61 | 3197 | 37002 | |
601281 | 601281 | 96140 | 96140: Carnelian Bay | 2021-09-09 | Placer | 61 | 86 | 1659 | |
601282 | 601282 | 96141 | 96141: Homewood | 2021-09-09 | Placer | 61 | 26 | 933 | |
601283 | 601283 | 96142 | 96142: Tahoma | 2021-09-09 | Placer | 61 | 5 | 5 or fewer | 0 |
601284 | 601284 | 96143 | 96143: Kings Beach | 2021-09-09 | Placer | 61 | 505 | 3988 | |
601285 | 601285 | 96145 | 96145: Tahoe City | 2021-09-09 | Placer | 61 | 236 | 3033 | |
601286 | 601286 | 96146 | 96146: Olympic Valley | 2021-09-09 | Placer | 61 | 100 | 1326 | |
601287 | 601287 | 96148 | 96148: Tahoe Vista | 2021-09-09 | Placer | 61 | 86 | 1450 | |
601288 | 601288 | 96161 | 96161: Truckee | 2021-09-09 | Placer | 61 | 115 | 18599 | |
601289 | 601289 | 96162 | 96162: Truckee | 2021-09-09 | Placer | 61 | 5 | 5 or fewer | 0 |
602534 | 602534 | 95602 | 95602: Auburn | 2021-09-08 | Placer | 61 | 1107 | 17817 | |
602535 | 602535 | 95603 | 95603: Auburn | 2021-09-08 | Placer | 61 | 2219 | 27256 | |
602536 | 602536 | 95626 | 95626: Elverta | 2021-09-08 | Placer | 61 | 46 | 6371 | |
602537 | 602537 | 95631 | 95631: Foresthill | 2021-09-08 | Placer | 61 | 345 | 6387 | |
602538 | 602538 | 95648 | 95648: Lincoln | 2021-09-08 | Placer | 61 | 3925 | 51257 | |
602539 | 602539 | 95650 | 95650: Loomis | 2021-09-08 | Placer | 61 | 1017 | 12986 | |
602540 | 602540 | 95658 | 95658: Newcastle | 2021-09-08 | Placer | 61 | 421 | 6751 | |
602541 | 602541 | 95661 | 95661: Roseville | 2021-09-08 | Placer | 61 | 2970 | 30470 | |
602542 | 602542 | 95663 | 95663: Penryn | 2021-09-08 | Placer | 61 | 216 | 2102 | |
602543 | 602543 | 95677 | 95677: Rocklin | 2021-09-08 | Placer | 61 | 2310 | 23121 | |
602544 | 602544 | 95678 | 95678: Roseville | 2021-09-08 | Placer | 61 | 4037 | 41221 | |
602545 | 602545 | 95681 | 95681: Sheridan | 2021-09-08 | Placer | 61 | 114 | 1241 | |
602546 | 602546 | 95701 | 95701: Alta | 2021-09-08 | Placer | 61 | 57 | 842 | |
602547 | 602547 | 95703 | 95703: Applegate | 2021-09-08 | Placer | 61 | 134 | 3023 | |
602548 | 602548 | 95713 | 95713: Colfax | 2021-09-08 | Placer | 61 | 506 | 8927 | |
602549 | 602549 | 95714 | 95714: Dutch Flat | 2021-09-08 | Placer | 61 | 18 | 701 | |
602550 | 602550 | 95715 | 95715: Emigrant Gap | 2021-09-08 | Placer | 61 | 11 | 0 | |
602551 | 602551 | 95717 | 95717: Gold Run | 2021-09-08 | Placer | 61 | 5 | 5 or fewer | 0 |
602552 | 602552 | 95722 | 95722: Meadow Vista | 2021-09-08 | Placer | 61 | 314 | 4933 | |
602553 | 602553 | 95724 | 95724: Norden | 2021-09-08 | Placer | 61 | 5 | 5 or fewer | 0 |
602554 | 602554 | 95746 | 95746: Granite Bay | 2021-09-08 | Placer | 61 | 1429 | 21786 | |
602555 | 602555 | 95747 | 95747: Roseville | 2021-09-08 | Placer | 61 | 5861 | 59715 | |
602556 | 602556 | 95765 | 95765: Rocklin | 2021-09-08 | Placer | 61 | 3197 | 37002 | |
602557 | 602557 | 96140 | 96140: Carnelian Bay | 2021-09-08 | Placer | 61 | 86 | 1659 | |
602558 | 602558 | 96141 | 96141: Homewood | 2021-09-08 | Placer | 61 | 26 | 933 | |
602559 | 602559 | 96142 | 96142: Tahoma | 2021-09-08 | Placer | 61 | 5 | 5 or fewer | 0 |
602560 | 602560 | 96143 | 96143: Kings Beach | 2021-09-08 | Placer | 61 | 505 | 3988 | |
602561 | 602561 | 96145 | 96145: Tahoe City | 2021-09-08 | Placer | 61 | 236 | 3033 | |
602562 | 602562 | 96146 | 96146: Olympic Valley | 2021-09-08 | Placer | 61 | 100 | 1326 | |
602563 | 602563 | 96148 | 96148: Tahoe Vista | 2021-09-08 | Placer | 61 | 86 | 1450 | |
602564 | 602564 | 96161 | 96161: Truckee | 2021-09-08 | Placer | 61 | 115 | 18599 | |
602565 | 602565 | 96162 | 96162: Truckee | 2021-09-08 | Placer | 61 | 5 | 5 or fewer | 0 |
603810 | 603810 | 95602 | 95602: Auburn | 2021-09-07 | Placer | 61 | 1081 | 17817 | |
603811 | 603811 | 95603 | 95603: Auburn | 2021-09-07 | Placer | 61 | 2145 | 27256 | |
603812 | 603812 | 95626 | 95626: Elverta | 2021-09-07 | Placer | 61 | 44 | 6371 | |
603813 | 603813 | 95631 | 95631: Foresthill | 2021-09-07 | Placer | 61 | 336 | 6387 | |
603814 | 603814 | 95648 | 95648: Lincoln | 2021-09-07 | Placer | 61 | 3857 | 51257 | |
603815 | 603815 | 95650 | 95650: Loomis | 2021-09-07 | Placer | 61 | 995 | 12986 | |
603816 | 603816 | 95658 | 95658: Newcastle | 2021-09-07 | Placer | 61 | 409 | 6751 | |
603817 | 603817 | 95661 | 95661: Roseville | 2021-09-07 | Placer | 61 | 2926 | 30470 | |
603818 | 603818 | 95663 | 95663: Penryn | 2021-09-07 | Placer | 61 | 208 | 2102 | |
603819 | 603819 | 95677 | 95677: Rocklin | 2021-09-07 | Placer | 61 | 2268 | 23121 | |
603820 | 603820 | 95678 | 95678: Roseville | 2021-09-07 | Placer | 61 | 3966 | 41221 | |
603821 | 603821 | 95681 | 95681: Sheridan | 2021-09-07 | Placer | 61 | 108 | 1241 | |
603822 | 603822 | 95701 | 95701: Alta | 2021-09-07 | Placer | 61 | 54 | 842 | |
603823 | 603823 | 95703 | 95703: Applegate | 2021-09-07 | Placer | 61 | 131 | 3023 | |
603824 | 603824 | 95713 | 95713: Colfax | 2021-09-07 | Placer | 61 | 488 | 8927 | |
603825 | 603825 | 95714 | 95714: Dutch Flat | 2021-09-07 | Placer | 61 | 17 | 701 | |
603826 | 603826 | 95715 | 95715: Emigrant Gap | 2021-09-07 | Placer | 61 | 11 | 0 | |
603827 | 603827 | 95717 | 95717: Gold Run | 2021-09-07 | Placer | 61 | 5 | 5 or fewer | 0 |
603828 | 603828 | 95722 | 95722: Meadow Vista | 2021-09-07 | Placer | 61 | 305 | 4933 | |
603829 | 603829 | 95724 | 95724: Norden | 2021-09-07 | Placer | 61 | 5 | 5 or fewer | 0 |
603830 | 603830 | 95746 | 95746: Granite Bay | 2021-09-07 | Placer | 61 | 1408 | 21786 | |
603831 | 603831 | 95747 | 95747: Roseville | 2021-09-07 | Placer | 61 | 5774 | 59715 | |
603832 | 603832 | 95765 | 95765: Rocklin | 2021-09-07 | Placer | 61 | 3134 | 37002 | |
603833 | 603833 | 96140 | 96140: Carnelian Bay | 2021-09-07 | Placer | 61 | 84 | 1659 | |
603834 | 603834 | 96141 | 96141: Homewood | 2021-09-07 | Placer | 61 | 25 | 933 | |
603835 | 603835 | 96142 | 96142: Tahoma | 2021-09-07 | Placer | 61 | 5 | 5 or fewer | 0 |
603836 | 603836 | 96143 | 96143: Kings Beach | 2021-09-07 | Placer | 61 | 499 | 3988 | |
603837 | 603837 | 96145 | 96145: Tahoe City | 2021-09-07 | Placer | 61 | 235 | 3033 | |
603838 | 603838 | 96146 | 96146: Olympic Valley | 2021-09-07 | Placer | 61 | 93 | 1326 | |
603839 | 603839 | 96148 | 96148: Tahoe Vista | 2021-09-07 | Placer | 61 | 85 | 1450 | |
603840 | 603840 | 96161 | 96161: Truckee | 2021-09-07 | Placer | 61 | 115 | 18599 | |
603841 | 603841 | 96162 | 96162: Truckee | 2021-09-07 | Placer | 61 | 5 | 5 or fewer | 0 |
605086 | 605086 | 95602 | 95602: Auburn | 2021-09-06 | Placer | 61 | 1081 | 17817 | |
605087 | 605087 | 95603 | 95603: Auburn | 2021-09-06 | Placer | 61 | 2145 | 27256 | |
605088 | 605088 | 95626 | 95626: Elverta | 2021-09-06 | Placer | 61 | 44 | 6371 | |
605089 | 605089 | 95631 | 95631: Foresthill | 2021-09-06 | Placer | 61 | 336 | 6387 | |
605090 | 605090 | 95648 | 95648: Lincoln | 2021-09-06 | Placer | 61 | 3857 | 51257 | |
605091 | 605091 | 95650 | 95650: Loomis | 2021-09-06 | Placer | 61 | 995 | 12986 | |
605092 | 605092 | 95658 | 95658: Newcastle | 2021-09-06 | Placer | 61 | 409 | 6751 | |
605093 | 605093 | 95661 | 95661: Roseville | 2021-09-06 | Placer | 61 | 2926 | 30470 | |
605094 | 605094 | 95663 | 95663: Penryn | 2021-09-06 | Placer | 61 | 208 | 2102 | |
605095 | 605095 | 95677 | 95677: Rocklin | 2021-09-06 | Placer | 61 | 2268 | 23121 | |
605096 | 605096 | 95678 | 95678: Roseville | 2021-09-06 | Placer | 61 | 3966 | 41221 | |
605097 | 605097 | 95681 | 95681: Sheridan | 2021-09-06 | Placer | 61 | 108 | 1241 |
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 );