# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T13:56:00+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 'Australian Journal of Mineralogy') 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
"9013156","4.961","","12.181","","18.974","","90","","90.96","","90","","1146.44","","","","","","","","","","","","Great Australia mine, Concurry, Queensland, Australia","8","P 1 21/c 1","-P 2ybc","14","","","Cloncurryite","- Al3.96 Cu1.12 F2 Fe0.04 H28 O28.72 P4 V0.88 -","- Al3.96 Cu1.12 F2 Fe0.04 H21.68 O28.72 P4 V0.88 -","- Al7.92 Cu2.24 F4 Fe0.08 H43.36 O57.44 P8 V1.76 -","2","0.5","","Colchester, D. M.; Leverett, P.; McKinnon, A. R.; Sharpe, J. L.; Williams, P. A.","Cloncurryite, Cu0.56(VO)0.44Al2(PO4)2(F,OH)2*5H2O, a new mineral from the Great Australia mine, Cloncurry, Queensland, Australia, and its relationship to nevadaite Locality: Great Australia mine, Concurry, Queensland, Australia","Australian Journal of Mineralogy","2007","13","","5","14","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:55:07",""
"9013999","8.323","","8.251","","5.861","","90","","90","","90","","402.493","","","","","","","","","","","","Block 14 open cut, Broken Hill, New South Wales, Australia","6","P n n m","-P 2 2n","58","","","Zincolibethenite","- As0.02 Cu0.94 H O5 P0.98 Zn1.06 -","- As0.08 Cu3.76 H4 O20 P3.92 Zn4.24 -","- As0.08 Cu3.76 H4 O20 P3.92 Zn4.24 -","","","","Williams, P. A.; Leverett, P.; Birch, W. D.; Hibbs, D. E.; Kilitsch, U.; Mihajlovic, T.","Zinc-rich zincolibethenite from Broken Hill, New South Wales Note: z-coordinate of O3 altered by communication with authors, April 2010","Australian Journal of Mineralogy","2006","12","","3","7","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:33:15",""
"9014598","9.663","","8.813","","5.2184","","90","","106.4","","90","","426.318","","","","","","","","","","","","Mount Anakie, Victoria, Australia","6","C 1 2/c 1","-C 2yc","15","","","Diopside","- Ca0.58 Fe0.5 Mg0.5 Na0.42 O6 Si2 -","- Ca2.32 Fe2 Mg2 Na1.68 O24 Si8 -","- Ca2.32 Fe2 Mg2 Na1.68 O24 Si8 -","","","","Mills, S. J.; Groat, L. A.","The crystal structure of yellow aegirine-augite from Mount Anakie, Victoria","Australian Journal of Mineralogy","2008","14","","43","45","","","","","","","","","","","","","","","","","","","","","","has coordinates","201816","2020-10-21","18:00:00",""
"9017388","13.682","","13.682","","13.916","","90","","90","","120","","2256.03","","","","","","","","","","","","Carr Boyd Rocks mine, Western Australia","6","R -3 :H","-R 3","148","","","Paratacamite-(Ni)","- Cl2 Co0.02 Cu3.27 H6 Ni0.71 O6 -","- Cl24 Co0.24 Cu39.24 H72 Ni8.52 O72 -","- Cl24 Co0.24 Cu39.24 H72 Ni8.52 O72 -","","","","Sciberras, M. J.; Leverett, P.; Williams, P. A.; Hibbs, D. E.; Downes, P. J.; Welch, M. D.; Kampf, A. R.","Paratacamite-(Ni), Cu3(Ni,Cu)Cl2(OH)6, a new mineral from the Carr Boyd Rocks mine, Western Australia","Australian Journal of Mineralogy","2013","17","","39","44","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:58",""
"9017893","25.77","","7.325","","10.522","","90","","90","","90","","1986.19","","","","100","","","","","","","","Griffins Find gold deposit, Western Australia","7","I m m a","-I 2b 2","74","","","Natrowalentalte","- As1.768 Fe2.686 H10.8 Na1.48 O20.36 P2 W0.664 -","- As1.768 Fe2.686 H10.8 Na1.48 O20.36 P2 W0.664 -","- As7.072 Fe10.744 H43.2 Na5.92 O81.44 P8 W2.656 -","4","0.25","","Grey, I. E.; Mumme, G.; Kampf, A. R.; MacRae, C. M.; Wilson, N. C.","Natrowalentaite, a new mineral from the Griffins Find gold deposit, Western Australia Note: T = 100 K","Australian Journal of Mineralogy","2019","20","","7","15","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""