enrollments

Data source: Big Local News · About: Big Local

16,847 rows where state = "NH" sorted by school_nces_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

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
349957 349957 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   pre_kindergarten                                                   0                                             0
349958 349958 NH     school 3300017 172   Exeter Region Cooperative 330001700107 20590 Cooperative Middle School Public School Regular School No Middle 06 08 2021   readiness                                                   0                                             0
261022 261022 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   pre_kindergarten                                                   0.0                                             0
261518 261518 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   kindergarten                                                   0.0                                             0
262014 262014 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   readiness                                                   0.0                                             0
262510 262510 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
263006 263006 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_2                                                   0.0                                             0
263502 263502 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
263998 263998 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
264494 264494 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_5                                                   0.0                                             0
264990 264990 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_6                                                   0.0                                             0
265486 265486 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
265982 265982 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_8                                                   0.0                                             0
266478 266478 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_9                                                   1.0                                             1
266974 266974 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_10                                                   12.0                                             12
267470 267470 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_11                                                   26.0                                             26
267966 267966 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   grade_12                                                   14.0                                             14
268462 268462 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   post_graduate                                                   0.0                                             0
268958 268958 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Public Charter Schools Regular School Yes High 09 12 2020   pk_12_total                                                   53.0                                             53
354328 354328 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_1                                                   0                                             0
354329 354329 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_10                                                   5                                             5
354330 354330 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_11                                                   16                                             16
354331 354331 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_12                                                   26                                             26
354332 354332 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_2                                                   0                                             0
354333 354333 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_3                                                   0                                             0
354334 354334 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_4                                                   0                                             0
354335 354335 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_5                                                   0                                             0
354336 354336 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_6                                                   0                                             0
354337 354337 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_7                                                   0                                             0
354338 354338 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_8                                                   0                                             0
354339 354339 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   grade_9                                                   0                                             0
354340 354340 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   kindergarten                                                   0                                             0
354341 354341 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   pk_12_total                                                   47                                             47
354342 354342 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   post_graduate                                                   0                                             0
354343 354343 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   pre_kindergarten                                                   0                                             0
354344 354344 NH     school 3300030 703   North Country Charter Academy 330003000605 28395 North Country Charter Academy (H) Charter Schools approved by the state Regular School Yes High 10 12 2021   readiness                                                   0                                             0
261023 261023 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   pre_kindergarten                                                   0.0                                             0
261519 261519 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   kindergarten                                                   0.0                                             0
262015 262015 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   readiness                                                   0.0                                             0
262511 262511 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_1                                                   0.0                                             0
263007 263007 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_2                                                   0.0                                             0
263503 263503 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_3                                                   0.0                                             0
263999 263999 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_4                                                   0.0                                             0
264495 264495 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_5                                                   0.0                                             0
264991 264991 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_6                                                   0.0                                             0
265487 265487 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_7                                                   0.0                                             0
265983 265983 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_8                                                   1.0                                             1
266479 266479 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_9                                                   0.0                                             0
266975 266975 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_10                                                   0.0                                             0
267471 267471 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_11                                                   0.0                                             0
267967 267967 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   grade_12                                                   0.0                                             0
268463 268463 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   post_graduate                                                   0.0                                             0
268959 268959 NH     school 3300030 703   North Country Charter Academy 330003000613 28505 North Country Charter Academy (M) Public Charter Schools Regular School Yes Middle 08 08 2020   pk_12_total                                                   1.0                                             1
261027 261027 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   pre_kindergarten                                                   0.0                                             0
261523 261523 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   kindergarten                                                   38.0                                             38
262019 262019 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   readiness                                                   0.0                                             0
262515 262515 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_1                                                   34.0                                             34
263011 263011 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_2                                                   31.0                                             31
263507 263507 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_3                                                   32.0                                             32
264003 264003 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_4                                                   31.0                                             31
264499 264499 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_5                                                   33.0                                             33
264995 264995 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_6                                                   32.0                                             32
265491 265491 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_7                                                   33.0                                             33
265987 265987 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_8                                                   33.0                                             33
266483 266483 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
266979 266979 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_10                                                   0.0                                             0
267475 267475 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_11                                                   0.0                                             0
267971 267971 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   grade_12                                                   0.0                                             0
268467 268467 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   post_graduate                                                   0.0                                             0
268963 268963 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Public Charter Schools Regular School Yes Elementary KG 08 2020   pk_12_total                                                   297.0                                             297
355688 355688 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_1                                                   35                                             35
355689 355689 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_10                                                   0                                             0
355690 355690 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_11                                                   0                                             0
355691 355691 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_12                                                   0                                             0
355692 355692 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_2                                                   33                                             33
355693 355693 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_3                                                   31                                             31
355694 355694 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_4                                                   33                                             33
355695 355695 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_5                                                   33                                             33
355696 355696 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_6                                                   32                                             32
355697 355697 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_7                                                   36                                             36
355698 355698 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_8                                                   33                                             33
355699 355699 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   grade_9                                                   0                                             0
355700 355700 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   kindergarten                                                   30                                             30
355701 355701 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pk_12_total                                                   296                                             296
355702 355702 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   post_graduate                                                   0                                             0
355703 355703 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   pre_kindergarten                                                   0                                             0
355704 355704 NH     school 3300031 705   Seacoast Charter School 330003100606 28400 Seacoast Charter School Charter Schools approved by the state Regular School Yes Elementary KG 08 2021   readiness                                                   0                                             0
260667 260667 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   pre_kindergarten                                                   0.0                                             0
261163 261163 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   kindergarten                                                   0.0                                             0
261659 261659 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   readiness                                                   0.0                                             0
262155 262155 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
262651 262651 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_2                                                   0.0                                             0
263147 263147 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_3                                                   0.0                                             0
263643 263643 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
264139 264139 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
264635 264635 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_6                                                   27.0                                             27
265131 265131 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_7                                                   39.0                                             39
265627 265627 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_8                                                   33.0                                             33
266123 266123 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_9                                                   0.0                                             0
266619 266619 NH     school 3300035 203   Gorham Randolph Shelburne Cooperative 330003500047 27005 Gorham Middle School   Regular School No Middle 06 08 2020   grade_10                                                   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]);