# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T09:55:14+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 'American Mineralogist') AND volume = 102 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
"1551077","9.6091","0.0002","12.4324","0.0002","2.8498","0.0001","90","","90","","90","","340.449","0.015","","","","","","","","","","","","3","P b a m","-P 2 2ab","55","Mg2Cr2O5","","Mg2Cr2O5 modified ludwigite","- Cr2 Mg2 O5 -","- Cr1.995 Mg2.005 O5 -","- Cr7.98 Mg8.02 O20 -","4","0.5","","Ishii, T.; Tsujino, N.; Arii, H.; Fujino, K.; Miyajima, N.; Kojitani, H.; Kunimoto, T.; Akaogi, M.","A shallow origin of so-called ultrahigh-pressure chromitites, based on single-crystal X-ray structure analysis of the high-pressure Mg2Cr2O5 phase, with modified ludwigite-type structure","American Mineralogist","2017","102","","2113","2118","","","","","","","","","","","","","","","","","","","","","","has coordinates","215348","2020-10-21","18:00:00",""
"1551886","8.4416","0.0005","10.8919","0.0007","7.2749","0.0004","90.465","0.002","113.158","0.002","78.08","0.002","599.74","0.06","100","2","100","2","","","","","","","Green River formation Uinta Co. Utah","4","P -1","-P 1","2","abelsonite","","abelsonite","- C31 H32 N4 Ni -","- C31 H32 N4 Ni -","- C31 H32 N4 Ni -","1","0.5","","Daniel R. Hummer; Bruce C. Noll; Robert M. Hazen; Robert T. Downs","Crystal structure of abelsonite, the only known crystalline geoporphyrin","American Mineralogist","2017","102","","1129","1132","10.2138/am-2017-5927","","","0.71073","MoKα","","0.0514","0.0406","","","0.0942","0.1019","","","","","","1.077","","","","has coordinates,has disorder","216528","2020-10-21","18:00:00",""
"9017144","5.0647","","8.7131","","9.3842","","90","","90","","90","","414.118","","","","","","","","","","","","basaltic scoria, Menan Volcanic Complex, Rexburg, Idaho","3","P n a 21","P 2c -2n","33","","","Luogufengite","- Al0.235 Fe1.765 O3 -","- Al1.88 Fe14.12 O24 -","- Al1.88 Fe14.12 O24 -","","","","Xu, H.; Lee, S.; Xu, H.","Luogufengite: A new nano-mineral of Fe2O3 polymorph with giant coercive field","American Mineralogist","2017","102","","711","719","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:23",""
"9017145","8.4416","","10.8919","","7.2749","","90.465","","113.158","","78.08","","599.743","","","","100","","","","","","","","Green River formation, Uintah County, Utah, USA","6","P -1","-P 1","2","","","Abelsonite","- C31 H32 Cr0.02 Fe0.05 N4 Ni0.93 -","- C31 H32 Cr0.02 Fe0.05 N4 Ni0.93 -","- C31 H32 Cr0.02 Fe0.05 N4 Ni0.93 -","","","","Hummer, D. R.; Noll, B. C.; Hazen, R. M.; Downs, R. T.","Crystal structure of abelsonite, the only known crystalline geoporphyrin Note: T = 100 K","American Mineralogist","2017","102","","1129","1132","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:23",""
"9017853","4.567","","12.803","","5.202","","90","","90","","90","","304.168","","","","","","","","","","","","Avacha Volcano, Kamchatka Peninsula, Russia","4","C m c m","-C 2c 2","63","","","Nataliyamalikite","- Br0.03 Cl0.02 I0.95 Tl -","- Br0.12 Cl0.08 I3.8 Tl4 -","- Br0.12 Cl0.08 I3.8 Tl4 -","","","","Okrugin, V.; Favero, M.; Liu, A.; Etschmann, B.; Plutachina, E.; Mills, S.; Tomkins, A. G.; Lukasheva, M.; Kozlov, V.; Moskaleva, S.; Chubarov, M.; Brugger, J.","Smoking gun for thallium geochemistry in volcanic arcs: Nataliyamalikite, TlI, a new thallium mineral from an active fumarole at Avacha Volcano, Kamchatka Peninsula, Russia Note: T = 100 (2) K","American Mineralogist","2017","102","","1736","1746","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","08:29:26",""