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 county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: hpi_quartile
Link | rowid | id | hpi_quartile | county ▼ | fips | city |
---|---|---|---|---|---|---|
959 | 959 | 94501 | 4 | Alameda | 1 | Alameda |
960 | 960 | 94502 | 4 | Alameda | 1 | Alameda |
988 | 988 | 94536 | 4 | Alameda | 1 | Fremont |
989 | 989 | 94538 | 4 | Alameda | 1 | Fremont |
990 | 990 | 94539 | 4 | Alameda | 1 | Fremont |
991 | 991 | 94541 | 2 | Alameda | 1 | Fairview |
992 | 992 | 94542 | 4 | Alameda | 1 | Hayward |
993 | 993 | 94544 | 2 | Alameda | 1 | |
994 | 994 | 94545 | 3 | Alameda | 1 | Hayward |
995 | 995 | 94546 | 4 | Alameda | 1 | |
999 | 999 | 94550 | 4 | Alameda | 1 | |
1000 | 1000 | 94551 | 4 | Alameda | 1 | Livermore |
1001 | 1001 | 94552 | 4 | Alameda | 1 | Castro Valley |
1003 | 1003 | 94555 | 4 | Alameda | 1 | Fremont |
1007 | 1007 | 94560 | 3 | Alameda | 1 | Newark |
1012 | 1012 | 94566 | 4 | Alameda | 1 | Pleasanton |
1014 | 1014 | 94568 | 4 | Alameda | 1 | Dublin |
1020 | 1020 | 94577 | 3 | Alameda | 1 | San Leandro |
1021 | 1021 | 94578 | 2 | Alameda | 1 | Castro Valley |
1022 | 1022 | 94579 | 3 | Alameda | 1 | San Leandro |
1023 | 1023 | 94580 | 3 | Alameda | 1 | Ashland |
1027 | 1027 | 94586 | 4 | Alameda | 1 | |
1028 | 1028 | 94587 | 3 | Alameda | 1 | Hayward |
1029 | 1029 | 94588 | 4 | Alameda | 1 | Hayward |
1039 | 1039 | 94601 | 1 | Alameda | 1 | Oakland |
1040 | 1040 | 94602 | 3 | Alameda | 1 | Oakland |
1041 | 1041 | 94603 | 1 | Alameda | 1 | Oakland |
1042 | 1042 | 94605 | 2 | Alameda | 1 | Oakland |
1043 | 1043 | 94606 | 2 | Alameda | 1 | Oakland |
1044 | 1044 | 94607 | 2 | Alameda | 1 | Oakland |
1045 | 1045 | 94608 | 3 | Alameda | 1 | Oakland |
1046 | 1046 | 94609 | 3 | Alameda | 1 | Oakland |
1047 | 1047 | 94610 | 4 | Alameda | 1 | Oakland |
1048 | 1048 | 94611 | 4 | Alameda | 1 | Oakland |
1049 | 1049 | 94612 | 2 | Alameda | 1 | Oakland |
1050 | 1050 | 94618 | 4 | Alameda | 1 | Oakland |
1051 | 1051 | 94619 | 3 | Alameda | 1 | Oakland |
1052 | 1052 | 94621 | 1 | Alameda | 1 | Oakland |
1053 | 1053 | 94702 | 4 | Alameda | 1 | Berkeley |
1054 | 1054 | 94703 | 4 | Alameda | 1 | Berkeley |
1055 | 1055 | 94704 | 2 | Alameda | 1 | Oakland |
1056 | 1056 | 94705 | 4 | Alameda | 1 | Berkeley |
1057 | 1057 | 94706 | 4 | Alameda | 1 | Albany |
1058 | 1058 | 94707 | 4 | Alameda | 1 | Berkeley |
1059 | 1059 | 94708 | 4 | Alameda | 1 | Berkeley |
1060 | 1060 | 94709 | 4 | Alameda | 1 | Berkeley |
1061 | 1061 | 94710 | 4 | Alameda | 1 | Albany |
1655 | 1655 | 96120 | 2 | Alpine | 3 | |
1374 | 1374 | 95601 | 3 | Amador | 5 | |
1396 | 1396 | 95629 | 3 | Amador | 5 | |
1407 | 1407 | 95640 | 3 | Amador | 5 | Ione |
1409 | 1409 | 95642 | 3 | Amador | 5 | |
1423 | 1423 | 95665 | 3 | Amador | 5 | Pine Grove |
1424 | 1424 | 95666 | 2 | Amador | 5 | |
1427 | 1427 | 95669 | 3 | Amador | 5 | |
1432 | 1432 | 95675 | 2 | Amador | 5 | |
1440 | 1440 | 95685 | 2 | Amador | 5 | |
1444 | 1444 | 95689 | 3 | Amador | 5 | |
1453 | 1453 | 95699 | 2 | Amador | 5 | |
1506 | 1506 | 95914 | 1 | Butte | 7 | |
1507 | 1507 | 95916 | 1 | Butte | 7 | Berry Creek |
1508 | 1508 | 95917 | 2 | Butte | 7 | |
1515 | 1515 | 95926 | 2 | Butte | 7 | Chico |
1516 | 1516 | 95928 | 2 | Butte | 7 | Butte Creek Canyon |
1522 | 1522 | 95938 | 3 | Butte | 7 | |
1524 | 1524 | 95941 | 1 | Butte | 7 | |
1525 | 1525 | 95942 | 3 | Butte | 7 | Forest Ranch |
1531 | 1531 | 95948 | 2 | Butte | 7 | |
1536 | 1536 | 95954 | 2 | Butte | 7 | Magalia |
1545 | 1545 | 95965 | 1 | Butte | 7 | |
1546 | 1546 | 95966 | 1 | Butte | 7 | Oroville East |
1547 | 1547 | 95968 | 1 | Butte | 7 | |
1548 | 1548 | 95969 | 2 | Butte | 7 | Paradise |
1551 | 1551 | 95973 | 3 | Butte | 7 | Chico |
1552 | 1552 | 95974 | 1 | Butte | 7 | |
1555 | 1555 | 95978 | 1 | Butte | 7 | |
1177 | 1177 | 95222 | 2 | Calaveras | 9 | Angels |
1178 | 1178 | 95223 | 3 | Calaveras | 9 | Avery |
1179 | 1179 | 95224 | 3 | Calaveras | 9 | |
1180 | 1180 | 95225 | 2 | Calaveras | 9 | |
1182 | 1182 | 95228 | 3 | Calaveras | 9 | |
1185 | 1185 | 95232 | 3 | Calaveras | 9 | |
1190 | 1190 | 95245 | 1 | Calaveras | 9 | |
1191 | 1191 | 95246 | 1 | Calaveras | 9 | |
1192 | 1192 | 95247 | 1 | Calaveras | 9 | |
1193 | 1193 | 95248 | 2 | Calaveras | 9 | |
1194 | 1194 | 95249 | 2 | Calaveras | 9 | |
1195 | 1195 | 95251 | 2 | Calaveras | 9 | |
1196 | 1196 | 95252 | 2 | Calaveras | 9 | |
1197 | 1197 | 95254 | 4 | Calaveras | 9 | |
1198 | 1198 | 95255 | 1 | Calaveras | 9 | |
1199 | 1199 | 95257 | 1 | Calaveras | 9 | |
1505 | 1505 | 95912 | 2 | Colusa | 11 | College City |
1517 | 1517 | 95932 | 2 | Colusa | 11 | |
1533 | 1533 | 95950 | 1 | Colusa | 11 | |
1537 | 1537 | 95955 | 2 | Colusa | 11 | |
1556 | 1556 | 95979 | 1 | Colusa | 11 | |
1562 | 1562 | 95987 | 2 | Colusa | 11 | |
962 | 962 | 94505 | 4 | Contra Costa | 13 | Discovery Bay |
963 | 963 | 94506 | 4 | Contra Costa | 13 | Danville |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "cdph-hpi-zipcodes" ( [id] INTEGER, [hpi_quartile] INTEGER, [county] TEXT, [fips] INTEGER, [city] TEXT );