Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by year descending

View and edit SQL

year

grade

  • grade_9 · 2,737
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade year ▲ term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
1681540 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District - TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_9 240 34 60 0   6     0   21   167 193 *                     361.0 240 34 60 0   6     0   21   167 193                 361
1681527 MA Franklin   school 2500551 3901   Massachusetts Virtual Academy at Greenfield Commonwealth Virtual District 250055102808 39010900 Greenfield Commonwealth Virtual District - Greenfield Commonwealth Virtual School   Regular School No Other KG 12 2021   grade_9 81 8 27 1   4     1   10   62 68 2                     132.0 81 8 27 1   4     1   10   62 68 2               132
1681515 MA Essex   school 2500590 3518   Phoenix Academy Public Charter High School Lawrence (District) 250059002886 35180505 Phoenix Academy Public Charter High School Lawrence (District) - Phoenix Academy Public Charter High School Lawrence   Regular School Yes High 09 12 2021   grade_9 8 0 112 0   0     0   0   77 42 *                     120.0 8 0 112 0   0     0   0   77 42                 120
1681511 MA Plymouth   school 2500589 3517   Map Academy Charter School (District) 250058902885 35170505 Map Academy Charter School (District) - Map Academy Charter School   Regular School Yes High 09 12 2021   grade_9 21 7 7 0   0     2   2   24 15 *                     39.0 21 7 7 0   0     2   2   24 15                 39
1681508 MA Hampden   school 2500588 3516   Hampden Charter School of Science West (District) 250058802888 35160305 Hampden Charter School of Science West (District) - Hampden Charter School of Science West   Regular School Yes Secondary 06 11 2021   grade_9 33 8 16 0   1     0   1   37 22 *                     59.0 33 8 16 0   1     0   1   37 22                 59
1681491 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District) - New Heights Charter School of Brockton   Regular School Yes High 06 12 2021   grade_9 2 87 7 1   0     0   1   53 45 *                     98.0 2 87 7 1   0     0   1   53 45                 98
1681477 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School   Regular School Yes Secondary 06 11 2021   grade_9 34 10 14 1   1     0   5   42 23 *                     65.0 34 10 14 1   1     0   5   42 23                 65
1681471 MA Hampden   school 2500555 3508   Phoenix Academy Public Charter High School Springfield (District) 250055502821 35080505 Phoenix Academy Public Charter High School Springfield (District) - Phoenix Academy Public Charter High School Springfield   Regular School Yes High 09 12 2021   grade_9 6 19 120 1   0     1   2   85 64 *                     149.0 6 19 120 1   0     1   2   85 64                 149
1681467 MA Middlesex   school 2500546 3506   Pioneer Charter School of Science II (PCSS-II) (District) 250054602780 35060505 Pioneer Charter School of Science II (PCSS-II) (District) - Pioneer Charter School of Science II (PCSS-II)   Regular School Yes High 07 12 2021   grade_9 17 21 16 0   7     0   1   39 23 *                     62.0 17 21 16 0   7     0   1   39 23                 62
1681453 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District) - Collegiate Charter School of Lowell   Regular School Yes Other KG 09 2021   grade_9 6 4 13 0   5     0   1   14 15 *                     29.0 6 4 13 0   5     0   1   14 15                 29
1681440 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District) - Baystate Academy Charter Public School   Regular School Yes High 06 12 2021   grade_9 5 15 46 0   2     1   1   41 29 *                     70.0 5 15 46 0   2     1   1   41 29                 70
1681433 MA Hampshire   school 2500547 3501   Paulo Freire Social Justice Charter School (District) 250054702782 35010505 Paulo Freire Social Justice Charter School (District) - Paulo Freire Social Justice Charter School   Regular School Yes High 09 12 2021   grade_9 2 4 63 0   0     0   0   32 37 *                     69.0 2 4 63 0   0     0   0   32 37                 69
1681429 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural - Norfolk County Agricultural   Career and Technical School No High 09 12 2021   grade_9 147 1 0 1   0     0   9   37 121 *                     158.0 147 1 0 1   0     0   9   37 121                 158
1681425 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural - Bristol County Agricultural High   Career and Technical School No High 09 12 2021   grade_9 114 3 4 0   0     0   2   24 99 *                     123.0 114 3 4 0   0     0   2   24 99                 123
1681421 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational Technical - Whittier Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 212 10 93 1   6     0   13   174 161 *                     335.0 212 10 93 1   6     0   13   174 161                 335
1681417 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Regional Vocational Technical - Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 164 4 15 2   1     0   18   112 92 *                     204.0 164 4 15 2   1     0   18   112 92                 204
1681413 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical - Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 214 6 25 0   1     0   14   150 108 *                     260.0 214 6 25 0   1     0   14   150 108                 260
1681409 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Southern Worcester County Regional Vocational Technical - Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2021   grade_9 263 3 35 0   4     0   9   181 133 *                     314.0 263 3 35 0   4     0   9   181 133                 314
1681405 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 South Shore Regional Vocational Technical - So Shore Vocational Technical High   Career and Technical School No High 09 12 2021   grade_9 154 4 10 0   0     0   0   103 65 *                     168.0 154 4 10 0   0     0   0   103 65                 168
1681401 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical - Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 151 150 78 0   9     0   22   187 223 *                     410.0 151 150 78 0   9     0   22   187 223                 410
1681397 MA Middlesex   school 2510615 871   Shawsheen Valley Regional Vocational Technical 251061501701 8710605 Shawsheen Valley Regional Vocational Technical - Shawsheen Valley Vocational Technical High School   Career and Technical School No High 09 12 2021   grade_9 322 3 24 3   3     0   2   228 129 *                     357.0 322 3 24 3   3     0   2   228 129                 357
1681393 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Regional Vocational Technical - Pathfinder Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 153 0 3 0   0     0   0   100 56 *                     156.0 153 0 3 0   0     0   0   100 56                 156
1681389 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical - Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 140 1 1 0   2     0   6   94 56 *                     150.0 140 1 1 0   2     0   6   94 56                 150
1681385 MA Middlesex   school 2508960 853   Northeast Metropolitan Regional Vocational Technical 250896002283 8530605 Northeast Metropolitan Regional Vocational Technical - Northeast Metro Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 282 5 44 0   1     0   0   183 147 *                     332.0 282 5 44 0   1     0   0   183 147                 332
1681381 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Regional Vocational Technical - Nashoba Valley Technical High School   Career and Technical School No High 09 12 2021   grade_9 153 3 20 0   3     0   11   112 76 2                     190.0 153 3 20 0   3     0   11   112 76 2               190
1681377 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Northern Berkshire Regional Vocational Technical - Charles McCann Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 124 1 2 0   1     0   0   72 56 *                     128.0 124 1 2 0   1     0   0   72 56                 128
1681373 MA Worcester   school 2508050 832   Montachusett Regional Vocational Technical 250805002279 8320605 Montachusett Regional Vocational Technical - Montachusett Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 268 7 58 0   6     0   16   175 179 1                     355.0 268 7 58 0   6     0   16   175 179 1               355
1681369 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional Vocational Technical - Minuteman Regional High   Career and Technical School No High 09 12 2021   grade_9 136 9 17 1   4     0   12   101 78 *                     179.0 136 9 17 1   4     0   12   101 78                 179
1681365 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_9 123 6 81 5   4     0   7   116 109 *                     226.0 123 6 81 5   4     0   7   116 109                 226
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
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
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
1681348 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Greater Fall River Regional Vocational Technical - Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2021   grade_9 281 15 48 2   8     0   20   194 178 *                     374.0 281 15 48 2   8     0   20   194 178                 374
1681344 MA Franklin   school 2505020 818   Franklin County Regional Vocational Technical 250502000744 8180605 Franklin County Regional Vocational Technical - Franklin County Technical   Career and Technical School No High 09 12 2021   grade_9 152 1 11 1   0     4   2   89 82 *                     171.0 152 1 11 1   0     4   2   89 82                 171
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
1681336 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical - Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 14 16 4   1     1   10   103 70 *                     174.0 128 14 16 4   1     1   10   103 70                 174
1681332 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Regional Vocational Technical - Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 293 16 18 0   4     0   12   202 141 *                     343.0 293 16 18 0   4     0   12   202 141                 343
1681328 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical - Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 61 39 3   5     0   11   136 111 *                     247.0 128 61 39 3   5     0   11   136 111                 247
1681324 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley Regional Vocational Technical - Blackstone Valley   Career and Technical School No High 09 12 2021   grade_9 268 6 31 0   4     0   9   164 153 *                     318.0 268 6 31 0   4     0   9   164 153                 318
1681320 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Regional Vocational Technical - Assabet Valley Vocational High School   Career and Technical School No High 09 12 2021   grade_9 219 1 78 0   2     0   6   166 138 2                     306.0 219 1 78 0   2     0   6   166 138 2               306
1681315 MA Plymouth   school 2512930 780   Whitman-Hanson 251293002135 7800505 Whitman-Hanson - Whitman Hanson Regional   Regular School No High 09 12 2021   grade_9 206 10 14 0   3     0   7   126 114 *                     240.0 206 10 14 0   3     0   7   126 114                 240
1681286 MA Worcester   school 2512100 778   Quaboag Regional 251210001994 7780505 Quaboag Regional - Quaboag Regional High   Regular School No High 09 12 2021   grade_9 77 1 7 0   0     0   4   51 38 *                     89.0 77 1 7 0   0     0   4   51 38                 89
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
1681185 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton - Triton Regional High School   Regular School No High 09 12 2021   grade_9 135 3 8 0   4     0   4   76 78 *                     154.0 135 3 8 0   4     0   4   76 78                 154
1681155 MA Worcester   school 2511490 770   Tantasqua 251149001901 7700605 Tantasqua - Tantasqua Regional Vocational   Career and Technical School No High 09 12 2021   grade_9 128 1 7 0   0     0   4   92 48 *                     140.0 128 1 7 0   0     0   4   92 48                 140
1681151 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua - Tantasqua Regional Sr High   Regular School No High 09 12 2021   grade_9 150 3 11 1   1     0   4   81 89 *                     170.0 150 3 11 1   1     0   4   81 89                 170
1681144 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 Spencer-E Brookfield - David Prouty High   Regular School No High 09 12 2021   grade_9 64 2 19 0   2     0   5   55 37 *                     92.0 64 2 19 0   2     0   5   55 37                 92
1681123 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_9 93 0 7 0   1     0   3   53 51 *                     104.0 93 0 7 0   1     0   3   53 51                 104
1681109 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire - Mt Everett Regional   Regular School No High 06 12 2021   grade_9 32 0 1 0   0     0   2   13 22 *                     35.0 32 0 1 0   0     0   2   13 22                 35
1681088 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional School District - Somerset Berkley Regional High School   Regular School No High 09 12 2021   grade_9 236 2 15 0   0     0   4   123 134 *                     257.0 236 2 15 0   0     0   4   123 134                 257
1681083 MA Plymouth   school 2510830 760   Silver Lake 251083001722 7600505 Silver Lake - Silver Lake Regional High   Regular School No High 09 12 2021   grade_9 238 3 6 1   5     0   4   136 121 *                     257.0 238 3 6 1   5     0   4   136 121                 257
1681076 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar - Ralph C Mahar Regional   Regular School No High 07 12 2021   grade_9 73 0 7 0   0     0   1   46 35 *                     81.0 73 0 7 0   0     0   1   46 35                 81
1681069 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin - Quabbin Regional High School   Regular School No High 09 12 2021   grade_9 162 1 6 1   4     0   2   80 94 *                     176.0 162 1 6 1   4     0   2   80 94                 176
1681036 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_9 36 1 1 0   0     0   2   24 16 *                     40.0 36 1 1 0   0     0   2   24 16                 40
1681014 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket - Pentucket Regional Sr High   Regular School No High 09 12 2021   grade_9 132 0 7 0   3     1   0   60 83 *                     143.0 132 0 7 0   3     1   0   60 83                 143
1680983 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester - Old Rochester Regional High   Regular School No High 09 12 2021   grade_9 132 4 7 0   1     0   8   77 75 *                     152.0 132 4 7 0   1     0   8   77 75                 152
1680976 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex - North Middlesex Regional   Regular School No High 09 12 2021   grade_9 159 5 9 0   7     0   7   107 80 *                     187.0 159 5 9 0   7     0   7   107 80                 187
1680944 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Northboro-Southboro - Algonquin Regional High   Regular School No High 09 12 2021   grade_9 214 7 25 0   47     2   19   151 163 *                     314.0 214 7 25 0   47     2   19   151 163                 314
1680931 MA Worcester   school 2508310 725   Nashoba 250831001289 7250505 Nashoba - Nashoba Regional   Regular School No High 09 12 2021   grade_9 190 2 10 0   13     0   8   113 110 *                     223.0 190 2 10 0   13     0   8   113 110                 223
1680897 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett - Narragansett Regional High   Regular School No High 08 12 2021   grade_9 83 0 3 0   0     0   3   50 39 *                     89.0 83 0 3 0   0     0   3   50 39                 89
1680882 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail - Mohawk Trail Regional School   Regular School No High 07 12 2021   grade_9 30 0 3 0   1     0   1   19 16 *                     35.0 30 0 3 0   1     0   1   19 16                 35
1680852 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock - Mt Greylock Regional High   Regular School No High 07 12 2021   grade_9 105 2 2 0   4     0   2   49 66 *                     115.0 105 2 2 0   4     0   2   49 66                 115
1680830 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional School District - Monomoy Regional High School   Regular School No High 08 12 2021   grade_9 88 8 11 0   1     0   4   57 55 *                     112.0 88 8 11 0   1     0   4   57 55                 112
1680810 MA Worcester   school 2507680 710   Mendon-Upton 250768001202 7100510 Mendon-Upton - Nipmuc Regional High   Regular School No High 09 12 2021   grade_9 135 2 8 0   3     0   5   75 78 *                     153.0 135 2 8 0   3     0   5   75 78                 153
1680790 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet - Masconomet Regional High School   Regular School No High 09 12 2021   grade_9 236 2 11 0   11     0   5   119 146 *                     265.0 236 2 11 0   11     0   5   119 146                 265
1680783 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard - Martha's Vineyard Regional High   Regular School No High 09 12 2021   grade_9 114 7 28 3   1     0   12   79 86 *                     165.0 114 7 28 3   1     0   12   79 86                 165
1680779 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional - Manchester Essex Regional High School   Regular School No High 09 12 2021   grade_9 93 0 1 0   1     0   1   51 45 *                     96.0 93 0 1 0   1     0   1   51 45                 96
1680758 MA Middlesex   school 2506930 695   Lincoln-Sudbury 250693001011 6950505 Lincoln-Sudbury - Lincoln-Sudbury Regional High   Regular School No High 09 12 2021   grade_9 279 21 16 1   5     0   47   180 189 *                     369.0 279 21 16 1   5     0   47   180 189                 369
1680751 MA Norfolk   school 2506510 690   King Philip 250651000940 6900505 King Philip - King Philip Regional High   Regular School No High 09 12 2021   grade_9 273 6 14 1   12     0   0   158 148 *                     306.0 273 6 14 1   12     0   0   158 148                 306
1680738 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire - Hampshire Regional High   Regular School No High 07 12 2021   grade_9 95 0 2 0   1     0   3   51 50 *                     101.0 95 0 2 0   1     0   3   51 50                 101
1680732 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000824 6800505 Hampden-Wilbraham - Minnechaug Regional High   Regular School No High 09 12 2021   grade_9 210 7 21 0   6     0   17   127 134 *                     261.0 210 7 21 0   6     0   17   127 134                 261
1680708 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham - Hamilton-Wenham Regional High   Regular School No High 09 12 2021   grade_9 100 1 8 0   11     0   4   50 74 *                     124.0 100 1 8 0   11     0   4   50 74                 124
1680681 MA Franklin   school 2505270 674   Gill-Montague 250527000768 6740505 Gill-Montague - Turners Fall High   Regular School No High 09 12 2021   grade_9 37 2 5 0   0     0   5   25 24 *                     49.0 37 2 5 0   0     0   5   25 24                 49
1680659 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton-Dunstable - Groton Dunstable Regional   Regular School No High 09 12 2021   grade_9 154 0 2 1   9     1   4   84 87 *                     171.0 154 0 2 1   9     1   4   84 87                 171
1680639 MA Hampshire   school 2505160 672   Gateway 250516000758 6720505 Gateway - Gateway Regional High   Regular School No High 09 12 2021   grade_9 44 1 4 0   0     0   0   22 27 *                     49.0 44 1 4 0   0     0   0   22 27                 49
1680618 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_9 75 5 5 0   7     0   7   58 41 *                     99.0 75 5 5 0   7     0   7   58 41                 99
1680612 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Freetown-Lakeville - Apponequet Regional High   Regular School No High 09 12 2021   grade_9 191 2 4 0   0     0   1   94 104 *                     198.0 191 2 4 0   0     0   1   94 104                 198
1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
1680577 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000591 6580505 Dudley-Charlton Reg - Shepherd Hill Regional High   Regular School No High 09 12 2021   grade_9 211 5 33 0   4     0   9   120 142 *                     262.0 211 5 33 0   4     0   9   120 142                 262
1680552 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000574 6550505 Dover-Sherborn - Dover-Sherborn Regional High   Regular School No High 09 12 2021   grade_9 137 3 9 1   16     0   10   94 81 *                     176.0 137 3 9 1   16     0   10   94 81                 176
1680544 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth - Dighton-Rehoboth Regional High School   Regular School No High 09 12 2021   grade_9 158 3 9 0   4     0   6   101 79 *                     180.0 158 3 9 0   4     0   6   101 79                 180
1680520 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth - Dennis-Yarmouth Regional High   Regular School No High 08 12 2021   grade_9 89 14 26 3   4     0   12   67 81 *                     148.0 89 14 26 3   4     0   12   67 81                 148
1680495 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord-Carlisle - Concord Carlisle High   Regular School No High 09 12 2021   grade_9 253 14 24 1   21     0   26   168 170 *                     339.0 253 14 24 1   21     0   26   168 170                 339
1680491 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Central Berkshire - Wahconah Regional High   Regular School No High 09 12 2021   grade_9 132 1 4 0   2     0   5   72 72 *                     144.0 132 1 4 0   2     0   5   72 72                 144
1680456 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham - Bridgewater-Raynham Regional   Regular School No High 09 12 2021   grade_9 245 29 9 0   6     0   16   153 152 *                     305.0 245 29 9 0   6     0   16   153 152                 305
1680453 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_9 * * * *   *     *   *   2 * *                     4.0                         2                   4
1680429 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone-Millville - Blackstone Millville RHS   Regular School No High 09 12 2021   grade_9 88 2 4 0   0     0   5   60 38 *                     99.0 88 2 4 0   0     0   5   60 38                 99
1680409 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_9 66 1 10 0   7     0   1   45 40 *                     85.0 66 1 10 0   7     0   1   45 40                 85
1680388 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Berkshire Hills - Monument Mt Regional High   Regular School No High 09 12 2021   grade_9 89 3 8 1   5     0   7   59 54 *                     113.0 89 3 8 1   5     0   7   59 54                 113
1680374 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley School District - Ayer Shirley Regional High School   Regular School No High 09 12 2021   grade_9 75 2 11 1   5     2   3   54 45 *                     99.0 75 2 11 1   5     2   3   54 45                 99
1680353 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol-Royalston - Athol High   Regular School No High 09 12 2021   grade_9 71 4 22 0   1     0   2   49 51 *                     100.0 71 4 22 0   1     0   2   49 51                 100
1680331 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Ashburnham-Westminster - Oakmont Regional High School   Regular School No High 09 12 2021   grade_9 146 4 12 1   2     0   1   90 76 *                     166.0 146 4 12 1   2     0   1   90 76                 166
1680310 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_9 120 20 42 0   11     0   19   108 103 *                     212.0 120 20 42 0   11     0   19   108 103                 212
1680304 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_9 57 1 4 2   0     0   0   33 31 *                     64.0 57 1 4 2   0     0   0   33 31                 64
1680289 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough - Acton-Boxborough Regional High   Regular School No High 09 12 2021   grade_9 206 8 27 1   149     0   15   221 185 *                     406.0 206 8 27 1   149     0   15   221 185                 406
1680240 MA Hampden   school 2500522 499   Hampden Charter School of Science (District) 250052202680 4990305 Hampden Charter School of Science East (District) - Hampden Charter School of Science East   Regular School Yes High 06 12 2021   grade_9 17 20 43 0   2     0   1   47 36 *                     83.0 17 20 43 0   2     0   1   47 36                 83
1680229 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_9 19 4 0 0   3     0   5   12 19 *                     31.0 19 4 0 0   3     0   5   12 19                 31
1680216 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District) - Global Learning Charter Public School   Regular School Yes High 05 12 2021   grade_9 10 6 19 1   0     0   3   22 17 *                     39.0 10 6 19 1   0     0   3   22 17                 39
1680208 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District) - Pioneer Charter School of Science   Regular School Yes Other KG 12 2021   grade_9 24 11 18 2   3     0   2   34 26 *                     60.0 24 11 18 2   3     0   2   34 26                 60
1680196 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy (District) - Phoenix Charter Academy   Regular School Yes High 09 12 2021   grade_9 8 16 135 3   0     0   0   80 82 *                     162.0 8 16 135 3   0     0   0   80 82                 162

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