enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
735668 735668 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2015   grade_9 113 1 15 0   0     0   2   61 70                       131 113 1 15 0   0     0   2   61 70                 131
932546 932546 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No 3 09 12 2016   grade_9 93 6 6 0   0     1   4   51 59                       110 93 6 6 0   0     1   4   51 59                 110
1121960 1121960 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2017   grade_9 106 3 8 1   4     0   2   55 69                       124 106 3 8 1   4     0   2   55 69                 124
1364794 1364794 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2020   grade_9 125 7 20 0   6     0   2   75 85 *                     160.0 125 7 20 0   6     0   2   75 85                 160
1672018 1672018 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington - Abington High   Regular School No High 09 12 2021   grade_9 122 5 16 0   3     0   0   88 58 *                     146.0 122 5 16 0   3     0   0   88 58                 146
2039820 2039820 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington High   Regular School No High 09 12 2019   grade_9 134 8 12 0   4     0   1   82 77                       159.0 134 8 12 0   4     0   1   82 77                 159
2228768 2228768 MA Plymouth   school 2501650 1   Abington 250165000001 10505 Abington: Abington High   Regular School No High 09 12 2018   grade_9 126 7 17 1   1     0   1   81 72                       153.0 126 7 17 1   1     0   1   81 72                 153
735710 735710 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2015   grade_9 281 6 15 0   7     1   7   172 145                       317 281 6 15 0   7     1   7   172 145                 317
932588 932588 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No 3 09 12 2016   grade_9 278 6 23 0   6     0   6   168 151                       319 278 6 23 0   6     0   6   168 151                 319
1122011 1122011 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2017   grade_9 272 3 14 0   6     0   4   151 148                       299 272 3 14 0   6     0   4   151 148                 299
1364834 1364834 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2020   grade_9 247 4 28 0   10     0   8   160 137 *                     297.0 247 4 28 0   10     0   8   160 137                 297
1672058 1672058 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam - Agawam High   Regular School No High 09 12 2021   grade_9 231 6 23 0   12     0   9   155 126 *                     281.0 231 6 23 0   12     0   9   155 126                 281
2039860 2039860 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam High   Regular School No High 09 12 2019   grade_9 219 7 21 1   6     0   11   136 129                       265.0 219 7 21 1   6     0   11   136 129                 265
2228817 2228817 MA Hampden   school 2501800 5   Agawam 250180000024 50505 Agawam: Agawam High   Regular School No High 09 12 2018   grade_9 282 5 21 0   1     0   9   159 159                       318.0 282 5 21 0   1     0   9   159 159                 318
735730 735730 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2015   grade_9 147 0 8 0   1     0   4   91 69                       160 147 0 8 0   1     0   4   91 69                 160
932608 932608 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No 3 09 12 2016   grade_9 127 3 9 0   2     0   5   81 65                       146 127 3 9 0   2     0   5   81 65                 146
1122035 1122035 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2017   grade_9 134 2 5 0   2     0   4   74 73                       147 134 2 5 0   2     0   4   74 73                 147
1364854 1364854 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2020   grade_9 101 2 8 0   0     0   7   63 55 *                     118.0 101 2 8 0   0     0   7   63 55                 118
1672078 1672078 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury - Amesbury High   Regular School No High 09 12 2021   grade_9 105 6 16 0   1     0   4   61 71 *                     132.0 105 6 16 0   1     0   4   61 71                 132
2039881 2039881 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury High   Regular School No High 09 12 2019   grade_9 119 2 6 0   2     0   5   68 66                       134.0 119 2 6 0   2     0   5   68 66                 134
2228841 2228841 MA Essex   school 2501860 7   Amesbury 250186000034 70505 Amesbury: Amesbury High   Regular School No High 09 12 2018   grade_9 124 5 15 1   2     0   9   82 74                       156.0 124 5 15 1   2     0   9   82 74                 156
1122040 1122040 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2017   grade_9 7 0 0 0   0     0   0   4 3                       7 7 0 0 0   0     0   0   4 3                 7
1364859 1364859 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2020   grade_9 7 0 1 0   0     0   0   4 4 *                     8.0 7 0 1 0   0     0   0   4 4                 8
2039886 2039886 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury Innovation High School   Regular School No High 09 12 2019   grade_9 9 0 2 0   0     0   1   8 4                       12.0 9 0 2 0   0     0   1   8 4                 12
2228846 2228846 MA Essex   school 2501860 7   Amesbury 250186002841 70515 Amesbury: Amesbury Innovation High School   Regular School No High 09 12 2018   grade_9 8 0 0 0   0     0   1   5 4                       9.0 8 0 0 0   0     0   1   5 4                 9
735801 735801 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2015   grade_9 321 7 23 0   61     0   8   199 221                       420 321 7 23 0   61     0   8   199 221                 420
932677 932677 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No 3 09 12 2016   grade_9 367 9 17 0   66     0   12   209 262                       471 367 9 17 0   66     0   12   209 262                 471
1122119 1122119 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_9 335 8 26 1   67     0   9   225 221                       446 335 8 26 1   67     0   9   225 221                 446
1364925 1364925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2020   grade_9 321 8 27 3   84     0   12   208 247 *                     455.0 321 8 27 3   84     0   12   208 247                 455
1672148 1672148 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover - Andover High   Regular School No High 09 12 2021   grade_9 285 19 42 0   78     0   13   209 226 *                     437.0 285 19 42 0   78     0   13   209 226                 437
2039952 2039952 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2019   grade_9 293 8 32 1   84     0   8   206 219                       426.0 293 8 32 1   84     0   8   206 219                 426
2228925 2228925 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover: Andover High   Regular School No High 09 12 2018   grade_9 333 10 21 0   98     0   10   209 262                       472.0 333 10 21 0   98     0   10   209 262                 472
735852 735852 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2015   grade_9 249 16 15 0   20     0   6   153 153                       306 249 16 15 0   20     0   6   153 153                 306
932728 932728 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No 3 09 12 2016   grade_9 241 17 21 0   41     0   24   154 190                       344 241 17 21 0   41     0   24   154 190                 344
1122179 1122179 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2017   grade_9 252 15 20 0   35     1   9   175 157                       332 252 15 20 0   35     1   9   175 157                 332
1364976 1364976 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2020   grade_9 272 17 20 0   36     0   23   162 205 *                     368.0 272 17 20 0   36     0   23   162 205                 368
1672199 1672199 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington - Arlington High   Regular School No High 09 12 2021   grade_9 271 9 23 0   41     1   18   161 201 *                     363.0 271 9 23 0   41     1   18   161 201                 363
2040003 2040003 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington High   Regular School No High 09 12 2019   grade_9 270 15 18 0   39     0   22   175 189                       364.0 270 15 18 0   39     0   22   175 189                 364
2228985 2228985 MA Middlesex   school 2501980 10   Arlington 250198000053 100505 Arlington: Arlington High   Regular School No High 09 12 2018   grade_9 261 16 23 0   36     0   14   168 182                       350.0 261 16 23 0   36     0   14   168 182                 350
735866 735866 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2015   grade_9 138 3 9 1   17     0   6   91 83                       174 138 3 9 1   17     0   6   91 83                 174
932742 932742 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No 3 09 12 2016   grade_9 143 3 12 0   14     0   4   84 92                       176 143 3 12 0   14     0   4   84 92                 176
1122198 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
1364990 1364990 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland High   Regular School No High 09 12 2020   grade_9 121 4 22 2   29     0   2   89 91 *                     180.0 121 4 22 2   29     0   2   89 91                 180
1672213 1672213 MA Middlesex   school 2502100 14   Ashland 250210000070 140505 Ashland - Ashland High   Regular School No High 09 12 2021   grade_9 128 3 25 2   31     0   6   97 98 *                     195.0 128 3 25 2   31     0   6   97 98                 195
2040017 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
2229004 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
735908 735908 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2015   grade_9 310 30 48 3   22     2   18   224 209                       433 310 30 48 3   22     2   18   224 209                 433
932784 932784 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No 3 09 12 2016   grade_9 300 23 54 1   17     1   18   228 186                       414 300 23 54 1   17     1   18   228 186                 414
1122250 1122250 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2017   grade_9 317 22 72 2   15     0   21   242 207                       449 317 22 72 2   15     0   21   242 207                 449
1365032 1365032 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2020   grade_9 310 28 79 1   16     0   20   259 194 *                     454.0 310 28 79 1   16     0   20   259 194                 454
1672255 1672255 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro - Attleboro High   Regular School No High 09 12 2021   grade_9 291 30 73 1   26     0   28   240 209 *                     449.0 291 30 73 1   26     0   28   240 209                 449
2040059 2040059 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro High   Regular School No High 09 12 2019   grade_9 330 35 72 1   24     1   16   260 219                       479.0 330 35 72 1   24     1   16   260 219                 479
2229056 2229056 MA Bristol   school 2502190 16   Attleboro 250219000084 160505 Attleboro: Attleboro High   Regular School No High 09 12 2018   grade_9 309 27 66 1   25     2   26   242 214                       456.0 309 27 66 1   25     2   26   242 214                 456
735931 735931 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No 3 09 12 2015   grade_9 146 5 12 0   5     0   3   73 98                       171 146 5 12 0   5     0   3   73 98                 171
932805 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
1122276 1122276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2017   grade_9 138 4 16 1   8     0   7   87 87                       174 138 4 16 1   8     0   7   87 87                 174
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
1672276 1672276 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn - Auburn Senior High   Regular School No High 09 12 2021   grade_9 136 3 14 0   9     0   6   84 84 *                     168.0 136 3 14 0   9     0   6   84 84                 168
2040081 2040081 MA Worcester   school 2502220 17   Auburn 250222000100 170505 Auburn Senior High   Regular School No High 09 12 2019   grade_9 141 4 14 0   6     0   8   77 96                       173.0 141 4 14 0   6     0   8   77 96                 173
2229082 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
735946 735946 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2015   grade_9 22 27 7 0   3     0   2   25 36                       61 22 27 7 0   3     0   2   25 36                 61
932820 932820 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_9 23 21 4 0   2     0   1   29 22                       51 23 21 4 0   2     0   1   29 22                 51
1122292 1122292 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_9 25 18 3 0   4     0   3   23 29                       53 25 18 3 0   4     0   3   23 29                 53
1365067 1365067 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2020   grade_9 17 21 7 0   1     0   4   28 22 *                     50.0 17 21 7 0   1     0   4   28 22                 50
1672291 1672291 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_9 23 16 7 1   3     0   3   33 20 *                     53.0 23 16 7 1   3     0   3   33 20                 53
2040096 2040096 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_9 22 24 3 0   3     0   4   33 23                       56.0 22 24 3 0   3     0   4   33 23                 56
2229098 2229098 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_9 19 16 1 0   2     0   1   29 10                       39.0 19 16 1 0   2     0   1   29 10                 39
735973 735973 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2015   grade_9 287 31 41 5   12     2   18   193 203                       396 287 31 41 5   12     2   18   193 203                 396
932847 932847 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No 3 08 12 2016   grade_9 284 30 28 3   16     2   21   186 198                       384 284 30 28 3   16     2   21   186 198                 384
1122326 1122326 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2017   grade_9 269 38 44 2   13     1   13   169 211                       380 269 38 44 2   13     1   13   169 211                 380
1365097 1365097 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2020   grade_9 218 30 53 2   5     1   23   134 198 *                     332.0 218 30 53 2   5     1   23   134 198                 332
1672321 1672321 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable - Barnstable High   Regular School No High 08 12 2021   grade_9 221 34 74 1   9     0   16   194 160 *                     355.0 221 34 74 1   9     0   16   194 160                 355
2040123 2040123 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable High   Regular School No High 08 12 2019   grade_9 246 35 39 1   6     0   14   177 164                       341.0 246 35 39 1   6     0   14   177 164                 341
2229132 2229132 MA Barnstable   school 2502310 20   Barnstable 250231000116 200505 Barnstable: Barnstable High   Regular School No High 08 12 2018   grade_9 262 31 57 1   4     1   13   200 169                       369.0 262 31 57 1   4     1   13   200 169                 369
735988 735988 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No 3 09 12 2015   grade_9 159 20 11 0   30     0   10   99 131                       230 159 20 11 0   30     0   10   99 131                 230
932862 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
1122344 1122344 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2017   grade_9 151 17 21 0   26     2   9   111 115                       226 151 17 21 0   26     2   9   111 115                 226
1365112 1365112 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2020   grade_9 138 20 25 1   36     0   8   108 120 *                     228.0 138 20 25 1   36     0   8   108 120                 228
1672336 1672336 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford - Bedford High   Regular School No High 09 12 2021   grade_9 116 16 29 0   30     1   15   107 100 *                     207.0 116 16 29 0   30     1   15   107 100                 207
2040138 2040138 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford High   Regular School No High 09 12 2019   grade_9 160 18 16 0   39     0   9   117 125                       242.0 160 18 16 0   39     0   9   117 125                 242
2229150 2229150 MA Middlesex   school 2502400 23   Bedford 250240000128 230505 Bedford: Bedford High   Regular School No High 09 12 2018   grade_9 121 11 17 0   20     0   11   94 86                       180.0 121 11 17 0   20     0   11   94 86                 180
736002 736002 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No 3 09 12 2015   grade_9 169 3 5 1   2     1   3   97 87                       184 169 3 5 1   2     1   3   97 87                 184
932876 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
1122363 1122363 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2017   grade_9 165 0 9 0   3     0   2   91 88                       179 165 0 9 0   3     0   2   91 88                 179
1365126 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
1672350 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
2040152 2040152 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown High   Regular School No High 09 12 2019   grade_9 155 1 1 0   2     1   5   78 87                       165.0 155 1 1 0   2     1   5   78 87                 165
2229169 2229169 MA Hampshire   school 2502430 24   Belchertown 250243000134 240505 Belchertown: Belchertown High   Regular School No High 09 12 2018   grade_9 164 5 3 1   5     0   5   91 92                       183.0 164 5 3 1   5     0   5   91 92                 183
736026 736026 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 09 12 2015   grade_9 108 4 5 1   2     0   1   64 57                       121 108 4 5 1   2     0   1   64 57                 121
932895 932895 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No 3 08 12 2016   grade_9 127 1 3 0   4     0   1   76 60                       136 127 1 3 0   4     0   1   76 60                 136
1122386 1122386 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2017   grade_9 123 2 14 1   6     0   3   68 81                       149 123 2 14 1   6     0   3   68 81                 149
1365145 1365145 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2020   grade_9 109 8 4 0   4     0   1   59 67 *                     126.0 109 8 4 0   4     0   1   59 67                 126
1672368 1672368 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham - Bellingham High School   Regular School No High 08 12 2021   grade_9 122 3 15 0   8     0   6   88 66 *                     154.0 122 3 15 0   8     0   6   88 66                 154
2040171 2040171 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham High School   Regular School No High 08 12 2019   grade_9 126 4 3 0   3     0   5   65 76                       141.0 126 4 3 0   3     0   5   65 76                 141
2229192 2229192 MA Norfolk   school 2502460 25   Bellingham 250246000139 250505 Bellingham: Bellingham High School   Regular School No High 08 12 2018   grade_9 137 5 5 0   6     0   5   90 68                       158.0 137 5 5 0   6     0   5   90 68                 158
736031 736031 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Primavera Junior/Senior High School   Alternative Education School No 3 07 12 2015   grade_9 8 0 0 0   0     0   0   5 3                       8 8 0 0 0   0     0   0   5 3                 8
932900 932900 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Paul J. Primavera Jr./Sr. High School   Alternative Education School No 3 07 12 2016   grade_9 5 0 1 0   0     0   1   4 3                       7 5 0 1 0   0     0   1   4 3                 7
1122391 1122391 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 07 12 2017   grade_9 8 0 2 0   0     0   0   6 4                       10 8 0 2 0   0     0   0   6 4                 10
1365150 1365150 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_9 6 0 2 0   0     0   0   4 3 *                     8.0 6 0 2 0   0     0   0   4 3                 8
1672372 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

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