announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by NRE_ID descending
This data as json, CSV (advanced)
Category 23
- Destination 1,171
- 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 ▲ |
---|---|---|---|---|---|---|
2288 | Stevenage | Destination | SVG | |||
1255 | Sunderland | Destination | SUN | |||
2335 | Sunderland | Destination | SUN | |||
2130 | Summerston | Destination | SUM | |||
2353 | Summerston | Destination | SUM | |||
2129 | Stevenston | Destination | STV | |||
2351 | Stevenston | Destination | STV | |||
1249 | Stewarton | Destination | STT | |||
2281 | Stewarton | Destination | STT | |||
1837 | Saltash | Destination | STS | |||
1899 | Saltash | Destination | STS | |||
1251 | Stranraer | Destination | STR | |||
2294 | Stranraer | Destination | STR | |||
0225 | St Pancras International | Destination | STP | |||
0366 | St. Pancras International | Destination | Low-pitch ending | STP | ||
1187 | London St. Pancras | Destination | STP | |||
1925 | London St Pancras | Destination | STP | |||
1254 | Stonehaven | Destination | STN | |||
2330 | Stonehaven | Destination | STN | |||
0444 | Stirling | Destination | STG | |||
1452 | Stirling | Destination | STG | |||
1599 | Stirling | Destination | STG | |||
0263 | Stromeferry | Destination | STF | |||
0410 | Stromeferry | Destination | STF | |||
2189 | Strathcarron | Destination | STC | |||
2415 | Strathcarron | Destination | STC | |||
0218 | Stafford | Destination | STA | |||
1295 | Stafford | Destination | STA | |||
2188 | Stratford | Destination | SRA | |||
2414 | Stratford | Destination | SRA | |||
1241 | Sanquhar | Destination | SQH | |||
2195 | Sanquhar | Destination | SQH | |||
1253 | Stockport | Destination | SPT | |||
2311 | Stockport | Destination | SPT | |||
2128 | Stepps | Destination | SPS | |||
2350 | Stepps | Destination | SPS | |||
2126 | Springburn | Destination | SPR | |||
2348 | Springburn | Destination | SPR | |||
0311 | Shepherd's Bush | Destination | SPH | |||
0443 | Shepherds Bush | Destination | SPH | |||
1245 | Springfield | Destination | SPF | |||
2214 | Springfield | Destination | SPF | |||
0212 | Southampton Central | Destination | SOU | |||
1293 | Southampton Central | Destination | SOU | |||
1252 | Stoke-on-Trent | Destination | SOT | |||
2306 | Stoke-on-Trent | Destination | SOT | |||
0707 | Stow... | Destination | SOI | |||
0735 | Stow | Destination | SOI | |||
0228 | Southampton Airport Parkway | Destination | SOA | |||
1302 | Southampton Airport Parkway | Destination | SOA | |||
2116 | Saltcoats | Destination | SLT | |||
2340 | Saltcoats | Destination | SLT | |||
2121 | Shettleston | Destination | SLS | |||
2344 | Shettleston | Destination | SLS | |||
1240 | Salford Crescent | Destination | SLD | |||
2183 | Salford Crescent | Destination | SLD | |||
1450 | Slateford | Destination | SLA | |||
1597 | Slateford | Destination | SLA | |||
1421 | Stocksfield | Destination | SKS | |||
1569 | Stocksfield | Destination | SKS | |||
2123 | Singer | Destination | SIN | |||
2346 | Singer | Destination | SIN | |||
1449 | Shotts | Destination | SHS | |||
1596 | Shotts | Destination | SHS | |||
2120 | Shawlands | Destination | SHL | |||
2343 | Shawlands | Destination | SHL | |||
1243 | Sheffield | Destination | SHF | |||
2211 | Sheffield | Destination | SHF | |||
1841 | St Germans | Destination | SGM | |||
1903 | St Germans | Destination | SGM | |||
1451 | South Gyle | Destination | SGL | |||
1598 | South Gyle | Destination | SGL | |||
0286 | Shawfair | Destination | SFI | |||
0426 | Shawfair | Destination | SFI | |||
0314 | Stratford International | Destination | SFA | |||
0446 | Stratford International | Destination | SFA | |||
1248 | St Erth | Destination | SER | |||
2267 | St Erth | Destination | SER | |||
2122 | Shieldmuir | Destination | SDM | |||
2345 | Shieldmuir | Destination | SDM | |||
2117 | Scotscalder | Destination | SCT | |||
2341 | Scotscalder | Destination | SCT | |||
0219 | Starcross | Destination | SCS | |||
1296 | Starcross | Destination | SCS | |||
1247 | St Columb Road | Destination | SCR | |||
2263 | St Columb Road | Destination | SCR | |||
2118 | Scotstounhill | Destination | SCH | |||
2342 | Scotstounhill | Destination | SCH | |||
1242 | Scarborough | Destination | SCA | |||
2198 | Scarborough | Destination | SCA | |||
2125 | Spean Bridge | Destination | SBR | |||
2347 | Spean Bridge | Destination | SBR | |||
1840 | St Budeaux Ferry Road | Destination | SBF | |||
1902 | St Budeaux Ferry Road | Destination | SBF | |||
1246 | St Austell | Destination | SAU | |||
2256 | St Austell | Destination | SAU | |||
1838 | Sandwell and Dudley | Destination | SAD | |||
1900 | Sandwell and Dudley | Destination | SAD | |||
2338 | Roy Bridge | Destination | RYV | |||
2113 | Roy Bridge | Destination | RYB |
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 );