{
  "fields": [{"id":"_id","type":"int"},{"id":"Original Header","type":"text"},{"id":"Common Name","type":"text"},{"id":"Units","type":"text"},{"id":"Data Provider Description","type":"text"},{"id":"media_type","type":"text"},{"id":"result_value_type","type":"text"},{"id":"Notes","type":"text"}],
  "records": [
    [1,"The exact column name as it appeared in the raw file before any cleaning.","A common or understandable name for the variable.","The physical units associated with the variable (e.g., m, PSU, °C).","The description supplied by the original data provider explaining what the variable represents.","The medium from which the measurement was taken (e.g., water, air, sediment). Extracted from the header or assigned manually.","Whether the value is a direct measurement or a calculated value.","Any notes about how the variable was processed or derived.Extracted from the header or assigned manually."],
    [2,"id","Measurement ID","–","Unique ID value assigned to each row in the datasheet","Seawater",null,null],
    [3,"date_time","Date and Time","–","Date and Time in the format dd-mm-yyyy hh:mm:ss","Seawater",null,null],
    [4,"year","Year","–","Year of measurement","Seawater",null,null],
    [5,"month","Month","–","Month of measurement","Seawater",null,null],
    [6,"day","Day","–","Date of measurement","Seawater",null,null],
    [7,"hour","Hour","–","Hour of measurement","Seawater",null,null],
    [8,"minute","Minute","–","Minute of measurement","Seawater","actual",null],
    [9,"latitude","Latitude","degrees north","Latitude of measurement","Seawater","actual",null],
    [10,"longitude","Longitude","degrees east","Longitude of measurement","Seawater","actual",null],
    [11,"temperature","Water Temperature","degrees C","Surface water temperature determined from TSG","Seawater","actual",null],
    [12,"temp_adj","Water Temperature (Adjusted)","degrees C","Surface water temperature adjusted to reflect CTD conditions","Seawater","actual",null],
    [13,"salinity","Salinity","psu","Surface water salinity determined from TSG","Seawater","actual",null],
    [14,"sal_ref","Reference Salinity","g/kg","Salinity measured in g/kg for ocean calculations","Seawater","actual",null],
    [15,"co2","Surface water pCO2","µatm","Surface water pCO2 measurement","Seawater","actual",null],
    [16,"pco2temp","pCO2 (temperature)","µatm","Thermally influenced surface water pCO2","Seawater","actual",null],
    [17,"pco2net","pCO2 (net)","µatm","“Net” influenced surface water pCO2","Seawater","actual",null],
    [18,"dpco2","Air - Sea CO2 difference","µatm","Difference between seawater and atmospheric CO2","Seawater","calculated",null]
]}