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_high_grade 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
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
2370790 NJ Burlington 5 school 3404470 1280   Edgewater Park Township School District 340447001062 50 Mildred Magowan Elementary School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370791 NJ Burlington 5 school 3404470 1280   Edgewater Park Township School District 340447001064 70 Samuel M Ridgway Middle School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370800 NJ Burlington 5 school 3405220 1520   Florence Township School District 340522006066 55 Florence Riverfront School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370801 NJ Burlington 5 school 3405220 1520   Florence Township School District 340522001086 70 Roebling Elementary School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   16.0                                             16
2370894 NJ Camden 7 school 3401590 330   Berlin Borough School District 340159001324 20 Berlin Community School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   15.0                                             15
2371944 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003928 55 Lafayette Mills School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371945 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939000453 110 Wemrock Brook School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371946 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939000029 60 Manalapan-Englishtown Middle School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371947 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003926 50 Clark Mills School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371948 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003932 75 Pine Brook School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371949 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003936 90 Taylor Mills School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371950 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939003930 63 Milford Brook School   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371951 NJ Monmouth 25 school 3409390 2920   Manalapan-Englishtown Regional Schools School District 340939002941 120 John I. Dawes Early Learning Center   Regular School No Not reported M M 2021   pre_kindergarten_full_day                                                   24.0                                             24
2370538 NJ Bergen 3 school 3404740 1370   Englewood Public School District 340474000392 70 Donald A. Quarles Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370552 NJ Bergen 3 school 3405070 1470   Fairview Public School District 340507000256 65 Lincoln School Annex   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   73.0                                             73
2370656 NJ Bergen 3 school 3412360 3910   Palisades Park School District 341236000789 80 Charles R Smith Early Chilhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   7.0                                             7
2370719 NJ Bergen 3 school 3416080 5150   Teaneck School District 341608003493 300 Theodora Smiley Lacey Elementary School   Regular School No Elementary KG KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370876 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003459 302 Ecdc At J.C.Stuart   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   2.0                                             2
2370882 NJ Burlington 5 school 3418000 5805   Willingboro Public School District 341800003489 303 Ecdc At Garfield East   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370913 NJ Camden 7 school 3402640 680   Camden City School District 340264006084 175 Riletta Twyne Cream Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2370940 NJ Camden 7 school 3403000 800   Cherry Hill School District 340300000263 62 Barclay Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   100.0                                             100
2371025 NJ Camden 7 school 3417250 5560   Waterford Township School District 341725005924 60 Thomas Richards Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371047 NJ Cape May 9 school 3409150 2840   Lower Township Elementary School District 340915005909 70 David C. Douglass Memorial School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371135 NJ Essex 13 school 3402580 660   Caldwell-West School District 340258003425 300 Harrison School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   6.0                                             6
2371158 NJ Essex 13 school 3404230 1210   East Orange School District 340423000275 107 Althea Gibson Academy   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371159 NJ Essex 13 school 3404230 1210   East Orange School District 340423000381 210 Wahlstrom Early Childhood Academy   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371355 NJ Gloucester 15 school 3405880 1730   Glassboro School District 340588002566 80 J. Harvey Rodgers School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371369 NJ Gloucester 15 school 3409600 2990   Mantua Township School District 340960002590 50 Sewell Elementary School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371393 NJ Gloucester 15 school 3415990 5120   Swedesboro-Woolwich School District 341599000184 70 Margaret C. Clifford School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   24.0                                             24
2371402 NJ Gloucester 15 school 3417070 5500   Washington Township School District 341707006038 30 Grenloch Terrace Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   25.0                                             25
2371515 NJ Hudson 17 school 3416380 5240   Union City School District 341638000819 145 Eugenio Maria De Hostos Center For Early Childhood Education   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371699 NJ Middlesex 23 school 3404500 1290   Edison Township School District 340450003237 302 Franklin D Roosevelt School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   31.0                                             31
2371709 NJ Middlesex 23 school 3404500 1290   Edison Township School District 340450003179 300 Edison Early Learning Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   12.0                                             12
2371720 NJ Middlesex 23 school 3409990 3120   Metuchen Public School District 340999003400 90 Mildred B. Moss Elementary School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   6.0                                             6
2371844 NJ Middlesex 23 school 3418120 5850   Woodbridge Township School District 341812003702 180 Kennedy Park Elementary School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   37.0                                             37
2371903 NJ Monmouth 25 school 3413680 2105   Hazlet Township Public School District 341368003838 100 Sycamore Drive Early Childhood Learning Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   65.0                                             65
2371938 NJ Monmouth 25 school 3408940 2770   Long Branch Public School District 340894003918 120 Lenna W. Conrow Elementary School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371940 NJ Monmouth 25 school 3408940 2770   Long Branch Public School District 340894000333 85 Joseph M. Ferraina Early Childhood Learning Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371943 NJ Monmouth 25 school 3408940 2770   Long Branch Public School District 340894003912 80 Morris Avenue Elementry School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2371957 NJ Monmouth 25 school 3409720 3030   Marlboro Township School District 340972000454 43 David C Abbott Early Learning Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   9.0                                             9
2372089 NJ Morris 27 school 3407800 2380   Jefferson Township Public School District 340780004276 50 Milton Elementary School   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   14.0                                             14
2372246 NJ Ocean 29 school 3408220 2520   Lakewood Township School District 340822003249 300 Lakewood Early Childhood Center   Regular School No Elementary PK KG 2021   pre_kindergarten_full_day                                                   0.0                                             0
2372289 NJ Ocean 29 school 3415690 5020   Stafford Township School District 341569000796 75 Ronald L. Meinders Primary Learning Center   Regular School No Elementary KG KG 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]);