Data source: Big Local News · About: Big Local

5,007 rows where grade = "grade_9" and state = "NJ" sorted by district_nces_id

View and edit SQL

year

grade

  • grade_9 · 5,007
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
2404617 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_9                                                   293.0                                             293
2404618 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_9                                                   0.0                                             0
2404619 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2404620 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2021   grade_9                                                   0.0                                             0
2404621 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2404622 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2509657 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2020   grade_9                                                   339.0                                             339
2509658 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2020   grade_9                                                   0.0                                             0
2509659 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_9                                                   0.0                                             0
2509660 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_9                                                   0.0                                             0
2509661 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_9                                                   0.0                                             0
2509662 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2020   grade_9                                                   0.0                                             0
2405255 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   grade_9                                                   0.0                                             0
2405256 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   grade_9                                                   0.0                                             0
2510295 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2020   grade_9                                                   0.0                                             0
2510296 NJ Union 39 school 3400005 3395   Morris-Union Jointure Com 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2020   grade_9                                                   2.0                                             2
2402986 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2021   grade_9                                                   1.0                                             1
2402987 NJ Atlantic 1 school 3400006 125   Atlantic County Special Services School District 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2508031 NJ Atlantic 1 school 3400006 125   Atlantic Co Special Serv 340000600695 30 Atlantic County Elementary And Middle Schools   Special Education School No Elementary PK 08 2020   grade_9                                                   0.0                                             0
2508032 NJ Atlantic 1 school 3400006 125   Atlantic Co Special Serv 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2020   grade_9                                                   2.0                                             2
2403280 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Commission School District 340000700081 60 Maywood Campus   Special Education School No Elementary PK 06 2021   grade_9                                                   0.0                                             0
2403281 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Commission School District 340000700083 70 Moonachie Campus   Special Education School No Elementary PK 08 2021   grade_9                                                   0.0                                             0
2403282 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Commission School District 340000700578 50 Lodi Ms Hs   Special Education School No High 06 12 2021   grade_9                                                   4.0                                             4
2508324 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700578 50 Lodi Ms Hs   Special Education School No High 06 12 2020   grade_9                                                   3.0                                             3
2508325 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700081 60 Maywood Campus   Special Education School No Elementary PK 05 2020   grade_9                                                   0.0                                             0
2508326 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700083 70 Moonachie Campus   Special Education School No Elementary PK 08 2020   grade_9                                                   0.0                                             0
2405360 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2021   grade_9                                                   0.0                                             0
2405361 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2021   grade_9                                                   0.0                                             0
2510400 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_9                                                   0.0                                             0
2510401 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_9                                                   0.0                                             0
2405122 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900177 30 Marion T. Bedwell Elementary School   Regular School No Elementary PK 04 2021   grade_9                                                   0.0                                             0
2405123 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900176 20 Bernards High School   Regular School No High 09 12 2021   grade_9                                                   210.0                                             210
2405124 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2021   grade_9                                                   0.0                                             0
2510161 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_9                                                   194.0                                             194
2510162 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900177 30 Marion T. Bedwell Elementary School   Regular School No Elementary PK 04 2020   grade_9                                                   0.0                                             0
2510163 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2020   grade_9                                                   0.0                                             0
2405440 NJ Charters 80 school 3400014 6430   Englewood On The Palisades Charter School 340001400258 930 Englewood On The Palisades Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510481 NJ Charters 80 school 3400014 6430   Englewood On The Palisades Charter School 340001400258 930 Englewood On The Palisades Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405465 NJ Charters 80 school 3400015 7890   Teaneck Community Charter School 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510506 NJ Charters 80 school 3400015 7890   Teaneck Community Cs 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405454 NJ Charters 80 school 3400019 7410   Chartertech High School For The Performing Arts 340001900269 940 Chartertech High School For The Performing Arts   Regular School Yes High 09 12 2021   grade_9                                                   112.0                                             112
2510495 NJ Charters 80 school 3400019 7410   Charter~Tech High School 340001900269 940 Chartertech High School For The Performing Arts   Regular School Yes High 09 12 2020   grade_9                                                   108.0                                             108
2405437 NJ Charters 80 school 3400020 6320   Discovery Charter School 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2021   grade_9                                                   0.0                                             0
2510478 NJ Charters 80 school 3400020 6320   Discovery Cs 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2020   grade_9                                                   0.0                                             0
2405438 NJ Charters 80 school 3400021 6410   East Orange Community Charter School 340002100283 920 East Orange Community Charter School   Regular School Yes Elementary KG 04 2021   grade_9                                                   0.0                                             0
2510479 NJ Charters 80 school 3400021 6410   East Orange Community Cs 340002100283 920 East Orange Community Charter School   Regular School Yes Elementary KG 05 2020   grade_9                                                   0.0                                             0
2405450 NJ Charters 80 school 3400022 7210   Marion P. Thomas Charter School 340002200285 940 Marion P. Thomas Charter School   Regular School Yes Other PK 12 2021   grade_9                                                   89.0                                             89
2510491 NJ Charters 80 school 3400022 7210   Marion P. Thomas Cs 340002200285 940 Marion P. Thomas Charter School   Regular School Yes Other PK 12 2020   grade_9                                                   134.0                                             134
2405451 NJ Charters 80 school 3400023 7290   New Horizons Community Charter School 340002300287 957 New Horizons Community Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510492 NJ Charters 80 school 3400023 7290   New Horizons Comm. Cs 340002300287 957 New Horizons Community Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405452 NJ Charters 80 school 3400024 7320   North Star Academy Charter School 340002400289 960 North Star Academy Charter School   Regular School Yes Other KG 12 2021   grade_9                                                   459.0                                             459
2510493 NJ Charters 80 school 3400024 7320   North Star Academy Charter School 340002400289 960 North Star Academy Charter School   Regular School Yes Other KG 12 2020   grade_9                                                   434.0                                             434
2405461 NJ Charters 80 school 3400025 7730   Robert Treat Academy Charter School 340002500291 970 Robert Treat Academy Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510502 NJ Charters 80 school 3400025 7730   Robert Treat Academy Cs 340002500291 970 Robert Treat Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405462 NJ Charters 80 school 3400026 7735   Maria L. Varisco-Rogers Charter School 340002600292 975 Maria Varisco Rogers Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510503 NJ Charters 80 school 3400026 7735   Maria L. Varisco-Rogers Cs 340002600292 975 Maria Varisco Rogers Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405439 NJ Charters 80 school 3400029 6420   Elysian Charter School 340002900297 925 Elysian Charter School Of Hoboken   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510480 NJ Charters 80 school 3400029 6420   Elysian Cs Of Hoboken 340002900297 925 Elysian Charter School Of Hoboken   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405443 NJ Charters 80 school 3400032 6720   Hoboken Charter School 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2021   grade_9                                                   25.0                                             25
2510484 NJ Charters 80 school 3400032 6720   Hoboken Cs 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2020   grade_9                                                   24.0                                             24
2405446 NJ Charters 80 school 3400033 6910   Jersey City Community Charter School 340003300303 940 Jersey City Community Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510487 NJ Charters 80 school 3400033 6910   Jersey City Comm. Cs 340003300303 940 Jersey City Community Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405447 NJ Charters 80 school 3400034 6915   Jersey City Golden Door Charter School 340003400305 950 Jersey City Golden Door Charter School   Regular School Yes Elementary PK 08 2021   grade_9                                                   0.0                                             0
2510488 NJ Charters 80 school 3400034 6915   Jersey City Golden Door Charter School 340003400305 950 Jersey City Golden Door Charter School   Regular School Yes Elementary PK 08 2020   grade_9                                                   0.0                                             0
2405449 NJ Charters 80 school 3400035 7115   The Learning Community Charter School 340003500307 960 Learning Community Charter School   Regular School Yes Elementary PK 08 2021   grade_9                                                   0.0                                             0
2510490 NJ Charters 80 school 3400035 7115   Learning Community Cs 340003500307 960 Learning Community Charter School   Regular School Yes Elementary PK 08 2020   grade_9                                                   0.0                                             0
2405463 NJ Charters 80 school 3400036 7830   Soaring Heights Charter School 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510504 NJ Charters 80 school 3400036 7830   Soaring Heights Cs 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405445 NJ Charters 80 school 3400041 6810   International Charter School Of Trenton 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2021   grade_9                                                   0.0                                             0
2510486 NJ Charters 80 school 3400041 6810   International Charter School 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2020   grade_9                                                   0.0                                             0
2405455 NJ Charters 80 school 3400042 7500   Pace Charter School Of Hamilton 340004200322 900 Pace Charter School Of Hamilton   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510496 NJ Charters 80 school 3400042 7500   Pace Cs Of Hamilton 340004200322 900 Pace Charter School Of Hamilton   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405457 NJ Charters 80 school 3400043 7540   Princeton Charter School 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510498 NJ Charters 80 school 3400043 7540   Princeton Cs 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405476 NJ Charters 80 school 3400046 8140   The Village Charter School 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510517 NJ Charters 80 school 3400046 8140   Village Cs 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405441 NJ Charters 80 school 3400047 6635   Greater Brunswick Charter School 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510482 NJ Charters 80 school 3400047 6635   Greater Brunswick Cs 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405390 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_9                                                   24.5                                             24
2510430 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_9                                                   46.0                                             46
2405459 NJ Charters 80 school 3400049 7720   Red Bank Charter School 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2021   grade_9                                                   0.0                                             0
2510500 NJ Charters 80 school 3400049 7720   The Red Bank Cs 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2020   grade_9                                                   0.0                                             0
2404126 NJ Hunterdon 19 school 3400050 2308   Hunterdon County Vocational School District 340005000021 50 Hunterdon County Vocational School District Central Campus   Career and Technical School No High 09 12 2021   grade_9                                                   0.0                                             0
2404127 NJ Hunterdon 19 school 3400050 2308   Hunterdon County Vocational School District 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2021   grade_9                                                   86.0                                             86
2404128 NJ Hunterdon 19 school 3400050 2308   Hunterdon County Vocational School District 340005000716 30 Hunterdon Polytech Bartles Corner Campus   Career and Technical School No High 09 12 2021   grade_9                                                   17.0                                             17
2509165 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005000716 30 Hunterdon Polytech Bartles Corner Campus   Career and Technical School No High 09 12 2020   grade_9                                                   0.5                                             0
2509166 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005000021 50 Hunterdon County Vocational School District Central Campus   Career and Technical School No High 09 12 2020   grade_9                                                   0.5                                             0
2509167 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2020   grade_9                                                   66.0                                             66
2405473 NJ Charters 80 school 3400051 8050   Unity Charter School 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510514 NJ Charters 80 school 3400051 8050   Unity Cs 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405434 NJ Charters 80 school 3400052 6230   Classical Academy Charter School Of Clifton 340005200351 915 Classical Academy Charter School Of Clifton   Regular School Yes Middle 06 08 2021   grade_9                                                   0.0                                             0
2510475 NJ Charters 80 school 3400052 6230   Classical Academy Charter School Of Clifton 340005200351 915 Classical Academy Charter School Of Clifton   Regular School Yes Middle 06 08 2020   grade_9                                                   0.0                                             0
2405464 NJ Charters 80 school 3400055 7850   Sussex County Technology Charter School 340005500361 960 Sussex County Technology Charter School   Regular School Yes Middle 06 08 2021   grade_9                                                   0.0                                             0
2510505 NJ Charters 80 school 3400055 7850   Sussex County Technology Charter School 340005500361 960 Sussex County Technology Charter School   Regular School Yes Middle 06 08 2020   grade_9                                                   0.0                                             0
2405458 NJ Charters 80 school 3400061 7600   The Queen City Academy Charter School District 340006100378 960 The Queen City Academy Charter School   Regular School Yes Other KG 09 2021   grade_9                                                   0.0                                             0
2510499 NJ Charters 80 school 3400061 7600   Queen City Academy Cs 340006100378 960 The Queen City Academy Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2405442 NJ Charters 80 school 3400064 6665   Gray Charter School 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2021   grade_9                                                   0.0                                             0
2510483 NJ Charters 80 school 3400064 6665   Gray Cs 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2020   grade_9                                                   0.0                                             0
2404435 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Commission School District 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2021   grade_9                                                   2.0                                             2
2509474 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_9                                                   1.0                                             1

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