Data source: Big Local News · About: Big Local

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

View and edit SQL

grade

year

  • 2020 · 43,230
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
2015191 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_11                                                   0                                             0
2016592 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_12                                                   0                                             0
2017993 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_2                                                   120                                             120
2019394 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_3                                                   116                                             116
2020795 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_4                                                   103                                             103
2022196 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_5                                                   112                                             112
2023597 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_6                                                   109                                             109
2024998 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_7                                                   100                                             100
2026399 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_8                                                   96                                             96
2027800 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_9                                                   0                                             0
2029201 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall grade_9_transitional                                                   0                                             0
2030602 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall kindergarten                                                   113                                             113
2032003 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall pk_12_total 4.0 967.0 33.0 0.0   0.0     0.0   6.0   489.0 521.0     11.0       983.0         1010 4 967 33 0   0     0   6   489 521     11   983       1010
2033404 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 fall pre_kindergarten                                                   30                                             30
594673 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_1                                                   29                                             29
596073 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_10                                                   26                                             26
597473 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_11                                                   35                                             35
598873 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_12                                                   28                                             28
600273 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_2                                                   29                                             29
601673 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_3                                                   28                                             28
603073 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_4                                                   33                                             33
604473 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_5                                                   25                                             25
605873 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_6                                                   29                                             29
607273 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_7                                                   42                                             42
608673 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_8                                                   23                                             23
610073 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_9                                                   28                                             28
611473 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring grade_9_transitional                                                   7                                             7
612873 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring kindergarten                                                   25                                             25
614273 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring pk_12_total 383.0 6.0 6.0 0.0   3.0     0.0   9.0   205.0 202.0     0.0       239.0         407 383 6 6 0   3     0   9   205 202     0   239       407
615673 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   20                                             20
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_10                                                   25                                             25
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_12                                                   28                                             28
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_3                                                   30                                             30
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_5                                                   27                                             27
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_7                                                   42                                             42
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall grade_9                                                   29                                             29
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall kindergarten                                                   27                                             27
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 LA     school 2200060 002   Allen Parish 220006000024 2001 Elizabeth High School   Regular School No Other PK 12 2020 fall pre_kindergarten                                                   20                                             20
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_10                                                   20                                             20
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_12                                                   24                                             24
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_3                                                   23                                             23
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_5                                                   32                                             32
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_7                                                   32                                             32
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring grade_9                                                   21                                             21
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring kindergarten                                                   32                                             32
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 spring pre_kindergarten                                                   16                                             16
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_10                                                   22                                             22
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_12                                                   23                                             23
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_3                                                   24                                             24
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_5                                                   32                                             32
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_7                                                   31                                             31
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall grade_9                                                   22                                             22
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall kindergarten                                                   29                                             29
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 LA     school 2200060 002   Allen Parish 220006000025 2002 Fairview High School   Regular School No Other PK 12 2020 fall pre_kindergarten                                                   16                                             16
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_10                                                   0                                             0
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_12                                                   0                                             0
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_3                                                   82                                             82
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_5                                                   0                                             0
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_7                                                   0                                             0
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring grade_9                                                   0                                             0
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring kindergarten                                                   100                                             100
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 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 spring pre_kindergarten                                                   71                                             71
2011098 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_1                                                   103                                             103
2012499 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_10                                                   0                                             0
2013900 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_11                                                   0                                             0
2015301 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_12                                                   0                                             0
2016702 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_2                                                   94                                             94
2018103 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2020 fall grade_3                                                   81                                             81

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