Data source: Big Local News · About: Big Local

490 rows where grade = "grade_8", state = "MA" and year = 2017 sorted by total

View and edit SQL

year

  • 2017 · 490

grade

  • grade_8 · 490
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
1122006 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_8 * * * *   *     *   *   1 1                       *                         1 1                  
1123449 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Horace Mann School for the Deaf   Special Education School No Other PK 12 2017   grade_8 * * * *   *     *   *   1 2                       *                         1 2                  
1123655 MA Plymouth   school 2503090 44   Brockton 250309000966 440080 Frederick Douglass Academy   Regular School No High 07 12 2017   grade_8 * * * *   *     *   *   3 1                       *                         3 1                  
1125194 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125268 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_8 * * * *   *     *   *   * *                       *                                              
1125426 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_8 * * * *   *     *   *   2 3                       *                         2 3                  
1128684 MA Essex   school 2510380 258   Salem 251038002774 2580515 Salem Prep High School   Regular School No High 08 12 2017   grade_8 * * * *   *     *   *   2 *                       *                         2                    
1131245 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_8 77 4 6 0   10     0   3   51 49                       100 77 4 6 0   10     0   3   51 49                 100
1131588 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes Other KG 12 2017   grade_8 8 57 24 0   11     0   0   52 48                       100 8 57 24 0   11     0   0   52 48                 100
1124653 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No Elementary KG 08 2017   grade_8 34 14 39 0   11     0   3   53 48                       101 34 14 39 0   11     0   3   53 48                 101
1129375 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_8 4 6 89 1   1     0   0   63 38                       101 4 6 89 1   1     0   0   63 38                 101
1129379 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_8 1 11 89 0   0     0   0   54 47                       101 1 11 89 0   0     0   0   54 47                 101
1129964 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No High 07 12 2017   grade_8 81 4 12 0   0     1   4   59 43                       102 81 4 12 0   0     1   4   59 43                 102
1125356 MA Worcester   school 2505880 125   Harvard 250588000838 1250505 Bromfield   Regular School No Other 06 12 2017   grade_8 83 3 2 0   11     0   4   57 46                       103 83 3 2 0   11     0   4   57 46                 103
1125831 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_8 1 1 100 0   1     0   0   49 54                       103 1 1 100 0   1     0   0   49 54                 103
1126559 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No Elementary KG 08 2017   grade_8 29 20 22 1   26     0   5   70 33                       103 29 20 22 1   26     0   5   70 33                 103
1127589 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 Drury High   Regular School No High 08 12 2017   grade_8 84 2 5 0   0     1   11   55 48                       103 84 2 5 0   0     1   11   55 48                 103
1132377 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No High 07 12 2017   grade_8 83 3 7 0   2     0   8   51 52                       103 83 3 7 0   2     0   8   51 52                 103
1133165 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_8 65 17 16 0   1     0   4   57 46                       103 65 17 16 0   1     0   4   57 46                 103
1124682 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_8 17 30 52 0   3     0   2   48 56                       104 17 30 52 0   3     0   2   48 56                 104
1131858 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_8 87 2 7 0   3     2   3   52 52                       104 87 2 7 0   3     2   3   52 52                 104
1133180 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_8 2 88 8 0   4     0   2   51 53                       104 2 88 8 0   4     0   2   51 53                 104
1127130 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2017   grade_8 65 15 19 0   2     1   3   56 49                       105 65 15 19 0   2     1   3   56 49                 105
1130196 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_8 92 2 5 0   2     0   4   46 59                       105 92 2 5 0   2     0   4   46 59                 105
1131208 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_8 7 57 35 1   2     0   3   49 56                       105 7 57 35 1   2     0   3   49 56                 105
1132440 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_8 91 2 7 0   1     0   5   54 52                       106 91 2 7 0   1     0   5   54 52                 106
1132762 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No Middle 05 08 2017   grade_8 94 1 8 1   0     0   3   51 56                       107 94 1 8 1   0     0   3   51 56                 107
1130584 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No Middle 06 08 2017   grade_8 92 0 8 1   2     0   5   51 57                       108 92 0 8 1   2     0   5   51 57                 108
1126126 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_8 81 6 5 0   12     0   5   58 51                       109 81 6 5 0   12     0   5   58 51                 109
1129010 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_8 2 3 6 0   0     0   0   7 *                       11 2 3 6 0   0     0   0   7                   11
1124102 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_8 7 9 91 0   2     0   1   66 44                       110 7 9 91 0   2     0   1   66 44                 110
1131348 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_8 38 44 7 0   13     1   7   52 58                       110 38 44 7 0   13     1   7   52 58                 110
1124539 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_8 93 3 8 0   3     0   4   52 59                       111 93 3 8 0   3     0   4   52 59                 111
1124895 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_8 28 8 61 0   3     0   11   62 49                       111 28 8 61 0   3     0   11   62 49                 111
1126770 MA Middlesex   school 2507500 174   Maynard 250750001153 1740505 Maynard High   Regular School No High 08 12 2017   grade_8 95 3 8 0   2     0   3   54 57                       111 95 3 8 0   2     0   3   54 57                 111
1127047 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_8 99 1 2 0   6     1   3   70 42                       112 99 1 2 0   6     1   3   70 42                 112
1129394 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No Middle 06 08 2017   grade_8 9 30 71 0   1     0   1   62 50                       112 9 30 71 0   1     0   1   62 50                 112
1131816 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_8 99 0 9 0   0     0   4   60 52                       112 99 0 9 0   0     0   4   60 52                 112
1121975 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_8 111 2 0 0   1     0   0   51 63                       114 111 2 0 0   1     0   0   51 63                 114
1125132 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_8 112 0 0 0   1     0   1   59 55                       114 112 0 0 0   1     0   1   59 55                 114
1126591 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No Elementary KG 08 2017   grade_8 25 30 25 0   27     0   7   57 57                       114 25 30 25 0   27     0   7   57 57                 114
1131334 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2017   grade_8 23 50 32 1   7     0   2   51 64                       115 23 50 32 1   7     0   2   51 64                 115
1126138 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_8 97 1 5 1   8     0   4   60 56                       116 97 1 5 1   8     0   4   60 56                 116
1125861 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_8 2 2 113 0   0     0   0   61 56                       117 2 2 113 0   0     0   0   61 56                 117
1129583 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_8 103 3 2 0   2     0   7   66 51                       117 103 3 2 0   2     0   7   66 51                 117
1131216 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2017   grade_8 8 25 77 0   3     0   4   53 64                       117 8 25 77 0   3     0   4   53 64                 117
1125871 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_8 14 2 94 0   7     0   1   63 55                       118 14 2 94 0   7     0   1   63 55                 118
1132024 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No Middle 05 08 2017   grade_8 111 1 5 0   0     0   2   66 53                       119 111 1 5 0   0     0   2   66 53                 119
1132667 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_8 87 7 14 0   2     0   9   59 60                       119 87 7 14 0   2     0   9   59 60                 119
1123233 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Mission Hill School   Regular School No Elementary PK 08 2017   grade_8 1 4 7 0   0     0   0   7 5                       12 1 4 7 0   0     0   0   7 5                 12
1125923 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No Middle 06 08 2017   grade_8 98 3 14 0   4     0   2   73 48                       121 98 3 14 0   4     0   2   73 48                 121
1131525 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2017   grade_8 10 62 44 0   5     0   0   62 59                       121 10 62 44 0   5     0   0   62 59                 121
1132518 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_8 106 1 5 0   1     1   7   59 62                       121 106 1 5 0   1     1   7   59 62                 121
1124107 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_8 8 5 104 0   3     0   2   66 56                       122 8 5 104 0   3     0   2   66 56                 122
1126103 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_8 104 0 3 1   11     0   3   49 73                       122 104 0 3 1   11     0   3   49 73                 122
1132738 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_8 109 2 9 0   1     0   1   63 59                       122 109 2 9 0   1     0   1   63 59                 122
1126340 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg Middle School   Regular School No Middle 06 08 2017   grade_8 116 1 5 1   0     0   0   71 52                       123 116 1 5 1   0     0   0   71 52                 123
1125814 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No Middle 05 08 2017   grade_8 11 0 113 0   1     0   1   70 56                       126 11 0 113 0   1     0   1   70 56                 126
1131167 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2017   grade_8 80 9 22 1   8     0   7   70 57                       127 80 9 22 1   8     0   7   70 57                 127
1132119 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_8 113 1 5 0   6     0   2   68 59                       127 113 1 5 0   6     0   2   68 59                 127
1123260 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_8 15 17 85 0   10     0   1   70 58                       128 15 17 85 0   10     0   1   70 58                 128
1125441 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_8 92 2 33 0   1     0   1   74 55                       129 92 2 33 0   1     0   1   74 55                 129
1125809 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_8 2 2 119 0   4     0   2   62 67                       129 2 2 119 0   4     0   2   62 67                 129
1131309 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_8 47 28 42 0   5     0   7   61 68                       129 47 28 42 0   5     0   7   61 68                 129
1131841 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_8 91 6 12 2   5     0   13   62 67                       129 91 6 12 2   5     0   13   62 67                 129
1124148 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_8 4 1 8 0   0     0   0   9 4                       13 4 1 8 0   0     0   0   9 4                 13
1125407 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_8 96 4 26 0   3     0   1   68 62                       130 96 4 26 0   3     0   1   68 62                 130
1132370 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402836 7120515 Monomoy Regional High School   Regular School No High 08 12 2017   grade_8 109 9 5 1   0     0   6   58 72                       130 109 9 5 1   0     0   6   58 72                 130
1133204 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2017   grade_8 85 8 20 1   6     0   10   60 70                       130 85 8 20 1   6     0   10   60 70                 130
1132308 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2017   grade_8 125 0 1 0   4     0   1   62 69                       131 125 0 1 0   4     0   1   62 69                 131
1132929 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2017   grade_8 122 1 6 0   0     0   2   63 68                       131 122 1 6 0   0     0   2   63 68                 131
1132965 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_8 120 2 3 0   2     0   4   72 59                       131 120 2 3 0   2     0   4   72 59                 131
1124421 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_8 121 2 3 0   2     1   3   64 68                       132 121 2 3 0   2     1   3   64 68                 132
1128366 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2017   grade_8 90 8 5 1   22     0   6   69 63                       132 90 8 5 1   22     0   6   69 63                 132
1129351 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No Middle 06 08 2017   grade_8 10 28 93 0   1     0   1   67 66                       133 10 28 93 0   1     0   1   67 66                 133
1124246 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_8 126 3 0 0   5     0   0   68 66                       134 126 3 0 0   5     0   0   68 66                 134
1125414 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_8 80 2 50 0   2     0   0   65 69                       134 80 2 50 0   2     0   0   65 69                 134
1130066 MA Worcester   school 2512240 316   Webster 251224002849 3160315 Webster Middle School   Regular School No Middle 05 08 2017   grade_8 92 9 23 0   2     1   7   69 65                       134 92 9 23 0   2     1   7   69 65                 134
1126945 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No Elementary PK 08 2017   grade_8 61 0 56 0   11     0   7   70 65                       135 61 0 56 0   11     0   7   70 65                 135
1127975 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer High   Regular School No High 08 12 2017   grade_8 120 4 5 0   1     0   5   76 59                       135 120 4 5 0   1     0   5   76 59                 135
1129778 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No Middle 06 08 2017   grade_8 120 2 4 1   3     0   6   60 76                       136 120 2 4 1   3     0   6   60 76                 136
1132029 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No Middle 05 08 2017   grade_8 123 2 6 0   0     0   5   77 59                       136 123 2 6 0   0     0   5   77 59                 136
1123415 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_8 3 89 37 1   3     0   4   65 72                       137 3 89 37 1   3     0   4   65 72                 137
1126268 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F. Butler Middle School   Regular School No Middle 05 08 2017   grade_8 52 8 37 0   40     0   0   63 74                       137 52 8 37 0   40     0   0   63 74                 137
1129080 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_8 111 4 15 0   1     0   6   73 64                       137 111 4 15 0   1     0   6   73 64                 137
1123411 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No Elementary PK 08 2017   grade_8 15 5 111 0   5     0   2   73 65                       138 15 5 111 0   5     0   2   73 65                 138
1129398 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No Middle 06 08 2017   grade_8 15 20 100 0   2     0   1   69 69                       138 15 20 100 0   2     0   1   69 69                 138
1130354 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_8 126 1 3 2   2     0   4   79 59                       138 126 1 3 2   2     0   4   79 59                 138
1131891 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2017   grade_8 120 2 12 0   3     0   1   70 68                       138 120 2 12 0   3     0   1   70 68                 138
1132263 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No High 07 12 2017   grade_8 128 1 5 1   2     0   1   60 78                       138 128 1 5 1   2     0   1   60 78                 138
1124227 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_8 93 12 28 0   2     0   4   70 69                       139 93 12 28 0   2     0   4   70 69                 139
1127031 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2017   grade_8 121 3 8 0   2     0   5   67 72                       139 121 3 8 0   2     0   5   67 72                 139
1132224 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2017   grade_8 123 2 3 0   6     0   6   75 65                       140 123 2 3 0   6     0   6   75 65                 140
1126923 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_8 103 0 29 0   3     0   6   69 72                       141 103 0 29 0   3     0   6   69 72                 141
1122243 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_8 91 8 21 0   9     2   12   82 61                       143 91 8 21 0   9     2   12   82 61                 143
1126934 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No Elementary PK 08 2017   grade_8 83 0 48 0   7     0   5   72 71                       143 83 0 48 0   7     0   5   72 71                 143
1129887 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No Middle 06 08 2017   grade_8 115 7 5 0   13     0   3   68 75                       143 115 7 5 0   13     0   3   68 75                 143
1132898 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_8 130 4 6 0   3     0   2   78 67                       145 130 4 6 0   3     0   2   78 67                 145
1123376 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_8 29 42 49 1   22     0   3   71 75                       146 29 42 49 1   22     0   3   71 75                 146
1125788 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No Middle 05 08 2017   grade_8 2 1 143 0   0     0   0   73 73                       146 2 1 143 0   0     0   0   73 73                 146

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