# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2026-03-11T01:46:14+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 'The Canadian Mineralogist') AND volume = 23 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 "1530595","12.197","","9.156","","10.667","","90","","96.77","","90","","1182.94","","","","","","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","Cu5 Zn (O H)6 (H2 O) (P O4)2","","- Cu5 H8 O15 P2 Zn -","- Cu5 O15 P2 Zn -","- Cu20 O60 P8 Zn4 -","4","1","","Piret, P.; Deliens, M.; Piret-Meunier, J.","Occurrence and Crystal Structure of Kipushite, a New Copper-Zinc Phosphate from Kipushi, Zaire","Canadian Mineralogist","1985","23","","35","42","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1539549","7.3055","","7.3055","","33.675","","90","","90","","120","","1556.46","","","","","","","","","","","","","5","R -3 m :H","-R 3 2""","166","","Pb (Fe3 (O H)6 (S O4)2)2","","- Fe6 H12 O28 Pb S4 -","- Fe6 H12 O28 Pb S4 -","- Fe18 H36 O84 Pb3 S12 -","3","0.0833333","","Szymanski, J.T.","The Crystal Structures of Plumbojarosite PB(Fe3 (SO4)2(OH)6)2","Canadian Mineralogist","1985","23","","659","668","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "9004175","11.836","","12.94","","6.735","","90","","90","","90","","1031.52","","","","","","","","","","","","","6","P 21 n b","P -2bc 2a","33","","","Georgechaoite","- H4 K Na O11 Si3 Zr -","- H4 K Na O11 Si3 Zr -","- H16 K4 Na4 O44 Si12 Zr4 -","4","1","","Ghose, S.; Thakur, P.","The crystal structure of georgechaoite NaKZrSi3O9.2H2O","The Canadian Mineralogist","1985","23","","5","10","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004176","11.74","","12.82","","6.691","","90","","90","","90","","1007.04","","","","","","","","","","","","Mont St. Hilaire, Quebec, Canada","5","P 21 n b","P -2bc 2a","33","","","Gaidonnayite","- H4 Na2 O11 Si3 Zr -","- H4 Na2 O11 Si3 Zr -","- H16 Na8 O44 Si12 Zr4 -","4","1","","Chao, G. Y.","The crystal structure of gaidonnayite Na2ZrSi3O9.2H2O","The Canadian Mineralogist","1985","23","","11","15","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:36","" "9004177","12.197","","9.156","","10.667","","90","","96.77","","90","","1182.94","","","","","","","","","","","","Kipushi, Zaire","5","P 1 21/c 1","-P 2ybc","14","","","Kipushite","- Cu2.92 H7 O15 P2 Zn2.08 -","- Cu2.92 H7 O15 P2 Zn2.08 -","- Cu11.68 H28 O60 P8 Zn8.32 -","4","1","","Piret, P.; Deliens, M.; Piret-Meunier J","Occurrence and crystal structure of kipushite, a new copper-zinc phosphate from Kipushi, Zaire","The Canadian Mineralogist","1985","23","","35","42","","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:20","" "9004178","3.2494","","3.2494","","5.2038","","90","","90","","120","","47.584","","","","293","","","","","","","","","2","P 63 m c","P 6c -2c","186","","","Zincite","- O Zn -","- O Zn -","- O2 Zn2 -","2","0.166667","","Kihara, K.; Donnay, G.","Anharmonic thermal vibrations in ZnO Model: 2-c, at T = 293 K","The Canadian Mineralogist","1985","23","","647","654","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004179","3.2533","","3.2533","","5.2073","","90","","90","","120","","47.73","","","","473","","","","","","","","","2","P 63 m c","P 6c -2c","186","","","Zincite","- O Zn -","- O Zn -","- O2 Zn2 -","2","0.166667","","Kihara, K.; Donnay, G.","Anharmonic thermal vibrations in ZnO Model: 2-c, at T = 473 K","The Canadian Mineralogist","1985","23","","647","654","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004180","3.2494","","3.2494","","5.2038","","90","","90","","120","","47.584","","","","293","","","","","","","","","2","P 63 m c","P 6c -2c","186","","","Zincite","- O Zn -","- O Zn -","- O2 Zn2 -","2","0.166667","","Kihara, K.; Donnay, G.","Anharmonic thermal vibrations in ZnO Model: 3-c, at T = 293 K","The Canadian Mineralogist","1985","23","","647","654","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004181","3.2533","","3.2533","","5.2073","","90","","90","","120","","47.73","","","","473","","","","","","","","","2","P 63 m c","P 6c -2c","186","","","Zincite","- O Zn -","- O Zn -","- O2 Zn2 -","2","0.166667","","Kihara, K.; Donnay, G.","Anharmonic thermal vibrations in ZnO Model: 3-c, at T = 473 K","The Canadian Mineralogist","1985","23","","647","654","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004182","7.3055","","7.3055","","33.675","","90","","90","","120","","1556.46","","","","","","","","","","","","","5","R -3 m :H","-R 3 2""","166","","","Plumbojarosite","- Fe3 H6 O14 Pb S2 -","- Fe3 H6 O14 Pb S2 -","- Fe18 H36 O84 Pb6 S12 -","6","0.166667","","Szymanski, J. T.","The crystal structure of plumbojarosite Pb[Fe3(SO4)2(OH)6]2","The Canadian Mineralogist","1985","23","","659","668","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41","" "9004183","11.126","","8.242","","5.539","","90","","100.84","","90","","498.866","","","","","","","","","","","","","5","P 1 21/a 1","-P 2yab","14","","","Blodite","- H8 Mg Na2 O12 S2 -","- H8 Mg Na2 O12 S2 -","- H16 Mg2 Na4 O24 S4 -","2","0.5","","Hawthorne, F. C.","Refinement of the crystal structure of bloedite: Structural similarities in the [M(T_4)2_n] finite-cluster minerals","The Canadian Mineralogist","1985","23","","669","674","","","","","","","","","","","","","","","","","","","","","","has coordinates","303136","2025-11-01","12:31:43","" "9004184","8.924","","10.016","","9.103","","59.91","","112.41","","81.69","","590.76","","","","","","","","","","","","","3","P -1","-P 1","2","","","Schneiderhohnite","- As5 Fe4 O13 -","- As5 Fe4 O13 -","- As10 Fe8 O26 -","2","1","","Hawthorne, F. C.","Schneiderhohnite, (Fe2+)(Fe3+)3As5O13, a densely packed arsenite structure","The Canadian Mineralogist","1985","23","","675","679","","","","","","","","","","","","","","","","","","","","","","has coordinates","291351","2024-04-25","15:50:41",""