enrollments

Data source: Big Local News · About: Big Local

493 rows where grade = "grade_8", state = "MA" and year = 2019 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 493 ✖

grade ✖

  • grade_8 · 493 ✖
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
2039819 2039819 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_8 147 7 12 0   3     0   3   83 89                       172.0 147 7 12 0   3     0   3   83 89                 172
2040002 2040002 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 07 08 2019   grade_8 301 18 21 0   42     0   32   184 230                       414.0 301 18 21 0   42     0   32   184 230                 414
2042452 2042452 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_8 123 12 27 0   5     0   7   84 90                       174.0 123 12 27 0   5     0   7   84 90                 174
2042455 2042455 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_8 70 22 65 0   6     1   12   92 84                       176.0 70 22 65 0   6     1   12   92 84                 176
2042458 2042458 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Walsh Middle   Regular School No Middle 06 08 2019   grade_8 138 14 72 0   13     0   5   134 108                       242.0 138 14 72 0   13     0   5   134 108                 242
2042502 2042502 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8 145 0 4 0   6     1   2   92 65                       158.0 145 0 4 0   6     1   2   92 65                 158
2042505 2042505 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2019   grade_8 119 3 6 0   9     0   1   62 76                       138.0 119 3 6 0   9     0   1   62 76                 138
2042508 2042508 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2019   grade_8 133 0 5 0   11     0   6   66 89                       155.0 133 0 5 0   11     0   6   66 89                 155
2042523 2042523 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner High   Regular School No High 08 12 2019   grade_8 94 1 34 0   6     0   15   72 78                       150.0 94 1 34 0   6     0   15   72 78                 150
2042542 2042542 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2019   grade_8 105 3 1 0   1     0   1   62 49                       111.0 105 3 1 0   1     0   1   62 49                 111
2042580 2042580 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Ralph B O'Maley Middle   Regular School No Middle 06 08 2019   grade_8 164 5 16 1   3     1   17   117 90                       207.0 164 5 16 1   3     1   17   117 90                 207
2042603 2042603 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton Middle   Regular School No Middle 07 08 2019   grade_8 214 7 8 0   30     0   6   125 140                       265.0 214 7 8 0   30     0   6   125 140                 265
2042618 2042618 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2019   grade_8 53 0 5 0   1     0   0   40 19                       59.0 53 0 5 0   1     0   0   40 19                 59
2042642 2042642 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield High   Regular School No High 08 12 2019   grade_8 88 2 28 0   1     0   6   65 60                       125.0 88 2 28 0   1     0   6   65 60                 125
2042657 2042657 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2019   grade_8 37 1 3 0   0     4   1   24 22                       46.0 37 1 3 0   0     4   1   24 22                 46
2042689 2042689 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2019   grade_8 172 2 2 0   5     0   0   91 90                       181.0 172 2 2 0   5     0   0   91 90                 181
2042704 2042704 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2019   grade_8 57 3 2 0   11     0   1   43 31                       74.0 57 3 2 0   11     0   1   43 31                 74
2042718 2042718 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2019   grade_8 28 0 3 0   0     0   0   15 16                       31.0 28 0 3 0   0     0   0   15 16                 31
2042745 2042745 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Caleb Dustin Hunking School   Regular School No Elementary KG 08 2019   grade_8 125 8 32 0   3     0   3   88 83                       171.0 125 8 32 0   3     0   3   88 83                 171
2042753 2042753 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2019   grade_8 69 7 58 0   5     0   1   75 65                       140.0 69 7 58 0   5     0   1   75 65                 140
2042772 2042772 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_8 * * * *   *     *   *   2 *                       2.0                         2                   2
2042789 2042789 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2019   grade_8 80 5 34 0   2     1   1   58 65                       123.0 80 5 34 0   2     1   1   58 65                 123
2042794 2042794 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_8 97 4 101 0   5     1   2   104 106                       210.0 97 4 101 0   5     1   2   104 106                 210
2042827 2042827 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham Middle School   Regular School No Middle 06 08 2019   grade_8 320 2 9 0   17     0   10   191 167                       358.0 320 2 9 0   17     0   10   191 167                 358
2042842 2042842 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Middle High School   Regular School No High 06 12 2019   grade_8 51 24 14 0   4     0   9   49 53                       102.0 51 24 14 0   4     0   9   49 53                 102
2042865 2042865 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Robert H. Adams Middle School   Regular School No Middle 06 08 2019   grade_8 171 3 18 2   20     0   5   115 104                       219.0 171 3 18 2   20     0   5   115 104                 219
2042886 2042886 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_8 10 1 22 0   0     0   1   16 18                       34.0 10 1 22 0   0     0   1   16 18                 34
2042897 2042897 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 William R. Peck School   Regular School No Middle 04 08 2019   grade_8 6 1 59 0   0     0   0   41 25                       66.0 6 1 59 0   0     0   0   41 25                 66
2042906 2042906 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_8 2 1 38 0   0     0   0   23 18                       41.0 2 1 38 0   0     0   0   23 18                 41
2042922 2042922 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2019   grade_8 5 3 50 0   0     0   0   25 33                       58.0 5 3 50 0   0     0   0   25 33                 58
2042932 2042932 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Maurice A Donahue Elementary   Regular School No Elementary PK 08 2019   grade_8 5 1 33 0   0     0   0   24 15                       39.0 5 1 33 0   0     0   0   24 15                 39
2042940 2042940 MA Hampden   school 2506270 137   Holyoke 250627002897 1370320 Holyoke STEM Academy   Regular School No Middle 06 08 2019   grade_8 8 4 68 0   0     0   1   38 43                       81.0 8 4 68 0   0     0   1   38 43                 81
2042954 2042954 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2019   grade_8 66 0 5 0   6     1   4   46 36                       82.0 66 0 5 0   6     1   4   46 36                 82
2042968 2042968 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton Middle School   Regular School No Middle 06 08 2019   grade_8 250 5 8 0   42     0   8   153 160                       313.0 250 5 8 0   42     0   8   153 160                 313
2040016 2040016 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_8 123 3 25 2   30     0   2   91 94                       185.0 123 3 25 2   30     0   2   91 94                 185
2042994 2042994 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson High   Regular School No High 08 12 2019   grade_8 179 4 22 0   2     0   8   103 112                       215.0 179 4 22 0   2     0   8   103 112                 215
2043008 2043008 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2019   grade_8 67 0 1 0   0     0   0   43 25                       68.0 67 0 1 0   0     0   0   43 25                 68
2043031 2043031 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich Middle School   Regular School No Middle 06 08 2019   grade_8 117 2 8 0   1     0   9   71 66                       137.0 117 2 8 0   1     0   9   71 66                 137
2043066 2043066 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Alexander B Bruce   Regular School No Middle 03 08 2019   grade_8 6 0 88 0   3     0   0   46 51                       97.0 6 0 88 0   3     0   0   46 51                 97
2043070 2043070 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2019   grade_8 3 0 165 0   0     0   1   95 74                       169.0 3 0 165 0   0     0   1   95 74                 169
2043087 2043087 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2019   grade_8 4 3 125 0   0     0   1   65 68                       133.0 4 3 125 0   0     0   1   65 68                 133
2043091 2043091 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2019   grade_8 5 0 158 0   1     0   0   88 76                       164.0 5 0 158 0   1     0   0   88 76                 164
2043104 2043104 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2019   grade_8 2 1 111 0   0     0   0   60 54                       114.0 2 1 111 0   0     0   0   60 54                 114
2043123 2043123 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_8 4 1 77 0   3     0   0   41 44                       85.0 4 1 77 0   3     0   0   41 44                 85
2043126 2043126 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Spark Academy   Regular School No Middle 06 08 2019   grade_8 4 2 146 0   2     0   1   66 88                       155.0 4 2 146 0   2     0   1   66 88                 155
2043129 2043129 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_8 2 1 111 0   1     0   0   64 51                       115.0 2 1 111 0   1     0   0   64 51                 115
2043138 2043138 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_8 6 2 119 0   2     0   1   71 59                       130.0 6 2 119 0   2     0   1   71 59                 130
2043162 2043162 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2019   grade_8 50 1 4 0   0     0   3   22 36                       58.0 50 1 4 0   0     0   3   22 36                 58
2043177 2043177 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_8 94 5 10 0   2     0   7   57 61                       118.0 94 5 10 0   2     0   7   57 61                 118
2043191 2043191 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox Memorial High   Regular School No High 06 12 2019   grade_8 62 0 5 0   4     0   0   36 35                       71.0 62 0 5 0   4     0   0   36 35                 71
2043225 2043225 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Samoset School   Regular School No Middle 06 08 2019   grade_8 105 8 40 0   5     0   6   87 76                       164.0 105 8 40 0   5     0   6   87 76                 164
2043228 2043228 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Sky View Middle School   Regular School No Middle 06 08 2019   grade_8 138 27 103 0   14     0   12   147 147                       294.0 138 27 103 0   14     0   12   147 147                 294
2043288 2043288 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Jonas Clarke Middle   Regular School No Middle 06 08 2019   grade_8 139 12 12 0   138     0   11   170 142                       312.0 139 12 12 0   138     0   11   170 142                 312
2043291 2043291 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Wm Diamond Middle   Regular School No Middle 06 08 2019   grade_8 149 9 10 0   137     0   23   160 168                       328.0 149 9 10 0   137     0   23   160 168                 328
2043310 2043310 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2019   grade_8 46 8 4 0   1     0   3   32 30                       62.0 46 8 4 0   1     0   3   32 30                 62
2043315 2043315 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Hanscom Middle   Regular School No Middle 04 08 2019   grade_8 33 5 9 1   1     0   4   24 29                       53.0 33 5 9 1   1     0   4   24 29                 53
2043325 2043325 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_8 99 0 2 1   9     0   7   58 60                       118.0 99 0 2 1   9     0   7   58 60                 118
2043344 2043344 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2019   grade_8 89 4 4 0   13     0   2   57 55                       112.0 89 4 4 0   13     0   2   57 55                 112
2043354 2043354 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2019   grade_8 85 1 4 0   7     0   3   60 40                       100.0 85 1 4 0   7     0   3   60 40                 100
2040050 2040050 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_8 109 4 7 0   5     0   11   71 65                       136.0 109 4 7 0   5     0   11   71 65                 136
2040054 2040054 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_8 85 10 34 1   3     0   10   75 67                       143.0 85 10 34 1   3     0   10   75 67                 143
2040058 2040058 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_8 97 8 24 0   8     0   2   83 56                       139.0 97 8 24 0   8     0   2   83 56                 139
2043395 2043395 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Pyne Arts   Regular School No Elementary PK 08 2019   grade_8 25 1 19 0   7     0   2   28 26                       54.0 25 1 19 0   7     0   2   28 26                 54
2043455 2043455 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2043465 2043465 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_8 8 3 20 0   22     0   1   23 31                       54.0 8 3 20 0   22     0   1   23 31                 54
2043469 2043469 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2019   grade_8 39 9 41 0   31     0   6   63 63                       126.0 39 9 41 0   31     0   6   63 63                 126
2043473 2043473 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 James S Daley Middle School   Regular School No Middle 05 08 2019   grade_8 42 9 34 0   76     0   7   91 77                       168.0 42 9 34 0   76     0   7   91 77                 168
2043481 2043481 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Henry J Robinson Middle   Regular School No Middle 05 08 2019   grade_8 39 20 61 0   27     0   5   81 71                       152.0 39 20 61 0   27     0   5   81 71                 152
2043484 2043484 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 James Sullivan Middle School   Regular School No Middle 06 08 2019   grade_8 39 15 66 0   24     0   5   73 76                       149.0 39 15 66 0   24     0   5   73 76                 149
2043488 2043488 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Dr An Wang School   Regular School No Middle 05 08 2019   grade_8 35 14 75 0   22     0   7   93 60                       153.0 35 14 75 0   22     0   7   93 60                 153
2043492 2043492 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2019   grade_8 17 5 59 0   81     0   6   92 76                       168.0 17 5 59 0   81     0   6   92 76                 168
2043519 2043519 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Paul R Baird Middle   Regular School No Middle 06 08 2019   grade_8 184 2 16 2   2     0   2   98 110                       208.0 184 2 16 2   2     0   2   98 110                 208
2043534 2043534 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2019   grade_8 105 2 14 0   2     0   3   74 52                       126.0 105 2 14 0   2     0   3   74 52                 126
2043653 2043653 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Thurgood Marshall Mid   Regular School No Middle 06 08 2019   grade_8 36 41 281 1   31     0   12   197 204                       402.0 36 41 281 1   31     0   12   197 204                 402
2043656 2043656 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Breed Middle School   Regular School No Middle 06 08 2019   grade_8 68 36 268 1   48     0   17   218 220                       438.0 68 36 268 1   48     0   17   218 220                 438
2043659 2043659 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Pickering Middle   Regular School No Middle 06 08 2019   grade_8 69 19 81 2   22     0   12   104 101                       205.0 69 19 81 2   22     0   12   104 101                 205
2043669 2043669 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2019   grade_8 1 1 9 1   0     0   1   7 6                       13.0 1 1 9 1   0     0   1   7 6                 13
2043676 2043676 MA Essex   school 2507110 163   Lynn 250711002277 1630605 Lynn Vocational Technical Institute   Career and Technical School No High 06 12 2019   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2043696 2043696 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield Middle School   Regular School No Middle 05 08 2019   grade_8 124 3 14 0   9     0   5   88 67                       155.0 124 3 14 0   9     0   5   88 67                 155
2043709 2043709 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Beebe   Regular School No Elementary KG 08 2019   grade_8 26 12 11 0   39     0   2   42 48                       90.0 26 12 11 0   39     0   2   42 48                 90
2043718 2043718 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2019   grade_8 17 20 32 0   19     0   6   46 48                       94.0 17 20 32 0   19     0   6   46 48                 94
2043727 2043727 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Forestdale   Regular School No Elementary KG 08 2019   grade_8 21 10 19 0   7     0   0   30 27                       57.0 21 10 19 0   7     0   0   30 27                 57
2043736 2043736 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Linden   Regular School No Elementary KG 08 2019   grade_8 36 19 17 1   17     0   3   45 48                       93.0 36 19 17 1   17     0   3   45 48                 93
2043746 2043746 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2019   grade_8 30 30 46 0   22     0   1   62 67                       129.0 30 30 46 0   22     0   1   62 67                 129
2043761 2043761 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Harold L Qualters Middle   Regular School No Middle 06 08 2019   grade_8 284 5 17 0   14     0   14   177 157                       334.0 284 5 17 0   14     0   14   177 157                 334
2043783 2043783 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead Veterans Middle School   Regular School No Middle 07 08 2019   grade_8 207 11 12 0   4     0   2   111 125                       236.0 207 11 12 0   4     0   2   111 125                 236
2040079 2040079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn Middle   Regular School No Middle 06 08 2019   grade_8 182 4 24 0   7     0   4   121 100                       221.0 182 4 24 0   7     0   4   121 100                 221
2043816 2043816 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_8 117 13 174 0   8     0   8   178 142                       320.0 117 13 174 0   8     0   8   178 142                 320
2043857 2043857 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Furnace Brook Middle   Regular School No Middle 06 08 2019   grade_8 323 2 7 0   4     1   3   179 161                       340.0 323 2 7 0   4     1   3   179 161                 340
2043867 2043867 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2019   grade_8 105 10 2 13   4     0   6   59 81                       140.0 105 10 2 13   4     0   6   59 81                 140
2043893 2043893 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Middle 04 08 2019   grade_8 74 1 10 0   2     0   4   48 43                       91.0 74 1 10 0   2     0   4   48 43                 91
2043907 2043907 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2019   grade_8 190 3 4 1   11     0   8   103 114                       217.0 190 3 4 1   11     0   8   103 114                 217
2043942 2043942 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Madeleine Dugger Andrews   Regular School No Middle 06 08 2019   grade_8 126 13 13 0   5     0   7   89 75                       164.0 126 13 13 0   5     0   7   89 75                 164
2043945 2043945 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 John J. McGlynn Middle School   Regular School No Middle 06 08 2019   grade_8 82 27 29 0   21     0   4   84 79                       163.0 82 27 29 0   21     0   4   84 79                 163
2043964 2043964 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway Middle   Regular School No Middle 05 08 2019   grade_8 157 1 9 1   5     0   2   78 97                       175.0 157 1 9 1   5     0   2   78 97                 175
2044003 2044003 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose Middle   Regular School No Middle 06 08 2019   grade_8 204 15 9 0   14     0   11   126 127                       253.0 204 15 9 0   14     0   11   126 127                 253
2040095 2040095 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon Middle High School   Regular School No High 07 12 2019   grade_8 35 19 7 0   1     0   4   28 38                       66.0 35 19 7 0   1     0   4   28 38                 66
2044018 2044018 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2019   grade_8 97 0 32 0   5     0   5   68 71                       139.0 97 0 32 0   5     0   5   68 71                 139
2044028 2044028 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2019   grade_8 64 2 49 0   10     0   7   60 72                       132.0 64 2 49 0   10     0   7   60 72                 132
2044038 2044038 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2019   grade_8 69 1 65 0   7     0   14   82 74                       156.0 69 1 65 0   7     0   14   82 74                 156

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