# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-28T14:53:07+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 'Zeitschrift fuer Kristallographie (149,1979-)') AND volume = 165 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
"8104234","10.456","","9.548","","13.625","","90","","90","","90","","1360.24","","","","","","","","","","","","","2","P n m a","-P 2ac 2n","62","","","","- P4 S3 -","- P4 S3 -","- P32 S24 -","8","1","","Chattopadhyay, T.K.; May, W.; von Schnering, H.G.; Pawley, G.S.","X-ray and neutron diffraction study of the crystal structure of alpha-P4 S3","Zeitschrift fuer Kristallographie (149,1979-)","1983","165","","47","64","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"9008310","5.605","","6.087","","6.929","","90","","94.48","","90","","235.679","","","","","","","","","","","","Synthetic","4","P 1 21 1","P 2yb","4","","","Rouaite","- Cu2 H3 N O6 -","- Cu2 H3 N O6 -","- Cu4 H6 N2 O12 -","2","1","","Effenberger, H.","Verfeinerung der kristallstruktur des monoklinen dikupfer(II)-trihydroxi-nitrates Cu2(NO3)(OH)3","Zeitschrift fur Kristallographie","1983","165","","127","135","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","07:55:58",""
"9008311","8.556","","8.556","","8.175","","90","","90","","120","","518.275","","","","","","","","","","","","Cape Cross, Namibia","4","P 63/m","-P 6c","176","","","Jeremejevite","- Al6 B5 F3 O15 -","- Al6 B5 F3 O15 -","- Al12 B10 F6 O30 -","2","0.166667","","Rodellas, C.; Garcia-Blanco S; Vegas, A.","Crystal structure refinement of jeremejevite (Al6B5F3O15)","Zeitschrift fur Kristallographie","1983","165","","255","260","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","07:55:58",""
"9008312","47.453","","15.476","","5.847","","90","","90","","90","","4293.94","","","","","","","","","","","","Synthetic","4","F d d 2","F 2 -2d","43","","","Edenharterite","- As3 Pb S6 Tl -","- As3 Pb S6 Tl -","- As48 Pb16 S96 Tl16 -","16","1","","Balic-Zunic T; Engel, P.","Crystal structure of synthetic PbTlAs3S6","Zeitschrift fur Kristallographie","1983","165","","261","269","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","07:55:58",""
"9008313","2.858","","2.858","","11.293","","90","","90","","120","","79.885","","","","","","","","","","","","Synthetic","3","P 63/m m c","-P 6c 2c","194","","","Delafossite","- Al Cu O2 -","- Al Cu O2 -","- Al2 Cu2 O4 -","2","0.0833333","","Kohler, B. U.; Jansen, M.","Synthesis and crystal structure of 2H-CuAlO2","Zeitschrift fur Kristallographie","1983","165","","313","314","10.1524/zkri.1983.165.1-4.313","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","07:55:58",""
"9011447","38.746","","8.816","","7.989","","90","","90","","90","","2728.92","","","","","","","","","","","","Jas-Roux, Hutes-Alps, France","4","P n a 21","P 2c -2n","33","","","Pierrotite","- As2 S8 Sb3 Tl -","- As2 S8 Sb3 Tl -","- As16 S64 Sb24 Tl8 -","8","2","","Engel, P.; Gostojic, M.; Nowacki, W.","The crystal structure of pierrotite, Tl2(Sb,As)10S16","Zeitschrift fur Kristallographie","1983","165","","209","215","10.1524/zkri.1983.165.1-4.209","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:47",""
"9016300","5.108","","8.844","","19.156","","90","","95.48","","90","","861.42","","","","","","","","","","","","Greiner, Zillertal, Autria","8","C 1 c 1","C -2yc","9","","","Margarite","- Al4 Ca0.725 H1.98 Li0.105 Mg0.105 Na0.21 O12 Si2 -","- Al4 Ca0.725 H1.98 Li0.105 Mg0.105 Na0.21 O12 Si2 -","- Al16 Ca2.9 H7.92 Li0.42 Mg0.42 Na0.84 O48 Si8 -","4","1","","Joswig, W.; Takeuchi, Y.; Fuess, H.","Neutron-diffraction study on the orientation of hydroxyl groups in margarite","Zeitschrift fur Kristallographie","1983","165","","295","303","10.1524/zkri.1983.165.1-4.295","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54",""