Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by rowid descending

View and edit SQL

year

  • 2020 · 9,437
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
1374220 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 2020   grade_7 17 25 17 1   5     0   1   32 34 *                     66.0 17 25 17 1   5     0   1   32 34                 66
1374219 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 2020   grade_8 1 35 30 0   1     1   1   32 37 *                     69.0 1 35 30 0   1     1   1   32 37                 69
1374218 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 2020   grade_7 2 40 34 0   0     0   1   39 38 *                     77.0 2 40 34 0   0     0   1   39 38                 77
1374217 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 2020   grade_6 1 44 37 0   1     1   1   50 35 *                     85.0 1 44 37 0   1     1   1   50 35                 85
1374216 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 2020   grade_5 0 45 26 0   1     1   0   38 35 *                     73.0 0 45 26 0   1     1   0   38 35                 73
1374215 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 2020   grade_4 0 45 27 0   1     0   2   40 35 *                     75.0 0 45 27 0   1     0   2   40 35                 75
1374214 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 2020   grade_3 1 41 26 2   0     1   1   34 38 *                     72.0 1 41 26 2   0     1   1   34 38                 72
1374213 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 2020   grade_2 0 39 30 0   0     0   0   37 32 *                     69.0 0 39 30 0   0     0   0   37 32                 69
1374212 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 2020   grade_1 1 39 30 0   0     0   2   36 36 *                     72.0 1 39 30 0   0     0   2   36 36                 72
1374211 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 2020   pre_kindergarten 0 32 26 0   0     0   2   25 35 *                     60.0 0 32 26 0   0     0   2   25 35                 60
1374210 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 2020   kindergarten 1 33 24 0   0     1   0   28 31 *                     59.0 1 33 24 0   0     1   0   28 31                 59
1374209 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 2020   grade_12 0 43 11 0   0     0   1   24 31 *                     55.0 0 43 11 0   0     0   1   24 31                 55
1374208 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 2020   grade_11 0 25 12 0   1     0   1   18 21 *                     39.0 0 25 12 0   1     0   1   18 21                 39
1374207 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 2020   grade_10 2 32 23 0   0     0   1   29 29 *                     58.0 2 32 23 0   0     0   1   29 29                 58
1374206 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 2020   grade_9 2 25 14 0   0     0   0   28 13 *                     41.0 2 25 14 0   0     0   0   28 13                 41
1374205 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_9 9 6 11 0   16     0   1   24 19 *                     43.0 9 6 11 0   16     0   1   24 19                 43
1374204 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_8 12 8 30 0   9     0   2   34 27 *                     61.0 12 8 30 0   9     0   2   34 27                 61
1374203 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_7 9 18 30 0   31     0   3   47 44 *                     91.0 9 18 30 0   31     0   3   47 44                 91
1374202 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_6 17 26 47 0   25     0   5   50 70 *                     120.0 17 26 47 0   25     0   5   50 70                 120
1374201 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_5 13 18 38 1   23     0   0   49 44 *                     93.0 13 18 38 1   23     0   0   49 44                 93
1374200 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_4 16 25 36 0   32     0   5   52 62 *                     114.0 16 25 36 0   32     0   5   52 62                 114
1374199 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_3 12 28 40 0   25     0   6   57 54 *                     111.0 12 28 40 0   25     0   6   57 54                 111
1374198 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_2 11 23 34 0   43     0   3   59 55 *                     114.0 11 23 34 0   43     0   3   59 55                 114
1374197 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   grade_1 18 20 33 0   31     0   5   46 61 *                     107.0 18 20 33 0   31     0   5   46 61                 107
1374196 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2020   kindergarten 12 15 31 0   19     0   1   36 42 *                     78.0 12 15 31 0   19     0   1   36 42                 78
1374195 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_12 5 18 29 0   1     0   1   27 27 *                     54.0 5 18 29 0   1     0   1   27 27                 54
1374194 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_11 3 14 42 0   1     0   0   30 30 *                     60.0 3 14 42 0   1     0   0   30 30                 60
1374193 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_10 1 17 35 0   0     0   0   28 25 *                     53.0 1 17 35 0   0     0   0   28 25                 53
1374192 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_9 5 15 45 0   0     0   0   43 22 *                     65.0 5 15 45 0   0     0   0   43 22                 65
1374191 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_8 5 17 51 0   1     1   2   39 38 *                     77.0 5 17 51 0   1     1   2   39 38                 77
1374190 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_7 3 15 57 0   0     0   0   35 40 *                     75.0 3 15 57 0   0     0   0   35 40                 75
1374189 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2020   grade_6 36 32 5 0   0     1   5   40 39 *                     79.0 36 32 5 0   0     1   5   40 39                 79
1374188 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_12 1 2 52 0   0     0   1   20 36 *                     56.0 1 2 52 0   0     0   1   20 36                 56
1374187 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_11 2 6 56 0   0     0   0   25 39 *                     64.0 2 6 56 0   0     0   0   25 39                 64
1374186 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_10 0 1 74 0   0     0   0   37 38 *                     75.0 0 1 74 0   0     0   0   37 38                 75
1374185 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2020   grade_9 0 9 74 0   0     0   0   43 40 *                     83.0 0 9 74 0   0     0   0   43 40                 83
1374184 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_12 109 1 3 0   1     0   5   34 85 *                     119.0 109 1 3 0   1     0   5   34 85                 119
1374183 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_11 121 2 4 1   4     0   4   45 91 *                     136.0 121 2 4 1   4     0   4   45 91                 136
1374182 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_10 134 3 4 0   2     1   8   43 109 *                     152.0 134 3 4 0   2     1   8   43 109                 152
1374181 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_9 134 1 0 0   1     1   7   40 104 *                     144.0 134 1 0 0   1     1   7   40 104                 144
1374180 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_12 105 0 2 0   0     0   0   34 72 *                     107.0 105 0 2 0   0     0   0   34 72                 107
1374179 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_11 91 3 9 0   0     0   5   34 73 *                     108.0 91 3 9 0   0     0   5   34 73                 108
1374178 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_10 104 4 4 0   0     1   0   30 83 *                     113.0 104 4 4 0   0     1   0   30 83                 113
1374177 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2020   grade_9 116 0 4 0   2     0   1   30 93 *                     123.0 116 0 4 0   2     0   1   30 93                 123
1374176 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2020   grade_12 234 6 67 1   3     0   6   171 146 *                     317.0 234 6 67 1   3     0   6   171 146                 317
1374175 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2020   grade_11 191 3 66 0   5     0   8   154 119 *                     273.0 191 3 66 0   5     0   8   154 119                 273
1374174 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2020   grade_10 203 16 73 2   2     0   16   164 148 *                     312.0 203 16 73 2   2     0   16   164 148                 312
1374173 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2020   grade_9 239 6 93 3   6     0   5   186 164 *                     352.0 239 6 93 3   6     0   5   186 164                 352
1374172 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 145 9 3 1   4     0   8   108 62 *                     170.0 145 9 3 1   4     0   8   108 62                 170
1374171 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 151 6 5 2   3     0   10   119 58 *                     177.0 151 6 5 2   3     0   10   119 58                 177
1374170 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 156 7 5 2   4     0   12   119 67 *                     186.0 156 7 5 2   4     0   12   119 67                 186
1374169 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 141 9 7 1   1     1   13   100 73 *                     173.0 141 9 7 1   1     1   13   100 73                 173
1374168 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 222 3 9 2   1     0   12   131 118 *                     249.0 222 3 9 2   1     0   12   131 118                 249
1374167 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 199 1 20 0   3     0   10   144 88 *                     233.0 199 1 20 0   3     0   10   144 88                 233
1374166 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 222 3 17 1   4     1   10   164 94 *                     258.0 222 3 17 1   4     1   10   164 94                 258
1374165 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 197 3 18 0   1     0   10   138 90 *                     229.0 197 3 18 0   1     0   10   138 90                 229
1374164 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_12 218 3 23 1   2     0   3   149 101 *                     250.0 218 3 23 1   2     0   3   149 101                 250
1374163 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_11 237 0 35 0   2     0   4   160 118 *                     278.0 237 0 35 0   2     0   4   160 118                 278
1374162 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_10 261 4 30 0   3     0   4   176 126 *                     302.0 261 4 30 0   3     0   4   176 126                 302
1374161 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_9 273 4 35 1   0     0   2   182 133 *                     315.0 273 4 35 1   0     0   2   182 133                 315
1374160 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2020   grade_12 123 4 10 0   0     0   7   95 49 *                     144.0 123 4 10 0   0     0   7   95 49                 144
1374159 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2020   grade_11 142 4 5 0   3     0   2   102 54 *                     156.0 142 4 5 0   3     0   2   102 54                 156
1374158 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2020   grade_10 148 0 10 0   3     0   6   118 49 *                     167.0 148 0 10 0   3     0   6   118 49                 167
1374157 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2020   grade_9 157 3 8 2   1     0   0   124 47 *                     171.0 157 3 8 2   1     0   0   124 47                 171
1374156 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 148 110 44 0   6     0   25   170 163 *                     333.0 148 110 44 0   6     0   25   170 163                 333
1374155 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 170 120 46 0   7     0   27   188 181 *                     370.0 170 120 46 0   7     0   27   188 181                 370
1374154 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 165 133 45 0   6     0   18   178 189 *                     367.0 165 133 45 0   6     0   18   178 189                 367
1374153 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 175 140 51 0   3     0   19   175 213 *                     388.0 175 140 51 0   3     0   19   175 213                 388
1374152 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_12 283 2 17 0   3     0   3   186 122 *                     308.0 283 2 17 0   3     0   3   186 122                 308
1374151 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_11 286 4 16 1   3     0   6   189 127 *                     316.0 286 4 16 1   3     0   6   189 127                 316
1374150 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_10 300 3 15 1   5     0   10   198 136 *                     334.0 300 3 15 1   5     0   10   198 136                 334
1374149 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2020   grade_9 280 4 19 0   0     0   4   182 125 *                     307.0 280 4 19 0   0     0   4   182 125                 307
1374148 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 143 1 8 0   2     0   3   91 64 *                     157.0 143 1 8 0   2     0   3   91 64                 157
1374147 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 134 3 8 1   0     0   5   99 52 *                     151.0 134 3 8 1   0     0   5   99 52                 151
1374146 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 147 0 4 0   0     0   7   94 63 *                     158.0 147 0 4 0   0     0   7   94 63                 158
1374145 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 144 3 9 0   0     0   4   95 65 *                     160.0 144 3 9 0   0     0   4   95 65                 160
1374144 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 124 3 1 0   2     0   5   93 42 *                     135.0 124 3 1 0   2     0   5   93 42                 135
1374143 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 121 3 5 1   1     0   1   78 53 *                     132.0 121 3 5 1   1     0   1   78 53                 132
1374142 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 129 0 4 0   1     0   5   96 43 *                     139.0 129 0 4 0   1     0   5   96 43                 139
1374141 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 143 0 3 0   1     0   3   91 59 *                     150.0 143 0 3 0   1     0   3   91 59                 150
1374140 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2020   grade_12 201 6 73 0   1     1   6   157 131 *                     288.0 201 6 73 0   1     1   6   157 131                 288
1374139 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2020   grade_11 179 7 115 0   1     1   7   167 143 *                     310.0 179 7 115 0   1     1   7   167 143                 310
1374138 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2020   grade_10 188 11 130 1   4     0   7   181 160 *                     341.0 188 11 130 1   4     0   7   181 160                 341
1374137 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2020   grade_9 193 9 127 0   2     1   4   190 146 *                     336.0 193 9 127 0   2     1   4   190 146                 336
1374136 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_12 146 0 10 1   1     0   4   97 65 *                     162.0 146 0 10 1   1     0   4   97 65                 162
1374135 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_11 156 8 8 0   6     0   3   114 64 *                     181.0 156 8 8 0   6     0   3   114 64                 181
1374134 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_10 159 5 10 1   3     0   7   114 71 *                     185.0 159 5 10 1   3     0   7   114 71                 185
1374133 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Career and Technical School No High 09 12 2020   grade_9 157 2 18 1   1     1   1   104 75 *                     181.0 157 2 18 1   1     1   1   104 75                 181
1374132 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 110 2 2 0   0     0   3   71 46 *                     117.0 110 2 2 0   0     0   3   71 46                 117
1374131 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 110 1 0 0   0     0   5   73 43 *                     116.0 110 1 0 0   0     0   5   73 43                 116
1374130 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 127 0 3 0   1     0   3   79 55 *                     134.0 127 0 3 0   1     0   3   79 55                 134
1374129 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 135 0 2 0   1     0   2   82 58 *                     140.0 135 0 2 0   1     0   2   82 58                 140
1374128 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_12 264 5 56 0   5     0   12   178 164 0                     342.0 264 5 56 0   5     0   12   178 164 0               342
1374127 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_11 271 7 59 0   6     0   10   170 181 2                     353.0 271 7 59 0   6     0   10   170 181 2               353
1374126 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_10 281 10 66 0   6     0   14   198 178 1                     377.0 281 10 66 0   6     0   14   198 178 1               377
1374125 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 265 5 63 0   9     0   16   158 197 3                     358.0 265 5 63 0   9     0   16   158 197 3               358
1374124 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2020   grade_12 101 6 7 0   8     0   5   83 43 *                     127.0 101 6 7 0   8     0   5   83 43                 127
1374123 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2020   grade_11 122 2 12 0   4     0   5   83 61 *                     145.0 122 2 12 0   4     0   5   83 61                 145
1374122 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2020   grade_10 109 3 6 1   8     0   8   91 43 *                     135.0 109 3 6 1   8     0   8   91 43                 135
1374121 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Career and Technical School No High 09 12 2020   grade_9 149 10 13 1   7     0   11   116 73 *                     191.0 149 10 13 1   7     0   11   116 73                 191

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