home

zeropm-v0-0-4

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

Custom SQL query

Queries

  • Canada
  • Europe

Tables

api_ready_query

query_id, query, type

Many rows

api_services

api_id, name, source

6 rows

cleanventory_chemicals

cleanventory_id, inventory_id, inchi_id

483,388 rows

component_index

mc_id, component_id, component_frequency

93,647 rows

components

component_id, inchi_id

22,380 rows

consensus_index

inventory_id, inchi_id, consensus_score, consensus_count

Many rows

countries

country_id, country

38 rows

country_sources_index

country_id, source_id

80 rows

global_regions

region_id, region

5 rows

inventories

inventory_id, identifier, source_id

Many rows

inventory_summary

inventory_id, query_id

1,045,887 rows

multi_components

mc_id, inchi_id

38,696 rows

pm_probabilities

inchi_id, probability_of_not_p, probability_of_p_or_vp, probability_of_p, probability_of_vp, probability_of_not_m, probability_of_m_or_vm, probability_of_m, probability_of_vm, n

130,954 rows

sources

source_id, source_name, link, disclosure, type, country_scope, comments

25 rows

substances

inchi_id, inchi, inchikey

Many rows

zeropm_chemicals

zeropm_id, inchi_id

126,369 rows

... and 2 hidden tables

Powered by Datasette · Queries took 99.862ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website