Data source: Big Local News · About: Big Local

44,816 rows where state = "LA" and year = 2020 sorted by total descending

View and edit SQL

grade

year

  • 2020 · 44,816
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
614965 LA     school 2201110 034   Morehouse Parish 220111002359 34003 Beekman Charter School   Regular School Yes Other PK 12 2020 spring pk_12_total 846.0 125.0 11.0 2.0   2.0     0.0   13.0   498.0 501.0     6.0       640.0         999 846 125 11 2   2     0   13   498 501     6   640       999
615051 LA     school 2201290 040   Rapides Parish 220129001041 40005 J.I. Barron Sr. Elementary School   Regular School No Elementary PK 06 2020 spring pk_12_total 671.0 214.0 25.0 4.0   37.0     0.0   47.0   497.0 501.0     42.0       596.0         998 671 214 25 4   37     0   47   497 501     42   596       998
615295 LA     school 2201650 052   St. Tammany Parish 220165002255 52061 Lakeshore High School   Regular School No High 09 12 2020 spring pk_12_total 734.0 164.0 63.0 7.0   11.0     2.0   16.0   511.0 486.0     16.0       415.0         997 734 164 63 7   11     2   16   511 486     16   415       997
2032051 LA     school   R36   Orleans Parish   WBB001 Benjamin Franklin High School             2020 fall pk_12_total 355.0 293.0 73.0 5.0   201.0     2.0   68.0   397.0 600.0     0.0       342.0         997 355 293 73 5   201     2   68   397 600     0   342       997
615056 LA     school 2201290 040   Rapides Parish 220129001047 40011 Buckeye High School   Regular School No High 06 12 2020 spring pk_12_total 968.0 1.0 14.0 5.0   4.0     0.0   2.0   511.0 483.0     1.0       546.0         994 968 1 14 5   4     0   2   511 483     1   546       994
615156 LA     school 2201500 047   St. James Parish 220150001163 47004 Lutcher High School   Regular School No High 07 12 2020 spring pk_12_total 509.0 460.0 15.0 3.0   3.0     0.0   4.0   491.0 503.00000000000006     6.0       496.0         994 509 460 15 3   3     0   4   491       6   496       994
615569 LA     school   R36   Orleans Parish   398004 KIPP Central City             2020 spring pk_12_total 4.0 902.0 70.0 1.0   0.0     5.0   11.0   518.0 475.0     51.0       944.0         993 4 902 70 1   0     5   11   518 475     51   944       993
2031422 LA     school 2201170 R36   Orleans Parish 220117000880 36035 Warren Easton Senior High School   Regular School Yes High 09 13 2020 fall pk_12_total 1.0 956.0 28.0 0.0   1.0     0.0   4.0   469.0 521.0     17.0       778.0         990 1 956 28 0   1     0   4   469 521     17   778       990
594758 LA     school 2200270 008   Bossier Parish 220027000116 8005 Benton Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   99                                             99
595820 LA     school 2201860 059   Washington Parish 220186001427 59009 Thomas Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   99                                             99
596142 LA     school 2200180 006   Beauregard Parish 220018000089 6011 South Beauregard High School   Regular School No High 07 12 2020 spring grade_10                                                   99                                             99
597335 LA     school   CHA   Type 2 Charters   344001 International High School of New Orleans             2020 spring grade_10                                                   99                                             99
597748 LA     school 2200510 016   DeSoto Parish 220051000334 16007 Mansfield High School   Regular School No High 08 12 2020 spring grade_11                                                   99                                             99
598215 LA     school 2201200 037   Ouachita Parish 220120001013 37032 Sterlington High School   Regular School No High 09 12 2020 spring grade_11                                                   99                                             99
600843 LA     school 2200870 028   Lafayette Parish 220087001600 28039 Ridge Elementary School   Regular School No Elementary PK 05 2020 spring grade_2                                                   99                                             99
600933 LA     school 2201020 032   Livingston Parish 220102000772 32022 Springfield Elementary School   Regular School No Elementary PK 04 2020 spring grade_2                                                   99                                             99
601609 LA     school   CHA   Type 2 Charters   WAU001 GEO Prep Academy of Greater Baton Rouge             2020 spring grade_2                                                   99                                             99
602276 LA     school 2200900 029   Lafourche Parish 220090000718 29022 Raceland Upper Elementary School   Regular School No Elementary 03 05 2020 spring grade_3                                                   99                                             99
602419 LA     school 2201200 037   Ouachita Parish 220120001020 37038 Woodlawn Elementary School   Regular School No Elementary PK 05 2020 spring grade_3                                                   99                                             99
603538 LA     school 2200840 026   Jefferson Parish 220084000612 26036 Shirley Johnson/Gretna Park Elementary School   Regular School No Elementary PK 05 2020 spring grade_4                                                   99                                             99
603647 LA     school 2200870 028   Lafayette Parish 220087001176 28049 Live Oak Elementary School   Regular School No Elementary PK 05 2020 spring grade_4                                                   99                                             99
603896 LA     school 2201320 041   Red River Parish 220132001529 41010 Red River Elementary School   Regular School No Elementary PK 05 2020 spring grade_4                                                   99                                             99
603924 LA     school 2201410 044   St. Bernard Parish 220141001131 44012 Joseph J. Davies Elementary School   Regular School No Elementary PK 05 2020 spring grade_4                                                   99                                             99
604342 LA     school   R36   Orleans Parish   363001 Harriet Tubman Charter School             2020 spring grade_4                                                   99                                             99
604405 LA     school   CHA   Type 2 Charters   WAG001 Louisiana Virtual Charter Academy             2020 spring grade_4                                                   99                                             99
604639 LA     school 2200300 009   Caddo Parish 220030001917 9078 Donnie Bickham Middle School   Regular School No Middle 05 08 2020 spring grade_5                                                   99                                             99
604931 LA     school 2200840 026   Jefferson Parish 220084000602 26027 Estelle School   Regular School No Elementary PK 08 2020 spring grade_5                                                   99                                             99
604938 LA     school 2200840 026   Jefferson Parish 220084000612 26036 Shirley Johnson/Gretna Park Elementary School   Regular School No Elementary PK 05 2020 spring grade_5                                                   99                                             99
606849 LA     school 2201650 052   St. Tammany Parish 220165001267 52006 Bonne Ecole Elementary School   Regular School No Elementary PK 06 2020 spring grade_6                                                   99                                             99
607179 LA     school   R36   Orleans Parish   3A5001 Mary D. Coghill Charter School             2020 spring grade_6                                                   99                                             99
607406 LA     school 2200300 009   Caddo Parish 220030000165 9027 Herndon Magnet School   Regular School No Elementary KG 08 2020 spring grade_7                                                   99                                             99
608600 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2020 spring grade_7                                                   99                                             99
609551 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2020 spring grade_8                                                   99                                             99
609593 LA     school 2201560 049   St. Landry Parish 220156001475 49038 Port Barre Middle School   Regular School No Middle 05 08 2020 spring grade_8                                                   99                                             99
609595 LA     school 2201560 049   St. Landry Parish 220156001213 49042 Sunset Elementary School   Regular School No Middle 05 08 2020 spring grade_8                                                   99                                             99
611002 LA     school 2201560 049   St. Landry Parish 220156001210 49056 Port Barre High School   Regular School No High 09 12 2020 spring grade_9                                                   99                                             99
612034 LA     school 2200870 028   Lafayette Parish 220087000686 28027 Northside High School   Regular School No High 09 12 2020 spring grade_9_transitional                                                   99                                             99
613027 LA     school 2200300 009   Caddo Parish 220030000201 9062 Summer Grove Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   99                                             99
613540 LA     school 2201020 032   Livingston Parish 220102001612 32031 Levi Milton Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   99                                             99
613559 LA     school 2201050 033   Madison Parish 220105000781 33003 Tallulah Elementary School   Regular School No Elementary PK 03 2020 spring kindergarten                                                   99                                             99
613745 LA     school 2201440 045   St. Charles Parish 220144001150 45015 St. Rose Elementary School   Regular School No Elementary PK 05 2020 spring kindergarten                                                   99                                             99
614202 LA     school   CHA   Type 2 Charters   W7B001 Lafayette Renaissance Charter Academy             2020 spring kindergarten                                                   99                                             99
616455 LA     school 2201290 040   Rapides Parish 220129001046 40010 Buckeye Elementary School   Regular School No Elementary PK 02 2020 spring pre_kindergarten                                                   99                                             99
2011597 LA     school 2200840 026   Jefferson Parish 220084001883 26098 Congetta Trippe Janet Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   99                                             99
2011738 LA     school 2201020 032   Livingston Parish 220102001550 32003 North Corbin Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   99                                             99
2011955 LA     school 2201410 044   St. Bernard Parish 220141002449 44028 Arlene Meraux Elementary School   Regular School No Elementary PK 05 2020 fall grade_1                                                   99                                             99
2012500 LA     school 2200060 002   Allen Parish 220006000027 2004 Kinder High School   Regular School No High 08 12 2020 fall grade_10                                                   99                                             99
2012760 LA     school 2200480 015   Concordia Parish 220048000317 15002 Ferriday High School   Regular School No High 08 12 2020 fall grade_10                                                   99                                             99
2013426 LA     school 2201560 049   St. Landry Parish 220156001210 49056 Port Barre High School   Regular School No High 09 12 2020 fall grade_10                                                   99                                             99
2013760 LA     school   CHA   Type 2 Charters   344001 International High School of New Orleans             2020 fall grade_10                                                   99                                             99
2016739 LA     school 2200090 003   Ascension Parish 220009002326 3034 Sorrento Primary School   Regular School No Elementary PK 05 2020 fall grade_2                                                   99                                             99
2017551 LA     school 2201410 044   St. Bernard Parish 220141001131 44012 Joseph J. Davies Elementary School   Regular School No Elementary PK 05 2020 fall grade_2                                                   99                                             99
2017970 LA     school   R36   Orleans Parish   363001 Harriet Tubman Charter School             2020 fall grade_2                                                   99                                             99
2018037 LA     school   CHA   Type 2 Charters   WAU001 GEO Prep Academy of Greater Baton Rouge             2020 fall grade_2                                                   99                                             99
2018185 LA     school 2200270 008   Bossier Parish 220027000114 8003 Bellaire Elementary School   Regular School No Elementary PK 03 2020 fall grade_3                                                   99                                             99
2018602 LA     school 2200840 026   Jefferson Parish 220084001883 26098 Congetta Trippe Janet Elementary School   Regular School No Elementary PK 05 2020 fall grade_3                                                   99                                             99
2018671 LA     school 2200870 028   Lafayette Parish 220087001600 28039 Ridge Elementary School   Regular School No Elementary PK 05 2020 fall grade_3                                                   99                                             99
2018704 LA     school 2200900 029   Lafourche Parish 220090000718 29022 Raceland Upper Elementary School   Regular School No Elementary 03 05 2020 fall grade_3                                                   99                                             99
2019434 LA     school   CHA   Type 2 Charters   WAG001 Louisiana Virtual Charter Academy             2020 fall grade_3                                                   99                                             99
2019967 LA     school 2200840 026   Jefferson Parish 220084000612 26036 Shirley Johnson/Gretna Park Elementary School   Regular School No Elementary PK 05 2020 fall grade_4                                                   99                                             99
2020392 LA     school 2201530 048   St. John the Baptist Parish 220153001493 48006 LaPlace Elementary School   Regular School No Elementary PK 13 2020 fall grade_4                                                   99                                             99
2020402 LA     school 2201560 049   St. Landry Parish 220156001174 49003 Cankton Elementary School   Regular School No Elementary PK 04 2020 fall grade_4                                                   99                                             99
2020772 LA     school   R36   Orleans Parish   363001 Harriet Tubman Charter School             2020 fall grade_4                                                   99                                             99
2020801 LA     school   R36   Orleans Parish   398006 KIPP Leadership             2020 fall grade_4                                                   99                                             99
2021058 LA     school 2200300 009   Caddo Parish 220030000200 9063 Summerfield Elementary School   Regular School No Elementary PK 05 2020 fall grade_5                                                   99                                             99
2021128 LA     school 2200330 010   Calcasieu Parish 220033000274 10060 J. I. Watson Elementary School   Regular School No Elementary PK 05 2020 fall grade_5                                                   99                                             99
2021255 LA     school 2200540 017   East Baton Rouge Parish 220054002265 17131 Woodlawn Elementary   Regular School No Elementary PK 05 2020 fall grade_5                                                   99                                             99
2021700 LA     school 2201290 040   Rapides Parish 220129001068 40032 Pineville Elementary School   Regular School No Middle 04 06 2020 fall grade_5                                                   99                                             99
2021794 LA     school 2201530 048   St. John the Baptist Parish 220153001495 48008 East St. John Preparatory Academy   Regular School No Middle 05 08 2020 fall grade_5                                                   99                                             99
2022271 LA     school   CHA   Type 2 Charters   WZ8001 GEO Prep Mid-City of Greater Baton Rouge             2020 fall grade_5                                                   99                                             99
2022495 LA     school 2200330 010   Calcasieu Parish 220033000226 10015 DeQuincy Middle School   Regular School No Middle 06 08 2020 fall grade_6                                                   99                                             99
2022711 LA     school 2200720 023   Iberia Parish 220072000511 23007 Delcambre High School   Regular School No High 06 12 2020 fall grade_6                                                   99                                             99
2023224 LA     school 2201560 049   St. Landry Parish 220156001475 49038 Port Barre Middle School   Regular School No Middle 05 08 2020 fall grade_6                                                   99                                             99
2023986 LA     school 2200510 016   DeSoto Parish 220051000626 16020 Mansfield Middle School   Regular School No Middle 05 08 2020 fall grade_7                                                   99                                             99
2025162 LA     school 2200150 005   Avoyelles Parish 220015000075 5018 Avoyelles High School   Regular School No High 07 12 2020 fall grade_8                                                   99                                             99
2025644 LA     school 2200870 028   Lafayette Parish 220087000659 28001 Acadian Middle School   Regular School No Middle 05 08 2020 fall grade_8                                                   99                                             99
2026770 LA     school 2200480 015   Concordia Parish 220048000317 15002 Ferriday High School   Regular School No High 08 12 2020 fall grade_9                                                   99                                             99
2027328 LA     school 2201320 041   Red River Parish 220132001090 41002 Red River High School   Regular School No High 09 12 2020 fall grade_9                                                   99                                             99
2029969 LA     school 2201020 032   Livingston Parish 220102000772 32022 Springfield Elementary School   Regular School No Elementary PK 04 2020 fall kindergarten                                                   99                                             99
2030427 LA     school 2201800 057   Vermilion Parish 220180002273 57029 Leblanc Elementary School   Regular School No Elementary PK 05 2020 fall kindergarten                                                   99                                             99
2033280 LA     school 2201920 061   West Baton Rouge Parish 220192001463 61007 Port Allen Elementary School   Regular School No Elementary PK 02 2020 fall pre_kindergarten                                                   99                                             99
614440 LA     school 2200300 009   Caddo Parish 220030001918 9079 Keithville Elementary/Middle School   Regular School No Elementary PK 08 2020 spring pk_12_total 403.0 511.0 36.0 3.0   4.0     0.0   32.0   497.0 492.0     9.0       727.0         989 403 511 36 3   4     0   32   497 492     9   727       989
615613 LA     school   R36   Orleans Parish   WBB001 Benjamin Franklin High School             2020 spring pk_12_total 352.0 290.0 72.0 5.0   201.0     2.0   67.0   392.0 597.0     0.0       352.0         989 352 290 72 5   201     2   67   392 597     0   352       989
2030732 LA     school 2200090 003   Ascension Parish 220009000044 3012 Prairieville Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 685.0 184.0 68.0 2.0   20.0     3.0   23.0   496.0 489.0     15.0       314.0         985 685 184 68 2   20     3   23   496 489     15   314       985
2031122 LA     school 2200720 023   Iberia Parish 220072000525 23022 Westgate High School   Regular School No High 09 12 2020 fall pk_12_total 302.0 565.0 22.0 2.0   77.0     0.0   15.0   488.0 495.0     13.0       790.0         983 302 565 22 2   77     0   15   488 495     13   790       983
2031190 LA     school 2200840 026   Jefferson Parish 220084000636 26062 J.D. Meisler Middle School   Regular School No Middle 06 08 2020 fall pk_12_total 163.0 225.0 549.0 1.0   33.0     0.0   12.0   520.0 463.0     302.0       850.0         983 163 225 549 1   33     0   12   520 463     302   850       983
615565 LA     school 2200054 RLA   Recovery School District - Louisiana 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2020 spring pk_12_total 4.0 939.0 33.0 0.0   0.0     0.0   6.0   475.0 507.00000000000006     27.0       958.0         982 4 939 33 0   0     0   6   475       27   958       982
2031975 LA     school   CHA   Type 2 Charters   346001 Lake Charles Charter Academy             2020 fall pk_12_total 77.0 857.0 43.0 0.0   2.0     3.0   0.0   486.0 496.0     41.0       982.0         982 77 857 43 0   2     3   0   486 496     41   982       982
2031912 LA     school 2201080 065   City of Monroe School District 220108000799 65014 Neville High School   Regular School No High 09 12 2020 fall pk_12_total 360.0 561.0 31.0 0.0   18.0     2.0   9.0   482.0 499.00000000000006     19.0       563.0         981 360 561 31 0   18     2   9   482       19   563       981
2032040 LA     school   CHA   Type 2 Charters   W7B001 Lafayette Renaissance Charter Academy             2020 fall pk_12_total 276.0 664.0 20.0 6.0   9.0     5.0   0.0   506.0 474.0     0.0       842.0         980 276 664 20 6   9     5   0   506 474     0   842       980
595545 LA     school 2201440 045   St. Charles Parish 220144001150 45015 St. Rose Elementary School   Regular School No Elementary PK 05 2020 spring grade_1                                                   98                                             98
596016 LA     school   R36   Orleans Parish   WBE001 Lusher Charter School             2020 spring grade_1                                                   98                                             98
596951 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2020 spring grade_10                                                   98                                             98
597978 LA     school 2200840 026   Jefferson Parish 220084001667 26105 Patrick F. Taylor Science & Technology Academy   Regular School No High 06 12 2020 spring grade_11                                                   98                                             98
600307 LA     school 2200090 003   Ascension Parish 220009002081 3029 Pecan Grove Primary School   Regular School No Elementary PK 05 2020 spring grade_2                                                   98                                             98
600572 LA     school 2200540 017   East Baton Rouge Parish 220054000372 17032 The Dufrocq School   Regular School No Elementary PK 05 2020 spring grade_2                                                   98                                             98
600758 LA     school 2200840 026   Jefferson Parish 220084000643 26069 Marie B. Riviere Elementary School   Regular School No Elementary PK 05 2020 spring grade_2                                                   98                                             98
600822 LA     school 2200870 028   Lafayette Parish 220087000670 28012 Katharine Drexel Elementary School   Regular School No Elementary PK 05 2020 spring grade_2                                                   98                                             98
601124 LA     school 2201410 044   St. Bernard Parish 220141001131 44012 Joseph J. Davies Elementary School   Regular School No Elementary PK 05 2020 spring grade_2                                                   98                                             98
601163 LA     school 2201530 048   St. John the Baptist Parish 220153001493 48006 LaPlace Elementary School   Regular School No Elementary PK 13 2020 spring grade_2                                                   98                                             98

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