Data source: Big Local News · About: Big Local

45,090 rows where state = "NJ" and year = 2021 sorted by school

View and edit SQL

grade

year

  • 2021 · 44,990
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
2395218 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_5                                                   0.0                                             0
2397723 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_6                                                   0.0                                             0
2400228 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_7                                                   0.0                                             0
2402733 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_8                                                   0.0                                             0
2405238 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_9                                                   0.0                                             0
2407743 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_10                                                   0.0                                             0
2410248 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_11                                                   0.0                                             0
2412753 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   grade_12                                                   0.0                                             0
2369546 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   pk_12_total 250.0 6.0 100.0 1.0   11.0 1.0       5.0             8.8   0.0     22.4     374.0 250 6 100 1   11 1       5                       374
2372051 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   pre_kindergarten_full_day                                                   14.0                                             14
2374556 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   pre_kindergarten_half_day                                                   3.0                                             3
2377061 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   kindergarten_full_day                                                   70.0                                             70
2379566 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   kindergarten_half_day                                                   0.0                                             0
2382071 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   ungraded                                                   6.0                                             6
2384576 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_1                                                   69.0                                             69
2387081 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_2                                                   71.0                                             71
2389586 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_3                                                   70.0                                             70
2392091 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_4                                                   71.0                                             71
2394596 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_5                                                   0.0                                             0
2397101 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_6                                                   0.0                                             0
2399606 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2402111 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_8                                                   0.0                                             0
2404616 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2407121 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_10                                                   0.0                                             0
2409626 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_11                                                   0.0                                             0
2412131 NJ Morris 27 school 3402520 630   Butler Public School District 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2021   grade_12                                                   0.0                                             0
2368767 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   pk_12_total 11.0 63.0 783.0 1.0   16.0 5.0       0.0             23.9   1.4     81.3     879.0 11 63 783 1   16 5       0                       879
2371272 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2373777 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   14.0                                             14
2376282 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   kindergarten_full_day                                                   93.0                                             93
2378787 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2381292 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   ungraded                                                   28.0                                             28
2383797 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_1                                                   91.0                                             91
2386302 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_2                                                   89.0                                             89
2388807 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_3                                                   92.0                                             92
2391312 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_4                                                   91.0                                             91
2393817 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_5                                                   91.0                                             91
2396322 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_6                                                   102.0                                             102
2398827 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_7                                                   97.0                                             97
2401332 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_8                                                   91.0                                             91
2403837 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2406342 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_10                                                   0.0                                             0
2408847 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_11                                                   0.0                                             0
2411352 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2021   grade_12                                                   0.0                                             0
2370214 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   pk_12_total 17.0 400.0 340.5 2.0   8.5 1.0       5.0             9.3   0.6     61.9     774.0 17 400 340 2   8 1       5                       774
2372719 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375224 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377729 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2380234 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2382739 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   ungraded                                                   30.5                                             30
2385244 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2387749 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_2                                                   0.0                                             0
2390254 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
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
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
2397769 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2400274 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
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
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
2407789 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_10                                                   195.5                                             195
2410294 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_11                                                   145.0                                             145
2412799 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2021   grade_12                                                   197.0                                             197
2368253 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   pk_12_total 254.0 2.0 23.0 0.0   12.0 0.0       13.0             1.0   0.0     0.0     304.0 254 2 23 0   12 0       13                       304
2370758 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2373263 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375768 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   45.0                                             45
2378273 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380778 NJ Bergen 3 school 3418360 5920   Wyckoff Township Public School District 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2021   ungraded                                                   0.0                                             0
2383283 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_1                                                   64.0                                             64
2385788 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_2                                                   45.0                                             45
2388293 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_3                                                   48.0                                             48
2390798 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_4                                                   60.0                                             60
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
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
2398313 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_7                                                   0.0                                             0
2400818 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_8                                                   0.0                                             0
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
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
2408333 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_11                                                   0.0                                             0
2410838 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_12                                                   0.0                                             0
2368060 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   pk_12_total 64.0 26.0 271.0 1.0   0.0 1.0       2.0             11.0   0.8     54.5     365.0 64 26 271 1   0 1       2                       365
2370565 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2373070 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   pre_kindergarten_half_day                                                   36.0                                             36
2375575 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   kindergarten_full_day                                                   53.0                                             53
2378080 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380585 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   ungraded                                                   43.0                                             43
2383090 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_1                                                   57.0                                             57
2385595 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_2                                                   51.0                                             51
2388100 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_3                                                   40.0                                             40
2390605 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_4                                                   42.0                                             42
2393110 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_5                                                   43.0                                             43
2395615 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_6                                                   0.0                                             0
2398120 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2400625 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_8                                                   0.0                                             0
2403130 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_9                                                   0.0                                             0
2405635 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_10                                                   0.0                                             0
2408140 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_11                                                   0.0                                             0
2410645 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_12                                                   0.0                                             0
2370152 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   pk_12_total 70.0 97.0 670.0 0.0   20.0 2.0       1.0             28.4   0.0     76.2     860.0 70 97 670 0   20 2       1                       860
2372657 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   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]);