Data source: Big Local News · About: Big Local

8,427 rows where grade = "grade_7" and state = "LA" sorted by rowid descending

View and edit SQL

year

grade

  • grade_7 · 8,327
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
2532093 LA     school   R36   All Orleans   363002 Paul Habans Charter School             2019 fall grade_7                                                   77                                             77
2532092 LA     school   R36   All Orleans   363001 Harriet Tubman Charter School             2019 fall grade_7                                                   99                                             99
2532091 LA     school   R36   All Orleans   361001 Crescent Leadership Academy             2019 fall grade_7                                                   2                                             2
2532090 LA     school   R36   All Orleans   360002 The NET 2 Charter High School             2019 fall grade_7                                                   0                                             0
2532089 LA     school   R36   All Orleans   360001 The NET Charter High School             2019 fall grade_7                                                   0                                             0
2532088 LA     school   CHA   Type 2 Charters   348001 New Orleans Military & Maritime Academy             2019 fall grade_7                                                   0                                             0
2532087 LA     school   CHA   Type 2 Charters   347001 Lycee Francais de la Nouvelle-Orleans             2019 fall grade_7                                                   53                                             53
2532086 LA     school   CHA   Type 2 Charters   346001 Lake Charles Charter Academy             2019 fall grade_7                                                   114                                             114
2532085 LA     school   CHA   Type 2 Charters   345001 University View Academy, Inc. (FRM LA Connections)             2019 fall grade_7                                                   285                                             285
2532084 LA     school   CHA   Type 2 Charters   344001 International High School of New Orleans             2019 fall grade_7                                                   0                                             0
2532083 LA     school   CHA   Type 2 Charters   343001 Madison Preparatory Academy             2019 fall grade_7                                                   0                                             0
2532082 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2019 fall grade_7                                                   80                                             80
2532081 LA     school   CHA   Type 2 Charters   340001 The MAX Charter School             2019 fall grade_7                                                   23                                             23
2532080 LA     school   CHA   Type 2 Charters   337001 Belle Chasse Academy             2019 fall grade_7                                                   95                                             95
2532079 LA     school   CHA   Type 2 Charters   336001 Delhi Charter School             2019 fall grade_7                                                   66                                             66
2532078 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_7                                                   0                                             0
2532077 LA     school   CHA   Type 2 Charters   333001 Avoyelles Public Charter School             2019 fall grade_7                                                   51                                             51
2532076 LA     school   CHA   Type 2 Charters   331001 International School of Louisiana             2019 fall grade_7                                                   113                                             113
2532075 LA     school   CHA   Type 2 Charters   329001 V. B. Glencoe Charter School             2019 fall grade_7                                                   37                                             37
2532074 LA     school   CHA   Type 2 Charters   321001 New Vision Learning Academy             2019 fall grade_7                                                   0                                             0
2532073 LA     school 2200023 319   Southern University Lab School 220002302402 319002 Southern University Laboratory Virtual School   Regular School No Other KG 12 2019 fall grade_7                                                   32                                             32
2532072 LA     school 2200023 319   Southern University Lab School 220002301921 319001 Southern University Lab School   Regular School No Other PK 12 2019 fall grade_7                                                   25                                             25
2532071 LA     school 2200022 318   LSU Laboratory School 220002201922 318001 LSU Laboratory School   Regular School No Other KG 12 2019 fall grade_7                                                   120                                             120
2532070 LA     school 2200020 306   Louisiana Special Education Center 220002000267 306001 Louisiana Special Education Center   Special Education School No Other KG 12 2019 fall grade_7                                                   3                                             3
2532069 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_7                                                   3                                             3
2532068 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 2019 fall grade_7                                                   10                                             10
2532067 LA     school 2200017 302   Louisiana School for Math Science & the Arts 220001701975 302006 Louisiana School for Math Science & the Arts   Alternative School No High 10 12 2019 fall grade_7                                                   0                                             0
2532066 LA     school   R36   All Orleans   300003 John F. Kennedy High School             2019 fall grade_7                                                   0                                             0
2532065 LA     school   R36   All Orleans   300002 Nelson Elementary School             2019 fall grade_7                                                   39                                             39
2532064 LA     school   R36   All Orleans   300001 Pierre A. Capdau Charter School at Avery Alexander             2019 fall grade_7                                                   96                                             96
2532063 LA     school 2280100 101   Special School District 228010002356 101038 Northlake Youth Academy   Special Education School No Other KG 12 2019 fall grade_7                                                   5                                             5
2532062 LA     school 2280100 101   Special School District 228010002372 101037 River Oaks Hospital   Special Education School No Other KG 12 2019 fall grade_7                                                   3                                             3
2532061 LA     school 2280100 101   Special School District 228010002351 101036 Methodist Home for Children of Greater New Orleans   Special Education School No Other KG 12 2019 fall grade_7                                                   1                                             1
2532060 LA     school 2280100 101   Special School District 228010002016 101033 Winn Correctional Center   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532059 LA     school 2280100 101   Special School District 228010002014 101031 Renaissance Home for Youth   Special Education School No Other KG 12 2019 fall grade_7                                                   3                                             3
2532058 LA     school 2280100 101   Special School District 228010001627 101027 Raymond Laborde Correctional Center   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532057 LA     school 2280100 101   Special School District 228010001624 101025 Dixon Correctional Institute   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532056 LA     school 2280100 101   Special School District 228010001621 101023 Louisiana State Penitentiary   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532055 LA     school 2280100 101   Special School District 228010001611 101020 Louisiana Correctional Institute for Women   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532054 LA     school 2280100 101   Special School District 228010001609 101019 Elayn Hunt Correctional Center   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532053 LA     school 2280100 101   Special School District 228010001607 101017 David Wade Correctional Center   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532052 LA     school 2280100 101   Special School District 228010001730 101010 Pinecrest Supports & Services Center   Special Education School No Other KG 12 2019 fall grade_7                                                   4                                             4
2532051 LA     school 2280100 101   Special School District 228010001725 101005 Eastern LA Mental System   Special Education School No High 10 12 2019 fall grade_7                                                   0                                             0
2532050 LA     school   069   Central Community School District   69700 Central Community Central Office             2019 fall grade_7                                                   0                                             0
2532049 LA     school 2200125 069   Central Community School District 220012502090 69006 Central Intermediate School   Regular School No Elementary 03 05 2019 fall grade_7                                                   0                                             0
2532048 LA     school 2200125 069   Central Community School District 220012500363 69004 Central High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532047 LA     school 2200125 069   Central Community School District 220012500364 69003 Central Middle School   Regular School No Middle 06 08 2019 fall grade_7                                                   371                                             371
2532046 LA     school 2200125 069   Central Community School District 220012500433 69002 Tanglewood Elementary School   Regular School No Elementary 01 02 2019 fall grade_7                                                   0                                             0
2532045 LA     school 2200125 069   Central Community School District 220012500351 69001 Bellingrath Hills Elementary School   Regular School No Elementary PK KG 2019 fall grade_7                                                   0                                             0
2532044 LA     school 2200040 068   City of Baker School District 220004000410 68005 Park Ridge Academic Magnet School   Regular School No Elementary KG 08 2019 fall grade_7                                                   18                                             18
2532043 LA     school 2200040 068   City of Baker School District 220004000345 68004 Bakerfield Elementary School   Regular School No Elementary PK 05 2019 fall grade_7                                                   0                                             0
2532042 LA     school 2200040 068   City of Baker School District 220004000343 68003 Baker Middle School   Regular School No Middle 06 08 2019 fall grade_7                                                   77                                             77
2532041 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532040 LA     school 2200040 068   City of Baker School District 220004000342 68001 Baker Heights Elementary School   Regular School No Elementary PK 05 2019 fall grade_7                                                   0                                             0
2532039 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall grade_7                                                   0                                             0
2532038 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall grade_7                                                   0                                             0
2532037 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall grade_7                                                   0                                             0
2532036 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall grade_7                                                   0                                             0
2532035 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532034 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall grade_7                                                   0                                             0
2532033 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall grade_7                                                   422                                             422
2532032 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall grade_7                                                   0                                             0
2532031 LA     school 2200240 066   City of Bogalusa School District 220024002371 66014 Northshore Charter School   Regular School Yes Elementary KG 08 2019 fall grade_7                                                   46                                             46
2532030 LA     school 2200240 066   City of Bogalusa School District 220024000104 66003 Byrd Avenue Primary School   Regular School No Elementary PK 02 2019 fall grade_7                                                   0                                             0
2532029 LA     school 2200240 066   City of Bogalusa School District 220024000103 66002 Bogalusa High School   Regular School No High 07 12 2019 fall grade_7                                                   108                                             108
2532028 LA     school 2200240 066   City of Bogalusa School District 220024000102 66001 Central Elementary School   Regular School No Elementary 03 06 2019 fall grade_7                                                   0                                             0
2532027 LA     school   065   City of Monroe School District   65700 City of Monroe Central Office             2019 fall grade_7                                                   0                                             0
2532026 LA     school 2201080 065   City of Monroe School District 220108001482 65028 Thomas Jefferson Elementary   Regular School No Elementary 03 06 2019 fall grade_7                                                   0                                             0
2532025 LA     school 2201080 065   City of Monroe School District 220108000996 65026 Madison James Foster Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532024 LA     school 2201080 065   City of Monroe School District 220108000831 65024 Cypress Point Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532023 LA     school 2201080 065   City of Monroe School District 220108002019 65023 Sherrouse School   Regular School No Other KG 12 2019 fall grade_7                                                   5                                             5
2532022 LA     school 2201080 065   City of Monroe School District 220108000803 65018 Wossman High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532021 LA     school 2201080 065   City of Monroe School District 220108000800 65015 Minnie Ruffin Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532020 LA     school 2201080 065   City of Monroe School District 220108000799 65014 Neville High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532019 LA     school 2201080 065   City of Monroe School District 220108000798 65013 Roy Neal Shelling, Sr. Elementary   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532018 LA     school 2201080 065   City of Monroe School District 220108000797 65012 Lexington Elementary School   Regular School No Elementary PK 02 2019 fall grade_7                                                   0                                             0
2532017 LA     school 2201080 065   City of Monroe School District 220108000796 65011 Robert E. Lee Junior High School   Regular School No Middle 07 08 2019 fall grade_7                                                   243                                             243
2532016 LA     school 2201080 065   City of Monroe School District 220108000795 65010 Berg Jones Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532015 LA     school 2201080 065   City of Monroe School District 220108000794 65009 Martin Luther King Junior High School   Regular School No Middle 07 08 2019 fall grade_7                                                   160                                             160
2532014 LA     school 2201080 065   City of Monroe School District 220108000793 65008 Sallie Humble Elementary School   Regular School No Elementary 03 06 2019 fall grade_7                                                   0                                             0
2532013 LA     school 2201080 065   City of Monroe School District 220108000792 65007 Clara Hall Accelerated School   Regular School No Elementary PK 02 2019 fall grade_7                                                   0                                             0
2532012 LA     school 2201080 065   City of Monroe School District 220108000791 65006 Barkdull Faulk Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532011 LA     school 2201080 065   City of Monroe School District 220108000790 65005 J.S. Clark Magnet Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532010 LA     school 2201080 065   City of Monroe School District 220108000789 65004 Carver Elementary School   Regular School No Elementary PK 06 2019 fall grade_7                                                   0                                             0
2532009 LA     school 2201080 065   City of Monroe School District 220108000788 65003 Carroll Junior High School   Regular School No Middle 07 08 2019 fall grade_7                                                   160                                             160
2532008 LA     school 2201080 065   City of Monroe School District 220108000787 65002 Carroll High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532007 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2019 fall grade_7                                                   0                                             0
2532006 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2019 fall grade_7                                                   95                                             95
2532005 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2019 fall grade_7                                                   0                                             0
2532004 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2019 fall grade_7                                                   26                                             26
2532003 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2019 fall grade_7                                                   18                                             18
2532002 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2019 fall grade_7                                                   22                                             22
2532001 LA     school 2201980 063   West Feliciana Parish 220198001276 63006 West Feliciana Middle School   Regular School No Middle 06 08 2019 fall grade_7                                                   164                                             164
2532000 LA     school 2201980 063   West Feliciana Parish 220198002012 63005 Bains Lower Elementary School   Regular School No Elementary PK 01 2019 fall grade_7                                                   0                                             0
2531999 LA     school 2201980 063   West Feliciana Parish 220198001476 63003 West Feliciana High School   Regular School No High 08 12 2019 fall grade_7                                                   0                                             0
2531998 LA     school 2201980 063   West Feliciana Parish 220198001474 63001 Bains Elementary School   Regular School No Elementary 02 05 2019 fall grade_7                                                   0                                             0
2531997 LA     school   063   West Feliciana Parish   63000 Administrative Services -- Special Education             2019 fall grade_7                                                   0                                             0
2531996 LA     school 2201950 062   West Carroll Parish 220195002011 62014 Oak Grove Elementary School   Regular School No Elementary PK 05 2019 fall grade_7                                                   0                                             0
2531995 LA     school 2201950 062   West Carroll Parish 220195001472 62006 Oak Grove High School   Regular School No High 06 12 2019 fall grade_7                                                   85                                             85
2531994 LA     school 2201950 062   West Carroll Parish 220195001471 62005 Kilbourne High School   Regular School No Other PK 12 2019 fall grade_7                                                   31                                             31

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