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

13,056 rows where fips = 61 sorted by date descending

✎ View and edit SQL

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

fips

  • 61 · 13,056 ✖

county

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