The LILY Database

Linking lithology to IODP physical, chemical, and magnetic properties data

During each expedition of the International Ocean Discovery Program and its precursor, the Integrated Ocean Drilling Program (jointly referred to as IODP), vast arrays of data are collected from drill cores. These data, which are accessible from the IODP LIMS (Laboratory Information Management System) database, include physical, chemical, and magnetic properties collected semi‐continuously along cores using automated track systems, as well as a variety of analyses conducted on discrete subsamples taken from the cores. In addition, the lithology of all cores is described based on visual characteristics of the surface of split cores, visual examination of smear slides and thin sections, and compositional or mineralogical information derived from geochemical analyses. We extract basic lithologic information from this complex array of descriptive information and then tie that information to all other measurements. This new database is referred to as LIMS with Lithology (LILY). LILY currently contains over 34 million data from 89 km of core recovered on 42 expeditions conducted 2009–2019. Some uses of LILY include identifying the abundance of different lithologies, finding data from core intervals with a specific lithology, assessing the efficacy of coring systems in different lithologies, or characterizing and analyzing physical, chemical, and magnetic properties based on lithology. We illustrate the use of LILY by computing the grain density by lithology from over 24,000 moisture and density measurements and then use those grain densities, along with the large IODP bulk density dataset, to compute a new high‐resolution porosity dataset with over 3.7 million new porosity estimates.
Childress, L.B., Acton, G.D., Percuoco, V.P. and M. Hastedt. 2024. The LILY database: Linking lithology to IODP physical, chemical, and magnetic properties data. Geochemistry, Geophysics, Geosystems, 25, e2023GC011287.

Access LILY Data on Zenodo

Primary Content (DataLITH)

There are 23 main files of the LILY database, which are organized based on data type and end with '_DataLITH.csv'. Each file contains IODP LIMS data paired with lithology and other metadata. The file prefix gives the type of data. For example, AVS_DataLITH.csv contains the Automated Vane Shear (AVS) shear strength data paired with lithology and other metadata. A list of all data types is given in Supporting Information Table S1 of Childress et al. (2024). There are a total of 23 DataLITH files.

Additional Content

Original Description Files: contains 7,940 .csv files derived from the raw text content of the DESClogik Excel worksheets that was extracted, converted to comma separated value (.csv) format, and put into files with a consistent naming convention, without applying any corrections or conversions to the original text. Each file is the direct extraction of a tab from the DESC workbooks, available at

Core Summary Files: contains one file with Core Summary information, which includes the expedition, site, hole, core, coring type, top and bottom depths drilled, advances and recoveries, time and date of recovery, and the number of sections. These data are further paired with additional metadata (expanded core type, latitude, longitude, and water depth). Coordinates and water depth for each hole are derived from LIMS (and the Janus Web Database at for older expeditions).

Raw Data Files: contains the raw track/discrete dataset downloaded by expedition from IODP LIMS database and placed in folders for each type of data (AVS, CARB, SRM, etc.).

Raw Lithology Files: contains 42 .csv files, with one file for each expedition. This is a metadata-cleaned, compiled by expedition version of lithologic descriptions only from the original DESClogik description files. Each file contains all lithologic description (prefix, principal and suffix, etc.) information for an entire expedition, as it was originally described. These have been transformed to a consistent format and paired with consistent identification information and additional metadata. Headers are normalized across all expeditions and SampleID information is standardized.

Cleaned Lithology Files: CleanLITH contains 42 .csv files. Each file contains all lithologic description (prefix, principal and suffix) information for an entire expedition. The lithologic descriptions have been standardized to a consistent nomenclature using the dictionary given in Support Information Table S4 of Childress et al. (2024). These data are further paired with additional metadata (e.g., degree of consolidation, expanded core type, latitude, longitude, and water depth).

These are not official IODP-JRSO applications and functionality is not guaranteed. User assumes all risk. Questions, comments, concerns, compliments: