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

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

✎ View and edit SQL

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

fips

  • 61 · 2,904 ✖

county

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