enrollments

Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 390 ✖

grade ✖

  • grade_8 · 390 ✖
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
1124102 1124102 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_8 7 9 91 0   2     0   1   66 44                       110 7 9 91 0   2     0   1   66 44                 110
1124107 1124107 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_8 8 5 104 0   3     0   2   66 56                       122 8 5 104 0   3     0   2   66 56                 122
1124112 1124112 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_8 7 13 124 0   3     0   0   75 72                       147 7 13 124 0   3     0   0   75 72                 147
1124148 1124148 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_8 4 1 8 0   0     0   0   9 4                       13 4 1 8 0   0     0   0   9 4                 13
1124191 1124191 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Bellamy Middle   Regular School No Middle 06 08 2017   grade_8 161 8 78 2   9     0   7   129 136                       265 161 8 78 2   9     0   7   129 136                 265
1124195 1124195 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_8 150 8 93 1   7     1   9   143 126                       269 150 8 93 1   7     1   9   143 126                 269
1124215 1124215 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2017   grade_8 16 0 0 0   0     0   0   6 10                       16 16 0 0 0   0     0   0   6 10                 16
1124227 1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1124246 1124246 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_8 126 3 0 0   5     0   0   68 66                       134 126 3 0 0   5     0   0   68 66                 134
1124277 1124277 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord Middle   Regular School No Middle 06 08 2017   grade_8 184 11 12 0   14     0   6   118 109                       227 184 11 12 0   14     0   6   118 109                 227
1124326 1124326 MA Essex   school 2503990 71   Danvers 250399002517 710305 Holten Richmond Middle School   Regular School No Middle 06 08 2017   grade_8 244 3 24 0   4     0   9   147 137                       284 244 3 24 0   4     0   9   147 137                 284
1124358 1124358 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth Middle   Regular School No Middle 06 08 2017   grade_8 304 5 6 0   2     0   14   155 176                       331 304 5 6 0   2     0   14   155 176                 331
1124394 1124394 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham Middle School   Regular School No Middle 06 08 2017   grade_8 161 14 26 0   5     0   9   110 105                       215 161 14 26 0   5     0   9   110 105                 215
1124421 1124421 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_8 121 2 3 0   2     1   3   64 68                       132 121 2 3 0   2     1   3   64 68                 132
1124467 1124467 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2017   grade_8 256 20 24 1   18     0   4   170 153                       323 256 20 24 1   18     0   4   170 153                 323
1124485 1124485 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2017   grade_8 245 1 9 0   5     0   5   137 128                       265 245 1 9 0   5     0   5   137 128                 265
1124503 1124503 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2017   grade_8 173 3 2 1   3     0   6   91 96                       188 173 3 2 1   3     0   6   91 96                 188
1124539 1124539 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_8 93 3 8 0   3     0   4   52 59                       111 93 3 8 0   3     0   4   52 59                 111
1124561 1124561 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 Birchland Park   Regular School No Middle 06 08 2017   grade_8 165 2 9 0   10     1   2   94 95                       189 165 2 9 0   10     1   2   94 95                 189
1124589 1124589 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton Middle School   Regular School No Middle 06 08 2017   grade_8 248 17 13 0   10     0   5   135 158                       293 248 17 13 0   10     0   5   135 158                 293
1124605 1124605 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2017   grade_8 34 1 4 1   0     0   0   15 25                       40 34 1 4 1   0     0   0   15 25                 40
1124626 1124626 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_8 4 3 25 0   3     0   0   19 16                       35 4 3 25 0   3     0   0   19 16                 35
1124643 1124643 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Madeline English School   Regular School No Elementary KG 08 2017   grade_8 29 10 31 0   5     0   2   44 33                       77 29 10 31 0   5     0   2   44 33                 77
1124653 1124653 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_8 34 14 39 0   11     0   3   53 48                       101 34 14 39 0   11     0   3   53 48                 101
1124672 1124672 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_8 24 22 37 0   8     0   3   41 53                       94 24 22 37 0   8     0   3   41 53                 94
1124682 1124682 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_8 17 30 52 0   3     0   2   48 56                       104 17 30 52 0   3     0   2   48 56                 104
1124706 1124706 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2017   grade_8 137 1 6 2   5     0   1   84 68                       152 137 1 6 2   5     0   1   84 68                 152
1124752 1124752 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Henry Lord Community School   Regular School No Elementary PK 08 2017   grade_8 42 5 10 0   4     0   5   33 33                       66 42 5 10 0   4     0   5   33 33                 66
1124763 1124763 MA Bristol   school 2504830 95   Fall River 250483000666 950045 John J Doran   Regular School No Elementary PK 08 2017   grade_8 26 2 20 0   3     0   2   30 23                       53 26 2 20 0   3     0   2   30 23                 53
1124796 1124796 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Talbot Innovation School   Regular School No Middle 06 08 2017   grade_8 103 10 59 0   12     0   6   88 102                       190 103 10 59 0   12     0   6   88 102                 190
1124800 1124800 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2017   grade_8 125 16 40 0   8     1   14   113 91                       204 125 16 40 0   8     1   14   113 91                 204
1124804 1124804 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Matthew J Kuss Middle   Regular School No Middle 06 08 2017   grade_8 154 11 43 0   8     0   11   119 108                       227 154 11 43 0   8     0   11   119 108                 227
1124812 1124812 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No Middle 06 08 2017   grade_8 7 3 8 0   0     0   1   9 10                       19 7 3 8 0   0     0   1   9 10                 19
1124820 1124820 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone Day School   Regular School No Elementary 02 08 2017   grade_8 2 1 3 0   0     0   0   6 *                       6 2 1 3 0   0     0   0   6                   6
1124860 1124860 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Lawrence   Regular School No Middle 07 08 2017   grade_8 228 12 5 4   10     0   19   134 144                       278 228 12 5 4   10     0   19   134 144                 278
1124883 1124883 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Memorial Intermediate   Regular School No Middle 05 08 2017   grade_8 56 14 82 0   7     0   16   73 102                       175 56 14 82 0   7     0   16   73 102                 175
1124895 1124895 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_8 28 8 61 0   3     0   11   62 49                       111 28 8 61 0   3     0   11   62 49                 111
1124906 1124906 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 McKay Arts Academy   Regular School No Elementary PK 08 2017   grade_8 23 6 34 0   3     0   9   27 48                       75 23 6 34 0   3     0   9   27 48                 75
1124951 1124951 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 John J Ahern   Regular School No Middle 05 08 2017   grade_8 174 5 5 0   7     0   2   98 95                       193 174 5 5 0   7     0   2   98 95                 193
1125022 1125022 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_8 120 17 40 0   2     0   7   97 89                       186 120 17 40 0   2     0   7   97 89                 186
1125026 1125026 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   grade_8 81 17 60 0   5     0   5   88 80                       168 81 17 60 0   5     0   5   88 80                 168
1125030 1125030 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_8 139 6 57 0   20     0   6   105 123                       228 139 6 57 0   20     0   6   105 123                 228
1125083 1125083 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_8 141 3 0 0   7     0   1   77 75                       152 141 3 0 0   7     0   1   77 75                 152
1125087 1125087 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   grade_8 146 3 6 1   6     0   4   94 72                       166 146 3 6 1   6     0   4   94 72                 166
1125091 1125091 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   grade_8 137 3 1 1   12     0   2   72 84                       156 137 3 1 1   12     0   2   72 84                 156
1125110 1125110 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2017   grade_8 144 5 22 0   3     0   7   96 85                       181 144 5 22 0   3     0   7   96 85                 181
1125132 1125132 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_8 112 0 0 0   1     0   1   59 55                       114 112 0 0 0   1     0   1   59 55                 114
1125178 1125178 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_8 157 2 23 1   0     1   4   85 103                       188 157 2 23 1   0     1   4   85 103                 188
1125194 1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125221 1125221 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2017   grade_8 174 4 10 0   19     0   7   106 108                       214 174 4 10 0   19     0   7   106 108                 214
1125239 1125239 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2017   grade_8 51 1 6 0   3     0   0   39 22                       61 51 1 6 0   3     0   0   39 22                 61
1125268 1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125285 1125285 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2017   grade_8 66 0 15 0   2     0   7   53 37                       90 66 0 15 0   2     0   7   53 37                 90
1125301 1125301 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2017   grade_8 45 0 2 0   0     0   2   28 21                       49 45 0 2 0   0     0   2   28 21                 49
1125339 1125339 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_8 214 2 5 0   5     0   0   116 110                       226 214 2 5 0   5     0   0   116 110                 226
1125356 1125356 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_8 83 3 2 0   11     0   4   57 46                       103 83 3 2 0   11     0   4   57 46                 103
1125372 1125372 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_8 32 1 1 0   0     0   0   25 9                       34 32 1 1 0   0     0   0   25 9                 34
1125399 1125399 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill Alternative School   Regular School No High 07 12 2017   grade_8 5 0 4 0   0     0   0   7 2                       9 5 0 4 0   0     0   0   7 2                 9
1125407 1125407 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_8 96 4 26 0   3     0   1   68 62                       130 96 4 26 0   3     0   1   68 62                 130
1125414 1125414 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_8 80 2 50 0   2     0   0   65 69                       134 80 2 50 0   2     0   0   65 69                 134
1125426 1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1125441 1125441 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_8 92 2 33 0   1     0   1   74 55                       129 92 2 33 0   1     0   1   74 55                 129
1125450 1125450 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_8 134 7 86 0   3     0   2   120 112                       232 134 7 86 0   3     0   2   120 112                 232
1125488 1125488 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_8 335 5 5 0   9     0   6   167 193                       360 335 5 5 0   9     0   6   167 193                 360
1125506 1125506 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_8 57 12 13 0   5     0   2   50 39                       89 57 12 13 0   5     0   2   50 39                 89
1125532 1125532 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_8 193 1 6 2   17     0   5   115 109                       224 193 1 6 2   17     0   5   115 109                 224
1125553 1125553 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_8 10 0 33 1   0     0   0   29 15                       44 10 0 33 1   0     0   0   29 15                 44
1125564 1125564 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_8 0 0 39 0   0     0   0   19 20                       39 0 0 39 0   0     0   0   19 20                 39
1125570 1125570 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_8 5 0 65 0   0     0   0   37 33                       70 5 0 65 0   0     0   0   37 33                 70
1125580 1125580 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_8 1 0 40 0   2     0   0   17 26                       43 1 0 40 0   2     0   0   17 26                 43
1125591 1125591 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_8 8 0 35 0   0     0   2   21 24                       45 8 0 35 0   0     0   2   21 24                 45
1125601 1125601 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_8 5 1 47 0   2     0   1   29 27                       56 5 1 47 0   2     0   1   29 27                 56
1125612 1125612 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_8 9 4 35 0   1     0   0   28 21                       49 9 4 35 0   1     0   0   28 21                 49
1125639 1125639 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_8 81 0 1 1   4     0   1   43 45                       88 81 0 1 1   4     0   1   43 45                 88
1125658 1125658 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2017   grade_8 264 3 2 1   37     0   2   147 162                       309 264 3 2 1   37     0   2   147 162                 309
1125689 1125689 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2017   grade_8 201 3 9 2   3     0   3   115 106                       221 201 3 9 2   3     0   3   115 106                 221
1125705 1125705 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2017   grade_8 73 2 1 0   0     0   2   38 40                       78 73 2 1 0   0     0   2   38 40                 78
1125730 1125730 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2017   grade_8 146 1 5 0   4     0   4   81 79                       160 146 1 5 0   4     0   4   81 79                 160
1125783 1125783 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_8 1 1 80 0   3     0   0   44 41                       85 1 1 80 0   3     0   0   44 41                 85
1125788 1125788 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_8 2 1 143 0   0     0   0   73 73                       146 2 1 143 0   0     0   0   73 73                 146
1125809 1125809 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_8 2 2 119 0   4     0   2   62 67                       129 2 2 119 0   4     0   2   62 67                 129
1125814 1125814 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_8 11 0 113 0   1     0   1   70 56                       126 11 0 113 0   1     0   1   70 56                 126
1125831 1125831 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_8 1 1 100 0   1     0   0   49 54                       103 1 1 100 0   1     0   0   49 54                 103
1125853 1125853 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_8 4 0 87 0   4     0   1   52 44                       96 4 0 87 0   4     0   1   52 44                 96
1125857 1125857 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2017   grade_8 8 0 147 0   5     0   0   75 85                       160 8 0 147 0   5     0   0   75 85                 160
1125861 1125861 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_8 2 2 113 0   0     0   0   61 56                       117 2 2 113 0   0     0   0   61 56                 117
1125871 1125871 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_8 14 2 94 0   7     0   1   63 55                       118 14 2 94 0   7     0   1   63 55                 118
1125885 1125885 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_8 1 0 17 0   1     0   0   15 4                       19 1 0 17 0   1     0   0   15 4                 19
1125906 1125906 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_8 57 0 1 0   1     0   0   25 34                       59 57 0 1 0   1     0   0   25 34                 59
1125923 1125923 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_8 98 3 14 0   4     0   2   73 48                       121 98 3 14 0   4     0   2   73 48                 121
1125940 1125940 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_8 54 0 5 0   7     0   3   37 32                       69 54 0 5 0   7     0   3   37 32                 69
1125982 1125982 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2017   grade_8 92 14 45 0   4     0   2   78 79                       157 92 14 45 0   4     0   2   78 79                 157
1125986 1125986 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2017   grade_8 161 22 90 1   10     0   9   157 136                       293 161 22 90 1   10     0   9   157 136                 293
1126058 1126058 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_8 133 13 10 1   99     0   15   129 142                       271 133 13 10 1   99     0   15   129 142                 271
1126062 1126062 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_8 152 5 9 1   85     0   14   141 125                       266 152 5 9 1   85     0   14   141 125                 266
1126084 1126084 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_8 46 7 6 0   8     0   5   28 44                       72 46 7 6 0   8     0   5   28 44                 72
1126090 1126090 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_8 14 6 7 0   2     0   5   20 14                       34 14 6 7 0   2     0   5   20 14                 34
1126103 1126103 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_8 104 0 3 1   11     0   3   49 73                       122 104 0 3 1   11     0   3   49 73                 122
1126126 1126126 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_8 81 6 5 0   12     0   5   58 51                       109 81 6 5 0   12     0   5   58 51                 109
1126138 1126138 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_8 97 1 5 1   8     0   4   60 56                       116 97 1 5 1   8     0   4   60 56                 116

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