enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_7", state = "NJ" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • grade_7 · 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
2505004 2505004 NJ Passaic 31 school 3412690 4010   Paterson City 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
2504538 2504538 NJ Monmouth 25 school 3408940 2770   Long Branch City 340894003908 65 A A Anastasia Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504352 2504352 NJ Middlesex 23 school 3411220 3530   New Brunswick City 341122003456 60 A Chester Redshaw School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2503530 2503530 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300001422 58 A. Russell Knight Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2503611 2503611 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_7                                                   2.0                                             2
2505276 2505276 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_7                                                   0.0                                             0
2504651 2504651 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2503834 2503834 NJ Essex 13 school 3411340 3570   Newark City 341134002222 170 Abington Avenue School   Regular School No Elementary PK 08 2020   grade_7                                                   90.0                                             90
2505318 2505318 NJ Union 39 school 3414280 4540   Roselle Boro 341428005650 10 Abraham Clark High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503358 2503358 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2503174 2503174 NJ Bergen 3 school 3405760 1700   Garfield City 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2505244 2505244 NJ Union 39 school 3404590 1320   Elizabeth City 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2020   grade_7                                                   98.0                                             98
2503052 2503052 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505426 2505426 NJ Charters 80 school 3400048 6010   Academy Charter High School 340004800335 910 Academy Charter High School   Regular School Yes High 09 12 2020   grade_7                                                   0.0                                             0
2505359 2505359 NJ Union 39 school 3418040 5260   Union County Vocational 341804000584 20 Academy For Allied Health Sciences   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2504717 2504717 NJ Morris 27 school 3410720 3365   Morris County Vocational 341072003418 301 Academy For Biotechnology   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2504716 2504716 NJ Morris 27 school 3410720 3365   Morris County Vocational 341072003375 300 Academy For Environmental Science   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2505360 2505360 NJ Union 39 school 3418040 5260   Union County Vocational 341804006134 30 Academy For Information Technology   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2504714 2504714 NJ Morris 27 school 3410720 3365   Morris County Vocational 341072000522 20 Academy For Mathematics Science And Engineering   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2504718 2504718 NJ Morris 27 school 3410720 3365   Morris County Vocational 341072003439 302 Academy For Performing Arts   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2505361 2505361 NJ Union 39 school 3418040 5260   Union County Vocational 341804003009 35 Academy For Performing Arts   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2505438 2505438 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_7                                                   61.0                                             61
2504056 2504056 NJ Hudson 17 school 3407830 2390   Jersey City 340783000142 95 Academy I   Regular School No Middle 06 08 2020   grade_7                                                   144.0                                             144
2504329 2504329 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018005951 30 Academy Learning Center   Special Education School No Other PK 12 2020   grade_7                                                   1.0                                             1
2504045 2504045 NJ Hudson 17 school 3407570 2295   Hudson County Vocational 340757003468 300 Academy Of Career And Technical Education   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2504600 2504600 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750003219 301 Academy Of Law & Public Safety   Career and Technical School No High 11 12 2020   grade_7                                                   0.0                                             0
2504046 2504046 NJ Hudson 17 school 3407570 2295   Hudson County Vocational 340757003198 304 Academy Of Technology Design   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2504666 2504666 NJ Morris 27 school 3403930 1110   Dover Town 340393004214 50 Academy Street Elementary School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2505469 2505469 NJ Charters 80 school 3400792 6110   Achieve Community Charter School 340079203419 902 Achieve Community Charter School   Regular School Yes Elementary KG 06 2020   grade_7                                                   0.0                                             0
2505506 2505506 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_7                                                   71.0                                             71
2505108 2505108 NJ Somerset 35 school 3402280 555   Bridgewater-Raritan Reg 340228005166 30 Adamsville Primary School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2504516 2504516 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000721 3 Adelphia Elementary School   Regular School No Elementary KG 02 2020   grade_7                                                   0.0                                             0
2505267 2505267 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_7                                                   0.0                                             0
2504368 2504368 NJ Middlesex 23 school 3409270 3845   Old Bridge Twp 340927003498 82 Alan B. Shepard Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504195 2504195 NJ Mercer 21 school 3406540 1950   Hamilton Twp 340654003094 70 Albert E Grice Middle School   Regular School No Middle 06 08 2020   grade_7                                                   281.0                                             281
2505035 2505035 NJ Passaic 31 school 3417280 5570   Wayne Twp 341728004970 78 Albert Payson Terhune Elementary   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2504127 2504127 NJ Hudson 17 school 3417580 5670   West New York Town 341758002946 80 Albio Sires Elementary School   Regular School No Elementary KG 06 2020   grade_7                                                   0.0                                             0
2503040 2503040 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002953 38 Alder Avenue Middle School   Regular School No Middle 06 08 2020   grade_7                                                   289.0                                             289
2504517 2504517 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003860 5 Aldrich Elementary School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2505139 2505139 NJ Somerset 35 school 3409630 3000   Manville Boro 340963005240 65 Alexander Batcho Intermediate School   Regular School No Middle 05 08 2020   grade_7                                                   113.0                                             113
2504079 2504079 NJ Hudson 17 school 3407830 2390   Jersey City 340783002830 320 Alexander D. Sullivan School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2503462 2503462 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001220 130 Alexander Denbo   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2504198 2504198 NJ Mercer 21 school 3406540 1950   Hamilton Twp 340654003100 85 Alexander Elementary School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2504725 2504725 NJ Morris 27 school 3410810 3385   Morris School District 341081004368 60 Alexander Hamilton   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2504976 2504976 NJ Passaic 31 school 3412690 4010   Paterson City 341269000353 43 Alexander Hamilton Academy   Regular School No Elementary KG 08 2020   grade_7                                                   43.0                                             43
2505270 2505270 NJ Union 39 school 3404590 1320   Elizabeth City 340459003043 405 Alexander Hamilton Preparatory Academy   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503184 2503184 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000482 65 Alexander Hamilton School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504131 2504131 NJ Hunterdon 19 school 3400690 20   Alexandria Twp 340069002954 5 Alexandria Middle School   Regular School No Middle 04 08 2020   grade_7                                                   60.0                                             60
2504797 2504797 NJ Morris 27 school 3417880 5770   Wharton Boro 341788004558 30 Alfred C. Mackinnon Middle School   Regular School No Middle 06 08 2020   grade_7                                                   101.0                                             101
2503514 2503514 NJ Camden 7 school 3402640 680   Camden City 340264001366 170 Alfred Cramer College Preparatory Lab School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2503129 2503129 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000352 40 Alfred S. Faust   Regular School No Middle 05 08 2020   grade_7                                                   87.0                                             87
2504726 2504726 NJ Morris 27 school 3410810 3385   Morris School District 341081004370 65 Alfred Vail School   Regular School No Elementary KG 02 2020   grade_7                                                   0.0                                             0
2504071 2504071 NJ Hudson 17 school 3407830 2390   Jersey City 340783002812 240 Alfred Zampella School   Regular School No Elementary PK 08 2020   grade_7                                                   103.0                                             103
2503506 2503506 NJ Camden 7 school 3402370 580   Brooklawn Boro 340237001340 10 Alice Costello Elementary School   Regular School No Elementary PK 08 2020   grade_7                                                   36.0                                             36
2503616 2503616 NJ Camden 7 school 3414430 4590   Runnemede Boro 341443001650 20 Aline Bingham Elementary School   Regular School No Elementary KG 03 2020   grade_7                                                   0.0                                             0
2505388 2505388 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   grade_7                                                   57.0                                             57
2505296 2505296 NJ Union 39 school 3411310 3560   New Providence Boro 341131005594 55 Allen W. Roberts School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2504634 2504634 NJ Monmouth 25 school 3416560 5310   Upper Freehold Regional 341656004124 50 Allentown High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504638 2504638 NJ Monmouth 25 school 3416890 5420   Wall Twp 341689004134 60 Allenwood Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2505057 2505057 NJ Salem 33 school 3400810 60   Alloway Twp 340081005028 20 Alloway Township School   Regular School No Elementary PK 08 2020   grade_7                                                   40.0                                             40
2505390 2505390 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   grade_7                                                   25.0                                             25
2503086 2503086 NJ Bergen 3 school 3400870 80   Alpine Boro 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2020   grade_7                                                   18.0                                             18
2505201 2505201 NJ Sussex 37 school 3415510 4960   Sparta Twp 341551005402 70 Alpine Elementary School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2503531 2503531 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300000223 60 Alternative High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504972 2504972 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_7                                                   0.0                                             0
2505084 2505084 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_7                                                   0.0                                             0
2503488 2503488 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   grade_7                                                   2.0                                             2
2503758 2503758 NJ Essex 13 school 3404230 1210   East Orange 340423000275 107 Althea Gibson Academy   Regular School No Elementary PK KG 2020   grade_7                                                   0.0                                             0
2503833 2503833 NJ Essex 13 school 3411340 3570   Newark City 341134000791 87 American History High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505130 2505130 NJ Somerset 35 school 3407230 2170   Hillsborough Twp 340723006068 33 Amsterdam Elementary School   Regular School No Elementary KG 04 2020   grade_7                                                   0.0                                             0
2505167 2505167 NJ Somerset 35 school 3416980 5470   Warren Twp 341698006106 40 Angelo L. Tomaso School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2503570 2503570 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603000131 100 Ann A. Mullen Middle School   Regular School No Middle 06 08 2020   grade_7                                                   289.0                                             289
2503200 2503200 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2020   grade_7                                                   0.0                                             0
2503835 2503835 NJ Essex 13 school 3411340 3570   Newark City 341134002228 200 Ann Street School   Regular School No Elementary PK 08 2020   grade_7                                                   148.0                                             148
2503206 2503206 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000538 60 Anna C. Scott Elementary School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2504031 2504031 NJ Hudson 17 school 3406240 1850   Guttenberg Town 340624002734 50 Anna L. Klein   Regular School No Elementary PK 08 2020   grade_7                                                   104.0                                             104
2503705 2503705 NJ Cumberland 11 school 3416800 5390   Vineland City 341680001910 65 Anthony Rossi Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504383 2504383 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293003534 70 Anthony V. Ceres Elementary School   Regular School No Elementary KG 04 2020   grade_7                                                   0.0                                             0
2505034 2505034 NJ Passaic 31 school 3417280 5570   Wayne Twp 341728000558 65 Anthony Wayne Middle School   Regular School No Middle 06 08 2020   grade_7                                                   238.0                                             238
2504349 2504349 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003229 300 Applegarth Elementary School   Regular School No Elementary 04 05 2020   grade_7                                                   0.0                                             0
2503097 2503097 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_7                                                   0.0                                             0
2505047 2505047 NJ Passaic 31 school 3417520 5650   West Milford Twp 341752004998 42 Apshawa Elementary School   Regular School No Elementary KG 06 2020   grade_7                                                   0.0                                             0
2504397 2504397 NJ Middlesex 23 school 3413050 4130   Piscataway Twp 341305003562 60 Arbor Elementary School   Regular School No Elementary 04 05 2020   grade_7                                                   0.0                                             0
2504518 2504518 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003862 10 Ardena Elementary School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2505223 2505223 NJ Union 39 school 3403150 850   Clark Twp 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504362 2504362 NJ Middlesex 23 school 3411490 3620   North Brunswick Twp 341149003482 55 Arthur M. Judd   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2505072 2505072 NJ Salem 33 school 3413110 4150   Pittsgrove Twp 341311005080 40 Arthur P. Schalick High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503046 2503046 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000108 15 Arthur Rann Elementary School   Regular School No Elementary KG 06 2020   grade_7                                                   0.0                                             0
2504684 2504684 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004266 28 Arthur Stanlick Elementary School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2503823 2503823 NJ Essex 13 school 3411340 3570   Newark City 341134002188 10 Arts High School   Regular School No High 08 12 2020   grade_7                                                   0.0                                             0
2504463 2504463 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003732 10 Asbury Park High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504561 2504561 NJ Monmouth 25 school 3409720 3030   Marlboro Twp 340972003954 70 Asher Holmes Elementary School   Regular School No Elementary 01 05 2020   grade_7                                                   0.0                                             0
2503628 2503628 NJ Camden 7 school 3417250 5560   Waterford Twp 341725001686 40 Atco Elementary School   Regular School No Elementary 01 02 2020   grade_7                                                   0.0                                             0
2504719 2504719 NJ Morris 27 school 3410720 3365   Morris County Vocational 341072003474 303 Athletic Training And Physical Therapy   Career and Technical School No High 09 12 2020   grade_7                                                   0.0                                             0
2503577 2503577 NJ Camden 7 school 3406330 1880   Haddon Heights Boro 340633001534 80 Atlantic Avenue   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2503014 2503014 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505445 2505445 NJ Charters 80 school 3400771 6060   Atlantic Community Charter School 340077103287 942 Atlantic Community Charter School   Regular School Yes Elementary KG 08 2020   grade_7                                                   24.0                                             24
2503026 2503026 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2503027 2503027 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_7                                                   4.0                                             4
2503028 2503028 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_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]);