# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2026-01-21T10:41:41+01: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 'The Journal of Chemical Physics') AND volume = 4 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
"1011063","7.8","","4.5","","5.56","","90","","90","","90","","195.2","","","","","","","","","","","","synthetic","2","C 2 2 21","C 2c 2","20","","Dihydrogen oxide - ice II","Ice II ?","- H2 O -","- H2 O -","- H16 O8 -","8","1","","McFarlan, Ronald L.","The Structure of Ice II","The Journal of Chemical Physics","1936","4","1","60","64","10.1063/1.1749748","","","","","","","","","","","","","","","","","","","","","has coordinates","301772","2025-08-18","12:31:57",""