Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by female_int descending

View and edit SQL

year

  • 2021 · 9,536
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
1673475 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_10 132 759 198 3   27     2   50   651 520 *                     1171.0 132 759 198 3   27     2   50   651 520                 1171
1673474 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_9 187 617 165 1   24     2   48   589 455 *                     1044.0 187 617 165 1   24     2   48   589 455                 1044
1673476 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_11 131 580 128 3   22     2   39   450 455 *                     905.0 131 580 128 3   22     2   39   450 455                 905
1673477 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton - Brockton High   Regular School No High 09 12 2021   grade_12 166 561 110 4   19     4   31   471 424 *                     895.0 166 561 110 4   19     4   31   471 424                 895
1675292 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_10 17 4 854 0   13     0   2   466 421 3                     890.0 17 4 854 0   13     0   2   466 421 3               890
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
1675657 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_12 212 89 176 0   248     0   26   360 391 *                     751.0 212 89 176 0   248     0   26   360 391                 751
1675656 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_11 206 99 179 0   227     0   25   362 374 *                     736.0 206 99 179 0   227     0   25   362 374                 736
1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
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
1675293 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_11 22 13 703 0   6     0   1   389 354 2                     745.0 22 13 703 0   6     0   1   389 354 2               745
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
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
1675294 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence - Lawrence High School   Regular School No High 09 12 2021   grade_12 18 5 639 1   20     0   1   347 336 1                     684.0 18 5 639 1   20     0   1   347 336 1               684
1674623 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_10 335 37 226 1   28     1   26   329 325 *                     654.0 335 37 226 1   28     1   26   329 325                 654
1681360 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 197 39 221 1   115     0   23   268 324 4                     596.0 197 39 221 1   115     0   23   268 324 4               596
1676588 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_11 216 109 298 3   7     2   36   359 311 *                     671.0 216 109 298 3   7     2   36   359 311                 671
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
1675655 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_10 123 69 231 0   212     0   25   355 305 *                     660.0 123 69 231 0   212     0   25   355 305                 660
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
1674438 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_10 297 57 169 1   26     0   33   288 294 *                     583.0 297 57 169 1   26     0   33   288 294                 583
1675454 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_10 257 15 25 0   267     0   35   305 293 *                     599.0 257 15 25 0   267     0   35   305 293                 599
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
1675455 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_11 269 32 25 0   226     0   30   293 289 *                     582.0 269 32 25 0   226     0   30   293 289                 582
1674624 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_11 282 43 175 1   33     1   19   266 288 *                     554.0 282 43 175 1   33     1   19   266 288                 554
1675453 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_9 224 25 27 0   231     0   43   261 288 *                     550.0 224 25 27 0   231     0   43   261 288                 550
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
1681362 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_11 198 29 214 2   89     0   28   276 281 3                     560.0 198 29 214 2   89     0   28   276 281 3               560
1678552 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_9 314 122 79 5   5     2   38   293 272 *                     565.0 314 122 79 5   5     2   38   293 272                 565
1674440 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_12 280 40 142 0   29     0   20   240 271 *                     511.0 280 40 142 0   29     0   20   240 271                 511
1675456 MA Middlesex   school 2506840 155   Lexington 250684001001 1550505 Lexington - Lexington High   Regular School No High 09 12 2021   grade_12 252 14 25 2   203     0   34   260 270 *                     530.0 252 14 25 2   203     0   34   260 270                 530
1677564 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_10 155 21 314 0   26     1   7   256 268 *                     524.0 155 21 314 0   26     1   7   256 268                 524
1677857 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury - Shrewsbury Sr High   Regular School No High 09 12 2021   grade_10 281 19 37 2   124     0   17   212 268 *                     480.0 281 19 37 2   124     0   17   212 268                 480
1676589 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_12 155 109 235 4   8     2   26   274 265 *                     539.0 155 109 235 4   8     2   26   274 265                 539
1679216 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth - Weymouth High School   Regular School No High 08 12 2021   grade_9 338 49 67 2   24     1   13   232 262 *                     494.0 338 49 67 2   24     1   13   232 262                 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
1675839 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_11 46 49 390 4   39     0   8   275 261 *                     536.0 46 49 390 4   39     0   8   275 261                 536
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
1681356 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 2021   grade_9 349 43 131 4   7     1   32   306 261 *                     567.0 349 43 131 4   7     1   32   306 261                 567
1681359 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 2021   grade_12 297 37 132 3   3     0   26   237 261 *                     498.0 297 37 132 3   3     0   26   237 261                 498
1681361 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_10 231 30 219 0   104     0   0   321 260 3                     584.0 231 30 219 0   104     0   0   321 260 3               584
1676724 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_11 316 31 60 0   91     0   40   279 259 *                     538.0 316 31 60 0   91     0   40   279 259                 538
1678554 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_11 313 77 79 0   12     1   13   238 257 *                     495.0 313 77 79 0   12     1   13   238 257                 495
1674320 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_10 94 85 307 4   26     0   10   270 256 *                     526.0 94 85 307 4   26     0   10   270 256                 526
1673578 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_12 263 45 65 0   88     1   41   248 255 *                     503.0 263 45 65 0   88     1   41   248 255                 503
1674625 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_12 306 46 116 0   30     0   18   260 255 *                     516.0 306 46 116 0   30     0   18   260 255                 516
1677855 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury - Sherwood Middle School   Regular School No Middle 05 06 2021   grade_6 240 13 53 2   159     0   24   236 255 *                     491.0 240 13 53 2   159     0   24   236 255                 491
1681358 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 2021   grade_11 306 47 135 1   7     1   24   266 255 *                     521.0 306 47 135 1   7     1   24   266 255                 521
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
1677846 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury - Oak Middle School   Regular School No Middle 07 08 2021   grade_7 251 13 41 2   172     0   23   248 254 *                     502.0 251 13 41 2   172     0   23   248 254                 502
1676722 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_9 319 24 63 0   77     0   32   261 253 *                     515.0 319 24 63 0   77     0   32   261 253                 515
1673712 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_10 179 128 79 0   45     3   44   226 252 *                     478.0 179 128 79 0   45     3   44   226 252                 478
1681341 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District - Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2021   grade_10 317 8 63 1   5     1   18   161 252 *                     413.0 317 8 63 1   5     1   18   161 252                 413
1674321 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett - Everett High   Regular School No High 09 12 2021   grade_11 99 103 287 3   25     0   7   273 251 *                     524.0 99 103 287 3   25     0   7   273 251                 524
1675838 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn - Lynn English High   Regular School No High 09 12 2021   grade_10 42 47 394 2   42     0   11   285 251 *                     538.0 42 47 394 2   42     0   11   285 251                 538
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
1672151 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_12 304 9 25 0   97     0   11   196 249 *                     446.0 304 9 25 0   97     0   11   196 249                 446
1676725 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_12 309 37 48 1   71     0   33   248 249 *                     499.0 309 37 48 1   71     0   33   248 249                 499
1676728 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_10 297 14 26 0   116     0   32   236 248 *                     485.0 297 14 26 0   116     0   32   236 248                 485
1677858 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury - Shrewsbury Sr High   Regular School No High 09 12 2021   grade_11 270 12 45 2   123     0   18   222 248 *                     470.0 270 12 45 2   123     0   18   222 248                 470
1673576 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_10 263 50 53 0   72     0   52   242 247 *                     490.0 263 50 53 0   72     0   52   242 247                 490
1673800 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Chelsea - Shurtleff Early Childhood   Regular School No Elementary PK 01 2021   kindergarten 36 30 404 2   0     0   5   230 247 *                     477.0 36 30 404 2   0     0   5   230 247                 477
1674437 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_9 250 57 149 0   31     0   38   279 246 *                     525.0 250 57 149 0   31     0   38   279 246                 525
1676229 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_11 243 16 194 0   21     0   18   246 246 *                     492.0 243 16 194 0   21     0   18   246 246                 492
1681363 MA Middlesex   school 2505480 828   Greater Lowell Regional Vocational Technical 250548002268 8280605 Greater Lowell Regional Vocational Technical - Gr Lowell Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_12 245 21 171 1   81     0   19   292 246 0                     538.0 245 21 171 1   81     0   19   292 246 0               538
1675828 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn - Breed Middle School   Regular School No Middle 06 08 2021   grade_7 35 38 361 1   47     0   18   255 245 *                     500.0 35 38 361 1   47     0   18   255 245                 500
1677859 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury - Shrewsbury Sr High   Regular School No High 09 12 2021   grade_12 261 15 43 2   125     0   18   217 245 *                     464.0 261 15 43 2   125     0   18   217 245                 464
1678307 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_10 45 109 342 1   15     0   12   280 244 *                     524.0 45 109 342 1   15     0   12   280 244                 524
1678553 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_10 298 108 70 1   6     1   24   264 244 *                     508.0 298 108 70 1   6     1   24   264 244                 508
1681340 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex North Shore Agricultural and Technical School District - Essex North Shore Agricultural and Technical School   Career and Technical School No High 09 12 2021   grade_9 338 9 54 0   10     0   15   180 244 *                     426.0 338 9 54 0   10     0   15   180 244                 426
1676445 MA Norfolk   school 2508370 199   Needham 250837001308 1990405 Needham - Pollard Middle   Regular School No Middle 07 08 2021   grade_7 357 12 42 0   31     0   19   218 243 *                     461.0 357 12 42 0   31     0   19   218 243                 461
1672149 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_10 312 8 25 2   78     0   12   195 242 *                     437.0 312 8 25 2   78     0   12   195 242                 437
1674955 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill - Haverhill High   Regular School No High 09 12 2021   grade_9 274 28 202 2   6     2   5   277 242 *                     519.0 274 28 202 2   6     2   5   277 242                 519
1674439 MA Bristol   school 2504830 95   Fall River 250483000649 950505 Fall River - B M C Durfee High   Regular School No High 09 12 2021   grade_11 262 51 140 1   28     0   29   270 241 *                     511.0 262 51 140 1   28     0   29   270 241                 511
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
1673575 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_9 256 32 79 0   86     0   56   268 240 *                     509.0 256 32 79 0   86     0   56   268 240                 509
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
1676228 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_10 217 11 234 0   23     0   25   271 239 *                     510.0 217 11 234 0   23     0   25   271 239                 510
1673577 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline - Brookline High   Regular School No High 09 12 2021   grade_11 296 31 64 0   71     1   52   274 238 *                     515.0 296 31 64 0   71     1   52   274 238                 515
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
1677847 MA Worcester   school 2510770 271   Shrewsbury 251077001825 2710030 Shrewsbury - Oak Middle School   Regular School No Middle 07 08 2021   grade_8 238 17 50 1   157     0   20   245 238 *                     483.0 238 17 50 1   157     0   20   245 238                 483
1677854 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury - Sherwood Middle School   Regular School No Middle 05 06 2021   grade_5 212 17 42 1   185     0   16   236 237 *                     473.0 212 17 42 1   185     0   16   236 237                 473
1677856 MA Worcester   school 2510770 271   Shrewsbury 251077001717 2710505 Shrewsbury - Shrewsbury Sr High   Regular School No High 09 12 2021   grade_9 241 21 40 2   138     0   17   222 237 *                     459.0 241 21 40 2   138     0   17   222 237                 459
1679213 MA Norfolk   school 2512840 336   Weymouth 251284002607 3360310 Weymouth - Abigail Adams Middle School   Regular School No Middle 05 08 2021   grade_6 281 37 60 1   27     1   17   187 237 *                     424.0 281 37 60 1   27     1   17   187 237                 424
1675824 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_6 38 46 336 1   34     1   13   233 236 *                     469.0 38 46 336 1   34     1   13   233 236                 469
1676730 MA Middlesex   school 2508610 207   Newton 250861001375 2070510 Newton - Newton South High   Regular School No High 09 12 2021   grade_12 301 20 35 0   106     0   29   254 236 *                     491.0 301 20 35 0   106     0   29   254 236                 491
1679219 MA Norfolk   school 2512840 336   Weymouth 251284002123 3360505 Weymouth - Weymouth High School   Regular School No High 08 12 2021   grade_12 328 28 42 0   24     0   15   200 236 *                     437.0 328 28 42 0   24     0   15   200 236                 437
1676723 MA Middlesex   school 2508610 207   Newton 250861001374 2070505 Newton - Newton North High   Regular School No High 09 12 2021   grade_10 308 22 55 2   66     0   40   257 235 *                     493.0 308 22 55 2   66     0   40   257 235                 493
1677138 MA Essex   school 2509360 229   Peabody 250936001495 2290305 Peabody - J Henry Higgins Middle   Regular School No Middle 06 08 2021   grade_6 344 26 86 0   9     0   11   241 235 *                     476.0 344 26 86 0   9     0   11   241 235                 476
1681357 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 2021   grade_10 300 43 136 0   7     0   41   293 234 *                     527.0 300 43 136 0   7     0   41   293 234                 527
1677566 MA Suffolk   school 2510050 248   Revere 251005001630 2480505 Revere - Revere High   Regular School No High 09 12 2021   grade_12 148 17 258 9   31     0   9   239 233 *                     472.0 148 17 258 9   31     0   9   239 233                 472
1675835 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_11 93 30 272 5   43     0   19   230 232 *                     462.0 93 30 272 5   43     0   19   230 232                 462
1679677 MA Worcester   school 2513230 348   Worcester 251323002305 3480605 Worcester - Worcester Technical High   Career and Technical School No High 09 12 2021   grade_10 124 64 150 0   29     0   14   149 232 *                     381.0 124 64 150 0   29     0   14   149 232                 381
1675825 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn - Thurgood Marshall Mid   Regular School No Middle 06 08 2021   grade_7 40 53 344 1   27     0   20   253 231 *                     485.0 40 53 344 1   27     0   20   253 231                 485
1673713 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_11 186 129 65 2   46     2   46   246 230 *                     476.0 186 129 65 2   46     2   46   246 230                 476
1676230 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen - Methuen High   Regular School No High 09 12 2021   grade_12 240 8 182 1   23     0   18   242 230 *                     472.0 240 8 182 1   23     0   18   242 230                 472
1675834 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Lynn - Classical High   Regular School No High 09 12 2021   grade_10 62 37 316 1   49     0   11   247 229 *                     476.0 62 37 316 1   49     0   11   247 229                 476
1676450 MA Norfolk   school 2508370 199   Needham 250837001315 1990505 Needham - Needham High   Regular School No High 09 12 2021   grade_11 345 10 18 2   44     1   25   214 229 2                     445.0 345 10 18 2   44     1   25   214 229 2               445
1679649 MA Worcester   school 2513230 348   Worcester 251323002213 3480415 Worcester - Forest Grove Middle   Regular School No Middle 07 08 2021   grade_7 206 63 145 0   20     0   24   229 229 *                     458.0 206 63 145 0   20     0   24   229 229                 458
1673711 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge - Cambridge Rindge and Latin   Regular School No High 09 12 2021   grade_9 162 114 73 0   43     0   36   198 228 *                     428.0 162 114 73 0   43     0   36   198 228                 428

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