enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district ▲ school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2301881 2301881 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 spring grade_9_transitional                                                   0                                             0
2301882 2301882 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 spring grade_9_transitional                                                   0                                             0
2301883 2301883 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 spring grade_9_transitional                                                   0                                             0
2301884 2301884 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 spring grade_9_transitional                                                   0                                             0
2303290 2303290 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 spring kindergarten                                                   406                                             406
2303291 2303291 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 spring kindergarten                                                   0                                             0
2303292 2303292 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 spring kindergarten                                                   0                                             0
2303293 2303293 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring kindergarten                                                   0                                             0
2303294 2303294 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 spring kindergarten                                                   0                                             0
2303295 2303295 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 spring kindergarten                                                   0                                             0
2303296 2303296 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 spring kindergarten                                                   0                                             0
2303297 2303297 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 spring kindergarten                                                   0                                             0
2304703 2304703 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 spring pk_12_total 189.0 179.0 8.0 0.0   6.0     1.0   23.0   214.0 192.0     7.0       220.0         406 189 179 8 0   6     1   23   214 192     7   220       406
2304704 2304704 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 spring pk_12_total 356.0 430.0 17.0 0.0   6.0     0.0   31.0   425.0 415.0     1.0       419.0         840 356 430 17 0   6     0   31   425 415     1   419       840
2304705 2304705 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 spring pk_12_total 360.0 408.0 17.0 0.0   6.0     0.0   32.0   422.0 401.0     10.0       441.0         823 360 408 17 0   6     0   32   422 401     10   441       823
2304706 2304706 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring pk_12_total 627.0 850.0 23.0 1.0   18.0     1.0   31.0   769.0 782.0     7.0       724.0         1551 627 850 23 1   18     1   31   769 782     7   724       1551
2304707 2304707 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 spring pk_12_total 350.0 475.0 15.0 0.0   16.0     0.0   37.0   447.0 446.0     6.0       456.0         893 350 475 15 0   16     0   37   447 446     6   456       893
2304708 2304708 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 spring pk_12_total 115.0 126.0 5.0 0.0   2.0     1.0   6.0   135.0 120.0     0.0       114.0         255 115 126 5 0   2     1   6   135 120     0   114       255
2304709 2304709 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 spring pk_12_total 366.0 379.0 11.0 0.0   12.0     0.0   30.0   410.0 388.0     2.0       394.0         798 366 379 11 0   12     0   30   410 388     2   394       798
2304710 2304710 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 spring pk_12_total 4.0 5.0 0.0 0.0   0.0     0.0   0.0   9.0 0.0     0.0       4.0         9 4 5 0 0   0     0   0   9 0     0   4       9
2306116 2306116 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 spring pre_kindergarten                                                   0                                             0
2306117 2306117 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 spring pre_kindergarten                                                   0                                             0
2306118 2306118 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 spring pre_kindergarten                                                   0                                             0
2306119 2306119 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 spring pre_kindergarten                                                   0                                             0
2306120 2306120 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 spring pre_kindergarten                                                   0                                             0
2306121 2306121 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 spring pre_kindergarten                                                   223                                             223
2306122 2306122 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 spring pre_kindergarten                                                   0                                             0
2306123 2306123 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 spring pre_kindergarten                                                   0                                             0
2519279 2519279 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_1                                                   0                                             0
2519280 2519280 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_1                                                   0                                             0
2519281 2519281 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_1                                                   0                                             0
2519282 2519282 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_1                                                   0                                             0
2519283 2519283 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_1                                                   0                                             0
2519284 2519284 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_1                                                   0                                             0
2519285 2519285 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_1                                                   392                                             392
2519286 2519286 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_1                                                   0                                             0
2520696 2520696 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_10                                                   0                                             0
2520697 2520697 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_10                                                   0                                             0
2520698 2520698 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_10                                                   0                                             0
2520699 2520699 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_10                                                   420                                             420
2520700 2520700 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_10                                                   0                                             0
2520701 2520701 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_10                                                   0                                             0
2520702 2520702 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_10                                                   0                                             0
2520703 2520703 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_10                                                   0                                             0
2522113 2522113 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_11                                                   0                                             0
2522114 2522114 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_11                                                   0                                             0
2522115 2522115 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_11                                                   0                                             0
2522116 2522116 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_11                                                   387                                             387
2522117 2522117 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_11                                                   0                                             0
2522118 2522118 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_11                                                   0                                             0
2522119 2522119 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_11                                                   0                                             0
2522120 2522120 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_11                                                   0                                             0
2523530 2523530 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_12                                                   0                                             0
2523531 2523531 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_12                                                   0                                             0
2523532 2523532 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_12                                                   0                                             0
2523533 2523533 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_12                                                   367                                             367
2523534 2523534 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_12                                                   0                                             0
2523535 2523535 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_12                                                   0                                             0
2523536 2523536 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_12                                                   0                                             0
2523537 2523537 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_12                                                   0                                             0
2524947 2524947 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_2                                                   0                                             0
2524948 2524948 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_2                                                   0                                             0
2524949 2524949 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_2                                                   0                                             0
2524950 2524950 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_2                                                   0                                             0
2524951 2524951 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_2                                                   0                                             0
2524952 2524952 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_2                                                   0                                             0
2524953 2524953 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_2                                                   403                                             403
2524954 2524954 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_2                                                   0                                             0
2526364 2526364 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_3                                                   0                                             0
2526365 2526365 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_3                                                   0                                             0
2526366 2526366 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_3                                                   395                                             395
2526367 2526367 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_3                                                   0                                             0
2526368 2526368 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_3                                                   0                                             0
2526369 2526369 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_3                                                   0                                             0
2526370 2526370 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_3                                                   0                                             0
2526371 2526371 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_3                                                   0                                             0
2527781 2527781 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_4                                                   0                                             0
2527782 2527782 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_4                                                   0                                             0
2527783 2527783 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_4                                                   421                                             421
2527784 2527784 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_4                                                   0                                             0
2527785 2527785 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_4                                                   0                                             0
2527786 2527786 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_4                                                   0                                             0
2527787 2527787 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_4                                                   0                                             0
2527788 2527788 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_4                                                   0                                             0
2529198 2529198 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_5                                                   0                                             0
2529199 2529199 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_5                                                   0                                             0
2529200 2529200 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_5                                                   0                                             0
2529201 2529201 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_5                                                   0                                             0
2529202 2529202 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_5                                                   439                                             439
2529203 2529203 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_5                                                   0                                             0
2529204 2529204 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_5                                                   0                                             0
2529205 2529205 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_5                                                   0                                             0
2530615 2530615 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_6                                                   0                                             0
2530616 2530616 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_6                                                   0                                             0
2530617 2530617 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_6                                                   0                                             0
2530618 2530618 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_6                                                   0                                             0
2530619 2530619 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_6                                                   457                                             457
2530620 2530620 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_6                                                   0                                             0
2530621 2530621 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_6                                                   0                                             0
2530622 2530622 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_6                                                   0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);