# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-15T03:52:16+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 = 76 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
"1010621","6.3","","6.3","","6.3","","90","","90","","90","","250","","","","","","","","","","","","","4","P 4 b m","P 4 -2ab","100","","Ammonium chlorate(III)","","- Cl H4 N O2 -","- Cl H8 N O -","- Cl2 H16 N2 O2 -","2","0.25","","Levi, G R; Scherillo, A","Ricerche cristallografiche sui sali dell acido cloroso","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1931","76","","431","452","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1010960","14.66","","18.5","","5.33","","90","","93.27","","90","","1443.2","","","","","","","","","","","","from Thedford Mines, Canada","4","C 1 2/m 1","-C 2y","12","","Hexamagnesium closo-undecaoxodisilicate hexahydroxide hydrate","Chrysotile","- H8 Mg6 O18 Si4 -","- H8 Mg6 O18 Si4 -","- H32 Mg24 O72 Si16 -","4","0.5","","Warren, B E; Bragg, W L","The crystal structure of chrysotile H4 Mg3 Si2 O9","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1931","76","","201","210","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011048","8.75","","8.01","","7.72","","90","","90","","90","","541.1","","","","","","","","","","","","from Norway","4","P b n m","-P 2c 2ab","62","","Calcium borosilicate *","Danburite","- B2 Ca O8 Si2 -","- B2 Ca O8 Si2 -","- B8 Ca4 O32 Si8 -","4","0.5","","Dunbar, C; Machatschki, F","The Structure of Danburite, Ca B2 Si2 O8","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1931","76","","133","145","","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1011136","10.39","0.01","10.39","0.01","10.39","0.01","90","","90","","90","","1121.6","","","","","","","","","","","","from Scheelinger Kalk, Kaiserstuhl,Germany","9","F d -3 m :1","F 4d 2 3 -1d","227","","Sodium potassium calcium cerium iron(III) niobium oxide hydroxide fluoride (.38/.25/1.13/.25/.38/1.63/5.95/.8/.25)","Pyrochlore","- Ca1.125 Ce0.25 F0.25 Fe0.38 H0.8 K0.25 Na0.375 Nb1.63 O6.75 -","- Ca1.125 Ce0.25 F0.25 Fe0.375 H0.575 K0.25 Na0.375 Nb1.625 O6.75 -","- Ca9 Ce2 F2 Fe3 H4.6 K2 Na3 Nb13 O54 -","8","0.0416667","","Brandenberger, E","Die Kristallstruktur des Koppit","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1931","76","","322","334","","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1011268","9.75","0.01","12.204","0.02","4.429","0.01","90","","90","","90","","527","","","","","","","","","","","","from Langesundfjord, Norway","4","P b c a","-P 2ac 2ab","61","","Diberyllium borate hydroxide","Hambergite","- B Be2 H O4 -","- B Be2 H O4 -","- B8 Be16 H8 O32 -","8","1","","Zachariasen, W H","The crystalline structure of Hambergite Be2 B O3 (O H)","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (-144,1977)","1931","76","","289","302","","","","","","","","","","","","","","","","","","","","","","has coordinates","200452","2020-10-21","18:00:00",""