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

41,470 rows where fips = 73 sorted by date descending

View and edit SQL

fips

  • 73 · 41,470

county

Link rowid id name date ▲ county fips confirmed_cases note population
974 92065 92065: Ramona 2021-04-10 San Diego 73 2469   36256
975 92066 92066: Ranchita 2021-04-10 San Diego 73 13   0
976 92067 92067: Rancho Santa Fe 2021-04-10 San Diego 73 380   0
977 92069 92069: San Marcos 2021-04-10 San Diego 73 4496   51172
978 92070 92070: Santa Ysabel 2021-04-10 San Diego 73 63   0
979 92071 92071: Santee 2021-04-10 San Diego 73 3762   58213
980 92075 92075: Solana Beach 2021-04-10 San Diego 73 489   12976
981 92078 92078: San Marcos 2021-04-10 San Diego 73 3138   50973
982 92081 92081: Vista 2021-04-10 San Diego 73 1854   32889
983 92082 92082: Valley Center 2021-04-10 San Diego 73 1455   17680
984 92083 92083: Vista 2021-04-10 San Diego 73 4448   39155
985 92084 92084: Vista 2021-04-10 San Diego 73 4863   49040
986 92086 92086: Warner Springs 2021-04-10 San Diego 73 57   0
987 92091 92091: Rancho Santa Fe 2021-04-10 San Diego 73 35   0
988 92093 92093: La Jolla 2021-04-10 San Diego 73 179   11299
989 92096 92096: San Marcos 2021-04-10 San Diego 73 5   0
990 92101 92101: San Diego 2021-04-10 San Diego 73 3880   60694
991 92102 92102: San Diego 2021-04-10 San Diego 73 4353   42331
992 92103 92103: San Diego 2021-04-10 San Diego 73 1759   39687
993 92104 92104: San Diego 2021-04-10 San Diego 73 2765   52095
994 92105 92105: San Diego 2021-04-10 San Diego 73 7066   67077
995 92106 92106: San Diego 2021-04-10 San Diego 73 791   22209
996 92107 92107: San Diego 2021-04-10 San Diego 73 1159   30971
997 92108 92108: San Diego 2021-04-10 San Diego 73 1559   27342
998 92109 92109: San Diego 2021-04-10 San Diego 73 3039   54115
999 92110 92110: San Diego 2021-04-10 San Diego 73 1894   29878
1000 92111 92111: San Diego 2021-04-10 San Diego 73 2916   47943
1001 92113 92113: San Diego 2021-04-10 San Diego 73 7165   48550
1002 92114 92114: San Diego 2021-04-10 San Diego 73 7107   58032
1003 92115 92115: San Diego 2021-04-10 San Diego 73 5768   61463
1004 92116 92116: San Diego 2021-04-10 San Diego 73 1615   36946
1005 92117 92117: San Diego 2021-04-10 San Diego 73 2848   52122
1006 92118 92118: Coronado 2021-04-10 San Diego 73 675   17956
1007 92119 92119: San Diego 2021-04-10 San Diego 73 1188   23730
1008 92120 92120: San Diego 2021-04-10 San Diego 73 1656   29448
1009 92121 92121: San Diego 2021-04-10 San Diego 73 188   0
1010 92122 92122: San Diego 2021-04-10 San Diego 73 1358   48952
1011 92123 92123: San Diego 2021-04-10 San Diego 73 2069   33643
1012 92124 92124: San Diego 2021-04-10 San Diego 73 1228   31705
1013 92126 92126: San Diego 2021-04-10 San Diego 73 4027   76748
1014 92127 92127: San Diego 2021-04-10 San Diego 73 1657   49508
1015 92128 92128: San Diego 2021-04-10 San Diego 73 2022   51732
1016 92129 92129: San Diego 2021-04-10 San Diego 73 1963   52624
1017 92130 92130: San Diego 2021-04-10 San Diego 73 1682   59593
1018 92131 92131: San Diego 2021-04-10 San Diego 73 1244   36090
1019 92134 92134: San Diego 2021-04-10 San Diego 73 45   0
1020 92135 92135: Coronado 2021-04-10 San Diego 73 86   0
1021 92136 92136: San Diego 2021-04-10 San Diego 73 231   12492
1022 92139 92139: San Diego 2021-04-10 San Diego 73 3469   33271
1023 92140 92140: San Diego 2021-04-10 San Diego 73 117   0
1024 92145 92145: San Diego 2021-04-10 San Diego 73 13   0
1025 92154 92154: San Diego 2021-04-10 San Diego 73 13576   79997
1026 92155 92155: Coronado 2021-04-10 San Diego 73 21   0
1027 92173 92173: San Ysidro 2021-04-10 San Diego 73 6209   27097
1028 92182 92182: San Diego 2021-04-10 San Diego 73 28   0
1029 92536 92536: Aguanga 2021-04-10 San Diego 73 6   0
1030 92672 92672: San Clemente 2021-04-10 San Diego 73 15   0
1031 91901 91901: Alpine 2021-04-10 San Diego 73 1271   17985
1032 91902 91902: Bonita 2021-04-10 San Diego 73 1339   17631
1033 91905 91905: Boulevard 2021-04-10 San Diego 73 70   0
1034 91906 91906: Campo 2021-04-10 San Diego 73 287   0
1035 91910 91910: Chula Vista 2021-04-10 San Diego 73 8937   83834
1036 91911 91911: Chula Vista 2021-04-10 San Diego 73 10879   84819
1037 91913 91913: Chula Vista 2021-04-10 San Diego 73 4623   51077
1038 91914 91914: Chula Vista 2021-04-10 San Diego 73 1400   16781
1039 91915 91915: Chula Vista 2021-04-10 San Diego 73 2737   31120
1040 91916 91916: Descanso 2021-04-10 San Diego 73 88   0
1041 91917 91917: Dulzura 2021-04-10 San Diego 73 184   0
1042 91931 91931: Guatay 2021-04-10 San Diego 73 12   0
1043 91932 91932: Imperial Beach 2021-04-10 San Diego 73 2536   27448
1044 91934 91934: Jacumba 2021-04-10 San Diego 73 35   0
1045 91935 91935: Jamul 2021-04-10 San Diego 73 679   0
1046 91941 91941: La Mesa 2021-04-10 San Diego 73 2229   34226
1047 91942 91942: La Mesa 2021-04-10 San Diego 73 2439   40025
1048 91945 91945: Lemon Grove 2021-04-10 San Diego 73 2811   27208
1049 91950 91950: National City 2021-04-10 San Diego 73 7533   58536
1050 91962 91962: Pine Valley 2021-04-10 San Diego 73 104   0
1051 91963 91963: Potrero 2021-04-10 San Diego 73 194   0
1052 91977 91977: Spring Valley 2021-04-10 San Diego 73 6657   60995
1053 91978 91978: Spring Valley 2021-04-10 San Diego 73 822   0
1054 91980 91980: Tecate 2021-04-10 San Diego 73 171   0
1055 92003 92003: Bonsall 2021-04-10 San Diego 73 274   0
1056 92004 92004: Borrego Springs 2021-04-10 San Diego 73 133   0
1057 92007 92007: Cardiff by the Sea 2021-04-10 San Diego 73 413   11483
1058 92008 92008: Carlsbad 2021-04-10 San Diego 73 1324   29652
1059 92009 92009: Carlsbad 2021-04-10 San Diego 73 1741   43338
1060 92010 92010: Carlsbad 2021-04-10 San Diego 73 760   16681
1061 92011 92011: Carlsbad 2021-04-10 San Diego 73 847   23963
1062 92014 92014: Del Mar 2021-04-10 San Diego 73 442   14139
1063 92019 92019: El Cajon 2021-04-10 San Diego 73 4367   45094
1064 92020 92020: El Cajon 2021-04-10 San Diego 73 6733   61896
1065 92021 92021: El Cajon 2021-04-10 San Diego 73 6977   68655
1066 92024 92024: Encinitas 2021-04-10 San Diego 73 2369   56390
1067 92025 92025: Escondido 2021-04-10 San Diego 73 5270   51820
1068 92026 92026: Escondido 2021-04-10 San Diego 73 4814   56272
1069 92027 92027: Escondido 2021-04-10 San Diego 73 6067   54202
1070 92028 92028: Fallbrook 2021-04-10 San Diego 73 3765   49009
1071 92029 92029: Escondido 2021-04-10 San Diego 73 1333   21201
1072 92036 92036: Julian 2021-04-10 San Diego 73 109   0
1073 92037 92037: La Jolla 2021-04-10 San Diego 73 1513   43283

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