enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by school_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2374989 2374989 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377494 2377494 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   kindergarten_full_day                                                   0.0                                             0
2379999 2379999 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   kindergarten_half_day                                                   0.0                                             0
2382504 2382504 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   ungraded                                                   4.0                                             4
2385009 2385009 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_1                                                   0.0                                             0
2387514 2387514 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_2                                                   0.0                                             0
2390019 2390019 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_3                                                   0.0                                             0
2392524 2392524 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_4                                                   0.0                                             0
2395029 2395029 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_5                                                   0.0                                             0
2397534 2397534 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_6                                                   1.0                                             1
2400039 2400039 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_7                                                   0.0                                             0
2402544 2402544 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_8                                                   1.0                                             1
2405049 2405049 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_9                                                   2.0                                             2
2407554 2407554 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_10                                                   5.0                                             5
2410059 2410059 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_11                                                   8.0                                             8
2412564 2412564 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   grade_12                                                   4.0                                             4
2475060 2475060 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   pk_12_total 5.0 16.0 9.0 0.0   0.0 0.0       1.0             6.5   3.2     58.0     31.0 5 16 9 0   0 0       1                       31
2477562 2477562 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480064 2480064 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482566 2482566 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   kindergarten_full_day                                                   0.0                                             0
2485068 2485068 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2487570 2487570 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   ungraded                                                   7.0                                             7
2490072 2490072 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_1                                                   0.0                                             0
2492574 2492574 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_2                                                   0.0                                             0
2495076 2495076 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_3                                                   0.0                                             0
2497578 2497578 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_4                                                   0.0                                             0
2500080 2500080 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_5                                                   0.0                                             0
2502582 2502582 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_6                                                   0.0                                             0
2505084 2505084 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_7                                                   0.0                                             0
2507586 2507586 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_8                                                   0.0                                             0
2510088 2510088 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_9                                                   3.0                                             3
2512590 2512590 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_10                                                   6.0                                             6
2515092 2515092 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_11                                                   8.0                                             8
2517594 2517594 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   grade_12                                                   7.0                                             7
2369978 2369978 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   pk_12_total 40.0 28.0 43.0 0.0   1.0 0.0       3.0             4.3   2.6     20.9     115.0 40 28 43 0   1 0       3                       115
2372483 2372483 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2374988 2374988 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377493 2377493 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   kindergarten_full_day                                                   2.0                                             2
2379998 2379998 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   kindergarten_half_day                                                   0.0                                             0
2382503 2382503 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   ungraded                                                   92.0                                             92
2385008 2385008 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_1                                                   3.0                                             3
2387513 2387513 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_2                                                   0.0                                             0
2390018 2390018 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_3                                                   0.0                                             0
2392523 2392523 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_4                                                   2.0                                             2
2395028 2395028 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_5                                                   1.0                                             1
2397533 2397533 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_6                                                   1.0                                             1
2400038 2400038 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_7                                                   1.0                                             1
2402543 2402543 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_8                                                   1.0                                             1
2405048 2405048 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_9                                                   2.0                                             2
2407553 2407553 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_10                                                   0.0                                             0
2410058 2410058 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_11                                                   4.0                                             4
2412563 2412563 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   grade_12                                                   6.0                                             6
2475059 2475059 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   pk_12_total 41.0 28.0 44.0 0.0   1.0 0.0       4.0             3.4   0.0     32.2     118.0 41 28 44 0   1 0       4                       118
2477561 2477561 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480063 2480063 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482565 2482565 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   kindergarten_full_day                                                   0.0                                             0
2485067 2485067 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   kindergarten_half_day                                                   0.0                                             0
2487569 2487569 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   ungraded                                                   96.0                                             96
2490071 2490071 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_1                                                   2.0                                             2
2492573 2492573 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_2                                                   0.0                                             0
2495075 2495075 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_3                                                   3.0                                             3
2497577 2497577 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_4                                                   1.0                                             1
2500079 2500079 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_5                                                   1.0                                             1
2502581 2502581 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_6                                                   1.0                                             1
2505083 2505083 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_7                                                   2.0                                             2
2507585 2507585 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_8                                                   1.0                                             1
2510087 2510087 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_9                                                   2.0                                             2
2512589 2512589 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_10                                                   3.0                                             3
2515091 2515091 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_11                                                   2.0                                             2
2517593 2517593 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2020   grade_12                                                   4.0                                             4
2370103 2370103 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   pk_12_total 33.0 2.0 1.0 0.0   0.0 0.0       1.0             0.0   0.0     16.2     37.0 33 2 1 0   0 0       1                       37
2372608 2372608 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2375113 2375113 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2377618 2377618 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   kindergarten_full_day                                                   0.0                                             0
2380123 2380123 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   kindergarten_half_day                                                   0.0                                             0
2382628 2382628 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   ungraded                                                   23.0                                             23
2385133 2385133 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_1                                                   1.0                                             1
2387638 2387638 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_2                                                   2.0                                             2
2390143 2390143 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_3                                                   3.0                                             3
2392648 2392648 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_4                                                   0.0                                             0
2395153 2395153 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_5                                                   1.0                                             1
2397658 2397658 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_6                                                   1.0                                             1
2400163 2400163 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_7                                                   0.0                                             0
2402668 2402668 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_8                                                   0.0                                             0
2405173 2405173 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_9                                                   1.0                                             1
2407678 2407678 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_10                                                   0.0                                             0
2410183 2410183 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_11                                                   2.0                                             2
2412688 2412688 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   grade_12                                                   3.0                                             3
2475184 2475184 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   pk_12_total 35.0 2.0 1.0 0.0   1.0 0.0       1.0             0   0.0     20.0     40.0 35 2 1 0   1 0       1                       40
2477686 2477686 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2480188 2480188 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2482690 2482690 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   kindergarten_full_day                                                   0.0                                             0
2485192 2485192 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   kindergarten_half_day                                                   0.0                                             0
2487694 2487694 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   ungraded                                                   25.0                                             25
2490196 2490196 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   grade_1                                                   1.0                                             1
2492698 2492698 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   grade_2                                                   2.0                                             2
2495200 2495200 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   grade_3                                                   1.0                                             1
2497702 2497702 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   grade_4                                                   2.0                                             2
2500204 2500204 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2020   grade_5                                                   1.0                                             1
2502706 2502706 NJ Sussex 37 school 3480320 5105   Sussex Co Ed Serv Comm 348032005960 50 Northern Hills Academy   Special Education School No Other PK 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]);