# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-22T07:05:11+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 'Analytical Sciences: X-ray Structure Analysis Online') AND volume = 20 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
"1100690","7.733","0.003","10.511","0.002","7.715","0.002","98.17","0.02","109.89","0.02","82.79","0.02","581.7","0.3","296.2","","296","","","","","","","","","5","P -1","-P 1","2","","","","- C8 H32 N4 O16 P4 -","- C8 H32 N4 O16 P4 -","- C8 H32 N4 O16 P4 -","1","0.5","","Hemissi, Hanène; Abid, Sonia; Rzaigui, Mohamed","Structural Characterization of a New Organic Cyclotetraphosphate, [C~4~H~8~N~2~H~4~]~2~P~4~O~12~·4H~2~O","Analytical Sciences: X-ray Structure Analysis Online","2004","20","","x1","x2","10.2116/analscix.20.x1","","","0.5608","AgKα","","","","","","","","","","","","","","","","","has coordinates","134161","2020-10-21","18:00:00",""
"1100691","11.082","0.003","35.856","0.008","12.135","0.003","90","","106.04","0.02","90","","4634","2","293","2","293","2","","","","","","","","7","P 1 21/n 1","-P 2yn","14","","Tetrakis(N,N-dimethyl,N'-phenylthiourea-S)cadmium(II)diperchlorate","","- C36 H48 Cd Cl2 N8 O8 S4 -","- C36 H48 Cd Cl2 N8 O8 S4 -","- C144 H192 Cd4 Cl8 N32 O32 S16 -","4","1","","Cherni, Saoussen Namouchi; Samba, Mohamadou; Dachraoui, Mohamed","Crystal Structure of Tetrakis(N,N-dimethyl, N'-phenylthiourea-S) cadmium(II) diperchlorate [Cd((CH~3~)~2~NCSNHPh)~4~](ClO~4~)~2~","Analytical Sciences: X-ray Structure Analysis Online","2004","20","","x3","x4","10.2116/analscix.20.x3","","","0.71073","MoKα","","0.0981","0.0496","","","0.118","0.1515","","","","","","1.024","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1100692","6.985","0.002","9.045","0.002","10.256","0.003","111.87","0.02","104.25","0.02","102","0.02","549.5","0.3","293","2","293","2","","","","","","","","4","P 1","P 1","1","","hexapotassium dibismuth diphosphate","","- Bi2 K6 O21 P6 -","- Bi2 K6 O21 P6 -","- Bi2 K6 O21 P6 -","1","1","","Falah, Chiraz; Boughzala, Habib; Jouini, Tahar","Preparation and the Crystal Structure of Non-centrosymmetric K~6~Bi~2~(P~2~O~7~)~3~","Analytical Sciences: X-ray Structure Analysis Online","2004","20","","x17","x18","10.2116/analscix.20.x17","","","0.71073","MoKα","","0.077","0.0732","","","0.1715","0.1753","","","","","","1.053","","","","has coordinates","277831","2022-09-14","14:31:32",""