Zip Code and Location Data in ASCII Files

The ASCII Files come in 2 different formats. Both ASCII Files are available to you in addition to the Microsoft Access databases.

All Acceptable Cities

The first contains all the information with each Zip Code, including multiple acceptable city and state names. Also included is the County Number, County Name, and latitude and longitude. A unique identifier exists for each record:

"ID","ZipCode","Primary","City","State","CountyNumber","CountyName","Latitude","Longitude"
1,"00501",1,"Holtsville","NY","103","Suffolk","40.81462860107420","-73.04187011718750"
2,"00544",1,"Holtsville","NY","103","Suffolk","40.81462860107420","-73.04187011718750"
3,"00601",1,"Adjuntas","PR","001","Adjuntas","18.16324996948240","-66.72303009033200"
4,"00602",1,"Aguada","PR","003","Aguada","18.38038063049320","-67.18917083740230"
5,"00603",1,"Aguadilla","PR","005","Aguadilla","18.43811988830570","-67.15358734130860"
6,"00603",0,"Ramey","PR","005","Aguadilla","18.44211578369140","-67.15690612792970"
7,"00604",1,"Aguadilla","PR","005","Aguadilla","18.49077987670900","-67.14823150634770"
8,"00604",0,"Ramey","PR","005","Aguadilla","18.49077987670900","-67.14823150634770"
9,"00605",1,"Aguadilla","PR","005","Aguadilla","18.44961929321290","-67.11286926269530"
10,"00606",1,"Maricao","PR","093","Maricao","18.18107032775880","-66.97869873046880"

NOTE: The above sample contains more than one city for zip codes "00603" and "00604".  The "1" denotes the primary city and the "0" denotes a secondary city name for the same zip code. Many zip codes have multiple secondary cities.

Primary Cities Only

The second file format contains the Primary "Official" City and State for each zip code along with its latitude and longitude. Secondary cities are not included.

"ZipCode","City","State","Latitude","Longitude"
"00501","Holtsville","NY","40.81462860107420","-73.04187011718750"
"00544","Holtsville","NY","40.81462860107420","-73.04187011718750"
"00601","Adjuntas","PR","18.16324996948240","-66.72303009033200"
"00602","Aguada","PR","18.38038063049320","-67.18917083740230"
"00603","Aguadilla","PR","18.43811988830570","-67.15358734130860"
"00604","Aguadilla","PR","18.49077987670900","-67.14823150634770"
"00605","Aguadilla","PR","18.44961929321290","-67.11286926269530"
"00606","Maricao","PR","18.18107032775880","-66.97869873046880"