metadata.yml

title: "Global Chemical Inventory"

description_html: |-
  <p>This is a beta version (v0.0.3) of the ZeroPM database, the Global Chemical Inventory. It builds on work from <a href="https://doi.org/10.1021/acs.est.9b06379">Wang et al. (2020)</a> More updates coming soon!</p> 

license: "CC-BY-4.0"
license_url: "https://creativecommons.org/licenses/by/4.0/"

source: "ZeroPM GitHub"
source_url: "https://github.com/ZeroPM-H2020/global-chemical-inventory-database"

about: "ZeroPM Website"
about_url: "https://zeropm.eu/"

#version: "0.0.3"

databases:
  zeropm-v0-0-3:
    tables:
      api_results:
        hidden: true
      region_country_index:
        hidden: true 
    queries: 
      Canada_search:
        sql: |-
          SELECT country, inchi, identifier, source_name 
          FROM substances
            JOIN cleanventory_chemicals ON cleanventory_chemicals.inchi_id = substances.inchi_id
            JOIN inventories ON inventories.inventory_id = cleanventory_chemicals.inventory_id
            JOIN sources ON sources.source_id = inventories.source_id
            JOIN country_sources_index ON country_sources_index.source_id = inventories.source_id
            JOIN countries ON country_sources_index.country_id = countries.country_id
            JOIN region_country_index ON region_country_index.country_id = countries.country_id
            JOIN global_regions ON global_regions.region_id = region_country_index.region_id
          WHERE "Canada" in (countries.country) LIMIT 100;
        title: Canada
        description_html: |-
          <p>This is a list of chemicals registered in Canada. Results are limited to 100 rows.</p>
      Europe_search:
        sql: |-
          SELECT country, inchi, identifier, source_name 
          FROM substances
            JOIN cleanventory_chemicals ON cleanventory_chemicals.inchi_id = substances.inchi_id
            JOIN inventories ON inventories.inventory_id = cleanventory_chemicals.inventory_id
            JOIN sources ON sources.source_id = inventories.source_id
            JOIN country_sources_index ON country_sources_index.source_id = inventories.source_id
            JOIN countries ON country_sources_index.country_id = countries.country_id
            JOIN region_country_index ON region_country_index.country_id = countries.country_id
            JOIN global_regions ON global_regions.region_id = region_country_index.region_id
          WHERE "Europe" in (global_regions.region) ORDER BY countries.country_id LIMIT 1000;
        title: Europe
        description_html: |-
          <p>This is a list of chemicals registered in Europe. Results are limited to 1000 rows.</p>