enrollments

Data source: Big Local News · About: Big Local

392 rows where grade = "grade_9", state = "MA" and year = 2017 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 392 ✖

grade ✖

  • grade_9 · 392 ✖
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
1122326 1122326 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_9 269 38 44 2   13     1   13   169 211                       380 269 38 44 2   13     1   13   169 211                 380
1123479 1123479 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No High 09 12 2017   grade_9 108 1 5 0   5     1   5   60 65                       125 108 1 5 0   5     1   5   60 65                 125
1124862 1124862 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2017   grade_9 195 11 11 2   9     0   12   113 127                       240 195 11 11 2   9     0   12   113 127                 240
1126744 1126744 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No High 09 12 2017   grade_9 91 6 4 5   2     0   5   60 53                       113 91 6 4 5   2     0   5   60 53                 113
1128703 1128703 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No High 09 12 2017   grade_9 162 4 4 0   5     0   1   87 89                       176 162 4 4 0   5     0   1   87 89                 176
1131608 1131608 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes High 09 12 2017   grade_9 182 4 15 2   6     0   8   99 118                       217 182 4 15 2   6     0   8   99 118                 217
1132004 1132004 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_9 138 18 22 1   4     0   11   86 108                       194 138 18 22 1   4     0   11   86 108                 194
1132081 1132081 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_9 185 13 1 1   8     0   11   100 119                       219 185 13 1 1   8     0   11   100 119                 219
1132371 1132371 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_9 100 6 4 2   3     0   4   56 63                       119 100 6 4 2   3     0   4   56 63                 119
1132992 1132992 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 2017   grade_9 117 11 20 1   2     0   9   101 59                       160 117 11 20 1   2     0   9   101 59                 160
1133092 1133092 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 163 10 3 1   4     0   11   119 73                       192 163 10 3 1   4     0   11   119 73                 192
1125907 1125907 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_9 55 0 8 0   1     0   0   30 34                       64 55 0 8 0   1     0   0   30 34                 64
1125941 1125941 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_9 60 0 6 0   1     0   1   36 32                       68 60 0 6 0   1     0   1   36 32                 68
1127590 1127590 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   grade_9 71 4 5 1   0     0   5   41 45                       86 71 4 5 1   0     0   5   41 45                 86
1128167 1128167 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2017   grade_9 159 25 19 0   5     0   8   110 106                       216 159 25 19 0   5     0   8   110 106                 216
1128172 1128172 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2017   grade_9 109 28 16 0   2     0   14   97 72                       169 109 28 16 0   2     0   14   97 72                 169
1131144 1131144 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes Other 06 12 2017   grade_9 33 8 3 0   2     0   1   24 23                       47 33 8 3 0   2     0   1   24 23                 47
1131760 1131760 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_9 57 3 3 0   0     0   0   29 34                       63 57 3 3 0   0     0   0   29 34                 63
1131860 1131860 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No High 09 12 2017   grade_9 108 1 9 0   2     0   1   63 58                       121 108 1 9 0   2     0   1   63 58                 121
1131970 1131970 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No High 09 12 2017   grade_9 119 1 5 0   0     0   0   74 51                       125 119 1 5 0   0     0   0   74 51                 125
1132378 1132378 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_9 82 0 4 0   1     0   2   42 47                       89 82 0 4 0   1     0   2   42 47                 89
1132715 1132715 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_9 47 0 7 0   0     0   1   27 28                       55 47 0 7 0   0     0   1   27 28                 55
1133042 1133042 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 123 2 3 0   0     0   6   83 51                       134 123 2 3 0   0     0   6   83 51                 134
1122250 1122250 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_9 317 22 72 2   15     0   21   242 207                       449 317 22 72 2   15     0   21   242 207                 449
1124360 1124360 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No High 09 12 2017   grade_9 241 2 5 0   1     0   20   147 122                       269 241 2 5 0   1     0   20   147 122                 269
1124591 1124591 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No High 09 12 2017   grade_9 227 13 14 1   6     0   6   132 135                       267 227 13 14 1   6     0   6   132 135                 267
1124708 1124708 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No High 09 12 2017   grade_9 155 0 11 0   2     0   2   76 94                       170 155 0 11 0   2     0   2   76 94                 170
1124806 1124806 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No High 09 12 2017   grade_9 27 6 16 0   0     2   3   30 24                       54 27 6 16 0   0     2   3   30 24                 54
1124822 1124822 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No High 09 12 2017   grade_9 344 45 150 3   30     0   25   298 299                       597 344 45 150 3   30     0   25   298 299                 597
1126612 1126612 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No High 09 12 2017   grade_9 278 8 11 0   14     0   8   169 150                       319 278 8 11 0   14     0   8   169 150                 319
1127384 1127384 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No High 09 12 2017   grade_9 189 86 270 3   3     1   23   317 258                       575 189 86 270 3   3     1   23   317 258                 575
1127390 1127390 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 06 12 2017   grade_9 7 0 5 0   0     0   1   8 5                       13 7 0 5 0   0     0   1   8 5                 13
1127395 1127395 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_9 9 6 10 0   1     0   0   21 5                       26 9 6 10 0   1     0   0   21 5                 26
1127720 1127720 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No High 09 12 2017   grade_9 233 7 15 1   21     1   6   137 147                       284 233 7 15 1   21     1   6   137 147                 284
1127841 1127841 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No High 09 12 2017   grade_9 164 1 6 0   2     1   4   86 92                       178 164 1 6 0   2     1   4   86 92                 178
1128815 1128815 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No High 09 12 2017   grade_9 131 3 6 0   4     0   3   72 75                       147 131 3 6 0   4     0   3   72 75                 147
1129640 1129640 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No High 09 12 2017   grade_9 135 1 3 1   2     0   2   75 69                       144 135 1 3 1   2     0   2   75 69                 144
1129702 1129702 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_9 334 76 63 0   9     2   18   249 253                       502 334 76 63 0   9     2   18   249 253                 502
1129707 1129707 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative School No High 08 12 2017   grade_9 * * * *   *     *   *   2 1                       *                         2 1                  
1130355 1130355 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_9 53 0 2 1   1     0   3   36 24                       60 53 0 2 1   1     0   3   36 24                 60
1131622 1131622 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_9 42 7 11 1   0     0   1   23 39                       62 42 7 11 1   0     0   1   23 39                 62
1131652 1131652 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes Other 05 12 2017   grade_9 26 2 12 0   0     0   1   19 22                       41 26 2 12 0   0     0   1   19 22                 41
1131929 1131929 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No High 09 12 2017   grade_9 316 13 7 1   8     0   9   177 177                       354 316 13 7 1   8     0   9   177 177                 354
1132032 1132032 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2017   grade_9 172 2 11 0   5     0   1   103 88                       191 172 2 11 0   5     0   1   103 88                 191
1132113 1132113 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2017   grade_9 174 2 3 0   2     1   0   98 84                       182 174 2 3 0   2     1   0   98 84                 182
1132689 1132689 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No High 09 12 2017   grade_9 251 5 11 0   0     0   11   145 133                       278 251 5 11 0   0     0   11   145 133                 278
1132987 1132987 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 302 9 19 2   1     0   12   192 153                       345 302 9 19 2   1     0   12   192 153                 345
1133007 1133007 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 2017   grade_9 302 11 31 2   7     1   18   193 179                       372 302 11 31 2   7     1   18   193 179                 372
1133017 1133017 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 394 48 95 1   3     0   21   297 265                       562 394 48 95 1   3     0   21   297 265                 562
1133057 1133057 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 141 4 1 0   2     0   3   104 47                       151 141 4 1 0   2     0   3   104 47                 151
1133072 1133072 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 163 133 48 0   7     0   28   187 192                       379 163 133 48 0   7     0   28   187 192                 379
1133102 1133102 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Career and Technical School No High 09 12 2017   grade_9 118 1 4 0   1     0   0   35 88                       124 118 1 4 0   1     0   0   35 88                 124
1133154 1133154 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 Other 09 11 2017   grade_9 32 10 56 0   0     0   4   46 56                       102 32 10 56 0   0     0   4   46 56                 102
1125195 1125195 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1131458 1131458 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_9 * * * *   *     *   *   1 2                       *                         1 2                  
1132315 1132315 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No High 09 12 2017   grade_9 131 4 18 2   2     0   10   87 80                       167 131 4 18 2   2     0   10   87 80                 167
1122035 1122035 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_9 134 2 5 0   2     0   4   74 73                       147 134 2 5 0   2     0   4   74 73                 147
1122040 1122040 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_9 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1122119 1122119 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_9 335 8 26 1   67     0   9   225 221                       446 335 8 26 1   67     0   9   225 221                 446
1122491 1122491 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No High 09 12 2017   grade_9 235 5 53 0   9     0   8   161 149                       310 235 5 53 0   9     0   8   161 149                 310
1124328 1124328 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2017   grade_9 208 2 8 0   9     0   3   111 119                       230 208 2 8 0   9     0   3   111 119                 230
1125134 1125134 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_9 97 0 5 0   1     0   5   47 61                       108 97 0 5 0   1     0   5   47 61                 108
1125180 1125180 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2017   grade_9 183 5 27 0   4     1   6   119 107                       226 183 5 27 0   4     1   6   119 107                 226
1125400 1125400 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2017   grade_9 6 0 8 0   0     0   0   12 2                       14 6 0 8 0   0     0   0   12 2                 14
1125452 1125452 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No High 09 12 2017   grade_9 295 21 173 2   8     0   6   263 242                       505 295 21 173 2   8     0   6   263 242                 505
1125732 1125732 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No High 09 12 2017   grade_9 126 0 6 0   2     0   4   66 72                       138 126 0 6 0   2     0   4   66 72                 138
1125863 1125863 MA Essex   school 2506660 149   Lawrence 250666002856 1490515 Lawrence High School   Regular School No High 09 12 2017   grade_9 39 16 921 1   12     0   1   561 429                       990 39 16 921 1   12     0   1   561 429                 990
1125873 1125873 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No High 09 12 2017   grade_9 0 0 6 0   0     0   0   4 2                       6 0 0 6 0   0     0   0   4 2                 6
1125886 1125886 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_9 4 0 11 0   0     0   0   11 4                       15 4 0 11 0   0     0   0   11 4                 15
1125891 1125891 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative School No High 09 12 2017   grade_9 3 1 56 0   1     0   0   39 22                       61 3 1 56 0   1     0   0   39 22                 61
1126493 1126493 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No High 09 12 2017   grade_9 83 40 220 1   49     0   8   226 175                       401 83 40 220 1   49     0   8   226 175                 401
1126498 1126498 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No High 09 12 2017   grade_9 74 34 275 0   44     0   13   227 213                       440 74 34 275 0   44     0   13   227 213                 440
1126505 1126505 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_9 7 3 182 0   2     0   1   129 66                       195 7 3 182 0   2     0   1   129 66                 195
1126512 1126512 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No Other 06 12 2017   grade_9 39 11 194 0   14     0   6   151 113                       264 39 11 194 0   14     0   6   151 113                 264
1126536 1126536 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2017   grade_9 130 7 1 0   5     0   3   73 73                       146 130 7 1 0   5     0   3   73 73                 146
1126641 1126641 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No High 09 12 2017   grade_9 217 8 15 0   6     0   9   125 130                       255 217 8 15 0   6     0   9   125 130                 255
1126958 1126958 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No High 09 12 2017   grade_9 263 1 168 0   18     1   30   248 233                       481 263 1 168 0   18     1   30   248 233                 481
1127413 1127413 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2017   grade_9 161 1 9 0   5     0   4   77 103                       180 161 1 9 0   5     0   4   77 103                 180
1127674 1127674 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No High 09 12 2017   grade_9 252 10 26 0   23     1   3   133 182                       315 252 10 26 0   23     1   3   133 182                 315
1128045 1128045 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No High 09 12 2017   grade_9 258 11 57 0   7     0   6   186 153                       339 258 11 57 0   7     0   6   186 153                 339
1128607 1128607 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No High 09 12 2017   grade_9 65 2 1 0   1     0   0   32 37                       69 65 2 1 0   1     0   0   32 37                 69
1128674 1128674 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2017   grade_9 109 19 103 0   3     0   7   123 118                       241 109 19 103 0   3     0   7   123 118                 241
1128679 1128679 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1128685 1128685 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1128742 1128742 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No High 09 12 2017   grade_9 108 16 22 1   9     0   0   87 69                       156 108 16 22 1   9     0   0   87 69                 156
1129614 1129614 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2017   grade_9 112 5 30 0   4     0   2   69 84                       153 112 5 30 0   4     0   2   69 84                 153
1131217 1131217 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   grade_9 12 36 76 0   2     0   4   59 71                       130 12 36 76 0   2     0   4   59 71                 130
1131565 1131565 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes Other 06 12 2017   grade_9 41 7 30 0   3     0   1   44 38                       82 41 7 30 0   3     0   1   44 38                 82
1131633 1131633 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes High 09 12 2017   grade_9 8 12 91 0   2     0   0   68 45                       113 8 12 91 0   2     0   0   68 45                 113
1132226 1132226 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No High 09 12 2017   grade_9 125 0 4 0   4     0   1   52 82                       134 125 0 4 0   4     0   1   52 82                 134
1132310 1132310 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No High 09 12 2017   grade_9 110 0 3 0   2     0   0   47 68                       115 110 0 3 0   2     0   0   47 68                 115
1132323 1132323 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No High 09 12 2017   grade_9 265 0 6 1   7     0   6   146 139                       285 265 0 6 1   7     0   6   146 139                 285
1132576 1132576 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2017   grade_9 195 0 6 0   1     0   1   107 96                       203 195 0 6 0   1     0   1   107 96                 203
1132812 1132812 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No High 09 12 2017   grade_9 177 3 5 0   3     0   1   98 91                       189 177 3 5 0   3     0   1   98 91                 189
1132997 1132997 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Career and Technical School No High 09 12 2017   grade_9 287 3 48 1   7     0   14   154 206                       360 287 3 48 1   7     0   14   154 206                 360
1133012 1133012 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 65 1 344 1   4     0   0   186 229                       415 65 1 344 1   4     0   0   186 229                 415
1133097 1133097 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Career and Technical School No High 09 12 2017   grade_9 248 5 57 2   2     0   4   163 155                       318 248 5 57 2   2     0   4   163 155                 318
1125269 1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125286 1125286 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_9 56 2 19 0   2     0   5   51 33                       84 56 2 19 0   2     0   5   51 33                 84
1131136 1131136 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2017   grade_9 32 0 3 0   1     0   2   15 23                       38 32 0 3 0   1     0   2   15 23                 38

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