{
  "fields": [{"id":"_id","type":"int"},{"id":"Original Header","type":"text"},{"id":"Type","type":"text"},{"id":"Cleaned Variable Name","type":"text"},{"id":"CanWIN Common Name","type":"text"},{"id":"Units","type":"text"},{"id":"Data Provider Description","type":"text"},{"id":"Standardized Source Term","type":"text"},{"id":"Standardized Source Term Link","type":"text"},{"id":"Notes","type":"text"},{"id":"media_type","type":"text"},{"id":"result_value_type","type":"text"},{"id":"statistic_applied","type":"text"}],
  "records": [
    [1,"The exact column name as it appeared in the raw file before any cleaning.","The variable’s data type (text, numeric, timestamp, etc.) after cleaning.","The standardized, machine‑friendly name produced following data best practices, for e.g., using the CSV Studio’s header cleaning function. Used in the final dataset.","A human‑readable name. Helps non‑technical users understand the variable.","The physical units associated with the variable (e.g., m, PSU, °C).","Description explaining what the variable represents.","Standardized scientific term selected from an authoritative vocabulary (e.g., BODC, CF). Ensures consistent meaning across datasets.","Link to standardized scientific term and definition.","Any notes about how the variable was processed or derived.Extracted from the header or assigned manually.","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 statistical operation applied to the variable (e.g., mean, max, min). “none” if no statistic was applied."],
    [2,null,"timestamp","date-time","Date-Time","UTC","String corresponding to format 'YYYY-MM-DDThh:mm:ss.sssZ' or other valid ISO8601 string","UT_ISO8600","http://vocab.nerc.ac.uk/collection/P01/current/DTUT8601/","Added from metadata rows","Freshwater","actual","None"],
    [3,null,"timestamp","lattitude","Latitude","decimal degrees","Latitude north","Lat","http://vocab.nerc.ac.uk/collection/P01/current/ALATZZ01/","Added from metadata rows","Freshwater","actual","None"],
    [4,null,"timestamp","longitude","Longitude","decimal degrees","Longitude east","Lon","http://vocab.nerc.ac.uk/collection/P01/current/ALONZZ01/","Added from metadata rows","Freshwater","actual","None"],
    [5,"Depth","numeric","depth (m)","Depth","m","Depth of the CTD in meters derived from pressure using salt water equations.","BATH","http://vocab.nerc.ac.uk/collection/P09/current/BATH/",null,"Freshwater","actual","None"],
    [6,"Temperature","numeric","temperature (degC)","Water Temperature","degC","Water temperature measured by the CTD and reported on the ITS-90 temperature scale.","WC_temp_CTD","http://vocab.nerc.ac.uk/collection/P01/current/TEMPS901/",null,"Freshwater","actual","None"],
    [7,"SpecificConductance","numeric","specific_conductance (uS cm-1)","Conductivity","uS cm^-1","Conductivity of seawater measured by the CTD, used to calculate salinity.","CTDCond","http://vocab.nerc.ac.uk/collection/P01/current/CNDCST01/",null,"Freshwater","actual","None"],
    [8,"DissolvedOxygen","numeric","dissolved_oxygen (mg l-1)","Oxygen (Mass-Based) - Water","mg L^-1","Dissolved oxygen (mg L⁻¹) is the mass of molecular oxygen dissolved in seawater, expressed as milligrams of O₂ per liter. On Sea‑Bird CTD systems, this value is derived from the SBE43 electrochemical oxygen sensor, which measures oxygen partial pressure and converts it to concentration using temperature, salinity, and pressure corrections.","DissO2_Mass","https://vocab.nerc.ac.uk/collection/P01/current/DOXMZZXX/",null,"Freshwater","actual","None"],
    [9,"DissolvedOxygen","numeric","dissolved_oxygen (percent_sat)","Oxygen (Saturation) - Water","%sat","Oxygen saturation (%) describes how much dissolved oxygen is present in seawater compared to the maximum amount the water could hold at the same temperature, salinity, and pressure.","O2_Sat_SBE43","https://vocab.nerc.ac.uk/collection/P01/current/OXYSSU01/",null,"Freshwater","actual","None"],
    [10,"Turbidity","numeric","turbidity (ntu)","Turbidity","NTU","Turbidity is a measure of how much light is scattered by particles suspended in seawater. On a Sea‑Bird CTD, turbidity is typically measured using an optical backscatter sensor (such as a WET Labs ECO FLNTU or ECO NTU module). The sensor emits light into the water and detects the amount that is scattered back toward the instrument. Higher turbidity values indicate more suspended particles, such as sediment, plankton, or organic matter.","Turbidity","https://vocab.nerc.ac.uk/collection/P01/current/TURBXXXX/",null,"Freshwater","actual","None"],
    [11,"Chlorophyll","numeric","chlorophyll (rfu)","Chlorophyll-a Flourescence","RFU","Chlorophyll fluorescence (RFU) represents the intensity of light emitted by chlorophyll‑a pigments in phytoplankton when they are excited by a specific wavelength of light. On a Sea‑Bird CTD, this measurement is typically made using a WET Labs ECO fluorometer integrated into the package. The sensor shines blue light into the water and detects the red fluorescence emitted by chlorophyll‑a in suspended phytoplankton cells.","chl-a_water_ISfluor_manufctrcal_sensor1","https://vocab.nerc.ac.uk/collection/P01/current/CPHLPM01/",null,"Freshwater","actual","None"],
    [12,"UnderwaterPAR","numeric","underwater_par (uE m-2 s-1)","Photosynthetically Active Radiation (Water)","uE m^-2 s^-1","Underwater PAR represents the amount of photosynthetically active radiation (light in the 400–700 nm range) reaching a point beneath the water surface. On a Sea‑Bird CTD, this measurement is collected using an in‑situ cosine‑collector PAR sensor (typically a Biospherical or LI‑COR instrument integrated into the CTD package). The sensor counts the number of photons arriving from above and reports the result as a photon flux density in units of µmol photons m⁻² s⁻¹ (µE m⁻² s⁻¹).\n \n This measurement reflects how much usable light is available for photosynthesis at depth. PAR decreases with depth due to absorption and scattering by water, dissolved substances, and suspended particles, making it a key indicator of underwater light climate and primary productivity potential.","SubsurVPAR","https://vocab.nerc.ac.uk/collection/P01/current/IRRDUV01/",null,"Freshwater","actual","None"],
    [13,"DescentRate","numeric","descent_rate (m s-1)",null,"m s^-1","Descent rate (m s⁻¹) is the vertical speed of the CTD package as it is lowered through the water column. It describes how quickly the instrument is moving downward during a cast.",null,null,null,"Freshwater","actual","None"],
    [14,"SurfacePAR","numeric","surfacepar (uE m-2 s-1)","Photosynthetically Active Radiation (Air)","uE m^-2 s^-1","Surface PAR represents the downwelling photosynthetically active radiation (400–700 nm) measured at the air–sea interface by the surface PAR sensor (deck cell) on a Sea‑Bird system. The cosine‑collector radiometer detects the flux of incoming photons from the sky and reports the photon irradiance in µmol photons m⁻² s⁻¹ (µE m⁻² s⁻¹). This measurement characterizes the amount of usable light available to drive photosynthesis at the surface.","SurfVPAR","https://vocab.nerc.ac.uk/collection/P01/current/IRRDSV01/",null,"Freshwater","actual","None"]
]}