# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-22T14:43:17+01: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 = 42 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
"1538022","5.38","","5.38","","10.76","","90","","90","","90","","311.442","","","","","","","","","","","","","3","I -4 2 m","I -4 2","121","","Cu3 (Sb S4)","","- Cu3 S4 Sb -","- Cu3 S4 Sb -","- Cu6 S8 Sb2 -","2","0.125","","Gaines, V.","Luzonite, famatinite and some related minerals","American Mineralogist","1957","42","","766","779","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000077","3.47","","3.47","","34.5","","90","","90","","120","","359.757","","","","","","","","","","","","","2","R -3 m :H","-R 3 2""","166","","","Smythite","- Fe3 S4 -","- Fe3 S4 -","- Fe9 S12 -","3","0.0833333","","Erd, R. C.; Evans, H. T.; Richter, D. H.","Smythite, a new iron sulfide, and associated pyrrhotite from Indiana","American Mineralogist","1957","42","","309","333","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000078","15.97","","7.07","","6.68","","90","","97.3","","90","","748.111","","","","","","","","","","","","Chinkolobwe deposits, Belgian Congo, Africa","5","P 1 21 1","P 2yb","4","","","Uranophane - alpha","- Ca H12 O17 Si2 U2 -","- Ca O12 Si2 U2 -","- Ca2 O24 Si4 U4 -","2","1","","Smith, D. K.; Gruner, J. W.; Lipscomb, W. N.","The crystal structure of uranophane [Ca(H3O)2](UO2)2(SiO4)2.3H2O","American Mineralogist","1957","42","","594","618","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""