ZIP_codes

Data source: Medicare / Nursing Home Compare: Provider Info

44,832 rows

View and edit SQL

Suggested facets: zip_join_type

Link rowid ▼ ZIP_CODE PO_NAME STATE ZCTA zip_join_type ZCTA5 CBSA MPOP ZPOP cbsatitle
1 00501 Holtsville NY 11742 Spatial join to ZCTA 11742 35620 18897109 13261 New York
2 00544 Holtsville NY 11742 Spatial join to ZCTA 11742 35620 18897109 13261 New York
3 00601 Adjuntas PR 00601 Zip Matches ZCTA 00601 10260 19483 18570 Adjuntas
4 00601 Adjuntas PR 00601 Zip Matches ZCTA 00601 46580 33149 18570  
5 00602 Aguada PR 00602 Zip Matches ZCTA 00602 10380 306292 41520 Aguadilla
6 00603 Aguadilla PR 00603 Zip Matches ZCTA 00603 10380 306292 54689 Aguadilla
7 00604 Aguadilla PR 00603 Spatial join to ZCTA 00603 10380 306292 54689 Aguadilla
8 00605 Aguadilla PR 00603 Spatial join to ZCTA 00603 10380 306292 54689 Aguadilla
9 00606 Maricao PR 00606 Zip Matches ZCTA 00606 41900 137462 6615 San Germán
10 00606 Maricao PR 00606 Zip Matches ZCTA 00606 49500 107333 6615  
11 00610 Anasco PR 00610 Zip Matches ZCTA 00610 10380 306292 29016 Aguadilla
12 00611 Angeles PR 00641 Spatial join to ZCTA 00641 10260 19483 31191 Adjuntas
13 00611 Angeles PR 00641 Spatial join to ZCTA 00641 46580 33149 31191  
14 00612 Arecibo PR 00612 Zip Matches ZCTA 00612 41980 2478905 67010 San Juan
15 00613 Arecibo PR 00612 Spatial join to ZCTA 00612 41980 2478905 67010 San Juan
16 00614 Arecibo PR 00612 Spatial join to ZCTA 00612 41980 2478905 67010 San Juan
17 00616 Bajadero PR 00616 Zip Matches ZCTA 00616 41980 2478905 11017 San Juan
18 00617 Barceloneta PR 00617 Zip Matches ZCTA 00617 41980 2478905 24597 San Juan
19 00622 Boqueron PR 00622 Zip Matches ZCTA 00622 41900 137462 7853 San Germán
20 00623 Cabo Rojo PR 00623 Zip Matches ZCTA 00623 41900 137462 43061 San Germán
21 00624 Penuelas PR 00624 Zip Matches ZCTA 00624 38660 243147 26241 Ponce
22 00624 Penuelas PR 00624 Zip Matches ZCTA 00624 49500 107333 26241  
23 00627 Camuy PR 00627 Zip Matches ZCTA 00627 41980 2478905 35159 San Juan
24 00631 Castaner PR 00631 Zip Matches ZCTA 00631 10260 19483 1852 Adjuntas
25 00631 Castaner PR 00631 Zip Matches ZCTA 00631 10380 306292 1852 Aguadilla
26 00636 Rosario PR 00680 Spatial join to ZCTA 00680 10380 306292 58140 Aguadilla
27 00636 Rosario PR 00680 Spatial join to ZCTA 00680 32420 106330 58140 Mayagüez
28 00636 Rosario PR 00680 Spatial join to ZCTA 00680 41900 137462 58140 San Germán
29 00637 Sabana Grande PR 00637 Zip Matches ZCTA 00637 41900 137462 25287 San Germán
30 00637 Sabana Grande PR 00637 Zip Matches ZCTA 00637 49500 107333 25287  
31 00638 Ciales PR 00638 Zip Matches ZCTA 00638 41980 2478905 18941 San Juan
32 00641 Utuado PR 00641 Zip Matches ZCTA 00641 10260 19483 31191 Adjuntas
33 00641 Utuado PR 00641 Zip Matches ZCTA 00641 46580 33149 31191  
34 00646 Dorado PR 00646 Zip Matches ZCTA 00646 41980 2478905 38199 San Juan
35 00647 Ensenada PR 00647 Zip Matches ZCTA 00647 41900 137462 6172 San Germán
36 00647 Ensenada PR 00647 Zip Matches ZCTA 00647 49500 107333 6172  
37 00650 Florida PR 00650 Zip Matches ZCTA 00650 41980 2478905 14998 San Juan
38 00650 Florida PR 00650 Zip Matches ZCTA 00650 46580 33149 14998  
39 00652 Garrochales PR 00652 Zip Matches ZCTA 00652 41980 2478905 4715 San Juan
40 00653 Guanica PR 00653 Zip Matches ZCTA 00653 49500 107333 13307  
41 00656 Guayanilla PR 00656 Zip Matches ZCTA 00656 49500 107333 21481  
42 00659 Hatillo PR 00659 Zip Matches ZCTA 00659 41980 2478905 41953 San Juan
43 00660 Hormigueros PR 00660 Zip Matches ZCTA 00660 32420 106330 17250 Mayagüez
44 00662 Isabela PR 00662 Zip Matches ZCTA 00662 10380 306292 43282 Aguadilla
45 00664 Jayuya PR 00664 Zip Matches ZCTA 00664 27580 16642 16784 Jayuya
46 00664 Jayuya PR 00664 Zip Matches ZCTA 00664 46580 33149 16784  
47 00667 Lajas PR 00667 Zip Matches ZCTA 00667 41900 137462 25968 San Germán
48 00669 Lares PR 00669 Zip Matches ZCTA 00669 10380 306292 29744 Aguadilla
49 00670 Las Marias PR 00670 Zip Matches ZCTA 00670 10380 306292 9807 Aguadilla
50 00674 Manati PR 00674 Zip Matches ZCTA 00674 41980 2478905 44457 San Juan
51 00676 Moca PR 00676 Zip Matches ZCTA 00676 10380 306292 40316 Aguadilla
52 00677 Rincon PR 00677 Zip Matches ZCTA 00677 10380 306292 15272 Aguadilla
53 00678 Quebradillas PR 00678 Zip Matches ZCTA 00678 10380 306292 27819 Aguadilla
54 00678 Quebradillas PR 00678 Zip Matches ZCTA 00678 41980 2478905 27819 San Juan
55 00680 Mayaguez PR 00680 Zip Matches ZCTA 00680 10380 306292 58140 Aguadilla
56 00680 Mayaguez PR 00680 Zip Matches ZCTA 00680 32420 106330 58140 Mayagüez
57 00680 Mayaguez PR 00680 Zip Matches ZCTA 00680 41900 137462 58140 San Germán
58 00681 Mayaguez PR 00680 Spatial join to ZCTA 00680 10380 306292 58140 Aguadilla
59 00681 Mayaguez PR 00680 Spatial join to ZCTA 00680 32420 106330 58140 Mayagüez
60 00681 Mayaguez PR 00680 Spatial join to ZCTA 00680 41900 137462 58140 San Germán
61 00682 Mayaguez PR 00682 Zip Matches ZCTA 00682 32420 106330 32615 Mayagüez
62 00683 San German PR 00683 Zip Matches ZCTA 00683 41900 137462 33772 San Germán
63 00685 San Sebastian PR 00685 Zip Matches ZCTA 00685 10380 306292 42831 Aguadilla
64 00687 Morovis PR 00687 Zip Matches ZCTA 00687 41980 2478905 32610 San Juan
65 00688 Sabana Hoyos PR 00688 Zip Matches ZCTA 00688 41980 2478905 13543 San Juan
66 00690 San Antonio PR 00690 Zip Matches ZCTA 00690 10380 306292 6255 Aguadilla
67 00692 Vega Alta PR 00692 Zip Matches ZCTA 00692 41980 2478905 37511 San Juan
68 00693 Vega Baja PR 00693 Zip Matches ZCTA 00693 41980 2478905 61038 San Juan
69 00694 Vega Baja PR 00694 Zip Matches ZCTA 00694 41980 2478905 328 San Juan
70 00698 Yauco PR 00698 Zip Matches ZCTA 00698 49500 107333 41782  
71 00703 Aguas Buenas PR 00703 Zip Matches ZCTA 00703 41980 2478905 28605 San Juan
72 00704 Aguirre PR 00704 Zip Matches ZCTA 00704 17620 71590 8577 Coamo
73 00704 Aguirre PR 00704 Zip Matches ZCTA 00704 25020 84214 8577 Guayama
74 00705 Aibonito PR 00705 Zip Matches ZCTA 00705 17620 71590 25598 Coamo
75 00705 Aibonito PR 00705 Zip Matches ZCTA 00705 41980 2478905 25598 San Juan
76 00707 Maunabo PR 00707 Zip Matches ZCTA 00707 41980 2478905 12225 San Juan
77 00714 Arroyo PR 00714 Zip Matches ZCTA 00714 25020 84214 19566 Guayama
78 00715 Mercedita PR 00715 Zip Matches ZCTA 00715 38660 243147 3656 Ponce
79 00716 Ponce PR 00716 Zip Matches ZCTA 00716 38660 243147 33779 Ponce
80 00717 Ponce PR 00717 Zip Matches ZCTA 00717 38660 243147 18457 Ponce
81 00718 Naguabo PR 00718 Zip Matches ZCTA 00718 41980 2478905 26606 San Juan
82 00719 Naranjito PR 00719 Zip Matches ZCTA 00719 41980 2478905 30990 San Juan
83 00720 Orocovis PR 00720 Zip Matches ZCTA 00720 17620 71590 23129 Coamo
84 00720 Orocovis PR 00720 Zip Matches ZCTA 00720 41980 2478905 23129 San Juan
85 00721 Palmer PR 00745 Spatial join to ZCTA 00745 41980 2478905 55062 San Juan
86 00723 Patillas PR 00723 Zip Matches ZCTA 00723 25020 84214 19277 Guayama
87 00725 Caguas PR 00725 Zip Matches ZCTA 00725 41980 2478905 89374 San Juan
88 00726 Caguas PR 00725 Spatial join to ZCTA 00725 41980 2478905 89374 San Juan
89 00727 Caguas PR 00727 Zip Matches ZCTA 00727 41980 2478905 58382 San Juan
90 00728 Ponce PR 00728 Zip Matches ZCTA 00728 38660 243147 44908 Ponce
91 00729 Canovanas PR 00729 Zip Matches ZCTA 00729 41980 2478905 53750 San Juan
92 00730 Ponce PR 00730 Zip Matches ZCTA 00730 38660 243147 35742 Ponce
93 00731 Ponce PR 00731 Zip Matches ZCTA 00731 10260 19483 15524 Adjuntas
94 00731 Ponce PR 00731 Zip Matches ZCTA 00731 38660 243147 15524 Ponce
95 00732 Ponce PR 00730 Spatial join to ZCTA 00730 38660 243147 35742 Ponce
96 00733 Ponce PR 00730 Spatial join to ZCTA 00730 38660 243147 35742 Ponce
97 00734 Ponce PR 00730 Spatial join to ZCTA 00730 38660 243147 35742 Ponce
98 00735 Ceiba PR 00735 Zip Matches ZCTA 00735 21940 70692 13730  
99 00735 Ceiba PR 00735 Zip Matches ZCTA 00735 41980 2478905 13730 San Juan
100 00736 Cayey PR 00736 Zip Matches ZCTA 00736 41980 2478905 51532 San Juan

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "ZIP_codes"(
  "ZIP_CODE" TEXT,
  "PO_NAME" TEXT,
  "STATE" TEXT,
  "ZCTA" TEXT,
  "zip_join_type" TEXT,
  "ZCTA5" TEXT,
  "CBSA" TEXT,
  "MPOP" TEXT,
  "ZPOP" TEXT,
  "cbsatitle" TEXT
);
Powered by Datasette · Query took 635.42ms · Data source: Medicare / Nursing Home Compare: Provider Info