US domestic flights from 1990 to 2009

Over 3.5 million monthly domestic flight records from 1990 to 2009. Data are arranged as an adjacency list with metadata. Ready for immediate database import and analysis. ##Fields: |Short name|Type |Description| |-|-|-| |Origin|String|Three letter airport code of the origin airport| |Destination|String|Three letter airport code of the destination airport| |Origin City|String|Origin city name| |Destination City|String|Destination city name| |Passengers|Integer|Number of passengers transported from origin to destination| |Seats|Integer|Number of seats available on flights from origin to destination| |Flights|Integer|Number of flights between origin and destination (multiple records for one month, many with flights > 1)| |Distance|Integer|Distance (to nearest mile) flown between origin and destination| |Fly Date|Integer|The date (yyyymm) of flight| |Origin Population|Integer|Origin city s population as reported by US Census| |Destination Population|Integer|Dest

包含1990年至2009年间超过350万条国内航班记录，数据以邻接表形式排列并附带元数据。数据已准备好，可直接导入数据库进行分析。##字段：|简称|类型|描述||-|-|-| |Origin|字符串|出发机场的三字母代码| |Destination|字符串|目的地机场的三字母代码| |Origin City|字符串|出发城市名称| |Destination City|字符串|目的地城市名称| |Passengers|整数|从出发地至目的地运输的乘客数量| |Seats|整数|从出发地至目的地的航班可容纳座位数| |Flights|整数|出发地与目的地之间的航班数量（一个月内有多条记录，许多记录的航班数大于1）| |Distance|整数|出发地与目的地之间飞行的距离（最近的英里数）| |Fly Date|整数|航班日期（yyyymm）| |Origin Population|整数|根据美国人口普查报告的出发城市人口| |Destination Population|整数|目的地城市人口