route_long_name,route_short_name,agency_id,route_type,route_id,route_url,route_color
Acela,,51,2,40751,http://www.amtrak.com/acela-train,CAE4F1
Adirondack,,51,2,95,https://www.amtrak.com/adirondack-train,CAE4F1
Amtrak Cascades,,51,2,60,https://www.amtrak.com/cascades-train,CAE4F1
Amtrak Hartford Line,,51,2,41042,https://www.amtrak.com/amtrak-hartford-line-train,CAE4F1
Amtrak Mardi Gras Service,,51,2,42996,http://www.amtrak.com,CAE4F1
Amtrak Thruway Connecting Service,,117,3,18650,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,1202,3,42891,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,1207,3,42896,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,1213,3,42912,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,1220,3,42920,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,1232,3,42954,http://www.amtrak.com,CAE4F1
Amtrak Thruway Connecting Service,,1233,3,42958,http://www.amtrak.com,CAE4F1
Amtrak Thruway Connecting Service,,147,3,23565,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,162,3,33820,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,178,3,42933,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,28,3,41080,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Amtrak Thruway Connecting Service,,43,3,43,https://www.amtrak.com/thruway-connecting-services-multiply-your-travel-destinations,CAE4F1
Auto Train,,51,2,77,https://www.amtrak.com/auto-train,CAE4F1
Berkshire Flyer,,51,2,42992,http://www.amtrak.com,CAE4F1
Blue Water,,51,2,42956,http://www.amtrak.com,CAE4F1
Borealis,,51,2,42991,http://www.amtrak.com,CAE4F1
California Zephyr,,51,2,96,https://www.amtrak.com/california-zephyr-train,CAE4F1
Capitol Corridor,,51,2,84,https://www.amtrak.com/capitol-corridor-train,CAE4F1
Cardinal,,51,2,58,https://www.amtrak.com/cardinal-train,CAE4F1
Carl Sandburg,,51,2,72,https://www.amtrak.com/illinois-services-train,CAE4F1
Carolinian,,51,2,85,https://www.amtrak.com/carolinian-piedmont-train,CAE4F1
City of New Orleans,,51,2,42946,http://www.amtrak.com,CAE4F1
Coast Starlight,,51,2,36924,https://www.amtrak.com/coast-starlight-train,CAE4F1
Commuter Rail,,1230,2,42948,http://www.amtrak.com,CAE4F1
Commuter Rail,,1238,2,42985,http://www.amtrak.com,CAE4F1
Crescent,,51,2,36923,https://www.amtrak.com/crescent-train,CAE4F1
Downeaster,,51,2,61,https://www.amtrak.com/downeaster-train,CAE4F1
Empire Builder,,51,2,75,https://www.amtrak.com/empire-builder-train,CAE4F1
Empire Service,,51,2,36921,https://www.amtrak.com/empire-service-train,CAE4F1
Ethan Allen Express,,51,2,36949,https://www.amtrak.com/ethan-allen-express-train,CAE4F1
Floridian,,51,2,42994,http://www.amtrak.com,CAE4F1
Heartland Flyer,,51,2,86,https://www.amtrak.com/heartland-flyer-train,CAE4F1
Hiawatha Service,,51,2,54,https://www.amtrak.com/hiawatha-train,CAE4F1
Illini,,51,2,56,https://www.amtrak.com/illinois-services-train,CAE4F1
Illinois Zephyr,,51,2,42957,http://www.amtrak.com,CAE4F1
Keystone Service,,51,2,94,https://www.amtrak.com/keystone-service-train,CAE4F1
Lake Shore Limited,,51,2,81,https://www.amtrak.com/lake-shore-limited-train,CAE4F1
Lincoln Service,,51,2,42951,http://www.amtrak.com,CAE4F1
Lincoln Service Missouri River Runner,,51,2,36926,https://www.amtrak.com/illinois-services-train,CAE4F1
Maple Leaf,,157,2,31849,http://www.amtrak.com,CAE4F1
Maple Leaf,,51,2,68,https://www.amtrak.com/maple-leaf-train,CAE4F1
Missouri River Runner,,51,2,36948,https://www.amtrak.com/missouri-river-runner-train,CAE4F1
Northeast Regional,,51,2,88,https://www.amtrak.com/northeast-regional-train,CAE4F1
Pacific Surfliner,,51,2,78,https://www.amtrak.com/pacific-surfliner-train,CAE4F1
Palmetto,,51,2,69,https://www.amtrak.com/silver-service-palmetto-train,CAE4F1
Pennsylvanian,,51,2,64,https://www.amtrak.com/pennsylvanian-train,CAE4F1
Pere Marquette,,51,2,55,https://www.amtrak.com/michigan-services-train,CAE4F1
Piedmont,,51,2,79,https://www.amtrak.com/carolinian-piedmont-train,CAE4F1
Saluki,,51,2,63,https://www.amtrak.com/illinois-services-train,CAE4F1
Silver Meteor,,51,2,42947,http://www.amtrak.com,CAE4F1
Southwest Chief,,51,2,51,https://www.amtrak.com/southwest-chief-train,CAE4F1
Sunset Limited,,51,2,36930,https://www.amtrak.com/sunset-limited-train,CAE4F1
Texas Eagle,,51,2,87,https://www.amtrak.com/texas-eagle-train,CAE4F1
Valley Flyer,,51,2,41044,https://www.amtrak.com/valley-flyer-train,CAE4F1
Vermonter,,51,2,90,https://www.amtrak.com/vermonter-train,CAE4F1
Wolverine,,51,2,80,https://www.amtrak.com/michigan-services-train,CAE4F1
