enrollments

Data source: Big Local News · About: Big Local

2,502 rows where grade = "pre_kindergarten_full_day", state = "NJ" and year = 2020 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • pre_kindergarten_full_day · 2,502 ✖
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
2475490 2475490 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475491 2475491 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476941 2476941 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003732 10 Asbury Park High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476942 2476942 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476943 2476943 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476944 2476944 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003742 70 Dr. Martin Luther King Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476945 2476945 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476955 2476955 NJ Monmouth 25 school 3403630 1000   Deal Boro 340363003764 40 Deal Elementary School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476161 2476161 NJ Cumberland 11 school 3403660 1020   Deerfield Twp 340366001826 40 Deerfield Township School District   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475866 2475866 NJ Burlington 5 school 3403690 1030   Delanco Twp 340369001032 30 M. Joan Pearson Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475867 2475867 NJ Burlington 5 school 3403690 1030   Delanco Twp 340369001036 60 Walnut Street School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476620 2476620 NJ Hunterdon 19 school 3403720 1040   Delaware Twp 340372002974 40 Delaware Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476621 2476621 NJ Hunterdon 19 school 3403750 1050   Delaware Valley Regional 340375002978 40 Delaware Valley Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475868 2475868 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001040 5 Delran High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475869 2475869 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001042 7 Delran Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475870 2475870 NJ Burlington 5 school 3403780 1060   Delran Twp 340378000123 15 Delran Intermediate School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475871 2475871 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001050 50 Millbridge Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   65.0                                             65
2475599 2475599 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000332 30 County Road School   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475600 2475600 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000334 40 Demarest Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475601 2475601 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381006085 50 Luther Lee Emerson School   Regular School No Elementary 02 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476123 2476123 NJ Cape May 9 school 3403840 1080   Dennis Twp 340384001716 40 Dennis Township Primary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476124 2476124 NJ Cape May 9 school 3403840 1080   Dennis Twp 340384006115 50 Dennis Township Elementary/Middle Schools   Regular School No Middle 04 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477140 2477140 NJ Morris 27 school 3403870 1090   Denville Twp 340387004202 50 Lakeview Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   41.0                                             41
2477141 2477141 NJ Morris 27 school 3403870 1090   Denville Twp 340387004206 70 Riverview Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477142 2477142 NJ Morris 27 school 3403870 1090   Denville Twp 340387004208 80 Valleyview Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475492 2475492 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475493 2475493 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000012 30 Sovereign Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475494 2475494 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000016 50 Chelsea Heights School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475495 2475495 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000018 60 Texas Avenue School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475496 2475496 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000020 70 New York Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475497 2475497 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000022 80 Uptown School Complex   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475498 2475498 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000026 100 Pennsylvania Ave School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475499 2475499 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000028 120 Richmond Avenue School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475500 2475500 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475501 2475501 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000032 140 Dr Martin Luther King Jr School Complex   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475502 2475502 NJ Atlantic 1 school 3400960 110   Atlantic City 340096003259 300 Brighton Avenue School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476415 2476415 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390000708 30 Central Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   122.0                                             122
2476416 2476416 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002512 40 Deptford Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476417 2476417 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002514 45 Monongahela Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476418 2476418 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002518 90 Good Intent Elementary School   Regular School No Elementary 02 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476419 2476419 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002520 105 Lake Tract Elementary School   Regular School No Elementary 02 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476420 2476420 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002524 120 Oak Valley Elementary School   Regular School No Elementary 02 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476421 2476421 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002526 130 Pine Acres Early Childhood Center   Regular School No Elementary PK 01 2020   pre_kindergarten_full_day                                                   58.0                                             58
2476422 2476422 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002528 140 Shady Lane Elementary School   Regular School No Elementary 02 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477143 2477143 NJ Morris 27 school 3403930 1110   Dover Town 340393004212 40 Dover High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477144 2477144 NJ Morris 27 school 3403930 1110   Dover Town 340393004214 50 Academy Street Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   8.0                                             8
2477145 2477145 NJ Morris 27 school 3403930 1110   Dover Town 340393004216 60 East Dover Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477146 2477146 NJ Morris 27 school 3403930 1110   Dover Town 340393000005 65 Dover Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477147 2477147 NJ Morris 27 school 3403930 1110   Dover Town 340393004220 70 North Dover Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476162 2476162 NJ Cumberland 11 school 3403960 1120   Downe Twp 340396001832 45 Downe Township Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475602 2475602 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000340 40 Dumont High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475603 2475603 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000342 50 Grant Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475604 2475604 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000344 60 Honiss Elementary\Middle School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475605 2475605 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000346 70 Lincoln Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475606 2475606 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000348 80 Selzer Elementary\Middle School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   46.0                                             46
2476758 2476758 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402003286 40 Dunellen High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476759 2476759 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402003288 50 John P. Faber Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476760 2476760 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402000149 60 Lincoln Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477303 2477303 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476622 2476622 NJ Hunterdon 19 school 3404080 1160   East Amwell Twp 340408002980 50 East Amwell Township   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   8.0                                             8
2476761 2476761 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003294 50 East Brunswick High School   Regular School No High 10 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476762 2476762 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003296 55 Churchill Jr High School   Regular School No Secondary 08 09 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476763 2476763 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003298 56 Hammarskjold Middle School   Regular School No Middle 06 07 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476764 2476764 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003300 60 Bowne-Munro Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   16.0                                             16
2476765 2476765 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003302 70 Central Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   19.0                                             19
2476766 2476766 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411005994 90 Irwin Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476767 2476767 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003306 100 Lawrence Brook Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476768 2476768 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003310 120 Memorial Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476769 2476769 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003312 125 Chittick Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   12.0                                             12
2476770 2476770 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003314 130 Frost Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476771 2476771 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003318 138 Warnsdorfer Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   45.0                                             45
2476423 2476423 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2476424 2476424 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000007 45 Samuel Mickle School   Regular School No Elementary 03 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477148 2477148 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004224 30 Central Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   30.0                                             30
2477149 2477149 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004226 35 Frank J Smith Elementary   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2477150 2477150 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004230 50 East Hanover Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475503 2475503 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_full_day                                                   0.0                                             0
2475504 2475504 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_full_day                                                   0.0                                             0
2476508 2476508 NJ Hudson 17 school 3404200 1200   East Newark Boro 340420002732 50 East Newark Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   34.0                                             34
2476226 2476226 NJ Essex 13 school 3404230 1210   East Orange 340423002040 30 East Orange Stem Academy High School   Regular School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476227 2476227 NJ Essex 13 school 3404230 1210   East Orange 340423000494 35 East Orange Campus High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476228 2476228 NJ Essex 13 school 3404230 1210   East Orange 340423002044 50 Edward T. Bowser Sr. School Of Excellence   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476229 2476229 NJ Essex 13 school 3404230 1210   East Orange 340423002046 60 George Washington Carver Institute   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476230 2476230 NJ Essex 13 school 3404230 1210   East Orange 340423005930 70 John L. Costley Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476231 2476231 NJ Essex 13 school 3404230 1210   East Orange 340423002048 80 Langston Hughes Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476232 2476232 NJ Essex 13 school 3404230 1210   East Orange 340423002050 90 Whitney E. Houston Academy   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476233 2476233 NJ Essex 13 school 3404230 1210   East Orange 340423000273 93 Benjamin Banneker Academy   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476234 2476234 NJ Essex 13 school 3404230 1210   East Orange 340423005931 95 Patrick F. Healy Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476235 2476235 NJ Essex 13 school 3404230 1210   East Orange 340423002052 100 Mildred Barry Garvin Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476236 2476236 NJ Essex 13 school 3404230 1210   East Orange 340423000275 107 Althea Gibson Academy   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476237 2476237 NJ Essex 13 school 3404230 1210   East Orange 340423002054 110 Dionne Warwick Institute   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476238 2476238 NJ Essex 13 school 3404230 1210   East Orange 340423002058 120 Ecole Toussaint Louverture   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476239 2476239 NJ Essex 13 school 3404230 1210   East Orange 340423002060 130 Gordon Parks Academy   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476240 2476240 NJ Essex 13 school 3404230 1210   East Orange 340423005932 135 Sojourner Truth Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476241 2476241 NJ Essex 13 school 3404230 1210   East Orange 340423002062 140 Cicely L. Tyson Community Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476242 2476242 NJ Essex 13 school 3404230 1210   East Orange 340423002064 150 Cicely L. Tyson Community Middle/High School   Regular School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476243 2476243 NJ Essex 13 school 3404230 1210   East Orange 340423005901 170 J. Garfield Jackson Sr. Academy   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476244 2476244 NJ Essex 13 school 3404230 1210   East Orange 340423000134 190 Johnnie L. Cochran Jr. Academy   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2476245 2476245 NJ Essex 13 school 3404230 1210   East Orange 340423000381 210 Wahlstrom Early Childhood Academy   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475607 2475607 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000352 40 Alfred S. Faust   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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