enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by ccd_school_type

✎ 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
2504591 2504591 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   grade_7                                                   0.0                                             0
2504962 2504962 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2504972 2504972 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_7                                                   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
2505354 2505354 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2505355 2505355 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2505364 2505364 NJ Union 39 school 3418040 5260   Union County Vocational 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2505366 2505366 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   grade_7                                                   0.0                                             0
2505528 2505528 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2505876 2505876 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   grade_8                                                   1.0                                             1
2505990 2505990 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   grade_8                                                   0.0                                             0
2506023 2506023 NJ Camden 7 school 3402640 680   Camden City 340264003441 303 Pride Academy   Alternative School No High 06 12 2020   grade_8                                                   3.0                                             3
2506113 2506113 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_8                                                   10.0                                             10
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
2507092 2507092 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024006080 50 Regional Alternative School   Alternative School No High 06 12 2020   grade_8                                                   0.0                                             0
2507093 2507093 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   grade_8                                                   0.0                                             0
2507464 2507464 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2507474 2507474 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_8                                                   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
2507856 2507856 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2507857 2507857 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2507866 2507866 NJ Union 39 school 3418040 5260   Union County Vocational 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2507868 2507868 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   grade_8                                                   0.0                                             0
2508030 2508030 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_9                                                   11.0                                             11
2508378 2508378 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   grade_9                                                   6.0                                             6
2508492 2508492 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   grade_9                                                   1.0                                             1
2508525 2508525 NJ Camden 7 school 3402640 680   Camden City 340264003441 303 Pride Academy   Alternative School No High 06 12 2020   grade_9                                                   2.0                                             2
2508615 2508615 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_9                                                   3.0                                             3
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
2509594 2509594 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024006080 50 Regional Alternative School   Alternative School No High 06 12 2020   grade_9                                                   0.0                                             0
2509595 2509595 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   grade_9                                                   0.0                                             0
2509966 2509966 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   grade_9                                                   2.0                                             2
2509976 2509976 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_9                                                   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
2510358 2510358 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_9                                                   20.0                                             20
2510359 2510359 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   grade_9                                                   22.0                                             22
2510368 2510368 NJ Union 39 school 3418040 5260   Union County Vocational 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2020   grade_9                                                   0.0                                             0
2510370 2510370 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   grade_9                                                   0.0                                             0
2510532 2510532 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_10                                                   8.0                                             8
2510880 2510880 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   grade_10                                                   25.0                                             25
2510994 2510994 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   grade_10                                                   5.0                                             5
2511027 2511027 NJ Camden 7 school 3402640 680   Camden City 340264003441 303 Pride Academy   Alternative School No High 06 12 2020   grade_10                                                   1.0                                             1
2511117 2511117 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_10                                                   6.0                                             6
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
2512096 2512096 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024006080 50 Regional Alternative School   Alternative School No High 06 12 2020   grade_10                                                   5.0                                             5
2512097 2512097 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   grade_10                                                   1.0                                             1
2512468 2512468 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   grade_10                                                   5.0                                             5
2512478 2512478 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_10                                                   25.0                                             25
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
2512860 2512860 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_10                                                   34.0                                             34
2512861 2512861 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   grade_10                                                   43.0                                             43
2512870 2512870 NJ Union 39 school 3418040 5260   Union County Vocational 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2020   grade_10                                                   2.0                                             2
2512872 2512872 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   grade_10                                                   12.0                                             12
2513034 2513034 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_11                                                   18.0                                             18
2513382 2513382 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   grade_11                                                   26.0                                             26
2513496 2513496 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   grade_11                                                   11.0                                             11
2513529 2513529 NJ Camden 7 school 3402640 680   Camden City 340264003441 303 Pride Academy   Alternative School No High 06 12 2020   grade_11                                                   4.0                                             4
2513619 2513619 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_11                                                   13.0                                             13
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
2514598 2514598 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024006080 50 Regional Alternative School   Alternative School No High 06 12 2020   grade_11                                                   2.0                                             2
2514599 2514599 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   grade_11                                                   0.0                                             0
2514970 2514970 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   grade_11                                                   12.0                                             12
2514980 2514980 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_11                                                   52.0                                             52
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
2515362 2515362 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_11                                                   29.0                                             29
2515363 2515363 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   grade_11                                                   23.0                                             23
2515372 2515372 NJ Union 39 school 3418040 5260   Union County Vocational 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2020   grade_11                                                   9.0                                             9
2515374 2515374 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   grade_11                                                   11.0                                             11
2515536 2515536 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   grade_12                                                   9.0                                             9
2515884 2515884 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   grade_12                                                   28.0                                             28
2515998 2515998 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   grade_12                                                   7.0                                             7
2516031 2516031 NJ Camden 7 school 3402640 680   Camden City 340264003441 303 Pride Academy   Alternative School No High 06 12 2020   grade_12                                                   2.0                                             2
2516121 2516121 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   grade_12                                                   8.0                                             8
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
2517100 2517100 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024006080 50 Regional Alternative School   Alternative School No High 06 12 2020   grade_12                                                   4.0                                             4
2517101 2517101 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   grade_12                                                   0.0                                             0
2517472 2517472 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   grade_12                                                   42.0                                             42
2517482 2517482 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   grade_12                                                   58.0                                             58
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
2517864 2517864 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   grade_12                                                   8.0                                             8
2517865 2517865 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   grade_12                                                   6.0                                             6
2517874 2517874 NJ Union 39 school 3418040 5260   Union County Vocational 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2020   grade_12                                                   1.0                                             1
2517876 2517876 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   grade_12                                                   7.0                                             7
2367915 2367915 NJ Atlantic 1 school 3400990 120   Atlantic County Vocational School District 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2021   pk_12_total 516.0 296.0 721.0 5.0   102.0 9.0       64.0             0.0   0.6     58.2     1713.0 516 296 721 5   102 9       64                       1713
2367983 2367983 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000264 75 Bergen County Technical High School - Paramus   Career and Technical School No High 09 12 2021   pk_12_total 68.0 17.0 46.0 0.0   1.5 0.0       0.0             0.0   0.0     32.5     132.5 68 17 46 0   1 0       0                       132
2367984 2367984 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000262 70 Bergen County Technical High School - Teterboro   Career and Technical School No High 09 12 2021   pk_12_total 280.5 49.0 128.0 1.0   213.0 6.0       0.0             0.0   0.0     5.9     677.5 280 49 128 1   213 6       0                       677
2367985 2367985 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147003341 300 Applied Technology High School   Career and Technical School No High 09 12 2021   pk_12_total 97.5 18.0 64.0 0.0   32.0 2.0       0.0             0.0   0.0     10.7     213.5 97 18 64 0   32 2       0                       213
2367986 2367986 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000250 20 Bergen County Academies   Career and Technical School No High 09 12 2021   pk_12_total 415.0 32.0 88.0 0.0   579.0 4.0       0.0             0.0   0.0     2.8     1118.0 415 32 88 0   579 4       0                       1118
2368267 2368267 NJ Burlington 5 school 3402490 610   Burlington County Institute Of Technology School District 340249000998 40 Burlington County Institute Of Technology - Medford   Career and Technical School No High 09 12 2021   pk_12_total 523.0 147.0 163.0 2.0   10.0 0.0       51.0             0.0   0.0     29.3     896.0 523 147 163 2   10 0       51                       896
2368268 2368268 NJ Burlington 5 school 3402490 610   Burlington County Institute Of Technology School District 340249000996 30 Burlington County Institute Of Technology - Westampton   Career and Technical School No High 09 12 2021   pk_12_total 296.0 599.0 235.0 2.0   26.0 2.0       81.0             0.8   0.1     40.0     1241.0 296 599 235 2   26 2       81                       1241
2368415 2368415 NJ Camden 7 school 3402670 700   Camden County Technical School District 340267001412 30 Camden County Technical School-Pennsauken   Career and Technical School No High 09 12 2021   pk_12_total 49.0 160.0 534.0 0.0   29.0 0.0       10.0             0.5   0.6     76.19999999999999     782.0 49 160 534 0   29 0       10                       782
2368416 2368416 NJ Camden 7 school 3402670 700   Camden County Technical School District 340267001414 40 Camden County Technical School-Gtc   Career and Technical School No High 09 12 2021   pk_12_total 615.0 378.0 350.0 3.0   48.0 1.0       68.0             0.2   0.7     44.8     1463.0 615 378 350 3   48 1       68                       1463
2368534 2368534 NJ Cape May 9 school 3402730 720   Cape May County Technical High School District 340273001712 30 Cape May County Technical High School   Career and Technical School No High 09 12 2021   pk_12_total 470.0 26.0 62.5 0.0   11.0 1.0       7.5             0.1   0.4     18.7     578.0 470 26 62 0   11 1       7                       578
2368570 2368570 NJ Cumberland 11 school 3403610 995   Cumberland County Board Of Vocational Education 340361001816 30 Cumberland County Technical Education Center   Career and Technical School No High 09 12 2021   pk_12_total 510.0 78.0 347.0 1.0   30.0 0.0       6.0             0.0   0.1     22.3     972.0 510 78 347 1   30 0       6                       972
2368662 2368662 NJ Essex 13 school 3404800 1390   Essex County Schools Of Technology 340480002074 50 Essex County Donald M. Payne Sr. School Of Technology   Career and Technical School No High 09 12 2021   pk_12_total 16.5 521.0 713.5 7.0   8.0 6.0       20.0             5.2   0.0     70.3     1292.0 16 521 713 7   8 6       20                       1292

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