enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 491 ✖

grade ✖

  • grade_7 · 491 ✖
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
932544 932544 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Frolio Middle School   Regular School No 2 07 08 2016   grade_7 150 7 8 0   1     0   3   90 79                       169 150 7 8 0   1     0   3   90 79                 169
932726 932726 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2016   grade_7 303 15 22 0   28     0   14   189 193                       382 303 15 22 0   28     0   14   189 193                 382
935142 935142 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No 2 06 08 2016   grade_7 116 16 39 0   2     0   5   93 85                       178 116 16 39 0   2     0   5   93 85                 178
935145 935145 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2016   grade_7 74 10 58 0   4     0   4   84 66                       150 74 10 58 0   4     0   4   84 66                 150
935148 935148 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No 2 06 08 2016   grade_7 136 7 58 0   20     0   6   104 123                       227 136 7 58 0   20     0   6   104 123                 227
935192 935192 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No 2 06 08 2016   grade_7 141 3 1 0   7     0   1   79 74                       153 141 3 1 0   7     0   1   79 74                 153
935195 935195 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No 2 06 08 2016   grade_7 143 4 6 1   6     0   4   92 72                       164 143 4 6 1   6     0   4   92 72                 164
935198 935198 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No 2 06 08 2016   grade_7 135 2 0 1   12     0   2   72 80                       152 135 2 0 1   12     0   2   72 80                 152
935213 935213 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner Middle School   Regular School No 2 05 07 2016   grade_7 149 3 24 0   3     0   10   99 90                       189 149 3 24 0   3     0   10   99 90                 189
935232 935232 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 07 08 2016   grade_7 111 0 0 0   2     0   1   59 55                       114 111 0 0 0   2     0   1   59 55                 114
935270 935270 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No 2 06 08 2016   grade_7 161 0 20 1   0     1   3   87 99                       186 161 0 20 1   0     1   3   87 99                 186
935295 935295 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No 2 07 08 2016   grade_7 176 4 9 0   23     0   8   107 113                       220 176 4 9 0   23     0   8   107 113                 220
935309 935309 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No 3 07 12 2016   grade_7 52 1 6 0   3     0   0   38 24                       62 52 1 6 0   3     0   0   38 24                 62
935335 935335 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No 2 04 07 2016   grade_7 63 0 17 0   3     0   11   55 39                       94 63 0 17 0   3     0   11   55 39                 94
935350 935350 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No 3 07 12 2016   grade_7 44 0 2 0   0     0   2   29 19                       48 44 0 2 0   0     0   2   29 19                 48
935383 935383 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No 2 05 08 2016   grade_7 214 1 5 0   7     0   0   117 110                       227 214 1 5 0   7     0   0   117 110                 227
935398 935398 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No 4 06 12 2016   grade_7 79 3 3 0   11     0   3   52 47                       99 79 3 3 0   11     0   3   52 47                 99
935412 935412 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No 3 07 12 2016   grade_7 35 0 1 0   0     0   0   26 10                       36 35 0 1 0   0     0   0   26 10                 36
935439 935439 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_7 99 5 23 0   3     0   0   70 60                       130 99 5 23 0   3     0   0   70 60                 130
935444 935444 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_7 79 2 53 0   2     0   0   66 70                       136 79 2 53 0   2     0   0   66 70                 136
935454 935454 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No 4 01 12 2016   grade_7 * * * *   *     *   *   2 3                       5                         2 3                 5
935467 935467 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_7 97 2 30 0   1     0   0   74 56                       130 97 2 30 0   1     0   0   74 56                 130
935475 935475 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No 1 01 08 2016   grade_7 136 7 66 0   2     0   2   106 107                       213 136 7 66 0   2     0   2   106 107                 213
935508 935508 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No 2 06 08 2016   grade_7 342 5 4 0   8     0   6   173 192                       365 342 5 4 0   8     0   6   173 192                 365
935523 935523 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No 3 07 12 2016   grade_7 62 11 15 0   5     0   2   52 43                       95 62 11 15 0   5     0   2   52 43                 95
935545 935545 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No 2 06 08 2016   grade_7 198 1 5 2   15     0   5   113 113                       226 198 1 5 2   15     0   5   113 113                 226
935562 935562 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No 1 KG 08 2016   grade_7 12 0 29 1   0     0   0   26 16                       42 12 0 29 1   0     0   0   26 16                 42
935572 935572 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Morgan Full Service Community School   Regular School No 1 PK 08 2016   grade_7 2 0 35 0   0     0   0   19 18                       37 2 0 35 0   0     0   0   19 18                 37
935577 935577 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No 2 04 08 2016   grade_7 3 0 60 0   0     0   0   32 31                       63 3 0 60 0   0     0   0   32 31                 63
935586 935586 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No 1 KG 08 2016   grade_7 0 0 45 0   2     0   0   20 27                       47 0 0 45 0   2     0   0   20 27                 47
935596 935596 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 E N White Elementary   Regular School No 1 PK 08 2016   grade_7 7 0 38 0   0     0   1   20 26                       46 7 0 38 0   0     0   1   20 26                 46
935605 935605 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No 1 KG 08 2016   grade_7 6 1 47 0   0     0   1   26 29                       55 6 1 47 0   0     0   1   26 29                 55
935615 935615 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No 1 PK 08 2016   grade_7 6 4 49 0   1     0   0   36 24                       60 6 4 49 0   1     0   0   36 24                 60
935638 935638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No 3 07 12 2016   grade_7 78 0 1 1   4     0   1   42 43                       85 78 0 1 1   4     0   1   42 43                 85
935652 935652 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No 2 06 08 2016   grade_7 266 3 2 1   34     0   2   149 159                       308 266 3 2 1   34     0   2   149 159                 308
932740 932740 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_7 150 4 25 0   18     0   8   98 107                       205 150 4 25 0   18     0   8   98 107                 205
935678 935678 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 David J. Quinn Middle School   Regular School No 2 05 07 2016   grade_7 191 4 11 2   3     0   3   111 103                       214 191 4 11 2   3     0   3   111 103                 214
935693 935693 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No 2 06 08 2016   grade_7 75 2 1 0   0     0   2   38 42                       80 75 2 1 0   0     0   2   38 42                 80
935714 935714 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No 2 06 08 2016   grade_7 150 1 6 0   4     0   4   86 79                       165 150 1 6 0   4     0   4   86 79                 165
935757 935757 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No 1 03 08 2016   grade_7 1 1 84 0   3     0   0   48 41                       89 1 1 84 0   3     0   0   48 41                 89
935761 935761 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_7 2 1 132 0   0     0   0   72 63                       135 2 1 132 0   0     0   0   72 63                 135
935778 935778 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_7 3 3 113 0   4     0   1   62 62                       124 3 3 113 0   4     0   1   62 62                 124
935782 935782 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2016   grade_7 9 0 115 0   1     0   1   70 56                       126 9 0 115 0   1     0   1   70 56                 126
935796 935796 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No 2 06 08 2016   grade_7 1 1 90 0   1     0   0   45 48                       93 1 1 90 0   1     0   0   45 48                 93
935815 935815 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No 1 KG 08 2016   grade_7 4 0 77 0   4     0   1   49 37                       86 4 0 77 0   4     0   1   49 37                 86
935818 935818 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No 2 06 08 2016   grade_7 11 0 138 0   5     0   0   73 81                       154 11 0 138 0   5     0   0   73 81                 154
935821 935821 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2016   grade_7 1 2 117 0   0     0   0   60 60                       120 1 2 117 0   0     0   0   60 60                 120
935826 935826 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_7 16 1 104 0   7     0   1   68 61                       129 16 1 104 0   7     0   1   68 61                 129
935864 935864 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No 4 01 12 2016   grade_7 2 0 19 0   1     0   0   16 6                       22 2 0 19 0   1     0   0   16 6                 22
935883 935883 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No 3 07 12 2016   grade_7 56 0 2 0   1     0   0   25 34                       59 56 0 2 0   1     0   0   25 34                 59
935897 935897 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2016   grade_7 102 2 10 0   3     0   1   68 50                       118 102 2 10 0   3     0   1   68 50                 118
935911 935911 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No 4 06 12 2016   grade_7 52 0 4 0   6     0   2   35 29                       64 52 0 4 0   6     0   2   35 29                 64
935945 935945 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No 2 06 08 2016   grade_7 92 13 46 0   4     0   2   81 76                       157 92 13 46 0   4     0   2   81 76                 157
935948 935948 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No 2 06 08 2016   grade_7 160 17 88 0   10     0   8   155 128                       283 160 17 88 0   10     0   8   155 128                 283
936004 936004 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No 2 06 08 2016   grade_7 130 14 10 1   95     0   14   130 134                       264 130 14 10 1   95     0   14   130 134                 264
936007 936007 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No 2 06 08 2016   grade_7 147 5 10 1   78     0   13   134 120                       254 147 5 10 1   78     0   13   134 120                 254
936026 936026 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No 1 PK 08 2016   grade_7 45 7 7 0   8     0   5   28 44                       72 45 7 7 0   8     0   5   28 44                 72
936031 936031 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No 2 04 08 2016   grade_7 17 11 11 2   1     0   6   23 25                       48 17 11 11 2   1     0   6   23 25                 48
936041 936041 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_7 100 0 3 1   9     0   2   47 68                       115 100 0 3 1   9     0   2   47 68                 115
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119
932774 932774 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_7 142 6 15 0   5     0   4   85 87                       172 142 6 15 0   5     0   4   85 87                 172
932778 932778 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_7 95 9 17 0   6     2   12   79 62                       141 95 9 17 0   6     2   12   79 62                 141
932782 932782 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_7 86 9 30 0   11     0   9   73 72                       145 86 9 30 0   11     0   9   73 72                 145
936107 936107 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No 1 PK 08 2016   grade_7 29 7 7 0   7     0   2   21 31                       52 29 7 7 0   7     0   2   21 31                 52
936167 936167 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No 1 02 07 2016   grade_7 * * * *   *     *   *   3 *                       3                         3                   3
936176 936176 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No 1 PK 08 2016   grade_7 12 4 22 0   16     0   4   37 21                       58 12 4 22 0   16     0   4   37 21                 58
936180 936180 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2016   grade_7 56 8 32 0   41     0   1   66 72                       138 56 8 32 0   41     0   1   66 72                 138
936184 936184 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No 2 05 08 2016   grade_7 51 10 27 0   69     0   11   88 80                       168 51 10 27 0   69     0   11   88 80                 168
936193 936193 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No 2 05 08 2016   grade_7 32 12 71 0   35     0   6   84 72                       156 32 12 71 0   35     0   6   84 72                 156
936197 936197 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No 2 05 08 2016   grade_7 69 15 60 0   17     0   4   88 77                       165 69 15 60 0   17     0   4   88 77                 165
936201 936201 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No 2 05 08 2016   grade_7 61 9 68 0   29     0   4   93 78                       171 61 9 68 0   29     0   4   93 78                 171
936205 936205 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No 2 05 08 2016   grade_7 15 4 43 0   101     0   5   90 78                       168 15 4 43 0   101     0   5   90 78                 168
936220 936220 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No 2 06 08 2016   grade_7 204 5 15 1   3     2   5   110 125                       235 204 5 15 1   3     2   5   110 125                 235
936235 936235 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_7 112 1 5 1   0     0   0   69 50                       119 112 1 5 1   0     0   0   69 50                 119
936357 936357 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No 2 06 08 2016   grade_7 36 34 233 0   29     0   10   194 148                       342 36 34 233 0   29     0   10   194 148                 342
936360 936360 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No 2 06 08 2016   grade_7 57 45 241 1   40     0   12   216 180                       396 57 45 241 1   40     0   12   216 180                 396
936363 936363 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No 2 06 08 2016   grade_7 92 12 65 1   21     0   9   112 88                       200 92 12 65 1   21     0   9   112 88                 200
936373 936373 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 8 1 3 0   0     0   0   8 4                       12 8 1 3 0   0     0   0   8 4                 12
936399 936399 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No 2 05 08 2016   grade_7 170 1 10 0   6     0   5   90 102                       192 170 1 10 0   6     0   5   90 102                 192
936412 936412 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No 1 KG 08 2016   grade_7 29 12 13 0   26     1   3   44 40                       84 29 12 13 0   26     1   3   44 40                 84
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101
936430 936430 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No 1 KG 08 2016   grade_7 27 10 16 0   7     0   0   35 25                       60 27 10 16 0   7     0   0   35 25                 60
936439 936439 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No 1 KG 08 2016   grade_7 37 17 17 0   21     0   3   46 49                       95 37 17 17 0   21     0   3   46 49                 95
936449 936449 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2016   grade_7 26 25 26 0   23     0   6   53 53                       106 26 25 26 0   23     0   6   53 53                 106
936463 936463 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No 2 06 08 2016   grade_7 314 13 11 0   19     0   12   187 182                       369 314 13 11 0   19     0   12   187 182                 369
936486 936486 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No 2 07 08 2016   grade_7 216 6 19 0   5     0   9   125 130                       255 216 6 19 0   5     0   9   125 130                 255
932802 932802 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No 2 06 08 2016   grade_7 181 3 6 1   10     0   5   100 106                       206 181 3 6 1   10     0   5   100 106                 206
936519 936519 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No 2 05 08 2016   grade_7 153 5 134 0   7     0   7   163 143                       306 153 5 134 0   7     0   7   163 143                 306
936559 936559 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No 2 06 08 2016   grade_7 309 0 13 1   4     0   3   160 170                       330 309 0 13 1   4     0   3   160 170                 330
936569 936569 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_7 123 7 6 8   3     0   2   69 80                       149 123 7 6 8   3     0   2   69 80                 149
936595 936595 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2016   grade_7 94 2 7 0   2     0   3   52 56                       108 94 2 7 0   2     0   3   52 56                 108
936609 936609 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No 2 06 08 2016   grade_7 178 1 4 0   10     0   7   105 95                       200 178 1 4 0   10     0   7   105 95                 200
936644 936644 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No 2 06 08 2016   grade_7 123 12 8 0   11     1   4   80 79                       159 123 12 8 0   11     1   4   80 79                 159
936647 936647 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No 2 06 08 2016   grade_7 88 20 25 0   18     0   7   84 74                       158 88 20 25 0   18     0   7   84 74                 158
936671 936671 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No 2 05 08 2016   grade_7 139 4 5 1   12     0   1   84 78                       162 139 4 5 1   12     0   1   84 78                 162
936709 936709 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No 2 06 08 2016   grade_7 233 15 5 0   9     0   7   126 143                       269 233 15 5 0   9     0   7   126 143                 269
932818 932818 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No 3 07 12 2016   grade_7 34 21 4 1   4     0   2   36 30                       66 34 21 4 1   4     0   2   36 30                 66
936723 936723 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2016   grade_7 113 4 27 0   3     0   2   74 75                       149 113 4 27 0   3     0   2   74 75                 149
936733 936733 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2016   grade_7 81 4 51 0   7     0   1   69 75                       144 81 4 51 0   7     0   1   69 75                 144

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