enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_1", state = "NJ" and year = 2020 sorted by district

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • grade_1 · 2,502 ✖
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
2488000 2488000 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2488001 2488001 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_1                                                   79.0                                             79
2490414 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
2490426 2490426 NJ Charters 80 school 3400741 6032   Academy For Urban Leadership Charter School 340074103050 901 Academy For Urban Leadership Charter School   Regular School Yes High 07 12 2020   grade_1                                                   0.0                                             0
2490457 2490457 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_1                                                   49.0                                             49
2490494 2490494 NJ Charters 80 school 3400794 7895   Achievers Early College Prep Charter School 340079403457 920 Achievers Early College Prep Charter School   Regular School Yes Middle 06 07 2020   grade_1                                                   0.0                                             0
2489119 2489119 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_1                                                   0.0                                             0
2489120 2489120 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002956 10 Lester D. Wilson Elementary School   Regular School No Elementary PK 03 2020   grade_1                                                   35.0                                             35
2490376 2490376 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   grade_1                                                   0.0                                             0
2490377 2490377 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_1                                                   50.0                                             50
2488072 2488072 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000224 10 Brookside School   Regular School No Middle 04 08 2020   grade_1                                                   0.0                                             0
2488073 2488073 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000226 20 Hillside Elementary School   Regular School No Elementary PK 03 2020   grade_1                                                   64.0                                             64
2490045 2490045 NJ Salem 33 school 3400810 60   Alloway Twp 340081005028 20 Alloway Township School   Regular School No Elementary PK 08 2020   grade_1                                                   20.0                                             20
2490378 2490378 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   grade_1                                                   22.0                                             22
2488074 2488074 NJ Bergen 3 school 3400870 80   Alpine Boro 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2020   grade_1                                                   14.0                                             14
2490160 2490160 NJ Sussex 37 school 3400900 90   Andover Reg 340090005324 10 Florence M. Burd   Regular School No Elementary PK 04 2020   grade_1                                                   43.0                                             43
2490161 2490161 NJ Sussex 37 school 3400900 90   Andover Reg 340090005326 40 Long Pond School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2489451 2489451 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003732 10 Asbury Park High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2489452 2489452 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   46.0                                             46
2489453 2489453 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   45.0                                             45
2489454 2489454 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003742 70 Dr. Martin Luther King Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
2489455 2489455 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   39.0                                             39
2488002 2488002 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2488003 2488003 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000012 30 Sovereign Avenue School   Regular School No Elementary PK 08 2020   grade_1                                                   59.0                                             59
2488004 2488004 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000016 50 Chelsea Heights School   Regular School No Elementary PK 08 2020   grade_1                                                   30.0                                             30
2488005 2488005 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000018 60 Texas Avenue School   Regular School No Elementary KG 08 2020   grade_1                                                   54.0                                             54
2488006 2488006 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000020 70 New York Avenue School   Regular School No Elementary PK 08 2020   grade_1                                                   55.0                                             55
2488007 2488007 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000022 80 Uptown School Complex   Regular School No Elementary PK 08 2020   grade_1                                                   51.0                                             51
2488008 2488008 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000026 100 Pennsylvania Ave School   Regular School No Elementary PK 08 2020   grade_1                                                   47.0                                             47
2488009 2488009 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000028 120 Richmond Avenue School   Regular School No Elementary PK 08 2020   grade_1                                                   56.0                                             56
2488010 2488010 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   grade_1                                                   0.0                                             0
2488011 2488011 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000032 140 Dr Martin Luther King Jr School Complex   Regular School No Elementary PK 08 2020   grade_1                                                   47.0                                             47
2488012 2488012 NJ Atlantic 1 school 3400960 110   Atlantic City 340096003259 300 Brighton Avenue School   Regular School No Elementary PK 05 2020   grade_1                                                   52.0                                             52
2488015 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 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
2488013 2488013 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2020   grade_1                                                   0.0                                             0
2488014 2488014 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_1                                                   0.0                                             0
2490433 2490433 NJ Charters 80 school 3400771 6060   Atlantic Community Charter School 340077103287 942 Atlantic Community Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   46.0                                             46
2489456 2489456 NJ Monmouth 25 school 3401020 130   Atlantic Highlands Boro 340102003746 20 Atlantic Highlands Elementary School   Regular School No Elementary PK 06 2020   grade_1                                                   37.0                                             37
2488480 2488480 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001298 10 Audubon Junior/Senior High School   Regular School No High 07 12 2020   grade_1                                                   0.0                                             0
2488481 2488481 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001300 40 Haviland Avenue School   Regular School No Elementary PK 02 2020   grade_1                                                   83.0                                             83
2488482 2488482 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001302 50 Mansion Avenue School   Regular School No Elementary 03 06 2020   grade_1                                                   0.0                                             0
2488628 2488628 NJ Cape May 9 school 3401110 170   Avalon Boro 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2489457 2489457 NJ Monmouth 25 school 3401140 180   Avon Boro 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2020   grade_1                                                   9.0                                             9
2489787 2489787 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   67.0                                             67
2489788 2489788 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647005947 15 Cecil S. Collins Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   51.0                                             51
2489789 2489789 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647000557 30 Barnegat High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2489790 2489790 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647006074 50 Russell O. Brackman Middle School   Regular School No Middle 06 08 2020   grade_1                                                   0.0                                             0
2489791 2489791 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647000461 70 Robert L. Horbelt Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   59.0                                             59
2489792 2489792 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647003007 80 Joseph T. Donahue Elementary School   Regular School No Elementary PK 05 2020   grade_1                                                   33.0                                             33
2488483 2488483 NJ Camden 7 school 3401170 190   Barrington Boro 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   56.0                                             56
2488484 2488484 NJ Camden 7 school 3401170 190   Barrington Boro 340117001312 30 Woodland Middle School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2488351 2488351 NJ Burlington 5 school 3401200 200   Bass River Twp 340120000950 50 Bass River Township Elementary School   Regular School No Elementary PK 06 2020   grade_1                                                   15.0                                             15
2489793 2489793 NJ Ocean 29 school 3401230 210   Bay Head Boro 340123004568 20 Bay Head Elementary   Regular School No Elementary KG 08 2020   grade_1                                                   12.0                                             12
2489005 2489005 NJ Hudson 17 school 3401260 220   Bayonne City 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2489006 2489006 NJ Hudson 17 school 3401260 220   Bayonne City 340126002704 20 Bayonne High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2489007 2489007 NJ Hudson 17 school 3401260 220   Bayonne City 340126002710 30 Walter F. Robinson Community School   Regular School No Elementary PK 08 2020   grade_1                                                   96.0                                             96
2489008 2489008 NJ Hudson 17 school 3401260 220   Bayonne City 340126002712 40 John M. Bailey Community School   Regular School No Elementary PK 08 2020   grade_1                                                   80.0                                             80
2489009 2489009 NJ Hudson 17 school 3401260 220   Bayonne City 340126002714 50 Henry E. Harris Community School   Regular School No Elementary PK 08 2020   grade_1                                                   66.0                                             66
2489010 2489010 NJ Hudson 17 school 3401260 220   Bayonne City 340126002716 60 Horace Mann Community School   Regular School No Elementary PK 08 2020   grade_1                                                   55.0                                             55
2489011 2489011 NJ Hudson 17 school 3401260 220   Bayonne City 340126002718 70 Lincoln Community School #5   Regular School No Elementary PK 08 2020   grade_1                                                   53.0                                             53
2489012 2489012 NJ Hudson 17 school 3401260 220   Bayonne City 340126002720 80 Mary J Donohoe Community School   Regular School No Elementary PK 08 2020   grade_1                                                   55.0                                             55
2489013 2489013 NJ Hudson 17 school 3401260 220   Bayonne City 340126000001 85 William Shemin Midtown Community School #8   Regular School No Elementary PK 08 2020   grade_1                                                   137.0                                             137
2489014 2489014 NJ Hudson 17 school 3401260 220   Bayonne City 340126002722 90 Philip G. Vroom Community School   Regular School No Elementary PK 08 2020   grade_1                                                   51.0                                             51
2489015 2489015 NJ Hudson 17 school 3401260 220   Bayonne City 340126002728 120 Washington Community School #9   Regular School No Elementary PK 08 2020   grade_1                                                   60.0                                             60
2489016 2489016 NJ Hudson 17 school 3401260 220   Bayonne City 340126002730 130 Woodrow Wilson Community School   Regular School No Elementary PK 08 2020   grade_1                                                   59.0                                             59
2489017 2489017 NJ Hudson 17 school 3401260 220   Bayonne City 340126000141 140 Nicholas Oresko Community School   Regular School No Elementary PK 08 2020   grade_1                                                   26.0                                             26
2489458 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
2489794 2489794 NJ Ocean 29 school 3401290 230   Beach Haven Boro 340129004570 20 Beach Haven School   Regular School No Elementary PK 06 2020   grade_1                                                   8.0                                             8
2490079 2490079 NJ Somerset 35 school 3401320 240   Bedminster Twp 340132005120 20 Bedminster Township Public School   Regular School No Elementary PK 08 2020   grade_1                                                   52.0                                             52
2488705 2488705 NJ Essex 13 school 3401350 250   Belleville Town 340135001954 20 Belleville High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2488706 2488706 NJ Essex 13 school 3401350 250   Belleville Town 340135001956 25 Belleville Middle School   Regular School No Middle 07 08 2020   grade_1                                                   0.0                                             0
2488707 2488707 NJ Essex 13 school 3401350 250   Belleville Town 340135001962 50 Belleville Ps3   Regular School No Elementary PK 06 2020   grade_1                                                   57.0                                             57
2488708 2488708 NJ Essex 13 school 3401350 250   Belleville Town 340135001964 55 Belleville Ps4   Regular School No Elementary PK 06 2020   grade_1                                                   50.0                                             50
2488709 2488709 NJ Essex 13 school 3401350 250   Belleville Town 340135001966 60 Belleville Ps5   Regular School No Elementary KG 06 2020   grade_1                                                   53.0                                             53
2488710 2488710 NJ Essex 13 school 3401350 250   Belleville Town 340135001968 70 Belleville Ps7   Regular School No Elementary PK 06 2020   grade_1                                                   46.0                                             46
2488711 2488711 NJ Essex 13 school 3401350 250   Belleville Town 340135001970 80 Belleville Ps8   Regular School No Elementary KG 06 2020   grade_1                                                   73.0                                             73
2488712 2488712 NJ Essex 13 school 3401350 250   Belleville Town 340135001972 90 Belleville Ps9   Regular School No Elementary KG 06 2020   grade_1                                                   19.0                                             19
2488713 2488713 NJ Essex 13 school 3401350 250   Belleville Town 340135001974 100 Belleville Ps10   Regular School No Elementary KG 06 2020   grade_1                                                   17.0                                             17
2488485 2488485 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001316 15 Bell Oaks Upper Elementary School   Regular School No Middle 05 08 2020   grade_1                                                   0.0                                             0
2488486 2488486 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   grade_1                                                   56.0                                             56
2488487 2488487 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001320 30 Ethel M Burke Elementary School   Regular School No Elementary KG 04 2020   grade_1                                                   39.0                                             39
2489459 2489459 NJ Monmouth 25 school 3401410 270   Belmar Boro 340141003750 20 Belmar Elementary   Regular School No Elementary PK 08 2020   grade_1                                                   35.0                                             35
2490441 2490441 NJ Charters 80 school 3400759 6082   Beloved Community Charter School 340075903196 963 Beloved Community Charter School   Regular School Yes Other KG 09 2020   grade_1                                                   120.0                                             120
2490379 2490379 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_1                                                   0.0                                             0
2490380 2490380 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   grade_1                                                   29.0                                             29
2490437 2490437 NJ Charters 80 school 3400744 6076   Benjamin Banneker Prep Cs 340074403139 961 Benjamin Banneker Preparatory Charter School   Regular School Yes Elementary KG 08 2020   grade_1                                                   29.0                                             29
2490415 2490415 NJ Charters 80 school 3400715 6013   Bergen Arts And Sciences Charter School 340071502923 900 Bergen Arts And Sciences Charter School   Regular School Yes Other KG 12 2020   grade_1                                                   100.0                                             100
2488075 2488075 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145005978 2 N. A. Bleshman Regional Day School   Special Education School No Other PK 12 2020   grade_1                                                   1.0                                             1
2488076 2488076 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000234 30 Hearing Impaired   Special Education School No Other PK 12 2020   grade_1                                                   3.0                                             3
2488077 2488077 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145006020 40 Multiply Handicapped   Special Education School No Other PK 12 2020   grade_1                                                   2.0                                             2
2488078 2488078 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000238 50 Emotionally Disturbed   Special Education School No Other PK 12 2020   grade_1                                                   0.0                                             0
2488079 2488079 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000240 70 Life Skills   Special Education School No Other PK 12 2020   grade_1                                                   0.0                                             0
2488080 2488080 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000073 100 Autistic   Special Education School No Other PK 12 2020   grade_1                                                   1.0                                             1
2488081 2488081 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000250 20 Bergen County Academies   Career and Technical School No High 09 12 2020   grade_1                                                   0.0                                             0
2488082 2488082 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000252 30 Bergen County Technical High School - Paramus   Special Education School No High 09 12 2020   grade_1                                                   0.0                                             0
2488083 2488083 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000262 70 Bergen County Technical High School - Teterboro   Career and Technical School No High 09 12 2020   grade_1                                                   0.0                                             0
2488084 2488084 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000264 75 Bergen County Technical High School - Paramus   Career and Technical School No High 09 12 2020   grade_1                                                   0.0                                             0
2488085 2488085 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147003341 300 Applied Technology High School   Career and Technical School No High 09 12 2020   grade_1                                                   0.0                                             0
2488086 2488086 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000268 20 Bergenfield High School   Regular School No High 09 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]);