Student Enrollment

State's description: average daily membership

Listed in the state's table index as rcd_adm (active, 2016)

59,478 rows loaded, covering 3,130 schools and agencies, 2005–06 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 RcdAdm(SRCBaseModel):
    agency_code = models.CharField(max_length=6)
    avg_student_num = models.DecimalField(max_digits=38, decimal_places=0, null=True, blank=True)
    category_code = models.CharField(
        max_length=31,
        choices=[
            ("E", "Elementary"),
            ("M", "Middle School"),
            ("H", "High School"),
            ("A", "Elementary, Middle, High School"),
            ("T", "Middle, High School"),
            ("I", "Elementary, Middle school"),
        ],
    )
    year = models.CharField(max_length=4)

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

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