enrollments

Data source: Big Local News · About: Big Local

9,536 rows where state = "MA" and year = 2021 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 9,536 ✖
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
1675656 1675656 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell - Lowell High   Regular School No High 09 12 2021   grade_11 206 99 179 0   227     0   25   362 374 *                     736.0 206 99 179 0   227     0   25   362 374                 736
1679786 1679786 MA Suffolk   school 2500049 424   Boston Day and Evening Academy Charter (District) 250004901245 4240505 Boston Day and Evening Academy Charter (District) - Boston Day and Evening Academy Charter School   Regular School Yes High 09 12 2021   grade_12 10 99 89 1   2     0   4   99 106 *                     205.0 10 99 89 1   2     0   4   99 106                 205
1673388 1673388 MA Plymouth   school 2503090 44   Brockton 250309002655 440003 Brockton - Manthala George Jr. School   Regular School No Elementary KG 05 2021   kindergarten 18 98 49 0   0     1   3   87 82 *                     169.0 18 98 49 0   0     1   3   87 82                 169
1673433 1673433 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_4 53 98 27 1   7     0   4   96 94 *                     190.0 53 98 27 1   7     0   4   96 94                 190
1679804 1679804 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_7 5 98 66 0   4     0   3   83 93 *                     176.0 5 98 66 0   4     0   3   83 93                 176
1673458 1673458 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_6 24 97 18 0   0     1   7   91 56 *                     147.0 24 97 18 0   0     1   7   91 56                 147
1676587 1676587 MA Bristol   school 2508430 201   New Bedford 250843001336 2010505 New Bedford - New Bedford High   Regular School No High 09 12 2021   grade_10 263 97 352 5   4     0   35   397 359 *                     756.0 263 97 352 5   4     0   35   397 359                 756
1673235 1673235 MA Suffolk   school 2502790 35   Boston 250279000205 350575 Boston - O'Bryant School Math/Science   Regular School No High 07 12 2021   grade_11 37 96 86 1   61     0   4   125 160 *                     285.0 37 96 86 1   61     0   4   125 160                 285
1678308 1678308 MA Hampden   school 2511130 281   Springfield 251113002444 2810500 Springfield - Springfield Central High   Regular School No High 09 12 2021   grade_11 54 96 231 0   20     0   5   208 198 *                     406.0 54 96 231 0   20     0   5   208 198                 406
1679803 1679803 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_6 14 96 63 1   4     0   4   85 97 *                     182.0 14 96 63 1   4     0   4   85 97                 182
1673434 1673434 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Brockton - Louis F Angelo Elementary   Regular School No Elementary KG 05 2021   grade_5 42 94 31 1   11     0   10   98 91 *                     189.0 42 94 31 1   11     0   10   98 91                 189
1678555 1678555 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton - Taunton High   Regular School No High 08 12 2021   grade_12 276 94 60 0   5     0   15   222 228 *                     450.0 276 94 60 0   5     0   15   222 228                 450
1681488 1681488 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 High 06 12 2021   grade_6 1 94 11 2   2     0   7   63 54 *                     117.0 1 94 11 2   2     0   7   63 54                 117
1673176 1673176 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Boston - Madison Park High   Career and Technical School No High 09 12 2021   grade_11 5 93 124 2   1     1   3   130 99 *                     229.0 5 93 124 2   1     1   3   130 99                 229
1673261 1673261 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_10 3 93 39 0   5     0   9   93 56 *                     149.0 3 93 39 0   5     0   9   93 56                 149
1679806 1679806 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_9 3 93 50 0   1     0   1   72 76 *                     148.0 3 93 50 0   1     0   1   72 76                 148
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1681493 1681493 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 High 06 12 2021   grade_11 1 92 8 0   0     0   0   49 52 *                     101.0 1 92 8 0   0     0   0   49 52                 101
1673471 1673471 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_6 35 91 83 1   6     1   8   109 116 *                     225.0 35 91 83 1   6     1   8   109 116                 225
1679800 1679800 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District) - Brooke Charter School   Regular School Yes Other KG 12 2021   grade_3 4 91 94 1   4     0   2   104 92 *                     196.0 4 91 94 1   4     0   2   104 92                 196
1673436 1673436 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Brockton - Oscar F Raymond   Regular School No Elementary KG 05 2021   grade_1 8 90 11 0   0     2   2   67 46 *                     113.0 8 90 11 0   0     2   2   67 46                 113
1677470 1677470 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   grade_10 16 90 25 0   25     0   9   95 70 *                     165.0 16 90 25 0   25     0   9   95 70                 165
1677471 1677471 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph - Randolph High   Regular School No High 09 12 2021   grade_11 15 90 28 0   31     0   2   105 61 *                     166.0 15 90 28 0   31     0   2   105 61                 166
1679941 1679941 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_5 31 90 5 0   11     0   12   71 78 *                     149.0 31 90 5 0   11     0   12   71 78                 149
1679944 1679944 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_8 34 90 4 0   15     0   8   72 79 *                     151.0 34 90 4 0   15     0   8   72 79                 151
1672106 1672106 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_5 31 9 12 0   5     0   3   30 30 *                     60.0 31 9 12 0   5     0   3   30 30                 60
1672150 1672150 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_11 275 9 31 2   85     0   6   193 215 *                     408.0 275 9 31 2   85     0   6   193 215                 408
1672151 1672151 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_12 304 9 25 0   97     0   11   196 249 *                     446.0 304 9 25 0   97     0   11   196 249                 446
1672199 1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
1672229 1672229 MA Bristol   school 2502190 16   Attleboro 250219000090 160040 Attleboro - Hyman Fine Elementary School   Regular School No Elementary KG 04 2021   grade_1 66 9 17 0   1     0   5   47 51 *                     98.0 66 9 17 0   1     0   5   47 51                 98
1672244 1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
1672250 1672250 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_8 100 9 41 0   9     0   5   94 70 *                     164.0 100 9 41 0   9     0   5   94 70                 164
1672273 1672273 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_7 175 9 20 0   6     0   8   94 124 *                     218.0 175 9 20 0   6     0   8   94 124                 218
1672283 1672283 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_1 27 9 5 0   2     0   3   21 25 *                     46.0 27 9 5 0   2     0   3   21 25                 46
1672304 1672304 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   kindergarten 22 9 27 0   1     0   6   38 27 *                     65.0 22 9 27 0   1     0   6   38 27                 65
1672305 1672305 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_1 25 9 24 3   4     0   3   38 30 *                     68.0 25 9 24 3   4     0   3   38 30                 68
1672403 1672403 MA Middlesex   school 2502490 26   Belmont 250249000143 260505 Belmont - Belmont High   Regular School No High 09 12 2021   grade_11 229 9 17 0   59     0   21   163 172 *                     335.0 229 9 17 0   59     0   21   163 172                 335
1672439 1672439 MA Essex   school 2502640 30   Beverly 250264000175 300055 Beverly - Ayers/Ryal Side School   Regular School No Elementary KG 04 2021   grade_3 104 9 25 0   5     0   9   80 72 *                     152.0 104 9 25 0   5     0   9   80 72                 152
1672554 1672554 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   kindergarten 41 9 22 0   5     0   6   60 23 *                     83.0 41 9 22 0   5     0   6   60 23                 83
1672556 1672556 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_1 43 9 25 0   3     0   7   48 39 *                     87.0 43 9 25 0   3     0   7   48 39                 87
1672572 1672572 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Boston - Charles Sumner   Regular School No Elementary PK 05 2021   kindergarten 21 9 40 0   3     0   0   43 30 *                     73.0 21 9 40 0   3     0   0   43 30                 73
1672620 1672620 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_3 14 9 18 0   1     0   2   20 24 *                     44.0 14 9 18 0   1     0   2   20 24                 44
1672657 1672657 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Boston - Ellis Mendell   Regular School No Elementary PK 05 2021   grade_2 13 9 11 0   5     0   4   21 21 *                     42.0 13 9 11 0   5     0   4   21 21                 42
1672676 1672676 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_4 4 9 11 0   0     0   0   15 9 *                     24.0 4 9 11 0   0     0   0   15 9                 24
1672681 1672681 MA Suffolk   school 2502790 35   Boston 250279000247 350135 Boston - Henry Grew   Regular School No Elementary PK 05 2021   grade_1 3 9 11 1   0     0   3   14 13 *                     27.0 3 9 11 1   0     0   3   14 13                 27
1672755 1672755 MA Suffolk   school 2502790 35   Boston 250279000264 350172 Boston - John D Philbrick   Regular School No Elementary PK 05 2021   grade_5 3 9 6 0   0     0   0   12 6 *                     18.0 3 9 6 0   0     0   0   12 6                 18
1672770 1672770 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston - Joseph P Tynan   Regular School No Elementary PK 06 2021   grade_3 0 9 7 0   0     0   4   7 13 *                     20.0 0 9 7 0   0     0   4   7 13                 20
1672816 1672816 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Boston - Harvard-Kent   Regular School No Elementary PK 06 2021   grade_3 10 9 17 0   8     0   1   24 21 *                     45.0 10 9 17 0   8     0   1   24 21                 45
1672829 1672829 MA Suffolk   school 2502790 35   Boston 250279000289 350227 Boston - Mather   Regular School No Elementary PK 05 2021   pre_kindergarten 0 9 4 0   15     0   1   11 18 *                     29.0 0 9 4 0   15     0   1   11 18                 29
1672837 1672837 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_1 2 9 21 0   0     0   2   16 18 *                     34.0 2 9 21 0   0     0   2   16 18                 34
1672847 1672847 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_1 3 9 5 0   3     0   1   8 13 *                     21.0 3 9 5 0   3     0   1   8 13                 21
1672870 1672870 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   kindergarten 4 9 4 0   0     0   0   5 12 *                     17.0 4 9 4 0   0     0   0   5 12                 17
1672873 1672873 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_2 2 9 7 0   4     0   0   8 14 *                     22.0 2 9 7 0   4     0   0   8 14                 22
1672933 1672933 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston - Phineas Bates   Regular School No Elementary PK 05 2021   grade_1 18 9 6 1   1     0   3   19 19 *                     38.0 18 9 6 1   1     0   3   19 19                 38
1672936 1672936 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Boston - Phineas Bates   Regular School No Elementary PK 05 2021   grade_4 7 9 12 0   1     0   0   18 11 *                     29.0 7 9 12 0   1     0   0   18 11                 29
1672988 1672988 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   kindergarten 13 9 6 0   7     0   2   21 16 *                     37.0 13 9 6 0   7     0   2   21 16                 37
1673012 1673012 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_5 2 9 8 0   0     0   1   12 8 *                     20.0 2 9 8 0   0     0   1   12 8                 20
1673018 1673018 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_7 5 9 8 0   0     0   0   16 6 *                     22.0 5 9 8 0   0     0   0   16 6                 22
1673053 1673053 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_3 9 9 39 1   7     1   3   48 21 *                     69.0 9 9 39 1   7     1   3   48 21                 69
1673071 1673071 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_5 0 9 14 0   0     0   0   10 13 *                     23.0 0 9 14 0   0     0   0   10 13                 23
1673100 1673100 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_4 14 9 11 0   0     1   0   16 19 *                     35.0 14 9 11 0   0     1   0   16 19                 35
1673103 1673103 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_7 3 9 6 0   0     0   0   16 2 *                     18.0 3 9 6 0   0     0   0   16 2                 18
1673167 1673167 MA Suffolk   school 2502790 35   Boston 250279000226 350530 Boston - East Boston High   Regular School No High 09 12 2021   grade_12 27 9 198 0   7     0   6   150 97 *                     247.0 27 9 198 0   7     0   6   150 97                 247
1673216 1673216 MA Suffolk   school 2502790 35   Boston 250279001692 350558 Boston - Boston Community Leadership Academy   Regular School No High 09 12 2021   sped_beyond_grade_12 1 9 4 1   5     0   0   17 3 *                     20.0 1 9 4 1   5     0   0   17 3                 20
1673230 1673230 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   sped_beyond_grade_12 2 9 4 0   2     0   0   10 7 *                     17.0 2 9 4 0   2     0   0   10 7                 17
1673354 1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1673485 1673485 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Brockton - Edison Academy   Regular School No High 09 12 2021   grade_10 0 9 6 0   0     0   0   7 8 *                     15.0 0 9 6 0   0     0   0   7 8                 15
1673550 1673550 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_4 23 9 3 0   11     0   7   29 24 *                     53.0 23 9 3 0   11     0   7   29 24                 53
1673554 1673554 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline - William H Lincoln   Regular School No Elementary KG 08 2021   grade_8 44 9 8 0   8     0   4   27 46 *                     73.0 44 9 8 0   8     0   4   27 46                 73
1673581 1673581 MA Middlesex   school 2503240 48   Burlington 250324000427 480007 Burlington - Fox Hill   Regular School No Elementary KG 05 2021   grade_1 46 9 4 0   7     0   4   40 30 *                     70.0 46 9 4 0   7     0   4   40 30                 70
1673598 1673598 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Burlington - Francis Wyman Elementary   Regular School No Elementary KG 05 2021   kindergarten 59 9 3 0   11     0   2   33 51 *                     84.0 59 9 3 0   11     0   2   33 51                 84
1673615 1673615 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Cambridge - Maria L. Baldwin   Regular School No Elementary PK 05 2021   grade_2 34 9 5 0   5     0   3   32 24 *                     56.0 34 9 5 0   5     0   3   32 24                 56
1673634 1673634 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   grade_4 16 9 5 0   3     0   6   24 15 *                     39.0 16 9 5 0   3     0   6   24 15                 39
1673635 1673635 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridge - Cambridgeport   Regular School No Elementary PK 05 2021   grade_5 25 9 0 0   1     0   3   20 18 *                     38.0 25 9 0 0   1     0   3   20 18                 38
1673663 1673663 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Cambridge - Kennedy-Longfellow   Regular School No Elementary PK 05 2021   grade_5 11 9 5 0   4     0   1   16 14 *                     30.0 11 9 5 0   4     0   1   16 14                 30
1673677 1673677 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Cambridge - Peabody   Regular School No Elementary PK 05 2021   grade_5 24 9 2 0   7     0   2   14 30 *                     44.0 24 9 2 0   7     0   2   14 30                 44
1673689 1673689 MA Middlesex   school 2503270 49   Cambridge 250327000437 490080 Cambridge - Graham and Parks   Alternative School No Elementary PK 05 2021   grade_3 29 9 3 0   4     0   4   24 25 *                     49.0 29 9 3 0   4     0   4   24 25                 49
1673792 1673792 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_5 126 9 18 0   33     0   5   99 92 *                     191.0 126 9 18 0   33     0   5   99 92                 191
1673808 1673808 MA Suffolk   school 2503540 57   Chelsea 250354000855 570030 Chelsea - Edgar A Hooks Elementary   Regular School No Elementary 01 04 2021   grade_2 15 9 105 0   0     0   2   57 74 *                     131.0 15 9 105 0   0     0   2   57 74                 131
1673849 1673849 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee - Belcher   Regular School No Elementary KG 02 2021   grade_1 37 9 37 0   1     0   3   41 46 *                     87.0 37 9 37 0   1     0   3   41 46                 87
1673907 1673907 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee - Chicopee Comprehensive High School   Regular School No High 09 12 2021   grade_10 173 9 102 0   5     0   5   169 125 *                     294.0 173 9 102 0   5     0   5   169 125                 294
1673969 1673969 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_6 159 9 15 0   11     0   21   114 101 *                     215.0 159 9 15 0   11     0   21   114 101                 215
1674107 1674107 MA Middlesex   school 2504320 79   Dracut 250432000583 790020 Dracut - Joseph A Campbell Elementary   Regular School No Elementary PK 05 2021   pre_kindergarten 19 9 5 0   7     0   0   24 16 *                     40.0 19 9 5 0   7     0   0   24 16                 40
1674120 1674120 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Dracut - Brookside Elementary   Regular School No Elementary KG 05 2021   grade_1 48 9 7 0   10     0   1   44 31 *                     75.0 48 9 7 0   10     0   1   44 31                 75
1674122 1674122 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Dracut - Brookside Elementary   Regular School No Elementary KG 05 2021   grade_3 51 9 5 0   3     0   1   33 36 *                     69.0 51 9 5 0   3     0   1   33 36                 69
1674134 1674134 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut - Dracut Senior High   Regular School No High 09 12 2021   grade_9 154 9 21 1   24     0   2   105 103 *                     211.0 154 9 21 1   24     0   2   105 103                 211
1674159 1674159 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater - Gordon W. Mitchell School   Regular School No Elementary 03 06 2021   grade_5 139 9 5 1   3     0   7   90 74 *                     164.0 139 9 5 1   3     0   7   90 74                 164
1674161 1674161 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_7 154 9 6 1   1     0   7   103 75 *                     178.0 154 9 6 1   1     0   7   103 75                 178
1674233 1674233 MA Bristol   school 2504620 88   Easton 250462000623 880505 Easton - Oliver Ames High   Regular School No High 09 12 2021   grade_9 220 9 18 0   10     0   8   137 128 *                     265.0 220 9 18 0   10     0   8   137 128                 265
1674263 1674263 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett - Sumner G. Whittier School   Regular School No Elementary KG 08 2021   grade_5 10 9 57 2   7     0   1   35 51 *                     86.0 10 9 57 2   7     0   1   35 51                 86
1674274 1674274 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett - Madeline English School   Regular School No Elementary KG 08 2021   grade_1 20 9 47 1   5     0   1   51 32 *                     83.0 20 9 47 1   5     0   1   51 32                 83
1674285 1674285 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett - George Keverian School   Regular School No Elementary KG 08 2021   grade_3 15 9 58 0   5     0   0   36 51 *                     87.0 15 9 58 0   5     0   0   36 51                 87
1674360 1674360 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_1 35 9 46 0   3     0   4   55 42 *                     97.0 35 9 46 0   3     0   4   55 42                 97
1674361 1674361 MA Bristol   school 2504830 95   Fall River 250483002650 950011 Fall River - Mary Fonseca Elementary School   Regular School No Elementary PK 05 2021   grade_2 29 9 45 0   3     0   7   42 51 *                     93.0 29 9 45 0   3     0   7   42 51                 93
1674370 1674370 MA Bristol   school 2504830 95   Fall River 250483002656 950013 Fall River - Letourneau Elementary School   Regular School No Elementary PK 05 2021   grade_4 37 9 35 0   3     0   9   40 53 *                     93.0 37 9 35 0   3     0   9   40 53                 93
1674378 1674378 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River - Henry Lord Community School   Regular School No Elementary PK 08 2021   grade_5 32 9 18 0   4     0   5   35 33 *                     68.0 32 9 18 0   4     0   5   35 33                 68
1674399 1674399 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River - Spencer Borden   Regular School No Elementary PK 05 2021   kindergarten 50 9 19 0   5     0   10   52 41 *                     93.0 50 9 19 0   5     0   10   52 41                 93
1674404 1674404 MA Bristol   school 2504830 95   Fall River 250483000679 950130 Fall River - Spencer Borden   Regular School No Elementary PK 05 2021   grade_4 52 9 16 0   3     0   13   48 45 *                     93.0 52 9 16 0   3     0   13   48 45                 93
1674471 1674471 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth - Lawrence   Regular School No Middle 07 08 2021   grade_7 197 9 15 9   3     0   20   131 122 *                     253.0 197 9 15 9   3     0   20   131 122                 253
1674475 1674475 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_11 148 9 9 1   6     0   12   92 92 *                     185.0 148 9 9 1   6     0   12   92 92                 185

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