# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T17:53:41+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 'Tschermaks Mineralogische und Petrographische Mitteilungen (-1978)') AND volume = 22 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
"1523966","17.641","","18.031","","7.402","","90","","116.43","","90","","2108.37","","","","","","","","","","","","","4","C 1 2/m 1","-C 2y","12","","Na4.12 (Si36 O72) (H2 O)23.12","","- H46.24 Na4.12 O95.12 Si36 -","- Na4.12 O95.12 Si36 -","- Na4.12 O95.12 Si36 -","1","0.125","","Alberti, A.","The crystal structure of two clinoptilolites","Tschermaks Mineralogische und Petrographische Mitteilungen (-1978)","1975","22","","25","37","","","","","","","","","","","","","","","","","","","","","","has coordinates","144599","2020-10-21","18:00:00",""
"9009578","17.646","","17.898","","7.397","","90","","116.37","","90","","2093.09","","","","","","","","","","","","Agoura, California, USA","5","C 1 2/m 1","-C 2y","12","","","Clinoptilolite-Ca","- Al1.2 Ca1.58 H30 O46.9 Si16.8 -","- Al1.2 Ca1.58 H21.8 O46.9 Si16.8 -","- Al2.4 Ca3.16 H43.6 O93.8 Si33.6 -","2","0.25","","Alberti, A.","The crystal structure of two clinoptilolites","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","25","37","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:10",""
"9009579","17.641","","18.031","","7.402","","90","","116.43","","90","","2108.37","","","","","","","","","","","","Alpe di Siusi, Italy","5","C 1 2/m 1","-C 2y","12","","","Clinoptilolite-Na","- Al1.6 H30 Na2.06 O47.56 Si16.4 -","- Al1.6 H23.12 Na2.06 O47.56 Si16.4 -","- Al3.2 H46.24 Na4.12 O95.12 Si32.8 -","2","0.25","","Alberti, A.","The crystal structure of two clinoptilolites","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","25","37","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:10",""
"9009580","13.338","","13.338","","23.014","","90","","90","","120","","3545.72","","","","","","","","","","","","small cavity in andesite from Nurri, Nuoro, Sardinia","7","R -3 m :H","-R 3 2""","166","","","Levyne-Ca","- Al6.3 Ca2.759 H48 K0.215 Na0.677 O51.24 Si11.7 -","- Al6.3 Ca2.759 H30.48 K0.2145 Na0.6765 O51.24 Si11.7 -","- Al18.9 Ca8.277 H91.44 K0.6435 Na2.0295 O153.72 Si35.1 -","3","0.0833333","","Merlino, S.; Galli, E.; Alberti, A.","The crystal structure of levyne Note: a zeolite mineral","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","117","129","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:58",""
"9009581","14.069","","14.069","","14.069","","90","","90","","90","","2784.77","","","","","","","","","","","","Searles Lake, California, USA","5","F d -3 :2","-F 2uv 2vw 3","203","","","Northupite","- C2 Cl Mg Na3 O6 -","- C2 Cl Mg Na3 O6 -","- C32 Cl16 Mg16 Na48 O96 -","16","0.166667","","Dal Negro, A.; Giuseppetti, G.; Tadini, C.","Refinement of the crystal structure of northupite: Na3Mg(CO3)2Cl","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","158","163","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009582","8.592","","8.592","","5.573","","90","","90","","90","","411.413","","","","","","","","","","","","","3","P 42/m b c","-P 4c 2ab","135","","","Trippkeite","- As2 Cu O4 -","- As2 Cu O4 -","- As8 Cu4 O16 -","4","0.25","","Pertlik, F.","Verfeinerung der kristallstruktur von synthetischem trippkeit, CuAs2O4","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","211","217","10.1007/BF01087840","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009583","8.59","","8.59","","5.913","","90","","90","","90","","436.309","","","","","","","","","","","","Pernek, Slowakei, CSSR","3","P 42/m b c","-P 4c 2ab","135","","","Schafarzikite","- Fe O4 Sb2 -","- Fe O4 Sb2 -","- Fe4 O16 Sb8 -","4","0.25","","Fischer, R.; Pertlik, F.","Verfeinerung der kristallstruktur des schafarzikites, FeSb2O4","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","236","241","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:31",""
"9009584","3.796","","3.796","","16.36","","90","","90","","120","","204.158","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","","Covellite","- Cu S -","- Cu S -","- Cu6 S6 -","6","0.25","","Kalbskopf, R.; Pertlik, F.; Zemann, J.","Verfeinerung der kristallstruktur des covellins, CuS, mit einkristalldaten","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","242","249","","","","","","","","","","","","","","","","","","","","","","has coordinates","294031","2024-08-07","17:26:34",""
"9009585","15.874","","11.854","","6.605","","90","","95.43","","90","","1237.29","","","","","","","","","","","","Lavra da Ilha, Taquaral, Minas Gerais, Brazil","8","C 1 2/c 1","-C 2yc","15","","","Zanazziite","- Al0.67 Be2 Ca Fe0.6 H7 Mg1.4 O17 P3 -","- Al0.67 Be2 Ca Fe0.6 H7 Mg1.4 O17 P3 -","- Al2.68 Be8 Ca4 Fe2.4 H28 Mg5.6 O68 P12 -","4","0.5","","Fanfani, L.; Nunzi, A.; Zananni, P. F.; Zanzari, A. R.","The crystal structure of roscherite","Tschermaks Mineralogische und Petrographische Mitteilungen","1975","22","","266","277","","","","","","","","","","","","","","","","","","","","","","has coordinates","293658","2024-08-03","10:24:26",""