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
2392614 2392614 NJ Sussex 37 school 3402550 640   Byram Township School District 340255000728 10 Byram Lakes Elementary School   Regular School No Elementary PK 04 2021   grade_4                                                   100.0                                             100
2392649 2392649 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_4                                                   0.0                                             0
2392717 2392717 NJ Union 39 school 3407920 2420   Kenilworth School District 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2021   grade_4                                                   0.0                                             0
2392759 2392759 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2392778 2392778 NJ Union 39 school 3415630 5000   Springfield Public School District 341563000213 10 Jonathan Dayton High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2392797 2392797 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_4                                                   0.0                                             0
2392827 2392827 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2021   grade_4                                                   48.0                                             48
2392829 2392829 NJ Warren 41 school 3400840 70   Alpha Borough School District 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2021   grade_4                                                   25.0                                             25
2392961 2392961 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000010 10 Atlantic City High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2392965 2392965 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_5                                                   0.0                                             0
2393004 2393004 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_5                                                   37.0                                             37
2393024 2393024 NJ Bergen 3 school 3400750 40   Allendale Public School District 340075000224 10 Brookside School   Regular School No Middle 04 08 2021   grade_5                                                   113.0                                             113
2393025 2393025 NJ Bergen 3 school 3400870 80   Alpine School District 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2021   grade_5                                                   11.0                                             11
2393141 2393141 NJ Bergen 3 school 3407260 2180   Hillsdale School District 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2021   grade_5                                                   0.0                                             0
2393303 2393303 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_5                                                   42.0                                             42
2393321 2393321 NJ Burlington 5 school 3402460 620   Burlington Township School District 340246001004 10 Burlington Township High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2393354 2393354 NJ Burlington 5 school 3409180 2850   Lumberton Township Board Of Education 340918000703 10 Ashbrook Elementary School   Regular School No Elementary PK 02 2021   grade_5                                                   0.0                                             0
2393383 2393383 NJ Burlington 5 school 3410950 3440   Mount Laurel Township School District 341095001156 10 Countryside Elementary School   Regular School No Elementary PK 04 2021   grade_5                                                   0.0                                             0
2393433 2393433 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_5                                                   0.0                                             0
2393434 2393434 NJ Camden 7 school 3401170 190   Barrington School District 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2021   grade_5                                                   0.0                                             0
2393445 2393445 NJ Camden 7 school 3402370 580   Brooklawn Public School District 340237001340 10 Alice Costello Elementary School   Regular School No Elementary PK 08 2021   grade_5                                                   31.0                                             31
2393486 2393486 NJ Camden 7 school 3403240 880   Clementon Elementary School District 340324005899 10 Clementon Elementary School   Regular School No Elementary PK 08 2021   grade_5                                                   60.0                                             60
2393554 2393554 NJ Camden 7 school 3412990 4110   Pine Hill School District 341299000432 10 Overbrook Senior High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2393574 2393574 NJ Camden 7 school 3418060 5820   Winslow Township School District 341806000437 10 Winslow Township High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2393580 2393580 NJ Cape May 9 school 3401110 170   Avalon School District 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2021   grade_5                                                   8.0                                             8
2393796 2393796 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002188 10 Arts High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2393892 2393892 NJ Gloucester 15 school 3404620 1330   Elk Township School District 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2021   grade_5                                                   39.0                                             39
2393903 2393903 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_5                                                   0.0                                             0
2393944 2393944 NJ Gloucester 15 school 3417070 5500   Washington Township School District 341707002640 10 Washington Township High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2393969 2393969 NJ Hudson 17 school 3401260 220   Bayonne School District 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2394077 2394077 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_5                                                   0.0                                             0
2394281 2394281 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_5                                                   0.0                                             0
2394291 2394291 NJ Middlesex 23 school 3410500 3290   Monroe Township School District 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2021   grade_5                                                   0.0                                             0
2394411 2394411 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_5                                                   0.0                                             0
2394414 2394414 NJ Monmouth 25 school 3401140 180   Avon Boro School District 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2021   grade_5                                                   11.0                                             11
2394438 2394438 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_5                                                   0.0                                             0
2394467 2394467 NJ Monmouth 25 school 3407560 2290   Howell Township Public School District 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2021   grade_5                                                   105.0                                             105
2394475 2394475 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003880 10 Keansburg High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2394543 2394543 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_5                                                   0.0                                             0
2394597 2394597 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2394653 2394653 NJ Morris 27 school 3410650 3340   Montville Township School District 341065004332 10 Montville Township High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2394685 2394685 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_5                                                   0.0                                             0
2394728 2394728 NJ Morris 27 school 3414130 4490   Rockaway Township School District 341413004510 10 Birchwood Elementary School   Regular School No Elementary KG 05 2021   grade_5                                                   59.0                                             59
2394747 2394747 NJ Ocean 29 school 3416470 185   Barnegat Township School District 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Prekindergarten PK PK 2021   grade_5                                                   0.0                                             0
2394811 2394811 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_5                                                   0.0                                             0
2394821 2394821 NJ Ocean 29 school 3413230 4190   Plumsted Township School District 341323000341 10 New Egypt High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2394908 2394908 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_5                                                   0.0                                             0
2394966 2394966 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_5                                                   98.0                                             98
2395006 2395006 NJ Salem 33 school 3412210 3860   Oldmans Township School District 341221005042 10 Oldmans Township School   Regular School No Elementary PK 08 2021   grade_5                                                   31.0                                             31
2395059 2395059 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_5                                                   0.0                                             0
2395117 2395117 NJ Sussex 37 school 3400900 90   Andover Regional School District 340090005324 10 Florence M. Burd   Regular School No Elementary PK 04 2021   grade_5                                                   0.0                                             0
2395119 2395119 NJ Sussex 37 school 3402550 640   Byram Township School District 340255000728 10 Byram Lakes Elementary School   Regular School No Elementary PK 04 2021   grade_5                                                   0.0                                             0
2395154 2395154 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_5                                                   0.0                                             0
2395222 2395222 NJ Union 39 school 3407920 2420   Kenilworth School District 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2021   grade_5                                                   0.0                                             0
2395264 2395264 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2395283 2395283 NJ Union 39 school 3415630 5000   Springfield Public School District 341563000213 10 Jonathan Dayton High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2395302 2395302 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_5                                                   0.0                                             0
2395332 2395332 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2021   grade_5                                                   51.0                                             51
2395334 2395334 NJ Warren 41 school 3400840 70   Alpha Borough School District 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2021   grade_5                                                   16.0                                             16
2395466 2395466 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000010 10 Atlantic City High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2395470 2395470 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_6                                                   0.0                                             0
2395509 2395509 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_6                                                   49.0                                             49
2395529 2395529 NJ Bergen 3 school 3400750 40   Allendale Public School District 340075000224 10 Brookside School   Regular School No Middle 04 08 2021   grade_6                                                   105.0                                             105
2395530 2395530 NJ Bergen 3 school 3400870 80   Alpine School District 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2021   grade_6                                                   12.0                                             12
2395646 2395646 NJ Bergen 3 school 3407260 2180   Hillsdale School District 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2021   grade_6                                                   0.0                                             0
2395808 2395808 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_6                                                   0.0                                             0
2395826 2395826 NJ Burlington 5 school 3402460 620   Burlington Township School District 340246001004 10 Burlington Township High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2395859 2395859 NJ Burlington 5 school 3409180 2850   Lumberton Township Board Of Education 340918000703 10 Ashbrook Elementary School   Regular School No Elementary PK 02 2021   grade_6                                                   0.0                                             0
2395888 2395888 NJ Burlington 5 school 3410950 3440   Mount Laurel Township School District 341095001156 10 Countryside Elementary School   Regular School No Elementary PK 04 2021   grade_6                                                   0.0                                             0
2395938 2395938 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_6                                                   0.0                                             0
2395939 2395939 NJ Camden 7 school 3401170 190   Barrington School District 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2021   grade_6                                                   0.0                                             0
2395950 2395950 NJ Camden 7 school 3402370 580   Brooklawn Public School District 340237001340 10 Alice Costello Elementary School   Regular School No Elementary PK 08 2021   grade_6                                                   36.0                                             36
2395991 2395991 NJ Camden 7 school 3403240 880   Clementon Elementary School District 340324005899 10 Clementon Elementary School   Regular School No Elementary PK 08 2021   grade_6                                                   43.0                                             43
2396059 2396059 NJ Camden 7 school 3412990 4110   Pine Hill School District 341299000432 10 Overbrook Senior High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2396079 2396079 NJ Camden 7 school 3418060 5820   Winslow Township School District 341806000437 10 Winslow Township High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2396085 2396085 NJ Cape May 9 school 3401110 170   Avalon School District 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2021   grade_6                                                   14.0                                             14
2396301 2396301 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002188 10 Arts High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2396397 2396397 NJ Gloucester 15 school 3404620 1330   Elk Township School District 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2021   grade_6                                                   48.0                                             48
2396408 2396408 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_6                                                   0.0                                             0
2396449 2396449 NJ Gloucester 15 school 3417070 5500   Washington Township School District 341707002640 10 Washington Township High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2396474 2396474 NJ Hudson 17 school 3401260 220   Bayonne School District 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2396582 2396582 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_6                                                   0.0                                             0
2396786 2396786 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_6                                                   0.0                                             0
2396796 2396796 NJ Middlesex 23 school 3410500 3290   Monroe Township School District 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2021   grade_6                                                   0.0                                             0
2396916 2396916 NJ Monmouth 25 school 3400930 100   Asbury Park School District 340093003732 10 Asbury Park High School   Regular School No High 07 12 2021   grade_6                                                   0.0                                             0
2396919 2396919 NJ Monmouth 25 school 3401140 180   Avon Boro School District 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2021   grade_6                                                   17.0                                             17
2396943 2396943 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_6                                                   0.0                                             0
2396972 2396972 NJ Monmouth 25 school 3407560 2290   Howell Township Public School District 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2021   grade_6                                                   0.0                                             0
2396980 2396980 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003880 10 Keansburg High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2397048 2397048 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_6                                                   0.0                                             0
2397102 2397102 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2397158 2397158 NJ Morris 27 school 3410650 3340   Montville Township School District 341065004332 10 Montville Township High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2397190 2397190 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_6                                                   0.0                                             0
2397233 2397233 NJ Morris 27 school 3414130 4490   Rockaway Township School District 341413004510 10 Birchwood Elementary School   Regular School No Elementary KG 05 2021   grade_6                                                   0.0                                             0
2397252 2397252 NJ Ocean 29 school 3416470 185   Barnegat Township School District 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Prekindergarten PK PK 2021   grade_6                                                   0.0                                             0
2397316 2397316 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_6                                                   0.0                                             0
2397326 2397326 NJ Ocean 29 school 3413230 4190   Plumsted Township School District 341323000341 10 New Egypt High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2397413 2397413 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_6                                                   0.0                                             0
2397471 2397471 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_6                                                   86.0                                             86
2397511 2397511 NJ Salem 33 school 3412210 3860   Oldmans Township School District 341221005042 10 Oldmans Township School   Regular School No Elementary PK 08 2021   grade_6                                                   29.0                                             29

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