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

63,470 rows where county = "San Diego" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 73 63,470

county

  • San Diego · 63,470 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
975 975 92029 92029: Escondido 2021-10-27 San Diego 73 1833   21201
976 976 92036 92036: Julian 2021-10-27 San Diego 73 189   0
977 977 92037 92037: La Jolla 2021-10-27 San Diego 73 2244   43283
978 978 92040 92040: Lakeside 2021-10-27 San Diego 73 4882   44105
979 979 92054 92054: Oceanside 2021-10-27 San Diego 73 3903   42441
980 980 92055 92055: Camp Pendleton 2021-10-27 San Diego 73 972   36726
981 981 92056 92056: Oceanside 2021-10-27 San Diego 73 5056   55369
982 982 92057 92057: Oceanside 2021-10-27 San Diego 73 6095   55753
983 983 92058 92058: Oceanside 2021-10-27 San Diego 73 3613   24170
984 984 92059 92059: Pala 2021-10-27 San Diego 73 315   0
985 985 92060 92060: Palomar Mountain 2021-10-27 San Diego 73 36   0
986 986 92061 92061: Pauma Valley 2021-10-27 San Diego 73 307   0
987 987 92064 92064: Poway 2021-10-27 San Diego 73 3508   50435
988 988 92065 92065: Ramona 2021-10-27 San Diego 73 3946   36256
989 989 92066 92066: Ranchita 2021-10-27 San Diego 73 17   0
990 990 92067 92067: Rancho Santa Fe 2021-10-27 San Diego 73 609   0
991 991 92069 92069: San Marcos 2021-10-27 San Diego 73 5956   51172
992 992 92070 92070: Santa Ysabel 2021-10-27 San Diego 73 109   0
993 993 92071 92071: Santee 2021-10-27 San Diego 73 5865   58213
994 994 92075 92075: Solana Beach 2021-10-27 San Diego 73 709   12976
995 995 92078 92078: San Marcos 2021-10-27 San Diego 73 4292   50973
996 996 92081 92081: Vista 2021-10-27 San Diego 73 2592   32889
997 997 92082 92082: Valley Center 2021-10-27 San Diego 73 2244   17680
998 998 92083 92083: Vista 2021-10-27 San Diego 73 5841   39155
999 999 92084 92084: Vista 2021-10-27 San Diego 73 6450   49040
1000 1000 92086 92086: Warner Springs 2021-10-27 San Diego 73 72   0
1001 1001 92091 92091: Rancho Santa Fe 2021-10-27 San Diego 73 50   0
1002 1002 92093 92093: La Jolla 2021-10-27 San Diego 73 244   11299
1003 1003 92096 92096: San Marcos 2021-10-27 San Diego 73 7   0
1004 1004 92101 92101: San Diego 2021-10-27 San Diego 73 5359   60694
1005 1005 92102 92102: San Diego 2021-10-27 San Diego 73 5824   42331
1006 1006 92103 92103: San Diego 2021-10-27 San Diego 73 2666   39687
1007 1007 92104 92104: San Diego 2021-10-27 San Diego 73 4087   52095
1008 1008 92105 92105: San Diego 2021-10-27 San Diego 73 9166   67077
1009 1009 92106 92106: San Diego 2021-10-27 San Diego 73 1342   22209
1010 1010 92107 92107: San Diego 2021-10-27 San Diego 73 1998   30971
1011 1011 92108 92108: San Diego 2021-10-27 San Diego 73 2269   27342
1012 1012 92109 92109: San Diego 2021-10-27 San Diego 73 4691   54115
1013 1013 92110 92110: San Diego 2021-10-27 San Diego 73 2795   29878
1014 1014 92111 92111: San Diego 2021-10-27 San Diego 73 4106   47943
1015 1015 92113 92113: San Diego 2021-10-27 San Diego 73 9136   48550
1016 1016 92114 92114: San Diego 2021-10-27 San Diego 73 9407   58032
1017 1017 92115 92115: San Diego 2021-10-27 San Diego 73 7567   61463
1018 1018 92116 92116: San Diego 2021-10-27 San Diego 73 2380   36946
1019 1019 92117 92117: San Diego 2021-10-27 San Diego 73 4136   52122
1020 1020 92118 92118: Coronado 2021-10-27 San Diego 73 1090   17956
1021 1021 92119 92119: San Diego 2021-10-27 San Diego 73 1860   23730
1022 1022 92120 92120: San Diego 2021-10-27 San Diego 73 2503   29448
1023 1023 92121 92121: San Diego 2021-10-27 San Diego 73 287   0
1024 1024 92122 92122: San Diego 2021-10-27 San Diego 73 2161   48952
1025 1025 92123 92123: San Diego 2021-10-27 San Diego 73 2938   33643
1026 1026 92124 92124: San Diego 2021-10-27 San Diego 73 1907   31705
1027 1027 92126 92126: San Diego 2021-10-27 San Diego 73 5511   76748
1028 1028 92127 92127: San Diego 2021-10-27 San Diego 73 2531   49508
1029 1029 92128 92128: San Diego 2021-10-27 San Diego 73 2936   51732
1030 1030 92129 92129: San Diego 2021-10-27 San Diego 73 2877   52624
1031 1031 92130 92130: San Diego 2021-10-27 San Diego 73 2682   59593
1032 1032 92131 92131: San Diego 2021-10-27 San Diego 73 1850   36090
1033 1033 92134 92134: San Diego 2021-10-27 San Diego 73 47   0
1034 1034 92135 92135: Coronado 2021-10-27 San Diego 73 105   0
1035 1035 92136 92136: San Diego 2021-10-27 San Diego 73 288   12492
1036 1036 92139 92139: San Diego 2021-10-27 San Diego 73 4537   33271
1037 1037 92140 92140: San Diego 2021-10-27 San Diego 73 137   0
1038 1038 92145 92145: San Diego 2021-10-27 San Diego 73 16   0
1039 1039 92154 92154: San Diego 2021-10-27 San Diego 73 16535   79997
1040 1040 92155 92155: Coronado 2021-10-27 San Diego 73 40   0
1041 1041 92173 92173: San Ysidro 2021-10-27 San Diego 73 7258   27097
1042 1042 92182 92182: San Diego 2021-10-27 San Diego 73 39   0
1043 1043 92536 92536: Aguanga 2021-10-27 San Diego 73 8   0
1044 1044 92672 92672: San Clemente 2021-10-27 San Diego 73 4   0
1045 1045 91901 91901: Alpine 2021-10-27 San Diego 73 1940   17985
1046 1046 91902 91902: Bonita 2021-10-27 San Diego 73 1850   17631
1047 1047 91905 91905: Boulevard 2021-10-27 San Diego 73 100   0
1048 1048 91906 91906: Campo 2021-10-27 San Diego 73 446   0
1049 1049 91910 91910: Chula Vista 2021-10-27 San Diego 73 11349   83834
1050 1050 91911 91911: Chula Vista 2021-10-27 San Diego 73 13531   84819
1051 1051 91913 91913: Chula Vista 2021-10-27 San Diego 73 6233   51077
1052 1052 91914 91914: Chula Vista 2021-10-27 San Diego 73 1856   16781
1053 1053 91915 91915: Chula Vista 2021-10-27 San Diego 73 3630   31120
1054 1054 91916 91916: Descanso 2021-10-27 San Diego 73 147   0
1055 1055 91917 91917: Dulzura 2021-10-27 San Diego 73 194   0
1056 1056 91931 91931: Guatay 2021-10-27 San Diego 73 22   0
1057 1057 91932 91932: Imperial Beach 2021-10-27 San Diego 73 3338   27448
1058 1058 91934 91934: Jacumba 2021-10-27 San Diego 73 50   0
1059 1059 91935 91935: Jamul 2021-10-27 San Diego 73 959   0
1060 1060 91941 91941: La Mesa 2021-10-27 San Diego 73 3362   34226
1061 1061 91942 91942: La Mesa 2021-10-27 San Diego 73 3590   40025
1062 1062 91945 91945: Lemon Grove 2021-10-27 San Diego 73 3915   27208
1063 1063 91950 91950: National City 2021-10-27 San Diego 73 9485   58536
1064 1064 91962 91962: Pine Valley 2021-10-27 San Diego 73 158   0
1065 1065 91963 91963: Potrero 2021-10-27 San Diego 73 218   0
1066 1066 91977 91977: Spring Valley 2021-10-27 San Diego 73 8871   60995
1067 1067 91978 91978: Spring Valley 2021-10-27 San Diego 73 1165   0
1068 1068 91980 91980: Tecate 2021-10-27 San Diego 73 180   0
1069 1069 92003 92003: Bonsall 2021-10-27 San Diego 73 405   0
1070 1070 92004 92004: Borrego Springs 2021-10-27 San Diego 73 160   0
1071 1071 92007 92007: Cardiff by the Sea 2021-10-27 San Diego 73 628   11483
1072 1072 92008 92008: Carlsbad 2021-10-27 San Diego 73 2025   29652
1073 1073 92009 92009: Carlsbad 2021-10-27 San Diego 73 2634   43338
1074 1074 92010 92010: Carlsbad 2021-10-27 San Diego 73 1194   16681

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
);