# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-01T06:38: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 (149,1979-)') AND volume = 151 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
"8103474","8.216","","8.216","","7.414","","90","","90","","90","","500.465","","","","","","","","","","","","","3","P 4/m b m","-P 4 2ab","127","","Li5.56 Ni32 B15.44","","- B15.44 Li5.56 Ni32 -","- B15.44 Li5.56 Ni32 -","- B15.44 Li5.56 Ni32 -","1","0.0625","","Jung, W.","Die Kristallstruktur von Li3 Ni20 B6 und Li3 Ni16 B8","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","113","120","","","","","","","","","","","","","","","","","","","","","","has coordinates","176728","2020-10-21","18:00:00",""
"8103483","9.689","","9.689","","7.47","","90","","90","","120","","607.308","","","","","","","","","","","","","3","R -3 m :H","-R 3 2""","166","","Ba Ni12 B6","","- B6 Ba Ni12 -","- B6 Ba Ni12 -","- B18 Ba3 Ni36 -","3","0.0833333","","Jung, W.; Quentmeier, D.","Darstellung der ternaeren boride Sr Ni12 B6 und Ba Ni12 B6","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","121","128","","","","","","","","","","","","","","","","","","","","","","has coordinates","176466","2020-10-21","18:00:00",""
"8103485","10.029","","10.029","","14.533","","90","","90","","120","","1265.91","","","","","","","","","","","","","3","R -3 c :H","-R 3 2""c","167","","Ba2 Ni9 B6","","- B6 Ba2 Ni9 -","- B6 Ba2 Ni9 -","- B36 Ba12 Ni54 -","6","0.166667","","Quentmeier, D.; Jung, W.","The crystal structure of Ba2 Ni9 B6","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","172","174","10.1524/zkri.1980.151.1-2.172","","","","","","","","","","","","","","","","","","","","","has coordinates","176728","2020-10-21","18:00:00",""
"8103489","10.478","","10.478","","10.478","","90","","90","","90","","1150.36","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","Li3.0125 Ni19.9875 B6","","- B6 Li3.0125 Ni19.9875 -","- B6 Li3.017 Ni19.983 -","- B24 Li12.068 Ni79.932 -","4","0.0208333","","Jung, W.","Die Kristallstruktur von Li3 Ni20 B6 und Li3 Ni16 B8","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","113","120","","","","","","","","","","","","","","","","","","","","","","has coordinates","176728","2020-10-21","18:00:00",""
"8103490","9.59","","9.59","","7.455","","90","","90","","120","","593.766","","","","","","","","","","","","","3","R -3 m :H","-R 3 2""","166","","Sr Ni12 B6","","- B6 Ni12 Sr -","- B6 Ni12 Sr -","- B18 Ni36 Sr3 -","3","0.0833333","","Quentmeier, D.; Jung, W.","Darstellung der ternaeren Boride Sr Ni12 B6 und Ba Ni12 B6","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","121","128","","","","","","","","","","","","","","","","","","","","","","has coordinates","176466","2020-10-21","18:00:00",""
"8103593","7.4659","","7.4659","","7.4659","","90","","90","","90","","416.147","","","","","","","","","","","","","3","I -4 3 m","I -4 2 3","217","","Zn4 O (B O2)6","","- B6 O13 Zn4 -","- B6 O13 Zn4 -","- B12 O26 Zn8 -","2","0.0416667","","Smith Verdier, P.; Garcia-Blanco, S.","Redetermination of the structure of anhydrous zinc metaborate Zn4 O (B O2)6","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","175","177","","","","","","","","","","","","","","","","","","","","","","has coordinates","146245","2020-10-21","18:00:00",""
"8103605","8.429","","9.848","","6.756","","90","","109.65","","90","","528.148","","","","","","","","","","","","","2","P 1 21/a 1","-P 2yab","14","","","","- Bi Br3 -","- Bi Br3 -","- Bi4 Br12 -","4","1","","von Benda, H.","Zur Polymorphie des Wismuttribromids","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","271","285","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"8103606","7.249","","12.528","","6.849","","90","","110.68","","90","","581.918","","","","","","","","","","","","","2","C 1 2/m 1","-C 2y","12","","","","- Bi Br3 -","- Bi Br3 -","- Bi4 Br12 -","4","0.5","","von Benda, H.","Zur Polymorphie des Wismuttribromids","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","271","285","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"8103959","11.31","","14.48","","9.99","","90","","125.4","","90","","1333.59","","","","","","","","","","","","","5","P 1 21/a 1","-P 2yab","14","","Al3.80 Mg3.15 Fe1.05 (Si1.75 Al4.25 O20)","","- Al8.05 Fe1.05 Mg3.15 O20 Si1.75 -","- Al8.05 Fe1.05 Mg3.15 O20 Si1.75 -","- Al32.2 Fe4.2 Mg12.6 O80 Si7 -","4","1","","Merlino, S.","Crystal structure of sapphirine -1Tc","Zeitschrift fuer Kristallographie (149,1979-)","1980","151","","91","100","","","","","","","","","","","","","","","","","","","","","","has coordinates","176428","2020-10-21","18:00:00",""
"9008289","17.51","","6.822","","18.21","","90","","113.3","","90","","1997.84","","","","","","","","","","","","Astakos, Greece","5","C 1 2/c 1","-C 2yc","15","","","Gorgeyite","- Ca5 H2 K2 O25 S6 -","- Ca5 H2 K2 O25 S6 -","- Ca20 H8 K8 O100 S24 -","4","0.5","","Smith, G. W.; Walls, R.","The crystal structure of goergeyite K2SO4*5CaSO4*H2O","Zeitschrift fur Kristallographie","1980","151","","49","60","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47",""
"9008290","10.756","","10.756","","28.678","","90","","90","","120","","2873.3","","","","","","","","","","","","Cornwall, England","6","R -3 :H","-R 3","148","","","Chalcophyllite","- Al As2 Cu9 H48 O44 S1.5 -","- Al As2 Cu9 H48 O44 S1.5 -","- Al3 As6 Cu27 H144 O132 S4.5 -","3","0.166667","","Sabelli, C.","The crystal structure of chalcophyllite","Zeitschrift fur Kristallographie","1980","151","","129","140","","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:22",""
"9008291","8.098","","19.415","","9.059","","90","","91.96","","90","","1423.45","","","","","","","","","","","","Synthetic","3","P 1 n 1","P -2yac","7","","","Parapierrotite","- S8 Sb5 Tl -","- S8 Sb5 Tl -","- S32 Sb20 Tl4 -","4","2","","Engel, P.","Die kristallstruktur von synthetischem parapierrotit, TlSb5S8","Zeitschrift fur Kristallographie","1980","151","","203","216","","","","","","","","","","","","","","","","","","","","","","has coordinates","291455","2024-05-02","11:21:05",""
"9011430","9.97","","10.34","","8.62","","107.4","","95.2","","123.8","","666.618","","","","","","","","","","","","Wilson Lake, Labrador, Canada","5","P -1","-P 1","2","","","Sapphirine","- Al8.05 Fe1.05 Mg3.15 O20 Si1.75 -","- Al8.05 Fe1.05 Mg3.15 O20 Si1.75 -","- Al16.1 Fe2.1 Mg6.3 O40 Si3.5 -","2","1","","Merlino, S.","Crystal structure of sapphirine-1Tc Note: polytype sapphirine-1Tc","Zeitschrift fur Kristallographie","1980","151","","91","100","","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:47",""
"9011431","13.628","","11.943","","21.285","","90","","90.92","","90","","3463.88","","","","","","","","","","","","","3","C 1 2/c 1","-C 2yc","15","","","Heteromorphite","- Pb7 S19 Sb8 -","- Pb7 S19 Sb8 -","- Pb28 S76 Sb32 -","4","0.5","","Edenharter, A.","Die kristallstruktur von heteromorphit, Pb7Sb8S19","Zeitschrift fur Kristallographie","1980","151","","193","202","10.1524/zkri.1980.151.3-4.193","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:47",""
"9011432","5.9967","","5.9967","","5.9967","","105.87","","105.87","","105.87","","184.847","","","","","","","","","","","","Synthetic","3","R 3 m :R","P 3* -2","160","","","Ellisite","- As S3 Tl3 -","- As S3 Tl3 -","- As S3 Tl3 -","1","0.166667","","Gostojic, M.","Die kristallstruktur von synthetischem ellisit, Tl3AsS3 Note: anisob's corrected to match reported Biso's","Zeitschrift fur Kristallographie","1980","151","","249","254","","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:47",""
"9011433","11.362","","5.266","","12.655","","90","","108.16","","90","","719.463","","","","","","","","","","","","Tsumeb mine, Namibia","5","P 1 21 1","P 2yb","4","","","Queitite","- O15 Pb4 S Si3 Zn2 -","- O15 Pb4 S Si3 Zn2 -","- O30 Pb8 S2 Si6 Zn4 -","2","1","","Hess, H.; Keller, P.","Die kristallstruktur von queitit, Pb4Zn2[SO4|SiO4|Si2O7]","Zeitschrift fur Kristallographie","1980","151","","287","299","","","","","","","","","","","","","","","","","","","","","","has coordinates","291792","2024-05-09","08:53:47",""