cdph-hpi-zipcodes
Data license: Reusing the data · Data source: LA Times California coronavirus data · About: README
- id
- The unique identifer of the ZIP Code.
- hpi_quartile
- The ranked quartile that contains the ZIP Code’s Healthy Places Index score. One is the lowest. Four is the highest.
- county
- The name of the county.
- fips
- The FIPS code given to the county by the federal government. Can be used to merge with other data sources.
- city
- The city the ZIP Code falls within
1,678 rows sorted by city
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: hpi_quartile
Link | rowid | id | hpi_quartile | county | fips | city ▼ |
---|---|---|---|---|---|---|
13 | 13 | 90014 | 2 | Los Angeles | 37 | |
85 | 85 | 90263 | 4 | Los Angeles | 37 | |
86 | 86 | 90265 | 4 | Los Angeles | 37 | |
146 | 146 | 90742 | 4 | Orange | 59 | |
147 | 147 | 90743 | 4 | Orange | 59 | |
166 | 166 | 91008 | 4 | Los Angeles | 37 | |
175 | 175 | 91046 | 2 | Los Angeles | 37 | |
181 | 181 | 91107 | 4 | Los Angeles | 37 | |
215 | 215 | 91354 | 4 | Los Angeles | 37 | |
218 | 218 | 91360 | 4 | Ventura | 111 | |
224 | 224 | 91381 | 4 | Los Angeles | 37 | |
225 | 225 | 91384 | 3 | Los Angeles | 37 | |
227 | 227 | 91390 | 4 | Los Angeles | 37 | |
251 | 251 | 91710 | 3 | San Bernardino | 71 | |
255 | 255 | 91724 | 3 | Los Angeles | 37 | |
261 | 261 | 91739 | 4 | San Bernardino | 71 | |
272 | 272 | 91759 | 4 | San Bernardino | 71 | |
294 | 294 | 91901 | 3 | San Diego | 73 | |
296 | 296 | 91905 | 1 | San Diego | 73 | |
297 | 297 | 91906 | 1 | San Diego | 73 | |
303 | 303 | 91916 | 2 | San Diego | 73 | |
304 | 304 | 91917 | 1 | San Diego | 73 | |
305 | 305 | 91931 | 3 | San Diego | 73 | |
307 | 307 | 91934 | 1 | San Diego | 73 | |
308 | 308 | 91935 | 3 | San Diego | 73 | |
312 | 312 | 91948 | 4 | San Diego | 73 | |
314 | 314 | 91962 | 3 | San Diego | 73 | |
315 | 315 | 91963 | 2 | San Diego | 73 | |
319 | 319 | 92004 | 2 | San Diego | 73 | |
331 | 331 | 92026 | 2 | San Diego | 73 | |
334 | 334 | 92029 | 3 | San Diego | 73 | |
335 | 335 | 92036 | 2 | San Diego | 73 | |
337 | 337 | 92040 | 3 | San Diego | 73 | |
339 | 339 | 92055 | 3 | San Diego | 73 | |
343 | 343 | 92059 | 2 | San Diego | 73 | |
344 | 344 | 92060 | 3 | San Diego | 73 | |
345 | 345 | 92061 | 2 | San Diego | 73 | |
348 | 348 | 92066 | 1 | San Diego | 73 | |
350 | 350 | 92069 | 2 | San Diego | 73 | |
351 | 351 | 92070 | 2 | San Diego | 73 | |
356 | 356 | 92082 | 3 | San Diego | 73 | |
358 | 358 | 92084 | 2 | San Diego | 73 | |
359 | 359 | 92086 | 1 | San Diego | 73 | |
360 | 360 | 92091 | 4 | San Diego | 73 | |
385 | 385 | 92127 | 4 | San Diego | 73 | |
399 | 399 | 92225 | 1 | Riverside | 65 | |
401 | 401 | 92230 | 1 | Riverside | 65 | |
403 | 403 | 92233 | 1 | Imperial | 25 | |
406 | 406 | 92239 | 2 | Riverside | 65 | |
407 | 407 | 92240 | 1 | Riverside | 65 | |
409 | 409 | 92242 | 1 | San Bernardino | 71 | |
411 | 411 | 92249 | 1 | Imperial | 25 | |
413 | 413 | 92251 | 3 | Imperial | 25 | |
416 | 416 | 92254 | 1 | Riverside | 65 | |
418 | 418 | 92257 | 1 | Imperial | 25 | |
419 | 419 | 92258 | 1 | Riverside | 65 | |
420 | 420 | 92259 | 1 | Imperial | 25 | |
424 | 424 | 92266 | 1 | Imperial | 25 | |
425 | 425 | 92268 | 2 | San Bernardino | 71 | |
427 | 427 | 92273 | 1 | Imperial | 25 | |
428 | 428 | 92274 | 1 | Riverside | 65 | |
429 | 429 | 92275 | 1 | Imperial | 25 | |
431 | 431 | 92277 | 1 | San Bernardino | 71 | |
432 | 432 | 92278 | 2 | San Bernardino | 71 | |
433 | 433 | 92281 | 1 | Imperial | 25 | |
434 | 434 | 92282 | 1 | Riverside | 65 | |
435 | 435 | 92283 | 1 | Imperial | 25 | |
436 | 436 | 92284 | 1 | San Bernardino | 71 | |
439 | 439 | 92304 | 2 | San Bernardino | 71 | |
442 | 442 | 92309 | 1 | San Bernardino | 71 | |
443 | 443 | 92310 | 1 | San Bernardino | 71 | |
446 | 446 | 92314 | 2 | San Bernardino | 71 | |
450 | 450 | 92321 | 3 | San Bernardino | 71 | |
453 | 453 | 92327 | 1 | San Bernardino | 71 | |
454 | 454 | 92328 | 2 | Inyo | 27 | |
455 | 455 | 92332 | 2 | San Bernardino | 71 | |
456 | 456 | 92333 | 3 | San Bernardino | 71 | |
457 | 457 | 92335 | 1 | San Bernardino | 71 | |
460 | 460 | 92339 | 3 | San Bernardino | 71 | |
461 | 461 | 92342 | 2 | San Bernardino | 71 | |
465 | 465 | 92347 | 2 | San Bernardino | 71 | |
469 | 469 | 92358 | 1 | San Bernardino | 71 | |
471 | 471 | 92363 | 1 | San Bernardino | 71 | |
472 | 472 | 92365 | 1 | San Bernardino | 71 | |
473 | 473 | 92368 | 1 | San Bernardino | 71 | |
476 | 476 | 92373 | 3 | San Bernardino | 71 | |
480 | 480 | 92378 | 2 | San Bernardino | 71 | |
481 | 481 | 92382 | 3 | San Bernardino | 71 | |
482 | 482 | 92384 | 4 | Inyo | 27 | |
483 | 483 | 92386 | 1 | San Bernardino | 71 | |
484 | 484 | 92389 | 2 | Inyo | 27 | |
485 | 485 | 92391 | 2 | San Bernardino | 71 | |
490 | 490 | 92398 | 1 | San Bernardino | 71 | |
495 | 495 | 92407 | 1 | San Bernardino | 71 | |
510 | 510 | 92536 | 2 | Riverside | 65 | |
511 | 511 | 92539 | 1 | Riverside | 65 | |
513 | 513 | 92544 | 1 | Riverside | 65 | |
515 | 515 | 92548 | 1 | Riverside | 65 | |
516 | 516 | 92549 | 3 | Riverside | 65 | |
519 | 519 | 92555 | 2 | Riverside | 65 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hpi-zipcodes" ( [id] INTEGER, [hpi_quartile] INTEGER, [county] TEXT, [fips] INTEGER, [city] TEXT );