Advanced Placement (AP) Participation

This dataset reports the number of students in all Massachusetts public schools who took one or more Advanced Placement (AP) exams since 2007. Results are disaggregated by test subject and student group.

Economically Disadvantaged was used 2015-2021. Low Income was used prior to 2015, and has been used again since 2022. Please see the <a href="https://www.doe.mass.edu/research/researchers.html" target="_blank" rel="noreferrer noopener">DESE Researcher's Guide</a> for more information.

This dataset contains the same data that is also published on our DESE Profiles site:

<a href="https://profiles.doe.mass.edu/statereport/ap_part.aspx" target="_blank" rel="noreferrer noopener">Advanced Placement Participation</a>

<b>List of AP Subjects</b>

Arts<ul><li>2-D Art and Design</li><li>3-D Art and Design</li><li>Drawing</li><li>Music Theory</li><li>Studio Art: 2-D Design</li><li>Studio Art: 3-D Design</li><li>Studio Art: Drawing</li></ul>English Language Arts<ul><li>English Lang/Comp</li><li>English Lit/Comp</li></ul>Foreign Languages<ul><li>Chinese Lang</li><li>French Lang</li><li>French Lit</li><li>German Lang</li><li>Italian Lang</li><li>Japanese Lang</li><li>Latin: Lit</li><li>Latin: Vergil</li><li>Spanish Lang</li><li>Spanish Lit</li></ul>History and Social Science<ul><li>Art History</li><li>Economics: Macro</li><li>Economics: Micro</li><li>Govt & Pol: Comp</li><li>Govt & Pol: U.S.</li><li>Govt RAD: Comp</li><li>Govt RAD: U.S.</li><li>History: European</li><li>History: U.S.</li><li>History: World</li><li>Human Geography</li><li>Psychology</li><li>World History: Modern</li></ul>Math and Computer Science<ul><li>Calculus AB</li><li>Calculus BC</li><li>Computer Sci A</li><li>Computer Sci AB</li><li>Computer Sci Principles</li><li>Statistics</li></ul>Science and Technology<ul><li>Biology</li><li>Chemistry</li><li>Environmental Sci</li><li>Physics 1</li><li>Physics 2</li><li>Physics B</li><li>Physics C: E</li><li>Physics C: E&M</li><li>Physics C: Mech</li></ul>Capstone<ul><li>Capstone Research</li><li>Capstone Seminar</li></ul>

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"educationtocareer-data-mass-gov/advanced-placement-ap-participation-37cp-pad8\".\"advanced_placement_ap_participation\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.