Example CSV file - multi-language content

http://environment.data.gov.uk/sources/bwq/eaew/input/stp-ReportForEpimorphics-20131002-20131002-072846-115.csv

STP = Short Term Predications

The link is to a real report for 2013/Oct/2.

These are water quality predications based on local conditions (local 
heavy rain in this particualr example)

"Site"
The site columns looks syntactically like a number but the leading zeros 
are significant as the column contains a key.

The predication is about this site but this is not necessarily the thing 
to choose as a primary key.  It might be used to create a link to the 
site by some template mechanism (a foreign key in effect).

"Datetime"
The column header has trailing whitespace.

"Prediction"
A code number.  Again, not a number.

"Prediction_text_en","Prediction_text_cy"

The labels to be used in English and Welsh.

 Andy

Received on Sunday, 30 March 2014 19:47:54 UTC