enrollments

Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by school_state_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
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
1991511 1991511 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_11                                                   19                                             19
1992910 1992910 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_12                                                   27                                             27
1994309 1994309 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_2                                                   26                                             26
1995708 1995708 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_3                                                   33                                             33
1997107 1997107 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_4                                                   24                                             24
1998506 1998506 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_5                                                   19                                             19
1999905 1999905 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_6                                                   32                                             32
2001304 2001304 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_7                                                   34                                             34
2002703 2002703 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_8                                                   31                                             31
2004102 2004102 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_9                                                   29                                             29
2005501 2005501 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall grade_9_transitional                                                   0                                             0
2006900 2006900 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall kindergarten                                                   23                                             23
2008299 2008299 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall pk_12_total 360.0 1.0 4.0 0.0   13.0     0.0   8.0   182.0 204.0     4.0       302.0         386 360 1 4 0   13     0   8   182 204     4   302       386
2009698 2009698 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2021 fall pre_kindergarten                                                   29                                             29
2011097 2011097 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_1                                                   28                                             28
2012498 2012498 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_10                                                   22                                             22
2013899 2013899 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_11                                                   27                                             27
2015300 2015300 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_12                                                   23                                             23
2016701 2016701 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_2                                                   27                                             27
2018102 2018102 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_3                                                   24                                             24
2019503 2019503 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_4                                                   21                                             21
2020904 2020904 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_5                                                   32                                             32
2022305 2022305 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_6                                                   33                                             33
2023706 2023706 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_7                                                   31                                             31
2025107 2025107 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_8                                                   29                                             29
2026508 2026508 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_9                                                   22                                             22
2027909 2027909 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_9_transitional                                                   4                                             4
2029310 2029310 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall kindergarten                                                   29                                             29
2030711 2030711 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall pk_12_total 345.0 1.0 5.0 0.0   13.0     0.0   6.0   169.0 201.0     4.0       238.0         370 345 1 5 0   13     0   6   169 201     4   238       370
2032112 2032112 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall pre_kindergarten                                                   16                                             16
2283702 2283702 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_1                                                   34                                             34
2285115 2285115 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_10                                                   30                                             30
2286528 2286528 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_11                                                   23                                             23
2287941 2287941 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_12                                                   24                                             24
2289354 2289354 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_2                                                   27                                             27
2290767 2290767 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_3                                                   22                                             22
2292180 2292180 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_4                                                   30                                             30
2293593 2293593 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_5                                                   34                                             34
2295006 2295006 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_6                                                   30                                             30
2296419 2296419 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_7                                                   31                                             31
2297832 2297832 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_8                                                   27                                             27
2299245 2299245 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_9                                                   21                                             21
2300658 2300658 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring grade_9_transitional                                                   3                                             3
2302071 2302071 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring kindergarten                                                   32                                             32
2303484 2303484 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring pk_12_total 369.0 1.0 5.0 0.0   13.0     0.0   6.0   186.0 208.0     3.0       252.0         394 369 1 5 0   13     0   6   186 208     3   252       394
2304897 2304897 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 spring pre_kindergarten                                                   25                                             25
2518057 2518057 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_1                                                   36                                             36
2519474 2519474 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_10                                                   32                                             32
2520891 2520891 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_11                                                   26                                             26
2522308 2522308 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_12                                                   24                                             24
2523725 2523725 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_2                                                   26                                             26
2525142 2525142 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_3                                                   23                                             23
2526559 2526559 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_4                                                   33                                             33
2527976 2527976 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_5                                                   35                                             35
2529393 2529393 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_6                                                   30                                             30
2530810 2530810 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_7                                                   34                                             34
2532227 2532227 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_8                                                   26                                             26
2533644 2533644 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_9                                                   20                                             20
2535061 2535061 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall grade_9_transitional                                                   3                                             3
2536478 2536478 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall kindergarten                                                   31                                             31
2537895 2537895 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall pk_12_total 382.0 0.0 4.0 0.0   13.0     0.0   6.0   188.0 217.0     3.0       248.0         405 382 0 4 0   13     0   6   188 217     3   248       405
2539312 2539312 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   25                                             25
594675 594675 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_1                                                   101                                             101
596075 596075 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_10                                                   0                                             0
597475 597475 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_11                                                   0                                             0
598875 598875 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_12                                                   0                                             0
600275 600275 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_2                                                   95                                             95
601675 601675 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_3                                                   82                                             82
603075 603075 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_4                                                   104                                             104
604475 604475 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_5                                                   0                                             0
605875 605875 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_6                                                   0                                             0
607275 607275 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_7                                                   0                                             0
608675 608675 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_8                                                   0                                             0
610075 610075 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_9                                                   0                                             0
611475 611475 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_9_transitional                                                   0                                             0
612875 612875 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring kindergarten                                                   100                                             100
614275 614275 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring pk_12_total 378.0 108.0 11.0 11.0   4.0     0.0   47.0   309.0 250.0     1.0       375.0         559 378 108 11 11   4     0   47   309 250     1   375       559
615675 615675 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring pre_kindergarten                                                   71                                             71
1763572 1763572 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring extension_academy                                                   0                                             0
1764969 1764969 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_1                                                   95                                             95
1766366 1766366 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_10                                                   0                                             0
1767763 1767763 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_11                                                   0                                             0
1769160 1769160 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_12                                                   0                                             0
1770557 1770557 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_2                                                   88                                             88
1771954 1771954 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_3                                                   95                                             95
1773351 1773351 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_4                                                   77                                             77
1774748 1774748 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring grade_5                                                   0                                             0
1776145 1776145 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2021 spring 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]);