enrollments

Data source: Big Local News · About: Big Local

5,007 rows where grade = "grade_7" and state = "NJ" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 5,007 ✖
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
2400342 2400342 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2021   grade_7                                                   43.0                                             43
2400343 2400343 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2021   grade_7                                                   0.0                                             0
2400344 2400344 NJ Warren 41 school 3400840 70   Alpha Borough School District 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2021   grade_7                                                   15.0                                             15
2400345 2400345 NJ Warren 41 school 3401440 280   Belvidere School District 340144005794 20 Belvidere High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400346 2400346 NJ Warren 41 school 3401440 280   Belvidere School District 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2021   grade_7                                                   27.0                                             27
2400347 2400347 NJ Warren 41 school 3401800 400   Blairstown Elementary Township School District 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2400348 2400348 NJ Warren 41 school 3405520 1620   Franklin Township School District 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2400349 2400349 NJ Warren 41 school 3405670 1670   Frelinghuysen Township School District 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2400350 2400350 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2400351 2400351 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2021   grade_7                                                   64.0                                             64
2400352 2400352 NJ Warren 41 school 3406210 1840   Greenwich Township School District 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2400353 2400353 NJ Warren 41 school 3406210 1840   Greenwich Township School District 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2021   grade_7                                                   82.0                                             82
2400354 2400354 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 02 2021   grade_7                                                   0.0                                             0
2400355 2400355 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005814 50 Hackettstown High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400356 2400356 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2021   grade_7                                                   100.0                                             100
2400357 2400357 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2021   grade_7                                                   0.0                                             0
2400358 2400358 NJ Warren 41 school 3406810 2040   Harmony Township School District 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2021   grade_7                                                   33.0                                             33
2400359 2400359 NJ Warren 41 school 3407470 2250   Hope Township School District 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2021   grade_7                                                   13.0                                             13
2400360 2400360 NJ Warren 41 school 3408070 2470   Knowlton Township School District 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2400361 2400361 NJ Warren 41 school 3409000 2790   Lopatcong Township School District 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2400362 2400362 NJ Warren 41 school 3409000 2790   Lopatcong Township School District 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2021   grade_7                                                   75.0                                             75
2400363 2400363 NJ Warren 41 school 3409540 2970   Mansfield Township Elementary School District 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2400364 2400364 NJ Warren 41 school 3409550 3675   North Warren Regional School District 340955005844 50 North Warren Regional School   Regular School No High 07 12 2021   grade_7                                                   116.0                                             116
2400365 2400365 NJ Warren 41 school 3412300 3890   Oxford Township School District 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2021   grade_7                                                   31.0                                             31
2400366 2400366 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400367 2400367 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2021   grade_7                                                   0.0                                             0
2400368 2400368 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2021   grade_7                                                   0.0                                             0
2400369 2400369 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2021   grade_7                                                   0.0                                             0
2400370 2400370 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2021   grade_7                                                   202.0                                             202
2400371 2400371 NJ Warren 41 school 3413260 4200   Pohatcong Township School District 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2021   grade_7                                                   41.0                                             41
2400372 2400372 NJ Warren 41 school 3417920 5460   Warren County Vocational Technical School 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2021   grade_7                                                   0.0                                             0
2400373 2400373 NJ Warren 41 school 3416970 5465   Warren Hills Regional School District 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400374 2400374 NJ Warren 41 school 3416970 5465   Warren Hills Regional School District 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2021   grade_7                                                   271.0                                             271
2400375 2400375 NJ Warren 41 school 3417010 5480   Washington Borough School District 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 02 06 2021   grade_7                                                   0.0                                             0
2400376 2400376 NJ Warren 41 school 3417010 5480   Washington Borough School District 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 01 2021   grade_7                                                   0.0                                             0
2400377 2400377 NJ Warren 41 school 3417160 5530   Washington Township School District 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2021   grade_7                                                   0.0                                             0
2400378 2400378 NJ Warren 41 school 3417160 5530   Washington Township School District 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2021   grade_7                                                   0.0                                             0
2400379 2400379 NJ Warren 41 school 3417910 5780   White Township Consolidated School District 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2021   grade_7                                                   27.0                                             27
2505388 2505388 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   grade_7                                                   57.0                                             57
2505389 2505389 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2505390 2505390 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   grade_7                                                   25.0                                             25
2505391 2505391 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505392 2505392 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   grade_7                                                   47.0                                             47
2505393 2505393 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2505394 2505394 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2505395 2505395 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2505396 2505396 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_7                                                   66.0                                             66
2505397 2505397 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_7                                                   0.0                                             0
2505398 2505398 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2505399 2505399 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2020   grade_7                                                   80.0                                             80
2505400 2505400 NJ Warren 41 school 3406300 1870   Hackettstown 340630005814 50 Hackettstown High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505401 2505401 NJ Warren 41 school 3406300 1870   Hackettstown 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2020   grade_7                                                   98.0                                             98
2505402 2505402 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   grade_7                                                   0.0                                             0
2505403 2505403 NJ Warren 41 school 3406300 1870   Hackettstown 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2020   grade_7                                                   0.0                                             0
2505404 2505404 NJ Warren 41 school 3406810 2040   Harmony Twp 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2020   grade_7                                                   24.0                                             24
2505405 2505405 NJ Warren 41 school 3407470 2250   Hope Twp 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2020   grade_7                                                   11.0                                             11
2505406 2505406 NJ Warren 41 school 3408070 2470   Knowlton Twp 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2505407 2505407 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2505408 2505408 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2020   grade_7                                                   95.0                                             95
2505409 2505409 NJ Warren 41 school 3409540 2970   Mansfield Twp 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2505410 2505410 NJ Warren 41 school 3409550 3675   North Warren Regional 340955005844 50 North Warren Regional School   Regular School No High 07 12 2020   grade_7                                                   115.0                                             115
2505411 2505411 NJ Warren 41 school 3412300 3890   Oxford Twp 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2020   grade_7                                                   31.0                                             31
2505412 2505412 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505413 2505413 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   grade_7                                                   0.0                                             0
2505414 2505414 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2505415 2505415 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   grade_7                                                   215.0                                             215
2505416 2505416 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   grade_7                                                   0.0                                             0
2505417 2505417 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   grade_7                                                   33.0                                             33
2505418 2505418 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_7                                                   0.0                                             0
2505419 2505419 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505420 2505420 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   grade_7                                                   285.0                                             285
2505421 2505421 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   grade_7                                                   0.0                                             0
2505422 2505422 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2505423 2505423 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   grade_7                                                   0.0                                             0
2505424 2505424 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   grade_7                                                   0.0                                             0
2505425 2505425 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   grade_7                                                   32.0                                             32
2400171 2400171 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005436 30 Columbia Middle School   Regular School No Middle 06 08 2021   grade_7                                                   162.0                                             162
2400172 2400172 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2021   grade_7                                                   0.0                                             0
2400173 2400173 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005442 50 William Woodruff School   Regular School No Elementary 02 05 2021   grade_7                                                   0.0                                             0
2400174 2400174 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2021   grade_7                                                   0.0                                             0
2400175 2400175 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005440 40 Mountain Park School   Regular School No Elementary 02 05 2021   grade_7                                                   0.0                                             0
2400176 2400176 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400177 2400177 NJ Union 39 school 3403150 850   Clark Township Public School District 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400178 2400178 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005454 40 Valley Road School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2400179 2400179 NJ Union 39 school 3403150 850   Clark Township Public School District 340315003295 300 Clark Preschool Annex   Special Education School No Prekindergarten PK PK 2021   grade_7                                                   0.0                                             0
2400180 2400180 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005452 35 Carl H. Kumpf School   Regular School No Middle 06 08 2021   grade_7                                                   188.0                                             188
2400181 2400181 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005450 30 Frank K. Hehnly   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2400182 2400182 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400183 2400183 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2400184 2400184 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_7                                                   0.0                                             0
2400185 2400185 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_7                                                   0.0                                             0
2400186 2400186 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_7                                                   129.0                                             129
2400187 2400187 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_7                                                   0.0                                             0
2400188 2400188 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_7                                                   153.0                                             153
2400189 2400189 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005478 25 Elizabeth High School - Frank J Cicarell Academy   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2400190 2400190 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005494 100 Winfield Scott School No. 2   Regular School No Elementary PK 08 2021   grade_7                                                   49.0                                             49
2400191 2400191 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005526 260 Nicholas Murray Butler Academy School No. 23   Regular School No Elementary KG 08 2021   grade_7                                                   74.0                                             74
2400192 2400192 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000806 295 Dr. Albert Einstein Academy School No. 29   Regular School No Elementary PK 08 2021   grade_7                                                   68.0                                             68
2400193 2400193 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459002983 315 Juan Pablo Duarte - Jose Julian Marti School No 28   Regular School No Elementary PK 08 2021   grade_7                                                   87.0                                             87
2400194 2400194 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005520 230 John Marshal School No. 20   Regular School No Elementary KG 08 2021   grade_7                                                   36.0                                             36

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