# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T06:20:57+02:00
# Query:
# SELECT data.*
# FROM
#  data JOIN jaltnames
#  ON altname = journal
# WHERE
#  (status is null or status != 'retracted') and
#  (journal_id IN (SELECT DISTINCT(journal_id) FROM jaltnames WHERE altname LIKE 'American Mineralogist') AND volume = 45 AND duplicateof IS NULL AND (status is NULL OR status != 'errors') AND (method is NULL OR method != 'theoretical'))
# ORDER BY file asc
file,a,siga,b,sigb,c,sigc,alpha,sigalpha,beta,sigbeta,gamma,siggamma,vol,sigvol,celltemp,sigcelltemp,diffrtemp,sigdiffrtemp,cellpressure,sigcellpressure,diffrpressure,sigdiffrpressure,thermalhist,pressurehist,compoundsource,nel,sg,sgHall,sgNumber,commonname,chemname,mineral,formula,calcformula,cellformula,Z,Zprime,acce_code,authors,title,journal,year,volume,issue,firstpage,lastpage,doi,method,radiation,wavelength,radType,radSymbol,Rall,Robs,Rref,wRall,wRobs,wRref,RFsqd,RI,gofall,gofobs,gofgt,gofref,duplicateof,optimal,status,flags,svnrevision,date,time,onhold
"1535420","21.14","","23.45999","","4.035","","90","","90","","90","","2001.14","","","","","","","","","","","","","3","P b n m","-P 2c 2ab","62","","Pb9 Sb9 S22","","- Pb9 S22 Sb9 -","- Pb9 S22 Sb9 -","- Pb18 S44 Sb18 -","2","0.25","","Born, L.; Hellner, E.","A structural proposal for boulangerite","American Mineralogist","1960","45","","1266","1271","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00",""
"1539166","4.2716","","4.2716","","3.7067","","90","","90","","90","","67.635","","","","","","","","","","","","","2","P 4/m m m","-P 4 2","123","","","","- Hg Pd -","- Hg Pd -","- Hg2 Pd2 -","2","0.125","","Terada, K.; Cagle, F.W.jr.","Crystal structure of potarite, Pd Hg, with comments on allopalladium","American Mineralogist","1960","45","","1093","1097","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"9000087","13.61","","5.62","","11.63","","90","","113.47","","90","","815.964","","","","","","","","","","","","","12","C 1 2/m 1","-C 2y","12","","","Perrierite-(Ce)","- Al0.16 Ca0.872 Ce2.312 Fe0.87 La0.5 Mg0.24 Na0.312 O22 Si3.84 Th0.192 Ti3.48 Y0.16 -","- Al0.16 Ca0.872 Ce2.312 Fe0.87 La0.5 Mg0.24 Na0.312 O22 Si3.84 Th0.192 Ti3.48 Y0.16 -","- Al0.32 Ca1.744 Ce4.624 Fe1.74 La Mg0.48 Na0.624 O44 Si7.68 Th0.384 Ti6.96 Y0.32 -","2","0.25","","Gottardi, G.","The crystal structure of perrierite","American Mineralogist","1960","45","","1","14","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000088","3.549","","3.549","","3.549","","90","","90","","90","","44.701","","","","","","","","","","","","Lord Brassey mine, Heazlewood, Tasmania","3","F m -3 m","-F 4 2 3","225","","","Awaruite","- Co0.027 Fe0.283 Ni0.689 -","- Co0.027 Fe0.283 Ni0.689 -","- Co0.108 Fe1.132 Ni2.756 -","4","0.0208333","","Williams, K. L.","An association of awaruite with heazlewoodite","American Mineralogist","1960","45","","450","453","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000089","3.545","","3.545","","3.545","","90","","90","","90","","44.55","","","","","","","","","","","","Awarua Bay, New Zealand","3","F m -3 m","-F 4 2 3","225","","","Awaruite","- Co0.027 Fe0.283 Ni0.689 -","- Co0.027 Fe0.283 Ni0.689 -","- Co0.108 Fe1.132 Ni2.756 -","4","0.0208333","","Williams, K. L.","An association of awaruite with heazlewoodite","American Mineralogist","1960","45","","450","453","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000090","3.553","","3.553","","3.553","","90","","90","","90","","44.852","","","","","","","","","","","","Eastern Townships, Quebec, USA","4","F m -3 m","-F 4 2 3","225","","","Awaruite","- Co0.039 Cu0.003 Fe0.262 Ni0.695 -","- Co0.039 Cu0.003 Fe0.262 Ni0.695 -","- Co0.156 Cu0.012 Fe1.048 Ni2.78 -","4","0.0208333","","Williams, K. L.","An association of awaruite with heazlewoodite","American Mineralogist","1960","45","","450","453","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000091","12.17","","2.99","","4.83","","90","","98.25","","90","","173.937","","","","","","","","","","","","","2","C 1 2/m 1","-C 2y","12","","","Haggite","- O5 V2 -","- O5 V2 -","- O10 V4 -","2","0.25","","Evans, H. T.; Mrose, M. E.","A crystal chemical study of the vanadium oxide minerals, haggite and doloresite","American Mineralogist","1960","45","","1144","1166","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000092","19.64","","2.99","","4.83","","90","","103.92","","90","","275.305","","","","","","","","","","","","","2","C 1 2/m 1","-C 2y","12","","","Doloresite","- O8 V3 -","- O8 V3 -","- O16 V6 -","2","0.25","","Evans, H. T.; Mrose, M. E.","A crystal chemical study of the vanadium oxide minerals, haggite and doloresite","American Mineralogist","1960","45","","1144","1166","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000093","42.28","","23.46","","8.07","","90","","90","","90","","8004.54","","","","","","","","","","","","Pribram, Bohemia","3","B b 21 m","B -2 -2b","36","","","Boulangerite","- Pb4.5 S11 Sb4.5 -","- Pb4.5 S11 Sb4.5 -","- Pb36 S88 Sb36 -","8","1","","Born, L.; Hellner, E.","A structural proposal for boulangerite","American Mineralogist","1960","45","","1266","1271","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""