Data source: Big Local News · About: Big Local

9,541 rows where state = "MA" and year = 2015 sorted by white_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
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
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
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
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
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
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
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
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
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
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
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
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
744434 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2015   grade_7 384 2 16 0   7     0   11   218 202                       420 384 2 16 0   7     0   11   218 202                 420
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
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
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
740566 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_8 375 9 13 2   19     0   10   214 214                       428 375 9 13 2   19     0   10   214 214                 428
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
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
738348 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_11 370 8 7 2   22     0   7   182 234                       416 370 8 7 2   22     0   7   182 234                 416
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
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
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
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
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
738349 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_12 367 1 7 1   13     1   7   196 201                       397 367 1 7 1   13     1   7   196 201                 397
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
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
738661 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2015   grade_6 366 5 3 0   9     0   5   188 200                       388 366 5 3 0   9     0   5   188 200                 388
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
737488 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_11 363 3 8 0   45     1   3   202 221                       423 363 3 8 0   45     1   3   202 221                 423
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
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
737489 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_12 359 7 12 1   32     0   2   198 215                       413 359 7 12 1   32     0   2   198 215                 413
738347 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_10 359 7 12 1   16     0   9   181 223                       404 359 7 12 1   16     0   9   181 223                 404
740840 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2015   grade_6 357 4 52 0   5     0   8   230 196                       426 357 4 52 0   5     0   8   230 196                 426
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
744435 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2015   grade_8 353 7 5 0   4     1   3   209 164                       373 353 7 5 0   4     1   3   209 164                 373
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
740842 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2015   grade_8 349 10 49 0   10     0   15   223 210                       433 349 10 49 0   10     0   15   223 210                 433
744431 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip Regional High   Regular School No 3 09 12 2015   grade_11 349 2 2 2   6     0   4   177 188                       365 349 2 2 2   6     0   4   177 188                 365
740136 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_11 348 11 16 0   29     0   10   200 214                       414 348 11 16 0   29     0   10   200 214                 414
744470 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2015   grade_11 348 3 5 0   4     2   1   192 171                       363 348 3 5 0   4     2   1   192 171                 363
739717 MA Plymouth   school 2507350 171   Marshfield 250735001142 1710505 Marshfield High   Regular School No 3 09 12 2015   grade_9 346 3 9 1   2     0   3   184 180                       364 346 3 9 1   2     0   3   184 180                 364
740845 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_11 345 12 64 2   4     0   5   211 221                       432 345 12 64 2   4     0   5   211 221                 432
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
744130 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2015   grade_10 344 19 6 0   7     0   15   200 191                       391 344 19 6 0   7     0   15   200 191                 391
740135 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_10 343 16 19 0   27     0   11   185 231                       416 343 16 19 0   27     0   11   185 231                 416
740523 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_8 342 10 32 0   23     3   6   214 202                       416 342 10 32 0   23     3   6   214 202                 416
740565 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No 2 06 08 2015   grade_7 342 7 11 1   24     1   10   193 203                       396 342 7 11 1   24     1   10   193 203                 396
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
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
735909 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_10 338 20 39 2   15     0   10   242 182                       424 338 20 39 2   15     0   10   242 182                 424
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
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
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
744132 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2015   grade_12 337 12 13 0   4     0   7   197 176                       373 337 12 13 0   4     0   7   197 176                 373
737039 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No 3 09 12 2015   grade_9 336 17 11 1   47     1   2   200 215                       415 336 17 11 1   47     1   2   200 215                 415
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
740096 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_9 334 13 13 0   21     1   14   199 197                       396 334 13 13 0   21     1   14   199 197                 396
740844 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_10 334 24 55 0   7     0   4   204 220                       424 334 24 55 0   7     0   4   204 220                 424
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
740521 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No 2 06 08 2015   grade_6 332 7 32 1   31     0   6   220 189                       409 332 7 32 1   31     0   6   220 189                 409
745108 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2015   grade_11 332 0 6 0   3     0   3   201 143                       344 332 0 6 0   3     0   3   201 143                 344
735803 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_11 331 5 18 2   63     0   13   208 224                       432 331 5 18 2   63     0   13   208 224                 432
739715 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2015   grade_7 331 3 6 2   4     0   2   177 171                       348 331 3 6 2   4     0   2   177 171                 348
739716 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2015   grade_8 331 1 6 1   3     1   3   170 176                       346 331 1 6 1   3     1   3   170 176                 346
740134 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_9 331 14 21 0   25     1   5   205 192                       397 331 14 21 0   25     1   5   205 192                 397
741208 MA Middlesex   school 2509990 246   Reading 250999001611 2460505 Reading Memorial High   Regular School No 3 09 12 2015   grade_10 330 7 1 1   13     0   5   173 184                       357 330 7 1 1   13     0   5   173 184                 357
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
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
740137 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham High   Regular School No 3 09 12 2015   grade_12 327 8 14 0   22     0   14   200 185                       385 327 8 14 0   22     0   14   200 185                 385
735804 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_12 326 5 20 1   53     0   10   199 216                       415 326 5 20 1   53     0   10   199 216                 415
740841 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No 2 06 08 2015   grade_7 326 11 55 0   7     0   10   210 199                       409 326 11 55 0   7     0   10   210 199                 409
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
739617 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_6 325 15 8 0   19     0   12   193 186                       379 325 15 8 0   19     0   12   193 186                 379
741022 MA Plymouth   school 2509720 239   Plymouth 250972000320 2390505 Plymouth North High   Regular School No 3 09 12 2015   grade_11 325 13 15 2   10     0   9   172 202                       374 325 13 15 2   10     0   9   172 202                 374
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
744131 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2015   grade_11 325 19 4 1   8     0   12   197 172                       369 325 19 4 1   8     0   12   197 172                 369
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
740131 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Pollard Middle   Regular School No 2 07 08 2015   grade_7 324 13 19 0   33     0   14   201 202                       403 324 13 19 0   33     0   14   201 202                 403
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
744439 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2015   grade_12 324 19 11 0   21     0   9   199 185                       384 324 19 11 0   21     0   9   199 185                 384
745106 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2015   grade_9 323 5 13 0   1     0   7   201 148                       349 323 5 13 0   1     0   7   201 148                 349
735801 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_9 321 7 23 0   61     0   8   199 221                       420 321 7 23 0   61     0   8   199 221                 420
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
742603 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley Middle   Regular School No 2 06 08 2015   grade_6 320 14 21 0   43     0   25   227 196                       423 320 14 21 0   43     0   25   227 196                 423
742756 MA Middlesex   school 2512660 326   Westford 251266002081 3260505 Westford Academy   Regular School No 3 09 12 2015   grade_12 320 1 12 0   69     0   17   206 213                       419 320 1 12 0   69     0   17   206 213                 419
745109 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Vocational Technical High School   Vocational Education School No 3 09 12 2015   grade_12 320 0 10 0   0     0   7   204 133                       337 320 0 10 0   0     0   7   204 133                 337
739619 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2015   grade_8 319 9 11 0   11     0   9   178 181                       359 319 9 11 0   11     0   9   178 181                 359
739621 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_10 319 6 6 4   13     0   4   178 174                       352 319 6 6 4   13     0   4   178 174                 352
744438 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2015   grade_11 319 22 10 0   21     0   11   191 192                       383 319 22 10 0   21     0   11   191 192                 383
744469 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2015   grade_10 319 1 5 0   5     0   0   162 168                       330 319 1 5 0   5     0   0   162 168                 330
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
744622 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_11 317 5 13 0   30     3   7   180 195                       375 317 5 13 0   30     3   7   180 195                 375
744623 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No 3 09 12 2015   grade_12 317 2 8 0   22     3   2   164 190                       354 317 2 8 0   22     3   2   164 190                 354
735972 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_8 316 22 13 4   21     2   20   197 201                       398 316 22 13 4   21     2   20   197 201                 398
737486 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No 3 09 12 2015   grade_9 316 5 7 0   44     0   7   178 201                       379 316 5 7 0   44     0   7   178 201                 379
740098 MA Middlesex   school 2508340 198   Natick 250834001303 1980505 Natick High   Regular School No 3 09 12 2015   grade_11 316 8 12 0   26     0   18   188 192                       380 316 8 12 0   26     0   18   188 192                 380
740527 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_12 316 14 18 2   22     0   2   192 182                       374 316 14 18 2   22     0   2   192 182                 374

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