Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 2,505

grade

  • pre_kindergarten_full_day · 2,505
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
2371291 NJ Essex 13 school 3412270 3880   Orange Board Of Education School District 341227002410 115 Orange Preparatory Academy   Regular School No Secondary 08 09 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371660 NJ Mercer 21 school 3416290 5210   Trenton Public Schools 341629003449 302 Trenton Central High School-9th Grade Academy   Regular School No Secondary 09 09 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371693 NJ Middlesex 23 school 3404110 1170   East Brunswick Township School District 340411003296 55 Churchill Jr High School   Regular School No Secondary 08 09 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370412 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370441 NJ Atlantic 1 school 3405730 1690   Galloway Township Public School District 340573000114 40 Pomona Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370474 NJ Atlantic 1 school 3415030 4800   Somers Point School District 341503000533 60 New York Avenue Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370564 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370569 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370571 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576003431 302 Garfield Public Preschool 3 At Headstart   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370616 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921003471 301 Community   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   31.0                                             31
2370687 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000221 80 Glen School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370713 NJ Bergen 3 school 3414490 4610   Saddle Brook School District 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   12.0                                             12
2370725 NJ Bergen 3 school 3416080 5150   Teaneck School District 341608000846 80 William Cullen Bryant School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370857 NJ Burlington 5 school 3412810 4050   Pemberton Township School District 341281003167 300 Pemberton Early Childhood Education Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370908 NJ Camden 7 school 3402640 680   Camden City School District 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370942 NJ Camden 7 school 3403420 940   Collingswood Public School District 340342003485 300 Collingswood Pre School At Oaklyn   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370945 NJ Camden 7 school 3403420 940   Collingswood Public School District 340342003497 301 Collingswood Pre Sch Penguins Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370990 NJ Camden 7 school 3408640 2670   Lindenwold Public School District 340864003271 300 Lindenwold Preschool Building   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370998 NJ Camden 7 school 3412870 4060   Pennsauken Township Board Of Education School District 341287001622 90 Baldwin Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371070 NJ Cumberland 11 school 3402250 540   Bridgeton City School District 340225000581 150 Geraldine O Foster Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371085 NJ Cumberland 11 school 3410320 3230   Millville School District 341032001874 68 Child Family Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371105 NJ Cumberland 11 school 3416800 5390   Vineland Public School District 341680000225 176 Casimer M. Dallago Jr. Impact Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371116 NJ Essex 13 school 3401350 250   Belleville Public School District 340135003501 301 Sandy Lane Nursery School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371118 NJ Essex 13 school 3401350 250   Belleville Public School District 340135003499 300 Hornblower Early Edudcation Elementary Sch   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371123 NJ Essex 13 school 3401830 410   Bloomfield Township School District 340183000133 120 The Early Childhood Center @ Forest Glen   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   31.0                                             31
2371187 NJ Essex 13 school 3407680 2330   Irvington Public School District 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371223 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003153 306 Early Childhood School - South   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371234 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003193 308 Early Childhood School - West   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371235 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003281 314 Early Childhood School - Central   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371259 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003327 316 Early Childhood School - North   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371295 NJ Essex 13 school 3412270 3880   Orange Board Of Education School District 341227003148 300 Orange Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371308 NJ Essex 13 school 3415330 4900   South Orange-Maplewood School District 341533003339 300 Montrose Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371329 NJ Essex 13 school 3417610 5680   West Orange Public Schools 341761003416 300 Betty Maddalena Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   3.0                                             3
2371523 NJ Hudson 17 school 3417580 5670   West New York School District 341758000445 55 Early Childhood School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371784 NJ Middlesex 23 school 3412930 4090   Perth Amboy Public School District 341293000551 75 Ignacio Cruz Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371790 NJ Middlesex 23 school 3412930 4090   Perth Amboy Public School District 341293002998 80 Edmund Hmieleski Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371810 NJ Middlesex 23 school 3414640 4660   Sayreville School District 341464003513 301 Project Before At Cheesequake School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371901 NJ Monmouth 25 school 3405640 1660   Freehold Township School District 340564006120 70 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371929 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003882 40 Port Monmouth Road School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371962 NJ Monmouth 25 school 3409750 3040   Matawan-Aberdeen Regional School District 340975000723 40 Cambridge Park Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372008 NJ Monmouth 25 school 3411160 3510   Neptune Township School District 341116000457 59 Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372038 NJ Monmouth 25 school 3416890 5420   Wall Township Public School District 341689000099 78 Wall Primary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   33.0                                             33
2372068 NJ Morris 27 school 3403930 1110   Dover Public School District 340393003478 300 Votech   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372126 NJ Morris 27 school 3410810 3385   Morris School District 341081004376 85 Lafayette Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372202 NJ Ocean 29 school 3416470 185   Barnegat Township School District 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372211 NJ Ocean 29 school 3402220 530   Brick Township Public School District 340222000166 27 Warren H. Wolf Early Childhood Development Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372213 NJ Ocean 29 school 3402220 530   Brick Township Public School District 340222004588 40 Herbertsville Early Childhood Development Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372253 NJ Ocean 29 school 3408700 2690   Little Egg Harbor Township School District 340870003199 300 Robert C. Wood Sr Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372288 NJ Ocean 29 school 3415690 5020   Stafford Township School District 341569004716 50 Oxycocus Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372319 NJ Passaic 31 school 3403300 900   Clifton Public School District 340330003436 301 Clifton Early Learner Academies   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372359 NJ Passaic 31 school 3412540 3970   Passaic City School District 341254000403 180 School No.16   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372374 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372431 NJ Passaic 31 school 3417280 5570   Wayne Township Public School District 341728003515 300 Preakness Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   125.0                                             125
2372454 NJ Passaic 31 school 3417640 5690   Woodland Park School District 341764003517 300 School One   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372475 NJ Salem 33 school 3413110 4150   Pittsgrove Township School District 341311005082 50 Norma Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   0.0                                             0
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
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
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 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
2372721 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428003147 120 Roselle Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_full_day                                                   32.0                                             32
2370481 NJ Bergen 3 school 3401450 285   Bergen County Special Services School District 340145000240 70 Life Skills   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370482 NJ Bergen 3 school 3401450 285   Bergen County Special Services School District 340145006020 40 Multiply Handicapped   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370483 NJ Bergen 3 school 3401450 285   Bergen County Special Services School District 340145000234 30 Hearing Impaired   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   3.0                                             3
2370484 NJ Bergen 3 school 3401450 285   Bergen County Special Services School District 340145000238 50 Emotionally Disturbed   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370485 NJ Bergen 3 school 3401450 285   Bergen County Special Services School District 340145000073 100 Autistic   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370486 NJ Bergen 3 school 3401450 285   Bergen County Special Services School District 340145005978 2 N. A. Bleshman Regional Day School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370680 NJ Bergen 3 school 3413770 4370   Ridgefield School District 341377000750 100 Slocum Skewes School   Regular School No Other 02 09 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370770 NJ Burlington 5 school 3402440 605   Burlington County Special Services School District 340244000982 30 Westampton Campus   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370967 NJ Camden 7 school 3400777 1799   Kipp: Cooper Norcross A New Jersey Nonprofit Corporation 340077703307 111 Kipp: Cooper Norcross A New Jersey Nonprofit Corporation   Regular School No Other KG 09 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370969 NJ Camden 7 school 3400772 1802   Mastery Schools Of Camden Inc. 340077203313 112 Mastery Schools Of Camden Inc.   Regular School No Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371220 NJ Essex 13 school 3411340 3570   Newark Public School District 341134002296 477 John F. Kennedy School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371221 NJ Essex 13 school 3411340 3570   Newark Public School District 341134005985 4 Nj Regional Day School - Newark   Special Education School No Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371357 NJ Gloucester 15 school 3480363 1774   Gloucester County Special Services School District 348036300413 15 Bankbridge Regional School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371482 NJ Hudson 17 school 3407830 2390   Jersey City Public Schools 340783005980 11 Regional Day School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371728 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018005951 30 Academy Learning Center   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371731 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018005991 6 Piscataway Regional Day School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371732 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018002926 31 Center For Lifelong Learning   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371733 NJ Middlesex 23 school 3480180 3145   Educational Services Commission Of New Jersey 348018000799 90 Nuview Academy   Special Education School No Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371870 NJ Monmouth 25 school 3400069 225   Bayshore Jointure Commission School District 340006900719 30 Developmental Learning Center   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372113 NJ Morris 27 school 3480260 3364   Educational Services Commission Of Morris County 348026000519 85 Central Park School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372258 NJ Ocean 29 school 3409450 2940   Manchester Township School District 340945005983 8 Manchester Regional Day School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372376 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269004894 150 Newcomers   Regular School No Other 03 10 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372481 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036106102 50 Daretown School   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372482 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103297 9 Salem Campus   Special Education School No Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372483 NJ Salem 33 school 3480361 4635   Salem County Special Services School District 348036103161 300 Cumberland Campus   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372608 NJ Sussex 37 school 3480320 5105   Northern Hills Academy School District 348032005960 50 Northern Hills Academy   Special Education School No Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372754 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640005726 30 Westlake   Special Education School No Other 04 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372826 NJ Charters 80 school 3400715 6013   Bergen Arts And Science Charter School 340071502923 900 Bergen Arts And Sciences Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372827 NJ Charters 80 school 3400717 6017   Foundation Academy Charter School 340071702925 932 Foundation Academy Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372828 NJ Charters 80 school 3400090 6018   Central Jersey College Prep Charter School 340009000829 900 Central Jersey College Prep Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372834 NJ Charters 80 school 3400729 6028   Vineland Public Charter School 340072903027 910 Vineland Public Charter School   Regular School Yes Other PK 11 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372841 NJ Charters 80 school 3400751 6053   Great Oaks Legacy Charter School 340075103180 917 Great Oaks Legacy Charter School   Regular School Yes Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372846 NJ Charters 80 school 3400749 6069   Millville Public Charter School 340074903184 952 Millville Public Charter School   Regular School Yes Other KG 10 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372849 NJ Charters 80 school 3400745 6080   Passaic Arts And Science Charter School 340074503137 966 Passaic Arts And Science Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372850 NJ Charters 80 school 3400746 6081   Thomas Edison Energysmart Charter School 340074603143 967 Thomas Edison Energysmart Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372851 NJ Charters 80 school 3400759 6082   Beloved Community Charter School 340075903196 963 Beloved Community Charter School   Regular School Yes Other KG 10 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372856 NJ Charters 80 school 3400765 6096   Paterson Arts And Science Charter School 340076503254 982 Paterson Arts And Science Charter School   Regular School Yes Other KG 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372859 NJ Charters 80 school 3400779 6101   College Achieve Central Charter School 340077903353 992 College Achieve Central Charter School   Regular School Yes Other KG 11 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372865 NJ Charters 80 school 3400785 6107   Camden'S Promise Charter School 340078503390 998 Camden'S Promise Charter School   Regular School Yes Other PK 12 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372871 NJ Charters 80 school 3400080 6240   Freedom Prep Charter School 340008000566 900 Freedom Prep Charter School   Regular School Yes Other KG 12 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]);