AP Exam Performance

State's description: AP score percentages and participation rates

Listed in the state's table index as rcd_ap (active, 2014)

6,308 rows loaded, covering 793 schools and agencies, 2013–14 to 2023–24.

1. The state publishes an Excel data dictionary. This demo reads it: 66 table definitions, 525 column definitions, and 181 code definitions — the same ones behind the Decoded view above.
2. From those definitions it writes a Django database model for each table, so nobody has to type the columns in by hand. This table's model came out like this:

class RcdAp(SRCBaseModel):
    agency_code = models.CharField(max_length=6)
    category_code = models.CharField(
        max_length=31,
        null=True,
        blank=True,
        choices=[
            ("E", "Elementary"),
            ("M", "Middle School"),
            ("H", "High School"),
            ("A", "Elementary, Middle, High School"),
            ("T", "Middle, High School"),
            ("I", "Elementary, Middle school"),
        ],
    )
    part_mask_code = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    pass_mask_code = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    pct_ap_participation = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    pct_ap_pass = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    year = models.CharField(max_length=4)

    class Meta:
        db_table = "rcd_ap"
        managed = True
        unique_together = ("year", "agency_code")

3. 6,308 rows were then loaded from the state's raw data files into RcdAp.
4. It also takes a fingerprint (SHA-256) of the dictionary's general-rules sheet. If the state quietly rewrites its rules document, the next rebuild flags the change instead of absorbing it silently.