enrollments

Data source: Big Local News · About: Big Local

8,432 rows where state = "NH" and year = 2020 sorted by school_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 8,432 ✖
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
260796 260796 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten                                                   19.0                                             19
261292 261292 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   kindergarten                                                   72.0                                             72
261788 261788 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   readiness                                                   14.0                                             14
262284 262284 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   88.0                                             88
262780 262780 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_2                                                   72.0                                             72
263276 263276 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_3                                                   82.0                                             82
263772 263772 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_4                                                   78.0                                             78
264268 264268 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
264764 264764 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
265260 265260 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
265756 265756 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
266252 266252 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_9                                                   0.0                                             0
266748 266748 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_10                                                   0.0                                             0
267244 267244 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_11                                                   0.0                                             0
267740 267740 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   grade_12                                                   0.0                                             0
268236 268236 NH     school 3304670 342   Mascenic Regional 330467000697 90393 Highbridge Hill Elementary School   Regular School No Elementary PK 04 2020   post_graduate                                                   0.0                                             0
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
260929 260929 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   87.0                                             87
261425 261425 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   0.0                                             0
261921 261921 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   readiness                                                   0.0                                             0
262417 262417 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_1                                                   0.0                                             0
262913 262913 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_2                                                   0.0                                             0
263409 263409 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_3                                                   0.0                                             0
263905 263905 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_4                                                   0.0                                             0
264401 264401 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
264897 264897 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
265393 265393 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265889 265889 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_8                                                   0.0                                             0
266385 266385 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_9                                                   0.0                                             0
266881 266881 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_10                                                   0.0                                             0
267377 267377 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_11                                                   0.0                                             0
267873 267873 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
268369 268369 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   post_graduate                                                   0.0                                             0
268865 268865 NH     school 3306060 473   Salem 330606000740 29225 Salem Preschool   Regular School No Prekindergarten PK PK 2020   pk_12_total                                                   87.0                                             87
261005 261005 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   pre_kindergarten                                                   0.0                                             0
261501 261501 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   kindergarten                                                   0.0                                             0
261997 261997 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   readiness                                                   0.0                                             0
262493 262493 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   grade_1                                                   0.0                                             0
262989 262989 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   grade_2                                                   0.0                                             0
263485 263485 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   grade_3                                                   0.0                                             0
263981 263981 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   grade_4                                                   0.0                                             0
264477 264477 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   grade_5                                                   0.0                                             0
264973 264973 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   grade_6                                                   0.0                                             0
265469 265469 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   grade_7                                                   0.0                                             0
265965 265965 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   grade_8                                                   0.0                                             0
266461 266461 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   grade_9                                                   7.0                                             7
266957 266957 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   grade_10                                                   0.0                                             0
267453 267453 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   grade_11                                                   0.0                                             0
267949 267949 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   grade_12                                                   0.0                                             0
268445 268445 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   post_graduate                                                   0.0                                             0
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
261028 261028 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   pre_kindergarten                                                   0.0                                             0
261524 261524 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   kindergarten                                                   0.0                                             0
262020 262020 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   readiness                                                   0.0                                             0
262516 262516 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   grade_1                                                   0.0                                             0
263012 263012 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   grade_2                                                   0.0                                             0
263508 263508 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   grade_3                                                   0.0                                             0
264004 264004 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   grade_4                                                   0.0                                             0
264500 264500 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   grade_5                                                   0.0                                             0
264996 264996 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   grade_6                                                   0.0                                             0
265492 265492 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   grade_7                                                   0.0                                             0
265988 265988 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   grade_8                                                   0.0                                             0
266484 266484 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   grade_9                                                   26.0                                             26
266980 266980 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   grade_10                                                   0.0                                             0
267476 267476 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   grade_11                                                   0.0                                             0
267972 267972 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   grade_12                                                   0.0                                             0
268468 268468 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   post_graduate                                                   0.0                                             0
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
260883 260883 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   pre_kindergarten                                                   34.0                                             34
261379 261379 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   kindergarten                                                   0.0                                             0
261875 261875 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   readiness                                                   0.0                                             0
262371 262371 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_1                                                   0.0                                             0
262867 262867 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_2                                                   0.0                                             0
263363 263363 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_3                                                   0.0                                             0
263859 263859 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_4                                                   0.0                                             0
264355 264355 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
264851 264851 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
265347 265347 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
265843 265843 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_8                                                   0.0                                             0
266339 266339 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_9                                                   0.0                                             0
266835 266835 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_10                                                   0.0                                             0
267331 267331 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_11                                                   0.0                                             0
267827 267827 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
268323 268323 NH     school 3305520 423   Oyster River Coop 330552000735 29210 Oyster River Preschool Education Program   Regular School No Prekindergarten PK PK 2020   post_graduate                                                   0.0                                             0
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
260944 260944 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten                                                   0.0                                             0
261440 261440 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   kindergarten                                                   0.0                                             0
261936 261936 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   readiness                                                   0.0                                             0
262432 262432 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_1                                                   0.0                                             0
262928 262928 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_2                                                   0.0                                             0
263424 263424 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_3                                                   125.0                                             125
263920 263920 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_4                                                   118.0                                             118
264416 264416 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_5                                                   125.0                                             125
264912 264912 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_6                                                   0.0                                             0
265408 265408 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
265904 265904 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_8                                                   0.0                                             0
266400 266400 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_9                                                   0.0                                             0
266896 266896 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_10                                                   0.0                                             0
267392 267392 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_11                                                   0.0                                             0
267888 267888 NH     school 3306240 491   Somersworth 330624000733 29203 Maple Wood Elementary School   Regular School No Elementary 03 05 2020   grade_12                                                   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]);