Bikes Last Used

StrataScratch

Find the last time each bike was in use. Output both the bike number and the date-timestamp of the bike's last use (i.e., the date-time the bike was returned). Order the results by bikes that were most recently used.

table name:dc_bikeshare_q1_2012


Solution Explanation:
  • bike_number is unique for each bike. Use group by bike, end_time to create different groups for each bike.

select bike_number,end_time from dc_bikeshare_q1_2012 group by bike_number,end_time
  • Use max(end_time) function to get latest (last) use bike end time. And removed group by end_time, otherwise it will create multiple rows for each bike.

Final Solution:
select  bike_number,max(end_time) as last_use
from dc_bikeshare_q1_2012 
group by bike_number

SQL Script:
CREATE TABLE [dbo].[dc_bikeshare_q1_2012](
	[duration] [nvarchar](50) NULL,
	[duration_seconds] [int] NULL,
	[start_time] [datetime] NULL,
	[start_station] [varchar](50) NULL,
	[start_terminal] [int] NULL,
	[end_time] [datetime] NULL,
	[end_station] [varchar](50) NULL,
	[end_terminal] [int] NULL,
	[bike_number] [varchar](50) NULL,
	[rider_type] [varchar](50) NULL,
	[id] [int] NULL
) ON [PRIMARY]
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 47sec.', 647, CAST(N'2012-03-25T10:30:00.000' AS DateTime), N'17th & Corcoran St NW', 31214, CAST(N'2012-03-25T10:40:00.000' AS DateTime), N'Calvert St & Woodley Pl NW', 31106, N'W00576', N'Registered', 326188)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 11m 45sec.', 705, CAST(N'2012-03-28T18:59:00.000' AS DateTime), N'Rosslyn Metro / Wilson Blvd & Ft Myer Dr', 31015, CAST(N'2012-03-28T19:11:00.000' AS DateTime), N'21st & M St NW', 31212, N'W00011', N'Registered', 345585)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 45sec.', 465, CAST(N'2012-03-12T22:30:00.000' AS DateTime), N'3rd & H St NE', 31616, CAST(N'2012-03-12T22:37:00.000' AS DateTime), N'Florida Ave & R St NW', 31503, N'W01215', N'Registered', 251919)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 4m 27sec.', 267, CAST(N'2012-03-12T20:11:00.000' AS DateTime), N'14th & G St NW', 31238, CAST(N'2012-03-12T20:15:00.000' AS DateTime), N'14th & Rhode Island Ave NW', 31203, N'W00455', N'Registered', 251426)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 2sec.', 602, CAST(N'2012-02-03T09:06:00.000' AS DateTime), N'Lamont & Mt Pleasant NW', 31107, CAST(N'2012-02-03T09:16:00.000' AS DateTime), N'17th & Rhode Island Ave NW', 31239, N'W00300', N'Registered', 105965)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 13m 45sec.', 825, CAST(N'2012-03-10T16:44:00.000' AS DateTime), N'North Capitol St & F St NW', 31624, CAST(N'2012-03-10T16:58:00.000' AS DateTime), N'Thomas Circle', 31241, N'W00089', N'Registered', 240483)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 12m 58sec.', 778, CAST(N'2012-02-09T21:32:00.000' AS DateTime), N'14th & R St NW', 31202, CAST(N'2012-02-09T21:45:00.000' AS DateTime), N'18th & M St NW', 31221, N'W01158', N'Registered', 129535)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 2m 2sec.', 122, CAST(N'2012-03-29T17:36:00.000' AS DateTime), N'18th & Bell St', 31007, CAST(N'2012-03-29T17:38:00.000' AS DateTime), N'23rd & Crystal Dr', 31011, N'W00653', N'Registered', 350819)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 17m 44sec.', 1064, CAST(N'2012-02-18T08:43:00.000' AS DateTime), N'21st & I St NW', 31205, CAST(N'2012-02-18T09:01:00.000' AS DateTime), N'8th & H St NW', 31228, N'W01398', N'Registered', 156324)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 19m 43sec.', 1183, CAST(N'2012-03-31T19:08:00.000' AS DateTime), N'19th & E Street NW', 31206, CAST(N'2012-03-31T19:28:00.000' AS DateTime), N'10th St & Constitution Ave NW', 31219, N'W01278', N'Casual', 363912)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 16m 33sec.', 993, CAST(N'2012-02-22T08:20:00.000' AS DateTime), N'7th & R St NW / Shaw Library', 31245, CAST(N'2012-02-22T08:37:00.000' AS DateTime), N'New York Ave & 15th St NW', 31222, N'W00356', N'Registered', 170556)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 5m 34sec.', 334, CAST(N'2012-01-19T20:39:00.000' AS DateTime), N'Columbus Circle / Union Station', 31623, CAST(N'2012-01-19T20:45:00.000' AS DateTime), N'13th & H St NE', 31611, N'W00724', N'Registered', 56016)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 14m 17sec.', 857, CAST(N'2012-03-31T10:30:00.000' AS DateTime), N'13th & D St NE', 31622, CAST(N'2012-03-31T10:44:00.000' AS DateTime), N'4th & E St SW', 31244, N'W01006', N'Registered', 359385)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 16m 11sec.', 971, CAST(N'2012-03-14T17:24:00.000' AS DateTime), N'13th St & New York Ave NW', 31227, CAST(N'2012-03-14T17:40:00.000' AS DateTime), N'11th & H St NE', 31614, N'W00034', N'Registered', 261560)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 13m 42sec.', 822, CAST(N'2012-03-31T09:10:00.000' AS DateTime), N'36th & Calvert St NW / Glover Park', 31304, CAST(N'2012-03-31T09:24:00.000' AS DateTime), N'7th & T St NW', 31109, N'W01242', N'Registered', 359045)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 30m 29sec.', 1829, CAST(N'2012-03-23T17:42:00.000' AS DateTime), N'11th & Kenyon St NW', 31102, CAST(N'2012-03-23T18:13:00.000' AS DateTime), N'Van Ness Metro / UDC', 31300, N'W00688', N'Registered', 319246)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 9m 11sec.', 551, CAST(N'2012-03-29T15:10:00.000' AS DateTime), N'4th & M St SW', 31108, CAST(N'2012-03-29T15:20:00.000' AS DateTime), N'USDA / 12th & Independence Ave SW', 31217, N'W01330', N'Registered', 349768)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 11m 30sec.', 690, CAST(N'2012-01-05T08:23:00.000' AS DateTime), N'14th & Rhode Island Ave NW', 31203, CAST(N'2012-01-05T08:34:00.000' AS DateTime), N'North Capitol St & F St NW', 31624, N'W00380', N'Registered', 9340)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 13sec.', 373, CAST(N'2012-03-16T08:27:00.000' AS DateTime), N'1st & M St NE', 31603, CAST(N'2012-03-16T08:33:00.000' AS DateTime), N'5th St & K St NW', 31600, N'W00932', N'Registered', 271143)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 2m 50sec.', 170, CAST(N'2012-03-25T14:04:00.000' AS DateTime), N'15th & P St NW', 31201, CAST(N'2012-03-25T14:06:00.000' AS DateTime), N'17th & Corcoran St NW', 31214, N'W01241', N'Registered', 327405)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 9sec.', 609, CAST(N'2012-03-17T13:30:00.000' AS DateTime), N'Georgia & New Hampshire Ave NW', 31400, CAST(N'2012-03-17T13:40:00.000' AS DateTime), N'10th & U St NW', 31111, N'W00448', N'Registered', 277687)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 22m 26sec.', 1346, CAST(N'2012-03-14T21:02:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, CAST(N'2012-03-14T21:24:00.000' AS DateTime), N'Lincoln Park / 13th & East Capitol St NE ', 31619, N'W01296', N'Registered', 263627)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 9m 18sec.', 558, CAST(N'2012-02-01T07:55:00.000' AS DateTime), N'16th & Harvard St NW', 31103, CAST(N'2012-02-01T08:04:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, N'W00127', N'Registered', 97060)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 28m 39sec.', 1719, CAST(N'2012-02-10T12:40:00.000' AS DateTime), N'Columbus Circle / Union Station', 31623, CAST(N'2012-02-10T13:09:00.000' AS DateTime), N'USDA / 12th & Independence Ave SW', 31217, N'W00679', N'Casual', 131319)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 0m 49sec.', 49, CAST(N'2012-03-14T20:23:00.000' AS DateTime), N'Columbia Rd & Belmont St NW', 31113, CAST(N'2012-03-14T20:24:00.000' AS DateTime), N'Columbia Rd & Belmont St NW', 31113, N'W00345', N'Registered', 263433)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 14m 12sec.', 852, CAST(N'2012-03-15T18:52:00.000' AS DateTime), N'Adams Mill & Columbia Rd NW', 31104, CAST(N'2012-03-15T19:07:00.000' AS DateTime), N'Florida Ave & R St NW', 31503, N'W01331', N'Registered', 269059)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 36sec.', 936, CAST(N'2012-03-22T18:14:00.000' AS DateTime), N'Tenleytown / Wisconsin Ave & Albemarle St NW', 31303, CAST(N'2012-03-22T18:30:00.000' AS DateTime), N'Connecticut Ave & Newark St NW / Cleveland Park', 31305, N'W01194', N'Registered', 311508)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 11m 15sec.', 675, CAST(N'2012-02-26T16:27:00.000' AS DateTime), N'Georgia Ave and Fairmont St NW', 31207, CAST(N'2012-02-26T16:38:00.000' AS DateTime), N'16th & Harvard St NW', 31103, N'W00455', N'Registered', 188243)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 2m 13sec.', 133, CAST(N'2012-01-08T11:51:00.000' AS DateTime), N'Columbia Rd & Belmont St NW', 31113, CAST(N'2012-01-08T11:54:00.000' AS DateTime), N'20th St & Florida Ave NW', 31110, N'W00191', N'Registered', 21641)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 5sec.', 905, CAST(N'2012-03-13T07:25:00.000' AS DateTime), N'14th St & Spring Rd NW', 31401, CAST(N'2012-03-13T07:40:00.000' AS DateTime), N'McPherson Square - 14th & H St NW', 31216, N'W01271', N'Registered', 252309)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 13m 21sec.', 801, CAST(N'2012-02-13T18:46:00.000' AS DateTime), N'John McCormack Dr & Michigan Ave NE', 31502, CAST(N'2012-02-13T19:00:00.000' AS DateTime), N'Columbus Circle / Union Station', 31623, N'W00454', N'Registered', 139911)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 28m 22sec.', 1702, CAST(N'2012-03-20T19:53:00.000' AS DateTime), N'Jefferson Dr & 14th St SW', 31247, CAST(N'2012-03-20T20:22:00.000' AS DateTime), N'Clarendon Blvd & Pierce St', 31016, N'W01023', N'Registered', 299762)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 5m 33sec.', 333, CAST(N'2012-03-01T18:08:00.000' AS DateTime), N'13th St & New York Ave NW', 31227, CAST(N'2012-03-01T18:14:00.000' AS DateTime), N'17th & K St NW / Farragut Square', 31233, N'W00606', N'Registered', 203446)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 2sec.', 902, CAST(N'2012-03-18T18:18:00.000' AS DateTime), N'5th St & K St NW', 31600, CAST(N'2012-03-18T18:33:00.000' AS DateTime), N'USDA / 12th & Independence Ave SW', 31217, N'W00361', N'Registered', 287327)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 18m 44sec.', 1124, CAST(N'2012-01-01T01:04:00.000' AS DateTime), N'4th St & Massachusetts Ave NW', 31604, CAST(N'2012-01-01T01:23:00.000' AS DateTime), N'15th St & Massachusetts Ave SE', 31626, N'W01213', N'Registered', 50)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 13m 25sec.', 805, CAST(N'2012-01-07T20:50:00.000' AS DateTime), N'16th & Harvard St NW', 31103, CAST(N'2012-01-07T21:04:00.000' AS DateTime), N'14th & Rhode Island Ave NW', 31203, N'W00566', N'Registered', 20354)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 51sec.', 471, CAST(N'2012-03-13T07:07:00.000' AS DateTime), N'US Dept of State / Virginia Ave & 21st St NW', 31220, CAST(N'2012-03-13T07:15:00.000' AS DateTime), N'Metro Center / 12th & G St NW', 31230, N'W00801', N'Registered', 252235)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 37sec.', 637, CAST(N'2012-03-23T07:38:00.000' AS DateTime), N'Lamont & Mt Pleasant NW', 31107, CAST(N'2012-03-23T07:49:00.000' AS DateTime), N'15th & P St NW', 31201, N'W00573', N'Registered', 314355)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 8m 34sec.', 514, CAST(N'2012-03-14T07:18:00.000' AS DateTime), N'15th & P St NW', 31201, CAST(N'2012-03-14T07:27:00.000' AS DateTime), N'4th St & Massachusetts Ave NW', 31604, N'W01405', N'Registered', 258189)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 12m 21sec.', 741, CAST(N'2012-03-28T12:42:00.000' AS DateTime), N'14th & V St NW', 31101, CAST(N'2012-03-28T12:54:00.000' AS DateTime), N'18th & M St NW', 31221, N'W00501', N'Registered', 343351)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 22m 41sec.', 1361, CAST(N'2012-03-22T21:00:00.000' AS DateTime), N'19th & E Street NW', 31206, CAST(N'2012-03-22T21:23:00.000' AS DateTime), N'S Joyce & Army Navy Dr', 31006, N'W01336', N'Registered', 313107)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 43sec.', 943, CAST(N'2012-02-18T15:15:00.000' AS DateTime), N'10th & U St NW', 31111, CAST(N'2012-02-18T15:31:00.000' AS DateTime), N'1st & Rhode Island Ave NW', 31506, N'W00471', N'Casual', 158313)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 14m 50sec.', 890, CAST(N'2012-02-10T21:31:00.000' AS DateTime), N'8th & H St NW', 31228, CAST(N'2012-02-10T21:46:00.000' AS DateTime), N'14th & Rhode Island Ave NW', 31203, N'W00813', N'Registered', 133397)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 51sec.', 411, CAST(N'2012-03-12T06:39:00.000' AS DateTime), N'14th & Harvard St NW', 31105, CAST(N'2012-03-12T06:46:00.000' AS DateTime), N'Calvert St & Woodley Pl NW', 31106, N'W00506', N'Registered', 246850)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 12m 22sec.', 742, CAST(N'2012-03-14T23:01:00.000' AS DateTime), N'California St & Florida Ave NW', 31116, CAST(N'2012-03-14T23:13:00.000' AS DateTime), N'1st & Rhode Island Ave NW', 31506, N'W01310', N'Registered', 264111)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 21m 54sec.', 1314, CAST(N'2012-03-22T16:43:00.000' AS DateTime), N'Lamont & Mt Pleasant NW', 31107, CAST(N'2012-03-22T17:05:00.000' AS DateTime), N'Metro Center / 12th & G St NW', 31230, N'W00746', N'Registered', 310344)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 12m 23sec.', 743, CAST(N'2012-01-17T11:38:00.000' AS DateTime), N'17th & K St NW / Farragut Square', 31233, CAST(N'2012-01-17T11:51:00.000' AS DateTime), N'7th & F St NW / National Portrait Gallery', 31232, N'W01284', N'Registered', 47225)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 12m 30sec.', 750, CAST(N'2012-03-03T14:30:00.000' AS DateTime), N'21st & I St NW', 31205, CAST(N'2012-03-03T14:42:00.000' AS DateTime), N'7th & F St NW / National Portrait Gallery', 31232, N'W00495', N'Registered', 209611)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 47sec.', 647, CAST(N'2012-02-18T12:18:00.000' AS DateTime), N'Georgia Ave and Fairmont St NW', 31207, CAST(N'2012-02-18T12:29:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, N'W00021', N'Registered', 157101)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 0m 3sec.', 3, CAST(N'2012-03-06T09:42:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, CAST(N'2012-03-06T09:42:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, N'W01309', N'Registered', 220000)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 37sec.', 397, CAST(N'2012-01-15T20:42:00.000' AS DateTime), N'21st & M St NW', 31212, CAST(N'2012-01-15T20:48:00.000' AS DateTime), N'15th & P St NW', 31201, N'W00173', N'Registered', 44242)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 4sec.', 904, CAST(N'2012-02-14T19:05:00.000' AS DateTime), N'21st & I St NW', 31205, CAST(N'2012-02-14T19:20:00.000' AS DateTime), N'15th & P St NW', 31201, N'W00585', N'Registered', 144010)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 46sec.', 406, CAST(N'2012-03-31T08:58:00.000' AS DateTime), N'Columbia Rd & Belmont St NW', 31113, CAST(N'2012-03-31T09:05:00.000' AS DateTime), N'17th & Corcoran St NW', 31214, N'W01048', N'Registered', 359016)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 12m 4sec.', 724, CAST(N'2012-03-31T11:58:00.000' AS DateTime), N'14th & Harvard St NW', 31105, CAST(N'2012-03-31T12:10:00.000' AS DateTime), N'McPherson Square - 14th & H St NW', 31216, N'W00270', N'Registered', 360015)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 44sec.', 464, CAST(N'2012-02-13T15:17:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, CAST(N'2012-02-13T15:24:00.000' AS DateTime), N'Adams Mill & Columbia Rd NW', 31104, N'W01417', N'Registered', 138850)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 13m 44sec.', 824, CAST(N'2012-03-26T16:45:00.000' AS DateTime), N'Georgetown Harbor / 30th St NW', 31215, CAST(N'2012-03-26T16:58:00.000' AS DateTime), N'Adams Mill & Columbia Rd NW', 31104, N'w00644', N'Registered', 333681)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 9m 42sec.', 582, CAST(N'2012-03-24T10:56:00.000' AS DateTime), N'25th St & Pennsylvania Ave NW', 31237, CAST(N'2012-03-24T11:06:00.000' AS DateTime), N'17th & Corcoran St NW', 31214, N'W01374', N'Registered', 323428)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 24m 20sec.', 1460, CAST(N'2012-01-13T08:48:00.000' AS DateTime), N'Van Ness Metro / UDC', 31300, CAST(N'2012-01-13T09:12:00.000' AS DateTime), N'10th St & Constitution Ave NW', 31219, N'W00983', N'Registered', 37103)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 11m 55sec.', 715, CAST(N'2012-03-02T08:45:00.000' AS DateTime), N'Massachusetts Ave & Dupont Circle NW', 31200, CAST(N'2012-03-02T08:57:00.000' AS DateTime), N'US Dept of State / Virginia Ave & 21st St NW', 31220, N'W00412', N'Registered', 205750)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 2m 48sec.', 168, CAST(N'2012-01-28T16:11:00.000' AS DateTime), N'16th & Harvard St NW', 31103, CAST(N'2012-01-28T16:14:00.000' AS DateTime), N'Lamont & Mt Pleasant NW', 31107, N'W00075', N'Registered', 83867)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 4m 10sec.', 250, CAST(N'2012-01-22T20:20:00.000' AS DateTime), N'14th & Harvard St NW', 31105, CAST(N'2012-01-22T20:24:00.000' AS DateTime), N'Adams Mill & Columbia Rd NW', 31104, N'W00754', N'Registered', 62588)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 41sec.', 401, CAST(N'2012-02-22T22:49:00.000' AS DateTime), N'Thomas Circle', 31241, CAST(N'2012-02-22T22:56:00.000' AS DateTime), N'20th & O St NW / Dupont South', 31234, N'W01153', N'Registered', 174607)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 16m 10sec.', 970, CAST(N'2012-03-12T18:17:00.000' AS DateTime), N'L''Enfant Plaza / 7th & C St SW', 31218, CAST(N'2012-03-12T18:34:00.000' AS DateTime), N'Eastern Market / 7th & North Carolina Ave SE', 31610, N'W00092', N'Registered', 250421)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 21m 21sec.', 1281, CAST(N'2012-01-24T10:46:00.000' AS DateTime), N'13th & H St NE', 31611, CAST(N'2012-01-24T11:08:00.000' AS DateTime), N'4th St & Massachusetts Ave NW', 31604, N'W00418', N'Registered', 66437)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 8sec.', 368, CAST(N'2012-01-18T22:17:00.000' AS DateTime), N'5th St & K St NW', 31600, CAST(N'2012-01-18T22:23:00.000' AS DateTime), N'1st & M St NE', 31603, N'W01074', N'Registered', 52953)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 3sec.', 603, CAST(N'2012-03-21T17:53:00.000' AS DateTime), N'Lynn & 19th St North', 31014, CAST(N'2012-03-21T18:03:00.000' AS DateTime), N'37th & O St NW / Georgetown University', 31236, N'W00926', N'Registered', 304557)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 1m 27sec.', 87, CAST(N'2012-02-03T19:34:00.000' AS DateTime), N'11th & Kenyon St NW', 31102, CAST(N'2012-02-03T19:36:00.000' AS DateTime), N'11th & Kenyon St NW', 31102, N'W00208', N'Registered', 108656)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 20m 13sec.', 1213, CAST(N'2012-02-20T16:53:00.000' AS DateTime), N'L''Enfant Plaza / 7th & C St SW', 31218, CAST(N'2012-02-20T17:13:00.000' AS DateTime), N'Thomas Circle', 31241, N'W01409', N'Casual', 165131)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 11m 53sec.', 713, CAST(N'2012-03-15T13:09:00.000' AS DateTime), N'16th & U St NW', 31229, CAST(N'2012-03-15T13:21:00.000' AS DateTime), N'New York Ave & 15th St NW', 31222, N'W00763', N'Registered', 266473)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 58sec.', 478, CAST(N'2012-03-05T07:18:00.000' AS DateTime), N'11th & Kenyon St NW', 31102, CAST(N'2012-03-05T07:26:00.000' AS DateTime), N'16th & U St NW', 31229, N'W00595', N'Registered', 215738)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 18m 32sec.', 1112, CAST(N'2012-01-13T17:46:00.000' AS DateTime), N'14th & D St NW / Ronald Reagan Building', 31231, CAST(N'2012-01-13T18:05:00.000' AS DateTime), N'20th St & Florida Ave NW', 31110, N'W00133', N'Registered', 38687)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 55sec.', 475, CAST(N'2012-01-10T14:09:00.000' AS DateTime), N'Columbus Circle / Union Station', 31623, CAST(N'2012-01-10T14:17:00.000' AS DateTime), N'14th & D St SE', 31607, N'W00888', N'Registered', 28073)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 52sec.', 412, CAST(N'2012-02-03T19:10:00.000' AS DateTime), N'North Capitol St & F St NW', 31624, CAST(N'2012-02-03T19:17:00.000' AS DateTime), N'7th & F St NW / National Portrait Gallery', 31232, N'W01124', N'Registered', 108531)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 14m 27sec.', 867, CAST(N'2012-02-09T17:48:00.000' AS DateTime), N'4th & D St NW / Judiciary Square', 31621, CAST(N'2012-02-09T18:02:00.000' AS DateTime), N'1st & Rhode Island Ave NW', 31506, N'W00519', N'Registered', 128435)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 20m 31sec.', 1231, CAST(N'2012-01-24T23:22:00.000' AS DateTime), N'5th St & K St NW', 31600, CAST(N'2012-01-24T23:42:00.000' AS DateTime), N'Park Rd & Holmead Pl NW', 31602, N'W00395', N'Casual', 69497)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 18sec.', 378, CAST(N'2012-03-01T18:03:00.000' AS DateTime), N'7th & R St NW / Shaw Library', 31245, CAST(N'2012-03-01T18:09:00.000' AS DateTime), N'17th & Rhode Island Ave NW', 31239, N'W01153', N'Registered', 203397)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 8m 32sec.', 512, CAST(N'2012-01-14T16:19:00.000' AS DateTime), N'Calvert St & Woodley Pl NW', 31106, CAST(N'2012-01-14T16:27:00.000' AS DateTime), N'Connecticut Ave & Newark St NW / Cleveland Park', 31305, N'W00594', N'Registered', 41288)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 23m 59sec.', 1439, CAST(N'2012-02-08T07:10:00.000' AS DateTime), N'5th & F St NW', 31620, CAST(N'2012-02-08T07:34:00.000' AS DateTime), N'18th & Bell St', 31007, N'W01307', N'Registered', 123346)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 30sec.', 450, CAST(N'2012-02-20T08:46:00.000' AS DateTime), N'7th & R St NW / Shaw Library', 31245, CAST(N'2012-02-20T08:54:00.000' AS DateTime), N'8th & H St NW', 31228, N'W01400', N'Registered', 163238)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 7m 51sec.', 471, CAST(N'2012-03-11T10:14:00.000' AS DateTime), N'3000 Connecticut Ave NW / National Zoo', 31307, CAST(N'2012-03-11T10:21:00.000' AS DateTime), N'20th St & Florida Ave NW', 31110, N'W00677', N'Registered', 242282)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 16sec.', 916, CAST(N'2012-03-21T08:32:00.000' AS DateTime), N'7th & R St NW / Shaw Library', 31245, CAST(N'2012-03-21T08:47:00.000' AS DateTime), N'C & O Canal & Wisconsin Ave NW', 31225, N'W01155', N'Registered', 301666)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 3sec.', 603, CAST(N'2012-02-17T19:09:00.000' AS DateTime), N'18th & M St NW', 31221, CAST(N'2012-02-17T19:19:00.000' AS DateTime), N'10th & U St NW', 31111, N'W00449', N'Registered', 155290)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 8m 12sec.', 492, CAST(N'2012-03-23T12:16:00.000' AS DateTime), N'Georgia Ave and Fairmont St NW', 31207, CAST(N'2012-03-23T12:24:00.000' AS DateTime), N'14th & V St NW', 31101, N'W00611', N'Registered', 316286)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'1h 5m 30sec.', 3930, CAST(N'2012-03-23T14:21:00.000' AS DateTime), N'USDA / 12th & Independence Ave SW', 31217, CAST(N'2012-03-23T15:27:00.000' AS DateTime), N'Ohio Dr & West Basin Dr SW / MLK & FDR Memorials', 31240, N'W01226', N'Casual', 317218)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 11m 58sec.', 718, CAST(N'2012-02-23T00:14:00.000' AS DateTime), N'Georgia & New Hampshire Ave NW', 31400, CAST(N'2012-02-23T00:26:00.000' AS DateTime), N'Florida Ave & R St NW', 31503, N'W01344', N'Casual', 174706)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 6m 16sec.', 376, CAST(N'2012-03-25T16:57:00.000' AS DateTime), N'Convention Center / 7th & M St NW', 31223, CAST(N'2012-03-25T17:03:00.000' AS DateTime), N'15th & P St NW', 31201, N'W01408', N'Registered', 328678)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 18m 42sec.', 1122, CAST(N'2012-03-21T17:32:00.000' AS DateTime), N'13th St & New York Ave NW', 31227, CAST(N'2012-03-21T17:51:00.000' AS DateTime), N'Adams Mill & Columbia Rd NW', 31104, N'W00426', N'Registered', 304283)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 3m 59sec.', 239, CAST(N'2012-02-14T14:11:00.000' AS DateTime), N'14th & D St SE', 31607, CAST(N'2012-02-14T14:15:00.000' AS DateTime), N'Lincoln Park / 13th & East Capitol St NE ', 31619, N'W00793', N'Registered', 142532)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 52sec.', 652, CAST(N'2012-03-12T08:51:00.000' AS DateTime), N'10th & U St NW', 31111, CAST(N'2012-03-12T09:02:00.000' AS DateTime), N'8th & H St NW', 31228, N'W01231', N'Registered', 247646)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'1h 7m 39sec.', 4059, CAST(N'2012-03-21T18:37:00.000' AS DateTime), N'Ohio Dr & West Basin Dr SW / MLK & FDR Memorials', 31240, CAST(N'2012-03-21T19:44:00.000' AS DateTime), N'20th & O St NW / Dupont South', 31234, N'W00497', N'Casual', 305152)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 10m 11sec.', 611, CAST(N'2012-03-06T12:44:00.000' AS DateTime), N'14th & V St NW', 31101, CAST(N'2012-03-06T12:55:00.000' AS DateTime), N'17th & K St NW [formerly 17th & L St NW]', 31213, N'W00661', N'Registered', 220413)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 39m 14sec.', 2354, CAST(N'2012-03-23T19:01:00.000' AS DateTime), N'19th St & Constitution Ave NW', 31235, CAST(N'2012-03-23T19:40:00.000' AS DateTime), N'Ohio Dr & West Basin Dr SW / MLK & FDR Memorials', 31240, N'W00560', N'Casual', 320360)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 4m 19sec.', 259, CAST(N'2012-03-28T09:23:00.000' AS DateTime), N'M St & Pennsylvania Ave NW', 31246, CAST(N'2012-03-28T09:27:00.000' AS DateTime), N'21st & M St NW', 31212, N'W00590', N'Registered', 342608)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 20m 32sec.', 1232, CAST(N'2012-03-29T20:40:00.000' AS DateTime), N'Jefferson Dr & 14th St SW', 31247, CAST(N'2012-03-29T21:01:00.000' AS DateTime), N'13th & D St NE', 31622, N'W01468', N'Registered', 352486)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 15m 48sec.', 948, CAST(N'2012-01-18T12:03:00.000' AS DateTime), N'Florida Ave & R St NW', 31503, CAST(N'2012-01-18T12:18:00.000' AS DateTime), N'20th St & Florida Ave NW', 31110, N'W00892', N'Registered', 50983)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 36m 50sec.', 2210, CAST(N'2012-03-27T18:57:00.000' AS DateTime), N'New York Ave & 15th St NW', 31222, CAST(N'2012-03-27T19:34:00.000' AS DateTime), N'New York Ave & 15th St NW', 31222, N'W00522', N'Casual', 340092)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 39m 29sec.', 2369, CAST(N'2012-03-16T10:22:00.000' AS DateTime), N'Georgetown Harbor / 30th St NW', 31215, CAST(N'2012-03-16T11:02:00.000' AS DateTime), N'10th St & Constitution Ave NW', 31219, N'W00332', N'Casual', 271836)
GO
INSERT [dbo].[dc_bikeshare_q1_2012] ([duration], [duration_seconds], [start_time], [start_station], [start_terminal], [end_time], [end_station], [end_terminal], [bike_number], [rider_type], [id]) VALUES (N'0h 24m 50sec.', 1490, CAST(N'2012-03-31T15:13:00.000' AS DateTime), N'Calvert St & Woodley Pl NW', 31106, CAST(N'2012-03-31T15:37:00.000' AS DateTime), N'7th & F St NW / National Portrait Gallery', 31232, N'W01097', N'Registered', 361942)
GO

Comments (0)
Questions List