# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-01-27T04:17:22+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 'Naturwissenschaften') AND volume = 31 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
"1539263","3.897","","3.897","","3.897","","90","","90","","90","","59.182","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Pt3 Ti -","- Pt3 Ti -","- Pt3 Ti -","1","0.0208333","","Wallbaum, H.J.","Zur Legierungschemie der Uebergangsmetalle","Naturwissenschaften","1943","31","","91","91","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"1542051","7.3","","7.3","","7.3","","90","","90","","90","","389.017","","","","","","","","","","","","","7","P -4 3 m","P -4 2 3","215","","Li4 Na K Al4 Be3 B10 O27","","- Al4 B9.9996 Be2.0004 K Li4 Na O27 -","- Al4 B9.9996 Be2.0004 K Li4 Na O27 -","- Al4 B9.9996 Be2.0004 K Li4 Na O27 -","1","0.0416667","","Strunz, H.","Die Struktur von Rhodizit","Naturwissenschaften","1943","31","","68","68","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542143","7.6","","7.6","","7.6","","90","","90","","90","","438.976","","","","","","","","","","","","","3","P 1 21/m 1","-P 2yb","11","","Ca (Ti O3)","","- Ca O3 Ti -","- Ca O3 Ti -","- Ca8 O24 Ti8 -","8","2","","Naray-Szabo, S.","Der Strukturtyp des Perowskits (Ca Ti O3)","Naturwissenschaften","1943","31","","202","203","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542144","3.89","","3.89","","3.89","","90","","90","","90","","58.864","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","La (Fe O3)","","- Fe La O3 -","- Fe La O3 -","- Fe La O3 -","1","0.0208333","","Naray-Szabo, S.","Die Strukturen von Verbindungen A B O3. Schwesterstrukturen","Naturwissenschaften","1943","31","","466","466","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542145","3.88","","3.88","","3.88","","90","","90","","90","","58.411","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","La (Mn O3)","","- La Mn O3 -","- La Mn O3 -","- La Mn O3 -","1","0.0208333","","Naray-Szabo, S.","Die Strukturen von Verbindungen A B O3. Schwesterstrukturen","Naturwissenschaften","1943","31","","466","466","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1542146","3.88","","3.88","","3.88","","90","","90","","90","","58.411","","","","","","","","","","","","","3","P m -3 m","-P 4 2 3","221","","La (Cr O3)","","- Cr La O3 -","- Cr La O3 -","- Cr La O3 -","1","0.0208333","","Naray-Szabo, S.","Die Strukturen von Verbindungen A B 03. Schwesterstrukturen","Naturwissenschaften","1943","31","","466","466","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""