# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-30T15:41:15+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 = 1997 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
"1509898","13.515","","4.098","","26","","90","","93","","90","","1438.02","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","Ag4.67 Pb0.5 Bi7.33 Sb1.5 S16","","- Ag4.67 Bi7.33 Pb0.5 S16 Sb1.5 -","- Ag4.66 Bi7.34 Pb0.5 S16 Sb1.5 -","- Ag9.32 Bi14.68 Pb S32 Sb3 -","2","0.25","","Ilinca, G.; Makovicky, E.","Note on the definition of borodayevite (Ag5 (Fe,Pb) Bi7)13 (Sb,Bi)2 S17","Neues Jahrbuch fuer Mineralogie. Monatshefte (Band=Jahr) (1950-)","1997","1997","","337","353","","","","","","","","","","","","","","","","","","","","","","has coordinates","176729","2020-10-21","18:00:00",""
"9009402","6.097","","7.145","","8.434","","76.54","","70.3","","70.75","","323.495","","","","","","","","","","","","Cerchiara mine, Val di Vara, northern Apennines, Italy","4","P -1","-P 1","2","","","Caoxite","- C2 H6 Ca O7 -","- C2 H6 Ca O7 -","- C4 H12 Ca2 O14 -","2","1","","Basso, R.; Lucchetti, G.; Zefiro, L.; Palenzona, A.","Caoxite, Ca(H2O)3(C2O4), a new mineral from the Cerchiara mine, northern Apennines, Italy","Neues Jahrbuch fur Mineralogie, Monatshefte","1997","1997","","84","96","","","","","","","","","","","","","","","","","","","","","","has coordinates","283850","2023-05-18","07:16:47",""
"9011760","6.971","","7.535","","10.881","","90","","107","","90","","546.567","","","","","","","","","","","","Hechtsberg quarry, Hausach, Black Forest, Germany","5","P 1 21/c 1","-P 2ybc","14","","","Hechtsbergite","- As0.03 Bi2 H O6 V0.97 -","- As0.03 Bi2 H O6 V0.97 -","- As0.12 Bi8 H4 O24 V3.88 -","4","1","","Krause, W.; Bernhardt, H. J.; Blass, G.; Effenberger, H.; Graf, H. W.","Hechtsbergite, Bi2O(OH)(VO4), a new mineral from the Black Forest, Germany","Neues Jahrbuch fur Mineralogie, Monatshefte","1997","1997","","271","287","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""
"9015048","13.515","","4.098","","26","","90","","93","","90","","1438.02","","","","","","","","","","","","Alyaskitovoye ore deposit, Yakutia","5","C 1 2/m 1","-C 2y","12","","","Borodaevite","- Ag4.5 Bi7.4 Pb0.6 S16 Sb1.5 -","- Ag4.5 Bi7.4 Pb0.6 S16 Sb1.5 -","- Ag9 Bi14.8 Pb1.2 S32 Sb3 -","2","0.25","","Ilinca, G.; Makovicky, E.","Note on the definition of borodayevite [Ag5(Fe,Pb)Bi7]13(Sb,Bi)2S17 Note: This structure is based on a theoretical construct, (11P), and is probably not an good model for borodayevite","Neues Jahrbuch fur Mineralogie, Monatshefte","1997","1997","","337","353","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18",""
"9015359","13.515","","4.098","","26","","90","","93","","90","","1438.02","","","","","","","","","","","","Alyaskitovoye ore deposit, Yakutia","5","C 1 2/m 1","-C 2y","12","","","Borodaevite","- Ag2.33 Bi3.67 Pb0.25 S8 Sb0.75 -","- Ag2.33 Bi3.67 Pb0.25 S8 Sb0.75 -","- Ag9.32 Bi14.68 Pb S32 Sb3 -","4","0.5","","Ilinca, G.; Makovicky, E.","Note on the definition of borodayevite [Ag5(Fe,Pb)Bi7]13(Sb,Bi)2S17 Note: This structure is based on a theoretical construct, (4,8L)","Neues Jahrbuch fur Mineralogie, Monatshefte","1997","1997","","337","353","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""
"9015584","15.207","","15.207","","10.114","","90","","90","","90","","2338.89","","","","","","","","","","","","Rocca Castellaccio, Val Malenco, Sondrio, Italy","4","I 41/a c d :2","-I 4bd 2c","142","","","Calzirtite","- Ca O8 Ti Zr2.5 -","- Ca O8 Ti Zr2.5 -","- Ca16 O128 Ti16 Zr40 -","16","0.5","","Callegari, A.; Mazzi, F.; Ungaretti, P.","The crystal structure of orthorhombic calzirtite from Val Malenco (Italy) Note: crystal n.2","Neues Jahrbuch fur Mineralogie, Monatshefte","1997","1997","","467","480","","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19",""
"9015700","15.207","","15.207","","10.114","","90","","90","","90","","2338.89","","","","","","","","","","","","Rocca Castellaccio, Val Malenco, Sondrio, Italy","4","P b c a","-P 2ac 2ab","61","","","Calzirtite","- Ca2 O16 Ti2 Zr5 -","- Ca2 O16 Ti2 Zr5 -","- Ca16 O128 Ti16 Zr40 -","8","1","","Callegari, A.; Mazzi, F.; Ungaretti, P.","The crystal structure of orthorhombic calzirtite from Val Malenco (Italy) Note: crystal n.2","Neues Jahrbuch fur Mineralogie, Monatshefte","1997","1997","","467","480","","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:53",""