# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-06-18T14:28:10+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 'International Journal of Coal Geology') 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
"9013067","4.4446","","5.4246","","3.3864","","90","","90","","90","","81.647","","","","","","","","","","","","Synthetic","2","P n n m","-P 2 2n","58","","","Marcasite","- Fe S2 -","- Fe S2 -","- Fe2 S4 -","2","0.25","","Rieder, M.; Crelling, J. C.; Sustai, O.; Drabek, M.; Weiss, Z.; Klementova, M.","Arsenic in iron disulfides in a brown coal from the North Bohemian Basin, Czech Republic Sample: As-free marcasite","International Journal of Coal Geology","2007","71","","115","121","10.1016/j.coal.2006.07.003","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""
"9013068","4.449","","5.432","","3.391","","90","","90","","90","","81.95","","","","","","","","","","","","Dul CSA mine, North Bohemian Basin, Czech Republic","3","P n n m","-P 2 2n","58","","","Marcasite","- As0.4 Fe S1.6 -","- As0.4 Fe S1.6 -","- As0.8 Fe2 S3.2 -","2","0.25","","Rieder, M.; Crelling, J. C.; Sustai, O.; Drabek, M.; Weiss, Z.; Klementova, M.","Arsenic in iron disulfides in a brown coal from the North Bohemian Basin, Czech Republic Sample: Natural As-marcasite","International Journal of Coal Geology","2007","71","","115","121","10.1016/j.coal.2006.07.003","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""
"9013069","5.416","","5.416","","5.416","","90","","90","","90","","158.868","","","","","","","","","","","","Synthetic","2","P a -3","-P 2ac 2ab 3","205","","","Pyrite","- Fe S2 -","- Fe S2 -","- Fe4 S8 -","4","0.166667","","Rieder, M.; Crelling, J. C.; Sustai, O.; Drabek, M.; Weiss, Z.; Klementova, M.","Arsenic in iron disulfides in a brown coal from the North Bohemian Basin, Czech Republic Sample: As-free pyrite","International Journal of Coal Geology","2007","71","","115","121","10.1016/j.coal.2006.07.003","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""
"9013070","5.428","","5.428","","5.428","","90","","90","","90","","159.926","","","","","","","","","","","","Synthetic","3","P a -3","-P 2ac 2ab 3","205","","","Pyrite","- As0.026 Fe S1.974 -","- As0.026 Fe S1.974 -","- As0.104 Fe4 S7.896 -","4","0.166667","","Rieder, M.; Crelling, J. C.; Sustai, O.; Drabek, M.; Weiss, Z.; Klementova, M.","Arsenic in iron disulfides in a brown coal from the North Bohemian Basin, Czech Republic Sample: As-pyrite","International Journal of Coal Geology","2007","71","","115","121","10.1016/j.coal.2006.07.003","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""
"9013071","5.429","","5.429","","5.429","","90","","90","","90","","160.015","","","","","","","","","","","","Dul CSA mine, North Bohemian Basin, Czech Republic","3","P a -3","-P 2ac 2ab 3","205","","","Pyrite","- As0.54 Fe S1.46 -","- As0.54 Fe S1.46 -","- As2.16 Fe4 S5.84 -","4","0.166667","","Rieder, M.; Crelling, J. C.; Sustai, O.; Drabek, M.; Weiss, Z.; Klementova, M.","Arsenic in iron disulfides in a brown coal from the North Bohemian Basin, Czech Republic Sample: natural As-pyrite","International Journal of Coal Geology","2007","71","","115","121","10.1016/j.coal.2006.07.003","","","","","","","","","","","","","","","","","","","","","has coordinates","291877","2024-05-16","06:53:48",""