# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-22T07:10:23+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 'Naturwissenschaften') AND volume = 27 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
"1010774","","","","","","","","","","","","","","","","","","","","","","","","","","6","","","","","Calcium phosphothiosilicate fluoride *","","- Ca10 F2 O24 P2 S2 Si2 -","","","","","","Klement, R","Isomorpher Ersatz des Phosphors in Apatiten durch Silicium und Schwefel","Naturwissenschaften","1939","27","","57","58","10.1007/BF01488937","","","","","","","","","","","","","","","","","","","","","","120071","2020-10-21","18:00:00",""
"1010775","12.18","","12.18","","18.82","","90","","90","","90","","2792","","","","","","","","","","","","","5","","","","","Iron hydrogen silicate tungstate hydrate *","","- Fe5 H105 O136 Si2 W24 -","","","1","","","Kraus, O","Die Basizitaet der Heteropolysaeuren- ein Strukturproblem","Naturwissenschaften","1939","27","","740","740","","","","","","","","","","","","","","","","","","","","","","","278158","2022-09-26","15:28:11",""
"1010969","","","","","","","","","","","","","","","","","","","","","","","","","","5","","","","","Calcium thiosilicate fluoride *","Ellestadite","- Ca10 F2 O24 S3 Si3 -","","","","","","Klement, R","Isomorpher Ersatz des Phosphors in Apatiten durch Silicium und Schwefel","Naturwissenschaften","1939","27","","57","58","10.1007/BF01488937","","","","","","","","","","","","","","","","","","","","","","120071","2020-10-21","18:00:00",""
"1011120","10.45","","10.45","","10.45","","24.13","","24.13","","24.13","","167.6","","","","","","","","","","","","synthetic","2","R -3 m :R","-P 3* 2","166","","Bismuth telluride","Tellurobismuthite","- Bi2 Te3 -","- Bi2 Te3 -","- Bi2 Te3 -","1","0.0833333","","Lange, P. W.","Ein vergleich zwischen Bi2Te3 und Bi2Te2S","Naturwissenschaften","1939","27","","133","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:11:44",""
"1011172","4.913","","4.913","","5.405","","90","","90","","120","","113","","","","","","","","","","","","","2","P 31 2 1","P 31 2""","152","","Silicon oxide $-alpha","Quartz low","- O2 Si -","- O2 Si -","- O6 Si3 -","3","0.5","","Brill, R; Hermann, C; Peters, C","Studien ueber chemische Bindung mittels Fourieranalyse III. Die Bindung im Quarz","Naturwissenschaften","1939","27","","676","677","10.1007/BF01494994","","","","","","","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1540232","3.023","","3.023","","3.023","","90","","90","","90","","27.626","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Ti Zn3 -","- Ti Zn3 -","- Ti Zn3 -","1","0.0208333","","Laves, F.; Wallbaum, H.J.","Zur Kristallchemie von Titan-Legierungen","Naturwissenschaften","1939","27","","674","675","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"9012420","10.31","","10.31","","10.31","","24.17","","24.17","","24.17","","161.469","","","","","","","","","","","","","3","R -3 m :R","-P 3* 2","166","","","Tetradymite","- Bi2 S Te2 -","- Bi2 S Te2 -","- Bi2 S Te2 -","1","0.0833333","","Lange, P. W.","Ein Vergleich zwischen Bi2Te3 und Bi2Te2S","Naturwissenschaften","1939","27","","133","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:47",""