enrollments

Data source: Big Local News · About: Big Local

5,007 rows where grade = "grade_7" and state = "NJ" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_7 · 4,907 ✖
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 ▼
2398115 2398115 NJ Bergen 3 school 3405370 1580   Franklin Lakes School District 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398117 2398117 NJ Bergen 3 school 3405370 1580   Franklin Lakes School District 340537000462 30 Woodside Avenue School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398118 2398118 NJ Bergen 3 school 3405370 1580   Franklin Lakes School District 340537000532 40 Colonial Road School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398119 2398119 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   grade_7                                                   0.0                                             0
2398120 2398120 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398121 2398121 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000480 130 Woodrow Wilson School #5   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398122 2398122 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000476 100 Roosevelt School #7   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398123 2398123 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000468 60 Christopher Columbus School #8   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398124 2398124 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2021   grade_7                                                   0.0                                             0
2398126 2398126 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576003431 302 Garfield Public Preschool 3 At Headstart   Regular School No Prekindergarten PK PK 2021   grade_7                                                   0.0                                             0
2398127 2398127 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576003443 300 Thomas Jefferson School #9   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398128 2398128 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000478 120 Washington Irving School #4   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398129 2398129 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000466 50 Garfield High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398130 2398130 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000387 205 James Madison School #10   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398132 2398132 NJ Bergen 3 school 3405970 1760   Glen Rock Public School District 340597000488 80 Central School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398133 2398133 NJ Bergen 3 school 3405970 1760   Glen Rock Public School District 340597000490 90 Clara E Coleman School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398134 2398134 NJ Bergen 3 school 3405970 1760   Glen Rock Public School District 340597000484 50 Glen Rock High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398135 2398135 NJ Bergen 3 school 3405970 1760   Glen Rock Public School District 340597000486 70 Richard Byrd   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398136 2398136 NJ Bergen 3 school 3405970 1760   Glen Rock Public School District 340597000482 65 Alexander Hamilton School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398137 2398137 NJ Bergen 3 school 3406270 1860   Hackensack School District 340627000498 90 Nellie K. Parker   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398138 2398138 NJ Bergen 3 school 3406270 1860   Hackensack School District 340627000496 50 Hackensack High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398139 2398139 NJ Bergen 3 school 3406270 1860   Hackensack School District 340627000500 100 Fairmount   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398141 2398141 NJ Bergen 3 school 3406270 1860   Hackensack School District 340627000502 110 Fanny Meyer Hillers   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398142 2398142 NJ Bergen 3 school 3406270 1860   Hackensack School District 340627000504 120 Jackson Avenue   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398144 2398144 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights School District 340693000514 60 Euclid Elementary School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398145 2398145 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights School District 340693000518 80 Lincoln Elementary School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398146 2398146 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights School District 340693000512 50 Hasbrouck Heights High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398150 2398150 NJ Bergen 3 school 3407260 2180   Hillsdale School District 340726000528 30 Meadowbrook   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398151 2398151 NJ Bergen 3 school 3407260 2180   Hillsdale School District 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2021   grade_7                                                   0.0                                             0
2398154 2398154 NJ Bergen 3 school 3408520 2620   Leonia Public School District 340852000534 50 Leonia High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398155 2398155 NJ Bergen 3 school 3408520 2620   Leonia Public School District 340852000538 60 Anna C. Scott Elementary School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398157 2398157 NJ Bergen 3 school 3408760 2710   Little Ferry Public School District 340876000544 50 Washington Elementary School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398158 2398158 NJ Bergen 3 school 3408850 2740   Lodi School District 340885000554 65 Hilltop School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398160 2398160 NJ Bergen 3 school 3408850 2740   Lodi School District 340885000564 100 Wilson School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398161 2398161 NJ Bergen 3 school 3408850 2740   Lodi School District 340885000562 90 Washington School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398162 2398162 NJ Bergen 3 school 3408850 2740   Lodi School District 340885005975 80 Roosevelt School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398163 2398163 NJ Bergen 3 school 3408850 2740   Lodi School District 340885000550 50 Lodi High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398164 2398164 NJ Bergen 3 school 3408850 2740   Lodi School District 340885000552 60 Columbus School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398166 2398166 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921000582 120 Washington School   Regular School No Elementary PK 02 2021   grade_7                                                   0.0                                             0
2398167 2398167 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921000574 80 Jefferson School   Regular School No Elementary 03 05 2021   grade_7                                                   0.0                                             0
2398168 2398168 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921000580 110 Roosevelt School   Regular School No Elementary 03 05 2021   grade_7                                                   0.0                                             0
2398169 2398169 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921000572 70 Franklin School   Regular School No Elementary KG 02 2021   grade_7                                                   0.0                                             0
2398170 2398170 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921000570 60 Columbus School   Regular School No Elementary KG 02 2021   grade_7                                                   0.0                                             0
2398171 2398171 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921003471 301 Community   Regular School No Prekindergarten PK PK 2021   grade_7                                                   0.0                                             0
2398172 2398172 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921000568 50 Lyndhurst High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398173 2398173 NJ Bergen 3 school 3409330 2900   Mahwah Township Public School District 340933000592 75 Joyce Kilmer School   Regular School No Elementary 04 05 2021   grade_7                                                   0.0                                             0
2398174 2398174 NJ Bergen 3 school 3409330 2900   Mahwah Township Public School District 340933000588 60 Betsy Ross Elementary   Regular School No Elementary KG 03 2021   grade_7                                                   0.0                                             0
2398175 2398175 NJ Bergen 3 school 3409330 2900   Mahwah Township Public School District 340933000492 65 Lenape Meadows   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2398176 2398176 NJ Bergen 3 school 3409330 2900   Mahwah Township Public School District 340933000596 80 George Washington School   Regular School No Elementary KG 03 2021   grade_7                                                   0.0                                             0
2398177 2398177 NJ Bergen 3 school 3409330 2900   Mahwah Township Public School District 340933000586 50 Mahwah High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398179 2398179 NJ Bergen 3 school 3409810 3060   Maywood School District 340981000604 70 Memorial School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2398181 2398181 NJ Bergen 3 school 3410140 3170   Midland Park School District 341014000612 70 Highland Elementary School   Regular School No Elementary 03 06 2021   grade_7                                                   0.0                                             0
2398183 2398183 NJ Bergen 3 school 3410140 3170   Midland Park School District 341014003209 300 Godwin Elementary School   Regular School No Elementary PK 02 2021   grade_7                                                   0.0                                             0
2398185 2398185 NJ Bergen 3 school 3410620 3330   Montvale Board Of Education School District 341062000618 30 Memorial Elementary School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398187 2398187 NJ Bergen 3 school 3411280 3550   New Milford Public School District 341128000628 70 Bertrand F. Gibbs Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398189 2398189 NJ Bergen 3 school 3411280 3550   New Milford Public School District 341128000626 60 Berkley Street School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398190 2398190 NJ Bergen 3 school 3411280 3550   New Milford Public School District 341128000624 50 New Milford High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398191 2398191 NJ Bergen 3 school 3411430 3600   North Arlington School District 341143000640 70 Roosevelt Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398192 2398192 NJ Bergen 3 school 3411430 3600   North Arlington School District 341143000638 60 Jefferson Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398193 2398193 NJ Bergen 3 school 3411430 3600   North Arlington School District 341143003492 300 North Arlington Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398194 2398194 NJ Bergen 3 school 3411430 3600   North Arlington School District 341143000636 50 North Arlington High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398195 2398195 NJ Bergen 3 school 3411430 3600   North Arlington School District 341143000642 80 Washington Elementary School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398197 2398197 NJ Bergen 3 school 3411730 3700   Northern Highlands Regional High School District 341173000646 50 Northern Highlands Regional High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398198 2398198 NJ Bergen 3 school 3411760 3710   Northern Valley Regional High School District 341176000650 50 Northern Valley Regional High School At Demarest   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398199 2398199 NJ Bergen 3 school 3411760 3710   Northern Valley Regional High School District 341176000652 60 Northern Valley Regional High School At Old Tappan   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398200 2398200 NJ Bergen 3 school 3411760 3710   Northern Valley Regional High School District 341176003359 300 Northern Valley Central   Special Education School No High 09 12 2021   grade_7                                                   0.0                                             0
2398203 2398203 NJ Bergen 3 school 3411910 3760   Oakland Public School District 341191000664 40 Dogwood Hill Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398205 2398205 NJ Bergen 3 school 3411910 3760   Oakland Public School District 341191000668 60 Manito Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398206 2398206 NJ Bergen 3 school 3411910 3760   Oakland Public School District 341191000666 50 Heights Elementary School   Regular School No Elementary PK 05 2021   grade_7                                                   0.0                                             0
2398208 2398208 NJ Bergen 3 school 3412180 3850   Old Tappan Public School District 341218000676 60 T. Baldwin Demarest Elementary School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398209 2398209 NJ Bergen 3 school 3412240 3870   Oradell Public School District 341224000678 50 Oradell Public School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2398211 2398211 NJ Bergen 3 school 3412360 3910   Palisades Park School District 341236000789 80 Charles R Smith Early Chilhood Center   Regular School No Elementary PK KG 2021   grade_7                                                   0.0                                             0
2398212 2398212 NJ Bergen 3 school 3412360 3910   Palisades Park School District 341236000684 70 Lindbergh Elementary School   Regular School No Elementary 01 06 2021   grade_7                                                   0.0                                             0
2398214 2398214 NJ Bergen 3 school 3412420 3930   Paramus Public School District 341242000700 100 Parkway Elementary School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398215 2398215 NJ Bergen 3 school 3412420 3930   Paramus Public School District 341242000706 130 Stony Lane Elementary School   Regular School No Elementary KG 04 2021   grade_7                                                   0.0                                             0
2398216 2398216 NJ Bergen 3 school 3412420 3930   Paramus Public School District 341242000400 90 Midland Elementary School   Regular School No Elementary KG 04 2021   grade_7                                                   0.0                                             0
2398217 2398217 NJ Bergen 3 school 3412420 3930   Paramus Public School District 341242000688 50 Paramus High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398218 2398218 NJ Bergen 3 school 3412420 3930   Paramus Public School District 341242000702 110 Ridge Ranch Elementary School   Regular School No Elementary KG 04 2021   grade_7                                                   0.0                                             0
2398219 2398219 NJ Bergen 3 school 3412420 3930   Paramus Public School District 341242000696 80 Memorial Elementary School   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398221 2398221 NJ Bergen 3 school 3412450 3940   Park Ridge School District 341245000712 60 East Brook Elementary School   Regular School No Elementary KG 06 2021   grade_7                                                   0.0                                             0
2398223 2398223 NJ Bergen 3 school 3412450 3940   Park Ridge School District 341245000714 70 West Ridge Elementary School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2398224 2398224 NJ Bergen 3 school 3412510 3960   Pascack Valley Regional High School District 341251000718 40 Pascack Hills High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398225 2398225 NJ Bergen 3 school 3412510 3960   Pascack Valley Regional High School District 341251000720 50 Pascack Valley High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398226 2398226 NJ Bergen 3 school 3413560 4300   Ramapo Indian Hills Regional High School District 341356000724 30 Indian Hills High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398227 2398227 NJ Bergen 3 school 3413560 4300   Ramapo Indian Hills Regional High School District 341356000726 50 Ramapo High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398228 2398228 NJ Bergen 3 school 3413590 4310   Ramsey School District 341359000738 80 Wesley D Tisdale Elementary School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2398229 2398229 NJ Bergen 3 school 3413590 4310   Ramsey School District 341359000736 70 Mary A. Hubbard Elementary School   Regular School No Elementary PK 03 2021   grade_7                                                   0.0                                             0
2398230 2398230 NJ Bergen 3 school 3413590 4310   Ramsey School District 341359000730 50 Ramsey High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398232 2398232 NJ Bergen 3 school 3413590 4310   Ramsey School District 341359000734 60 John Y Dater Elementary School   Regular School No Elementary 04 05 2021   grade_7                                                   0.0                                             0
2398233 2398233 NJ Bergen 3 school 3413770 4370   Ridgefield School District 341377006057 65 Bergen Boulevard School   Regular School No Elementary KG 04 2021   grade_7                                                   0.0                                             0
2398234 2398234 NJ Bergen 3 school 3413770 4370   Ridgefield School District 341377000078 90 Shaler Academy   Regular School No Elementary PK 04 2021   grade_7                                                   0.0                                             0
2398236 2398236 NJ Bergen 3 school 3413770 4370   Ridgefield School District 341377000742 50 Ridgefield Memorial High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398237 2398237 NJ Bergen 3 school 3413800 4380   Ridgefield Park Public School District 341380000756 60 Grant Elementary School   Regular School No Elementary KG 06 2021   grade_7                                                   0.0                                             0
2398238 2398238 NJ Bergen 3 school 3413800 4380   Ridgefield Park Public School District 341380000760 80 Roosevelt Elementary School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2398239 2398239 NJ Bergen 3 school 3413800 4380   Ridgefield Park Public School District 341380000257 70 Lincoln Elementary School   Regular School No Elementary PK 06 2021   grade_7                                                   0.0                                             0
2398241 2398241 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000782 130 Willard Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398242 2398242 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000221 80 Glen School   Regular School No Prekindergarten PK PK 2021   grade_7                                                   0.0                                             0
2398244 2398244 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000764 50 Ridgewood High School   Regular School No High 09 12 2021   grade_7                                                   0.0                                             0
2398246 2398246 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000772 85 Hawes Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   0.0                                             0
2398247 2398247 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000774 90 Ridge Elementary School   Regular School No Elementary KG 05 2021   grade_7                                                   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]);