enrollments

Data source: Big Local News · About: Big Local

4,038 rows where grade = "grade_6" and state = "MA" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,038 ✖
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
735665 735665 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2015   grade_6 158 7 6 1   2     0   0   94 80                       174 158 7 6 1   2     0   0   94 80                 174
932543 932543 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No 2 05 06 2016   grade_6 149 1 7 0   0     0   4   86 75                       161 149 1 7 0   0     0   4   86 75                 161
1121955 1121955 MA Plymouth   school 2501650 1   Abington 250165000006 10015 Woodsdale Elementary School   Regular School No Middle 05 06 2017   grade_6 156 6 8 0   2     0   1   82 91                       173 156 6 8 0   2     0   1   82 91                 173
1364791 1364791 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2020   grade_6 137 6 20 2   4     0   3   92 80 *                     172.0 137 6 20 2   4     0   3   92 80                 172
1672015 1672015 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington - Abington Middle School   Regular School No Middle 05 08 2021   grade_6 136 5 20 0   4     1   3   95 74 *                     169.0 136 5 20 0   4     1   3   95 74                 169
2039817 2039817 MA Plymouth   school 2501650 1   Abington 250165000002 10405 Abington Middle School   Regular School No Middle 05 08 2019   grade_6 136 1 10 1   2     0   4   80 74                       154.0 136 1 10 1   2     0   4   80 74                 154
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
735680 735680 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2015   grade_6 113 1 1 0   1     0   0   55 61                       116 113 1 1 0   1     0   0   55 61                 116
932558 932558 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No 2 05 08 2016   grade_6 75 0 3 0   0     0   0   41 37                       78 75 0 3 0   0     0   0   41 37                 78
1121973 1121973 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2017   grade_6 119 0 1 0   0     0   1   61 60                       121 119 0 1 0   0     0   1   61 60                 121
1364806 1364806 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2020   grade_6 97 1 2 0   1     0   0   57 44 *                     101.0 97 1 2 0   1     0   0   57 44                 101
1672030 1672030 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Acushnet - Albert F Ford Middle School   Regular School No Middle 05 08 2021   grade_6 92 0 7 0   1     0   4   49 55 *                     104.0 92 0 7 0   1     0   4   49 55                 104
2039832 2039832 MA Bristol   school 2501740 3   Acushnet 250174000015 30305 Albert F Ford Middle School   Regular School No Middle 05 08 2019   grade_6 94 0 5 0   1     0   5   57 48                       105.0 94 0 5 0   1     0   5   57 48                 105
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
735705 735705 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 05 08 2015   grade_6 278 3 21 0   3     0   11   146 170                       316 278 3 21 0   3     0   11   146 170                 316
932583 932583 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No 2 04 08 2016   grade_6 218 6 21 0   7     0   12   123 141                       264 218 6 21 0   7     0   12   123 141                 264
1122004 1122004 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2017   grade_6 253 6 25 0   13     0   7   155 149                       304 253 6 25 0   13     0   7   155 149                 304
1364831 1364831 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 08 2020   grade_6 250 3 35 0   11     0   13   144 168 *                     312.0 250 3 35 0   11     0   13   144 168                 312
1672055 1672055 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Agawam - Roberta G. Doering School   Regular School No Middle 05 08 2021   grade_6 209 8 36 0   10     0   9   164 108 *                     272.0 209 8 36 0   10     0   9   164 108                 272
2039857 2039857 MA Hampden   school 2501800 5   Agawam 250180000026 50303 Roberta G. Doering School   Regular School No Middle 05 07 2019   grade_6 235 12 16 0   4     0   8   140 135                       275.0 235 12 16 0   4     0   8   140 135                 275
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
735727 735727 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2015   grade_6 150 4 11 0   1     0   9   95 80                       175 150 4 11 0   1     0   9   95 80                 175
932605 932605 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No 2 05 08 2016   grade_6 160 0 10 0   2     0   6   96 82                       178 160 0 10 0   2     0   6   96 82                 178
1122031 1122031 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2017   grade_6 138 1 10 1   0     0   8   81 77                       158 138 1 10 1   0     0   8   81 77                 158
1364851 1364851 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2020   grade_6 128 4 18 0   2     0   10   96 66 *                     162.0 128 4 18 0   2     0   10   96 66                 162
1672075 1672075 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury - Amesbury Middle   Regular School No Middle 05 08 2021   grade_6 139 1 16 1   4     0   5   90 76 *                     166.0 139 1 16 1   4     0   5   90 76                 166
2039878 2039878 MA Essex   school 2501860 7   Amesbury 250186000035 70013 Amesbury Middle   Regular School No Middle 05 08 2019   grade_6 132 3 9 0   2     1   4   71 80                       151.0 132 3 9 0   2     1   4   71 80                 151
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
735742 735742 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2015   grade_6 32 6 12 0   5     1   6   33 29                       62 32 6 12 0   5     1   6   33 29                 62
932622 932622 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No 1 PK 06 2016   grade_6 29 2 6 0   11     0   0   23 25                       48 29 2 6 0   11     0   0   23 25                 48
1122052 1122052 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2017   grade_6 23 6 13 0   5     0   2   22 27                       49 23 6 13 0   5     0   2   22 27                 49
1364870 1364870 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2020   grade_6 29 3 20 0   6     0   3   34 27 *                     61.0 29 3 20 0   6     0   3   34 27                 61
1672093 1672093 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst - Crocker Farm Elementary   Regular School No Elementary PK 06 2021   grade_6 26 1 15 0   6     0   2   26 24 *                     50.0 26 1 15 0   6     0   2   26 24                 50
2039897 2039897 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Crocker Farm Elementary   Regular School No Elementary PK 06 2019   grade_6 13 6 7 0   4     0   2   17 15                       32.0 13 6 7 0   4     0   2   17 15                 32
2228858 2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
735749 735749 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2015   grade_6 27 3 10 0   8     0   4   18 34                       52 27 3 10 0   8     0   4   18 34                 52
932629 932629 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No 1 KG 06 2016   grade_6 35 5 11 0   7     1   2   28 33                       61 35 5 11 0   7     1   2   28 33                 61
1122060 1122060 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2017   grade_6 20 5 9 0   6     0   4   26 18                       44 20 5 9 0   6     0   4   26 18                 44
1364877 1364877 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2020   grade_6 26 6 11 0   5     0   2   18 32 *                     50.0 26 6 11 0   5     0   2   18 32                 50
1672100 1672100 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst - Fort River Elementary   Regular School No Elementary KG 06 2021   grade_6 20 2 10 0   6     0   2   18 22 *                     40.0 20 2 10 0   6     0   2   18 22                 40
2039904 2039904 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Fort River Elementary   Regular School No Elementary KG 06 2019   grade_6 35 3 14 0   9     0   6   43 24                       67.0 35 3 14 0   9     0   6   43 24                 67
2228866 2228866 MA Hampshire   school 2501890 8   Amherst 250189000039 80020 Amherst: Fort River Elementary   Regular School No Elementary KG 06 2018   grade_6 25 9 13 0   0     0   3   24 26                       50.0 25 9 13 0   0     0   3   24 26                 50
735756 735756 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2015   grade_6 34 7 14 0   8     0   7   34 36                       70 34 7 14 0   8     0   7   34 36                 70
932636 932636 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No 1 KG 06 2016   grade_6 40 6 10 0   4     0   3   30 33                       63 40 6 10 0   4     0   3   30 33                 63
1122068 1122068 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2017   grade_6 25 7 11 0   9     0   5   27 30                       57 25 7 11 0   9     0   5   27 30                 57
1364884 1364884 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2020   grade_6 32 6 8 0   5     0   6   29 28 *                     57.0 32 6 8 0   5     0   6   29 28                 57
1672107 1672107 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst - Wildwood Elementary   Regular School No Elementary KG 06 2021   grade_6 27 4 10 0   4     0   5   32 18 *                     50.0 27 4 10 0   4     0   5   32 18                 50
2039911 2039911 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Wildwood Elementary   Regular School No Elementary KG 06 2019   grade_6 30 3 10 0   13     0   11   39 28                       67.0 30 3 10 0   13     0   11   39 28                 67
2228874 2228874 MA Hampshire   school 2501890 8   Amherst 250189000041 80050 Amherst: Wildwood Elementary   Regular School No Elementary KG 06 2018   grade_6 27 11 12 1   4     0   4   29 30                       59.0 27 11 12 1   4     0   4   29 30                 59
735792 735792 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2015   grade_6 150 1 9 0   24     0   6   90 100                       190 150 1 9 0   24     0   6   90 100                 190
932668 932668 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No 2 06 08 2016   grade_6 135 1 8 1   22     0   5   103 69                       172 135 1 8 1   22     0   5   103 69                 172
1122107 1122107 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2017   grade_6 164 0 5 2   27     0   6   99 105                       204 164 0 5 2   27     0   6   99 105                 204
1364916 1364916 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2020   grade_6 121 3 13 0   14     0   7   74 84 *                     158.0 121 3 13 0   14     0   7   74 84                 158
1672139 1672139 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover - Doherty Middle   Regular School No Middle 06 08 2021   grade_6 109 3 13 0   22     0   5   83 69 *                     152.0 109 3 13 0   22     0   5   83 69                 152
2039943 2039943 MA Essex   school 2501950 9   Andover 250195002510 90305 Doherty Middle   Regular School No Middle 06 08 2019   grade_6 139 3 11 1   23     1   5   96 87                       183.0 139 3 11 1   23     1   5   96 87                 183
2228913 2228913 MA Essex   school 2501950 9   Andover 250195002510 90305 Andover: Doherty Middle   Regular School No Middle 06 08 2018   grade_6 142 4 15 0   18     0   6   82 103                       185.0 142 4 15 0   18     0   6   82 103                 185
735795 735795 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2015   grade_6 138 2 8 1   30     0   3   92 90                       182 138 2 8 1   30     0   3   92 90                 182
932671 932671 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No 2 06 08 2016   grade_6 120 4 10 0   26     0   4   73 91                       164 120 4 10 0   26     0   4   73 91                 164
1122111 1122111 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2017   grade_6 145 1 4 0   26     0   6   86 96                       182 145 1 4 0   26     0   6   86 96                 182
1364919 1364919 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2020   grade_6 120 10 12 0   39     0   3   94 90 *                     184.0 120 10 12 0   39     0   3   94 90                 184
1672142 1672142 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover - Andover West Middle   Regular School No Middle 06 08 2021   grade_6 129 5 18 0   26     0   4   89 93 *                     182.0 129 5 18 0   26     0   4   89 93                 182
2039946 2039946 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover West Middle   Regular School No Middle 06 08 2019   grade_6 124 4 9 0   27     0   7   95 76                       171.0 124 4 9 0   27     0   7   95 76                 171
2228917 2228917 MA Essex   school 2501950 9   Andover 250195002511 90310 Andover: Andover West Middle   Regular School No Middle 06 08 2018   grade_6 126 7 10 1   28     0   4   96 80                       176.0 126 7 10 1   28     0   4   96 80                 176
735798 735798 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2015   grade_6 104 7 5 0   38     0   4   67 91                       158 104 7 5 0   38     0   4   67 91                 158
932674 932674 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No 2 06 08 2016   grade_6 85 2 13 0   38     0   3   74 67                       141 85 2 13 0   38     0   3   74 67                 141
1122115 1122115 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2017   grade_6 72 3 9 0   32     0   4   50 70                       120 72 3 9 0   32     0   4   50 70                 120
1364922 1364922 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2020   grade_6 69 3 9 0   37     1   6   56 69 *                     125.0 69 3 9 0   37     1   6   56 69                 125
1672145 1672145 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover - Wood Hill Middle School   Regular School No Middle 06 08 2021   grade_6 57 3 13 0   41     0   7   68 53 *                     121.0 57 3 13 0   41     0   7   68 53                 121
2039949 2039949 MA Essex   school 2501950 9   Andover 250195001678 90350 Wood Hill Middle School   Regular School No Middle 06 08 2019   grade_6 59 3 17 1   53     0   0   73 60                       133.0 59 3 17 1   53     0   0   73 60                 133
2228921 2228921 MA Essex   school 2501950 9   Andover 250195001678 90350 Andover: Wood Hill Middle School   Regular School No Middle 06 08 2018   grade_6 77 4 13 1   44     0   4   79 64                       143.0 77 4 13 1   44     0   4   79 64                 143
1364973 1364973 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2020   grade_6 356 20 40 0   40     0   30   255 231 *                     486.0 356 20 40 0   40     0   30   255 231                 486
1672196 1672196 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Arlington - Gibbs School   Regular School No Middle 06 06 2021   grade_6 334 21 31 2   60     1   34   260 223 *                     483.0 334 21 31 2   60     1   34   260 223                 483
2040000 2040000 MA Middlesex   school 2501980 10   Arlington 250198002889 100305 Gibbs School   Regular School No Middle 06 06 2019   grade_6 321 15 34 1   61     1   30   250 213                       463.0 321 15 34 1   61     1   30   250 213                 463
735849 735849 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2015   grade_6 308 16 28 0   31     0   14   193 204                       397 308 16 28 0   31     0   14   193 204                 397
932725 932725 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No 2 06 08 2016   grade_6 302 17 18 0   50     0   22   193 216                       409 302 17 18 0   50     0   22   193 216                 409
1122175 1122175 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Ottoson Middle   Regular School No Middle 06 08 2017   grade_6 306 21 22 0   45     0   27   188 233                       421 306 21 22 0   45     0   27   188 233                 421
2228981 2228981 MA Middlesex   school 2501980 10   Arlington 250198000063 100410 Arlington: Ottoson Middle   Regular School No Middle 06 08 2018   grade_6 328 11 28 0   52     1   22   204 238                       442.0 328 11 28 0   52     1   22   204 238                 442
735863 735863 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2015   grade_6 146 4 24 0   16     0   8   92 106                       198 146 4 24 0   16     0   8   92 106                 198
932739 932739 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No 2 06 08 2016   grade_6 147 7 22 0   26     0   5   96 111                       207 147 7 22 0   26     0   5   96 111                 207
1122194 1122194 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2017   grade_6 127 5 16 2   25     0   4   96 83                       179 127 5 16 2   25     0   4   96 83                 179
1364987 1364987 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2020   grade_6 150 4 32 4   30     0   9   118 111 *                     229.0 150 4 32 4   30     0   9   118 111                 229
1672210 1672210 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland - Ashland Middle   Regular School No Middle 06 08 2021   grade_6 158 7 27 3   29     0   5   115 114 *                     229.0 158 7 27 3   29     0   5   115 114                 229
2040014 2040014 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland Middle   Regular School No Middle 06 08 2019   grade_6 145 6 26 0   30     0   8   107 108                       215.0 145 6 26 0   30     0   8   107 108                 215
2229000 2229000 MA Middlesex   school 2502100 14   Ashland 250210000938 140405 Ashland: Ashland Middle   Regular School No Middle 06 08 2018   grade_6 139 4 27 1   30     0   6   101 106                       207.0 139 4 27 1   30     0   6   101 106                 207
735897 735897 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2015   grade_6 141 5 13 0   5     0   4   83 85                       168 141 5 13 0   5     0   4   83 85                 168
932773 932773 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No 2 05 08 2016   grade_6 157 7 20 0   5     0   7   102 94                       196 157 7 20 0   5     0   7   102 94                 196
1122236 1122236 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2017   grade_6 108 5 12 0   5     0   11   69 72                       141 108 5 12 0   5     0   11   69 72                 141
1365021 1365021 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2020   grade_6 111 16 9 2   10     0   14   82 80 *                     162.0 111 16 9 2   10     0   14   82 80                 162
1672244 1672244 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Attleboro - Robert J. Coelho Middle School   Regular School No Middle 05 08 2021   grade_6 97 9 15 0   8     0   7   75 61 *                     136.0 97 9 15 0   8     0   7   75 61                 136
2040048 2040048 MA Bristol   school 2502190 16   Attleboro 250219000096 160305 Robert J. Coelho Middle School   Regular School No Middle 05 08 2019   grade_6 120 9 24 0   6     0   10   98 71                       169.0 120 9 24 0   6     0   10   98 71                 169
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
735901 735901 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2015   grade_6 96 8 17 0   7     2   10   80 60                       140 96 8 17 0   7     2   10   80 60                 140
932777 932777 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No 2 05 08 2016   grade_6 92 5 19 0   4     0   8   69 59                       128 92 5 19 0   4     0   8   69 59                 128
1122241 1122241 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2017   grade_6 79 3 25 1   3     0   12   66 57                       123 79 3 25 1   3     0   12   66 57                 123
1365025 1365025 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2020   grade_6 94 2 20 0   10     0   15   69 72 *                     141.0 94 2 20 0   10     0   15   69 72                 141
1672248 1672248 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Attleboro - Cyril K. Brennan Middle School   Regular School No Middle 05 08 2021   grade_6 102 11 36 0   3     0   11   86 77 *                     163.0 102 11 36 0   3     0   11   86 77                 163
2040052 2040052 MA Bristol   school 2502190 16   Attleboro 250219000087 160315 Cyril K. Brennan Middle School   Regular School No Middle 05 08 2019   grade_6 104 10 37 0   9     0   5   91 73                       165.0 104 10 37 0   9     0   5   91 73                 165
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
735905 735905 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2015   grade_6 82 10 34 0   10     0   7   66 77                       143 82 10 34 0   10     0   7   66 77                 143
932781 932781 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No 2 05 08 2016   grade_6 87 5 25 0   10     1   5   73 60                       133 87 5 25 0   10     1   5   73 60                 133

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