Log: known string formats in Oyster data

[matt-dray]

Examples of unique string formats from Oyster data sent by email from TfL (example CSV). I assume that more are possible. What are they?

Journey/Action column

Train travel

• X to Y
• X to Y [National Rail]
• X to Y [London Underground]
• X to Y [London Underground / National Rail]
• X to Y (A, B lines)

Start and end the same

• Entered and exited X

Failed tap

• X to [No touch-out]
• [No touch-in] to X

Other transport modes

• Bus journey, route 999

Fares

• Season ticket added on touch in, X
• Topped up,
• Automated Refund, X

Note column

• NA
• We are not able to show where you touched out during this journey
• We are not able to show where you touched in during this journey
• You have been charged for travelling in zones not covered by your Travelcard.

[matt-dray]

Tweeted about this: https://twitter.com/mattdray/status/1179438163665793024?s=20

[matt-dray]

19 November 2019

Thank you for contacting us in regards to your query with the downloadable Oyster journey history CSV file.

I appreciate the time you have taken to get in touch with us.

Unfortunately I will not be able to provide a breakdown of all the possible formats on this occasion.

I've reached out to our technical team who have advised that you may want to raise an FOI request, but of course the information received will be in relation to yourself and may not give you all the formats for the data within the Journey/Action and Notes columns.

I'm sorry I'm unable to provide you with a more favourable response and trust this resolves your query to your satisfaction.

Kind regards

Customer Service Adviser
Transport for London Customer Services