# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T13:58:37+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 Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)') AND volume = 101 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
"1010018","8.21","","12.05","","9.1","","90","","90","","90","","900.3","","","","","","","","","","","","","5","P b n m","-P 2c 2ab","62","","Dipotassium tin chloride hydrate","","- Cl4 H2 K2 O Sn -","- Cl4 H2 K2 O Sn -","- Cl16 H8 K8 O4 Sn4 -","4","0.5","","Brasseur, H; de Rassenfosse, A","The crystal structure of hydrated potassium chlorostannite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","389","395","","","","","","","","","","","","","","","","","","","","","","has coordinates","200452","2020-10-21","18:00:00",""
"1010019","9.2","","11.42","","4.3","","90","","90","","90","","451.8","","","","","","","","","","","","","2","P b n m","-P 2c 2ab","62","","Strontium bromide","","- Br2 Sr -","- Br2 Sr -","- Br8 Sr4 -","4","0.5","","Kamermans, M A","The crystal structure of Sr Br~2~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","406","411","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010020","4.05","","4.05","","4.9","","90","","90","","90","","80.4","","","","","","","","","","","","","3","P 4/n m m :1","P 4ab 2ab -1ab","129","","Lead bismuth oxide (.3/.7/1.3)","","- Bi0.67 O1.33 Pb0.33 -","- Bi0.67 O1.34 Pb0.33 -","- Bi1.34 O2.68 Pb0.66 -","2","0.125","","Sillen, L G; Aurivillius, B","Oxide phases with a defect oxygen lattice","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","483","495","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010021","3.98","","3.98","","5.15","","90","","90","","90","","81.6","","","","","","","","","","","","","3","P 4/n m m :1","P 4ab 2ab -1ab","129","","Lead bismuth oxide (.5/.5/1.3)","","- Bi0.5 O1.33 Pb0.5 -","- Bi0.5 O1.34 Pb0.5 -","- Bi O2.68 Pb -","2","0.125","","Sillen, L G; Aurivillius, B","Oxide phases with a defect oxygen lattice","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","483","495","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010022","3.97","","3.97","","28.59","","90","","90","","120","","390.2","","","","","","","","","","","","","3","R -3 m HR","","166","","Strontium bismuth oxide (.8/2.2/4)","","- Bi2.22 O4 Sr0.78 -","- Bi2.22 O4.02 Sr0.78 -","- Bi6.66 O12.06 Sr2.34 -","3","","","Sillen, L G; Aurivillius, B","Oxide phases with a defect oxygen lattice","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","483","495","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010451","4.022","","4.022","","4.022","","89.575","","89.575","","89.575","","65.1","","","","","","","","","","","","","2","R 3 2 :R","P 3* 2","155","","Scandium fluoride","","- F3 Sc -","- F3 Sc -","- F3 Sc -","1","0.166667","","Nowacki, W","Die Kristallstruktur des Sc F~3~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","273","282","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"1010452","5.096","","5.096","","8.304","","90","","90","","120","","186.8","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","Nickel titanium (3:1)","","- Ni3 Ti -","- Ni3 Ti -","- Ni12 Ti4 -","4","0.166667","","Laves, F; Wallbaum, H J","Die Kristallstruktur von Ni~3~ Ti und Si~2~ Ti","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","78","93","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010453","8.236","","4.773","","8.523","","90","","90","","90","","335","","","","","","","","","","","","Synthetic","2","F d d d :1","F 2 2 -1d","70","","Titanium silicide (1/2)","Zhiqinite","- Si2 Ti -","- Si2 Ti -","- Si16 Ti8 -","8","0.25","","Laves, F; Wallbaum, H J","Die Kristallstruktur von Ni~3~ Ti und Si~2~ Ti","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","78","93","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44",""
"1010454","8.02","0.01","8.02","0.01","7","0.02","90","","90","","90","","450.2","","","","","","","","","","","","","2","I 4/m c m","-I 4 2c","140","","Thallium thallium(III) selenide","","- Se2 Tl2 -","- Se2 Tl2 -","- Se8 Tl8 -","4","0.125","","Ketelaar, J A A; t'Hart, W H; Polder, D","The Crystal Structure of Tl Se, Thallous Thallic or Thallosic Selenide","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","396","405","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010455","10.082","","10.082","","10.082","","90","","90","","90","","1024.8","","","","","","","","","","","","","2","P -4 3 m","P -4 2 3","215","","Lithium lead (10:3) - $-gamma","","- Li10 Pb3 -","- Li10 Pb3 -","- Li40 Pb12 -","4","0.166667","","Rollier, M A; Arreghini, E","La fase gamma della lega litio-piombo Li~10~ Pb~3~","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","470","482","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1010457","12.2","0.07","12.2","0.07","18.17","0.06","90","","90","","120","","2342.1","","","","","","","","","","","","","2","R 3 :H","R 3","146","","Thallium sulfide","","- S Tl2 -","","","27","3","","Ketelaar, J A A; Gorter, E W","Die Kristallstruktur des Thallosulfid ( Tl~2~ S )","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","367","375","","","","","","","","","","","","","","","","","","","","","","","176729","2020-10-21","18:00:00",""
"1010933","13.37","0.004","13.37","0.004","6.713","0.002","90","","90","","90","","1200","","","","","","","","","","","","synthetic","6","P 4/n :1","P 4ab -1ab","85","","Magnesium potassium bromide chloride hydrate (1/1/1.5/1.5/6)","Bromcarnallite","- Br1.5 Cl1.5 H12 K Mg O6 -","- Br1.5 Cl1.5 H12 K Mg O6 -","- Br6 Cl6 H48 K4 Mg4 O24 -","4","0.5","","Andress, K R; Saffe, O","Roentgenographische Untersuchung der Mischkristallreihe Karnallit- Bromkarnallit","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","451","469","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011041","11.986","","9.57","","9.95","","90","","85","","90","","1137","","","","","","","","","","","","containing) - synthetic from solution","5","C 1 2/m 1","-C 2y","12","","Dipotassium manganese sulfate tetrahydrate","Leonite (Mn)","- H8 K2 Mn O12 S2 -","- H8 K2 Mn O12 S2 -","- H32 K8 Mn4 O48 S8 -","4","0.5","","Anspach, H","Die Struktur des Mn-Leonit","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","39","77","","","","","","","","","","","","","","","","","","","","","","has coordinates","287518","2023-11-10","19:02:04",""
"1011042","6.02","","5.93","","6.02","","90","","67.87","","90","","199.1","","","","","","","","","","","","from Gudmundstorp, Sweden","3","P 1 21/c 1","-P 2ybc","14","","Iron antimony sulfide (1/1/1)","Gudmundite","- Fe S Sb -","- Fe S Sb -","- Fe4 S4 Sb4 -","4","1","","Buerger, M J","The Crystal Structure of Gudmundite (Fe Sb S) and its Bearing on the Existence Field of the Arsenopyrite Structural Type","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","290","316","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011125","6.13","","9.81","","11.4","","90","","90","","90","","685.5","","","","","","","","","","","","from Aurora mine, Kaveltorp, Sweden","3","P m m a","-P 2a 2a","51","","Copper(I) heptathiotetraferrate(III)","Valleriite","- Cu2 Fe4 S7 -","- Cu2 Fe4 S7 -","- Cu4 Fe8 S14 -","2","0.25","","Hiller, J E","Zur Kristallstruktur des Valleriits","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1939","101","","425","434","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""