Data source: Big Local News · About: Big Local

5,007 rows where grade = "kindergarten_half_day" and state = "NJ" sorted by ccd_school_type

View and edit SQL

year

grade

  • kindergarten_half_day · 5,007
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
2378286 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   kindergarten_half_day                                                   0.0                                             0
2378394 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003421 300 Willingboro Alternative School   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378434 NJ Camden 7 school 3402640 680   Camden City School District 340264003441 303 Pride Academy   Alternative School No High 06 12 2021   kindergarten_half_day                                                   0.0                                             0
2378515 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   kindergarten_half_day                                                   0.0                                             0
2378680 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000135 30 Essex High School   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378681 NJ Essex 13 school 3480300 1387   Essex Regional Educational Services Commission 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378744 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003117 2 Uplift Academy   Alternative School No High 10 12 2021   kindergarten_half_day                                                   0.0                                             0
2379504 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   kindergarten_half_day                                                   0.0                                             0
2379505 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   kindergarten_half_day                                                   0.0                                             0
2379876 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379918 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003111 6 Alternative High School   Alternative School No High 06 12 2021   kindergarten_half_day                                                   0.0                                             0
2379999 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2021   kindergarten_half_day                                                   0.0                                             0
2380267 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380268 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380275 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380278 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   kindergarten_half_day                                                   0.0                                             0
2483010 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483358 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2483472 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2483505 NJ Camden 7 school 3402640 680   Camden City 340264003441 303 Pride Academy   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2483595 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287003465 300 A.E. Burling High School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2483752 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000543 20 Essex Campus Academy   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483753 NJ Essex 13 school 3480300 1387   Essex Co Ed Serv Comm 348030000135 30 Essex High School   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2484574 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024006080 50 Regional Alternative School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2484575 NJ Monmouth 25 school 3480240 3255   Monmouth-Ocean Ed Ser Com 348024002989 90 New Jersey Virtual School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2484946 NJ Passaic 31 school 3480364 3975   Northern Region Educational Services Commission 348036402991 100 Hope Academy   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2484956 NJ Passaic 31 school 3412690 4010   Paterson City 341269003111 6 Alternative High School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2485068 NJ Salem 33 school 3480361 4635   Salem Co Special Service 348036103163 301 Alternative Middle & High School   Alternative School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2485338 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006008 20 Hillcrest Academy-North   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485339 NJ Union 39 school 3416400 5245   Union Co Ed Serv Comm 341640006127 25 Hillcrest Academy-South   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2485348 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   kindergarten_half_day                                                   0.0                                             0
2485350 NJ Union 39 school 3418040 5260   Union County Vocational 341804003397 302 Simon Youth Academy   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2377935 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   kindergarten_half_day                                                   0.0                                             0
2378003 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   kindergarten_half_day                                                   0.0                                             0
2378004 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   kindergarten_half_day                                                   0.0                                             0
2378005 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   kindergarten_half_day                                                   0.0                                             0
2378006 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   kindergarten_half_day                                                   0.0                                             0
2378287 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   kindergarten_half_day                                                   0.0                                             0
2378288 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   kindergarten_half_day                                                   0.0                                             0
2378435 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   kindergarten_half_day                                                   0.0                                             0
2378436 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   kindergarten_half_day                                                   0.0                                             0
2378554 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   kindergarten_half_day                                                   0.0                                             0
2378590 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   kindergarten_half_day                                                   0.0                                             0
2378682 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   kindergarten_half_day                                                   0.0                                             0
2378683 NJ Essex 13 school 3404800 1390   Essex County Schools Of Technology 340480002080 80 Essex County West Caldwell Tech   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378684 NJ Essex 13 school 3404800 1390   Essex County Schools Of Technology 340480000137 70 Essex County Newark Tech   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378873 NJ Gloucester 15 school 3406040 1775   Gloucester County Vocational-Technical School District 340604002570 10 Gloucester County Institute Of Technology   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378957 NJ Hudson 17 school 3407570 2295   Hudson County Schools Of Technology School District 340757002766 50 High Tech High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378958 NJ Hudson 17 school 3407570 2295   Hudson County Schools Of Technology School District 340757003198 304 Academy Of Technology Design   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378959 NJ Hudson 17 school 3407570 2295   Hudson County Schools Of Technology School District 340757003468 300 Academy Of Career And Technical Education   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378960 NJ Hudson 17 school 3407570 2295   Hudson County Schools Of Technology School District 340757005906 30 County Prep High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378961 NJ Hudson 17 school 3407570 2295   Hudson County Schools Of Technology School District 340757003233 305 Bayonne Academy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2378962 NJ Hudson 17 school 3407570 2295   Hudson County Schools Of Technology School District 340757000189 90 Explore Middle School   Career and Technical School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2379076 NJ Hunterdon 19 school 3400050 2308   Hunterdon County Vocational School District 340005000021 50 Hunterdon County Vocational School District Central Campus   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379077 NJ Hunterdon 19 school 3400050 2308   Hunterdon County Vocational School District 340005003405 300 Hunterdon County Academies   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379078 NJ Hunterdon 19 school 3400050 2308   Hunterdon County Vocational School District 340005000716 30 Hunterdon Polytech Bartles Corner Campus   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379146 NJ Mercer 21 school 3409950 3105   Area Vocational Technical Schools Of Mercer County 340995003410 300 Mercer County Technical School Culinary Arts Academy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379147 NJ Mercer 21 school 3409950 3105   Area Vocational Technical Schools Of Mercer County 340995003415 302 Mercer County Technical School Stem Academy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379148 NJ Mercer 21 school 3409950 3105   Area Vocational Technical Schools Of Mercer County 340995003174 30 Mcvs Assunpink Center   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379149 NJ Mercer 21 school 3409950 3105   Area Vocational Technical Schools Of Mercer County 340995003178 40 Mcvs Arthur R. Sypek Center   Career and Technical School No High 10 12 2021   kindergarten_half_day                                                   0.0                                             0
2379150 NJ Mercer 21 school 3409950 3105   Area Vocational Technical Schools Of Mercer County 340995003409 304 Mercer County Technical School Health Sciences Academy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379249 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008003420 40 Middlesex County Vocational School East Brunswick   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379250 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008003426 65 Middlesex County Vocational School Piscataway   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379251 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008000395 10 Middlesex County Voc Academy Math Science &Engineering Techn   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379252 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008003176 301 Middlesex Co Voc School East Bruns. School Of Career Develop   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379253 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008003428 70 Middlesex County Voc Acad Allied Health & Biomedical Science   Career and Technical School No High 08 12 2021   kindergarten_half_day                                                   0.0                                             0
2379254 NJ Middlesex 23 school 3410080 3150   Middlesex County Vocational And Technical School District 341008003424 60 Middlesex County Vocational School Perth Amboy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379506 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750006121 28 Biotechnology High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379507 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750000163 25 Monmouth County Academy Of Allied Health And Science   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379508 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750004024 50 Monmouth County Vocational Technical High School   Career and Technical School No High 11 12 2021   kindergarten_half_day                                                   0.0                                             0
2379509 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750005990 40 Monmouth County Career Center   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379510 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750000161 3 Class Academy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379511 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750003219 301 Academy Of Law & Public Safety   Career and Technical School No High 11 12 2021   kindergarten_half_day                                                   0.0                                             0
2379512 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750000409 4 Communications High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379513 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750006095 10 High Technology High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379514 NJ Monmouth 25 school 3417500 3260   Monmouth County Vocational School District 341750005989 20 Marine Academy Of Science And Technology   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379629 NJ Morris 27 school 3410720 3365   Morris County Vocational School District 341072000522 20 Academy For Mathematics Science And Engineering   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379630 NJ Morris 27 school 3410720 3365   Morris County Vocational School District 341072003474 303 Athletic Training And Physical Therapy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379631 NJ Morris 27 school 3410720 3365   Morris County Vocational School District 341072004348 50 Morris County School Of Technology   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379632 NJ Morris 27 school 3410720 3365   Morris County Vocational School District 341072003439 302 Academy For Performing Arts   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379633 NJ Morris 27 school 3410720 3365   Morris County Vocational School District 341072003418 301 Academy For Biotechnology   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379634 NJ Morris 27 school 3410720 3365   Morris County Vocational School District 341072003375 300 Academy For Environmental Science   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379779 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198004672 20 Ocean County Vocational Technical School Jackson Center   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379780 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198004674 30 Ocean County Vocational Technical School Toms River Center   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379781 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198004670 10 Ocean County Vocational Technical School Brick Center   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379782 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198006122 55 Performing Arts Academy Of The Ocean County Vocational Tech   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379783 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198004676 40 Ocean County Vocational Technical School Waretown Center   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379784 NJ Ocean 29 school 3411980 3790   Ocean County Vocational Technical School District 341198000559 45 Marine Academy Of Technology And Environmental Science   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379880 NJ Passaic 31 school 3412630 3995   Passaic County Vocational School District 341263004860 50 Passaic County Technical Institute   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2379881 NJ Passaic 31 school 3412630 3995   Passaic County Vocational School District 341263003477 300 Diana C. Lobosco Stem Academy   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380000 NJ Salem 33 school 3414580 4640   Salem County Vocational Technical School District 341458005098 40 Salem County Career And Technical High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380071 NJ Somerset 35 school 3415060 4810   Somerset County Vocational And Technical School District 341506005278 70 Somerset County Vocational Technical High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380124 NJ Sussex 37 school 3415930 5110   Sussex County Technical School District 341593005416 10 Sussex County Technical School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380273 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003391 301 Union County Career & Technical Institute   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380274 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804000214 40 Union County Magnet High School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380276 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804003009 35 Academy For Performing Arts   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380277 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804000584 20 Academy For Allied Health Sciences   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380279 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804005738 50 Union County Tech   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380280 NJ Union 39 school 3418040 5260   Union County Vocational-Technical School District 341804006134 30 Academy For Information Technology   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380332 NJ Warren 41 school 3417920 5460   Warren County Vocational Technical School 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);