Data source: Big Local News · About: Big Local

2,801 rows where grade = "grade_9", state = "LA" and year = 2020 sorted by total descending

View and edit SQL

year

  • 2020 · 2,801

grade

  • grade_9 · 2,801
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
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
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
610076 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 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
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
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
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
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
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
611366 LA     school   R36   Orleans Parish   397001 Sophie B. Wright Institute of Academic Excellence             2020 spring 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
2027869 LA     school   CHA   Type 2 Charters   WBX001 GEO Next Generation High School             2020 fall grade_9                                                   91                                             91
2027639 LA     school 2201830 058   Vernon Parish 220183001415 58012 Rosepine High School   Regular School No High 07 12 2020 fall grade_9                                                   90                                             90
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
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
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
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
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
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
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
610263 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2020 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
2027349 LA     school 2201380 043   Sabine Parish 220138001112 43006 Many High School   Regular School No High 09 12 2020 fall grade_9                                                   84                                             84
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
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
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
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
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
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
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
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
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
610480 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2020 spring 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
610484 LA     school 2200720 023   Iberia Parish 220072000523 23020 Loreauville High School   Regular School No High 07 12 2020 spring 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
2027084 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2020 fall grade_9                                                   76                                             76
2027823 LA     school   CHA   Type 2 Charters   W1A001 JCFA-East             2020 fall grade_9                                                   76                                             76
610595 LA     school 2200840 026   Jefferson Parish 220084002478 26130 Young Audiences Charter High School   Regular School No High 09 12 2020 spring grade_9                                                   75                                             75
610650 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2020 spring grade_9                                                   75                                             75
610904 LA     school 2201350 042   Richland Parish 220135001100 42006 Mangham High School   Regular School No High 09 12 2020 spring grade_9                                                   75                                             75
611404 LA     school   RBR   Recovery School District - Baton Rouge   WA7001 Capitol High School             2020 spring grade_9                                                   75                                             75
2026882 LA     school 2200600 019   East Feliciana Parish 220060002321 19015 Slaughter Community Charter School   Regular School Yes High 07 12 2020 fall grade_9                                                   75                                             75
2026942 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2020 fall grade_9                                                   75                                             75
610129 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2020 spring grade_9                                                   74                                             74
2026563 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2020 fall grade_9                                                   74                                             74
2027029 LA     school 2200840 026   Jefferson Parish 220084002478 26130 Young Audiences Charter High School   Regular School No High 09 12 2020 fall grade_9                                                   74                                             74
610294 LA     school 2200330 010   Calcasieu Parish 220033000270 10056 Vinton High School   Regular School No High 09 12 2020 spring grade_9                                                   73                                             73
610448 LA     school 2200600 019   East Feliciana Parish 220060002321 19015 Slaughter Community Charter School   Regular School Yes High 07 12 2020 spring grade_9                                                   73                                             73
610508 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2020 spring grade_9                                                   73                                             73
611388 LA     school   CHA   Type 2 Charters   W1A001 JCFA-East             2020 spring grade_9                                                   72                                             72
2026646 LA     school 2200300 009   Caddo Parish 220030000179 9042 North Caddo High School   Regular School No High 09 12 2020 fall grade_9                                                   71                                             71
610137 LA     school 2200180 006   Beauregard Parish 220018000083 6004 East Beauregard High School   Regular School No High 06 12 2020 spring grade_9                                                   70                                             70
2027839 LA     school   RBR   Recovery School District - Baton Rouge   WA7001 Capitol High School             2020 fall grade_9                                                   70                                             70
610345 LA     school 2200480 015   Concordia Parish 220048001515 15014 Concordia Education Center   Regular School No Other 03 12 2020 spring grade_9                                                   7                                             7
2026680 LA     school 2200300 009   Caddo Parish 220030002413 9109 Pathways in Education - North market   Regular School Yes High 09 12 2020 fall grade_9                                                   7                                             7
2027202 LA     school 2201110 034   Morehouse Parish 220111000778 34023 Morehouse Magnet School   Regular School No Other PK 09 2020 fall grade_9                                                   7                                             7
610698 LA     school 2200990 031   Lincoln Parish 220099000742 31003 Choudrant High School   Regular School No High 07 12 2020 spring grade_9                                                   69                                             69
2027132 LA     school 2200990 031   Lincoln Parish 220099000742 31003 Choudrant High School   Regular School No High 07 12 2020 fall grade_9                                                   69                                             69
610212 LA     school 2200300 009   Caddo Parish 220030000179 9042 North Caddo High School   Regular School No High 09 12 2020 spring grade_9                                                   68                                             68
610593 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Middle 06 10 2020 spring grade_9                                                   68                                             68
611333 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2020 spring grade_9                                                   68                                             68
2026571 LA     school 2200180 006   Beauregard Parish 220018000083 6004 East Beauregard High School   Regular School No High 06 12 2020 fall grade_9                                                   68                                             68
2027768 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2020 fall grade_9                                                   68                                             68
610205 LA     school 2200300 009   Caddo Parish 220030000163 9025 Green Oaks Performing Arts Academy   Regular School No High 07 12 2020 spring grade_9                                                   67                                             67
2026639 LA     school 2200300 009   Caddo Parish 220030000163 9025 Green Oaks Performing Arts Academy   Regular School No High 07 12 2020 fall grade_9                                                   67                                             67
2026728 LA     school 2200330 010   Calcasieu Parish 220033000270 10056 Vinton High School   Regular School No High 09 12 2020 fall grade_9                                                   67                                             67
2027155 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2020 fall grade_9                                                   67                                             67
610721 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2020 spring grade_9                                                   65                                             65
2027765 LA     school   CHA   Type 2 Charters   336001 Delhi Charter School             2020 fall grade_9                                                   65                                             65

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