# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-29T10:27:05+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 (101,1978-)') AND volume = 105 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 "1001783","7.84","0.01","9.11","0.01","4.67","0.01","95.04","0.01","96.94","0.01","107.72","0.01","312.6","","","","","","","","","","","","from Kamysch-Burun, USSR","4","P -1","-P 1","2","","Triiron bis(phosphate(V)) octahydrate","Metavivianite","- Fe3 H16 O16 P2 -","- Fe3 H16 O16 P2 -","- Fe3 H16 O16 P2 -","1","0.5","","Dormann, J.; Gasperin, M.; Poullen, J. F.","Etude structurale de la sequence d'oxydation de la vivianite Fe3(PO4)2*8(H2O)","Bulletin de Mineralogie","1982","105","","147","160","","","","","","","0.133","","","","","","","","","","","","","","","has coordinates","287555","2023-11-12","10:38:26","" "1529987","10.211","","13.335","","4.728","","90","","104.97","","90","","621.933","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","(Ni2.4 Mg.6) (As O4)2 (H2 O)8","","- As2 H16 Mg0.6 Ni2.4 O16 -","- As2 H16 Mg0.62 Ni2.38 O16 -","- As4 H32 Mg1.24 Ni4.76 O32 -","2","0.25","","Giuseppetti, G.; Tadini, C.","The crystal structure of cabrerite (Ni, Mg)3 (As O4)2 (H2 O)8 a variety of Annabergite","Bulletin de Mineralogie (101,1978-)","1982","105","","333","337","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "1530550","13.611","","18.227","","17.858","","90","","90","","90","","4430.35","","","","","","","","","","","","","5","F m m m","-F 2 2","69","","Na7.52 (Si28.44 Al7.56 O72) (H2 O)19.68","","- Al7.56 H39.36 Na7.52 O91.68 Si28.44 -","- Al7.56 Na7.52 O91.68 Si28.44 -","- Al15.12 Na15.04 O183.36 Si56.88 -","2","0.0625","","Passaglia, E.; Sacerdoti, M.","Crystal structural refinement of Na-exchanged stellerite","Bulletin de Mineralogie (101,1978-)","1982","105","","338","342","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00","" "9009713","17.06","","16.76","","7.023","","90","","90","","90","","2008.06","","","","","","","","","","","","Kobokobo pegmatite, Kivu, Zaire","4","P 21 m n","P -2ab 2ab","31","","","Vanmeersscheite","- H2 O10 P U2 -","- H2 O10 P U2 -","- H16 O80 P8 U16 -","8","2","","Piret, P.; Deliens, M.","La vanmeerscheite U(UO2)3(PO4)2(OH)6*4(H2O) et la meta-vanmeerscheite U(UO2)3(PO4)2(OH)6*2(H2O), nouveaux mineraux","Bulletin de Mineralogie","1982","105","","125","128","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47","" "9012087","13.86","","12.3","","14.92","","90","","90","","90","","2543.53","","","","","","","","","","","","Shinkolobwe, Shaba, Zaire","4","P n 21 a","P -2ac -2n","33","","","Becquerelite","- Ca H22 O30 U6 -","- Ca H22 O30 U6 -","- Ca4 H88 O120 U24 -","4","1","","Piret-Meunier J; Piret, P.","Nouvelle determination de la structure cristalline de la bequerelite","Bulletin de Mineralogie","1982","105","","606","610","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49",""