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,121 ✖
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
2477992 2477992 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2477994 2477994 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2477997 2477997 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000018 60 Texas Avenue School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478005 2478005 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478006 2478006 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478008 2478008 NJ Atlantic 1 school 3400006 125   Atlantic Co Special Serv 340000600697 60 Atlantic County High School   Special Education School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478010 2478010 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000044 25 Buena Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478011 2478011 NJ Atlantic 1 school 3402400 590   Buena Regional 340240000046 30 Buena Regional Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478014 2478014 NJ Atlantic 1 school 3402400 590   Buena Regional 340240003221 300 Dr. J.P. Cleary Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478016 2478016 NJ Atlantic 1 school 3404530 1300   Egg Harbor City 340453000076 30 Egg Harbor City Community School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478017 2478017 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456005961 5 Egg Harbor Township High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478018 2478018 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000086 33 Clayton J. Davenport Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478019 2478019 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000051 35 E. H. Slaybaugh Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478020 2478020 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002953 38 Alder Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478021 2478021 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456002955 39 Fernwood Avenue Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478022 2478022 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000698 45 Dr. Joyanne D. Miller Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478023 2478023 NJ Atlantic 1 school 3404560 1310   Egg Harbor Twp 340456000092 50 H. Russel Swift Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478024 2478024 NJ Atlantic 1 school 3404860 1410   Estell Manor City 340486000102 50 Estell Manor Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478026 2478026 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000108 15 Arthur Rann Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478027 2478027 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573000383 16 Galloway Township Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478029 2478029 NJ Atlantic 1 school 3405730 1690   Galloway Twp 340573006028 45 Reeds Road Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478032 2478032 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000122 40 Absegami High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478033 2478033 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606000124 50 Oakcrest High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478034 2478034 NJ Atlantic 1 school 3406060 1790   Greater Egg Harbor Reg 340606003115 60 Cedar Creek High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478037 2478037 NJ Atlantic 1 school 3406510 1940   Hamilton Twp 340651006029 120 William Davies Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478038 2478038 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000699 30 Hammonton Early Childhood Eductional Center   Regular School No Elementary PK 01 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478039 2478039 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000136 50 Hammonton High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478040 2478040 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000138 55 Warren E. Sooy Jr. Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478041 2478041 NJ Atlantic 1 school 3406570 1960   Hammonton Town 340657000140 60 Hammonton Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478042 2478042 NJ Atlantic 1 school 3408670 2680   Linwood City 340867000144 20 Belhaven Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478044 2478044 NJ Atlantic 1 school 3409360 2910   Mainland Regional 340936000158 50 Mainland Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478045 2478045 NJ Atlantic 1 school 3409690 3020   Margate City 340969000162 10 Eugene A. Tighe Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478046 2478046 NJ Atlantic 1 school 3409690 3020   Margate City 340969000393 25 William H. Ross Iii School   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478048 2478048 NJ Atlantic 1 school 3411070 3480   Mullica Twp 341107000174 25 Mullica Township Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478049 2478049 NJ Atlantic 1 school 3411790 3720   Northfield City 341179000215 56 Northfield Community Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478052 2478052 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000219 55 Pleasantville Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478053 2478053 NJ Atlantic 1 school 3413200 4180   Pleasantville City 341320000194 60 Washington Avenue Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478057 2478057 NJ Atlantic 1 school 3413380 4240   Port Republic City 341338000204 50 Port Republic Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478058 2478058 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000208 50 Dawes Avenue Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478059 2478059 NJ Atlantic 1 school 3415030 4800   Somers Point City 341503000210 55 Jordan Road Elementary School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478061 2478061 NJ Atlantic 1 school 3416680 5350   Ventnor City 341668000216 40 Ventnor Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478064 2478064 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000224 10 Brookside School   Regular School No Middle 04 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478065 2478065 NJ Bergen 3 school 3400750 40   Allendale Boro 340075000226 20 Hillside Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478066 2478066 NJ Bergen 3 school 3400870 80   Alpine Boro 340087000228 10 Alpine Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478070 2478070 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000238 50 Emotionally Disturbed   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478071 2478071 NJ Bergen 3 school 3401450 285   Bergen Co Special Service 340145000240 70 Life Skills   Special Education School No Other PK 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478073 2478073 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000250 20 Bergen County Academies   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478074 2478074 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000252 30 Bergen County Technical High School - Paramus   Special Education School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478075 2478075 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000262 70 Bergen County Technical High School - Teterboro   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478076 2478076 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147000264 75 Bergen County Technical High School - Paramus   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478077 2478077 NJ Bergen 3 school 3401470 290   Bergen County Vocational Technical School District 340147003341 300 Applied Technology High School   Career and Technical School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478078 2478078 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000268 20 Bergenfield High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478081 2478081 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000274 60 Jefferson Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478083 2478083 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000278 75 Roy W. Brown Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478084 2478084 NJ Bergen 3 school 3401500 300   Bergenfield Boro 340150000280 80 Washington Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478085 2478085 NJ Bergen 3 school 3401920 440   Bogota Boro 340192000284 20 Bogota Jr./Sr. High School   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478089 2478089 NJ Bergen 3 school 3402800 745   Carlstadt-East Rutherford 340280000300 50 Henry P. Becton Regional High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478090 2478090 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000304 30 Cliffside Park High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478091 2478091 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000306 50 School #3   Regular School No Elementary PK 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478092 2478092 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000308 60 School #4   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478094 2478094 NJ Bergen 3 school 3403270 890   Cliffside Park Boro 340327000312 80 School #6/Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478096 2478096 NJ Bergen 3 school 3403390 930   Closter Boro 340339000318 60 Tenakill Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478097 2478097 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000324 40 Cresskill High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478098 2478098 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360002993 45 Cresskill Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478099 2478099 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000326 50 Edward H. Bryan   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478100 2478100 NJ Bergen 3 school 3403600 990   Cresskill Boro 340360000328 60 Merritt Memorial   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478102 2478102 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000334 40 Demarest Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478103 2478103 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381006085 50 Luther Lee Emerson School   Regular School No Elementary 02 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478104 2478104 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000340 40 Dumont High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478105 2478105 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000342 50 Grant Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478106 2478106 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000344 60 Honiss Elementary\Middle School   Regular School No Elementary KG 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478107 2478107 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000346 70 Lincoln Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478108 2478108 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000348 80 Selzer Elementary\Middle School   Regular School No Elementary PK 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478109 2478109 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000352 40 Alfred S. Faust   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478111 2478111 NJ Bergen 3 school 3404440 1270   Edgewater Boro 340444000362 50 Eleanor Van Gelder   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478113 2478113 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000368 50 Memorial Senior High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478114 2478114 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000075 60 Memorial Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478115 2478115 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000372 70 Gantner Avenue School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478116 2478116 NJ Bergen 3 school 3404660 1345   Elmwood Park 340466000374 80 Gilbert Avenue School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478118 2478118 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000380 50 Emerson Jr Sr High   Regular School No High 07 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478119 2478119 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000382 60 Patrick M Villano School   Regular School No Elementary 03 06 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478120 2478120 NJ Bergen 3 school 3404710 1360   Emerson Boro 340471000384 70 Memorial School   Regular School No Elementary PK 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478121 2478121 NJ Bergen 3 school 3404740 1370   Englewood City 340474000388 40 Dwight Morrow High School/Academies@Englewood   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478122 2478122 NJ Bergen 3 school 3404740 1370   Englewood City 340474000390 60 Dr. Leroy Mccloud Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478124 2478124 NJ Bergen 3 school 3404740 1370   Englewood City 340474000394 76 Janis E. Dismus Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478125 2478125 NJ Bergen 3 school 3404740 1370   Englewood City 340474003063 86 Dr. John Grieco Elementary School   Regular School No Elementary 01 02 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478127 2478127 NJ Bergen 3 school 3404770 1380   Englewood Cliffs Boro 340477000406 60 Upper School   Regular School No Middle 03 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478128 2478128 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000410 50 Fair Lawn High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478129 2478129 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000053 60 Thomas Jefferson Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478130 2478130 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000414 70 Memorial Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478131 2478131 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000416 80 Henry B. Milnes Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478132 2478132 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000418 85 John A. Forrest Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478133 2478133 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000420 100 Lyncrest Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478134 2478134 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000422 110 Radburn Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478135 2478135 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000426 140 Warren Point Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478136 2478136 NJ Bergen 3 school 3404980 1450   Fair Lawn Public Schools 340498000430 160 Westmoreland Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478137 2478137 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000436 60 Lincoln School   Regular School No Middle 05 08 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478139 2478139 NJ Bergen 3 school 3405070 1470   Fairview Boro 340507000438 80 Number Three School   Regular School No Elementary KG 04 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478140 2478140 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000442 50 Fort Lee High School   Regular School No High 09 12 2020   pre_kindergarten_half_day                                                   0.0                                             0
2478141 2478141 NJ Bergen 3 school 3405310 1550   Fort Lee Boro 340531000444 60 School No. 1   Regular School No Elementary KG 04 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]);