# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-07T13:04:15+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 'Crystallography Reports') AND volume = 62 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
"1564821","12.0051","0.0002","10.4423","0.0001","19.9229","0.0002","90","","95.254","0.001","90","","2487.06","0.05","293","2","293","2","","","","","","","","7","P 1 21/c 1","-P 2ybc","14","","","","- C6 H58 Ca N2 Na8 O44 P6 -","- C6 H58 Ca N2 Na8 O44.002 P6 -","- C12 H116 Ca2 N4 Na16 O88.004 P12 -","2","0.5","","Somov, N.V.; Chausov, F.F.; Zakirova, R.M.","Synthesis and Structure of Decaaqua-Hexasodium-Calcium Bis-nitrilotris(methylenephosphonate) Bis(hexaaquasodium) Tetrahydrate [CaNa6{NH(CH2PO3)3}2(H2O)10][Na(H2O)6]2 4H2O","Crystallography Reports","2017","62","3","397","404","10.1134/S1063774517030208","","x-ray","0.71073","MoKα","","0.0421","0.0398","","","0.1114","0.1133","","","","","","1.076","","","","has coordinates","269564","2021-10-05","10:00:38",""
"1564822","13.9117","0.001","11.5403","0.0001","24.1784","0.0017","90","","148.785","0.018","90","","2011.7","0.6","296","2","296","2","","","","","","","","7","P 1 21/c 1","-P 2ybc","14","","","","- C3 H23 Ba2 N Na O17 P3 -","- C3 H23 Ba2 N Na O17 P3 -","- C12 H92 Ba8 N4 Na4 O68 P12 -","4","1","","Somov, N.V.; Chausov, F.F.; Zakirova, R.M.","Synthesis and Structure of Heptaaqua{nitrilotris(methylenephosphonato)}(dibarium)sodium Monohydrate [Na(H2O)3{6-NH(CH2PO3)3}(-H2O)3Ba2(H2O)] H2O","Crystallography Reports","2017","62","2","232","237","10.1134/S1063774517020262","","x-ray","0.71073","MoKα","","0.0366","0.0279","","","0.0578","0.0605","","","","","","1.068","","","","has coordinates","269565","2021-10-05","10:00:48",""
"1564825","8.038","0.0003","9.0522","0.0004","10.7837","0.0004","113.252","0.004","105.391","0.003","96.182","0.003","674.77","0.05","293","2","293","2","","","","","","","","6","P -1","-P 1","2","","","","- C3 H12 N O10 P3 Rb2 -","- C3 H12 N O10 P3 Rb2 -","- C6 H24 N2 O20 P6 Rb4 -","2","1","","Somov, N.V.; Chausov, F.F.; Zakirova, R.M.; Shumilova, M.A.; Aleksandrov, V.A.; Petrov, V.G.","Aquanitrilotris(methylenephosphonato)dirubidium [Rb2(H2O){12-NH(CH2PO3H)3}]: Synthesis and Structure","Crystallography Reports","2017","62","5","734","738","10.1134/S1063774517050212","","x-ray","0.71073","MoKα","","0.0317","0.0259","","","0.0627","0.0653","","","","","","1.048","","","","has coordinates","269571","2021-10-05","10:02:25",""
"1564826","10.8942","0.0003","13.1882","0.0004","14.0016","0.0004","65.885","0.003","82.401","0.002","83.143","0.002","1815.23","0.1","293","2","293","2","","","","","","","","7","P -1","-P 1","2","","","","- C6 H40 N2 Na4 O30 P6 Pb2 -","- C6 H40 N2 Na4 O30 P6 Pb2 -","- C12 H80 N4 Na8 O60 P12 Pb4 -","2","1","","Somov, N.V.; Chausov, F.F.; Zakirova, R.M.; Reshetnikov, S.M.; Shishkin, A.S.; Shumilova, M.A.; Aleksandrov, V.A.; Petrov, V.G.","Chelate Complexes of Lead(II) with Nitrilotris(methylenephosphonic) Acid [Pb{5-NH(CH2PO3H)3}] and Na4[Pb2(H2O)2{3-N(CH2PO3)3H2}2] 10H2O: Synthesis, Structure, and Asymmetry of Lone 6s Pair","Crystallography Reports","2017","62","6","857","867","10.1134/S1063774517050224","","x-ray","0.71073","MoKα","","0.0304","0.0244","","","0.0512","0.0535","","","","","","1.091","","","","has coordinates,has disorder","269572","2021-10-05","10:02:34",""