latimes_place_totals

Table actions
⚠️ 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

19,456 rows where fips = 61 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips

  • 61 · 19,456 ✖

county

Link rowid id name date ▲ county fips confirmed_cases note population
807 807 95602 95602: Auburn 2021-10-27 Placer 61 1250   17817
808 808 95603 95603: Auburn 2021-10-27 Placer 61 2592   27256
809 809 95626 95626: Elverta 2021-10-27 Placer 61 51   6371
810 810 95631 95631: Foresthill 2021-10-27 Placer 61 385   6387
811 811 95648 95648: Lincoln 2021-10-27 Placer 61 4436   51257
812 812 95650 95650: Loomis 2021-10-27 Placer 61 1166   12986
813 813 95658 95658: Newcastle 2021-10-27 Placer 61 498   6751
814 814 95661 95661: Roseville 2021-10-27 Placer 61 3281   30470
815 815 95663 95663: Penryn 2021-10-27 Placer 61 240   2102
816 816 95677 95677: Rocklin 2021-10-27 Placer 61 2598   23121
817 817 95678 95678: Roseville 2021-10-27 Placer 61 4499   41221
818 818 95681 95681: Sheridan 2021-10-27 Placer 61 127   1241
819 819 95701 95701: Alta 2021-10-27 Placer 61 65   842
820 820 95703 95703: Applegate 2021-10-27 Placer 61 154   3023
821 821 95713 95713: Colfax 2021-10-27 Placer 61 599   8927
822 822 95714 95714: Dutch Flat 2021-10-27 Placer 61 19   701
823 823 95715 95715: Emigrant Gap 2021-10-27 Placer 61 13   0
824 824 95717 95717: Gold Run 2021-10-27 Placer 61 6   0
825 825 95722 95722: Meadow Vista 2021-10-27 Placer 61 351   4933
826 826 95724 95724: Norden 2021-10-27 Placer 61 5 5 or fewer 0
827 827 95746 95746: Granite Bay 2021-10-27 Placer 61 1569   21786
828 828 95747 95747: Roseville 2021-10-27 Placer 61 6543   59715
829 829 95765 95765: Rocklin 2021-10-27 Placer 61 3561   37002
830 830 96140 96140: Carnelian Bay 2021-10-27 Placer 61 102   1659
831 831 96141 96141: Homewood 2021-10-27 Placer 61 34   933
832 832 96142 96142: Tahoma 2021-10-27 Placer 61 5 5 or fewer 0
833 833 96143 96143: Kings Beach 2021-10-27 Placer 61 560   3988
834 834 96145 96145: Tahoe City 2021-10-27 Placer 61 293   3033
835 835 96146 96146: Olympic Valley 2021-10-27 Placer 61 115   1326
836 836 96148 96148: Tahoe Vista 2021-10-27 Placer 61 94   1450
837 837 96161 96161: Truckee 2021-10-27 Placer 61 145   18599
838 838 96162 96162: Truckee 2021-10-27 Placer 61 5 5 or fewer 0
2172 2172 95602 95602: Auburn 2021-10-26 Placer 61 1250   17817
2173 2173 95603 95603: Auburn 2021-10-26 Placer 61 2592   27256
2174 2174 95626 95626: Elverta 2021-10-26 Placer 61 51   6371
2175 2175 95631 95631: Foresthill 2021-10-26 Placer 61 385   6387
2176 2176 95648 95648: Lincoln 2021-10-26 Placer 61 4436   51257
2177 2177 95650 95650: Loomis 2021-10-26 Placer 61 1166   12986
2178 2178 95658 95658: Newcastle 2021-10-26 Placer 61 498   6751
2179 2179 95661 95661: Roseville 2021-10-26 Placer 61 3281   30470
2180 2180 95663 95663: Penryn 2021-10-26 Placer 61 240   2102
2181 2181 95677 95677: Rocklin 2021-10-26 Placer 61 2598   23121
2182 2182 95678 95678: Roseville 2021-10-26 Placer 61 4499   41221
2183 2183 95681 95681: Sheridan 2021-10-26 Placer 61 127   1241
2184 2184 95701 95701: Alta 2021-10-26 Placer 61 65   842
2185 2185 95703 95703: Applegate 2021-10-26 Placer 61 154   3023
2186 2186 95713 95713: Colfax 2021-10-26 Placer 61 599   8927
2187 2187 95714 95714: Dutch Flat 2021-10-26 Placer 61 19   701
2188 2188 95715 95715: Emigrant Gap 2021-10-26 Placer 61 13   0
2189 2189 95717 95717: Gold Run 2021-10-26 Placer 61 6   0
2190 2190 95722 95722: Meadow Vista 2021-10-26 Placer 61 351   4933
2191 2191 95724 95724: Norden 2021-10-26 Placer 61 5 5 or fewer 0
2192 2192 95746 95746: Granite Bay 2021-10-26 Placer 61 1569   21786
2193 2193 95747 95747: Roseville 2021-10-26 Placer 61 6543   59715
2194 2194 95765 95765: Rocklin 2021-10-26 Placer 61 3561   37002
2195 2195 96140 96140: Carnelian Bay 2021-10-26 Placer 61 102   1659
2196 2196 96141 96141: Homewood 2021-10-26 Placer 61 34   933
2197 2197 96142 96142: Tahoma 2021-10-26 Placer 61 5 5 or fewer 0
2198 2198 96143 96143: Kings Beach 2021-10-26 Placer 61 560   3988
2199 2199 96145 96145: Tahoe City 2021-10-26 Placer 61 293   3033
2200 2200 96146 96146: Olympic Valley 2021-10-26 Placer 61 115   1326
2201 2201 96148 96148: Tahoe Vista 2021-10-26 Placer 61 94   1450
2202 2202 96161 96161: Truckee 2021-10-26 Placer 61 145   18599
2203 2203 96162 96162: Truckee 2021-10-26 Placer 61 5 5 or fewer 0
3537 3537 95602 95602: Auburn 2021-10-25 Placer 61 1250   17817
3538 3538 95603 95603: Auburn 2021-10-25 Placer 61 2592   27256
3539 3539 95626 95626: Elverta 2021-10-25 Placer 61 51   6371
3540 3540 95631 95631: Foresthill 2021-10-25 Placer 61 385   6387
3541 3541 95648 95648: Lincoln 2021-10-25 Placer 61 4436   51257
3542 3542 95650 95650: Loomis 2021-10-25 Placer 61 1166   12986
3543 3543 95658 95658: Newcastle 2021-10-25 Placer 61 498   6751
3544 3544 95661 95661: Roseville 2021-10-25 Placer 61 3281   30470
3545 3545 95663 95663: Penryn 2021-10-25 Placer 61 240   2102
3546 3546 95677 95677: Rocklin 2021-10-25 Placer 61 2598   23121
3547 3547 95678 95678: Roseville 2021-10-25 Placer 61 4499   41221
3548 3548 95681 95681: Sheridan 2021-10-25 Placer 61 127   1241
3549 3549 95701 95701: Alta 2021-10-25 Placer 61 65   842
3550 3550 95703 95703: Applegate 2021-10-25 Placer 61 154   3023
3551 3551 95713 95713: Colfax 2021-10-25 Placer 61 599   8927
3552 3552 95714 95714: Dutch Flat 2021-10-25 Placer 61 19   701
3553 3553 95715 95715: Emigrant Gap 2021-10-25 Placer 61 13   0
3554 3554 95717 95717: Gold Run 2021-10-25 Placer 61 6   0
3555 3555 95722 95722: Meadow Vista 2021-10-25 Placer 61 351   4933
3556 3556 95724 95724: Norden 2021-10-25 Placer 61 5 5 or fewer 0
3557 3557 95746 95746: Granite Bay 2021-10-25 Placer 61 1569   21786
3558 3558 95747 95747: Roseville 2021-10-25 Placer 61 6543   59715
3559 3559 95765 95765: Rocklin 2021-10-25 Placer 61 3561   37002
3560 3560 96140 96140: Carnelian Bay 2021-10-25 Placer 61 102   1659
3561 3561 96141 96141: Homewood 2021-10-25 Placer 61 34   933
3562 3562 96142 96142: Tahoma 2021-10-25 Placer 61 5 5 or fewer 0
3563 3563 96143 96143: Kings Beach 2021-10-25 Placer 61 560   3988
3564 3564 96145 96145: Tahoe City 2021-10-25 Placer 61 293   3033
3565 3565 96146 96146: Olympic Valley 2021-10-25 Placer 61 115   1326
3566 3566 96148 96148: Tahoe Vista 2021-10-25 Placer 61 94   1450
3567 3567 96161 96161: Truckee 2021-10-25 Placer 61 145   18599
3568 3568 96162 96162: Truckee 2021-10-25 Placer 61 5 5 or fewer 0
4902 4902 95602 95602: Auburn 2021-10-24 Placer 61 1250   17817
4903 4903 95603 95603: Auburn 2021-10-24 Placer 61 2592   27256
4904 4904 95626 95626: Elverta 2021-10-24 Placer 61 51   6371
4905 4905 95631 95631: Foresthill 2021-10-24 Placer 61 385   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
);