enrollments

Data source: Big Local News · About: Big Local

3,371,677 rows sorted by grade

✎ View and edit SQL

This data as json, CSV (advanced)

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
741682 741682 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
741738 741738 MA Hampshire   school 2510920 278   South Hadley 251092001754 2780505 South Hadley High   Regular School No 3 09 12 2015   SP 9 0 0 0   0     0   0                             9 9 0 0 0   0     0   0                       9
741998 741998 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   SP 1 1 5 0   0     0   0                             7 1 1 5 0   0     0   0                       7
742003 742003 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2015   SP 2 4 19 0   1     0   1                             27 2 4 19 0   1     0   1                       27
742008 742008 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
742013 742013 MA Hampden   school 2511130 281   Springfield 251113002742 2810550 Springfield Public Day High School   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
742033 742033 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2015   SP 5 8 16 0   0     0   3                             32 5 8 16 0   0     0   3                       32
742059 742059 MA Middlesex   school 2511220 284   Stoneham 251122002295 2840505 Stoneham High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             1                                             1
742099 742099 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
742168 742168 MA Essex   school 2511430 291   Swampscott 251143001884 2910010 Hadley   Regular School No 1 KG 04 2015   SP * * * *   *     *   *                             1                                             1
742253 742253 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   SP 7 2 3 0   0     0   1                             13 7 2 3 0   0     0   1                       13
742277 742277 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No 3 09 12 2015   SP 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
742331 742331 MA Worcester   school 2511850 304   Uxbridge 251185001938 3040505 Uxbridge High   Regular School No 3 09 12 2015   SP 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
742361 742361 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
742405 742405 MA Norfolk   school 2511970 307   Walpole 251197001964 3070505 Walpole High   Regular School No 3 09 12 2015   SP 5 0 0 0   1     0   0                             6 5 0 0 0   1     0   0                       6
742454 742454 MA Middlesex   school 2512000 308   Waltham 251200001979 3080505 Waltham Sr High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             2                                             2
742469 742469 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2015   SP * * * *   *     *   *                             4                                             4
742493 742493 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No 3 09 12 2015   SP 5 0 1 0   0     0   1                             7 5 0 1 0   0     0   1                       7
742559 742559 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett Jr Sr High School   Regular School No 3 07 12 2015   SP * * * *   *     *   *                             5                                             5
742610 742610 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
742640 742640 MA Worcester   school 2512600 321   Westborough 251260002059 3210505 Westborough High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             2                                             2
742655 742655 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston Junior/Senior High   Regular School No 4 06 12 2015   SP * * * *   *     *   *                             2                                             2
742723 742723 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2015   SP 22 3 2 0   0     0   0                             27 22 3 2 0   0     0   0                       27
742784 742784 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
742835 742835 MA Hampden   school 2512510 332   West Springfield 251251002052 3320505 West Springfield High   Regular School No 3 09 12 2015   SP 10 1 1 0   0     0   0                             12 10 1 1 0   0     0   0                       12
742925 742925 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   SP 6 1 0 0   0     0   0                             7 6 1 0 0   0     0   0                       7
742971 742971 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
743038 743038 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2015   SP * * * *   *     *   *                             1                                             1
743425 743425 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes 4 06 12 2015   SP 0 8 4 0   1     0   0                             13 0 8 4 0   1     0   0                       13
743997 743997 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
744018 744018 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No 3 09 12 2015   SP 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
744045 744045 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No 3 09 12 2015   SP 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
744081 744081 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2015   SP 10 0 0 0   0     0   0                             10 10 0 0 0   0     0   0                       10
744109 744109 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
744133 744133 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2015   SP 7 1 0 0   0     0   0                             8 7 1 0 0   0     0   0                       8
744177 744177 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
744266 744266 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
744300 744300 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2015   SP * * * *   *     *   *                             4                                             4
744321 744321 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             1                                             1
744341 744341 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
744363 744363 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Turners Fall High   Regular School No 3 09 12 2015   SP 7 0 2 0   0     0   0                             9 7 0 2 0   0     0   0                       9
744420 744420 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2015   SP * * * *   *     *   *                             3                                             3
744433 744433 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2015   SP 13 0 0 0   0     0   0                             13 13 0 0 0   0     0   0                       13
744440 744440 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             2                                             2
744465 744465 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2015   SP 5 0 1 0   0     0   0                             6 5 0 1 0   0     0   0                       6
744472 744472 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             1                                             1
744493 744493 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Nipmuc Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
744514 744514 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2015   SP 8 0 0 0   0     0   0                             8 8 0 0 0   0     0   0                       8
744521 744521 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   SP * * * *   *     *   *                             2                                             2
744611 744611 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba Regional   Regular School No 3 09 12 2015   SP 11 0 1 0   0     0   0                             12 11 0 1 0   0     0   0                       12
744624 744624 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   SP 8 0 0 0   1     0   1                             10 8 0 0 0   1     0   1                       10
744653 744653 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
744654 744654 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 Peter Fitzpatrick School   Regular School No 4 UG UG 2015   SP * * * *   *     *   *                             1                                             1
744691 744691 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             5                                             5
744831 744831 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland Regional High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
744853 744853 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
744860 744860 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua Regional Sr High   Regular School No 3 09 12 2015   SP 5 1 0 0   0     0   0                             6 5 1 0 0   0     0   0                       6
744895 744895 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2015   SP 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
744974 744974 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   SP 11 0 0 0   0     0   0                             11 11 0 0 0   0     0   0                       11
745026 745026 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2015   SP * * * *   *     *   *                             3                                             3
745047 745047 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   SP * * * *   *     *   *                             4                                             4
745072 745072 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   SP 12 1 4 0   4     0   0                             21 12 1 4 0   4     0   0                       21
745105 745105 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2015   SP * * * *   *     *   *                             2                                             2
745114 745114 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2015   SP * * * *   *     *   *                             1                                             1
1159473 1159473 IN     school 1800060 15   Adams Central Community Schools 180006000007 21 Adams Central High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1159501 1159501 IN     school 1810260 35   South Adams Schools 181026001642 23 South Adams High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1160016 1160016 IN     school 1802850 255   East Allen County Schools 180285000353 297 New Haven High School   Regular School No 3.0 09 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1160271 1160271 IN     school 1802830 630   Zionsville Community Schools 180283000341 512 Zionsville Community High Sch   Regular School No 3.0 09 12 2015   adult                         7.0 0.0                       7.0                         7 0                 7
1160350 1160350 IN     school 1800960 670   Brown County School Corporation 180096000169 573 Brown County High School   Regular School No 3.0 09 12 2015   adult                         2.0 2.0                       4.0                         2 2                 4
1160414 1160414 IN     school 1808940 775   Pioneer Regional School Corp 180894001491 645 Pioneer Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         2.0 3.0                       5.0                         2 3                 5
1160488 1160488 IN     school 1809370 940   West Clark Community Schools 180937001531 765 Henryville Jr & Sr High Sch   Regular School No 3.0 07 12 2015   adult                         2.0 0.0                       2.0                         2 0                 2
1160519 1160519 IN     school 1809370 940   West Clark Community Schools 180937001540 813 William W Borden High School   Regular School No 3.0 07 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1160540 1160540 IN     school 1801920 1000   Clarksville Com School Corp 180192000249 833 Clarksville Senior High Sch   Regular School No 3.0 09 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1160863 1160863 IN     school 1802440 1300   Crawford Co Com School Corp 180244000279 1059 Crawford County Jr-Sr HS   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1160940 1160940 IN     school 1812450 1405   Washington Com Schools 181245002006 1125 Washington High School   Regular School No 3.0 09 12 2015   adult                         4.0 1.0                       5.0                         4 1                 5
1160988 1160988 IN     school 1811190 1560   Sunman-Dearborn Com Sch Corp 181119001802 7213 East Central High School   Regular School No 3.0 09 12 2015   adult                         3.0 1.0                       4.0                         3 1                 4
1161021 1161021 IN     school 1800240 1600   South Dearborn Com School Corp 180024000056 1179 South Dearborn High School   Regular School No 3.0 09 12 2015   adult                         8.0 5.0                       13.0                         8 5                 13
1161036 1161036 IN     school 1805700 1620   Lawrenceburg Com School Corp 180570001037 1177 Lawrenceburg High School   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1161055 1161055 IN     school 1802610 1655   Decatur County Com Schools 180261000311 1263 South Decatur Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1161080 1161080 IN     school 1802610 1655   Decatur County Com Schools 180261000309 1267 North Decatur Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161263 1161263 IN     school 1807230 1910   Yorktown Community Schools 180723001217 1389 Yorktown High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1161416 1161416 IN     school 1810640 2100   Southeast Dubois Co Sch Corp 181064001745 1583 Forest Park Jr-Sr High Sch   Regular School No 3.0 07 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1161463 1161463 IN     school 1803960 2120   Greater Jasper Con Schs 180396000685 1593 Jasper High School   Regular School No 3.0 09 12 2015   adult                         6.0 1.0                       7.0                         6 1                 7
1161509 1161509 IN     school 1800420 2260   Baugo Community Schools 180042000090 1701 Jimtown High School   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161527 1161527 IN     school 1802400 2270   Concord Community Schools 180240000271 1713 Concord Junior High School   Regular School No 4.0 06 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161533 1161533 IN     school 1802400 2270   Concord Community Schools 180240000269 1715 Concord Community High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1161617 1161617 IN     school 1812240 2285   Wa-Nee Community Schools 181224001956 1737 North Wood High School   Regular School No 3.0 09 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1161679 1161679 IN     school 1803270 2305   Elkhart Community Schools 180327000429 1749 Elkhart Central High School   Regular School No 3.0 09 12 2015   adult                         2.0 2.0                       4.0                         2 2                 4
1161685 1161685 IN     school 1803270 2305   Elkhart Community Schools 180327000430 1750 Elkhart Memorial High School   Regular School No 3.0 09 12 2015   adult                         13.0 15.0                       28.0                         13 15                 28
1161846 1161846 IN     school 1803510 2395   Fayette County School Corp 180351000498 1889 Connersville Sr High School   Regular School No 3.0 09 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1162021 1162021 IN     school 1810620 2455   Southeast Fountain School Corp 181062001742 2022 Fountain Central High School   Regular School No 3.0 07 12 2015   adult                         0.0 1.0                       1.0                         0 1                 1
1162067 1162067 IN     school 1809630 2645   Rochester Community Sch Corp 180963001576 2173 Rochester Community High Sch   Regular School No 3.0 09 12 2015   adult                         1.0 2.0                       3.0                         1 2                 3
1162302 1162302 IN     school 1800600 2920   Bloomfield School District 180060000113 2419 Bloomfield Jr-Sr High School   Regular School No 3.0 07 12 2015   adult                         1.0 0.0                       1.0                         1 0                 1
1162327 1162327 IN     school 1805910 2950   Linton-Stockton School Corp 180591001049 2437 Linton-Stockton High School   Regular School No 3.0 09 12 2015   adult                         2.0 3.0                       5.0                         2 3                 5
1162359 1162359 IN     school 1800008 2980   White River Valley Sch Dist 180000802302 2429 White River Valley Jr/Sr High Sch   Regular School No 3.0 07 12 2015   adult                         0.0 2.0                       2.0                         0 2                 2
1162513 1162513 IN     school 1813080 3030   Westfield-Washington Schools 181308002075 2493 Westfield High School   Regular School No 3.0 09 12 2015   adult                         4.0 2.0                       6.0                         4 2                 6
1162763 1162763 IN     school 1810710 3115   Southern Hancock Co Com Sch Corp 181071001761 2565 New Palestine High School   Regular School No 3.0 09 12 2015   adult                         1.0 1.0                       2.0                         1 1                 2
1162978 1162978 IN     school 1808100 3295   North West Hendricks Schools 180810001387 2731 Tri-West Senior High School   Regular School No 3.0 09 12 2015   adult                         2.0 1.0                       3.0                         2 1                 3
1162993 1162993 IN     school 1801020 3305   Brownsburg Community Sch Corp 180102000176 2709 Brownsburg High School   Regular School No 3.0 09 12 2015   adult                         5.0 1.0                       6.0                         5 1                 6
1163079 1163079 IN     school 1800270 3315   Avon Community School Corp 180027000057 2737 Avon High School   Regular School No 3.0 09 12 2015   adult                         7.0 1.0                       8.0                         7 1                 8

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