enrollments

Data source: Big Local News · About: Big Local

4,267 rows where grade = "sped_beyond_grade_12" and state = "MA" sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • sped_beyond_grade_12 · 4,267 ✖
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
2230216 2230216 MA Suffolk   school   35   Boston   350652               2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1126679 1126679 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130406 1130406 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 21st Century Skills Academy   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126373 1126373 MA Essex   school 2507110 163   Lynn 250711001062 1630016 A Drewicz Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127424 1127424 MA Middlesex   school 2508610 207   Newton 250861001356 2070005 A E Angier   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131888 1131888 MA Worcester   school 2502715 622   Blackstone-Millville 250271501078 6220015 A F Maloney   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128486 1128486 MA Suffolk   school 2510050 248   Revere 251005001619 2480003 A. C. Whelan Elementary School   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122208 1122208 MA Bristol   school 2502190 16   Attleboro 250219000097 160001 A. Irvin Studley Elementary School   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1369818 1369818 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 ACE Program   Special Education School No High 10 12 2020   sped_beyond_grade_12 * * * *   *     *   *   1 * *                     1.0                         1                   1
1130274 1130274 MA Middlesex   school 2512660 326   Westford 251266000163 3260004 Abbot Elementary   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124928 1124928 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238171 2238171 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131339 1131339 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130510 1130510 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No Middle 05 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1672022 1672022 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 0 1 0   1     0   0   5 3 *                     8.0 6 0 1 0   1     0   0   5 3                 8
932550 932550 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   sped_beyond_grade_12 * * * *   *     *   *   2 3                       5                         2 3                 5
1121964 1121964 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1364798 1364798 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 0 1 0   0     0   0   3 3 *                     6.0 5 0 1 0   0     0   0   3 3                 6
2039824 2039824 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228772 2228772 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2228767 2228767 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228762 2228762 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington: Beaver Brook Elementary   Regular School No Elementary KG 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228758 2228758 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Abington: Woodsdale Elementary School   Regular School No Elementary 03 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130217 1130217 MA Hampden   school 2512630 325   Westfield 251263002061 3250020 Abner Gibbs   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126366 1126366 MA Essex   school 2507110 163   Lynn 250711001061 1630011 Aborn   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1126191 1126191 MA Middlesex   school 2507020 160   Lowell 250702001023 1600020 Abraham Lincoln   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127311 1127311 MA Bristol   school 2508430 201   New Bedford 250843001318 2010095 Abraham Lincoln   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128506 1128506 MA Suffolk   school 2510050 248   Revere 251005001618 2480025 Abraham Lincoln   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1130460 1130460 MA Norfolk   school 2512840 336   Weymouth 251284002103 3360005 Academy Avenue   Regular School No Elementary KG 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237960 2237960 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131133 1131133 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1680293 1680293 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   sped_beyond_grade_12 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1131741 1131741 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1373029 1373029 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2020   sped_beyond_grade_12 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
2048101 2048101 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             3.0                                             3
2238578 2238578 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough: Acton-Boxborough Regional High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238530 2238530 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000356 6000005 Acton-Boxborough: Blanchard Memorial School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238554 2238554 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000007 6000020 Acton-Boxborough: C.T. Douglas Elementary School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238522 2238522 MA Middlesex   school 2501710 600   Acton-Boxborough 250171002867 6000001 Acton-Boxborough: Carol Huebner Early Childhood Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238570 2238570 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000009 6000030 Acton-Boxborough: Luther Conant School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238546 2238546 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000010 6000015 Acton-Boxborough: McCarthy-Towne School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238538 2238538 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000029 6000010 Acton-Boxborough: Merriam School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238562 2238562 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000008 6000025 Acton-Boxborough: Paul P Gates Elementary School   Regular School No Elementary KG 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238573 2238573 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Acton-Boxborough: Raymond J Grey Junior High   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1121971 1121971 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet Elementary School   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228779 2228779 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228784 2228784 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1124617 1124617 MA Middlesex   school 2504770 93   Everett 250477002804 930003 Adams School   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2238584 2238584 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Adams-Cheshire: Hoosac Valley Elementary School   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2238595 2238595 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Adams-Cheshire: Hoosac Valley High School   Regular School No High 08 12 2018   sped_beyond_grade_12 5 0 0 0   1     0   0                             6.0 5 0 0 0   1     0   0                       6
2238589 2238589 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1368470 1368470 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   * * *                     6.0 6 0 0 0   0     0   0                       6
2043539 2043539 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2019   sped_beyond_grade_12 7 0 0 0   0     0   1                             8.0 7 0 0 0   0     0   1                       8
2238059 2238059 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1131229 1131229 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1121978 1121978 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122015 1122015 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 0 0 0   0     0   0                             6 6 0 0 0   0     0   0                       6
2039864 2039864 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   sped_beyond_grade_12 9 0 0 0   0     0   0                             9.0 9 0 0 0   0     0   0                       9
1122010 1122010 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam Junior High   Regular School No Middle 07 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228786 2228786 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228821 2228821 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   sped_beyond_grade_12 10 0 0 0   0     0   0                             10.0 10 0 0 0   0     0   0                       10
2228816 2228816 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228798 2228798 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam: Benjamin J Phelps   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228792 2228792 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam: Clifford M Granger   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228810 2228810 MA Hampden   school 2501800 5   Agawam 250180000030 50030 Agawam: James Clark School   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228813 2228813 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228804 2228804 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam: Robinson Park   Regular School No Elementary KG 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1121976 1121976 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128975 1128975 MA Middlesex   school 2510890 274   Somerville 251089001739 2740087 Albert F. Argenziano School at Lincoln Park   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129040 1129040 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124259 1124259 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Alcott   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1124477 1124477 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1125784 1125784 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129218 1129218 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127281 1127281 MA Bristol   school 2508430 201   New Bedford 250843001326 2010063 Alfred J Gomes   Regular School No Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1127948 1127948 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
941448 941448 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2016   sped_beyond_grade_12 5 0 0 0   1     0   0   3 3                       6 5 0 0 0   1     0   0   3 3                 6
1132500 1132500 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 0 0 0   1     0   0                             9 8 0 0 0   1     0   0                       9
1373693 1373693 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 0 0 0   1     0   0   4 3 *                     7.0 6 0 0 0   1     0   0   4 3                 7
2048754 2048754 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   sped_beyond_grade_12 7 0 0 0   3     0   0                             10.0 7 0 0 0   3     0   0                       10
1130347 1130347 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1129298 1129298 MA Hampden   school 2511130 281   Springfield 251113001792 2810175 Alice B Beal Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128438 1128438 MA Middlesex   school 2509990 246   Reading 250999001604 2460002 Alice M Barrows   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128105 1128105 MA Berkshire   school 2509630 236   Pittsfield 250963001516 2360010 Allendale   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131109 1131109 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2237935 2237935 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
1130631 1130631 MA Middlesex   school 2513110 344   Winchester 251311002164 3440045 Ambrose Elementary   Regular School No Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1128283 1128283 MA Norfolk   school 2509870 243   Quincy 250987002807 2430005 Amelio Della Chiesa Early Childhood Center   Regular School No Elementary PK PK 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1672082 1672082 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   sped_beyond_grade_12 8 0 0 0   0     0   0   4 4 *                     8.0 8 0 0 0   0     0   0   4 4                 8
1122022 1122022 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury Elementary   Regular School No Elementary PK 04 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122039 1122039 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1364858 1364858 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   sped_beyond_grade_12 6 0 0 0   0     0   0   4 2 *                     6.0 6 0 0 0   0     0   0   4 2                 6
2039885 2039885 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   sped_beyond_grade_12 * * * *   *     *   *                             5.0                                             5
1122044 1122044 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1122034 1122034 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
2228828 2228828 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228845 2228845 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             2.0                                             2
2228850 2228850 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228840 2228840 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   sped_beyond_grade_12 * * * *   *     *   *                             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]);