# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-26T20:54:33+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 'Bulletin de Mineralogie') AND volume = 103 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
"1001782","10.086","0.003","13.441","0.004","4.703","0.002","90","","104.27","0.02","90","","617.9","","","","","","","","","","","","from Huanuni tin mine, Bolivia","4","C 1 2/m 1","-C 2y","12","","Triiron bis(phosphate(V)) octahydrate","Vivianite","- Fe3 H16 O16 P2 -","- Fe3 H16 O16 P2 -","- Fe6 H32 O32 P4 -","2","0.25","","Fejdi, P.; Poullen, J. F.; Gasperin, M.","Affinement de la structure de la vivianite Fe3(PO4)2*8H2O Locality: synthetic","Bulletin de Mineralogie","1980","103","","135","138","","","","","","","0.041","","","","","","","","","","","","","","","has coordinates","287555","2023-11-12","10:38:25",""
"1529743","8.294","","6.722","","11.198","","106.16","","92.94","","99.2","","588.904","","","","","","","","","","","","","4","P -1","-P 1","2","","Ca5 (H As O4)2 (As O4)2 (H2 O)9","","- As4 Ca5 H20 O25 -","- As4 Ca5 H14 O25 -","- As4 Ca5 H14 O25 -","1","0.5","","Catti, M.; Chiari, G.; Ferraris, G.","The structure of ferrarisite, Ca5 (H As O4)2 (As O4)2 (H2 O)9. Disorder, hydrogen bonding, and polymorphism with guerinite","Bulletin de Mineralogie (101,1978-)","1980","103","","541","546","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9009707","8.459","","7.613","","6.968","","82.21","","98.25","","95.86","","438.42","","","","","","","","","","","","","5","P -1","-P 1","2","","","Fluckite","- As2 Ca H6 Mn O10 -","- As2 Ca H6 Mn O10 -","- As4 Ca2 H12 Mn2 O20 -","2","1","","Catti, M.; Chiari, G.; Ferraris, G.","Fluckite, CaMn(HAsO4)2*2H2O, a structure related by pseudo-polytypism to krautite MnHAsO4*H2O Locality: Sainte Marie-aux-Mines, Alsace, France","Bulletin de Mineralogie","1980","103","","129","134","","","","","","","","","","","","","","","","","","","","","","has coordinates","287555","2023-11-12","10:38:27",""
"9009708","8.294","","6.722","","11.198","","106.16","","92.94","","99.2","","588.904","","","","","","","","","","","","","4","P -1","-P 1","2","","","Ferrarisite","- As4 Ca5 H15.16 O25 -","- As4 Ca5 H16 O25 -","- As4 Ca5 H16 O25 -","1","0.5","","Catti, M.; Chiari, G.; Ferraris, G.","The structure of ferrarisite, Ca5(HAsO4)2(AsO4)2*9H2O: disorder, hydrogen bonding, and polymorphism with guerinite Locality: Sainte Marie-aux-Mines, Alsace, France","Bulletin de Mineralogie","1980","103","","541","546","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:10",""
"9012086","10.599","","8.093","","10.085","","90","","103.42","","90","","841.447","","","","","","","","","","","","Shinkolobwe, Zaire","5","P 1 21/a 1","-P 2yab","14","","","Sengierite","- Cu H7 O10 U V -","- Cu H7 O10 U V -","- Cu4 H28 O40 U4 V4 -","4","1","","Piret, P.; Declercq, J. P.; Wauters-Stoop D","Structure cristalline de la sengierite","Bulletin de Mineralogie","1980","103","","176","178","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""