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

2,904 rows where fips = 61 sorted by date descending

View and edit SQL

fips

  • 61 · 2,904

county

Link rowid date ▲ county fips place confirmed_cases note x y population
765 2021-01-14 Placer 61 95602: Auburn 660   -121.09142 38.976837 178201
766 2021-01-14 Placer 61 95603: Auburn 1097   -121.07971 38.909605 272491
767 2021-01-14 Placer 61 95626: Elverta 18   -121.45433 38.727451 63584
768 2021-01-14 Placer 61 95631: Foresthill 144   -120.82172 39.033312 63892
769 2021-01-14 Placer 61 95648: Lincoln 2255   -121.29795 38.902873 512543
770 2021-01-14 Placer 61 95650: Loomis 492   -121.17225 38.817508 129856
771 2021-01-14 Placer 61 95658: Newcastle 205   -121.14213 38.87672 67508
772 2021-01-14 Placer 61 95661: Roseville 1575   -121.2531 38.731976 304680
773 2021-01-14 Placer 61 95663: Penryn 101   -121.17565 38.859227 21024
774 2021-01-14 Placer 61 95677: Rocklin 1079   -121.23825 38.789165 231212
775 2021-01-14 Placer 61 95678: Roseville 2044   -121.28933 38.752434 412235
776 2021-01-14 Placer 61 95681: Sheridan 58   -121.37967 38.997612 12411
777 2021-01-14 Placer 61 95701: Alta 19   -120.78346 39.217668 8419
778 2021-01-14 Placer 61 95703: Applegate 53   -120.99703 38.995732 30240
779 2021-01-14 Placer 61 95713: Colfax 181   -120.93471 39.092062 89224
780 2021-01-14 Placer 61 95714: Dutch Flat 5 5 or fewer -120.83816 39.204434  
781 2021-01-14 Placer 61 95715: Emigrant Gap 5 5 or fewer -120.7067 39.277658  
782 2021-01-14 Placer 61 95717: Gold Run 5 5 or fewer -120.8451 39.177026  
783 2021-01-14 Placer 61 95722: Meadow Vista 149   -121.01891 39.005098 49339
784 2021-01-14 Placer 61 95724: Norden 5 5 or fewer -120.64145 39.26599  
785 2021-01-14 Placer 61 95746: Granite Bay 663   -121.19013 38.743811 217786
786 2021-01-14 Placer 61 95747: Roseville 2882   -121.33629 38.768829 597255
787 2021-01-14 Placer 61 95765: Rocklin 1686   -121.2631 38.817993 370093
788 2021-01-14 Placer 61 96140: Carnelian Bay 42   -120.08627 39.223151 16588
789 2021-01-14 Placer 61 96141: Homewood 6   -120.16325 39.093271  
790 2021-01-14 Placer 61 96142: Tahoma 5 5 or fewer -120.12438 39.037696  
791 2021-01-14 Placer 61 96143: Kings Beach 269   -120.02809 39.241961 39882
792 2021-01-14 Placer 61 96145: Tahoe City 124   -120.14607 39.177383 30334
793 2021-01-14 Placer 61 96146: Olympic Valley 46   -120.21804 39.180983 13258
794 2021-01-14 Placer 61 96148: Tahoe Vista 41   -120.05437 39.243877 14501
795 2021-01-14 Placer 61 96161: Truckee 63   -120.22805 39.339574 185771
796 2021-01-14 Placer 61 96162: Truckee 5 5 or fewer -120.64145 39.26599  
2094 2021-01-13 Placer 61 95602: Auburn 660   -121.09142 38.976837 178201
2095 2021-01-13 Placer 61 95603: Auburn 1097   -121.07971 38.909605 272491
2096 2021-01-13 Placer 61 95626: Elverta 18   -121.45433 38.727451 63584
2097 2021-01-13 Placer 61 95631: Foresthill 144   -120.82172 39.033312 63892
2098 2021-01-13 Placer 61 95648: Lincoln 2255   -121.29795 38.902873 512543
2099 2021-01-13 Placer 61 95650: Loomis 492   -121.17225 38.817508 129856
2100 2021-01-13 Placer 61 95658: Newcastle 205   -121.14213 38.87672 67508
2101 2021-01-13 Placer 61 95661: Roseville 1575   -121.2531 38.731976 304680
2102 2021-01-13 Placer 61 95663: Penryn 101   -121.17565 38.859227 21024
2103 2021-01-13 Placer 61 95677: Rocklin 1079   -121.23825 38.789165 231212
2104 2021-01-13 Placer 61 95678: Roseville 2044   -121.28933 38.752434 412235
2105 2021-01-13 Placer 61 95681: Sheridan 58   -121.37967 38.997612 12411
2106 2021-01-13 Placer 61 95701: Alta 19   -120.78346 39.217668 8419
2107 2021-01-13 Placer 61 95703: Applegate 53   -120.99703 38.995732 30240
2108 2021-01-13 Placer 61 95713: Colfax 181   -120.93471 39.092062 89224
2109 2021-01-13 Placer 61 95714: Dutch Flat 5 5 or fewer -120.83816 39.204434  
2110 2021-01-13 Placer 61 95715: Emigrant Gap 5 5 or fewer -120.7067 39.277658  
2111 2021-01-13 Placer 61 95717: Gold Run 5 5 or fewer -120.8451 39.177026  
2112 2021-01-13 Placer 61 95722: Meadow Vista 149   -121.01891 39.005098 49339
2113 2021-01-13 Placer 61 95724: Norden 5 5 or fewer -120.64145 39.26599  
2114 2021-01-13 Placer 61 95746: Granite Bay 663   -121.19013 38.743811 217786
2115 2021-01-13 Placer 61 95747: Roseville 2882   -121.33629 38.768829 597255
2116 2021-01-13 Placer 61 95765: Rocklin 1686   -121.2631 38.817993 370093
2117 2021-01-13 Placer 61 96140: Carnelian Bay 42   -120.08627 39.223151 16588
2118 2021-01-13 Placer 61 96141: Homewood 6   -120.16325 39.093271  
2119 2021-01-13 Placer 61 96142: Tahoma 5 5 or fewer -120.12438 39.037696  
2120 2021-01-13 Placer 61 96143: Kings Beach 269   -120.02809 39.241961 39882
2121 2021-01-13 Placer 61 96145: Tahoe City 124   -120.14607 39.177383 30334
2122 2021-01-13 Placer 61 96146: Olympic Valley 46   -120.21804 39.180983 13258
2123 2021-01-13 Placer 61 96148: Tahoe Vista 41   -120.05437 39.243877 14501
2124 2021-01-13 Placer 61 96161: Truckee 63   -120.22805 39.339574 185771
2125 2021-01-13 Placer 61 96162: Truckee 5 5 or fewer -120.64145 39.26599  
3440 2021-01-12 Placer 61 95602: Auburn 655   -121.09142 38.976837 178201
3441 2021-01-12 Placer 61 95603: Auburn 1087   -121.07971 38.909605 272491
3442 2021-01-12 Placer 61 95626: Elverta 18   -121.45433 38.727451 63584
3443 2021-01-12 Placer 61 95631: Foresthill 141   -120.82172 39.033312 63892
3444 2021-01-12 Placer 61 95648: Lincoln 2230   -121.29795 38.902873 512543
3445 2021-01-12 Placer 61 95650: Loomis 480   -121.17225 38.817508 129856
3446 2021-01-12 Placer 61 95658: Newcastle 203   -121.14213 38.87672 67508
3447 2021-01-12 Placer 61 95661: Roseville 1558   -121.2531 38.731976 304680
3448 2021-01-12 Placer 61 95663: Penryn 99   -121.17565 38.859227 21024
3449 2021-01-12 Placer 61 95677: Rocklin 1067   -121.23825 38.789165 231212
3450 2021-01-12 Placer 61 95678: Roseville 2024   -121.28933 38.752434 412235
3451 2021-01-12 Placer 61 95681: Sheridan 57   -121.37967 38.997612 12411
3452 2021-01-12 Placer 61 95701: Alta 19   -120.78346 39.217668 8419
3453 2021-01-12 Placer 61 95703: Applegate 52   -120.99703 38.995732 30240
3454 2021-01-12 Placer 61 95713: Colfax 179   -120.93471 39.092062 89224
3455 2021-01-12 Placer 61 95714: Dutch Flat 5 5 or fewer -120.83816 39.204434  
3456 2021-01-12 Placer 61 95715: Emigrant Gap 5 5 or fewer -120.7067 39.277658  
3457 2021-01-12 Placer 61 95717: Gold Run 5 5 or fewer -120.8451 39.177026  
3458 2021-01-12 Placer 61 95722: Meadow Vista 149   -121.01891 39.005098 49339
3459 2021-01-12 Placer 61 95724: Norden 5 5 or fewer -120.64145 39.26599  
3460 2021-01-12 Placer 61 95746: Granite Bay 656   -121.19013 38.743811 217786
3461 2021-01-12 Placer 61 95747: Roseville 2849   -121.33629 38.768829 597255
3462 2021-01-12 Placer 61 95765: Rocklin 1663   -121.2631 38.817993 370093
3463 2021-01-12 Placer 61 96140: Carnelian Bay 42   -120.08627 39.223151 16588
3464 2021-01-12 Placer 61 96141: Homewood 6   -120.16325 39.093271  
3465 2021-01-12 Placer 61 96142: Tahoma 5 5 or fewer -120.12438 39.037696  
3466 2021-01-12 Placer 61 96143: Kings Beach 267   -120.02809 39.241961 39882
3467 2021-01-12 Placer 61 96145: Tahoe City 124   -120.14607 39.177383 30334
3468 2021-01-12 Placer 61 96146: Olympic Valley 45   -120.21804 39.180983 13258
3469 2021-01-12 Placer 61 96148: Tahoe Vista 41   -120.05437 39.243877 14501
3470 2021-01-12 Placer 61 96161: Truckee 63   -120.22805 39.339574 185771
3471 2021-01-12 Placer 61 96162: Truckee 5 5 or fewer -120.64145 39.26599  
4774 2021-01-11 Placer 61 95602: Auburn 649   -121.09142 38.976837 178201
4775 2021-01-11 Placer 61 95603: Auburn 1075   -121.07971 38.909605 272491
4776 2021-01-11 Placer 61 95626: Elverta 19   -121.45433 38.727451 63584
4777 2021-01-11 Placer 61 95631: Foresthill 138   -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
);