Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_1 · 6,780
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
743668 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 KG 08 2015   grade_1 1 0 81 0   0     0   0   46 36                       82 1 0 81 0   0     0   0   46 36                 82
940492 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes 1 PK 08 2016   grade_1 0 1 82 0   0     0   0   43 40                       83 0 1 82 0   0     0   0   43 40                 83
1131400 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2017   grade_1 0 0 84 0   0     0   0   37 47                       84 0 0 84 0   0     0   0   37 47                 84
1372726 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2020   grade_1 1 1 82 0   0     0   0   39 45 *                     84.0 1 1 82 0   0     0   0   39 45                 84
1679990 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District) - Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2021   grade_1 2 0 79 0   0     0   0   29 52 *                     81.0 2 0 79 0   0     0   0   29 52                 81
2047797 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_1 1 1 82 0   0     0   0   39 45                       84.0 1 1 82 0   0     0   0   39 45                 84
2238232 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter (District): Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2018   grade_1 0 0 83 0   0     0   0   35 48                       83.0 0 0 83 0   0     0   0   35 48                 83
743715 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_1 11 0 0 0   0     0   2   2 11                       13 11 0 0 0   0     0   2   2 11                 13
940544 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2016   grade_1 9 0 1 0   0     0   4   6 8                       14 9 0 1 0   0     0   4   6 8                 14
1131450 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_1 13 0 1 0   0     0   1   6 9                       15 13 0 1 0   0     0   1   6 9                 15
1372772 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_1 15 0 2 0   0     0   0   6 11 *                     17.0 15 0 2 0   0     0   0   6 11                 17
1680036 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_1 12 0 1 0   0     0   0   7 6 *                     13.0 12 0 1 0   0     0   0   7 6                 13
2047843 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2019   grade_1 8 0 4 1   0     0   1   8 6                       14.0 8 0 4 1   0     0   1   8 6                 14
2238283 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_1 9 0 1 0   0     0   3   6 7                       13.0 9 0 1 0   0     0   3   6 7                 13
743793 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2015   grade_1 3 79 36 0   1     0   5   60 64                       124 3 79 36 0   1     0   5   60 64                 124
940622 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes 1 PK 06 2016   grade_1 2 82 28 0   0     0   4   58 58                       116 2 82 28 0   0     0   4   58 58                 116
1131529 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2017   grade_1 2 85 50 0   0     0   7   74 70                       144 2 85 50 0   0     0   7   74 70                 144
1372835 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2020   grade_1 1 79 45 0   1     0   6   64 68 *                     132.0 1 79 45 0   1     0   6   64 68                 132
1680100 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District) - Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2021   grade_1 5 85 48 0   0     0   2   64 76 *                     140.0 5 85 48 0   0     0   2   64 76                 140
2047907 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2019   grade_1 5 84 44 0   1     0   4   69 69                       138.0 5 84 44 0   1     0   4   69 69                 138
2238362 MA Suffolk   school 2500039 481   Boston Renaissance Charter Public (District) 250003900599 4810550 Boston Renaissance Charter Public (District): Boston Renaissance Charter Public School   Regular School Yes Elementary PK 06 2018   grade_1 1 79 56 0   1     0   4   62 79                       141.0 1 79 56 0   1     0   4   62 79                 141
743850 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2015   grade_1 25 12 0 0   2     0   4   20 23                       43 25 12 0 0   2     0   4   20 23                 43
940680 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes 4 KG 12 2016   grade_1 33 6 1 0   4     0   0   21 23                       44 33 6 1 0   4     0   0   21 23                 44
1131595 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2017   grade_1 34 8 3 0   4     0   2   27 24                       51 34 8 3 0   4     0   2   27 24                 51
1372896 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_1 39 30 4 0   4     0   5   38 44 *                     82.0 39 30 4 0   4     0   5   38 44                 82
1680161 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_1 30 26 5 1   5     0   9   41 34 *                     76.0 30 26 5 1   5     0   9   41 34                 76
2047968 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2019   grade_1 41 23 0 0   5     0   7   32 44                       76.0 41 23 0 0   5     0   7   32 44                 76
2238429 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District): South Shore Charter Public School   Regular School Yes Other KG 12 2018   grade_1 43 10 0 0   5     0   9   32 35                       67.0 43 10 0 0   5     0   9   32 35                 67
743867 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_1 97 2 13 0   2     0   1   57 58                       115 97 2 13 0   2     0   1   57 58                 115
940697 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_1 90 5 5 0   1     0   5   52 54                       106 90 5 5 0   1     0   5   52 54                 106
1131614 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_1 86 5 8 0   2     0   5   46 60                       106 86 5 8 0   2     0   5   46 60                 106
1372913 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2020   grade_1 89 5 7 0   3     1   5   54 56 *                     110.0 89 5 7 0   3     1   5   54 56                 110
1680178 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District) - Atlantis Charter School   Regular School Yes Other KG 12 2021   grade_1 72 7 20 0   4     0   7   52 58 *                     110.0 72 7 20 0   4     0   7   52 58                 110
2047985 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_1 86 6 7 0   1     0   10   55 55                       110.0 86 6 7 0   1     0   10   55 55                 110
2238448 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_1 79 9 11 0   0     0   7   54 52                       106.0 79 9 11 0   0     0   7   54 52                 106
744897 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2015   grade_1 8 0 0 0   1     0   1   8 2                       10 8 0 0 0   1     0   1   8 2                 10
941718 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   grade_1 4 0 0 0   0     0   4   6 2                       8 4 0 0 0   0     0   4   6 2                 8
1132818 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   grade_1 * * * *   *     *   *   2 2                       *                         2 2                  
1373942 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   grade_1 9 0 0 0   0     0   1   5 5 *                     10.0 9 0 0 0   0     0   1   5 5                 10
1681190 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional - Chilmark Elementary   Regular School No Elementary KG 05 2021   grade_1 5 0 0 0   1     0   0   4 2 *                     6.0 5 0 0 0   1     0   0   4 2                 6
2049016 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   grade_1 9 0 0 1   0     0   1   5 6                       11.0 9 0 0 1   0     0   1   5 6                 11
2239633 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional: Chilmark Elementary   Regular School No Elementary KG 05 2018   grade_1 7 0 0 0   0     0   2   4 5                       9.0 7 0 0 0   0     0   2   4 5                 9
744904 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   grade_1 30 2 2 1   0     0   2   18 19                       37 30 2 2 1   0     0   2   18 19                 37
941725 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_1 28 1 3 1   0     0   3   17 19                       36 28 1 3 1   0     0   3   17 19                 36
1132826 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_1 33 0 1 4   0     0   1   23 16                       39 33 0 1 4   0     0   1   23 16                 39
1373949 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_1 25 0 4 5   0     0   3   23 14 *                     37.0 25 0 4 5   0     0   3   23 14                 37
1681197 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_1 25 0 4 0   0     0   3   16 16 *                     32.0 25 0 4 0   0     0   3   16 16                 32
2049023 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_1 22 0 2 1   0     0   5   18 12                       30.0 22 0 2 1   0     0   5   18 12                 30
2239641 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_1 20 0 5 2   0     0   0   15 12                       27.0 20 0 5 2   0     0   0   15 12                 27
743828 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_1 7 48 33 0   0     0   2   46 44                       90 7 48 33 0   0     0   2   46 44                 90
940658 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2016   grade_1 8 44 33 0   0     0   3   46 42                       88 8 44 33 0   0     0   3   46 42                 88
1131571 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2017   grade_1 11 47 27 0   0     0   8   48 45                       93 11 47 27 0   0     0   8   48 45                 93
1372874 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_1 5 29 39 0   0     0   1   36 38 *                     74.0 5 29 39 0   0     0   1   36 38                 74
1680139 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Learning First Charter Public School (District) - Learning First Charter Public School   Regular School Yes Elementary KG 08 2021   grade_1 2 33 38 0   1     0   1   31 44 *                     75.0 2 33 38 0   1     0   1   31 44                 75
2047946 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_1 4 33 40 0   0     0   1   39 39                       78.0 4 33 40 0   0     0   1   39 39                 78
2238405 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter Public (District): Seven Hills Charter School   Regular School Yes Elementary KG 08 2018   grade_1 6 30 39 0   0     0   0   38 37                       75.0 6 30 39 0   0     0   0   38 37                 75
743837 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2015   grade_1 10 52 16 0   6     1   3   41 47                       88 10 52 16 0   6     1   3   41 47                 88
940667 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_1 9 37 19 1   15     0   6   54 33                       87 9 37 19 1   15     0   6   54 33                 87
1131581 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_1 10 45 20 0   10     0   1   38 48                       86 10 45 20 0   10     0   1   38 48                 86
1372883 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2020   grade_1 10 41 23 0   3     0   8   33 52 *                     85.0 10 41 23 0   3     0   8   33 52                 85
1680148 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District) - Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2021   grade_1 12 57 9 0   6     0   2   43 43 *                     86.0 12 57 9 0   6     0   2   43 43                 86
2047955 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2019   grade_1 16 47 11 0   6     0   5   41 44                       85.0 16 47 11 0   6     0   5   41 44                 85
2238415 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter (District): Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2018   grade_1 15 39 18 0   6     0   2   44 36                       80.0 15 39 18 0   6     0   2   44 36                 80
743603 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2015   grade_1 15 79 26 0   4     0   1   57 68                       125 15 79 26 0   4     0   1   57 68                 125
940426 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_1 27 61 17 0   3     0   8   62 54                       116 27 61 17 0   3     0   8   62 54                 116
1131327 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_1 31 55 20 0   2     0   5   54 59                       113 31 55 20 0   2     0   5   54 59                 113
1372660 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2020   grade_1 18 61 31 3   2     0   5   54 66 *                     120.0 18 61 31 3   2     0   5   54 66                 120
1679924 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2021   grade_1 26 65 7 1   4     0   13   55 61 *                     116.0 26 65 7 1   4     0   13   55 61                 116
2047731 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_1 16 55 30 1   5     0   7   40 74                       114.0 16 55 30 1   5     0   7   40 74                 114
2238159 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_1 25 52 34 0   5     0   0   52 64                       116.0 25 52 34 0   5     0   0   52 64                 116
743616 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_1 68 20 5 0   16     0   4   57 56                       113 68 20 5 0   16     0   4   57 56                 113
940439 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_1 65 30 5 0   7     0   7   54 60                       114 65 30 5 0   7     0   7   54 60                 114
1131341 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_1 43 49 3 0   10     0   9   53 61                       114 43 49 3 0   10     0   9   53 61                 114
1372673 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2020   grade_1 38 70 10 0   15     0   11   80 64 *                     144.0 38 70 10 0   15     0   11   80 64                 144
1679937 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_1 43 66 10 0   24     0   7   74 76 *                     150.0 43 66 10 0   24     0   7   74 76                 150
2047744 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2019   grade_1 51 60 10 0   23     1   3   70 78                       148.0 51 60 10 0   23     1   3   70 78                 148
2238173 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District): Foxborough Regional Charter School   Regular School Yes Other KG 12 2018   grade_1 46 52 8 0   18     0   8   72 60                       132.0 46 52 8 0   18     0   8   72 60                 132
743747 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2015   grade_1 70 21 10 0   26     0   7   65 69                       134 70 21 10 0   26     0   7   65 69                 134
940576 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_1 67 24 6 1   13     0   10   59 62                       121 67 24 6 1   13     0   10   59 62                 121
1131482 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_1 52 28 14 0   21     0   5   62 58                       120 52 28 14 0   21     0   5   62 58                 120
1372800 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2020   grade_1 62 24 22 0   43     0   5   72 84 *                     156.0 62 24 22 0   43     0   5   72 84                 156
1680065 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District) - Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2021   grade_1 70 20 13 0   45     0   11   72 87 *                     159.0 70 20 13 0   45     0   11   72 87                 159
2047872 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2019   grade_1 53 29 21 1   47     0   4   78 77                       155.0 53 29 21 1   47     0   4   78 77                 155
2238315 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_1 57 18 21 0   19     0   12   65 62                       127.0 57 18 21 0   19     0   12   65 62                 127
743552 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_1 7 23 15 0   2     0   5   24 28                       52 7 23 15 0   2     0   5   24 28                 52
940375 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2016   grade_1 10 23 17 0   4     0   5   26 33                       59 10 23 17 0   4     0   5   26 33                 59
1131281 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_1 4 20 24 0   2     0   0   28 22                       50 4 20 24 0   2     0   0   28 22                 50
1372615 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_1 1 29 20 0   2     0   2   28 26 *                     54.0 1 29 20 0   2     0   2   28 26                 54
1679878 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District) - Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2021   grade_1 3 23 23 0   1     0   3   23 30 *                     53.0 3 23 23 0   1     0   3   23 30                 53
2047687 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_1 8 25 19 0   0     0   1   24 29                       53.0 8 25 19 0   0     0   1   24 29                 53
2238112 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_1 3 21 22 0   4     0   1   18 33                       51.0 3 21 22 0   4     0   1   18 33                 51
743800 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_1 27 0 2 1   2     0   0   10 22                       32 27 0 2 1   2     0   0   10 22                 32
940629 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_1 30 0 0 0   3     0   1   18 16                       34 30 0 0 0   3     0   1   18 16                 34
1131537 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_1 32 0 0 0   0     0   0   14 18                       32 32 0 0 0   0     0   0   14 18                 32
1372842 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_1 29 0 2 0   0     0   1   21 11 *                     32.0 29 0 2 0   0     0   1   21 11                 32
1680107 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_1 29 0 5 0   0     0   0   18 16 *                     34.0 29 0 5 0   0     0   0   18 16                 34
2047914 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_1 30 0 0 0   0     0   2   17 15                       32.0 30 0 0 0   0     0   2   17 15                 32
2238370 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_1 27 0 2 0   1     0   2   17 15                       32.0 27 0 2 0   1     0   2   17 15                 32
743687 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 07 2015   grade_1 3 23 50 0   20     0   4   52 48                       100 3 23 50 0   20     0   4   52 48                 100
940511 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public School   Regular School Yes 1 PK 08 2016   grade_1 5 25 43 0   19     0   3   54 41                       95 5 25 43 0   19     0   3   54 41                 95

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