enrollments

Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by ccd_school_type

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,737 ✖
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
2230212 2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
736031 736031 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_9 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
736837 736837 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2015   grade_9 5 30 40 0   3     0   3   41 40                       81 5 30 40 0   3     0   3   41 40                 81
736841 736841 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2015   grade_9 4 32 19 0   4     1   2   33 29                       62 4 32 19 0   4     1   2   33 29                 62
736845 736845 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2015   grade_9 3 49 19 1   0     0   1   47 26                       73 3 49 19 1   0     0   1   47 26                 73
736860 736860 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2015   grade_9 13 41 43 1   2     0   2   36 66                       102 13 41 43 1   2     0   2   36 66                 102
737142 737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
737550 737550 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2015   grade_9 14 0 13 0   0     0   0   17 10                       27 14 0 13 0   0     0   0   17 10                 27
737827 737827 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   * *                       2                                             2
738369 738369 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_9 13 0 0 0   1     0   0   9 5                       14 13 0 0 0   1     0   0   9 5                 14
739022 739022 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_9 4 4 86 0   2     0   0   53 43                       96 4 4 86 0   2     0   0   53 43                 96
741683 741683 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2015   grade_9 2 2 3 0   1     0   0   6 2                       8 2 2 3 0   1     0   0   6 2                 8
742025 742025 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   1 3                       4                         1 3                 4
742254 742254 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2015   grade_9 2 3 1 0   0     0   1   6 1                       7 2 3 1 0   0     0   1   6 1                 7
932900 932900 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_9 5 0 1 0   0     0   1   4 3                       7 5 0 1 0   0     0   1   4 3                 7
933702 933702 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative Education School No 3 09 12 2016   grade_9 7 27 62 0   4     1   0   49 52                       101 7 27 62 0   4     1   0   49 52                 101
933706 933706 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative Education School No 3 09 12 2016   grade_9 8 16 25 0   4     0   1   31 23                       54 8 16 25 0   4     0   1   31 23                 54
933710 933710 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative Education School No 3 09 12 2016   grade_9 1 48 29 0   2     0   0   33 47                       80 1 48 29 0   2     0   0   33 47                 80
933724 933724 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative Education School No 3 09 12 2016   grade_9 14 49 45 0   8     0   5   47 74                       121 14 49 45 0   8     0   5   47 74                 121
933825 933825 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative Education School No 3 08 12 2016   grade_9 1 9 6 1   0     0   0   8 9                       17 1 9 6 1   0     0   0   8 9                 17
934003 934003 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2016   grade_9 5 1 2 0   0     0   0   5 3                       8 5 1 2 0   0     0   0   5 3                 8
934410 934410 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative Education School No 4 06 12 2016   grade_9 11 0 9 0   0     0   1   14 7                       21 11 0 9 0   0     0   1   14 7                 21
935220 935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
935871 935871 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2016   grade_9 1 2 42 0   1     0   0   25 21                       46 1 2 42 0   1     0   0   25 21                 46
938486 938486 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative Education School No 3 09 12 2016   grade_9 1 5 3 0   0     0   2   6 5                       11 1 5 3 0   0     0   2   6 5                 11
938837 938837 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2016   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
939063 939063 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2016   grade_9 * * * *   *     *   *   4 1                       5                         4 1                 5
939787 939787 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_9 * * * *   *     *   *   1 4                       5                         1 4                 5
1122391 1122391 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_9 8 0 2 0   0     0   0   6 4                       10 8 0 2 0   0     0   0   6 4                 10
1123315 1123315 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2017   grade_9 3 34 66 0   2     0   2   48 59                       107 3 34 66 0   2     0   2   48 59                 107
1123320 1123320 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2017   grade_9 4 20 23 0   1     0   1   23 26                       49 4 20 23 0   1     0   1   23 26                 49
1123325 1123325 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 09 12 2017   grade_9 2 45 30 0   0     0   2   37 42                       79 2 45 30 0   0     0   2   37 42                 79
1123342 1123342 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2017   grade_9 10 58 56 0   4     0   4   47 85                       132 10 58 56 0   4     0   4   47 85                 132
1123456 1123456 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_9 * * * *   *     *   *   2 2                       *                         2 2                  
1123670 1123670 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_9 3 3 0 0   0     0   0   5 1                       6 3 3 0 0   0     0   0   5 1                 6
1124149 1124149 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_9 9 1 20 0   0     0   0   24 6                       30 9 1 20 0   0     0   0   24 6                 30
1125116 1125116 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_9 20 1 2 0   0     0   4   18 9                       27 20 1 2 0   0     0   4   18 9                 27
1125891 1125891 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_9 3 1 56 0   1     0   0   39 22                       61 3 1 56 0   1     0   0   39 22                 61
1129017 1129017 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2017   grade_9 3 5 7 0   0     0   0   9 6                       15 3 5 7 0   0     0   0   9 6                 15
1129434 1129434 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2017   grade_9 3 0 3 0   0     0   0   3 3                       6 3 0 3 0   0     0   0   3 3                 6
1129707 1129707 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_9 * * * *   *     *   *   2 1                       *                         2 1                  
1130586 1130586 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No Other 06 12 2017   grade_9 6 0 0 0   0     0   1   5 2                       7 6 0 0 0   0     0   1   5 2                 7
1365150 1365150 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_9 6 0 2 0   0     0   0   4 3 *                     8.0 6 0 2 0   0     0   0   4 3                 8
1365940 1365940 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2020   grade_9 9 35 63 0   1     0   3   53 58 *                     111.0 9 35 63 0   1     0   3   53 58                 111
1365944 1365944 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2020   grade_9 5 30 26 0   1     0   0   42 20 *                     62.0 5 30 26 0   1     0   0   42 20                 62
1365950 1365950 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2020   grade_9 0 48 43 0   4     0   1   46 50 *                     96.0 0 48 43 0   4     0   1   46 50                 96
1365964 1365964 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2020   grade_9 9 58 57 0   2     0   6   42 89 *                     132.0 9 58 57 0   2     0   6   42 89                 132
1366221 1366221 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_9 1 3 1 0   0     0   1   3 3 *                     6.0 1 3 1 0   0     0   1   3 3                 6
1366246 1366246 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2020   grade_9 5 7 4 0   0     0   2   8 10 *                     18.0 5 7 4 0   0     0   2   8 10                 18
1366606 1366606 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2020   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1366634 1366634 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_9 7 0 11 0   0     0   1   9 10 *                     19.0 7 0 11 0   0     0   1   9 10                 19
1367209 1367209 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2020   grade_9 14 4 8 0   0     0   1   14 13 *                     27.0 14 4 8 0   0     0   1   14 13                 27
1367457 1367457 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2020   grade_9 26 1 6 0   0     0   1   17 17 *                     34.0 26 1 6 0   0     0   1   17 17                 34
1370713 1370713 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2020   grade_9 4 1 3 0   1     0   0   6 3 *                     9.0 4 1 3 0   1     0   0   6 3                 9
1370753 1370753 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge Academy   Alternative School No High 09 12 2020   grade_9 0 0 7 0   0     0   2   5 4 *                     9.0 0 0 7 0   0     0   2   5 4                 9
1371072 1371072 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2020   grade_9 5 2 6 0   0     0   0   2 11 *                     13.0 5 2 6 0   0     0   0   2 11                 13
1372007 1372007 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No High 09 12 2020   grade_9 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1672372 1672372 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_9 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1673179 1673179 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston - Fenway High School   Alternative School No High 09 12 2021   grade_9 4 27 68 0   2     0   5   52 54 *                     106.0 4 27 68 0   2     0   5   52 54                 106
1673183 1673183 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Boston - Another Course To College   Alternative School No High 09 12 2021   grade_9 0 27 30 0   0     0   2   33 26 *                     59.0 0 27 30 0   0     0   2   33 26                 59
1673189 1673189 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston - New Mission High School   Alternative School No High 07 12 2021   grade_9 4 54 51 0   4     0   3   64 52 *                     116.0 4 54 51 0   4     0   3   64 52                 116
1673202 1673202 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston - Boston Arts Academy   Alternative School No High 09 12 2021   grade_9 8 47 66 0   3     0   6   32 97 *                     130.0 8 47 66 0   3     0   6   32 97                 130
1673454 1673454 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_9 3 4 2 0   0     0   1   8 2 *                     10.0 3 4 2 0   0     0   1   8 2                 10
1673479 1673479 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton - Brockton Champion High School   Alternative School No High 09 12 2021   grade_9 7 15 6 0   0     0   2   16 14 *                     30.0 7 15 6 0   0     0   2   16 14                 30
1673863 1673863 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee - Chicopee Academy   Alternative School No High 07 12 2021   grade_9 2 1 7 0   0     0   1   6 5 *                     11.0 2 1 7 0   0     0   1   6 5                 11
1674443 1674443 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_9 10 6 14 0   0     0   3   22 11 *                     33.0 10 6 14 0   0     0   3   22 11                 33
1674692 1674692 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner - Gardner Academy for Learning and Technology   Alternative School No High 09 12 2021   grade_9 7 0 6 0   1     0   0   11 3 *                     14.0 7 0 6 0   1     0   0   11 3                 14
1675312 1675312 MA Essex   school 2506660 149   Lawrence 250666002919 1490615 Lawrence - RISE Academy   Alternative School No Secondary 09 11 2021   grade_9 0 0 8 0   0     0   0   7 * *                     8.0 0 0 8 0   0     0   0   7                   8
1677964 1677964 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Somerville - Full Circle High School   Alternative School No High 09 12 2021   grade_9 0 2 9 0   0     0   0   9 2 *                     11.0 0 2 9 0   0     0   0   9 2                 11
1678008 1678008 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_9 5 0 6 0   0     0   0   7 4 *                     11.0 5 0 6 0   0     0   0   7 4                 11
1679267 1679267 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Winchendon - Murdock Academy for Success   Alternative School No High 09 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
2040176 2040176 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2019   grade_9 6 0 0 0   0     0   0   4 2                       6.0 6 0 0 0   0     0   0   4 2                 6
2040983 2040983 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Fenway High School   Alternative School No High 09 12 2019   grade_9 2 30 64 1   5     0   2   50 54                       104.0 2 30 64 1   5     0   2   50 54                 104
2040988 2040988 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_9 4 32 25 0   1     0   0   31 31                       62.0 4 32 25 0   1     0   0   31 31                 62
2040994 2040994 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_9 1 54 45 1   0     0   1   49 53                       102.0 1 54 45 1   0     0   1   49 53                 102
2041009 2041009 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_9 16 53 36 0   3     0   6   38 76                       114.0 16 53 36 0   3     0   6   38 76                 114
2041290 2041290 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_9 1 4 2 0   0     0   2   6 3                       9.0 1 4 2 0   0     0   2   6 3                 9
2041316 2041316 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_9 10 10 17 0   0     0   2   26 13                       39.0 10 10 17 0   0     0   2   26 13                 39
2041676 2041676 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_9 * * * *   *     *   *   1 4                       5.0                         1 4                 5
2041704 2041704 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_9 7 1 25 0   0     0   0   18 15                       33.0 7 1 25 0   0     0   0   18 15                 33
2042280 2042280 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Resiliency Preparatory Academy   Alternative School No High 07 12 2019   grade_9 11 4 7 1   0     0   1   14 10                       24.0 11 4 7 1   0     0   1   14 10                 24
2042529 2042529 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_9 7 1 1 0   0     0   1   6 4                       10.0 7 1 1 0   0     0   1   6 4                 10
2045788 2045788 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Full Circle High School   Alternative School No High 09 12 2019   grade_9 1 0 6 0   0     0   0   5 2                       7.0 1 0 6 0   0     0   0   5 2                 7
2046148 2046148 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative School No High 09 12 2019   grade_9 2 3 2 0   0     0   0   4 3                       7.0 2 3 2 0   0     0   0   4 3                 7
2047081 2047081 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative School No High 09 12 2019   grade_9 13 0 0 0   0     0   0   7 6                       13.0 13 0 0 0   0     0   0   7 6                 13
2229198 2229198 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_9 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2230120 2230120 MA Suffolk   school 2502790 35   Boston 250279000695 350540 Boston: Fenway High School   Alternative School No High 09 12 2018   grade_9 3 26 70 0   2     0   1   50 52                       102.0 3 26 70 0   2     0   1   50 52                 102
2230125 2230125 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Boston: Another Course To College   Alternative School No High 09 12 2018   grade_9 4 19 27 0   1     0   1   32 20                       52.0 4 19 27 0   1     0   1   32 20                 52
2230131 2230131 MA Suffolk   school 2502790 35   Boston 250279000704 350542 Boston: New Mission High School   Alternative School No High 07 12 2018   grade_9 2 51 33 0   1     0   1   49 39                       88.0 2 51 33 0   1     0   1   49 39                 88
2230147 2230147 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston: Boston Arts Academy   Alternative School No High 09 12 2018   grade_9 16 48 49 2   4     1   8   30 98                       128.0 16 48 49 2   4     1   8   30 98                 128
2230274 2230274 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston: Boston Collaborative High School   Alternative School No High 09 12 2018   grade_9 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2230484 2230484 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_9 3 3 6 0   0     0   1   10 3                       13.0 3 3 6 0   0     0   1   10 3                 13
2230964 2230964 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_9 6 2 17 0   0     0   0   21 4                       25.0 6 2 17 0   0     0   0   21 4                 25
2231653 2231653 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_9 20 5 7 0   0     0   0   16 16                       32.0 20 5 7 0   0     0   0   16 16                 32
2231945 2231945 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner: Gardner Academy for Learning and Technology   Alternative School No High 09 12 2018   grade_9 12 0 1 1   0     0   1   8 7                       15.0 12 0 1 1   0     0   1   8 7                 15
2232707 2232707 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Lawrence: Phoenix Academy Lawrence   Alternative School No High 09 12 2018   grade_9 1 0 12 0   0     0   0   6 7                       13.0 1 0 12 0   0     0   0   6 7                 13
2235837 2235837 MA Middlesex   school 2510890 274   Somerville 251089002499 2740510 Somerville: Full Circle High School   Alternative School No High 09 12 2018   grade_9 4 0 5 0   0     0   0   5 4                       9.0 4 0 5 0   0     0   0   5 4                 9
1123310 1123310 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_9 2 74 138 1   0     0   7   130 92                       222 2 74 138 1   0     0   7   130 92                 222
1125998 1125998 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2017   grade_9 136 27 100 0   5     2   10   162 118                       280 136 27 100 0   5     2   10   162 118                 280
1126512 1126512 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_9 39 11 194 0   14     0   6   151 113                       264 39 11 194 0   14     0   6   151 113                 264

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