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

3,320 rows where county = "Placer" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 61 3,320

county

  • Placer · 3,320 ✖
Link rowid date ▲ county fips place confirmed_cases note x y population
763 763 2021-01-27 Placer 61 95602: Auburn 715   -121.09142 38.976837 178201
764 764 2021-01-27 Placer 61 95603: Auburn 1187   -121.07971 38.909605 272491
765 765 2021-01-27 Placer 61 95626: Elverta 20   -121.45433 38.727451 63584
766 766 2021-01-27 Placer 61 95631: Foresthill 172   -120.82172 39.033312 63892
767 767 2021-01-27 Placer 61 95648: Lincoln 2459   -121.29795 38.902873 512543
768 768 2021-01-27 Placer 61 95650: Loomis 545   -121.17225 38.817508 129856
769 769 2021-01-27 Placer 61 95658: Newcastle 235   -121.14213 38.87672 67508
770 770 2021-01-27 Placer 61 95661: Roseville 1730   -121.2531 38.731976 304680
771 771 2021-01-27 Placer 61 95663: Penryn 111   -121.17565 38.859227 21024
772 772 2021-01-27 Placer 61 95677: Rocklin 1190   -121.23825 38.789165 231212
773 773 2021-01-27 Placer 61 95678: Roseville 2278   -121.28933 38.752434 412235
774 774 2021-01-27 Placer 61 95681: Sheridan 59   -121.37967 38.997612 12411
775 775 2021-01-27 Placer 61 95701: Alta 24   -120.78346 39.217668 8419
776 776 2021-01-27 Placer 61 95703: Applegate 62   -120.99703 38.995732 30240
777 777 2021-01-27 Placer 61 95713: Colfax 221   -120.93471 39.092062 89224
778 778 2021-01-27 Placer 61 95714: Dutch Flat 5 5 or fewer -120.83816 39.204434  
779 779 2021-01-27 Placer 61 95715: Emigrant Gap 5 5 or fewer -120.7067 39.277658  
780 780 2021-01-27 Placer 61 95717: Gold Run 5 5 or fewer -120.8451 39.177026  
781 781 2021-01-27 Placer 61 95722: Meadow Vista 163   -121.01891 39.005098 49339
782 782 2021-01-27 Placer 61 95724: Norden 5 5 or fewer -120.64145 39.26599  
783 783 2021-01-27 Placer 61 95746: Granite Bay 757   -121.19013 38.743811 217786
784 784 2021-01-27 Placer 61 95747: Roseville 3232   -121.33629 38.768829 597255
785 785 2021-01-27 Placer 61 95765: Rocklin 1840   -121.2631 38.817993 370093
786 786 2021-01-27 Placer 61 96140: Carnelian Bay 44   -120.08627 39.223151 16588
787 787 2021-01-27 Placer 61 96141: Homewood 6   -120.16325 39.093271  
788 788 2021-01-27 Placer 61 96142: Tahoma 5 5 or fewer -120.12438 39.037696  
789 789 2021-01-27 Placer 61 96143: Kings Beach 300   -120.02809 39.241961 39882
790 790 2021-01-27 Placer 61 96145: Tahoe City 132   -120.14607 39.177383 30334
791 791 2021-01-27 Placer 61 96146: Olympic Valley 51   -120.21804 39.180983 13258
792 792 2021-01-27 Placer 61 96148: Tahoe Vista 44   -120.05437 39.243877 14501
793 793 2021-01-27 Placer 61 96161: Truckee 65   -120.22805 39.339574 185771
794 794 2021-01-27 Placer 61 96162: Truckee 5 5 or fewer -120.64145 39.26599  
2100 2100 2021-01-26 Placer 61 95602: Auburn 715   -121.09142 38.976837 178201
2101 2101 2021-01-26 Placer 61 95603: Auburn 1187   -121.07971 38.909605 272491
2102 2102 2021-01-26 Placer 61 95626: Elverta 20   -121.45433 38.727451 63584
2103 2103 2021-01-26 Placer 61 95631: Foresthill 172   -120.82172 39.033312 63892
2104 2104 2021-01-26 Placer 61 95648: Lincoln 2459   -121.29795 38.902873 512543
2105 2105 2021-01-26 Placer 61 95650: Loomis 545   -121.17225 38.817508 129856
2106 2106 2021-01-26 Placer 61 95658: Newcastle 235   -121.14213 38.87672 67508
2107 2107 2021-01-26 Placer 61 95661: Roseville 1730   -121.2531 38.731976 304680
2108 2108 2021-01-26 Placer 61 95663: Penryn 111   -121.17565 38.859227 21024
2109 2109 2021-01-26 Placer 61 95677: Rocklin 1190   -121.23825 38.789165 231212
2110 2110 2021-01-26 Placer 61 95678: Roseville 2278   -121.28933 38.752434 412235
2111 2111 2021-01-26 Placer 61 95681: Sheridan 59   -121.37967 38.997612 12411
2112 2112 2021-01-26 Placer 61 95701: Alta 24   -120.78346 39.217668 8419
2113 2113 2021-01-26 Placer 61 95703: Applegate 62   -120.99703 38.995732 30240
2114 2114 2021-01-26 Placer 61 95713: Colfax 221   -120.93471 39.092062 89224
2115 2115 2021-01-26 Placer 61 95714: Dutch Flat 5 5 or fewer -120.83816 39.204434  
2116 2116 2021-01-26 Placer 61 95715: Emigrant Gap 5 5 or fewer -120.7067 39.277658  
2117 2117 2021-01-26 Placer 61 95717: Gold Run 5 5 or fewer -120.8451 39.177026  
2118 2118 2021-01-26 Placer 61 95722: Meadow Vista 163   -121.01891 39.005098 49339
2119 2119 2021-01-26 Placer 61 95724: Norden 5 5 or fewer -120.64145 39.26599  
2120 2120 2021-01-26 Placer 61 95746: Granite Bay 757   -121.19013 38.743811 217786
2121 2121 2021-01-26 Placer 61 95747: Roseville 3232   -121.33629 38.768829 597255
2122 2122 2021-01-26 Placer 61 95765: Rocklin 1840   -121.2631 38.817993 370093
2123 2123 2021-01-26 Placer 61 96140: Carnelian Bay 44   -120.08627 39.223151 16588
2124 2124 2021-01-26 Placer 61 96141: Homewood 6   -120.16325 39.093271  
2125 2125 2021-01-26 Placer 61 96142: Tahoma 5 5 or fewer -120.12438 39.037696  
2126 2126 2021-01-26 Placer 61 96143: Kings Beach 300   -120.02809 39.241961 39882
2127 2127 2021-01-26 Placer 61 96145: Tahoe City 132   -120.14607 39.177383 30334
2128 2128 2021-01-26 Placer 61 96146: Olympic Valley 51   -120.21804 39.180983 13258
2129 2129 2021-01-26 Placer 61 96148: Tahoe Vista 44   -120.05437 39.243877 14501
2130 2130 2021-01-26 Placer 61 96161: Truckee 65   -120.22805 39.339574 185771
2131 2131 2021-01-26 Placer 61 96162: Truckee 5 5 or fewer -120.64145 39.26599  
3441 3441 2021-01-25 Placer 61 95602: Auburn 707   -121.09142 38.976837 178201
3442 3442 2021-01-25 Placer 61 95603: Auburn 1166   -121.07971 38.909605 272491
3443 3443 2021-01-25 Placer 61 95626: Elverta 20   -121.45433 38.727451 63584
3444 3444 2021-01-25 Placer 61 95631: Foresthill 163   -120.82172 39.033312 63892
3445 3445 2021-01-25 Placer 61 95648: Lincoln 2421   -121.29795 38.902873 512543
3446 3446 2021-01-25 Placer 61 95650: Loomis 529   -121.17225 38.817508 129856
3447 3447 2021-01-25 Placer 61 95658: Newcastle 230   -121.14213 38.87672 67508
3448 3448 2021-01-25 Placer 61 95661: Roseville 1689   -121.2531 38.731976 304680
3449 3449 2021-01-25 Placer 61 95663: Penryn 110   -121.17565 38.859227 21024
3450 3450 2021-01-25 Placer 61 95677: Rocklin 1162   -121.23825 38.789165 231212
3451 3451 2021-01-25 Placer 61 95678: Roseville 2223   -121.28933 38.752434 412235
3452 3452 2021-01-25 Placer 61 95681: Sheridan 59   -121.37967 38.997612 12411
3453 3453 2021-01-25 Placer 61 95701: Alta 23   -120.78346 39.217668 8419
3454 3454 2021-01-25 Placer 61 95703: Applegate 62   -120.99703 38.995732 30240
3455 3455 2021-01-25 Placer 61 95713: Colfax 213   -120.93471 39.092062 89224
3456 3456 2021-01-25 Placer 61 95714: Dutch Flat 5 5 or fewer -120.83816 39.204434  
3457 3457 2021-01-25 Placer 61 95715: Emigrant Gap 5 5 or fewer -120.7067 39.277658  
3458 3458 2021-01-25 Placer 61 95717: Gold Run 5 5 or fewer -120.8451 39.177026  
3459 3459 2021-01-25 Placer 61 95722: Meadow Vista 161   -121.01891 39.005098 49339
3460 3460 2021-01-25 Placer 61 95724: Norden 5 5 or fewer -120.64145 39.26599  
3461 3461 2021-01-25 Placer 61 95746: Granite Bay 732   -121.19013 38.743811 217786
3462 3462 2021-01-25 Placer 61 95747: Roseville 3165   -121.33629 38.768829 597255
3463 3463 2021-01-25 Placer 61 95765: Rocklin 1819   -121.2631 38.817993 370093
3464 3464 2021-01-25 Placer 61 96140: Carnelian Bay 43   -120.08627 39.223151 16588
3465 3465 2021-01-25 Placer 61 96141: Homewood 6   -120.16325 39.093271  
3466 3466 2021-01-25 Placer 61 96142: Tahoma 5 5 or fewer -120.12438 39.037696  
3467 3467 2021-01-25 Placer 61 96143: Kings Beach 295   -120.02809 39.241961 39882
3468 3468 2021-01-25 Placer 61 96145: Tahoe City 133   -120.14607 39.177383 30334
3469 3469 2021-01-25 Placer 61 96146: Olympic Valley 49   -120.21804 39.180983 13258
3470 3470 2021-01-25 Placer 61 96148: Tahoe Vista 44   -120.05437 39.243877 14501
3471 3471 2021-01-25 Placer 61 96161: Truckee 64   -120.22805 39.339574 185771
3472 3472 2021-01-25 Placer 61 96162: Truckee 5 5 or fewer -120.64145 39.26599  
4769 4769 2021-01-24 Placer 61 95602: Auburn 707   -121.09142 38.976837 178201
4770 4770 2021-01-24 Placer 61 95603: Auburn 1166   -121.07971 38.909605 272491
4771 4771 2021-01-24 Placer 61 95626: Elverta 20   -121.45433 38.727451 63584
4772 4772 2021-01-24 Placer 61 95631: Foresthill 163   -120.82172 39.033312 63892

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [latimes_place_totals] (
   [date] TEXT,
   [county] TEXT,
   [fips] INTEGER,
   [place] TEXT,
   [confirmed_cases] INTEGER,
   [note] TEXT,
   [x] TEXT,
   [y] TEXT,
   [population] TEXT
);