enrollments

Data source: Big Local News · About: Big Local

2,505 rows where grade = "kindergarten_half_day", state = "NJ" and year = 2021 sorted by rowid descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 2,305 ✖

grade ✖

  • kindergarten_half_day · 2,305 ✖
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
2380226 2380226 NJ Union 39 school 3413530 4290   Rahway Public School District 341353005646 120 Roosevelt Elementary School   Regular School No Elementary PK 06 2021   kindergarten_half_day                                                   0.0                                             0
2380225 2380225 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005610 80 Dewitt D. Barlow Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380224 2380224 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005620 140 Evergreen Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380223 2380223 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005618 130 Emerson Community School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380222 2380222 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005608 70 Maxson Middle School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380221 2380221 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005606 60 Hubbard Middle School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380220 2380220 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005628 180 Washington Community School   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380219 2380219 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005626 170 Charles H. Stillman Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380218 2380218 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314003041 52 Plainfield Academy For The Arts & Advanced Studies   Regular School No High 07 12 2021   kindergarten_half_day                                                   0.0                                             0
2380217 2380217 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005622 150 Jefferson Elementary School   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380216 2380216 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005616 120 Frederic W. Cook Elementary School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380215 2380215 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005612 100 Cedarbrook Elementary School   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380214 2380214 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005614 110 Clinton Elementary School   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380213 2380213 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005604 50 Plainfield High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380212 2380212 NJ Union 39 school 3411310 3560   New Providence School District 341131005592 50 New Providence High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380211 2380211 NJ Union 39 school 3411310 3560   New Providence School District 341131005600 90 Salt Brook School   Regular School No Elementary KG 06 2021   kindergarten_half_day                                                   62.0                                             62
2380210 2380210 NJ Union 39 school 3411310 3560   New Providence School District 341131006097 80 New Providence Middle School   Regular School No Middle 07 08 2021   kindergarten_half_day                                                   0.0                                             0
2380209 2380209 NJ Union 39 school 3411310 3560   New Providence School District 341131005594 55 Allen W. Roberts School   Regular School No Elementary PK 06 2021   kindergarten_half_day                                                   70.0                                             70
2380208 2380208 NJ Union 39 school 3411040 3470   Mountainside School District 341104000527 60 Beechwood School   Regular School No Elementary PK 02 2021   kindergarten_half_day                                                   0.0                                             0
2380207 2380207 NJ Union 39 school 3411040 3470   Mountainside School District 341104005588 30 Deerfield Elementary School   Regular School No Middle 03 08 2021   kindergarten_half_day                                                   0.0                                             0
2380206 2380206 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000500817 80 Developmental Learning Center Warren   Special Education School No High 06 12 2021   kindergarten_half_day                                                   0.0                                             0
2380205 2380205 NJ Union 39 school 3400005 3395   Morris-Union Jointure Commisson School District 340000506063 50 Developmental Learning Center New Providence   Special Education School No Elementary KG 06 2021   kindergarten_half_day                                                   0.0                                             0
2380204 2380204 NJ Union 39 school 3408610 2660   Linden Public School District 340861005560 70 Joseph E. Soehl Middle School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380203 2380203 NJ Union 39 school 3408610 2660   Linden Public School District 340861005558 60 Myles J. Mcmanus Middle School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380202 2380202 NJ Union 39 school 3408610 2660   Linden Public School District 340861005580 160 Number 9   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380201 2380201 NJ Union 39 school 3408610 2660   Linden Public School District 340861005564 90 Number 2   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380200 2380200 NJ Union 39 school 3408610 2660   Linden Public School District 340861005562 80 Number 1   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380199 2380199 NJ Union 39 school 3408610 2660   Linden Public School District 340861005570 115 Number 4   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380198 2380198 NJ Union 39 school 3408610 2660   Linden Public School District 340861005582 170 Number 10   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380197 2380197 NJ Union 39 school 3408610 2660   Linden Public School District 340861005574 130 Number 6   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380196 2380196 NJ Union 39 school 3408610 2660   Linden Public School District 340861005556 50 Linden High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380195 2380195 NJ Union 39 school 3408610 2660   Linden Public School District 340861005572 120 Number 5   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380194 2380194 NJ Union 39 school 3408610 2660   Linden Public School District 340861005578 150 Number 8   Regular School No Elementary PK 05 2021   kindergarten_half_day                                                   0.0                                             0
2380193 2380193 NJ Union 39 school 3407920 2420   Kenilworth School District 340792005552 50 Warren G. Harding Elementary School   Regular School No Elementary PK 06 2021   kindergarten_half_day                                                   0.0                                             0
2380192 2380192 NJ Union 39 school 3407920 2420   Kenilworth School District 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2021   kindergarten_half_day                                                   0.0                                             0
2380191 2380191 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005540 50 Hillside High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380190 2380190 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005542 60 Deanna G. Taylor Academy   Regular School No Elementary 02 06 2021   kindergarten_half_day                                                   0.0                                             0
2380189 2380189 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005550 110 Ola Edwards Community School   Regular School No Elementary 02 06 2021   kindergarten_half_day                                                   0.0                                             0
2380188 2380188 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005548 90 A.P. Morris Early Childhood Center   Regular School No Elementary PK 01 2021   kindergarten_half_day                                                   0.0                                             0
2380187 2380187 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005544 80 Hurden Looker School   Regular School No Elementary 02 06 2021   kindergarten_half_day                                                   0.0                                             0
2380186 2380186 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005546 85 Walter O. Krumbiegel Middle School   Regular School No Middle 07 08 2021   kindergarten_half_day                                                   0.0                                             0
2380185 2380185 NJ Union 39 school 3405790 1710   Garwood Boro 340579005532 50 Lincoln   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380184 2380184 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003045 404 Thomas A. Edison Career And Technical Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380183 2380183 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459002997 310 Dr. Antonia Pantoja School No. 27   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380182 2380182 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003389 303 J. Christian Bollwage Finance Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380181 2380181 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005524 250 William F. Halloran School No.22   Regular School No Middle 02 08 2021   kindergarten_half_day                                                   0.0                                             0
2380180 2380180 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005518 220 Woodrow Wilson School No. 19   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380179 2380179 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005504 150 Elmora School No. 12   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380178 2380178 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005482 35 Joseph Battin School No 4   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380177 2380177 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003039 402 Admiral William F. Halsey Jr. Health & Public Safety Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380176 2380176 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000567 360 Dr. Martin Luther King Jr. Early Childhood Center No 52   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380175 2380175 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000467 350 Frances C. Smith Early Childhood Center No 50   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380174 2380174 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000071 300 Mabel G. Homes School No. 5   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380173 2380173 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005512 190 Madison Monroe School No. 16   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380172 2380172 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380171 2380171 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003043 405 Alexander Hamilton Preparatory Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380170 2380170 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000245 290 Dr. Orlando Edreira Academy School No. 26   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380169 2380169 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005522 240 Victor Mravlag School No. 21   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380168 2380168 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005510 180 Christopher Columbus School No. 15   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380167 2380167 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005506 160 Benjamin Franklin School No. 13   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380166 2380166 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005498 120 Toussaint Louverture-Marquis De Lafayette School No. 6   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380165 2380165 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005962 110 Nicholas S. Lacorte-Peterstown School No. 3   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380164 2380164 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005492 90 George Washington Academy School No. 1   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380163 2380163 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003071 401 John E. Dwyer Technology Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380162 2380162 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005516 210 Robert Morris School No. 18   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380161 2380161 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459006131 355 Donald Stewart Early Childhood Center No 51   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380160 2380160 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003197 301 Iprep Academy School No 8   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380159 2380159 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000013 30 Terence C. Reilly School No 7   Regular School No Middle 02 08 2021   kindergarten_half_day                                                   0.0                                             0
2380158 2380158 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003049 403 Thomas Jefferson Arts Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380157 2380157 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000825 305 Chessie Dentley Roberts Academy School No. 30   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380156 2380156 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003293 302 Jerome Dunn Academy No 9   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380155 2380155 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000207 280 Sonia Sotomayor School No 25   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380154 2380154 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005520 230 John Marshal School No. 20   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380153 2380153 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459002983 315 Juan Pablo Duarte - Jose Julian Marti School No 28   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380152 2380152 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000806 295 Dr. Albert Einstein Academy School No. 29   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380151 2380151 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005526 260 Nicholas Murray Butler Academy School No. 23   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   0.0                                             0
2380150 2380150 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005494 100 Winfield Scott School No. 2   Regular School No Elementary PK 08 2021   kindergarten_half_day                                                   0.0                                             0
2380149 2380149 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005478 25 Elizabeth High School - Frank J Cicarell Academy   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380148 2380148 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   kindergarten_half_day                                                   0.0                                             0
2380147 2380147 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   kindergarten_half_day                                                   63.0                                             63
2380146 2380146 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   kindergarten_half_day                                                   34.0                                             34
2380145 2380145 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   kindergarten_half_day                                                   69.0                                             69
2380144 2380144 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   kindergarten_half_day                                                   0.0                                             0
2380143 2380143 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   55.0                                             55
2380142 2380142 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380141 2380141 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005450 30 Frank K. Hehnly   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380140 2380140 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005452 35 Carl H. Kumpf School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380139 2380139 NJ Union 39 school 3403150 850   Clark Township Public School District 340315003295 300 Clark Preschool Annex   Special Education School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380138 2380138 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005454 40 Valley Road School   Regular School No Elementary KG 05 2021   kindergarten_half_day                                                   0.0                                             0
2380137 2380137 NJ Union 39 school 3403150 850   Clark Township Public School District 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380136 2380136 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380135 2380135 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005440 40 Mountain Park School   Regular School No Elementary 02 05 2021   kindergarten_half_day                                                   0.0                                             0
2380134 2380134 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2021   kindergarten_half_day                                                   85.0                                             85
2380133 2380133 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005442 50 William Woodruff School   Regular School No Elementary 02 05 2021   kindergarten_half_day                                                   0.0                                             0
2380132 2380132 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2021   kindergarten_half_day                                                   0.0                                             0
2380131 2380131 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005436 30 Columbia Middle School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380130 2380130 NJ Sussex 37 school 3416870 5435   Wallkill Valley Regional High School 341687005949 60 Wallkill Valley Regional High School   Regular School No High 09 12 2021   kindergarten_half_day                                                   0.0                                             0
2380129 2380129 NJ Sussex 37 school 3416710 5360   Vernon Township School District 341671005948 25 Glen Meadow Middle School   Regular School No Middle 06 08 2021   kindergarten_half_day                                                   0.0                                             0
2380128 2380128 NJ Sussex 37 school 3416710 5360   Vernon Township School District 341671006009 23 Cedar Mountain Primary School   Regular School No Elementary PK 01 2021   kindergarten_half_day                                                   0.0                                             0
2380127 2380127 NJ Sussex 37 school 3416710 5360   Vernon Township School District 341671005426 40 Rolling Hills Primary School   Regular School No Elementary 02 03 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]);