Skip to content

Instantly share code, notes, and snippets.

@naveen
Created September 18, 2014 19:31
Show Gist options
  • Save naveen/fd40b22e666ecb07a2c9 to your computer and use it in GitHub Desktop.
Save naveen/fd40b22e666ecb07a2c9 to your computer and use it in GitHub Desktop.
naveen citibike trips 20140815
start_station,start_station_lat,start_station_lon,start_time,end_station,end_station_lat,end_station_lon,end_time,actual_duration,estimated_duration,estimated_distance
Great Jones St,40.72743423,-73.99379025,6/30/14 10:30:27 AM,Cleveland Pl & Spring St,40.7218158,-73.99720307,6/30/14 10:34:23 AM,236.0,417,1562
Cleveland Pl & Spring St,40.7218158,-73.99720307,6/30/14 8:55:28 AM,Great Jones St,40.72743423,-73.99379025,6/30/14 8:58:33 AM,185.0,199,704
Great Jones St,40.72743423,-73.99379025,6/26/14 11:36:57 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,6/26/14 11:41:38 PM,281.0,417,1562
Great Jones St,40.72743423,-73.99379025,6/26/14 6:10:45 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,6/26/14 6:16:44 PM,359.0,417,1562
Cleveland Pl & Spring St,40.7218158,-73.99720307,6/26/14 5:01:41 PM,Great Jones St,40.72743423,-73.99379025,6/26/14 5:06:05 PM,264.0,199,704
Broadway & E 14 St,40.73454567,-73.99074142,6/24/14 3:14:29 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,6/24/14 3:24:47 PM,618.0,432,1681
Broadway & E 14 St,40.73454567,-73.99074142,6/23/14 6:28:18 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,6/23/14 6:34:46 PM,388.0,432,1681
Cleveland Pl & Spring St,40.7218158,-73.99720307,6/14/14 11:27:16 AM,W 22 St & 10 Ave,40.74691959,-74.00451887,6/14/14 11:47:24 AM,1208.0,951,3915
Cleveland Pl & Spring St,40.7218158,-73.99720307,6/11/14 9:00:16 AM,Great Jones St,40.72743423,-73.99379025,6/11/14 9:03:17 AM,181.0,199,704
Cleveland Pl & Spring St,40.7218158,-73.99720307,5/29/14 9:05:58 AM,Great Jones St,40.72743423,-73.99379025,5/29/14 9:10:20 AM,262.0,199,704
Cleveland Pl & Spring St,40.7218158,-73.99720307,5/22/14 10:27:38 AM,Great Jones St,40.72743423,-73.99379025,5/22/14 10:31:19 AM,221.0,199,704
Lafayette St & Jersey St,40.72456089,-73.99565293,5/21/14 6:13:18 PM,Great Jones St,40.72743423,-73.99379025,5/21/14 6:16:51 PM,213.0,105,367
Great Jones St,40.72743423,-73.99379025,5/21/14 4:00:22 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,5/21/14 4:05:08 PM,286.0,417,1562
Cleveland Pl & Spring St,40.7218158,-73.99720307,5/21/14 2:54:03 PM,Great Jones St,40.72743423,-73.99379025,5/21/14 2:57:56 PM,233.0,199,704
Shevchenko Pl & E 7 St,40.728145,-73.990214,5/20/14 1:48:49 PM,Mercer St & Spring St,40.72362738,-73.99949601,5/20/14 2:04:54 PM,965.0,419,1655
Cleveland Pl & Spring St,40.7218158,-73.99720307,5/20/14 12:27:33 PM,Shevchenko Pl & E 7 St,40.728145,-73.990214,5/20/14 12:34:12 PM,399.0,303,1130
Great Jones St,40.72743423,-73.99379025,4/29/14 1:45:45 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,4/29/14 1:52:44 PM,419.0,417,1562
Cleveland Pl & Spring St,40.7218158,-73.99720307,4/29/14 12:28:35 PM,Great Jones St,40.72743423,-73.99379025,4/29/14 12:31:35 PM,180.0,199,704
Cleveland Pl & Spring St,40.7218158,-73.99720307,4/21/14 4:04:05 PM,Great Jones St,40.72743423,-73.99379025,4/21/14 4:07:11 PM,186.0,199,704
Cleveland Pl & Spring St,40.7218158,-73.99720307,4/21/14 9:30:38 AM,Great Jones St,40.72743423,-73.99379025,4/21/14 9:34:00 AM,202.0,199,704
Cleveland Pl & Spring St,40.7218158,-73.99720307,4/19/14 3:04:08 PM,Great Jones St,40.72743423,-73.99379025,4/19/14 3:09:04 PM,296.0,199,704
Great Jones St,40.72743423,-73.99379025,3/27/14 8:48:32 AM,Cleveland Pl & Spring St,40.7218158,-73.99720307,3/27/14 8:55:13 AM,401.0,417,1562
Cleveland Pl & Spring St,40.7218158,-73.99720307,3/23/14 12:28:47 PM,Lafayette St & E 8 St,40.73028666,-73.9907647,3/23/14 12:33:50 PM,303.0,268,1099
Cleveland Pl & Spring St,40.7218158,-73.99720307,3/21/14 9:12:14 AM,Lawrence St & Willoughby St,40.69236178,-73.98631746,3/21/14 9:14:17 AM,123.0,1024,4410
Broadway & E 14 St,40.73454567,-73.99074142,3/13/14 9:10:22 AM,Cleveland Pl & Spring St,40.7218158,-73.99720307,3/13/14 9:16:18 AM,356.0,432,1681
Cleveland Pl & Spring St,40.7218158,-73.99720307,3/11/14 6:35:10 PM,Lawrence St & Willoughby St,40.69236178,-73.98631746,3/11/14 6:37:08 PM,118.0,1024,4410
Cleveland Pl & Spring St,40.7218158,-73.99720307,3/11/14 2:14:29 PM,Lafayette St & Jersey St,40.72456089,-73.99565293,3/11/14 2:17:21 PM,172.0,93,337
Lawrence St & Willoughby St,40.69236178,-73.98631746,3/10/14 7:21:08 PM,Allen St & E Houston St,40.722055,-73.989111,3/10/14 7:26:07 PM,299.0,1000,4216
Cleveland Pl & Spring St,40.7218158,-73.99720307,2/27/14 6:57:34 PM,Shevchenko Pl & E 7 St,40.728145,-73.990214,2/27/14 7:04:45 PM,431.0,303,1130
Allen St & Hester St,40.71605866,-73.99190759,2/27/14 1:47:46 PM,E 24 St & Park Ave S,40.74096374,-73.98602213,2/27/14 1:55:30 PM,464.0,888,3719
Lawrence St & Willoughby St,40.69236178,-73.98631746,2/27/14 12:30:08 PM,Allen St & Hester St,40.71605866,-73.99190759,2/27/14 12:39:07 PM,539.0,755,3429
Lawrence St & Willoughby St,40.69236178,-73.98631746,2/25/14 11:52:58 AM,MacDougal St & Washington Sq,40.73226398,-73.99852205,2/25/14 12:10:57 PM,1079.0,1428,5947
Cleveland Pl & Spring St,40.7218158,-73.99720307,2/22/14 1:51:58 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,2/22/14 1:52:01 PM,3.0,0,0
Lispenard St & Broadway,40.71939226,-74.00247214,1/30/14 11:06:26 AM,E 2 St & Avenue B,40.72217444,-73.98368779,1/30/14 11:12:56 AM,390.0,817,2454
Cleveland Pl & Spring St,40.7218158,-73.99720307,1/30/14 9:35:23 AM,Lispenard St & Broadway,40.71939226,-74.00247214,1/30/14 9:39:30 AM,247.0,292,728
Cleveland Pl & Spring St,40.7218158,-73.99720307,12/18/13 2:10:27 PM,Lawrence St & Willoughby St,40.69236178,-73.98631746,12/18/13 2:11:59 PM,92.0,1024,4410
Lafayette St & Jersey St,40.72456089,-73.99565293,12/9/13 8:00:01 PM,Franklin St & W Broadway,40.71911552,-74.00666661,12/9/13 8:08:39 PM,518.0,403,1539
Great Jones St,40.72743423,-73.99379025,12/7/13 11:59:46 PM,Stanton St & Chrystie St,40.72229346,-73.99147535,12/8/13 12:11:41 AM,715.0,340,943
Great Jones St,40.72743423,-73.99379025,12/7/13 11:59:11 PM,Great Jones St,40.72743423,-73.99379025,12/7/13 11:59:31 PM,20.0,0,0
Rivington St & Chrystie St,40.72110063,-73.9919254,12/7/13 7:56:30 PM,E 2 St & Avenue B,40.72217444,-73.98368779,12/7/13 8:03:54 PM,444.0,291,1006
Lawrence St & Willoughby St,40.69236178,-73.98631746,12/3/13 8:08:25 PM,MacDougal St & Prince St,40.72710258,-74.00297088,12/3/13 8:13:21 PM,296.0,1277,5100
Lawrence St & Willoughby St,40.69236178,-73.98631746,12/2/13 4:49:01 PM,9 Ave & W 14 St,40.7405826,-74.00550867,12/2/13 5:03:07 PM,846.0,1512,6919
LaGuardia Pl & W 3 St,40.72917025,-73.99810231,12/1/13 3:47:13 PM,Rivington St & Chrystie St,40.72110063,-73.9919254,12/1/13 3:57:42 PM,629.0,435,1486
Rivington St & Chrystie St,40.72110063,-73.9919254,12/1/13 2:23:30 PM,LaGuardia Pl & W 3 St,40.72917025,-73.99810231,12/1/13 2:30:54 PM,444.0,417,1428
E 24 St & Park Ave S,40.74096374,-73.98602213,11/25/13 3:44:36 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,11/25/13 3:50:25 PM,349.0,811,3386
Elizabeth St & Hester St,40.71729,-73.996375,11/24/13 11:59:09 AM,Mott St & Prince St,40.72317958,-73.99480012,11/24/13 12:03:40 PM,271.0,207,721
Lawrence St & Willoughby St,40.69236178,-73.98631746,11/23/13 6:46:11 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,11/23/13 6:52:17 PM,366.0,999,4214
Cleveland Pl & Spring St,40.7218158,-73.99720307,11/23/13 6:37:27 PM,Lafayette St & Jersey St,40.72456089,-73.99565293,11/23/13 6:38:56 PM,89.0,93,337
E 24 St & Park Ave S,40.74096374,-73.98602213,11/22/13 7:50:28 PM,Harrison St & Hudson St,40.71870987,-74.0090009,11/22/13 8:04:53 PM,865.0,1027,4214
Elizabeth St & Hester St,40.71729,-73.996375,11/21/13 3:42:58 PM,Lawrence St & Willoughby St,40.69236178,-73.98631746,11/21/13 3:48:04 PM,306.0,904,4001
Cleveland Pl & Spring St,40.7218158,-73.99720307,11/21/13 1:21:55 PM,Elizabeth St & Hester St,40.71729,-73.996375,11/21/13 1:28:56 PM,421.0,317,750
Elizabeth St & Hester St,40.71729,-73.996375,11/21/13 10:28:00 AM,Cleveland Pl & Spring St,40.7218158,-73.99720307,11/21/13 10:32:22 AM,262.0,173,645
Mott St & Prince St,40.72317958,-73.99480012,11/20/13 10:28:17 PM,Elizabeth St & Hester St,40.71729,-73.996375,11/20/13 10:32:54 PM,277.0,310,727
Elizabeth St & Hester St,40.71729,-73.996375,11/19/13 10:35:54 AM,E 24 St & Park Ave S,40.74096374,-73.98602213,11/19/13 10:42:20 AM,386.0,740,3024
Cleveland Pl & Spring St,40.7218158,-73.99720307,11/18/13 2:48:46 PM,Lawrence St & Willoughby St,40.69236178,-73.98631746,11/18/13 2:50:42 PM,116.0,1024,4410
Lawrence St & Willoughby St,40.69236178,-73.98631746,11/18/13 2:27:15 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,11/18/13 2:32:06 PM,291.0,999,4214
Leonard St & Church St,40.717571,-74.005549,11/17/13 7:25:24 PM,Leonard St & Church St,40.717571,-74.005549,11/17/13 7:25:27 PM,3.0,0,0
Elizabeth St & Hester St,40.71729,-73.996375,11/17/13 6:07:04 PM,Leonard St & Church St,40.717571,-74.005549,11/17/13 6:17:33 PM,629.0,395,1532
Sullivan St & Washington Sq,40.73047747,-73.99906065,11/14/13 2:44:39 PM,Lafayette St & Jersey St,40.72456089,-73.99565293,11/14/13 2:52:08 PM,449.0,373,1650
Lawrence St & Willoughby St,40.69236178,-73.98631746,11/14/13 12:57:47 PM,Sullivan St & Washington Sq,40.73047747,-73.99906065,11/14/13 1:03:15 PM,328.0,1335,5520
Elizabeth St & Hester St,40.71729,-73.996375,11/14/13 10:32:01 AM,Lawrence St & Willoughby St,40.69236178,-73.98631746,11/14/13 10:37:30 AM,329.0,904,4001
Allen St & E Houston St,40.722055,-73.989111,11/13/13 3:37:49 PM,Allen St & E Houston St,40.722055,-73.989111,11/13/13 3:37:52 PM,3.0,0,0
W 20 St & 11 Ave,40.746745,-74.007756,11/10/13 5:53:34 PM,Elizabeth St & Hester St,40.71729,-73.996375,11/10/13 6:02:02 PM,508.0,1293,4662
Elizabeth St & Hester St,40.71729,-73.996375,11/9/13 4:14:33 PM,St Marks Pl & 2 Ave,40.7284186,-73.98713956,11/9/13 4:24:32 PM,599.0,528,2071
Cleveland Pl & Spring St,40.7218158,-73.99720307,11/8/13 1:03:02 PM,Great Jones St,40.72743423,-73.99379025,11/8/13 1:06:20 PM,198.0,199,704
W 31 St & 7 Ave,40.749156,-73.9916,11/5/13 1:02:31 PM,Great Jones St,40.72743423,-73.99379025,11/5/13 1:05:43 PM,192.0,932,3800
E 11 St & Broadway,40.73261787,-73.99158043,10/21/13 8:58:20 PM,Allen St & Rivington St,40.72019576,-73.98997825,10/21/13 9:15:06 PM,1006.0,600,2380
Lawrence St & Willoughby St,40.69236178,-73.98631746,10/21/13 6:56:15 PM,E 11 St & Broadway,40.73261787,-73.99158043,10/21/13 7:03:15 PM,420.0,1443,5988
Grand St & Greene St,40.72165481,-74.00234737,10/15/13 11:25:05 AM,Mott St & Prince St,40.72317958,-73.99480012,10/15/13 11:31:39 AM,394.0,315,1117
Elizabeth St & Hester St,40.71729,-73.996375,10/15/13 8:37:09 AM,2 Ave & E 31 St,40.74290902,-73.97706058,10/15/13 8:41:52 AM,283.0,981,4159
Shevchenko Pl & E 7 St,40.728145,-73.990214,10/14/13 6:36:20 PM,Lafayette St & Jersey St,40.72456089,-73.99565293,10/14/13 6:43:52 PM,452.0,366,1436
Lawrence St & Willoughby St,40.69236178,-73.98631746,10/14/13 5:23:28 PM,Shevchenko Pl & E 7 St,40.728145,-73.990214,10/14/13 5:28:37 PM,309.0,1210,5213
LaGuardia Pl & W 3 St,40.72917025,-73.99810231,10/6/13 9:34:12 PM,Elizabeth St & Hester St,40.71729,-73.996375,10/6/13 9:46:47 PM,755.0,615,1861
Elizabeth St & Hester St,40.71729,-73.996375,10/6/13 6:15:05 PM,E 53 St & Lexington Ave,40.75828065,-73.97069431,10/6/13 6:22:08 PM,423.0,1495,5994
Lawrence St & Willoughby St,40.69236178,-73.98631746,9/30/13 7:55:57 PM,Rivington St & Chrystie St,40.72110063,-73.9919254,9/30/13 8:03:55 PM,478.0,858,3844
MacDougal St & Washington Sq,40.73226398,-73.99852205,9/30/13 7:08:57 PM,Lawrence St & Willoughby St,40.69236178,-73.98631746,9/30/13 7:20:50 PM,713.0,1321,6072
Lawrence St & Willoughby St,40.69236178,-73.98631746,9/30/13 5:45:41 PM,MacDougal St & Washington Sq,40.73226398,-73.99852205,9/30/13 5:53:41 PM,480.0,1428,5947
LaGuardia Pl & W 3 St,40.72917025,-73.99810231,9/15/13 4:22:14 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,9/15/13 4:32:28 PM,614.0,328,1136
Mott St & Prince St,40.72317958,-73.99480012,9/15/13 2:17:59 PM,Sullivan St & Washington Sq,40.73047747,-73.99906065,9/15/13 2:29:35 PM,696.0,284,1285
E 2 St & 2 Ave,40.72502876,-73.99069656,9/9/13 9:45:34 PM,Elizabeth St & Hester St,40.71729,-73.996375,9/9/13 9:55:44 PM,610.0,438,1401
Elizabeth St & Hester St,40.71729,-73.996375,9/3/13 5:53:24 PM,St Marks Pl & 1 Ave,40.72779126,-73.98564945,9/3/13 6:06:05 PM,761.0,549,2214
Lawrence St & Willoughby St,40.69236178,-73.98631746,8/16/13 8:03:44 PM,Cadman Plaza West & Montague St,40.69383,-73.990539,8/16/13 8:11:05 PM,441.0,256,839
Cleveland Pl & Spring St,40.7218158,-73.99720307,8/16/13 2:39:02 PM,8 Ave & W 31 St,40.75044999,-73.99481051,8/16/13 2:40:43 PM,101.0,942,4085
Elizabeth St & Hester St,40.71729,-73.996375,8/16/13 7:56:39 AM,Mercer St & Bleecker St,40.72679454,-73.99695094,8/16/13 8:05:24 AM,525.0,434,1852
Elizabeth St & Hester St,40.71729,-73.996375,8/15/13 7:22:42 PM,W 13 St & 7 Ave,40.73781509,-73.99994661,8/15/13 7:40:56 PM,1094.0,741,3075
Cleveland Pl & Spring St,40.7218158,-73.99720307,8/15/13 12:30:11 PM,Great Jones St,40.72743423,-73.99379025,8/15/13 12:34:28 PM,257.0,199,704
E 10 St & 5 Ave,40.73331967,-73.99510132,8/7/13 11:14:29 AM,Cleveland Pl & Spring St,40.7218158,-73.99720307,8/7/13 11:22:46 AM,497.0,587,2080
Cleveland Pl & Spring St,40.7218158,-73.99720307,8/7/13 10:05:02 AM,E 10 St & 5 Ave,40.73331967,-73.99510132,8/7/13 10:13:45 AM,523.0,500,1921
Cleveland Pl & Spring St,40.7218158,-73.99720307,8/6/13 11:54:57 AM,W Broadway & Spring St,40.72490985,-74.00154702,8/6/13 11:58:53 AM,236.0,193,763
Vesey Pl & River Terrace,40.7153379,-74.01658354,8/5/13 2:22:09 PM,Elizabeth St & Hester St,40.71729,-73.996375,8/5/13 2:35:39 PM,810.0,684,2483
Cleveland Pl & Spring St,40.7218158,-73.99720307,8/5/13 11:31:51 AM,Vesey Pl & River Terrace,40.7153379,-74.01658354,8/5/13 11:45:16 AM,805.0,822,3658
11 Ave & W 27 St,40.751396,-74.005226,7/16/13 8:46:16 PM,Cleveland Pl & Spring St,40.7218158,-73.99720307,7/16/13 9:24:24 PM,2288.0,1055,4195
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment