enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 2,637 ✖
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
2238423 2238423 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_9 9 57 24 0   8     0   1   52 47                       99.0 9 57 24 0   8     0   1   52 47                 99
743476 743476 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2015   grade_9 5 34 37 0   0     1   2   32 47                       79 5 34 37 0   0     1   2   32 47                 79
940294 940294 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes 3 09 12 2016   grade_9 3 38 31 2   2     1   2   41 38                       79 3 38 31 2   2     1   2   41 38                 79
1131182 1131182 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_9 6 65 48 1   1     0   1   57 65                       122 6 65 48 1   1     0   1   57 65                 122
1372520 1372520 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2020   grade_9 6 46 42 1   0     0   1   42 54 *                     96.0 6 46 42 1   0     0   1   42 54                 96
1679783 1679783 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District) - Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2021   grade_9 2 31 38 0   1     0   1   31 42 *                     73.0 2 31 38 0   1     0   1   31 42                 73
2047592 2047592 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_9 3 46 42 2   0     0   1   46 48                       94.0 3 46 42 2   0     0   1   46 48                 94
2238010 2238010 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District): Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2018   grade_9 6 52 44 0   0     0   5   52 55                       107.0 6 52 44 0   0     0   5   52 55                 107
743611 743611 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_9 24 35 29 0   6     0   2   33 63                       96 24 35 29 0   6     0   2   33 63                 96
940434 940434 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 39 17 0   6     1   3   56 37                       93 27 39 17 0   6     1   3   56 37                 93
1131335 1131335 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   grade_9 27 41 20 0   5     0   3   48 48                       96 27 41 20 0   5     0   3   48 48                 96
1372668 1372668 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 2020   grade_9 20 50 24 0   3     0   5   53 49 *                     102.0 20 50 24 0   3     0   5   53 49                 102
1679932 1679932 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 2021   grade_9 18 59 16 0   3     0   1   46 51 *                     97.0 18 59 16 0   3     0   1   46 51                 97
2047739 2047739 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 2019   grade_9 19 59 25 0   6     0   0   51 58                       109.0 19 59 25 0   6     0   0   51 58                 109
2238167 2238167 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   grade_9 16 47 29 1   6     0   2   44 57                       101.0 16 47 29 1   6     0   2   44 57                 101
743624 743624 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_9 39 29 3 0   5     0   3   34 45                       79 39 29 3 0   5     0   3   34 45                 79
940447 940447 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_9 30 33 3 0   8     0   2   41 35                       76 30 33 3 0   8     0   2   41 35                 76
1131349 1131349 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_9 24 37 4 0   7     0   5   37 40                       77 24 37 4 0   7     0   5   37 40                 77
1372681 1372681 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_9 35 50 5 1   5     0   7   49 54 *                     103.0 35 50 5 1   5     0   7   49 54                 103
1679945 1679945 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_9 31 68 7 0   7     0   4   55 62 *                     117.0 31 68 7 0   7     0   4   55 62                 117
2047752 2047752 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_9 31 63 5 0   5     0   2   50 56                       106.0 31 63 5 0   5     0   2   50 56                 106
2238181 2238181 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_9 24 39 5 0   11     1   5   36 49                       85.0 24 39 5 0   11     1   5   36 49                 85
743641 743641 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2015   grade_9 54 13 9 2   4     0   4   32 54                       86 54 13 9 2   4     0   4   32 54                 86
940464 940464 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes 4 05 12 2016   grade_9 47 18 14 0   3     0   1   31 52                       83 47 18 14 0   3     0   1   31 52                 83
1131368 1131368 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_9 30 22 20 1   1     0   2   34 42                       76 30 22 20 1   1     0   2   34 42                 76
1372698 1372698 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2020   grade_9 44 24 18 0   2     0   2   49 41 *                     90.0 44 24 18 0   2     0   2   49 41                 90
1679962 1679962 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_9 26 38 21 0   2     0   4   53 38 *                     91.0 26 38 21 0   2     0   4   53 38                 91
2047769 2047769 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_9 40 32 18 0   0     0   1   46 45                       91.0 40 32 18 0   0     0   1   46 45                 91
2238200 2238200 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_9 41 28 15 1   1     0   1   41 46                       87.0 41 28 15 1   1     0   1   41 46                 87
743654 743654 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes 3 09 12 2015   grade_9 3 39 52 1   5     0   4   37 67                       104 3 39 52 1   5     0   4   37 67                 104
940477 940477 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes 3 09 12 2016   grade_9 8 33 49 1   0     0   2   30 63                       93 8 33 49 1   0     0   2   30 63                 93
1131383 1131383 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2017   grade_9 3 52 48 0   0     0   2   37 68                       105 3 52 48 0   0     0   2   37 68                 105
1372711 1372711 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2020   grade_9 3 39 64 0   0     0   0   34 72 *                     106.0 3 39 64 0   0     0   0   34 72                 106
1679975 1679975 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) - Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2021   grade_9 5 39 47 0   2     0   7   38 62 *                     100.0 5 39 47 0   2     0   7   38 62                 100
2047782 2047782 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Man   Regular School Yes High 09 12 2019   grade_9 3 39 58 1   2     0   2   37 68                       105.0 3 39 58 1   2     0   2   37 68                 105
2238215 2238215 MA Suffolk   school 2500054 452   Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District) 250005401258 4520505 Edward M. Kennedy Academy for Health Careers (Horace Mann Charter) (District): Edward M. Kennedy Academy for Health Careers (Horace Mann Charter School)   Regular School Yes High 09 12 2018   grade_9 2 42 57 1   0     0   5   45 62                       107.0 2 42 57 1   0     0   5   45 62                 107
743755 743755 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_9 55 13 8 1   14     0   5   41 55                       96 55 13 8 1   14     0   5   41 55                 96
940584 940584 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_9 50 16 6 0   23     0   2   47 50                       97 50 16 6 0   23     0   2   47 50                 97
1131490 1131490 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_9 65 16 5 2   14     0   4   39 67                       106 65 16 5 2   14     0   4   39 67                 106
1372808 1372808 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_9 46 11 12 0   24     0   2   43 52 *                     95.0 46 11 12 0   24     0   2   43 52                 95
1680073 1680073 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_9 47 36 7 0   32     0   3   57 68 *                     125.0 47 36 7 0   32     0   3   57 68                 125
2047880 2047880 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_9 49 11 5 0   12     0   2   37 42                       79.0 49 11 5 0   12     0   2   37 42                 79
2238323 2238323 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_9 52 11 3 0   23     0   2   46 45                       91.0 52 11 3 0   23     0   2   46 45                 91
743812 743812 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2015   grade_9 78 2 1 0   0     0   4   39 46                       85 78 2 1 0   0     0   4   39 46                 85
940641 940641 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes 4 05 12 2016   grade_9 68 1 2 0   5     0   0   41 35                       76 68 1 2 0   5     0   0   41 35                 76
1131550 1131550 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_9 80 0 4 1   4     0   1   33 57                       90 80 0 4 1   4     0   1   33 57                 90
1372854 1372854 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2020   grade_9 74 0 3 2   1     0   5   38 47 *                     85.0 74 0 3 2   1     0   5   38 47                 85
1680119 1680119 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District) - Rising Tide Charter Public School   Regular School Yes High 05 12 2021   grade_9 68 0 5 2   2     0   8   41 43 *                     85.0 68 0 5 2   2     0   8   41 43                 85
2047926 2047926 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2019   grade_9 76 0 2 0   1     0   1   36 44                       80.0 76 0 2 0   1     0   1   36 44                 80
2238383 2238383 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District): Rising Tide Charter Public School   Regular School Yes High 05 12 2018   grade_9 68 0 1 0   0     0   4   32 41                       73.0 68 0 1 0   0     0   4   32 41                 73
743862 743862 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2015   grade_9 177 4 5 0   3     0   11   78 122                       200 177 4 5 0   3     0   11   78 122                 200
940692 940692 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2016   grade_9 184 6 12 2   8     1   7   87 133                       220 184 6 12 2   8     1   7   87 133                 220
1131608 1131608 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_9 182 4 15 2   6     0   8   99 118                       217 182 4 15 2   6     0   8   99 118                 217
1372908 1372908 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2020   grade_9 185 5 11 1   10     0   5   96 120 *                     217.0 185 5 11 1   10     0   5   96 120                 217
1680173 1680173 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District) - Sturgis Charter Public School   Regular School Yes High 09 12 2021   grade_9 188 4 9 0   1     1   8   79 132 *                     211.0 188 4 9 0   1     1   8   79 132                 211
2047980 2047980 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2019   grade_9 198 6 16 1   2     0   0   104 119                       223.0 198 6 16 1   2     0   0   104 119                 223
2238442 2238442 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public (District): Sturgis Charter Public School   Regular School Yes High 09 12 2018   grade_9 183 5 7 0   11     0   9   97 118                       215.0 183 5 7 0   11     0   9   97 118                 215
940649 940649 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes 2 05 09 2016   grade_9 2 103 65 1   1     0   3   84 91                       175 2 103 65 1   1     0   3   84 91                 175
1131559 1131559 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_9 1 136 83 0   1     0   3   112 112                       224 1 136 83 0   1     0   3   112 112                 224
1372862 1372862 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2020   grade_9 6 152 89 0   4     1   1   141 112 *                     253.0 6 152 89 0   4     1   1   141 112                 253
1680127 1680127 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_9 1 124 103 1   4     1   4   137 100 *                     238.0 1 124 103 1   4     1   4   137 100                 238
2047934 2047934 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_9 3 132 87 0   0     1   2   116 109                       225.0 3 132 87 0   0     1   2   116 109                 225
2238392 2238392 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_9 2 113 81 1   0     0   2   117 82                       199.0 2 113 81 1   0     0   2   117 82                 199
743742 743742 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_9 5 47 37 2   0     0   0   48 43                       91 5 47 37 2   0     0   0   48 43                 91
940571 940571 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_9 4 43 34 1   0     0   4   40 46                       86 4 43 34 1   0     0   4   40 46                 86
1131476 1131476 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_9 3 49 38 0   0     0   3   54 39                       93 3 49 38 0   0     0   3   54 39                 93
1372795 1372795 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_9 0 35 48 0   1     0   3   46 41 *                     87.0 0 35 48 0   1     0   3   46 41                 87
1680060 1680060 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District) - MATCH Charter Public School   Regular School Yes Other PK 12 2021   grade_9 1 33 50 0   0     0   1   43 42 *                     85.0 1 33 50 0   0     0   1   43 42                 85
2047867 2047867 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_9 2 39 49 1   1     0   3   52 43                       95.0 2 39 49 1   1     0   3   52 43                 95
2238309 2238309 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_9 2 49 38 1   0     0   1   51 40                       91.0 2 49 38 1   0     0   1   51 40                 91
744457 744457 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2015   grade_9 101 0 0 0   0     0   0   49 52                       101 101 0 0 0   0     0   0   49 52                 101
941282 941282 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2016   grade_9 109 0 0 0   0     0   2   46 65                       111 109 0 0 0   0     0   2   46 65                 111
1132310 1132310 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_9 110 0 3 0   2     0   0   47 68                       115 110 0 3 0   2     0   0   47 68                 115
1373515 1373515 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2020   grade_9 120 0 0 0   3     0   2   72 53 *                     125.0 120 0 0 0   3     0   2   72 53                 125
1680779 1680779 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional - Manchester Essex Regional High School   Regular School No High 09 12 2021   grade_9 93 0 1 0   1     0   1   51 45 *                     96.0 93 0 1 0   1     0   1   51 45                 96
2048577 2048577 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2019   grade_9 124 0 2 0   2     0   1   67 62                       129.0 124 0 2 0   2     0   1   67 62                 129
2239141 2239141 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional: Manchester Essex Regional High School   Regular School No High 09 12 2018   grade_9 129 0 0 0   2     0   0   59 72                       131.0 129 0 0 0   2     0   0   59 72                 131
743447 743447 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_9 8 0 0 0   0     0   1   6 3                       9 8 0 0 0   0     0   1   6 3                 9
743546 743546 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2015   grade_9 0 40 9 0   0     0   0   31 18                       49 0 40 9 0   0     0   0   31 18                 49
940369 940369 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes 4 PK 12 2016   grade_9 0 38 13 0   0     1   0   26 26                       52 0 38 13 0   0     1   0   26 26                 52
1131274 1131274 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2017   grade_9 1 33 11 1   0     0   0   26 20                       46 1 33 11 1   0     0   0   26 20                 46
1372609 1372609 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_9 0 34 6 0   0     0   0   22 18 *                     40.0 0 34 6 0   0     0   0   22 18                 40
1679872 1679872 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_9 0 34 9 0   0     0   0   17 26 *                     43.0 0 34 9 0   0     0   0   17 26                 43
2047681 2047681 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_9 0 31 8 0   0     0   1   20 20                       40.0 0 31 8 0   0     0   1   20 20                 40
2238105 2238105 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_9 1 27 11 1   0     0   1   16 25                       41.0 1 27 11 1   0     0   1   16 25                 41
1131209 1131209 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_9 2 41 23 0   1     0   1   29 39                       68 2 41 23 0   1     0   1   29 39                 68
1372543 1372543 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_9 5 91 32 0   1     0   2   71 60 *                     131.0 5 91 32 0   1     0   2   71 60                 131
1679806 1679806 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_9 3 93 50 0   1     0   1   72 76 *                     148.0 3 93 50 0   1     0   1   72 76                 148
2047618 2047618 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_9 3 62 39 0   1     0   3   63 45                       108.0 3 62 39 0   1     0   3   63 45                 108
2238037 2238037 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_9 2 38 24 1   1     0   0   32 34                       66.0 2 38 24 1   1     0   0   32 34                 66
743761 743761 MA Worcester   school 2500073 474   The Sizer School: A North Central Charter Essential (District) 250007301750 4740505 The Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2015   grade_9 49 4 14 0   1     0   3   35 36                       71 49 4 14 0   1     0   3   35 36                 71
940590 940590 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes 3 07 12 2016   grade_9 55 2 15 0   1     0   2   41 34                       75 55 2 15 0   1     0   2   41 34                 75
1131497 1131497 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2017   grade_9 56 6 9 0   2     0   1   36 38                       74 56 6 9 0   2     0   1   36 38                 74
1372814 1372814 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2020   grade_9 32 3 21 0   0     0   4   34 26 *                     60.0 32 3 21 0   0     0   4   34 26                 60
1680079 1680079 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District) - Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2021   grade_9 46 7 13 1   1     0   1   39 30 *                     69.0 46 7 13 1   1     0   1   39 30                 69
2047886 2047886 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_9 43 5 17 0   1     0   2   31 35                       68.0 43 5 17 0   1     0   2   31 35                 68
2238330 2238330 MA Worcester   school 2500073 474   Sizer School: A North Central Charter Essential (District) 250007301750 4740505 Sizer School: A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2018   grade_9 46 5 18 0   0     0   0   42 27                       69.0 46 5 18 0   0     0   0   42 27                 69
940239 940239 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes 2 05 09 2016   grade_9 12 18 79 2   4     0   0   56 59                       115 12 18 79 2   4     0   0   56 59                 115
1131114 1131114 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_9 15 15 140 0   3     0   0   84 89                       173 15 15 140 0   3     0   0   84 89                 173
1372456 1372456 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_9 26 14 130 4   2     2   0   83 95 *                     178.0 26 14 130 4   2     2   0   83 95                 178

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