Database fields, all categories

Sample identification
	`id`	Unique record identifier
	`LABNO`	Laboratory sample number assigned by the analytical laboratory.
	`FIELD`	Sample field number assigned by the submitter designated in the NAME field.
	`FULLNAME`	LABNO value concatenated with FIELD value
Geographic location
	`STATE`	The state (or location) in which the sample was collected.
	`COUNTY`	The county in which the sample was collected.
	`LATITUDE`	The latitude of the sample location.
	`LONGITUDE`	The longitude of the sample location. By convention, longitudes west of Greenwich Meridian are negative.
Processing information
	`JOBN`	Laboratory job number assigned by the analytical laboratory. A given job may have between 1 and 40 samples.
	`NAME`	Name of the individual who submitted the samples to the laboratory for analysis.
	`SUB__DATE`	Date that the samples were submitted to the laboratory for analysis (written as YYYYMMDD)
	`METHOD`	Instrument or technique used to analyze sample
Sample characteristics
	`FORMATION`	The name of the stratigraphic unit of formation rank or higher, represented by rock, mineral, or coal samples from the United States, Canada, or Mexico.
	`DESCRIPTIO`	Description of the sample material provided by the submitter, indicating any distinguishing characteristics.
	`CHARACTER_`	Indication of how typical sample is of an area and how it was collected
	`SOURCE`	Type of source material or location
	`AGE`	Age of the sample if known
	`ROCK_FORM`	Type of rock formation from which sample was collected
	`TEXTURE_ST`	Rock texture and structure
	`QTZ_FELDSP`	Relationship between quartz and feldspar in the rock
	`ROCK_NAME`	General rock classification
	`ECON_GEOL`	Mineralization noted by geologist in sample. This field is used to identify samples of ores and (or) related protore, altered material, or other samples of possible economic significance.
Chemical analysis
	`SIO2`	Silicon dioxide concentration (in percent by weight)
	`AL2O3`	Aluminum oxide concentration (in percent by weight)
	`MGO`	Magnesium oxide concentration (in percent by weight)
	`CAO`	Calcium oxide concentration (in percent by weight)
	`NA2O`	Sodium oxide concentration (in percent by weight)
	`K2O`	Potassium oxide concentration (in percent by weight)
	`TIO2`	Titanium dioxide concentration (in percent by weight)
	`P2O5`	Phosphorus pentoxide concentration (in percent by weight)
	`MNO`	Manganese oxide concentration (in percent by weight)
	`FETO3`	Total iron concentration expressed as ferric oxide (in percent by weight)
	`SUM`	Sum of the weight percents of SIO2, AL2O3, MGO, CAO, NA2O, K2O, TIO2, P2O2, MNO, and FETO3
	`FE2O3`	Ferric oxide concentration (in percent by weight)
	`FEO`	Ferrous oxide concentration (in percent by weight)
	`CO2`	Carbon dioxide concentration (in percent by weight)
	`H2O_PLUS`	Water ("Essential" or "Bound" water) in percent by weight. Usually determined as the difference between total water and "moisture" (water lost from the sample on heating at 110 degrees centigrade).
	`H2O_MINUS`	Moisture (water lost from the sample on heating at 110 degrees centigrade) in percent by weight.