Machynlleth - Aberystwyth Schools
| trip_id | arrival_time | departure_time | stop_id | stop_sequence | |
|---|---|---|---|---|---|
| ... | 07:42:00 | 07:42:00 | ... | 1 |
|
| ... | 07:43:00 | 07:43:00 | ... | 2 |
|
| ... | 07:46:00 | 07:46:00 | ... | 3 |
|
| ... | 07:49:00 | 07:49:00 | ... | 4 |
|
| ... | 07:50:00 | 07:50:00 | ... | 5 |
|
| ... | 07:51:00 | 07:51:00 | ... | 6 |
|
| ... | 07:52:00 | 07:52:00 | ... | 7 |
|
| ... | 07:52:00 | 07:52:00 | ... | 8 |
|
| ... | 07:53:00 | 07:53:00 | ... | 9 |
|
| ... | 07:55:00 | 07:55:00 | ... | 10 |
|
| ... | 07:56:00 | 07:56:00 | ... | 11 |
|
| ... | 08:00:00 | 08:00:00 | ... | 12 |
|
| ... | 08:05:00 | 08:05:00 | ... | 13 |
|
| ... | 08:07:00 | 08:07:00 | ... | 14 |
|
| ... | 08:07:00 | 08:07:00 | ... | 15 |
|
| ... | 08:12:00 | 08:12:00 | ... | 16 |
|
| ... | 08:12:00 | 08:12:00 | ... | 17 |
|
| ... | 08:13:00 | 08:13:00 | ... | 18 |
|
| ... | 08:13:00 | 08:13:00 | ... | 19 |
|
| ... | 08:23:00 | 08:23:00 | ... | 20 |
|
| ... | 08:25:00 | 08:25:00 | ... | 21 |
|
| ... | 08:26:00 | 08:26:00 | ... | 22 |
|
| ... | 08:27:00 | 08:27:00 | ... | 23 |
|
| ... | 08:28:00 | 08:28:00 | ... | 24 |
|
| ... | 08:29:00 | 08:29:00 | ... | 25 |
|
| start_date | end_date | monday | tuesday | wednesday | thursday | friday | saturday | sunday | |
|---|---|---|---|---|---|---|---|---|---|
| 24/08/2013 @ 00:00 | 01/01/0001 @ 00:00 |
|
| stop_code | stop_name | stop_lat | stop_lon | |
|---|---|---|---|---|
| cejatjp | Garreg Farm | 52.5562314693 | -3.9233104151 | |
| cejapwm | Castle Gates | 52.5508326873 | -3.9329419874 | |
| cejapwt | London House | 52.5430823669 | -3.9373352725 | |
| cejatdw | Furnace Bridge | 52.5383185977 | -3.9405317486 | |
| cejamtd | Plas Einion | 52.5364232209 | -3.9426156825 | |
| cejdtmj | Seaview Terrace | 52.5028787163 | -3.9793853137 | |
| cejdtdp | Square | 52.4838901756 | -3.9825384007 | |
| cejapta | Dole Lane | 52.4577221558 | -4.0141119897 | |
| cejdmjt | Rhydypennau Inn | 52.453934532 | -4.0189872801 | |
| cejdmjd | Maes y Garn | 52.4498583175 | -4.0212731414 | |
| cejdmjm | Cross Street | 52.4464494357 | -4.025016568 | |
| cejagwd | Post Office | 52.442222803 | -4.0276771579 | |
| cejamwp | Park Lodge | 52.5227582873 | -3.9686193343 | |
| cejdwaw | Wildfowler Hotel | 52.51145898 | -3.9765436178 | |
| cejdtmw | Manchester House | 52.5052127427 | -3.9785324468 | |
| cejdtgj | Maes-y-Deri | 52.4897620648 | -3.981432703 | |
| cejdtgm | Tal-y-bont Primary School | 52.4882057628 | -3.9814805622 | |
| cejdtdw | Post Office | 52.4860715942 | -3.9822094017 | |
| cejagwa | Caerfelin | 52.4434505708 | -4.0268654148 | |
| cejgamd | Main Road | 52.5120438394 | -3.9770561947 | |
| cejgdja | Llancynfelyn | 52.5104460393 | -3.9961714603 | |
| powgdtg | Clock | 52.5901585128 | -3.8531951988 | |
| powdagj | Black Lion | 52.5744171087 | -3.8889090088 | |
| powgdwj | Bus Depot | 52.5939416106 | -3.8550527758 | |
| powjmjp | Llyffant Valley Bridge | 52.5632859321 | -3.9124354808 |