Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_3 · 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
2389587 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2389588 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2021   grade_3                                                   0.0                                             0
2389589 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2021   grade_3                                                   101.0                                             101
2389590 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2021   grade_3                                                   0.0                                             0
2389591 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2021   grade_3                                                   54.0                                             54
2389592 NJ Morris 27 school 3400004 785   School District Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2021   grade_3                                                   119.0                                             119
2494645 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406014 10 Chatham High School   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
2494646 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406015 30 Chatham Middle School   Regular School No Middle 06 08 2020   grade_3                                                   0.0                                             0
2494647 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406016 50 Lafayette Avenue School   Regular School No Elementary 04 05 2020   grade_3                                                   0.0                                             0
2494648 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406017 60 Milton Avenue School   Regular School No Elementary PK 03 2020   grade_3                                                   61.0                                             61
2494649 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406018 70 Washington Avenue School   Regular School No Elementary PK 03 2020   grade_3                                                   86.0                                             86
2494650 NJ Morris 27 school 3400004 785   Sch Dist Of The Chathams 340000406019 80 Southern Boulevard School   Regular School No Elementary PK 03 2020   grade_3                                                   132.0                                             132
2390225 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_3                                                   1.0                                             1
2390226 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_3                                                   0.0                                             0
2495283 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_3                                                   4.0                                             4
2495284 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_3                                                   0.0                                             0
2387956 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_3                                                   0.0                                             0
2387957 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_3                                                   4.0                                             4
2493019 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_3                                                   3.0                                             3
2493020 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_3                                                   0.0                                             0
2388250 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_3                                                   9.0                                             9
2388251 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_3                                                   0.0                                             0
2388252 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_3                                                   0.0                                             0
2493312 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700578 50 Lodi Ms Hs   Special Education School No High 06 12 2020   grade_3                                                   0.0                                             0
2493313 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700081 60 Maywood Campus   Special Education School No Elementary PK 05 2020   grade_3                                                   3.0                                             3
2493314 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700083 70 Moonachie Campus   Special Education School No Elementary PK 08 2020   grade_3                                                   0.0                                             0
2390330 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2021   grade_3                                                   68.0                                             68
2390331 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_3                                                   0.0                                             0
2495388 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_3                                                   0.0                                             0
2495389 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_3                                                   70.0                                             70
2390092 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_3                                                   91.0                                             91
2390093 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900176 20 Bernards High School   Regular School No High 09 12 2021   grade_3                                                   0.0                                             0
2390094 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional School District 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2021   grade_3                                                   0.0                                             0
2495149 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_3                                                   0.0                                             0
2495150 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900177 30 Marion T. Bedwell Elementary School   Regular School No Elementary PK 04 2020   grade_3                                                   121.0                                             121
2495151 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2020   grade_3                                                   0.0                                             0
2390410 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_3                                                   35.0                                             35
2495469 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_3                                                   36.0                                             36
2390435 NJ Charters 80 school 3400015 7890   Teaneck Community Charter School 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   36.0                                             36
2495494 NJ Charters 80 school 3400015 7890   Teaneck Community Cs 340001500259 920 Teaneck Community Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   36.0                                             36
2390424 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_3                                                   0.0                                             0
2495483 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_3                                                   0.0                                             0
2390407 NJ Charters 80 school 3400020 6320   Discovery Charter School 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2021   grade_3                                                   0.0                                             0
2495466 NJ Charters 80 school 3400020 6320   Discovery Cs 340002000282 920 Discovery Charter School   Regular School Yes Middle 04 08 2020   grade_3                                                   0.0                                             0
2390408 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_3                                                   96.0                                             96
2495467 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_3                                                   87.0                                             87
2390420 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_3                                                   100.0                                             100
2495479 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_3                                                   116.0                                             116
2390421 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_3                                                   59.0                                             59
2495480 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_3                                                   67.0                                             67
2390422 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_3                                                   569.0                                             569
2495481 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_3                                                   554.0                                             554
2390431 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_3                                                   78.0                                             78
2495490 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_3                                                   79.0                                             79
2390432 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_3                                                   64.0                                             64
2495491 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_3                                                   64.0                                             64
2390409 NJ Charters 80 school 3400029 6420   Elysian Charter School 340002900297 925 Elysian Charter School Of Hoboken   Regular School Yes Elementary KG 08 2021   grade_3                                                   33.0                                             33
2495468 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_3                                                   32.0                                             32
2390413 NJ Charters 80 school 3400032 6720   Hoboken Charter School 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2021   grade_3                                                   22.0                                             22
2495472 NJ Charters 80 school 3400032 6720   Hoboken Cs 340003200302 930 Hoboken Charter School   Regular School Yes Other KG 12 2020   grade_3                                                   22.0                                             22
2390416 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_3                                                   71.0                                             71
2495475 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_3                                                   60.0                                             60
2390417 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_3                                                   72.0                                             72
2495476 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_3                                                   63.0                                             63
2390419 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_3                                                   65.0                                             65
2495478 NJ Charters 80 school 3400035 7115   Learning Community Cs 340003500307 960 Learning Community Charter School   Regular School Yes Elementary PK 08 2020   grade_3                                                   66.0                                             66
2390433 NJ Charters 80 school 3400036 7830   Soaring Heights Charter School 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   23.0                                             23
2495492 NJ Charters 80 school 3400036 7830   Soaring Heights Cs 340003600309 980 Soaring Heights Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   25.0                                             25
2390415 NJ Charters 80 school 3400041 6810   International Charter School Of Trenton 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2021   grade_3                                                   7.0                                             7
2495474 NJ Charters 80 school 3400041 6810   International Charter School 340004100321 940 International Charter School   Regular School Yes Elementary KG 04 2020   grade_3                                                   18.0                                             18
2390425 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_3                                                   46.0                                             46
2495484 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_3                                                   45.0                                             45
2390427 NJ Charters 80 school 3400043 7540   Princeton Charter School 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   48.0                                             48
2495486 NJ Charters 80 school 3400043 7540   Princeton Cs 340004300323 930 Princeton Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   48.0                                             48
2390446 NJ Charters 80 school 3400046 8140   The Village Charter School 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   39.0                                             39
2495505 NJ Charters 80 school 3400046 8140   Village Cs 340004600329 990 The Village Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   39.0                                             39
2390411 NJ Charters 80 school 3400047 6635   Greater Brunswick Charter School 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   44.0                                             44
2495470 NJ Charters 80 school 3400047 6635   Greater Brunswick Cs 340004700330 930 Greater Brunswick Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   44.0                                             44
2390360 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2021   grade_3                                                   0.0                                             0
2495418 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_3                                                   0.0                                             0
2390429 NJ Charters 80 school 3400049 7720   Red Bank Charter School 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2021   grade_3                                                   19.0                                             19
2495488 NJ Charters 80 school 3400049 7720   The Red Bank Cs 340004900336 915 Red Bank Charter School   Regular School Yes Elementary PK 08 2020   grade_3                                                   20.0                                             20
2389096 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_3                                                   0.0                                             0
2389097 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_3                                                   0.0                                             0
2389098 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_3                                                   0.0                                             0
2494153 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_3                                                   0.0                                             0
2494154 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_3                                                   0.0                                             0
2494155 NJ Hunterdon 19 school 3400050 2308   Hunterdon Co Vocational 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2020   grade_3                                                   0.0                                             0
2390443 NJ Charters 80 school 3400051 8050   Unity Charter School 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   25.0                                             25
2495502 NJ Charters 80 school 3400051 8050   Unity Cs 340005100339 990 Unity Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   27.0                                             27
2390404 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_3                                                   0.0                                             0
2495463 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_3                                                   0.0                                             0
2390434 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_3                                                   0.0                                             0
2495493 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_3                                                   0.0                                             0
2390428 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_3                                                   38.0                                             38
2495487 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_3                                                   36.0                                             36
2390412 NJ Charters 80 school 3400064 6665   Gray Charter School 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2021   grade_3                                                   48.0                                             48
2495471 NJ Charters 80 school 3400064 6665   Gray Cs 340006400373 930 The Gray Charter School   Regular School Yes Elementary KG 08 2020   grade_3                                                   44.0                                             44
2389405 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_3                                                   1.0                                             1
2494462 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Comm 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2020   grade_3                                                   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]);