Data source: Big Local News · About: Big Local

70,226 rows where state = "MA" sorted by white_int descending

View and edit SQL

grade

year

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
1132906 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   grade_10 523 7 26 0   26     1   6   267 322                       589 523 7 26 0   26     1   6   267 322                 589
2239722 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   grade_11 521 7 25 0   22     0   6   263 318                       581.0 521 7 25 0   22     0   6   263 318                 581
941791 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   grade_9 516 5 24 0   27     0   5   263 314                       577 516 5 24 0   27     0   5   263 314                 577
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
2049092 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2019   grade_12 510 8 24 0   21     0   6   260 309                       569.0 510 8 24 0   21     0   6   260 309                 569
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
941794 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   grade_12 498 12 19 0   10     1   12   275 277                       552 498 12 19 0   10     1   12   275 277                 552
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
939727 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2016   grade_9 476 26 38 1   20     0   20   327 254                       581 476 26 38 1   20     0   20   327 254                 581
2236518 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_8 476 81 98 1   14     0   23   342 351                       693.0 476 81 98 1   14     0   23   342 351                 693
941793 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   grade_11 472 10 17 1   9     1   8   256 262                       518 472 10 17 1   9     1   8   256 262                 518
1132905 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   grade_9 469 12 23 0   10     0   14   255 273                       528 469 12 23 0   10     0   14   255 273                 528
2239721 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   grade_10 461 13 22 0   11     0   14   253 268                       521.0 461 13 22 0   11     0   14   253 268                 521
1132908 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   grade_12 459 10 18 1   11     1   7   255 252                       507 459 10 18 1   11     1   7   255 252                 507
939057 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2016   grade_8 458 74 79 0   6     2   20   331 308                       639 458 74 79 0   6     2   20   331 308                 639
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
2049090 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2019   grade_10 456 12 28 1   20     0   9   256 270                       526.0 456 12 28 1   20     0   9   256 270                 526
2049091 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2019   grade_11 453 11 24 0   12     0   13   254 258                       513.0 453 11 24 0   12     0   13   254 258                 513
2239720 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   grade_9 451 14 25 1   22     0   9   251 271                       522.0 451 14 25 1   22     0   9   251 271                 522
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
1374017 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2020   grade_11 448 11 30 1   24     0   9   255 268 *                     523.0 448 11 30 1   24     0   9   255 268                 523
941792 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No 3 09 12 2016   grade_10 447 11 19 0   22     2   8   221 288                       509 447 11 19 0   22     2   8   221 288                 509
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
1130511 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2017   grade_9 443 29 60 2   34     0   13   308 273                       581 443 29 60 2   34     0   13   308 273                 581
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
1374018 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2020   grade_12 442 10 23 0   12     0   13   251 248 *                     500.0 442 10 23 0   12     0   13   251 248                 500
1132907 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2017   grade_11 440 11 20 0   21     2   8   224 278                       502 440 11 20 0   21     2   8   224 278                 502
1374015 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2020   grade_9 440 13 22 0   20     0   14   252 257 *                     509.0 440 13 22 0   20     0   14   252 257                 509
1374016 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2020   grade_10 440 7 28 1   14     0   9   249 250 *                     499.0 440 7 28 1   14     0   9   249 250                 499
935201 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_10 436 7 9 1   16     0   5   241 233                       474 436 7 9 1   16     0   5   241 233                 474
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
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
2239723 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett: Wachusett Regional High   Regular School No High 09 12 2018   grade_12 434 12 18 0   20     2   7   222 271                       493.0 434 12 18 0   20     2   7   222 271                 493
1681264 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett - Wachusett Regional High   Regular School No High 09 12 2021   grade_10 434 14 22 0   20     0   14   253 251 *                     504.0 434 14 22 0   20     0   14   253 251                 504
1681263 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett - Wachusett Regional High   Regular School No High 09 12 2021   grade_9 431 8 29 1   15     0   10   203 291 *                     494.0 431 8 29 1   15     0   10   203 291                 494
1681266 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett - Wachusett Regional High   Regular School No High 09 12 2021   grade_12 431 11 27 1   22     0   9   239 262 *                     501.0 431 11 27 1   22     0   9   239 262                 501
1125095 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_11 430 8 10 1   17     0   4   245 225                       470 430 8 10 1   17     0   4   245 225                 470
2231925 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_12 430 6 9 1   17     0   4   243 224                       467.0 430 6 9 1   17     0   4   243 224                 467
2049089 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett Regional High   Regular School No High 09 12 2019   grade_9 430 6 24 1   11     0   8   235 245                       480.0 430 6 24 1   11     0   8   235 245                 480
1681265 MA Worcester   school 2511880 775   Wachusett 251188001940 7750505 Wachusett - Wachusett Regional High   Regular School No High 09 12 2021   grade_11 429 7 29 1   14     0   8   247 241 *                     488.0 429 7 29 1   14     0   8   247 241                 488
1371298 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2020   grade_8 427 122 83 4   8     1   45   356 334 *                     690.0 427 122 83 4   8     1   45   356 334                 690
1678551 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_8 426 113 92 4   5     2   33   337 338 *                     675.0 426 113 92 4   5     2   33   337 338                 675
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
939730 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2016   grade_12 408 15 25 0   16     0   13   252 225                       477 408 15 25 0   16     0   13   252 225                 477
2046374 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2019   grade_8 400 110 79 3   8     0   31   331 300                       631.0 400 110 79 3   8     0   31   331 300                 631
939728 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2016   grade_10 396 18 31 1   18     0   14   232 246                       478 396 18 31 1   18     0   14   232 246                 478
1369200 MA Norfolk   school 2508370 199   Needham 250837002690 1990410 High Rock School   Regular School No Middle 06 06 2020   grade_6 396 14 43 0   26     0   20   245 254 *                     499.0 396 14 43 0   26     0   20   245 254                 499
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
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
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
2237342 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth: Weymouth High School   Regular School No High 09 12 2018   grade_12 391 21 30 0   17     0   10   232 237                       469.0 391 21 30 0   17     0   10   232 237                 469
2239833 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Greater New Bedford Regional Vocational Technical: Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2018   grade_10 391 51 95 1   5     0   20   296 267                       563.0 391 51 95 1   5     0   20   296 267                 563
941261 MA Norfolk   school 2506510 690   King Philip 250651000941 6900510 King Philip Middle School   Regular School No 2 07 08 2016   grade_8 390 1 15 0   6     1   10   219 204                       423 390 1 15 0   6     1   10   219 204                 423
1130512 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2017   grade_10 390 17 29 1   17     0   14   254 214                       468 390 17 29 1   17     0   14   254 214                 468
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
939726 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_6 389 30 33 0   22     1   23   267 231                       498 389 30 33 0   22     1   23   267 231                 498
1125093 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_9 389 4 8 0   19     2   14   219 217                       436 389 4 8 0   19     2   14   219 217                 436
1369895 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_6 388 15 76 0   14     1   11   248 257 *                     505.0 388 15 76 0   14     1   11   248 257                 505
2231922 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_9 386 9 10 2   36     0   9   231 221                       452.0 386 9 10 2   36     0   9   231 221                 452
2049186 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 2019   grade_11 386 49 90 1   4     0   21   293 258                       551.0 386 49 90 1   4     0   21   293 258                 551
2231923 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_10 385 7 9 0   20     2   14   214 223                       437.0 385 7 9 0   20     2   14   214 223                 437
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
939729 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No 3 09 12 2016   grade_11 384 23 16 0   20     0   17   230 230                       460 384 23 16 0   20     0   17   230 230                 460
2042509 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_9 383 6 15 0   33     2   6   221 224                       445.0 383 6 15 0   33     2   6   221 224                 445
2042511 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_11 383 6 11 0   20     3   14   215 222                       437.0 383 6 11 0   20     3   14   215 222                 437
1674675 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_12 381 9 15 2   33     0   9   232 217 *                     449.0 381 9 15 2   33     0   9   232 217                 449
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
935200 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_9 380 7 5 2   26     2   8   209 221                       430 380 7 5 2   26     2   8   209 221                 430
1130513 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2017   grade_11 380 18 30 1   21     0   12   228 234                       462 380 18 30 1   21     0   12   228 234                 462
1367440 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_11 380 9 13 2   33     0   10   235 212 *                     447.0 380 9 13 2   33     0   10   235 212                 447
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
941887 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 2016   grade_12 379 57 76 1   6     0   2   247 274                       521 379 57 76 1   6     0   2   247 274                 521
1367441 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_12 379 5 9 0   19     3   14   216 213 *                     429.0 379 5 9 0   19     3   14   216 213                 429
1677139 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody - J Henry Higgins Middle   Regular School No Middle 06 08 2021   grade_7 379 17 77 1   13     1   12   246 254 *                     500.0 379 17 77 1   13     1   12   246 254                 500
939725 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Abigail Adams Middle School   Regular School No 2 05 06 2016   grade_5 378 25 36 2   17     1   15   245 229                       474 378 25 36 2   17     1   15   245 229                 474
2047032 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2019   grade_12 378 17 28 0   17     0   15   237 218                       455.0 378 17 28 0   17     0   15   237 218                 455
939689 MA Norfolk   school 2512840 336   Weymouth 251284001840 3360020 Maria Weston Chapman Middle School   Regular School No 2 05 08 2016   grade_8 377 23 40 2   28     0   9   240 239                       479 377 23 40 2   28     0   9   240 239                 479
2044968 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2019   grade_6 377 20 66 0   4     0   10   248 229                       477.0 377 20 66 0   4     0   10   248 229                 477
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
1674674 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_11 376 6 15 0   31     2   6   219 217 *                     436.0 376 6 15 0   31     2   6   219 217                 436
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
2047029 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth High School   Regular School No High 09 12 2019   grade_9 375 30 44 0   25     1   26   270 230                       501.0 375 30 44 0   25     1   26   270 230                 501
1367438 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_9 375 4 16 0   29     1   10   209 224 *                     435.0 375 4 16 0   29     1   10   209 224                 435
2237339 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth: Weymouth High School   Regular School No High 09 12 2018   grade_9 374 37 40 0   26     0   18   251 244                       495.0 374 37 40 0   26     0   18   251 244                 495
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
2042510 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_10 373 10 10 2   33     0   10   226 212                       438.0 373 10 10 2   33     0   10   226 212                 438
941884 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 2016   grade_9 372 44 118 3   6     0   20   268 295                       563 372 44 118 3   6     0   20   268 295                 563
1132289 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No High 09 12 2017   grade_12 372 14 16 0   25     0   13   184 256                       440 372 14 16 0   25     0   13   184 256                 440
941264 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury Regional High   Regular School No 3 09 12 2016   grade_11 371 13 15 0   25     0   13   180 257                       437 371 13 15 0   25     0   13   180 257                 437
1125094 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_10 371 7 8 1   27     2   8   205 219                       424 371 7 8 1   27     2   8   205 219                 424
1128041 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2017   grade_6 371 21 66 0   8     0   10   248 228                       476 371 21 66 0   8     0   10   248 228                 476
2044969 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2019   grade_7 371 18 67 0   8     0   7   240 231                       471.0 371 18 67 0   8     0   7   240 231                 471
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
937246 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton North High   Regular School No 3 09 12 2016   grade_10 370 24 43 0   81     2   20   280 260                       540 370 24 43 0   81     2   20   280 260                 540
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
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
1367439 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_10 370 5 16 0   33     2   6   214 218 *                     432.0 370 5 16 0   33     2   6   214 218                 432
1369897 MA Essex   school 2509360 229   Peabody 250936001495 2290305 J Henry Higgins Middle   Regular School No Middle 06 08 2020   grade_8 370 18 77 0   9     0   7   247 234 *                     481.0 370 18 77 0   9     0   7   247 234                 481

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