enrollments

Data source: Big Local News · About: Big Local

45,036 rows where state = "NJ" and year = 2020 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 44,936 ✖
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
2513125 2513125 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000324 40 Cresskill High School   Regular School No High 09 12 2020   grade_11                                                   130.0                                             130
2513126 2513126 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2020   grade_11                                                   0.0                                             0
2513127 2513127 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000326 50 Edward H. Bryan   Regular School No Elementary PK 05 2020   grade_11                                                   0.0                                             0
2513128 2513128 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000328 60 Merritt Memorial   Regular School No Elementary KG 05 2020   grade_11                                                   0.0                                             0
2515627 2515627 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000324 40 Cresskill High School   Regular School No High 09 12 2020   grade_12                                                   127.0                                             127
2515628 2515628 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
2515629 2515629 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000326 50 Edward H. Bryan   Regular School No Elementary PK 05 2020   grade_12                                                   0.0                                             0
2515630 2515630 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000328 60 Merritt Memorial   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
2475204 2475204 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   pk_12_total 994.0 39.0 95.5 0.0   36.0 0.0       14.5             .2   0.0     2.0     1179.0 994 39 95 0   36 0       14                       1179
2475205 2475205 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   pk_12_total 503.0 45.0 86.0 0.0   39.0 0.0       21.0             .9   0.0     4.9     694.0 503 45 86 0   39 0       21                       694
2475206 2475206 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   pk_12_total 605.0 3.0 45.0 0.0   29.0 0.0       23.0             0   0.0     1.2     705.0 605 3 45 0   29 0       23                       705
2475207 2475207 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   pk_12_total 209.0 6.0 15.0 0.0   11.0 0.0       11.0             .4   0.0     0.4     252.0 209 6 15 0   11 0       11                       252
2475208 2475208 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   pk_12_total 308.0 1.0 28.0 0.0   15.0 0.0       5.0             0   0.0     0.3     357.0 308 1 28 0   15 0       5                       357
2475209 2475209 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   pk_12_total 212.0 6.0 27.0 0.0   9.0 0.0       8.0             0   0.0     2.3     262.0 212 6 27 0   9 0       8                       262
2475210 2475210 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   pk_12_total 255.0 4.0 32.0 0.0   14.0 1.0       7.0             0   0.0     0.8999999999999999     313.0 255 4 32 0   14 1       7                       313
2477706 2477706 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477707 2477707 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477708 2477708 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477709 2477709 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477710 2477710 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477711 2477711 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477712 2477712 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   49.0                                             49
2480208 2480208 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480209 2480209 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480210 2480210 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480211 2480211 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480212 2480212 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480213 2480213 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480214 2480214 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482710 2482710 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2482711 2482711 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   kindergarten_full_day                                                   0.0                                             0
2482712 2482712 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   kindergarten_full_day                                                   0.0                                             0
2482713 2482713 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   kindergarten_full_day                                                   0.0                                             0
2482714 2482714 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   kindergarten_full_day                                                   0.0                                             0
2482715 2482715 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   kindergarten_full_day                                                   0.0                                             0
2482716 2482716 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   kindergarten_full_day                                                   0.0                                             0
2485212 2485212 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485213 2485213 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   kindergarten_half_day                                                   42.0                                             42
2485214 2485214 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   kindergarten_half_day                                                   0.0                                             0
2485215 2485215 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   kindergarten_half_day                                                   78.0                                             78
2485216 2485216 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   41.0                                             41
2485217 2485217 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   kindergarten_half_day                                                   0.0                                             0
2485218 2485218 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   kindergarten_half_day                                                   93.0                                             93
2487714 2487714 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   ungraded                                                   25.5                                             25
2487715 2487715 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   ungraded                                                   21.0                                             21
2487716 2487716 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   ungraded                                                   7.0                                             7
2487717 2487717 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   ungraded                                                   0.0                                             0
2487718 2487718 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   ungraded                                                   0.0                                             0
2487719 2487719 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   ungraded                                                   1.0                                             1
2487720 2487720 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   ungraded                                                   0.0                                             0
2490216 2490216 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2490217 2490217 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_1                                                   50.0                                             50
2490218 2490218 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_1                                                   0.0                                             0
2490219 2490219 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_1                                                   88.0                                             88
2490220 2490220 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_1                                                   63.0                                             63
2490221 2490221 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_1                                                   0.0                                             0
2490222 2490222 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_1                                                   83.0                                             83
2492718 2492718 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_2                                                   0.0                                             0
2492719 2492719 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_2                                                   44.0                                             44
2492720 2492720 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_2                                                   0.0                                             0
2492721 2492721 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_2                                                   86.0                                             86
2492722 2492722 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_2                                                   58.0                                             58
2492723 2492723 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_2                                                   0.0                                             0
2492724 2492724 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_2                                                   88.0                                             88
2495220 2495220 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
2495221 2495221 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_3                                                   41.0                                             41
2495222 2495222 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_3                                                   85.0                                             85
2495223 2495223 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_3                                                   0.0                                             0
2495224 2495224 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_3                                                   58.0                                             58
2495225 2495225 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_3                                                   90.0                                             90
2495226 2495226 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_3                                                   0.0                                             0
2497722 2497722 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2497723 2497723 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_4                                                   48.0                                             48
2497724 2497724 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_4                                                   89.0                                             89
2497725 2497725 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_4                                                   0.0                                             0
2497726 2497726 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_4                                                   75.0                                             75
2497727 2497727 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_4                                                   87.0                                             87
2497728 2497728 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
2500224 2500224 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500225 2500225 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_5                                                   59.0                                             59
2500226 2500226 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_5                                                   82.0                                             82
2500227 2500227 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_5                                                   0.0                                             0
2500228 2500228 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_5                                                   62.0                                             62
2500229 2500229 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_5                                                   84.0                                             84
2500230 2500230 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2502726 2502726 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502727 2502727 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_6                                                   124.0                                             124
2502728 2502728 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_6                                                   149.0                                             149
2502729 2502729 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_6                                                   0.0                                             0
2502730 2502730 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2502731 2502731 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_6                                                   0.0                                             0
2502732 2502732 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2505228 2505228 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505229 2505229 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_7                                                   134.0                                             134
2505230 2505230 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_7                                                   148.0                                             148
2505231 2505231 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_7                                                   0.0                                             0
2505232 2505232 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2505233 2505233 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2505234 2505234 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2507730 2507730 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_8                                                   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]);