SQL和R位_SQL and R Bits.zip

ZIP CODEDisplay NameShort NameStateMSA '00210','Greater Boston Area','Boston','NH','Boston-Cambridge-Quincy, MA-NH MSA' '00211','Greater Boston Area','Boston','NH','Boston-Cambridge-Quincy, MA-NH MSA' '00212','Greater Boston Area','Boston','NH','Boston-Cambridge-Quincy, MA-NH MSA' '00213','Greater Boston Area','Boston','NH','Boston-Cambridge-Quincy, MA-NH MSA' '00214','Greater Boston Area','Boston','NH','Boston-Cambridge-Quincy, MA-NH MSA' '00215','Greater Boston Area','Boston','NH','Boston-Cambridge-Quincy, MA-NH MSA' '00501','Greater New York City Area','New York City','NY','New York-Northern New Jersey-Long Island, NY-NJ-PA MSA' '00544','Greater New York City Area','New York City','NY','New York-Northern New Jersey-Long Island, NY-NJ-PA MSA' '00601','Puerto Rico','Puerto Rico','PR','PR NONMETROPOLITAN AREA' '00602','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00603','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00604','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00605','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00606','Puerto Rico','Puerto Rico','PR','PR NONMETROPOLITAN AREA' '00610','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00611','Greater San Juan, PR Area','San Juan, PR','PR','PR NONMETROPOLITAN AREA' '00612','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00613','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00614','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00616','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00617','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00622','Greater Mayaguez, PR Area','Mayaguez, PR','PR','San German-Cabo Rojo, PR MSA' '00623','Greater Mayaguez, PR Area','Mayaguez, PR','PR','San German-Cabo Rojo, PR MSA' '00624','Greater Ponce, PR Area','Ponce, PR','PR','Yauco, PR MSA' '00627','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00631','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00636','Greater Mayaguez, PR Area','Mayaguez, PR','PR','San German-Cabo Rojo, PR MSA' '00637','Greater Mayaguez, PR Area','Mayaguez, PR','PR','San German-Cabo Rojo, PR MSA' '00638','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00641','Greater San Juan, PR Area','San Juan, PR','PR','PR NONMETROPOLITAN AREA' '00646','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00647','Greater Ponce, PR Area','Ponce, PR','PR','Yauco, PR MSA' '00650','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00652','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00653','Greater Ponce, PR Area','Ponce, PR','PR','Yauco, PR MSA' '00656','Greater Ponce, PR Area','Ponce, PR','PR','Yauco, PR MSA' '00659','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00660','Greater Mayaguez, PR Area','Mayaguez, PR','PR','Mayaguez, PR MSA' '00662','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00664','Puerto Rico','Puerto Rico','PR','PR NONMETROPOLITAN AREA' '00667','Greater Mayaguez, PR Area','Mayaguez, PR','PR','San German-Cabo Rojo, PR MSA' '00669','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00670','Greater San Juan, PR Area','San Juan, PR','PR','PR NONMETROPOLITAN AREA' '00674','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00676','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00677','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00678','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00680','Greater Mayaguez, PR Area','Mayaguez, PR','PR','Mayaguez, PR MSA' '00681','Greater Mayaguez, PR Area','Mayaguez, PR','PR','Mayaguez, PR MSA' '00682','Greater Mayaguez, PR Area','Mayaguez, PR','PR','Mayaguez, PR MSA' '00683','Greater Mayaguez, PR Area','Mayaguez, PR','PR','San German-Cabo Rojo, PR MSA' '00685','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00687','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00688','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00690','Greater Aguadilla, PR Area','Aguadilla, PR','PR','Aguadilla-Isabela-San Sebastian, PR MSA' '00692','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00693','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00694','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00698','Greater Ponce, PR Area','Ponce, PR','PR','Yauco, PR MSA' '00703','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00704','Greater Guayama, PR Area','Guayama, PR','PR','Guayama, PR MSA' '00705','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00707','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00714','Greater Guayama, PR Area','Guayama, PR','PR','Guayama, PR MSA' '00715','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00716','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00717','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00718','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00719','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00720','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00721','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00723','Greater Guayama, PR Area','Guayama, PR','PR','Guayama, PR MSA' '00725','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00726','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00727','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00728','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00729','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00730','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00731','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00732','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00733','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00734','Greater Ponce, PR Area','Ponce, PR','PR','Ponce, PR MSA' '00735','Greater San Juan, PR Area','San Juan, PR','PR','Fajardo, PR MSA' '00736','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00737','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00738','Greater San Juan, PR Area','San Juan, PR','PR','Fajardo, PR MSA' '00739','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00740','Greater San Juan, PR Area','San Juan, PR','PR','Fajardo, PR MSA' '00741','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00742','Greater San Juan, PR Area','San Juan, PR','PR','Fajardo, PR MSA' '00744','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00745','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA' '00751','Puerto Rico','Puerto Rico','PR','PR NONMETROPOLITAN AREA' '00754','Greater San Juan, PR Area','San Juan, PR','PR','San Juan-Caguas-Guaynabo, PR MSA