enrollments

Data source: Big Local News · About: Big Local

497 rows where grade = "grade_7", state = "MA" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 497 ✖

grade ✖

  • grade_7 · 497 ✖
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
1122005 1122005 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1122638 1122638 MA Suffolk   school 2502790 35   Boston 250279000210 350036 Carter Developmental Center   Regular School No High 07 12 2017   grade_7 * * * *   *     *   *   1 2                       *                         1 2                  
1123668 1123668 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Goddard Alternative School   Alternative School No Other 05 12 2017   grade_7 * * * *   *     *   *   4 1                       *                         4 1                  
1124658 1124658 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Devens School   Regular School No Other KG 12 2017   grade_7 * * * *   *     *   *   2 2                       *                         2 2                  
1125193 1125193 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Cuttyhunk Elementary   Regular School No Middle 06 07 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125267 1125267 MA Franklin   school 2505490 114   Greenfield 250549002771 1140030 Green River   Regular School No Elementary 04 04 2017   grade_7 * * * *   *     *   *   * *                       *                                              
1125425 1125425 MA Essex   school 2505970 128   Haverhill 250597001706 1280073 TEACH   Regular School No Other 01 12 2017   grade_7 * * * *   *     *   *   2 1                       *                         2 1                  
1129009 1129009 MA Middlesex   school 2510890 274   Somerville 251089002498 2740410 Next Wave Junior High   Alternative School No Middle 06 08 2017   grade_7 * * * *   *     *   *   3 *                       *                         3                    
1131924 1131924 MA Plymouth   school 2503030 625   Bridgewater-Raynham 250303002866 6250415 Therapeutic Day School   Special Education School No Other 05 12 2017   grade_7 * * * *   *     *   *   1 *                       *                         1                    
1124147 1124147 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee Academy   Alternative School No Other 06 12 2017   grade_7 1 0 9 0   0     0   0   9 1                       10 1 0 9 0   0     0   0   9 1                 10
1128279 1128279 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown Schools   Regular School No Elementary PK 08 2017   grade_7 4 2 4 0   0     0   0   4 6                       10 4 2 4 0   0     0   0   4 6                 10
1123621 1123621 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No Elementary KG 08 2017   grade_7 14 70 12 2   0     0   2   52 48                       100 14 70 12 2   0     0   2   52 48                 100
1131244 1131244 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes Other 05 12 2017   grade_7 84 4 1 0   9     0   2   47 53                       100 84 4 1 0   9     0   2   47 53                 100
1131620 1131620 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes Other KG 11 2017   grade_7 86 3 7 0   2     0   2   50 50                       100 86 3 7 0   2     0   2   50 50                 100
1129362 1129362 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 STEM Middle Academy   Regular School No Middle 06 08 2017   grade_7 16 25 58 0   2     0   0   67 34                       101 16 25 58 0   2     0   0   67 34                 101
1129397 1129397 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No Middle 06 08 2017   grade_7 14 10 74 0   4     0   0   60 42                       102 14 10 74 0   4     0   0   60 42                 102
1133164 1133164 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes Middle 06 08 2017   grade_7 78 4 12 1   2     1   4   52 50                       102 78 4 12 1   2     1   4   52 50                 102
1123263 1123263 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Washington Irving Middle   Regular School No Middle 06 08 2017   grade_7 5 44 49 1   1     0   3   49 54                       103 5 44 49 1   1     0   3   49 54                 103
1125638 1125638 MA Worcester   school 2506300 138   Hopedale 250630000915 1380505 Hopedale Jr Sr High   Regular School No High 07 12 2017   grade_7 95 2 5 0   0     0   1   50 53                       103 95 2 5 0   0     0   1   50 53                 103
1126102 1126102 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No Middle 06 08 2017   grade_7 89 2 2 0   7     0   3   51 52                       103 89 2 2 0   7     0   3   51 52                 103
1127129 1127129 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No Middle 06 08 2017   grade_7 57 12 24 0   1     0   9   47 56                       103 57 12 24 0   1     0   9   47 56                 103
1124671 1124671 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Lafayette School   Regular School No Elementary KG 08 2017   grade_7 37 22 37 0   5     0   3   50 54                       104 37 22 37 0   5     0   3   50 54                 104
1124681 1124681 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Parlin School   Regular School No Elementary KG 08 2017   grade_7 15 16 70 2   1     0   0   52 52                       104 15 16 70 2   1     0   0   52 52                 104
1129374 1129374 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No Middle 06 08 2017   grade_7 2 11 91 0   0     0   0   58 46                       104 2 11 91 0   0     0   0   58 46                 104
1129382 1129382 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2017   grade_7 15 23 62 1   1     0   2   50 54                       104 15 23 62 1   1     0   2   50 54                 104
1133179 1133179 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_7 4 92 8 0   0     0   0   59 45                       104 4 92 8 0   0     0   0   59 45                 104
1127046 1127046 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No Middle 05 08 2017   grade_7 91 5 5 0   3     0   1   58 47                       105 91 5 5 0   3     0   1   58 47                 105
1129378 1129378 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Chestnut Accelerated Middle School (South)   Regular School No Middle 06 08 2017   grade_7 4 13 87 0   1     0   0   53 52                       105 4 13 87 0   1     0   0   53 52                 105
1131488 1131488 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2017   grade_7 68 15 5 0   15     0   2   50 55                       105 68 15 5 0   15     0   2   50 55                 105
1122439 1122439 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley Middle School   Regular School No Middle 05 08 2017   grade_7 98 1 3 0   2     0   2   54 52                       106 98 1 3 0   2     0   2   54 52                 106
1132118 1132118 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No High 07 12 2017   grade_7 94 2 6 0   1     1   2   55 51                       106 94 2 6 0   1     1   2   55 51                 106
1132928 1132928 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2017   grade_7 95 0 8 0   0     0   3   52 54                       106 95 0 8 0   0     0   3   52 54                 106
1131815 1131815 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No Middle 05 08 2017   grade_7 96 1 6 1   0     0   3   53 54                       107 96 1 6 1   0     0   3   53 54                 107
1124927 1124927 MA Berkshire   school 2504920 98   Florida 250492000706 980005 Abbott Memorial   Regular School No Elementary PK 08 2017   grade_7 11 0 0 0   0     0   0   6 5                       11 11 0 0 0   0     0   0   6 5                 11
1126503 1126503 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No High 07 12 2017   grade_7 3 0 7 0   0     0   1   9 2                       11 3 0 7 0   0     0   1   9 2                 11
1129370 1129370 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Balliet Middle School   Regular School No Middle 06 08 2017   grade_7 1 2 8 0   0     0   0   7 4                       11 1 2 8 0   0     0   0   7 4                 11
1123259 1123259 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No Middle 06 08 2017   grade_7 9 16 75 0   7     0   3   58 52                       110 9 16 75 0   7     0   3   58 52                 110
1124894 1124894 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No Middle 05 08 2017   grade_7 38 6 49 0   7     0   10   62 48                       110 38 6 49 0   7     0   10   62 48                 110
1129331 1129331 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No Other 06 12 2017   grade_7 28 27 54 0   1     0   0   57 53                       110 28 27 54 0   1     0   0   57 53                 110
1132439 1132439 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No Middle 05 08 2017   grade_7 99 2 7 0   0     1   2   60 51                       111 99 2 7 0   0     1   2   60 51                 111
1126125 1126125 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No Middle 06 08 2017   grade_7 92 3 5 1   7     0   4   58 54                       112 92 3 5 1   7     0   4   58 54                 112
1131347 1131347 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes Other KG 12 2017   grade_7 38 53 7 0   9     0   5   50 62                       112 38 53 7 0   9     0   5   50 62                 112
1131758 1131758 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000021 6030505 Hoosac Valley Middle & High School   Regular School No Other 06 12 2017   grade_7 104 6 1 0   1     0   0   58 54                       112 104 6 1 0   1     0   0   58 54                 112
1130195 1130195 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No High 07 12 2017   grade_7 105 2 5 0   1     0   0   61 52                       113 105 2 5 0   1     0   0   61 52                 113
1131840 1131840 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2017   grade_7 88 5 10 1   2     1   6   52 61                       113 88 5 10 1   2     1   6   52 61                 113
1126768 1126768 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No Elementary 04 07 2017   grade_7 93 4 13 1   1     0   2   54 60                       114 93 4 13 1   1     0   2   54 60                 114
1132479 1132479 MA Worcester   school 2508310 725   Nashoba 250831001868 7250310 Hale   Regular School No Middle 06 08 2017   grade_7 108 1 3 0   2     0   0   49 65                       114 108 1 3 0   2     0   0   49 65                 114
1125505 1125505 MA Norfolk   school 2506150 133   Holbrook 250615000878 1330505 Holbrook Jr Sr High   Regular School No High 07 12 2017   grade_7 69 21 11 0   5     0   9   60 55                       115 69 21 11 0   5     0   9   60 55                 115
1128365 1128365 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No Middle 06 08 2017   grade_7 80 6 6 0   19     0   4   66 49                       115 80 6 6 0   19     0   4   66 49                 115
1123414 1123414 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_7 3 63 40 0   3     0   7   75 41                       116 3 63 40 0   3     0   7   75 41                 116
1124027 1124027 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver Middle/High School   Regular School No Other 06 12 2017   grade_7 109 2 4 0   1     0   0   70 46                       116 109 2 4 0   1     0   0   70 46                 116
1132666 1132666 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No High 07 12 2017   grade_7 102 3 3 0   1     0   7   53 63                       116 102 3 3 0   1     0   7   53 63                 116
1123267 1123267 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No Middle 06 08 2017   grade_7 0 41 68 0   1     1   6   66 51                       117 0 41 68 0   1     1   6   66 51                 117
1125131 1125131 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No Middle 07 08 2017   grade_7 112 1 1 0   2     0   1   66 51                       117 112 1 1 0   2     0   1   66 51                 117
1125830 1125830 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 UP Academy Oliver Middle School   Regular School No Middle 06 08 2017   grade_7 2 2 113 0   0     0   0   71 46                       117 2 2 113 0   0     0   0   71 46                 117
1125413 1125413 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No Middle 05 08 2017   grade_7 69 7 41 0   2     0   0   52 67                       119 69 7 41 0   2     0   0   52 67                 119
1127973 1127973 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No Middle 06 07 2017   grade_7 102 4 10 0   1     0   2   67 52                       119 102 4 10 0   1     0   2   67 52                 119
1131215 1131215 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_7 7 33 71 0   2     0   6   57 62                       119 7 33 71 0   2     0   6   57 62                 119
1131857 1131857 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No Middle 05 08 2017   grade_7 104 1 10 1   1     0   2   42 77                       119 104 1 10 1   1     0   2   42 77                 119
1132897 1132897 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No Middle 06 08 2017   grade_7 109 1 4 0   1     0   5   67 53                       120 109 1 4 0   1     0   5   67 53                 120
1125870 1125870 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No Middle 05 08 2017   grade_7 16 3 98 0   3     0   1   63 58                       121 16 3 98 0   3     0   1   63 58                 121
1131333 1131333 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_7 23 63 28 0   7     0   0   55 66                       121 23 63 28 0   7     0   0   55 66                 121
1132528 1132528 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No Middle 05 08 2017   grade_7 112 2 5 0   0     0   3   59 63                       122 112 2 5 0   0     0   3   59 63                 122
1124106 1124106 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_7 1 2 117 0   2     0   1   65 58                       123 1 2 117 0   2     0   1   65 58                 123
1124420 1124420 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No Middle 06 08 2017   grade_7 115 0 3 0   2     1   2   68 55                       123 115 0 3 0   2     1   2   68 55                 123
1125860 1125860 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No Middle 06 08 2017   grade_7 6 1 116 0   0     0   0   63 60                       123 6 1 116 0   0     0   0   63 60                 123
1124538 1124538 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No Middle 05 08 2017   grade_7 100 1 17 0   4     0   2   57 67                       124 100 1 17 0   4     0   2   57 67                 124
1130353 1130353 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport Junior/Senior High School   Regular School No High 07 12 2017   grade_7 114 0 3 0   2     0   5   66 58                       124 114 0 3 0   2     0   5   66 58                 124
1125283 1125283 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield Middle   Regular School No Elementary 04 07 2017   grade_7 88 4 20 0   4     0   9   66 59                       125 88 4 20 0   4     0   9   66 59                 125
1131166 1131166 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_7 73 10 25 2   5     1   9   63 62                       125 73 10 25 2   5     1   9   63 62                 125
1132517 1132517 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No Middle 05 08 2017   grade_7 112 0 7 0   2     0   4   57 68                       125 112 0 7 0   2     0   4   57 68                 125
1129582 1129582 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No Middle 06 08 2017   grade_7 120 0 1 0   1     0   4   61 65                       126 120 0 1 0   1     0   4   61 65                 126
1132737 1132737 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No High 07 12 2017   grade_7 119 3 3 0   0     0   1   62 64                       126 119 3 3 0   0     0   1   62 64                 126
1124226 1124226 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No Elementary 04 08 2017   grade_7 90 4 30 0   1     0   2   70 57                       127 90 4 30 0   1     0   2   70 57                 127
1126137 1126137 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No Middle 06 08 2017   grade_7 111 1 5 0   6     0   4   68 59                       127 111 1 5 0   6     0   4   68 59                 127
1124245 1124245 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No Other 06 12 2017   grade_7 114 4 3 2   3     0   2   64 64                       128 114 4 3 2   3     0   2   64 64                 128
1126922 1126922 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No Elementary PK 08 2017   grade_7 96 2 25 0   2     0   3   67 61                       128 96 2 25 0   2     0   3   67 61                 128
1126736 1126736 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No Middle 07 08 2017   grade_7 105 4 4 7   3     1   5   71 58                       129 105 4 4 7   3     1   5   71 58                 129
1131308 1131308 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes Other KG 12 2017   grade_7 31 35 47 0   4     0   12   58 71                       129 31 35 47 0   4     0   12   58 71                 129
1125884 1125884 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 School for Exceptional Studies   Regular School No Other 01 12 2017   grade_7 2 1 10 0   0     0   0   11 2                       13 2 1 10 0   0     0   0   11 2                 13
1125406 1125406 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No Middle 06 08 2017   grade_7 100 6 21 0   2     0   1   64 66                       130 100 6 21 0   2     0   1   64 66                 130
1125808 1125808 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No Middle 05 08 2017   grade_7 1 2 125 0   2     0   0   57 73                       130 1 2 125 0   2     0   0   57 73                 130
1124101 1124101 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_7 6 7 112 1   3     0   2   70 61                       131 6 7 112 1   3     0   2   70 61                 131
1129791 1129791 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 McCloskey Middle School   Regular School No Middle 06 08 2017   grade_7 116 0 7 0   3     0   5   67 64                       131 116 0 7 0   3     0   5   67 64                 131
1132307 1132307 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No Middle 06 08 2017   grade_7 126 0 2 0   3     0   1   65 67                       132 126 0 2 0   3     0   1   65 67                 132
1124111 1124111 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_7 5 9 115 0   4     0   0   67 66                       133 5 9 115 0   4     0   0   67 66                 133
1131967 1131967 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Nessacus Regional Middle School   Regular School No Middle 06 08 2017   grade_7 123 2 2 0   1     0   6   76 58                       134 123 2 2 0   1     0   6   76 58                 134
1132368 1132368 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No Middle 05 07 2017   grade_7 108 3 13 2   2     1   6   67 68                       135 108 3 13 2   2     1   6   67 68                 135
1132964 1132964 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No Middle 06 08 2017   grade_7 128 2 2 0   0     0   3   68 67                       135 128 2 2 0   0     0   3   68 67                 135
1122247 1122247 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_7 90 9 22 0   10     1   4   74 62                       136 90 9 22 0   10     1   4   74 62                 136
1132223 1132223 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No Middle 06 08 2017   grade_7 127 1 6 0   2     0   0   73 63                       136 127 1 6 0   2     0   0   73 63                 136
1127956 1127956 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No Middle 05 07 2017   grade_7 111 4 11 1   1     2   7   60 77                       137 111 4 11 1   1     2   7   60 77                 137
1129079 1129079 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No Middle 05 08 2017   grade_7 106 4 18 0   4     0   5   65 72                       137 106 4 18 0   4     0   5   65 72                 137
1125440 1125440 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No Middle 05 08 2017   grade_7 97 7 30 0   3     1   1   67 72                       139 97 7 30 0   3     1   1   67 72                 139
1131207 1131207 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_7 7 75 49 2   1     0   5   80 59                       139 7 75 49 2   1     0   5   80 59                 139
1122991 1122991 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Oliver Hazard Perry   Regular School No Elementary PK 08 2017   grade_7 5 4 4 0   1     0   0   13 1                       14 5 4 4 0   1     0   0   13 1                 14
1131456 1131456 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter School   Regular School Yes Other KG 12 2017   grade_7 10 2 1 0   0     0   1   5 9                       14 10 2 1 0   0     0   1   5 9                 14
1127030 1127030 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No High 07 12 2017   grade_7 112 5 12 0   5     0   6   71 69                       140 112 5 12 0   5     0   6   71 69                 140
1122242 1122242 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_7 97 8 24 0   4     0   8   77 64                       141 97 8 24 0   4     0   8   77 64                 141
1124705 1124705 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No Middle 06 08 2017   grade_7 127 1 6 0   3     0   4   74 67                       141 127 1 6 0   3     0   4   74 67                 141

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