enrollments

Data source: Big Local News · About: Big Local

90,126 rows where state = "NJ" sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
2475853 2475853 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244000982 30 Westampton Campus   Special Education School No Other PK 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475854 2475854 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244000121 55 Lumberton Campus   Special Education School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475855 2475855 NJ Burlington 5 school 3402490 610   Burlington Co Vocational 340249000996 30 Burlington County Institute Of Technology - Westampton   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475856 2475856 NJ Burlington 5 school 3402490 610   Burlington Co Vocational 340249000998 40 Burlington County Institute Of Technology - Medford   Career and Technical School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475857 2475857 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001004 10 Burlington Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475859 2475859 NJ Burlington 5 school 3402460 620   Burlington Twp 340246000260 37 Fountain Woods Elementary School   Regular School No Elementary 02 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475860 2475860 NJ Burlington 5 school 3402460 620   Burlington Twp 340246002939 51 Burlington Township Middle School At Springside   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475862 2475862 NJ Burlington 5 school 3403120 840   Cinnaminson Twp 340312001020 30 Cinnaminson High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475863 2475863 NJ Burlington 5 school 3403120 840   Cinnaminson Twp 340312001024 53 Cinnaminson Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475865 2475865 NJ Burlington 5 school 3403120 840   Cinnaminson Twp 340312001028 60 Eleanor Rush Intermediate School   Regular School No Elementary 03 05 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
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
2475872 2475872 NJ Burlington 5 school 3404350 1250   Eastampton Twp 340435001056 60 Eastampton Township Community School   Regular School No Elementary KG 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475874 2475874 NJ Burlington 5 school 3404470 1280   Edgewater Park Twp 340447001064 70 Samuel M Ridgway Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475875 2475875 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489000056 30 Frances Demasi Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475876 2475876 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489000057 40 Frances Demasi Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475877 2475877 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489001070 55 Helen L Beeler   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475878 2475878 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489001072 57 J Harold Van Zant   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475879 2475879 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489000058 58 Marlton Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475880 2475880 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489001074 60 Marlton Middle   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475882 2475882 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489001076 70 Robert B Jaggard School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475883 2475883 NJ Burlington 5 school 3405220 1520   Florence Twp 340522001082 50 Florence Township Memorial High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475884 2475884 NJ Burlington 5 school 3405220 1520   Florence Twp 340522006066 55 Florence Riverfront School   Regular School No Middle 04 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475887 2475887 NJ Burlington 5 school 3408490 2610   Lenape Regional 340849001092 40 Cherokee High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475888 2475888 NJ Burlington 5 school 3408490 2610   Lenape Regional 340849001094 50 Lenape High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475889 2475889 NJ Burlington 5 school 3408490 2610   Lenape Regional 340849001096 60 Shawnee High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475890 2475890 NJ Burlington 5 school 3408490 2610   Lenape Regional 340849000701 70 Seneca High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475891 2475891 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918000222 20 Bobby'S Run Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475892 2475892 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918001098 50 Florence L. Walther School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475893 2475893 NJ Burlington 5 school 3409180 2850   Lumberton Twp 340918006092 60 Lumberton Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475894 2475894 NJ Burlington 5 school 3409510 2960   Mansfield Twp 340951001100 30 John Hydock Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475895 2475895 NJ Burlington 5 school 3409510 2960   Mansfield Twp 340951000704 40 Mansfield Township Elementary School   Regular School No Elementary 03 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475896 2475896 NJ Burlington 5 school 3409660 3010   Maple Shade Twp 340966001104 30 Maple Shade High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475897 2475897 NJ Burlington 5 school 3409660 3010   Maple Shade Twp 340966001106 80 Maude M. Wilkins Elementary School   Regular School No Elementary 03 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475898 2475898 NJ Burlington 5 school 3409660 3010   Maple Shade Twp 340966001108 90 Howard R. Yocum Elementary School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475899 2475899 NJ Burlington 5 school 3409660 3010   Maple Shade Twp 340966001110 100 Ralph J. Steinhauer Elementary School   Regular School No Middle 05 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475900 2475900 NJ Burlington 5 school 3409840 3070   Medford Lakes Boro 340984001114 40 Neeta School   Regular School No Middle 03 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475902 2475902 NJ Burlington 5 school 3409870 3080   Medford Twp 340987006113 30 Chairville Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475903 2475903 NJ Burlington 5 school 3409870 3080   Medford Twp 340987001120 40 Cranberry Pines Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475905 2475905 NJ Burlington 5 school 3409870 3080   Medford Twp 340987001122 50 Haines Sixth Grade Center   Regular School No Middle 06 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475906 2475906 NJ Burlington 5 school 3409870 3080   Medford Twp 340987001124 55 Medford Memorial Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475907 2475907 NJ Burlington 5 school 3409870 3080   Medford Twp 340987001126 60 Milton H. Allen Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475908 2475908 NJ Burlington 5 school 3409870 3080   Medford Twp 340987001128 70 Taunton Forge Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475909 2475909 NJ Burlington 5 school 3410710 3360   Moorestown Twp 341071001132 40 Moorestown High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475910 2475910 NJ Burlington 5 school 3410710 3360   Moorestown Twp 341071001134 60 George C. Baker Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475912 2475912 NJ Burlington 5 school 3410710 3360   Moorestown Twp 341071001140 110 William Allen Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475913 2475913 NJ Burlington 5 school 3410710 3360   Moorestown Twp 341071000421 115 Moorestown Upper Elementary School   Regular School No Middle 04 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475916 2475916 NJ Burlington 5 school 3410920 3430   Mount Holly Twp 341092001150 50 Gertrude C. Folwell Elementary School   Regular School No Elementary 02 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475917 2475917 NJ Burlington 5 school 3410920 3430   Mount Holly Twp 341092001152 60 F. W. Holbein Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475919 2475919 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095001158 45 Fleetwood Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475920 2475920 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095000125 47 Hartford Upper Elementary School   Regular School No Middle 05 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475921 2475921 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095001160 50 Hillside Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475923 2475923 NJ Burlington 5 school 3410950 3440   Mount Laurel Twp 341095001164 60 T. E. Harrington Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475926 2475926 NJ Burlington 5 school 3411250 3540   New Hanover Twp 341125001168 50 New Hanover Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475927 2475927 NJ Burlington 5 school 3411580 3650   North Hanover Twp 341158002943 36 North Hanover Township Upper Elementary School   Regular School No Middle 05 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475928 2475928 NJ Burlington 5 school 3411580 3650   North Hanover Twp 341158001178 40 Clarence B. Lamb Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475929 2475929 NJ Burlington 5 school 3411580 3650   North Hanover Twp 341158003470 300 Endeavour Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475930 2475930 NJ Burlington 5 school 3411700 3690   Northern Burlington Reg 341170001182 50 Northern Burlington County Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475931 2475931 NJ Burlington 5 school 3411700 3690   Northern Burlington Reg 341170001184 60 Northern Burlington County Regional Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475932 2475932 NJ Burlington 5 school 3412390 3920   Palmyra Boro 341239001188 50 Palmyra High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475934 2475934 NJ Burlington 5 school 3412390 3920   Palmyra Boro 341239003483 300 Palmyra Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475935 2475935 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001200 50 Helen A. Fort Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475936 2475936 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001202 55 Pemberton Township High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475937 2475937 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001208 85 Howard L. Emmons   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475938 2475938 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001210 90 Harker-Wylie School   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475939 2475939 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001216 110 Fort Dix Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475940 2475940 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001220 130 Alexander Denbo   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475941 2475941 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001222 135 Samuel T. Busansky School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475942 2475942 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281001224 140 Joseph S. Stackhouse School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475943 2475943 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003167 300 Pemberton Early Childhood Education Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475944 2475944 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003399 301 Isaiah Haines   Regular School No Elementary KG 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475945 2475945 NJ Burlington 5 school 3412810 4050   Pemberton Twp 341281003398 302 Marcus Newcomb Middle School   Regular School No Middle 06 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475946 2475946 NJ Burlington 5 school 3413620 4320   Rancocas Valley Regional 341362001230 50 Rancocas Valley Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475947 2475947 NJ Burlington 5 school 3414010 4450   Riverside Twp 341401001234 50 Riverside High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475949 2475949 NJ Burlington 5 school 3414010 4450   Riverside Twp 341401000085 70 Riverside Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475952 2475952 NJ Burlington 5 school 3414880 4740   Shamong Twp 341488006103 55 Indian Mills Memorial School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475953 2475953 NJ Burlington 5 school 3415420 4930   Southampton Township School District 341542001242 50 Southampton Township School #1   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475954 2475954 NJ Burlington 5 school 3415420 4930   Southampton Township School District 341542006035 60 Southampton Township School #2   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475955 2475955 NJ Burlington 5 school 3415420 4930   Southampton Township School District 341542000127 70 Southampton Township School #3   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475957 2475957 NJ Burlington 5 school 3416020 5130   Tabernacle Twp 341602005946 40 Kenneth R. Olson Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475960 2475960 NJ Burlington 5 school 3417730 5720   Westampton 341773001258 50 Westampton Township Middle School   Regular School No Middle 04 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475961 2475961 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800001264 53 Willingboro High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475962 2475962 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800006108 57 Willingboro Memorial Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475963 2475963 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800001276 65 Hawthorne Park Elementary School   Regular School No Elementary 01 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475964 2475964 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800001282 80 W. R. James Sr. Elementary School   Regular School No Elementary 01 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475965 2475965 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800001288 120 Twin Hills Elementary School   Regular School No Elementary 01 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475966 2475966 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003421 300 Alternative School At Levitt   Alternative School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475967 2475967 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003463 301 Levitt Intermediate School   Regular School No Middle 05 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475968 2475968 NJ Burlington 5 school 3418000 5805   Willingboro Twp 341800003459 302 J. C. Stuart Early Childhood Development Center   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475969 2475969 NJ Burlington 5 school 3418240 5890   Woodland Twp 341824001294 30 Chatsworth Elementary School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475970 2475970 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001298 10 Audubon Junior/Senior High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475972 2475972 NJ Camden 7 school 3401050 150   Audubon Public School Disrict 340105001302 50 Mansion Avenue School   Regular School No Elementary 03 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475974 2475974 NJ Camden 7 school 3401170 190   Barrington Boro 340117001312 30 Woodland Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475975 2475975 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001316 15 Bell Oaks Upper Elementary School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475976 2475976 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001318 20 Bellmawr Park Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475977 2475977 NJ Camden 7 school 3401380 260   Bellmawr Boro 340138001320 30 Ethel M Burke Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475979 2475979 NJ Camden 7 school 3401620 340   Berlin Twp 340162001328 30 Dwight D Eisenhower Middle School   Regular School No Middle 04 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]);