Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_1 · 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
2384577 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2384578 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_1                                                   0.0                                             0
2384579 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_1                                                   75.0                                             75
2384580 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2021   grade_1                                                   0.0                                             0
2384581 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_1                                                   52.0                                             52
2384582 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2021   grade_1                                                   91.0                                             91
2489641 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2489642 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
2489643 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_1                                                   0.0                                             0
2489644 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_1                                                   59.0                                             59
2489645 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_1                                                   70.0                                             70
2489646 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2020   grade_1                                                   118.0                                             118
2385215 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_1                                                   2.0                                             2
2385216 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_1                                                   0.0                                             0
2490279 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_1                                                   1.0                                             1
2490280 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_1                                                   0.0                                             0
2382946 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_1                                                   0.0                                             0
2382947 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_1                                                   0.0                                             0
2488015 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_1                                                   8.0                                             8
2488016 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_1                                                   0.0                                             0
2383240 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_1                                                   5.0                                             5
2383241 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_1                                                   1.0                                             1
2383242 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_1                                                   0.0                                             0
2488308 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700578 50 Lodi Ms Hs   Special Education School No High 06 12 2020   grade_1                                                   0.0                                             0
2488309 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700081 60 Maywood Campus   Special Education School No Elementary PK 05 2020   grade_1                                                   2.0                                             2
2488310 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700083 70 Moonachie Campus   Special Education School No Elementary PK 08 2020   grade_1                                                   2.0                                             2
2385320 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2021   grade_1                                                   61.0                                             61
2385321 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_1                                                   0.0                                             0
2490384 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_1                                                   0.0                                             0
2490385 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_1                                                   65.0                                             65
2385082 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_1                                                   106.0                                             106
2385083 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900176 20 Bernards High School   Regular School No High 09 12 2021   grade_1                                                   0.0                                             0
2385084 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2021   grade_1                                                   0.0                                             0
2490145 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2490146 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900177 30 Marion T. Bedwell Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   89.0                                             89
2490147 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2385400 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_1                                                   40.0                                             40
2490465 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_1                                                   40.0                                             40
2385425 NJ Charters 80 school 3400015 7890   Teaneck Community Charter School 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   45.0                                             45
2490490 NJ Charters 80 school 3400015 7890   Teaneck Community Cs 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   36.0                                             36
2385414 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_1                                                   0.0                                             0
2490479 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_1                                                   0.0                                             0
2385397 NJ Charters 80 school 3400020 6320   Discovery Charter School 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2021   grade_1                                                   0.0                                             0
2490462 NJ Charters 80 school 3400020 6320   Discovery Cs 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2020   grade_1                                                   0.0                                             0
2385398 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_1                                                   113.0                                             113
2490463 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_1                                                   98.0                                             98
2385410 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_1                                                   103.0                                             103
2490475 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_1                                                   81.0                                             81
2385411 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_1                                                   31.0                                             31
2490476 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_1                                                   61.0                                             61
2385412 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_1                                                   567.0                                             567
2490477 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_1                                                   562.0                                             562
2385421 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_1                                                   79.0                                             79
2490486 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_1                                                   78.0                                             78
2385422 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_1                                                   62.0                                             62
2490487 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_1                                                   64.0                                             64
2385399 NJ Charters 80 school 3400029 6420   Elysian Charter School 340002900297 925 Elysian Charter School Of Hoboken   Regular School Yes Elementary KG 08 2021   grade_1                                                   32.0                                             32
2490464 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_1                                                   32.0                                             32
2385403 NJ Charters 80 school 3400032 6720   Hoboken Charter School 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2021   grade_1                                                   22.0                                             22
2490468 NJ Charters 80 school 3400032 6720   Hoboken Cs 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2020   grade_1                                                   22.0                                             22
2385406 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_1                                                   66.0                                             66
2490471 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_1                                                   68.0                                             68
2385407 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_1                                                   74.0                                             74
2490472 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_1                                                   74.0                                             74
2385409 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_1                                                   66.0                                             66
2490474 NJ Charters 80 school 3400035 7115   Learning Community Cs 340003500307 960 Learning Community Charter School   Regular School Yes Elementary PK 08 2020   grade_1                                                   66.0                                             66
2385423 NJ Charters 80 school 3400036 7830   Soaring Heights Charter School 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   24.0                                             24
2490488 NJ Charters 80 school 3400036 7830   Soaring Heights Cs 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   51.0                                             51
2385405 NJ Charters 80 school 3400041 6810   International Charter School Of Trenton 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2021   grade_1                                                   21.0                                             21
2490470 NJ Charters 80 school 3400041 6810   International Charter School 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2020   grade_1                                                   18.0                                             18
2385415 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_1                                                   50.0                                             50
2490480 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_1                                                   45.0                                             45
2385417 NJ Charters 80 school 3400043 7540   Princeton Charter School 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   43.0                                             43
2490482 NJ Charters 80 school 3400043 7540   Princeton Cs 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   42.0                                             42
2385436 NJ Charters 80 school 3400046 8140   The Village Charter School 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   40.0                                             40
2490501 NJ Charters 80 school 3400046 8140   Village Cs 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   39.0                                             39
2385401 NJ Charters 80 school 3400047 6635   Greater Brunswick Charter School 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   46.0                                             46
2490466 NJ Charters 80 school 3400047 6635   Greater Brunswick Cs 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   44.0                                             44
2385350 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_1                                                   0.0                                             0
2490414 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_1                                                   0.0                                             0
2385419 NJ Charters 80 school 3400049 7720   Red Bank Charter School 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2021   grade_1                                                   20.0                                             20
2490484 NJ Charters 80 school 3400049 7720   The Red Bank Cs 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2020   grade_1                                                   20.0                                             20
2384086 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_1                                                   0.0                                             0
2384087 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_1                                                   0.0                                             0
2384088 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_1                                                   0.0                                             0
2489149 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_1                                                   0.0                                             0
2489150 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_1                                                   0.0                                             0
2489151 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2020   grade_1                                                   0.0                                             0
2385433 NJ Charters 80 school 3400051 8050   Unity Charter School 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   25.0                                             25
2490498 NJ Charters 80 school 3400051 8050   Unity Cs 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   28.0                                             28
2385394 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_1                                                   0.0                                             0
2490459 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_1                                                   0.0                                             0
2385424 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_1                                                   0.0                                             0
2490489 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_1                                                   0.0                                             0
2385418 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_1                                                   38.0                                             38
2490483 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_1                                                   36.0                                             36
2385402 NJ Charters 80 school 3400064 6665   Gray Charter School 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2021   grade_1                                                   46.0                                             46
2490467 NJ Charters 80 school 3400064 6665   Gray Cs 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   46.0                                             46
2384395 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_1                                                   0.0                                             0
2489458 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_1                                                   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]);