⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals

13,056 rows where county = "Placer" sorted by date descending

View and edit SQL

fips

  • 61 13,056

county

  • Placer · 13,056
Link rowid id name date ▲ county fips confirmed_cases note population
806 95602 95602: Auburn 2021-04-10 Placer 61 813   17817
807 95603 95603: Auburn 2021-04-10 Placer 61 1466   27256
808 95626 95626: Elverta 2021-04-10 Placer 61 23   6371
809 95631 95631: Foresthill 2021-04-10 Placer 61 211   6387
810 95648 95648: Lincoln 2021-04-10 Placer 61 2791   51257
811 95650 95650: Loomis 2021-04-10 Placer 61 656   12986
812 95658 95658: Newcastle 2021-04-10 Placer 61 286   6751
813 95661 95661: Roseville 2021-04-10 Placer 61 2036   30470
814 95663 95663: Penryn 2021-04-10 Placer 61 145   2102
815 95677 95677: Rocklin 2021-04-10 Placer 61 1430   23121
816 95678 95678: Roseville 2021-04-10 Placer 61 2705   41221
817 95681 95681: Sheridan 2021-04-10 Placer 61 69   1241
818 95701 95701: Alta 2021-04-10 Placer 61 37   842
819 95703 95703: Applegate 2021-04-10 Placer 61 85   3023
820 95713 95713: Colfax 2021-04-10 Placer 61 292   8927
821 95714 95714: Dutch Flat 2021-04-10 Placer 61 10   701
822 95715 95715: Emigrant Gap 2021-04-10 Placer 61 7   0
823 95717 95717: Gold Run 2021-04-10 Placer 61 5 5 or fewer 0
824 95722 95722: Meadow Vista 2021-04-10 Placer 61 182   4933
825 95724 95724: Norden 2021-04-10 Placer 61 5 5 or fewer 0
826 95746 95746: Granite Bay 2021-04-10 Placer 61 945   21786
827 95747 95747: Roseville 2021-04-10 Placer 61 3849   59715
828 95765 95765: Rocklin 2021-04-10 Placer 61 2144   37002
829 96140 96140: Carnelian Bay 2021-04-10 Placer 61 53   1659
830 96141 96141: Homewood 2021-04-10 Placer 61 10   933
831 96142 96142: Tahoma 2021-04-10 Placer 61 5 5 or fewer 0
832 96143 96143: Kings Beach 2021-04-10 Placer 61 368   3988
833 96145 96145: Tahoe City 2021-04-10 Placer 61 159   3033
834 96146 96146: Olympic Valley 2021-04-10 Placer 61 62   1326
835 96148 96148: Tahoe Vista 2021-04-10 Placer 61 57   1450
836 96161 96161: Truckee 2021-04-10 Placer 61 85   18599
837 96162 96162: Truckee 2021-04-10 Placer 61 5 5 or fewer 0
2173 95602 95602: Auburn 2021-04-09 Placer 61 813   17817
2174 95603 95603: Auburn 2021-04-09 Placer 61 1466   27256
2175 95626 95626: Elverta 2021-04-09 Placer 61 23   6371
2176 95631 95631: Foresthill 2021-04-09 Placer 61 211   6387
2177 95648 95648: Lincoln 2021-04-09 Placer 61 2791   51257
2178 95650 95650: Loomis 2021-04-09 Placer 61 656   12986
2179 95658 95658: Newcastle 2021-04-09 Placer 61 286   6751
2180 95661 95661: Roseville 2021-04-09 Placer 61 2036   30470
2181 95663 95663: Penryn 2021-04-09 Placer 61 145   2102
2182 95677 95677: Rocklin 2021-04-09 Placer 61 1430   23121
2183 95678 95678: Roseville 2021-04-09 Placer 61 2705   41221
2184 95681 95681: Sheridan 2021-04-09 Placer 61 69   1241
2185 95701 95701: Alta 2021-04-09 Placer 61 37   842
2186 95703 95703: Applegate 2021-04-09 Placer 61 85   3023
2187 95713 95713: Colfax 2021-04-09 Placer 61 292   8927
2188 95714 95714: Dutch Flat 2021-04-09 Placer 61 10   701
2189 95715 95715: Emigrant Gap 2021-04-09 Placer 61 7   0
2190 95717 95717: Gold Run 2021-04-09 Placer 61 5 5 or fewer 0
2191 95722 95722: Meadow Vista 2021-04-09 Placer 61 182   4933
2192 95724 95724: Norden 2021-04-09 Placer 61 5 5 or fewer 0
2193 95746 95746: Granite Bay 2021-04-09 Placer 61 945   21786
2194 95747 95747: Roseville 2021-04-09 Placer 61 3849   59715
2195 95765 95765: Rocklin 2021-04-09 Placer 61 2144   37002
2196 96140 96140: Carnelian Bay 2021-04-09 Placer 61 53   1659
2197 96141 96141: Homewood 2021-04-09 Placer 61 10   933
2198 96142 96142: Tahoma 2021-04-09 Placer 61 5 5 or fewer 0
2199 96143 96143: Kings Beach 2021-04-09 Placer 61 368   3988
2200 96145 96145: Tahoe City 2021-04-09 Placer 61 159   3033
2201 96146 96146: Olympic Valley 2021-04-09 Placer 61 62   1326
2202 96148 96148: Tahoe Vista 2021-04-09 Placer 61 57   1450
2203 96161 96161: Truckee 2021-04-09 Placer 61 85   18599
2204 96162 96162: Truckee 2021-04-09 Placer 61 5 5 or fewer 0
3543 95602 95602: Auburn 2021-04-08 Placer 61 812   17817
3544 95603 95603: Auburn 2021-04-08 Placer 61 1460   27256
3545 95626 95626: Elverta 2021-04-08 Placer 61 23   6371
3546 95631 95631: Foresthill 2021-04-08 Placer 61 209   6387
3547 95648 95648: Lincoln 2021-04-08 Placer 61 2785   51257
3548 95650 95650: Loomis 2021-04-08 Placer 61 654   12986
3549 95658 95658: Newcastle 2021-04-08 Placer 61 284   6751
3550 95661 95661: Roseville 2021-04-08 Placer 61 2026   30470
3551 95663 95663: Penryn 2021-04-08 Placer 61 145   2102
3552 95677 95677: Rocklin 2021-04-08 Placer 61 1427   23121
3553 95678 95678: Roseville 2021-04-08 Placer 61 2696   41221
3554 95681 95681: Sheridan 2021-04-08 Placer 61 69   1241
3555 95701 95701: Alta 2021-04-08 Placer 61 37   842
3556 95703 95703: Applegate 2021-04-08 Placer 61 84   3023
3557 95713 95713: Colfax 2021-04-08 Placer 61 291   8927
3558 95714 95714: Dutch Flat 2021-04-08 Placer 61 10   701
3559 95715 95715: Emigrant Gap 2021-04-08 Placer 61 7   0
3560 95717 95717: Gold Run 2021-04-08 Placer 61 5 5 or fewer 0
3561 95722 95722: Meadow Vista 2021-04-08 Placer 61 182   4933
3562 95724 95724: Norden 2021-04-08 Placer 61 5 5 or fewer 0
3563 95746 95746: Granite Bay 2021-04-08 Placer 61 939   21786
3564 95747 95747: Roseville 2021-04-08 Placer 61 3837   59715
3565 95765 95765: Rocklin 2021-04-08 Placer 61 2135   37002
3566 96140 96140: Carnelian Bay 2021-04-08 Placer 61 53   1659
3567 96141 96141: Homewood 2021-04-08 Placer 61 10   933
3568 96142 96142: Tahoma 2021-04-08 Placer 61 5 5 or fewer 0
3569 96143 96143: Kings Beach 2021-04-08 Placer 61 368   3988
3570 96145 96145: Tahoe City 2021-04-08 Placer 61 159   3033
3571 96146 96146: Olympic Valley 2021-04-08 Placer 61 62   1326
3572 96148 96148: Tahoe Vista 2021-04-08 Placer 61 56   1450
3573 96161 96161: Truckee 2021-04-08 Placer 61 85   18599
3574 96162 96162: Truckee 2021-04-08 Placer 61 5 5 or fewer 0
4913 95602 95602: Auburn 2021-04-07 Placer 61 810   17817
4914 95603 95603: Auburn 2021-04-07 Placer 61 1460   27256
4915 95626 95626: Elverta 2021-04-07 Placer 61 23   6371
4916 95631 95631: Foresthill 2021-04-07 Placer 61 209   6387

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [latimes_place_totals] (
   [id] TEXT,
   [name] TEXT,
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [population] TEXT
);