home / scotrail

Menu
  • GraphQL API

announcements

Table actions
  • GraphQL API for announcements

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

24 rows where search matches "theft"

✎ View and edit SQL

This data as json, CSV (advanced)

Category 1

  • Reason 24
File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0969 Attempted theft of overhead line electrification equipment Reason Audio not supported      
0970 Attempted theft of overhead line electrification equipment earlier today Reason Audio not supported      
0971 Attempted theft of overhead line electrification equipment yesterday Reason Audio not supported      
0972 Attempted theft of railway equipment Reason Audio not supported      
0973 Attempted theft of railway equipment earlier today Reason Audio not supported      
0974 Attempted theft of railway equipment yesterday Reason Audio not supported      
0975 Attempted theft of signalling cables Reason Audio not supported      
0976 Attempted theft of signalling cables earlier today Reason Audio not supported      
0977 Attempted theft of signalling cables yesterday Reason Audio not supported      
0978 Attempted theft of third rail electrification equipment Reason Audio not supported      
0979 Attempted theft of third rail electrification equipment earlier today Reason Audio not supported      
0980 Attempted theft of third rail electrification equipment yesterday Reason Audio not supported      
1102 Theft of overhead line electrification equipment Reason Audio not supported      
1103 Theft of overhead line electrification equipment, earlier today Reason Audio not supported      
1104 Theft of overhead line electrification equipment, yesterday Reason Audio not supported      
1105 Theft of railway equipment Reason Audio not supported      
1106 Theft of railway equipment, earlier today Reason Audio not supported      
1107 Theft of railway equipment yesterday Reason Audio not supported      
1108 Theft of signalling cables Reason Audio not supported      
1109 Theft of signalling cables, earlier today Reason Audio not supported      
1110 Theft of signalling cables yesterday Reason Audio not supported      
1111 Theft of third rail electrical equipment Reason Audio not supported      
1112 Theft of third rail electrical equipment, earlier today Reason Audio not supported      
1113 Theft of third rail electrical equipment yesterday Reason 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 24.079ms · Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette