Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_2 · 6,731
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
743669 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_2 1 1 77 0   0     0   0   31 48                       79 1 1 77 0   0     0   0   31 48                 79
940493 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_2 1 0 83 0   0     0   0   48 36                       84 1 0 83 0   0     0   0   48 36                 84
1131401 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_2 0 1 83 0   0     0   0   45 39                       84 0 1 83 0   0     0   0   45 39                 84
1372727 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_2 1 1 82 0   0     0   0   39 45 *                     84.0 1 1 82 0   0     0   0   39 45                 84
1679991 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_2 1 1 82 0   0     0   0   39 45 *                     84.0 1 1 82 0   0     0   0   39 45                 84
2047798 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_2 0 0 84 0   0     0   0   35 49                       84.0 0 0 84 0   0     0   0   35 49                 84
2238233 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_2 1 0 83 0   0     0   0   36 48                       84.0 1 0 83 0   0     0   0   36 48                 84
743716 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_2 14 1 1 0   0     0   1   9 8                       17 14 1 1 0   0     0   1   9 8                 17
940545 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_2 12 0 0 0   0     0   2   3 11                       14 12 0 0 0   0     0   2   3 11                 14
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
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
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
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
2238284 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_2 13 0 2 1   0     0   1   7 10                       17.0 13 0 2 1   0     0   1   7 10                 17
743794 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_2 0 89 38 0   1     0   0   60 68                       128 0 89 38 0   1     0   0   60 68                 128
940623 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_2 2 78 33 0   1     0   5   56 63                       119 2 78 33 0   1     0   5   56 63                 119
1131530 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_2 1 83 31 0   0     0   4   61 58                       119 1 83 31 0   0     0   4   61 58                 119
1372836 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_2 4 87 41 0   0     0   6   74 64 *                     138.0 4 87 41 0   0     0   6   74 64                 138
1680101 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_2 1 85 48 0   1     0   6   73 68 *                     141.0 1 85 48 0   1     0   6   73 68                 141
2047908 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_2 1 81 50 0   0     0   5   61 76                       137.0 1 81 50 0   0     0   5   61 76                 137
2238363 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_2 2 83 49 0   0     0   7   72 69                       141.0 2 83 49 0   0     0   7   72 69                 141
743851 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_2 23 16 4 0   1     0   2   23 23                       46 23 16 4 0   1     0   2   23 23                 46
940681 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_2 26 12 0 0   2     0   4   20 24                       44 26 12 0 0   2     0   4   20 24                 44
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
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
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
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
2238430 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_2 40 11 4 0   3     0   3   31 30                       61.0 40 11 4 0   3     0   3   31 30                 61
743868 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_2 61 2 6 0   1     0   2   28 44                       72 61 2 6 0   1     0   2   28 44                 72
940698 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_2 94 2 11 0   2     0   1   53 57                       110 94 2 11 0   2     0   1   53 57                 110
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
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
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
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
2238449 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_2 87 5 7 0   2     0   5   44 62                       106.0 87 5 7 0   2     0   5   44 62                 106
744898 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2015   grade_2 7 0 0 0   0     0   1   2 6                       8 7 0 0 0   0     0   1   2 6                 8
941719 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No 1 KG 05 2016   grade_2 8 0 0 0   0     0   0   6 2                       8 8 0 0 0   0     0   0   6 2                 8
1132819 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2017   grade_2 4 0 1 0   0     0   2   5 2                       7 4 0 1 0   0     0   2   5 2                 7
1373943 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2020   grade_2 8 0 0 1   0     0   1   5 5 *                     10.0 8 0 0 1   0     0   1   5 5                 10
1681191 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional - Chilmark Elementary   Regular School No Elementary KG 05 2021   grade_2 10 0 0 0   0     0   0   6 4 *                     10.0 10 0 0 0   0     0   0   6 4                 10
2049017 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Chilmark Elementary   Regular School No Elementary KG 05 2019   grade_2 8 0 0 0   0     0   2   4 6                       10.0 8 0 0 0   0     0   2   4 6                 10
2239634 MA Dukes   school 2500043 774   Up-Island Regional 250004300508 7740010 Up-Island Regional: Chilmark Elementary   Regular School No Elementary KG 05 2018   grade_2 4 0 0 1   0     0   1   3 3                       6.0 4 0 0 1   0     0   1   3 3                 6
744905 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2015   grade_2 26 1 1 0   0     0   1   18 11                       29 26 1 1 0   0     0   1   18 11                 29
941726 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No 1 PK 08 2016   grade_2 34 2 1 2   0     0   2   18 23                       41 34 2 1 2   0     0   2   18 23                 41
1132827 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_2 30 1 4 1   0     0   2   16 22                       38 30 1 4 1   0     0   2   16 22                 38
1373950 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_2 23 0 4 2   0     0   4   20 13 *                     33.0 23 0 4 2   0     0   4   20 13                 33
1681198 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_2 26 0 5 5   0     0   4   22 18 *                     40.0 26 0 5 5   0     0   4   22 18                 40
2049024 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2019   grade_2 22 0 5 2   0     0   0   17 12                       29.0 22 0 5 2   0     0   0   17 12                 29
2239642 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_2 34 0 2 2   0     0   1   21 18                       39.0 34 0 2 2   0     0   1   21 18                 39
743829 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2015   grade_2 2 41 38 0   0     0   3   41 43                       84 2 41 38 0   0     0   3   41 43                 84
940659 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes 1 KG 08 2016   grade_2 7 46 31 0   0     0   2   45 41                       86 7 46 31 0   0     0   2   45 41                 86
1131572 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2017   grade_2 7 42 33 0   0     0   3   44 41                       85 7 42 33 0   0     0   3   44 41                 85
1372875 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2020   grade_2 4 29 40 0   0     0   1   35 39 *                     74.0 4 29 40 0   0     0   1   35 39                 74
1680140 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_2 4 32 38 0   0     0   1   37 38 *                     75.0 4 32 38 0   0     0   1   37 38                 75
2047947 MA Worcester   school 2500045 486   Seven Hills Charter Public (District) 250004500817 4860105 Seven Hills Charter School   Regular School Yes Elementary KG 08 2019   grade_2 6 30 39 0   0     0   0   39 36                       75.0 6 30 39 0   0     0   0   39 36                 75
2238406 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_2 10 46 25 0   0     0   7   46 42                       88.0 10 46 25 0   0     0   7   46 42                 88
743838 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_2 13 45 18 2   8     1   1   45 43                       88 13 45 18 2   8     1   1   45 43                 88
940668 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_2 10 54 18 0   6     1   3   43 49                       92 10 54 18 0   6     1   3   43 49                 92
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
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
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
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
2238416 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_2 9 45 21 0   9     0   1   38 47                       85.0 9 45 21 0   9     0   1   38 47                 85
743604 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_2 26 60 34 0   2     0   0   58 64                       122 26 60 34 0   2     0   0   58 64                 122
940427 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_2 15 80 25 0   3     0   1   55 69                       124 15 80 25 0   3     0   1   55 69                 124
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
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
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
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
2238160 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_2 28 59 19 0   2     0   5   54 59                       113.0 28 59 19 0   2     0   5   54 59                 113
743617 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2015   grade_2 66 24 2 0   16     0   6   51 63                       114 66 24 2 0   16     0   6   51 63                 114
940440 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_2 66 25 3 0   14     0   5   55 58                       113 66 25 3 0   14     0   5   55 58                 113
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
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
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
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
2238174 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_2 43 66 4 2   9     0   10   61 73                       134.0 43 66 4 2   9     0   10   61 73                 134
743748 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_2 76 26 11 0   24     0   5   77 65                       142 76 26 11 0   24     0   5   77 65                 142
940577 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_2 68 20 9 0   26     0   7   66 64                       130 68 20 9 0   26     0   7   66 64                 130
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
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
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
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
2238316 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_2 54 28 16 0   25     0   5   65 63                       128.0 54 28 16 0   25     0   5   65 63                 128
743553 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2015   grade_2 9 25 9 0   2     0   2   27 20                       47 9 25 9 0   2     0   2   27 20                 47
940376 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes 1 PK 08 2016   grade_2 5 24 16 0   3     0   5   20 33                       53 5 24 16 0   3     0   5   20 33                 53
1131282 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2017   grade_2 8 20 17 0   1     0   4   24 26                       50 8 20 17 0   1     0   4   24 26                 50
1372616 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2020   grade_2 9 26 19 0   0     0   0   26 28 *                     54.0 9 26 19 0   0     0   0   26 28                 54
1679879 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_2 0 28 22 0   2     0   2   28 26 *                     54.0 0 28 22 0   2     0   2   28 26                 54
2047688 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_2 2 24 24 0   3     0   0   22 31                       53.0 2 24 24 0   3     0   0   22 31                 53
2238113 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_2 6 18 26 0   2     0   0   31 21                       52.0 6 18 26 0   2     0   0   31 21                 52
743801 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2015   grade_2 30 0 0 0   0     0   2   15 17                       32 30 0 0 0   0     0   2   15 17                 32
940630 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes 1 KG 08 2016   grade_2 27 0 2 1   1     0   0   11 20                       31 27 0 2 1   1     0   0   11 20                 31
1131538 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2017   grade_2 30 0 0 0   3     0   1   18 16                       34 30 0 0 0   3     0   1   18 16                 34
1372843 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_2 30 0 0 0   0     0   2   14 18 *                     32.0 30 0 0 0   0     0   2   14 18                 32
1680108 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_2 29 0 2 0   0     0   1   21 11 *                     32.0 29 0 2 0   0     0   1   21 11                 32
2047915 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2019   grade_2 27 0 2 0   1     0   2   17 15                       32.0 27 0 2 0   1     0   2   17 15                 32
2238371 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_2 32 0 0 0   0     0   0   14 18                       32.0 32 0 0 0   0     0   0   14 18                 32
743688 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_2 2 25 49 0   20     0   4   52 48                       100 2 25 49 0   20     0   4   52 48                 100
940512 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_2 3 23 48 0   19     0   4   51 46                       97 3 23 48 0   19     0   4   51 46                 97

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