announcements_fts
Data source: matteason/scotrail-announcements-june-2022 · About: simonw/scotrail-datasette
2,440 rows sorted by Transcription
This data as json, CSV (advanced)
Link | rowid | Transcription ▼ | announcements_fts | rank |
---|---|---|---|---|
1596 | 1596 | Please listen for announcements onboard the train | 1 | |
319 | 319 | ...Edinburgh Gateway... | 1 | |
2379 | 2379 | ...First Capital Connect. | 1 | |
2378 | 2378 | ...First Capital Connect.... | 1 | |
2383 | 2383 | ...Grand Central | 1 | |
2382 | 2382 | ...Grand Central... | 1 | |
1729 | 1729 | ...a bicycle on the track earlier on this train's journey. | 1 | |
1730 | 1730 | ...a bicycle on the track earlier today. | 1 | |
1728 | 1728 | ...a bicycle on the track... | 1 | |
1732 | 1732 | ...a boat colliding with a bridge earlier today | 1 | |
1731 | 1731 | ...a boat colliding with a bridge. | 1 | |
1734 | 1734 | ...a bridge being damaged by a boat. | 1 | |
1735 | 1735 | ...a bridge being damaged by a road vehicle. | 1 | |
1733 | 1733 | ...a bridge being damaged. | 1 | |
1736 | 1736 | ...a bridge having collapsed. | 1 | |
1738 | 1738 | ...a broken down train, earlier today. | 1 | |
1737 | 1737 | ...a broken down train. | 1 | |
1739 | 1739 | ...a broken rail. | 1 | |
1740 | 1740 | ...a broken windscreen on the train. | 1 | |
1742 | 1742 | ...a burst water main flooding the railway, earlier today. | 1 | |
1741 | 1741 | ...a burst water main flooding the railway. | 1 | |
1744 | 1744 | ...a burst water main near the railway, earlier today. | 1 | |
1745 | 1745 | ...a burst water main near the railway, yesterday. | 1 | |
1743 | 1743 | ...a burst water main near the railway. | 1 | |
1747 | 1747 | ...a bus colliding with a bridge, earlier on this train's journey. | 1 | |
1748 | 1748 | ...a bus colliding with a bridge, earlier today. | 1 | |
1746 | 1746 | ...a bus colliding with a bridge. | 1 | |
1750 | 1750 | ...a chemical spillage near the railway earlier today | 1 | |
1751 | 1751 | ...a chemical spillage near the railway yesterday | 1 | |
1749 | 1749 | ...a chemical spillage near the railway. | 1 | |
1753 | 1753 | ...a coach becoming uncoupled on a train earlier in its journey | 1 | |
1754 | 1754 | ...a coach becoming uncoupled on a train earlier today | 1 | |
1752 | 1752 | ...a coach becoming uncoupled on a train. | 1 | |
1756 | 1756 | ...a coach becoming uncoupled on this train earlier in its journey. | 1 | |
1757 | 1757 | ...a coach becoming uncoupled on this train earlier today. | 1 | |
1755 | 1755 | ...a coach becoming uncoupled on this train. | 1 | |
1759 | 1759 | ...a collision at a level crossing earlier today. | 1 | |
1760 | 1760 | ...a collision at a level crossing yesterday. | 1 | |
1758 | 1758 | ...a collision at a level crossing. | 1 | |
1761 | 1761 | ...a collision between trains. | 1 | |
1762 | 1762 | ...a collision with the buffers at a station. | 1 | |
1763 | 1763 | ...a derailed train. | 1 | |
1764 | 1764 | ...a derailment within the depot. | 1 | |
1765 | 1765 | ...a fault occurring when attaching a part of a train. | 1 | |
1766 | 1766 | ...a fault occurring when attaching a part of this train. | 1 | |
1767 | 1767 | ...a fault occurring when detaching a part of a train. | 1 | |
1768 | 1768 | ...a fault occurring when detaching a part of this train. | 1 | |
1769 | 1769 | ...a fault on a train in front of this one. | 1 | |
1771 | 1771 | ...a fault on this train which is now fixed. | 1 | |
1770 | 1770 | ...a fault on this train. | 1 | |
1773 | 1773 | ...a fault with a swing bridge over a river earlier today. | 1 | |
1772 | 1772 | ...a fault with a swing bridge over a river. | 1 | |
1775 | 1775 | ...a fault with barriers at a level crossing earlier today. | 1 | |
1776 | 1776 | ...a fault with barriers at a level crossing yesterday. | 1 | |
1774 | 1774 | ...a fault with barriers at a level crossing. | 1 | |
1778 | 1778 | ...a fault with the electric third rail earlier on this train's journey. | 1 | |
1779 | 1779 | ...a fault with the electric third rail earlier today. | 1 | |
1777 | 1777 | ...a fault with the electric third rail. | 1 | |
1781 | 1781 | ...a fault with the on-train signalling system earlier on this train's journey. | 1 | |
1782 | 1782 | ...a fault with the on-train signalling system earlier today. | 1 | |
1780 | 1780 | ...a fault with the on-train signalling system. | 1 | |
1784 | 1784 | ...a fault with the radio system between the driver and the signaller earlier on this train's journey. | 1 | |
1785 | 1785 | ...a fault with the radio system between the driver and the signaller earlier today. | 1 | |
1783 | 1783 | ...a fault with the radio system between the driver and the signaller. | 1 | |
1787 | 1787 | ...a fault with the signalling system earlier on this train's journey. | 1 | |
1788 | 1788 | ...a fault with the signalling system earlier today. | 1 | |
1786 | 1786 | ...a fault with the signalling system. | 1 | |
2411 | 2411 | ...adverse weather conditions... | 1 | |
1723 | 1723 | ...an incident on the line... | 1 | |
29 | 29 | ...at... | 1 | |
1725 | 1725 | ...cancellation of the incoming service... | 1 | |
1605 | 1605 | ...customers are advised to evacuate this station by the nearest exit | 1 | |
34 | 34 | ...is delayed. | 1 | |
50 | 50 | ...is the delayed... | 1 | |
51 | 51 | ...is the delayed... | 1 | |
1727 | 1727 | ...signalling difficulties. | 1 | |
1726 | 1726 | ...signalling difficulties... | 1 | |
1724 | 1724 | ...suspected damage to a railway bridge... | 1 | |
1603 | 1603 | ...train is ready to board | 1 | |
1722 | 1722 | ...trespass on the line... | 1 | |
1606 | 1606 | ...waiting for trains at this station. | 1 | |
28 | 28 | ...will not call at... | 1 | |
2225 | 2225 | 01 | 1 | |
2249 | 2249 | 01 | 1 | |
2310 | 2310 | 01 | 1 | |
2226 | 2226 | 02 | 1 | |
2250 | 2250 | 02 | 1 | |
2311 | 2311 | 02 | 1 | |
2227 | 2227 | 03 | 1 | |
2251 | 2251 | 03 | 1 | |
2312 | 2312 | 03 | 1 | |
2228 | 2228 | 04 | 1 | |
2252 | 2252 | 04 | 1 | |
2313 | 2313 | 04 | 1 | |
2229 | 2229 | 05 | 1 | |
2253 | 2253 | 05 | 1 | |
2314 | 2314 | 05 | 1 | |
2230 | 2230 | 06 | 1 | |
2254 | 2254 | 06 | 1 | |
2315 | 2315 | 06 | 1 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIRTUAL TABLE [announcements_fts] USING FTS5 ( [Transcription], tokenize='porter', content=[announcements] );