home / scotrail

Menu
  • GraphQL API

announcements

Table actions
  • GraphQL API for announcements

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

15 rows where Category = "Safety"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Transcription, Notes

Category 1

  • Safety · 15 ✖
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0190 Stand well away from the edge of platform 1 Safety Audio not supported      
0191 Stand well away from the edge of platform 2 Safety Audio not supported      
0192 Stand well away from the edge of platform 3 Safety Audio not supported      
0193 Stand well away from the edge of platform 4 Safety Audio not supported      
0194 Stand well away from the edge of platform 5 Safety Audio not supported      
0195 Stand well away from the edge of platform 6 Safety Audio not supported      
0196 Stand well away from the edge of platform 7 Safety Audio not supported      
0197 Stand well away from the edge of platform 8 Safety Audio not supported      
0208 Attention please! Please leave the station immediately. Safety Audio not supported Male voice (quieter)    
0209 Attention please! Please leave the station immediately. Safety Audio not supported Male voice    
0210 Attention please! Please leave the station immediately. Safety Audio not supported Male voice    
0211 Attention please! Please leave the station immediately. Safety Audio not supported Male voice (louder)    
1176 Please take extra care when getting on and off trains. Safety Audio not supported      
1751 Stand well away from the edge of platform Safety Audio not supported      
1752 Fast train approaching Safety Audio not supported      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "announcements" (
   [File] TEXT PRIMARY KEY,
   [Transcription] TEXT,
   [Category] TEXT,
   [mp3] TEXT,
   [Notes] TEXT,
   [Timestamp] TEXT,
   [NRE_ID] TEXT
);
Powered by Datasette · Queries took 27.713ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette