enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
1133209 1133209 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133208 1133208 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_12 90 6 14 0   4     0   3   38 79                       117 90 6 14 0   4     0   3   38 79                 117
1133207 1133207 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_11 103 1 11 1   4     1   10   48 83                       131 103 1 11 1   4     1   10   48 83                 131
1133206 1133206 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_10 149 4 16 0   2     0   9   63 117                       180 149 4 16 0   2     0   9   63 117                 180
1133205 1133205 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_9 157 13 23 1   4     1   11   95 115                       210 157 13 23 1   4     1   11   95 115                 210
1133204 1133204 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_8 85 8 20 1   6     0   10   60 70                       130 85 8 20 1   6     0   10   60 70                 130
1133203 1133203 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_7 57 6 15 0   4     0   8   36 54                       90 57 6 15 0   4     0   8   36 54                 90
1133202 1133202 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_6 47 7 6 0   7     0   7   37 37                       74 47 7 6 0   7     0   7   37 37                 74
1133201 1133201 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_5 21 6 8 0   2     0   3   22 18                       40 21 6 8 0   2     0   3   22 18                 40
1133200 1133200 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 16 8 5 0   1     0   3   23 10                       33 16 8 5 0   1     0   3   23 10                 33
1133199 1133199 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_3 22 3 6 0   1     0   4   22 14                       36 22 3 6 0   1     0   4   22 14                 36
1133198 1133198 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_2 16 3 5 0   1     0   6   16 15                       31 16 3 5 0   1     0   6   16 15                 31
1133197 1133197 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_1 15 3 3 1   1     0   4   17 10                       27 15 3 3 1   1     0   4   17 10                 27
1133196 1133196 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   kindergarten 11 3 5 0   0     0   1   9 11                       20 11 3 5 0   0     0   1   9 11                 20
1133195 1133195 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133194 1133194 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_12 22 1 4 0   0     0   3   5 25                       30 22 1 4 0   0     0   3   5 25                 30
1133193 1133193 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_11 35 2 7 0   3     0   4   22 29                       51 35 2 7 0   3     0   4   22 29                 51
1133192 1133192 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_10 52 6 11 2   0     1   3   25 50                       75 52 6 11 2   0     1   3   25 50                 75
1133191 1133191 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_9 51 9 16 0   2     0   3   35 46                       81 51 9 16 0   2     0   3   35 46                 81
1133190 1133190 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_8 51 6 10 0   1     0   2   28 42                       70 51 6 10 0   1     0   2   28 42                 70
1133189 1133189 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_7 44 11 12 0   2     1   2   40 32                       72 44 11 12 0   2     1   2   40 32                 72
1133188 1133188 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_6 30 6 9 0   1     0   3   22 27                       49 30 6 9 0   1     0   3   22 27                 49
1133187 1133187 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_5 27 5 5 0   2     0   0   22 17                       39 27 5 5 0   2     0   0   22 17                 39
1133186 1133186 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_4 22 8 9 0   3     0   4   21 25                       46 22 8 9 0   3     0   4   21 25                 46
1133185 1133185 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_3 36 7 12 0   0     0   4   34 25                       59 36 7 12 0   0     0   4   34 25                 59
1133184 1133184 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_2 28 4 8 0   0     0   0   18 22                       40 28 4 8 0   0     0   0   18 22                 40
1133183 1133183 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_1 18 6 6 0   0     0   2   16 16                       32 18 6 6 0   0     0   2   16 16                 32
1133182 1133182 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Massachusetts Virtual Academy at Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2017   kindergarten 13 3 3 0   1     0   3   11 12                       23 13 3 3 0   1     0   3   11 12                 23
1133181 1133181 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133180 1133180 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_8 2 88 8 0   4     0   2   51 53                       104 2 88 8 0   4     0   2   51 53                 104
1133179 1133179 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_7 4 92 8 0   0     0   0   59 45                       104 4 92 8 0   0     0   0   59 45                 104
1133178 1133178 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1133177 1133177 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133176 1133176 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_5 8 4 23 0   1     0   1   18 19                       37 8 4 23 0   1     0   1   18 19                 37
1133175 1133175 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_4 9 6 15 0   2     0   2   18 16                       34 9 6 15 0   2     0   2   18 16                 34
1133174 1133174 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_3 12 6 17 0   0     0   3   21 17                       38 12 6 17 0   0     0   3   21 17                 38
1133173 1133173 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_2 16 8 27 0   2     0   1   29 25                       54 16 8 27 0   2     0   1   29 25                 54
1133172 1133172 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   grade_1 23 4 14 0   1     0   1   21 22                       43 23 4 14 0   1     0   1   21 22                 43
1133171 1133171 MA Essex   school 2500558 3511   Bentley Academy Charter School (District) 250055802844 35110205 Bentley Academy Charter School   Regular School Yes Elementary KG 05 2017   kindergarten 16 4 29 0   2     0   0   25 26                       51 16 4 29 0   2     0   0   25 26                 51
1133170 1133170 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133169 1133169 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   grade_2 4 12 35 0   0     0   4   29 26                       55 4 12 35 0   0     0   4   29 26                 55
1133168 1133168 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   grade_1 2 10 39 0   2     0   1   26 28                       54 2 10 39 0   2     0   1   26 28                 54
1133167 1133167 MA Hampden   school 2500557 3510   Springfield Preparatory Charter 250055702842 35100205 Springfield Preparatory Charter School   Regular School Yes Elementary KG 02 2017   kindergarten 4 18 31 0   1     0   0   28 26                       54 4 18 31 0   1     0   0   28 26                 54
1133166 1133166 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133165 1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1133164 1133164 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_7 78 4 12 1   2     1   4   52 50                       102 78 4 12 1   2     1   4   52 50                 102
1133163 1133163 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_6 79 8 6 0   3     1   5   57 45                       102 79 8 6 0   3     1   5   57 45                 102
1133162 1133162 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133161 1133161 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   grade_12 0 3 9 0   0     0   0   5 7                       12 0 3 9 0   0     0   0   5 7                 12
1133160 1133160 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   grade_11 0 6 23 0   0     0   0   15 14                       29 0 6 23 0   0     0   0   15 14                 29
1133159 1133159 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   grade_10 0 4 11 0   1     0   2   6 12                       18 0 4 11 0   1     0   2   6 12                 18
1133158 1133158 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2017   grade_9 6 28 91 2   0     0   7   73 61                       134 6 28 91 2   0     0   7   73 61                 134
1133157 1133157 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes Other 09 11 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133156 1133156 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes Other 09 11 2017   grade_11 9 1 8 0   0     0   2   9 11                       20 9 1 8 0   0     0   2   9 11                 20
1133155 1133155 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes Other 09 11 2017   grade_10 20 8 23 0   1     0   3   28 27                       55 20 8 23 0   1     0   3   28 27                 55
1133154 1133154 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes Other 09 11 2017   grade_9 32 10 56 0   0     0   4   46 56                       102 32 10 56 0   0     0   4   46 56                 102
1133153 1133153 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133152 1133152 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_12 5 5 2 0   0     0   0   7 5                       12 5 5 2 0   0     0   0   7 5                 12
1133151 1133151 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_11 10 20 1 0   5     0   1   15 22                       37 10 20 1 0   5     0   1   15 22                 37
1133150 1133150 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_10 15 11 13 2   9     0   1   30 21                       51 15 11 13 2   9     0   1   30 21                 51
1133149 1133149 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_9 21 27 12 0   9     0   1   33 37                       70 21 27 12 0   9     0   1   33 37                 70
1133148 1133148 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_8 27 24 18 1   4     0   1   29 46                       75 27 24 18 1   4     0   1   29 46                 75
1133147 1133147 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2017   grade_7 18 26 22 1   10     0   0   31 46                       77 18 26 22 1   10     0   0   31 46                 77
1133146 1133146 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133145 1133145 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_8 0 31 18 0   1     0   0   22 28                       50 0 31 18 0   1     0   0   22 28                 50
1133144 1133144 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_7 0 45 26 2   0     0   0   28 45                       73 0 45 26 2   0     0   0   28 45                 73
1133143 1133143 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_6 0 49 24 0   1     0   3   34 43                       77 0 49 24 0   1     0   3   34 43                 77
1133142 1133142 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_5 0 38 43 0   5     0   3   41 48                       89 0 38 43 0   5     0   3   41 48                 89
1133141 1133141 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_4 2 56 39 0   0     0   2   51 48                       99 2 56 39 0   0     0   2   51 48                 99
1133140 1133140 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_3 1 53 39 0   1     0   3   53 44                       97 1 53 39 0   1     0   3   53 44                 97
1133139 1133139 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_2 1 42 24 0   2     0   1   36 34                       70 1 42 24 0   2     0   1   36 34                 70
1133138 1133138 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   grade_1 0 42 27 0   1     0   2   42 30                       72 0 42 27 0   1     0   2   42 30                 72
1133137 1133137 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   pre_kindergarten 2 28 20 0   0     0   2   28 24                       52 2 28 20 0   0     0   2   28 24                 52
1133136 1133136 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2017   kindergarten 2 38 23 1   1     0   0   31 34                       65 2 38 23 1   1     0   0   31 34                 65
1133135 1133135 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133134 1133134 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   grade_12 1 27 12 0   0     0   0   15 25                       40 1 27 12 0   0     0   0   15 25                 40
1133133 1133133 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   grade_11 0 34 18 0   2     0   2   22 34                       56 0 34 18 0   2     0   2   22 34                 56
1133132 1133132 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   grade_10 1 56 11 0   3     0   0   29 42                       71 1 56 11 0   3     0   0   29 42                 71
1133131 1133131 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2017   grade_9 7 83 23 0   0     0   1   53 61                       114 7 83 23 0   0     0   1   53 61                 114
1133130 1133130 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133129 1133129 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_6 16 10 21 0   16     0   2   32 33                       65 16 10 21 0   16     0   2   32 33                 65
1133128 1133128 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_5 12 9 30 0   9     0   5   38 27                       65 12 9 30 0   9     0   5   38 27                 65
1133127 1133127 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_4 14 18 29 0   25     0   4   42 48                       90 14 18 29 0   25     0   4   42 48                 90
1133126 1133126 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_3 20 25 48 0   22     0   7   56 66                       122 20 25 48 0   22     0   7   56 66                 122
1133125 1133125 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_2 19 16 36 1   19     0   3   44 50                       94 19 16 36 1   19     0   3   44 50                 94
1133124 1133124 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   grade_1 20 25 36 0   24     0   5   47 63                       110 20 25 36 0   24     0   5   47 63                 110
1133123 1133123 MA Middlesex   school 2500545 3503   Lowell Collegiate Charter School (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Elementary KG 06 2017   kindergarten 15 25 40 0   16     0   4   57 43                       100 15 25 40 0   16     0   4   57 43                 100
1133122 1133122 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133121 1133121 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_10 3 17 49 0   0     0   0   32 37                       69 3 17 49 0   0     0   0   32 37                 69
1133120 1133120 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_9 6 27 44 0   1     0   1   38 41                       79 6 27 44 0   1     0   1   38 41                 79
1133119 1133119 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_8 3 18 57 0   1     0   1   36 44                       80 3 18 57 0   1     0   1   36 44                 80
1133118 1133118 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_7 5 26 50 0   1     0   0   41 41                       82 5 26 50 0   1     0   0   41 41                 82
1133117 1133117 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes Other 06 10 2017   grade_6 6 20 56 0   0     0   0   51 31                       82 6 20 56 0   0     0   0   51 31                 82
1133116 1133116 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133115 1133115 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   grade_12 3 4 62 0   0     1   0   25 45                       70 3 4 62 0   0     1   0   25 45                 70
1133114 1133114 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   grade_11 3 2 58 0   0     0   0   30 33                       63 3 2 58 0   0     0   0   30 33                 63
1133113 1133113 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   grade_10 11 5 76 0   0     0   0   49 43                       92 11 5 76 0   0     0   0   49 43                 92
1133112 1133112 MA Hampden   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2017   grade_9 6 6 91 0   0     0   0   43 60                       103 6 6 91 0   0     0   0   43 60                 103
1133111 1133111 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2017   sped_beyond_grade_12 * * * *   *     *   *                             *                                              
1133110 1133110 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2017   grade_12 116 1 2 0   0     0   2   30 91                       121 116 1 2 0   0     0   2   30 91                 121

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