latimes-place-totals
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifier of the city, neighborhood or other area.
- name
- The name of the city, neighborhood or other area.
- date
- The date when the data were retrieved in ISO 8601 format.
- county
- The name of the county where the city is located.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- confirmed_cases
- The cumulative number of confirmed coronavirus case at that time.
- note
- In cases where the confirmed_cases are obscured, this explains the range of possible values.
- population
- The number of residents in the area. Not available for all places.
1,276 rows where "date" is on date 2021-01-11 sorted by note
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id | name | date | county | fips | confirmed_cases | note ▼ | population |
---|---|---|---|---|---|---|---|---|---|
908104 | 908104 | Pittsburg | Pittsburg | 2021-01-11 | Contra Costa | 13 | 4731 | 74321 | |
908105 | 908105 | Pleasant Hill | Pleasant Hill | 2021-01-11 | Contra Costa | 13 | 831 | 34267 | |
908106 | 908106 | Richmond | Richmond | 2021-01-11 | Contra Costa | 13 | 7669 | 111217 | |
908107 | 908107 | Rodeo | Rodeo | 2021-01-11 | Contra Costa | 13 | 371 | 8679 | |
908108 | 908108 | San Pablo | San Pablo | 2021-01-11 | Contra Costa | 13 | 3801 | 31413 | |
908109 | 908109 | San Ramon | San Ramon | 2021-01-11 | Contra Costa | 13 | 1450 | 83118 | |
908110 | 908110 | Walnut Creek | Walnut Creek | 2021-01-11 | Contra Costa | 13 | 1955 | 70860 | |
908111 | 908111 | Camino, Pollock Pines, Kyburz | Camino, Pollock Pines, Kyburz | 2021-01-11 | El Dorado | 17 | 381 | 13548 | |
908112 | 908112 | El Dorado Hills | El Dorado Hills | 2021-01-11 | El Dorado | 17 | 1491 | 42439 | |
908113 | 908113 | El Dorado, Diamond Springs | El Dorado, Diamond Springs | 2021-01-11 | El Dorado | 17 | 326 | 9396 | |
908114 | 908114 | Greater Placerville Area | Greater Placerville Area | 2021-01-11 | El Dorado | 17 | 1305 | 36508 | |
908115 | 908115 | North County | North County | 2021-01-11 | El Dorado | 17 | 312 | 14433 | |
908116 | 908116 | Shingle Springs, Cameron Park, Rescue | Shingle Springs, Cameron Park, Rescue | 2021-01-11 | El Dorado | 17 | 1182 | 35294 | |
908117 | 908117 | South County | South County | 2021-01-11 | El Dorado | 17 | 81 | 10345 | |
908118 | 908118 | Tahoe Region | Tahoe Region | 2021-01-11 | El Dorado | 17 | 1884 | 30275 | |
908119 | 908119 | Auberry | Auberry | 2021-01-11 | Fresno | 19 | 47 | 3994 | |
908120 | 908120 | Biola | Biola | 2021-01-11 | Fresno | 19 | 88 | 949 | |
908121 | 908121 | Cantua Creek | Cantua Creek | 2021-01-11 | Fresno | 19 | 55 | 1125 | |
908122 | 908122 | Caruthers | Caruthers | 2021-01-11 | Fresno | 19 | 367 | 5887 | |
908123 | 908123 | Clovis | Clovis | 2021-01-11 | Fresno | 19 | 3615 | 122949 | |
908124 | 908124 | Coalinga | Coalinga | 2021-01-11 | Fresno | 19 | 2078 | 19345 | |
908125 | 908125 | Del Rey | Del Rey | 2021-01-11 | Fresno | 19 | 166 | 2759 | |
908126 | 908126 | Dinuba | Dinuba | 2021-01-11 | Fresno | 19 | 0 | 0 | |
908127 | 908127 | Dos Palos | Dos Palos | 2021-01-11 | Fresno | 19 | 0 | ||
908128 | 908128 | Dunlap | Dunlap | 2021-01-11 | Fresno | 19 | 6 | ||
908129 | 908129 | Firebaugh | Firebaugh | 2021-01-11 | Fresno | 19 | 505 | 9965 | |
908130 | 908130 | Five Points | Five Points | 2021-01-11 | Fresno | 19 | 23 | 0 | |
908131 | 908131 | Fowler | Fowler | 2021-01-11 | Fresno | 19 | 474 | 7917 | |
908132 | 908132 | Fresno | Fresno | 2021-01-11 | Fresno | 19 | 26967 | 608579 | |
908133 | 908133 | Friant | Friant | 2021-01-11 | Fresno | 19 | 36 | 1930 | |
908134 | 908134 | Huron | Huron | 2021-01-11 | Fresno | 19 | 498 | 7579 | |
908135 | 908135 | Kerman | Kerman | 2021-01-11 | Fresno | 19 | 1429 | 21009 | |
908136 | 908136 | Kingsburg | Kingsburg | 2021-01-11 | Fresno | 19 | 658 | 17086 | |
908137 | 908137 | Laton | Laton | 2021-01-11 | Fresno | 19 | 168 | 3513 | |
908138 | 908138 | Mendota | Mendota | 2021-01-11 | Fresno | 19 | 1213 | 13576 | |
908139 | 908139 | Orange Cove | Orange Cove | 2021-01-11 | Fresno | 19 | 885 | 11320 | |
908140 | 908140 | Parlier | Parlier | 2021-01-11 | Fresno | 19 | 1606 | 17097 | |
908141 | 908141 | Prather | Prather | 2021-01-11 | Fresno | 19 | 16 | 0 | |
908142 | 908142 | Raisin | Raisin | 2021-01-11 | Fresno | 19 | 0 | 380 | |
908143 | 908143 | Reedley | Reedley | 2021-01-11 | Fresno | 19 | 1961 | 31129 | |
908144 | 908144 | Riverdale | Riverdale | 2021-01-11 | Fresno | 19 | 337 | 6459 | |
908145 | 908145 | San Joaquin | San Joaquin | 2021-01-11 | Fresno | 19 | 249 | 4633 | |
908146 | 908146 | Sanger | Sanger | 2021-01-11 | Fresno | 19 | 2275 | 38252 | |
908147 | 908147 | Selma | Selma | 2021-01-11 | Fresno | 19 | 2309 | 31726 | |
908148 | 908148 | Squaw Valley | Squaw Valley | 2021-01-11 | Fresno | 19 | 46 | 3908 | |
908149 | 908149 | Tollhouse | Tollhouse | 2021-01-11 | Fresno | 19 | 39 | 2712 | |
908150 | 908150 | Tranquillity | Tranquillity | 2021-01-11 | Fresno | 19 | 50 | 1132 | |
908151 | 908151 | 92222 | 92222: Bard | 2021-01-11 | Imperial | 25 | 6 | 0 | |
908152 | 908152 | 92227 | 92227: Brawley | 2021-01-11 | Imperial | 25 | 3826 | 27255 | |
908153 | 908153 | 92231 | 92231: Calexico | 2021-01-11 | Imperial | 25 | 6703 | 40019 | |
908154 | 908154 | 92233 | 92233: Calipatria | 2021-01-11 | Imperial | 25 | 645 | 7618 | |
908155 | 908155 | 92243 | 92243: El Centro | 2021-01-11 | Imperial | 25 | 6210 | 50484 | |
908156 | 908156 | 92244 | 92244: El Centro | 2021-01-11 | Imperial | 25 | 86 | 0 | |
908157 | 908157 | 92249 | 92249: Heber | 2021-01-11 | Imperial | 25 | 1065 | 7898 | |
908158 | 908158 | 92250 | 92250: Holtville | 2021-01-11 | Imperial | 25 | 927 | 8979 | |
908159 | 908159 | 92251 | 92251: Imperial | 2021-01-11 | Imperial | 25 | 2614 | 23388 | |
908160 | 908160 | 92257 | 92257: Niland | 2021-01-11 | Imperial | 25 | 89 | 1332 | |
908161 | 908161 | 92259 | 92259: Ocotillo | 2021-01-11 | Imperial | 25 | 5 | 94 | |
908162 | 908162 | 92266 | 92266: Palo Verde | 2021-01-11 | Imperial | 25 | 7 | 108 | |
908163 | 908163 | 92273 | 92273: Seeley | 2021-01-11 | Imperial | 25 | 163 | 1704 | |
908164 | 908164 | 92274 | 92274: Thermal | 2021-01-11 | Imperial | 25 | 377 | 15118 | |
908165 | 908165 | 92275 | 92275: Salton City | 2021-01-11 | Imperial | 25 | 32 | 2456 | |
908166 | 908166 | 92281 | 92281: Westmorland | 2021-01-11 | Imperial | 25 | 228 | 2859 | |
908167 | 908167 | 92283 | 92283: Winterhaven | 2021-01-11 | Imperial | 25 | 199 | 1694 | |
908168 | 908168 | 93226 | 93226: Glennville | 2021-01-11 | Kern | 29 | 12 | 195 | |
908169 | 908169 | 93238 | 93238: Kernville | 2021-01-11 | Kern | 29 | 42 | 1408 | |
908170 | 908170 | 93240 | 93240: Lake Isabella | 2021-01-11 | Kern | 29 | 185 | 6960 | |
908171 | 908171 | 93241 | 93241: Lamont | 2021-01-11 | Kern | 29 | 1824 | 16969 | |
908172 | 908172 | 93243 | 93243: Lebec | 2021-01-11 | Kern | 29 | 62 | 1709 | |
908173 | 908173 | 93249 | 93249: Lost Hills | 2021-01-11 | Kern | 29 | 219 | 2264 | |
908174 | 908174 | 93250 | 93250: Mc Farland | 2021-01-11 | Kern | 29 | 1869 | 15523 | |
908175 | 908175 | 93251 | 93251: Mc Kittrick | 2021-01-11 | Kern | 29 | 17 | 243 | |
908176 | 908176 | 93252 | 93252: Maricopa | 2021-01-11 | Kern | 29 | 67 | 3188 | |
908177 | 908177 | 93255 | 93255: Onyx | 2021-01-11 | Kern | 29 | 8 | 707 | |
908178 | 908178 | 93263 | 93263: Shafter | 2021-01-11 | Kern | 29 | 2667 | 20710 | |
908179 | 908179 | 93268 | 93268: Taft | 2021-01-11 | Kern | 29 | 1222 | 17620 | |
908180 | 908180 | 93276 | 93276: Tupman | 2021-01-11 | Kern | 29 | 10 | 159 | |
908181 | 908181 | 93280 | 93280: Wasco | 2021-01-11 | Kern | 29 | 4089 | 27552 | |
908182 | 908182 | 93283 | 93283: Weldon | 2021-01-11 | Kern | 29 | 29 | 2086 | |
908183 | 908183 | 93285 | 93285: Wofford Heights | 2021-01-11 | Kern | 29 | 48 | 1723 | |
908184 | 908184 | 93287 | 93287: Woody | 2021-01-11 | Kern | 29 | 6 | 74 | |
908185 | 908185 | 93301 | 93301: Bakersfield | 2021-01-11 | Kern | 29 | 1292 | 12345 | |
908186 | 908186 | 93304 | 93304: Bakersfield | 2021-01-11 | Kern | 29 | 4678 | 50787 | |
908187 | 908187 | 93305 | 93305: Bakersfield | 2021-01-11 | Kern | 29 | 3224 | 39114 | |
908188 | 908188 | 93306 | 93306: Bakersfield | 2021-01-11 | Kern | 29 | 6899 | 70208 | |
908189 | 908189 | 93307 | 93307: Bakersfield | 2021-01-11 | Kern | 29 | 9219 | 84948 | |
908190 | 908190 | 93308 | 93308: Bakersfield | 2021-01-11 | Kern | 29 | 3265 | 54042 | |
908191 | 908191 | 93309 | 93309: Bakersfield | 2021-01-11 | Kern | 29 | 5055 | 60893 | |
908192 | 908192 | 93311 | 93311: Bakersfield | 2021-01-11 | Kern | 29 | 3704 | 44862 | |
908193 | 908193 | 93312 | 93312: Bakersfield | 2021-01-11 | Kern | 29 | 4143 | 59359 | |
908194 | 908194 | 93313 | 93313: Bakersfield | 2021-01-11 | Kern | 29 | 5790 | 51245 | |
908195 | 908195 | 93314 | 93314: Bakersfield | 2021-01-11 | Kern | 29 | 2334 | 26992 | |
908196 | 908196 | 93501 | 93501: Mojave | 2021-01-11 | Kern | 29 | 297 | 5063 | |
908197 | 908197 | 93505 | 93505: California City | 2021-01-11 | Kern | 29 | 1353 | 13445 | |
908198 | 908198 | 93516 | 93516: Boron | 2021-01-11 | Kern | 29 | 76 | 2425 | |
908199 | 908199 | 93518 | 93518: Caliente | 2021-01-11 | Kern | 29 | 16 | 995 | |
908200 | 908200 | 93519 | 93519: Cantil | 2021-01-11 | Kern | 29 | 0 | 28 | |
908201 | 908201 | 93523 | 93523: Edwards | 2021-01-11 | Kern | 29 | 51 | 3312 | |
908202 | 908202 | 93524 | 93524: Edwards | 2021-01-11 | Kern | 29 | 3 | 168 | |
908203 | 908203 | 93203 | 93203: Arvin | 2021-01-11 | Kern | 29 | 2410 | 22471 |
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] INTEGER );