enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_8", state = "NJ" and year = 2020 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,402 ✖

grade ✖

  • grade_8 · 2,402 ✖
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
2505669 2505669 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2505703 2505703 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   grade_8                                                   138.0                                             138
2505737 2505737 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   grade_8                                                   119.0                                             119
2505754 2505754 NJ Bergen 3 school 3411850 3740   Norwood Boro 341185000660 20 Norwood Public School   Regular School No Elementary PK 08 2020   grade_8                                                   66.0                                             66
2505861 2505861 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000942 20 Calvin Coolidge Elementary School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2505872 2505872 NJ Burlington 5 school 3402430 600   Burlington City 340243000966 20 Burlington City High School   Regular School No High 07 12 2020   grade_8                                                   102.0                                             102
2505915 2505915 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918000222 20 Bobby'S Run Elementary School   Regular School No Elementary 03 05 2020   grade_8                                                   0.0                                             0
2505983 2505983 NJ Burlington 5 school 3417730 5720   Westampton 341773001256 20 Holly Hills Elementary School   Regular School No Elementary PK 03 2020   grade_8                                                   0.0                                             0
2506000 2506000 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
2506002 2506002 NJ Camden 7 school 3401590 330   Berlin Boro 340159001324 20 Berlin Community School   Regular School No Elementary PK 08 2020   grade_8                                                   89.0                                             89
2506005 2506005 NJ Camden 7 school 3401770 390   Black Horse Pike Regional 340177001336 20 Highland Regional High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506059 2506059 NJ Camden 7 school 3405850 1720   Gibbsboro Boro 340585001490 20 Gibbsboro Elementary School   Regular School No Elementary PK 08 2020   grade_8                                                   28.0                                             28
2506063 2506063 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603001508 20 Blackwood Elementary School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2506102 2506102 NJ Camden 7 school 3410890 3420   Mount Ephraim Boro 341089001598 20 Raymond W. Kershaw School   Regular School No Middle 06 08 2020   grade_8                                                   30.0                                             30
2506118 2506118 NJ Camden 7 school 3414430 4590   Runnemede Boro 341443001650 20 Aline Bingham Elementary School   Regular School No Elementary KG 03 2020   grade_8                                                   0.0                                             0
2506121 2506121 NJ Camden 7 school 3415000 4790   Somerdale Boro 341500001660 20 Somerdale Park School   Regular School No Elementary PK 08 2020   grade_8                                                   52.0                                             52
2506125 2506125 NJ Camden 7 school 3416830 5400   Voorhees Twp 341683001676 20 Edward T. Hamilton   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2506134 2506134 NJ Camden 7 school 3418060 5820   Winslow Twp 341806000439 20 Winslow Township Middle School   Regular School No Middle 07 08 2020   grade_8                                                   381.0                                             381
2506144 2506144 NJ Cape May 9 school 3402740 715   Cape May Co Special Serv 340274001708 20 Cape May County High School   Special Education School No High 09 12 2020   grade_8                                                   0.0                                             0
2506173 2506173 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225001784 20 Bridgeton High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506219 2506219 NJ Essex 13 school 3401350 250   Belleville Town 340135001954 20 Belleville High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506228 2506228 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001980 20 Bloomfield High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506270 2506270 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2506326 2506326 NJ Essex 13 school 3411340 3570   Newark City 341134002190 20 Barringer High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506403 2506403 NJ Essex 13 school 3414250 4530   Roseland Boro 341425002418 20 Lester C Noecker   Regular School No Elementary PK 06 2020   grade_8                                                   0.0                                             0
2506437 2506437 NJ Gloucester 15 school 3403210 870   Clearview Regional 340321002506 20 Clearview Regional High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506447 2506447 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   grade_8                                                   0.0                                             0
2506497 2506497 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707000185 20 Bunker Hill Middle School   Regular School No Middle 06 08 2020   grade_8                                                   186.0                                             186
2506520 2506520 NJ Hudson 17 school 3401260 220   Bayonne City 340126002704 20 Bayonne High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506635 2506635 NJ Hunterdon 19 school 3401710 370   Bethlehem Twp 340171002958 20 Ethel Hoppock Middle School   Regular School No Middle 06 08 2020   grade_8                                                   43.0                                             43
2506637 2506637 NJ Hunterdon 19 school 3401890 430   Bloomsbury Boro 340189002960 20 Bloomsbury Borough School   Regular School No Elementary PK 08 2020   grade_8                                                   2.0                                             2
2506647 2506647 NJ Hunterdon 19 school 3400769 1376   South Hunterdon Regional School District 340076903010 20 Lambertville Public School   Regular School No Elementary PK 06 2020   grade_8                                                   0.0                                             0
2506766 2506766 NJ Mercer 21 school 3417700 5715   W Windsor-Plainsboro Reg 341770003258 20 West Windsor-Plainsboro High School South   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506846 2506846 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003442 20 Monroe Township Middle School   Regular School No Middle 06 08 2020   grade_8                                                   594.0                                             594
2506939 2506939 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003668 20 Colonia High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506966 2506966 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2506970 2506970 NJ Monmouth 25 school 3401020 130   Atlantic Highlands Boro 340102003746 20 Atlantic Highlands Elementary School   Regular School No Elementary PK 06 2020   grade_8                                                   0.0                                             0
2506973 2506973 NJ Monmouth 25 school 3401410 270   Belmar Boro 340141003750 20 Belmar Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   52.0                                             52
2506974 2506974 NJ Monmouth 25 school 3402130 500   Bradley Beach Boro 340213003752 20 Bradley Beach Elementary School   Regular School No Elementary PK 08 2020   grade_8                                                   31.0                                             31
2506975 2506975 NJ Monmouth 25 school 3402310 560   Brielle Boro 340231003754 20 Brielle Elementary School   Regular School No Elementary PK 08 2020   grade_8                                                   66.0                                             66
2506996 2506996 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003810 20 Joseph J Catena School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2507014 2507014 NJ Monmouth 25 school 3407410 2230   Holmdel Twp 340741003850 20 Holmdel High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507022 2507022 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   grade_8                                                   0.0                                             0
2507097 2507097 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750005989 20 Marine Academy Of Science And Technology   Career and Technical School No High 09 12 2020   grade_8                                                   0.0                                             0
2507148 2507148 NJ Morris 27 school 3401950 450   Boonton Town 340195004154 20 Boonton High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507152 2507152 NJ Morris 27 school 3402520 630   Butler Boro 340252004166 20 Butler High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507161 2507161 NJ Morris 27 school 3403060 820   Chester Twp 340306004194 20 Black River Middle School   Regular School No Middle 06 08 2020   grade_8                                                   127.0                                             127
2507176 2507176 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004236 20 Brooklake School   Regular School No Elementary 03 05 2020   grade_8                                                   0.0                                             0
2507185 2507185 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004264 20 Jefferson Township High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507216 2507216 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_8                                                   0.0                                             0
2507224 2507224 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004358 20 Morris Plains Borough School   Regular School No Middle 03 08 2020   grade_8                                                   68.0                                             68
2507307 2507307 NJ Ocean 29 school 3401230 210   Bay Head Boro 340123004568 20 Bay Head Elementary   Regular School No Elementary KG 08 2020   grade_8                                                   18.0                                             18
2507308 2507308 NJ Ocean 29 school 3401290 230   Beach Haven Boro 340129004570 20 Beach Haven School   Regular School No Elementary PK 06 2020   grade_8                                                   0.0                                             0
2507309 2507309 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156004574 20 Bayville Elementary School   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
2507313 2507313 NJ Ocean 29 school 3402220 530   Brick Twp 340222004582 20 Brick Township High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507327 2507327 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   grade_8                                                   0.0                                             0
2507329 2507329 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774004612 20 Jackson Memorial High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507339 2507339 NJ Ocean 29 school 3408100 2480   Lacey Twp 340810005935 20 Lacey Township High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507358 2507358 NJ Ocean 29 school 3408910 2760   Long Beach Island 340891004654 20 Ethel A. Jacobsen Elementary School   Regular School No Elementary PK 02 2020   grade_8                                                   0.0                                             0
2507367 2507367 NJ Ocean 29 school 3411980 3790   Ocean County Vocational 341198004672 20 Ocean County Vocational Technical School Jackson Center   Career and Technical School No High 09 12 2020   grade_8                                                   0.0                                             0
2507413 2507413 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   grade_8                                                   0.0                                             0
2507475 2507475 NJ Passaic 31 school 3412690 4010   Paterson City 341269005998 20 Rosa L. Parks School Of Fine And Performing Arts   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507559 2507559 NJ Salem 33 school 3400810 60   Alloway Twp 340081005028 20 Alloway Township School   Regular School No Elementary PK 08 2020   grade_8                                                   43.0                                             43
2507593 2507593 NJ Somerset 35 school 3401320 240   Bedminster Twp 340132005120 20 Bedminster Township Public School   Regular School No Elementary PK 08 2020   grade_8                                                   62.0                                             62
2507600 2507600 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210005144 20 Bound Brook High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507605 2507605 NJ Somerset 35 school 3402160 510   Branchburg Twp 340216005154 20 Branchburg Central Middle School   Regular School No Middle 06 08 2020   grade_8                                                   149.0                                             149
2507659 2507659 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507707 2507707 NJ Sussex 37 school 3415960 5100   Sussex-Wantage Regional 341596005945 20 Clifton E. Lawrence   Regular School No Elementary PK 02 2020   grade_8                                                   0.0                                             0
2507712 2507712 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005422 20 Vernon Township High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507720 2507720 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   grade_8                                                   0.0                                             0
2507821 2507821 NJ Union 39 school 3414280 4540   Roselle Boro 341428005652 20 Harrison Elementary School   Regular School No Elementary 01 04 2020   grade_8                                                   0.0                                             0
2507856 2507856 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2507861 2507861 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_8                                                   0.0                                             0
2507891 2507891 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_8                                                   0.0                                             0
2507893 2507893 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2506997 2506997 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003812 21 C. Richard Applegate School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2506998 2506998 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003814 23 Clifton T. Barkalow School   Regular School No Middle 06 08 2020   grade_8                                                   213.0                                             213
2507713 2507713 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   grade_8                                                   0.0                                             0
2506999 2506999 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003816 24 Dwight D. Eisenhower School   Regular School No Middle 06 08 2020   grade_8                                                   201.0                                             201
2505532 2505532 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2505568 2505568 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
2505570 2505570 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   grade_8                                                   84.0                                             84
2505862 2505862 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000944 25 Dwight D. Eisenhower Middle School   Regular School No Middle 06 08 2020   grade_8                                                   229.0                                             229
2505866 2505866 NJ Burlington 5 school 3401740 380   Beverly City 340174000952 25 Beverly City School District   Regular School No Elementary PK 08 2020   grade_8                                                   34.0                                             34
2505885 2505885 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   grade_8                                                   0.0                                             0
2506009 2506009 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   grade_8                                                   0.0                                             0
2506181 2506181 NJ Cumberland 11 school 3403480 950   Commercial Twp 340348001810 25 Haleyville-Mauricetown Elementary School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2506220 2506220 NJ Essex 13 school 3401350 250   Belleville Town 340135001956 25 Belleville Middle School   Regular School No Middle 07 08 2020   grade_8                                                   299.0                                             299
2506467 2506467 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   grade_8                                                   0.0                                             0
2506498 2506498 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002644 25 Bells Elementary School   Regular School No Elementary 01 05 2020   grade_8                                                   0.0                                             0
2506767 2506767 NJ Mercer 21 school 3417700 5715   W Windsor-Plainsboro Reg 341770000191 25 West Windsor-Plainsboro High School North   Regular School No High 09 12 2020   grade_8                                                   0.0                                             0
2507000 2507000 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003818 25 Marshall W. Errickson School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2507023 2507023 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000097 25 Howell Township Middle School North   Regular School No Middle 06 08 2020   grade_8                                                   365.0                                             365
2507098 2507098 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750000163 25 Monmouth County Academy Of Allied Health And Science   Career and Technical School No High 09 12 2020   grade_8                                                   0.0                                             0
2507153 2507153 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_8                                                   0.0                                             0
2507180 2507180 NJ Morris 27 school 3406690 2000   Hanover Twp 340669004250 25 Bee Meadow School   Regular School No Elementary KG 05 2020   grade_8                                                   0.0                                             0
2507209 2507209 NJ Morris 27 school 3410650 3340   Montville Twp 341065004334 25 Cedar Hill School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2507283 2507283 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004516 25 Dennis B O'Brien Elementary School   Regular School No Elementary PK 05 2020   grade_8                                                   0.0                                             0
2507310 2507310 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156006125 25 Berkeley Township Elementary School   Regular School No Middle 04 06 2020   grade_8                                                   0.0                                             0
2507314 2507314 NJ Ocean 29 school 3402220 530   Brick Twp 340222005896 25 Brick Township Memorial High School   Regular School No High 09 12 2020   grade_8                                                   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]);