home / zeropm-v0-0-4

consensus_index

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

28 rows where inventory_id = 71595

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
201809 201809 71595 71595 45286 8 0.254678174360871
201810 201810 71595 71595 136966 2 0.127339087180436
201811 201811 71595 71595 186242 2 0.0450211660276955
201812 201812 71595 71595 186857 2 0.0128796288821797
201813 201813 71595 71595 189109 2 0.0176164576836421
201814 201814 71595 71595 191719 2 0.0145116357809265
201815 201815 71595 71595 192424 1 0.0169785449573914
201816 201816 71595 71595 194994 2 0.0848927247869571
201817 201817 71595 71595 195140 1 0.0106115905983696
201818 201818 71595 71595 197990 2 0.0110834449039543
201819 201819 71595 71595 203715 2 0.0254678174360871
201820 201820 71595 71595 208869 2 0.0196488477330561
201821 201821 71595 71595 230927 1 0.0127339087180436
201822 201822 71595 71595 237667 2 0.0430484685295163
201823 201823 71595 71595 254800 2 0.0519859646506417
201824 201824 71595 71595 256410 2 0.0277876669490918
201825 201825 71595 71595 258902 2 0.0245064187539953
201826 201826 71595 71595 259521 2 0.0245064187539953
201827 201827 71595 71595 259787 2 0.0223367535165676
201828 201828 71595 71595 270296 2 0.0304398640169167
201829 201829 71595 71595 270900 1 0.0121275321124224
201830 201830 71595 71595 274355 2 0.0176587541615323
201831 201831 71595 71595 275028 1 0.0141487874644929
201832 201832 71595 71595 276349 2 0.0198266689840923
201833 201833 71595 71595 288143 1 0.0141487874644929
201834 201834 71595 71595 288201 1 0.0134041144400459
201835 201835 71595 71595 291669 2 0.0154421325504315
201836 201836 71595 71595 310173 2 0.0106208140599965
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 1397.282ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website