Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by school descending

View and edit SQL

year

grade

  • grade_9 · 2,737
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
2237890 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester: Worcester Technical High   Career and Technical School No High 09 12 2018   grade_9 137 58 144 1   23     0   17   193 187                       380.0 137 58 144 1   23     0   17   193 187                 380
2237844 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_9 4 4 19 0   9     0   0   15 21                       36.0 4 4 19 0   9     0   0   15 21                 36
2237885 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester: South High Community   Regular School No High 09 12 2018   grade_9 84 53 173 0   38     0   15   185 178                       363.0 84 53 173 0   38     0   15   185 178                 363
2237880 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester: North High   Regular School No High 09 12 2018   grade_9 58 81 167 0   22     0   13   170 171                       341.0 58 81 167 0   22     0   13   170 171                 341
2237875 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester: Doherty Memorial High   Regular School No High 09 12 2018   grade_9 166 56 116 1   23     0   21   217 166                       383.0 166 56 116 1   23     0   21   217 166                 383
2237851 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester: Claremont Academy   Regular School No High 07 12 2018   grade_9 7 8 65 0   7     0   1   51 37                       88.0 7 8 65 0   7     0   1   51 37                 88
2237870 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester: Burncoat Senior High   Regular School No High 09 12 2018   grade_9 64 48 117 0   9     0   12   129 121                       250.0 64 48 117 0   9     0   12   129 121                 250
743389 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2015   grade_9 144 45 145 0   24     0   12   165 205                       370 144 45 145 0   24     0   12   165 205                 370
940198 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Vocational Education School No 3 09 12 2016   grade_9 126 61 121 0   16     0   12   147 189                       336 126 61 121 0   16     0   12   147 189                 336
1131065 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2017   grade_9 130 72 118 0   28     0   11   142 217                       359 130 72 118 0   28     0   11   142 217                 359
1372413 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2020   grade_9 124 70 154 0   30     0   15   155 238 *                     393.0 124 70 154 0   30     0   15   155 238                 393
2047486 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester Technical High   Career and Technical School No High 09 12 2019   grade_9 141 54 140 1   36     1   13   172 214                       386.0 141 54 140 1   36     1   13   172 214                 386
1679676 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester - Worcester Technical High   Career and Technical School No High 09 12 2021   grade_9 101 80 148 0   29     0   11   160 209 *                     369.0 101 80 148 0   29     0   11   160 209                 369
1679637 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester - University Pk Campus School   Regular School No High 07 12 2021   grade_9 3 7 24 0   5     0   0   20 19 *                     39.0 3 7 24 0   5     0   0   20 19                 39
1679671 MA Worcester   school 2513230 348   Worcester 251323002244 3480520 Worcester - South High Community   Regular School No High 09 12 2021   grade_9 110 76 191 0   43     0   16   215 221 *                     436.0 110 76 191 0   43     0   16   215 221                 436
1679666 MA Worcester   school 2513230 348   Worcester 251323002239 3480515 Worcester - North High   Regular School No High 09 12 2021   grade_9 57 69 195 0   18     0   12   182 169 *                     351.0 57 69 195 0   18     0   12   182 169                 351
1679661 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Worcester - Doherty Memorial High   Regular School No High 09 12 2021   grade_9 119 42 139 1   20     0   14   192 143 *                     335.0 119 42 139 1   20     0   14   192 143                 335
1679643 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Worcester - Claremont Academy   Regular School No High 07 12 2021   grade_9 3 12 63 0   5     0   2   44 41 *                     85.0 3 12 63 0   5     0   2   44 41                 85
1679656 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Worcester - Burncoat Senior High   Regular School No High 09 12 2021   grade_9 104 66 126 1   12     0   11   164 156 *                     320.0 104 66 126 1   12     0   11   164 156                 320
2237554 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn: Woburn High   Regular School No High 09 12 2018   grade_9 219 27 31 0   15     0   5   149 148                       297.0 219 27 31 0   15     0   5   149 148                 297
743095 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No 3 09 12 2015   grade_9 249 30 35 0   18     1   4   172 165                       337 249 30 35 0   18     1   4   172 165                 337
939904 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No 3 09 12 2016   grade_9 263 16 36 1   25     1   7   169 180                       349 263 16 36 1   25     1   7   169 180                 349
1130726 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2017   grade_9 233 23 31 0   18     0   4   142 167                       309 233 23 31 0   18     0   4   142 167                 309
1372119 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2020   grade_9 209 13 32 5   18     0   6   140 143 *                     283.0 209 13 32 5   18     0   6   140 143                 283
2047192 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn High   Regular School No High 09 12 2019   grade_9 244 25 41 1   21     1   8   167 174                       341.0 244 25 41 1   21     1   8   167 174                 341
1679380 MA Middlesex   school 2513200 347   Woburn 251320002193 3470505 Woburn - Woburn High   Regular School No High 09 12 2021   grade_9 198 19 36 1   18     0   8   144 136 *                     280.0 198 19 36 1   18     0   8   144 136                 280
738777 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 5 0 116 0   1     0   0   66 56                       122 5 0 116 0   1     0   0   66 56                 122
935625 MA Hampden   school 2506270 137   Holyoke 250627000913 1370605 Wm J Dean Vocational Technical High   Vocational Education School No 3 09 12 2016   grade_9 3 5 104 0   1     0   0   56 57                       113 3 5 104 0   1     0   0   56 57                 113
2237483 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop: Winthrop High School   Regular School No High 09 12 2018   grade_9 146 2 23 0   1     0   1   91 82                       173.0 146 2 23 0   1     0   1   91 82                 173
743034 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2015   grade_9 98 2 11 2   0     0   3   55 61                       116 98 2 11 2   0     0   3   55 61                 116
939843 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop Sr High   Regular School No 3 08 12 2016   grade_9 137 2 13 0   1     0   6   91 68                       159 137 2 13 0   1     0   6   91 68                 159
1130655 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2017   grade_9 125 6 15 0   1     0   0   65 82                       147 125 6 15 0   1     0   0   65 82                 147
1372065 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2020   grade_9 110 0 25 0   2     0   1   73 65 *                     138.0 110 0 25 0   2     0   1   73 65                 138
2047138 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop High School   Regular School No High 09 12 2019   grade_9 117 3 27 0   1     0   1   80 69                       149.0 117 3 27 0   1     0   1   80 69                 149
1679325 MA Suffolk   school 2513170 346   Winthrop 251317002180 3460505 Winthrop - Winthrop High School   Regular School No High 09 12 2021   grade_9 103 2 29 0   2     0   3   78 61 *                     139.0 103 2 29 0   2     0   3   78 61                 139
2237464 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester: Winchester High School   Regular School No High 09 12 2018   grade_9 284 4 14 1   57     0   6   175 191                       366.0 284 4 14 1   57     0   6   175 191                 366
743020 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No 3 09 12 2015   grade_9 253 6 10 0   56     0   11   188 148                       336 253 6 10 0   56     0   11   188 148                 336
939829 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No 3 09 12 2016   grade_9 229 1 12 0   41     0   11   144 150                       294 229 1 12 0   41     0   11   144 150                 294
1130636 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2017   grade_9 246 9 15 1   72     0   16   169 190                       359 246 9 15 1   72     0   16   169 190                 359
1372050 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2020   grade_9 262 7 9 1   72     0   11   179 182 *                     362.0 262 7 9 1   72     0   11   179 182                 362
2047124 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester High School   Regular School No High 09 12 2019   grade_9 247 1 13 1   64     2   16   169 175                       344.0 247 1 13 1   64     2   16   169 175                 344
1679310 MA Middlesex   school 2513110 344   Winchester 251311002174 3440505 Winchester - Winchester High School   Regular School No High 09 12 2021   grade_9 251 6 12 2   57     0   16   158 185 *                     344.0 251 6 12 2   57     0   16   158 185                 344
2237418 MA Worcester   school 2513080 343   Winchendon 251308002786 3430515 Winchendon: Murdock High School   Regular School No High 09 12 2018   grade_9 77 0 7 1   1     0   4   51 39                       90.0 77 0 7 1   1     0   4   51 39                 90
1679271 MA Worcester   school 2513080 343   Winchendon 251308002786 3430515 Winchendon - Murdock High School   Regular School No High 09 12 2021   grade_9 61 0 4 0   0     1   3   40 29 *                     69.0 61 0 4 0   0     1   3   40 29                 69
1679267 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Winchendon - Murdock Academy for Success   Alternative School No High 09 12 2021   grade_9 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
2237395 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington: Wilmington High   Regular School No High 09 12 2018   grade_9 166 4 6 0   14     0   8   93 105                       198.0 166 4 6 0   14     0   8   93 105                 198
742967 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2015   grade_9 202 5 5 0   14     1   5   108 124                       232 202 5 5 0   14     1   5   108 124                 232
939772 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2016   grade_9 186 2 6 1   11     0   5   110 101                       211 186 2 6 1   11     0   5   110 101                 211
1130567 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2017   grade_9 186 6 7 0   11     0   1   107 104                       211 186 6 7 0   11     0   1   107 104                 211
1371993 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2020   grade_9 166 3 7 0   9     0   10   97 98 *                     195.0 166 3 7 0   9     0   10   97 98                 195
2047067 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2019   grade_9 175 3 14 0   9     0   7   100 108                       208.0 175 3 14 0   9     0   7   100 108                 208
1679253 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington - Wilmington High   Regular School No High 09 12 2021   grade_9 141 2 7 1   9     0   8   87 81 *                     168.0 141 2 7 1   9     0   8   87 81                 168
736680 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2015   grade_9 3 27 11 0   1     0   1   32 11                       43 3 27 11 0   1     0   1   32 11                 43
933547 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No 4 KG 12 2016   grade_9 5 19 14 0   0     0   0   29 9                       38 5 19 14 0   0     0   0   29 9                 38
1123140 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2017   grade_9 4 31 25 0   1     0   1   41 21                       62 4 31 25 0   1     0   1   41 21                 62
1365783 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other KG 12 2020   grade_9 3 24 26 1   1     0   1   41 15 *                     56.0 3 24 26 1   1     0   1   41 15                 56
2040826 MA Suffolk   school 2502790 35   Boston 250279000342 350363 William McKinley   Regular School No Other 01 12 2019   grade_9 1 25 25 0   2     0   3   44 12                       56.0 1 25 25 0   2     0   3   44 12                 56
2239912 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical: Whittier Regional Vocational   Career and Technical School No High 09 12 2018   grade_9 210 2 60 1   4     0   11   160 128                       288.0 210 2 60 1   4     0   11   160 128                 288
1681421 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical - Whittier Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 212 10 93 1   6     0   13   174 161 *                     335.0 212 10 93 1   6     0   13   174 161                 335
745131 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2015   grade_9 259 5 49 0   3     0   11   183 144                       327 259 5 49 0   3     0   11   183 144                 327
941950 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2016   grade_9 260 6 59 2   5     0   10   181 161                       342 260 6 59 2   5     0   10   181 161                 342
1133097 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2017   grade_9 248 5 57 2   2     0   4   163 155                       318 248 5 57 2   2     0   4   163 155                 318
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
2049249 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2019   grade_9 215 15 71 2   2     0   15   164 156                       320.0 215 15 71 2   2     0   15   164 156                 320
2239782 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson: Whitman Hanson Regional   Regular School No High 09 12 2018   grade_9 259 8 7 2   2     0   6   134 150                       284.0 259 8 7 2   2     0   6   134 150                 284
1681315 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson - Whitman Hanson Regional   Regular School No High 09 12 2021   grade_9 206 10 14 0   3     0   7   126 114 *                     240.0 206 10 14 0   3     0   7   126 114                 240
745022 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2015   grade_9 282 2 5 0   2     0   5   138 158                       296 282 2 5 0   2     0   5   138 158                 296
941843 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No 3 09 12 2016   grade_9 265 6 5 2   3     0   8   142 147                       289 265 6 5 2   3     0   8   142 147                 289
1132967 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2017   grade_9 244 7 7 0   7     2   4   133 138                       271 244 7 7 0   7     2   4   133 138                 271
1374067 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2020   grade_9 241 10 15 3   2     1   10   156 126 *                     282.0 241 10 15 3   2     1   10   156 126                 282
2049141 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman Hanson Regional   Regular School No High 09 12 2019   grade_9 265 8 9 1   1     0   6   147 143                       290.0 265 8 9 1   1     0   6   147 143                 290
740288 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_9 6 6 9 0   0     0   4   22 3                       25 6 6 9 0   0     0   4   22 3                 25
937123 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2016   grade_9 8 5 15 1   0     0   0   22 7                       29 8 5 15 1   0     0   0   22 7                 29
1127395 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_9 9 6 10 0   1     0   0   21 5                       26 9 6 10 0   1     0   0   21 5                 26
1369351 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_9 6 7 13 0   1     0   2   22 7 *                     29.0 6 7 13 0   1     0   2   22 7                 29
2044424 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2019   grade_9 4 2 7 0   0     0   1   12 2                       14.0 4 2 7 0   0     0   1   12 2                 14
2237339 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth: Weymouth High School   Regular School No High 09 12 2018   grade_9 374 37 40 0   26     0   18   251 244                       495.0 374 37 40 0   26     0   18   251 244                 495
742921 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   grade_9 508 27 42 2   22     0   16   323 294                       617 508 27 42 2   22     0   16   323 294                 617
939727 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2016   grade_9 476 26 38 1   20     0   20   327 254                       581 476 26 38 1   20     0   20   327 254                 581
1130511 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2017   grade_9 443 29 60 2   34     0   13   308 273                       581 443 29 60 2   34     0   13   308 273                 581
1371955 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2020   grade_9 353 27 50 1   14     1   18   250 214 *                     464.0 353 27 50 1   14     1   18   250 214                 464
2047029 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2019   grade_9 375 30 44 0   25     1   26   270 230                       501.0 375 30 44 0   25     1   26   270 230                 501
1679216 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth - Weymouth High School   Regular School No High 08 12 2021   grade_9 338 49 67 2   24     1   13   232 262 *                     494.0 338 49 67 2   24     1   13   232 262                 494
2237276 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood: Westwood High   Regular School No High 09 12 2018   grade_9 215 8 10 0   18     0   2   113 140                       253.0 215 8 10 0   18     0   2   113 140                 253
742872 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2015   grade_9 213 8 6 0   12     0   8   114 133                       247 213 8 6 0   12     0   8   114 133                 247
939677 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No 3 09 12 2016   grade_9 231 8 6 0   14     0   1   134 126                       260 231 8 6 0   14     0   1   134 126                 260
1130448 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2017   grade_9 195 10 4 0   23     0   5   103 134                       237 195 10 4 0   23     0   5   103 134                 237
1371905 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2020   grade_9 203 10 11 0   22     0   10   118 138 *                     256.0 203 10 11 0   22     0   10   118 138                 256
2046980 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2019   grade_9 199 10 8 0   36     0   4   116 141                       257.0 199 10 8 0   36     0   4   116 141                 257
1679160 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood - Westwood High   Regular School No High 09 12 2021   grade_9 181 7 12 0   33     0   10   126 116 *                     243.0 181 7 12 0   33     0   10   126 116                 243
2237170 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_9 87 0 1 2   1     0   2   54 39                       93.0 87 0 1 2   1     0   2   54 39                 93
939601 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport Senior High School   Regular School No 3 08 12 2016   grade_9 95 1 3 0   3     0   4   55 51                       106 95 1 3 0   3     0   4   55 51                 106
1130355 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_9 53 0 2 1   1     0   3   36 24                       60 53 0 2 1   1     0   3   36 24                 60
1371831 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2020   grade_9 75 0 4 0   1     0   3   49 34 *                     83.0 75 0 4 0   1     0   3   49 34                 83
2046905 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2019   grade_9 84 0 1 1   1     0   2   48 41                       89.0 84 0 1 1   1     0   2   48 41                 89
742796 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport High   Regular School No 3 08 12 2015   grade_9 68 1 1 0   0     0   1   39 32                       71 68 1 1 0   0     0   1   39 32                 71
1679084 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport - Westport Junior/Senior High School   Regular School No High 07 12 2021   grade_9 80 1 6 0   0     0   5   48 44 *                     92.0 80 1 6 0   0     0   5   48 44                 92
2237153 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston: Weston High   Regular School No High 09 12 2018   grade_9 116 8 8 0   28     0   13   87 86                       173.0 116 8 8 0   28     0   13   87 86                 173
742780 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No 3 09 12 2015   grade_9 105 11 6 0   18     0   9   83 66                       149 105 11 6 0   18     0   9   83 66                 149
939587 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No 3 09 12 2016   grade_9 140 12 16 1   27     0   10   96 110                       206 140 12 16 1   27     0   10   96 110                 206

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