enrollments

Data source: Big Local News · About: Big Local

592 rows where grade = "grade_6", state = "MA" and year = 2021

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 592 ✖

grade ✖

  • grade_6 · 592 ✖
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1672252 1672252 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Attleboro - Wamsutta Middle School   Regular School No Middle 05 08 2021   grade_6 86 11 18 0   1     0   18   62 72 *                     134.0 86 11 18 0   1     0   18   62 72                 134
1672272 1672272 MA Worcester   school 2502220 17   Auburn 250222002567 170305 Auburn - Auburn Middle   Regular School No Middle 06 08 2021   grade_6 163 6 23 0   18     0   3   110 103 *                     213.0 163 6 23 0   18     0   3   110 103                 213
1672288 1672288 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon - Ralph D Butler   Regular School No Elementary PK 06 2021   grade_6 29 19 6 0   1     0   0   26 29 *                     55.0 29 19 6 0   1     0   0   26 29                 55
1672318 1672318 MA Barnstable   school 2502310 20   Barnstable 250231002678 200315 Barnstable - Barnstable Intermediate School   Regular School No Middle 06 07 2021   grade_6 221 33 70 2   7     0   25   190 168 *                     358.0 221 33 70 2   7     0   25   190 168                 358
1672333 1672333 MA Middlesex   school 2502400 23   Bedford 250240000130 230305 Bedford - John Glenn Middle   Regular School No Middle 06 08 2021   grade_6 136 13 11 0   41     0   4   99 106 *                     205.0 136 13 11 0   41     0   4   99 106                 205
1672344 1672344 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Belchertown - Chestnut Hill Community School   Regular School No Middle 04 06 2021   grade_6 141 3 18 1   0     0   12   96 79 *                     175.0 141 3 18 1   0     0   12   96 79                 175
1672365 1672365 MA Norfolk   school 2502460 25   Bellingham 250246001683 250315 Bellingham - Bellingham Memorial School   Regular School No Middle 04 07 2021   grade_6 134 4 11 1   4     0   5   75 84 *                     159.0 134 4 11 1   4     0   5   75 84                 159
1672398 1672398 MA Middlesex   school 2502490 26   Belmont 250249000149 260305 Belmont - Winthrop L Chenery Middle   Regular School No Middle 05 08 2021   grade_6 251 8 8 0   74     0   24   184 181 *                     365.0 251 8 8 0   74     0   24   184 181                 365
1672412 1672412 MA Bristol   school 2502520 27   Berkley 250252001613 270305 Berkley - Berkley Middle School   Regular School No Middle 05 08 2021   grade_6 84 1 2 0   0     0   4   47 44 *                     91.0 84 1 2 0   0     0   4   47 44                 91
1672442 1672442 MA Essex   school 2502640 30   Beverly 250264000165 300305 Beverly - Beverly Middle School   Regular School No Middle 05 08 2021   grade_6 270 14 59 1   7     0   13   178 186 *                     364.0 270 14 59 1   7     0   13   178 186                 364
1672476 1672476 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Billerica - Marshall Middle School   Regular School No Middle 05 07 2021   grade_6 127 19 22 0   16     0   9   109 84 *                     193.0 127 19 22 0   16     0   9   109 84                 193
1672479 1672479 MA Middlesex   school 2502670 31   Billerica 250267000182 310310 Billerica - Locke Middle   Regular School No Middle 05 07 2021   grade_6 132 4 13 0   14     0   13   83 93 *                     176.0 132 4 13 0   14     0   13   83 93                 176
1672502 1672502 MA Suffolk   school 2502790 35   Boston 250279002458 350004 Boston - Lyon K-8   Regular School No Elementary KG 08 2021   grade_6 5 4 5 0   3     0   1   9 9 *                     18.0 5 4 5 0   3     0   1   9 9                 18
1672526 1672526 MA Suffolk   school 2502790 35   Boston 250279002687 350012 Boston - Boston Teachers Union School   Regular School No Elementary PK 08 2021   grade_6 19 7 16 0   1     0   4   19 28 *                     47.0 19 7 16 0   1     0   4   19 28                 47
1672536 1672536 MA Suffolk   school 2502790 35   Boston 250279000251 350013 Boston - Jackson Mann   Regular School No Elementary PK 08 2021   grade_6 8 10 27 0   9     0   1   33 22 *                     55.0 8 10 27 0   9     0   1   33 22                 55
1672561 1672561 MA Suffolk   school 2502790 35   Boston 250279002622 350020 Boston - Curley K-8 School   Regular School No Elementary PK 08 2021   grade_6 30 20 51 1   3     0   5   43 67 *                     110.0 30 20 51 1   3     0   5   43 67                 110
1672593 1672593 MA Suffolk   school 2502790 35   Boston 250279000218 350062 Boston - Curtis Guild   Regular School No Elementary PK 06 2021   grade_6 3 0 33 0   0     0   0   16 20 *                     36.0 3 0 33 0   0     0   0   16 20                 36
1672601 1672601 MA Suffolk   school 2502790 35   Boston 250279002835 350066 Boston - Dante Alighieri Montessori School   Regular School No Elementary PK 06 2021   grade_6 4 0 8 0   0     0   0   7 5 *                     12.0 4 0 8 0   0     0   0   7 5                 12
1672609 1672609 MA Suffolk   school 2502790 35   Boston 250279000222 350074 Boston - Dearborn   Regular School No High 06 12 2021   grade_6 2 33 37 0   0     1   6   35 43 *                     79.0 2 33 37 0   0     1   6   35 43                 79
1672623 1672623 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Boston - Dennis C Haley   Regular School No Elementary PK 08 2021   grade_6 12 17 16 0   0     0   1   23 23 *                     46.0 12 17 16 0   0     0   1   23 23                 46
1672633 1672633 MA Suffolk   school 2502790 35   Boston 250279000224 350080 Boston - Donald Mckay   Regular School No Elementary PK 08 2021   grade_6 8 0 88 0   0     0   1   44 53 *                     97.0 8 0 88 0   0     0   1   44 53                 97
1672643 1672643 MA Suffolk   school 2502790 35   Boston 250279000227 350088 Boston - Edward Everett   Regular School No Elementary PK 06 2021   grade_6 1 16 18 0   5     0   3   16 27 *                     43.0 1 16 18 0   5     0   3   16 27                 43
1672651 1672651 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Boston - Eliot Elementary   Regular School No Elementary PK 08 2021   grade_6 59 6 22 1   10     0   7   47 58 *                     105.0 59 6 22 1   10     0   7   47 58                 105
1672668 1672668 MA Suffolk   school 2502790 35   Boston 250279000239 350116 Boston - Franklin D Roosevelt   Regular School No Elementary PK 08 2021   grade_6 4 22 16 0   2     0   5   25 24 *                     49.0 4 22 16 0   2     0   5   25 24                 49
1672678 1672678 MA Suffolk   school 2502790 35   Boston 250279000241 350122 Boston - George H Conley   Regular School No Elementary PK 06 2021   grade_6 1 10 10 0   1     0   2   13 11 *                     24.0 1 10 10 0   1     0   2   13 11                 24
1672700 1672700 MA Suffolk   school 2502790 35   Boston 250279000249 350141 Boston - Hugh Roe O'Donnell   Regular School No Elementary PK 06 2021   grade_6 0 0 34 0   1     0   0   16 19 *                     35.0 0 0 34 0   1     0   0   16 19                 35
1672708 1672708 MA Suffolk   school 2502790 35   Boston 250279000254 350146 Boston - Condon K-8   Regular School No Elementary PK 08 2021   grade_6 25 20 37 0   12     0   5   49 50 *                     99.0 25 20 37 0   12     0   5   49 50                 99
1672717 1672717 MA Suffolk   school 2502790 35   Boston 250279000259 350153 Boston - James W Hennigan   Regular School No Elementary KG 08 2021   grade_6 1 30 45 0   1     1   0   36 42 *                     78.0 1 30 45 0   1     1   0   36 42                 78
1672734 1672734 MA Suffolk   school 2502790 35   Boston 250279000257 350156 Boston - James Otis   Regular School No Elementary PK 06 2021   grade_6 9 3 25 0   3     0   0   27 13 *                     40.0 9 3 25 0   3     0   0   27 13                 40
1672756 1672756 MA Suffolk   school 2502790 35   Boston 250279000269 350179 Boston - John W McCormack   Regular School No Middle 06 08 2021   grade_6 0 10 42 1   9     0   4   33 33 *                     66.0 0 10 42 1   9     0   4   33 33                 66
1672773 1672773 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Boston - Joseph P Tynan   Regular School No Elementary PK 06 2021   grade_6 2 11 8 0   2     0   0   15 8 *                     23.0 2 11 8 0   2     0   0   15 8                 23
1672781 1672781 MA Suffolk   school 2502790 35   Boston 250279000272 350182 Boston - Joseph J Hurley   Regular School No Elementary PK 08 2021   grade_6 6 1 27 0   0     0   3   21 16 *                     37.0 6 1 27 0   0     0   3   21 16                 37
1672791 1672791 MA Suffolk   school 2502790 35   Boston 250279000273 350183 Boston - Joseph Lee   Regular School No Elementary PK 08 2021   grade_6 5 42 25 0   3     0   6   42 39 *                     81.0 5 42 25 0   3     0   6   42 39                 81
1672801 1672801 MA Suffolk   school 2502790 35   Boston 250279000274 350184 Boston - Joseph P Manning   Regular School No Elementary PK 06 2021   grade_6 14 3 3 0   1     1   2   17 7 *                     24.0 14 3 3 0   1     1   2   17 7                 24
1672809 1672809 MA Suffolk   school 2502790 35   Boston 250279000278 350190 Boston - Joyce Kilmer   Regular School No Elementary PK 08 2021   grade_6 29 4 11 0   9     0   3   36 20 *                     56.0 29 4 11 0   9     0   3   36 20                 56
1672819 1672819 MA Suffolk   school 2502790 35   Boston 250279000244 350200 Boston - Harvard-Kent   Regular School No Elementary PK 06 2021   grade_6 6 17 18 0   14     0   1   32 24 *                     56.0 6 17 18 0   14     0   1   32 24                 56
1672827 1672827 MA Suffolk   school 2502790 35   Boston 250279000283 350215 Boston - Manassah E Bradley   Regular School No Elementary PK 06 2021   grade_6 6 1 16 0   3     0   1   13 14 *                     27.0 6 1 16 0   3     0   1   13 14                 27
1672842 1672842 MA Suffolk   school 2502790 35   Boston 250279000291 350229 Boston - Maurice J Tobin   Regular School No Elementary PK 08 2021   grade_6 1 17 29 0   0     0   1   20 28 *                     48.0 1 17 29 0   0     0   1   20 28                 48
1672852 1672852 MA Suffolk   school 2502790 35   Boston 250279000292 350231 Boston - Michael J Perkins   Regular School No Elementary PK 06 2021   grade_6 3 7 4 0   1     0   2   10 7 *                     17.0 3 7 4 0   1     0   2   10 7                 17
1672867 1672867 MA Suffolk   school 2502790 35   Boston 250279000315 350240 Boston - Richard J Murphy   Regular School No Elementary PK 08 2021   grade_6 10 24 23 1   74     0   7   78 61 *                     139.0 10 24 23 1   74     0   7   78 61                 139
1672877 1672877 MA Suffolk   school 2502790 35   Boston 250279000295 350243 Boston - Nathan Hale   Regular School No Elementary PK 06 2021   grade_6 2 10 6 0   3     0   2   10 13 *                     23.0 2 10 6 0   3     0   2   10 13                 23
1672885 1672885 MA Suffolk   school 2502790 35   Boston 250279000297 350255 Boston - Oliver Hazard Perry   Regular School No Elementary PK 08 2021   grade_6 6 6 8 0   0     0   2   18 4 *                     22.0 6 6 8 0   0     0   2   18 4                 22
1672894 1672894 MA Suffolk   school 2502790 35   Boston 250279002006 350257 Boston - Orchard Gardens   Regular School No Elementary PK 08 2021   grade_6 1 54 29 0   1     0   1   37 49 *                     86.0 1 54 29 0   1     0   1   37 49                 86
1672900 1672900 MA Suffolk   school 2502790 35   Boston 250279000339 350258 Boston - William H Ohrenberger   Regular School No Middle 03 08 2021   grade_6 37 31 45 0   4     0   1   58 60 *                     118.0 37 31 45 0   4     0   1   58 60                 118
1672910 1672910 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Boston - Lyndon   Regular School No Elementary PK 08 2021   grade_6 30 10 20 0   3     1   3   37 30 *                     67.0 30 10 20 0   3     1   3   37 30                 67
1672920 1672920 MA Suffolk   school 2502790 35   Boston 250279000302 350264 Boston - Patrick J Kennedy   Regular School No Elementary PK 06 2021   grade_6 1 4 36 0   1     0   0   29 13 *                     42.0 1 4 36 0   1     0   0   29 13                 42
1672952 1672952 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Boston - Roger Clap   Regular School No Elementary PK 06 2021   grade_6 1 5 4 0   0     0   0   5 5 *                     10.0 1 5 4 0   0     0   0   5 5                 10
1672960 1672960 MA Suffolk   school 2502790 35   Boston 250279000321 350302 Boston - Samuel Adams   Regular School No Elementary PK 06 2021   grade_6 5 0 20 0   0     0   0   16 9 *                     25.0 5 0 20 0   0     0   0   16 9                 25
1672975 1672975 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Boston - Sarah Greenwood   Regular School No Elementary PK 08 2021   grade_6 0 8 34 0   0     0   0   23 19 *                     42.0 0 8 34 0   0     0   0   23 19                 42
1672985 1672985 MA Suffolk   school 2502790 35   Boston 250279000331 350326 Boston - Gardner Pilot Academy   Regular School No Elementary PK 08 2021   grade_6 4 3 34 0   3     0   1   25 20 *                     45.0 4 3 34 0   3     0   1   25 20                 45
1672995 1672995 MA Suffolk   school 2502790 35   Boston 250279000332 350328 Boston - Thomas J Kenny   Regular School No Elementary PK 06 2021   grade_6 4 27 12 0   7     0   0   28 22 *                     50.0 4 27 12 0   7     0   0   28 22                 50
1673003 1673003 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Boston - Warren-Prescott   Regular School No Elementary PK 08 2021   grade_6 32 11 14 0   4     0   2   32 31 *                     63.0 32 11 14 0   4     0   2   32 31                 63
1673013 1673013 MA Suffolk   school 2502790 35   Boston 250279000338 350360 Boston - William Ellery Channing   Regular School No Elementary PK 06 2021   grade_6 1 6 14 0   2     1   1   12 13 *                     25.0 1 6 14 0   2     1   1   12 13                 25
1673039 1673039 MA Suffolk   school 2502790 35   Boston 250279000343 350370 Boston - William Monroe Trotter   Regular School No Elementary PK 08 2021   grade_6 1 16 18 0   0     0   0   25 10 *                     35.0 1 16 18 0   0     0   0   25 10                 35
1673056 1673056 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Boston - Edison K-8   Regular School No Elementary PK 08 2021   grade_6 7 13 38 1   10     0   1   36 34 *                     70.0 7 13 38 1   10     0   1   36 34                 70
1673066 1673066 MA Suffolk   school 2502790 35   Boston 250279002669 350376 Boston - King K-8   Regular School No Elementary PK 08 2021   grade_6 0 35 18 0   2     0   3   31 27 *                     58.0 0 35 18 0   2     0   3   31 27                 58
1673072 1673072 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Boston - Higginson/Lewis K-8   Regular School No Middle 03 08 2021   grade_6 0 19 16 0   1     0   3   29 10 *                     39.0 0 19 16 0   1     0   3   29 10                 39
1673082 1673082 MA Suffolk   school 2502790 35   Boston 250279002670 350378 Boston - Mildred Avenue K-8   Regular School No Elementary PK 08 2021   grade_6 3 76 29 1   2     0   1   54 58 *                     112.0 3 76 29 1   2     0   1   54 58                 112
1673092 1673092 MA Suffolk   school 2502790 35   Boston 250279000693 350380 Boston - Young Achievers   Alternative School No Elementary PK 08 2021   grade_6 0 36 30 1   0     0   2   43 26 *                     69.0 0 36 30 1   0     0   2   43 26                 69
1673102 1673102 MA Suffolk   school 2502790 35   Boston 250279000946 350382 Boston - Mission Hill School   Regular School No Elementary PK 08 2021   grade_6 5 5 5 0   0     0   1   10 6 *                     16.0 5 5 5 0   0     0   1   10 6                 16
1673105 1673105 MA Suffolk   school 2502790 35   Boston 250279002013 350383 Boston - Lilla G. Frederick Middle School   Regular School No Middle 06 08 2021   grade_6 2 38 43 0   14     0   1   57 41 *                     98.0 2 38 43 0   14     0   1   57 41                 98
1673119 1673119 MA Suffolk   school 2502790 35   Boston 250279000952 350426 Boston - Dr. William Henderson Upper   Regular School No Other 02 12 2021   grade_6 14 26 18 0   7     0   0   31 34 *                     65.0 14 26 18 0   7     0   0   31 34                 65
1673129 1673129 MA Suffolk   school 2502790 35   Boston 250279000334 350445 Boston - Washington Irving Middle   Regular School No Middle 06 08 2021   grade_6 4 18 25 0   2     0   3   30 22 *                     52.0 4 18 25 0   2     0   3   30 22                 52
1673132 1673132 MA Suffolk   school 2502790 35   Boston 250279000258 350485 Boston - James P Timilty Middle   Regular School No Middle 06 08 2021   grade_6 0 22 30 0   0     0   3   28 27 *                     55.0 0 22 30 0   0     0   3   28 27                 55
1673223 1673223 MA Suffolk   school 2502790 35   Boston 250279001296 350565 Boston - Quincy Upper School   Regular School No High 06 12 2021   grade_6 9 20 20 0   83     0   4   67 69 *                     136.0 9 20 20 0   83     0   4   67 69                 136
1673254 1673254 MA Suffolk   school 2502790 35   Boston 250279002721 350656 Boston - Mario Umana Academy   Regular School No Elementary PK 08 2021   grade_6 3 1 60 0   1     0   0   35 30 *                     65.0 3 1 60 0   1     0   0   35 30                 65
1673257 1673257 MA Suffolk   school 2502790 35   Boston 250279002725 350657 Boston - TechBoston Academy   Regular School No High 06 12 2021   grade_6 2 60 31 0   1     0   10   65 39 *                     104.0 2 60 31 0   1     0   10   65 39                 104
1673275 1673275 MA Suffolk   school 2502790 35   Boston 250279000312 350691 Boston - Rafael Hernandez   Regular School No Elementary PK 08 2021   grade_6 0 2 34 0   0     0   1   16 21 *                     37.0 0 2 34 0   0     0   1   16 21                 37
1673283 1673283 MA Suffolk   school 2502790 35   Boston 250279002374 350750 Boston - Horace Mann School for the Deaf   Special Education School No Other 01 12 2021   grade_6 0 4 4 0   0     0   0   6 2 *                     8.0 0 4 4 0   0     0   0   6 2                 8
1673300 1673300 MA Barnstable   school 2502820 36   Bourne 250282001517 360325 Bourne - Bourne Middle School   Regular School No Middle 06 08 2021   grade_6 124 2 6 0   1     0   5   68 70 *                     138.0 124 2 6 0   1     0   5   68 70                 138
1673315 1673315 MA Essex   school 2502880 38   Boxford 250288000358 380013 Boxford - Spofford Pond   Regular School No Elementary 03 06 2021   grade_6 81 0 3 0   6     0   2   49 43 *                     92.0 81 0 3 0   6     0   2   49 43                 92
1673349 1673349 MA Norfolk   school 2502940 40   Braintree 250294000364 400305 Braintree - East Middle School   Regular School No Middle 05 08 2021   grade_6 148 19 18 0   50     0   4   113 126 *                     239.0 148 19 18 0   50     0   4   113 126                 239
1673352 1673352 MA Norfolk   school 2502940 40   Braintree 250294000372 400310 Braintree - South Middle School   Regular School No Middle 06 08 2021   grade_6 133 3 8 1   51     0   3   97 102 *                     199.0 133 3 8 1   51     0   3   97 102                 199
1673374 1673374 MA Hampden   school 2503060 43   Brimfield 250306000381 430005 Brimfield - Brimfield Elementary   Regular School No Elementary PK 06 2021   grade_6 44 2 1 0   0     0   0   23 24 *                     47.0 44 2 1 0   0     0   0   23 24                 47
1673414 1673414 MA Plymouth   school 2503090 44   Brockton 250309000390 440023 Brockton - Edgar B Davis   Regular School No Elementary KG 08 2021   grade_6 14 92 17 0   3     2   3   51 80 *                     131.0 14 92 17 0   3     2   3   51 80                 131
1673458 1673458 MA Plymouth   school 2503090 44   Brockton 250309000389 440405 Brockton - East Middle School   Regular School No Middle 06 08 2021   grade_6 24 97 18 0   0     1   7   91 56 *                     147.0 24 97 18 0   0     1   7   91 56                 147
1673461 1673461 MA Plymouth   school 2503090 44   Brockton 250309000404 440410 Brockton - North Middle School   Regular School No Middle 06 08 2021   grade_6 21 136 27 1   3     0   12   96 104 *                     200.0 21 136 27 1   3     0   12   96 104                 200
1673462 1673462 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 Brockton - South Middle School   Regular School No Middle 06 08 2021   grade_6 19 110 21 1   1     0   16   90 78 *                     168.0 19 110 21 1   1     0   16   90 78                 168
1673465 1673465 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 Brockton - West Middle School   Regular School No Middle 06 08 2021   grade_6 34 124 27 0   4     1   14   110 94 *                     204.0 34 124 27 0   4     1   14   110 94                 204
1673468 1673468 MA Plymouth   school 2503090 44   Brockton 250309002688 440421 Brockton - Ashfield Middle School   Regular School No Middle 06 08 2021   grade_6 31 78 16 1   3     2   6   79 58 *                     137.0 31 78 16 1   3     2   6   79 58                 137
1673471 1673471 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Brockton - Joseph F. Plouffe Academy   Regular School No Middle 06 08 2021   grade_6 35 91 83 1   6     1   8   109 116 *                     225.0 35 91 83 1   6     1   8   109 116                 225
1673495 1673495 MA Worcester   school 2503120 45   Brookfield 250312000413 450005 Brookfield - Brookfield Elementary   Regular School No Elementary PK 06 2021   grade_6 33 0 1 0   0     0   2   17 19 *                     36.0 33 0 1 0   0     0   2   17 19                 36
1673505 1673505 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Brookline - Edith C Baker   Regular School No Elementary KG 08 2021   grade_6 40 6 5 0   28     0   7   44 42 *                     86.0 40 6 5 0   28     0   7   44 42                 86
1673515 1673515 MA Norfolk   school 2503150 46   Brookline 250315000417 460015 Brookline - Florida Ruffin Ridley School   Regular School No Elementary PK 08 2021   grade_6 45 5 9 0   10     0   11   38 42 *                     80.0 45 5 9 0   10     0   11   38 42                 80
1673524 1673524 MA Norfolk   school 2503150 46   Brookline 250315000421 460020 Brookline - Michael Driscoll   Regular School No Elementary KG 08 2021   grade_6 41 3 4 0   8     0   12   37 31 *                     68.0 41 3 4 0   8     0   12   37 31                 68
1673534 1673534 MA Norfolk   school 2503150 46   Brookline 250315000418 460025 Brookline - Heath   Regular School No Elementary PK 08 2021   grade_6 38 2 4 0   10     0   8   26 36 *                     62.0 38 2 4 0   10     0   8   26 36                 62

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