enrollments

Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 490 ✖

grade ✖

  • grade_8 · 490 ✖
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
1122325 1122325 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_8 279 26 54 1   2     2   13   204 173                       377 279 26 54 1   2     2   13   204 173                 377
1123477 1123477 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 05 08 2017   grade_8 162 4 7 1   5     0   12   104 87                       191 162 4 7 1   5     0   12   104 87                 191
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1126737 1126737 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_8 120 7 6 9   3     0   3   68 80                       148 120 7 6 9   3     0   3   68 80                 148
1128280 1128280 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_8 9 1 4 0   0     0   3   11 6                       17 9 1 4 0   0     0   3   11 6                 17
1128701 1128701 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2017   grade_8 223 2 2 3   9     1   1   121 120                       241 223 2 2 3   9     1   1   121 120                 241
1131240 1131240 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2017   grade_8 70 0 5 0   1     0   4   32 48                       80 70 0 5 0   1     0   4   32 48                 80
1132003 1132003 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_8 154 20 21 8   4     1   13   125 96                       221 154 20 21 8   4     1   13   125 96                 221
1132079 1132079 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset Regional Middle   Regular School No Middle 06 08 2017   grade_8 167 6 11 2   4     0   3   89 104                       193 167 6 11 2   4     0   3   89 104                 193
1132370 1132370 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_8 109 9 5 1   0     0   6   58 72                       130 109 9 5 1   0     0   6   58 72                 130
1124215 1124215 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_8 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
1125906 1125906 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_8 57 0 1 0   1     0   0   25 34                       59 57 0 1 0   1     0   0   25 34                 59
1125940 1125940 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_8 54 0 5 0   7     0   3   37 32                       69 54 0 5 0   7     0   3   37 32                 69
1127589 1127589 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   grade_8 84 2 5 0   0     1   11   55 48                       103 84 2 5 0   0     1   11   55 48                 103
1128161 1128161 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2017   grade_8 117 24 21 0   1     0   16   86 93                       179 117 24 21 0   1     0   16   86 93                 179
1128165 1128165 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Theodore Herberg Middle   Regular School No Middle 06 08 2017   grade_8 148 24 24 1   6     0   7   111 99                       210 148 24 24 1   6     0   7   111 99                 210
1128556 1128556 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2017   grade_8 5 1 1 0   0     0   1   2 6                       8 5 1 1 0   0     0   1   2 6                 8
1131143 1131143 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_8 50 14 2 0   0     0   1   35 31                       67 50 14 2 0   0     0   1   35 31                 67
1131759 1131759 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_8 86 8 0 0   2     0   0   55 41                       96 86 8 0 0   2     0   0   55 41                 96
1131858 1131858 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_8 87 2 7 0   3     2   3   52 52                       104 87 2 7 0   3     2   3   52 52                 104
1131968 1131968 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_8 136 1 6 1   2     0   5   79 72                       151 136 1 6 1   2     0   5   79 72                 151
1132377 1132377 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_8 83 3 7 0   2     0   8   51 52                       103 83 3 7 0   2     0   8   51 52                 103
1132714 1132714 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 07 12 2017   grade_8 43 1 3 0   0     0   5   28 24                       52 43 1 3 0   0     0   5   28 24                 52
1121975 1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1122238 1122238 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_8 136 6 12 0   5     0   4   81 82                       163 136 6 12 0   5     0   4   81 82                 163
1122243 1122243 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_8 91 8 21 0   9     2   12   82 61                       143 91 8 21 0   9     2   12   82 61                 143
1122248 1122248 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_8 87 10 31 0   11     0   8   72 75                       147 87 10 31 0   11     0   8   72 75                 147
1122440 1122440 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_8 93 1 1 0   1     0   3   44 55                       99 93 1 1 0   1     0   3   44 55                 99
1124358 1124358 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_8 304 5 6 0   2     0   14   155 176                       331 304 5 6 0   2     0   14   155 176                 331
1124589 1124589 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_8 248 17 13 0   10     0   5   135 158                       293 248 17 13 0   10     0   5   135 158                 293
1124706 1124706 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2017   grade_8 137 1 6 2   5     0   1   84 68                       152 137 1 6 2   5     0   1   84 68                 152
1124752 1124752 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_8 42 5 10 0   4     0   5   33 33                       66 42 5 10 0   4     0   5   33 33                 66
1124763 1124763 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_8 26 2 20 0   3     0   2   30 23                       53 26 2 20 0   3     0   2   30 23                 53
1124796 1124796 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_8 103 10 59 0   12     0   6   88 102                       190 103 10 59 0   12     0   6   88 102                 190
1124800 1124800 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_8 125 16 40 0   8     1   14   113 91                       204 125 16 40 0   8     1   14   113 91                 204
1124804 1124804 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_8 154 11 43 0   8     0   11   119 108                       227 154 11 43 0   8     0   11   119 108                 227
1124812 1124812 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No Middle 06 08 2017   grade_8 7 3 8 0   0     0   1   9 10                       19 7 3 8 0   0     0   1   9 10                 19
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1126610 1126610 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2017   grade_8 313 15 14 0   21     0   13   191 185                       376 313 15 14 0   21     0   13   191 185                 376
1127374 1127374 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 Keith Middle School   Regular School No Middle 06 08 2017   grade_8 113 48 102 3   4     2   21   146 147                       293 113 48 102 3   4     2   21   146 147                 293
1127378 1127378 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 Normandin Middle School   Regular School No Middle 06 08 2017   grade_8 188 19 104 4   2     2   10   181 148                       329 188 19 104 4   2     2   10   181 148                 329
1127382 1127382 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2017   grade_8 101 34 113 1   1     0   17   138 129                       267 101 34 113 1   1     0   17   138 129                 267
1127394 1127394 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No Other 06 12 2017   grade_8 3 3 8 0   0     0   1   11 4                       15 3 3 8 0   0     0   1   11 4                 15
1127718 1127718 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough Middle   Regular School No Middle 06 08 2017   grade_8 308 9 12 0   19     0   11   189 170                       359 308 9 12 0   19     0   11   189 170                 359
1127839 1127839 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2017   grade_8 192 3 4 0   6     1   3   114 95                       209 192 3 4 0   6     1   3   114 95                 209
1128813 1128813 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2017   grade_8 161 0 9 0   4     0   2   88 87                       176 161 0 9 0   4     0   2   88 87                 176
1128931 1128931 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset Middle School   Regular School No Middle 06 08 2017   grade_8 198 2 7 1   0     0   8   115 101                       216 198 2 7 1   0     0   8   115 101                 216
1129638 1129638 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2017   grade_8 155 1 3 0   3     0   6   88 80                       168 155 1 3 0   3     0   6   88 80                 168
1129701 1129701 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_8 435 90 90 1   5     0   23   319 325                       644 435 90 90 1   5     0   23   319 325                 644
1130354 1130354 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_8 126 1 3 2   2     0   4   79 59                       138 126 1 3 2   2     0   4   79 59                 138
1131621 1131621 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_8 86 4 5 0   3     0   1   48 51                       99 86 4 5 0   3     0   1   48 51                 99
1131651 1131651 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_8 33 9 30 0   1     0   4   37 40                       77 33 9 30 0   1     0   4   37 40                 77
1131918 1131918 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2017   grade_8 167 5 5 0   6     0   6   90 99                       189 167 5 5 0   6     0   6   90 99                 189
1132024 1132024 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_8 111 1 5 0   0     0   2   66 53                       119 111 1 5 0   0     0   2   66 53                 119
1132029 1132029 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_8 123 2 6 0   0     0   5   77 59                       136 123 2 6 0   0     0   5   77 59                 136
1132111 1132111 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 08 2017   grade_8 249 1 2 0   3     0   3   131 127                       258 249 1 2 0   3     0   3   131 127                 258
1133165 1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1124605 1124605 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_8 34 1 4 1   0     0   0   15 25                       40 34 1 4 1   0     0   0   15 25                 40
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1127922 1127922 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs Elementary   Regular School No Elementary PK 08 2017   grade_8 33 3 7 1   1     0   3   24 24                       48 33 3 7 1   1     0   3   24 24                 48
1129747 1129747 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_8 24 1 7 1   1     0   2   17 19                       36 24 1 7 1   1     0   2   17 19                 36
1131457 1131457 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_8 11 0 1 0   2     0   1   12 3                       15 11 0 1 0   2     0   1   12 3                 15
1132833 1132833 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2017   grade_8 15 2 2 1   0     0   0   8 12                       20 15 2 2 1   0     0   0   8 12                 20
1122033 1122033 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_8 142 4 11 1   2     0   10   91 79                       170 142 4 11 1   2     0   10   91 79                 170
1122109 1122109 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_8 147 2 9 0   26     0   5   86 103                       189 147 2 9 0   26     0   5   86 103                 189
1122113 1122113 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_8 138 2 6 0   29     0   3   86 92                       178 138 2 6 0   29     0   3   86 92                 178
1122117 1122117 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_8 99 7 7 0   40     0   3   66 90                       156 99 7 7 0   40     0   3   66 90                 156
1122489 1122489 MA Essex   school 2502640 30   Beverly 250264000165 300305 Briscoe Middle   Regular School No Middle 06 08 2017   grade_8 262 10 37 0   10     0   9   170 158                       328 262 10 37 0   10     0   9   170 158                 328
1124326 1124326 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2017   grade_8 244 3 24 0   4     0   9   147 137                       284 244 3 24 0   4     0   9   147 137                 284
1125132 1125132 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_8 112 0 0 0   1     0   1   59 55                       114 112 0 0 0   1     0   1   59 55                 114
1125178 1125178 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_8 157 2 23 1   0     1   4   85 103                       188 157 2 23 1   0     1   4   85 103                 188
1125399 1125399 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2017   grade_8 5 0 4 0   0     0   0   7 2                       9 5 0 4 0   0     0   0   7 2                 9
1125407 1125407 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_8 96 4 26 0   3     0   1   68 62                       130 96 4 26 0   3     0   1   68 62                 130
1125414 1125414 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_8 80 2 50 0   2     0   0   65 69                       134 80 2 50 0   2     0   0   65 69                 134
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1125441 1125441 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_8 92 2 33 0   1     0   1   74 55                       129 92 2 33 0   1     0   1   74 55                 129
1125450 1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1125730 1125730 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2017   grade_8 146 1 5 0   4     0   4   81 79                       160 146 1 5 0   4     0   4   81 79                 160
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1125788 1125788 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_8 2 1 143 0   0     0   0   73 73                       146 2 1 143 0   0     0   0   73 73                 146
1125809 1125809 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_8 2 2 119 0   4     0   2   62 67                       129 2 2 119 0   4     0   2   62 67                 129
1125814 1125814 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_8 11 0 113 0   1     0   1   70 56                       126 11 0 113 0   1     0   1   70 56                 126
1125831 1125831 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_8 1 1 100 0   1     0   0   49 54                       103 1 1 100 0   1     0   0   49 54                 103
1125853 1125853 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_8 4 0 87 0   4     0   1   52 44                       96 4 0 87 0   4     0   1   52 44                 96
1125857 1125857 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2017   grade_8 8 0 147 0   5     0   0   75 85                       160 8 0 147 0   5     0   0   75 85                 160
1125861 1125861 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_8 2 2 113 0   0     0   0   61 56                       117 2 2 113 0   0     0   0   61 56                 117
1125871 1125871 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_8 14 2 94 0   7     0   1   63 55                       118 14 2 94 0   7     0   1   63 55                 118
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
1126483 1126483 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_8 38 33 243 0   31     0   8   197 156                       353 38 33 243 0   31     0   8   197 156                 353
1126487 1126487 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_8 52 42 252 1   39     0   11   219 178                       397 52 42 252 1   39     0   11   219 178                 397
1126491 1126491 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2017   grade_8 89 11 77 1   21     0   8   117 90                       207 89 11 77 1   21     0   8   117 90                 207
1126504 1126504 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_8 11 0 6 0   0     0   0   10 7                       17 11 0 6 0   0     0   0   10 7                 17
1126534 1126534 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_8 170 1 7 0   7     0   5   89 101                       190 170 1 7 0   7     0   5   89 101                 190
1126639 1126639 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2017   grade_8 222 6 16 0   5     0   8   121 136                       257 222 6 16 0   5     0   8   121 136                 257
1126923 1126923 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_8 103 0 29 0   3     0   6   69 72                       141 103 0 29 0   3     0   6   69 72                 141
1126934 1126934 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_8 83 0 48 0   7     0   5   72 71                       143 83 0 48 0   7     0   5   72 71                 143
1126945 1126945 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_8 61 0 56 0   11     0   7   70 65                       135 61 0 56 0   11     0   7   70 65                 135
1126956 1126956 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No Elementary PK 08 2017   grade_8 72 0 67 1   3     0   8   83 68                       151 72 0 67 1   3     0   8   83 68                 151
1127411 1127411 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2017   grade_8 180 0 2 0   5     0   4   97 94                       191 180 0 2 0   5     0   4   97 94                 191
1127672 1127672 MA Essex   school 2508700 211   North Andover 250870001398 2110305 North Andover Middle   Regular School No Middle 06 08 2017   grade_8 329 11 37 1   32     0   6   218 198                       416 329 11 37 1   32     0   6   218 198                 416

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