enrollments

Data source: Big Local News · About: Big Local

491 rows where grade = "grade_7", state = "MA" and year = 2016 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 491 ✖

grade ✖

  • grade_7 · 491 ✖
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
940344 940344 MA Middlesex   school 2500025 435   Innovation Academy Charter (District) 250002500524 4350305 Innovation Academy Charter School   Regular School Yes 4 05 12 2016   grade_7 80 3 6 0   8     0   3   51 49                       100 80 3 6 0   8     0   3   51 49                 100
940703 940703 MA Bristol   school 2500041 491   Atlantis Charter (District) 250004100601 4910550 Atlantis Charter School   Regular School Yes 4 KG 10 2016   grade_7 87 3 5 0   4     0   1   51 49                       100 87 3 5 0   4     0   1   51 49                 100
940909 940909 MA Berkshire   school 2502530 618   Berkshire Hills 250253002000 6180310 Monument Valley Regional Middle School   Regular School No 2 05 08 2016   grade_7 83 2 7 0   3     2   3   50 50                       100 83 2 7 0   3     2   3   50 50                 100
941395 941395 MA Worcester   school 2508280 720   Narragansett 250828001467 7200305 Narragansett Middle   Regular School No 2 05 08 2016   grade_7 89 1 5 0   1     0   4   51 49                       100 89 1 5 0   1     0   4   51 49                 100
942000 942000 MA Bristol   school 2500552 3509   Argosy Collegiate Charter School (District) 250055202827 35090305 Argosy Collegiate Charter School   Regular School Yes 2 06 07 2016   grade_7 64 12 19 1   1     0   3   58 42                       100 64 12 19 1   1     0   3   58 42                 100
936060 936060 MA Hampden   school 2506990 159   Longmeadow 250699001019 1590017 Glenbrook Middle   Regular School No 2 06 08 2016   grade_7 77 5 5 0   9     0   5   55 46                       101 77 5 5 0   9     0   5   55 46                 101
936421 936421 MA Middlesex   school 2507170 165   Malden 250717001345 1650013 Ferryway   Regular School No 1 KG 08 2016   grade_7 29 24 20 1   22     0   5   68 33                       101 29 24 20 1   22     0   5   68 33                 101
936901 936901 MA Nantucket   school 2508250 197   Nantucket 250825001281 1970010 Cyrus Peirce   Regular School No 2 06 08 2016   grade_7 62 15 18 0   2     1   3   56 45                       101 62 15 18 0   2     1   3   56 45                 101
939470 939470 MA Plymouth   school 2512420 323   West Bridgewater 251242002039 3230505 West Bridgewater Junior/Senior   Regular School No 3 07 12 2016   grade_7 87 2 4 0   4     0   4   48 53                       101 87 2 4 0   4     0   4   48 53                 101
939784 939784 MA Middlesex   school 2513080 343   Winchendon 251308002796 3430315 Murdock Middle School   Regular School No 2 06 08 2016   grade_7 85 1 8 1   2     0   4   48 53                       101 85 1 8 1   2     0   4   48 53                 101
941423 941423 MA Worcester   school 2508310 725   Nashoba 250831001102 7250025 Florence Sawyer School   Regular School No 1 PK 08 2016   grade_7 97 1 1 0   2     0   0   48 53                       101 97 1 1 0   2     0   0   48 53                 101
940582 940582 MA Middlesex   school 2500055 470   Mystic Valley Regional Charter (District) 250005501260 4700105 Mystic Valley Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 60 13 3 0   23     0   3   52 50                       102 60 13 3 0   23     0   3   52 50                 102
938789 938789 MA Hampden   school 2511130 281   Springfield 251113002830 2810365 Chestnut Accelerated Middle School (North)   Regular School No 2 06 08 2016   grade_7 3 8 91 0   1     0   0   62 41                       103 3 8 91 0   1     0   0   62 41                 103
940673 940673 MA Middlesex   school 2500046 487   Prospect Hill Academy Charter (District) 250004600819 4870550 Prospect Hill Academy Charter School   Regular School Yes 4 KG 12 2016   grade_7 9 62 20 0   12     0   1   57 47                       104 9 62 20 0   12     0   1   57 47                 104
934833 934833 MA Middlesex   school 2504770 93   Everett 250477002038 930028 George Keverian School   Regular School No 1 KG 08 2016   grade_7 43 13 35 0   12     0   3   58 48                       106 43 13 35 0   12     0   3   58 48                 106
936449 936449 MA Middlesex   school 2507170 165   Malden 250717001363 1650057 Salemwood   Regular School No 1 KG 08 2016   grade_7 26 25 26 0   23     0   6   53 53                       106 26 25 26 0   23     0   6   53 53                 106
941668 941668 MA Worcester   school 2500002 767   Spencer-E Brookfield 250000200639 7670415 Knox Trail Middle School   Regular School No 2 05 08 2016   grade_7 95 1 8 1   0     0   2   49 58                       107 95 1 8 1   0     0   2   49 58                 107
934738 934738 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 White Brook Middle School   Regular School No 2 05 08 2016   grade_7 91 4 6 0   3     0   4   52 56                       108 91 4 6 0   3     0   4   52 56                 108
936595 936595 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Fowler School   Regular School No 2 04 07 2016   grade_7 94 2 7 0   2     0   3   52 56                       108 94 2 7 0   2     0   3   52 56                 108
938755 938755 MA Hampden   school 2511130 281   Springfield 251113002137 2810205 The Springfield Renaissance School an Expeditionary Learning School   Regular School No 4 06 12 2016   grade_7 24 29 53 1   0     1   0   61 47                       108 24 29 53 1   0     1   0   61 47                 108
941339 941339 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mt Greylock Regional High   Regular School No 3 07 12 2016   grade_7 86 2 7 0   3     0   10   56 52                       108 86 2 7 0   3     0   10   56 52                 108
934968 934968 MA Bristol   school 2504830 95   Fall River 250483002838 950335 Resiliency Middle School   Regular School No 2 07 08 2016   grade_7 3 4 4 0   0     0   0   5 6                       11 3 4 4 0   0     0   0   5 6                 11
934370 934370 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No 2 05 08 2016   grade_7 6 8 93 0   2     0   1   64 46                       110 6 8 93 0   2     0   1   64 46                 110
936830 936830 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis Middle   Regular School No 2 05 08 2016   grade_7 100 0 2 0   5     1   3   74 37                       111 100 0 2 0   5     1   3   74 37                 111
939270 939270 MA Hampshire   school 2512030 309   Ware 251203001983 3090505 Ware Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 90 4 11 0   0     2   4   64 47                       111 90 4 11 0   0     2   4   64 47                 111
940445 940445 MA Norfolk   school 2500052 446   Foxborough Regional Charter (District) 250005201250 4460550 Foxborough Regional Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 40 4 0   14     1   6   60 52                       112 47 40 4 0   14     1   6   60 52                 112
935035 935035 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Arthur M Longsjo Middle School   Regular School No 2 05 08 2016   grade_7 35 8 58 0   3     0   9   58 55                       113 35 8 58 0   3     0   9   58 55                 113
935232 935232 MA Essex   school 2505220 105   Georgetown 250522002764 1050305 Georgetown Middle School   Regular School No 2 07 08 2016   grade_7 111 0 0 0   2     0   1   59 55                       114 111 0 0 0   2     0   1   59 55                 114
940873 940873 MA Worcester   school 2502160 615   Athol-Royalston 250216000176 6150305 Athol-Royalston Middle School   Regular School No 2 05 08 2016   grade_7 99 1 10 0   0     0   4   61 53                       114 99 1 10 0   0     0   4   61 53                 114
936041 936041 MA Middlesex   school 2506960 158   Littleton 250696001628 1580305 Littleton Middle School   Regular School No 2 06 08 2016   grade_7 100 0 3 1   9     0   2   47 68                       115 100 0 3 1   9     0   2   47 68                 115
941120 941120 MA Franklin   school 2505100 670   Frontier 250510000749 6700505 Frontier Regional   Regular School No 3 07 12 2016   grade_7 102 1 5 0   4     0   3   58 57                       115 102 1 5 0   4     0   3   58 57                 115
941647 941647 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301782 7660505 Southwick Regional School   Regular School No 3 07 12 2016   grade_7 103 3 7 0   1     0   2   62 54                       116 103 3 7 0   1     0   2   62 54                 116
933964 933964 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Edgar B Davis   Regular School No 1 KG 08 2016   grade_7 28 70 16 0   0     1   2   58 59                       117 28 70 16 0   0     1   2   58 59                 117
941043 941043 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420000400 6500305 Dighton Middle School   Regular School No 2 05 08 2016   grade_7 108 1 5 0   1     0   2   63 54                       117 108 1 5 0   1     0   2   63 54                 117
932559 932559 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_7 114 2 1 0   1     0   0   54 64                       118 114 2 1 0   1     0   0   54 64                 118
935897 935897 MA Worcester   school 2506720 151   Leicester 250672000973 1510015 Leicester Middle   Regular School No 2 06 08 2016   grade_7 102 2 10 0   3     0   1   68 50                       118 102 2 10 0   3     0   1   68 50                 118
936070 936070 MA Hampden   school 2506990 159   Longmeadow 250699000743 1590305 Williams Middle   Regular School No 2 06 08 2016   grade_7 99 1 5 1   9     0   4   58 61                       119 99 1 5 1   9     0   4   58 61                 119
936235 936235 MA Worcester   school 2507080 162   Lunenburg 250708001060 1620020 Turkey Hill Middle   Regular School No 2 04 07 2016   grade_7 112 1 5 1   0     0   0   69 50                       119 112 1 5 1   0     0   0   69 50                 119
941589 941589 MA Franklin   school 2509900 755   Ralph C Mahar 250990001587 7550505 Ralph C Mahar Regional   Regular School No 3 07 12 2016   grade_7 88 6 14 0   3     0   8   60 59                       119 88 6 14 0   3     0   8   60 59                 119
936373 936373 MA Essex   school 2507110 163   Lynn 250711002647 1630525 Fecteau-Leary Junior/Senior High School   Regular School No 3 07 12 2016   grade_7 8 1 3 0   0     0   0   8 4                       12 8 1 3 0   0     0   0   8 4                 12
935821 935821 MA Essex   school 2506660 149   Lawrence 250666002766 1490090 UP Academy Leonard Middle School   Regular School No 2 06 08 2016   grade_7 1 2 117 0   0     0   0   60 60                       120 1 2 117 0   0     0   0   60 60                 120
938802 938802 MA Hampden   school 2511130 281   Springfield 251113002859 2810480 Van Sickle Academy   Regular School No 2 06 08 2016   grade_7 10 25 84 0   1     0   0   69 51                       120 10 25 84 0   1     0   0   69 51                 120
940320 940320 MA Essex   school 2500082 429   KIPP Academy Lynn Charter (District) 250008201845 4290010 KIPP Academy Lynn Charter School   Regular School Yes 4 05 12 2016   grade_7 10 24 79 0   3     0   4   52 68                       120 10 24 79 0   3     0   4   52 68                 120
940432 940432 MA Worcester   school 2500051 445   Abby Kelley Foster Charter Public (District) 250005101247 4450105 Abby Kelley Foster Charter Public School   Regular School Yes 4 KG 12 2016   grade_7 27 49 34 1   7     0   2   54 66                       120 27 49 34 1   7     0   2   54 66                 120
933652 933652 MA Suffolk   school 2502790 35   Boston 250279000216 350430 Clarence R Edwards Middle   Regular School No 2 06 08 2016   grade_7 16 11 86 0   8     0   0   63 58                       121 16 11 86 0   8     0   0   63 58                 121
941462 941462 MA Middlesex   school 2508790 735   North Middlesex 250879002280 7350030 Hawthorne Brook   Regular School No 2 05 08 2016   grade_7 107 1 4 0   2     0   7   61 60                       121 107 1 4 0   2     0   7   61 60                 121
938962 938962 MA Worcester   school 2511400 290   Sutton 251140001413 2900305 Sutton Middle School   Regular School No 2 06 08 2016   grade_7 111 3 0 0   3     0   6   66 57                       123 111 3 0 0   3     0   6   66 57                 123
935778 935778 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Guilmette Middle School   Regular School No 2 05 08 2016   grade_7 3 3 113 0   4     0   1   62 62                       124 3 3 113 0   4     0   1   62 62                 124
937609 937609 MA Hampden   school 2509300 227   Palmer 250930002595 2270305 Converse Middle   Regular School No 2 05 07 2016   grade_7 115 2 3 0   0     0   5   65 60                       125 115 2 3 0   0     0   5   65 60                 125
935782 935782 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Parthum Middle School   Regular School No 2 05 08 2016   grade_7 9 0 115 0   1     0   1   70 56                       126 9 0 115 0   1     0   1   70 56                 126
934639 934639 MA Worcester   school 2504230 77   Douglas 250423002788 770305 Douglas Middle School   Regular School No 2 06 08 2016   grade_7 119 2 3 0   0     1   2   62 65                       127 119 2 3 0   0     1   2   62 65                 127
940895 940895 MA Middlesex   school 2500542 616   Ayer Shirley School District 250054202737 6160305 Ayer Shirley Regional Middle School   Regular School No 2 06 08 2016   grade_7 94 6 8 2   4     0   13   62 65                       127 94 6 8 2   4     0   13   62 65                 127
940400 940400 MA Hampden   school 2500028 441   Sabis International Charter (District) 250002800537 4410505 Sabis International Charter School   Regular School Yes 4 KG 12 2016   grade_7 47 28 41 0   5     0   7   60 68                       128 47 28 41 0   5     0   7   60 68                 128
935826 935826 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Frost Middle School   Regular School No 2 05 08 2016   grade_7 16 1 104 0   7     0   1   68 61                       129 16 1 104 0   7     0   1   68 61                 129
935439 935439 MA Essex   school 2505970 128   Haverhill 250597000848 1280035 Caleb Dustin Hunking   Regular School No 2 06 08 2016   grade_7 99 5 23 0   3     0   0   70 60                       130 99 5 23 0   3     0   0   70 60                 130
935467 935467 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 John G Whittier   Regular School No 2 05 08 2016   grade_7 97 2 30 0   1     0   0   74 56                       130 97 2 30 0   1     0   0   74 56                 130
938771 938771 MA Hampden   school 2511130 281   Springfield 251113002601 2810328 John F Kennedy Middle   Regular School No 2 06 08 2016   grade_7 12 27 91 0   0     0   0   63 67                       130 12 27 91 0   0     0   0   63 67                 130
941841 941841 MA Plymouth   school 2512930 780   Whitman-Hanson 251293001286 7800315 Hanson Middle School   Regular School No 2 06 08 2016   grade_7 119 3 2 0   2     0   4   72 58                       130 119 3 2 0   2     0   4   72 58                 130
939599 939599 MA Bristol   school 2512780 331   Westport 251278002094 3310305 Westport Junior High School   Regular School No 2 07 08 2016   grade_7 121 1 2 2   2     0   3   76 55                       131 121 1 2 2   2     0   3   76 55                 131
941280 941280 MA Essex   school 2500067 698   Manchester Essex Regional 250006702653 6980030 Manchester Essex Regional Middle School   Regular School No 2 06 08 2016   grade_7 125 0 1 0   4     0   1   62 69                       131 125 0 1 0   4     0   1   62 69                 131
940618 940618 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston   Regular School Yes 2 06 08 2016   grade_7 9 64 50 1   7     0   1   66 66                       132 9 64 50 1   7     0   1   66 66                 132
937944 937944 MA Norfolk   school 2509870 243   Quincy 250987001563 2430310 Broad Meadows Middle   Regular School No 2 06 08 2016   grade_7 89 8 5 1   24     0   6   71 62                       133 89 8 5 1   24     0   6   71 62                 133
941332 941332 MA Barnstable   school 2500544 712   Monomoy Regional School District 250054402832 7120315 Monomoy Regional Middle School   Regular School No 2 05 07 2016   grade_7 116 6 5 1   0     0   6   58 76                       134 116 6 5 1   0     0   6   58 76                 134
934374 934374 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No 2 05 08 2016   grade_7 12 6 111 0   4     0   2   75 60                       135 12 6 111 0   4     0   2   75 60                 135
935761 935761 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Arlington Middle School   Regular School No 2 05 08 2016   grade_7 2 1 132 0   0     0   0   72 63                       135 2 1 132 0   0     0   0   72 63                 135
938805 938805 MA Hampden   school 2511130 281   Springfield 251113002855 2810485 Van Sickle International Baccalaureate   Regular School No 2 06 08 2016   grade_7 16 18 100 0   1     0   0   67 68                       135 16 18 100 0   1     0   0   67 68                 135
940282 940282 MA Middlesex   school 2500068 418   Christa McAuliffe Charter Public (District) 250006801746 4180305 Christa McAuliffe Charter Public School   Regular School Yes 2 06 08 2016   grade_7 89 10 20 1   10     0   5   75 60                       135 89 10 20 1   10     0   5   75 60                 135
935444 935444 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Dr Paul Nettle   Regular School No 2 05 08 2016   grade_7 79 2 53 0   2     0   0   66 70                       136 79 2 53 0   2     0   0   66 70                 136
940937 940937 MA Worcester   school 2502715 622   Blackstone-Millville 250271501082 6220405 Frederick W. Hartnett Middle School   Regular School No 2 06 08 2016   grade_7 120 2 10 0   3     0   1   69 67                       136 120 2 10 0   3     0   1   69 67                 136
933786 933786 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No 4 06 12 2016   grade_7 4 80 46 1   3     0   3   67 70                       137 4 80 46 1   3     0   3   67 70                 137
939120 939120 MA Middlesex   school 2511760 301   Tyngsborough 251176001715 3010305 Tyngsborough Middle   Regular School No 2 06 08 2016   grade_7 121 2 4 1   3     0   6   61 76                       137 121 2 4 1   3     0   6   61 76                 137
936180 936180 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 B.F.Butler Middle School   Regular School No 2 05 08 2016   grade_7 56 8 32 0   41     0   1   66 72                       138 56 8 32 0   41     0   1   66 72                 138
941210 941210 MA Essex   school 2505670 675   Hamilton-Wenham 250567001276 6750310 Miles River Middle   Regular School No 2 06 08 2016   grade_7 123 3 3 0   6     0   3   74 64                       138 123 3 3 0   6     0   3   74 64                 138
941812 941812 MA Worcester   school 2512100 778   Quaboag Regional 251210002794 7780305 Quaboag Regional Middle Innovation School   Regular School No 2 07 08 2016   grade_7 129 0 6 0   0     0   3   68 70                       138 129 0 6 0   0     0   3   68 70                 138
941240 941240 MA Hampshire   school 2505740 683   Hampshire 250574000825 6830505 Hampshire Regional High   Regular School No 3 07 12 2016   grade_7 129 2 5 1   1     0   1   64 75                       139 129 2 5 1   1     0   1   64 75                 139
941785 941785 MA Worcester   school 2511880 775   Wachusett 251188001280 7750310 Central Tree Middle   Regular School No 2 06 08 2016   grade_7 123 5 6 0   3     0   2   74 65                       139 123 5 6 0   3     0   2   74 65                 139
934378 934378 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No 2 05 08 2016   grade_7 6 14 115 1   4     0   0   76 64                       140 6 14 115 1   4     0   0   76 64                 140
936743 936743 MA Essex   school 2507740 181   Methuen 250774001556 1810055 Tenney Grammar School   Regular School No 1 PK 08 2016   grade_7 68 9 50 0   12     0   1   75 65                       140 68 9 50 0   12     0   1   75 65                 140
938536 938536 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 Michael E. Smith Middle School   Regular School No 2 05 08 2016   grade_7 118 3 13 0   1     0   5   69 71                       140 118 3 13 0   1     0   5   69 71                 140
941047 941047 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dorothy L Beckwith   Regular School No 2 05 08 2016   grade_7 127 2 6 0   0     0   5   78 62                       140 127 2 6 0   0     0   5   78 62                 140
932778 932778 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_7 95 9 17 0   6     2   12   79 62                       141 95 9 17 0   6     2   12   79 62                 141
934878 934878 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Hastings Middle   Regular School No 2 06 08 2016   grade_7 126 1 7 2   5     0   1   79 63                       142 126 1 7 2   5     0   1   79 63                 142
936815 936815 MA Worcester   school 2507890 186   Millbury 250789001249 1860505 Millbury Junior/Senior High   Regular School No 3 07 12 2016   grade_7 125 2 8 0   2     0   5   67 75                       142 125 2 8 0   2     0   5   67 75                 142
940327 940327 MA Middlesex   school 2500085 430   Advanced Math and Science Academy Charter (District) 250008501984 4300305 Advanced Math and Science Academy Charter School   Regular School Yes 4 06 12 2016   grade_7 96 2 9 0   31     0   4   68 74                       142 96 2 9 0   31     0   4   68 74                 142
937594 937594 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford Middle   Regular School No 2 05 08 2016   grade_7 127 1 8 0   5     0   2   76 67                       143 127 1 8 0   5     0   2   76 67                 143
939207 939207 MA Norfolk   school 2511970 307   Walpole 251197001965 3070310 Eleanor N Johnson Middle   Regular School No 2 06 08 2016   grade_7 116 8 6 0   10     0   3   67 76                       143 116 8 6 0   10     0   3   67 76                 143
934492 934492 MA Norfolk   school 2503780 65   Cohasset 250378000518 650505 Cohasset Middle/High School   Regular School No 4 06 12 2016   grade_7 134 5 0 0   5     0   0   72 72                       144 134 5 0 0   5     0   0   72 72                 144
936733 936733 MA Essex   school 2507740 181   Methuen 250774002558 1810050 Comprehensive Grammar School   Regular School No 1 PK 08 2016   grade_7 81 4 51 0   7     0   1   69 75                       144 81 4 51 0   7     0   1   69 75                 144
932782 932782 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_7 86 9 30 0   11     0   9   73 72                       145 86 9 30 0   11     0   9   73 72                 145
933752 933752 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No 3 07 12 2016   grade_7 30 39 48 2   24     0   3   71 75                       146 30 39 48 2   24     0   3   71 75                 146
933783 933783 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Mario Umana Academy   Regular School No 1 KG 08 2016   grade_7 15 7 116 0   6     0   2   77 69                       146 15 7 116 0   6     0   2   77 69                 146
933659 933659 MA Suffolk   school 2502790 35   Boston 250279000258 350485 James P Timilty Middle   Regular School No 2 06 08 2016   grade_7 1 45 100 0   0     0   2   86 62                       148 1 45 100 0   0     0   2   86 62                 148
941471 941471 MA Middlesex   school 2508790 735   North Middlesex 250879001762 7350310 Nissitissit Middle School   Regular School No 2 05 08 2016   grade_7 133 2 3 1   2     0   7   73 75                       148 133 2 3 1   2     0   7   73 75                 148
936569 936569 MA Barnstable   school 2507440 172   Mashpee 250744002638 1720020 Mashpee Middle School   Regular School No 2 07 08 2016   grade_7 123 7 6 8   3     0   2   69 80                       149 123 7 6 8   3     0   2   69 80                 149
936723 936723 MA Essex   school 2507740 181   Methuen 250774001211 1810030 Marsh Grammar School   Regular School No 1 PK 08 2016   grade_7 113 4 27 0   3     0   2   74 75                       149 113 4 27 0   3     0   2   74 75                 149
933050 933050 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Lyon K-8   Regular School No 1 KG 08 2016   grade_7 9 1 3 0   1     0   1   8 7                       15 9 1 3 0   1     0   1   8 7                 15
935145 935145 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Fuller Middle   Regular School No 2 06 08 2016   grade_7 74 10 58 0   4     0   4   84 66                       150 74 10 58 0   4     0   4   84 66                 150
934019 934019 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Ashfield Middle School   Regular School No 2 06 08 2016   grade_7 67 64 11 0   1     0   8   73 78                       151 67 64 11 0   1     0   8   73 78                 151
934477 934477 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton Middle School   Regular School No 2 04 08 2016   grade_7 102 15 29 0   2     0   3   79 72                       151 102 15 29 0   2     0   3   79 72                 151
936753 936753 MA Essex   school 2507740 181   Methuen 250774001376 1810060 Donald P Timony Grammar   Regular School No 1 PK 08 2016   grade_7 71 6 67 1   3     0   3   86 65                       151 71 6 67 1   3     0   3   86 65                 151

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