enrollments

Data source: Big Local News · About: Big Local

45,036 rows where state = "NJ" and year = 2020 sorted by district_nces_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 44,936 ✖
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
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
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
2505081 2505081 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   grade_7                                                   1.0                                             1
2505082 2505082 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   grade_7                                                   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
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
2507583 2507583 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   grade_8                                                   0.0                                             0
2507584 2507584 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   grade_8                                                   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
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
2510085 2510085 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   grade_9                                                   2.0                                             2
2510086 2510086 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   grade_9                                                   0.0                                             0
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
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
2512587 2512587 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   grade_10                                                   1.0                                             1
2512588 2512588 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   grade_10                                                   1.0                                             1
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
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
2515089 2515089 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   grade_11                                                   0.0                                             0
2515090 2515090 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   grade_11                                                   0.0                                             0
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
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
2517591 2517591 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103297 9 Salem Campus   Special Education School No Other KG 12 2020   grade_12                                                   5.0                                             5
2517592 2517592 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036106102 50 Daretown School   Special Education School No Other PK 12 2020   grade_12                                                   0.0                                             0
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
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
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
2505208 2505208 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_7                                                   0.0                                             0
2507710 2507710 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_8                                                   1.0                                             1
2510212 2510212 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_9                                                   0.0                                             0
2512714 2512714 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_10                                                   3.0                                             3
2515216 2515216 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_11                                                   0.0                                             0
2517718 2517718 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_12                                                   4.0                                             4
2473744 2473744 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   pk_12_total 3.0 16.0 14.0 0.0   0.0 0.0       0.0             0   6.1     57.5     33.0 3 16 14 0   0 0       0                       33
2473745 2473745 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   pk_12_total 0.0 10.0 9.0 0.0   0.0 0.0       0.0             0   0.0     57.9     19.0 0 10 9 0   0 0       0                       19
2473746 2473746 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   pk_12_total 0.0 20.0 3.0 0.0   1.0 0.0       0.0             0   8.3     58.400000000000006     24.0 0 20 3 0   1 0       0                       24
2476246 2476246 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476247 2476247 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476248 2476248 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2478748 2478748 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478749 2478749 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478750 2478750 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2481250 2481250 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2481251 2481251 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   kindergarten_full_day                                                   0.0                                             0
2481252 2481252 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   kindergarten_full_day                                                   0.0                                             0
2483752 2483752 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483753 2483753 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483754 2483754 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   kindergarten_half_day                                                   0.0                                             0
2486254 2486254 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   ungraded                                                   2.0                                             2
2486255 2486255 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   ungraded                                                   2.0                                             2
2486256 2486256 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   ungraded                                                   6.0                                             6
2488756 2488756 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_1                                                   0.0                                             0
2488757 2488757 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_1                                                   0.0                                             0
2488758 2488758 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_1                                                   1.0                                             1
2491258 2491258 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_2                                                   0.0                                             0
2491259 2491259 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_2                                                   0.0                                             0
2491260 2491260 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_2                                                   1.0                                             1
2493760 2493760 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_3                                                   0.0                                             0
2493761 2493761 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_3                                                   0.0                                             0
2493762 2493762 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_3                                                   0.0                                             0
2496262 2496262 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_4                                                   0.0                                             0
2496263 2496263 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_4                                                   0.0                                             0
2496264 2496264 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_4                                                   2.0                                             2
2498764 2498764 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_5                                                   0.0                                             0
2498765 2498765 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_5                                                   0.0                                             0
2498766 2498766 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_5                                                   1.0                                             1
2501266 2501266 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_6                                                   0.0                                             0
2501267 2501267 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_6                                                   0.0                                             0
2501268 2501268 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_6                                                   4.0                                             4
2503768 2503768 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2503769 2503769 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2503770 2503770 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_7                                                   0.0                                             0
2506270 2506270 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2506271 2506271 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2506272 2506272 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_8                                                   6.0                                             6
2508772 2508772 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_9                                                   0.0                                             0
2508773 2508773 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_9                                                   1.0                                             1
2508774 2508774 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_9                                                   2.0                                             2
2511274 2511274 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_10                                                   6.0                                             6
2511275 2511275 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_10                                                   7.0                                             7
2511276 2511276 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_10                                                   0.0                                             0
2513776 2513776 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_11                                                   8.0                                             8
2513777 2513777 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_11                                                   3.0                                             3
2513778 2513778 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_11                                                   1.0                                             1
2516278 2516278 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   grade_12                                                   17.0                                             17
2516279 2516279 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   grade_12                                                   6.0                                             6
2516280 2516280 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030006040 40 Essex Junior Academy   Special Education School No Other KG 12 2020   grade_12                                                   0.0                                             0
2475129 2475129 NJ Somerset 35 school 3480280 4805   Somerset Co Ed Serv Comm 348028005918 50 Somerset Secondary Academy   Special Education School No High 09 12 2020   pk_12_total 8.0 28.0 16.0 0.0   0.0 0.0       0.0             1.9   1.9     30.8     52.0 8 28 16 0   0 0       0                       52
2475130 2475130 NJ Somerset 35 school 3480280 4805   Somerset Co Ed Serv Comm 348028000070 60 Somerset Elementary Academy   Special Education School No Elementary KG 08 2020   pk_12_total 3.0 27.0 7.0 0.0   1.0 0.0       1.0             0   10.3     41.0     39.0 3 27 7 0   1 0       1                       39

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