enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2475790 2475790 NJ Bergen 3 school 3414460 4600   Rutherford Boro 341446000818 100 Union School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475791 2475791 NJ Bergen 3 school 3414460 4600   Rutherford Boro 341446000820 110 Washington School   Regular School No Elementary 01 03 2020   pre_kindergarten_full_day                                                   28.0                                             28
2475792 2475792 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000824 50 Saddle Brook Middle/High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475793 2475793 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000826 80 Franklin School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475794 2475794 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000828 85 Helen I. Smith School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475795 2475795 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000830 90 Salome H. Long Memorial School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475796 2475796 NJ Bergen 3 school 3414490 4610   Saddle Brook Twp 341449000119 100 Washington School   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   44.0                                             44
2475797 2475797 NJ Bergen 3 school 3414520 4620   Saddle River Boro 341452000834 50 Wandell School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   7.0                                             7
2475798 2475798 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700578 50 Lodi Ms Hs   Special Education School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475799 2475799 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700081 60 Maywood Campus   Special Education School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   21.0                                             21
2475800 2475800 NJ Bergen 3 school 3400007 4845   South Bergen Jointure Com 340000700083 70 Moonachie Campus   Special Education School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475801 2475801 NJ Bergen 3 school 3415240 4870   South Hackensack Twp 341524000836 50 Memorial School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475802 2475802 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000840 50 Teaneck High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475803 2475803 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000842 60 Benjamin Franklin Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475804 2475804 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000844 70 Thomas Jefferson Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475805 2475805 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000846 80 William Cullen Bryant School   Regular School No Elementary PK KG 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475806 2475806 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000852 110 Nathaniel Hawthorne Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475807 2475807 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000856 130 James Russell Lowell Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475808 2475808 NJ Bergen 3 school 3416080 5150   Teaneck Twp 341608000860 150 John Greenleaf Whittier Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475809 2475809 NJ Bergen 3 school 3416110 5160   Tenafly Boro 341611000864 50 Tenafly High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475810 2475810 NJ Bergen 3 school 3416110 5160   Tenafly Boro 341611000866 70 J Spencer Smith School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475811 2475811 NJ Bergen 3 school 3416110 5160   Tenafly Boro 341611000868 80 Malcolm S Mackay School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475812 2475812 NJ Bergen 3 school 3416110 5160   Tenafly Boro 341611000870 90 Ralph S Maugham School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475813 2475813 NJ Bergen 3 school 3416110 5160   Tenafly Boro 341611000872 95 Tenafly Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475814 2475814 NJ Bergen 3 school 3416110 5160   Tenafly Boro 341611000874 100 Walter Stillman School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   3.0                                             3
2475815 2475815 NJ Bergen 3 school 3416620 5330   Upper Saddle River Boro 341662000880 50 Emil A. Cavallini Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475816 2475816 NJ Bergen 3 school 3416620 5330   Upper Saddle River Boro 341662000882 60 Edith A. Bogert Elementary School   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475817 2475817 NJ Bergen 3 school 3416620 5330   Upper Saddle River Boro 341662000884 70 Robert D Reynolds Primary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   24.0                                             24
2475818 2475818 NJ Bergen 3 school 3416860 5410   Waldwick Boro 341686000888 30 Waldwick High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475819 2475819 NJ Bergen 3 school 3416860 5410   Waldwick Boro 341686000890 40 Crescent Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475820 2475820 NJ Bergen 3 school 3416860 5410   Waldwick Boro 341686000892 50 Julia A Traphagen School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   20.0                                             20
2475821 2475821 NJ Bergen 3 school 3416860 5410   Waldwick Boro 341686000537 70 Waldwick Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475822 2475822 NJ Bergen 3 school 3416920 5430   Wallington Boro 341692000898 50 Wallington Junior Senior High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475823 2475823 NJ Bergen 3 school 3416920 5430   Wallington Boro 341692000900 55 Frank W. Gavlak Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475824 2475824 NJ Bergen 3 school 3416920 5430   Wallington Boro 341692000902 60 Jefferson (Annex) Elementary School   Regular School No Elementary KG 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475825 2475825 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000906 50 Westwood Junior/Senior High School   Regular School No High 08 12 2020   pre_kindergarten_full_day                                                   19.0                                             19
2475826 2475826 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000910 60 Berkeley Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475827 2475827 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000912 62 Westwood Regional Middle School   Regular School No Middle 06 07 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475828 2475828 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000914 65 Jessie F. George Elementary   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475829 2475829 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000916 70 Brookside Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475830 2475830 NJ Bergen 3 school 3417820 5755   Westwood Regional 341782000918 80 Washington Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475831 2475831 NJ Bergen 3 school 3418300 5830   Wood-Ridge Boro 341830000922 50 Wood-Ridge Jr/Sr High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475832 2475832 NJ Bergen 3 school 3418300 5830   Wood-Ridge Boro 341830000924 60 Catherine E. Doyle Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475833 2475833 NJ Bergen 3 school 3418300 5830   Wood-Ridge Boro 341830003257 300 Wood-Ridge Intermediate School   Regular School No Middle 04 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475834 2475834 NJ Bergen 3 school 3418210 5880   Woodcliff Lake Boro 341821000934 30 Dorchester Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   14.0                                             14
2475835 2475835 NJ Bergen 3 school 3418210 5880   Woodcliff Lake Boro 341821000936 50 Woodcliff Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475836 2475836 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000940 10 Abraham Lincoln Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475837 2475837 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000942 20 Calvin Coolidge Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475838 2475838 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000944 25 Dwight D. Eisenhower Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475839 2475839 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000946 30 George Washington Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475840 2475840 NJ Bergen 3 school 3418360 5920   Wyckoff Twp 341836000948 50 Sicomac Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   22.0                                             22
2475841 2475841 NJ Burlington 5 school 3401200 200   Bass River Twp 340120000950 50 Bass River Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   5.0                                             5
2475842 2475842 NJ Burlington 5 school 3401740 380   Beverly City 340174000952 25 Beverly City School District   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475843 2475843 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203000960 50 Bordentown Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475844 2475844 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203000801 55 Bordentown Regional Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475845 2475845 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203005925 60 Clara Barton Elementary   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475846 2475846 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203005926 90 Mac Farland Intermediate   Regular School No Elementary 03 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475847 2475847 NJ Burlington 5 school 3402030 475   Bordentown Regional 340203005927 100 Peter Muschal Elementary   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475848 2475848 NJ Burlington 5 school 3402430 600   Burlington City 340243000966 20 Burlington City High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475849 2475849 NJ Burlington 5 school 3402430 600   Burlington City 340243000968 40 Captain James Lawrence Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475850 2475850 NJ Burlington 5 school 3402430 600   Burlington City 340243000974 80 Samuel Smith Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475851 2475851 NJ Burlington 5 school 3402430 600   Burlington City 340243000976 85 Wilbur Watts Intermediate School   Regular School No Elementary 03 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475852 2475852 NJ Burlington 5 school 3402440 605   Burlington Co Spec Serv 340244003303 11 Burlington County Alternative High School   Alternative School No High 06 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
2475858 2475858 NJ Burlington 5 school 3402460 620   Burlington Twp 340246001010 30 B. Bernice Young Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   7.0                                             7
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
2475861 2475861 NJ Burlington 5 school 3403090 830   Chesterfield Twp 340309001016 25 Chesterfield Township Elementary School   Regular School No Elementary PK 06 2020   pre_kindergarten_full_day                                                   29.0                                             29
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
2475864 2475864 NJ Burlington 5 school 3403120 840   Cinnaminson Twp 340312001026 55 New Albany Elementary School   Regular School No Elementary PK 02 2020   pre_kindergarten_full_day                                                   16.0                                             16
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
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
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
2475873 2475873 NJ Burlington 5 school 3404470 1280   Edgewater Park Twp 340447001062 50 Mildred Magowan Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   25.0                                             25
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
2475881 2475881 NJ Burlington 5 school 3404890 1420   Evesham Twp 340489006065 65 Richard L Rice School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   87.0                                             87
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
2475885 2475885 NJ Burlington 5 school 3405220 1520   Florence Twp 340522001086 70 Roebling Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   37.0                                             37
2475886 2475886 NJ Burlington 5 school 3406420 1910   Hainesport Twp 340642001088 50 Hainesport Township School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   16.0                                             16
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

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]);