enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_6", 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_6 · 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
2500665 2500665 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2500699 2500699 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   grade_6                                                   123.0                                             123
2500733 2500733 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   grade_6                                                   117.0                                             117
2500750 2500750 NJ Bergen 3 school 3411850 3740   Norwood Boro 341185000660 20 Norwood Public School   Regular School No Elementary PK 08 2020   grade_6                                                   65.0                                             65
2500857 2500857 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000942 20 Calvin Coolidge Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2500868 2500868 NJ Burlington 5 school 3402430 600   Burlington City 340243000966 20 Burlington City High School   Regular School No High 07 12 2020   grade_6                                                   0.0                                             0
2500911 2500911 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918000222 20 Bobby'S Run Elementary School   Regular School No Elementary 03 05 2020   grade_6                                                   0.0                                             0
2500979 2500979 NJ Burlington 5 school 3417730 5720   Westampton 341773001256 20 Holly Hills Elementary School   Regular School No Elementary PK 03 2020   grade_6                                                   0.0                                             0
2500996 2500996 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2500998 2500998 NJ Camden 7 school 3401590 330   Berlin Boro 340159001324 20 Berlin Community School   Regular School No Elementary PK 08 2020   grade_6                                                   79.0                                             79
2501001 2501001 NJ Camden 7 school 3401770 390   Black Horse Pike Regional 340177001336 20 Highland Regional High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501055 2501055 NJ Camden 7 school 3405850 1720   Gibbsboro Boro 340585001490 20 Gibbsboro Elementary School   Regular School No Elementary PK 08 2020   grade_6                                                   33.0                                             33
2501059 2501059 NJ Camden 7 school 3406030 1780   Gloucester Twp 340603001508 20 Blackwood Elementary School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2501098 2501098 NJ Camden 7 school 3410890 3420   Mount Ephraim Boro 341089001598 20 Raymond W. Kershaw School   Regular School No Middle 06 08 2020   grade_6                                                   51.0                                             51
2501114 2501114 NJ Camden 7 school 3414430 4590   Runnemede Boro 341443001650 20 Aline Bingham Elementary School   Regular School No Elementary KG 03 2020   grade_6                                                   0.0                                             0
2501117 2501117 NJ Camden 7 school 3415000 4790   Somerdale Boro 341500001660 20 Somerdale Park School   Regular School No Elementary PK 08 2020   grade_6                                                   55.0                                             55
2501121 2501121 NJ Camden 7 school 3416830 5400   Voorhees Twp 341683001676 20 Edward T. Hamilton   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2501130 2501130 NJ Camden 7 school 3418060 5820   Winslow Twp 341806000439 20 Winslow Township Middle School   Regular School No Middle 07 08 2020   grade_6                                                   0.0                                             0
2501140 2501140 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_6                                                   0.0                                             0
2501169 2501169 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225001784 20 Bridgeton High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501215 2501215 NJ Essex 13 school 3401350 250   Belleville Town 340135001954 20 Belleville High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501224 2501224 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001980 20 Bloomfield High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501266 2501266 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_6                                                   0.0                                             0
2501322 2501322 NJ Essex 13 school 3411340 3570   Newark City 341134002190 20 Barringer High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501399 2501399 NJ Essex 13 school 3414250 4530   Roseland Boro 341425002418 20 Lester C Noecker   Regular School No Elementary PK 06 2020   grade_6                                                   68.0                                             68
2501433 2501433 NJ Gloucester 15 school 3403210 870   Clearview Regional 340321002506 20 Clearview Regional High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501443 2501443 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2501493 2501493 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707000185 20 Bunker Hill Middle School   Regular School No Middle 06 08 2020   grade_6                                                   177.0                                             177
2501516 2501516 NJ Hudson 17 school 3401260 220   Bayonne City 340126002704 20 Bayonne High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501631 2501631 NJ Hunterdon 19 school 3401710 370   Bethlehem Twp 340171002958 20 Ethel Hoppock Middle School   Regular School No Middle 06 08 2020   grade_6                                                   40.0                                             40
2501633 2501633 NJ Hunterdon 19 school 3401890 430   Bloomsbury Boro 340189002960 20 Bloomsbury Borough School   Regular School No Elementary PK 08 2020   grade_6                                                   8.0                                             8
2501643 2501643 NJ Hunterdon 19 school 3400769 1376   South Hunterdon Regional School District 340076903010 20 Lambertville Public School   Regular School No Elementary PK 06 2020   grade_6                                                   29.0                                             29
2501762 2501762 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_6                                                   0.0                                             0
2501842 2501842 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003442 20 Monroe Township Middle School   Regular School No Middle 06 08 2020   grade_6                                                   569.0                                             569
2501935 2501935 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003668 20 Colonia High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501962 2501962 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2501966 2501966 NJ Monmouth 25 school 3401020 130   Atlantic Highlands Boro 340102003746 20 Atlantic Highlands Elementary School   Regular School No Elementary PK 06 2020   grade_6                                                   28.0                                             28
2501969 2501969 NJ Monmouth 25 school 3401410 270   Belmar Boro 340141003750 20 Belmar Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   39.0                                             39
2501970 2501970 NJ Monmouth 25 school 3402130 500   Bradley Beach Boro 340213003752 20 Bradley Beach Elementary School   Regular School No Elementary PK 08 2020   grade_6                                                   30.0                                             30
2501971 2501971 NJ Monmouth 25 school 3402310 560   Brielle Boro 340231003754 20 Brielle Elementary School   Regular School No Elementary PK 08 2020   grade_6                                                   67.0                                             67
2501992 2501992 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003810 20 Joseph J Catena School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2502010 2502010 NJ Monmouth 25 school 3407410 2230   Holmdel Twp 340741003850 20 Holmdel High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502018 2502018 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756003864 20 Edith M. Griebling Elementary School   Regular School No Elementary KG 02 2020   grade_6                                                   0.0                                             0
2502093 2502093 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_6                                                   0.0                                             0
2502144 2502144 NJ Morris 27 school 3401950 450   Boonton Town 340195004154 20 Boonton High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502148 2502148 NJ Morris 27 school 3402520 630   Butler Boro 340252004166 20 Butler High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502157 2502157 NJ Morris 27 school 3403060 820   Chester Twp 340306004194 20 Black River Middle School   Regular School No Middle 06 08 2020   grade_6                                                   140.0                                             140
2502172 2502172 NJ Morris 27 school 3405250 1530   Florham Park Boro 340525004236 20 Brooklake School   Regular School No Elementary 03 05 2020   grade_6                                                   0.0                                             0
2502181 2502181 NJ Morris 27 school 3407800 2380   Jefferson Twp 340780004264 20 Jefferson Township High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502212 2502212 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_6                                                   0.0                                             0
2502220 2502220 NJ Morris 27 school 3410770 3380   Morris Plains Boro 341077004358 20 Morris Plains Borough School   Regular School No Middle 03 08 2020   grade_6                                                   69.0                                             69
2502303 2502303 NJ Ocean 29 school 3401230 210   Bay Head Boro 340123004568 20 Bay Head Elementary   Regular School No Elementary KG 08 2020   grade_6                                                   11.0                                             11
2502304 2502304 NJ Ocean 29 school 3401290 230   Beach Haven Boro 340129004570 20 Beach Haven School   Regular School No Elementary PK 06 2020   grade_6                                                   2.0                                             2
2502305 2502305 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156004574 20 Bayville Elementary School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2502309 2502309 NJ Ocean 29 school 3402220 530   Brick Twp 340222004582 20 Brick Township High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502323 2502323 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   grade_6                                                   0.0                                             0
2502325 2502325 NJ Ocean 29 school 3407740 2360   Jackson Twp 340774004612 20 Jackson Memorial High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502335 2502335 NJ Ocean 29 school 3408100 2480   Lacey Twp 340810005935 20 Lacey Township High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502354 2502354 NJ Ocean 29 school 3408910 2760   Long Beach Island 340891004654 20 Ethel A. Jacobsen Elementary School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2502363 2502363 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_6                                                   0.0                                             0
2502409 2502409 NJ Passaic 31 school 3401860 420   Bloomingdale Boro 340186004754 20 Martha B. Day Elementary School   Regular School No Elementary PK 01 2020   grade_6                                                   0.0                                             0
2502471 2502471 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_6                                                   0.0                                             0
2502555 2502555 NJ Salem 33 school 3400810 60   Alloway Twp 340081005028 20 Alloway Township School   Regular School No Elementary PK 08 2020   grade_6                                                   35.0                                             35
2502589 2502589 NJ Somerset 35 school 3401320 240   Bedminster Twp 340132005120 20 Bedminster Township Public School   Regular School No Elementary PK 08 2020   grade_6                                                   75.0                                             75
2502596 2502596 NJ Somerset 35 school 3402100 490   Bound Brook Boro 340210005144 20 Bound Brook High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502601 2502601 NJ Somerset 35 school 3402160 510   Branchburg Twp 340216005154 20 Branchburg Central Middle School   Regular School No Middle 06 08 2020   grade_6                                                   175.0                                             175
2502655 2502655 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900176 20 Bernards High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502703 2502703 NJ Sussex 37 school 3415960 5100   Sussex-Wantage Regional 341596005945 20 Clifton E. Lawrence   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2502708 2502708 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671005422 20 Vernon Township High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2502716 2502716 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   grade_6                                                   0.0                                             0
2502817 2502817 NJ Union 39 school 3414280 4540   Roselle Boro 341428005652 20 Harrison Elementary School   Regular School No Elementary 01 04 2020   grade_6                                                   0.0                                             0
2502852 2502852 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_6                                                   0.0                                             0
2502857 2502857 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_6                                                   0.0                                             0
2502887 2502887 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2502889 2502889 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501993 2501993 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003812 21 C. Richard Applegate School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2501994 2501994 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003814 23 Clifton T. Barkalow School   Regular School No Middle 06 08 2020   grade_6                                                   208.0                                             208
2502709 2502709 NJ Sussex 37 school 3416710 5360   Vernon Twp 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary KG 01 2020   grade_6                                                   0.0                                             0
2501995 2501995 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003816 24 Dwight D. Eisenhower School   Regular School No Middle 06 08 2020   grade_6                                                   215.0                                             215
2500528 2500528 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2500564 2500564 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2500566 2500566 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   grade_6                                                   78.0                                             78
2500858 2500858 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000944 25 Dwight D. Eisenhower Middle School   Regular School No Middle 06 08 2020   grade_6                                                   225.0                                             225
2500862 2500862 NJ Burlington 5 school 3401740 380   Beverly City 340174000952 25 Beverly City School District   Regular School No Elementary PK 08 2020   grade_6                                                   25.0                                             25
2500881 2500881 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   grade_6                                                   113.0                                             113
2501005 2501005 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
2501177 2501177 NJ Cumberland 11 school 3403480 950   Commercial Twp 340348001810 25 Haleyville-Mauricetown Elementary School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2501216 2501216 NJ Essex 13 school 3401350 250   Belleville Town 340135001956 25 Belleville Middle School   Regular School No Middle 07 08 2020   grade_6                                                   0.0                                             0
2501463 2501463 NJ Gloucester 15 school 3408880 2750   Logan Twp 340888000443 25 Center Square School   Regular School No Elementary PK 01 2020   grade_6                                                   0.0                                             0
2501494 2501494 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002644 25 Bells Elementary School   Regular School No Elementary 01 05 2020   grade_6                                                   0.0                                             0
2501763 2501763 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_6                                                   0.0                                             0
2501996 2501996 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564003818 25 Marshall W. Errickson School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2502019 2502019 NJ Monmouth 25 school 3407560 2290   Howell Twp 340756000097 25 Howell Township Middle School North   Regular School No Middle 06 08 2020   grade_6                                                   355.0                                             355
2502094 2502094 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_6                                                   0.0                                             0
2502149 2502149 NJ Morris 27 school 3402520 630   Butler Boro 340252004168 25 Aaron Decker School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2502176 2502176 NJ Morris 27 school 3406690 2000   Hanover Twp 340669004250 25 Bee Meadow School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2502205 2502205 NJ Morris 27 school 3410650 3340   Montville Twp 341065004334 25 Cedar Hill School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2502279 2502279 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004516 25 Dennis B O'Brien Elementary School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2502306 2502306 NJ Ocean 29 school 3401560 320   Berkeley Twp 340156006125 25 Berkeley Township Elementary School   Regular School No Middle 04 06 2020   grade_6                                                   290.0                                             290
2502310 2502310 NJ Ocean 29 school 3402220 530   Brick Twp 340222005896 25 Brick Township Memorial High School   Regular School No High 09 12 2020   grade_6                                                   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]);