enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by multiracial_int 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
1123699 1123699 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_9 216 739 183 4   29     3   49   687 536                       1223 216 739 183 4   29     3   49   687 536                 1223
1123812 1123812 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_9 272 38 47 0   95     0   48   266 234                       500 272 38 47 0   95     0   48   266 234                 500
1123814 1123814 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_11 279 35 52 0   80     0   46   260 232                       492 279 35 52 0   80     0   46   260 232                 492
1123700 1123700 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_10 218 642 115 4   27     1   41   515 533                       1048 218 642 115 4   27     1   41   515 533                 1048
1123815 1123815 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_12 280 44 49 0   73     0   33   224 255                       479 280 44 49 0   73     0   33   224 255                 479
1123970 1123970 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_9 197 136 70 5   49     1   33   241 250                       491 197 136 70 5   49     1   33   241 250                 491
1123813 1123813 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2017   grade_10 300 34 58 0   85     1   31   243 266                       509 300 34 58 0   85     1   31   243 266                 509
1126958 1126958 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_9 263 1 168 0   18     1   30   248 233                       481 263 1 168 0   18     1   30   248 233                 481
1129971 1129971 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_1 156 10 15 2   2     0   30   115 100                       215 156 10 15 2   2     0   30   115 100                 215
1124823 1124823 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_10 283 43 128 0   28     2   29   261 252                       513 283 43 128 0   28     2   29   261 252                 513
1127544 1127544 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_12 316 21 49 0   64     0   29   220 259                       479 316 21 49 0   64     0   29   220 259                 479
1123701 1123701 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_11 169 633 111 4   31     2   28   494 484                       978 169 633 111 4   31     2   28   494 484                 978
1126959 1126959 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_10 279 1 171 2   17     1   28   271 228                       499 279 1 171 2   17     1   28   271 228                 499
1127376 1127376 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_6 205 32 132 3   6     0   28   211 195                       406 205 32 132 3   6     0   28   211 195                 406
1127541 1127541 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_9 338 36 47 1   71     0   28   259 262                       521 338 36 47 1   71     0   28   259 262                 521
1130123 1130123 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_6 291 9 18 0   46     0   28   215 177                       392 291 9 18 0   46     0   28   215 177                 392
1131035 1131035 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2017   grade_8 228 61 154 1   33     0   28   260 245                       505 228 61 154 1   33     0   28   260 245                 505
1131734 1131734 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_7 260 8 22 0   151     0   28   236 233                       469 260 8 22 0   151     0   28   236 233                 469
1133072 1133072 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 163 133 48 0   7     0   28   187 192                       379 163 133 48 0   7     0   28   187 192                 379
1122175 1122175 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_6 306 21 22 0   45     0   27   188 233                       421 306 21 22 0   45     0   27   188 233                 421
1123971 1123971 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2017   grade_10 182 169 73 1   58     1   27   274 237                       511 182 169 73 1   58     1   27   274 237                 511
1126064 1126064 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_9 254 20 18 0   233     0   27   270 282                       552 254 20 18 0   233     0   27   270 282                 552
1122428 1122428 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2017   grade_12 201 12 7 0   44     0   26   131 159                       290 201 12 7 0   44     0   26   131 159                 290
1123702 1123702 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2017   grade_12 194 622 125 3   23     1   25   444 549                       993 194 622 125 3   23     1   25   444 549                 993
1124822 1124822 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_9 344 45 150 3   30     0   25   298 299                       597 344 45 150 3   30     0   25   298 299                 597
1126868 1126868 MA Middlesex   school 2507620 178   Melrose 250762001800 1780003 Early Childhood Center   Regular School No Elementary PK PK 2017   pre_kindergarten 244 6 4 0   11     0   25   153 137                       290 244 6 4 0   11     0   25   153 137                 290
1127219 1127219 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No Middle 07 08 2017   grade_7 352 10 15 2   41     0   25   211 234                       445 352 10 15 2   41     0   25   211 234                 445
1131031 1131031 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Burncoat Middle School   Regular School No Middle 07 08 2017   grade_7 105 31 120 0   14     0   25   161 134                       295 105 31 120 0   14     0   25   161 134                 295
1131739 1131739 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2017   grade_11 291 8 13 2   117     0   25   224 232                       456 291 8 13 2   117     0   25   224 232                 456
1122322 1122322 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable Intermediate School   Regular School No Middle 06 07 2017   grade_6 261 26 39 2   5     0   24   167 190                       357 261 26 39 2   5     0   24   167 190                 357
1125098 1125098 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_2 129 6 30 1   0     0   24   103 87                       190 129 6 30 1   0     0   24   103 87                 190
1126066 1126066 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_11 307 20 22 0   184     0   24   293 264                       557 307 20 22 0   184     0   24   293 264                 557
1127222 1127222 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2017   grade_6 331 8 28 0   30     0   24   200 221                       421 331 8 28 0   30     0   24   200 221                 421
1127533 1127533 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2017   grade_6 203 19 21 1   41     0   24   171 138                       309 203 19 21 1   41     0   24   171 138                 309
1129975 1129975 MA Plymouth   school 2512060 310   Wareham 251206001989 3100017 Minot Forest   Regular School No Elementary 03 04 2017   grade_3 153 22 12 3   2     0   24   93 123                       216 153 22 12 3   2     0   24   93 123                 216
1133023 1133023 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_10 235 22 193 3   90     0   24   332 235                       567 235 22 193 3   90     0   24   332 235                 567
1127384 1127384 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_9 189 86 270 3   3     1   23   317 258                       575 189 86 270 3   3     1   23   317 258                 575
1127542 1127542 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_10 362 21 50 3   78     0   23   268 269                       537 362 21 50 3   78     0   23   268 269                 537
1128251 1128251 MA Plymouth   school 2509720 239   Plymouth 250972002531 2390405 Plymouth Commun Intermediate   Regular School No Middle 06 08 2017   grade_8 297 6 13 0   5     0   23   172 172                       344 297 6 13 0   5     0   23   172 172                 344
1129701 1129701 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_8 435 90 90 1   5     0   23   319 325                       644 435 90 90 1   5     0   23   319 325                 644
1129703 1129703 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_10 314 71 57 0   14     4   23   261 221                       483 314 71 57 0   14     4   23   261 221                 483
1129972 1129972 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   grade_2 161 17 14 2   3     0   23   118 102                       220 161 17 14 2   3     0   23   118 102                 220
1131735 1131735 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No Middle 07 08 2017   grade_8 257 10 12 1   139     0   23   240 202                       442 257 10 12 1   139     0   23   240 202                 442
1131766 1131766 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst Regional Middle School   Regular School No Middle 07 08 2017   grade_8 121 16 41 0   16     1   23   100 118                       218 121 16 41 0   16     1   23   100 118                 218
1131770 1131770 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_11 135 24 31 0   24     0   23   136 101                       237 135 24 31 0   24     0   23   136 101                 237
1131771 1131771 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_12 142 14 26 0   23     0   23   113 115                       228 142 14 26 0   23     0   23   113 115                 228
1122180 1122180 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_10 244 16 26 0   42     0   22   157 193                       350 244 16 26 0   42     0   22   157 193                 350
1122420 1122420 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_5 238 10 26 1   51     0   22   175 173                       348 238 10 26 1   51     0   22   175 173                 348
1124909 1124909 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2017   grade_9 92 18 132 0   16     0   22   156 124                       280 92 18 132 0   16     0   22   156 124                 280
1125032 1125032 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2017   grade_9 334 26 127 0   26     1   22   272 264                       536 334 26 127 0   26     1   22   272 264                 536
1126065 1126065 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No High 09 12 2017   grade_10 305 14 22 0   192     0   22   279 276                       555 305 14 22 0   192     0   22   279 276                 555
1127385 1127385 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_10 160 62 268 6   7     2   22   299 228                       527 160 62 268 6   7     2   22   299 228                 527
1127546 1127546 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2017   grade_9 312 32 27 0   90     0   22   256 227                       483 312 32 27 0   90     0   22   256 227                 483
1127549 1127549 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No High 09 12 2017   grade_12 276 28 34 0   91     0   22   226 225                       451 276 28 34 0   91     0   22   226 225                 451
1128159 1128159 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_6 109 22 25 0   3     1   22   96 86                       182 109 22 25 0   3     1   22   96 86                 182
1129970 1129970 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary KG 02 2017   kindergarten 128 10 11 1   1     0   22   75 98                       173 128 10 11 1   1     0   22   75 98                 173
1129988 1129988 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham Senior High   Regular School No High 09 12 2017   grade_9 105 22 17 1   3     1   22   91 80                       171 105 22 17 1   3     1   22   91 80                 171
1130125 1130125 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_8 303 12 16 0   50     0   22   206 197                       403 303 12 16 0   50     0   22   206 197                 403
1130129 1130129 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2017   grade_11 275 29 20 0   52     1   22   193 206                       399 275 29 20 0   52     1   22   193 206                 399
1130463 1130463 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No Middle 05 08 2017   grade_7 370 34 29 0   23     1   22   248 231                       479 370 34 29 0   23     1   22   248 231                 479
1131042 1131042 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2017   grade_7 103 57 181 1   49     0   22   209 204                       413 103 57 181 1   49     0   22   209 204                 413
1131768 1131768 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2017   grade_9 140 15 36 1   20     0   22   115 119                       234 140 15 36 1   20     0   22   115 119                 234
1132287 1132287 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2017   grade_10 295 20 17 0   23     1   22   198 180                       378 295 20 17 0   23     1   22   198 180                 378
1122176 1122176 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_7 302 16 22 0   48     0   21   201 208                       409 302 16 22 0   48     0   21   201 208                 409
1122250 1122250 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_9 317 22 72 2   15     0   21   242 207                       449 317 22 72 2   15     0   21   242 207                 449
1122423 1122423 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_8 226 10 12 1   55     0   21   159 166                       325 226 10 12 1   55     0   21   159 166                 325
1123360 1123360 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2017   grade_7 169 23 57 0   116     0   21   162 224                       386 169 23 57 0   116     0   21   162 224                 386
1125033 1125033 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2017   grade_10 313 46 132 1   34     0   21   298 249                       547 313 46 132 1   34     0   21   298 249                 547
1125100 1125100 MA Worcester   school 2505130 103   Gardner 250513000750 1030001 Elm Street School   Regular School No Elementary 02 04 2017   grade_4 136 4 39 0   3     0   21   108 95                       203 136 4 39 0   3     0   21   108 95                 203
1126060 1126060 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_6 150 9 8 0   117     0   21   148 157                       305 150 9 8 0   117     0   21   148 157                 305
1126300 1126300 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_9 238 100 235 1   243     1   21   429 410                       839 238 100 235 1   243     1   21   429 410                 839
1127374 1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293
1127534 1127534 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2017   grade_7 191 20 30 0   54     0   21   176 140                       316 191 20 30 0   54     0   21   176 140                 316
1128163 1128163 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_6 129 23 29 0   3     0   21   108 97                       205 129 23 29 0   3     0   21   108 97                 205
1130308 1130308 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No High 09 12 2017   grade_12 297 4 5 0   71     0   21   199 199                       398 297 4 5 0   71     0   21   199 199                 398
1131034 1131034 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No Middle 07 08 2017   grade_7 219 58 163 0   31     0   21   262 230                       492 219 58 163 0   31     0   21   262 230                 492
1131039 1131039 MA Worcester   school 2513230 348   Worcester 251323002253 3480420 Worcester East Middle   Regular School No Middle 06 08 2017   grade_8 72 79 171 0   29     0   21   196 176                       372 72 79 171 0   29     0   21   196 176                 372
1132286 1132286 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2017   grade_9 298 15 14 1   20     0   21   208 161                       369 298 15 14 1   20     0   21   208 161                 369
1133017 1133017 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 394 48 95 1   3     0   21   297 265                       562 394 48 95 1   3     0   21   297 265                 562
1133019 1133019 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2017   grade_11 340 47 117 2   3     0   21   272 258                       530 340 47 117 2   3     0   21   272 258                 530
1133022 1133022 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 246 21 196 1   89     0   21   305 269                       574 246 21 196 1   89     0   21   305 269                 574
1124357 1124357 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_7 301 4 8 0   1     0   20   167 167                       334 301 4 8 0   1     0   20   167 167                 334
1124360 1124360 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2017   grade_9 241 2 5 0   1     0   20   147 122                       269 241 2 5 0   1     0   20   147 122                 269
1124824 1124824 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_11 317 46 100 1   31     1   20   267 249                       516 317 46 100 1   31     1   20   267 249                 516
1126960 1126960 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_11 270 2 162 1   22     0   20   246 231                       477 270 2 162 1   22     0   20   246 231                 477
1127386 1127386 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_11 132 47 184 4   6     3   20   211 185                       396 132 47 184 4   6     3   20   211 185                 396
1127529 1127529 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Charles E Brown Middle   Regular School No Middle 06 08 2017   grade_6 158 6 11 0   46     0   20   118 123                       241 158 6 11 0   46     0   20   118 123                 241
1127535 1127535 MA Middlesex   school 2508610 207   Newton 250861000314 2070315 F A Day Middle   Regular School No Middle 06 08 2017   grade_8 200 21 22 1   30     0   20   148 146                       294 200 21 22 1   30     0   20   148 146                 294
1127543 1127543 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No High 09 12 2017   grade_11 370 29 51 0   87     2   20   292 267                       559 370 29 51 0   87     2   20   292 267                 559
1130124 1130124 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No Middle 06 08 2017   grade_7 266 17 18 0   29     0   20   169 181                       350 266 17 18 0   29     0   20   169 181                 350
1130128 1130128 MA Norfolk   school 2512270 317   Wellesley 251227002030 3170505 Wellesley Sr High   Regular School No High 09 12 2017   grade_10 279 20 17 0   47     0   20   173 210                       383 279 20 17 0   47     0   20   173 210                 383
1133040 1133040 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_12 288 1 51 0   2     0   20   201 161                       362 288 1 51 0   2     0   20   201 161                 362
1122252 1122252 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_11 305 23 49 2   19     2   19   216 203                       419 305 23 49 2   19     2   19   216 203                 419
1122421 1122421 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_6 233 15 11 0   62     1   19   171 170                       341 233 15 11 0   62     1   19   171 170                 341
1122422 1122422 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Winthrop L Chenery Middle   Regular School No Middle 05 08 2017   grade_7 243 13 17 0   51     0   19   169 174                       343 243 13 17 0   51     0   19   169 174                 343
1123598 1123598 MA Plymouth   school 2503090 44   Brockton 250309002792 440007 Barrett Russell School   Regular School No Elementary KG KG 2017   kindergarten 24 129 42 1   4     0   19   117 102                       219 24 129 42 1   4     0   19   117 102                 219
1123696 1123696 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_7 48 98 65 0   3     1   19   102 132                       234 48 98 65 0   3     1   19   102 132                 234
1124859 1124859 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_7 229 14 17 4   7     0   19   157 133                       290 229 14 17 4   7     0   19   157 133                 290
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1124910 1124910 MA Worcester   school 2504890 97   Fitchburg 250489000697 970505 Fitchburg High   Regular School No High 09 12 2017   grade_10 97 26 147 0   18     0   19   151 156                       307 97 26 147 0   18     0   19   151 156                 307

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