Data source: Big Local News · About: Big Local

6,880 rows where grade = "grade_1" and state = "MA" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • grade_1 · 6,880
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
1368458 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1374308 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1675699 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_1 * * * *   *     *   *   * * *                     0.0                                             0
1123444 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_1 * * * *   *     *   *   2 3                       *                         2 3                  
1125878 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_1 1 0 7 0   0     0   0   5 3                       8 1 0 7 0   0     0   0   5 3                 8
1131201 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_1 8 95 73 0   2     0   4   87 95                       182 8 95 73 0   2     0   4   87 95                 182
1131212 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_1 5 24 84 0   6     0   4   68 55                       123 5 24 84 0   6     0   4   68 55                 123
1131266 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_1 0 17 5 0   0     0   0   11 11                       22 0 17 5 0   0     0   0   11 11                 22
1131302 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_1 20 31 50 0   5     0   6   60 52                       112 20 31 50 0   5     0   6   60 52                 112
1131327 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_1 31 55 20 0   2     0   5   54 59                       113 31 55 20 0   2     0   5   54 59                 113
1131341 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_1 43 49 3 0   10     0   9   53 61                       114 43 49 3 0   10     0   9   53 61                 114
1131450 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_1 13 0 1 0   0     0   1   6 9                       15 13 0 1 0   0     0   1   6 9                 15
1131468 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_1 4 39 48 0   2     0   3   44 52                       96 4 39 48 0   2     0   3   44 52                 96
1131482 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_1 52 28 14 0   21     0   5   62 58                       120 52 28 14 0   21     0   5   62 58                 120
1131581 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_1 10 45 20 0   10     0   1   38 48                       86 10 45 20 0   10     0   1   38 48                 86
1131595 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_1 34 8 3 0   4     0   2   27 24                       51 34 8 3 0   4     0   2   27 24                 51
1131614 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_1 86 5 8 0   2     0   5   46 60                       106 86 5 8 0   2     0   5   46 60                 106
1131639 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_1 19 20 22 0   5     0   0   34 32                       66 19 20 22 0   5     0   0   34 32                 66
1131658 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_1 24 2 6 0   7     0   5   21 23                       44 24 2 6 0   7     0   5   21 23                 44
1133183 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_1 18 6 6 0   0     0   2   16 16                       32 18 6 6 0   0     0   2   16 16                 32
1133197 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_1 15 3 3 1   1     0   4   17 10                       27 15 3 3 1   1     0   4   17 10                 27
1366043 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_1 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1367063 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_1 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368058 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_1 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368421 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_1 1 3 1 0   1     0   1   5 2 *                     7.0 1 3 1 0   1     0   1   5 2                 7
1372535 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_1 17 86 78 0   3     0   5   82 107 *                     189.0 17 86 78 0   3     0   5   82 107                 189
1372548 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_1 8 14 98 0   1     2   1   53 71 *                     124.0 8 14 98 0   1     2   1   53 71                 124
1372601 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_1 0 8 12 0   0     0   0   9 11 *                     20.0 0 8 12 0   0     0   0   9 11                 20
1372634 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_1 26 35 47 0   2     0   5   66 49 *                     115.0 26 35 47 0   2     0   5   66 49                 115
1372648 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_1 5 21 12 0   2     0   2   20 22 *                     42.0 5 21 12 0   2     0   2   20 22                 42
1372660 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_1 18 61 31 3   2     0   5   54 66 *                     120.0 18 61 31 3   2     0   5   54 66                 120
1372673 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_1 38 70 10 0   15     0   11   80 64 *                     144.0 38 70 10 0   15     0   11   80 64                 144
1372772 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_1 15 0 2 0   0     0   0   6 11 *                     17.0 15 0 2 0   0     0   0   6 11                 17
1372787 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_1 1 58 39 0   0     0   0   44 54 *                     98.0 1 58 39 0   0     0   0   44 54                 98
1372800 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_1 62 24 22 0   43     0   5   72 84 *                     156.0 62 24 22 0   43     0   5   72 84                 156
1372883 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_1 10 41 23 0   3     0   8   33 52 *                     85.0 10 41 23 0   3     0   8   33 52                 85
1372896 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_1 39 30 4 0   4     0   5   38 44 *                     82.0 39 30 4 0   4     0   5   38 44                 82
1372913 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_1 89 5 7 0   3     1   5   54 56 *                     110.0 89 5 7 0   3     1   5   54 56                 110
1372936 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_1 24 14 16 1   5     0   3   31 32 *                     63.0 24 14 16 1   5     0   3   31 32                 63
1372957 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_1 20 1 4 0   10     0   10   24 21 *                     45.0 20 1 4 0   10     0   10   24 21                 45
1374197 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_1 18 20 33 0   31     0   5   46 61 *                     107.0 18 20 33 0   31     0   5   46 61                 107
1374281 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_1 11 2 2 0   2     0   2   6 13 *                     19.0 11 2 2 0   2     0   2   6 13                 19
1374294 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_1 21 7 10 0   1     0   2   25 16 *                     41.0 21 7 10 0   1     0   2   25 16                 41
1675663 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_1 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1679798 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_1 8 101 72 1   5     0   8   81 114 *                     195.0 8 101 72 1   5     0   8   81 114                 195
1679811 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_1 13 13 95 0   1     0   2   65 59 *                     124.0 13 13 95 0   1     0   2   65 59                 124
1679864 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_1 1 14 5 0   0     0   1   12 9 *                     21.0 1 14 5 0   0     0   1   12 9                 21
1679897 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_1 11 38 54 0   0     0   8   50 61 *                     111.0 11 38 54 0   0     0   8   50 61                 111
1679911 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_1 7 18 11 1   0     0   2   23 16 *                     39.0 7 18 11 1   0     0   2   23 16                 39
1679924 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_1 26 65 7 1   4     0   13   55 61 *                     116.0 26 65 7 1   4     0   13   55 61                 116
1679937 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_1 43 66 10 0   24     0   7   74 76 *                     150.0 43 66 10 0   24     0   7   74 76                 150
1680036 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_1 12 0 1 0   0     0   0   7 6 *                     13.0 12 0 1 0   0     0   0   7 6                 13
1680052 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_1 1 47 41 1   0     2   3   51 44 *                     95.0 1 47 41 1   0     2   3   51 44                 95
1680065 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_1 70 20 13 0   45     0   11   72 87 *                     159.0 70 20 13 0   45     0   11   72 87                 159
1680148 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_1 12 57 9 0   6     0   2   43 43 *                     86.0 12 57 9 0   6     0   2   43 43                 86
1680161 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_1 30 26 5 1   5     0   9   41 34 *                     76.0 30 26 5 1   5     0   9   41 34                 76
1680178 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_1 72 7 20 0   4     0   7   52 58 *                     110.0 72 7 20 0   4     0   7   52 58                 110
1680200 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_1 25 12 17 0   3     0   2   26 33 *                     59.0 25 12 17 0   3     0   2   26 33                 59
1680221 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_1 23 5 1 0   12     0   3   23 20 *                     44.0 23 5 1 0   12     0   3   23 20                 44
1681445 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_1 14 17 30 0   22     0   1   46 38 *                     84.0 14 17 30 0   22     0   1   46 38                 84
1681519 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_1 23 3 10 0   1     0   0   16 21 0                     37.0 23 3 10 0   1     0   0   16 21 0               37
1681532 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_1 25 11 15 0   2     0   5   34 24 *                     58.0 25 11 15 0   2     0   5   34 24                 58
2041096 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_1 2 4 2 0   0     0   0   5 3                       8.0 2 4 2 0   0     0   0   5 3                 8
2042765 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   1 *                       1.0                         1                   1
2043143 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_1 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2043505 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_1 1 2 3 0   0     0   0   5 1                       6.0 1 2 3 0   0     0   0   5 1                 6
2047610 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_1 4 92 76 0   5     0   2   86 93                       179.0 4 92 76 0   5     0   2   86 93                 179
2047622 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_1 9 18 85 0   4     0   6   54 68                       122.0 9 18 85 0   4     0   6   54 68                 122
2047673 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_1 0 17 3 0   0     0   0   8 12                       20.0 0 17 3 0   0     0   0   8 12                 20
2047706 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_1 20 32 56 0   3     0   7   58 60                       118.0 20 32 56 0   3     0   7   58 60                 118
2047720 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_1 6 18 9 0   3     0   4   17 23                       40.0 6 18 9 0   3     0   4   17 23                 40
2047731 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_1 16 55 30 1   5     0   7   40 74                       114.0 16 55 30 1   5     0   7   40 74                 114
2047744 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_1 51 60 10 0   23     1   3   70 78                       148.0 51 60 10 0   23     1   3   70 78                 148
2047843 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_1 8 0 4 1   0     0   1   8 6                       14.0 8 0 4 1   0     0   1   8 6                 14
2047859 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_1 1 52 40 0   1     1   2   49 48                       97.0 1 52 40 0   1     1   2   49 48                 97
2047872 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_1 53 29 21 1   47     0   4   78 77                       155.0 53 29 21 1   47     0   4   78 77                 155
2047955 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_1 16 47 11 0   6     0   5   41 44                       85.0 16 47 11 0   6     0   5   41 44                 85
2047968 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_1 41 23 0 0   5     0   7   32 44                       76.0 41 23 0 0   5     0   7   32 44                 76
2047985 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_1 86 6 7 0   1     0   10   55 55                       110.0 86 6 7 0   1     0   10   55 55                 110
2048008 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science   Regular School Yes Other KG 12 2019   grade_1 22 21 20 0   0     0   1   32 32                       64.0 22 21 20 0   0     0   1   32 32                 64
2048029 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 2019   grade_1 20 4 2 0   12     0   6   25 19                       44.0 20 4 2 0   12     0   6   25 19                 44
2049350 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_1 13 7 2 0   1     0   1   10 14                       24.0 13 7 2 0   1     0   1   10 14                 24
2049363 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 2019   grade_1 27 9 16 1   1     0   5   36 23                       59.0 27 9 16 1   1     0   5   36 23                 59
2229937 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_1 1 1 4 0   0     0   1   6 1                       7.0 1 1 4 0   0     0   1   6 1                 7
2230263 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_1 3 2 2 0   0     0   0   6 1                       7.0 3 2 2 0   0     0   0   6 1                 7
2232238 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_1 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2238029 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_1 8 104 66 0   4     0   2   83 101                       184.0 8 104 66 0   4     0   2   83 101                 184
2238041 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 2018   grade_1 8 21 84 2   3     0   4   57 65                       122.0 8 21 84 2   3     0   4   57 65                 122
2238097 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_1 0 16 4 0   0     0   0   7 13                       20.0 0 16 4 0   0     0   0   7 13                 20
2238133 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 2018   grade_1 22 35 48 0   3     0   6   64 50                       114.0 22 35 48 0   3     0   6   64 50                 114
2238148 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_1 11 16 7 0   2     0   4   15 25                       40.0 11 16 7 0   2     0   4   15 25                 40
2238159 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_1 25 52 34 0   5     0   0   52 64                       116.0 25 52 34 0   5     0   0   52 64                 116
2238173 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_1 46 52 8 0   18     0   8   72 60                       132.0 46 52 8 0   18     0   8   72 60                 132
2238283 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 2018   grade_1 9 0 1 0   0     0   3   6 7                       13.0 9 0 1 0   0     0   3   6 7                 13
2238301 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_1 2 45 43 1   0     0   4   51 44                       95.0 2 45 43 1   0     0   4   51 44                 95
2238315 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_1 57 18 21 0   19     0   12   65 62                       127.0 57 18 21 0   19     0   12   65 62                 127
2238415 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_1 15 39 18 0   6     0   2   44 36                       80.0 15 39 18 0   6     0   2   44 36                 80
2238429 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 2018   grade_1 43 10 0 0   5     0   9   32 35                       67.0 43 10 0 0   5     0   9   32 35                 67
2238448 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_1 79 9 11 0   0     0   7   54 52                       106.0 79 9 11 0   0     0   7   54 52                 106
2238474 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 2018   grade_1 27 16 21 1   2     0   1   31 37                       68.0 27 16 21 1   2     0   1   31 37                 68

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