# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-12T05:24:13+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 = 32 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
"1008754","10.05","","10.05","","8.38","","90","","90","","120","","733","","","","","","","","","","","","","5","P 63","P 6c","173","","Potassium trisodium tetraalumotetrasilicate","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; Hamburger, G","The structure of nepheline","American Mineralogist","1947","32","","197","197","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"9000032","6.89","","6.89","","6.89","","60.63","","60.63","","60.63","","234.573","","","","","","","","","","","","","6","R -3 m :R","-P 3* 2","166","","","Svanbergite","- Al3 H6 O14 P S Sr -","- Al3 H6 O14 P S Sr -","- Al3 H6 O14 P S Sr -","1","0.0833333","","Pabst, A.","Some computations on svanbergite, woodhouseite and alunite trial C","American Mineralogist","1947","32","","16","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:28",""
"9000033","6.75","","6.75","","6.75","","62.07","","62.07","","62.07","","227.532","","","","","","","","","","","","","6","R -3 m :R","-P 3* 2","166","","","Woodhouseite","- Al3 Ca H6 O14 P S -","- Al3 Ca H6 O14 P S -","- Al3 Ca H6 O14 P S -","1","0.0833333","","Pabst, A.","Some computations on svanbergite, woodhouseite and alunite","American Mineralogist","1947","32","","16","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:28",""
"9000034","7.058","","7.058","","7.058","","59.08","","59.08","","59.08","","243.402","","","","","","","","","","","","","5","R -3 m :R","-P 3* 2","166","","","Alunite","- Al3 H6 K O14 S2 -","- Al3 H6 K O14 S2 -","- Al3 H6 K O14 S2 -","1","0.0833333","","Pabst, A.","Some computations on svanbergite, woodhouseite and alunite","American Mineralogist","1947","32","","16","30","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:28",""
"9000035","3.073","","3.073","","128.17","","90","","90","","120","","1048.19","","","","","","","","","","","","","2","R 3 m :H","R 3 -2""","160","SiC-51R","","","- C17 Si17 -","- C17 Si17 -","- C51 Si51 -","3","0.166667","","Ramsdell, L. S.","Studies on silicon carbide","American Mineralogist","1947","32","","64","82","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000036","3.073","","3.073","","218.65","","90","","90","","120","","1788.16","","","","","","","","","","","","","2","R 3 m :H","R 3 -2""","160","SiC-87R","","","- C29 Si29 -","- C29 Si29 -","- C87 Si87 -","3","0.166667","","Ramsdell, L. S.","Studies on silicon carbide","American Mineralogist","1947","32","","64","82","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000038","8.96","","5.63","","10.2","","90","","115.4","","90","","464.799","","","","","","","","","","","","","6","P 1 21/m 1","-P 2yb","11","","","Epidote","- Al2 Ca2 Fe H O13 Si3 -","- Al2 Ca2 Fe H O13 Si3 -","- Al4 Ca4 Fe2 H2 O26 Si6 -","2","0.5","","Ito, T.","The structure of epidote (HCa2(Al,Fe)Al2Si3O13)","American Mineralogist","1947","32","","309","321","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:28",""
"9000039","6.463","","11.117","","6.234","","90","","90","","90","","447.908","","","","","","","","","","","","","3","P c m n","-P 2n 2ac","62","","","Cubanite","- Cu Fe2 S3 -","- Cu Fe2 S3 -","- Cu4 Fe8 S12 -","4","0.5","","Buerger, M. J.","The crystal structure of cubanite","American Mineralogist","1947","32","","415","425","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000040","12.62","","7.37","","13.99","","90","","103.72","","90","","1264.07","","","","","","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","","Eudidymite","- Be H Na O8 Si3 -","- Be H Na O8 Si3 -","- Be8 H8 Na8 O64 Si24 -","8","1","","Ito, T.","The structure of eudidymite (HNaBeSi3O8) Note: this structure does not make any sense","American Mineralogist","1947","32","","442","453","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""
"9000041","8.21","","18.42","","5.4","","90","","90","","90","","816.632","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","","","- C4 Br N2 O4 -","- C4 Br N2 O4 -","- C16 Br4 N8 O16 -","4","1","","Barney, E.","The structure of diglycine hydrobromide","American Mineralogist","1947","32","","685","685","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""