enrollments

Data source: Big Local News · About: Big Local

2,737 rows where grade = "grade_9" and state = "MA" sorted by district_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
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
738296 738296 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2015   grade_9 338 30 87 1   34     0   9   241 258                       499 338 30 87 1   34     0   9   241 258                 499
935150 935150 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No 3 09 12 2016   grade_9 319 43 136 1   33     0   22   291 263                       554 319 43 136 1   33     0   22   291 263                 554
1125032 1125032 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2017   grade_9 334 26 127 0   26     1   22   272 264                       536 334 26 127 0   26     1   22   272 264                 536
1367388 1367388 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2020   grade_9 356 36 236 1   27     1   27   353 331 *                     684.0 356 36 236 1   27     1   27   353 331                 684
1674622 1674622 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham - Framingham High School   Regular School No High 09 12 2021   grade_9 326 39 245 0   24     1   26   356 305 *                     661.0 326 39 245 0   24     1   26   356 305                 661
2042459 2042459 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham High School   Regular School No High 09 12 2019   grade_9 337 50 156 2   35     1   21   300 302                       602.0 337 50 156 2   35     1   21   300 302                 602
2231861 2231861 MA Middlesex   school 2504980 100   Framingham 250498002573 1000515 Framingham: Framingham High School   Regular School No High 09 12 2018   grade_9 346 50 132 0   31     0   21   288 292                       580.0 346 50 132 0   31     0   21   288 292                 580
738346 738346 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2015   grade_9 442 7 9 1   15     0   6   247 233                       480 442 7 9 1   15     0   6   247 233                 480
935200 935200 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No 3 09 12 2016   grade_9 380 7 5 2   26     2   8   209 221                       430 380 7 5 2   26     2   8   209 221                 430
1125093 1125093 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2017   grade_9 389 4 8 0   19     2   14   219 217                       436 389 4 8 0   19     2   14   219 217                 436
1367438 1367438 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2020   grade_9 375 4 16 0   29     1   10   209 224 *                     435.0 375 4 16 0   29     1   10   209 224                 435
1674672 1674672 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin - Franklin High   Regular School No High 09 12 2021   grade_9 346 8 16 0   32     1   11   200 214 *                     414.0 346 8 16 0   32     1   11   200 214                 414
2042509 2042509 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin High   Regular School No High 09 12 2019   grade_9 383 6 15 0   33     2   6   221 224                       445.0 383 6 15 0   33     2   6   221 224                 445
2231922 2231922 MA Norfolk   school 2505010 101   Franklin 250501000737 1010505 Franklin: Franklin High   Regular School No High 09 12 2018   grade_9 386 9 10 2   36     0   9   231 221                       452.0 386 9 10 2   36     0   9   231 221                 452
738364 738364 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 09 12 2015   grade_9 124 5 17 0   2     0   9   78 79                       157 124 5 17 0   2     0   9   78 79                 157
738369 738369 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2015   grade_9 13 0 0 0   1     0   0   9 5                       14 13 0 0 0   1     0   0   9 5                 14
935215 935215 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No 3 08 12 2016   grade_9 115 2 25 1   4     0   11   83 75                       158 115 2 25 1   4     0   11   83 75                 158
935220 935220 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative Education School No 3 09 12 2016   grade_9 11 0 0 0   0     0   1   2 10                       12 11 0 0 0   0     0   1   2 10                 12
1125111 1125111 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   grade_9 137 6 27 1   5     0   6   92 90                       182 137 6 27 1   5     0   6   92 90                 182
1125116 1125116 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2017   grade_9 20 1 2 0   0     0   4   18 9                       27 20 1 2 0   0     0   4   18 9                 27
1367453 1367453 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2020   grade_9 84 1 37 0   6     0   10   74 64 *                     138.0 84 1 37 0   6     0   10   74 64                 138
1367457 1367457 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2020   grade_9 26 1 6 0   0     0   1   17 17 *                     34.0 26 1 6 0   0     0   1   17 17                 34
1674687 1674687 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner - Gardner High   Regular School No High 08 12 2021   grade_9 110 6 41 0   1     0   12   91 79 *                     170.0 110 6 41 0   1     0   12   91 79                 170
1674692 1674692 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner - Gardner Academy for Learning and Technology   Alternative School No High 09 12 2021   grade_9 7 0 6 0   1     0   0   11 3 *                     14.0 7 0 6 0   1     0   0   11 3                 14
2042524 2042524 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_9 87 7 31 1   3     0   8   82 55                       137.0 87 7 31 1   3     0   8   82 55                 137
2042529 2042529 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner Academy for Learning and Technology   Alternative School No High 09 12 2019   grade_9 7 1 1 0   0     0   1   6 4                       10.0 7 1 1 0   0     0   1   6 4                 10
2231940 2231940 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_9 128 9 21 0   2     0   9   93 76                       169.0 128 9 21 0   2     0   9   93 76                 169
2231945 2231945 MA Worcester   school 2505130 103   Gardner 250513002692 1030515 Gardner: Gardner Academy for Learning and Technology   Alternative School No High 09 12 2018   grade_9 12 0 1 1   0     0   1   8 7                       15.0 12 0 1 1   0     0   1   8 7                 15
738383 738383 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2015   grade_9 105 3 1 0   2     0   2   63 50                       113 105 3 1 0   2     0   2   63 50                 113
935234 935234 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No 3 09 12 2016   grade_9 88 0 1 0   1     0   0   40 50                       90 88 0 1 0   1     0   0   40 50                 90
1125134 1125134 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2017   grade_9 97 0 5 0   1     0   5   47 61                       108 97 0 5 0   1     0   5   47 61                 108
1367471 1367471 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2020   grade_9 79 2 2 0   1     0   1   45 40 *                     85.0 79 2 2 0   1     0   1   45 40                 85
1674706 1674706 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown - Georgetown High School   Regular School No High 09 12 2021   grade_9 71 1 2 0   0     0   0   38 36 *                     74.0 71 1 2 0   0     0   0   38 36                 74
2042543 2042543 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown High School   Regular School No High 09 12 2019   grade_9 90 1 4 0   2     0   0   50 47                       97.0 90 1 4 0   2     0   0   50 47                 97
2231963 2231963 MA Essex   school 2505220 105   Georgetown 250522000764 1050505 Georgetown: Georgetown High School   Regular School No High 09 12 2018   grade_9 87 0 2 0   1     0   0   43 47                       90.0 87 0 2 0   1     0   0   43 47                 90
738421 738421 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2015   grade_9 205 2 22 0   3     5   4   118 123                       241 205 2 22 0   3     5   4   118 123                 241
935272 935272 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No 3 09 12 2016   grade_9 214 3 12 2   5     1   5   130 112                       242 214 3 12 2   5     1   5   130 112                 242
1125180 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
1367509 1367509 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester High   Regular School No High 09 12 2020   grade_9 172 3 32 1   1     4   17   147 83 *                     230.0 172 3 32 1   1     4   17   147 83                 230
1674744 1674744 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester - Gloucester High   Regular School No High 09 12 2021   grade_9 210 3 26 0   5     3   11   146 112 *                     258.0 210 3 26 0   5     3   11   146 112                 258
2042581 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
2232009 2232009 MA Essex   school 2505280 107   Gloucester 250528000774 1070505 Gloucester: Gloucester High   Regular School No High 09 12 2018   grade_9 162 5 30 1   0     1   3   108 94                       202.0 162 5 30 1   0     1   3   108 94                 202
1125195 1125195 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1374316 1374316 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
1674759 1674759 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_9 * * * *   *     *   *   * * *                     0.0                                             0
2232024 2232024 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_9 * * * *   *     *   *   * *                       0.0                                             0
738445 738445 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2015   grade_9 185 0 6 0   17     0   4   99 113                       212 185 0 6 0   17     0   4   99 113                 212
935297 935297 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No 3 09 12 2016   grade_9 186 5 6 0   30     1   5   113 120                       233 186 5 6 0   30     1   5   113 120                 233
1125223 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
1367532 1367532 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2020   grade_9 192 5 10 0   27     0   5   110 129 *                     239.0 192 5 10 0   27     0   5   110 129                 239
1674782 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
2042604 2042604 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton High School   Regular School No High 09 12 2019   grade_9 194 4 9 0   27     0   8   118 124                       242.0 194 4 9 0   27     0   8   118 124                 242
2232052 2232052 MA Worcester   school 2505370 110   Grafton 250537000786 1100505 Grafton: Grafton High School   Regular School No High 09 12 2018   grade_9 161 7 10 0   11     0   6   95 100                       195.0 161 7 10 0   11     0   6   95 100                 195
738460 738460 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2015   grade_9 58 0 3 0   2     0   0   25 38                       63 58 0 3 0   2     0   0   25 38                 63
935311 935311 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_9 47 0 1 0   2     0   1   31 20                       51 47 0 1 0   2     0   1   31 20                 51
1125240 1125240 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2017   grade_9 48 0 4 0   2     0   0   26 28                       54 48 0 4 0   2     0   0   26 28                 54
1367546 1367546 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2020   grade_9 53 0 4 0   1     0   0   41 17 *                     58.0 53 0 4 0   1     0   0   41 17                 58
1674796 1674796 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby - Granby Jr Sr High School   Regular School No High 07 12 2021   grade_9 43 0 2 0   1     0   3   23 26 *                     49.0 43 0 2 0   1     0   3   23 26                 49
2042619 2042619 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_9 58 1 5 0   0     0   0   36 28                       64.0 58 1 5 0   0     0   0   36 28                 64
2232069 2232069 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_9 42 0 6 0   3     0   3   32 22                       54.0 42 0 6 0   3     0   3   32 22                 54
738486 738486 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2015   grade_9 68 1 20 0   2     0   1   42 50                       92 68 1 20 0   2     0   1   42 50                 92
935337 935337 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No 3 08 12 2016   grade_9 58 1 20 0   3     0   6   49 39                       88 58 1 20 0   3     0   6   49 39                 88
1125269 1125269 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_9 * * * *   *     *   *   * *                       *                                              
1125286 1125286 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_9 56 2 19 0   2     0   5   51 33                       84 56 2 19 0   2     0   5   51 33                 84
1367570 1367570 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2020   grade_9 66 2 28 0   1     0   7   52 52 *                     104.0 66 2 28 0   1     0   7   52 52                 104
1674820 1674820 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield - Greenfield High   Regular School No High 08 12 2021   grade_9 60 2 22 0   2     0   9   56 39 *                     95.0 60 2 22 0   2     0   9   56 39                 95
2042643 2042643 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2019   grade_9 82 2 27 1   3     0   8   62 61                       123.0 82 2 27 1   3     0   8   62 61                 123
2232099 2232099 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield: Greenfield High   Regular School No High 08 12 2018   grade_9 59 3 18 0   2     0   7   51 38                       89.0 59 3 18 0   2     0   7   51 38                 89
738501 738501 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2015   grade_9 33 0 1 0   1     0   2   17 20                       37 33 0 1 0   1     0   2   17 20                 37
935352 935352 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2016   grade_9 35 3 6 0   1     1   1   21 26                       47 35 3 6 0   1     1   1   21 26                 47
1125302 1125302 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2017   grade_9 25 0 5 0   2     0   0   16 16                       32 25 0 5 0   2     0   0   16 16                 32
1367584 1367584 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_9 28 2 4 0   0     4   0   17 21 *                     38.0 28 2 4 0   0     4   0   17 21                 38
1674834 1674834 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley - Hopkins Academy   Regular School No High 07 12 2021   grade_9 36 1 5 0   2     3   3   27 23 *                     50.0 36 1 5 0   2     3   3   27 23                 50
2042658 2042658 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_9 29 1 1 1   2     1   1   18 18                       36.0 29 1 1 1   2     1   1   18 18                 36
2232115 2232115 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_9 32 0 3 0   0     0   3   21 17                       38.0 32 0 3 0   0     0   3   21 17                 38
738535 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
935385 935385 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No 3 09 12 2016   grade_9 208 2 1 0   4     0   0   123 92                       215 208 2 1 0   4     0   0   123 92                 215
1125341 1125341 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2017   grade_9 171 0 3 0   5     0   0   93 86                       179 171 0 3 0   5     0   0   93 86                 179
1367612 1367612 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2020   grade_9 162 3 2 0   5     0   0   87 85 *                     172.0 162 3 2 0   5     0   0   87 85                 172
1674863 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
2042690 2042690 MA Plymouth   school 2505790 122   Hanover 250579000829 1220505 Hanover High   Regular School No High 09 12 2019   grade_9 186 1 2 0   5     0   0   105 89                       194.0 186 1 2 0   5     0   0   105 89                 194
2232154 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
738550 738550 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2015   grade_9 84 2 1 0   12     0   3   56 46                       102 84 2 1 0   12     0   3   56 46                 102
935400 935400 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_9 84 4 4 0   12     0   1   55 50                       105 84 4 4 0   12     0   1   55 50                 105
1125357 1125357 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_9 77 1 4 0   10     0   1   42 51                       93 77 1 4 0   10     0   1   42 51                 93
1367626 1367626 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_9 58 3 3 0   9     0   1   41 33 *                     74.0 58 3 3 0   9     0   1   41 33                 74

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