# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-29T10:17:49+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 'Arkiv foer Kemi') AND volume = 1 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 "1534180","5.492","","5.503","","25.53","","90","","90","","90","","771.58","","","","","","","","","","","","","4","F 2 2 2","F 2 2","22","","Pb Bi2 Nb2 O9","","- Bi2 Nb2 O9 Pb -","- Bi2 Nb2 O9 Pb -","- Bi8 Nb8 O36 Pb4 -","4","0.25","","Aurivillius, B.","Mixed bismuth oxides with layer lattices. I. The structure type of Ca Nb2 Bi2 O9","Arkiv foer Kemi","1949","1","","463","480","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1534181","5.405","","5.442","","25.11","","90","","90","","90","","738.586","","","","","","","","","","","","","4","F m m m","-F 2 2","69","","Bi3 Nb Ti O9","","- Bi3 Nb O9 Ti -","- Bi3 Nb O9 Ti -","- Bi12 Nb4 O36 Ti4 -","4","0.125","","Aurivillius, B.","Mixed bismuth oxides with layer lattices. I. The structure type of Ca Bi2 Nb2 O9","Arkiv foer Kemi","1949","1","","463","480","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1534182","5.41","","5.448","","32.84","","90","","90","","90","","967.916","","","","","","","","","","","","","3","F m m m","-F 2 2","69","","Bi4 Ti3 O12","","- Bi4 O12 Ti3 -","- Bi4 O12 Ti3 -","- Bi16 O48 Ti12 -","4","0.125","","Aurivillius, B.","Mixed bismuth oxides with layer lattices. II. Structure of Bi4 Ti3 O12","Arkiv foer Kemi","1949","1","","499","512","","","","","","","","","","","","","","","","","","","","","","has coordinates","160693","2020-10-21","18:00:00","" "1538314","12.285","","12.285","","3.833","","90","","90","","90","","578.481","","","","","","","","","","","","","3","P 4/m b m","-P 4 2ab","127","","K0.475 (W O3)","","- K0.475 O3 W -","- K0.474 O3 W -","- K4.74 O30 W10 -","10","0.625","","Magneli, A.","The crystal structure of tetragonal potassium tungsten bronze","Arkiv foer Kemi","1949","1","","213","221","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538315","18.31999","","3.79","","14.04","","90","","115.03","","90","","883.286","","","","","","","","","","","","","2","P 1 2/m 1","-P 2y","10","","W O2.72","","- O2.72 W -","- O2.72222 W -","- O49 W18 -","18","4.5","","Magneli, A.","Crystal structure studies on gamma-tungsten oxide","Arkiv foer Kemi","1949","1","","223","230","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1538317","12.1","","3.78","","23.4","","90","","95","","90","","1066.2","","","","","","","","","","","","","2","P 1 2/m 1","-P 2y","10","","W O2.90","","- O2.9 W -","- O2.9 W -","- O58 W20 -","20","5","","Magneli, A.","Crystal structure studies on beta-tungsten oxide","Arkiv foer Kemi","1949","1","","513","523","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""