# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T18:45:16+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 'Zeitschrift fuer Anorganische und Allgemeine Chemie') AND volume = 343 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
"1539940","5.65","","16.21","","6.13","","90","","94.3","","90","","559.845","","","","","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","","Pb N2 S2 (N H3)","","- H3 N3 Pb S2 -","- H3 N3 Pb S2 -","- H12 N12 Pb4 S8 -","4","1","","Weiss, J.","Zur Struktur von Pb N2 S2 (N H3)","Zeitschrift fuer Anorganische und Allgemeine Chemie","1966","343","","315","322","","","","","","","","","","","","","","","","","","","","","","has coordinates","186592","2020-10-21","18:00:00",""
"2002281","9.51","","3.11","","10.83","","90","","90","","90","","320.3","","","","","","","","","","","","","3","P n m a","-P 2ac 2n","62","","Mangnesium discandium oxide","","- Mg O4 Sc2 -","- Mg0.9999 O4 Sc1.9998 -","- Mg3.9996 O16 Sc7.9992 -","4","0.5","","Mueller-Buschbaum, H","Zur Kenntnis des Mg Sc2 O4","Zeitschrift fuer Anorganische und Allgemeine Chemie","1966","343","","113","120","10.1002/zaac.19663430302","","","","","","0.096","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"2002849","3.83","","3.83","","6.01","","90","","90","","120","","76.3","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","Neodymium oxide - A-form","","- Nd2 O3 -","- Nd2 O3 -","- Nd2 O3 -","1","0.0416667","","Mueller-Buschbaum, Hk","Zur Struktur der A-Form der Sesquioxide der Seltenen Erden. II Strukturuntersuchung an Nd2 O3","Zeitschrift fuer Anorganische und Allgemeine Chemie","1966","343","","6","10","10.1002/zaac.19663430103","","","","","","0.11","","","","","","","","","","","","","","","has coordinates","201955","2020-10-21","18:00:00",""