# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T12:02:31+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 'Recueil des Travaux Chimiques des Pays-Bas et de la Belgique') AND volume = 58 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 "1010002","9","","14.9","","3.96","","90","","90","","90","","531","","","","","","","","","","","","","4","P n a m","-P 2c 2n","62","","Ammonium cadmium chloride","","- Cd Cl3 H4 N -","- Cd Cl3 H2 N -","- Cd4 Cl12 H8 N4 -","4","0.5","","MacGillavry, C H; Nijveld, H; Dierdorp, S; Karsten, J","Die Krystallstruktur von N H~4~ Cd Cl~3~ und Rb Cd Cl~3~","Recueil des Travaux Chimiques des Pays-Bas et de la Belgique","1939","58","","193","200","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00","" "1010052","11.6","0.01","11.6","0.01","11.6","0.01","90","","90","","90","","1560.9","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Rubidium hexaiodostannate","","- I6 Rb2 Sn -","- I6 Rb2 Sn -","- I24 Rb8 Sn4 -","4","0.0208333","","Werker, W","Die Kristallstruktur des Rb~2~ Sn I~6~ und Cs~2~ Sn I~6~","Recueil des Travaux Chimiques des Pays-Bas et de la Belgique","1939","58","","257","258","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010053","11.63","0.01","11.63","0.01","11.63","0.01","90","","90","","90","","1573","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Caesium hexaiodostannate","","- Cs2 I6 Sn -","- Cs2 I6 Sn -","- Cs8 I24 Sn4 -","4","0.0208333","","Werker, W","Die Kristallstruktur des Rb~2~ Sn I~6~ und Cs~2~ Sn I~6~","Recueil des Travaux Chimiques des Pays-Bas et de la Belgique","1939","58","","257","258","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010567","9.01","","14.93","","4.01","","90","","90","","90","","539.4","","","","","","","","","","","","","3","P n a m","-P 2c 2n","62","","Rubidium trichlorocadmate","","- Cd Cl3 Rb -","- Cd Cl3 Rb -","- Cd4 Cl12 Rb4 -","4","0.5","","MacGillavry, C H; Nijveld, H; Dierdorp, S; Karsten, J","Die Krystallstruktur von NH~4~CdCl~3~ und RbCdCl~3~","Recueil des Travaux Chimiques des Pays-Bas et de la Belgique","1939","58","","193","200","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00","" "1010890","10.82","0.01","10.82","0.01","5.95","0.01","90","","90","","90","","696.6","","","","","","","","","","","","","3","P 42/n :1","P 4n -1n","86","","Cyclo-tetrakis(phosphorus(V) nitride dichloride)","","- Cl8 N4 P4 -","- Cl8 N4 P4 -","- Cl16 N8 P8 -","2","0.25","","Ketelaar, J. A. A.; De Vries, T. A.","The Crystal Structure of Tetra Phosphonitrile Chloride , P~4~N~4~Cl~8~","Recueil des Travaux Chimiques des Pays-Bas et de la Belgique","1939","58","","1081","1099","10.1002/recl.19390581205","","","","","","","","","","","","","","","","","","","","","has coordinates","189446","2020-10-21","18:00:00",""