enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2284115 2284115 LA     school 2200720 023   Iberia Parish 220072000519 23015 Jeanerette Senior High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284117 2284117 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284118 2284118 LA     school 2200720 023   Iberia Parish 220072000525 23022 Westgate High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284119 2284119 LA     school 2200720 023   Iberia Parish 220072000527 23024 New Iberia Senior High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284125 2284125 LA     school 2200720 023   Iberia Parish 220072001924 23033 St. Charles Street Elementary School   Regular School No Elementary 03 06 2019 spring grade_1                                                   0                                             0
2284128 2284128 LA     school 2200720 023   Iberia Parish 220072001927 23036 Belle Place Middle School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284129 2284129 LA     school 2200720 023   Iberia Parish 220072000316 23038 Iberia Middle School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284133 2284133 LA     school   023   Iberia Parish   23700 Iberia Central Office             2019 spring grade_1                                                   0                                             0
2284135 2284135 LA     school 2200750 024   Iberville Parish 220075000543 24010 Plaquemine Senior High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284136 2284136 LA     school 2200750 024   Iberville Parish 220075000550 24017 White Castle High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284141 2284141 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284142 2284142 LA     school 2200780 025   Jackson Parish 220078000557 25006 Jonesboro-Hodge Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284146 2284146 LA     school   026   Jefferson Parish   26000 Administrative Services -- Special Education             2019 spring grade_1                                                   0                                             0
2284147 2284147 LA     school 2200840 026   Jefferson Parish 220084000576 26001 John Q. Adams Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284152 2284152 LA     school 2200840 026   Jefferson Parish 220084000585 26010 Bonnabel Magnet Academy High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284156 2284156 LA     school 2200840 026   Jefferson Parish 220084000592 26017 Helen Cox High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284159 2284159 LA     school 2200840 026   Jefferson Parish 220084000597 26022 East Jefferson High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284160 2284160 LA     school 2200840 026   Jefferson Parish 220084000598 26023 John Ehret High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284165 2284165 LA     school 2200840 026   Jefferson Parish 220084000604 26029 Fisher Middle/High School   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284166 2284166 LA     school 2200840 026   Jefferson Parish 220084000605 26030 Henry Ford Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284170 2284170 LA     school 2200840 026   Jefferson Parish 220084000609 26035 Gretna Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284173 2284173 LA     school 2200840 026   Jefferson Parish 220084000614 26039 T.H. Harris Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284175 2284175 LA     school 2200840 026   Jefferson Parish 220084000617 26042 Haynes Academy School for Advanced Studies   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284178 2284178 LA     school 2200840 026   Jefferson Parish 220084000620 26045 L.W. Higgins High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284181 2284181 LA     school 2200840 026   Jefferson Parish 220084000625 26051 Grace King High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284182 2284182 LA     school 2200840 026   Jefferson Parish 220084000630 26056 Livaudais Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284184 2284184 LA     school 2200840 026   Jefferson Parish 220084000632 26058 L.H. Marrero Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284187 2284187 LA     school 2200840 026   Jefferson Parish 220084000636 26062 J.D. Meisler Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284191 2284191 LA     school 2200840 026   Jefferson Parish 220084000642 26068 Riverdale High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284193 2284193 LA     school 2200840 026   Jefferson Parish 220084000644 26070 Theodore Roosevelt Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284198 2284198 LA     school 2200840 026   Jefferson Parish 220084000654 26080 West Jefferson High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284202 2284202 LA     school 2200840 026   Jefferson Parish 220084000658 26085 Stella Worley Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284211 2284211 LA     school 2200840 026   Jefferson Parish 220084001884 26099 Harry S. Truman Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284212 2284212 LA     school 2200840 026   Jefferson Parish 220084000320 26100 Riverdale Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284214 2284214 LA     school 2200840 026   Jefferson Parish 220084001667 26105 Patrick F. Taylor Science & Technology Academy   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284215 2284215 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284217 2284217 LA     school 2200840 026   Jefferson Parish 220084002051 26111 L. W. Ruppel Academy for Advanced Studies   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284225 2284225 LA     school 2200840 026   Jefferson Parish 220084002305 26123 JCFA   Regular School Yes High 08 12 2019 spring grade_1                                                   0                                             0
2284229 2284229 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Middle 06 09 2019 spring grade_1                                                   0                                             0
2284231 2284231 LA     school   027   Jefferson Davis Parish   27000 Administrative Services -- Special Education             2019 spring grade_1                                                   0                                             0
2284232 2284232 LA     school 2200810 027   Jefferson Davis Parish 220081000561 27001 Elton High School   Regular School No High 06 12 2019 spring grade_1                                                   0                                             0
2284236 2284236 LA     school 2200810 027   Jefferson Davis Parish 220081000566 27006 Jennings High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284238 2284238 LA     school 2200810 027   Jefferson Davis Parish 220081000569 27009 Jennings Elementary School   Regular School No Elementary 03 06 2019 spring grade_1                                                   0                                             0
2284241 2284241 LA     school 2200810 027   Jefferson Davis Parish 220081000572 27012 Lake Arthur High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284243 2284243 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284244 2284244 LA     school 2200810 027   Jefferson Davis Parish 220081000575 27015 Welsh-Roanoke Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284245 2284245 LA     school 2200870 028   Lafayette Parish 220087000659 28001 Acadian Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284246 2284246 LA     school 2200870 028   Lafayette Parish 220087000660 28002 Acadiana High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284247 2284247 LA     school 2200870 028   Lafayette Parish 220087000661 28003 L.J. Alleman Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284249 2284249 LA     school 2200870 028   Lafayette Parish 220087000663 28005 Paul Breaux Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284251 2284251 LA     school 2200870 028   Lafayette Parish 220087000665 28007 Broussard Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284252 2284252 LA     school 2200870 028   Lafayette Parish 220087000666 28008 Carencro Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284254 2284254 LA     school 2200870 028   Lafayette Parish 220087000668 28010 Carencro High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284255 2284255 LA     school 2200870 028   Lafayette Parish 220087000669 28011 O. Comeaux High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284259 2284259 LA     school 2200870 028   Lafayette Parish 220087000675 28016 Judice Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284261 2284261 LA     school 2200870 028   Lafayette Parish 220087000677 28018 Lafayette Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284262 2284262 LA     school 2200870 028   Lafayette Parish 220087000678 28019 Lafayette High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284264 2284264 LA     school 2200870 028   Lafayette Parish 220087000681 28022 Edgar Martin Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284268 2284268 LA     school 2200870 028   Lafayette Parish 220087000686 28027 Northside High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284272 2284272 LA     school 2200870 028   Lafayette Parish 220087000690 28032 Scott Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284273 2284273 LA     school 2200870 028   Lafayette Parish 220087000691 28033 Truman Early Childhood Education Center   Regular School No Prekindergarten PK PK 2019 spring grade_1                                                   0                                             0
2284276 2284276 LA     school 2200870 028   Lafayette Parish 220087000695 28038 Youngsville Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284284 2284284 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284285 2284285 LA     school 2200870 028   Lafayette Parish 220087002301 28054 David Thibodaux STEM Magnet Academy   Career and Technical School No High 06 12 2019 spring grade_1                                                   0                                             0
2284286 2284286 LA     school 2200870 028   Lafayette Parish 220087002442 28055 Southside High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284287 2284287 LA     school 2200870 028   Lafayette Parish 220087002441 28056 Edward J Sam Accelerated School of Lafayette   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284288 2284288 LA     school   028   Lafayette Parish   28700 Lafayette Central Office             2019 spring grade_1                                                   0                                             0
2284291 2284291 LA     school 2200900 029   Lafourche Parish 220090000699 29003 Central Lafourche High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284294 2284294 LA     school 2200900 029   Lafourche Parish 220090000703 29006 East Thibodaux Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284296 2284296 LA     school 2200900 029   Lafourche Parish 220090000706 29009 Golden Meadow Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284298 2284298 LA     school 2200900 029   Lafourche Parish 220090000708 29011 Golden Meadow Upper Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284299 2284299 LA     school 2200900 029   Lafourche Parish 220090000709 29012 W.S. Lafargue Elementary School   Regular School No Elementary 02 03 2019 spring grade_1                                                   0                                             0
2284302 2284302 LA     school 2200900 029   Lafourche Parish 220090000711 29015 Larose-Cut Off Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284303 2284303 LA     school 2200900 029   Lafourche Parish 220090000712 29016 Lockport Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284305 2284305 LA     school 2200900 029   Lafourche Parish 220090000714 29018 Lockport Upper Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284306 2284306 LA     school 2200900 029   Lafourche Parish 220090000716 29020 Raceland Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284308 2284308 LA     school 2200900 029   Lafourche Parish 220090000718 29022 Raceland Upper Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284310 2284310 LA     school 2200900 029   Lafourche Parish 220090000701 29024 Sixth Ward Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284311 2284311 LA     school 2200900 029   Lafourche Parish 220090000721 29026 South Lafourche High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284312 2284312 LA     school 2200900 029   Lafourche Parish 220090000722 29027 South Thibodaux Elementary School   Regular School No Elementary 04 05 2019 spring grade_1                                                   0                                             0
2284314 2284314 LA     school 2200900 029   Lafourche Parish 220090000725 29029 Thibodaux High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284315 2284315 LA     school 2200900 029   Lafourche Parish 220090000727 29030 West Thibodaux Middle School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284316 2284316 LA     school 2200900 029   Lafourche Parish 220090001968 29038 Bayou Blue Middle School   Regular School No Middle 05 08 2019 spring grade_1                                                   0                                             0
2284319 2284319 LA     school   029   Lafourche Parish   29700 Lafourche Central Office             2019 spring grade_1                                                   0                                             0
2284321 2284321 LA     school 2200960 030   LaSalle Parish 220096000730 30002 Goodpine Middle School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284323 2284323 LA     school 2200960 030   LaSalle Parish 220096000732 30004 Jena High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284324 2284324 LA     school 2200960 030   LaSalle Parish 220096000733 30005 Jena Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284325 2284325 LA     school 2200960 030   LaSalle Parish 220096000734 30006 LaSalle High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284328 2284328 LA     school 2200960 030   LaSalle Parish 220096000738 30010 LaSalle Junior High School   Regular School No Middle 06 08 2019 spring grade_1                                                   0                                             0
2284329 2284329 LA     school 2200990 031   Lincoln Parish 220099000742 31003 Choudrant High School   Regular School No High 07 12 2019 spring grade_1                                                   0                                             0
2284330 2284330 LA     school 2200990 031   Lincoln Parish 220099000743 31004 Cypress Springs Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284334 2284334 LA     school 2200990 031   Lincoln Parish 220099000748 31009 I.A. Lewis School   Regular School No Middle 06 06 2019 spring grade_1                                                   0                                             0
2284336 2284336 LA     school 2200990 031   Lincoln Parish 220099000751 31012 Ruston Elementary School   Regular School No Elementary 03 05 2019 spring grade_1                                                   0                                             0
2284337 2284337 LA     school 2200990 031   Lincoln Parish 220099000752 31013 Ruston High School   Regular School No High 09 12 2019 spring grade_1                                                   0                                             0
2284339 2284339 LA     school 2200990 031   Lincoln Parish 220099001815 31018 Ruston Junior High School   Regular School No Middle 07 08 2019 spring grade_1                                                   0                                             0
2284341 2284341 LA     school   031   Lincoln Parish   31022 Howard School             2019 spring grade_1                                                   0                                             0
2284342 2284342 LA     school 2200990 031   Lincoln Parish 220099002304 31023 Lincoln Parish Early Childhood Center   Regular School No Prekindergarten PK PK 2019 spring grade_1                                                   0                                             0
2284343 2284343 LA     school   031   Lincoln Parish   31700 Lincoln Central Office             2019 spring grade_1                                                   0                                             0
2284345 2284345 LA     school 2201020 032   Livingston Parish 220102000755 32002 Albany High School   Regular School No High 08 12 2019 spring grade_1                                                   0                                             0
2284348 2284348 LA     school 2201020 032   Livingston Parish 220102000758 32005 Denham Springs High School   Regular School No High 10 12 2019 spring grade_1                                                   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]);