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 |
---|---|---|---|---|---|---|---|---|---|
503006 | 503006 | 95602 | 95602: Auburn | 2021-11-25 | Placer | 61 | 1311 | 17817 | |
503007 | 503007 | 95603 | 95603: Auburn | 2021-11-25 | Placer | 61 | 2723 | 27256 | |
503008 | 503008 | 95626 | 95626: Elverta | 2021-11-25 | Placer | 61 | 56 | 6371 | |
503009 | 503009 | 95631 | 95631: Foresthill | 2021-11-25 | Placer | 61 | 416 | 6387 | |
503010 | 503010 | 95648 | 95648: Lincoln | 2021-11-25 | Placer | 61 | 4693 | 51257 | |
503011 | 503011 | 95650 | 95650: Loomis | 2021-11-25 | Placer | 61 | 1240 | 12986 | |
503012 | 503012 | 95658 | 95658: Newcastle | 2021-11-25 | Placer | 61 | 542 | 6751 | |
503013 | 503013 | 95661 | 95661: Roseville | 2021-11-25 | Placer | 61 | 3522 | 30470 | |
503014 | 503014 | 95663 | 95663: Penryn | 2021-11-25 | Placer | 61 | 254 | 2102 | |
503015 | 503015 | 95677 | 95677: Rocklin | 2021-11-25 | Placer | 61 | 2768 | 23121 | |
503016 | 503016 | 95678 | 95678: Roseville | 2021-11-25 | Placer | 61 | 4750 | 41221 | |
503017 | 503017 | 95681 | 95681: Sheridan | 2021-11-25 | Placer | 61 | 133 | 1241 | |
503018 | 503018 | 95701 | 95701: Alta | 2021-11-25 | Placer | 61 | 74 | 842 | |
503019 | 503019 | 95703 | 95703: Applegate | 2021-11-25 | Placer | 61 | 164 | 3023 | |
503020 | 503020 | 95713 | 95713: Colfax | 2021-11-25 | Placer | 61 | 633 | 8927 | |
503021 | 503021 | 95714 | 95714: Dutch Flat | 2021-11-25 | Placer | 61 | 22 | 701 | |
503022 | 503022 | 95715 | 95715: Emigrant Gap | 2021-11-25 | Placer | 61 | 13 | 0 | |
503023 | 503023 | 95717 | 95717: Gold Run | 2021-11-25 | Placer | 61 | 6 | 0 | |
503024 | 503024 | 95722 | 95722: Meadow Vista | 2021-11-25 | Placer | 61 | 379 | 4933 | |
503025 | 503025 | 95724 | 95724: Norden | 2021-11-25 | Placer | 61 | 6 | 0 | |
503026 | 503026 | 95746 | 95746: Granite Bay | 2021-11-25 | Placer | 61 | 1659 | 21786 | |
503027 | 503027 | 95747 | 95747: Roseville | 2021-11-25 | Placer | 61 | 6934 | 59715 | |
503028 | 503028 | 95765 | 95765: Rocklin | 2021-11-25 | Placer | 61 | 3754 | 37002 | |
503029 | 503029 | 96140 | 96140: Carnelian Bay | 2021-11-25 | Placer | 61 | 110 | 1659 | |
503030 | 503030 | 96141 | 96141: Homewood | 2021-11-25 | Placer | 61 | 34 | 933 | |
503031 | 503031 | 96142 | 96142: Tahoma | 2021-11-25 | Placer | 61 | 5 | 5 or fewer | 0 |
503032 | 503032 | 96143 | 96143: Kings Beach | 2021-11-25 | Placer | 61 | 595 | 3988 | |
503033 | 503033 | 96145 | 96145: Tahoe City | 2021-11-25 | Placer | 61 | 324 | 3033 | |
503034 | 503034 | 96146 | 96146: Olympic Valley | 2021-11-25 | Placer | 61 | 130 | 1326 | |
503035 | 503035 | 96148 | 96148: Tahoe Vista | 2021-11-25 | Placer | 61 | 102 | 1450 | |
503036 | 503036 | 96161 | 96161: Truckee | 2021-11-25 | Placer | 61 | 169 | 18599 | |
503037 | 503037 | 96162 | 96162: Truckee | 2021-11-25 | Placer | 61 | 5 | 5 or fewer | 0 |
504282 | 504282 | 95602 | 95602: Auburn | 2021-11-24 | Placer | 61 | 1311 | 17817 | |
504283 | 504283 | 95603 | 95603: Auburn | 2021-11-24 | Placer | 61 | 2723 | 27256 | |
504284 | 504284 | 95626 | 95626: Elverta | 2021-11-24 | Placer | 61 | 56 | 6371 | |
504285 | 504285 | 95631 | 95631: Foresthill | 2021-11-24 | Placer | 61 | 416 | 6387 | |
504286 | 504286 | 95648 | 95648: Lincoln | 2021-11-24 | Placer | 61 | 4693 | 51257 | |
504287 | 504287 | 95650 | 95650: Loomis | 2021-11-24 | Placer | 61 | 1240 | 12986 | |
504288 | 504288 | 95658 | 95658: Newcastle | 2021-11-24 | Placer | 61 | 542 | 6751 | |
504289 | 504289 | 95661 | 95661: Roseville | 2021-11-24 | Placer | 61 | 3522 | 30470 | |
504290 | 504290 | 95663 | 95663: Penryn | 2021-11-24 | Placer | 61 | 254 | 2102 | |
504291 | 504291 | 95677 | 95677: Rocklin | 2021-11-24 | Placer | 61 | 2768 | 23121 | |
504292 | 504292 | 95678 | 95678: Roseville | 2021-11-24 | Placer | 61 | 4750 | 41221 | |
504293 | 504293 | 95681 | 95681: Sheridan | 2021-11-24 | Placer | 61 | 133 | 1241 | |
504294 | 504294 | 95701 | 95701: Alta | 2021-11-24 | Placer | 61 | 74 | 842 | |
504295 | 504295 | 95703 | 95703: Applegate | 2021-11-24 | Placer | 61 | 164 | 3023 | |
504296 | 504296 | 95713 | 95713: Colfax | 2021-11-24 | Placer | 61 | 633 | 8927 | |
504297 | 504297 | 95714 | 95714: Dutch Flat | 2021-11-24 | Placer | 61 | 22 | 701 | |
504298 | 504298 | 95715 | 95715: Emigrant Gap | 2021-11-24 | Placer | 61 | 13 | 0 | |
504299 | 504299 | 95717 | 95717: Gold Run | 2021-11-24 | Placer | 61 | 6 | 0 | |
504300 | 504300 | 95722 | 95722: Meadow Vista | 2021-11-24 | Placer | 61 | 379 | 4933 | |
504301 | 504301 | 95724 | 95724: Norden | 2021-11-24 | Placer | 61 | 6 | 0 | |
504302 | 504302 | 95746 | 95746: Granite Bay | 2021-11-24 | Placer | 61 | 1659 | 21786 | |
504303 | 504303 | 95747 | 95747: Roseville | 2021-11-24 | Placer | 61 | 6934 | 59715 | |
504304 | 504304 | 95765 | 95765: Rocklin | 2021-11-24 | Placer | 61 | 3754 | 37002 | |
504305 | 504305 | 96140 | 96140: Carnelian Bay | 2021-11-24 | Placer | 61 | 110 | 1659 | |
504306 | 504306 | 96141 | 96141: Homewood | 2021-11-24 | Placer | 61 | 34 | 933 | |
504307 | 504307 | 96142 | 96142: Tahoma | 2021-11-24 | Placer | 61 | 5 | 5 or fewer | 0 |
504308 | 504308 | 96143 | 96143: Kings Beach | 2021-11-24 | Placer | 61 | 595 | 3988 | |
504309 | 504309 | 96145 | 96145: Tahoe City | 2021-11-24 | Placer | 61 | 324 | 3033 | |
504310 | 504310 | 96146 | 96146: Olympic Valley | 2021-11-24 | Placer | 61 | 130 | 1326 | |
504311 | 504311 | 96148 | 96148: Tahoe Vista | 2021-11-24 | Placer | 61 | 102 | 1450 | |
504312 | 504312 | 96161 | 96161: Truckee | 2021-11-24 | Placer | 61 | 169 | 18599 | |
504313 | 504313 | 96162 | 96162: Truckee | 2021-11-24 | Placer | 61 | 5 | 5 or fewer | 0 |
505558 | 505558 | 95602 | 95602: Auburn | 2021-11-23 | Placer | 61 | 1311 | 17817 | |
505559 | 505559 | 95603 | 95603: Auburn | 2021-11-23 | Placer | 61 | 2721 | 27256 | |
505560 | 505560 | 95626 | 95626: Elverta | 2021-11-23 | Placer | 61 | 56 | 6371 | |
505561 | 505561 | 95631 | 95631: Foresthill | 2021-11-23 | Placer | 61 | 416 | 6387 | |
505562 | 505562 | 95648 | 95648: Lincoln | 2021-11-23 | Placer | 61 | 4686 | 51257 | |
505563 | 505563 | 95650 | 95650: Loomis | 2021-11-23 | Placer | 61 | 1237 | 12986 | |
505564 | 505564 | 95658 | 95658: Newcastle | 2021-11-23 | Placer | 61 | 542 | 6751 | |
505565 | 505565 | 95661 | 95661: Roseville | 2021-11-23 | Placer | 61 | 3515 | 30470 | |
505566 | 505566 | 95663 | 95663: Penryn | 2021-11-23 | Placer | 61 | 254 | 2102 | |
505567 | 505567 | 95677 | 95677: Rocklin | 2021-11-23 | Placer | 61 | 2754 | 23121 | |
505568 | 505568 | 95678 | 95678: Roseville | 2021-11-23 | Placer | 61 | 4733 | 41221 | |
505569 | 505569 | 95681 | 95681: Sheridan | 2021-11-23 | Placer | 61 | 133 | 1241 | |
505570 | 505570 | 95701 | 95701: Alta | 2021-11-23 | Placer | 61 | 72 | 842 | |
505571 | 505571 | 95703 | 95703: Applegate | 2021-11-23 | Placer | 61 | 164 | 3023 | |
505572 | 505572 | 95713 | 95713: Colfax | 2021-11-23 | Placer | 61 | 630 | 8927 | |
505573 | 505573 | 95714 | 95714: Dutch Flat | 2021-11-23 | Placer | 61 | 22 | 701 | |
505574 | 505574 | 95715 | 95715: Emigrant Gap | 2021-11-23 | Placer | 61 | 13 | 0 | |
505575 | 505575 | 95717 | 95717: Gold Run | 2021-11-23 | Placer | 61 | 6 | 0 | |
505576 | 505576 | 95722 | 95722: Meadow Vista | 2021-11-23 | Placer | 61 | 379 | 4933 | |
505577 | 505577 | 95724 | 95724: Norden | 2021-11-23 | Placer | 61 | 6 | 0 | |
505578 | 505578 | 95746 | 95746: Granite Bay | 2021-11-23 | Placer | 61 | 1651 | 21786 | |
505579 | 505579 | 95747 | 95747: Roseville | 2021-11-23 | Placer | 61 | 6908 | 59715 | |
505580 | 505580 | 95765 | 95765: Rocklin | 2021-11-23 | Placer | 61 | 3748 | 37002 | |
505581 | 505581 | 96140 | 96140: Carnelian Bay | 2021-11-23 | Placer | 61 | 110 | 1659 | |
505582 | 505582 | 96141 | 96141: Homewood | 2021-11-23 | Placer | 61 | 34 | 933 | |
505583 | 505583 | 96142 | 96142: Tahoma | 2021-11-23 | Placer | 61 | 5 | 5 or fewer | 0 |
505584 | 505584 | 96143 | 96143: Kings Beach | 2021-11-23 | Placer | 61 | 594 | 3988 | |
505585 | 505585 | 96145 | 96145: Tahoe City | 2021-11-23 | Placer | 61 | 321 | 3033 | |
505586 | 505586 | 96146 | 96146: Olympic Valley | 2021-11-23 | Placer | 61 | 130 | 1326 | |
505587 | 505587 | 96148 | 96148: Tahoe Vista | 2021-11-23 | Placer | 61 | 102 | 1450 | |
505588 | 505588 | 96161 | 96161: Truckee | 2021-11-23 | Placer | 61 | 169 | 18599 | |
505589 | 505589 | 96162 | 96162: Truckee | 2021-11-23 | Placer | 61 | 5 | 5 or fewer | 0 |
506834 | 506834 | 95602 | 95602: Auburn | 2021-11-22 | Placer | 61 | 1311 | 17817 | |
506835 | 506835 | 95603 | 95603: Auburn | 2021-11-22 | Placer | 61 | 2721 | 27256 | |
506836 | 506836 | 95626 | 95626: Elverta | 2021-11-22 | Placer | 61 | 56 | 6371 | |
506837 | 506837 | 95631 | 95631: Foresthill | 2021-11-22 | Placer | 61 | 416 | 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 );