enrollments

Data source: Big Local News · About: Big Local

495 rows where grade = "grade_7", state = "MA" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 495 ✖

grade ✖

  • grade_7 · 495 ✖
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
2230210 2230210 MA Suffolk   school   35   Boston   350652               2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2231644 2231644 MA Bristol   school 2504830 95   Fall River 250483002858 950515 Fall River: Fall River Gateway to College @ BCC   Regular School No High 12 12 2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2237228 2237228 MA Hampden   school 2512510 332   West Springfield 251251002790 3320515 West Springfield: 21st Century Skills Academy   Regular School No High 12 12 2018   grade_7 * * * *   *     *   *   * *                       0.0                                             0
2232022 2232022 MA Dukes   school 2505340 109   Gosnold 250534000725 1090005 Gosnold: Cuttyhunk Elementary   Regular School No Middle 07 08 2018   grade_7 * * * *   *     *   *   * *                       1.0                                             1
2229377 2229377 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston: Lyon K-8   Regular School No Elementary KG 08 2018   grade_7 3 1 4 0   1     0   1   7 3                       10.0 3 1 4 0   1     0   1   7 3                 10
2235100 2235100 MA Barnstable   school 2509840 242   Provincetown 250984002694 2420020 Provincetown: Provincetown Schools   Regular School No Elementary PK 08 2018   grade_7 5 1 3 0   0     0   1   7 3                       10.0 5 1 3 0   0     0   1   7 3                 10
2230068 2230068 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston: Washington Irving Middle   Regular School No Middle 06 08 2018   grade_7 2 47 49 0   2     0   0   53 47                       100.0 2 47 49 0   2     0   0   53 47                 100
2230439 2230439 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton: Edgar B Davis   Regular School No Elementary KG 08 2018   grade_7 14 63 12 0   0     1   10   42 58                       100.0 14 63 12 0   0     1   10   42 58                 100
2230782 2230782 MA Middlesex   school 2503270 49   Cambridge 250327002756 490320 Cambridge: Vassal Lane Upper School   Regular School No Middle 06 08 2018   grade_7 48 22 4 0   20     1   5   45 55                       100.0 48 22 4 0   20     1   5   45 55                 100
2231237 2231237 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas: Douglas Middle School   Regular School No Middle 06 08 2018   grade_7 92 0 6 0   1     0   1   49 51                       100.0 92 0 6 0   1     0   1   49 51                 100
2232677 2232677 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 Lawrence: UP Academy Leonard Middle School   Regular School No Middle 06 08 2018   grade_7 1 0 98 0   1     0   0   54 46                       100.0 1 0 98 0   1     0   0   54 46                 100
2234410 2234410 MA Berkshire   school 2508670 209   North Adams 250867001387 2090505 North Adams: Drury High   Regular School No High 07 12 2018   grade_7 85 4 4 0   0     0   7   52 48                       100.0 85 4 4 0   0     0   7   52 48                 100
2238075 2238075 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter (District): Innovation Academy Charter School   Regular School Yes High 05 12 2018   grade_7 82 2 6 0   5     0   5   57 43                       100.0 82 2 6 0   5     0   5   57 43                 100
2238646 2238646 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston: Athol-Royalston Middle School   Regular School No Middle 05 08 2018   grade_7 91 0 6 0   0     0   3   49 51                       100.0 91 0 6 0   0     0   3   49 51                 100
2229525 2229525 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston: Donald Mckay   Regular School No Elementary PK 08 2018   grade_7 12 2 85 0   1     0   1   47 54                       101.0 12 2 85 0   1     0   1   47 54                 101
2236181 2236181 MA Hampden   school 2511130 281   Springfield 251113002642 2810350 Springfield: STEM Middle Academy   Regular School No Middle 06 08 2018   grade_7 12 19 67 0   3     0   0   67 34                       101.0 12 19 67 0   3     0   0   67 34                 101
2238688 2238688 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Berkshire Hills: Monument Valley Regional Middle School   Regular School No Middle 05 08 2018   grade_7 83 1 10 0   4     0   3   51 50                       101.0 83 1 10 0   4     0   3   51 50                 101
2238854 2238854 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton-Rehoboth: Dighton Middle School   Regular School No Middle 05 08 2018   grade_7 91 1 4 0   1     0   5   56 46                       102.0 91 1 4 0   1     0   5   56 46                 102
2239982 2239982 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School (District): Argosy Collegiate Charter School   Regular School Yes Middle 06 09 2018   grade_7 65 10 15 1   3     1   8   54 49                       103.0 65 10 15 1   3     1   8   54 49                 103
2236200 2236200 MA Hampden   school 2511130 281   Springfield 251113002840 2810367 Springfield: Chestnut Accelerated Middle School (Talented and Gifted)   Regular School No Middle 06 08 2018   grade_7 14 30 52 0   4     1   3   44 60                       104.0 14 30 52 0   4     1   3   44 60                 104
2239264 2239264 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett: Narragansett Middle   Regular School No Middle 05 08 2018   grade_7 95 0 7 0   0     0   2   55 49                       104.0 95 0 7 0   0     0   2   55 49                 104
2230064 2230064 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Boston: Clarence R Edwards Middle   Regular School No Middle 06 08 2018   grade_7 7 14 75 0   7     0   2   63 42                       105.0 7 14 75 0   7     0   2   63 42                 105
2231355 2231355 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_7 86 2 12 0   3     0   2   60 45                       105.0 86 2 12 0   3     0   2   60 45                 105
2233863 2233863 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_7 89 1 12 0   0     0   3   53 52                       105.0 89 1 12 0   0     0   3   53 52                 105
2231489 2231489 MA Middlesex   school 2504770 93   Everett 250477001520 930038 Everett: Lafayette School   Regular School No Elementary KG 08 2018   grade_7 32 18 50 1   2     0   3   49 57                       106.0 32 18 50 1   2     0   3   49 57                 106
2231498 2231498 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_7 11 10 81 0   4     0   0   58 48                       106.0 11 10 81 0   4     0   0   58 48                 106
2237010 2237010 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater: West Bridgewater Junior/Senior   Regular School No High 07 12 2018   grade_7 96 5 5 0   0     0   0   61 45                       106.0 96 5 5 0   0     0   0   61 45                 106
2239342 2239342 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 North Middlesex: Hawthorne Brook   Regular School No Middle 05 08 2018   grade_7 105 0 1 0   0     0   2   46 62                       108.0 105 0 1 0   0     0   2   46 62                 108
2239999 2239999 MA Plymouth   school 2500559 3513   New Heights Charter School of Brockton (District) 250055902869 35130305 New Heights Charter School of Brockton (District): New Heights Charter School of Brockton   Regular School Yes Middle 06 09 2018   grade_7 1 95 10 0   0     0   2   51 57                       108.0 1 95 10 0   0     0   2   51 57                 108
2236150 2236150 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 Springfield: The Springfield Renaissance School an Expeditionary Learning School   Regular School No High 06 12 2018   grade_7 24 22 62 0   1     0   0   55 54                       109.0 24 22 62 0   1     0   0   55 54                 109
2238454 2238454 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter (District): Atlantis Charter School   Regular School Yes Other KG 12 2018   grade_7 85 7 11 0   3     0   3   56 53                       109.0 85 7 11 0   3     0   3   56 53                 109
2238514 2238514 MA Hampden   school 2500522 499   Hampden Charter School of Science East (District) 250052202680 4990305 Hampden Charter School of Science East (District): Hampden Charter School of Science East   Regular School Yes High 06 12 2018   grade_7 40 29 36 0   1     0   3   52 57                       109.0 40 29 36 0   1     0   3   52 57                 109
2232700 2232700 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_7 2 0 9 0   0     0   0   10 1                       11.0 2 0 9 0   0     0   0   10 1                 11
2231960 2231960 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown: Georgetown Middle School   Regular School No Middle 07 08 2018   grade_7 107 2 1 0   1     0   1   62 50                       112.0 107 2 1 0   1     0   1   62 50                 112
2232941 2232941 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Longmeadow: Glenbrook Middle   Regular School No Middle 06 08 2018   grade_7 87 4 6 0   14     0   2   57 56                       113.0 87 4 6 0   14     0   2   57 56                 113
2237168 2237168 MA Bristol   school 2512780 331   Westport 251278002861 3310515 Westport: Westport Junior/Senior High School   Regular School No High 07 12 2018   grade_7 104 2 3 0   1     0   5   62 53                       115.0 104 2 3 0   1     0   5   62 53                 115
2238796 2238796 MA Berkshire   school 2503390 635   Central Berkshire 250339000466 6350305 Central Berkshire: Nessacus Regional Middle School   Regular School No Middle 06 08 2018   grade_7 107 1 3 0   0     0   4   54 61                       115.0 107 1 3 0   0     0   4   54 61                 115
2230916 2230916 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea: Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2018   grade_7 12 4 96 0   2     0   2   64 52                       116.0 12 4 96 0   2     0   2   64 52                 116
2232738 2232738 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester: Leicester Middle   Regular School No Middle 06 08 2018   grade_7 93 4 10 0   2     0   7   54 62                       116.0 93 4 10 0   2     0   7   54 62                 116
2238949 2238949 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier: Frontier Regional   Regular School No High 07 12 2018   grade_7 105 2 4 0   2     0   3   62 54                       116.0 105 2 4 0   2     0   3   62 54                 116
2239552 2239552 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 2018   grade_7 105 3 4 0   3     0   1   59 57                       116.0 105 3 4 0   3     0   1   59 57                 116
2239576 2239576 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Spencer-E Brookfield: Knox Trail Middle School   Regular School No Middle 05 08 2018   grade_7 100 1 12 0   2     0   1   67 49                       116.0 100 1 12 0   2     0   1   67 49                 116
2239093 2239093 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire: Hampshire Regional High   Regular School No High 07 12 2018   grade_7 112 1 3 0   1     0   1   58 60                       118.0 112 1 3 0   1     0   1   58 60                 118
2228782 2228782 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_7 116 1 1 0   0     0   1   58 61                       119.0 116 1 1 0   0     0   1   58 61                 119
2232647 2232647 MA Essex   school 2506660 149   Lawrence 250666002805 1490049 Lawrence: UP Academy Oliver Middle School   Regular School No Middle 06 08 2018   grade_7 3 1 115 0   0     0   0   61 58                       119.0 3 1 115 0   0     0   0   61 58                 119
2232918 2232918 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton: Littleton Middle School   Regular School No Middle 06 08 2018   grade_7 103 0 1 1   8     0   6   57 62                       119.0 103 0 1 1   8     0   6   57 62                 119
2234796 2234796 MA Hampden   school 2509300 227   Palmer 250930001485 2270505 Palmer: Palmer High   Regular School No High 06 12 2018   grade_7 95 3 13 0   0     0   8   70 49                       119.0 95 3 13 0   0     0   8   70 49                 119
2229797 2229797 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston: Oliver Hazard Perry   Regular School No Elementary PK 08 2018   grade_7 9 2 1 0   0     0   0   5 7                       12.0 9 2 1 0   0     0   0   5 7                 12
2232258 2232258 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_7 77 4 36 0   2     1   0   56 64                       120.0 77 4 36 0   2     1   0   56 64                 120
2236197 2236197 MA Hampden   school 2511130 281   Springfield 251113002837 2810366 Springfield: Impact Prep at Chestnut   Regular School No Middle 06 07 2018   grade_7 4 15 101 0   0     0   0   54 66                       120.0 4 15 101 0   0     0   0   54 66                 120
2236215 2236215 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Springfield: Van Sickle Academy   Regular School No Middle 06 08 2018   grade_7 16 14 87 0   2     0   1   67 53                       120.0 16 14 87 0   2     0   1   67 53                 120
2230234 2230234 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston: TechBoston Academy   Regular School No High 06 12 2018   grade_7 2 73 40 0   1     1   4   82 39                       121.0 2 73 40 0   1     1   4   82 39                 121
2232096 2232096 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   grade_7 86 1 26 0   1     0   8   64 58                       122.0 86 1 26 0   1     0   8   64 58                 122
2238045 2238045 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter (District): KIPP Academy Lynn Charter School   Regular School Yes Other KG 12 2018   grade_7 8 18 91 0   2     0   3   74 48                       122.0 8 18 91 0   2     0   3   74 48                 122
2233750 2233750 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Methuen: Comprehensive Grammar School   Regular School No Elementary PK 08 2018   grade_7 59 2 46 0   8     0   8   58 65                       123.0 59 2 46 0   8     0   8   58 65                 123
2238165 2238165 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School   Regular School Yes Other KG 12 2018   grade_7 26 62 25 0   3     0   7   65 58                       123.0 26 62 25 0   3     0   7   65 58                 123
2229660 2229660 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston: John W McCormack   Regular School No Middle 06 08 2018   grade_7 8 40 71 0   3     0   2   62 62                       124.0 8 40 71 0   3     0   2   62 62                 124
2232687 2232687 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_7 7 1 112 0   3     0   1   72 52                       124.0 7 1 112 0   3     0   1   72 52                 124
2228922 2228922 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_7 73 2 11 0   35     0   4   50 75                       125.0 73 2 11 0   35     0   4   50 75                 125
2231041 2231041 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton: Clinton Middle School   Regular School No Middle 04 08 2018   grade_7 91 7 26 0   1     0   0   74 51                       125.0 91 7 26 0   1     0   0   74 51                 125
2233162 2233162 MA Worcester   school 2507080 162   Lunenburg 250708002870 1620305 Lunenburg: Lunenburg Middle School   Regular School No Middle 06 08 2018   grade_7 107 2 12 0   2     0   2   74 51                       125.0 107 2 12 0   2     0   2   74 51                 125
2236212 2236212 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Springfield: Rise Academy at Van Sickle   Regular School No Middle 06 07 2018   grade_7 10 19 91 0   2     0   3   66 59                       125.0 10 19 91 0   2     0   3   66 59                 125
2239138 2239138 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional: Manchester Essex Regional Middle School   Regular School No Middle 06 08 2018   grade_7 121 0 0 0   2     0   2   72 53                       125.0 121 0 0 0   2     0   2   72 53                 125
2239353 2239353 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 North Middlesex: Nissitissit Middle School   Regular School No Middle 05 08 2018   grade_7 116 0 3 0   4     0   2   72 53                       125.0 116 0 3 0   4     0   2   72 53                 125
2239491 2239491 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar: Ralph C Mahar Regional   Regular School No High 07 12 2018   grade_7 114 1 8 0   2     0   1   69 57                       126.0 114 1 8 0   2     0   1   69 57                 126
2239743 2239743 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional: Quaboag Regional Middle Innovation School   Regular School No Middle 07 08 2018   grade_7 113 0 9 0   0     0   4   64 62                       126.0 113 0 9 0   0     0   4   64 62                 126
2233085 2233085 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell: B.F. Butler Middle School   Regular School No Middle 05 08 2018   grade_7 39 11 41 0   30     0   6   68 59                       127.0 39 11 41 0   30     0   6   68 59                 127
2233943 2233943 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Nantucket: Cyrus Peirce   Regular School No Middle 06 08 2018   grade_7 71 14 36 0   1     0   5   63 64                       127.0 71 14 36 0   1     0   5   63 64                 127
2235186 2235186 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Quincy: Broad Meadows Middle   Regular School No Middle 06 08 2018   grade_7 84 10 8 1   21     1   3   59 69                       128.0 84 10 8 1   21     1   3   59 69                 128
2238139 2238139 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter (District): Sabis International Charter School   Regular School Yes Other KG 12 2018   grade_7 26 35 54 0   6     0   7   66 62                       128.0 26 35 54 0   6     0   7   66 62                 128
2238179 2238179 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 2018   grade_7 54 52 4 1   6     0   11   63 65                       128.0 54 52 4 1   6     0   11   63 65                 128
2238321 2238321 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter (District): Mystic Valley Regional Charter School   Regular School Yes Other KG 12 2018   grade_7 69 17 14 0   26     0   2   67 61                       128.0 69 17 14 0   26     0   2   67 61                 128
2235376 2235376 MA Berkshire   school 2510080 249   Richmond 251008001635 2490005 Richmond: Richmond Consolidated   Regular School No Elementary PK 08 2018   grade_7 13 0 0 0   0     0   0   8 5                       13.0 13 0 0 0   0     0   0   8 5                 13
2232229 2232229 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_7 69 6 50 0   4     0   1   67 63                       130.0 69 6 50 0   4     0   1   67 63                 130
2236606 2236606 MA Worcester   school 2511850 304   Uxbridge 251185001939 3040015 Uxbridge: McCloskey Middle School   Regular School No Middle 06 08 2018   grade_7 117 3 6 0   3     0   1   76 54                       130.0 117 3 6 0   3     0   1   76 54                 130
2232625 2232625 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_7 3 3 124 0   0     0   1   65 66                       131.0 3 3 124 0   0     0   1   65 66                 131
2236399 2236399 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton: Sutton Middle School   Regular School No Middle 06 08 2018   grade_7 118 1 3 0   4     0   5   73 58                       131.0 118 1 3 0   4     0   5   73 58                 131
2239779 2239779 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Whitman-Hanson: Hanson Middle School   Regular School No Middle 06 08 2018   grade_7 125 1 4 0   0     0   1   83 48                       131.0 125 1 4 0   0     0   1   83 48                 131
2229048 2229048 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_7 82 10 25 1   3     0   11   70 62                       132.0 82 10 25 1   3     0   11   70 62                 132
2233847 2233847 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury: Millbury Junior/Senior High   Regular School No High 07 12 2018   grade_7 117 3 9 0   2     0   1   56 76                       132.0 117 3 9 0   2     0   1   56 76                 132
2239199 2239199 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional School District: Monomoy Regional Middle School   Regular School No Middle 05 07 2018   grade_7 110 10 7 0   1     0   4   56 76                       132.0 110 10 7 0   1     0   4   56 76                 132
2239712 2239712 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Wachusett: Central Tree Middle   Regular School No Middle 06 08 2018   grade_7 116 0 3 0   4     0   9   73 59                       132.0 116 0 3 0   4     0   9   73 59                 132
2231060 2231060 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset: Cohasset Middle/High School   Regular School No High 06 12 2018   grade_7 124 3 1 0   4     0   1   65 68                       133.0 124 3 1 0   4     0   1   65 68                 133
2233411 2233411 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Malden: Salemwood   Regular School No Elementary KG 08 2018   grade_7 32 33 45 0   23     0   1   66 68                       134.0 32 33 45 0   23     0   1   66 68                 134
2239054 2239054 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Hamilton-Wenham: Miles River Middle   Regular School No Middle 06 08 2018   grade_7 124 0 4 0   3     1   2   59 75                       134.0 124 0 4 0   3     1   2   59 75                 134
2232546 2232546 MA Essex   school 2506480 144   Ipswich 250648000937 1440305 Ipswich: Ipswich Middle School   Regular School No Middle 06 08 2018   grade_7 115 1 8 0   2     0   9   71 64                       135.0 115 1 8 0   2     0   9   71 64                 135
2230921 2230921 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea: Clark Avenue School   Regular School No Middle 05 08 2018   grade_7 5 7 121 1   1     0   1   78 58                       136.0 5 7 121 1   1     0   1   78 58                 136
2231915 2231915 MA Norfolk   school 2505010 101   Franklin 250501000871 1010310 Franklin: Remington Middle   Regular School No Middle 06 08 2018   grade_7 118 3 5 0   9     0   1   62 74                       136.0 118 3 5 0   9     0   1   62 74                 136
2229043 2229043 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_7 109 2 10 0   5     0   11   69 68                       137.0 109 2 10 0   5     0   11   69 68                 137
2234779 2234779 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford: Oxford Middle   Regular School No Middle 05 07 2018   grade_7 116 2 14 0   3     0   2   70 67                       137.0 116 2 14 0   3     0   2   70 67                 137
2235898 2235898 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley: Michael E. Smith Middle School   Regular School No Middle 05 08 2018   grade_7 109 2 20 0   0     0   6   62 75                       137.0 109 2 20 0   0     0   6   62 75                 137
2230842 2230842 MA Plymouth   school 2503360 52   Carver 250336002662 520405 Carver: Carver Middle/High School   Regular School No High 06 12 2018   grade_7 133 1 2 0   1     0   1   62 76                       138.0 133 1 2 0   1     0   1   62 76                 138
2238671 2238671 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley School District: Ayer Shirley Regional Middle School   Regular School No Middle 06 08 2018   grade_7 109 7 18 1   0     1   2   67 71                       138.0 109 7 18 1   0     1   2   67 71                 138
2236592 2236592 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough: Tyngsborough Middle   Regular School No Middle 06 08 2018   grade_7 116 4 4 0   12     0   3   71 68                       139.0 116 4 4 0   12     0   3   71 68                 139
2236700 2236700 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Walpole: Eleanor N Johnson Middle   Regular School No Middle 06 08 2018   grade_7 120 2 4 0   10     0   3   69 70                       139.0 120 2 4 0   10     0   3   69 70                 139
2240031 2240031 MA Norfolk   school 2500556 3902   TEC Connections Academy Commonwealth Virtual School District 250055602817 39020900 TEC Connections Academy Commonwealth Virtual School District: TEC Connections Academy Commonwealth Virtual School   Regular School No Other KG 12 2018   grade_7 95 11 19 1   6     0   7   62 77                       139.0 95 11 19 1   6     0   7   62 77                 139
2232673 2232673 MA Essex   school 2506660 149   Lawrence 250666002758 1490085 Lawrence: Spark Academy   Regular School No Middle 06 08 2018   grade_7 5 2 129 0   3     0   1   61 79                       140.0 5 2 129 0   3     0   1   61 79                 140
2233557 2233557 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee: Mashpee Middle School   Regular School No Middle 07 08 2018   grade_7 104 10 2 13   4     0   7   58 82                       140.0 104 10 2 13   4     0   7   58 82                 140
2237994 2237994 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public (District): Christa McAuliffe Charter Public School   Regular School Yes Middle 06 08 2018   grade_7 88 2 36 1   10     0   4   75 66                       141.0 88 2 36 1   10     0   4   75 66                 141
2238721 2238721 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Blackstone-Millville: Frederick W. Hartnett Middle School   Regular School No Middle 06 08 2018   grade_7 128 4 4 0   0     0   5   71 70                       141.0 128 4 4 0   0     0   5   71 70                 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]);