enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • kindergarten_half_day · 5,007 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ▲ ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2378806 2378806 NJ Essex 13 school 3412270 3880   Orange Board Of Education School District 341227002410 115 Orange Preparatory Academy   Regular School No Secondary 08 09 2021   kindergarten_half_day                                                   0.0                                             0
2379175 2379175 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   kindergarten_half_day                                                   0.0                                             0
2379208 2379208 NJ Middlesex 23 school 3404110 1170   East Brunswick Township School District 340411003296 55 Churchill Jr High School   Regular School No Secondary 08 09 2021   kindergarten_half_day                                                   0.0                                             0
2483882 2483882 NJ Essex 13 school 3412270 3880   City Of Orange Twp 341227002410 115 Orange Preparatory Academy   Regular School No Secondary 08 09 2020   kindergarten_half_day                                                   0.0                                             0
2484242 2484242 NJ Mercer 21 school 3416290 5210   Trenton Public School District 341629003449 302 Trenton Central High School-9th Grade Academy   Regular School No Secondary 09 09 2020   kindergarten_half_day                                                   0.0                                             0
2484268 2484268 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003296 55 Churchill Jr High School   Regular School No Secondary 08 09 2020   kindergarten_half_day                                                   0.0                                             0
2377927 2377927 NJ Atlantic 1 school 3400960 110   Atlantic City School District 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2377956 2377956 NJ Atlantic 1 school 3405730 1690   Galloway Township Public School District 340573000114 40 Pomona Preschool   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2377989 2377989 NJ Atlantic 1 school 3415030 4800   Somers Point School District 341503000533 60 New York Avenue Elementary School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378079 2378079 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378084 2378084 NJ Bergen 3 school 3405760 1700   Garfield Public School District 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378086 2378086 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   kindergarten_half_day                                                   0.0                                             0
2378131 2378131 NJ Bergen 3 school 3409210 2860   Lyndhurst School District 340921003471 301 Community   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378202 2378202 NJ Bergen 3 school 3413830 4390   Ridgewood Public School District 341383000221 80 Glen School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378228 2378228 NJ Bergen 3 school 3414490 4610   Saddle Brook School District 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378240 2378240 NJ Bergen 3 school 3416080 5150   Teaneck School District 341608000846 80 William Cullen Bryant School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378372 2378372 NJ Burlington 5 school 3412810 4050   Pemberton Township School District 341281003167 300 Pemberton Early Childhood Education Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378423 2378423 NJ Camden 7 school 3402640 680   Camden City School District 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378457 2378457 NJ Camden 7 school 3403420 940   Collingswood Public School District 340342003485 300 Collingswood Pre School At Oaklyn   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378460 2378460 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   kindergarten_half_day                                                   0.0                                             0
2378505 2378505 NJ Camden 7 school 3408640 2670   Lindenwold Public School District 340864003271 300 Lindenwold Preschool Building   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378513 2378513 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   kindergarten_half_day                                                   0.0                                             0
2378585 2378585 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   kindergarten_half_day                                                   0.0                                             0
2378600 2378600 NJ Cumberland 11 school 3410320 3230   Millville School District 341032001874 68 Child Family Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378620 2378620 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   kindergarten_half_day                                                   0.0                                             0
2378631 2378631 NJ Essex 13 school 3401350 250   Belleville Public School District 340135003501 301 Sandy Lane Nursery School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378633 2378633 NJ Essex 13 school 3401350 250   Belleville Public School District 340135003499 300 Hornblower Early Edudcation Elementary Sch   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378638 2378638 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   kindergarten_half_day                                                   0.0                                             0
2378702 2378702 NJ Essex 13 school 3407680 2330   Irvington Public School District 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378738 2378738 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003153 306 Early Childhood School - South   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378749 2378749 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003193 308 Early Childhood School - West   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378750 2378750 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003281 314 Early Childhood School - Central   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378774 2378774 NJ Essex 13 school 3411340 3570   Newark Public School District 341134003327 316 Early Childhood School - North   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378810 2378810 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   kindergarten_half_day                                                   0.0                                             0
2378823 2378823 NJ Essex 13 school 3415330 4900   South Orange-Maplewood School District 341533003339 300 Montrose Early Childhood Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2378844 2378844 NJ Essex 13 school 3417610 5680   West Orange Public Schools 341761003416 300 Betty Maddalena Early Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379038 2379038 NJ Hudson 17 school 3417580 5670   West New York School District 341758000445 55 Early Childhood School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379299 2379299 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   kindergarten_half_day                                                   0.0                                             0
2379305 2379305 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   kindergarten_half_day                                                   0.0                                             0
2379325 2379325 NJ Middlesex 23 school 3414640 4660   Sayreville School District 341464003513 301 Project Before At Cheesequake School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379416 2379416 NJ Monmouth 25 school 3405640 1660   Freehold Township School District 340564006120 70 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379444 2379444 NJ Monmouth 25 school 3407860 2400   Keansburg School District 340786003882 40 Port Monmouth Road School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379477 2379477 NJ Monmouth 25 school 3409750 3040   Matawan-Aberdeen Regional School District 340975000723 40 Cambridge Park Elementary School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379523 2379523 NJ Monmouth 25 school 3411160 3510   Neptune Township School District 341116000457 59 Early Childhood Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379553 2379553 NJ Monmouth 25 school 3416890 5420   Wall Township Public School District 341689000099 78 Wall Primary School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379583 2379583 NJ Morris 27 school 3403930 1110   Dover Public School District 340393003478 300 Votech   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379641 2379641 NJ Morris 27 school 3410810 3385   Morris School District 341081004376 85 Lafayette Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379717 2379717 NJ Ocean 29 school 3416470 185   Barnegat Township School District 341647004564 10 Lillian M. Dunfee Elementary   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379726 2379726 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   kindergarten_half_day                                                   0.0                                             0
2379728 2379728 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   kindergarten_half_day                                                   0.0                                             0
2379768 2379768 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   kindergarten_half_day                                                   0.0                                             0
2379803 2379803 NJ Ocean 29 school 3415690 5020   Stafford Township School District 341569004716 50 Oxycocus Elementary School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379834 2379834 NJ Passaic 31 school 3403300 900   Clifton Public School District 340330003436 301 Clifton Early Learner Academies   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379874 2379874 NJ Passaic 31 school 3412540 3970   Passaic City School District 341254000403 180 School No.16   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379889 2379889 NJ Passaic 31 school 3412690 4010   Paterson Public School District 341269003473 302 14# Avenue Early Learning Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379946 2379946 NJ Passaic 31 school 3417280 5570   Wayne Township Public School District 341728003515 300 Preakness Early Childhood Center   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379969 2379969 NJ Passaic 31 school 3417640 5690   Woodland Park School District 341764003517 300 School One   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2379990 2379990 NJ Salem 33 school 3413110 4150   Pittsgrove Township School District 341311005082 50 Norma Elementary School   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380139 2380139 NJ Union 39 school 3403150 850   Clark Township Public School District 340315003295 300 Clark Preschool Annex   Special Education School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380161 2380161 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459006131 355 Donald Stewart Early Childhood Center No 51   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380175 2380175 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000467 350 Frances C. Smith Early Childhood Center No 50   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380176 2380176 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000567 360 Dr. Martin Luther King Jr. Early Childhood Center No 52   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2380236 2380236 NJ Union 39 school 3414280 4540   Roselle Public Schools 341428003147 120 Roselle Preschool   Regular School No Prekindergarten PK PK 2021   kindergarten_half_day                                                   0.0                                             0
2483006 2483006 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483032 2483032 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000114 40 Pomona Preschool   Special Education School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483064 2483064 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000533 60 New York Avenue Elementary School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483154 2483154 NJ Bergen 3 school 3405760 1700   Garfield City 340576006110 40 Garfield Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483159 2483159 NJ Bergen 3 school 3405760 1700   Garfield City 340576000386 86 Garfield Public Preschool Annex   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483165 2483165 NJ Bergen 3 school 3405760 1700   Garfield City 340576003431 302 Garfield Public Preschool 3 At Headstart   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483278 2483278 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000221 80 Glen School   Special Education School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483302 2483302 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483449 2483449 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003167 300 Pemberton Early Childhood Education Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483491 2483491 NJ Camden 7 school 3402640 680   Camden City 340264001344 25 Early Childhood Development Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483499 2483499 NJ Camden 7 school 3402640 680   Camden City 340264006084 175 Riletta Twyne Cream Family School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483539 2483539 NJ Camden 7 school 3403420 940   Collingswood Boro 340342003485 300 Collingswood Pre School At Oaklyn   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483581 2483581 NJ Camden 7 school 3408640 2670   Lindenwold Boro 340864003271 300 Lindenwold Preschool Building   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483589 2483589 NJ Camden 7 school 3412870 4060   Pennsauken Twp 341287001622 90 Baldwin Elementary School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483662 2483662 NJ Cumberland 11 school 3402250 540   Bridgeton City 340225000581 150 Geraldine O Foster Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483677 2483677 NJ Cumberland 11 school 3410320 3230   Millville City 341032001874 68 Child Family Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483695 2483695 NJ Cumberland 11 school 3416800 5390   Vineland City 341680000225 176 Casimer M. Dallago Jr. Impact Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483717 2483717 NJ Essex 13 school 3401830 410   Bloomfield Twp 340183000133 120 The Early Childhood Center @ Forest Glen   Special Education School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483767 2483767 NJ Essex 13 school 3407680 2330   Irvington Township 340768002949 71 Augusta Preschool Academy   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483827 2483827 NJ Essex 13 school 3411340 3570   Newark City 341134003153 306 Early Childhood School - South   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483829 2483829 NJ Essex 13 school 3411340 3570   Newark City 341134003193 308 Early Childhood School - West   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483831 2483831 NJ Essex 13 school 3411340 3570   Newark City 341134003281 314 Early Childhood School - Central   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483832 2483832 NJ Essex 13 school 3411340 3570   Newark City 341134003327 316 Early Childhood School - North   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483884 2483884 NJ Essex 13 school 3412270 3880   City Of Orange Twp 341227003148 300 Orange Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483895 2483895 NJ Essex 13 school 3415330 4900   South Orange-Maplewood 341533003339 300 Montrose Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483915 2483915 NJ Essex 13 school 3417610 5680   West Orange Town 341761003416 300 Betty Maddalena Early Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484022 2484022 NJ Hudson 17 school 3407350 2210   Hoboken City 340735002760 63 Early Childhood Learning Center At Calabro School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484107 2484107 NJ Hudson 17 school 3417580 5670   West New York Town 341758000445 55 Early Childhood School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484122 2484122 NJ Hunterdon 19 school 3403360 920   Clinton Twp 340336002968 30 Spruce Run   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484368 2484368 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293000551 75 Ignacio Cruz Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484369 2484369 NJ Middlesex 23 school 3412930 4090   Perth Amboy City 341293002998 80 Edmund Hmieleski Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484485 2484485 NJ Monmouth 25 school 3405640 1660   Freehold Twp 340564006120 70 Early Childhood Learning Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484514 2484514 NJ Monmouth 25 school 3407860 2400   Keansburg Boro 340786003882 40 Port Monmouth Road School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484546 2484546 NJ Monmouth 25 school 3409750 3040   Matawan-Aberdeen Regional 340975000723 40 Cambridge Park Elementary School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484589 2484589 NJ Monmouth 25 school 3411160 3510   Neptune Twp 341116000457 59 Early Childhood Center   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484626 2484626 NJ Monmouth 25 school 3416890 5420   Wall Twp 341689000099 78 Wall Primary School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2484712 2484712 NJ Morris 27 school 3410810 3385   Morris School District 341081004376 85 Lafayette Learning Center   Regular School No Prekindergarten PK PK 2020   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]);