Data source: Big Local News · About: Big Local

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

View and edit SQL

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
2283969 LA     school 2200480 015   Concordia Parish 220048000324 15008 Vidalia High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2283970 LA     school 2200480 015   Concordia Parish 220048000325 15009 Vidalia Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2283971 LA     school 2200480 015   Concordia Parish 220048000326 15010 Vidalia Lower Elementary School   Regular School No Elementary PK 02 2019 spring grade_1                                                   142                                             142
2283972 LA     school 2200480 015   Concordia Parish 220048000327 15011 Vidalia Upper Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2283973 LA     school 2200480 015   Concordia Parish 220048001515 15014 Concordia Education Center   Regular School No Other 04 12 2019 spring grade_1                                                   0                                             0
2283974 LA     school   015   Concordia Parish   15700 Concordia Central Office             2019 spring grade_1                                                   0                                             0
2283975 LA     school 2200510 016   DeSoto Parish 220051000331 16004 Logansport High School   Regular School No Other PK 12 2019 spring grade_1                                                   34                                             34
2283976 LA     school 2200510 016   DeSoto Parish 220051000334 16007 Mansfield High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2283977 LA     school 2200510 016   DeSoto Parish 220051000337 16010 Stanley High School   Regular School No Other PK 12 2019 spring grade_1                                                   30                                             30
2283978 LA     school 2200510 016   DeSoto Parish 220051001579 16012 North DeSoto High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2283979 LA     school 2200510 016   DeSoto Parish 220051001919 16014 North DeSoto Lower Elementary School   Regular School No Elementary PK 01 2019 spring grade_1                                                   190                                             190
2283980 LA     school 2200510 016   DeSoto Parish 220051000275 16017 North DeSoto Middle School 6-8   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2283981 LA     school 2200510 016   DeSoto Parish 220051000623 16019 Mansfield Elementary School   Regular School No Elementary PK 04 2019 spring grade_1                                                   106                                             106
2283982 LA     school 2200510 016   DeSoto Parish 220051000626 16020 Mansfield Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2283983 LA     school 2200510 016   DeSoto Parish 220051002064 16023 North DeSoto Upper Elementary School   Regular School No Elementary 02 05 2019 spring grade_1                                                   0                                             0
2283984 LA     school 2200540 017   East Baton Rouge Parish 220054000340 17001 Arlington Preparatory Academy   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2283985 LA     school 2200540 017   East Baton Rouge Parish 220054000341 17002 Audubon Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   72                                             72
2283986 LA     school 2200540 017   East Baton Rouge Parish 220054000347 17008 Baton Rouge Magnet High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2283987 LA     school 2200540 017   East Baton Rouge Parish 220054000349 17010 Belaire High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2283988 LA     school 2200540 017   East Baton Rouge Parish 220054000350 17011 Belfair Montessori School   Regular School No Elementary PK 08 2019 spring grade_1                                                   29                                             29
2283989 LA     school 2200540 017   East Baton Rouge Parish 220054000352 17013 Bernard Terrace Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   48                                             48
2283990 LA     school 2200540 017   East Baton Rouge Parish 220054000353 17014 Broadmoor Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   89                                             89
2283991 LA     school 2200540 017   East Baton Rouge Parish 220054000354 17015 Broadmoor Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2283992 LA     school 2200540 017   East Baton Rouge Parish 220054000355 17016 Broadmoor Senior High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2283993 LA     school 2200540 017   East Baton Rouge Parish 220054000357 17018 Brownfields Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   44                                             44
2283994 LA     school 2200540 017   East Baton Rouge Parish 220054000358 17019 Buchanan Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   61                                             61
2283995 LA     school 2200540 017   East Baton Rouge Parish 220054000360 17020 Capitol Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2283996 LA     school 2200540 017   East Baton Rouge Parish 220054000362 17022 Cedarcrest-Southmoor Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   95                                             95
2283997 LA     school 2200540 017   East Baton Rouge Parish 220054000367 17026 Claiborne Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   74                                             74
2283998 LA     school 2200540 017   East Baton Rouge Parish 220054000368 17027 Crestworth Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   47                                             47
2283999 LA     school 2200540 017   East Baton Rouge Parish 220054001920 17031 Southdowns School   Special Education School No Elementary PK KG 2019 spring grade_1                                                   0                                             0
2284000 LA     school 2200540 017   East Baton Rouge Parish 220054000372 17032 The Dufrocq School   Regular School No Elementary PK 05 2019 spring grade_1                                                   95                                             95
2284001 LA     school 2200540 017   East Baton Rouge Parish 220054000375 17034 Forest Heights Academy of Excellence   Regular School No Elementary PK 05 2019 spring grade_1                                                   47                                             47
2284002 LA     school 2200540 017   East Baton Rouge Parish 220054001554 17035 Glasgow Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284003 LA     school 2200540 017   East Baton Rouge Parish 220054000376 17037 Glen Oaks Park Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   66                                             66
2284004 LA     school 2200540 017   East Baton Rouge Parish 220054000378 17038 Glen Oaks Senior High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284005 LA     school 2200540 017   East Baton Rouge Parish 220054000380 17040 Greenbrier Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   47                                             47
2284006 LA     school 2200540 017   East Baton Rouge Parish 220054000383 17043 Highland Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   42                                             42
2284007 LA     school 2200540 017   East Baton Rouge Parish 220054000385 17044 Howell Park Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   30                                             30
2284008 LA     school 2200540 017   East Baton Rouge Parish 220054002440 17045 Istrouma High School   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284009 LA     school 2200540 017   East Baton Rouge Parish 220054000388 17047 Jefferson Terrace Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   51                                             51
2284010 LA     school 2200540 017   East Baton Rouge Parish 220054000390 17050 LaBelle Aire Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   99                                             99
2284011 LA     school 2200540 017   East Baton Rouge Parish 220054000392 17051 LaSalle Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   92                                             92
2284012 LA     school 2200540 017   East Baton Rouge Parish 220054000394 17053 Magnolia Woods Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   82                                             82
2284013 LA     school 2200540 017   East Baton Rouge Parish 220054000396 17055 McKinley Middle Magnet School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284014 LA     school 2200540 017   East Baton Rouge Parish 220054000397 17056 McKinley Senior High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284015 LA     school 2200540 017   East Baton Rouge Parish 220054000398 17057 Melrose Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   63                                             63
2284016 LA     school 2200540 017   East Baton Rouge Parish 220054000399 17058 Merrydale Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   50                                             50
2284017 LA     school 2200540 017   East Baton Rouge Parish 220054000404 17063 Northdale Superintendent's Academy   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284018 LA     school 2200540 017   East Baton Rouge Parish 220054000416 17064 Northeast Elementary School   Regular School No Elementary PK 06 2019 spring grade_1                                                   32                                             32
2284019 LA     school 2200540 017   East Baton Rouge Parish 220054000365 17065 Northeast High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284020 LA     school 2200540 017   East Baton Rouge Parish 220054000407 17068 Park Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   35                                             35
2284021 LA     school 2200540 017   East Baton Rouge Parish 220054000408 17069 Park Forest Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   61                                             61
2284022 LA     school 2200540 017   East Baton Rouge Parish 220054000409 17070 Park Forest Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284023 LA     school 2200540 017   East Baton Rouge Parish 220054000411 17072 Parkview Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   102                                             102
2284024 LA     school 2200540 017   East Baton Rouge Parish 220054000417 17075 Progress Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   55                                             55
2284025 LA     school 2200540 017   East Baton Rouge Parish 220054000420 17077 Riveroaks Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   89                                             89
2284026 LA     school 2200540 017   East Baton Rouge Parish 220054000421 17078 Ryan Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   62                                             62
2284027 LA     school 2200540 017   East Baton Rouge Parish 220054000423 17079 Scotlandville Magnet High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284028 LA     school 2200540 017   East Baton Rouge Parish 220054000425 17081 Sharon Hills Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   46                                             46
2284029 LA     school 2200540 017   East Baton Rouge Parish 220054000426 17082 Shenandoah Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   108                                             108
2284030 LA     school 2200540 017   East Baton Rouge Parish 220054000428 17083 Sherwood Middle Academic Academy   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284031 LA     school 2200540 017   East Baton Rouge Parish 220054000429 17084 B. R. Foreign Language Acad. Immersion Magnet   Regular School No Elementary PK 05 2019 spring grade_1                                                   94                                             94
2284032 LA     school 2200540 017   East Baton Rouge Parish 220054000432 17085 Southeast Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284033 LA     school 2200540 017   East Baton Rouge Parish 220054000434 17088 Tara High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284034 LA     school 2200540 017   East Baton Rouge Parish 220054000435 17089 Twin Oaks Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   80                                             80
2284035 LA     school 2200540 017   East Baton Rouge Parish 220054000436 17091 University Terrace Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   54                                             54
2284036 LA     school 2200540 017   East Baton Rouge Parish 220054000339 17092 EBR Readiness Superintendent Academy   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284037 LA     school 2200540 017   East Baton Rouge Parish 220054000438 17093 Villa del Rey Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   51                                             51
2284038 LA     school 2200540 017   East Baton Rouge Parish 220054000439 17094 Baton Rouge Center for Visual and Performing Arts   Regular School No Elementary PK 05 2019 spring grade_1                                                   65                                             65
2284039 LA     school 2200540 017   East Baton Rouge Parish 220054000440 17095 Wedgewood Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   68                                             68
2284040 LA     school 2200540 017   East Baton Rouge Parish 220054000441 17096 Westdale Heights Academic Magnet School   Regular School No Elementary PK 05 2019 spring grade_1                                                   70                                             70
2284041 LA     school 2200540 017   East Baton Rouge Parish 220054000442 17097 Westdale Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284042 LA     school 2200540 017   East Baton Rouge Parish 220054000443 17098 Westminster Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   68                                             68
2284043 LA     school 2200540 017   East Baton Rouge Parish 220054000445 17100 Wildwood Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   86                                             86
2284044 LA     school 2200540 017   East Baton Rouge Parish 220054000446 17101 Winbourne Elementary School   Regular School No Elementary KG 05 2019 spring grade_1                                                   75                                             75
2284045 LA     school 2200540 017   East Baton Rouge Parish 220054000447 17102 Woodlawn High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284046 LA     school 2200540 017   East Baton Rouge Parish 220054000628 17110 Children's Charter School   Regular School Yes Elementary PK 05 2019 spring grade_1                                                   27                                             27
2284047 LA     school 2200540 017   East Baton Rouge Parish 220054000673 17111 Community School For Apprenticeship Learning   Regular School Yes Middle 06 08 2019 spring grade_1                                                   0                                             0
2284048 LA     school 2200540 017   East Baton Rouge Parish 220054000679 17112 J. K. Haynes Charter Inc.   Regular School Yes Elementary PK 07 2019 spring grade_1                                                   33                                             33
2284049 LA     school 2200540 017   East Baton Rouge Parish 220054001384 17114 Greenville Superintendent's Academy   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284050 LA     school 2200540 017   East Baton Rouge Parish 220054001703 17120 White Hills Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   30                                             30
2284051 LA     school 2200540 017   East Baton Rouge Parish 220054001692 17125 Woodlawn Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284052 LA     school 2200540 017   East Baton Rouge Parish 220054000373 17128 Capitol Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   48                                             48
2284053 LA     school 2200540 017   East Baton Rouge Parish 220054002069 17130 Scotlandville Pre-Engineering Academy   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284054 LA     school 2200540 017   East Baton Rouge Parish 220054002265 17131 Woodlawn Elementary   Regular School No Elementary PK 05 2019 spring grade_1                                                   109                                             109
2284055 LA     school 2200540 017   East Baton Rouge Parish 220054002311 17133 Mentorship STEAM Academy   Regular School Yes High 09 12 2019 spring grade_1                                                   0                                             0
2284056 LA     school 2200540 017   East Baton Rouge Parish 220054002316 17135 Inspire Charter Academy (Natl. Heritage Acad.)   Regular School Yes Elementary KG 08 2019 spring grade_1                                                   68                                             68
2284057 LA     school 2200540 017   East Baton Rouge Parish 220054002342 17138 Lee High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284058 LA     school 2200540 017   East Baton Rouge Parish 220054002368 17141 Eden Park Superintendent Academy   Regular School No Elementary KG 05 2019 spring grade_1                                                   1                                             1
2284059 LA     school 2200540 017   East Baton Rouge Parish 220054002363 17142 North Banks Middle School of Excellence   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284060 LA     school 2200540 017   East Baton Rouge Parish 220054002360 17143 Delmont Pre-K and Kindergarten Center   Regular School No Prekindergarten PK PK 2019 spring grade_1                                                   0                                             0
2284061 LA     school 2200540 017   East Baton Rouge Parish 220054002353 17144 Mayfair Laboratory School   Regular School No Elementary KG 08 2019 spring grade_1                                                   51                                             51
2284062 LA     school 2200540 017   East Baton Rouge Parish 220054002404 17145 South Baton Rouge Charter Academy   Regular School Yes Elementary PK 08 2019 spring grade_1                                                   75                                             75
2284063 LA     school 2200540 017   East Baton Rouge Parish 220054002379 17146 Brookstown Middle   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284064 LA     school 2200540 017   East Baton Rouge Parish 220054002423 17147 EBR Virtual Academy   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284065 LA     school 2200540 017   East Baton Rouge Parish 220054002451 17148 BASIS Baton Rouge   Regular School Yes Elementary KG 04 2019 spring grade_1                                                   66                                             66
2284066 LA     school 2200540 017   East Baton Rouge Parish 220054002454 17149 The Emerge School for Autism   Regular School Yes Elementary KG KG 2019 spring grade_1                                                   0                                             0
2284067 LA     school 2200540 017   East Baton Rouge Parish 220054002459 17151 IDEA Innovation   Regular School Yes Elementary KG 06 2019 spring grade_1                                                   66                                             66
2284068 LA     school 2200540 017   East Baton Rouge Parish 220054002453 17152 IDEA Bridge   Regular School Yes Elementary KG 06 2019 spring grade_1                                                   98                                             98

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