Data source: Big Local News · About: Big Local

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

View and edit SQL

year

grade

  • grade_9 · 2,737
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
737827 MA Middlesex   school 2504320 79   Dracut 250432002800 790515 Parker Avenue School   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   * *                       2                                             2
939288 MA Plymouth   school 2512060 310   Wareham 251206002668 3100310 West Academy   Regular School No N N N 2016   grade_9 * * * *   *     *   *   * *                       1                                             1
1125195 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1368466 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1675707 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
2046144 MA Hampden   school 2511130 281   Springfield 251113002743 2810575 Gateway to College at Holyoke Community College   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   * 1                       1.0                           1                 1
2230212 MA Suffolk   school   35   Boston   350652               2018   grade_9 * * * *   *     *   *   * *                       1.0                                             1
2231646 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2232024 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
2237230 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
736239 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No 3 07 12 2015   grade_9 * * * *   *     *   *   1 2                       3                         1 2                 3
742025 MA Hampden   school 2511130 281   Springfield 251113002809 2810580 Gateway to College at Springfield Technical Community College   Alternative Education School No 3 09 12 2015   grade_9 * * * *   *     *   *   1 3                       4                         1 3                 4
936655 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No 3 09 12 2016   grade_9 * * * *   *     *   *   1 *                       1                         1                   1
939787 MA Worcester   school 2513080 343   Winchendon 251308002843 3430405 Murdock Academy for Success   Alternative Education School No 4 06 12 2016   grade_9 * * * *   *     *   *   1 4                       5                         1 4                 5
1122639 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1123330 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1124914 MA Worcester   school 2504890 97   Fitchburg 250489002110 970510 Goodrich Academy   Regular School No High 09 12 2017   grade_9 6 1 2 0   0     0   0   1 8                       9 6 1 2 0   0     0   0   1 8                 9
1128679 MA Essex   school 2510380 258   Salem 251038002864 2580510 New Liberty Innovation School   Regular School No High 09 12 2017   grade_9 * * * *   *     *   *   1 1                       *                         1 1                  
1128685 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1131458 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_9 * * * *   *     *   *   1 2                       *                         1 2                  
1131925 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_9 * * * *   *     *   *   1 *                       *                         1                    
1672372 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham - Keough Memorial Academy   Alternative School No High 08 12 2021   grade_9 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1673484 MA Plymouth   school 2503090 44   Brockton 250309002752 440520 Brockton - Edison Academy   Regular School No High 09 12 2021   grade_9 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1680044 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_9 6 0 2 0   0     0   1   1 8 *                     9.0 6 0 2 0   0     0   1   1 8                 9
2041676 MA Suffolk   school 2503540 57   Chelsea 250354002890 570515 Chelsea Opportunity Academy   Alternative School No High 09 12 2019   grade_9 * * * *   *     *   *   1 4                       5.0                         1 4                 5
2043952 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Curtis-Tufts   Regular School No High 09 12 2019   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2229198 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Bellingham: Keough Memorial Academy   Alternative School No High 08 12 2018   grade_9 * * * *   *     *   *   1 3                       4.0                         1 3                 4
2229453 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Boston: Carter Developmental Center   Regular School No High 07 12 2018   grade_9 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2230269 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston: Horace Mann School for the Deaf   Special Education School No Other PK 12 2018   grade_9 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2230274 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston: Boston Collaborative High School   Alternative School No High 09 12 2018   grade_9 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2233662 MA Middlesex   school 2507560 176   Medford 250756002393 1760510 Medford: Curtis-Tufts   Regular School No High 09 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
2234772 MA Worcester   school 2509270 226   Oxford 250927002810 2260305 Oxford: Project C.O.F.F.E.E.   Special Education School No High 08 12 2018   grade_9 * * * *   *     *   *   1 *                       1.0                         1                   1
737142 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative Education School No 4 04 12 2015   grade_9 7 3 5 0   0     0   0   10 5                       15 7 3 5 0   0     0   0   10 5                 15
1368064 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other KG 12 2020   grade_9 2 0 9 0   0     0   0   10 1 *                     11.0 2 0 9 0   0     0   0   10 1                 11
1372965 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_9 13 0 3 0   5     1   4   10 16 *                     26.0 13 0 3 0   5     1   4   10 16                 26
1675659 MA Middlesex   school 2507020 160   Lowell 250702002860 1600515 Lowell - The Career Academy   Regular School No High 09 12 2021   grade_9 3 0 5 0   5     0   0   10 3 *                     13.0 3 0 5 0   5     0   0   10 3                 13
2044418 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_9 8 1 6 0   0     0   2   10 7                       17.0 8 1 6 0   0     0   2   10 7                 17
2230484 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_9 3 3 6 0   0     0   1   10 3                       13.0 3 3 6 0   0     0   1   10 3                 13
737904 MA Hampden   school 2504500 87   East Longmeadow 250450000603 870505 East Longmeadow High   Regular School No 3 09 12 2015   grade_9 190 7 6 0   8     0   1   100 112                       212 190 7 6 0   8     0   1   100 112                 212
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
745043 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 128 4 18 0   1     0   11   100 62                       162 128 4 18 0   1     0   11   100 62                 162
1132081 MA Barnstable   school 2504560 660   Nauset 250456000610 6600505 Nauset Regional High   Regular School No High 09 12 2017   grade_9 185 13 1 1   8     0   11   100 119                       219 185 13 1 1   8     0   11   100 119                 219
1373726 MA Plymouth   school 2509150 740   Old Rochester 250915001472 7400505 Old Rochester Regional High   Regular School No High 09 12 2020   grade_9 154 4 4 0   4     0   8   100 74 *                     174.0 154 4 4 0   4     0   8   100 74                 174
1374169 MA Barnstable   school 2511800 879   Upper Cape Cod Regional Vocational Technical 251180002296 8790605 Upper Cape Cod Vocational Technical   Career and Technical School No High 09 12 2020   grade_9 141 9 7 1   1     1   13   100 73 *                     173.0 141 9 7 1   1     1   13   100 73                 173
1678001 MA Worcester   school 2511010 277   Southbridge 251101002868 2770515 Southbridge - Southbridge High School   Regular School No High 09 12 2021   grade_9 57 5 104 1   3     0   1   100 71 *                     171.0 57 5 104 1   3     0   1   100 71                 171
1681393 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Regional Vocational Technical - Pathfinder Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 153 0 3 0   0     0   0   100 56 *                     156.0 153 0 3 0   0     0   0   100 56                 156
2042866 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston High   Regular School No High 09 12 2019   grade_9 181 3 8 0   21     0   5   100 118                       218.0 181 3 8 0   21     0   5   100 118                 218
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
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
738979 MA Essex   school 2506660 149   Lawrence 250666002627 1490530 Business Management & Finance High School   Regular School No 3 09 12 2015   grade_9 10 3 133 0   1     0   0   101 46                       147 10 3 133 0   1     0   0   101 46                 147
932805 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_9 170 6 7 0   12     0   5   101 99                       200 170 6 7 0   12     0   5   101 99                 200
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
935007 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth High   Regular School No 3 09 12 2016   grade_9 183 10 5 6   9     0   10   101 122                       223 183 10 5 6   9     0   10   101 122                 223
936611 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2016   grade_9 177 1 3 0   13     1   3   101 97                       198 177 1 3 0   13     1   3   101 97                 198
937498 MA Bristol   school 2509000 218   Norton 250900001451 2180505 Norton High   Regular School No 3 09 12 2016   grade_9 171 5 3 0   5     0   3   101 86                       187 171 5 3 0   5     0   3   101 86                 187
938294 MA Plymouth   school 2510560 264   Scituate 251056001693 2640505 Scituate High School   Regular School No 3 09 12 2016   grade_9 199 9 0 0   3     0   2   101 112                       213 199 9 0 0   3     0   2   101 112                 213
941163 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000807 6730505 Groton Dunstable Regional   Regular School No 3 09 12 2016   grade_9 180 4 2 0   11     0   4   101 100                       201 180 4 2 0   11     0   4   101 100                 201
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
1124953 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No High 09 12 2017   grade_9 178 14 9 0   6     0   5   101 111                       212 178 14 9 0   6     0   5   101 111                 212
1132992 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2017   grade_9 117 11 20 1   2     0   9   101 59                       160 117 11 20 1   2     0   9   101 59                 160
1133077 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 So Shore Vocational Technical High   Career and Technical School No High 09 12 2017   grade_9 140 3 8 0   0     0   7   101 57                       158 140 3 8 0   0     0   7   101 57                 158
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
1674782 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton - Grafton High School   Regular School No High 09 12 2021   grade_9 163 7 13 2   22     1   5   101 112 *                     213.0 163 7 13 2   22     1   5   101 112                 213
1677027 MA Norfolk   school 2509060 220   Norwood 250906001466 2200505 Norwood - Norwood High   Regular School No High 09 12 2021   grade_9 142 27 33 0   16     1   5   101 123 *                     224.0 142 27 33 0   16     1   5   101 123                 224
1680544 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth - Dighton-Rehoboth Regional High School   Regular School No High 09 12 2021   grade_9 158 3 9 0   4     0   6   101 79 *                     180.0 158 3 9 0   4     0   6   101 79                 180
1681369 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional Vocational Technical - Minuteman Regional High   Career and Technical School No High 09 12 2021   grade_9 136 9 17 1   4     0   12   101 78 *                     179.0 136 9 17 1   4     0   12   101 78                 179
2049162 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2019   grade_9 107 12 21 3   1     1   7   101 51                       152.0 107 12 21 3   1     1   7   101 51                 152
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
738535 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2015   grade_9 185 1 2 0   2     0   1   102 89                       191 185 1 2 0   2     0   1   102 89                 191
745089 MA Middlesex   school 2508320 852   Nashoba Valley Regional Vocational Technical 250832001290 8520605 Nashoba Valley Technical High School   Vocational Education School No 3 09 12 2015   grade_9 175 0 10 1   1     0   8   102 93                       195 175 0 10 1   1     0   8   102 93                 195
1365930 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2020   grade_9 4 61 112 0   1     0   3   102 79 *                     181.0 4 61 112 0   1     0   3   102 79                 181
1373255 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000558 6450505 Dennis-Yarmouth Regional High   Regular School No High 08 12 2020   grade_9 127 22 23 3   5     0   7   102 85 *                     187.0 127 22 23 3   5     0   7   102 85                 187
1674473 MA Barnstable   school 2504860 96   Falmouth 250486000686 960505 Falmouth - Falmouth High   Regular School No High 09 12 2021   grade_9 158 15 13 0   2     0   11   102 97 *                     199.0 158 15 13 0   2     0   11   102 97                 199
2232349 MA Middlesex   school 2506240 136   Holliston 250624000894 1360505 Holliston: Holliston High   Regular School No High 09 12 2018   grade_9 175 2 5 2   15     0   3   102 100                       202.0 175 2 5 2   15     0   3   102 100                 202
739767 MA Norfolk   school 2507530 175   Medfield 250753001157 1750505 Medfield Senior High   Regular School No 3 09 12 2015   grade_9 206 1 2 0   9     1   7   103 123                       226 206 1 2 0   9     1   7   103 123                 226
740651 MA Middlesex   school 2508820 217   North Reading 250882001422 2170505 North Reading High   Regular School No 3 09 12 2015   grade_9 206 1 7 0   9     2   1   103 123                       226 206 1 7 0   9     2   1   103 123                 226
745101 MA Hampden   school 2509310 860   Pathfinder Regional Vocational Technical 250931002285 8600605 Pathfinder Vocational Technical   Vocational Education School No 3 09 12 2015   grade_9 153 1 12 1   2     0   7   103 73                       176 153 1 12 1   2     0   7   103 73                 176
937780 MA Berkshire   school 2509630 236   Pittsfield 250963001534 2360510 Taconic High   Regular School No 3 09 12 2016   grade_9 118 29 13 0   2     0   14   103 73                       176 118 29 13 0   2     0   14   103 73                 176
941893 MA Middlesex   school 2511060 829   South Middlesex Regional Vocational Technical 251106002291 8290605 Joseph P Keefe Technical High School   Vocational Education School No 3 09 12 2016   grade_9 75 7 82 2   1     0   5   103 69                       172 75 7 82 2   1     0   5   103 69                 172
1128590 MA Plymouth   school 2510170 251   Rockland 251017001643 2510505 Rockland Senior High   Regular School No High 09 12 2017   grade_9 154 9 23 0   0     0   10   103 93                       196 154 9 23 0   0     0   10   103 93                 196
1130448 MA Norfolk   school 2512810 335   Westwood 251281002100 3350505 Westwood High   Regular School No High 09 12 2017   grade_9 195 10 4 0   23     0   5   103 134                       237 195 10 4 0   23     0   5   103 134                 237
1132032 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000568 6500505 Dighton-Rehoboth Regional High School   Regular School No High 09 12 2017   grade_9 172 2 11 0   5     0   1   103 88                       191 172 2 11 0   5     0   1   103 88                 191
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
1365126 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2020   grade_9 171 4 6 0   3     1   7   103 89 *                     192.0 171 4 6 0   3     1   7   103 89                 192
1369365 MA Essex   school 2508580 204   Newburyport 250858001354 2040505 Newburyport High   Regular School No High 09 12 2020   grade_9 201 0 10 0   1     0   4   103 113 *                     216.0 201 0 10 0   1     0   4   103 113                 216
1674863 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover - Hanover High   Regular School No High 09 12 2021   grade_9 171 2 3 0   5     0   1   103 79 *                     182.0 171 2 3 0   5     0   1   103 79                 182
1676182 MA Middlesex   school 2507620 178   Melrose 250762001193 1780505 Melrose - Melrose High   Regular School No High 09 12 2021   grade_9 164 26 19 0   6     0   6   103 118 *                     221.0 164 26 19 0   6     0   6   103 118                 221
1681336 MA Barnstable   school 2503310 815   Cape Cod Regional Vocational Technical 250331002264 8150605 Cape Cod Regional Vocational Technical - Cape Cod Region Vocational Technical   Career and Technical School No High 09 12 2021   grade_9 128 14 16 4   1     1   10   103 70 *                     174.0 128 14 16 4   1     1   10   103 70                 174
1681405 MA Plymouth   school 2510930 873   South Shore Regional Vocational Technical 251093001756 8730605 South Shore Regional Vocational Technical - So Shore Vocational Technical High   Career and Technical School No High 09 12 2021   grade_9 154 4 10 0   0     0   0   103 65 *                     168.0 154 4 10 0   0     0   0   103 65                 168
2040017 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_9 156 7 24 1   28     0   8   103 121                       224.0 156 7 24 1   28     0   8   103 121                 224
2041446 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No Other 09 12 2019   grade_9 140 19 15 2   30     0   11   103 114                       217.0 140 19 15 2   30     0   11   103 114                 217
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
738233 MA Norfolk   school 2504950 99   Foxborough 250495000708 990505 Foxborough High   Regular School No 3 09 12 2015   grade_9 171 14 2 0   3     1   0   104 87                       191 171 14 2 0   3     1   0   104 87                 191
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
745077 MA Middlesex   school 2507985 830   Minuteman Regional Vocational Technical 250798501264 8300605 Minuteman Regional High   Vocational Education School No 3 09 12 2015   grade_9 117 11 14 0   4     0   2   104 44                       148 117 11 14 0   4     0   2   104 44                 148
932876 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2016   grade_9 167 7 11 0   3     0   4   104 88                       192 167 7 11 0   3     0   4   104 88                 192
937321 MA Hampshire   school 2508850 210   Northampton 250885001432 2100505 Northampton High   Regular School No 3 09 12 2016   grade_9 174 6 28 0   12     0   9   104 125                       229 174 6 28 0   12     0   9   104 125                 229

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