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;
