# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-20T11:47:03+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 = 38 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
"1535828","7.124","","7.124","","84.1","","90","","90","","120","","3696.36","","","","","","","","","","","","","4","R 3 :H","R 3","146","","(Ce F (C O3))2 (Ca (C O3))","","- C Ca Ce2 F2 -","- C Ca Ce2 F2 -","- C18 Ca18 Ce36 F36 -","18","2","","Donnay, G.; Donnay, J.D.H.","The crystallography of bastnaesite, parisite, roentgenite, and synchisite","American Mineralogist","1953","38","","932","963","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1535831","7.131","","7.131","","69.39999","","90","","90","","120","","3056.26","","","","","","","","","","","","","4","R 3 :H","R 3","146","","(Ce F (C O3))3 (Ca C O3)2","","- C Ca2 Ce3 F3 -","- C Ca2 Ce3 F3 -","- C9 Ca18 Ce27 F27 -","9","1","","Donnay, G.; Donnay, J.D.H.","The crystallography of bastnaesite, parisite, roentgenite, and synchisite","American Mineralogist","1953","38","","932","963","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"1538515","3.073","","3.073","","47.75299","","90","","90","","120","","390.532","","","","","","","","","","","","","2","P 3 m 1","P 3 -2""","156","","Si C","","- C Si -","- C Si -","- C19 Si19 -","19","3.16667","","Ramsdell, L.S.; Mitchell, R.S.","A new hexagonal polymorph of silicon carbide, 19H","American Mineralogist","1953","38","","56","59","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"9000053","3.079","","3.079","","47.849","","90","","90","","120","","392.846","","","","","","","","","","","","","2","P 3 m 1","P 3 -2""","156","SiC-19H","","","- C19 Si19 -","- C19 Si19 -","- C19 Si19 -","1","0.166667","","Ramsdell, L. S.; Mitchell, R. S.","A new hexagonal polymorph of silicon carbide, 19H","American Mineralogist","1953","38","","56","59","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000054","5.332","","5.06","","12.02","","90","","90","","90","","324.299","","","","","","","","","","","","","3","P n c a","-P 2a 2n","60","","","Pucherite","- Bi O4 V -","- Bi O4 V -","- Bi4 O16 V4 -","4","0.5","","Qurashi, M. M.; Barnes, W. H.","The structure of pucherite, BiVO4","American Mineralogist","1953","38","","489","500","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000055","7.789","","7.789","","5.018","","90","","90","","90","","304.435","","","","","","","","","","","","","7","P -4 21 m","P -4 2ab","113","","","Melilite","- Al0.4 Ca1.7 K0.1 Mg0.5 Na0.2 O7 Si2 -","- Al0.4 Ca1.7 K0.1 Mg0.5 Na0.2 O7 Si2 -","- Al0.8 Ca3.4 K0.2 Mg Na0.4 O14 Si4 -","2","0.25","","Smith, J. V.","Reexamination of the crystal structure of melilite","American Mineralogist","1953","38","","643","661","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000056","7.16","","7.16","","9.79","","90","","90","","120","","434.65","","","","","","","","","","","","","4","P -6 2 c","P -6c -2c","190","","","Bastnasite-(Ce)","- C Ce F O3 -","- C Ce F O3 -","- C6 Ce6 F6 O18 -","6","0.5","","Donnay, G.; Donnay, J. D. H.","The crystallography of bastnaesite, parasite, roentgenite, and synchisite","American Mineralogist","1953","38","","932","963","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000057","7.12","","7.12","","84.1","","90","","90","","120","","3692.21","","","","","","","","","","","","","5","R 3 :H","R 3","146","","","Parisite-(Ce)","- C3 Ca Ce2 F2 O9 -","- C Ca Ce2 F2 O3 -","- C18 Ca18 Ce36 F36 O54 -","18","2","","Donnay, G.; Donnay, J. D. H.","The crystallography of bastnaesite, parasite, roentgenite, and synchisite","American Mineralogist","1953","38","","932","963","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000058","7.13","","7.13","","69.4","","90","","90","","120","","3055.41","","","","","","","","","","","","","5","R 3 :H","R 3","146","","","Rontgenite-(Ce)","- C5 Ca2 Ce3 F3 O15 -","- C Ca2 Ce3 F3 O3 -","- C9 Ca18 Ce27 F27 O27 -","9","1","","Donnay, G.; Donnay, J. D. H.","The crystallography of bastnaesite, parasite, roentgenite, and synchisite","American Mineralogist","1953","38","","932","963","","","","","","","","","","","","","","","","","","","","","","has coordinates","291269","2024-04-18","16:13:59",""
"9000059","4.54","","9.97","","3.03","","90","","90","","90","","137.149","","","","","","","","","","","","","4","P b n m","-P 2c 2ab","62","","","Montroseite","- Fe0.125 H O2 V0.875 -","- Fe0.125 H O2 V0.875 -","- Fe0.5 H4 O8 V3.5 -","4","0.5","","Evans, H. T.; Block, S.","The crystal structure of montroseite, a vanadium member of the diaspore group","American Mineralogist","1953","38","","1242","1250","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:51:29",""