enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_7", state = "MA" and year = 2018 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_7 · 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
2229129 2229129 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable: Barnstable Intermediate School   Regular School No Middle 06 07 2018   grade_7 262 27 38 2   5     0   25   160 199                       359.0 262 27 38 2   5     0   25   160 199                 359
2230294 2230294 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_7 146 0 2 2   5     0   6   70 91                       161.0 146 0 2 2   5     0   6   70 91                 161
2231686 2231686 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_7 257 17 16 1   5     1   15   151 161                       312.0 257 17 16 1   5     1   15   151 161                 312
2233557 2233557 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_7 104 10 2 13   4     0   7   58 82                       140.0 104 10 2 13   4     0   7   58 82                 140
2235100 2235100 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_7 5 1 3 0   0     0   1   7 3                       10.0 5 1 3 0   0     0   1   7 3                 10
2235522 2235522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_7 221 1 1 4   6     0   1   120 114                       234.0 221 1 1 4   6     0   1   120 114                 234
2238070 2238070 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_7 71 2 3 0   1     0   4   37 44                       81.0 71 2 3 0   1     0   4   37 44                 81
2238831 2238831 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_7 156 22 18 5   5     0   11   115 102                       217.0 156 22 18 5   5     0   11   115 102                 217
2238909 2238909 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset: Nauset Regional Middle   Regular School No Middle 06 08 2018   grade_7 155 10 6 0   6     0   6   89 94                       183.0 155 10 6 0   6     0   6   89 94                 183
2239199 2239199 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_7 110 10 7 0   1     0   4   56 76                       132.0 110 10 7 0   1     0   4   56 76                 132
2231029 2231029 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_7 16 0 0 0   0     0   0   7 9                       16.0 16 0 0 0   0     0   0   7 9                 16
2232721 2232721 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_7 49 1 4 0   0     0   5   25 34                       59.0 49 1 4 0   0     0   5   25 34                 59
2232755 2232755 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_7 62 0 4 0   4     0   0   35 35                       70.0 62 0 4 0   4     0   0   35 35                 70
2234410 2234410 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   grade_7 85 4 4 0   0     0   7   52 48                       100.0 85 4 4 0   0     0   7   52 48                 100
2234982 2234982 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 Pittsfield: John T Reid Middle   Regular School No Middle 06 08 2018   grade_7 110 20 25 0   3     1   20   97 82                       179.0 110 20 25 0   3     1   20   97 82                 179
2234986 2234986 MA Berkshire   school 2509630 236   Pittsfield 250963001532 2360310 Pittsfield: Theodore Herberg Middle   Regular School No Middle 06 08 2018   grade_7 128 22 28 0   3     0   21   100 102                       202.0 128 22 28 0   3     0   21   100 102                 202
2235376 2235376 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_7 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2237969 2237969 MA Berkshire   school 2500079 414   Berkshire Arts and Technology Charter Public (District) 250007901842 4140305 Berkshire Arts and Technology Charter Public (District): Berkshire Arts and Technology Charter Public School   Regular School Yes High 06 12 2018   grade_7 47 8 8 1   4     0   5   33 40                       73.0 47 8 8 1   4     0   5   33 40                 73
2238588 2238588 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_7 86 4 1 0   0     0   1   46 46                       92.0 86 4 1 0   0     0   1   46 46                 92
2238688 2238688 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 10 0   4     0   3   51 50                       101.0 83 1 10 0   4     0   3   51 50                 101
2238796 2238796 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_7 107 1 3 0   0     0   4   54 61                       115.0 107 1 3 0   0     0   4   54 61                 115
2239207 2239207 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock: Mt Greylock Regional High   Regular School No High 07 12 2018   grade_7 86 1 2 0   4     0   1   47 47                       94.0 86 1 2 0   4     0   1   47 47                 94
2239535 2239535 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Southern Berkshire: Mt Everett Regional   Regular School No High 07 12 2018   grade_7 53 2 3 1   0     0   3   27 35                       62.0 53 2 3 1   0     0   3   27 35                 62
2228782 2228782 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_7 116 1 1 0   0     0   1   58 61                       119.0 116 1 1 0   0     0   1   58 61                 119
2229043 2229043 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_7 109 2 10 0   5     0   11   69 68                       137.0 109 2 10 0   5     0   11   69 68                 137
2229048 2229048 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_7 82 10 25 1   3     0   11   70 62                       132.0 82 10 25 1   3     0   11   70 62                 132
2229053 2229053 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_7 101 9 24 0   7     0   2   87 56                       143.0 101 9 24 0   7     0   2   87 56                 143
2229247 2229247 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_7 92 0 0 0   0     0   5   47 50                       97.0 92 0 0 0   0     0   5   47 50                 97
2231174 2231174 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_7 268 6 12 0   0     0   19   178 127                       305.0 268 6 12 0   0     0   19   178 127                 305
2231405 2231405 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_7 264 18 10 0   10     0   3   157 148                       305.0 264 18 10 0   10     0   3   157 148                 305
2231523 2231523 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven: Hastings Middle   Regular School No Middle 06 08 2018   grade_7 145 3 10 1   4     0   5   83 85                       168.0 145 3 10 1   4     0   5   83 85                 168
2231570 2231570 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_7 30 8 22 0   2     0   2   36 28                       64.0 30 8 22 0   2     0   2   36 28                 64
2231581 2231581 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_7 25 3 22 0   1     0   2   20 33                       53.0 25 3 22 0   1     0   2   20 33                 53
2231614 2231614 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_7 87 13 55 0   10     0   8   96 77                       173.0 87 13 55 0   10     0   8   96 77                 173
2231618 2231618 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_7 120 16 44 2   13     0   12   112 95                       207.0 120 16 44 2   13     0   12   112 95                 207
2231622 2231622 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_7 157 26 61 0   7     0   16   136 131                       267.0 157 26 61 0   7     0   16   136 131                 267
2231628 2231628 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_7 5 0 3 0   0     0   0   7 1                       8.0 5 0 3 0   0     0   0   7 1                 8
2231644 2231644 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_7 * * * *   *     *   *   * *                       0.0                                             0
2231651 2231651 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_7 12 3 3 0   0     0   5   12 11                       23.0 12 3 3 0   0     0   5   12 11                 23
2233430 2233430 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield: Harold L Qualters Middle   Regular School No Middle 06 08 2018   grade_7 280 5 15 0   12     0   14   175 151                       326.0 280 5 15 0   12     0   14   175 151                 326
2234192 2234192 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford: Keith Middle School   Regular School No Middle 06 08 2018   grade_7 121 38 111 1   2     1   12   140 146                       286.0 121 38 111 1   2     1   12   140 146                 286
2234196 2234196 MA Bristol   school 2508430 201   New Bedford 250843001337 2010410 New Bedford: Normandin Middle School   Regular School No Middle 06 08 2018   grade_7 198 28 151 2   9     0   29   216 201                       417.0 198 28 151 2   9     0   29   216 201                 417
2234200 2234200 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford: Roosevelt Middle School   Regular School No Middle 06 08 2018   grade_7 98 43 95 1   0     0   19   136 120                       256.0 98 43 95 1   0     0   19   136 120                 256
2234208 2234208 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford: Trinity Day Academy   Regular School No High 06 12 2018   grade_7 4 0 2 1   0     0   0   5 2                       7.0 4 0 2 1   0     0   0   5 2                 7
2234215 2234215 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford: Whaling City Junior/Senior High School   Regular School No High 06 12 2018   grade_7 1 1 5 0   0     0   0   6 1                       7.0 1 1 5 0   0     0   0   6 1                 7
2234539 2234539 MA Bristol   school 2508730 212   North Attleborough 250873001207 2120305 North Attleborough: North Attleborough Middle   Regular School No Middle 06 08 2018   grade_7 284 10 14 1   25     1   11   183 163                       346.0 284 10 14 1   25     1   11   183 163                 346
2234659 2234659 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton: Norton Middle   Regular School No Middle 06 08 2018   grade_7 176 3 5 0   3     0   5   92 100                       192.0 176 3 5 0   3     0   5   92 100                 192
2235632 2235632 MA Bristol   school 2510590 265   Seekonk 251059001700 2650405 Seekonk: Dr. Kevin M. Hurley Middle School   Regular School No Middle 06 08 2018   grade_7 148 4 5 1   6     0   6   82 88                       170.0 148 4 5 1   6     0   6   82 88                 170
2235751 2235751 MA Bristol   school 2510860 273   Somerset 251086002537 2730305 Somerset: Somerset Middle School   Regular School No Middle 06 08 2018   grade_7 180 4 7 0   1     0   6   106 92                       198.0 180 4 7 0   1     0   6   106 92                 198
2236454 2236454 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea: Joseph Case Jr High   Regular School No Middle 06 08 2018   grade_7 155 1 2 0   0     0   2   82 78                       160.0 155 1 2 0   0     0   2   82 78                 160
2236502 2236502 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton: Joseph H Martin   Regular School No Middle 05 07 2018   grade_7 157 34 26 1   5     0   4   126 101                       227.0 157 34 26 1   5     0   4   126 101                 227
2236512 2236512 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton: John F Parker Middle   Regular School No Middle 05 07 2018   grade_7 78 40 15 1   1     0   12   71 76                       147.0 78 40 15 1   1     0   12   71 76                 147
2236516 2236516 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_7 172 25 28 2   1     0   14   126 116                       242.0 172 25 28 2   1     0   14   126 116                 242
2237168 2237168 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_7 104 2 3 0   1     0   5   62 53                       115.0 104 2 3 0   1     0   5   62 53                 115
2237933 2237933 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_7 12 7 23 0   0     0   2   23 21                       44.0 12 7 23 0   0     0   2   23 21                 44
2238454 2238454 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_7 85 7 11 0   3     0   3   56 53                       109.0 85 7 11 0   3     0   3   56 53                 109
2238487 2238487 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_7 45 10 29 0   1     0   7   50 42                       92.0 45 10 29 0   1     0   7   50 42                 92
2238748 2238748 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham: Raynham Middle School   Regular School No Middle 05 08 2018   grade_7 154 6 3 0   3     1   9   91 85                       176.0 154 6 3 0   3     1   9   91 85                 176
2238751 2238751 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham: Bridgewater Middle School   Regular School No Middle 07 08 2018   grade_7 232 9 0 1   4     0   9   133 122                       255.0 232 9 0 1   4     0   9   133 122                 255
2238854 2238854 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_7 91 1 4 0   1     0   5   56 46                       102.0 91 1 4 0   1     0   5   56 46                 102
2238859 2238859 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_7 135 0 4 0   1     0   6   62 84                       146.0 135 0 4 0   1     0   6   62 84                 146
2238941 2238941 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_7 242 2 3 0   2     0   2   130 121                       251.0 242 2 3 0   2     0   2   130 121                 251
2239982 2239982 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_7 65 10 15 1   3     1   8   54 49                       103.0 65 10 15 1   3     1   8   54 49                 103
2231421 2231421 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_7 20 0 7 0   0     0   3   15 15                       30.0 20 0 7 0   0     0   3   15 15                 30
2232022 2232022 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_7 * * * *   *     *   *   * *                       1.0                                             1
2234743 2234743 MA Dukes   school 2504650 221   Oak Bluffs 250465000625 2210005 Oak Bluffs: Oak Bluffs Elementary   Regular School No Elementary PK 08 2018   grade_7 30 3 8 1   1     0   5   25 23                       48.0 30 3 8 1   1     0   5   25 23                 48
2236562 2236562 MA Dukes   school 2512570 296   Tisbury 251257002054 2960005 Tisbury: Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_7 20 0 9 0   0     0   0   17 12                       29.0 20 0 9 0   0     0   0   17 12                 29
2238289 2238289 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_7 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2239647 2239647 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional: West Tisbury Elementary   Regular School No Elementary PK 08 2018   grade_7 45 2 1 1   2     0   2   24 29                       53.0 45 2 1 1   2     0   2   24 29                 53
2228838 2228838 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_7 144 1 12 0   1     0   9   86 81                       167.0 144 1 12 0   1     0   9   86 81                 167
2228914 2228914 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_7 162 1 5 2   27     0   5   97 105                       202.0 162 1 5 2   27     0   5   97 105                 202
2228918 2228918 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_7 141 2 6 1   25     0   6   84 97                       181.0 141 2 6 1   25     0   6   84 97                 181
2228922 2228922 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_7 73 2 11 0   35     0   4   50 75                       125.0 73 2 11 0   35     0   4   50 75                 125
2229296 2229296 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly: Briscoe Middle   Regular School No Middle 06 08 2018   grade_7 269 10 32 0   6     0   12   170 159                       329.0 269 10 32 0   6     0   12   170 159                 329
2231141 2231141 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_7 240 5 20 0   7     0   9   136 145                       281.0 240 5 20 0   7     0   9   136 145                 281
2231960 2231960 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_7 107 2 1 0   1     0   1   62 50                       112.0 107 2 1 0   1     0   1   62 50                 112
2232006 2232006 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_7 169 5 14 1   4     2   18   123 90                       213.0 169 5 14 1   4     2   18   123 90                 213
2232217 2232217 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_7 127 7 29 0   2     0   3   85 83                       168.0 127 7 29 0   2     0   3   85 83                 168
2232229 2232229 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_7 69 6 50 0   4     0   1   67 63                       130.0 69 6 50 0   4     0   1   67 63                 130
2232258 2232258 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_7 77 4 36 0   2     1   0   56 64                       120.0 77 4 36 0   2     1   0   56 64                 120
2232265 2232265 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_7 97 6 101 0   5     1   3   95 118                       213.0 97 6 101 0   5     1   3   95 118                 213
2232546 2232546 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_7 115 1 8 0   2     0   9   71 64                       135.0 115 1 8 0   2     0   9   71 64                 135
2232599 2232599 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_7 6 0 90 0   3     0   0   46 53                       99.0 6 0 90 0   3     0   0   46 53                 99
2232604 2232604 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_7 3 1 143 0   0     0   1   80 68                       148.0 3 1 143 0   0     0   1   80 68                 148
2232625 2232625 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_7 3 3 124 0   0     0   1   65 66                       131.0 3 3 124 0   0     0   1   65 66                 131
2232630 2232630 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_7 6 0 155 0   1     0   0   83 79                       162.0 6 0 155 0   1     0   0   83 79                 162
2232647 2232647 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_7 3 1 115 0   0     0   0   61 58                       119.0 3 1 115 0   0     0   0   61 58                 119
2232669 2232669 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_7 4 1 75 0   3     0   0   39 44                       83.0 4 1 75 0   3     0   0   39 44                 83
2232673 2232673 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence: Spark Academy   Regular School No Middle 06 08 2018   grade_7 5 2 129 0   3     0   1   61 79                       140.0 5 2 129 0   3     0   1   61 79                 140
2232677 2232677 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 98 0   1     0   0   54 46                       100.0 1 0 98 0   1     0   0   54 46                 100
2232687 2232687 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_7 7 1 112 0   3     0   1   72 52                       124.0 7 1 112 0   3     0   1   72 52                 124
2232700 2232700 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_7 2 0 9 0   0     0   0   10 1                       11.0 2 0 9 0   0     0   0   10 1                 11
2233302 2233302 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_7 41 40 269 0   35     0   13   195 203                       398.0 41 40 269 0   35     0   13   195 203                 398
2233306 2233306 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_7 67 37 264 1   49     0   16   216 218                       434.0 67 37 264 1   49     0   16   216 218                 434
2233310 2233310 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_7 66 20 79 2   22     0   10   103 96                       199.0 66 20 79 2   22     0   10   103 96                 199
2233323 2233323 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_7 2 2 3 1   0     0   0   4 4                       8.0 2 2 3 1   0     0   0   4 4                 8
2233332 2233332 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn: Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2233354 2233354 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield: Lynnfield Middle School   Regular School No Middle 05 08 2018   grade_7 129 3 13 0   9     0   5   90 69                       159.0 129 3 13 0   9     0   5   90 69                 159
2233459 2233459 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_7 208 11 11 0   4     0   2   115 121                       236.0 208 11 11 0   4     0   2   115 121                 236
2233739 2233739 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Methuen: Marsh Grammar School   Regular School No Elementary PK 08 2018   grade_7 100 0 33 0   4     0   5   70 72                       142.0 100 0 33 0   4     0   5   70 72                 142

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