Data source: Big Local News · About: Big Local

45,280 rows where state = "LA" and year = 2019 sorted by rowid descending

View and edit SQL

grade

year

  • 2019 · 45,180
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
2540595 LA     school   R36   All Orleans   363002 Paul Habans Charter School             2019 fall pre_kindergarten                                                   60                                             60
2540594 LA     school   R36   All Orleans   363001 Harriet Tubman Charter School             2019 fall pre_kindergarten                                                   54                                             54
2540593 LA     school   R36   All Orleans   361001 Crescent Leadership Academy             2019 fall pre_kindergarten                                                   0                                             0
2540592 LA     school   R36   All Orleans   360002 The NET 2 Charter High School             2019 fall pre_kindergarten                                                   0                                             0
2540591 LA     school   R36   All Orleans   360001 The NET Charter High School             2019 fall pre_kindergarten                                                   0                                             0
2540590 LA     school   CHA   Type 2 Charters   348001 New Orleans Military & Maritime Academy             2019 fall pre_kindergarten                                                   0                                             0
2540589 LA     school   CHA   Type 2 Charters   347001 Lycee Francais de la Nouvelle-Orleans             2019 fall pre_kindergarten                                                   80                                             80
2540588 LA     school   CHA   Type 2 Charters   346001 Lake Charles Charter Academy             2019 fall pre_kindergarten                                                   40                                             40
2540587 LA     school   CHA   Type 2 Charters   345001 University View Academy, Inc. (FRM LA Connections)             2019 fall pre_kindergarten                                                   20                                             20
2540586 LA     school   CHA   Type 2 Charters   344001 International High School of New Orleans             2019 fall pre_kindergarten                                                   0                                             0
2540585 LA     school   CHA   Type 2 Charters   343001 Madison Preparatory Academy             2019 fall pre_kindergarten                                                   0                                             0
2540584 LA     school   CHA   Type 2 Charters   341001 D'Arbonne Woods Charter School             2019 fall pre_kindergarten                                                   0                                             0
2540583 LA     school   CHA   Type 2 Charters   340001 The MAX Charter School             2019 fall pre_kindergarten                                                   0                                             0
2540582 LA     school   CHA   Type 2 Charters   337001 Belle Chasse Academy             2019 fall pre_kindergarten                                                   0                                             0
2540581 LA     school   CHA   Type 2 Charters   336001 Delhi Charter School             2019 fall pre_kindergarten                                                   0                                             0
2540580 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 pre_kindergarten                                                   0                                             0
2540579 LA     school   CHA   Type 2 Charters   333001 Avoyelles Public Charter School             2019 fall pre_kindergarten                                                   0                                             0
2540578 LA     school   CHA   Type 2 Charters   331001 International School of Louisiana             2019 fall pre_kindergarten                                                   0                                             0
2540577 LA     school   CHA   Type 2 Charters   329001 V. B. Glencoe Charter School             2019 fall pre_kindergarten                                                   37                                             37
2540576 LA     school   CHA   Type 2 Charters   321001 New Vision Learning Academy             2019 fall pre_kindergarten                                                   40                                             40
2540575 LA     school 2200023 319   Southern University Lab School 220002302402 319002 Southern University Laboratory Virtual School   Regular School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540574 LA     school 2200023 319   Southern University Lab School 220002301921 319001 Southern University Lab School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   20                                             20
2540573 LA     school 2200022 318   LSU Laboratory School 220002201922 318001 LSU Laboratory School   Regular School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540572 LA     school 2200020 306   Louisiana Special Education Center 220002000267 306001 Louisiana Special Education Center   Special Education School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540571 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 pre_kindergarten                                                   0                                             0
2540570 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 pre_kindergarten                                                   0                                             0
2540569 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 pre_kindergarten                                                   0                                             0
2540568 LA     school   R36   All Orleans   300003 John F. Kennedy High School             2019 fall pre_kindergarten                                                   0                                             0
2540567 LA     school   R36   All Orleans   300002 Nelson Elementary School             2019 fall pre_kindergarten                                                   20                                             20
2540566 LA     school   R36   All Orleans   300001 Pierre A. Capdau Charter School at Avery Alexander             2019 fall pre_kindergarten                                                   40                                             40
2540565 LA     school 2280100 101   Special School District 228010002356 101038 Northlake Youth Academy   Special Education School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540564 LA     school 2280100 101   Special School District 228010002372 101037 River Oaks Hospital   Special Education School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540563 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 pre_kindergarten                                                   0                                             0
2540562 LA     school 2280100 101   Special School District 228010002016 101033 Winn Correctional Center   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540561 LA     school 2280100 101   Special School District 228010002014 101031 Renaissance Home for Youth   Special Education School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540560 LA     school 2280100 101   Special School District 228010001627 101027 Raymond Laborde Correctional Center   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540559 LA     school 2280100 101   Special School District 228010001624 101025 Dixon Correctional Institute   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540558 LA     school 2280100 101   Special School District 228010001621 101023 Louisiana State Penitentiary   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540557 LA     school 2280100 101   Special School District 228010001611 101020 Louisiana Correctional Institute for Women   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540556 LA     school 2280100 101   Special School District 228010001609 101019 Elayn Hunt Correctional Center   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540555 LA     school 2280100 101   Special School District 228010001607 101017 David Wade Correctional Center   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540554 LA     school 2280100 101   Special School District 228010001730 101010 Pinecrest Supports & Services Center   Special Education School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540553 LA     school 2280100 101   Special School District 228010001725 101005 Eastern LA Mental System   Special Education School No High 10 12 2019 fall pre_kindergarten                                                   0                                             0
2540552 LA     school   069   Central Community School District   69700 Central Community Central Office             2019 fall pre_kindergarten                                                   0                                             0
2540551 LA     school 2200125 069   Central Community School District 220012502090 69006 Central Intermediate School   Regular School No Elementary 03 05 2019 fall pre_kindergarten                                                   0                                             0
2540550 LA     school 2200125 069   Central Community School District 220012500363 69004 Central High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540549 LA     school 2200125 069   Central Community School District 220012500364 69003 Central Middle School   Regular School No Middle 06 08 2019 fall pre_kindergarten                                                   0                                             0
2540548 LA     school 2200125 069   Central Community School District 220012500433 69002 Tanglewood Elementary School   Regular School No Elementary 01 02 2019 fall pre_kindergarten                                                   0                                             0
2540547 LA     school 2200125 069   Central Community School District 220012500351 69001 Bellingrath Hills Elementary School   Regular School No Elementary PK KG 2019 fall pre_kindergarten                                                   116                                             116
2540546 LA     school 2200040 068   City of Baker School District 220004000410 68005 Park Ridge Academic Magnet School   Regular School No Elementary KG 08 2019 fall pre_kindergarten                                                   0                                             0
2540545 LA     school 2200040 068   City of Baker School District 220004000345 68004 Bakerfield Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten                                                   41                                             41
2540544 LA     school 2200040 068   City of Baker School District 220004000343 68003 Baker Middle School   Regular School No Middle 06 08 2019 fall pre_kindergarten                                                   0                                             0
2540543 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540542 LA     school 2200040 068   City of Baker School District 220004000342 68001 Baker Heights Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten                                                   38                                             38
2540541 LA     school   067   Zachary Community School District   67700 Zachary Community Central Office             2019 fall pre_kindergarten                                                   0                                             0
2540540 LA     school 2200039 067   Zachary Community School District 220003902347 67010 Rollins Place Elementary   Regular School No Elementary 01 02 2019 fall pre_kindergarten                                                   0                                             0
2540539 LA     school 2200039 067   Zachary Community School District 220003902299 67008 Zachary Early Learning Center   Regular School No Prekindergarten PK PK 2019 fall pre_kindergarten                                                   225                                             225
2540538 LA     school 2200039 067   Zachary Community School District 220003902013 67006 Copper Mill Elementary/Middle School   Regular School No Middle 05 06 2019 fall pre_kindergarten                                                   0                                             0
2540537 LA     school 2200039 067   Zachary Community School District 220003900450 67004 Zachary High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540536 LA     school 2200039 067   Zachary Community School District 220003900449 67003 Zachary Elementary School   Regular School No Elementary 03 04 2019 fall pre_kindergarten                                                   0                                             0
2540535 LA     school 2200039 067   Zachary Community School District 220003900406 67002 Northwestern Middle School   Regular School No Middle 07 08 2019 fall pre_kindergarten                                                   0                                             0
2540534 LA     school 2200039 067   Zachary Community School District 220003900405 67001 Northwestern Elementary School   Regular School No Elementary KG KG 2019 fall pre_kindergarten                                                   0                                             0
2540533 LA     school 2200240 066   City of Bogalusa School District 220024002371 66014 Northshore Charter School   Regular School Yes Elementary KG 08 2019 fall pre_kindergarten                                                   0                                             0
2540532 LA     school 2200240 066   City of Bogalusa School District 220024000104 66003 Byrd Avenue Primary School   Regular School No Elementary PK 02 2019 fall pre_kindergarten                                                   96                                             96
2540531 LA     school 2200240 066   City of Bogalusa School District 220024000103 66002 Bogalusa High School   Regular School No High 07 12 2019 fall pre_kindergarten                                                   0                                             0
2540530 LA     school 2200240 066   City of Bogalusa School District 220024000102 66001 Central Elementary School   Regular School No Elementary 03 06 2019 fall pre_kindergarten                                                   0                                             0
2540529 LA     school   065   City of Monroe School District   65700 City of Monroe Central Office             2019 fall pre_kindergarten                                                   0                                             0
2540528 LA     school 2201080 065   City of Monroe School District 220108001482 65028 Thomas Jefferson Elementary   Regular School No Elementary 03 06 2019 fall pre_kindergarten                                                   0                                             0
2540527 LA     school 2201080 065   City of Monroe School District 220108000996 65026 Madison James Foster Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   38                                             38
2540526 LA     school 2201080 065   City of Monroe School District 220108000831 65024 Cypress Point Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   33                                             33
2540525 LA     school 2201080 065   City of Monroe School District 220108002019 65023 Sherrouse School   Regular School No Other KG 12 2019 fall pre_kindergarten                                                   0                                             0
2540524 LA     school 2201080 065   City of Monroe School District 220108000803 65018 Wossman High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540523 LA     school 2201080 065   City of Monroe School District 220108000800 65015 Minnie Ruffin Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   39                                             39
2540522 LA     school 2201080 065   City of Monroe School District 220108000799 65014 Neville High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540521 LA     school 2201080 065   City of Monroe School District 220108000798 65013 Roy Neal Shelling, Sr. Elementary   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   50                                             50
2540520 LA     school 2201080 065   City of Monroe School District 220108000797 65012 Lexington Elementary School   Regular School No Elementary PK 02 2019 fall pre_kindergarten                                                   97                                             97
2540519 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 pre_kindergarten                                                   0                                             0
2540518 LA     school 2201080 065   City of Monroe School District 220108000795 65010 Berg Jones Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   37                                             37
2540517 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 pre_kindergarten                                                   0                                             0
2540516 LA     school 2201080 065   City of Monroe School District 220108000793 65008 Sallie Humble Elementary School   Regular School No Elementary 03 06 2019 fall pre_kindergarten                                                   0                                             0
2540515 LA     school 2201080 065   City of Monroe School District 220108000792 65007 Clara Hall Accelerated School   Regular School No Elementary PK 02 2019 fall pre_kindergarten                                                   56                                             56
2540514 LA     school 2201080 065   City of Monroe School District 220108000791 65006 Barkdull Faulk Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   20                                             20
2540513 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 pre_kindergarten                                                   57                                             57
2540512 LA     school 2201080 065   City of Monroe School District 220108000789 65004 Carver Elementary School   Regular School No Elementary PK 06 2019 fall pre_kindergarten                                                   19                                             19
2540511 LA     school 2201080 065   City of Monroe School District 220108000788 65003 Carroll Junior High School   Regular School No Middle 07 08 2019 fall pre_kindergarten                                                   0                                             0
2540510 LA     school 2201080 065   City of Monroe School District 220108000787 65002 Carroll High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540509 LA     school 2202010 064   Winn Parish 220201001487 64009 Winnfield High School   Regular School No High 09 12 2019 fall pre_kindergarten                                                   0                                             0
2540508 LA     school 2202010 064   Winn Parish 220201001486 64008 Winnfield Middle School   Regular School No Middle 05 08 2019 fall pre_kindergarten                                                   0                                             0
2540507 LA     school 2202010 064   Winn Parish 220201001484 64006 Winnfield Primary School   Regular School No Elementary PK 04 2019 fall pre_kindergarten                                                   39                                             39
2540506 LA     school 2202010 064   Winn Parish 220201001480 64003 Dodson High School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   16                                             16
2540505 LA     school 2202010 064   Winn Parish 220201001479 64002 Calvin High School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   18                                             18
2540504 LA     school 2202010 064   Winn Parish 220201001478 64001 Atlanta High School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   19                                             19
2540503 LA     school 2201980 063   West Feliciana Parish 220198001276 63006 West Feliciana Middle School   Regular School No Middle 06 08 2019 fall pre_kindergarten                                                   0                                             0
2540502 LA     school 2201980 063   West Feliciana Parish 220198002012 63005 Bains Lower Elementary School   Regular School No Elementary PK 01 2019 fall pre_kindergarten                                                   177                                             177
2540501 LA     school 2201980 063   West Feliciana Parish 220198001476 63003 West Feliciana High School   Regular School No High 08 12 2019 fall pre_kindergarten                                                   0                                             0
2540500 LA     school 2201980 063   West Feliciana Parish 220198001474 63001 Bains Elementary School   Regular School No Elementary 02 05 2019 fall pre_kindergarten                                                   0                                             0
2540499 LA     school   063   West Feliciana Parish   63000 Administrative Services -- Special Education             2019 fall pre_kindergarten                                                   0                                             0
2540498 LA     school 2201950 062   West Carroll Parish 220195002011 62014 Oak Grove Elementary School   Regular School No Elementary PK 05 2019 fall pre_kindergarten                                                   42                                             42
2540497 LA     school 2201950 062   West Carroll Parish 220195001472 62006 Oak Grove High School   Regular School No High 06 12 2019 fall pre_kindergarten                                                   0                                             0
2540496 LA     school 2201950 062   West Carroll Parish 220195001471 62005 Kilbourne High School   Regular School No Other PK 12 2019 fall pre_kindergarten                                                   6                                             6

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