Database fields, all categories

Sample identification
idUnique record identifier
labnoUnique identification number assigned by the laboratory
fieldField number assigned by the submitter designated in the "name" field.
Geographic location
stateState in which the sample was collected.
countyCounty in which the sample was collected.
latitudeNorth latitude of sample site reported in decimal degrees. (NAD27, Clarke 1866)
longitudeLongitude of sample site reported in decimal degrees. Longitudes up to 180 degrees west are reported in negative decimal degrees. Longitudes up to 180 degrees east are reported in positive decimal degrees. (NAD27, Clarke 1866)
Processing information
jobnLaboratory job number assigned by the analytical laboratory. One job number may contain from one to a few hundred samples.
nameName of person who sumbitted the sample to the laboratory for chemical analysis.
sub__dateDate the sample was submitted for analysis
toaType of analysis (Chemical method by which the sample was analyzed)
Sample characteristics
matCategory of sample material
descriptn_Description of the sample material provided by the submitter, indicating any distinguishing characteristics.
b12Character of sample
b13Source of sample
b20Nature of material
b21Modifier for the material category given in field B20
b23Environment of deposition
b22Modifier for the material category given in field B20
Chemical analysis
q_feQuality indicator for analysis of Fe
fe_ppmIron concentration in parts per million (ppm)
q_mgQuality indicator for analysis of Mg
mg_ppmMagnesium concentration in parts per million (ppm)
q_caQuality indicator for analysis of Ca
ca_ppmCalcium concentration in parts per million (ppm)
q_tiQuality indicator for analysis of Ti
ti_ppmTitanium concentration in parts per million (ppm)
q_bQuality indicator for analysis of B
b_ppmBoron concentration in parts per million
q_baQuality indicator for analysis of Ba
ba_ppmBarium concentration in parts per million (ppm)
q_coQuality indicator for analysis of Co
co_ppmCobalt concentration in parts per million (ppm)
q_crQuality indicator for analysis of Cr
cr_ppmChromium concentration in parts per million (ppm)
q_cuQuality indicator for analysis of Cu
cu_ppmCopper concentration in parts per million (ppm)
q_laQuality indicator for analysis of La
la_ppmLanthanum concentration in parts per million
q_niQuality indicator for analysis of Ni
ni_ppmNickel concentration in parts per million (ppm)
q_pbQuality indicator for analysis of Pb
pb_ppmLead concentration in parts per million (ppm)
q_srQuality indicator for analysis of Sr
sr_ppmStrontium concentration in parts per million
q_vQuality indicator for analysis of V
v_ppmVanadium concentration in parts per million (ppm)
q_yQuality indicator for analysis of Y
y_ppmYttrium concentration in parts per million (ppm)
q_zrQuality indicator for analysis of Zr
zr_ppmZirconium concentration in parts per million (ppm)
q_siQuality indicator for analysis of Si
si_ppmSilicon concentration in parts per million (ppm)
q_alQuality indicator for analysis of Al
al_ppmAluminum concentration in parts per million (ppm)
q_naQuality indicator for analysis of Na
na_ppmSodium concentration in parts per million (ppm)
q_kQuality indicator for analysis of K
k_ppmPotassium concentration in parts per million (ppm)
q_beQuality indicator for analysis of Be
be_ppmBeryllium concentration in parts per million
q_agQuality indicator for analysis of Ag
ag_ppmSilver concentration in parts per million (ppm)
q_asQuality indicator for analysis of As
as_ppmArsenic concentration in parts per million
q_auQuality indicator for analysis of Au
au_ppmGold concentration in parts per million
q_biQuality indicator for analysis of Bi
bi_ppmBismuth concentration in parts per million (ppm)
q_cdQuality indicator for analysis of Cd
cd_ppmCadmium concentration in parts per million (ppm)
q_moQuality indicator for analysis of Mo
mo_ppmMolybdenum concentration in parts per million (ppm)
q_nbQuality indicator for analysis of Nb
nb_ppmNiobium concentration in parts per million (ppm)
q_sbQuality indicator for analysis of Sb
sb_ppmAntimony concentration in parts per million (ppm)
q_snQuality indicator for analysis of Sn
sn_ppmTin concentration in parts per million (ppm)
q_teQuality indicator for analysis of Te
te_ppmTellurium concentration in parts per million (ppm)
q_wQuality indicator for analysis of W
w_ppmTungsten concentration in parts per million (ppm)
q_znQuality indicator for analysis of Zn
zn_ppmZinc concentration in parts per million (ppm)
q_pQuality indicator for analysis of P
p_ppmPhosphorus concentration in parts per million (ppm)
q_ceQuality indicator for analysis of Ce
ce_ppmCerium concentration in parts per million (ppm)
q_liQuality indicator for analysis of Li
li_ppmLithium concentration in parts per million (ppm)
q_tlQuality indicator for analysis of Tl
tl_ppmThallium concentration in parts per million (ppm)
q_hgQuality indicator for analysis of Hg
hg_ppmMercury concentration in parts per million (ppm)
q_seQuality indicator for analysis of Se
se_ppmSelenium concentration in parts per million (ppm)
q_thQuality indicator for analysis of Th
th_ppmThorium concentration in parts per million (ppm)
q_uQuality indicator for analysis of U
u_ppmUranium concentration in parts per million (ppm)
q_sQuality indicator for analysis of S
s_ppmSulfur concentration in parts per million (ppm)
q_pdQuality indicator for analysis of Pd
pd_ppmPaladium concentration in parts per million (ppm)
q_ptQuality indicator for analysis of Pt
pt_ppmPlatinum concentration in parts per million (ppm)
q_rhQuality indicator for analysis of Rh
rh_ppmRhodium concentration in parts per million (ppm)
q_ruQuality indicator for analysis of Ru
ru_ppmRuthenium concentration in parts per million (ppm)
q_org_cQuality indicator for analysis of Organic C
org_c_ppmOrganic carbon concentration in parts per million (ppm)
q_feoQuality indicator for analysis of FeO
feo_ppmFerrous iron oxide concentration in parts per million (ppm)
q_fQuality indicator for analysis of F
f_ppmFluorine concentration in parts per million (ppm)
q_rbQuality indicator for analysis of Rb
rb_ppmRubidium concentration in parts per million (ppm)