# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-30T19:23:20+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 'TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)') AND volume = 29 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
"1524099","11.335","","11.335","","11.335","","90","","90","","90","","1456.35","","","","","","","","","","","","","3","P a -3","-P 2ac 2ab 3","205","","U0.91 Te3 O8.85","","- O8.85 Te3 U0.91 -","- O8.85 Te3 U0.91 -","- O70.8 Te24 U7.28 -","8","0.333333","","Brandstaetter, F.","Non-stoichiometric, hydrothermally synthesized cliffordite","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1981","29","","1","8","","","","","","","","","","","","","","","","","","","","","","has coordinates","144764","2020-10-21","18:00:00",""
"1528385","9.738","","8.918","","5.248","","90","","106.08","","90","","437.924","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","Ca.89 Mg1.11 Si1.98 O6","","- Ca0.89 Mg1.11 O6 Si1.98 -","- Ca0.87 Mg1.13 O6 Si2 -","- Ca3.48 Mg4.52 O24 Si8 -","4","0.5","","Bruno, E.; Carbonin, S.; Molin, G.","Crystal structures of Ca-rich Clinopyroxenes on the Ca Mg Si2 O6 - Mg2 Si2 O6 join","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1982","29","","223","240","","","","","","","","","","","","","","","","","","","","","","has coordinates","150538","2020-10-21","18:00:00",""
"1528639","9.789","","9.882","","16.868","","90","","90","","89.95","","1631.72","","","","","","","","","","","","","5","P 1 1 21/a","-P 2ac","14","","Ba (U O2)2 (P O4)2 (H2 O)6","","- Ba H12 O18 P2 U2 -","- Ba O18 P2 U2 -","- Ba4 O72 P8 U8 -","4","1","","Khosrawan-Sazedj, F.","The crystal structure of meta-uranocircite II, Ba (U O2)2 (P O4)2 (H2 O)6","TMPM. Tschermaks Mineralogische und Petrographische Mitteilungen (1979-)","1982","29","","193","204","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9009605","7.255","","10.709","","8.746","","90","","90","","90","","679.51","","","","","","","","","","","","","4","P c c n","-P 2ab 2ac","56","","","Teschemacherite","- C H5 N O3 -","- C H5 N O3 -","- C8 H40 N8 O24 -","8","1","","Pertlik, F.","Verfeinerung der kristallstruktur des teschemacherits, (NH4)CO2(OH)","Tschermaks Mineralogische und Petrographische Mitteilungen","1981","29","","67","74","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009606","9.789","","9.882","","16.868","","90","","90","","89.95","","1631.72","","","","","","","","","","","","","5","P 1 1 21/a","-P 2ac","14","","","Metauranocircite II","- Ba0.92 H12 O18 P2 U2 -","- Ba0.92 H12 O18 P2 U2 -","- Ba3.68 H48 O72 P8 U8 -","4","1","","Khosrawan-Sazedj F","The crystal structure of meta-uranocircite II, Ba(UO2)2(PO4)2*6H2O Locality: synthetic","Tschermaks Mineralogische und Petrographische Mitteilungen","1982","29","","193","204","","","","","","","","","","","","","","","","","","","","","","has coordinates","287555","2023-11-12","10:38:27",""