enrollments

Data source: Big Local News · About: Big Local

5,007 rows where grade = "grade_5" and state = "NJ" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_5 · 3,745 ✖
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
2498009 2498009 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498010 2498010 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498018 2498018 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2498021 2498021 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_5                                                   0.0                                             0
2498022 2498022 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_5                                                   0.0                                             0
2498024 2498024 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_5                                                   0.0                                             0
2498026 2498026 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498027 2498027 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000046 30 Buena Regional Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498028 2498028 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000048 45 Collings Lakes Elementary School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2498029 2498029 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000052 55 John C. Milanesi Elementary School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2498031 2498031 NJ Atlantic 1 school 3404530 1300   Egg Harbor City 340453000074 20 Charles L. Spragg School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2498033 2498033 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456005961 5 Egg Harbor Township High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498034 2498034 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000086 33 Clayton J. Davenport Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2498035 2498035 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000051 35 E. H. Slaybaugh Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2498036 2498036 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002953 38 Alder Avenue Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498037 2498037 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002955 39 Fernwood Avenue Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498039 2498039 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000092 50 H. Russel Swift Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2498043 2498043 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000383 16 Galloway Township Middle School   Regular School No Middle 07 08 2020   grade_5                                                   0.0                                             0
2498044 2498044 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000114 40 Pomona Preschool   Special Education School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2498048 2498048 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498049 2498049 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000124 50 Oakcrest High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498050 2498050 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606003115 60 Cedar Creek High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498052 2498052 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651000130 60 Joseph C Shaner Memorial Elementary School   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2498053 2498053 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651006029 120 William Davies Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498054 2498054 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2498055 2498055 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000136 50 Hammonton High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498057 2498057 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000140 60 Hammonton Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498059 2498059 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000150 50 Seaview Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498060 2498060 NJ Atlantic 1 school 3409360 2910   Mainland Regional 340936000158 50 Mainland Regional High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498062 2498062 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498063 2498063 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000172 20 Mullica Township Primary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498066 2498066 NJ Atlantic 1 school 3411790 3720   Northfield City 341179000217 57 Northfield Community Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498067 2498067 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000192 50 Pleasantville High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498068 2498068 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000219 55 Pleasantville Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498074 2498074 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000208 50 Dawes Avenue Elementary School   Regular School No Elementary KG 03 2020   grade_5                                                   0.0                                             0
2498076 2498076 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000533 60 New York Avenue Elementary School   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2498078 2498078 NJ Atlantic 1 school 3416680 5350   Ventnor City 341668000407 45 Ventnor Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498081 2498081 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000226 20 Hillside Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2498087 2498087 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000240 70 Life Skills   Special Education School No Other PK 12 2020   grade_5                                                   0.0                                             0
2498088 2498088 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000073 100 Autistic   Special Education School No Other PK 12 2020   grade_5                                                   0.0                                             0
2498089 2498089 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_5                                                   0.0                                             0
2498090 2498090 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_5                                                   0.0                                             0
2498091 2498091 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_5                                                   0.0                                             0
2498092 2498092 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_5                                                   0.0                                             0
2498093 2498093 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_5                                                   0.0                                             0
2498094 2498094 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000268 20 Bergenfield High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498099 2498099 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000278 75 Roy W. Brown Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498101 2498101 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000284 20 Bogota Jr./Sr. High School   Regular School No High 07 12 2020   grade_5                                                   0.0                                             0
2498105 2498105 NJ Bergen 3 school 3402800 745   Carlstadt-East Rutherford 340280000300 50 Henry P. Becton Regional High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498106 2498106 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000304 30 Cliffside Park High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498107 2498107 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000306 50 School #3   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498109 2498109 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000310 70 School #5   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498111 2498111 NJ Bergen 3 school 3403390 930   Closter Boro 340339000316 50 Hillside Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498113 2498113 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000324 40 Cresskill High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498114 2498114 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498117 2498117 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000332 30 County Road School   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2498119 2498119 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381006085 50 Luther Lee Emerson School   Regular School No Elementary 02 04 2020   grade_5                                                   0.0                                             0
2498120 2498120 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000340 40 Dumont High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498126 2498126 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000474 80 Mckenzie School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498128 2498128 NJ Bergen 3 school 3404440 1270   Edgewater Boro 340444003211 300 George Washington School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2498129 2498129 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000368 50 Memorial Senior High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498130 2498130 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000075 60 Memorial Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498134 2498134 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000380 50 Emerson Jr Sr High   Regular School No High 07 12 2020   grade_5                                                   0.0                                             0
2498136 2498136 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000384 70 Memorial School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2498137 2498137 NJ Bergen 3 school 3404740 1370   Englewood City 340474000388 40 Dwight Morrow High School/Academies@Englewood   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498139 2498139 NJ Bergen 3 school 3404740 1370   Englewood City 340474000392 70 Donald A. Quarles Early Childhood Center   Regular School No Elementary PK KG 2020   grade_5                                                   0.0                                             0
2498140 2498140 NJ Bergen 3 school 3404740 1370   Englewood City 340474000394 76 Janis E. Dismus Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498141 2498141 NJ Bergen 3 school 3404740 1370   Englewood City 340474003063 86 Dr. John Grieco Elementary School   Regular School No Elementary 01 02 2020   grade_5                                                   0.0                                             0
2498142 2498142 NJ Bergen 3 school 3404770 1380   Englewood Cliffs Boro 340477000402 40 North Cliff School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2498144 2498144 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000410 50 Fair Lawn High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498145 2498145 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000053 60 Thomas Jefferson Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498146 2498146 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000414 70 Memorial Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498154 2498154 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000256 65 Lincoln School Annex   Regular School No Elementary PK KG 2020   grade_5                                                   0.0                                             0
2498155 2498155 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000438 80 Number Three School   Regular School No Elementary KG 04 2020   grade_5                                                   0.0                                             0
2498156 2498156 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000442 50 Fort Lee High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498157 2498157 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000444 60 School No. 1   Regular School No Elementary KG 04 2020   grade_5                                                   0.0                                             0
2498158 2498158 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000446 70 School No. 2   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498159 2498159 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000448 80 School No. 3   Regular School No Elementary KG 04 2020   grade_5                                                   0.0                                             0
2498160 2498160 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000450 90 School No. 4   Regular School No Elementary KG 04 2020   grade_5                                                   0.0                                             0
2498162 2498162 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000117 15 Franklin Avenue Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498166 2498166 NJ Bergen 3 school 3405760 1700   Garfield City 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2498167 2498167 NJ Bergen 3 school 3405760 1700   Garfield City 340576000466 50 Garfield High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498169 2498169 NJ Bergen 3 school 3405760 1700   Garfield City 340576000470 70 Garfield Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498171 2498171 NJ Bergen 3 school 3405760 1700   Garfield City 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2498177 2498177 NJ Bergen 3 school 3405760 1700   Garfield City 340576003431 302 Garfield Public Preschool 3 At Headstart   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2498178 2498178 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000484 50 Glen Rock High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498179 2498179 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000077 60 Glen Rock Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498184 2498184 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000496 50 Hackensack High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498185 2498185 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000498 90 Nellie K. Parker   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498186 2498186 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000500 100 Fairmount   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498187 2498187 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000502 110 Fanny Meyer Hillers   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498188 2498188 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000504 120 Jackson Avenue   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498191 2498191 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000512 50 Hasbrouck Heights High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498192 2498192 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000491 55 Hasbrouck Heights Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498196 2498196 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2020   grade_5                                                   0.0                                             0
2498198 2498198 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000528 30 Meadowbrook   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498200 2498200 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000534 50 Leonia High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2498201 2498201 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000536 55 Leonia Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2498204 2498204 NJ Bergen 3 school 3408760 2710   Little Ferry Boro 340876000544 50 Washington Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2498205 2498205 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000550 50 Lodi High School   Regular School No High 09 12 2020   grade_5                                                   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]);