announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Transcription
This data as json, CSV (advanced)
Category 23
- Destination 1,271
- Reason 421
- Time 161
- Passenger information 153
- Number 102
- Train operating company 76
- Platform information 67
- Conjoining 66
- Weather 30
- Safety 15
- Train formation 14
- Special train 12
- Operational 10
- Apology 8
- Fare information 7
- Platform ID 7
- Heritage Railway 6
- Number combo 4
- Non-vocal 3
- Strathclyde metro 3
- Request stop 2
- Station 1
- Train operating company 1
File | Transcription ▼ | Category | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
1513 | Please listen for announcements onboard the train | Passenger information | ||||
0706 | ...Edinburgh Gateway... | Destination | EGY | |||
0648 | ...First Capital Connect. | Train operating company | end | |||
0647 | ...First Capital Connect.... | Train operating company | mid | |||
0656 | ...Grand Central | Train operating company | end | |||
0653 | ...Grand Central... | Train operating company | mid | |||
0739 | ...a bicycle on the track earlier on this train's journey. | Reason | ||||
0740 | ...a bicycle on the track earlier today. | Reason | ||||
0738 | ...a bicycle on the track... | Reason | ||||
0742 | ...a boat colliding with a bridge earlier today | Reason | ||||
0741 | ...a boat colliding with a bridge. | Reason | ||||
0744 | ...a bridge being damaged by a boat. | Reason | ||||
0745 | ...a bridge being damaged by a road vehicle. | Reason | ||||
0743 | ...a bridge being damaged. | Reason | ||||
0746 | ...a bridge having collapsed. | Reason | ||||
0748 | ...a broken down train, earlier today. | Reason | ||||
0747 | ...a broken down train. | Reason | ||||
0749 | ...a broken rail. | Reason | ||||
0750 | ...a broken windscreen on the train. | Reason | ||||
0752 | ...a burst water main flooding the railway, earlier today. | Reason | ||||
0751 | ...a burst water main flooding the railway. | Reason | ||||
0754 | ...a burst water main near the railway, earlier today. | Reason | ||||
0755 | ...a burst water main near the railway, yesterday. | Reason | ||||
0753 | ...a burst water main near the railway. | Reason | ||||
0757 | ...a bus colliding with a bridge, earlier on this train's journey. | Reason | ||||
0759 | ...a bus colliding with a bridge, earlier today. | Reason | ||||
0756 | ...a bus colliding with a bridge. | Reason | ||||
0761 | ...a chemical spillage near the railway earlier today | Reason | ||||
0762 | ...a chemical spillage near the railway yesterday | Reason | ||||
0760 | ...a chemical spillage near the railway. | Reason | ||||
0764 | ...a coach becoming uncoupled on a train earlier in its journey | Reason | ||||
0765 | ...a coach becoming uncoupled on a train earlier today | Reason | ||||
0763 | ...a coach becoming uncoupled on a train. | Reason | ||||
0767 | ...a coach becoming uncoupled on this train earlier in its journey. | Reason | ||||
0768 | ...a coach becoming uncoupled on this train earlier today. | Reason | ||||
0766 | ...a coach becoming uncoupled on this train. | Reason | ||||
0771 | ...a collision at a level crossing earlier today. | Reason | ||||
0772 | ...a collision at a level crossing yesterday. | Reason | ||||
0770 | ...a collision at a level crossing. | Reason | ||||
0773 | ...a collision between trains. | Reason | ||||
0774 | ...a collision with the buffers at a station. | Reason | ||||
0775 | ...a derailed train. | Reason | ||||
0776 | ...a derailment within the depot. | Reason | ||||
0777 | ...a fault occurring when attaching a part of a train. | Reason | ||||
0778 | ...a fault occurring when attaching a part of this train. | Reason | ||||
0779 | ...a fault occurring when detaching a part of a train. | Reason | ||||
0780 | ...a fault occurring when detaching a part of this train. | Reason | ||||
0781 | ...a fault on a train in front of this one. | Reason | ||||
0783 | ...a fault on this train which is now fixed. | Reason | ||||
0782 | ...a fault on this train. | Reason | ||||
0785 | ...a fault with a swing bridge over a river earlier today. | Reason | ||||
0784 | ...a fault with a swing bridge over a river. | Reason | ||||
0787 | ...a fault with barriers at a level crossing earlier today. | Reason | ||||
0788 | ...a fault with barriers at a level crossing yesterday. | Reason | ||||
0786 | ...a fault with barriers at a level crossing. | Reason | ||||
0790 | ...a fault with the electric third rail earlier on this train's journey. | Reason | ||||
0791 | ...a fault with the electric third rail earlier today. | Reason | ||||
0789 | ...a fault with the electric third rail. | Reason | Why do they need this... | |||
0793 | ...a fault with the on-train signalling system earlier on this train's journey. | Reason | ||||
0794 | ...a fault with the on-train signalling system earlier today. | Reason | ||||
0792 | ...a fault with the on-train signalling system. | Reason | ||||
0796 | ...a fault with the radio system between the driver and the signaller earlier on this train's journey. | Reason | when has this ever been used | |||
0797 | ...a fault with the radio system between the driver and the signaller earlier today. | Reason | ||||
0795 | ...a fault with the radio system between the driver and the signaller. | Reason | ||||
0799 | ...a fault with the signalling system earlier on this train's journey. | Reason | ||||
0800 | ...a fault with the signalling system earlier today. | Reason | ||||
0798 | ...a fault with the signalling system. | Reason | ||||
0654 | ...adverse weather conditions... | Weather | mid | |||
0618 | ...an incident on the line... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
0736 | ...at... | Conjoining | ||||
0641 | ...cancellation of the incoming service... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
1523 | ...customers are advised to evacuate this station by the nearest exit | Passenger information | ||||
1231 | ...is delayed. | Conjoining | Used when no ETA for departure is available (e.g., stationary for extended period) | |||
1549 | ...is the delayed... | Conjoining | ||||
1552 | ...is the delayed... | Conjoining | ||||
0669 | ...signalling difficulties. | Reason | end | |||
0668 | ...signalling difficulties... | Reason | mid | |||
0629 | ...suspected damage to a railway bridge... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
1521 | ...train is ready to board | Passenger information | ||||
0608 | ...trespass on the line... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
1525 | ...waiting for trains at this station. | Passenger information | ||||
0723 | ...will not call at... | Conjoining | mid | |||
0231 | 01 | Time | oh-one | |||
0300 | 01 | Time | oh-one | |||
1304 | 01 | Time | oh-one | |||
0232 | 02 | Time | oh-two | |||
0301 | 02 | Time | oh-two | |||
1305 | 02 | Time | oh-two | |||
0233 | 03 | Time | oh-three | |||
0302 | 03 | Time | oh-three | |||
1306 | 03 | Time | oh-three | |||
0234 | 04 | Time | oh-four | |||
0308 | 04 | Time | oh-four | |||
1307 | 04 | Time | oh-four | |||
0235 | 05 | Time | oh-five | |||
0317 | 05 | Time | oh-five | |||
1308 | 05 | Time | oh-five | |||
0236 | 06 | Time | oh-six | |||
0319 | 06 | Time | oh-six | |||
1309 | 06 | Time | oh-six |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "announcements" ( [File] TEXT PRIMARY KEY, [Transcription] TEXT, [Category] TEXT, [mp3] TEXT, [Notes] TEXT, [Timestamp] TEXT, [NRE_ID] TEXT );