enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_7", 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_7 · 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
2503167 2503167 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2503201 2503201 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   grade_7                                                   129.0                                             129
2503235 2503235 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   grade_7                                                   112.0                                             112
2503252 2503252 NJ Bergen 3 school 3411850 3740   Norwood Boro 341185000660 20 Norwood Public School   Regular School No Elementary PK 08 2020   grade_7                                                   81.0                                             81
2503359 2503359 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000942 20 Calvin Coolidge Elementary School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2503370 2503370 NJ Burlington 5 school 3402430 600   Burlington City 340243000966 20 Burlington City High School   Regular School No High 07 12 2020   grade_7                                                   96.0                                             96
2503413 2503413 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918000222 20 Bobby'S Run Elementary School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2503481 2503481 NJ Burlington 5 school 3417730 5720   Westampton 341773001256 20 Holly Hills Elementary School   Regular School No Elementary PK 03 2020   grade_7                                                   0.0                                             0
2503498 2503498 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2503500 2503500 NJ Camden 7 school 3401590 330   Berlin Boro 340159001324 20 Berlin Community School   Regular School No Elementary PK 08 2020   grade_7                                                   110.0                                             110
2503503 2503503 NJ Camden 7 school 3401770 390   Black Horse Pike Regional 340177001336 20 Highland Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503557 2503557 NJ Camden 7 school 3405850 1720   Gibbsboro Boro 340585001490 20 Gibbsboro Elementary School   Regular School No Elementary PK 08 2020   grade_7                                                   27.0                                             27
2503561 2503561 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603001508 20 Blackwood Elementary School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2503600 2503600 NJ Camden 7 school 3410890 3420   Mount Ephraim Boro 341089001598 20 Raymond W. Kershaw School   Regular School No Middle 06 08 2020   grade_7                                                   34.0                                             34
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
2503619 2503619 NJ Camden 7 school 3415000 4790   Somerdale Boro 341500001660 20 Somerdale Park School   Regular School No Elementary PK 08 2020   grade_7                                                   58.0                                             58
2503623 2503623 NJ Camden 7 school 3416830 5400   Voorhees Twp 341683001676 20 Edward T. Hamilton   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2503632 2503632 NJ Camden 7 school 3418060 5820   Winslow Twp 341806000439 20 Winslow Township Middle School   Regular School No Middle 07 08 2020   grade_7                                                   360.0                                             360
2503642 2503642 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_7                                                   0.0                                             0
2503671 2503671 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225001784 20 Bridgeton High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503717 2503717 NJ Essex 13 school 3401350 250   Belleville Town 340135001954 20 Belleville High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503726 2503726 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001980 20 Bloomfield High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503768 2503768 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2503824 2503824 NJ Essex 13 school 3411340 3570   Newark City 341134002190 20 Barringer High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503901 2503901 NJ Essex 13 school 3414250 4530   Roseland Boro 341425002418 20 Lester C Noecker   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2503935 2503935 NJ Gloucester 15 school 3403210 870   Clearview Regional 340321002506 20 Clearview Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503945 2503945 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2503995 2503995 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707000185 20 Bunker Hill Middle School   Regular School No Middle 06 08 2020   grade_7                                                   191.0                                             191
2504018 2504018 NJ Hudson 17 school 3401260 220   Bayonne City 340126002704 20 Bayonne High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504133 2504133 NJ Hunterdon 19 school 3401710 370   Bethlehem Twp 340171002958 20 Ethel Hoppock Middle School   Regular School No Middle 06 08 2020   grade_7                                                   34.0                                             34
2504135 2504135 NJ Hunterdon 19 school 3401890 430   Bloomsbury Boro 340189002960 20 Bloomsbury Borough School   Regular School No Elementary PK 08 2020   grade_7                                                   7.0                                             7
2504145 2504145 NJ Hunterdon 19 school 3400769 1376   South Hunterdon Regional School District 340076903010 20 Lambertville Public School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2504264 2504264 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_7                                                   0.0                                             0
2504344 2504344 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003442 20 Monroe Township Middle School   Regular School No Middle 06 08 2020   grade_7                                                   595.0                                             595
2504437 2504437 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003668 20 Colonia High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504464 2504464 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2504468 2504468 NJ Monmouth 25 school 3401020 130   Atlantic Highlands Boro 340102003746 20 Atlantic Highlands Elementary School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2504471 2504471 NJ Monmouth 25 school 3401410 270   Belmar Boro 340141003750 20 Belmar Elementary   Regular School No Elementary PK 08 2020   grade_7                                                   57.0                                             57
2504472 2504472 NJ Monmouth 25 school 3402130 500   Bradley Beach Boro 340213003752 20 Bradley Beach Elementary School   Regular School No Elementary PK 08 2020   grade_7                                                   26.0                                             26
2504473 2504473 NJ Monmouth 25 school 3402310 560   Brielle Boro 340231003754 20 Brielle Elementary School   Regular School No Elementary PK 08 2020   grade_7                                                   54.0                                             54
2504494 2504494 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003810 20 Joseph J Catena School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504512 2504512 NJ Monmouth 25 school 3407410 2230   Holmdel Twp 340741003850 20 Holmdel High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504520 2504520 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   grade_7                                                   0.0                                             0
2504595 2504595 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_7                                                   0.0                                             0
2504646 2504646 NJ Morris 27 school 3401950 450   Boonton Town 340195004154 20 Boonton High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504650 2504650 NJ Morris 27 school 3402520 630   Butler Boro 340252004166 20 Butler High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504659 2504659 NJ Morris 27 school 3403060 820   Chester Twp 340306004194 20 Black River Middle School   Regular School No Middle 06 08 2020   grade_7                                                   143.0                                             143
2504674 2504674 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004236 20 Brooklake School   Regular School No Elementary 03 05 2020   grade_7                                                   0.0                                             0
2504683 2504683 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004264 20 Jefferson Township High School   Regular 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
2504722 2504722 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004358 20 Morris Plains Borough School   Regular School No Middle 03 08 2020   grade_7                                                   58.0                                             58
2504805 2504805 NJ Ocean 29 school 3401230 210   Bay Head Boro 340123004568 20 Bay Head Elementary   Regular School No Elementary KG 08 2020   grade_7                                                   16.0                                             16
2504806 2504806 NJ Ocean 29 school 3401290 230   Beach Haven Boro 340129004570 20 Beach Haven School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2504807 2504807 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156004574 20 Bayville Elementary School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2504811 2504811 NJ Ocean 29 school 3402220 530   Brick Twp 340222004582 20 Brick Township High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504825 2504825 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2504827 2504827 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774004612 20 Jackson Memorial High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504837 2504837 NJ Ocean 29 school 3408100 2480   Lacey Twp 340810005935 20 Lacey Township High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504856 2504856 NJ Ocean 29 school 3408910 2760   Long Beach Island 340891004654 20 Ethel A. Jacobsen Elementary School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2504865 2504865 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_7                                                   0.0                                             0
2504911 2504911 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   grade_7                                                   0.0                                             0
2504973 2504973 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_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
2505091 2505091 NJ Somerset 35 school 3401320 240   Bedminster Twp 340132005120 20 Bedminster Township Public School   Regular School No Elementary PK 08 2020   grade_7                                                   56.0                                             56
2505098 2505098 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210005144 20 Bound Brook High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505103 2505103 NJ Somerset 35 school 3402160 510   Branchburg Twp 340216005154 20 Branchburg Central Middle School   Regular School No Middle 06 08 2020   grade_7                                                   173.0                                             173
2505157 2505157 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505205 2505205 NJ Sussex 37 school 3415960 5100   Sussex-Wantage Regional 341596005945 20 Clifton E. Lawrence   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2505210 2505210 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005422 20 Vernon Township High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2505218 2505218 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   grade_7                                                   0.0                                             0
2505319 2505319 NJ Union 39 school 3414280 4540   Roselle Boro 341428005652 20 Harrison Elementary School   Regular School No Elementary 01 04 2020   grade_7                                                   0.0                                             0
2505354 2505354 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No 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
2505389 2505389 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_7                                                   0.0                                             0
2505391 2505391 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2504495 2504495 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003812 21 C. Richard Applegate School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504496 2504496 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003814 23 Clifton T. Barkalow School   Regular School No Middle 06 08 2020   grade_7                                                   238.0                                             238
2505211 2505211 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   grade_7                                                   0.0                                             0
2504497 2504497 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003816 24 Dwight D. Eisenhower School   Regular School No Middle 06 08 2020   grade_7                                                   235.0                                             235
2503030 2503030 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   grade_7                                                   0.0                                             0
2503066 2503066 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   grade_7                                                   0.0                                             0
2503068 2503068 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   grade_7                                                   88.0                                             88
2503360 2503360 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000944 25 Dwight D. Eisenhower Middle School   Regular School No Middle 06 08 2020   grade_7                                                   219.0                                             219
2503364 2503364 NJ Burlington 5 school 3401740 380   Beverly City 340174000952 25 Beverly City School District   Regular School No Elementary PK 08 2020   grade_7                                                   25.0                                             25
2503383 2503383 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   grade_7                                                   0.0                                             0
2503507 2503507 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   grade_7                                                   0.0                                             0
2503679 2503679 NJ Cumberland 11 school 3403480 950   Commercial Twp 340348001810 25 Haleyville-Mauricetown Elementary School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2503718 2503718 NJ Essex 13 school 3401350 250   Belleville Town 340135001956 25 Belleville Middle School   Regular School No Middle 07 08 2020   grade_7                                                   370.0                                             370
2503965 2503965 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   grade_7                                                   0.0                                             0
2503996 2503996 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002644 25 Bells Elementary School   Regular School No Elementary 01 05 2020   grade_7                                                   0.0                                             0
2504265 2504265 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_7                                                   0.0                                             0
2504498 2504498 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003818 25 Marshall W. Errickson School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504521 2504521 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000097 25 Howell Township Middle School North   Regular School No Middle 06 08 2020   grade_7                                                   381.0                                             381
2504596 2504596 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_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
2504678 2504678 NJ Morris 27 school 3406690 2000   Hanover Twp 340669004250 25 Bee Meadow School   Regular School No Elementary KG 05 2020   grade_7                                                   0.0                                             0
2504707 2504707 NJ Morris 27 school 3410650 3340   Montville Twp 341065004334 25 Cedar Hill School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2504781 2504781 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004516 25 Dennis B O'Brien Elementary School   Regular School No Elementary PK 05 2020   grade_7                                                   0.0                                             0
2504808 2504808 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156006125 25 Berkeley Township Elementary School   Regular School No Middle 04 06 2020   grade_7                                                   0.0                                             0
2504812 2504812 NJ Ocean 29 school 3402220 530   Brick Twp 340222005896 25 Brick Township Memorial High School   Regular 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]);