# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-06-01T16:26:56+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 'Journal of Applied Physics') AND volume = 51 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 "5910082","5.0079","0.0003","5.0079","0.0003","13.6467","0.0009","90","","90","","120","","296.39","0.03","","","","","","","","","","","synthetic","2","R -3 c :H","-R 3 2""c","167","","Iron(III) oxide - $-alpha","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe12 O18 -","6","0.166667","","Finger, L W; Hazen, R M","Crystal structure and isothermal compression of Fe2 O3, Cr2 O3, and V2 O3 to 50 kbars","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","0.026","","","","","","","","","","","","","","","has coordinates","201983","2020-10-21","18:00:00","" "9014269","4.9233","","4.9233","","13.4953","","90","","90","","120","","283.286","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Eskolaite","- Cr2 O3 -","- Cr2 O3 -","- Cr12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 40.6 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:17","" "9014850","4.9371","","4.9371","","13.53","","90","","90","","120","","285.609","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Eskolaite","- Cr2 O3 -","- Cr2 O3 -","- Cr12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 18.6 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9014880","5.0143","","5.0143","","13.6733","","90","","90","","120","","297.731","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 31.4 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9014893","4.9018","","4.9018","","13.969","","90","","90","","120","","290.675","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Karelianite","- O3 V2 -","- O3 V2 -","- O18 V12 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 47 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9014898","4.9199","","4.9199","","13.9787","","90","","90","","120","","293.029","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Karelianite","- O3 V2 -","- O3 V2 -","- O18 V12 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 28.3 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9015065","5.0249","","5.0249","","13.7163","","90","","90","","120","","299.932","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 15.4 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:18","" "9015503","5.002","","5.002","","13.6202","","90","","90","","120","","295.122","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 52.4 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19","" "9015569","4.9521","","4.9521","","14.0024","","90","","90","","120","","297.38","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Karelianite","- O3 V2 -","- O3 V2 -","- O18 V12 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 0.001 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292002","2024-05-23","10:01:19","" "9015778","4.9128","","4.9128","","13.4689","","90","","90","","120","","281.528","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Eskolaite","- Cr2 O3 -","- Cr2 O3 -","- Cr12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 56.8 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:53","" "9015964","5.0346","","5.0346","","13.7473","","90","","90","","120","","301.771","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 0.001 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54","" "9016457","5.0066","","5.0066","","13.6411","","90","","90","","120","","296.119","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Hematite","- Fe2 O3 -","- Fe2 O3 -","- Fe12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 43.9 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54","" "9016535","4.9322","","4.9322","","13.991","","90","","90","","120","","294.755","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Karelianite","- O3 V2 -","- O3 V2 -","- O18 V12 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 18.3 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:54","" "9016609","4.951","","4.951","","13.5656","","90","","90","","120","","287.975","","","","","","","","","","","","Synthetic","2","R -3 c :H","-R 3 2""c","167","","","Eskolaite","- Cr2 O3 -","- Cr2 O3 -","- Cr12 O18 -","6","0.166667","","Finger, L. W.; Hazen, R. M.","Crystal structure and isothermal compression of Fe2O3, Cr2O3, and V2O3 to 50 kbars Note: P = 0.001 kbar","Journal of Applied Physics","1980","51","","5362","5367","10.1063/1.327451","","","","","","","","","","","","","","","","","","","","","has coordinates","292100","2024-05-29","14:19:55",""