# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-08-10T20:04:59+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 'Journal of Structural Chemistry') AND volume = 14 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
"9009961","6.76","","11.12","","7.32","","90","","95","","90","","548.159","","","","","","","","","","","","","5","C 1 2/c 1","-C 2yc","15","","","Prosopite","- Al2 Ca F4 H4 O4 -","- Al2 Ca F4 H4 O4 -","- Al8 Ca4 F16 H16 O16 -","4","0.5","","Pudovkina, Z. V.; Chernitsova, N. M.; Pyatenko, Y. A.","Refinement of the crystalline structure of prosopite, CaAl2F4(OH)4","Journal of Structural Chemistry","1973","14","","345","347","10.1007/BF00739481","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:48",""
"9009962","5.02","","10.62","","8.73","","90","","102.7","","90","","454.031","","","","","","","","","","","","","5","P 1 21/c 1","-P 2ybc","14","","","Tikhonenkovite","- Al F4 H3 O2 Sr -","- Al F4 H3 O2 Sr -","- Al4 F16 H12 O8 Sr4 -","4","1","","Pudovkina, Z. V.; Chernitsova, N. M.; Pyatenko Yu, A.","Crystal structure refinement of tikhonenkovite Sr2[Al2F8(OH)2]*2H2O","Journal of Structural Chemistry","1973","14","","445","448","10.1007/BF00746997","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:48",""