enrollments

Data source: Big Local News · About: Big Local

5,007 rows where grade = "pre_kindergarten_full_day" and state = "NJ" sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten_full_day · 4,931 ✖
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
2372616 2372616 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005436 30 Columbia Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372617 2372617 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372618 2372618 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005442 50 William Woodruff School   Regular School No Elementary 02 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372619 2372619 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   pre_kindergarten_full_day                                                   45.0                                             45
2372620 2372620 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005440 40 Mountain Park School   Regular School No Elementary 02 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372621 2372621 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372622 2372622 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   pre_kindergarten_full_day                                                   0.0                                             0
2372623 2372623 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005454 40 Valley Road School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372624 2372624 NJ Union 39 school 3403150 850   Clark Township Public School District 340315003295 300 Clark Preschool Annex   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   14.0                                             14
2372625 2372625 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005452 35 Carl H. Kumpf School   Regular School No Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372626 2372626 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005450 30 Frank K. Hehnly   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372627 2372627 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372628 2372628 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372629 2372629 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372630 2372630 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   pre_kindergarten_full_day                                                   40.0                                             40
2372631 2372631 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372632 2372632 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372633 2372633 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372634 2372634 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   pre_kindergarten_full_day                                                   0.0                                             0
2372635 2372635 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005494 100 Winfield Scott School No. 2   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372636 2372636 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   pre_kindergarten_full_day                                                   0.0                                             0
2372637 2372637 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   pre_kindergarten_full_day                                                   0.0                                             0
2372638 2372638 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   pre_kindergarten_full_day                                                   0.0                                             0
2372639 2372639 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005520 230 John Marshal School No. 20   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372640 2372640 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000207 280 Sonia Sotomayor School No 25   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372641 2372641 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003293 302 Jerome Dunn Academy No 9   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372642 2372642 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   pre_kindergarten_full_day                                                   0.0                                             0
2372643 2372643 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003049 403 Thomas Jefferson Arts Academy   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372644 2372644 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000013 30 Terence C. Reilly School No 7   Regular School No Middle 02 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372645 2372645 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003197 301 Iprep Academy School No 8   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372646 2372646 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   pre_kindergarten_full_day                                                   0.0                                             0
2372647 2372647 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005516 210 Robert Morris School No. 18   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372648 2372648 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003071 401 John E. Dwyer Technology Academy   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372649 2372649 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005492 90 George Washington Academy School No. 1   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372650 2372650 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   pre_kindergarten_full_day                                                   0.0                                             0
2372651 2372651 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   pre_kindergarten_full_day                                                   0.0                                             0
2372652 2372652 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005506 160 Benjamin Franklin School No. 13   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372653 2372653 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005510 180 Christopher Columbus School No. 15   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372654 2372654 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005522 240 Victor Mravlag School No. 21   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372655 2372655 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   pre_kindergarten_full_day                                                   0.0                                             0
2372656 2372656 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003043 405 Alexander Hamilton Preparatory Academy   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372657 2372657 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005508 170 Abraham Lincoln School No. 14   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372658 2372658 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005512 190 Madison Monroe School No. 16   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372659 2372659 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000071 300 Mabel G. Homes School No. 5   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372660 2372660 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   pre_kindergarten_full_day                                                   0.0                                             0
2372661 2372661 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   pre_kindergarten_full_day                                                   0.0                                             0
2372662 2372662 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   pre_kindergarten_full_day                                                   0.0                                             0
2372663 2372663 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005482 35 Joseph Battin School No 4   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372664 2372664 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005504 150 Elmora School No. 12   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372665 2372665 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005518 220 Woodrow Wilson School No. 19   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372666 2372666 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005524 250 William F. Halloran School No.22   Regular School No Middle 02 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372667 2372667 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459003389 303 J. Christian Bollwage Finance Academy   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372668 2372668 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459002997 310 Dr. Antonia Pantoja School No. 27   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372669 2372669 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   pre_kindergarten_full_day                                                   0.0                                             0
2372670 2372670 NJ Union 39 school 3405790 1710   Garwood Boro 340579005532 50 Lincoln   Regular School No Elementary PK 08 2021   pre_kindergarten_full_day                                                   2.0                                             2
2372671 2372671 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005546 85 Walter O. Krumbiegel Middle School   Regular School No Middle 07 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372672 2372672 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005544 80 Hurden Looker School   Regular School No Elementary 02 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372673 2372673 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   pre_kindergarten_full_day                                                   0.0                                             0
2372674 2372674 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005550 110 Ola Edwards Community School   Regular School No Elementary 02 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372675 2372675 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005542 60 Deanna G. Taylor Academy   Regular School No Elementary 02 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372676 2372676 NJ Union 39 school 3407290 2190   Hillside Public School District 340729005540 50 Hillside High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372677 2372677 NJ Union 39 school 3407920 2420   Kenilworth School District 340792000209 10 David Brearley Middle/High School   Regular School No High 07 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372678 2372678 NJ Union 39 school 3407920 2420   Kenilworth School District 340792005552 50 Warren G. Harding Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten_full_day                                                   38.0                                             38
2372679 2372679 NJ Union 39 school 3408610 2660   Linden Public School District 340861005578 150 Number 8   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372680 2372680 NJ Union 39 school 3408610 2660   Linden Public School District 340861005572 120 Number 5   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372681 2372681 NJ Union 39 school 3408610 2660   Linden Public School District 340861005556 50 Linden High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372682 2372682 NJ Union 39 school 3408610 2660   Linden Public School District 340861005574 130 Number 6   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372683 2372683 NJ Union 39 school 3408610 2660   Linden Public School District 340861005582 170 Number 10   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372684 2372684 NJ Union 39 school 3408610 2660   Linden Public School District 340861005570 115 Number 4   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372685 2372685 NJ Union 39 school 3408610 2660   Linden Public School District 340861005562 80 Number 1   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372686 2372686 NJ Union 39 school 3408610 2660   Linden Public School District 340861005564 90 Number 2   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372687 2372687 NJ Union 39 school 3408610 2660   Linden Public School District 340861005580 160 Number 9   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372688 2372688 NJ Union 39 school 3408610 2660   Linden Public School District 340861005558 60 Myles J. Mcmanus Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372689 2372689 NJ Union 39 school 3408610 2660   Linden Public School District 340861005560 70 Joseph E. Soehl Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372690 2372690 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   pre_kindergarten_full_day                                                   0.0                                             0
2372691 2372691 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   pre_kindergarten_full_day                                                   0.0                                             0
2372692 2372692 NJ Union 39 school 3411040 3470   Mountainside School District 341104005588 30 Deerfield Elementary School   Regular School No Middle 03 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372693 2372693 NJ Union 39 school 3411040 3470   Mountainside School District 341104000527 60 Beechwood School   Regular School No Elementary PK 02 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372694 2372694 NJ Union 39 school 3411310 3560   New Providence School District 341131005594 55 Allen W. Roberts School   Regular School No Elementary PK 06 2021   pre_kindergarten_full_day                                                   24.0                                             24
2372695 2372695 NJ Union 39 school 3411310 3560   New Providence School District 341131006097 80 New Providence Middle School   Regular School No Middle 07 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372696 2372696 NJ Union 39 school 3411310 3560   New Providence School District 341131005600 90 Salt Brook School   Regular School No Elementary KG 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372697 2372697 NJ Union 39 school 3411310 3560   New Providence School District 341131005592 50 New Providence High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372698 2372698 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005604 50 Plainfield High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372699 2372699 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005614 110 Clinton Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372700 2372700 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005612 100 Cedarbrook Elementary School   Regular School No Elementary KG 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372701 2372701 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005616 120 Frederic W. Cook Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372702 2372702 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005622 150 Jefferson Elementary School   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372703 2372703 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   pre_kindergarten_full_day                                                   0.0                                             0
2372704 2372704 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005626 170 Charles H. Stillman Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372705 2372705 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005628 180 Washington Community School   Regular School No Elementary PK 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372706 2372706 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005606 60 Hubbard Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372707 2372707 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005608 70 Maxson Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372708 2372708 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005618 130 Emerson Community School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372709 2372709 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005620 140 Evergreen Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372710 2372710 NJ Union 39 school 3413140 4160   Plainfield Public School District 341314005610 80 Dewitt D. Barlow Elementary School   Regular School No Elementary KG 05 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372711 2372711 NJ Union 39 school 3413530 4290   Rahway Public School District 341353005646 120 Roosevelt Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372712 2372712 NJ Union 39 school 3413530 4290   Rahway Public School District 341353005642 90 Grover Cleveland Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372713 2372713 NJ Union 39 school 3413530 4290   Rahway Public School District 341353005634 50 Rahway High School   Regular School No High 09 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372714 2372714 NJ Union 39 school 3413530 4290   Rahway Public School District 341353005640 80 Franklin Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372715 2372715 NJ Union 39 school 3413530 4290   Rahway Public School District 341353005636 60 Rahway 7th & 8th Grade Academy   Regular School No Middle 07 08 2021   pre_kindergarten_full_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]);