Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by female

View and edit SQL

year

grade

  • grade_9 · 2,637
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
740301 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2015   grade_9 177 2 8 0   1     0   7   94 101                       195 177 2 8 0   1     0   7   94 101                 195
740948 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No 3 09 12 2015   grade_9 146 32 24 0   4     0   15   120 101                       221 146 32 24 0   4     0   15   120 101                 221
939772 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No 3 09 12 2016   grade_9 186 2 6 1   11     0   5   110 101                       211 186 2 6 1   11     0   5   110 101                 211
941480 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2016   grade_9 169 3 4 0   7     0   3   85 101                       186 169 3 4 0   7     0   3   85 101                 186
941954 MA Bristol   school 2503070 910   Bristol County Agricultural 250307000382 9100705 Bristol County Agricultural High   Vocational Education School No 3 09 12 2016   grade_9 118 0 3 1   0     0   4   25 101                       126 118 0 3 1   0     0   4   25 101                 126
1126790 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2017   grade_9 183 2 7 0   12     0   3   106 101                       207 183 2 7 0   12     0   3   106 101                 207
1129733 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2017   grade_9 218 3 10 0   10     1   1   142 101                       243 218 3 10 0   10     1   1   142 101                 243
1367915 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2020   grade_9 144 4 30 1   2     0   9   89 101 *                     190.0 144 4 30 1   2     0   9   89 101                 190
1369933 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2020   grade_9 200 2 3 0   3     0   0   107 101 *                     208.0 200 2 3 0   3     0   0   107 101                 208
1370426 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem High   Regular School No High 09 12 2020   grade_9 104 14 110 0   2     0   7   136 101 *                     237.0 104 14 110 0   2     0   7   136 101                 237
1675679 MA Hampden   school 2507050 161   Ludlow 250705001056 1610505 Ludlow - Ludlow Senior High   Regular School No High 09 12 2021   grade_9 179 3 20 0   1     0   8   110 101 *                     211.0 179 3 20 0   1     0   8   110 101                 211
2046219 MA Norfolk   school 2511250 285   Stoughton 251125001864 2850505 Stoughton High   Regular School No High 09 12 2019   grade_9 128 62 20 0   13     1   14   137 101                       238.0 128 62 20 0   13     1   14   137 101                 238
2048317 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2019   grade_9 127 22 27 3   3     0   11   92 101                       193.0 127 22 27 3   3     0   11   92 101                 193
2048786 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2019   grade_9 186 4 4 0   2     0   10   105 101                       206.0 186 4 4 0   2     0   10   105 101                 206
2049241 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 238 3 17 1   4     2   10   174 101                       275.0 238 3 17 1   4     2   10   174 101                 275
740952 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2015   grade_9 145 18 15 0   2     0   13   91 102                       193 145 18 15 0   2     0   13   91 102                 193
744891 MA Essex   school 2511740 773   Triton 251174001932 7730505 Triton Regional High School   Regular School No 3 09 12 2015   grade_9 183 0 1 0   6     0   0   88 102                       190 183 0 1 0   6     0   0   88 102                 190
941116 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Apponequet Regional High   Regular School No 3 09 12 2016   grade_9 179 4 4 1   1     0   8   95 102                       197 179 4 4 1   1     0   8   95 102                 197
1125690 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2017   grade_9 176 4 14 0   2     0   1   95 102                       197 176 4 14 0   2     0   1   95 102                 197
1127818 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No High 09 12 2017   grade_9 198 1 3 0   5     0   1   106 102                       208 198 1 3 0   5     0   1   106 102                 208
2229082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_9 155 3 6 1   11     0   5   79 102                       181.0 155 3 6 1   11     0   5   79 102                 181
2231286 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut: Dracut Senior High   Regular School No High 09 12 2018   grade_9 165 15 14 2   23     0   6   123 102                       225.0 165 15 14 2   23     0   6   123 102                 225
2233611 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield: Medfield Senior High   Regular School No High 09 12 2018   grade_9 175 2 4 0   10     0   8   97 102                       199.0 175 2 4 0   10     0   8   97 102                 199
2238944 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Freetown-Lakeville: Apponequet Regional High   Regular School No High 09 12 2018   grade_9 197 1 4 0   3     0   3   106 102                       208.0 197 1 4 0   3     0   3   106 102                 208
742541 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No 3 09 12 2015   grade_9 158 10 6 0   34     1   9   115 103                       218 158 10 6 0   34     1   9   115 103                 218
744337 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2015   grade_9 196 1 2 0   9     0   1   106 103                       209 196 1 2 0   9     0   1   106 103                 209
745123 MA Norfolk   school 2511735 878   Tri County Regional Vocational Technical 251173501931 8780605 Tri County Regional Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 227 0 13 0   1     0   9   147 103                       250 227 0 13 0   1     0   9   147 103                 250
934450 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No 3 09 12 2016   grade_9 108 7 73 0   2     0   4   91 103                       194 108 7 73 0   2     0   4   91 103                 194
937137 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No 3 09 12 2016   grade_9 172 3 12 0   3     0   2   89 103                       192 172 3 12 0   3     0   2   89 103                 192
937553 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood High   Regular School No 3 09 12 2016   grade_9 166 24 14 0   9     0   7   117 103                       220 166 24 14 0   9     0   7   117 103                 220
941473 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No 3 09 12 2016   grade_9 174 2 3 0   2     0   5   83 103                       186 174 2 3 0   2     0   5   83 103                 186
1127413 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2017   grade_9 161 1 9 0   5     0   4   77 103                       180 161 1 9 0   5     0   4   77 103                 180
1371322 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No High 09 12 2020   grade_9 173 9 6 1   7     0   2   95 103 *                     198.0 173 9 6 1   7     0   2   95 103                 198
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
1680310 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst-Pelham - Amherst Regional High   Regular School No High 09 12 2021   grade_9 120 20 42 0   11     0   19   108 103 *                     212.0 120 20 42 0   11     0   19   108 103                 212
2046302 MA Essex   school 2511430 291   Swampscott 251143001887 2910505 Swampscott High   Regular School No High 09 12 2019   grade_9 139 9 26 0   7     0   2   80 103                       183.0 139 9 26 0   7     0   2   80 103                 183
2234639 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading: North Reading High   Regular School No High 09 12 2018   grade_9 178 3 3 0   6     0   5   92 103                       195.0 178 3 3 0   6     0   5   92 103                 195
744687 MA Essex   school 2509450 745   Pentucket 250945001513 7450505 Pentucket Regional Sr High   Regular School No 3 09 12 2015   grade_9 181 0 2 0   5     0   4   88 104                       192 181 0 2 0   5     0   4   88 104                 192
934758 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2016   grade_9 175 11 9 1   7     1   1   101 104                       205 175 11 9 1   7     1   1   101 104                 205
936775 MA Plymouth   school 2507770 182   Middleborough 250777001227 1820505 Middleborough High   Regular School No 3 09 12 2016   grade_9 164 8 9 0   4     0   9   90 104                       194 164 8 9 0   4     0   9   90 104                 194
1122198 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2017   grade_9 142 5 27 1   24     0   3   98 104                       202 142 5 27 1   24     0   3   98 104                 202
1124469 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2017   grade_9 174 20 10 0   11     0   5   116 104                       220 174 20 10 0   11     0   5   116 104                 220
1125223 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2017   grade_9 180 2 10 0   24     0   5   117 104                       221 180 2 10 0   24     0   5   117 104                 221
1130567 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2017   grade_9 186 6 7 0   11     0   1   107 104                       211 186 6 7 0   11     0   1   107 104                 211
1374181 MA Norfolk   school 2508650 915   Norfolk County Agricultural 250865001386 9150705 Norfolk County Agricultural   Career and Technical School No High 09 12 2020   grade_9 134 1 0 0   1     1   7   40 104 *                     144.0 134 1 0 0   1     1   7   40 104                 144
1672350 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown - Belchertown High   Regular School No High 09 12 2021   grade_9 154 4 10 0   2     1   3   69 104 *                     174.0 154 4 10 0   2     1   3   69 104                 174
1680612 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000746 6650505 Freetown-Lakeville - Apponequet Regional High   Regular School No High 09 12 2021   grade_9 191 2 4 0   0     0   1   94 104 *                     198.0 191 2 4 0   0     0   1   94 104                 198
2239587 MA Worcester   school 2511490 770   Tantasqua 251149001900 7700505 Tantasqua: Tantasqua Regional Sr High   Regular School No High 09 12 2018   grade_9 156 3 12 0   1     0   2   70 104                       174.0 156 3 12 0   1     0   2   70 104                 174
743993 MA Hampshire   school 2501920 605   Amherst-Pelham 250192000042 6050505 Amherst Regional High   Regular School No 3 09 12 2015   grade_9 150 15 32 0   24     0   23   139 105                       244 150 15 32 0   24     0   23   139 105                 244
744649 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No 3 09 12 2015   grade_9 194 3 3 0   1     0   3   99 105                       204 194 3 3 0   1     0   3   99 105                 204
1132531 MA Middlesex   school 2508790 735   North Middlesex 250879001415 7350505 North Middlesex Regional   Regular School No High 09 12 2017   grade_9 185 3 12 0   2     0   6   103 105                       208 185 3 12 0   2     0   6   103 105                 208
1366786 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2020   grade_9 177 4 18 0   7     0   5   105 105 *                     211.0 177 4 18 0   7     0   5   105 105                 211
1674212 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow - East Longmeadow High   Regular School No High 09 12 2021   grade_9 171 7 11 0   9     0   5   98 105 *                     203.0 171 7 11 0   9     0   5   98 105                 203
2044623 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No High 09 12 2019   grade_9 166 3 20 1   7     0   14   106 105                       211.0 166 3 20 1   7     0   14   106 105                 211
2048342 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2019   grade_9 181 3 13 1   1     0   3   97 105                       202.0 181 3 13 1   1     0   3   97 105                 202
2237395 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington: Wilmington High   Regular School No High 09 12 2018   grade_9 166 4 6 0   14     0   8   93 105                       198.0 166 4 6 0   14     0   8   93 105                 198
2239483 MA Worcester   school 2500001 753   Quabbin 250000101558 7530505 Quabbin: Quabbin Regional High School   Regular School No High 09 12 2018   grade_9 183 1 5 0   1     0   11   96 105                       201.0 183 1 5 0   1     0   11   96 105                 201
933670 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2016   grade_9 17 89 147 0   33     0   2   182 106                       288 17 89 147 0   33     0   2   182 106                 288
1125534 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2017   grade_9 199 1 4 0   15     0   6   119 106                       225 199 1 4 0   15     0   6   119 106                 225
1128167 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2017   grade_9 159 25 19 0   5     0   8   110 106                       216 159 25 19 0   5     0   8   110 106                 216
1130051 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2017   grade_9 150 12 14 0   26     0   12   108 106                       214 150 12 14 0   26     0   12   108 106                 214
1370520 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2020   grade_9 184 2 2 0   1     0   1   84 106 *                     190.0 184 2 2 0   1     0   1   84 106                 190
1676614 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport - Newburyport High   Regular School No High 09 12 2021   grade_9 181 3 7 0   8     0   3   95 106 *                     202.0 181 3 7 0   8     0   3   95 106                 202
1677772 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate - Scituate High School   Regular School No High 09 12 2021   grade_9 196 3 6 0   2     0   4   105 106 *                     211.0 196 3 6 0   2     0   4   105 106                 211
1678844 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland - Wayland High School   Regular School No High 09 12 2021   grade_9 144 12 7 0   38     0   12   107 106 *                     213.0 144 12 7 0   38     0   12   107 106                 213
2048382 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2019   grade_9 185 9 7 0   3     1   8   106 106                       213.0 185 9 7 0   3     1   8   106 106                 213
2229004 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_9 151 4 23 0   19     0   9   99 106                       206.0 151 4 23 0   19     0   9   99 106                 206
2232154 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover: Hanover High   Regular School No High 09 12 2018   grade_9 193 3 4 0   6     0   0   100 106                       206.0 193 3 4 0   6     0   0   100 106                 206
2234908 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke: Pembroke High School   Regular School No High 09 12 2018   grade_9 202 3 2 0   2     0   1   104 106                       210.0 202 3 2 0   2     0   1   104 106                 210
2234989 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield: Pittsfield High   Regular School No High 09 12 2018   grade_9 152 22 30 1   5     0   13   116 106                       223.0 152 22 30 1   5     0   13   116 106                 223
738832 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No 3 08 12 2015   grade_9 184 4 12 1   3     0   3   100 107                       207 184 4 12 1   3     0   3   100 107                 207
742273 MA Middlesex   school 2511580 295   Tewksbury 251158001926 2950505 Tewksbury Memorial High   Regular School No 3 09 12 2015   grade_9 229 3 6 0   2     1   0   134 107                       241 229 3 6 0   2     1   0   134 107                 241
932862 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_9 152 18 14 1   19     2   16   115 107                       222 152 18 14 1   19     2   16   115 107                 222
1124396 MA Norfolk   school 2504050 73   Dedham 250405000548 730505 Dedham High   Regular School No High 09 12 2017   grade_9 143 27 32 0   4     0   2   101 107                       208 143 27 32 0   4     0   2   101 107                 208
1125180 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2017   grade_9 183 5 27 0   4     1   6   119 107                       226 183 5 27 0   4     1   6   119 107                 226
1366376 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2020   grade_9 149 15 15 1   30     0   11   114 107 *                     221.0 149 15 15 1   30     0   11   114 107                 221
1366905 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2020   grade_9 166 15 16 3   19     0   6   118 107 *                     225.0 166 15 16 3   19     0   6   118 107                 225
1371410 MA Middlesex   school 2511910 305   Wakefield 251191001951 3050505 Wakefield Memorial High   Regular School No High 09 12 2020   grade_9 182 9 17 0   7     0   4   112 107 *                     219.0 182 9 17 0   7     0   4   112 107                 219
1680585 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset - Nauset Regional High   Regular School No High 09 12 2021   grade_9 162 9 12 0   5     0   4   85 107 *                     192.0 162 9 12 0   5     0   4   85 107                 192
2042053 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No High 09 12 2019   grade_9 174 7 17 0   15     0   1   107 107                       214.0 174 7 17 0   15     0   1   107 107                 214
2042581 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2019   grade_9 193 5 32 0   2     2   4   131 107                       238.0 193 5 32 0   2     2   4   131 107                 238
2230085 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Boston: Charlestown High   Regular School No High 09 12 2018   grade_9 12 85 152 0   17     0   3   162 107                       269.0 12 85 152 0   17     0   3   162 107                 269
2234235 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport: Newburyport High   Regular School No High 09 12 2018   grade_9 195 0 4 0   5     0   4   101 107                       208.0 195 0 4 0   5     0   4   101 107                 208
2239365 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester: Old Rochester Regional High   Regular School No High 09 12 2018   grade_9 179 7 2 0   3     0   8   92 107                       199.0 179 7 2 0   3     0   8   92 107                 199
738983 MA Essex   school 2506660 149   Lawrence 250666002636 1490531 Health & Human Services High School   Regular School No 3 09 12 2015   grade_9 5 2 151 0   3     0   0   53 108                       161 5 2 151 0   3     0   0   53 108                 161
744657 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No 3 09 12 2015   grade_9 196 5 1 1   7     0   2   104 108                       212 196 5 1 1   7     0   2   104 108                 212
1124197 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_9 121 7 105 0   2     0   1   128 108                       236 121 7 105 0   2     0   1   128 108                 236
1128086 MA Plymouth   school 2509420 231   Pembroke 250942001824 2310505 Pembroke High School   Regular School No High 09 12 2017   grade_9 199 2 0 0   4     1   1   99 108                       207 199 2 0 0   4     1   1   99 108                 207
1132004 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2017   grade_9 138 18 22 1   4     0   11   86 108                       194 138 18 22 1   4     0   11   86 108                 194
1371594 MA Middlesex   school 2512210 315   Wayland 251221002010 3150505 Wayland High School   Regular School No High 09 12 2020   grade_9 131 9 8 0   38     0   16   94 108 *                     202.0 131 9 8 0   38     0   16   94 108                 202
1677679 MA Essex   school 2510380 258   Salem 251038001664 2580505 Salem - Salem High   Regular School No High 09 12 2021   grade_9 77 19 133 0   7     0   12   140 108 *                     248.0 77 19 133 0   7     0   12   140 108                 248
1681413 MA Norfolk   school 2511735 878   Tri-County Regional Vocational Technical 251173501931 8780605 Tri-County Regional Vocational Technical - Tri-County Regional Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 214 6 25 0   1     0   14   150 108 *                     260.0 214 6 25 0   1     0   14   150 108                 260
2045077 MA Berkshire   school 2509630 236   Pittsfield 250963001526 2360505 Pittsfield High   Regular School No High 09 12 2019   grade_9 153 20 21 0   2     0   15   103 108                       211.0 153 20 21 0   2     0   15   103 108                 211
2047067 MA Middlesex   school 2513050 342   Wilmington 251305002158 3420505 Wilmington High   Regular School No High 09 12 2019   grade_9 175 3 14 0   9     0   7   100 108                       208.0 175 3 14 0   9     0   7   100 108                 208
736803 MA Suffolk   school 2502790 35   Boston 250279000215 350515 Charlestown High   Regular School No 3 09 12 2015   grade_9 13 115 110 1   33     0   5   168 109                       277 13 115 110 1   33     0   5   168 109                 277
1128791 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No High 09 12 2017   grade_9 206 10 0 0   4     0   6   117 109                       226 206 10 0 0   4     0   6   117 109                 226
1366919 MA Plymouth   school 2504410 82   Duxbury 250441000594 820505 Duxbury High   Regular School No High 09 12 2020   grade_9 228 0 6 0   2     0   8   135 109 *                     244.0 228 0 6 0   2     0   8   135 109                 244
1368837 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No High 09 12 2020   grade_9 172 3 4 1   12     0   7   90 109 *                     199.0 172 3 4 1   12     0   7   90 109                 199
1370008 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No High 09 12 2020   grade_9 137 27 24 0   3     0   28   109 109 *                     219.0 137 27 24 0   3     0   28   109 109                 219
1681365 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 South Middlesex Regional Vocational Technical - Joseph P Keefe Technical High School   Career and Technical School No High 09 12 2021   grade_9 123 6 81 5   4     0   7   116 109 *                     226.0 123 6 81 5   4     0   7   116 109                 226

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