# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T15:24:29+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 'Acta Crystallographica Section A Foundations of Crystallography') AND volume = 61 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
"2019332","10.7355","0.0009","9.1456","0.0007","4.8304","0.0004","90","","106.46","0.01","90","","454.82","0.07","298","","298","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","D,L-Serine","(±) 2-Amino-3-hydroxypropionic acid","","- C3 H7 N O3 -","- C3 H7 N O3 -","- C12 H28 N4 O12 -","4","1","","Dittrich, B.; Hübschle, C. B.; Messerschmidt, M.; Kalinowski, R.; Girnt, D.; Luger, P.","The invariom model and its application: refinement ofD,L-serine at different temperatures and resolution","Acta Crystallographica Section A Foundations of Crystallography","2005","61","3","314","320","10.1107/S0108767305005039","","","0.71073","MoKα","","0.0346","0.0223","","","","0.0257","","","","","","1.3889","","","","has coordinates","176760","2020-10-21","18:00:00",""
"2019333","10.7621","0.001","9.1771","0.0009","4.7883","0.0005","90","","106.76","0.02","90","","452.83","0.09","100","","100","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","D,L-Serine","(±) 2-Amino-3-hydroxypropionic acid","","- C3 H7 N O3 -","- C3 H7 N O3 -","- C12 H28 N4 O12 -","4","1","","Dittrich, B.; Hübschle, C. B.; Messerschmidt, M.; Kalinowski, R.; Girnt, D.; Luger, P.","The invariom model and its application: refinement ofD,L-serine at different temperatures and resolution","Acta Crystallographica Section A Foundations of Crystallography","2005","61","3","314","320","10.1107/S0108767305005039","","","0.71073","MoKα","","0.0347","0.0228","","","","0.0237","","","","","","1.2422","","","","has coordinates","176760","2020-10-21","18:00:00",""
"2019334","10.7764","0.001","9.1947","0.0009","4.7788","0.0005","90","","106.87","0.02","90","","453.13","0.09","20","","20","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","D,L-Serine","(±) 2-Amino-3-hydroxypropionic acid","","- C3 H7 N O3 -","- C3 H7 N O3 -","- C12 H28 N4 O12 -","4","1","","Dittrich, B.; Hübschle, C. B.; Messerschmidt, M.; Kalinowski, R.; Girnt, D.; Luger, P.","The invariom model and its application: refinement ofD,L-serine at different temperatures and resolution","Acta Crystallographica Section A Foundations of Crystallography","2005","61","3","314","320","10.1107/S0108767305005039","","","0.71073","MoKα","","0.0272","0.0196","","","","0.0218","","","","","","1.2952","","","","has coordinates","176760","2020-10-21","18:00:00",""