# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-03T03:42:19+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 'Mineralogical Magazine (1969-)') AND volume = 38 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
"1535701","6.954","","8.637","","5.771","","90","","104.93","","90","","334.915","","","","","","","","","","","","","4","P 1 21/m 1","-P 2yb","11","","Y2 (W4 O14) (O H)2 (H2 O)2","","- H6 O18 W4 Y2 -","- O18 W4 Y2 -","- O18 W4 Y2 -","1","0.25","","Davis, R.J.; Smith, G.W.","Yttrotungstite","Mineralogical Magazine (1969-)","1971","38","","261","285","","","","","","","","","","","","","","","","","","","","","","has coordinates","163148","2020-10-21","18:00:00",""
"9009443","11.42","","5.09","","21.95","","90","","90","","90","","1275.91","","","","","","","","","","","","Kilchoan, Ardnamurchan, Scotland","3","I 2 c m","I -2c 2","46","","","Kilchoanite","- Ca3 O7 Si2 -","- Ca3 O7 Si2 -","- Ca24 O56 Si16 -","8","1","","Taylor, H. F. W.","The crystal structure of kilchoanite, Ca6(SiO4)(Si3O10), with some comments on related phases","Mineralogical Magazine","1971","38","","26","31","10.1180/minmag.1971.038.293.03","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009444","6.954","","8.637","","5.771","","90","","104.93","","90","","334.915","","","","","","","","","","","","Kinta district, Perak, Malaysia","18","P 1 21/m 1","-P 2yb","11","","","Yttrotungstite-(Y)","- Al0.1 Ca0.04 Ce0.08 Dy0.05 Er0.04 Fe0.02 Gd0.04 H3 La0.01 Mg0.03 Nd0.09 O9 Pr0.01 Si0.04 Sm0.03 Tb0.01 W1.84 Y0.57 -","- Al0.1 Ca0.04 Ce0.08 Dy0.05 Er0.04 Fe0.02 Gd0.04 H3 La0.01 Mg0.03 Nd0.09 O9 Pr0.01 Si0.04 Sm0.03 Tb0.01 W1.84 Y0.57 -","- Al0.2 Ca0.08 Ce0.16 Dy0.1 Er0.08 Fe0.04 Gd0.08 H6 La0.02 Mg0.06 Nd0.18 O18 Pr0.02 Si0.08 Sm0.06 Tb0.02 W3.68 Y1.14 -","2","0.5","","Davis R J; Smith G W","Yttrotungstite","Mineralogical Magazine","1971","38","","261","285","10.1180/minmag.1971.038.295.01","","","","","","","","","","","","","","","","","","","","","has coordinates","283868","2023-05-18","14:40:10",""
"9009445","3.12","","3.12","","37.4","","90","","90","","120","","315.291","","","","","","","","","","","","New Idria serpentinite, Coalinga, California, USA","6","R -3 m :H","-R 3 2""","166","","","Coalingite","- C0.03 H7.64 Fe0.11 Mg0.87 Mn0.02 O2.48 -","- C0.03 H2.66 Fe0.11 Mg0.87 Mn0.02 O2.48 -","- C0.18 H15.96 Fe0.66 Mg5.22 Mn0.12 O14.88 -","6","0.166667","","Pastor-Rodriguez J; Taylor, H. F. W.","Crystal structure of coalingite Note: occupancies altered to match formula","Mineralogical Magazine","1971","38","","286","294","10.1180/minmag.1971.038.295.02","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:10",""
"9009446","10.448","","5.282","","11.208","","90","","116.73","","90","","552.43","","","","","","","","","","","","Salmo, British Columbia, Canada","4","P 1 2/c 1","-P 2yc","13","","","Spencerite","- H8 O13 P2 Zn4 -","- H8 O13 P2 Zn4 -","- H16 O26 P4 Zn8 -","2","0.5","","Fanfani, L.; Nunzi, A.; Zanazzi, P. F.","Structure and twinning in spencerite","Mineralogical Magazine","1972","38","","687","692","10.1180/minmag.1972.038.298.05","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9011792","9.08","","16.37","","5.62","","90","","90","","90","","835.355","","","","","","","","","","","","Gonnesa, Sardinia, Italy","5","P b n m","-P 2c 2ab","62","","","Dundasite","- C2 H6 Al2 O11 Pb -","- C2 H6 Al2 O11 Pb -","- C8 H24 Al8 O44 Pb4 -","4","0.5","","Cocco, G.; Fanfani, L.; Nunzi, A.; Zanazzi, P. F.","The crystal structure of dundasite","Mineralogical Magazine","1972","38","","564","569","10.1180/minmag.1972.038.297.04","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""