cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
483,388 rows
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 1 | 1 1 | 6210 6210 |
| 2 | 2 2 | 101901 101901 |
| 3 | 3 3 | 75314 75314 |
| 4 | 4 4 | 6859 6859 |
| 5 | 5 5 | 29879 29879 |
| 6 | 6 6 | 6790 6790 |
| 7 | 7 7 | 3684 3684 |
| 8 | 8 8 | 13640 13640 |
| 9 | 9 9 | 90489 90489 |
| 10 | 10 10 | 16367 16367 |
| 11 | 11 11 | 6211 6211 |
| 12 | 12 12 | 6217 6217 |
| 13 | 13 13 | 25839 25839 |
| 14 | 14 14 | 84592 84592 |
| 15 | 15 15 | 2030 2030 |
| 16 | 16 16 | 42441 42441 |
| 17 | 17 17 | 84286 84286 |
| 18 | 18 18 | 26542 26542 |
| 19 | 19 19 | 83564 83564 |
| 20 | 20 20 | 27035 27035 |
| 21 | 21 21 | 10956 10956 |
| 22 | 22 22 | 76866 76866 |
| 23 | 23 23 | 76375 76375 |
| 24 | 24 24 | 76118 76118 |
| 25 | 25 25 | 220845 220845 |
| 26 | 26 26 | 27941 27941 |
| 27 | 27 27 | 34973 34973 |
| 28 | 28 28 | 14826 14826 |
| 29 | 29 29 | 262283 262283 |
| 30 | 30 30 | 32259 32259 |
| 31 | 31 31 | 53005 53005 |
| 32 | 32 32 | 74053 74053 |
| 33 | 33 33 | 55055 55055 |
| 34 | 34 34 | 7470 7470 |
| 35 | 35 35 | 60357 60357 |
| 36 | 36 36 | 49267 49267 |
| 37 | 37 37 | 3125 3125 |
| 38 | 38 38 | 6869 6869 |
| 39 | 39 39 | 97062 97062 |
| 40 | 40 40 | 101991 101991 |
| 41 | 41 41 | 11222 11222 |
| 42 | 42 42 | 238322 238322 |
| 43 | 43 43 | 106395 106395 |
| 44 | 44 44 | 119305 119305 |
| 45 | 45 45 | 199795 199795 |
| 46 | 46 46 | 31531 31531 |
| 47 | 47 47 | 31531 31531 |
| 48 | 48 48 | 49562 49562 |
| 49 | 49 49 | 108183 108183 |
| 50 | 50 50 | 106253 106253 |
| 51 | 51 51 | 119211 119211 |
| 52 | 52 52 | 64734 64734 |
| 53 | 53 53 | 123759 123759 |
| 54 | 54 54 | 134368 134368 |
| 55 | 55 55 | 3325 3325 |
| 56 | 56 56 | 3128 3128 |
| 57 | 57 57 | 35364 35364 |
| 58 | 58 58 | 63046 63046 |
| 59 | 59 59 | 74052 74052 |
| 60 | 60 60 | 91288 91288 |
| 61 | 61 61 | 107688 107688 |
| 62 | 63 63 | 6618 6618 |
| 63 | 64 64 | 8233 8233 |
| 64 | 65 65 | 25481 25481 |
| 65 | 66 66 | 37369 37369 |
| 66 | 67 67 | 74080 74080 |
| 67 | 68 68 | 70844 70844 |
| 68 | 69 69 | 9965 9965 |
| 69 | 70 70 | 10592 10592 |
| 70 | 71 71 | 2811 2811 |
| 71 | 72 72 | 77090 77090 |
| 72 | 74 74 | 47121 47121 |
| 73 | 75 75 | 5822 5822 |
| 74 | 76 76 | 111981 111981 |
| 75 | 77 77 | 1299 1299 |
| 76 | 78 78 | 73278 73278 |
| 77 | 79 79 | 12847 12847 |
| 78 | 80 80 | 41457 41457 |
| 79 | 81 81 | 41971 41971 |
| 80 | 82 82 | 68961 68961 |
| 81 | 83 83 | 9594 9594 |
| 82 | 84 84 | 45708 45708 |
| 83 | 85 85 | 73339 73339 |
| 84 | 86 86 | 161135 161135 |
| 85 | 87 87 | 42780 42780 |
| 86 | 88 88 | 76685 76685 |
| 87 | 89 89 | 2834 2834 |
| 88 | 90 90 | 15189 15189 |
| 89 | 91 91 | 198871 198871 |
| 90 | 92 92 | 32583 32583 |
| 91 | 93 93 | 16679 16679 |
| 92 | 94 94 | 16733 16733 |
| 93 | 95 95 | 8092 8092 |
| 94 | 97 97 | 235316 235316 |
| 95 | 98 98 | 123818 123818 |
| 96 | 99 99 | 85239 85239 |
| 97 | 100 100 | 2838 2838 |
| 98 | 101 101 | 2657 2657 |
| 99 | 102 102 | 90468 90468 |
| 100 | 103 103 | 6460 6460 |
CREATE TABLE [cleanventory_chemicals] (
[cleanventory_id] integer PRIMARY KEY,
[inventory_id] integer,
[inchi_id] integer,
FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);