# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-21T14:42:09+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 'Neues Jahrbuch fuer Mineralogie. Monatshefte (Band=Jahr) (1950-)') AND volume = 1969 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
"1523973","3.113","","3.113","","15.61","","90","","90","","120","","131.006","","","","","","","","","","","","","5","P 63/m m c","-P 6c 2c","194","","(Mg6 Fe2 (O H)16 (C O3) (H2 O)4.5)0.25","","- C0.25 H4 Fe0.5 Mg1.5 O5.875 -","- C0.25 H4 Fe0.5 Mg1.5 O5.875 -","- C0.25 H4 Fe0.5 Mg1.5 O5.875 -","1","0.0416667","","Allmann, R.","Nachtrag zu den Strukturen des Pyroaurits und Sjoegrenits","Neues Jahrbuch fuer Mineralogie. Monatshefte (Band=Jahr) (1950-)","1969","1969","","552","558","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1525612","12.5755","","12.5755","","12.5755","","90","","90","","90","","1988.73","","","","","","","","","","","","","4","I a -3 d","-I 4bd 2c 3","230","","Ca3 Al2 (H O)12","","- Al2 Ca3 H12 O12 -","- Al2 Ca3 O12 -","- Al16 Ca24 O96 -","8","0.0833333","","Bartl, H.","Roentgen-Einkristalluntersuchungen an (Ca O)3 (Al2 O3) (H2 O)6 und an (Ca O)12 (Al2 O3)7 (H2 O), neuer Vorschlag zur (Ca O)12 (Al2 O3)7-Struktur","Neues Jahrbuch fuer Mineralogie. Monatshefte (Band=Jahr) (1950-)","1969","1969","","404","413","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1525613","11.98","","11.98","","11.98","","90","","90","","90","","1719.37","","","","","","","","","","","","","3","I -4 3 d","I -4bd 2c 3","220","","Ca12 Al14 O33 (H2 O)","","- Al14 Ca12 O31.9992 -","- Al14 Ca12 O31.9992 -","- Al28 Ca24 O63.9984 -","2","0.0416667","","Bartl, H.","Roentgen-Einkristalluntersuchungen an (Ca O)3 (Al2 O3) (H2 O)6 und an (Ca O)12 (Al2 O3)7 (H2 O), neuer Vorschlag zur (Ca O)12 (Al2 O3)7-Struktur","Neues Jahrbuch fuer Mineralogie. Monatshefte (Band=Jahr) (1950-)","1969","1969","","404","413","","","","","","","","","","","","","","","","","","","","","","has coordinates","146632","2020-10-21","18:00:00",""
"9009269","19.62","","9.81","","7.14","","90","","90","","120","","1190.14","","","","","","","","","","","","Caracoles, Chile","5","P 1 1 21/m","-P 2c","11","","","Caracolite","- Cl Na3 O12 Pb2 S3 -","- Cl Na3 O12 Pb2 S3 -","- Cl4 Na12 O48 Pb8 S12 -","4","1","","Schneider, W.","Bestimmung einer uberstruktur am caracolit","Neues Jahrbuch fur Mineralogie, Monatshefte","1969","1969","","58","64","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:30",""
"9009270","8.631","","8.631","","11.855","","90","","90","","120","","764.812","","","","","","","","","","","","Synthetic","3","R -3 c :H","-R 3 2""c","167","","","Takedaite","- B2 Ca3 O6 -","- B2 Ca3 O6 -","- B12 Ca18 O36 -","6","0.166667","","Schuckmann, W.","Zur kristallstruktur des calcium-borates Ca3(BO3)2","Neues Jahrbuch fur Mineralogie, Monatshefte","1969","1969","","142","144","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:30",""
"9009271","5.233","","10.541","","6.962","","106.9","","110.8","","72.1","","334.434","","","","","","","","","","","","","5","P -1","-P 1","2","","","Paravauxite","- Al2 Fe H18 O18 P2 -","- Al2 Fe H18 O18 P2 -","- Al2 Fe H18 O18 P2 -","1","0.5","","Baur, W. H.","The crystal structure of paravauxite, Fe2+Al2(PO4)2(OH)2(OH2)6*2H2O","Neues Jahrbuch fur Mineralogie, Monatshefte","1969","1969","","430","433","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:47",""
"9009272","3.054","","3.054","","22.81","","90","","90","","120","","184.244","","","","","","","","","","","","Vezna, Western Moravia","5","R -3 m :H","-R 3 2""","166","","","Hydrotalcite","- C0.167 H14 Al0.333 Mg0.667 O3 -","- C0.16666 H2.99996 Al0.33333 Mg0.66667 O2.99996 -","- C0.49998 H8.99988 Al0.99999 Mg2.00001 O8.99988 -","3","0.0833333","","Allmann, R.; Jepsen, H. P.","Die struktur des hydrotalkits","Neues Jahrbuch fur Mineralogie, Monatshefte","1969","1969","","544","551","","","","","","","","","","","","","","","","","","","","","","has coordinates","285095","2023-07-08","07:47:57",""