Hydrochlorothiazide
Everything that changed this flow. Back to the flow
5c6a516b-20af-4d4a-8983-d216254adc55
By field
14 fields| Field | Changes | Written by | Latest note |
|---|---|---|---|
| properties | 5 | enrich_references, normalise_property_values, opsin_iupac, rdkit_post_consensus, rdkit_pre_consensus | typed the way the ontology types it |
| altLabel | 3 | chebi_altlabels, consensus_match, strip_catalogue_altlabels | Removed 2 catalogue altLabel value(s): 'NSC 53477' (registry code), 'Su 5879' (grade code) |
| prefLabel | 2 | bootstrap_labels, normalize_name_case | Title-cased words without internal capitals (preserved words with uppercase letters beyond the first character) |
| cas_match_labels | 1 | consensus_match | group_key=hydrochlorothiazide||dimension=Environmental > media=Water > water_body=Long-term; group_sources=['chebi', 'ec_inventory', 'pubchem']; cas_sources={'58-93-5': ['chebi', 'ec_inventory', 'pubchem']}; assigned CAS labels from group consensus; object_uuid=fo-9f550d725bc7f101: {'58-93-5': 'exactMatch'} |
| concept_associations | 1 | carry_associations_onto_flows | associations resolved on the elementary layer |
| context | 1 | default_context_mapping | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to fresh water |
| context_iri | 1 | default_context_mapping | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to fresh water |
| name | 1 | bootstrap_labels | Purged legacy name field to enforce prefLabel usage |
| references | 1 | enrich_references | Added references with provenance; cas_numbers=['58-93-5']; matched_chebi_ids=['http://purl.obolibrary.org/obo/CHEBI_5778']; candidate_pubchem_cids=[3639, 69571]; selected_pubchem_cids=[3639]; formula_similarity_expected=[]; pubchem_selection_rule=curated_cas_then_formula_similarity_then_prefer_chebi_aligned_when_unambiguous_else_keep_all_cas_matches; single_cas_commonchem_link=yes |
| roles | 1 | link_flows_to_their_substance | the substance's answer, copied onto its flow |
| skos_definition | 1 | enrich_references | Merged ChEBI/PubChem definitions into skos:definition |
| synonyms | 1 | bootstrap_labels | Removed legacy synonyms field in favor of structured labels |
| types | 1 | link_flows_to_their_substance | the substance's answer, copied onto its flow |
| unit_iri | 1 | unit_normalization | Unit IRI set from normalization of 'kg' |
Where several steps wrote one field, the last one won — and the log below shows the sequence.
Changes
21| # | Step | Field | From | To | Why |
|---|---|---|---|---|---|
| 12,433 | bootstrap_labels | prefLabel | — | [{"@value":"hydrochlorothiazide","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttribute… | Bootstrapped prefLabel from legacy name field |
| 12,434 | bootstrap_labels | name | hydrochlorothiazide | — | Purged legacy name field to enforce prefLabel usage |
| 12,435 | bootstrap_labels | synonyms | ["organic","hydrochlorothiazide"] | [] | Removed legacy synonyms field in favor of structured labels |
| 104,672 | default_context_mapping | context | — | {"dimension":"Environmental","media":"Water","water_body":"Surface water"} | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to fresh water |
| 104,673 | default_context_mapping | context_iri | — | https://vocab.brightway.one/flow-contexts/envi-wate-suwa | Mapped from context mapping for source=EF 3.1, source context Emissions > Emissions to water > Emissions to fresh water |
| 217,453 | unit_normalization | unit_iri | — | https://vocab.brightway.one/units/unit/KiloGM | Unit IRI set from normalization of 'kg' |
| 223,972 | normalize_name_case | prefLabel | [{"@value":"hydrochlorothiazide","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttribute… | [{"@value":"Hydrochlorothiazide","@language":"en","source":{"prov:wasGeneratedBy":"bootstrap_labels","prov:wasAttribute… | Title-cased words without internal capitals (preserved words with uppercase letters beyond the first character) |
| 238,990 | enrich_references | properties | {} | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | Added ChEBI/PubChem properties (chebi_ids=1, pubchem_cids=1) |
| 238,991 | enrich_references | skos_definition | — | [{"@value":"A benzothiadiazine that is 3,4-dihydro-2H-1,2,4-benzothiadiazine 1,1-dioxide substituted by a chloro group… | Merged ChEBI/PubChem definitions into skos:definition |
| 238,992 | enrich_references | references | [] | [{"@id":"drugcentral:1385","provenance":{"prov:wasGeneratedBy":"enrich_references.chebi_xrefs","prov:wasAttributedTo":"… | Added references with provenance; cas_numbers=['58-93-5']; matched_chebi_ids=['http://purl.obolibrary.org/obo/CHEBI_5778']; candidate_pubchem_cids=[3639, 69571]; selected_pubchem_cids=[3639]; formula_similarity_expected=[]; pubchem_selection_rule=curated_cas_then_formula_similarity_then_prefer_chebi_aligned_when_unambiguous_else_keep_all_cas_matches; single_cas_commonchem_link=yes |
| 251,712 | rdkit_pre_consensus | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | rdkit_pre_consensus from 'C1NC2=CC(=C(C=C2S(=O)(=O)N1)S(=O)(=O)N)Cl'; added: monoisotopic_mass |
| 256,087 | chebi_altlabels | altLabel | [] | [{"@value":"6-chloro-3,4-dihydro-2H-1,2,4-benzothiadiazine-7-sulfonamide 1,1-dioxide","@language":"en","source":{"prov:… | Added 4 ChEBI synonym(s) as altLabel from 1 linked ChEBI record(s) |
| 267,853 | consensus_match | altLabel | [{"@value":"6-chloro-3,4-dihydro-2H-1,2,4-benzothiadiazine-7-sulfonamide 1,1-dioxide","@language":"en","source":{"prov:… | [{"@value":"6-chloro-3,4-dihydro-2H-1,2,4-benzothiadiazine-7-sulfonamide 1,1-dioxide","@language":"en","source":{"prov:… | group_key=hydrochlorothiazide||dimension=Environmental > media=Water > water_body=Long-term; cas=58-93-5; added Common Chemistry CAS names as altLabel: 2<em>H</em>-1,2,4-Benzothiadiazine-7-sulfonamide, 6-chloro-3,4-dihydro-, 1,1-dioxide, 3,4-Dihydrochlorothiazide, 6-Chloro-3,4-dihydro-7-sulfamoyl-2<em>H</em>-1,2,4-benzothiadiazine 1,1-dioxide, 6-Chloro-7-sulfamoyl-3,4-dihydro-2<em>H</em>-1,2,4-benzothiadiazine 1,1-dioxide, 6-Chloro-7-sulfamoyl-3,4-dihydrobenzo-1,2,4-thiadiazine-1,1-dioxide, Acuretic, Apo-Hydro, Apresazide, Aquarius, Aquazide, Aquazide H, Caplaril, Carozide, Chlorosulthiadil, Chlorsulthiadil, Clorana, Clothia, Dichlothiazide, Dichlotiazid, Dichlotride, Dichlozid, Diclotride, Didralin, Dihydrochlorothiazide, Dihydrochlorothiazidum, Dihydrochlorurit, Dihydrochlorurite, Disalunil, Disothiazide, Diuret-P, Diurex, Diurizid, Drenol, Esidrex, Esidrix, HCT, HCTZ, HCZ, HH 25/25, HH 50/50, Hidrenox, Hidril, Hidrochlortiazid, Hidrosaluretil, Hidrotiazida, Hydrex, Hydrex-semi, Hydril, Hydro Par, Hydro-Aquil, Hydro-Diuril, Hydro-T, Hydrochlorothiazid, Hydrochlorthiazide, Hydrochlorzide, Hydrocot, Hydrodiuretic, Hydrosaluric, Hydrozide, Hypothiazid, Hypothiazide, Hypothiazide (C<sub>7</sub>H<sub>8</sub>ClN<sub>3</sub>O<sub>4</sub>S<sub>2</sub>), Idrodiuvis, Idrotiazide, Lopressor HCT, Lotensin HCT, Manschitt, Maschitt, MeSH ID: D006852, Megadiuril, Microzide, NSC 53477, Natrimax, Nefrix, Nefrol, Neoflumen, Newtolide, Oretic, Pantemon, Servithiazid, Su 5879, Tandiur, Thiuretic, Timolide, Trilopace H, Unipres, Urirex, Vetidrex, Ziac, Zide; object_uuid=fo-9f550d725bc7f101 |
| 267,854 | consensus_match | cas_match_labels | — | {"58-93-5":"exactMatch"} | group_key=hydrochlorothiazide||dimension=Environmental > media=Water > water_body=Long-term; group_sources=['chebi', 'ec_inventory', 'pubchem']; cas_sources={'58-93-5': ['chebi', 'ec_inventory', 'pubchem']}; assigned CAS labels from group consensus; object_uuid=fo-9f550d725bc7f101: {'58-93-5': 'exactMatch'} |
| 276,897 | opsin_iupac | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | opsin_iupac: set authoritative IUPAC name, SMILES, InChI from '6-chloro-3,4-dihydro-2H-1,2,4-benzothiadiazine-7-sulfonamide 1,1-dioxide' |
| 283,544 | rdkit_post_consensus | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | rdkit_post_consensus from 'NS(=O)(=O)c1cc2c(cc1Cl)NCNS2(=O)=O'; confirmed: smiles_string, inchi2d_string, inchi2d_key_string, molecular_formula, molecular_mass, monoisotopic_mass |
| 289,817 | strip_catalogue_altlabels | altLabel | [{"@value":"6-chloro-3,4-dihydro-2H-1,2,4-benzothiadiazine-7-sulfonamide 1,1-dioxide","@language":"en","source":{"prov:… | [{"@value":"6-chloro-3,4-dihydro-2H-1,2,4-benzothiadiazine-7-sulfonamide 1,1-dioxide","@language":"en","source":{"prov:… | Removed 2 catalogue altLabel value(s): 'NSC 53477' (registry code), 'Su 5879' (grade code) |
| 333,333 | carry_associations_onto_flows | concept_associations | [] | [{"@type":"xkos:ConceptAssociation","xkos:sourceConcept":{"@id":"https://vocab.brightway.one/ef/3.1/flow/5c6a516b-20af-… | associations resolved on the elementary layer |
| 391,254 | normalise_property_values | properties | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | {"https://w3id.org/chemrof/molecular_formula":{"@id":"https://w3id.org/chemrof/molecular_formula","@value":["C7H8ClN3O4… | typed the way the ontology types it |
| 399,203 | link_flows_to_their_substance | types | — | ["https://w3id.org/chemrof/NeutralMolecule"] | the substance's answer, copied onto its flow |
| 399,204 | link_flows_to_their_substance | roles | — | [{"@id":"http://purl.obolibrary.org/obo/CHEBI_78298","rdfs:label":"environmental contaminant","http://www.w3.org/2004/0… | the substance's answer, copied onto its flow |
PROV-O trail
21 activitiesOne activity per change: which version of the flow it consumed, and which it produced. The values are on the change with the same number — stored once, not twice.
| Activity | Field | Agent | Used | Generated |
|---|---|---|---|---|
| ef:activity/change/20260822T0600486828500000/12433 | prefLabel | ef:agent/bootstrap_labels | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v0 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v1 |
| ef:activity/change/20260822T0600486828500000/12434 | name | ef:agent/bootstrap_labels | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v1 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v2 |
| ef:activity/change/20260822T0600486828500000/12435 | synonyms | ef:agent/bootstrap_labels | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v2 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v3 |
| ef:activity/change/20260822T0600486828500000/104672 | context | ef:agent/default_context_mapping | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v3 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v4 |
| ef:activity/change/20260822T0600486828500000/104673 | context_iri | ef:agent/default_context_mapping | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v4 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v5 |
| ef:activity/change/20260822T0600486828500000/217453 | unit_iri | ef:agent/unit_normalization | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v5 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v6 |
| ef:activity/change/20260822T0600486828500000/223972 | prefLabel | ef:agent/normalize_name_case | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v6 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v7 |
| ef:activity/change/20260822T0600486828500000/238990 | properties | ef:agent/enrich_references | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v7 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v8 |
| ef:activity/change/20260822T0600486828500000/238991 | skos_definition | ef:agent/enrich_references | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v8 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v9 |
| ef:activity/change/20260822T0600486828500000/238992 | references | ef:agent/enrich_references | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v9 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v10 |
| ef:activity/change/20260822T0600486828500000/251712 | properties | ef:agent/rdkit_pre_consensus | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v10 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v11 |
| ef:activity/change/20260822T0600486828500000/256087 | altLabel | ef:agent/chebi_altlabels | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v11 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v12 |
| ef:activity/change/20260822T0600486828500000/267853 | altLabel | ef:agent/consensus_match | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v12 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v13 |
| ef:activity/change/20260822T0600486828500000/267854 | cas_match_labels | ef:agent/consensus_match | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v13 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v14 |
| ef:activity/change/20260822T0600486828500000/276897 | properties | ef:agent/opsin_iupac | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v14 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v15 |
| ef:activity/change/20260822T0600486828500000/283544 | properties | ef:agent/rdkit_post_consensus | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v15 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v16 |
| ef:activity/change/20260822T0600486828500000/289817 | altLabel | ef:agent/strip_catalogue_altlabels | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v16 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v17 |
| ef:activity/change/20260822T0600486828500000/333333 | concept_associations | ef:agent/carry_associations_onto_flows | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v17 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v18 |
| ef:activity/change/20260822T0600486828500000/391254 | properties | ef:agent/normalise_property_values | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v18 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v19 |
| ef:activity/change/20260822T0600486828500000/399203 | types | ef:agent/link_flows_to_their_substance | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v19 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v20 |
| ef:activity/change/20260822T0600486828500000/399204 | roles | ef:agent/link_flows_to_their_substance | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v20 | ef:flow/5c6a516b-20af-4d4a-8983-d216254adc55/v21 |