Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 2,701

grade

  • grade_7 · 2,701
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
2024973 LA     school   R36   Orleans Parish   360001 The NET Charter High School             2020 fall grade_7                                                   0                                             0
2024972 LA     school   CHA   Type 2 Charters   348001 New Orleans Military & Maritime Academy             2020 fall grade_7                                                   0                                             0
2024971 LA     school   CHA   Type 2 Charters   347001 Lycee Francais de la Nouvelle-Orleans             2020 fall grade_7                                                   85                                             85
2024970 LA     school   CHA   Type 2 Charters   346001 Lake Charles Charter Academy             2020 fall grade_7                                                   111                                             111
2024969 LA     school   CHA   Type 2 Charters   345001 University View Academy, Inc. (FRM LA Connections)             2020 fall grade_7                                                   283                                             283
2024968 LA     school   CHA   Type 2 Charters   344001 International High School of New Orleans             2020 fall grade_7                                                   0                                             0
2024967 LA     school   CHA   Type 2 Charters   343001 Madison Preparatory Academy             2020 fall grade_7                                                   0                                             0
2024966 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2020 fall grade_7                                                   76                                             76
2024965 LA     school   CHA   Type 2 Charters   340001 The MAX Charter School             2020 fall grade_7                                                   12                                             12
2024964 LA     school   CHA   Type 2 Charters   337001 Belle Chasse Academy             2020 fall grade_7                                                   105                                             105
2024963 LA     school   CHA   Type 2 Charters   336001 Delhi Charter School             2020 fall grade_7                                                   66                                             66
2024962 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 2020 fall grade_7                                                   0                                             0
2024961 LA     school   CHA   Type 2 Charters   333001 Avoyelles Public Charter School             2020 fall grade_7                                                   54                                             54
2024960 LA     school   CHA   Type 2 Charters   331001 International School of Louisiana             2020 fall grade_7                                                   122                                             122
2024959 LA     school   CHA   Type 2 Charters   329001 V. B. Glencoe Charter School             2020 fall grade_7                                                   33                                             33
2024958 LA     school   CHA   Type 2 Charters   321001 New Vision Learning Academy             2020 fall grade_7                                                   0                                             0
2024957 LA     school 2200023 319   Southern University Lab School 220002302402 319002 Southern University Laboratory Virtual School   Regular School No Other KG 12 2020 fall grade_7                                                   24                                             24
2024956 LA     school 2200023 319   Southern University Lab School 220002301921 319001 Southern University Lab School   Regular School No Other PK 12 2020 fall grade_7                                                   18                                             18
2024955 LA     school 2200022 318   LSU Laboratory School 220002201922 318001 LSU Laboratory School   Regular School No Other KG 12 2020 fall grade_7                                                   112                                             112
2024954 LA     school 2200020 306   Central Louisiana Supports and Services Center 220002000267 306001 Central Louisiana Supports and Services Center   Special Education School No Other PK 12 2020 fall grade_7                                                   6                                             6
2024953 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_7                                                   1                                             1
2024952 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_7                                                   6                                             6
2024951 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024950 LA     school   R36   Orleans Parish   300003 John F. Kennedy High School             2020 fall grade_7                                                   0                                             0
2024949 LA     school   R36   Orleans Parish   300001 Pierre A. Capdau Charter School at Avery Alexander             2020 fall grade_7                                                   101                                             101
2024948 LA     school 2280100 101   Special School District 228010002356 101038 Northlake Youth Academy   Special Education School No Other KG 12 2020 fall grade_7                                                   0                                             0
2024947 LA     school 2280100 101   Special School District 228010002372 101037 River Oaks Hospital   Special Education School No Other KG 12 2020 fall grade_7                                                   0                                             0
2024946 LA     school 2280100 101   Special School District 228010002351 101036 Methodist Home for Children of Greater New Orleans   Special Education School No Other KG 12 2020 fall grade_7                                                   4                                             4
2024945 LA     school 2280100 101   Special School District 228010002014 101031 Renaissance Home for Youth   Special Education School No Other KG 12 2020 fall grade_7                                                   0                                             0
2024944 LA     school 2280100 101   Special School District 228010001627 101027 Raymond Laborde Correctional Center   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024943 LA     school 2280100 101   Special School District 228010001624 101025 Dixon Correctional Institute   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024942 LA     school 2280100 101   Special School District 228010001621 101023 Louisiana State Penitentiary   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024941 LA     school 2280100 101   Special School District 228010001611 101020 Louisiana Correctional Institute for Women   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024940 LA     school 2280100 101   Special School District 228010001609 101019 Elayn Hunt Correctional Center   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024939 LA     school 2280100 101   Special School District 228010001607 101017 David Wade Correctional Center   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024938 LA     school 2280100 101   Special School District 228010001730 101010 Pinecrest Supports & Services Center   Special Education School No Other KG 12 2020 fall grade_7                                                   3                                             3
2024937 LA     school 2280100 101   Special School District 228010001725 101005 Eastern LA Mental System   Special Education School No High 10 12 2020 fall grade_7                                                   0                                             0
2024936 LA     school   069   Central Community School District   69700 Central Community Central Office             2020 fall grade_7                                                   0                                             0
2024935 LA     school 2200125 069   Central Community School District 220012502090 69006 Central Intermediate School   Regular School No Elementary 03 05 2020 fall grade_7                                                   0                                             0
2024934 LA     school 2200125 069   Central Community School District 220012500363 69004 Central High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024933 LA     school 2200125 069   Central Community School District 220012500364 69003 Central Middle School   Regular School No Middle 06 08 2020 fall grade_7                                                   382                                             382
2024932 LA     school 2200125 069   Central Community School District 220012500433 69002 Tanglewood Elementary School   Regular School No Elementary 01 02 2020 fall grade_7                                                   0                                             0
2024931 LA     school 2200125 069   Central Community School District 220012500351 69001 Bellingrath Hills Elementary School   Regular School No Elementary PK KG 2020 fall grade_7                                                   0                                             0
2024930 LA     school 2200040 068   City of Baker School District 220004000410 68005 Park Ridge Academic Magnet School   Regular School No Elementary KG 08 2020 fall grade_7                                                   26                                             26
2024929 LA     school 2200040 068   City of Baker School District 220004000343 68003 Baker Middle School   Regular School No Middle 06 08 2020 fall grade_7                                                   69                                             69
2024928 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024927 LA     school 2200040 068   City of Baker School District 220004000342 68001 Baker Heights Elementary School   Regular School No Elementary PK 05 2020 fall grade_7                                                   0                                             0
2024926 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2020 fall grade_7                                                   0                                             0
2024925 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2020 fall grade_7                                                   0                                             0
2024924 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2020 fall grade_7                                                   0                                             0
2024923 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2020 fall grade_7                                                   0                                             0
2024922 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024921 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2020 fall grade_7                                                   0                                             0
2024920 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2020 fall grade_7                                                   455                                             455
2024919 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2020 fall grade_7                                                   0                                             0
2024918 LA     school 2200240 066   City of Bogalusa School District 220024002371 66014 Northshore Charter School   Regular School Yes Other KG 09 2020 fall grade_7                                                   43                                             43
2024917 LA     school 2200240 066   City of Bogalusa School District 220024000104 66003 Byrd Avenue Primary School   Regular School No Elementary PK 02 2020 fall grade_7                                                   0                                             0
2024916 LA     school 2200240 066   City of Bogalusa School District 220024000103 66002 Bogalusa High School   Regular School No High 07 12 2020 fall grade_7                                                   110                                             110
2024915 LA     school 2200240 066   City of Bogalusa School District 220024000102 66001 Central Elementary School   Regular School No Elementary 03 06 2020 fall grade_7                                                   0                                             0
2024914 LA     school   065   City of Monroe School District   65700 City of Monroe Central Office             2020 fall grade_7                                                   0                                             0
2024913 LA     school 2201080 065   City of Monroe School District 220108001482 65028 Thomas Jefferson Elementary   Regular School No Elementary 03 06 2020 fall grade_7                                                   0                                             0
2024912 LA     school 2201080 065   City of Monroe School District 220108000996 65026 Madison James Foster Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024911 LA     school 2201080 065   City of Monroe School District 220108000831 65024 Cypress Point Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024910 LA     school 2201080 065   City of Monroe School District 220108002019 65023 Sherrouse School   Regular School No Other KG 12 2020 fall grade_7                                                   1                                             1
2024909 LA     school 2201080 065   City of Monroe School District 220108000803 65018 Wossman High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024908 LA     school 2201080 065   City of Monroe School District 220108000800 65015 Minnie Ruffin Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024907 LA     school 2201080 065   City of Monroe School District 220108000799 65014 Neville High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024906 LA     school 2201080 065   City of Monroe School District 220108000798 65013 Roy Neal Shelling, Sr. Elementary   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024905 LA     school 2201080 065   City of Monroe School District 220108000797 65012 Lexington Elementary School   Regular School No Elementary PK 02 2020 fall grade_7                                                   0                                             0
2024904 LA     school 2201080 065   City of Monroe School District 220108000796 65011 Robert E. Lee Junior High School   Regular School No Middle 07 08 2020 fall grade_7                                                   272                                             272
2024903 LA     school 2201080 065   City of Monroe School District 220108000795 65010 Berg Jones Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024902 LA     school 2201080 065   City of Monroe School District 220108000794 65009 Martin Luther King Junior High School   Regular School No Middle 07 08 2020 fall grade_7                                                   145                                             145
2024901 LA     school 2201080 065   City of Monroe School District 220108000793 65008 Sallie Humble Elementary School   Regular School No Elementary 03 06 2020 fall grade_7                                                   0                                             0
2024900 LA     school 2201080 065   City of Monroe School District 220108000792 65007 Clara Hall Accelerated School   Regular School No Elementary PK 02 2020 fall grade_7                                                   0                                             0
2024899 LA     school 2201080 065   City of Monroe School District 220108000791 65006 Barkdull Faulk Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024898 LA     school 2201080 065   City of Monroe School District 220108000790 65005 J.S. Clark Magnet Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024897 LA     school 2201080 065   City of Monroe School District 220108000789 65004 Carver Elementary School   Regular School No Elementary PK 06 2020 fall grade_7                                                   0                                             0
2024896 LA     school 2201080 065   City of Monroe School District 220108000788 65003 Carroll Junior High School   Regular School No Middle 07 08 2020 fall grade_7                                                   175                                             175
2024895 LA     school 2201080 065   City of Monroe School District 220108000787 65002 Carroll High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024894 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024893 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2020 fall grade_7                                                   102                                             102
2024892 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2020 fall grade_7                                                   0                                             0
2024891 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2020 fall grade_7                                                   27                                             27
2024890 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2020 fall grade_7                                                   19                                             19
2024889 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2020 fall grade_7                                                   20                                             20
2024888 LA     school 2201980 063   West Feliciana Parish 220198001276 63006 West Feliciana Middle School   Regular School No Middle 06 08 2020 fall grade_7                                                   168                                             168
2024887 LA     school 2201980 063   West Feliciana Parish 220198002012 63005 Bains Lower Elementary School   Regular School No Elementary PK 01 2020 fall grade_7                                                   0                                             0
2024886 LA     school 2201980 063   West Feliciana Parish 220198001476 63003 West Feliciana High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024885 LA     school 2201980 063   West Feliciana Parish 220198001474 63001 Bains Elementary School   Regular School No Elementary 02 05 2020 fall grade_7                                                   0                                             0
2024884 LA     school   063   West Feliciana Parish   63000 Administrative Services -- Special Education             2020 fall grade_7                                                   0                                             0
2024883 LA     school 2201950 062   West Carroll Parish 220195002011 62014 Oak Grove Elementary School   Regular School No Elementary PK 05 2020 fall grade_7                                                   0                                             0
2024882 LA     school 2201950 062   West Carroll Parish 220195001472 62006 Oak Grove High School   Regular School No High 06 12 2020 fall grade_7                                                   66                                             66
2024881 LA     school 2201950 062   West Carroll Parish 220195001471 62005 Kilbourne High School   Regular School No Other PK 12 2020 fall grade_7                                                   21                                             21
2024880 LA     school 2201950 062   West Carroll Parish 220195001469 62003 Forest School   Regular School No Other PK 12 2020 fall grade_7                                                   51                                             51
2024879 LA     school 2201950 062   West Carroll Parish 220195001467 62001 Epps High School   Regular School No Other PK 12 2020 fall grade_7                                                   19                                             19
2024878 LA     school   061   West Baton Rouge Parish   61013 Caneview K-8 School             2020 fall grade_7                                                   34                                             34
2024877 LA     school 2201920 061   West Baton Rouge Parish 220192000419 61011 Brusly Elementary School   Regular School No Elementary PK 02 2020 fall grade_7                                                   0                                             0
2024876 LA     school 2201920 061   West Baton Rouge Parish 220192001548 61009 Port Allen Middle School   Regular School No Middle 06 08 2020 fall grade_7                                                   77                                             77
2024875 LA     school 2201920 061   West Baton Rouge Parish 220192001464 61008 Port Allen High School   Regular School No High 09 12 2020 fall grade_7                                                   0                                             0
2024874 LA     school 2201920 061   West Baton Rouge Parish 220192001463 61007 Port Allen Elementary School   Regular School No Elementary PK 02 2020 fall grade_7                                                   0                                             0

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