Data source: Big Local News · About: Big Local

386 rows where grade = "grade_9", state = "MA" and year = 2015 sorted by county

View and edit SQL

year

  • 2015 · 386

grade

  • grade_9 · 386
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
735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
736979 MA Barnstable   school 2502820 36   Bourne 250282000348 360505 Bourne High School   Regular School No 3 09 12 2015   grade_9 98 1 3 0   1     0   6   55 54                       109 98 1 3 0   1     0   6   55 54                 109
738153 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2015   grade_9 186 8 10 1   6     1   18   114 116                       230 186 8 10 1   6     1   18   114 116                 230
739731 MA Barnstable   school 2507440 172   Mashpee 250744000886 1720505 Mashpee High   Regular School No 3 09 12 2015   grade_9 100 4 4 4   1     0   6   54 65                       119 100 4 4 4   1     0   6   54 65                 119
741413 MA Barnstable   school 2510470 261   Sandwich 251047001673 2610505 Sandwich High   Regular School No 3 09 12 2015   grade_9 170 1 1 1   3     0   0   91 85                       176 170 1 1 1   3     0   0   91 85                 176
743862 MA Barnstable   school 2500058 489   Sturgis Charter Public (District) 250005801272 4890505 Sturgis Charter Public School   Regular School Yes 3 09 12 2015   grade_9 177 4 5 0   3     0   11   78 122                       200 177 4 5 0   3     0   11   78 122                 200
744201 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No 3 08 12 2015   grade_9 157 15 20 1   8     0   10   113 98                       211 157 15 20 1   8     0   10   113 98                 211
744262 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No 3 09 12 2015   grade_9 189 8 8 1   7     1   3   107 110                       217 189 8 8 1   7     1   3   107 110                 217
744510 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No 3 08 12 2015   grade_9 100 14 9 1   4     0   7   71 64                       135 100 14 9 1   4     0   7   71 64                 135
745043 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 128 4 18 0   1     0   11   100 62                       162 128 4 18 0   1     0   11   100 62                 162
745127 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 168 3 6 1   7     0   7   114 78                       192 168 3 6 1   7     0   7   114 78                 192
739036 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2015   grade_9 50 0 3 0   0     0   1   28 26                       54 50 0 3 0   0     0   1   28 26                 54
739064 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2015   grade_9 56 0 3 0   4     0   1   33 31                       64 56 0 3 0   4     0   1   33 31                 64
740453 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No 3 08 12 2015   grade_9 65 2 5 0   0     0   6   37 41                       78 65 2 5 0   0     0   6   37 41                 78
740948 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_9 146 32 24 0   4     0   15   120 101                       221 146 32 24 0   4     0   15   120 101                 221
740952 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2015   grade_9 145 18 15 0   2     0   13   91 102                       193 145 18 15 0   2     0   13   91 102                 193
743443 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public School   Regular School Yes 4 06 12 2015   grade_9 43 7 4 0   2     1   0   22 35                       57 43 7 4 0   2     1   0   22 35                 57
743987 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No 4 06 12 2015   grade_9 73 4 1 0   0     0   1   38 41                       79 73 4 1 0   0     0   1   38 41                 79
744077 MA Berkshire   school 2502530 618   Berkshire Hills 250253000154 6180505 Monument Mt Regional High   Regular School No 3 09 12 2015   grade_9 110 0 8 0   4     0   3   63 62                       125 110 0 8 0   4     0   3   63 62                 125
744173 MA Berkshire   school 2503390 635   Central Berkshire 250339000467 6350505 Wahconah Regional High   Regular School No 3 09 12 2015   grade_9 115 2 3 0   1     0   4   57 68                       125 115 2 3 0   1     0   4   57 68                 125
744517 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2015   grade_9 85 2 2 0   0     0   2   40 51                       91 85 2 2 0   0     0   2   40 51                 91
744804 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No 3 07 12 2015   grade_9 47 0 3 0   0     0   0   25 25                       50 47 0 3 0   0     0   0   25 25                 50
745085 MA Berkshire   school 2508950 851   Northern Berkshire Regional Vocational Technical 250895002282 8510605 Charles McCann Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 115 1 2 1   0     0   3   75 47                       122 115 1 2 1   0     0   3   75 47                 122
735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
737731 MA Bristol   school 2504020 72   Dartmouth 250402000540 720505 Dartmouth High   Regular School No 3 09 12 2015   grade_9 228 5 2 0   11     0   4   127 123                       250 228 5 2 0   11     0   4   127 123                 250
737927 MA Bristol   school 2504620 88   Easton 250462000623 880505 Oliver Ames High   Regular School No 3 09 12 2015   grade_9 265 13 14 1   11     0   11   148 167                       315 265 13 14 1   11     0   11   148 167                 315
738028 MA Bristol   school 2504800 94   Fairhaven 250480000642 940505 Fairhaven High   Regular School No 3 09 12 2015   grade_9 141 1 14 0   2     0   4   84 78                       162 141 1 14 0   2     0   4   84 78                 162
738114 MA Bristol   school 2504830 95   Fall River 250483002660 950325 Resiliency Preparatory School   Regular School No 3 09 12 2015   grade_9 40 10 14 0   1     0   3   46 22                       68 40 10 14 0   1     0   3   46 22                 68
738123 MA Bristol   school 2504830 95   Fall River 250483000649 950505 B M C Durfee High   Regular School No 3 09 12 2015   grade_9 376 59 148 1   36     2   19   344 297                       641 376 59 148 1   36     2   19   344 297                 641
739620 MA Bristol   school 2507230 167   Mansfield 250723001114 1670505 Mansfield High   Regular School No 3 09 12 2015   grade_9 269 14 13 1   10     0   7   148 166                       314 269 14 13 1   10     0   7   148 166                 314
740275 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford High   Regular School No 3 09 12 2015   grade_9 213 54 248 8   3     4   27   322 235                       557 213 54 248 8   3     4   27   322 235                 557
740281 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No 3 07 12 2015   grade_9 7 0 3 0   0     0   0   9 1                       10 7 0 3 0   0     0   0   9 1                 10
740288 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No 4 06 12 2015   grade_9 6 6 9 0   0     0   4   22 3                       25 6 6 9 0   0     0   4   22 3                 25
740567 MA Bristol   school 2508730 212   North Attleborough 250873001405 2120505 North Attleboro High   Regular School No 3 09 12 2015   grade_9 270 7 16 2   18     0   4   140 177                       317 270 7 16 2   18     0   4   140 177                 317
740669 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2015   grade_9 186 4 2 0   3     0   0   99 96                       195 186 4 2 0   3     0   0   99 96                 195
741509 MA Bristol   school 2510590 265   Seekonk 251059001699 2650505 Seekonk High   Regular School No 3 09 12 2015   grade_9 125 1 4 0   2     0   1   59 74                       133 125 1 4 0   2     0   1   59 74                 133
742199 MA Bristol   school 2511460 292   Swansea 251146001893 2920505 Joseph Case High   Regular School No 3 09 12 2015   grade_9 121 2 3 0   1     0   3   70 60                       130 121 2 3 0   1     0   3   70 60                 130
742249 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No 3 08 12 2015   grade_9 352 66 41 0   7     0   17   256 227                       483 352 66 41 0   7     0   17   256 227                 483
742254 MA Bristol   school 2511520 293   Taunton 251152002778 2930525 Taunton Alternative High School   Alternative Education School No 3 08 12 2015   grade_9 2 3 1 0   0     0   1   6 1                       7 2 3 1 0   0     0   1   6 1                 7
742796 MA Bristol   school 2512780 331   Westport 251278002093 3310505 Westport High   Regular School No 3 08 12 2015   grade_9 68 1 1 0   0     0   1   39 32                       71 68 1 1 0   0     0   1   39 32                 71
743875 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 09 2015   grade_9 35 4 6 0   0     0   2   18 29                       47 35 4 6 0   0     0   2   18 29                 47
743896 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public School   Regular School Yes 4 05 12 2015   grade_9 33 4 7 1   1     0   6   26 26                       52 33 4 7 1   1     0   6   26 26                 52
744129 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303000380 6250505 Bridgewater-Raynham Regional   Regular School No 3 09 12 2015   grade_9 296 15 19 0   7     0   15   161 191                       352 296 15 19 0   7     0   15   161 191                 352
744224 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No 3 09 12 2015   grade_9 198 2 11 0   1     0   6   121 97                       218 198 2 11 0   1     0   6   121 97                 218
744290 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No 3 09 12 2015   grade_9 180 2 2 0   4     0   1   98 91                       189 180 2 2 0   4     0   1   98 91                 189
744781 MA Bristol   school 2500541 763   Somerset Berkley Regional School District 250054102728 7630505 Somerset Berkley Regional High School   Regular School No 3 09 12 2015   grade_9 194 2 5 0   4     0   3   88 120                       208 194 2 5 0   4     0   3   88 120                 208
745039 MA Bristol   school 2503080 810   Bristol-Plymouth Regional Vocational Technical 250308002262 8100605 Bristol-Plymouth Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 298 11 22 2   4     0   12   196 153                       349 298 11 22 2   4     0   12   196 153                 349
745056 MA Bristol   school 2505485 821   Greater Fall River Regional Vocational Technical 250548502269 8210605 Diman Regional Vocational Technical High   Vocational Education School No 3 09 12 2015   grade_9 311 2 23 1   7     0   19   228 135                       363 311 2 23 1   7     0   19   228 135                 363
745064 MA Bristol   school 2508440 825   Greater New Bedford Regional Vocational Technical 250844002266 8250605 Gr New Bedford Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 373 48 125 0   4     0   18   295 273                       568 373 48 125 0   4     0   18   295 273                 568
745097 MA Bristol   school 2509140 855   Old Colony Regional Vocational Technical 250914001471 8550605 Old Colony Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 141 1 0 0   2     0   0   91 53                       144 141 1 0 0   2     0   0   91 53                 144
745110 MA Bristol   school 2511020 872   Southeastern Regional Vocational Technical 251102002290 8720605 Southeastern Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 193 129 42 0   5     0   11   196 184                       380 193 129 42 0   5     0   11   196 184                 380
745135 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2015   grade_9 122 0 2 0   0     0   2   38 88                       126 122 0 2 0   0     0   2   38 88                 126
745168 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 4 09 09 2015   grade_9 27 15 33 1   1     0   11   41 47                       88 27 15 33 1   1     0   11   41 47                 88
743723 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes 4 KG 12 2015   grade_9 6 1 1 0   1     0   0   6 3                       9 6 1 1 0   1     0   0   6 3                 9
744461 MA Dukes   school 2507380 700   Martha's Vineyard 250738001145 7000505 Martha's Vineyard Regional High   Regular School No 3 09 12 2015   grade_9 139 5 13 4   4     0   13   92 86                       178 139 5 13 4   4     0   13   92 86                 178
735730 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_9 147 0 8 0   1     0   4   91 69                       160 147 0 8 0   1     0   4   91 69                 160
735801 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_9 321 7 23 0   61     0   8   199 221                       420 321 7 23 0   61     0   8   199 221                 420
736115 MA Essex   school 2502640 30   Beverly 250264000164 300505 Beverly High   Regular School No 3 09 12 2015   grade_9 297 8 30 0   5     0   11   170 181                       351 297 8 30 0   5     0   11   170 181                 351
737704 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No 3 09 12 2015   grade_9 209 7 10 0   3     1   4   120 114                       234 209 7 10 0   3     1   4   120 114                 234
738383 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2015   grade_9 105 3 1 0   2     0   2   63 50                       113 105 3 1 0   2     0   2   63 50                 113
738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
738606 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 02 12 2015   grade_9 * * * *   *     *   *   2 1                       3                         2 1                 3
738631 MA Essex   school 2505970 128   Haverhill 250597000856 1280505 Haverhill High   Regular School No 3 09 12 2015   grade_9 314 10 110 0   6     0   3   234 209                       443 314 10 110 0   6     0   3   234 209                 443
738867 MA Essex   school 2506480 144   Ipswich 250648000935 1440505 Ipswich High   Regular School No 3 09 12 2015   grade_9 114 1 4 0   3     0   2   68 56                       124 114 1 4 0   3     0   2   68 56                 124
738979 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_9 10 3 133 0   1     0   0   101 46                       147 10 3 133 0   1     0   0   101 46                 147
738983 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2015   grade_9 5 2 151 0   3     0   0   53 108                       161 5 2 151 0   3     0   0   53 108                 161
738987 MA Essex   school 2506660 149   Lawrence 250666002633 1490532 Humanities & Leadership Development High School   Regular School No 3 09 12 2015   grade_9 5 3 164 0   3     0   0   99 76                       175 5 3 164 0   3     0   0   99 76                 175
738992 MA Essex   school 2506660 149   Lawrence 250666002618 1490533 Math, Science & Technology High School   Regular School No 3 09 12 2015   grade_9 13 2 137 0   8     0   1   118 43                       161 13 2 137 0   8     0   1   118 43                 161
738996 MA Essex   school 2506660 149   Lawrence 250666002631 1490534 International High School   Regular School No 3 09 12 2015   grade_9 2 1 124 0   0     0   0   69 58                       127 2 1 124 0   0     0   0   69 58                 127
739000 MA Essex   school 2506660 149   Lawrence 250666002616 1490535 Performing & Fine Arts High School   Regular School No 3 09 12 2015   grade_9 6 3 114 0   0     0   0   44 79                       123 6 3 114 0   0     0   0   44 79                 123
739005 MA Essex   school 2506660 149   Lawrence 250666002628 1490536 High School Learning Center   Regular School No 3 09 12 2015   grade_9 1 0 15 0   0     0   0   8 8                       16 1 0 15 0   0     0   0   8 8                 16
739017 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2015   grade_9 0 1 19 0   0     0   0   18 2                       20 0 1 19 0   0     0   0   18 2                 20
739022 MA Essex   school 2506660 149   Lawrence 250666002749 1490540 Phoenix Academy Lawrence   Alternative Education School No 3 09 12 2015   grade_9 4 4 86 0   2     0   0   53 43                       96 4 4 86 0   2     0   0   53 43                 96
739517 MA Essex   school 2507110 163   Lynn 250711001067 1630505 Classical High   Regular School No 3 09 12 2015   grade_9 92 55 293 1   55     0   12   266 242                       508 92 55 293 1   55     0   12   266 242                 508
739522 MA Essex   school 2507110 163   Lynn 250711001080 1630510 Lynn English High   Regular School No 3 09 12 2015   grade_9 93 52 313 0   25     0   23   293 213                       506 93 52 313 0   25     0   23   293 213                 506
739529 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2015   grade_9 6 6 17 0   4     0   2   18 17                       35 6 6 17 0   4     0   2   18 17                 35
739536 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Vocational Education School No 3 07 12 2015   grade_9 30 28 167 1   9     0   6   149 92                       241 30 28 167 1   9     0   6   149 92                 241
739556 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No 3 09 12 2015   grade_9 141 3 6 0   4     0   2   72 84                       156 141 3 6 0   4     0   2   72 84                 156
739644 MA Essex   school 2507260 168   Marblehead 250726001124 1680505 Marblehead High   Regular School No 3 09 12 2015   grade_9 216 17 15 0   1     0   2   111 140                       251 216 17 15 0   1     0   2   111 140                 251
739910 MA Essex   school 2507740 181   Methuen 250774001213 1810505 Methuen High   Regular School No 3 09 12 2015   grade_9 282 16 154 1   22     0   3   255 223                       478 282 16 154 1   22     0   3   255 223                 478
740301 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2015   grade_9 177 2 8 0   1     0   7   94 101                       195 177 2 8 0   1     0   7   94 101                 195
740524 MA Essex   school 2508700 211   North Andover 250870001397 2110505 North Andover High   Regular School No 3 09 12 2015   grade_9 300 11 23 3   28     1   3   180 189                       369 300 11 23 3   28     1   3   180 189                 369
740843 MA Essex   school 2509360 229   Peabody 250936001504 2290510 Peabody Veterans Memorial High   Regular School No 3 09 12 2015   grade_9 278 16 70 0   10     0   10   189 195                       384 278 16 70 0   10     0   10   189 195                 384
741319 MA Essex   school 2510200 252   Rockport 251020002597 2520510 Rockport High   Regular School No 3 09 12 2015   grade_9 61 1 3 0   0     0   3   34 34                       68 61 1 3 0   0     0   3   34 34                 68
741382 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No 3 09 12 2015   grade_9 105 20 108 1   8     0   12   133 121                       254 105 20 108 1   8     0   12   133 121                 254
741445 MA Essex   school 2510500 262   Saugus 251050001684 2620505 Saugus High   Regular School No 3 09 12 2015   grade_9 113 3 19 1   10     1   2   68 81                       149 113 3 19 1   10     1   2   68 81                 149
742179 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No 3 09 12 2015   grade_9 131 7 18 0   4     2   1   81 82                       163 131 7 18 0   4     2   1   81 82                 163
743447 MA Essex   school 2500069 415   Amesbury Academy Charter Public (District) 250006901666 4150505 Amesbury Academy Charter Public School   Regular School Yes 3 09 12 2015   grade_9 8 0 0 0   0     0   1   6 3                       9 8 0 0 0   0     0   1   6 3                 9
743502 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2015   grade_9 10 28 69 0   2     0   3   61 51                       112 10 28 69 0   2     0   3   61 51                 112
743823 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter School   Regular School Yes 4 06 12 2015   grade_9 22 5 24 0   2     0   0   31 22                       53 22 5 24 0   2     0   0   31 22                 53
743882 MA Essex   school 2500090 493   Phoenix Charter Academy (District) 250009002112 4930505 Phoenix Charter Academy   Regular School Yes 3 09 12 2015   grade_9 9 14 67 0   0     0   0   50 40                       90 9 14 67 0   0     0   0   50 40                 90
744386 MA Essex   school 2505670 675   Hamilton-Wenham 250567000820 6750505 Hamilton-Wenham Regional High   Regular School No 3 09 12 2015   grade_9 127 0 3 0   6     0   4   76 64                       140 127 0 3 0   6     0   4   76 64                 140
744457 MA Essex   school 2500067 698   Manchester Essex Regional 250006701109 6980510 Manchester Essex Regional High School   Regular School No 3 09 12 2015   grade_9 101 0 0 0   0     0   0   49 52                       101 101 0 0 0   0     0   0   49 52                 101
744468 MA Essex   school 2507410 705   Masconomet 250741001146 7050505 Masconomet Regional High School   Regular School No 3 09 12 2015   grade_9 274 1 10 0   11     0   2   145 153                       298 274 1 10 0   11     0   2   145 153                 298
744687 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2015   grade_9 181 0 2 0   5     0   4   88 104                       192 181 0 2 0   5     0   4   88 104                 192
744891 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2015   grade_9 183 0 1 0   6     0   0   88 102                       190 183 0 1 0   6     0   0   88 102                 190
745048 MA Essex   school 2500554 817   Essex North Shore Agricultural and Technical School District 250055402833 8170505 Essex Technical High School   Vocational Education School No 3 09 12 2015   grade_9 300 7 40 0   3     1   8   145 214                       359 300 7 40 0   3     1   8   145 214                 359
745060 MA Essex   school 2505470 823   Greater Lawrence Regional Vocational Technical 250547002267 8230605 Gr Lawrence Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 55 4 295 0   4     0   0   184 174                       358 55 4 295 0   4     0   0   184 174                 358
745131 MA Essex   school 2512950 885   Whittier Regional Vocational Technical 251295002300 8850605 Whittier Regional Vocational   Vocational Education School No 3 09 12 2015   grade_9 259 5 49 0   3     0   11   183 144                       327 259 5 49 0   3     0   11   183 144                 327
738486 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_9 68 1 20 0   2     0   1   42 50                       92 68 1 20 0   2     0   1   42 50                 92

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