announcements

Table actions

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

File ▼ Transcription Category mp3 Notes Timestamp NRE_ID
0969 Attempted theft of overhead line electrification equipment Reason      
0970 Attempted theft of overhead line electrification equipment earlier today Reason      
0971 Attempted theft of overhead line electrification equipment yesterday Reason      
0972 Attempted theft of railway equipment Reason      
0973 Attempted theft of railway equipment earlier today Reason      
0974 Attempted theft of railway equipment yesterday Reason      
0975 Attempted theft of signalling cables Reason      
0976 Attempted theft of signalling cables earlier today Reason      
0977 Attempted theft of signalling cables yesterday Reason      
0978 Attempted theft of third rail electrification equipment Reason      
0979 Attempted theft of third rail electrification equipment earlier today Reason      
0980 Attempted theft of third rail electrification equipment yesterday Reason      
1102 Theft of overhead line electrification equipment Reason      
1103 Theft of overhead line electrification equipment, earlier today Reason      
1104 Theft of overhead line electrification equipment, yesterday Reason      
1105 Theft of railway equipment Reason      
1106 Theft of railway equipment, earlier today Reason      
1107 Theft of railway equipment yesterday Reason      
1108 Theft of signalling cables Reason      
1109 Theft of signalling cables, earlier today Reason      
1110 Theft of signalling cables yesterday Reason      
1111 Theft of third rail electrical equipment Reason      
1112 Theft of third rail electrical equipment, earlier today Reason      
1113 Theft of third rail electrical equipment yesterday Reason      

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