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,427
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
611002 LA     school 2201560 049   St. Landry Parish 220156001210 49056 Port Barre High School   Regular School No High 09 12 2020 spring grade_9                                                   99                                             99
1780851 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Secondary 06 11 2021 spring grade_9                                                   99                                             99
2004618 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Secondary 06 11 2021 fall grade_9                                                   99                                             99
2004790 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2021 fall grade_9                                                   99                                             99
2005464 LA     school   CHA   Type 2 Charters   WJ5001 Collegiate Baton Rouge             2021 fall grade_9                                                   99                                             99
2026770 LA     school 2200480 015   Concordia Parish 220048000317 15002 Ferriday High School   Regular School No High 08 12 2020 fall grade_9                                                   99                                             99
2027328 LA     school 2201320 041   Red River Parish 220132001090 41002 Red River High School   Regular School No High 09 12 2020 fall grade_9                                                   99                                             99
2534293 LA     school 2201020 032   Livingston Parish 220102000761 32008 Doyle High School   Regular School No High 06 12 2019 fall grade_9                                                   99                                             99
2534875 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2019 fall grade_9                                                   99                                             99
611296 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2020 spring grade_9                                                   98                                             98
2004235 LA     school 2200300 009   Caddo Parish 220030000163 9025 Green Oaks Performing Arts Academy   Regular School No High 07 12 2021 fall grade_9                                                   98                                             98
2300079 LA     school 2201350 042   Richland Parish 220135001102 42008 Rayville High School   Career and Technical School No High 09 12 2019 spring grade_9                                                   98                                             98
2300211 LA     school 2201620 051   St. Mary Parish 220162001254 51024 Patterson High School   Regular School No High 09 12 2019 spring grade_9                                                   98                                             98
2300573 LA     school   CHA   Type 2 Charters   W1A001 JCFA-East             2019 spring grade_9                                                   98                                             98
2534339 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2019 fall grade_9                                                   98                                             98
2534489 LA     school 2201380 043   Sabine Parish 220138001112 43006 Many High School   Regular School No High 09 12 2019 fall grade_9                                                   98                                             98
610076 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 spring grade_9                                                   97                                             97
1780337 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2021 spring grade_9                                                   97                                             97
2027168 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2020 fall grade_9                                                   97                                             97
2027192 LA     school 2201050 033   Madison Parish 220105000780 33002 Madison High School   Regular School No High 08 12 2020 fall grade_9                                                   97                                             97
2299631 LA     school 2200630 020   Evangeline Parish 220063000482 20014 Ville Platte High School   Regular School No High 06 12 2019 spring grade_9                                                   97                                             97
2534030 LA     school 2200630 020   Evangeline Parish 220063000482 20014 Ville Platte High School   Regular School No High 06 12 2019 fall grade_9                                                   97                                             97
611041 LA     school 2201620 051   St. Mary Parish 220162001253 51039 West St. Mary High School   Regular School No High 09 12 2020 spring grade_9                                                   96                                             96
1781207 LA     school 2201500 047   St. James Parish 220150001167 47008 St. James High School   Regular School No High 07 12 2021 spring grade_9                                                   96                                             96
2004984 LA     school 2201500 047   St. James Parish 220150001167 47008 St. James High School   Regular School No High 07 12 2021 fall grade_9                                                   96                                             96
2005063 LA     school 2201620 051   St. Mary Parish 220162001254 51024 Patterson High School   Regular School No High 09 12 2021 fall grade_9                                                   96                                             96
2027436 LA     school 2201560 049   St. Landry Parish 220156001210 49056 Port Barre High School   Regular School No High 09 12 2020 fall grade_9                                                   96                                             96
2027696 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 fall grade_9                                                   96                                             96
2300088 LA     school 2201380 043   Sabine Parish 220138001112 43006 Many High School   Regular School No High 09 12 2019 spring grade_9                                                   96                                             96
2300282 LA     school 2201680 053   Tangipahoa Parish 220168001307 53012 Independence High Magnet   Regular School No High 09 12 2019 spring grade_9                                                   96                                             96
2535017 LA     school   R36   All Orleans   WBM001 Einstein Charter High School at Sarah Towles Reed             2019 fall grade_9                                                   96                                             96
611262 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 spring grade_9                                                   95                                             95
611424 LA     school   R36   Orleans Parish   WBM001 Einstein Charter High School at Sarah Towles Reed             2020 spring grade_9                                                   95                                             95
2300614 LA     school   R36   All Orleans   WBM001 Einstein Charter High School at Sarah Towles Reed             2019 spring grade_9                                                   95                                             95
610348 LA     school 2200510 016   DeSoto Parish 220051000334 16007 Mansfield High School   Regular School No High 08 12 2020 spring grade_9                                                   94                                             94
610454 LA     school 2200630 020   Evangeline Parish 220063000478 20010 Pine Prairie High School   Regular School No Other PK 12 2020 spring grade_9                                                   94                                             94
611205 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2020 spring grade_9                                                   94                                             94
1781023 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2021 spring grade_9                                                   94                                             94
1781291 LA     school 2201620 051   St. Mary Parish 220162001253 51039 West St. Mary High School   Regular School No High 09 12 2021 spring grade_9                                                   94                                             94
2004977 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2021 fall grade_9                                                   94                                             94
2005456 LA     school   R36   Orleans Parish   WBU001 Rosenwald Collegiate Academy             2021 fall grade_9                                                   94                                             94
2026782 LA     school 2200510 016   DeSoto Parish 220051000334 16007 Mansfield High School   Regular School No High 08 12 2020 fall grade_9                                                   94                                             94
2027475 LA     school 2201620 051   St. Mary Parish 220162001253 51039 West St. Mary High School   Regular School No High 09 12 2020 fall grade_9                                                   94                                             94
2027541 LA     school 2201680 053   Tangipahoa Parish 220168001307 53012 Independence High Magnet   Regular School No High 09 12 2020 fall grade_9                                                   94                                             94
2027730 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2020 fall grade_9                                                   94                                             94
2299939 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2019 spring grade_9                                                   94                                             94
2534782 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2019 fall grade_9                                                   94                                             94
1780339 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2021 spring grade_9                                                   93                                             93
2534480 LA     school 2201350 042   Richland Parish 220135001102 42008 Rayville High School   Career and Technical School No High 09 12 2019 fall grade_9                                                   93                                             93
2534532 LA     school 2201500 047   St. James Parish 220150001167 47008 St. James High School   Regular School No High 07 12 2019 fall grade_9                                                   93                                             93
2534683 LA     school 2201680 053   Tangipahoa Parish 220168001307 53012 Independence High Magnet   Regular School No High 09 12 2019 fall grade_9                                                   93                                             93
611366 LA     school   R36   Orleans Parish   397001 Sophie B. Wright Institute of Academic Excellence             2020 spring grade_9                                                   92                                             92
1781155 LA     school 2201350 042   Richland Parish 220135001102 42008 Rayville High School   Career and Technical School No High 09 12 2021 spring grade_9                                                   92                                             92
2004106 LA     school 2200060 002   Allen Parish 220006000029 2006 Oakdale High School   Regular School No High 08 12 2021 fall grade_9                                                   92                                             92
2026888 LA     school 2200630 020   Evangeline Parish 220063000478 20010 Pine Prairie High School   Regular School No Other PK 12 2020 fall grade_9                                                   92                                             92
2299257 LA     school 2200090 003   Ascension Parish 220009000036 3003 Donaldsonville High School   Regular School No High 09 12 2019 spring grade_9                                                   92                                             92
2300131 LA     school 2201500 047   St. James Parish 220150001167 47008 St. James High School   Regular School No High 07 12 2019 spring grade_9                                                   92                                             92
1780598 LA     school 2200480 015   Concordia Parish 220048000317 15002 Ferriday High School   Regular School No High 08 12 2021 spring grade_9                                                   91                                             91
1781684 LA     school   R36   Orleans Parish   WBU001 Rosenwald Collegiate Academy             2021 spring grade_9                                                   91                                             91
2004932 LA     school 2201350 042   Richland Parish 220135001102 42008 Rayville High School   Career and Technical School No High 09 12 2021 fall grade_9                                                   91                                             91
2005068 LA     school 2201620 051   St. Mary Parish 220162001253 51039 West St. Mary High School   Regular School No High 09 12 2021 fall grade_9                                                   91                                             91
2005232 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2021 fall grade_9                                                   91                                             91
2027869 LA     school   CHA   Type 2 Charters   WBX001 GEO Next Generation High School             2020 fall grade_9                                                   91                                             91
2300527 LA     school   R36   All Orleans   368001 Morris Jeff Community School             2019 spring grade_9                                                   91                                             91
2534863 LA     school 2200240 066   City of Bogalusa School District 220024000103 66002 Bogalusa High School   Regular School No High 07 12 2019 fall grade_9                                                   91                                             91
1781200 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2021 spring grade_9                                                   90                                             90
2004635 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2021 fall grade_9                                                   90                                             90
2027639 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2020 fall grade_9                                                   90                                             90
2299660 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2019 spring grade_9                                                   90                                             90
2534059 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2019 fall grade_9                                                   90                                             90
1780413 LA     school 2200210 007   Bienville Parish 220021000095 7006 Gibsland-Coleman High School   Regular School No Other PK 12 2021 spring grade_9                                                   9                                             9
1780507 LA     school 2200300 009   Caddo Parish 220030002426 9110 Caddo Virtual Academy   Regular School No High 09 12 2021 spring grade_9                                                   9                                             9
1780795 LA     school 2200840 026   Jefferson Parish 220084000606 26031 Grand Isle High School   Regular School No Other PK 12 2021 spring grade_9                                                   9                                             9
1781144 LA     school 2201320 041   Red River Parish 220132000784 41008 Ware Youth Center   Regular School No Other KG 12 2021 spring grade_9                                                   9                                             9
2004562 LA     school 2200840 026   Jefferson Parish 220084000606 26031 Grand Isle High School   Regular School No Other PK 12 2021 fall grade_9                                                   9                                             9
2004952 LA     school 2201410 044   St. Bernard Parish 220141000816 44019 C.F. Rowley Alternative School   Regular School No High 06 12 2021 fall grade_9                                                   9                                             9
2005334 LA     school 2280100 101   Special School District 228010001730 101010 Pinecrest Supports & Services Center   Special Education School No Other KG 12 2021 fall grade_9                                                   9                                             9
2027740 LA     school 2280100 101   Special School District 228010001730 101010 Pinecrest Supports & Services Center   Special Education School No Other KG 12 2020 fall grade_9                                                   9                                             9
2299516 LA     school 2200480 015   Concordia Parish 220048001515 15014 Concordia Education Center   Regular School No Other 04 12 2019 spring grade_9                                                   9                                             9
2300491 LA     school 2280100 101   Special School District 228010002014 101031 Renaissance Home for Youth   Special Education School No Other KG 12 2019 spring grade_9                                                   9                                             9
2533652 LA     school 2200060 002   Allen Parish 220006000033 2010 Reeves High School   Regular School No Other PK 12 2019 fall grade_9                                                   9                                             9
2534903 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 2019 fall grade_9                                                   9                                             9
610758 LA     school 2201050 033   Madison Parish 220105000780 33002 Madison High School   Regular School No High 08 12 2020 spring grade_9                                                   89                                             89
611107 LA     school 2201680 053   Tangipahoa Parish 220168001307 53012 Independence High Magnet   Regular School No High 09 12 2020 spring grade_9                                                   89                                             89
1780468 LA     school 2200300 009   Caddo Parish 220030000163 9025 Green Oaks Performing Arts Academy   Regular School No High 07 12 2021 spring grade_9                                                   89                                             89
2026697 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2020 fall grade_9                                                   89                                             89
610457 LA     school 2200630 020   Evangeline Parish 220063000482 20014 Ville Platte High School   Regular School No High 07 12 2020 spring grade_9                                                   88                                             88
1781017 LA     school 2201050 033   Madison Parish 220105000780 33002 Madison High School   Regular School No High 08 12 2021 spring grade_9                                                   88                                             88
1781679 LA     school   R36   Orleans Parish   WBM001 Einstein Charter High School at Sarah Towles Reed             2021 spring grade_9                                                   88                                             88
1781696 LA     school   RBR   Recovery School District - Baton Rouge   WA7001 Capitol High School             2021 spring grade_9                                                   88                                             88
2026891 LA     school 2200630 020   Evangeline Parish 220063000482 20014 Ville Platte High School   Regular School No High 07 12 2020 fall grade_9                                                   88                                             88
2534989 LA     school   CHA   Type 2 Charters   W4B001 Lake Charles College Prep             2019 fall grade_9                                                   88                                             88
610609 LA     school 2200810 027   Jefferson Davis Parish 220081000574 27014 Welsh High School   Regular School No High 09 12 2020 spring grade_9                                                   87                                             87
610839 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2020 spring grade_9                                                   87                                             87
611219 LA     school 2201860 059   Washington Parish 220186001426 59008 Pine School   Regular School No High 06 12 2020 spring grade_9                                                   87                                             87
2004159 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2021 fall grade_9                                                   87                                             87
2004784 LA     school 2201050 033   Madison Parish 220105000780 33002 Madison High School   Regular School No High 08 12 2021 fall grade_9                                                   87                                             87
2005246 LA     school 2201860 059   Washington Parish 220186001426 59008 Pine School   Regular School No High 06 12 2021 fall grade_9                                                   87                                             87
2005429 LA     school   RBR   Recovery School District - Baton Rouge   WA7001 Capitol High School             2021 fall grade_9                                                   87                                             87
2300586 LA     school   CHA   Type 2 Charters   W4B001 Lake Charles College Prep             2019 spring grade_9                                                   87                                             87

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