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,181 rows where "date" is on date 2022-12-18 sorted by id
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id ▼ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
13639 | 13639 | 90802 | 90802: Long Beach | 2022-12-18 | Los Angeles | 37 | 11943 | 39453 | |
13640 | 13640 | 90803 | 90803: Long Beach | 2022-12-18 | Los Angeles | 37 | 7123 | 32389 | |
13641 | 13641 | 90804 | 90804: Long Beach | 2022-12-18 | Los Angeles | 37 | 12946 | 39344 | |
13642 | 13642 | 90805 | 90805: Long Beach | 2022-12-18 | Los Angeles | 37 | 34025 | 96708 | |
13643 | 13643 | 90806 | 90806: Long Beach | 2022-12-18 | Los Angeles | 37 | 15309 | 42817 | |
13644 | 13644 | 90807 | 90807: Long Beach | 2022-12-18 | Los Angeles | 37 | 9851 | 32067 | |
13645 | 13645 | 90808 | 90808: Long Beach | 2022-12-18 | Los Angeles | 37 | 10507 | 38860 | |
13646 | 13646 | 90810 | 90810: Long Beach | 2022-12-18 | Los Angeles | 37 | 11363 | 38579 | |
13647 | 13647 | 90813 | 90813: Long Beach | 2022-12-18 | Los Angeles | 37 | 18185 | 59000 | |
13648 | 13648 | 90814 | 90814: Long Beach | 2022-12-18 | Los Angeles | 37 | 5086 | 18587 | |
13649 | 13649 | 90815 | 90815: Long Beach | 2022-12-18 | Los Angeles | 37 | 10945 | 41026 | |
13650 | 13650 | 91101 | 91101: Pasadena | 2022-12-18 | Los Angeles | 37 | 4947 | 20719 | |
13651 | 13651 | 91103 | 91103: Pasadena | 2022-12-18 | Los Angeles | 37 | 9674 | 28435 | |
13652 | 13652 | 91104 | 91104: Pasadena | 2022-12-18 | Los Angeles | 37 | 8466 | 39178 | |
13653 | 13653 | 91105 | 91105: Pasadena | 2022-12-18 | Los Angeles | 37 | 2880 | 11907 | |
13654 | 13654 | 91106 | 91106: Pasadena | 2022-12-18 | Los Angeles | 37 | 6120 | 25479 | |
13655 | 13655 | 91107 | 91107: Pasadena | 2022-12-18 | Los Angeles | 37 | 5586 | 321 | |
14613 | 14613 | 91307 | 91307: Bell Canyon | 2022-12-18 | Ventura | 111 | 37 | 2391 | |
14614 | 14614 | 91320 | 91320: Thousand Oaks/Newbury Park | 2022-12-18 | Ventura | 111 | 9118 | 46191 | |
14615 | 14615 | 91360 | 91360: Thousand Oaks | 2022-12-18 | Ventura | 111 | 9058 | 42104 | |
14616 | 14616 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2022-12-18 | Ventura | 111 | 2304 | 20487 | |
14617 | 14617 | 91362 | 91362: Thousand Oaks/Westlake | 2022-12-18 | Ventura | 111 | 6654 | 36980 | |
14618 | 14618 | 91377 | 91377: Oak Park | 2022-12-18 | Ventura | 111 | 2385 | 14226 | |
14413 | 14413 | 91901 | 91901: Alpine | 2022-12-18 | San Diego | 73 | 4322 | 17985 | |
14414 | 14414 | 91902 | 91902: Bonita | 2022-12-18 | San Diego | 73 | 4998 | 17631 | |
14415 | 14415 | 91905 | 91905: Boulevard | 2022-12-18 | San Diego | 73 | 289 | 0 | |
14416 | 14416 | 91906 | 91906: Campo | 2022-12-18 | San Diego | 73 | 1009 | 0 | |
14307 | 14307 | 91910 | 91910: Chula Vista | 2022-12-18 | San Diego | 73 | 28705 | 83834 | |
14308 | 14308 | 91911 | 91911: Chula Vista | 2022-12-18 | San Diego | 73 | 32989 | 84819 | |
14309 | 14309 | 91913 | 91913: Chula Vista | 2022-12-18 | San Diego | 73 | 19070 | 51077 | |
14310 | 14310 | 91914 | 91914: Chula Vista | 2022-12-18 | San Diego | 73 | 5369 | 16781 | |
14311 | 14311 | 91915 | 91915: Chula Vista | 2022-12-18 | San Diego | 73 | 10832 | 31120 | |
14312 | 14312 | 91916 | 91916: Descanso | 2022-12-18 | San Diego | 73 | 366 | 0 | |
14313 | 14313 | 91917 | 91917: Dulzura | 2022-12-18 | San Diego | 73 | 332 | 0 | |
14314 | 14314 | 91931 | 91931: Guatay | 2022-12-18 | San Diego | 73 | 47 | 0 | |
14315 | 14315 | 91932 | 91932: Imperial Beach | 2022-12-18 | San Diego | 73 | 8482 | 27448 | |
14316 | 14316 | 91934 | 91934: Jacumba | 2022-12-18 | San Diego | 73 | 116 | 0 | |
14317 | 14317 | 91935 | 91935: Jamul | 2022-12-18 | San Diego | 73 | 2108 | 0 | |
14318 | 14318 | 91941 | 91941: La Mesa | 2022-12-18 | San Diego | 73 | 9022 | 34226 | |
14319 | 14319 | 91942 | 91942: La Mesa | 2022-12-18 | San Diego | 73 | 10236 | 40025 | |
14320 | 14320 | 91945 | 91945: Lemon Grove | 2022-12-18 | San Diego | 73 | 10068 | 27208 | |
14321 | 14321 | 91950 | 91950: National City | 2022-12-18 | San Diego | 73 | 21823 | 58536 | |
14322 | 14322 | 91962 | 91962: Pine Valley | 2022-12-18 | San Diego | 73 | 362 | 0 | |
14323 | 14323 | 91963 | 91963: Potrero | 2022-12-18 | San Diego | 73 | 390 | 0 | |
14324 | 14324 | 91977 | 91977: Spring Valley | 2022-12-18 | San Diego | 73 | 20428 | 60995 | |
14325 | 14325 | 91978 | 91978: Spring Valley | 2022-12-18 | San Diego | 73 | 2763 | 0 | |
14326 | 14326 | 91980 | 91980: Tecate | 2022-12-18 | San Diego | 73 | 287 | 0 | |
14327 | 14327 | 92003 | 92003: Bonsall | 2022-12-18 | San Diego | 73 | 1052 | 0 | |
14328 | 14328 | 92004 | 92004: Borrego Springs | 2022-12-18 | San Diego | 73 | 376 | 0 | |
14329 | 14329 | 92007 | 92007: Cardiff by the Sea | 2022-12-18 | San Diego | 73 | 1912 | 11483 | |
14330 | 14330 | 92008 | 92008: Carlsbad | 2022-12-18 | San Diego | 73 | 5831 | 29652 | |
14331 | 14331 | 92009 | 92009: Carlsbad | 2022-12-18 | San Diego | 73 | 8319 | 43338 | |
14332 | 14332 | 92010 | 92010: Carlsbad | 2022-12-18 | San Diego | 73 | 3872 | 16681 | |
14333 | 14333 | 92011 | 92011: Carlsbad | 2022-12-18 | San Diego | 73 | 4315 | 23963 | |
14334 | 14334 | 92014 | 92014: Del Mar | 2022-12-18 | San Diego | 73 | 2183 | 14139 | |
14335 | 14335 | 92019 | 92019: El Cajon | 2022-12-18 | San Diego | 73 | 12810 | 45094 | |
14336 | 14336 | 92020 | 92020: El Cajon | 2022-12-18 | San Diego | 73 | 19184 | 61896 | |
14337 | 14337 | 92021 | 92021: El Cajon | 2022-12-18 | San Diego | 73 | 20869 | 68655 | |
14338 | 14338 | 92024 | 92024: Encinitas | 2022-12-18 | San Diego | 73 | 10402 | 56390 | |
14339 | 14339 | 92025 | 92025: Escondido | 2022-12-18 | San Diego | 73 | 15239 | 51820 | |
14340 | 14340 | 92026 | 92026: Escondido | 2022-12-18 | San Diego | 73 | 14972 | 56272 | |
14341 | 14341 | 92027 | 92027: Escondido | 2022-12-18 | San Diego | 73 | 17377 | 54202 | |
14342 | 14342 | 92028 | 92028: Fallbrook | 2022-12-18 | San Diego | 73 | 11127 | 49009 | |
14343 | 14343 | 92029 | 92029: Escondido | 2022-12-18 | San Diego | 73 | 4973 | 21201 | |
14344 | 14344 | 92036 | 92036: Julian | 2022-12-18 | San Diego | 73 | 492 | 0 | |
14345 | 14345 | 92037 | 92037: La Jolla | 2022-12-18 | San Diego | 73 | 8201 | 43283 | |
14346 | 14346 | 92040 | 92040: Lakeside | 2022-12-18 | San Diego | 73 | 11565 | 44105 | |
14347 | 14347 | 92054 | 92054: Oceanside | 2022-12-18 | San Diego | 73 | 9461 | 42441 | |
14348 | 14348 | 92055 | 92055: Camp Pendleton | 2022-12-18 | San Diego | 73 | 2037 | 36726 | |
14349 | 14349 | 92056 | 92056: Oceanside | 2022-12-18 | San Diego | 73 | 13684 | 55369 | |
14350 | 14350 | 92057 | 92057: Oceanside | 2022-12-18 | San Diego | 73 | 15697 | 55753 | |
14351 | 14351 | 92058 | 92058: Oceanside | 2022-12-18 | San Diego | 73 | 10209 | 24170 | |
14352 | 14352 | 92059 | 92059: Pala | 2022-12-18 | San Diego | 73 | 614 | 0 | |
14353 | 14353 | 92060 | 92060: Palomar Mountain | 2022-12-18 | San Diego | 73 | 102 | 0 | |
14354 | 14354 | 92061 | 92061: Pauma Valley | 2022-12-18 | San Diego | 73 | 725 | 0 | |
14355 | 14355 | 92064 | 92064: Poway | 2022-12-18 | San Diego | 73 | 10743 | 50435 | |
14356 | 14356 | 92065 | 92065: Ramona | 2022-12-18 | San Diego | 73 | 8484 | 36256 | |
14357 | 14357 | 92066 | 92066: Ranchita | 2022-12-18 | San Diego | 73 | 48 | 0 | |
14358 | 14358 | 92067 | 92067: Rancho Santa Fe | 2022-12-18 | San Diego | 73 | 1851 | 0 | |
14359 | 14359 | 92069 | 92069: San Marcos | 2022-12-18 | San Diego | 73 | 14847 | 51172 | |
14360 | 14360 | 92070 | 92070: Santa Ysabel | 2022-12-18 | San Diego | 73 | 363 | 0 | |
14361 | 14361 | 92071 | 92071: Santee | 2022-12-18 | San Diego | 73 | 15126 | 58213 | |
14362 | 14362 | 92075 | 92075: Solana Beach | 2022-12-18 | San Diego | 73 | 2028 | 12976 | |
14363 | 14363 | 92078 | 92078: San Marcos | 2022-12-18 | San Diego | 73 | 12022 | 50973 | |
14364 | 14364 | 92081 | 92081: Vista | 2022-12-18 | San Diego | 73 | 7262 | 32889 | |
14365 | 14365 | 92082 | 92082: Valley Center | 2022-12-18 | San Diego | 73 | 5066 | 17680 | |
14366 | 14366 | 92083 | 92083: Vista | 2022-12-18 | San Diego | 73 | 14023 | 39155 | |
14367 | 14367 | 92084 | 92084: Vista | 2022-12-18 | San Diego | 73 | 15054 | 49040 | |
14368 | 14368 | 92086 | 92086: Warner Springs | 2022-12-18 | San Diego | 73 | 169 | 0 | |
14369 | 14369 | 92091 | 92091: Rancho Santa Fe | 2022-12-18 | San Diego | 73 | 176 | 0 | |
14370 | 14370 | 92093 | 92093: La Jolla | 2022-12-18 | San Diego | 73 | 4014 | 11299 | |
14371 | 14371 | 92096 | 92096: San Marcos | 2022-12-18 | San Diego | 73 | 36 | 0 | |
14372 | 14372 | 92101 | 92101: San Diego | 2022-12-18 | San Diego | 73 | 13636 | 60694 | |
14373 | 14373 | 92102 | 92102: San Diego | 2022-12-18 | San Diego | 73 | 14236 | 42331 | |
14374 | 14374 | 92103 | 92103: San Diego | 2022-12-18 | San Diego | 73 | 7886 | 39687 | |
14375 | 14375 | 92104 | 92104: San Diego | 2022-12-18 | San Diego | 73 | 11455 | 52095 | |
14376 | 14376 | 92105 | 92105: San Diego | 2022-12-18 | San Diego | 73 | 21563 | 67077 | |
14377 | 14377 | 92106 | 92106: San Diego | 2022-12-18 | San Diego | 73 | 3978 | 22209 | |
14378 | 14378 | 92107 | 92107: San Diego | 2022-12-18 | San Diego | 73 | 5460 | 30971 | |
14379 | 14379 | 92108 | 92108: San Diego | 2022-12-18 | San Diego | 73 | 7986 | 27342 |
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 );