# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-12-22T05:24:07+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 'Strukturbericht') 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
"1510457","7.927","","7.927","","7.927","","90","","90","","90","","498.112","","","","","","","","","","","","","2","F d -3 m :1","F 4d 2 3 -1d","227","","Pb Au2","","- Au2 Pb -","- Au2 Pb -","- Au16 Pb8 -","8","0.0416667","","Perlitz, H.","The structure of the intermetallic compound Au2 Pb","Strukturbericht","1934","3","","612","612","","","","","","","","","","","","","","","","","","","","","","has coordinates","176432","2020-10-21","18:00:00",""
"5900000","5.89","","5.89","","5.89","","90","","90","","90","","204.34","","","","93","","","","","","","","","2","F m -3 m","","225","","Methane","","- C H4 -","- C H4 -","- C4 H16 -","4","0.0208333","","","","Strukturbericht","","1","","613","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900002","5.67","","5.67","","4.726","","90","","90","","90","","151.94","","","","","","","","","","","","","4","P -4 21 m","","113","","Diaminomethanal","","- C H4 N2 O -","- C N4 O -","- C2 N8 O2 -","2","0.25","","","","Strukturbericht","","3","","660","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900003","5.47","","7.64","","8.54","","90","","90","","90","","356.89","","","","","","","","","","","","","4","P b n m","","62","","Thiourea","","- C H4 N2 S -","- C H4 N2 S -","- C4 H16 N8 S4 -","4","0.5","","","","Strukturbericht","","2","","805","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900004","6.89","","6.96","","8.45","","90","","90","","90","","405.21","","","","","","","","","","","","","4","P 21 21 21","P 2ac 2ab","19","","Monomethylurea","","- C2 H6 N2 O -","- C2 H6 N2 O -","- C8 H24 N8 O4 -","4","1","","","","Strukturbericht","","3","","660","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900011","4.58","","13.31","","4.58","","90","","105.33","","90","","269.26","","","","","","","","","","","","","3","P 1 21/c 1","","14","","Diiodine acetylene","","- C2 H2 I2 -","- C2 I2 -","- C4 I4 -","2","0.5","","","","Strukturbericht","","3","","666","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900012","4.768","","12.897","","4.784","","90","","105.08","","90","","284.05","","","","","","","","","","","","","3","P 1 21/c 1","","14","","Diiodine ethylene","","- C2 H4 I2 -","- C2 I2 -","- C4 I4 -","2","0.5","","","","Strukturbericht","","3","","665","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900021","9.85","","9.85","","9.85","","90","","90","","90","","955.67","","","","","","","","","","","","","4","P 2 3","","195","","Tetramethyl silicate","","- C4 H12 O4 Si -","- C4 H12 O4 Si -","- C16 H48 O16 Si4 -","4","0.333333","","","","Strukturbericht","","2","","803","","","","","","","","","","","","","","","","","","","","","","","has coordinates","296823","2024-12-10","16:38:25",""
"5900032","6.546","","7.847","","6.086","","90","","90","","90","","312.62","","","","","","","","","","","","","3","P c a b","","61","","Ethanedioic acid of form alpha","","- C2 H2 O4 -","- C2 H2 O4 -","- C8 H8 O16 -","4","0.5","","","","Strukturbericht","","3","","671","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""
"5900033","5.3","","6.09","","5.51","","90","","115.5","","90","","160.52","","","","","","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","Ethanedioic acid of form beta","","- C2 H2 O4 -","- C2 H2 O4 -","- C4 H4 O8 -","2","0.5","","","","Strukturbericht","","3","","672","","","","","","","","","","","","","","","","","","","","","","","has coordinates","264769","2021-05-03","12:41:22",""