Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by hispanic_int 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
1125863 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_9 39 16 921 1   12     0   1   561 429                       990 39 16 921 1   12     0   1   561 429                 990
2043130 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2019   grade_9 32 14 912 0   9     0   2   543 420                       969.0 32 14 912 0   9     0   2   543 420                 969
1368046 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2020   grade_9 20 5 879 0   12     0   3   483 429 7                     919.0 20 5 879 0   12     0   3   483 429 7               919
2232680 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence: Lawrence High School   Regular School No High 09 12 2018   grade_9 30 6 854 0   20     0   1   500 411                       911.0 30 6 854 0   20     0   1   500 411                 911
1675291 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_9 19 13 735 1   14     0   3   425 358 2                     785.0 19 13 735 1   14     0   3   425 358 2               785
935823 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No 4 09 09 2016   grade_9 25 12 700 1   12     0   3   391 362                       753 25 12 700 1   12     0   3   391 362                 753
737520 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2015   grade_9 28 39 510 0   12     0   3   324 268                       592 28 39 510 0   12     0   3   324 268                 592
1678306 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_9 46 123 454 1   25     0   10   354 305 *                     659.0 46 123 454 1   25     0   10   354 305                 659
1371044 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2020   grade_9 51 119 434 1   23     0   13   349 292 *                     641.0 51 119 434 1   23     0   13   349 292                 641
934380 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No 3 09 12 2016   grade_9 27 28 429 0   6     0   2   282 210                       492 27 28 429 0   6     0   2   282 210                 492
1366602 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2020   grade_9 22 14 428 1   1     0   6   267 205 *                     472.0 22 14 428 1   1     0   6   267 205                 472
2046119 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2019   grade_9 63 140 427 1   21     0   6   388 270                       658.0 63 140 427 1   21     0   6   388 270                 658
741999 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2015   grade_9 55 140 422 0   3     0   17   352 285                       637 55 140 422 0   3     0   17   352 285                 637
2236218 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_9 76 162 408 0   34     0   7   394 293                       687.0 76 162 408 0   34     0   7   394 293                 687
1129400 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No High 09 12 2017   grade_9 88 151 403 1   31     1   8   365 318                       683 88 151 403 1   31     1   8   365 318                 683
1368596 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2020   grade_9 41 51 380 2   43     0   15   287 244 *                     532.0 41 51 380 2   43     0   15   287 244                 532
1673833 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea - Chelsea High   Regular School No High 09 12 2021   grade_9 29 18 380 1   0     0   4   222 210 *                     432.0 29 18 380 1   0     0   4   222 210                 432
2232436 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke: Holyoke High   Regular School No High 09 12 2018   grade_9 74 6 378 1   4     0   2   254 211                       465.0 74 6 378 1   4     0   2   254 211                 465
1124114 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2017   grade_9 24 28 377 0   7     1   2   245 194                       439 24 28 377 0   7     1   2   245 194                 439
933688 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2016   grade_9 56 28 369 2   4     0   6   272 193                       465 56 28 369 2   4     0   6   272 193                 465
1374104 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 59 5 363 1   4     0   0   222 210 *                     432.0 59 5 363 1   4     0   0   222 210                 432
2235358 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere: Revere High   Regular School No High 09 12 2018   grade_9 184 19 363 8   30     0   10   320 294                       614.0 184 19 363 8   30     0   10   320 294                 614
736822 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No 3 09 12 2015   grade_9 53 43 357 2   8     0   1   286 178                       464 53 43 357 2   8     0   1   286 178                 464
2049180 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 60 5 357 0   6     0   0   218 210                       428.0 60 5 357 0   6     0   0   218 210                 428
2043664 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2019   grade_9 58 57 352 5   43     0   13   288 240                       528.0 58 57 352 5   43     0   13   288 240                 528
1675837 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_9 51 45 351 0   38     0   18   265 238 *                     503.0 51 45 351 0   38     0   18   265 238                 503
2233318 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn: Lynn English High   Regular School No High 09 12 2018   grade_9 73 44 345 1   41     0   13   317 200                       517.0 73 44 345 1   41     0   13   317 200                 517
1133012 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 65 1 344 1   4     0   0   186 229                       415 65 1 344 1   4     0   0   186 229                 415
2230929 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea: Chelsea High   Regular School No High 09 12 2018   grade_9 17 29 343 0   8     0   1   236 162                       398.0 17 29 343 0   8     0   1   236 162                 398
2239827 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical: Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2018   grade_9 66 3 341 1   8     0   0   217 202                       419.0 66 3 341 1   8     0   0   217 202                 419
1125619 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2017   grade_9 72 9 340 0   6     0   6   223 210                       433 72 9 340 0   6     0   6   223 210                 433
1675654 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_9 202 80 340 0   221     0   37   479 401 *                     880.0 202 80 340 0   221     0   37   479 401                 880
1677563 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_9 147 24 337 3   23     0   8   281 261 *                     542.0 147 24 337 3   23     0   8   281 261                 542
2041671 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_9 13 14 337 1   6     0   0   221 150                       371.0 13 14 337 1   6     0   0   221 150                 371
1369337 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2020   grade_9 269 89 331 3   4     0   37   377 355 *                     733.0 269 89 331 3   4     0   37   377 355                 733
1674319 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_9 103 79 329 4   31     1   9   272 284 *                     556.0 103 79 329 4   31     1   9   272 284                 556
938816 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2016   grade_9 58 65 328 0   9     0   7   281 186                       467 58 65 328 0   9     0   7   281 186                 467
1370315 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2020   grade_9 167 22 328 1   27     1   7   279 273 *                     553.0 167 22 328 1   27     1   7   279 273                 553
1681352 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Greater Lawrence Regional Vocational Technical - Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 79 8 328 1   3     1   0   180 240 *                     420.0 79 8 328 1   3     1   0   180 240                 420
938807 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2016   grade_9 99 148 327 0   44     1   9   347 281                       628 99 148 327 0   44     1   9   347 281                 628
941880 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2016   grade_9 67 6 322 0   2     0   0   201 196                       397 67 6 322 0   2     0   0   201 196                 397
1368592 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2020   grade_9 64 35 319 2   47     0   14   251 230 *                     481.0 64 35 319 2   47     0   14   251 230                 481
2042941 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2019   grade_9 48 12 319 2   1     1   4   202 185                       387.0 48 12 319 2   1     1   4   202 185                 387
1676586 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_9 296 101 315 2   7     1   34   407 349 *                     756.0 296 101 315 2   7     1   34   407 349                 756
2045388 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2019   grade_9 164 19 315 2   28     0   13   291 250                       541.0 164 19 315 2   28     0   13   291 250                 541
742004 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No 3 09 12 2015   grade_9 48 58 314 1   7     0   11   256 183                       439 48 58 314 1   7     0   11   256 183                 439
739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
1123300 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2017   grade_9 33 18 307 1   3     0   3   231 134                       365 33 18 307 1   3     0   3   231 134                 365
938811 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No 3 09 12 2016   grade_9 43 94 303 0   4     0   8   239 213                       452 43 94 303 0   4     0   8   239 213                 452
936369 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2016   grade_9 72 52 299 1   30     0   18   283 189                       472 72 52 299 1   30     0   18   283 189                 472
1371052 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2020   grade_9 25 72 298 0   7     1   7   223 187 *                     410.0 25 72 298 0   7     1   7   223 187                 410
1129410 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2017   grade_9 45 63 297 0   9     1   4   273 146                       419 45 63 297 0   9     1   4   273 146                 419
1367861 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No High 09 12 2020   grade_9 58 11 297 0   0     0   4   195 175 *                     370.0 58 11 297 0   0     0   4   195 175                 370
741259 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2015   grade_9 164 24 295 1   31     0   12   278 249                       527 164 24 295 1   31     0   12   278 249                 527
745060 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 55 4 295 0   4     0   0   184 174                       358 55 4 295 0   4     0   0   184 174                 358
1675106 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke - Holyoke High   Regular School No High 09 12 2021   grade_9 52 11 294 0   1     0   3   181 180 *                     361.0 52 11 294 0   1     0   3   181 180                 361
739517 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_9 92 55 293 1   55     0   12   266 242                       508 92 55 293 1   55     0   12   266 242                 508
741994 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_9 78 135 293 0   27     0   32   293 272                       565 78 135 293 0   27     0   32   293 272                 565
1678314 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield - Springfield High School of Science and Technology   Regular School No High 09 12 2021   grade_9 25 67 293 0   4     1   2   231 161 *                     392.0 25 67 293 0   4     1   2   231 161                 392
1678310 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield - High School Of Commerce   Regular School No High 09 12 2021   grade_9 26 50 283 0   3     0   6   198 170 *                     368.0 26 50 283 0   3     0   6   198 170                 368
1367088 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2020   grade_9 90 86 281 4   24     0   8   251 242 *                     493.0 90 86 281 4   24     0   8   251 242                 493
1371048 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2020   grade_9 32 78 281 2   7     1   4   211 194 *                     405.0 32 78 281 2   7     1   4   211 194                 405
2236228 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield: Springfield High School of Science and Technology   Regular School No High 09 12 2018   grade_9 27 69 281 0   6     0   1   229 155                       384.0 27 69 281 0   6     0   1   229 155                 384
738773 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2015   grade_9 96 14 280 0   6     0   9   224 181                       405 96 14 280 0   6     0   9   224 181                 405
2046128 MA Hampden   school 2511130 281   Springfield 251113000901 2810530 Springfield High School of Science and Technology   Regular School No High 09 12 2019   grade_9 36 51 278 1   7     0   3   233 143                       376.0 36 51 278 1   7     0   3   233 143                 376
2230105 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston: East Boston High   Regular School No High 09 12 2018   grade_9 34 17 277 0   6     0   6   222 118                       340.0 34 17 277 0   6     0   6   222 118                 340
1129405 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2017   grade_9 27 63 276 0   3     0   4   208 165                       373 27 63 276 0   3     0   4   208 165                 373
1126498 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2017   grade_9 74 34 275 0   44     0   13   227 213                       440 74 34 275 0   44     0   13   227 213                 440
1128537 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No High 09 12 2017   grade_9 178 14 275 2   32     0   15   263 253                       516 178 14 275 2   32     0   15   263 253                 516
2233313 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn: Classical High   Regular School No High 09 12 2018   grade_9 68 30 274 2   30     0   7   240 171                       411.0 68 30 274 2   30     0   7   240 171                 411
2042160 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2019   grade_9 102 94 273 4   23     0   7   258 245                       503.0 102 94 273 4   23     0   7   258 245                 503
935621 MA Hampden   school 2506270 137   Holyoke 250627000900 1370505 Holyoke High   Regular School No 3 09 12 2016   grade_9 73 15 272 0   1     0   5   194 172                       366 73 15 272 0   1     0   5   194 172                 366
1368410 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2020   grade_9 150 79 272 0   210     0   29   388 352 *                     740.0 150 79 272 0   210     0   29   388 352                 740
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
938087 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere High   Regular School No 3 09 12 2016   grade_9 163 31 265 3   33     0   12   251 256                       507 163 31 265 3   33     0   12   251 256                 507
1371076 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2020   grade_9 26 59 264 0   9     0   2   167 193 *                     360.0 26 59 264 0   9     0   2   167 193                 360
2046152 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2019   grade_9 32 72 263 0   5     0   3   166 209                       375.0 32 72 263 0   5     0   3   166 209                 375
937113 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2016   grade_9 209 68 261 9   4     1   25   339 238                       577 209 68 261 9   4     1   25   339 238                 577
1678334 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield - Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2021   grade_9 30 56 261 1   12     0   2   162 200 *                     362.0 30 56 261 1   12     0   2   162 200                 362
2043660 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2019   grade_9 108 32 261 4   48     0   19   234 238                       472.0 108 32 261 4   48     0   19   234 238                 472
2046123 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 High School Of Commerce   Regular School No High 09 12 2019   grade_9 28 63 260 0   6     1   5   183 180                       363.0 28 63 260 0   6     1   5   183 180                 363
2236255 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Springfield: Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2018   grade_9 29 71 260 1   3     0   3   180 187                       367.0 29 71 260 1   3     0   3   180 187                 367
2236223 MA Hampden   school 2511130 281   Springfield 251113001806 2810510 Springfield: High School Of Commerce   Regular School No High 09 12 2018   grade_9 35 53 257 0   6     0   5   177 179                       356.0 35 53 257 0   6     0   5   177 179                 356
938841 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Vocational Education School No 3 09 12 2016   grade_9 38 57 255 0   7     1   1   162 197                       359 38 57 255 0   7     1   1   162 197                 359
1129439 MA Hampden   school 2511130 281   Springfield 251113002293 2810620 Roger L. Putnam Vocational Technical Academy   Career and Technical School No High 09 12 2017   grade_9 48 67 252 0   6     0   1   163 211                       374 48 67 252 0   6     0   1   163 211                 374
740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
2044410 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2019   grade_9 232 111 247 5   9     1   34   339 300                       639.0 232 111 247 5   9     1   34   339 300                 639
1674622 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_9 326 39 245 0   24     1   26   356 305 *                     661.0 326 39 245 0   24     1   26   356 305                 661
2233118 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_9 214 80 242 1   256     0   29   409 413                       822.0 214 80 242 1   256     0   29   409 413                 822
1675833 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_9 44 25 240 0   23     0   16   213 135 *                     348.0 44 25 240 0   23     0   16   213 135                 348
738007 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_9 178 102 238 2   20     0   8   301 247                       548 178 102 238 2   20     0   8   301 247                 548
936365 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2016   grade_9 117 50 238 2   44     1   14   256 210                       466 117 50 238 2   44     1   14   256 210                 466
1367388 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2020   grade_9 356 36 236 1   27     1   27   353 331 *                     684.0 356 36 236 1   27     1   27   353 331                 684
934859 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2016   grade_9 164 90 235 3   24     1   8   281 244                       525 164 90 235 3   24     1   8   281 244                 525
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
2043493 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2019   grade_9 221 104 233 0   236     0   30   411 413                       824.0 221 104 233 0   236     0   30   411 413                 824
1366241 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2020   grade_9 169 865 231 3   29     3   52   766 586 *                     1352.0 169 865 231 3   29     3   52   766 586                 1352
2049188 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 2019   grade_9 210 31 230 2   96     0   29   300 295                       598.0 210 31 230 2   96     0   29   300 295                 598
1374112 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 2020   grade_9 240 30 229 0   108     0   0   329 275 3                     607.0 240 30 229 0   108     0   0   329 275 3               607
2040969 MA Suffolk   school 2502790 35   Boston 250279000226 350530 East Boston High   Regular School No High 09 12 2019   grade_9 29 19 229 0   8     0   7   167 125                       292.0 29 19 229 0   8     0   7   167 125                 292

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