Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_4 · 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
2392092 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2392093 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_4                                                   280.0                                             280
2392094 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2392095 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2021   grade_4                                                   0.0                                             0
2392096 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2392097 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2497147 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2497148 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2497149 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_4                                                   291.0                                             291
2497150 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2497151 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2497152 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2392730 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_4                                                   4.0                                             4
2392731 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_4                                                   0.0                                             0
2497785 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_4                                                   0.0                                             0
2497786 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_4                                                   0.0                                             0
2390461 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_4                                                   0.0                                             0
2390462 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_4                                                   3.0                                             3
2495521 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_4                                                   5.0                                             5
2495522 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_4                                                   0.0                                             0
2390755 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_4                                                   1.0                                             1
2390756 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_4                                                   0.0                                             0
2390757 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_4                                                   0.0                                             0
2495814 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700578 50 Lodi Ms Hs   Special Education School No High 06 12 2020   grade_4                                                   0.0                                             0
2495815 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700081 60 Maywood Campus   Special Education School No Elementary PK 05 2020   grade_4                                                   3.0                                             3
2495816 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700083 70 Moonachie Campus   Special Education School No Elementary PK 08 2020   grade_4                                                   0.0                                             0
2392835 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2021   grade_4                                                   0.0                                             0
2392836 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_4                                                   67.0                                             67
2497890 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_4                                                   53.0                                             53
2497891 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2392597 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_4                                                   119.0                                             119
2392598 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900176 20 Bernards High School   Regular School No High 09 12 2021   grade_4                                                   0.0                                             0
2392599 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2021   grade_4                                                   0.0                                             0
2497651 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2497652 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900177 30 Marion T. Bedwell Elementary School   Regular School No Elementary PK 04 2020   grade_4                                                   121.0                                             121
2497653 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2392915 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_4                                                   33.0                                             33
2497971 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_4                                                   36.0                                             36
2392940 NJ Charters 80 school 3400015 7890   Teaneck Community Charter School 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   36.0                                             36
2497996 NJ Charters 80 school 3400015 7890   Teaneck Community Cs 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   36.0                                             36
2392929 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_4                                                   0.0                                             0
2497985 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_4                                                   0.0                                             0
2392912 NJ Charters 80 school 3400020 6320   Discovery Charter School 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2021   grade_4                                                   28.0                                             28
2497968 NJ Charters 80 school 3400020 6320   Discovery Cs 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2020   grade_4                                                   30.0                                             30
2392913 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_4                                                   89.0                                             89
2497969 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_4                                                   91.0                                             91
2392925 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_4                                                   115.0                                             115
2497981 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_4                                                   122.0                                             122
2392926 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_4                                                   67.0                                             67
2497982 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_4                                                   69.0                                             69
2392927 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_4                                                   557.0                                             557
2497983 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_4                                                   472.0                                             472
2392936 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_4                                                   81.0                                             81
2497992 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_4                                                   78.0                                             78
2392937 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_4                                                   64.0                                             64
2497993 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_4                                                   64.0                                             64
2392914 NJ Charters 80 school 3400029 6420   Elysian Charter School 340002900297 925 Elysian Charter School Of Hoboken   Regular School Yes Elementary KG 08 2021   grade_4                                                   31.0                                             31
2497970 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_4                                                   32.0                                             32
2392918 NJ Charters 80 school 3400032 6720   Hoboken Charter School 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2021   grade_4                                                   22.0                                             22
2497974 NJ Charters 80 school 3400032 6720   Hoboken Cs 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2020   grade_4                                                   22.0                                             22
2392921 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_4                                                   63.0                                             63
2497977 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_4                                                   65.0                                             65
2392922 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_4                                                   60.0                                             60
2497978 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_4                                                   73.0                                             73
2392924 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_4                                                   66.0                                             66
2497980 NJ Charters 80 school 3400035 7115   Learning Community Cs 340003500307 960 Learning Community Charter School   Regular School Yes Elementary PK 08 2020   grade_4                                                   66.0                                             66
2392938 NJ Charters 80 school 3400036 7830   Soaring Heights Charter School 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   26.0                                             26
2497994 NJ Charters 80 school 3400036 7830   Soaring Heights Cs 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   25.0                                             25
2392920 NJ Charters 80 school 3400041 6810   International Charter School Of Trenton 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2021   grade_4                                                   12.0                                             12
2497976 NJ Charters 80 school 3400041 6810   International Charter School 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2020   grade_4                                                   18.0                                             18
2392930 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_4                                                   44.0                                             44
2497986 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_4                                                   45.0                                             45
2392932 NJ Charters 80 school 3400043 7540   Princeton Charter School 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   50.0                                             50
2497988 NJ Charters 80 school 3400043 7540   Princeton Cs 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   50.0                                             50
2392951 NJ Charters 80 school 3400046 8140   The Village Charter School 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   41.0                                             41
2498007 NJ Charters 80 school 3400046 8140   Village Cs 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   40.0                                             40
2392916 NJ Charters 80 school 3400047 6635   Greater Brunswick Charter School 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   44.0                                             44
2497972 NJ Charters 80 school 3400047 6635   Greater Brunswick Cs 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   44.0                                             44
2392865 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_4                                                   0.0                                             0
2497920 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_4                                                   0.0                                             0
2392934 NJ Charters 80 school 3400049 7720   Red Bank Charter School 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2021   grade_4                                                   20.0                                             20
2497990 NJ Charters 80 school 3400049 7720   The Red Bank Cs 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2020   grade_4                                                   20.0                                             20
2391601 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_4                                                   0.0                                             0
2391602 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_4                                                   0.0                                             0
2391603 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_4                                                   0.0                                             0
2496655 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_4                                                   0.0                                             0
2496656 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_4                                                   0.0                                             0
2496657 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2020   grade_4                                                   0.0                                             0
2392948 NJ Charters 80 school 3400051 8050   Unity Charter School 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   25.0                                             25
2498004 NJ Charters 80 school 3400051 8050   Unity Cs 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   31.0                                             31
2392909 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_4                                                   0.0                                             0
2497965 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_4                                                   0.0                                             0
2392939 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_4                                                   0.0                                             0
2497995 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_4                                                   0.0                                             0
2392933 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_4                                                   38.0                                             38
2497989 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_4                                                   36.0                                             36
2392917 NJ Charters 80 school 3400064 6665   Gray Charter School 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2021   grade_4                                                   48.0                                             48
2497973 NJ Charters 80 school 3400064 6665   Gray Cs 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2020   grade_4                                                   49.0                                             49
2391910 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_4                                                   0.0                                             0
2496964 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_4                                                   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]);