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-10 sorted by id
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | id ▼ | name | date | county | fips | confirmed_cases | note | population |
---|---|---|---|---|---|---|---|---|---|
909518 | 909518 | 90802 | 90802: Long Beach | 2021-01-10 | Los Angeles | 37 | 2862 | 39453 | |
909519 | 909519 | 90803 | 90803: Long Beach | 2021-01-10 | Los Angeles | 37 | 1369 | 32389 | |
909520 | 909520 | 90804 | 90804: Long Beach | 2021-01-10 | Los Angeles | 37 | 3295 | 39344 | |
909521 | 909521 | 90805 | 90805: Long Beach | 2021-01-10 | Los Angeles | 37 | 9641 | 96708 | |
909522 | 909522 | 90806 | 90806: Long Beach | 2021-01-10 | Los Angeles | 37 | 4500 | 42817 | |
909523 | 909523 | 90807 | 90807: Long Beach | 2021-01-10 | Los Angeles | 37 | 2068 | 32067 | |
909524 | 909524 | 90808 | 90808: Long Beach | 2021-01-10 | Los Angeles | 37 | 1898 | 38860 | |
909525 | 909525 | 90810 | 90810: Long Beach | 2021-01-10 | Los Angeles | 37 | 3388 | 38579 | |
909526 | 909526 | 90813 | 90813: Long Beach | 2021-01-10 | Los Angeles | 37 | 5836 | 59000 | |
909527 | 909527 | 90814 | 90814: Long Beach | 2021-01-10 | Los Angeles | 37 | 934 | 18587 | |
909528 | 909528 | 90815 | 90815: Long Beach | 2021-01-10 | Los Angeles | 37 | 2052 | 41026 | |
909529 | 909529 | 91101 | 91101: Pasadena | 2021-01-10 | Los Angeles | 37 | 1041 | 20719 | |
909530 | 909530 | 91103 | 91103: Pasadena | 2021-01-10 | Los Angeles | 37 | 2881 | 28435 | |
909531 | 909531 | 91104 | 91104: Pasadena | 2021-01-10 | Los Angeles | 37 | 1794 | 39178 | |
909532 | 909532 | 91105 | 91105: Pasadena | 2021-01-10 | Los Angeles | 37 | 549 | 11907 | |
909533 | 909533 | 91106 | 91106: Pasadena | 2021-01-10 | Los Angeles | 37 | 1156 | 25479 | |
909534 | 909534 | 91107 | 91107: Pasadena | 2021-01-10 | Los Angeles | 37 | 935 | 321 | |
910521 | 910521 | 91307 | 91307: Bell Canyon | 2021-01-10 | Ventura | 111 | 7 | 2391 | |
910522 | 910522 | 91320 | 91320: Thousand Oaks/Newbury Park | 2021-01-10 | Ventura | 111 | 1764 | 46191 | |
910523 | 910523 | 91360 | 91360: Thousand Oaks | 2021-01-10 | Ventura | 111 | 1607 | 42104 | |
910524 | 910524 | 91361 | 91361: Thousand Oaks/Lake Sherwood/Westlake | 2021-01-10 | Ventura | 111 | 399 | 20487 | |
910525 | 910525 | 91362 | 91362: Thousand Oaks/Westlake | 2021-01-10 | Ventura | 111 | 1035 | 36980 | |
910526 | 910526 | 91377 | 91377: Oak Park | 2021-01-10 | Ventura | 111 | 247 | 14226 | |
910323 | 910323 | 91901 | 91901: Alpine | 2021-01-10 | San Diego | 73 | 851 | 17985 | |
910324 | 910324 | 91902 | 91902: Bonita | 2021-01-10 | San Diego | 73 | 963 | 17631 | |
910325 | 910325 | 91905 | 91905: Boulevard | 2021-01-10 | San Diego | 73 | 46 | 0 | |
910326 | 910326 | 91906 | 91906: Campo | 2021-01-10 | San Diego | 73 | 198 | 0 | |
910327 | 910327 | 91910 | 91910: Chula Vista | 2021-01-10 | San Diego | 73 | 6565 | 83834 | |
910218 | 910218 | 91911 | 91911: Chula Vista | 2021-01-10 | San Diego | 73 | 8153 | 84819 | |
910219 | 910219 | 91913 | 91913: Chula Vista | 2021-01-10 | San Diego | 73 | 3227 | 51077 | |
910220 | 910220 | 91914 | 91914: Chula Vista | 2021-01-10 | San Diego | 73 | 1046 | 16781 | |
910221 | 910221 | 91915 | 91915: Chula Vista | 2021-01-10 | San Diego | 73 | 1984 | 31120 | |
910222 | 910222 | 91916 | 91916: Descanso | 2021-01-10 | San Diego | 73 | 63 | 0 | |
910223 | 910223 | 91917 | 91917: Dulzura | 2021-01-10 | San Diego | 73 | 153 | 0 | |
910224 | 910224 | 91931 | 91931: Guatay | 2021-01-10 | San Diego | 73 | 9 | 0 | |
910225 | 910225 | 91932 | 91932: Imperial Beach | 2021-01-10 | San Diego | 73 | 1903 | 27448 | |
910226 | 910226 | 91934 | 91934: Jacumba | 2021-01-10 | San Diego | 73 | 22 | 0 | |
910227 | 910227 | 91935 | 91935: Jamul | 2021-01-10 | San Diego | 73 | 451 | 0 | |
910228 | 910228 | 91941 | 91941: La Mesa | 2021-01-10 | San Diego | 73 | 1505 | 34226 | |
910229 | 910229 | 91942 | 91942: La Mesa | 2021-01-10 | San Diego | 73 | 1669 | 40025 | |
910230 | 910230 | 91945 | 91945: Lemon Grove | 2021-01-10 | San Diego | 73 | 1936 | 27208 | |
910231 | 910231 | 91950 | 91950: National City | 2021-01-10 | San Diego | 73 | 5450 | 58536 | |
910232 | 910232 | 91962 | 91962: Pine Valley | 2021-01-10 | San Diego | 73 | 60 | 0 | |
910233 | 910233 | 91963 | 91963: Potrero | 2021-01-10 | San Diego | 73 | 151 | 0 | |
910234 | 910234 | 91977 | 91977: Spring Valley | 2021-01-10 | San Diego | 73 | 4664 | 60995 | |
910235 | 910235 | 91978 | 91978: Spring Valley | 2021-01-10 | San Diego | 73 | 580 | 0 | |
910236 | 910236 | 91980 | 91980: Tecate | 2021-01-10 | San Diego | 73 | 159 | 0 | |
910237 | 910237 | 92003 | 92003: Bonsall | 2021-01-10 | San Diego | 73 | 195 | 0 | |
910238 | 910238 | 92004 | 92004: Borrego Springs | 2021-01-10 | San Diego | 73 | 102 | 0 | |
910239 | 910239 | 92007 | 92007: Cardiff by the Sea | 2021-01-10 | San Diego | 73 | 239 | 11483 | |
910240 | 910240 | 92008 | 92008: Carlsbad | 2021-01-10 | San Diego | 73 | 906 | 29652 | |
910241 | 910241 | 92009 | 92009: Carlsbad | 2021-01-10 | San Diego | 73 | 1179 | 43338 | |
910242 | 910242 | 92010 | 92010: Carlsbad | 2021-01-10 | San Diego | 73 | 519 | 16681 | |
910243 | 910243 | 92011 | 92011: Carlsbad | 2021-01-10 | San Diego | 73 | 587 | 23963 | |
910244 | 910244 | 92014 | 92014: Del Mar | 2021-01-10 | San Diego | 73 | 298 | 14139 | |
910245 | 910245 | 92019 | 92019: El Cajon | 2021-01-10 | San Diego | 73 | 3011 | 45094 | |
910246 | 910246 | 92020 | 92020: El Cajon | 2021-01-10 | San Diego | 73 | 4811 | 61896 | |
910247 | 910247 | 92021 | 92021: El Cajon | 2021-01-10 | San Diego | 73 | 4887 | 68655 | |
910248 | 910248 | 92024 | 92024: Encinitas | 2021-01-10 | San Diego | 73 | 1496 | 56390 | |
910249 | 910249 | 92025 | 92025: Escondido | 2021-01-10 | San Diego | 73 | 3561 | 51820 | |
910250 | 910250 | 92026 | 92026: Escondido | 2021-01-10 | San Diego | 73 | 3247 | 56272 | |
910251 | 910251 | 92027 | 92027: Escondido | 2021-01-10 | San Diego | 73 | 4112 | 54202 | |
910252 | 910252 | 92028 | 92028: Fallbrook | 2021-01-10 | San Diego | 73 | 2424 | 49009 | |
910253 | 910253 | 92029 | 92029: Escondido | 2021-01-10 | San Diego | 73 | 906 | 21201 | |
910254 | 910254 | 92036 | 92036: Julian | 2021-01-10 | San Diego | 73 | 55 | 0 | |
910255 | 910255 | 92037 | 92037: La Jolla | 2021-01-10 | San Diego | 73 | 1063 | 43283 | |
910256 | 910256 | 92040 | 92040: Lakeside | 2021-01-10 | San Diego | 73 | 1932 | 44105 | |
910257 | 910257 | 92054 | 92054: Oceanside | 2021-01-10 | San Diego | 73 | 1738 | 42441 | |
910258 | 910258 | 92055 | 92055: Camp Pendleton | 2021-01-10 | San Diego | 73 | 315 | 36726 | |
910259 | 910259 | 92056 | 92056: Oceanside | 2021-01-10 | San Diego | 73 | 2420 | 55369 | |
910260 | 910260 | 92057 | 92057: Oceanside | 2021-01-10 | San Diego | 73 | 2744 | 55753 | |
910261 | 910261 | 92058 | 92058: Oceanside | 2021-01-10 | San Diego | 73 | 1502 | 24170 | |
910262 | 910262 | 92059 | 92059: Pala | 2021-01-10 | San Diego | 73 | 177 | 0 | |
910263 | 910263 | 92060 | 92060: Palomar Mountain | 2021-01-10 | San Diego | 73 | 8 | 0 | |
910264 | 910264 | 92061 | 92061: Pauma Valley | 2021-01-10 | San Diego | 73 | 126 | 0 | |
910265 | 910265 | 92064 | 92064: Poway | 2021-01-10 | San Diego | 73 | 1493 | 50435 | |
910266 | 910266 | 92065 | 92065: Ramona | 2021-01-10 | San Diego | 73 | 1688 | 36256 | |
910267 | 910267 | 92066 | 92066: Ranchita | 2021-01-10 | San Diego | 73 | 10 | 0 | |
910268 | 910268 | 92067 | 92067: Rancho Santa Fe | 2021-01-10 | San Diego | 73 | 250 | 0 | |
910269 | 910269 | 92069 | 92069: San Marcos | 2021-01-10 | San Diego | 73 | 3052 | 51172 | |
910270 | 910270 | 92070 | 92070: Santa Ysabel | 2021-01-10 | San Diego | 73 | 49 | 0 | |
910271 | 910271 | 92071 | 92071: Santee | 2021-01-10 | San Diego | 73 | 2410 | 58213 | |
910272 | 910272 | 92075 | 92075: Solana Beach | 2021-01-10 | San Diego | 73 | 276 | 12976 | |
910273 | 910273 | 92078 | 92078: San Marcos | 2021-01-10 | San Diego | 73 | 2195 | 50973 | |
910274 | 910274 | 92081 | 92081: Vista | 2021-01-10 | San Diego | 73 | 1180 | 32889 | |
910275 | 910275 | 92082 | 92082: Valley Center | 2021-01-10 | San Diego | 73 | 924 | 17680 | |
910276 | 910276 | 92083 | 92083: Vista | 2021-01-10 | San Diego | 73 | 3084 | 39155 | |
910277 | 910277 | 92084 | 92084: Vista | 2021-01-10 | San Diego | 73 | 3245 | 49040 | |
910278 | 910278 | 92086 | 92086: Warner Springs | 2021-01-10 | San Diego | 73 | 42 | 0 | |
910279 | 910279 | 92091 | 92091: Rancho Santa Fe | 2021-01-10 | San Diego | 73 | 22 | 0 | |
910280 | 910280 | 92093 | 92093: La Jolla | 2021-01-10 | San Diego | 73 | 137 | 11299 | |
910281 | 910281 | 92096 | 92096: San Marcos | 2021-01-10 | San Diego | 73 | 5 | 0 | |
910282 | 910282 | 92101 | 92101: San Diego | 2021-01-10 | San Diego | 73 | 2926 | 60694 | |
910283 | 910283 | 92102 | 92102: San Diego | 2021-01-10 | San Diego | 73 | 3101 | 42331 | |
910284 | 910284 | 92103 | 92103: San Diego | 2021-01-10 | San Diego | 73 | 1281 | 39687 | |
910285 | 910285 | 92104 | 92104: San Diego | 2021-01-10 | San Diego | 73 | 1946 | 52095 | |
910286 | 910286 | 92105 | 92105: San Diego | 2021-01-10 | San Diego | 73 | 4862 | 67077 | |
910287 | 910287 | 92106 | 92106: San Diego | 2021-01-10 | San Diego | 73 | 535 | 22209 | |
910288 | 910288 | 92107 | 92107: San Diego | 2021-01-10 | San Diego | 73 | 755 | 30971 | |
910289 | 910289 | 92108 | 92108: San Diego | 2021-01-10 | San Diego | 73 | 1091 | 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 );