home / zeropm-v0-0-4

consensus_index

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

8 rows where inventory_id = 71499

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
201504 201504 71499 71499 27587 11 0.231011550577529
201505 201505 71499 71499 52272 1 0.115505775288764
201506 201506 71499 71499 55483 1 0.0577528876443822
201507 201507 71499 71499 110443 4 0.231011550577529
201508 201508 71499 71499 202015 1 0.0770038501925096
201509 201509 71499 71499 202066 1 0.0462023101155058
201510 201510 71499 71499 241121 1 0.115505775288764
201511 201511 71499 71499 271530 1 0.115505775288764
CREATE TABLE [consensus_index] (
        [inventory_id] integer,
        [inchi_id] text,
        [consensus_score] text,
        [consensus_count] integer,
        FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
        FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);
Powered by Datasette · Queries took 1557.76ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website