enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • pre_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
2375292 2375292 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375293 2375293 NJ Warren 41 school 3400720 30   Allamuchy Township School District 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375294 2375294 NJ Warren 41 school 3400840 70   Alpha Borough School District 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   3.0                                             3
2375295 2375295 NJ Warren 41 school 3401440 280   Belvidere School District 340144005794 20 Belvidere High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375296 2375296 NJ Warren 41 school 3401440 280   Belvidere School District 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   18.0                                             18
2375297 2375297 NJ Warren 41 school 3401800 400   Blairstown Elementary Township School District 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten_half_day                                                   23.0                                             23
2375298 2375298 NJ Warren 41 school 3405520 1620   Franklin Township School District 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375299 2375299 NJ Warren 41 school 3405670 1670   Frelinghuysen Township School District 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375300 2375300 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2021   pre_kindergarten_half_day                                                   5.0                                             5
2375301 2375301 NJ Warren 41 school 3400008 1785   Great Meadows Regional School District 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375302 2375302 NJ Warren 41 school 3406210 1840   Greenwich Township School District 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2021   pre_kindergarten_half_day                                                   1.0                                             1
2375303 2375303 NJ Warren 41 school 3406210 1840   Greenwich Township School District 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375304 2375304 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 02 2021   pre_kindergarten_half_day                                                   25.0                                             25
2375305 2375305 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005814 50 Hackettstown High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375306 2375306 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375307 2375307 NJ Warren 41 school 3406300 1870   Hackettstown Public School District 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375308 2375308 NJ Warren 41 school 3406810 2040   Harmony Township School District 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375309 2375309 NJ Warren 41 school 3407470 2250   Hope Township School District 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375310 2375310 NJ Warren 41 school 3408070 2470   Knowlton Township School District 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375311 2375311 NJ Warren 41 school 3409000 2790   Lopatcong Township School District 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375312 2375312 NJ Warren 41 school 3409000 2790   Lopatcong Township School District 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375313 2375313 NJ Warren 41 school 3409540 2970   Mansfield Township Elementary School District 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2021   pre_kindergarten_half_day                                                   11.0                                             11
2375314 2375314 NJ Warren 41 school 3409550 3675   North Warren Regional School District 340955005844 50 North Warren Regional School   Regular School No High 07 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375315 2375315 NJ Warren 41 school 3412300 3890   Oxford Township School District 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375316 2375316 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375317 2375317 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2021   pre_kindergarten_half_day                                                   180.0                                             180
2375318 2375318 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375319 2375319 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375320 2375320 NJ Warren 41 school 3412960 4100   Phillipsburg School District 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375321 2375321 NJ Warren 41 school 3413260 4200   Pohatcong Township School District 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375322 2375322 NJ Warren 41 school 3417920 5460   Warren County Vocational Technical School 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375323 2375323 NJ Warren 41 school 3416970 5465   Warren Hills Regional School District 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375324 2375324 NJ Warren 41 school 3416970 5465   Warren Hills Regional School District 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375325 2375325 NJ Warren 41 school 3417010 5480   Washington Borough School District 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 02 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375326 2375326 NJ Warren 41 school 3417010 5480   Washington Borough School District 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 01 2021   pre_kindergarten_half_day                                                   64.0                                             64
2375327 2375327 NJ Warren 41 school 3417160 5530   Washington Township School District 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375328 2375328 NJ Warren 41 school 3417160 5530   Washington Township School District 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375329 2375329 NJ Warren 41 school 3417910 5780   White Township Consolidated School District 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2480368 2480368 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072005788 10 Allamuchy Township School   Regular School No Middle 03 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480369 2480369 NJ Warren 41 school 3400720 30   Allamuchy Twp 340072003066 20 Mountain Villa School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480370 2480370 NJ Warren 41 school 3400840 70   Alpha Boro 340084005790 10 Alpha Borough School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   5.0                                             5
2480371 2480371 NJ Warren 41 school 3401440 280   Belvidere Town 340144005794 20 Belvidere High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480372 2480372 NJ Warren 41 school 3401440 280   Belvidere Town 340144005796 30 Oxford Street Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   25.0                                             25
2480373 2480373 NJ Warren 41 school 3401800 400   Blairstown Twp 340180005800 30 Blairstown Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   28.0                                             28
2480374 2480374 NJ Warren 41 school 3405520 1620   Franklin Twp 340552005802 50 Franklin Township School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480375 2480375 NJ Warren 41 school 3405670 1670   Frelinghuysen Twp 340567005804 50 Frelinghuysen Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480376 2480376 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800248 40 Great Meadows Regional Middle School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480377 2480377 NJ Warren 41 school 3400008 1785   Great Meadows Regional 340000800107 50 Central Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   7.0                                             7
2480378 2480378 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621000471 40 Greenwich School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480379 2480379 NJ Warren 41 school 3406210 1840   Greenwich Twp 340621005810 70 Stewartsville Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480380 2480380 NJ Warren 41 school 3406300 1870   Hackettstown 340630005814 50 Hackettstown High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480381 2480381 NJ Warren 41 school 3406300 1870   Hackettstown 340630005816 60 Hackettstown Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480382 2480382 NJ Warren 41 school 3406300 1870   Hackettstown 340630005818 70 Hatchery Hill Elementary School   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   18.0                                             18
2480383 2480383 NJ Warren 41 school 3406300 1870   Hackettstown 340630005820 90 Willow Grove Elementary School   Regular School No Elementary 02 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480384 2480384 NJ Warren 41 school 3406810 2040   Harmony Twp 340681005824 30 Harmony Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480385 2480385 NJ Warren 41 school 3407470 2250   Hope Twp 340747005826 50 Hope Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480386 2480386 NJ Warren 41 school 3408070 2470   Knowlton Twp 340807005832 40 Knowlton Township Board Of Education   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480387 2480387 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900005840 50 Lopatcong Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480388 2480388 NJ Warren 41 school 3409000 2790   Lopatcong Twp 340900000731 60 Lopatcong Township Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480389 2480389 NJ Warren 41 school 3409540 2970   Mansfield Twp 340954005842 50 Mansfield Township Elementary   Regular School No Elementary PK 06 2020   pre_kindergarten_half_day                                                   10.0                                             10
2480390 2480390 NJ Warren 41 school 3409550 3675   North Warren Regional 340955005844 50 North Warren Regional School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480391 2480391 NJ Warren 41 school 3412300 3890   Oxford Twp 341230005846 50 Oxford Central School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480392 2480392 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005852 50 Phillipsburg High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480393 2480393 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005856 70 Philipsburg Primary School   Regular School No Elementary KG 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480394 2480394 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005860 105 Phillipsburg Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480395 2480395 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296005862 110 Phillipsburg Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480396 2480396 NJ Warren 41 school 3412960 4100   Phillipsburg Town 341296002957 150 Phillipsburg Early Childhood Learning Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   241.0                                             241
2480397 2480397 NJ Warren 41 school 3413260 4200   Pohatcong Twp 341326000366 40 Pohatcong Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480398 2480398 NJ Warren 41 school 3417920 5460   Warren County Vocational 341792005872 50 Warren County Vocational Technical School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480399 2480399 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005878 50 Warren Hills Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480400 2480400 NJ Warren 41 school 3416970 5465   Warren Hills Regional 341697005880 60 Warren Hills Regional Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480401 2480401 NJ Warren 41 school 3417010 5480   Washington Boro 341701005884 55 Washington Memorial Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480402 2480402 NJ Warren 41 school 3417010 5480   Washington Boro 341701005886 60 Taylor Street Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   34.0                                             34
2480403 2480403 NJ Warren 41 school 3417160 5530   Washington Twp 341716005890 40 Brass Castle School   Regular School No Elementary 04 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480404 2480404 NJ Warren 41 school 3417160 5530   Washington Twp 341716005892 50 Port Colden School   Regular School No Elementary 01 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2480405 2480405 NJ Warren 41 school 3417910 5780   White Twp 341791005894 50 White Township Consolidated School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2375121 2375121 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005436 30 Columbia Middle School   Regular School No Middle 06 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375122 2375122 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005434 20 Thomas P. Hughes School   Regular School No Elementary 02 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375123 2375123 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005442 50 William Woodruff School   Regular School No Elementary 02 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375124 2375124 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000203 35 Mary Kay Mcmillin Early Childhood Center   Regular School No Elementary PK 01 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375125 2375125 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153005440 40 Mountain Park School   Regular School No Elementary 02 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375126 2375126 NJ Union 39 school 3401530 310   Berkeley Heights School District 340153000201 5 Governor Livingston High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375127 2375127 NJ Union 39 school 3403150 850   Clark Township Public School District 340315000205 5 Arthur L. Johnson High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375128 2375128 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005454 40 Valley Road School   Regular School No Elementary KG 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375129 2375129 NJ Union 39 school 3403150 850   Clark Township Public School District 340315003295 300 Clark Preschool Annex   Special Education School No Prekindergarten PK PK 2021   pre_kindergarten_half_day                                                   8.0                                             8
2375130 2375130 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005452 35 Carl H. Kumpf School   Regular School No Middle 06 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375131 2375131 NJ Union 39 school 3403150 850   Clark Township Public School District 340315005450 30 Frank K. Hehnly   Regular School No Elementary KG 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375132 2375132 NJ Union 39 school 3403570 980   Cranford Public School District 340357005458 30 Cranford High School   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375133 2375133 NJ Union 39 school 3403570 980   Cranford Public School District 340357005466 50 Brookside Place School   Regular School No Elementary KG 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375134 2375134 NJ Union 39 school 3403570 980   Cranford Public School District 340357005470 80 Livingston Avenue School   Regular School No Elementary 03 05 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375135 2375135 NJ Union 39 school 3403570 980   Cranford Public School District 340357005474 110 Walnut Avenue School   Regular School No Elementary PK 02 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375136 2375136 NJ Union 39 school 3403570 980   Cranford Public School District 340357005460 33 Hillside Avenue School   Regular School No Elementary KG 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375137 2375137 NJ Union 39 school 3403570 980   Cranford Public School District 340357000206 40 Bloomingdale Avenue School   Regular School No Elementary KG 02 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375138 2375138 NJ Union 39 school 3403570 980   Cranford Public School District 340357005462 37 Orange Avenue School   Regular School No Middle 03 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375139 2375139 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005478 25 Elizabeth High School - Frank J Cicarell Academy   Regular School No High 09 12 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375140 2375140 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005494 100 Winfield Scott School No. 2   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   114.0                                             114
2375141 2375141 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005526 260 Nicholas Murray Butler Academy School No. 23   Regular School No Elementary KG 08 2021   pre_kindergarten_half_day                                                   0.0                                             0
2375142 2375142 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459000806 295 Dr. Albert Einstein Academy School No. 29   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   123.0                                             123
2375143 2375143 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459002983 315 Juan Pablo Duarte - Jose Julian Marti School No 28   Regular School No Elementary PK 08 2021   pre_kindergarten_half_day                                                   43.0                                             43
2375144 2375144 NJ Union 39 school 3404590 1320   Elizabeth Public Schools 340459005520 230 John Marshal School No. 20   Regular School No Elementary KG 08 2021   pre_kindergarten_half_day                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);