enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by school_nces_id

✎ 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
1988712 1988712 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_1                                                   21                                             21
1990111 1990111 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_10                                                   31                                             31
1991510 1991510 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_11                                                   25                                             25
1992909 1992909 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_12                                                   33                                             33
1994308 1994308 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_2                                                   32                                             32
1995707 1995707 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_3                                                   29                                             29
1997106 1997106 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_4                                                   30                                             30
1998505 1998505 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_5                                                   33                                             33
1999904 1999904 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_6                                                   24                                             24
2001303 2001303 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_7                                                   29                                             29
2002702 2002702 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_8                                                   41                                             41
2004101 2004101 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_9                                                   22                                             22
2005500 2005500 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall grade_9_transitional                                                   0                                             0
2006899 2006899 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall kindergarten                                                   27                                             27
2008298 2008298 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall pk_12_total 370.0 4.0 8.0 0.0   3.0     0.0   9.0   197.0 197.0     0.0       294.0         394 370 4 8 0   3     0   9   197 197     0   294       394
2009697 2009697 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2021 fall pre_kindergarten                                                   17                                             17
2011096 2011096 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_1                                                   30                                             30
2012497 2012497 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_10                                                   25                                             25
2013898 2013898 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_11                                                   34                                             34
2015299 2015299 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_12                                                   28                                             28
2016700 2016700 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_2                                                   29                                             29
2018101 2018101 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_3                                                   30                                             30
2019502 2019502 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_4                                                   33                                             33
2020903 2020903 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_5                                                   27                                             27
2022304 2022304 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_6                                                   30                                             30
2023705 2023705 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_7                                                   42                                             42
2025106 2025106 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_8                                                   24                                             24
2026507 2026507 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_9                                                   29                                             29
2027908 2027908 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_9_transitional                                                   7                                             7
2029309 2029309 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall kindergarten                                                   27                                             27
2030710 2030710 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall pk_12_total 390.0 6.0 7.0 1.0   3.0     0.0   8.0   213.0 202.0     0.0       240.0         415 390 6 7 1   3     0   8   213 202     0   240       415
2032111 2032111 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall pre_kindergarten                                                   20                                             20
2283701 2283701 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_1                                                   29                                             29
2285114 2285114 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_10                                                   37                                             37
2286527 2286527 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_11                                                   30                                             30
2287940 2287940 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_12                                                   15                                             15
2289353 2289353 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_2                                                   31                                             31
2290766 2290766 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_3                                                   33                                             33
2292179 2292179 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_4                                                   30                                             30
2293592 2293592 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_5                                                   29                                             29
2295005 2295005 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_6                                                   41                                             41
2296418 2296418 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_7                                                   26                                             26
2297831 2297831 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_8                                                   37                                             37
2299244 2299244 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_9                                                   26                                             26
2300657 2300657 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring grade_9_transitional                                                   0                                             0
2302070 2302070 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring kindergarten                                                   30                                             30
2303483 2303483 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring pk_12_total 393.0 4.0 5.0 2.0   3.0     0.0   7.0   214.0 200.0     0.0       241.0         414 393 4 5 2   3     0   7   214 200     0   241       414
2304896 2304896 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 spring pre_kindergarten                                                   20                                             20
2518056 2518056 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_1                                                   28                                             28
2519473 2519473 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_10                                                   36                                             36
2520890 2520890 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_11                                                   29                                             29
2522307 2522307 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_12                                                   16                                             16
2523724 2523724 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_2                                                   32                                             32
2525141 2525141 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_3                                                   33                                             33
2526558 2526558 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_4                                                   30                                             30
2527975 2527975 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_5                                                   27                                             27
2529392 2529392 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_6                                                   39                                             39
2530809 2530809 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_7                                                   25                                             25
2532226 2532226 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_8                                                   37                                             37
2533643 2533643 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_9                                                   27                                             27
2535060 2535060 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall grade_9_transitional                                                   0                                             0
2536477 2536477 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall kindergarten                                                   30                                             30
2537894 2537894 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall pk_12_total 385.0 4.0 5.0 2.0   3.0     0.0   10.0   211.0 198.0     0.0       227.0         409 385 4 5 2   3     0   10   211 198     0   227       409
2539311 2539311 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   20                                             20
594674 594674 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_1                                                   28                                             28
596074 596074 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_10                                                   20                                             20
597474 597474 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_11                                                   27                                             27
598874 598874 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_12                                                   24                                             24
600274 600274 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_2                                                   27                                             27
601674 601674 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_3                                                   23                                             23
603074 603074 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_4                                                   20                                             20
604474 604474 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_5                                                   32                                             32
605874 605874 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_6                                                   32                                             32
607274 607274 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_7                                                   32                                             32
608674 608674 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_8                                                   30                                             30
610074 610074 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_9                                                   21                                             21
611474 611474 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   4                                             4
612874 612874 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring kindergarten                                                   32                                             32
614274 614274 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring pk_12_total 344.0 1.0 4.0 0.0   13.0     0.0   7.0   168.0 201.0     4.0       246.0         369 344 1 4 0   13     0   7   168 201     4   246       369
615674 615674 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   16                                             16
1763571 1763571 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring extension_academy                                                   0                                             0
1764968 1764968 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_1                                                   30                                             30
1766365 1766365 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_10                                                   25                                             25
1767762 1767762 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_11                                                   20                                             20
1769159 1769159 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_12                                                   26                                             26
1770556 1770556 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_2                                                   25                                             25
1771953 1771953 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_3                                                   28                                             28
1773350 1773350 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_4                                                   23                                             23
1774747 1774747 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_5                                                   19                                             19
1776144 1776144 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_6                                                   28                                             28
1777541 1777541 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_7                                                   31                                             31
1778938 1778938 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_8                                                   30                                             30
1780335 1780335 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_9                                                   28                                             28
1781732 1781732 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring grade_9_transitional                                                   0                                             0
1783129 1783129 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring kindergarten                                                   21                                             21
1784526 1784526 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring pk_12_total 351.0 1.0 4.0 0.0   1.0     0.0   8.0   173.0 192.0     0.0       279.0         365 351 1 4 0   1     0   8   173 192     0   279       365
1785923 1785923 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 spring pre_kindergarten                                                   29                                             29
1987314 1987314 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall extension_academy                                                   0                                             0
1988713 1988713 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_1                                                   34                                             34
1990112 1990112 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_10                                                   24                                             24

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