zipcodes

Zip code to city mapping

Data source: simplemaps

33,783 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ zip lat lng city state_id state_name zcta parent_zcta population density county_fips county_name county_weights county_names_all county_fips_all imprecise military timezone
1 1 601 18.18027 -66.75266 Adjuntas PR Puerto Rico 1   16721 100.2 72001 Adjuntas {"72001": 98.74, "72141": 1.26} Adjuntas|Utuado 72001|72141 0 0 America/Puerto_Rico
2 2 602 18.36075 -67.17541 Aguada PR Puerto Rico 1   37510 477.6 72003 Aguada {"72003": 100} Aguada 72003 0 0 America/Puerto_Rico
3 3 603 18.45744 -67.12225 Aguadilla PR Puerto Rico 1   48317 543.1 72005 Aguadilla {"72005": 99.76, "72099": 0.24} Aguadilla|Moca 72005|72099 0 0 America/Puerto_Rico
4 4 606 18.16585 -66.93716 Maricao PR Puerto Rico 1   5435 47.3 72093 Maricao {"72093": 82.27, "72153": 11.66, "72121": 6.06} Maricao|Yauco|Sabana Grande 72093|72153|72121 0 0 America/Puerto_Rico
5 5 610 18.2911 -67.12243 Anasco PR Puerto Rico 1   25413 264.4 72011 Añasco {"72011": 96.71, "72099": 2.82, "72083": 0.37, "72003": 0.1} Añasco|Moca|Las Marías|Aguada 72011|72099|72083|72003 0 0 America/Puerto_Rico
6 6 611 18.27698 -66.80688 Angeles PR Puerto Rico 1   1522 55.2 72141 Utuado {"72141": 100} Utuado 72141 0 0 America/Puerto_Rico
7 7 612 18.41283 -66.7051 Arecibo PR Puerto Rico 1   62462 316.7 72013 Arecibo {"72013": 98.94, "72065": 0.94, "72017": 0.11} Arecibo|Hatillo|Barceloneta 72013|72065|72017 0 0 America/Puerto_Rico
8 8 616 18.41878 -66.6679 Bajadero PR Puerto Rico 1   9836 348.9 72013 Arecibo {"72013": 100} Arecibo 72013 0 0 America/Puerto_Rico
9 9 617 18.44598 -66.56006 Barceloneta PR Puerto Rico 1   22699 477.5 72017 Barceloneta {"72017": 99.63, "72054": 0.37} Barceloneta|Florida 72017|72054 0 0 America/Puerto_Rico
10 10 622 17.98892 -67.1566 Boqueron PR Puerto Rico 1   7950 98.5 72023 Cabo Rojo {"72023": 100} Cabo Rojo 72023 0 0 America/Puerto_Rico
11 11 623 18.08429 -67.15336 Cabo Rojo PR Puerto Rico 1   39005 384.2 72023 Cabo Rojo {"72023": 100} Cabo Rojo 72023 0 0 America/Puerto_Rico
12 12 624 18.05905 -66.71932 Penuelas PR Puerto Rico 1   21374 175.7 72111 Peñuelas {"72111": 94.94, "72113": 5.06} Peñuelas|Ponce 72111|72113 0 0 America/Puerto_Rico
13 13 627 18.41905 -66.86037 Camuy PR Puerto Rico 1   32753 272.7 72027 Camuy {"72027": 100} Camuy 72027 0 0 America/Puerto_Rico
14 14 631 18.1852 -66.83169 Castaner PR Puerto Rico 1   1357 167.6 72081 Lares {"72081": 50.58, "72001": 49.42} Lares|Adjuntas 72081|72001 0 0 America/Puerto_Rico
15 15 637 18.081 -66.94659 Sabana Grande PR Puerto Rico 1   22884 251.2 72121 Sabana Grande {"72121": 93.98, "72125": 4.22, "72079": 1.8} Sabana Grande|San Germán|Lajas 72121|72125|72079 0 0 America/Puerto_Rico
16 16 638 18.28462 -66.5137 Ciales PR Puerto Rico 1   17410 94.1 72039 Ciales {"72039": 91.88, "72107": 7.48, "72091": 0.64} Ciales|Orocovis|Manatí 72039|72107|72091 0 0 America/Puerto_Rico
17 17 641 18.26742 -66.70212 Utuado PR Puerto Rico 1   23962 110.0 72141 Utuado {"72141": 100} Utuado 72141 0 0 America/Puerto_Rico
18 18 646 18.43251 -66.28429 Dorado PR Puerto Rico 1   36099 662.1 72051 Dorado {"72051": 97.18, "72143": 2.82} Dorado|Vega Alta 72051|72143 0 0 America/Puerto_Rico
19 19 647 17.96667 -66.94266 Ensenada PR Puerto Rico 1   4611 112.6 72055 Guánica {"72055": 98.28, "72079": 1.72} Guánica|Lajas 72055|72079 0 0 America/Puerto_Rico
20 20 650 18.34487 -66.58347 Florida PR Puerto Rico 1   13457 163.8 72054 Florida {"72054": 47.41, "72141": 41.94, "72091": 4.27, "72039": 2.9, "72013": 2.41, "72017": 1.07} Florida|Utuado|Manatí|Ciales|Arecibo|Barceloneta 72054|72141|72091|72039|72013|72017 0 0 America/Puerto_Rico
21 21 652 18.45614 -66.60194 Garrochales PR Puerto Rico 1   4492 269.2 72013 Arecibo {"72013": 100} Arecibo 72013 0 0 America/Puerto_Rico
22 22 653 17.99413 -66.90266 Guanica PR Puerto Rico 1   8665 151.5 72055 Guánica {"72055": 97.47, "72121": 2.53} Guánica|Sabana Grande 72055|72121 0 0 America/Puerto_Rico
23 23 656 18.04186 -66.79123 Guayanilla PR Puerto Rico 1   17815 163.2 72059 Guayanilla {"72059": 97.01, "72153": 2.99} Guayanilla|Yauco 72059|72153 0 0 America/Puerto_Rico
24 24 659 18.41036 -66.79691 Hatillo PR Puerto Rico 1   37203 349.9 72065 Hatillo {"72065": 100} Hatillo 72065 0 0 America/Puerto_Rico
25 25 660 18.13412 -67.11399 Hormigueros PR Puerto Rico 1   15439 526.7 72067 Hormigueros {"72067": 100} Hormigueros 72067 0 0 America/Puerto_Rico
26 26 662 18.46622 -67.01508 Isabela PR Puerto Rico 1   40705 380.8 72071 Isabela {"72071": 100} Isabela 72071 0 0 America/Puerto_Rico
27 27 664 18.21064 -66.59066 Jayuya PR Puerto Rico 1   14816 121.9 72073 Jayuya {"72073": 94.96, "72141": 5.04} Jayuya|Utuado 72073|72141 0 0 America/Puerto_Rico
28 28 667 18.01246 -67.0417 Lajas PR Puerto Rico 1   23116 148.3 72079 Lajas {"72079": 98.05, "72125": 1.95} Lajas|San Germán 72079|72125 0 0 America/Puerto_Rico
29 29 669 18.27019 -66.86727 Lares PR Puerto Rico 1   27534 165.8 72081 Lares {"72081": 93.38, "72141": 3.8, "72083": 2.7, "72131": 0.12} Lares|Utuado|Las Marías|San Sebastián 72081|72141|72083|72131 0 0 America/Puerto_Rico
30 30 670 18.23782 -66.98852 Las Marias PR Puerto Rico 1   8553 71.0 72083 Las Marías {"72083": 95.63, "72011": 3.6, "72097": 0.45, "72093": 0.32} Las Marías|Añasco|Mayagüez|Maricao 72083|72011|72097|72093 0 0 America/Puerto_Rico
31 31 674 18.42229 -66.4891 Manati PR Puerto Rico 1   39288 349.1 72091 Manatí {"72091": 99.45, "72145": 0.55} Manatí|Vega Baja 72091|72145 0 0 America/Puerto_Rico
32 32 676 18.37897 -67.08098 Moca PR Puerto Rico 1   36836 291.1 72099 Moca {"72099": 99.19, "72003": 0.81} Moca|Aguada 72099|72003 0 0 America/Puerto_Rico
33 33 677 18.33535 -67.23155 Rincon PR Puerto Rico 1   15432 409.0 72117 Rincón {"72117": 98.0, "72011": 1.2, "72003": 0.8} Rincón|Añasco|Aguada 72117|72011|72003 0 0 America/Puerto_Rico
34 34 678 18.42949 -66.93016 Quebradillas PR Puerto Rico 1   24848 329.2 72115 Quebradillas {"72115": 77.06, "72071": 17.17, "72131": 5.77} Quebradillas|Isabela|San Sebastián 72115|72071|72131 0 0 America/Puerto_Rico
35 35 680 18.16307 -67.36122 Mayaguez PR Puerto Rico 1   42817 257.1 72097 Mayagüez {"72097": 94.1, "72125": 3.46, "72011": 2.44} Mayagüez|San Germán|Añasco 72097|72125|72011 0 0 America/Puerto_Rico
36 36 682 18.22415 -67.15309 Mayaguez PR Puerto Rico 1   29939 708.7 72097 Mayagüez {"72097": 99.83, "72067": 0.17} Mayagüez|Hormigueros 72097|72067 0 0 America/Puerto_Rico
37 37 683 18.10926 -67.03803 San German PR Puerto Rico 1   29431 230.5 72125 San Germán {"72125": 100} San Germán 72125 0 0 America/Puerto_Rico
38 38 685 18.33656 -66.97518 San Sebastian PR Puerto Rico 1   40323 197.8 72131 San Sebastián {"72131": 87.74, "72071": 11.31, "72099": 0.95} San Sebastián|Isabela|Moca 72131|72071|72099 0 0 America/Puerto_Rico
39 39 687 18.31707 -66.42029 Morovis PR Puerto Rico 1   28534 283.4 72101 Morovis {"72101": 100} Morovis 72101 0 0 America/Puerto_Rico
40 40 688 18.3807 -66.62496 Sabana Hoyos PR Puerto Rico 1   10985 130.5 72013 Arecibo {"72013": 100} Arecibo 72013 0 0 America/Puerto_Rico
41 41 690 18.49363 -67.09734 San Antonio PR Puerto Rico 1   6275 1071.5 72005 Aguadilla {"72005": 100} Aguadilla 72005 0 0 America/Puerto_Rico
42 42 692 18.40905 -66.33768 Vega Alta PR Puerto Rico 1   32717 476.2 72143 Vega Alta {"72143": 99.87, "72145": 0.13} Vega Alta|Vega Baja 72143|72145 0 0 America/Puerto_Rico
43 43 693 18.42633 -66.39811 Vega Baja PR Puerto Rico 1   55725 484.5 72145 Vega Baja {"72145": 98.28, "72143": 1.43, "72091": 0.29} Vega Baja|Vega Alta|Manatí 72145|72143|72091 0 0 America/Puerto_Rico
44 44 694 18.48327 -66.39269 Vega Baja PR Puerto Rico 1   125 60.4 72145 Vega Baja {"72145": 100} Vega Baja 72145 0 0 America/Puerto_Rico
45 45 698 18.07274 -66.85519 Yauco PR Puerto Rico 1   32945 203.0 72153 Yauco {"72153": 97.82, "72059": 2.18} Yauco|Guayanilla 72153|72059 0 0 America/Puerto_Rico
46 46 703 18.24739 -66.13143 Aguas Buenas PR Puerto Rico 1   24642 306.7 72007 Aguas Buenas {"72007": 93.07, "72041": 3.61, "72045": 3.32} Aguas Buenas|Cidra|Comerío 72007|72041|72045 0 0 America/Puerto_Rico
47 47 704 17.97442 -66.22888 Aguirre PR Puerto Rico 1   6433 276.1 72123 Salinas {"72123": 97.38, "72057": 2.62} Salinas|Guayama 72123|72057 0 0 America/Puerto_Rico
48 48 705 18.1294 -66.26653 Aibonito PR Puerto Rico 1   24475 310.8 72009 Aibonito {"72009": 97.19, "72043": 2.81} Aibonito|Coamo 72009|72043 0 0 America/Puerto_Rico
49 49 707 18.01752 -65.92127 Maunabo PR Puerto Rico 1   10400 191.9 72095 Maunabo {"72095": 100} Maunabo 72095 0 0 America/Puerto_Rico
50 50 714 17.9981 -66.05635 Arroyo PR Puerto Rico 1   15573 400.8 72015 Arroyo {"72015": 100} Arroyo 72015 0 0 America/Puerto_Rico
51 51 715 17.99738 -66.56104 Mercedita PR Puerto Rico 1   2003 60.9 72113 Ponce {"72113": 99.09, "72075": 0.91} Ponce|Juana Díaz 72113|72075 0 0 America/Puerto_Rico
52 52 716 17.99942 -66.59868 Ponce PR Puerto Rico 1   27705 1234.1 72113 Ponce {"72113": 100} Ponce 72113 0 0 America/Puerto_Rico
53 53 717 18.00272 -66.61146 Ponce PR Puerto Rico 1   14651 2384.0 72113 Ponce {"72113": 100} Ponce 72113 0 0 America/Puerto_Rico
54 54 718 18.23145 -65.76067 Naguabo PR Puerto Rico 1   23174 189.5 72103 Naguabo {"72103": 99.87, "72037": 0.13} Naguabo|Ceiba 72103|72037 0 0 America/Puerto_Rico
55 55 719 18.28879 -66.25316 Naranjito PR Puerto Rico 1   29732 406.9 72105 Naranjito {"72105": 96.91, "72047": 2.23, "72045": 0.46, "72135": 0.4} Naranjito|Corozal|Comerío|Toa Alta 72105|72047|72045|72135 0 0 America/Puerto_Rico
56 56 720 18.21559 -66.42421 Orocovis PR Puerto Rico 1   20974 144.3 72107 Orocovis {"72107": 99.27, "72043": 0.73} Orocovis|Coamo 72107|72043 0 0 America/Puerto_Rico
57 57 723 18.03139 -66.01122 Patillas PR Puerto Rico 1   15835 132.9 72109 Patillas {"72109": 99.5, "72095": 0.5} Patillas|Maunabo 72109|72095 0 0 America/Puerto_Rico
58 58 725 18.22052 -66.03962 Caguas PR Puerto Rico 1   76246 711.7 72025 Caguas {"72025": 86.56, "72061": 4.44, "72129": 2.78, "72127": 2.24, "72139": 2.08, "72007": 1.9} Caguas|Guaynabo|San Lorenzo|San Juan|Trujillo Alto|Aguas Buenas 72025|72061|72129|72127|72139|72007 0 0 America/Puerto_Rico
59 59 727 18.21142 -66.07374 Caguas PR Puerto Rico 1   53412 914.0 72025 Caguas {"72025": 100} Caguas 72025 0 0 America/Puerto_Rico
60 60 728 18.00697 -66.65995 Ponce PR Puerto Rico 1   37322 935.9 72113 Ponce {"72113": 100} Ponce 72113 0 0 America/Puerto_Rico
61 61 729 18.33524 -65.88677 Canovanas PR Puerto Rico 1   47653 514.6 72029 Canóvanas {"72029": 91.45, "72087": 8.55} Canóvanas|Loíza 72029|72087 0 0 America/Puerto_Rico
62 62 730 18.03256 -66.61384 Ponce PR Puerto Rico 1   31976 1860.0 72113 Ponce {"72113": 100} Ponce 72113 0 0 America/Puerto_Rico
63 63 731 18.09914 -66.63279 Ponce PR Puerto Rico 1   10221 80.6 72113 Ponce {"72113": 97.12, "72001": 2.88} Ponce|Adjuntas 72113|72001 0 0 America/Puerto_Rico
64 64 735 18.2525 -65.67534 Ceiba PR Puerto Rico 1   11159 157.4 72037 Ceiba {"72037": 94.57, "72103": 5.43} Ceiba|Naguabo 72037|72103 0 0 America/Puerto_Rico
65 65 736 18.10736 -66.14994 Cayey PR Puerto Rico 1   45528 320.2 72035 Cayey {"72035": 92.47, "72041": 7.53} Cayey|Cidra 72035|72041 0 0 America/Puerto_Rico
66 66 738 18.31793 -65.66793 Fajardo PR Puerto Rico 1   29797 388.4 72053 Fajardo {"72053": 99.58, "72037": 0.42} Fajardo|Ceiba 72053|72037 0 0 America/Puerto_Rico
67 67 739 18.17543 -66.16198 Cidra PR Puerto Rico 1   34595 434.1 72041 Cidra {"72041": 100} Cidra 72041 0 0 America/Puerto_Rico
68 68 740 18.33251 -65.63419 Puerto Real PR Puerto Rico 1   1959 1811.6 72053 Fajardo {"72053": 100} Fajardo 72053 0 0 America/Puerto_Rico
69 69 741 18.16569 -65.75506 Punta Santiago PR Puerto Rico 1   3733 633.1 72069 Humacao {"72069": 100} Humacao 72069 0 0 America/Puerto_Rico
70 70 745 18.3466 -65.81382 Rio Grande PR Puerto Rico 1   47077 299.2 72119 Río Grande {"72119": 99.78, "72029": 0.22} Río Grande|Canóvanas 72119|72029 0 0 America/Puerto_Rico
71 71 751 18.01205 -66.25871 Salinas PR Puerto Rico 1   19596 124.6 72123 Salinas {"72123": 99.82, "72035": 0.18} Salinas|Cayey 72123|72035 0 0 America/Puerto_Rico
72 72 754 18.1447 -65.97565 San Lorenzo PR Puerto Rico 1   36822 284.4 72129 San Lorenzo {"72129": 100} San Lorenzo 72129 0 0 America/Puerto_Rico
73 73 757 17.9933 -66.39056 Santa Isabel PR Puerto Rico 1   19974 237.8 72133 Santa Isabel {"72133": 100} Santa Isabel 72133 0 0 America/Puerto_Rico
74 74 765 18.12365 -65.43013 Vieques PR Puerto Rico 1   8147 66.6 72147 Vieques {"72147": 100} Vieques 72147 0 0 America/Puerto_Rico
75 75 766 18.13039 -66.4757 Villalba PR Puerto Rico 1   21829 220.8 72149 Villalba {"72149": 93.48, "72107": 6.52} Villalba|Orocovis 72149|72107 0 0 America/Puerto_Rico
76 76 767 18.07033 -65.89618 Yabucoa PR Puerto Rico 1   30453 213.1 72151 Yabucoa {"72151": 99.33, "72069": 0.67} Yabucoa|Humacao 72151|72069 0 0 America/Puerto_Rico
77 77 769 18.09459 -66.3607 Coamo PR Puerto Rico 1   33953 170.1 72043 Coamo {"72043": 98.04, "72133": 1.96} Coamo|Santa Isabel 72043|72133 0 0 America/Puerto_Rico
78 78 771 18.18797 -65.86916 Las Piedras PR Puerto Rico 1   35165 404.1 72085 Las Piedras {"72085": 99.0, "72069": 1.0} Las Piedras|Humacao 72085|72069 0 0 America/Puerto_Rico
79 79 772 18.43048 -65.90377 Loiza PR Puerto Rico 1   16961 400.7 72087 Loíza {"72087": 100} Loíza 72087 0 0 America/Puerto_Rico
80 80 773 18.34073 -65.72756 Luquillo PR Puerto Rico 1   17631 282.5 72089 Luquillo {"72089": 100} Luquillo 72089 0 0 America/Puerto_Rico
81 81 775 18.31387 -65.28618 Culebra PR Puerto Rico 1   1281 42.5 72049 Culebra {"72049": 100} Culebra 72049 0 0 America/Puerto_Rico
82 82 777 18.22365 -65.90904 Juncos PR Puerto Rico 1   37243 535.5 72077 Juncos {"72077": 98.61, "72129": 0.82, "72085": 0.43, "72029": 0.14} Juncos|San Lorenzo|Las Piedras|Canóvanas 72077|72129|72085|72029 0 0 America/Puerto_Rico
83 83 778 18.26319 -65.97938 Gurabo PR Puerto Rico 1   40391 528.2 72063 Gurabo {"72063": 94.08, "72129": 5.92} Gurabo|San Lorenzo 72063|72129 0 0 America/Puerto_Rico
84 84 780 18.09998 -66.57032 Coto Laurel PR Puerto Rico 1   13612 274.7 72113 Ponce {"72113": 98.12, "72075": 1.88} Ponce|Juana Díaz 72113|72075 0 0 America/Puerto_Rico
85 85 782 18.22501 -66.22452 Comerio PR Puerto Rico 1   18397 253.9 72045 Comerío {"72045": 97.39, "72019": 2.61} Comerío|Barranquitas 72045|72019 0 0 America/Puerto_Rico
86 86 783 18.30348 -66.32851 Corozal PR Puerto Rico 1   34266 314.2 72047 Corozal {"72047": 99.06, "72019": 0.94} Corozal|Barranquitas 72047|72019 0 0 America/Puerto_Rico
87 87 784 18.00558 -66.13651 Guayama PR Puerto Rico 1   35405 204.8 72057 Guayama {"72057": 97.13, "72035": 1.63, "72109": 1.24} Guayama|Cayey|Patillas 72057|72035|72109 0 0 America/Puerto_Rico
88 88 786 18.1357 -66.22881 La Plata PR Puerto Rico 1   135 29.6 72009 Aibonito {"72009": 100} Aibonito 72009 0 0 America/Puerto_Rico
89 89 791 18.14391 -65.81398 Humacao PR Puerto Rico 1   45912 415.8 72069 Humacao {"72069": 97.87, "72085": 1.16, "72151": 0.96} Humacao|Las Piedras|Yabucoa 72069|72085|72151 0 0 America/Puerto_Rico
90 90 794 18.19934 -66.31179 Barranquitas PR Puerto Rico 1   28450 320.1 72019 Barranquitas {"72019": 96.52, "72043": 3.48} Barranquitas|Coamo 72019|72043 0 0 America/Puerto_Rico
91 91 795 18.05128 -66.49485 Juana Diaz PR Puerto Rico 1   43212 279.3 72075 Juana Díaz {"72075": 100} Juana Díaz 72075 0 0 America/Puerto_Rico
92 92 802 18.34349 -64.9287 St Thomas VI Virgin Islands 1       78030 St. Thomas {"78030": 100} St. Thomas 78030 0 0 America/St_Thomas
93 93 820 17.7388 -64.70695 Christiansted VI Virgin Islands 1       78010 St. Croix {"78010": 100} St. Croix 78010 0 0 America/St_Thomas
94 94 830 18.33857 -64.73802 St John VI Virgin Islands 1       78020 St. John {"78020": 100} St. John 78020 0 0 America/St_Thomas
95 95 840 17.72649 -64.84717 Frederiksted VI Virgin Islands 1       78010 St. Croix {"78010": 100} St. Croix 78010 0 0 America/St_Thomas
96 96 850 17.72763 -64.79122 Kingshill VI Virgin Islands 1       78010 St. Croix {"78010": 100} St. Croix 78010 0 0 America/St_Thomas
97 97 851 17.74757 -64.78737 Kingshill VI Virgin Islands 1       78010 St. Croix {"78010": 100} St. Croix 78010 0 0 America/St_Thomas
98 98 901 18.46478 -66.10277 San Juan PR Puerto Rico 1   6762 2573.0 72127 San Juan {"72127": 100} San Juan 72127 0 0 America/Puerto_Rico
99 99 906 18.46446 -66.09499 San Juan PR Puerto Rico 1   46 5577.8 72127 San Juan {"72127": 100} San Juan 72127 0 0 America/Puerto_Rico
100 100 907 18.45287 -66.08381 San Juan PR Puerto Rico 1   15911 3006.8 72127 San Juan {"72127": 100} San Juan 72127 0 0 America/Puerto_Rico

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "zipcodes" (
"zip" INTEGER,
  "lat" REAL,
  "lng" REAL,
  "city" TEXT,
  "state_id" TEXT,
  "state_name" TEXT,
  "zcta" INTEGER,
  "parent_zcta" INTEGER,
  "population" INTEGER,
  "density" REAL,
  "county_fips" INTEGER,
  "county_name" TEXT,
  "county_weights" TEXT,
  "county_names_all" TEXT,
  "county_fips_all" TEXT,
  "imprecise" INTEGER,
  "military" INTEGER,
  "timezone" TEXT
);