# Search results of SQL query from the Crystallography Open Database
# Date and time performed: 2024-05-17T13:18:43+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 'Bulletin de la Societe Chimique de France') 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
"9014112","10.501","","10.501","","11.555","","90","","90","","120","","1103.47","","","","","","","","","","","","Synthetic","3","R 3 m :H","R 3 -2""","160","","","Changbaiite","- Nb2 O6 Pb -","- Nb18 O54 Pb9 -","- Nb18 O54 Pb9 -","","","","Mahe, R.","Etude structurale du metaniobate de plombe rhomboedrique II. - Positions des atomes","Bulletin de la Societe Chimique de France","1967","1967","","1879","1884","","","","","","","","","","","","","","","","","","","","","","has coordinates","201816","2020-10-21","18:00:00",""
"9017391","12.0155","","5.6323","","9.9609","","90","","128.37","","90","","528.509","","","","","","","","","","","","Synthetic","3","C 1 2/c 1","-C 2yc","15","","","Lindbergite","- C2 Mn O6 -","- C8 Mn4 O24 -","- C8 Mn4 O24 -","","","","Deyrieux, R.; Berro, C.; Peneloux, A.","Contribution a l'etude des oxalates de certains metaux bivalents. III. - Structure cristalline des oxalates dihydrates de manganese, de cobalt, de nickel et de zinc. Polymorphisme des oxalates dihydrates de cobalt et de nickel","Bulletin de la Societe Chimique de France","1973","1973","","25","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:58",""
"9017392","11.775","","5.416","","9.859","","90","","127.85","","90","","496.467","","","","","","","","","","","","Synthetic","3","C 1 2/c 1","-C 2yc","15","","","","- C2 Co O6 -","- C8 Co4 O24 -","- C8 Co4 O24 -","","","","Deyrieux, R.; Berro, C.; Peneloux, A.","Contribution a l'etude des oxalates de certains metaux bivalents. III. - Structure cristalline des oxalates dihydrates de manganese, de cobalt, de nickel et de zinc. Polymorphisme des oxalates dihydrates de cobalt et de nickel","Bulletin de la Societe Chimique de France","1973","1973","","25","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:59",""
"9017393","11.7748","","5.3328","","9.8326","","90","","127.21","","90","","491.724","","","","","","","","","","","","Synthetic","3","C 1 2/c 1","-C 2yc","15","","","","- C2 Ni O6 -","- C8 Ni4 O24 -","- C8 Ni4 O24 -","","","","Deyrieux, R.; Berro, C.; Peneloux, A.","Contribution a l'etude des oxalates de certains metaux bivalents. III. - Structure cristalline des oxalates dihydrates de manganese, de cobalt, de nickel et de zinc. Polymorphisme des oxalates dihydrates de cobalt et de nickel","Bulletin de la Societe Chimique de France","1973","1973","","25","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:59",""
"9017394","11.8039","","5.4028","","9.9213","","90","","127.7","","90","","500.625","","","","","","","","","","","","Synthetic","3","C 1 2/c 1","-C 2yc","15","","","","- C2 O6 Zn -","- C8 O24 Zn4 -","- C8 O24 Zn4 -","","","","Deyrieux, R.; Berro, C.; Peneloux, A.","Contribution a l'etude des oxalates de certains metaux bivalents. III. - Structure cristalline des oxalates dihydrates de manganese, de cobalt, de nickel et de zinc. Polymorphisme des oxalates dihydrates de cobalt et de nickel","Bulletin de la Societe Chimique de France","1973","1973","","25","34","","","","","","","","","","","","","","","","","","","","","","has coordinates","282074","2023-03-27","07:57:59",""
"9017894","6.891","","7.624","","7.549","","90","","116.25","","90","","355.701","","","","","","","","","","","","Synthetic","4","C 1 2/c 1","-C 2yc","15","","","Kieserite","- H2 Mg O5 S -","- H2 Mg O5 S -","- H8 Mg4 O20 S4 -","4","0.5","","Coing-Boyat J","Remarques sur la structure commune de MgSO4*H2O et de CoSO4*H2O","Bulletin de la Societe Chimique de France","1971","1971","","3863","3865","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:53",""