Data source: Big Local News · About: Big Local

2,748 rows where grade = "grade_12" and state = "MA" sorted by ccd_school_low_grade descending

View and edit SQL

year

grade

  • grade_12 · 2,748
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
1368469 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1374319 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
1675710 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_12 * * * *   *     *   *   * * *                     0.0                                             0
736962 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2015   grade_12 1 5 4 0   1     0   0   4 7                       11 1 5 4 0   1     0   0   4 7                 11
743549 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_12 2 18 8 0   1     0   0   10 19                       29 2 18 8 0   1     0   0   10 19                 29
743745 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2015   grade_12 2 34 20 0   0     0   1   27 30                       57 2 34 20 0   0     0   1   27 30                 57
933822 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No 4 PK 12 2016   grade_12 * * * *   *     *   *   1 1                       2                         1 1                 2
940372 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_12 0 17 2 0   0     0   0   10 9                       19 0 17 2 0   0     0   0   10 9                 19
940574 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes 4 PK 12 2016   grade_12 2 41 20 0   0     0   0   26 37                       63 2 41 20 0   0     0   0   26 37                 63
1123453 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_12 1 2 2 0   2     0   0   5 2                       7 1 2 2 0   2     0   0   5 2                 7
1131277 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_12 0 30 2 0   0     0   0   13 19                       32 0 30 2 0   0     0   0   13 19                 32
1131479 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_12 4 40 15 1   1     0   0   29 32                       61 4 40 15 1   1     0   0   29 32                 61
1368614 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_12 28 12 186 0   10     0   7   137 106 *                     243.0 28 12 186 0   10     0   7   137 106                 243
1372612 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_12 0 24 10 0   0     0   0   20 14 *                     34.0 0 24 10 0   0     0   0   20 14                 34
1372798 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_12 3 34 36 0   0     0   2   37 38 *                     75.0 3 34 36 0   0     0   2   37 38                 75
1675855 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_12 39 19 161 0   15     0   6   135 105 *                     240.0 39 19 161 0   15     0   6   135 105                 240
1679875 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_12 1 16 5 1   0     0   0   8 15 *                     23.0 1 16 5 1   0     0   0   8 15                 23
1679922 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_12 8 33 10 0   1     0   2   31 23 *                     54.0 8 33 10 0   1     0   2   31 23                 54
1680063 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_12 2 40 29 1   0     0   1   38 35 *                     73.0 2 40 29 1   0     0   1   38 35                 73
2041105 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_12 0 4 6 0   1     0   0   5 6                       11.0 0 4 6 0   1     0   0   5 6                 11
2047684 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_12 0 30 8 0   0     2   0   20 20                       40.0 0 30 8 0   0     2   0   20 20                 40
2047870 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_12 3 33 31 1   0     0   1   30 39                       69.0 3 33 31 1   0     0   1   30 39                 69
2230272 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_12 1 0 5 0   1     0   1   4 4                       8.0 1 0 5 0   1     0   1   4 4                 8
2238108 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_12 0 21 7 0   0     0   0   20 8                       28.0 0 21 7 0   0     0   0   20 8                 28
2238312 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_12 4 40 28 2   0     0   1   38 37                       75.0 4 40 28 2   0     0   1   38 37                 75
736683 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_12 5 20 5 1   0     0   1   20 12                       32 5 20 5 1   0     0   1   20 12                 32
743582 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_12 39 31 31 0   0     0   9   47 63                       110 39 31 31 0   0     0   9   47 63                 110
743614 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_12 23 25 17 0   5     0   9   31 48                       79 23 25 17 0   5     0   9   31 48                 79
743627 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_12 31 19 3 0   6     0   5   33 31                       64 31 19 3 0   6     0   5   33 31                 64
743726 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_12 10 0 0 0   0     0   0   6 4                       10 10 0 0 0   0     0   0   6 4                 10
743758 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_12 61 15 3 0   14     0   3   50 46                       96 61 15 3 0   14     0   3   50 46                 96
743848 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_12 15 37 9 0   2     0   0   33 30                       63 15 37 9 0   2     0   0   33 30                 63
743861 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_12 31 12 0 0   0     0   2   31 14                       45 31 12 0 0   0     0   2   31 14                 45
745185 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_12 15 0 0 0   1     0   0   5 11                       16 15 0 0 0   1     0   0   5 11                 16
745198 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_12 9 1 1 0   1     0   1   3 10                       13 9 1 1 0   1     0   1   3 10                 13
933550 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_12 1 27 16 0   1     0   0   35 10                       45 1 27 16 0   1     0   0   35 10                 45
934840 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No 4 KG 12 2016   grade_12 * * * *   *     *   *   1 1                       2                         1 1                 2
940405 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_12 29 37 32 0   2     0   8   50 58                       108 29 37 32 0   2     0   8   50 58                 108
940437 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_12 19 23 28 0   3     0   6   36 43                       79 19 23 28 0   3     0   6   36 43                 79
940450 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_12 34 21 4 0   6     0   2   25 42                       67 34 21 4 0   6     0   2   25 42                 67
940555 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_12 8 1 0 0   0     0   0   7 2                       9 8 1 0 0   0     0   0   7 2                 9
940587 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_12 65 19 2 0   14     0   4   46 58                       104 65 19 2 0   14     0   4   46 58                 104
940678 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_12 11 48 16 0   4     0   1   34 46                       80 11 48 16 0   4     0   1   34 46                 80
940691 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_12 27 12 1 0   0     0   5   24 21                       45 27 12 1 0   0     0   5   24 21                 45
942021 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_12 27 0 4 0   0     1   0   11 21                       32 27 0 4 0   0     1   0   11 21                 32
942034 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_12 51 5 4 0   3     0   5   18 50                       68 51 5 4 0   3     0   5   18 50                 68
1124662 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_12 * * * *   *     *   *   3 2                       *                         3 2                  
1131220 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_12 9 27 54 0   2     0   2   43 51                       94 9 27 54 0   2     0   2   43 51                 94
1131313 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_12 35 28 35 0   0     0   4   41 61                       102 35 28 35 0   0     0   4   41 61                 102
1131338 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_12 31 29 15 0   4     0   2   33 48                       81 31 29 15 0   4     0   2   33 48                 81
1131352 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_12 27 22 4 0   3     0   3   24 35                       59 27 22 4 0   3     0   3   24 35                 59
1131461 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_12 9 0 2 0   0     0   1   5 7                       12 9 0 2 0   0     0   1   5 7                 12
1131493 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_12 53 24 3 0   13     0   3   41 55                       96 53 24 3 0   13     0   3   41 55                 96
1131592 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_12 11 38 17 0   4     0   3   37 36                       73 11 38 17 0   4     0   3   37 36                 73
1131606 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_12 31 14 0 0   3     0   1   32 17                       49 31 14 0 0   3     0   1   32 17                 49
1131646 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_12 11 18 8 0   4     0   0   26 15                       41 11 18 8 0   4     0   0   26 15                 41
1131669 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_12 5 1 0 0   5     0   0   8 3                       11 5 1 0 0   5     0   0   8 3                 11
1133194 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_12 22 1 4 0   0     0   3   5 25                       30 22 1 4 0   0     0   3   5 25                 30
1133208 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_12 90 6 14 0   4     0   3   38 79                       117 90 6 14 0   4     0   3   38 79                 117
1365786 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_12 3 13 11 0   0     0   0   19 8 *                     27.0 3 13 11 0   0     0   0   19 8                 27
1368067 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_12 2 0 5 0   0     0   0   4 3 *                     7.0 2 0 5 0   0     0   0   4 3                 7
1372546 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_12 1 30 23 0   1     0   1   20 36 *                     56.0 1 30 23 0   1     0   1   20 36                 56
1372559 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_12 8 35 65 0   2     0   4   48 66 *                     114.0 8 35 65 0   2     0   4   48 66                 114
1372645 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_12 20 28 31 0   5     0   8   48 44 *                     92.0 20 28 31 0   5     0   8   48 44                 92
1372671 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_12 23 35 19 0   5     0   2   38 46 *                     84.0 23 35 19 0   5     0   2   38 46                 84
1372684 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_12 21 29 4 0   6     0   3   27 36 *                     63.0 21 29 4 0   6     0   3   27 36                 63
1372782 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_12 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1372811 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_12 48 12 3 2   14     0   3   32 50 *                     82.0 48 12 3 2   14     0   3   32 50                 82
1372894 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_12 6 31 14 1   7     0   1   27 33 *                     60.0 6 31 14 1   7     0   1   27 33                 60
1372907 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_12 35 26 2 0   2     1   3   37 32 *                     69.0 35 26 2 0   2     1   3   37 32                 69
1372924 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_12 41 7 11 1   0     0   0   20 40 *                     60.0 41 7 11 1   0     0   0   20 40                 60
1372947 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_12 14 11 10 2   11     0   0   26 22 *                     48.0 14 11 10 2   11     0   0   26 22                 48
1372968 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_12 7 0 0 0   0     0   1   1 7 *                     8.0 7 0 0 0   0     0   1   1 7                 8
1374292 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_12 47 3 8 0   0     0   6   25 39 *                     64.0 47 3 8 0   0     0   6   25 39                 64
1374305 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_12 205 8 39 0   12     1   12   91 186 *                     277.0 205 8 39 0   12     1   12   91 186                 277
1673023 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_12 4 13 17 0   1     0   0   25 10 *                     35.0 4 13 17 0   1     0   0   25 10                 35
1674300 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_12 * * * *   *     *   *   1 1 *                     3.0                         1 1                 3
1675311 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_12 0 0 12 0   0     0   0   10 2 *                     12.0 0 0 12 0   0     0   0   10 2                 12
1679809 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_12 0 26 14 0   1     0   0   18 23 *                     41.0 0 26 14 0   1     0   0   18 23                 41
1679822 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_12 9 26 75 0   4     0   4   51 67 *                     118.0 9 26 75 0   4     0   4   51 67                 118
1679908 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_12 38 21 31 0   4     0   7   46 55 *                     101.0 38 21 31 0   4     0   7   46 55                 101
1679935 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_12 16 43 20 0   6     0   1   33 53 *                     86.0 16 43 20 0   6     0   1   33 53                 86
1679948 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_12 22 25 4 0   9     1   2   22 41 *                     63.0 22 25 4 0   9     1   2   22 41                 63
1680047 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_12 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1680076 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_12 48 11 3 0   22     0   2   42 44 *                     86.0 48 11 3 0   22     0   2   42 44                 86
1680159 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_12 6 42 16 0   7     0   1   35 37 *                     72.0 6 42 16 0   7     0   1   35 37                 72
1680172 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_12 43 18 6 2   4     0   3   40 36 *                     76.0 43 18 6 2   4     0   3   40 36                 76
1680189 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_12 61 4 15 0   4     0   2   50 36 *                     86.0 61 4 15 0   4     0   2   50 36                 86
1680211 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_12 8 15 20 2   7     0   1   20 33 *                     53.0 8 15 20 2   7     0   1   20 33                 53
1680232 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_12 13 5 1 0   4     0   5   13 15 *                     28.0 13 5 1 0   4     0   5   13 15                 28
1681530 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_12 66 6 16 0   1     0   4   24 67 2                     93.0 66 6 16 0   1     0   4   24 67 2               93
1681543 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_12 212 16 47 0   4     1   19   96 203 *                     299.0 212 16 47 0   4     1   19   96 203                 299
2047632 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2019   grade_12 5 35 65 0   4     0   4   53 60                       113.0 5 35 65 0   4     0   4   53 60                 113
2047717 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_12 28 40 32 0   6     0   5   48 63                       111.0 28 40 32 0   6     0   5   48 63                 111
2047742 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_12 23 35 16 0   5     1   3   48 35                       83.0 23 35 16 0   5     1   3   48 35                 83
2047755 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_12 22 28 3 0   8     0   2   36 26                       63.0 22 28 3 0   8     0   2   36 26                 63
2047854 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_12 9 0 1 0   0     0   0   5 5                       10.0 9 0 1 0   0     0   0   5 5                 10
2047883 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_12 48 12 6 0   21     0   2   45 44                       89.0 48 12 6 0   21     0   2   45 44                 89
2047966 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_12 7 39 14 0   7     0   3   32 38                       70.0 7 39 14 0   7     0   3   32 38                 70
2047979 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2019   grade_12 38 15 3 1   0     0   5   30 32                       62.0 38 15 3 1   0     0   5   30 32                 62

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