Database fields in table main

Site location and characteristics

rec_no
Record ID
(Sample identification)
Database record identifier
country
Country
(Geographic location)
Name of country in which the deposit occurs
stprov
State or province
(Geographic location)
State or province where the deposit occurs
county
County
(Geographic location)
Third order political subdivision containing the deposit, such as a county
location
Location description
(Geographic location)
General description of the location
site_name
Site name
(Site identification)
Name or names by which the site is known
commodity
Commodities
(Site characteristics)
List of commodities present at the site
analytical
Analytical data
(Site characteristics)
Physical, chemical, or mineralogical analyses describing materials at the site
latitude
Latitude
(Geographic location)
Geographic latitude in decimal degrees, WGS84
longitude
Longitude
(Geographic location)
Geographic longitude in decimal degrees, WGS84
loc_comm
Comments on location
(Geographic location)
General comments on the location or how well we know it
disc_yr
Discovery year
(Site characteristics)
Year in which the deposit was discovered
prod
Production
(Site characteristics)
General characteristics of production at the site
ann_prod
Annual production
(Site characteristics)
Annual production at the site in millions of metric tons of ore
cum_prod
Cumulative production
(Site characteristics)
Cumulative production at the site in millions of metric tons of ore
min_method
Mining methods
(Site characteristics)
Methods by which materials are extracted from the site
resources
Resource estimates
(Site characteristics)
Estimates of the mineral endowment
company
Company name
(Site characteristics)
Name of the company associated with the site as operator, owner, or both
dep_type
Deposit type
(Site characteristics)
General type of deposit
sub_type
Deposit subtype
(Site characteristics)
Specific subtype of deposit; form or style of mineralization
min_age_g
Mineralization age (general)
(Site characteristics)
General age of mineralization
min_age_s
Mineralization age (specific)
(Site characteristics)
Specific age of mineralization
host_age
Host rock age
(Site characteristics)
Age of associated magmatism or host rocks
host_lith
Host rock lithology
(Site characteristics)
Lithologic description of host or associated rocks
host_unit
Host rock unit
(Site characteristics)
Host rock formation or complex name
minerals
Minerals present
(Site characteristics)
Major minerals present at the site
descript
Description
(Site characteristics)
Geologic comments or description of the deposit
age_ref
Age references
(Bibliographic reference)
Bibliographic references (short citations) providing information about the age of the deposit.
comments
Comments
(Site characteristics)
General comments on the deposit or our knowledge of it
loc_ref
Location references
(Bibliographic reference)
Bibliographic references (short citations) providing information about the location of the deposit.
ref
General references
(Bibliographic reference)
Bibliographic references (short citations) providing general information about the site or deposit.
mas_id
MAS/MILS ID number
(Metadata)
Record number of the same site as described in the MAS/MILS database
mrds_id
MRDS ID number
(Metadata)
Record number of the same site as described in MRDS