enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1121957 1121957 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No Middle 07 08 2017   grade_7 142 2 9 0   5     0   1   84 75                       159 142 2 9 0   5     0   1   84 75                 159
1122176 1122176 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_7 302 16 22 0   48     0   21   201 208                       409 302 16 22 0   48     0   21   201 208                 409
1125021 1125021 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2017   grade_7 117 12 36 1   6     0   6   93 85                       178 117 12 36 1   6     0   6   93 85                 178
1125025 1125025 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2017   grade_7 78 9 55 0   3     1   0   79 67                       146 78 9 55 0   3     1   0   79 67                 146
1125029 1125029 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2017   grade_7 132 13 81 0   22     0   9   132 125                       257 132 13 81 0   22     0   9   132 125                 257
1125082 1125082 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2017   grade_7 140 0 5 0   6     2   1   81 73                       154 140 0 5 0   6     2   1   81 73                 154
1125086 1125086 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2017   grade_7 137 1 6 0   8     0   5   83 74                       157 137 1 6 0   8     0   5   83 74                 157
1125090 1125090 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2017   grade_7 136 3 4 0   13     0   1   83 74                       157 136 3 4 0   13     0   1   83 74                 157
1125108 1125108 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No Middle 05 07 2017   grade_7 123 6 30 1   3     0   18   96 85                       181 123 6 30 1   3     0   18   96 85                 181
1125131 1125131 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_7 112 1 1 0   2     0   1   66 51                       117 112 1 1 0   2     0   1   66 51                 117
1125177 1125177 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2017   grade_7 206 3 17 0   2     0   6   119 115                       234 206 3 17 0   2     0   6   119 115                 234
1125193 1125193 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125220 1125220 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2017   grade_7 220 3 9 0   30     0   9   135 136                       271 220 3 9 0   30     0   9   135 136                 271
1125238 1125238 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2017   grade_7 68 1 5 0   0     0   0   41 33                       74 68 1 5 0   0     0   0   41 33                 74
1125267 1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125283 1125283 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_7 88 4 20 0   4     0   9   66 59                       125 88 4 20 0   4     0   9   66 59                 125
1125300 1125300 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2017   grade_7 34 2 3 1   0     1   1   24 18                       42 34 2 3 1   0     1   1   24 18                 42
1125338 1125338 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2017   grade_7 201 1 3 0   4     0   0   115 94                       209 201 1 3 0   4     0   0   115 94                 209
1125355 1125355 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_7 76 2 3 0   16     0   1   44 54                       98 76 2 3 0   16     0   1   44 54                 98
1125371 1125371 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2017   grade_7 41 0 0 0   3     0   2   19 27                       46 41 0 0 0   3     0   2   19 27                 46
1125406 1125406 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_7 100 6 21 0   2     0   1   64 66                       130 100 6 21 0   2     0   1   64 66                 130
1125413 1125413 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_7 69 7 41 0   2     0   0   52 67                       119 69 7 41 0   2     0   0   52 67                 119
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1125440 1125440 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_7 97 7 30 0   3     1   1   67 72                       139 97 7 30 0   3     1   1   67 72                 139
1125449 1125449 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Elementary 01 08 2017   grade_7 96 8 98 0   3     0   1   99 107                       206 96 8 98 0   3     0   1   99 107                 206
1125487 1125487 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2017   grade_7 340 4 11 0   8     1   11   195 180                       375 340 4 11 0   8     1   11   195 180                 375
1125505 1125505 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_7 69 21 11 0   5     0   9   60 55                       115 69 21 11 0   5     0   9   60 55                 115
1125531 1125531 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2017   grade_7 195 1 7 1   18     0   4   100 126                       226 195 1 7 1   18     0   4   100 126                 226
1125552 1125552 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2017   grade_7 14 0 37 0   0     0   1   30 22                       52 14 0 37 0   0     0   1   30 22                 52
1125563 1125563 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No Elementary PK 08 2017   grade_7 1 1 34 0   1     0   0   14 23                       37 1 1 34 0   1     0   0   14 23                 37
1125569 1125569 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Elementary 04 08 2017   grade_7 7 2 84 0   0     0   0   47 46                       93 7 2 84 0   0     0   0   47 46                 93
1125579 1125579 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary KG 08 2017   grade_7 1 1 51 0   0     0   0   30 23                       53 1 1 51 0   0     0   0   30 23                 53
1125590 1125590 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No Elementary PK 08 2017   grade_7 6 1 42 0   0     0   1   25 25                       50 6 1 42 0   0     0   1   25 25                 50
1125600 1125600 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2017   grade_7 6 0 44 0   0     0   2   26 26                       52 6 0 44 0   0     0   2   26 26                 52
1125611 1125611 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2017   grade_7 6 3 49 0   0     0   0   36 22                       58 6 3 49 0   0     0   0   36 22                 58
1125638 1125638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_7 95 2 5 0   0     0   1   50 53                       103 95 2 5 0   0     0   1   50 53                 103
1125657 1125657 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2017   grade_7 229 2 4 1   31     0   8   130 145                       275 229 2 4 1   31     0   8   130 145                 275
1122195 1122195 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_7 146 5 23 0   27     0   5   93 113                       206 146 5 23 0   27     0   5   93 113                 206
1125687 1125687 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No Middle 05 07 2017   grade_7 177 4 16 0   0     1   7   97 108                       205 177 4 16 0   0     1   7   97 108                 205
1125704 1125704 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2017   grade_7 61 0 0 0   1     0   1   35 28                       63 61 0 0 0   1     0   1   35 28                 63
1125729 1125729 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2017   grade_7 149 1 5 0   0     0   9   75 89                       164 149 1 5 0   0     0   9   75 89                 164
1125782 1125782 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Elementary 03 08 2017   grade_7 2 2 75 0   0     0   0   39 40                       79 2 2 75 0   0     0   0   39 40                 79
1125787 1125787 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_7 3 1 142 0   0     0   0   65 81                       146 3 1 142 0   0     0   0   65 81                 146
1125808 1125808 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_7 1 2 125 0   2     0   0   57 73                       130 1 2 125 0   2     0   0   57 73                 130
1125813 1125813 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_7 12 5 127 0   0     0   1   82 63                       145 12 5 127 0   0     0   1   82 63                 145
1125830 1125830 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_7 2 2 113 0   0     0   0   71 46                       117 2 2 113 0   0     0   0   71 46                 117
1125852 1125852 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2017   grade_7 8 0 77 0   3     0   0   44 44                       88 8 0 77 0   3     0   0   44 44                 88
1125856 1125856 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2017   grade_7 3 3 149 0   3     0   0   75 83                       158 3 3 149 0   3     0   0   75 83                 158
1125860 1125860 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_7 6 1 116 0   0     0   0   63 60                       123 6 1 116 0   0     0   0   63 60                 123
1125870 1125870 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_7 16 3 98 0   3     0   1   63 58                       121 16 3 98 0   3     0   1   63 58                 121
1125884 1125884 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_7 2 1 10 0   0     0   0   11 2                       13 2 1 10 0   0     0   0   11 2                 13
1125905 1125905 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2017   grade_7 38 0 6 0   1     0   2   28 19                       47 38 0 6 0   1     0   2   28 19                 47
1125922 1125922 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_7 133 8 15 0   2     0   3   76 85                       161 133 8 15 0   2     0   3   76 85                 161
1125939 1125939 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No Other 06 12 2017   grade_7 62 1 2 0   2     0   1   18 50                       68 62 1 2 0   2     0   1   18 50                 68
1125981 1125981 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2017   grade_7 85 15 55 0   2     0   5   86 76                       162 85 15 55 0   2     0   5   86 76                 162
1125985 1125985 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2017   grade_7 168 24 84 1   19     0   10   160 146                       306 168 24 84 1   19     0   10   160 146                 306
1126057 1126057 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2017   grade_7 158 19 11 0   119     0   10   171 146                       317 158 19 11 0   119     0   10   171 146                 317
1126061 1126061 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2017   grade_7 150 13 4 0   95     0   19   129 152                       281 150 13 4 0   95     0   19   129 152                 281
1126083 1126083 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2017   grade_7 40 10 3 0   4     0   5   31 31                       62 40 10 3 0   4     0   5   31 31                 62
1126089 1126089 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Elementary 04 08 2017   grade_7 27 5 9 0   1     0   7   24 24                       49 27 5 9 0   1     0   7   24 24                 49
1126102 1126102 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_7 89 2 2 0   7     0   3   51 52                       103 89 2 2 0   7     0   3   51 52                 103
1126125 1126125 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_7 92 3 5 1   7     0   4   58 54                       112 92 3 5 1   7     0   4   58 54                 112
1126137 1126137 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_7 111 1 5 0   6     0   4   68 59                       127 111 1 5 0   6     0   4   68 59                 127
1122237 1122237 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_7 153 8 21 0   5     0   8   103 92                       195 153 8 21 0   5     0   8   103 92                 195
1122242 1122242 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_7 97 8 24 0   4     0   8   77 64                       141 97 8 24 0   4     0   8   77 64                 141
1122247 1122247 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_7 90 9 22 0   10     1   4   74 62                       136 90 9 22 0   10     1   4   74 62                 136
1126182 1126182 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2017   grade_7 33 2 9 0   4     0   2   28 22                       50 33 2 9 0   4     0   2   28 22                 50
1126252 1126252 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Elementary 02 07 2017   grade_7 2 0 3 0   0     0   1   6 *                       6 2 0 3 0   0     0   1   6                   6
1126262 1126262 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2017   grade_7 12 7 18 0   22     0   0   30 29                       59 12 7 18 0   22     0   0   30 29                 59
1126267 1126267 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_7 49 14 31 0   38     0   9   69 72                       141 49 14 31 0   38     0   9   69 72                 141
1126272 1126272 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2017   grade_7 48 5 32 0   73     0   11   84 85                       169 48 5 32 0   73     0   11   84 85                 169
1126282 1126282 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2017   grade_7 49 26 55 0   34     0   5   90 79                       169 49 26 55 0   34     0   5   90 79                 169
1126287 1126287 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 05 08 2017   grade_7 66 20 63 0   18     0   5   86 86                       172 66 20 63 0   18     0   5   86 86                 172
1126292 1126292 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2017   grade_7 55 15 62 0   29     0   4   82 83                       165 55 15 62 0   29     0   4   82 83                 165
1126297 1126297 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2017   grade_7 19 17 53 0   89     0   3   91 90                       181 19 17 53 0   89     0   3   91 90                 181
1126321 1126321 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2017   grade_7 214 7 14 0   1     0   6   123 119                       242 214 7 14 0   1     0   6   123 119                 242
1126339 1126339 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_7 119 3 15 2   2     3   1   76 69                       145 119 3 15 2   2     3   1   76 69                 145
1126482 1126482 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2017   grade_7 53 41 275 5   35     0   14   223 200                       423 53 41 275 5   35     0   14   223 200                 423
1126486 1126486 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2017   grade_7 65 43 261 5   57     0   16   226 221                       447 65 43 261 5   57     0   16   226 221                 447
1126490 1126490 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2017   grade_7 85 12 74 2   16     0   13   101 101                       202 85 12 74 2   16     0   13   101 101                 202
1126503 1126503 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_7 3 0 7 0   0     0   1   9 2                       11 3 0 7 0   0     0   1   9 2                 11
1126533 1126533 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2017   grade_7 164 1 3 0   5     0   4   83 94                       177 164 1 3 0   5     0   4   83 94                 177
1126548 1126548 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2017   grade_7 24 13 10 0   37     0   1   35 50                       85 24 13 10 0   37     0   1   35 50                 85
1126558 1126558 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_7 18 24 28 1   22     0   1   37 57                       94 18 24 28 1   22     0   1   37 57                 94
1126568 1126568 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2017   grade_7 23 9 11 0   3     0   5   21 30                       51 23 9 11 0   3     0   5   21 30                 51
1126578 1126578 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2017   grade_7 28 20 20 0   17     0   2   50 37                       87 28 20 20 0   17     0   2   50 37                 87
1126590 1126590 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_7 27 38 50 1   25     0   5   78 68                       146 27 38 50 1   25     0   5   78 68                 146
1126609 1126609 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2017   grade_7 267 9 10 0   18     0   14   162 156                       318 267 9 10 0   18     0   14   162 156                 318
1126638 1126638 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2017   grade_7 220 7 12 0   1     0   6   118 128                       246 220 7 12 0   1     0   6   118 128                 246
1122272 1122272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2017   grade_7 179 3 14 0   5     0   9   105 105                       210 179 3 14 0   5     0   9   105 105                 210
1126677 1126677 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2017   grade_7 132 9 137 0   3     0   13   163 131                       294 132 9 137 0   3     0   13   163 131                 294
1126723 1126723 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2017   grade_7 330 0 9 0   2     0   6   196 151                       347 330 0 9 0   2     0   6   196 151                 347
1126736 1126736 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_7 105 4 4 7   3     1   5   71 58                       129 105 4 4 7   3     1   5   71 58                 129
1126768 1126768 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_7 93 4 13 1   1     0   2   54 60                       114 93 4 13 1   1     0   2   54 60                 114
1126787 1126787 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2017   grade_7 189 1 3 0   7     0   7   106 101                       207 189 1 3 0   7     0   7   106 101                 207
1126828 1126828 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2017   grade_7 113 21 15 0   8     0   10   88 79                       167 113 21 15 0   8     0   10   88 79                 167
1126832 1126832 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No Middle 06 08 2017   grade_7 83 28 19 0   27     0   4   94 67                       161 83 28 19 0   27     0   4   94 67                 161
1126860 1126860 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2017   grade_7 172 3 7 1   8     0   4   100 95                       195 172 3 7 1   8     0   4   100 95                 195
1126906 1126906 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2017   grade_7 219 13 4 0   12     0   13   138 123                       261 219 13 4 0   12     0   13   138 123                 261
1122290 1122290 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2017   grade_7 39 12 2 0   3     0   3   33 26                       59 39 12 2 0   3     0   3   33 26                 59

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