File indexing completed on 2024-05-12 04:46:38 

0001 CREATE TABLE IF NOT EXISTS CITIES (
0002 id TEXT,
0003     name TEXT,
0004     asciiname TEXT,
0005     alternativeNames TEXT,
0006     lat REAL,
0007     lon REAL,
0008     featureClass TEXT,
0009     featureCode TEXT,
0010     country TEXT,
0011     altCountry TEXT,
0012     adminCode TEXT,
0013     countrySubdivision TEXT,
0014     municipality TEXT,
0015     municipalitySubdivision TEXT,
0016     population TEXT,
0017     elevation TEXT,
0018     dem TEXT,
0019     tz TEXT,
0020     lastModified,
0021 PRIMARY KEY(id)
0022 );
0023 
0024 .separator "\t"
0025 
0026 .import cities1000.txt CITIES
0027 
0028 CREATE TABLE IF NOT EXISTS COUNTRIES (
0029 id TEXT,
0030     name TEXT ,
0031 PRIMARY KEY(id)
0032 );
0033 
0034 .separator ","
0035 
0036 .import countries.csv COUNTRIES