# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-11-02T11:14:53+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 'Nature (London)') AND volume = 187 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
"1511515","6.319","","6.319","","12.713","","90","","90","","120","","439.618","","","","","","","","","","","","","2","R -3 m :H","-R 3 2""","166","","Si B4","","- B4 Si -","- B3.99933 Si1.00067 -","- B35.994 Si9.006 -","9","0.25","","Brosset, C.; Magnusson, B.","The Silicon - Boron System","Nature (London)","1960","187","","54","55","10.1038/187054a0","","","","","","","","","","","","","","","","","","","","","has coordinates","176435","2020-10-21","18:00:00",""
"1528620","6.8","","6.8","","6.8","","90","","90","","90","","314.432","","","","","","","","","","","","","2","P 41 21 2","P 4abw 2nw","92","","","","- H2 O -","- H2 O -","- H24 O12 -","12","1.5","","Kamb, W.B.; Datta, S.K.","Crystal structures of the high-pressure froms of ice: Ice III","Nature (London)","1960","187","","140","141","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""