enrollments

Data source: Big Local News · About: Big Local

5,007 rows where grade = "pre_kindergarten_half_day" and state = "NJ" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_kindergarten_half_day · 3,021 ✖
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
2478143 2478143 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000448 80 School No. 3   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478144 2478144 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000450 90 School No. 4   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478145 2478145 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000452 100 Lewis F. Cole Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478146 2478146 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000117 15 Franklin Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478148 2478148 NJ Bergen 3 school 3405370 1580   Franklin Lakes Boro 340537000462 30 Woodside Avenue School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478151 2478151 NJ Bergen 3 school 3405760 1700   Garfield City 340576000466 50 Garfield High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478152 2478152 NJ Bergen 3 school 3405760 1700   Garfield City 340576000468 60 Christopher Columbus School #8   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478153 2478153 NJ Bergen 3 school 3405760 1700   Garfield City 340576000470 70 Garfield Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478159 2478159 NJ Bergen 3 school 3405760 1700   Garfield City 340576000387 205 James Madison School #10   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478160 2478160 NJ Bergen 3 school 3405760 1700   Garfield City 340576003443 300 Thomas Jefferson School #9   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478162 2478162 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000484 50 Glen Rock High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478163 2478163 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000077 60 Glen Rock Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478164 2478164 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000482 65 Alexander Hamilton School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478165 2478165 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000486 70 Richard Byrd   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478166 2478166 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000488 80 Central School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478167 2478167 NJ Bergen 3 school 3405970 1760   Glen Rock Boro 340597000490 90 Clara E Coleman School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478168 2478168 NJ Bergen 3 school 3406270 1860   Hackensack City 340627000496 50 Hackensack High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478173 2478173 NJ Bergen 3 school 3406270 1860   Hackensack City 340627003191 300 Hackensack Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478175 2478175 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000512 50 Hasbrouck Heights High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478176 2478176 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000491 55 Hasbrouck Heights Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478177 2478177 NJ Bergen 3 school 3406930 2080   Hasbrouck Heights Boro 340693000514 60 Euclid Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478179 2478179 NJ Bergen 3 school 3406960 2090   Haworth Boro 340696000520 50 Haworth Public School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478180 2478180 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000524 10 Ann Blanche Smith   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478181 2478181 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000526 20 George G White   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478182 2478182 NJ Bergen 3 school 3407260 2180   Hillsdale Boro 340726000528 30 Meadowbrook   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478183 2478183 NJ Bergen 3 school 3407320 2200   Ho Ho Kus Boro 340732000530 50 Ho-Ho-Kus Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478184 2478184 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000534 50 Leonia High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478185 2478185 NJ Bergen 3 school 3408520 2620   Leonia Boro 340852000536 55 Leonia Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478187 2478187 NJ Bergen 3 school 3408760 2710   Little Ferry Boro 340876000542 30 Memorial Elementary School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478189 2478189 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000550 50 Lodi High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478190 2478190 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000552 60 Columbus School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478191 2478191 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000554 65 Hilltop School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478192 2478192 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000556 67 Thomas Jefferson Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478193 2478193 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885005975 80 Roosevelt School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478194 2478194 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000562 90 Washington School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478195 2478195 NJ Bergen 3 school 3408850 2740   Lodi Borough 340885000564 100 Wilson School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478196 2478196 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000568 50 Lyndhurst High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478197 2478197 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000570 60 Columbus School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478198 2478198 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000572 70 Franklin School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478199 2478199 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000574 80 Jefferson School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478200 2478200 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000576 90 Lincoln School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478201 2478201 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000580 110 Roosevelt School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478202 2478202 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921000582 120 Washington School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478203 2478203 NJ Bergen 3 school 3409210 2860   Lyndhurst Twp 340921003279 300 Memorial Campus   Regular School No Elementary 03 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478204 2478204 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000586 50 Mahwah High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478205 2478205 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000588 60 Betsy Ross Elementary   Regular School No Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478206 2478206 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000492 65 Lenape Meadows   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478207 2478207 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000592 75 Joyce Kilmer School   Regular School No Elementary 04 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478208 2478208 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000594 76 Ramapo Ridge   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478209 2478209 NJ Bergen 3 school 3409330 2900   Mahwah Twp 340933000596 80 George Washington School   Regular School No Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478210 2478210 NJ Bergen 3 school 3409810 3060   Maywood Boro 340981000602 60 Maywood Avenue School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478211 2478211 NJ Bergen 3 school 3409810 3060   Maywood Boro 340981000604 70 Memorial School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478212 2478212 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014000608 50 Midland Park Jr./Sr. High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478213 2478213 NJ Bergen 3 school 3410140 3170   Midland Park Boro 341014000612 70 Highland Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478215 2478215 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000616 20 Fieldstone Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478216 2478216 NJ Bergen 3 school 3410620 3330   Montvale Boro 341062000618 30 Memorial Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478218 2478218 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000624 50 New Milford High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478219 2478219 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000626 60 Berkley Street School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478220 2478220 NJ Bergen 3 school 3411280 3550   New Milford Boro 341128000628 70 Bertrand F. Gibbs Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478222 2478222 NJ Bergen 3 school 3411430 3600   North Arlington Boro 341143000636 50 North Arlington High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478223 2478223 NJ Bergen 3 school 3411430 3600   North Arlington Boro 341143000638 60 Jefferson Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478224 2478224 NJ Bergen 3 school 3411430 3600   North Arlington Boro 341143000640 70 Roosevelt Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478226 2478226 NJ Bergen 3 school 3411430 3600   North Arlington Boro 341143000644 90 North Arlington Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478227 2478227 NJ Bergen 3 school 3411730 3700   Northern Highlands Reg 341173000646 50 Northern Highlands Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478228 2478228 NJ Bergen 3 school 3411760 3710   Northern Valley Regional 341176000650 50 Northern Valley Regional High School At Demarest   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478229 2478229 NJ Bergen 3 school 3411760 3710   Northern Valley Regional 341176000652 60 Northern Valley Regional High School At Old Tappan   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478230 2478230 NJ Bergen 3 school 3411760 3710   Northern Valley Regional 341176003359 300 Northern Valley Central   Special Education School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478231 2478231 NJ Bergen 3 school 3411820 3730   Northvale Boro 341182000656 50 Northvale Public School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478233 2478233 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000664 40 Dogwood Hill Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478234 2478234 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000666 50 Heights Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478235 2478235 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000668 60 Manito Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478236 2478236 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000670 80 Valley Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478237 2478237 NJ Bergen 3 school 3412180 3850   Old Tappan Boro 341218000674 30 Charles Dewolf Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478239 2478239 NJ Bergen 3 school 3412240 3870   Oradell Boro 341224000678 50 Oradell Public School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478240 2478240 NJ Bergen 3 school 3412360 3910   Palisades Park 341236000682 50 Palisades Park Jr-Sr High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478241 2478241 NJ Bergen 3 school 3412360 3910   Palisades Park 341236000684 70 Lindbergh Elementary School   Regular School No Elementary 01 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478244 2478244 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000690 60 West Brook Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478245 2478245 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000692 65 East Brook Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478246 2478246 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000696 80 Memorial Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478247 2478247 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000400 90 Midland Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478249 2478249 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000702 110 Ridge Ranch Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478250 2478250 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000706 130 Stony Lane Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478251 2478251 NJ Bergen 3 school 3412450 3940   Park Ridge Boro 341245000710 50 Park Ridge High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478252 2478252 NJ Bergen 3 school 3412450 3940   Park Ridge Boro 341245000712 60 East Brook Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478254 2478254 NJ Bergen 3 school 3412510 3960   Pascack Valley Regional 341251000718 40 Pascack Hills High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478255 2478255 NJ Bergen 3 school 3412510 3960   Pascack Valley Regional 341251000720 50 Pascack Valley High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478256 2478256 NJ Bergen 3 school 3413560 4300   Ramapo-Indian Hill Reg 341356000724 30 Indian Hills High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478257 2478257 NJ Bergen 3 school 3413560 4300   Ramapo-Indian Hill Reg 341356000726 50 Ramapo High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478258 2478258 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000730 50 Ramsey High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478259 2478259 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000732 55 Eric S. Smith Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478260 2478260 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000734 60 John Y Dater Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478263 2478263 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377000742 50 Ridgefield Memorial High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478264 2478264 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377006057 65 Bergen Boulevard School   Regular School No Elementary 01 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478266 2478266 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377000750 100 Slocum Skewes School   Regular School No Other 01 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478267 2478267 NJ Bergen 3 school 3413800 4380   Ridgefield Park Twp 341380000754 50 Ridgefield Park Jr Sr High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478268 2478268 NJ Bergen 3 school 3413800 4380   Ridgefield Park Twp 341380000756 60 Grant Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478270 2478270 NJ Bergen 3 school 3413800 4380   Ridgefield Park Twp 341380000760 80 Roosevelt Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478271 2478271 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000764 50 Ridgewood High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478272 2478272 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000766 60 Benjamin Franklin Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478273 2478273 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000768 70 George Washington Middle School   Regular School No Middle 06 08 2020   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]);