Northern Mariana Islands cities list with latitude and longitude in CSV format

Northern_Mariana_Islands
Northern Mariana Islands
CSV, SQL, XML, JSON

Last update : 26 May 2024.

Country
Northern Mariana Islands
Capitale
Saipan
Number of cities
30
Download

This is the best list of 30 cities in the Northern Mariana Islands available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).

Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.

Here is an example of the data from the Northern Mariana Islands file that you are going to retrieve. The data is displayed here in the form of a table:


Geoname_IDCityAlternate_NameCountry_CodeRegionSub_regionLatitudeLongitudeElevationPopulationTimezoneFcode_Name
7267930Garapan VillageGarapan CDPMPSaipan15.20545145.7202560Pacific/Saipanpopulated place
4041462Navy Hill VillageMPSaipan15.21109145.733941500Pacific/Saipanpopulated place
4041579SongsongAammama,Mirikattan,Rota,Rota Village,Sasanhiya,Sonson,Sonsonhiya,Sosonhiya,SosonjayaMPRota14.13972145.1411150Pacific/Saipanpopulated place
7838874Achugao HamletMPSaipan15.23165145.767072000Pacific/Saipanpopulated place
7267932Gualo Rai VillageGualo Rai CDPMPSaipan15.19415145.7168250Pacific/Saipanpopulated place
4041348Koblerville VillageMPSaipan15.12382145.70228300Pacific/Saipanpopulated place
7778779Agrihan VillageMPNorthern IslandsAgrihan Island18.73638145.652952020Pacific/Saipanpopulated place
7838878Fina Sisu HamletMPSaipan15.14558145.71927500Pacific/Saipanpopulated place
7778853Alamagan VillagePatida Camp,Patik CampMPNorthern IslandsAlamagan Island17.61252145.821472015Pacific/Saipanpopulated place
4041560San Roque VillageMakunsha,MatansaMPSaipan15.24889145.7755390Pacific/Saipanpopulated place
7838880Papago HamletMPSaipan15.17358145.747032000Pacific/Saipanpopulated place
4041561San Vicente VillageTuturam VillageMPSaipan15.15165145.7376800Pacific/Saipanpopulated place
7838879Matansa HamletMPSaipan15.2509145.785961000Pacific/Saipanpopulated place
7267947San Antonio VillageSan Antonio CDPMPSaipan15.13299145.6971640Pacific/Saipanpopulated place
7267948San Jose VillageSan Jose CDPMPSaipan15.16853145.7101640Pacific/Saipanpopulated place
7828758SaipanSPN,Saipan,Sajpan,saipan,Сайпан,사이판MPSaipan15.21233145.7545548220Pacific/Saipancapital of a political entity
7267956Susupe VillageSusupe CDPMPSaipan15.15634145.7025850Pacific/Saipanpopulated place
4041178Chalan Kanoa VillageMPSaipan15.14636145.7030450Pacific/Saipanpopulated place
7828768Capitol Hill VillageArmy Hill,Capital Hill VillageMPSaipan15.20825145.753132100Pacific/Saipanpopulated place
7267926Dandan VillageDan Dan Village,Dandan CDPMPSaipan15.13511145.73404800Pacific/Saipanpopulated place
7267949San Jose VillageSan Jose,San Jose CDP,San Khose,Сан ХосеMPTinian14.96823145.619981515000Pacific/Saipanseat of a first-order administrative division
4041575Pagan VillageBandeera,Bandera,Pagan Island,ShomushonMPNorthern IslandsPagan Island18.12539145.759381050Pacific/Saipanpopulated place
7838877Chalan Kiya HamletMPSaipan15.16364145.71909200Pacific/Saipanpopulated place
7838654Kagman VillageMPSaipan15.17354145.78057700Pacific/Saipanpopulated place
4041619Tanapag VillageLagunan Tanapag,Puetton Tanapag,Talabogh,Tanapagu,Tanapako,TanapakuMPSaipan15.24205145.7562650Pacific/Saipanpopulated place
7838875As Lito HamletMPSaipan15.12963145.72377600Pacific/Saipanpopulated place
7838876As Perdido HamletMPSaipan15.1339145.7092400Pacific/Saipanpopulated place
4041576Sinapalo VillageShinaparu,SinapaluMPRota14.16608145.23171790Pacific/Saipanpopulated place
4041534Dugi VillageDuge,RugiiMPRota14.18851145.278741200Pacific/Saipanpopulated place
7838658Puerto Rico VillageMPSaipan15.2197145.73296100Pacific/Saipanpopulated place

FaQ about Northern Mariana Islands


Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
  • Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
  • City: The name of the place, which can be a town, village or any other form of human settlement.
  • Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
  • Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
  • Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
  • Sub_region: This is a second-order administrative division, such as a county or district, within the region.
  • Latitude: The geographical latitude of the location, usually in decimal degrees.
  • Longitude: The geographical longitude of the location, also usually in decimal degrees.
  • Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
  • Population: The estimated number of inhabitants or population of the location.
  • Timezone: The time zone in which the location is located, in accordance with global time zone standards.
  • Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel

List of countries :

h2020-flow.eu

With the aim of delivering reliable information, based on quality sources such as Geoname, we, a team of passionate geographers, have created this site. To enable you to obtain databases at very competitive prices.