Data source: Big Local News · About: Big Local

137,628 rows where state = "LA" sorted by total descending

View and edit SQL

grade

year

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
2304368 LA     school 2201500 047   St. James Parish 220150001163 47004 Lutcher High School   Regular School No High 07 12 2019 spring pk_12_total 499.0 478.0 13.0 3.0   4.0     0.0   2.0   494.0 505.00000000000006     3.0       492.0         999 499 478 13 3   4     0   2   494       3   492       999
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
2304787 LA     school   R36   All Orleans   395005 Lord Beaconsfield Landry-Oliver Perry Walker High             2019 spring pk_12_total 3.0 953.0 38.0 0.0   2.0     0.0   2.0   544.0 454.0     38.0       992.0         998 3 953 38 0   2     0   2   544 454     38   992       998
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
1785780 LA     school   CHA   Type 2 Charters   348001 New Orleans Military & Maritime Academy             2021 spring pk_12_total 257.0 322.0 369.0 8.0   16.0     0.0   26.0   585.0 413.0     144.0       769.0         998 257 322 369 8   16     0   26   585 413     144   769       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
2538226 LA     school 2200540 017   East Baton Rouge Parish 220054000434 17088 Tara High School   Regular School No High 09 12 2019 fall pk_12_total 54.0 781.0 135.0 0.0   18.0     0.0   8.0   533.0 463.0     118.0       824.0         996 54 781 135 0   18     0   8   533 463     118   824       996
2538677 LA     school 2201290 040   Rapides Parish 220129001041 40005 J.I. Barron Sr. Elementary School   Regular School No Elementary PK 06 2019 fall pk_12_total 669.0 213.0 24.0 2.0   44.0     4.0   40.0   510.00000000000006 486.0     52.0       603.0         996 669 213 24 2   44     4   40     486     52   603       996
2539181 LA     school   R36   All Orleans   368001 Morris Jeff Community School             2019 fall pk_12_total 267.0 510.0 166.0 0.0   6.0     0.0   47.0   536.0 460.0     70.0       679.0         996 267 510 166 0   6     0   47   536 460     70   679       996
2304791 LA     school   R36   All Orleans   398002 KIPP Morial             2019 spring pk_12_total 5.0 916.0 60.0 0.0   1.0     0.0   13.0   515.0 480.0     35.0       920.0         995 5 916 60 0   1     0   13   515 480     35   920       995
2539257 LA     school   R36   All Orleans   WBB001 Benjamin Franklin High School             2019 fall pk_12_total 371.0 296.0 55.0 8.0   190.0     1.0   74.0   408.0 587.0     0.0       349.0         995 371 296 55 8   190     1   74   408 587     0   349       995
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
2009104 LA     school 2201290 040   Rapides Parish 220129001084 40048 Tioga High School   Regular School No High 09 12 2021 fall pk_12_total 634.0 315.0 24.0 4.0   4.0     0.0   13.0   514.0 480.0     0.0       725.0         994 634 315 24 4   4     0   13   514 480     0   725       994
2537984 LA     school 2200270 008   Bossier Parish 220027000125 8015 Elm Grove Middle School   Regular School No Middle 06 08 2019 fall pk_12_total 599.0 234.0 74.0 2.0   22.0     4.0   58.0   513.0 480.0     12.0       500.0         993 599 234 74 2   22     4   58   513 480     12   500       993
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
2538064 LA     school 2200300 009   Caddo Parish 220030002377 9106 Magnolia School of Excellence   Regular School Yes Other KG 11 2019 fall pk_12_total 131.0 786.0 54.0 1.0   4.0     0.0   16.0   501.0 491.0     27.0       795.0         992 131 786 54 1   4     0   16   501 491     27   795       992
1785396 LA     school 2201500 047   St. James Parish 220150001163 47004 Lutcher High School   Regular School No High 07 12 2021 spring pk_12_total 501.0 472.0 11.0 3.0   2.0     0.0   3.0   522.0 470.0     5.0       505.0         992 501 472 11 3   2     0   3   522 470     5   505       992
1785839 LA     school   R36   Orleans Parish   398002 KIPP Morial             2021 spring pk_12_total 2.0 911.0 68.0 1.0   0.0     0.0   10.0   512.0 480.0     45.0       942.0         992 2 911 68 1   0     0   10   512 480     45   942       992
2009587 LA     school   R36   Orleans Parish   398002 KIPP Morial             2021 fall pk_12_total 2.0 911.0 68.0 1.0   0.0     0.0   10.0   516.0 476.0     45.0       939.0         992 2 911 68 1   0     0   10   516 476     45   939       992
2303573 LA     school 2200270 008   Bossier Parish 220027000125 8015 Elm Grove Middle School   Regular School No Middle 06 08 2019 spring pk_12_total 599.0 231.0 75.0 2.0   22.0     4.0   58.0   515.0 476.0     12.0       504.0         991 599 231 75 2   22     4   58   515 476     12   504       991
2304198 LA     school 2201170 R36   All Orleans 220117000880 36035 Warren Easton Senior High School   Regular School Yes High 09 12 2019 spring pk_12_total 1.0 960.0 25.0 0.0   0.0     0.0   5.0   481.0 510.0     15.0       777.0         991 1 960 25 0   0     0   5   481 510     15   777       991
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
2284010 LA     school 2200540 017   East Baton Rouge Parish 220054000390 17050 LaBelle Aire Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   99                                             99
2284200 LA     school 2200840 026   Jefferson Parish 220084000656 26083 Woodland West Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   99                                             99
2284397 LA     school 2201110 034   Morehouse Parish 220111000807 34004 Morehouse Junior High School   Regular School No Elementary KG 07 2019 spring grade_1                                                   99                                             99
2284561 LA     school 2201410 044   St. Bernard Parish 220141002338 44027 Lacoste Elementary School   Regular School No Elementary PK 05 2019 spring grade_1                                                   99                                             99
2286795 LA     school 2200480 015   Concordia Parish 220048000324 15008 Vidalia High School   Regular School No High 08 12 2019 spring grade_11                                                   99                                             99
2289282 LA     school   CHA   Type 2 Charters   W4B001 Lake Charles College Prep             2019 spring grade_12                                                   99                                             99
2289930 LA     school 2200870 028   Lafayette Parish 220087001598 28040 Evangeline Elementary School   Regular School No Elementary PK 05 2019 spring grade_2                                                   99                                             99
2290008 LA     school 2201020 032   Livingston Parish 220102000766 32013 Live Oak Elementary School   Regular School No Elementary PK 04 2019 spring grade_2                                                   99                                             99
2290032 LA     school 2201020 032   Livingston Parish 220102001719 32043 North Live Oak Elementary School   Regular School No Elementary PK 04 2019 spring grade_2                                                   99                                             99
2290863 LA     school 2200270 008   Bossier Parish 220027000133 8023 Plantation Park Elementary School   Regular School No Elementary PK 05 2019 spring grade_3                                                   99                                             99
2291429 LA     school 2201020 032   Livingston Parish 220102000772 32022 Springfield Elementary School   Regular School No Elementary PK 04 2019 spring grade_3                                                   99                                             99
2291436 LA     school 2201020 032   Livingston Parish 220102001612 32031 Levi Milton Elementary School   Regular School No Elementary PK 05 2019 spring grade_3                                                   99                                             99
2291658 LA     school 2201530 048   St. John the Baptist Parish 220153001493 48006 LaPlace Elementary School   Regular School No Elementary KG 08 2019 spring grade_3                                                   99                                             99
2292110 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2019 spring grade_3                                                   99                                             99
2292262 LA     school 2200270 008   Bossier Parish 220027000116 8005 Benton Elementary School   Regular School No Elementary KG 05 2019 spring grade_4                                                   99                                             99
2292295 LA     school 2200300 009   Caddo Parish 220030000145 9006 Blanchard Elementary School   Regular School No Elementary PK 04 2019 spring grade_4                                                   99                                             99
2293458 LA     school   R36   All Orleans   363001 Harriet Tubman Charter School             2019 spring grade_4                                                   99                                             99
2293523 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2019 spring grade_4                                                   99                                             99
2296764 LA     school 2200540 017   East Baton Rouge Parish 220054000673 17111 Community School For Apprenticeship Learning   Regular School Yes Middle 06 08 2019 spring grade_7                                                   99                                             99
2297298 LA     school 2201470 046   St. Helena Parish 220147001154 46002 St. Helena College and Career Academy   Regular School No High 07 12 2019 spring grade_7                                                   99                                             99
2297305 LA     school 2201500 047   St. James Parish 220150001167 47008 St. James High School   Regular School No High 07 12 2019 spring grade_7                                                   99                                             99
2297723 LA     school 2200054 RLA   RSD-Direct Run 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2019 spring grade_7                                                   99                                             99
2298021 LA     school 2200330 010   Calcasieu Parish 220033000226 10015 DeQuincy Middle School   Regular School No Middle 06 08 2019 spring grade_8                                                   99                                             99
2298667 LA     school 2201350 042   Richland Parish 220135001103 42009 Rayville Junior High School   Regular School No Middle 07 08 2019 spring grade_8                                                   99                                             99
2299136 LA     school 2200054 RLA   RSD-Direct Run 220005400175 396211 Linwood Charter School   Regular School No Elementary PK 08 2019 spring grade_8                                                   99                                             99
2302167 LA     school 2200270 008   Bossier Parish 220027000133 8023 Plantation Park Elementary School   Regular School No Elementary PK 05 2019 spring kindergarten                                                   99                                             99
2302423 LA     school 2200540 017   East Baton Rouge Parish 220054002265 17131 Woodlawn Elementary   Regular School No Elementary PK 05 2019 spring kindergarten                                                   99                                             99
2303101 LA     school 2201680 053   Tangipahoa Parish 220168001297 53001 Amite Elementary Magnet School   Regular School No Elementary PK 04 2019 spring kindergarten                                                   99                                             99
2304996 LA     school 2200270 008   Bossier Parish 220027001574 8027 T.L. Rodes Elementary School   Regular School No Elementary PK 01 2019 spring pre_kindergarten                                                   99                                             99
2305332 LA     school 2200750 024   Iberville Parish 220075001980 24019 Dorseyville Elementary School   Regular School No Elementary PK 06 2019 spring pre_kindergarten                                                   99                                             99
2305954 LA     school 2201680 053   Tangipahoa Parish 220168001841 53034 Perrin Early Learning Center   Regular School No Elementary PK KG 2019 spring pre_kindergarten                                                   99                                             99
2518058 LA     school 2200060 002   Allen Parish 220006000026 2003 Kinder Elementary School   Regular School No Elementary PK 04 2019 fall grade_1                                                   99                                             99
2518138 LA     school 2200270 008   Bossier Parish 220027000114 8003 Bellaire Elementary School   Regular School No Elementary KG 03 2019 fall grade_1                                                   99                                             99
2518577 LA     school 2200840 026   Jefferson Parish 220084000590 26118 John Clancy/Joseph Maggiore Elementary School   Regular School No Elementary PK 05 2019 fall grade_1                                                   99                                             99
2518807 LA     school 2201200 037   Ouachita Parish 220120001020 37038 Woodlawn Elementary School   Regular School No Elementary PK 05 2019 fall grade_1                                                   99                                             99
2518947 LA     school 2201500 047   St. James Parish 220150001170 47011 Vacherie Elementary School   Regular School No Elementary PK 03 2019 fall grade_1                                                   99                                             99
2519404 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2019 fall grade_1                                                   99                                             99
2520137 LA     school 2201020 032   Livingston Parish 220102000773 32023 Springfield High School   Regular School No High 08 12 2019 fall grade_10                                                   99                                             99
2521158 LA     school 2200480 015   Concordia Parish 220048000324 15008 Vidalia High School   Regular School No High 08 12 2019 fall grade_11                                                   99                                             99
2524330 LA     school 2200900 029   Lafourche Parish 220090000717 29021 Raceland Lower Elementary School   Regular School No Elementary PK 02 2019 fall grade_2                                                   99                                             99
2524475 LA     school 2201200 037   Ouachita Parish 220120001020 37038 Woodlawn Elementary School   Regular School No Elementary PK 05 2019 fall grade_2                                                   99                                             99
2524598 LA     school 2201440 045   St. Charles Parish 220144001148 45013 Norco Elementary School   Regular School No Elementary PK 05 2019 fall grade_2                                                   99                                             99
2524618 LA     school 2201530 048   St. John the Baptist Parish 220153001493 48006 LaPlace Elementary School   Regular School No Elementary KG 08 2019 fall grade_2                                                   99                                             99
2524628 LA     school 2201560 049   St. Landry Parish 220156001174 49003 Cankton Elementary School   Regular School No Elementary PK 04 2019 fall grade_2                                                   99                                             99
2525334 LA     school 2200330 010   Calcasieu Parish 220033000232 10019 Frasch Elementary School   Regular School No Elementary PK 05 2019 fall grade_3                                                   99                                             99
2526240 LA     school 2201740 055   Terrebonne Parish 220174001370 55038 Upper Little Caillou Elementary School   Regular School No Elementary PK 04 2019 fall grade_3                                                   99                                             99
2526276 LA     school 2201830 058   Vernon Parish 220183001412 58008 Pickering Elementary School   Regular School No Elementary PK 06 2019 fall grade_3                                                   99                                             99
2526360 LA     school 2200240 066   City of Bogalusa School District 220024000102 66001 Central Elementary School   Regular School No Elementary 03 06 2019 fall grade_3                                                   99                                             99
2526489 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2019 fall grade_3                                                   99                                             99
2526494 LA     school   CHA   Type 2 Charters   WAG001 Louisiana Virtual Charter Academy             2019 fall grade_3                                                   99                                             99
2527126 LA     school 2200870 028   Lafayette Parish 220087001556 28028 Ossun Elementary School   Regular School No Elementary PK 05 2019 fall grade_4                                                   99                                             99
2527657 LA     school 2201740 055   Terrebonne Parish 220174001370 55038 Upper Little Caillou Elementary School   Regular School No Elementary PK 04 2019 fall grade_4                                                   99                                             99
2527894 LA     school   CHA   Type 2 Charters   W2B001 Willow Charter Academy             2019 fall grade_4                                                   99                                             99
2527906 LA     school   CHA   Type 2 Charters   W6B001 Acadiana Renaissance Charter Academy             2019 fall grade_4                                                   99                                             99
2528026 LA     school 2200150 005   Avoyelles Parish 220015000069 5012 Lafargue Elementary School   Regular School No Elementary PK 06 2019 fall grade_5                                                   99                                             99
2528072 LA     school 2200270 008   Bossier Parish 220027000133 8023 Plantation Park Elementary School   Regular School No Elementary PK 05 2019 fall grade_5                                                   99                                             99
2528711 LA     school 2201200 037   Ouachita Parish 220120000994 37012 Lakeshore School   Regular School No Elementary PK 05 2019 fall grade_5                                                   99                                             99
2529230 LA     school   R36   All Orleans   300001 Pierre A. Capdau Charter School at Avery Alexander             2019 fall grade_5                                                   99                                             99
2529613 LA     school 2200330 010   Calcasieu Parish 220033000271 10057 Vinton Middle School   Regular School No Middle 06 08 2019 fall grade_6                                                   99                                             99
2530320 LA     school 2201560 049   St. Landry Parish 220156001213 49042 Sunset Elementary School   Regular School No Middle 05 08 2019 fall grade_6                                                   99                                             99
2530535 LA     school 2201830 058   Vernon Parish 220183001665 58016 Rosepine Elementary School   Regular School No Elementary PK 06 2019 fall grade_6                                                   99                                             99
2530647 LA     school   R36   All Orleans   300001 Pierre A. Capdau Charter School at Avery Alexander             2019 fall grade_6                                                   99                                             99
2530815 LA     school 2200060 002   Allen Parish 220006000030 2007 Oakdale Middle School   Regular School No Middle 05 08 2019 fall grade_7                                                   99                                             99
2530858 LA     school 2200150 005   Avoyelles Parish 220015000063 5004 Bunkie Magnet High School   Regular School No High 07 12 2019 fall grade_7                                                   99                                             99
2530862 LA     school 2200150 005   Avoyelles Parish 220015000073 5016 Marksville High School   Regular School No High 07 12 2019 fall grade_7                                                   99                                             99
2532092 LA     school   R36   All Orleans   363001 Harriet Tubman Charter School             2019 fall grade_7                                                   99                                             99
2532416 LA     school 2200330 010   Calcasieu Parish 220033000226 10015 DeQuincy Middle School   Regular School No Middle 06 08 2019 fall grade_8                                                   99                                             99
2533199 LA     school 2201620 051   St. Mary Parish 220162001248 51038 B. Edward Boudreaux Middle School   Regular School No Middle 06 08 2019 fall grade_8                                                   99                                             99
2534293 LA     school 2201020 032   Livingston Parish 220102000761 32008 Doyle High School   Regular School No High 06 12 2019 fall grade_9                                                   99                                             99
2534875 LA     school 2200040 068   City of Baker School District 220004000344 68002 Baker High School   Regular School No High 09 12 2019 fall grade_9                                                   99                                             99
2535841 LA     school 2201290 040   Rapides Parish 220129001040 40003 Alexandria Senior High School   Regular School No High 09 12 2019 fall grade_9_transitional                                                   99                                             99
2537003 LA     school 2200840 026   Jefferson Parish 220084000638 26126 Young Audiences Charter School   Regular School Yes Elementary KG 08 2019 fall kindergarten                                                   99                                             99
2537083 LA     school 2200900 029   Lafourche Parish 220090000717 29021 Raceland Lower Elementary School   Regular School No Elementary PK 02 2019 fall kindergarten                                                   99                                             99
2537153 LA     school 2201020 032   Livingston Parish 220102000403 32040 South Walker Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   99                                             99
2537332 LA     school 2201410 044   St. Bernard Parish 220141001131 44012 Joseph J. Davies Elementary School   Regular School No Elementary PK 05 2019 fall kindergarten                                                   99                                             99
2538719 LA     school   040   Rapides Parish   40700 Rapides Central Office             2019 fall pk_12_total 40.0 47.0 4.0 1.0   1.0     0.0   6.0   68.0 31.0     0.0       70.0         99 40 47 4 1   1     0   6   68 31     0   70       99

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