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

6,571 rows where county = "Kern" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips

  • 29 6,571

county

  • Kern · 6,571 ✖
Link rowid date ▲ county fips place confirmed_cases note x y
1079 1079 2020-10-22 Kern 29 93203: Arvin 1301   -118.845976 35.196467
1080 1080 2020-10-22 Kern 29 93205: Bodfish 7   -118.508875 35.568924
1081 1081 2020-10-22 Kern 29 93206: Buttonwillow 119   -119.47438 35.418624
1082 1082 2020-10-22 Kern 29 93215: Delano 2245   -119.304631 35.754264
1083 1083 2020-10-22 Kern 29 93220: Edison 3   -118.875922 35.3464
1084 1084 2020-10-22 Kern 29 93222: Pine Mountain Club 6   -119.206571 34.843183
1085 1085 2020-10-22 Kern 29 93224: Fellows 3   -119.556497 35.178493
1086 1086 2020-10-22 Kern 29 93225: Frazier Park 36   -118.990444 34.810422
1087 1087 2020-10-22 Kern 29 93226: Glennville 2   -118.729746 35.723529
1088 1088 2020-10-22 Kern 29 93238: Kernville 17   -118.504448 35.73311
1089 1089 2020-10-22 Kern 29 93240: Lake Isabella 49   -118.51853 35.637717
1090 1090 2020-10-22 Kern 29 93241: Lamont 1002   -118.930775 35.263374
1091 1091 2020-10-22 Kern 29 93243: Lebec 14   -118.934489 34.840174
1092 1092 2020-10-22 Kern 29 93249: Lost Hills 92   -119.709567 35.633765
1093 1093 2020-10-22 Kern 29 93250: Mc Farland 969   -119.284618 35.678053
1094 1094 2020-10-22 Kern 29 93252: Maricopa 23   -119.423844 35.050872
1095 1095 2020-10-22 Kern 29 93263: Shafter 1308   -119.294577 35.481604
1096 1096 2020-10-22 Kern 29 93268: Taft 545   -119.468953 35.126049
1097 1097 2020-10-22 Kern 29 93276: Tupman 2   -119.364401 35.29931
1098 1098 2020-10-22 Kern 29 93280: Wasco 1599   -119.406818 35.58496
1099 1099 2020-10-22 Kern 29 93283: Weldon 10   -118.384148 35.643632
1100 1100 2020-10-22 Kern 29 93285: Wofford Heights 14   -118.511663 35.710558
1101 1101 2020-10-22 Kern 29 93287: Woody 2   -118.836405 35.703491
1102 1102 2020-10-22 Kern 29 93301: Bakersfield 603   -119.0169 35.3874
1103 1103 2020-10-22 Kern 29 93304: Bakersfield 2284   -119.0285 35.3441
1104 1104 2020-10-22 Kern 29 93305: Bakersfield 1569   -118.982 35.3965
1105 1105 2020-10-22 Kern 29 93306: Bakersfield 3248   -118.7898 35.4516
1106 1106 2020-10-22 Kern 29 93307: Bakersfield 4607   -118.9762 35.2421
1107 1107 2020-10-22 Kern 29 93308: Bakersfield 1429   -118.9063 35.5217
1108 1108 2020-10-22 Kern 29 93309: Bakersfield 2286   -119.0576 35.3516
1109 1109 2020-10-22 Kern 29 93311: Bakersfield 1526   -119.1856 35.1269
1110 1110 2020-10-22 Kern 29 93312: Bakersfield 1553   -119.1274 35.3734
1111 1111 2020-10-22 Kern 29 93313: Bakersfield 2478   -119.0227 35.1091
1112 1112 2020-10-22 Kern 29 93314: Bakersfield 799   -119.2088 35.3821
1113 1113 2020-10-22 Kern 29 93501: Mojave 55   -118.194488 35.023791
1114 1114 2020-10-22 Kern 29 93505: California City 129   -117.879958 35.16675
1115 1115 2020-10-22 Kern 29 93516: Boron 8   -117.670056 35.018887
1116 1116 2020-10-22 Kern 29 93518: Caliente 2   -118.628869 35.291223
1117 1117 2020-10-22 Kern 29 93523: Edwards 17   -117.862804 34.971263
1118 1118 2020-10-22 Kern 29 93524: Edwards 1   -117.908625 34.931747
1119 1119 2020-10-22 Kern 29 93527: Inyokern 9   -117.805113 35.640156
1120 1120 2020-10-22 Kern 29 93531: Keene 6   -118.562992 35.219588
1121 1121 2020-10-22 Kern 29 93555: Ridgecrest 128   -117.670833 35.6225
1122 1122 2020-10-22 Kern 29 93560: Rosamond 308   -118.219949 34.857685
1123 1123 2020-10-22 Kern 29 93561: Tehachapi 1145   -118.447687 35.129115
2032 2032 2020-10-21 Kern 29 93203: Arvin 1301   -118.845976 35.196467
2033 2033 2020-10-21 Kern 29 93205: Bodfish 7   -118.508875 35.568924
2034 2034 2020-10-21 Kern 29 93206: Buttonwillow 119   -119.47438 35.418624
2035 2035 2020-10-21 Kern 29 93215: Delano 2246   -119.304631 35.754264
2036 2036 2020-10-21 Kern 29 93220: Edison 3   -118.875922 35.3464
2037 2037 2020-10-21 Kern 29 93222: Pine Mountain Club 6   -119.206571 34.843183
2038 2038 2020-10-21 Kern 29 93224: Fellows 3   -119.556497 35.178493
2039 2039 2020-10-21 Kern 29 93225: Frazier Park 36   -118.990444 34.810422
2040 2040 2020-10-21 Kern 29 93226: Glennville 2   -118.729746 35.723529
2041 2041 2020-10-21 Kern 29 93238: Kernville 18   -118.504448 35.73311
2042 2042 2020-10-21 Kern 29 93240: Lake Isabella 48   -118.51853 35.637717
2043 2043 2020-10-21 Kern 29 93241: Lamont 1003   -118.930775 35.263374
2044 2044 2020-10-21 Kern 29 93243: Lebec 14   -118.934489 34.840174
2045 2045 2020-10-21 Kern 29 93249: Lost Hills 92   -119.709567 35.633765
2046 2046 2020-10-21 Kern 29 93250: Mc Farland 970   -119.284618 35.678053
2047 2047 2020-10-21 Kern 29 93252: Maricopa 23   -119.423844 35.050872
2048 2048 2020-10-21 Kern 29 93263: Shafter 1306   -119.294577 35.481604
2049 2049 2020-10-21 Kern 29 93268: Taft 532   -119.468953 35.126049
2050 2050 2020-10-21 Kern 29 93276: Tupman 2   -119.364401 35.29931
2051 2051 2020-10-21 Kern 29 93280: Wasco 1615   -119.406818 35.58496
2052 2052 2020-10-21 Kern 29 93283: Weldon 10   -118.384148 35.643632
2053 2053 2020-10-21 Kern 29 93285: Wofford Heights 14   -118.511663 35.710558
2054 2054 2020-10-21 Kern 29 93287: Woody 2   -118.836405 35.703491
2055 2055 2020-10-21 Kern 29 93301: Bakersfield 601   -119.0169 35.3874
2056 2056 2020-10-21 Kern 29 93304: Bakersfield 2274   -119.0285 35.3441
2057 2057 2020-10-21 Kern 29 93305: Bakersfield 1568   -118.982 35.3965
2058 2058 2020-10-21 Kern 29 93306: Bakersfield 3241   -118.7898 35.4516
2059 2059 2020-10-21 Kern 29 93307: Bakersfield 4605   -118.9762 35.2421
2060 2060 2020-10-21 Kern 29 93308: Bakersfield 1428   -118.9063 35.5217
2061 2061 2020-10-21 Kern 29 93309: Bakersfield 2283   -119.0576 35.3516
2062 2062 2020-10-21 Kern 29 93311: Bakersfield 1524   -119.1856 35.1269
2063 2063 2020-10-21 Kern 29 93312: Bakersfield 1550   -119.1274 35.3734
2064 2064 2020-10-21 Kern 29 93313: Bakersfield 2472   -119.0227 35.1091
2065 2065 2020-10-21 Kern 29 93314: Bakersfield 798   -119.2088 35.3821
2066 2066 2020-10-21 Kern 29 93501: Mojave 55   -118.194488 35.023791
2067 2067 2020-10-21 Kern 29 93505: California City 127   -117.879958 35.16675
2068 2068 2020-10-21 Kern 29 93516: Boron 8   -117.670056 35.018887
2069 2069 2020-10-21 Kern 29 93518: Caliente 2   -118.628869 35.291223
2070 2070 2020-10-21 Kern 29 93523: Edwards 17   -117.862804 34.971263
2071 2071 2020-10-21 Kern 29 93524: Edwards 1   -117.908625 34.931747
2072 2072 2020-10-21 Kern 29 93527: Inyokern 9   -117.805113 35.640156
2073 2073 2020-10-21 Kern 29 93531: Keene 7   -118.562992 35.219588
2074 2074 2020-10-21 Kern 29 93555: Ridgecrest 126   -117.670833 35.6225
2075 2075 2020-10-21 Kern 29 93560: Rosamond 306   -118.219949 34.857685
2076 2076 2020-10-21 Kern 29 93561: Tehachapi 1144   -118.447687 35.129115
3051 3051 2020-10-20 Kern 29 93203: Arvin 1301   -118.845976 35.196467
3052 3052 2020-10-20 Kern 29 93205: Bodfish 7   -118.508875 35.568924
3053 3053 2020-10-20 Kern 29 93206: Buttonwillow 119   -119.47438 35.418624
3054 3054 2020-10-20 Kern 29 93215: Delano 2247   -119.304631 35.754264
3055 3055 2020-10-20 Kern 29 93220: Edison 3   -118.875922 35.3464
3056 3056 2020-10-20 Kern 29 93222: Pine Mountain Club 6   -119.206571 34.843183
3057 3057 2020-10-20 Kern 29 93224: Fellows 3   -119.556497 35.178493
3058 3058 2020-10-20 Kern 29 93225: Frazier Park 36   -118.990444 34.810422
3059 3059 2020-10-20 Kern 29 93226: Glennville 2   -118.729746 35.723529
3060 3060 2020-10-20 Kern 29 93238: Kernville 18   -118.504448 35.73311

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