latimes_place_totals
Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals
110,660 rows where county = "San Diego" sorted by population
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note | population ▼ |
---|---|---|---|---|---|---|---|---|---|
3688 | 3688 | 91935 | 91935: Jamul | 2022-12-27 | San Diego | 73 | 2118 | 0 | |
3693 | 3693 | 91962 | 91962: Pine Valley | 2022-12-27 | San Diego | 73 | 366 | 0 | |
3694 | 3694 | 91963 | 91963: Potrero | 2022-12-27 | San Diego | 73 | 391 | 0 | |
3696 | 3696 | 91978 | 91978: Spring Valley | 2022-12-27 | San Diego | 73 | 2773 | 0 | |
3697 | 3697 | 91980 | 91980: Tecate | 2022-12-27 | San Diego | 73 | 287 | 0 | |
3698 | 3698 | 92003 | 92003: Bonsall | 2022-12-27 | San Diego | 73 | 1054 | 0 | |
3699 | 3699 | 92004 | 92004: Borrego Springs | 2022-12-27 | San Diego | 73 | 377 | 0 | |
3715 | 3715 | 92036 | 92036: Julian | 2022-12-27 | San Diego | 73 | 495 | 0 | |
3723 | 3723 | 92059 | 92059: Pala | 2022-12-27 | San Diego | 73 | 618 | 0 | |
3724 | 3724 | 92060 | 92060: Palomar Mountain | 2022-12-27 | San Diego | 73 | 102 | 0 | |
3725 | 3725 | 92061 | 92061: Pauma Valley | 2022-12-27 | San Diego | 73 | 727 | 0 | |
3728 | 3728 | 92066 | 92066: Ranchita | 2022-12-27 | San Diego | 73 | 48 | 0 | |
3729 | 3729 | 92067 | 92067: Rancho Santa Fe | 2022-12-27 | San Diego | 73 | 1868 | 0 | |
3731 | 3731 | 92070 | 92070: Santa Ysabel | 2022-12-27 | San Diego | 73 | 364 | 0 | |
3739 | 3739 | 92086 | 92086: Warner Springs | 2022-12-27 | San Diego | 73 | 170 | 0 | |
3740 | 3740 | 92091 | 92091: Rancho Santa Fe | 2022-12-27 | San Diego | 73 | 179 | 0 | |
3742 | 3742 | 92096 | 92096: San Marcos | 2022-12-27 | San Diego | 73 | 36 | 0 | |
3762 | 3762 | 92121 | 92121: San Diego | 2022-12-27 | San Diego | 73 | 1088 | 0 | |
3772 | 3772 | 92134 | 92134: San Diego | 2022-12-27 | San Diego | 73 | 136 | 0 | |
3773 | 3773 | 92135 | 92135: Coronado | 2022-12-27 | San Diego | 73 | 173 | 0 | |
3776 | 3776 | 92140 | 92140: San Diego | 2022-12-27 | San Diego | 73 | 213 | 0 | |
3777 | 3777 | 92145 | 92145: San Diego | 2022-12-27 | San Diego | 73 | 37 | 0 | |
3779 | 3779 | 92155 | 92155: Coronado | 2022-12-27 | San Diego | 73 | 94 | 0 | |
3781 | 3781 | 92182 | 92182: San Diego | 2022-12-27 | San Diego | 73 | 188 | 0 | |
3782 | 3782 | 92536 | 92536: Aguanga | 2022-12-27 | San Diego | 73 | 26 | 0 | |
3783 | 3783 | 92672 | 92672: San Clemente | 2022-12-27 | San Diego | 73 | 13 | 0 | |
3786 | 3786 | 91905 | 91905: Boulevard | 2022-12-27 | San Diego | 73 | 289 | 0 | |
3787 | 3787 | 91906 | 91906: Campo | 2022-12-27 | San Diego | 73 | 1015 | 0 | |
4864 | 4864 | 91916 | 91916: Descanso | 2022-12-26 | San Diego | 73 | 369 | 0 | |
4865 | 4865 | 91917 | 91917: Dulzura | 2022-12-26 | San Diego | 73 | 332 | 0 | |
4866 | 4866 | 91931 | 91931: Guatay | 2022-12-26 | San Diego | 73 | 48 | 0 | |
4868 | 4868 | 91934 | 91934: Jacumba | 2022-12-26 | San Diego | 73 | 116 | 0 | |
4869 | 4869 | 91935 | 91935: Jamul | 2022-12-26 | San Diego | 73 | 2118 | 0 | |
4874 | 4874 | 91962 | 91962: Pine Valley | 2022-12-26 | San Diego | 73 | 366 | 0 | |
4875 | 4875 | 91963 | 91963: Potrero | 2022-12-26 | San Diego | 73 | 391 | 0 | |
4877 | 4877 | 91978 | 91978: Spring Valley | 2022-12-26 | San Diego | 73 | 2773 | 0 | |
4878 | 4878 | 91980 | 91980: Tecate | 2022-12-26 | San Diego | 73 | 287 | 0 | |
4879 | 4879 | 92003 | 92003: Bonsall | 2022-12-26 | San Diego | 73 | 1054 | 0 | |
4880 | 4880 | 92004 | 92004: Borrego Springs | 2022-12-26 | San Diego | 73 | 377 | 0 | |
4896 | 4896 | 92036 | 92036: Julian | 2022-12-26 | San Diego | 73 | 495 | 0 | |
4904 | 4904 | 92059 | 92059: Pala | 2022-12-26 | San Diego | 73 | 618 | 0 | |
4905 | 4905 | 92060 | 92060: Palomar Mountain | 2022-12-26 | San Diego | 73 | 102 | 0 | |
4906 | 4906 | 92061 | 92061: Pauma Valley | 2022-12-26 | San Diego | 73 | 727 | 0 | |
4909 | 4909 | 92066 | 92066: Ranchita | 2022-12-26 | San Diego | 73 | 48 | 0 | |
4910 | 4910 | 92067 | 92067: Rancho Santa Fe | 2022-12-26 | San Diego | 73 | 1868 | 0 | |
4912 | 4912 | 92070 | 92070: Santa Ysabel | 2022-12-26 | San Diego | 73 | 364 | 0 | |
4920 | 4920 | 92086 | 92086: Warner Springs | 2022-12-26 | San Diego | 73 | 170 | 0 | |
4921 | 4921 | 92091 | 92091: Rancho Santa Fe | 2022-12-26 | San Diego | 73 | 179 | 0 | |
4923 | 4923 | 92096 | 92096: San Marcos | 2022-12-26 | San Diego | 73 | 36 | 0 | |
4943 | 4943 | 92121 | 92121: San Diego | 2022-12-26 | San Diego | 73 | 1088 | 0 | |
4953 | 4953 | 92134 | 92134: San Diego | 2022-12-26 | San Diego | 73 | 136 | 0 | |
4954 | 4954 | 92135 | 92135: Coronado | 2022-12-26 | San Diego | 73 | 173 | 0 | |
4957 | 4957 | 92140 | 92140: San Diego | 2022-12-26 | San Diego | 73 | 213 | 0 | |
4958 | 4958 | 92145 | 92145: San Diego | 2022-12-26 | San Diego | 73 | 37 | 0 | |
4960 | 4960 | 92155 | 92155: Coronado | 2022-12-26 | San Diego | 73 | 94 | 0 | |
4962 | 4962 | 92182 | 92182: San Diego | 2022-12-26 | San Diego | 73 | 188 | 0 | |
4963 | 4963 | 92536 | 92536: Aguanga | 2022-12-26 | San Diego | 73 | 26 | 0 | |
4964 | 4964 | 92672 | 92672: San Clemente | 2022-12-26 | San Diego | 73 | 13 | 0 | |
4967 | 4967 | 91905 | 91905: Boulevard | 2022-12-26 | San Diego | 73 | 289 | 0 | |
4968 | 4968 | 91906 | 91906: Campo | 2022-12-26 | San Diego | 73 | 1015 | 0 | |
6045 | 6045 | 91916 | 91916: Descanso | 2022-12-25 | San Diego | 73 | 369 | 0 | |
6046 | 6046 | 91917 | 91917: Dulzura | 2022-12-25 | San Diego | 73 | 332 | 0 | |
6047 | 6047 | 91931 | 91931: Guatay | 2022-12-25 | San Diego | 73 | 48 | 0 | |
6049 | 6049 | 91934 | 91934: Jacumba | 2022-12-25 | San Diego | 73 | 116 | 0 | |
6050 | 6050 | 91935 | 91935: Jamul | 2022-12-25 | San Diego | 73 | 2118 | 0 | |
6055 | 6055 | 91962 | 91962: Pine Valley | 2022-12-25 | San Diego | 73 | 366 | 0 | |
6056 | 6056 | 91963 | 91963: Potrero | 2022-12-25 | San Diego | 73 | 391 | 0 | |
6058 | 6058 | 91978 | 91978: Spring Valley | 2022-12-25 | San Diego | 73 | 2773 | 0 | |
6059 | 6059 | 91980 | 91980: Tecate | 2022-12-25 | San Diego | 73 | 287 | 0 | |
6060 | 6060 | 92003 | 92003: Bonsall | 2022-12-25 | San Diego | 73 | 1054 | 0 | |
6061 | 6061 | 92004 | 92004: Borrego Springs | 2022-12-25 | San Diego | 73 | 377 | 0 | |
6077 | 6077 | 92036 | 92036: Julian | 2022-12-25 | San Diego | 73 | 495 | 0 | |
6085 | 6085 | 92059 | 92059: Pala | 2022-12-25 | San Diego | 73 | 618 | 0 | |
6086 | 6086 | 92060 | 92060: Palomar Mountain | 2022-12-25 | San Diego | 73 | 102 | 0 | |
6087 | 6087 | 92061 | 92061: Pauma Valley | 2022-12-25 | San Diego | 73 | 727 | 0 | |
6090 | 6090 | 92066 | 92066: Ranchita | 2022-12-25 | San Diego | 73 | 48 | 0 | |
6091 | 6091 | 92067 | 92067: Rancho Santa Fe | 2022-12-25 | San Diego | 73 | 1868 | 0 | |
6093 | 6093 | 92070 | 92070: Santa Ysabel | 2022-12-25 | San Diego | 73 | 364 | 0 | |
6101 | 6101 | 92086 | 92086: Warner Springs | 2022-12-25 | San Diego | 73 | 170 | 0 | |
6102 | 6102 | 92091 | 92091: Rancho Santa Fe | 2022-12-25 | San Diego | 73 | 179 | 0 | |
6104 | 6104 | 92096 | 92096: San Marcos | 2022-12-25 | San Diego | 73 | 36 | 0 | |
6124 | 6124 | 92121 | 92121: San Diego | 2022-12-25 | San Diego | 73 | 1088 | 0 | |
6134 | 6134 | 92134 | 92134: San Diego | 2022-12-25 | San Diego | 73 | 136 | 0 | |
6135 | 6135 | 92135 | 92135: Coronado | 2022-12-25 | San Diego | 73 | 173 | 0 | |
6138 | 6138 | 92140 | 92140: San Diego | 2022-12-25 | San Diego | 73 | 213 | 0 | |
6139 | 6139 | 92145 | 92145: San Diego | 2022-12-25 | San Diego | 73 | 37 | 0 | |
6141 | 6141 | 92155 | 92155: Coronado | 2022-12-25 | San Diego | 73 | 94 | 0 | |
6143 | 6143 | 92182 | 92182: San Diego | 2022-12-25 | San Diego | 73 | 188 | 0 | |
6144 | 6144 | 92536 | 92536: Aguanga | 2022-12-25 | San Diego | 73 | 26 | 0 | |
6145 | 6145 | 92672 | 92672: San Clemente | 2022-12-25 | San Diego | 73 | 13 | 0 | |
6148 | 6148 | 91905 | 91905: Boulevard | 2022-12-25 | San Diego | 73 | 289 | 0 | |
6149 | 6149 | 91906 | 91906: Campo | 2022-12-25 | San Diego | 73 | 1015 | 0 | |
7226 | 7226 | 91916 | 91916: Descanso | 2022-12-24 | San Diego | 73 | 369 | 0 | |
7227 | 7227 | 91917 | 91917: Dulzura | 2022-12-24 | San Diego | 73 | 332 | 0 | |
7228 | 7228 | 91931 | 91931: Guatay | 2022-12-24 | San Diego | 73 | 48 | 0 | |
7230 | 7230 | 91934 | 91934: Jacumba | 2022-12-24 | San Diego | 73 | 116 | 0 | |
7231 | 7231 | 91935 | 91935: Jamul | 2022-12-24 | San Diego | 73 | 2118 | 0 | |
7236 | 7236 | 91962 | 91962: Pine Valley | 2022-12-24 | San Diego | 73 | 366 | 0 | |
7237 | 7237 | 91963 | 91963: Potrero | 2022-12-24 | San Diego | 73 | 391 | 0 | |
7239 | 7239 | 91978 | 91978: Spring Valley | 2022-12-24 | San Diego | 73 | 2773 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [latimes_place_totals] ( [id] TEXT, [name] TEXT, [date] TEXT, [county] TEXT, [fips] INTEGER, [confirmed_cases] INTEGER, [note] TEXT, [population] TEXT );