announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Category descending
This data as json, CSV (advanced)
Category 21
- Destination 1,271
- Reason 421
- Time 161
- Passenger information 153
- Number 102
- Platform information 67
- Conjoining 66
- Safety 15
- Train formation 14
- Special train 12
- Operational 10
- Apology 8
- Fare information 7
- Platform ID 7
- Train operating company 7
- Heritage Railway 6
- Number combo 4
- Non-vocal 3
- Strathclyde metro 3
- Request stop 2
- Station 1
File | Transcription | Category ▲ | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
1852 | GNER service to | Train operating company | ||||
1854 | South West Trains service from | Train operating company | ||||
1855 | South West Trains service from | Train operating company | ||||
1856 | GNER service from | Train operating company | ||||
1974 | Midland Mainline Turbostar | Train operating company | ||||
1975 | Midland Mainline Turbostar service to | Train operating company | ||||
1976 | Midland Mainline Turbostar service from | Train operating company | ||||
0177 | This train is formed of 1 coach only | Train formation | ||||
0178 | This train is formed of 2 coaches | Train formation | ||||
0179 | This train is formed of 3 coaches | Train formation | ||||
0180 | This train is formed of 4 coaches | Train formation | ||||
0181 | This train is formed of 5 coaches | Train formation | ||||
0182 | This train is formed of 6 coaches | Train formation | ||||
0183 | This train is formed of 7 coaches | Train formation | ||||
0184 | This train is formed of 8 coaches | Train formation | ||||
0185 | This train is formed of 9 coaches | Train formation | ||||
0186 | This train is formed of 10 coaches | Train formation | ||||
0187 | This train is formed of 11 coaches | Train formation | ||||
0188 | This train is formed of 12 coaches | Train formation | ||||
1730 | This train is formed of | Train formation | ||||
1815 | This train is formed of one coach only | Train formation | ||||
0097 | Will be in | Time | ||||
0098 | Will be in 5 minutes | Time | ||||
0099 | Will be in 10 minutes | Time | ||||
0100 | Will be in 15 minutes | Time | ||||
0101 | Will be in 20 minutes | Time | ||||
0102 | Will be in 25 minutes | Time | ||||
0103 | Will be in 30 minutes | Time | ||||
0104 | Will be in 35 minutes | Time | ||||
0105 | Will be in 40 minutes | Time | ||||
0106 | Will be in 45 minutes | Time | ||||
0107 | Will be in 50 minutes | Time | ||||
0108 | Will be in 55 minutes | Time | ||||
0109 | Will be in 1 hour | Time | ||||
0110 | Is delayed by approximately 5 minutes | Time | ||||
0111 | Is delayed by approximately 10 minutes | Time | ||||
0112 | Is delayed by approximately 15 minutes | Time | ||||
0113 | Is delayed by approximately 20 minutes | Time | ||||
0114 | Is delayed by approximately 25 minutes | Time | ||||
0115 | Is delayed by approximately 30 minutes | Time | ||||
0116 | Is delayed by approximately 35 minutes | Time | ||||
0117 | Is delayed by approximately 40 minutes | Time | ||||
0118 | Is delayed by approximately 45 minutes | Time | ||||
0119 | Is delayed by approximately 50 minutes | Time | ||||
0120 | Is delayed by approximately 55 minutes | Time | ||||
0121 | Is delayed by approximately 1 hour | Time | ||||
0128 | This service will be in approximately 5 minutes | Time | ||||
0129 | This service will be in approximately 10 minutes | Time | ||||
0130 | This service will arrive in approximately 7 minutes | Time | ||||
0131 | This service will arrive in approximately 12 minutes | Time | ||||
0132 | This service will be in approximately | Time | ||||
0133 | 5 minutes | Time | ||||
0134 | 10 minutes | Time | ||||
0135 | 7 minutes | Time | ||||
0136 | 12 minutes | Time | ||||
0137 | Will arrive in approximately 1 minute | Time | ||||
0138 | Will arrive in approximately 2 minutes | Time | ||||
0139 | Will arrive in approximately 3 minutes | Time | ||||
0140 | Will arrive in approximately 4 minutes | Time | ||||
0141 | Will arrive in approximately 5 minutes | Time | ||||
0142 | Will arrive in approximately 10 minutes | Time | ||||
0143 | Will arrive in approximately 15 minutes | Time | ||||
0144 | Will arrive in approximately 20 minutes | Time | ||||
0145 | Will arrive in approximately 25 minutes | Time | ||||
0146 | Will arrive in approximately 30 minutes | Time | ||||
0147 | Will arrive in approximately 35 minutes | Time | ||||
0148 | Will arrive in approximately 40 minutes | Time | ||||
0149 | Will arrive in approximately 45 minutes | Time | ||||
0150 | Will arrive in approximately 50 minutes | Time | ||||
0151 | Will arrive in approximately 55 minutes | Time | ||||
0162 | Will be in approximately 1 minute | Time | ||||
0163 | Will be in approximately 2 minutes | Time | ||||
0164 | Will be in approximately 3 minutes | Time | ||||
0165 | Will be in approximately 4 minutes | Time | ||||
0166 | Will be in approximately 5 minutes | Time | ||||
0167 | Will be in approximately 10 minutes | Time | ||||
0168 | Will be in approximately 15 minutes | Time | ||||
0169 | Will be in approximately 20 minutes | Time | ||||
0170 | Will be in approximately 25 minutes | Time | ||||
0171 | Will be in approximately 30 minutes | Time | ||||
0172 | Will be in approximately 35 minutes | Time | ||||
0173 | Will be in approximately 40 minutes | Time | ||||
0174 | Will be in approximately 45 minutes | Time | ||||
0175 | Will be in approximately 50 minutes | Time | ||||
0176 | Will be in approximately 55 minutes | Time | ||||
0189 | hundred hours | Time | ||||
0230 | Midnight | Time | ||||
0231 | 01 | Time | oh-one | |||
0232 | 02 | Time | oh-two | |||
0233 | 03 | Time | oh-three | |||
0234 | 04 | Time | oh-four | |||
0235 | 05 | Time | oh-five | |||
0236 | 06 | Time | oh-six | |||
0237 | 07 | Time | oh-seven | |||
0238 | 08 | Time | oh-eight | |||
0239 | 09 | Time | oh-nine | |||
0240 | 10 | Time | ||||
0248 | 11 | Time | ||||
0259 | 12 | Time | ||||
0270 | 13 | Time |
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 );