route_id,agency_id,route_short_name,route_long_name,route_desc,route_type,route_url,route_color,route_text_color,route_sort_order
A,MTA NYCT,A,8 Avenue Express,"Trains operate between Inwood-207 St, Manhattan and Far Rockaway-Mott Av, Queens at all times. Also, from about 6 AM until about midnight, additional trains operate between Inwood-207 St and Ozone Park-Lefferts Blvd (trains typically alternate between Ozone Park and Far Rockaway). During weekday morning rush hours, special trains operate from Rockaway Park-Beach 116 St, Queens, toward Manhattan. These trains make local stops in Queens between Rockaway Park and Broad Channel. Similarly, in the evening, rush hour special trains leave Manhattan operating toward Rockaway Park-Beach 116 St.",1,https://www.mta.info/schedules/subway/a-train,0062CF,FFFFFF,1
C,MTA NYCT,C,8 Avenue Local,"Trains operate between 168 St, Manhattan, and Euclid Av, Brooklyn, daily from about 6 AM to 11 PM.",1,https://www.mta.info/schedules/subway/c-train,0062CF,FFFFFF,2
E,MTA NYCT,E,8 Avenue Local,"Trains operate between Jamaica Center-Parsons/Archer, Queens, and World Trade Center, Manhattan, at all times. E trains operate express in Queens at all times except late nights when they operate local.",1,https://www.mta.info/schedules/subway/e-train,0062CF,FFFFFF,3
B,MTA NYCT,B,6 Avenue Express,"Trains operate, weekdays only, between 145 St, Manhattan, and Brighton Beach, Brooklyn at all times except late nights. During rush hours and middays, some trips are extended to Bedford Park Blvd, Bronx.",1,https://www.mta.info/schedules/subway/b-train,EB6800,FFFFFF,4
D,MTA NYCT,D,6 Avenue Express,"Trains operate, at all times, from Norwood-205 St, Bronx, to Coney Island-Stillwell Av, Brooklyn via Central Park West and 6 Avenue in Manhattan, and via the Manhattan Bridge to and from Brooklyn. When in Brooklyn, trains operate via 4 Avenue, then through Bensonhurst to Coney Island. Trains typically operate local in the Bronx, express in Manhattan, and local in Brooklyn. Note that Bronx rush hour trains operate express (peak direction only), and Brooklyn trains operate express along the 4 Avenue segment (all times except late nights).",1,https://www.mta.info/schedules/subway/d-train,EB6800,FFFFFF,5
F,MTA NYCT,F,Queens Blvd Express/6 Av Local,"Trains operate at all times between Jamaica-179 St, Queens, and Coney Island-Stillwell Av, Brooklyn. On weekdays, trains operate via 53 St (serving Queens Plaza, Court Sq-23 St, Lexington Av/53 St, and 5 Av/53). During nights and weekends trains operate via 63 St (serving 21 St-Queensbridge, Roosevelt Island, Lexington Av/63 St, and 57 St). F trains operate local in Manhattan and express in Queens at all times except late nights when they operate local.",1,https://www.mta.info/schedules/subway/f-train,EB6800,FFFFFF,6
FX,MTA NYCT,FX,Brooklyn F Express,"Trains operate rush hour only between Jamaica-179 St, Queens, and Coney Island-Stillwell Av, Brooklyn, weekday mornings toward Manhattan, weekday afternoons toward Coney Island. These trains operate express in Brooklyn between Church Av and Jay St-MetroTech for two trips each rush hour period.",1,https://www.mta.info/schedules/subway/f-train,EB6800,FFFFFF,7
M,MTA NYCT,M,Queens Blvd Local/6 Av Local,"Trains operate weekdays between Middle Village-Metropolitan Av, Queens and Forest Hills-71 Av, Queens. Weekends, M trains operate from Middle Village to Delancey St-Essex St, Manhattan, and late nights from Middle Village to Myrtle Av (Broadway), Brooklyn. All trains provide local service.",1,https://www.mta.info/schedules/subway/m-train,EB6800,FFFFFF,8
G,MTA NYCT,G,Brooklyn-Queens Crosstown,"Trains operate between Court Sq, Queens and Church Av, Brooklyn at all times.",1,https://www.mta.info/schedules/subway/g-train,799534,FFFFFF,9
J,MTA NYCT,J,Nassau St Local,"Trains operate weekdays between Jamaica Center-Parsons/Archer, Queens, and Broad St, Manhattan at all times. During weekdays, trains going to Manhattan run express in Brooklyn between Myrtle Av and Marcy Av from about 7 AM to 1 PM and from Manhattan from 1:30 PM and 8 PM. During weekday rush hours, trains provide skip-stop service. Skip-stop service means that some stations are served by J trains, some stations are served by Z trains, and some stations are served by both J and Z trains. J/Z skip-stop service runs toward Manhattan from about 7 AM to 8:15 AM and from Manhattan from about 4:30 PM to 5:45 PM.",1,https://www.mta.info/schedules/subway/j-train,8E5C33,FFFFFF,10
Z,MTA NYCT,Z,Nassau St Express,"Trains operate weekday rush hours only. During weekday rush hours, J and Z trains provide skip-stop service. Skip-stop service means that some stations are served by J trains, some stations are served by Z trains, and some stations are served by both J and Z trains. J/Z skip-stop service runs towards Manhattan from about 7 AM to 8:15 AM and from Manhattan from about 4:30 PM to 5:45 PM.",1,https://www.mta.info/schedules/subway/j-train,8E5C33,FFFFFF,11
L,MTA NYCT,L,14 St-Canarsie Local,"Trains operate between 8 Av, Manhattan, and Canarsie-Rockaway Pkwy, Brooklyn, at all times.",1,https://www.mta.info/schedules/subway/l-train,7C858C,FFFFFF,12
N,MTA NYCT,N,Broadway Local,"Trains operate from Astoria-Ditmars Blvd, Queens, to Coney Island-Stillwell Av, Brooklyn, at all times. N trains in Manhattan operate along Broadway and across the Manhattan Bridge to and from Brooklyn. Trains in Brooklyn operate along 4 Avenue, then through Borough Park and Gravesend. Trains typically operate local in Queens and express in Manhattan and Brooklyn. Late night trains operate local in Manhattan and to/from Brooklyn via Whitehall St-South Ferry, Manhattan. Weekends, N trains operate local in Manhattan.",1,https://www.mta.info/schedules/subway/n-train,F6BC26,000000,13
Q,MTA NYCT,Q,Broadway Express,"Trains operate between 96 St (2 Av), Manhattan, and Coney Island-Stillwell Av, Brooklyn at all times. Trains operate local in Brooklyn at all times. Train operate express in Manhattan at all times, except late nights when trains operate local in Manhattan.",1,https://www.mta.info/schedules/subway/q-train,F6BC26,000000,14
R,MTA NYCT,R,Broadway Local,"Trains operate local between Forest Hills-71 Av, Queens, and Bay Ridge-95 St, Brooklyn, at all times except late nights. During late nights, trains operate between Whitehall St-South Ferry, Manhattan and Bay Ridge-95 St, Brooklyn.",1,https://www.mta.info/schedules/subway/r-train,F6BC26,000000,15
W,MTA NYCT,W,Broadway Local,"Trains operate from Astoria-Ditmars Blvd, Queens, to Whitehall St-South Ferry, Manhattan, on weekdays only.",1,https://www.mta.info/schedules/subway/w-train,F6BC26,000000,16
GS,MTA NYCT,S,42 St Shuttle,"Operates in Manhattan between Grand Central-42 St and Times Sq-42 St. The shuttle provides a free transfer between 4, 5, 6, and 7 service at Grand Central-42 St and A, C, E, N, Q, R, W, 1, 2, 3, and 7 service at Times Sq-42 St. The shuttle runs at all times except during late nights from about 12 midnight to 6 AM.",1,https://www.mta.info/schedules/subway/42-st-shuttle,7C858C,FFFFFF,17
FS,MTA NYCT,S,Franklin Avenue Shuttle,Trains operate in Brooklyn between Franklin Av (Fulton St) and Prospect Park.,1,https://www.mta.info/schedules/subway/franklin-avenue-shuttle,7C858C,FFFFFF,18
H,MTA NYCT,S,Rockaway Park Shuttle,"Service operates at all times between Broad Channel and Rockaway Park, Queens.",1,https://www.mta.info/schedules/subway/rockaway-park-shuttle,7C858C,FFFFFF,19
1,MTA NYCT,1,Broadway - 7 Avenue Local,"Trains operate between Van Cortlandt Park-242 St, Bronx and South Ferry, Manhattan at all times.",1,https://www.mta.info/schedules/subway/1-train,D82233,FFFFFF,20
2,MTA NYCT,2,7 Avenue Express,"Trains operate between Wakefield-241 St, Bronx, and Flatbush Av-Brooklyn College, Brooklyn, at all times. Trains operate local in the Bronx and Brooklyn. Trains operate express in Manhattan except late nights, when they operate local.",1,https://www.mta.info/schedules/subway/2-train,D82233,FFFFFF,21
3,MTA NYCT,3,7 Avenue Express,"Trains operate between Harlem-148 St, Manhattan, and New Lots Av, Brooklyn, at all times except late nights. During late nights, trains operate only in Manhattan between Harlem-148 St and 34 St-Penn Station.",1,https://www.mta.info/schedules/subway/3-train,D82233,FFFFFF,22
4,MTA NYCT,4,Lexington Avenue Express,"Trains operate daily between Woodlawn, Bronx, and Crown Hts-Utica Av, Brooklyn, running express in Manhattan and Brooklyn. During late night and early morning hours, trains run local in Manhattan and Brooklyn and extend beyond Crown Hts-Utica Av to New Lots Av, Brooklyn.",1,https://www.mta.info/schedules/subway/4-train,009952,FFFFFF,23
5,MTA NYCT,5,Lexington Avenue Express,"Weekdays daytime, most trains operate between either Eastchester-Dyre Av or Nereid Av, Bronx and Flatbush Av-Brooklyn College, Brooklyn. At all other times except during late nights, trains operate between Eastchester-Dyre Av, Bronx and Bowling Green, Manhattan. During late nights, trains operate only in the Bronx between Eastchester-Dyre Av and E 180 St. Customers who ride during late night hours can transfer to 2 service at E 180 St. At all times, trains operate express in Manhattan and Brooklyn. Weekdays, trains in the Bronx operate express from E 180 St to 3 Av-149 St during morning rush hours (from about 6 AM to 9 AM), and from 3 Av-149 St to E 180 St during the evening rush hours (from about 4 PM to 7 PM).",1,https://www.mta.info/schedules/subway/5-train,009952,FFFFFF,24
6,MTA NYCT,6,Lexington Avenue Local,"Local trains operate between Pelham Bay Park, Bronx, and Brooklyn Bridge-City Hall, Manhattan, at all times.",1,https://www.mta.info/schedules/subway/6-train,009952,FFFFFF,25
6X,MTA NYCT,6X,Pelham Bay Park Express,"Express trains operate between Pelham Bay Park, Bronx, and Brooklyn Bridge-City Hall, Manhattan, weekday mornings express in the Bronx toward Manhattan. Weekday afternoons and evenings, these trains operate express in the Bronx toward Pelham Bay Park.",1,https://www.mta.info/schedules/subway/6-train,009952,FFFFFF,26
7,MTA NYCT,7,Flushing Local,"Trains operate between Flushing-Main St, Queens, and 34 St-Hudson Yards, Manhattan, at all times.",1,https://www.mta.info/schedules/subway/7-train,9A38A1,FFFFFF,27
7X,MTA NYCT,7X,Flushing Express,"Trains operate between Flushing-Main St, Queens, and 34 St-Hudson Yards, Manhattan, weekday mornings express toward Manhattan. Weekday afternoons and evenings, these trains operate express toward Queens.",1,https://www.mta.info/schedules/subway/7-train,9A38A1,FFFFFF,28
SI,MTA NYCT,SIR,Staten Island Railway,"Service runs 24 hours a day between the St George and Tottenville terminals. At the St George terminal, customers can make connections with Staten Island Ferry service to Manhattan.",2,https://www.mta.info/schedules/subway/staten-island-railway,08179C,FFFFFF,29