enrollments

Data source: Big Local News · About: Big Local

9,537 rows where state = "MA" and year = 2020 sorted by female descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 9,537 ✖
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
1365106 1365106 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_3 121 14 12 0   35     0   15   98 99 *                     197.0 121 14 12 0   35     0   15   98 99                 197
1366231 1366231 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2020   grade_8 31 131 35 0   4     0   10   112 99 *                     211.0 31 131 35 0   4     0   10   112 99                 211
1366677 1366677 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2020   grade_12 107 6 95 0   9     0   2   120 99 *                     219.0 107 6 95 0   9     0   2   120 99                 219
1366915 1366915 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2020   grade_2 183 1 6 0   0     0   9   100 99 *                     199.0 183 1 6 0   0     0   9   100 99                 199
1367257 1367257 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_6 59 9 92 0   9     1   11   82 99 *                     181.0 59 9 92 0   9     1   11   82 99                 181
1367317 1367317 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2020   grade_7 181 13 8 1   8     0   5   117 99 *                     216.0 181 13 8 1   8     0   5   117 99                 216
1367321 1367321 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2020   grade_11 157 15 8 0   7     0   1   89 99 *                     188.0 157 15 8 0   7     0   1   89 99                 188
1367611 1367611 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_8 208 5 5 0   5     0   1   125 99 *                     224.0 208 5 5 0   5     0   1   125 99                 224
1369364 1369364 MA Essex   school 2508580 204   Newburyport 250858001355 2040305 Rupert A Nock Middle   Regular School No Middle 06 08 2020   grade_8 176 3 7 0   9     0   4   100 99 *                     199.0 176 3 7 0   9     0   4   100 99                 199
1369553 1369553 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2020   grade_12 146 5 37 0   6     0   12   107 99 *                     206.0 146 5 37 0   6     0   12   107 99                 206
1369652 1369652 MA Worcester   school 2508880 213   Northborough 250888001440 2130305 Robert E. Melican Middle School   Regular School No Middle 06 08 2020   grade_7 133 2 17 0   23     3   6   85 99 *                     184.0 133 2 17 0   23     3   6   85 99                 184
1369721 1369721 MA Bristol   school 2509000 218   Norton 250900001452 2180305 Norton Middle   Regular School No Middle 06 08 2020   grade_7 173 3 9 0   3     0   10   99 99 *                     198.0 173 3 9 0   3     0   10   99 99                 198
1370005 1370005 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2020   grade_11 131 23 28 1   7     0   7   98 99 *                     197.0 131 23 28 1   7     0   7   98 99                 197
1370424 1370424 MA Essex   school 2510380 258   Salem 251038002404 2580305 Collins Middle   Regular School No Middle 06 08 2020   grade_7 87 16 94 0   8     0   8   114 99 *                     213.0 87 16 94 0   8     0   8   114 99                 213
1370602 1370602 MA Worcester   school 2510770 271   Shrewsbury 251077001559 2710040 Parker Road Preschool   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 104 9 11 2   97     0   7   131 99 *                     230.0 104 9 11 2   97     0   7   131 99                 230
1371002 1371002 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Forest Park Middle   Regular School No Middle 06 08 2020   grade_6 11 59 142 0   13     0   6   132 99 *                     231.0 11 59 142 0   13     0   6   132 99                 231
1371325 1371325 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2020   grade_12 197 3 10 0   9     0   1   120 99 *                     220.0 197 3 10 0   9     0   1   120 99                 220
1365050 1365050 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_7 154 4 26 0   9     0   9   104 98 *                     202.0 154 4 26 0   9     0   9   104 98                 202
1365107 1365107 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2020   grade_4 120 12 14 0   40     0   16   104 98 *                     202.0 120 12 14 0   40     0   16   104 98                 202
1365115 1365115 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_12 133 11 17 0   25     1   7   96 98 *                     194.0 133 11 17 0   25     1   7   96 98                 194
1365258 1365258 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Locke Middle   Regular School No Middle 05 07 2020   grade_7 147 7 10 0   17     0   7   90 98 *                     188.0 147 7 10 0   17     0   7   90 98                 188
1366562 1366562 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_6 140 5 9 0   34     0   7   97 98 *                     195.0 140 5 9 0   34     0   7   97 98                 195
1367913 1367913 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2020   grade_7 159 6 25 0   2     0   11   105 98 *                     203.0 159 6 25 0   2     0   11   105 98                 203
1367916 1367916 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2020   grade_10 124 8 27 0   1     1   4   67 98 *                     165.0 124 8 27 0   1     1   4   67 98                 165
1368440 1368440 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow Senior High   Regular School No High 09 12 2020   grade_12 167 5 14 1   2     0   6   97 98 *                     195.0 167 5 14 1   2     0   6   97 98                 195
1369462 1369462 MA Middlesex   school 2508610 207   Newton 250861000307 2070305 Bigelow Middle   Regular School No Middle 06 08 2020   grade_7 108 11 21 1   23     0   12   78 98 *                     176.0 108 11 21 1   23     0   12   78 98                 176
1370311 1370311 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Garfield Middle School   Regular School No Middle 06 08 2020   grade_8 55 6 117 1   10     0   3   94 98 *                     192.0 55 6 117 1   10     0   3   94 98                 192
1370517 1370517 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_6 196 6 3 0   2     0   3   112 98 *                     210.0 196 6 3 0   2     0   3   112 98                 210
1371993 1371993 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2020   grade_9 166 3 7 0   9     0   10   97 98 *                     195.0 166 3 7 0   9     0   10   97 98                 195
1372539 1372539 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_5 13 95 64 1   4     0   4   83 98 *                     181.0 13 95 64 1   4     0   4   83 98                 181
1373066 1373066 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000831 6100305 Overlook Middle School   Regular School No Middle 06 08 2020   grade_8 176 2 15 1   1     0   2   99 98 *                     197.0 176 2 15 1   1     0   2   99 98                 197
1373069 1373069 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000069 6100505 Oakmont Regional High School   Regular School No High 09 12 2020   grade_11 162 0 4 0   4     0   2   74 98 *                     172.0 162 0 4 0   4     0   2   74 98                 172
1373393 1373393 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_8 185 2 2 1   9     1   3   105 98 *                     203.0 185 2 2 1   9     1   3   105 98                 203
1373538 1373538 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_7 181 0 11 0   6     0   7   107 98 *                     205.0 181 0 11 0   6     0   7   107 98                 205
1373539 1373539 MA Worcester   school 2507680 710   Mendon-Upton 250768001279 7100015 Miscoe Hill School   Regular School No Middle 05 08 2020   grade_8 173 1 13 0   4     0   12   105 98 *                     203.0 173 1 13 0   4     0   12   105 98                 203
1373727 1373727 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2020   grade_10 182 4 4 0   2     0   9   103 98 *                     201.0 182 4 4 0   2     0   9   103 98                 201
1373759 1373759 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No High 09 12 2020   grade_11 185 4 3 0   9     0   3   106 98 *                     204.0 185 4 3 0   9     0   3   106 98                 204
1373820 1373820 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin Regional Middle School   Regular School No Middle 07 08 2020   grade_8 174 0 8 1   4     0   2   91 98 *                     189.0 174 0 8 1   4     0   2   91 98                 189
1365048 1365048 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_5 160 5 23 0   16     0   4   111 97 *                     208.0 160 5 23 0   16     0   4   111 97                 208
1366610 1366610 MA Hampden   school 2503660 61   Chicopee 250366002571 610001 Szetela Early Childhood Center   Regular School No Prekindergarten PK PK 2020   pre_kindergarten 141 8 76 0   10     0   14   152 97 *                     249.0 141 8 76 0   10     0   14   152 97                 249
1366840 1366840 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2020   grade_6 166 11 32 0   3     0   9   124 97 *                     221.0 166 11 32 0   3     0   9   124 97                 221
1366908 1366908 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2020   grade_12 157 17 7 1   14     0   3   102 97 *                     199.0 157 17 7 1   14     0   3   102 97                 199
1367707 1367707 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 05 08 2020   grade_8 101 9 100 1   4     0   1   119 97 *                     216.0 101 9 100 1   4     0   1   119 97                 216
1368271 1368271 MA Hampden   school 2506990 159   Longmeadow 250699001020 1590505 Longmeadow High   Regular School No High 09 12 2020   grade_9 175 6 7 0   25     0   5   121 97 *                     218.0 175 6 7 0   25     0   5   121 97                 218
1368704 1368704 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_4 166 6 18 0   0     0   14   107 97 *                     204.0 166 6 18 0   0     0   14   107 97                 204
1368705 1368705 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Village School   Regular School No Elementary 03 06 2020   grade_5 183 9 16 0   5     0   9   125 97 *                     222.0 183 9 16 0   5     0   9   125 97                 222
1369707 1369707 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2020   grade_12 187 1 3 0   5     0   1   100 97 *                     197.0 187 1 3 0   5     0   1   100 97                 197
1369748 1369748 MA Plymouth   school 2509030 219   Norwell 250903001455 2190505 Norwell High   Regular School No High 09 12 2020   grade_12 172 2 2 0   6     1   2   88 97 *                     185.0 172 2 2 0   6     1   2   88 97                 185
1369932 1369932 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2020   grade_8 218 1 0 0   2     1   1   126 97 *                     223.0 218 1 0 0   2     1   1   126 97                 223
1370479 1370479 MA Essex   school 2510500 262   Saugus 251050001685 2620305 Belmonte Saugus Middle   Regular School No Middle 06 08 2020   grade_7 139 7 39 1   10     3   5   107 97 *                     204.0 139 7 39 1   10     3   5   107 97                 204
1371244 1371244 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_6 169 0 3 1   4     0   1   81 97 *                     178.0 169 0 3 1   4     0   1   81 97                 178
1371818 1371818 MA Middlesex   school 2512750 330   Weston 251275002087 3300505 Weston High   Regular School No High 09 12 2020   grade_10 106 12 7 2   33     0   6   69 97 *                     166.0 106 12 7 2   33     0   6   69 97                 166
1371903 1371903 MA Norfolk   school 2512810 335   Westwood 251281002097 3350305 E W Thurston Middle   Regular School No Middle 06 08 2020   grade_7 181 5 9 0   28     0   5   131 97 *                     228.0 181 5 9 0   28     0   5   131 97                 228
1364982 1364982 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2020   grade_1 131 6 29 1   44     0   11   126 96 *                     222.0 131 6 29 1   44     0   11   126 96                 222
1365047 1365047 MA Worcester   school 2502220 17   Auburn 250222002846 170030 Swanson Road Intermediate School   Regular School No Elementary 03 05 2020   grade_4 162 6 25 0   4     0   6   107 96 *                     203.0 162 6 25 0   4     0   6   107 96                 203
1365908 1365908 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No High 09 12 2020   grade_9 12 48 168 0   10     0   4   146 96 *                     242.0 12 48 168 0   10     0   4   146 96                 242
1366975 1366975 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2020   grade_2 151 1 24 0   8     0   9   97 96 *                     193.0 151 1 24 0   8     0   9   97 96                 193
1367259 1367259 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_8 50 10 94 0   14     0   10   82 96 *                     178.0 50 10 94 0   14     0   10   82 96                 178
1367451 1367451 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2020   grade_7 126 3 47 0   5     0   19   104 96 *                     200.0 126 3 47 0   5     0   19   104 96                 200
1367787 1367787 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2020   grade_11 169 2 5 2   15     0   2   99 96 *                     195.0 169 2 5 2   15     0   2   99 96                 195
1368433 1368433 MA Hampden   school 2507050 161   Ludlow 250705001057 1610023 Veterans Park Elementary   Regular School No Elementary 04 05 2020   grade_5 136 3 22 0   3     0   7   75 96 *                     171.0 136 3 22 0   3     0   7   75 96                 171
1368435 1368435 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2020   grade_7 175 5 18 2   0     0   5   109 96 *                     205.0 175 5 18 2   0     0   5   109 96                 205
1369719 1369719 MA Bristol   school 2509000 218   Norton 250900001209 2180060 Henri A. Yelle   Regular School No Elementary 04 05 2020   grade_5 159 5 10 2   2     0   8   90 96 *                     186.0 159 5 10 2   2     0   8   90 96                 186
1369998 1369998 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2020   grade_7 118 27 17 1   0     0   13   80 96 *                     176.0 118 27 17 1   0     0   13   80 96                 176
1370442 1370442 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2020   grade_2 165 0 14 0   3     1   5   92 96 *                     188.0 165 0 14 0   3     1   5   92 96                 188
1370640 1370640 MA Middlesex   school 2510890 274   Somerville 251089002561 2740005 Capuano Early Childhood Center   Regular School No Elementary PK KG 2020   pre_kindergarten 88 22 73 0   28     0   16   131 96 *                     227.0 88 22 73 0   28     0   16   131 96                 227
1371103 1371103 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham Central Middle School   Regular School No Middle 05 08 2020   grade_7 132 4 24 0   9     0   5   78 96 *                     174.0 132 4 24 0   9     0   5   78 96                 174
1372536 1372536 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_2 4 95 81 0   5     0   2   91 96 *                     187.0 4 95 81 0   5     0   2   91 96                 187
1372538 1372538 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_4 10 99 66 0   2     0   4   85 96 *                     181.0 10 99 66 0   2     0   4   85 96                 181
1372540 1372540 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 12 2020   grade_6 6 99 64 0   5     0   2   80 96 *                     176.0 6 99 64 0   5     0   2   80 96                 176
1373281 1373281 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2020   grade_10 173 2 10 1   0     0   1   91 96 *                     187.0 173 2 10 1   0     0   1   91 96                 187
1373392 1373392 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_7 159 5 5 0   10     0   5   88 96 *                     184.0 159 5 5 0   10     0   5   88 96                 184
1373397 1373397 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No High 09 12 2020   grade_12 169 1 1 0   11     1   0   87 96 *                     183.0 169 1 1 0   11     1   0   87 96                 183
1373724 1373724 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester Regional Jr High   Regular School No Middle 07 08 2020   grade_7 186 6 5 0   4     0   13   118 96 *                     214.0 186 6 5 0   4     0   13   118 96                 214
1365051 1365051 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2020   grade_8 171 4 17 0   10     0   7   114 95 *                     209.0 171 4 17 0   10     0   7   114 95                 209
1365053 1365053 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_9 156 5 24 0   7     0   4   101 95 *                     196.0 156 5 24 0   7     0   4   101 95                 196
1366561 1366561 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2020   grade_5 131 5 14 0   27     1   14   97 95 *                     192.0 131 5 14 0   27     1   14   97 95                 192
1367241 1367241 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No High 09 12 2020   grade_11 157 8 7 1   4     0   10   91 95 *                     187.0 157 8 7 1   4     0   10   91 95                 187
1367256 1367256 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Middle School   Regular School No Middle 05 08 2020   grade_5 57 11 84 0   5     0   18   80 95 *                     175.0 57 11 84 0   5     0   18   80 95                 175
1367606 1367606 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary 02 04 2020   grade_3 194 2 7 0   3     0   1   112 95 *                     207.0 194 2 7 0   3     0   1   112 95                 207
1368400 1368400 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2020   grade_7 55 11 70 0   26     0   13   80 95 *                     175.0 55 11 70 0   26     0   13   80 95                 175
1370358 1370358 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2020   grade_6 145 11 32 0   3     0   3   99 95 *                     194.0 145 11 32 0   3     0   3   99 95                 194
1371246 1371246 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Joseph Case Jr High   Regular School No Middle 06 08 2020   grade_8 189 3 6 0   1     0   1   105 95 *                     200.0 189 3 6 0   1     0   1   105 95                 200
1371595 1371595 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2020   grade_10 126 8 8 0   43     1   12   103 95 *                     198.0 126 8 8 0   43     1   12   103 95                 198
1371788 1371788 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2020   grade_7 141 2 6 0   46     0   7   107 95 *                     202.0 141 2 6 0   46     0   7   107 95                 202
1372456 1372456 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter School   Regular School Yes High 05 12 2020   grade_9 26 14 130 4   2     2   0   83 95 *                     178.0 26 14 130 4   2     2   0   83 95                 178
1373046 1373046 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No High 09 12 2020   grade_9 104 20 35 0   23     0   23   110 95 *                     205.0 104 20 35 0   23     0   23   110 95                 205
1373282 1373282 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2020   grade_11 195 3 4 0   0     0   6   113 95 *                     208.0 195 3 4 0   0     0   6   113 95                 208
1373346 1373346 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No High 09 12 2020   grade_9 185 3 1 0   1     0   1   96 95 *                     191.0 185 3 1 0   1     0   1   96 95                 191
1373465 1373465 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573002141 6800310 Wilbraham Middle   Regular School No Middle 06 08 2020   grade_7 167 5 14 0   7     0   5   103 95 *                     198.0 167 5 14 0   7     0   5   103 95                 198
1366017 1366017 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2020   grade_6 20 7 150 0   8     0   4   95 94 *                     189.0 20 7 150 0   8     0   4   95 94                 189
1366064 1366064 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne Middle School   Regular School No Middle 06 08 2020   grade_6 149 5 8 4   4     0   4   80 94 *                     174.0 149 5 8 4   4     0   4   80 94                 174
1366199 1366199 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2020   grade_4 49 96 32 1   10     0   11   105 94 *                     199.0 49 96 32 1   10     0   11   105 94                 199
1366595 1366595 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2020   grade_6 11 6 171 1   1     1   2   99 94 *                     193.0 11 6 171 1   1     1   2   99 94                 193
1366843 1366843 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2020   grade_9 117 15 28 0   5     0   4   75 94 *                     169.0 117 15 28 0   5     0   4   75 94                 169
1366911 1366911 MA Plymouth   school 2504410 82   Duxbury 250441000968 820004 Alden School   Regular School No Elementary 03 05 2020   grade_5 170 1 4 0   3     0   18   102 94 *                     196.0 170 1 4 0   3     0   18   102 94                 196
1366982 1366982 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2020   grade_9 175 11 22 0   11     0   2   127 94 *                     221.0 175 11 22 0   11     0   2   127 94                 221
1367452 1367452 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2020   grade_8 131 6 41 0   1     0   12   97 94 *                     191.0 131 6 41 0   1     0   12   97 94                 191
1368436 1368436 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2020   grade_8 171 3 19 0   1     0   5   105 94 *                     199.0 171 3 19 0   1     0   5   105 94                 199
1368633 1368633 MA Essex   school 2507140 164   Lynnfield 250714001090 1640505 Lynnfield High   Regular School No High 09 12 2020   grade_11 147 2 12 0   9     0   3   78 94 *                     173.0 147 2 12 0   9     0   3   78 94                 173

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