Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by total_int descending

View and edit SQL

grade

year

  • 2015 · 9,541
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 ▲
737164 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_9 206 707 159 6   31     2   35   624 522                       1146 206 707 159 6   31     2   35   624 522                 1146
737165 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_10 220 623 140 4   27     3   25   503 539                       1042 220 623 140 4   27     3   25   503 539                 1042
737166 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_11 231 627 106 3   26     0   23   530 486                       1016 231 627 106 3   26     0   23   530 486                 1016
737167 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No 3 09 12 2015   grade_12 219 572 101 4   25     0   17   445 493                       938 219 572 101 4   25     0   17   445 493                 938
739360 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_9 277 84 226 1   289     0   12   466 423                       889 277 84 226 1   289     0   12   466 423                 889
739361 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_10 265 80 190 1   246     0   10   390 402                       792 265 80 190 1   246     0   10   390 402                 792
740276 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_10 297 93 274 3   5     3   32   369 338                       707 297 93 274 3   5     3   32   369 338                 707
739362 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_11 214 78 156 1   231     0   7   340 347                       687 214 78 156 1   231     0   7   340 347                 687
739363 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No 3 09 12 2015   grade_12 203 83 154 1   199     0   5   321 324                       645 203 83 154 1   199     0   5   321 324                 645
742248 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_8 448 75 73 1   16     3   27   346 297                       643 448 75 73 1   16     3   27   346 297                 643
738123 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_9 376 59 148 1   36     2   19   344 297                       641 376 59 148 1   36     2   19   344 297                 641
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
737490 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No 1 PK KG 2015   kindergarten 66 36 498 0   6     0   11   327 290                       617 66 36 498 0   6     0   11   327 290                 617
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
743099 MA Worcester   school 2513230 348   Worcester 251323002684 3480002 Head Start   Regular School No 1 PK PK 2015   pre_kindergarten 173 122 284 0   25     0   2   283 323                       606 173 122 284 0   25     0   2   283 323                 606
738124 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_10 367 55 129 0   31     0   11   307 286                       593 367 55 129 0   31     0   11   307 286                 593
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
745064 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 373 48 125 0   4     0   18   295 273                       568 373 48 125 0   4     0   18   295 273                 568
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
744972 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   grade_11 510 12 18 0   10     1   12   275 288                       563 510 12 18 0   10     1   12   275 288                 563
745068 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 256 12 173 2   102     0   14   315 244                       559 256 12 173 2   102     0   14   315 244                 559
738008 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_10 179 115 233 3   21     0   7   312 246                       558 179 115 233 3   21     0   7   312 246                 558
738125 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_11 355 53 110 2   27     0   11   244 314                       558 355 53 110 2   27     0   11   244 314                 558
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
745065 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 366 55 107 2   3     0   23   247 309                       556 366 55 107 2   3     0   23   247 309                 556
739163 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_9 317 18 25 1   169     0   25   295 260                       555 317 18 25 1   169     0   25   295 260                 555
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
745066 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 394 60 80 1   6     0   2   259 284                       543 394 60 80 1   6     0   2   259 284                 543
740409 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_9 368 25 44 0   81     2   19   275 264                       539 368 25 44 0   81     2   19   275 264                 539
745069 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_10 250 17 156 4   89     0   20   268 268                       536 250 17 156 4   89     0   20   268 268                 536
739165 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_11 301 27 19 0   161     0   23   270 261                       531 301 27 19 0   161     0   23   270 261                 531
741995 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_10 78 139 263 0   32     0   18   278 252                       530 78 139 263 0   32     0   18   278 252                 530
738632 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2015   grade_10 329 18 171 0   10     0   1   306 223                       529 329 18 171 0   10     0   1   306 223                 529
741562 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2015   grade_7 360 12 31 2   113     0   11   285 244                       529 360 12 31 2   113     0   11   285 244                 529
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
738297 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_10 341 41 103 0   35     0   5   275 250                       525 341 41 103 0   35     0   5   275 250                 525
744971 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   grade_10 476 8 19 1   12     1   8   264 261                       525 476 8 19 1   12     1   8   264 261                 525
739164 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_10 280 23 18 1   177     0   19   251 267                       518 280 23 18 1   177     0   19   251 267                 518
740411 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_11 367 32 45 0   51     0   23   258 260                       518 367 32 45 0   51     0   23   258 260                 518
745071 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_12 268 24 132 3   82     0   7   232 284                       516 268 24 132 3   82     0   7   232 284                 516
742923 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   grade_11 435 18 27 0   16     0   16   272 240                       512 435 18 27 0   16     0   16   272 240                 512
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
744973 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   grade_12 456 12 20 1   13     1   5   248 260                       508 456 12 20 1   13     1   5   248 260                 508
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
738010 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_12 200 124 151 1   25     0   4   256 249                       505 200 124 151 1   25     0   4   256 249                 505
744970 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2015   grade_9 443 10 18 0   23     2   9   216 289                       505 443 10 18 0   23     2   9   216 289                 505
739606 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_9 133 97 138 2   117     0   15   274 228                       502 133 97 138 2   117     0   15   274 228                 502
737401 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_9 185 172 64 4   56     0   18   270 229                       499 185 172 64 4   56     0   18   270 229                 499
738296 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_9 338 30 87 1   34     0   9   241 258                       499 338 30 87 1   34     0   9   241 258                 499
740410 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_10 333 21 50 0   64     0   30   227 271                       498 333 21 50 0   64     0   30   227 271                 498
738298 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_11 340 36 84 1   35     0   1   241 256                       497 340 36 84 1   35     0   1   241 256                 497
745070 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Gr Lowell Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_11 268 17 118 2   79     0   13   264 233                       497 268 17 118 2   79     0   13   264 233                 497
742919 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_5 389 36 30 0   18     1   22   262 234                       496 389 36 30 0   18     1   22   262 234                 496
737264 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_9 288 37 50 0   70     0   49   259 235                       494 288 37 50 0   70     0   49   259 235                 494
742883 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 07 08 2015   grade_8 411 22 25 1   15     0   18   270 222                       492 411 22 25 1   15     0   18   270 222                 492
739166 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington High   Regular School No 3 09 12 2015   grade_12 282 27 24 1   142     0   13   254 235                       489 282 27 24 1   142     0   13   254 235                 489
743365 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Forest Grove Middle   Regular School No 2 07 08 2015   grade_7 241 52 143 0   24     0   28   267 221                       488 241 52 143 0   24     0   28   267 221                 488
741570 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_5 293 6 38 2   131     0   17   250 237                       487 293 6 38 2   131     0   17   250 237                 487
743969 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_11 338 8 14 1   114     0   11   251 235                       486 338 8 14 1   114     0   11   251 235                 486
740277 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_11 226 61 151 6   2     6   31   271 212                       483 226 61 151 6   2     6   31   271 212                 483
742249 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_9 352 66 41 0   7     0   17   256 227                       483 352 66 41 0   7     0   17   256 227                 483
743970 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_12 344 2 16 1   112     0   6   235 246                       481 344 2 16 1   112     0   6   235 246                 481
738346 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_9 442 7 9 1   15     0   6   247 233                       480 442 7 9 1   15     0   6   247 233                 480
743966 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000013 6000405 Raymond J Grey Junior High   Regular School No 2 07 08 2015   grade_8 284 4 16 0   157     0   18   260 219                       479 284 4 16 0   157     0   18   260 219                 479
743968 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_10 325 4 20 1   118     0   11   243 236                       479 325 4 20 1   118     0   11   243 236                 479
737265 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_10 280 41 46 0   78     0   33   222 256                       478 280 41 46 0   78     0   33   222 256                 478
739910 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_9 282 16 154 1   22     0   3   255 223                       478 282 16 154 1   22     0   3   255 223                 478
741563 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Oak Middle School   Regular School No 2 07 08 2015   grade_8 337 4 31 0   93     1   12   247 231                       478 337 4 31 0   93     1   12   247 231                 478
735802 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_10 369 11 25 0   61     0   11   248 229                       477 369 11 25 0   61     0   11   248 229                 477
738299 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_12 325 28 84 0   35     0   2   254 220                       474 325 28 84 0   35     0   2   254 220                 474
739609 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_12 148 95 97 2   114     2   16   246 228                       474 148 95 97 2   114     2   16   246 228                 474
742882 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 07 08 2015   grade_7 375 19 39 2   30     0   9   241 233                       474 375 19 39 2   30     0   9   241 233                 474
745067 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_12 335 36 83 0   3     0   17   227 247                       474 335 36 83 0   3     0   17   227 247                 474
737267 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No 3 09 12 2015   grade_12 281 28 45 0   78     0   41   232 241                       473 281 28 45 0   78     0   41   232 241                 473
742922 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   grade_10 392 21 24 0   20     1   15   234 239                       473 392 21 24 0   20     1   15   234 239                 473
737402 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No 3 09 12 2015   grade_10 193 139 64 2   56     2   15   250 221                       471 193 139 64 2   56     2   15   250 221                 471
741997 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield Central High   Regular School No 3 09 12 2015   grade_12 90 102 211 0   48     0   20   239 232                       471 90 102 211 0   48     0   20   239 232                 471
742920 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2015   grade_6 369 31 31 2   20     0   17   237 233                       470 369 31 31 2   20     0   17   237 233                 470
741571 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Sherwood Middle School   Regular School No 2 05 06 2015   grade_6 288 11 30 2   122     0   16   237 232                       469 288 11 30 2   122     0   16   237 232                 469
742250 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_10 330 49 61 3   11     1   14   219 250                       469 330 49 61 3   11     1   14   219 250                 469
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
740416 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_11 303 22 32 1   81     0   21   242 218                       460 303 22 32 1   81     0   21   242 218                 460
739912 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_11 291 17 123 4   20     0   4   261 198                       459 291 17 123 4   20     0   4   261 198                 459
738126 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_12 308 44 69 2   25     0   9   215 242                       457 308 44 69 2   25     0   9   215 242                 457
740132 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No 2 07 08 2015   grade_8 367 21 20 0   35     0   14   234 223                       457 367 21 20 0   35     0   14   234 223                 457
740412 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2015   grade_12 324 28 31 1   47     0   26   233 224                       457 324 28 31 1   47     0   26   233 224                 457
743967 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No 3 09 12 2015   grade_9 294 7 13 2   115     0   26   229 228                       457 294 7 13 2   115     0   26   229 228                 457
740415 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_10 281 26 33 0   91     0   23   227 227                       454 281 26 33 0   91     0   23   227 227                 454
740846 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_12 360 9 63 1   10     0   10   235 218                       453 360 9 63 1   10     0   10   235 218                 453
735910 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_11 324 26 56 3   23     1   19   241 211                       452 324 26 56 3   23     1   19   241 211                 452
739608 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No 3 09 12 2015   grade_11 128 110 83 2   115     2   12   223 229                       452 128 110 83 2   115     2   12   223 229                 452
738009 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No 3 09 12 2015   grade_11 163 99 149 2   30     0   6   236 213                       449 163 99 149 2   30     0   6   236 213                 449
744437 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2015   grade_10 379 15 15 0   26     0   14   189 260                       449 379 15 15 0   26     0   14   189 260                 449
736876 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No 3 07 12 2015   grade_9 185 59 78 0   111     0   15   193 255                       448 185 59 78 0   111     0   15   193 255                 448
738633 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2015   grade_11 311 10 113 1   9     0   4   243 205                       448 311 10 113 1   9     0   4   243 205                 448
740133 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No 2 06 06 2015   grade_6 370 7 18 0   34     0   18   225 222                       447 370 7 18 0   34     0   18   225 222                 447
742251 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_11 320 48 52 3   4     2   18   213 234                       447 320 48 52 3   4     2   18   213 234                 447
742924 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2015   grade_12 380 19 27 5   11     0   4   204 242                       446 380 19 27 5   11     0   4   204 242                 446
740414 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_9 299 16 24 0   87     0   18   212 232                       444 299 16 24 0   87     0   18   212 232                 444
740417 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton South High   Regular School No 3 09 12 2015   grade_12 290 18 26 0   93     3   14   209 235                       444 290 18 26 0   93     3   14   209 235                 444

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