enrollments

Data source: Big Local News · About: Big Local

11,264 rows where state = "MA" and year = 2017 sorted by black descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 11,264 ✖
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
1123651 1123651 MA Plymouth   school 2503090 44   Brockton 250309000405 440078 Oscar F Raymond   Regular School No Elementary KG 05 2017   grade_3 17 99 11 0   2     0   9   73 65                       138 17 99 11 0   2     0   9   73 65                 138
1123418 1123418 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_11 3 98 24 1   5     1   2   64 70                       134 3 98 24 1   5     1   2   64 70                 134
1123696 1123696 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_7 48 98 65 0   3     1   19   102 132                       234 48 98 65 0   3     1   19   102 132                 234
1126593 1126593 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_9 137 98 121 2   100     0   15   257 216                       473 137 98 121 2   100     0   15   257 216                 473
1123379 1123379 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_11 22 97 84 0   77     0   6   136 150                       286 22 97 84 0   77     0   6   136 150                 286
1131205 1131205 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_5 11 97 71 0   3     0   2   87 97                       184 11 97 71 0   3     0   2   87 97                 184
1123272 1123272 MA Suffolk   school 2502790 35   Boston 250279000208 350505 Brighton High   Regular School No High 09 12 2017   grade_11 8 96 96 2   9     0   2   131 82                       213 8 96 96 2   9     0   2   131 82                 213
1123419 1123419 MA Suffolk   school 2502790 35   Boston 250279002725 350657 TechBoston Academy   Regular School No Other 06 12 2017   grade_12 6 96 23 0   3     0   2   71 59                       130 6 96 23 0   3     0   2   71 59                 130
1123579 1123579 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_2 16 96 24 2   0     0   14   88 64                       152 16 96 24 2   0     0   14   88 64                 152
1123581 1123581 MA Plymouth   school 2503090 44   Brockton 250309000388 440001 Dr W Arnone Community School   Regular School No Elementary KG 05 2017   grade_4 16 96 27 1   0     0   5   74 71                       145 16 96 27 1   0     0   5   74 71                 145
1123695 1123695 MA Plymouth   school 2503090 44   Brockton 250309002691 440422 Joseph F. Plouffe Academy   Regular School No Middle 06 08 2017   grade_6 60 95 72 1   8     0   12   124 124                       248 60 95 72 1   8     0   12   124 124                 248
1128423 1128423 MA Norfolk   school 2509930 244   Randolph 250993001392 2440410 Randolph Community Middle   Regular School No Middle 06 08 2017   grade_8 28 95 34 0   39     0   9   114 91                       205 28 95 34 0   39     0   9   114 91                 205
1131201 1131201 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_1 8 95 73 0   2     0   4   87 95                       182 8 95 73 0   2     0   4   87 95                 182
1131202 1131202 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_2 14 95 63 2   5     0   4   86 97                       183 14 95 63 2   5     0   4   86 97                 183
1131204 1131204 MA Suffolk   school 2500071 428   Brooke Charter School Roslindale (District) 250007101747 4280305 Brooke Charter School   Regular School Yes Other KG 09 2017   grade_4 13 95 73 2   4     0   4   102 89                       191 13 95 73 2   4     0   4   102 89                 191
1123683 1123683 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_6 26 94 30 0   6     1   14   89 82                       171 26 94 30 0   6     1   14   89 82                 171
1123685 1123685 MA Plymouth   school 2503090 44   Brockton 250309000407 440415 South Middle School   Regular School No Middle 06 08 2017   grade_8 44 94 21 0   8     0   9   100 76                       176 44 94 21 0   8     0   9   100 76                 176
1123643 1123643 MA Plymouth   school 2503090 44   Brockton 250309001132 440065 Louis F Angelo Elementary   Regular School No Elementary KG 05 2017   grade_2 16 93 14 1   8     1   5   71 67                       138 16 93 14 1   8     1   5   71 67                 138
1128426 1128426 MA Norfolk   school 2509930 244   Randolph 250993001596 2440505 Randolph High   Regular School No High 09 12 2017   grade_10 9 93 19 0   24     0   9   87 67                       154 9 93 19 0   24     0   9   87 67                 154
1123311 1123311 MA Suffolk   school 2502790 35   Boston 250279000282 350537 Madison Park High   Career and Technical School No High 09 12 2017   grade_10 3 92 129 0   2     0   8   127 107                       234 3 92 129 0   2     0   8   127 107                 234
1123688 1123688 MA Plymouth   school 2503090 44   Brockton 250309000410 440420 West Middle School   Regular School No Middle 06 08 2017   grade_7 49 92 27 1   8     1   13   102 89                       191 49 92 27 1   8     1   13   102 89                 191
1124685 1124685 MA Middlesex   school 2504770 93   Everett 250477000634 930505 Everett High   Regular School No High 09 12 2017   grade_10 148 92 244 1   21     1   7   265 249                       514 148 92 244 1   21     1   7   265 249                 514
1126301 1126301 MA Middlesex   school 2507020 160   Lowell 250702001041 1600505 Lowell High   Regular School No High 09 12 2017   grade_10 226 92 178 0   248     0   19   371 392                       763 226 92 178 0   248     0   19   371 392                 763
1133178 1133178 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_6 1 92 10 0   0     0   2   55 50                       105 1 92 10 0   0     0   2   55 50                 105
1133179 1133179 MA Plymouth   school 2500559 3513   New Heights Charter of Brockton 250055902869 35130305 New Heights Charter School of Brockton   Regular School Yes Middle 06 08 2017   grade_7 4 92 8 0   0     0   0   59 45                       104 4 92 8 0   0     0   0   59 45                 104
1123380 1123380 MA Suffolk   school 2502790 35   Boston 250279000205 350575 O'Bryant School Math/Science   Regular School No High 07 12 2017   grade_12 26 91 80 1   62     0   5   110 155                       265 26 91 80 1   62     0   5   110 155                 265
1123339 1123339 MA Suffolk   school 2502790 35   Boston 250279000204 350545 Boston Latin Academy   Regular School No High 07 12 2017   grade_11 82 90 56 1   68     1   5   127 176                       303 82 90 56 1   68     1   5   127 176                 303
1126594 1126594 MA Middlesex   school 2507170 165   Malden 250717001106 1650505 Malden High   Regular School No High 09 12 2017   grade_10 135 90 97 3   109     0   13   216 231                       447 135 90 97 3   109     0   13   216 231                 447
1129701 1129701 MA Bristol   school 2511520 293   Taunton 251152001915 2930505 Taunton High   Regular School No High 08 12 2017   grade_8 435 90 90 1   5     0   23   319 325                       644 435 90 90 1   5     0   23   319 325                 644
1122120 1122120 MA Essex   school 2501950 9   Andover 250195000045 90505 Andover High   Regular School No High 09 12 2017   grade_10 352 9 18 0   69     0   11   204 255                       459 352 9 18 0   69     0   11   204 255                 459
1122247 1122247 MA Bristol   school 2502190 16   Attleboro 250219000945 160320 Wamsutta Middle School   Regular School No Middle 05 08 2017   grade_7 90 9 22 0   10     1   4   74 62                       136 90 9 22 0   10     1   4   74 62                 136
1122336 1122336 MA Middlesex   school 2502400 23   Bedford 250240000132 230012 Lt Job Lane School   Regular School No Elementary 03 05 2017   grade_4 137 9 9 0   27     0   0   100 82                       182 137 9 9 0   27     0   0   100 82                 182
1122352 1122352 MA Hampshire   school 2502430 24   Belchertown 250243001871 240006 Chestnut Hill Community School   Regular School No Elementary 04 06 2017   grade_4 161 9 4 0   6     1   1   102 80                       182 161 9 4 0   6     1   1   102 80                 182
1122539 1122539 MA Middlesex   school 2502670 31   Billerica 250267000183 310305 Marshall Middle School   Regular School No Middle 06 08 2017   grade_7 186 9 7 1   10     0   2   106 109                       215 186 9 7 1   10     0   2   106 109                 215
1122547 1122547 MA Middlesex   school 2502670 31   Billerica 250267000177 310505 Billerica Memorial High School   Regular School No High 09 12 2017   grade_9 306 9 17 0   21     0   7   176 184                       360 306 9 17 0   21     0   7   176 184                 360
1122558 1122558 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2017   pre_kindergarten 19 9 22 0   27     0   5   47 35                       82 19 9 22 0   27     0   5   47 35                 82
1122572 1122572 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2017   pre_kindergarten 6 9 21 0   8     0   2   29 17                       46 6 9 21 0   8     0   2   29 17                 46
1122645 1122645 MA Suffolk   school 2502790 35   Boston 250279000214 350052 Charles Sumner   Regular School No Elementary PK 05 2017   pre_kindergarten 17 9 24 0   0     0   4   27 27                       54 17 9 24 0   0     0   4   27 27                 54
1122695 1122695 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_1 14 9 12 0   0     0   5   20 20                       40 14 9 12 0   0     0   5   20 20                 40
1122700 1122700 MA Suffolk   school 2502790 35   Boston 250279000223 350077 Dennis C Haley   Regular School No Elementary PK 08 2017   grade_6 9 9 24 0   1     0   3   21 25                       46 9 9 24 0   1     0   3   21 25                 46
1122729 1122729 MA Suffolk   school 2502790 35   Boston 250279000230 350096 Eliot Elementary   Regular School No Elementary PK 08 2017   grade_5 21 9 10 0   3     0   1   21 23                       44 21 9 10 0   3     0   1   21 23                 44
1122734 1122734 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   kindergarten 18 9 12 0   0     0   2   26 15                       41 18 9 12 0   0     0   2   26 15                 41
1122740 1122740 MA Suffolk   school 2502790 35   Boston 250279000232 350100 Ellis Mendell   Regular School No Elementary PK 05 2017   grade_5 4 9 9 0   0     0   1   11 12                       23 4 9 9 0   0     0   1   11 12                 23
1122837 1122837 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   kindergarten 8 9 7 0   0     0   1   13 12                       25 8 9 7 0   0     0   1   13 12                 25
1122839 1122839 MA Suffolk   school 2502790 35   Boston 250279000264 350172 John D Philbrick   Regular School No Elementary PK 05 2017   grade_1 7 9 4 0   1     0   1   12 10                       22 7 9 4 0   1     0   1   12 10                 22
1122857 1122857 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   kindergarten 7 9 13 0   2     0   4   20 15                       35 7 9 13 0   2     0   4   20 15                 35
1122859 1122859 MA Suffolk   school 2502790 35   Boston 250279000275 350181 Joseph P Tynan   Regular School No Elementary PK 05 2017   grade_1 10 9 7 0   3     0   2   19 12                       31 10 9 7 0   3     0   2   19 12                 31
1123021 1123021 MA Suffolk   school 2502790 35   Boston 250279000692 350262 Lyndon   Regular School No Elementary PK 08 2017   grade_8 5 9 23 0   0     0   0   20 17                       37 5 9 23 0   0     0   0   20 17                 37
1123042 1123042 MA Suffolk   school 2502790 35   Boston 250279000304 350268 Paul A Dever   Regular School No Elementary PK 05 2017   grade_5 2 9 44 0   2     0   1   27 31                       58 2 9 44 0   2     0   1   27 31                 58
1123044 1123044 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2017   kindergarten 11 9 14 0   2     0   3   24 15                       39 11 9 14 0   2     0   3   24 15                 39
1123046 1123046 MA Suffolk   school 2502790 35   Boston 250279000308 350278 Phineas Bates   Regular School No Elementary PK 05 2017   grade_1 7 9 14 0   3     0   2   14 21                       35 7 9 14 0   3     0   2   14 21                 35
1123065 1123065 MA Suffolk   school 2502790 35   Boston 250279000319 350298 Roger Clap   Regular School No Elementary PK 05 2017   grade_4 4 9 8 0   2     0   0   8 15                       23 4 9 8 0   2     0   0   8 15                 23
1123088 1123088 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_3 0 9 37 0   0     0   0   23 23                       46 0 9 37 0   0     0   0   23 23                 46
1123091 1123091 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_6 0 9 25 0   0     0   1   19 16                       35 0 9 25 0   0     0   1   19 16                 35
1123093 1123093 MA Suffolk   school 2502790 35   Boston 250279000323 350308 Sarah Greenwood   Regular School No Elementary PK 08 2017   grade_8 1 9 24 0   0     0   0   16 18                       34 1 9 24 0   0     0   0   16 18                 34
1123116 1123116 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_1 32 9 10 0   5     0   5   27 34                       61 32 9 10 0   5     0   5   27 34                 61
1123117 1123117 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_2 38 9 14 0   3     0   4   35 33                       68 38 9 14 0   3     0   4   35 33                 68
1123123 1123123 MA Suffolk   school 2502790 35   Boston 250279000333 350346 Warren-Prescott   Regular School No Elementary PK 08 2017   grade_8 11 9 9 1   2     0   0   19 13                       32 11 9 9 1   2     0   0   19 13                 32
1123169 1123169 MA Suffolk   school 2502790 35   Boston 250279000344 350374 Winship Elementary   Regular School No Elementary PK 05 2017   grade_4 10 9 15 0   2     1   1   20 18                       38 10 9 15 0   2     1   1   20 18                 38
1123180 1123180 MA Suffolk   school 2502790 35   Boston 250279002689 350375 Edison K-8   Regular School No Elementary PK 08 2017   grade_7 17 9 41 0   5     0   1   41 32                       73 17 9 41 0   5     0   1   41 32                 73
1123199 1123199 MA Suffolk   school 2502790 35   Boston 250279002677 350377 Higginson/Lewis K-8   Regular School No Elementary KG 08 2017   grade_6 0 9 12 0   0     0   1   14 8                       22 0 9 12 0   0     0   1   14 8                 22
1123309 1123309 MA Suffolk   school 2502790 35   Boston 250279000327 350535 The English High   Regular School No High 09 12 2017   sped_beyond_grade_12 0 9 5 0   2     0   0                             16 0 9 5 0   2     0   0                       16
1123332 1123332 MA Suffolk   school 2502790 35   Boston 250279000837 350543 Greater Egleston Community High School   Regular School No High 09 12 2017   grade_11 1 9 30 0   0     0   1   28 13                       41 1 9 30 0   0     0   1   28 13                 41
1123457 1123457 MA Suffolk   school 2502790 35   Boston 250279002848 350755 Boston Collaborative High School   Alternative School No High 07 12 2017   grade_10 3 9 14 1   0     0   0   10 17                       27 3 9 14 1   0     0   0   10 17                 27
1123708 1123708 MA Plymouth   school 2503090 44   Brockton 250309002652 440515 Brockton Champion High School   Regular School No High 09 12 2017   sped_beyond_grade_12 6 9 3 0   0     0   1                             19 6 9 3 0   0     0   1                       19
1123732 1123732 MA Norfolk   school 2503150 46   Brookline 250315000416 460005 Edith C Baker   Regular School No Elementary KG 08 2017   grade_6 36 9 5 0   16     0   8   36 38                       74 36 9 5 0   16     0   8   36 38                 74
1123780 1123780 MA Norfolk   school 2503150 46   Brookline 250315000423 460035 William H Lincoln   Regular School No Elementary KG 08 2017   grade_2 31 9 7 0   19     0   5   31 40                       71 31 9 7 0   19     0   5   31 40                 71
1123839 1123839 MA Middlesex   school 2503240 48   Burlington 250324000844 480035 Francis Wyman Elementary   Regular School No Elementary KG 05 2017   grade_1 42 9 8 1   14     0   4   36 42                       78 42 9 8 1   14     0   4   36 42                 78
1123851 1123851 MA Middlesex   school 2503240 48   Burlington 250324000426 480505 Burlington High   Regular School No High 09 12 2017   grade_10 186 9 12 1   32     0   9   112 137                       249 186 9 12 1   32     0   9   112 137                 249
1123857 1123857 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2017   grade_1 23 9 5 0   5     0   8   28 22                       50 23 9 5 0   5     0   8   28 22                 50
1123858 1123858 MA Middlesex   school 2503270 49   Cambridge 250327000435 490005 Maria L. Baldwin   Regular School No Elementary PK 05 2017   grade_2 30 9 7 0   5     0   5   33 23                       56 30 9 7 0   5     0   5   33 23                 56
1123875 1123875 MA Middlesex   school 2503270 49   Cambridge 250327000020 490007 Cambridgeport   Regular School No Elementary PK 05 2017   pre_kindergarten 28 9 4 0   6     0   6   32 21                       53 28 9 4 0   6     0   6   32 21                 53
1123896 1123896 MA Middlesex   school 2503270 49   Cambridge 250327000443 490030 Martin Luther King Jr.   Regular School No Elementary PK 05 2017   grade_5 7 9 6 0   8     0   1   12 19                       31 7 9 6 0   8     0   1   12 19                 31
1123904 1123904 MA Middlesex   school 2503270 49   Cambridge 250327000228 490035 King Open   Alternative School No Elementary PK 05 2017   grade_5 21 9 7 0   0     0   7   23 21                       44 21 9 7 0   0     0   7   23 21                 44
1123909 1123909 MA Middlesex   school 2503270 49   Cambridge 250327000444 490040 Kennedy-Longfellow   Regular School No Elementary PK 05 2017   grade_2 20 9 11 0   7     0   4   23 28                       51 20 9 11 0   7     0   4   23 28                 51
1123914 1123914 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   kindergarten 26 9 3 0   10     0   3   30 21                       51 26 9 3 0   10     0   3   30 21                 51
1123916 1123916 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   grade_1 21 9 5 0   4     0   4   23 20                       43 21 9 5 0   4     0   4   23 20                 43
1123917 1123917 MA Middlesex   school 2503270 49   Cambridge 250327000446 490045 Morse   Regular School No Elementary PK 05 2017   grade_2 13 9 5 1   7     0   7   20 22                       42 13 9 5 1   7     0   7   20 22                 42
1123926 1123926 MA Middlesex   school 2503270 49   Cambridge 250327000447 490050 Peabody   Regular School No Elementary PK 05 2017   grade_3 22 9 7 0   2     0   4   19 25                       44 22 9 7 0   2     0   4   19 25                 44
1123930 1123930 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   kindergarten 15 9 2 0   8     0   5   25 14                       39 15 9 2 0   8     0   5   25 14                 39
1123933 1123933 MA Middlesex   school 2503270 49   Cambridge 250327000442 490065 John M Tobin   Regular School No Elementary PK 05 2017   grade_2 7 9 7 0   11     0   6   18 22                       40 7 9 7 0   11     0   6   18 22                 40
1124065 1124065 MA Middlesex   school 2503510 56   Chelmsford 250351000478 560310 McCarthy Middle School   Regular School No Middle 05 08 2017   grade_5 162 9 11 0   32     2   2   118 100                       218 162 9 11 0   32     2   2   118 100                 218
1124082 1124082 MA Suffolk   school 2503540 57   Chelsea 250354000847 570025 William A Berkowitz Elementary   Regular School No Elementary 01 04 2017   grade_4 11 9 113 0   1     0   2   69 67                       136 11 9 113 0   1     0   2   69 67                 136
1124102 1124102 MA Suffolk   school 2503540 57   Chelsea 250354001772 570045 Eugene Wright Science and Technology Academy   Regular School No Middle 05 08 2017   grade_8 7 9 91 0   2     0   1   66 44                       110 7 9 91 0   2     0   1   66 44                 110
1124105 1124105 MA Suffolk   school 2503540 57   Chelsea 250354001158 570050 Clark Avenue School   Regular School No Middle 05 08 2017   grade_6 6 9 128 1   1     0   2   87 60                       147 6 9 128 1   1     0   2   87 60                 147
1124111 1124111 MA Suffolk   school 2503540 57   Chelsea 250354001776 570055 Joseph A. Browne School   Regular School No Middle 05 08 2017   grade_7 5 9 115 0   4     0   0   67 66                       133 5 9 115 0   4     0   0   67 66                 133
1124128 1124128 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2017   kindergarten 52 9 31 0   0     0   6   46 52                       98 52 9 31 0   0     0   6   46 52                 98
1124157 1124157 MA Hampden   school 2503660 61   Chicopee 250366000502 610022 Litwin   Regular School No Elementary KG 05 2017   grade_3 63 9 43 0   0     0   1   69 47                       116 63 9 43 0   0     0   1   69 47                 116
1124194 1124194 MA Hampden   school 2503660 61   Chicopee 250366000722 610310 Dupont Middle   Regular School No Middle 06 08 2017   grade_7 127 9 93 0   0     0   7   138 98                       236 127 9 93 0   0     0   7   138 98                 236
1124199 1124199 MA Hampden   school 2503660 61   Chicopee 250366000496 610505 Chicopee High   Regular School No High 09 12 2017   grade_11 146 9 87 0   9     1   3   115 140                       255 146 9 87 0   9     1   3   115 140                 255
1124205 1124205 MA Hampden   school 2503660 61   Chicopee 250366000495 610510 Chicopee Comprehensive High School   Regular School No High 09 12 2017   grade_12 248 9 77 1   10     3   7   207 148                       355 248 9 77 1   10     3   7   207 148                 355
1124329 1124329 MA Essex   school 2503990 71   Danvers 250399000529 710505 Danvers High   Regular School No High 09 12 2017   grade_10 218 9 15 0   6     0   3   124 127                       251 218 9 15 0   6     0   3   124 127                 251
1124451 1124451 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2017   kindergarten 64 9 6 0   5     0   0   40 44                       84 64 9 6 0   5     0   0   40 44                 84
1124455 1124455 MA Middlesex   school 2504320 79   Dracut 250432000578 790035 Brookside Elementary   Regular School No Elementary KG 05 2017   grade_4 63 9 8 0   4     0   1   46 39                       85 63 9 8 0   4     0   1   46 39                 85
1124465 1124465 MA Middlesex   school 2504320 79   Dracut 250432001625 790410 Justus C. Richardson Middle School   Regular School No Middle 06 08 2017   grade_6 221 9 25 1   17     0   4   149 128                       277 221 9 25 1   17     0   4   149 128                 277
1124472 1124472 MA Middlesex   school 2504320 79   Dracut 250432000579 790505 Dracut Senior High   Regular School No High 09 12 2017   grade_12 148 9 13 0   11     2   4   90 97                       187 148 9 13 0   11     2   4   90 97                 187
1124581 1124581 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2017   grade_2 65 9 4 0   2     0   0   38 42                       80 65 9 4 0   2     0   0   38 42                 80
1124619 1124619 MA Middlesex   school 2504770 93   Everett 250477000631 930010 Sumner G. Whittier School   Regular School No Elementary KG 08 2017   grade_1 11 9 40 1   7     0   1   25 44                       69 11 9 40 1   7     0   1   25 44                 69
1124628 1124628 MA Middlesex   school 2504770 93   Everett 250477002118 930015 Webster School   Regular School No Elementary PK 04 2017   kindergarten 30 9 29 0   3     0   0   45 26                       71 30 9 29 0   3     0   0   45 26                 71
1124723 1124723 MA Bristol   school 2504830 95   Fall River 250483002644 950009 Carlton M. Viveiros Elementary School   Regular School No Elementary KG 05 2017   grade_2 61 9 32 0   7     0   15   71 53                       124 61 9 32 0   7     0   15   71 53                 124

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