enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 2,502 ✖

grade ✖

  • kindergarten_half_day · 2,502 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id ▼ district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2482996 2482996 NJ Atlantic 1 school 3400660 10   Absecon City 340066000004 50 Emma C Attales   Regular School No Middle 05 08 2020   kindergarten_half_day                                                   0.0                                             0
2482997 2482997 NJ Atlantic 1 school 3400660 10   Absecon City 340066000006 60 H Ashton Marsh   Regular School No Elementary PK 04 2020   kindergarten_half_day                                                   0.0                                             0
2484447 2484447 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003732 10 Asbury Park High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2484448 2484448 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003301 20 Barack Obama Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484449 2484449 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003740 40 Bradley Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484450 2484450 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093003742 70 Dr. Martin Luther King Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2484451 2484451 NJ Monmouth 25 school 3400930 100   Asbury Park City 340093000157 100 Thurgood Marshall Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484461 2484461 NJ Monmouth 25 school 3403630 1000   Deal Boro 340363003764 40 Deal Elementary School   Regular School No Elementary KG 08 2020   kindergarten_half_day                                                   0.0                                             0
2483667 2483667 NJ Cumberland 11 school 3403660 1020   Deerfield Twp 340366001826 40 Deerfield Township School District   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483372 2483372 NJ Burlington 5 school 3403690 1030   Delanco Twp 340369001032 30 M. Joan Pearson Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2483373 2483373 NJ Burlington 5 school 3403690 1030   Delanco Twp 340369001036 60 Walnut Street School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2484126 2484126 NJ Hunterdon 19 school 3403720 1040   Delaware Twp 340372002974 40 Delaware Township School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2484127 2484127 NJ Hunterdon 19 school 3403750 1050   Delaware Valley Regional 340375002978 40 Delaware Valley Regional High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483374 2483374 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001040 5 Delran High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483375 2483375 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001042 7 Delran Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2483376 2483376 NJ Burlington 5 school 3403780 1060   Delran Twp 340378000123 15 Delran Intermediate School   Regular School No Elementary 03 05 2020   kindergarten_half_day                                                   0.0                                             0
2483377 2483377 NJ Burlington 5 school 3403780 1060   Delran Twp 340378001050 50 Millbridge Elementary School   Regular School No Elementary PK 02 2020   kindergarten_half_day                                                   0.0                                             0
2483105 2483105 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000332 30 County Road School   Regular School No Elementary PK 01 2020   kindergarten_half_day                                                   0.0                                             0
2483106 2483106 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381000334 40 Demarest Middle School   Regular School No Middle 05 08 2020   kindergarten_half_day                                                   0.0                                             0
2483107 2483107 NJ Bergen 3 school 3403810 1070   Demarest Boro 340381006085 50 Luther Lee Emerson School   Regular School No Elementary 02 04 2020   kindergarten_half_day                                                   0.0                                             0
2483629 2483629 NJ Cape May 9 school 3403840 1080   Dennis Twp 340384001716 40 Dennis Township Primary School   Regular School No Elementary PK 03 2020   kindergarten_half_day                                                   0.0                                             0
2483630 2483630 NJ Cape May 9 school 3403840 1080   Dennis Twp 340384006115 50 Dennis Township Elementary/Middle Schools   Regular School No Middle 04 08 2020   kindergarten_half_day                                                   0.0                                             0
2484646 2484646 NJ Morris 27 school 3403870 1090   Denville Twp 340387004202 50 Lakeview Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484647 2484647 NJ Morris 27 school 3403870 1090   Denville Twp 340387004206 70 Riverview Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2484648 2484648 NJ Morris 27 school 3403870 1090   Denville Twp 340387004208 80 Valleyview Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2482998 2482998 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000010 10 Atlantic City High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2482999 2482999 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000012 30 Sovereign Avenue School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483000 2483000 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000016 50 Chelsea Heights School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483001 2483001 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000018 60 Texas Avenue School   Regular School No Elementary KG 08 2020   kindergarten_half_day                                                   0.0                                             0
2483002 2483002 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000020 70 New York Avenue School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483003 2483003 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000022 80 Uptown School Complex   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483004 2483004 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000026 100 Pennsylvania Ave School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483005 2483005 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000028 120 Richmond Avenue School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483006 2483006 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000030 130 Venice Park School   Regular School No Prekindergarten PK PK 2020   kindergarten_half_day                                                   0.0                                             0
2483007 2483007 NJ Atlantic 1 school 3400960 110   Atlantic City 340096000032 140 Dr Martin Luther King Jr School Complex   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483008 2483008 NJ Atlantic 1 school 3400960 110   Atlantic City 340096003259 300 Brighton Avenue School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483921 2483921 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390000708 30 Central Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_half_day                                                   0.0                                             0
2483922 2483922 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002512 40 Deptford Township High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483923 2483923 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002514 45 Monongahela Middle School   Regular School No Middle 07 08 2020   kindergarten_half_day                                                   0.0                                             0
2483924 2483924 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002518 90 Good Intent Elementary School   Regular School No Elementary 02 06 2020   kindergarten_half_day                                                   0.0                                             0
2483925 2483925 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002520 105 Lake Tract Elementary School   Regular School No Elementary 02 06 2020   kindergarten_half_day                                                   0.0                                             0
2483926 2483926 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002524 120 Oak Valley Elementary School   Regular School No Elementary 02 06 2020   kindergarten_half_day                                                   0.0                                             0
2483927 2483927 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002526 130 Pine Acres Early Childhood Center   Regular School No Elementary PK 01 2020   kindergarten_half_day                                                   0.0                                             0
2483928 2483928 NJ Gloucester 15 school 3403900 1100   Deptford Twp 340390002528 140 Shady Lane Elementary School   Regular School No Elementary 02 06 2020   kindergarten_half_day                                                   0.0                                             0
2484649 2484649 NJ Morris 27 school 3403930 1110   Dover Town 340393004212 40 Dover High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2484650 2484650 NJ Morris 27 school 3403930 1110   Dover Town 340393004214 50 Academy Street Elementary School   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2484651 2484651 NJ Morris 27 school 3403930 1110   Dover Town 340393004216 60 East Dover Elementary School   Regular School No Elementary KG 06 2020   kindergarten_half_day                                                   0.0                                             0
2484652 2484652 NJ Morris 27 school 3403930 1110   Dover Town 340393000005 65 Dover Middle School   Regular School No Middle 07 08 2020   kindergarten_half_day                                                   0.0                                             0
2484653 2484653 NJ Morris 27 school 3403930 1110   Dover Town 340393004220 70 North Dover Elementary School   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2483668 2483668 NJ Cumberland 11 school 3403960 1120   Downe Twp 340396001832 45 Downe Township Elementary School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483108 2483108 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000340 40 Dumont High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483109 2483109 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000342 50 Grant Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2483110 2483110 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000344 60 Honiss Elementary\Middle School   Regular School No Elementary KG 08 2020   kindergarten_half_day                                                   0.0                                             0
2483111 2483111 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000346 70 Lincoln Elementary School   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2483112 2483112 NJ Bergen 3 school 3403990 1130   Dumont Boro 340399000348 80 Selzer Elementary\Middle School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2484264 2484264 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402003286 40 Dunellen High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2484265 2484265 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402003288 50 John P. Faber Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484266 2484266 NJ Middlesex 23 school 3404020 1140   Dunellen Boro 340402000149 60 Lincoln Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2484809 2484809 NJ Ocean 29 school 3404050 1150   Eagleswood Twp 340405004606 20 Eagleswood Elementary School   Regular School No Elementary PK 06 2020   kindergarten_half_day                                                   0.0                                             0
2484128 2484128 NJ Hunterdon 19 school 3404080 1160   East Amwell Twp 340408002980 50 East Amwell Township   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2484267 2484267 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003294 50 East Brunswick High School   Regular School No High 10 12 2020   kindergarten_half_day                                                   0.0                                             0
2484268 2484268 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003296 55 Churchill Jr High School   Regular School No Secondary 08 09 2020   kindergarten_half_day                                                   0.0                                             0
2484269 2484269 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003298 56 Hammarskjold Middle School   Regular School No Middle 06 07 2020   kindergarten_half_day                                                   0.0                                             0
2484270 2484270 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003300 60 Bowne-Munro Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484271 2484271 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003302 70 Central Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484272 2484272 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411005994 90 Irwin Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484273 2484273 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003306 100 Lawrence Brook Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484274 2484274 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003310 120 Memorial Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484275 2484275 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003312 125 Chittick Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484276 2484276 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003314 130 Frost Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2484277 2484277 NJ Middlesex 23 school 3404110 1170   East Brunswick Twp 340411003318 138 Warnsdorfer Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483929 2483929 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000063 20 Jeffrey Clark School   Regular School No Elementary PK 02 2020   kindergarten_half_day                                                   0.0                                             0
2483930 2483930 NJ Gloucester 15 school 3404140 1180   East Greenwich Twp 340414000007 45 Samuel Mickle School   Regular School No Elementary 03 06 2020   kindergarten_half_day                                                   0.0                                             0
2484654 2484654 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004224 30 Central Elementary School   Regular School No Elementary 03 05 2020   kindergarten_half_day                                                   0.0                                             0
2484655 2484655 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004226 35 Frank J Smith Elementary   Regular School No Elementary KG 02 2020   kindergarten_half_day                                                   0.0                                             0
2484656 2484656 NJ Morris 27 school 3404170 1190   East Hanover Twp 340417004230 50 East Hanover Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2483009 2483009 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099000034 10 Atlantic County Institute Of Technology   Career and Technical School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483010 2483010 NJ Atlantic 1 school 3400990 120   Atlantic Co Vocational 340099003175 300 Atlantic County Alternative High School   Alternative School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2484014 2484014 NJ Hudson 17 school 3404200 1200   East Newark Boro 340420002732 50 East Newark Public School   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483732 2483732 NJ Essex 13 school 3404230 1210   East Orange 340423002040 30 East Orange Stem Academy High School   Regular School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2483733 2483733 NJ Essex 13 school 3404230 1210   East Orange 340423000494 35 East Orange Campus High School   Regular School No High 09 12 2020   kindergarten_half_day                                                   0.0                                             0
2483734 2483734 NJ Essex 13 school 3404230 1210   East Orange 340423002044 50 Edward T. Bowser Sr. School Of Excellence   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483735 2483735 NJ Essex 13 school 3404230 1210   East Orange 340423002046 60 George Washington Carver Institute   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483736 2483736 NJ Essex 13 school 3404230 1210   East Orange 340423005930 70 John L. Costley Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2483737 2483737 NJ Essex 13 school 3404230 1210   East Orange 340423002048 80 Langston Hughes Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483738 2483738 NJ Essex 13 school 3404230 1210   East Orange 340423002050 90 Whitney E. Houston Academy   Regular School No Elementary PK 08 2020   kindergarten_half_day                                                   0.0                                             0
2483739 2483739 NJ Essex 13 school 3404230 1210   East Orange 340423000273 93 Benjamin Banneker Academy   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483740 2483740 NJ Essex 13 school 3404230 1210   East Orange 340423005931 95 Patrick F. Healy Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2483741 2483741 NJ Essex 13 school 3404230 1210   East Orange 340423002052 100 Mildred Barry Garvin Elementary   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483742 2483742 NJ Essex 13 school 3404230 1210   East Orange 340423000275 107 Althea Gibson Academy   Regular School No Elementary PK KG 2020   kindergarten_half_day                                                   0.0                                             0
2483743 2483743 NJ Essex 13 school 3404230 1210   East Orange 340423002054 110 Dionne Warwick Institute   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483744 2483744 NJ Essex 13 school 3404230 1210   East Orange 340423002058 120 Ecole Toussaint Louverture   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483745 2483745 NJ Essex 13 school 3404230 1210   East Orange 340423002060 130 Gordon Parks Academy   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483746 2483746 NJ Essex 13 school 3404230 1210   East Orange 340423005932 135 Sojourner Truth Middle School   Regular School No Middle 06 08 2020   kindergarten_half_day                                                   0.0                                             0
2483747 2483747 NJ Essex 13 school 3404230 1210   East Orange 340423002062 140 Cicely L. Tyson Community Elementary School   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483748 2483748 NJ Essex 13 school 3404230 1210   East Orange 340423002064 150 Cicely L. Tyson Community Middle/High School   Regular School No High 06 12 2020   kindergarten_half_day                                                   0.0                                             0
2483749 2483749 NJ Essex 13 school 3404230 1210   East Orange 340423005901 170 J. Garfield Jackson Sr. Academy   Regular School No Elementary PK 05 2020   kindergarten_half_day                                                   0.0                                             0
2483750 2483750 NJ Essex 13 school 3404230 1210   East Orange 340423000134 190 Johnnie L. Cochran Jr. Academy   Regular School No Elementary KG 05 2020   kindergarten_half_day                                                   0.0                                             0
2483751 2483751 NJ Essex 13 school 3404230 1210   East Orange 340423000381 210 Wahlstrom Early Childhood Academy   Regular School No Elementary PK KG 2020   kindergarten_half_day                                                   0.0                                             0
2483113 2483113 NJ Bergen 3 school 3404290 1230   East Rutherford Boro 340429000352 40 Alfred S. Faust   Regular School No Middle 05 08 2020   kindergarten_half_day                                                   0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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