announcements
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
26 rows where search matches "Bridge " and Category != "Destination" sorted by Category
This data as json, CSV (advanced)
Suggested facets: Notes, NRE_ID
Category 1
- Reason 26
File | Transcription | Category ▼ | mp3 | Notes | Timestamp | NRE_ID |
---|---|---|---|---|---|---|
0629 | ...suspected damage to a railway bridge... | Reason | mid (suffixed with 'at <station>'/'between <x> and <y>'/similar) | |||
0741 | ...a boat colliding with a bridge. | Reason | ||||
0742 | ...a boat colliding with a bridge earlier today | Reason | ||||
0743 | ...a bridge being damaged. | Reason | ||||
0744 | ...a bridge being damaged by a boat. | Reason | ||||
0745 | ...a bridge being damaged by a road vehicle. | Reason | ||||
0746 | ...a bridge having collapsed. | Reason | ||||
0756 | ...a bus colliding with a bridge. | Reason | ||||
0757 | ...a bus colliding with a bridge, earlier on this train's journey. | Reason | ||||
0759 | ...a bus colliding with a bridge, earlier today. | Reason | ||||
0784 | ...a fault with a swing bridge over a river. | Reason | ||||
0785 | ...a fault with a swing bridge over a river earlier today. | Reason | ||||
0823 | A lorry colliding with a bridge | Reason | ||||
0824 | A lorry colliding with a bridge earlier on this trains journey | Reason | ||||
0825 | A lorry colliding with a bridge earlier today | Reason | ||||
0839 | A problem with a river bridge | Reason | Belter | 562 | ||
0841 | A problem with a river bridge earlier today | Reason | ||||
0858 | A road vehicle colliding with a bridge | Reason | ||||
0859 | A road vehicle colliding with a bridge earlier on this train's journey | Reason | ||||
0860 | A road vehicle colliding with a bridge earlier today | Reason | ||||
0913 | a speed restriction over a bridge | Reason | ||||
0914 | a speed restriction over a bridge earlier on this train's journey | Reason | ||||
0915 | a speed restriction over a bridge earlier today | Reason | ||||
1138 | Urgent repairs to a bridge | Reason | ||||
1139 | Urgent repairs to a bridge earlier today | Reason | ||||
1716 | suspected damage to a railway bridge. | Reason |
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 );