enrollments

Data source: Big Local News · About: Big Local

575 rows where grade = "grade_6", state = "MA" and year = 2018 sorted by ccd_school_low_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 575 ✖

grade ✖

  • grade_6 · 575 ✖
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
2230209 2230209 MA Suffolk   school   35   Boston   350652               2018   grade_6 * * * *   *     *   *   * *                       0.0                                             0
2229941 2229941 MA Suffolk   school 2502790 35   Boston 250279000342 350363 Boston: William McKinley   Regular School No Other 01 12 2018   grade_6 1 5 12 0   0     0   0   15 3                       18.0 1 5 12 0   0     0   0   15 3                 18
2230002 2230002 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston: Higginson/Lewis K-8   Regular School No Elementary 01 08 2018   grade_6 0 20 21 0   0     0   4   22 23                       45.0 0 20 21 0   0     0   4   22 23                 45
2231475 2231475 MA Middlesex   school 2504770 93   Everett 250477002787 930030 Everett: Devens School   Regular School No Other 01 12 2018   grade_6 * * * *   *     *   *   2 1                       3.0                         2 1                 3
2231497 2231497 MA Middlesex   school 2504770 93   Everett 250477001521 930058 Everett: Parlin School   Regular School No Elementary 01 08 2018   grade_6 15 23 72 0   3     0   0   54 59                       113.0 15 23 72 0   3     0   0   54 59                 113
2232699 2232699 MA Essex   school 2506660 149   Lawrence 250666002625 1490537 Lawrence: School for Exceptional Studies   Regular School No Other 01 12 2018   grade_6 2 0 9 0   0     0   0   9 2                       11.0 2 0 9 0   0     0   0   9 2                 11
2230055 2230055 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston: Dr. William Henderson Upper   Regular School No Other 02 12 2018   grade_6 10 33 11 0   5     0   3   32 30                       62.0 10 33 11 0   5     0   3   32 30                 62
2230482 2230482 MA Plymouth   school 2503090 44   Brockton 250309002544 440400 Brockton: Huntington Therapeutic Day School   Alternative School No Other 02 12 2018   grade_6 2 3 0 0   0     0   1   5 1                       6.0 2 3 0 0   0     0   1   5 1                 6
2232041 2232041 MA Worcester   school 2505370 110   Grafton 250537002754 1100030 Grafton: North Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 89 1 6 2   7     2   3   63 47                       110.0 89 1 6 2   7     2   3   63 47                 110
2232047 2232047 MA Worcester   school 2505370 110   Grafton 250537002576 1100200 Grafton: Millbury Street Elementary School   Regular School No Elementary 02 06 2018   grade_6 93 3 8 0   22     0   3   67 62                       129.0 93 3 8 0   22     0   3   67 62                 129
2239469 2239469 MA Worcester   school 2500001 753   Quabbin 250000102402 7530025 Quabbin: Oakham Center   Regular School No Elementary 02 06 2018   grade_6 26 0 0 0   0     0   0   13 13                       26.0 26 0 0 0   0     0   0   13 13                 26
2229813 2229813 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston: William H Ohrenberger   Regular School No Middle 03 08 2018   grade_6 30 31 57 0   2     0   6   65 61                       126.0 30 31 57 0   2     0   6   65 61                 126
2230310 2230310 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford: Spofford Pond   Regular School No Elementary 03 06 2018   grade_6 98 0 3 0   4     0   1   42 64                       106.0 98 0 3 0   4     0   1   42 64                 106
2231317 2231317 MA Plymouth   school 2504440 83   East Bridgewater 250444000976 830010 East Bridgewater: Gordon W Mitchell   Regular School No Elementary 03 06 2018   grade_6 159 4 7 1   1     0   5   99 78                       177.0 159 4 7 1   1     0   5   99 78                 177
2232264 2232264 MA Essex   school 2505970 128   Haverhill 250597000850 1280100 Haverhill: Consentino Middle School   Regular School No Middle 03 08 2018   grade_6 114 11 89 1   2     0   1   115 103                       218.0 114 11 89 1   2     0   1   115 103                 218
2232561 2232561 MA Plymouth   school 2506540 145   Kingston 250654001531 1450020 Kingston: Kingston Intermediate   Regular School No Elementary 03 06 2018   grade_6 125 2 3 1   1     0   2   66 68                       134.0 125 2 3 1   1     0   2   66 68                 134
2232598 2232598 MA Essex   school 2506660 149   Lawrence 250666000950 1490015 Lawrence: Alexander B Bruce   Regular School No Middle 03 08 2018   grade_6 4 1 73 0   2     0   0   39 41                       80.0 4 1 73 0   2     0   0   39 41                 80
2233563 2233563 MA Barnstable   school 2507440 172   Mashpee 250744001546 1720035 Mashpee: Quashnet School   Regular School No Elementary 03 06 2018   grade_6 82 3 3 7   1     0   6   59 43                       102.0 82 3 3 7   1     0   6   59 43                 102
2233812 2233812 MA Essex   school 2507830 184   Middleton 250783001236 1840005 Middleton: Howe-Manning   Regular School No Elementary 03 06 2018   grade_6 92 1 2 0   6     0   5   55 51                       106.0 92 1 2 0   6     0   5   55 51                 106
2234376 2234376 MA Norfolk   school 2508640 208   Norfolk 250864001384 2080005 Norfolk: Freeman-Kennedy School   Regular School No Elementary 03 06 2018   grade_6 110 2 3 0   0     0   6   70 51                       121.0 110 2 3 0   0     0   6   70 51                 121
2234749 2234749 MA Franklin   school 2509180 223   Orange 250918001475 2230010 Orange: Dexter Park   Regular School No Elementary 03 06 2018   grade_6 66 0 5 0   1     0   1   44 29                       73.0 66 0 5 0   1     0   1   44 29                 73
2235520 2235520 MA Barnstable   school 2510470 261   Sandwich 251047002535 2610025 Sandwich: Oak Ridge   Regular School No Elementary 03 06 2018   grade_6 216 0 4 0   2     0   1   102 121                       223.0 216 0 4 0   2     0   1   102 121                 223
2237166 2237166 MA Bristol   school 2512780 331   Westport 251278002092 3310030 Westport: Westport Elementary   Regular School No Elementary 03 06 2018   grade_6 138 0 8 0   0     0   7   79 74                       153.0 138 0 8 0   0     0   7   79 74                 153
2239382 2239382 MA Essex   school 2509450 745   Pentucket 250945000406 7450010 Pentucket: Helen R Donaghue School   Regular School No Elementary 03 06 2018   grade_6 66 0 5 0   1     0   0   33 39                       72.0 66 0 5 0   1     0   0   33 39                 72
2239550 2239550 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001302845 7660315 Southwick-Tolland-Granville Regional School District: Powder Mill School   Regular School No Elementary 03 06 2018   grade_6 93 2 6 0   0     0   4   54 51                       105.0 93 2 6 0   0     0   4   54 51                 105
2229160 2229160 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown: Chestnut Hill Community School   Regular School No Middle 04 06 2018   grade_6 164 3 12 0   3     1   4   75 112                       187.0 164 3 12 0   3     1   4   75 112                 187
2229188 2229188 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham: Bellingham Memorial School   Regular School No Middle 04 07 2018   grade_6 162 3 9 1   8     0   6   106 83                       189.0 162 3 9 1   8     0   6   106 83                 189
2231040 2231040 MA Worcester   school 2503750 64   Clinton 250375000512 640305 Clinton: Clinton Middle School   Regular School No Middle 04 08 2018   grade_6 91 2 38 0   2     0   0   69 64                       133.0 91 2 38 0   2     0   0   69 64                 133
2232059 2232059 MA Hampshire   school 2505400 111   Granby 250540000789 1110004 Granby: East Meadow   Regular School No Middle 04 06 2018   grade_6 52 0 3 0   1     0   1   28 29                       57.0 52 0 3 0   1     0   1   28 29                 57
2232384 2232384 MA Hampden   school 2506270 137   Holyoke 250627002645 1370030 Holyoke: William R. Peck School   Regular School No Middle 04 08 2018   grade_6 2 5 49 0   0     0   2   41 17                       58.0 2 5 49 0   0     0   2   41 17                 58
2232904 2232904 MA Middlesex   school 2506900 157   Lincoln 250690001008 1570305 Lincoln: Hanscom Middle   Regular School No Middle 04 08 2018   grade_6 28 3 12 0   2     0   6   31 20                       51.0 28 3 12 0   2     0   6   31 20                 51
2233451 2233451 MA Essex   school 2507260 168   Marblehead 250726001788 1680016 Marblehead: Village School   Regular School No Middle 04 06 2018   grade_6 177 10 17 2   2     0   7   110 105                       215.0 177 10 17 2   2     0   7   110 105                 215
2233578 2233578 MA Plymouth   school 2507470 173   Mattapoisett 250747001149 1730010 Mattapoisett: Old Hammondtown   Regular School No Middle 04 06 2018   grade_6 66 2 1 0   1     0   4   36 38                       74.0 66 2 1 0   1     0   4   36 38                 74
2233588 2233588 MA Middlesex   school 2507500 174   Maynard 250750000105 1740305 Maynard: Fowler School   Regular School No Middle 04 08 2018   grade_6 77 2 9 0   2     0   6   45 51                       96.0 77 2 9 0   2     0   6   45 51                 96
2233845 2233845 MA Worcester   school 2507890 186   Millbury 250789001251 1860025 Millbury: Raymond E. Shaw Elementary   Regular School No Middle 04 06 2018   grade_6 115 3 14 0   6     0   6   72 72                       144.0 115 3 14 0   6     0   6   72 72                 144
2235001 2235001 MA Norfolk   school 2509690 238   Plainville 250969001538 2380005 Plainville: Beatrice H Wood Elementary   Regular School No Middle 04 06 2018   grade_6 91 2 9 1   5     0   0   51 57                       108.0 91 2 9 1   5     0   0   51 57                 108
2236567 2236567 MA Essex   school 2511670 298   Topsfield 251167001928 2980005 Topsfield: Proctor Elementary   Regular School No Middle 04 06 2018   grade_6 72 1 1 0   2     0   0   34 42                       76.0 72 1 1 0   2     0   0   34 42                 76
2236776 2236776 MA Hampshire   school 2512030 309   Ware 251203002538 3090305 Ware: Ware Middle School   Regular School No Middle 04 06 2018   grade_6 99 3 6 0   0     1   6   51 64                       115.0 99 3 6 0   0     1   6   51 64                 115
2236973 2236973 MA Worcester   school 2512600 321   Westborough 251260001734 3210045 Westborough: Mill Pond School   Regular School No Middle 04 06 2018   grade_6 182 4 21 0   91     1   10   154 155                       309.0 182 4 21 0   91     1   10   154 155                 309
2237008 2237008 MA Plymouth   school 2512420 323   West Bridgewater 251242002036 3230305 West Bridgewater: Howard School   Regular School No Middle 04 06 2018   grade_6 76 6 4 1   1     0   5   45 48                       93.0 76 6 4 1   1     0   5   45 48                 93
2237911 2237911 MA Norfolk   school 2513290 350   Wrentham 251329002254 3500010 Wrentham: Charles E Roderick   Regular School No Middle 04 06 2018   grade_6 134 2 9 0   6     0   5   85 71                       156.0 134 2 9 0   6     0   5   85 71                 156
2238278 2238278 MA Essex   school 2500034 464   Marblehead Community Charter Public (District) 250003400567 4640305 Marblehead Community Charter Public (District): Marblehead Community Charter Public School   Regular School Yes Middle 04 08 2018   grade_6 42 4 0 0   2     0   3   30 21                       51.0 42 4 0 0   2     0   3   30 21                 51
2238587 2238587 MA Berkshire   school 2501780 603   Adams-Cheshire 250178002879 6030315 Adams-Cheshire: Hoosac Valley Middle School   Regular School No Middle 04 07 2018   grade_6 87 2 2 1   0     0   0   43 49                       92.0 87 2 2 1   0     0   0   43 49                 92
2238744 2238744 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002657 6250300 Bridgewater-Raynham: Williams Intermediate School   Regular School No Middle 04 06 2018   grade_6 215 16 0 0   1     0   16   146 102                       248.0 215 16 0 0   1     0   16   146 102                 248
2228764 2228764 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington: Abington Middle School   Regular School No Middle 05 08 2018   grade_6 173 2 10 0   3     0   0   106 82                       188.0 173 2 10 0   3     0   0   106 82                 188
2228781 2228781 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet: Albert F Ford Middle School   Regular School No Middle 05 08 2018   grade_6 109 2 2 0   0     0   1   62 52                       114.0 109 2 2 0   0     0   1   62 52                 114
2228812 2228812 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam: Roberta G. Doering School   Regular School No Middle 05 08 2018   grade_6 249 9 18 0   14     0   10   169 131                       300.0 249 9 18 0   14     0   10   169 131                 300
2228837 2228837 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury: Amesbury Middle   Regular School No Middle 05 08 2018   grade_6 145 4 14 0   0     1   3   77 90                       167.0 145 4 14 0   0     1   3   77 90                 167
2229042 2229042 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro: Robert J. Coelho Middle School   Regular School No Middle 05 08 2018   grade_6 121 5 22 0   8     0   11   82 85                       167.0 121 5 22 0   8     0   11   82 85                 167
2229047 2229047 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro: Cyril K. Brennan Middle School   Regular School No Middle 05 08 2018   grade_6 93 5 29 1   9     0   7   69 75                       144.0 93 5 29 1   9     0   7   69 75                 144
2229052 2229052 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro: Wamsutta Middle School   Regular School No Middle 05 08 2018   grade_6 104 6 27 0   7     0   11   80 75                       155.0 104 6 27 0   7     0   11   80 75                 155
2229229 2229229 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont: Winthrop L Chenery Middle   Regular School No Middle 05 08 2018   grade_6 246 13 24 1   52     0   25   178 183                       361.0 246 13 24 1   52     0   25   178 183                 361
2229246 2229246 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley: Berkley Middle School   Regular School No Middle 05 08 2018   grade_6 86 1 3 0   0     0   1   46 45                       91.0 86 1 3 0   0     0   1   46 45                 91
2230293 2230293 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne: Bourne Middle School   Regular School No Middle 05 08 2018   grade_6 156 2 10 1   1     0   3   86 87                       173.0 156 2 10 1   1     0   3   86 87                 173
2230876 2230876 MA Middlesex   school 2503510 56   Chelmsford 250351000476 560305 Chelmsford: Col Moses Parker School   Regular School No Middle 05 08 2018   grade_6 125 4 14 0   30     0   3   84 92                       176.0 125 4 14 0   30     0   3   84 92                 176
2230881 2230881 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 Chelmsford: McCarthy Middle School   Regular School No Middle 05 08 2018   grade_6 163 11 14 0   31     1   4   119 105                       224.0 163 11 14 0   31     1   4   119 105                 224
2230915 2230915 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Chelsea: Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2018   grade_6 14 10 123 0   0     0   2   84 65                       149.0 14 10 123 0   0     0   2   84 65                 149
2230920 2230920 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Chelsea: Clark Avenue School   Regular School No Middle 05 08 2018   grade_6 10 3 132 1   1     0   0   76 71                       147.0 10 3 132 1   1     0   0   76 71                 147
2230925 2230925 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Chelsea: Joseph A. Browne School   Regular School No Middle 05 08 2018   grade_6 11 8 144 0   2     0   1   80 86                       166.0 11 8 144 0   2     0   1   80 86                 166
2231354 2231354 MA Hampshire   school 2504590 86   Easthampton 250459000616 860305 Easthampton: White Brook Middle School   Regular School No Middle 05 08 2018   grade_6 86 0 10 0   6     0   2   46 58                       104.0 86 0 10 0   6     0   2   46 58                 104
2231684 2231684 MA Barnstable   school 2504860 96   Falmouth 250486000688 960305 Falmouth: Morse Pond School   Regular School No Middle 05 06 2018   grade_6 221 20 17 2   2     1   15   139 139                       278.0 221 20 17 2   2     1   15   139 139                 278
2231709 2231709 MA Worcester   school 2504890 97   Fitchburg 250489001523 970048 Fitchburg: Memorial Intermediate   Regular School No Middle 05 08 2018   grade_6 58 8 97 0   14     0   10   90 97                       187.0 58 8 97 0   14     0   10   90 97                 187
2231721 2231721 MA Worcester   school 2504890 97   Fitchburg 250489002672 970315 Fitchburg: Arthur M Longsjo Middle School   Regular School No Middle 05 08 2018   grade_6 44 11 94 0   7     0   14   96 74                       170.0 44 11 94 0   7     0   14   96 74                 170
2231777 2231777 MA Norfolk   school 2504950 99   Foxborough 250495000709 990405 Foxborough: John J Ahern   Regular School No Middle 05 08 2018   grade_6 175 15 12 0   3     0   3   111 97                       208.0 175 15 12 0   3     0   3   111 97                 208
2231936 2231936 MA Worcester   school 2505130 103   Gardner 250513002431 1030405 Gardner: Gardner Middle School   Regular School No Middle 05 07 2018   grade_6 136 7 30 0   2     0   14   94 95                       189.0 136 7 30 0   2     0   14   94 95                 189
2232095 2232095 MA Franklin   school 2505490 114   Greenfield 250549000800 1140305 Greenfield: Greenfield Middle   Regular School No Middle 05 07 2018   grade_6 94 2 21 0   4     0   10   69 62                       131.0 94 2 21 0   4     0   10   69 62                 131
2232150 2232150 MA Plymouth   school 2505790 122   Hanover 250579002548 1220305 Hanover: Hanover Middle   Regular School No Middle 05 08 2018   grade_6 210 1 5 0   6     0   1   124 99                       223.0 210 1 5 0   6     0   1   124 99                 223
2232228 2232228 MA Essex   school 2505970 128   Haverhill 250597000852 1280050 Haverhill: Dr Paul Nettle   Regular School No Middle 05 08 2018   grade_6 62 5 56 0   4     1   1   63 66                       129.0 62 5 56 0   4     1   1   63 66                 129
2232257 2232257 MA Essex   school 2505970 128   Haverhill 250597000857 1280085 Haverhill: John G Whittier   Regular School No Middle 05 08 2018   grade_6 83 6 32 1   3     0   1   69 57                       126.0 83 6 32 1   3     0   1   69 57                 126
2232503 2232503 MA Middlesex   school 2506390 141   Hudson 250639000927 1410410 Hudson: David J. Quinn Middle School   Regular School No Middle 05 07 2018   grade_6 178 0 23 0   7     0   2   97 113                       210.0 178 0 23 0   7     0   2   97 113                 210
2232603 2232603 MA Essex   school 2506660 149   Lawrence 250666001945 1490017 Lawrence: Arlington Middle School   Regular School No Middle 05 08 2018   grade_6 2 1 146 0   0     0   0   74 75                       149.0 2 1 146 0   0     0   0   74 75                 149
2232624 2232624 MA Essex   school 2506660 149   Lawrence 250666002630 1490025 Lawrence: Guilmette Middle School   Regular School No Middle 05 08 2018   grade_6 2 4 111 0   1     0   0   56 62                       118.0 2 4 111 0   1     0   0   56 62                 118
2232629 2232629 MA Essex   school 2506660 149   Lawrence 250666002623 1490027 Lawrence: Parthum Middle School   Regular School No Middle 05 08 2018   grade_6 7 0 115 0   0     0   2   55 69                       124.0 7 0 115 0   0     0   2   55 69                 124
2232686 2232686 MA Essex   school 2506660 149   Lawrence 250666002654 1490525 Lawrence: Frost Middle School   Regular School No Middle 05 08 2018   grade_6 13 3 100 0   7     0   0   61 62                       123.0 13 3 100 0   7     0   0   61 62                 123
2233084 2233084 MA Middlesex   school 2507020 160   Lowell 250702001026 1600310 Lowell: B.F. Butler Middle School   Regular School No Middle 05 08 2018   grade_6 33 13 52 0   32     0   7   61 76                       137.0 33 13 52 0   32     0   7   61 76                 137
2233089 2233089 MA Middlesex   school 2507020 160   Lowell 250702001036 1600315 Lowell: James S Daley Middle School   Regular School No Middle 05 08 2018   grade_6 55 6 36 0   81     0   8   97 89                       186.0 55 6 36 0   81     0   8   97 89                 186
2233099 2233099 MA Middlesex   school 2507020 160   Lowell 250702001034 1600330 Lowell: Henry J Robinson Middle   Regular School No Middle 05 08 2018   grade_6 43 14 73 0   23     0   8   74 87                       161.0 43 14 73 0   23     0   8   74 87                 161
2233104 2233104 MA Middlesex   school 2507020 160   Lowell 250702000073 1600340 Lowell: James Sullivan Middle School   Regular School No Middle 05 08 2018   grade_6 56 16 67 0   27     0   4   94 76                       170.0 56 16 67 0   27     0   4   94 76                 170
2233109 2233109 MA Middlesex   school 2507020 160   Lowell 250702000086 1600345 Lowell: Dr An Wang School   Regular School No Middle 05 08 2018   grade_6 64 12 78 0   36     0   7   86 111                       197.0 64 12 78 0   36     0   7   86 111                 197
2233114 2233114 MA Middlesex   school 2507020 160   Lowell 250702001955 1600360 Lowell: Kathryn P. Stoklosa Middle School   Regular School No Middle 05 08 2018   grade_6 21 6 50 0   94     0   4   86 89                       175.0 21 6 50 0   94     0   4   86 89                 175
2233353 2233353 MA Essex   school 2507140 164   Lynnfield 250714001091 1640405 Lynnfield: Lynnfield Middle School   Regular School No Middle 05 08 2018   grade_6 153 3 8 0   7     0   4   89 86                       175.0 153 3 8 0   7     0   4   89 86                 175
2233497 2233497 MA Middlesex   school 2507320 170   Marlborough 250732002639 1700045 Marlborough: 1 LT Charles W. Whitcomb School   Regular School No Middle 05 08 2018   grade_6 114 6 152 0   4     0   14   137 153                       290.0 114 6 152 0   4     0   14   137 153                 290
2233676 2233676 MA Norfolk   school 2507590 177   Medway 250759002483 1770305 Medway: Medway Middle   Regular School No Middle 05 08 2018   grade_6 149 3 6 0   2     0   4   80 84                       164.0 149 3 6 0   2     0   4   80 84                 164
2233862 2233862 MA Norfolk   school 2507920 187   Millis 250792001254 1870020 Millis: Millis Middle   Regular School No Middle 05 08 2018   grade_6 81 1 12 0   5     0   6   58 47                       105.0 81 1 12 0   5     0   6   58 47                 105
2233919 2233919 MA Hampden   school 2508040 191   Monson 250804001655 1910310 Monson: Granite Valley Middle   Regular School No Middle 05 08 2018   grade_6 53 1 5 0   2     2   2   31 34                       65.0 53 1 5 0   2     2   2   31 34                 65
2233986 2233986 MA Middlesex   school 2508340 198   Natick 250834001297 1980305 Natick: J F Kennedy Middle School   Regular School No Middle 05 08 2018   grade_6 126 4 5 1   22     0   4   77 85                       162.0 126 4 5 1   22     0   4   77 85                 162
2233991 2233991 MA Middlesex   school 2508340 198   Natick 250834001305 1980310 Natick: Wilson Middle   Regular School No Middle 05 08 2018   grade_6 200 6 9 0   14     0   14   128 115                       243.0 200 6 9 0   14     0   14   128 115                 243
2234588 2234588 MA Worcester   school 2508940 214   Northbridge 250894002591 2140305 Northbridge: Northbridge Middle   Regular School No Middle 05 08 2018   grade_6 160 3 10 0   1     1   5   86 94                       180.0 160 3 10 0   1     1   5   86 94                 180
2234778 2234778 MA Worcester   school 2509270 226   Oxford 250927001483 2260405 Oxford: Oxford Middle   Regular School No Middle 05 07 2018   grade_6 121 3 12 0   2     0   8   79 67                       146.0 121 3 12 0   2     0   8   79 67                 146
2235194 2235194 MA Norfolk   school 2509870 243   Quincy 250987001581 2430320 Quincy: Reay E Sterling Middle   Regular School No Middle 05 08 2018   grade_6 33 12 12 1   24     1   6   49 40                       89.0 33 12 12 1   24     1   6   49 40                 89
2235199 2235199 MA Norfolk   school 2509870 243   Quincy 250987001381 2430325 Quincy: Point Webster Middle   Regular School No Middle 05 08 2018   grade_6 26 9 8 0   32     1   3   46 33                       79.0 26 9 8 0   32     1   3   46 33                 79
2235407 2235407 MA Plymouth   school 2510170 251   Rockland 251017001642 2510305 Rockland: John W Rogers Middle   Regular School No Middle 05 08 2018   grade_6 113 12 22 0   3     0   4   68 86                       154.0 113 12 22 0   3     0   4   68 86                 154
2235712 2235712 MA Worcester   school 2510770 271   Shrewsbury 251077001716 2710305 Shrewsbury: Sherwood Middle School   Regular School No Middle 05 06 2018   grade_6 291 15 35 1   143     0   18   263 240                       503.0 291 15 35 1   143     0   18   263 240                 503
2235897 2235897 MA Hampshire   school 2510920 278   South Hadley 251092001752 2780305 South Hadley: Michael E. Smith Middle School   Regular School No Middle 05 08 2018   grade_6 120 1 17 0   4     0   4   77 69                       146.0 120 1 17 0   4     0   4   77 69                 146
2236282 2236282 MA Middlesex   school 2511220 284   Stoneham 251122001857 2840405 Stoneham: Stoneham Central Middle School   Regular School No Middle 05 08 2018   grade_6 135 5 15 0   9     0   6   84 86                       170.0 135 5 15 0   9     0   6   84 86                 170
2236427 2236427 MA Essex   school 2511430 291   Swampscott 251143002562 2910305 Swampscott: Swampscott Middle   Regular School No Middle 05 08 2018   grade_6 123 7 20 0   3     0   2   77 78                       155.0 123 7 20 0   3     0   2   77 78                 155
2236501 2236501 MA Bristol   school 2511520 293   Taunton 251152001911 2930042 Taunton: Joseph H Martin   Regular School No Middle 05 07 2018   grade_6 159 30 21 1   2     0   13   124 102                       226.0 159 30 21 1   2     0   13   124 102                 226
2236511 2236511 MA Bristol   school 2511520 293   Taunton 251152002416 2930305 Taunton: John F Parker Middle   Regular School No Middle 05 07 2018   grade_6 85 46 31 1   2     0   14   90 89                       179.0 85 46 31 1   2     0   14   90 89                 179
2236515 2236515 MA Bristol   school 2511520 293   Taunton 251152001662 2930315 Taunton: Benjamin Friedman Middle   Regular School No Middle 05 07 2018   grade_6 191 22 24 0   3     2   14   127 129                       256.0 191 22 24 0   3     2   14   127 129                 256
2236541 2236541 MA Middlesex   school 2511580 295   Tewksbury 251158001426 2950023 Tewksbury: John F. Ryan   Regular School No Middle 05 06 2018   grade_6 238 6 8 0   9     1   2   141 123                       264.0 238 6 8 0   9     1   2   141 123                 264

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