# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-10-06T10:17:41+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 'Annales Academiae Scientiarum Fennicae Series A6: Physica') 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
"9009733","6.2788","","6.2788","","6.2788","","90","","90","","90","","247.531","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","Sylvite","- Cl K -","- Cl K -","- Cl4 K4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009734","6.5847","","6.5847","","6.5847","","90","","90","","90","","285.501","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- Br K -","- Br K -","- Br4 K4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009735","7.0491","","7.0491","","7.0491","","90","","90","","90","","350.268","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- I K -","- I K -","- I4 K4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009736","6.579","","6.579","","6.579","","90","","90","","90","","284.76","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- Cl Rb -","- Cl Rb -","- Cl4 Rb4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009737","6.8768","","6.8768","","6.8768","","90","","90","","90","","325.206","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- Br Rb -","- Br Rb -","- Br4 Rb4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009738","7.3291","","7.3291","","7.3291","","90","","90","","90","","393.688","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- I Rb -","- I Rb -","- I4 Rb4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009739","7.156","","7.156","","7.156","","90","","90","","90","","366.447","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Br0.4 I0.6 Rb -","- Br0.4 I0.6 Rb -","- Br1.6 I2.4 Rb4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009740","6.7149","","6.7149","","6.7149","","90","","90","","90","","302.774","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Br0.4 Cl0.6 Rb -","- Br0.4 Cl0.6 Rb -","- Br1.6 Cl2.4 Rb4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009741","6.4958","","6.4958","","6.4958","","90","","90","","90","","274.093","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Cl K0.3 Rb0.7 -","- Cl K0.3 Rb0.7 -","- Cl4 K1.2 Rb2.8 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009742","6.8717","","6.8717","","6.8717","","90","","90","","90","","324.483","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Br0.4 I0.6 K -","- Br0.4 I0.6 K -","- Br1.6 I2.4 K4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009743","4.115","","4.115","","4.115","","90","","90","","90","","69.68","","","","","","","","","","","","","2","P m -3 m","-P 4 2 3","221","","","","- Cl Cs -","- Cl Cs -","- Cl Cs -","1","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009744","4.2812","","4.2812","","4.2812","","90","","90","","90","","78.469","","","","","","","","","","","","","2","F m -3 m","-F 4 2 3","225","","","","- Br Cs -","- Br Cs -","- Br4 Cs4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""
"9009745","4.2228","","4.2228","","4.2228","","90","","90","","90","","75.301","","","","","","","","","","","","","3","F m -3 m","-F 4 2 3","225","","","","- Br0.6 Cl0.4 Cs -","- Br0.6 Cl0.4 Cs -","- Br2.4 Cl1.6 Cs4 -","4","0.0208333","","Ahtee, M.","Lattice constants of some binary alkali halide solid solutions.","Annales Academiae Scientiarum Fennicae Series A6: Physica","1969","313","","1","11","10.1177/000271625731300103","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:32",""