Skip to content

Instantly share code, notes, and snippets.

View cmutel's full-sized avatar

Chris Mutel cmutel

View GitHub Profile
@cmutel
cmutel / rhodium-palladium-ion-rows.csv
Created September 2, 2026 11:31
consensus-flow-list: ecoinvent 3.12 Rhodium III and Palladium II rows and AGRIBALYSE's minted ions, shared build 20260902T1058340456220000 (b445ff6)
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 11 columns, instead of 6 in line 6.
list,version,source_uuid,source_name,cas,context,unit,outcome,basis,basis_value,published_flow
agribalyse,3.2,3e763201-acbe-5ad4-8181-a6aadf547437,Palladium (II),16065-88-6,"[""Emissions to air""]",kg,created,,,f931b086795fa2d78dcb28c472dc1ee83c5e25b5
agribalyse,3.2,5fe37faf-3eb2-515c-b6d4-63b1069a6cd9,Rhodium (III),16065-89-7,"[""Emissions to air""]",kg,created,,,abc830222db25268ae4eb9a66c12ab78bab837df
ecoinvent,3.12,51377cff-3c04-5717-8961-6819901a3e90,Palladium II,16065-88-6,"[""air"",""unspecified""]",kg,algorithm,label,Palladium,08a91e70-3ddc-11dd-a056-0050c2490048
ecoinvent,3.12,55640730-a22e-4972-8709-f05c560b2d8b,Palladium II,16065-88-6,"[""water"",""ground-""]",kg,algorithm,label,Palladium,04074f82c5a00c6797a3e418bcb3f5029b1d7f1e
ecoinvent,3.12,ef90b8a8-d053-4927-9efe-841d9e1f3a5e,Palladium II,16065-88-6,"[""water"",""ground-, long-term""]",kg,algorithm,label,Palladium,08a91e70-3ddc-11dd-a05f-0050c2490048
ecoinvent,3.12,f8f45bf4-3126-41ac-918f-944a028c2ac8,Palladium II,16065-88-6,"[""water"","
@cmutel
cmutel / agribalyse-unrecorded-unit-crossings.csv
Created September 2, 2026 07:10
consensus-flow-list build 20260902T0601348875460000 (commit 944b274, 2026-09-02) — agribalyse-unrecorded-unit-crossings
We can make this file beautiful and searchable if this error is corrected: It looks like row 5 should actually have 17 columns, instead of 10 in line 4.
source_uuid,name_as_shipped,compartment,subcompartment,unit,cas,merged_as,outcome,basis,published_flow_uuid,published_flow_name,published_context,published_unit,vendor_exchange_rows,nonzero_rows,largest_amount,largest_amount_process
eb761cc9-c9ad-52ba-84e1-4f292d8cc77f,Argon-40/kg,Emissions to air,,kg,,Argon-40,algorithm,label,3f5f02ed-d820-47b1-b319-505ab06b9bc0,Argon-40,Environmental → Air → Unknown,kBq,30,30,0.004958912,Shed S {FR} U
b5bffb1f-1e13-56b7-a45f-eb5c262078e4,Lead-210/kg,Emissions to water,,kg,14255-04-0,Lead-210,algorithm,cas,4d9a8790-3ddd-11dd-9812-0050c2490048,Lead-210,Environmental → Water → Unknown,kBq,13,13,7.5433734e-21,Isoleucine S {CN} U
eb3ff946-cc3e-554d-850b-33064a00bcfd,Manganese-55,Emissions to water,,kBq,7439-96-5,Manganese-55,algorithm,cas,08a91e70-3ddc-11dd-9bcc-0050c2490048,Manganese,Environmental → Water → Unknown,kg,13,13,2.5102623e-12,Isoleucine S {CN} U
345c7fd9-afa8-5a1a-a079-46274e660f01,Radium-226/kg,Emissions to water,,kg,13982-63-3,Radium-226,algorithm,cas,08a91e70
@cmutel
cmutel / agribalyse-soil-carbon-stock-rows.csv
Created September 2, 2026 07:10
consensus-flow-list build 20260902T0601348875460000 (commit 944b274, 2026-09-02) — agribalyse-soil-carbon-stock-rows
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 4.
source_uuid,name_as_shipped,compartment,subcompartment,unit,cas,merged_as,outcome,basis,published_flow_uuid,published_flow_name,published_context,published_unit,vendor_exchange_rows,nonzero_rows,largest_amount,largest_amount_process
f2590e38-fbee-53d4-b8a2-f27c391bf73f,"Carbon, organic, in soil or biomass stock",Resources,,kg,7440-44-0,"Carbon, Organic, In Soil Or Biomass Stock",algorithm,cas+designation,5cdcf97ea78476e054c0c259aa9639d1132af2ec,Carbon,Resource → Ground,kg,12,12,0.065887425,Isoleucine S {FR} U
02ec599f-c6a1-50ac-86bc-ab213d8a9f83,"Carbon, organic, in soil or biomass stock",Resources,in ground,kg,7440-44-0,"Carbon, Organic, In Soil Or Biomass Stock",algorithm,cas+designation,5cdcf97ea78476e054c0c259aa9639d1132af2ec,Carbon,Resource → Ground,kg,2307,2278,31639.77,"Mine infrastructure, phosphate rock {GLO}| market for | Cut-off, S - Copied from Ecoinvent U"
0a68e3c1-dc59-515a-af32-c6ecb00b864a,"Carbon, organic, in soil or biomass stock",Resources,land,kg,7440-44-0,"Carbon, Organic, In Soil Or B
@cmutel
cmutel / agribalyse-bare-carbon-dioxide-rows.csv
Created September 2, 2026 07:10
consensus-flow-list build 20260902T0601348875460000 (commit 944b274, 2026-09-02) — agribalyse-bare-carbon-dioxide-rows
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 17 columns, instead of 12 in line 3.
source_uuid,name_as_shipped,compartment,subcompartment,unit,cas,merged_as,outcome,basis,published_flow_uuid,published_flow_name,published_context,published_unit,vendor_exchange_rows,nonzero_rows,largest_amount,largest_amount_process
9f281494-cb58-5f23-a894-ba8b7839e534,Carbon dioxide,Emissions to air,,kg,124-38-9,Carbon Dioxide,algorithm,cas+label,033b961dd01b53699d8830bf71d8d28beb794663,Carbon Dioxide,Environmental → Air → Unknown,kg,56,46,1917.5,Glutamate {CN} U
5dab3ab7-6821-58ec-b4dd-f1e0366ff916,Carbon dioxide,Emissions to air,low. pop.,kg,124-38-9,Carbon Dioxide,algorithm,cas+label,4cfc59229bd6474feed4931aa077d5fa0f08c418,Carbon Dioxide,"Environmental → Air → Medium stack, <150 meters → Rural (<1000 people/square mile)",kg,28,28,29.6,"Compost, of sludge and green waste (amendment), burden on downstream {RER} U"
d724a400-85de-5a17-bd00-fa94561fdf50,"Carbon dioxide, peat oxidation",Emissions to air,,kg,124-38-9,Carbon dioxide,algorithm,cas+label,033b961dd01b53699d8830bf71d8d28beb794663,Carbon Dioxide,E
@cmutel
cmutel / two-inchikeys.csv
Created August 30, 2026 07:12
consensus-flow-list build 20260829T1927246446400000 (commit 54b0f9d, 2026-08-29) — two-inchikeys
We can't make this file beautiful and searchable because it's too large.
substance_id,substance_name,cas,kind,bucket,inchikey,first_block,provenance,registry_backed,name_derived,common_chemistry_own,keys_on_substance,distinct_first_blocks,flows,flows_deprecated,factors_all,factors_consensus,source_lists,example_flow_uuid,example_flow_name,example_compartment
fo-96a91315c6effcea,(1-methyl-1-phenylethyl)phenyl Diphenyl Phosphate,34364-42-6,different atoms,a: registry key vs name-derived key - precedence decision,KMLCDKUGVGTGBJ-UHFFFAOYSA-N,KMLCDKUGVGTGBJ,PubChem (by_cas),True,False,False,2,2,13,0,52,26,EF 3.1,07cbf167-1021-4246-b796-4773acf3d21a,(1-methyl-1-phenylethyl)phenyl Diphenyl Phosphate,Environmental → Water → Surface water
fo-96a91315c6effcea,(1-methyl-1-phenylethyl)phenyl Diphenyl Phosphate,34364-42-6,different atoms,a: registry key vs name-derived key - precedence decision,NSKVIUBXDJHCAL-UHFFFAOYSA-N,NSKVIUBXDJHCAL,RDKit (from SMILES); derived from OPSIN name-to-structure,False,True,False,2,2,13,0,52,26,EF 3.1,07cbf167-1021-4246-b796-4773acf3d21a,(1-methyl-1-phenylethyl
@cmutel
cmutel / stepwise-previous-state-land-rows.csv
Created August 30, 2026 07:12
consensus-flow-list build 20260829T1927246446400000 (commit 54b0f9d, 2026-08-29) — stepwise-previous-state-land-rows
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
stepwise_row_name,residue_the_parser_could_not_place,flow_uuid,published_flow_name,compartment,unit,substance_id,substance_name,substance_flow_type,is_deprecated,factors (implementer: category = amount (derivation)),factor_count,merge_outcome,other_source_rows_on_this_flow
"Occupation, accelerated denaturalisation, grassland to pasture",accelerated denaturalisation + grassland to pasture,2cee44b47004eb93470f636f7114c4222af24f7c,"Occupation, Accelerated Denaturalisation, Grassland To Pasture",Land Use → Occupation,m2.a,fo-18781a192cfefa8c,"Occupation, Accelerated Denaturalisation, Grassland To Pasture",unclassified,0,2.-0 LCA consultants: Nature occupation = 0.3 (own); consensus-flow-list: Nature occupation = 0.3 (sole),2,created flow_object_creation ,
"Occupation, accelerated denaturalisation, primary forest to extensive forest",accelerated denaturalisation + primary forest to extensive forest,41d6c1a92f04616b64e58fa4e45e3e243f6e3c4c,"Occupation, Accelerated Denaturalisation, Primary Forest To Extensive For
@cmutel
cmutel / registry-rename-shortlist.csv
Created August 30, 2026 07:12
consensus-flow-list build 20260829T1927246446400000 (commit 54b0f9d, 2026-08-29) — registry-rename-shortlist
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 5.
old_name,new_name,cas,what_was_lost,reduction,bucket,flows,ruling_on_file,ruling_notes,published_today_on_example_flow,substance_name_today,example_flow_uuid,example_compartment,example_flow_cas,flows_named_new_today,flows_named_old_today,common_chemistry_name,chebi_labels
Pyraclostrobin (prop),Pyraclostrobin,175013-18-0,parenthetical: prop,True,systematic_to_common,20,none,,Pyraclostrobin,Pyraclostrobin,056a192d-e899-4d84-accd-46a81dd2ac9c,Environmental → Water → Long-term,175013-18-0,21,0,Pyraclostrobin,pyraclostrobin
(1s)-(-)-alpha-pinene,(-)-α-Pinene,7785-26-4,parenthetical: 1s,True,systematic_to_common,13,none,,(-)-α-Pinene,(-)-α-Pinene,29061440-6556-11dd-ad8b-0800200c9a66,Environmental → Ground → Agricultural,7785-26-4,13,0,(-)-α-Pinene,(-)-alpha-pinene
"1,3-dihydroxyacetone",Dihydroxyacetone,96-26-4,"locant: 1,3",True,synonym_swap,13,none,,Dihydroxyacetone,Dihydroxyacetone,00eef6ff-bf68-469f-8732-3369db297c55,Environmental → Water → Surface water,96-26-4,13,0,Dihydroxyacetone,dihydroxyacetone
"1,6-
@cmutel
cmutel / minted-substances-all-lists.csv
Created August 30, 2026 07:12
consensus-flow-list build 20260829T1927246446400000 (commit 54b0f9d, 2026-08-29) — minted-substances-all-lists
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 24 columns, instead of 9 in line 3.
list,version,source_uuid,source_name,source_cas,source_context,unit,substance_id,substance_name,flow_type,unclassified_reason,property_count,classification_count,has_formula,has_smiles,has_inchi,has_inchikey,has_mass,has_charge,substance_cas_published,cross_list_cas_the_name_could_have_taken,lists_stating_that_cas,existing_substance_whose_label_matches_the_name,elementary_flow_uuid
ecoinvent,3.12,00936757-054d-5bc1-9490-23c6f1f1840f,Ioxynil Octanoate,3861-47-0,"['water', 'unspecified']",kg,fo-bbe3ad5e5daea8b8,Ioxynil Octanoate,NeutralMolecule,,7,2,yes,yes,yes,yes,yes,yes,,,,,dd11b7c1876a44cf3d02ebb92ee51cfd40143e63
ecoinvent,3.12,017e8179-f85d-52d7-9228-18d8b7065681,"Copper Chloride Oxide, Hydrate",1332-40-7,"['soil', 'forestry']",kg,fo-8ba5127e2e7ae1b7,"Copper Chloride Oxide, Hydrate",ImpreciseChemicalMixture,,0,1,no,no,no,no,no,no,,,,,f19b273895f7daf98a3cdfb6694707a092a6c336
ecoinvent,3.12,01cc4a83-9f3f-52e4-9404-bc1251a9335e,Beflubutamid,113614-08-7,"['water', 'unspecified']",kg,fo-c53cb43352839041,Befl
@cmutel
cmutel / greendelta-country-water-tail.csv
Created August 30, 2026 07:12
consensus-flow-list build 20260829T1927246446400000 (commit 54b0f9d, 2026-08-29) — greendelta-country-water-tail
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
greendelta_flow_name,greendelta_compartment,unit,cas,country_coded,country_or_region_code,name_without_code,same_name_is_an_exchange_in_the_bafu_ecospold_zip,factors_in_package,factors_published_on_a_flow_of_ours,factors_reaching_nothing,impact_categories,sample_factors_geography=amount,site_generic_flow_of_ours_reached_by_name_without_code (name|compartment|uuid|consensus water-use factors),lcia_findings_detail,greendelta_source_flow_uuid
"Water, EG",Elementary flows/Emission to water/river,m3,007732-18-5,yes,EG,Water,yes,2,1,1,Water use,GLO=-98.4; EG=-98.4,Water|Environmental → Water → River|f213d8e4abd83830db89e3b9bf1ec0de3b5d00af|consensus water-use factors 0,(no finding recorded),027354fe-6d83-35d3-b878-df72c8ec4469
"Water, unspecified natural origin, IN",Elementary flows/Resource/in water,m3,007732-18-5,yes,IN,"Water, unspecified natural origin",yes,2,0,2,Water use,IN=29.4; GLO=29.4,,"flow-not-reached: Water, unspecified natural origin, IN carries 2 factors and is merged onto no consensus flow, so non
@cmutel
cmutel / formula-element-disagreement.csv
Created August 30, 2026 07:12
consensus-flow-list build 20260829T1927246446400000 (commit 54b0f9d, 2026-08-29) — formula-element-disagreement
We can make this file beautiful and searchable if this error is corrected: It looks like row 4 should actually have 16 columns, instead of 1 in line 3.
substance_id,substance_name,cas,formulas,element_sets,extra_elements,classification,formula_provenance,flows,flows_deprecated,factors_all,factors_consensus,source_lists,example_flow_uuid,example_flow_name,example_compartment
fo-61672a19d0d5dc87,"1,3-dioxodiphosphoxane 1,3-dioxide",1314-56-3,H2O2Pb | H4O7P2 | O10P4 | O5P2,HOPb | HOP | OP | OP,HPPb,element the substance does not contain (wrong hit),"H2O2Pb: PubChem; H4O7P2: PubChem; O10P4: PubChem; O5P2: PubChem, RDKit (from SMILES)",15,0,62,31,EF 3.1; stepwise 2006-1.09,1502592d-31f3-49d6-baf2-045526344a4e,"1,3-dioxodiphosphoxane 1,3-dioxide",Environmental → Water → Ocean
fo-acb63277eb53db3a,2-hydrazino-4-(p-aminophenyl)thiazole,26049-71-8,C22H17ClO2 | C9H10N4S,CClHO | CHNS,ClNOS,element the substance does not contain (wrong hit),"C22H17ClO2: PubChem; C9H10N4S: PubChem, RDKit (from SMILES)",14,0,64,32,EF 3.1; stepwise 2006-1.09,08a91e70-3ddc-11dd-8fba-0050c2490048,2-hydrazino-4-(p-aminophenyl)thiazole,Environmental → Ground → Agricultural
fo-b1dee00c87f6608