# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-11T22:49:10+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 = 39 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
"1008753","10.01","","10.01","","8.405","","90","","90","","120","","729.4","","","","","","","","","","","","","5","P 63","P 6c","173","","Potassium trisodium tetraaluminium silicate","Nepheline","- Al4 K Na3 O16 Si4 -","- Al4 K Na3 O16 Si4 -","- Al8 K2 Na6 O32 Si8 -","2","0.333333","","Buerger, M J; Klein, G E; Donnay, G","Determination of the crystal structure of nepheline","American Mineralogist","1954","39","","805","818","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1535068","5.33","","9.18","","28.89999","","90","","97","","90","","1403.52","","","","","","","","","","","","","6","C 1 2/c 1","-C 2yc","15","","(Mg2.36 Fe0.48 Al0.16) Mg0.32 (Al1.28 Si2.72 O10) (O H)2 (H2 O)4.32","","- Al1.44 Fe0.48 H10.64 Mg2.68 O16.32 Si2.72 -","- Al1.4402 Fe0.48 Mg2.6799 O16.32 Si2.72 -","- Al5.7608 Fe1.92 Mg10.7196 O65.28 Si10.88 -","4","0.5","","Mathieson, A.M.; Walker, G.F.","Crystal structure of magnesium-vermiculite","American Mineralogist","1954","39","","231","255","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000060","5.33","","9.18","","28.9","","90","","97","","90","","1403.52","","","","","","","","","","","","","6","C 1 c 1","C -2yc","9","","","Vermiculite","- Al0.721 Fe0.24 H3 Mg1.338 O9 Si1.36 -","- Al0.721 Fe0.24 H3 Mg1.338 O9 Si1.36 -","- Al2.884 Fe0.96 H12 Mg5.352 O36 Si5.44 -","4","1","","Mathieson, A. M.; Walker, G. F.","Crystal structure of magnesium-vermiculite","American Mineralogist","1954","39","","231","255","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000061","11.44","","14.12","","3.76","","90","","90","","90","","607.363","","","","","","","","","","","","","3","P n a m","-P 2c 2n","62","","","Berthierite","- Fe S4 Sb2 -","- Fe S4 Sb2 -","- Fe4 S16 Sb8 -","4","0.5","","Buerger, M. J.; Hahn, T.","The crystal structure of berthierite, FeSb2S4","American Mineralogist","1954","39","","319","319","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000062","3.796","","3.796","","16.36","","90","","90","","120","","204.158","","","","","","","","","","","","Leonard mine, Butte, Montana, USA","2","P 63/m m c","-P 6c 2c","194","","","Covellite","- Cu S -","- Cu S -","- Cu6 S6 -","6","0.25","","Berry, L. G.","The crystal structure of covellite, CuS and klockmannite, CuSe","American Mineralogist","1954","39","","504","509","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000063","3.938","","3.938","","17.25","","90","","90","","120","","231.671","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","","Klockmannite","- Cu Se -","- Cu Se -","- Cu6 Se6 -","6","0.25","","Berry, L. G.","The crystal structure of covellite, CuS and klockmannite, CuSe","American Mineralogist","1954","39","","504","509","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""