# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T19:48:19+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 'Journal of Alloys Compd.') AND volume = 235 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
"1005022","10.708","0.002","11.233","0.002","16.52699","0.003","90","","90","","90","","1987.9","","","","","","","","","","","","","3","P b c a","-P 2ac 2ab","61","","Tricerium hexachloride nitride","","- Ce3 Cl6 N -","- Ce3 Cl6 N -","- Ce24 Cl48 N8 -","8","1","","Ehrlich, G M; Badding, M E; Brese, N E; Trail, S S; DiSalvo, F J","Corrigendum to ""New cerium nitride chlorides: Ce6 Cl12 N2 and Ce N Cl""","Journal of Alloys Compd.","1996","235","","133","134","10.1016/0925-8388(95)02134-5","","","","","","0.027","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1005023","5.723","0.002","10.04","0.003","26.05899","0.007","90","","90","","90","","1497.3","","","","","","","","","","","","","3","F d d d :2","-F 2uv 2vw","70","","Dipotassium phyllo-tetrathiotriniccolate","","- K2 Ni3 S4 -","- K2 Ni3 S4 -","- K16 Ni24 S32 -","8","0.25","","Elder, S H; Jobic, S; Brec, R; Gelabert, M; DiSalvo, F J","Structural and electronic properties of K2 Ni3 S4, a pseudo-two dimensional compound with a honeycomb-like arrangement","Journal of Alloys Compd.","1996","235","","135","142","10.1016/0925-8388(95)02064-0","","","","","","0.038","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1510166","4.3775","","4.3775","","7.1138","","90","","90","","120","","118.055","","","","","","","","","","","","","3","P 63 m c","P 6c -2c","186","","Lu Au Ge","","- Au Ge Lu -","- Au Ge Lu -","- Au2 Ge2 Lu2 -","2","0.166667","","Poettgen, R.; Henn, R.W.; Simon, A.; Felser, C.; Borrmann, H.; Kremer, R.K.; Jepsen, O.","Crystal and electronic structures of Sc Au Ge, Ce Au Ge, and Lu Au Ge: a transition from two- to three-dimensional (Au Ge) polyanions","Journal of Alloys Compd.","1996","235","","170","175","10.1016/0925-8388(95)02069-1","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1510169","4.3082","","4.3082","","6.8458","","90","","90","","120","","110.039","","","","","","","","","","","","","3","P 63 m c","P 6c -2c","186","","Sc Au Ge","","- Au Ge Sc -","- Au Ge Sc -","- Au2 Ge2 Sc2 -","2","0.166667","","Jepsen, O.; Poettgen, R.; Simon, A.; Kremer, R.K.; Felser, C.; Henn, R.W.; Borrmann, H.","Crystal and electronic structures of Sc Au Ge, Ce Au Ge, and Lu Au Ge: a transition from two- to three-dimensional (Au Ge) polyanions","Journal of Alloys Compd.","1996","235","","170","175","10.1016/0925-8388(95)02069-1","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""