| tripduration | starttime | stoptime | start station id | start station name | start station latitude | start station longitude | end station id | end station name | end station latitude | end station longitude | bikeid | usertype | birth year | gender |
| 704 | 7/1/2014 1:57:00 | 7/1/2014 2:09:00 | 478 | 11 Ave & W 41 St | 40.76030096 | -73.99884222 | 465 | Broadway & W 41 St | 40.75513557 | -73.98658032 | 19274 | Subscriber | 1943 | w |
| 577 | 7/1/2014 0:20:00 | 7/1/2014 0:30:00 | 528 | 2 Ave & E 31 St | 40.74290902 | -73.97706058 | 367 | E 53 St & Lexington Ave | 40.75828065 | -73.97069431 | 16479 | Subscriber | 1947 | w |
| 718 | 7/1/2014 0:22:00 | 7/1/2014 0:34:00 | 476 | E 31 St & 3 Ave | 40.74394314 | -73.97966069 | 325 | E 19 St & 3 Ave | 40.73624527 | -73.98473765 | 15063 | Subscriber | 1947 | w |
| 363 | 7/1/2014 0:33:00 | 7/1/2014 0:39:00 | 540 | Lexington Ave & E 26 St | 40.74147286 | -73.98320928 | 498 | Broadway & W 32 St | 40.74854862 | -73.98808416 | 17933 | Subscriber | 1952 | w |
| 250 | 7/1/2014 0:39:00 | 7/1/2014 0:43:00 | 479 | 9 Ave & W 45 St | 40.76019252 | -73.9912551 | 173 | Broadway & W 49 St | 40.76064679 | -73.98442659 | 14707 | Subscriber | 1953 | w |
| 1477 | 7/1/2014 0:23:00 | 7/1/2014 0:47:00 | 494 | W 26 St & 8 Ave | 40.74734825 | -73.99723551 | 401 | Allen St & Rivington St | 40.72019576 | -73.98997825 | 21132 | Customer | 1954 | w |
| 906 | 7/1/2014 0:23:00 | 7/1/2014 0:38:00 | 428 | E 3 St & 1 Ave | 40.72467721 | -73.98783413 | 332 | Cherry St | 40.71219906 | -73.97948148 | 15624 | Subscriber | 1954 | w |
| 986 | 7/1/2014 0:05:00 | 7/1/2014 0:21:00 | 487 | E 20 St & FDR Drive | 40.73314259 | -73.97573881 | 511 | E 14 St & Avenue B | 40.72938685 | -73.97772429 | 20727 | Subscriber | 1955 | w |
| 737 | 7/1/2014 0:22:00 | 7/1/2014 0:34:00 | 296 | Division St & Bowery | 40.71413089 | -73.9970468 | 394 | E 9 St & Avenue C | 40.72521311 | -73.97768752 | 16043 | Subscriber | 1955 | w |
| 365 | 7/1/2014 0:26:00 | 7/1/2014 0:32:00 | 306 | Cliff St & Fulton St | 40.70823502 | -74.00530063 | 534 | Water - Whitehall Plaza | 40.70255065 | -74.0127234 | 16421 | Subscriber | 1955 | w |
| 424 | 7/1/2014 0:50:00 | 7/1/2014 0:57:00 | 161 | LaGuardia Pl & W 3 St | 40.72917025 | -73.99810231 | 497 | E 17 St & Broadway | 40.73704984 | -73.99009296 | 14934 | Subscriber | 1955 | w |
| 595 | 7/1/2014 1:41:00 | 7/1/2014 1:51:00 | 433 | E 13 St & Avenue A | 40.72955361 | -73.98057249 | 511 | E 14 St & Avenue B | 40.72938685 | -73.97772429 | 17860 | Subscriber | 1955 | w |
| 290 | 7/1/2014 0:04:00 | 7/1/2014 0:08:00 | 329 | Greenwich St & N Moore St | 40.72043411 | -74.01020609 | 152 | Warren St & Church St | 40.71473993 | -74.00910627 | 15264 | Subscriber | 1956 | w |
| 444 | 7/1/2014 0:07:00 | 7/1/2014 0:14:00 | 489 | 10 Ave & W 28 St | 40.75066386 | -74.00176802 | 116 | W 17 St & 8 Ave | 40.74177603 | -74.00149746 | 16327 | Subscriber | 1956 | w |
| 2847 | 7/1/2014 0:37:00 | 7/1/2014 1:24:00 | 300 | Shevchenko Pl & E 7 St | 40.728145 | -73.990214 | 473 | Rivington St & Chrystie St | 40.72110063 | -73.9919254 | 17119 | Subscriber | 1956 | w |
| 496 | 7/1/2014 1:25:00 | 7/1/2014 1:33:00 | 473 | Rivington St & Chrystie St | 40.72110063 | -73.9919254 | 79 | Franklin St & W Broadway | 40.71911552 | -74.00666661 | 19857 | Subscriber | 1956 | w |
| 769 | 7/1/2014 0:13:00 | 7/1/2014 0:26:00 | 2021 | W 45 St & 8 Ave | 40.75929124 | -73.98859651 | 453 | W 22 St & 8 Ave | 40.74475148 | -73.99915362 | 17518 | Subscriber | 1957 | w |
| 970 | 7/1/2014 0:54:00 | 7/1/2014 1:10:00 | 527 | E 33 St & 1 Ave | 40.74315566 | -73.97434726 | 509 | 9 Ave & W 22 St | 40.7454973 | -74.00197139 | 19166 | Subscriber | 1957 | w |
| 1195 | 7/1/2014 1:02:00 | 7/1/2014 1:22:00 | 528 | 2 Ave & E 31 St | 40.74290902 | -73.97706058 | 349 | Rivington St & Ridge St | 40.71850211 | -73.98329859 | 16737 | Subscriber | 1957 | w |
| 1576 | 7/1/2014 2:06:00 | 7/1/2014 2:33:00 | 479 | 9 Ave & W 45 St | 40.76019252 | -73.9912551 | 515 | W 43 St & 10 Ave | 40.76009437 | -73.99461843 | 18101 | Subscriber | 1957 | w |
| 511 | 7/1/2014 3:04:00 | 7/1/2014 3:13:00 | 268 | Howard St & Centre St | 40.71910537 | -73.99973337 | 483 | E 12 St & 3 Ave | 40.73223272 | -73.98889957 | 17294 | Subscriber | 1958 | w |
| 364 | 7/1/2014 0:05:00 | 7/1/2014 0:11:00 | 307 | Canal St & Rutgers St | 40.71427487 | -73.98990025 | 332 | Cherry St | 40.71219906 | -73.97948148 | 15217 | Subscriber | 1959 | w |
| 928 | 7/1/2014 2:06:00 | 7/1/2014 2:21:00 | 434 | 9 Ave & W 18 St | 40.74317449 | -74.00366443 | 518 | E 39 St & 2 Ave | 40.74780373 | -73.9734419 | 21173 | Subscriber | 1959 | w |
| 771 | 7/1/2014 0:39:00 | 7/1/2014 0:52:00 | 334 | W 20 St & 7 Ave | 40.74238787 | -73.99726235 | 439 | E 4 St & 2 Ave | 40.7262807 | -73.98978041 | 19648 | Subscriber | 1960 | w |
| 684 | 7/1/2014 0:25:00 | 7/1/2014 0:36:00 | 499 | Broadway & W 60 St | 40.76915505 | -73.98191841 | 479 | 9 Ave & W 45 St | 40.76019252 | -73.9912551 | 15899 | Subscriber | 1961 | w |
| 237 | 7/1/2014 2:05:00 | 7/1/2014 2:09:00 | 330 | Reade St & Broadway | 40.71450451 | -74.00562789 | 276 | Duane St & Greenwich St | 40.71748752 | -74.0104554 | 14603 | Subscriber | 1961 | w |
| 639 | 7/1/2014 2:35:00 | 7/1/2014 2:45:00 | 284 | Greenwich Ave & 8 Ave | 40.73901691 | -74.00263761 | 151 | Cleveland Pl & Spring St | 40.7218158 | -73.99720307 | 15153 | Subscriber | 1961 | w |
| 315 | 7/1/2014 0:03:00 | 7/1/2014 0:08:00 | 128 | MacDougal St & Prince St | 40.72710258 | -74.00297088 | 328 | Watts St & Greenwich St | 40.72405549 | -74.00965965 | 15719 | Subscriber | 1962 | w |
| 618 | 7/1/2014 1:07:00 | 7/1/2014 1:17:00 | 238 | Bank St & Washington St | 40.7361967 | -74.00859207 | 152 | Warren St & Church St | 40.71473993 | -74.00910627 | 18830 | Subscriber | 1962 | w |
| 238 | 7/1/2014 1:20:00 | 7/1/2014 1:24:00 | 539 | Metropolitan Ave & Bedford Ave | 40.71534825 | -73.96024116 | 389 | Broadway & Berry St | 40.71044554 | -73.96525063 | 14577 | Subscriber | 1962 | w |
| 624 | 7/1/2014 1:48:00 | 7/1/2014 1:58:00 | 540 | Lexington Ave & E 26 St | 40.74147286 | -73.98320928 | 174 | E 25 St & 1 Ave | 40.7381765 | -73.97738662 | 15695 | Subscriber | 1963 | w |
| 268 | 7/1/2014 2:39:00 | 7/1/2014 2:44:00 | 336 | Sullivan St & Washington Sq | 40.73047747 | -73.99906065 | 382 | University Pl & E 14 St | 40.73492695 | -73.99200509 | 15003 | Subscriber | 1963 | w |
| 464 | 7/1/2014 0:05:00 | 7/1/2014 0:12:00 | 297 | E 15 St & 3 Ave | 40.734232 | -73.986923 | 540 | Lexington Ave & E 26 St | 40.74147286 | -73.98320928 | 17149 | Subscriber | 1964 | w |
| 437 | 7/1/2014 0:44:00 | 7/1/2014 0:51:00 | 173 | Broadway & W 49 St | 40.76064679 | -73.98442659 | 318 | E 43 St & Vanderbilt Ave | 40.75320159 | -73.9779874 | 14707 | Subscriber | 1964 | w |
| 1960 | 7/1/2014 1:04:00 | 7/1/2014 1:36:00 | 497 | E 17 St & Broadway | 40.73704984 | -73.99009296 | 477 | W 41 St & 8 Ave | 40.75640548 | -73.9900262 | 18208 | Subscriber | 1964 | w |
| 1603 | 7/1/2014 1:20:00 | 7/1/2014 1:46:00 | 470 | W 20 St & 8 Ave | 40.74345335 | -74.00004031 | 116 | W 17 St & 8 Ave | 40.74177603 | -74.00149746 | 20706 | Subscriber | 1964 | w |
| 77 | 7/1/2014 0:09:00 | 7/1/2014 0:10:00 | 514 | 12 Ave & W 40 St | 40.76087502 | -74.00277668 | 514 | 12 Ave & W 40 St | 40.76087502 | -74.00277668 | 15656 | Subscriber | 1965 | w |
| 301 | 7/1/2014 0:20:00 | 7/1/2014 0:25:00 | 268 | Howard St & Centre St | 40.71910537 | -73.99973337 | 412 | Forsyth St & Canal St | 40.7158155 | -73.99422366 | 17563 | Customer | 1947 | m |
| 261 | 7/1/2014 0:02:00 | 7/1/2014 0:07:00 | 450 | W 49 St & 8 Ave | 40.76227205 | -73.98788205 | 479 | 9 Ave & W 45 St | 40.76019252 | -73.9912551 | 19764 | Subscriber | 1951 | m |
| 532 | 7/1/2014 1:01:00 | 7/1/2014 1:10:00 | 82 | St James Pl & Pearl St | 40.71117416 | -74.00016545 | 263 | Elizabeth St & Hester St | 40.71729 | -73.996375 | 17435 | Subscriber | 1953 | m |
| 381 | 7/1/2014 0:08:00 | 7/1/2014 0:14:00 | 545 | E 23 St & 1 Ave | 40.736502 | -73.97809472 | 325 | E 19 St & 3 Ave | 40.73624527 | -73.98473765 | 18973 | Subscriber | 1954 | m |
| 797 | 7/1/2014 2:46:00 | 7/1/2014 2:59:00 | 238 | Bank St & Washington St | 40.7361967 | -74.00859207 | 79 | Franklin St & W Broadway | 40.71911552 | -74.00666661 | 21069 | Subscriber | 1955 | m |
| 647 | 7/1/2014 0:01:00 | 7/1/2014 0:12:00 | 500 | Broadway & W 51 St | 40.76228826 | -73.98336183 | 533 | Broadway & W 39 St | 40.75299641 | -73.98721619 | 15001 | Subscriber | 1959 | m |
| 104 | 7/1/2014 1:50:00 | 7/1/2014 1:51:00 | 430 | York St & Jay St | 40.7014851 | -73.98656928 | 2000 | Front St & Washington St | 40.70255088 | -73.98940236 | 20338 | Subscriber | 1960 | m |
| 299 | 7/1/2014 1:50:00 | 7/1/2014 1:55:00 | 369 | Washington Pl & 6 Ave | 40.73224119 | -74.00026394 | 116 | W 17 St & 8 Ave | 40.74177603 | -74.00149746 | 18775 | Subscriber | 1960 | m |
| 508 | 7/1/2014 0:35:00 | 7/1/2014 0:44:00 | 236 | St Marks Pl & 2 Ave | 40.7284186 | -73.98713956 | 402 | Broadway & E 22 St | 40.7403432 | -73.98955109 | 19330 | Subscriber | 1963 | m |
| 1413 | 7/1/2014 0:49:00 | 7/1/2014 1:13:00 | 450 | W 49 St & 8 Ave | 40.76227205 | -73.98788205 | 504 | 1 Ave & E 15 St | 40.73221853 | -73.98165557 | 20582 | Subscriber | 1963 | m |
| 677 | 7/1/2014 2:07:00 | 7/1/2014 2:18:00 | 479 | 9 Ave & W 45 St | 40.76019252 | -73.9912551 | 509 | 9 Ave & W 22 St | 40.7454973 | -74.00197139 | 15032 | Subscriber | 1963 | m |
| 653 | 7/1/2014 0:02:00 | 7/1/2014 0:12:00 | 504 | 1 Ave & E 15 St | 40.73221853 | -73.98165557 | 334 | W 20 St & 7 Ave | 40.74238787 | -73.99726235 | 15645 | Subscriber | 1964 | m |
| 1207 | 7/1/2014 0:12:00 | 7/1/2014 0:32:00 | 435 | W 21 St & 6 Ave | 40.74173969 | -73.99415556 | 328 | Watts St & Greenwich St | 40.72405549 | -74.00965965 | 20836 | Subscriber | 1964 | m |
| 744 | 7/1/2014 0:38:00 | 7/1/2014 0:50:00 | 311 | Norfolk St & Broome St | 40.7172274 | -73.98802084 | 382 | University Pl & E 14 St | 40.73492695 | -73.99200509 | 14962 | Subscriber | 1964 | m |
| 1021 | 7/1/2014 2:36:00 | 7/1/2014 2:53:00 | 382 | University Pl & E 14 St | 40.73492695 | -73.99200509 | 311 | Norfolk St & Broome St | 40.7172274 | -73.98802084 | 14665 | Subscriber | 1964 | m |
| 1467 | 7/1/2014 0:05:00 | 7/1/2014 0:29:00 | 514 | 12 Ave & W 40 St | 40.76087502 | -74.00277668 | 426 | West St & Chambers St | 40.71754834 | -74.01322069 | 18202 | Customer | 1965 | m |
Amazon2020
misspreadsheetmt.xlsx
