enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_10", state = "NJ" and year = 2020 sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • grade_10 · 2,502 ✖
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
2512644 2512644 NJ Somerset 35 school 3409630 3000   Manville Boro 340963005238 50 Manville High School   Regular School No High 09 12 2020   grade_10                                                   98.5                                             98
2512388 2512388 NJ Ocean 29 school 3413320 4220   Point Pleasant Beach Boro 341332004702 50 Point Pleasant Beach High School   Regular School No High 09 12 2020   grade_10                                                   98.0                                             98
2512999 2512999 NJ Charters 80 school 3400087 7503   Paterson Cs For Sci/Tech 340008700735 970 Paterson Charter School For Science/Technology   Regular School Yes Other KG 12 2020   grade_10                                                   98.0                                             98
2510850 2510850 NJ Bergen 3 school 3416920 5430   Wallington Boro 341692000898 50 Wallington Junior Senior High School   Regular School No High 07 12 2020   grade_10                                                   97.0                                             97
2512997 2512997 NJ Charters 80 school 3400019 7410   Charter~Tech High School 340001900269 940 Chartertech High School For The Performing Arts   Regular School Yes High 09 12 2020   grade_10                                                   96.0                                             96
2511583 2511583 NJ Hudson 17 school 3407830 2390   Jersey City 340783003378 301 Innovation High School   Regular School No High 09 12 2020   grade_10                                                   94.0                                             94
2512691 2512691 NJ Sussex 37 school 3407440 2240   Hopatcong 340744005362 30 Hopatcong High School   Regular School No High 08 12 2020   grade_10                                                   94.0                                             94
2510960 2510960 NJ Burlington 5 school 3412390 3920   Palmyra Boro 341239001188 50 Palmyra High School   Regular School No High 09 12 2020   grade_10                                                   93.0                                             93
2512944 2512944 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_10                                                   93.0                                             93
2510611 2510611 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000284 20 Bogota Jr./Sr. High School   Regular School No High 07 12 2020   grade_10                                                   92.0                                             92
2512897 2512897 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_10                                                   92.0                                             92
2511518 2511518 NJ Gloucester 15 school 3418150 5860   Woodbury City 341815002688 50 Woodbury Jr-Sr High School   Regular School No High 06 12 2020   grade_10                                                   91.0                                             91
2511488 2511488 NJ Gloucester 15 school 3413080 4140   Pitman Boro 341308002616 50 Pitman High School   Regular School No High 09 12 2020   grade_10                                                   90.0                                             90
2512370 2512370 NJ Ocean 29 school 3411980 3790   Ocean County Vocational 341198004670 10 Ocean County Vocational Technical School Brick Center   Career and Technical School No High 09 12 2020   grade_10                                                   9.5                                             9
2510881 2510881 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244000982 30 Westampton Campus   Special Education School No Other PK 12 2020   grade_10                                                   9.0                                             9
2511463 2511463 NJ Gloucester 15 school 3480363 1774   Gloucester Co Spec Serv 348036300413 15 Bankbridge Regional School   Special Education School No Other PK 12 2020   grade_10                                                   9.0                                             9
2512659 2512659 NJ Somerset 35 school 3480280 4805   Somerset Co Ed Serv Comm 348028005918 50 Somerset Secondary Academy   Special Education School No High 09 12 2020   grade_10                                                   9.0                                             9
2510777 2510777 NJ Bergen 3 school 3412450 3940   Park Ridge Boro 341245000710 50 Park Ridge High School   Regular School No High 07 12 2020   grade_10                                                   89.0                                             89
2512924 2512924 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   grade_10                                                   89.0                                             89
2512933 2512933 NJ Charters 80 school 3400715 6013   Bergen Arts And Sciences Charter School 340071502923 900 Bergen Arts And Sciences Charter School   Regular School Yes Other KG 12 2020   grade_10                                                   88.0                                             88
2510975 2510975 NJ Burlington 5 school 3414010 4450   Riverside Twp 341401001234 50 Riverside High School   Regular School No High 09 12 2020   grade_10                                                   87.0                                             87
2512381 2512381 NJ Ocean 29 school 3413230 4190   Plumsted Twp 341323000341 10 New Egypt High School   Regular School No High 09 12 2020   grade_10                                                   87.0                                             87
2511786 2511786 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402003286 40 Dunellen High School   Regular School No High 09 12 2020   grade_10                                                   85.0                                             85
2512471 2512471 NJ Passaic 31 school 3412630 3995   Passaic County Vocational 341263004860 50 Passaic County Technical Institute   Career and Technical School No High 09 12 2020   grade_10                                                   846.0                                             846
2511336 2511336 NJ Essex 13 school 3411340 3570   Newark City 341134002202 57 University High School   Regular School No High 07 12 2020   grade_10                                                   83.0                                             83
2512865 2512865 NJ Union 39 school 3418040 5260   Union County Vocational 341804000584 20 Academy For Allied Health Sciences   Career and Technical School No High 09 12 2020   grade_10                                                   83.0                                             83
2512038 2512038 NJ Monmouth 25 school 3407950 2430   Keyport Boro 340795003888 50 Keyport High School   Regular School No High 09 12 2020   grade_10                                                   82.0                                             82
2512765 2512765 NJ Union 39 school 3404590 1320   Elizabeth City 340459003389 303 J. Christian Bollwage Finance Academy   Regular School No High 09 12 2020   grade_10                                                   82.0                                             82
2512976 2512976 NJ Charters 80 school 3400770 6183   Trenton Stem-To-Civics Cs 340077003291 914 Trenton Stem-To-Civics Charter School   Regular School Yes High 06 12 2020   grade_10                                                   82.0                                             82
2511015 2511015 NJ Camden 7 school 3402640 680   Camden City 340264001346 30 Camden High School   Regular School No High 09 12 2020   grade_10                                                   81.0                                             81
2511254 2511254 NJ Essex 13 school 3404230 1210   East Orange 340423002040 30 East Orange Stem Academy High School   Regular School No High 06 12 2020   grade_10                                                   81.0                                             81
2512806 2512806 NJ Union 39 school 3413140 4160   Plainfield City 341314003041 52 Plainfield Academy For The Arts & Advanced Studies   Regular School No High 07 12 2020   grade_10                                                   81.0                                             81
2512375 2512375 NJ Ocean 29 school 3411980 3790   Ocean County Vocational 341198006122 55 Performing Arts Academy Of The Ocean County Vocational Tech   Career and Technical School No High 09 12 2020   grade_10                                                   80.0                                             80
2512934 2512934 NJ Charters 80 school 3400717 6017   Foundation Academy Cs 340071702925 932 Foundation Academy Charter School   Regular School Yes Other KG 12 2020   grade_10                                                   80.0                                             80
2510532 2510532 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_10                                                   8.0                                             8
2511845 2511845 NJ Middlesex 23 school 3410080 3150   Middlesex Co Vocational 341008003176 301 Middlesex Co Voc School East Bruns. School Of Career Develop   Career and Technical School No High 09 12 2020   grade_10                                                   79.0                                             79
2512034 2512034 NJ Monmouth 25 school 3407860 2400   Keansburg Boro 340786003880 10 Keansburg High School   Regular School No High 09 12 2020   grade_10                                                   78.0                                             78
2510600 2510600 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000252 30 Bergen County Technical High School - Paramus   Special Education School No High 09 12 2020   grade_10                                                   77.5                                             77
2512476 2512476 NJ Passaic 31 school 3412690 4010   Paterson City 341269003107 4 School Of Health Science   Regular School No High 09 12 2020   grade_10                                                   77.0                                             77
2512979 2512979 NJ Charters 80 school 3400080 6240   Freedom Prep Charter School 340008000566 900 Freedom Prep Charter School   Regular School Yes Other KG 12 2020   grade_10                                                   77.0                                             77
2512103 2512103 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750006121 28 Biotechnology High School   Career and Technical School No High 09 12 2020   grade_10                                                   76.0                                             76
2512957 2512957 NJ Charters 80 school 3400745 6080   Passaic Arts And Science Charter School 340074503137 966 Passaic Arts And Science Charter School   Regular School Yes Other KG 12 2020   grade_10                                                   76.0                                             76
2511337 2511337 NJ Essex 13 school 3411340 3570   Newark City 341134002206 70 Weequahic High School   Regular School No High 09 12 2020   grade_10                                                   75.0                                             75
2511918 2511918 NJ Middlesex 23 school 3415210 4860   South Brunswick Twp 341521003610 50 South Brunswick High School   Regular School No High 09 12 2020   grade_10                                                   743.0                                             743
2511612 2511612 NJ Hudson 17 school 3416380 5240   Union City 341638003059 55 Union City High School   Regular School No High 09 12 2020   grade_10                                                   742.0                                             742
2510644 2510644 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000380 50 Emerson Jr Sr High   Regular School No High 07 12 2020   grade_10                                                   74.0                                             74
2511333 2511333 NJ Essex 13 school 3411340 3570   Newark City 341134002198 50 Malcolm X Shabazz High School   Regular School No High 09 12 2020   grade_10                                                   73.0                                             73
2511484 2511484 NJ Gloucester 15 school 3412720 4020   Paulsboro Boro 341272002608 50 Paulsboro High School   Regular School No High 09 12 2020   grade_10                                                   73.0                                             73
2511653 2511653 NJ Hunterdon 19 school 3400769 1376   South Hunterdon Regional School District 340076903036 50 South Hunterdon Regional High School   Regular School No High 07 12 2020   grade_10                                                   73.0                                             73
2512099 2512099 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750000409 4 Communications High School   Career and Technical School No High 09 12 2020   grade_10                                                   73.0                                             73
2512102 2512102 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750000163 25 Monmouth County Academy Of Allied Health And Science   Career and Technical School No High 09 12 2020   grade_10                                                   73.0                                             73
2512868 2512868 NJ Union 39 school 3418040 5260   Union County Vocational 341804000214 40 Union County Magnet High School   Career and Technical School No High 09 12 2020   grade_10                                                   73.0                                             73
2512420 2512420 NJ Passaic 31 school 3403300 900   Clifton City 340330004762 30 Clifton High School   Regular School No High 09 12 2020   grade_10                                                   723.0                                             723
2511842 2511842 NJ Middlesex 23 school 3410080 3150   Middlesex Co Vocational 341008003424 60 Middlesex County Vocational School Perth Amboy   Career and Technical School No High 09 12 2020   grade_10                                                   72.0                                             72
2512100 2512100 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750006095 10 High Technology High School   Career and Technical School No High 09 12 2020   grade_10                                                   71.0                                             71
2511789 2511789 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003294 50 East Brunswick High School   Regular School No High 10 12 2020   grade_10                                                   703.5                                             703
2512101 2512101 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750005989 20 Marine Academy Of Science And Technology   Career and Technical School No High 09 12 2020   grade_10                                                   70.0                                             70
2512974 2512974 NJ Charters 80 school 3400788 6109   Lead Charter School 340078803423 953 Lead Charter School   Regular School Yes High 09 12 2020   grade_10                                                   70.0                                             70
2511275 2511275 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_10                                                   7.0                                             7
2510738 2510738 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014000608 50 Midland Park Jr./Sr. High School   Regular School No High 07 12 2020   grade_10                                                   69.0                                             69
2512374 2512374 NJ Ocean 29 school 3411980 3790   Ocean County Vocational 341198000559 45 Marine Academy Of Technology And Environmental Science   Career and Technical School No High 09 12 2020   grade_10                                                   69.0                                             69
2511844 2511844 NJ Middlesex 23 school 3410080 3150   Middlesex Co Vocational 341008003428 70 Middlesex County Voc Acad Allied Health & Biomedical Science   Career and Technical School No High 09 12 2020   grade_10                                                   67.0                                             67
2512612 2512612 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228000173 5 Bridgewater-Raritan High School   Regular School No High 09 12 2020   grade_10                                                   661.5                                             661
2511873 2511873 NJ Middlesex 23 school 3409270 3845   Old Bridge Twp 340927003496 40 Old Bridge High School   Regular School No High 09 12 2020   grade_10                                                   653.5                                             653
2511749 2511749 NJ Mercer 21 school 3416290 5210   Trenton Public School District 341629003200 50 Trenton Central High School - Main Campus   Regular School No High 10 12 2020   grade_10                                                   650.0                                             650
2511916 2511916 NJ Middlesex 23 school 3415120 4830   South Amboy City 341512000154 30 South Amboy Middle/High School   Regular School No High 06 12 2020   grade_10                                                   65.0                                             65
2511666 2511666 NJ Hunterdon 19 school 3407590 2300   Hunterdon Central Reg 340759003006 50 Hunterdon Central Regional High School District   Regular School No High 09 12 2020   grade_10                                                   641.0                                             641
2511887 2511887 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293003530 50 Perth Amboy High School   Regular School No High 09 12 2020   grade_10                                                   640.5                                             640
2511801 2511801 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003326 53 John P. Stevens High School   Regular School No High 09 12 2020   grade_10                                                   630.0                                             630
2510603 2510603 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147003341 300 Applied Technology High School   Career and Technical School No High 09 12 2020   grade_10                                                   62.0                                             62
2511172 2511172 NJ Cape May 9 school 3417940 5790   Wildwood City 341794001768 50 Wildwood High School   Regular School No High 09 12 2020   grade_10                                                   62.0                                             62
2512866 2512866 NJ Union 39 school 3418040 5260   Union County Vocational 341804006134 30 Academy For Information Technology   Career and Technical School No High 09 12 2020   grade_10                                                   61.0                                             61
2511554 2511554 NJ Hudson 17 school 3407830 2390   Jersey City 340783003121 2 Infinity Institute   Regular School No High 06 12 2020   grade_10                                                   60.0                                             60
2511738 2511738 NJ Mercer 21 school 3409950 3105   Mercer County Vocational 340995003178 40 Mcvs Arthur R. Sypek Center   Career and Technical School No High 10 12 2020   grade_10                                                   6.5                                             6
2510596 2510596 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000238 50 Emotionally Disturbed   Special Education School No Other PK 12 2020   grade_10                                                   6.0                                             6
2511117 2511117 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_10                                                   6.0                                             6
2511274 2511274 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_10                                                   6.0                                             6
2512590 2512590 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_10                                                   6.0                                             6
2512450 2512450 NJ Passaic 31 school 3412540 3970   Passaic City 341254004836 50 Passaic High School No. 12   Regular School No High 09 12 2020   grade_10                                                   591.0                                             591
2511561 2511561 NJ Hudson 17 school 3407830 2390   Jersey City 340783000391 82 Liberty High School   Regular School No High 09 12 2020   grade_10                                                   59.0                                             59
2512867 2512867 NJ Union 39 school 3418040 5260   Union County Vocational 341804003009 35 Academy For Performing Arts   Career and Technical School No High 09 12 2020   grade_10                                                   59.0                                             59
2512964 2512964 NJ Charters 80 school 3400765 6096   Paterson Arts And Science Charter School 340076503254 982 Paterson Arts And Science Charter School   Regular School Yes Other KG 11 2020   grade_10                                                   59.0                                             59
2511209 2511209 NJ Cumberland 11 school 3416800 5390   Vineland City 341680001902 50 Vineland Senior High School   Regular School No High 09 12 2020   grade_10                                                   588.0                                             588
2511848 2511848 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003438 5 Monroe Township High School   Regular School No High 09 12 2020   grade_10                                                   587.0                                             587
2511500 2511500 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002640 10 Washington Township High School   Regular School No High 09 12 2020   grade_10                                                   586.0                                             586
2511669 2511669 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2020   grade_10                                                   57.0                                             57
2511034 2511034 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001418 30 Cherry Hill High School East   Regular School No High 09 12 2020   grade_10                                                   565.0                                             565
2512635 2512635 NJ Somerset 35 school 3407230 2170   Hillsborough Twp 340723005222 30 Hillsborough High School   Regular School No High 09 12 2020   grade_10                                                   565.0                                             565
2510543 2510543 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456005961 5 Egg Harbor Township High School   Regular School No High 09 12 2020   grade_10                                                   561.0                                             561
2511628 2511628 NJ Hudson 17 school 3417580 5670   West New York Town 341758002938 50 Memorial High School   Regular School No High 09 12 2020   grade_10                                                   560.0                                             560
2511552 2511552 NJ Hudson 17 school 3407570 2295   Hudson County Vocational 340757003198 304 Academy Of Technology Design   Career and Technical School No High 09 12 2020   grade_10                                                   56.0                                             56
2511856 2511856 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003454 50 New Brunswick High School   Regular School No High 09 12 2020   grade_10                                                   554.0                                             554
2512873 2512873 NJ Union 39 school 3416500 5290   Union Twp 341650005742 50 Union High School   Regular School No High 09 12 2020   grade_10                                                   547.0                                             547
2511600 2511600 NJ Hudson 17 school 3411460 3610   North Bergen Twp 341146002882 50 North Bergen High School   Regular School No High 09 12 2020   grade_10                                                   546.0                                             546
2511014 2511014 NJ Camden 7 school 3402640 680   Camden City 340264000087 29 Dr. Charles E. Brimm Medical Arts High School   Regular School No High 09 12 2020   grade_10                                                   54.0                                             54
2512104 2512104 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750005990 40 Monmouth County Career Center   Career and Technical School No High 09 12 2020   grade_10                                                   54.0                                             54
2512477 2512477 NJ Passaic 31 school 3412690 4010   Paterson City 341269003109 5 School Of Earth And Space Science   Regular School No High 09 12 2020   grade_10                                                   54.0                                             54
2510915 2510915 NJ Burlington 5 school 3408490 2610   Lenape Regional 340849001092 40 Cherokee High School   Regular School No High 09 12 2020   grade_10                                                   536.0                                             536
2511997 2511997 NJ Monmouth 25 school 3405610 1650   Freehold Regional 340561003800 60 Howell High School   Regular School No High 09 12 2020   grade_10                                                   533.5                                             533
2511279 2511279 NJ Essex 13 school 3404800 1390   Essex Co Voc-Tech 340480002080 80 Essex County West Caldwell Tech   Career and Technical School No High 09 12 2020   grade_10                                                   53.5                                             53

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