enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_7", state = "MA" and year = 2019 sorted by white

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 499 ✖

grade ✖

  • grade_7 · 499 ✖
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
2040387 2040387 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2019   grade_7 * * * *   *     *   *   1 2                       3.0                         1 2                 3
2041274 2041274 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No Secondary 07 11 2019   grade_7 * * * *   *     *   *   1 *                       1.0                         1                   1
2041702 2041702 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2019   grade_7 * * * *   *     *   *   2 2                       4.0                         2 2                 4
2042771 2042771 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2019   grade_7 * * * *   *     *   *   5 *                       5.0                         5                   5
2043454 2043454 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 02 08 2019   grade_7 * * * *   *     *   *   3 *                       4.0                         3                   4
2043509 2043509 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 11 2019   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2048250 2048250 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 06 12 2019   grade_7 * * * *   *     *   *   1 1                       2.0                         1 1                 2
2040429 2040429 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Dearborn   Regular School No High 06 12 2019   grade_7 0 36 19 0   0     2   1   26 32                       58.0 0 36 19 0   0     2   1   26 32                 58
2040596 2040596 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Joseph J Hurley   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   9 7                       16.0 0 0 16 0   0     0   0   9 7                 16
2040783 2040783 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2019   grade_7 0 9 14 0   0     0   0   16 7                       23.0 0 9 14 0   0     0   0   16 7                 23
2040846 2040846 MA Suffolk   school 2502790 35   Boston 250279000343 350370 William Monroe Trotter   Regular School No Elementary PK 08 2019   grade_7 0 12 11 0   0     0   4   13 14                       27.0 0 12 11 0   0     0   4   13 14                 27
2040873 2040873 MA Suffolk   school 2502790 35   Boston 250279002669 350376 King K-8   Regular School No Elementary PK 08 2019   grade_7 0 22 16 0   0     0   3   17 24                       41.0 0 22 16 0   0     0   3   17 24                 41
2040880 2040880 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Middle 02 08 2019   grade_7 0 21 13 0   0     0   5   22 17                       39.0 0 21 13 0   0     0   5   22 17                 39
2040900 2040900 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Young Achievers   Alternative School No Elementary PK 08 2019   grade_7 0 24 18 0   0     0   1   24 19                       43.0 0 24 18 0   0     0   1   24 19                 43
2040910 2040910 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2019   grade_7 0 6 10 0   0     0   2   11 7                       18.0 0 6 10 0   0     0   2   11 7                 18
2041093 2041093 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Rafael Hernandez   Regular School No Elementary PK 08 2019   grade_7 0 0 16 0   0     0   0   4 12                       16.0 0 0 16 0   0     0   0   4 12                 16
2043128 2043128 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2019   grade_7 0 1 99 0   1     0   0   59 42                       101.0 0 1 99 0   1     0   0   59 42                 101
2045781 2045781 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 07 08 2019   grade_7 0 2 4 0   0     0   0   6 *                       6.0 0 2 4 0   0     0   0   6                   6
2047577 2047577 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School   Regular School Yes Elementary PK 07 2019   grade_7 0 16 7 0   0     0   1   12 12                       24.0 0 16 7 0   0     0   1   12 12                 24
2047604 2047604 MA Essex   school 2500538 426   Community Day Charter Public School - Gateway (District) 250053802717 4260205 Community Day Charter Public School - Gateway   Regular School Yes Elementary PK 07 2019   grade_7 0 0 32 0   1     0   0   14 19                       33.0 0 0 32 0   1     0   0   14 19                 33
2047679 2047679 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2019   grade_7 0 15 3 0   0     0   0   8 10                       18.0 0 15 3 0   0     0   0   8 10                 18
2047693 2047693 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2019   grade_7 0 15 11 0   0     0   0   8 18                       26.0 0 15 11 0   0     0   0   8 18                 26
2047835 2047835 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2019   grade_7 0 44 14 0   0     0   1   26 33                       59.0 0 44 14 0   0     0   1   26 33                 59
2049293 2049293 MA Suffolk   school 2500549 3505   UP Academy Charter School of Dorchester (District) 250054902783 35050405 UP Academy Charter School of Dorchester   Regular School Yes Elementary PK 08 2019   grade_7 0 37 36 0   2     1   1   36 41                       77.0 0 37 36 0   2     1   1   36 41                 77
2040348 2040348 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston Teachers Union School   Regular School No Elementary PK 08 2019   grade_7 1 8 8 0   0     0   1   8 10                       18.0 1 8 8 0   0     0   1   8 10                 18
2040534 2040534 MA Suffolk   school 2502790 35   Boston 250279000259 350153 James W Hennigan   Regular School No Elementary KG 08 2019   grade_7 1 13 36 0   1     0   1   24 28                       52.0 1 13 36 0   1     0   1   24 28                 52
2040654 2040654 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Maurice J Tobin   Regular School No Elementary PK 08 2019   grade_7 1 9 23 0   3     0   0   18 18                       36.0 1 9 23 0   3     0   0   18 18                 36
2040941 2040941 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2019   grade_7 1 41 54 0   0     0   2   42 56                       98.0 1 41 54 0   0     0   2   42 56                 98
2040992 2040992 MA Suffolk   school 2502790 35   Boston 250279000704 350542 New Mission High School   Alternative School No High 07 12 2019   grade_7 1 23 20 0   0     0   0   18 26                       44.0 1 23 20 0   0     0   0   18 26                 44
2042137 2042137 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2019   grade_7 1 1 4 0   0     0   0   4 2                       6.0 1 1 4 0   0     0   0   4 2                 6
2042905 2042905 MA Hampden   school 2506270 137   Holyoke 250627000904 1370040 Kelly Elementary   Regular School No Elementary PK 08 2019   grade_7 1 1 49 0   0     0   0   30 21                       51.0 1 1 49 0   0     0   0   30 21                 51
2043122 2043122 MA Essex   school 2506660 149   Lawrence 250666000955 1490080 Emily G Wetherbee   Regular School No Elementary KG 08 2019   grade_7 1 1 72 0   2     0   0   36 40                       76.0 1 1 72 0   2     0   0   36 40                 76
2044416 2044416 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2019   grade_7 1 0 4 0   0     0   1   3 3                       6.0 1 0 4 0   0     0   1   3 3                 6
2046093 2046093 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 South End Middle School   Regular School No Middle 06 08 2019   grade_7 1 8 75 0   0     0   1   41 44                       85.0 1 8 75 0   0     0   1   41 44                 85
2047563 2047563 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public School   Regular School Yes High 06 12 2019   grade_7 1 51 30 0   0     0   5   43 44                       87.0 1 51 30 0   0     0   5   43 44                 87
2047582 2047582 MA Suffolk   school 2500077 419   Helen Y. Davis Leadership Academy Charter Public (District) 250007702091 4190305 Helen Y. Davis Leadership Academy Charter Public School   Regular School Yes Middle 06 08 2019   grade_7 1 51 11 0   0     0   0   35 28                       63.0 1 51 11 0   0     0   0   35 28                 63
2047648 2047648 MA Essex   school 2500535 431   Community Day Charter Public School - R. Kingman Webster (District) 250053502719 4310205 Community Day Charter Public School - R. Kingman Webster   Regular School Yes Elementary PK 07 2019   grade_7 1 0 31 0   0     0   0   18 14                       32.0 1 0 31 0   0     0   0   18 14                 32
2047803 2047803 MA Essex   school 2500032 454   Lawrence Family Development Charter (District) 250003200553 4540205 Lawrence Family Development Charter School   Regular School Yes Elementary PK 08 2019   grade_7 1 2 47 0   0     0   0   22 28                       50.0 1 2 47 0   0     0   0   22 28                 50
2047865 2047865 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School   Regular School Yes Other PK 12 2019   grade_7 1 29 61 0   0     0   1   44 48                       92.0 1 29 61 0   0     0   1   44 48                 92
2047932 2047932 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter School   Regular School Yes High 05 12 2019   grade_7 1 134 95 1   4     1   2   134 104                       238.0 1 134 95 1   4     1   2   134 104                 238
2040695 2040695 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2019   grade_7 10 7 4 0   0     0   1   15 7                       22.0 10 7 4 0   0     0   1   15 7                 22
2040711 2040711 MA Suffolk   school 2502790 35   Boston 250279000339 350258 William H Ohrenberger   Regular School No Middle 03 08 2019   grade_7 10 24 39 0   0     0   5   39 39                       78.0 10 24 39 0   0     0   5   39 39                 78
2042108 2042108 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2019   grade_7 10 5 35 1   4     0   2   31 26                       57.0 10 5 35 1   4     0   2   31 26                 57
2043464 2043464 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Bartlett Community Partnership   Regular School No Elementary PK 08 2019   grade_7 10 5 14 0   22     0   2   23 30                       53.0 10 5 14 0   22     0   2   23 30                 53
2045759 2045759 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 E Somerville Community   Regular School No Elementary KG 08 2019   grade_7 10 3 62 0   5     0   0   43 37                       80.0 10 3 62 0   5     0   0   43 37                 80
2044587 2044587 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2019   grade_7 100 4 4 0   1     0   5   61 53                       114.0 100 4 4 0   1     0   5   61 53                 114
2040057 2040057 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2019   grade_7 101 6 24 0   7     0   11   79 70                       149.0 101 6 24 0   7     0   11   79 70                 149
2046574 2046574 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 John F Kennedy Middle   Regular School No Middle 06 08 2019   grade_7 101 19 47 0   6     0   2   87 88                       175.0 101 19 47 0   6     0   2   87 88                 175
2048945 2048945 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2019   grade_7 101 0 7 0   1     0   4   57 56                       113.0 101 0 7 0   1     0   4   57 56                 113
2047634 2047634 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes High 06 12 2019   grade_7 102 0 9 0   21     0   12   78 66                       144.0 102 0 9 0   21     0   12   78 66                 144
2046276 2046276 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2019   grade_7 103 2 2 0   3     0   3   56 57                       113.0 103 2 2 0   3     0   3   56 57                 113
2045809 2045809 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 P Brent Trottier   Regular School No Middle 06 08 2019   grade_7 104 0 10 0   30     0   8   84 68                       152.0 104 0 10 0   30     0   8   84 68                 152
2043324 2043324 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2019   grade_7 105 5 1 0   6     0   5   51 71                       122.0 105 5 1 0   6     0   5   51 71                 122
2042263 2042263 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Morton Middle   Regular School No Middle 06 08 2019   grade_7 106 14 49 0   10     0   16   111 84                       195.0 106 14 49 0   10     0   16   111 84                 195
2043176 2043176 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2019   grade_7 106 6 14 0   7     0   4   81 56                       137.0 106 6 14 0   7     0   4   81 56                 137
2044108 2044108 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2019   grade_7 106 4 13 0   6     0   7   69 67                       136.0 106 4 13 0   6     0   7   69 67                 136
2047464 2047464 MA Worcester   school 2513230 348   Worcester 251323002223 3480423 Sullivan Middle   Regular School No Middle 06 08 2019   grade_7 106 67 191 0   44     0   16   207 217                       424.0 106 67 191 0   44     0   16   207 217                 424
2048504 2048504 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2019   grade_7 106 1 7 0   8     1   2   43 82                       125.0 106 1 7 0   8     1   2   43 82                 125
2048768 2048768 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2019   grade_7 106 3 5 0   4     0   6   68 56                       124.0 106 3 5 0   4     0   6   68 56                 124
2046889 2046889 MA Middlesex   school 2512750 330   Weston 251275000793 3300305 Weston Middle   Regular School No Middle 06 08 2019   grade_7 107 8 8 0   25     0   12   86 74                       160.0 107 8 8 0   25     0   12   86 74                 160
2048575 2048575 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2019   grade_7 107 0 3 0   1     0   2   59 54                       113.0 107 0 3 0   1     0   2   59 54                 113
2048700 2048700 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2019   grade_7 108 0 4 0   0     0   3   63 52                       115.0 108 0 4 0   0     0   3   63 52                 115
2049083 2049083 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2019   grade_7 108 3 3 0   3     0   3   49 71                       120.0 108 3 3 0   3     0   3   49 71                 120
2042501 2042501 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Annie Sullivan Middle School   Regular School No Middle 06 08 2019   grade_7 109 3 5 0   6     1   3   62 65                       127.0 109 3 5 0   6     1   3   62 65                 127
2042793 2042793 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Consentino Middle School   Regular School No Middle 04 08 2019   grade_7 109 10 95 1   3     0   1   124 95                       219.0 109 10 95 1   3     0   1   124 95                 219
2044408 2044408 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 Roosevelt Middle School   Regular School No Middle 06 08 2019   grade_7 109 49 104 1   0     1   9   139 134                       273.0 109 49 104 1   0     1   9   139 134                 273
2047187 2047187 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 John F Kennedy Middle School   Regular School No Middle 06 08 2019   grade_7 109 9 16 1   9     0   6   71 79                       150.0 109 9 16 1   9     0   6   71 79                 150
2040863 2040863 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2019   grade_7 11 12 38 0   4     0   1   39 27                       66.0 11 12 38 0   4     0   1   39 27                 66
2041665 2041665 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2019   grade_7 11 3 124 1   1     0   0   73 67                       140.0 11 3 124 1   1     0   0   73 67                 140
2043137 2043137 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2019   grade_7 11 4 104 0   6     0   0   62 63                       125.0 11 4 104 0   6     0   0   62 63                 125
2046114 2046114 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Rise Academy at Van Sickle   Regular School No Middle 06 08 2019   grade_7 11 11 69 0   0     0   1   48 44                       92.0 11 11 69 0   0     0   1   48 44                 92
2046607 2046607 MA Plymouth   school 2512060 310   Wareham 251206002603 3100305 Wareham Middle   Regular School No Middle 05 07 2019   grade_7 110 13 22 1   2     1   18   90 77                       167.0 110 13 22 1   2     1   18   90 77                 167
2046858 2046858 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Blanchard Middle   Regular School No Middle 06 08 2019   grade_7 111 0 7 0   62     0   4   94 90                       184.0 111 0 7 0   62     0   4   94 90                 184
2048224 2048224 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2019   grade_7 111 2 6 0   0     0   6   71 53                       125.0 111 2 6 0   0     0   6   71 53                 125
2049369 2049369 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2019   grade_7 111 16 27 0   5     0   22   89 92                       181.0 111 16 27 0   5     0   22   89 92                 181
2044544 2044544 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Oak Hill Middle   Regular School No Middle 06 08 2019   grade_7 112 9 15 1   43     1   12   109 84                       193.0 112 9 15 1   43     1   12   109 84                 193
2042454 2042454 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No Middle 06 08 2019   grade_7 113 19 74 0   4     1   5   114 102                       216.0 113 19 74 0   4     1   5   114 102                 216
2043815 2043815 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2019   grade_7 113 8 162 0   4     0   12   142 157                       299.0 113 8 162 0   4     0   12   142 157                 299
2045247 2045247 MA Norfolk   school 2509870 243   Quincy 250987001564 2430315 Central Middle   Regular School No Middle 06 08 2019   grade_7 113 4 6 0   72     1   6   89 113                       202.0 113 4 6 0   72     1   6   89 113                 202
2045841 2045841 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2019   grade_7 113 3 15 0   4     0   4   77 62                       139.0 113 3 15 0   4     0   4   77 62                 139
2040135 2040135 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 John Glenn Middle   Regular School No Middle 06 08 2019   grade_7 114 13 10 0   27     0   14   98 80                       178.0 114 13 10 0   27     0   14   98 80                 178
2041933 2041933 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2019   grade_7 114 0 3 0   1     0   4   79 43                       122.0 114 0 3 0   1     0   4   79 43                 122
2045072 2045072 MA Berkshire   school 2509630 236   Pittsfield 250963001525 2360305 John T Reid Middle   Regular School No Middle 06 08 2019   grade_7 114 24 20 1   2     0   18   88 91                       179.0 114 24 20 1   2     0   18   88 91                 179
2046525 2046525 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2019   grade_7 114 1 6 0   17     0   5   69 74                       143.0 114 1 6 0   17     0   5   69 74                 143
2048777 2048777 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2019   grade_7 114 3 6 0   3     0   2   75 53                       128.0 114 3 6 0   3     0   2   75 53                 128
2049138 2049138 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 05 08 2019   grade_7 115 2 4 0   2     0   1   66 58                       124.0 115 2 4 0   2     0   1   66 58                 124
2048649 2048649 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2019   grade_7 116 3 1 0   1     0   1   50 72                       122.0 116 3 1 0   1     0   1   50 72                 122
2039833 2039833 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_7 117 2 1 0   0     0   1   64 57                       121.0 117 2 1 0   0     0   1   64 57                 121
2045432 2045432 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 John W Rogers Middle   Regular School No Middle 05 08 2019   grade_7 117 13 26 0   3     0   4   72 91                       163.0 117 13 26 0   3     0   4   72 91                 163
2046639 2046639 MA Middlesex   school 2512180 314   Watertown 251218002501 3140305 Watertown Middle   Regular School No Middle 06 08 2019   grade_7 117 8 30 0   11     0   7   89 84                       173.0 117 8 30 0   11     0   7   89 84                 173
2048287 2048287 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2019   grade_7 119 0 3 0   2     0   5   66 63                       129.0 119 0 3 0   2     0   5   66 63                 129
2042158 2042158 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2019   grade_7 12 18 80 0   3     0   0   53 60                       113.0 12 18 80 0   3     0   0   53 60                 113
2042885 2042885 MA Hampden   school 2506270 137   Holyoke 250627000908 1370015 Lt Elmer J McMahon Elementary   Regular School No Elementary PK 08 2019   grade_7 12 0 29 0   0     0   0   22 19                       41.0 12 0 29 0   0     0   0   22 19                 41
2045779 2045779 MA Middlesex   school 2510890 274   Somerville 251089001749 2740120 Winter Hill Community   Regular School No Elementary PK 08 2019   grade_7 12 13 31 0   5     0   1   34 28                       62.0 12 13 31 0   5     0   1   34 28                 62
2048246 2048246 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2019   grade_7 120 9 5 0   6     0   2   70 72                       142.0 120 9 5 0   6     0   2   70 72                 142
2041599 2041599 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2019   grade_7 121 1 3 0   0     0   3   80 48                       128.0 121 1 3 0   0     0   3   80 48                 128
2041629 2041629 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Col Moses Parker School   Regular School No Middle 05 08 2019   grade_7 121 4 16 0   28     0   2   81 90                       171.0 121 4 16 0   28     0   2   81 90                 171
2042451 2042451 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Cameron Middle School   Regular School No Middle 06 08 2019   grade_7 121 13 36 0   7     0   9   101 85                       186.0 121 13 36 0   7     0   9   101 85                 186
2044894 2044894 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2019   grade_7 121 1 14 0   3     1   8   81 67                       148.0 121 1 14 0   3     1   8   81 67                 148
2047136 2047136 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop Middle School   Regular School No Middle 06 08 2019   grade_7 121 1 35 0   3     0   4   93 71                       164.0 121 1 35 0   3     0   4   93 71                 164

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