Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2019 · 2,830

grade

  • grade_9 · 2,830
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
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
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
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
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
2300614 LA     school   R36   All Orleans   WBM001 Einstein Charter High School at Sarah Towles Reed             2019 spring grade_9                                                   95                                             95
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
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
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
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
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
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
2534989 LA     school   CHA   Type 2 Charters   W4B001 Lake Charles College Prep             2019 fall grade_9                                                   88                                             88
2300586 LA     school   CHA   Type 2 Charters   W4B001 Lake Charles College Prep             2019 spring grade_9                                                   87                                             87
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
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
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
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
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
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
2299298 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2019 spring grade_9                                                   81                                             81
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
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
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
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
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
2299374 LA     school 2200300 009   Caddo Parish 220030000163 9025 Green Oaks Performing Arts Academy   Regular School No High 07 12 2019 spring grade_9                                                   76                                             76
2299614 LA     school 2200570 018   East Carroll Parish 220057000454 18002 General Trass High School   Regular School No High 09 12 2019 spring grade_9                                                   76                                             76
2534942 LA     school   R36   All Orleans   385002 Walter L. Cohen College Prep             2019 fall grade_9                                                   76                                             76
2299301 LA     school 2200150 005   Avoyelles Parish 220015001378 5025 LA School for Ag Science   Career and Technical School Yes High 07 12 2019 spring grade_9                                                   75                                             75
2299464 LA     school 2200330 010   Calcasieu Parish 220033000270 10056 Vinton High School   Regular School No High 09 12 2019 spring grade_9                                                   75                                             75
2300395 LA     school 2201860 059   Washington Parish 220186001426 59008 Pine School   Regular School No High 06 12 2019 spring grade_9                                                   75                                             75
2299772 LA     school 2200840 026   Jefferson Parish 220084002419 26128 Jefferson RISE Charter School   Regular School Yes Middle 06 09 2019 spring grade_9                                                   73                                             73
2300568 LA     school   RBR   RSD-Baton Rouge   3B9001 Capitol High School             2019 spring grade_9                                                   73                                             73
2533863 LA     school 2200330 010   Calcasieu Parish 220033000270 10056 Vinton High School   Regular School No High 09 12 2019 fall grade_9                                                   72                                             72
2300013 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2019 spring grade_9                                                   71                                             71
2300348 LA     school 2201770 056   Union Parish 220177001376 56004 Union Parish High School   Regular School No High 06 12 2019 spring grade_9                                                   71                                             71
2534226 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2019 fall grade_9                                                   71                                             71
2534414 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2019 fall grade_9                                                   71                                             71
2534779 LA     school 2201830 058   Vernon Parish 220183001664 58009 Pickering High School   Regular School No High 07 12 2019 fall grade_9                                                   71                                             71
2534916 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2019 fall grade_9                                                   71                                             71
2299562 LA     school 2200540 017   East Baton Rouge Parish 220054000365 17065 Northeast High School   Regular School No High 07 12 2019 spring grade_9                                                   70                                             70
2299827 LA     school 2200870 028   Lafayette Parish 220087002072 28053 Early College Academy   Regular School No High 09 12 2019 spring grade_9                                                   70                                             70
2299784 LA     school 2200810 027   Jefferson Davis Parish 220081000572 27012 Lake Arthur High School   Regular School No High 07 12 2019 spring grade_9                                                   69                                             69
2300439 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2019 spring grade_9                                                   69                                             69
2300514 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2019 spring grade_9                                                   69                                             69
2534183 LA     school 2200810 027   Jefferson Davis Parish 220081000572 27012 Lake Arthur High School   Regular School No High 07 12 2019 fall grade_9                                                   69                                             69
2534913 LA     school   CHA   Type 2 Charters   336001 Delhi Charter School             2019 fall grade_9                                                   69                                             69
2300511 LA     school   CHA   Type 2 Charters   336001 Delhi Charter School             2019 spring grade_9                                                   68                                             68
2533961 LA     school 2200540 017   East Baton Rouge Parish 220054000365 17065 Northeast High School   Regular School No High 07 12 2019 fall grade_9                                                   68                                             68
2534841 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2019 fall grade_9                                                   68                                             68
2300577 LA     school   R36   All Orleans   W31001 Dr. Martin Luther King Charter School for Sci Tech             2019 spring grade_9                                                   67                                             67
2299861 LA     school 2200900 029   Lafourche Parish 220090002339 29040 Virtual Academy of Lafourche   Regular School Yes Other KG 12 2019 spring grade_9                                                   66                                             66
2300216 LA     school 2201620 051   St. Mary Parish 220162001253 51039 West St. Mary High School   Regular School No High 09 12 2019 spring grade_9                                                   66                                             66
2300510 LA     school 2200036 334   New Orleans Center for Creative Arts 220003601499 334001 New Orleans Center for Creative Arts   Special Education School No High 09 12 2019 spring grade_9                                                   66                                             66
2534021 LA     school 2200600 019   East Feliciana Parish 220060002321 19015 Slaughter Community Charter School   Regular School Yes High 07 12 2019 fall grade_9                                                   66                                             66
2534606 LA     school 2201620 051   St. Mary Parish 220162001242 51012 Franklin Senior High School   Regular School No High 09 12 2019 fall grade_9                                                   66                                             66
2534912 LA     school 2200036 334   New Orleans Center for Creative Arts 220003601499 334001 New Orleans Center for Creative Arts   Special Education School No High 09 12 2019 fall grade_9                                                   66                                             66
2300093 LA     school 2201380 043   Sabine Parish 220138001118 43012 Zwolle High School   Regular School No High 07 12 2019 spring grade_9                                                   65                                             65
2300370 LA     school 2201830 058   Vernon Parish 220183001405 58001 Anacoco High School   Regular School No High 07 12 2019 spring grade_9                                                   65                                             65
2533780 LA     school 2200300 009   Caddo Parish 220030000179 9042 North Caddo High School   Regular School No High 09 12 2019 fall grade_9                                                   65                                             65
2534494 LA     school 2201380 043   Sabine Parish 220138001118 43012 Zwolle High School   Regular School No High 07 12 2019 fall grade_9                                                   65                                             65
2534617 LA     school 2201620 051   St. Mary Parish 220162001253 51039 West St. Mary High School   Regular School No High 09 12 2019 fall grade_9                                                   65                                             65
2534980 LA     school   R36   All Orleans   W31001 Dr. Martin Luther King Charter School for Sci/Tech             2019 fall grade_9                                                   65                                             65
2299684 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2019 spring grade_9                                                   64                                             64
2299895 LA     school 2201020 032   Livingston Parish 220102000762 32009 French Settlement High School   Regular School No High 07 12 2019 spring grade_9                                                   64                                             64
2533627 LA     school 2200030 001   Acadia Parish 220003000016 1017 Midland High School   Regular School No High 06 12 2019 fall grade_9                                                   64                                             64
2534083 LA     school 2200780 025   Jackson Parish 220078000555 25005 Jonesboro-Hodge High School   Regular School No High 09 12 2019 fall grade_9                                                   64                                             64

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