enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2500523 2500523 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 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
2500990 2500990 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001298 10 Audubon Junior/Senior High School   Regular School No High 07 12 2020   grade_6                                                   0.0                                             0
2501281 2501281 NJ Essex 13 school 3407680 2330   Irvington Township 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
2501445 2501445 NJ Gloucester 15 school 3404620 1330   Elk Twp 340462002538 10 Aura Elementary School   Regular School No Elementary PK 06 2020   grade_6                                                   42.0                                             42
2502629 2502629 NJ Somerset 35 school 3407230 2170   Hillsborough Twp 340723000357 34 Auten Road Intermediate School   Regular School No Middle 05 06 2020   grade_6                                                   578.0                                             578
2500590 2500590 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000073 100 Autistic   Special Education School No Other PK 12 2020   grade_6                                                   2.0                                             2
2501138 2501138 NJ Cape May 9 school 3401110 170   Avalon Boro 340111001702 10 Avalon Elementary School   Regular School No Middle 05 08 2020   grade_6                                                   16.0                                             16
2501937 2501937 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812005972 45 Avenel Middle School   Regular School No Middle 06 08 2020   grade_6                                                   181.0                                             181
2501943 2501943 NJ Middlesex 23 school 3418120 5850   Woodbridge Twp 341812003686 100 Avenel Street Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2501334 2501334 NJ Essex 13 school 3411340 3570   Newark City 341134002232 220 Avon Avenue School   Regular School No Elementary PK 08 2020   grade_6                                                   47.0                                             47
2500993 2500993 NJ Camden 7 school 3401170 190   Barrington Boro 340117001308 10 Avon Elementary School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2501967 2501967 NJ Monmouth 25 school 3401140 180   Avon Boro 340114003748 10 Avon Elementary School   Regular School No Elementary PK 08 2020   grade_6                                                   15.0                                             15
2500878 2500878 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001010 30 B. Bernice Young Elementary School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2501103 2501103 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287001622 90 Baldwin Elementary School   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
2501455 2501455 NJ Gloucester 15 school 3480363 1774   Gloucester Co Spec Serv 348036300413 15 Bankbridge Regional School   Special Education School No Other PK 12 2020   grade_6                                                   8.0                                             8
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
2501841 2501841 NJ Middlesex 23 school 3410500 3290   Monroe Twp 341050003440 10 Barclay Brook School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2501030 2501030 NJ Camden 7 school 3403000 800   Cherry Hill Twp 340300000263 62 Barclay Early Childhood Center   Regular School No Elementary PK KG 2020   grade_6                                                   0.0                                             0
2501340 2501340 NJ Essex 13 school 3411340 3570   Newark City 341134003158 304 Bard Early College High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2501646 2501646 NJ Hunterdon 19 school 3405190 1510   Flemington-Raritan Reg 340519002984 30 Barley Sheaf Elementary School   Regular School No Elementary KG 04 2020   grade_6                                                   0.0                                             0
2502299 2502299 NJ Ocean 29 school 3416470 185   Barnegat Twp 341647000557 30 Barnegat High School   Regular 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
2501814 2501814 NJ Middlesex 23 school 3407170 2150   Highland Park Boro 340717003380 85 Bartle Elementary School   Regular School No Elementary 02 05 2020   grade_6                                                   0.0                                             0
2500861 2500861 NJ Burlington 5 school 3401200 200   Bass River Twp 340120000950 50 Bass River Township Elementary School   Regular School No Elementary PK 06 2020   grade_6                                                   21.0                                             21
2502868 2502868 NJ Union 39 school 3416500 5290   Union Twp 341650005748 80 Battle Hill Elementary   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
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
2502667 2502667 NJ Somerset 35 school 3417190 5540   Watchung Boro 341719005316 40 Bayberry School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
2501545 2501545 NJ Hudson 17 school 3407570 2295   Hudson County Vocational 340757003233 305 Bayonne Academy   Career and Technical School No High 09 12 2020   grade_6                                                   0.0                                             0
2501515 2501515 NJ Hudson 17 school 3401260 220   Bayonne City 340126003447 10 Bayonne Alternative High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
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
2502069 2502069 NJ Monmouth 25 school 3410110 3160   Middletown Twp 341011003980 55 Bayshore Middle School   Regular School No Middle 06 08 2020   grade_6                                                   194.0                                             194
2502072 2502072 NJ Monmouth 25 school 3410110 3160   Middletown Twp 341011003986 60 Bayview Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
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
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
2502396 2502396 NJ Ocean 29 school 3416230 5190   Toms River Regional 341623006037 64 Beachwood Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2501714 2501714 NJ Mercer 21 school 3407530 2280   Hopewell Valley Regional 340753003138 35 Bear Tavern Elementary School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2502552 2502552 NJ Passaic 31 school 3417640 5690   Woodland Park 341764005018 60 Beatrice Gilmore School   Regular School No Elementary 03 04 2020   grade_6                                                   0.0                                             0
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
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
2502792 2502792 NJ Union 39 school 3411040 3470   Mountainside Boro 341104000527 60 Beechwood School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2502001 2502001 NJ Monmouth 25 school 3413680 2105   Hazlet Twp 341368003828 60 Beers Street School   Regular School No Middle 05 06 2020   grade_6                                                   101.0                                             101
2500560 2500560 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000144 20 Belhaven Middle School   Regular School No Middle 05 08 2020   grade_6                                                   91.0                                             91
2500995 2500995 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001316 15 Bell Oaks Upper Elementary School   Regular School No Middle 05 08 2020   grade_6                                                   108.0                                             108
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
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
2501223 2501223 NJ Essex 13 school 3401350 250   Belleville Town 340135001974 100 Belleville Ps10   Regular School No Elementary KG 06 2020   grade_6                                                   20.0                                             20
2501217 2501217 NJ Essex 13 school 3401350 250   Belleville Town 340135001962 50 Belleville Ps3   Regular School No Elementary PK 06 2020   grade_6                                                   59.0                                             59
2501218 2501218 NJ Essex 13 school 3401350 250   Belleville Town 340135001964 55 Belleville Ps4   Regular School No Elementary PK 06 2020   grade_6                                                   47.0                                             47
2501219 2501219 NJ Essex 13 school 3401350 250   Belleville Town 340135001966 60 Belleville Ps5   Regular School No Elementary KG 06 2020   grade_6                                                   60.0                                             60
2501220 2501220 NJ Essex 13 school 3401350 250   Belleville Town 340135001968 70 Belleville Ps7   Regular School No Elementary PK 06 2020   grade_6                                                   73.0                                             73
2501221 2501221 NJ Essex 13 school 3401350 250   Belleville Town 340135001970 80 Belleville Ps8   Regular School No Elementary KG 06 2020   grade_6                                                   69.0                                             69
2501222 2501222 NJ Essex 13 school 3401350 250   Belleville Town 340135001972 90 Belleville Ps9   Regular School No Elementary KG 06 2020   grade_6                                                   23.0                                             23
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
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
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
2501335 2501335 NJ Essex 13 school 3411340 3570   Newark City 341134002234 225 Belmont Runyon Elementary School   Regular School No Elementary PK 08 2020   grade_6                                                   52.0                                             52
2502951 2502951 NJ Charters 80 school 3400759 6082   Beloved Community Charter School 340075903196 963 Beloved Community Charter School   Regular School Yes Other KG 09 2020   grade_6                                                   119.0                                             119
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
2501721 2501721 NJ Mercer 21 school 3408400 2580   Lawrence Twp 340840003156 70 Ben Franklin Elementary   Regular School No Elementary PK 03 2020   grade_6                                                   0.0                                             0
2502292 2502292 NJ Morris 27 school 3417130 5520   Washington Twp 341713000815 50 Benedict A. Cucinella School   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2501253 2501253 NJ Essex 13 school 3404230 1210   East Orange 340423000273 93 Benjamin Banneker Academy   Regular School No Elementary PK 05 2020   grade_6                                                   0.0                                             0
2502947 2502947 NJ Charters 80 school 3400744 6076   Benjamin Banneker Prep Cs 340074403139 961 Benjamin Banneker Preparatory Charter School   Regular School Yes Elementary KG 08 2020   grade_6                                                   40.0                                             40
2501104 2501104 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287001624 100 Benjamin Franklin Elementary School   Regular School No Elementary PK 03 2020   grade_6                                                   0.0                                             0
2501355 2501355 NJ Essex 13 school 3411340 3570   Newark City 341134002278 430 Benjamin Franklin Elementary School   Regular School No Elementary PK 08 2020   grade_6                                                   0.0                                             0
2501798 2501798 NJ Middlesex 23 school 3404500 1290   Edison Twp 340450003336 65 Benjamin Franklin Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2500790 2500790 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000766 60 Benjamin Franklin Middle School   Regular School No Middle 06 08 2020   grade_6                                                   218.0                                             218
2500823 2500823 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000842 60 Benjamin Franklin Middle School   Regular School No Middle 05 08 2020   grade_6                                                   114.0                                             114
2502741 2502741 NJ Union 39 school 3404590 1320   Elizabeth City 340459005506 160 Benjamin Franklin School No. 13   Regular School No Elementary KG 08 2020   grade_6                                                   42.0                                             42
2502925 2502925 NJ Charters 80 school 3400715 6013   Bergen Arts And Sciences Charter School 340071502923 900 Bergen Arts And Sciences Charter School   Regular School Yes Other KG 12 2020   grade_6                                                   91.0                                             91
2500782 2500782 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377006057 65 Bergen Boulevard School   Regular School No Elementary 01 04 2020   grade_6                                                   0.0                                             0
2500591 2500591 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000250 20 Bergen County Academies   Career and Technical School No High 09 12 2020   grade_6                                                   0.0                                             0
2500592 2500592 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000252 30 Bergen County Technical High School - Paramus   Special Education School No High 09 12 2020   grade_6                                                   0.0                                             0
2500594 2500594 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000264 75 Bergen County Technical High School - Paramus   Career and Technical School No High 09 12 2020   grade_6                                                   0.0                                             0
2500593 2500593 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000262 70 Bergen County Technical High School - Teterboro   Career and Technical School No High 09 12 2020   grade_6                                                   0.0                                             0
2500596 2500596 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000268 20 Bergenfield High School   Regular School No High 09 12 2020   grade_6                                                   0.0                                             0
2500846 2500846 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000910 60 Berkeley Elementary   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2501226 2501226 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001986 50 Berkeley Elementary School   Regular School No Elementary KG 06 2020   grade_6                                                   73.0                                             73
2501282 2501282 NJ Essex 13 school 3407680 2330   Irvington Township 340768002108 80 Berkeley Terrace 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
2500737 2500737 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000626 60 Berkley Street School   Regular School No Elementary KG 05 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
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
2502657 2502657 NJ Somerset 35 school 3400009 4815   Somerset Hills Regional 340000900178 40 Bernardsville Middle School   Regular School No Middle 05 08 2020   grade_6                                                   111.0                                             111
2500738 2500738 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000628 70 Bertrand F. Gibbs Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2500723 2500723 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000588 60 Betsy Ross Elementary   Regular School No Elementary KG 03 2020   grade_6                                                   0.0                                             0
2501429 2501429 NJ Essex 13 school 3417610 5680   West Orange Town 341761003416 300 Betty Maddalena Early Learning Center   Regular School No Prekindergarten PK PK 2020   grade_6                                                   0.0                                             0
2502143 2502143 NJ Monmouth 25 school 3417490 5640   West Long Branch Boro 341749006107 80 Betty Mcelmon Elementary School   Regular School No Elementary PK 04 2020   grade_6                                                   0.0                                             0
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
2501477 2501477 NJ Gloucester 15 school 3412720 4020   Paulsboro Boro 341272002610 60 Billingsport Elementary School   Regular School No Elementary PK 02 2020   grade_6                                                   0.0                                             0
2502095 2502095 NJ Monmouth 25 school 3417500 3260   Monmouth Co Vocational 341750006121 28 Biotechnology High School   Career and Technical School No High 09 12 2020   grade_6                                                   0.0                                             0
2501496 2501496 NJ Gloucester 15 school 3417070 5500   Washington Twp 341707002646 27 Birches Elementary School   Regular School No Elementary KG 05 2020   grade_6                                                   0.0                                             0
2502276 2502276 NJ Morris 27 school 3414130 4490   Rockaway Twp 341413004510 10 Birchwood Elementary School   Regular School No Elementary KG 05 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
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
2502891 2502891 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   grade_6                                                   75.0                                             75
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
2501225 2501225 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183001982 30 Bloomfield Middle School   Regular School No Middle 07 08 2020   grade_6                                                   0.0                                             0
2502729 2502729 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_6                                                   0.0                                             0
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

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]);