Students Facing Economic Hardship

State's description: accountability - Percent of Economically Disadvantaged students

Listed in the state's table index as rcd_acc_eds (active, 2017)

22,365 rows loaded, covering 2,965 schools and agencies, 2016–17 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 RcdAccEds(SRCBaseModel):
    agency_code = models.CharField(max_length=6)
    pct_eds = models.DecimalField(max_digits=4, decimal_places=1, null=True, blank=True)
    pct_eds_masking = models.CharField(max_length=1, null=True, blank=True)
    year = models.CharField(max_length=4)

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

3. 22,365 rows were then loaded from the state's raw data files into RcdAccEds.
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.