enrollments

Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 11,284 ✖
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
2238030 2238030 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_2 8 99 68 0   2     0   3   81 99                       180.0 8 99 68 0   2     0   3   81 99                 180
2238035 2238035 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_7 9 99 59 0   3     0   4   88 86                       174.0 9 99 59 0   3     0   4   88 86                 174
2238393 2238393 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_10 1 99 58 0   1     0   3   79 83                       162.0 1 99 58 0   1     0   3   79 83                 162
2230460 2230460 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton: Louis F Angelo Elementary   Regular School No Elementary KG 05 2018   grade_4 58 98 29 2   15     0   10   101 111                       212.0 58 98 29 2   15     0   10   101 111                 212
2238031 2238031 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_3 14 98 66 1   4     0   4   91 96                       187.0 14 98 66 1   4     0   4   91 96                 187
2233416 2233416 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_11 130 97 103 2   108     0   15   218 237                       455.0 130 97 103 2   108     0   15   218 237                 455
2240000 2240000 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_8 3 97 8 0   0     0   0   55 53                       108.0 3 97 8 0   0     0   0   55 53                 108
2231503 2231503 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_11 141 96 251 1   23     1   5   260 258                       518.0 141 96 251 1   23     1   5   260 258                 518
2236221 2236221 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield: Springfield Central High   Regular School No High 09 12 2018   grade_12 82 96 195 0   26     0   5   212 192                       404.0 82 96 195 0   26     0   5   212 192                 404
2230184 2230184 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston: O'Bryant School Math/Science   Regular School No High 07 12 2018   grade_11 25 95 82 2   65     1   6   126 150                       276.0 25 95 82 2   65     1   6   126 150                 276
2230238 2230238 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_11 3 95 26 1   8     0   2   78 57                       135.0 3 95 26 1   8     0   2   78 57                 135
2239999 2239999 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
2230194 2230194 MA Suffolk   school 2502790 35   Boston 250279001902 350581 Boston: Community Academy of Science and Health   Regular School No High 09 12 2018   grade_11 0 94 27 0   1     0   4   67 59                       126.0 0 94 27 0   1     0   4   67 59                 126
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
2233417 2233417 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden: Malden High   Regular School No High 09 12 2018   grade_12 120 94 113 1   113     0   13   219 235                       454.0 120 94 113 1   113     0   13   219 235                 454
2239998 2239998 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_6 2 94 10 1   0     0   0   52 55                       107.0 2 94 10 1   0     0   0   52 55                 107
2230467 2230467 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton: Oscar F Raymond   Regular School No Elementary KG 05 2018   grade_4 17 93 11 0   2     0   10   66 67                       133.0 17 93 11 0   2     0   10   66 67                 133
2233119 2233119 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell: Lowell High   Regular School No High 09 12 2018   grade_10 227 93 199 0   240     1   20   393 387                       780.0 227 93 199 0   240     1   20   393 387                 780
2236520 2236520 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton: Taunton High   Regular School No High 08 12 2018   grade_10 308 93 62 0   8     2   19   232 260                       492.0 308 93 62 0   8     2   19   232 260                 492
2238028 2238028 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   kindergarten 4 93 74 0   5     0   2   86 92                       178.0 4 93 74 0   5     0   2   86 92                 178
2230088 2230088 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_12 13 92 93 0   42     0   2   132 110                       242.0 13 92 93 0   42     0   2   132 110                 242
2230041 2230041 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston: Lilla G. Frederick Middle School   Regular School No Middle 06 08 2018   grade_8 3 91 87 0   18     0   3   107 95                       202.0 3 91 87 0   18     0   3   107 95                 202
2230118 2230118 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston: Madison Park High   Career and Technical School No High 09 12 2018   grade_12 8 91 84 1   3     1   3   107 84                       191.0 8 91 84 1   3     1   3   107 84                 191
2231502 2231502 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett: Everett High   Regular School No High 09 12 2018   grade_10 132 91 266 2   27     2   5   271 254                       525.0 132 91 266 2   27     2   5   271 254                 525
2235243 2235243 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph: Randolph Community Middle   Regular School No Middle 06 08 2018   grade_7 28 91 29 1   32     0   10   95 96                       191.0 28 91 29 1   32     0   10   95 96                 191
2229470 2229470 MA Suffolk   school 2502790 35   Boston 250279000213 350054 Boston: Charles H Taylor   Regular School No Elementary PK 05 2018   grade_3 0 90 11 1   1     0   4   56 51                       107.0 0 90 11 1   1     0   4   56 51                 107
2234204 2234204 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford: New Bedford High   Regular School No High 09 12 2018   grade_10 179 90 285 4   5     1   22   325 261                       586.0 179 90 285 4   5     1   22   325 261                 586
2238356 2238356 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_6 4 90 69 0   16     1   3   89 94                       183.0 4 90 69 0   16     1   3   89 94                 183
2228754 2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
2228812 2228812 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_6 249 9 18 0   14     0   10   169 131                       300.0 249 9 18 0   14     0   10   169 131                 300
2228866 2228866 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_6 25 9 13 0   0     0   3   24 26                       50.0 25 9 13 0   0     0   3   24 26                 50
2228870 2228870 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_2 29 9 14 0   6     0   0   31 27                       58.0 29 9 14 0   6     0   0   31 27                 58
2228926 2228926 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_10 317 9 27 1   63     0   10   214 213                       427.0 317 9 27 1   63     0   10   214 213                 427
2228928 2228928 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_12 311 9 19 0   64     0   8   197 213                       411.0 311 9 19 0   64     0   8   197 213                 411
2228992 2228992 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland: Henry E Warren Elementary   Regular School No Elementary KG 02 2018   kindergarten 122 9 24 0   37     0   10   100 102                       202.0 122 9 24 0   37     0   10   100 102                 202
2229041 2229041 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_5 124 9 19 0   4     0   12   93 75                       168.0 124 9 19 0   4     0   12   93 75                 168
2229049 2229049 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_8 95 9 25 0   5     0   7   77 64                       141.0 95 9 25 0   5     0   7   77 64                 141
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
2229115 2229115 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable: Hyannis West Elementary   Regular School No Elementary KG 03 2018   kindergarten 30 9 24 0   3     0   13   49 30                       79.0 30 9 24 0   3     0   13   49 30                 79
2229138 2229138 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford: Lt Elezer Davis   Regular School No Elementary KG 02 2018   grade_1 129 9 10 0   35     0   16   102 97                       199.0 129 9 10 0   35     0   16   102 97                 199
2229142 2229142 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Bedford: Lt Job Lane School   Regular School No Elementary 03 05 2018   grade_4 144 9 4 0   38     0   8   104 99                       203.0 144 9 4 0   38     0   8   104 99                 203
2229354 2229354 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   pre_kindergarten 98 9 12 0   20     0   5   85 59                       144.0 98 9 12 0   20     0   5   85 59                 144
2229356 2229356 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_10 289 9 20 0   22     0   7   167 180                       347.0 289 9 20 0   22     0   7   167 180                 347
2229358 2229358 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica: Billerica Memorial High School   Regular School No High 09 12 2018   grade_12 241 9 10 0   16     2   3   130 151                       281.0 241 9 10 0   16     2   3   130 151                 281
2229447 2229447 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Boston: Beethoven   Regular School No Elementary PK 03 2018   pre_kindergarten 20 9 10 0   3     0   2   20 24                       44.0 20 9 10 0   3     0   2   20 24                 44
2229507 2229507 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston: Dennis C Haley   Regular School No Elementary PK 08 2018   pre_kindergarten 12 9 6 0   0     0   0   16 11                       27.0 12 9 6 0   0     0   0   16 11                 27
2229570 2229570 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston: George H Conley   Regular School No Elementary PK 05 2018   grade_3 3 9 11 0   1     0   1   16 9                       25.0 3 9 11 0   1     0   1   16 9                 25
2229640 2229640 MA Suffolk   school 2502790 35   Boston 250279000265 350166 Boston: John F Kennedy   Regular School No Elementary PK 05 2018   grade_4 1 9 48 0   0     0   2   32 28                       60.0 1 9 48 0   0     0   2   32 28                 60
2229673 2229673 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston: Joseph P Tynan   Regular School No Elementary PK 05 2018   grade_1 5 9 9 0   3     0   4   19 11                       30.0 5 9 9 0   3     0   4   19 11                 30
2229707 2229707 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston: Joseph P Manning   Regular School No Elementary PK 05 2018   grade_5 7 9 9 0   0     0   1   13 13                       26.0 7 9 9 0   0     0   1   13 13                 26
2229710 2229710 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston: Joyce Kilmer   Regular School No Elementary PK 08 2018   pre_kindergarten 24 9 6 0   0     0   5   27 17                       44.0 24 9 6 0   0     0   5   27 17                 44
2229785 2229785 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_3 1 9 9 0   3     0   3   11 14                       25.0 1 9 9 0   3     0   3   11 14                 25
2229787 2229787 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston: Nathan Hale   Regular School No Elementary PK 05 2018   grade_5 0 9 12 0   1     0   2   13 11                       24.0 0 9 12 0   1     0   2   13 11                 24
2229846 2229846 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Boston: Paul A Dever   Regular School No Elementary PK 05 2018   grade_5 2 9 40 0   2     1   1   29 26                       55.0 2 9 40 0   2     1   1   29 26                 55
2229852 2229852 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston: Phineas Bates   Regular School No Elementary PK 05 2018   grade_3 8 9 14 0   5     0   1   20 17                       37.0 8 9 14 0   5     0   1   20 17                 37
2229866 2229866 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston: Roger Clap   Regular School No Elementary PK 05 2018   grade_1 3 9 5 0   0     0   0   6 11                       17.0 3 9 5 0   0     0   0   6 11                 17
2229870 2229870 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston: Roger Clap   Regular School No Elementary PK 05 2018   grade_5 2 9 7 0   0     0   0   11 7                       18.0 2 9 7 0   0     0   0   11 7                 18
2229896 2229896 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston: Sarah Greenwood   Regular School No Elementary PK 08 2018   grade_7 0 9 18 0   0     0   1   16 12                       28.0 0 9 18 0   0     0   1   16 12                 28
2229912 2229912 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston: Thomas J Kenny   Regular School No Elementary PK 05 2018   grade_1 9 9 10 1   7     0   2   22 16                       38.0 9 9 10 1   7     0   2   22 16                 38
2229921 2229921 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_2 36 9 16 0   4     0   4   30 39                       69.0 36 9 16 0   4     0   4   30 39                 69
2229924 2229924 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston: Warren-Prescott   Regular School No Elementary PK 08 2018   grade_5 34 9 16 0   5     0   2   34 32                       66.0 34 9 16 0   5     0   2   34 32                 66
2229938 2229938 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_3 0 9 3 0   0     0   0   10 2                       12.0 0 9 3 0   0     0   0   10 2                 12
2229940 2229940 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_5 4 9 5 0   0     0   0   16 2                       18.0 4 9 5 0   0     0   0   16 2                 18
2230220 2230220 MA Suffolk   school 2502790 35   Boston 250279002674 350655 Boston: Lyon Upper 9-12   Regular School No High 09 12 2018   grade_12 8 9 7 0   0     0   3   18 9                       27.0 8 9 7 0   0     0   3   18 9                 27
2230350 2230350 MA Norfolk   school 2502940 40   Braintree 250294000360 400033 Braintree: Archie T Morrison   Regular School No Elementary KG 05 2018   grade_1 41 9 3 1   10     0   1   38 27                       65.0 41 9 3 1   10     0   1   38 27                 65
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
2230367 2230367 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree: South Middle School   Regular School No Middle 06 08 2018   grade_6 163 9 10 0   32     0   0   106 108                       214.0 163 9 10 0   32     0   0   106 108                 214
2230652 2230652 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington: Francis Wyman Elementary   Regular School No Elementary KG 05 2018   kindergarten 51 9 5 0   18     0   3   49 37                       86.0 51 9 5 0   18     0   3   49 37                 86
2230654 2230654 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington: Francis Wyman Elementary   Regular School No Elementary KG 05 2018   grade_2 42 9 9 1   18     0   5   40 44                       84.0 42 9 9 1   18     0   5   40 44                 84
2230656 2230656 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington: Francis Wyman Elementary   Regular School No Elementary KG 05 2018   grade_4 57 9 4 0   15     0   0   43 42                       85.0 57 9 4 0   15     0   0   43 42                 85
2230667 2230667 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington: Burlington High   Regular School No High 09 12 2018   grade_11 183 9 14 1   35     0   9   112 139                       251.0 183 9 14 1   35     0   9   112 139                 251
2230674 2230674 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge: Maria L. Baldwin   Regular School No Elementary PK 05 2018   grade_3 25 9 6 0   4     0   5   28 21                       49.0 25 9 6 0   4     0   5   28 21                 49
2230695 2230695 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge: Cambridgeport   Regular School No Elementary PK 05 2018   grade_5 16 9 4 0   3     0   5   14 23                       37.0 16 9 4 0   3     0   5   14 23                 37
2230700 2230700 MA Middlesex   school 2503270 49   Cambridge 250327000441 490020 Cambridge: Haggerty   Regular School No Elementary PK 05 2018   grade_2 19 9 4 0   5     0   5   23 19                       42.0 19 9 4 0   5     0   5   23 19                 42
2230705 2230705 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Cambridge: Martin Luther King Jr.   Regular School No Elementary PK 05 2018   kindergarten 18 9 1 0   20     0   14   33 29                       62.0 18 9 1 0   20     0   14   33 29                 62
2230718 2230718 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 Cambridge: King Open   Alternative School No Elementary PK 05 2018   grade_4 20 9 12 1   5     0   3   26 24                       50.0 20 9 12 1   5     0   3   26 24                 50
2230723 2230723 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge: Kennedy-Longfellow   Regular School No Elementary PK 05 2018   grade_1 15 9 5 0   14     0   3   19 27                       46.0 15 9 5 0   14     0   3   19 27                 46
2230733 2230733 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Cambridge: Morse   Regular School No Elementary PK 05 2018   grade_3 14 9 6 1   7     0   6   22 21                       43.0 14 9 6 1   7     0   6   22 21                 43
2230757 2230757 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge: Graham and Parks   Alternative School No Elementary PK 05 2018   grade_3 27 9 3 0   10     0   2   29 22                       51.0 27 9 3 0   10     0   2   29 22                 51
2230790 2230790 MA Norfolk   school 2503300 50   Canton 250330002635 500010 Canton: Rodman Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 56 9 9 0   8     0   6   56 32                       88.0 56 9 9 0   8     0   6   56 32                 88
2230909 2230909 MA Suffolk   school 2503540 57   Chelsea 250354000859 570040 Chelsea: Frank M Sokolowski Elementary   Regular School No Elementary 01 04 2018   grade_1 7 9 92 0   1     0   0   59 50                       109.0 7 9 92 0   1     0   0   59 50                 109
2230998 2230998 MA Hampden   school 2503660 61   Chicopee 250366000500 610090 Chicopee: Gen John J Stefanik   Regular School No Elementary KG 05 2018   grade_1 27 9 37 0   0     0   0   45 28                       73.0 27 9 37 0   0     0   0   45 28                 73
2231005 2231005 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_7 139 9 108 0   2     0   10   144 124                       268.0 139 9 108 0   2     0   10   144 124                 268
2231015 2231015 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee: Chicopee High   Regular School No High 09 12 2018   grade_12 139 9 84 0   8     1   3   116 128                       244.0 139 9 84 0   8     1   3   116 128                 244
2231017 2231017 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee: Chicopee Comprehensive High School   Regular School No High 09 12 2018   grade_9 222 9 89 2   12     0   8   191 151                       342.0 222 9 89 2   12     0   8   191 151                 342
2231072 2231072 MA Middlesex   school 2503840 67   Concord 250384000521 670005 Concord: Alcott   Regular School No Elementary PK 05 2018   grade_4 55 9 8 0   5     0   3   36 44                       80.0 55 9 8 0   5     0   3   36 44                 80
2231185 2231185 MA Norfolk   school 2504050 73   Dedham 250405000546 730010 Dedham: Avery   Regular School No Elementary 01 05 2018   grade_1 32 9 21 1   0     0   8   31 40                       71.0 32 9 21 1   0     0   8   31 40                 71
2231211 2231211 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham: Dedham Middle School   Regular School No Middle 06 08 2018   grade_8 149 9 40 0   4     0   6   109 99                       208.0 149 9 40 0   4     0   6   109 99                 208
2231254 2231254 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Dracut: Joseph A Campbell Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten 41 9 1 0   4     0   1   36 20                       56.0 41 9 1 0   4     0   1   36 20                 56
2231272 2231272 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Dracut: Brookside Elementary   Regular School No Elementary KG 05 2018   grade_4 56 9 6 0   5     0   0   39 37                       76.0 56 9 6 0   5     0   0   39 37                 76
2231288 2231288 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut: Dracut Senior High   Regular School No High 09 12 2018   grade_11 167 9 13 0   15     1   4   101 108                       209.0 167 9 13 0   15     1   4   101 108                 209
2231322 2231322 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_10 159 9 4 0   0     0   2   80 94                       174.0 159 9 4 0   0     0   2   80 94                 174
2231388 2231388 MA Bristol   school 2504620 88   Easton 250462000980 880003 Easton: Center School   Regular School No Elementary PK 02 2018   grade_2 71 9 0 0   3     0   3   47 39                       86.0 71 9 0 0   3     0   3   47 39                 86
2231404 2231404 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_6 250 9 11 0   10     0   6   149 137                       286.0 250 9 11 0   10     0   6   149 137                 286
2231435 2231435 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett: Sumner G. Whittier School   Regular School No Elementary KG 08 2018   kindergarten 13 9 36 0   2     0   1   34 27                       61.0 13 9 36 0   2     0   1   34 27                 61
2231457 2231457 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_4 30 9 49 0   7     0   1   41 55                       96.0 30 9 49 0   7     0   1   41 55                 96
2231463 2231463 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   kindergarten 11 9 45 0   5     0   0   31 39                       70.0 11 9 45 0   5     0   0   31 39                 70
2231466 2231466 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_3 17 9 54 1   2     0   2   44 41                       85.0 17 9 54 1   2     0   2   44 41                 85
2231546 2231546 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River: Mary Fonseca Elementary School   Regular School No Elementary PK 05 2018   kindergarten 31 9 43 1   3     1   12   54 46                       100.0 31 9 43 1   3     1   12   54 46                 100
2231564 2231564 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_1 38 9 19 0   0     0   12   44 34                       78.0 38 9 19 0   0     0   12   44 34                 78

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