enrollments

Data source: Big Local News · About: Big Local

44,816 rows where state = "LA" and year = 2020 sorted by district descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 44,716 ✖
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
612691 612691 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 spring grade_9_transitional                                                   0                                             0
612692 612692 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 spring grade_9_transitional                                                   0                                             0
612693 612693 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 spring grade_9_transitional                                                   0                                             0
612694 612694 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 spring grade_9_transitional                                                   0                                             0
614087 614087 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 spring kindergarten                                                   393                                             393
614088 614088 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 spring kindergarten                                                   0                                             0
614089 614089 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 spring kindergarten                                                   0                                             0
614090 614090 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring kindergarten                                                   0                                             0
614091 614091 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 spring kindergarten                                                   0                                             0
614092 614092 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 spring kindergarten                                                   0                                             0
614093 614093 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 spring kindergarten                                                   0                                             0
614094 614094 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 spring kindergarten                                                   0                                             0
615487 615487 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 spring pk_12_total 178.0 186.0 11.0 0.0   2.0     1.0   15.0   219.00000000000003 174.0     12.999999999999998       216.0         393 178 186 11 0   2     1   15     174         216       393
615488 615488 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 spring pk_12_total 344.0 470.0 18.0 0.0   10.0     1.0   33.0   436.0 440.0     2.0       477.0         876 344 470 18 0   10     1   33   436 440     2   477       876
615489 615489 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 spring pk_12_total 350.0 400.0 17.0 0.0   9.0     0.0   16.0   415.0 377.0     7.0       409.0         792 350 400 17 0   9     0   16   415 377     7   409       792
615490 615490 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring pk_12_total 636.0 853.0 33.0 1.0   17.0     1.0   40.0   783.0 798.0     11.0       775.0         1581 636 853 33 1   17     1   40   783 798     11   775       1581
615491 615491 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 spring pk_12_total 338.0 479.0 12.0 0.0   8.0     0.0   35.0   442.0 430.0     6.0       478.0         872 338 479 12 0   8     0   35   442 430     6   478       872
615492 615492 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 spring pk_12_total 110.0 131.0 6.0 0.0   3.0     0.0   10.0   152.0 108.0     0.0       141.0         260 110 131 6 0   3     0   10   152 108     0   141       260
615493 615493 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 spring pk_12_total 347.0 381.0 13.0 0.0   10.0     0.0   41.0   410.0 382.0     13.000000000000002       422.00000000000006         792 347 381 13 0   10     0   41   410 382                 792
615494 615494 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 spring pk_12_total 11.0 6.0 0.0 0.0   0.0     0.0   0.0   7.0 10.0     0.0       8.0         17 11 6 0 0   0     0   0   7 10     0   8       17
616887 616887 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 spring pre_kindergarten                                                   0                                             0
616888 616888 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 spring pre_kindergarten                                                   0                                             0
616889 616889 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 spring pre_kindergarten                                                   0                                             0
616890 616890 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 spring pre_kindergarten                                                   0                                             0
616891 616891 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 spring pre_kindergarten                                                   0                                             0
616892 616892 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 spring pre_kindergarten                                                   216                                             216
616893 616893 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 spring pre_kindergarten                                                   0                                             0
616894 616894 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 spring pre_kindergarten                                                   0                                             0
2012310 2012310 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_1                                                   0                                             0
2012311 2012311 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_1                                                   0                                             0
2012312 2012312 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_1                                                   0                                             0
2012313 2012313 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_1                                                   0                                             0
2012314 2012314 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_1                                                   0                                             0
2012315 2012315 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_1                                                   0                                             0
2012316 2012316 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_1                                                   416                                             416
2012317 2012317 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_1                                                   0                                             0
2013711 2013711 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_10                                                   0                                             0
2013712 2013712 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_10                                                   0                                             0
2013713 2013713 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_10                                                   0                                             0
2013714 2013714 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_10                                                   380                                             380
2013715 2013715 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_10                                                   0                                             0
2013716 2013716 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_10                                                   0                                             0
2013717 2013717 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_10                                                   0                                             0
2013718 2013718 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_10                                                   0                                             0
2015112 2015112 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_11                                                   0                                             0
2015113 2015113 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_11                                                   0                                             0
2015114 2015114 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_11                                                   0                                             0
2015115 2015115 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_11                                                   386                                             386
2015116 2015116 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_11                                                   0                                             0
2015117 2015117 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_11                                                   0                                             0
2015118 2015118 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_11                                                   0                                             0
2015119 2015119 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_11                                                   0                                             0
2016513 2016513 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_12                                                   0                                             0
2016514 2016514 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_12                                                   0                                             0
2016515 2016515 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_12                                                   0                                             0
2016516 2016516 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_12                                                   387                                             387
2016517 2016517 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_12                                                   0                                             0
2016518 2016518 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_12                                                   0                                             0
2016519 2016519 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_12                                                   0                                             0
2016520 2016520 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_12                                                   0                                             0
2017914 2017914 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_2                                                   0                                             0
2017915 2017915 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_2                                                   0                                             0
2017916 2017916 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_2                                                   0                                             0
2017917 2017917 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_2                                                   0                                             0
2017918 2017918 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_2                                                   0                                             0
2017919 2017919 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_2                                                   0                                             0
2017920 2017920 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_2                                                   388                                             388
2017921 2017921 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_2                                                   0                                             0
2019315 2019315 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_3                                                   0                                             0
2019316 2019316 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_3                                                   0                                             0
2019317 2019317 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_3                                                   406                                             406
2019318 2019318 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_3                                                   0                                             0
2019319 2019319 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_3                                                   0                                             0
2019320 2019320 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_3                                                   0                                             0
2019321 2019321 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_3                                                   0                                             0
2019322 2019322 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_3                                                   0                                             0
2020716 2020716 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_4                                                   0                                             0
2020717 2020717 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_4                                                   0                                             0
2020718 2020718 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_4                                                   399                                             399
2020719 2020719 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_4                                                   0                                             0
2020720 2020720 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_4                                                   0                                             0
2020721 2020721 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_4                                                   0                                             0
2020722 2020722 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_4                                                   0                                             0
2020723 2020723 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_4                                                   0                                             0
2022117 2022117 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_5                                                   0                                             0
2022118 2022118 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_5                                                   0                                             0
2022119 2022119 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_5                                                   0                                             0
2022120 2022120 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_5                                                   0                                             0
2022121 2022121 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_5                                                   438                                             438
2022122 2022122 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_5                                                   0                                             0
2022123 2022123 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_5                                                   0                                             0
2022124 2022124 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_5                                                   0                                             0
2023518 2023518 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_6                                                   0                                             0
2023519 2023519 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_6                                                   0                                             0
2023520 2023520 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_6                                                   0                                             0
2023521 2023521 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_6                                                   0                                             0
2023522 2023522 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_6                                                   434                                             434
2023523 2023523 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_6                                                   0                                             0
2023524 2023524 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_6                                                   0                                             0
2023525 2023525 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 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]);