Data source: Big Local News · About: Big Local

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

View and edit SQL

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
1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1675707 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
736960 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_9 2 0 3 0   0     0   1   3 3                       6 2 0 3 0   0     0   1   3 3                 6
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
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
933819 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_9 0 3 3 0   1     0   0   2 5                       7 0 3 3 0   1     0   0   2 5                 7
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
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
1123450 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_9 0 3 5 0   1     0   1   7 3                       10 0 3 5 0   1     0   1   7 3                 10
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
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
1368611 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_9 48 13 202 1   12     0   11   167 120 *                     287.0 48 13 202 1   12     0   11   167 120                 287
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
1372656 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_9 7 43 8 0   1     0   5   42 22 *                     64.0 7 43 8 0   1     0   5   42 22                 64
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
1675668 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_9 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1675852 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_9 39 21 216 0   13     0   8   151 146 *                     297.0 39 21 216 0   13     0   8   151 146                 297
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
1679919 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District) - Neighborhood House Charter School   Regular School Yes Other PK 12 2021   grade_9 7 46 20 1   1     0   6   44 37 *                     81.0 7 46 20 1   1     0   6   44 37                 81
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
2041102 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_9 1 2 3 0   1     0   0   4 3                       7.0 1 2 3 0   1     0   0   4 3                 7
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
2047728 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_9 16 38 8 0   2     0   1   32 33                       65.0 16 38 8 0   2     0   1   32 33                 65
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
2230269 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_9 * * * *   *     *   *   1 2                       3.0                         1 2                 3
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
2238156 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_9 7 31 9 0   0     0   0   27 20                       47.0 7 31 9 0   0     0   0   27 20                 47
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
939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
736680 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_9 3 27 11 0   1     0   1   32 11                       43 3 27 11 0   1     0   1   32 11                 43
743579 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_9 30 50 35 0   2     0   1   59 59                       118 30 50 35 0   2     0   1   59 59                 118
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
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
743723 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_9 6 1 1 0   1     0   0   6 3                       9 6 1 1 0   1     0   0   6 3                 9
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
743845 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_9 14 49 20 0   6     0   2   43 48                       91 14 49 20 0   6     0   2   43 48                 91
743858 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2015   grade_9 33 15 1 0   1     0   2   24 28                       52 33 15 1 0   1     0   2   24 28                 52
743875 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_9 35 4 6 0   0     0   2   18 29                       47 35 4 6 0   0     0   2   18 29                 47
743909 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter(District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 10 2015   grade_9 9 3 3 0   2     0   2   7 12                       19 9 3 3 0   2     0   2   7 12                 19
745182 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_9 41 4 8 1   0     0   1   24 31                       55 41 4 8 1   0     0   1   24 31                 55
745195 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2015   grade_9 74 5 14 0   0     1   3   36 61                       97 74 5 14 0   0     1   3   36 61                 97
933547 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_9 5 19 14 0   0     0   0   29 9                       38 5 19 14 0   0     0   0   29 9                 38
934837 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 KG 12 2016   grade_9 2 3 5 0   0     0   0   7 3                       10 2 3 5 0   0     0   0   7 3                 10
940402 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_9 33 49 41 0   8     0   5   63 73                       136 33 49 41 0   8     0   5   63 73                 136
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
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
940552 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_9 5 0 1 0   0     0   0   3 3                       6 5 0 1 0   0     0   0   3 3                 6
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
940675 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_9 8 47 23 0   7     0   4   39 50                       89 8 47 23 0   7     0   4   39 50                 89
940688 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_9 27 14 3 0   1     0   3   23 25                       48 27 14 3 0   1     0   3   23 25                 48
940705 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_9 49 2 8 0   3     0   1   29 34                       63 49 2 8 0   3     0   1   29 34                 63
940740 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes 4 KG 11 2016   grade_9 15 4 1 0   8     0   2   17 13                       30 15 4 1 0   8     0   2   17 13                 30
942018 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_9 44 9 10 1   2     1   1   30 38                       68 44 9 10 1   2     1   1   30 38                 68
942031 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No 4 KG 12 2016   grade_9 108 11 14 0   2     1   8   51 93                       144 108 11 14 0   2     1   8   51 93                 144
1124659 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_9 3 0 6 0   0     0   0   6 3                       9 3 0 6 0   0     0   0   6 3                 9
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
1131217 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   grade_9 12 36 76 0   2     0   4   59 71                       130 12 36 76 0   2     0   4   59 71                 130
1131310 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_9 28 33 43 0   6     0   7   59 58                       117 28 33 43 0   6     0   7   59 58                 117
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
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
1131458 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_9 * * * *   *     *   *   1 2                       *                         1 2                  
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
1131589 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_9 7 41 26 1   7     0   0   45 37                       82 7 41 26 1   7     0   0   45 37                 82
1131603 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_9 45 30 2 0   3     1   2   45 38                       83 45 30 2 0   3     1   2   45 38                 83
1131622 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_9 42 7 11 1   0     0   1   23 39                       62 42 7 11 1   0     0   1   23 39                 62
1131643 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2017   grade_9 18 19 14 0   12     0   1   39 25                       64 18 19 14 0   12     0   1   39 25                 64
1131666 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2017   grade_9 9 1 1 0   2     0   1   2 12                       14 9 1 1 0   2     0   1   2 12                 14
1133191 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_9 51 9 16 0   2     0   3   35 46                       81 51 9 16 0   2     0   3   35 46                 81
1133205 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_9 157 13 23 1   4     1   11   95 115                       210 157 13 23 1   4     1   11   95 115                 210
1365783 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_9 3 24 26 1   1     0   1   41 15 *                     56.0 3 24 26 1   1     0   1   41 15                 56
1367067 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_9 1 1 5 0   0     0   0   5 2 *                     7.0 1 1 5 0   0     0   0   5 2                 7
1368064 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_9 2 0 9 0   0     0   0   10 1 *                     11.0 2 0 9 0   0     0   0   10 1                 11
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
1372556 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2020   grade_9 7 20 97 0   4     0   2   74 56 *                     130.0 7 20 97 0   4     0   2   74 56                 130
1372642 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_9 19 24 42 0   5     0   7   49 48 *                     97.0 19 24 42 0   5     0   7   49 48                 97
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
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
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
1372891 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_9 9 53 19 0   4     0   4   45 44 *                     89.0 9 53 19 0   4     0   4   45 44                 89
1372904 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_9 44 28 2 0   6     0   6   48 37 *                     86.0 44 28 2 0   6     0   6   48 37                 86
1372921 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_9 56 7 18 0   2     0   1   38 46 *                     84.0 56 7 18 0   2     0   1   38 46                 84
1372944 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2020   grade_9 15 18 23 2   2     0   1   31 30 *                     61.0 15 18 23 2   2     0   1   31 30                 61
1372965 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_9 13 0 3 0   5     1   4   10 16 *                     26.0 13 0 3 0   5     1   4   10 16                 26
1374205 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_9 9 6 11 0   16     0   1   24 19 *                     43.0 9 6 11 0   16     0   1   24 19                 43
1374289 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_9 62 5 21 1   7     1   13   53 57 *                     110.0 62 5 21 1   7     1   13   53 57                 110
1374302 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2020   grade_9 248 21 71 1   8     0   29   176 202 *                     378.0 248 21 71 1   8     0   29   176 202                 378
1673020 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_9 1 10 13 0   0     0   2   21 5 *                     26.0 1 10 13 0   0     0   2   21 5                 26
1674297 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_9 2 2 1 0   0     0   1   4 2 *                     6.0 2 2 1 0   0     0   1   4 2                 6
1675308 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_9 1 0 10 0   0     0   0   9 2 *                     11.0 1 0 10 0   0     0   0   9 2                 11
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
1679819 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District) - KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2021   grade_9 4 23 99 0   3     0   1   65 65 *                     130.0 4 23 99 0   3     0   1   65 65                 130
1679905 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District) - Sabis International Charter School   Regular School Yes Other KG 12 2021   grade_9 22 34 47 0   3     0   2   51 57 *                     108.0 22 34 47 0   3     0   2   51 57                 108
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
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
1680044 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_9 6 0 2 0   0     0   1   1 8 *                     9.0 6 0 2 0   0     0   1   1 8                 9
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
1680156 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 2021   grade_9 17 48 18 0   9     0   4   59 37 *                     96.0 17 48 18 0   9     0   4   59 37                 96
1680169 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_9 28 38 4 0   9     0   7   43 42 *                     86.0 28 38 4 0   9     0   7   43 42                 86
1680186 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_9 33 5 19 0   1     0   0   30 28 *                     58.0 33 5 19 0   1     0   0   30 28                 58

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