COMMNUM community district identifer TOT80 total population, 1980 TOT90 total population, 1990 PW80 percentage nonhispanic white, 1980 PW90 percentage nonhispanic white, 1990 PB80,PB90,PH80,PH90,PA80,PA90 : equivalent variables for blacks, nonblack hispanics, asians W_HC anti-white hate crime, all perpetrators B_HC anti-black hate crime, all perpetrators H_HC anti-hispanic hate crime, all perpetrators A_HC anti-asian hate crime, all perpetrators UNEM80 unemployment rate, 1980 UNEM90 unemployment rate, 1990 nhwu80 nonhispanic white unemployment rate, 1980 nhwu90 nonhispanic white unemployment rate, 1990 brx,byn,man,qun,sta dummy variables for bronx,brooklyn,manhattan,queens,staten island chngwht change in white population proportion: pw90-pw80 chngblk change in black population proportion: pb90-pb80 chngasn change in asian population proportion: pa90-pa80 chnghsp change in hispanic population proportion: ph90-ph80 xblk interaction: pw80 * chngblk xasn interaction: pw80 * chngasn xhsp interaction: pw80 * chnghsp a_blk hate crimes: asian perp, black victim a_lat hate crimes: asian perp, latino victim a_wht hate crimes: asian perp, white victim b_l_wht hate crimes: black and latino perp, white victim b_asn hate crimes: black perp, asian victim b_lat hate crimes: black perp, latino victim b_wht hate crimes: black perp, white victim l_asn hate crimes: latino perp, asian victim l_blk hate crimes: latino perp, black victim l_wht hate crimes: latino perp, white victim uk_asn hate crimes: unknown perp, asian victim uk_blk hate crimes: unknown perp, black victim uk_lat hate crimes: unknown perp, latino victim uk_wht hate crimes: unknown perp, white victim w_asn hate crimes: white perp, black victim w_blk hate crimes: white perp, black victim w_lat hate crimes: white perp, black victim newahc anti-asian hate crime: unknown + white perps newbhc anti-black hate crime: unknown + white perps newlhc anti-latino hate crime: unknown + white perps COMMDIS another community district indicator ANHANH # households with asian/asian marriages ANHHIS # households with asian/latino marriages BNHANH # households with black/asian marriages BNHBNH # households with black/black marriages BNHHIS # households with black/latino marriages BNHWNH # households with black/white marriages HISHIS # households with latino/latino marriages TOTMAR # households with married couples WNHANH # households with white/asian marriages WNHHIS # households with white/latino marriages WNHWN # households with white/white marriages lntot90 log of total population Other tranformations: hate crime per capita make newa_pc=1000*newahc / tot90; make newl_pc=1000*newlhc / tot90; make newb_pc=1000*newlhc / tot90; change in unemployment, interactions make xnhwub =nhwu90*chngblk; make dnhwu =nhwu90-nhwu80; make xdnhub =dnhwu*chngblk; ethnic composition change in terms of logs of ratios make ratio_a=ln((1000+tot90*pa90)/(1000+tot80*pa80)); make ratioax=pw80*ratio_a; make ratio_h=ln((1000+tot90*ph90)/(1000+tot80*ph80)); make ratiohx=pw80*ratio_h; make ratio_b=ln((1000+tot90*pb90)/(1000+tot80*pb80)); make ratiobx=pw80*ratio_b;