script_create_db.sql

-- DROP DATABASE IF EXISTS train_db;

CREATE DATABASE IF NOT EXISTS train_db;
USE train_db;

CREATE TABLE IF NOT EXISTS routes (
      routeId varchar(10) collate latin1_general_cs, 
      startingPoint varchar(50),
      destination varchar(50),
      departureDay varchar(20),
      departureTime varchar(10),
      arrivalTime varchar(10),
      ticketPrice float,
      trainType varchar(50),
      CONSTRAINT PK_routes PRIMARY KEY (routeId)
);

CREATE TABLE IF NOT EXISTS users (
	userId varchar(20) collate latin1_general_cs,
	username varchar(20),
    password varchar(100) collate latin1_general_cs,
    role varchar(10),
	CONSTRAINT PK_users PRIMARY KEY (userId)
);

CREATE TABLE IF NOT EXISTS reservations (
	userId varchar(20) collate latin1_general_cs,
    routeId varchar(20) collate latin1_general_cs,
    CONSTRAINT PK_reservations PRIMARY KEY(userId, routeId),
    CONSTRAINT FK_reservations FOREIGN KEY (userId) REFERENCES users(userId),
    CONSTRAINT FK_reservations2 FOREIGN KEY (routeId) REFERENCES routes(routeId)
);


