Data source: Big Local News · About: Big Local

8,427 rows where grade = "grade_9" and state = "LA" sorted by total descending

View and edit SQL

year

grade

  • grade_9 · 8,327
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
2534053 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2019 fall grade_9                                                   87                                             87
2534930 LA     school   R36   All Orleans   368001 Morris Jeff Community School             2019 fall grade_9                                                   87                                             87
611235 LA     school 2201890 060   Webster Parish 220189001450 60018 Lakeside Junior-Senior High School   Regular School No High 06 12 2020 spring grade_9                                                   86                                             86
611345 LA     school   R36   Orleans Parish   368001 Morris Jeff Community School             2020 spring grade_9                                                   86                                             86
611434 LA     school   CHA   Type 2 Charters   WBX001 GEO Next Generation High School             2020 spring grade_9                                                   86                                             86
1780392 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2021 spring grade_9                                                   86                                             86
1780838 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 06 12 2021 spring grade_9                                                   86                                             86
1781455 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2021 spring grade_9                                                   86                                             86
2004365 LA     school 2200480 015   Concordia Parish 220048000317 15002 Ferriday High School   Regular School No High 08 12 2021 fall grade_9                                                   86                                             86
2004605 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 06 12 2021 fall grade_9                                                   86                                             86
2004760 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2021 fall grade_9                                                   86                                             86
2027043 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2020 fall grade_9                                                   86                                             86
2299758 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 09 12 2019 spring grade_9                                                   86                                             86
2534157 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 09 12 2019 fall grade_9                                                   86                                             86
2534171 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Middle 06 09 2019 fall grade_9                                                   86                                             86
610263 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2020 spring grade_9                                                   85                                             85
1780868 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2021 spring grade_9                                                   85                                             85
2027273 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2020 fall grade_9                                                   85                                             85
2027669 LA     school 2201890 060   Webster Parish 220189001450 60018 Lakeside Junior-Senior High School   Regular School No High 06 12 2020 fall grade_9                                                   85                                             85
2027780 LA     school   R36   Orleans Parish   368001 Morris Jeff Community School             2020 fall grade_9                                                   85                                             85
2299654 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2019 spring grade_9                                                   85                                             85
2300381 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2019 spring grade_9                                                   85                                             85
2300461 LA     school 2200240 066   City of Bogalusa School District 220024000103 66002 Bogalusa High School   Regular School No High 07 12 2019 spring grade_9                                                   85                                             85
2534976 LA     school   CHA   Type 2 Charters   W1A001 JCFA-East             2019 fall grade_9                                                   85                                             85
1781485 LA     school 2201890 060   Webster Parish 220189001450 60018 Lakeside Junior-Senior High School   Regular School No High 06 12 2021 spring grade_9                                                   84                                             84
2004272 LA     school 2200300 009   Caddo Parish 220030002377 9106 Magnolia School of Excellence   Regular School Yes Other KG 12 2021 fall grade_9                                                   84                                             84
2005324 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2021 fall grade_9                                                   84                                             84
2005449 LA     school   R36   Orleans Parish   WBM001 Einstein Charter High School at Sarah Towles Reed             2021 fall grade_9                                                   84                                             84
2027349 LA     school 2201380 043   Sabine Parish 220138001112 43006 Many High School   Regular School No High 09 12 2020 fall grade_9                                                   84                                             84
2299433 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2019 spring grade_9                                                   84                                             84
2300411 LA     school 2201890 060   Webster Parish 220189001450 60018 Lakeside Junior-Senior High School   Regular School No High 06 12 2019 spring grade_9                                                   84                                             84
2533648 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 fall grade_9                                                   84                                             84
2534307 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2019 fall grade_9                                                   84                                             84
1781469 LA     school 2201860 059   Washington Parish 220186001426 59008 Pine School   Regular School No High 06 12 2021 spring grade_9                                                   83                                             83
2027199 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2020 fall grade_9                                                   83                                             83
2027653 LA     school 2201860 059   Washington Parish 220186001426 59008 Pine School   Regular School No High 06 12 2020 fall grade_9                                                   83                                             83
2299908 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2019 spring grade_9                                                   83                                             83
2534812 LA     school 2201890 060   Webster Parish 220189001450 60018 Lakeside Junior-Senior High School   Regular School No High 06 12 2019 fall grade_9                                                   83                                             83
610579 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 09 12 2020 spring grade_9                                                   82                                             82
1780980 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2021 spring grade_9                                                   82                                             82
2004920 LA     school 2201320 041   Red River Parish 220132001090 41002 Red River High School   Regular School No High 09 12 2021 fall grade_9                                                   82                                             82
2027013 LA     school 2200840 026   Jefferson Parish 220084001964 26107 Thomas Jefferson High School for Advanced Studies   Regular School No High 09 12 2020 fall grade_9                                                   82                                             82
2027027 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Middle 06 10 2020 fall grade_9                                                   82                                             82
2533773 LA     school 2200300 009   Caddo Parish 220030000163 9025 Green Oaks Performing Arts Academy   Regular School No High 07 12 2019 fall grade_9                                                   82                                             82
610132 LA     school 2200150 005   Avoyelles Parish 220015001378 5025 LA School for Ag Science   Career and Technical School Yes High 07 12 2020 spring grade_9                                                   81                                             81
1780793 LA     school 2200840 026   Jefferson Parish 220084000604 26029 Fisher Middle/High School   Regular School No High 06 12 2021 spring grade_9                                                   81                                             81
1780993 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2021 spring grade_9                                                   81                                             81
1781143 LA     school 2201320 041   Red River Parish 220132001090 41002 Red River High School   Regular School No High 09 12 2021 spring grade_9                                                   81                                             81
2004747 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2021 fall grade_9                                                   81                                             81
2004805 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2021 fall grade_9                                                   81                                             81
2026566 LA     school 2200150 005   Avoyelles Parish 220015001378 5025 LA School for Ag Science   Career and Technical School Yes High 07 12 2020 fall grade_9                                                   81                                             81
2026918 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2020 fall grade_9                                                   81                                             81
2027214 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2020 fall grade_9                                                   81                                             81
2299298 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2019 spring grade_9                                                   81                                             81
610765 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2020 spring grade_9                                                   80                                             80
610951 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2020 spring grade_9                                                   80                                             80
1781038 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2021 spring grade_9                                                   80                                             80
2005262 LA     school 2201890 060   Webster Parish 220189001450 60018 Lakeside Junior-Senior High School   Regular School No High 06 12 2021 fall grade_9                                                   80                                             80
2027385 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2020 fall grade_9                                                   80                                             80
2299249 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 09 12 2019 spring grade_9                                                   80                                             80
2533697 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2019 fall grade_9                                                   80                                             80
610180 LA     school 2200270 008   Bossier Parish 220027000218 8036 Johnny Gray Jones Youth Shelter & Detention Center   Alternative School No Other KG 12 2020 spring grade_9                                                   8                                             8
610534 LA     school 2200840 026   Jefferson Parish 220084000606 26031 Grand Isle High School   Regular School No Other PK 12 2020 spring grade_9                                                   8                                             8
611319 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 spring grade_9                                                   8                                             8
611320 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 spring grade_9                                                   8                                             8
1780587 LA     school 2200420 013   Catahoula Parish 220042000295 13002 Central High School   Regular School No Other KG 12 2021 spring grade_9                                                   8                                             8
1780670 LA     school 2200540 017   East Baton Rouge Parish 220054000339 17092 EBR Readiness Superintendent Academy   Regular School No Other PK 12 2021 spring grade_9                                                   8                                             8
1781562 LA     school 2280100 101   Special School District 228010002014 101031 Renaissance Home for Youth   Special Education School No Other KG 12 2021 spring grade_9                                                   8                                             8
2005411 LA     school 2200047 A02   Office of Juvenile Justice 220004701780 A02002 Riverside Alternative High School   Alternative School No Other 01 12 2021 fall grade_9                                                   8                                             8
2026968 LA     school 2200840 026   Jefferson Parish 220084000606 26031 Grand Isle High School   Regular School No Other PK 12 2020 fall grade_9                                                   8                                             8
2027754 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001801789 304001 Louisiana School for the Deaf   Special Education School No Other PK 12 2020 fall grade_9                                                   8                                             8
2027755 LA     school 2200018 304   LA Schools for the Deaf and Visually Impaired 220001800193 304002 Louisiana School for the Visually Impaired   Special Education School No Other PK 12 2020 fall grade_9                                                   8                                             8
2299710 LA     school 2200840 026   Jefferson Parish 220084000606 26031 Grand Isle High School   Regular School No Other PK 12 2019 spring grade_9                                                   8                                             8
610480 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2020 spring grade_9                                                   79                                             79
1780505 LA     school 2200300 009   Caddo Parish 220030002377 9106 Magnolia School of Excellence   Regular School Yes Other KG 12 2021 spring grade_9                                                   79                                             79
1780893 LA     school 2200870 028   Lafayette Parish 220087000686 28027 Northside High School   Regular School No High 09 12 2021 spring grade_9                                                   79                                             79
1781084 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2021 spring grade_9                                                   79                                             79
1781547 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2021 spring grade_9                                                   79                                             79
2004560 LA     school 2200840 026   Jefferson Parish 220084000604 26029 Fisher Middle/High School   Regular School No High 06 12 2021 fall grade_9                                                   79                                             79
2533832 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2019 fall grade_9                                                   79                                             79
2534185 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2019 fall grade_9                                                   79                                             79
2534355 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2019 fall grade_9                                                   79                                             79
610780 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2020 spring grade_9                                                   78                                             78
610915 LA     school 2201380 043   Sabine Parish 220138001112 43006 Many High School   Regular School No High 09 12 2020 spring grade_9                                                   78                                             78
1780523 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2021 spring grade_9                                                   78                                             78
2004321 LA     school 2200330 010   Calcasieu Parish 220033000270 10056 Vinton High School   Regular School No High 09 12 2021 fall grade_9                                                   78                                             78
2004676 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2021 fall grade_9                                                   78                                             78
2004861 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2021 fall grade_9                                                   78                                             78
2005138 LA     school 2201680 053   Tangipahoa Parish 220168001310 53015 Kentwood High Magnet School   Regular School No High 07 12 2021 fall grade_9                                                   78                                             78
2534013 LA     school 2200570 018   East Carroll Parish 220057000454 18002 General Trass High School   Regular School No High 09 12 2019 fall grade_9                                                   78                                             78
610484 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2020 spring grade_9                                                   77                                             77
1780909 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2021 spring grade_9                                                   77                                             77
1781361 LA     school 2201680 053   Tangipahoa Parish 220168001310 53015 Kentwood High Magnet School   Regular School No High 07 12 2021 spring grade_9                                                   77                                             77
2004290 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2021 fall grade_9                                                   77                                             77
2026914 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2020 fall grade_9                                                   77                                             77
2027338 LA     school 2201350 042   Richland Parish 220135001100 42006 Mangham High School   Regular School No High 09 12 2020 fall grade_9                                                   77                                             77
2299786 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2019 spring grade_9                                                   77                                             77
2299954 LA     school 2201140 035   Natchitoches Parish 220114000101 35026 Lakeview Jr./Sr. High School   Regular School No High 07 12 2019 spring grade_9                                                   77                                             77
2533700 LA     school 2200150 005   Avoyelles Parish 220015001378 5025 LA School for Ag Science   Career and Technical School Yes High 07 12 2019 fall grade_9                                                   77                                             77
2534796 LA     school 2201860 059   Washington Parish 220186001426 59008 Pine School   Regular School No High 06 12 2019 fall grade_9                                                   77                                             77

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