enrollments

Data source: Big Local News · About: Big Local

45,090 rows where state = "NJ" and year = 2021 sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2021 · 44,890 ✖
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
2399545 2399545 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024006080 50 Regional Achievement Academy   Alternative School No High 06 12 2021   grade_7                                                   0.0                                             0
2399916 2399916 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   grade_7                                                   0.0                                             0
2399958 2399958 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   grade_7                                                   0.0                                             0
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
2400307 2400307 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   grade_7                                                   0.0                                             0
2400308 2400308 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   grade_7                                                   0.0                                             0
2400315 2400315 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   grade_7                                                   0.0                                             0
2400318 2400318 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2021   grade_7                                                   0.0                                             0
2400831 2400831 NJ Burlington 5 school 3402440 605   Burlington County Special Services School District 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2021   grade_8                                                   0.0                                             0
2400939 2400939 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003421 300 Willingboro Alternative School   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2400979 2400979 NJ Camden 7 school 3402640 680   Camden City School District 340264003441 303 Pride Academy   Alternative School No High 06 12 2021   grade_8                                                   10.0                                             10
2401060 2401060 NJ Camden 7 school 3412870 4060   Pennsauken Township Board Of Education School District 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2021   grade_8                                                   5.0                                             5
2401225 2401225 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000135 30 Essex High School   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2401226 2401226 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2401289 2401289 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003117 2 Uplift Academy   Alternative School No High 10 12 2021   grade_8                                                   0.0                                             0
2402049 2402049 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2021   grade_8                                                   0.0                                             0
2402050 2402050 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024006080 50 Regional Achievement Academy   Alternative School No High 06 12 2021   grade_8                                                   1.0                                             1
2402421 2402421 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2402463 2402463 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   grade_8                                                   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
2402812 2402812 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2402813 2402813 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2402820 2402820 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2402823 2402823 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2021   grade_8                                                   0.0                                             0
2403336 2403336 NJ Burlington 5 school 3402440 605   Burlington County Special Services School District 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2021   grade_9                                                   5.0                                             5
2403444 2403444 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003421 300 Willingboro Alternative School   Alternative School No High 09 12 2021   grade_9                                                   0.0                                             0
2403484 2403484 NJ Camden 7 school 3402640 680   Camden City School District 340264003441 303 Pride Academy   Alternative School No High 06 12 2021   grade_9                                                   8.0                                             8
2403565 2403565 NJ Camden 7 school 3412870 4060   Pennsauken Township Board Of Education School District 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2021   grade_9                                                   11.0                                             11
2403730 2403730 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000135 30 Essex High School   Alternative School No High 09 12 2021   grade_9                                                   6.0                                             6
2403731 2403731 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2021   grade_9                                                   0.0                                             0
2403794 2403794 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003117 2 Uplift Academy   Alternative School No High 10 12 2021   grade_9                                                   0.0                                             0
2404554 2404554 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2021   grade_9                                                   0.0                                             0
2404555 2404555 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024006080 50 Regional Achievement Academy   Alternative School No High 06 12 2021   grade_9                                                   0.0                                             0
2404926 2404926 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   grade_9                                                   3.0                                             3
2404968 2404968 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   grade_9                                                   0.0                                             0
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
2405317 2405317 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   grade_9                                                   1.0                                             1
2405318 2405318 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   grade_9                                                   6.0                                             6
2405325 2405325 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   grade_9                                                   0.0                                             0
2405328 2405328 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2021   grade_9                                                   1.0                                             1
2405841 2405841 NJ Burlington 5 school 3402440 605   Burlington County Special Services School District 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2021   grade_10                                                   19.0                                             19
2405949 2405949 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003421 300 Willingboro Alternative School   Alternative School No High 09 12 2021   grade_10                                                   4.0                                             4
2405989 2405989 NJ Camden 7 school 3402640 680   Camden City School District 340264003441 303 Pride Academy   Alternative School No High 06 12 2021   grade_10                                                   15.0                                             15
2406070 2406070 NJ Camden 7 school 3412870 4060   Pennsauken Township Board Of Education School District 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2021   grade_10                                                   2.0                                             2
2406235 2406235 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000135 30 Essex High School   Alternative School No High 09 12 2021   grade_10                                                   5.0                                             5
2406236 2406236 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2021   grade_10                                                   1.0                                             1
2406299 2406299 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003117 2 Uplift Academy   Alternative School No High 10 12 2021   grade_10                                                   0.0                                             0
2407059 2407059 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2021   grade_10                                                   0.0                                             0
2407060 2407060 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024006080 50 Regional Achievement Academy   Alternative School No High 06 12 2021   grade_10                                                   2.0                                             2
2407431 2407431 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   grade_10                                                   3.0                                             3
2407473 2407473 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   grade_10                                                   19.0                                             19
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
2407822 2407822 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   grade_10                                                   9.0                                             9
2407823 2407823 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   grade_10                                                   26.0                                             26
2407830 2407830 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   grade_10                                                   0.0                                             0
2407833 2407833 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2021   grade_10                                                   0.0                                             0
2408346 2408346 NJ Burlington 5 school 3402440 605   Burlington County Special Services School District 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2021   grade_11                                                   24.0                                             24
2408454 2408454 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003421 300 Willingboro Alternative School   Alternative School No High 09 12 2021   grade_11                                                   8.0                                             8
2408494 2408494 NJ Camden 7 school 3402640 680   Camden City School District 340264003441 303 Pride Academy   Alternative School No High 06 12 2021   grade_11                                                   13.0                                             13
2408575 2408575 NJ Camden 7 school 3412870 4060   Pennsauken Township Board Of Education School District 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2021   grade_11                                                   11.0                                             11
2408740 2408740 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000135 30 Essex High School   Alternative School No High 09 12 2021   grade_11                                                   8.0                                             8
2408741 2408741 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2021   grade_11                                                   4.0                                             4
2408804 2408804 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003117 2 Uplift Academy   Alternative School No High 10 12 2021   grade_11                                                   1.0                                             1
2409564 2409564 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2021   grade_11                                                   1.0                                             1
2409565 2409565 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024006080 50 Regional Achievement Academy   Alternative School No High 06 12 2021   grade_11                                                   5.0                                             5
2409936 2409936 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   grade_11                                                   6.0                                             6
2409978 2409978 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   grade_11                                                   48.0                                             48
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
2410327 2410327 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   grade_11                                                   19.0                                             19
2410328 2410328 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   grade_11                                                   30.0                                             30
2410335 2410335 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   grade_11                                                   8.0                                             8
2410338 2410338 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2021   grade_11                                                   2.0                                             2
2410851 2410851 NJ Burlington 5 school 3402440 605   Burlington County Special Services School District 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2021   grade_12                                                   34.0                                             34
2410959 2410959 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003421 300 Willingboro Alternative School   Alternative School No High 09 12 2021   grade_12                                                   10.0                                             10
2410999 2410999 NJ Camden 7 school 3402640 680   Camden City School District 340264003441 303 Pride Academy   Alternative School No High 06 12 2021   grade_12                                                   8.0                                             8
2411080 2411080 NJ Camden 7 school 3412870 4060   Pennsauken Township Board Of Education School District 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2021   grade_12                                                   3.0                                             3
2411245 2411245 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000135 30 Essex High School   Alternative School No High 09 12 2021   grade_12                                                   7.0                                             7
2411246 2411246 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2021   grade_12                                                   13.0                                             13
2411309 2411309 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003117 2 Uplift Academy   Alternative School No High 10 12 2021   grade_12                                                   0.0                                             0
2412069 2412069 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2021   grade_12                                                   1.0                                             1
2412070 2412070 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Educational Services Commission School Distri 348024006080 50 Regional Achievement Academy   Alternative School No High 06 12 2021   grade_12                                                   3.0                                             3
2412441 2412441 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   grade_12                                                   40.0                                             40
2412483 2412483 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   grade_12                                                   58.0                                             58
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
2412832 2412832 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   grade_12                                                   21.0                                             21
2412833 2412833 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   grade_12                                                   22.0                                             22
2412840 2412840 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   grade_12                                                   12.0                                             12
2412843 2412843 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003363 300 Raymond J. Lesniak Experience Strength & Hope Recovery Hs   Alternative School No High 09 12 2021   grade_12                                                   3.0                                             3
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]);