# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-28T17:46:19+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 'Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)') AND volume = 64 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
"1010499","9.67","","9.67","","8.92","","90","","90","","90","","834.1","","","","","","","","","","","","","3","I -4 2 d S","","122","","Mercury cyanide","","- C2 Hg N2 -","- C2 Hg N2 -","- C16 Hg8 N16 -","8","","","Hassel, O.","Roentgenographische Untersuchung des tetragonal kristallisierenden Quecksilberzyanids.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","64","","218","223","","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1010500","5.73","0.01","5.73","0.01","5.73","0.01","90","","90","","90","","188.1","","","","","","","","","","","","","2","P n -3 :1","P 2 2 3 -1n","201","","Calcium duo-dicarbide","","- C4 Ca2 -","- C4 Ca2 -","- C8 Ca4 -","2","0.0833333","","Dehlinger, U; Glocker, R","Die Kristallstruktur des Calciumcarbides.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","64","","296","302","","","","","","","","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"1010501","12.23","","12.23","","12.23","","90","","90","","90","","1829.3","","","","","","","","","","","","","2","P a -3","-P 2ac 2ab 3","205","","Tin(IV) iodide","","- I4 Sn -","- I4 Sn -","- I32 Sn8 -","8","0.333333","","Dickinson, R G","Die Symmetrie und der Elementarbereich von Zinntetrajodid.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","64","","400","404","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011056","9.416","0.007","9.416","0.007","9.416","0.007","90","","90","","90","","834.8","","","","","","","","","","","","from Schwabengrube, Muesen, Germany","2","F d -3 m :1","F 4d 2 3 -1d","227","","Cobalt dicobalt(III) sulfide","Linnaeite","- Co3 S4 -","- Co3 S4 -","- Co24 S32 -","8","0.0416667","","Menzer, G","Ueber die Kristallstruktur von Linneit einschliesslich Polydymit und Sychnodymit.","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","64","","506","507","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1011262","5.762","","5.762","","9.439","","90","","90","","90","","313.4","","","","","","","","","","","","from Langban, Sweden","2","I 41/a m d :1","I 4bw 2bw -1bw","141","","Manganese dimanganese(III) oxide","Hausmannite","- Mn3 O4 -","- Mn3 O4 -","- Mn12 O16 -","4","0.125","","Aminoff, G","Ueber die Kristallstruktur von Hausmannit (Mn Mn2 O4).","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","64","","475","490","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"8103496","8.16","","8.16","","9.44","","90","","90","","90","","628.568","","","","","","","","","","","","","2","I 41/a m d :1","I 4bw 2bw -1bw","141","","Manganese Dimanganese(III) Oxide","","- Mn3 O4 -","- Mn3 O4 -","- Mn12 O16 -","4","0.125","","Aminoff, G.","Ueber die Kristallstruktur von Hausmannit (Mn Mn2 O4).","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1926","64","","475","490","","","","","","","","","","","","","","","","","","","","","","has coordinates","176728","2020-10-21","18:00:00",""