Data source: Big Local News · About: Big Local

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

View and edit SQL

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 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold - Cuttyhunk Elementary   Regular School No Middle 07 07 2021   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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
1672886 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_8 7 3 2 0   1     0   1   6 8 *                     14.0 7 3 2 0   1     0   1   6 8                 14
1673752 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle - Carlisle School   Regular School No Elementary PK 08 2021   grade_8 49 0 2 0   6     0   8   38 27 *                     65.0 49 0 2 0   6     0   8   38 27                 65
1674162 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater - East Bridgewater JR./SR. High School   Regular School No High 07 12 2021   grade_8 148 14 2 1   0     1   6   102 70 *                     172.0 148 14 2 1   0     1   6   102 70                 172
1674705 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown - Georgetown Middle School   Regular School No Middle 07 08 2021   grade_8 82 0 2 0   2     1   1   41 47 *                     88.0 82 0 2 0   2     1   1   41 47                 88
1676991 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell - Norwell Middle School   Regular School No Middle 06 08 2021   grade_8 169 0 2 0   5     0   4   106 74 *                     180.0 169 0 2 0   5     0   4   106 74                 180
1677347 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown - Provincetown Schools   Regular School No Elementary PK 08 2021   grade_8 3 5 2 0   0     0   0   3 7 *                     10.0 3 5 2 0   0     0   0   3 7                 10
1677581 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond - Richmond Consolidated   Regular School No Elementary PK 08 2021   grade_8 15 1 2 0   0     0   0   9 9 *                     18.0 15 1 2 0   0     0   0   9 9                 18
1677699 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich - Sandwich STEM Academy   Regular School No Middle 07 08 2021   grade_8 208 5 2 1   3     0   3   114 107 *                     222.0 208 5 2 1   3     0   3   114 107                 222
1678007 MA Worcester   school 2511010 277   Southbridge 251101002896 2770525 Southbridge - Southbridge Academy   Alternative School No High 07 12 2021   grade_8 4 0 2 0   0     0   0   4 2 *                     6.0 4 0 2 0   0     0   0   4 2                 6
1679871 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District) - Codman Academy Charter Public School   Regular School Yes Other PK 12 2021   grade_8 0 19 2 0   0     0   0   9 12 *                     21.0 0 19 2 0   0     0   0   9 12                 21
1679974 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public (District) - Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2021   grade_8 26 2 2 0   0     0   2   14 17 *                     32.0 26 2 2 0   0     0   2   14 17                 32
1680034 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District) - Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2021   grade_8 19 2 2 0   0     0   2   16 9 *                     25.0 19 2 2 0   0     0   2   16 9                 25
1680408 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Berlin-Boylston - Tahanto Regional High   Regular School No High 06 12 2021   grade_8 65 4 2 0   3     0   3   32 45 *                     77.0 65 4 2 0   3     0   3   32 45                 77
1673545 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline - Lawrence   Regular School No Elementary KG 08 2021   grade_8 31 4 3 0   18     0   5   36 25 *                     61.0 31 4 3 0   18     0   5   36 25                 61
1674094 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas - Douglas Middle School   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   1     0   2   47 54 *                     101.0 94 1 3 0   1     0   2   47 54                 101
1674296 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett - Devens School   Regular School No Other KG 12 2021   grade_8 1 1 3 0   0     0   1   5 1 *                     6.0 1 1 3 0   0     0   1   5 1                 6
1674432 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River - Stone PK-12 School   Regular School No Other 01 12 2021   grade_8 4 2 3 0   0     0   1   8 2 *                     10.0 4 2 3 0   0     0   1   8 2                 10
1674795 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby - Granby Jr Sr High School   Regular School No High 07 12 2021   grade_8 47 0 3 0   0     0   1   31 20 *                     51.0 47 0 3 0   0     0   1   31 20                 51
1675471 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln - Lincoln School   Regular School No Elementary PK 08 2021   grade_8 27 7 3 0   2     0   6   23 22 *                     45.0 27 7 3 0   2     0   6   23 22                 45
1675515 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Longmeadow - Williams Middle   Regular School No Middle 06 08 2021   grade_8 94 1 3 0   7     0   7   59 53 *                     112.0 94 1 3 0   7     0   7   59 53                 112
1676599 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 New Bedford - Whaling City Junior/Senior High School   Regular School No High 06 12 2021   grade_8 2 1 3 0   0     0   0   4 2 *                     6.0 2 1 3 0   0     0   0   4 2                 6
1677507 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Reading - Arthur W Coolidge Middle   Regular School No Middle 06 08 2021   grade_8 116 2 3 0   1     0   2   69 55 *                     124.0 116 2 3 0   1     0   2   69 55                 124
1677624 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport - Rockport Middle   Regular School No Middle 06 08 2021   grade_8 58 0 3 0   2     0   4   23 44 *                     67.0 58 0 3 0   2     0   4   23 44                 67
1679842 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District) - Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2021   grade_8 73 1 3 1   2     0   2   38 44 *                     82.0 73 1 3 1   2     0   2   38 44                 82
1680084 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District) - Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2021   grade_8 65 2 3 0   2     0   3   36 39 *                     75.0 65 2 3 0   2     0   3   36 39                 75
1680228 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter (District) - Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2021   grade_8 30 8 3 0   7     0   8   33 23 *                     56.0 30 8 3 0   7     0   8   33 23                 56
1680638 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway - Gateway Regional Middle School   Regular School No Middle 06 08 2021   grade_8 53 0 3 1   0     0   1   35 23 *                     58.0 53 0 3 1   0     0   1   35 23                 58
1680982 MA Plymouth   school 2509150 740   Old Rochester 250915001473 7400405 Old Rochester - Old Rochester Regional Jr High   Regular School No Middle 07 08 2021   grade_8 185 6 3 0   4     0   13   114 97 *                     211.0 185 6 3 0   4     0   13   114 97                 211
1672032 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_8 99 0 4 0   1     0   5   59 50 *                     109.0 99 0 4 0   1     0   5   59 50                 109
1673453 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton - Huntington Therapeutic Day School   Alternative School No Other 02 12 2021   grade_8 1 3 4 0   0     0   0   7 1 *                     8.0 1 3 4 0   0     0   0   7 1                 8
1673573 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline - John D Runkle   Regular School No Elementary PK 08 2021   grade_8 44 4 4 0   7     0   8   33 34 *                     67.0 44 4 4 0   7     0   8   33 34                 67
1673710 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge - Vassal Lane Upper School   Regular School No Middle 06 08 2021   grade_8 43 27 4 0   17     0   6   50 46 *                     97.0 43 27 4 0   17     0   6   50 46                 97
1675173 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Hull - Memorial Middle   Regular School No Middle 06 08 2021   grade_8 60 1 4 0   0     0   0   29 35 *                     65.0 60 1 4 0   0     0   0   29 35                 65
1675843 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Lynn - Fecteau-Leary Junior/Senior High School   Regular School No High 06 12 2021   grade_8 3 0 4 1   0     0   2   8 2 *                     10.0 3 0 4 1   0     0   2   8 2                 10
1676924 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield - North Brookfield High   Regular School No High 07 12 2021   grade_8 34 0 4 0   0     0   2   23 17 *                     40.0 34 0 4 0   0     0   2   23 17                 40
1677958 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Somerville - Next Wave Junior High   Alternative School No Middle 06 08 2021   grade_8 2 0 4 0   0     0   1   6 * *                     7.0 2 0 4 0   0     0   1   6                   7
1678460 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton - Sutton Middle School   Regular School No Middle 06 08 2021   grade_8 106 1 4 0   1     0   6   55 63 *                     118.0 106 1 4 0   1     0   6   55 63                 118
1679944 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter (District) - Foxborough Regional Charter School   Regular School Yes Other KG 12 2021   grade_8 34 90 4 0   15     0   8   72 79 *                     151.0 34 90 4 0   15     0   8   72 79                 151
1680043 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District) - Martha's Vineyard Charter School   Regular School Yes Other KG 12 2021   grade_8 13 0 4 0   0     0   3   11 9 *                     20.0 13 0 4 0   0     0   3   11 9                 20
1680303 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Regional - Hoosac Valley High School   Regular School No High 08 12 2021   grade_8 83 6 4 0   0     0   2   48 47 *                     95.0 83 6 4 0   0     0   2   48 47                 95
1680449 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Bridgewater-Raynham - Raynham Middle School   Regular School No Middle 05 08 2021   grade_8 158 14 4 0   4     0   8   122 65 *                     188.0 158 14 4 0   4     0   8   122 65                 188
1680543 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth - Dorothy L Beckwith   Regular School No Middle 05 08 2021   grade_8 124 1 4 0   0     0   7   70 66 *                     136.0 124 1 4 0   0     0   7   70 66                 136
1680551 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn - Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2021   grade_8 120 8 4 0   22     0   8   93 69 *                     162.0 120 8 4 0   22     0   8   93 69                 162
1680611 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville - Freetown-Lakeville Middle School   Regular School No Middle 06 09 2021   grade_8 213 8 4 1   4     0   4   105 129 *                     234.0 213 8 4 1   4     0   4   105 129                 234
1680721 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Hampden-Wilbraham - Green Meadows Elementary   Regular School No Elementary PK 08 2021   grade_8 9 1 4 0   0     0   0   4 10 *                     14.0 9 1 4 0   0     0   0   4 10                 14
1680851 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock - Mt Greylock Regional High   Regular School No High 07 12 2021   grade_8 74 4 4 0   0     0   4   44 42 *                     86.0 74 4 4 0   0     0   4   44 42                 86
1672414 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_8 88 1 5 0   0     0   2   48 48 *                     96.0 88 1 5 0   0     0   2   48 48                 96
1673041 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_8 1 12 5 0   0     0   1   11 8 *                     19.0 1 12 5 0   0     0   1   11 8                 19
1673762 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver - Carver Middle/High School   Regular School No High 06 12 2021   grade_8 118 0 5 1   0     1   0   71 54 *                     125.0 118 0 5 1   0     1   0   71 54                 125
1675324 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee - Lee Middle/High School   Regular School No High 07 12 2021   grade_8 43 0 5 0   3     0   2   19 34 *                     53.0 43 0 5 0   3     0   2   19 34                 53
1676046 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee - Mashpee Middle School   Regular School No Middle 07 08 2021   grade_8 101 6 5 8   5     0   16   69 72 *                     141.0 101 6 5 8   5     0   16   69 72                 141
1676593 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 New Bedford - Trinity Day Academy   Regular School No Other 04 12 2021   grade_8 2 2 5 0   0     0   1   6 4 *                     10.0 2 2 5 0   0     0   1   6 4                 10
1677175 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke - Pembroke Community Middle School   Regular School No Middle 07 08 2021   grade_8 222 0 5 0   2     0   1   126 104 *                     230.0 222 0 5 0   2     0   1   126 104                 230
1677771 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate - Gates Middle School   Regular School No Middle 06 08 2021   grade_8 205 8 5 0   1     0   2   110 111 *                     221.0 205 8 5 0   1     0   2   110 111                 221
1678504 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea - Joseph Case Jr High   Regular School No Middle 06 08 2021   grade_8 178 3 5 0   0     0   3   103 86 *                     189.0 178 3 5 0   0     0   3   103 86                 189
1678966 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater - West Bridgewater Junior/Senior   Regular School No High 07 12 2021   grade_8 96 5 5 0   1     0   5   52 60 *                     112.0 96 5 5 0   1     0   5   52 60                 112
1679768 MA Suffolk   school 2500527 417   Bridge Boston Charter School (District) 250052702710 4170205 Bridge Boston Charter School (District) - Bridge Boston Charter School   Regular School Yes Elementary PK 08 2021   grade_8 0 12 5 0   0     0   3   11 9 *                     20.0 0 12 5 0   0     0   3   11 9                 20
1680118 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public (District) - Rising Tide Charter Public School   Regular School Yes High 05 12 2021   grade_8 69 3 5 1   1     0   8   55 32 *                     87.0 69 3 5 1   1     0   8   55 32                 87
1680451 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater-Raynham - Bridgewater Middle School   Regular School No Middle 07 08 2021   grade_8 243 20 5 1   5     1   21   141 155 *                     296.0 243 20 5 1   5     1   21   141 155                 296
1680658 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton-Dunstable - Groton Dunstable Regional Middle   Regular School No Middle 05 08 2021   grade_8 158 5 5 0   9     0   5   90 92 *                     182.0 158 5 5 0   9     0   5   90 92                 182
1680707 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham - Miles River Middle   Regular School No Middle 06 08 2021   grade_8 118 1 5 0   3     0   3   66 64 *                     130.0 118 1 5 0   3     0   3   66 64                 130
1680789 MA Essex   school 2507410 705   Masconomet 250741001097 7050405 Masconomet - Masconomet Regional Middle School   Regular School No Middle 07 08 2021   grade_8 250 2 5 0   5     0   0   138 124 *                     262.0 250 2 5 0   5     0   0   138 124                 262
1681122 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick-Tolland-Granville Regional School District - Southwick Regional School   Regular School No High 07 12 2021   grade_8 115 1 5 0   1     0   2   60 64 *                     124.0 115 1 5 0   1     0   2   60 64                 124
1672290 MA Norfolk   school 2502250 18   Avon 250225001295 180510 Avon - Avon Middle High School   Regular School No High 07 12 2021   grade_8 28 19 6 0   3     0   5   27 34 *                     61.0 28 19 6 0   3     0   5   27 34                 61
1673284 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_8 0 3 6 0   0     0   0   7 2 *                     9.0 0 3 6 0   0     0   0   7 2                 9
1673536 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_8 35 2 6 0   9     0   5   20 37 *                     57.0 35 2 6 0   9     0   5   20 37                 57
1673563 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline - Pierce   Regular School No Elementary KG 08 2021   grade_8 44 3 6 0   11     0   5   34 35 *                     69.0 44 3 6 0   11     0   5   34 35                 69
1674148 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury - Duxbury Middle   Regular School No Middle 06 08 2021   grade_8 229 0 6 1   3     0   6   110 135 *                     245.0 229 0 6 1   3     0   6   110 135                 245
1674552 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough - John J Ahern   Regular School No Middle 05 08 2021   grade_8 175 15 6 1   7     0   5   111 98 *                     209.0 175 15 6 1   7     0   5   111 98                 209
1674877 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Harvard - Bromfield   Regular School No High 06 12 2021   grade_8 65 3 6 0   8     0   3   44 41 *                     85.0 65 3 6 0   8     0   3   44 41                 85
1675353 MA Berkshire   school 2506750 152   Lenox 250675000978 1520505 Lenox - Lenox Memorial High   Regular School No High 06 12 2021   grade_8 48 0 6 0   3     0   4   33 28 *                     61.0 48 0 6 0   3     0   4   33 28                 61
1675615 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Lowell - Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2021   grade_8 4 0 6 0   0     0   0   9 * *                     10.0 4 0 6 0   0     0   0   9                   10
1677946 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville - West Somerville Neighborhood   Regular School No Elementary PK 08 2021   grade_8 24 2 6 0   4     0   2   23 15 *                     38.0 24 2 6 0   4     0   2   23 15                 38
1678285 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield - Balliet Middle School   Regular School No Middle 06 08 2021   grade_8 0 4 6 0   0     0   0   8 * *                     10.0 0 4 6 0   0     0   0   8                   10
1679038 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford - Blanchard Middle   Regular School No Middle 06 08 2021   grade_8 104 7 6 2   54     0   10   97 86 *                     183.0 104 7 6 2   54     0   10   97 86                 183
1679041 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Westford - Stony Brook School   Regular School No Middle 06 08 2021   grade_8 134 2 6 0   48     0   7   107 90 *                     197.0 134 2 6 0   48     0   7   107 90                 197
1679266 MA Worcester   school 2513080 343   Winchendon 251308002796 3430315 Winchendon - Murdock Middle School   Regular School No Middle 06 08 2021   grade_8 83 5 6 0   4     1   2   53 48 *                     101.0 83 5 6 0   4     1   2   53 48                 101
1679853 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District) - Community Charter School of Cambridge   Regular School Yes High 06 12 2021   grade_8 3 50 6 0   2     0   3   35 29 *                     64.0 3 50 6 0   2     0   3   35 29                 64
1680168 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public (District) - South Shore Charter Public School   Regular School Yes Other KG 12 2021   grade_8 26 43 6 0   4     0   3   45 37 *                     82.0 26 43 6 0   4     0   3   45 37                 82

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