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

31,264 rows where county = "Placer" sorted by date descending

✎ View and edit SQL

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

fips 1

  • 61 31,264

county 1

  • Placer · 31,264 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
72359 72359 95602 95602: Auburn 2022-10-31 Placer 61 2433   17817
72360 72360 95603 95603: Auburn 2022-10-31 Placer 61 4976   27256
72361 72361 95626 95626: Elverta 2022-10-31 Placer 61 93   6371
72362 72362 95631 95631: Foresthill 2022-10-31 Placer 61 776   6387
72363 72363 95648 95648: Lincoln 2022-10-31 Placer 61 9608   51257
72364 72364 95650 95650: Loomis 2022-10-31 Placer 61 2227   12986
72365 72365 95658 95658: Newcastle 2022-10-31 Placer 61 980   6751
72366 72366 95661 95661: Roseville 2022-10-31 Placer 61 7114   30470
72367 72367 95663 95663: Penryn 2022-10-31 Placer 61 478   2102
72368 72368 95677 95677: Rocklin 2022-10-31 Placer 61 5410   23121
72369 72369 95678 95678: Roseville 2022-10-31 Placer 61 9285   41221
72370 72370 95681 95681: Sheridan 2022-10-31 Placer 61 250   1241
72371 72371 95701 95701: Alta 2022-10-31 Placer 61 124   842
72372 72372 95703 95703: Applegate 2022-10-31 Placer 61 281   3023
72373 72373 95713 95713: Colfax 2022-10-31 Placer 61 1134   8927
72374 72374 95714 95714: Dutch Flat 2022-10-31 Placer 61 48   701
72375 72375 95715 95715: Emigrant Gap 2022-10-31 Placer 61 19   0
72376 72376 95717 95717: Gold Run 2022-10-31 Placer 61 26   0
72377 72377 95722 95722: Meadow Vista 2022-10-31 Placer 61 689   4933
72378 72378 95724 95724: Norden 2022-10-31 Placer 61 6   0
72379 72379 95746 95746: Granite Bay 2022-10-31 Placer 61 3486   21786
72380 72380 95747 95747: Roseville 2022-10-31 Placer 61 14960   59715
72381 72381 95765 95765: Rocklin 2022-10-31 Placer 61 7873   37002
72382 72382 96140 96140: Carnelian Bay 2022-10-31 Placer 61 206   1659
72383 72383 96141 96141: Homewood 2022-10-31 Placer 61 75   933
72384 72384 96142 96142: Tahoma 2022-10-31 Placer 61 8   0
72385 72385 96143 96143: Kings Beach 2022-10-31 Placer 61 982   3988
72386 72386 96145 96145: Tahoe City 2022-10-31 Placer 61 665   3033
72387 72387 96146 96146: Olympic Valley 2022-10-31 Placer 61 276   1326
72388 72388 96148 96148: Tahoe Vista 2022-10-31 Placer 61 218   1450
72389 72389 96161 96161: Truckee 2022-10-31 Placer 61 348   18599
72390 72390 96162 96162: Truckee 2022-10-31 Placer 61 5 5 or fewer 0
73622 73622 95602 95602: Auburn 2022-10-30 Placer 61 2433   17817
73623 73623 95603 95603: Auburn 2022-10-30 Placer 61 4976   27256
73624 73624 95626 95626: Elverta 2022-10-30 Placer 61 93   6371
73625 73625 95631 95631: Foresthill 2022-10-30 Placer 61 776   6387
73626 73626 95648 95648: Lincoln 2022-10-30 Placer 61 9608   51257
73627 73627 95650 95650: Loomis 2022-10-30 Placer 61 2227   12986
73628 73628 95658 95658: Newcastle 2022-10-30 Placer 61 980   6751
73629 73629 95661 95661: Roseville 2022-10-30 Placer 61 7114   30470
73630 73630 95663 95663: Penryn 2022-10-30 Placer 61 478   2102
73631 73631 95677 95677: Rocklin 2022-10-30 Placer 61 5410   23121
73632 73632 95678 95678: Roseville 2022-10-30 Placer 61 9285   41221
73633 73633 95681 95681: Sheridan 2022-10-30 Placer 61 250   1241
73634 73634 95701 95701: Alta 2022-10-30 Placer 61 124   842
73635 73635 95703 95703: Applegate 2022-10-30 Placer 61 281   3023
73636 73636 95713 95713: Colfax 2022-10-30 Placer 61 1134   8927
73637 73637 95714 95714: Dutch Flat 2022-10-30 Placer 61 48   701
73638 73638 95715 95715: Emigrant Gap 2022-10-30 Placer 61 19   0
73639 73639 95717 95717: Gold Run 2022-10-30 Placer 61 26   0
73640 73640 95722 95722: Meadow Vista 2022-10-30 Placer 61 689   4933
73641 73641 95724 95724: Norden 2022-10-30 Placer 61 6   0
73642 73642 95746 95746: Granite Bay 2022-10-30 Placer 61 3486   21786
73643 73643 95747 95747: Roseville 2022-10-30 Placer 61 14960   59715
73644 73644 95765 95765: Rocklin 2022-10-30 Placer 61 7873   37002
73645 73645 96140 96140: Carnelian Bay 2022-10-30 Placer 61 206   1659
73646 73646 96141 96141: Homewood 2022-10-30 Placer 61 75   933
73647 73647 96142 96142: Tahoma 2022-10-30 Placer 61 8   0
73648 73648 96143 96143: Kings Beach 2022-10-30 Placer 61 982   3988
73649 73649 96145 96145: Tahoe City 2022-10-30 Placer 61 665   3033
73650 73650 96146 96146: Olympic Valley 2022-10-30 Placer 61 276   1326
73651 73651 96148 96148: Tahoe Vista 2022-10-30 Placer 61 218   1450
73652 73652 96161 96161: Truckee 2022-10-30 Placer 61 348   18599
73653 73653 96162 96162: Truckee 2022-10-30 Placer 61 5 5 or fewer 0
74885 74885 95602 95602: Auburn 2022-10-29 Placer 61 2433   17817
74886 74886 95603 95603: Auburn 2022-10-29 Placer 61 4976   27256
74887 74887 95626 95626: Elverta 2022-10-29 Placer 61 93   6371
74888 74888 95631 95631: Foresthill 2022-10-29 Placer 61 776   6387
74889 74889 95648 95648: Lincoln 2022-10-29 Placer 61 9608   51257
74890 74890 95650 95650: Loomis 2022-10-29 Placer 61 2227   12986
74891 74891 95658 95658: Newcastle 2022-10-29 Placer 61 980   6751
74892 74892 95661 95661: Roseville 2022-10-29 Placer 61 7114   30470
74893 74893 95663 95663: Penryn 2022-10-29 Placer 61 478   2102
74894 74894 95677 95677: Rocklin 2022-10-29 Placer 61 5410   23121
74895 74895 95678 95678: Roseville 2022-10-29 Placer 61 9285   41221
74896 74896 95681 95681: Sheridan 2022-10-29 Placer 61 250   1241
74897 74897 95701 95701: Alta 2022-10-29 Placer 61 124   842
74898 74898 95703 95703: Applegate 2022-10-29 Placer 61 281   3023
74899 74899 95713 95713: Colfax 2022-10-29 Placer 61 1134   8927
74900 74900 95714 95714: Dutch Flat 2022-10-29 Placer 61 48   701
74901 74901 95715 95715: Emigrant Gap 2022-10-29 Placer 61 19   0
74902 74902 95717 95717: Gold Run 2022-10-29 Placer 61 26   0
74903 74903 95722 95722: Meadow Vista 2022-10-29 Placer 61 689   4933
74904 74904 95724 95724: Norden 2022-10-29 Placer 61 6   0
74905 74905 95746 95746: Granite Bay 2022-10-29 Placer 61 3486   21786
74906 74906 95747 95747: Roseville 2022-10-29 Placer 61 14960   59715
74907 74907 95765 95765: Rocklin 2022-10-29 Placer 61 7873   37002
74908 74908 96140 96140: Carnelian Bay 2022-10-29 Placer 61 206   1659
74909 74909 96141 96141: Homewood 2022-10-29 Placer 61 75   933
74910 74910 96142 96142: Tahoma 2022-10-29 Placer 61 8   0
74911 74911 96143 96143: Kings Beach 2022-10-29 Placer 61 982   3988
74912 74912 96145 96145: Tahoe City 2022-10-29 Placer 61 665   3033
74913 74913 96146 96146: Olympic Valley 2022-10-29 Placer 61 276   1326
74914 74914 96148 96148: Tahoe Vista 2022-10-29 Placer 61 218   1450
74915 74915 96161 96161: Truckee 2022-10-29 Placer 61 348   18599
74916 74916 96162 96162: Truckee 2022-10-29 Placer 61 5 5 or fewer 0
76148 76148 95602 95602: Auburn 2022-10-28 Placer 61 2433   17817
76149 76149 95603 95603: Auburn 2022-10-28 Placer 61 4976   27256
76150 76150 95626 95626: Elverta 2022-10-28 Placer 61 93   6371
76151 76151 95631 95631: Foresthill 2022-10-28 Placer 61 776   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
);