enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_8", state = "MA" and year = 2018 sorted by district_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_8 · 495 ✖
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
2228766 2228766 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_8 144 5 12 0   5     0   1   84 83                       167.0 144 5 12 0   5     0   1   84 83                 167
2228983 2228983 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_8 299 16 24 0   41     0   21   196 205                       401.0 299 16 24 0   41     0   21   196 205                 401
2231851 2231851 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   grade_8 115 16 36 1   5     0   6   94 85                       179.0 115 16 36 1   5     0   6   94 85                 179
2231855 2231855 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   grade_8 82 12 59 0   4     1   1   77 82                       159.0 82 12 59 0   4     1   1   77 82                 159
2231859 2231859 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_8 133 12 82 0   21     0   9   134 123                       257.0 133 12 82 0   21     0   9   134 123                 257
2231912 2231912 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_8 144 0 4 0   6     2   1   82 75                       157.0 144 0 4 0   6     2   1   82 75                 157
2231916 2231916 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   grade_8 134 0 6 0   7     0   5   82 70                       152.0 134 0 6 0   7     0   5   82 70                 152
2231920 2231920 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   grade_8 139 3 5 0   13     0   1   86 75                       161.0 139 3 5 0   13     0   1   86 75                 161
2231939 2231939 MA Worcester   school 2505130 103   Gardner 250513000751 1030505 Gardner: Gardner High   Regular School No High 08 12 2018   grade_8 108 5 32 1   3     0   14   91 72                       163.0 108 5 32 1   3     0   14   91 72                 163
2231961 2231961 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_8 112 1 2 0   2     0   1   65 53                       118.0 112 1 2 0   2     0   1   65 53                 118
2232007 2232007 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_8 198 3 21 0   2     0   5   115 114                       229.0 198 3 21 0   2     0   5   115 114                 229
2232023 2232023 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_8 * * * *   *     *   *   * *                       1.0                                             1
2232050 2232050 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_8 215 3 9 0   31     0   9   135 132                       267.0 215 3 9 0   31     0   9   135 132                 267
2232068 2232068 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_8 61 1 7 0   0     0   0   38 31                       69.0 61 1 7 0   0     0   0   38 31                 69
2232098 2232098 MA Franklin   school 2505490 114   Greenfield 250549000801 1140505 Greenfield: Greenfield High   Regular School No High 08 12 2018   grade_8 93 3 20 0   3     0   11   70 60                       130.0 93 3 20 0   3     0   11   70 60                 130
2232114 2232114 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_8 34 2 2 1   0     1   1   25 16                       41.0 34 2 2 1   0     1   1   25 16                 41
2232152 2232152 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_8 204 2 3 0   7     0   0   119 97                       216.0 204 2 3 0   7     0   0   119 97                 216
2232169 2232169 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard: Bromfield   Regular School No High 06 12 2018   grade_8 72 2 5 0   17     0   1   43 54                       97.0 72 2 5 0   17     0   1   43 54                 97
2232185 2232185 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield: Smith Academy   Regular School No High 07 12 2018   grade_8 42 0 0 0   3     0   3   20 28                       48.0 42 0 0 0   3     0   3   20 28                 48
2232218 2232218 MA Essex   school 2505970 128   Haverhill 250597002881 1280030 Haverhill: Caleb Dustin Hunking School   Regular School No Elementary KG 08 2018   grade_8 100 7 22 0   1     0   2   63 69                       132.0 100 7 22 0   1     0   2   63 69                 132
2232220 2232220 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill: Haverhill Alternative School   Regular School No High 06 12 2018   grade_8 6 1 3 0   0     0   0   7 3                       10.0 6 1 3 0   0     0   0   7 3                 10
2232230 2232230 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_8 67 8 38 0   3     0   0   51 65                       116.0 67 8 38 0   3     0   0   51 65                 116
2232241 2232241 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 Haverhill: TEACH   Regular School No Other KG 12 2018   grade_8 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2232259 2232259 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_8 96 6 37 0   2     1   1   69 74                       143.0 96 6 37 0   2     1   1   69 74                 143
2232266 2232266 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_8 91 9 101 0   3     0   0   104 100                       204.0 91 9 101 0   3     0   0   104 100                 204
2232304 2232304 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham: Hingham Middle School   Regular School No Middle 06 08 2018   grade_8 331 5 11 0   8     1   10   187 179                       366.0 331 5 11 0   8     1   10   187 179                 366
2232321 2232321 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook: Holbrook Middle High School   Regular School No High 06 12 2018   grade_8 67 20 10 0   7     0   9   57 56                       113.0 67 20 10 0   7     0   9   57 56                 113
2232347 2232347 MA Middlesex   school 2506240 136   Holliston 250624001304 1360305 Holliston: Robert H. Adams Middle School   Regular School No Middle 06 08 2018   grade_8 198 2 7 1   20     0   4   104 128                       232.0 198 2 7 1   20     0   4   104 128                 232
2232369 2232369 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Holyoke: Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2018   grade_8 15 0 45 0   0     0   2   38 24                       62.0 15 0 45 0   0     0   2   38 24                 62
2232380 2232380 MA Hampden   school 2506270 137   Holyoke 250627000910 1370025 Holyoke: Morgan Full Service Community School   Regular School No Elementary PK 08 2018   grade_8 0 1 34 0   1     0   1   15 22                       37.0 0 1 34 0   1     0   1   15 22                 37
2232386 2232386 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke: William R. Peck School   Regular School No Middle 04 08 2018   grade_8 7 2 74 0   0     0   0   37 46                       83.0 7 2 74 0   0     0   0   37 46                 83
2232397 2232397 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Holyoke: Kelly Elementary   Regular School No Elementary PK 08 2018   grade_8 2 1 42 0   0     0   0   25 20                       45.0 2 1 42 0   0     0   0   25 20                 45
2232408 2232408 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke: E N White Elementary   Regular School No Elementary PK 08 2018   grade_8 5 1 45 0   0     0   1   23 29                       52.0 5 1 45 0   0     0   1   23 29                 52
2232418 2232418 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_8 8 0 44 0   0     0   2   29 25                       54.0 8 0 44 0   0     0   2   29 25                 54
2232429 2232429 MA Hampden   school 2506270 137   Holyoke 250627000909 1370060 Holyoke: Maurice A Donahue Elementary   Regular School No Elementary PK 08 2018   grade_8 6 4 44 0   0     0   0   36 18                       54.0 6 4 44 0   0     0   0   36 18                 54
2232456 2232456 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale: Hopedale Jr Sr High   Regular School No High 07 12 2018   grade_8 94 1 5 0   0     0   1   50 51                       101.0 94 1 5 0   0     0   1   50 51                 101
2232475 2232475 MA Middlesex   school 2506330 139   Hopkinton 250633000468 1390305 Hopkinton: Hopkinton Middle School   Regular School No Middle 06 08 2018   grade_8 228 2 3 1   35     0   8   130 147                       277.0 228 2 3 1   35     0   8   130 147                 277
2229002 2229002 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_8 148 5 22 0   27     0   6   97 111                       208.0 148 5 22 0   27     0   6   97 111                 208
2232506 2232506 MA Middlesex   school 2506390 141   Hudson 250639000926 1410505 Hudson: Hudson High   Regular School No High 08 12 2018   grade_8 176 6 20 0   0     1   6   97 112                       209.0 176 6 20 0   0     1   6   97 112                 209
2232522 2232522 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull: Memorial Middle   Regular School No Middle 06 08 2018   grade_8 60 0 1 0   1     0   0   34 28                       62.0 60 0 1 0   1     0   0   34 28                 62
2232547 2232547 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_8 148 1 5 0   0     0   10   74 90                       164.0 148 1 5 0   0     0   10   74 90                 164
2232600 2232600 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_8 3 1 79 0   0     0   0   41 42                       83.0 3 1 79 0   0     0   0   41 42                 83
2232605 2232605 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_8 3 2 146 0   0     0   0   72 79                       151.0 3 2 146 0   0     0   0   72 79                 151
2232626 2232626 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_8 2 2 122 0   2     0   0   59 69                       128.0 2 2 122 0   2     0   0   59 69                 128
2232631 2232631 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_8 10 5 131 0   0     0   1   81 66                       147.0 10 5 131 0   0     0   1   81 66                 147
2232648 2232648 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_8 2 0 111 0   0     0   0   66 47                       113.0 2 0 111 0   0     0   0   66 47                 113
2232670 2232670 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Lawrence: Emily G Wetherbee   Regular School No Elementary KG 08 2018   grade_8 5 0 70 0   3     0   0   38 40                       78.0 5 0 70 0   3     0   0   38 40                 78
2232674 2232674 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence: Spark Academy   Regular School No Middle 06 08 2018   grade_8 2 2 155 0   4     0   0   81 82                       163.0 2 2 155 0   4     0   0   81 82                 163
2232678 2232678 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_8 5 2 112 0   0     0   0   63 56                       119.0 5 2 112 0   0     0   0   63 56                 119
2232688 2232688 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_8 12 4 105 0   3     0   1   66 59                       125.0 12 4 105 0   3     0   1   66 59                 125
2232701 2232701 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_8 1 1 8 0   0     0   0   9 1                       10.0 1 1 8 0   0     0   0   9 1                 10
2232722 2232722 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee: Lee Middle/High School   Regular School No High 07 12 2018   grade_8 45 0 3 0   1     0   2   30 21                       51.0 45 0 3 0   1     0   2   30 21                 51
2232739 2232739 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester: Leicester Middle   Regular School No Middle 06 08 2018   grade_8 136 8 13 0   3     0   4   77 87                       164.0 136 8 13 0   3     0   4   77 87                 164
2232756 2232756 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox: Lenox Memorial High   Regular School No High 06 12 2018   grade_8 60 1 2 0   2     0   1   20 46                       66.0 60 1 2 0   2     0   1   20 46                 66
2232798 2232798 MA Worcester   school 2506780 153   Leominster 250678000742 1530045 Leominster: Samoset School   Regular School No Middle 06 08 2018   grade_8 86 9 52 0   2     0   5   79 75                       154.0 86 9 52 0   2     0   5   79 75                 154
2232802 2232802 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster: Sky View Middle School   Regular School No Middle 06 08 2018   grade_8 158 24 89 2   20     0   9   155 147                       302.0 158 24 89 2   20     0   9   155 147                 302
2232874 2232874 MA Middlesex   school 2506840 155   Lexington 250684002551 1550305 Lexington: Jonas Clarke Middle   Regular School No Middle 06 08 2018   grade_8 155 18 10 0   121     0   10   167 147                       314.0 155 18 10 0   121     0   10   167 147                 314
2232878 2232878 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington: Wm Diamond Middle   Regular School No Middle 06 08 2018   grade_8 159 11 4 0   107     0   20   141 160                       301.0 159 11 4 0   107     0   20   141 160                 301
2232900 2232900 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln: Lincoln School   Regular School No Elementary PK 08 2018   grade_8 40 9 2 0   4     0   5   31 29                       60.0 40 9 2 0   4     0   5   31 29                 60
2232906 2232906 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln: Hanscom Middle   Regular School No Middle 04 08 2018   grade_8 27 5 9 0   1     0   5   29 18                       47.0 27 5 9 0   1     0   5   29 18                 47
2232919 2232919 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton: Littleton Middle School   Regular School No Middle 06 08 2018   grade_8 96 2 2 0   7     0   3   54 56                       110.0 96 2 2 0   7     0   3   54 56                 110
2232942 2232942 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow: Glenbrook Middle   Regular School No Middle 06 08 2018   grade_8 96 3 5 1   6     0   4   59 56                       115.0 96 3 5 1   6     0   4   59 56                 115
2232954 2232954 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow: Williams Middle   Regular School No Middle 06 08 2018   grade_8 108 3 4 0   6     0   3   66 58                       124.0 108 3 4 0   6     0   3   66 58                 124
2229044 2229044 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_8 147 8 24 0   5     0   8   98 94                       192.0 147 8 24 0   5     0   8   98 94                 192
2229049 2229049 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_8 95 9 25 0   5     0   7   77 64                       141.0 95 9 25 0   5     0   7   77 64                 141
2229054 2229054 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_8 95 10 24 1   9     1   3   81 62                       143.0 95 10 24 1   9     1   3   81 62                 143
2233000 2233000 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell: Pyne Arts   Regular School No Elementary PK 08 2018   grade_8 36 0 9 0   3     0   2   24 26                       50.0 36 0 9 0   3     0   2   24 26                 50
2233070 2233070 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell: Laura Lee Therapeutic Day School   Regular School No Middle KG 08 2018   grade_8 * * * *   *     *   *   5 *                       5.0                         5                   5
2233081 2233081 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell: Bartlett Community Partnership   Regular School No Elementary PK 08 2018   grade_8 13 6 19 0   21     0   1   31 29                       60.0 13 6 19 0   21     0   1   31 29                 60
2233086 2233086 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell: B.F. Butler Middle School   Regular School No Middle 05 08 2018   grade_8 48 10 31 0   41     0   10   71 69                       140.0 48 10 31 0   41     0   10   71 69                 140
2233091 2233091 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell: James S Daley Middle School   Regular School No Middle 05 08 2018   grade_8 43 4 31 0   73     0   11   80 82                       162.0 43 4 31 0   73     0   11   80 82                 162
2233101 2233101 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell: Henry J Robinson Middle   Regular School No Middle 05 08 2018   grade_8 43 25 58 0   38     0   6   93 77                       170.0 43 25 58 0   38     0   6   93 77                 170
2233106 2233106 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell: James Sullivan Middle School   Regular School No Middle 05 08 2018   grade_8 62 21 64 0   18     0   4   86 83                       169.0 62 21 64 0   18     0   4   86 83                 169
2233111 2233111 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell: Dr An Wang School   Regular School No Middle 05 08 2018   grade_8 56 18 63 0   32     0   4   81 92                       173.0 56 18 63 0   32     0   4   81 92                 173
2233116 2233116 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_8 20 21 53 0   84     0   3   87 94                       181.0 20 21 53 0   84     0   3   87 94                 181
2233145 2233145 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow: Paul R Baird Middle   Regular School No Middle 06 08 2018   grade_8 204 7 17 0   1     0   7   124 112                       236.0 204 7 17 0   1     0   7   124 112                 236
2233163 2233163 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_8 122 4 13 2   2     3   1   80 67                       147.0 122 4 13 2   2     3   1   80 67                 147
2233303 2233303 MA Essex   school 2507110 163   Lynn 250711000301 1630305 Lynn: Thurgood Marshall Mid   Regular School No Middle 06 08 2018   grade_8 53 40 291 6   35     0   15   227 213                       440.0 53 40 291 6   35     0   15   227 213                 440
2233307 2233307 MA Essex   school 2507110 163   Lynn 250711001063 1630405 Lynn: Breed Middle School   Regular School No Middle 06 08 2018   grade_8 65 40 256 4   52     0   12   223 206                       429.0 65 40 256 4   52     0   12   223 206                 429
2233311 2233311 MA Essex   school 2507110 163   Lynn 250711001083 1630420 Lynn: Pickering Middle   Regular School No Middle 06 08 2018   grade_8 79 11 77 2   15     0   15   96 103                       199.0 79 11 77 2   15     0   15   96 103                 199
2233324 2233324 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn: Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2018   grade_8 3 0 9 0   0     0   1   10 3                       13.0 3 0 9 0   0     0   1   10 3                 13
2233355 2233355 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield: Lynnfield Middle School   Regular School No Middle 05 08 2018   grade_8 163 1 3 0   4     0   3   82 92                       174.0 163 1 3 0   4     0   3   82 92                 174
2233370 2233370 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_8 23 15 14 0   39     0   1   40 52                       92.0 23 15 14 0   39     0   1   40 52                 92
2233380 2233380 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Malden: Ferryway   Regular School No Elementary KG 08 2018   grade_8 20 27 28 1   21     0   2   39 60                       99.0 20 27 28 1   21     0   2   39 60                 99
2233390 2233390 MA Middlesex   school 2507170 165   Malden 250717001351 1650027 Malden: Forestdale   Regular School No Elementary KG 08 2018   grade_8 23 10 10 0   5     0   4   23 29                       52.0 23 10 10 0   5     0   4   23 29                 52
2233400 2233400 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden: Linden   Regular School No Elementary KG 08 2018   grade_8 24 18 21 0   15     0   3   45 36                       81.0 24 18 21 0   15     0   3   45 36                 81
2233412 2233412 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_8 30 38 48 1   24     0   5   77 69                       146.0 30 38 48 1   24     0   5   77 69                 146
2233431 2233431 MA Bristol   school 2507230 167   Mansfield 250723001112 1670035 Mansfield: Harold L Qualters Middle   Regular School No Middle 06 08 2018   grade_8 262 8 10 1   18     0   14   163 150                       313.0 262 8 10 1   18     0   14   163 150                 313
2233460 2233460 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_8 227 6 12 0   1     0   7   124 129                       253.0 227 6 12 0   1     0   7   124 129                 253
2229079 2229079 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn: Auburn Middle   Regular School No Middle 06 08 2018   grade_8 184 3 14 0   5     0   10   109 107                       216.0 184 3 14 0   5     0   10   109 107                 216
2233499 2233499 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_8 130 11 142 0   3     0   12   170 128                       298.0 130 11 142 0   3     0   12   170 128                 298
2233545 2233545 MA Plymouth   school 2507350 171   Marshfield 250735001143 1710310 Marshfield: Furnace Brook Middle   Regular School No Middle 06 08 2018   grade_8 331 0 10 0   2     0   6   196 153                       349.0 331 0 10 0   2     0   6   196 153                 349
2233558 2233558 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_8 105 4 4 6   3     1   7   71 59                       130.0 105 4 4 6   3     1   7   71 59                 130
2233590 2233590 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_8 92 4 14 1   1     0   2   54 60                       114.0 92 4 14 1   1     0   2   54 60                 114
2233609 2233609 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield: Thomas Blake Middle   Regular School No Middle 06 08 2018   grade_8 188 1 3 0   9     0   8   110 99                       209.0 188 1 3 0   9     0   8   110 99                 209
2233650 2233650 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford: Madeleine Dugger Andrews   Regular School No Middle 06 08 2018   grade_8 105 17 15 0   9     0   12   86 72                       158.0 105 17 15 0   9     0   12   86 72                 158
2233654 2233654 MA Middlesex   school 2507560 176   Medford 250756002063 1760320 Medford: John J. McGlynn Middle School   Regular School No Middle 06 08 2018   grade_8 84 29 21 0   29     0   5   97 71                       168.0 84 29 21 0   29     0   5   97 71                 168
2233678 2233678 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway: Medway Middle   Regular School No Middle 05 08 2018   grade_8 170 3 5 1   7     0   4   93 97                       190.0 170 3 5 1   7     0   4   93 97                 190
2233724 2233724 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose: Melrose Middle   Regular School No Middle 06 08 2018   grade_8 220 14 6 0   12     0   13   139 126                       265.0 220 14 6 0   12     0   13   139 126                 265
2229097 2229097 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon: Avon Middle High School   Regular School No High 07 12 2018   grade_8 38 13 3 0   3     0   2   36 23                       59.0 38 13 3 0   3     0   2   36 23                 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]);