enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_5", state = "NJ" and year = 2020 sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • grade_5 · 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
2500384 2500384 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   grade_5                                                   33.0                                             33
2500385 2500385 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2500386 2500386 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   grade_5                                                   24.0                                             24
2500387 2500387 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500388 2500388 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   grade_5                                                   25.0                                             25
2500389 2500389 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   grade_5                                                   66.0                                             66
2500390 2500390 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   grade_5                                                   22.0                                             22
2500391 2500391 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   grade_5                                                   23.0                                             23
2500392 2500392 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_5                                                   63.0                                             63
2500393 2500393 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_5                                                   0.0                                             0
2500394 2500394 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   grade_5                                                   75.0                                             75
2500395 2500395 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2500396 2500396 NJ Warren 41 school 3406300 1870   Hackettstown 340630005814 50 Hackettstown High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500397 2500397 NJ Warren 41 school 3406300 1870   Hackettstown 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2020   grade_5                                                   112.0                                             112
2500398 2500398 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2500399 2500399 NJ Warren 41 school 3406300 1870   Hackettstown 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2020   grade_5                                                   0.0                                             0
2500400 2500400 NJ Warren 41 school 3406810 2040   Harmony Twp 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2020   grade_5                                                   19.0                                             19
2500401 2500401 NJ Warren 41 school 3407470 2250   Hope Twp 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2020   grade_5                                                   10.0                                             10
2500402 2500402 NJ Warren 41 school 3408070 2470   Knowlton Twp 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2020   grade_5                                                   19.0                                             19
2500403 2500403 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2020   grade_5                                                   0.0                                             0
2500404 2500404 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2020   grade_5                                                   88.0                                             88
2500405 2500405 NJ Warren 41 school 3409540 2970   Mansfield Twp 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2020   grade_5                                                   72.0                                             72
2500406 2500406 NJ Warren 41 school 3409550 3675   North Warren Regional 340955005844 50 North Warren Regional School   Regular School No High 07 12 2020   grade_5                                                   0.0                                             0
2500407 2500407 NJ Warren 41 school 3412300 3890   Oxford Twp 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2020   grade_5                                                   31.0                                             31
2500408 2500408 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500409 2500409 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   grade_5                                                   0.0                                             0
2500410 2500410 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   grade_5                                                   221.0                                             221
2500411 2500411 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2500412 2500412 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2500413 2500413 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   grade_5                                                   35.0                                             35
2500414 2500414 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   grade_5                                                   0.0                                             0
2500415 2500415 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500416 2500416 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   grade_5                                                   0.0                                             0
2500417 2500417 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   grade_5                                                   73.0                                             73
2500418 2500418 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2500419 2500419 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   grade_5                                                   54.0                                             54
2500420 2500420 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   grade_5                                                   0.0                                             0
2500421 2500421 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   grade_5                                                   27.0                                             27
2500213 2500213 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500214 2500214 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   grade_5                                                   77.0                                             77
2500215 2500215 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005436 30 Columbia Middle School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2500216 2500216 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2500217 2500217 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005440 40 Mountain Park School   Regular School No Elementary 02 05 2020   grade_5                                                   57.0                                             57
2500218 2500218 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005442 50 William Woodruff School   Regular School No Elementary 02 05 2020   grade_5                                                   58.0                                             58
2500219 2500219 NJ Union 39 school 3403150 850   Clark Twp 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500220 2500220 NJ Union 39 school 3403150 850   Clark Twp 340315005450 30 Frank K. Hehnly   Regular School No Elementary KG 05 2020   grade_5                                                   101.0                                             101
2500221 2500221 NJ Union 39 school 3403150 850   Clark Twp 340315005452 35 Carl H. Kumpf School   Regular School No Middle 06 08 2020   grade_5                                                   0.0                                             0
2500222 2500222 NJ Union 39 school 3403150 850   Clark Twp 340315005454 40 Valley Road School   Regular School No Elementary KG 05 2020   grade_5                                                   75.0                                             75
2500223 2500223 NJ Union 39 school 3403150 850   Clark Twp 340315003295 300 Clark Preschool Annex   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2500224 2500224 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500225 2500225 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_5                                                   59.0                                             59
2500226 2500226 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_5                                                   82.0                                             82
2500227 2500227 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_5                                                   0.0                                             0
2500228 2500228 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_5                                                   62.0                                             62
2500229 2500229 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_5                                                   84.0                                             84
2500230 2500230 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_5                                                   0.0                                             0
2500231 2500231 NJ Union 39 school 3404590 1320   Elizabeth City 340459005478 25 Elizabeth High School - Frank J Cicarell Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500232 2500232 NJ Union 39 school 3404590 1320   Elizabeth City 340459000013 30 Terence C. Reilly School No 7   Regular School No Middle 02 08 2020   grade_5                                                   142.0                                             142
2500233 2500233 NJ Union 39 school 3404590 1320   Elizabeth City 340459005482 35 Joseph Battin School No 4   Regular School No Elementary KG 08 2020   grade_5                                                   81.0                                             81
2500234 2500234 NJ Union 39 school 3404590 1320   Elizabeth City 340459005492 90 George Washington Academy School No. 1   Regular School No Elementary PK 08 2020   grade_5                                                   41.0                                             41
2500235 2500235 NJ Union 39 school 3404590 1320   Elizabeth City 340459005494 100 Winfield Scott School No. 2   Regular School No Elementary PK 08 2020   grade_5                                                   65.0                                             65
2500236 2500236 NJ Union 39 school 3404590 1320   Elizabeth City 340459005962 110 Nicholas S. Lacorte-Peterstown School No. 3   Regular School No Elementary KG 08 2020   grade_5                                                   81.0                                             81
2500237 2500237 NJ Union 39 school 3404590 1320   Elizabeth City 340459005498 120 Toussaint Louverture-Marquis De Lafayette School No. 6   Regular School No Elementary PK 08 2020   grade_5                                                   110.0                                             110
2500238 2500238 NJ Union 39 school 3404590 1320   Elizabeth City 340459005504 150 Elmora School No. 12   Regular School No Elementary PK 08 2020   grade_5                                                   72.0                                             72
2500239 2500239 NJ Union 39 school 3404590 1320   Elizabeth City 340459005506 160 Benjamin Franklin School No. 13   Regular School No Elementary KG 08 2020   grade_5                                                   48.0                                             48
2500240 2500240 NJ Union 39 school 3404590 1320   Elizabeth City 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2020   grade_5                                                   92.0                                             92
2500241 2500241 NJ Union 39 school 3404590 1320   Elizabeth City 340459005510 180 Christopher Columbus School No. 15   Regular School No Elementary KG 08 2020   grade_5                                                   82.0                                             82
2500242 2500242 NJ Union 39 school 3404590 1320   Elizabeth City 340459005512 190 Madison Monroe School No. 16   Regular School No Elementary PK 08 2020   grade_5                                                   37.0                                             37
2500243 2500243 NJ Union 39 school 3404590 1320   Elizabeth City 340459005516 210 Robert Morris School No. 18   Regular School No Elementary PK 08 2020   grade_5                                                   61.0                                             61
2500244 2500244 NJ Union 39 school 3404590 1320   Elizabeth City 340459005518 220 Woodrow Wilson School No. 19   Regular School No Elementary PK 08 2020   grade_5                                                   60.0                                             60
2500245 2500245 NJ Union 39 school 3404590 1320   Elizabeth City 340459005520 230 John Marshal School No. 20   Regular School No Elementary KG 08 2020   grade_5                                                   40.0                                             40
2500246 2500246 NJ Union 39 school 3404590 1320   Elizabeth City 340459005522 240 Victor Mravlag School No. 21   Regular School No Elementary PK 08 2020   grade_5                                                   50.0                                             50
2500247 2500247 NJ Union 39 school 3404590 1320   Elizabeth City 340459005524 250 William F. Halloran School No.22   Regular School No Middle 02 08 2020   grade_5                                                   144.0                                             144
2500248 2500248 NJ Union 39 school 3404590 1320   Elizabeth City 340459005526 260 Nicholas Murray Butler Academy School No. 23   Regular School No Elementary KG 08 2020   grade_5                                                   83.0                                             83
2500249 2500249 NJ Union 39 school 3404590 1320   Elizabeth City 340459000207 280 Sonia Sotomayor School No 25   Regular School No Elementary KG 08 2020   grade_5                                                   71.0                                             71
2500250 2500250 NJ Union 39 school 3404590 1320   Elizabeth City 340459000245 290 Dr. Orlando Edreira Academy School No. 26   Regular School No Elementary PK 08 2020   grade_5                                                   63.0                                             63
2500251 2500251 NJ Union 39 school 3404590 1320   Elizabeth City 340459000806 295 Dr. Albert Einstein Academy School No. 29   Regular School No Elementary PK 08 2020   grade_5                                                   64.0                                             64
2500252 2500252 NJ Union 39 school 3404590 1320   Elizabeth City 340459000071 300 Mabel G. Homes School No. 5   Regular School No Elementary PK 08 2020   grade_5                                                   64.0                                             64
2500253 2500253 NJ Union 39 school 3404590 1320   Elizabeth City 340459003197 301 Iprep Academy School No 8   Regular School No Elementary KG 08 2020   grade_5                                                   47.0                                             47
2500254 2500254 NJ Union 39 school 3404590 1320   Elizabeth City 340459003293 302 Jerome Dunn Academy No 9   Regular School No Elementary KG 08 2020   grade_5                                                   94.0                                             94
2500255 2500255 NJ Union 39 school 3404590 1320   Elizabeth City 340459003389 303 J. Christian Bollwage Finance Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500256 2500256 NJ Union 39 school 3404590 1320   Elizabeth City 340459000825 305 Chessie Dentley Roberts Academy School No. 30   Regular School No Elementary PK 08 2020   grade_5                                                   72.0                                             72
2500257 2500257 NJ Union 39 school 3404590 1320   Elizabeth City 340459002997 310 Dr. Antonia Pantoja School No. 27   Regular School No Elementary PK 08 2020   grade_5                                                   85.0                                             85
2500258 2500258 NJ Union 39 school 3404590 1320   Elizabeth City 340459002983 315 Juan Pablo Duarte - Jose Julian Marti School No 28   Regular School No Elementary PK 08 2020   grade_5                                                   92.0                                             92
2500259 2500259 NJ Union 39 school 3404590 1320   Elizabeth City 340459000467 350 Frances C. Smith Early Childhood Center No 50   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2500260 2500260 NJ Union 39 school 3404590 1320   Elizabeth City 340459006131 355 Donald Stewart Early Childhood Center No 51   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2500261 2500261 NJ Union 39 school 3404590 1320   Elizabeth City 340459000567 360 Dr. Martin Luther King Jr. Early Childhood Center No 52   Regular School No Prekindergarten PK PK 2020   grade_5                                                   0.0                                             0
2500262 2500262 NJ Union 39 school 3404590 1320   Elizabeth City 340459003071 401 John E. Dwyer Technology Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500263 2500263 NJ Union 39 school 3404590 1320   Elizabeth City 340459003039 402 Admiral William F. Halsey Jr. Health & Public Safety Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500264 2500264 NJ Union 39 school 3404590 1320   Elizabeth City 340459003049 403 Thomas Jefferson Arts Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500265 2500265 NJ Union 39 school 3404590 1320   Elizabeth City 340459003045 404 Thomas A. Edison Career And Technical Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500266 2500266 NJ Union 39 school 3404590 1320   Elizabeth City 340459003043 405 Alexander Hamilton Preparatory Academy   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500267 2500267 NJ Union 39 school 3405790 1710   Garwood Boro 340579005532 50 Lincoln   Regular School No Elementary PK 08 2020   grade_5                                                   46.0                                             46
2500268 2500268 NJ Union 39 school 3407290 2190   Hillside Twp 340729005540 50 Hillside High School   Regular School No High 09 12 2020   grade_5                                                   0.0                                             0
2500269 2500269 NJ Union 39 school 3407290 2190   Hillside Twp 340729005542 60 Calvin Coolidge School   Regular School No Elementary 02 06 2020   grade_5                                                   58.0                                             58
2500270 2500270 NJ Union 39 school 3407290 2190   Hillside Twp 340729005544 80 Hurden Looker School   Regular School No Elementary 02 06 2020   grade_5                                                   78.0                                             78
2500271 2500271 NJ Union 39 school 3407290 2190   Hillside Twp 340729005546 85 Walter O. Krumbiegel Middle School   Regular School No Middle 07 08 2020   grade_5                                                   0.0                                             0
2500272 2500272 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_5                                                   0.0                                             0
2500273 2500273 NJ Union 39 school 3407290 2190   Hillside Twp 340729005550 110 George Washington School   Regular School No Elementary 02 06 2020   grade_5                                                   88.0                                             88
2500274 2500274 NJ Union 39 school 3407920 2420   Kenilworth Boro 340792000209 10 David Brearley Middle/High School   Regular School No High 07 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]);