Data source: Big Local News · About: Big Local

6,787 rows where grade = "grade_3" and state = "MA" sorted by ccd_school_lvl descending

View and edit SQL

year

grade

  • grade_3 · 6,787
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
1368460 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1374310 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1675701 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_3 * * * *   *     *   *   * * *                     0.0                                             0
1123134 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_3 2 7 4 0   0     0   0   10 3                       13 2 7 4 0   0     0   0   10 3                 13
1123247 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 03 12 2017   grade_3 13 10 14 0   1     0   1   23 16                       39 13 10 14 0   1     0   1   23 16                 39
1124655 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_3 * * * *   *     *   *   4 1                       *                         4 1                  
1125880 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_3 1 0 7 0   0     0   0   7 1                       8 1 0 7 0   0     0   0   7 1                 8
1131203 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_3 6 111 66 0   5     0   3   91 100                       191 6 111 66 0   5     0   3   91 100                 191
1131268 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_3 0 15 6 0   0     0   0   13 8                       21 0 15 6 0   0     0   0   13 8                 21
1131304 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_3 22 44 46 0   9     0   7   63 65                       128 22 44 46 0   9     0   7   63 65                 128
1131329 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_3 14 81 24 0   3     0   0   52 70                       122 14 81 24 0   3     0   0   52 70                 122
1131343 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_3 60 33 4 0   13     0   5   56 59                       115 60 33 4 0   13     0   5   56 59                 115
1131452 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_3 13 0 0 0   0     0   2   3 12                       15 13 0 0 0   0     0   2   3 12                 15
1131470 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2017   grade_3 3 30 37 0   1     0   2   30 43                       73 3 30 37 0   1     0   2   30 43                 73
1131484 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_3 68 19 10 0   26     0   6   65 64                       129 68 19 10 0   26     0   6   65 64                 129
1131583 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_3 8 56 20 0   6     1   3   48 46                       94 8 56 20 0   6     1   3   48 46                 94
1131597 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_3 30 14 1 0   1     0   4   22 28                       50 30 14 1 0   1     0   4   22 28                 50
1131616 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_3 90 2 11 0   2     0   1   47 59                       106 90 2 11 0   2     0   1   47 59                 106
1131660 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_3 20 3 3 0   11     0   8   23 22                       45 20 3 3 0   11     0   8   23 22                 45
1133185 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_3 36 7 12 0   0     0   4   34 25                       59 36 7 12 0   0     0   4   34 25                 59
1133199 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_3 22 3 6 0   1     0   4   22 14                       36 22 3 6 0   1     0   4   22 14                 36
1365777 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_3 3 4 4 0   1     0   0   11 1 *                     12.0 3 4 4 0   1     0   0   11 1                 12
1365879 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2020   grade_3 15 23 17 0   9     0   4   41 27 *                     68.0 15 23 17 0   9     0   4   41 27                 68
1366045 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other 01 12 2020   grade_3 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1366216 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_3 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367197 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_3 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1367683 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_3 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368423 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_3 5 0 3 0   3     0   0   10 1 *                     11.0 5 0 3 0   3     0   0   10 1                 11
1372537 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_3 9 96 73 0   4     0   0   82 100 *                     182.0 9 96 73 0   4     0   0   82 100                 182
1372550 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_3 7 24 84 2   3     0   4   58 66 *                     124.0 7 24 84 2   3     0   4   58 66                 124
1372603 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_3 0 15 6 0   0     0   0   7 14 *                     21.0 0 15 6 0   0     0   0   7 14                 21
1372636 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_3 25 35 57 0   5     0   7   65 64 *                     129.0 25 35 57 0   5     0   7   65 64                 129
1372650 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_3 12 18 7 0   3     0   4   16 26 *                     44.0 12 18 7 0   3     0   4   16 26                 44
1372662 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_3 27 55 34 0   4     0   0   52 68 *                     120.0 27 55 34 0   4     0   0   52 68                 120
1372675 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_3 46 69 10 0   17     0   8   78 72 *                     150.0 46 69 10 0   17     0   8   78 72                 150
1372774 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_3 8 0 1 0   0     0   3   6 6 *                     12.0 8 0 1 0   0     0   3   6 6                 12
1372789 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2020   grade_3 2 42 45 1   0     0   5   48 47 *                     95.0 2 42 45 1   0     0   5   48 47                 95
1372802 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_3 55 23 17 0   18     0   14   70 57 *                     127.0 55 23 17 0   18     0   14   70 57                 127
1372885 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_3 9 48 30 0   6     0   1   47 47 *                     94.0 9 48 30 0   6     0   1   47 47                 94
1372898 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_3 45 16 5 0   4     0   9   37 42 *                     79.0 45 16 5 0   4     0   9   37 42                 79
1372915 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_3 79 10 13 0   0     0   8   59 51 *                     110.0 79 10 13 0   0     0   8   59 51                 110
1372938 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_3 25 17 20 1   2     0   1   27 39 *                     66.0 25 17 20 1   2     0   1   27 39                 66
1372959 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_3 33 1 2 0   6     0   2   23 20 *                     44.0 33 1 2 0   6     0   2   23 20                 44
1374199 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_3 12 28 40 0   25     0   6   57 54 *                     111.0 12 28 40 0   25     0   6   57 54                 111
1374283 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_3 11 4 3 0   2     0   2   9 13 *                     22.0 11 4 3 0   2     0   2   9 13                 22
1374296 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_3 22 8 13 0   1     0   5   20 29 *                     49.0 22 8 13 0   1     0   5   20 29                 49
1673015 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_3 0 3 5 0   0     0   1   8 1 *                     9.0 0 3 5 0   0     0   1   8 1                 9
1673116 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_3 24 17 14 0   10     0   2   35 32 *                     67.0 24 17 14 0   10     0   2   35 32                 67
1673280 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_3 2 3 2 0   0     0   0   6 1 *                     7.0 2 3 2 0   0     0   0   6 1                 7
1674427 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_3 * * * *   *     *   *   2 1 *                     3.0                         2 1                 3
1675304 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_3 2 0 5 0   0     0   0   5 2 *                     7.0 2 0 5 0   0     0   0   5 2                 7
1675849 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn - Lynn Vocational Technical Institute   Career and Technical School No Other PK 12 2021   grade_3 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1679800 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_3 4 91 94 1   4     0   2   104 92 *                     196.0 4 91 94 1   4     0   2   104 92                 196
1679813 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_3 9 20 85 0   4     0   6   58 66 *                     124.0 9 20 85 0   4     0   6   58 66                 124
1679866 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_3 0 18 3 0   0     0   0   11 10 *                     21.0 0 18 3 0   0     0   0   11 10                 21
1679899 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_3 24 41 78 0   3     0   10   80 76 *                     156.0 24 41 78 0   3     0   10   80 76                 156
1679913 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_3 7 17 15 0   2     0   3   15 29 *                     44.0 7 17 15 0   2     0   3   15 29                 44
1679926 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_3 18 57 28 1   6     0   8   40 78 *                     118.0 18 57 28 1   6     0   8   40 78                 118
1679939 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_3 41 78 9 0   19     1   5   77 76 *                     153.0 41 78 9 0   19     1   5   77 76                 153
1680038 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_3 8 0 8 0   0     0   1   10 7 *                     17.0 8 0 8 0   0     0   1   10 7                 17
1680054 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_3 0 52 39 0   1     1   2   44 51 *                     95.0 0 52 39 0   1     1   2   44 51                 95
1680067 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_3 59 25 17 1   48     0   3   77 76 *                     153.0 59 25 17 1   48     0   3   77 76                 153
1680150 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_3 15 53 12 0   6     0   5   47 44 *                     91.0 15 53 12 0   6     0   5   47 44                 91
1680163 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_3 45 23 4 1   3     0   4   32 48 *                     80.0 45 23 4 1   3     0   4   32 48                 80
1680180 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_3 86 6 8 0   1     0   8   55 54 *                     109.0 86 6 8 0   1     0   8   55 54                 109
1680202 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_3 20 20 22 0   0     0   1   31 32 *                     63.0 20 20 22 0   0     0   1   31 32                 63
1680223 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_3 21 5 2 0   10     0   6   25 19 *                     44.0 21 5 2 0   10     0   6   25 19                 44
1681447 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_3 16 23 34 1   43     0   5   64 58 *                     122.0 16 23 34 1   43     0   5   64 58                 122
1681521 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_3 29 6 9 0   5     0   2   20 31 0                     51.0 29 6 9 0   5     0   2   20 31 0               51
1681534 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_3 40 12 21 0   3     1   5   48 34 *                     82.0 40 12 21 0   3     1   5   48 34                 82
2040820 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_3 0 3 6 1   0     0   0   9 1                       10.0 0 3 6 1   0     0   0   9 1                 10
2040923 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Dr. William Henderson Upper   Regular School No Other 02 12 2019   grade_3 22 11 6 0   4     0   2   24 21                       45.0 22 11 6 0   4     0   2   24 21                 45
2041098 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2019   grade_3 0 2 4 0   0     0   0   3 3                       6.0 0 2 4 0   0     0   0   3 3                 6
2042268 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2042767 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_3 * * * *   *     *   *   2 *                       2.0                         2                   2
2047612 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_3 8 102 69 0   2     0   3   85 99                       184.0 8 102 69 0   2     0   3   85 99                 184
2047624 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_3 6 24 82 0   6     0   4   67 55                       122.0 6 24 82 0   6     0   4   67 55                 122
2047675 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_3 0 15 5 0   0     0   0   10 10                       20.0 0 15 5 0   0     0   0   10 10                 20
2047708 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_3 17 38 58 0   6     0   9   70 58                       128.0 17 38 58 0   6     0   9   70 58                 128
2047722 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_3 7 27 6 0   2     0   2   22 22                       44.0 7 27 6 0   2     0   2   22 22                 44
2047733 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_3 28 62 21 0   2     0   5   57 61                       118.0 28 62 21 0   2     0   5   57 61                 118
2047746 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_3 41 79 2 2   11     0   11   65 81                       146.0 41 79 2 2   11     0   11   65 81                 146
2047845 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_3 15 0 2 1   0     0   1   8 11                       19.0 15 0 2 1   0     0   1   8 11                 19
2047861 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_3 2 44 49 0   0     0   0   41 54                       95.0 2 44 49 0   0     0   0   41 54                 95
2047874 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_3 50 30 15 0   26     0   5   65 61                       126.0 50 30 15 0   26     0   5   65 61                 126
2047957 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_3 9 49 23 0   10     0   1   39 53                       92.0 9 49 23 0   10     0   1   39 53                 92
2047970 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_3 38 13 4 0   2     0   3   32 28                       60.0 38 13 4 0   2     0   3   32 28                 60
2047987 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_3 89 6 9 0   2     0   5   49 62                       111.0 89 6 9 0   2     0   5   49 62                 111
2048010 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_3 17 23 21 1   4     0   0   36 30                       66.0 17 23 21 1   4     0   0   36 30                 66
2048031 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_3 20 3 7 0   7     0   5   18 24                       42.0 20 3 7 0   7     0   5   18 24                 42
2049352 MA Franklin   school 2500551 3901   Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_3 13 6 6 0   1     0   1   13 14                       27.0 13 6 6 0   1     0   1   13 14                 27
2049365 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_3 36 9 9 1   3     0   1   27 32                       59.0 36 9 9 1   3     0   1   27 32                 59
2229938 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_3 0 9 3 0   0     0   0   10 2                       12.0 0 9 3 0   0     0   0   10 2                 12
2230052 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_3 18 12 14 0   7     0   0   23 28                       51.0 18 12 14 0   7     0   0   23 28                 51
2230265 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_3 0 4 3 0   0     0   1   6 2                       8.0 0 4 3 0   0     0   1   6 2                 8
2231473 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_3 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231625 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_3 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2232239 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_3 * * * *   *     *   *   4 1                       5.0                         4 1                 5
2232696 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_3 2 0 7 0   0     0   0   6 3                       9.0 2 0 7 0   0     0   0   6 3                 9
2238031 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_3 14 98 66 1   4     0   4   91 96                       187.0 14 98 66 1   4     0   4   91 96                 187

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