enrollments

Data source: Big Local News · About: Big Local

499 rows where grade = "grade_8", state = "MA" and year = 2021 sorted by hispanic

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 499 ✖

grade ✖

  • grade_8 · 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
1674758 1674758 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1674916 1674916 MA Essex   school 2505970 128   Haverhill 250597001698 1280033 Haverhill - Greenleaf Academy   Regular School No High 06 12 2021   grade_8 * * * *   *     *   *   4 1 *                     5.0                         4 1                 5
1675667 1675667 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Lowell - Dr. Janice Adie Day School   Special Education School No Other PK 12 2021   grade_8 * * * *   *     *   *   3 2 *                     5.0                         3 2                 5
1675706 1675706 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg - Advanced Community Experience Program   Special Education School No Ungraded UG UG 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1678259 1678259 MA Hampden   school 2511130 281   Springfield 251113002916 2810318 Springfield - Emergence Academy   Regular School No Middle 06 08 2021   grade_8 * * * *   *     *   *   4 * *                     5.0                         4                   5
1680452 1680452 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Bridgewater-Raynham - Therapeutic Day School   Special Education School No High 07 12 2021   grade_8 * * * *   *     *   *   1 * *                     1.0                         1                   1
1673918 1673918 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg - Clarksburg Elementary   Regular School No Elementary KG 08 2021   grade_8 20 0 0 0   0     0   2   12 10 *                     22.0 20 0 0 0   0     0   2   12 10                 22
1673943 1673943 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset - Cohasset Middle School   Regular School No Middle 06 08 2021   grade_8 100 4 0 0   1     0   3   64 44 *                     108.0 100 4 0 0   1     0   3   64 44                 108
1674532 1674532 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Florida - Abbott Memorial   Regular School No Elementary PK 08 2021   grade_8 13 0 0 0   0     0   0   8 5 *                     13.0 13 0 0 0   0     0   0   8 5                 13
1679957 1679957 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District) - Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 35 2 0 0   15     0   0   22 30 *                     52.0 35 2 0 0   15     0   0   22 30                 52
1680114 1680114 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District) - River Valley Charter School   Regular School Yes Elementary KG 08 2021   grade_8 27 0 0 0   1     0   3   10 21 *                     31.0 27 0 0 0   1     0   3   10 21                 31
1680778 1680778 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional - Manchester Essex Regional Middle School   Regular School No Middle 06 08 2021   grade_8 124 0 0 0   2     0   2   61 67 *                     128.0 124 0 0 0   2     0   2   61 67                 128
1680966 1680966 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex - Hawthorne Brook   Regular School No Middle 05 08 2021   grade_8 124 2 0 0   5     0   3   74 60 *                     134.0 124 2 0 0   5     0   3   74 60                 134
1681249 1681249 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett - Thomas Prince   Regular School No Elementary KG 08 2021   grade_8 40 0 0 0   3     0   1   25 19 *                     44.0 40 0 0 0   3     0   1   25 19                 44
1674891 1674891 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Hatfield - Smith Academy   Regular School No High 07 12 2021   grade_8 33 0 1 0   0     0   1   20 15 *                     35.0 33 0 1 0   0     0   1   20 15                 35
1676348 1676348 MA Hampden   school 2508040 191   Monson 250804001269 1910505 Monson - Monson High School   Regular School No High 07 12 2021   grade_8 53 0 1 0   3     0   1   30 28 *                     58.0 53 0 1 0   3     0   1   30 28                 58
1679740 1679740 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District) - Four Rivers Charter Public School   Regular School Yes High 07 12 2021   grade_8 33 0 1 0   0     0   3   14 23 *                     37.0 33 0 1 0   0     0   3   14 23                 37
1680881 1680881 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail - Mohawk Trail Regional School   Regular School No High 07 12 2021   grade_8 65 0 1 0   0     0   0   31 35 *                     66.0 65 0 1 0   0     0   0   31 35                 66
1681035 1681035 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley - Pioneer Valley Regional   Regular School No High 07 12 2021   grade_8 59 0 1 0   0     0   3   30 33 *                     63.0 59 0 1 0   0     0   3   30 33                 63
1681204 1681204 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 Up-Island Regional - West Tisbury Elementary   Regular School No Elementary PK 08 2021   grade_8 35 0 1 0   0     0   1   21 16 *                     37.0 35 0 1 0   0     0   1   21 16                 37
1681240 1681240 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett - Paxton Center   Regular School No Elementary KG 08 2021   grade_8 56 3 1 0   5     0   1   36 30 *                     66.0 56 3 1 0   5     0   1   36 30                 66
1672811 1672811 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_8 9 5 10 0   2     0   2   14 14 *                     28.0 9 5 10 0   2     0   2   14 14                 28
1673019 1673019 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston - William McKinley   Regular School No Other KG 12 2021   grade_8 3 12 10 0   1     0   1   22 5 *                     27.0 3 12 10 0   1     0   1   22 5                 27
1673302 1673302 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_8 132 3 10 3   2     0   7   88 69 *                     157.0 132 3 10 3   2     0   7   88 69                 157
1673354 1673354 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_8 168 9 10 0   54     0   1   115 127 *                     242.0 168 9 10 0   54     0   1   115 127                 242
1673526 1673526 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_8 33 2 10 0   6     0   6   23 34 *                     57.0 33 2 10 0   6     0   6   23 34                 57
1674665 1674665 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin - Annie Sullivan Middle School   Regular School No Middle 06 08 2021   grade_8 108 2 10 1   4     0   0   70 55 *                     125.0 108 2 10 1   4     0   0   70 55                 125
1674671 1674671 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin - Horace Mann   Regular School No Middle 06 08 2021   grade_8 138 2 10 0   14     0   2   99 67 *                     166.0 138 2 10 0   14     0   2   99 67                 166
1674991 1674991 MA Plymouth   school 2506090 131   Hingham 250609000875 1310410 Hingham - Hingham Middle School   Regular School No Middle 06 08 2021   grade_8 249 6 10 1   13     0   12   143 148 *                     291.0 249 6 10 1   13     0   12   143 148                 291
1676122 1676122 MA Middlesex   school 2507560 176   Medford 250756001638 1760315 Medford - Madeleine Dugger Andrews   Regular School No Middle 06 08 2021   grade_8 97 9 10 1   11     0   11   80 59 *                     139.0 97 9 10 1   11     0   11   80 59                 139
1676721 1676721 MA Middlesex   school 2508610 207   Newton 250861001042 2070320 Newton - Oak Hill Middle   Regular School No Middle 06 08 2021   grade_8 107 7 10 0   55     0   13   108 84 *                     192.0 107 7 10 0   55     0   13   108 84                 192
1677818 1677818 MA Norfolk   school 2510620 266   Sharon 251062002560 2660305 Sharon - Sharon Middle   Regular School No Middle 06 08 2021   grade_8 165 10 10 0   89     0   14   133 155 *                     288.0 165 10 10 0   89     0   14   133 155                 288
1679961 1679961 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District) - Boston Collegiate Charter School   Regular School Yes High 05 12 2021   grade_8 47 34 10 0   0     0   4   47 48 *                     95.0 47 34 10 0   0     0   4   47 48                 95
1680572 1680572 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg - Dudley Middle School   Regular School No Middle 05 08 2021   grade_8 112 2 10 1   1     0   1   65 61 *                     127.0 112 2 10 1   1     0   1   65 61                 127
1680617 1680617 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier - Frontier Regional   Regular School No High 07 12 2021   grade_8 107 3 10 0   2     0   4   70 56 *                     126.0 107 3 10 0   2     0   4   70 56                 126
1680896 1680896 MA Worcester   school 2508280 720   Narragansett 250828001285 7200505 Narragansett - Narragansett Regional High   Regular School No High 08 12 2021   grade_8 101 1 10 0   0     1   4   61 56 *                     117.0 101 1 10 0   0     1   4   61 56                 117
1676216 1676216 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Methuen - Tenney Grammar School   Regular School No Elementary PK 08 2021   grade_8 54 7 103 0   6     0   7   102 75 *                     177.0 54 7 103 0   6     0   7   102 75                 177
1680126 1680126 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District) - Roxbury Preparatory Charter School   Regular School Yes High 05 12 2021   grade_8 1 143 107 0   1     0   2   129 125 *                     254.0 1 143 107 0   1     0   2   129 125                 254
1675248 1675248 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence - Guilmette Middle School   Regular School No Middle 05 08 2021   grade_8 2 2 108 0   0     0   0   57 55 *                     112.0 2 2 108 0   0     0   0   57 55                 112
1675265 1675265 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence - UP Academy Oliver Middle School   Regular School No Middle 06 08 2021   grade_8 2 1 109 0   0     0   0   59 53 *                     112.0 2 1 109 0   0     0   0   59 53                 112
1672077 1672077 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_8 121 5 11 0   3     1   6   70 77 *                     147.0 121 5 11 0   3     1   6   70 77                 147
1673005 1673005 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_8 12 5 11 0   1     0   4   13 20 *                     33.0 12 5 11 0   1     0   4   13 20                 33
1673507 1673507 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_8 50 3 11 0   16     0   6   47 39 *                     86.0 50 3 11 0   16     0   6   47 39                 86
1673795 1673795 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford - McCarthy Middle School   Regular School No Middle 05 08 2021   grade_8 127 7 11 0   22     0   10   104 73 *                     177.0 127 7 11 0   22     0   10   104 73                 177
1674442 1674442 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River - Resiliency Preparatory Academy   Alternative School No High 07 12 2021   grade_8 6 6 11 0   0     0   2   19 6 *                     25.0 6 6 11 0   0     0   2   19 6                 25
1676333 1676333 MA Norfolk   school 2507980 189   Milton 250798001257 1890410 Milton - Charles S Pierce Middle   Regular School No Middle 06 08 2021   grade_8 220 43 11 0   19     1   12   149 157 *                     306.0 220 43 11 0   19     1   12   149 157                 306
1676404 1676404 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick - J F Kennedy Middle School   Regular School No Middle 05 08 2021   grade_8 123 4 11 0   15     0   14   96 71 *                     167.0 123 4 11 0   15     0   14   96 71                 167
1677986 1677986 MA Worcester   school 2510980 276   Southborough 251098001221 2760305 Southborough - P Brent Trottier   Regular School No Middle 06 08 2021   grade_8 94 1 11 0   17     0   7   68 62 *                     130.0 94 1 11 0   17     0   7   68 62                 130
1678277 1678277 MA Hampden   school 2511130 281   Springfield 251113002740 2810345 Springfield - Springfield Public Day Middle School   Regular School No Middle 06 08 2021   grade_8 1 7 11 0   0     0   2   17 4 *                     21.0 1 7 11 0   0     0   2   17 4                 21
1678700 1678700 MA Norfolk   school 2511970 307   Walpole 251197001959 3070305 Walpole - Bird Middle   Regular School No Middle 06 08 2021   grade_8 100 9 11 0   5     0   3   63 65 *                     128.0 100 9 11 0   5     0   3   63 65                 128
1678790 1678790 MA Plymouth   school 2512060 310   Wareham 251206001991 3100505 Wareham - Wareham Senior High   Regular School No High 08 12 2021   grade_8 123 10 11 2   1     0   17   89 75 *                     164.0 123 10 11 2   1     0   17   89 75                 164
1678843 1678843 MA Middlesex   school 2512210 315   Wayland 251221002502 3150305 Wayland - Wayland Middle School   Regular School No Middle 06 08 2021   grade_8 159 14 11 0   44     0   12   111 129 *                     240.0 159 14 11 0   44     0   12   111 129                 240
1680387 1680387 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills - W.E.B. Du Bois Regional Middle School   Regular School No Middle 05 08 2021   grade_8 79 3 11 0   2     0   5   60 40 *                     100.0 79 3 11 0   2     0   5   60 40                 100
1680584 1680584 MA Barnstable   school 2504560 660   Nauset 250456000609 6600305 Nauset - Nauset Regional Middle   Regular School No Middle 06 08 2021   grade_8 180 9 11 1   3     0   3   99 108 *                     207.0 180 9 11 1   3     0   3   99 108                 207
1681068 1681068 MA Worcester   school 2500001 753   Quabbin 250000102003 7530405 Quabbin - Quabbin Regional Middle School   Regular School No Middle 06 08 2021   grade_8 150 2 11 0   3     0   2   79 89 *                     168.0 150 2 11 0   3     0   2   79 89                 168
1673824 1673824 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea - Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2021   grade_8 8 7 110 0   0     0   2   55 72 *                     127.0 8 7 110 0   0     0   2   55 72                 127
1674618 1674618 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham - Fuller Middle   Regular School No Middle 06 08 2021   grade_8 57 19 110 0   1     0   4   116 75 *                     191.0 57 19 110 0   1     0   4   116 75                 191
1673898 1673898 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee - Bellamy Middle   Regular School No Middle 06 08 2021   grade_8 134 8 111 1   3     0   14   139 132 *                     271.0 134 8 111 1   3     0   14   139 132                 271
1678272 1678272 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 Springfield - John F Kennedy Middle   Regular School No Middle 06 08 2021   grade_8 14 23 111 0   2     0   4   81 73 *                     154.0 14 23 111 0   2     0   4   81 73                 154
1676271 1676271 MA Worcester   school 2507860 185   Milford 250786001240 1850305 Milford - Stacy Middle   Regular School No Middle 06 08 2021   grade_8 202 6 113 13   5     0   16   185 170 *                     355.0 202 6 113 13   5     0   16   185 170                 355
1675390 1675390 MA Worcester   school 2506780 153   Leominster 250678002045 1530320 Leominster - Sky View Middle School   Regular School No Middle 06 08 2021   grade_8 125 27 115 0   8     0   13   143 145 *                     288.0 125 27 115 0   8     0   13   143 145                 288
1673901 1673901 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee - Dupont Middle   Regular School No Middle 06 08 2021   grade_8 119 11 117 0   10     0   9   149 117 *                     266.0 119 11 117 0   10     0   9   149 117                 266
1677559 1677559 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere - Garfield Middle School   Regular School No Middle 06 08 2021   grade_8 68 9 118 0   8     0   3   99 107 *                     206.0 68 9 118 0   8     0   3   99 107                 206
1675299 1675299 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence - Frost Middle School   Regular School No Middle 05 08 2021   grade_8 13 2 119 0   8     0   3   77 68 *                     145.0 13 2 119 0   8     0   3   77 68                 145
1672141 1672141 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_8 133 2 12 1   17     1   4   83 87 *                     170.0 133 2 12 1   17     1   4   83 87                 170
1672147 1672147 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_8 62 3 12 1   50     0   3   73 58 *                     131.0 62 3 12 1   50     0   3   73 58                 131
1672335 1672335 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_8 141 10 12 1   41     0   1   120 86 *                     206.0 141 10 12 1   41     0   1   120 86                 206
1672528 1672528 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_8 3 14 12 1   0     0   0   15 15 *                     30.0 3 14 12 1   0     0   0   15 15                 30
1673104 1673104 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_8 3 2 12 0   0     0   1   10 8 *                     18.0 3 2 12 0   0     0   1   10 8                 18
1673704 1673704 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge - Putnam Avenue Upper School   Regular School No Middle 06 08 2021   grade_8 28 34 12 0   12     1   8   38 56 *                     95.0 28 34 12 0   12     1   8   38 56                 95
1673971 1673971 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord - Concord Middle   Regular School No Middle 06 08 2021   grade_8 177 11 12 0   25     0   11   123 113 *                     236.0 177 11 12 0   25     0   11   123 113                 236
1675193 1675193 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich - Ipswich Middle School   Regular School No Middle 06 08 2021   grade_8 117 3 12 0   3     0   1   64 72 *                     136.0 117 3 12 0   3     0   1   64 72                 136
1675307 1675307 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence - School for Exceptional Studies   Regular School No Other KG 12 2021   grade_8 2 0 12 0   0     0   1   13 2 *                     15.0 2 0 12 0   0     0   1   13 2                 15
1675452 1675452 MA Middlesex   school 2506840 155   Lexington 250684002552 1550310 Lexington - Wm Diamond Middle   Regular School No Middle 06 08 2021   grade_8 136 8 12 0   139     0   29   158 166 *                     324.0 136 8 12 0   139     0   29   158 166                 324
1675911 1675911 MA Middlesex   school 2507170 165   Malden 250717001361 1650047 Malden - Linden   Regular School No Elementary KG 08 2021   grade_8 35 20 12 0   19     0   4   44 46 *                     90.0 35 20 12 0   19     0   4   44 46                 90
1676087 1676087 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Medfield - Thomas Blake Middle   Regular School No Middle 06 08 2021   grade_8 152 1 12 0   8     0   10   93 90 *                     183.0 152 1 12 0   8     0   10   93 90                 183
1676286 1676286 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury - Millbury Junior/Senior High   Regular School No High 07 12 2021   grade_8 114 5 12 0   8     0   12   85 65 *                     151.0 114 5 12 0   8     0   12   85 65                 151
1676408 1676408 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick - Wilson Middle   Regular School No Middle 05 08 2021   grade_8 181 10 12 0   15     0   16   123 111 *                     234.0 181 10 12 0   15     0   16   123 111                 234
1677080 1677080 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer - Palmer High   Regular School No High 06 12 2021   grade_8 94 4 12 0   3     0   8   53 68 *                     121.0 94 4 12 0   3     0   8   53 68                 121
1678908 1678908 MA Norfolk   school 2512270 317   Wellesley 251227002029 3170305 Wellesley - Wellesley Middle   Regular School No Middle 06 08 2021   grade_8 252 20 12 0   64     0   24   158 213 *                     372.0 252 20 12 0   64     0   24   158 213                 372
1678952 1678952 MA Worcester   school 2512390 322   West Boylston 251239002035 3220505 West Boylston - West Boylston Junior/Senior High   Regular School No High 06 12 2021   grade_8 53 1 12 0   1     0   5   30 42 *                     72.0 53 1 12 0   1     0   5   30 42                 72
1679885 1679885 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District) - Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 17 12 0   0     0   1   16 14 *                     30.0 0 17 12 0   0     0   1   16 14                 30
1677530 1677530 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere - Rumney Marsh Academy   Regular School No Middle 06 08 2021   grade_8 58 7 121 1   11     0   10   96 112 *                     208.0 58 7 121 1   11     0   10   96 112                 208
1675476 1675476 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln - Hanscom Middle   Regular School No Middle 04 08 2021   grade_8 17 6 13 0   1     0   5   19 23 *                     42.0 17 6 13 0   1     0   5   19 23                 42
1675955 1675955 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead - Marblehead Veterans Middle School   Regular School No Middle 07 08 2021   grade_8 223 7 13 0   2     0   4   134 115 *                     249.0 223 7 13 0   2     0   4   134 115                 249
1676142 1676142 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway - Medway Middle   Regular School No Middle 05 08 2021   grade_8 146 2 13 0   4     1   6   91 81 *                     172.0 146 2 13 0   4     1   6   91 81                 172
1676181 1676181 MA Middlesex   school 2507620 178   Melrose 250762002557 1780305 Melrose - Melrose Middle   Regular School No Middle 06 08 2021   grade_8 208 22 13 0   15     0   14   147 125 *                     272.0 208 22 13 0   15     0   14   147 125                 272
1679252 1679252 MA Middlesex   school 2513050 342   Wilmington 251305001578 3420330 Wilmington - Wilmington Middle School   Regular School No Middle 06 08 2021   grade_8 214 4 13 0   13     0   5   115 134 *                     249.0 214 4 13 0   13     0   5   115 134                 249
1679309 1679309 MA Middlesex   school 2513110 344   Winchester 251311002167 3440305 Winchester - McCall Middle   Regular School No Middle 06 08 2021   grade_8 236 5 13 1   65     0   28   168 180 *                     348.0 236 5 13 1   65     0   28   168 180                 348
1681013 1681013 MA Essex   school 2509450 745   Pentucket 250945001512 7450405 Pentucket - Pentucket Regional Middle   Regular School No Middle 07 08 2021   grade_8 184 1 13 0   1     0   4   102 101 *                     203.0 184 1 13 0   1     0   4   102 101                 203
1681143 1681143 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield - Knox Trail Middle School   Regular School No Middle 05 08 2021   grade_8 92 4 13 1   3     0   7   61 59 *                     120.0 92 4 13 1   3     0   7   61 59                 120
1673832 1673832 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea - Joseph A. Browne School   Regular School No Middle 05 08 2021   grade_8 4 1 132 0   0     0   0   71 66 *                     137.0 4 1 132 0   0     0   0   71 66                 137
1678757 1678757 MA Middlesex   school 2512000 308   Waltham 251200001977 3080415 Waltham - John W. McDevitt Middle School   Regular School No Middle 06 08 2021   grade_8 68 20 136 0   13     0   3   118 122 *                     240.0 68 20 136 0   13     0   3   118 122                 240
1673256 1673256 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_8 7 1 137 0   1     0   1   74 73 *                     147.0 7 1 137 0   1     0   1   74 73                 147
1676579 1676579 MA Bristol   school 2508430 201   New Bedford 250843001334 2010405 New Bedford - Keith Middle School   Regular School No Middle 06 08 2021   grade_8 124 44 137 0   5     0   26   184 152 *                     336.0 124 44 137 0   5     0   26   184 152                 336
1677562 1677562 MA Suffolk   school 2510050 248   Revere 251005002113 2480305 Revere - Susan B. Anthony Middle School   Regular School No Middle 06 08 2021   grade_8 57 5 137 0   4     0   2   88 117 *                     205.0 57 5 137 0   4     0   2   88 117                 205
1676585 1676585 MA Bristol   school 2508430 201   New Bedford 250843001339 2010415 New Bedford - Roosevelt Middle School   Regular School No Middle 06 08 2021   grade_8 118 47 138 0   1     1   17   167 155 *                     322.0 118 47 138 0   1     1   17   167 155                 322
1672144 1672144 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_8 119 6 14 0   29     0   7   97 78 *                     175.0 119 6 14 0   29     0   7   97 78                 175
1673606 1673606 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington - Marshall Simonds Middle   Regular School No Middle 06 08 2021   grade_8 158 17 14 0   53     0   14   121 135 *                     256.0 158 17 14 0   53     0   14   121 135                 256
1675006 1675006 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook - Holbrook Middle High School   Regular School No High 06 12 2021   grade_8 46 18 14 0   7     0   11   39 56 *                     96.0 46 18 14 0   7     0   11   39 56                 96

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