INSERT INTO routes VALUES('m3v7P5', 'Chicago', 'Houston', 'Friday', '05:38', '11:32', 54, 'Passenger');
INSERT INTO routes VALUES('u8N1s3', 'Seattle', 'New York', 'Saturday', '13:38', '21:06', 30, 'High-Speed');
INSERT INTO routes VALUES('E2k2r4', 'Dallas', 'Boston', 'Thursday', '02:24', '07:08', 22, 'Inter-City');
INSERT INTO routes VALUES('d2r3t2', 'Seattle', 'San Francisco', 'Thursday', '09:46', '15:17', 21, 'Regional');
INSERT INTO routes VALUES('b9J4N3', 'Phoenix', 'New York', 'Tuesday', '21:14', '23:48', 19, 'Passenger');
INSERT INTO routes VALUES('O9g7t1', 'Chicago', 'Washington', 'Tuesday', '04:37', '06:54', 86, 'Regional');
INSERT INTO routes VALUES('B8X2Z6', 'Chicago', 'Dallas', 'Tuesday', '05:58', '12:19', 93, 'High-Speed');
INSERT INTO routes VALUES('U1l5h8', 'Boston', 'Dallas', 'Thursday', '20:11', '23:17', 57, 'High-Speed');
INSERT INTO routes VALUES('Z7T8K8', 'Seattle', 'Chicago', 'Thursday', '17:34', '19:43', 67, 'Regional');
INSERT INTO routes VALUES('A2n0X1', 'New York', 'San Francisco', 'Friday', '10:55', '11:47', 30, 'Passenger');
INSERT INTO routes VALUES('r1L0G8', 'Chicago', 'Dallas', 'Saturday', '10:32', '14:20', 23, 'Inter-City');
INSERT INTO routes VALUES('i8M8b0', 'Philadelphia', 'Houston', 'Tuesday', '03:56', '09:04', 100, 'High-Speed');
INSERT INTO routes VALUES('t0L3m6', 'New York', 'San Francisco', 'Sunday', '02:16', '02:52', 94, 'High-Speed');
INSERT INTO routes VALUES('w8p0G7', 'Philadelphia', 'Atlanta', 'Wednesday', '17:13', '18:36', 53, 'Inter-City');
INSERT INTO routes VALUES('v6m7o5', 'Philadelphia', 'Detroit', 'Friday', '01:56', '06:22', 14, 'Inter-City');
INSERT INTO routes VALUES('D9N5N3', 'Los Angeles', 'Chicago', 'Wednesday', '09:21', '13:17', 77, 'Passenger');
INSERT INTO routes VALUES('d9A4l0', 'Phoenix', 'New York', 'Tuesday', '03:38', '10:48', 42, 'Inter-City');
INSERT INTO routes VALUES('O0x2N7', 'Los Angeles', 'Atlanta', 'Saturday', '13:36', '21:09', 77, 'High-Speed');
INSERT INTO routes VALUES('X1g0P3', 'Atlanta', 'Dallas', 'Tuesday', '14:41', '18:53', 81, 'High-Speed');
INSERT INTO routes VALUES('b5r0e2', 'New York', 'Dallas', 'Friday', '15:55', '22:52', 40, 'High-Speed');
INSERT INTO routes VALUES('p8q5F7', 'Detroit', 'Miami', 'Friday', '17:44', '18:37', 53, 'High-Speed');
INSERT INTO routes VALUES('N1J1D0', 'Los Angeles', 'Detroit', 'Wednesday', '16:27', '18:58', 85, 'Inter-City');
INSERT INTO routes VALUES('v7Z0G7', 'Boston', 'Phoenix', 'Wednesday', '07:22', '15:07', 23, 'Inter-City');
INSERT INTO routes VALUES('A5b7c9', 'Chicago', 'Houston', 'Sunday', '11:36', '19:59', 42, 'Regional');
INSERT INTO routes VALUES('A5h0V6', 'Dallas', 'Atlanta', 'Thursday', '10:12', '18:09', 69, 'Inter-City');
INSERT INTO routes VALUES('s1K9Z2', 'New York', 'Los Angeles', 'Thursday', '03:15', '08:35', 63, 'Inter-City');
INSERT INTO routes VALUES('k5n0q1', 'San Francisco', 'Miami', 'Thursday', '06:36', '08:53', 15, 'Passenger');
INSERT INTO routes VALUES('f5h0Y8', 'Los Angeles', 'Chicago', 'Sunday', '07:24', '10:37', 12, 'High-Speed');
INSERT INTO routes VALUES('G2A8e4', 'Miami', 'Philadelphia', 'Thursday', '13:23', '16:13', 96, 'High-Speed');
INSERT INTO routes VALUES('f0p3l6', 'Atlanta', 'Dallas', 'Friday', '13:42', '21:45', 18, 'Regional');
INSERT INTO routes VALUES('m8Q4B7', 'Boston', 'Chicago', 'Tuesday', '18:56', '21:52', 85, 'Passenger');
INSERT INTO routes VALUES('V9K1t4', 'Philadelphia', 'Phoenix', 'Monday', '07:18', '14:14', 73, 'Passenger');
INSERT INTO routes VALUES('x5P6B0', 'Washington', 'Miami', 'Thursday', '03:53', '05:57', 71, 'Passenger');
INSERT INTO routes VALUES('z3z8h1', 'Houston', 'Detroit', 'Saturday', '05:32', '13:07', 12, 'Inter-City');
INSERT INTO routes VALUES('T3J7I6', 'New York', 'Boston', 'Thursday', '05:46', '11:23', 100, 'Inter-City');
INSERT INTO routes VALUES('I9N6G9', 'Houston', 'Miami', 'Wednesday', '18:03', '19:53', 34, 'Passenger');
INSERT INTO routes VALUES('O2a0p3', 'Dallas', 'Philadelphia', 'Wednesday', '18:23', '23:05', 94, 'Passenger');
INSERT INTO routes VALUES('q8L0s0', 'Boston', 'Los Angeles', 'Thursday', '13:06', '15:17', 16, 'Passenger');
INSERT INTO routes VALUES('e3w3Y5', 'Miami', 'Atlanta', 'Tuesday', '13:45', '15:52', 74, 'Passenger');
INSERT INTO routes VALUES('l1C8F8', 'Detroit', 'Phoenix', 'Sunday', '04:01', '07:22', 40, 'Passenger');
INSERT INTO routes VALUES('t0b0O9', 'Seattle', 'Los Angeles', 'Thursday', '03:15', '09:58', 46, 'Regional');
INSERT INTO routes VALUES('T0j4l3', 'Los Angeles', 'Atlanta', 'Saturday', '00:23', '01:10', 12, 'Regional');
INSERT INTO routes VALUES('D8E3f6', 'Detroit', 'Philadelphia', 'Saturday', '19:51', '20:21', 20, 'Regional');
INSERT INTO routes VALUES('h8I2p9', 'Philadelphia', 'Phoenix', 'Tuesday', '11:13', '14:16', 100, 'Inter-City');
INSERT INTO routes VALUES('P8M1S7', 'Chicago', 'Dallas', 'Friday', '12:02', '16:22', 82, 'Inter-City');
INSERT INTO routes VALUES('O5I4Z6', 'Seattle', 'Boston', 'Saturday', '11:36', '12:17', 74, 'Inter-City');
INSERT INTO routes VALUES('g5D2G0', 'Houston', 'San Francisco', 'Monday', '08:47', '10:37', 65, 'Inter-City');
INSERT INTO routes VALUES('k8L7a8', 'Phoenix', 'Seattle', 'Friday', '02:32', '06:27', 17, 'Regional');
INSERT INTO routes VALUES('L0U5a8', 'Miami', 'Los Angeles', 'Sunday', '04:20', '07:59', 49, 'Regional');
INSERT INTO routes VALUES('r0m0B1', 'Washington', 'Boston', 'Tuesday', '05:53', '10:43', 35, 'High-Speed');
INSERT INTO routes VALUES('H3m2b2', 'New York', 'Seattle', 'Sunday', '21:47', '22:44', 56, 'Passenger');
INSERT INTO routes VALUES('J9i3z3', 'New York', 'Washington', 'Tuesday', '04:12', '08:41', 58, 'Passenger');
INSERT INTO routes VALUES('G5I4G1', 'Philadelphia', 'New York', 'Tuesday', '03:45', '07:38', 22, 'Inter-City');
INSERT INTO routes VALUES('W4Z6q6', 'Chicago', 'Miami', 'Wednesday', '14:40', '18:22', 89, 'Regional');
INSERT INTO routes VALUES('C4v5i1', 'Miami', 'Chicago', 'Wednesday', '16:35', '20:01', 64, 'Inter-City');
INSERT INTO routes VALUES('G3Z5P1', 'Houston', 'New York', 'Monday', '13:57', '20:12', 62, 'Regional');
INSERT INTO routes VALUES('e1l4D9', 'Washington', 'Houston', 'Tuesday', '06:33', '07:32', 40, 'Regional');
INSERT INTO routes VALUES('G5p1J5', 'Boston', 'Miami', 'Sunday', '06:46', '11:10', 29, 'Regional');
INSERT INTO routes VALUES('A3c4f4', 'Boston', 'Detroit', 'Sunday', '07:16', '12:46', 35, 'Regional');
INSERT INTO routes VALUES('b0I5W3', 'Houston', 'Miami', 'Sunday', '05:51', '09:26', 37, 'Passenger');
INSERT INTO routes VALUES('t1r3e6', 'San Francisco', 'Miami', 'Saturday', '14:14', '15:21', 97, 'Inter-City');
INSERT INTO routes VALUES('Q2P5z7', 'Boston', 'New York', 'Friday', '09:19', '17:43', 16, 'Passenger');
INSERT INTO routes VALUES('F3T7I8', 'Atlanta', 'Los Angeles', 'Wednesday', '11:35', '15:01', 93, 'Passenger');
INSERT INTO routes VALUES('B8v9a1', 'Detroit', 'Boston', 'Thursday', '18:28', '20:04', 75, 'Passenger');
INSERT INTO routes VALUES('a4h2x4', 'Philadelphia', 'Boston', 'Monday', '02:07', '06:09', 51, 'Inter-City');
INSERT INTO routes VALUES('W9P7x6', 'Philadelphia', 'Washington', 'Tuesday', '13:29', '18:29', 18, 'Regional');
INSERT INTO routes VALUES('Y1I6y1', 'Boston', 'Dallas', 'Wednesday', '01:29', '09:44', 52, 'Passenger');
INSERT INTO routes VALUES('W1m9r0', 'Atlanta', 'Miami', 'Monday', '14:50', '22:55', 85, 'Regional');
INSERT INTO routes VALUES('u5S8m3', 'Phoenix', 'Detroit', 'Friday', '03:17', '06:19', 37, 'Regional');
INSERT INTO routes VALUES('e5o9t8', 'Detroit', 'Philadelphia', 'Sunday', '20:53', '21:28', 100, 'Inter-City');
INSERT INTO routes VALUES('C9P3p3', 'Chicago', 'Los Angeles', 'Monday', '04:09', '12:11', 59, 'Passenger');
INSERT INTO routes VALUES('r8U9J4', 'Los Angeles', 'Detroit', 'Tuesday', '22:16', '23:36', 70, 'High-Speed');
INSERT INTO routes VALUES('A1n5F0', 'Los Angeles', 'Seattle', 'Saturday', '16:46', '19:20', 57, 'Regional');
INSERT INTO routes VALUES('w2P0H6', 'San Francisco', 'Phoenix', 'Saturday', '04:29', '08:36', 55, 'High-Speed');
INSERT INTO routes VALUES('t0R8t2', 'Philadelphia', 'San Francisco', 'Wednesday', '18:21', '22:49', 18, 'Regional');
INSERT INTO routes VALUES('Y0V8K1', 'Chicago', 'Boston', 'Friday', '02:29', '05:53', 31, 'High-Speed');
INSERT INTO routes VALUES('S9N1K8', 'Washington', 'Miami', 'Thursday', '13:08', '14:32', 82, 'Passenger');
INSERT INTO routes VALUES('P0S9E8', 'Seattle', 'Dallas', 'Monday', '06:12', '07:36', 72, 'Inter-City');
INSERT INTO routes VALUES('C4k3b6', 'Dallas', 'Miami', 'Monday', '08:57', '14:14', 14, 'High-Speed');
INSERT INTO routes VALUES('U9t6F0', 'San Francisco', 'Seattle', 'Wednesday', '15:19', '19:36', 13, 'High-Speed');
INSERT INTO routes VALUES('u2w6B3', 'Los Angeles', 'Chicago', 'Thursday', '05:42', '10:54', 30, 'Passenger');
INSERT INTO routes VALUES('X8H0X1', 'Atlanta', 'Dallas', 'Wednesday', '15:45', '16:54', 92, 'High-Speed');
INSERT INTO routes VALUES('C1r5y5', 'Philadelphia', 'Miami', 'Friday', '00:33', '07:33', 45, 'High-Speed');
INSERT INTO routes VALUES('r3O7f6', 'Detroit', 'Dallas', 'Tuesday', '15:20', '17:46', 14, 'Passenger');
INSERT INTO routes VALUES('b8R9w2', 'Seattle', 'Detroit', 'Thursday', '00:25', '01:54', 12, 'Regional');
INSERT INTO routes VALUES('j1t8i5', 'Washington', 'New York', 'Monday', '10:40', '16:19', 16, 'Regional');
INSERT INTO routes VALUES('C1s3x6', 'Boston', 'Detroit', 'Sunday', '04:09', '12:00', 22, 'Regional');
INSERT INTO routes VALUES('L6z3q0', 'Miami', 'Los Angeles', 'Monday', '16:53', '23:36', 99, 'Passenger');
INSERT INTO routes VALUES('U1I0K6', 'Atlanta', 'Phoenix', 'Sunday', '19:41', '20:17', 39, 'Inter-City');
INSERT INTO routes VALUES('f7K9i7', 'Miami', 'Seattle', 'Wednesday', '16:57', '17:08', 75, 'Inter-City');
INSERT INTO routes VALUES('v7I6k3', 'Chicago', 'Washington', 'Friday', '04:24', '09:13', 25, 'High-Speed');
INSERT INTO routes VALUES('L5k9u9', 'Dallas', 'Washington', 'Saturday', '03:06', '06:49', 23, 'Regional');
INSERT INTO routes VALUES('a9L0n2', 'Dallas', 'Washington', 'Saturday', '11:48', '13:31', 48, 'Regional');
INSERT INTO routes VALUES('V1D5Y8', 'Miami', 'Seattle', 'Friday', '01:36', '09:39', 44, 'Regional');
INSERT INTO routes VALUES('D0j2z0', 'Atlanta', 'Chicago', 'Monday', '13:58', '14:58', 23, 'Inter-City');
INSERT INTO routes VALUES('b3l4d7', 'New York', 'Philadelphia', 'Thursday', '11:00', '14:42', 95, 'Regional');
INSERT INTO routes VALUES('a9P9n1', 'Houston', 'Seattle', 'Saturday', '02:18', '03:07', 19, 'High-Speed');
INSERT INTO routes VALUES('x4F1Y1', 'Los Angeles', 'Boston', 'Monday', '17:18', '19:10', 98, 'High-Speed');
INSERT INTO routes VALUES('x2W7U6', 'Philadelphia', 'Seattle', 'Friday', '18:40', '19:03', 20, 'Regional');
INSERT INTO routes VALUES('u7L8P9', 'Dallas', 'San Francisco', 'Thursday', '21:59', '23:19', 80, 'Inter-City');
INSERT INTO routes VALUES('J5F7a6', 'Dallas', 'San Francisco', 'Sunday', '06:22', '13:05', 44, 'Passenger');
INSERT INTO routes VALUES('q4b8I1', 'New York', 'Miami', 'Tuesday', '01:07', '04:23', 46, 'High-Speed');
INSERT INTO routes VALUES('m2O8S7', 'Houston', 'Boston', 'Sunday', '01:11', '08:19', 23, 'Inter-City');
INSERT INTO routes VALUES('o6R3A6', 'Los Angeles', 'Miami', 'Sunday', '03:59', '11:50', 83, 'Passenger');
INSERT INTO routes VALUES('y6E8S8', 'Boston', 'Seattle', 'Tuesday', '09:14', '11:16', 62, 'High-Speed');
INSERT INTO routes VALUES('V3K0g8', 'Boston', 'Washington', 'Tuesday', '15:11', '17:24', 91, 'Inter-City');
INSERT INTO routes VALUES('k1x6W4', 'Phoenix', 'Philadelphia', 'Saturday', '20:12', '22:59', 18, 'Inter-City');
INSERT INTO routes VALUES('Y2d8T3', 'Detroit', 'Philadelphia', 'Sunday', '18:09', '21:50', 41, 'High-Speed');
INSERT INTO routes VALUES('D3g6i0', 'Atlanta', 'Los Angeles', 'Wednesday', '10:18', '14:30', 24, 'High-Speed');
INSERT INTO routes VALUES('p7v6D5', 'New York', 'Chicago', 'Tuesday', '17:14', '19:55', 59, 'Regional');
INSERT INTO routes VALUES('Q9Q7S7', 'Phoenix', 'Boston', 'Tuesday', '01:39', '05:31', 79, 'Regional');
INSERT INTO routes VALUES('v3y4X0', 'Atlanta', 'Detroit', 'Thursday', '08:08', '16:28', 21, 'Inter-City');
INSERT INTO routes VALUES('r9C1w9', 'Houston', 'Miami', 'Sunday', '06:52', '11:38', 73, 'High-Speed');
INSERT INTO routes VALUES('I3s2Y3', 'Dallas', 'San Francisco', 'Wednesday', '20:40', '23:38', 64, 'Inter-City');
INSERT INTO routes VALUES('S8E9X5', 'Phoenix', 'New York', 'Tuesday', '13:38', '18:02', 32, 'Passenger');
INSERT INTO routes VALUES('a4A2n0', 'New York', 'Washington', 'Saturday', '06:47', '07:43', 52, 'High-Speed');
INSERT INTO routes VALUES('L3W1z2', 'Seattle', 'Dallas', 'Saturday', '05:20', '07:00', 20, 'Passenger');
INSERT INTO routes VALUES('o0V8u2', 'Detroit', 'San Francisco', 'Tuesday', '12:51', '15:47', 27, 'Passenger');
INSERT INTO routes VALUES('u7U9t9', 'Atlanta', 'Seattle', 'Tuesday', '01:38', '04:33', 72, 'Inter-City');
INSERT INTO routes VALUES('Q8H2c0', 'Seattle', 'Miami', 'Tuesday', '11:06', '16:00', 30, 'High-Speed');
INSERT INTO routes VALUES('p3b7d3', 'Chicago', 'Detroit', 'Thursday', '11:30', '16:45', 22, 'Inter-City');
INSERT INTO routes VALUES('O2m1O4', 'Detroit', 'Dallas', 'Friday', '20:07', '23:50', 94, 'Passenger');
INSERT INTO routes VALUES('F2f3f1', 'Chicago', 'Detroit', 'Monday', '02:35', '05:55', 71, 'Regional');
INSERT INTO routes VALUES('C7W8Y8', 'Philadelphia', 'Washington', 'Sunday', '16:51', '18:59', 90, 'Passenger');
INSERT INTO routes VALUES('G8c9N0', 'Washington', 'Houston', 'Saturday', '11:39', '17:43', 95, 'Regional');
INSERT INTO routes VALUES('T5S8l6', 'Philadelphia', 'Washington', 'Thursday', '03:14', '11:53', 16, 'High-Speed');
INSERT INTO routes VALUES('R0A4A8', 'Atlanta', 'Phoenix', 'Sunday', '12:50', '15:56', 60, 'Inter-City');
INSERT INTO routes VALUES('C5F1Q1', 'Atlanta', 'Boston', 'Thursday', '07:32', '08:49', 61, 'High-Speed');
INSERT INTO routes VALUES('S8z6c0', 'San Francisco', 'Chicago', 'Tuesday', '11:34', '12:07', 53, 'Passenger');
INSERT INTO routes VALUES('m6i0J1', 'Miami', 'Dallas', 'Saturday', '10:23', '12:41', 90, 'Passenger');
INSERT INTO routes VALUES('M3i0f9', 'San Francisco', 'Houston', 'Sunday', '10:06', '11:36', 98, 'Inter-City');
INSERT INTO routes VALUES('u9I5m4', 'Detroit', 'Phoenix', 'Saturday', '14:20', '16:42', 61, 'Regional');
INSERT INTO routes VALUES('h6s6P5', 'Phoenix', 'Dallas', 'Saturday', '07:27', '14:24', 36, 'High-Speed');
INSERT INTO routes VALUES('g8n6W2', 'Miami', 'New York', 'Wednesday', '01:54', '09:33', 32, 'High-Speed');
INSERT INTO routes VALUES('n3P9N8', 'Detroit', 'Phoenix', 'Friday', '06:35', '10:34', 25, 'Regional');
INSERT INTO routes VALUES('X9m9t8', 'Chicago', 'Miami', 'Friday', '17:35', '21:17', 10, 'High-Speed');
INSERT INTO routes VALUES('m8O4a6', 'Seattle', 'San Francisco', 'Saturday', '02:19', '08:52', 30, 'Inter-City');
INSERT INTO routes VALUES('X7I2l3', 'New York', 'Boston', 'Thursday', '13:23', '17:12', 26, 'Inter-City');
INSERT INTO routes VALUES('e8W2c3', 'Houston', 'New York', 'Saturday', '17:46', '21:39', 70, 'Regional');
INSERT INTO routes VALUES('T9Y2Y1', 'Philadelphia', 'Phoenix', 'Monday', '00:50', '06:34', 77, 'Regional');
INSERT INTO routes VALUES('j2o5J6', 'Seattle', 'Washington', 'Friday', '15:22', '23:15', 96, 'Inter-City');
INSERT INTO routes VALUES('s2W9u4', 'New York', 'Atlanta', 'Monday', '05:41', '07:11', 72, 'Passenger');
INSERT INTO routes VALUES('H3g5o2', 'Atlanta', 'Washington', 'Thursday', '04:01', '08:44', 23, 'High-Speed');
INSERT INTO routes VALUES('B6f4T3', 'San Francisco', 'Detroit', 'Thursday', '19:03', '22:14', 50, 'High-Speed');
INSERT INTO routes VALUES('q9T7d8', 'Miami', 'Detroit', 'Sunday', '16:03', '17:19', 97, 'High-Speed');
INSERT INTO routes VALUES('X5M3a9', 'Los Angeles', 'Chicago', 'Monday', '00:06', '04:29', 93, 'High-Speed');
INSERT INTO routes VALUES('Z2z3g7', 'Atlanta', 'Seattle', 'Wednesday', '06:35', '14:45', 88, 'High-Speed');
INSERT INTO routes VALUES('A4a5H7', 'Miami', 'Atlanta', 'Sunday', '08:23', '13:13', 25, 'Inter-City');
INSERT INTO routes VALUES('i7G5i4', 'Phoenix', 'Boston', 'Wednesday', '02:19', '07:40', 64, 'Passenger');
INSERT INTO routes VALUES('H5w4Z2', 'Detroit', 'Philadelphia', 'Friday', '15:43', '20:30', 18, 'Inter-City');
INSERT INTO routes VALUES('L8H2g5', 'Seattle', 'Atlanta', 'Wednesday', '12:31', '18:15', 83, 'Passenger');
INSERT INTO routes VALUES('H1s8l6', 'Atlanta', 'Miami', 'Wednesday', '06:55', '13:52', 28, 'Inter-City');
INSERT INTO routes VALUES('r6Q3G7', 'Atlanta', 'Chicago', 'Thursday', '14:27', '19:31', 85, 'High-Speed');
INSERT INTO routes VALUES('g9h4s5', 'San Francisco', 'Los Angeles', 'Monday', '06:38', '07:05', 16, 'Passenger');
INSERT INTO routes VALUES('Q7y9Y4', 'Seattle', 'Boston', 'Friday', '00:52', '03:02', 71, 'Inter-City');
INSERT INTO routes VALUES('x5o9V5', 'New York', 'Miami', 'Monday', '08:14', '16:01', 89, 'Regional');
INSERT INTO routes VALUES('i8U0N5', 'Chicago', 'Houston', 'Tuesday', '18:00', '23:48', 69, 'Inter-City');
INSERT INTO routes VALUES('L2m2a5', 'Chicago', 'Los Angeles', 'Saturday', '04:45', '10:17', 17, 'Inter-City');
INSERT INTO routes VALUES('G5u5q1', 'Philadelphia', 'Dallas', 'Thursday', '12:32', '20:32', 37, 'Passenger');
INSERT INTO routes VALUES('j4E7t4', 'Phoenix', 'Seattle', 'Saturday', '15:07', '17:07', 34, 'High-Speed');
INSERT INTO routes VALUES('J1N9S5', 'San Francisco', 'Seattle', 'Saturday', '09:36', '10:02', 95, 'Regional');
INSERT INTO routes VALUES('k8V3L0', 'Philadelphia', 'Atlanta', 'Tuesday', '20:17', '20:53', 60, 'High-Speed');
INSERT INTO routes VALUES('k0Z8f0', 'Washington', 'Detroit', 'Thursday', '05:31', '10:29', 93, 'Inter-City');
INSERT INTO routes VALUES('N2l2K5', 'Chicago', 'Philadelphia', 'Friday', '18:29', '19:08', 92, 'Passenger');
INSERT INTO routes VALUES('o9S7Z6', 'Boston', 'Philadelphia', 'Thursday', '17:10', '19:19', 81, 'High-Speed');
INSERT INTO routes VALUES('e8C5b5', 'Washington', 'Atlanta', 'Friday', '16:59', '18:13', 53, 'Inter-City');
INSERT INTO routes VALUES('a1N5P2', 'Boston', 'San Francisco', 'Sunday', '11:27', '17:41', 35, 'Passenger');
INSERT INTO routes VALUES('u5W0m7', 'Dallas', 'San Francisco', 'Sunday', '02:12', '09:13', 38, 'Inter-City');
INSERT INTO routes VALUES('W5P9q7', 'Dallas', 'Philadelphia', 'Sunday', '12:28', '15:06', 23, 'Passenger');
INSERT INTO routes VALUES('R1r3p1', 'Boston', 'Philadelphia', 'Friday', '04:31', '12:24', 34, 'Regional');
INSERT INTO routes VALUES('A9E8u4', 'Washington', 'Boston', 'Thursday', '06:32', '07:53', 97, 'Regional');
INSERT INTO routes VALUES('Y9w0J4', 'New York', 'Dallas', 'Tuesday', '09:52', '16:46', 80, 'Regional');
INSERT INTO routes VALUES('W5i1v8', 'Seattle', 'Chicago', 'Thursday', '10:25', '14:12', 62, 'Inter-City');
INSERT INTO routes VALUES('L5n8U5', 'Atlanta', 'Miami', 'Wednesday', '04:26', '07:00', 54, 'High-Speed');
INSERT INTO routes VALUES('t5Z3C3', 'Seattle', 'New York', 'Friday', '07:35', '09:56', 33, 'Inter-City');
INSERT INTO routes VALUES('P0p4f7', 'Philadelphia', 'Los Angeles', 'Saturday', '08:33', '16:55', 59, 'Passenger');
INSERT INTO routes VALUES('D0P2o3', 'Seattle', 'San Francisco', 'Monday', '02:12', '04:30', 64, 'High-Speed');
INSERT INTO routes VALUES('j1t3x8', 'Atlanta', 'Seattle', 'Wednesday', '06:45', '12:51', 12, 'Passenger');
INSERT INTO routes VALUES('W5Q8M4', 'Seattle', 'Miami', 'Sunday', '01:06', '05:50', 62, 'Regional');
INSERT INTO routes VALUES('y4m1Q9', 'Dallas', 'Boston', 'Wednesday', '06:31', '11:57', 28, 'High-Speed');
INSERT INTO routes VALUES('e9t3U9', 'Los Angeles', 'San Francisco', 'Saturday', '11:11', '13:10', 20, 'Passenger');
INSERT INTO routes VALUES('b4k9o4', 'Los Angeles', 'Phoenix', 'Thursday', '10:11', '13:11', 62, 'Passenger');
INSERT INTO routes VALUES('L0f4J5', 'San Francisco', 'Boston', 'Thursday', '10:51', '12:16', 28, 'Inter-City');
INSERT INTO routes VALUES('c5v2x2', 'Washington', 'Seattle', 'Thursday', '19:49', '23:23', 28, 'High-Speed');
INSERT INTO routes VALUES('t4N7n8', 'Los Angeles', 'Phoenix', 'Monday', '15:19', '16:16', 100, 'High-Speed');
INSERT INTO routes VALUES('d0P7E0', 'Detroit', 'New York', 'Wednesday', '06:08', '08:27', 54, 'Inter-City');
INSERT INTO routes VALUES('q9q9z8', 'Detroit', 'San Francisco', 'Sunday', '08:53', '14:04', 38, 'Passenger');
INSERT INTO routes VALUES('S7R3Z7', 'Philadelphia', 'Chicago', 'Saturday', '15:29', '21:13', 45, 'Inter-City');
INSERT INTO routes VALUES('v2L2o5', 'Boston', 'San Francisco', 'Monday', '01:32', '05:09', 80, 'Passenger');
INSERT INTO routes VALUES('i2U2T2', 'Miami', 'San Francisco', 'Wednesday', '06:43', '08:05', 22, 'Regional');
INSERT INTO routes VALUES('I6j3p8', 'Phoenix', 'Philadelphia', 'Thursday', '00:15', '03:50', 29, 'Regional');
INSERT INTO routes VALUES('G1a2n6', 'Chicago', 'Los Angeles', 'Wednesday', '03:01', '10:03', 43, 'Inter-City');
INSERT INTO routes VALUES('B8f1R4', 'Los Angeles', 'Seattle', 'Thursday', '08:27', '15:06', 53, 'High-Speed');
INSERT INTO routes VALUES('J6Z1U5', 'Detroit', 'Philadelphia', 'Monday', '12:35', '20:17', 32, 'Passenger');
INSERT INTO routes VALUES('d0d5g1', 'Miami', 'Detroit', 'Sunday', '15:47', '18:31', 40, 'High-Speed');
INSERT INTO routes VALUES('R0G5J6', 'Dallas', 'New York', 'Thursday', '06:44', '10:55', 18, 'High-Speed');
INSERT INTO routes VALUES('y7p9M2', 'New York', 'Los Angeles', 'Thursday', '17:16', '21:29', 56, 'Passenger');
INSERT INTO routes VALUES('N0z4i5', 'Miami', 'Phoenix', 'Saturday', '14:52', '20:02', 13, 'Passenger');
INSERT INTO routes VALUES('G6J1T7', 'Boston', 'New York', 'Sunday', '04:06', '05:22', 14, 'High-Speed');
INSERT INTO routes VALUES('c0F0A3', 'Houston', 'Los Angeles', 'Monday', '00:33', '07:13', 26, 'Inter-City');
INSERT INTO routes VALUES('c6C4C6', 'Dallas', 'Philadelphia', 'Monday', '11:22', '16:51', 55, 'Regional');
INSERT INTO routes VALUES('f4A7l8', 'Atlanta', 'Seattle', 'Monday', '13:40', '21:40', 63, 'High-Speed');
INSERT INTO routes VALUES('a6E2O3', 'Atlanta', 'Detroit', 'Tuesday', '14:26', '19:49', 32, 'Regional');
INSERT INTO routes VALUES('B4l9i8', 'Phoenix', 'Los Angeles', 'Thursday', '07:43', '08:41', 21, 'Inter-City');
INSERT INTO routes VALUES('C3D1Z8', 'Houston', 'Phoenix', 'Friday', '15:22', '16:26', 35, 'High-Speed');
INSERT INTO routes VALUES('G0y0S1', 'Washington', 'Dallas', 'Wednesday', '12:33', '20:58', 17, 'Regional');
INSERT INTO routes VALUES('f0q0H2', 'Los Angeles', 'Houston', 'Sunday', '05:03', '13:54', 43, 'High-Speed');
INSERT INTO routes VALUES('J7m5P2', 'Dallas', 'New York', 'Sunday', '04:43', '12:22', 93, 'Inter-City');
INSERT INTO routes VALUES('h7V2M2', 'Chicago', 'Boston', 'Saturday', '05:17', '06:15', 88, 'Passenger');
INSERT INTO routes VALUES('a1l0m9', 'San Francisco', 'Los Angeles', 'Saturday', '07:10', '11:36', 46, 'Regional');
INSERT INTO routes VALUES('Q2f6p2', 'Seattle', 'Miami', 'Friday', '15:30', '20:47', 38, 'Regional');
INSERT INTO routes VALUES('Y1w3J2', 'Dallas', 'Los Angeles', 'Monday', '11:16', '12:43', 66, 'High-Speed');
INSERT INTO routes VALUES('C9H2J8', 'New York', 'Chicago', 'Monday', '18:44', '19:51', 51, 'High-Speed');
INSERT INTO routes VALUES('R9v7a2', 'San Francisco', 'Los Angeles', 'Tuesday', '08:21', '16:31', 96, 'High-Speed');
INSERT INTO routes VALUES('W4y6F5', 'Miami', 'New York', 'Friday', '08:28', '12:17', 23, 'High-Speed');
INSERT INTO routes VALUES('L7q0J1', 'New York', 'Chicago', 'Monday', '12:31', '20:25', 26, 'Inter-City');
INSERT INTO routes VALUES('N7K1i6', 'Seattle', 'Washington', 'Saturday', '15:24', '23:05', 82, 'High-Speed');
INSERT INTO routes VALUES('V6O2r6', 'Detroit', 'Phoenix', 'Saturday', '11:03', '18:15', 55, 'Passenger');
INSERT INTO routes VALUES('M7n2G1', 'San Francisco', 'Miami', 'Sunday', '12:03', '17:49', 36, 'High-Speed');
INSERT INTO routes VALUES('Z5I0W7', 'New York', 'Houston', 'Sunday', '11:34', '16:06', 20, 'Inter-City');
INSERT INTO routes VALUES('w3F2k4', 'Seattle', 'Los Angeles', 'Sunday', '04:16', '08:09', 78, 'Inter-City');
INSERT INTO routes VALUES('x8i1A5', 'Los Angeles', 'Phoenix', 'Wednesday', '19:47', '20:34', 44, 'Passenger');
INSERT INTO routes VALUES('S7T5D1', 'Los Angeles', 'Washington', 'Saturday', '17:47', '19:35', 11, 'Passenger');
INSERT INTO routes VALUES('H3k2q0', 'Seattle', 'Detroit', 'Tuesday', '01:32', '03:40', 54, 'Passenger');
INSERT INTO routes VALUES('T9M7V3', 'Dallas', 'Philadelphia', 'Wednesday', '13:59', '16:26', 15, 'High-Speed');
INSERT INTO routes VALUES('Q4M2G8', 'Philadelphia', 'San Francisco', 'Wednesday', '09:03', '12:00', 33, 'Passenger');
INSERT INTO routes VALUES('s4E0u7', 'Dallas', 'San Francisco', 'Tuesday', '08:13', '10:10', 73, 'Passenger');
INSERT INTO routes VALUES('R9v8p2', 'Miami', 'Houston', 'Wednesday', '10:07', '12:58', 62, 'Inter-City');
INSERT INTO routes VALUES('D5N4E0', 'Chicago', 'Miami', 'Sunday', '20:25', '22:19', 36, 'Regional');
INSERT INTO routes VALUES('v9c4X1', 'Seattle', 'Detroit', 'Thursday', '15:37', '21:44', 70, 'Passenger');
INSERT INTO routes VALUES('n3N9H7', 'Miami', 'Dallas', 'Saturday', '06:39', '08:14', 14, 'High-Speed');
INSERT INTO routes VALUES('N2r3k0', 'Atlanta', 'Phoenix', 'Tuesday', '08:04', '11:24', 29, 'Inter-City');
INSERT INTO routes VALUES('s3H8I5', 'San Francisco', 'Boston', 'Monday', '21:28', '22:40', 13, 'Passenger');
INSERT INTO routes VALUES('Z1d9g3', 'Detroit', 'Dallas', 'Sunday', '15:00', '23:00', 11, 'High-Speed');
INSERT INTO routes VALUES('S3B7a9', 'Philadelphia', 'Dallas', 'Monday', '09:03', '12:00', 69, 'Regional');
INSERT INTO routes VALUES('A5U3Q8', 'Phoenix', 'San Francisco', 'Saturday', '01:32', '02:20', 79, 'Regional');
INSERT INTO routes VALUES('K6X3y1', 'Philadelphia', 'Seattle', 'Friday', '13:45', '15:35', 56, 'High-Speed');
INSERT INTO routes VALUES('A1e1L2', 'Boston', 'New York', 'Sunday', '05:56', '10:01', 25, 'High-Speed');
INSERT INTO routes VALUES('M2d5K9', 'Boston', 'San Francisco', 'Friday', '12:22', '14:19', 11, 'Regional');
INSERT INTO routes VALUES('U3U4T7', 'Philadelphia', 'Miami', 'Friday', '07:08', '08:46', 80, 'Inter-City');
INSERT INTO routes VALUES('G8Q1j7', 'Chicago', 'San Francisco', 'Thursday', '13:46', '18:19', 54, 'Regional');
INSERT INTO routes VALUES('J5z3v5', 'Miami', 'San Francisco', 'Sunday', '05:05', '08:14', 93, 'Regional');
INSERT INTO routes VALUES('U1U0b5', 'San Francisco', 'Dallas', 'Wednesday', '03:16', '05:57', 35, 'Regional');
INSERT INTO routes VALUES('G2N5q9', 'Los Angeles', 'Houston', 'Friday', '19:39', '20:00', 88, 'Inter-City');
INSERT INTO routes VALUES('H5k2L8', 'Houston', 'Dallas', 'Wednesday', '13:42', '16:30', 37, 'Passenger');
INSERT INTO routes VALUES('c3j3v8', 'Boston', 'Atlanta', 'Friday', '06:10', '14:12', 61, 'Regional');
INSERT INTO routes VALUES('i0m2B3', 'Chicago', 'Atlanta', 'Monday', '04:58', '11:00', 47, 'High-Speed');
INSERT INTO routes VALUES('A3O2e9', 'Miami', 'Washington', 'Saturday', '15:44', '21:32', 55, 'Passenger');
INSERT INTO routes VALUES('A6l0a0', 'Miami', 'Philadelphia', 'Wednesday', '05:15', '10:03', 22, 'Passenger');
INSERT INTO routes VALUES('k6U2b6', 'New York', 'Washington', 'Sunday', '02:34', '10:15', 84, 'High-Speed');
INSERT INTO routes VALUES('O5W2a3', 'Miami', 'Seattle', 'Wednesday', '16:13', '17:14', 59, 'Inter-City');
INSERT INTO routes VALUES('x8q2f2', 'Philadelphia', 'New York', 'Friday', '03:28', '11:53', 50, 'Regional');
INSERT INTO routes VALUES('n2j3h3', 'Washington', 'Los Angeles', 'Sunday', '15:52', '19:25', 40, 'Passenger');
INSERT INTO routes VALUES('q4S7B7', 'Philadelphia', 'Washington', 'Sunday', '01:13', '09:18', 50, 'Regional');
INSERT INTO routes VALUES('G1u2W5', 'Dallas', 'Los Angeles', 'Monday', '07:53', '15:00', 52, 'High-Speed');
INSERT INTO routes VALUES('V6g2f2', 'Chicago', 'Miami', 'Friday', '10:12', '11:59', 42, 'Passenger');
INSERT INTO routes VALUES('X8S2r2', 'Dallas', 'Philadelphia', 'Sunday', '08:21', '11:32', 60, 'High-Speed');
INSERT INTO routes VALUES('H7G8B2', 'Seattle', 'Washington', 'Thursday', '10:45', '13:41', 33, 'Passenger');
INSERT INTO routes VALUES('f8l4m4', 'Miami', 'Chicago', 'Thursday', '10:49', '18:12', 70, 'Inter-City');
INSERT INTO routes VALUES('j7H3z9', 'Chicago', 'Miami', 'Tuesday', '10:32', '14:49', 11, 'Passenger');
INSERT INTO routes VALUES('X9W3x3', 'New York', 'Detroit', 'Thursday', '08:59', '13:48', 32, 'Regional');
INSERT INTO routes VALUES('c1t0X8', 'Seattle', 'Philadelphia', 'Wednesday', '12:39', '20:28', 16, 'High-Speed');
INSERT INTO routes VALUES('L9w1L5', 'Phoenix', 'San Francisco', 'Sunday', '05:32', '11:46', 11, 'High-Speed');
INSERT INTO routes VALUES('A8g6B6', 'San Francisco', 'Washington', 'Sunday', '06:58', '10:46', 67, 'Regional');
INSERT INTO routes VALUES('n7h1f0', 'Houston', 'Seattle', 'Friday', '15:34', '19:17', 39, 'Inter-City');
INSERT INTO routes VALUES('B0U0P1', 'New York', 'Boston', 'Friday', '01:53', '08:43', 63, 'Inter-City');
INSERT INTO routes VALUES('W0Z0F8', 'Phoenix', 'Los Angeles', 'Saturday', '09:09', '16:08', 68, 'Regional');
INSERT INTO routes VALUES('Z4N4T5', 'Atlanta', 'Philadelphia', 'Sunday', '13:53', '14:11', 84, 'Inter-City');
INSERT INTO routes VALUES('z7B9D8', 'Philadelphia', 'Washington', 'Monday', '02:38', '06:15', 71, 'Passenger');
INSERT INTO routes VALUES('y0B0m2', 'Detroit', 'Houston', 'Monday', '15:24', '20:01', 37, 'Passenger');
INSERT INTO routes VALUES('G6X7f1', 'New York', 'Washington', 'Tuesday', '00:46', '04:28', 78, 'High-Speed');
INSERT INTO routes VALUES('I5p1u4', 'Detroit', 'New York', 'Wednesday', '08:44', '15:40', 91, 'Regional');
INSERT INTO routes VALUES('X4z9F4', 'Chicago', 'Seattle', 'Saturday', '05:09', '09:09', 74, 'Inter-City');
INSERT INTO routes VALUES('O5T1y1', 'New York', 'Houston', 'Friday', '07:34', '10:24', 69, 'Regional');
INSERT INTO routes VALUES('k5U4r2', 'Miami', 'Washington', 'Thursday', '07:39', '10:31', 58, 'Passenger');
INSERT INTO routes VALUES('t5H3B6', 'Chicago', 'Boston', 'Monday', '17:34', '18:40', 45, 'Regional');
INSERT INTO routes VALUES('I5D4p5', 'Phoenix', 'Philadelphia', 'Sunday', '00:04', '06:39', 70, 'High-Speed');
INSERT INTO routes VALUES('b0m1T2', 'Seattle', 'Boston', 'Wednesday', '02:38', '05:52', 67, 'Regional');
INSERT INTO routes VALUES('L9a8p6', 'Chicago', 'Phoenix', 'Monday', '03:06', '06:54', 34, 'High-Speed');
INSERT INTO routes VALUES('s9G3J7', 'New York', 'Philadelphia', 'Friday', '09:42', '10:14', 59, 'High-Speed');
INSERT INTO routes VALUES('f9h0Z1', 'Boston', 'Los Angeles', 'Friday', '09:58', '12:52', 84, 'Regional');
INSERT INTO routes VALUES('C7l4R1', 'Washington', 'New York', 'Tuesday', '16:00', '23:34', 63, 'High-Speed');
INSERT INTO routes VALUES('l9j4B5', 'New York', 'Boston', 'Sunday', '01:09', '07:44', 86, 'Inter-City');
INSERT INTO routes VALUES('q3T1Y6', 'Houston', 'Phoenix', 'Sunday', '05:01', '05:53', 56, 'Regional');
INSERT INTO routes VALUES('z1x1F2', 'Phoenix', 'New York', 'Wednesday', '06:50', '10:40', 80, 'High-Speed');
INSERT INTO routes VALUES('D5V5n3', 'Seattle', 'Dallas', 'Monday', '00:44', '03:55', 70, 'High-Speed');
INSERT INTO routes VALUES('Q3i1Q4', 'San Francisco', 'Chicago', 'Monday', '02:08', '06:57', 74, 'High-Speed');
INSERT INTO routes VALUES('w0B0J7', 'Detroit', 'Houston', 'Saturday', '11:56', '15:59', 70, 'Passenger');
INSERT INTO routes VALUES('b2z0d9', 'Philadelphia', 'Chicago', 'Tuesday', '12:45', '17:14', 27, 'Regional');
INSERT INTO routes VALUES('J3w8M7', 'Houston', 'Los Angeles', 'Wednesday', '09:27', '13:41', 97, 'Inter-City');
INSERT INTO routes VALUES('x8g3F3', 'Atlanta', 'Seattle', 'Thursday', '00:20', '04:27', 53, 'Inter-City');
INSERT INTO routes VALUES('l5k8W7', 'Washington', 'Miami', 'Monday', '06:56', '14:37', 72, 'Passenger');
INSERT INTO routes VALUES('l9t7X5', 'Seattle', 'Washington', 'Wednesday', '10:34', '14:26', 93, 'Inter-City');
INSERT INTO routes VALUES('y2W1I8', 'Seattle', 'Miami', 'Monday', '18:47', '22:41', 89, 'Passenger');
INSERT INTO routes VALUES('x8l7T4', 'Seattle', 'Boston', 'Wednesday', '05:01', '10:40', 98, 'Regional');
INSERT INTO routes VALUES('O4n0G5', 'Chicago', 'Los Angeles', 'Thursday', '18:05', '20:59', 22, 'Inter-City');
INSERT INTO routes VALUES('D1t8i5', 'Dallas', 'New York', 'Tuesday', '17:54', '19:21', 88, 'Regional');
INSERT INTO routes VALUES('H0C3X7', 'Boston', 'Atlanta', 'Tuesday', '20:38', '22:14', 59, 'Inter-City');
INSERT INTO routes VALUES('u2e6q5', 'Dallas', 'Houston', 'Sunday', '11:54', '15:09', 57, 'Passenger');
INSERT INTO routes VALUES('f6I2k5', 'Miami', 'Phoenix', 'Tuesday', '14:24', '18:52', 55, 'Passenger');
INSERT INTO routes VALUES('J0h6e0', 'Seattle', 'Boston', 'Sunday', '17:42', '18:56', 29, 'Passenger');
INSERT INTO routes VALUES('R4M8D4', 'Dallas', 'Detroit', 'Sunday', '11:47', '18:39', 22, 'Passenger');
INSERT INTO routes VALUES('b9L8v3', 'Chicago', 'Dallas', 'Tuesday', '14:12', '21:09', 72, 'Passenger');
INSERT INTO routes VALUES('z5S5r0', 'Los Angeles', 'Phoenix', 'Thursday', '06:23', '12:51', 20, 'Passenger');
INSERT INTO routes VALUES('T1R5Z5', 'Boston', 'Los Angeles', 'Wednesday', '08:56', '12:27', 89, 'Regional');
INSERT INTO routes VALUES('Q8T2v4', 'Los Angeles', 'Houston', 'Saturday', '01:14', '09:49', 67, 'Passenger');
INSERT INTO routes VALUES('S5P5w4', 'Boston', 'Detroit', 'Sunday', '05:07', '11:51', 38, 'Regional');
INSERT INTO routes VALUES('D7A8L2', 'Houston', 'San Francisco', 'Wednesday', '01:57', '07:34', 25, 'High-Speed');
INSERT INTO routes VALUES('s2A9i9', 'Phoenix', 'Washington', 'Friday', '11:54', '14:25', 43, 'Regional');
INSERT INTO routes VALUES('l3p6i8', 'Miami', 'Atlanta', 'Saturday', '14:59', '15:55', 77, 'Regional');
INSERT INTO routes VALUES('R3W8c4', 'Miami', 'San Francisco', 'Monday', '11:49', '17:43', 91, 'Regional');
INSERT INTO routes VALUES('e4a2Q9', 'Miami', 'Washington', 'Sunday', '14:57', '18:55', 33, 'High-Speed');
INSERT INTO routes VALUES('A8z9q6', 'Chicago', 'Miami', 'Sunday', '15:54', '18:09', 98, 'Passenger');
INSERT INTO routes VALUES('b1s3D3', 'Chicago', 'Seattle', 'Monday', '18:57', '22:14', 47, 'High-Speed');
INSERT INTO routes VALUES('w8W5Q8', 'San Francisco', 'Seattle', 'Friday', '03:26', '04:18', 74, 'Passenger');
INSERT INTO routes VALUES('H7B0O5', 'Chicago', 'Detroit', 'Thursday', '09:24', '12:57', 57, 'Inter-City');
INSERT INTO routes VALUES('f9W0w5', 'Philadelphia', 'Detroit', 'Tuesday', '11:46', '18:50', 91, 'High-Speed');
INSERT INTO routes VALUES('b6q7S7', 'Seattle', 'Chicago', 'Saturday', '14:04', '20:31', 50, 'High-Speed');
INSERT INTO routes VALUES('Y6H0y5', 'Washington', 'Boston', 'Saturday', '05:22', '09:43', 90, 'Regional');
INSERT INTO routes VALUES('O6Z2d5', 'Atlanta', 'Los Angeles', 'Thursday', '15:08', '17:43', 61, 'Inter-City');
INSERT INTO routes VALUES('j0h4O1', 'Houston', 'Detroit', 'Monday', '08:32', '15:02', 92, 'High-Speed');
INSERT INTO routes VALUES('f3D4e0', 'Detroit', 'Phoenix', 'Wednesday', '06:10', '08:41', 10, 'Inter-City');
INSERT INTO routes VALUES('p2C3q6', 'New York', 'Miami', 'Thursday', '16:51', '18:41', 93, 'Passenger');
INSERT INTO routes VALUES('R5t5F9', 'Seattle', 'Chicago', 'Saturday', '11:25', '19:27', 88, 'High-Speed');
INSERT INTO routes VALUES('m0i7q9', 'Chicago', 'San Francisco', 'Saturday', '17:12', '18:16', 53, 'Inter-City');
INSERT INTO routes VALUES('r3k6n4', 'Detroit', 'Phoenix', 'Friday', '11:41', '12:28', 48, 'Inter-City');
INSERT INTO routes VALUES('O9i0j7', 'Houston', 'Phoenix', 'Friday', '00:46', '04:06', 79, 'Regional');
INSERT INTO routes VALUES('o4e2A7', 'Phoenix', 'Los Angeles', 'Monday', '20:06', '23:28', 68, 'Regional');
INSERT INTO routes VALUES('M9R8U9', 'Seattle', 'Atlanta', 'Thursday', '01:48', '04:30', 40, 'Regional');
INSERT INTO routes VALUES('M5B3i6', 'Philadelphia', 'Washington', 'Wednesday', '09:58', '13:32', 59, 'Inter-City');
INSERT INTO routes VALUES('b5L0W8', 'Houston', 'Atlanta', 'Wednesday', '02:09', '10:07', 46, 'Inter-City');
INSERT INTO routes VALUES('G8p7S3', 'Dallas', 'Phoenix', 'Sunday', '05:42', '08:51', 61, 'Passenger');
INSERT INTO routes VALUES('K9V8J6', 'New York', 'San Francisco', 'Wednesday', '15:59', '18:43', 42, 'Inter-City');
INSERT INTO routes VALUES('Z0r1S9', 'Chicago', 'Los Angeles', 'Monday', '18:04', '23:56', 84, 'Inter-City');
INSERT INTO routes VALUES('f9z3N7', 'Miami', 'Boston', 'Tuesday', '10:40', '15:32', 65, 'High-Speed');
INSERT INTO routes VALUES('k2X7z6', 'Los Angeles', 'Boston', 'Sunday', '07:04', '15:12', 18, 'Regional');
INSERT INTO routes VALUES('D3Q3u4', 'New York', 'Chicago', 'Thursday', '16:55', '20:16', 62, 'Passenger');
INSERT INTO routes VALUES('a8s5v1', 'Dallas', 'Detroit', 'Monday', '09:05', '17:16', 69, 'Regional');
INSERT INTO routes VALUES('M4n4n6', 'Phoenix', 'Houston', 'Thursday', '01:17', '09:09', 28, 'Passenger');
INSERT INTO routes VALUES('C3s6V6', 'Houston', 'Dallas', 'Thursday', '12:01', '16:44', 87, 'Regional');
INSERT INTO routes VALUES('F9A2v8', 'Miami', 'Chicago', 'Sunday', '19:33', '22:24', 75, 'High-Speed');
INSERT INTO routes VALUES('L7l6o0', 'Chicago', 'New York', 'Thursday', '15:11', '17:06', 36, 'Regional');
INSERT INTO routes VALUES('m1L4S4', 'Detroit', 'Boston', 'Thursday', '14:12', '17:41', 70, 'Regional');
INSERT INTO routes VALUES('Z2s9s7', 'Houston', 'Seattle', 'Sunday', '01:59', '04:34', 25, 'Inter-City');
INSERT INTO routes VALUES('u9R3s3', 'Boston', 'Dallas', 'Saturday', '21:45', '22:53', 73, 'Passenger');
INSERT INTO routes VALUES('I8p7e7', 'Dallas', 'Los Angeles', 'Monday', '11:22', '17:04', 80, 'Inter-City');
INSERT INTO routes VALUES('p3R1z8', 'San Francisco', 'Atlanta', 'Tuesday', '21:04', '22:44', 89, 'Passenger');
INSERT INTO routes VALUES('b4b6P7', 'Seattle', 'Atlanta', 'Wednesday', '06:30', '08:38', 100, 'Inter-City');
INSERT INTO routes VALUES('u5L1D1', 'Dallas', 'San Francisco', 'Thursday', '05:49', '12:00', 89, 'High-Speed');
INSERT INTO routes VALUES('b7u9W0', 'Los Angeles', 'Chicago', 'Saturday', '19:51', '21:27', 40, 'Regional');
INSERT INTO routes VALUES('k3C6I0', 'Phoenix', 'Dallas', 'Thursday', '10:03', '17:10', 75, 'Regional');
INSERT INTO routes VALUES('o9p4y4', 'Atlanta', 'Houston', 'Friday', '09:17', '10:39', 41, 'High-Speed');
INSERT INTO routes VALUES('F3B1A4', 'Boston', 'San Francisco', 'Friday', '11:06', '14:39', 78, 'Regional');
INSERT INTO routes VALUES('Y3N7r6', 'Phoenix', 'Seattle', 'Thursday', '11:35', '15:42', 78, 'High-Speed');
INSERT INTO routes VALUES('a0L9S7', 'Miami', 'Seattle', 'Sunday', '14:08', '22:24', 12, 'Passenger');
INSERT INTO routes VALUES('s6b7Q7', 'Houston', 'Boston', 'Wednesday', '05:35', '11:53', 99, 'Inter-City');
INSERT INTO routes VALUES('W9J1g0', 'Dallas', 'Atlanta', 'Tuesday', '06:38', '08:46', 52, 'Regional');
INSERT INTO routes VALUES('Y6j9F4', 'San Francisco', 'Philadelphia', 'Friday', '18:21', '21:07', 59, 'Inter-City');
INSERT INTO routes VALUES('J2l4a6', 'Chicago', 'Los Angeles', 'Friday', '04:22', '11:39', 48, 'High-Speed');
INSERT INTO routes VALUES('U1w5I6', 'New York', 'Houston', 'Wednesday', '13:08', '16:56', 99, 'Regional');
INSERT INTO routes VALUES('P9i7f5', 'Phoenix', 'Chicago', 'Saturday', '06:07', '14:02', 52, 'Regional');
INSERT INTO routes VALUES('M7j8z8', 'Boston', 'Houston', 'Monday', '08:51', '13:02', 47, 'Regional');
INSERT INTO routes VALUES('z1g0L6', 'Washington', 'Phoenix', 'Wednesday', '03:00', '06:00', 27, 'Regional');
INSERT INTO routes VALUES('h3Y4y8', 'Dallas', 'Seattle', 'Friday', '03:09', '04:50', 78, 'High-Speed');
INSERT INTO routes VALUES('r9v6P6', 'Miami', 'Atlanta', 'Sunday', '17:33', '22:46', 71, 'High-Speed');
INSERT INTO routes VALUES('y3K8e5', 'Atlanta', 'San Francisco', 'Tuesday', '04:32', '09:19', 83, 'Inter-City');
INSERT INTO routes VALUES('V8S2A6', 'Phoenix', 'Chicago', 'Tuesday', '01:58', '02:29', 27, 'High-Speed');
INSERT INTO routes VALUES('H5h0G1', 'New York', 'Miami', 'Thursday', '10:26', '17:25', 57, 'Regional');
INSERT INTO routes VALUES('e4Z5i7', 'Seattle', 'Philadelphia', 'Monday', '07:37', '10:05', 59, 'Inter-City');
INSERT INTO routes VALUES('J3b3x9', 'Detroit', 'Chicago', 'Monday', '03:58', '07:27', 47, 'Regional');
INSERT INTO routes VALUES('a0t7O3', 'Phoenix', 'Houston', 'Thursday', '05:32', '13:57', 74, 'Inter-City');
INSERT INTO routes VALUES('k1o0g3', 'Phoenix', 'Boston', 'Wednesday', '17:08', '23:05', 95, 'Passenger');
INSERT INTO routes VALUES('V0Z1X1', 'Philadelphia', 'Miami', 'Monday', '13:25', '19:59', 96, 'Inter-City');
INSERT INTO routes VALUES('D2y7q0', 'Phoenix', 'Detroit', 'Monday', '09:58', '14:08', 14, 'High-Speed');
INSERT INTO routes VALUES('A5m0y8', 'Washington', 'Phoenix', 'Sunday', '16:31', '20:31', 31, 'Regional');
INSERT INTO routes VALUES('P8S1e9', 'Seattle', 'Miami', 'Monday', '09:33', '13:47', 20, 'High-Speed');
INSERT INTO routes VALUES('G3c4k3', 'Washington', 'Los Angeles', 'Wednesday', '19:56', '20:07', 11, 'High-Speed');
INSERT INTO routes VALUES('j7E1k0', 'Seattle', 'Phoenix', 'Tuesday', '02:49', '05:59', 53, 'Regional');
INSERT INTO routes VALUES('I7d6V2', 'New York', 'Houston', 'Saturday', '00:14', '08:02', 46, 'High-Speed');
INSERT INTO routes VALUES('x1O3f5', 'Chicago', 'New York', 'Tuesday', '15:28', '18:23', 91, 'Passenger');
INSERT INTO routes VALUES('E8t3O6', 'Phoenix', 'New York', 'Saturday', '01:20', '03:56', 53, 'Regional');
INSERT INTO routes VALUES('B0g8s3', 'Boston', 'Atlanta', 'Sunday', '13:01', '16:23', 48, 'Passenger');
INSERT INTO routes VALUES('U9Z3b3', 'Boston', 'Washington', 'Monday', '20:18', '22:48', 10, 'Passenger');
INSERT INTO routes VALUES('K0f5S6', 'Washington', 'New York', 'Saturday', '11:08', '19:20', 31, 'High-Speed');
INSERT INTO routes VALUES('M9c4R7', 'San Francisco', 'Los Angeles', 'Saturday', '17:55', '18:16', 51, 'Passenger');
INSERT INTO routes VALUES('G8n1s5', 'Philadelphia', 'Detroit', 'Friday', '04:28', '11:08', 33, 'Inter-City');
INSERT INTO routes VALUES('v7h5D3', 'Phoenix', 'Philadelphia', 'Friday', '14:45', '20:59', 19, 'Inter-City');
INSERT INTO routes VALUES('A4o7T2', 'Philadelphia', 'Detroit', 'Sunday', '03:05', '04:26', 53, 'High-Speed');
INSERT INTO routes VALUES('x2x8O7', 'Philadelphia', 'Chicago', 'Saturday', '08:22', '16:40', 42, 'Passenger');
INSERT INTO routes VALUES('X8l7g2', 'San Francisco', 'Detroit', 'Sunday', '11:14', '13:28', 45, 'Regional');
INSERT INTO routes VALUES('k3A7I7', 'San Francisco', 'New York', 'Thursday', '12:54', '18:23', 32, 'High-Speed');
INSERT INTO routes VALUES('t3K1y0', 'Dallas', 'Philadelphia', 'Thursday', '16:52', '22:27', 14, 'Regional');
INSERT INTO routes VALUES('u2t1z1', 'Miami', 'Houston', 'Wednesday', '00:14', '04:57', 53, 'Passenger');
INSERT INTO routes VALUES('Q7E2r0', 'Phoenix', 'Chicago', 'Sunday', '01:48', '05:41', 97, 'Regional');
INSERT INTO routes VALUES('i2s6q6', 'Washington', 'Chicago', 'Tuesday', '03:29', '08:42', 86, 'Regional');
INSERT INTO routes VALUES('H2t8Z0', 'New York', 'Atlanta', 'Sunday', '22:17', '23:49', 61, 'High-Speed');
INSERT INTO routes VALUES('u4i1L3', 'Detroit', 'Chicago', 'Thursday', '07:20', '15:00', 45, 'High-Speed');
INSERT INTO routes VALUES('c6c8x4', 'Houston', 'Atlanta', 'Saturday', '00:29', '03:35', 74, 'Regional');
INSERT INTO routes VALUES('t9H5A4', 'Seattle', 'Boston', 'Tuesday', '16:37', '22:14', 46, 'High-Speed');
INSERT INTO routes VALUES('m6j4a1', 'Chicago', 'Atlanta', 'Wednesday', '04:33', '11:00', 14, 'Regional');
INSERT INTO routes VALUES('x1M0h7', 'Atlanta', 'San Francisco', 'Sunday', '00:53', '03:49', 30, 'Passenger');
INSERT INTO routes VALUES('s9j5U1', 'Seattle', 'Detroit', 'Monday', '09:58', '16:52', 90, 'Passenger');
INSERT INTO routes VALUES('a0g4B4', 'New York', 'Dallas', 'Friday', '00:03', '07:52', 62, 'Passenger');
INSERT INTO routes VALUES('s1o5Z0', 'Miami', 'Philadelphia', 'Sunday', '01:16', '09:47', 66, 'Inter-City');
INSERT INTO routes VALUES('X7a6j3', 'Boston', 'Los Angeles', 'Sunday', '06:36', '08:05', 97, 'Inter-City');
INSERT INTO routes VALUES('K7c5I8', 'Philadelphia', 'Detroit', 'Tuesday', '13:09', '16:17', 74, 'Inter-City');
INSERT INTO routes VALUES('u2u8Q5', 'New York', 'Detroit', 'Sunday', '21:01', '23:47', 72, 'High-Speed');
INSERT INTO routes VALUES('o5q1G2', 'San Francisco', 'Washington', 'Sunday', '13:06', '17:07', 11, 'Regional');
INSERT INTO routes VALUES('o4w3X7', 'Chicago', 'Seattle', 'Wednesday', '06:33', '14:59', 55, 'High-Speed');
INSERT INTO routes VALUES('i0B4k4', 'San Francisco', 'Miami', 'Sunday', '13:42', '14:12', 88, 'Passenger');
INSERT INTO routes VALUES('m8V5r8', 'Los Angeles', 'Boston', 'Tuesday', '15:04', '17:13', 52, 'Passenger');
INSERT INTO routes VALUES('Q7D7J0', 'Phoenix', 'Seattle', 'Friday', '03:56', '09:37', 93, 'Regional');
INSERT INTO routes VALUES('Q9b4D8', 'Philadelphia', 'San Francisco', 'Sunday', '10:49', '11:25', 81, 'High-Speed');
INSERT INTO routes VALUES('F2o4Y9', 'Philadelphia', 'San Francisco', 'Sunday', '17:18', '19:16', 37, 'Inter-City');
INSERT INTO routes VALUES('b5X6R7', 'Los Angeles', 'San Francisco', 'Thursday', '16:12', '20:23', 94, 'Passenger');
INSERT INTO routes VALUES('C2P0U4', 'Atlanta', 'San Francisco', 'Monday', '00:57', '04:32', 64, 'Passenger');
INSERT INTO routes VALUES('s6P6q4', 'Atlanta', 'Houston', 'Monday', '10:39', '12:27', 34, 'Passenger');
INSERT INTO routes VALUES('l9l7V6', 'Detroit', 'New York', 'Monday', '03:21', '11:52', 88, 'High-Speed');
INSERT INTO routes VALUES('W0A2z3', 'New York', 'Atlanta', 'Wednesday', '05:05', '13:22', 89, 'Inter-City');
INSERT INTO routes VALUES('m9d0N5', 'Dallas', 'Washington', 'Friday', '12:02', '13:39', 95, 'High-Speed');
INSERT INTO routes VALUES('P3v5v2', 'Detroit', 'Philadelphia', 'Saturday', '05:30', '07:03', 26, 'Regional');
INSERT INTO routes VALUES('z8U1C9', 'Atlanta', 'New York', 'Tuesday', '15:05', '17:44', 33, 'Passenger');
INSERT INTO routes VALUES('p4K1n4', 'Dallas', 'Phoenix', 'Sunday', '02:31', '04:50', 86, 'Passenger');
INSERT INTO routes VALUES('c1t9J9', 'Phoenix', 'Atlanta', 'Sunday', '16:37', '22:21', 99, 'High-Speed');
INSERT INTO routes VALUES('O8U4N9', 'Seattle', 'New York', 'Saturday', '00:14', '06:56', 88, 'High-Speed');
INSERT INTO routes VALUES('v2P1k0', 'Los Angeles', 'Seattle', 'Wednesday', '11:24', '17:05', 49, 'High-Speed');
INSERT INTO routes VALUES('d1y1C4', 'San Francisco', 'Washington', 'Saturday', '10:13', '15:42', 21, 'Inter-City');
INSERT INTO routes VALUES('Z4b6b6', 'Boston', 'Phoenix', 'Wednesday', '08:41', '14:23', 84, 'Regional');
INSERT INTO routes VALUES('a1L2O6', 'Los Angeles', 'Phoenix', 'Saturday', '14:01', '18:00', 46, 'High-Speed');
INSERT INTO routes VALUES('v5Z9Y9', 'Houston', 'Detroit', 'Monday', '10:41', '12:46', 20, 'High-Speed');
INSERT INTO routes VALUES('W7L4S1', 'San Francisco', 'Phoenix', 'Sunday', '05:39', '08:41', 48, 'High-Speed');
INSERT INTO routes VALUES('f2z8n3', 'San Francisco', 'Atlanta', 'Sunday', '13:19', '16:24', 74, 'Regional');
INSERT INTO routes VALUES('Q3t1l7', 'Seattle', 'Philadelphia', 'Friday', '09:46', '12:29', 59, 'High-Speed');
INSERT INTO routes VALUES('e5L9g6', 'Detroit', 'Atlanta', 'Friday', '20:10', '21:28', 85, 'Regional');
INSERT INTO routes VALUES('X1z4G6', 'Philadelphia', 'Boston', 'Friday', '09:43', '14:10', 54, 'Regional');
INSERT INTO routes VALUES('C0m0i6', 'Phoenix', 'Houston', 'Tuesday', '13:19', '14:02', 97, 'Regional');
INSERT INTO routes VALUES('i3a8X3', 'Chicago', 'Philadelphia', 'Sunday', '10:40', '15:56', 31, 'High-Speed');
INSERT INTO routes VALUES('g5F9v0', 'Houston', 'Detroit', 'Wednesday', '04:22', '11:06', 64, 'Regional');
INSERT INTO routes VALUES('j2k5j5', 'New York', 'San Francisco', 'Sunday', '02:38', '09:14', 78, 'High-Speed');
INSERT INTO routes VALUES('U8I6s2', 'Atlanta', 'Washington', 'Monday', '16:05', '20:08', 63, 'High-Speed');
INSERT INTO routes VALUES('O1G8V1', 'Seattle', 'Philadelphia', 'Friday', '08:09', '14:53', 98, 'High-Speed');
INSERT INTO routes VALUES('n3S3Q0', 'San Francisco', 'Miami', 'Thursday', '00:27', '04:53', 14, 'Regional');
INSERT INTO routes VALUES('o1E8o2', 'Detroit', 'Phoenix', 'Tuesday', '16:33', '23:35', 48, 'Passenger');
INSERT INTO routes VALUES('Y6z2L7', 'Los Angeles', 'Philadelphia', 'Wednesday', '13:13', '15:13', 69, 'Inter-City');
INSERT INTO routes VALUES('E5g2t2', 'San Francisco', 'Boston', 'Friday', '03:13', '04:24', 85, 'High-Speed');
INSERT INTO routes VALUES('s5L6R4', 'Seattle', 'Boston', 'Sunday', '13:59', '14:51', 33, 'Passenger');
INSERT INTO routes VALUES('B3k3g6', 'Boston', 'Houston', 'Tuesday', '04:38', '08:12', 70, 'Regional');
INSERT INTO routes VALUES('Q4f7G0', 'Detroit', 'Miami', 'Friday', '17:36', '18:21', 25, 'Passenger');
INSERT INTO routes VALUES('F2u1V3', 'Dallas', 'Los Angeles', 'Thursday', '07:23', '08:26', 94, 'Inter-City');
INSERT INTO routes VALUES('a0e6L3', 'Houston', 'San Francisco', 'Saturday', '15:04', '22:26', 21, 'Regional');
INSERT INTO routes VALUES('O7B4O4', 'Detroit', 'Atlanta', 'Sunday', '01:38', '05:36', 50, 'High-Speed');
INSERT INTO routes VALUES('m9W1Y6', 'Philadelphia', 'Seattle', 'Saturday', '02:53', '03:25', 32, 'Regional');
INSERT INTO routes VALUES('U7u0i8', 'Los Angeles', 'Washington', 'Saturday', '12:55', '16:09', 42, 'Regional');
INSERT INTO routes VALUES('D1w8L1', 'Dallas', 'Philadelphia', 'Friday', '06:29', '08:48', 21, 'Inter-City');
INSERT INTO routes VALUES('u0m1w2', 'Philadelphia', 'Washington', 'Sunday', '02:28', '03:36', 72, 'Inter-City');
INSERT INTO routes VALUES('g0w2t7', 'Los Angeles', 'Dallas', 'Monday', '08:11', '11:11', 83, 'Passenger');
INSERT INTO routes VALUES('q2G2c5', 'Phoenix', 'Atlanta', 'Wednesday', '03:15', '05:46', 32, 'Passenger');
INSERT INTO routes VALUES('D8Z9u5', 'Los Angeles', 'Chicago', 'Sunday', '04:55', '08:46', 59, 'Passenger');
INSERT INTO routes VALUES('U5V4v2', 'Los Angeles', 'Phoenix', 'Tuesday', '14:37', '15:50', 17, 'Inter-City');
INSERT INTO routes VALUES('R3R2k0', 'Houston', 'Seattle', 'Sunday', '02:27', '04:23', 19, 'Passenger');
INSERT INTO routes VALUES('L3w0l8', 'Los Angeles', 'Seattle', 'Monday', '11:53', '16:19', 94, 'Regional');
INSERT INTO routes VALUES('r5E0x2', 'Phoenix', 'Seattle', 'Tuesday', '16:15', '18:11', 48, 'High-Speed');
INSERT INTO routes VALUES('h4g7a6', 'Miami', 'Boston', 'Monday', '13:15', '14:35', 40, 'Passenger');
INSERT INTO routes VALUES('t7y0n7', 'Los Angeles', 'New York', 'Tuesday', '05:31', '12:26', 58, 'Inter-City');
INSERT INTO routes VALUES('E3l7S1', 'Atlanta', 'Seattle', 'Sunday', '06:21', '13:03', 93, 'High-Speed');
INSERT INTO routes VALUES('Z9C6e0', 'San Francisco', 'Philadelphia', 'Sunday', '09:05', '10:54', 89, 'High-Speed');
INSERT INTO routes VALUES('t2n9N0', 'Philadelphia', 'Dallas', 'Saturday', '16:30', '19:11', 81, 'Inter-City');
INSERT INTO routes VALUES('G2V0t0', 'Seattle', 'Boston', 'Friday', '02:58', '05:49', 15, 'Regional');
INSERT INTO routes VALUES('M1k0s4', 'Atlanta', 'San Francisco', 'Monday', '19:15', '20:44', 64, 'High-Speed');
INSERT INTO routes VALUES('B7f8g7', 'Dallas', 'Phoenix', 'Monday', '15:26', '23:11', 54, 'Passenger');
INSERT INTO routes VALUES('o7x5C9', 'Chicago', 'Houston', 'Saturday', '03:03', '07:01', 38, 'High-Speed');
INSERT INTO routes VALUES('C6y6x7', 'Miami', 'Boston', 'Monday', '09:43', '13:59', 29, 'Inter-City');
INSERT INTO routes VALUES('k2M5b0', 'Miami', 'Seattle', 'Friday', '16:31', '22:52', 75, 'High-Speed');
INSERT INTO routes VALUES('Z7E1Q0', 'Detroit', 'Miami', 'Sunday', '06:19', '10:17', 88, 'Inter-City');
INSERT INTO routes VALUES('J0m4W4', 'Washington', 'Boston', 'Monday', '02:49', '04:58', 32, 'Regional');
INSERT INTO routes VALUES('X1i9K2', 'Seattle', 'Houston', 'Monday', '11:03', '15:07', 74, 'Regional');
INSERT INTO routes VALUES('T7R9g4', 'Houston', 'Atlanta', 'Saturday', '01:55', '07:37', 88, 'High-Speed');
INSERT INTO routes VALUES('W4q0w7', 'Philadelphia', 'Miami', 'Sunday', '22:01', '22:36', 42, 'High-Speed');
INSERT INTO routes VALUES('T3X2M5', 'Chicago', 'Seattle', 'Tuesday', '08:09', '16:47', 41, 'Passenger');
INSERT INTO routes VALUES('a3k6A4', 'Los Angeles', 'Washington', 'Tuesday', '04:25', '08:58', 19, 'Regional');
INSERT INTO routes VALUES('P9P9S9', 'San Francisco', 'New York', 'Wednesday', '05:15', '13:23', 29, 'Passenger');
INSERT INTO routes VALUES('C2I2i0', 'Atlanta', 'Boston', 'Monday', '02:40', '06:57', 79, 'Regional');
INSERT INTO routes VALUES('o2h2d1', 'Dallas', 'Atlanta', 'Friday', '04:05', '10:13', 82, 'Inter-City');
INSERT INTO routes VALUES('m8g3U4', 'Dallas', 'Chicago', 'Saturday', '03:00', '09:39', 40, 'Regional');
INSERT INTO routes VALUES('x8Z1n1', 'San Francisco', 'Seattle', 'Wednesday', '11:34', '12:43', 37, 'Regional');
INSERT INTO routes VALUES('J6m6X0', 'New York', 'Houston', 'Sunday', '14:11', '20:41', 43, 'Inter-City');
INSERT INTO routes VALUES('U2w8T6', 'Dallas', 'Los Angeles', 'Tuesday', '21:53', '22:39', 78, 'Passenger');
INSERT INTO routes VALUES('T8U5n4', 'Seattle', 'Philadelphia', 'Sunday', '00:04', '05:49', 37, 'Inter-City');
INSERT INTO routes VALUES('B1v1C8', 'Los Angeles', 'Chicago', 'Sunday', '05:21', '07:31', 32, 'Inter-City');
INSERT INTO routes VALUES('o4a5J0', 'Philadelphia', 'Houston', 'Sunday', '04:09', '09:17', 12, 'Passenger');
INSERT INTO routes VALUES('g9g4S8', 'Phoenix', 'Atlanta', 'Sunday', '17:29', '23:43', 28, 'Passenger');
INSERT INTO routes VALUES('x5f8I0', 'Detroit', 'Los Angeles', 'Tuesday', '18:09', '19:57', 52, 'Passenger');
INSERT INTO routes VALUES('q6p7d1', 'Miami', 'Phoenix', 'Friday', '18:08', '20:43', 42, 'Passenger');
INSERT INTO routes VALUES('e2X1h7', 'Washington', 'Boston', 'Sunday', '12:13', '14:13', 76, 'High-Speed');
INSERT INTO routes VALUES('Q4y0h9', 'San Francisco', 'Houston', 'Saturday', '00:51', '05:51', 39, 'High-Speed');
INSERT INTO routes VALUES('r2g5K5', 'Detroit', 'Los Angeles', 'Wednesday', '02:34', '04:26', 12, 'Inter-City');
INSERT INTO routes VALUES('c0X7X6', 'Chicago', 'Phoenix', 'Saturday', '07:35', '14:26', 29, 'Passenger');
INSERT INTO routes VALUES('i5Q8d3', 'Seattle', 'Detroit', 'Friday', '17:59', '19:07', 13, 'Passenger');
INSERT INTO routes VALUES('U4m5d5', 'Detroit', 'Seattle', 'Sunday', '19:57', '20:00', 64, 'Regional');
INSERT INTO routes VALUES('k0F8y3', 'Boston', 'Miami', 'Sunday', '05:22', '06:27', 17, 'High-Speed');
INSERT INTO routes VALUES('P7h3C9', 'Atlanta', 'Dallas', 'Saturday', '16:10', '17:14', 63, 'High-Speed');
INSERT INTO routes VALUES('n8R1i2', 'Philadelphia', 'Seattle', 'Saturday', '11:46', '14:24', 83, 'Inter-City');
INSERT INTO routes VALUES('L4s2H0', 'New York', 'Atlanta', 'Sunday', '17:54', '19:38', 20, 'Passenger');
INSERT INTO routes VALUES('z0d4Y9', 'Washington', 'Los Angeles', 'Friday', '12:17', '15:30', 10, 'Inter-City');
INSERT INTO routes VALUES('X0R4p8', 'Seattle', 'Dallas', 'Saturday', '20:17', '21:56', 44, 'Regional');
INSERT INTO routes VALUES('k2h8f2', 'Detroit', 'Chicago', 'Thursday', '18:34', '21:19', 54, 'Passenger');
INSERT INTO routes VALUES('E3O9l7', 'Atlanta', 'Dallas', 'Thursday', '16:41', '17:31', 87, 'Regional');
INSERT INTO routes VALUES('P4w2H2', 'Dallas', 'Miami', 'Friday', '00:30', '05:35', 38, 'High-Speed');
INSERT INTO routes VALUES('O5r2x4', 'Washington', 'Houston', 'Sunday', '14:25', '21:10', 73, 'Passenger');
INSERT INTO routes VALUES('s9g6G5', 'Houston', 'Seattle', 'Sunday', '14:10', '22:40', 53, 'Passenger');
INSERT INTO routes VALUES('J0C1I9', 'Phoenix', 'Miami', 'Saturday', '21:26', '23:00', 29, 'Inter-City');
INSERT INTO routes VALUES('k6l8r3', 'Seattle', 'Chicago', 'Saturday', '16:13', '17:23', 23, 'Passenger');
INSERT INTO routes VALUES('P2Y5l1', 'Washington', 'San Francisco', 'Monday', '03:29', '06:28', 100, 'High-Speed');
INSERT INTO routes VALUES('Y5D8A7', 'Washington', 'Atlanta', 'Thursday', '06:49', '07:41', 25, 'Regional');
INSERT INTO routes VALUES('Q9p9e7', 'Seattle', 'Boston', 'Saturday', '11:12', '18:43', 38, 'Inter-City');
INSERT INTO routes VALUES('B6P7R7', 'Seattle', 'San Francisco', 'Wednesday', '17:58', '18:19', 59, 'High-Speed');
INSERT INTO routes VALUES('y1F6Q7', 'San Francisco', 'Houston', 'Monday', '00:31', '02:28', 85, 'High-Speed');
INSERT INTO routes VALUES('E5G2x8', 'Washington', 'Chicago', 'Wednesday', '03:08', '10:30', 16, 'Regional');
INSERT INTO routes VALUES('b6R8H2', 'Seattle', 'Atlanta', 'Thursday', '12:39', '13:12', 97, 'High-Speed');
INSERT INTO routes VALUES('g8w5q7', 'Phoenix', 'Houston', 'Thursday', '18:45', '23:55', 44, 'Regional');
INSERT INTO routes VALUES('F3u5O6', 'Los Angeles', 'Detroit', 'Wednesday', '02:44', '05:24', 56, 'Inter-City');
INSERT INTO routes VALUES('F8Y5E3', 'Los Angeles', 'Detroit', 'Friday', '01:35', '08:24', 93, 'Inter-City');
INSERT INTO routes VALUES('K2F0l7', 'Dallas', 'Phoenix', 'Tuesday', '17:06', '22:40', 87, 'Inter-City');
INSERT INTO routes VALUES('V3Z1i7', 'Washington', 'Detroit', 'Friday', '10:35', '17:52', 100, 'High-Speed');
INSERT INTO routes VALUES('A2K5r3', 'Detroit', 'Boston', 'Monday', '09:21', '16:30', 17, 'Regional');
INSERT INTO routes VALUES('F0M1q4', 'Detroit', 'Seattle', 'Monday', '13:26', '14:21', 66, 'Inter-City');
INSERT INTO routes VALUES('j4f8H4', 'New York', 'Boston', 'Thursday', '02:46', '08:17', 16, 'Passenger');
INSERT INTO routes VALUES('q2X0U6', 'Los Angeles', 'San Francisco', 'Wednesday', '12:36', '18:59', 46, 'Passenger');
INSERT INTO routes VALUES('d1Z8y0', 'Seattle', 'Dallas', 'Friday', '06:04', '07:12', 31, 'Regional');
INSERT INTO routes VALUES('k1g7C1', 'Los Angeles', 'Houston', 'Sunday', '07:31', '13:32', 30, 'High-Speed');
INSERT INTO routes VALUES('p1Z9J1', 'Boston', 'Atlanta', 'Monday', '16:11', '16:51', 17, 'Inter-City');
INSERT INTO routes VALUES('W4X3c0', 'Atlanta', 'Detroit', 'Wednesday', '18:35', '21:31', 89, 'Regional');
INSERT INTO routes VALUES('E4k4d1', 'San Francisco', 'Washington', 'Wednesday', '02:38', '08:45', 58, 'Regional');
INSERT INTO routes VALUES('A5r3f4', 'Detroit', 'New York', 'Saturday', '06:01', '06:37', 34, 'Inter-City');
INSERT INTO routes VALUES('G6h1q8', 'Miami', 'Los Angeles', 'Tuesday', '17:44', '23:39', 67, 'High-Speed');
INSERT INTO routes VALUES('g5k9G3', 'Detroit', 'Boston', 'Tuesday', '01:12', '08:58', 32, 'Regional');
INSERT INTO routes VALUES('R5F0R4', 'Phoenix', 'Philadelphia', 'Wednesday', '09:56', '15:37', 38, 'Passenger');
INSERT INTO routes VALUES('k6y2p3', 'Washington', 'Miami', 'Tuesday', '16:14', '22:01', 62, 'Regional');
INSERT INTO routes VALUES('L7s4Y9', 'Atlanta', 'San Francisco', 'Friday', '06:18', '10:56', 41, 'Regional');
INSERT INTO routes VALUES('k8x2K7', 'Houston', 'Detroit', 'Monday', '11:10', '15:13', 92, 'Passenger');
INSERT INTO routes VALUES('q6t0K4', 'Atlanta', 'Houston', 'Friday', '04:14', '12:15', 82, 'Inter-City');
INSERT INTO routes VALUES('G0W9x5', 'Miami', 'Washington', 'Monday', '00:35', '04:06', 44, 'Passenger');
INSERT INTO routes VALUES('x1M0y6', 'Dallas', 'Detroit', 'Wednesday', '07:25', '10:16', 41, 'Passenger');
INSERT INTO routes VALUES('G9C5R1', 'Los Angeles', 'Seattle', 'Sunday', '06:05', '08:51', 60, 'Passenger');
INSERT INTO routes VALUES('b0g6p5', 'Houston', 'Dallas', 'Sunday', '06:47', '14:00', 97, 'Inter-City');
INSERT INTO routes VALUES('s9y5W8', 'Philadelphia', 'Chicago', 'Monday', '03:57', '04:51', 19, 'Passenger');
INSERT INTO routes VALUES('j4M8d3', 'New York', 'Boston', 'Saturday', '18:22', '23:11', 82, 'Regional');
INSERT INTO routes VALUES('p4h2E3', 'San Francisco', 'Washington', 'Monday', '20:44', '22:00', 95, 'Inter-City');
INSERT INTO routes VALUES('j1z2b8', 'Miami', 'Dallas', 'Sunday', '13:23', '16:51', 47, 'High-Speed');
INSERT INTO routes VALUES('N3T4j8', 'Chicago', 'Dallas', 'Saturday', '20:16', '23:08', 74, 'High-Speed');
INSERT INTO routes VALUES('n6b5u8', 'New York', 'Boston', 'Thursday', '06:30', '07:40', 81, 'Inter-City');
INSERT INTO routes VALUES('s3P9y0', 'Atlanta', 'Dallas', 'Tuesday', '05:05', '09:23', 92, 'High-Speed');
INSERT INTO routes VALUES('V0L2f9', 'Miami', 'Dallas', 'Wednesday', '08:32', '16:33', 20, 'High-Speed');
INSERT INTO routes VALUES('g3q4B8', 'New York', 'Philadelphia', 'Saturday', '05:08', '11:15', 26, 'High-Speed');
INSERT INTO routes VALUES('W0W2K9', 'Los Angeles', 'Miami', 'Saturday', '05:08', '10:26', 74, 'Regional');
INSERT INTO routes VALUES('X1N2t9', 'Houston', 'Seattle', 'Wednesday', '15:20', '21:23', 66, 'Regional');
INSERT INTO routes VALUES('F0o3T0', 'Washington', 'Seattle', 'Tuesday', '16:02', '20:08', 81, 'Passenger');
INSERT INTO routes VALUES('s7D7r5', 'San Francisco', 'Philadelphia', 'Saturday', '00:59', '05:25', 82, 'Regional');
INSERT INTO routes VALUES('M4y9j0', 'Detroit', 'Chicago', 'Thursday', '18:41', '21:23', 67, 'Regional');
INSERT INTO routes VALUES('u4e6t0', 'Detroit', 'Dallas', 'Sunday', '03:04', '09:45', 51, 'High-Speed');
INSERT INTO routes VALUES('W9g6Y5', 'Atlanta', 'Philadelphia', 'Thursday', '15:13', '23:37', 13, 'High-Speed');
INSERT INTO routes VALUES('c3c0V6', 'San Francisco', 'Philadelphia', 'Tuesday', '15:59', '21:56', 90, 'Passenger');
INSERT INTO routes VALUES('x5n3A4', 'San Francisco', 'New York', 'Thursday', '12:32', '17:14', 18, 'High-Speed');
INSERT INTO routes VALUES('v4o0V2', 'Seattle', 'Phoenix', 'Sunday', '12:26', '19:06', 70, 'Regional');
INSERT INTO routes VALUES('S7S4G9', 'Phoenix', 'Atlanta', 'Friday', '03:17', '05:03', 58, 'Regional');
INSERT INTO routes VALUES('j7H8r4', 'Atlanta', 'Miami', 'Wednesday', '15:47', '16:52', 22, 'Regional');
INSERT INTO routes VALUES('P8H7r0', 'Miami', 'Detroit', 'Monday', '21:16', '23:56', 22, 'Passenger');
INSERT INTO routes VALUES('z3u3k2', 'Seattle', 'Atlanta', 'Thursday', '11:17', '14:58', 37, 'Passenger');
INSERT INTO routes VALUES('B9e8u5', 'Washington', 'Philadelphia', 'Tuesday', '09:54', '14:20', 97, 'Regional');
INSERT INTO routes VALUES('X5R7m6', 'Los Angeles', 'Atlanta', 'Tuesday', '14:02', '16:25', 59, 'Inter-City');
INSERT INTO routes VALUES('U2W4r9', 'Detroit', 'Philadelphia', 'Saturday', '15:38', '19:07', 41, 'High-Speed');
INSERT INTO routes VALUES('E5P6E2', 'Seattle', 'Philadelphia', 'Friday', '06:39', '11:21', 37, 'Inter-City');
INSERT INTO routes VALUES('y8a6p4', 'Phoenix', 'Los Angeles', 'Saturday', '03:14', '07:51', 75, 'Passenger');
INSERT INTO routes VALUES('r0b8G1', 'Philadelphia', 'Houston', 'Saturday', '13:18', '14:17', 44, 'Inter-City');
INSERT INTO routes VALUES('Q2v6g6', 'Washington', 'Philadelphia', 'Thursday', '11:04', '19:21', 17, 'Passenger');
INSERT INTO routes VALUES('l6B6t7', 'Phoenix', 'Dallas', 'Monday', '07:34', '12:35', 34, 'High-Speed');
INSERT INTO routes VALUES('C5x3z8', 'Seattle', 'New York', 'Sunday', '03:59', '08:30', 83, 'Inter-City');
INSERT INTO routes VALUES('G8c9k7', 'Chicago', 'Boston', 'Wednesday', '04:20', '05:58', 30, 'Inter-City');
INSERT INTO routes VALUES('H0N2y4', 'Boston', 'Philadelphia', 'Monday', '17:49', '22:32', 39, 'Passenger');
INSERT INTO routes VALUES('i1j7x2', 'Boston', 'Atlanta', 'Thursday', '15:07', '19:17', 54, 'Inter-City');
INSERT INTO routes VALUES('V1p3C8', 'Chicago', 'Phoenix', 'Saturday', '04:04', '09:18', 13, 'High-Speed');
INSERT INTO routes VALUES('W3m5R6', 'Philadelphia', 'Phoenix', 'Saturday', '02:17', '05:00', 78, 'High-Speed');
INSERT INTO routes VALUES('x3Z9g3', 'Dallas', 'Chicago', 'Monday', '05:59', '07:47', 64, 'Inter-City');
INSERT INTO routes VALUES('v4k4W6', 'New York', 'Philadelphia', 'Tuesday', '00:01', '04:19', 12, 'Inter-City');
INSERT INTO routes VALUES('s5p9t7', 'Detroit', 'Phoenix', 'Monday', '15:34', '23:42', 15, 'Inter-City');
INSERT INTO routes VALUES('n3N7p0', 'Phoenix', 'Detroit', 'Tuesday', '15:28', '20:27', 58, 'Regional');
INSERT INTO routes VALUES('S6T2N2', 'New York', 'Dallas', 'Tuesday', '10:25', '13:28', 71, 'Inter-City');
INSERT INTO routes VALUES('O3R3x7', 'Chicago', 'Philadelphia', 'Monday', '08:54', '14:31', 48, 'Passenger');
INSERT INTO routes VALUES('e9r2K2', 'Los Angeles', 'Dallas', 'Tuesday', '12:22', '19:27', 72, 'Inter-City');
INSERT INTO routes VALUES('I4Y5E0', 'Boston', 'Detroit', 'Tuesday', '18:53', '20:15', 30, 'High-Speed');
INSERT INTO routes VALUES('v8u0Y6', 'Washington', 'Los Angeles', 'Sunday', '15:52', '19:45', 29, 'Passenger');
INSERT INTO routes VALUES('o5Y1R8', 'New York', 'Houston', 'Saturday', '03:25', '08:37', 58, 'Inter-City');
INSERT INTO routes VALUES('Z9O7v1', 'Seattle', 'Los Angeles', 'Thursday', '17:28', '18:50', 58, 'High-Speed');
INSERT INTO routes VALUES('Z8J6S6', 'Boston', 'Atlanta', 'Saturday', '00:55', '07:04', 42, 'High-Speed');
INSERT INTO routes VALUES('s8d2N7', 'New York', 'Atlanta', 'Thursday', '05:47', '10:07', 50, 'Passenger');
INSERT INTO routes VALUES('o1b4V0', 'Seattle', 'Dallas', 'Sunday', '15:48', '17:35', 32, 'High-Speed');
INSERT INTO routes VALUES('m2b4q6', 'Washington', 'San Francisco', 'Saturday', '14:10', '18:24', 69, 'Passenger');
INSERT INTO routes VALUES('T1a1w9', 'Dallas', 'Houston', 'Friday', '01:45', '02:46', 74, 'High-Speed');
INSERT INTO routes VALUES('P9p3S2', 'Houston', 'Boston', 'Friday', '03:47', '08:29', 98, 'Regional');
INSERT INTO routes VALUES('A7L7Q3', 'Los Angeles', 'New York', 'Thursday', '06:13', '12:57', 95, 'Passenger');
INSERT INTO routes VALUES('Q7p2d0', 'Detroit', 'Los Angeles', 'Monday', '12:40', '16:14', 28, 'Passenger');
INSERT INTO routes VALUES('b7o5D7', 'Atlanta', 'Phoenix', 'Saturday', '06:08', '07:39', 66, 'High-Speed');
INSERT INTO routes VALUES('A4n4T8', 'Dallas', 'Washington', 'Sunday', '14:26', '15:13', 39, 'Inter-City');
INSERT INTO routes VALUES('l4P2s4', 'Chicago', 'Washington', 'Sunday', '14:34', '20:02', 74, 'Regional');
INSERT INTO routes VALUES('f2c1g1', 'Boston', 'Houston', 'Thursday', '11:56', '18:28', 71, 'Regional');
INSERT INTO routes VALUES('U7P9e4', 'Atlanta', 'Washington', 'Tuesday', '02:38', '10:38', 95, 'Passenger');
INSERT INTO routes VALUES('T2c6O4', 'Chicago', 'Detroit', 'Thursday', '00:55', '08:33', 78, 'Passenger');
INSERT INTO routes VALUES('I3Q3p1', 'Boston', 'Chicago', 'Friday', '02:10', '04:33', 56, 'Passenger');
INSERT INTO routes VALUES('c5w9u2', 'Dallas', 'Los Angeles', 'Friday', '14:24', '15:26', 77, 'Inter-City');
INSERT INTO routes VALUES('o5w9E6', 'Seattle', 'Phoenix', 'Friday', '02:42', '04:24', 29, 'Passenger');
INSERT INTO routes VALUES('C4F2r3', 'Los Angeles', 'Chicago', 'Saturday', '17:24', '19:27', 47, 'Inter-City');
INSERT INTO routes VALUES('F0I9g2', 'Washington', 'Houston', 'Saturday', '05:47', '12:45', 87, 'Inter-City');
INSERT INTO routes VALUES('s3E2O1', 'Los Angeles', 'Philadelphia', 'Tuesday', '14:14', '18:52', 71, 'Regional');
INSERT INTO routes VALUES('x7p4O2', 'San Francisco', 'Washington', 'Monday', '06:36', '13:11', 75, 'Passenger');
INSERT INTO routes VALUES('l6J0T6', 'Atlanta', 'Phoenix', 'Tuesday', '10:42', '15:23', 71, 'Inter-City');
INSERT INTO routes VALUES('e7A2o6', 'Detroit', 'New York', 'Tuesday', '16:11', '22:40', 44, 'Passenger');
INSERT INTO routes VALUES('W9B1c5', 'Atlanta', 'Washington', 'Saturday', '15:21', '21:55', 52, 'Inter-City');
INSERT INTO routes VALUES('O0M2b2', 'Washington', 'Detroit', 'Thursday', '17:44', '23:08', 73, 'High-Speed');
INSERT INTO routes VALUES('X5v9h3', 'New York', 'Houston', 'Monday', '04:03', '11:32', 92, 'High-Speed');
INSERT INTO routes VALUES('S4f8Y2', 'Philadelphia', 'Atlanta', 'Friday', '05:31', '13:07', 20, 'Regional');
INSERT INTO routes VALUES('j6w4b2', 'Boston', 'Philadelphia', 'Wednesday', '08:50', '13:54', 29, 'Passenger');
INSERT INTO routes VALUES('n2q4E5', 'Dallas', 'Atlanta', 'Tuesday', '13:08', '20:19', 59, 'Passenger');
INSERT INTO routes VALUES('Y9D0A4', 'Detroit', 'Miami', 'Friday', '00:27', '06:42', 34, 'Passenger');
INSERT INTO routes VALUES('X9T2t7', 'Detroit', 'Philadelphia', 'Sunday', '18:32', '19:11', 15, 'Passenger');
INSERT INTO routes VALUES('Q8d5T0', 'Philadelphia', 'Dallas', 'Sunday', '02:48', '08:36', 13, 'Regional');
INSERT INTO routes VALUES('c0P8y1', 'San Francisco', 'New York', 'Friday', '05:48', '09:26', 88, 'Inter-City');
INSERT INTO routes VALUES('d6E1K9', 'Houston', 'Dallas', 'Thursday', '18:36', '19:11', 64, 'High-Speed');
INSERT INTO routes VALUES('i7K2w1', 'Atlanta', 'Dallas', 'Friday', '06:56', '14:43', 48, 'Regional');
INSERT INTO routes VALUES('R9B0i6', 'Philadelphia', 'New York', 'Thursday', '07:32', '10:33', 13, 'High-Speed');
INSERT INTO routes VALUES('d2b6O3', 'Miami', 'San Francisco', 'Thursday', '20:02', '20:52', 38, 'Passenger');
INSERT INTO routes VALUES('v7o7R8', 'Houston', 'Boston', 'Saturday', '15:26', '22:50', 82, 'High-Speed');
INSERT INTO routes VALUES('X0D4w7', 'Seattle', 'Miami', 'Friday', '18:48', '21:12', 37, 'Inter-City');
INSERT INTO routes VALUES('E9b7m5', 'Boston', 'Houston', 'Monday', '08:29', '15:00', 81, 'Inter-City');
INSERT INTO routes VALUES('s6E7k7', 'New York', 'Dallas', 'Wednesday', '07:35', '12:07', 25, 'Passenger');
INSERT INTO routes VALUES('M6b3R1', 'Chicago', 'New York', 'Wednesday', '12:03', '12:48', 97, 'Regional');
INSERT INTO routes VALUES('T4f4J4', 'Atlanta', 'Miami', 'Thursday', '06:11', '13:23', 53, 'High-Speed');
INSERT INTO routes VALUES('K3P3O2', 'Boston', 'Los Angeles', 'Tuesday', '13:16', '18:42', 23, 'Inter-City');
INSERT INTO routes VALUES('K3g6J3', 'Boston', 'Phoenix', 'Tuesday', '06:22', '09:51', 87, 'Inter-City');
INSERT INTO routes VALUES('e0A7Y7', 'Seattle', 'Miami', 'Monday', '06:36', '11:31', 84, 'Inter-City');
INSERT INTO routes VALUES('u1U5i6', 'Detroit', 'Los Angeles', 'Thursday', '17:37', '19:08', 30, 'Regional');
INSERT INTO routes VALUES('s5K8c2', 'New York', 'San Francisco', 'Thursday', '00:26', '05:15', 51, 'High-Speed');
INSERT INTO routes VALUES('U2F2V3', 'Dallas', 'Boston', 'Sunday', '15:17', '17:22', 80, 'High-Speed');
INSERT INTO routes VALUES('p2D4h0', 'Dallas', 'Los Angeles', 'Friday', '09:37', '15:50', 28, 'Inter-City');
INSERT INTO routes VALUES('a5C7s6', 'Philadelphia', 'San Francisco', 'Tuesday', '16:33', '18:04', 20, 'Inter-City');
INSERT INTO routes VALUES('E5N0S1', 'San Francisco', 'Atlanta', 'Tuesday', '05:06', '11:08', 70, 'High-Speed');
INSERT INTO routes VALUES('s9M4M6', 'Phoenix', 'Miami', 'Wednesday', '02:11', '10:27', 70, 'Inter-City');
INSERT INTO routes VALUES('K2p9v7', 'New York', 'Washington', 'Thursday', '10:23', '11:21', 50, 'Passenger');
INSERT INTO routes VALUES('o1R5u3', 'Detroit', 'Los Angeles', 'Thursday', '13:55', '21:58', 67, 'Inter-City');
INSERT INTO routes VALUES('p6L2k3', 'Miami', 'Phoenix', 'Saturday', '01:39', '05:11', 63, 'Passenger');
INSERT INTO routes VALUES('g9g5F2', 'Philadelphia', 'Dallas', 'Wednesday', '18:28', '19:38', 94, 'High-Speed');
INSERT INTO routes VALUES('f1t6H5', 'Atlanta', 'San Francisco', 'Wednesday', '02:38', '03:23', 23, 'Regional');
INSERT INTO routes VALUES('D3s3t6', 'Los Angeles', 'Boston', 'Monday', '07:59', '09:33', 86, 'Regional');
INSERT INTO routes VALUES('j4H6u9', 'Washington', 'Phoenix', 'Wednesday', '02:48', '05:01', 96, 'High-Speed');
INSERT INTO routes VALUES('G0V6X8', 'Chicago', 'Houston', 'Tuesday', '01:40', '09:58', 13, 'Passenger');
INSERT INTO routes VALUES('y8I5M6', 'Chicago', 'Washington', 'Saturday', '10:32', '11:14', 24, 'Passenger');
INSERT INTO routes VALUES('k6i7w4', 'Dallas', 'Seattle', 'Sunday', '03:19', '06:59', 76, 'Regional');
INSERT INTO routes VALUES('D7l4n5', 'Washington', 'Miami', 'Tuesday', '09:08', '16:43', 63, 'Inter-City');
INSERT INTO routes VALUES('s4B8B6', 'Houston', 'Seattle', 'Monday', '08:17', '11:37', 72, 'High-Speed');
INSERT INTO routes VALUES('f8A6m7', 'Phoenix', 'San Francisco', 'Sunday', '09:07', '14:03', 16, 'Passenger');
INSERT INTO routes VALUES('P0w3S3', 'Washington', 'Houston', 'Thursday', '05:14', '10:01', 76, 'Inter-City');
INSERT INTO routes VALUES('z7j6B6', 'San Francisco', 'New York', 'Friday', '09:34', '13:05', 25, 'Inter-City');
INSERT INTO routes VALUES('N9I5x3', 'Houston', 'Miami', 'Wednesday', '02:44', '10:38', 13, 'Regional');
INSERT INTO routes VALUES('z6z3g5', 'Miami', 'New York', 'Thursday', '13:43', '21:05', 49, 'Inter-City');
INSERT INTO routes VALUES('p8X9k1', 'Washington', 'San Francisco', 'Sunday', '10:32', '16:41', 70, 'Passenger');
INSERT INTO routes VALUES('H7d0P3', 'Los Angeles', 'Boston', 'Thursday', '17:13', '18:34', 67, 'Passenger');
INSERT INTO routes VALUES('x2K5w6', 'New York', 'Dallas', 'Saturday', '11:00', '18:08', 71, 'Passenger');
INSERT INTO routes VALUES('D4W1s0', 'Atlanta', 'Los Angeles', 'Saturday', '04:16', '11:27', 15, 'Passenger');
INSERT INTO routes VALUES('w6V6h3', 'Phoenix', 'Detroit', 'Thursday', '04:50', '10:14', 56, 'Regional');
INSERT INTO routes VALUES('b3y1N4', 'San Francisco', 'Atlanta', 'Sunday', '12:43', '14:58', 95, 'Inter-City');
INSERT INTO routes VALUES('c9i2N0', 'San Francisco', 'Phoenix', 'Friday', '08:11', '14:09', 75, 'Regional');
INSERT INTO routes VALUES('F7X3r9', 'Philadelphia', 'Houston', 'Saturday', '17:27', '23:36', 40, 'Regional');
INSERT INTO routes VALUES('j6p7H1', 'San Francisco', 'Los Angeles', 'Tuesday', '09:28', '16:03', 63, 'High-Speed');
INSERT INTO routes VALUES('Z1j8b1', 'Houston', 'Phoenix', 'Friday', '00:57', '04:32', 86, 'High-Speed');
INSERT INTO routes VALUES('C0D7E8', 'Atlanta', 'Phoenix', 'Saturday', '17:12', '20:42', 32, 'High-Speed');
INSERT INTO routes VALUES('d3t0x2', 'Detroit', 'Los Angeles', 'Saturday', '09:18', '13:30', 49, 'High-Speed');
INSERT INTO routes VALUES('A5U5a9', 'Miami', 'Phoenix', 'Wednesday', '15:30', '19:53', 17, 'Inter-City');
INSERT INTO routes VALUES('t5H1X8', 'Dallas', 'Atlanta', 'Saturday', '04:01', '07:44', 92, 'Inter-City');
INSERT INTO routes VALUES('M3x3t1', 'Dallas', 'Boston', 'Saturday', '14:55', '17:04', 23, 'Regional');
INSERT INTO routes VALUES('g0w6G5', 'Phoenix', 'Boston', 'Friday', '21:17', '22:11', 50, 'High-Speed');
INSERT INTO routes VALUES('r6a6s5', 'Detroit', 'San Francisco', 'Tuesday', '12:27', '19:44', 66, 'Inter-City');
INSERT INTO routes VALUES('m2z0V9', 'San Francisco', 'Dallas', 'Sunday', '07:28', '09:29', 10, 'Regional');
INSERT INTO routes VALUES('N8w2A3', 'Los Angeles', 'Houston', 'Thursday', '03:30', '06:41', 95, 'Passenger');
INSERT INTO routes VALUES('m3v9a9', 'Dallas', 'San Francisco', 'Wednesday', '17:32', '21:18', 67, 'High-Speed');
INSERT INTO routes VALUES('a6R0L5', 'San Francisco', 'New York', 'Thursday', '21:48', '23:28', 10, 'High-Speed');
INSERT INTO routes VALUES('C6M3o5', 'Seattle', 'Boston', 'Monday', '11:07', '17:18', 57, 'Regional');
INSERT INTO routes VALUES('V9f0E0', 'Chicago', 'Boston', 'Wednesday', '02:55', '06:19', 74, 'Passenger');
INSERT INTO routes VALUES('z1F0t9', 'Chicago', 'Atlanta', 'Friday', '00:51', '03:58', 16, 'High-Speed');
INSERT INTO routes VALUES('I3Y3L8', 'Atlanta', 'Los Angeles', 'Wednesday', '04:09', '05:48', 32, 'High-Speed');
INSERT INTO routes VALUES('K5T6q9', 'Atlanta', 'Phoenix', 'Thursday', '08:44', '09:06', 81, 'Regional');
INSERT INTO routes VALUES('o9A7i0', 'Chicago', 'Boston', 'Thursday', '10:05', '17:27', 26, 'Inter-City');
INSERT INTO routes VALUES('s0v7U3', 'Houston', 'Boston', 'Monday', '02:36', '04:02', 30, 'Inter-City');
INSERT INTO routes VALUES('z5C9U2', 'Houston', 'Dallas', 'Wednesday', '07:27', '10:38', 73, 'Regional');
INSERT INTO routes VALUES('g1x4R2', 'Seattle', 'Washington', 'Tuesday', '01:23', '04:08', 18, 'Regional');
INSERT INTO routes VALUES('s9w1p7', 'San Francisco', 'Washington', 'Wednesday', '17:54', '23:55', 22, 'Regional');
INSERT INTO routes VALUES('I6Q2u7', 'Chicago', 'Detroit', 'Saturday', '13:16', '15:27', 17, 'Regional');
INSERT INTO routes VALUES('I5H4J2', 'Atlanta', 'Detroit', 'Wednesday', '07:22', '08:21', 81, 'Regional');
INSERT INTO routes VALUES('Y4e3A7', 'Seattle', 'Dallas', 'Sunday', '13:11', '16:38', 53, 'Inter-City');
INSERT INTO routes VALUES('H0G1H0', 'Seattle', 'Washington', 'Saturday', '13:26', '17:09', 67, 'High-Speed');
INSERT INTO routes VALUES('z2I7a1', 'Philadelphia', 'Washington', 'Wednesday', '03:23', '07:22', 15, 'Passenger');
INSERT INTO routes VALUES('D7k6U9', 'Los Angeles', 'Dallas', 'Friday', '12:05', '18:32', 32, 'Passenger');
INSERT INTO routes VALUES('U0M2D0', 'Dallas', 'Detroit', 'Monday', '02:39', '08:35', 98, 'Inter-City');
INSERT INTO routes VALUES('l7J6S9', 'Washington', 'Detroit', 'Saturday', '04:33', '07:58', 84, 'Regional');
INSERT INTO routes VALUES('Z2X0F3', 'New York', 'Seattle', 'Tuesday', '03:02', '07:25', 92, 'Inter-City');
INSERT INTO routes VALUES('J7Z1a9', 'Seattle', 'Phoenix', 'Saturday', '14:33', '20:59', 20, 'Passenger');
INSERT INTO routes VALUES('g4P9g6', 'Houston', 'San Francisco', 'Tuesday', '06:45', '11:21', 58, 'Passenger');
INSERT INTO routes VALUES('y5h7i5', 'Washington', 'Philadelphia', 'Wednesday', '00:18', '05:39', 25, 'Inter-City');
INSERT INTO routes VALUES('G9N0y7', 'San Francisco', 'Chicago', 'Monday', '03:49', '05:03', 39, 'High-Speed');
INSERT INTO routes VALUES('r7p3B5', 'Miami', 'Phoenix', 'Monday', '16:35', '21:07', 17, 'Regional');
INSERT INTO routes VALUES('U9G2a7', 'Houston', 'Detroit', 'Sunday', '20:36', '23:29', 16, 'Inter-City');
INSERT INTO routes VALUES('t5b0B0', 'Washington', 'Detroit', 'Sunday', '05:08', '07:58', 40, 'Inter-City');
INSERT INTO routes VALUES('R5x9T0', 'Los Angeles', 'Seattle', 'Sunday', '11:24', '17:14', 57, 'Inter-City');
INSERT INTO routes VALUES('O9z7S7', 'Houston', 'Dallas', 'Monday', '12:20', '19:29', 58, 'High-Speed');
INSERT INTO routes VALUES('E3v8G0', 'Phoenix', 'New York', 'Sunday', '01:55', '06:07', 100, 'Passenger');
INSERT INTO routes VALUES('T9C8O8', 'San Francisco', 'Seattle', 'Monday', '17:02', '22:05', 19, 'Passenger');
INSERT INTO routes VALUES('a2z0b6', 'Houston', 'Boston', 'Monday', '01:50', '02:47', 48, 'Inter-City');
INSERT INTO routes VALUES('B4q6z1', 'Phoenix', 'Seattle', 'Monday', '19:43', '23:45', 73, 'Regional');
INSERT INTO routes VALUES('g9q3P2', 'Boston', 'Dallas', 'Wednesday', '14:49', '18:27', 20, 'High-Speed');
INSERT INTO routes VALUES('Q9s5u5', 'Atlanta', 'Chicago', 'Thursday', '10:25', '17:47', 23, 'Passenger');
INSERT INTO routes VALUES('t3H8G5', 'Houston', 'Dallas', 'Wednesday', '18:28', '23:14', 62, 'Inter-City');
INSERT INTO routes VALUES('N6h5z2', 'Dallas', 'Seattle', 'Friday', '10:35', '16:37', 89, 'Regional');
INSERT INTO routes VALUES('f2U8b9', 'New York', 'Dallas', 'Monday', '04:36', '10:06', 33, 'High-Speed');
INSERT INTO routes VALUES('A6e0N4', 'Miami', 'Seattle', 'Thursday', '15:55', '19:16', 70, 'Regional');
INSERT INTO routes VALUES('J3l4u7', 'Phoenix', 'New York', 'Tuesday', '11:24', '17:12', 17, 'Regional');
INSERT INTO routes VALUES('Z4C4A9', 'Detroit', 'Philadelphia', 'Monday', '16:02', '23:47', 36, 'Regional');
INSERT INTO routes VALUES('e1v5e6', 'Detroit', 'Los Angeles', 'Friday', '09:14', '15:09', 47, 'High-Speed');
INSERT INTO routes VALUES('j0N7C7', 'San Francisco', 'Dallas', 'Monday', '09:48', '10:56', 76, 'Passenger');
INSERT INTO routes VALUES('S4n6P7', 'Chicago', 'Detroit', 'Tuesday', '16:46', '21:05', 43, 'Passenger');
INSERT INTO routes VALUES('N3h9f7', 'Atlanta', 'Phoenix', 'Sunday', '02:01', '09:50', 81, 'Passenger');
INSERT INTO routes VALUES('V3a2M9', 'Chicago', 'Washington', 'Wednesday', '12:40', '13:45', 54, 'Regional');
INSERT INTO routes VALUES('o5E2a2', 'Seattle', 'Miami', 'Friday', '15:21', '19:50', 11, 'Regional');
INSERT INTO routes VALUES('Z2c7e1', 'San Francisco', 'New York', 'Monday', '11:06', '16:51', 73, 'Passenger');
INSERT INTO routes VALUES('N3j8B0', 'Detroit', 'Atlanta', 'Saturday', '14:38', '22:40', 31, 'Passenger');
INSERT INTO routes VALUES('n1T8X2', 'Boston', 'Seattle', 'Friday', '16:42', '18:04', 47, 'Passenger');
INSERT INTO routes VALUES('T3N1C3', 'Phoenix', 'Philadelphia', 'Friday', '08:47', '09:32', 72, 'Passenger');
INSERT INTO routes VALUES('W0o4k4', 'San Francisco', 'Atlanta', 'Wednesday', '20:22', '21:34', 75, 'High-Speed');
INSERT INTO routes VALUES('v6p7f2', 'Miami', 'Seattle', 'Tuesday', '08:06', '10:07', 45, 'High-Speed');