# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T11:46:04+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 'Tschermaks Mineralogische und Petrographische Mitteilungen') AND volume = 31 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
"1517796","4.808","0.001","4.808","0.001","16.022","0.003","90","","90","","120","","320.76","0.11","","","","","","","","","","","","4","R -3 :H","-R 3","148","","Magnesium Calcium Carbonate (.1/.9/1)","Dolomite","- C2 Ca Mg O6 -","- C2 Ca Mg O6 -","- C6 Ca3 Mg3 O18 -","3","0.166667","","Effenberger, H.; Kirfel, A.; Will, G.","Untersuchungen zur Elektronendichteverteilung im Dolomit Ca Mg (C O3)2","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1983","31","","151","164","","","","","","","0.018","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"9009614","5.894","","16.116","","4.612","","90","","106.54","","90","","419.956","","","","","","","","","","","","Mountain Pass mine, San Bernardino County, California","6","P 1 21/a 1","-P 2yab","14","","","Sahamalite-(Ce)","- C4 Ce Fe0.14 La Mg0.86 O12 -","- C4 Ce Fe0.14 La Mg0.86 O12 -","- C8 Ce2 Fe0.28 La2 Mg1.72 O24 -","2","0.5","","Pertlik, F.; Preisinger, A.","Crystal structure of sahamalite (Mg,Fe)RE2(CO3)4","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","31","","39","46","10.1007/BF01084760","","","","","","","","","","","","","","","","","","","","","has coordinates","288653","2024-01-03","17:00:04",""
"9009615","10.46","","10.46","","45.479","","90","","90","","120","","4309.28","","","","","","","","","","","","Tunugdliarfik, South Greenland","11","R -3 m :H","-R 3 2""","166","","","Steenstrupine-(Ce)","- Ca0.52 Ce3.9 Fe2 H10 La2.1 Mn2 Na13.48 O68.2 P5.44 Si13.38 Zr -","- Ca0.52 Ce3.9 Fe2 H6.38 La2.1 Mn2 Na13.48 O67.47 P5.44 Si13.38 Zr -","- Ca1.56 Ce11.7 Fe6 H19.14 La6.3 Mn6 Na40.44 O202.41 P16.32 Si40.14 Zr3 -","3","0.0833333","","Moore, P. B.; Shen, J.","Crystal structure of steenstrupine: A rod structure of unusual complexity","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","31","","47","67","","","","","","","","","","","","","","","","","","","","","","has coordinates","283911","2023-05-21","08:37:45",""
"9009616","7.25","","7.474","","6.909","","105.59","","112.81","","99.28","","317.198","","","","","","","","","","","","Synthetic","4","P -1","-P 1","2","","","Davanite","- K2 O15 Si6 Ti -","- K2 O15 Si6 Ti -","- K2 O15 Si6 Ti -","1","0.5","","Gebert, W.; Medenbach, O.; Florke, O. W.","Darstellung und kristallographie von K2TiSi6O15 - isotyp mit dalyit K2ZrSi6O15 Locality: synthetic","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","31","","69","79","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9011958","6.948","","14.089","","14.065","","90","","90","","90","","1376.83","","","","","","","","","","","","","6","P b c b","-P 2bc 2b","54","","","Tancoite","- Al H2 Li Na2 O9 P2 -","- Al H2 Li Na2 O9 P2 -","- Al8 H16 Li8 Na16 O72 P16 -","8","1","","Hawthorne, F. C.","The crystal structure of tancoite","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","31","","121","135","","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9011959","11.458","","5.052","","8.84","","90","","108.91","","90","","484.093","","","","","","","","","","","","Synthetic","6","P 1 21/a 1","-P 2yab","14","","","Reinhardbraunsite","- Ca5 F0.97 H1.26 O9.26 P0.04 Si1.96 -","- Ca5 F0.97 H1.26 O9.26 P0.04 Si1.96 -","- Ca10 F1.94 H2.52 O18.52 P0.08 Si3.92 -","2","0.5","","Kirfel, A.; Hamm, H. M.; Will, G.","The crystal structure of reinhardbraunsite, Ca5(SiO4)2(OH,F)2, a new mineral of the calcio-chondrodite type","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","31","","137","150","10.1007/BF01084766","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:45",""
"9017833","6.909","","7.401","","9.399","","110.72","","106.05","","92.2","","427.008","","","","","","","","","","","","Schneeberg, Sachsen, Germany","6","P -1","-P 1","2","","","Schumacherite","- As0.44 Bi3 H O10 P0.45 V1.1 -","- As0.44 Bi3 H O10 P0.45 V1.1 -","- As0.88 Bi6 H2 O20 P0.9 V2.2 -","2","1","","Walenta, K.; Dunn, P. J.; Hentschel, G.; Mereiter, K.","Schumacherit, ein neues Wismutmineral von Schneeberg in Sachsen Note: structure determined after the paper was published: Schumacherite, Bi3O(OH)((V0.55,As0.22,P0.23)O4)2, using a triclinic reduced cell instead of the non-reduced cell applied in the publication","Tschermaks Mineralogische und Petrographische Mitteilungen","1983","31","","165","173","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""