Data source: Big Local News · About: Big Local

6,831 rows where grade = "grade_2" and state = "MA" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • grade_2 · 6,831
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
1368459 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1374309 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1675700 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_2 * * * *   *     *   *   * * *                     0.0                                             0
1123133 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_2 1 5 0 0   0     0   0   4 2                       6 1 5 0 0   0     0   0   4 2                 6
1123445 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_2 0 5 3 0   0     0   1   7 2                       9 0 5 3 0   0     0   1   7 2                 9
1125422 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_2 * * * *   *     *   *   4 1                       *                         4 1                  
1125879 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_2 1 0 9 0   0     0   0   6 4                       10 1 0 9 0   0     0   0   6 4                 10
1131202 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_2 14 95 63 2   5     0   4   86 97                       183 14 95 63 2   5     0   4   86 97                 183
1131267 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_2 0 19 1 0   0     0   1   11 10                       21 0 19 1 0   0     0   1   11 10                 21
1131303 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_2 27 41 61 0   7     0   5   77 64                       141 27 41 61 0   7     0   5   77 64                 141
1131328 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_2 27 62 18 0   3     0   8   63 55                       118 27 62 18 0   3     0   8   63 55                 118
1131342 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_2 56 38 5 0   8     0   6   53 60                       113 56 38 5 0   8     0   6   53 60                 113
1131451 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_2 10 0 1 0   0     0   5   8 8                       16 10 0 1 0   0     0   5   8 8                 16
1131469 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_2 4 43 44 0   2     0   2   39 56                       95 4 43 44 0   2     0   2   39 56                 95
1131483 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_2 63 27 6 1   13     0   10   57 63                       120 63 27 6 1   13     0   10   57 63                 120
1131582 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_2 12 37 18 1   13     0   5   53 33                       86 12 37 18 1   13     0   5   53 33                 86
1131596 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_2 35 8 2 0   3     0   2   22 28                       50 35 8 2 0   3     0   2   22 28                 50
1131615 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_2 89 5 6 0   2     0   5   47 60                       107 89 5 6 0   2     0   5   47 60                 107
1131640 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_2 25 11 22 0   8     0   0   26 40                       66 25 11 22 0   8     0   0   26 40                 66
1131659 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_2 24 0 3 0   8     0   10   20 25                       45 24 0 3 0   8     0   10   20 25                 45
1133184 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_2 28 4 8 0   0     0   0   18 22                       40 28 4 8 0   0     0   0   18 22                 40
1133198 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_2 16 3 5 0   1     0   6   16 15                       31 16 3 5 0   1     0   6   16 15                 31
1365776 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_2 0 2 4 0   0     0   1   6 1 *                     7.0 0 2 4 0   0     0   1   6 1                 7
1365878 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_2 29 15 13 0   12     0   2   35 36 *                     71.0 29 15 13 0   12     0   2   35 36                 71
1366044 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_2 2 5 2 0   0     0   0   6 3 *                     9.0 2 5 2 0   0     0   0   6 3                 9
1367196 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_2 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1367682 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_2 * * * *   *     *   *   1 * *                     1.0                         1                   1
1368059 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_2 1 0 6 0   0     0   0   6 1 *                     7.0 1 0 6 0   0     0   0   6 1                 7
1368422 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_2 2 2 3 0   0     0   0   5 2 *                     7.0 2 2 3 0   0     0   0   5 2                 7
1368608 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2020   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1372536 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_2 4 95 81 0   5     0   2   91 96 *                     187.0 4 95 81 0   5     0   2   91 96                 187
1372549 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_2 9 19 86 0   4     0   6   58 66 *                     124.0 9 19 86 0   4     0   6   58 66                 124
1372602 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_2 1 17 3 0   0     0   0   9 12 *                     21.0 1 17 3 0   0     0   0   9 12                 21
1372635 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_2 24 41 74 0   3     0   7   77 72 *                     149.0 24 41 74 0   3     0   7   77 72                 149
1372649 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_2 6 16 14 0   2     0   3   15 26 *                     41.0 6 16 14 0   2     0   3   15 26                 41
1372661 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_2 19 56 29 1   6     0   8   42 77 *                     119.0 19 56 29 1   6     0   8   42 77                 119
1372674 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_2 48 69 11 0   20     1   4   74 79 *                     153.0 48 69 11 0   20     1   4   74 79                 153
1372773 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_2 11 0 2 1   0     0   1   9 6 *                     15.0 11 0 2 1   0     0   1   9 6                 15
1372788 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_2 1 53 40 0   1     1   2   48 50 *                     98.0 1 53 40 0   1     1   2   48 50                 98
1372801 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_2 58 25 17 1   49     0   5   78 77 *                     155.0 58 25 17 1   49     0   5   78 77                 155
1372884 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_2 16 52 12 0   5     0   5   48 42 *                     90.0 16 52 12 0   5     0   5   48 42                 90
1372897 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_2 45 23 2 1   3     0   6   31 49 *                     80.0 45 23 2 1   3     0   6   31 49                 80
1372914 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_2 86 6 7 0   1     0   10   55 55 *                     110.0 86 6 7 0   1     0   10   55 55                 110
1372937 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_2 20 19 24 0   0     0   1   33 31 *                     64.0 20 19 24 0   0     0   1   33 31                 64
1372958 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_2 21 4 2 0   11     0   6   24 20 *                     44.0 21 4 2 0   11     0   6   24 20                 44
1374198 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_2 11 23 34 0   43     0   3   59 55 *                     114.0 11 23 34 0   43     0   3   59 55                 114
1374282 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_2 13 6 5 0   3     0   1   11 17 *                     28.0 13 6 5 0   3     0   1   11 17                 28
1374295 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_2 22 8 16 0   3     1   4   28 26 *                     54.0 22 8 16 0   3     1   4   28 26                 54
1673014 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1673115 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_2 13 32 11 0   8     1   4   37 32 *                     69.0 13 32 11 0   8     1   4   37 32                 69
1673279 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_2 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1674291 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_2 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1675303 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_2 1 0 5 0   0     0   0   5 1 *                     6.0 1 0 5 0   0     0   0   5 1                 6
1675664 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_2 1 3 1 0   0     0   1   5 1 *                     6.0 1 3 1 0   0     0   1   5 1                 6
1679799 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_2 14 88 77 0   4     0   7   83 107 *                     190.0 14 88 77 0   4     0   7   83 107                 190
1679812 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_2 9 14 97 0   1     2   1   54 70 *                     124.0 9 14 97 0   1     2   1   54 70                 124
1679865 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_2 0 9 12 0   0     0   0   9 12 *                     21.0 0 9 12 0   0     0   0   9 12                 21
1679898 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_2 26 35 51 0   2     0   6   68 52 *                     120.0 26 35 51 0   2     0   6   68 52                 120
1679912 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_2 5 22 12 0   2     0   2   22 21 *                     43.0 5 22 12 0   2     0   2   22 21                 43
1679925 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_2 17 62 31 3   2     0   5   56 64 *                     120.0 17 62 31 3   2     0   5   56 64                 120
1679938 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_2 38 77 10 0   18     0   11   86 68 *                     154.0 38 77 10 0   18     0   11   86 68                 154
1680037 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_2 13 0 2 0   0     0   1   6 10 *                     16.0 13 0 2 0   0     0   1   6 10                 16
1680053 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_2 2 58 39 0   0     0   0   45 54 *                     99.0 2 58 39 0   0     0   0   45 54                 99
1680066 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_2 57 24 21 0   42     0   6   69 81 *                     150.0 57 24 21 0   42     0   6   69 81                 150
1680149 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_2 9 44 23 0   4     0   7   38 49 *                     87.0 9 44 23 0   4     0   7   38 49                 87
1680162 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_2 37 29 7 0   4     0   2   37 42 *                     79.0 37 29 7 0   4     0   2   37 42                 79
1680179 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_2 88 6 7 0   3     1   5   53 57 *                     110.0 88 6 7 0   3     1   5   53 57                 110
1680201 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_2 24 14 16 1   5     0   3   31 32 *                     63.0 24 14 16 1   5     0   3   31 32                 63
1680222 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_2 19 1 4 0   12     0   9   22 23 *                     45.0 19 1 4 0   12     0   9   22 23                 45
1681446 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_2 18 22 36 1   34     0   5   53 63 *                     116.0 18 22 36 1   34     0   5   53 63                 116
1681520 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_2 22 2 10 0   4     0   2   18 22 0                     40.0 22 2 10 0   4     0   2   18 22 0               40
1681533 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_2 38 9 19 1   5     0   8   42 38 *                     80.0 38 9 19 1   5     0   8   42 38                 80
2040819 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_2 3 1 3 0   0     0   1   7 1                       8.0 3 1 3 0   0     0   1   7 1                 8
2040922 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_2 17 26 15 0   7     0   6   41 30                       71.0 17 26 15 0   7     0   6   41 30                 71
2041097 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_2 3 1 2 0   0     0   0   5 1                       6.0 3 1 2 0   0     0   0   5 1                 6
2042766 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_2 * * * *   *     *   *   2 *                       2.0                         2                   2
2043506 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_2 4 0 2 0   2     0   0   7 1                       8.0 4 0 2 0   2     0   0   7 1                 8
2047611 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_2 8 103 68 0   4     0   2   84 101                       185.0 8 103 68 0   4     0   2   84 101                 185
2047623 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_2 7 24 82 2   3     0   4   58 64                       122.0 7 24 82 2   3     0   4   58 64                 122
2047674 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_2 0 16 4 0   0     0   0   7 13                       20.0 0 16 4 0   0     0   0   7 13                 20
2047707 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_2 21 38 57 0   4     0   6   69 57                       126.0 21 38 57 0   4     0   6   69 57                 126
2047721 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_2 11 16 7 0   2     0   4   15 25                       40.0 11 16 7 0   2     0   4   15 25                 40
2047732 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_2 25 53 34 0   4     0   0   53 63                       116.0 25 53 34 0   4     0   0   53 63                 116
2047745 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_2 49 65 8 0   18     0   7   78 69                       147.0 49 65 8 0   18     0   7   78 69                 147
2047844 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_2 7 0 2 0   0     0   3   6 6                       12.0 7 0 2 0   0     0   3   6 6                 12
2047860 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_2 2 40 47 1   0     0   4   50 44                       94.0 2 40 47 1   0     0   4   50 44                 94
2047873 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_2 59 21 17 0   18     0   13   67 61                       128.0 59 21 17 0   18     0   13   67 61                 128
2047956 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_2 13 42 22 0   6     0   2   45 40                       85.0 13 42 22 0   6     0   2   45 40                 85
2047969 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_2 49 12 3 0   3     0   11   36 42                       78.0 49 12 3 0   3     0   11   36 42                 78
2047986 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_2 82 10 9 0   0     0   9   58 52                       110.0 82 10 9 0   0     0   9   58 52                 110
2048009 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_2 25 17 20 1   2     0   1   30 36                       66.0 25 17 20 1   2     0   1   30 36                 66
2048030 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_2 33 2 2 0   5     0   2   24 19                       44.0 33 2 2 0   5     0   2   24 19                 44
2049351 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_2 11 10 2 0   1     0   2   15 11                       26.0 11 10 2 0   1     0   2   15 11                 26
2049364 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_2 24 8 15 1   1     1   3   22 31                       53.0 24 8 15 1   1     1   3   22 31                 53
2230051 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_2 24 7 8 0   3     0   2   20 24                       44.0 24 7 8 0   3     0   2   20 24                 44
2230264 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_2 * * * *   *     *   *   2 3                       5.0                         2 3                 5
2232695 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_2 1 0 5 0   0     0   0   5 1                       6.0 1 0 5 0   0     0   0   5 1                 6
2238030 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_2 8 99 68 0   2     0   3   81 99                       180.0 8 99 68 0   2     0   3   81 99                 180
2238042 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_2 6 23 83 0   6     0   4   68 54                       122.0 6 23 83 0   6     0   4   68 54                 122
2238098 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_2 0 15 5 0   0     0   0   10 10                       20.0 0 15 5 0   0     0   0   10 10                 20

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