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
2475730 2475730 NJ Bergen 3 school 3411850 3740   Norwood Boro 341185000660 20 Norwood Public School   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475731 2475731 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000664 40 Dogwood Hill Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475733 2475733 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000668 60 Manito Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475734 2475734 NJ Bergen 3 school 3411910 3760   Oakland Boro 341191000670 80 Valley Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475735 2475735 NJ Bergen 3 school 3412180 3850   Old Tappan Boro 341218000674 30 Charles Dewolf Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475736 2475736 NJ Bergen 3 school 3412180 3850   Old Tappan Boro 341218000676 60 T. Baldwin Demarest Elementary School   Regular School No Elementary PK 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475738 2475738 NJ Bergen 3 school 3412360 3910   Palisades Park 341236000682 50 Palisades Park Jr-Sr High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475739 2475739 NJ Bergen 3 school 3412360 3910   Palisades Park 341236000684 70 Lindbergh Elementary School   Regular School No Elementary 01 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475742 2475742 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000690 60 West Brook Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475743 2475743 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000692 65 East Brook Middle School   Regular School No Middle 05 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475744 2475744 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000696 80 Memorial Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475745 2475745 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000400 90 Midland Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475747 2475747 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000702 110 Ridge Ranch Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475748 2475748 NJ Bergen 3 school 3412420 3930   Paramus Boro 341242000706 130 Stony Lane Elementary School   Regular School No Elementary KG 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475749 2475749 NJ Bergen 3 school 3412450 3940   Park Ridge Boro 341245000710 50 Park Ridge High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475750 2475750 NJ Bergen 3 school 3412450 3940   Park Ridge Boro 341245000712 60 East Brook Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475752 2475752 NJ Bergen 3 school 3412510 3960   Pascack Valley Regional 341251000718 40 Pascack Hills High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475753 2475753 NJ Bergen 3 school 3412510 3960   Pascack Valley Regional 341251000720 50 Pascack Valley High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475754 2475754 NJ Bergen 3 school 3413560 4300   Ramapo-Indian Hill Reg 341356000724 30 Indian Hills High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475755 2475755 NJ Bergen 3 school 3413560 4300   Ramapo-Indian Hill Reg 341356000726 50 Ramapo High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475756 2475756 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000730 50 Ramsey High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475757 2475757 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000732 55 Eric S. Smith Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475758 2475758 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000734 60 John Y Dater Elementary School   Regular School No Elementary 04 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475760 2475760 NJ Bergen 3 school 3413590 4310   Ramsey Boro 341359000738 80 Wesley D Tisdale Elementary School   Regular School No Elementary PK 03 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475761 2475761 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377000742 50 Ridgefield Memorial High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475762 2475762 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377006057 65 Bergen Boulevard School   Regular School No Elementary 01 04 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475764 2475764 NJ Bergen 3 school 3413770 4370   Ridgefield Boro 341377000750 100 Slocum Skewes School   Regular School No Other 01 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475765 2475765 NJ Bergen 3 school 3413800 4380   Ridgefield Park Twp 341380000754 50 Ridgefield Park Jr Sr High School   Regular School No High 07 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475766 2475766 NJ Bergen 3 school 3413800 4380   Ridgefield Park Twp 341380000756 60 Grant Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475768 2475768 NJ Bergen 3 school 3413800 4380   Ridgefield Park Twp 341380000760 80 Roosevelt Elementary School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475769 2475769 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000764 50 Ridgewood High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475770 2475770 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000766 60 Benjamin Franklin Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475771 2475771 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000768 70 George Washington Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475772 2475772 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000221 80 Glen School   Special Education School No Prekindergarten PK PK 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475773 2475773 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000772 85 Hawes Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475774 2475774 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000774 90 Ridge Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475775 2475775 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000776 100 Somerville Elementary School   Regular School No Elementary PK 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475776 2475776 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000778 110 Travell Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475777 2475777 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000780 120 Orchard Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475778 2475778 NJ Bergen 3 school 3413830 4390   Ridgewood Village 341383000782 130 Willard Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475779 2475779 NJ Bergen 3 school 3412260 4405   River Dell Regional 341226000786 50 River Dell Regional High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475780 2475780 NJ Bergen 3 school 3412260 4405   River Dell Regional 341226000788 60 River Dell Middle School   Regular School No Middle 07 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475782 2475782 NJ Bergen 3 school 3413890 4410   River Edge Boro 341389000794 50 Roosevelt School   Regular School No Elementary KG 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475783 2475783 NJ Bergen 3 school 3413950 4430   River Vale Twp 341395000798 50 Holdrum Middle School   Regular School No Middle 06 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475784 2475784 NJ Bergen 3 school 3413950 4430   River Vale Twp 341395000800 60 Roberge Elementary School   Regular School No Elementary KG 05 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475786 2475786 NJ Bergen 3 school 3414070 4470   Rochelle Park Twp 341407000804 50 Midland School #1   Regular School No Elementary PK 08 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475787 2475787 NJ Bergen 3 school 3414460 4600   Rutherford Boro 341446000810 50 Rutherford High School   Regular School No High 09 12 2020   pre_kindergarten_full_day                                                   0.0                                             0
2475789 2475789 NJ Bergen 3 school 3414460 4600   Rutherford Boro 341446000814 80 Pierrepont School   Regular School No Middle 04 06 2020   pre_kindergarten_full_day                                                   0.0                                             0
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
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
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
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
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
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
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
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
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
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

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