TOP SECRET//NIGINT//NONORM

On June 29 2023, racial affirmative action in college admissions was ruled illegal.
Computer Niggy Exploitation (CNE) reveals NYU continued anyway.

Raw Data (PII redacted)

Mirror 1 - Proton
Mirror 2 - MEGA

SAT

Reproduction
  • Asian
    select AVG(SATRD_HIGH_COMPOSITE_TOTAL) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=3) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_ETH_GRPS='A')) and SATRD_HIGH_COMPOSITE_TOTAL > 0;
  • White
    select AVG(SATRD_HIGH_COMPOSITE_TOTAL) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=6) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_ETH_GRPS='W')) and SATRD_HIGH_COMPOSITE_TOTAL > 0;
  • Hispanic
    select AVG(SATRD_HIGH_COMPOSITE_TOTAL) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=1) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_HSPN_Y_N='Y')) and SATRD_HIGH_COMPOSITE_TOTAL > 0;
  • Black
    select AVG(SATRD_HIGH_COMPOSITE_TOTAL) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=4) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_ETH_GRPS='B')) and SATRD_HIGH_COMPOSITE_TOTAL > 0;

ACT

Reproduction
  • Asian
    select AVG(ACT_COMP_HIGH_SCORE) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=3) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_ETH_GRPS='A')) and ACT_COMP_HIGH_SCORE > 0;
  • White
    select AVG(ACT_COMP_HIGH_SCORE) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=6) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_ETH_GRPS='W')) and ACT_COMP_HIGH_SCORE > 0;
  • Hispanic
    select AVG(ACT_COMP_HIGH_SCORE) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=1) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_HSPN_Y_N='Y')) and ACT_COMP_HIGH_SCORE > 0;
  • Black
    select AVG(ACT_COMP_HIGH_SCORE) from STDNT_TEST_SCORES_UG_ADM where EXISTS(select 1 from APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%') and (EXISTS(select 1 from PERSON where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_RACE_ETHNICITY=4) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=STDNT_TEST_SCORES_UG_ADM.EMPLID and NYU_APC_ETH_GRPS='B')) and ACT_COMP_HIGH_SCORE > 0;

GPA

Reproduction
  • White
    select AVG(CONVERT_GPA) from APPLICATION where PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%' and (EXISTS(select 1 from PERSON where EMPLID=APPLICATION.EMPLID and NYU_RACE_ETHNICITY=6) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=APPLICATION.EMPLID and NYU_APC_ETH_GRPS='W')) and CONVERT_GPA > 0;
  • Asian
    select AVG(CONVERT_GPA) from APPLICATION where PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%' and (EXISTS(select 1 from PERSON where EMPLID=APPLICATION.EMPLID and NYU_RACE_ETHNICITY=3) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=APPLICATION.EMPLID and NYU_APC_ETH_GRPS='A')) and CONVERT_GPA > 0;
  • Hispanic
    select AVG(CONVERT_GPA) from APPLICATION where PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%' and (EXISTS(select 1 from PERSON where EMPLID=APPLICATION.EMPLID and NYU_RACE_ETHNICITY=1) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=APPLICATION.EMPLID and NYU_APC_HSPN_Y_N='Y')) and CONVERT_GPA > 0;
  • Black
    select AVG(CONVERT_GPA) from APPLICATION where PROG_STATUS in ('AD','WT','AC') and ADMIT_TERM_SD like '2024%' and (EXISTS(select 1 from PERSON where EMPLID=APPLICATION.EMPLID and NYU_RACE_ETHNICITY=4) or EXISTS(select 1 from ADM_COMMON_APPLICATION where EMPLID=APPLICATION.EMPLID and NYU_APC_ETH_GRPS='B')) and CONVERT_GPA > 0;

TOP SECRET//NIGINT//NONORM