# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2025-01-02T16:03:19+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 'Crystals structures, Vol. II') 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
"5910007","7.84","","7.84","","7.84","","90","","90","","90","","481.89","","","","","","","","","","","","","3","P a -3","-P 2ac 2ab 3","205","","lead(II) nitrate","","- N2 O6 Pb -","- N2 O6 Pb -","- N8 O24 Pb4 -","4","0.166667","","Wyckoff, R. W. G.","Crystal structure of lead(II) nitrate","Crystals structures, Vol. II","1951","","","","","","","","","","","","","","","","","","","","","","","","","","has coordinates","205202","2020-10-21","18:00:00",""
"5910045","7.6","","7.6","","7.6","","90","","90","","90","","438.976","","","","","","","","","","","","","3","P a -3","-P 2ac 2ab 3","205","","Calcium nitrate","","- Ca N2 O6 -","- Ca N2 O6 -","- Ca4 N8 O24 -","4","0.166667","","Wyckoff, R. W. G.","Crystal structure of calcium nitrate","Crystals structures, Vol. II","1951","","","","","","","","","","","","","","","","","","","","","","","","","","has coordinates","205206","2020-10-21","18:00:00",""
"5910065","8.11","","8.11","","8.11","","90","","90","","90","","533.41","","","","","","","","","","","","","3","P a -3","-P 2ac 2ab 3","205","","Barium nitrate","","- Ba N2 O6 -","- Ba N2 O6 -","- Ba4 N8 O24 -","4","0.166667","","Wyckoff, R. W. G.","Crystal structure of barium nitrate","Crystals structures, Vol. II","1951","","","","","","","","","","","","","","","","","","","","","","","","","","has coordinates","205206","2020-10-21","18:00:00",""
"5910116","7.81","","7.81","","7.81","","90","","90","","90","","476.38","","","","","","","","","","","","","3","P a -3","-P 2ac 2ab 3","205","","Strontium nitrate","","- N2 O6 Sr -","- N2 O6 Sr -","- N8 O24 Sr4 -","4","0.166667","","Wyckoff, R. W. G.","Crystal structure of strontium nitrate","Crystals structures, Vol. II","1951","","","","","","","","","","","","","","","","","","","","","","","","","","has coordinates","205206","2020-10-21","18:00:00",""