# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-10-12T00:00:59+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 'Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)') AND volume = 148 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
"1008726","9.696","0.002","6.101","0.002","13.779","0.003","90","","91.83","0.02","90","","814.7","","","","","","","","","","","","synthetic","5","P 1 21/n 1","-P 2yn","14","","Disodium copper(II) carbonate trihydrate","Chalconatronite","- C2 H6 Cu Na2 O9 -","- C2 H10 Cu Na2 O9 -","- C8 H40 Cu4 Na8 O36 -","4","1","","Mosset, A; Bonnet, J J; Galy, J","Structure cristalline de la Chalconatronite synthetique. Na2 Cu (C O3)2 (H2 O)3","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","165","177","","","","","","","0.042","","","","","","","","","","","","","","","has coordinates","278158","2022-09-26","15:28:11",""
"8103424","7.438","","3.097","","4.899","","90","","105.47","","90","","108.762","","","","","","","","","","","","","2","P 1 2/m 1","-P 2y","10","","","","- Au Cd -","- Au Cd0.99 -","- Au3 Cd2.97 -","3","0.75","","Alasafi, K.M.; Schubert, K.","Crystal structure of Au1.1 Cd.9 (r)","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","179","191","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""
"8103724","3.665","","5.67","","5.358","","90","","90","","90","","111.342","","","","","","","","","","","","","3","I m 2 m","I -2 -2","44","","Na N O2","","- N Na O2 -","- N Na O2 -","- N2 Na2 O4 -","2","0.25","","Boehm, H.","X-ray structure determination of the modulated phase of Na N O2","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","207","220","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8103726","5.052","","5.052","","8.27","","90","","90","","120","","182.794","","","","","","","","","","","","","2","P 63/m m c","-P 6c 2c","194","","Si O2","","- O2 Si -","- O2 Si -","- O8 Si4 -","4","0.166667","","Kihara, K.","Thermal change in unit-cell dimensions, and a hexagonal structure of tridymite","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","237","253","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8103728","7.657","","8.588","","5.485","","90","","90","","90","","360.684","","","","","","","","","","","","","4","P n m a","-P 2ac 2n","62","","S C (N H2)2","","- C H4 N2 S -","- C H4 N2 S -","- C4 H16 N8 S4 -","4","0.5","","Mullen, D.; Heger, G.; Treutmann, W.","Refinement of the structure of thiourea. A neutron diffraction study at 293 K","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","95","100","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8103729","5.421","","9.353","","10.533","","90","","100.14","","90","","525.709","","","","","","","","","","","","","5","C 1 2/m 1","-C 2y","12","","K Mg2.5 Ge4 O10 F2","","- F2 Ge4 K Mg2.5 O10 -","- F2 Ge4 K Mg2.5 O10 -","- F4 Ge8 K2 Mg5 O20 -","2","0.25","","Toraya, H.; Iwai, S.I.; Marumo, F.; Hirao, M.","The crystal structures of germanate micas, K Mg2.5 Ge4 O10 F2 and K Li Mg2 Ge4 O10 F2","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","65","81","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8103730","5.395","","9.341","","10.547","","90","","99.87","","90","","523.646","","","","","","","","","","","","","6","C 1 2/m 1","-C 2y","12","","K Li Mg2 Ge4 O10 F2","","- F2 Ge4 K Li Mg2 O10 -","- F2 Ge4 K Li Mg2 O10 -","- F4 Ge8 K2 Li2 Mg4 O20 -","2","0.25","","Toraya, H.; Marumo, F.; Iwai, S.I.; Hirao, M.","The crystal structures of germanate micas, K Mg2.5 Ge4 O10 F2 and K Li Mg2 Ge4 O10 F2","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","65","81","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8103732","7.536","","6.029","","9.509","","90","","115.15","","90","","391.079","","","","","","","","","","","","","3","P 1 21/c 1","-P 2ybc","14","","Pb3 (As O4)2","","- As2 O8 Pb3 -","- As2 O8 Pb3 -","- As4 O16 Pb6 -","2","0.5","","Viswanathan, K.; Miehe, G.","The crystal structure of low temperature Pb3 (As O4)2","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","275","280","","","","","","","","","","","","","","","","","","","","","","has coordinates","156193","2020-10-21","18:00:00",""
"8104281","11.2","","3.987","","4.334","","90","","90","","90","","193.532","","","","","","","","","","","","","2","P n m a","-P 2ac 2n","62","","Sn S","","- S Sn -","- S Sn -","- S4 Sn4 -","4","0.5","","Wiedemeier, H.; von Schnering, H.G.","Refinement of the structures of Ge S, Ge Se, Sn S, and Sn Se","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","295","303","","","","","","","","","","","","","","","","","","","","","","has coordinates","176429","2020-10-21","18:00:00",""
"8104282","10.481","","3.646","","4.299","","90","","90","","90","","164.281","","","","","","","","","","","","","2","P n m a","-P 2ac 2n","62","","","","- Ge S -","- Ge S -","- Ge4 S4 -","4","0.5","","Wiedemeier, H.; von Schnering, H.G.","Refinement of the structures of Ge S, Ge Se, Sn S, and Sn Se","Zeitschrift fuer Kristallographie, Kristallgeometrie, Kristallphysik, Kristallchemie (145,1977-148,1979)","1978","148","","295","303","","","","","","","","","","","","","","","","","","","","","","has coordinates","211196","2020-10-21","18:00:00",""