Data source: Big Local News · About: Big Local

3,459 rows where grade = "grade_8" and state = "MA" sorted by school_nces_id

View and edit SQL

year

grade

  • grade_8 · 3,459
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
744756 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2015   grade_8 189 1 9 0   2     0   4   106 99                       205 189 1 9 0   2     0   4   106 99                 205
941581 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No 2 07 08 2016   grade_8 191 0 8 0   2     0   8   106 103                       209 191 0 8 0   2     0   8   106 103                 209
1132656 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2017   grade_8 198 1 7 0   1     0   9   103 113                       216 198 1 7 0   1     0   9   103 113                 216
1373820 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2020   grade_8 174 0 8 1   4     0   2   91 98 *                     189.0 174 0 8 1   4     0   2   91 98                 189
1681068 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_8 150 2 11 0   3     0   2   79 89 *                     168.0 150 2 11 0   3     0   2   79 89                 168
2048886 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2019   grade_8 164 0 6 0   1     0   5   76 100                       176.0 164 0 6 0   1     0   5   76 100                 176
2239481 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin: Quabbin Regional Middle School   Regular School No Middle 07 08 2018   grade_8 203 0 14 0   1     0   4   117 105                       222.0 203 0 14 0   1     0   4   117 105                 222
744848 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Junior High   Regular School No 2 06 08 2015   grade_8 118 1 9 0   1     0   6   74 61                       135 118 1 9 0   1     0   6   74 61                 135
941669 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_8 94 3 13 0   1     0   1   75 37                       112 94 3 13 0   1     0   1   75 37                 112
1132762 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_8 94 1 8 1   0     0   3   51 56                       107 94 1 8 1   0     0   3   51 56                 107
1373895 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2020   grade_8 95 4 17 0   2     0   5   74 49 *                     123.0 95 4 17 0   2     0   5   74 49                 123
1681143 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_8 92 4 13 1   3     0   7   61 59 *                     120.0 92 4 13 1   3     0   7   61 59                 120
2048968 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2019   grade_8 87 2 17 0   2     0   1   61 48                       109.0 87 2 17 0   2     0   1   61 48                 109
2239577 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_8 82 0 9 0   1     0   4   53 43                       96.0 82 0 9 0   1     0   4   53 43                 96
744826 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301781 7660305 Powder Mill   Regular School No 2 05 08 2015   grade_8 106 5 5 0   1     0   1   57 61                       118 106 5 5 0   1     0   1   57 61                 118
941648 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_8 133 2 1 0   1     0   1   83 55                       138 133 2 1 0   1     0   1   83 55                 138
1132738 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_8 109 2 9 0   1     0   1   63 59                       122 109 2 9 0   1     0   1   63 59                 122
1373874 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2020   grade_8 102 0 8 0   1     0   3   60 54 *                     114.0 102 0 8 0   1     0   3   60 54                 114
1681122 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_8 115 1 5 0   1     0   2   60 64 *                     124.0 115 1 5 0   1     0   2   60 64                 124
2048946 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_8 109 3 4 0   2     0   2   63 57                       120.0 109 3 4 0   2     0   2   63 57                 120
2239553 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District: Southwick Regional School   Regular School No High 07 12 2018   grade_8 119 3 3 0   0     0   1   59 67                       126.0 119 3 3 0   0     0   1   59 67                 126
744822 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302773 7660205 Granville Village School   Regular School No 1 KG 08 2015   grade_8 14 0 1 0   0     0   1   7 9                       16 14 0 1 0   0     0   1   7 9                 16
743429 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2015   grade_8 10 41 20 0   2     0   5   37 41                       78 10 41 20 0   2     0   5   37 41                 78
940250 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes 4 05 12 2016   grade_8 10 51 12 0   1     0   2   37 39                       76 10 51 12 0   1     0   2   37 39                 76
1131128 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes Other 05 12 2017   grade_8 4 53 20 0   1     0   1   40 39                       79 4 53 20 0   1     0   1   40 39                 79
1372471 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2020   grade_8 5 43 25 0   1     0   1   33 42 *                     75.0 5 43 25 0   1     0   1   33 42                 75
1679734 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2021   grade_8 9 44 22 0   0     0   1   39 37 *                     76.0 9 44 22 0   0     0   1   39 37                 76
2047544 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_8 3 43 23 0   0     0   4   34 39                       73.0 3 43 23 0   0     0   4   34 39                 73
2237955 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2018   grade_8 11 50 18 0   2     0   0   41 40                       81.0 11 50 18 0   2     0   0   41 40                 81
743520 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2015   grade_8 73 1 0 0   1     0   5   42 38                       80 73 1 0 0   1     0   5   42 38                 80
940341 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes 2 06 08 2016   grade_8 70 3 1 0   2     0   4   42 38                       80 70 3 1 0   2     0   4   42 38                 80
1131240 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_8 70 0 5 0   1     0   4   32 48                       80 70 0 5 0   1     0   4   32 48                 80
1372579 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_8 62 3 5 0   1     0   6   38 39 *                     77.0 62 3 5 0   1     0   6   38 39                 77
1679842 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District) - Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2021   grade_8 73 1 3 1   2     0   2   38 44 *                     82.0 73 1 3 1   2     0   2   38 44                 82
2047651 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2019   grade_8 71 2 2 0   2     0   4   36 45                       81.0 71 2 2 0   2     0   4   36 45                 81
2238071 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_8 68 4 4 0   0     0   5   33 48                       81.0 68 4 4 0   0     0   5   33 48                 81
743524 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2015   grade_8 86 5 2 0   3     0   4   47 53                       100 86 5 2 0   3     0   4   47 53                 100
940345 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_8 82 3 4 1   6     0   4   47 53                       100 82 3 4 1   6     0   4   47 53                 100
1131245 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_8 77 4 6 0   10     0   3   51 49                       100 77 4 6 0   10     0   3   51 49                 100
1372583 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2020   grade_8 68 3 12 0   6     0   11   43 56 *                     100.0 68 3 12 0   6     0   11   43 56                 100
1679846 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District) - Innovation Academy Charter School   Regular School Yes High 05 12 2021   grade_8 76 3 7 0   13     0   1   54 46 *                     100.0 76 3 7 0   13     0   1   54 46                 100
2047655 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes High 05 12 2019   grade_8 81 3 6 0   5     0   5   57 43                       100.0 81 3 6 0   5     0   5   57 43                 100
2238076 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_8 84 4 1 0   9     0   2   48 52                       100.0 84 4 1 0   9     0   2   48 52                 100
743569 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2015   grade_8 3 3 38 0   1     0   0   25 20                       45 3 3 38 0   1     0   0   25 20                 45
940392 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes 1 PK 08 2016   grade_8 5 1 37 0   0     0   0   12 31                       43 5 1 37 0   0     0   0   12 31                 43
1131299 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2017   grade_8 2 0 44 0   0     0   0   24 22                       46 2 0 44 0   0     0   0   24 22                 46
1372632 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2020   grade_8 2 0 30 0   0     0   0   10 22 *                     32.0 2 0 30 0   0     0   0   10 22                 32
1679895 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District) - Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2021   grade_8 3 1 37 0   0     0   0   23 18 *                     41.0 3 1 37 0   0     0   0   23 18                 41
2047704 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2019   grade_8 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2238130 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_8 2 0 19 0   1     0   0   12 10                       22.0 2 0 19 0   1     0   0   12 10                 22
743578 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2015   grade_8 41 56 47 0   9     0   7   73 87                       160 41 56 47 0   9     0   7   73 87                 160
940401 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_8 29 35 53 0   7     0   7   66 65                       131 29 35 53 0   7     0   7   66 65                 131
1131309 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_8 47 28 42 0   5     0   7   61 68                       129 47 28 42 0   5     0   7   61 68                 129
1372641 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2020   grade_8 26 43 50 0   4     0   5   57 71 *                     128.0 26 43 50 0   4     0   5   57 71                 128
1679904 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_8 20 31 57 0   7     0   8   63 60 *                     123.0 20 31 57 0   7     0   8   63 60                 123
2047713 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2019   grade_8 23 41 50 0   5     0   9   63 65                       128.0 23 41 50 0   5     0   9   63 65                 128
2238140 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 2018   grade_8 30 34 49 0   4     0   11   57 71                       128.0 30 34 49 0   4     0   11   57 71                 128
743601 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2015   grade_8 1 18 7 1   3     0   1   17 14                       31 1 18 7 1   3     0   1   17 14                 31
940424 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes 1 PK 08 2016   grade_8 4 22 6 0   0     0   2   14 20                       34 4 22 6 0   0     0   2   14 20                 34
1131324 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Elementary PK 08 2017   grade_8 7 26 9 0   2     0   0   24 20                       44 7 26 9 0   2     0   0   24 20                 44
1372655 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 11 2020   grade_8 8 42 13 1   2     0   4   33 37 *                     70.0 8 42 13 1   2     0   4   33 37                 70
1679918 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_8 9 40 29 1   1     0   2   45 37 *                     82.0 9 40 29 1   1     0   2   45 37                 82
2047727 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter School   Regular School Yes Other PK 10 2019   grade_8 10 39 12 0   1     0   4   36 30                       66.0 10 39 12 0   1     0   4   36 30                 66
2238155 MA Suffolk   school 2500029 444   Neighborhood House Charter (District) 250002900545 4440205 Neighborhood House Charter (District): Neighborhood House Charter School   Regular School Yes Other PK 09 2018   grade_8 17 32 5 2   1     0   1   29 29                       58.0 17 32 5 2   1     0   1   29 29                 58
743636 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2015   grade_8 39 0 0 0   11     0   1   21 30                       51 39 0 0 0   11     0   1   21 30                 51
940459 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes 1 KG 08 2016   grade_8 38 1 1 0   6     0   1   20 27                       47 38 1 1 0   6     0   1   20 27                 47
1131362 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 29 0 1 0   14     0   2   32 14                       46 29 0 1 0   14     0   2   32 14                 46
1372693 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 36 0 2 0   11     0   3   21 31 *                     52.0 36 0 2 0   11     0   3   21 31                 52
1679957 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
2047764 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 25 2 3 0   15     0   1   25 21                       46.0 25 2 3 0   15     0   1   25 21                 46
2238194 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   grade_8 28 4 1 0   11     0   1   22 23                       45.0 28 4 1 0   11     0   1   22 23                 45
743653 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2015   grade_8 17 0 0 0   0     0   0   7 10                       17 17 0 0 0   0     0   0   7 10                 17
940476 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes 1 KG 08 2016   grade_8 15 0 2 0   1     0   5   11 12                       23 15 0 2 0   1     0   5   11 12                 23
1131381 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2017   grade_8 27 0 2 0   0     0   0   16 13                       29 27 0 2 0   0     0   0   16 13                 29
1372710 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 17 2 4 0   0     0   4   15 12 *                     27.0 17 2 4 0   0     0   4   15 12                 27
1679974 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 26 2 2 0   0     0   2   14 17 *                     32.0 26 2 2 0   0     0   2   14 17                 32
2047781 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2019   grade_8 27 0 1 0   0     0   2   18 12                       30.0 27 0 1 0   0     0   2   18 12                 30
2238213 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2018   grade_8 23 0 6 0   1     0   2   13 19                       32.0 23 0 6 0   1     0   2   13 19                 32
743675 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_8 0 0 58 0   0     0   0   21 37                       58 0 0 58 0   0     0   0   21 37                 58
940499 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_8 0 0 62 0   0     0   0   27 35                       62 0 0 62 0   0     0   0   27 35                 62
1131407 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_8 1 0 54 0   0     0   0   26 29                       55 1 0 54 0   0     0   0   26 29                 55
1372733 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_8 1 0 47 0   0     0   0   20 28 *                     48.0 1 0 47 0   0     0   0   20 28                 48
1679997 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_8 1 1 75 0   0     0   0   29 48 *                     77.0 1 1 75 0   0     0   0   29 48                 77
2047804 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_8 0 0 49 0   0     0   0   20 29                       49.0 0 0 49 0   0     0   0   20 29                 49
2238239 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_8 0 1 47 0   0     0   0   17 31                       48.0 0 1 47 0   0     0   0   17 31                 48
743713 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2015   grade_8 39 3 5 0   0     0   0   28 19                       47 39 3 5 0   0     0   0   28 19                 47
940542 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes 2 04 08 2016   grade_8 33 1 0 0   2     0   0   16 20                       36 33 1 0 0   2     0   0   16 20                 36
1131447 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Elementary 04 08 2017   grade_8 37 0 2 0   1     0   0   19 21                       40 37 0 2 0   1     0   0   19 21                 40
1372770 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_8 26 3 3 0   2     0   2   18 18 *                     36.0 26 3 3 0   2     0   2   18 18                 36
1680034 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District) - Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2021   grade_8 19 2 2 0   0     0   2   16 9 *                     25.0 19 2 2 0   0     0   2   16 9                 25
2047841 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2019   grade_8 33 3 3 1   1     0   0   25 16                       41.0 33 3 3 1   1     0   0   25 16                 41
2238280 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_8 34 0 0 0   1     0   1   19 17                       36.0 34 0 0 0   1     0   1   19 17                 36
743722 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_8 14 2 1 0   1     0   0   10 8                       18 14 2 1 0   1     0   0   10 8                 18
940551 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_8 12 1 0 0   0     0   2   7 8                       15 12 1 0 0   0     0   2   7 8                 15
1131457 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_8 11 0 1 0   2     0   1   12 3                       15 11 0 1 0   2     0   1   12 3                 15
1372779 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_8 18 1 1 0   0     0   1   7 14 *                     21.0 18 1 1 0   0     0   1   7 14                 21
1680043 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_8 13 0 4 0   0     0   3   11 9 *                     20.0 13 0 4 0   0     0   3   11 9                 20
2047850 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_8 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2238290 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_8 10 2 1 0   0     0   1   5 9                       14.0 10 2 1 0   0     0   1   5 9                 14
743777 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes 3 07 12 2015   grade_8 64 0 2 0   2     0   1   33 36                       69 64 0 2 0   2     0   1   33 36                 69

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