# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-01-05T00:43:21+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 'Mineralogical Journal') AND volume = 7 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
"1544675","8.496","0.002","9.983","0.002","16.755","0.003","90","","90","","90","","1421.1","0.5","","","","","","","","","","","","5","I b a m","-I 2 2c","72","BaNa2Al4Si4O16","","banalsite","- Al4 Ba Na2 O16 Si4 -","- Al4 Ba Na2 O16 Si4 -","- Al16 Ba4 Na8 O64 Si16 -","4","0.25","","Haga, N.","The crystal structure of banalsite, BaNa2Al4Si4O16, and its relation to the feldspar structure","Mineralogical Journal","1973","7","","262","281","","","","","","","","","","","","","","","","","","","","","","has coordinates","188704","2020-10-21","18:00:00",""
"1544906","4.3992","0.0002","9.4214","0.0007","2.8446","0.0002","90","","90","","90","","117.899","0.013","","","","","","","","","","","","3","P b n m","-P 2c 2ab","62","AlOOH","","natural diaspore","- Al H O2 -","- Al O2 -","- Al4 O8 -","4","0.5","","Iwai, S.; Yamamoto, H.; Morikawa, H.; Isobe, M.","Topotactic thermal-transformation of diaspore to corundum Sample: no heat treatment","Mineralogical Journal","1973","7","","137","158","","","","","","","","","","","","","","","","","","","","","","has coordinates","189464","2020-10-21","18:00:00",""
"9012092","10.553","","18.199","","5.031","","90","","90","","90","","966.224","","","","","","","","","","","","Synthetic","4","P n m a","-P 2ac 2n","62","","","Hopeite","- H8 O12 P2 Zn3 -","- H8 O12 P2 Zn3 -","- H32 O48 P8 Zn12 -","4","0.5","","Kawahara, A.; Takano, Y.; Takahashi, M.","The structure of hopeite","Mineralogical Journal","1973","7","","289","297","10.2465/minerj1953.7.289","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""
"9016285","10.958","","7.778","","7.799","","90","","100.9","","90","","652.727","","","","","","","","","","","","Ohmi District, Niigata Prefecture, Central Japan","5","P 1 21/m 1","-P 2yb","11","","","Ohmilite","- H5 O15 Si4 Sr3 Ti -","- H5 O15 Si4 Sr3 Ti -","- H10 O30 Si8 Sr6 Ti2 -","2","0.5","","Mizota, T.; Komatsu, M.; Chihara, K.","On the crystal structure of Sr3TiSi4O12(OH)*2H2O, a new mineral Note: paper is missing data for O8","Mineralogical Journal","1973","7","","302","305","10.2465/minerj1953.7.302","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:52",""