# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-09-28T00:30:31+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 'Ferroelectrics') AND volume = 69 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
"1007236","18.32999","0.09","5.45","0.04","9.25","0.06","90","","90.14","0.08","90","","924.1","","","","","","","","","","","","","4","P 1 21/a 1","-P 2yab","14","","Caesium zinc phosphate(V) - III","","- Cs O4 P Zn -","- Cs O4 P Zn -","- Cs8 O32 P8 Zn8 -","8","2","","Blum, D; Durif, A; Averbuch-Pouchot, M T","Crystal structures of the three forms of Cs Zn P O4","Ferroelectrics","1986","69","","283","292","10.1080/00150198608008201","","","","","","0.043","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1007237","9.236","0.006","5.462","0.003","9.342","0.007","90","","90","","90","","471.3","","","","","","","","","","","","","4","P n 21 a","P -2ac -2n","33","","Caesium zinc phosphate(V) - II","","- Cs O4 P Zn -","- Cs O4 P Zn -","- Cs4 O16 P4 Zn4 -","4","1","","Blum, D; Durif, A; Averbuch-Pouchot, M T","Crystal structures of the three forms of Cs Zn P O4","Ferroelectrics","1986","69","","283","292","10.1080/00150198608008201","","","","","","0.041","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""
"1007238","9.194","0.003","5.49","0.002","9.388","0.004","90","","90","","90","","473.9","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","Caesium zinc phosphate(V) - I","","- Cs O4 P Zn -","- Cs O4 P Zn -","- Cs4 O16 P4 Zn4 -","4","0.5","","Blum, D; Durif, A; Averbuch-Pouchot, M T","Crystal structures of the three forms of Cs Zn P O4","Ferroelectrics","1986","69","","283","292","10.1080/00150198608008201","","","","","","0.042","","","","","","","","","","","","","","","has coordinates","130149","2020-10-21","18:00:00",""