Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1123309 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2017   sped_beyond_grade_12 0 9 5 0   2     0   0                             16 0 9 5 0   2     0   0                       16
1123708 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No High 09 12 2017   sped_beyond_grade_12 6 9 3 0   0     0   1                             19 6 9 3 0   0     0   1                       19
1370225 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2020   sped_beyond_grade_12 0 9 1 0   1     0   0   8 3 *                     11.0 0 9 1 0   1     0   0   8 3                 11
1673216 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston - Boston Community Leadership Academy   Regular School No High 09 12 2021   sped_beyond_grade_12 1 9 4 1   5     0   0   17 3 *                     20.0 1 9 4 1   5     0   0   17 3                 20
1673230 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   sped_beyond_grade_12 2 9 4 0   2     0   0   10 7 *                     17.0 2 9 4 0   2     0   0   10 7                 17
1677473 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   sped_beyond_grade_12 0 9 0 0   1     0   0   8 2 *                     10.0 0 9 0 0   1     0   0   8 2                 10
2041023 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2019   sped_beyond_grade_12 0 9 2 0   4     0   0                             15.0 0 9 2 0   4     0   0                       15
940246 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 2016   sped_beyond_grade_12 1 8 1 0   0     0   0   8 2                       10 1 8 1 0   0     0   0   8 2                 10
1365903 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2020   sped_beyond_grade_12 0 8 7 0   0     0   1   7 9 *                     16.0 0 8 7 0   0     0   1   7 9                 16
1365993 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2020   sped_beyond_grade_12 1 8 7 0   2     0   1   12 7 *                     19.0 1 8 7 0   2     0   1   12 7                 19
1673715 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   sped_beyond_grade_12 3 8 3 0   0     0   0   11 3 *                     14.0 3 8 3 0   0     0   0   11 3                 14
936870 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No 3 09 12 2016   sped_beyond_grade_12 5 7 0 0   0     0   0   7 5                       12 5 7 0 0   0     0   0   7 5                 12
938845 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   sped_beyond_grade_12 12 7 35 0   0     0   0   35 19                       54 12 7 35 0   0     0   0   35 19                 54
1123274 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 7 4 0   1     0   0                             14 2 7 4 0   1     0   0                       14
1129414 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2017   sped_beyond_grade_12 1 7 26 0   0     0   0                             34 1 7 26 0   0     0   0                       34
1365889 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   sped_beyond_grade_12 3 7 3 1   0     0   0   10 4 *                     14.0 3 7 3 1   0     0   0   10 4                 14
1673139 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Boston - Brighton High   Regular School No High 09 12 2021   sped_beyond_grade_12 0 7 5 0   0     0   0   5 7 *                     12.0 0 7 5 0   0     0   0   5 7                 12
2230517 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton: Brockton High   Regular School No High 09 12 2018   sped_beyond_grade_12 8 7 1 0   0     0   0                             16.0 8 7 1 0   0     0   0                       16
933751 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No 4 06 12 2016   sped_beyond_grade_12 2 6 3 0   0     0   1   6 6                       12 2 6 3 0   0     0   1   6 6                 12
933762 MA Suffolk   school 2502790 35   Boston 250279001898 350579 Urban Science Academy   Regular School No 3 09 12 2016   sped_beyond_grade_12 1 6 0 0   1     0   0   6 2                       8 1 6 0 0   1     0   0   6 2                 8
1372407 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2020   sped_beyond_grade_12 7 6 5 0   1     0   1   11 9 *                     20.0 7 6 5 0   1     0   1   11 9                 20
1675856 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   sped_beyond_grade_12 9 6 28 0   0     0   1   31 13 *                     44.0 9 6 28 0   0     0   1   31 13                 44
2040392 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   sped_beyond_grade_12 2 6 1 0   0     0   0                             9.0 2 6 1 0   0     0   0                       9
2047540 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 High 06 12 2019   sped_beyond_grade_12 0 6 4 0   0     0   0                             10.0 0 6 4 0   0     0   0                       10
933111 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 4 06 12 2016   sped_beyond_grade_12 0 5 2 0   1     0   0   4 4                       8 0 5 2 0   1     0   0   4 4                 8
936385 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 08 12 2016   sped_beyond_grade_12 6 5 14 0   1     0   1   16 11                       27 6 5 14 0   1     0   1   16 11                 27
1123425 MA Suffolk   school 2502790 35   Boston 250279002729 350658 West Roxbury Academy   Regular School No High 09 12 2017   sped_beyond_grade_12 1 5 2 0   1     0   0                             9 1 5 2 0   1     0   0                       9
1365349 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter School   Regular School No High 07 12 2020   sped_beyond_grade_12 3 5 3 0   2     0   0   8 5 *                     13.0 3 5 3 0   2     0   0   8 5                 13
1368615 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   sped_beyond_grade_12 8 5 18 0   0     0   3   23 11 *                     34.0 8 5 18 0   0     0   3   23 11                 34
1672571 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston - Carter School   Regular School No High 07 12 2021   sped_beyond_grade_12 4 5 3 0   2     0   0   8 6 *                     14.0 4 5 3 0   2     0   0   8 6                 14
1676338 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton - Milton High   Regular School No High 09 12 2021   sped_beyond_grade_12 4 5 0 0   0     0   0   7 2 *                     9.0 4 5 0 0   0     0   0   7 2                 9
1679670 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester - North High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 5 8 0   2     0   0   10 11 *                     21.0 6 5 8 0   2     0   0   10 11                 21
933823 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   sped_beyond_grade_12 0 4 4 0   3     0   0   8 3                       11 0 4 4 0   3     0   0   8 3                 11
938815 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   sped_beyond_grade_12 5 4 20 0   1     0   0   13 17                       30 5 4 20 0   1     0   0   13 17                 30
1126304 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   sped_beyond_grade_12 15 4 13 0   6     0   0                             38 15 4 13 0   6     0   0                       38
1126516 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   sped_beyond_grade_12 9 4 10 0   4     0   2                             29 9 4 10 0   4     0   2                       29
1129404 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 4 13 0   0     0   0                             24 7 4 13 0   0     0   0                       24
1131064 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 South High Community   Regular School No High 09 12 2017   sped_beyond_grade_12 10 4 9 0   2     0   0                             25 10 4 9 0   2     0   0                       25
1370712 MA Middlesex   school 2510890 274   Somerville 251089001745 2740505 Somerville High   Regular School No High 09 12 2020   sped_beyond_grade_12 2 4 4 0   0     0   1   7 4 *                     11.0 2 4 4 0   0     0   1   7 4                 11
1371303 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   sped_beyond_grade_12 5 4 0 0   1     0   0   8 2 *                     10.0 5 4 0 0   1     0   0   8 2                 10
1673126 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   sped_beyond_grade_12 5 4 3 1   1     0   1   10 5 *                     15.0 5 4 3 1   1     0   1   10 5                 15
1673163 MA Suffolk   school 2502790 35   Boston 250279000261 350525 Boston - Jeremiah E Burke High   Regular School No High 09 12 2021   sped_beyond_grade_12 4 4 1 0   0     0   0   8 1 *                     9.0 4 4 1 0   0     0   0   8 1                 9
1673173 MA Suffolk   school 2502790 35   Boston 250279000327 350535 Boston - The English High   Regular School No High 09 12 2021   sped_beyond_grade_12 1 4 8 0   0     0   0   9 4 *                     13.0 1 4 8 0   0     0   0   9 4                 13
1679660 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester - Burncoat Senior High   Regular School No High 09 12 2021   sped_beyond_grade_12 3 4 3 0   1     0   0   9 2 *                     11.0 3 4 3 0   1     0   0   9 2                 11
2040933 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   sped_beyond_grade_12 3 4 2 0   0     0   0                             9.0 3 4 2 0   0     0   0                       9
2041037 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No High 06 12 2019   sped_beyond_grade_12 2 4 5 0   2     0   0                             13.0 2 4 5 0   2     0   0                       13
2041193 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   sped_beyond_grade_12 10 4 2 0   0     0   0                             16.0 10 4 2 0   0     0   0                       16
2043497 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   sped_beyond_grade_12 13 4 10 0   5     0   0                             32.0 13 4 10 0   5     0   0                       32
2043751 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2019   sped_beyond_grade_12 6 4 1 0   2     0   0                             13.0 6 4 1 0   2     0   0                       13
2047480 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2019   sped_beyond_grade_12 5 4 5 0   1     0   1                             16.0 5 4 5 0   1     0   1                       16
2233122 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   sped_beyond_grade_12 11 4 11 0   4     0   0                             30.0 11 4 11 0   4     0   0                       30
2237889 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester: South High Community   Regular School No High 09 12 2018   sped_beyond_grade_12 8 4 8 0   2     0   0                             22.0 8 4 8 0   2     0   0                       22
933665 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No 3 09 12 2016   sped_beyond_grade_12 2 3 4 0   0     0   0   5 4                       9 2 3 4 0   0     0   0   5 4                 9
935052 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No 3 09 12 2016   sped_beyond_grade_12 4 3 7 0   0     0   0   8 6                       14 4 3 7 0   0     0   0   8 6                 14
936211 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2016   sped_beyond_grade_12 10 3 5 0   6     0   0   15 9                       24 10 3 5 0   6     0   0   15 9                 24
939529 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No 3 09 12 2016   sped_beyond_grade_12 30 3 1 0   0     0   1   24 11                       35 30 3 1 0   0     0   1   24 11                 35
1123304 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 3 11 0   0     0   0                             16 2 3 11 0   0     0   0                       16
1126497 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2017   sped_beyond_grade_12 1 3 3 0   0     0   0                             7 1 3 3 0   0     0   0                       7
1129337 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   sped_beyond_grade_12 1 3 10 0   0     0   0                             14 1 3 10 0   0     0   0                       14
1130265 MA Hampden   school 2512630 325   Westfield 251263002073 3250505 Westfield High   Regular School No High 09 12 2017   sped_beyond_grade_12 28 3 2 0   1     0   1                             35 28 3 2 0   1     0   1                       35
1365227 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2020   sped_beyond_grade_12 4 3 2 0   0     0   0   6 3 *                     9.0 4 3 2 0   0     0   0   6 3                 9
1365929 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2020   sped_beyond_grade_12 3 3 5 0   1     0   0   6 6 *                     12.0 3 3 5 0   1     0   0   6 6                 12
1366483 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2020   sped_beyond_grade_12 1 3 2 0   0     0   0   4 2 *                     6.0 1 3 2 0   0     0   0   4 2                 6
1368685 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2020   sped_beyond_grade_12 5 3 6 0   1     0   0   7 8 *                     15.0 5 3 6 0   1     0   0   7 8                 15
1369091 MA Norfolk   school 2507980 189   Milton 250798001262 1890505 Milton High   Regular School No High 09 12 2020   sped_beyond_grade_12 3 3 0 0   0     0   0   4 2 *                     6.0 3 3 0 0   0     0   0   4 2                 6
1371959 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2020   sped_beyond_grade_12 8 3 1 0   0     0   2   10 4 *                     14.0 8 3 1 0   0     0   2   10 4                 14
1673168 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston - East Boston High   Regular School No High 09 12 2021   sped_beyond_grade_12 2 3 8 0   2     0   1   7 9 *                     16.0 2 3 8 0   2     0   1   7 9                 16
1675926 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden - Malden High   Regular School No High 09 12 2021   sped_beyond_grade_12 10 3 8 0   2     0   0   10 13 *                     23.0 10 3 8 0   2     0   0   10 13                 23
2045081 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   sped_beyond_grade_12 11 3 1 0   0     0   0                             15.0 11 3 1 0   0     0   0                       15
2046132 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2019   sped_beyond_grade_12 2 3 10 0   1     0   0                             16.0 2 3 10 0   1     0   0                       16
2046379 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   sped_beyond_grade_12 7 3 0 0   1     0   0                             11.0 7 3 0 0   1     0   0                       11
2049192 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2019   sped_beyond_grade_12 12 3 2 1   4     0   0                             22.0 12 3 2 1   4     0   0                       22
2233337 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   sped_beyond_grade_12 4 3 4 0   0     0   1                             12.0 4 3 4 0   0     0   1                       12
2234993 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield: Pittsfield High   Regular School No High 09 12 2018   sped_beyond_grade_12 10 3 2 0   0     0   1                             16.0 10 3 2 0   0     0   1                       16
2236156 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   sped_beyond_grade_12 0 3 5 0   0     0   0                             8.0 0 3 5 0   0     0   0                       8
2237884 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester: North High   Regular School No High 09 12 2018   sped_beyond_grade_12 5 3 4 0   0     0   1                             13.0 5 3 4 0   0     0   1                       13
2239841 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2018   sped_beyond_grade_12 17 3 5 0   3     0   0                             28.0 17 3 5 0   3     0   0                       28
1365912 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   sped_beyond_grade_12 2 27 18 0   4     0   1   36 16 *                     52.0 2 27 18 0   4     0   1   36 16                 52
1678338 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield - Springfield Vocational Academy   Special Education School No Ungraded UG UG 2021   sped_beyond_grade_12 13 27 82 0   5     0   0   86 41 *                     127.0 13 27 82 0   5     0   0   86 41                 127
1123284 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2017   sped_beyond_grade_12 8 22 8 0   5     0   0                             43 8 22 8 0   5     0   0                       43
1371080 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield Vocational Academy   Special Education School No Ungraded UG UG 2020   sped_beyond_grade_12 10 22 70 0   4     0   1   65 42 *                     107.0 10 22 70 0   4     0   1   65 42                 107
1673148 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston - Charlestown High   Regular School No High 09 12 2021   sped_beyond_grade_12 6 22 19 0   5     0   1   34 19 *                     53.0 6 22 19 0   5     0   1   34 19                 53
2230522 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton: Brockton Champion High School   Regular School No High 09 12 2018   sped_beyond_grade_12 9 22 5 0   1     0   1                             38.0 9 22 5 0   1     0   1                       38
933674 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   sped_beyond_grade_12 10 21 9 0   2     0   0   26 16                       42 10 21 9 0   2     0   0   26 16                 42
933692 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   sped_beyond_grade_12 1 2 2 1   0     0   0   4 2                       6 1 2 2 1   0     0   0   4 2                 6
933910 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2016   sped_beyond_grade_12 5 2 0 0   0     0   0   5 2                       7 5 2 0 0   0     0   0   5 2                 7
936525 MA Middlesex   school 2507320 170   Marlborough 250732001133 1700505 Marlborough High   Regular School No 3 09 12 2016   sped_beyond_grade_12 9 2 4 0   2     0   0   12 5                       17 9 2 4 0   2     0   0   12 5                 17
938761 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   sped_beyond_grade_12 1 2 9 0   0     0   0   8 4                       12 1 2 9 0   0     0   0   8 4                 12
939062 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   sped_beyond_grade_12 10 2 2 0   1     0   0   8 7                       15 10 2 2 0   1     0   0   8 7                 15
1122643 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   sped_beyond_grade_12 0 2 2 0   2     0   0                             6 0 2 2 0   2     0   0                       6
1123374 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Quincy Upper School   Regular School No Other 06 12 2017   sped_beyond_grade_12 1 2 3 0   1     0   1                             8 1 2 3 0   1     0   1                       8
1123558 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2017   sped_beyond_grade_12 6 2 1 0   0     0   0                             9 6 2 1 0   0     0   0                       9
1124918 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2017   sped_beyond_grade_12 5 2 7 0   0     0   0                             14 5 2 7 0   0     0   0                       14
1129409 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2017   sped_beyond_grade_12 3 2 17 0   0     0   0                             22 3 2 17 0   0     0   0                       22
1129706 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   sped_beyond_grade_12 12 2 0 0   1     0   1                             16 12 2 0 0   1     0   1                       16
1131049 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2017   sped_beyond_grade_12 2 2 8 0   1     0   1                             14 2 2 8 0   1     0   1                       14
1131059 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 North High   Regular School No High 09 12 2017   sped_beyond_grade_12 7 2 8 0   1     0   1                             19 7 2 8 0   1     0   1                       19
1131864 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2017   sped_beyond_grade_12 9 2 0 0   0     0   0                             11 9 2 0 0   0     0   0                       11
1133026 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 15 2 5 0   3     0   0                             25 15 2 5 0   3     0   0                       25
1365036 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   sped_beyond_grade_12 12 2 2 0   0     0   0   9 7 *                     16.0 12 2 2 0   0     0   0   9 7                 16

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