Data source: Big Local News · About: Big Local

6,218 rows where grade = "grade_5" and state = "MA" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • grade_5 · 6,218
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
1368462 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1374312 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1675703 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_5 * * * *   *     *   *   * * *                     0.0                                             0
1123136 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_5 2 4 10 0   0     0   0   12 4                       16 2 4 10 0   0     0   0   12 4                 16
1123249 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_5 7 18 9 0   3     0   1   20 18                       38 7 18 9 0   3     0   1   20 18                 38
1123667 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_5 * * * *   *     *   *   1 1                       *                         1 1                  
1124657 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_5 1 2 3 0   0     0   0   5 1                       6 1 2 3 0   0     0   0   5 1                 6
1125882 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_5 2 0 9 0   0     0   0   9 2                       11 2 0 9 0   0     0   0   9 2                 11
1131110 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_5 19 4 138 1   3     1   2   87 81                       168 19 4 138 1   3     1   2   87 81                 168
1131125 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1131205 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_5 11 97 71 0   3     0   2   87 97                       184 11 97 71 0   3     0   2   87 97                 184
1131213 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_5 5 18 100 0   2     0   1   66 60                       126 5 18 100 0   2     0   1   66 60                 126
1131242 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_5 72 0 11 0   7     0   10   44 56                       100 72 0 11 0   7     0   10   44 56                 100
1131270 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_5 0 16 3 0   0     0   0   8 11                       19 0 16 3 0   0     0   0   8 11                 19
1131306 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_5 32 40 48 0   5     0   3   68 60                       128 32 40 48 0   5     0   3   68 60                 128
1131331 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_5 30 61 19 0   5     1   2   57 61                       118 30 61 19 0   5     1   2   57 61                 118
1131345 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_5 52 36 6 0   13     0   3   47 63                       110 52 36 6 0   13     0   3   47 63                 110
1131364 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes Other 05 12 2017   grade_5 29 36 23 1   4     0   3   52 44                       96 29 36 23 1   4     0   3   52 44                 96
1131454 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_5 15 2 0 0   0     0   1   7 11                       18 15 2 0 0   0     0   1   7 11                 18
1131472 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_5 3 27 61 0   0     1   1   43 50                       93 3 27 61 0   0     1   1   43 50                 93
1131486 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_5 64 31 11 0   31     0   6   66 77                       143 64 31 11 0   31     0   6   66 77                 143
1131546 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes Other 05 12 2017   grade_5 75 2 3 1   2     0   7   47 43                       90 75 2 3 1   2     0   7   47 43                 90
1131555 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes Other 05 10 2017   grade_5 3 137 93 0   6     1   4   139 105                       244 3 137 93 0   6     1   4   139 105                 244
1131585 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_5 22 56 9 1   7     0   3   53 45                       98 22 56 9 1   7     0   3   53 45                 98
1131599 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_5 30 16 1 0   4     0   2   26 27                       53 30 16 1 0   4     0   2   26 27                 53
1131618 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_5 82 4 10 0   2     0   2   47 53                       100 82 4 10 0   2     0   2   47 53                 100
1131648 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_5 34 10 34 1   0     0   1   39 41                       80 34 10 34 1   0     0   1   39 41                 80
1131662 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_5 24 1 1 0   7     0   6   17 22                       39 24 1 1 0   7     0   6   17 22                 39
1133187 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_5 27 5 5 0   2     0   0   22 17                       39 27 5 5 0   2     0   0   22 17                 39
1133201 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_5 21 6 8 0   2     0   3   22 18                       40 21 6 8 0   2     0   3   22 18                 40
1365779 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_5 0 10 5 0   0     0   1   14 2 *                     16.0 0 10 5 0   0     0   1   14 2                 16
1365881 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_5 18 14 11 0   4     0   0   26 21 *                     47.0 18 14 11 0   4     0   0   26 21                 47
1366047 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_5 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1367685 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_5 * * * *   *     *   *   4 * *                     5.0                         4                   5
1368060 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_5 0 0 11 0   0     0   0   6 5 *                     11.0 0 0 11 0   0     0   0   6 5                 11
1368424 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_5 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1369342 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_5 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
1372552 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_5 3 34 82 1   4     0   4   63 65 *                     128.0 3 34 82 1   4     0   4   63 65                 128
1372605 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_5 0 17 1 0   0     0   1   10 9 *                     19.0 0 17 1 0   0     0   1   10 9                 19
1372638 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_5 23 43 81 0   8     0   5   81 79 *                     160.0 23 43 81 0   8     0   5   81 79                 160
1372652 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_5 15 24 22 0   2     0   2   35 30 *                     65.0 15 24 22 0   2     0   2   35 30                 65
1372664 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_5 22 67 18 0   3     0   6   61 55 *                     116.0 22 67 18 0   3     0   6   61 55                 116
1372677 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_5 47 73 10 0   12     0   7   77 72 *                     149.0 47 73 10 0   12     0   7   77 72                 149
1372776 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_5 11 0 0 1   0     0   4   8 8 *                     16.0 11 0 0 1   0     0   4   8 8                 16
1372791 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_5 1 44 46 1   2     0   1   37 58 *                     95.0 1 44 46 1   2     0   1   37 58                 95
1372804 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_5 63 30 6 1   18     0   10   58 70 *                     128.0 63 30 6 1   18     0   10   58 70                 128
1372887 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_5 9 47 19 0   11     0   4   53 37 *                     90.0 9 47 19 0   11     0   4   53 37                 90
1372900 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_5 43 21 3 0   6     0   7   39 41 *                     80.0 43 21 3 0   6     0   7   39 41                 80
1372917 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_5 91 5 8 0   2     0   4   48 62 *                     110.0 91 5 8 0   2     0   4   48 62                 110
1372940 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_5 25 11 23 0   8     0   0   30 37 *                     67.0 25 11 23 0   8     0   0   30 37                 67
1372961 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_5 22 0 4 0   12     0   8   20 26 *                     46.0 22 0 4 0   12     0   8   20 26                 46
1374201 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_5 13 18 38 1   23     0   0   49 44 *                     93.0 13 18 38 1   23     0   0   49 44                 93
1374285 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_5 15 6 7 0   2     0   4   23 11 *                     34.0 15 6 7 0   2     0   4   23 11                 34
1374298 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_5 33 9 14 0   3     0   9   37 31 *                     68.0 33 9 14 0   3     0   9   37 31                 68
1673017 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_5 0 6 8 1   0     0   0   13 2 *                     15.0 0 6 8 1   0     0   0   13 2                 15
1673118 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_5 16 17 6 1   5     0   2   23 24 *                     47.0 16 17 6 1   5     0   2   23 24                 47
1673282 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_5 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1673451 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_5 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1674293 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_5 1 2 2 0   0     0   1   5 1 *                     6.0 1 2 2 0   0     0   1   5 1                 6
1674429 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_5 6 0 0 0   0     0   1   6 1 *                     7.0 6 0 0 0   0     0   1   6 1                 7
1676590 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_5 4 1 7 0   0     0   0   10 2 *                     12.0 4 1 7 0   0     0   0   10 2                 12
1679802 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_5 8 101 62 0   2     0   4   82 95 *                     177.0 8 101 62 0   2     0   4   82 95                 177
1679815 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_5 6 23 90 0   6     0   3   71 57 *                     128.0 6 23 90 0   6     0   3   71 57                 128
1679868 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_5 0 15 6 0   0     0   0   9 12 *                     21.0 0 15 6 0   0     0   0   9 12                 21
1679901 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_5 19 39 59 0   5     0   7   68 61 *                     129.0 19 39 59 0   5     0   7   68 61                 129
1679915 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_5 7 39 12 1   2     0   2   36 27 *                     63.0 7 39 12 1   2     0   2   36 27                 63
1679928 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_5 28 61 18 0   2     0   6   59 56 *                     115.0 28 61 18 0   2     0   6   59 56                 115
1679941 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_5 31 90 5 0   11     0   12   71 78 *                     149.0 31 90 5 0   11     0   12   71 78                 149
1680040 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_5 14 0 4 1   0     0   1   8 12 *                     20.0 14 0 4 1   0     0   1   8 12                 20
1680056 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_5 1 45 48 0   0     0   1   47 48 *                     95.0 1 45 48 0   0     0   1   47 48                 95
1680069 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_5 53 28 15 1   24     0   2   60 63 *                     123.0 53 28 15 1   24     0   2   60 63                 123
1680152 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_5 9 51 17 0   9     0   1   38 49 *                     87.0 9 51 17 0   9     0   1   38 49                 87
1680165 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_5 40 30 2 0   1     0   6   48 31 *                     79.0 40 30 2 0   1     0   6   48 31                 79
1680182 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_5 87 6 11 0   2     0   4   47 63 *                     110.0 87 6 11 0   2     0   4   47 63                 110
1680204 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_5 21 20 19 1   4     0   0   36 29 *                     65.0 21 20 19 1   4     0   0   36 29                 65
1680225 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_5 17 5 8 0   9     0   5   22 22 *                     44.0 17 5 8 0   9     0   5   22 22                 44
1681449 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_5 16 26 39 0   35     0   4   50 70 *                     120.0 16 26 39 0   35     0   4   50 70                 120
1681523 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_5 31 5 8 0   2     0   2   27 21 0                     48.0 31 5 8 0   2     0   2   27 21 0               48
1681536 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_5 67 9 29 1   7     0   7   59 61 *                     120.0 67 9 29 1   7     0   7   59 61                 120
2040822 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_5 1 10 8 0   0     0   0   14 5                       19.0 1 10 8 0   0     0   0   14 5                 19
2040925 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_5 9 15 12 0   2     0   3   24 17                       41.0 9 15 12 0   2     0   3   24 17                 41
2041286 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 03 12 2019   grade_5 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042135 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_5 2 1 3 0   0     0   0   5 1                       6.0 2 1 3 0   0     0   0   5 1                 6
2042769 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_5 * * * *   *     *   *   5 *                       5.0                         5                   5
2043145 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2019   grade_5 0 0 8 0   0     0   0   7 1                       8.0 0 0 8 0   0     0   0   7 1                 8
2043507 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_5 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2047614 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_5 5 102 67 0   5     0   2   87 94                       181.0 5 102 67 0   5     0   2   87 94                 181
2047625 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_5 3 32 79 0   6     0   2   59 63                       122.0 3 32 79 0   6     0   2   59 63                 122
2047677 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_5 0 15 4 0   0     0   0   11 8                       19.0 0 15 4 0   0     0   0   11 8                 19
2047710 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_5 20 42 50 0   9     0   7   63 65                       128.0 20 42 50 0   9     0   7   63 65                 128
2047724 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_5 10 37 15 1   2     0   3   27 41                       68.0 10 37 15 1   2     0   3   27 41                 68
2047735 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_5 14 78 22 0   4     0   0   52 66                       118.0 14 78 22 0   4     0   0   52 66                 118
2047748 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_5 59 58 5 2   15     1   7   67 80                       147.0 59 58 5 2   15     1   7   67 80                 147
2047847 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_5 14 0 1 0   0     0   2   4 13                       17.0 14 0 1 0   0     0   2   4 13                 17
2047863 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_5 2 46 43 0   0     0   3   41 53                       94.0 2 46 43 0   0     0   3   41 53                 94
2047876 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_5 72 26 9 0   32     0   8   80 67                       147.0 72 26 9 0   32     0   8   80 67                 147
2047959 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_5 10 55 24 0   7     1   2   51 48                       99.0 10 55 24 0   7     1   2   51 48                 99
2047972 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_5 38 22 3 0   3     0   9   38 37                       75.0 38 22 3 0   3     0   9   38 37                 75
2047989 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_5 93 2 13 0   2     0   0   49 61                       110.0 93 2 13 0   2     0   0   49 61                 110

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