enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
2408086 2408086 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360000328 60 Merritt Memorial   Regular School No Elementary KG 05 2021   grade_11                                                   0.0                                             0
2408087 2408087 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2021   grade_11                                                   0.0                                             0
2408088 2408088 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360000324 40 Cresskill High School   Regular School No High 09 12 2021   grade_11                                                   124.5                                             124
2408089 2408089 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360000326 50 Edward H. Bryan   Regular School No Elementary PK 05 2021   grade_11                                                   0.0                                             0
2410591 2410591 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360000328 60 Merritt Memorial   Regular School No Elementary KG 05 2021   grade_12                                                   0.0                                             0
2410592 2410592 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2021   grade_12                                                   0.0                                             0
2410593 2410593 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360000324 40 Cresskill High School   Regular School No High 09 12 2021   grade_12                                                   129.0                                             129
2410594 2410594 NJ Bergen 3 school 3403600 990   Cresskill Public School District 340360000326 50 Edward H. Bryan   Regular School No Elementary PK 05 2021   grade_12                                                   0.0                                             0
2370122 2370122 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   pk_12_total 958.0 38.5 105.0 1.0   37.0 0.0       18.0             0.1   0.0     1.7000000000000002     1157.5 958 38 105 1   37 0       18                       1157
2370123 2370123 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   pk_12_total 306.0 1.0 35.0 0.0   15.0 0.0       9.0             0.5   0.0     0.0     366.0 306 1 35 0   15 0       9                       366
2370124 2370124 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   pk_12_total 203.0 9.0 29.0 0.0   7.0 1.0       11.0             0.0   0.0     0.0     260.0 203 9 29 0   7 1       11                       260
2370125 2370125 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   pk_12_total 210.0 5.0 38.0 0.0   13.0 0.0       14.0             0.0   0.0     0.0     280.0 210 5 38 0   13 0       14                       280
2370126 2370126 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   pk_12_total 483.0 43.0 98.0 0.0   43.0 0.0       20.0             0.7   0.0     1.9     687.0 483 43 98 0   43 0       20                       687
2370127 2370127 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   pk_12_total 177.0 4.0 20.0 0.0   15.0 0.0       11.0             0.9   0.0     0.0     227.0 177 4 20 0   15 0       11                       227
2370128 2370128 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   pk_12_total 620.0 7.0 48.0 0.0   21.0 0.0       26.0             0.0   0.0     0.4     722.0 620 7 48 0   21 0       26                       722
2372627 2372627 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372628 2372628 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372629 2372629 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372630 2372630 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   pre_kindergarten_full_day                                                   40.0                                             40
2372631 2372631 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372632 2372632 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372633 2372633 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375132 2375132 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375133 2375133 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375134 2375134 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375135 2375135 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375136 2375136 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375137 2375137 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375138 2375138 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377637 2377637 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   kindergarten_full_day                                                   0.0                                             0
2377638 2377638 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   kindergarten_full_day                                                   0.0                                             0
2377639 2377639 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   kindergarten_full_day                                                   0.0                                             0
2377640 2377640 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   kindergarten_full_day                                                   0.0                                             0
2377641 2377641 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   kindergarten_full_day                                                   0.0                                             0
2377642 2377642 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   kindergarten_full_day                                                   0.0                                             0
2377643 2377643 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   kindergarten_full_day                                                   0.0                                             0
2380142 2380142 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380143 2380143 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   55.0                                             55
2380144 2380144 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   kindergarten_half_day                                                   0.0                                             0
2380145 2380145 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   kindergarten_half_day                                                   69.0                                             69
2380146 2380146 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   34.0                                             34
2380147 2380147 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   kindergarten_half_day                                                   63.0                                             63
2380148 2380148 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   kindergarten_half_day                                                   0.0                                             0
2382647 2382647 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   ungraded                                                   27.0                                             27
2382648 2382648 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   ungraded                                                   0.0                                             0
2382649 2382649 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   ungraded                                                   0.0                                             0
2382650 2382650 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   ungraded                                                   0.0                                             0
2382651 2382651 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   ungraded                                                   15.0                                             15
2382652 2382652 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   ungraded                                                   0.0                                             0
2382653 2382653 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   ungraded                                                   8.0                                             8
2385152 2385152 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2385153 2385153 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_1                                                   58.0                                             58
2385154 2385154 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_1                                                   0.0                                             0
2385155 2385155 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_1                                                   88.0                                             88
2385156 2385156 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_1                                                   53.0                                             53
2385157 2385157 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_1                                                   74.0                                             74
2385158 2385158 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_1                                                   0.0                                             0
2387657 2387657 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_2                                                   0.0                                             0
2387658 2387658 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_2                                                   60.0                                             60
2387659 2387659 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_2                                                   0.0                                             0
2387660 2387660 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_2                                                   83.0                                             83
2387661 2387661 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_2                                                   50.0                                             50
2387662 2387662 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_2                                                   90.0                                             90
2387663 2387663 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_2                                                   0.0                                             0
2390162 2390162 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2390163 2390163 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_3                                                   57.0                                             57
2390164 2390164 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_3                                                   80.0                                             80
2390165 2390165 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_3                                                   0.0                                             0
2390166 2390166 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_3                                                   46.0                                             46
2390167 2390167 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_3                                                   0.0                                             0
2390168 2390168 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_3                                                   91.0                                             91
2392667 2392667 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2392668 2392668 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_4                                                   60.0                                             60
2392669 2392669 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_4                                                   90.0                                             90
2392670 2392670 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_4                                                   0.0                                             0
2392671 2392671 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_4                                                   45.0                                             45
2392672 2392672 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_4                                                   0.0                                             0
2392673 2392673 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_4                                                   86.0                                             86
2395172 2395172 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_5                                                   0.0                                             0
2395173 2395173 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_5                                                   76.0                                             76
2395174 2395174 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_5                                                   90.0                                             90
2395175 2395175 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_5                                                   0.0                                             0
2395176 2395176 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_5                                                   48.0                                             48
2395177 2395177 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_5                                                   0.0                                             0
2395178 2395178 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_5                                                   92.0                                             92
2397677 2397677 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   grade_6                                                   0.0                                             0
2397678 2397678 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   grade_6                                                   0.0                                             0
2397679 2397679 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   grade_6                                                   0.0                                             0
2397680 2397680 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   grade_6                                                   0.0                                             0
2397681 2397681 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   grade_6                                                   137.0                                             137
2397682 2397682 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   grade_6                                                   0.0                                             0
2397683 2397683 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   grade_6                                                   144.0                                             144
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
2402687 2402687 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   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]);