# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-24T18:52:20+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 'Philips Research Reports') 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 "1523158","3.0472","","3.0472","","3.0472","","90","","90","","90","","28.295","","","","","","","","","","","","","2","I m -3 m","-I 4 2 3","229","","(Ga0.25 V0.75)","","- Ga0.25 V0.75 -","- Ga0.25 V0.75 -","- Ga0.5 V1.5 -","2","0.0208333","","van Vucht, J.H.N.; Bruning, H.A.C.M.; Gomes de Mesquita, A.H.; Donkersloot, H.C.","The system vanadium-gallium","Philips Research Reports","1964","19","","407","421","","","","","","","","","","","","","","","","","","","","","","has coordinates","143662","2020-10-21","18:00:00","" "1523715","9.86","","5.6477","","19.127","","90","","90","","90","","1065.11","","","","","","","","","","","","","2","F d d d :1","F 2 2 -1d","70","","","","- Nb Sn2 -","- Nb Sn2 -","- Nb16 Sn32 -","16","0.5","","Gomes de Mesquita, A.H.; Langereis, C.; Leenhouts, J.L.","The structure of Nb Sn2","Philips Research Reports","1963","18","","377","382","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1524171","3.429","","3.429","","3.429","","90","","90","","90","","40.318","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Cu Er -","- Cu Er -","- Cu Er -","1","0.0208333","","Buschow, K.H.J.","The erbium-copper system","Philips Research Reports","1970","25","","227","230","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1525537","5.098","","5.098","","5.098","","90","","90","","90","","132.495","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- Ce0.5 Th0.5 -","- Ce0.5 Th0.5 -","- Ce2 Th2 -","4","0.0208333","","van Vucht, J.H.N.","Ternary system Th-Ce-Al","Philips Research Reports","1961","16","","1","40","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1528270","16.93","","9.144","","5.735","","90","","90","","90","","887.823","","","","","","","","","","","","","2","I m m m","-I 2 2","71","","","","- Sn5 Ti6 -","- Sn5 Ti6 -","- Sn20 Ti24 -","4","0.25","","van Vucht, J.H.N.; Bruning, H.A.C.M.; Donkersloot, H.C.; Gomes de Mesquita, A.H.","The system vanadium-gallium","Philips Research Reports","1964","19","","407","421","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1534312","5.88","","5.88","","84.11","","90","","90","","120","","2518.45","","","","","","","","","","","","","3","R -3 m :H","-R 3 2""","166","","","","- Ba2 Fe30 O46 -","- Ba2 Fe30 O46 -","- Ba6 Fe90 O138 -","3","0.0833333","","Braun, P.B.","The crystal structures of a new group of ferromagnetic compounds","Philips Research Reports","1957","12","","491","548","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1534313","5.885","","5.885","","52.301","","90","","90","","120","","1568.68","","","","","","","","","","","","","3","P 63/m m c","-P 6c 2c","194","","","","- Ba3 Fe26 O41 -","- Ba3 Fe26 O41 -","- Ba6 Fe52 O82 -","2","0.0833333","","Braun, P.B.","The crystal structures of a new group of ferromagnetic compounds","Philips Research Reports","1957","12","","491","548","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1538487","5.1864","","5.1864","","18.87","","90","","90","","120","","439.577","","","","","","","","","","","","","2","R -3 m :H","-R 3 2""","166","","","","- Co3 Ta -","- Co3 Ta -","- Co27 Ta9 -","9","0.25","","Ponsioen, J.C.M.A.; van Vucht, J.H.N.","The Structure of beta-Ta Co3 and the Effect of the Substitution of Ta and Co by Related Elements","Philips Research Reports","1967","22","","161","169","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1540870","9.22","","9.22","","5.69","","90","","90","","120","","418.895","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","","","- Sn5 Ti6 -","- Sn5 Ti6 -","- Sn10 Ti12 -","2","0.0833333","","van Vucht, J.H.N.; Bruning, H.A.C.M.; Donkersloot, H.C.; Gomes de Mesquita, A.H.","The system V-Ga","Philips Research Reports","1964","19","","407","421","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00","" "1541567","8.3","","8.3","","8.3","","90","","90","","90","","571.787","","","","","","","","","","","","","3","F d -3 m :1","F 4d 2 3 -1d","227","","","","- Co2 Ge O4 -","- Co2 Ge O4 -","- Co16 Ge8 O32 -","8","0.0416667","","Romeijn, F.C.","Physical and Crystallographical Properties of Some Spinels","Philips Research Reports","1953","8","","304","320","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""