# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-28T16:59:55+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 'The Canadian Mineralogist') AND volume = 25 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
"1529749","7.455","","8.955","","5.916","","90","","90","","90","","394.949","","","","","","","","","","","","","5","P 21 21 21","P 2ac 2ab","19","","Ca Ni (As O4) (O H)","","- As Ca H Ni O5 -","- As Ca H Ni O5 -","- As4 Ca4 H4 Ni4 O20 -","4","1","","Cesbron, F.; Pillard, F.; Ginderow, D.; Giraud, R.; Pelisson, P.","La nickelaustinite, Ca (Ni, Zn) (As O4) (O H): Nouvelle espece minerale du district Cobalto-Nickelifere de Bou-Azzer, Maroc","Canadian Mineralogist","1987","25","","401","407","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9004190","7.455","","8.955","","5.916","","90","","90","","90","","394.949","","","","","","","","","","","","","9","P 21 21 21","P 2ac 2ab","19","","","Nickelaustinite","- As Ca Co0.04 Cu0.01 H Mg0.06 Ni0.67 O5 Zn0.22 -","- As Ca Co0.04 Cu0.01 H Mg0.06 Ni0.67 O5 Zn0.22 -","- As4 Ca4 Co0.16 Cu0.04 H4 Mg0.24 Ni2.68 O20 Zn0.88 -","4","1","","Cesbron, F. P.; Ginderow, D.; Giraud, R.; Pelisson, P.; Pillard, F.","La nickelaustinite Ca(Ni,Zn)(AsO4)(OH): Nouvelle espece minerale du district cobalto-nickelifere de Bou-Azzer, Maroc Note: signs changed on y-coordinates of O1 and O2","The Canadian Mineralogist","1987","25","","401","407","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41",""
"9004191","8.5714","","12.9646","","7.2217","","90.6","","115.9","","87.7","","721.3","","","","","","","","","","","","","5","C -1","-P 1 (1/2*x+1/2*y,1/2*x-1/2*y,-z)","2","","","Microcline","- Al K0.95 Na0.05 O8 Si3 -","- Al K0.95 Na0.05 O8 Si3 -","- Al4 K3.8 Na0.2 O32 Si12 -","4","","","Blasi, A.; De Pol Blasi, C.; Zanazzi, P. F.","A re-examination of the Pellotsalo microcline: Mineralogical implications and genetic considerations","The Canadian Mineralogist","1987","25","","527","537","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41",""
"9004192","10.253","","10.253","","13.503","","90","","90","","120","","1229.31","","","","","","","","","","","","Mont Saint-Hilaire, Quebec, Canada","5","P 6/m c c","-P 6 2c","192","","","Poudretteite","- B3 K Na2 O30 Si12 -","- B3 K Na2 O30 Si12 -","- B6 K2 Na4 O60 Si24 -","2","0.0833333","","Grice, J. D.; Ercit, T. S.; Van Velthuizen, J.; Dunn, P. J.","Poudretteite, KNa2B3Si12O30, a new member of the osumilite group from Mont Saint-Hilaire, Quebec, and its crystal structure","The Canadian Mineralogist","1987","25","","763","766","","","","","","","","","","","","","","","","","","","","","","has coordinates","288653","2024-01-03","17:00:04",""
"9004193","7.13","","7.43","","12.479","","94.3","","102.1","","82.7","","640.363","","","","","","","","","","","","","6","P -1","-P 1","2","","","Ehrleite","- Be Ca2 H9 O16 P3 Zn -","- Be Ca2 H9 O16 P3 Zn -","- Be2 Ca4 H18 O32 P6 Zn2 -","2","1","","Hawthorne, F. C.; Grice, J. D.","The crystal structure of ehrleite, a tetrahedral sheet structure","The Canadian Mineralogist","1987","25","","767","774","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:36",""