enrollments

Data source: Big Local News · About: Big Local

396 rows where grade = "grade_9", state = "MA" and year = 2019 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 396 ✖

grade ✖

  • grade_9 · 396 ✖
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
2047886 2047886 MA Worcester   school 2500073 474   Sizer School 250007301750 4740505 A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School   Regular School Yes High 07 12 2019   grade_9 43 5 17 0   1     0   2   31 35                       68.0 43 5 17 0   1     0   2   31 35                 68
2047739 2047739 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2019   grade_9 19 59 25 0   6     0   0   51 58                       109.0 19 59 25 0   6     0   0   51 58                 109
2039820 2039820 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_9 134 8 12 0   4     0   1   82 77                       159.0 134 8 12 0   4     0   1   82 77                 159
2047545 2047545 MA Suffolk   school 2500021 412   Academy Of the Pacific Rim Charter Public (District) 250002100511 4120530 Academy Of the Pacific Rim Charter Public School   Regular School Yes High 05 12 2019   grade_9 10 43 17 0   1     0   0   37 34                       71.0 10 43 17 0   1     0   0   37 34                 71
2048097 2048097 MA Middlesex   school 2501710 600   Acton-Boxborough 250171000012 6000505 Acton-Boxborough Regional High   Regular School No High 09 12 2019   grade_9 246 9 22 0   154     0   29   227 233                       460.0 246 9 22 0   154     0   29   227 233                 460
2047636 2047636 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_9 102 2 12 0   31     0   9   75 81                       156.0 102 2 12 0   31     0   9   75 81                 156
2039860 2039860 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_9 219 7 21 1   6     0   11   136 129                       265.0 219 7 21 1   6     0   11   136 129                 265
2048750 2048750 MA Worcester   school 2508910 730   Northboro-Southboro 250891001441 7300505 Algonquin Regional High   Regular School No High 09 12 2019   grade_9 261 3 12 1   42     2   13   156 178                       334.0 261 3 12 1   42     2   13   156 178                 334
2039881 2039881 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_9 119 2 6 0   2     0   5   68 66                       134.0 119 2 6 0   2     0   5   68 66                 134
2039886 2039886 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_9 9 0 2 0   0     0   1   8 4                       12.0 9 0 2 0   0     0   1   8 4                 12
2048119 2048119 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2019   grade_9 150 16 29 0   20     1   15   112 119                       231.0 150 16 29 0   20     1   15   112 119                 231
2039952 2039952 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_9 293 8 32 1   84     0   8   206 219                       426.0 293 8 32 1   84     0   8   206 219                 426
2040988 2040988 MA Suffolk   school 2502790 35   Boston 250279000698 350541 Another Course To College   Alternative School No High 09 12 2019   grade_9 4 32 25 0   1     0   0   31 31                       62.0 4 32 25 0   1     0   0   31 31                 62
2048410 2048410 MA Plymouth   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2019   grade_9 137 2 8 1   1     1   4   65 89                       154.0 137 2 8 1   1     1   4   65 89                 154
2049312 2049312 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 10 2019   grade_9 68 14 23 0   2     0   7   59 55                       114.0 68 14 23 0   2     0   7   59 55                 114
2040003 2040003 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_9 270 15 18 0   39     0   22   175 189                       364.0 270 15 18 0   39     0   22   175 189                 364
2040017 2040017 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_9 156 7 24 1   28     0   8   103 121                       224.0 156 7 24 1   28     0   8   103 121                 224
2049146 2049146 MA Middlesex   school 2502110 801   Assabet Valley Regional Vocational Technical 250211002257 8010605 Assabet Valley Vocational High School   Career and Technical School No High 09 12 2019   grade_9 208 8 70 2   3     0   9   181 119                       300.0 208 8 70 2   3     0   9   181 119                 300
2048162 2048162 MA Worcester   school 2502160 615   Athol-Royalston 250216000074 6150505 Athol High   Regular School No High 09 12 2019   grade_9 80 0 2 0   0     0   3   47 38                       85.0 80 0 2 0   0     0   3   47 38                 85
2047993 2047993 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 12 2019   grade_9 58 5 16 1   1     0   1   41 41                       82.0 58 5 16 1   1     0   1   41 41                 82
2040059 2040059 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_9 330 35 72 1   24     1   16   260 219                       479.0 330 35 72 1   24     1   16   260 219                 479
2040081 2040081 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_9 141 4 14 0   6     0   8   77 96                       173.0 141 4 14 0   6     0   8   77 96                 173
2040096 2040096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_9 22 24 3 0   3     0   4   33 23                       56.0 22 24 3 0   3     0   4   33 23                 56
2048184 2048184 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202738 6160505 Ayer Shirley Regional High School   Regular School No High 09 12 2019   grade_9 62 5 8 3   2     1   6   44 43                       87.0 62 5 8 3   2     1   6   44 43                 87
2042274 2042274 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2019   grade_9 297 53 160 1   28     0   38   316 261                       577.0 297 53 160 1   28     0   38   316 261                 577
2040123 2040123 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_9 246 35 39 1   6     0   14   177 164                       341.0 246 35 39 1   6     0   14   177 164                 341
2046681 2046681 MA Worcester   school 2512240 316   Webster 251224002012 3160505 Bartlett High School   Regular School No High 09 12 2019   grade_9 62 10 42 0   3     1   9   49 78                       127.0 62 10 42 0   3     1   9   49 78                 127
2049237 2049237 MA Worcester   school 2511050 876   Southern Worcester County Regional Vocational Technical 251105001779 8760605 Bay Path Regional Vocational Technical High School   Career and Technical School No High 09 12 2019   grade_9 270 4 27 1   3     0   4   177 132                       309.0 270 4 27 1   3     0   4   177 132                 309
2049268 2049268 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School   Regular School Yes High 06 12 2019   grade_9 2 22 43 0   0     0   0   34 33                       67.0 2 22 43 0   0     0   0   34 33                 67
2040138 2040138 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_9 160 18 16 0   39     0   9   117 125                       242.0 160 18 16 0   39     0   9   117 125                 242
2040152 2040152 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_9 155 1 1 0   2     1   5   78 87                       165.0 155 1 1 0   2     1   5   78 87                 165
2040171 2040171 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_9 126 4 3 0   3     0   5   65 76                       141.0 126 4 3 0   3     0   5   65 76                 141
2040205 2040205 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont High   Regular School No High 09 12 2019   grade_9 235 11 17 0   58     0   23   170 174                       344.0 235 11 17 0   58     0   23   170 174                 344
2047558 2047558 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2019   grade_9 43 8 4 0   0     0   4   29 30                       59.0 43 8 4 0   0     0   4   29 30                 59
2040256 2040256 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2019   grade_9 283 14 42 0   8     0   12   198 161                       359.0 283 14 42 0   8     0   12   198 161                 359
2040304 2040304 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2019   grade_9 242 20 9 1   26     0   6   159 145                       304.0 242 20 9 1   26     0   6   159 145                 304
2048226 2048226 MA Worcester   school 2502715 622   Blackstone-Millville 250271500192 6220505 Blackstone Millville RHS   Regular School No High 09 12 2019   grade_9 103 0 8 0   3     0   4   56 62                       118.0 103 0 8 0   3     0   4   56 62                 118
2049150 2049150 MA Worcester   school 2502710 805   Blackstone Valley Regional Vocational Technical 250271000191 8050605 Blackstone Valley   Career and Technical School No High 09 12 2019   grade_9 276 7 19 0   8     0   0   138 172                       310.0 276 7 19 0   8     0   0   138 172                 310
2049154 2049154 MA Norfolk   school 2502740 806   Blue Hills Regional Vocational Technical 250274000193 8060605 Blue Hills Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 140 47 31 0   4     0   15   128 109                       237.0 140 47 31 0   4     0   15   128 109                 237
2041009 2041009 MA Suffolk   school 2502790 35   Boston 250279001128 350546 Boston Arts Academy   Alternative School No High 09 12 2019   grade_9 16 53 36 0   3     0   6   38 76                       114.0 16 53 36 0   3     0   6   38 76                 114
2047769 2047769 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter School   Regular School Yes High 05 12 2019   grade_9 40 32 18 0   0     0   1   46 45                       91.0 40 32 18 0   0     0   1   46 45                 91
2041019 2041019 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston Community Leadership Academy   Regular School No High 09 12 2019   grade_9 3 50 75 0   1     0   3   78 54                       132.0 3 50 75 0   1     0   3   78 54                 132
2047592 2047592 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2019   grade_9 3 46 42 2   0     0   1   46 48                       94.0 3 46 42 2   0     0   1   46 48                 94
2047536 2047536 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2019   grade_9 6 33 41 1   2     2   1   47 39                       86.0 6 33 41 1   2     2   1   47 39                 86
2040948 2040948 MA Suffolk   school 2502790 35   Boston 250279002015 350507 Boston International High School   Regular School No High 09 12 2019   grade_9 2 45 78 0   8     0   0   76 57                       133.0 2 45 78 0   8     0   0   76 57                 133
2041026 2041026 MA Suffolk   school 2502790 35   Boston 250279000203 350560 Boston Latin   Regular School No High 07 12 2019   grade_9 166 34 53 0   129     0   25   175 232                       407.0 166 34 53 0   129     0   25   175 232                 407
2041005 2041005 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2019   grade_9 76 70 83 0   57     0   12   126 172                       298.0 76 70 83 0   57     0   12   126 172                 298
2047565 2047565 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_9 0 58 29 1   1     0   1   46 44                       90.0 0 58 29 1   1     0   1   46 44                 90
2041126 2041126 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2019   grade_9 103 3 7 2   2     0   1   54 64                       118.0 103 3 7 2   2     0   1   54 64                 118
2041189 2041189 MA Norfolk   school 2502940 40   Braintree 250294000361 400505 Braintree High   Regular School No High 09 12 2019   grade_9 294 13 19 0   79     2   7   205 209                       414.0 294 13 19 0   79     2   7   205 209                 414
2048254 2048254 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2019   grade_9 297 15 5 0   5     1   19   177 165                       342.0 297 15 5 0   5     1   19   177 165                 342
2040943 2040943 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2019   grade_9 9 45 50 1   11     0   1   79 38                       117.0 9 45 50 1   11     0   1   79 38                 117
2049253 2049253 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2019   grade_9 111 3 4 0   0     1   0   32 87                       119.0 111 3 4 0   0     1   0   32 87                 119
2049158 2049158 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 304 10 22 4   2     0   17   221 138                       359.0 304 10 22 4   2     0   17   221 138                 359
2041316 2041316 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Alternative School No High 09 12 2019   grade_9 10 10 17 0   0     0   2   26 13                       39.0 10 10 17 0   0     0   2   26 13                 39
2041311 2041311 MA Plymouth   school 2503090 44   Brockton 250309000385 440505 Brockton High   Regular School No High 09 12 2019   grade_9 174 708 154 3   20     4   45   585 523                       1108.0 174 708 154 3   20     4   45   585 523                 1108
2042705 2042705 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_9 75 1 7 0   17     0   3   44 59                       103.0 75 1 7 0   17     0   3   44 59                 103
2047618 2047618 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 11 2019   grade_9 3 62 39 0   1     0   3   63 45                       108.0 3 62 39 0   1     0   3   63 45                 108
2041412 2041412 MA Norfolk   school 2503150 46   Brookline 250315000415 460505 Brookline High   Regular School No High 09 12 2019   grade_9 326 29 65 0   75     1   58   296 255                       554.0 326 29 65 0   75     1   58   296 255                 554
2041446 2041446 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   grade_9 140 19 15 2   30     0   11   103 114                       217.0 140 19 15 2   30     0   11   103 114                 217
2047466 2047466 MA Worcester   school 2513230 348   Worcester 251323002200 3480503 Burncoat Senior High   Regular School No High 09 12 2019   grade_9 91 43 124 1   11     0   20   178 112                       290.0 91 43 124 1   11     0   20   178 112                 290
2041549 2041549 MA Middlesex   school 2503270 49   Cambridge 250327000436 490506 Cambridge Rindge and Latin   Regular School No High 09 12 2019   grade_9 198 143 77 3   44     2   45   262 250                       512.0 198 143 77 3   44     2   45   262 250                 512
2041576 2041576 MA Norfolk   school 2503300 50   Canton 250330000451 500505 Canton High   Regular School No High 09 12 2019   grade_9 169 28 18 0   28     0   5   112 136                       248.0 169 28 18 0   28     0   5   112 136                 248
2049162 2049162 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 107 12 21 3   1     1   7   101 51                       152.0 107 12 21 3   1     1   7   101 51                 152
2040388 2040388 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_9 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2041601 2041601 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_9 75 2 1 0   1     0   0   42 37                       79.0 75 2 1 0   1     0   0   42 37                 79
2043237 2043237 MA Worcester   school 2506780 153   Leominster 250678002272 1530605 Center For Technical Education Innovation   Career and Technical School No High 09 12 2019   grade_9 104 20 95 0   9     0   7   167 68                       235.0 104 20 95 0   9     0   7   167 68                 235
2049205 2049205 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 127 0 3 0   1     0   3   79 55                       134.0 127 0 3 0   1     0   3   79 55                 134
2040952 2040952 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2019   grade_9 12 54 175 0   7     0   4   128 124                       252.0 12 54 175 0   7     0   4   128 124                 252
2041635 2041635 MA Middlesex   school 2503510 56   Chelmsford 250351000475 560505 Chelmsford High   Regular School No High 09 12 2019   grade_9 260 11 15 0   64     1   5   170 186                       356.0 260 11 15 0   64     1   5   170 186                 356
2041671 2041671 MA Suffolk   school 2503540 57   Chelsea 250354000482 570505 Chelsea High   Regular School No High 09 12 2019   grade_9 13 14 337 1   6     0   0   221 150                       371.0 13 14 337 1   6     0   0   221 150                 371
2041676 2041676 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_9 * * * *   *     *   *   1 4                       5.0                         1 4                 5
2041704 2041704 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_9 7 1 25 0   0     0   0   18 15                       33.0 7 1 25 0   0     0   0   18 15                 33
2041748 2041748 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2019   grade_9 191 5 72 0   6     0   6   152 128                       280.0 191 5 72 0   6     0   6   152 128                 280
2041744 2041744 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2019   grade_9 142 13 124 0   4     0   5   145 143                       288.0 142 13 124 0   4     0   5   145 143                 288
2047667 2047667 MA Suffolk   school 2500026 437   City on a Hill Charter Public School Circuit Street (District) 250002600530 4370505 City on a Hill Charter Public School Circuit Street   Regular School Yes High 09 12 2019   grade_9 0 54 33 0   0     0   0   49 38                       87.0 0 54 33 0   0     0   0   49 38                 87
2049281 2049281 MA Suffolk   school 2500548 3504   City on a Hill Charter Public School Dudley Square (District) 250054802781 35040505 City on a Hill Charter Public School Dudley Square   Regular School Yes High 09 12 2019   grade_9 3 43 29 0   1     0   1   45 32                       77.0 3 43 29 0   1     0   1   45 32                 77
2049301 2049301 MA Bristol   school 2500553 3507   City on a Hill Charter Public School New Bedford (District) 250055302814 35070505 City on a Hill Charter Public School New Bedford   Regular School Yes High 09 12 2019   grade_9 26 7 37 1   0     0   7   49 28                       78.0 26 7 37 1   0     0   7   49 28                 78
2047453 2047453 MA Worcester   school 2513230 348   Worcester 251323002121 3480350 Claremont Academy   Regular School No High 07 12 2019   grade_9 6 12 74 0   7     0   1   48 52                       100.0 6 12 74 0   7     0   1   48 52                 100
2043660 2043660 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2019   grade_9 108 32 261 4   48     0   19   234 238                       472.0 108 32 261 4   48     0   19   234 238                 472
2041772 2041772 MA Worcester   school 2503750 64   Clinton 250375000513 640505 Clinton Senior High   Regular School No High 09 12 2019   grade_9 60 3 32 0   2     0   3   51 49                       100.0 60 3 32 0   2     0   3   51 49                 100
2047681 2047681 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_9 0 31 8 0   0     0   1   20 20                       40.0 0 31 8 0   0     0   1   20 20                 40
2041786 2041786 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No High 06 12 2019   grade_9 98 3 2 2   4     0   2   55 56                       111.0 98 3 2 2   4     0   2   55 56                 111
2040957 2040957 MA Suffolk   school 2502790 35   Boston 250279001617 350518 Community Academy   Regular School No High 09 12 2019   grade_9 0 7 4 0   0     0   0   6 5                       11.0 0 7 4 0   0     0   0   6 5                 11
2041049 2041049 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Community Academy of Science and Health   Regular School No High 09 12 2019   grade_9 2 48 20 1   2     0   5   47 31                       78.0 2 48 20 1   2     0   5   47 31                 78
2047663 2047663 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge   Regular School Yes High 06 12 2019   grade_9 4 37 12 0   1     0   3   26 31                       57.0 4 37 12 0   1     0   3   26 31                 57
2048294 2048294 MA Middlesex   school 2503870 640   Concord-Carlisle 250387000527 6400505 Concord Carlisle High   Regular School No High 09 12 2019   grade_9 250 14 18 1   25     0   22   145 184                       330.0 250 14 18 1   25     0   22   145 184                 330
2046109 2046109 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Conservatory of the Arts   Regular School No High 06 12 2019   grade_9 7 6 38 0   0     0   0   20 31                       51.0 7 6 38 0   0     0   0   20 31                 51
2043952 2043952 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2041856 2041856 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2019   grade_9 173 5 17 1   6     0   6   115 93                       208.0 173 5 17 1   6     0   6   115 93                 208
2041884 2041884 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2019   grade_9 242 5 11 0   1     0   22   136 145                       281.0 242 5 11 0   1     0   22   136 145                 281
2048969 2048969 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000201790 7670505 David Prouty High   Regular School No High 09 12 2019   grade_9 50 1 10 0   1     0   3   37 28                       65.0 50 1 10 0   1     0   3   37 28                 65
2040431 2040431 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_9 2 51 24 0   2     1   2   41 41                       82.0 2 51 24 0   2     1   2   41 41                 82
2041913 2041913 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2019   grade_9 124 9 31 0   2     0   4   95 75                       170.0 124 9 31 0   2     0   4   95 75                 170
2048317 2048317 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_9 127 22 27 3   3     0   11   92 101                       193.0 127 22 27 3   3     0   11   92 101                 193
2042139 2042139 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_9 2 0 4 0   0     0   1   6 1                       7.0 2 0 4 0   0     0   1   6 1                 7
2048342 2048342 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2019   grade_9 181 3 13 1   1     0   3   97 105                       202.0 181 3 13 1   1     0   3   97 105                 202
2049175 2049175 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Career and Technical School No High 09 12 2019   grade_9 283 12 55 1   7     0   19   202 175                       377.0 283 12 55 1   7     0   19   202 175                 377
2047471 2047471 MA Worcester   school 2513230 348   Worcester 251323002209 3480512 Doherty Memorial High   Regular School No High 09 12 2019   grade_9 137 52 133 0   23     0   16   198 163                       361.0 137 52 133 0   23     0   16   198 163                 361
2041935 2041935 MA Worcester   school 2504230 77   Douglas 250423000570 770505 Douglas High School   Regular School No High 09 12 2019   grade_9 86 1 3 0   2     1   2   51 44                       95.0 86 1 3 0   2     1   2   51 44                 95

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