enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_8", state = "MA" and year = 2018 sorted by female

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_8 · 495 ✖
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
2230211 2230211 MA Suffolk   school   35   Boston   350652               2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2231645 2231645 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2232023 2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2233070 2233070 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2234771 2234771 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_8 * * * *   *     *   *   1 *                       1.0                         1                   1
2235830 2235830 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville: Next Wave Junior High   Alternative School No Middle 06 08 2018   grade_8 2 0 5 0   0     0   0   6 *                       7.0 2 0 5 0   0     0   0   6                   7
2237229 2237229 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_8 * * * *   *     *   *   * *                       0.0                                             0
2229452 2229452 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2230470 2230470 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Brockton: Frederick Douglass Academy   Regular School No Secondary 07 11 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2232241 2232241 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2232701 2232701 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_8 1 1 8 0   0     0   0   9 1                       10.0 1 1 8 0   0     0   0   9 1                 10
2238754 2238754 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham: Therapeutic Day School   Special Education School No High 07 12 2018   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2238832 2238832 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_8 * * * *   *     *   *   3 1                       4.0                         3 1                 4
2238104 2238104 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_8 0 15 4 0   0     0   1   10 10                       20.0 0 15 4 0   0     0   1   10 10                 20
2238130 2238130 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_8 2 0 19 0   1     0   0   12 10                       22.0 2 0 19 0   1     0   0   12 10                 22
2230295 2230295 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_8 176 5 3 3   6     0   0   93 100                       193.0 176 5 3 3   6     0   0   93 100                 193
2231779 2231779 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_8 184 9 18 2   6     0   4   123 100                       223.0 184 9 18 2   6     0   4   123 100                 223
2232266 2232266 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_8 91 9 101 0   3     0   0   104 100                       204.0 91 9 101 0   3     0   0   104 100                 204
2237114 2237114 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_8 144 3 2 1   65     1   2   118 100                       218.0 144 3 2 1   65     1   2   118 100                 218
2231010 2231010 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_8 128 11 101 0   1     0   6   145 102                       247.0 128 11 101 0   1     0   6   145 102                 247
2234361 2234361 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton: Oak Hill Middle   Regular School No Middle 06 08 2018   grade_8 115 11 10 0   39     0   19   92 102                       194.0 115 11 10 0   39     0   19   92 102                 194
2239625 2239625 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton: Triton Regional Middle School   Regular School No Middle 07 08 2018   grade_8 183 3 7 0   4     1   4   100 102                       202.0 183 3 7 0   4     1   4   100 102                 202
2233311 2233311 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_8 79 11 77 2   15     0   15   96 103                       199.0 79 11 77 2   15     0   15   96 103                 199
2238752 2238752 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham: Bridgewater Middle School   Regular School No Middle 07 08 2018   grade_8 236 5 0 0   3     1   10   152 103                       255.0 236 5 0 0   3     1   10   152 103                 255
2234577 2234577 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Northborough: Robert E. Melican Middle School   Regular School No Middle 06 08 2018   grade_8 180 3 5 1   22     3   7   117 104                       221.0 180 3 5 1   22     3   7   117 104                 221
2234685 2234685 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell: Norwell Middle School   Regular School No Middle 06 08 2018   grade_8 155 2 3 0   5     0   2   63 104                       167.0 155 2 3 0   5     0   2   63 104                 167
2230495 2230495 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton: North Middle School   Regular School No Middle 06 08 2018   grade_8 20 164 23 0   3     2   4   111 105                       216.0 20 164 23 0   3     2   4   111 105                 216
2236175 2236175 MA Hampden   school 2511130 281   Springfield 251113002602 2810330 Springfield: M Marcus Kiley Middle   Regular School No Middle 06 08 2018   grade_8 26 53 143 0   6     0   2   125 105                       230.0 26 53 143 0   6     0   2   125 105                 230
2239481 2239481 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin: Quabbin Regional Middle School   Regular School No Middle 07 08 2018   grade_8 203 0 14 0   1     0   4   117 105                       222.0 203 0 14 0   1     0   4   117 105                 222
2234983 2234983 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield: John T Reid Middle   Regular School No Middle 06 08 2018   grade_8 134 19 24 1   0     0   15   87 106                       193.0 134 19 24 1   0     0   15   87 106                 193
2235244 2235244 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph: Randolph Community Middle   Regular School No Middle 06 08 2018   grade_8 38 107 28 0   32     1   14   114 106                       220.0 38 107 28 0   32     1   14   114 106                 220
2229079 2229079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_8 184 3 14 0   5     0   10   109 107                       216.0 184 3 14 0   5     0   10   109 107                 216
2229147 2229147 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford: John Glenn Middle   Regular School No Middle 06 08 2018   grade_8 145 14 9 0   39     0   6   106 107                       213.0 145 14 9 0   39     0   6   106 107                 213
2234449 2234449 MA Hampshire   school 2508850 210   Northampton 250885001430 2100410 Northampton: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_8 165 3 25 1   8     0   14   109 107                       216.0 165 3 25 1   8     0   14   109 107                 216
2236331 2236331 MA Norfolk   school 2511250 285   Stoughton 251125001865 2850405 Stoughton: O'Donnell Middle School   Regular School No Middle 06 08 2018   grade_8 139 53 19 0   13     1   17   135 107                       242.0 139 53 19 0   13     1   17   135 107                 242
2238597 2238597 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000043 6050405 Amherst-Pelham: Amherst Regional Middle School   Regular School No Middle 07 08 2018   grade_8 142 14 29 0   17     1   13   109 107                       216.0 142 14 29 0   17     1   13   109 107                 216
2235523 2235523 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_8 216 2 1 2   4     1   0   118 108                       226.0 216 2 1 2   4     1   0   118 108                 226
2236194 2236194 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Springfield: Chestnut Academy   Regular School No Middle 06 08 2018   grade_8 9 26 190 1   1     0   2   121 108                       229.0 9 26 190 1   1     0   2   121 108                 229
2237070 2237070 MA Hampden   school 2512630 325   Westfield 251263001569 3250305 Westfield: North Middle School   Regular School No Middle 06 08 2018   grade_8 184 5 32 0   6     1   4   124 108                       232.0 184 5 32 0   6     1   4   124 108                 232
2238998 2238998 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable: Groton Dunstable Regional Middle   Regular School No Middle 05 08 2018   grade_8 174 1 4 0   20     0   4   95 108                       203.0 174 1 4 0   20     0   4   95 108                 203
2230883 2230883 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_8 159 8 9 0   30     1   5   103 109                       212.0 159 8 9 0   30     1   5   103 109                 212
2231378 2231378 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow: Birchland Park   Regular School No Middle 06 08 2018   grade_8 187 6 19 0   17     0   1   121 109                       230.0 187 6 19 0   17     0   1   121 109                 230
2234660 2234660 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton: Norton Middle   Regular School No Middle 06 08 2018   grade_8 191 6 6 0   3     0   5   102 109                       211.0 191 6 6 0   3     0   5   102 109                 211
2229407 2229407 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston: Boston Teachers Union School   Regular School No Elementary PK 08 2018   grade_8 1 12 21 0   1     0   4   28 11                       39.0 1 12 21 0   1     0   4   28 11                 39
2229927 2229927 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_8 7 5 15 0   1     0   0   17 11                       28.0 7 5 15 0   1     0   0   17 11                 28
2230026 2230026 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston: Young Achievers   Alternative School No Elementary PK 08 2018   grade_8 1 15 17 0   0     0   1   23 11                       34.0 1 15 17 0   0     0   1   23 11                 34
2231422 2231422 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_8 29 1 6 0   0     0   0   25 11                       36.0 29 1 6 0   0     0   0   25 11                 36
2229348 2229348 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica: Marshall Middle School   Regular School No Middle 06 08 2018   grade_8 187 10 7 1   10     0   2   107 110                       217.0 187 10 7 1   10     0   2   107 110                 217
2236429 2236429 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott: Swampscott Middle   Regular School No Middle 05 08 2018   grade_8 161 7 23 0   8     0   3   92 110                       202.0 161 7 23 0   8     0   3   92 110                 202
2229002 2229002 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_8 148 5 22 0   27     0   6   97 111                       208.0 148 5 22 0   27     0   6   97 111                 208
2231320 2231320 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater: East Bridgewater JR./SR. High School   Regular School No High 07 12 2018   grade_8 194 3 3 1   1     0   2   92 112                       204.0 194 3 3 1   1     0   2   92 112                 204
2232506 2232506 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson: Hudson High   Regular School No High 08 12 2018   grade_8 176 6 20 0   0     1   6   97 112                       209.0 176 6 20 0   0     1   6   97 112                 209
2233145 2233145 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow: Paul R Baird Middle   Regular School No Middle 06 08 2018   grade_8 204 7 17 0   1     0   7   124 112                       236.0 204 7 17 0   1     0   7   124 112                 236
2233993 2233993 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick: Wilson Middle   Regular School No Middle 05 08 2018   grade_8 175 9 14 1   11     0   18   115 113                       228.0 175 9 14 1   11     0   18   115 113                 228
2232007 2232007 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_8 198 3 21 0   2     0   5   115 114                       229.0 198 3 21 0   2     0   5   115 114                 229
2239086 2239086 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Hampden-Wilbraham: Wilbraham Middle   Regular School No Middle 06 08 2018   grade_8 190 6 12 0   6     0   5   105 114                       219.0 190 6 12 0   6     0   5   105 114                 219
2234728 2234728 MA Norfolk   school 2509060 220   Norwood 250906001468 2200305 Norwood: Dr. Philip O. Coakley Middle School   Regular School No Middle 06 08 2018   grade_8 169 27 26 0   9     0   4   119 116                       235.0 169 27 26 0   9     0   4   119 116                 235
2235068 2235068 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth: Plymouth South Middle   Regular School No Middle 06 08 2018   grade_8 219 2 7 0   2     0   8   122 116                       238.0 219 2 7 0   2     0   8   122 116                 238
2235562 2235562 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Saugus: Belmonte Saugus Middle   Regular School No Middle 06 08 2018   grade_8 186 12 21 1   6     1   2   113 116                       229.0 186 12 21 1   6     1   2   113 116                 229
2230369 2230369 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_8 169 4 10 0   38     0   1   105 117                       222.0 169 4 10 0   38     0   1   105 117                 222
2234987 2234987 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_8 160 20 22 0   2     0   15   102 117                       219.0 160 20 22 0   2     0   15   102 117                 219
2238834 2238834 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth: Dennis-Yarmouth Regional High   Regular School No High 08 12 2018   grade_8 154 26 29 6   4     0   11   113 117                       230.0 154 26 29 6   4     0   11   113 117                 230
2239709 2239709 MA Worcester   school 2511880 775   Wachusett 251188000888 7750305 Wachusett: Mountview Middle   Regular School No Middle 06 08 2018   grade_8 225 6 16 1   7     0   8   144 119                       263.0 225 6 16 1   7     0   8   144 119                 263
2229966 2229966 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston: William Monroe Trotter   Regular School No Elementary PK 08 2018   grade_8 0 13 9 0   0     0   1   11 12                       23.0 0 13 9 0   0     0   1   11 12                 23
2230687 2230687 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_8 9 1 10 0   1     0   4   13 12                       25.0 9 1 10 0   1     0   4   13 12                 25
2230365 2230365 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree: East Middle School   Regular School No Middle 06 08 2018   grade_8 182 9 10 1   34     0   5   120 121                       241.0 182 9 10 1   34     0   5   120 121                 241
2234353 2234353 MA Middlesex   school 2508610 207   Newton 250861000310 2070310 Newton: Charles E Brown Middle   Regular School No Middle 06 08 2018   grade_8 162 16 20 0   69     0   16   161 122                       283.0 162 16 20 0   69     0   16   161 122                 283
2236167 2236167 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_8 13 51 163 0   20     1   3   129 122                       251.0 13 51 163 0   20     1   3   129 122                 251
2231859 2231859 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_8 133 12 82 0   21     0   9   134 123                       257.0 133 12 82 0   21     0   9   134 123                 257
2231302 2231302 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_8 227 0 6 1   3     0   10   123 124                       247.0 227 0 6 1   3     0   10   123 124                 247
2238942 2238942 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_8 215 2 10 1   2     1   6   113 124                       237.0 215 2 10 1   2     1   6   113 124                 237
2234201 2234201 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_8 95 44 111 1   2     1   9   138 125                       263.0 95 44 111 1   2     1   9   138 125                 263
2230511 2230511 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_8 47 94 56 0   3     1   20   95 126                       221.0 47 94 56 0   3     1   20   95 126                 221
2233724 2233724 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose: Melrose Middle   Regular School No Middle 06 08 2018   grade_8 220 14 6 0   12     0   13   139 126                       265.0 220 14 6 0   12     0   13   139 126                 265
2231687 2231687 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_8 229 16 14 3   6     0   19   160 127                       287.0 229 16 14 3   6     0   19   160 127                 287
2239506 2239506 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake: Silver Lake Regional Middle School   Regular School No Middle 07 08 2018   grade_8 259 4 3 0   3     0   2   144 127                       271.0 259 4 3 0   3     0   2   144 127                 271
2231142 2231142 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_8 231 4 20 1   7     0   7   142 128                       270.0 231 4 20 1   7     0   7   142 128                 270
2231623 2231623 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_8 136 16 45 1   13     0   16   99 128                       227.0 136 16 45 1   13     0   16   99 128                 227
2232347 2232347 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston: Robert H. Adams Middle School   Regular School No Middle 06 08 2018   grade_8 198 2 7 1   20     0   4   104 128                       232.0 198 2 7 1   20     0   4   104 128                 232
2233499 2233499 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_8 130 11 142 0   3     0   12   170 128                       298.0 130 11 142 0   3     0   12   170 128                 298
2234193 2234193 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_8 106 49 95 4   3     0   20   149 128                       277.0 106 49 95 4   3     0   20   149 128                 277
2239363 2239363 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester: Old Rochester Regional Jr High   Regular School No Middle 07 08 2018   grade_8 238 5 5 0   3     0   10   133 128                       261.0 238 5 5 0   3     0   10   133 128                 261
2233460 2233460 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_8 227 6 12 0   1     0   7   124 129                       253.0 227 6 12 0   1     0   7   124 129                 253
2229897 2229897 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_8 0 10 12 0   0     0   0   9 13                       22.0 0 10 12 0   0     0   0   9 13                 22
2235377 2235377 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_8 19 0 1 0   0     0   0   7 13                       20.0 19 0 1 0   0     0   0   7 13                 20
2235467 2235467 MA Essex   school 2510380 258   Salem 251038002559 2580025 Salem: Nathaniel Bowditch   Regular School No Elementary KG 08 2018   grade_8 7 0 27 0   0     0   0   21 13                       34.0 7 0 27 0   0     0   0   21 13                 34
2236190 2236190 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield: Balliet Middle School   Regular School No Middle 06 08 2018   grade_8 1 8 24 0   0     0   0   20 13                       33.0 1 8 24 0   0     0   0   20 13                 33
2239648 2239648 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_8 35 1 2 3   1     0   2   31 13                       44.0 35 1 2 3   1     0   2   31 13                 44
2230661 2230661 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington: Marshall Simonds Middle   Regular School No Middle 06 08 2018   grade_8 196 19 13 2   34     0   12   146 130                       276.0 196 19 13 2   34     0   12   146 130                 276
2237857 2237857 MA Worcester   school 2513230 348   Worcester 251323002202 3480405 Worcester: Burncoat Middle School   Regular School No Middle 07 08 2018   grade_8 97 33 125 0   14     0   19   158 130                       288.0 97 33 125 0   14     0   19   158 130                 288
2232050 2232050 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_8 215 3 9 0   31     0   9   135 132                       267.0 215 3 9 0   31     0   9   135 132                 267
2228815 2228815 MA Hampden   school 2501800 5   Agawam 250180000025 50405 Agawam: Agawam Junior High   Regular School No Middle 07 08 2018   grade_8 216 6 24 0   7     0   9   129 133                       262.0 216 6 24 0   7     0   9   129 133                 262
2237213 2237213 MA Hampden   school 2512510 332   West Springfield 251251001243 3320305 West Springfield: West Springfield Middle   Regular School No Middle 06 08 2018   grade_8 193 10 57 1   19     0   6   153 133                       286.0 193 10 57 1   19     0   6   153 133                 286
2231006 2231006 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_8 163 7 87 0   4     0   5   131 135                       266.0 163 7 87 0   4     0   5   131 135                 266
2233797 2233797 MA Plymouth   school 2507770 182   Middleborough 250777001378 1820305 Middleborough: John T. Nichols Middle   Regular School No Middle 06 08 2018   grade_8 247 6 13 1   2     0   5   139 135                       274.0 247 6 13 1   2     0   5   139 135                 274
2230815 2230815 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_8 181 34 19 0   23     0   5   125 137                       262.0 181 34 19 0   23     0   5   125 137                 262
2233830 2233830 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford: Stacy Middle   Regular School No Middle 06 08 2018   grade_8 196 9 79 1   5     0   9   162 137                       299.0 196 9 79 1   5     0   9   162 137                 299
2234906 2234906 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke: Pembroke Community Middle School   Regular School No Middle 07 08 2018   grade_8 241 0 3 0   4     0   3   114 137                       251.0 241 0 3 0   4     0   3   114 137                 251
2238391 2238391 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_8 1 136 115 0   1     0   2   118 137                       255.0 1 136 115 0   1     0   2   118 137                 255
2235608 2235608 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate: Gates Middle School   Regular School No Middle 06 08 2018   grade_8 249 12 0 0   6     0   3   132 138                       270.0 249 12 0 0   6     0   3   132 138                 270

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