enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

  • 2020 · 44,836 ✖
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
2473001 2473001 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2020   pk_12_total 523.0 321.0 673.0 6.0   86.0 10.0       48.0             0   0.6     62.8     1667.0 523 321 673 6   86 10       48                       1667
2473069 2473069 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 2020   pk_12_total 408.0 32.0 86.0 0.0   553.0 7.0       0.0             0   0.0     5.1     1086.0 408 32 86 0   553 7       0                       1086
2473071 2473071 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 2020   pk_12_total 284.0 52.5 129.0 1.0   200.0 8.0       0.0             0   0.0     9.6     674.5 284 52 129 1   200 8       0                       674
2473072 2473072 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 2020   pk_12_total 72.0 14.5 45.5 0.0   1.0 0.0       0.5             .4   0.0     38.6     133.5 72 14 45 0   1 0       0                       133
2473073 2473073 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 2020   pk_12_total 90.0 15.0 57.0 0.0   18.0 2.0       0.0             .5   0.0     16.5     182.0 90 15 57 0   18 2       0                       182
2473353 2473353 NJ Burlington 5 school 3402490 610   Burlington Co Vocational 340249000996 30 Burlington County Institute Of Technology - Westampton   Career and Technical School No High 09 12 2020   pk_12_total 273.0 626.0 237.0 3.0   22.0 2.0       94.0             1   0.1     48.5     1257.0 273 626 237 3   22 2       94                       1257
2473354 2473354 NJ Burlington 5 school 3402490 610   Burlington Co Vocational 340249000998 40 Burlington County Institute Of Technology - Medford   Career and Technical School No High 09 12 2020   pk_12_total 498.0 145.0 147.0 2.0   7.0 0.0       53.0             0   0.4     34.3     852.0 498 145 147 2   7 0       53                       852
2473502 2473502 NJ Camden 7 school 3402670 700   Camden County Vocational 340267001412 30 Camden County Technical School-Pennsauken   Career and Technical School No High 09 12 2020   pk_12_total 58.0 143.0 505.0 1.0   28.0 0.0       8.0             .4   0.9     83.6     743.0 58 143 505 1   28 0       8                       743
2473503 2473503 NJ Camden 7 school 3402670 700   Camden County Vocational 340267001414 40 Camden County Technical School-Gtc   Career and Technical School No High 09 12 2020   pk_12_total 527.0 384.0 338.0 2.0   33.0 1.0       62.0             .1   1.4     53.6     1347.0 527 384 338 2   33 1       62                       1347
2473620 2473620 NJ Cape May 9 school 3402730 720   Cape May County Vocational School District 340273001712 30 Cape May County Technical High School   Career and Technical School No High 09 12 2020   pk_12_total 493.5 26.0 57.0 0.0   12.0 1.0       0.5             0   0.1     23.799999999999997     590.0 493 26 57 0   12 1       0                       590
2473657 2473657 NJ Cumberland 11 school 3403610 995   Cumberland Co Vocational 340361001816 30 Cumberland County Technical Education Center   Career and Technical School No High 09 12 2020   pk_12_total 491.0 93.0 329.0 2.0   21.0 0.0       11.0             0   0.4     32.300000000000004     947.0 491 93 329 2   21 0       11                       947
2473747 2473747 NJ Essex 13 school 3404800 1390   Essex Co Voc-Tech 340480002074 50 Essex County Donald M. Payne Sr. School Of Technology   Career and Technical School No High 09 12 2020   pk_12_total 12.0 500.0 747.0 8.0   10.0 8.0       19.0             5.4   0.0     55.8     1304.0 12 500 747 8   10 8       19                       1304

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