enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_4", state = "NJ" and year = 2020 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,302 ✖

grade ✖

  • grade_4 · 2,302 ✖
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
2495638 2495638 NJ Bergen 3 school 3404740 1370   Englewood City 340474000394 76 Janis E. Dismus Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495639 2495639 NJ Bergen 3 school 3404740 1370   Englewood City 340474003063 86 Dr. John Grieco Elementary School   Regular School No Elementary 01 02 2020   grade_4                                                   0.0                                             0
2495640 2495640 NJ Bergen 3 school 3404770 1380   Englewood Cliffs Boro 340477000402 40 North Cliff School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
2495641 2495641 NJ Bergen 3 school 3404770 1380   Englewood Cliffs Boro 340477000406 60 Upper School   Regular School No Middle 03 08 2020   grade_4                                                   47.0                                             47
2495642 2495642 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000410 50 Fair Lawn High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495643 2495643 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000053 60 Thomas Jefferson Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495644 2495644 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000414 70 Memorial Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495645 2495645 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000416 80 Henry B. Milnes Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   97.0                                             97
2495646 2495646 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000418 85 John A. Forrest Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   44.0                                             44
2495647 2495647 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000420 100 Lyncrest Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   45.0                                             45
2495648 2495648 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000422 110 Radburn Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   89.0                                             89
2495649 2495649 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000426 140 Warren Point Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   77.0                                             77
2495650 2495650 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000430 160 Westmoreland Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   50.0                                             50
2495651 2495651 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000436 60 Lincoln School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495652 2495652 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000256 65 Lincoln School Annex   Regular School No Elementary PK KG 2020   grade_4                                                   0.0                                             0
2495653 2495653 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000438 80 Number Three School   Regular School No Elementary KG 04 2020   grade_4                                                   158.0                                             158
2495654 2495654 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000442 50 Fort Lee High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495655 2495655 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000444 60 School No. 1   Regular School No Elementary KG 04 2020   grade_4                                                   118.0                                             118
2495656 2495656 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000446 70 School No. 2   Regular School No Elementary PK 04 2020   grade_4                                                   55.0                                             55
2495657 2495657 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000448 80 School No. 3   Regular School No Elementary KG 04 2020   grade_4                                                   78.0                                             78
2495658 2495658 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000450 90 School No. 4   Regular School No Elementary KG 04 2020   grade_4                                                   96.0                                             96
2495659 2495659 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000452 100 Lewis F. Cole Middle School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495660 2495660 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000117 15 Franklin Avenue Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495661 2495661 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000460 20 High Mountain Road School   Regular School No Elementary PK 05 2020   grade_4                                                   39.0                                             39
2495662 2495662 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000462 30 Woodside Avenue School   Regular School No Elementary KG 05 2020   grade_4                                                   37.0                                             37
2495663 2495663 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000532 40 Colonial Road School   Regular School No Elementary PK 05 2020   grade_4                                                   38.0                                             38
2495664 2495664 NJ Bergen 3 school 3405760 1700   Garfield City 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   grade_4                                                   0.0                                             0
2495665 2495665 NJ Bergen 3 school 3405760 1700   Garfield City 340576000466 50 Garfield High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495666 2495666 NJ Bergen 3 school 3405760 1700   Garfield City 340576000468 60 Christopher Columbus School #8   Regular School No Elementary PK 05 2020   grade_4                                                   44.0                                             44
2495667 2495667 NJ Bergen 3 school 3405760 1700   Garfield City 340576000470 70 Garfield Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495668 2495668 NJ Bergen 3 school 3405760 1700   Garfield City 340576000472 80 Abraham Lincoln School #6   Regular School No Elementary PK 05 2020   grade_4                                                   43.0                                             43
2495669 2495669 NJ Bergen 3 school 3405760 1700   Garfield City 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2020   grade_4                                                   0.0                                             0
2495670 2495670 NJ Bergen 3 school 3405760 1700   Garfield City 340576000476 100 Roosevelt School #7   Regular School No Elementary PK 05 2020   grade_4                                                   30.0                                             30
2495671 2495671 NJ Bergen 3 school 3405760 1700   Garfield City 340576000478 120 Washington Irving School #4   Regular School No Elementary PK 05 2020   grade_4                                                   66.0                                             66
2495672 2495672 NJ Bergen 3 school 3405760 1700   Garfield City 340576000480 130 Woodrow Wilson School #5   Regular School No Elementary PK 05 2020   grade_4                                                   34.0                                             34
2495673 2495673 NJ Bergen 3 school 3405760 1700   Garfield City 340576000387 205 James Madison School #10   Regular School No Elementary PK 05 2020   grade_4                                                   39.0                                             39
2495674 2495674 NJ Bergen 3 school 3405760 1700   Garfield City 340576003443 300 Thomas Jefferson School #9   Regular School No Elementary PK 05 2020   grade_4                                                   37.0                                             37
2495675 2495675 NJ Bergen 3 school 3405760 1700   Garfield City 340576003431 302 Garfield Public Preschool 3 At Headstart   Regular School No Prekindergarten PK PK 2020   grade_4                                                   0.0                                             0
2495676 2495676 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000484 50 Glen Rock High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495677 2495677 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000077 60 Glen Rock Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495678 2495678 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000482 65 Alexander Hamilton School   Regular School No Elementary KG 05 2020   grade_4                                                   45.0                                             45
2495679 2495679 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000486 70 Richard Byrd   Regular School No Elementary KG 05 2020   grade_4                                                   44.0                                             44
2495680 2495680 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000488 80 Central School   Regular School No Elementary KG 05 2020   grade_4                                                   46.0                                             46
2495681 2495681 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000490 90 Clara E Coleman School   Regular School No Elementary PK 05 2020   grade_4                                                   57.0                                             57
2495682 2495682 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000496 50 Hackensack High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495683 2495683 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000498 90 Nellie K. Parker   Regular School No Elementary PK 04 2020   grade_4                                                   84.0                                             84
2495684 2495684 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000500 100 Fairmount   Regular School No Elementary PK 04 2020   grade_4                                                   98.0                                             98
2495685 2495685 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000502 110 Fanny Meyer Hillers   Regular School No Elementary PK 04 2020   grade_4                                                   105.0                                             105
2495686 2495686 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000504 120 Jackson Avenue   Regular School No Elementary PK 04 2020   grade_4                                                   78.0                                             78
2495687 2495687 NJ Bergen 3 school 3406270 1860   Hackensack City 340627003191 300 Hackensack Middle School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495688 2495688 NJ Bergen 3 school 3406840 2050   Harrington Park Boro 340684000508 50 Harrington Park School   Regular School No Elementary PK 08 2020   grade_4                                                   85.0                                             85
2495689 2495689 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000512 50 Hasbrouck Heights High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495690 2495690 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000491 55 Hasbrouck Heights Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495691 2495691 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000514 60 Euclid Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   55.0                                             55
2495692 2495692 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000518 80 Lincoln Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   65.0                                             65
2495693 2495693 NJ Bergen 3 school 3406960 2090   Haworth Boro 340696000520 50 Haworth Public School   Regular School No Elementary KG 08 2020   grade_4                                                   41.0                                             41
2495694 2495694 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2020   grade_4                                                   61.0                                             61
2495695 2495695 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495696 2495696 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000528 30 Meadowbrook   Regular School No Elementary PK 04 2020   grade_4                                                   55.0                                             55
2495697 2495697 NJ Bergen 3 school 3407320 2200   Ho Ho Kus Boro 340732000530 50 Ho-Ho-Kus Public School   Regular School No Elementary PK 08 2020   grade_4                                                   51.0                                             51
2495698 2495698 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000534 50 Leonia High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495699 2495699 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000536 55 Leonia Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495700 2495700 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000538 60 Anna C. Scott Elementary School   Regular School No Elementary PK 05 2020   grade_4                                                   108.0                                             108
2495701 2495701 NJ Bergen 3 school 3408760 2710   Little Ferry Boro 340876000542 30 Memorial Elementary School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495702 2495702 NJ Bergen 3 school 3408760 2710   Little Ferry Boro 340876000544 50 Washington Elementary School   Regular School No Elementary PK 04 2020   grade_4                                                   85.0                                             85
2495703 2495703 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000550 50 Lodi High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495704 2495704 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000552 60 Columbus School   Regular School No Elementary KG 05 2020   grade_4                                                   43.0                                             43
2495705 2495705 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000554 65 Hilltop School   Regular School No Elementary PK 05 2020   grade_4                                                   50.0                                             50
2495706 2495706 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000556 67 Thomas Jefferson Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495707 2495707 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885005975 80 Roosevelt School   Regular School No Elementary PK 05 2020   grade_4                                                   25.0                                             25
2495708 2495708 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000562 90 Washington School   Regular School No Elementary PK 05 2020   grade_4                                                   46.0                                             46
2495709 2495709 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000564 100 Wilson School   Regular School No Elementary PK 05 2020   grade_4                                                   51.0                                             51
2495710 2495710 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000568 50 Lyndhurst High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495711 2495711 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000570 60 Columbus School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
2495712 2495712 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000572 70 Franklin School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
2495713 2495713 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000574 80 Jefferson School   Regular School No Middle 04 08 2020   grade_4                                                   54.0                                             54
2495714 2495714 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000576 90 Lincoln School   Regular School No Middle 04 08 2020   grade_4                                                   51.0                                             51
2495715 2495715 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000580 110 Roosevelt School   Regular School No Middle 04 08 2020   grade_4                                                   100.0                                             100
2495716 2495716 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000582 120 Washington School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
2495717 2495717 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921003279 300 Memorial Campus   Regular School No Elementary 03 03 2020   grade_4                                                   0.0                                             0
2495718 2495718 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000586 50 Mahwah High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495719 2495719 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000588 60 Betsy Ross Elementary   Regular School No Elementary KG 03 2020   grade_4                                                   0.0                                             0
2495720 2495720 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000492 65 Lenape Meadows   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2495721 2495721 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000592 75 Joyce Kilmer School   Regular School No Elementary 04 05 2020   grade_4                                                   193.0                                             193
2495722 2495722 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000594 76 Ramapo Ridge   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495723 2495723 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000596 80 George Washington School   Regular School No Elementary KG 03 2020   grade_4                                                   0.0                                             0
2495724 2495724 NJ Bergen 3 school 3409810 3060   Maywood Boro 340981000602 60 Maywood Avenue School   Regular School No Middle 04 08 2020   grade_4                                                   96.0                                             96
2495725 2495725 NJ Bergen 3 school 3409810 3060   Maywood Boro 340981000604 70 Memorial School   Regular School No Elementary PK 03 2020   grade_4                                                   0.0                                             0
2495726 2495726 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014000608 50 Midland Park Jr./Sr. High School   Regular School No High 07 12 2020   grade_4                                                   0.0                                             0
2495727 2495727 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014000612 70 Highland Elementary School   Regular School No Elementary 03 06 2020   grade_4                                                   72.0                                             72
2495728 2495728 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014003209 300 Godwin Elementary School   Regular School No Elementary PK 02 2020   grade_4                                                   0.0                                             0
2495729 2495729 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   grade_4                                                   0.0                                             0
2495730 2495730 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000618 30 Memorial Elementary School   Regular School No Elementary PK 04 2020   grade_4                                                   101.0                                             101
2495731 2495731 NJ Bergen 3 school 3410680 3350   Moonachie Boro 341068000620 60 Robert L. Craig School   Regular School No Elementary PK 08 2020   grade_4                                                   29.0                                             29
2495732 2495732 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000624 50 New Milford High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495733 2495733 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000626 60 Berkley Street School   Regular School No Elementary KG 05 2020   grade_4                                                   69.0                                             69
2495734 2495734 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000628 70 Bertrand F. Gibbs Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   75.0                                             75
2495735 2495735 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000632 85 David E. Owens Middle School   Regular School No Middle 06 08 2020   grade_4                                                   0.0                                             0
2495736 2495736 NJ Bergen 3 school 3411430 3600   North Arlington Boro 341143000636 50 North Arlington High School   Regular School No High 09 12 2020   grade_4                                                   0.0                                             0
2495737 2495737 NJ Bergen 3 school 3411430 3600   North Arlington Boro 341143000638 60 Jefferson Elementary School   Regular School No Elementary KG 05 2020   grade_4                                                   50.0                                             50

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