enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

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
2402634 2402634 NJ Sussex 37 school 3402550 640   Byram Township School District 340255000728 10 Byram Lakes Elementary School   Regular School No Elementary PK 04 2021   grade_8                                                   0.0                                             0
2402669 2402669 NJ Sussex 37 school 3415930 5110   Sussex County Technical School District 341593005416 10 Sussex County Technical School   Career and Technical School No High 09 12 2021   grade_8                                                   0.0                                             0
2402737 2402737 NJ Union 39 school 3407920 2420   Kenilworth School District 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2021   grade_8                                                   134.0                                             134
2402779 2402779 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2402798 2402798 NJ Union 39 school 3415630 5000   Springfield Public School District 341563000213 10 Jonathan Dayton High School   Regular School No High 09 12 2021   grade_8                                                   0.0                                             0
2402817 2402817 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640005988 10 Lamberts Mill Academy   Special Education School No High 06 12 2021   grade_8                                                   1.0                                             1
2402847 2402847 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2021   grade_8                                                   53.0                                             53
2402849 2402849 NJ Warren 41 school 3400840 70   Alpha Borough School District 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2021   grade_8                                                   25.0                                             25
2402981 2402981 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000010 10 Atlantic City High School   Regular School No High 09 12 2021   grade_9                                                   496.0                                             496
2402985 2402985 NJ Atlantic 1 school 3400990 120   Atlantic County Vocational School District 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2021   grade_9                                                   437.0                                             437
2403024 2403024 NJ Atlantic 1 school 3409690 3020   Margate City School District 340969000162 10 Eugene A. Tighe Middle School   Regular School No Middle 05 08 2021   grade_9                                                   0.0                                             0
2403044 2403044 NJ Bergen 3 school 3400750 40   Allendale Public School District 340075000224 10 Brookside School   Regular School No Middle 04 08 2021   grade_9                                                   0.0                                             0
2403045 2403045 NJ Bergen 3 school 3400870 80   Alpine School District 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2021   grade_9                                                   0.0                                             0
2403161 2403161 NJ Bergen 3 school 3407260 2180   Hillsdale School District 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2021   grade_9                                                   0.0                                             0
2403323 2403323 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_9                                                   0.0                                             0
2403341 2403341 NJ Burlington 5 school 3402460 620   Burlington Township School District 340246001004 10 Burlington Township High School   Regular School No High 09 12 2021   grade_9                                                   264.0                                             264
2403374 2403374 NJ Burlington 5 school 3409180 2850   Lumberton Township Board Of Education 340918000703 10 Ashbrook Elementary School   Regular School No Elementary PK 02 2021   grade_9                                                   0.0                                             0
2403403 2403403 NJ Burlington 5 school 3410950 3440   Mount Laurel Township School District 341095001156 10 Countryside Elementary School   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2403453 2403453 NJ Camden 7 school 3401050 150   Audubon Public School District 340105001298 10 Audubon Junior/Senior High School   Regular School No High 07 12 2021   grade_9                                                   143.0                                             143
2403454 2403454 NJ Camden 7 school 3401170 190   Barrington School District 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2403465 2403465 NJ Camden 7 school 3402370 580   Brooklawn Public School District 340237001340 10 Alice Costello Elementary School   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2403506 2403506 NJ Camden 7 school 3403240 880   Clementon Elementary School District 340324005899 10 Clementon Elementary School   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2403574 2403574 NJ Camden 7 school 3412990 4110   Pine Hill School District 341299000432 10 Overbrook Senior High School   Regular School No High 09 12 2021   grade_9                                                   182.0                                             182
2403594 2403594 NJ Camden 7 school 3418060 5820   Winslow Township School District 341806000437 10 Winslow Township High School   Regular School No High 09 12 2021   grade_9                                                   356.0                                             356
2403600 2403600 NJ Cape May 9 school 3401110 170   Avalon School District 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2021   grade_9                                                   0.0                                             0
2403816 2403816 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002188 10 Arts High School   Regular School No High 09 12 2021   grade_9                                                   195.0                                             195
2403912 2403912 NJ Gloucester 15 school 3404620 1330   Elk Township School District 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2021   grade_9                                                   0.0                                             0
2403923 2403923 NJ Gloucester 15 school 3406040 1775   Gloucester County Vocational-Technical School District 340604002570 10 Gloucester County Institute Of Technology   Career and Technical School No High 09 12 2021   grade_9                                                   407.0                                             407
2403964 2403964 NJ Gloucester 15 school 3417070 5500   Washington Township School District 341707002640 10 Washington Township High School   Regular School No High 09 12 2021   grade_9                                                   535.0                                             535
2403989 2403989 NJ Hudson 17 school 3401260 220   Bayonne School District 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2021   grade_9                                                   29.0                                             29
2404097 2404097 NJ Hunterdon 19 school 3400690 20   Alexandria Township School District 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2404301 2404301 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008000395 10 Middlesex County Voc Academy Math Science &Engineering Techn   Career and Technical School No High 09 12 2021   grade_9                                                   44.0                                             44
2404311 2404311 NJ Middlesex 23 school 3410500 3290   Monroe Township School District 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2021   grade_9                                                   0.0                                             0
2404431 2404431 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_9                                                   115.0                                             115
2404434 2404434 NJ Monmouth 25 school 3401140 180   Avon Boro School District 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2404458 2404458 NJ Monmouth 25 school 3405610 1650   Freehold Regional High School District 340561000237 10 Colts Neck High School   Regular School No High 09 12 2021   grade_9                                                   306.0                                             306
2404487 2404487 NJ Monmouth 25 school 3407560 2290   Howell Township Public School District 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2021   grade_9                                                   0.0                                             0
2404495 2404495 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003880 10 Keansburg High School   Regular School No High 09 12 2021   grade_9                                                   96.0                                             96
2404563 2404563 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750006095 10 High Technology High School   Career and Technical School No High 09 12 2021   grade_9                                                   76.0                                             76
2404617 2404617 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_9                                                   293.0                                             293
2404673 2404673 NJ Morris 27 school 3410650 3340   Montville Township School District 341065004332 10 Montville Township High School   Regular School No High 09 12 2021   grade_9                                                   268.0                                             268
2404705 2404705 NJ Morris 27 school 3410980 3450   Mount Olive Township School District 341098004398 10 Mount Olive High School   Regular School No High 09 12 2021   grade_9                                                   339.0                                             339
2404748 2404748 NJ Morris 27 school 3414130 4490   Rockaway Township School District 341413004510 10 Birchwood Elementary School   Regular School No Elementary KG 05 2021   grade_9                                                   0.0                                             0
2404767 2404767 NJ Ocean 29 school 3416470 185   Barnegat Township School District 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Prekindergarten PK PK 2021   grade_9                                                   0.0                                             0
2404831 2404831 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198004670 10 Ocean County Vocational Technical School Brick Center   Career and Technical School No High 09 12 2021   grade_9                                                   5.5                                             5
2404841 2404841 NJ Ocean 29 school 3413230 4190   Plumsted Township School District 341323000341 10 New Egypt High School   Regular School No High 09 12 2021   grade_9                                                   76.0                                             76
2404928 2404928 NJ Passaic 31 school 3412600 3980   Passaic County Manchester Regional High School District 341260004856 10 Passaic County-Manchester Regional High School   Regular School No High 09 12 2021   grade_9                                                   205.0                                             205
2404986 2404986 NJ Passaic 31 school 3413470 4270   Prospect Park Public School District 341347004938 10 Prospect Park School No. 1   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2405026 2405026 NJ Salem 33 school 3412210 3860   Oldmans Township School District 341221005042 10 Oldmans Township School   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2405079 2405079 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Regional School District 340228005162 10 Bridgewater-Raritan Middle School   Regular School No Middle 07 08 2021   grade_9                                                   0.0                                             0
2405137 2405137 NJ Sussex 37 school 3400900 90   Andover Regional School District 340090005324 10 Florence M. Burd   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2405139 2405139 NJ Sussex 37 school 3402550 640   Byram Township School District 340255000728 10 Byram Lakes Elementary School   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2405174 2405174 NJ Sussex 37 school 3415930 5110   Sussex County Technical School District 341593005416 10 Sussex County Technical School   Career and Technical School No High 09 12 2021   grade_9                                                   183.0                                             183
2405242 2405242 NJ Union 39 school 3407920 2420   Kenilworth School District 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2021   grade_9                                                   135.0                                             135
2405284 2405284 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_9                                                   206.0                                             206
2405303 2405303 NJ Union 39 school 3415630 5000   Springfield Public School District 341563000213 10 Jonathan Dayton High School   Regular School No High 09 12 2021   grade_9                                                   151.0                                             151
2405322 2405322 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640005988 10 Lamberts Mill Academy   Special Education School No High 06 12 2021   grade_9                                                   2.0                                             2
2405352 2405352 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2021   grade_9                                                   0.0                                             0
2405354 2405354 NJ Warren 41 school 3400840 70   Alpha Borough School District 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2405486 2405486 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000010 10 Atlantic City High School   Regular School No High 09 12 2021   grade_10                                                   462.0                                             462
2405490 2405490 NJ Atlantic 1 school 3400990 120   Atlantic County Vocational School District 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2021   grade_10                                                   399.0                                             399
2405529 2405529 NJ Atlantic 1 school 3409690 3020   Margate City School District 340969000162 10 Eugene A. Tighe Middle School   Regular School No Middle 05 08 2021   grade_10                                                   0.0                                             0
2405549 2405549 NJ Bergen 3 school 3400750 40   Allendale Public School District 340075000224 10 Brookside School   Regular School No Middle 04 08 2021   grade_10                                                   0.0                                             0
2405550 2405550 NJ Bergen 3 school 3400870 80   Alpine School District 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2021   grade_10                                                   0.0                                             0
2405666 2405666 NJ Bergen 3 school 3407260 2180   Hillsdale School District 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2021   grade_10                                                   0.0                                             0
2405828 2405828 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   grade_10                                                   0.0                                             0
2405846 2405846 NJ Burlington 5 school 3402460 620   Burlington Township School District 340246001004 10 Burlington Township High School   Regular School No High 09 12 2021   grade_10                                                   289.0                                             289
2405879 2405879 NJ Burlington 5 school 3409180 2850   Lumberton Township Board Of Education 340918000703 10 Ashbrook Elementary School   Regular School No Elementary PK 02 2021   grade_10                                                   0.0                                             0
2405908 2405908 NJ Burlington 5 school 3410950 3440   Mount Laurel Township School District 341095001156 10 Countryside Elementary School   Regular School No Elementary PK 04 2021   grade_10                                                   0.0                                             0
2405958 2405958 NJ Camden 7 school 3401050 150   Audubon Public School District 340105001298 10 Audubon Junior/Senior High School   Regular School No High 07 12 2021   grade_10                                                   137.0                                             137
2405959 2405959 NJ Camden 7 school 3401170 190   Barrington School District 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2021   grade_10                                                   0.0                                             0
2405970 2405970 NJ Camden 7 school 3402370 580   Brooklawn Public School District 340237001340 10 Alice Costello Elementary School   Regular School No Elementary PK 08 2021   grade_10                                                   0.0                                             0
2406011 2406011 NJ Camden 7 school 3403240 880   Clementon Elementary School District 340324005899 10 Clementon Elementary School   Regular School No Elementary PK 08 2021   grade_10                                                   0.0                                             0
2406079 2406079 NJ Camden 7 school 3412990 4110   Pine Hill School District 341299000432 10 Overbrook Senior High School   Regular School No High 09 12 2021   grade_10                                                   164.0                                             164
2406099 2406099 NJ Camden 7 school 3418060 5820   Winslow Township School District 341806000437 10 Winslow Township High School   Regular School No High 09 12 2021   grade_10                                                   261.0                                             261
2406105 2406105 NJ Cape May 9 school 3401110 170   Avalon School District 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2021   grade_10                                                   0.0                                             0
2406321 2406321 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002188 10 Arts High School   Regular School No High 09 12 2021   grade_10                                                   165.0                                             165
2406417 2406417 NJ Gloucester 15 school 3404620 1330   Elk Township School District 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2021   grade_10                                                   0.0                                             0
2406428 2406428 NJ Gloucester 15 school 3406040 1775   Gloucester County Vocational-Technical School District 340604002570 10 Gloucester County Institute Of Technology   Career and Technical School No High 09 12 2021   grade_10                                                   393.0                                             393
2406469 2406469 NJ Gloucester 15 school 3417070 5500   Washington Township School District 341707002640 10 Washington Township High School   Regular School No High 09 12 2021   grade_10                                                   513.0                                             513
2406494 2406494 NJ Hudson 17 school 3401260 220   Bayonne School District 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2021   grade_10                                                   33.0                                             33
2406602 2406602 NJ Hunterdon 19 school 3400690 20   Alexandria Township School District 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2021   grade_10                                                   0.0                                             0
2406806 2406806 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008000395 10 Middlesex County Voc Academy Math Science &Engineering Techn   Career and Technical School No High 09 12 2021   grade_10                                                   45.0                                             45
2406816 2406816 NJ Middlesex 23 school 3410500 3290   Monroe Township School District 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2021   grade_10                                                   0.0                                             0
2406936 2406936 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_10                                                   123.0                                             123
2406939 2406939 NJ Monmouth 25 school 3401140 180   Avon Boro School District 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2021   grade_10                                                   0.0                                             0
2406963 2406963 NJ Monmouth 25 school 3405610 1650   Freehold Regional High School District 340561000237 10 Colts Neck High School   Regular School No High 09 12 2021   grade_10                                                   323.0                                             323
2406992 2406992 NJ Monmouth 25 school 3407560 2290   Howell Township Public School District 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2021   grade_10                                                   0.0                                             0
2407000 2407000 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003880 10 Keansburg High School   Regular School No High 09 12 2021   grade_10                                                   91.0                                             91
2407068 2407068 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750006095 10 High Technology High School   Career and Technical School No High 09 12 2021   grade_10                                                   74.0                                             74
2407122 2407122 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_10                                                   334.0                                             334
2407178 2407178 NJ Morris 27 school 3410650 3340   Montville Township School District 341065004332 10 Montville Township High School   Regular School No High 09 12 2021   grade_10                                                   264.0                                             264
2407210 2407210 NJ Morris 27 school 3410980 3450   Mount Olive Township School District 341098004398 10 Mount Olive High School   Regular School No High 09 12 2021   grade_10                                                   364.0                                             364
2407253 2407253 NJ Morris 27 school 3414130 4490   Rockaway Township School District 341413004510 10 Birchwood Elementary School   Regular School No Elementary KG 05 2021   grade_10                                                   0.0                                             0
2407272 2407272 NJ Ocean 29 school 3416470 185   Barnegat Township School District 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Prekindergarten PK PK 2021   grade_10                                                   0.0                                             0
2407336 2407336 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198004670 10 Ocean County Vocational Technical School Brick Center   Career and Technical School No High 09 12 2021   grade_10                                                   11.0                                             11
2407346 2407346 NJ Ocean 29 school 3413230 4190   Plumsted Township School District 341323000341 10 New Egypt High School   Regular School No High 09 12 2021   grade_10                                                   79.0                                             79
2407433 2407433 NJ Passaic 31 school 3412600 3980   Passaic County Manchester Regional High School District 341260004856 10 Passaic County-Manchester Regional High School   Regular School No High 09 12 2021   grade_10                                                   188.0                                             188
2407491 2407491 NJ Passaic 31 school 3413470 4270   Prospect Park Public School District 341347004938 10 Prospect Park School No. 1   Regular School No Elementary PK 08 2021   grade_10                                                   0.0                                             0
2407531 2407531 NJ Salem 33 school 3412210 3860   Oldmans Township School District 341221005042 10 Oldmans Township School   Regular School No Elementary PK 08 2021   grade_10                                                   0.0                                             0

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