# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-24T12:33:01+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 'Journal of Mineralogical and Petrological Sciences') AND volume = 111 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
"1544636","8.3428","0.0011","8.566","0.001","6.0769","0.0008","90","","90","","90","","434.28","0.1","","","","","","","","","","","","4","P n n m","-P 2 2n","58","Zn2AsO4(OH)","","Adamite","- As H O5 Zn2 -","- As H O5 Zn2 -","- As4 H4 O20 Zn8 -","4","0.5","","Jinnouchi, S.; Yoshiasa, A.; Sugiyama, K.; Shimura, R.; Arima, H.; Momma, K.; Miyawaki, R.","Crystal structure refinements of legrandite, adamite, and paradamite: The complex structure and characteristic hydrogen bonding network of legrandite","Journal of Mineralogical and Petrological Sciences","2016","111","","35","43","","","","","","","","","","","","","","","","","","","","","","has coordinates","287740","2023-11-22","19:37:36",""
"1544637","5.8438","0.0005","6.7226","0.0006","5.6566","0.0004","104.348","0.003","92.32","0.003","76.683","0.003","209.47","0.03","","","","","","","","","","","","4","P -1","-P 1","2","Zn2AsO4(OH)","","paradamite","- As H O5 Zn2 -","- As H O5 Zn2 -","- As2 H2 O10 Zn4 -","2","1","","Jinnouchi, S.; Yoshiasa, A.; Sugiyama, K.; Shimura, R.; Arima, H.; Momma, K.; Miyawaki, R.","Crystal structure refinements of legrandite, adamite, and paradamite: The complex structure and characteristic hydrogen bonding network of legrandite","Journal of Mineralogical and Petrological Sciences","2016","111","","35","43","","","","","","","","","","","","","","","","","","","","","","has coordinates","188589","2020-10-21","18:00:00",""
"1544638","12.8014","0.0011","7.939","0.0003","10.2262","0.0005","90","","104.49","0.002","90","","1006.23","0.11","","","","","","","","","","","Ojuela Mine, Mapimi, Durango, Mexico","4","P 1 21/c 1","-P 2ybc","14","Zn2AsO4(OH)*H2O","","legrandite","- As H3 O6 Zn2 -","- As H3 O6 Zn2 -","- As8 H24 O48 Zn16 -","8","2","","Jinnouchi, S.; Yoshiasa, A.; Sugiyama, K.; Shimura, R.; Arima, H.; Momma, K.; Miyawaki, R.","Crystal structure refinements of legrandite, adamite, and paradamite: The complex structure and characteristic hydrogen bonding network of legrandite","Journal of Mineralogical and Petrological Sciences","2016","111","","35","43","","","","","","","","","","","","","","","","","","","","","","has coordinates","282068","2023-03-26","10:12:03",""
"1544861","10.3417","0.0013","13.4837","0.0016","4.7756","0.0005","90","","105.306","0.004","90","","642.31","0.13","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","Zn1.62Fe1.38(AsO4)2*8H2O","","kottigite-parasymplesite solid solution","- As2 Fe1.38 H16 O16 Zn1.62 -","- As0.5 Fe0.313 H8 O7 Zn0.312 -","- As2 Fe1.252 H32 O28 Zn1.248 -","4","0.5","","Yoshiasa, A.; Miyano, Y.; Isobe, H.; Sugiyama, K.; Arima, H.; Nakatsuka, A.; Momma, K.; Miyawaki, R.","Structural refinement of kottigite-parasymplesite solid solution: Unique cation site occupancy and chemical bonding with water molecules","Journal of Mineralogical and Petrological Sciences","2016","111","","363","369","","","","","","","","","","","","","","","","","","","","","","has coordinates","189373","2020-10-21","18:00:00",""
"1544862","15.816","0.001","15.816","0.001","7.0944","0.0006","90","","90","","120","","1536.88","0.19","","","","","","","","","","","","7","R 3 m :H","R 3 -2""","160","Na0.70(Li0.60Al2.40)Al6(BO3)3(Si5.58B0.42O18)(OH)3O","","elbaitic tourmaline","- Al8.4 B3.42 H3 Li0.6 Na0.7 O31 Si5.58 -","- Al8.4 B3.42 H3 Li0.6 Na0.7 O31 Si5.58 -","- Al25.2 B10.26 H9 Li1.8 Na2.1 O93 Si16.74 -","3","0.166667","","Sugiyama, K.; Arima, H.; Konno, H.; Kawamata, T.","Distribution of Mn in pink elbaitic tourmaline from Mogok, Myanmar","Journal of Mineralogical and Petrological Sciences","2016","111","","1","8","","","","","","","","","","","","","","","","","","","","","","has coordinates","208816","2020-10-21","18:00:00",""