Data source: Big Local News · About: Big Local

500 rows where grade = "grade_8", state = "MA" and year = 2020 sorted by hispanic_int

View and edit SQL

year

  • 2020 · 500

grade

  • grade_8 · 500
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
1365149 MA Norfolk   school 2502460 25   Bellingham 250246002543 250510 Keough Memorial Academy   Alternative School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1365345 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter School   Regular School No High 07 12 2020   grade_8 * * * *   *     *   *   1 2 *                     3.0                         1 2                 3
1366633 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No High 07 12 2020   grade_8 * * * *   *     *   *   2 2 *                     4.0                         2 2                 4
1367066 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2020   grade_8 * * * *   *     *   *   2 3 *                     5.0                         2 3                 5
1367688 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 02 11 2020   grade_8 * * * *   *     *   *   2 * *                     2.0                         2                   2
1368370 MA Middlesex   school 2507020 160   Lowell 250702002726 1600085 Laura Lee Therapeutic Day School   Regular School No Middle 03 08 2020   grade_8 * * * *   *     *   *   3 * *                     3.0                         3                   3
1368389 MA Middlesex   school 2507020 160   Lowell 250702002732 1600320 Leblanc Therapeutic Day School   Regular School No High 08 12 2020   grade_8 * * * *   *     *   *   1 1 *                     2.0                         1 1                 2
1368426 MA Middlesex   school 2507020 160   Lowell 250702002876 1600605 Dr. Janice Adie Day School   Special Education School No Other PK 12 2020   grade_8 * * * *   *     *   *   3 1 *                     4.0                         3 1                 4
1368465 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Advanced Community Experience Program   Special Education School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1373190 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No High 07 12 2020   grade_8 * * * *   *     *   *   1 * *                     2.0                         1                   2
1374315 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Ungraded UG UG 2020   grade_8 * * * *   *     *   *   * * *                     0.0                                             0
1366690 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg Elementary   Regular School No Elementary KG 08 2020   grade_8 14 1 0 0   0     0   1   7 9 *                     16.0 14 1 0 0   0     0   1   7 9                 16
1367199 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Stone PK-12 School   Regular School No Other 01 12 2020   grade_8 3 1 0 0   0     0   4   7 1 *                     8.0 3 1 0 0   0     0   4   7 1                 8
1367298 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2020   grade_8 7 0 0 0   0     0   0   1 6 *                     7.0 7 0 0 0   0     0   0   1 6                 7
1367639 MA Hampshire   school 2505940 127   Hatfield 250594000845 1270505 Smith Academy   Regular School No High 07 12 2020   grade_8 29 1 0 0   0     0   0   16 14 *                     30.0 29 1 0 0   0     0   0   16 14                 30
1367928 MA Plymouth   school 2506420 142   Hull 250642001307 1420305 Memorial Middle   Regular School No Middle 06 08 2020   grade_8 56 1 0 0   1     0   1   28 31 *                     59.0 56 1 0 0   1     0   1   28 31                 59
1369932 MA Plymouth   school 2509420 231   Pembroke 250942001823 2310305 Pembroke Community Middle School   Regular School No Middle 07 08 2020   grade_8 218 1 0 0   2     1   1   126 97 *                     223.0 218 1 0 0   2     1   1   126 97                 223
1371789 MA Middlesex   school 2512660 326   Westford 251266002080 3260330 Stony Brook School   Regular School No Middle 06 08 2020   grade_8 145 3 0 0   54     0   7   102 107 *                     209.0 145 3 0 0   54     0   7   102 107                 209
1366220 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Huntington Therapeutic Day School   Alternative School No Other 02 12 2020   grade_8 5 3 1 0   0     0   0   7 2 *                     9.0 5 3 1 0   0     0   0   7 2                 9
1372477 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public School   Regular School Yes High 07 12 2020   grade_8 34 1 1 0   0     0   2   18 20 *                     38.0 34 1 1 0   0     0   2   18 20                 38
1372779 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2020   grade_8 18 1 1 0   0     0   1   7 14 *                     21.0 18 1 1 0   0     0   1   7 14                 21
1372819 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2020   grade_8 64 0 1 1   0     0   3   38 31 *                     69.0 64 0 1 1   0     0   3   38 31                 69
1372964 MA Hampshire   school 2500517 497   Pioneer Valley Chinese Immersion Charter (District) 250051702619 4970205 Pioneer Valley Chinese Immersion Charter School   Regular School Yes Other KG 12 2020   grade_8 22 5 1 0   7     0   5   15 25 *                     40.0 22 5 1 0   7     0   5   15 25                 40
1373039 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley High School   Regular School No High 08 12 2020   grade_8 87 2 1 1   0     0   1   45 47 *                     92.0 87 2 1 1   0     0   1   45 47                 92
1373456 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573000822 6800005 Green Meadows Elementary   Regular School No Elementary PK 08 2020   grade_8 10 1 1 0   0     0   1   7 6 *                     13.0 10 1 1 0   0     0   1   7 6                 13
1373588 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2020   grade_8 124 2 1 0   2     0   1   56 74 *                     130.0 124 2 1 0   2     0   1   56 74                 130
1373784 MA Franklin   school 2509600 750   Pioneer Valley 250960001515 7500505 Pioneer Valley Regional   Regular School No High 07 12 2020   grade_8 61 2 1 0   0     0   2   38 28 *                     66.0 61 2 1 0   0     0   2   38 28                 66
1373860 MA Berkshire   school 2511040 765   Southern Berkshire 251104001774 7650505 Mt Everett Regional   Regular School No High 06 12 2020   grade_8 37 0 1 0   0     0   2   16 24 *                     40.0 37 0 1 0   0     0   2   16 24                 40
1364808 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_8 112 2 2 0   1     0   3   62 58 *                     120.0 112 2 2 0   1     0   3   62 58                 120
1367434 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Remington Middle   Regular School No Middle 06 08 2020   grade_8 137 4 2 0   7     0   3   77 76 *                     153.0 137 4 2 0   7     0   3   77 76                 153
1368241 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2020   grade_8 107 5 2 0   6     0   5   52 73 *                     125.0 107 5 2 0   6     0   5   52 73                 125
1372693 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 36 0 2 0   11     0   3   21 31 *                     52.0 36 0 2 0   11     0   3   21 31                 52
1372849 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter School   Regular School Yes Elementary KG 08 2020   grade_8 22 0 2 0   1     0   1   7 18 *                     26.0 22 0 2 0   1     0   1   7 18                 26
1373393 MA Middlesex   school 2505500 673   Groton-Dunstable 250550000805 6730305 Groton Dunstable Regional Middle   Regular School No Middle 05 08 2020   grade_8 185 2 2 1   9     1   3   105 98 *                     203.0 185 2 2 1   9     1   3   105 98                 203
1373514 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2020   grade_8 106 0 2 0   1     0   2   59 52 *                     111.0 106 0 2 0   1     0   2   59 52                 111
1373669 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No Elementary PK 08 2020   grade_8 56 0 2 0   11     0   2   36 35 *                     71.0 56 0 2 0   11     0   2   36 35                 71
1373675 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2020   grade_8 100 0 2 0   1     0   3   50 56 *                     106.0 100 0 2 0   1     0   3   50 56                 106
1373956 MA Dukes   school 2500043 774   Up-Island Regional 250004301927 7740020 West Tisbury Elementary   Regular School No Elementary PK 08 2020   grade_8 37 0 2 1   1     0   3   29 15 *                     44.0 37 0 2 1   1     0   3   29 15                 44
1366303 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Heath   Regular School No Elementary PK 08 2020   grade_8 34 2 3 0   11     0   3   31 22 *                     53.0 34 2 3 0   11     0   3   31 22                 53
1366530 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No High 06 12 2020   grade_8 124 1 3 0   0     0   3   81 50 *                     131.0 124 1 3 0   0     0   3   81 50                 131
1366715 MA Norfolk   school 2503780 65   Cohasset 250378002910 650305 Cohasset Middle School   Regular School No Middle 06 08 2020   grade_8 86 3 3 0   3     0   2   47 50 *                     97.0 86 3 3 0   3     0   2   47 50                 97
1366865 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2020   grade_8 109 0 3 0   1     0   3   73 43 *                     116.0 109 0 3 0   1     0   3   73 43                 116
1367470 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2020   grade_8 91 2 3 0   0     0   0   50 46 *                     96.0 91 2 3 0   0     0   0   50 46                 96
1369744 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell Middle School   Regular School No Middle 06 08 2020   grade_8 148 0 3 0   5     1   5   98 64 *                     162.0 148 0 3 0   5     1   5   98 64                 162
1370099 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2020   grade_8 6 4 3 0   0     0   2   7 8 *                     15.0 6 4 3 0   0     0   2   7 8                 15
1370333 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond Consolidated   Regular School No Elementary PK 08 2020   grade_8 18 0 3 0   0     0   1   12 10 *                     22.0 18 0 3 0   0     0   1   12 10                 22
1370376 MA Essex   school 2510200 252   Rockport 251020000506 2520305 Rockport Middle   Regular School No Middle 06 08 2020   grade_8 73 3 3 0   0     0   0   48 31 *                     79.0 73 3 3 0   0     0   0   48 31                 79
1370448 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich STEM Academy   Regular School No Middle 07 08 2020   grade_8 221 1 3 0   2     0   2   110 118 *                     229.0 221 1 3 0   2     0   2   110 118                 229
1371519 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2020   grade_8 98 2 3 0   0     0   4   55 52 *                     107.0 98 2 3 0   0     0   4   55 52                 107
1372770 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2020   grade_8 26 3 3 0   2     0   2   18 18 *                     36.0 26 3 3 0   2     0   2   18 18                 36
1372853 MA Plymouth   school 2500057 483   Rising Tide Charter Public (District) 250005701271 4830305 Rising Tide Charter Public School   Regular School Yes High 05 12 2020   grade_8 76 1 3 2   2     0   7   45 46 *                     91.0 76 1 3 2   2     0   7   45 46                 91
1373145 MA Worcester   school 2502580 620   Berlin-Boylston 250258000160 6200505 Tahanto Regional High   Regular School No High 06 12 2020   grade_8 84 2 3 0   5     0   3   55 42 *                     97.0 84 2 3 0   5     0   3   55 42                 97
1373188 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002659 6250320 Bridgewater Middle School   Regular School No Middle 07 08 2020   grade_8 212 21 3 0   2     0   16   145 109 *                     254.0 212 21 3 0   2     0   16   145 109                 254
1373473 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2020   grade_8 134 0 3 0   1     0   4   74 67 *                     142.0 134 0 3 0   1     0   4   74 67                 142
1373640 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 06 08 2020   grade_8 110 0 3 0   0     0   3   61 55 *                     116.0 110 0 3 0   0     0   3   61 55                 116
1374010 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2020   grade_8 109 3 3 0   3     0   3   51 70 *                     121.0 109 3 3 0   3     0   3   51 70                 121
1365192 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2020   grade_8 87 2 4 0   0     0   1   50 44 *                     94.0 87 2 4 0   0     0   1   50 44                 94
1366520 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle School   Regular School No Elementary PK 08 2020   grade_8 52 0 4 0   5     0   10   38 33 *                     71.0 52 0 4 0   5     0   10   38 33                 71
1367437 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Horace Mann   Regular School No Middle 06 08 2020   grade_8 130 3 4 0   9     0   4   77 73 *                     150.0 130 3 4 0   9     0   4   77 73                 150
1367545 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby Jr Sr High School   Regular School No High 07 12 2020   grade_8 50 0 4 0   1     0   2   29 28 *                     57.0 50 0 4 0   1     0   2   29 28                 57
1368078 MA Berkshire   school 2506690 150   Lee 250669000970 1500505 Lee Middle/High School   Regular School No High 07 12 2020   grade_8 50 1 4 0   2     0   1   31 27 *                     58.0 50 1 4 0   2     0   1   31 27                 58
1368796 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2020   grade_8 85 4 4 6   3     0   7   59 50 *                     109.0 85 4 4 6   3     0   7   59 50                 109
1368836 MA Norfolk   school 2507530 175   Medfield 250753001156 1750305 Thomas Blake Middle   Regular School No Middle 06 08 2020   grade_8 172 2 4 2   8     0   8   103 93 *                     196.0 172 2 4 2   8     0   8   103 93                 196
1369677 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield High   Regular School No High 07 12 2020   grade_8 53 0 4 0   0     0   3   34 26 *                     60.0 53 0 4 0   0     0   3   34 26                 60
1370168 MA Norfolk   school 2509870 243   Quincy 250987001561 2430305 Atlantic Middle   Regular School No Middle 06 08 2020   grade_8 74 9 4 0   96     2   8   105 88 *                     193.0 74 9 4 0   96     2   8   105 88                 193
1370259 MA Middlesex   school 2509990 246   Reading 250999001605 2460305 Arthur W Coolidge Middle   Regular School No Middle 06 08 2020   grade_8 139 4 4 0   8     1   5   82 79 *                     161.0 139 4 4 0   8     1   5   82 79                 161
1372608 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public School   Regular School Yes Other PK 12 2020   grade_8 0 15 4 0   0     0   0   10 9 *                     19.0 0 15 4 0   0     0   0   10 9                 19
1372710 MA Hampshire   school 2500031 450   Hilltown Cooperative Charter Public (District) 250003100549 4500105 Hilltown Cooperative Charter Public School   Regular School Yes Elementary KG 08 2020   grade_8 17 2 4 0   0     0   4   15 12 *                     27.0 17 2 4 0   0     0   4   15 12                 27
1372903 MA Plymouth   school 2500040 488   South Shore Charter Public (District) 250004000600 4880550 South Shore Charter Public School   Regular School Yes Other KG 12 2020   grade_8 30 32 4 0   8     0   6   40 40 *                     80.0 30 32 4 0   8     0   6   40 40                 80
1373186 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303001674 6250315 Raynham Middle School   Regular School No Middle 05 08 2020   grade_8 121 12 4 0   7     0   2   66 80 *                     146.0 121 12 4 0   7     0   2   66 80                 146
1373227 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2020   grade_8 127 0 4 0   2     0   6   70 69 *                     139.0 127 0 4 0   2     0   6   70 69                 139
1373274 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2020   grade_8 99 2 4 0   1     0   4   61 49 *                     110.0 99 2 4 0   1     0   4   61 49                 110
1373345 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville Middle School   Regular School No Middle 06 09 2020   grade_8 252 1 4 1   0     0   4   130 132 *                     262.0 252 1 4 1   0     0   4   130 132                 262
1373373 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway Regional Middle School   Regular School No Middle 06 08 2020   grade_8 59 2 4 0   0     0   1   31 35 *                     66.0 59 2 4 0   0     0   1   31 35                 66
1373619 MA Franklin   school 2507990 717   Mohawk Trail 250799001265 7170505 Mohawk Trail Regional School   Regular School No High 07 12 2020   grade_8 62 0 4 0   1     0   2   32 37 *                     69.0 62 0 4 0   1     0   2   32 37                 69
1373672 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Luther Burbank Middle School   Regular School No Middle 06 08 2020   grade_8 80 1 4 0   2     0   4   47 44 *                     91.0 80 1 4 0   2     0   4   47 44                 91
1373718 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2020   grade_8 114 4 4 0   3     0   3   78 50 *                     128.0 114 4 4 0   3     0   3   78 50                 128
1374014 MA Worcester   school 2511880 775   Wachusett 251188001494 7750315 Chocksett Middle School   Regular School No Middle 05 08 2020   grade_8 88 0 4 0   1     0   2   42 53 *                     95.0 88 0 4 0   1     0   2   42 53                 95
1366918 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury Middle   Regular School No Middle 06 08 2020   grade_8 223 2 5 0   6     0   12   123 125 *                     248.0 223 2 5 0   6     0   12   123 125                 248
1366932 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater JR./SR. High School   Regular School No High 07 12 2020   grade_8 167 2 5 1   0     0   4   102 77 *                     179.0 167 2 5 1   0     0   4   102 77                 179
1367018 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown Elementary   Regular School No Elementary PK 08 2020   grade_8 28 2 5 0   0     0   1   17 19 *                     36.0 28 2 5 0   0     0   1   17 19                 36
1367583 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hopkins Academy   Regular School No High 07 12 2020   grade_8 36 1 5 0   3     3   3   27 24 *                     51.0 36 1 5 0   3     3   3   27 24                 51
1367611 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover Middle   Regular School No Middle 05 08 2020   grade_8 208 5 5 0   5     0   1   125 99 *                     224.0 208 5 5 0   5     0   1   125 99                 224
1367625 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No High 06 12 2020   grade_8 66 0 5 0   11     0   2   41 43 *                     84.0 66 0 5 0   11     0   2   41 43                 84
1367874 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2020   grade_8 79 2 5 1   2     0   1   49 41 *                     90.0 79 2 5 1   2     0   1   49 41                 90
1368226 MA Middlesex   school 2506900 157   Lincoln 250690001183 1570025 Lincoln School   Regular School No Elementary PK 08 2020   grade_8 43 2 5 1   4     0   3   30 28 *                     58.0 43 2 5 1   4     0   3   30 28                 58
1369345 MA Bristol   school 2508430 201   New Bedford 250843002590 2010510 Trinity Day Academy   Regular School No Other 04 12 2020   grade_8 2 0 5 0   0     0   2   4 5 *                     9.0 2 0 5 0   0     0   2   4 5                 9
1369350 MA Bristol   school 2508430 201   New Bedford 250843002681 2010515 Whaling City Junior/Senior High School   Regular School No High 06 12 2020   grade_8 3 6 5 0   0     0   0   10 4 *                     14.0 3 6 5 0   0     0   0   10 4                 14
1369515 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 07 12 2020   grade_8 98 4 5 0   1     1   5   60 54 *                     114.0 98 4 5 0   1     1   5   60 54                 114
1370071 MA Plymouth   school 2509720 239   Plymouth 250972001380 2390305 Plymouth South Middle   Regular School No Middle 06 08 2020   grade_8 236 3 5 1   1     0   11   140 117 *                     257.0 236 3 5 1   1     0   11   140 117                 257
1370519 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Gates Middle School   Regular School No Middle 06 08 2020   grade_8 212 4 5 0   2     0   3   109 117 *                     226.0 212 4 5 0   2     0   3   109 117                 226
1370694 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 West Somerville Neighborhood   Regular School No Elementary PK 08 2020   grade_8 17 4 5 0   2     0   1   14 15 *                     29.0 17 4 5 0   2     0   1   14 15                 29
1371201 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2020   grade_8 103 2 5 0   3     0   3   57 59 *                     116.0 103 2 5 0   3     0   3   57 59                 116
1371715 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2020   grade_8 89 5 5 2   1     0   5   51 56 *                     107.0 89 5 5 2   1     0   5   51 56                 107
1372579 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2020   grade_8 62 3 5 0   1     0   6   38 39 *                     77.0 62 3 5 0   1     0   6   38 39                 77
1373123 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2020   grade_8 65 2 5 1   5     0   6   42 42 *                     84.0 65 2 5 1   5     0   6   42 42                 84
1373165 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2020   grade_8 112 2 5 0   0     0   6   70 55 *                     125.0 112 2 5 0   0     0   6   70 55                 125
1373351 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2020   grade_8 98 6 5 0   6     0   8   71 52 *                     123.0 98 6 5 0   6     0   8   71 52                 123
1373709 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2020   grade_8 107 3 5 0   3     0   6   72 52 *                     124.0 107 3 5 0   3     0   6   72 52                 124
1373936 MA Essex   school 2511740 773   Triton 251174001470 7730405 Triton Regional Middle School   Regular School No Middle 07 08 2020   grade_8 164 2 5 0   3     0   4   89 89 *                     178.0 164 2 5 0   3     0   4   89 89                 178

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