Data source: Big Local News · About: Big Local

47,532 rows where state = "LA" and year = 2021 sorted by total_int

View and edit SQL

grade

year

  • 2021 · 19,319
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 ▼
2001412 LA     school 2200270 008   Bossier Parish 220027000218 8036 Johnny Gray Jones Youth Shelter & Detention Center   Alternative School No Other KG 12 2021 fall grade_7                                                   1                                             1
2001576 LA     school 2200480 015   Concordia Parish 220048001515 15014 Concordia Education Center   Regular School No Other 03 12 2021 fall grade_7                                                   1                                             1
2001677 LA     school 2200600 019   East Feliciana Parish 220060000715 19013 East Feliciana Parish Enrichment Academy   Regular School No Other 01 12 2021 fall grade_7                                                   1                                             1
2001881 LA     school 2200870 028   Lafayette Parish 220087002441 28056 Edward J Sam Accelerated School of Lafayette   Regular School No High 07 12 2021 fall grade_7                                                   1                                             1
2002014 LA     school 2201170 R36   Orleans Parish 220117001522 36132 Travis Hill School   Regular School No Other 03 12 2021 fall grade_7                                                   1                                             1
2002543 LA     school 2280100 101   Special School District 228010002351 101036 Methodist Home for Children of Greater New Orleans   Special Education School No Other KG 12 2021 fall grade_7                                                   1                                             1
2002544 LA     school 2280100 101   Special School District 228010002497 101041 Central Louisiana Supports and Services Center   Regular School No Other KG 12 2021 fall grade_7                                                   1                                             1
2002615 LA     school 2200047 A02   Office of Juvenile Justice 220004702462 A02004 Central Southwest Alternative High School   Alternative School No Other KG 12 2021 fall grade_7                                                   1                                             1
2002872 LA     school 2200300 009   Caddo Parish 220030002343 9104 Academic Recovery Ombudsman   Regular School No Other 02 12 2021 fall grade_8                                                   1                                             1
2003208 LA     school 2200840 026   Jefferson Parish 220084002044 26112 Strehle Community School   Regular School No High 08 12 2021 fall grade_8                                                   1                                             1
2003907 LA     school 2201080 065   City of Monroe School District 220108002019 65023 Sherrouse School   Regular School No Other KG 12 2021 fall grade_8                                                   1                                             1
2003943 LA     school 2280100 101   Special School District 228010002497 101041 Central Louisiana Supports and Services Center   Regular School No Other KG 12 2021 fall grade_8                                                   1                                             1
2004016 LA     school   CHA   Type 2 Charters   W1A001 JCFA-East             2021 fall grade_8                                                   1                                             1
2004210 LA     school 2200270 008   Bossier Parish 220027000218 8036 Johnny Gray Jones Youth Shelter & Detention Center   Alternative School No Other KG 12 2021 fall grade_9                                                   1                                             1
2005187 LA     school 2201740 055   Terrebonne Parish 220174001653 55032 School for Exceptional Children   Special Education School No Other PK 12 2021 fall grade_9                                                   1                                             1
2005564 LA     school 2200180 006   Beauregard Parish 220018000081 6002 DeRidder High School   Regular School No High 08 12 2021 fall grade_9_transitional                                                   1                                             1
2005689 LA     school 2200330 010   Calcasieu Parish 220033000227 10014 DeQuincy High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2005728 LA     school 2200330 010   Calcasieu Parish 220033000278 10064 Westlake High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2005776 LA     school 2200510 016   DeSoto Parish 220051000334 16007 Mansfield High School   Regular School No High 08 12 2021 fall grade_9_transitional                                                   1                                             1
2005788 LA     school 2200540 017   East Baton Rouge Parish 220054000349 17010 Belaire High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2005853 LA     school 2200540 017   East Baton Rouge Parish 220054002311 17133 Mentorship STEAM Academy   Regular School Yes High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2005877 LA     school 2200630 020   Evangeline Parish 220063000470 20001 Basile High School   Regular School No Other 04 12 2021 fall grade_9_transitional                                                   1                                             1
2006073 LA     school 2200870 028   Lafayette Parish 220087001397 28050 Lerosen Preparatory Academy   Regular School No Other KG 12 2021 fall grade_9_transitional                                                   1                                             1
2006123 LA     school 2200990 031   Lincoln Parish 220099000742 31003 Choudrant High School   Regular School No High 07 12 2021 fall grade_9_transitional                                                   1                                             1
2006153 LA     school 2201020 032   Livingston Parish 220102000768 32017 Maurepas School   Regular School No Other PK 12 2021 fall grade_9_transitional                                                   1                                             1
2006189 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2021 fall grade_9_transitional                                                   1                                             1
2006260 LA     school 2201230 038   Plaquemines Parish 220123002028 38013 South Plaquemines High School   Regular School No High 07 12 2021 fall grade_9_transitional                                                   1                                             1
2006482 LA     school 2201650 052   St. Tammany Parish 220165001274 52013 Covington High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2006521 LA     school 2201650 052   St. Tammany Parish 220165002255 52061 Lakeshore High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2006539 LA     school 2201680 053   Tangipahoa Parish 220168001312 53017 Loranger High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2006599 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 fall grade_9_transitional                                                   1                                             1
2006624 LA     school 2201830 058   Vernon Parish 220183001409 58005 Hornbeck High School   Regular School No Other PK 12 2021 fall grade_9_transitional                                                   1                                             1
2006629 LA     school 2201830 058   Vernon Parish 220183001413 58010 Pitkin High School   Regular School No Other PK 12 2021 fall grade_9_transitional                                                   1                                             1
2006647 LA     school 2201860 059   Washington Parish 220186001429 59011 Varnado High School   Regular School No High 06 12 2021 fall grade_9_transitional                                                   1                                             1
2006676 LA     school 2201950 062   West Carroll Parish 220195001471 62005 Kilbourne High School   Regular School No Other PK 12 2021 fall grade_9_transitional                                                   1                                             1
2006744 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 2021 fall grade_9_transitional                                                   1                                             1
2006818 LA     school   R36   Orleans Parish   W31001 Dr. Martin Luther King Charter School for Sci Tech             2021 fall grade_9_transitional                                                   1                                             1
2006828 LA     school   RBR   Recovery School District - Baton Rouge   WA7001 Capitol High School             2021 fall grade_9_transitional                                                   1                                             1
2006839 LA     school   R36   Orleans Parish   WBD001 Edna Karr High School             2021 fall grade_9_transitional                                                   1                                             1
2006848 LA     school   R36   Orleans Parish   WBM001 Einstein Charter High School at Sarah Towles Reed             2021 fall grade_9_transitional                                                   1                                             1
2008142 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 2021 fall kindergarten                                                   1                                             1
2009005 LA     school 2201140 035   Natchitoches Parish 220114002022 35032 Lakeview Annex   Regular School No Other 04 12 2021 fall pk_12_total 0.0 1.0 0.0 0.0   0.0     0.0   0.0   1.0 0.0     0.0       1.0         1 0 1 0 0   0     0   0   1 0     0   1       1
2009177 LA     school   046   St. Helena Parish   46700 St. Helena Central Office             2021 fall pk_12_total 0.0 1.0 0.0 0.0   0.0     0.0   0.0   1.0 0.0     0.0       1.0         1 0 1 0 0   0     0   0   1 0     0   1       1
2009477 LA     school   063   West Feliciana Parish   63000 Administrative Services -- Special Education             2021 fall pk_12_total 0.0 1.0 0.0 0.0   0.0     0.0   0.0   1.0 0.0     0.0       0.0         1 0 1 0 0   0     0   0   1 0     0   0       1
2009889 LA     school 2200330 010   Calcasieu Parish 220033000230 10018 Fairview Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten                                                   1                                             1
2009946 LA     school 2200390 012   Cameron Parish 220039000291 12005 Johnson Bayou High School   Regular School No Other PK 12 2021 fall pre_kindergarten                                                   1                                             1
2010420 LA     school 2201200 037   Ouachita Parish 220120000992 37010 Highland Elementary School   Regular School No Elementary PK 05 2021 fall pre_kindergarten                                                   1                                             1
1763692 LA     school 2200300 009   Caddo Parish 220030000147 9008 C.E. Byrd High School   Regular School No High 09 13 2021 spring extension_academy                                                   2                                             2
1764881 LA     school   R36   Orleans Parish   395005 Lord Beaconsfield Landry High School             2021 spring extension_academy                                                   2                                             2
1764890 LA     school   R36   Orleans Parish   398009 John F. Kennedy High School             2021 spring extension_academy                                                   2                                             2
1764926 LA     school   R36   Orleans Parish   WZB001 Warren Easton Charter High School             2021 spring extension_academy                                                   2                                             2
1765216 LA     school 2200390 012   Cameron Parish 220039000291 12005 Johnson Bayou High School   Regular School No Other PK 12 2021 spring grade_1                                                   2                                             2
1765220 LA     school 2200420 013   Catahoula Parish 220042000295 13002 Central High School   Regular School No Other KG 12 2021 spring grade_1                                                   2                                             2
1766197 LA     school 2280100 101   Special School District 228010002497 101041 Central Louisiana Supports and Services Center   Regular School No Other KG 12 2021 spring grade_1                                                   2                                             2
1766200 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 2021 spring grade_1                                                   2                                             2
1767163 LA     school 2201290 040   Rapides Parish 220129000115 40054 Rapides Training Academy   Special Education School No Other KG 12 2021 spring grade_10                                                   2                                             2
1767440 LA     school 2201740 055   Terrebonne Parish 220174001653 55032 School for Exceptional Children   Special Education School No Other PK 12 2021 spring grade_10                                                   2                                             2
1769844 LA     school 2201050 033   Madison Parish 220105010412 33010 Christian Acres Alternative School   Regular School No High 06 12 2021 spring grade_12                                                   2                                             2
1770424 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2021 spring grade_12                                                   2                                             2
1772205 LA     school 2200420 013   Catahoula Parish 220042000295 13002 Central High School   Regular School No Other KG 12 2021 spring grade_3                                                   2                                             2
1773181 LA     school 2280100 101   Special School District 228010002351 101036 Methodist Home for Children of Greater New Orleans   Special Education School No Other KG 12 2021 spring grade_3                                                   2                                             2
1773182 LA     school 2280100 101   Special School District 228010002497 101041 Central Louisiana Supports and Services Center   Regular School No Other KG 12 2021 spring grade_3                                                   2                                             2
1774578 LA     school 2280100 101   Special School District 228010002351 101036 Methodist Home for Children of Greater New Orleans   Special Education School No Other KG 12 2021 spring grade_4                                                   2                                             2
1775381 LA     school   031   Lincoln Parish   31022 Howard School             2021 spring grade_5                                                   2                                             2
1775976 LA     school 2280100 101   Special School District 228010002497 101041 Central Louisiana Supports and Services Center   Regular School No Other KG 12 2021 spring grade_5                                                   2                                             2
1776645 LA     school 2200840 026   Jefferson Parish 220084001518 26103 Frederick Douglass Community School   Regular School No Middle 03 08 2021 spring grade_6                                                   2                                             2
1776829 LA     school 2201050 033   Madison Parish 220105010412 33010 Christian Acres Alternative School   Regular School No High 06 12 2021 spring grade_6                                                   2                                             2
1777219 LA     school 2201740 055   Terrebonne Parish 220174001653 55032 School for Exceptional Children   Special Education School No Other PK 12 2021 spring grade_6                                                   2                                             2
1777365 LA     school 2280100 101   Special School District 228010001730 101010 Pinecrest Supports & Services Center   Special Education School No Other KG 12 2021 spring grade_6                                                   2                                             2
1777373 LA     school 2280100 101   Special School District 228010002497 101041 Central Louisiana Supports and Services Center   Regular School No Other KG 12 2021 spring grade_6                                                   2                                             2
1778226 LA     school 2201050 033   Madison Parish 220105010412 33010 Christian Acres Alternative School   Regular School No High 06 12 2021 spring grade_7                                                   2                                             2
1778350 LA     school 2201320 041   Red River Parish 220132000784 41008 Ware Youth Center   Regular School No Other KG 12 2021 spring grade_7                                                   2                                             2
1778780 LA     school 2200047 A02   Office of Juvenile Justice 220004701781 A02003 Southside Alternative High School   Alternative School No Other 01 12 2021 spring grade_7                                                   2                                             2
1779107 LA     school 2200300 009   Caddo Parish 220030002343 9104 Academic Recovery Ombudsman   Regular School No Other 02 12 2021 spring grade_8                                                   2                                             2
1779187 LA     school 2200390 012   Cameron Parish 220039000293 12007 South Cameron High School   Regular School No Other PK 12 2021 spring grade_8                                                   2                                             2
1779443 LA     school 2200840 026   Jefferson Parish 220084002044 26112 Strehle Community School   Regular School No High 08 12 2021 spring grade_8                                                   2                                             2
1780176 LA     school 2200047 A02   Office of Juvenile Justice 220004701780 A02002 Riverside Alternative High School   Alternative School No Other 01 12 2021 spring grade_8                                                   2                                             2
1780194 LA     school   CHA   Type 2 Charters   W1A001 JCFA-East             2021 spring grade_8                                                   2                                             2
1781567 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 2021 spring grade_9                                                   2                                             2
1781831 LA     school 2200270 008   Bossier Parish 220027000132 8022 Plain Dealing High School   Regular School No Other PK 12 2021 spring grade_9_transitional                                                   2                                             2
1781953 LA     school 2200330 010   Calcasieu Parish 220033000272 10058 Washington/Marion Magnet High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1782064 LA     school 2200540 017   East Baton Rouge Parish 220054000434 17088 Tara High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1782116 LA     school 2200630 020   Evangeline Parish 220063000482 20014 Ville Platte High School   Regular School No High 07 12 2021 spring grade_9_transitional                                                   2                                             2
1782370 LA     school 2201020 032   Livingston Parish 220102000755 32002 Albany High School   Regular School No High 08 12 2021 spring grade_9_transitional                                                   2                                             2
1782384 LA     school 2201020 032   Livingston Parish 220102000768 32017 Maurepas School   Regular School No Other PK 12 2021 spring grade_9_transitional                                                   2                                             2
1782508 LA     school 2201290 040   Rapides Parish 220129001064 40028 Oak Hill High School   Regular School No Other PK 12 2021 spring grade_9_transitional                                                   2                                             2
1782515 LA     school 2201290 040   Rapides Parish 220129001071 40035 Plainview High School   Regular School No Other PK 12 2021 spring grade_9_transitional                                                   2                                             2
1782749 LA     school 2201680 053   Tangipahoa Parish 220168001298 53002 Amite High Magnet   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1782765 LA     school 2201680 053   Tangipahoa Parish 220168001319 53024 Ponchatoula High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1782820 LA     school 2201800 057   Vermilion Parish 220180001385 57001 Abbeville High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1782891 LA     school 2201920 061   West Baton Rouge Parish 220192001464 61008 Port Allen High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1782898 LA     school 2201950 062   West Carroll Parish 220195001471 62005 Kilbourne High School   Regular School No Other PK 12 2021 spring grade_9_transitional                                                   2                                             2
1782925 LA     school 2201080 065   City of Monroe School District 220108000803 65018 Wossman High School   Regular School No High 09 12 2021 spring grade_9_transitional                                                   2                                             2
1783047 LA     school   R36   Orleans Parish   398005 Frederick A. Douglass High School             2021 spring grade_9_transitional                                                   2                                             2
1783051 LA     school   R36   Orleans Parish   398009 John F. Kennedy High School             2021 spring grade_9_transitional                                                   2                                             2
1783076 LA     school   R36   Orleans Parish   WBM001 Einstein Charter High School at Sarah Towles Reed             2021 spring grade_9_transitional                                                   2                                             2
1784360 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 2021 spring kindergarten                                                   2                                             2
1784361 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 2021 spring kindergarten                                                   2                                             2
1785394 LA     school   046   St. Helena Parish   46700 St. Helena Central Office             2021 spring pk_12_total 0.0 2.0 0.0 0.0   0.0     0.0   0.0   2.0 0.0     0.0       2.0         2 0 2 0 0   0     0   0   2 0     0   2       2
1786250 LA     school 2200540 017   East Baton Rouge Parish 220054000425 17081 Sharon Hills Elementary School   Regular School No Elementary PK 05 2021 spring pre_kindergarten                                                   2                                             2

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