enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "grade_12", state = "NJ" and year = 2020 sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • grade_12 · 2,502 ✖
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
2517898 2517898 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   grade_12                                                   0.0                                             0
2517899 2517899 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   grade_12                                                   0.0                                             0
2517900 2517900 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517901 2517901 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   grade_12                                                   106.0                                             106
2517902 2517902 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517903 2517903 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   grade_12                                                   0.0                                             0
2517904 2517904 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   grade_12                                                   0.0                                             0
2517905 2517905 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   grade_12                                                   0.0                                             0
2517906 2517906 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   grade_12                                                   0.0                                             0
2517907 2517907 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   grade_12                                                   0.0                                             0
2517908 2517908 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   grade_12                                                   0.0                                             0
2517909 2517909 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
2517910 2517910 NJ Warren 41 school 3406300 1870   Hackettstown 340630005814 50 Hackettstown High School   Regular School No High 09 12 2020   grade_12                                                   195.0                                             195
2517911 2517911 NJ Warren 41 school 3406300 1870   Hackettstown 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2020   grade_12                                                   0.0                                             0
2517912 2517912 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   grade_12                                                   0.0                                             0
2517913 2517913 NJ Warren 41 school 3406300 1870   Hackettstown 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2020   grade_12                                                   0.0                                             0
2517914 2517914 NJ Warren 41 school 3406810 2040   Harmony Twp 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517915 2517915 NJ Warren 41 school 3407470 2250   Hope Twp 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517916 2517916 NJ Warren 41 school 3408070 2470   Knowlton Twp 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2020   grade_12                                                   0.0                                             0
2517917 2517917 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2020   grade_12                                                   0.0                                             0
2517918 2517918 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2020   grade_12                                                   0.0                                             0
2517919 2517919 NJ Warren 41 school 3409540 2970   Mansfield Twp 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2020   grade_12                                                   0.0                                             0
2517920 2517920 NJ Warren 41 school 3409550 3675   North Warren Regional 340955005844 50 North Warren Regional School   Regular School No High 07 12 2020   grade_12                                                   134.0                                             134
2517921 2517921 NJ Warren 41 school 3412300 3890   Oxford Twp 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517922 2517922 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   grade_12                                                   423.0                                             423
2517923 2517923 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   grade_12                                                   0.0                                             0
2517924 2517924 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   grade_12                                                   0.0                                             0
2517925 2517925 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
2517926 2517926 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   grade_12                                                   0.0                                             0
2517927 2517927 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517928 2517928 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   grade_12                                                   83.0                                             83
2517929 2517929 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   grade_12                                                   269.0                                             269
2517930 2517930 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   grade_12                                                   0.0                                             0
2517931 2517931 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   grade_12                                                   0.0                                             0
2517932 2517932 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   grade_12                                                   0.0                                             0
2517933 2517933 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   grade_12                                                   0.0                                             0
2517934 2517934 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   grade_12                                                   0.0                                             0
2517935 2517935 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517727 2517727 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2020   grade_12                                                   264.5                                             264
2517728 2517728 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2020   grade_12                                                   0.0                                             0
2517729 2517729 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005436 30 Columbia Middle School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
2517730 2517730 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2020   grade_12                                                   0.0                                             0
2517731 2517731 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005440 40 Mountain Park School   Regular School No Elementary 02 05 2020   grade_12                                                   0.0                                             0
2517732 2517732 NJ Union 39 school 3401530 310   Berkeley Heights Twp 340153005442 50 William Woodruff School   Regular School No Elementary 02 05 2020   grade_12                                                   0.0                                             0
2517733 2517733 NJ Union 39 school 3403150 850   Clark Twp 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2020   grade_12                                                   162.5                                             162
2517734 2517734 NJ Union 39 school 3403150 850   Clark Twp 340315005450 30 Frank K. Hehnly   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
2517735 2517735 NJ Union 39 school 3403150 850   Clark Twp 340315005452 35 Carl H. Kumpf School   Regular School No Middle 06 08 2020   grade_12                                                   0.0                                             0
2517736 2517736 NJ Union 39 school 3403150 850   Clark Twp 340315005454 40 Valley Road School   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
2517737 2517737 NJ Union 39 school 3403150 850   Clark Twp 340315003295 300 Clark Preschool Annex   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
2517738 2517738 NJ Union 39 school 3403570 980   Cranford Twp 340357005458 30 Cranford High School   Regular School No High 09 12 2020   grade_12                                                   259.5                                             259
2517739 2517739 NJ Union 39 school 3403570 980   Cranford Twp 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517740 2517740 NJ Union 39 school 3403570 980   Cranford Twp 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2020   grade_12                                                   0.0                                             0
2517741 2517741 NJ Union 39 school 3403570 980   Cranford Twp 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2020   grade_12                                                   0.0                                             0
2517742 2517742 NJ Union 39 school 3403570 980   Cranford Twp 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2020   grade_12                                                   0.0                                             0
2517743 2517743 NJ Union 39 school 3403570 980   Cranford Twp 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2020   grade_12                                                   0.0                                             0
2517744 2517744 NJ Union 39 school 3403570 980   Cranford Twp 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2020   grade_12                                                   0.0                                             0
2517745 2517745 NJ Union 39 school 3404590 1320   Elizabeth City 340459005478 25 Elizabeth High School - Frank J Cicarell Academy   Regular School No High 09 12 2020   grade_12                                                   282.0                                             282
2517746 2517746 NJ Union 39 school 3404590 1320   Elizabeth City 340459000013 30 Terence C. Reilly School No 7   Regular School No Middle 02 08 2020   grade_12                                                   0.0                                             0
2517747 2517747 NJ Union 39 school 3404590 1320   Elizabeth City 340459005482 35 Joseph Battin School No 4   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517748 2517748 NJ Union 39 school 3404590 1320   Elizabeth City 340459005492 90 George Washington Academy School No. 1   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517749 2517749 NJ Union 39 school 3404590 1320   Elizabeth City 340459005494 100 Winfield Scott School No. 2   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517750 2517750 NJ Union 39 school 3404590 1320   Elizabeth City 340459005962 110 Nicholas S. Lacorte-Peterstown School No. 3   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517751 2517751 NJ Union 39 school 3404590 1320   Elizabeth City 340459005498 120 Toussaint Louverture-Marquis De Lafayette School No. 6   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517752 2517752 NJ Union 39 school 3404590 1320   Elizabeth City 340459005504 150 Elmora School No. 12   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517753 2517753 NJ Union 39 school 3404590 1320   Elizabeth City 340459005506 160 Benjamin Franklin School No. 13   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517754 2517754 NJ Union 39 school 3404590 1320   Elizabeth City 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517755 2517755 NJ Union 39 school 3404590 1320   Elizabeth City 340459005510 180 Christopher Columbus School No. 15   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517756 2517756 NJ Union 39 school 3404590 1320   Elizabeth City 340459005512 190 Madison Monroe School No. 16   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517757 2517757 NJ Union 39 school 3404590 1320   Elizabeth City 340459005516 210 Robert Morris School No. 18   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517758 2517758 NJ Union 39 school 3404590 1320   Elizabeth City 340459005518 220 Woodrow Wilson School No. 19   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517759 2517759 NJ Union 39 school 3404590 1320   Elizabeth City 340459005520 230 John Marshal School No. 20   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517760 2517760 NJ Union 39 school 3404590 1320   Elizabeth City 340459005522 240 Victor Mravlag School No. 21   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517761 2517761 NJ Union 39 school 3404590 1320   Elizabeth City 340459005524 250 William F. Halloran School No.22   Regular School No Middle 02 08 2020   grade_12                                                   0.0                                             0
2517762 2517762 NJ Union 39 school 3404590 1320   Elizabeth City 340459005526 260 Nicholas Murray Butler Academy School No. 23   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517763 2517763 NJ Union 39 school 3404590 1320   Elizabeth City 340459000207 280 Sonia Sotomayor School No 25   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517764 2517764 NJ Union 39 school 3404590 1320   Elizabeth City 340459000245 290 Dr. Orlando Edreira Academy School No. 26   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517765 2517765 NJ Union 39 school 3404590 1320   Elizabeth City 340459000806 295 Dr. Albert Einstein Academy School No. 29   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517766 2517766 NJ Union 39 school 3404590 1320   Elizabeth City 340459000071 300 Mabel G. Homes School No. 5   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517767 2517767 NJ Union 39 school 3404590 1320   Elizabeth City 340459003197 301 Iprep Academy School No 8   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517768 2517768 NJ Union 39 school 3404590 1320   Elizabeth City 340459003293 302 Jerome Dunn Academy No 9   Regular School No Elementary KG 08 2020   grade_12                                                   0.0                                             0
2517769 2517769 NJ Union 39 school 3404590 1320   Elizabeth City 340459003389 303 J. Christian Bollwage Finance Academy   Regular School No High 09 12 2020   grade_12                                                   131.0                                             131
2517770 2517770 NJ Union 39 school 3404590 1320   Elizabeth City 340459000825 305 Chessie Dentley Roberts Academy School No. 30   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517771 2517771 NJ Union 39 school 3404590 1320   Elizabeth City 340459002997 310 Dr. Antonia Pantoja School No. 27   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517772 2517772 NJ Union 39 school 3404590 1320   Elizabeth City 340459002983 315 Juan Pablo Duarte - Jose Julian Marti School No 28   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517773 2517773 NJ Union 39 school 3404590 1320   Elizabeth City 340459000467 350 Frances C. Smith Early Childhood Center No 50   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
2517774 2517774 NJ Union 39 school 3404590 1320   Elizabeth City 340459006131 355 Donald Stewart Early Childhood Center No 51   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
2517775 2517775 NJ Union 39 school 3404590 1320   Elizabeth City 340459000567 360 Dr. Martin Luther King Jr. Early Childhood Center No 52   Regular School No Prekindergarten PK PK 2020   grade_12                                                   0.0                                             0
2517776 2517776 NJ Union 39 school 3404590 1320   Elizabeth City 340459003071 401 John E. Dwyer Technology Academy   Regular School No High 09 12 2020   grade_12                                                   213.0                                             213
2517777 2517777 NJ Union 39 school 3404590 1320   Elizabeth City 340459003039 402 Admiral William F. Halsey Jr. Health & Public Safety Academy   Regular School No High 09 12 2020   grade_12                                                   209.0                                             209
2517778 2517778 NJ Union 39 school 3404590 1320   Elizabeth City 340459003049 403 Thomas Jefferson Arts Academy   Regular School No High 09 12 2020   grade_12                                                   184.0                                             184
2517779 2517779 NJ Union 39 school 3404590 1320   Elizabeth City 340459003045 404 Thomas A. Edison Career And Technical Academy   Regular School No High 09 12 2020   grade_12                                                   165.0                                             165
2517780 2517780 NJ Union 39 school 3404590 1320   Elizabeth City 340459003043 405 Alexander Hamilton Preparatory Academy   Regular School No High 09 12 2020   grade_12                                                   231.0                                             231
2517781 2517781 NJ Union 39 school 3405790 1710   Garwood Boro 340579005532 50 Lincoln   Regular School No Elementary PK 08 2020   grade_12                                                   0.0                                             0
2517782 2517782 NJ Union 39 school 3407290 2190   Hillside Twp 340729005540 50 Hillside High School   Regular School No High 09 12 2020   grade_12                                                   207.0                                             207
2517783 2517783 NJ Union 39 school 3407290 2190   Hillside Twp 340729005542 60 Calvin Coolidge School   Regular School No Elementary 02 06 2020   grade_12                                                   0.0                                             0
2517784 2517784 NJ Union 39 school 3407290 2190   Hillside Twp 340729005544 80 Hurden Looker School   Regular School No Elementary 02 06 2020   grade_12                                                   0.0                                             0
2517785 2517785 NJ Union 39 school 3407290 2190   Hillside Twp 340729005546 85 Walter O. Krumbiegel Middle School   Regular School No Middle 07 08 2020   grade_12                                                   0.0                                             0
2517786 2517786 NJ Union 39 school 3407290 2190   Hillside Twp 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2020   grade_12                                                   0.0                                             0
2517787 2517787 NJ Union 39 school 3407290 2190   Hillside Twp 340729005550 110 George Washington School   Regular School No Elementary 02 06 2020   grade_12                                                   0.0                                             0
2517788 2517788 NJ Union 39 school 3407920 2420   Kenilworth Boro 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2020   grade_12                                                   118.0                                             118

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