# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-12-06T02:38:49+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 'American Mineralogist') AND volume = 16 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 "1537441","10","","10","","6.3","","90","","90","","120","","545.596","","","","","","","","","","","","","3","P 3 2 1","P 3 2""","150","","Rb2 (S2 O6)","","- O6 Rb2 S2 -","- O6 Rb2 S2 -","- O18 Rb6 S6 -","3","0.5","","Huggins, M.L.; Frank, G.O.","The crystal structure of potassium dithionate, K2 S2 O6","American Mineralogist","1931","16","","580","591","","","","","","","","","","","","","","","","","","","","","","has coordinates","165588","2020-10-21","18:00:00","" "9000005","3.37","","4.44","","5.39","","90","","90","","90","","80.649","","","","","","","","","","","","Joplin, Missouri, USA","2","P m n n","-P 2n 2","58","","","Marcasite","- Fe S2 -","- Fe S2 -","- Fe2 S4 -","2","0.25","","Buerger, M. J.","The crystal structure of marcasite","American Mineralogist","1931","16","","361","395","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59","" "9000006","9.82","","9.82","","6.36","","90","","90","","120","","531.142","","","","","","","","","","","","","3","P 3 2 1","P 3 2""","150","Potassium dithionate","","","- K2 O6 S2 -","- K2 O6 S2 -","- K6 O18 S6 -","3","0.5","","Huggins, M. L.; Frank, G. O.","The crystal structure of potassium dithionate, K2S2O6 Note: coordinates revised according to Am Min 18 (1933) 455-457","American Mineralogist","1931","16","","580","591","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59","" "9000007","10","","10","","6.3","","90","","90","","120","","545.596","","","","","","","","","","","","","3","P 3 2 1","P 3 2""","150","Rubidium dithionate","","","- O6 Rb2 S2 -","- O6 Rb2 S2 -","- O18 Rb6 S6 -","3","0.5","","Huggins, M. L.; Frank, G. O.","The crystal structure of potassium dithionate, K2S2O6","American Mineralogist","1931","16","","580","591","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""