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
2532032 2532032 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_7                                                   0                                             0
2532033 2532033 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_7                                                   422                                             422
2532034 2532034 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_7                                                   0                                             0
2532035 2532035 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532036 2532036 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_7                                                   0                                             0
2532037 2532037 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_7                                                   0                                             0
2532038 2532038 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_7                                                   0                                             0
2532039 2532039 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_7                                                   0                                             0
2533449 2533449 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_8                                                   0                                             0
2533450 2533450 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_8                                                   414                                             414
2533451 2533451 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_8                                                   0                                             0
2533452 2533452 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_8                                                   0                                             0
2533453 2533453 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_8                                                   0                                             0
2533454 2533454 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_8                                                   0                                             0
2533455 2533455 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_8                                                   0                                             0
2533456 2533456 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_8                                                   0                                             0
2534866 2534866 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_9                                                   0                                             0
2534867 2534867 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_9                                                   0                                             0
2534868 2534868 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_9                                                   0                                             0
2534869 2534869 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_9                                                   382                                             382
2534870 2534870 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_9                                                   0                                             0
2534871 2534871 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_9                                                   0                                             0
2534872 2534872 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_9                                                   0                                             0
2534873 2534873 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_9                                                   0                                             0
2536283 2536283 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_9_transitional                                                   0                                             0
2536284 2536284 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_9_transitional                                                   0                                             0
2536285 2536285 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_9_transitional                                                   0                                             0
2536286 2536286 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_9_transitional                                                   33                                             33
2536287 2536287 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_9_transitional                                                   0                                             0
2536288 2536288 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_9_transitional                                                   0                                             0
2536289 2536289 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_9_transitional                                                   0                                             0
2536290 2536290 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_9_transitional                                                   0                                             0
2537700 2537700 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall kindergarten                                                   394                                             394
2537701 2537701 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall kindergarten                                                   0                                             0
2537702 2537702 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall kindergarten                                                   0                                             0
2537703 2537703 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall kindergarten                                                   0                                             0
2537704 2537704 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall kindergarten                                                   0                                             0
2537705 2537705 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall kindergarten                                                   0                                             0
2537706 2537706 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall kindergarten                                                   0                                             0
2537707 2537707 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall kindergarten                                                   0                                             0
2539117 2539117 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall pk_12_total 182.0 180.0 6.0 0.0   6.0     1.0   19.0   207.0 187.0     1.0       208.0         394 182 180 6 0   6     1   19   207 187     1   208       394
2539118 2539118 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall pk_12_total 352.0 427.0 18.0 0.0   7.0     0.0   32.0   425.0 411.0     2.0       419.0         836 352 427 18 0   7     0   32   425 411     2   419       836
2539119 2539119 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall pk_12_total 359.0 401.0 16.0 0.0   7.0     0.0   33.0   415.0 401.0     3.0       429.0         816 359 401 16 0   7     0   33   415 401     3   429       816
2539120 2539120 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall pk_12_total 639.0 871.0 26.0 1.0   18.0     1.0   33.0   789.0 799.9999999999999     8.0       742.0         1589 639 871 26 1   18     1   33   789       8   742       1589
2539121 2539121 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall pk_12_total 350.0 477.0 15.0 0.0   18.0     0.0   36.0   453.0 443.0     6.0       454.0         896 350 477 15 0   18     0   36   453 443     6   454       896
2539122 2539122 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall pk_12_total 115.0 122.0 5.0 0.0   2.0     1.0   6.0   133.0 118.0     0.0       111.0         251 115 122 5 0   2     1   6   133 118     0   111       251
2539123 2539123 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall pk_12_total 366.0 377.0 11.0 0.0   12.0     0.0   29.0   410.0 385.0     2.0       394.0         795 366 377 11 0   12     0   29   410 385     2   394       795
2539124 2539124 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall pk_12_total 3.0 6.0 0.0 0.0   0.0     0.0   0.0   8.0 1.0     0.0       4.0         9 3 6 0 0   0     0   0   8 1     0   4       9
2540534 2540534 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall pre_kindergarten                                                   0                                             0
2540535 2540535 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall pre_kindergarten                                                   0                                             0
2540536 2540536 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall pre_kindergarten                                                   0                                             0
2540537 2540537 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540538 2540538 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall pre_kindergarten                                                   0                                             0
2540539 2540539 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall pre_kindergarten                                                   225                                             225
2540540 2540540 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall pre_kindergarten                                                   0                                             0
2540541 2540541 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall pre_kindergarten                                                   0                                             0
595857 595857 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_1                                                   18                                             18
595858 595858 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_1                                                   19                                             19
595859 595859 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_1                                                   15                                             15
595860 595860 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_1                                                   88                                             88
595861 595861 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_1                                                   0                                             0
595862 595862 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_1                                                   0                                             0
597257 597257 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_10                                                   14                                             14
597258 597258 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_10                                                   27                                             27
597259 597259 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_10                                                   24                                             24
597260 597260 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_10                                                   0                                             0
597261 597261 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_10                                                   0                                             0
597262 597262 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_10                                                   87                                             87
598657 598657 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_11                                                   14                                             14
598658 598658 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_11                                                   24                                             24
598659 598659 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_11                                                   24                                             24
598660 598660 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_11                                                   0                                             0
598661 598661 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_11                                                   0                                             0
598662 598662 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_11                                                   80                                             80
600057 600057 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_12                                                   9                                             9
600058 600058 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_12                                                   16                                             16
600059 600059 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_12                                                   24                                             24
600060 600060 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_12                                                   0                                             0
600061 600061 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_12                                                   0                                             0
600062 600062 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_12                                                   87                                             87
601457 601457 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_2                                                   20                                             20
601458 601458 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_2                                                   23                                             23
601459 601459 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_2                                                   17                                             17
601460 601460 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_2                                                   81                                             81
601461 601461 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_2                                                   0                                             0
601462 601462 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_2                                                   0                                             0
602857 602857 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_3                                                   18                                             18
602858 602858 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_3                                                   27                                             27
602859 602859 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_3                                                   25                                             25
602860 602860 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_3                                                   81                                             81
602861 602861 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_3                                                   0                                             0
602862 602862 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_3                                                   0                                             0
604257 604257 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_4                                                   13                                             13
604258 604258 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_4                                                   22                                             22
604259 604259 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 spring grade_4                                                   27                                             27
604260 604260 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 spring grade_4                                                   107                                             107
604261 604261 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 spring grade_4                                                   0                                             0
604262 604262 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_4                                                   0                                             0
605657 605657 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 spring grade_5                                                   15                                             15
605658 605658 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 spring grade_5                                                   29                                             29

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]);