# Search results of SQL query from the Crystallography Open Database # Date and time performed: 2024-11-28T12:15:58+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 'Neues Jahrbuch fur Mineralogie, Monatshefte') AND volume = 1971 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 "9009273","5.19182","","9.01535","","20.04577","","90","","95.7353","","90","","933.567","","","","","","","","","","","","Diamond mine, Black Hills, South Dakota, USA","6","C 1 2/c 1","-C 2yc","15","","","Muscovite-2M1","- Al2.87 Fe0.13 H2 K O12 Si3 -","- Al2.87 Fe0.13 H2 K O12 Si3 -","- Al11.48 Fe0.52 H8 K4 O48 Si12 -","4","0.5","","Rothbauer, R.","Untersuchung eines 2M1-muskovits mit neutronenstrahlen","Neues Jahrbuch fur Mineralogie, Monatshefte","1971","1971","","143","154","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:30","" "9009274","16","","6.676","","7.964","","90","","104.033","","90","","825.295","","","","","","","","","","","","","4","C 1 2/c 1","-C 2yc","15","","","","- B2 Ca H12 O10 -","- B2 Ca H12 O10 -","- B8 Ca4 H48 O40 -","4","0.5","","Wang, N.","A structure proposal for the phase beta-CaB2O4*6H2O","Neues Jahrbuch fur Mineralogie, Monatshefte","1971","1971","","315","325","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:47","" "9009275","10.232","","10.232","","10.232","","90","","90","","90","","1071.23","","","","","","","","","","","","","4","I -4 3 m","I -4 2 3","217","","","Tennantite","- As0.85 Cu3 S3 Sb0.15 -","- As0.85 Cu3 S3 Sb0.15 -","- As6.8 Cu24 S24 Sb1.2 -","8","0.166667","","Edenharter, A.; Koto, K.; Nowacki, W.","Uber pearceit, polybasit und binnit","Neues Jahrbuch fur Mineralogie, Monatshefte","1971","1971","","337","341","","","","","","","","","","","","","","","","","","","","","","has coordinates","291735","2024-05-06","08:06:30","" "9009276","13","","19.15","","4.3","","90","","90","","90","","1070.48","","","","","","","","","","","","","4","B b m m","-B 2 2b","63","","","Andorite VI","- Ag Pb S6 Sb3 -","- Ag Pb S6 Sb3 -","- Ag4 Pb4 S24 Sb12 -","4","0.25","","Kawada, I.; Hellner, E.","Die kristallstruktur der pseudozelle (sub cell) von andorit VI (ramdohrit)","Neues Jahrbuch fur Mineralogie, Monatshefte","1971","1971","","551","560","","","","","","","","","","","","","","","","","","","","","","has coordinates","294031","2024-08-07","17:26:34","" "9011738","6.976","","6.976","","16.235","","90","","90","","120","","684.22","","","","","","","","","","","","Andalusite mine, Mono Co., California, USA","6","R -3 m :H","-R 3 2""","166","","","Woodhouseite","- Al3 Ca H6 O14 P S -","- Al3 Ca H6 O14 P S -","- Al9 Ca3 H18 O42 P3 S3 -","3","0.0833333","","Kato, T.","The crystal structures of goyazite and woodhousite","Neues Jahrbuch fur Mineralogie, Monatshefte","1971","1971","","241","247","","","","","","","","","","","","","","","","","","","","","","has coordinates","283658","2023-05-10","17:55:49","" "9011739","7.021","","7.021","","16.505","","90","","90","","120","","704.602","","","","","","","","","","","","Palermo mine, North Groton, New Hampshire, USA","5","R -3 m :H","-R 3 2""","166","","","Goyazite","- Al3 H16.98 O14 P2 Sr -","- Al3 H7.02 O14 P2 Sr -","- Al9 H21.06 O42 P6 Sr3 -","3","0.0833333","","Kato, T.","The crystal structures of goyazite and woodhousite","Neues Jahrbuch fur Mineralogie, Monatshefte","1971","1971","","241","247","","","","","","","","","","","","","","","","","","","","","","has coordinates","283866","2023-05-18","12:54:11",""