home / covid

Menu
  • GraphQL API

latimes_place_totals

Table actions
  • GraphQL API for latimes_place_totals
⚠️ 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

96,030 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 1

  • 73 96,030

county 1

  • San Diego · 96,030 ✖
Link rowid id name date ▲ county fips confirmed_cases note population
898 898 91978 91978: Spring Valley 2022-08-19 San Diego 73 2618   0
899 899 91980 91980: Tecate 2022-08-19 San Diego 73 274   0
900 900 92003 92003: Bonsall 2022-08-19 San Diego 73 984   0
901 901 92004 92004: Borrego Springs 2022-08-19 San Diego 73 353   0
902 902 92007 92007: Cardiff by the Sea 2022-08-19 San Diego 73 1798   11483
903 903 92008 92008: Carlsbad 2022-08-19 San Diego 73 5550   29652
904 904 92009 92009: Carlsbad 2022-08-19 San Diego 73 7806   43338
905 905 92010 92010: Carlsbad 2022-08-19 San Diego 73 3626   16681
906 906 92011 92011: Carlsbad 2022-08-19 San Diego 73 4008   23963
907 907 92014 92014: Del Mar 2022-08-19 San Diego 73 2011   14139
908 908 92019 92019: El Cajon 2022-08-19 San Diego 73 12185   45094
909 909 92020 92020: El Cajon 2022-08-19 San Diego 73 18098   61896
910 910 92021 92021: El Cajon 2022-08-19 San Diego 73 19794   68655
911 911 92024 92024: Encinitas 2022-08-19 San Diego 73 9801   56390
912 912 92025 92025: Escondido 2022-08-19 San Diego 73 14390   51820
913 913 92026 92026: Escondido 2022-08-19 San Diego 73 14224   56272
914 914 92027 92027: Escondido 2022-08-19 San Diego 73 16550   54202
915 915 92028 92028: Fallbrook 2022-08-19 San Diego 73 10595   49009
916 916 92029 92029: Escondido 2022-08-19 San Diego 73 4692   21201
917 917 92036 92036: Julian 2022-08-19 San Diego 73 463   0
918 918 92037 92037: La Jolla 2022-08-19 San Diego 73 7513   43283
919 919 92040 92040: Lakeside 2022-08-19 San Diego 73 11028   44105
920 920 92054 92054: Oceanside 2022-08-19 San Diego 73 9000   42441
921 921 92055 92055: Camp Pendleton 2022-08-19 San Diego 73 1884   36726
922 922 92056 92056: Oceanside 2022-08-19 San Diego 73 12811   55369
923 923 92057 92057: Oceanside 2022-08-19 San Diego 73 14830   55753
924 924 92058 92058: Oceanside 2022-08-19 San Diego 73 9515   24170
925 925 92059 92059: Pala 2022-08-19 San Diego 73 581   0
926 926 92060 92060: Palomar Mountain 2022-08-19 San Diego 73 98   0
927 927 92061 92061: Pauma Valley 2022-08-19 San Diego 73 683   0
928 928 92064 92064: Poway 2022-08-19 San Diego 73 10020   50435
929 929 92065 92065: Ramona 2022-08-19 San Diego 73 8080   36256
930 930 92066 92066: Ranchita 2022-08-19 San Diego 73 46   0
931 931 92067 92067: Rancho Santa Fe 2022-08-19 San Diego 73 1733   0
932 932 92069 92069: San Marcos 2022-08-19 San Diego 73 14101   51172
933 933 92070 92070: Santa Ysabel 2022-08-19 San Diego 73 343   0
934 934 92071 92071: Santee 2022-08-19 San Diego 73 14276   58213
935 935 92075 92075: Solana Beach 2022-08-19 San Diego 73 1897   12976
936 936 92078 92078: San Marcos 2022-08-19 San Diego 73 11222   50973
937 937 92081 92081: Vista 2022-08-19 San Diego 73 6806   32889
938 938 92082 92082: Valley Center 2022-08-19 San Diego 73 4843   17680
939 939 92083 92083: Vista 2022-08-19 San Diego 73 13357   39155
940 940 92084 92084: Vista 2022-08-19 San Diego 73 14310   49040
941 941 92086 92086: Warner Springs 2022-08-19 San Diego 73 156   0
942 942 92091 92091: Rancho Santa Fe 2022-08-19 San Diego 73 158   0
943 943 92093 92093: La Jolla 2022-08-19 San Diego 73 3595   11299
944 944 92096 92096: San Marcos 2022-08-19 San Diego 73 36   0
945 945 92101 92101: San Diego 2022-08-19 San Diego 73 12960   60694
946 946 92102 92102: San Diego 2022-08-19 San Diego 73 13608   42331
947 947 92103 92103: San Diego 2022-08-19 San Diego 73 7426   39687
948 948 92104 92104: San Diego 2022-08-19 San Diego 73 10818   52095
949 949 92105 92105: San Diego 2022-08-19 San Diego 73 20652   67077
950 950 92106 92106: San Diego 2022-08-19 San Diego 73 3699   22209
951 951 92107 92107: San Diego 2022-08-19 San Diego 73 5198   30971
952 952 92108 92108: San Diego 2022-08-19 San Diego 73 6914   27342
953 953 92109 92109: San Diego 2022-08-19 San Diego 73 10299   54115
954 954 92110 92110: San Diego 2022-08-19 San Diego 73 7388   29878
955 955 92111 92111: San Diego 2022-08-19 San Diego 73 10985   47943
956 956 92113 92113: San Diego 2022-08-19 San Diego 73 19425   48550
957 957 92114 92114: San Diego 2022-08-19 San Diego 73 23242   58032
958 958 92115 92115: San Diego 2022-08-19 San Diego 73 17026   61463
959 959 92116 92116: San Diego 2022-08-19 San Diego 73 6633   36946
960 960 92117 92117: San Diego 2022-08-19 San Diego 73 10994   52122
961 961 92118 92118: Coronado 2022-08-19 San Diego 73 3036   17956
962 962 92119 92119: San Diego 2022-08-19 San Diego 73 5066   23730
963 963 92120 92120: San Diego 2022-08-19 San Diego 73 6868   29448
964 964 92121 92121: San Diego 2022-08-19 San Diego 73 1002   0
965 965 92122 92122: San Diego 2022-08-19 San Diego 73 7783   48952
966 966 92123 92123: San Diego 2022-08-19 San Diego 73 7695   33643
967 967 92124 92124: San Diego 2022-08-19 San Diego 73 6160   31705
968 968 92126 92126: San Diego 2022-08-19 San Diego 73 17429   76748
969 969 92127 92127: San Diego 2022-08-19 San Diego 73 9961   49508
970 970 92128 92128: San Diego 2022-08-19 San Diego 73 9431   51732
971 971 92129 92129: San Diego 2022-08-19 San Diego 73 10765   52624
972 972 92130 92130: San Diego 2022-08-19 San Diego 73 9792   59593
973 973 92131 92131: San Diego 2022-08-19 San Diego 73 6224   36090
974 974 92134 92134: San Diego 2022-08-19 San Diego 73 125   0
975 975 92135 92135: Coronado 2022-08-19 San Diego 73 160   0
976 976 92136 92136: San Diego 2022-08-19 San Diego 73 422   12492
977 977 92139 92139: San Diego 2022-08-19 San Diego 73 11287   33271
978 978 92140 92140: San Diego 2022-08-19 San Diego 73 200   0
979 979 92145 92145: San Diego 2022-08-19 San Diego 73 39   0
980 980 92154 92154: San Diego 2022-08-19 San Diego 73 36386   79997
981 981 92155 92155: Coronado 2022-08-19 San Diego 73 92   0
982 982 92173 92173: San Ysidro 2022-08-19 San Diego 73 15150   27097
983 983 92182 92182: San Diego 2022-08-19 San Diego 73 164   0
984 984 92536 92536: Aguanga 2022-08-19 San Diego 73 22   0
985 985 92672 92672: San Clemente 2022-08-19 San Diego 73 19   0
986 986 91901 91901: Alpine 2022-08-19 San Diego 73 4097   17985
987 987 91902 91902: Bonita 2022-08-19 San Diego 73 4702   17631
988 988 91905 91905: Boulevard 2022-08-19 San Diego 73 275   0
989 989 91906 91906: Campo 2022-08-19 San Diego 73 965   0
990 990 91910 91910: Chula Vista 2022-08-19 San Diego 73 27250   83834
991 991 91911 91911: Chula Vista 2022-08-19 San Diego 73 31445   84819
992 992 91913 91913: Chula Vista 2022-08-19 San Diego 73 17973   51077
993 993 91914 91914: Chula Vista 2022-08-19 San Diego 73 5079   16781
994 994 91915 91915: Chula Vista 2022-08-19 San Diego 73 10302   31120
995 995 91916 91916: Descanso 2022-08-19 San Diego 73 347   0
996 996 91917 91917: Dulzura 2022-08-19 San Diego 73 310   0
997 997 91931 91931: Guatay 2022-08-19 San Diego 73 47   0

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
);
Powered by Datasette · Queries took 1249.179ms · Data license: Reusing the data · Data source: The Los Angeles Times · About: Data dictionary for latimes_place_totals