enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 395 ✖

grade ✖

  • grade_7 · 395 ✖
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
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
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
2232067 2232067 MA Hampshire   school 2505400 111   Granby 250540000790 1110505 Granby: Granby Jr Sr High School   Regular School No High 07 12 2018   grade_7 51 0 6 0   0     0   1   39 19                       58.0 51 0 6 0   0     0   1   39 19                 58
2232113 2232113 MA Hampshire   school 2505580 117   Hadley 250558000813 1170505 Hadley: Hopkins Academy   Regular School No High 07 12 2018   grade_7 39 0 3 0   0     5   1   24 24                       48.0 39 0 3 0   0     5   1   24 24                 48
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
2232407 2232407 MA Hampden   school 2506270 137   Holyoke 250627002581 1370045 Holyoke: E N White Elementary   Regular School No Elementary PK 08 2018   grade_7 7 3 31 0   0     0   1   18 24                       42.0 7 3 31 0   0     0   1   18 24                 42
2232417 2232417 MA Hampden   school 2506270 137   Holyoke 250627000907 1370055 Holyoke: Lt Clayre Sullivan Elementary   Regular School No Elementary KG 08 2018   grade_7 8 4 49 0   0     0   1   26 36                       62.0 8 4 49 0   0     0   1   26 36                 62
2232604 2232604 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_7 3 1 143 0   0     0   1   80 68                       148.0 3 1 143 0   0     0   1   80 68                 148
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
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
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
2233080 2233080 MA Middlesex   school 2507020 160   Lowell 250702001954 1600090 Lowell: Bartlett Community Partnership   Regular School No Elementary PK 08 2018   grade_7 8 3 24 0   19     0   1   22 33                       55.0 8 3 24 0   19     0   1   22 33                 55
2233144 2233144 MA Hampden   school 2507050 161   Ludlow 250705001055 1610305 Ludlow: Paul R Baird Middle   Regular School No Middle 06 08 2018   grade_7 187 2 15 2   2     0   1   99 110                       209.0 187 2 15 2   2     0   1   99 110                 209
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
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
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
2235522 2235522 MA Barnstable   school 2510470 261   Sandwich 251047002824 2610305 Sandwich: Sandwich STEM Academy   Regular School No Middle 07 08 2018   grade_7 221 1 1 4   6     0   1   120 114                       234.0 221 1 1 4   6     0   1   120 114                 234
2235782 2235782 MA Middlesex   school 2510890 274   Somerville 251089001738 2740083 Somerville: John F Kennedy   Regular School No Elementary KG 08 2018   grade_7 32 6 6 0   2     0   1   25 22                       47.0 32 6 6 0   2     0   1   25 22                 47
2235803 2235803 MA Middlesex   school 2510890 274   Somerville 251089001736 2740111 Somerville: E Somerville Community   Regular School No Elementary KG 08 2018   grade_7 7 5 51 0   1     0   1   27 38                       65.0 7 5 51 0   1     0   1   27 38                 65
2236189 2236189 MA Hampden   school 2511130 281   Springfield 251113002744 2810360 Springfield: Balliet Middle School   Regular School No Middle 06 08 2018   grade_7 0 2 13 0   0     0   1   10 6                       16.0 0 2 13 0   0     0   1   10 6                 16
2236204 2236204 MA Hampden   school 2511130 281   Springfield 251113002818 2810475 Springfield: Conservatory of the Arts   Regular School No High 06 12 2018   grade_7 5 14 37 0   0     0   1   14 43                       57.0 5 14 37 0   0     0   1   14 43                 57
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
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
2237073 2237073 MA Hampden   school 2512630 325   Westfield 251263001570 3250310 Westfield: South Middle School   Regular School No Middle 06 08 2018   grade_7 141 7 40 0   9     0   1   105 93                       198.0 141 7 40 0   9     0   1   105 93                 198
2237113 2237113 MA Middlesex   school 2512660 326   Westford 251266000170 3260310 Westford: Blanchard Middle   Regular School No Middle 06 08 2018   grade_7 133 2 1 0   56     0   1   103 90                       193.0 133 2 1 0   56     0   1   103 90                 193
2237945 2237945 MA Suffolk   school 2500526 411   Boston Green Academy Horace Mann Charter School (District) 250052602703 4110305 Boston Green Academy Horace Mann Charter School (District): Boston Green Academy Horace Mann Charter School   Regular School Yes High 06 12 2018   grade_7 3 32 24 0   0     0   1   32 28                       60.0 3 32 24 0   0     0   1   32 28                 60
2237961 2237961 MA Franklin   school 2500076 413   Four Rivers Charter Public (District) 250007602086 4130505 Four Rivers Charter Public (District): Four Rivers Charter Public School   Regular School Yes High 07 12 2018   grade_7 33 0 2 0   0     0   1   17 19                       36.0 33 0 2 0   0     0   1   17 19                 36
2238118 2238118 MA Suffolk   school 2500060 439   Conservatory Lab Charter (District) 250006001439 4390050 Conservatory Lab Charter (District): Conservatory Lab Charter School   Regular School Yes Elementary PK 08 2018   grade_7 2 19 11 0   0     0   1   15 18                       33.0 2 19 11 0   0     0   1   15 18                 33
2238193 2238193 MA Norfolk   school 2500030 447   Benjamin Franklin Classical Charter Public (District) 250003000547 4470205 Benjamin Franklin Classical Charter Public (District): Benjamin Franklin Classical Charter Public School   Regular School Yes Elementary KG 08 2018   grade_7 25 1 3 0   15     0   1   25 20                       45.0 25 1 3 0   15     0   1   25 20                 45
2238273 2238273 MA Suffolk   school 2500537 463   KIPP Academy Boston Charter School (District) 250053702716 4630205 KIPP Academy Boston Charter School (District): KIPP Academy Boston Charter School   Regular School Yes Elementary KG 08 2018   grade_7 0 46 26 0   1     0   1   43 31                       74.0 0 46 26 0   1     0   1   43 31                 74
2238357 2238357 MA Suffolk   school 2500533 480   UP Academy Charter School of Boston (District) 250053302713 4800405 UP Academy Charter School of Boston (District): UP Academy Charter School of Boston   Regular School Yes Middle 06 08 2018   grade_7 7 67 82 0   9     0   1   88 78                       166.0 7 67 82 0   9     0   1   88 78                 166
2238390 2238390 MA Suffolk   school 2500063 484   Roxbury Preparatory Charter (District) 250006301453 4840505 Roxbury Preparatory Charter (District): Roxbury Preparatory Charter School   Regular School Yes Middle 05 11 2018   grade_7 5 150 86 0   1     1   1   116 128                       244.0 5 150 86 0   1     1   1   116 128                 244
2238397 2238397 MA Essex   school 2500084 485   Salem Academy Charter (District) 250008401847 4850485 Salem Academy Charter (District): Salem Academy Charter School   Regular School Yes High 06 12 2018   grade_7 36 5 25 0   6     0   1   31 42                       73.0 36 5 25 0   6     0   1   31 42                 73
2238588 2238588 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_7 86 4 1 0   0     0   1   46 46                       92.0 86 4 1 0   0     0   1   46 46                 92
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
2239207 2239207 MA Berkshire   school 2508160 715   Mount Greylock 250816001273 7150505 Mount Greylock: Mt Greylock Regional High   Regular School No High 07 12 2018   grade_7 86 1 2 0   4     0   1   47 47                       94.0 86 1 2 0   4     0   1   47 47                 94
2239300 2239300 MA Worcester   school 2508310 725   Nashoba 250831000947 7250305 Nashoba: Luther Burbank Middle School   Regular School No Middle 06 08 2018   grade_7 60 2 7 0   4     0   1   45 29                       74.0 60 2 7 0   4     0   1   45 29                 74
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
2239505 2239505 MA Plymouth   school 2510830 760   Silver Lake 251083001721 7600405 Silver Lake: Silver Lake Regional Middle School   Regular School No Middle 07 08 2018   grade_7 261 3 4 0   2     0   1   144 127                       271.0 261 3 4 0   2     0   1   144 127                 271
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
2239690 2239690 MA Worcester   school 2511880 775   Wachusett 251188001492 7750040 Wachusett: Paxton Center   Regular School No Elementary KG 08 2018   grade_7 57 1 2 0   1     0   1   37 25                       62.0 57 1 2 0   1     0   1   37 25                 62
2239700 2239700 MA Worcester   school 2511880 775   Wachusett 251188001553 7750045 Wachusett: Thomas Prince   Regular School No Elementary KG 08 2018   grade_7 38 1 2 0   0     0   1   19 23                       42.0 38 1 2 0   0     0   1   19 23                 42
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
2239933 2239933 MA Hampden   school 2500550 3502   Baystate Academy Charter Public School (District) 250055002784 35020405 Baystate Academy Charter Public School (District): Baystate Academy Charter Public School   Regular School Yes Secondary 06 11 2018   grade_7 6 18 55 0   0     0   1   48 32                       80.0 6 18 55 0   0     0   1   48 32                 80
2228765 2228765 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_7 155 7 12 0   2     0   2   85 93                       178.0 155 7 12 0   2     0   2   85 93                 178
2229053 2229053 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_7 101 9 24 0   7     0   2   87 56                       143.0 101 9 24 0   7     0   2   87 56                 143
2229443 2229443 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston: Curley K-8 School   Regular School No Elementary PK 08 2018   grade_7 3 18 54 0   2     0   2   32 47                       79.0 3 18 54 0   2     0   2   32 47                 79
2229544 2229544 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston: Eliot Elementary   Regular School No Elementary PK 08 2018   grade_7 11 2 12 0   2     0   2   16 13                       29.0 11 2 12 0   2     0   2   16 13                 29
2229606 2229606 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston: James Condon Elementary   Regular School No Elementary PK 08 2018   grade_7 9 27 34 0   4     0   2   44 32                       76.0 9 27 34 0   4     0   2   44 32                 76
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
2229778 2229778 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston: Richard J Murphy   Regular School No Elementary PK 08 2018   grade_7 9 22 15 0   36     0   2   46 38                       84.0 9 22 15 0   36     0   2   46 38                 84
2230003 2230003 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_7 0 12 11 0   0     0   2   13 12                       25.0 0 12 11 0   0     0   2   13 12                 25
2230014 2230014 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston: Mildred Avenue K-8   Regular School No Elementary PK 08 2018   grade_7 2 45 28 1   3     0   2   47 34                       81.0 2 45 28 1   3     0   2   47 34                 81
2230056 2230056 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_7 10 24 17 0   6     0   2   34 25                       59.0 10 24 17 0   6     0   2   34 25                 59
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
2230173 2230173 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston: Quincy Upper School   Regular School No High 06 12 2018   grade_7 4 13 18 0   26     0   2   36 27                       63.0 4 13 18 0   26     0   2   36 27                 63
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
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
2231442 2231442 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Everett: Sumner G. Whittier School   Regular School No Elementary KG 08 2018   grade_7 6 8 29 3   3     0   2   27 24                       51.0 6 8 29 3   3     0   2   27 24                 51
2231570 2231570 MA Bristol   school 2504830 95   Fall River 250483002811 950017 Fall River: Henry Lord Community School   Regular School No Elementary PK 08 2018   grade_7 30 8 22 0   2     0   2   36 28                       64.0 30 8 22 0   2     0   2   36 28                 64
2231581 2231581 MA Bristol   school 2504830 95   Fall River 250483000666 950045 Fall River: John J Doran   Regular School No Elementary PK 08 2018   grade_7 25 3 22 0   1     0   2   20 33                       53.0 25 3 22 0   1     0   2   20 33                 53
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
2232999 2232999 MA Middlesex   school 2507020 160   Lowell 250702001038 1600018 Lowell: Pyne Arts   Regular School No Elementary PK 08 2018   grade_7 24 1 20 0   9     0   2   30 26                       56.0 24 1 20 0   9     0   2   30 26                 56
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
2233369 2233369 MA Middlesex   school 2507170 165   Malden 250717001344 1650003 Malden: Beebe   Regular School No Elementary KG 08 2018   grade_7 23 11 10 0   41     0   2   40 47                       87.0 23 11 10 0   41     0   2   40 47                 87
2233459 2233459 MA Essex   school 2507260 168   Marblehead 250726001789 1680300 Marblehead: Marblehead Veterans Middle School   Regular School No Middle 07 08 2018   grade_7 208 11 11 0   4     0   2   115 121                       236.0 208 11 11 0   4     0   2   115 121                 236
2233677 2233677 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway: Medway Middle   Regular School No Middle 05 08 2018   grade_7 158 1 8 1   5     0   2   79 96                       175.0 158 1 8 1   5     0   2   79 96                 175
2234606 2234606 MA Worcester   school 2508760 215   North Brookfield 250876001411 2150505 North Brookfield: North Brookfield High   Regular School No High 07 12 2018   grade_7 41 1 3 0   0     0   2   32 15                       47.0 41 1 3 0   0     0   2   32 15                 47
2234684 2234684 MA Plymouth   school 2509030 219   Norwell 250903001456 2190405 Norwell: Norwell Middle School   Regular School No Middle 06 08 2018   grade_7 170 0 1 0   4     0   2   81 96                       177.0 170 0 1 0   4     0   2   81 96                 177
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
2235317 2235317 MA Suffolk   school 2510050 248   Revere 251005001963 2480014 Revere: Rumney Marsh Academy   Regular School No Middle 06 08 2018   grade_7 94 7 84 1   6     1   2   102 93                       195.0 94 7 84 1   6     1   2   102 93                 195
2235351 2235351 MA Suffolk   school 2510050 248   Revere 251005001976 2480057 Revere: Garfield Middle School   Regular School No Middle 06 08 2018   grade_7 59 6 101 0   13     0   2   93 88                       181.0 59 6 101 0   13     0   2   93 88                 181
2235607 2235607 MA Plymouth   school 2510560 264   Scituate 251056001690 2640305 Scituate: Gates Middle School   Regular School No Middle 06 08 2018   grade_7 205 3 4 0   3     0   2   94 123                       217.0 205 3 4 0   3     0   2   94 123                 217
2235772 2235772 MA Middlesex   school 2510890 274   Somerville 251089001731 2740075 Somerville: Arthur D Healey   Regular School No Elementary PK 08 2018   grade_7 13 7 13 0   5     0   2   21 19                       40.0 13 7 13 0   5     0   2   21 19                 40
2235814 2235814 MA Middlesex   school 2510890 274   Somerville 251089000891 2740115 Somerville: West Somerville Neighborhood   Regular School No Elementary PK 08 2018   grade_7 16 4 10 0   3     0   2   18 17                       35.0 16 4 10 0   3     0   2   18 17                 35
2235880 2235880 MA Worcester   school 2511010 277   Southbridge 251101002865 2770315 Southbridge: Southbridge Middle School   Regular School No Middle 06 08 2018   grade_7 53 3 105 0   4     0   2   87 80                       167.0 53 3 105 0   4     0   2   87 80                 167
2236035 2236035 MA Hampden   school 2511130 281   Springfield 251113001809 2810095 Springfield: Alfred G. Zanetti Montessori Magnet School   Regular School No Elementary PK 08 2018   grade_7 8 8 13 0   0     0   2   14 17                       31.0 8 8 13 0   0     0   2   14 17                 31
2236166 2236166 MA Hampden   school 2511130 281   Springfield 251113002600 2810325 Springfield: Forest Park Middle   Regular School No Middle 06 08 2018   grade_7 8 35 150 1   21     0   2   113 104                       217.0 8 35 150 1   21     0   2   113 104                 217
2236185 2236185 MA Hampden   school 2511130 281   Springfield 251113002733 2810355 Springfield: South End Middle School   Regular School No Middle 06 08 2018   grade_7 1 13 64 0   0     0   2   35 45                       80.0 1 13 64 0   0     0   2   35 45                 80
2236454 2236454 MA Bristol   school 2511460 292   Swansea 251146001894 2920305 Swansea: Joseph Case Jr High   Regular School No Middle 06 08 2018   grade_7 155 1 2 0   0     0   2   82 78                       160.0 155 1 2 0   0     0   2   82 78                 160
2236546 2236546 MA Middlesex   school 2511580 295   Tewksbury 251158000366 2950305 Tewksbury: John W. Wynn Middle   Regular School No Middle 07 08 2018   grade_7 247 7 5 1   7     0   2   143 126                       269.0 247 7 5 1   7     0   2   143 126                 269
2236756 2236756 MA Middlesex   school 2512000 308   Waltham 251200001971 3080404 Waltham: John F Kennedy Middle   Regular School No Middle 06 08 2018   grade_7 86 21 54 0   14     0   2   99 78                       177.0 86 21 54 0   14     0   2   99 78                 177
2237479 2237479 MA Suffolk   school 2513170 346   Winthrop 251317002179 3460305 Winthrop: Winthrop Middle School   Regular School No Middle 06 08 2018   grade_7 130 0 21 0   1     0   2   80 74                       154.0 130 0 21 0   1     0   2   80 74                 154
2237547 2237547 MA Middlesex   school 2513200 347   Woburn 251320002186 3470405 Woburn: John F Kennedy Middle School   Regular School No Middle 06 08 2018   grade_7 112 10 10 3   10     0   2   68 79                       147.0 112 10 10 3   10     0   2   68 79                 147
2237842 2237842 MA Worcester   school 2513230 348   Worcester 251323001076 3480285 Worcester: University Pk Campus School   Regular School No High 07 12 2018   grade_7 4 7 21 0   10     0   2   21 23                       44.0 4 7 21 0   10     0   2   21 23                 44
2237933 2237933 MA Bristol   school 2500525 409   Alma del Mar Charter School (District) 250052502708 4090205 Alma del Mar Charter School (District): Alma del Mar Charter School   Regular School Yes Elementary KG 08 2018   grade_7 12 7 23 0   0     0   2   23 21                       44.0 12 7 23 0   0     0   2   23 21                 44
2237977 2237977 MA Suffolk   school 2500080 416   Boston Preparatory Charter Public (District) 250008001843 4160305 Boston Preparatory Charter Public (District): Boston Preparatory Charter Public School   Regular School Yes High 06 12 2018   grade_7 0 39 9 0   1     1   2   24 28                       52.0 0 39 9 0   1     1   2   24 28                 52
2238083 2238083 MA Middlesex   school 2500086 436   Community Charter School of Cambridge (District) 250008601996 4360305 Community Charter School of Cambridge (District): Community Charter School of Cambridge   Regular School Yes High 06 12 2018   grade_7 3 38 16 1   5     0   2   32 33                       65.0 3 38 16 1   5     0   2   32 33                 65
2238198 2238198 MA Suffolk   school 2500053 449   Boston Collegiate Charter (District) 250005301256 4490305 Boston Collegiate Charter (District): Boston Collegiate Charter School   Regular School Yes High 05 12 2018   grade_7 49 24 22 0   1     0   2   53 45                       98.0 49 24 22 0   1     0   2   53 45                 98
2238227 2238227 MA Hampden   school 2500087 453   Holyoke Community Charter (District) 250008701997 4530005 Holyoke Community Charter (District): Holyoke Community Charter School   Regular School Yes Elementary KG 08 2018   grade_7 3 1 66 0   0     0   2   32 40                       72.0 3 1 66 0   0     0   2   32 40                 72
2238248 2238248 MA Essex   school 2500083 455   Hill View Montessori Charter Public (District) 250008301846 4550050 Hill View Montessori Charter Public (District): Hill View Montessori Charter Public School   Regular School Yes Elementary KG 08 2018   grade_7 21 1 6 0   0     0   2   12 18                       30.0 21 1 6 0   0     0   2   12 18                 30
2238259 2238259 MA Middlesex   school 2500065 456   Lowell Community Charter Public (District) 250006501585 4560050 Lowell Community Charter Public (District): Lowell Community Charter Public School   Regular School Yes Elementary PK 08 2018   grade_7 2 25 36 0   17     0   2   39 43                       82.0 2 25 36 0   17     0   2   39 43                 82
2238289 2238289 MA Dukes   school 2500035 466   Martha's Vineyard Charter (District) 250003500569 4660550 Martha's Vineyard Charter (District): Martha's Vineyard Charter School   Regular School Yes Other KG 12 2018   grade_7 12 2 3 0   0     0   2   10 9                       19.0 12 2 3 0   0     0   2   10 9                 19
2238307 2238307 MA Suffolk   school 2500066 469   MATCH Charter Public School (District) 250006601586 4690505 MATCH Charter Public School (District): MATCH Charter Public School   Regular School Yes Other PK 12 2018   grade_7 0 41 48 0   1     0   2   49 43                       92.0 0 41 48 0   1     0   2   49 43                 92
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
2238349 2238349 MA Hampshire   school 2500044 479   Pioneer Valley Performing Arts Charter Public (District) 250004400816 4790505 Pioneer Valley Performing Arts Charter Public (District): Pioneer Valley Performing Arts Charter Public School   Regular School Yes High 07 12 2018   grade_7 48 5 12 0   1     0   2   18 50                       68.0 48 5 12 0   1     0   2   18 50                 68
2238376 2238376 MA Essex   school 2500062 482   River Valley Charter (District) 250006201446 4820050 River Valley Charter (District): River Valley Charter School   Regular School Yes Elementary KG 08 2018   grade_7 27 1 1 0   0     0   2   11 20                       31.0 27 1 1 0   0     0   2   11 20                 31
2238478 2238478 MA Middlesex   school 2500518 494   Pioneer Charter School of Science (District) 250051802632 4940205 Pioneer Charter School of Science (District): Pioneer Charter School of Science   Regular School Yes Other KG 12 2018   grade_7 15 20 27 2   3     0   2   38 31                       69.0 15 20 27 2   3     0   2   38 31                 69
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

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