enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2230498 2230498 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton: South Middle School   Regular School No Middle 06 08 2018   grade_7 23 89 30 0   6     0   15   86 77                       163.0 23 89 30 0   6     0   15   86 77                 163
2230502 2230502 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton: West Middle School   Regular School No Middle 06 08 2018   grade_7 48 123 36 0   8     0   11   106 120                       226.0 48 123 36 0   8     0   11   106 120                 226
2230506 2230506 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton: Ashfield Middle School   Regular School No Middle 06 08 2018   grade_7 54 83 21 1   3     0   6   93 75                       168.0 54 83 21 1   3     0   6   93 75                 168
2230510 2230510 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton: Joseph F. Plouffe Academy   Regular School No Middle 06 08 2018   grade_7 56 88 71 1   8     0   9   116 117                       233.0 56 88 71 1   8     0   9   116 117                 233
2238035 2238035 MA Suffolk   school 2500071 428   Brooke Charter School (District) 250007101747 4280305 Brooke Charter School (District): Brooke Charter School   Regular School Yes Other KG 10 2018   grade_7 9 99 59 0   3     0   4   88 86                       174.0 9 99 59 0   3     0   4   88 86                 174
2230547 2230547 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline: Edith C Baker   Regular School No Elementary KG 08 2018   grade_7 38 10 4 0   15     0   8   37 38                       75.0 38 10 4 0   15     0   8   37 38                 75
2230557 2230557 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline: Edward Devotion   Regular School No Elementary KG 08 2018   grade_7 43 7 10 0   7     0   11   41 37                       78.0 43 7 10 0   7     0   11   41 37                 78
2230568 2230568 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline: Michael Driscoll   Regular School No Elementary PK 08 2018   grade_7 38 6 3 0   14     0   7   37 31                       68.0 38 6 3 0   14     0   7   37 31                 68
2230579 2230579 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline: Heath   Regular School No Elementary PK 08 2018   grade_7 41 4 4 0   13     0   1   33 30                       63.0 41 4 4 0   13     0   1   33 30                 63
2230589 2230589 MA Norfolk   school 2503150 46   Brookline 250315000420 460030 Brookline: Lawrence   Regular School No Elementary KG 08 2018   grade_7 26 4 2 0   22     0   6   29 31                       60.0 26 4 2 0   22     0   6   29 31                 60
2230599 2230599 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 Brookline: William H Lincoln   Regular School No Elementary KG 08 2018   grade_7 24 6 9 0   7     0   8   23 31                       54.0 24 6 9 0   7     0   8   23 31                 54
2230609 2230609 MA Norfolk   school 2503150 46   Brookline 250315000422 460040 Brookline: Pierce   Regular School No Elementary KG 08 2018   grade_7 49 5 11 0   13     0   6   34 50                       84.0 49 5 11 0   13     0   6   34 50                 84
2230620 2230620 MA Norfolk   school 2503150 46   Brookline 250315000419 460045 Brookline: John D Runkle   Regular School No Elementary PK 08 2018   grade_7 43 1 6 0   12     0   6   29 39                       68.0 43 1 6 0   12     0   6   29 39                 68
2230660 2230660 MA Middlesex   school 2503240 48   Burlington 250324000429 480303 Burlington: Marshall Simonds Middle   Regular School No Middle 06 08 2018   grade_7 194 14 19 0   33     0   12   143 129                       272.0 194 14 19 0   33     0   12   143 129                 272
2230686 2230686 MA Middlesex   school 2503270 49   Cambridge 250327001621 490006 Cambridge: Amigos School   Regular School No Elementary PK 08 2018   grade_7 14 2 16 0   0     0   6   10 28                       38.0 14 2 16 0   0     0   6   10 28                 38
2230770 2230770 MA Middlesex   school 2503270 49   Cambridge 250327002759 490305 Cambridge: Cambridge Street Upper School   Regular School No Middle 06 08 2018   grade_7 32 20 16 0   6     1   5   37 43                       80.0 32 20 16 0   6     1   5   37 43                 80
2230774 2230774 MA Middlesex   school 2503270 49   Cambridge 250327002768 490310 Cambridge: Putnam Avenue Upper School   Regular School No Middle 06 08 2018   grade_7 23 30 17 0   7     0   13   43 47                       90.0 23 30 17 0   7     0   13   43 47                 90
2230778 2230778 MA Middlesex   school 2503270 49   Cambridge 250327002746 490315 Cambridge: Rindge Avenue Upper School   Regular School No Middle 06 08 2018   grade_7 40 28 7 0   7     1   6   42 47                       89.0 40 28 7 0   7     1   6   42 47                 89
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
2230814 2230814 MA Norfolk   school 2503300 50   Canton 250330000456 500305 Canton: Wm H Galvin Middle   Regular School No Middle 06 08 2018   grade_7 174 24 7 0   20     1   13   119 120                       239.0 174 24 7 0   20     1   13   119 120                 239
2238070 2238070 MA Barnstable   school 2500024 432   Cape Cod Lighthouse Charter (District) 250002400516 4320530 Cape Cod Lighthouse Charter (District): Cape Cod Lighthouse Charter School   Regular School Yes Middle 06 08 2018   grade_7 71 2 3 0   1     0   4   37 44                       81.0 71 2 3 0   1     0   4   37 44                 81
2230830 2230830 MA Middlesex   school 2503330 51   Carlisle 250333000457 510025 Carlisle: Carlisle School   Regular School No Elementary PK 08 2018   grade_7 52 1 1 0   15     0   4   35 38                       73.0 52 1 1 0   15     0   4   35 38                 73
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
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
2230877 2230877 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford: Col Moses Parker School   Regular School No Middle 05 08 2018   grade_7 141 3 6 0   26     0   5   94 87                       181.0 141 3 6 0   26     0   5   94 87                 181
2230882 2230882 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_7 153 5 7 0   27     0   7   97 102                       199.0 153 5 7 0   27     0   7   97 102                 199
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
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
2230926 2230926 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea: Joseph A. Browne School   Regular School No Middle 05 08 2018   grade_7 11 5 126 0   2     0   0   75 69                       144.0 11 5 126 0   2     0   0   75 69                 144
2230962 2230962 MA Hampden   school 2503660 61   Chicopee 250366000720 610021 Chicopee: Chicopee Academy   Alternative School No High 06 12 2018   grade_7 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231005 2231005 MA Hampden   school 2503660 61   Chicopee 250366000491 610305 Chicopee: Bellamy Middle   Regular School No Middle 06 08 2018   grade_7 139 9 108 0   2     0   10   144 124                       268.0 139 9 108 0   2     0   10   144 124                 268
2231009 2231009 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Chicopee: Dupont Middle   Regular School No Middle 06 08 2018   grade_7 123 16 98 1   3     0   9   145 105                       250.0 123 16 98 1   3     0   9   145 105                 250
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
2231029 2231029 MA Berkshire   school 2503720 63   Clarksburg 250372000510 630010 Clarksburg: Clarksburg Elementary   Regular School No Elementary KG 08 2018   grade_7 16 0 0 0   0     0   0   7 9                       16.0 16 0 0 0   0     0   0   7 9                 16
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
2238103 2238103 MA Suffolk   school 2500070 438   Codman Academy Charter Public (District) 250007001667 4380505 Codman Academy Charter Public (District): Codman Academy Charter Public School   Regular School Yes Other PK 12 2018   grade_7 0 14 2 0   0     0   0   7 9                       16.0 0 14 2 0   0     0   0   7 9                 16
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
2239946 2239946 MA Middlesex   school 2500545 3503   Collegiate Charter School of Lowell (District) 250054502785 35030205 Collegiate Charter School of Lowell (District): Collegiate Charter School of Lowell   Regular School Yes Elementary KG 07 2018   grade_7 15 11 20 0   16     0   2   32 32                       64.0 15 11 20 0   16     0   2   32 32                 64
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
2238129 2238129 MA Essex   school 2500027 440   Community Day Charter Public School - Prospect (District) 250002700535 4400205 Community Day Charter Public School - Prospect (District): Community Day Charter Public School - Prospect   Regular School Yes Elementary PK 08 2018   grade_7 1 0 18 0   1     0   0   11 9                       20.0 1 0 18 0   1     0   0   11 9                 20
2231092 2231092 MA Middlesex   school 2503840 67   Concord 250384000522 670305 Concord: Concord Middle   Regular School No Middle 06 08 2018   grade_7 204 12 9 0   12     0   12   128 121                       249.0 204 12 9 0   12     0   12   128 121                 249
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
2231141 2231141 MA Essex   school 2503990 71   Danvers 250399002517 710305 Danvers: Holten Richmond Middle School   Regular School No Middle 06 08 2018   grade_7 240 5 20 0   7     0   9   136 145                       281.0 240 5 20 0   7     0   9   136 145                 281
2231174 2231174 MA Bristol   school 2504020 72   Dartmouth 250402000541 720050 Dartmouth: Dartmouth Middle   Regular School No Middle 06 08 2018   grade_7 268 6 12 0   0     0   19   178 127                       305.0 268 6 12 0   0     0   19   178 127                 305
2231210 2231210 MA Norfolk   school 2504050 73   Dedham 250405000551 730305 Dedham: Dedham Middle School   Regular School No Middle 06 08 2018   grade_7 144 19 24 1   5     0   5   95 103                       198.0 144 19 24 1   5     0   5   95 103                 198
2238831 2238831 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000562 6450305 Dennis-Yarmouth: Mattacheese Middle School   Regular School No Middle 05 08 2018   grade_7 156 22 18 5   5     0   11   115 102                       217.0 156 22 18 5   5     0   11   115 102                 217
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
2238859 2238859 MA Bristol   school 2504200 650   Dighton-Rehoboth 250420002430 6500310 Dighton-Rehoboth: Dorothy L Beckwith   Regular School No Middle 05 08 2018   grade_7 135 0 4 0   1     0   6   62 84                       146.0 135 0 4 0   1     0   6   62 84                 146
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
2238869 2238869 MA Norfolk   school 2504290 655   Dover-Sherborn 250429000575 6550405 Dover-Sherborn: Dover-Sherborn Regional Middle School   Regular School No Middle 06 08 2018   grade_7 139 7 5 1   17     0   9   83 95                       178.0 139 7 5 1   17     0   9   83 95                 178
2231283 2231283 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Dracut: Justus C. Richardson Middle School   Regular School No Middle 06 08 2018   grade_7 227 12 25 1   19     0   4   153 135                       288.0 227 12 25 1   19     0   4   153 135                 288
2238895 2238895 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001595 6580305 Dudley-Charlton Reg: Dudley Middle School   Regular School No Middle 05 08 2018   grade_7 128 4 8 0   3     0   4   67 80                       147.0 128 4 8 0   3     0   4   67 80                 147
2238900 2238900 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436001597 6580310 Dudley-Charlton Reg: Charlton Middle School   Regular School No Middle 05 08 2018   grade_7 166 0 10 0   2     1   2   87 94                       181.0 166 0 10 0   2     1   2   87 94                 181
2231301 2231301 MA Plymouth   school 2504410 82   Duxbury 250441000975 820305 Duxbury: Duxbury Middle   Regular School No Middle 06 08 2018   grade_7 234 0 5 0   2     0   9   141 109                       250.0 234 0 5 0   2     0   9   141 109                 250
2231319 2231319 MA Plymouth   school 2504440 83   East Bridgewater 250444000597 830505 East Bridgewater: East Bridgewater JR./SR. High School   Regular School No High 07 12 2018   grade_7 177 6 3 1   3     0   3   92 101                       193.0 177 6 3 1   3     0   3   92 101                 193
2231377 2231377 MA Hampden   school 2504500 87   East Longmeadow 250450000602 870305 East Longmeadow: Birchland Park   Regular School No Middle 06 08 2018   grade_7 183 8 16 0   10     0   4   126 95                       221.0 183 8 16 0   10     0   4   126 95                 221
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
2231405 2231405 MA Bristol   school 2504620 88   Easton 250462000618 880405 Easton: Easton Middle School   Regular School No Middle 06 08 2018   grade_7 264 18 10 0   10     0   3   157 148                       305.0 264 18 10 0   10     0   3   157 148                 305
2231421 2231421 MA Dukes   school 2509090 89   Edgartown 250909001469 890005 Edgartown: Edgartown Elementary   Regular School No Elementary PK 08 2018   grade_7 20 0 7 0   0     0   3   15 15                       30.0 20 0 7 0   0     0   3   15 15                 30
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
2231460 2231460 MA Middlesex   school 2504770 93   Everett 250477002033 930018 Everett: Madeline English School   Regular School No Elementary KG 08 2018   grade_7 20 15 41 0   6     0   3   39 46                       85.0 20 15 41 0   6     0   3   39 46                 85
2231470 2231470 MA Middlesex   school 2504770 93   Everett 250477002038 930028 Everett: George Keverian School   Regular School No Elementary KG 08 2018   grade_7 25 20 43 0   3     0   1   45 47                       92.0 25 20 43 0   3     0   1   45 47                 92
2231476 2231476 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_7 * * * *   *     *   *   3 1                       4.0                         3 1                 4
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
2237938 2237938 MA Suffolk   school 2500075 410   Excel Academy Charter (District) 250007502084 4100205 Excel Academy Charter (District): Excel Academy Charter School   Regular School Yes Middle 05 11 2018   grade_7 26 13 122 5   3     2   0   80 91                       171.0 26 13 122 5   3     2   0   80 91                 171
2231523 2231523 MA Bristol   school 2504800 94   Fairhaven 250480002572 940305 Fairhaven: Hastings Middle   Regular School No Middle 06 08 2018   grade_7 145 3 10 1   4     0   5   83 85                       168.0 145 3 10 1   4     0   5   83 85                 168
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
2231614 2231614 MA Bristol   school 2504830 95   Fall River 250483000655 950305 Fall River: Talbot Innovation School   Regular School No Middle 06 08 2018   grade_7 87 13 55 0   10     0   8   96 77                       173.0 87 13 55 0   10     0   8   96 77                 173
2231618 2231618 MA Bristol   school 2504830 95   Fall River 250483000672 950315 Fall River: Morton Middle   Regular School No Middle 06 08 2018   grade_7 120 16 44 2   13     0   12   112 95                       207.0 120 16 44 2   13     0   12   112 95                 207
2231622 2231622 MA Bristol   school 2504830 95   Fall River 250483000671 950320 Fall River: Matthew J Kuss Middle   Regular School No Middle 06 08 2018   grade_7 157 26 61 0   7     0   16   136 131                       267.0 157 26 61 0   7     0   16   136 131                 267
2231628 2231628 MA Bristol   school 2504830 95   Fall River 250483002852 950340 Fall River: Stone PK-12 School   Regular School No Other 02 12 2018   grade_7 5 0 3 0   0     0   0   7 1                       8.0 5 0 3 0   0     0   0   7 1                 8
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
2231651 2231651 MA Bristol   school 2504830 95   Fall River 250483002873 950525 Fall River: Resiliency Preparatory Academy   Alternative School No High 07 12 2018   grade_7 12 3 3 0   0     0   5   12 11                       23.0 12 3 3 0   0     0   5   12 11                 23
2231686 2231686 MA Barnstable   school 2504860 96   Falmouth 250486000687 960405 Falmouth: Lawrence   Regular School No Middle 07 08 2018   grade_7 257 17 16 1   5     1   15   151 161                       312.0 257 17 16 1   5     1   15   151 161                 312
2231710 2231710 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_7 54 12 95 0   12     0   10   93 90                       183.0 54 12 95 0   12     0   10   93 90                 183
2231722 2231722 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_7 42 12 88 0   8     0   8   88 70                       158.0 42 12 88 0   8     0   8   88 70                 158
2231733 2231733 MA Worcester   school 2504890 97   Fitchburg 250489002775 970340 Fitchburg: McKay Arts Academy   Regular School No Elementary PK 08 2018   grade_7 25 1 33 0   3     0   5   25 42                       67.0 25 1 33 0   3     0   5   25 42                 67
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
2231778 2231778 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_7 177 9 8 2   3     0   5   93 111                       204.0 177 9 8 2   3     0   5   93 111                 204
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
2231850 2231850 MA Middlesex   school 2504980 100   Framingham 250498001530 1000302 Framingham: Cameron Middle School   Regular School No Middle 06 08 2018   grade_7 127 9 22 0   3     0   7   77 91                       168.0 127 9 22 0   3     0   7   77 91                 168
2231854 2231854 MA Middlesex   school 2504980 100   Framingham 250498000464 1000305 Framingham: Fuller Middle   Regular School No Middle 06 08 2018   grade_7 59 20 63 0   5     1   10   80 78                       158.0 59 20 63 0   5     1   10   80 78                 158
2231858 2231858 MA Middlesex   school 2504980 100   Framingham 250498000733 1000310 Framingham: Walsh Middle   Regular School No Middle 06 08 2018   grade_7 135 14 75 0   14     0   5   135 108                       243.0 135 14 75 0   14     0   5   135 108                 243
2238342 2238342 MA Middlesex   school 2500038 478   Francis W. Parker Charter Essential (District) 250003800581 4780505 Francis W. Parker Charter Essential (District): Francis W. Parker Charter Essential School   Regular School Yes High 07 12 2018   grade_7 62 1 2 0   0     0   4   33 36                       69.0 62 1 2 0   0     0   4   33 36                 69
2231911 2231911 MA Norfolk   school 2505010 101   Franklin 250501001785 1010040 Franklin: Annie Sullivan Middle School   Regular School No Middle 06 08 2018   grade_7 149 0 4 0   5     0   1   89 70                       159.0 149 0 4 0   5     0   1   89 70                 159
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
2231919 2231919 MA Norfolk   school 2505010 101   Franklin 250501000738 1010405 Franklin: Horace Mann   Regular School No Middle 06 08 2018   grade_7 129 0 5 0   11     0   6   64 87                       151.0 129 0 5 0   11     0   6   64 87                 151
2238941 2238941 MA Bristol   school 2505070 665   Freetown-Lakeville 250507000748 6650305 Freetown-Lakeville: Freetown-Lakeville Middle School   Regular School No Middle 06 08 2018   grade_7 242 2 3 0   2     0   2   130 121                       251.0 242 2 3 0   2     0   2   130 121                 251
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
2231937 2231937 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   grade_7 97 1 28 0   5     0   15   70 76                       146.0 97 1 28 0   5     0   15   70 76                 146
2238973 2238973 MA Hampshire   school 2505160 672   Gateway 250516002667 6720405 Gateway: Gateway Regional Middle School   Regular School No Middle 06 08 2018   grade_7 62 0 4 1   0     0   0   36 31                       67.0 62 0 4 1   0     0   0   36 31                 67
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
2239023 2239023 MA Franklin   school 2505270 674   Gill-Montague 250527002386 6740310 Gill-Montague: Great Falls Middle   Regular School No Middle 06 08 2018   grade_7 74 4 9 0   0     0   7   56 38                       94.0 74 4 9 0   0     0   7   56 38                 94
2238487 2238487 MA Bristol   school 2500519 496   Global Learning Charter Public (District) 250051902629 4960305 Global Learning Charter Public (District): Global Learning Charter Public School   Regular School Yes High 05 12 2018   grade_7 45 10 29 0   1     0   7   50 42                       92.0 45 10 29 0   1     0   7   50 42                 92
2232006 2232006 MA Essex   school 2505280 107   Gloucester 250528000779 1070305 Gloucester: Ralph B O'Maley Middle   Regular School No Middle 06 08 2018   grade_7 169 5 14 1   4     2   18   123 90                       213.0 169 5 14 1   4     2   18   123 90                 213
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
2232049 2232049 MA Worcester   school 2505370 110   Grafton 250537002520 1100305 Grafton: Grafton Middle   Regular School No Middle 07 08 2018   grade_7 215 6 7 0   24     0   5   117 140                       257.0 215 6 7 0   24     0   5   117 140                 257
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

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