Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2021 · 2,505

grade

  • pre_kindergarten_half_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
2373796 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_half_day                                                   0.0                                             0
2374165 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_half_day                                                   0.0                                             0
2374198 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_half_day                                                   0.0                                             0
2372917 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   14.0                                             14
2372946 NJ Atlantic 1 school 3405730 1690   Galloway Township Public School District 340573000114 40 Pomona Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   60.0                                             60
2372979 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_half_day                                                   52.0                                             52
2373069 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_half_day                                                   139.0                                             139
2373074 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_half_day                                                   95.0                                             95
2373076 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_half_day                                                   159.0                                             159
2373121 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921003471 301 Community   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   0.0                                             0
2373192 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000221 80 Glen School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   42.0                                             42
2373218 NJ Bergen 3 school 3414490 4610   Saddle Brook School District 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   3.0                                             3
2373230 NJ Bergen 3 school 3416080 5150   Teaneck School District 341608000846 80 William Cullen Bryant School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   188.0                                             188
2373362 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_half_day                                                   309.0                                             309
2373413 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_half_day                                                   154.0                                             154
2373447 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_half_day                                                   31.0                                             31
2373450 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_half_day                                                   42.0                                             42
2373495 NJ Camden 7 school 3408640 2670   Lindenwold Public School District 340864003271 300 Lindenwold Preschool Building   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   144.0                                             144
2373503 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_half_day                                                   138.0                                             138
2373575 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_half_day                                                   302.0                                             302
2373590 NJ Cumberland 11 school 3410320 3230   Millville School District 341032001874 68 Child Family Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   438.0                                             438
2373610 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_half_day                                                   214.0                                             214
2373621 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_half_day                                                   25.0                                             25
2373623 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_half_day                                                   60.0                                             60
2373628 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_half_day                                                   52.0                                             52
2373692 NJ Essex 13 school 3407680 2330   Irvington Public School District 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   295.0                                             295
2373728 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_half_day                                                   178.0                                             178
2373739 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_half_day                                                   57.0                                             57
2373740 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_half_day                                                   142.0                                             142
2373764 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_half_day                                                   123.0                                             123
2373800 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_half_day                                                   180.0                                             180
2373813 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_half_day                                                   105.0                                             105
2373834 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_half_day                                                   0.0                                             0
2374028 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_half_day                                                   383.0                                             383
2374289 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_half_day                                                   650.0                                             650
2374295 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_half_day                                                   349.0                                             349
2374315 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_half_day                                                   145.0                                             145
2374406 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_half_day                                                   64.0                                             64
2374434 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003882 40 Port Monmouth Road School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   132.0                                             132
2374467 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_half_day                                                   15.0                                             15
2374513 NJ Monmouth 25 school 3411160 3510   Neptune Township School District 341116000457 59 Early Childhood Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   115.0                                             115
2374543 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_half_day                                                   3.0                                             3
2374573 NJ Morris 27 school 3403930 1110   Dover Public School District 340393003478 300 Votech   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   12.0                                             12
2374631 NJ Morris 27 school 3410810 3385   Morris School District 341081004376 85 Lafayette Learning Center   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   75.0                                             75
2374707 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_half_day                                                   268.0                                             268
2374716 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_half_day                                                   267.0                                             267
2374718 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_half_day                                                   113.0                                             113
2374758 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_half_day                                                   240.0                                             240
2374793 NJ Ocean 29 school 3415690 5020   Stafford Township School District 341569004716 50 Oxycocus Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   48.0                                             48
2374824 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_half_day                                                   225.0                                             225
2374864 NJ Passaic 31 school 3412540 3970   Passaic City School District 341254000403 180 School No.16   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   283.0                                             283
2374879 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_half_day                                                   77.0                                             77
2374936 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_half_day                                                   0.0                                             0
2374959 NJ Passaic 31 school 3417640 5690   Woodland Park School District 341764003517 300 School One   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   99.0                                             99
2374980 NJ Salem 33 school 3413110 4150   Pittsgrove Township School District 341311005082 50 Norma Elementary School   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   104.0                                             104
2375129 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_half_day                                                   8.0                                             8
2375151 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_half_day                                                   269.0                                             269
2375165 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_half_day                                                   271.0                                             271
2375166 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_half_day                                                   287.0                                             287
2375226 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428003147 120 Roselle Preschool   Regular School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   43.0                                             43
2372986 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_half_day                                                   0.0                                             0
2372987 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_half_day                                                   0.0                                             0
2372988 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_half_day                                                   9.0                                             9
2372989 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_half_day                                                   0.0                                             0
2372990 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_half_day                                                   0.0                                             0
2372991 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_half_day                                                   1.0                                             1
2373185 NJ Bergen 3 school 3413770 4370   Ridgefield School District 341377000750 100 Slocum Skewes School   Regular School No Other 02 09 2021   pre_kindergarten_half_day                                                   0.0                                             0
2373275 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_half_day                                                   4.0                                             4
2373472 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_half_day                                                   0.0                                             0
2373474 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_half_day                                                   0.0                                             0
2373725 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_half_day                                                   0.0                                             0
2373726 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_half_day                                                   0.0                                             0
2373862 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_half_day                                                   2.0                                             2
2373987 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_half_day                                                   0.0                                             0
2374233 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_half_day                                                   1.0                                             1
2374236 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_half_day                                                   0.0                                             0
2374237 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_half_day                                                   0.0                                             0
2374238 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_half_day                                                   0.0                                             0
2374375 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_half_day                                                   0.0                                             0
2374618 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_half_day                                                   0.0                                             0
2374763 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_half_day                                                   0.0                                             0
2374881 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269004894 150 Newcomers   Regular School No Other 03 10 2021   pre_kindergarten_half_day                                                   0.0                                             0
2374986 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_half_day                                                   0.0                                             0
2374987 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_half_day                                                   0.0                                             0
2374988 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_half_day                                                   0.0                                             0
2375113 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_half_day                                                   0.0                                             0
2375259 NJ Union 39 school 3416400 5245   Union County Educational Services Commission 341640005726 30 Westlake   Special Education School No Other 04 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375331 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_half_day                                                   0.0                                             0
2375332 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_half_day                                                   0.0                                             0
2375333 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_half_day                                                   0.0                                             0
2375339 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_half_day                                                   32.0                                             32
2375346 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_half_day                                                   50.0                                             50
2375351 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_half_day                                                   0.0                                             0
2375354 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_half_day                                                   0.0                                             0
2375355 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_half_day                                                   0.0                                             0
2375356 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_half_day                                                   0.0                                             0
2375361 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_half_day                                                   0.0                                             0
2375364 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_half_day                                                   0.0                                             0
2375370 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_half_day                                                   61.0                                             61
2375376 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_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]);