Gyle Centre or Broomhouse - The Jewel
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 20:48:00 | 20:48:00 | ... | 1 |
|
| ... | 20:49:00 | 20:49:00 | ... | 2 |
|
| ... | 20:50:00 | 20:50:00 | ... | 3 |
|
| ... | 20:50:00 | 20:50:00 | ... | 4 |
|
| ... | 20:52:00 | 20:52:00 | ... | 5 |
|
| ... | 20:52:00 | 20:52:00 | ... | 6 |
|
| ... | 20:53:00 | 20:53:00 | ... | 7 |
|
| ... | 20:54:00 | 20:54:00 | ... | 8 |
|
| ... | 20:54:00 | 20:54:00 | ... | 9 |
|
| ... | 20:55:00 | 20:55:00 | ... | 10 |
|
| ... | 20:55:00 | 20:55:00 | ... | 11 |
|
| ... | 20:56:00 | 20:56:00 | ... | 12 |
|
| ... | 20:57:00 | 20:57:00 | ... | 13 |
|
| ... | 20:57:00 | 20:57:00 | ... | 14 |
|
| ... | 20:58:00 | 20:58:00 | ... | 15 |
|
| ... | 20:59:00 | 20:59:00 | ... | 16 |
|
| ... | 21:00:00 | 21:00:00 | ... | 17 |
|
| ... | 21:01:00 | 21:01:00 | ... | 18 |
|
| ... | 21:01:00 | 21:01:00 | ... | 19 |
|
| ... | 21:02:00 | 21:02:00 | ... | 20 |
|
| ... | 21:03:00 | 21:03:00 | ... | 21 |
|
| ... | 21:04:00 | 21:04:00 | ... | 22 |
|
| ... | 21:05:00 | 21:05:00 | ... | 23 |
|
| ... | 21:06:00 | 21:06:00 | ... | 24 |
|
| ... | 21:07:00 | 21:07:00 | ... | 25 |
|
| ... | 21:09:00 | 21:09:00 | ... | 26 |
|
| ... | 21:10:00 | 21:10:00 | ... | 27 |
|
| ... | 21:11:00 | 21:11:00 | ... | 28 |
|
| ... | 21:13:00 | 21:13:00 | ... | 29 |
|
| ... | 21:14:00 | 21:14:00 | ... | 30 |
|
| ... | 21:15:00 | 21:15:00 | ... | 31 |
|
| ... | 21:16:00 | 21:16:00 | ... | 32 |
|
| ... | 21:17:00 | 21:17:00 | ... | 33 |
|
| ... | 21:18:00 | 21:18:00 | ... | 34 |
|
| ... | 21:19:00 | 21:19:00 | ... | 35 |
|
| ... | 21:20:00 | 21:20:00 | ... | 36 |
|
| ... | 21:22:00 | 21:22:00 | ... | 37 |
|
| ... | 21:23:00 | 21:23:00 | ... | 38 |
|
| ... | 21:24:00 | 21:24:00 | ... | 39 |
|
| ... | 21:25:00 | 21:25:00 | ... | 40 |
|
| ... | 21:25:00 | 21:25:00 | ... | 41 |
|
| ... | 21:26:00 | 21:26:00 | ... | 42 |
|
| ... | 21:27:00 | 21:27:00 | ... | 43 |
|
| ... | 21:28:00 | 21:28:00 | ... | 44 |
|
| ... | 21:29:00 | 21:29:00 | ... | 45 |
|
| ... | 21:29:00 | 21:29:00 | ... | 46 |
|
| ... | 21:31:00 | 21:31:00 | ... | 47 |
|
| ... | 21:32:00 | 21:32:00 | ... | 48 |
|
| ... | 21:32:00 | 21:32:00 | ... | 49 |
|
| ... | 21:32:00 | 21:32:00 | ... | 50 |
|
| ... | 21:33:00 | 21:33:00 | ... | 51 |
|
| ... | 21:33:00 | 21:33:00 | ... | 52 |
|
| ... | 21:34:00 | 21:34:00 | ... | 53 |
|
| ... | 21:35:00 | 21:35:00 | ... | 54 |
|
| ... | 21:36:00 | 21:36:00 | ... | 55 |
|
| ... | 21:36:00 | 21:36:00 | ... | 56 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 29/07/2018 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| 36236392 | Semple Street | 55.945247848 | -3.206871094 | |
| 36253239 | Asda The Jewel | 55.9387947081 | -3.1045626979 | |
| 36234369 | Milton Link | 55.9395362188 | -3.1060406758 | |
| 36234367 | Corbiewynd | 55.9392815605 | -3.1093793939 | |
| 36234364 | Parrotshot | 55.9387386307 | -3.1127898494 | |
| 36234385 | Niddrie Mill Crescent | 55.9361964442 | -3.1147019685 | |
| 36238375 | Niddrie Mill | 55.9348249307 | -3.1143424221 | |
| 36234396 | Jack Kane Sports Centre | 55.9338596779 | -3.1167478077 | |
| 36234397 | Hay Drive | 55.9340454833 | -3.1200346549 | |
| 36234398 | Hay Avenue | 55.9336827974 | -3.1233536813 | |
| 36234523 | Wauchope Road | 55.9326229564 | -3.1282210713 | |
| 36234528 | Greendykes Road | 55.9321071732 | -3.1305750471 | |
| 36234529 | Wauchope Avenue | 55.9324737434 | -3.1337070315 | |
| 36234532 | Craigmillar Castle Loan | 55.9326556211 | -3.1393147188 | |
| 36234534 | Craigmillar Castle Road | 55.9323507675 | -3.142154957 | |
| 36234535 | Craigmillar Castle Gardens | 55.9318135359 | -3.1458206322 | |
| 36234536 | Kings Haugh | 55.9321045899 | -3.1502630476 | |
| 36236294 | Prestonfield Park | 55.9327384007 | -3.1574208888 | |
| 36236292 | Clearburn Crescent | 55.933438314 | -3.1603870777 | |
| 36236287 | Prestonfield Road | 55.9335887689 | -3.1625365438 | |
| 36234832 | Prestonfield Avenue | 55.9335233889 | -3.1666004145 | |
| 36234834 | Priestfield Road | 55.9352340264 | -3.1690850391 | |
| 36234835 | Marchhall Place | 55.9363004239 | -3.1703337999 | |
| 36234836 | Royal Commonwealth Pool | 55.9380117457 | -3.1727387451 | |
| 36234783 | East Preston Street | 55.9392184914 | -3.1781064043 | |
| 36236562 | Bernard Terrace | 55.9405669692 | -3.1808530611 | |
| 36234857 | St Patrick Square | 55.9432750231 | -3.1833051509 | |
| 36238637 | Surgeons' Hall | 55.9457239101 | -3.1856055543 | |
| 36238547 | Bristo Square | 55.9459527863 | -3.1888950867 | |
| 36236456 | Forrest Road | 55.9462009318 | -3.1911124148 | |
| 36236439 | Grassmarket | 55.9474739724 | -3.1951227331 | |
| 36236452 | West Port | 55.9465513952 | -3.1985210159 | |
| 36236436 | Lauriston Street | 55.9458022086 | -3.2016362888 | |
| 36236467 | East Fountainbridge | 55.9451409874 | -3.204017619 | |
| 36236393 | Morrison Street | 55.9456577993 | -3.2081328071 | |
| 36236394 | Grove Street | 55.9460559649 | -3.2124205368 | |
| 36232658 | Haymarket Station | 55.9455337895 | -3.2170797984 | |
| 36232672 | Caledonian Village | 55.9425438902 | -3.2213890404 | |
| 36232673 | Dalry Primary School | 55.9414043761 | -3.2230342794 | |
| 36232674 | Murieston Crescent | 55.9396088527 | -3.2255872884 | |
| 36232675 | Gorgie City Farm | 55.9387712341 | -3.2284905712 | |
| 36232676 | Tynecastle | 55.9378275363 | -3.2321107744 | |
| 36232678 | Stewart Terrace | 55.9372443284 | -3.2347177143 | |
| 36236257 | Westfield Road | 55.9368252422 | -3.2397631359 | |
| 36236542 | Westfield Avenue | 55.9374134344 | -3.2429196863 | |
| 36238784 | Stevenson Grove | 55.9359431438 | -3.2452578432 | |
| 36235872 | Balgreen Primary School | 55.9368324424 | -3.249720803 | |
| 36235869 | Whitson Crescent | 55.9354574465 | -3.2532783669 | |
| 36235868 | Whitson Grove | 55.9338995937 | -3.2571339033 | |
| 36235867 | Stenhouse Cross | 55.9329082227 | -3.259182722 | |
| 36243453 | Stenhouse Grove | 55.9332292278 | -3.2620584417 | |
| 36235864 | Saughton Mains Street | 55.9335419459 | -3.2657343116 | |
| 36235863 | Saughton Road North | 55.9324933739 | -3.2715746871 | |
| 36236798 | Saughton House | 55.9312597093 | -3.2770405109 | |
| 36243975 | Broomhouse Gardens | 55.930978801 | -3.2807287483 | |
| 36236795 | Broomhouse Avenue | 55.9298273125 | -3.2843080973 |