enrollments

Data source: Big Local News · About: Big Local

991 rows where grade = "pk_12_total" and state = "NH" sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pk_12_total · 991 ✖
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
353644 353644 NH     school   357   Milford     Milford Early Education Experiences             2021   pk_12_total                                                   36                                             36
355208 355208 NH     school   453   Raymond     Raymond School District Preschool Program             2021   pk_12_total                                                   38                                             38
268732 268732 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   pk_12_total                                                   425.0                                             425
351604 351604 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School Public School Regular School No Elementary PK 04 2021   pk_12_total                                                   351                                             351
354426 354426 NH     school 3303316 716   Northeast Woodland Chartered Public School 330331600741 29231 Northeast Woodland Chartered Public School Charter Schools approved by the state Regular School Yes Elementary PK 07 2021   pk_12_total                                                   144                                             144
268865 268865 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   87.0                                             87
355497 355497 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   80                                             80
268941 268941 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H) Public Charter Schools Regular School Yes Secondary 09 09 2020   pk_12_total                                                   7.0                                             7
349870 349870 NH     school 3303301 743   Compass Classical Academy Charter School 330330100739 29224 Compass Classical Academy Charter School (H)   Regular School Yes Secondary 09 10 2021   pk_12_total                                                   12                                             12
268964 268964 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Public Charter Schools Regular School Yes Secondary 09 09 2020   pk_12_total                                                   26.0                                             26
355905 355905 NH     school 3303315 714   Spark Academy of Advanced Technologies 330331500736 29221 Spark Academy of Advanced Technologies Charter School Charter Schools approved by the state Regular School Yes Secondary 09 10 2021   pk_12_total                                                   34                                             34
268819 268819 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   34.0                                             34
354596 354596 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   25                                             25
268880 268880 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   pk_12_total                                                   368.0                                             368
353236 353236 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School Public School Regular School No Elementary 03 05 2021   pk_12_total                                                   321                                             321
268879 268879 NH     school 3306240 491   Somersworth 330624000732 29202 Idlehurst Elementary School   Regular School No Elementary PK 02 2020   pk_12_total                                                   357.0                                             357
351961 351961 NH     school 3306240 491   Somersworth 330624000732 29202 Idlehurst Elementary School Public School Regular School No Elementary PK 02 2021   pk_12_total                                                   282                                             282
268652 268652 NH     school 3303960 269   Inter-Lakes Cooperative 330396000731 29201 Inter-Lakes Middle School   Regular School No Middle 07 08 2020   pk_12_total                                                   165.0                                             165
352029 352029 NH     school 3303960 269   Inter-Lakes Cooperative 330396000731 29201 Inter-Lakes Middle School Public School Regular School No Middle 07 08 2021   pk_12_total                                                   156                                             156
268650 268650 NH     school 3303960 269   Inter-Lakes Cooperative 330396000734 29200 Inter-Lakes Elementary School   Regular School No Elementary PK 06 2020   pk_12_total                                                   470.0                                             470
351995 351995 NH     school 3303960 269   Inter-Lakes Cooperative 330396000734 29200 Inter-Lakes Elementary School Public School Regular School No Elementary PK 06 2021   pk_12_total                                                   411                                             411
268934 268934 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate Schools           2020   pk_12_total                                                   56.0                                             56
355327 355327 NH     school   457   Rivendell   29197 Rivendell Academy (H) Interstate School           2021   pk_12_total                                                   51                                             51
268933 268933 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate Schools           2020   pk_12_total                                                   18.0                                             18
355310 355310 NH     school   457   Rivendell   29196 Rivendell Academy (E) Interstate School           2021   pk_12_total                                                   25                                             25
268938 268938 NH     school 3303313 710   Capital City Public Charter School 330331300728 29195 Capital City Public Charter School (H) Public Charter Schools Regular School Yes Secondary 09 11 2020   pk_12_total                                                   20.0                                             20
268937 268937 NH     school 3303313 710   Capital City Public Charter School 330331300729 29194 Capital City Public Charter School (E) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   22.0                                             22
268972 268972 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Public Charter Schools Regular School Yes Elementary KG 04 2020   pk_12_total                                                   167.0                                             167
356857 356857 NH     school 3303314 712   Windham Academy Public Charter School 330331400730 29193 Windham Academy Public Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   pk_12_total                                                   245                                             245
268947 268947 NH     school 3303308 708   Kreiva Academy Public Charter School District 330330800727 29192 Kreiva Academy Public Charter School (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   44.0                                             44
352488 352488 NH     school 3303308 708   Kreiva Academy Public Charter School District 330330800727 29192 Kreiva Academy Public Charter School (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   72                                             72
268948 268948 NH     school 3303308 708   Kreiva Academy Public Charter School District 330330800726 29191 Kreiva Academy Public Charter School (M) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   77.0                                             77
352505 352505 NH     school 3303308 708   Kreiva Academy Public Charter School District 330330800726 29191 Kreiva Academy Public Charter School (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pk_12_total                                                   70                                             70
268949 268949 NH     school 3303305 706   LEAF Charter School 330330500722 29189 LEAF Charter School Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   69.0                                             69
352522 352522 NH     school 3303305 706   LEAF Charter School 330330500722 29189 LEAF Charter School Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   71                                             71
268514 268514 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   64.0                                             64
349751 349751 NH     school 3302340 101   Claremont 330234000724 29184 Claremont Preschool Center Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   51                                             51
268669 268669 NH     school 3304050 279   Keene 330405000723 29180 Jonathan Daniels School   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   114.0                                             114
352267 352267 NH     school 3304050 279   Keene 330405000723 29180 Jonathan Daniels School Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   63                                             63
268752 268752 NH     school 3304770 353   Middleton 330477000725 29178 Middleton Elementary School   Regular School No Elementary PK 06 2020   pk_12_total                                                   142.0                                             142
353593 353593 NH     school 3304770 353   Middleton 330477000725 29178 Middleton Elementary School Public School Regular School No Elementary PK 06 2021   pk_12_total                                                   144                                             144
268686 268686 NH     school 3303303 299   Lempster 330330300719 29169 Lempster Community School   Regular School No Elementary KG 08 2020   pk_12_total                                                   104.0                                             104
352709 352709 NH     school 3303303 299   Lempster 330330300719 29169 Lempster Community School Public School Regular School No Elementary KG 08 2021   pk_12_total                                                   108                                             108
268954 268954 NH     school 3303302 744   MicroSociety Academy Charter School Foundation 330330200721 29167 MicroSociety Academy Charter School Foundation Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   230.0                                             230
353559 353559 NH     school 3303302 744   MicroSociety Academy Charter School Foundation 330330200721 29167 MicroSociety Academy Charter School Foundation Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   241                                             241
268940 268940 NH     school 3303301 743   Compass Classical Academy Charter School 330330100718 29166 Compass Classical Academy Charter School (E) Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   127.0                                             127
349853 349853 NH     school 3303301 743   Compass Classical Academy Charter School 330330100718 29166 Compass Classical Academy Charter School (E) Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   139                                             139
268951 268951 NH     school 3303289 733   Making Community Connections Charter School 330328900720 29160 Making Community Connections Charter School - Monadnock Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   76.0                                             76
353083 353083 NH     school 3303289 733   Making Community Connections Charter School 330328900720 29160 Making Community Connections Charter School - Monadnock Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   54                                             54
268546 268546 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program   Regular School No Elementary PK KG 2020   pk_12_total                                                   124.0                                             124
350142 350142 NH     school 3302610 131   Derry Cooperative 330261000716 29156 Derry Early Education Program Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   74                                             74
268956 268956 NH     school 3303297 704   Mountain Village Charter School 330329700715 29154 Mountain Village Charter School Public Charter Schools Regular School Yes Elementary 01 08 2020   pk_12_total                                                   103.0                                             103
353916 353916 NH     school 3303297 704   Mountain Village Charter School 330329700715 29154 Mountain Village Charter School Charter Schools approved by the state Regular School Yes Elementary 01 08 2021   pk_12_total                                                   96                                             96
268944 268944 NH     school 3303296 702   Granite State Arts Academy Charter School 330329600711 29153 Granite State Arts Academy Charter School Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   113.0                                             113
351111 351111 NH     school 3303296 702   Granite State Arts Academy Charter School 330329600711 29153 Granite State Arts Academy Charter School Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   114                                             114
268787 268787 NH     school 3304980 371   Nashua 330498000714 29152 Nashua Title I Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   46.0                                             46
354052 354052 NH     school 3304980 371   Nashua 330498000714 29152 Nashua Title I Preschool Public School Regular School No Prekindergarten PK PK 2021   pk_12_total                                                   34                                             34
268943 268943 NH     school 3303299 742   Gate City Charter School For the Arts 330329900712 29151 Gate City Charter School for the Arts Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   164.0                                             164
350873 350873 NH     school 3303299 742   Gate City Charter School For the Arts 330329900712 29151 Gate City Charter School for the Arts Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   140                                             140
268968 268968 NH     school 3303298 741   The Founders Academy Charter School 330329800713 29150 The Founders Academy Charter School (E) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   238.0                                             238
356228 356228 NH     school 3303298 741   The Founders Academy Charter School 330329800713 29150 The Founders Academy Charter School (E) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pk_12_total                                                   236                                             236
268969 268969 NH     school 3303298 741   The Founders Academy Charter School 330329800717 29149 The Founders Academy Charter School (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   127.0                                             127
356245 356245 NH     school 3303298 741   The Founders Academy Charter School 330329800717 29149 The Founders Academy Charter School (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   133                                             133
268957 268957 NH     school 3303291 740   Next Charter School 330329100707 29105 Next Charter School Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   75.0                                             75
354324 354324 NH     school 3303291 740   Next Charter School 330329100707 29105 Next Charter School Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   75                                             75
268953 268953 NH     school 3303289 733   Making Community Connections Charter School 330328900710 29100 Making Community Connections Charter School (M) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   21.0                                             21
353066 353066 NH     school 3303289 733   Making Community Connections Charter School 330328900710 29100 Making Community Connections Charter School (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pk_12_total                                                   16                                             16
268719 268719 NH     school 3304590 335   Manchester 330459000708 29085 Manchester School of Technology (High School)   Regular School No High 09 12 2020   pk_12_total                                                   388.0                                             388
353134 353134 NH     school 3304590 335   Manchester 330459000708 29085 Manchester School of Technology (High School) Public School Regular School No High 09 12 2021   pk_12_total                                                   383                                             383
268850 268850 NH     school 3305940 461   Rochester 330594000709 29080 Maple Street Magnet School   Regular School No Elementary KG 05 2020   pk_12_total                                                   114.0                                             114
353219 353219 NH     school 3305940 461   Rochester 330594000709 29080 Maple Street Magnet School Public School Regular School No Elementary KG 05 2021   pk_12_total                                                   111                                             111
268962 268962 NH     school 3303287 737   Robert Frost Charter School 330328700703 29070 Robert Frost Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   52.0                                             52
355344 355344 NH     school 3303287 737   Robert Frost Charter School 330328700703 29070 Robert Frost Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   40                                             40
268961 268961 NH     school 3303290 735   Polaris Charter School 330329000706 29065 Polaris Charter School Public Charter Schools Regular School Yes Elementary 01 06 2020   pk_12_total                                                   109.0                                             109
355072 355072 NH     school 3303290 735   Polaris Charter School 330329000706 29065 Polaris Charter School Charter Schools approved by the state Regular School Yes Elementary KG 05 2021   pk_12_total                                                   109                                             109
268952 268952 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   40.0                                             40
353049 353049 NH     school 3303289 733   Making Community Connections Charter School 330328900705 29060 Making Community Connections Charter School (H) Charter Schools approved by the state Regular School Yes Secondary 09 11 2021   pk_12_total                                                   36                                             36
268967 268967 NH     school 3303286 731   The Birches Academy of Academics & Art A Public Charter Sch 330328600704 29055 The Birches Academy of Academics - Art A Public Charter Sch Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   225.0                                             225
356211 356211 NH     school 3303286 731   The Birches Academy of Academics & Art A Public Charter Sch 330328600704 29055 The Birches Academy of Academics - Art A Public Charter Sch Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   225                                             225
268955 268955 NH     school 3303280 729   Mill Falls Charter School 330328000699 29040 Mill Falls Charter School Public Charter Schools Regular School Yes Elementary KG 06 2020   pk_12_total                                                   168.0                                             168
353712 353712 NH     school 3303280 729   Mill Falls Charter School 330328000699 29040 Mill Falls Charter School Charter Schools approved by the state Regular School Yes Elementary KG 06 2021   pk_12_total                                                   168                                             168
268960 268960 NH     school 3303292 728   PACE Career Academy Charter School 330329200701 29035 PACE Career Academy Charter School Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   57.0                                             57
354613 354613 NH     school 3303292 728   PACE Career Academy Charter School 330329200701 29035 PACE Career Academy Charter School Charter Schools approved by local district Regular School Yes High 09 13 2021   pk_12_total                                                   62                                             62
268488 268488 NH     school 3301650 33   Barrington 330165000700 29010 Early Childhood Learning Center   Regular School No Elementary PK KG 2020   pk_12_total                                                   141.0                                             141
350329 350329 NH     school 3301650 33   Barrington 330165000700 29010 Early Childhood Learning Center Public School Regular School No Elementary PK KG 2021   pk_12_total                                                   140                                             140
268970 268970 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100693 28650 Virtual Learning Academy (E) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   51.0                                             51
356449 356449 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100693 28650 Virtual Learning Academy (E) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pk_12_total                                                   99                                             99
268922 268922 NH     school 3307170 575   Windham 330717000692 28640 Windham High School   Regular School No High 09 13 2020   pk_12_total                                                   986.0                                             986
356891 356891 NH     school 3307170 575   Windham 330717000692 28640 Windham High School Public School Regular School No High 09 12 2021   pk_12_total                                                   1020                                             1020
268946 268946 NH     school 3300048 709   Great Bay Charter School 330004800688 28620 Great Bay Charter School (M) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   40.0                                             40
351162 351162 NH     school 3300048 709   Great Bay Charter School 330004800688 28620 Great Bay Charter School (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pk_12_total                                                   45                                             45
268935 268935 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   226.0                                             226
348680 348680 NH     school 3300040 725   Academy for Science and Design Charter School 330004000684 28615 Academy for Science and Design Charter (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   222                                             222
268790 268790 NH     school 3304980 371   Nashua 330498000682 28610 Purple Panthers Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   35.0                                             35
268971 268971 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100679 28605 Virtual Learning Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   298.0                                             298
356466 356466 NH     school 3303271 727   Virtual Learning Academy Charter School 330327100679 28605 Virtual Learning Academy (H) Charter Schools approved by the state Regular School Yes High 09 12 2021   pk_12_total                                                   379                                             379
268936 268936 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Public Charter Schools Regular School Yes Middle 06 08 2020   pk_12_total                                                   309.0                                             309
348697 348697 NH     school 3300040 725   Academy for Science and Design Charter School 330004000678 28580 Academy for Science and Design Charter (M) Charter Schools approved by the state Regular School Yes Middle 06 08 2021   pk_12_total                                                   319                                             319
268942 268942 NH     school 3300041 723   CSI Charter School 330004100677 28575 CSI Charter School Public Charter Schools Regular School Yes High 11 12 2020   pk_12_total                                                   32.0                                             32
349462 349462 NH     school 3300041 723   CSI Charter School 330004100677 28575 CSI Charter School Charter Schools approved by the state Regular School Yes High 11 12 2021   pk_12_total                                                   28                                             28

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