scotrail: announcements: 153 rows where Category = "Passenger information" and Category != "Destination"

Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette

153 rows where Category = "Passenger information" and Category != "Destination"

Search:

descending

File ▼	Transcription	Category	Notes	Timestamp
0002	A trolley service	Passenger information		0:00:02
0028	This train will call additionally at	Passenger information
0053	Midland Main Line	Passenger information	Low-pitch ending
0062	will now depart from	Passenger information
0063	This train is formed of 11 coaches	Passenger information
0064	This train is formed of 12 coaches	Passenger information
0065	This train is formed of 1 coach only	Passenger information
0066	This train is formed of 1 coach	Passenger information
0084	of drinks and light refreshments	Passenger information
0094	The next service is to	Passenger information
0124	Should join the rear 9 coaches	Passenger information
0125	Should join the rear 10 coaches	Passenger information
0126	Should join the rear 11 coaches	Passenger information
0127	Should join the rear 12 coaches	Passenger information
0351	is available on this train	Passenger information
0494	Please join the front coach only	Passenger information
0495	Please join the front coach only of this train	Passenger information
0496	Please join the front two coaches of this train	Passenger information
0497	Please join the front three coaches of this train	Passenger information
0498	Please join the front four coaches of this train	Passenger information
0499	Please join the front five coaches of this train	Passenger information
0500	Please join the front six coaches of this train	Passenger information
0501	Please join the front seven coaches of this train	Passenger information
0502	Please join the front eight coaches of this train	Passenger information
0503	Please join the front nine coaches of this train	Passenger information
0504	Please join the front ten coaches of this train	Passenger information
0505	Please join the front eleven coaches of this train	Passenger information
0506	Please join the front twelve coaches of this train	Passenger information
0507	Please join the middle	Passenger information
0508	Please join the middle coach only	Passenger information
0509	Please join the middle coach only of this train	Passenger information
0511	Please join the middle two coaches of this train	Passenger information
0512	Please join the middle three coaches of this train	Passenger information
0513	Please join the middle four coaches of this train	Passenger information
0514	Please join the middle five coaches of this train	Passenger information
0515	Please join the middle six coaches of this train	Passenger information
0516	Please join the middle seven coaches of this train	Passenger information
0517	Please join the middle eight coaches of this train	Passenger information
0518	Please join the middle nine coaches of this train	Passenger information
0519	Please join the middle ten coaches of this train	Passenger information
0520	Please join the middle eleven coaches of this train	Passenger information
0521	Please join the middle twelve coaches of this train	Passenger information	How long does a train have to be in total to have twelve middle coaches? - 14 coaches!
0522	Please join the rear coach of this train	Passenger information
0523	Please join the rear coach only of this train	Passenger information
0524	Please join the rear two coaches of this train	Passenger information
0525	Please join the rear three coaches of this train	Passenger information
0526	Please join the rear four coaches of this train	Passenger information
0527	Please join the rear five coaches of this train	Passenger information
0528	Please join the rear six coaches of this train	Passenger information
0529	Please join the rear seven coaches of this train	Passenger information
0530	Please join the rear eight coaches of this train	Passenger information
0531	Please join the rear nine coaches of this train	Passenger information
0532	Please join the rear ten coaches of this train	Passenger information
0533	Please join the rear eleven coaches of this train	Passenger information
0534	Please join the rear twelve coaches of this train	Passenger information
0535	Megatrain accommodation can be found at the	Passenger information
0536	Front	Passenger information
0537	Middle	Passenger information
0538	Rear	Passenger information
0539	Of the train	Passenger information
0540	Megatrain accomodation can be found at the front of the train	Passenger information
0541	Megatrain accomodation can be found in the middle of the train	Passenger information
0542	Megatrain accomodation can be found at the rear of the train	Passenger information
0543	First class accommodation is available	Passenger information
0544	and can be found in the front of the train	Passenger information
0545	First class accommodation is available	Passenger information
0546	and can be found in the middle of the train	Passenger information
0547	First class accommodation is available	Passenger information
0548	and can be found in the rear of the train	Passenger information
0549	If you are travelling in First Class accommodation	Passenger information
0550	If you are travelling to this station	Passenger information
0551	If you are travelling to this station, please wait on the platform	Passenger information
0552	If you are travelling to these stations, please wait on the concourse	Passenger information
0553	If you are travelling to these stations, please wait on the platform	Passenger information
0554	If you are travelling to this station, please wait on the concourse	Passenger information
0555	If you are travelling to this station, please wait on the platform	Passenger information
0556	If you are travelling to these stations, please wait on the concourse	Passenger information
0557	If you are travelling to these stations, please wait on the platform	Passenger information
0558	You are advised that cycles are not allowed on this train	Passenger information
0559	You are advised that cycles are not permitted on this train	Passenger information
0560	Cycles are not allowed on this train	Passenger information
0561	Cycles are not permitted on this train	Passenger information
0562	First class accommodation is available	Passenger information
0563	and can be found in the front and the middle of the train	Passenger information
0564	First class accommodation is available	Passenger information
0565	and can be found in the front and rear of the train	Passenger information
0566	First class accommodation is available	Passenger information
0567	and can be found in the middle and rear of the train	Passenger information
0568	You must ensure that you have a valid first class ticket	Passenger information
0569	Please wait on the concourse and listen for further announcements	Passenger information
0570	Listen for further announcements	Passenger information
1162	This train is formed of	Passenger information
1177	Please use all available doors when getting on the train.	Passenger information
1210	There will be a special bus service in operation	Passenger information
1375	has been cancelled	Passenger information
1376	The next service to	Passenger information	upwards inflection
1389	The next bus service	Passenger information
1492	please listen for further announcements	Passenger information	Used at end of 'is delayed' message when no ETD available.
1493	please note that cycles may not be carried on this train	Passenger information
1494	please note that cycles cannot be carried on this train	Passenger information

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
);