id | iata_code | airport_name | city_name | country_name | latitude | longitude | |
---|---|---|---|---|---|---|---|
1 | 2918 | HFE | Shanghai | Hefei | China | 31.780019 | 117.298436 |
2 | 3912 | KNH | Shang-Yi | Kinmen | China | 24.427892 | 118.359197 |
3 | 5515 | NRI | Shangri-la | Shangri-la | United States | 36.56666667 | -94.85 |
4 | 6359 | PVG | Pu Dong | Shanghai | China | 31.143378 | 121.805214 |
5 | 6951 | SHA | Hongqiao | Shanghai | China | 31.197875 | 121.336319 |