Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by ccd_charter_school descending

View and edit SQL

year

  • 2017 · 11,264
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
1131093 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   kindergarten 1 28 14 1   0     0   0   21 23                       44 1 28 14 1   0     0   0   21 23                 44
1131094 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   pre_kindergarten 3 23 15 0   0     0   0   21 20                       41 3 23 15 0   0     0   0   21 20                 41
1131095 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_1 0 25 18 0   0     0   0   17 26                       43 0 25 18 0   0     0   0   17 26                 43
1131096 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_2 0 32 11 0   0     0   1   17 27                       44 0 32 11 0   0     0   1   17 27                 44
1131097 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_3 0 27 16 1   0     0   0   20 24                       44 0 27 16 1   0     0   0   20 24                 44
1131098 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_4 0 25 19 0   0     0   0   22 22                       44 0 25 19 0   0     0   0   22 22                 44
1131099 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   grade_5 0 18 14 0   0     0   0   14 18                       32 0 18 14 0   0     0   0   14 18                 32
1131100 MA Suffolk   school 2500543 407   Dudley Street Neighborhood Charter School (District) 250054302763 4070405 Dudley Street Neighborhood Charter School   Regular School Yes Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131101 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   kindergarten 7 7 23 0   0     0   1   16 22                       38 7 7 23 0   0     0   1   16 22                 38
1131102 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_1 15 5 17 0   0     0   3   22 18                       40 15 5 17 0   0     0   3   22 18                 40
1131103 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_2 9 2 27 1   0     0   1   20 20                       40 9 2 27 1   0     0   1   20 20                 40
1131104 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_3 17 3 20 0   0     0   2   19 23                       42 17 3 20 0   0     0   2   19 23                 42
1131105 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_4 10 9 19 0   0     0   4   18 24                       42 10 9 19 0   0     0   4   18 24                 42
1131106 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_5 18 5 15 0   0     0   2   17 23                       40 18 5 15 0   0     0   2   17 23                 40
1131107 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_6 12 8 19 0   0     0   3   21 21                       42 12 8 19 0   0     0   3   21 21                 42
1131108 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   grade_7 15 7 13 0   2     0   3   17 23                       40 15 7 13 0   2     0   3   17 23                 40
1131109 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School   Regular School Yes Elementary KG 07 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131110 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_5 19 4 138 1   3     1   2   87 81                       168 19 4 138 1   3     1   2   87 81                 168
1131111 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_6 26 16 120 5   2     2   0   79 92                       171 26 16 120 5   2     2   0   79 92                 171
1131112 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_7 14 10 146 3   1     0   0   85 89                       174 14 10 146 3   1     0   0   85 89                 174
1131113 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_8 14 9 139 1   1     0   1   89 76                       165 14 9 139 1   1     0   1   89 76                 165
1131114 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_9 15 15 140 0   3     0   0   84 89                       173 15 15 140 0   3     0   0   84 89                 173
1131115 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   grade_10 9 16 75 2   4     0   0   49 57                       106 9 16 75 2   4     0   0   49 57                 106
1131116 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes Other 05 10 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131117 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_6 5 36 26 0   0     0   1   32 36                       68 5 36 26 0   0     0   1   32 36                 68
1131118 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_7 2 38 16 0   1     0   2   35 24                       59 2 38 16 0   1     0   2   35 24                 59
1131119 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_8 6 31 17 0   0     0   4   28 30                       58 6 31 17 0   0     0   4   28 30                 58
1131120 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_9 10 37 25 0   1     0   6   40 39                       79 10 37 25 0   1     0   6   40 39                 79
1131121 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_10 2 37 25 0   0     0   1   30 35                       65 2 37 25 0   0     0   1   30 35                 65
1131122 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_11 3 34 27 0   2     0   3   38 31                       69 3 34 27 0   2     0   3   38 31                 69
1131123 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   grade_12 7 48 19 0   0     0   4   42 36                       78 7 48 19 0   0     0   4   42 36                 78
1131124 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131125 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_5 5 41 32 0   1     0   0   35 44                       79 5 41 32 0   1     0   0   35 44                 79
1131126 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_6 5 40 26 0   0     0   6   39 38                       77 5 40 26 0   0     0   6   39 38                 77
1131127 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_7 13 47 20 0   1     0   0   37 44                       81 13 47 20 0   1     0   0   37 44                 81
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
1131129 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_9 5 45 11 0   1     0   2   35 29                       64 5 45 11 0   1     0   2   35 29                 64
1131130 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_10 6 29 14 0   1     1   4   29 26                       55 6 29 14 0   1     1   4   29 26                 55
1131131 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_11 5 26 11 0   0     0   1   17 26                       43 5 26 11 0   0     0   1   17 26                 43
1131132 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_12 12 25 10 0   0     0   2   18 31                       49 12 25 10 0   0     0   2   18 31                 49
1131133 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   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131134 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_7 33 1 1 0   0     0   1   18 18                       36 33 1 1 0   0     0   1   18 18                 36
1131135 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_8 27 0 7 0   2     0   1   18 19                       37 27 0 7 0   2     0   1   18 19                 37
1131136 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_9 32 0 3 0   1     0   2   15 23                       38 32 0 3 0   1     0   2   15 23                 38
1131137 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_10 32 0 3 0   0     0   3   18 20                       38 32 0 3 0   0     0   3   18 20                 38
1131138 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_11 34 0 1 0   0     0   2   22 15                       37 34 0 1 0   0     0   2   22 15                 37
1131139 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_12 29 0 1 0   3     0   1   13 21                       34 29 0 1 0   3     0   1   13 21                 34
1131140 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131141 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_6 45 11 6 0   4     0   5   30 41                       71 45 11 6 0   4     0   5   30 41                 71
1131142 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_7 55 7 5 0   0     0   4   35 36                       71 55 7 5 0   0     0   4   35 36                 71
1131143 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_8 50 14 2 0   0     0   1   35 31                       67 50 14 2 0   0     0   1   35 31                 67
1131144 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_9 33 8 3 0   2     0   1   24 23                       47 33 8 3 0   2     0   1   24 23                 47
1131145 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_10 34 9 6 0   1     0   3   26 27                       53 34 9 6 0   1     0   3   26 27                 53
1131146 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_11 24 2 2 0   2     1   0   12 19                       31 24 2 2 0   2     1   0   12 19                 31
1131147 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_12 15 1 0 0   0     0   0   9 7                       16 15 1 0 0   0     0   0   9 7                 16
1131148 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131149 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_6 0 36 10 0   1     1   2   21 29                       50 0 36 10 0   1     1   2   21 29                 50
1131150 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_7 1 38 20 0   1     0   1   34 27                       61 1 38 20 0   1     0   1   34 27                 61
1131151 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_8 2 47 17 0   0     0   1   35 32                       67 2 47 17 0   0     0   1   35 32                 67
1131152 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_9 1 42 24 0   1     0   1   40 29                       69 1 42 24 0   1     0   1   40 29                 69
1131153 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_10 3 50 12 0   1     0   1   35 32                       67 3 50 12 0   1     0   1   35 32                 67
1131154 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_11 3 42 8 0   0     0   0   30 23                       53 3 42 8 0   0     0   0   30 23                 53
1131155 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   grade_12 0 32 12 2   0     0   2   20 28                       48 0 32 12 2   0     0   2   20 28                 48
1131156 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes Other 06 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131157 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   kindergarten 0 24 11 0   0     0   1   15 21                       36 0 24 11 0   0     0   1   15 21                 36
1131158 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   pre_kindergarten 1 23 12 2   1     0   0   17 22                       39 1 23 12 2   1     0   0   17 22                 39
1131159 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_1 0 22 15 0   1     0   0   19 19                       38 0 22 15 0   1     0   0   19 19                 38
1131160 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_2 0 23 14 0   0     0   3   21 19                       40 0 23 14 0   0     0   3   21 19                 40
1131161 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_3 0 25 14 0   1     0   0   19 21                       40 0 25 14 0   1     0   0   19 21                 40
1131162 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_4 0 21 13 0   0     0   5   17 22                       39 0 21 13 0   0     0   5   17 22                 39
1131163 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   grade_5 0 24 9 0   1     0   1   16 19                       35 0 24 9 0   1     0   1   16 19                 35
1131164 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131165 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_6 86 3 36 1   11     0   6   74 69                       143 86 3 36 1   11     0   6   74 69                 143
1131166 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_7 73 10 25 2   5     1   9   63 62                       125 73 10 25 2   5     1   9   63 62                 125
1131167 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_8 80 9 22 1   8     0   7   70 57                       127 80 9 22 1   8     0   7   70 57                 127
1131168 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131169 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   grade_6 0 46 18 1   1     2   0   44 24                       68 0 46 18 1   1     2   0   44 24                 68
1131170 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   grade_7 0 71 6 0   0     0   0   39 38                       77 0 71 6 0   0     0   0   39 38                 77
1131171 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   grade_8 0 56 14 0   0     2   0   43 29                       72 0 56 14 0   0     2   0   43 29                 72
1131172 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131173 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   kindergarten 2 40 4 1   0     0   1   23 25                       48 2 40 4 1   0     0   1   23 25                 48
1131174 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   pre_kindergarten 1 18 1 0   1     0   2   13 10                       23 1 18 1 0   1     0   2   13 10                 23
1131175 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_1 2 36 5 0   3     0   0   28 18                       46 2 36 5 0   3     0   0   28 18                 46
1131176 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_2 0 38 8 1   0     0   0   24 23                       47 0 38 8 1   0     0   0   24 23                 47
1131177 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_3 0 38 9 0   1     0   0   25 23                       48 0 38 9 0   1     0   0   25 23                 48
1131178 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_4 1 50 7 0   3     0   0   35 26                       61 1 50 7 0   3     0   0   35 26                 61
1131179 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_5 2 35 4 0   0     0   0   15 26                       41 2 35 4 0   0     0   0   15 26                 41
1131180 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   grade_6 1 21 8 1   1     0   1   17 16                       33 1 21 8 1   1     0   1   17 16                 33
1131181 MA Middlesex   school 2500022 420   Benjamin Banneker Charter Public (District) 250002200514 4200205 Benjamin Banneker Charter Public School   Regular School Yes Elementary PK 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131182 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_9 6 65 48 1   1     0   1   57 65                       122 6 65 48 1   1     0   1   57 65                 122
1131183 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_10 1 14 15 0   0     0   2   10 22                       32 1 14 15 0   0     0   2   10 22                 32
1131184 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_11 * * * *   *     *   *   1 2                       *                         1 2                  
1131185 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   grade_12 14 115 97 3   7     1   10   103 144                       247 14 115 97 3   7     1   10   103 144                 247
1131186 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1131187 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   kindergarten 0 0 42 0   0     0   0   14 28                       42 0 0 42 0   0     0   0   14 28                 42
1131188 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   pre_kindergarten 2 0 38 0   0     0   0   24 16                       40 2 0 38 0   0     0   0   24 16                 40
1131189 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   grade_1 2 0 38 0   0     0   0   21 19                       40 2 0 38 0   0     0   0   21 19                 40
1131190 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   grade_2 0 1 40 0   1     0   0   21 21                       42 0 1 40 0   1     0   0   21 21                 42
1131191 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   grade_3 1 1 36 0   0     0   0   24 14                       38 1 1 36 0   0     0   0   24 14                 38
1131192 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 05 2017   grade_4 0 0 40 0   0     0   0   22 18                       40 0 0 40 0   0     0   0   22 18                 40

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