Data source: Big Local News · About: Big Local

2,758 rows where grade = "grade_10" and state = "MA" sorted by school_state_id

View and edit SQL

year

grade

  • grade_10 · 2,758
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
735669 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_10 82 3 10 0   0     0   1   46 50                       96 82 3 10 0   0     0   1   46 50                 96
932547 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_10 107 2 14 0   0     0   3   60 66                       126 107 2 14 0   0     0   3   60 66                 126
1121961 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_10 91 4 10 0   3     1   0   50 59                       109 91 4 10 0   3     1   0   50 59                 109
1364795 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_10 127 10 12 0   4     0   3   80 76 *                     156.0 127 10 12 0   4     0   3   80 76                 156
1672019 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_10 121 8 22 0   7     0   2   80 80 *                     160.0 121 8 22 0   7     0   2   80 80                 160
2039821 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_10 127 6 13 0   2     0   1   79 70                       149.0 127 6 13 0   2     0   1   79 70                 149
2228769 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_10 109 3 11 1   4     0   2   58 72                       130.0 109 3 11 1   4     0   2   58 72                 130
735711 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_10 303 3 18 1   10     0   4   171 168                       339 303 3 18 1   10     0   4   171 168                 339
932589 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_10 269 4 14 0   6     1   8   166 136                       302 269 4 14 0   6     1   8   166 136                 302
1122012 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_10 270 6 20 0   7     0   6   164 145                       309 270 6 20 0   7     0   6   164 145                 309
1364835 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_10 197 6 15 1   5     0   10   112 121 *                     234.0 197 6 15 1   5     0   10   112 121                 234
1672059 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_10 233 6 24 0   10     0   8   149 132 *                     281.0 233 6 24 0   10     0   8   149 132                 281
2039861 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_10 259 4 20 0   1     0   8   139 153                       292.0 259 4 20 0   1     0   8   139 153                 292
2228818 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_10 254 4 12 0   6     0   3   139 140                       279.0 254 4 12 0   6     0   3   139 140                 279
735731 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_10 146 2 6 0   0     0   0   80 74                       154 146 2 6 0   0     0   0   80 74                 154
932609 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2016   grade_10 139 1 6 0   2     0   4   85 67                       152 139 1 6 0   2     0   4   85 67                 152
1122036 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_10 119 3 8 0   2     0   6   77 61                       138 119 3 8 0   2     0   6   77 61                 138
1364855 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_10 108 2 7 0   2     0   5   61 63 *                     124.0 108 2 7 0   2     0   5   61 63                 124
1672079 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_10 99 2 10 0   0     0   7   63 55 *                     118.0 99 2 10 0   0     0   7   63 55                 118
2039882 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_10 118 4 12 0   2     0   9   75 70                       145.0 118 4 12 0   2     0   9   75 70                 145
2228842 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_10 134 1 6 0   2     0   3   73 73                       146.0 134 1 6 0   2     0   3   73 73                 146
932612 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No 3 09 12 2016   grade_10 7 0 0 0   0     0   2   6 3                       9 7 0 0 0   0     0   2   6 3                 9
1122041 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_10 * * * *   *     *   *   1 1                       *                         1 1                  
1364860 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_10 11 0 1 0   0     0   1   10 3 *                     13.0 11 0 1 0   0     0   1   10 3                 13
1672083 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury - Amesbury Innovation High School   Regular School No High 09 12 2021   grade_10 7 0 1 0   0     0   0   3 5 *                     8.0 7 0 1 0   0     0   0   3 5                 8
2039887 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_10 9 0 0 0   0     0   1   7 3                       10.0 9 0 0 0   0     0   1   7 3                 10
2228847 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_10 11 0 1 0   0     0   0   5 7                       12.0 11 0 1 0   0     0   0   5 7                 12
735802 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_10 369 11 25 0   61     0   11   248 229                       477 369 11 25 0   61     0   11   248 229                 477
932678 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_10 314 6 22 0   63     0   8   197 216                       413 314 6 22 0   63     0   8   197 216                 413
1122120 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_10 352 9 18 0   69     0   11   204 255                       459 352 9 18 0   69     0   11   204 255                 459
1364926 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_10 291 10 33 2   84     0   7   203 224 *                     427.0 291 10 33 2   84     0   7   203 224                 427
1672149 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_10 312 8 25 2   78     0   12   195 242 *                     437.0 312 8 25 2   78     0   12   195 242                 437
2039953 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_10 324 9 21 0   96     0   10   209 250                       460.0 324 9 21 0   96     0   10   209 250                 460
2228926 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_10 317 9 27 1   63     0   10   214 213                       427.0 317 9 27 1   63     0   10   214 213                 427
735853 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_10 228 10 8 0   32     0   11   139 150                       289 228 10 8 0   32     0   11   139 150                 289
932729 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_10 257 14 12 0   22     2   6   157 156                       313 257 14 12 0   22     2   6   157 156                 313
1122180 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_10 244 16 26 0   42     0   22   157 193                       350 244 16 26 0   42     0   22   157 193                 350
1364977 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_10 269 16 19 0   38     0   22   172 192 *                     364.0 269 16 19 0   38     0   22   172 192                 364
1672200 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_10 260 17 20 0   33     0   22   152 198 *                     352.0 260 17 20 0   33     0   22   152 198                 352
2040004 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_10 258 12 24 0   36     0   14   170 173                       344.0 258 12 24 0   36     0   14   170 173                 344
2228986 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_10 245 15 18 0   34     1   8   172 147                       321.0 245 15 18 0   34     1   8   172 147                 321
735867 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_10 160 5 13 0   7     0   3   87 101                       188 160 5 13 0   7     0   3   87 101                 188
932743 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2016   grade_10 137 4 11 1   18     0   7   93 85                       178 137 4 11 1   18     0   7   93 85                 178
1122199 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2017   grade_10 139 3 12 0   16     0   2   80 92                       172 139 3 12 0   16     0   2   80 92                 172
1364991 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_10 152 8 22 1   28     0   7   101 117 *                     218.0 152 8 22 1   28     0   7   101 117                 218
1672214 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland - Ashland High   Regular School No High 09 12 2021   grade_10 117 3 22 2   29     0   2   87 88 *                     175.0 117 3 22 2   29     0   2   87 88                 175
2040018 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2019   grade_10 151 4 25 0   21     0   9   102 108                       210.0 151 4 25 0   21     0   9   102 108                 210
2229005 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland: Ashland High   Regular School No High 09 12 2018   grade_10 144 7 31 1   23     0   1   101 106                       207.0 144 7 31 1   23     0   1   101 106                 207
735909 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_10 338 20 39 2   15     0   10   242 182                       424 338 20 39 2   15     0   10   242 182                 424
932785 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_10 312 24 54 2   21     2   23   230 208                       438 312 24 54 2   21     2   23   230 208                 438
1122251 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_10 285 26 51 1   19     1   18   220 181                       401 285 26 51 1   19     1   18   220 181                 401
1365033 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_10 320 29 77 1   23     1   14   249 216 *                     465.0 320 29 77 1   23     1   14   249 216                 465
1672256 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_10 301 28 76 2   16     0   20   254 188 *                     443.0 301 28 76 2   16     0   20   254 188                 443
2040060 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_10 295 30 72 1   25     2   27   239 213                       452.0 295 30 72 1   25     2   27   239 213                 452
2229057 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_10 305 23 74 2   14     0   23   230 211                       441.0 305 23 74 2   14     0   23   230 211                 441
735912 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2015   grade_10 * * * *   *     *   *   1 2                       3                         1 2                 3
932789 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative Education School No 3 09 12 2016   grade_10 * * * *   *     *   *   1 4                       5                         1 4                 5
1122255 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 09 12 2017   grade_10 11 0 3 0   0     0   0   5 9                       14 11 0 3 0   0     0   0   5 9                 14
1672260 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro - Attleboro Community Academy   Alternative School No High 09 12 2021   grade_10 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
2040064 MA Bristol   school 2502190 16   Attleboro 250219002831 160515 Attleboro Community Academy   Alternative School No High 10 12 2019   grade_10 4 1 2 0   0     0   0   5 2                       7.0 4 1 2 0   0     0   0   5 2                 7
735932 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_10 139 1 7 2   5     0   3   68 89                       157 139 1 7 2   5     0   3   68 89                 157
932806 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2016   grade_10 150 5 12 0   6     0   3   78 98                       176 150 5 12 0   6     0   3   78 98                 176
1122277 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_10 168 5 8 0   11     0   5   97 100                       197 168 5 8 0   11     0   5   97 100                 197
1365054 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2020   grade_10 146 4 15 0   6     0   8   79 100 *                     179.0 146 4 15 0   6     0   8   79 100                 179
1672277 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   grade_10 159 7 24 0   7     0   4   105 96 *                     201.0 159 7 24 0   7     0   4   105 96                 201
2040082 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_10 158 3 9 1   8     0   5   83 101                       184.0 158 3 9 1   8     0   5   83 101                 184
2229083 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn: Auburn Senior High   Regular School No High 09 12 2018   grade_10 145 2 18 1   9     0   9   91 93                       184.0 145 2 18 1   9     0   9   91 93                 184
735947 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_10 19 26 0 1   3     0   1   20 30                       50 19 26 0 1   3     0   1   20 30                 50
932821 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_10 16 22 5 0   3     0   2   18 30                       48 16 22 5 0   3     0   2   18 30                 48
1122293 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_10 21 21 3 0   2     0   2   25 24                       49 21 21 3 0   2     0   2   25 24                 49
1365068 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_10 20 18 3 0   4     0   2   30 17 *                     47.0 20 18 3 0   4     0   2   30 17                 47
1672292 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_10 20 16 8 0   1     0   4   26 23 *                     49.0 20 16 8 0   1     0   4   26 23                 49
2040097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_10 16 21 3 0   1     0   1   28 14                       42.0 16 21 3 0   1     0   1   28 14                 42
2229099 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_10 22 21 3 0   4     0   3   23 29                       53.0 22 21 3 0   4     0   3   23 29                 53
735974 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_10 269 29 42 6   11     0   12   180 189                       369 269 29 42 6   11     0   12   180 189                 369
932848 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_10 275 28 40 6   16     2   14   187 194                       381 275 28 40 6   16     2   14   187 194                 381
1122327 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_10 273 28 34 5   12     3   17   175 197                       372 273 28 34 5   12     3   17   175 197                 372
1365098 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_10 227 32 61 1   5     1   11   178 160 *                     338.0 227 32 61 1   5     1   11   178 160                 338
1672322 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_10 210 30 65 2   5     1   22   136 199 *                     335.0 210 30 65 2   5     1   22   136 199                 335
2040124 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_10 254 31 58 1   3     3   12   189 173                       362.0 254 31 58 1   3     3   12   189 173                 362
2229133 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_10 252 32 49 1   9     1   12   157 199                       356.0 252 32 49 1   9     1   12   157 199                 356
735989 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_10 160 15 8 0   22     1   14   112 108                       220 160 15 8 0   22     1   14   112 108                 220
932863 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2016   grade_10 151 22 10 0   29     0   13   97 128                       225 151 22 10 0   29     0   13   97 128                 225
1122345 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_10 142 18 13 0   17     2   14   106 100                       206 142 18 13 0   17     2   14   106 100                 206
1365113 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_10 151 20 17 0   39     0   9   119 117 *                     236.0 151 20 17 0   39     0   9   119 117                 236
1672337 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford - Bedford High   Regular School No High 09 12 2021   grade_10 123 19 24 0   35     0   8   100 108 *                     209.0 123 19 24 0   35     0   8   100 108                 209
2040139 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_10 121 11 22 0   22     0   12   99 89                       188.0 121 11 22 0   22     0   12   99 89                 188
2229151 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_10 143 13 19 0   25     1   9   104 106                       210.0 143 13 19 0   25     1   9   104 106                 210
736003 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_10 155 2 8 0   6     0   4   75 100                       175 155 2 8 0   6     0   4   75 100                 175
932877 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2016   grade_10 154 2 6 1   2     1   4   90 80                       170 154 2 6 1   2     1   4   90 80                 170
1122364 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2017   grade_10 164 5 11 0   3     0   2   102 83                       185 164 5 11 0   3     0   2   102 83                 185
1365127 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2020   grade_10 150 2 2 0   1     1   4   79 81 *                     160.0 150 2 2 0   1     1   4   79 81                 160
1672351 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown - Belchertown High   Regular School No High 09 12 2021   grade_10 164 4 7 1   3     1   7   98 89 *                     187.0 164 4 7 1   3     1   7   98 89                 187
2040153 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_10 157 5 3 1   3     0   5   85 89                       174.0 157 5 3 1   3     0   5   85 89                 174
2229170 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown: Belchertown High   Regular School No High 09 12 2018   grade_10 163 1 11 0   2     0   1   90 88                       178.0 163 1 11 0   2     0   1   90 88                 178
736027 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_10 130 2 6 0   4     0   1   78 65                       143 130 2 6 0   4     0   1   78 65                 143
932896 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_10 105 4 5 1   2     0   1   64 54                       118 105 4 5 1   2     0   1   64 54                 118
1122387 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_10 131 1 5 0   4     0   1   81 61                       142 131 1 5 0   4     0   1   81 61                 142
1365146 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_10 122 4 7 0   3     0   5   64 77 *                     141.0 122 4 7 0   3     0   5   64 77                 141
1672369 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_10 107 7 5 0   4     0   1   56 68 *                     124.0 107 7 5 0   4     0   1   56 68                 124

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