# Data Dictionary - Global Airport Registry - every airport, runway & frequency in one cleaned table

**Units:** stated per column in the descriptions below (this is a relational table; columns mix units).

| column | type | description |
|---|---|---|
| `ident` | str | Airport identifier - ICAO where assigned (primary key) |
| `type` | str | Airport type (large_airport, medium_airport, small_airport, heliport, …) |
| `name` | str | Airport name |
| `continent` | str | Continent code |
| `iso_country` | str | ISO 3166-1 alpha-2 country code |
| `iso_region` | str | ISO 3166-2 region code |
| `municipality` | str | Served municipality / city |
| `scheduled_service` | str | 'yes' if the airport has scheduled airline service |
| `gps_code` | str | GPS / ICAO code |
| `iata_code` | str | IATA code (where assigned) |
| `local_code` | str | Local / national code |
| `latitude_deg` | float | Latitude (decimal degrees) |
| `longitude_deg` | float | Longitude (decimal degrees) |
| `elevation_ft` | float | Elevation above sea level (feet) |
| `runway_count` | int | Number of runways at the airport |
| `longest_runway_ft` | int | Longest runway length (feet) |
| `hard_surface_runways` | int | Number of hard-surface (asphalt/concrete) runways |
| `comm_frequencies` | int | Number of published communication frequencies |

*Source: OurAirports (ourairports.com) - public-domain aviation data.*