cdph-hpi-zipcodes

Table actions

California's Department of Public Health has assigned each California ZIP Code a community health score by combining a variety of economic and social indicators. It is known as the Healthy Places Index. The quartile that each ZIP Code falls within was released in response to a request by The Times.

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

✎ View and edit SQL

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

Suggested facets: hpi_quartile

Link rowid ▼ id hpi_quartile county fips city
1 1 90001 1 Los Angeles 37 Los Angeles
2 2 90002 1 Los Angeles 37 Los Angeles
3 3 90003 1 Los Angeles 37 Los Angeles
4 4 90004 1 Los Angeles 37 Los Angeles
5 5 90005 1 Los Angeles 37 Los Angeles
6 6 90006 1 Los Angeles 37 Los Angeles
7 7 90007 1 Los Angeles 37 Los Angeles
8 8 90008 1 Los Angeles 37 Los Angeles
9 9 90010 2 Los Angeles 37 Los Angeles
10 10 90011 1 Los Angeles 37 Los Angeles
11 11 90012 1 Los Angeles 37 Los Angeles
12 12 90013 1 Los Angeles 37 Los Angeles
13 13 90014 2 Los Angeles 37  
14 14 90015 1 Los Angeles 37 Los Angeles
15 15 90016 1 Los Angeles 37 Los Angeles
16 16 90017 1 Los Angeles 37 Los Angeles
17 17 90018 1 Los Angeles 37 Los Angeles
18 18 90019 2 Los Angeles 37 Los Angeles
19 19 90020 2 Los Angeles 37 Los Angeles
20 20 90021 2 Los Angeles 37 Los Angeles
21 21 90022 1 Los Angeles 37 East Los Angeles
22 22 90023 1 Los Angeles 37 Los Angeles
23 23 90024 3 Los Angeles 37 Los Angeles
24 24 90025 4 Los Angeles 37 Los Angeles
25 25 90026 2 Los Angeles 37 Los Angeles
26 26 90027 2 Los Angeles 37 Los Angeles
27 27 90028 1 Los Angeles 37 Los Angeles
28 28 90029 1 Los Angeles 37 Los Angeles
29 29 90031 1 Los Angeles 37 Los Angeles
30 30 90032 1 Los Angeles 37 Los Angeles
31 31 90033 1 Los Angeles 37 Los Angeles
32 32 90034 3 Los Angeles 37 Los Angeles
33 33 90035 3 Los Angeles 37 Los Angeles
34 34 90036 4 Los Angeles 37 Los Angeles
35 35 90037 1 Los Angeles 37 Los Angeles
36 36 90038 1 Los Angeles 37 Los Angeles
37 37 90039 3 Los Angeles 37 Los Angeles
38 38 90040 1 Los Angeles 37 Commerce
39 39 90041 3 Los Angeles 37 Los Angeles
40 40 90042 2 Los Angeles 37 Los Angeles
41 41 90043 1 Los Angeles 37 Los Angeles
42 42 90044 1 Los Angeles 37 Los Angeles
43 43 90045 3 Los Angeles 37 Los Angeles
44 44 90046 3 Los Angeles 37 Los Angeles
45 45 90047 1 Los Angeles 37 Los Angeles
46 46 90048 4 Los Angeles 37 Los Angeles
47 47 90049 4 Los Angeles 37 Los Angeles
48 48 90056 3 Los Angeles 37 Ladera Heights
49 49 90057 1 Los Angeles 37 Los Angeles
50 50 90058 1 Los Angeles 37 Los Angeles
51 51 90059 1 Los Angeles 37 Los Angeles
52 52 90061 1 Los Angeles 37 Los Angeles
53 53 90062 1 Los Angeles 37 Los Angeles
54 54 90063 1 Los Angeles 37 Los Angeles
55 55 90064 4 Los Angeles 37 Los Angeles
56 56 90065 2 Los Angeles 37 Los Angeles
57 57 90066 3 Los Angeles 37 Los Angeles
58 58 90067 4 Los Angeles 37 Los Angeles
59 59 90068 3 Los Angeles 37 Los Angeles
60 60 90069 4 Los Angeles 37 Los Angeles
61 61 90071 2 Los Angeles 37 Los Angeles
62 62 90077 4 Los Angeles 37 Los Angeles
63 63 90094 4 Los Angeles 37 Los Angeles
64 64 90201 1 Los Angeles 37 Bell
65 65 90210 4 Los Angeles 37 Los Angeles
66 66 90211 3 Los Angeles 37 Beverly Hills
67 67 90212 4 Los Angeles 37 Beverly Hills
68 68 90220 1 Los Angeles 37 West Rancho Dominguez
69 69 90221 1 Los Angeles 37 Compton
70 70 90222 1 Los Angeles 37 Compton
71 71 90230 4 Los Angeles 37 Los Angeles
72 72 90232 3 Los Angeles 37 Culver City
73 73 90240 3 Los Angeles 37 Downey
74 74 90241 2 Los Angeles 37 Downey
75 75 90242 2 Los Angeles 37 Downey
76 76 90245 4 Los Angeles 37 El Segundo
77 77 90247 2 Los Angeles 37 Los Angeles
78 78 90248 3 Los Angeles 37 Los Angeles
79 79 90249 2 Los Angeles 37 Gardena
80 80 90250 2 Los Angeles 37 Hawthorne
81 81 90254 4 Los Angeles 37 Hermosa Beach
82 82 90255 1 Los Angeles 37 Huntington Park
83 83 90260 2 Los Angeles 37 Lawndale
84 84 90262 1 Los Angeles 37 Lynwood
85 85 90263 4 Los Angeles 37  
86 86 90265 4 Los Angeles 37  
87 87 90266 4 Los Angeles 37 Manhattan Beach
88 88 90270 1 Los Angeles 37 Maywood
89 89 90272 4 Los Angeles 37 Los Angeles
90 90 90274 4 Los Angeles 37 Rolling Hills Estates
91 91 90275 4 Los Angeles 37 Rancho Palos Verdes
92 92 90277 4 Los Angeles 37 Redondo Beach
93 93 90278 4 Los Angeles 37 Redondo Beach
94 94 90280 1 Los Angeles 37 South Gate
95 95 90290 4 Los Angeles 37 Topanga
96 96 90291 4 Los Angeles 37 Los Angeles
97 97 90292 4 Los Angeles 37 Los Angeles
98 98 90293 4 Los Angeles 37 Los Angeles
99 99 90301 1 Los Angeles 37 Inglewood
100 100 90302 2 Los Angeles 37 Inglewood

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cdph-hpi-zipcodes" (
   [id] INTEGER,
   [hpi_quartile] INTEGER,
   [county] TEXT,
   [fips] INTEGER,
   [city] TEXT
);